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.AHL_PARTY_MERGE_PKG dependencies on FND_API

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63:
64: BEGIN
65: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SOURCE_PARTY()+');
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: select merge_reason_code
70: into l_merge_reason_code
71: from hz_merge_batch

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: when resource_busy then
123: arp_message.set_line(g_proc_name || '.' || l_api_name ||
124: '; Could not obtain lock for records in table ' ||
125: 'AHL_DOCUMENTS_B for source_party_id = ' || p_from_fk_id );
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: raise;
128:
129: when others then
130: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: raise;
128:
129: when others then
130: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: raise;
133: end;
134: end if;
135: END AHL_DI_SOURCE_PARTY;

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: return;
168: end if;
169: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUPPLIER()+');
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: select merge_reason_code
174: into l_merge_reason_code
175: from hz_merge_batch

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: when resource_busy then
227: arp_message.set_line(g_proc_name || '.' || l_api_name ||
228: '; Could not obtain lock for records in table ' ||
229: 'AHL_SUPPLIER_DOCUMENTS for supplier_id = ' || p_from_fk_id );
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: raise;
232:
233: when others then
234: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: raise;
232:
233: when others then
234: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: raise;
237: end;
238: end if;
239: END AHL_DI_SUPPLIER;

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267:
268: BEGIN
269: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECIPIENT_PARTY()+');
270:
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: select merge_reason_code
274: into l_merge_reason_code
275: from hz_merge_batch

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: when resource_busy then
327: arp_message.set_line(g_proc_name || '.' || l_api_name ||
328: '; Could not obtain lock for records in table ' ||
329: 'AHL_RECIPIENT_DOCUMENTS for recipient_party_id = ' || p_from_fk_id );
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: raise;
332:
333: when others then
334: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: raise;
332:
333: when others then
334: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: raise;
337: end;
338: end if;
339: END AHL_DI_RECIPIENT_PARTY;

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: return;
371: end if;
372: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_REQUESTED_BY_PARTY ()+');
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: select merge_reason_code
377: into l_merge_reason_code
378: from hz_merge_batch

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: when resource_busy then
430: arp_message.set_line(g_proc_name || '.' || l_api_name ||
431: '; Could not obtain lock for records in table ' ||
432: 'AHL_SUBSCRIPTIONS_B for requested_by_party_id = ' || p_from_fk_id );
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: raise;
435:
436: when others then
437: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: raise;
435:
436: when others then
437: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: raise;
440: end;
441: end if;
442: END AHL_DI_REQUESTED_BY_PARTY ;

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473: return;
474: end if;
475: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUBSCRIBED_FRM_PARTY()+');
476:
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: select merge_reason_code
480: into l_merge_reason_code
481: from hz_merge_batch

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: when resource_busy then
533: arp_message.set_line(g_proc_name || '.' || l_api_name ||
534: '; Could not obtain lock for records in table ' ||
535: 'AHL_SUBSCRIPTIONS_B for requested_by_party_id = ' || p_from_fk_id );
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: raise;
538:
539: when others then
540: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: raise;
538:
539: when others then
540: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: raise;
543: end;
544: end if;
545: END AHL_DI_SUBSCRIBED_FRM_PARTY;

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: end if;
578:
579: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_APPROVED_BY_PARTY ()+');
580:
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: select merge_reason_code
584: into l_merge_reason_code
585: from hz_merge_batch

Line 640: x_return_status := FND_API.G_RET_STS_ERROR;

636: when resource_busy then
637: arp_message.set_line(g_proc_name || '.' || l_api_name ||
638: '; Could not obtain lock for records in table ' ||
639: 'AHL_DOC_REVSIONS_B for approved_by_party_id = ' || p_from_fk_id );
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: raise;
642:
643: when others then
644: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641: raise;
642:
643: when others then
644: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: raise;
647: end;
648: end if;
649: END AHL_DI_APPROVED_BY_PARTY ;

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677:
678: BEGIN
679: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECEIVED_BY_PARTY ()+');
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: select merge_reason_code
684: into l_merge_reason_code
685: from hz_merge_batch

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: when resource_busy then
737: arp_message.set_line(g_proc_name || '.' || l_api_name ||
738: '; Could not obtain lock for records in table ' ||
739: 'AHL_DOC_REVISION_COPIES for received_by_party_id = ' || p_from_fk_id );
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: raise;
742:
743: when others then
744: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: raise;
742:
743: when others then
744: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: raise;
747: end;
748: end if;
749: END AHL_DI_RECEIVED_BY_PARTY ;

Line 781: x_return_status := FND_API.G_RET_STS_SUCCESS;

777:
778: BEGIN
779: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_OPERATOR_PARTY ()+');
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: select merge_reason_code
784: into l_merge_reason_code
785: from hz_merge_batch

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: when resource_busy then
834: arp_message.set_line(g_proc_name || '.' || l_api_name ||
835: '; Could not obtain lock for records in table ' ||
836: 'AHL_OPERATIONS_B for operator_party_id = ' || p_from_fk_id );
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: raise;
839:
840: when others then
841: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: raise;
839:
840: when others then
841: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: raise;
844: end;
845: end if;
846: END AHL_RM_OPER_OPERATOR_PARTY;

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

874:
875: BEGIN
876: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_H_OPERATOR_PARTY ()+');
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: select merge_reason_code
881: into l_merge_reason_code
882: from hz_merge_batch

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930: when resource_busy then
931: arp_message.set_line(g_proc_name || '.' || l_api_name ||
932: '; Could not obtain lock for records in table ' ||
933: 'AHL_OPERATIONS_H_B for operator_party_id = ' || p_from_fk_id );
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: raise;
936:
937: when others then
938: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935: raise;
936:
937: when others then
938: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: raise;
941: end;
942: end if;
943: END AHL_RM_OPER_H_OPERATOR_PARTY;

Line 975: x_return_status := FND_API.G_RET_STS_SUCCESS;

971:
972: BEGIN
973: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_OPERATOR_PARTY ()+');
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: select merge_reason_code
978: into l_merge_reason_code
979: from hz_merge_batch

Line 1031: x_return_status := FND_API.G_RET_STS_ERROR;

1027: when resource_busy then
1028: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1029: '; Could not obtain lock for records in table ' ||
1030: 'AHL_ROUTES_B for operator_party_id = ' || p_from_fk_id );
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: raise;
1033:
1034: when others then
1035: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1036: x_return_status := FND_API.G_RET_STS_ERROR;

1032: raise;
1033:
1034: when others then
1035: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: raise;
1038: end;
1039: end if;
1040: END AHL_RM_ROUTE_OPERATOR_PARTY;

Line 1072: x_return_status := FND_API.G_RET_STS_SUCCESS;

1068:
1069: BEGIN
1070: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_H_OPERATOR_PARTY ()+');
1071:
1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: select merge_reason_code
1075: into l_merge_reason_code
1076: from hz_merge_batch

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR;

1124: when resource_busy then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1126: '; Could not obtain lock for records in table ' ||
1127: 'AHL_ROUTES_H_B for operator_party_id = ' || p_from_fk_id );
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: raise;
1130:
1131: when others then
1132: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR;

1129: raise;
1130:
1131: when others then
1132: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: raise;
1135: end;
1136: end if;
1137: END AHL_RM_ROUTE_H_OPERATOR_PARTY;

Line 1170: x_return_status := FND_API.G_RET_STS_SUCCESS;

1166:
1167: BEGIN
1168: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_OSP_CUSTOMER()+');
1169:
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171:
1172: select merge_reason_code
1173: into l_merge_reason_code
1174: from hz_merge_batch

Line 1229: x_return_status := FND_API.G_RET_STS_ERROR;

1225: when resource_busy then
1226: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1227: '; Could not obtain lock for records in table ' ||
1228: 'AHL_OSP_ORDERS_B for customer_id = ' || p_from_fk_id );
1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: raise;
1231:
1232: when others then
1233: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: raise;
1231:
1232: when others then
1233: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: raise;
1236: end;
1237: end if;
1238: END AHL_OSP_CUSTOMER;