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

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
55: BEGIN
56: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: begin
61: select internal_party_id
62: into v_internal_party_id

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

66: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. Data exists in Installed Base, but Install Parameters are not defined';
67: raise internal_party_error;
68: when others then
69: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: raise;
72: end;
73:
74: if v_internal_party_id = p_from_fk_id or

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273:
274: EXCEPTION
275: when internal_party_error then
276: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: raise;
279: when txn_type_not_found_error then
280: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
281: x_return_status := FND_API.G_RET_STS_ERROR;

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277: x_return_status := FND_API.G_RET_STS_ERROR;
278: raise;
279: when txn_type_not_found_error then
280: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: raise;
283: when resource_busy then
284: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_ITEM_INSTANCES for '||l_column_name ||' = '|| p_from_fk_id );
285: x_return_status := FND_API.G_RET_STS_ERROR;

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: x_return_status := FND_API.G_RET_STS_ERROR;
282: raise;
283: when resource_busy then
284: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_ITEM_INSTANCES for '||l_column_name ||' = '|| p_from_fk_id );
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: raise;
287: when others then
288: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
289: x_return_status := FND_API.G_RET_STS_ERROR;

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: x_return_status := FND_API.G_RET_STS_ERROR;
286: raise;
287: when others then
288: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: raise;
291: END;
292: END IF;
293: END CSI_ITEM_INSTANCES_MERGE;

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
335: BEGIN
336: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: begin
341: select internal_party_id
342: into v_internal_party_id

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. Data exists in Installed Base, but Install Parameters are not defined';
347: raise internal_party_error;
348: when others then
349: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: raise;
352: end;
353:
354: if v_internal_party_id = p_from_fk_id or

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504:
505: EXCEPTION
506: when internal_party_error then
507: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: raise;
510: when txn_type_not_found_error then
511: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
512: x_return_status := FND_API.G_RET_STS_ERROR;

Line 512: x_return_status := FND_API.G_RET_STS_ERROR;

508: x_return_status := FND_API.G_RET_STS_ERROR;
509: raise;
510: when txn_type_not_found_error then
511: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: raise;
514: when resource_busy then
515: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_I_PARTIES for '||l_column_name ||' = '|| p_from_fk_id );
516: x_return_status := FND_API.G_RET_STS_ERROR;

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: x_return_status := FND_API.G_RET_STS_ERROR;
513: raise;
514: when resource_busy then
515: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_I_PARTIES for '||l_column_name ||' = '|| p_from_fk_id );
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: raise;
518: when others then
519: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
520: x_return_status := FND_API.G_RET_STS_ERROR;

Line 520: x_return_status := FND_API.G_RET_STS_ERROR;

516: x_return_status := FND_API.G_RET_STS_ERROR;
517: raise;
518: when others then
519: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: raise;
522: END;
523: END IF;
524: END CSI_I_PARTIES_MERGE;

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571:
572: BEGIN
573: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
574:
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: begin
578: select internal_party_id
579: into v_internal_party_id

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. Data exists in Installed Base, but Install Parameters are not defined';
584: raise internal_party_error;
585: when others then
586: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: raise;
589: end;
590:
591: if v_internal_party_id = p_from_fk_id or

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824:
825: EXCEPTION
826: when internal_party_error then
827: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: raise;
830: when txn_type_not_found_error then
831: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: x_return_status := FND_API.G_RET_STS_ERROR;
829: raise;
830: when txn_type_not_found_error then
831: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: raise;
834: when resource_busy then
835: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_SYSTEMS_B for '||l_column_name ||' = '|| p_from_fk_id );
836: x_return_status := FND_API.G_RET_STS_ERROR;

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 841: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 891: x_return_status := FND_API.G_RET_STS_SUCCESS;

887:
888: BEGIN
889: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
890:
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: begin
894: select internal_party_id
895: into v_internal_party_id

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. Data exists in Installed Base, but Install Parameters are not defined';
900: raise internal_party_error;
901: when others then
902: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: raise;
905: end;
906:
907: if v_internal_party_id = p_from_fk_id or

Line 992: x_return_status := FND_API.G_RET_STS_ERROR;

988:
989: EXCEPTION
990: when internal_party_error then
991: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;
994: when resource_busy then
995: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_SYSTEMS for '||l_column_name ||' = '|| p_from_fk_id );
996: x_return_status := FND_API.G_RET_STS_ERROR;

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;
994: when resource_busy then
995: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_SYSTEMS for '||l_column_name ||' = '|| p_from_fk_id );
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: raise;
998: when others then
999: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1000: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: x_return_status := FND_API.G_RET_STS_ERROR;
997: raise;
998: when others then
999: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: raise;
1002: END;
1003:
1004: end if;

Line 1044: x_return_status := FND_API.G_RET_STS_SUCCESS;

1040: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1041: BEGIN
1042: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_PARTY_DETAILS_MERGE()+');
1043:
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046: begin
1047: select internal_party_id
1048: into v_internal_party_id

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. Data exists in Installed Base, but Install Parameters are not defined';
1053: raise internal_party_error;
1054: when others then
1055: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: raise;
1058: end;
1059:
1060: if v_internal_party_id = p_from_fk_id or

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR;

1114:
1115: EXCEPTION
1116: when internal_party_error then
1117: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise;
1120: when resource_busy then
1121: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_PARTY_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1122: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1122: x_return_status := FND_API.G_RET_STS_ERROR;

1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise;
1120: when resource_busy then
1121: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_PARTY_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: raise;
1124: when others then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1126: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR;

1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: raise;
1124: when others then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: raise;
1128: END;
1129: END IF;
1130: END CSI_T_PARTY_DETAILS_MERGE;

Line 1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

1167: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1168: BEGIN
1169: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');
1170:
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: select merge_reason_code
1174: into l_merge_reason_code
1175: from hz_merge_batch

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214:
1215: EXCEPTION
1216: when internal_party_error then
1217: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: raise;
1220: when resource_busy then
1221: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_LINE_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1222: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1222: x_return_status := FND_API.G_RET_STS_ERROR;

1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: raise;
1220: when resource_busy then
1221: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_LINE_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: raise;
1224: when others then
1225: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1226: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR;

1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: raise;
1224: when others then
1225: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: raise;
1228: END;
1229: END IF;
1230: END CSI_T_TXN_LINE_DETAILS_MERGE;