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.ECE_POO_TRANSACTION dependencies on ECE_POO_TRANSACTION

Line 1: PACKAGE BODY ece_poo_transaction AS

1: PACKAGE BODY ece_poo_transaction AS
2: -- $Header: ECEPOOB.pls 120.10.12020000.3 2013/02/26 12:22:07 venuthot ship $
3:
4: iOutput_width INTEGER := 4000; -- 2823215
5: iKey_count NUMBER := 0;

Line 95: ece_poo_transaction.project_sel_c:=0; --Bug 2490109

91:
92:
93: xProgress := 'POO-10-1026';
94:
95: ece_poo_transaction.project_sel_c:=0; --Bug 2490109
96:
97: IF cOutput_Filename IS NULL THEN --Bug 2430822
98: cFilename := 'POO' || iRun_id || '.dat';
99: ELSE

Line 111: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790

107: ec_debug.pl(1,'Open Output file'); --Bug 2034376
108: end if;
109: i_path := cOutput_Path;
110: i_filename := cFilename;
111: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790
112:
113: xProgress := 'POO-10-1040';
114: if ec_debug.G_debug_level = 1 then
115: ec_debug.pl(1,'Call Populate Poo Trx procedure'); --Bug 2034376

Line 118: ece_poo_transaction.populate_poo_trx(

114: if ec_debug.G_debug_level = 1 then
115: ec_debug.pl(1,'Call Populate Poo Trx procedure'); --Bug 2034376
116: end if;
117:
118: ece_poo_transaction.populate_poo_trx(
119: cCommunication_Method,
120: cTransaction_Type,
121: iOutput_width,
122: SYSDATE,

Line 157: ece_poo_transaction.put_data_to_output_table(

153:
154: /*
155: xProgress := 'POO-10-1041';
156:
157: ece_poo_transaction.put_data_to_output_table(
158: cCommunication_Method,
159: cTransaction_Type,
160: iOutput_width,
161: iRun_id,

Line 169: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then

165: cDistribution_Interface);
166: */
167:
168: xProgress := 'POO-10-1042';
169: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
170: utl_file.fclose(ece_poo_transaction.uFile_type);
171: end if;
172:
173: IF ec_mapping_utils.ec_get_trans_upgrade_status(cTransaction_Type) = 'U' THEN

Line 170: utl_file.fclose(ece_poo_transaction.uFile_type);

166: */
167:
168: xProgress := 'POO-10-1042';
169: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
170: utl_file.fclose(ece_poo_transaction.uFile_type);
171: end if;
172:
173: IF ec_mapping_utils.ec_get_trans_upgrade_status(cTransaction_Type) = 'U' THEN
174: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

Line 200: if (utl_file.is_open(ece_poo_transaction.uFile_type))

196: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
197:
198: retcode := 2;
199: ec_debug.disable_debug;
200: if (utl_file.is_open(ece_poo_transaction.uFile_type))
201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 202: utl_file.fclose(ece_poo_transaction.uFile_type);

198: retcode := 2;
199: ec_debug.disable_debug;
200: if (utl_file.is_open(ece_poo_transaction.uFile_type))
201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;

Line 204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

200: if (utl_file.is_open(ece_poo_transaction.uFile_type))
201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;
207:
208: WHEN utl_file.invalid_path THEN

Line 205: utl_file.fclose(ece_poo_transaction.uFile_type);

201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;
207:
208: WHEN utl_file.invalid_path THEN
209: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);

Line 222: if (utl_file.is_open(ece_poo_transaction.uFile_type))

218: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
219:
220: retcode := 2;
221: ec_debug.disable_debug;
222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 224: utl_file.fclose(ece_poo_transaction.uFile_type);

220: retcode := 2;
221: ec_debug.disable_debug;
222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;

Line 226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;
229:
230: WHEN OTHERS THEN

Line 227: utl_file.fclose(ece_poo_transaction.uFile_type);

223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;
229:
230: WHEN OTHERS THEN
231: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 236: if (utl_file.is_open(ece_poo_transaction.uFile_type))

232: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
233:
234: retcode := 2;
235: ec_debug.disable_debug;
236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 238: utl_file.fclose(ece_poo_transaction.uFile_type);

234: retcode := 2;
235: ec_debug.disable_debug;
236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;

Line 240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;
243:
244: END extract_poo_outbound;

Line 241: utl_file.fclose(ece_poo_transaction.uFile_type);

237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;
243:
244: END extract_poo_outbound;
245:

Line 503: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_POO_TRX');

499: WHERE po_line_id = p_line_id;
500:
501: BEGIN
502: if ec_debug.G_debug_level >= 2 then
503: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_POO_TRX');
504: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
505: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
506: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
507: ec_debug.pl(3,'dTransaction_date: ' ,dTransaction_date);

Line 1332: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then

1328:
1329: -- **************************************
1330: -- store internal values in pl/sql table
1331: -- **************************************
1332: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1333: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1334: end if;
1335: xProgress := 'POOB-10-1431';
1336: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);

Line 1333: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);

1329: -- **************************************
1330: -- store internal values in pl/sql table
1331: -- **************************************
1332: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1333: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1334: end if;
1335: xProgress := 'POOB-10-1431';
1336: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);
1337:

Line 1375: ece_poo_transaction.update_po(l_document_type,

1371: end if;
1372: xProgress := 'POOB-10-1450';
1373:
1374:
1375: ece_poo_transaction.update_po(l_document_type,
1376: l_header_tbl(nPO_Number_pos).value,
1377: l_header_tbl(nPO_type_pos).value,
1378: l_header_tbl(nRelease_num_pos).value);
1379:

Line 1499: ece_poo_transaction.write_to_file(cTransaction_Type,

1495: -- ********************************************************
1496: xProgress := 'POOB-10-1492';
1497: ece_poo_x.populate_ext_header(l_header_fkey,l_header_tbl);
1498: -- 2823215
1499: ece_poo_transaction.write_to_file(cTransaction_Type,
1500: cCommunication_Method,
1501: cHeader_Interface,
1502: l_header_tbl,
1503: iOutput_width,

Line 1530: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1526: end if;
1527: END IF;
1528:
1529: xProgress := 'POOB-10-1505';
1530: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1531: cTransaction_Type,
1532: iRun_id,
1533: 2,
1534: 3,

Line 1558: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1554: end if;
1555:
1556: v_entity_name := 'PO_VENDOR_SITES';
1557: v_pk1_value := l_header_tbl(nVendor_Site_Id_pos).Value;
1558: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1559: cTransaction_Type,
1560: iRun_id,
1561: 2,
1562: 3,

Line 1754: ece_poo_transaction.write_to_file( cTransaction_Type,

1750: xProgress := 'POOB-10-1620';
1751: ece_poo_x.populate_ext_line(l_line_fkey,l_line_tbl);
1752: -- 2823215
1753: xProgress := 'POOB-10-1621';
1754: ece_poo_transaction.write_to_file( cTransaction_Type,
1755: cCommunication_Method,
1756: cLine_Interface,
1757: l_line_tbl,
1758: iOutput_width,

Line 1792: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1788: -- end if;
1789: END IF;
1790:
1791: xProgress := 'POOB-10-1624';
1792: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1793: cTransaction_Type,
1794: iRun_id,
1795: 5,
1796: 6,

Line 1830: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1826: ec_debug.pl(3,'Item ID: ',v_pk2_value);
1827: end if;
1828:
1829: xProgress := 'POOB-10-1626';
1830: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1831: cTransaction_Type,
1832: iRun_id,
1833: 7,
1834: 8,

Line 1873: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1869: ec_debug.pl(3,'Inventory Org ID: ',v_pk1_value);
1870: end if;
1871:
1872: xProgress := 'POOB-10-1626';
1873: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1874: cTransaction_Type,
1875: iRun_id,
1876: 9,
1877: 10,

Line 2107: ece_poo_transaction.write_to_file(cTransaction_Type,

2103:
2104: END IF;
2105:
2106: -- 2823215
2107: ece_poo_transaction.write_to_file(cTransaction_Type,
2108: cCommunication_Method,
2109: cShipment_Interface,
2110: l_shipment_tbl,
2111: iOutput_width,

Line 2132: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

2128: ec_debug.pl(3,'Ship Level Line Location ID: ',l_shipment_tbl(nShip_Line_Location_ID_pos).value);
2129: end if;
2130:
2131: xProgress := 'POOB-10-1720';
2132: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
2133: cTransaction_Type,
2134: iRun_id,
2135: 12,
2136: 13,

Line 2157: ece_poo_transaction.POPULATE_DISTRIBUTION_INFO(

2153:
2154: -- Project Level Handler
2155: xProgress := 'POOB-10-1730';
2156: -- IF v_project_acct_status = 'I' THEN -- Project Accounting is Installed --Bug 1891291
2157: ece_poo_transaction.POPULATE_DISTRIBUTION_INFO(
2158: cCommunication_Method,
2159: cTransaction_Type,
2160: iRun_id,
2161: cDistribution_Interface,

Line 2224: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176

2220: cTransaction_Type);
2221: END IF;
2222:
2223: xProgress := 'POOB-10-1770';
2224: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
2225: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2226: end if;
2227: xProgress := 'POOB-10-1780';
2228: dbms_sql.close_cursor(shipment_sel_c);

Line 2225: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109

2221: END IF;
2222:
2223: xProgress := 'POOB-10-1770';
2224: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
2225: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2226: end if;
2227: xProgress := 'POOB-10-1780';
2228: dbms_sql.close_cursor(shipment_sel_c);
2229:

Line 2235: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_POO_TRX');

2231: dbms_sql.close_cursor(line_sel_c);
2232:
2233: xProgress := 'POOB-10-1800';
2234: dbms_sql.close_cursor(header_sel_c);
2235: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_POO_TRX');
2236:
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 2366: ec_debug.push('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

2362: WHERE po_line_id = p_line_id;
2363:
2364: BEGIN
2365: if ec_debug.G_debug_level = 3 then
2366: ec_debug.push('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
2367: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
2368: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
2369: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
2370: ec_debug.pl(3,'iRun_id: ' ,iRun_id);

Line 2907: ece_poo_transaction.write_to_file(cTransaction_Type,

2903:
2904: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
2905:
2906: xProgress := 'POOB-20-1480';
2907: ece_poo_transaction.write_to_file(cTransaction_Type,
2908: cCommunication_Method,
2909: cHeader_Interface,
2910: l_header_tbl,
2911: iOutput_width,

Line 3028: ece_poo_transaction.write_to_file(cTransaction_Type,

3024: ec_debug.pl(3,'c_file_common_key: ',c_file_common_key);
3025: end if;
3026:
3027: xProgress := 'POOB-20-1551';
3028: ece_poo_transaction.write_to_file(cTransaction_Type,
3029: cCommunication_Method,
3030: cLine_Interface,
3031: l_line_tbl,
3032: iOutput_width,

Line 3175: ece_poo_transaction.write_to_file(cTransaction_Type,

3171: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
3172: end if;
3173:
3174: xProgress := 'POOB-20-1630';
3175: ece_poo_transaction.write_to_file(cTransaction_Type,
3176: cCommunication_Method,
3177: cShipment_Interface,
3178: l_shipment_tbl,
3179: iOutput_width,

Line 3209: ece_poo_transaction.PUT_DISTDATA_TO_OUT_TBL(

3205:
3206: -- Project Level Handler
3207: xProgress := 'POOB-20-1634';
3208: -- IF v_project_acct_status = 'I' THEN -- Project Accounting is Installed --bug1891291
3209: ece_poo_transaction.PUT_DISTDATA_TO_OUT_TBL(
3210: cCommunication_Method,
3211: cTransaction_Type,
3212: iOutput_width,
3213: iRun_id,

Line 3338: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176

3334: dbms_sql.close_cursor(shipment_del_c2);
3335:
3336: -- Bug 2490109 Closing the distribution cursors.
3337: xProgress := 'POOB-50-1819';
3338: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3339: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3340:
3341: xProgress := 'POOB-50-1820';
3342: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);

Line 3339: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);

3335:
3336: -- Bug 2490109 Closing the distribution cursors.
3337: xProgress := 'POOB-50-1819';
3338: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3339: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3340:
3341: xProgress := 'POOB-50-1820';
3342: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3343:

Line 3342: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);

3338: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3339: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3340:
3341: xProgress := 'POOB-50-1820';
3342: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3343:
3344: xProgress := 'POOB-50-1821';
3345: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3346: end if;

Line 3345: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);

3341: xProgress := 'POOB-50-1820';
3342: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3343:
3344: xProgress := 'POOB-50-1821';
3345: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3346: end if;
3347:
3348: xProgress := 'POOB-20-1820';
3349: if ec_debug.G_debug_level >= 2 then

Line 3350: ec_debug.pop('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

3346: end if;
3347:
3348: xProgress := 'POOB-20-1820';
3349: if ec_debug.G_debug_level >= 2 then
3350: ec_debug.pop('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
3351: end if;
3352:
3353: EXCEPTION
3354: WHEN OTHERS THEN

Line 3381: ec_debug.push('ECE_POO_TRANSACTION.UPDATE_PO');

3377: l_error_stack VARCHAR2(2000);
3378:
3379: BEGIN
3380: if ec_debug.G_debug_level >= 2 then
3381: ec_debug.push('ECE_POO_TRANSACTION.UPDATE_PO');
3382: ec_debug.pl(3,'document_type: ', document_type);
3383: ec_debug.pl(3,'po_number: ', po_number);
3384: ec_debug.pl(3,'po_type: ', po_type);
3385: ec_debug.pl(3,'release_number: ',release_number);

Line 3543: ec_debug.pop('ECE_POO_TRANSACTION.UPDATE_PO');

3539: -- raise_application_error(-20000,l_error_buf || l_error_stack);
3540: -- END IF;
3541:
3542: if ec_debug.G_debug_level = 3 then
3543: ec_debug.pop('ECE_POO_TRANSACTION.UPDATE_PO');
3544: end if;
3545:
3546: EXCEPTION
3547: WHEN OTHERS THEN

Line 3614: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');

3610: nConv_tz_pos pls_integer;
3611: nConv_off_pos pls_integer;
3612: BEGIN
3613: if ec_debug.G_debug_level = 3 then
3614: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');
3615: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
3616: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
3617: ec_debug.pl(3,'iRun_id: ' ,iRun_id);
3618: ec_debug.pl(3,'cDistribution_Interface: ' ,cDistribution_Interface);

Line 3637: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109

3633: v_project_acct_schema);
3634:
3635: v_project_acct_status := NVL(v_project_acct_status,'X');
3636:
3637: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3638: ece_poo_transaction.project_sel_c:=-911;
3639: end if;
3640:
3641: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109

Line 3638: ece_poo_transaction.project_sel_c:=-911;

3634:
3635: v_project_acct_status := NVL(v_project_acct_status,'X');
3636:
3637: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3638: ece_poo_transaction.project_sel_c:=-911;
3639: end if;
3640:
3641: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109
3642:

Line 3641: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109

3637: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3638: ece_poo_transaction.project_sel_c:=-911;
3639: end if;
3640:
3641: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109
3642:
3643: xProgress := 'POOB-40-1000';
3644: iKey_count := l_key_tbl.COUNT;
3645: if ec_debug.G_debug_level = 3 then

Line 3732: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109

3728: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3729: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3730: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3731:
3732: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3733: -- Bind Variables
3734: xProgress := 'POOB-40-1140';
3735: dbms_sql.bind_variable(project_sel_c,':po_header_id',NVL(cPO_Header_ID,0));
3736:

Line 3872: ece_poo_transaction.write_to_file(cTransaction_Type,

3868:
3869: end if;
3870:
3871: -- 2823215
3872: ece_poo_transaction.write_to_file(cTransaction_Type,
3873: cCommunication_Method,
3874: cDistribution_Interface,
3875: l_project_tbl,
3876: iOutput_width,

Line 3907: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');

3903: -- dbms_sql.close_cursor(project_sel_c);
3904:
3905: -- Tell Debug that this Procedure is Done
3906: if ec_debug.G_debug_level = 3 then
3907: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');
3908: end if;
3909:
3910: EXCEPTION
3911: WHEN OTHERS THEN

Line 3964: ec_debug.push('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');

3960: dummy INTEGER;
3961:
3962: BEGIN
3963: if ec_debug.G_debug_level >= 2 then
3964: ec_debug.push('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');
3965: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
3966: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
3967: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
3968: ec_debug.pl(3,'iRun_id: ' ,iRun_id);

Line 3978: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109

3974: ec_debug.pl(3,'cFile_Common_Key: ' ,cFile_Common_Key);
3975: end if;
3976:
3977:
3978: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3979: ece_poo_transaction.project_sel_c:=-911;
3980: end if;
3981:
3982: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109

Line 3979: ece_poo_transaction.project_sel_c:=-911;

3975: end if;
3976:
3977:
3978: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3979: ece_poo_transaction.project_sel_c:=-911;
3980: end if;
3981:
3982: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3983: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109

Line 3982: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109

3978: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3979: ece_poo_transaction.project_sel_c:=-911;
3980: end if;
3981:
3982: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3983: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3984:
3985: -- Build the SELECT, FROM, and WHERE Clauses
3986: xProgress := 'POOB-50-1000';

Line 3983: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109

3979: ece_poo_transaction.project_sel_c:=-911;
3980: end if;
3981:
3982: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3983: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3984:
3985: -- Build the SELECT, FROM, and WHERE Clauses
3986: xProgress := 'POOB-50-1000';
3987: ece_flatfile_pvt.select_clause(cTransaction_Type,

Line 4090: if ece_poo_transaction.project_sel_c > 0 then -- Bug 2490109

4086: END;
4087:
4088: end if; --Bug 2490109
4089:
4090: if ece_poo_transaction.project_sel_c > 0 then -- Bug 2490109
4091:
4092: -- Set the Counter Variables
4093: xProgress := 'POOB-50-1110';
4094: iProject_count := l_project_tbl.COUNT;

Line 4147: ece_poo_transaction.write_to_file(cTransaction_Type,

4143: xProgress := 'POOB-50-1240';
4144: dbms_sql.column_value(project_sel_c,iProject_count + 2,rProject_X_rowid);
4145:
4146: xProgress := 'POOB-50-1250';
4147: ece_poo_transaction.write_to_file(cTransaction_Type,
4148: cCommunication_Method,
4149: cDistribution_Interface,
4150: l_project_tbl,
4151: iOutput_width,

Line 4205: ec_debug.pop('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');

4201: */
4202:
4203: xProgress := 'POOB-50-1350';
4204: if ec_debug.G_debug_level >= 2 then
4205: ec_debug.pop('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');
4206: end if;
4207:
4208: EXCEPTION
4209: WHEN OTHERS THEN

Line 4259: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');

4255: n_att_doc_id_pos NUMBER; --Bug 2187958
4256: n_att_hdr_count NUMBER;
4257: BEGIN
4258: if ec_debug.G_debug_level >= 2 then
4259: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');
4260: ec_debug.pl(3,'cEntity_Name: ', cEntity_Name);
4261: ec_debug.pl(3,'cName: ', cName);
4262: ec_debug.pl(3,'cPK1_Value: ', cPK1_Value);
4263: ec_debug.pl(3,'cPK2_Value: ', cPK2_Value);

Line 4519: ece_poo_transaction.write_to_file( cTransaction_Type,

4515: l_att_header_tbl,
4516: n_header_fkey); */
4517:
4518: -- 2823215
4519: ece_poo_transaction.write_to_file( cTransaction_Type,
4520: cCommunication_Method,
4521: cAtt_Header_Interface,
4522: l_att_header_tbl,
4523: iOutput_width,

Line 4558: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');

4554:
4555: xProgress := 'POOB-60-1210';
4556: dbms_sql.close_cursor(n_att_header_sel_c);
4557: if ec_debug.G_debug_level >= 2 then
4558: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');
4559: end if;
4560:
4561: EXCEPTION
4562: WHEN OTHERS THEN

Line 4641: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');

4637: n_pr_pos NUMBER; -- 3618073
4638:
4639: BEGIN
4640: if ec_debug.G_debug_level = 3 then
4641: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');
4642: ec_debug.pl(3,'cDetail_Output_Level: ' ,cDetail_Output_Level);
4643: ec_debug.pl(3,'cAtt_Detail_Interface: ',cAtt_Detail_Interface);
4644: ec_debug.pl(3,'cAtt_Seq_Num: ' ,cAtt_Seq_Num);
4645: ec_debug.pl(3,'cEntity_Name: ' ,cEntity_Name);

Line 5261: ece_poo_transaction.write_to_file(cTransaction_Type,

5257: cAtt_Detail_Interface,
5258: l_att_detail_tbl,
5259: n_detail_fkey); */
5260: -- 2823215
5261: ece_poo_transaction.write_to_file(cTransaction_Type,
5262: cCommunication_Method,
5263: cAtt_Detail_Interface,
5264: l_att_detail_tbl,
5265: iOutput_width,

Line 5280: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');

5276: xProgress := 'POOB-70-1640';
5277: dbms_sql.close_cursor(n_att_detail_sel_c);
5278:
5279: if ec_debug.G_debug_level >= 2 then
5280: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');
5281: end if;
5282: EXCEPTION
5283: WHEN OTHERS THEN
5284: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 5340: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');

5336: get_no_rows INTEGER;
5337: get_no_lrows INTEGER;
5338: BEGIN
5339: if ec_debug.G_debug_level >= 2 then
5340: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');
5341: ec_debug.pl(3,'cEntity_Name: ',cEntity_Name);
5342: ec_debug.pl(3,'cName: ', cName);
5343: ec_debug.pl(3,'cPK1_Value: ', cPK1_Value);
5344: ec_debug.pl(3,'cPK2_Value: ', cPK2_Value);

Line 5617: ece_poo_transaction.write_to_file(cTransaction_Type,

5613: ec_debug.pl(3,'nAtt_Doc_ID: ',nAtt_Doc_ID);
5614: end if;
5615:
5616: xProgress := 'POOB-80-1250';
5617: ece_poo_transaction.write_to_file(cTransaction_Type,
5618: cCommunication_Method,
5619: cHeader_Interface,
5620: l_header_tbl,
5621: iOutput_width,

Line 5666: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');

5662: dbms_sql.close_cursor(Header_sel_c);
5663: dbms_sql.close_cursor(Header_del_c1);
5664: dbms_sql.close_cursor(Header_del_c2);
5665: if ec_debug.G_debug_level >= 2 then
5666: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');
5667: end if;
5668: EXCEPTION
5669: WHEN OTHERS THEN
5670: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 5721: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');

5717: get_no_rows INTEGER; -- Bug 1892253
5718: get_no_lrows INTEGER;
5719: BEGIN
5720: if ec_debug.G_debug_level >= 2 then
5721: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');
5722: ec_debug.pl(3,'cDetail_Output_Level: ',cDetail_Output_Level);
5723: ec_debug.pl(3,'cAtt_Seq_Num: ', cAtt_Seq_Num);
5724: ec_debug.pl(3,'cEntity_Name: ', cEntity_Name);
5725: ec_debug.pl(3,'cName: ', cName);

Line 6011: ece_poo_transaction.write_to_file(cTransaction_Type,

6007: xProgress := 'POOB-90-1250';
6008: dbms_sql.column_value(Detail_sel_c,iDetail_count + 2,rDetail_X_rowid);
6009:
6010: xProgress := 'POOB-90-1260';
6011: ece_poo_transaction.write_to_file(cTransaction_Type,
6012: cCommunication_Method,
6013: cDetail_Interface,
6014: l_detail_tbl,
6015: iOutput_width,

Line 6041: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');

6037: dbms_sql.close_cursor(Detail_sel_c);
6038: dbms_sql.close_cursor(Detail_del_c1);
6039: dbms_sql.close_cursor(Detail_del_c2);
6040: if ec_debug.G_debug_level >= 2 then
6041: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');
6042: end if;
6043: EXCEPTION
6044: WHEN OTHERS THEN
6045: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 6083: ec_debug.push('ECE_POO_TRANSACTION.WRITE_TO_FILE');

6079:
6080:
6081: BEGIN
6082: if EC_DEBUG.G_debug_level >= 2 then
6083: ec_debug.push('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6084: end if;
6085: xProgress := 'POOB-WR-1020';
6086: FOR i IN 1..iData_count LOOP
6087: xProgress := 'POOB-WR-1030';

Line 6136: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);

6132: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6133: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6134:
6135: xProgress := 'POOB-WR-1100';
6136: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6137: xProgress := 'POOB-WR-1110';
6138: cInsert_stmt := NULL;
6139: -- cInsert_stmt := '*' || TO_CHAR(p_Interface_tbl(i).Record_num);
6140: END IF;

Line 6152: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);

6148: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6149: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6150:
6151: xProgress := 'POOB-WR-1130';
6152: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6153: END IF;
6154: END IF;
6155: END LOOP;
6156:

Line 6158: ec_debug.pop('ECE_POO_TRANSACTION.WRITE_TO_FILE');

6154: END IF;
6155: END LOOP;
6156:
6157: if EC_DEBUG.G_debug_level >= 2 then
6158: ec_debug.pop('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6159: end if;
6160:
6161: EXCEPTION
6162: WHEN utl_file.write_error THEN

Line 6178: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_POO_TRANSACTION.WRITE_TO_FILE');

6174: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6175: app_exception.raise_exception;
6176:
6177: WHEN OTHERS THEN
6178: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_POO_TRANSACTION.WRITE_TO_FILE');
6179: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
6180: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
6181: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6182:

Line 6191: END ECE_POO_TRANSACTION;

6187: app_exception.raise_exception;
6188:
6189: END write_to_file;
6190:
6191: END ECE_POO_TRANSACTION;
6192: