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

Line 65: (p_init_msg_list => fnd_api.g_false,

61: );
62: END IF;
63:
64: hz_party_contact_v2pub.create_org_contact
65: (p_init_msg_list => fnd_api.g_false,
66: p_org_contact_rec => l_org_contact_rec,
67: x_return_status => x_return_status,
68: x_msg_count => x_msg_count,
69: x_msg_data => x_msg_data,

Line 84: IF x_return_status = fnd_api.g_ret_sts_success THEN

80: p_msg_count => x_msg_count,
81: p_msg_data => x_msg_data
82: );
83:
84: IF x_return_status = fnd_api.g_ret_sts_success THEN
85: x_rel_party_id := l_rel_party_id;
86: END IF;
87:
88: END create_org_contact_private;

Line 170: (p_init_msg_list => fnd_api.g_false,

166: );
167: END IF;
168:
169: hz_party_v2pub.create_person
170: (p_init_msg_list => fnd_api.g_false,
171: p_person_rec => l_person_rec,
172: p_party_usage_code => 'SUPPLIER_CONTACT',
173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,

Line 196: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

192: p_msg_count => x_msg_count,
193: p_msg_data => x_msg_data
194: );
195:
196: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
197: /* Added for bug 7366321 */
198: if nvl(l_hzprofile_changed,'N') = 'Y' then
199: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);
200: l_hzprofile_changed := 'N';

Line 219: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

215: x_msg_data => x_msg_data,
216: x_rel_party_id => l_rel_party_id
217: );
218:
219: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
220: ROLLBACK TO create_supplier_contact_sp;
221: RETURN;
222: END IF;
223:

Line 246: x_return_status <> fnd_api.g_ret_sts_success THEN

242: x_msg_data => x_msg_data
243: );
244:
245: IF x_return_status IS NULL OR
246: x_return_status <> fnd_api.g_ret_sts_success THEN
247: ROLLBACK TO create_supplier_contact_sp;
248: RETURN;
249: END IF;
250:

Line 273: x_return_status <> fnd_api.g_ret_sts_success THEN

269: x_msg_data => x_msg_data
270: );
271:
272: IF x_return_status IS NULL OR
273: x_return_status <> fnd_api.g_ret_sts_success THEN
274: ROLLBACK TO create_supplier_contact_sp;
275: RETURN;
276: END IF;
277:

Line 297: x_return_status <> fnd_api.g_ret_sts_success THEN

293: x_msg_data => x_msg_data
294: );
295:
296: IF x_return_status IS NULL OR
297: x_return_status <> fnd_api.g_ret_sts_success THEN
298: ROLLBACK TO create_supplier_contact_sp;
299: RETURN;
300: END IF;
301:

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

307: l_hzprofile_changed := 'N';
308: end if;
309: /* End */
310: ROLLBACK TO create_supplier_contact_sp;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: x_msg_count := 1;
313: x_msg_data := Sqlerrm;
314: pos_log.log_sqlerrm('POSCONTB', 'in create_supplier_contact');
315:

Line 366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

362: p_fax_number IN VARCHAR2 DEFAULT NULL,
363: p_email_address IN VARCHAR2 DEFAULT NULL,
364: p_inactive_date IN DATE DEFAULT NULL,
365: --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

Line 367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

363: p_email_address IN VARCHAR2 DEFAULT NULL,
364: p_inactive_date IN DATE DEFAULT NULL,
365: --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

Line 368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

364: p_inactive_date IN DATE DEFAULT NULL,
365: --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
372: --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages

Line 369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

365: --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
372: --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
373: p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

Line 370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

366: p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
372: --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
373: p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
374: x_return_status OUT nocopy VARCHAR2,

Line 371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

367: p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
368: p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
372: --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
373: p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
374: x_return_status OUT nocopy VARCHAR2,
375: x_msg_count OUT nocopy NUMBER,

Line 373: p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,

369: p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
370: p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
371: p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
372: --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
373: p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
374: x_return_status OUT nocopy VARCHAR2,
375: x_msg_count OUT nocopy NUMBER,
376: x_msg_data OUT nocopy VARCHAR2
377: )

Line 455: x_return_status := fnd_api.g_ret_sts_error;

451: FETCH l_contact_party_cur INTO l_contact_party_rec;
452:
453: IF l_contact_party_cur%notfound THEN
454: CLOSE l_contact_party_cur;
455: x_return_status := fnd_api.g_ret_sts_error;
456: x_msg_count := 1;
457: x_msg_data := 'invalid contact party_id ' || p_contact_party_id;
458: RETURN;
459: END IF;

Line 461: IF(p_person_party_obversion_num=fnd_api.G_NULL_NUM) THEN

457: x_msg_data := 'invalid contact party_id ' || p_contact_party_id;
458: RETURN;
459: END IF;
460: /* Bug 7027825 Start */
461: IF(p_person_party_obversion_num=fnd_api.G_NULL_NUM) THEN
462: l_person_party_obversion_num := l_contact_party_rec.object_version_number;
463: ELSE
464: l_person_party_obversion_num := p_person_party_obversion_num;
465: END IF ;

Line 484: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

480: x_return_status => x_return_status,
481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data
483: );
484: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
485: ROLLBACK TO update_supplier_contact_sp;
486: RETURN;
487: END IF;
488:

Line 498: IF(p_party_object_version_number = fnd_api.G_NULL_NUM) THEN

494: l_rel_rec.end_date := p_inactive_date;
495: end if;
496:
497: /* Start Bug 6620664 */
498: IF(p_party_object_version_number = fnd_api.G_NULL_NUM) THEN
499: l_party_object_version_number := l_rec2.rel_party_obj_ver_num;
500: ELSE
501: l_party_object_version_number := p_party_object_version_number;
502: END IF;

Line 504: IF(p_rel_object_version_number = fnd_api.G_NULL_NUM) THEN

500: ELSE
501: l_party_object_version_number := p_party_object_version_number;
502: END IF;
503:
504: IF(p_rel_object_version_number = fnd_api.G_NULL_NUM) THEN
505: l_rel_object_version_number := l_rec2.rel_object_version_number;
506: ELSE
507: l_rel_object_version_number := p_rel_object_version_number;
508: END IF;

Line 510: IF(p_cont_object_version_number = fnd_api.G_NULL_NUM) THEN

506: ELSE
507: l_rel_object_version_number := p_rel_object_version_number;
508: END IF;
509:
510: IF(p_cont_object_version_number = fnd_api.G_NULL_NUM) THEN
511: l_cont_object_version_number := l_rec2.cont_object_version_number;
512: ELSE
513: l_cont_object_version_number := p_cont_object_version_number;
514: END IF;

Line 529: (p_init_msg_list => fnd_api.g_true,

525: l_org_contact_rec.party_rel_rec := l_rel_rec;
526: l_org_contact_rec.org_contact_id := l_rec2.org_contact_id;
527:
528: hz_party_contact_v2pub.update_org_contact
529: (p_init_msg_list => fnd_api.g_true,
530: p_org_contact_rec => l_org_contact_rec,
531: --Start Bug 6620664
532: p_cont_object_version_number => l_cont_object_version_number, --l_rec2.cont_object_version_number,
533: p_rel_object_version_number => l_rel_object_version_number, --l_rec2.rel_object_version_number,

Line 540: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

536: x_return_status => x_return_status,
537: x_msg_count => x_msg_count,
538: x_msg_data => x_msg_data
539: );
540: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
541: ROLLBACK TO update_supplier_contact_sp;
542: RETURN;
543: END IF;
544: END IF;

Line 558: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

554: x_msg_data => x_msg_data,
555: x_rel_party_id => l_rel_party_id
556: );
557:
558: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
559: --ROLLBACK TO create_supplier_contact_sp;
560: ROLLBACK TO update_supplier_contact_sp;
561: RETURN;
562: END IF;

Line 586: l_person_rec.person_first_name := nvl(p_first_name, fnd_api.g_miss_char);

582:
583: NULL; -- no change for party
584:
585: ELSE
586: l_person_rec.person_first_name := nvl(p_first_name, fnd_api.g_miss_char);
587: l_person_rec.person_last_name := p_last_name;
588: l_person_rec.person_middle_name := nvl(p_middle_name, fnd_api.g_miss_char);
589: l_person_rec.person_pre_name_adjunct := nvl(p_contact_title, fnd_api.g_miss_char);
590: l_party_rec.party_id := p_contact_party_id;

Line 588: l_person_rec.person_middle_name := nvl(p_middle_name, fnd_api.g_miss_char);

584:
585: ELSE
586: l_person_rec.person_first_name := nvl(p_first_name, fnd_api.g_miss_char);
587: l_person_rec.person_last_name := p_last_name;
588: l_person_rec.person_middle_name := nvl(p_middle_name, fnd_api.g_miss_char);
589: l_person_rec.person_pre_name_adjunct := nvl(p_contact_title, fnd_api.g_miss_char);
590: l_party_rec.party_id := p_contact_party_id;
591: l_person_rec.party_rec := l_party_rec;
592:

Line 589: l_person_rec.person_pre_name_adjunct := nvl(p_contact_title, fnd_api.g_miss_char);

585: ELSE
586: l_person_rec.person_first_name := nvl(p_first_name, fnd_api.g_miss_char);
587: l_person_rec.person_last_name := p_last_name;
588: l_person_rec.person_middle_name := nvl(p_middle_name, fnd_api.g_miss_char);
589: l_person_rec.person_pre_name_adjunct := nvl(p_contact_title, fnd_api.g_miss_char);
590: l_party_rec.party_id := p_contact_party_id;
591: l_person_rec.party_rec := l_party_rec;
592:
593: /* Bug 7027825 , For Updating A Person Party Type We need to pass the object version number of the

Line 597: (p_init_msg_list => fnd_api.g_true,

593: /* Bug 7027825 , For Updating A Person Party Type We need to pass the object version number of the
594: PERSON record ,So changed the below object version number parameter to l_person_party_obversion_num */
595:
596: hz_party_v2pub.update_person
597: (p_init_msg_list => fnd_api.g_true,
598: p_person_rec => l_person_rec,
599: p_party_object_version_number => l_person_party_obversion_num,
600: x_profile_id => l_profile_id,
601: x_return_status => x_return_status,

Line 606: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data
604: );
605:
606: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
607: ROLLBACK TO update_supplier_contact_sp;
608: RETURN;
609: END IF;
610: END IF;

Line 628: x_return_status <> fnd_api.g_ret_sts_success THEN

624: x_msg_data => x_msg_data
625: );
626:
627: IF x_return_status IS NULL OR
628: x_return_status <> fnd_api.g_ret_sts_success THEN
629: --ROLLBACK TO create_supplier_contact_sp;
630: ROLLBACK TO update_supplier_contact_sp;
631: RETURN;
632: END IF;

Line 650: x_return_status <> fnd_api.g_ret_sts_success THEN

646: x_msg_data => x_msg_data
647: );
648:
649: IF x_return_status IS NULL OR
650: x_return_status <> fnd_api.g_ret_sts_success THEN
651: --ROLLBACK TO create_supplier_contact_sp;
652: ROLLBACK TO update_supplier_contact_sp;
653: RETURN;
654: END IF;

Line 681: x_return_status <> fnd_api.g_ret_sts_success THEN

677:
678: END LOOP;
679:
680: IF x_return_status IS NULL OR
681: x_return_status <> fnd_api.g_ret_sts_success THEN
682: --ROLLBACK TO create_supplier_contact_sp;
683: ROLLBACK TO update_supplier_contact_sp;
684: RETURN;
685: END IF;

Line 690: x_return_status := fnd_api.g_ret_sts_unexp_error;

686:
687: EXCEPTION
688: WHEN OTHERS THEN
689: ROLLBACK TO update_supplier_contact_sp;
690: x_return_status := fnd_api.g_ret_sts_unexp_error;
691: x_msg_count := 1;
692: x_msg_data := Sqlerrm;
693: pos_log.log_sqlerrm('POSCONTB', 'in update_supplier_contact');
694: