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.IGS_AD_IMP_008 dependencies on FND_API

Line 1740: p_init_msg_list => FND_API.G_FALSE,

1736: phone_rec.phone_number := p_rel_con_rec.phone_number;
1737: phone_rec.phone_extension := p_rel_con_rec.phone_extension;
1738: END IF;
1739: HZ_CONTACT_POINT_V2PUB.create_contact_point(
1740: p_init_msg_list => FND_API.G_FALSE,
1741: p_contact_point_rec => contact_point_rec,
1742: p_edi_rec => l_edi_rec,
1743: p_email_rec => email_rec,
1744: p_phone_rec => phone_rec,

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

1750: x_contact_point_id => l_contact_point_id);
1751: IF l_return_status IN ( 'E' , 'U' ) THEN
1752: IF l_msg_count > 1 THEN
1753: FOR i IN 1..l_msg_count LOOP
1754: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1755: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1756: END LOOP;
1757: l_msg_data := tmp_var1;
1758: END IF;

Line 2097: contact_point_rec.primary_flag :=NVL((NVL(relcon_rec.primary_flag,rel_cont_del_dup_rec.primary_flag)),FND_API.G_MISS_CHAR);

2093: contact_point_rec.contact_point_type := relcon_rec.contact_point_type;
2094: contact_point_rec.contact_point_id := rel_cont_del_dup_rec.contact_point_id;
2095: -- contact_point_rec.status := relcon_rec.status; --ssomani, unrelated statuses 15 March 2001
2096: contact_point_rec.owner_table_name := 'HZ_PARTIES';
2097: contact_point_rec.primary_flag :=NVL((NVL(relcon_rec.primary_flag,rel_cont_del_dup_rec.primary_flag)),FND_API.G_MISS_CHAR);
2098:
2099: -- contact_point_rec.content_source_type := 'USER_ENTERED';
2100: -- contact_point_rec.created_by_module := 'IGS';
2101:

Line 2104: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);

2100: -- contact_point_rec.created_by_module := 'IGS';
2101:
2102: IF relcon_rec.contact_point_type = 'EMAIL' THEN
2103: --items in the record p_email_rec
2104: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2105: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2106: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);

Line 2105: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);

2101:
2102: IF relcon_rec.contact_point_type = 'EMAIL' THEN
2103: --items in the record p_email_rec
2104: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2105: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2106: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);

Line 2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);

2104: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2105: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2106: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);

Line 2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);

2105: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2106: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2113: END IF;

Line 2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);

2106: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2113: END IF;
2114:

Line 2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);

2107: --items in the record p_phone_rec
2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2113: END IF;
2114:
2115: OPEN get_obj_version(rel_cont_del_dup_rec.contact_point_id);

Line 2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);

2108: phone_rec.phone_country_code := NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2109: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2110: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2111: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2112: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2113: END IF;
2114:
2115: OPEN get_obj_version(rel_cont_del_dup_rec.contact_point_id);
2116: FETCH get_obj_version INTO l_obj_ver;

Line 2121: p_init_msg_list => FND_API.G_FALSE,

2117: CLOSE get_obj_version;
2118:
2119: --Usage of API HZ_CONTACT_POINT_PUB.update_contact_points
2120: HZ_CONTACT_POINT_V2PUB.update_contact_point(
2121: p_init_msg_list => FND_API.G_FALSE,
2122: p_contact_point_rec => contact_point_rec,
2123: p_email_rec => email_rec ,
2124: p_phone_rec => phone_rec,
2125: p_object_version_number => l_obj_ver,

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

2141: ELSE --ssomani added this check 15 March 2001
2142:
2143: IF l_msg_count > 1 THEN
2144: FOR i IN 1..l_msg_count LOOP
2145: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2146: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2147: END LOOP;
2148: l_msg_data := tmp_var1;
2149: END IF;

Line 2189: contact_point_rec.primary_flag := NVL((NVL(relcon_rec.primary_flag,rel_cont_del_dup_rec.primary_flag)),FND_API.G_MISS_CHAR);

2185: contact_point_rec.contact_point_type := relcon_rec.contact_point_type;
2186: contact_point_rec.contact_point_id := rel_cont_del_dup_rec.contact_point_id;
2187: -- contact_point_rec.status := relcon_rec.status; --ssomani, unrelated statuses 15 March 2001
2188: contact_point_rec.owner_table_name := 'HZ_PARTIES';
2189: contact_point_rec.primary_flag := NVL((NVL(relcon_rec.primary_flag,rel_cont_del_dup_rec.primary_flag)),FND_API.G_MISS_CHAR);
2190:
2191: -- contact_point_rec.content_source_type := 'USER_ENTERED';
2192: -- contact_point_rec.created_by_module := 'IGS';
2193:

Line 2196: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);

2192: -- contact_point_rec.created_by_module := 'IGS';
2193:
2194: IF relcon_rec.contact_point_type = 'EMAIL' THEN
2195: --items in the record p_email_rec
2196: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2197: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2198: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);

Line 2197: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);

2193:
2194: IF relcon_rec.contact_point_type = 'EMAIL' THEN
2195: --items in the record p_email_rec
2196: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2197: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2198: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);

Line 2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);

2196: email_rec.email_format := NVL((NVL(relcon_rec.email_format,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2197: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2198: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);

Line 2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);

2197: email_rec.email_address :=NVL((NVL(relcon_rec.email_addrress,rel_cont_del_dup_rec.email_format)),FND_API.G_MISS_CHAR);
2198: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2205: END IF;

Line 2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);

2198: ELSIF relcon_rec.contact_point_type = 'PHONE' THEN
2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2205: END IF;
2206:

Line 2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);

2199: --items in the record p_phone_rec
2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2205: END IF;
2206:
2207: -- SELECT LAST_UPDATE_DATEFROM HZ_CONTACT_POINTSWHERE OWNER_TABLE_ID = contact_point_id

Line 2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);

2200: phone_rec.phone_country_code :=NVL((NVL(relcon_rec.phone_country_code,rel_cont_del_dup_rec.phone_country_code)),FND_API.G_MISS_CHAR);
2201: phone_rec.phone_line_type := NVL((NVL(relcon_rec.phone_line_type,rel_cont_del_dup_rec.phone_line_type)),FND_API.G_MISS_CHAR);
2202: phone_rec.phone_area_code := NVL((NVL(relcon_rec.phone_area_code,rel_cont_del_dup_rec.phone_area_code)),FND_API.G_MISS_CHAR);
2203: phone_rec.phone_number := NVL((NVL(relcon_rec.phone_number,rel_cont_del_dup_rec.phone_number)),FND_API.G_MISS_CHAR);
2204: phone_rec.phone_extension := NVL((NVL(relcon_rec.phone_extension,rel_cont_del_dup_rec.phone_extension)),FND_API.G_MISS_CHAR);
2205: END IF;
2206:
2207: -- SELECT LAST_UPDATE_DATEFROM HZ_CONTACT_POINTSWHERE OWNER_TABLE_ID = contact_point_id
2208: -- returned from duplicate check.

Line 2218: p_init_msg_list => FND_API.G_FALSE,

2214: --Usage of API HZ_CONTACT_POINT_PUB.update_contact_points
2215: BEGIN --ssomani added BEGIN - EXCEPTION - END Block 15 March 2001
2216:
2217: HZ_CONTACT_POINT_V2PUB.update_contact_point(
2218: p_init_msg_list => FND_API.G_FALSE,
2219: p_contact_point_rec => contact_point_rec,
2220: p_email_rec => email_rec ,
2221: p_phone_rec => phone_rec,
2222: p_object_version_number => l_obj_ver,

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

2227:
2228: IF l_return_status IN ('E','U') THEN
2229: IF l_msg_count > 1 THEN
2230: FOR i IN 1..l_msg_count LOOP
2231: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2232: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2233: END LOOP;
2234: l_msg_data := tmp_var1;
2235: END IF;