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 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);
70:
71:
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: begin
76: select internal_party_id
77: into v_internal_party_id

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: 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';
82: raise internal_party_error;
83: when others then
84: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: raise;
87: end;
88:
89: if v_internal_party_id = p_from_fk_id or

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: EXCEPTION
290: WHEN others THEN
291: arp_message.set_line(g_proc_name || '.' || l_api_name || ': '
292: || sqlerrm);
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: raise;
295: END;
296:
297: WHEN others THEN

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

296:
297: WHEN others THEN
298: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||
299: sqlerrm);
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: raise;
302:
303: END;
304: /*

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338:
339: EXCEPTION
340: when internal_party_error then
341: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: raise;
344: when txn_type_not_found_error then
345: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
346: x_return_status := FND_API.G_RET_STS_ERROR;

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: x_return_status := FND_API.G_RET_STS_ERROR;
343: raise;
344: when txn_type_not_found_error then
345: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: raise;
348: when resource_busy then
349: 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 );
350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: x_return_status := FND_API.G_RET_STS_ERROR;
347: raise;
348: when resource_busy then
349: 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 );
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: raise;
352: when others then
353: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
354: x_return_status := FND_API.G_RET_STS_ERROR;

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

350: x_return_status := FND_API.G_RET_STS_ERROR;
351: raise;
352: when others then
353: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: raise;
356: END;
357: END IF;
358: END CSI_ITEM_INSTANCES_MERGE;

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: begin
408: select internal_party_id
409: into v_internal_party_id

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: 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';
414: raise internal_party_error;
415: when others then
416: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: raise;
419: end;
420:
421: if v_internal_party_id = p_from_fk_id or

Line 582: x_return_status := FND_API.G_RET_STS_ERROR;

578:
579: EXCEPTION
580: when internal_party_error then
581: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: raise;
584: when txn_type_not_found_error then
585: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
586: x_return_status := FND_API.G_RET_STS_ERROR;

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: x_return_status := FND_API.G_RET_STS_ERROR;
583: raise;
584: when txn_type_not_found_error then
585: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: raise;
588: when resource_busy then
589: 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 );
590: x_return_status := FND_API.G_RET_STS_ERROR;

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: x_return_status := FND_API.G_RET_STS_ERROR;
587: raise;
588: when resource_busy then
589: 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 );
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: raise;
592: when others then
593: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
594: x_return_status := FND_API.G_RET_STS_ERROR;

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590: x_return_status := FND_API.G_RET_STS_ERROR;
591: raise;
592: when others then
593: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: raise;
596: END;
597: END IF;
598: END CSI_I_PARTIES_MERGE;

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645:
646: BEGIN
647: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: begin
652: select internal_party_id
653: into v_internal_party_id

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: 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';
658: raise internal_party_error;
659: when others then
660: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: raise;
663: end;
664:
665: if v_internal_party_id = p_from_fk_id or

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

898:
899: EXCEPTION
900: when internal_party_error then
901: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: raise;
904: when txn_type_not_found_error then
905: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
906: x_return_status := FND_API.G_RET_STS_ERROR;

Line 906: x_return_status := FND_API.G_RET_STS_ERROR;

902: x_return_status := FND_API.G_RET_STS_ERROR;
903: raise;
904: when txn_type_not_found_error then
905: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: raise;
908: when resource_busy then
909: 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 );
910: x_return_status := FND_API.G_RET_STS_ERROR;

Line 910: x_return_status := FND_API.G_RET_STS_ERROR;

906: x_return_status := FND_API.G_RET_STS_ERROR;
907: raise;
908: when resource_busy then
909: 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 );
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: raise;
912:
913: when others then
914: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: raise;
912:
913: when others then
914: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: raise;
917: END;
918: end if;
919: END CSI_SYSTEMS_B_MERGE;

Line 965: x_return_status := FND_API.G_RET_STS_SUCCESS;

961:
962: BEGIN
963: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
964:
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: begin
968: select internal_party_id
969: into v_internal_party_id

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: 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';
974: raise internal_party_error;
975: when others then
976: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: raise;
979: end;
980:
981: if v_internal_party_id = p_from_fk_id or

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

1062:
1063: EXCEPTION
1064: when internal_party_error then
1065: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: raise;
1068: when resource_busy then
1069: 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 );
1070: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1070: x_return_status := FND_API.G_RET_STS_ERROR;

1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: raise;
1068: when resource_busy then
1069: 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 );
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: raise;
1072: when others then
1073: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1074: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: raise;
1072: when others then
1073: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: raise;
1076: END;
1077:
1078: end if;

Line 1118: x_return_status := FND_API.G_RET_STS_SUCCESS;

1114: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1115: BEGIN
1116: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_PARTY_DETAILS_MERGE()+');
1117:
1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119:
1120: begin
1121: select internal_party_id
1122: into v_internal_party_id

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: 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';
1127: raise internal_party_error;
1128: when others then
1129: arp_message.set_line(g_proc_name || '.' ||l_api_name || ': ' ||sqlerrm);
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: raise;
1132: end;
1133:
1134: if v_internal_party_id = p_from_fk_id or

Line 1192: x_return_status := FND_API.G_RET_STS_ERROR;

1188:
1189: EXCEPTION
1190: when internal_party_error then
1191: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: raise;
1194: when resource_busy then
1195: 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 );
1196: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: raise;
1194: when resource_busy then
1195: 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 );
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: raise;
1198: when others then
1199: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1200: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1200: x_return_status := FND_API.G_RET_STS_ERROR;

1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: raise;
1198: when others then
1199: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: raise;
1202: END;
1203: END IF;
1204: END CSI_T_PARTY_DETAILS_MERGE;

Line 1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

1241: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1242: BEGIN
1243: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');
1244:
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246:
1247: select merge_reason_code
1248: into l_merge_reason_code
1249: from hz_merge_batch

Line 1292: x_return_status := FND_API.G_RET_STS_ERROR;

1288:
1289: EXCEPTION
1290: when internal_party_error then
1291: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: raise;
1294: when resource_busy then
1295: 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 );
1296: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1296: x_return_status := FND_API.G_RET_STS_ERROR;

1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: raise;
1294: when resource_busy then
1295: 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 );
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: raise;
1298: when others then
1299: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1300: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR;

1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: raise;
1298: when others then
1299: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: raise;
1302: END;
1303: END IF;
1304: END CSI_T_TXN_LINE_DETAILS_MERGE;