34: p_debug_mode := 3;
35: IF p_Debug_mode IS NULL THEN
36: p_Debug_Mode := 3;
37: END IF;
38: ec_debug.enable_debug(p_debug_mode);
39: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
40: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
41: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
35: IF p_Debug_mode IS NULL THEN
36: p_Debug_Mode := 3;
37: END IF;
38: ec_debug.enable_debug(p_debug_mode);
39: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
40: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
41: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
43:
36: p_Debug_Mode := 3;
37: END IF;
38: ec_debug.enable_debug(p_debug_mode);
39: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
40: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
41: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
43:
44: i_Transaction_Type := 'PYO';
37: END IF;
38: ec_debug.enable_debug(p_debug_mode);
39: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
40: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
41: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
43:
44: i_Transaction_Type := 'PYO';
45:
38: ec_debug.enable_debug(p_debug_mode);
39: ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
40: ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
41: ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
43:
44: i_Transaction_Type := 'PYO';
45:
46: ec_debug.pl (3, 'comes here');
42: ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
43:
44: i_Transaction_Type := 'PYO';
45:
46: ec_debug.pl (3, 'comes here');
47: /* IF NOT fnd_api.Compatible_API_Call(l_api_version,
48: p_api_version,
49: l_api_name,
50: G_PKG_NAME)
48: p_api_version,
49: l_api_name,
50: G_PKG_NAME)
51: THEN
52: ec_debug.pl (3, 'comes here');
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
56: IF fnd_api.to_Boolean(p_init_msg_list) THEN
57: fnd_msg_pub.initialize;
58: END IF;
59:
60: x_return_status := fnd_api.g_ret_sts_success;
61: ec_debug.pl (3, 'comes here');*/
62:
63: x_return_status := fnd_api.g_ret_sts_success; -- bug:5512623
64:
65: xProgress := 'PYO-10-1004';
72: select ece_output_runs_s.NEXTVAL INTO i_file_id
73: FROM DUAL;
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: ec_debug.pl ( 0,
77: 'EC',
78: 'ECE_GET_NEXT_SEQ_FAILED',
79: 'PROGRESS_LEVEL',
80: xProgress,
81: 'SEQ',
82: 'ECE_OUTPUT_RUNS_S' );
83: END;
84: END IF;
85: ec_debug.pl (3, 'comes here');
86:
87: ec_debug.pl ( 3, 'File ID ',i_file_id);
88:
89:
83: END;
84: END IF;
85: ec_debug.pl (3, 'comes here');
86:
87: ec_debug.pl ( 3, 'File ID ',i_file_id);
88:
89:
90: i_Filename := i_Transaction_Type || i_file_id || '.dat';
91:
92:
93: xProgress := 'PYO-10-1005';
94: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
95: cOutput_path );
96: ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
97:
98:
99:
100:
100:
101:
102:
103: xProgress := 'PYO-10-1030';
104: ec_debug.pl ( 0, 'EC', 'ECE_PAYMENT_BATCH', 'PAYMENT INSTRUCTION ID ', p_payment_instruction_id );
105:
106: ec_document.process_outbound(
107: errbuf => p_errbuf,
108: retcode => p_retcode,
125: p_data => x_msg_data);
126:
127:
128: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_Transaction_Type) = 'U' THEN
129: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
130: END IF;
131:
132: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
133: ec_debug.disable_debug;
128: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_Transaction_Type) = 'U' THEN
129: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
130: END IF;
131:
132: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
133: ec_debug.disable_debug;
134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: ROLLBACK;
129: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
130: END IF;
131:
132: ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
133: ec_debug.disable_debug;
134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: ROLLBACK;
137: x_return_status := fnd_api.g_ret_sts_error;
136: ROLLBACK;
137: x_return_status := fnd_api.g_ret_sts_error;
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,
139: p_data => x_msg_data);
140: ec_debug.disable_debug;
141: WHEN fnd_api.g_exc_unexpected_error THEN
142: ROLLBACK;
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,
142: ROLLBACK;
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,
145: p_data => x_msg_data);
146: ec_debug.disable_debug;
147: WHEN OTHERS THEN
148: ROLLBACK;
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: IF fnd_msg_pub.Check_Msg_Level
153: END IF;
154: fnd_msg_pub.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: ec_debug.disable_debug;
158: END Extract_PYO_Outbound;
159:
160:
161: END ece_ap_payment;