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_CONTACT_PREFERENCE_VALIDATE dependencies on FND_API

Line 70: IF ( p_column_value <> FND_API.G_MISS_DATE OR

66: BEGIN
67:
68: IF p_column_value IS NOT NULL THEN
69: IF p_restricted = 'Y' THEN
70: IF ( p_column_value <> FND_API.G_MISS_DATE OR
71: p_old_column_value IS NOT NULL ) AND
72: ( p_old_column_value IS NULL OR
73: p_column_value <> p_old_column_value )
74: THEN

Line 79: p_old_column_value <> FND_API.G_MISS_DATE)

75: l_error := TRUE;
76: END IF;
77: ELSE
78: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053
79: p_old_column_value <> FND_API.G_MISS_DATE)
80: AND
81: ( p_column_value = FND_API.G_MISS_DATE OR
82: p_column_value <> p_old_column_value )
83: THEN

Line 81: ( p_column_value = FND_API.G_MISS_DATE OR

77: ELSE
78: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053
79: p_old_column_value <> FND_API.G_MISS_DATE)
80: AND
81: ( p_column_value = FND_API.G_MISS_DATE OR
82: p_column_value <> p_old_column_value )
83: THEN
84: l_error := TRUE;
85: END IF;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89: IF l_error THEN
90: FND_MESSAGE.SET_NAME( 'AR', 'HZ_NONUPDATEABLE_PREF_DATE' );
91: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: END IF;
95:
96: END preference_date_nonupdateable;
97:

Line 112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),

108: CONTACT_LEVEL_TABLE,
109: CONTACT_LEVEL_TABLE_ID,
110: CONTACT_TYPE,
111: DECODE ( p_update_field_rec.preference_code, null, PREFERENCE_CODE, p_update_field_rec.preference_code),
112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),
113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),

Line 113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),

109: CONTACT_LEVEL_TABLE_ID,
110: CONTACT_TYPE,
111: DECODE ( p_update_field_rec.preference_code, null, PREFERENCE_CODE, p_update_field_rec.preference_code),
112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),
113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),

Line 114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),

110: CONTACT_TYPE,
111: DECODE ( p_update_field_rec.preference_code, null, PREFERENCE_CODE, p_update_field_rec.preference_code),
112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),
113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),

Line 115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),

111: DECODE ( p_update_field_rec.preference_code, null, PREFERENCE_CODE, p_update_field_rec.preference_code),
112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),
113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),

Line 116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),

112: DECODE( p_update_field_rec.preference_topic_type, NULL, PREFERENCE_TOPIC_TYPE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.PREFERENCE_TOPIC_TYPE ),
113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),

Line 117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),

113: DECODE( p_update_field_rec.preference_topic_type_id, NULL, PREFERENCE_TOPIC_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_topic_type_id ),
114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),

Line 118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),

114: DECODE( p_update_field_rec.preference_topic_type_code, NULL, PREFERENCE_TOPIC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.preference_topic_type_code ),
115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),

Line 119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),

115: DECODE( p_update_field_rec.preference_start_date, NULL, PREFERENCE_START_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_start_date ),
116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),

Line 120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),

116: DECODE( p_update_field_rec.preference_end_date, NULL, PREFERENCE_END_DATE, FND_API.G_MISS_DATE, NULL, p_update_field_rec.preference_end_date ),
117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),
124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),

Line 121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),

117: DECODE( p_update_field_rec.preference_start_time_hr, NULL, PREFERENCE_START_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_hr ),
118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),
124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),
125: DECODE( p_update_field_rec.status, NULL, STATUS, p_update_field_rec.status )

Line 122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),

118: DECODE( p_update_field_rec.preference_end_time_hr, NULL, PREFERENCE_END_TIME_HR, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_hr ),
119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),
124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),
125: DECODE( p_update_field_rec.status, NULL, STATUS, p_update_field_rec.status )
126:

Line 123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),

119: DECODE( p_update_field_rec.preference_start_time_mi, NULL, PREFERENCE_START_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_start_time_mi ),
120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),
124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),
125: DECODE( p_update_field_rec.status, NULL, STATUS, p_update_field_rec.status )
126:
127: INTO

Line 124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),

120: DECODE( p_update_field_rec.preference_end_time_mi, NULL, PREFERENCE_END_TIME_MI, FND_API.G_MISS_NUM, NULL, p_update_field_rec.preference_end_time_mi ),
121: DECODE( p_update_field_rec.max_no_of_interactions, NULL, MAX_NO_OF_INTERACTIONS, FND_API.G_MISS_NUM, NULL, p_update_field_rec.max_no_of_interactions),
122: DECODE( p_update_field_rec.max_no_of_interact_uom_code, NULL, MAX_NO_OF_INTERACT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.max_no_of_interact_uom_code ),
123: DECODE( p_update_field_rec.requested_by, NULL, REQUESTED_BY, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.requested_by ),
124: DECODE( p_update_field_rec.reason_code, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_update_field_rec.REASON_CODE ),
125: DECODE( p_update_field_rec.status, NULL, STATUS, p_update_field_rec.status )
126:
127: INTO
128: x_updated_cp_rec.CONTACT_PREFERENCE_ID,

Line 182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;

178: l_created_by_module HZ_CONTACT_PREFERENCES.created_by_module%TYPE;
179: l_application_id NUMBER;
180: l_dummy VARCHAR2(1);
181: l_tag FND_LOOKUP_VALUES.tag%TYPE;
182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;
183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;

Line 207: p_contact_preference_rec.contact_preference_id <> FND_API.G_MISS_NUM

203:
204: IF p_create_update_flag = 'C' THEN
205: --If primary key value is passed, check for uniqueness.
206: IF p_contact_preference_rec.contact_preference_id IS NOT NULL AND
207: p_contact_preference_rec.contact_preference_id <> FND_API.G_MISS_NUM
208: THEN
209: BEGIN
210: SELECT 'Y' INTO l_dummy
211: FROM HZ_CONTACT_PREFERENCES

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213:
214: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'contact_preference_id');
216: FND_MSG_PUB.ADD;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: NULL;
221: END;

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: FND_MESSAGE.SET_TOKEN( 'FK', 'party_id' );
366: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
367: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );
368: FND_MSG_PUB.ADD;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: END;
371: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES' THEN
372: BEGIN
373: SELECT 'Y' INTO l_dummy

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: FND_MESSAGE.SET_TOKEN( 'FK', 'party_site_id' );
380: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
381: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );
382: FND_MSG_PUB.ADD;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: END;
385: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN
386: BEGIN
387: SELECT 'Y' INTO l_dummy

Line 397: x_return_status := FND_API.G_RET_STS_ERROR;

393: FND_MESSAGE.SET_TOKEN( 'FK', 'contact_point_id' );
394: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
395: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_points' );
396: FND_MSG_PUB.ADD;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: END;
399: END IF;
400: END IF;
401:

Line 473: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

469:
470: -- if contact_level_table = 'HZ_CONTACT_POINTS' ,
471: -- p_contact_preference_rec.contact_type should match with contact_point_type
472:
473: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
474:
475: IF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN
476: select contact_point_type,
477: decode(contact_point_type, 'PHONE', 'CALL', 'FAX', 'FAX',

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_CONTACT_LEVEL_TABLE' );
486: FND_MESSAGE.SET_TOKEN( 'CONTACT_TYPE', 'MAIL/VISIT' );
487: FND_MESSAGE.SET_TOKEN( 'CONTACT_LEVEL_TABLE', 'hz_contact_points' );
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490:
491: ELSIF p_contact_preference_rec.contact_type <> l_correct_contact_type AND
492: not ( p_contact_preference_rec.contact_type in ('CALL' , 'FAX') AND l_correct_contact_type in ( 'FAX', 'CALL')) THEN
493: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_CONTACT_TYPE' );

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494: FND_MESSAGE.SET_TOKEN( 'INCORRECT_CONTACT_TYPE', p_contact_preference_rec.contact_type );
495: FND_MESSAGE.SET_TOKEN( 'CORRECT_CONTACT_TYPE', l_correct_contact_type );
496: FND_MESSAGE.SET_TOKEN( 'CONTACT_POINT_TYPE', l_contact_point_type);
497: FND_MSG_PUB.ADD;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: END IF;
500: END IF;
501: END IF;
502:

Line 531: p_contact_preference_rec.preference_code <> FND_API.G_MISS_CHAR AND

527: END IF;
528:
529: -- preference_code is lookup code in lookup type PREFERENCE_CODE
530: IF p_contact_preference_rec.preference_code IS NOT NULL AND
531: p_contact_preference_rec.preference_code <> FND_API.G_MISS_CHAR AND
532: ( p_create_update_flag = 'C' OR
533: ( p_create_update_flag = 'U' AND
534: p_contact_preference_rec.preference_code <> NVL (l_preference_code, FND_API.G_MISS_CHAR))) THEN
535:

Line 534: p_contact_preference_rec.preference_code <> NVL (l_preference_code, FND_API.G_MISS_CHAR))) THEN

530: IF p_contact_preference_rec.preference_code IS NOT NULL AND
531: p_contact_preference_rec.preference_code <> FND_API.G_MISS_CHAR AND
532: ( p_create_update_flag = 'C' OR
533: ( p_create_update_flag = 'U' AND
534: p_contact_preference_rec.preference_code <> NVL (l_preference_code, FND_API.G_MISS_CHAR))) THEN
535:
536: HZ_UTILITY_V2PUB.validate_lookup (
537: p_column => 'preference_code',
538: p_lookup_type => 'PREFERENCE_CODE',

Line 557: p_contact_preference_rec.preference_topic_type <> FND_API.G_MISS_CHAR AND

553: ----------------------------------------------
554:
555: -- preference_topic_type is lookup code in lookup type PREFERENCE_TOPIC_TYPE
556: IF p_contact_preference_rec.preference_topic_type IS NOT NULL AND
557: p_contact_preference_rec.preference_topic_type <> FND_API.G_MISS_CHAR AND
558: ( p_create_update_flag = 'C' OR
559: ( p_create_update_flag = 'U' AND
560: p_contact_preference_rec.preference_topic_type <> NVL (l_preference_topic_type, FND_API.G_MISS_CHAR))) THEN
561:

Line 560: p_contact_preference_rec.preference_topic_type <> NVL (l_preference_topic_type, FND_API.G_MISS_CHAR))) THEN

556: IF p_contact_preference_rec.preference_topic_type IS NOT NULL AND
557: p_contact_preference_rec.preference_topic_type <> FND_API.G_MISS_CHAR AND
558: ( p_create_update_flag = 'C' OR
559: ( p_create_update_flag = 'U' AND
560: p_contact_preference_rec.preference_topic_type <> NVL (l_preference_topic_type, FND_API.G_MISS_CHAR))) THEN
561:
562: HZ_UTILITY_V2PUB.validate_lookup (
563: p_column => 'preference_topic_type',
564: p_lookup_type => 'PREFERENCE_TOPIC_TYPE',

Line 579: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

575: ----------------------------------------------
576: -- validate preference_topic_type_id
577: ----------------------------------------------
578:
579: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
580:
581:
582: SELECT TAG
583: INTO l_tag

Line 589: END_DATE_ACTIVE = FND_API.G_MISS_DATE OR

585: WHERE
586: LANGUAGE = userenv('LANG') AND
587: START_DATE_ACTIVE < sysdate AND
588: ( END_DATE_ACTIVE is null OR
589: END_DATE_ACTIVE = FND_API.G_MISS_DATE OR
590: END_DATE_ACTIVE > sysdate) AND
591: LOOKUP_TYPE = 'PREFERENCE_TOPIC_TYPE' AND
592: LOOKUP_CODE = p_contact_preference_rec.preference_topic_type;
593:

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: FND_MESSAGE.SET_TOKEN( 'FK', 'source_code_id');
619: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
620: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ams_source_codes' );
621: FND_MSG_PUB.ADD;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END;
624: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_TYPES_B' THEN
625: BEGIN
626: SELECT 'Y' INTO l_dummy

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_type_id');
633: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
634: FND_MESSAGE.SET_TOKEN( 'TABLE', 'as_interest_types_b' );
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: END;
638: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_CODES_B' THEN
639: BEGIN
640: SELECT 'Y' INTO l_dummy

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_code_id' );
647: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
648: FND_MESSAGE.SET_TOKEN( 'TABLE', 'as_interest_codes_b' );
649: FND_MSG_PUB.ADD;
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: END;
652: /* Bug 3301160, data privacy support */
653: /* Removed the above as the design will change */
654: END IF;

Line 688: p_contact_preference_rec.preference_topic_type_code <> FND_API.G_MISS_CHAR AND

684:
685:
686: -- preference_topic_type_code is lookup code in lookup type
687: IF p_contact_preference_rec.preference_topic_type_code IS NOT NULL AND
688: p_contact_preference_rec.preference_topic_type_code <> FND_API.G_MISS_CHAR AND
689: ( p_create_update_flag = 'C' OR
690: ( p_create_update_flag = 'U' AND
691: p_contact_preference_rec.preference_topic_type_code <> NVL (l_preference_topic_type_code, FND_API.G_MISS_CHAR))) THEN
692:

Line 691: p_contact_preference_rec.preference_topic_type_code <> NVL (l_preference_topic_type_code, FND_API.G_MISS_CHAR))) THEN

687: IF p_contact_preference_rec.preference_topic_type_code IS NOT NULL AND
688: p_contact_preference_rec.preference_topic_type_code <> FND_API.G_MISS_CHAR AND
689: ( p_create_update_flag = 'C' OR
690: ( p_create_update_flag = 'U' AND
691: p_contact_preference_rec.preference_topic_type_code <> NVL (l_preference_topic_type_code, FND_API.G_MISS_CHAR))) THEN
692:
693: HZ_UTILITY_V2PUB.validate_lookup (
694: p_column => 'preference_topic_type_code',
695: p_lookup_type => p_contact_preference_rec.preference_topic_type,

Line 756: p_contact_preference_rec.preference_end_date <> FND_API.G_MISS_DATE AND

752: /* Requirement change, to allow preference_end_date less than sysdate
753: -- preference_end_date should not be less than sysdate when creating a new record
754: IF p_create_update_flag = 'C' AND
755: p_contact_preference_rec.preference_end_date is not null AND
756: p_contact_preference_rec.preference_end_date <> FND_API.G_MISS_DATE AND
757: trunc(p_contact_preference_rec.preference_end_date) < trunc(sysdate) THEN
758: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_END_DATE' );
759: FND_MESSAGE.SET_TOKEN( 'PREFERENCE_END_DATE', to_char(p_contact_preference_rec.preference_end_date) );
760: FND_MSG_PUB.ADD;

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757: trunc(p_contact_preference_rec.preference_end_date) < trunc(sysdate) THEN
758: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_END_DATE' );
759: FND_MESSAGE.SET_TOKEN( 'PREFERENCE_END_DATE', to_char(p_contact_preference_rec.preference_end_date) );
760: FND_MSG_PUB.ADD;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: END IF;
763:
764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
765: hz_utility_v2pub.debug(p_message=>'preference_end_date should not be less than sysdate when creating a new record' ||

Line 830: p_contact_preference_rec.preference_start_time_hr <> FND_API.G_MISS_NUM THEN

826:
827: -- preference_end_time_hr should be greater than preference_start_time_hr, and both should between 0-23
828:
829: IF p_contact_preference_rec.preference_start_time_hr is not null AND
830: p_contact_preference_rec.preference_start_time_hr <> FND_API.G_MISS_NUM THEN
831: IF p_contact_preference_rec.preference_start_time_hr < 0 OR
832: p_contact_preference_rec.preference_start_time_hr > 23 THEN
833: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
834: FND_MSG_PUB.ADD;

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

831: IF p_contact_preference_rec.preference_start_time_hr < 0 OR
832: p_contact_preference_rec.preference_start_time_hr > 23 THEN
833: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
834: FND_MSG_PUB.ADD;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: l_time_comparison := FND_API.G_FALSE;
837: END IF;
838: ELSE
839: l_time_comparison := FND_API.G_FALSE;

Line 836: l_time_comparison := FND_API.G_FALSE;

832: p_contact_preference_rec.preference_start_time_hr > 23 THEN
833: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
834: FND_MSG_PUB.ADD;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: l_time_comparison := FND_API.G_FALSE;
837: END IF;
838: ELSE
839: l_time_comparison := FND_API.G_FALSE;
840: END IF;

Line 839: l_time_comparison := FND_API.G_FALSE;

835: x_return_status := FND_API.G_RET_STS_ERROR;
836: l_time_comparison := FND_API.G_FALSE;
837: END IF;
838: ELSE
839: l_time_comparison := FND_API.G_FALSE;
840: END IF;
841: IF p_contact_preference_rec.preference_end_time_hr is not null AND
842: p_contact_preference_rec.preference_end_time_hr <> FND_API.G_MISS_NUM THEN
843: IF p_contact_preference_rec.preference_end_time_hr < 0 OR

Line 842: p_contact_preference_rec.preference_end_time_hr <> FND_API.G_MISS_NUM THEN

838: ELSE
839: l_time_comparison := FND_API.G_FALSE;
840: END IF;
841: IF p_contact_preference_rec.preference_end_time_hr is not null AND
842: p_contact_preference_rec.preference_end_time_hr <> FND_API.G_MISS_NUM THEN
843: IF p_contact_preference_rec.preference_end_time_hr < 0 OR
844: p_contact_preference_rec.preference_end_time_hr > 23 THEN
845: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
846: FND_MSG_PUB.ADD;

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: IF p_contact_preference_rec.preference_end_time_hr < 0 OR
844: p_contact_preference_rec.preference_end_time_hr > 23 THEN
845: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
846: FND_MSG_PUB.ADD;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: l_time_comparison := FND_API.G_FALSE;
849: END IF;
850: ELSE
851: l_time_comparison := FND_API.G_FALSE;

Line 848: l_time_comparison := FND_API.G_FALSE;

844: p_contact_preference_rec.preference_end_time_hr > 23 THEN
845: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
846: FND_MSG_PUB.ADD;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: l_time_comparison := FND_API.G_FALSE;
849: END IF;
850: ELSE
851: l_time_comparison := FND_API.G_FALSE;
852: END IF;

Line 851: l_time_comparison := FND_API.G_FALSE;

847: x_return_status := FND_API.G_RET_STS_ERROR;
848: l_time_comparison := FND_API.G_FALSE;
849: END IF;
850: ELSE
851: l_time_comparison := FND_API.G_FALSE;
852: END IF;
853:
854: IF l_time_comparison = FND_API.G_TRUE THEN
855: IF p_contact_preference_rec.preference_end_time_hr < p_contact_preference_rec.preference_start_time_hr THEN

Line 854: IF l_time_comparison = FND_API.G_TRUE THEN

850: ELSE
851: l_time_comparison := FND_API.G_FALSE;
852: END IF;
853:
854: IF l_time_comparison = FND_API.G_TRUE THEN
855: IF p_contact_preference_rec.preference_end_time_hr < p_contact_preference_rec.preference_start_time_hr THEN
856: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
857: FND_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: IF l_time_comparison = FND_API.G_TRUE THEN
855: IF p_contact_preference_rec.preference_end_time_hr < p_contact_preference_rec.preference_start_time_hr THEN
856: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
857: FND_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: l_time_comparison := FND_API.G_FALSE;
860: ELSIF p_contact_preference_rec.preference_end_time_hr > p_contact_preference_rec.preference_start_time_hr THEN
861: l_time_comparison := FND_API.G_FALSE;
862: END IF;

Line 859: l_time_comparison := FND_API.G_FALSE;

855: IF p_contact_preference_rec.preference_end_time_hr < p_contact_preference_rec.preference_start_time_hr THEN
856: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
857: FND_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: l_time_comparison := FND_API.G_FALSE;
860: ELSIF p_contact_preference_rec.preference_end_time_hr > p_contact_preference_rec.preference_start_time_hr THEN
861: l_time_comparison := FND_API.G_FALSE;
862: END IF;
863: END IF;

Line 861: l_time_comparison := FND_API.G_FALSE;

857: FND_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: l_time_comparison := FND_API.G_FALSE;
860: ELSIF p_contact_preference_rec.preference_end_time_hr > p_contact_preference_rec.preference_start_time_hr THEN
861: l_time_comparison := FND_API.G_FALSE;
862: END IF;
863: END IF;
864:
865: ----------------------------------------------

Line 872: p_contact_preference_rec.preference_start_time_mi <> FND_API.G_MISS_NUM THEN

868:
869: -- preference_end_time_mi should be greater than preference_start_time_mi, and both should between 0-59
870:
871: IF p_contact_preference_rec.preference_start_time_mi is not null AND
872: p_contact_preference_rec.preference_start_time_mi <> FND_API.G_MISS_NUM THEN
873: IF p_contact_preference_rec.preference_start_time_mi < 0 OR
874: p_contact_preference_rec.preference_start_time_mi > 59 THEN
875: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
876: FND_MSG_PUB.ADD;

Line 877: x_return_status := FND_API.G_RET_STS_ERROR;

873: IF p_contact_preference_rec.preference_start_time_mi < 0 OR
874: p_contact_preference_rec.preference_start_time_mi > 59 THEN
875: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
876: FND_MSG_PUB.ADD;
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: l_time_comparison := FND_API.G_FALSE;
879: END IF;
880: ELSE
881: l_time_comparison := FND_API.G_FALSE;

Line 878: l_time_comparison := FND_API.G_FALSE;

874: p_contact_preference_rec.preference_start_time_mi > 59 THEN
875: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
876: FND_MSG_PUB.ADD;
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: l_time_comparison := FND_API.G_FALSE;
879: END IF;
880: ELSE
881: l_time_comparison := FND_API.G_FALSE;
882: END IF;

Line 881: l_time_comparison := FND_API.G_FALSE;

877: x_return_status := FND_API.G_RET_STS_ERROR;
878: l_time_comparison := FND_API.G_FALSE;
879: END IF;
880: ELSE
881: l_time_comparison := FND_API.G_FALSE;
882: END IF;
883: IF p_contact_preference_rec.preference_end_time_mi is not null AND
884: p_contact_preference_rec.preference_end_time_mi <> FND_API.G_MISS_NUM THEN
885: IF p_contact_preference_rec.preference_end_time_mi < 0 OR

Line 884: p_contact_preference_rec.preference_end_time_mi <> FND_API.G_MISS_NUM THEN

880: ELSE
881: l_time_comparison := FND_API.G_FALSE;
882: END IF;
883: IF p_contact_preference_rec.preference_end_time_mi is not null AND
884: p_contact_preference_rec.preference_end_time_mi <> FND_API.G_MISS_NUM THEN
885: IF p_contact_preference_rec.preference_end_time_mi < 0 OR
886: p_contact_preference_rec.preference_end_time_mi > 59 THEN
887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
888: FND_MSG_PUB.ADD;

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: IF p_contact_preference_rec.preference_end_time_mi < 0 OR
886: p_contact_preference_rec.preference_end_time_mi > 59 THEN
887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
888: FND_MSG_PUB.ADD;
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: l_time_comparison := FND_API.G_FALSE;
891: END IF;
892: ELSE
893: l_time_comparison := FND_API.G_FALSE;

Line 890: l_time_comparison := FND_API.G_FALSE;

886: p_contact_preference_rec.preference_end_time_mi > 59 THEN
887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
888: FND_MSG_PUB.ADD;
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: l_time_comparison := FND_API.G_FALSE;
891: END IF;
892: ELSE
893: l_time_comparison := FND_API.G_FALSE;
894: END IF;

Line 893: l_time_comparison := FND_API.G_FALSE;

889: x_return_status := FND_API.G_RET_STS_ERROR;
890: l_time_comparison := FND_API.G_FALSE;
891: END IF;
892: ELSE
893: l_time_comparison := FND_API.G_FALSE;
894: END IF;
895:
896: IF l_time_comparison = FND_API.G_TRUE THEN
897: IF p_contact_preference_rec.preference_end_time_mi < p_contact_preference_rec.preference_start_time_mi THEN

Line 896: IF l_time_comparison = FND_API.G_TRUE THEN

892: ELSE
893: l_time_comparison := FND_API.G_FALSE;
894: END IF;
895:
896: IF l_time_comparison = FND_API.G_TRUE THEN
897: IF p_contact_preference_rec.preference_end_time_mi < p_contact_preference_rec.preference_start_time_mi THEN
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
899: FND_MSG_PUB.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: IF l_time_comparison = FND_API.G_TRUE THEN
897: IF p_contact_preference_rec.preference_end_time_mi < p_contact_preference_rec.preference_start_time_mi THEN
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
899: FND_MSG_PUB.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: l_time_comparison := FND_API.G_FALSE;
902: END IF;
903: END IF;
904:

Line 901: l_time_comparison := FND_API.G_FALSE;

897: IF p_contact_preference_rec.preference_end_time_mi < p_contact_preference_rec.preference_start_time_mi THEN
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
899: FND_MSG_PUB.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: l_time_comparison := FND_API.G_FALSE;
902: END IF;
903: END IF;
904:
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 918: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR AND

914: ----------------------------------------------
915:
916: -- max_no_of_interact_uom_code is lookup code in lookup type MAX_NO_OF_INTERACT_UOM_CODE
917: IF p_contact_preference_rec.max_no_of_interact_uom_code IS NOT NULL AND
918: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR AND
919: ( p_create_update_flag = 'C' OR
920: ( p_create_update_flag = 'U' AND
921: p_contact_preference_rec.max_no_of_interact_uom_code <> NVL (l_max_no_of_interact_uom_code, FND_API.G_MISS_CHAR))) THEN
922:

Line 921: p_contact_preference_rec.max_no_of_interact_uom_code <> NVL (l_max_no_of_interact_uom_code, FND_API.G_MISS_CHAR))) THEN

917: IF p_contact_preference_rec.max_no_of_interact_uom_code IS NOT NULL AND
918: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR AND
919: ( p_create_update_flag = 'C' OR
920: ( p_create_update_flag = 'U' AND
921: p_contact_preference_rec.max_no_of_interact_uom_code <> NVL (l_max_no_of_interact_uom_code, FND_API.G_MISS_CHAR))) THEN
922:
923: HZ_UTILITY_V2PUB.validate_lookup (
924: p_column => 'max_no_of_interact_uom_code',
925: p_lookup_type => 'MAX_NO_OF_INTERACT_UOM_CODE',

Line 940: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR

936: END IF;
937:
938: -- if a value is passed for max_no_of_interact_uom_code then preference_start_date should have a value
939: IF p_contact_preference_rec.max_no_of_interact_uom_code IS NOT NULL AND
940: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR
941: THEN
942: HZ_UTILITY_V2PUB.validate_mandatory (
943: p_create_update_flag => p_create_update_flag,
944: p_column => 'preference_start_date',

Line 976: p_contact_preference_rec.requested_by <> FND_API.G_MISS_CHAR AND

972: END IF;
973:
974: -- requested_by is lookup code in lookup type REQUESTED_BY
975: IF p_contact_preference_rec.requested_by IS NOT NULL AND
976: p_contact_preference_rec.requested_by <> FND_API.G_MISS_CHAR AND
977: ( p_create_update_flag = 'C' OR
978: ( p_create_update_flag = 'U' AND
979: p_contact_preference_rec.requested_by <> NVL (l_requested_by, FND_API.G_MISS_CHAR))) THEN
980:

Line 979: p_contact_preference_rec.requested_by <> NVL (l_requested_by, FND_API.G_MISS_CHAR))) THEN

975: IF p_contact_preference_rec.requested_by IS NOT NULL AND
976: p_contact_preference_rec.requested_by <> FND_API.G_MISS_CHAR AND
977: ( p_create_update_flag = 'C' OR
978: ( p_create_update_flag = 'U' AND
979: p_contact_preference_rec.requested_by <> NVL (l_requested_by, FND_API.G_MISS_CHAR))) THEN
980:
981: HZ_UTILITY_V2PUB.validate_lookup (
982: p_column => 'requested_by',
983: p_lookup_type => 'REQUESTED_BY',

Line 1001: p_contact_preference_rec.reason_code <> FND_API.G_MISS_CHAR AND

997: -- validate reason_code
998: ----------------------------------------------
999: -- reason_code is lookup code in lookup type REASON_CODE
1000: IF p_contact_preference_rec.reason_code IS NOT NULL AND
1001: p_contact_preference_rec.reason_code <> FND_API.G_MISS_CHAR AND
1002: ( p_create_update_flag = 'C' OR
1003: ( p_create_update_flag = 'U' AND
1004: p_contact_preference_rec.reason_code <> NVL (l_reason_code, FND_API.G_MISS_CHAR))) THEN
1005:

Line 1004: p_contact_preference_rec.reason_code <> NVL (l_reason_code, FND_API.G_MISS_CHAR))) THEN

1000: IF p_contact_preference_rec.reason_code IS NOT NULL AND
1001: p_contact_preference_rec.reason_code <> FND_API.G_MISS_CHAR AND
1002: ( p_create_update_flag = 'C' OR
1003: ( p_create_update_flag = 'U' AND
1004: p_contact_preference_rec.reason_code <> NVL (l_reason_code, FND_API.G_MISS_CHAR))) THEN
1005:
1006: HZ_UTILITY_V2PUB.validate_lookup (
1007: p_column => 'reason_code',
1008: p_lookup_type => 'REASON_CODE',

Line 1042: p_contact_preference_rec.status <> FND_API.G_MISS_CHAR AND

1038: END IF;
1039:
1040: -- status is lookup code in lookup type CODE_STATUS
1041: IF p_contact_preference_rec.status IS NOT NULL AND
1042: p_contact_preference_rec.status <> FND_API.G_MISS_CHAR AND
1043: ( p_create_update_flag = 'C' OR
1044: ( p_create_update_flag = 'U' AND
1045: p_contact_preference_rec.status <> NVL (l_status, FND_API.G_MISS_CHAR))) THEN
1046:

Line 1045: p_contact_preference_rec.status <> NVL (l_status, FND_API.G_MISS_CHAR))) THEN

1041: IF p_contact_preference_rec.status IS NOT NULL AND
1042: p_contact_preference_rec.status <> FND_API.G_MISS_CHAR AND
1043: ( p_create_update_flag = 'C' OR
1044: ( p_create_update_flag = 'U' AND
1045: p_contact_preference_rec.status <> NVL (l_status, FND_API.G_MISS_CHAR))) THEN
1046:
1047: HZ_UTILITY_V2PUB.validate_lookup (
1048: p_column => 'status',
1049: p_lookup_type => 'CODE_STATUS',

Line 1063: IF p_contact_preference_rec.status <> FND_API.G_MISS_CHAR AND

1059: END IF;
1060: END IF;
1061:
1062: -- if status is not 'A', put sysdate on preference_end_date
1063: IF p_contact_preference_rec.status <> FND_API.G_MISS_CHAR AND
1064: p_contact_preference_rec.status is not null AND
1065: p_contact_preference_rec.status <> 'A' THEN
1066: IF p_contact_preference_rec.preference_end_date is not null AND
1067: to_char(p_contact_preference_rec.preference_end_date,'DD-MON-YY') <> to_char(sysdate, 'DD-MON-YY') THEN

Line 1096: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1092:
1093: -------------------------------------------
1094: -- check for record duplication
1095: --------------------------------------------
1096: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1097: IF p_create_update_flag = 'C' THEN
1098: BEGIN
1099: SELECT contact_preference_id INTO l_contact_pref_dup_id
1100: FROM HZ_CONTACT_PREFERENCES

Line 1124: p_contact_preference_rec.preference_end_date <> fnd_api.g_miss_date AND

1120:
1121: -- check preference_start_date preference_end_date overlap
1122: NOT ( ( p_contact_preference_rec.preference_end_date is not null AND
1123: --Bug Number 3067948.
1124: p_contact_preference_rec.preference_end_date <> fnd_api.g_miss_date AND
1125: p_contact_preference_rec.preference_end_date < preference_start_date ) OR
1126: ( preference_end_date is not null and
1127: p_contact_preference_rec.preference_start_date > preference_end_date )) AND
1128:

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR;

1155: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1156: END IF;
1157:
1158: FND_MSG_PUB.ADD;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: EXCEPTION
1161: WHEN NO_DATA_FOUND THEN
1162: NULL;
1163: END;

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1230: END IF;
1231:
1232: FND_MSG_PUB.ADD;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: EXCEPTION
1235: WHEN NO_DATA_FOUND THEN
1236: NULL;
1237: END;