DBA Data[Home] [Help]

APPS.IGS_AD_IMP_012 dependencies on FND_API

Line 180: p_init_msg_list => FND_API.G_FALSE,

176: p_phone_rec.phone_line_type := rec_pc.phone_line_type;
177: END IF;
178:
179: HZ_CONTACT_POINT_V2PUB.create_contact_point(
180: p_init_msg_list => FND_API.G_FALSE,
181: p_contact_point_rec => p_contact_points_rec,
182: p_email_rec => p_email_rec,
183: p_phone_rec => p_phone_rec,
184: x_return_status => l_return_status,

Line 194: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

190:
191: IF l_msg_count > 1 THEN
192: FOR i IN 1..l_msg_count
193: LOOP
194: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
195: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
196: END LOOP;
197: l_msg_data := l_tmp_var1;
198: END IF;

Line 655: p_contact_points_rec.primary_flag := NVL((NVL(rec_pc1.primary_flag,check_dup_contact_rec.primary_flag)),FND_API.G_MISS_CHAR);

651: p_contact_points_rec.contact_point_id := check_dup_contact_rec.contact_point_id;
652: p_contact_points_rec.contact_point_type := rec_pc1.contact_point_type;
653: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';
654: p_contact_points_rec.owner_table_id := rec_pc1.i_person_id;
655: p_contact_points_rec.primary_flag := NVL((NVL(rec_pc1.primary_flag,check_dup_contact_rec.primary_flag)),FND_API.G_MISS_CHAR);
656: -- p_contact_points_rec.content_source_type := 'USER_ENTERED';
657: -- p_contact_points_rec.created_by_module := 'IGS';
658: IF rec_pc1.contact_point_type = 'EMAIL' THEN
659: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);

Line 659: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);

655: p_contact_points_rec.primary_flag := NVL((NVL(rec_pc1.primary_flag,check_dup_contact_rec.primary_flag)),FND_API.G_MISS_CHAR);
656: -- p_contact_points_rec.content_source_type := 'USER_ENTERED';
657: -- p_contact_points_rec.created_by_module := 'IGS';
658: IF rec_pc1.contact_point_type = 'EMAIL' THEN
659: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);
660: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
661: END IF;
662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --

Line 660: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);

656: -- p_contact_points_rec.content_source_type := 'USER_ENTERED';
657: -- p_contact_points_rec.created_by_module := 'IGS';
658: IF rec_pc1.contact_point_type = 'EMAIL' THEN
659: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);
660: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
661: END IF;
662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);

Line 663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --

659: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);
660: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
661: END IF;
662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --
666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --

Line 664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);

660: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
661: END IF;
662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --
666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;

Line 665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --

661: END IF;
662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --
666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;
669:

Line 666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);

662: IF rec_pc1.contact_point_type = 'PHONE' THEN
663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --
666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;
669:
670: HZ_CONTACT_POINT_V2PUB.update_contact_point(

Line 667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --

663: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR); --
664: p_phone_rec.phone_line_type :=NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
665: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR); --
666: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;
669:
670: HZ_CONTACT_POINT_V2PUB.update_contact_point(
671: p_init_msg_list => FND_API.G_FALSE,

Line 671: p_init_msg_list => FND_API.G_FALSE,

667: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR); --
668: END IF;
669:
670: HZ_CONTACT_POINT_V2PUB.update_contact_point(
671: p_init_msg_list => FND_API.G_FALSE,
672: p_contact_point_rec => p_contact_points_rec,
673: p_email_rec => p_email_rec ,
674: p_phone_rec => p_phone_rec,
675: p_object_version_number => l_obj_ver,

Line 684: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

680:
681: IF l_return_status IN ('E','U') THEN
682: IF l_msg_count > 1 THEN
683: FOR i IN 1..l_msg_count LOOP -- loop thro the various error msgs and display
684: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
685: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
686: END LOOP;
687: l_msg_data := l_tmp_var1;
688: END IF;

Line 788: p_contact_points_rec.primary_flag := NVL((NVL(rec_pc1.primary_flag,check_dup_contact_rec.primary_flag)),FND_API.G_MISS_CHAR);

784: p_contact_points_rec.contact_point_id := l_contact_point_id;
785: p_contact_points_rec.contact_point_type := rec_pc1.contact_point_type;
786: p_contact_points_rec.owner_table_name := 'HZ_PARTIES';
787: p_contact_points_rec.owner_table_id := rec_pc1.i_person_id;
788: p_contact_points_rec.primary_flag := NVL((NVL(rec_pc1.primary_flag,check_dup_contact_rec.primary_flag)),FND_API.G_MISS_CHAR);
789:
790: -- p_contact_points_rec.content_source_type := 'USER_ENTERED';
791: -- p_contact_points_rec.created_by_module := 'IGS';
792:

Line 794: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);

790: -- p_contact_points_rec.content_source_type := 'USER_ENTERED';
791: -- p_contact_points_rec.created_by_module := 'IGS';
792:
793: IF rec_pc1.contact_point_type = 'EMAIL' THEN
794: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);
795: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
796: END IF;
797:
798: IF rec_pc1.contact_point_type = 'PHONE' THEN

Line 795: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);

791: -- p_contact_points_rec.created_by_module := 'IGS';
792:
793: IF rec_pc1.contact_point_type = 'EMAIL' THEN
794: p_email_rec.email_format := NVL(rec_pc1.email_format,FND_API.G_MISS_CHAR);
795: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
796: END IF;
797:
798: IF rec_pc1.contact_point_type = 'PHONE' THEN
799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);

Line 799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);

795: p_email_rec.email_address :=NVL(rec_pc1.email_address,FND_API.G_MISS_CHAR);
796: END IF;
797:
798: IF rec_pc1.contact_point_type = 'PHONE' THEN
799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);
800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;

Line 800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);

796: END IF;
797:
798: IF rec_pc1.contact_point_type = 'PHONE' THEN
799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);
800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;

Line 801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);

797:
798: IF rec_pc1.contact_point_type = 'PHONE' THEN
799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);
800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;
805: HZ_CONTACT_POINT_V2PUB.update_contact_point(

Line 802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);

798: IF rec_pc1.contact_point_type = 'PHONE' THEN
799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);
800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;
805: HZ_CONTACT_POINT_V2PUB.update_contact_point(
806: p_init_msg_list => FND_API.G_FALSE,

Line 803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;

799: p_phone_rec.phone_country_code := NVL((NVL(rec_pc1.phone_country_code,check_dup_contact_rec.phone_country_code)),FND_API.G_MISS_CHAR);
800: p_phone_rec.phone_line_type := NVL(rec_pc1.phone_line_type,FND_API.G_MISS_CHAR);
801: p_phone_rec.phone_area_code := NVL((NVL(rec_pc1.phone_area_code,check_dup_contact_rec.phone_area_code)),FND_API.G_MISS_CHAR);
802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;
805: HZ_CONTACT_POINT_V2PUB.update_contact_point(
806: p_init_msg_list => FND_API.G_FALSE,
807: p_contact_point_rec => p_contact_points_rec,

Line 806: p_init_msg_list => FND_API.G_FALSE,

802: p_phone_rec.phone_number := NVL(rec_pc1.phone_number,FND_API.G_MISS_CHAR);
803: p_phone_rec.phone_extension := NVL((NVL(rec_pc1.phone_extension,check_dup_contact_rec.phone_extension)),FND_API.G_MISS_CHAR) ;
804: END IF;
805: HZ_CONTACT_POINT_V2PUB.update_contact_point(
806: p_init_msg_list => FND_API.G_FALSE,
807: p_contact_point_rec => p_contact_points_rec,
808: p_email_rec => p_email_rec ,
809: p_phone_rec => p_phone_rec,
810: p_object_version_number => l_obj_ver,

Line 821: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

817: IF l_return_status IN ('E','U') THEN
818: IF l_msg_count > 1 THEN
819: FOR i IN 1..l_msg_count
820: LOOP
821: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
822: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
823: END LOOP;
824: l_msg_data := l_tmp_var1;
825: END IF;

Line 1125: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1121: IF l_return_status IN ('E','U') THEN
1122: IF l_msg_count > 1 THEN
1123: FOR i IN 1..l_msg_count
1124: LOOP
1125: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1126: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
1127: END LOOP;
1128: l_msg_data := l_tmp_var1;
1129: END IF;

Line 1366: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1362: IF l_return_status IN ('E','U') THEN
1363: IF l_msg_count > 1 THEN
1364: FOR i IN 1..l_msg_count
1365: LOOP
1366: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1367: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
1368: END LOOP;
1369: l_msg_data := l_tmp_var1;
1370: END IF;

Line 1488: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1484:
1485: IF l_msg_count > 1 THEN
1486: FOR i IN 1..l_msg_count
1487: LOOP
1488: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1489: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
1490: END LOOP;
1491: l_msg_data := l_tmp_var1;
1492: END IF;