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_POPULATE_BOT_PKG dependencies on HZ_CREDIT_RATINGS

Line 2890: -- Procedure name: pop_hz_credit_ratings()

2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END pop_hz_customer_profiles;
2888:
2889: -----------------------------------------------------------------
2890: -- Procedure name: pop_hz_credit_ratings()
2891: -- Purpose: populates BOT for HZ_CREDIT_RATINGS create or update
2892: -- Scope: internal
2893: -- Called From: V2 API
2894: -- Called By: HZ_CREDIT_RATINGS create or update APIs

Line 2891: -- Purpose: populates BOT for HZ_CREDIT_RATINGS create or update

2887: END pop_hz_customer_profiles;
2888:
2889: -----------------------------------------------------------------
2890: -- Procedure name: pop_hz_credit_ratings()
2891: -- Purpose: populates BOT for HZ_CREDIT_RATINGS create or update
2892: -- Scope: internal
2893: -- Called From: V2 API
2894: -- Called By: HZ_CREDIT_RATINGS create or update APIs
2895: -- Input Parameters:

Line 2894: -- Called By: HZ_CREDIT_RATINGS create or update APIs

2890: -- Procedure name: pop_hz_credit_ratings()
2891: -- Purpose: populates BOT for HZ_CREDIT_RATINGS create or update
2892: -- Scope: internal
2893: -- Called From: V2 API
2894: -- Called By: HZ_CREDIT_RATINGS create or update APIs
2895: -- Input Parameters:
2896: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2897: -- p_credit_rating_id IN NUMBER
2898: --

Line 2900: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CREDIT_RATINGS

2896: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2897: -- p_credit_rating_id IN NUMBER
2898: --
2899: -- Note:
2900: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CREDIT_RATINGS
2901: -- This procedure must ensure that the combination is valid before populating BOT
2902: --
2903: -- PARENT BO: ORG :: CHILD BO:
2904: -----------------------------------------------------------------

Line 2905: PROCEDURE pop_hz_credit_ratings(p_operation IN VARCHAR2, p_credit_rating_id IN NUMBER) IS

2901: -- This procedure must ensure that the combination is valid before populating BOT
2902: --
2903: -- PARENT BO: ORG :: CHILD BO:
2904: -----------------------------------------------------------------
2905: PROCEDURE pop_hz_credit_ratings(p_operation IN VARCHAR2, p_credit_rating_id IN NUMBER) IS
2906:
2907: -- cursor statement to select the info from child table
2908: CURSOR C_child IS
2909: SELECT cr.LAST_UPDATE_DATE lud, cr.PARTY_ID parent_id, cr.CREDIT_RATING_ID child_id

Line 2910: FROM HZ_CREDIT_RATINGS cr, HZ_PARTIES p

2906:
2907: -- cursor statement to select the info from child table
2908: CURSOR C_child IS
2909: SELECT cr.LAST_UPDATE_DATE lud, cr.PARTY_ID parent_id, cr.CREDIT_RATING_ID child_id
2910: FROM HZ_CREDIT_RATINGS cr, HZ_PARTIES p
2911: WHERE cr.CREDIT_RATING_ID = P_CREDIT_RATING_ID
2912: AND cr.party_id = p.party_id
2913: AND p.party_type = 'ORGANIZATION';
2914:

Line 2916: l_debug_prefix VARCHAR2(40) := 'pop_hz_credit_ratings';

2912: AND cr.party_id = p.party_id
2913: AND p.party_type = 'ORGANIZATION';
2914:
2915: -- local variables
2916: l_debug_prefix VARCHAR2(40) := 'pop_hz_credit_ratings';
2917: l_parent_id NUMBER; -- used to store parent entity identifier
2918: l_child_id NUMBER; -- used to store HZ_CREDIT_RATINGS identifier
2919: l_lud DATE; -- used to store the child last update date
2920: l_child_rec_exists_no NUMBER;

Line 2918: l_child_id NUMBER; -- used to store HZ_CREDIT_RATINGS identifier

2914:
2915: -- local variables
2916: l_debug_prefix VARCHAR2(40) := 'pop_hz_credit_ratings';
2917: l_parent_id NUMBER; -- used to store parent entity identifier
2918: l_child_id NUMBER; -- used to store HZ_CREDIT_RATINGS identifier
2919: l_lud DATE; -- used to store the child last update date
2920: l_child_rec_exists_no NUMBER;
2921: l_cen VARCHAR2(30) := 'HZ_CREDIT_RATINGS';
2922: BEGIN

Line 2921: l_cen VARCHAR2(30) := 'HZ_CREDIT_RATINGS';

2917: l_parent_id NUMBER; -- used to store parent entity identifier
2918: l_child_id NUMBER; -- used to store HZ_CREDIT_RATINGS identifier
2919: l_lud DATE; -- used to store the child last update date
2920: l_child_rec_exists_no NUMBER;
2921: l_cen VARCHAR2(30) := 'HZ_CREDIT_RATINGS';
2922: BEGIN
2923: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_credit_ratings+',
2924: p_prefix=>l_debug_prefix,
2925: p_msg_level=>fnd_log.level_procedure);

Line 2923: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_credit_ratings+',

2919: l_lud DATE; -- used to store the child last update date
2920: l_child_rec_exists_no NUMBER;
2921: l_cen VARCHAR2(30) := 'HZ_CREDIT_RATINGS';
2922: BEGIN
2923: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_credit_ratings+',
2924: p_prefix=>l_debug_prefix,
2925: p_msg_level=>fnd_log.level_procedure);
2926:
2927: -- validate p_operation

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

2927: -- validate p_operation
2928: IF p_operation IN ('I','U') THEN
2929: NULL;
2930: ELSE
2931: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_credit_ratings',
2932: p_prefix=>l_debug_prefix,
2933: p_msg_level=>fnd_log.level_procedure);
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;

Line 2965: 'N', p_operation, l_child_id, 'HZ_CREDIT_RATINGS', NULL,

2961: INSERT INTO HZ_BUS_OBJ_TRACKING
2962: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2963: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2964: ) VALUES (
2965: 'N', p_operation, l_child_id, 'HZ_CREDIT_RATINGS', NULL,
2966: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
2967:
2968: pop_parent_record(p_child_id => l_parent_id,
2969: p_lud => l_lud,

Line 2978: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_credit_ratings-',

2974: p_pbo_code => NULL);
2975: END ; -- anonymous block end
2976: END LOOP;
2977:
2978: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_credit_ratings-',
2979: p_prefix=>l_debug_prefix,
2980: p_msg_level=>fnd_log.level_procedure);
2981: EXCEPTION
2982: WHEN OTHERS THEN

Line 2987: END pop_hz_credit_ratings;

2983: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2984: p_prefix=>l_debug_prefix,
2985: p_msg_level=>fnd_log.level_procedure);
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: END pop_hz_credit_ratings;
2988:
2989: -----------------------------------------------------------------
2990: -- Procedure name: pop_hz_contact_preferences()
2991: -- Purpose: populates BOT for HZ_CONTACT_PREFERENCES create or update