APPS.ECE_ADVO_ADVICE_PKG dependencies on ECE_ADVO_ADVICE_PKG

Line 1: PACKAGE BODY ece_advo_advice_pkg AS

1: PACKAGE BODY ece_advo_advice_pkg AS
2: -- $Header: ECADVOB.pls 120.2.12000000.3 2007/03/09 14:37:48 cpeixoto ship $
3:
4: /*===========================================================================
5: PROCEDURE NAME: Extract_ADVO_Outbound

Line 52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );

48:
49: BEGIN
50:
51: ec_debug.enable_debug ( v_debug_mode );
52: ec_debug.push ( 'ECE_ADVO_ADVICE_PKG.Extract_ADVO_Outbound' );
53: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
54: ec_debug.pl ( 3, 'cOutput_Filename: ',cOutput_Filename );
55: ec_debug.pl ( 3, 'p_TP_Group: ',p_TP_Group );
56: ec_debug.pl ( 3, 'p_TP: ',p_TP );

Line 102: ECE_ADVO_ADVICE_PKG.EXTRACT_FROM_BASE_APPS ( p_communication_method,

98: xProgress := 'ADVO-10-1020';
99: ec_debug.pl ( 0, 'EC', 'ECE_RUN_ID', 'RUN_ID', p_run_id );
100:
101: xProgress := 'ADVO-10-1030';
102: ECE_ADVO_ADVICE_PKG.EXTRACT_FROM_BASE_APPS ( p_communication_method,
103: p_transaction_type,
104: p_output_width,
105: p_transaction_date,
106: p_run_id,

Line 123: ece_advo_advice_pkg.Put_Data_To_Output_Table ( p_communication_method,

119: p_ext_ref6 );
120:
121: xProgress := 'ADVO-10-1040';
122:
123: ece_advo_advice_pkg.Put_Data_To_Output_Table ( p_communication_method,
124: p_transaction_type,
125: p_output_width,
126: p_run_id,
127: p_header_interface,

Line 212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );

208: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
209: retcode := 1;
210: END IF;
211:
212: ec_debug.pop ( 'ece_advo_advice_pkg.Extract_ADVO_Outbound' );
213: ec_debug.disable_debug;
214:
215: EXCEPTION
216: WHEN ece_transaction_disabled THEN

Line 410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );

406: ** Debug statements for the parameter values.
407: **
408: */
409:
410: ec_debug.push ( 'ece_advo_advice_pkg.Extract_From_Base_Apps' );
411: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
412: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
413: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
414: ec_debug.pl ( 3, 'dTransaction_date: ',dTransaction_date );

Line 1110: ec_debug.pop('ece_advo_advice_pkg.Extract_From_Base_Apps' );

1106:
1107: xProgress := 'ADVOB-10-1460';
1108: dbms_sql.close_cursor(Line_sel_c );
1109:
1110: ec_debug.pop('ece_advo_advice_pkg.Extract_From_Base_Apps' );
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114:

Line 1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );

1245: ** Debug statements for the parameter values.
1246: **
1247: */
1248:
1249: ec_debug.push ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1250: ec_debug.pl ( 3, 'cCommunication_Method: ', cCommunication_Method );
1251: ec_debug.pl ( 3, 'cTransaction_Type: ',cTransaction_Type );
1252: ec_debug.pl ( 3, 'iOutput_width: ',iOutput_width );
1253: ec_debug.pl ( 3, 'iRun_id: ',iRun_id );

Line 1899: ec_debug.pop ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );

1895:
1896: xProgress := 'ADVOB-20-1650';
1897: dbms_sql.close_cursor ( Line_del_c1 );
1898:
1899: ec_debug.pop ( 'ece_advo_advice_pkg.Put_Data_To_Output_Table' );
1900:
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903:

Line 1920: END ece_advo_advice_pkg;

1916: app_exception.raise_exception;
1917:
1918: END Put_Data_To_Output_Table;
1919:
1920: END ece_advo_advice_pkg;