APPS.IBY_PYO_TRANSACTION dependencies on FND_API

Line 73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);
71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);
72: fnd_file.put_line(fnd_file.log, 'UnExpected Error. Payments/Documents could not be fetched');
73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
74: return;
75: END IF;
76:
77: x_return_status := fnd_api.g_ret_sts_success; -- bug:5512623

Line 77: x_return_status := fnd_api.g_ret_sts_success; -- bug:5512623

73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
74: return;
75: END IF;
76:
77: x_return_status := fnd_api.g_ret_sts_success; -- bug:5512623
78:
79: xProgress := 'PYO-10-1004';
80:
81: -- Derive output filename

Line 142: if fnd_api.to_Boolean(p_commit) then

138: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: END ::'||systimestamp);
139:
140:
141: -- Standard check of p_commit
142: if fnd_api.to_Boolean(p_commit) then
143: COMMIT WORK;
144: end if;
145:
146: -- Standard call to get message count and if count is 1, get message info.

Line 160: WHEN fnd_api.g_exc_error THEN

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);
163: x_return_status := fnd_api.g_ret_sts_error;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 163: x_return_status := fnd_api.g_ret_sts_error;

159: EXCEPTION
160: WHEN fnd_api.g_exc_error THEN
161: ROLLBACK;
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

Line 167: WHEN fnd_api.g_exc_unexpected_error THEN

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;
171: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 170: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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

Line 177: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
181: END IF;