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 1684: -- primary_specialist_id is foreign key to per_all_people_f

1680: --------------------------------------
1681: -- validate primary_specialist_id
1682: --------------------------------------
1683:
1684: -- primary_specialist_id is foreign key to per_all_people_f
1685: IF p_cust_account_rec.primary_specialist_id IS NOT NULL AND
1686: p_cust_account_rec.primary_specialist_id <> FND_API.G_MISS_NUM
1687: THEN
1688: check_per_all_people_f_fk (

Line 1688: check_per_all_people_f_fk (

1684: -- primary_specialist_id is foreign key to per_all_people_f
1685: IF p_cust_account_rec.primary_specialist_id IS NOT NULL AND
1686: p_cust_account_rec.primary_specialist_id <> FND_API.G_MISS_NUM
1687: THEN
1688: check_per_all_people_f_fk (
1689: p_column => 'primary_specialist_id',
1690: p_column_value => p_cust_account_rec.primary_specialist_id,
1691: x_return_status => x_return_status );
1692:

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

1691: x_return_status => x_return_status );
1692:
1693: /*IF G_DEBUG THEN
1694: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1695: 'primary_specialist_id is foreign key to per_all_people_f. ' ||
1696: 'x_return_status = ' || x_return_status, l_debug_prefix );
1697: END IF;
1698: */
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1696: 'x_return_status = ' || x_return_status, l_debug_prefix );
1697: END IF;
1698: */
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||
1701: 'x_return_status = ' || x_return_status,
1702: p_msg_level=>fnd_log.level_statement);
1703: END IF;
1704:

Line 1725: -- secondary_specialist_id is foreign key to per_all_people_f

1721: --------------------------------------
1722: -- validate secondary_specialist_id
1723: --------------------------------------
1724:
1725: -- secondary_specialist_id is foreign key to per_all_people_f
1726: IF p_cust_account_rec.secondary_specialist_id IS NOT NULL AND
1727: p_cust_account_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
1728: THEN
1729: check_per_all_people_f_fk (

Line 1729: check_per_all_people_f_fk (

1725: -- secondary_specialist_id is foreign key to per_all_people_f
1726: IF p_cust_account_rec.secondary_specialist_id IS NOT NULL AND
1727: p_cust_account_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
1728: THEN
1729: check_per_all_people_f_fk (
1730: p_column => 'secondary_specialist_id',
1731: p_column_value => p_cust_account_rec.secondary_specialist_id,
1732: x_return_status => x_return_status );
1733:

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

1732: x_return_status => x_return_status );
1733:
1734: /*IF G_DEBUG THEN
1735: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1736: 'secondary_specialist_id is foreign key to per_all_people_f. ' ||
1737: 'x_return_status = ' || x_return_status, l_debug_prefix );
1738: END IF;
1739: */
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1737: 'x_return_status = ' || x_return_status, l_debug_prefix );
1738: END IF;
1739: */
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1741: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||
1742: 'x_return_status = ' || x_return_status,
1743: p_msg_level=>fnd_log.level_statement);
1744: END IF;
1745:

Line 7583: -- primary_specialist_id is foreign key to per_all_people_f

7579: --------------------------------------
7580: -- validate primary_specialist_id
7581: --------------------------------------
7582:
7583: -- primary_specialist_id is foreign key to per_all_people_f
7584: IF p_cust_acct_site_rec.primary_specialist_id IS NOT NULL AND
7585: p_cust_acct_site_rec.primary_specialist_id <> FND_API.G_MISS_NUM
7586: THEN
7587: check_per_all_people_f_fk (

Line 7587: check_per_all_people_f_fk (

7583: -- primary_specialist_id is foreign key to per_all_people_f
7584: IF p_cust_acct_site_rec.primary_specialist_id IS NOT NULL AND
7585: p_cust_acct_site_rec.primary_specialist_id <> FND_API.G_MISS_NUM
7586: THEN
7587: check_per_all_people_f_fk (
7588: p_column => 'primary_specialist_id',
7589: p_column_value => p_cust_acct_site_rec.primary_specialist_id,
7590: x_return_status => x_return_status );
7591:

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

7589: p_column_value => p_cust_acct_site_rec.primary_specialist_id,
7590: x_return_status => x_return_status );
7591:
7592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7593: hz_utility_v2pub.debug(p_message=>'primary_specialist_id is foreign key to per_all_people_f. ' ||
7594: 'x_return_status = ' || x_return_status,
7595: p_prefix =>l_debug_prefix,
7596: p_msg_level=>fnd_log.level_statement);
7597: END IF;

Line 7611: -- secondary_specialist_id is foreign key to per_all_people_f

7607: --------------------------------------
7608: -- validate secondary_specialist_id
7609: --------------------------------------
7610:
7611: -- secondary_specialist_id is foreign key to per_all_people_f
7612: IF p_cust_acct_site_rec.secondary_specialist_id IS NOT NULL AND
7613: p_cust_acct_site_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
7614: THEN
7615: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to

Line 7616: check_per_all_people_f_fk.

7612: IF p_cust_acct_site_rec.secondary_specialist_id IS NOT NULL AND
7613: p_cust_acct_site_rec.secondary_specialist_id <> FND_API.G_MISS_NUM
7614: THEN
7615: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to
7616: check_per_all_people_f_fk.
7617: */
7618: -- check_cust_account_fk (
7619: check_per_all_people_f_fk(
7620: p_column => 'secondary_specialist_id',

Line 7619: check_per_all_people_f_fk(

7615: /* Bug 3591694 Changed foreign key validation from check_cust_account_fk to
7616: check_per_all_people_f_fk.
7617: */
7618: -- check_cust_account_fk (
7619: check_per_all_people_f_fk(
7620: p_column => 'secondary_specialist_id',
7621: p_column_value => p_cust_acct_site_rec.secondary_specialist_id,
7622: x_return_status => x_return_status );
7623:

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

7621: p_column_value => p_cust_acct_site_rec.secondary_specialist_id,
7622: x_return_status => x_return_status );
7623:
7624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7625: hz_utility_v2pub.debug(p_message=>'secondary_specialist_id is foreign key to per_all_people_f. ' ||
7626: 'x_return_status = ' || x_return_status,
7627: p_prefix =>l_debug_prefix,
7628: p_msg_level=>fnd_log.level_statement);
7629: END IF;

Line 11095: PROCEDURE check_per_all_people_f_fk (

11091: x_return_status := FND_API.G_RET_STS_ERROR;
11092:
11093: END check_cust_account_role_fk;
11094:
11095: PROCEDURE check_per_all_people_f_fk (
11096: p_column IN VARCHAR2,
11097: p_column_value IN NUMBER,
11098: x_return_status IN OUT NOCOPY VARCHAR2
11099: ) IS

Line 11106: FROM PER_ALL_PEOPLE_F

11102:
11103: BEGIN
11104:
11105: SELECT 'Y' INTO l_dummy
11106: FROM PER_ALL_PEOPLE_F
11107: WHERE PERSON_ID = p_column_value
11108: /* Bug 3591694.
11109: Retrieve only those records, which are effective on sysdate.
11110: Both effective_start_date and effective_end_date are not null columns and

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

11118: WHEN NO_DATA_FOUND THEN
11119: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11120: FND_MESSAGE.SET_TOKEN( 'FK', 'person_id' );
11121: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11122: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );
11123: FND_MSG_PUB.ADD;
11124: x_return_status := FND_API.G_RET_STS_ERROR;
11125:
11126: END check_per_all_people_f_fk;

Line 11126: END check_per_all_people_f_fk;

11122: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );
11123: FND_MSG_PUB.ADD;
11124: x_return_status := FND_API.G_RET_STS_ERROR;
11125:
11126: END check_per_all_people_f_fk;
11127:
11128: PROCEDURE check_collector_fk (
11129: p_column IN VARCHAR2,
11130: p_column_value IN NUMBER,