DBA Data[Home] [Help]

APPS.IGW_PARTY_MERGE_PUB dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.add;

41: or (p_parent_entity_name <> 'HZ_PARTIES') then
42: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
43: fnd_message.set_token('P_ENTITY',p_entity_name);
44: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
45: FND_MSG_PUB.add;
46: RAISE fnd_api.g_exc_error;
47: end if;
48:
49: open from_party_cur(p_from_id); -- p_from_id is the value of person_degree_id

Line 59: FND_MSG_PUB.add;

55:
56: --reject merge because the person is already used
57: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
58: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
59: FND_MSG_PUB.add;
60: x_return_status := fnd_api.g_ret_sts_error;
61: RAISE fnd_api.g_exc_error;
62:
63: else

Line 87: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

83: x_return_status := fnd_api.g_ret_sts_error;
84: WHEN OTHERS
85: THEN
86: ROLLBACK TO PARTY_MERGE_SP;
87: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
88: p_procedure_name => l_api_name,
89: p_error_text => SUBSTRB(SQLERRM,1,240));
90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91:

Line 136: FND_MSG_PUB.add;

132: or (p_parent_entity_name <> 'HZ_PARTIES') then
133: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
134: fnd_message.set_token('P_ENTITY',p_entity_name);
135: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
136: FND_MSG_PUB.add;
137: RAISE fnd_api.g_exc_error;
138: end if;
139:
140: open from_party_cur(p_from_id);

Line 150: FND_MSG_PUB.add;

146:
147: -- reject merge because the person is already used
148: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
149: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
150: FND_MSG_PUB.add;
151: x_return_status := fnd_api.g_ret_sts_error;
152: RAISE fnd_api.g_exc_error;
153:
154: else

Line 178: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

174: x_return_status := fnd_api.g_ret_sts_error;
175: WHEN OTHERS
176: THEN
177: ROLLBACK TO PARTY_MERGE_SP;
178: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
179: p_procedure_name => l_api_name,
180: p_error_text => SUBSTRB(SQLERRM,1,240));
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: END person_biosketch_party_merge;

Line 226: FND_MSG_PUB.add;

222: or (p_parent_entity_name <> 'HZ_PARTIES') then
223: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
224: fnd_message.set_token('P_ENTITY',p_entity_name);
225: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
226: FND_MSG_PUB.add;
227: RAISE fnd_api.g_exc_error;
228: end if;
229:
230: open from_party_cur(p_from_id);

Line 240: FND_MSG_PUB.add;

236:
237: -- reject merge because the person is already used
238: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
239: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
240: FND_MSG_PUB.add;
241: x_return_status := fnd_api.g_ret_sts_error;
242: RAISE fnd_api.g_exc_error;
243:
244: else

Line 268: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

264: x_return_status := fnd_api.g_ret_sts_error;
265: WHEN OTHERS
266: THEN
267: ROLLBACK TO PARTY_MERGE_SP;
268: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
269: p_procedure_name => l_api_name,
270: p_error_text => SUBSTRB(SQLERRM,1,240));
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272: END prop_location_party_merge;

Line 317: FND_MSG_PUB.add;

313: or (p_parent_entity_name <> 'HZ_PARTIES') then
314: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
315: fnd_message.set_token('P_ENTITY',p_entity_name);
316: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
317: FND_MSG_PUB.add;
318: RAISE fnd_api.g_exc_error;
319: end if;
320:
321: open from_party_cur(p_from_id);

Line 331: FND_MSG_PUB.add;

327:
328: -- reject merge because the person is already used
329: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
330: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
331: FND_MSG_PUB.add;
332: x_return_status := fnd_api.g_ret_sts_error;
333: RAISE fnd_api.g_exc_error;
334:
335: else

Line 350: FND_MSG_PUB.add;

346: exception
347: when dup_val_on_index then
348: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
349: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name||' - ASSURANCES');
350: FND_MSG_PUB.add;
351: x_return_status := fnd_api.g_ret_sts_error;
352: RAISE fnd_api.g_exc_error;
353: end;
354:

Line 364: FND_MSG_PUB.add;

360: exception
361: when dup_val_on_index then
362: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
363: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name||' - OTHER SUPPORT');
364: FND_MSG_PUB.add;
365: x_return_status := fnd_api.g_ret_sts_error;
366: RAISE fnd_api.g_exc_error;
367: end;
368:

Line 378: FND_MSG_PUB.add;

374: exception
375: when dup_val_on_index then
376: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
377: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name||' - BUDGET PERSONS');
378: FND_MSG_PUB.add;
379: x_return_status := fnd_api.g_ret_sts_error;
380: RAISE fnd_api.g_exc_error;
381: end;
382:

Line 392: FND_MSG_PUB.add;

388: exception
389: when dup_val_on_index then
390: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
391: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name||' - BUDGET PERSONNEL DETAILS');
392: FND_MSG_PUB.add;
393: x_return_status := fnd_api.g_ret_sts_error;
394: RAISE fnd_api.g_exc_error;
395: end;
396:

Line 413: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

409: x_return_status := fnd_api.g_ret_sts_error;
410: WHEN OTHERS
411: THEN
412: ROLLBACK TO PARTY_MERGE_SP;
413: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
414: p_procedure_name => l_api_name,
415: p_error_text => SUBSTRB(SQLERRM,1,240));
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: END prop_person_party_merge;

Line 462: FND_MSG_PUB.add;

458: or (p_parent_entity_name <> 'HZ_PARTIES') then
459: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
460: fnd_message.set_token('P_ENTITY',p_entity_name);
461: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
462: FND_MSG_PUB.add;
463: RAISE fnd_api.g_exc_error;
464: end if;
465:
466: --Repeat the same for org party

Line 478: FND_MSG_PUB.add;

474:
475: -- reject merge because the person is already used
476: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
477: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
478: FND_MSG_PUB.add;
479: x_return_status := fnd_api.g_ret_sts_error;
480: RAISE fnd_api.g_exc_error;
481:
482: else */

Line 506: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

502: x_return_status := fnd_api.g_ret_sts_error;
503: WHEN OTHERS
504: THEN
505: ROLLBACK TO PARTY_MERGE_SP;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
507: p_procedure_name => l_api_name,
508: p_error_text => SUBSTRB(SQLERRM,1,240));
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: END prop_org_party_merge;

Line 554: FND_MSG_PUB.add;

550: or (p_parent_entity_name <> 'HZ_PARTIES') then
551: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
552: fnd_message.set_token('P_ENTITY',p_entity_name);
553: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
554: FND_MSG_PUB.add;
555: RAISE fnd_api.g_exc_error;
556: end if;
557:
558: --Repeat the same for org party

Line 570: FND_MSG_PUB.add;

566:
567: -- reject merge because the person is already used
568: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
569: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
570: FND_MSG_PUB.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: RAISE fnd_api.g_exc_error;
573:
574: else */

Line 599: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

595: x_return_status := fnd_api.g_ret_sts_error;
596: WHEN OTHERS
597: THEN
598: ROLLBACK TO PARTY_MERGE_SP;
599: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
600: p_procedure_name => l_api_name,
601: p_error_text => SUBSTRB(SQLERRM,1,240));
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603: END other_support_location_merge;

Line 646: FND_MSG_PUB.add;

642: or (p_parent_entity_name <> 'HZ_PARTIES') then
643: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
644: fnd_message.set_token('P_ENTITY',p_entity_name);
645: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
646: FND_MSG_PUB.add;
647: RAISE fnd_api.g_exc_error;
648: end if;
649:
650: --Repeat the same for org party

Line 662: FND_MSG_PUB.add;

658:
659: -- reject merge because the person is already used
660: fnd_message.set_name ('IGW', 'IGW_MRG_REJECT_MERGE');
661: fnd_message.set_token('API','IGW_PARTY_MERGE_PUB.'||l_api_name);
662: FND_MSG_PUB.add;
663: x_return_status := fnd_api.g_ret_sts_error;
664: RAISE fnd_api.g_exc_error;
665:
666: else */

Line 691: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

687: x_return_status := fnd_api.g_ret_sts_error;
688: WHEN OTHERS
689: THEN
690: ROLLBACK TO PARTY_MERGE_SP;
691: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
692: p_procedure_name => l_api_name,
693: p_error_text => SUBSTRB(SQLERRM,1,240));
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: END other_support_pi_party_merge;