38: x_return_status := fnd_api.g_ret_sts_success;
39:
40: if (p_entity_name <> 'IGW_PERSON_DEGREES')
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;
39:
40: if (p_entity_name <> 'IGW_PERSON_DEGREES')
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;
40: if (p_entity_name <> 'IGW_PERSON_DEGREES')
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:
53: fetch to_party_cur into to_party_rec;
54: if(to_party_cur%found) then
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;
54: if(to_party_cur%found) then
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:
129: x_return_status := fnd_api.g_ret_sts_success;
130:
131: if (p_entity_name <> 'IGW_PERSON_BIOSKETCH')
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;
130:
131: if (p_entity_name <> 'IGW_PERSON_BIOSKETCH')
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;
131: if (p_entity_name <> 'IGW_PERSON_BIOSKETCH')
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:
144: fetch to_party_cur into to_party_rec;
145: if(to_party_cur%found) then
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;
145: if(to_party_cur%found) then
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:
219: x_return_status := fnd_api.g_ret_sts_success;
220:
221: if (p_entity_name <> 'IGW_PROP_LOCATIONS')
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;
220:
221: if (p_entity_name <> 'IGW_PROP_LOCATIONS')
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;
221: if (p_entity_name <> 'IGW_PROP_LOCATIONS')
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:
234: fetch to_party_cur into to_party_rec;
235: if(to_party_cur%found) then
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;
235: if(to_party_cur%found) then
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:
310: x_return_status := fnd_api.g_ret_sts_success;
311:
312: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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;
311:
312: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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;
312: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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:
325: fetch to_party_cur into to_party_rec;
326: if(to_party_cur%found) then
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;
326: if(to_party_cur%found) then
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:
344: where proposal_id = from_party_rec.proposal_id
345: and party_id = from_party_rec.person_party_id;
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;
345: and party_id = from_party_rec.person_party_id;
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;
358: where proposal_id = from_party_rec.proposal_id
359: and party_id = from_party_rec.person_party_id;
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;
359: and party_id = from_party_rec.person_party_id;
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;
372: where proposal_id = from_party_rec.proposal_id
373: and party_id = from_party_rec.person_party_id;
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;
373: and party_id = from_party_rec.person_party_id;
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;
386: where proposal_id = from_party_rec.proposal_id
387: and party_id = from_party_rec.person_party_id;
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;
387: and party_id = from_party_rec.person_party_id;
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;
455: x_return_status := fnd_api.g_ret_sts_success;
456:
457: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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;
456:
457: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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;
457: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
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:
472: fetch to_party_cur into to_party_rec;
473: if(to_party_cur%found) then
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;
473: if(to_party_cur%found) then
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:
547: x_return_status := fnd_api.g_ret_sts_success;
548:
549: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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;
548:
549: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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;
549: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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:
564: fetch to_party_cur into to_party_rec;
565: if(to_party_cur%found) then
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;
565: if(to_party_cur%found) then
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:
639: x_return_status := fnd_api.g_ret_sts_success;
640:
641: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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;
640:
641: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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;
641: if (p_entity_name <> 'IGW_PROP_PERSON_SUPPORT')
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:
656: fetch to_party_cur into to_party_rec;
657: if(to_party_cur%found) then
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;
657: if(to_party_cur%found) then
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: