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.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on PER_ALL_PEOPLE_F

Line 161: PROCEDURE check_per_all_people_f_fk (

157: p_column_value IN NUMBER,
158: x_return_status IN OUT NOCOPY VARCHAR2
159: );
160:
161: PROCEDURE check_per_all_people_f_fk (
162: p_column IN VARCHAR2,
163: p_column_value IN NUMBER,
164: x_return_status IN OUT NOCOPY VARCHAR2
165: );

Line 1671: -- primary_specialist_id is foreign key to per_all_people_f

1667: --------------------------------------
1668: -- validate primary_specialist_id
1669: --------------------------------------
1670:
1671: -- primary_specialist_id is foreign key to per_all_people_f
1672: IF p_cust_account_rec.primary_specialist_id IS NOT NULL AND
1673: p_cust_account_rec.primary_specialist_id <> FND_API.G_MISS_NUM
1674: THEN
1675: check_per_all_people_f_fk (

Line 1675: check_per_all_people_f_fk (

1671: -- primary_specialist_id is foreign key to per_all_people_f
1672: IF p_cust_account_rec.primary_specialist_id IS NOT NULL AND
1673: p_cust_account_rec.primary_specialist_id <> FND_API.G_MISS_NUM
1674: THEN
1675: check_per_all_people_f_fk (
1676: p_column => 'primary_specialist_id',
1677: p_column_value => p_cust_account_rec.primary_specialist_id,
1678: x_return_status => x_return_status );
1679:

Line 1682: 'primary_specialist_id is foreign key to per_all_people_f. ' ||

1678: x_return_status => x_return_status );
1679:
1680: /*IF G_DEBUG THEN
1681: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1682: 'primary_specialist_id is foreign key to per_all_people_f. ' ||
1683: 'x_return_status = ' || x_return_status, l_debug_prefix );
1684: END IF;
1685: */
1686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1687: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||

1683: 'x_return_status = ' || x_return_status, l_debug_prefix );
1684: END IF;
1685: */
1686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1687: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||
1688: 'x_return_status = ' || x_return_status,
1689: p_msg_level=>fnd_log.level_statement);
1690: END IF;
1691:

Line 1712: -- secondary_specialist_id is foreign key to per_all_people_f

1708: --------------------------------------
1709: -- validate secondary_specialist_id
1710: --------------------------------------
1711:
1712: -- secondary_specialist_id is foreign key to per_all_people_f
1713: IF p_cust_account_rec.secondary_specialist_id IS NOT NULL AND
1714: p_cust_account_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
1715: THEN
1716: check_per_all_people_f_fk (

Line 1716: check_per_all_people_f_fk (

1712: -- secondary_specialist_id is foreign key to per_all_people_f
1713: IF p_cust_account_rec.secondary_specialist_id IS NOT NULL AND
1714: p_cust_account_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
1715: THEN
1716: check_per_all_people_f_fk (
1717: p_column => 'secondary_specialist_id',
1718: p_column_value => p_cust_account_rec.secondary_specialist_id,
1719: x_return_status => x_return_status );
1720:

Line 1723: 'secondary_specialist_id is foreign key to per_all_people_f. ' ||

1719: x_return_status => x_return_status );
1720:
1721: /*IF G_DEBUG THEN
1722: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1723: 'secondary_specialist_id is foreign key to per_all_people_f. ' ||
1724: 'x_return_status = ' || x_return_status, l_debug_prefix );
1725: END IF;
1726: */
1727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1728: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||

1724: 'x_return_status = ' || x_return_status, l_debug_prefix );
1725: END IF;
1726: */
1727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||
1729: 'x_return_status = ' || x_return_status,
1730: p_msg_level=>fnd_log.level_statement);
1731: END IF;
1732:

Line 7308: -- primary_specialist_id is foreign key to per_all_people_f

7304: --------------------------------------
7305: -- validate primary_specialist_id
7306: --------------------------------------
7307:
7308: -- primary_specialist_id is foreign key to per_all_people_f
7309: IF p_cust_acct_site_rec.primary_specialist_id IS NOT NULL AND
7310: p_cust_acct_site_rec.primary_specialist_id <> FND_API.G_MISS_NUM
7311: THEN
7312: check_per_all_people_f_fk (

Line 7312: check_per_all_people_f_fk (

7308: -- primary_specialist_id is foreign key to per_all_people_f
7309: IF p_cust_acct_site_rec.primary_specialist_id IS NOT NULL AND
7310: p_cust_acct_site_rec.primary_specialist_id <> FND_API.G_MISS_NUM
7311: THEN
7312: check_per_all_people_f_fk (
7313: p_column => 'primary_specialist_id',
7314: p_column_value => p_cust_acct_site_rec.primary_specialist_id,
7315: x_return_status => x_return_status );
7316:

Line 7318: hz_utility_v2pub.debug(p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||

7314: p_column_value => p_cust_acct_site_rec.primary_specialist_id,
7315: x_return_status => x_return_status );
7316:
7317: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7318: hz_utility_v2pub.debug(p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||
7319: 'x_return_status = ' || x_return_status,
7320: p_prefix =>l_debug_prefix,
7321: p_msg_level=>fnd_log.level_statement);
7322: END IF;

Line 7336: -- secondary_specialist_id is foreign key to per_all_people_f

7332: --------------------------------------
7333: -- validate secondary_specialist_id
7334: --------------------------------------
7335:
7336: -- secondary_specialist_id is foreign key to per_all_people_f
7337: IF p_cust_acct_site_rec.secondary_specialist_id IS NOT NULL AND
7338: p_cust_acct_site_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
7339: THEN
7340: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to

Line 7341: check_per_all_people_f_fk.

7337: IF p_cust_acct_site_rec.secondary_specialist_id IS NOT NULL AND
7338: p_cust_acct_site_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
7339: THEN
7340: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to
7341: check_per_all_people_f_fk.
7342: */
7343: -- check_cust_account_fk (
7344: check_per_all_people_f_fk(
7345: p_column => 'secondary_specialist_id',

Line 7344: check_per_all_people_f_fk(

7340: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to
7341: check_per_all_people_f_fk.
7342: */
7343: -- check_cust_account_fk (
7344: check_per_all_people_f_fk(
7345: p_column => 'secondary_specialist_id',
7346: p_column_value => p_cust_acct_site_rec.secondary_specialist_id,
7347: x_return_status => x_return_status );
7348:

Line 7350: hz_utility_v2pub.debug(p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||

7346: p_column_value => p_cust_acct_site_rec.secondary_specialist_id,
7347: x_return_status => x_return_status );
7348:
7349: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7350: hz_utility_v2pub.debug(p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||
7351: 'x_return_status = ' || x_return_status,
7352: p_prefix =>l_debug_prefix,
7353: p_msg_level=>fnd_log.level_statement);
7354: END IF;

Line 10804: PROCEDURE check_per_all_people_f_fk (

10800: x_return_status := FND_API.G_RET_STS_ERROR;
10801:
10802: END check_cust_account_role_fk;
10803:
10804: PROCEDURE check_per_all_people_f_fk (
10805: p_column IN VARCHAR2,
10806: p_column_value IN NUMBER,
10807: x_return_status IN OUT NOCOPY VARCHAR2
10808: ) IS

Line 10815: FROM PER_ALL_PEOPLE_F

10811:
10812: BEGIN
10813:
10814: SELECT 'Y' INTO l_dummy
10815: FROM PER_ALL_PEOPLE_F
10816: WHERE PERSON_ID = p_column_value
10817: /* Bug 3591694.
10818: Retrieve only those records, which are effective on sysdate.
10819: Both effective_start_date and effective_end_date are not null columns and

Line 10831: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );

10827: WHEN NO_DATA_FOUND THEN
10828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10829: FND_MESSAGE.SET_TOKEN( 'FK', 'person_id' );
10830: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10831: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );
10832: FND_MSG_PUB.ADD;
10833: x_return_status := FND_API.G_RET_STS_ERROR;
10834:
10835: END check_per_all_people_f_fk;

Line 10835: END check_per_all_people_f_fk;

10831: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );
10832: FND_MSG_PUB.ADD;
10833: x_return_status := FND_API.G_RET_STS_ERROR;
10834:
10835: END check_per_all_people_f_fk;
10836:
10837: PROCEDURE check_collector_fk (
10838: p_column IN VARCHAR2,
10839: p_column_value IN NUMBER,