DBA Data[Home] [Help]

APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on FND_MSG_PUB

Line 113: fnd_msg_pub.add;

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:
117: END validate_mandatory;

Line 161: fnd_msg_pub.add;

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:
165: END validate_mandatory;

Line 204: FND_MSG_PUB.ADD;

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:
208: /**

Line 348: fnd_msg_pub.add;

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

Line 396: fnd_msg_pub.add;

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:
400:

Line 470: fnd_msg_pub.add;

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:
474: END;

Line 488: FND_MSG_PUB.ADD;

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:
492: PROCEDURE email_domains_merge(

Line 552: FND_MSG_PUB.ADD;

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:
556: FUNCTION check_email_domain_dup(

Line 613: FND_MSG_PUB.ADD;

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:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN

Line 623: FND_MSG_PUB.ADD;

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:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND

Line 634: FND_MSG_PUB.ADD;

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
638: WHEN OTHERS THEN

Line 641: FND_MSG_PUB.ADD;

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:
645: ---------------- VJN INTRODUCED -----------------------------------------------------

Line 746: FND_MSG_PUB.ADD;

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:
750:

Line 830: FND_MSG_PUB.ADD;

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

Line 1017: FND_MSG_PUB.ADD;

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:
1021: END CORE_DOMAIN;