APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 470: -- hz_orig_system_ref_pub.get_owner_table_id

466: l_validate_flag varchar2(1) := 'Y';
467: l_mosr_owner_table_id number;
468:
469: l_temp_return_status VARCHAR2(10); -- for storing return status from
470: -- hz_orig_system_ref_pub.get_owner_table_id
471:
472: BEGIN
473:
474: -- Check if API is called in debug mode. If yes, enable debug.

Line 818: hz_orig_system_ref_pub.get_owner_table_id

814: IF (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
815: and (p_cust_account_rec.orig_system_reference is not null and p_cust_account_rec.orig_system_reference <>fnd_api.g_miss_char)
816: and p_create_update_flag = 'U'
817: then
818: hz_orig_system_ref_pub.get_owner_table_id
819: (p_orig_system => p_cust_account_rec.orig_system,
820: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
821: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
822: x_owner_table_id => l_mosr_owner_table_id,

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

827: THEN
828: l_validate_flag := 'N';
829: END IF;
830:
831: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
832: -- x_return_status. Set x_return_status to error, ONLY if there is error.
833: -- In case of success, leave it to carry over previous value as before this call.
834: -- Fix for Bug 5498116 (29-AUG-2006)
835: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 6733: -- hz_orig_system_ref_pub.get_owner_table_id

6729: l_validate_flag varchar2(1) := 'Y';
6730: l_mosr_owner_table_id number;
6731:
6732: l_temp_return_status VARCHAR2(10); -- for storing return status from
6733: -- hz_orig_system_ref_pub.get_owner_table_id
6734:
6735: BEGIN
6736:
6737: -- Check if API is called in debug mode. If yes, enable debug.

Line 7082: hz_orig_system_ref_pub.get_owner_table_id

7078: IF (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
7079: 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)
7080: and p_create_update_flag = 'U'
7081: then
7082: hz_orig_system_ref_pub.get_owner_table_id
7083: (p_orig_system => p_cust_acct_site_rec.orig_system,
7084: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
7085: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
7086: x_owner_table_id => l_mosr_owner_table_id,

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

7091: THEN
7092: l_validate_flag := 'N';
7093: END IF;
7094:
7095: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
7096: -- x_return_status. Set x_return_status to error, ONLY if there is error.
7097: -- In case of success, leave it to carry over previous value as before this call.
7098: -- Fix for Bug 5498116 (29-AUG-2006)
7099: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 7549: -- hz_orig_system_ref_pub.get_owner_table_id

7545: l_coa_id NUMBER;
7546: l_exist_flag VARCHAR2(1);
7547:
7548: l_temp_return_status VARCHAR2(10); -- for storing return status from
7549: -- hz_orig_system_ref_pub.get_owner_table_id
7550:
7551: BEGIN
7552:
7553: -- Check if API is called in debug mode. If yes, enable debug.

Line 8158: hz_orig_system_ref_pub.get_owner_table_id

8154: 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)
8155: and p_create_update_flag = 'U'
8156: THEN
8157:
8158: hz_orig_system_ref_pub.get_owner_table_id
8159: (p_orig_system => p_cust_site_use_rec.orig_system,
8160: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8161: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8162: x_owner_table_id => l_mosr_owner_table_id,

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

8167: THEN
8168: l_validate_flag := 'N';
8169: END IF;
8170:
8171: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
8172: -- x_return_status. Set x_return_status to error, ONLY if there is error.
8173: -- In case of success, leave it to carry over previous value as before this call.
8174: -- Fix for Bug 5498116 (29-AUG-2006)
8175: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 9486: -- hz_orig_system_ref_pub.get_owner_table_id

9482: l_mosr_owner_table_id number;
9483: l_return_status VARCHAR2(1);
9484: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
9485: l_temp_return_status VARCHAR2(10); -- for storing return status from
9486: -- hz_orig_system_ref_pub.get_owner_table_id
9487:
9488: BEGIN
9489:
9490: -- Check if API is called in debug mode. If yes, enable debug.

Line 10010: hz_orig_system_ref_pub.get_owner_table_id

10006: IF (p_cust_account_role_rec.orig_system is not null and p_cust_account_role_rec.orig_system <>fnd_api.g_miss_char)
10007: 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)
10008: and p_create_update_flag = 'U'
10009: then
10010: hz_orig_system_ref_pub.get_owner_table_id
10011: (p_orig_system => p_cust_account_role_rec.orig_system,
10012: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
10013: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
10014: x_owner_table_id => l_mosr_owner_table_id,

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

10019: THEN
10020: l_validate_flag := 'N';
10021: END IF;
10022:
10023: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
10024: -- x_return_status. Set x_return_status to error, ONLY if there is error.
10025: -- In case of success, leave it to carry over previous value as before this call.
10026: -- Fix for Bug 5498116 (29-AUG-2006)
10027: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN