DBA Data[Home] [Help]

APPS.IGS_OR_CONTACTS_PKG dependencies on FND_API

Line 59: l_message := FND_MSG_PUB.Get(p_msg_index => p_msg_cnt , p_encoded => FND_API.G_FALSE);

55: and give the right output.
56: ***************************************************************** */
57: BEGIN
58: IF p_msg_cnt = 1 THEN
59: l_message := FND_MSG_PUB.Get(p_msg_index => p_msg_cnt , p_encoded => FND_API.G_FALSE);
60: ELSE
61: FOR l_cnt IN 1..p_msg_cnt LOOP
62: l_var := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
63: l_message := l_message||' '||l_var;

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

58: IF p_msg_cnt = 1 THEN
59: l_message := FND_MSG_PUB.Get(p_msg_index => p_msg_cnt , p_encoded => FND_API.G_FALSE);
60: ELSE
61: FOR l_cnt IN 1..p_msg_cnt LOOP
62: l_var := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
63: l_message := l_message||' '||l_var;
64: END LOOP;
65: END IF;
66:

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

300: -- bug 2338473 logic to display more than one error modified.
301:
302: IF x_msg_count > 1 THEN
303: FOR i IN 1..x_msg_count LOOP
304: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
305: tmp_var1 := tmp_var1 || ' '|| tmp_var;
306: END LOOP;
307: x_msg_data := tmp_var1;
308: END IF;

Line 331: p_init_msg_list => FND_API.G_FALSE,

327:
328: -- If the Email Address is provided, then create the Contact Point
329: IF x_email_address IS NOT NULL THEN
330: hz_contact_point_v2pub.create_contact_point(
331: p_init_msg_list => FND_API.G_FALSE,
332: p_contact_point_rec => cpoint_rec ,
333: p_edi_rec => NULL,
334: p_email_rec => email_rec,
335: p_phone_rec => NULL,

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

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

Line 473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);

469: BEGIN
470:
471: -- Assign the values to the Org Contact Record
472: ocon_rec.org_contact_id := x_org_contact_id;
473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);
474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);

Line 474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);

470:
471: -- Assign the values to the Org Contact Record
472: ocon_rec.org_contact_id := x_org_contact_id;
473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);
474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);

Line 475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);

471: -- Assign the values to the Org Contact Record
472: ocon_rec.org_contact_id := x_org_contact_id;
473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);
474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);

Line 476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);

472: ocon_rec.org_contact_id := x_org_contact_id;
473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);
474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);

Line 477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);

473: ocon_rec.contact_number := NVL(x_contact_number,FND_API.G_MISS_CHAR);
474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);

Line 478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);

474: ocon_rec.title := NVL(x_title,FND_API.G_MISS_CHAR);
475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);

Line 479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);

475: ocon_rec.job_title := NVL(x_job_title,FND_API.G_MISS_CHAR);
476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);

Line 480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);

476: ocon_rec.attribute_category := NVL(x_Attribute_Category,FND_API.G_MISS_CHAR);
477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);

Line 481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);

477: ocon_rec.attribute1 := NVL(x_Attribute1,FND_API.G_MISS_CHAR);
478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);

Line 482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);

478: ocon_rec.attribute2 := NVL(x_Attribute2,FND_API.G_MISS_CHAR);
479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);

Line 483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);

479: ocon_rec.attribute3 := NVL(x_Attribute3,FND_API.G_MISS_CHAR);
480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);

Line 484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);

480: ocon_rec.attribute4 := NVL(x_Attribute4,FND_API.G_MISS_CHAR);
481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);

Line 485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);

481: ocon_rec.attribute5 := NVL(x_Attribute5,FND_API.G_MISS_CHAR);
482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);

Line 486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);

482: ocon_rec.attribute6 := NVL(x_Attribute6,FND_API.G_MISS_CHAR);
483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);

Line 487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);

483: ocon_rec.attribute7 := NVL(x_Attribute7,FND_API.G_MISS_CHAR);
484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);

Line 488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);

484: ocon_rec.attribute8 := NVL(x_attribute8,FND_API.G_MISS_CHAR);
485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);

Line 489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);

485: ocon_rec.attribute9 := NVL(x_Attribute9,FND_API.G_MISS_CHAR);
486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);

Line 490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);

486: ocon_rec.attribute10 := NVL(x_Attribute10,FND_API.G_MISS_CHAR);
487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);

Line 491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);

487: ocon_rec.attribute11 := NVL(x_Attribute11,FND_API.G_MISS_CHAR);
488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);

Line 492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);

488: ocon_rec.attribute12 := NVL(x_Attribute12,FND_API.G_MISS_CHAR);
489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);

Line 493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);

489: ocon_rec.attribute13 := NVL(x_Attribute13,FND_API.G_MISS_CHAR);
490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);
497:

Line 494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);

490: ocon_rec.attribute14 := NVL(x_Attribute14,FND_API.G_MISS_CHAR);
491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);
497:
498: org_rel_rec.subject_type := 'PERSON';

Line 495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);

491: ocon_rec.attribute15 := NVL(x_Attribute15,FND_API.G_MISS_CHAR);
492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);
497:
498: org_rel_rec.subject_type := 'PERSON';
499: org_rel_rec.subject_table_name := 'HZ_PARTIES';

Line 496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);

492: ocon_rec.attribute16 := NVL(x_Attribute16,FND_API.G_MISS_CHAR);
493: ocon_rec.attribute17 := NVL(x_Attribute17,FND_API.G_MISS_CHAR);
494: ocon_rec.attribute18 := NVL(x_Attribute18,FND_API.G_MISS_CHAR);
495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);
497:
498: org_rel_rec.subject_type := 'PERSON';
499: org_rel_rec.subject_table_name := 'HZ_PARTIES';
500: org_rel_rec.object_type := 'ORGANIZATION';

Line 516: -- email_rec.email_address := NVL(X_Email_Address,FND_API.G_MISS_CHAR);

512: cpoint_rec.contact_point_id := x_contact_point_Id;
513: cpoint_rec.status := NVL(x_status,'I');
514:
515: -- Assign the value to the Email Record
516: -- email_rec.email_address := NVL(X_Email_Address,FND_API.G_MISS_CHAR);
517:
518: -- Fetch the Org Contact Last Update Date
519: l_org_contacts_obj_ver_num := P_ORG_CONT_OVN;
520: l_hz_parties_obj_ver_num := P_REL_PARTY_OVN;

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

539: tmp_var := NULL;
540: tmp_var1 := NULL;
541:
542: FOR i IN 1..x_msg_count LOOP
543: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
544: tmp_var1 := tmp_var1 || ' '|| tmp_var;
545: END LOOP;
546: x_msg_data := tmp_var1;
547: END IF;

Line 571: email_rec.email_address := FND_API.G_MISS_CHAR;

567: email_rec.email_address := x_email_address;
568: ELSE
569:
570: cpoint_rec.primary_flag := 'N';
571: email_rec.email_address := FND_API.G_MISS_CHAR;
572: END IF;
573:
574: l_obj_ver := P_CONTACT_POINT_OVN;
575:

Line 578: p_init_msg_list => FND_API.G_FALSE,

574: l_obj_ver := P_CONTACT_POINT_OVN;
575:
576:
577: HZ_CONTACT_POINT_V2PUB.update_contact_point(
578: p_init_msg_list => FND_API.G_FALSE,
579: p_contact_point_rec => cpoint_rec,
580: p_edi_rec => NULL,
581: p_email_rec => email_rec,
582: p_phone_rec => NULL,

Line 605: p_init_msg_list => FND_API.G_FALSE,

601: cpoint_rec.created_by_module := 'IGS' ;
602: cpoint_rec.content_source_type := 'USER_ENTERED';
603:
604: hz_contact_point_v2pub.create_contact_point(
605: p_init_msg_list => FND_API.G_FALSE,
606: p_contact_point_rec => cpoint_rec ,
607: p_edi_rec => NULL,
608: p_email_rec => email_rec,
609: p_phone_rec => NULL,

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

623: tmp_var := NULL;
624: tmp_var1 := NULL;
625:
626: FOR i IN 1..x_msg_count LOOP
627: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
628: tmp_var1 := tmp_var1 || ' '|| tmp_var;
629: END LOOP;
630: x_msg_data := tmp_var1;
631: END IF;