DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_BO_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 650: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

646: EXCEPTION
647: WHEN fnd_api.g_exc_error THEN
648: ROLLBACK TO create_cp_pvt;
649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
650: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
651: FND_MSG_PUB.ADD;
652:
653: x_return_status := fnd_api.g_ret_sts_error;
654:

Line 675: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

671:
672: WHEN fnd_api.g_exc_unexpected_error THEN
673: ROLLBACK TO create_cp_pvt;
674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
675: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
676: FND_MSG_PUB.ADD;
677:
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:

Line 700: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

696:
697: WHEN OTHERS THEN
698: ROLLBACK TO create_cp_pvt;
699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
700: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
701: FND_MSG_PUB.ADD;
702:
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:

Line 771: FROM HZ_CUSTOMER_PROFILES cp

767: l_casu_id NUMBER;
768:
769: CURSOR get_ovn(l_ca_id NUMBER, l_casu_id NUMBER) IS
770: SELECT cp.cust_account_profile_id, cp.object_version_number
771: FROM HZ_CUSTOMER_PROFILES cp
772: WHERE cp.cust_account_id = l_ca_id
773: AND nvl(cp.site_use_id, -99) = nvl(l_casu_id, -99);
774:
775: CURSOR get_ovn_by_cpid(l_cp_id NUMBER) IS

Line 777: FROM HZ_CUSTOMER_PROFILES cp

773: AND nvl(cp.site_use_id, -99) = nvl(l_casu_id, -99);
774:
775: CURSOR get_ovn_by_cpid(l_cp_id NUMBER) IS
776: SELECT cp.cust_account_profile_id, cp.object_version_number, cp.cust_account_id, cp.site_use_id
777: FROM HZ_CUSTOMER_PROFILES cp
778: WHERE cp.cust_account_profile_id = l_cp_id;
779: BEGIN
780: -- Standard start of API savepoint
781: SAVEPOINT update_cp_pvt;

Line 864: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK TO update_cp_pvt;
863: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
864: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
865: FND_MSG_PUB.ADD;
866:
867: x_return_status := fnd_api.g_ret_sts_error;
868:

Line 889: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

885:
886: WHEN fnd_api.g_exc_unexpected_error THEN
887: ROLLBACK TO update_cp_pvt;
888: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
889: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
890: FND_MSG_PUB.ADD;
891:
892: x_return_status := fnd_api.g_ret_sts_unexp_error;
893:

Line 914: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');

910:
911: WHEN OTHERS THEN
912: ROLLBACK TO update_cp_pvt;
913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
914: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_CUSTOMER_PROFILES');
915: FND_MSG_PUB.ADD;
916:
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: