DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on FND_MESSAGE

Line 275: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');

271:
272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');
273:
274: IF l_rule_id IS NULL THEN
275: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
276: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_ORG_DUP_PREV_MATCHRULE'));
277: fnd_msg_pub.add;
278: RAISE fnd_api.g_exc_unexpected_error;
279: END IF;

Line 276: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_ORG_DUP_PREV_MATCHRULE'));

272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');
273:
274: IF l_rule_id IS NULL THEN
275: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
276: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_ORG_DUP_PREV_MATCHRULE'));
277: fnd_msg_pub.add;
278: RAISE fnd_api.g_exc_unexpected_error;
279: END IF;
280:

Line 313: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_NOTFOUND');

309: x_organization_id := get_organization_party_id(l_search_ctx_id);
310: ELSE
311: IF l_num_matches = 0 THEN
312: -- Error message: : Organization does not exist, contact not synchronized.
313: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_NOTFOUND');
314: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
315: ELSE
316: -- Error message: : Multiple matches for the organization were found, contact not synchronized.
317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');

Line 314: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);

310: ELSE
311: IF l_num_matches = 0 THEN
312: -- Error message: : Organization does not exist, contact not synchronized.
313: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_NOTFOUND');
314: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
315: ELSE
316: -- Error message: : Multiple matches for the organization were found, contact not synchronized.
317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');
318: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);

Line 317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');

313: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_NOTFOUND');
314: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
315: ELSE
316: -- Error message: : Multiple matches for the organization were found, contact not synchronized.
317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');
318: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
319: END IF;
320: fnd_msg_pub.add;
321: RAISE fnd_api.g_exc_unexpected_error;

Line 318: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);

314: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
315: ELSE
316: -- Error message: : Multiple matches for the organization were found, contact not synchronized.
317: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_ORG_TOOMANY');
318: fnd_message.set_token ('P_CONTACT_NAME', p_contact_name);
319: END IF;
320: fnd_msg_pub.add;
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;

Line 333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');

329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: WHEN OTHERS THEN
333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
334: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
335: fnd_msg_pub.add;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 334: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: WHEN OTHERS THEN
333: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
334: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
335: fnd_msg_pub.add;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
338: END FIND_ORGANIZATION;

Line 393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');

389: x_return_status := fnd_api.g_ret_sts_success;
390:
391: l_rule_id := fnd_profile.value('HZ_CON_DUP_PREV_MATCHRULE');
392: IF l_rule_id IS NULL THEN
393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
394: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_CON_DUP_PREV_MATCHRULE'));
395: fnd_msg_pub.add;
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;

Line 394: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_CON_DUP_PREV_MATCHRULE'));

390:
391: l_rule_id := fnd_profile.value('HZ_CON_DUP_PREV_MATCHRULE');
392: IF l_rule_id IS NULL THEN
393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
394: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_CON_DUP_PREV_MATCHRULE'));
395: fnd_msg_pub.add;
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;
398:

Line 456: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_CONTACT_EXISTS');

452: RAISE fnd_api.g_exc_unexpected_error;
453: ELSE
454: IF l_num_matches > 1 THEN
455: -- Error message: : Multiple matches for the contact were found, contact not synchronized.
456: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_CONTACT_EXISTS');
457: fnd_message.set_token ('P_CONTACT_NAME', p_person_full_name);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_unexpected_error;
460: ELSE

Line 457: fnd_message.set_token ('P_CONTACT_NAME', p_person_full_name);

453: ELSE
454: IF l_num_matches > 1 THEN
455: -- Error message: : Multiple matches for the contact were found, contact not synchronized.
456: fnd_message.set_name ('JTF', 'CAC_SYNC_DQM_CONTACT_EXISTS');
457: fnd_message.set_token ('P_CONTACT_NAME', p_person_full_name);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_unexpected_error;
460: ELSE
461: x_num_of_matches := l_num_matches;

Line 474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');

470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: WHEN OTHERS THEN
474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: WHEN OTHERS THEN
474: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_UNEXPECTED_ER');
475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
479: END CHECK_CONTACT;