DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_MESSAGE

Line 188: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

184: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
185: arp_standard.debug('Debug Info: ' || l_debug_info);
186: arp_standard.debug(SQLERRM);
187: END IF;
188: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
190: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
192: FND_MSG_PUB.ADD;

Line 189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

185: arp_standard.debug('Debug Info: ' || l_debug_info);
186: arp_standard.debug(SQLERRM);
187: END IF;
188: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
190: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
192: FND_MSG_PUB.ADD;
193: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 190: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

186: arp_standard.debug(SQLERRM);
187: END IF;
188: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
190: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
192: FND_MSG_PUB.ADD;
193: InformSysAdminError(p_procedure_name => l_procedure_name,
194: p_debug_info => l_debug_info,

Line 191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

187: END IF;
188: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
190: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
192: FND_MSG_PUB.ADD;
193: InformSysAdminError(p_procedure_name => l_procedure_name,
194: p_debug_info => l_debug_info,
195: p_error => SQLERRM);

Line 262: FND_MESSAGE.Set_Name('AR', 'ARI_REG_APP_NAME');

258:
259: ----------------------------------------------------------------------------
260: l_debug_info := 'Retrieve Application Name';
261: ----------------------------------------------------------------------------
262: FND_MESSAGE.Set_Name('AR', 'ARI_REG_APP_NAME');
263: l_app_name := FND_MESSAGE.Get;
264:
265: ----------------------------------------------------------------------------
266: l_debug_info := 'Check if the registration service code passed in is valid';

Line 263: l_app_name := FND_MESSAGE.Get;

259: ----------------------------------------------------------------------------
260: l_debug_info := 'Retrieve Application Name';
261: ----------------------------------------------------------------------------
262: FND_MESSAGE.Set_Name('AR', 'ARI_REG_APP_NAME');
263: l_app_name := FND_MESSAGE.Get;
264:
265: ----------------------------------------------------------------------------
266: l_debug_info := 'Check if the registration service code passed in is valid';
267: ----------------------------------------------------------------------------

Line 277: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');

273: AND REGSRVC.START_DATE <= SYSDATE
274: AND NVL(REGSRVC.END_DATE, SYSDATE+1) > SYSDATE;
275: EXCEPTION
276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
278: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END;

Line 278: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);

274: AND NVL(REGSRVC.END_DATE, SYSDATE+1) > SYSDATE;
275: EXCEPTION
276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
278: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END;
282:

Line 285: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');

281: END;
282:
283: --Reg Service Type should be SELF_SERVICE when calling from Collections
284: IF l_reg_service_type <> 'SELF_SERVICE' THEN
285: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
286: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;

Line 286: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);

282:
283: --Reg Service Type should be SELF_SERVICE when calling from Collections
284: IF l_reg_service_type <> 'SELF_SERVICE' THEN
285: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
286: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290:

Line 386: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

382: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
383: arp_standard.debug('Debug Info: ' || l_debug_info);
384: arp_standard.debug(SQLERRM);
385: END IF;
386: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
388: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
389: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
390: FND_MSG_PUB.ADD;

Line 387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

383: arp_standard.debug('Debug Info: ' || l_debug_info);
384: arp_standard.debug(SQLERRM);
385: END IF;
386: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
388: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
389: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
390: FND_MSG_PUB.ADD;
391: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 388: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

384: arp_standard.debug(SQLERRM);
385: END IF;
386: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
388: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
389: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
390: FND_MSG_PUB.ADD;
391: InformSysAdminError(p_procedure_name => l_procedure_name,
392: p_debug_info => l_debug_info,

Line 389: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

385: END IF;
386: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
388: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
389: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
390: FND_MSG_PUB.ADD;
391: InformSysAdminError(p_procedure_name => l_procedure_name,
392: p_debug_info => l_debug_info,
393: p_error => SQLERRM);

Line 452: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

448: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
449: arp_standard.debug('Debug Info: ' || l_debug_info);
450: arp_standard.debug(SQLERRM);
451: END IF;
452: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
453: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
454: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
455: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
456: FND_MSG_PUB.ADD;

Line 453: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

449: arp_standard.debug('Debug Info: ' || l_debug_info);
450: arp_standard.debug(SQLERRM);
451: END IF;
452: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
453: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
454: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
455: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
456: FND_MSG_PUB.ADD;
457: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 454: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

450: arp_standard.debug(SQLERRM);
451: END IF;
452: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
453: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
454: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
455: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
456: FND_MSG_PUB.ADD;
457: InformSysAdminError(p_procedure_name => l_procedure_name,
458: p_debug_info => l_debug_info,

Line 455: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

451: END IF;
452: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
453: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
454: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
455: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
456: FND_MSG_PUB.ADD;
457: InformSysAdminError(p_procedure_name => l_procedure_name,
458: p_debug_info => l_debug_info,
459: p_error => SQLERRM);

Line 496: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

492: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
493: arp_standard.debug('Debug Info: ' || l_debug_info);
494: arp_standard.debug(SQLERRM);
495: END IF;
496: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
497: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
498: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
499: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
500: FND_MSG_PUB.ADD;

Line 497: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

493: arp_standard.debug('Debug Info: ' || l_debug_info);
494: arp_standard.debug(SQLERRM);
495: END IF;
496: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
497: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
498: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
499: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
500: FND_MSG_PUB.ADD;
501: END IF;

Line 498: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

494: arp_standard.debug(SQLERRM);
495: END IF;
496: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
497: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
498: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
499: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
500: FND_MSG_PUB.ADD;
501: END IF;
502: APP_EXCEPTION.RAISE_EXCEPTION;

Line 499: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

495: END IF;
496: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
497: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
498: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
499: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
500: FND_MSG_PUB.ADD;
501: END IF;
502: APP_EXCEPTION.RAISE_EXCEPTION;
503: END InformSysAdminError;

Line 605: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

601: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
602: arp_standard.debug('Debug Info: ' || l_debug_info);
603: arp_standard.debug(SQLERRM);
604: END IF;
605: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
606: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
607: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
608: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
609: FND_MSG_PUB.ADD;

Line 606: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

602: arp_standard.debug('Debug Info: ' || l_debug_info);
603: arp_standard.debug(SQLERRM);
604: END IF;
605: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
606: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
607: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
608: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
609: FND_MSG_PUB.ADD;
610: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 607: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

603: arp_standard.debug(SQLERRM);
604: END IF;
605: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
606: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
607: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
608: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
609: FND_MSG_PUB.ADD;
610: InformSysAdminError(p_procedure_name => l_procedure_name,
611: p_debug_info => l_debug_info,

Line 608: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

604: END IF;
605: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
606: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
607: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
608: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
609: FND_MSG_PUB.ADD;
610: InformSysAdminError(p_procedure_name => l_procedure_name,
611: p_debug_info => l_debug_info,
612: p_error => SQLERRM);

Line 661: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

657: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
658: arp_standard.debug('ERROR =>'|| SQLERRM);
659: END IF;
660:
661: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
665: FND_MSG_PUB.ADD;

Line 662: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

658: arp_standard.debug('ERROR =>'|| SQLERRM);
659: END IF;
660:
661: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
665: FND_MSG_PUB.ADD;
666:

Line 663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

659: END IF;
660:
661: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
665: FND_MSG_PUB.ADD;
666:
667:

Line 664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

660:
661: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
665: FND_MSG_PUB.ADD;
666:
667:
668: END;

Line 758: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

754: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
755: arp_standard.debug('Debug Info: ' || l_debug_info);
756: arp_standard.debug(SQLERRM);
757: END IF;
758: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
760: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
761: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
762: FND_MSG_PUB.ADD;

Line 759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

755: arp_standard.debug('Debug Info: ' || l_debug_info);
756: arp_standard.debug(SQLERRM);
757: END IF;
758: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
760: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
761: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
762: FND_MSG_PUB.ADD;
763: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 760: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

756: arp_standard.debug(SQLERRM);
757: END IF;
758: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
760: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
761: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
762: FND_MSG_PUB.ADD;
763: InformSysAdminError(p_procedure_name => l_procedure_name,
764: p_debug_info => l_debug_info,

Line 761: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

757: END IF;
758: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
760: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
761: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
762: FND_MSG_PUB.ADD;
763: InformSysAdminError(p_procedure_name => l_procedure_name,
764: p_debug_info => l_debug_info,
765: p_error => SQLERRM);

Line 1176: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

1172: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1173: arp_standard.debug('Debug Info: ' || l_debug_info);
1174: arp_standard.debug(SQLERRM);
1175: END IF;
1176: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1178: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1180: FND_MSG_PUB.ADD;

Line 1177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1173: arp_standard.debug('Debug Info: ' || l_debug_info);
1174: arp_standard.debug(SQLERRM);
1175: END IF;
1176: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1178: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1180: FND_MSG_PUB.ADD;
1181: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 1178: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

1174: arp_standard.debug(SQLERRM);
1175: END IF;
1176: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1178: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1180: FND_MSG_PUB.ADD;
1181: InformSysAdminError(p_procedure_name => l_procedure_name,
1182: p_debug_info => l_debug_info,

Line 1179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1175: END IF;
1176: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1178: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1180: FND_MSG_PUB.ADD;
1181: InformSysAdminError(p_procedure_name => l_procedure_name,
1182: p_debug_info => l_debug_info,
1183: p_error => SQLERRM);

Line 1415: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

1411: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1412: arp_standard.debug('Debug Info: ' || l_debug_info);
1413: arp_standard.debug(SQLERRM);
1414: END IF;
1415: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1417: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1418: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1419: FND_MSG_PUB.ADD;

Line 1416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1412: arp_standard.debug('Debug Info: ' || l_debug_info);
1413: arp_standard.debug(SQLERRM);
1414: END IF;
1415: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1417: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1418: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 1417: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

1413: arp_standard.debug(SQLERRM);
1414: END IF;
1415: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1417: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1418: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: InformSysAdminError(p_procedure_name => l_procedure_name,
1421: p_debug_info => l_debug_info,

Line 1418: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1414: END IF;
1415: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1417: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1418: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: InformSysAdminError(p_procedure_name => l_procedure_name,
1421: p_debug_info => l_debug_info,
1422: p_error => SQLERRM);

Line 1695: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

1691: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1692: arp_standard.debug('Debug Info: ' || l_debug_info);
1693: arp_standard.debug(SQLERRM);
1694: END IF;
1695: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1696: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1698: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1699: FND_MSG_PUB.ADD;

Line 1696: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1692: arp_standard.debug('Debug Info: ' || l_debug_info);
1693: arp_standard.debug(SQLERRM);
1694: END IF;
1695: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1696: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1698: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1699: FND_MSG_PUB.ADD;
1700: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

1693: arp_standard.debug(SQLERRM);
1694: END IF;
1695: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1696: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1698: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1699: FND_MSG_PUB.ADD;
1700: InformSysAdminError(p_procedure_name => l_procedure_name,
1701: p_debug_info => l_debug_info,

Line 1698: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1694: END IF;
1695: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1696: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1698: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1699: FND_MSG_PUB.ADD;
1700: InformSysAdminError(p_procedure_name => l_procedure_name,
1701: p_debug_info => l_debug_info,
1702: p_error => SQLERRM);

Line 1870: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

1866: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1867: arp_standard.debug('Debug Info: ' || l_debug_info);
1868: arp_standard.debug(SQLERRM);
1869: END IF;
1870: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1872: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1874: FND_MSG_PUB.ADD;

Line 1871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1867: arp_standard.debug('Debug Info: ' || l_debug_info);
1868: arp_standard.debug(SQLERRM);
1869: END IF;
1870: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1872: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1874: FND_MSG_PUB.ADD;
1875: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 1872: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

1868: arp_standard.debug(SQLERRM);
1869: END IF;
1870: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1872: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1874: FND_MSG_PUB.ADD;
1875: InformSysAdminError(p_procedure_name => l_procedure_name,
1876: p_debug_info => l_debug_info,

Line 1873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1869: END IF;
1870: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1872: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1874: FND_MSG_PUB.ADD;
1875: InformSysAdminError(p_procedure_name => l_procedure_name,
1876: p_debug_info => l_debug_info,
1877: p_error => SQLERRM);

Line 1995: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

1991: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1992: arp_standard.debug('Debug Info: ' || l_debug_info);
1993: arp_standard.debug(SQLERRM);
1994: END IF;
1995: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1996: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1997: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1998: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1999: FND_MSG_PUB.ADD;

Line 1996: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1992: arp_standard.debug('Debug Info: ' || l_debug_info);
1993: arp_standard.debug(SQLERRM);
1994: END IF;
1995: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1996: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1997: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1998: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1999: FND_MSG_PUB.ADD;
2000: InformSysAdminError(p_procedure_name => l_procedure_name,

Line 1997: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

1993: arp_standard.debug(SQLERRM);
1994: END IF;
1995: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1996: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1997: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1998: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1999: FND_MSG_PUB.ADD;
2000: InformSysAdminError(p_procedure_name => l_procedure_name,
2001: p_debug_info => l_debug_info,

Line 1998: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1994: END IF;
1995: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
1996: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1997: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
1998: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1999: FND_MSG_PUB.ADD;
2000: InformSysAdminError(p_procedure_name => l_procedure_name,
2001: p_debug_info => l_debug_info,
2002: p_error => SQLERRM);