DBA Data[Home] [Help]

APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: ROLLBACK TO IMPORT_MAIN;
54: arp_standard.debug('EXCEPTION OTHERS: impremapi.Dummy_Remittance');
55: app_exception.raise_exception;
56: END;
57:
58:
59: /*---------------------------------------------------------------------------------------------------------------------------|

Line 93: app_exception.raise_exception;

89: and reserved_type = 'REMITTANCE';
90:
91: IF p_reserved_value is null THEN
92: fnd_message.set_name('AR_BR','AR_BR_TRX_INVALID');
93: app_exception.raise_exception;
94: END IF;
95:
96: Select batch_applied_status,
97: status,

Line 121: app_exception.raise_exception;

117: WHEN NO_DATA_FOUND THEN
118: ROLLBACK TO IMPORT_MAIN;
119: fnd_message.set_name ('AR_BR','AR_BR_TRX_INVALID');
120: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Check_BR_and_Batch_Status');
121: app_exception.raise_exception;
122:
123: WHEN invalid_remittance_status THEN
124: ROLLBACK TO IMPORT_MAIN;
125: fnd_message.set_name ('AR_BR','AR_BR_TRX_INVALID');

Line 127: app_exception.raise_exception;

123: WHEN invalid_remittance_status THEN
124: ROLLBACK TO IMPORT_MAIN;
125: fnd_message.set_name ('AR_BR','AR_BR_TRX_INVALID');
126: arp_standard.debug ('EXCEPTION invalid_remittance_status.Check_BR_and_Batch_Status');
127: app_exception.raise_exception;
128:
129: WHEN OTHERS THEN
130: ROLLBACK TO IMPORT_MAIN;
131: arp_standard.debug ('EXCEPTION WHEN_OTHERS impremapi.Check_BR_and_Batch_Status');

Line 132: app_exception.raise_exception;

128:
129: WHEN OTHERS THEN
130: ROLLBACK TO IMPORT_MAIN;
131: arp_standard.debug ('EXCEPTION WHEN_OTHERS impremapi.Check_BR_and_Batch_Status');
132: app_exception.raise_exception;
133: END;
134:
135: /*---------------------------------------------------------------------------------------------------------------------------|
136: | PROCEDURE : compare_old_versus_new_values |

Line 215: app_exception.raise_exception;

211: If l_bank_account_num <> p_remittance_bnk_acct_number THEN
212: fnd_message.set_name
213: ( 'AR_BR','AR_BR_INVALID_PARAMETER');
214: FND_MESSAGE.set_token('PARAMETER',' bank account ');
215: app_exception.raise_exception;
216: END IF;
217:
218: IF l_currency_code<>p_currency_code THEN
219: fnd_message.set_name

Line 222: app_exception.raise_exception;

218: IF l_currency_code<>p_currency_code THEN
219: fnd_message.set_name
220: ('AR_BR','AR_BR_INVALID_PARAMETER');
221: FND_MESSAGE.set_token('PARAMETER',' currency code ');
222: app_exception.raise_exception;
223: END IF;
224:
225: IF l_gl_date<>p_remittance_accounting_date THEN
226: fnd_message.set_name

Line 229: app_exception.raise_exception;

225: IF l_gl_date<>p_remittance_accounting_date THEN
226: fnd_message.set_name
227: ('AR_BR','AR_BR_INVALID_PARAMETER');
228: FND_MESSAGE.set_token('PARAMETER',' accounting date ');
229: app_exception.raise_exception;
230: END IF;
231:
232: IF l_with_recourse_flag<>p_with_recourse_flag THEN
233: fnd_message.set_name

Line 236: app_exception.raise_exception;

232: IF l_with_recourse_flag<>p_with_recourse_flag THEN
233: fnd_message.set_name
234: ('AR_BR','AR_BR_INVALID_PARAMETER');
235: FND_MESSAGE.set_token('PARAMETER',' recourse flag ');
236: app_exception.raise_exception;
237: END IF;
238:
239:
240: IF l_batch_date<>p_remittance_date THEN

Line 244: app_exception.raise_exception;

240: IF l_batch_date<>p_remittance_date THEN
241: fnd_message.set_name
242: ('AR_BR','AR_BR_INVALID_PARAMETER');
243: FND_MESSAGE.set_token('PARAMETER',' remittance date ');
244: app_exception.raise_exception;
245: END IF;
246:
247: BEGIN
248: select name

Line 259: app_exception.raise_exception;

255:
256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
258: fnd_message.set_name ( 'AR', 'AR_BR_INVALID_RECEIPT_METHOD');
259: app_exception.raise_exception;
260:
261: END;
262:
263: IF l_payment_method <> p_payment_method THEN

Line 267: app_exception.raise_exception;

263: IF l_payment_method <> p_payment_method THEN
264: fnd_message.set_name
265: ('AR_BR','AR_BR_INVALID_PARAMETER');
266: FND_MESSAGE.set_token('PARAMETER',' payment method ');
267: app_exception.raise_exception;
268: END IF;
269:
270: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()-');
271:

Line 276: app_exception.raise_exception;

272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: ROLLBACK TO IMPORT_MAIN;
275: arp_standard.debug ('EXCEPTION NO_DATA impremapi.Compare_old_versus_new_values');
276: app_exception.raise_exception;
277:
278: WHEN OTHERS THEN
279: ROLLBACK TO IMPORT_MAIN;
280: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Compare_old_versus_new_values');

Line 281: app_exception.raise_exception;

277:
278: WHEN OTHERS THEN
279: ROLLBACK TO IMPORT_MAIN;
280: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Compare_old_versus_new_values');
281: app_exception.raise_exception;
282:
283: END;
284:
285: /*---------------------------------------------------------------------------------------------------------------------------|

Line 369: app_exception.raise_exception;

365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: ROLLBACK TO IMPORT_MAIN;
368: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Existing_Remittance');
369: app_exception.raise_exception;
370:
371: END;
372:
373: /*---------------------------------------------------------------------------------------------------------------------------|

Line 465: app_exception.raise_exception;

461: ROLLBACK TO IMPORT_MAIN;
462: arp_standard.debug('EXCEPTION Branch no_data : ' ||
463: 'impremapi.New_Remittance');
464: fnd_message.set_name ( 'AR', 'AR_MUST_ENTER_REMIT_BANK');
465: app_exception.raise_exception;
466: END;
467:
468: BEGIN
469:

Line 483: app_exception.raise_exception;

479: ROLLBACK TO IMPORT_MAIN;
480: arp_standard.debug('EXCEPTION Bank acc id no_data : ' ||
481: 'impremapi.New_Remittance');
482: fnd_message.set_name ( 'AR', 'Invalid Remittance Bank Branch');
483: app_exception.raise_exception;
484: END;
485:
486: BEGIN
487: select receipt_method_id,

Line 504: app_exception.raise_exception;

500: x_return_status := FND_API.G_RET_STS_ERROR;
501: ROLLBACK TO IMPORT_MAIN;
502: arp_standard.debug('EXCEPTION Receipt Method : impremapi.New_Remittance');
503: fnd_message.set_name('AR','AR_BR_INVALID_REMIT_PROGRAM');
504: app_exception.raise_exception;
505:
506: END;
507:
508: BEGIN

Line 525: app_exception.raise_exception;

521: x_return_status := FND_API.G_RET_STS_ERROR;
522: ROLLBACK TO IMPORT_MAIN;
523: arp_standard.debug('EXCEPTION Receipt Method Progs : impremapi.New_Remittance');
524: fnd_message.set_name ( 'AR', 'AR_BR_INVALID_RECEIPT_METHOD');
525: app_exception.raise_exception;
526: END;
527:
528: l_batch_id := null;
529:

Line 587: app_exception.raise_exception;

583: WHEN OTHERS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: ROLLBACK TO IMPORT_MAIN;
586: arp_standard.debug('EXCEPTION OTHERS: impremapi.New_Remittance');
587: app_exception.raise_exception;
588: END;
589:
590: /*---------------------------------------------------------------------------------------------------------------------------|
591: | FUNCTION : |

Line 636: app_exception.raise_exception;

632:
633:
634: WHEN OTHERS THEN
635: arp_standard.debug('EXCEPTION OTHERS: impremapi.remittance_Exists');
636: app_exception.raise_exception;
637:
638: END;
639:
640: /*---------------------------------------------------------------------------------------------------------------------------|

Line 739: app_exception.raise_exception;

735: x_return_status := FND_API.G_RET_STS_ERROR;
736: arp_standard.debug('Impremapi.Import_Remittance_Main media_ref null');
737: --bug 1644533
738: fnd_message.set_name('AR_BR','AR_BR_MEDIA_REF_NULL');
739: app_exception.raise_exception;
740: end if;
741:
742: /*---------------------------------------------------------------------------------------
743: | if the remittance does not exist, call the new_remittance procedure else call the |