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

Line 13: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

9: p_area_code IN VARCHAR2 ,
10: p_number IN VARCHAR2 ,
11: p_extension IN VARCHAR2 ,
12: --Start Bug 6620664
13: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
14: --End Bug 6620664
15: x_return_status OUT NOCOPY VARCHAR2,
16: x_msg_count OUT NOCOPY NUMBER ,
17: x_msg_data OUT NOCOPY VARCHAR2

Line 68: x_return_status := fnd_api.g_ret_sts_success;

64: l_rec.phone_extension IS NOT NULL AND p_extension IS NOT NULL AND
65: l_rec.phone_extension = p_extension
66: ) THEN
67: -- the current data is the same as the new data so no change needed
68: x_return_status := fnd_api.g_ret_sts_success;
69: RETURN;
70: END IF;
71:
72: l_contact_points_rec.status := 'A';

Line 85: IF p_phone_object_version_number <> fnd_api.G_NULL_NUM THEN

81: l_phone_rec.phone_extension := p_extension;
82: l_phone_rec.phone_line_type := 'GEN';
83:
84: --Start for Bug 6620664
85: IF p_phone_object_version_number <> fnd_api.G_NULL_NUM THEN
86:
87: l_rec.object_version_number := p_phone_object_version_number;
88: END IF;
89: --End for Bug 6620664

Line 92: (p_init_msg_list => fnd_api.g_false,

88: END IF;
89: --End for Bug 6620664
90:
91: hz_contact_point_v2pub.update_contact_point
92: (p_init_msg_list => fnd_api.g_false,
93: p_contact_point_rec => l_contact_points_rec,
94: p_phone_rec => l_phone_rec,
95: p_object_version_number => l_rec.object_version_number,
96: x_return_status => x_return_status,

Line 125: ( p_init_msg_list => fnd_api.g_false,

121: l_contact_points_rec.application_id := 177;
122: l_contact_points_rec.primary_flag := 'Y';
123:
124: hz_contact_point_v2pub.create_contact_point
125: ( p_init_msg_list => fnd_api.g_false,
126: p_contact_point_rec => l_contact_points_rec,
127: p_phone_rec => l_phone_rec,
128: x_contact_point_id => l_contact_point_id,
129: x_return_status => x_return_status,

Line 142: x_return_status := fnd_api.g_ret_sts_success;

138: p_msg_count => x_msg_count,
139: p_msg_data => x_msg_data
140: );
141: ELSE
142: x_return_status := fnd_api.g_ret_sts_success;
143: END IF;
144:
145: END create_or_update_tca_phone;
146:

Line 156: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

152: p_area_code IN VARCHAR2 ,
153: p_number IN VARCHAR2 ,
154: p_extension IN VARCHAR2 ,
155: --Start Bug 6620664
156: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
157: --End Bug 6620664
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER ,
160: x_msg_data OUT NOCOPY VARCHAR2

Line 209: x_return_status := fnd_api.g_ret_sts_success;

205: l_rec.phone_number IS NOT NULL AND p_number IS NOT NULL AND
206: l_rec.phone_number = p_number
207: ) THEN
208: -- the current data is the same as the new data so no change needed
209: x_return_status := fnd_api.g_ret_sts_success;
210: RETURN;
211: END IF;
212: l_contact_points_rec.status := 'A';
213: l_phone_rec.phone_number := p_number;

Line 224: IF p_fax_object_version_number <> fnd_api.G_NULL_NUM THEN

220: l_phone_rec.phone_extension := p_extension;
221: l_phone_rec.phone_line_type := 'FAX';
222:
223: --Start for Bug 6620664
224: IF p_fax_object_version_number <> fnd_api.G_NULL_NUM THEN
225:
226: l_rec.object_version_number := p_fax_object_version_number;
227: END IF;
228: --End for Bug 6620664

Line 231: (p_init_msg_list => fnd_api.g_false,

227: END IF;
228: --End for Bug 6620664
229:
230: hz_contact_point_v2pub.update_contact_point
231: (p_init_msg_list => fnd_api.g_false,
232: p_contact_point_rec => l_contact_points_rec,
233: p_phone_rec => l_phone_rec,
234: p_object_version_number => l_rec.object_version_number,
235: x_return_status => x_return_status,

Line 255: ( p_init_msg_list => fnd_api.g_false,

251: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
252: l_contact_points_rec.application_id := 177;
253:
254: hz_contact_point_v2pub.create_contact_point
255: ( p_init_msg_list => fnd_api.g_false,
256: p_contact_point_rec => l_contact_points_rec,
257: p_phone_rec => l_phone_rec,
258: x_contact_point_id => l_contact_point_id,
259: x_return_status => x_return_status,

Line 264: x_return_status := fnd_api.g_ret_sts_success;

260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data
262: );
263: ELSE
264: x_return_status := fnd_api.g_ret_sts_success;
265: END IF;
266:
267: END create_or_update_tca_fax;
268:

Line 275: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

271: ( p_owner_table_id IN NUMBER,
272: p_owner_table_name IN VARCHAR2,
273: p_email_address IN VARCHAR2,
274: --Start Bug 6620664
275: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
276: --End Bug 6620664
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2

Line 317: x_return_status := fnd_api.g_ret_sts_success;

313: l_rec.email_address IS NOT NULL AND p_email_address IS NOT NULL AND
314: l_rec.email_address = p_email_address
315: ) THEN
316: -- the current data is the same as the new data so no change needed
317: x_return_status := fnd_api.g_ret_sts_success;
318: RETURN;
319: END IF;
320:
321: l_contact_points_rec.status := 'A';

Line 330: IF p_email_object_version_number <> fnd_api.G_NULL_NUM THEN

326:
327: l_email_rec.email_format := 'MAILTEXT';
328:
329: --Start for Bug 6620664
330: IF p_email_object_version_number <> fnd_api.G_NULL_NUM THEN
331:
332: l_rec.object_version_number := p_email_object_version_number;
333: END IF;
334: --End for Bug 6620664

Line 337: (p_init_msg_list => fnd_api.g_false,

333: END IF;
334: --End for Bug 6620664
335:
336: hz_contact_point_v2pub.update_contact_point
337: (p_init_msg_list => fnd_api.g_false,
338: p_contact_point_rec => l_contact_points_rec,
339: p_email_rec => l_email_rec,
340: p_object_version_number => l_rec.object_version_number,
341: x_return_status => x_return_status,

Line 358: ( p_init_msg_list => fnd_api.g_false,

354: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
355: l_contact_points_rec.application_id := 177;
356:
357: hz_contact_point_v2pub.create_contact_point
358: ( p_init_msg_list => fnd_api.g_false,
359: p_contact_point_rec => l_contact_points_rec,
360: p_email_rec => l_email_rec,
361: x_contact_point_id => l_contact_point_id,
362: x_return_status => x_return_status,

Line 367: x_return_status := fnd_api.g_ret_sts_success;

363: x_msg_count => x_msg_count,
364: x_msg_data => x_msg_data
365: );
366: ELSE
367: x_return_status := fnd_api.g_ret_sts_success;
368: END IF;
369:
370: END create_or_update_tca_email;
371:

Line 379: , p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM

375: , p_area_code IN VARCHAR2
376: , p_number IN VARCHAR2
377: , p_extension IN VARCHAR2
378: --Start Bug 6620664
379: , p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
380: --End Bug 6620664
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_msg_count OUT nocopy VARCHAR2
383: , x_msg_data OUT NOCOPY VARCHAR2

Line 391: p_area_code => nvl(p_area_code, fnd_api.g_miss_char),

387: create_or_update_tca_phone
388: (p_owner_table_id => p_party_id,
389: p_owner_table_name => 'HZ_PARTIES',
390: p_country_code => p_country_code,
391: p_area_code => nvl(p_area_code, fnd_api.g_miss_char),
392: p_number => p_number,
393: p_extension => nvl(p_extension,fnd_api.g_miss_char),
394: --Start Bug 6620664
395: p_phone_object_version_number => p_phone_object_version_number,

Line 393: p_extension => nvl(p_extension,fnd_api.g_miss_char),

389: p_owner_table_name => 'HZ_PARTIES',
390: p_country_code => p_country_code,
391: p_area_code => nvl(p_area_code, fnd_api.g_miss_char),
392: p_number => p_number,
393: p_extension => nvl(p_extension,fnd_api.g_miss_char),
394: --Start Bug 6620664
395: p_phone_object_version_number => p_phone_object_version_number,
396: --End Bug 6620664
397: x_return_status => x_return_status,

Line 410: , p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM

406: , p_area_code IN VARCHAR2
407: , p_number IN VARCHAR2
408: , p_extension IN VARCHAR2
409: --Start Bug 6620664
410: , p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
411: --End Bug 6620664
412: , x_return_status OUT NOCOPY VARCHAR2
413: , x_msg_count OUT nocopy VARCHAR2
414: , x_msg_data OUT NOCOPY VARCHAR2

Line 438: , p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM

434: PROCEDURE update_party_email
435: ( p_party_id IN NUMBER
436: , p_email IN VARCHAR2
437: --Start Bug 6620664
438: , p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
439: --End Bug 6620664
440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_msg_count OUT nocopy VARCHAR2
442: , x_msg_data OUT NOCOPY VARCHAR2