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.IBY_PYO_TRANSACTION dependencies on EC_DEBUG

Line 50: ec_debug.enable_debug(p_debug_mode);

46: p_Debug_Mode := 3;
47: END IF;
48:
49:
50: ec_debug.enable_debug(p_debug_mode);
51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );

Line 51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );

47: END IF;
48:
49:
50: ec_debug.enable_debug(p_debug_mode);
51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
55:

Line 52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');

48:
49:
50: ec_debug.enable_debug(p_debug_mode);
51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
55:
56: i_Transaction_Type := 'PYO';

Line 53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );

49:
50: ec_debug.enable_debug(p_debug_mode);
51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
55:
56: i_Transaction_Type := 'PYO';
57:

Line 54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );

50: ec_debug.enable_debug(p_debug_mode);
51: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
52: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
53: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
54: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
55:
56: i_Transaction_Type := 'PYO';
57:
58: /*

Line 85: ec_debug.pl(3,'File Id returned from ext pub::',i_file_id );

81: -- Derive output filename
82: -- IF fnd_global.conc_request_id IS NOT NULL THEN
83:
84: i_file_id := IBY_EC_OP_FILE_NAME_EXT_PUB.get_File_Id(p_payment_instruction_id);
85: ec_debug.pl(3,'File Id returned from ext pub::',i_file_id );
86:
87:
88: IF i_file_id is null THEN
89: BEGIN

Line 94: ec_debug.pl ( 0,

90: SELECT ece_output_runs_s.NEXTVAL INTO i_file_id
91: FROM DUAL;
92: EXCEPTION
93: WHEN NO_DATA_FOUND THEN
94: ec_debug.pl ( 0,
95: 'EC',
96: 'ECE_GET_NEXT_SEQ_FAILED',
97: 'PROGRESS_LEVEL',
98: xProgress,

Line 105: ec_debug.pl (3, 'comes here');

101: );
102: END;
103: END IF;
104:
105: ec_debug.pl (3, 'comes here');
106:
107: ec_debug.pl ( 3, 'File ID ',i_file_id);
108:
109:

Line 107: ec_debug.pl ( 3, 'File ID ',i_file_id);

103: END IF;
104:
105: ec_debug.pl (3, 'comes here');
106:
107: ec_debug.pl ( 3, 'File ID ',i_file_id);
108:
109:
110: i_Filename := i_Transaction_Type || i_file_id || '.dat';
111:

Line 116: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );

112:
113: xProgress := 'PYO-10-1005';
114: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
115: cOutput_path );
116: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
117:
118:
119:
120:

Line 124: ec_debug.pl ( 0, 'EC', 'ECE_PAYMENT_BATCH', 'PAYMENT INSTRUCTION ID ', p_payment_instruction_id );

120:
121:
122:
123: xProgress := 'PYO-10-1030';
124: ec_debug.pl ( 0, 'EC', 'ECE_PAYMENT_BATCH', 'PAYMENT INSTRUCTION ID ', p_payment_instruction_id );
125:
126: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: START ::'||systimestamp);
127:
128: ec_document.process_outbound(

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

149: p_data => x_msg_data);
150:
151:
152: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_Transaction_Type) = 'U' THEN
153: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
154: END IF;
155:
156: delete_from_gt;
157: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );

Line 157: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );

153: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
154: END IF;
155:
156: delete_from_gt;
157: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
158: ec_debug.disable_debug;
159: EXCEPTION
160: WHEN fnd_api.g_exc_error THEN
161: ROLLBACK;

Line 158: ec_debug.disable_debug;

154: END IF;
155:
156: delete_from_gt;
157: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
158: ec_debug.disable_debug;
159: EXCEPTION
160: WHEN fnd_api.g_exc_error THEN
161: ROLLBACK;
162: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);

Line 166: ec_debug.disable_debug;

162: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
163: x_return_status := fnd_api.g_ret_sts_error;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,
165: p_data => x_msg_data);
166: ec_debug.disable_debug;
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: ROLLBACK;
169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
170: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 173: ec_debug.disable_debug;

169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: fnd_msg_pub.count_and_get(p_count => x_msg_count,
172: p_data => x_msg_data);
173: ec_debug.disable_debug;
174: WHEN OTHERS THEN
175: ROLLBACK;
176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
177: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 185: ec_debug.disable_debug;

181: END IF;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count,
183: p_data => x_msg_data);
184:
185: ec_debug.disable_debug;
186: END Extract_PYO_Outbound;
187:
188:
189: PROCEDURE insert_into_gt(p_payment_instruction_id IN NUMBER)

Line 193: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');

189: PROCEDURE insert_into_gt(p_payment_instruction_id IN NUMBER)
190: IS
191:
192: BEGIN
193: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');
194: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);
195: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);
196:
197: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,

Line 194: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);

190: IS
191:
192: BEGIN
193: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');
194: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);
195: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);
196:
197: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,
198: TEST_FLAG,

Line 779: ec_debug.pl (3, 'Finished fetching Payment data');

775: AND ipay.payment_instruction_id = p_payment_instruction_id
776: AND (ipay.payment_status = 'INSTRUCTION_CREATED'
777: OR (ipay.payment_status = 'FORMATTED' AND ipay.process_type = 'IMMEDIATE'));
778:
779: ec_debug.pl (3, 'Finished fetching Payment data');
780: ec_debug.pl (3, 'Fetching Invoice data');
781: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);
782:
783: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,

Line 780: ec_debug.pl (3, 'Fetching Invoice data');

776: AND (ipay.payment_status = 'INSTRUCTION_CREATED'
777: OR (ipay.payment_status = 'FORMATTED' AND ipay.process_type = 'IMMEDIATE'));
778:
779: ec_debug.pl (3, 'Finished fetching Payment data');
780: ec_debug.pl (3, 'Fetching Invoice data');
781: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);
782:
783: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,
784: PAYMENT_INSTRUCTION_ID,

Line 955: ec_debug.pop ( 'ECE_AP_TRANSACTION.insert_into_gt');

951: AND ipa.payment_instruction_id = p_payment_instruction_id
952: AND idpa.document_status in ('PAYMENT_CREATED');
953:
954:
955: ec_debug.pop ( 'ECE_AP_TRANSACTION.insert_into_gt');
956: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: END ::'||systimestamp);
957: END insert_into_gt;
958:
959:

Line 962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');

958:
959:
960: PROCEDURE delete_from_gt IS
961: BEGIN
962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);

Line 967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');

963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');
968: END delete_from_gt;
969:
970: END IBY_PYO_TRANSACTION;
971: