DBA Data[Home] [Help]

APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on FND_MESSAGE

Line 111: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

107: END IF;
108: END IF;
109:
110: IF l_error THEN
111: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
112: fnd_message.set_token('COLUMN', p_column);
113: fnd_msg_pub.add;
114: x_return_status := fnd_api.g_ret_sts_error;
115: END IF;

Line 112: fnd_message.set_token('COLUMN', p_column);

108: END IF;
109:
110: IF l_error THEN
111: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
112: fnd_message.set_token('COLUMN', p_column);
113: fnd_msg_pub.add;
114: x_return_status := fnd_api.g_ret_sts_error;
115: END IF;
116:

Line 159: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

155: END IF;
156: END IF;
157:
158: IF l_error THEN
159: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
160: fnd_message.set_token('COLUMN', p_column);
161: fnd_msg_pub.add;
162: x_return_status := fnd_api.g_ret_sts_error;
163: END IF;

Line 160: fnd_message.set_token('COLUMN', p_column);

156: END IF;
157:
158: IF l_error THEN
159: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
160: fnd_message.set_token('COLUMN', p_column);
161: fnd_msg_pub.add;
162: x_return_status := fnd_api.g_ret_sts_error;
163: END IF;
164:

Line 202: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

198:
199: END IF;
200: EXCEPTION
201: WHEN OTHERS THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: END do_email_domain_transfer;

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

199: END IF;
200: EXCEPTION
201: WHEN OTHERS THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: END do_email_domain_transfer;
207:

Line 346: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

342: FETCH c_unique_email_domain INTO l_dummy;
343:
344: -- combination key is not unique, push an error onto the stack.
345: IF NVL(c_unique_email_domain%FOUND, FALSE) THEN
346: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
347: fnd_message.set_token('COLUMN', 'party_id and domain_name combination');
348: fnd_msg_pub.add;
349: x_return_status := fnd_api.g_ret_sts_error;
350: END IF;

Line 347: fnd_message.set_token('COLUMN', 'party_id and domain_name combination');

343:
344: -- combination key is not unique, push an error onto the stack.
345: IF NVL(c_unique_email_domain%FOUND, FALSE) THEN
346: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
347: fnd_message.set_token('COLUMN', 'party_id and domain_name combination');
348: fnd_msg_pub.add;
349: x_return_status := fnd_api.g_ret_sts_error;
350: END IF;
351: CLOSE c_unique_email_domain;

Line 392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

388: WHERE p.party_id = p_party_id;
389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;

Line 393: fnd_message.set_token('FK', 'party_id');

389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.g_ret_sts_error;

Line 394: fnd_message.set_token('COLUMN', 'party_id');

390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.g_ret_sts_error;
398: END;

Line 395: fnd_message.set_token('TABLE', 'hz_parties');

391: WHEN NO_DATA_FOUND THEN
392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.g_ret_sts_error;
398: END;
399:

Line 466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

462: END IF;
463:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;

Line 467: fnd_message.set_token('FK', 'party_id');

463:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;
471: x_return_status := fnd_api.g_ret_sts_error;

Line 468: fnd_message.set_token('COLUMN', 'party_id');

464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;
471: x_return_status := fnd_api.g_ret_sts_error;
472:

Line 469: fnd_message.set_token('TABLE', 'hz_parties');

465: WHEN NO_DATA_FOUND THEN
466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;
471: x_return_status := fnd_api.g_ret_sts_error;
472:
473:

Line 486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

482: x_return_status := fnd_api.g_ret_sts_error;
483: WHEN OTHERS THEN
484: ROLLBACK TO create_email_domain;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
487: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
488: FND_MSG_PUB.ADD;
489:
490: END create_email_domain;

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

483: WHEN OTHERS THEN
484: ROLLBACK TO create_email_domain;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
487: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
488: FND_MSG_PUB.ADD;
489:
490: END create_email_domain;
491:

Line 550: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

546: x_to_id := l_to_id;
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: END email_domains_merge;

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

547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: END email_domains_merge;
555:

Line 609: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');

605:
606: BEGIN
607: IF (p_entity_name <> p_exp_ent_name OR
608: p_par_entity_name <> p_exp_par_ent_name) THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
613: FND_MSG_PUB.ADD;

Line 610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);

606: BEGIN
607: IF (p_entity_name <> p_exp_ent_name OR
608: p_par_entity_name <> p_exp_par_ent_name) THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
613: FND_MSG_PUB.ADD;
614: x_return_status := FND_API.G_RET_STS_ERROR;

Line 611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);

607: IF (p_entity_name <> p_exp_ent_name OR
608: p_par_entity_name <> p_exp_par_ent_name) THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
613: FND_MSG_PUB.ADD;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;

Line 612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

608: p_par_entity_name <> p_exp_par_ent_name) THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
613: FND_MSG_PUB.ADD;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616:

Line 618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');

614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

Line 619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

615: END IF;
616:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
623: FND_MSG_PUB.ADD;

Line 620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);

616:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
623: FND_MSG_PUB.ADD;
624: x_return_status := FND_API.G_RET_STS_ERROR;

Line 621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
623: FND_MSG_PUB.ADD;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;

Line 622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
623: FND_MSG_PUB.ADD;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:

Line 629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');

625: END IF;
626:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

Line 630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

626:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
634: FND_MSG_PUB.ADD;

Line 631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);

627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_ERROR;

Line 632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF;

Line 633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF;
637: EXCEPTION

Line 639: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF;
637: EXCEPTION
638: WHEN OTHERS THEN
639: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
641: FND_MSG_PUB.ADD;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: END check_params;

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

636: END IF;
637: EXCEPTION
638: WHEN OTHERS THEN
639: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
641: FND_MSG_PUB.ADD;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: END check_params;
644:

Line 743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

739: return l_ret_str ;
740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');
745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');

740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');
745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END get_email_domains ;

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

741: EXCEPTION
742: WHEN OTHERS THEN
743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');
745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END get_email_domains ;
749:

Line 827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

823: return retstr;
824:
825: EXCEPTION
826: WHEN OTHERS THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');
829: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
830: FND_MSG_PUB.ADD;
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');

824:
825: EXCEPTION
826: WHEN OTHERS THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');
829: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
830: FND_MSG_PUB.ADD;
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832:

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

825: EXCEPTION
826: WHEN OTHERS THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');
829: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
830: FND_MSG_PUB.ADD;
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832:
833: END FULL_DOMAIN;

Line 1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

1010: return retstr;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');

1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019:

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

1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019:
1020: