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.12010000.1 2008/07/25 07:23:27 appldev 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 502: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_POO_TRX');

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

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

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

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

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

Line 1371: ece_poo_transaction.update_po(l_document_type,

1367: end if;
1368: xProgress := 'POOB-10-1450';
1369:
1370:
1371: ece_poo_transaction.update_po(l_document_type,
1372: l_header_tbl(nPO_Number_pos).value,
1373: l_header_tbl(nPO_type_pos).value,
1374: l_header_tbl(nRelease_num_pos).value);
1375:

Line 1495: ece_poo_transaction.write_to_file(cTransaction_Type,

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

Line 1526: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1522: end if;
1523: END IF;
1524:
1525: xProgress := 'POOB-10-1505';
1526: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1527: cTransaction_Type,
1528: iRun_id,
1529: 2,
1530: 3,

Line 1721: ece_poo_transaction.write_to_file( cTransaction_Type,

1717: xProgress := 'POOB-10-1620';
1718: ece_poo_x.populate_ext_line(l_line_fkey,l_line_tbl);
1719: -- 2823215
1720: xProgress := 'POOB-10-1621';
1721: ece_poo_transaction.write_to_file( cTransaction_Type,
1722: cCommunication_Method,
1723: cLine_Interface,
1724: l_line_tbl,
1725: iOutput_width,

Line 1759: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1755: -- end if;
1756: END IF;
1757:
1758: xProgress := 'POOB-10-1624';
1759: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1760: cTransaction_Type,
1761: iRun_id,
1762: 5,
1763: 6,

Line 1797: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1793: ec_debug.pl(3,'Item ID: ',v_pk2_value);
1794: end if;
1795:
1796: xProgress := 'POOB-10-1626';
1797: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1798: cTransaction_Type,
1799: iRun_id,
1800: 7,
1801: 8,

Line 1840: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1836: ec_debug.pl(3,'Inventory Org ID: ',v_pk1_value);
1837: end if;
1838:
1839: xProgress := 'POOB-10-1626';
1840: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1841: cTransaction_Type,
1842: iRun_id,
1843: 9,
1844: 10,

Line 2074: ece_poo_transaction.write_to_file(cTransaction_Type,

2070:
2071: END IF;
2072:
2073: -- 2823215
2074: ece_poo_transaction.write_to_file(cTransaction_Type,
2075: cCommunication_Method,
2076: cShipment_Interface,
2077: l_shipment_tbl,
2078: iOutput_width,

Line 2099: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

2095: ec_debug.pl(3,'Ship Level Line Location ID: ',l_shipment_tbl(nShip_Line_Location_ID_pos).value);
2096: end if;
2097:
2098: xProgress := 'POOB-10-1720';
2099: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
2100: cTransaction_Type,
2101: iRun_id,
2102: 12,
2103: 13,

Line 2124: ece_poo_transaction.POPULATE_DISTRIBUTION_INFO(

2120:
2121: -- Project Level Handler
2122: xProgress := 'POOB-10-1730';
2123: -- IF v_project_acct_status = 'I' THEN -- Project Accounting is Installed --Bug 1891291
2124: ece_poo_transaction.POPULATE_DISTRIBUTION_INFO(
2125: cCommunication_Method,
2126: cTransaction_Type,
2127: iRun_id,
2128: cDistribution_Interface,

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

2187: cTransaction_Type);
2188: END IF;
2189:
2190: xProgress := 'POOB-10-1770';
2191: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
2192: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2193: end if;
2194: xProgress := 'POOB-10-1780';
2195: dbms_sql.close_cursor(shipment_sel_c);

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

2188: END IF;
2189:
2190: xProgress := 'POOB-10-1770';
2191: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
2192: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2193: end if;
2194: xProgress := 'POOB-10-1780';
2195: dbms_sql.close_cursor(shipment_sel_c);
2196:

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

2198: dbms_sql.close_cursor(line_sel_c);
2199:
2200: xProgress := 'POOB-10-1800';
2201: dbms_sql.close_cursor(header_sel_c);
2202: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_POO_TRX');
2203:
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

2329: WHERE po_line_id = p_line_id;
2330:
2331: BEGIN
2332: if ec_debug.G_debug_level = 3 then
2333: ec_debug.push('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
2334: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
2335: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
2336: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
2337: ec_debug.pl(3,'iRun_id: ' ,iRun_id);

Line 2874: ece_poo_transaction.write_to_file(cTransaction_Type,

2870:
2871: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
2872:
2873: xProgress := 'POOB-20-1480';
2874: ece_poo_transaction.write_to_file(cTransaction_Type,
2875: cCommunication_Method,
2876: cHeader_Interface,
2877: l_header_tbl,
2878: iOutput_width,

Line 2995: ece_poo_transaction.write_to_file(cTransaction_Type,

2991: ec_debug.pl(3,'c_file_common_key: ',c_file_common_key);
2992: end if;
2993:
2994: xProgress := 'POOB-20-1551';
2995: ece_poo_transaction.write_to_file(cTransaction_Type,
2996: cCommunication_Method,
2997: cLine_Interface,
2998: l_line_tbl,
2999: iOutput_width,

Line 3142: ece_poo_transaction.write_to_file(cTransaction_Type,

3138: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
3139: end if;
3140:
3141: xProgress := 'POOB-20-1630';
3142: ece_poo_transaction.write_to_file(cTransaction_Type,
3143: cCommunication_Method,
3144: cShipment_Interface,
3145: l_shipment_tbl,
3146: iOutput_width,

Line 3176: ece_poo_transaction.PUT_DISTDATA_TO_OUT_TBL(

3172:
3173: -- Project Level Handler
3174: xProgress := 'POOB-20-1634';
3175: -- IF v_project_acct_status = 'I' THEN -- Project Accounting is Installed --bug1891291
3176: ece_poo_transaction.PUT_DISTDATA_TO_OUT_TBL(
3177: cCommunication_Method,
3178: cTransaction_Type,
3179: iOutput_width,
3180: iRun_id,

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

3301: dbms_sql.close_cursor(shipment_del_c2);
3302:
3303: -- Bug 2490109 Closing the distribution cursors.
3304: xProgress := 'POOB-50-1819';
3305: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3306: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3307:
3308: xProgress := 'POOB-50-1820';
3309: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);

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

3302:
3303: -- Bug 2490109 Closing the distribution cursors.
3304: xProgress := 'POOB-50-1819';
3305: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3306: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3307:
3308: xProgress := 'POOB-50-1820';
3309: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3310:

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

3305: if(ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3306: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3307:
3308: xProgress := 'POOB-50-1820';
3309: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3310:
3311: xProgress := 'POOB-50-1821';
3312: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3313: end if;

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

3308: xProgress := 'POOB-50-1820';
3309: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3310:
3311: xProgress := 'POOB-50-1821';
3312: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3313: end if;
3314:
3315: xProgress := 'POOB-20-1820';
3316: if ec_debug.G_debug_level >= 2 then

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

3313: end if;
3314:
3315: xProgress := 'POOB-20-1820';
3316: if ec_debug.G_debug_level >= 2 then
3317: ec_debug.pop('ECE_POO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
3318: end if;
3319:
3320: EXCEPTION
3321: WHEN OTHERS THEN

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

3344: l_error_stack VARCHAR2(2000);
3345:
3346: BEGIN
3347: if ec_debug.G_debug_level >= 2 then
3348: ec_debug.push('ECE_POO_TRANSACTION.UPDATE_PO');
3349: ec_debug.pl(3,'document_type: ', document_type);
3350: ec_debug.pl(3,'po_number: ', po_number);
3351: ec_debug.pl(3,'po_type: ', po_type);
3352: ec_debug.pl(3,'release_number: ',release_number);

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

3506: -- raise_application_error(-20000,l_error_buf || l_error_stack);
3507: -- END IF;
3508:
3509: if ec_debug.G_debug_level = 3 then
3510: ec_debug.pop('ECE_POO_TRANSACTION.UPDATE_PO');
3511: end if;
3512:
3513: EXCEPTION
3514: WHEN OTHERS THEN

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

3577: nConv_tz_pos pls_integer;
3578: nConv_off_pos pls_integer;
3579: BEGIN
3580: if ec_debug.G_debug_level = 3 then
3581: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');
3582: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
3583: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
3584: ec_debug.pl(3,'iRun_id: ' ,iRun_id);
3585: ec_debug.pl(3,'cDistribution_Interface: ' ,cDistribution_Interface);

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

3600: v_project_acct_schema);
3601:
3602: v_project_acct_status := NVL(v_project_acct_status,'X');
3603:
3604: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3605: ece_poo_transaction.project_sel_c:=-911;
3606: end if;
3607:
3608: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109

Line 3605: ece_poo_transaction.project_sel_c:=-911;

3601:
3602: v_project_acct_status := NVL(v_project_acct_status,'X');
3603:
3604: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3605: ece_poo_transaction.project_sel_c:=-911;
3606: end if;
3607:
3608: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109
3609:

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

3604: if ece_poo_transaction.project_sel_c =0 then --Bug 2490109
3605: ece_poo_transaction.project_sel_c:=-911;
3606: end if;
3607:
3608: if ece_poo_transaction.project_sel_c <0 then --Bug 2490109
3609:
3610: xProgress := 'POOB-40-1000';
3611: iKey_count := l_key_tbl.COUNT;
3612: if ec_debug.G_debug_level = 3 then

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

3695: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DATE',nConv_dt_pos);
3696: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_TZ_CODE',nConv_tz_pos);
3697: ece_flatfile_pvt.find_pos(l_project_tbl,'CONVERSION_DT_OFF',nConv_off_pos);
3698:
3699: if ece_poo_transaction.project_sel_c >0 then --Bug 2490109
3700: -- Bind Variables
3701: xProgress := 'POOB-40-1140';
3702: dbms_sql.bind_variable(project_sel_c,':po_header_id',NVL(cPO_Header_ID,0));
3703:

Line 3839: ece_poo_transaction.write_to_file(cTransaction_Type,

3835:
3836: end if;
3837:
3838: -- 2823215
3839: ece_poo_transaction.write_to_file(cTransaction_Type,
3840: cCommunication_Method,
3841: cDistribution_Interface,
3842: l_project_tbl,
3843: iOutput_width,

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

3870: -- dbms_sql.close_cursor(project_sel_c);
3871:
3872: -- Tell Debug that this Procedure is Done
3873: if ec_debug.G_debug_level = 3 then
3874: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_PROJECT_INFO');
3875: end if;
3876:
3877: EXCEPTION
3878: WHEN OTHERS THEN

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

3927: dummy INTEGER;
3928:
3929: BEGIN
3930: if ec_debug.G_debug_level >= 2 then
3931: ec_debug.push('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');
3932: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
3933: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
3934: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
3935: ec_debug.pl(3,'iRun_id: ' ,iRun_id);

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

3941: ec_debug.pl(3,'cFile_Common_Key: ' ,cFile_Common_Key);
3942: end if;
3943:
3944:
3945: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3946: ece_poo_transaction.project_sel_c:=-911;
3947: end if;
3948:
3949: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109

Line 3946: ece_poo_transaction.project_sel_c:=-911;

3942: end if;
3943:
3944:
3945: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3946: ece_poo_transaction.project_sel_c:=-911;
3947: end if;
3948:
3949: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3950: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109

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

3945: if ece_poo_transaction.project_sel_c = 0 then -- Bug 2490109
3946: ece_poo_transaction.project_sel_c:=-911;
3947: end if;
3948:
3949: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3950: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3951:
3952: -- Build the SELECT, FROM, and WHERE Clauses
3953: xProgress := 'POOB-50-1000';

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

3946: ece_poo_transaction.project_sel_c:=-911;
3947: end if;
3948:
3949: if ece_poo_transaction.project_sel_c < 0 then -- Bug 2490109
3950: ece_poo_transaction.l_project_tbl.DELETE; -- Bug 2490109
3951:
3952: -- Build the SELECT, FROM, and WHERE Clauses
3953: xProgress := 'POOB-50-1000';
3954: ece_flatfile_pvt.select_clause(cTransaction_Type,

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

4053: END;
4054:
4055: end if; --Bug 2490109
4056:
4057: if ece_poo_transaction.project_sel_c > 0 then -- Bug 2490109
4058:
4059: -- Set the Counter Variables
4060: xProgress := 'POOB-50-1110';
4061: iProject_count := l_project_tbl.COUNT;

Line 4114: ece_poo_transaction.write_to_file(cTransaction_Type,

4110: xProgress := 'POOB-50-1240';
4111: dbms_sql.column_value(project_sel_c,iProject_count + 2,rProject_X_rowid);
4112:
4113: xProgress := 'POOB-50-1250';
4114: ece_poo_transaction.write_to_file(cTransaction_Type,
4115: cCommunication_Method,
4116: cDistribution_Interface,
4117: l_project_tbl,
4118: iOutput_width,

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

4168: */
4169:
4170: xProgress := 'POOB-50-1350';
4171: if ec_debug.G_debug_level >= 2 then
4172: ec_debug.pop('ECE_POO_TRANSACTION.PUT_PROJECT_DATA_TO_OUTPUT_TBL');
4173: end if;
4174:
4175: EXCEPTION
4176: WHEN OTHERS THEN

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

4222: n_att_doc_id_pos NUMBER; --Bug 2187958
4223: n_att_hdr_count NUMBER;
4224: BEGIN
4225: if ec_debug.G_debug_level >= 2 then
4226: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');
4227: ec_debug.pl(3,'cEntity_Name: ', cEntity_Name);
4228: ec_debug.pl(3,'cName: ', cName);
4229: ec_debug.pl(3,'cPK1_Value: ', cPK1_Value);
4230: ec_debug.pl(3,'cPK2_Value: ', cPK2_Value);

Line 4486: ece_poo_transaction.write_to_file( cTransaction_Type,

4482: l_att_header_tbl,
4483: n_header_fkey); */
4484:
4485: -- 2823215
4486: ece_poo_transaction.write_to_file( cTransaction_Type,
4487: cCommunication_Method,
4488: cAtt_Header_Interface,
4489: l_att_header_tbl,
4490: iOutput_width,

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

4521:
4522: xProgress := 'POOB-60-1210';
4523: dbms_sql.close_cursor(n_att_header_sel_c);
4524: if ec_debug.G_debug_level >= 2 then
4525: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATTACHMENT');
4526: end if;
4527:
4528: EXCEPTION
4529: WHEN OTHERS THEN

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

4604: n_pr_pos NUMBER; -- 3618073
4605:
4606: BEGIN
4607: if ec_debug.G_debug_level = 3 then
4608: ec_debug.push('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');
4609: ec_debug.pl(3,'cDetail_Output_Level: ' ,cDetail_Output_Level);
4610: ec_debug.pl(3,'cAtt_Detail_Interface: ',cAtt_Detail_Interface);
4611: ec_debug.pl(3,'cAtt_Seq_Num: ' ,cAtt_Seq_Num);
4612: ec_debug.pl(3,'cEntity_Name: ' ,cEntity_Name);

Line 5228: ece_poo_transaction.write_to_file(cTransaction_Type,

5224: cAtt_Detail_Interface,
5225: l_att_detail_tbl,
5226: n_detail_fkey); */
5227: -- 2823215
5228: ece_poo_transaction.write_to_file(cTransaction_Type,
5229: cCommunication_Method,
5230: cAtt_Detail_Interface,
5231: l_att_detail_tbl,
5232: iOutput_width,

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

5243: xProgress := 'POOB-70-1640';
5244: dbms_sql.close_cursor(n_att_detail_sel_c);
5245:
5246: if ec_debug.G_debug_level >= 2 then
5247: ec_debug.pop('ECE_POO_TRANSACTION.POPULATE_TEXT_ATT_DETAIL');
5248: end if;
5249: EXCEPTION
5250: WHEN OTHERS THEN
5251: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

5303: get_no_rows INTEGER;
5304: get_no_lrows INTEGER;
5305: BEGIN
5306: if ec_debug.G_debug_level >= 2 then
5307: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');
5308: ec_debug.pl(3,'cEntity_Name: ',cEntity_Name);
5309: ec_debug.pl(3,'cName: ', cName);
5310: ec_debug.pl(3,'cPK1_Value: ', cPK1_Value);
5311: ec_debug.pl(3,'cPK2_Value: ', cPK2_Value);

Line 5584: ece_poo_transaction.write_to_file(cTransaction_Type,

5580: ec_debug.pl(3,'nAtt_Doc_ID: ',nAtt_Doc_ID);
5581: end if;
5582:
5583: xProgress := 'POOB-80-1250';
5584: ece_poo_transaction.write_to_file(cTransaction_Type,
5585: cCommunication_Method,
5586: cHeader_Interface,
5587: l_header_tbl,
5588: iOutput_width,

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

5629: dbms_sql.close_cursor(Header_sel_c);
5630: dbms_sql.close_cursor(Header_del_c1);
5631: dbms_sql.close_cursor(Header_del_c2);
5632: if ec_debug.G_debug_level >= 2 then
5633: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_TO_OUTPUT_TABLE');
5634: end if;
5635: EXCEPTION
5636: WHEN OTHERS THEN
5637: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

5684: get_no_rows INTEGER; -- Bug 1892253
5685: get_no_lrows INTEGER;
5686: BEGIN
5687: if ec_debug.G_debug_level >= 2 then
5688: ec_debug.push('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');
5689: ec_debug.pl(3,'cDetail_Output_Level: ',cDetail_Output_Level);
5690: ec_debug.pl(3,'cAtt_Seq_Num: ', cAtt_Seq_Num);
5691: ec_debug.pl(3,'cEntity_Name: ', cEntity_Name);
5692: ec_debug.pl(3,'cName: ', cName);

Line 5978: ece_poo_transaction.write_to_file(cTransaction_Type,

5974: xProgress := 'POOB-90-1250';
5975: dbms_sql.column_value(Detail_sel_c,iDetail_count + 2,rDetail_X_rowid);
5976:
5977: xProgress := 'POOB-90-1260';
5978: ece_poo_transaction.write_to_file(cTransaction_Type,
5979: cCommunication_Method,
5980: cDetail_Interface,
5981: l_detail_tbl,
5982: iOutput_width,

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

6004: dbms_sql.close_cursor(Detail_sel_c);
6005: dbms_sql.close_cursor(Detail_del_c1);
6006: dbms_sql.close_cursor(Detail_del_c2);
6007: if ec_debug.G_debug_level >= 2 then
6008: ec_debug.pop ('ECE_POO_TRANSACTION.PUT_ATT_DETAIL_TO_OUTPUT_TABLE');
6009: end if;
6010: EXCEPTION
6011: WHEN OTHERS THEN
6012: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

6046:
6047:
6048: BEGIN
6049: if EC_DEBUG.G_debug_level >= 2 then
6050: ec_debug.push('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6051: end if;
6052: xProgress := 'POOB-WR-1020';
6053: FOR i IN 1..iData_count LOOP
6054: xProgress := 'POOB-WR-1030';

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

6099: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6100: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6101:
6102: xProgress := 'POOB-WR-1100';
6103: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6104: xProgress := 'POOB-WR-1110';
6105: cInsert_stmt := NULL;
6106: -- cInsert_stmt := '*' || TO_CHAR(p_Interface_tbl(i).Record_num);
6107: END IF;

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

6115: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6116: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6117:
6118: xProgress := 'POOB-WR-1130';
6119: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6120: END IF;
6121: END IF;
6122: END LOOP;
6123:

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

6121: END IF;
6122: END LOOP;
6123:
6124: if EC_DEBUG.G_debug_level >= 2 then
6125: ec_debug.pop('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6126: end if;
6127:
6128: EXCEPTION
6129: WHEN utl_file.write_error THEN

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

6141: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6142: app_exception.raise_exception;
6143:
6144: WHEN OTHERS THEN
6145: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_POO_TRANSACTION.WRITE_TO_FILE');
6146: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
6147: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
6148: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6149:

Line 6158: END ECE_POO_TRANSACTION;

6154: app_exception.raise_exception;
6155:
6156: END write_to_file;
6157:
6158: END ECE_POO_TRANSACTION;
6159: