APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_T_PARTY_DETAILS

Line 1082: PROCEDURE CSI_T_PARTY_DETAILS_MERGE(

1078: end if;
1079:
1080: END CSI_T_TXN_SYSTEMS_MERGE;
1081:
1082: PROCEDURE CSI_T_PARTY_DETAILS_MERGE(
1083: p_entity_name IN VARCHAR2,
1084: p_from_id IN NUMBER,
1085: x_to_id OUT NOCOPY NUMBER,
1086: p_from_fk_id IN NUMBER,

Line 1097: from csi_t_party_details

1093: v_party_source_table VARCHAR2(30) := 'HZ_PARTIES';
1094:
1095: cursor c1 is
1096: select 1
1097: from csi_t_party_details
1098: where party_source_id = p_from_fk_id
1099: and party_source_table = v_party_source_table
1100: for update nowait;
1101:

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

1099: and party_source_table = v_party_source_table
1100: for update nowait;
1101:
1102: l_merge_reason_code VARCHAR2(30);
1103: l_api_name VARCHAR2(30) := 'CSI_T_PARTY_DETAILS_MERGE';
1104: l_column_name VARCHAR2(30);
1105: l_count NUMBER(10) := 0;
1106: l_cp_audit_id NUMBER;
1107: v_no_of_rows NUMBER;

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

1112:
1113: RESOURCE_BUSY EXCEPTION;
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

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

1161:
1162: BEGIN
1163:
1164: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1165: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);
1166: l_column_name := 'party_source_id';
1167:
1168: open c1;
1169: close c1;

Line 1171: update csi_t_party_details

1167:
1168: open c1;
1169: close c1;
1170:
1171: update csi_t_party_details
1172: set party_source_id = p_to_fk_id,
1173: last_update_date = SYSDATE,
1174: last_updated_by = G_USER_ID,
1175: last_update_login = G_LOGIN_ID

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

1181: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1182: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1183:
1184: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1185: arp_message.set_token('TABLE_NAME', 'CSI_T_PARTY_DETAILS', FALSE);
1186:
1187: l_column_name := 'contact_party_id';
1188:
1189: EXCEPTION

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

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;
1197: raise;
1198: when others then
1199: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1204: END CSI_T_PARTY_DETAILS_MERGE;

1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: raise;
1202: END;
1203: END IF;
1204: END CSI_T_PARTY_DETAILS_MERGE;
1205:
1206: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(
1207: p_entity_name IN VARCHAR2,
1208: p_from_id IN NUMBER,