APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 483: -- hz_orig_system_ref_pub.get_owner_table_id

479: l_validate_flag varchar2(1) := 'Y';
480: l_mosr_owner_table_id number;
481:
482: l_temp_return_status VARCHAR2(10); -- for storing return status from
483: -- hz_orig_system_ref_pub.get_owner_table_id
484:
485: BEGIN
486:
487: -- Check if API is called in debug mode. If yes, enable debug.

Line 831: hz_orig_system_ref_pub.get_owner_table_id

827: IF (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
828: and (p_cust_account_rec.orig_system_reference is not null and p_cust_account_rec.orig_system_reference <>fnd_api.g_miss_char)
829: and p_create_update_flag = 'U'
830: then
831: hz_orig_system_ref_pub.get_owner_table_id
832: (p_orig_system => p_cust_account_rec.orig_system,
833: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
834: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
835: x_owner_table_id => l_mosr_owner_table_id,

Line 844: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

840: THEN
841: l_validate_flag := 'N';
842: END IF;
843:
844: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
845: -- x_return_status. Set x_return_status to error, ONLY if there is error.
846: -- In case of success, leave it to carry over previous value as before this call.
847: -- Fix for Bug 5498116 (29-AUG-2006)
848: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 6990: -- hz_orig_system_ref_pub.get_owner_table_id

6986: l_validate_flag varchar2(1) := 'Y';
6987: l_mosr_owner_table_id number;
6988:
6989: l_temp_return_status VARCHAR2(10); -- for storing return status from
6990: -- hz_orig_system_ref_pub.get_owner_table_id
6991:
6992: BEGIN
6993:
6994: -- Check if API is called in debug mode. If yes, enable debug.

Line 7357: hz_orig_system_ref_pub.get_owner_table_id

7353: IF (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
7354: and (p_cust_acct_site_rec.orig_system_reference is not null and p_cust_acct_site_rec.orig_system_reference <>fnd_api.g_miss_char)
7355: and p_create_update_flag = 'U'
7356: then
7357: hz_orig_system_ref_pub.get_owner_table_id
7358: (p_orig_system => p_cust_acct_site_rec.orig_system,
7359: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
7360: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
7361: x_owner_table_id => l_mosr_owner_table_id,

Line 7370: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

7366: THEN
7367: l_validate_flag := 'N';
7368: END IF;
7369:
7370: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
7371: -- x_return_status. Set x_return_status to error, ONLY if there is error.
7372: -- In case of success, leave it to carry over previous value as before this call.
7373: -- Fix for Bug 5498116 (29-AUG-2006)
7374: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 7824: -- hz_orig_system_ref_pub.get_owner_table_id

7820: l_coa_id NUMBER;
7821: l_exist_flag VARCHAR2(1);
7822:
7823: l_temp_return_status VARCHAR2(10); -- for storing return status from
7824: -- hz_orig_system_ref_pub.get_owner_table_id
7825:
7826: BEGIN
7827:
7828: -- Check if API is called in debug mode. If yes, enable debug.

Line 8441: hz_orig_system_ref_pub.get_owner_table_id

8437: and (p_cust_site_use_rec.orig_system_reference is not null and p_cust_site_use_rec.orig_system_reference <>fnd_api.g_miss_char)
8438: and p_create_update_flag = 'U'
8439: THEN
8440:
8441: hz_orig_system_ref_pub.get_owner_table_id
8442: (p_orig_system => p_cust_site_use_rec.orig_system,
8443: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8444: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8445: x_owner_table_id => l_mosr_owner_table_id,

Line 8454: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

8450: THEN
8451: l_validate_flag := 'N';
8452: END IF;
8453:
8454: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
8455: -- x_return_status. Set x_return_status to error, ONLY if there is error.
8456: -- In case of success, leave it to carry over previous value as before this call.
8457: -- Fix for Bug 5498116 (29-AUG-2006)
8458: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 9769: -- hz_orig_system_ref_pub.get_owner_table_id

9765: l_mosr_owner_table_id number;
9766: l_return_status VARCHAR2(1);
9767: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
9768: l_temp_return_status VARCHAR2(10); -- for storing return status from
9769: -- hz_orig_system_ref_pub.get_owner_table_id
9770:
9771: BEGIN
9772:
9773: -- Check if API is called in debug mode. If yes, enable debug.

Line 10293: hz_orig_system_ref_pub.get_owner_table_id

10289: IF (p_cust_account_role_rec.orig_system is not null and p_cust_account_role_rec.orig_system <>fnd_api.g_miss_char)
10290: and (p_cust_account_role_rec.orig_system_reference is not null and p_cust_account_role_rec.orig_system_reference <>fnd_api.g_miss_char)
10291: and p_create_update_flag = 'U'
10292: then
10293: hz_orig_system_ref_pub.get_owner_table_id
10294: (p_orig_system => p_cust_account_role_rec.orig_system,
10295: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
10296: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
10297: x_owner_table_id => l_mosr_owner_table_id,

Line 10306: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

10302: THEN
10303: l_validate_flag := 'N';
10304: END IF;
10305:
10306: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
10307: -- x_return_status. Set x_return_status to error, ONLY if there is error.
10308: -- In case of success, leave it to carry over previous value as before this call.
10309: -- Fix for Bug 5498116 (29-AUG-2006)
10310: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN