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_CONTACT_PREFERENCES

Line 2990: -- Procedure name: pop_hz_contact_preferences()

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
2992: -- Scope: internal
2993: -- Called From: V2 API
2994: -- Called By: HZ_CONTACT_PREFERENCES create or update APIs

Line 2991: -- Purpose: populates BOT for HZ_CONTACT_PREFERENCES create or update

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
2992: -- Scope: internal
2993: -- Called From: V2 API
2994: -- Called By: HZ_CONTACT_PREFERENCES create or update APIs
2995: -- Input Parameters:

Line 2994: -- Called By: HZ_CONTACT_PREFERENCES create or update APIs

2990: -- Procedure name: pop_hz_contact_preferences()
2991: -- Purpose: populates BOT for HZ_CONTACT_PREFERENCES create or update
2992: -- Scope: internal
2993: -- Called From: V2 API
2994: -- Called By: HZ_CONTACT_PREFERENCES create or update APIs
2995: -- Input Parameters:
2996: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2997: -- p_contact_preference_id IN NUMBER
2998: --

Line 3000: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CONTACT_PREFERENCES

2996: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
2997: -- p_contact_preference_id IN NUMBER
2998: --
2999: -- Note:
3000: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CONTACT_PREFERENCES
3001: -- This procedure must ensure that the combination is valid before populating BOT
3002: --
3003: -- PARENT BO: ORG :: CHILD BO:
3004: -- PARENT BO: PERSON :: CHILD BO:

Line 3015: PROCEDURE pop_hz_contact_preferences(p_operation IN VARCHAR2, p_contact_preference_id IN NUMBER) IS

3011: -- PARENT BO: EDI :: CHILD BO:
3012: -- PARENT BO: EFT :: CHILD BO:
3013: -- PARENT BO: SMS :: CHILD BO:
3014: -----------------------------------------------------------------
3015: PROCEDURE pop_hz_contact_preferences(p_operation IN VARCHAR2, p_contact_preference_id IN NUMBER) IS
3016:
3017: CURSOR c_child IS
3018: SELECT cpp.LAST_UPDATE_DATE lud, cpp.CONTACT_LEVEL_TABLE_ID parent_id,
3019: cpp.CONTACT_LEVEL_TABLE parent_tbl_name, cpp.CONTACT_PREFERENCE_ID child_id

Line 3020: FROM HZ_CONTACT_PREFERENCES cpp

3016:
3017: CURSOR c_child IS
3018: SELECT cpp.LAST_UPDATE_DATE lud, cpp.CONTACT_LEVEL_TABLE_ID parent_id,
3019: cpp.CONTACT_LEVEL_TABLE parent_tbl_name, cpp.CONTACT_PREFERENCE_ID child_id
3020: FROM HZ_CONTACT_PREFERENCES cpp
3021: WHERE cpp.CONTACT_PREFERENCE_ID = P_CONTACT_PREFERENCE_ID;
3022:
3023: CURSOR c_cp(p_parent_id NUMBER) IS
3024: SELECT decode(contact_point_type, 'PHONE', 'PHONE', 'EMAIL', 'EMAIL', 'WEB', 'WEB', 'EFT', 'EFT', 'SMS', 'SMS', 'TLX', 'TLX', 'EDI', 'EDI', NULL), owner_table_name, owner_table_id

Line 3046: l_debug_prefix VARCHAR2(40) := 'pop_hz_contact_preferences';

3042: AND r.party_id = p_parent_id
3043: AND rownum = 1;
3044:
3045: -- local variables
3046: l_debug_prefix VARCHAR2(40) := 'pop_hz_contact_preferences';
3047: l_parent_id NUMBER; -- used to store parent entity identifier
3048: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
3049: l_pty_bo_code VARCHAR2(30);
3050: l_pty_tbl_name VARCHAR2(30);

Line 3053: l_child_id NUMBER; -- used to store HZ_CONTACT_PREFERENCES identifier

3049: l_pty_bo_code VARCHAR2(30);
3050: l_pty_tbl_name VARCHAR2(30);
3051: l_bo_code VARCHAR2(30); -- used to store BO Code
3052: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
3053: l_child_id NUMBER; -- used to store HZ_CONTACT_PREFERENCES identifier
3054: l_lud DATE; -- used to store the child last update date
3055: l_child_rec_exists_no NUMBER;
3056: l_cp_owner_table VARCHAR2(30);
3057: l_cp_owner_id NUMBER;

Line 3059: l_cen VARCHAR2(30) := 'HZ_CONTACT_PREFERENCES';

3055: l_child_rec_exists_no NUMBER;
3056: l_cp_owner_table VARCHAR2(30);
3057: l_cp_owner_id NUMBER;
3058: l_oc_id NUMBER;
3059: l_cen VARCHAR2(30) := 'HZ_CONTACT_PREFERENCES';
3060: BEGIN
3061: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_preferences+',
3062: p_prefix=>l_debug_prefix,
3063: p_msg_level=>fnd_log.level_procedure);

Line 3061: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_preferences+',

3057: l_cp_owner_id NUMBER;
3058: l_oc_id NUMBER;
3059: l_cen VARCHAR2(30) := 'HZ_CONTACT_PREFERENCES';
3060: BEGIN
3061: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_preferences+',
3062: p_prefix=>l_debug_prefix,
3063: p_msg_level=>fnd_log.level_procedure);
3064:
3065: -- validate p_operation

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

3065: -- validate p_operation
3066: IF p_operation IN ('I','U') THEN
3067: NULL;
3068: ELSE
3069: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_contact_preferences',
3070: p_prefix=>l_debug_prefix,
3071: p_msg_level=>fnd_log.level_procedure);
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;

Line 3148: 'N', p_operation, l_child_id, 'HZ_CONTACT_PREFERENCES', NULL,

3144: INSERT INTO HZ_BUS_OBJ_TRACKING
3145: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3146: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3147: ) VALUES (
3148: 'N', p_operation, l_child_id, 'HZ_CONTACT_PREFERENCES', NULL,
3149: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
3150: END ; -- anonymous block end
3151: END LOOP;
3152:

Line 3153: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_preferences-',

3149: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
3150: END ; -- anonymous block end
3151: END LOOP;
3152:
3153: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_contact_preferences-',
3154: p_prefix=>l_debug_prefix,
3155: p_msg_level=>fnd_log.level_procedure);
3156: EXCEPTION
3157: WHEN OTHERS THEN

Line 3162: END pop_hz_contact_preferences;

3158: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3159: p_prefix=>l_debug_prefix,
3160: p_msg_level=>fnd_log.level_procedure);
3161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3162: END pop_hz_contact_preferences;
3163:
3164: -----------------------------------------------------------------
3165: -- Procedure name: pop_hz_contact_points()
3166: -- Purpose: populates BOT for HZ_CONTACT_POINTS create or update