eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_UTILITIES_PVT dependencies on BIS_UTILITIES_PVT

Line 1: PACKAGE BODY BIS_UTILITIES_PVT AS

1: PACKAGE BODY BIS_UTILITIES_PVT AS
2: /* $Header: BISVUTLB.pls 120.1 2005/12/28 06:06:51 ashankar noship $ */
3: --
4: G_IMG_SRC_DIR CONSTANT VARCHAR2(100) := '/OA_MEDIA/';
5:

Line 162: l_str := icx_util.getPrompt( BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID

158:
159: l_str varchar2(32000);
160: begin
161: --
162: l_str := icx_util.getPrompt( BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
163: , p_region_code
164: , BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
165: , p_attribute_code
166: );

Line 164: , BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID

160: begin
161: --
162: l_str := icx_util.getPrompt( BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
163: , p_region_code
164: , BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID
165: , p_attribute_code
166: );
167:
168: if (l_str is null or Length(l_str)=0) then

Line 301: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME

297: )
298: RETURN VARCHAR2
299: IS
300: BEGIN
301: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME
302: , p_message_name
303: );
304: RETURN FND_MESSAGE.get;
305: END Get_FND_Message;

Line 316: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME

312: )
313: RETURN VARCHAR2
314: IS
315: BEGIN
316: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME
317: , p_message_name
318: );
319: FND_MESSAGE.set_token(p_msg_param1, p_msg_param1_val);
320: RETURN FND_MESSAGE.get;

Line 334: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME

330: )
331: RETURN VARCHAR2
332: IS
333: BEGIN
334: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME
335: , p_message_name
336: );
337: FND_MESSAGE.set_token(p_msg_param1, p_msg_param1_val);
338: FND_MESSAGE.set_token(p_msg_param2, p_msg_param2_val);

Line 355: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME

351: )
352: RETURN VARCHAR2
353: IS
354: BEGIN
355: FND_MESSAGE.set_name( BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME
356: , p_message_name
357: );
358: FND_MESSAGE.set_token(p_msg_param1, p_msg_param1_val);
359: FND_MESSAGE.set_token(p_msg_param2, p_msg_param2_val);

Line 381: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);

377: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
378: --
379: BEGIN
380: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
381: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);
382:
383: l_error_rec.Error_Msg_ID := NULL;
384: l_error_rec.Error_Msg_Name := p_error_msg_name;
385: l_error_rec.Error_proc_Name := p_error_proc_name;

Line 412: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);

408: --
409: BEGIN
410:
411: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
412: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);
413: fnd_message.set_token(p_token1, p_value1);
414:
415: -- mdamle 08/06/2003 - Added token and values
416: l_error_rec.Error_Token1 := p_token1;

Line 451: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);

447: --
448: BEGIN
449:
450: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
451: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);
452: fnd_message.set_token(p_token1, p_value1);
453: fnd_message.set_token(p_token2, p_value2);
454:
455: -- mdamle 08/06/2003 - Added token and values

Line 494: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);

490: --
491: BEGIN
492:
493: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
494: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);
495: fnd_message.set_token(p_token1, p_value1);
496: fnd_message.set_token(p_token2, p_value2);
497: fnd_message.set_token(p_token3, p_value3);
498:

Line 554: BIS_UTILITIES_PVT.Add_Error_Message

550: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
551: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
552: l_return_status VARCHAR2(32000);
553: BEGIN
554: BIS_UTILITIES_PVT.Add_Error_Message
555: ( p_error_msg_name
556: , p_error_msg_level
557: , p_error_proc_name
558: , p_error_type

Line 581: BIS_UTILITIES_PVT.Add_Error_Message

577: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579: l_return_status VARCHAR2(32000);
580: BEGIN
581: BIS_UTILITIES_PVT.Add_Error_Message
582: ( p_error_msg_name
583: , p_error_msg_level
584: , p_error_proc_name
585: , p_error_type

Line 612: BIS_UTILITIES_PVT.Add_Error_Message

608: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
609: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
610: l_return_status VARCHAR2(32000);
611: BEGIN
612: BIS_UTILITIES_PVT.Add_Error_Message
613: ( p_error_msg_name
614: , p_error_msg_level
615: , p_error_proc_name
616: , p_error_type

Line 647: BIS_UTILITIES_PVT.Add_Error_Message

643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
644: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
645: l_return_status VARCHAR2(32000);
646: BEGIN
647: BIS_UTILITIES_PVT.Add_Error_Message
648: ( p_error_msg_name
649: , p_error_msg_level
650: , p_error_proc_name
651: , p_error_type

Line 679: BIS_UTILITIES_PVT.Add_Error_Message

675: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
676: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
677: l_return_status VARCHAR2(32000);
678: BEGIN
679: BIS_UTILITIES_PVT.Add_Error_Message
680: ( p_error_msg_id
681: , p_error_description
682: , p_error_proc_name
683: , p_error_type

Line 743: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();

739: l_bot_inner_edge_img_src VARCHAR2(1000);
740: l_bot_outer_edge_img_src VARCHAR2(1000);
741: BEGIN
742: --
743: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();
744: IF(l_swan_enabled)THEN
745: l_left_flat_image_src := '';
746: l_top_outer_edge_img_src := '';
747: l_right_flat_edge_img_src := '';

Line 903: || BIS_UTILITIES_PVT.G_TABLE_LEFT_MARGIN_PERCENT

899: );
900: htp.tableRowOpen;
901: htp.tableData( crowspan => p_num_row + 1
902: , cattributes => 'width="'
903: || BIS_UTILITIES_PVT.G_TABLE_LEFT_MARGIN_PERCENT
904: || '%"'
905: );
906: htp.tableData(ccolspan => p_num_col);
907: htp.tableData( crowspan => p_num_row + 1

Line 909: || BIS_UTILITIES_PVT.G_TABLE_RIGHT_MARGIN_PERCENT

905: );
906: htp.tableData(ccolspan => p_num_col);
907: htp.tableData( crowspan => p_num_row + 1
908: , cattributes => 'width="'
909: || BIS_UTILITIES_PVT.G_TABLE_RIGHT_MARGIN_PERCENT
910: || '%"'
911: );
912: htp.tableRowClose;
913: end tableOpen;

Line 950: || BIS_UTILITIES_PVT.Get_FND_Message

946:
947: htp.p('function ' || G_FUNCTION_SUBMIT_FORM_DELETE || '()
948: {
949: if (confirm("'
950: || BIS_UTILITIES_PVT.Get_FND_Message
951: ( p_message_name => 'BIS_CONFIRM_DELETE_MESSAGE' )
952: || '"))
953: {document.'
954: || p_form_name

Line 1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE

1538: end if;
1539:
1540: l_str := l_rec.display_name;
1541:
1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1544: l_str := '&'||'nbsp';
1545: end if;
1546:

Line 1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then

1539:
1540: l_str := l_rec.display_name;
1541:
1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1544: l_str := '&'||'nbsp';
1545: end if;
1546:
1547: -- we have a separator line in between columns

Line 1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE

1647: , ctext => l_rec.display_name
1648: );
1649: end if;
1650:
1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1653: l_str := '&'||'nbsp';
1654: end if;
1655:

Line 1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then

1648: );
1649: end if;
1650:
1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1653: l_str := '&'||'nbsp';
1654: end if;
1655:
1656: -- l_str := 'xx';

Line 2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE

1996: return VARCHAR2
1997: is
1998: begin
1999:
2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE
2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then
2002: return htf.tableData( cvalue => '&'||'nbsp'
2003: , calign => p_align
2004: , crowspan => p_rowspan

Line 2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then

1997: is
1998: begin
1999:
2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE
2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then
2002: return htf.tableData( cvalue => '&'||'nbsp'
2003: , calign => p_align
2004: , crowspan => p_rowspan
2005: , ccolspan => p_colspan

Line 2260: BIS_UTILITIES_PVT.G_DEBUG_FLAG := 0;

2256:
2257: PROCEDURE Set_Debug_Flag
2258: IS
2259: BEGIN
2260: BIS_UTILITIES_PVT.G_DEBUG_FLAG := 0;
2261: END Set_Debug_Flag;
2262:
2263: FUNCTION Convert_to_ID
2264: ( p_id NUMBER

Line 2341: BIS_UTILITIES_PVT.Add_Error_Message

2337:
2338: EXCEPTION
2339: when others then
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: BIS_UTILITIES_PVT.Add_Error_Message
2342: ( p_error_msg_id => SQLCODE
2343: , p_error_description => SQLERRM
2344: , p_error_proc_name => 'Retrieve_User_Target_Level'
2345: );

Line 2385: BIS_UTILITIES_PVT.Add_Error_Message

2381:
2382: EXCEPTION
2383: when others then
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2385: BIS_UTILITIES_PVT.Add_Error_Message
2386: ( p_error_msg_id => SQLCODE
2387: , p_error_description => SQLERRM
2388: , p_error_proc_name => 'Retrieve_User_Perf_Measure'
2389: );

Line 2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR

2585: l_time_Seq NUMBER;
2586: BEGIN
2587: x_dim_values_rec := p_dim_Values_rec;
2588: IF (p_sequence_dir = 'N') THEN
2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2591: THEN
2592: OPEN c_seq(p_dim_values_rec.target_level_id
2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

2586: BEGIN
2587: x_dim_values_rec := p_dim_Values_rec;
2588: IF (p_sequence_dir = 'N') THEN
2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2591: THEN
2592: OPEN c_seq(p_dim_values_rec.target_level_id
2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2594: ,p_TargetLevelName => NULL));

Line 2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2591: THEN
2592: OPEN c_seq(p_dim_values_rec.target_level_id
2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2594: ,p_TargetLevelName => NULL));
2595: FETCH c_seq INTO l_org_seq;
2596: CLOSE c_seq;
2597: OPEN c_seq(p_dim_values_rec.target_level_id

Line 2598: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

2594: ,p_TargetLevelName => NULL));
2595: FETCH c_seq INTO l_org_seq;
2596: CLOSE c_seq;
2597: OPEN c_seq(p_dim_values_rec.target_level_id
2598: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2599: ,p_TargetLevelName => NULL));
2600: FETCH c_seq INTO l_time_seq;
2601: CLOSE c_seq;
2602: x_dim_values_rec := p_dim_Values_rec;

Line 2707: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

2703: END IF;
2704: IF (p_Sequence_dir = 'R') THEN
2705: --Get the sequence number for Org and Time Dimensions
2706: OPEN c_seq(p_dim_values_rec.target_level_id
2707: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2708: ,p_TargetLevelName => NULL));
2709: FETCH c_seq INTO l_org_seq;
2710: CLOSE c_seq;
2711: OPEN c_seq(p_dim_values_rec.target_level_id

Line 2712: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

2708: ,p_TargetLevelName => NULL));
2709: FETCH c_seq INTO l_org_seq;
2710: CLOSE c_seq;
2711: OPEN c_seq(p_dim_values_rec.target_level_id
2712: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2713: ,p_TargetLevelName => NULL));
2714: FETCH c_seq INTO l_time_seq;
2715: CLOSE c_seq;
2716: x_dim_values_rec := p_dim_Values_rec;

Line 2802: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id

2798: IF (p_sequence_dir = 'N') THEN
2799: IF ((p_Dim_level_rec.org_level_id <> FND_API.G_MISS_NUM) OR
2800: (p_dim_level_Rec.time_level_id <> FND_API.G_MISS_NUM)) THEN
2801: OPEN c_seq(x_dim_level_rec.target_level_id
2802: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id
2803: ,p_TargetLevelName => NULL));
2804: FETCH c_seq INTO l_org_seq;
2805: CLOSE c_seq;
2806: OPEN c_seq(x_dim_level_Rec.target_level_id

Line 2807: , BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_Rec.target_level_id

2803: ,p_TargetLevelName => NULL));
2804: FETCH c_seq INTO l_org_seq;
2805: CLOSE c_seq;
2806: OPEN c_seq(x_dim_level_Rec.target_level_id
2807: , BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_Rec.target_level_id
2808: ,p_TargetLevelName => NULL));
2809: FETCH c_seq INTO l_time_seq;
2810: CLOSE c_seq;
2811: x_dim_level_rec := p_dim_level_rec;

Line 2891: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id

2887: END IF;
2888: END IF;
2889: IF (p_sequence_dir = 'R' ) THEN
2890: OPEN c_seq(x_dim_level_rec.target_level_id
2891: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id
2892: ,p_TargetLevelName => NULL));
2893: FETCH c_seq INTO l_org_seq;
2894: CLOSE c_seq;
2895: OPEN c_seq(x_dim_level_Rec.target_level_id

Line 2896: , BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_Rec.target_level_id

2892: ,p_TargetLevelName => NULL));
2893: FETCH c_seq INTO l_org_seq;
2894: CLOSE c_seq;
2895: OPEN c_seq(x_dim_level_Rec.target_level_id
2896: , BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_Rec.target_level_id
2897: ,p_TargetLevelName => NULL));
2898: FETCH c_seq INTO l_time_seq;
2899: CLOSE c_seq;
2900: x_dim_level_rec := p_dim_level_rec;

Line 2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR

2992: l_time_Seq NUMBER;
2993: BEGIN
2994: x_dim_values_rec := p_Dim_values_rec;
2995: IF (p_sequence_dir = 'N') THEN
2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2998: THEN
2999: OPEN c_seq(p_dim_values_rec.target_level_id
3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

2993: BEGIN
2994: x_dim_values_rec := p_Dim_values_rec;
2995: IF (p_sequence_dir = 'N') THEN
2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2998: THEN
2999: OPEN c_seq(p_dim_values_rec.target_level_id
3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3001: , p_TargetLevelName => NULL));

Line 3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2998: THEN
2999: OPEN c_seq(p_dim_values_rec.target_level_id
3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3001: , p_TargetLevelName => NULL));
3002: FETCH c_seq INTO l_org_seq;
3003: CLOSE c_seq;
3004: OPEN c_seq(p_dim_values_rec.target_level_id

Line 3005: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

3001: , p_TargetLevelName => NULL));
3002: FETCH c_seq INTO l_org_seq;
3003: CLOSE c_seq;
3004: OPEN c_seq(p_dim_values_rec.target_level_id
3005: ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3006: ,p_TargetLevelName => NULL));
3007: FETCH c_seq INTO l_time_seq;
3008: CLOSE c_seq;
3009: x_dim_values_rec := p_dim_Values_rec;

Line 3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))

3093: BEGIN
3094: x_dim_values_rec := p_Dim_values_rec;
3095: IF (p_sequence_dir = 'N') THEN
3096:
3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))
3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
3099: THEN
3100: OPEN c_seq(p_dim_values_rec.target_level_id
3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

3094: x_dim_values_rec := p_Dim_values_rec;
3095: IF (p_sequence_dir = 'N') THEN
3096:
3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))
3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
3099: THEN
3100: OPEN c_seq(p_dim_values_rec.target_level_id
3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3102: ,p_TargetLevelName => NULL));

Line 3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))
3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
3099: THEN
3100: OPEN c_seq(p_dim_values_rec.target_level_id
3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3102: ,p_TargetLevelName => NULL));
3103: FETCH c_seq INTO l_org_seq;
3104: CLOSE c_seq;
3105: -- OPEN c_seq(p_dim_values_rec.target_level_id

Line 3106: -- ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_i,p_TargetLevelName => NULL));

3102: ,p_TargetLevelName => NULL));
3103: FETCH c_seq INTO l_org_seq;
3104: CLOSE c_seq;
3105: -- OPEN c_seq(p_dim_values_rec.target_level_id
3106: -- ,BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_i,p_TargetLevelName => NULL));
3107: -- FETCH c_seq INTO l_time_seq;
3108: -- CLOSE c_seq;
3109: x_dim_values_rec := p_dim_Values_rec;
3110: IF (l_org_Seq = 1) THEN

Line 3143: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_values_rec.target_level_id

3139: END IF;
3140: -- mdamle 06/29/2001 - Bug#1842840 - Added the 'R' condition
3141: IF (p_sequence_dir = 'R' ) THEN
3142: OPEN c_seq(x_dim_values_rec.target_level_id
3143: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_values_rec.target_level_id
3144: ,p_TargetLevelName => NULL));
3145: FETCH c_seq INTO l_org_seq;
3146: CLOSE c_seq;
3147: x_dim_values_rec := p_dim_values_rec;

Line 3357: l_dim_name := BIS_UTILITIES_PVT.GET_INV_LOC_DIMENSION_NAME_SRC (p_source => l_source);

3353: OPEN c_dim_name;
3354: FETCH c_dim_name INTO l_Source;
3355: CLOSE c_dim_name;
3356: END IF;
3357: l_dim_name := BIS_UTILITIES_PVT.GET_INV_LOC_DIMENSION_NAME_SRC (p_source => l_source);
3358: RETURN l_dim_name;
3359:
3360: EXCEPTION
3361: WHEN OTHERS THEN

Line 3658: BIS_UTILITIES_PVT.Add_Error_Message

3654: EXCEPTION
3655: when others then
3656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3657:
3658: BIS_UTILITIES_PVT.Add_Error_Message
3659: ( p_error_msg_id => SQLCODE
3660: , p_error_description => SQLERRM
3661: , p_error_proc_name => 'IS_TOTAL_DIMLEVEL'
3662: );

Line 3707: l_total_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name => p_dim_short_name

3703: CLOSE c_dim_name;
3704: end if;
3705: -----------------
3706: -- 2617369, use newly created get_total_dimlevel_name_src
3707: l_total_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name => p_dim_short_name
3708: ,p_source => l_source);
3709: RETURN l_total_name;
3710:
3711: END GET_TOTAL_DIMLEVEL_NAME;

Line 3858: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL

3854: BEGIN
3855:
3856: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_from ' );
3857:
3858: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
3859: (
3860: p_DimLevelId => p_time_level_id
3861: , p_DimLevelShortName => p_time_level_sh_name -- l_level_name
3862: );

Line 3868: bis_utilities_pvt.Get_Org_Info_Based_On_Source

3864: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
3865:
3866:
3867: if ( l_source = 'OLTP' ) then
3868: bis_utilities_pvt.Get_Org_Info_Based_On_Source
3869: ( p_source => l_source,
3870: p_org_level_id => p_org_level_id,
3871: p_org_level_short_name => p_org_level_short_name,
3872: x_org_level_id => l_org_level_id,

Line 3883: -- bis_utilities_pvt.

3879: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_FROM : source can be only either OLTP or EDW ' );
3880: end if;
3881:
3882:
3883: -- bis_utilities_pvt.
3884: Get_Start_End_Dates
3885: ( p_source => l_source,
3886: p_view_name => p_table_name,
3887: p_id_col_name => p_id_col_name,

Line 3903: -- bis_utilities_pvt.

3899:
3900: l_date := l_start_date + l_num;
3901:
3902:
3903: -- bis_utilities_pvt.
3904: Get_Time_Level_Value
3905: ( p_source => l_source ,
3906: p_table_name => p_table_name,
3907: p_value_col_name => p_value_col_name,

Line 3918: -- bis_utilities_pvt.

3914:
3915:
3916: if ( l_time_value is null ) then
3917:
3918: -- bis_utilities_pvt.
3919: Get_Min_Max_Start_End_Dates
3920: ( p_source => l_source,
3921: p_view_name => p_table_name,
3922: p_Org_Level_ID => l_Org_Level_ID,

Line 3929: bis_utilities_pvt.Get_Time_Level_Value

3925: x_max_end_date => l_max_end_date
3926: );
3927:
3928:
3929: bis_utilities_pvt.Get_Time_Level_Value
3930: ( p_source => l_source,
3931: p_table_name => p_table_name,
3932: p_value_col_name => p_value_col_name,
3933: p_Org_Level_ID => l_Org_Level_ID,

Line 3952: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_FROM 1000 : '||sqlerrm);

3948:
3949: Exception
3950: when others then
3951: BIS_UTILITIES_PUB.put_line(p_text =>'GET_TIME_FROM : SQL Statement is '|| l_selectStmt);
3952: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_FROM 1000 : '||sqlerrm);
3953:
3954: END GET_TIME_FROM;
3955:
3956:

Line 4006: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL

4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;
4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;
4004:
4005:
4006: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
4007: (
4008: p_DimLevelId => p_time_level_id
4009: , p_DimLevelShortName => p_time_level_sh_name -- l_level_name
4010: );

Line 4014: bis_utilities_pvt.Get_Org_Info_Based_On_Source

4010: );
4011:
4012:
4013: if ( l_source = 'OLTP' ) then
4014: bis_utilities_pvt.Get_Org_Info_Based_On_Source
4015: ( p_source => l_source,
4016: p_org_level_id => p_org_level_id,
4017: p_org_level_short_name => p_org_level_short_name,
4018: x_org_level_id => l_org_level_id,

Line 4032: bis_utilities_pvt.Get_Start_End_Dates

4028: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
4029:
4030:
4031:
4032: bis_utilities_pvt.Get_Start_End_Dates
4033: ( p_source => l_source,
4034: p_view_name => p_table_name,
4035: p_id_col_name => p_id_col_name,
4036: p_id_value_name => p_id,

Line 4051: bis_utilities_pvt.Get_Time_Level_Value

4047:
4048: l_date := l_start_date + l_num;
4049:
4050:
4051: bis_utilities_pvt.Get_Time_Level_Value
4052: ( p_source => l_source ,
4053: p_table_name => p_table_name,
4054: p_value_col_name => p_value_col_name,
4055: p_Org_Level_ID => l_Org_Level_ID,

Line 4065: bis_utilities_pvt.Get_Min_Max_Start_End_Dates

4061:
4062:
4063: if ( l_time_value is null ) then
4064:
4065: bis_utilities_pvt.Get_Min_Max_Start_End_Dates
4066: ( p_source => l_source,
4067: p_view_name => p_table_name,
4068: p_Org_Level_ID => l_Org_Level_ID,
4069: p_org_level_short_name => l_org_level_short_name,

Line 4075: bis_utilities_pvt.Get_Time_Level_Value

4071: x_max_end_date => l_max_end_date
4072: );
4073:
4074:
4075: bis_utilities_pvt.Get_Time_Level_Value
4076: ( p_source => l_source,
4077: p_table_name => p_table_name,
4078: p_value_col_name => p_value_col_name,
4079: p_Org_Level_ID => l_Org_Level_ID,

Line 4098: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_TO : '||sqlerrm);

4094:
4095: Exception
4096: when others then
4097: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4098: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_TO : '||sqlerrm);
4099:
4100: END GET_TIME_TO;
4101:
4102:

Line 4832: BIS_UTILITIES_PVT.Add_Error_Message

4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: l_error_tbl := x_error_tbl;
4832: BIS_UTILITIES_PVT.Add_Error_Message
4833: ( p_error_table => l_error_tbl
4834: , p_error_msg_id => SQLCODE
4835: , p_error_description => SQLERRM
4836: , x_error_table => x_error_Tbl

Line 4845: BIS_UTILITIES_PVT.Add_Error_Message

4841: );
4842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: l_error_tbl := x_error_tbl;
4845: BIS_UTILITIES_PVT.Add_Error_Message
4846: ( p_error_table => l_error_tbl
4847: , p_error_msg_id => SQLCODE
4848: , p_error_description => SQLERRM
4849: , x_error_table => x_error_Tbl

Line 4858: BIS_UTILITIES_PVT.Add_Error_Message

4854: );
4855: WHEN OTHERS THEN
4856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4857: l_error_tbl := x_error_tbl;
4858: BIS_UTILITIES_PVT.Add_Error_Message
4859: ( p_error_table => l_error_tbl
4860: , p_error_msg_id => SQLCODE
4861: , p_error_description => SQLERRM
4862: , x_error_table => x_error_Tbl

Line 4924: BIS_UTILITIES_PVT.Add_Error_Message

4920: EXCEPTION
4921: WHEN FND_API.G_EXC_ERROR THEN
4922: x_return_status := FND_API.G_RET_STS_ERROR;
4923: l_error_tbl := x_error_tbl;
4924: BIS_UTILITIES_PVT.Add_Error_Message
4925: ( p_error_table => l_error_tbl
4926: , p_error_msg_id => SQLCODE
4927: , p_error_description => SQLERRM
4928: , x_error_table => x_error_Tbl

Line 4937: BIS_UTILITIES_PVT.Add_Error_Message

4933: );
4934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936: l_error_tbl := x_error_tbl;
4937: BIS_UTILITIES_PVT.Add_Error_Message
4938: ( p_error_table => l_error_tbl
4939: , p_error_msg_id => SQLCODE
4940: , p_error_description => SQLERRM
4941: , x_error_table => x_error_Tbl

Line 4950: BIS_UTILITIES_PVT.Add_Error_Message

4946: );
4947: WHEN OTHERS THEN
4948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4949: l_error_tbl := x_error_tbl;
4950: BIS_UTILITIES_PVT.Add_Error_Message
4951: ( p_error_table => l_error_tbl
4952: , p_error_msg_id => SQLCODE
4953: , p_error_description => SQLERRM
4954: , x_error_table => x_error_Tbl

Line 5243: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.get_debug_mode_profile: '|| SQLERRM;

5239:
5240: EXCEPTION
5241: WHEN OTHERS THEN
5242: x_return_status := FND_API.G_RET_STS_ERROR;
5243: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.get_debug_mode_profile: '|| SQLERRM;
5244: x_is_debug_mode := FALSE;
5245: END get_debug_mode_profile;
5246:
5247:

Line 5270: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.set_debug_log_flag: '|| SQLERRM;

5266:
5267: EXCEPTION
5268: WHEN OTHERS THEN
5269: x_return_status := FND_API.G_RET_STS_ERROR;
5270: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.set_debug_log_flag: '|| SQLERRM;
5271: END set_debug_log_flag;
5272:
5273:
5274:

Line 5364: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Directory for log file is null';

5360: l_default_log_name := get_default_log_name; -- () || '.log';
5361:
5362: IF ( (l_default_dir_name IS NULL ) AND (p_dir_name IS NULL)) THEN
5363: x_return_status := FND_API.G_RET_STS_ERROR;
5364: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Directory for log file is null';
5365: RETURN;
5366: END IF;
5367:
5368: IF ( (l_default_log_name IS NULL ) AND (p_file_name IS NULL)) THEN

Line 5370: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Log file name is null';

5366: END IF;
5367:
5368: IF ( (l_default_log_name IS NULL ) AND (p_file_name IS NULL)) THEN
5369: x_return_status := FND_API.G_RET_STS_ERROR;
5370: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Log file name is null';
5371: RETURN;
5372: END IF;
5373:
5374: l_default_dir_name := NVL(p_dir_name, l_default_dir_name) ;

Line 5386: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.open_debug_log: '|| SQLERRM;

5382:
5383: EXCEPTION
5384: WHEN OTHERS THEN
5385: x_return_status := FND_API.G_RET_STS_ERROR;
5386: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.open_debug_log: '|| SQLERRM;
5387:
5388: END open_debug_log;
5389:
5390:

Line 5407: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.close_debug_log: '|| SQLERRM;

5403:
5404: EXCEPTION
5405: WHEN OTHERS THEN
5406: x_return_status := FND_API.G_RET_STS_ERROR;
5407: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.close_debug_log: '|| SQLERRM;
5408: END close_debug_log;
5409:
5410:
5411:

Line 5417: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;

5413: IS
5414: l_is_debug_on BOOLEAN := FALSE;
5415: BEGIN
5416:
5417: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5418:
5419: IF (l_is_debug_on) THEN
5420: IF (
5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

Line 5439: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;

5435: IS
5436: l_is_debug_on BOOLEAN := FALSE;
5437: BEGIN
5438:
5439: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5440:
5441: IF (l_is_debug_on) THEN
5442: IF (
5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

Line 5524: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => l_source);

5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: CLOSE c_dims;
5523: IF (l_source = 'EDW') THEN
5524: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => l_source);
5525: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshort_name
5526: ,p_source => l_source);
5527: IF ((l_dimshort_name = l_dimshortname_time) AND
5528: (l_dimlevel_name <> l_lvlshortname_total)) THEN

Line 5525: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshort_name

5521: END IF;
5522: CLOSE c_dims;
5523: IF (l_source = 'EDW') THEN
5524: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => l_source);
5525: l_lvlshortname_total := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_SRC(p_dim_short_name=>l_dimshort_name
5526: ,p_source => l_source);
5527: IF ((l_dimshort_name = l_dimshortname_time) AND
5528: (l_dimlevel_name <> l_lvlshortname_total)) THEN
5529: RETURN TRUE;

Line 5534: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_Source => l_source);

5530: ELSE
5531: RETURN FALSE;
5532: END IF;
5533: ELSE
5534: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_Source => l_source);
5535: IF (l_dimshort_name = l_dimshortname_time) THEN
5536: RETURN TRUE;
5537: ELSE
5538: RETURN FALSE;

Line 5643: END BIS_UTILITIES_PVT;

5639: RETURN l_swan_enabled;
5640:
5641: END checkSWANEnabled;
5642:
5643: END BIS_UTILITIES_PVT;