APPS.ECE_INBOUND dependencies on ECE_INBOUND

Line 1: PACKAGE BODY ece_inbound as

1: PACKAGE BODY ece_inbound as
2: -- $Header: ECEINBB.pls 120.2 2005/09/28 11:26:03 arsriniv ship $
3:
4: /* Bug 2422787 */
5: g_count number:=0;

Line 30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

26: is
27: i_select_cursor INTEGER;
28: BEGIN
29: if ec_debug.G_debug_level >= 2 then
30: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
31: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
32: ec_debug.pl(3,'i_document_id',i_document_id);
33: end if;
34:

Line 63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

59: then
60: dbms_sql.close_cursor(i_select_cursor);
61: end if;
62: if ec_debug.G_debug_level >= 2 then
63: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
64: end if;
65:
66: EXCEPTION
67: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

69: raise EC_UTILS.PROGRAM_EXIT;
70: WHEN EC_UTILS.PROGRAM_EXIT then
71: raise;
72: WHEN OTHERS THEN
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
75: ec_utils.i_ret_code := 2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: END process_inbound_documents;

Line 103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

99: i_count number:=0;
100:
101: begin
102: if ec_debug.G_debug_level >= 2 then
103: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
104: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
105: ec_debug.pl(3,'i_run_id',i_run_id);
106: end if;
107:

Line 153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

149: then
150: dbms_sql.close_cursor(i_select_cursor);
151: end if;
152: if ec_debug.G_debug_level >= 2 then
153: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
154: end if;
155:
156: EXCEPTION
157: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 163: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

159: raise EC_UTILS.PROGRAM_EXIT;
160: WHEN EC_UTILS.PROGRAM_EXIT then
161: raise;
162: WHEN OTHERS THEN
163: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
165: ec_utils.i_ret_code := 2;
166: raise EC_UTILS.PROGRAM_EXIT;
167: end process_inbound_documents;

Line 193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');

189: i_count number:=0;
190:
191: begin
192: if ec_debug.G_debug_level >= 2 then
193: ec_debug.PUSH('ECE_INBOUND.PROCESS_RUN_INBOUND');
194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**

Line 316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');

312: then
313: dbms_sql.close_cursor(i_select_cursor);
314: end if;
315: if ec_debug.G_debug_level >= 2 then
316: ec_debug.POP('ECE_INBOUND.PROCESS_RUN_INBOUND');
317: end if;
318: EXCEPTION
319: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
320: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 325: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_RUN_INBOUND');

321: raise EC_UTILS.PROGRAM_EXIT;
322: WHEN EC_UTILS.PROGRAM_EXIT then
323: raise;
324: WHEN OTHERS THEN
325: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_RUN_INBOUND');
326: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
327: ec_utils.i_ret_code := 2;
328: raise EC_UTILS.PROGRAM_EXIT;
329: end process_run_inbound;

Line 355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

351: i_count number:=0;
352:
353: begin
354: if ec_debug.G_debug_level >= 2 then
355: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
356: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
357: ec_debug.pl(3,'i_status',i_status);
358: end if;
359: ec_utils.g_stack.DELETE;

Line 404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

400: then
401: dbms_sql.close_cursor(i_select_cursor);
402: end if;
403: if ec_debug.G_debug_level >= 2 then
404: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
405: end if;
406: EXCEPTION
407: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
408: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 413: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

409: raise EC_UTILS.PROGRAM_EXIT;
410: WHEN EC_UTILS.PROGRAM_EXIT then
411: raise;
412: WHEN OTHERS THEN
413: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
414: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
415: ec_utils.i_ret_code := 2;
416: raise EC_UTILS.PROGRAM_EXIT;
417: end process_inbound_documents;

Line 440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

436: i_count number:=0;
437:
438: begin
439: if ec_debug.G_debug_level >= 2 then
440: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
441: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
442: end if;
443: ec_utils.g_stack.DELETE;
444: ec_utils.g_documents_skipped := 0;

Line 490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

486: then
487: dbms_sql.close_cursor(i_select_cursor);
488: end if;
489: if ec_debug.G_debug_level >= 2 then
490: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
491: end if;
492: EXCEPTION
493: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
494: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 499: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

495: raise EC_UTILS.PROGRAM_EXIT;
496: WHEN EC_UTILS.PROGRAM_EXIT then
497: raise;
498: WHEN OTHERS THEN
499: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
500: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
501: ec_utils.i_ret_code := 2;
502: raise EC_UTILS.PROGRAM_EXIT;
503: end process_inbound_documents;

Line 546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

542: i_count number:=0;
543:
544: begin
545: if ec_debug.G_debug_level >= 2 then
546: ec_debug.PUSH('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
547: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
548: ec_debug.pl(3,'i_tp_code',i_tp_code);
549: ec_debug.pl(3,'i_status',i_status);
550: end if;

Line 640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

636: then
637: dbms_sql.close_cursor(i_select_cursor);
638: end if;
639: if ec_debug.G_debug_level >= 2 then
640: ec_debug.POP('ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
641: end if;
642: EXCEPTION
643: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
644: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 649: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');

645: raise EC_UTILS.PROGRAM_EXIT;
646: WHEN EC_UTILS.PROGRAM_EXIT then
647: raise;
648: WHEN OTHERS THEN
649: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_INBOUND_DOCUMENTS');
650: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
651: ec_utils.i_ret_code := 2;
652: raise EC_UTILS.PROGRAM_EXIT;
653: end process_inbound_documents;

Line 702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');

698:
699:
700: BEGIN
701: if ec_debug.G_debug_level >= 2 then
702: ec_debug.push('ECE_INBOUND.RUN_INBOUND');
703: ec_debug.pl(3,'i_document_id',i_document_id);
704: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
705: end if;
706: --Set the Document Id package variable

Line 1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');

1183: i_total_records := dbms_sql.last_row_count;
1184: if ec_debug.G_debug_level >= 1 then
1185: ec_debug.pl(1,'EC','ECE_TOTAL_RECORDS_PROCESSED','TOTAL_RECORDS',i_total_records,'DOCUMENT_ID',i_document_id);
1186:
1187: ec_debug.POP('ECE_INBOUND.RUN_INBOUND');
1188: end if;
1189:
1190: EXCEPTION
1191: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then

Line 1198: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.RUN_INBOUND');

1194: raise EC_UTILS.PROGRAM_EXIT;
1195: WHEN EC_UTILS.PROGRAM_EXIT then
1196: raise;
1197: WHEN OTHERS THEN
1198: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.RUN_INBOUND');
1199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1200: ec_utils.i_ret_code := 2;
1201: raise EC_UTILS.PROGRAM_EXIT;
1202: END run_inbound;

Line 1209: ec_debug.push('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1205: is
1206: BEGIN
1207:
1208: if ec_debug.G_debug_level >= 2 then
1209: ec_debug.push('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1210: end if;
1211: /**
1212: Update Header record in the Staging Table.
1213: **/

Line 1260: ec_debug.pop('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1256: end if;
1257:
1258: end if;
1259: if ec_debug.G_debug_level >= 2 then
1260: ec_debug.pop('ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1261: end if;
1262: EXCEPTION
1263: WHEN EC_UTILS.PROGRAM_EXIT then
1264: raise;

Line 1266: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.UPDATE_DOCUMENT_STATUS');

1262: EXCEPTION
1263: WHEN EC_UTILS.PROGRAM_EXIT then
1264: raise;
1265: WHEN OTHERS THEN
1266: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.UPDATE_DOCUMENT_STATUS');
1267: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1268: ec_utils.i_ret_code := 2;
1269: raise EC_UTILS.PROGRAM_EXIT;
1270: END update_document_status;

Line 1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');

1276: )
1277: is
1278: begin
1279: if ec_debug.G_debug_level >= 2 then
1280: ec_debug.push('ECE_INBOUND.INITIALIZE_INBOUND');
1281: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1282: end if;
1283:
1284: if g_count=0 then -- Bug 2422787

Line 1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');

1423: end if;
1424:
1425:
1426: if ec_debug.G_debug_level>= 2 then
1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');
1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');

Line 1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');

1427: ec_debug.pop('ECE_INBOUND.INITIALIZE_INBOUND');
1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INITIALIZE_INBOUND');
1432: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1433: ec_utils.i_ret_code := 2;
1434: raise EC_UTILS.PROGRAM_EXIT;
1435: end initialize_inbound;

Line 1441: ec_debug.push('ECE_INBOUND.CLOSE_INBOUND');

1437: procedure close_inbound
1438: is
1439: begin
1440: if ec_debug.G_debug_level >= 2 then
1441: ec_debug.push('ECE_INBOUND.CLOSE_INBOUND');
1442: end if;
1443:
1444: g_count:=0; --Bug 2422787
1445:

Line 1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');

1471: end if;
1472: end loop;
1473:
1474: if ec_debug.G_debug_level >= 2 then
1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');
1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');

Line 1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');

1475: ec_debug.pop('ECE_INBOUND.CLOSE_INBOUND');
1476: end if;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.CLOSE_INBOUND');
1480: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1481: ec_utils.i_ret_code := 2;
1482: raise EC_UTILS.PROGRAM_EXIT;
1483: end close_inbound;

Line 1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1488: )
1489: is
1490: begin
1491: if ec_debug.G_debug_level >= 2 then
1492: ec_debug.push('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1493: ec_debug.pl(3,'i_document_id',i_document_id);
1494: end if;
1495: /**
1496: Delete the Old violations for this Document

Line 1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1542: /** Clean the PL/SQL table for next set of violations.
1543: **/
1544: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1545: if ec_debug.G_debug_level >= 2 then
1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');

Line 1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');

1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1551: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1552: ec_utils.i_ret_code := 2;
1553: raise EC_UTILS.PROGRAM_EXIT;
1554: end Insert_Into_Violations;

Line 1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');

1564: is
1565: begin
1566: ec_debug.enable_debug(i_debug_mode);
1567: if ec_debug.G_debug_level >= 2 then
1568: ec_debug.push('ECE_INBOUND.PROCESS_FOR_REQID');
1569: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1574: ece_inbound.process_inbound_documents

1570: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1571: ec_debug.pl(3,'i_reqid',i_reqid);
1572: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1573: end if;
1574: ece_inbound.process_inbound_documents
1575: (
1576: i_transaction_type => i_transaction_type,
1577: i_run_id => i_reqid
1578: );

Line 1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1581: if ec_debug.G_debug_level >= 2 then
1582: ec_debug.pl(3,'errbuf',errbuf);
1583: ec_debug.pl(3,'retcode',retcode);
1584: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1585: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1586: end if;
1587: ec_debug.disable_debug;
1588: EXCEPTION
1589: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1589: WHEN EC_UTILS.PROGRAM_EXIT then
1590: ece_flatfile_pvt.print_attributes;
1591: retcode := ec_utils.i_ret_code;
1592: ec_debug.disable_debug;
1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');

1592: ec_debug.disable_debug;
1593: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1594: WHEN OTHERS THEN
1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;

Line 1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');

1595: retcode :=2;
1596: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_REQID');
1597: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1598: ece_flatfile_pvt.print_attributes;
1599: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_REQID');
1600: ec_debug.disable_debug;
1601: end process_for_reqid;
1602:
1603: procedure process_for_document_id

Line 1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1611: is
1612: begin
1613: ec_debug.enable_debug(i_debug_mode);
1614: if ec_debug.G_debug_level >= 2 then
1615: ec_debug.push('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1616: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1621: ece_inbound.process_inbound_documents

1617: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1618: ec_debug.pl(3,'i_document_id',i_document_id);
1619: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1620: end if;
1621: ece_inbound.process_inbound_documents
1622: (
1623: i_transaction_type => i_transaction_type,
1624: i_document_id => i_document_id
1625: );

Line 1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1627: if ec_debug.G_debug_level >= 2 then
1628: ec_debug.pl(3,'errbuf',errbuf);
1629: ec_debug.pl(3,'retcode',retcode);
1630: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1631: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1632: end if;
1633: ec_debug.disable_debug;
1634: EXCEPTION
1635: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1635: WHEN EC_UTILS.PROGRAM_EXIT then
1636: retcode := ec_utils.i_ret_code;
1637: ece_flatfile_pvt.print_attributes;
1638: ec_debug.disable_debug;
1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1638: ec_debug.disable_debug;
1639: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1640: WHEN OTHERS THEN
1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;

Line 1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');

1641: retcode :=2;
1642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1643: ec_debug.pl(1,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1644: ece_flatfile_pvt.print_attributes;
1645: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_DOCUMENT_ID');
1646: ec_debug.disable_debug;
1647: end process_for_document_id;
1648:
1649: procedure process_for_status

Line 1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');

1657: is
1658: begin
1659: ec_debug.enable_debug(i_debug_mode);
1660: if ec_debug.G_debug_level >= 2 then
1661: ec_debug.push('ECE_INBOUND.PROCESS_FOR_STATUS');
1662: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1663: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 1668: ece_inbound.process_inbound_documents

1664: ec_debug.pl(3,'i_status',i_status);
1665: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1666: end if;
1667:
1668: ece_inbound.process_inbound_documents
1669: (
1670: i_transaction_type => i_transaction_type,
1671: i_status => i_status
1672: );

Line 1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1674: if ec_debug.G_debug_level >= 2 then
1675: ec_debug.pl(3,'errbuf',errbuf);
1676: ec_debug.pl(3,'retcode',retcode);
1677: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1678: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1679: end if;
1680: ec_debug.disable_debug;
1681: EXCEPTION
1682: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1682: WHEN EC_UTILS.PROGRAM_EXIT then
1683: retcode := ec_utils.i_ret_code;
1684: ece_flatfile_pvt.print_attributes;
1685: ec_debug.disable_debug;
1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');

1685: ec_debug.disable_debug;
1686: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1687: WHEN OTHERS THEN
1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;

Line 1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');

1688: retcode :=2;
1689: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_STATUS');
1690: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1691: ece_flatfile_pvt.print_attributes;
1692: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_STATUS');
1693: ec_debug.disable_debug;
1694: end process_for_status;
1695:
1696: procedure process_for_transaction

Line 1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1703: is
1704: begin
1705: ec_debug.enable_debug(i_debug_mode);
1706: if ec_debug.G_debug_level >= 2 then
1707: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;

Line 1712: ece_inbound.process_inbound_documents

1708: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1709: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1710: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1711: end if;
1712: ece_inbound.process_inbound_documents
1713: (
1714: i_transaction_type => i_transaction_type
1715: );
1716: retcode := ec_utils.i_ret_code;

Line 1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1718: if ec_debug.G_debug_level >= 2 then
1719: ec_debug.pl(3,'errbuf',errbuf);
1720: ec_debug.pl(3,'retcode',retcode);
1721: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1722: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1723: end if;
1724: ec_debug.disable_debug;
1725: EXCEPTION
1726: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1726: WHEN EC_UTILS.PROGRAM_EXIT then
1727: retcode := ec_utils.i_ret_code;
1728: ece_flatfile_pvt.print_attributes;
1729: ec_debug.disable_debug;
1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1729: ec_debug.disable_debug;
1730: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1731: WHEN OTHERS THEN
1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;

Line 1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');

1732: retcode :=2;
1733: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1734: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1735: ece_flatfile_pvt.print_attributes;
1736: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TRANSACTION');
1737: ec_debug.disable_debug;
1738: end process_for_transaction;
1739:
1740: procedure process_for_tpstatus

Line 1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1749: is
1750: begin
1751: ec_debug.enable_debug(i_debug_mode);
1752: if ec_debug.G_debug_level >= 2 then
1753: ec_debug.push('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1754: ec_debug.pl(2,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1755: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);

Line 1760: ece_inbound.process_inbound_documents

1756: ec_debug.pl(3,'i_tp_code',i_tp_code);
1757: ec_debug.pl(3,'i_status',i_status);
1758: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
1759: end if;
1760: ece_inbound.process_inbound_documents
1761: (
1762: i_transaction_type => i_transaction_type,
1763: i_tp_code => i_tp_code,
1764: i_status => i_status

Line 1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1768: if ec_debug.G_debug_level >=2 then
1769: ec_debug.pl(3,'errbuf',errbuf);
1770: ec_debug.pl(3,'retcode',retcode);
1771: ec_debug.pl(2,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
1772: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1773: end if;
1774: ec_debug.disable_debug;
1775: EXCEPTION
1776: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1776: WHEN EC_UTILS.PROGRAM_EXIT then
1777: retcode := ec_utils.i_ret_code;
1778: ece_flatfile_pvt.print_attributes;
1779: ec_debug.disable_debug;
1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1779: ec_debug.disable_debug;
1780: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1781: WHEN OTHERS THEN
1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;

Line 1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');

1782: retcode :=2;
1783: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1784: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1785: ece_flatfile_pvt.print_attributes;
1786: ec_debug.pop('ECE_INBOUND.PROCESS_FOR_TPSTATUS');
1787: ec_debug.disable_debug;
1788: end process_for_tpstatus;
1789:
1790: procedure process_documents

Line 1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');

1795: )
1796: is
1797: BEGIN
1798: if ec_debug.G_debug_level >= 2 then
1799: ec_debug.push('ECE_INBOUND.PROCESS_DOCUMENTS');
1800: ec_debug.pl(3,'i_document_id',i_document_id);
1801: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1802: end if;
1803: /**

Line 1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');

1859:
1860: /** Save the Violations. **/
1861: Insert_Into_Violations(i_Document_Id);
1862: if ec_debug.G_debug_level >=2 then
1863: ec_debug.pop('ECE_INBOUND.PROCESS_DOCUMENTS');
1864: end if;
1865: EXCEPTION
1866: WHEN EC_UTILS.DOCUMENTS_UNDER_PROCESS then
1867: ec_debug.pl(0,'EC','ECE_DOCUMENTS_UNDER_PROCESS',null);

Line 1872: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_DOCUMENTS');

1868: raise EC_UTILS.PROGRAM_EXIT;
1869: WHEN EC_UTILS.PROGRAM_EXIT then
1870: raise;
1871: WHEN OTHERS THEN
1872: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.PROCESS_DOCUMENTS');
1873: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1874: ec_utils.i_ret_code :=2;
1875: raise EC_UTILS.PROGRAM_EXIT;
1876: end process_documents;

Line 1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');

1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin
1895: if ec_debug.G_debug_level >=2 then
1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');
1897: end if;
1898:
1899: i_Select_Stmt := 'select Stage_Id ,Document_Number ,transaction_level ,line_number ,Status , map_id, ';
1900:

Line 1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');

1920: dbms_sql.parse(i_Cursor_handle,i_Select_Stmt,dbms_sql.native);
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: error_position := dbms_sql.last_error_position;
1924: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1925: ece_error_handling_pvt.print_parse_error (error_position,i_Select_Stmt);
1926: ec_utils.i_ret_code :=2;
1927: raise EC_UTILS.PROGRAM_EXIT;
1928: END;

Line 1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');

1945:
1946: i_Select_Cursor := i_Cursor_Handle;
1947: if ec_debug.G_debug_level >=2 then
1948: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
1949: ec_debug.pop('ECE_INBOUND.SELECT_STAGE');
1950: end if;
1951: EXCEPTION
1952: WHEN EC_UTILS.PROGRAM_EXIT then
1953: raise;

Line 1955: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');

1951: EXCEPTION
1952: WHEN EC_UTILS.PROGRAM_EXIT then
1953: raise;
1954: WHEN OTHERS then
1955: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_INBOUND.SELECT_STAGE');
1956: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1957: ec_utils.i_ret_code :=2;
1958: raise EC_UTILS.PROGRAM_EXIT;
1959: end select_stage;

Line 1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

1979: error_position pls_integer;
1980:
1981: BEGIN
1982: if ec_debug.G_debug_level >=2 then
1983: ec_debug.push('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
1984: ec_debug.pl(3,'i_Insert_Cursor',i_Insert_Cursor);
1985: ec_debug.pl(3,'i_level',i_level);
1986: end if;
1987:

Line 2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2019: exception
2020: when others then
2021: error_position := dbms_sql.last_error_position;
2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2024: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
2025: ec_utils.i_ret_code :=2;
2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2027: raise EC_UTILS.PROGRAM_EXIT;

Line 2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2022: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2023: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2024: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
2025: ec_utils.i_ret_code :=2;
2026: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2027: raise EC_UTILS.PROGRAM_EXIT;
2028: end;
2029: end if;
2030:

Line 2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2090: end if;
2091:
2092: if ec_debug.G_debug_level >= 2 then
2093: ec_debug.pl(3,'i_success',i_success);
2094: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2095: end if;
2096: return i_success;
2097: EXCEPTION
2098: WHEN EC_UTILS.PROGRAM_EXIT then

Line 2102: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2098: WHEN EC_UTILS.PROGRAM_EXIT then
2099: raise;
2100: WHEN OTHERS THEN
2101: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
2102: 'ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);

Line 2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');

2104: i_success := FALSE;
2105: ec_utils.i_ret_code :=1;
2106: ec_debug.pl(0,'EC','ECE_INSERT_FAILED',null);
2107: ec_debug.pl(3,'i_success',i_success);
2108: ec_debug.pop('ECE_INBOUND.INSERT_INTO_PROD_INTERFACE');
2109: return i_success;
2110: END insert_into_prod_interface;
2111:
2112:

Line 2113: end ece_inbound;

2109: return i_success;
2110: END insert_into_prod_interface;
2111:
2112:
2113: end ece_inbound;