APPS.IGS_PE_HZ_CONT_PREF_PKG dependencies on FND_API

Line 143: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

139: X_MODE in VARCHAR2 default 'R'
140: ) AS
141:
142: l_cont_pref_rec_type HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
143: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
144:
145: tmp_var VARCHAR2(2000);
146: tmp_var1 VARCHAR2(2000);
147: BEGIN

Line 210: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

206: IF x_return_status IN ('E','U') THEN
207:
208: IF x_msg_count > 1 THEN
209: FOR i IN 1..x_msg_count LOOP
210: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
211: tmp_var1 := tmp_var1 || ' '|| tmp_var;
212: END LOOP;
213: x_msg_data := tmp_var1;
214: END IF;

Line 244: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

240: X_STATUS IN VARCHAR2,
241: X_MODE in VARCHAR2 default 'R'
242: ) AS
243: l_cont_pref_rec_type HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
244: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
245: tmp_var VARCHAR2(2000);
246: tmp_var1 VARCHAR2(2000);
247:
248: BEGIN

Line 290: l_cont_pref_rec_type.preference_end_date := NVL(X_PREFERENCE_END_DATE,FND_API.G_MISS_DATE);-- this is a nullable col

286: l_cont_pref_rec_type.contact_level_table_id := X_CONTACT_LEVEL_TABLE_ID;
287: l_cont_pref_rec_type.contact_type := X_CONTACT_TYPE;
288: l_cont_pref_rec_type.preference_code := X_PREFERENCE_CODE;
289: l_cont_pref_rec_type.preference_start_date := X_PREFERENCE_START_DATE;
290: l_cont_pref_rec_type.preference_end_date := NVL(X_PREFERENCE_END_DATE,FND_API.G_MISS_DATE);-- this is a nullable col
291: l_cont_pref_rec_type.requested_by := NVL(X_REQUESTED_BY,'PARTY');
292: l_cont_pref_rec_type.reason_code := NVL(X_REASON_CODE,FND_API.G_MISS_CHAR); -- this is a nullable col
293: l_cont_pref_rec_type.status := 'A';
294:

Line 292: l_cont_pref_rec_type.reason_code := NVL(X_REASON_CODE,FND_API.G_MISS_CHAR); -- this is a nullable col

288: l_cont_pref_rec_type.preference_code := X_PREFERENCE_CODE;
289: l_cont_pref_rec_type.preference_start_date := X_PREFERENCE_START_DATE;
290: l_cont_pref_rec_type.preference_end_date := NVL(X_PREFERENCE_END_DATE,FND_API.G_MISS_DATE);-- this is a nullable col
291: l_cont_pref_rec_type.requested_by := NVL(X_REQUESTED_BY,'PARTY');
292: l_cont_pref_rec_type.reason_code := NVL(X_REASON_CODE,FND_API.G_MISS_CHAR); -- this is a nullable col
293: l_cont_pref_rec_type.status := 'A';
294:
295:
296:

Line 309: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

305: IF x_return_status IN ('E','U') THEN
306:
307: IF x_msg_count > 1 THEN
308: FOR i IN 1..x_msg_count LOOP
309: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
310: tmp_var1 := tmp_var1 || ' '|| tmp_var;
311: END LOOP;
312: x_msg_data := tmp_var1;
313: END IF;