DBA Data[Home] [Help]

APPS.ECEPOCI dependencies on EC_DEBUG

Line 27: ec_debug.enable_debug(i_debug_mode);

23: cEnabled VARCHAR2(1) := 'Y';
24: ece_transaction_disabled EXCEPTION;
25:
26: begin
27: ec_debug.enable_debug(i_debug_mode);
28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);

Line 28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

24: ece_transaction_disabled EXCEPTION;
25:
26: begin
27: ec_debug.enable_debug(i_debug_mode);
28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);

Line 29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');

25:
26: begin
27: ec_debug.enable_debug(i_debug_mode);
28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);

Line 30: ec_debug.pl(3,'i_file_path',i_file_path);

26: begin
27: ec_debug.enable_debug(i_debug_mode);
28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 31: ec_debug.pl(3,'i_file_name',i_file_name);

27: ec_debug.enable_debug(i_debug_mode);
28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
35: ec_debug.pl(3,'i_num_instances',i_num_instances);

Line 32: ec_debug.pl(3,'i_run_import',i_run_import);

28: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
35: ec_debug.pl(3,'i_num_instances',i_num_instances);
36:

Line 33: ec_debug.pl(3,'i_map_id',i_map_id);

29: ec_debug.push('ECEPOCI.PROCESS_POCI_INBOUND');
30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
35: ec_debug.pl(3,'i_num_instances',i_num_instances);
36:
37: /* Check to see if the transaction is enabled. If not, abort */

Line 34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

30: ec_debug.pl(3,'i_file_path',i_file_path);
31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
35: ec_debug.pl(3,'i_num_instances',i_num_instances);
36:
37: /* Check to see if the transaction is enabled. If not, abort */
38: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);

Line 35: ec_debug.pl(3,'i_num_instances',i_num_instances);

31: ec_debug.pl(3,'i_file_name',i_file_name);
32: ec_debug.pl(3,'i_run_import',i_run_import);
33: ec_debug.pl(3,'i_map_id',i_map_id);
34: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
35: ec_debug.pl(3,'i_num_instances',i_num_instances);
36:
37: /* Check to see if the transaction is enabled. If not, abort */
38: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
39: IF cEnabled = 'N' THEN

Line 43: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);

39: IF cEnabled = 'N' THEN
40: RAISE ece_transaction_disabled;
41: END IF;
42:
43: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
44:
45: select map_type into i_map_type
46: from ece_mappings
47: where map_id = i_map_id

Line 69: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);

65: i_run_id
66: );
67: END IF;
68:
69: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
70:
71: /**
72: Initialize the Stack Table
73: **/

Line 76: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

72: Initialize the Stack Table
73: **/
74: ec_utils.g_stack.DELETE;
75:
76: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
77: ece_inbound.process_run_inbound (
78: i_transaction_type => i_transaction_type,
79: i_run_id => i_run_id
80: );

Line 82: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

78: i_transaction_type => i_transaction_type,
79: i_run_id => i_run_id
80: );
81:
82: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
83:
84: IF i_Run_Import = 'Y' THEN
85: i_Submit_ID := fnd_request.submit_request (
86: application => 'ONT',

Line 97: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE',

93: argument6 => '1', -- Debug Level = 1
94: argument7 => i_num_instances -- No. of Instances
95: );
96:
97: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE',
98: 'TRANSACTION_TYPE',i_transaction_type,
99: 'REQUEST_ID',i_Submit_Id);
100: END IF;
101:

Line 106: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

102: COMMIT;
103: retcode := ec_utils.i_ret_code;
104:
105: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type) = 'U' THEN
106: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
107: retcode := 1;
108: END IF;
109:
110: ec_debug.pl(3,'i_submit_id',i_submit_id);

Line 110: ec_debug.pl(3,'i_submit_id',i_submit_id);

106: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
107: retcode := 1;
108: END IF;
109:
110: ec_debug.pl(3,'i_submit_id',i_submit_id);
111: ec_debug.pl(3,'retcode',retcode);
112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:

Line 111: ec_debug.pl(3,'retcode',retcode);

107: retcode := 1;
108: END IF;
109:
110: ec_debug.pl(3,'i_submit_id',i_submit_id);
111: ec_debug.pl(3,'retcode',retcode);
112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:
115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

Line 112: ec_debug.pl(3,'errbuf',errbuf);

108: END IF;
109:
110: ec_debug.pl(3,'i_submit_id',i_submit_id);
111: ec_debug.pl(3,'retcode',retcode);
112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:
115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
116: ec_debug.disable_debug;

Line 113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');

109:
110: ec_debug.pl(3,'i_submit_id',i_submit_id);
111: ec_debug.pl(3,'retcode',retcode);
112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:
115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
116: ec_debug.disable_debug;
117:

Line 115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

111: ec_debug.pl(3,'retcode',retcode);
112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:
115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
116: ec_debug.disable_debug;
117:
118: EXCEPTION
119: WHEN ece_transaction_disabled THEN

Line 116: ec_debug.disable_debug;

112: ec_debug.pl(3,'errbuf',errbuf);
113: ec_debug.pop('ECEPOCI.PROCESS_POCI_INBOUND');
114:
115: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
116: ec_debug.disable_debug;
117:
118: EXCEPTION
119: WHEN ece_transaction_disabled THEN
120: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

Line 120: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

116: ec_debug.disable_debug;
117:
118: EXCEPTION
119: WHEN ece_transaction_disabled THEN
120: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
121: retcode := 1;
122: ec_debug.disable_debug;
123: ROLLBACK WORK;
124:

Line 122: ec_debug.disable_debug;

118: EXCEPTION
119: WHEN ece_transaction_disabled THEN
120: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
121: retcode := 1;
122: ec_debug.disable_debug;
123: ROLLBACK WORK;
124:
125: WHEN EC_UTILS.PROGRAM_EXIT then
126: errbuf := ec_utils.i_errbuf;

Line 130: ec_debug.disable_debug;

126: errbuf := ec_utils.i_errbuf;
127: retcode := ec_utils.i_ret_code;
128: ece_flatfile_pvt.print_attributes;
129: rollback work;
130: ec_debug.disable_debug;
131:
132: WHEN OTHERS THEN
133: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
134: 'ECEPOCI.PROCESS_POCI_INBOUND');

Line 133: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

129: rollback work;
130: ec_debug.disable_debug;
131:
132: WHEN OTHERS THEN
133: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
134: 'ECEPOCI.PROCESS_POCI_INBOUND');
135: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
136: retcode := 2;
137: rollback work;

Line 135: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

131:
132: WHEN OTHERS THEN
133: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
134: 'ECEPOCI.PROCESS_POCI_INBOUND');
135: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
136: retcode := 2;
137: rollback work;
138: ece_flatfile_pvt.print_attributes;
139: ec_debug.disable_debug;

Line 139: ec_debug.disable_debug;

135: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
136: retcode := 2;
137: rollback work;
138: ece_flatfile_pvt.print_attributes;
139: ec_debug.disable_debug;
140:
141: END PROCESS_POCI_INBOUND;
142:
143: