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_POCO_TRANSACTION

Line 1: PACKAGE BODY ece_poco_transaction AS

1: PACKAGE BODY ece_poco_transaction AS
2: -- $Header: ECPOCOB.pls 120.10.12010000.1 2008/07/25 07:25:44 appldev ship $
3: iOutput_width INTEGER := 4000; -- 2823215
4: i_path VARCHAR2(1000);
5: i_filename VARCHAR2(1000);

Line 47: ec_debug.push('ECE_POCO_TRANSACTION.EXTRACT_POCO_OUTBOUND' );

43:
44: BEGIN
45: xProgress := 'POCO-10-1000';
46: ec_debug.enable_debug(v_debug_mode);
47: ec_debug.push('ECE_POCO_TRANSACTION.EXTRACT_POCO_OUTBOUND' );
48: ec_debug.pl(3,'cOutput_Path: ', cOutput_Path );
49: ec_debug.pl(3,'cOutput_Filename: ', cOutput_Filename );
50: ec_debug.pl(3,'cPO_Number_From: ', cPO_Number_From );
51: ec_debug.pl(3,'cPO_Number_To: ', cPO_Number_To );

Line 110: ece_poco_transaction.populate_poco_trx(

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(
111: cCommunication_Method,
112: cTransaction_Type,
113: iOutput_width,
114: SYSDATE,

Line 141: ece_poco_transaction.put_data_to_output_table(

137:
138: -- 2823215
139:
140: /* ec_debug.pl(1,'NUMBER OF RECORDS PROCESSED IS ',xHeaderCount);
141: ece_poco_transaction.put_data_to_output_table(
142: cCommunication_Method,
143: cTransaction_Type,
144: iOutput_width,
145: iRun_id,

Line 164: ec_debug.pop('ECE_POCO_TRANSACTION.EXTRACT_POCO_OUTBOUND');

160: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
161: retcode := 1;
162: END IF;
163:
164: ec_debug.pop('ECE_POCO_TRANSACTION.EXTRACT_POCO_OUTBOUND');
165: ec_debug.disable_debug;
166: COMMIT;
167:
168: EXCEPTION

Line 491: ec_debug.push('ECE_POCO_TRANSACTION.POPULATE_POCO_TRX');

487: FROM po_line_locations
488: WHERE po_line_id = p_line_id;
489:
490: BEGIN
491: ec_debug.push('ECE_POCO_TRANSACTION.POPULATE_POCO_TRX');
492: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
493: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
494: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
495: ec_debug.pl(3,'dTransaction_date: ' ,dTransaction_date);

Line 2196: ec_debug.pop('ECE_POCO_TRANSACTION.POPULATE_POCO_TRX');

2192:
2193: xProgress := 'POCOB-10-1800';
2194: dbms_sql.close_cursor(header_sel_c);
2195:
2196: ec_debug.pop('ECE_POCO_TRANSACTION.POPULATE_POCO_TRX');
2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 2326: ec_debug.push('ECE_POCO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

2322: FROM po_line_locations
2323: WHERE po_line_id = p_line_id;
2324:
2325: BEGIN
2326: ec_debug.push('ECE_POCO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
2327: ec_debug.pl(3,'cCommunication_Method: ',cCommunication_Method);
2328: ec_debug.pl(3,'cTransaction_Type: ' ,cTransaction_Type);
2329: ec_debug.pl(3,'iOutput_width: ' ,iOutput_width);
2330: ec_debug.pl(3,'iRun_id: ' ,iRun_id);

Line 3260: ec_debug.pop('ECE_POCO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

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');
3261:
3262: EXCEPTION
3263: WHEN OTHERS THEN
3264: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 3271: END ece_poco_transaction;

3267: app_exception.raise_exception;
3268:
3269: END put_data_to_output_table;
3270:
3271: END ece_poco_transaction;
3272: