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_PE_CONTACT_POINT_PKG dependencies on FND_API

Line 53: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

49: (reverse chronological order - newest change first)
50: ***************************************************************/
51:
52: p_api_version NUMBER(15) := 1.0;
53: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
54: p_commit VARCHAR2(30) := FND_API.G_FALSE;
55: l_msg_count NUMBER(15);
56: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
57: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

Line 54: p_commit VARCHAR2(30) := FND_API.G_FALSE;

50: ***************************************************************/
51:
52: p_api_version NUMBER(15) := 1.0;
53: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
54: p_commit VARCHAR2(30) := FND_API.G_FALSE;
55: l_msg_count NUMBER(15);
56: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
57: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
58: l_last_update_date hz_contact_points.last_update_date%TYPE;

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

117: ELSIF p_return_status <> 'S' THEN
118: -- bug 2338473 logic to display more than one error modified.
119: IF l_msg_count > 1 THEN
120: FOR i IN 1..l_msg_count LOOP
121: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
122: tmp_var1 := tmp_var1 || ' '|| tmp_var;
123: END LOOP;
124: p_msg_data := tmp_var1;
125: END IF;

Line 137: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);

133: l_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'EMAIL';
134: l_CONTACT_POINT_REC.STATUS := p_status;
135: l_CONTACT_POINT_REC.OWNER_TABLE_NAME := p_owner_table_name;
136: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
137: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
138: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);

Line 139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);

135: l_CONTACT_POINT_REC.OWNER_TABLE_NAME := p_owner_table_name;
136: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
137: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
138: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);

Line 140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);

136: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
137: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
138: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);

Line 141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);

137: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
138: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);

Line 142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);

138: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);

Line 143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);

139: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);

Line 144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);

140: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);

Line 145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);

141: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);

Line 146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);

142: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);

Line 147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);

143: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);

Line 148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);

144: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);

Line 149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);

145: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);

Line 150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);

146: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);

Line 151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);

147: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);

Line 152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);

148: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);

Line 153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);

149: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);

Line 154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);

150: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);

Line 155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);

151: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);

Line 156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);

152: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';

Line 157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);

153: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
161:

Line 158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);

154: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
161:
162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);

Line 159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);

155: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
156: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
157: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
161:
162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);
163: l_EMAIL_REC.EMAIL_ADDRESS := NVL(p_email_address,FND_API.G_MISS_CHAR);

Line 162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);

158: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
161:
162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);
163: l_EMAIL_REC.EMAIL_ADDRESS := NVL(p_email_address,FND_API.G_MISS_CHAR);
164:
165: HZ_CONTACT_POINT_V2PUB.update_contact_point(
166: p_init_msg_list => p_init_msg_list ,

Line 163: l_EMAIL_REC.EMAIL_ADDRESS := NVL(p_email_address,FND_API.G_MISS_CHAR);

159: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
160: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
161:
162: l_EMAIL_REC.EMAIL_FORMAT := NVL(p_email_format,FND_API.G_MISS_CHAR);
163: l_EMAIL_REC.EMAIL_ADDRESS := NVL(p_email_address,FND_API.G_MISS_CHAR);
164:
165: HZ_CONTACT_POINT_V2PUB.update_contact_point(
166: p_init_msg_list => p_init_msg_list ,
167: p_contact_point_rec => l_contact_point_rec ,

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

178: IF p_return_status <> 'S' THEN
179: -- bug 2338473 logic to display more than one error modified.
180: IF l_msg_count > 1 THEN
181: FOR i IN 1..l_msg_count LOOP
182: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
183: tmp_var1 := tmp_var1 || ' '|| tmp_var;
184: END LOOP;
185: p_msg_data := tmp_var1;
186: END IF;

Line 245: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

241: (reverse chronological order - newest change first)
242: ***************************************************************/
243:
244: p_api_version NUMBER(15) := 1.0;
245: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
246: p_commit VARCHAR2(30) := FND_API.G_FALSE;
247: l_msg_count NUMBER(15);
248: l_last_update_date hz_contact_points.last_update_date%TYPE;
249:

Line 246: p_commit VARCHAR2(30) := FND_API.G_FALSE;

242: ***************************************************************/
243:
244: p_api_version NUMBER(15) := 1.0;
245: p_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
246: p_commit VARCHAR2(30) := FND_API.G_FALSE;
247: l_msg_count NUMBER(15);
248: l_last_update_date hz_contact_points.last_update_date%TYPE;
249:
250: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

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

315: ELSIF p_return_status <> 'S' THEN
316: -- bug 2338473 logic to display more than one error modified.
317: IF l_msg_count > 1 THEN
318: FOR i IN 1..l_msg_count LOOP
319: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
320: tmp_var1 := tmp_var1 || ' '|| tmp_var;
321: END LOOP;
322: p_msg_data := tmp_var1;
323: END IF;

Line 336: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);

332: l_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'PHONE';
333: l_CONTACT_POINT_REC.STATUS := p_status;
334: l_CONTACT_POINT_REC.OWNER_TABLE_NAME := P_owner_table_name;
335: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
336: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
337: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);

Line 338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);

334: l_CONTACT_POINT_REC.OWNER_TABLE_NAME := P_owner_table_name;
335: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
336: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
337: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);

Line 339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);

335: l_CONTACT_POINT_REC.OWNER_TABLE_ID := p_owner_table_id;
336: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
337: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);

Line 340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);

336: l_CONTACT_POINT_REC.PRIMARY_FLAG := NVL(p_primary_flag,FND_API.G_MISS_CHAR);
337: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);

Line 341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);

337: -- l_CONTACT_POINT_REC.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);

Line 342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);

338: l_CONTACT_POINT_REC.attribute_category := NVL(p_attribute_category,FND_API.G_MISS_CHAR);
339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);

Line 343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);

339: l_CONTACT_POINT_REC.attribute1 := NVL(p_attribute1,FND_API.G_MISS_CHAR);
340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);

Line 344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);

340: l_CONTACT_POINT_REC.attribute2 := NVL(p_attribute2,FND_API.G_MISS_CHAR);
341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);

Line 345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);

341: l_CONTACT_POINT_REC.attribute3 := NVL(p_attribute3,FND_API.G_MISS_CHAR);
342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);

Line 346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);

342: l_CONTACT_POINT_REC.attribute4 := NVL(p_attribute4,FND_API.G_MISS_CHAR);
343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);

Line 347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);

343: l_CONTACT_POINT_REC.attribute5 := NVL(p_attribute5,FND_API.G_MISS_CHAR);
344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);

Line 348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);

344: l_CONTACT_POINT_REC.attribute6 := NVL(p_attribute6,FND_API.G_MISS_CHAR);
345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);

Line 349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);

345: l_CONTACT_POINT_REC.attribute7 := NVL(p_attribute7,FND_API.G_MISS_CHAR);
346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);

Line 350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);

346: l_CONTACT_POINT_REC.attribute8 := NVL(p_attribute8,FND_API.G_MISS_CHAR);
347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);

Line 351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);

347: l_CONTACT_POINT_REC.attribute9 := NVL(p_attribute9,FND_API.G_MISS_CHAR);
348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);

Line 352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);

348: l_CONTACT_POINT_REC.attribute10 := NVL(p_attribute10,FND_API.G_MISS_CHAR);
349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);

Line 353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);

349: l_CONTACT_POINT_REC.attribute11 := NVL(p_attribute11,FND_API.G_MISS_CHAR);
350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);

Line 354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);

350: l_CONTACT_POINT_REC.attribute12 := NVL(p_attribute12,FND_API.G_MISS_CHAR);
351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);

Line 355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);

351: l_CONTACT_POINT_REC.attribute13 := NVL(p_attribute13,FND_API.G_MISS_CHAR);
352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';

Line 356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);

352: l_CONTACT_POINT_REC.attribute14 := NVL(p_attribute14,FND_API.G_MISS_CHAR);
353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
360:

Line 357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);

353: l_CONTACT_POINT_REC.attribute15 := NVL(p_attribute15,FND_API.G_MISS_CHAR);
354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
360:
361:

Line 358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);

354: l_CONTACT_POINT_REC.attribute16 := NVL(p_attribute16,FND_API.G_MISS_CHAR);
355: l_CONTACT_POINT_REC.attribute17 := NVL(p_attribute17,FND_API.G_MISS_CHAR);
356: l_CONTACT_POINT_REC.attribute18 := NVL(p_attribute18,FND_API.G_MISS_CHAR);
357: l_CONTACT_POINT_REC.attribute19 := NVL(p_attribute19,FND_API.G_MISS_CHAR);
358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
360:
361:
362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);

Line 362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);

358: l_CONTACT_POINT_REC.attribute20 := NVL(p_attribute20,FND_API.G_MISS_CHAR);
359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
360:
361:
362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);
363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);
364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);

Line 363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);

359: -- l_CONTACT_POINT_REC.created_by_module := 'IGS';
360:
361:
362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);
363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);
364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);
367:

Line 364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);

360:
361:
362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);
363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);
364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);
367:
368: HZ_CONTACT_POINT_V2PUB.update_contact_point(

Line 365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);

361:
362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);
363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);
364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);
367:
368: HZ_CONTACT_POINT_V2PUB.update_contact_point(
369: p_init_msg_list => p_init_msg_list ,

Line 366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);

362: l_PHONE_REC.PHONE_COUNTRY_CODE := NVL(p_phone_country_code,FND_API.G_MISS_CHAR);
363: l_PHONE_REC.PHONE_AREA_CODE := NVL(p_phone_area_code,FND_API.G_MISS_CHAR);
364: l_PHONE_REC.PHONE_NUMBER := NVL( p_phone_number,FND_API.G_MISS_CHAR);
365: l_PHONE_REC.PHONE_EXTENSION := NVL( p_phone_extension,FND_API.G_MISS_CHAR);
366: l_PHONE_REC.PHONE_LINE_TYPE := NVL( p_phone_line_type,FND_API.G_MISS_CHAR);
367:
368: HZ_CONTACT_POINT_V2PUB.update_contact_point(
369: p_init_msg_list => p_init_msg_list ,
370: p_contact_point_rec => l_contact_point_rec ,

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

381: IF p_return_status <> 'S' THEN
382: -- bug 2338473 logic to display more than one error modified.
383: IF l_msg_count > 1 THEN
384: FOR i IN 1..l_msg_count LOOP
385: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
386: tmp_var1 := tmp_var1 || ' '|| tmp_var;
387: END LOOP;
388: p_msg_data := tmp_var1;
389: END IF;