94: when others then
95:
96: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
97: fnd_message.set_token('ERROR' ,SQLERRM);
98: fnd_msg_pub.add;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100:
101:
102: END TASK_MERGE_PARTY;
178: when others then
179:
180: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
181: fnd_message.set_token('ERROR' ,SQLERRM);
182: fnd_msg_pub.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:
185:
186: END TASK_AUDIT_MERGE_NEW_CUSTOMER;
261: when others then
262:
263: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
264: fnd_message.set_token('ERROR' ,SQLERRM);
265: fnd_msg_pub.add;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: END TASK_AUDIT_MERGE_OLD_CUSTOMER;
269:
377: to_char(p_to_fk_id) ,
378: to_char(p_from_fk_id);
379: else
380: fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');
381: fnd_msg_pub.add;
382: raise fnd_api.g_exc_error;
383: end if;
384:
385: exception
386: when others then
387:
388: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
389: fnd_message.set_token('ERROR' ,SQLERRM);
390: fnd_msg_pub.add;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: END TASK_MERGE_SOURCE_OBJECT;
394:
497: to_char(p_to_fk_id) ,
498: to_char(p_from_fk_id);
499: else
500: fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');
501: fnd_msg_pub.add;
502: raise fnd_api.g_exc_error;
503: end if;
504:
505: exception
506: when others then
507:
508: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
509: fnd_message.set_token('ERROR' ,SQLERRM);
510: fnd_msg_pub.add;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512:
513:
514: END TASK_AUDIT_MERGE_NEW_S_OBJECT;
621: to_char(p_to_fk_id) ,
622: to_char(p_from_fk_id);
623: else
624: fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');
625: fnd_msg_pub.add;
626: raise fnd_api.g_exc_error;
627: end if;
628:
629: exception
630: when others then
631:
632: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
633: fnd_message.set_token('ERROR' ,SQLERRM);
634: fnd_msg_pub.add;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636:
637:
638: END TASK_AUDIT_MERGE_OLD_S_OBJECT;
747: to_char(p_from_fk_id);
748:
749: else
750: fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');
751: fnd_msg_pub.add;
752: raise fnd_api.g_exc_error;
753: end if;
754:
755: exception
756: when others then
757:
758: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
759: fnd_message.set_token('ERROR' ,SQLERRM);
760: fnd_msg_pub.add;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762:
763: END TASK_REF_MERGE_PARTY_OBJECT;
764:
873: to_char(p_to_fk_id) ,
874: to_char(p_from_fk_id);
875: else
876: fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');
877: fnd_msg_pub.add;
878: raise fnd_api.g_exc_error;
879: end if;
880:
881: exception
882: when others then
883:
884: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
885: fnd_message.set_token('ERROR' ,SQLERRM);
886: fnd_msg_pub.add;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888:
889: END TASK_REF_MERGE_PSITE_OBJECT;
890:
969: when others then
970:
971: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
972: fnd_message.set_token('ERROR' ,SQLERRM);
973: fnd_msg_pub.add;
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975:
976: END TASK_MERGE_ADDRESS;
977:
1054: when others then
1055:
1056: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1057: fnd_message.set_token('ERROR' ,SQLERRM);
1058: fnd_msg_pub.add;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060:
1061: END TASK_AUDIT_MERGE_NEW_ADDRESS;
1062:
1139: when others then
1140:
1141: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1142: fnd_message.set_token('ERROR' ,SQLERRM);
1143: fnd_msg_pub.add;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145:
1146: END TASK_AUDIT_MERGE_OLD_ADDRESS;
1147:
1224: when others then
1225:
1226: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1227: fnd_message.set_token('ERROR' ,SQLERRM);
1228: fnd_msg_pub.add;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230:
1231: END TASK_MERGE_CONTACTS;
1232:
1310: when others then
1311:
1312: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1313: fnd_message.set_token('ERROR' ,SQLERRM);
1314: fnd_msg_pub.add;
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316:
1317: END TASK_MERGE_CONTACT_POINTS;
1318:
1469: when others then
1470:
1471: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1472: fnd_message.set_token('ERROR' ,SQLERRM);
1473: fnd_msg_pub.add;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475:
1476:
1477: END SEARCH_MERGE_NUMBER_PARTY_ID;
1645: when others then
1646:
1647: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1648: fnd_message.set_token('ERROR' ,SQLERRM);
1649: fnd_msg_pub.add;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651:
1652:
1653: END SEARCH_MERGE_NAME_PARTY_ID;
1738: when others then
1739:
1740: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1741: fnd_message.set_token('ERROR' ,SQLERRM);
1742: fnd_msg_pub.add;
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744:
1745: END TASK_ASSIGNMENTS_MERGE;
1746: