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

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

106: AND wf_assign.wf_item_type = oe_globals.g_wfi_bkt
107: AND wf_assign.line_type_id IS NULL;
108:
109: --
110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
111: --
112: BEGIN
113: IF l_debug_level > 0
114: THEN

Line 115: oe_debug_pub.ADD ( 'IN GET_PROCESSNAME: '

111: --
112: BEGIN
113: IF l_debug_level > 0
114: THEN
115: oe_debug_pub.ADD ( 'IN GET_PROCESSNAME: '
116: || p_itemtype
117: || '/'
118: || p_itemkey
119: || '/'

Line 136: oe_debug_pub.ADD ( 'header_id: '

132: ELSIF (p_itemtype = oe_globals.g_wfi_lin)
133: THEN
134: IF l_debug_level > 0
135: THEN
136: oe_debug_pub.ADD ( 'header_id: '
137: || p_line_rec.header_id
138: || ' line_id: '
139: || p_line_rec.line_id
140: || ' line_type_id: '

Line 190: oe_debug_pub.ADD ('PROCESS NAME IS ' || l_process_name);

186: END IF;
187:
188: IF l_debug_level > 0
189: THEN
190: oe_debug_pub.ADD ('PROCESS NAME IS ' || l_process_name);
191: END IF;
192:
193: RETURN l_process_name;
194:

Line 197: oe_debug_pub.ADD ('EXITING GET_PROCESSNAME');

193: RETURN l_process_name;
194:
195: IF l_debug_level > 0
196: THEN
197: oe_debug_pub.ADD ('EXITING GET_PROCESSNAME');
198: END IF;
199: EXCEPTION
200: WHEN NO_DATA_FOUND
201: THEN

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

225: l_order_category_code VARCHAR2 (30);
226: l_order_type_txt VARCHAR2 (2000);
227: l_header_txt VARCHAR2 (2000);
228: --
229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
230: l_item_type VARCHAR2 (240); --ame er 16084377
231: l_item_key VARCHAR2 (100); --ame er 16084377
232: l_org_id NUMBER;
233: --

Line 269: oe_debug_pub.ADD ( 'before getting attribute:'

265: -- ame er 16084377 BEGIN
266: BEGIN
267: IF l_debug_level > 0
268: THEN
269: oe_debug_pub.ADD ( 'before getting attribute:'
270: );
271: END IF;
272:
273: IF l_item_type = 'OEAME'

Line 283: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);

279: END IF; --ame er 16084377
280:
281: IF l_debug_level > 0
282: THEN
283: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);
284: END IF;
285:
286: SELECT org_id
287: INTO l_org_id

Line 295: oe_debug_pub.ADD ('After setting org context:' || l_header_id);

291: mo_global.set_policy_context ('S', l_org_id);
292:
293: IF l_debug_level > 0
294: THEN
295: oe_debug_pub.ADD ('After setting org context:' || l_header_id);
296: END IF;
297:
298: IF l_header_id IS NULL
299: THEN

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

362: l_shipment_number NUMBER;
363: l_option_number NUMBER;
364: l_service_number NUMBER;
365: --
366: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
367: --
368: BEGIN
369: document_type := display_type;
370:

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

454: PROCEDURE set_header_user_key (p_header_rec IN oe_order_pub.header_rec_type)
455: IS
456: sales_order VARCHAR2 (240);
457: --
458: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
459: --
460: BEGIN
461: IF p_header_rec.order_category_code = 'RETURN'
462: THEN

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

481: PROCEDURE set_line_user_key (p_line_rec IN oe_order_pub.line_rec_type)
482: IS
483: l_header_id NUMBER;
484: --
485: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
486: --
487: BEGIN
488: l_header_id := p_line_rec.header_id;
489: -- Performance Bug 1929163:

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

525: --
526: PROCEDURE start_flow (p_itemtype IN VARCHAR2, p_itemkey IN VARCHAR2)
527: IS
528: --
529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
530: --
531: BEGIN
532: IF l_debug_level > 0
533: THEN

Line 534: oe_debug_pub.ADD ('IN START_FLOW');

530: --
531: BEGIN
532: IF l_debug_level > 0
533: THEN
534: oe_debug_pub.ADD ('IN START_FLOW');
535: END IF;
536:
537: wf_engine.startprocess (p_itemtype, p_itemkey);
538:

Line 541: oe_debug_pub.ADD ('EXITING START_FLOW');

537: wf_engine.startprocess (p_itemtype, p_itemkey);
538:
539: IF l_debug_level > 0
540: THEN
541: oe_debug_pub.ADD ('EXITING START_FLOW');
542: END IF;
543: EXCEPTION
544: WHEN OTHERS
545: THEN

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

552:
553: PROCEDURE start_linefork (p_itemkey IN VARCHAR2)
554: IS
555: --
556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
557: --
558: BEGIN
559: IF l_debug_level > 0
560: THEN

Line 561: oe_debug_pub.ADD ('IN START_LINEFORK');

557: --
558: BEGIN
559: IF l_debug_level > 0
560: THEN
561: oe_debug_pub.ADD ('IN START_LINEFORK');
562: END IF;
563:
564: wf_engine.startforkprocess ('OEOL', p_itemkey);
565:

Line 569: oe_debug_pub.ADD ('EXITING START_LINEFORK');

565:
566: -- Refresh old notifications here if needed.
567: IF l_debug_level > 0
568: THEN
569: oe_debug_pub.ADD ('EXITING START_LINEFORK');
570: END IF;
571: EXCEPTION
572: WHEN OTHERS
573: THEN

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

591: )
592: IS
593: --
594: l_count NUMBER;
595: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
596: --
597: BEGIN
598: IF l_debug_level > 0
599: THEN

Line 600: oe_debug_pub.ADD ('IN CREATESTART_HDRPROCESS');

596: --
597: BEGIN
598: IF l_debug_level > 0
599: THEN
600: oe_debug_pub.ADD ('IN CREATESTART_HDRPROCESS');
601: END IF;
602:
603: create_hdrworkitem (p_header_rec);
604: -- We do not start the flow when the record is written, rather

Line 630: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESS');

626:
627: /* Start_Flow(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id); */
628: IF l_debug_level > 0
629: THEN
630: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESS');
631: END IF;
632: EXCEPTION
633: WHEN fnd_api.g_exc_error
634: THEN -- 2590433

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

655: l_user_name VARCHAR2 (100);
656: l_validate_user NUMBER;
657: l_owner_role VARCHAR2 (100);
658: --
659: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
660: --
661: BEGIN
662: IF l_debug_level > 0
663: THEN

Line 664: oe_debug_pub.ADD ('IN CREATE_HDRWORKITEM');

660: --
661: BEGIN
662: IF l_debug_level > 0
663: THEN
664: oe_debug_pub.ADD ('IN CREATE_HDRWORKITEM');
665: END IF;
666:
667: -- Get name of Header Process
668: IF l_debug_level > 0

Line 670: oe_debug_pub.ADD ('GET HEADER PROCESS NAME');

666:
667: -- Get name of Header Process
668: IF l_debug_level > 0
669: THEN
670: oe_debug_pub.ADD ('GET HEADER PROCESS NAME');
671: END IF;
672:
673: l_hdr_process_name :=
674: get_processname (p_itemtype => oe_globals.g_wfi_hdr,

Line 701: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

697: );
698:
699: IF l_debug_level > 0
700: THEN
701: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
702: END IF;
703:
704: -- Set various Header Attributes
705: l_aname (1) := 'USER_ID';

Line 756: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEM');

752: );
753:
754: IF l_debug_level > 0
755: THEN
756: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEM');
757: END IF;
758: EXCEPTION
759: WHEN fnd_api.g_exc_error
760: THEN -- 2590433

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

774: IS
775: l_item_type VARCHAR2 (30);
776: l_index NUMBER;
777: --
778: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
779: --
780: BEGIN
781: -- If this is a Split Insert then we need to fork the flow
782: IF p_line_rec.split_from_line_id IS NOT NULL

Line 786: oe_debug_pub.ADD ('SPLIT FROM LINE ID IS NOT NULL');

782: IF p_line_rec.split_from_line_id IS NOT NULL
783: THEN
784: IF l_debug_level > 0
785: THEN
786: oe_debug_pub.ADD ('SPLIT FROM LINE ID IS NOT NULL');
787: END IF;
788:
789: createstart_linefork (p_line_rec);
790: ELSE -- Regular Flow creation

Line 796: oe_debug_pub.ADD ('IN CREATESTART_LINEPROCESS');

792: l_item_type := oe_order_wf_util.get_wf_item_type (p_line_rec);
793:
794: IF l_debug_level > 0
795: THEN
796: oe_debug_pub.ADD ('IN CREATESTART_LINEPROCESS');
797: END IF;
798:
799: create_lineworkitem (p_line_rec, l_item_type);
800:

Line 811: oe_debug_pub.ADD ( 'G_START_LINE_FLOWS_TBL.COUNT = 0'

807: IF (oe_globals.g_start_line_flows_tbl.COUNT = 0)
808: THEN
809: IF l_debug_level > 0
810: THEN
811: oe_debug_pub.ADD ( 'G_START_LINE_FLOWS_TBL.COUNT = 0'
812: || p_line_rec.ato_line_id
813: || '-'
814: || p_line_rec.line_id,
815: 2

Line 828: oe_debug_pub.ADD ( 'G_START_LINE_FLOWS_TBL.COUNT = '

824: l_index := oe_globals.g_start_line_flows_tbl.LAST;
825:
826: IF l_debug_level > 0
827: THEN
828: oe_debug_pub.ADD ( 'G_START_LINE_FLOWS_TBL.COUNT = '
829: || TO_CHAR (l_index)
830: || p_line_rec.ato_line_id
831: || '-'
832: || p_line_rec.line_id,

Line 845: oe_debug_pub.ADD ('EXITING CREATESTART_LINEPROCESS');

841: END IF;
842:
843: IF l_debug_level > 0
844: THEN
845: oe_debug_pub.ADD ('EXITING CREATESTART_LINEPROCESS');
846: END IF;
847: END IF;
848: EXCEPTION
849: WHEN fnd_api.g_exc_error

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

860:
861: PROCEDURE createstart_linefork (p_line_rec IN oe_order_pub.line_rec_type)
862: IS
863: --
864: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
865: --
866: BEGIN
867: IF l_debug_level > 0
868: THEN

Line 869: oe_debug_pub.ADD ('IN CREATESTART_LINEFORK');

865: --
866: BEGIN
867: IF l_debug_level > 0
868: THEN
869: oe_debug_pub.ADD ('IN CREATESTART_LINEFORK');
870: END IF;
871:
872: create_linefork (p_line_rec);
873: start_linefork (p_line_rec.line_id);

Line 877: oe_debug_pub.ADD ('EXITING CREATESTART_LINEFORK');

873: start_linefork (p_line_rec.line_id);
874:
875: IF l_debug_level > 0
876: THEN
877: oe_debug_pub.ADD ('EXITING CREATESTART_LINEFORK');
878: END IF;
879: EXCEPTION
880: WHEN OTHERS
881: THEN

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

902: l_avaluetext wf_engine.texttabtyp;
903: line VARCHAR2 (240);
904: l_owner_role VARCHAR2 (100);
905: --
906: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
907: --
908: BEGIN
909: IF l_debug_level > 0
910: THEN

Line 911: oe_debug_pub.ADD ('IN CREATE_LINEWORKITEM');

907: --
908: BEGIN
909: IF l_debug_level > 0
910: THEN
911: oe_debug_pub.ADD ('IN CREATE_LINEWORKITEM');
912: END IF;
913:
914: l_item_type := p_item_type;
915:

Line 919: oe_debug_pub.ADD ('GET LINE PROCESSNAME');

915:
916: -- Get name of Line Process
917: IF l_debug_level > 0
918: THEN
919: oe_debug_pub.ADD ('GET LINE PROCESSNAME');
920: END IF;
921:
922: l_line_process_name :=
923: get_processname (p_itemtype => oe_globals.g_wfi_lin,

Line 946: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

942: );
943:
944: IF l_debug_level > 0
945: THEN
946: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
947: END IF;
948:
949: -- Set various Line Attributes
950: l_aname (1) := 'USER_ID';

Line 982: oe_debug_pub.ADD ('EXITING CREATE_LINEWORKITEM');

978: );
979:
980: IF l_debug_level > 0
981: THEN
982: oe_debug_pub.ADD ('EXITING CREATE_LINEWORKITEM');
983: END IF;
984: EXCEPTION
985: WHEN fnd_api.g_exc_error
986: THEN -- 2590433

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

999: l_order_number NUMBER;
1000: l_header_id NUMBER;
1001: line VARCHAR2 (240);
1002: --
1003: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1004: --
1005: BEGIN
1006: IF l_debug_level > 0
1007: THEN

Line 1008: oe_debug_pub.ADD ('IN CREATE_LINEFORK');

1004: --
1005: BEGIN
1006: IF l_debug_level > 0
1007: THEN
1008: oe_debug_pub.ADD ('IN CREATE_LINEFORK');
1009: END IF;
1010:
1011: set_line_user_key (p_line_rec);
1012: line := SUBSTRB (fnd_message.get, 1, 240);

Line 1024: oe_debug_pub.ADD ('EXITING CREATE_LINEFORK');

1020: line);
1021:
1022: IF l_debug_level > 0
1023: THEN
1024: oe_debug_pub.ADD ('EXITING CREATE_LINEFORK');
1025: END IF;
1026: EXCEPTION
1027: WHEN OTHERS
1028: THEN

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

1043: RETURN VARCHAR2
1044: IS
1045: l_item_rec oe_order_cache.item_rec_type;
1046: --
1047: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1048: --
1049: BEGIN
1050: l_item_rec :=
1051: oe_order_cache.load_item (p_line_rec.inventory_item_id,

Line 1057: oe_debug_pub.ADD ('ITEM_TYPE_CODE IS ' || p_line_rec.item_type_code);

1053: );
1054:
1055: IF l_debug_level > 0
1056: THEN
1057: oe_debug_pub.ADD ('ITEM_TYPE_CODE IS ' || p_line_rec.item_type_code);
1058: END IF;
1059:
1060: -- Code for Returns
1061: IF p_line_rec.line_category_code = 'RETURN'

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

1160: l_item_type VARCHAR2 (30);
1161: l_line_rec oe_order_pub.line_rec_type;
1162: l_header_id NUMBER;
1163: --
1164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1165: --
1166: BEGIN
1167: IF l_debug_level > 0
1168: THEN

Line 1169: oe_debug_pub.ADD ('ENTERING START_ALL_FLOWS');

1165: --
1166: BEGIN
1167: IF l_debug_level > 0
1168: THEN
1169: oe_debug_pub.ADD ('ENTERING START_ALL_FLOWS');
1170: END IF;
1171:
1172: -- This code should be invoked again, once it starts executing
1173: -- Starting flows can cause the creation of new lines, but we do not

Line 1181: oe_debug_pub.ADD ('FLOW PROCESSING STARTED');

1177: oe_globals.g_flow_processing_started := TRUE;
1178:
1179: IF l_debug_level > 0
1180: THEN
1181: oe_debug_pub.ADD ('FLOW PROCESSING STARTED');
1182: END IF;
1183:
1184: -- Issue Savepoint
1185: SAVEPOINT start_all_flows;

Line 1201: oe_debug_pub.ADD ('STARTING HEADER FLOW');

1197: WHERE header_id = oe_globals.g_start_header_flow;
1198:
1199: IF l_debug_level > 0
1200: THEN
1201: oe_debug_pub.ADD ('STARTING HEADER FLOW');
1202: END IF;
1203:
1204: -- Start flow and clear global
1205: start_flow (oe_globals.g_wfi_hdr,

Line 1214: oe_debug_pub.ADD

1210: WHEN NO_DATA_FOUND
1211: THEN
1212: IF l_debug_level > 0
1213: THEN
1214: oe_debug_pub.ADD
1215: ( 'HEADER '
1216: || oe_globals.g_start_header_flow
1217: || ' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE'
1218: );

Line 1233: oe_debug_pub.ADD ('START LINE FLOWS');

1229: -- loop thru using first ... count. Starting a line flow can create included item
1230: -- lines (booking, scheduling activity).
1231: IF l_debug_level > 0
1232: THEN
1233: oe_debug_pub.ADD ('START LINE FLOWS');
1234: END IF;
1235:
1236: ctr := oe_globals.g_start_line_flows_tbl.FIRST;
1237:

Line 1242: oe_debug_pub.ADD

1238: WHILE (ctr IS NOT NULL)
1239: LOOP
1240: IF l_debug_level > 0
1241: THEN
1242: oe_debug_pub.ADD
1243: ( 'INSIDE LOOP '
1244: || 'LINE ID IS '
1245: || oe_globals.g_start_line_flows_tbl (ctr).line_id
1246: );

Line 1265: oe_debug_pub.ADD

1261: oe_globals.g_start_line_flows_tbl (ctr).line_id;
1262:
1263: IF l_debug_level > 0
1264: THEN
1265: oe_debug_pub.ADD
1266: ( 'STARTING LINE FLOW '
1267: || 'LINE ID = '
1268: || oe_globals.g_start_line_flows_tbl (ctr).line_id
1269: );

Line 1278: oe_debug_pub.ADD

1274: AND l_ato_line_id <> l_line_id
1275: THEN
1276: IF l_debug_level > 0
1277: THEN
1278: oe_debug_pub.ADD
1279: ('need to check wf assignment for ato under ato under pto, 3'
1280: );
1281: END IF;
1282:

Line 1317: oe_debug_pub.ADD

1313: WHEN NO_DATA_FOUND
1314: THEN
1315: IF l_debug_level > 0
1316: THEN
1317: oe_debug_pub.ADD
1318: ( 'LINE '
1319: || oe_globals.g_start_line_flows_tbl (ctr).line_id
1320: || ' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE'
1321: );

Line 1355: oe_debug_pub.ADD ('STARTING NEGOTIATE HEADER FLOW');

1351: END IF;
1352:
1353: IF l_debug_level > 0
1354: THEN
1355: oe_debug_pub.ADD ('STARTING NEGOTIATE HEADER FLOW');
1356: END IF;
1357:
1358: -- Start flow and clear global
1359: start_flow (oe_globals.g_wfi_ngo,

Line 1368: oe_debug_pub.ADD

1364: WHEN NO_DATA_FOUND
1365: THEN
1366: IF l_debug_level > 0
1367: THEN
1368: oe_debug_pub.ADD
1369: ( 'Negotiate Header (OENH): '
1370: || oe_globals.g_start_negotiate_header_flow
1371: || ' IS MISSING , BUT ID EXISTS IN GLOBAL'
1372: );

Line 1392: oe_debug_pub.ADD ('STARTING BLANKET HEADER FLOW');

1388: WHERE header_id = oe_globals.g_start_blanket_header_flow;
1389:
1390: IF l_debug_level > 0
1391: THEN
1392: oe_debug_pub.ADD ('STARTING BLANKET HEADER FLOW');
1393: END IF;
1394:
1395: -- Start flow and clear global
1396: start_flow (oe_globals.g_wfi_bkt,

Line 1405: oe_debug_pub.ADD

1401: WHEN NO_DATA_FOUND
1402: THEN
1403: IF l_debug_level > 0
1404: THEN
1405: oe_debug_pub.ADD
1406: ( 'Blanket Header (OEBH): '
1407: || oe_globals.g_start_blanket_header_flow
1408: || ' IS MISSING , BUT ID EXISTS IN GLOBAL'
1409: );

Line 1424: oe_debug_pub.ADD ('EXITING START_ALL_FLOWS');

1420: END IF;
1421:
1422: IF l_debug_level > 0
1423: THEN
1424: oe_debug_pub.ADD ('EXITING START_ALL_FLOWS');
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS
1428: THEN

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

1439:
1440: PROCEDURE clear_flowstart_globals
1441: IS
1442: --
1443: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1444: --
1445: BEGIN
1446: IF l_debug_level > 0
1447: THEN

Line 1448: oe_debug_pub.ADD ('IN CLEAR_FLOWSTART_GLOBALS');

1444: --
1445: BEGIN
1446: IF l_debug_level > 0
1447: THEN
1448: oe_debug_pub.ADD ('IN CLEAR_FLOWSTART_GLOBALS');
1449: END IF;
1450:
1451: oe_globals.g_start_header_flow := NULL;
1452: oe_globals.g_start_negotiate_header_flow := NULL;

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

1461: l_result VARCHAR2 (240);
1462: l_count NUMBER;
1463: l_transaction_phase_code VARCHAR2 (30);
1464: --
1465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1466: --
1467: BEGIN
1468: IF l_debug_level > 0
1469: THEN

Line 1470: oe_debug_pub.ADD ('IN OE_ORDER_WF_UTIL.DELETE_ROW');

1466: --
1467: BEGIN
1468: IF l_debug_level > 0
1469: THEN
1470: oe_debug_pub.ADD ('IN OE_ORDER_WF_UTIL.DELETE_ROW');
1471: END IF;
1472:
1473: IF p_type = 'HEADER'
1474: THEN

Line 1552: oe_debug_pub.ADD ('PURGING WF ITEM');

1548: END IF;
1549:
1550: IF l_debug_level > 0
1551: THEN
1552: oe_debug_pub.ADD ('PURGING WF ITEM');
1553: END IF;
1554:
1555: wf_purge.items (itemtype => oe_globals.g_wfi_lin,
1556: itemkey => p_id,

Line 1588: oe_debug_pub.ADD ('PURGING WF ITEM - Negotiate');

1584: END IF;
1585:
1586: IF l_debug_level > 0
1587: THEN
1588: oe_debug_pub.ADD ('PURGING WF ITEM - Negotiate');
1589: END IF;
1590:
1591: wf_purge.items (itemtype => oe_globals.g_wfi_ngo,
1592: itemkey => p_id,

Line 1625: oe_debug_pub.ADD ('PURGING WF ITEM - BLANKET');

1621: END IF;
1622:
1623: IF l_debug_level > 0
1624: THEN
1625: oe_debug_pub.ADD ('PURGING WF ITEM - BLANKET');
1626: END IF;
1627:
1628: wf_purge.items (itemtype => oe_globals.g_wfi_bkt,
1629: itemkey => p_id,

Line 1654: oe_debug_pub.ADD

1650: END IF; --13020709
1651: ELSE
1652: IF l_debug_level > 0
1653: THEN
1654: oe_debug_pub.ADD
1655: ('OE_ORDER_WF_UTIL: DELETE TYPE NOT IN HEADER,LINE,NEGOTIATE,BLANKET'
1656: );
1657: END IF;
1658:

Line 1668: oe_debug_pub.ADD ('EXITING OE_ORDER_WF_UTIL.DELETE_ROW');

1664: END IF;
1665:
1666: IF l_debug_level > 0
1667: THEN
1668: oe_debug_pub.ADD ('EXITING OE_ORDER_WF_UTIL.DELETE_ROW');
1669: END IF;
1670: END delete_row;
1671:
1672: PROCEDURE update_flow_status_code (

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

1698: l_msg_count NUMBER;
1699: l_msg_data VARCHAR2 (2000);
1700: l_itemkey_sso NUMBER; -- GENESIS
1701: --
1702: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1703: --
1704: l_line_rec oe_order_pub.line_rec_type; --OIP ER
1705:
1706: CURSOR lines

Line 1718: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);

1714: l_lock_control NUMBER;
1715: BEGIN
1716: IF l_debug_level > 0
1717: THEN
1718: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
1719: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
1720: || oe_order_util.g_recursion_without_exception
1721: );
1722: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'

Line 1719: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '

1715: BEGIN
1716: IF l_debug_level > 0
1717: THEN
1718: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
1719: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
1720: || oe_order_util.g_recursion_without_exception
1721: );
1722: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
1723: || oe_order_cache.g_header_rec.booked_flag

Line 1722: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'

1718: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
1719: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
1720: || oe_order_util.g_recursion_without_exception
1721: );
1722: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
1723: || oe_order_cache.g_header_rec.booked_flag
1724: );
1725: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
1726: || oe_order_util.g_header_rec.booked_flag

Line 1725: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'

1721: );
1722: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
1723: || oe_order_cache.g_header_rec.booked_flag
1724: );
1725: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
1726: || oe_order_util.g_header_rec.booked_flag
1727: );
1728: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
1729: || oe_order_util.g_line_tbl.COUNT

Line 1728: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '

1724: );
1725: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
1726: || oe_order_util.g_header_rec.booked_flag
1727: );
1728: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
1729: || oe_order_util.g_line_tbl.COUNT
1730: );
1731: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
1732: || oe_order_util.g_old_line_tbl.COUNT

Line 1731: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '

1727: );
1728: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
1729: || oe_order_util.g_line_tbl.COUNT
1730: );
1731: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
1732: || oe_order_util.g_old_line_tbl.COUNT
1733: );
1734: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
1735: || oe_order_util.g_line_adj_tbl.COUNT

Line 1734: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '

1730: );
1731: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
1732: || oe_order_util.g_old_line_tbl.COUNT
1733: );
1734: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
1735: || oe_order_util.g_line_adj_tbl.COUNT
1736: );
1737: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
1738: || oe_order_util.g_old_line_adj_tbl.COUNT

Line 1737: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '

1733: );
1734: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
1735: || oe_order_util.g_line_adj_tbl.COUNT
1736: );
1737: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
1738: || oe_order_util.g_old_line_adj_tbl.COUNT
1739: );
1740: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
1741: || oe_order_util.g_header_adj_tbl.COUNT

Line 1740: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '

1736: );
1737: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
1738: || oe_order_util.g_old_line_adj_tbl.COUNT
1739: );
1740: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
1741: || oe_order_util.g_header_adj_tbl.COUNT
1742: );
1743: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
1744: || oe_order_util.g_old_header_adj_tbl.COUNT

Line 1743: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '

1739: );
1740: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
1741: || oe_order_util.g_header_adj_tbl.COUNT
1742: );
1743: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
1744: || oe_order_util.g_old_header_adj_tbl.COUNT
1745: );
1746: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
1747: || oe_order_util.g_header_scredit_tbl.COUNT

Line 1746: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '

1742: );
1743: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
1744: || oe_order_util.g_old_header_adj_tbl.COUNT
1745: );
1746: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
1747: || oe_order_util.g_header_scredit_tbl.COUNT
1748: );
1749: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
1750: || oe_order_util.g_old_header_scredit_tbl.COUNT

Line 1749: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '

1745: );
1746: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
1747: || oe_order_util.g_header_scredit_tbl.COUNT
1748: );
1749: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
1750: || oe_order_util.g_old_header_scredit_tbl.COUNT
1751: );
1752: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
1753: || oe_order_util.g_line_scredit_tbl.COUNT

Line 1752: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '

1748: );
1749: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
1750: || oe_order_util.g_old_header_scredit_tbl.COUNT
1751: );
1752: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
1753: || oe_order_util.g_line_scredit_tbl.COUNT
1754: );
1755: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
1756: || oe_order_util.g_old_line_scredit_tbl.COUNT

Line 1755: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '

1751: );
1752: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
1753: || oe_order_util.g_line_scredit_tbl.COUNT
1754: );
1755: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
1756: || oe_order_util.g_old_line_scredit_tbl.COUNT
1757: );
1758: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
1759: || oe_order_util.g_lot_serial_tbl.COUNT

Line 1758: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '

1754: );
1755: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
1756: || oe_order_util.g_old_line_scredit_tbl.COUNT
1757: );
1758: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
1759: || oe_order_util.g_lot_serial_tbl.COUNT
1760: );
1761: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '
1762: || oe_order_util.g_old_lot_serial_tbl.COUNT

Line 1761: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '

1757: );
1758: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
1759: || oe_order_util.g_lot_serial_tbl.COUNT
1760: );
1761: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '
1762: || oe_order_util.g_old_lot_serial_tbl.COUNT
1763: );
1764: END IF;
1765:

Line 1803: oe_debug_pub.ADD

1799: IF p_sales_document_type_code = 'O'
1800: THEN
1801: IF l_debug_level > 0
1802: THEN
1803: oe_debug_pub.ADD
1804: ( 'Update_Flow_Status_Code for Quote:'
1805: || p_flow_status_code,
1806: 5
1807: );

Line 1894: oe_debug_pub.ADD

1890: );
1891:
1892: IF l_debug_level > 0
1893: THEN
1894: oe_debug_pub.ADD
1895: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
1896: || l_return_status
1897: );
1898: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

Line 1898: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

1894: oe_debug_pub.ADD
1895: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
1896: || l_return_status
1897: );
1898: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
1899: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '
1900: || p_flow_status_code,
1901: 1
1902: );

Line 1899: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '

1895: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
1896: || l_return_status
1897: );
1898: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
1899: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '
1900: || p_flow_status_code,
1901: 1
1902: );
1903: END IF;

Line 1924: oe_debug_pub.ADD

1920: oe_globals.g_opr_update;
1921:
1922: IF l_debug_level > 0
1923: THEN
1924: oe_debug_pub.ADD
1925: ( 'GLOBAL HEADER FLOW STATUS IS: '
1926: || oe_order_util.g_header_rec.flow_status_code,
1927: 1
1928: );

Line 1929: oe_debug_pub.ADD

1925: ( 'GLOBAL HEADER FLOW STATUS IS: '
1926: || oe_order_util.g_header_rec.flow_status_code,
1927: 1
1928: );
1929: oe_debug_pub.ADD
1930: ( 'GLOBAL HEADER OPERATION IS: '
1931: || oe_order_util.g_header_rec.operation,
1932: 1
1933: );

Line 1940: oe_debug_pub.ADD

1936:
1937: -- bug 4732614
1938: IF l_debug_level > 0
1939: THEN
1940: oe_debug_pub.ADD
1941: ('OEXUOWFB.pls: Calling Process_Requests_And_Notify......',
1942: 1
1943: );
1944: END IF;

Line 1956: oe_debug_pub.ADD

1952: IF l_return_status = fnd_api.g_ret_sts_error
1953: THEN
1954: IF l_debug_level > 0
1955: THEN
1956: oe_debug_pub.ADD
1957: ( 'Process_Requests_And_Notify,return_status='
1958: || l_return_status
1959: || ',Raising FND_API.G_EXC_ERROR exception',
1960: 2

Line 1969: oe_debug_pub.ADD

1965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1966: THEN
1967: IF l_debug_level > 0
1968: THEN
1969: oe_debug_pub.ADD
1970: ( 'Process_Requests_And_Notify,return_status='
1971: || l_return_status
1972: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
1973: 2

Line 1983: oe_debug_pub.ADD

1979: ELSIF p_sales_document_type_code = 'B'
1980: THEN -- Blanket Negotitation
1981: IF l_debug_level > 0
1982: THEN
1983: oe_debug_pub.ADD
1984: ( 'Update_Flow_Status_Code for Blanket Negotiation:'
1985: || p_flow_status_code,
1986: 5
1987: );

Line 2030: oe_debug_pub.ADD

2026: ELSIF p_item_type = oe_globals.g_wfi_bkt
2027: THEN
2028: IF l_debug_level > 0
2029: THEN
2030: oe_debug_pub.ADD
2031: ( 'Update_Flow_Status_Code for Blanket Fulfillment:'
2032: || p_flow_status_code,
2033: 5
2034: );

Line 2207: oe_debug_pub.ADD

2203: WHERE line_id = p_line_id;
2204:
2205: IF (l_debug_level > 0)
2206: THEN
2207: oe_debug_pub.ADD
2208: ( 'Calling raise business Event for SCCC p_header_id :'
2209: || p_header_id
2210: || ' line_id :'
2211: || p_line_id

Line 2252: oe_debug_pub.ADD

2248: );
2249:
2250: IF l_debug_level > 0
2251: THEN
2252: oe_debug_pub.ADD
2253: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE LINE FLOW STATUS CODE IS: '
2254: || l_return_status
2255: );
2256: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

Line 2256: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

2252: oe_debug_pub.ADD
2253: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE LINE FLOW STATUS CODE IS: '
2254: || l_return_status
2255: );
2256: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
2257: END IF;
2258:
2259: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
2260: IF (l_return_status <> fnd_api.g_ret_sts_success)

Line 2259: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);

2255: );
2256: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
2257: END IF;
2258:
2259: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
2260: IF (l_return_status <> fnd_api.g_ret_sts_success)
2261: THEN
2262: RAISE fnd_api.g_exc_unexpected_error;
2263: END IF;

Line 2296: oe_debug_pub.ADD

2292: oe_globals.g_opr_update;
2293:
2294: IF l_debug_level > 0
2295: THEN
2296: oe_debug_pub.ADD
2297: ( 'GLOBAL LINE FLOW STATUS IS: '
2298: || oe_order_util.g_line_tbl (l_index).flow_status_code,
2299: 1
2300: );

Line 2301: oe_debug_pub.ADD

2297: ( 'GLOBAL LINE FLOW STATUS IS: '
2298: || oe_order_util.g_line_tbl (l_index).flow_status_code,
2299: 1
2300: );
2301: oe_debug_pub.ADD
2302: ( 'GLOBAL LINE OPERATION IS: '
2303: || oe_order_util.g_line_tbl (l_index).operation,
2304: 1
2305: );

Line 2312: oe_debug_pub.ADD

2308:
2309: -- bug 4732614
2310: IF l_debug_level > 0
2311: THEN
2312: oe_debug_pub.ADD
2313: ('OEXUOWFB.pls: Calling Process_Requests_And_Notify......',
2314: 1
2315: );
2316: END IF;

Line 2328: oe_debug_pub.ADD

2324: IF l_return_status = fnd_api.g_ret_sts_error
2325: THEN
2326: IF l_debug_level > 0
2327: THEN
2328: oe_debug_pub.ADD
2329: ( 'Process_Requests_And_Notify,return_status='
2330: || l_return_status
2331: || ',Raising FND_API.G_EXC_ERROR exception',
2332: 2

Line 2341: oe_debug_pub.ADD

2337: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2338: THEN
2339: IF l_debug_level > 0
2340: THEN
2341: oe_debug_pub.ADD
2342: ( 'Process_Requests_And_Notify,return_status='
2343: || l_return_status
2344: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
2345: 2

Line 2363: oe_debug_pub.ADD

2359: * sources. *
2360: ***********************************************************/
2361: IF l_debug_level > 0
2362: THEN
2363: oe_debug_pub.ADD
2364: ( ' GENESIS : UPDATE FLOW STATUS - p_header_id: '
2365: || p_header_id
2366: );
2367: oe_debug_pub.ADD

Line 2367: oe_debug_pub.ADD

2363: oe_debug_pub.ADD
2364: ( ' GENESIS : UPDATE FLOW STATUS - p_header_id: '
2365: || p_header_id
2366: );
2367: oe_debug_pub.ADD
2368: ( ' GENESIS : UPDATE FLOW STATUS - p_line_id: '
2369: || p_line_id
2370: );
2371: oe_debug_pub.ADD

Line 2371: oe_debug_pub.ADD

2367: oe_debug_pub.ADD
2368: ( ' GENESIS : UPDATE FLOW STATUS - p_line_id: '
2369: || p_line_id
2370: );
2371: oe_debug_pub.ADD
2372: ( ' GENESIS : UPDATE FLOW STATUS - l_header_rec.order_source_id: '
2373: || l_header_rec.order_source_id
2374: );
2375: oe_debug_pub.ADD

Line 2375: oe_debug_pub.ADD

2371: oe_debug_pub.ADD
2372: ( ' GENESIS : UPDATE FLOW STATUS - l_header_rec.order_source_id: '
2373: || l_header_rec.order_source_id
2374: );
2375: oe_debug_pub.ADD
2376: ( ' GENESIS : UPDATE FLOW STATUS - l_order_source_id: '
2377: || l_order_source_id
2378: );
2379: oe_debug_pub.ADD

Line 2379: oe_debug_pub.ADD

2375: oe_debug_pub.ADD
2376: ( ' GENESIS : UPDATE FLOW STATUS - l_order_source_id: '
2377: || l_order_source_id
2378: );
2379: oe_debug_pub.ADD
2380: ( ' GENESIS : UPDATE FLOW STATUS - l_line_tbl(1).order_source_id: '
2381: || l_line_tbl (1).order_source_id
2382: );
2383: oe_debug_pub.ADD

Line 2383: oe_debug_pub.ADD

2379: oe_debug_pub.ADD
2380: ( ' GENESIS : UPDATE FLOW STATUS - l_line_tbl(1).order_source_id: '
2381: || l_line_tbl (1).order_source_id
2382: );
2383: oe_debug_pub.ADD
2384: ( ' GENESIS : UPDATE FLOW STATUS - l_line_tbl(1).header_id: '
2385: || l_line_tbl (1).header_id
2386: );
2387: oe_debug_pub.ADD

Line 2387: oe_debug_pub.ADD

2383: oe_debug_pub.ADD
2384: ( ' GENESIS : UPDATE FLOW STATUS - l_line_tbl(1).header_id: '
2385: || l_line_tbl (1).header_id
2386: );
2387: oe_debug_pub.ADD
2388: ( ' GENESIS : UPDATE FLOW STATUS - g_aso_installed: '
2389: || oe_globals.g_aso_installed
2390: );
2391: oe_debug_pub.ADD

Line 2391: oe_debug_pub.ADD

2387: oe_debug_pub.ADD
2388: ( ' GENESIS : UPDATE FLOW STATUS - g_aso_installed: '
2389: || oe_globals.g_aso_installed
2390: );
2391: oe_debug_pub.ADD
2392: ( ' GENESIS : UPDATE FLOW STATUS - DBI Installed: '
2393: || NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),
2394: 'No.'
2395: )

Line 2397: oe_debug_pub.ADD

2393: || NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),
2394: 'No.'
2395: )
2396: );
2397: oe_debug_pub.ADD
2398: ( ' GENESIS : UPDATE FLOW STATUS - p_flow_status_code: '
2399: || p_flow_status_code
2400: );
2401: END IF;

Line 2447: oe_debug_pub.ADD

2443: FROM DUAL;
2444:
2445: IF l_debug_level > 0
2446: THEN
2447: oe_debug_pub.ADD
2448: ( ' GENESIS : UPDATE FLOW STATUS - l_itemkey_sso'
2449: || l_itemkey_sso
2450: );
2451: END IF;

Line 2455: oe_debug_pub.ADD (' GENESIS : UPDATE FLOW STATUS');

2451: END IF;
2452:
2453: IF l_debug_level > 0
2454: THEN
2455: oe_debug_pub.ADD (' GENESIS : UPDATE FLOW STATUS');
2456: END IF;
2457:
2458: oe_sync_order_pvt.insert_sync_line
2459: (p_line_rec => l_line_tbl

Line 2509: oe_debug_pub.ADD

2505: );
2506:
2507: IF l_debug_level > 0
2508: THEN
2509: oe_debug_pub.ADD
2510: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
2511: || l_return_status
2512: );
2513: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

Line 2513: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

2509: oe_debug_pub.ADD
2510: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
2511: || l_return_status
2512: );
2513: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
2514: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '
2515: || p_flow_status_code,
2516: 1
2517: );

Line 2514: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '

2510: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
2511: || l_return_status
2512: );
2513: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
2514: oe_debug_pub.ADD ( 'HEADER FLOW STATUS IS: '
2515: || p_flow_status_code,
2516: 1
2517: );
2518: END IF;

Line 2538: oe_debug_pub.ADD

2534: oe_globals.g_opr_update;
2535:
2536: IF l_debug_level > 0
2537: THEN
2538: oe_debug_pub.ADD
2539: ( 'GLOBAL HEADER FLOW STATUS IS: '
2540: || oe_order_util.g_header_rec.flow_status_code,
2541: 1
2542: );

Line 2543: oe_debug_pub.ADD ( 'GLOBAL HEADER OPERATION IS: '

2539: ( 'GLOBAL HEADER FLOW STATUS IS: '
2540: || oe_order_util.g_header_rec.flow_status_code,
2541: 1
2542: );
2543: oe_debug_pub.ADD ( 'GLOBAL HEADER OPERATION IS: '
2544: || oe_order_util.g_header_rec.operation,
2545: 1
2546: );
2547: END IF;

Line 2553: oe_debug_pub.ADD

2549:
2550: -- bug 4732614
2551: IF l_debug_level > 0
2552: THEN
2553: oe_debug_pub.ADD
2554: ('OEXUOWFB.pls: Calling Process_Requests_And_Notify......',
2555: 1
2556: );
2557: END IF;

Line 2569: oe_debug_pub.ADD

2565: IF l_return_status = fnd_api.g_ret_sts_error
2566: THEN
2567: IF l_debug_level > 0
2568: THEN
2569: oe_debug_pub.ADD
2570: ( 'Process_Requests_And_Notify,return_status='
2571: || l_return_status
2572: || ',Raising FND_API.G_EXC_ERROR exception',
2573: 2

Line 2582: oe_debug_pub.ADD

2578: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2579: THEN
2580: IF l_debug_level > 0
2581: THEN
2582: oe_debug_pub.ADD
2583: ( 'Process_Requests_And_Notify,return_status='
2584: || l_return_status
2585: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
2586: 2

Line 2595: oe_debug_pub.ADD

2591: END IF; -- bug 4732614 ends
2592: ELSE
2593: IF l_debug_level > 0
2594: THEN
2595: oe_debug_pub.ADD
2596: ('UPDATE_FLOW_STATUS_CODE: HEADER_ID AND LINE_ID ARE NULL');
2597: END IF;
2598:
2599: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2608: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);

2604: oe_pc_constraints_admin_pvt.clear_cached_results;
2605:
2606: IF l_debug_level > 0
2607: THEN
2608: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
2609: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
2610: || oe_order_util.g_recursion_without_exception
2611: );
2612: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'

Line 2609: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '

2605:
2606: IF l_debug_level > 0
2607: THEN
2608: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
2609: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
2610: || oe_order_util.g_recursion_without_exception
2611: );
2612: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
2613: || oe_order_cache.g_header_rec.booked_flag

Line 2612: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'

2608: oe_debug_pub.ADD ('ENTERING UPDATE_FLOW_STATUS_CODE', 5);
2609: oe_debug_pub.ADD ( 'UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: '
2610: || oe_order_util.g_recursion_without_exception
2611: );
2612: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
2613: || oe_order_cache.g_header_rec.booked_flag
2614: );
2615: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
2616: || oe_order_util.g_header_rec.booked_flag

Line 2615: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'

2611: );
2612: oe_debug_pub.ADD ( 'UFSC: GLOBAL CACHE BOOKED FLAG'
2613: || oe_order_cache.g_header_rec.booked_flag
2614: );
2615: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
2616: || oe_order_util.g_header_rec.booked_flag
2617: );
2618: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
2619: || oe_order_util.g_line_tbl.COUNT

Line 2618: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '

2614: );
2615: oe_debug_pub.ADD ( 'UFSC: GLOBAL PICTURE HEADER BOOKED FLAG'
2616: || oe_order_util.g_header_rec.booked_flag
2617: );
2618: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
2619: || oe_order_util.g_line_tbl.COUNT
2620: );
2621: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
2622: || oe_order_util.g_old_line_tbl.COUNT

Line 2621: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '

2617: );
2618: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE TABLE= '
2619: || oe_order_util.g_line_tbl.COUNT
2620: );
2621: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
2622: || oe_order_util.g_old_line_tbl.COUNT
2623: );
2624: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
2625: || oe_order_util.g_line_adj_tbl.COUNT

Line 2624: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '

2620: );
2621: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE TABLE= '
2622: || oe_order_util.g_old_line_tbl.COUNT
2623: );
2624: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
2625: || oe_order_util.g_line_adj_tbl.COUNT
2626: );
2627: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
2628: || oe_order_util.g_old_line_adj_tbl.COUNT

Line 2627: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '

2623: );
2624: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE ADJ TABLE= '
2625: || oe_order_util.g_line_adj_tbl.COUNT
2626: );
2627: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
2628: || oe_order_util.g_old_line_adj_tbl.COUNT
2629: );
2630: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
2631: || oe_order_util.g_header_adj_tbl.COUNT

Line 2630: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '

2626: );
2627: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE ADJ TABLE= '
2628: || oe_order_util.g_old_line_adj_tbl.COUNT
2629: );
2630: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
2631: || oe_order_util.g_header_adj_tbl.COUNT
2632: );
2633: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
2634: || oe_order_util.g_old_header_adj_tbl.COUNT

Line 2633: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '

2629: );
2630: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR ADJ TABLE= '
2631: || oe_order_util.g_header_adj_tbl.COUNT
2632: );
2633: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
2634: || oe_order_util.g_old_header_adj_tbl.COUNT
2635: );
2636: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
2637: || oe_order_util.g_header_scredit_tbl.COUNT

Line 2636: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '

2632: );
2633: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR ADJ TABLE= '
2634: || oe_order_util.g_old_header_adj_tbl.COUNT
2635: );
2636: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
2637: || oe_order_util.g_header_scredit_tbl.COUNT
2638: );
2639: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
2640: || oe_order_util.g_old_header_scredit_tbl.COUNT

Line 2639: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '

2635: );
2636: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW HDR SCREDIT TABLE= '
2637: || oe_order_util.g_header_scredit_tbl.COUNT
2638: );
2639: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
2640: || oe_order_util.g_old_header_scredit_tbl.COUNT
2641: );
2642: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
2643: || oe_order_util.g_line_scredit_tbl.COUNT

Line 2642: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '

2638: );
2639: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD HDR SCREDIT TABLE= '
2640: || oe_order_util.g_old_header_scredit_tbl.COUNT
2641: );
2642: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
2643: || oe_order_util.g_line_scredit_tbl.COUNT
2644: );
2645: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
2646: || oe_order_util.g_old_line_scredit_tbl.COUNT

Line 2645: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '

2641: );
2642: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LINE SCREDIT TABLE= '
2643: || oe_order_util.g_line_scredit_tbl.COUNT
2644: );
2645: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
2646: || oe_order_util.g_old_line_scredit_tbl.COUNT
2647: );
2648: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
2649: || oe_order_util.g_lot_serial_tbl.COUNT

Line 2648: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '

2644: );
2645: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LINE SCREDIT TABLE= '
2646: || oe_order_util.g_old_line_scredit_tbl.COUNT
2647: );
2648: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
2649: || oe_order_util.g_lot_serial_tbl.COUNT
2650: );
2651: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '
2652: || oe_order_util.g_old_lot_serial_tbl.COUNT

Line 2651: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '

2647: );
2648: oe_debug_pub.ADD ( 'UFSC: COUNT OF NEW LOT SERIAL TABLE= '
2649: || oe_order_util.g_lot_serial_tbl.COUNT
2650: );
2651: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '
2652: || oe_order_util.g_old_lot_serial_tbl.COUNT
2653: );
2654: oe_debug_pub.ADD ('EXITING UPDATE_FLOW_STATUS_CODE', 5);
2655: END IF;

Line 2654: oe_debug_pub.ADD ('EXITING UPDATE_FLOW_STATUS_CODE', 5);

2650: );
2651: oe_debug_pub.ADD ( 'UFSC: COUNT OF OLD LOT SERIAL TABLE= '
2652: || oe_order_util.g_old_lot_serial_tbl.COUNT
2653: );
2654: oe_debug_pub.ADD ('EXITING UPDATE_FLOW_STATUS_CODE', 5);
2655: END IF;
2656: EXCEPTION
2657: WHEN NO_DATA_FOUND
2658: THEN

Line 2663: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: NO_DATA_FOUND');

2659: ROLLBACK TO update_flow_status_code;
2660:
2661: IF l_debug_level > 0
2662: THEN
2663: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: NO_DATA_FOUND');
2664: END IF;
2665:
2666: IF p_line_id IS NOT NULL
2667: THEN

Line 2679: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: ERROR', 5);

2675: ROLLBACK TO update_flow_status_code;
2676:
2677: IF l_debug_level > 0
2678: THEN
2679: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: ERROR', 5);
2680: END IF;
2681:
2682: x_return_status := fnd_api.g_ret_sts_error;
2683:

Line 2697: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: LOCK EXC', 5);

2693: ROLLBACK TO update_flow_status_code;
2694:
2695: IF l_debug_level > 0
2696: THEN
2697: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: LOCK EXC', 5);
2698: END IF;
2699:
2700: x_return_status := fnd_api.g_ret_sts_error;
2701:

Line 2721: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: UNEXP ERROR', 5);

2717: ROLLBACK TO update_flow_status_code;
2718:
2719: IF l_debug_level > 0
2720: THEN
2721: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: UNEXP ERROR', 5);
2722: END IF;
2723:
2724: x_return_status := fnd_api.g_ret_sts_unexp_error;
2725:

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

2749: v_value VARCHAR2 (240);
2750: l_type VARCHAR2 (30);
2751: v_header_id NUMBER;
2752: --
2753: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2754: --
2755: BEGIN
2756: --
2757: -- RUN mode - normal process execution

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

2900: l_index NUMBER;
2901: l_blanket_lock_control NUMBER;
2902: l_msg_count NUMBER;
2903: l_msg_data VARCHAR2 (2000);
2904: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2905: l_updated_flag VARCHAR2 (1) := 'N';
2906: l_sales_document_type_code VARCHAR2 (30);
2907: l_line_id NUMBER;
2908: l_lock_control NUMBER;

Line 2926: oe_debug_pub.ADD ('ENTERING UPDATE_QUOTE_BLANKET', 5);

2922: FOR UPDATE NOWAIT;
2923: BEGIN
2924: IF l_debug_level > 0
2925: THEN
2926: oe_debug_pub.ADD ('ENTERING UPDATE_QUOTE_BLANKET', 5);
2927: END IF;
2928:
2929: SAVEPOINT update_quote_blanket;
2930: x_return_status := fnd_api.g_ret_sts_success;

Line 3101: oe_debug_pub.ADD

3097: );
3098:
3099: IF l_debug_level > 0
3100: THEN
3101: oe_debug_pub.ADD
3102: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
3103: || l_return_status
3104: );
3105: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

Line 3105: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);

3101: oe_debug_pub.ADD
3102: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
3103: || l_return_status
3104: );
3105: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
3106: oe_debug_pub.ADD ('HEADER FLOW STATUS IS: ' || p_flow_status_code,
3107: 1
3108: );
3109: END IF;

Line 3106: oe_debug_pub.ADD ('HEADER FLOW STATUS IS: ' || p_flow_status_code,

3102: ( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: '
3103: || l_return_status
3104: );
3105: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
3106: oe_debug_pub.ADD ('HEADER FLOW STATUS IS: ' || p_flow_status_code,
3107: 1
3108: );
3109: END IF;
3110:

Line 3144: oe_debug_pub.ADD ( 'GLOBAL HEADER FLOW STATUS IS: '

3140: oe_order_util.g_header_rec.operation := oe_globals.g_opr_update;
3141:
3142: IF l_debug_level > 0
3143: THEN
3144: oe_debug_pub.ADD ( 'GLOBAL HEADER FLOW STATUS IS: '
3145: || oe_order_util.g_header_rec.flow_status_code,
3146: 1
3147: );
3148: oe_debug_pub.ADD ( 'GLOBAL HEADER OPEN_FLAG IS: '

Line 3148: oe_debug_pub.ADD ( 'GLOBAL HEADER OPEN_FLAG IS: '

3144: oe_debug_pub.ADD ( 'GLOBAL HEADER FLOW STATUS IS: '
3145: || oe_order_util.g_header_rec.flow_status_code,
3146: 1
3147: );
3148: oe_debug_pub.ADD ( 'GLOBAL HEADER OPEN_FLAG IS: '
3149: || oe_order_util.g_header_rec.open_flag,
3150: 1
3151: );
3152: oe_debug_pub.ADD

Line 3152: oe_debug_pub.ADD

3148: oe_debug_pub.ADD ( 'GLOBAL HEADER OPEN_FLAG IS: '
3149: || oe_order_util.g_header_rec.open_flag,
3150: 1
3151: );
3152: oe_debug_pub.ADD
3153: ( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: '
3154: || oe_order_util.g_header_rec.draft_submitted_flag,
3155: 1
3156: );

Line 3157: oe_debug_pub.ADD ( 'GLOBAL HEADER OPERATION IS: '

3153: ( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: '
3154: || oe_order_util.g_header_rec.draft_submitted_flag,
3155: 1
3156: );
3157: oe_debug_pub.ADD ( 'GLOBAL HEADER OPERATION IS: '
3158: || oe_order_util.g_header_rec.operation,
3159: 1
3160: );
3161: END IF;

Line 3167: oe_debug_pub.ADD

3163:
3164: -- bug 4732614
3165: IF l_debug_level > 0
3166: THEN
3167: oe_debug_pub.ADD
3168: ('OEXUOWFB.pls: Calling Process_Requests_And_Notify......',
3169: 1
3170: );
3171: END IF;

Line 3183: oe_debug_pub.ADD

3179: IF l_return_status = fnd_api.g_ret_sts_error
3180: THEN
3181: IF l_debug_level > 0
3182: THEN
3183: oe_debug_pub.ADD
3184: ( 'Process_Requests_And_Notify,return_status='
3185: || l_return_status
3186: || ',Raising FND_API.G_EXC_ERROR exception',
3187: 2

Line 3196: oe_debug_pub.ADD

3192: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
3193: THEN
3194: IF l_debug_level > 0
3195: THEN
3196: oe_debug_pub.ADD
3197: ( 'Process_Requests_And_Notify,return_status='
3198: || l_return_status
3199: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
3200: 2

Line 3259: oe_debug_pub.ADD ('Acquiring locks on blanket lines');

3255: last_update_login = fnd_global.login_id
3256: WHERE header_id = l_header_id;
3257:
3258: -- ZB put the code here
3259: oe_debug_pub.ADD ('Acquiring locks on blanket lines');
3260:
3261: OPEN blanket_lines;
3262:
3263: LOOP

Line 3272: oe_debug_pub.ADD ('Updating blanket lines 4 open flag');

3268: END LOOP;
3269:
3270: CLOSE blanket_lines;
3271:
3272: oe_debug_pub.ADD ('Updating blanket lines 4 open flag');
3273:
3274: UPDATE oe_blanket_lines_all
3275: SET open_flag = p_open_flag,
3276: -- Bug 12849250

Line 3312: oe_debug_pub.ADD ('EXITING UPDATE_QUOTE_BLANKET', 5);

3308: oe_pc_constraints_admin_pvt.clear_cached_results;
3309:
3310: IF l_debug_level > 0
3311: THEN
3312: oe_debug_pub.ADD ('EXITING UPDATE_QUOTE_BLANKET', 5);
3313: END IF;
3314: EXCEPTION
3315: WHEN NO_DATA_FOUND
3316: THEN

Line 3321: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: NO_DATA_FOUND');

3317: ROLLBACK TO update_quote_blanket;
3318:
3319: IF l_debug_level > 0
3320: THEN
3321: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: NO_DATA_FOUND');
3322: END IF;
3323:
3324: x_return_status := fnd_api.g_ret_sts_error;
3325:

Line 3336: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: ERROR', 5);

3332: ROLLBACK TO update_quote_blanket;
3333:
3334: IF l_debug_level > 0
3335: THEN
3336: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: ERROR', 5);
3337: END IF;
3338:
3339: x_return_status := fnd_api.g_ret_sts_error;
3340:

Line 3351: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: LOCK EXC', 5);

3347: ROLLBACK TO update_quote_blanket;
3348:
3349: IF l_debug_level > 0
3350: THEN
3351: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: LOCK EXC', 5);
3352: END IF;
3353:
3354: x_return_status := fnd_api.g_ret_sts_error;
3355:

Line 3372: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: UNEXP ERROR', 5);

3368: ROLLBACK TO update_quote_blanket;
3369:
3370: IF l_debug_level > 0
3371: THEN
3372: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: UNEXP ERROR', 5);
3373: END IF;
3374:
3375: x_return_status := fnd_api.g_ret_sts_unexp_error;
3376:

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

3414: l_user_name VARCHAR2 (100);
3415: l_validate_user NUMBER;
3416: l_owner_role VARCHAR2 (100);
3417: --
3418: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3419: --
3420: BEGIN
3421: IF l_debug_level > 0
3422: THEN

Line 3423: oe_debug_pub.ADD

3419: --
3420: BEGIN
3421: IF l_debug_level > 0
3422: THEN
3423: oe_debug_pub.ADD
3424: ( 'Entering Create_WorkItem_Upgrade. item_type/item_key='
3425: || p_item_type
3426: || '/'
3427: || p_item_key,

Line 3443: oe_debug_pub.ADD ('process_name: ' || l_valid_process, 4);

3439: AND end_date IS NULL;
3440:
3441: IF l_debug_level > 0
3442: THEN
3443: oe_debug_pub.ADD ('process_name: ' || l_valid_process, 4);
3444: END IF;
3445:
3446: IF p_sales_document_type_code = 'O'
3447: THEN

Line 3474: oe_debug_pub.ADD ('After WF_ENGINE.CreateProcess', 4);

3470: );
3471:
3472: IF l_debug_level > 0
3473: THEN
3474: oe_debug_pub.ADD ('After WF_ENGINE.CreateProcess', 4);
3475: END IF;
3476:
3477: -- Set various Header Attributes
3478: l_aname (1) := 'USER_ID';

Line 3496: oe_debug_pub.ADD ('EXITING CREATE_WORKITEM_UPGRADE', 4);

3492: );
3493:
3494: IF l_debug_level > 0
3495: THEN
3496: oe_debug_pub.ADD ('EXITING CREATE_WORKITEM_UPGRADE', 4);
3497: END IF;
3498: EXCEPTION
3499: WHEN OTHERS
3500: THEN

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

3512: p_sales_document_type_code IN VARCHAR2
3513: )
3514: IS
3515: --
3516: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3517: l_count NUMBER;
3518: --
3519: BEGIN
3520: IF l_debug_level > 0

Line 3522: oe_debug_pub.ADD ('IN CREATESTART_HDRINTERNAL');

3518: --
3519: BEGIN
3520: IF l_debug_level > 0
3521: THEN
3522: oe_debug_pub.ADD ('IN CREATESTART_HDRINTERNAL');
3523: END IF;
3524:
3525: create_hdrworkiteminternal (p_item_type,
3526: p_header_id,

Line 3561: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESSINTERNAL');

3557: oe_globals.g_sales_document_type_code := p_sales_document_type_code;
3558:
3559: IF l_debug_level > 0
3560: THEN
3561: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESSINTERNAL');
3562: END IF;
3563: EXCEPTION
3564: WHEN fnd_api.g_exc_error
3565: THEN

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

3595: l_validate_user NUMBER;
3596: l_sales_document_type VARCHAR2 (240);
3597: l_owner_role VARCHAR2 (100);
3598: --
3599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3600: --
3601: BEGIN
3602: IF l_debug_level > 0
3603: THEN

Line 3604: oe_debug_pub.ADD

3600: --
3601: BEGIN
3602: IF l_debug_level > 0
3603: THEN
3604: oe_debug_pub.ADD
3605: ( 'IN CREATE_HDRWORKITEMINTERNAL, ITEM_TYPE/ITEM_KEY='
3606: || p_item_type
3607: || '/'
3608: || TO_CHAR (p_header_id)

Line 3621: oe_debug_pub.ADD ('Get ProcessName: ' || l_hdr_process_name);

3617: );
3618:
3619: IF l_debug_level > 0
3620: THEN
3621: oe_debug_pub.ADD ('Get ProcessName: ' || l_hdr_process_name);
3622: END IF;
3623:
3624: -- set user key
3625: IF p_sales_document_type_code = 'O'

Line 3652: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

3648: );
3649:
3650: IF l_debug_level > 0
3651: THEN
3652: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
3653: END IF;
3654:
3655: -- Set various Header Attributes
3656: l_aname (1) := 'USER_ID';

Line 3717: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEMINTERNAL');

3713: END IF; -- only need to set text item attr if it is OENH
3714:
3715: IF l_debug_level > 0
3716: THEN
3717: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEMINTERNAL');
3718: END IF;
3719: EXCEPTION
3720: WHEN fnd_api.g_exc_error
3721: THEN

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

3804: l_blanket_flag VARCHAR2 (1);
3805: -- HTML variables
3806: l_document VARCHAR2 (32000) := '';
3807: l_header_id VARCHAR2 (240); -- ame er 16084377
3808: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3809: BEGIN
3810: -- select ITEM_KEY, ITEM_TYPE
3811: -- into l_item_key, l_item_type
3812: -- from wf_item_activity_statuses_v

Line 3835: oe_debug_pub.ADD ('before getting attribute');

3831: -- ame er 16084377 code begins
3832: BEGIN
3833: IF l_debug_level > 0
3834: THEN
3835: oe_debug_pub.ADD ('before getting attribute');
3836: END IF;
3837:
3838: IF l_item_type = 'OEAME'
3839: THEN

Line 3848: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);

3844: );
3845:
3846: IF l_debug_level > 0
3847: THEN
3848: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);
3849: END IF;
3850: ELSE
3851: l_header_id := l_item_key;
3852: END IF;

Line 4939: -- oe_debug_pub.add( 'NO HOLDS FOUND FOR HEADER ID: ' || P_HDR_ID ) ;

4935: WHEN NO_DATA_FOUND
4936: THEN
4937: l_result_out := 'N';
4938: --IF l_debug_level > 0 THEN
4939: -- oe_debug_pub.add( 'NO HOLDS FOUND FOR HEADER ID: ' || P_HDR_ID ) ;
4940: --END IF;
4941: WHEN TOO_MANY_ROWS
4942: THEN
4943: NULL;

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

4974: l_book_deferred VARCHAR2 (1);
4975: l_booked_flag VARCHAR2 (1);
4976: l_flow_status_code VARCHAR2 (30);
4977: l_flow_status VARCHAR2 (256);
4978: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4979:
4980: CURSOR c_eligible_activity
4981: IS
4982: SELECT pa.activity_name

Line 5025: oe_debug_pub.ADD ( 'In Complete_eligible_and_Book, header_id'

5021: AND wpa.instance_id = wias.process_activity;
5022: BEGIN
5023: IF l_debug_level > 0
5024: THEN
5025: oe_debug_pub.ADD ( 'In Complete_eligible_and_Book, header_id'
5026: || p_header_id
5027: );
5028: END IF;
5029:

Line 5037: oe_debug_pub.ADD ('c_eligible_activity NOT FOUND');

5033: INTO l_activity;
5034:
5035: IF c_eligible_activity%NOTFOUND
5036: THEN
5037: oe_debug_pub.ADD ('c_eligible_activity NOT FOUND');
5038: fnd_message.set_name ('ONT', 'OE_NO_ELIGIBLE_ACTIVITIES');
5039: oe_msg_pub.ADD;
5040: ELSE
5041: CLOSE c_eligible_activity;

Line 5045: oe_debug_pub.ADD ('ELIGIBLE Activity: ' || l_activity);

5041: CLOSE c_eligible_activity;
5042:
5043: IF l_debug_level > 0
5044: THEN
5045: oe_debug_pub.ADD ('ELIGIBLE Activity: ' || l_activity);
5046: END IF;
5047:
5048: BEGIN
5049: wf_engine.completeactivityinternalname (oe_globals.g_wfi_ngo,

Line 5058: oe_debug_pub.ADD ('Workflow complete activity failed. Raising');

5054: ); --14599978
5055: EXCEPTION
5056: WHEN OTHERS
5057: THEN
5058: oe_debug_pub.ADD ('Workflow complete activity failed. Raising');
5059: RAISE;
5060: END;
5061:
5062: -- The order could have been booked already becuase the booking was synchronous.

Line 5070: oe_debug_pub.ADD ('l_booked_flag: ' || l_booked_flag);

5066: WHERE header_id = p_header_id;
5067:
5068: IF l_debug_level > 0
5069: THEN
5070: oe_debug_pub.ADD ('l_booked_flag: ' || l_booked_flag);
5071: END IF;
5072:
5073: IF l_booked_flag = 'N'
5074: THEN

Line 5085: oe_debug_pub.ADD ('BOOKING NOT ELIGIBLE');

5081: IF (book_eligible%NOTFOUND)
5082: THEN
5083: IF l_debug_level > 0
5084: THEN
5085: oe_debug_pub.ADD ('BOOKING NOT ELIGIBLE');
5086: END IF;
5087:
5088: -- Booking can be a high cost activity and may be deferred
5089: OPEN book_deferred;

Line 5098: oe_debug_pub.ADD ('BOOKING IS DEFERRED');

5094: IF (book_deferred%FOUND)
5095: THEN
5096: IF l_debug_level > 0
5097: THEN
5098: oe_debug_pub.ADD ('BOOKING IS DEFERRED');
5099: END IF;
5100:
5101: fnd_message.set_name ('ONT', 'OE_ORDER_BOOK_DEFERRED');
5102: oe_msg_pub.ADD;

Line 5122: oe_debug_pub.ADD

5118: END IF; -- book_deferred%FOUND
5119: ELSE -- book_eligible%NOTFOUND
5120: IF l_debug_level > 0
5121: THEN
5122: oe_debug_pub.ADD
5123: ('Calling OE_Order_Book_Util.Complete_Book_Eligible');
5124: END IF;
5125:
5126: oe_order_book_util.complete_book_eligible