APPS.HZ_POPULATE_BOT_PKG dependencies on RA_CUST_RECEIPT_METHODS

Line 3894: -- Procedure name: pop_ra_cust_receipt_methods()

3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3891: END pop_hz_extensibility;
3892:
3893: -----------------------------------------------------------------
3894: -- Procedure name: pop_ra_cust_receipt_methods()
3895: -- Purpose: populates BOT for RA_CUST_RECEIPT_METHODS create or update
3896: -- Scope: internal
3897: -- Called From: V2 API
3898: -- Called By: HZ_PAYMENT_METHOD_PUB create or update APIs

Line 3895: -- Purpose: populates BOT for RA_CUST_RECEIPT_METHODS create or update

3891: END pop_hz_extensibility;
3892:
3893: -----------------------------------------------------------------
3894: -- Procedure name: pop_ra_cust_receipt_methods()
3895: -- Purpose: populates BOT for RA_CUST_RECEIPT_METHODS create or update
3896: -- Scope: internal
3897: -- Called From: V2 API
3898: -- Called By: HZ_PAYMENT_METHOD_PUB create or update APIs
3899: -- Input Parameters:

Line 3904: -- Following are the allowed PARENT and CHILD BO combinations for RA_CUST_RECEIPT_METHODS

3900: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3901: -- p_cust_receipt_method_id IN NUMBER
3902: --
3903: -- Note:
3904: -- Following are the allowed PARENT and CHILD BO combinations for RA_CUST_RECEIPT_METHODS
3905: -- This procedure must ensure that the combination is valid before populating BOT
3906: --
3907: -- PARENT BO: CUST_ACCT_SITE_USE :: CHILD BO:
3908: -- PARENT BO: CUST_ACCT :: CHILD BO:

Line 3910: PROCEDURE pop_ra_cust_receipt_methods(p_operation IN VARCHAR2, p_cust_receipt_method_id IN NUMBER) IS

3906: --
3907: -- PARENT BO: CUST_ACCT_SITE_USE :: CHILD BO:
3908: -- PARENT BO: CUST_ACCT :: CHILD BO:
3909: -----------------------------------------------------------------
3910: PROCEDURE pop_ra_cust_receipt_methods(p_operation IN VARCHAR2, p_cust_receipt_method_id IN NUMBER) IS
3911:
3912: -- cursor statement to select the info from child table
3913: CURSOR C_child IS
3914: SELECT rcrm.last_update_date lud, rcrm.cust_receipt_method_id child_id,

Line 3921: FROM RA_CUST_RECEIPT_METHODS rcrm, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p

3917: decode(rcrm.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo_code,
3918: decode(rcrm.site_use_id, NULL, p.party_id, rcrm.customer_id) grand_parent_id,
3919: decode(rcrm.site_use_id, NULL, 'HZ_PARTIES', 'HZ_CUST_ACCOUNTS') grand_parent_tbl_name,
3920: decode(rcrm.site_use_id, NULL, decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL), 'CUST_ACCT') grand_parent_bo_code
3921: FROM RA_CUST_RECEIPT_METHODS rcrm, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
3922: WHERE rcrm.cust_receipt_method_id = p_cust_receipt_method_id
3923: AND rcrm.customer_id = ca.cust_account_id
3924: AND ca.party_id = p.party_id
3925: AND p.party_type in ('ORGANIZATION', 'PERSON')

Line 3929: l_debug_prefix VARCHAR2(40) := 'pop_ra_cust_receipt_methods';

3925: AND p.party_type in ('ORGANIZATION', 'PERSON')
3926: AND rcrm.customer_id > 0;
3927:
3928: -- local variables
3929: l_debug_prefix VARCHAR2(40) := 'pop_ra_cust_receipt_methods';
3930: l_parent_id NUMBER; -- used to store parent entity identifier
3931: l_bo_code VARCHAR2(30); -- used to store BO Code
3932: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier
3933: l_lud DATE; -- used to store the child last update date

Line 3940: l_cen VARCHAR2(30) := 'RA_CUST_RECEIPT_METHODS';

3936: l_parent_tbl_name VARCHAR2(30);
3937: l_g_parent_id NUMBER;
3938: l_g_parent_tbl_name VARCHAR2(30);
3939: l_g_parent_bo_code VARCHAR2(30);
3940: l_cen VARCHAR2(30) := 'RA_CUST_RECEIPT_METHODS';
3941: BEGIN
3942: hz_utility_v2pub.DEBUG(p_message=>'pop_ra_cust_receipt_methods+',
3943: p_prefix=>l_debug_prefix,
3944: p_msg_level=>fnd_log.level_procedure);

Line 3942: hz_utility_v2pub.DEBUG(p_message=>'pop_ra_cust_receipt_methods+',

3938: l_g_parent_tbl_name VARCHAR2(30);
3939: l_g_parent_bo_code VARCHAR2(30);
3940: l_cen VARCHAR2(30) := 'RA_CUST_RECEIPT_METHODS';
3941: BEGIN
3942: hz_utility_v2pub.DEBUG(p_message=>'pop_ra_cust_receipt_methods+',
3943: p_prefix=>l_debug_prefix,
3944: p_msg_level=>fnd_log.level_procedure);
3945:
3946: -- validate p_operation

Line 3950: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_ra_cust_receipt_methods',

3946: -- validate p_operation
3947: IF p_operation IN ('I','U') THEN
3948: NULL;
3949: ELSE
3950: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_ra_cust_receipt_methods',
3951: p_prefix=>l_debug_prefix,
3952: p_msg_level=>fnd_log.level_procedure);
3953: RAISE FND_API.G_EXC_ERROR;
3954: END IF;

Line 3988: 'N', p_operation, l_child_id, 'RA_CUST_RECEIPT_METHODS', NULL,

3984: INSERT INTO HZ_BUS_OBJ_TRACKING
3985: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3986: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3987: ) VALUES (
3988: 'N', p_operation, l_child_id, 'RA_CUST_RECEIPT_METHODS', NULL,
3989: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_parent_bo_code);
3990:
3991: pop_parent_record(p_child_id => l_parent_id,
3992: p_lud => l_lud,

Line 4001: hz_utility_v2pub.DEBUG(p_message=>'pop_ra_cust_receipt_methods-',

3997: p_pbo_code => l_g_parent_bo_code);
3998: END ; -- anonymous block end
3999: END LOOP;
4000:
4001: hz_utility_v2pub.DEBUG(p_message=>'pop_ra_cust_receipt_methods-',
4002: p_prefix=>l_debug_prefix,
4003: p_msg_level=>fnd_log.level_procedure);
4004: EXCEPTION
4005: WHEN OTHERS THEN

Line 4010: END pop_ra_cust_receipt_methods;

4006: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
4007: p_prefix=>l_debug_prefix,
4008: p_msg_level=>fnd_log.level_procedure);
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: END pop_ra_cust_receipt_methods;
4011:
4012: FUNCTION is_valid_ps(
4013: p_party_site_id IN NUMBER
4014: ) RETURN BOOLEAN IS