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_BULK_MSG_PUB dependencies on OE_DEBUG_PUB

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

6:
7: PROCEDURE Extend
8: IS
9: --
10: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11: --
12: BEGIN
13: g_msg_tbl.MESSAGE.EXTEND;
14: g_msg_tbl.ENTITY_CODE.EXTEND;

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

35:
36: PROCEDURE Delete_tbl(p_count NUMBER := NULL)
37: IS
38: --
39: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
40: --
41: BEGIN
42: IF p_count IS NULL THEN
43: g_msg_tbl.MESSAGE.DELETE;

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

86:
87: PROCEDURE Initialize
88: IS
89: --
90: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
91: --
92: BEGIN
93:
94: FND_MSG_PUB.Initialize;

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

129: PROCEDURE Set_Process_Activity(
130: p_process_activity IN NUMBER DEFAULT NULL)
131: IS
132: --
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134: --
135: BEGIN
136:
137: G_process_activity := p_process_activity;

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

156: ,p_constraint_id IN NUMBER DEFAULT NULL
157: )
158: IS
159: --
160: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
161: --
162: BEGIN
163: G_msg_context_count := G_msg_context_count + 1;
164:

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

195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
197: ) IS
198: --
199: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
200: --
201: Begin
202:
203: if p_entity_id <> FND_API.G_MISS_NUM then

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

238:
239: PROCEDURE Reset_Msg_Context (p_entity_code IN VARCHAR2)
240: IS
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245: if G_msg_context_count > 0 then
246: if G_msg_context_tbl.EXISTS(G_msg_context_count) AND

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

253:
254: FUNCTION Count_Msg RETURN NUMBER
255: IS
256: --
257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
258: --
259: BEGIN
260:
261: RETURN G_msg_Count;

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

271: )
272: IS
273: l_msg_count NUMBER;
274: --
275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
276: --
277: BEGIN
278:
279: l_msg_count := Count_Msg;

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

298: l_type VARCHAR2(30);
299: l_app_id VARCHAR2(30);
300: l_message_name VARCHAR2(30);
301: --
302: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
303: --
304: BEGIN
305:
306: IF p_msg_type IS NOT NULL THEN

Line 363: oe_debug_pub.add( 'NO CONTEXT , ADD TO MSG TBL' ) ;

359: G_msg_tbl.message(G_msg_count) := Get(G_msg_count, 'F');
360:
361: ELSE
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'NO CONTEXT , ADD TO MSG TBL' ) ;
364: END IF;
365: G_msg_tbl.ENTITY_CODE(G_msg_count) := NULL;
366: G_msg_tbl.ENTITY_ID(G_msg_count) := NULL;
367: G_msg_tbl.HEADER_ID(G_msg_count) := NULL;

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

385: ,p_type IN VARCHAR2 DEFAULT 'ERROR'
386: ,p_context_flag IN VARCHAR2 DEFAULT 'Y')
387: IS
388: --
389: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
390: --
391: BEGIN
392:
393: G_msg_count := G_msg_count + 1;

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

434: )
435: IS
436: l_msg_index NUMBER;
437: --
438: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
439: --
440: BEGIN
441:
442: IF p_msg_index IS NULL THEN

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

495: )
496: IS
497: l_msg_index NUMBER := G_msg_index;
498: --
499: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
500: --
501: BEGIN
502:
503: IF p_msg_index = G_NEXT THEN

Line 520: oe_debug_pub.add( 'ENTERING THE MESSAGE_TEXT NOT NULL' ) ;

516: IF G_msg_tbl.Message_Text(G_msg_index) IS NOT NULL THEN
517:
518: p_data := G_msg_tbl.Message_Text(G_msg_index);
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'ENTERING THE MESSAGE_TEXT NOT NULL' ) ;
521: END IF;
522:
523: ELSE
524: IF FND_API.To_Boolean( p_encoded ) THEN

Line 528: oe_debug_pub.add( 'ENTERING P_ENCODED AS TRUE ' ) ;

524: IF FND_API.To_Boolean( p_encoded ) THEN
525:
526: p_data := G_msg_tbl.Message( G_msg_index );
527: IF l_debug_level > 0 THEN
528: oe_debug_pub.add( 'ENTERING P_ENCODED AS TRUE ' ) ;
529: END IF;
530:
531: ELSE
532:

Line 534: oe_debug_pub.add( 'ENTERING P_ENCODED AS FALSE ' ) ;

530:
531: ELSE
532:
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'ENTERING P_ENCODED AS FALSE ' ) ;
535: END IF;
536: FND_MESSAGE.SET_ENCODED ( G_msg_tbl.Message( G_msg_index ));
537:
538: p_data := FND_MESSAGE.GET;

Line 540: oe_debug_pub.add( 'THE MESSAGE IS '||P_DATA ) ;

536: FND_MESSAGE.SET_ENCODED ( G_msg_tbl.Message( G_msg_index ));
537:
538: p_data := FND_MESSAGE.GET;
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'THE MESSAGE IS '||P_DATA ) ;
541: END IF;
542:
543: END IF;
544: END IF;

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

564: IS
565: l_data VARCHAR2(2000) ;
566: l_msg_index_out NUMBER ;
567: --
568: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
569: --
570: BEGIN
571:
572: Get

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

598: PROCEDURE Reset ( p_mode IN NUMBER := G_FIRST )
599: IS
600: l_PROCEDURE_name CONSTANT VARCHAR2(15):='Reset';
601: --
602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
603: --
604: BEGIN
605:
606: IF p_mode = G_FIRST THEN

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

646: ( p_message_level IN NUMBER := G_MSG_LVL_SUCCESS
647: ) RETURN BOOLEAN
648: IS
649: --
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: --
652: BEGIN
653:
654: IF G_msg_level_threshold = FND_API.G_MISS_NUM THEN

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

677: )
678: IS
679: l_error_text VARCHAR2(2000) := p_error_text ;
680: --
681: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
682: --
683: BEGIN
684:
685: -- If p_error_text is missing use SQLERRM.

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

713: p_context_flag IN VARCHAR2 DEFAULT 'Y'
714: )
715: IS
716: --
717: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
718: --
719: BEGIN
720: Build_Exc_Msg
721: ( p_pkg_name ,

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

731: PROCEDURE Dump_Msg
732: ( p_msg_index IN NUMBER )
733: IS
734: --
735: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
736: --
737: BEGIN
738: OE_DEBUG_PUB.debug_on;
739: IF l_debug_level > 0 THEN

Line 738: OE_DEBUG_PUB.debug_on;

734: --
735: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
736: --
737: BEGIN
738: OE_DEBUG_PUB.debug_on;
739: IF l_debug_level > 0 THEN
740: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
741: END IF;
742: IF l_debug_level > 0 THEN

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

736: --
737: BEGIN
738: OE_DEBUG_PUB.debug_on;
739: IF l_debug_level > 0 THEN
740: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
741: END IF;
742: IF l_debug_level > 0 THEN
743: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL.ORDER_SOURCE_ID ( P_MSG_INDEX ) ) ;
744: END IF;

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

739: IF l_debug_level > 0 THEN
740: oe_debug_pub.add( 'MESSAGE NUMBER : '||P_MSG_INDEX ) ;
741: END IF;
742: IF l_debug_level > 0 THEN
743: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL.ORDER_SOURCE_ID ( P_MSG_INDEX ) ) ;
744: END IF;
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_REF ( P_MSG_INDEX ) ) ;
747: END IF;

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

742: IF l_debug_level > 0 THEN
743: oe_debug_pub.add( 'ORDER_SOURCE_ID = '||G_MSG_TBL.ORDER_SOURCE_ID ( P_MSG_INDEX ) ) ;
744: END IF;
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_REF ( P_MSG_INDEX ) ) ;
747: END IF;
748: IF l_debug_level > 0 THEN
749: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_LINE_REF ( P_MSG_INDEX ) ) ;
750: END IF;

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

745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( 'ORIG_SYS_DOC_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_REF ( P_MSG_INDEX ) ) ;
747: END IF;
748: IF l_debug_level > 0 THEN
749: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_LINE_REF ( P_MSG_INDEX ) ) ;
750: END IF;
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_TYPE_ID ( P_MSG_INDEX ) ) ;
753: END IF;

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

748: IF l_debug_level > 0 THEN
749: oe_debug_pub.add( 'ORIG_SYS_LIN_REF = '||G_MSG_TBL.ORIG_SYS_DOCUMENT_LINE_REF ( P_MSG_INDEX ) ) ;
750: END IF;
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_TYPE_ID ( P_MSG_INDEX ) ) ;
753: END IF;
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_ID ( P_MSG_INDEX ) ) ;
756: END IF;

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

751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'SOURCE_DOC_TYPE_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_TYPE_ID ( P_MSG_INDEX ) ) ;
753: END IF;
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_ID ( P_MSG_INDEX ) ) ;
756: END IF;
757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_LINE_ID ( P_MSG_INDEX ) ) ;
759: END IF;

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

754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'SOURCE_DOC_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_ID ( P_MSG_INDEX ) ) ;
756: END IF;
757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_LINE_ID ( P_MSG_INDEX ) ) ;
759: END IF;
760: IF l_debug_level > 0 THEN
761: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL.ATTRIBUTE_CODE ( P_MSG_INDEX ) ) ;
762: END IF;

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

757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'SOURCE_LIN_ID = '||G_MSG_TBL.SOURCE_DOCUMENT_LINE_ID ( P_MSG_INDEX ) ) ;
759: END IF;
760: IF l_debug_level > 0 THEN
761: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL.ATTRIBUTE_CODE ( P_MSG_INDEX ) ) ;
762: END IF;
763: IF l_debug_level > 0 THEN
764: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL.CONSTRAINT_ID ( P_MSG_INDEX ) ) ;
765: END IF;

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

760: IF l_debug_level > 0 THEN
761: oe_debug_pub.add( 'ATTRIBUTE_CODE = '||G_MSG_TBL.ATTRIBUTE_CODE ( P_MSG_INDEX ) ) ;
762: END IF;
763: IF l_debug_level > 0 THEN
764: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL.CONSTRAINT_ID ( P_MSG_INDEX ) ) ;
765: END IF;
766: IF l_debug_level > 0 THEN
767: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL.PROCESS_ACTIVITY ( P_MSG_INDEX ) ) ;
768: END IF;

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

763: IF l_debug_level > 0 THEN
764: oe_debug_pub.add( 'CONSTRAINT_ID = '||G_MSG_TBL.CONSTRAINT_ID ( P_MSG_INDEX ) ) ;
765: END IF;
766: IF l_debug_level > 0 THEN
767: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL.PROCESS_ACTIVITY ( P_MSG_INDEX ) ) ;
768: END IF;
769: OE_DEBUG_PUB.dumpdebug;
770: OE_DEBUG_PUB.debug_off;
771: END Dump_Msg;

Line 769: OE_DEBUG_PUB.dumpdebug;

765: END IF;
766: IF l_debug_level > 0 THEN
767: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL.PROCESS_ACTIVITY ( P_MSG_INDEX ) ) ;
768: END IF;
769: OE_DEBUG_PUB.dumpdebug;
770: OE_DEBUG_PUB.debug_off;
771: END Dump_Msg;
772:
773: -- PROCEDURE Dump_List

Line 770: OE_DEBUG_PUB.debug_off;

766: IF l_debug_level > 0 THEN
767: oe_debug_pub.add( 'PROCESS_ACTIVITY = '||G_MSG_TBL.PROCESS_ACTIVITY ( P_MSG_INDEX ) ) ;
768: END IF;
769: OE_DEBUG_PUB.dumpdebug;
770: OE_DEBUG_PUB.debug_off;
771: END Dump_Msg;
772:
773: -- PROCEDURE Dump_List
774: --

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

776: ( p_messages IN BOOLEAN := FALSE
777: )
778: IS
779: --
780: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
781: --
782: BEGIN
783:
784: OE_DEBUG_PUB.debug_on;

Line 784: OE_DEBUG_PUB.debug_on;

780: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
781: --
782: BEGIN
783:
784: OE_DEBUG_PUB.debug_on;
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
787: END IF;
788: IF l_debug_level > 0 THEN

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

782: BEGIN
783:
784: OE_DEBUG_PUB.debug_on;
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
787: END IF;
788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'G_MSG_TBL.MESSAGE.COUNT = '||G_MSG_TBL.MESSAGE.COUNT ) ;
790: END IF;

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

785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'DUMPING MESSAGE LIST :' ) ;
787: END IF;
788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'G_MSG_TBL.MESSAGE.COUNT = '||G_MSG_TBL.MESSAGE.COUNT ) ;
790: END IF;
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
793: END IF;

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

788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'G_MSG_TBL.MESSAGE.COUNT = '||G_MSG_TBL.MESSAGE.COUNT ) ;
790: END IF;
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
793: END IF;
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
796: END IF;

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

791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'G_MSG_COUNT = '||G_MSG_COUNT ) ;
793: END IF;
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
796: END IF;
797: OE_DEBUG_PUB.dumpdebug;
798: OE_DEBUG_PUB.debug_off;
799:

Line 797: OE_DEBUG_PUB.dumpdebug;

793: END IF;
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
796: END IF;
797: OE_DEBUG_PUB.dumpdebug;
798: OE_DEBUG_PUB.debug_off;
799:
800: IF p_messages THEN
801:

Line 798: OE_DEBUG_PUB.debug_off;

794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'G_MSG_INDEX = '||G_MSG_INDEX ) ;
796: END IF;
797: OE_DEBUG_PUB.dumpdebug;
798: OE_DEBUG_PUB.debug_off;
799:
800: IF p_messages THEN
801:
802: FOR I IN 1..G_msg_tbl.Message.COUNT LOOP

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

826: ,p_message_source_code IN VARCHAR2 DEFAULT 'C')
827: IS
828: l_count_msg NUMBER;
829: --
830: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
831: --
832: begin
833: IF l_debug_level > 0 THEN
834: oe_debug_pub.add( 'ENTER SAVE_MESSAGES' , 1 ) ;

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

830: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
831: --
832: begin
833: IF l_debug_level > 0 THEN
834: oe_debug_pub.add( 'ENTER SAVE_MESSAGES' , 1 ) ;
835: END IF;
836: l_count_msg := G_msg_tbl.ENTITY_ID.COUNT;
837:
838: FORALL i IN 1..l_count_msg

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

905: , G_msg_tbl.message(i)
906: );
907:
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add( 'EXIT SAVE_MESSAGES' , 1 ) ;
910: END IF;
911: OE_BULK_MSG_PUB.initialize;
912:
913: EXCEPTION

Line 916: oe_debug_pub.add( 'OTHERS ERROR , SAVE_MESSAGES' ) ;

912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: IF l_debug_level > 0 THEN
916: oe_debug_pub.add( 'OTHERS ERROR , SAVE_MESSAGES' ) ;
917: END IF;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
920: END IF;

Line 919: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

915: IF l_debug_level > 0 THEN
916: oe_debug_pub.add( 'OTHERS ERROR , SAVE_MESSAGES' ) ;
917: END IF;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
920: END IF;
921: end;
922:
923:

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

932: --
933: PROCEDURE Get_msg_tbl(x_msg_tbl IN OUT NOCOPY /* file.sql.39 change */ G_MSG_REC_TYPE)
934: IS
935: --
936: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
937: --
938: BEGIN
939:
940: FOR i IN G_msg_tbl.Message.FIRST .. G_msg_tbl.Message.LAST LOOP

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

980: IS
981: l_count NUMBER;
982: l_message VARCHAR2(2000);
983: --
984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
985: --
986: BEGIN
987:
988: IF p_msg_index IS NOT NULL THEN