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

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

85:
86: xProgress := 'POCO-10-1010';
87: ec_debug.pl(0,'EC','ECE_RUN_ID','RUN_ID',iRun_id);
88:
89: ece_poo_transaction.project_sel_c:=0; --Bug 2490109
90:
91: IF cOutput_Filename IS NULL THEN --Bug 2430822
92: cFilename := 'POCO' || iRun_id || '.dat';
93: ELSE

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

102: -- ec_debug.pl(1,'Open Output file'); --Bug 2034376
103: end if;
104: i_path := cOutput_Path;
105: i_filename := cFilename;
106: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790
107:
108: xProgress := 'POCO-10-1020';
109: ec_debug.pl(1,'Call Populate Poco Trx procedure'); --Bug 2034376
110: ece_poco_transaction.populate_poco_trx(

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

149: cProject_Interface); */
150:
151: xProgress := 'POCO-10-1090';
152: ec_debug.pl(1,'Close Output file'); --Bug 2034376
153: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
154: utl_file.fclose(ece_poo_transaction.uFile_type);
155: end if;
156:
157:

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

150:
151: xProgress := 'POCO-10-1090';
152: ec_debug.pl(1,'Close Output file'); --Bug 2034376
153: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
154: utl_file.fclose(ece_poo_transaction.uFile_type);
155: end if;
156:
157:
158:

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

177: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
178:
179: retcode := 2;
180: ec_debug.disable_debug;
181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

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

179: retcode := 2;
180: ec_debug.disable_debug;
181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;

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

181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;
188:
189: WHEN utl_file.invalid_path THEN

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

182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;
188:
189: WHEN utl_file.invalid_path THEN
190: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);

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

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

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

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

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

203: if (utl_file.is_open(ece_poo_transaction.uFile_type))
204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
208: utl_file.fclose(ece_poo_transaction.uFile_type);
209: ROLLBACK;
210:
211: WHEN OTHERS THEN

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

204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
208: utl_file.fclose(ece_poo_transaction.uFile_type);
209: ROLLBACK;
210:
211: WHEN OTHERS THEN
212: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

213: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
214:
215: retcode := 2;
216: ec_debug.disable_debug;
217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

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

215: retcode := 2;
216: ec_debug.disable_debug;
217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;

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

217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;
224:
225: END extract_poco_outbound;

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

218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;
224:
225: END extract_poco_outbound;
226:

Line 562: IF n_att_seg_size < 1 OR n_att_seg_size > ece_poo_transaction.G_MAX_ATT_SEG_SIZE OR n_att_seg_size IS NULL THEN

558: END IF;
559:
560: IF v_att_enabled = 'Y' THEN
561: BEGIN
562: IF n_att_seg_size < 1 OR n_att_seg_size > ece_poo_transaction.G_MAX_ATT_SEG_SIZE OR n_att_seg_size IS NULL THEN
563: RAISE invalid_number;
564: END IF;
565:
566: EXCEPTION

Line 568: ec_debug.pl(0,'EC','ECE_INVALID_SEGMENT_NUM','SEGMENT_VALUE',n_att_seg_size,'SEGMENT_DEFAULT',ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE);

564: END IF;
565:
566: EXCEPTION
567: WHEN value_error OR invalid_number THEN
568: ec_debug.pl(0,'EC','ECE_INVALID_SEGMENT_NUM','SEGMENT_VALUE',n_att_seg_size,'SEGMENT_DEFAULT',ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE);
569: n_att_seg_size := ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE;
570: END;
571: END IF;
572:

Line 569: n_att_seg_size := ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE;

565:
566: EXCEPTION
567: WHEN value_error OR invalid_number THEN
568: ec_debug.pl(0,'EC','ECE_INVALID_SEGMENT_NUM','SEGMENT_VALUE',n_att_seg_size,'SEGMENT_DEFAULT',ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE);
569: n_att_seg_size := ece_poo_transaction.G_DEFAULT_ATT_SEG_SIZE;
570: END;
571: END IF;
572:
573: ec_debug.pl(3,'v_header_att_enabled: ',v_header_att_enabled);

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

1280: -- ***************************************************
1281: xProgress := 'POCOB-10-1410';
1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
1283:
1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1286: end if;
1287: counter := 0;
1288: -- **************************************

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

1281: xProgress := 'POCOB-10-1410';
1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
1283:
1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1286: end if;
1287: counter := 0;
1288: -- **************************************
1289: -- store internal values in pl/sql table

Line 1329: ece_poo_transaction.update_po(l_document_type,

1325: END;
1326: ec_debug.pl(3, 'l_document_type: ',l_document_type);
1327:
1328: xProgress := 'POCOB-10-1450';
1329: ece_poo_transaction.update_po(l_document_type,
1330: l_header_tbl(nPO_Number_pos).value,
1331: l_header_tbl(nPO_type_pos).value,
1332: l_header_tbl(nRelease_num_pos).value);
1333: xProgress := 'POCOB-TZ-1500';

Line 1453: ece_poo_transaction.write_to_file(cTransaction_Type,

1449: xProgress := 'POCOB-10-1500';
1450: ece_poco_x.populate_ext_header(l_header_fkey,l_header_tbl);
1451:
1452: -- 2823215
1453: ece_poo_transaction.write_to_file(cTransaction_Type,
1454: cCommunication_Method,
1455: cHeader_Interface,
1456: l_header_tbl,
1457: iOutput_width,

Line 1479: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1475: ec_debug.pl(3,'po_header_id: ',l_header_tbl(nHeader_key_pos).value);
1476: END IF;
1477:
1478: xProgress := 'POCOB-10-1505';
1479: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1480: cTransaction_Type,
1481: iRun_id,
1482: 2,
1483: 3,

Line 1489: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903

1485: cAtt_Detail_Interface,
1486: v_entity_name,
1487: 'VENDOR',
1488: v_pk1_value,
1489: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1490: ECE_POO_TRANSACTION.C_ANY_VALUE,
1491: ECE_POO_TRANSACTION.C_ANY_VALUE,
1492: ECE_POO_TRANSACTION.C_ANY_VALUE,
1493: n_att_seg_size,

Line 1490: ECE_POO_TRANSACTION.C_ANY_VALUE,

1486: v_entity_name,
1487: 'VENDOR',
1488: v_pk1_value,
1489: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1490: ECE_POO_TRANSACTION.C_ANY_VALUE,
1491: ECE_POO_TRANSACTION.C_ANY_VALUE,
1492: ECE_POO_TRANSACTION.C_ANY_VALUE,
1493: n_att_seg_size,
1494: l_key_tbl,

Line 1491: ECE_POO_TRANSACTION.C_ANY_VALUE,

1487: 'VENDOR',
1488: v_pk1_value,
1489: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1490: ECE_POO_TRANSACTION.C_ANY_VALUE,
1491: ECE_POO_TRANSACTION.C_ANY_VALUE,
1492: ECE_POO_TRANSACTION.C_ANY_VALUE,
1493: n_att_seg_size,
1494: l_key_tbl,
1495: c_file_common_key,

Line 1492: ECE_POO_TRANSACTION.C_ANY_VALUE,

1488: v_pk1_value,
1489: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1490: ECE_POO_TRANSACTION.C_ANY_VALUE,
1491: ECE_POO_TRANSACTION.C_ANY_VALUE,
1492: ECE_POO_TRANSACTION.C_ANY_VALUE,
1493: n_att_seg_size,
1494: l_key_tbl,
1495: c_file_common_key,
1496: l_hdr_att_hdr_tbl,

Line 1744: ece_poo_transaction.write_to_file( cTransaction_Type,

1740: -- 2823215
1741: xProgress := 'POCOB-10-1620';
1742: ece_poco_x.populate_ext_line(l_line_fkey,l_line_tbl);
1743:
1744: ece_poo_transaction.write_to_file( cTransaction_Type,
1745: cCommunication_Method,
1746: cLine_Interface,
1747: l_line_tbl,
1748: iOutput_width,

Line 1781: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1777: ec_debug.pl(3,'PO_LINE_ID: ',l_line_tbl(nLine_key_pos).value);
1778: -- END IF;
1779:
1780: xProgress := 'POCOB-10-1624';
1781: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1782: cTransaction_Type,
1783: iRun_id,
1784: 5,
1785: 6,

Line 1791: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903

1787: cAtt_Detail_Interface,
1788: v_entity_name,
1789: 'VENDOR',
1790: v_pk1_value,
1791: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1792: ECE_POO_TRANSACTION.C_ANY_VALUE,
1793: ECE_POO_TRANSACTION.C_ANY_VALUE,
1794: ECE_POO_TRANSACTION.C_ANY_VALUE,
1795: n_att_seg_size,

Line 1792: ECE_POO_TRANSACTION.C_ANY_VALUE,

1788: v_entity_name,
1789: 'VENDOR',
1790: v_pk1_value,
1791: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1792: ECE_POO_TRANSACTION.C_ANY_VALUE,
1793: ECE_POO_TRANSACTION.C_ANY_VALUE,
1794: ECE_POO_TRANSACTION.C_ANY_VALUE,
1795: n_att_seg_size,
1796: l_key_tbl,

Line 1793: ECE_POO_TRANSACTION.C_ANY_VALUE,

1789: 'VENDOR',
1790: v_pk1_value,
1791: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1792: ECE_POO_TRANSACTION.C_ANY_VALUE,
1793: ECE_POO_TRANSACTION.C_ANY_VALUE,
1794: ECE_POO_TRANSACTION.C_ANY_VALUE,
1795: n_att_seg_size,
1796: l_key_tbl,
1797: c_file_common_key,

Line 1794: ECE_POO_TRANSACTION.C_ANY_VALUE,

1790: v_pk1_value,
1791: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
1792: ECE_POO_TRANSACTION.C_ANY_VALUE,
1793: ECE_POO_TRANSACTION.C_ANY_VALUE,
1794: ECE_POO_TRANSACTION.C_ANY_VALUE,
1795: n_att_seg_size,
1796: l_key_tbl,
1797: c_file_common_key,
1798: l_ln_att_hdr_tbl,

Line 1817: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1813: v_pk2_value := l_line_tbl(nitem_id_pos).value; -- Item ID
1814: ec_debug.pl(3,'Item ID: ',v_pk2_value);
1815:
1816: xProgress := 'POCOB-10-1626';
1817: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1818: cTransaction_Type,
1819: iRun_id,
1820: 7,
1821: 8,

Line 1855: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

1851: v_pk1_value := v_org_id.ship_to_organization_id;
1852: ec_debug.pl(3,'Inventory Org ID: ',v_pk1_value);
1853:
1854: xProgress := 'POCOB-10-1626';
1855: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
1856: cTransaction_Type,
1857: iRun_id,
1858: 9,
1859: 10,

Line 2096: ece_poo_transaction.write_to_file(cTransaction_Type,

2092:
2093: END IF;
2094:
2095:
2096: ece_poo_transaction.write_to_file(cTransaction_Type,
2097: cCommunication_Method,
2098: cShipment_Interface,
2099: l_shipment_tbl,
2100: iOutput_width,

Line 2118: ece_poo_transaction.populate_text_attachment(cCommunication_Method,

2114: v_pk1_value := l_shipment_tbl(nShip_Line_Location_ID_pos).value;
2115: ec_debug.pl(3,'Ship Level Line Location ID: ',l_shipment_tbl(nShip_Line_Location_ID_pos).value);
2116:
2117: xProgress := 'POCOB-10-1720';
2118: ece_poo_transaction.populate_text_attachment(cCommunication_Method,
2119: cTransaction_Type,
2120: iRun_id,
2121: 12,
2122: 13,

Line 2128: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903

2124: cAtt_Detail_Interface,
2125: v_entity_name,
2126: 'VENDOR',
2127: v_pk1_value,
2128: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
2129: ECE_POO_TRANSACTION.C_ANY_VALUE,
2130: ECE_POO_TRANSACTION.C_ANY_VALUE,
2131: ECE_POO_TRANSACTION.C_ANY_VALUE,
2132: n_att_seg_size,

Line 2129: ECE_POO_TRANSACTION.C_ANY_VALUE,

2125: v_entity_name,
2126: 'VENDOR',
2127: v_pk1_value,
2128: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
2129: ECE_POO_TRANSACTION.C_ANY_VALUE,
2130: ECE_POO_TRANSACTION.C_ANY_VALUE,
2131: ECE_POO_TRANSACTION.C_ANY_VALUE,
2132: n_att_seg_size,
2133: l_key_tbl,

Line 2130: ECE_POO_TRANSACTION.C_ANY_VALUE,

2126: 'VENDOR',
2127: v_pk1_value,
2128: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
2129: ECE_POO_TRANSACTION.C_ANY_VALUE,
2130: ECE_POO_TRANSACTION.C_ANY_VALUE,
2131: ECE_POO_TRANSACTION.C_ANY_VALUE,
2132: n_att_seg_size,
2133: l_key_tbl,
2134: c_file_common_key,

Line 2131: ECE_POO_TRANSACTION.C_ANY_VALUE,

2127: v_pk1_value,
2128: ECE_POO_TRANSACTION.C_ANY_VALUE, -- BUG:5367903
2129: ECE_POO_TRANSACTION.C_ANY_VALUE,
2130: ECE_POO_TRANSACTION.C_ANY_VALUE,
2131: ECE_POO_TRANSACTION.C_ANY_VALUE,
2132: n_att_seg_size,
2133: l_key_tbl,
2134: c_file_common_key,
2135: l_shp_att_hdr_tbl,

Line 2143: ece_poo_transaction.populate_distribution_info(

2139:
2140: -- Project Level Handler
2141: xProgress := 'POCOB-10-1730';
2142: -- if project_acct_status = 'I' THEN -- Project Accounting is Installed bug 1891291
2143: ece_poo_transaction.populate_distribution_info(
2144: cCommunication_Method,
2145: cTransaction_Type,
2146: iRun_id,
2147: cProject_Interface,

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

2178: END IF;
2179:
2180: xProgress := 'POCOB-10-1770';
2181:
2182: if (ece_poo_transaction.project_sel_c >0) then --Bug 2819176
2183:
2184: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2185: end if;
2186: xProgress := 'POCOB-10-1780';

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

2180: xProgress := 'POCOB-10-1770';
2181:
2182: if (ece_poo_transaction.project_sel_c >0) then --Bug 2819176
2183:
2184: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c); --Bug 2490109
2185: end if;
2186: xProgress := 'POCOB-10-1780';
2187:
2188: dbms_sql.close_cursor(shipment_sel_c);

Line 2848: ece_poo_transaction.write_to_file(cTransaction_Type,

2844:
2845: ec_debug.pl(3,'c_file_common_key: ',c_file_common_key);
2846:
2847: xProgress := 'POCOB-20-1480';
2848: ece_poo_transaction.write_to_file(cTransaction_Type,
2849: cCommunication_Method,
2850: cHeader_Interface,
2851: l_header_tbl,
2852: iOutput_width,

Line 2870: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,

2866: ec_debug.pl(3,'po_header_id: ',n_po_header_id);
2867: END IF;
2868:
2869: xProgress := 'POCOB-20-1483';
2870: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,
2871: cTransaction_Type,
2872: iOutput_width,
2873: iRun_id,
2874: 2,

Line 2952: ece_poo_transaction.write_to_file(cTransaction_Type,

2948: RPAD(' ',22);
2949: ec_debug.pl(3,'c_file_common_key: ',c_file_common_key);
2950:
2951: xProgress := 'POCOB-20-1551';
2952: ece_poo_transaction.write_to_file(cTransaction_Type,
2953: cCommunication_Method,
2954: cLine_Interface,
2955: l_line_tbl,
2956: iOutput_width,

Line 2973: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,

2969: v_pk1_value := n_po_line_id; -- LINE_ID
2970: -- END IF;
2971:
2972: xProgress := 'POCOB-20-1554';
2973: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,
2974: cTransaction_Type,
2975: iOutput_width,
2976: iRun_id,
2977: 5,

Line 3000: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,

2996: v_pk2_value := nItem_ID; -- Item ID
2997: ec_debug.pl(3,'Item ID: ',v_pk2_value);
2998:
2999: xProgress := 'POCOB-20-1556';
3000: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,
3001: cTransaction_Type,
3002: iOutput_width,
3003: iRun_id,
3004: 7,

Line 3025: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,

3021: v_pk1_value := v_org_id.ship_to_organization_id;
3022: ec_debug.pl(3,'Inventory Org ID: ',v_pk1_value);
3023:
3024: xProgress := 'POCOB-20-1558';
3025: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,
3026: cTransaction_Type,
3027: iOutput_width,
3028: iRun_id,
3029: 9,

Line 3086: ece_poo_transaction.write_to_file(cTransaction_Type,

3082: RPAD(SUBSTRB(NVL(l_shipment_tbl(nShipment_key_pos).value,' '),1,22),22);
3083: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
3084:
3085: xProgress := 'POCOB-20-1630';
3086: ece_poo_transaction.write_to_file(cTransaction_Type,
3087: cCommunication_Method,
3088: cShipment_Interface,
3089: l_shipment_tbl,
3090: iOutput_width,

Line 3100: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,

3096: v_entity_name := 'PO_SHIPMENTS';
3097: v_pk1_value := nLine_Location_ID;
3098:
3099: xProgress := 'POCOB-20-1632';
3100: ece_poo_transaction.put_att_to_output_table(cCommunication_Method,
3101: cTransaction_Type,
3102: iOutput_width,
3103: iRun_id,
3104: 12,

Line 3120: ece_poo_transaction.put_distdata_to_out_tbl(

3116:
3117: -- Project Level Handler
3118: xProgress := 'POCOB-20-1634';
3119: -- IF v_project_acct_status = 'I' THEN -- Project Accounting is Installed bug1891291
3120: ece_poo_transaction.put_distdata_to_out_tbl(
3121: cCommunication_Method,
3122: cTransaction_Type,
3123: iOutput_width,
3124: iRun_id,

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

3245: dbms_sql.close_cursor(shipment_del_c2);
3246:
3247: -- Bug 2490109 Closing the distribution cursors.
3248: xProgress := 'POCOB-50-1819';
3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3251:
3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);

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

3246:
3247: -- Bug 2490109 Closing the distribution cursors.
3248: xProgress := 'POCOB-50-1819';
3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3251:
3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:

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

3249: if (ece_poo_transaction.project_sel_c>0) then --Bug 2819176
3250: dbms_sql.close_cursor(ece_poo_transaction.project_sel_c);
3251:
3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:
3255: xProgress := 'POCOB-50-1821';
3256: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3257: end if;

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

3252: xProgress := 'POCOB-50-1820';
3253: dbms_sql.close_cursor(ece_poo_transaction.project_del_c1);
3254:
3255: xProgress := 'POCOB-50-1821';
3256: dbms_sql.close_cursor(ece_poo_transaction.project_del_c2);
3257: end if;
3258:
3259: xProgress := 'POCOB-20-1820';
3260: ec_debug.pop('ECE_POCO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');