APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_T_PARTY_DETAILS

Line 1008: PROCEDURE CSI_T_PARTY_DETAILS_MERGE(

1004: end if;
1005:
1006: END CSI_T_TXN_SYSTEMS_MERGE;
1007:
1008: PROCEDURE CSI_T_PARTY_DETAILS_MERGE(
1009: p_entity_name IN VARCHAR2,
1010: p_from_id IN NUMBER,
1011: x_to_id OUT NOCOPY NUMBER,
1012: p_from_fk_id IN NUMBER,

Line 1023: from csi_t_party_details

1019: v_party_source_table VARCHAR2(30) := 'HZ_PARTIES';
1020:
1021: cursor c1 is
1022: select 1
1023: from csi_t_party_details
1024: where party_source_id = p_from_fk_id
1025: and party_source_table = v_party_source_table
1026: for update nowait;
1027:

Line 1029: l_api_name VARCHAR2(30) := 'CSI_T_PARTY_DETAILS_MERGE';

1025: and party_source_table = v_party_source_table
1026: for update nowait;
1027:
1028: l_merge_reason_code VARCHAR2(30);
1029: l_api_name VARCHAR2(30) := 'CSI_T_PARTY_DETAILS_MERGE';
1030: l_column_name VARCHAR2(30);
1031: l_count NUMBER(10) := 0;
1032: l_cp_audit_id NUMBER;
1033: v_no_of_rows NUMBER;

Line 1042: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_PARTY_DETAILS_MERGE()+');

1038:
1039: RESOURCE_BUSY EXCEPTION;
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

Line 1091: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);

1087:
1088: BEGIN
1089:
1090: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1091: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);
1092: l_column_name := 'party_source_id';
1093:
1094: open c1;
1095: close c1;

Line 1097: update csi_t_party_details

1093:
1094: open c1;
1095: close c1;
1096:
1097: update csi_t_party_details
1098: set party_source_id = p_to_fk_id,
1099: last_update_date = SYSDATE,
1100: last_updated_by = G_USER_ID,
1101: last_update_login = G_LOGIN_ID

Line 1111: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);

1107: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1108: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1109:
1110: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1111: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);
1112:
1113: l_column_name := 'contact_party_id';
1114:
1115: EXCEPTION

Line 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 );

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;
1123: raise;
1124: when others then
1125: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1130: END CSI_T_PARTY_DETAILS_MERGE;

1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: raise;
1128: END;
1129: END IF;
1130: END CSI_T_PARTY_DETAILS_MERGE;
1131:
1132: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(
1133: p_entity_name IN VARCHAR2,
1134: p_from_id IN NUMBER,