eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_PARTY_MERGE_PKG dependencies on FND_API

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44:
45:
46: BEGIN
47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: open c_duplicate;
51: fetch c_duplicate into l_merge_reason_code;
52: close c_duplicate;

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128:
129:
130: BEGIN
131:
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: open c_duplicate;
135: fetch c_duplicate into l_merge_reason_code;
136: close c_duplicate;

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211:
212:
213: BEGIN
214:
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: open c_duplicate;
218: fetch c_duplicate into l_merge_reason_code;
219: close c_duplicate;

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
270: ------------------------------------------------------------------------------------------

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311:
312:
313: BEGIN
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: open c_duplicate;
318: fetch c_duplicate into l_merge_reason_code;
319: close c_duplicate;

Line 382: raise fnd_api.g_exc_error;

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

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
395: ------------------------------------------------------------------------------------------

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: l_select_stat varchar2(1000);
436:
437: BEGIN
438:
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: open c_duplicate;
442: fetch c_duplicate into l_merge_reason_code;
443: close c_duplicate;

Line 502: raise fnd_api.g_exc_error;

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

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 561: x_return_status := FND_API.G_RET_STS_SUCCESS;

557: l_select_stat varchar2(1000);
558:
559: BEGIN
560:
561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562:
563: open c_duplicate;
564: fetch c_duplicate into l_merge_reason_code;
565: close c_duplicate;

Line 626: raise fnd_api.g_exc_error;

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

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 687: x_return_status := FND_API.G_RET_STS_SUCCESS;

683:
684:
685: BEGIN
686:
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: open c_duplicate;
690: fetch c_duplicate into l_merge_reason_code;
691: close c_duplicate;

Line 752: raise fnd_api.g_exc_error;

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

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
765: ------------------------------------------------------------------------------------------

Line 811: x_return_status := FND_API.G_RET_STS_SUCCESS;

807:
808:
809: BEGIN
810:
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
812:
813: open c_duplicate;
814: fetch c_duplicate into l_merge_reason_code;
815: close c_duplicate;

Line 878: raise fnd_api.g_exc_error;

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

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
891:

Line 920: x_return_status := FND_API.G_RET_STS_SUCCESS;

916:
917:
918: BEGIN
919:
920: x_return_status := FND_API.G_RET_STS_SUCCESS;
921:
922: open c_duplicate;
923: fetch c_duplicate into l_merge_reason_code;
924: close c_duplicate;

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
978: ------------------------------------------------------------------------------------------

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001:
1002:
1003: BEGIN
1004:
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: open c_duplicate;
1008: fetch c_duplicate into l_merge_reason_code;
1009: close c_duplicate;

Line 1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1063: ------------------------------------------------------------------------------------------

Line 1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

1086:
1087:
1088: BEGIN
1089:
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091:
1092: open c_duplicate;
1093: fetch c_duplicate into l_merge_reason_code;
1094: close c_duplicate;

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1148: ------------------------------------------------------------------------------------------

Line 1174: x_return_status := FND_API.G_RET_STS_SUCCESS;

1170: where batch_id = p_batch_id;
1171:
1172: BEGIN
1173:
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1175:
1176: open c_duplicate;
1177: fetch c_duplicate into l_merge_reason_code;
1178: close c_duplicate;

Line 1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1233:

Line 1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

1256: where batch_id = p_batch_id;
1257:
1258: BEGIN
1259:
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: open c_duplicate;
1263: fetch c_duplicate into l_merge_reason_code;
1264: close c_duplicate;

Line 1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1319:

Line 1368: x_return_status := FND_API.G_RET_STS_SUCCESS;

1364: l_customer_new_number hz_parties.party_number%TYPE;
1365:
1366: BEGIN
1367:
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369:
1370: open c_duplicate;
1371: fetch c_duplicate into l_merge_reason_code;
1372: close c_duplicate;

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524: l_customer_new_name hz_parties.party_name%TYPE;
1525:
1526: BEGIN
1527:
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529:
1530: open c_duplicate;
1531: fetch c_duplicate into l_merge_reason_code;
1532: close c_duplicate;

Line 1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1689: x_return_status := FND_API.G_RET_STS_SUCCESS;

1685: l_party_type hz_parties.party_type%TYPE;
1686:
1687: BEGIN
1688:
1689: x_return_status := FND_API.G_RET_STS_SUCCESS;
1690:
1691: open c_duplicate;
1692: fetch c_duplicate into l_merge_reason_code;
1693: close c_duplicate;

Line 1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1747: