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.OE_MSG_PUB dependencies on OE_DEBUG_PUB

Line 21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

17:
18: PROCEDURE Initialize
19: IS
20: --
21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22: --
23: BEGIN
24:
25: FND_MSG_PUB.Initialize;

Line 35: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;

31: G_msg_context_count := 0;
32: G_Msg_Context_index := 0;
33:
34: IF l_debug_level > 0 THEN
35: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.INITIALIZE' , 1 ) ;
36: END IF;
37: EXCEPTION
38: WHEN OTHERS THEN
39: IF l_debug_level > 0 THEN

Line 40: oe_debug_pub.add('Error in procedure Initialize ' || sqlerrm);

36: END IF;
37: EXCEPTION
38: WHEN OTHERS THEN
39: IF l_debug_level > 0 THEN
40: oe_debug_pub.add('Error in procedure Initialize ' || sqlerrm);
41: END IF;
42: END;
43:
44: PROCEDURE Set_Process_Activity(

Line 48: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

44: PROCEDURE Set_Process_Activity(
45: p_process_activity IN NUMBER DEFAULT NULL)
46: IS
47: --
48: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
49: --
50: BEGIN
51:
52: G_process_activity := p_process_activity;

Line 56: oe_debug_pub.add('Error in procedure Set_Process_Activity ' || sqlerrm);

52: G_process_activity := p_process_activity;
53: EXCEPTION
54: WHEN OTHERS THEN
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add('Error in procedure Set_Process_Activity ' || sqlerrm);
57: END IF;
58: END Set_Process_Activity;
59:
60: PROCEDURE Set_Msg_Context (

Line 80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

76: -- ,p_process_activity IN NUMBER DEFAULT NULL
77: )
78: IS
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
83: -- Increment message context count
84: G_msg_context_count := G_msg_context_count + 1;

Line 203: oe_debug_pub.add('Error in procedure Set_Msg_Context ' || sqlerrm);

199: G_msg_context_tbl(G_msg_context_count).PROCESS_ACTIVITY := G_process_activity;
200: EXCEPTION
201: WHEN OTHERS THEN
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add('Error in procedure Set_Msg_Context ' || sqlerrm);
204: END IF;
205: END;
206:
207: PROCEDURE Update_Msg_Context (

Line 225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
223: ) IS
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: Begin
228:
229: -- if G_msg_context_tbl(G_msg_context_count).ENTITY_CODE = p_entity_code then

Line 287: oe_debug_pub.add('Error in procedure Update_Msg_Context ' || sqlerrm);

283: -- end if;
284: EXCEPTION
285: WHEN OTHERS THEN
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add('Error in procedure Update_Msg_Context ' || sqlerrm);
288: END IF;
289: End Update_Msg_Context;
290:
291: PROCEDURE Reset_Msg_Context (p_entity_code IN VARCHAR2)

Line 294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

290:
291: PROCEDURE Reset_Msg_Context (p_entity_code IN VARCHAR2)
292: IS
293: --
294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
295: --
296: BEGIN
297: if G_msg_context_count > 0 then
298: if G_msg_context_tbl.EXISTS(G_msg_context_count) AND

Line 307: oe_debug_pub.add('Error in procedure Reset_Msg_Context ' || sqlerrm);

303: end if;
304: EXCEPTION
305: WHEN OTHERS THEN
306: IF l_debug_level > 0 THEN
307: oe_debug_pub.add('Error in procedure Reset_Msg_Context ' || sqlerrm);
308: END IF;
309: END Reset_Msg_Context;
310:
311:

Line 326: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

322:
323: FUNCTION Count_Msg RETURN NUMBER
324: IS
325: --
326: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
327: --
328: BEGIN
329:
330: RETURN G_msg_Count;

Line 334: oe_debug_pub.add('Error in Function Count_msg ' || sqlerrm);

330: RETURN G_msg_Count;
331: EXCEPTION
332: WHEN OTHERS THEN
333: IF l_debug_level > 0 THEN
334: oe_debug_pub.add('Error in Function Count_msg ' || sqlerrm);
335: END IF;
336: END Count_Msg;
337:
338: -- PROCEDURE Count_And_Get

Line 351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

347: )
348: IS
349: l_msg_count NUMBER;
350: --
351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
352: --
353: BEGIN
354:
355: l_msg_count := Count_Msg;

Line 369: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.COUNT_AND_GET '|| L_MSG_COUNT , 3 ) ;

365:
366: p_count := l_msg_count ;
367:
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.COUNT_AND_GET '|| L_MSG_COUNT , 3 ) ;
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF l_debug_level > 0 THEN

Line 374: oe_debug_pub.add('Error in Function Count_And_Get ' || sqlerrm);

370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add('Error in Function Count_And_Get ' || sqlerrm);
375: END IF;
376: END Count_And_Get;
377:
378: -- PROCEDURE Add

Line 395: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

391: l_type VARCHAR2(30);
392: l_app_id VARCHAR2(30);
393: l_message_name VARCHAR2(30);
394: --
395: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
396: --
397: BEGIN
398:
399: -- Increment message count

Line 466: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD' , 3 ) ;

462: G_msg_tbl(G_msg_count).ORG_ID := NULL;
463: END IF;
464:
465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD' , 3 ) ;
467: END IF;
468: EXCEPTION
469: WHEN OTHERS THEN
470: IF l_debug_level > 0 THEN

Line 471: oe_debug_pub.add('Error in Procedure Add ' || sqlerrm);

467: END IF;
468: EXCEPTION
469: WHEN OTHERS THEN
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add('Error in Procedure Add ' || sqlerrm);
472: END IF;
473: END Add;
474:
475: -- PROCEDURE Add_text

Line 491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

487: ,p_type IN VARCHAR2 DEFAULT 'ERROR'
488: ,p_context_flag IN VARCHAR2 DEFAULT 'Y')
489: IS
490: --
491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
492: --
493: BEGIN
494:
495: -- Increment message count

Line 537: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD_TEXT' , 3 ) ;

533: G_msg_tbl(G_msg_count).ORG_ID := NULL;
534: END IF;
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add( 'LEAVING OE_MSG_PUB.ADD_TEXT' , 3 ) ;
538: END IF;
539: EXCEPTION
540: WHEN OTHERS THEN
541: IF l_debug_level > 0 THEN

Line 542: oe_debug_pub.add('Error in Procedure Add_text ' || sqlerrm);

538: END IF;
539: EXCEPTION
540: WHEN OTHERS THEN
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add('Error in Procedure Add_text ' || sqlerrm);
543: END IF;
544: END Add_Text;
545:
546: --

Line 570: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

566: )
567: IS
568: l_msg_index NUMBER;
569: --
570: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
571: --
572: BEGIN
573:
574: IF p_msg_index IS NULL THEN

Line 628: oe_debug_pub.add('Error in Delete_msg ' || sqlerrm);

624: END IF;
625: EXCEPTION
626: WHEN OTHERS THEN
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Error in Delete_msg ' || sqlerrm);
629: END IF;
630: END Delete_Msg;
631:
632: procedure get_msg_context(

Line 672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

668: ,x_type OUT NOCOPY VARCHAR2
669:
670: ) IS
671: --
672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
673: --
674: Begin
675: x_entity_code := G_msg_tbl(p_msg_index).ENTITY_CODE;
676: x_entity_ref := G_msg_tbl(p_msg_index).ENTITY_REF;

Line 732: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

728: )
729: IS
730: l_msg_index NUMBER := G_msg_index;
731: --
732: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
733: --
734: BEGIN
735:
736: IF p_msg_index = G_NEXT THEN

Line 781: oe_debug_pub.add('Error in Procedure Get ' || sqlerrm);

777: p_data := NULL;
778: p_msg_index_out := NULL;
779: WHEN OTHERS THEN
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add('Error in Procedure Get ' || sqlerrm);
782: END IF;
783: END Get;
784:
785: -- FUNCTION Get

Line 797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

793: IS
794: l_data VARCHAR2(2000) ;
795: l_msg_index_out NUMBER ;
796: --
797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
798: --
799: BEGIN
800:
801: Get

Line 813: oe_debug_pub.add('Error in Function Get ' || sqlerrm);

809:
810: EXCEPTION
811: WHEN OTHERS THEN
812: IF l_debug_level > 0 THEN
813: oe_debug_pub.add('Error in Function Get ' || sqlerrm);
814: END IF;
815: END Get;
816:
817: -- PROCEDURE Reset

Line 836: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

832: PROCEDURE Reset ( p_mode IN NUMBER := G_FIRST )
833: IS
834: l_procedure_name CONSTANT VARCHAR2(15):='Reset';
835: --
836: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
837: --
838: BEGIN
839:
840: IF p_mode = G_FIRST THEN

Line 865: oe_debug_pub.add('Error in Procedure Reset ' || sqlerrm);

861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF l_debug_level > 0 THEN
865: oe_debug_pub.add('Error in Procedure Reset ' || sqlerrm);
866: END IF;
867: END Reset;
868:
869: -- FUNCTION Check_Msg_Level

Line 889: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

885: ( p_message_level IN NUMBER := G_MSG_LVL_SUCCESS
886: ) RETURN BOOLEAN
887: IS
888: --
889: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
890: --
891: BEGIN
892:
893: IF G_msg_level_threshold = FND_API.G_MISS_NUM THEN

Line 912: oe_debug_pub.add('Error in Function Check_Msg_Level ' || sqlerrm);

908: RETURN p_message_level >= G_msg_level_threshold ;
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('Error in Function Check_Msg_Level ' || sqlerrm);
913: END IF;
914: END; -- Check_Msg_Level
915:
916: PROCEDURE Build_Exc_Msg

Line 924: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

920: )
921: IS
922: l_error_text VARCHAR2(2000) := p_error_text ;
923: --
924: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
925: --
926: BEGIN
927:
928: -- If p_error_text is missing use SQLERRM.

Line 952: oe_debug_pub.add('Error in Function Build_Exc_Msg ' || sqlerrm);

948: END IF;
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add('Error in Function Build_Exc_Msg ' || sqlerrm);
953: END IF;
954: END; -- Build_Exc_Msg
955:
956: PROCEDURE Add_Exc_Msg

Line 964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

960: p_context_flag IN VARCHAR2 DEFAULT 'Y'
961: )
962: IS
963: --
964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
965: --
966: BEGIN
967: Build_Exc_Msg
968: ( p_pkg_name ,

Line 976: oe_debug_pub.add('Error in Procedure Add_Exc_Msg ' || sqlerrm);

972: Add((p_context_flag));
973: EXCEPTION
974: WHEN OTHERS THEN
975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add('Error in Procedure Add_Exc_Msg ' || sqlerrm);
977: END IF;
978: END Add_Exc_Msg ;
979:
980: -- PROCEDURE Dump_Msg

Line 987: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

983: PROCEDURE Dump_Msg
984: ( p_msg_index IN NUMBER )
985: IS
986: --
987: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
988: --
989: BEGIN
990: OE_DEBUG_PUB.debug_on;
991: IF l_debug_level > 0 THEN

Line 990: OE_DEBUG_PUB.debug_on;

986: --
987: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
988: --
989: BEGIN
990: OE_DEBUG_PUB.debug_on;
991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;

Line 992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;

988: --
989: BEGIN
990: OE_DEBUG_PUB.debug_on;
991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;

Line 993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;

989: BEGIN
990: OE_DEBUG_PUB.debug_on;
991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;

Line 994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;

990: OE_DEBUG_PUB.debug_on;
991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;

Line 995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;

991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;

Line 996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;

992: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;

Line 997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;

993: oe_debug_pub.add( 'DATA = '||G_MSG_TBL ( P_MSG_INDEX ) .MESSAGE ) ;
994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;

Line 998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;

994: oe_debug_pub.add( 'ENTITY_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_CODE ) ;
995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;

Line 999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;

995: oe_debug_pub.add( 'ENTITY_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ENTITY_ID ) ;
996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;

Line 1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;

996: oe_debug_pub.add( 'HEADER_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .HEADER_ID ) ;
997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;

Line 1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;

997: oe_debug_pub.add( 'LINE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .LINE_ID ) ;
998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;

Line 1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;

998: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .ORDER_SOURCE_ID ) ;
999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;

Line 1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;

999: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_REF ) ;
1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;

Line 1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;

1000: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL ( P_MSG_INDEX ) .ORIG_SYS_DOCUMENT_LINE_REF ) ;
1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;
1008: OE_DEBUG_PUB.dumpdebug;

Line 1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;

1001: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_TYPE_ID ) ;
1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;
1008: OE_DEBUG_PUB.dumpdebug;
1009: OE_DEBUG_PUB.debug_off;

Line 1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;

1002: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_ID ) ;
1003: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .SOURCE_DOCUMENT_LINE_ID ) ;
1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;
1008: OE_DEBUG_PUB.dumpdebug;
1009: OE_DEBUG_PUB.debug_off;
1010: EXCEPTION

Line 1008: OE_DEBUG_PUB.dumpdebug;

1004: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL ( P_MSG_INDEX ) .ATTRIBUTE_CODE ) ;
1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;
1008: OE_DEBUG_PUB.dumpdebug;
1009: OE_DEBUG_PUB.debug_off;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF l_debug_level > 0 THEN

Line 1009: OE_DEBUG_PUB.debug_off;

1005: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL ( P_MSG_INDEX ) .CONSTRAINT_ID ) ;
1006: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL ( P_MSG_INDEX ) .PROCESS_ACTIVITY ) ;
1007: END IF;
1008: OE_DEBUG_PUB.dumpdebug;
1009: OE_DEBUG_PUB.debug_off;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF l_debug_level > 0 THEN
1013: oe_debug_pub.add('Error in Procedure Dump_Msg ' || sqlerrm);

Line 1013: oe_debug_pub.add('Error in Procedure Dump_Msg ' || sqlerrm);

1009: OE_DEBUG_PUB.debug_off;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF l_debug_level > 0 THEN
1013: oe_debug_pub.add('Error in Procedure Dump_Msg ' || sqlerrm);
1014: END IF;
1015: END Dump_Msg;
1016:
1017: -- PROCEDURE Dump_List

Line 1024: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1020: ( p_messages IN BOOLEAN := FALSE
1021: )
1022: IS
1023: --
1024: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1025: --
1026: BEGIN
1027:
1028: OE_DEBUG_PUB.debug_on;

Line 1028: OE_DEBUG_PUB.debug_on;

1024: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1025: --
1026: BEGIN
1027:
1028: OE_DEBUG_PUB.debug_on;
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;

Line 1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;

1026: BEGIN
1027:
1028: OE_DEBUG_PUB.debug_on;
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;

Line 1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;

1027:
1028: OE_DEBUG_PUB.debug_on;
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;
1035: OE_DEBUG_PUB.dumpdebug;

Line 1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;

1028: OE_DEBUG_PUB.debug_on;
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;
1035: OE_DEBUG_PUB.dumpdebug;
1036: OE_DEBUG_PUB.debug_off;

Line 1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;

1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;
1035: OE_DEBUG_PUB.dumpdebug;
1036: OE_DEBUG_PUB.debug_off;
1037:

Line 1035: OE_DEBUG_PUB.dumpdebug;

1031: oe_debug_pub.add( 'G_MSG_TBL.COUNT = '||G_MSG_TBL.COUNT ) ;
1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;
1035: OE_DEBUG_PUB.dumpdebug;
1036: OE_DEBUG_PUB.debug_off;
1037:
1038: IF p_messages THEN
1039:

Line 1036: OE_DEBUG_PUB.debug_off;

1032: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
1033: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
1034: END IF;
1035: OE_DEBUG_PUB.dumpdebug;
1036: OE_DEBUG_PUB.debug_off;
1037:
1038: IF p_messages THEN
1039:
1040: FOR I IN 1..G_msg_tbl.COUNT LOOP

Line 1050: oe_debug_pub.add('Error in Procedure Dump_List ' || sqlerrm);

1046: END IF;
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add('Error in Procedure Dump_List ' || sqlerrm);
1051: END IF;
1052: END Dump_List;
1053:
1054:

Line 1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1068: ,p_message_source_code IN VARCHAR2 DEFAULT 'C')
1069: IS
1070: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --
1074: begin
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'ENTER SAVE_MESSAGES' , 1 ) ;

Line 1076: oe_debug_pub.add( 'ENTER SAVE_MESSAGES' , 1 ) ;

1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --
1074: begin
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'ENTER SAVE_MESSAGES' , 1 ) ;
1077: END IF;
1078: FOR I IN 1..l_count_msg LOOP
1079: IF nvl(g_msg_tbl(I).processed,'N') = 'N' THEN
1080: insert_message(I,p_request_id,p_message_source_code);

Line 1084: oe_debug_pub.add( 'EXIT SAVE_MESSAGES' , 1 ) ;

1080: insert_message(I,p_request_id,p_message_source_code);
1081: END IF;
1082: End Loop;
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'EXIT SAVE_MESSAGES' , 1 ) ;
1085: END IF;
1086: oe_msg_pub.initialize;
1087: EXCEPTION
1088: WHEN OTHERS THEN

Line 1090: oe_debug_pub.add('Error in Procedure save_messages ' || sqlerrm);

1086: oe_msg_pub.initialize;
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: IF l_debug_level > 0 THEN
1090: oe_debug_pub.add('Error in Procedure save_messages ' || sqlerrm);
1091: END IF;
1092: end;
1093:
1094: -- Bug 5007836, Created this overloaded API which is to be called

Line 1102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1098: RETURN VARCHAR2
1099: IS
1100: Pragma AUTONOMOUS_TRANSACTION;
1101: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
1102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1103: l_count NUMBER := 0;
1104: begin
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add( 'ENTER Function SAVE_MESSAGES' , 1 ) ;

Line 1106: oe_debug_pub.add( 'ENTER Function SAVE_MESSAGES' , 1 ) ;

1102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1103: l_count NUMBER := 0;
1104: begin
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add( 'ENTER Function SAVE_MESSAGES' , 1 ) ;
1107: END IF;
1108: FOR I IN 1..l_count_msg LOOP
1109: IF nvl(g_msg_tbl(I).processed,'N') = 'N' THEN
1110: insert_message(I,p_request_id,p_message_source_code);

Line 1131: oe_debug_pub.add('Error in Function save_messages ' || sqlerrm);

1127: END IF;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: IF l_debug_level > 0 THEN
1131: oe_debug_pub.add('Error in Function save_messages ' || sqlerrm);
1132: END IF;
1133: end save_messages;
1134:
1135: -- PROCEDURE insert_messages

Line 1175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1171: l_order_number NUMBER;
1172: l_line_number VARCHAR2(30);
1173:
1174: --
1175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1176: --
1177: BEGIN
1178:
1179:

Line 1210: oe_debug_pub.add( 'L_MSG_DATA='||L_MSG_DATA,3 ) ;

1206: ,x_type => l_type
1207: );
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'L_MSG_DATA='||L_MSG_DATA,3 ) ;
1211: END IF;
1212:
1213: if nvl(fnd_profile.value('CONC_REQUEST_ID'),0) > 0 then
1214: BEGIN --bug 7184951

Line 1232: oe_debug_pub.add('Error in Procedure insert_message ' || sqlerrm);

1228: FND_FILE.put_line(FND_FILE.LOG,'Message :'|| l_msg_data);
1229: EXCEPTION ---start bug 7184951
1230: WHEN OTHERS THEN
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add('Error in Procedure insert_message ' || sqlerrm);
1233: oe_debug_pub.add('Order number not found');
1234: END IF;
1235: /*End bug 7184951*/
1236: END ;

Line 1233: oe_debug_pub.add('Order number not found');

1229: EXCEPTION ---start bug 7184951
1230: WHEN OTHERS THEN
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add('Error in Procedure insert_message ' || sqlerrm);
1233: oe_debug_pub.add('Order number not found');
1234: END IF;
1235: /*End bug 7184951*/
1236: END ;
1237:

Line 1357: oe_debug_pub.add('Error in Procedure insert_message ' || sqlerrm);

1353: end if;
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: IF l_debug_level > 0 THEN
1357: oe_debug_pub.add('Error in Procedure insert_message ' || sqlerrm);
1358: END IF;
1359: End insert_message;
1360:
1361:

Line 1374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1370: --
1371: PROCEDURE Get_msg_tbl(x_msg_tbl IN OUT NOCOPY /* file.sql.39 change */ msg_tbl_type)
1372: IS
1373: --
1374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1375: --
1376: BEGIN
1377:
1378: FOR i IN G_msg_tbl.FIRST .. G_msg_tbl.LAST LOOP

Line 1416: oe_debug_pub.add('Error in Procedure get_msg_tbl ' || sqlerrm);

1412: END LOOP;
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add('Error in Procedure get_msg_tbl ' || sqlerrm);
1417: END IF;
1418:
1419: END;
1420: /* Added the below procedure for bug 4716444 */

Line 1475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1471: ,p_message_source_code IN VARCHAR2)
1472: IS
1473: Pragma AUTONOMOUS_TRANSACTION;
1474: --
1475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1476: --
1477: BEGIN
1478:
1479: Save_Messages(p_request_id

Line 1485: oe_debug_pub.add('Error in Procedure save_ui_messages ' || sqlerrm);

1481: COMMIT;
1482: EXCEPTION
1483: WHEN OTHERS THEN
1484: IF l_debug_level > 0 THEN
1485: oe_debug_pub.add('Error in Procedure save_ui_messages ' || sqlerrm);
1486: END IF;
1487: END Save_UI_Messages;
1488:
1489: -- PROCEDURE Update_notification_flag.

Line 1506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1502: PROCEDURE Update_Notification_Flag(p_transaction_id IN NUMBER)
1503: IS
1504: Pragma AUTONOMOUS_TRANSACTION;
1505: --
1506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1507: --
1508: BEGIN
1509:
1510: UPDATE oe_processing_msgs

Line 1518: oe_debug_pub.add('Error in Procedure Update_Notification_Flag ' || sqlerrm);

1514: COMMIT;
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('Error in Procedure Update_Notification_Flag ' || sqlerrm);
1519: END IF;
1520: END Update_Notification_Flag;
1521:
1522: -- PROCEDURE Update_UI_notification_flag.

Line 1534: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1530:
1531: PROCEDURE Update_UI_Notification_Flag(p_msg_ind IN NUMBER)
1532: IS
1533: --
1534: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1535: --
1536: BEGIN
1537:
1538: G_msg_tbl(p_msg_ind).Notification_flag := 'Y';

Line 1542: oe_debug_pub.add('Error in Procedure Update_UI_Notification_Flag ' || sqlerrm);

1538: G_msg_tbl(p_msg_ind).Notification_flag := 'Y';
1539: EXCEPTION
1540: WHEN OTHERS THEN
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('Error in Procedure Update_UI_Notification_Flag ' || sqlerrm);
1543: END IF;
1544:
1545: END Update_UI_Notification_Flag;
1546:

Line 1575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1571: l_message VARCHAR2(2000);
1572: l_constraint_id NUMBER;
1573: l_msg_length NUMBER := 0;
1574: --
1575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1576: --
1577: BEGIN
1578:
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1692: l_transaction_id NUMBER;
1693: l_creation_date_from DATE;
1694: l_creation_date_to DATE;
1695: --
1696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1697: --
1698: BEGIN
1699: IF l_debug_level > 0 THEN
1700: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;

Line 1700: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;

1696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1697: --
1698: BEGIN
1699: IF l_debug_level > 0 THEN
1700: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_MESSAGE' ) ;
1701: END IF;
1702: /* 1922443 */
1703: /* select msg.rowid,
1704: msg.transaction_id

Line 1836: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

1832: IF p_process_activity_name IS NOT NULL THEN
1833: l_stmt := l_stmt ||' AND wa.display_name = :process_activity_name';
1834: END IF;
1835:
1836: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
1837:
1838: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
1839:
1840: OE_DEBUG_PUB.Add('after parse',1);

Line 1840: OE_DEBUG_PUB.Add('after parse',1);

1836: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
1837:
1838: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
1839:
1840: OE_DEBUG_PUB.Add('after parse',1);
1841: --5121760
1842: SELECT fnd_date.chardt_to_date(p_creation_date_from),
1843: fnd_date.chardt_to_date(p_creation_date_to)
1844: INTO l_creation_date_from,l_creation_date_to

Line 1898: oe_debug_pub.add('Before execute ',1);

1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);
1895: END IF;
1896:
1897: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1898: oe_debug_pub.add('Before execute ',1);
1899: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1900:
1901: LOOP
1902: oe_debug_pub.add('J: ' || J,1);

Line 1902: oe_debug_pub.add('J: ' || J,1);

1898: oe_debug_pub.add('Before execute ',1);
1899: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1900:
1901: LOOP
1902: oe_debug_pub.add('J: ' || J,1);
1903:
1904: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
1905: EXIT;
1906: END IF;

Line 1911: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);

1907:
1908: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
1909: J := J +1 ;
1910:
1911: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
1912: oe_debug_pub.add('J1: ' || J,1);
1913:
1914: Transactionids.extend(1);
1915: Transactionids(J) := l_transaction_id;

Line 1912: oe_debug_pub.add('J1: ' || J,1);

1908: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
1909: J := J +1 ;
1910:
1911: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
1912: oe_debug_pub.add('J1: ' || J,1);
1913:
1914: Transactionids.extend(1);
1915: Transactionids(J) := l_transaction_id;
1916:

Line 1919: oe_debug_pub.add('Before Close ',1);

1915: Transactionids(J) := l_transaction_id;
1916:
1917: END LOOP;
1918:
1919: oe_debug_pub.add('Before Close ',1);
1920: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1921:
1922:
1923: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);

Line 1923: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);

1919: oe_debug_pub.add('Before Close ',1);
1920: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1921:
1922:
1923: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1924:
1925: FORALL J in 1..Transactionids.COUNT
1926: Delete
1927: from oe_processing_msgs_tl

Line 1947: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_MESSAGE' ) ;

1943:
1944: commit;
1945:
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_MESSAGE' ) ;
1948: END IF;
1949:
1950: EXCEPTION
1951:

Line 1954: oe_debug_pub.add ('error :' || sqlerrm,1);

1950: EXCEPTION
1951:
1952: WHEN OTHERS THEN
1953:
1954: oe_debug_pub.add ('error :' || sqlerrm,1);
1955: oe_debug_pub.add (l_stmt,1);
1956: END DELETE_MESSAGE;
1957:
1958: PROCEDURE DELETE_OI_MESSAGE

Line 1955: oe_debug_pub.add (l_stmt,1);

1951:
1952: WHEN OTHERS THEN
1953:
1954: oe_debug_pub.add ('error :' || sqlerrm,1);
1955: oe_debug_pub.add (l_stmt,1);
1956: END DELETE_MESSAGE;
1957:
1958: PROCEDURE DELETE_OI_MESSAGE
1959: (p_request_id IN NUMBER DEFAULT NULL

Line 1988: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1984: d NUMBER;
1985: l_transaction_id NUMBER;
1986:
1987: --
1988: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1989: --
1990: BEGIN
1991:
1992: IF l_debug_level > 0 THEN

Line 1993: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;

1989: --
1990: BEGIN
1991:
1992: IF l_debug_level > 0 THEN
1993: oe_debug_pub.add( 'IN OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
1994: END IF;
1995: /* Replaced with the following for 1922443
1996: Select transaction_id
1997: Bulk Collect Into transactions_oi

Line 2098: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

2094: IF p_org_id IS NOT NULL THEN
2095: l_stmt := l_stmt ||' AND org_id = :org_id';
2096: END IF;
2097:
2098: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2099:
2100: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2101:
2102: OE_DEBUG_PUB.Add('after parse',1);

Line 2102: OE_DEBUG_PUB.Add('after parse',1);

2098: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2099:
2100: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2101:
2102: OE_DEBUG_PUB.Add('after parse',1);
2103: IF p_order_source_id IS NOT NULL THEN
2104: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2105: END IF;
2106:

Line 2140: oe_debug_pub.add('Before execute ',1);

2136: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2137: END IF;
2138:
2139: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2140: oe_debug_pub.add('Before execute ',1);
2141: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2142:
2143: LOOP
2144: oe_debug_pub.add('J: ' || J,1);

Line 2144: oe_debug_pub.add('J: ' || J,1);

2140: oe_debug_pub.add('Before execute ',1);
2141: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2142:
2143: LOOP
2144: oe_debug_pub.add('J: ' || J,1);
2145:
2146: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2147: EXIT;
2148: END IF;

Line 2153: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);

2149:
2150: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2151: J := J +1 ;
2152:
2153: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
2154: oe_debug_pub.add('J1: ' || J,1);
2155:
2156: Transactionids.extend(1);
2157: Transactionids(J) := l_transaction_id;

Line 2154: oe_debug_pub.add('J1: ' || J,1);

2150: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2151: J := J +1 ;
2152:
2153: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
2154: oe_debug_pub.add('J1: ' || J,1);
2155:
2156: Transactionids.extend(1);
2157: Transactionids(J) := l_transaction_id;
2158:

Line 2161: oe_debug_pub.add('Before Close ',1);

2157: Transactionids(J) := l_transaction_id;
2158:
2159: END LOOP;
2160:
2161: oe_debug_pub.add('Before Close ',1);
2162: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2163:
2164:
2165: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);

Line 2165: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);

2161: oe_debug_pub.add('Before Close ',1);
2162: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2163:
2164:
2165: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2166:
2167: FORALL J in 1..Transactionids.COUNT
2168: Delete
2169: from oe_processing_msgs_tl

Line 2183: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;

2179:
2180: commit;
2181:
2182: IF l_debug_level > 0 THEN
2183: oe_debug_pub.add( 'EXITING OE_MSG_PUB.DELETE_OI_MESSAGE' ) ;
2184: END IF;
2185:
2186: /*
2187: EXCEPTION

Line 2191: oe_debug_pub.add('Error : ' || sqlerrm);*/

2187: EXCEPTION
2188:
2189: WHEN OTHERS THEN
2190:
2191: oe_debug_pub.add('Error : ' || sqlerrm);*/
2192: END DELETE_OI_MESSAGE;
2193:
2194: -- 4091185 - Added parameter p_type.
2195: PROCEDURE Transfer_Msg_Stack

Line 2202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2198: IS
2199: l_count NUMBER;
2200: l_message VARCHAR2(2000);
2201: --
2202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2203: --
2204: BEGIN
2205:
2206: IF p_msg_index IS NOT NULL THEN

Line 2231: oe_debug_pub.add('Error in Procedure Transfer_Msg_Stack ' || sqlerrm);

2227: fnd_msg_pub.delete_msg; -- Adding this call to fix 4642102.
2228: EXCEPTION
2229: WHEN OTHERS THEN
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add('Error in Procedure Transfer_Msg_Stack ' || sqlerrm);
2232: END IF;
2233: END Transfer_Msg_Stack;
2234:
2235: /* Procedure Save_API_Messages will be used by many API's to store the

Line 2254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2250: IS
2251: Pragma AUTONOMOUS_TRANSACTION;
2252:
2253: l_count_msg NUMBER;
2254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2255: l_errmsg VARCHAR2(1000) := Null;
2256: l_request_id NUMBER := p_request_id;
2257: l_message_source_code VARCHAR2(3) := p_message_source_code;
2258:

Line 2263: oe_debug_pub.add( 'ENTER Save_API_Messages' , 1 ) ;

2259: BEGIN
2260:
2261:
2262: IF l_debug_level > 0 THEN
2263: oe_debug_pub.add( 'ENTER Save_API_Messages' , 1 ) ;
2264: END IF;
2265:
2266: IF nvl(fnd_profile.value('CONC_REQUEST_ID'),0) > 0
2267: THEN

Line 2275: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;

2271:
2272: l_errmsg := ltrim(Substr(SQLERRM,1,1000));
2273:
2274: IF l_errmsg IS NOT NULL THEN
2275: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;
2276: END IF;
2277:
2278: /* Commenting the following code
2279: to fix the bug 5201283 as we do not need to

Line 2287: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;

2283: IF l_errmsg IS NOT NULL
2284: AND substr(l_errmsg,5,4) <> '0000'
2285: AND rtrim(ltrim(l_errmsg)) <> 'ORA-20001:'
2286: AND upper(substr(ltrim(l_errmsg),1,5)) <> 'USER-' THEN
2287: oe_debug_pub.add('l_errmsg ' || l_errmsg, 2 ) ;
2288: oe_msg_pub.add_text(p_message_text => l_errmsg);
2289: END IF;
2290:
2291: */

Line 2301: oe_debug_pub.add( 'EXIT Save_API_Messages' , 1 ) ;

2297: END IF;
2298: End Loop;
2299:
2300: IF l_debug_level > 0 THEN
2301: oe_debug_pub.add( 'EXIT Save_API_Messages' , 1 ) ;
2302: END IF;
2303:
2304: COMMIT;
2305: EXCEPTION

Line 2308: oe_debug_pub.add('Error in Procedure Save_API_Messages ' || sqlerrm);

2304: COMMIT;
2305: EXCEPTION
2306: WHEN OTHERS THEN
2307: IF l_debug_level > 0 THEN
2308: oe_debug_pub.add('Error in Procedure Save_API_Messages ' || sqlerrm);
2309: END IF;
2310: END Save_API_Messages;
2311: PROCEDURE Update_status_code(
2312: p_request_id IN NUMBER DEFAULT NULL

Line 2333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2329: ,p_sold_to_org_id IN NUMBER DEFAULT NULL
2330: ,p_status_code IN Varchar2)
2331: IS
2332: --
2333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2334:
2335: l_transaction_id NUMBER;
2336: l_cursor_id INTEGER;
2337: l_retval INTEGER;

Line 2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);

2338: l_stmt VARCHAR2(4000) :=NULL;
2339: --
2340: BEGIN
2341:
2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);
2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);

Line 2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);

2339: --
2340: BEGIN
2341:
2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);
2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);

Line 2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);

2340: BEGIN
2341:
2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);
2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);

Line 2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);

2341:
2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);
2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);

Line 2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);

2342: oe_debug_pub.add('p_entity_code: ' || p_entity_code,2);
2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);

Line 2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);

2343: oe_debug_pub.add('p_entity_id: ' || p_entity_id,2);
2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);

Line 2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);

2344: oe_debug_pub.add('p_header_id: ' || p_header_id,2);
2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2352:

Line 2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);

2345: oe_debug_pub.add('p_line_id: ' || p_line_id,2);
2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2352:
2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);

2346: oe_debug_pub.add('p_order_source_id: ' || p_order_source_id,2);
2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2352:
2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2354:

Line 2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);

2347: oe_debug_pub.add('p_orig_sys_document_ref: ' || p_orig_sys_document_ref,2);
2348: oe_debug_pub.add('p_process_activity: ' || p_process_activity,2);
2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2352:
2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2354:
2355:

Line 2493: oe_debug_pub.add('Error in Procedure Update_status_code ' || sqlerrm);

2489: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: IF l_debug_level > 0 THEN
2493: oe_debug_pub.add('Error in Procedure Update_status_code ' || sqlerrm);
2494: END IF;
2495: End Update_status_code;
2496:
2497: END OE_MSG_PUB ;