APPS.CSI_RESUBMIT_PUB dependencies on FND_API

Line 146: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

142: x_return_status OUT nocopy varchar2,
143: x_error_message OUT nocopy varchar2)
144: IS
145: l_trx_error_rec csi_datastructures_pub.transaction_error_rec;
146: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
147: l_error_message varchar2(2000);
148:
149: CURSOR c_txn_info (pc_txn_type_id IN NUMBER) is
150: SELECT seeded_flag,source_application_id

Line 158: x_return_status := fnd_api.g_ret_sts_success;

154: r_txn_info c_txn_info%rowtype;
155:
156: BEGIN
157:
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: fnd_msg_pub.initialize;
161:
162: UPDATE csi_txn_errors

Line 181: IF l_return_status <> fnd_api.g_ret_sts_success THEN

177: p_body_text => p_error_rec.message_string,
178: x_return_status => l_return_status,
179: x_error_message => l_error_message);
180:
181: IF l_return_status <> fnd_api.g_ret_sts_success THEN
182: RAISE fnd_api.g_exc_error;
183: END IF;
184:
185: -- Second check if its seeded then it must be a CSI error so process thru

Line 182: RAISE fnd_api.g_exc_error;

178: x_return_status => l_return_status,
179: x_error_message => l_error_message);
180:
181: IF l_return_status <> fnd_api.g_ret_sts_success THEN
182: RAISE fnd_api.g_exc_error;
183: END IF;
184:
185: -- Second check if its seeded then it must be a CSI error so process thru
186: -- CSI reprocess logic.

Line 198: IF l_return_status <> fnd_api.g_ret_sts_success THEN

194: p_transaction_id => p_error_rec.source_id,
195: x_trx_return_status => l_return_status,
196: x_trx_error_rec => l_trx_error_rec);
197:
198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
199: l_error_message := l_trx_error_rec.error_text;
200: RAISE fnd_api.g_exc_error;
201: END IF;
202:

Line 200: RAISE fnd_api.g_exc_error;

196: x_trx_error_rec => l_trx_error_rec);
197:
198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
199: l_error_message := l_trx_error_rec.error_text;
200: RAISE fnd_api.g_exc_error;
201: END IF;
202:
203: ELSE
204:

Line 217: IF l_return_status <> fnd_api.g_ret_sts_success THEN

213: -- If no custom code exists this will return an error so that the error
214: -- is retained for the custom defined transaction. After code is entered
215: -- to reprocess then the transaction should get processed.
216:
217: IF l_return_status <> fnd_api.g_ret_sts_success THEN
218: l_error_message := l_trx_error_rec.error_text;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:

Line 219: RAISE fnd_api.g_exc_error;

215: -- to reprocess then the transaction should get processed.
216:
217: IF l_return_status <> fnd_api.g_ret_sts_success THEN
218: l_error_message := l_trx_error_rec.error_text;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:
222: END IF;
223:

Line 225: WHEN fnd_api.g_exc_error THEN

221:
222: END IF;
223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227: x_error_message := l_error_message;
228: WHEN others THEN
229: x_return_status := fnd_api.g_ret_sts_error;

Line 226: x_return_status := fnd_api.g_ret_sts_error;

222: END IF;
223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227: x_error_message := l_error_message;
228: WHEN others THEN
229: x_return_status := fnd_api.g_ret_sts_error;
230: x_error_message := 'Error in resubmit: '||substr(sqlerrm, 1, 540);

Line 229: x_return_status := fnd_api.g_ret_sts_error;

225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227: x_error_message := l_error_message;
228: WHEN others THEN
229: x_return_status := fnd_api.g_ret_sts_error;
230: x_error_message := 'Error in resubmit: '||substr(sqlerrm, 1, 540);
231: END resubmit;
232:
233:

Line 241: l_return_status varchar2(1):= fnd_api.g_ret_sts_success;

237: process_flag IN varchar2)
238: IS
239:
240: l_error_message varchar2(2000);
241: l_return_status varchar2(1):= fnd_api.g_ret_sts_success;
242:
243: process_success exception;
244: process_failure exception;
245:

Line 287: IF l_return_status <> fnd_api.g_ret_sts_success THEN

283: p_error_rec => error_rec,
284: x_return_status => l_return_status,
285: x_error_message => l_error_message);
286:
287: IF l_return_status <> fnd_api.g_ret_sts_success THEN
288: RAISE process_failure;
289: ELSE
290: RAISE process_success;
291: END IF;

Line 305: IF nvl(l_error_message, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

301: WHERE transaction_error_id = error_rec.transaction_error_id;
302:
303: WHEN process_failure THEN
304:
305: IF nvl(l_error_message, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
306: l_error_message := error_rec.error_text;
307: END IF;
308:
309: debug(' status : FAILED AGAIN');