APPS.ECE_MVSTO_TRANSACTION dependencies on ECE_MVSTO_TRANSACTION

Line 1: PACKAGE BODY ECE_MVSTO_TRANSACTION AS

1: PACKAGE BODY ECE_MVSTO_TRANSACTION AS
2: -- $Header: ECEMVSOB.pls 120.2.12000000.2 2007/03/09 14:39:44 cpeixoto ship $
3:
4: /*===========================================================================
5: PROCEDURE NAME: Extract_MVSTO_Outbound

Line 45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');

41:
42: BEGIN
43: xProgress := 'MVSTO-10-1000';
44: ec_debug.enable_debug(v_debug_mode);
45: ec_debug.push ('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
46: ec_debug.pl(3,'cOutput_Path: ',cOutput_Path);
47: ec_debug.pl(3,'cOutput_Filename: ',cOutput_Filename);
48: ec_debug.pl(3,'cLegal_Entity: ',cLegal_Entity);
49: ec_debug.pl(3,'cZone_Code: ',cZone_Code);

Line 91: ece_mvsto_transaction.populate_mvsto_trx(cCommunication_Method,

87: xProgress := 'MVSTO-10-1010';
88: ec_debug.pl(0, 'EC', 'ECE_RUN_ID', 'RUN_ID', iRun_id);
89:
90: xProgress := 'MVSTO-10-1020';
91: ece_mvsto_transaction.populate_mvsto_trx(cCommunication_Method,
92: cTransaction_Type,
93: iOutput_width,
94: sysdate,
95: iRun_id,

Line 107: ece_mvsto_transaction.put_data_to_output_table(cCommunication_Method,

103: cMovement_Type,
104: cInclude_Address);
105:
106: xProgress := 'MVSTO-10-1030';
107: ece_mvsto_transaction.put_data_to_output_table(cCommunication_Method,
108: cTransaction_Type,
109: iOutput_width,
110: iRun_id,
111: cHeader_Interface,

Line 187: ec_debug.pop('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');

183: retcode := 1;
184: END IF;
185:
186: ec_debug.pl(0,'EC','ECE_MVSTO_END',NULL);
187: ec_debug.pop('ECE_MVSTO_TRANSACTION.Extract_MVSTO_Outbound');
188: ec_debug.disable_debug;
189: COMMIT;
190:
191: EXCEPTION

Line 358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');

354: msg_data VARCHAR2(20);
355:
356: BEGIN
357:
358: ec_debug.push('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
359: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
360: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
361: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
362: ec_debug.pl(3, 'dTransaction_date: ',dTransaction_date);

Line 1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');

1117: DBMS_SQL.CLOSE_CURSOR(Line_sel_c);
1118:
1119: xProgress := 'MVSTOB-20-1740';
1120: DBMS_SQL.CLOSE_CURSOR(Header_sel_c);
1121: ec_debug.pop('ECE_MVSTO_TRANSACTION.POPULATE_MVSTO_TRX');
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125:

Line 1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

1223: ntransaction_line_id NUMBER;
1224:
1225: BEGIN
1226:
1227: ec_debug.push('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1228: ec_debug.pl(3, 'cCommunication_Method: ', cCommunication_Method);
1229: ec_debug.pl(3, 'cTransaction_Type: ',cTransaction_Type);
1230: ec_debug.pl(3, 'iOutput_width: ',iOutput_width);
1231: ec_debug.pl(3, 'iRun_id: ',iRun_id);

Line 1956: ec_debug.pop('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');

1952: xProgress := 'MVSTOB-10-1818';
1953: DBMS_SQL.CLOSE_CURSOR(Location_del_c2);
1954:
1955: xProgress := 'MVSTOB-10-1820';
1956: ec_debug.pop('ECE_MVSTO_TRANSACTION.PUT_DATA_TO_OUTPUT_TABLE');
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960:

Line 1977: END ECE_MVSTO_TRANSACTION;

1973: app_exception.raise_exception;
1974:
1975: END PUT_DATA_TO_OUTPUT_TABLE;
1976:
1977: END ECE_MVSTO_TRANSACTION;
1978: