APPS.HZ_PARTY_INFO_PUB dependencies on HZ_FINANCIAL_PROFILE

Line 529: HZ_POPULATE_BOT_PKG.pop_hz_financial_profile(

525: END IF;
526:
527: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
528: -- populate function for integration service
529: HZ_POPULATE_BOT_PKG.pop_hz_financial_profile(
530: p_operation => 'I',
531: p_financial_profile_id => x_financial_profile_id);
532: END IF;
533: END IF;

Line 703: HZ_POPULATE_BOT_PKG.pop_hz_financial_profile(

699: END IF;
700:
701: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
702: -- populate function for integration service
703: HZ_POPULATE_BOT_PKG.pop_hz_financial_profile(
704: p_operation => 'U',
705: p_financial_profile_id => l_financial_profile_rec.financial_profile_id);
706: END IF;
707: END IF;

Line 1343: SELECT hz_financial_profile_s.nextval

1339: l_financial_profile_id = FND_API.G_MISS_NUM THEN
1340:
1341: l_count := 1;
1342: WHILE l_count > 0 LOOP
1343: SELECT hz_financial_profile_s.nextval
1344: INTO l_financial_profile_id FROM dual;
1345:
1346: SELECT count(*)
1347: INTO l_count

Line 1348: FROM hz_financial_profile

1344: INTO l_financial_profile_id FROM dual;
1345:
1346: SELECT count(*)
1347: INTO l_count
1348: FROM hz_financial_profile
1349: WHERE financial_profile_id = l_financial_profile_id;
1350: END LOOP;
1351: ELSE
1352: l_count := 0;

Line 1355: FROM hz_financial_profile

1351: ELSE
1352: l_count := 0;
1353: SELECT count(*)
1354: INTO l_count
1355: FROM hz_financial_profile
1356: WHERE financial_profile_id = l_financial_profile_id;
1357:
1358: if l_count > 0 then
1359: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 1383: HZ_FINANCIAL_PROFILE_PKG.INSERT_ROW(

1379: -- Make sure to use values in p_financial_profile_rec.* when calling insert table
1380: -- handler. Need to update p_financial_profile_rec first.
1381: p_financial_profile_rec.financial_profile_id := l_financial_profile_id;
1382: -- call table handler to insert a row
1383: HZ_FINANCIAL_PROFILE_PKG.INSERT_ROW(
1384: X_Rowid => l_rowid,
1385: X_FINANCIAL_PROFILE_ID => p_financial_profile_rec.financial_profile_id,
1386: X_ACCESS_AUTHORITY_DATE => p_financial_profile_rec.ACCESS_AUTHORITY_DATE,
1387: X_ACCESS_AUTHORITY_GRANTED => p_financial_profile_rec.ACCESS_AUTHORITY_GRANTED,

Line 1471: FROM HZ_FINANCIAL_PROFILE

1467: begin
1468: -- check last update date.
1469: SELECT rowid, last_update_date
1470: INTO l_rowid, l_last_update_date
1471: FROM HZ_FINANCIAL_PROFILE
1472: where financial_profile_id = p_financial_profile_rec.financial_profile_id
1473: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1474: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1475: FOR UPDATE NOWAIT;

Line 1479: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_PROFILE');

1475: FOR UPDATE NOWAIT;
1476:
1477: EXCEPTION WHEN NO_DATA_FOUND THEN
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1479: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_PROFILE');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: end;
1483: -- validate credit rating record

Line 1499: HZ_FINANCIAL_PROFILE_PKG.UPDATE_ROW(

1495: -- Make sure to use values in p_financial_profile_rec.* when calling update table
1496: -- handler. Need to update p_financial_profile_rec first.
1497: NULL;
1498: -- call table handler to update a row
1499: HZ_FINANCIAL_PROFILE_PKG.UPDATE_ROW(
1500: X_Rowid => l_rowid,
1501: X_FINANCIAL_PROFILE_ID => p_financial_profile_rec.FINANCIAL_PROFILE_ID,
1502: X_ACCESS_AUTHORITY_DATE => p_financial_profile_rec.ACCESS_AUTHORITY_DATE,
1503: X_ACCESS_AUTHORITY_GRANTED => p_financial_profile_rec.ACCESS_AUTHORITY_GRANTED,