DBA Data[Home] [Help]

APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_RELOCATE_ASTS_ALL_B

Line 1228: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);

1224: -- as the Merged To Id
1225: IF p_from_fk_id <> p_to_fk_id THEN
1226: BEGIN
1227: ARP_MESSAGE.set_name('AR','AR_UPDATING_TABLE');
1228: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);
1229: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1230: SET RAB.PAC_ID = p_to_fk_id,
1231: RAB.object_version_number = RAB.object_version_number + 1,
1232: RAB.last_update_date = SYSDATE,

Line 1229: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB

1225: IF p_from_fk_id <> p_to_fk_id THEN
1226: BEGIN
1227: ARP_MESSAGE.set_name('AR','AR_UPDATING_TABLE');
1228: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);
1229: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1230: SET RAB.PAC_ID = p_to_fk_id,
1231: RAB.object_version_number = RAB.object_version_number + 1,
1232: RAB.last_update_date = SYSDATE,
1233: RAB.last_updated_by = arp_standard.profile.user_id,

Line 1243: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));

1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: ARP_MESSAGE.set_line(G_PKG_NAME|| '.' ||l_api_name||': '|| sqlerrm);
1242: FND_FILE.put_line(FND_FILE.log,
1243: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));
1244: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246: END;
1247: END IF;

Line 1307: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);

1303: -- as the Merged To Id
1304: IF p_from_fk_id <> p_to_fk_id THEN
1305: BEGIN
1306: ARP_MESSAGE.set_name('AR','AR_UPDATING_TABLE');
1307: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);
1308: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1309: SET RAB.IST_ID = p_to_fk_id,
1310: RAB.object_version_number = RAB.object_version_number + 1,
1311: RAB.last_update_date = SYSDATE,

Line 1308: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB

1304: IF p_from_fk_id <> p_to_fk_id THEN
1305: BEGIN
1306: ARP_MESSAGE.set_name('AR','AR_UPDATING_TABLE');
1307: ARP_MESSAGE.set_token('TABLE_NAME','OKL_RELOCATE_ASTS_ALL_B',FALSE);
1308: UPDATE OKL_RELOCATE_ASTS_ALL_B RAB
1309: SET RAB.IST_ID = p_to_fk_id,
1310: RAB.object_version_number = RAB.object_version_number + 1,
1311: RAB.last_update_date = SYSDATE,
1312: RAB.last_updated_by = arp_standard.profile.user_id,

Line 1322: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));

1318: EXCEPTION
1319: WHEN OTHERS THEN
1320: ARP_MESSAGE.set_line(G_PKG_NAME|| '.' ||l_api_name||': '|| sqlerrm);
1321: FND_FILE.put_line(FND_FILE.log,
1322: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));
1323: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: END;
1326: END IF;