DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on FND_MSG_PUB

Line 269: fnd_msg_pub.initialize;

265: BEGIN
266: IF p_init_msg_list IS NULL OR
267: fnd_api.to_boolean (p_init_msg_list)
268: THEN
269: fnd_msg_pub.initialize;
270: END IF;
271:
272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');
273:

Line 277: fnd_msg_pub.add;

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:
281: l_party_search_rec.organization_name := p_organization_name;

Line 320: fnd_msg_pub.add;

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;
323: END IF;
324:

Line 325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;
323: END IF;
324:
325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
326:
327: EXCEPTION
328: WHEN fnd_api.g_exc_unexpected_error THEN
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

325: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
326:
327: EXCEPTION
328: WHEN fnd_api.g_exc_unexpected_error THEN
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');

Line 335: fnd_msg_pub.add;

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

Line 337: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
339:
340: PROCEDURE CHECK_CONTACT
341: ( p_init_msg_list IN VARCHAR2

Line 386: fnd_msg_pub.initialize;

382: BEGIN
383: IF p_init_msg_list IS NULL OR
384: fnd_api.to_boolean (p_init_msg_list)
385: THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:
389: x_return_status := fnd_api.g_ret_sts_success;
390:

Line 395: fnd_msg_pub.add;

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:
399: -- Prepare contact list

Line 458: fnd_msg_pub.add;

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;
462: x_party_id := get_party_id(l_search_ctx_id);

Line 466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

462: x_party_id := get_party_id(l_search_ctx_id);
463: END IF;
464: END IF;
465:
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_unexpected_error THEN
470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_unexpected_error THEN
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');

Line 476: fnd_msg_pub.add;

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

Line 478: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
480:
481: END CAC_SYNC_CONTACT_DQM_PVT;