DBA Data[Home] [Help]

APPS.IGS_OR_PHONES_PKG dependencies on FND_API

Line 43: l_var := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

39: Who When What
40: ***************************************************************** */
41: BEGIN
42: FOR l_cnt IN 1..p_msg_cnt LOOP
43: l_var := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
44: l_message := l_message||' '||l_var;
45: END LOOP;
46:
47: RETURN (l_message);

Line 185: p_init_msg_list => FND_API.G_FALSE,

181: END IF;
182:
183: -- call the API for the creation of the Contact Points
184: HZ_CONTACT_POINT_V2PUB.create_contact_point(
185: p_init_msg_list => FND_API.G_FALSE,
186: p_contact_point_rec => cpoint_rec,
187: p_edi_rec => edi_rec,
188: p_email_rec => email_rec,
189: p_phone_rec => phone_rec,

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

198: IF x_return_status <> 'S' THEN
199: -- ssawhney bug 2338473
200: IF x_msg_count > 1 THEN
201: FOR i IN 1..x_msg_count LOOP
202: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
203: tmp_var1 := tmp_var1 || ' '|| tmp_var;
204: END LOOP;
205: x_msg_data := tmp_var1;
206: END IF;

Line 287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);

283: -- Assign the values from the input to the Contact Points record
284: cpoint_rec.contact_point_id := x_phone_Id;
285: cpoint_rec.contact_point_type := X_Phone_Type;
286: cpoint_rec.status := x_status;
287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);
288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);

Line 288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);

284: cpoint_rec.contact_point_id := x_phone_Id;
285: cpoint_rec.contact_point_type := X_Phone_Type;
286: cpoint_rec.status := x_status;
287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);
288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);

Line 289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);

285: cpoint_rec.contact_point_type := X_Phone_Type;
286: cpoint_rec.status := x_status;
287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);
288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);

Line 290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);

286: cpoint_rec.status := x_status;
287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);
288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);

Line 291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);

287: cpoint_rec.primary_flag := NVL(x_primary_flag,FND_API.G_MISS_CHAR);
288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);

Line 292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);

288: cpoint_rec.attribute_category := NVL(x_attribute_category,FND_API.G_MISS_CHAR);
289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);

Line 293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);

289: cpoint_rec.attribute1 := NVL(x_attribute1,FND_API.G_MISS_CHAR);
290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);

Line 294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);

290: cpoint_rec.attribute2 := NVL(x_attribute2,FND_API.G_MISS_CHAR);
291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);

Line 295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);

291: cpoint_rec.attribute3 := NVL(x_attribute3,FND_API.G_MISS_CHAR);
292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);

Line 296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);

292: cpoint_rec.attribute4 := NVL(x_attribute4,FND_API.G_MISS_CHAR);
293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);

Line 297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);

293: cpoint_rec.attribute5 := NVL(x_attribute5,FND_API.G_MISS_CHAR);
294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);

Line 298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);

294: cpoint_rec.attribute6 := NVL(x_attribute6,FND_API.G_MISS_CHAR);
295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);

Line 299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);

295: cpoint_rec.attribute7 := NVL(x_attribute7,FND_API.G_MISS_CHAR);
296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);

Line 300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);

296: cpoint_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);

Line 301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);

297: cpoint_rec.attribute9 := NVL(x_attribute9,FND_API.G_MISS_CHAR);
298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);

Line 302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);

298: cpoint_rec.attribute10 := NVL(x_attribute10,FND_API.G_MISS_CHAR);
299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);

Line 303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);

299: cpoint_rec.attribute11 := NVL(x_attribute11,FND_API.G_MISS_CHAR);
300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);

Line 304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);

300: cpoint_rec.attribute12 := NVL(x_attribute12,FND_API.G_MISS_CHAR);
301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);
308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);

Line 305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);

301: cpoint_rec.attribute13 := NVL(x_attribute13,FND_API.G_MISS_CHAR);
302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);
308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);
309: -- cpoint_rec.created_by_module := 'IGS';

Line 306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);

302: cpoint_rec.attribute14 := NVL(x_attribute14,FND_API.G_MISS_CHAR);
303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);
308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);
309: -- cpoint_rec.created_by_module := 'IGS';
310: --cpoint_rec.content_source_type := 'USER_ENTERED ';

Line 307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);

303: cpoint_rec.attribute15 := NVL(x_attribute15,FND_API.G_MISS_CHAR);
304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);
308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);
309: -- cpoint_rec.created_by_module := 'IGS';
310: --cpoint_rec.content_source_type := 'USER_ENTERED ';
311:

Line 308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);

304: cpoint_rec.attribute16 := NVL(x_attribute16,FND_API.G_MISS_CHAR);
305: cpoint_rec.attribute17 := NVL(x_attribute17,FND_API.G_MISS_CHAR);
306: cpoint_rec.attribute18 := NVL(x_attribute18,FND_API.G_MISS_CHAR);
307: cpoint_rec.attribute19 := NVL(x_attribute19,FND_API.G_MISS_CHAR);
308: cpoint_rec.attribute20 := NVL(x_attribute20,FND_API.G_MISS_CHAR);
309: -- cpoint_rec.created_by_module := 'IGS';
310: --cpoint_rec.content_source_type := 'USER_ENTERED ';
311:
312: IF x_phone_type = g_tlx THEN

Line 321: phone_rec.phone_line_type := NVL(x_phone_type,FND_API.G_MISS_CHAR);

317: x_area_code IS NOT NULL THEN
318: telex_rec.telex_number := x_area_code ||'-'||x_phone_number;
319: END IF;
320: IF x_phone_type NOT IN ( g_tlx) THEN
321: phone_rec.phone_line_type := NVL(x_phone_type,FND_API.G_MISS_CHAR);
322: cpoint_rec.contact_point_type := g_phone;
323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);
324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);
325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);

Line 323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);

319: END IF;
320: IF x_phone_type NOT IN ( g_tlx) THEN
321: phone_rec.phone_line_type := NVL(x_phone_type,FND_API.G_MISS_CHAR);
322: cpoint_rec.contact_point_type := g_phone;
323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);
324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);
325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);
326: phone_rec.phone_extension := NVL(x_extension,FND_API.G_MISS_CHAR);
327: END IF;

Line 324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);

320: IF x_phone_type NOT IN ( g_tlx) THEN
321: phone_rec.phone_line_type := NVL(x_phone_type,FND_API.G_MISS_CHAR);
322: cpoint_rec.contact_point_type := g_phone;
323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);
324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);
325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);
326: phone_rec.phone_extension := NVL(x_extension,FND_API.G_MISS_CHAR);
327: END IF;
328:

Line 325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);

321: phone_rec.phone_line_type := NVL(x_phone_type,FND_API.G_MISS_CHAR);
322: cpoint_rec.contact_point_type := g_phone;
323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);
324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);
325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);
326: phone_rec.phone_extension := NVL(x_extension,FND_API.G_MISS_CHAR);
327: END IF;
328:
329: -- Call the API for the updation of the Contact Points

Line 326: phone_rec.phone_extension := NVL(x_extension,FND_API.G_MISS_CHAR);

322: cpoint_rec.contact_point_type := g_phone;
323: phone_rec.phone_number := NVL(x_phone_number,FND_API.G_MISS_CHAR);
324: phone_rec.phone_country_code := NVL(x_country_code,FND_API.G_MISS_CHAR);
325: phone_rec.phone_area_code := NVL(x_area_code,FND_API.G_MISS_CHAR);
326: phone_rec.phone_extension := NVL(x_extension,FND_API.G_MISS_CHAR);
327: END IF;
328:
329: -- Call the API for the updation of the Contact Points
330:

Line 334: p_init_msg_list => FND_API.G_FALSE,

330:
331:
332:
333: HZ_CONTACT_POINT_V2PUB.update_contact_point(
334: p_init_msg_list => FND_API.G_FALSE,
335: p_contact_point_rec => cpoint_rec,
336: p_edi_rec => edi_rec,
337: p_email_rec => email_rec ,
338: p_phone_rec => phone_rec,

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

346:
347: IF x_return_status <> 'S' THEN
348: IF x_msg_count > 1 THEN
349: FOR i IN 1..x_msg_count LOOP
350: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
351: tmp_var1 := tmp_var1 || ' '|| tmp_var;
352: END LOOP;
353: x_msg_data := tmp_var1;
354: END IF;