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

Line 132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

128: --
129: -- DESCRIPTION
130: -- Create customer account contact business object.
131: PROCEDURE do_create_cac_bo(
132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
133: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
134: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
135: p_created_by_module IN VARCHAR2,
136: p_obj_source IN VARCHAR2 := null,

Line 133: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

129: -- DESCRIPTION
130: -- Create customer account contact business object.
131: PROCEDURE do_create_cac_bo(
132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
133: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
134: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
135: p_created_by_module IN VARCHAR2,
136: p_obj_source IN VARCHAR2 := null,
137: x_return_status OUT NOCOPY VARCHAR2,

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: -- Standard start of API savepoint
203: SAVEPOINT do_create_cac_bo_pub;
204:
205: -- initialize API return status to success.
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: -- Initialize message list if p_init_msg_list is set to TRUE.
209: IF FND_API.to_Boolean(p_init_msg_list) THEN
210: FND_MSG_PUB.initialize;

Line 209: IF FND_API.to_Boolean(p_init_msg_list) THEN

205: -- initialize API return status to success.
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: -- Initialize message list if p_init_msg_list is set to TRUE.
209: IF FND_API.to_Boolean(p_init_msg_list) THEN
210: FND_MSG_PUB.initialize;
211: END IF;
212:
213: -- initialize Global variable

Line 229: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

225: p_msg_level=>fnd_log.level_procedure);
226: END IF;
227:
228: -- Base on p_validate_bo_flag, check the completeness of business objects
229: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
230: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
231: p_bus_object_code => 'CUST_ACCT_CONTACT',
232: x_bus_object => l_bus_object
233: );

Line 239: RAISE fnd_api.g_exc_error;

235: p_cac_objs => HZ_CUST_ACCT_CONTACT_BO_TBL(p_cust_acct_contact_obj),
236: p_bus_object => l_bus_object
237: );
238: IF NOT(l_valid_obj) THEN
239: RAISE fnd_api.g_exc_error;
240: END IF;
241: END IF;
242:
243: -- check pass in parent_id and parent_os+osr

Line 253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

249: x_return_status => x_return_status,
250: x_msg_count => x_msg_count,
251: x_msg_data => x_msg_data);
252:
253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: x_cust_acct_contact_id := p_cust_acct_contact_obj.cust_acct_contact_id;

Line 254: RAISE FND_API.G_EXC_ERROR;

250: x_msg_count => x_msg_count,
251: x_msg_data => x_msg_data);
252:
253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: x_cust_acct_contact_id := p_cust_acct_contact_obj.cust_acct_contact_id;
258: x_cust_acct_contact_os := p_cust_acct_contact_obj.orig_system;

Line 273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

269: x_return_status => x_return_status,
270: x_msg_count => x_msg_count,
271: x_msg_data => x_msg_data);
272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: -- From px_parent_id, get parent party_id

Line 274: RAISE FND_API.G_EXC_ERROR;

270: x_msg_count => x_msg_count,
271: x_msg_data => x_msg_data);
272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: -- From px_parent_id, get parent party_id
278:

Line 313: RAISE FND_API.G_EXC_ERROR;

309: FND_MESSAGE.SET_TOKEN('FK','RELATIONSHIP');
310: FND_MESSAGE.SET_TOKEN('COLUMN','RELATIONSHIIP_ID, RELATIONSHIP_CODE, RELATIONSHIP_TYPE');
311: FND_MESSAGE.SET_TOKEN('TABLE','HZ_RELATIONSHIPS');
312: FND_MSG_PUB.ADD();
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: ----------------------------------
317: -- Assign cust account role record

Line 340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data
338: );
339:
340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
344: -- assign cust_acct_contact_id

Line 341: RAISE FND_API.G_EXC_ERROR;

337: x_msg_data => x_msg_data
338: );
339:
340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
344: -- assign cust_acct_contact_id
345: p_cust_acct_contact_obj.cust_acct_contact_id := x_cust_acct_contact_id;

Line 359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data
357: );
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: END IF;
363:

Line 360: RAISE FND_API.G_EXC_ERROR;

356: x_msg_data => x_msg_data
357: );
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: END IF;
363:
364: -- reset Global variable

Line 382: WHEN fnd_api.g_exc_error THEN

378: p_msg_level=>fnd_log.level_procedure);
379: END IF;
380:
381: EXCEPTION
382: WHEN fnd_api.g_exc_error THEN
383: ROLLBACK TO do_create_cac_bo_pub;
384:
385: -- reset Global variable
386: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 393: x_return_status := fnd_api.g_ret_sts_error;

389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
390: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
391: FND_MSG_PUB.ADD;
392:
393: x_return_status := fnd_api.g_ret_sts_error;
394:
395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
396: p_count => x_msg_count,
397: p_data => x_msg_data);

Line 395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

391: FND_MSG_PUB.ADD;
392:
393: x_return_status := fnd_api.g_ret_sts_error;
394:
395: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
396: p_count => x_msg_count,
397: p_data => x_msg_data);
398:
399: -- Debug info.

Line 412: WHEN fnd_api.g_exc_unexpected_error THEN

408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;
411:
412: WHEN fnd_api.g_exc_unexpected_error THEN
413: ROLLBACK TO do_create_cac_bo_pub;
414:
415: -- reset Global variable
416: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 423: x_return_status := fnd_api.g_ret_sts_unexp_error;

419: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
420: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
421: FND_MSG_PUB.ADD;
422:
423: x_return_status := fnd_api.g_ret_sts_unexp_error;
424:
425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
426: p_count => x_msg_count,
427: p_data => x_msg_data);

Line 425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

421: FND_MSG_PUB.ADD;
422:
423: x_return_status := fnd_api.g_ret_sts_unexp_error;
424:
425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
426: p_count => x_msg_count,
427: p_data => x_msg_data);
428:
429: -- Debug info.

Line 453: x_return_status := fnd_api.g_ret_sts_unexp_error;

449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
450: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
451: FND_MSG_PUB.ADD;
452:
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454:
455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
456: fnd_message.set_token('ERROR' ,SQLERRM);
457: fnd_msg_pub.add;

Line 459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
456: fnd_message.set_token('ERROR' ,SQLERRM);
457: fnd_msg_pub.add;
458:
459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data);
462:
463: -- Debug info.

Line 478: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

474: END IF;
475: END do_create_cac_bo;
476:
477: PROCEDURE create_cust_acct_contact_bo(
478: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
479: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
480: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
481: p_created_by_module IN VARCHAR2,
482: x_return_status OUT NOCOPY VARCHAR2,

Line 479: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

475: END do_create_cac_bo;
476:
477: PROCEDURE create_cust_acct_contact_bo(
478: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
479: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
480: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
481: p_created_by_module IN VARCHAR2,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,

Line 516: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

512: );
513: END create_cust_acct_contact_bo;
514:
515: PROCEDURE create_cust_acct_contact_bo(
516: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
517: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
518: p_created_by_module IN VARCHAR2,
519: p_obj_source IN VARCHAR2 := null,
520: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 520: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

516: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
517: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
518: p_created_by_module IN VARCHAR2,
519: p_obj_source IN VARCHAR2 := null,
520: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
523: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
524: x_cust_acct_contact_id OUT NOCOPY NUMBER,

Line 538: p_init_msg_list => fnd_api.g_true,

534: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
535: BEGIN
536: l_cac_obj := p_cust_acct_contact_obj;
537: do_create_cac_bo(
538: p_init_msg_list => fnd_api.g_true,
539: p_validate_bo_flag => p_validate_bo_flag,
540: p_cust_acct_contact_obj => l_cac_obj,
541: p_created_by_module => p_created_by_module,
542: p_obj_source => null,

Line 558: IF FND_API.to_Boolean(p_return_obj_flag) THEN

554: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
555: x_return_status => x_return_status,
556: x_msg_count => l_msg_count,
557: x_msg_data => l_msg_data);
558: IF FND_API.to_Boolean(p_return_obj_flag) THEN
559: x_return_obj := l_cac_obj;
560: END IF;
561: END create_cust_acct_contact_bo;
562:

Line 568: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

564: --
565: -- DESCRIPTION
566: -- Update customer account contact business object.
567: PROCEDURE update_cust_acct_contact_bo(
568: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
569: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
570: p_created_by_module IN VARCHAR2,
571: x_return_status OUT NOCOPY VARCHAR2,
572: x_msg_count OUT NOCOPY NUMBER,

Line 600: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

596: PROCEDURE update_cust_acct_contact_bo(
597: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
598: p_created_by_module IN VARCHAR2,
599: p_obj_source IN VARCHAR2 := null,
600: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
603: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
604: x_cust_acct_contact_id OUT NOCOPY NUMBER,

Line 614: p_init_msg_list => fnd_api.g_true,

610: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
611: BEGIN
612: l_cac_obj := p_cust_acct_contact_obj;
613: do_update_cac_bo(
614: p_init_msg_list => fnd_api.g_true,
615: p_cust_acct_contact_obj => l_cac_obj,
616: p_created_by_module => p_created_by_module,
617: p_obj_source => p_obj_source,
618: x_return_status => x_return_status,

Line 630: IF FND_API.to_Boolean(p_return_obj_flag) THEN

626: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
627: x_return_status => x_return_status,
628: x_msg_count => l_msg_count,
629: x_msg_data => l_msg_data);
630: IF FND_API.to_Boolean(p_return_obj_flag) THEN
631: x_return_obj := l_cac_obj;
632: END IF;
633: END update_cust_acct_contact_bo;
634:

Line 636: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

632: END IF;
633: END update_cust_acct_contact_bo;
634:
635: PROCEDURE do_update_cac_bo(
636: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
637: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
638: p_created_by_module IN VARCHAR2,
639: p_obj_source IN VARCHAR2 := null,
640: x_return_status OUT NOCOPY VARCHAR2,

Line 672: x_return_status := FND_API.G_RET_STS_SUCCESS;

668: -- SAVEPOINT update_logical_cac_pub;
669: SAVEPOINT do_update_cac_bo_pub;
670:
671: -- initialize API return status to success.
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: -- Initialize message list if p_init_msg_list is set to TRUE.
675: IF FND_API.to_Boolean(p_init_msg_list) THEN
676: FND_MSG_PUB.initialize;

Line 675: IF FND_API.to_Boolean(p_init_msg_list) THEN

671: -- initialize API return status to success.
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: -- Initialize message list if p_init_msg_list is set to TRUE.
675: IF FND_API.to_Boolean(p_init_msg_list) THEN
676: FND_MSG_PUB.initialize;
677: END IF;
678:
679: -- initialize Global variable

Line 709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

705: x_return_status => x_return_status,
706: x_msg_count => x_msg_count,
707: x_msg_data => x_msg_data);
708:
709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: OPEN get_ovn(x_cust_acct_contact_id);

Line 710: RAISE FND_API.G_EXC_ERROR;

706: x_msg_count => x_msg_count,
707: x_msg_data => x_msg_data);
708:
709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: OPEN get_ovn(x_cust_acct_contact_id);
714: FETCH get_ovn INTO l_car_ovn, l_party_id, l_ca_id, l_cas_id;

Line 740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data
738: );
739:
740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: -- assign cust_acct_contact_id

Line 741: RAISE FND_API.G_EXC_ERROR;

737: x_msg_data => x_msg_data
738: );
739:
740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: -- assign cust_acct_contact_id
745: p_cust_acct_contact_obj.cust_acct_contact_id := x_cust_acct_contact_id;

Line 759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data
757: );
758:
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763:

Line 760: RAISE FND_API.G_EXC_ERROR;

756: x_msg_data => x_msg_data
757: );
758:
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763:
764: -- reset Global variable

Line 781: WHEN fnd_api.g_exc_error THEN

777: p_prefix=>l_debug_prefix,
778: p_msg_level=>fnd_log.level_procedure);
779: END IF;
780: EXCEPTION
781: WHEN fnd_api.g_exc_error THEN
782: ROLLBACK TO do_update_cac_bo_pub;
783:
784: -- reset Global variable
785: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 792: x_return_status := fnd_api.g_ret_sts_error;

788: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
789: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
790: FND_MSG_PUB.ADD;
791:
792: x_return_status := fnd_api.g_ret_sts_error;
793:
794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data);

Line 794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

790: FND_MSG_PUB.ADD;
791:
792: x_return_status := fnd_api.g_ret_sts_error;
793:
794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data);
797:
798: -- Debug info.

Line 811: WHEN fnd_api.g_exc_unexpected_error THEN

807: p_prefix=>l_debug_prefix,
808: p_msg_level=>fnd_log.level_procedure);
809: END IF;
810:
811: WHEN fnd_api.g_exc_unexpected_error THEN
812: ROLLBACK TO do_update_cac_bo_pub;
813:
814: -- reset Global variable
815: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 822: x_return_status := fnd_api.g_ret_sts_unexp_error;

818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
819: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
820: FND_MSG_PUB.ADD;
821:
822: x_return_status := fnd_api.g_ret_sts_unexp_error;
823:
824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
825: p_count => x_msg_count,
826: p_data => x_msg_data);

Line 824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

820: FND_MSG_PUB.ADD;
821:
822: x_return_status := fnd_api.g_ret_sts_unexp_error;
823:
824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
825: p_count => x_msg_count,
826: p_data => x_msg_data);
827:
828: -- Debug info.

Line 852: x_return_status := fnd_api.g_ret_sts_unexp_error;

848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
849: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
850: FND_MSG_PUB.ADD;
851:
852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853:
854: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
855: fnd_message.set_token('ERROR' ,SQLERRM);
856: fnd_msg_pub.add;

Line 858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

854: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
855: fnd_message.set_token('ERROR' ,SQLERRM);
856: fnd_msg_pub.add;
857:
858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: -- Debug info.

Line 881: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

877: --
878: -- DESCRIPTION
879: -- Create or update customer account contact business object.
880: PROCEDURE do_save_cac_bo(
881: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
882: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
883: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
884: p_created_by_module IN VARCHAR2,
885: p_obj_source IN VARCHAR2 := null,

Line 882: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

878: -- DESCRIPTION
879: -- Create or update customer account contact business object.
880: PROCEDURE do_save_cac_bo(
881: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
882: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
883: p_cust_acct_contact_obj IN OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
884: p_created_by_module IN VARCHAR2,
885: p_obj_source IN VARCHAR2 := null,
886: x_return_status OUT NOCOPY VARCHAR2,

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: l_create_update_flag VARCHAR2(1);
901: l_debug_prefix VARCHAR2(30) := '';
902: BEGIN
903: -- initialize API return status to success.
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: -- Initialize message list if p_init_msg_list is set to TRUE.
907: IF FND_API.to_Boolean(p_init_msg_list) THEN
908: FND_MSG_PUB.initialize;

Line 907: IF FND_API.to_Boolean(p_init_msg_list) THEN

903: -- initialize API return status to success.
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: -- Initialize message list if p_init_msg_list is set to TRUE.
907: IF FND_API.to_Boolean(p_init_msg_list) THEN
908: FND_MSG_PUB.initialize;
909: END IF;
910:
911: -- Debug info.

Line 937: RAISE FND_API.G_EXC_ERROR;

933: IF(l_create_update_flag = 'E') THEN
934: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
935: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_CONTACT');
936: FND_MSG_PUB.ADD;
937: RAISE FND_API.G_EXC_ERROR;
938: END IF;
939:
940: IF(l_create_update_flag = 'C') THEN
941: do_create_cac_bo(

Line 942: p_init_msg_list => fnd_api.g_false,

938: END IF;
939:
940: IF(l_create_update_flag = 'C') THEN
941: do_create_cac_bo(
942: p_init_msg_list => fnd_api.g_false,
943: p_validate_bo_flag => p_validate_bo_flag,
944: p_cust_acct_contact_obj => p_cust_acct_contact_obj,
945: p_created_by_module => p_created_by_module,
946: p_obj_source => p_obj_source,

Line 960: p_init_msg_list => fnd_api.g_false,

956: px_parent_obj_type => px_parent_obj_type
957: );
958: ELSIF(l_create_update_flag = 'U') THEN
959: do_update_cac_bo(
960: p_init_msg_list => fnd_api.g_false,
961: p_cust_acct_contact_obj => p_cust_acct_contact_obj,
962: p_created_by_module => p_created_by_module,
963: p_obj_source => p_obj_source,
964: x_return_status => x_return_status,

Line 973: RAISE FND_API.G_EXC_ERROR;

969: x_cust_acct_contact_osr => x_cust_acct_contact_osr,
970: p_parent_os => px_parent_os
971: );
972: ELSE
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975:
976: -- Debug info.
977: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 990: WHEN fnd_api.g_exc_error THEN

986: p_msg_level=>fnd_log.level_procedure);
987: END IF;
988:
989: EXCEPTION
990: WHEN fnd_api.g_exc_error THEN
991: x_return_status := fnd_api.g_ret_sts_error;
992:
993: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
994: FND_MSG_PUB.ADD;

Line 991: x_return_status := fnd_api.g_ret_sts_error;

987: END IF;
988:
989: EXCEPTION
990: WHEN fnd_api.g_exc_error THEN
991: x_return_status := fnd_api.g_ret_sts_error;
992:
993: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
994: FND_MSG_PUB.ADD;
995: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 995: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

991: x_return_status := fnd_api.g_ret_sts_error;
992:
993: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
994: FND_MSG_PUB.ADD;
995: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:
999: -- Debug info.

Line 1011: WHEN fnd_api.g_exc_unexpected_error THEN

1007: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1008: p_prefix=>l_debug_prefix,
1009: p_msg_level=>fnd_log.level_procedure);
1010: END IF;
1011: WHEN fnd_api.g_exc_unexpected_error THEN
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013:
1014: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1015: p_count => x_msg_count,

Line 1012: x_return_status := fnd_api.g_ret_sts_unexp_error;

1008: p_prefix=>l_debug_prefix,
1009: p_msg_level=>fnd_log.level_procedure);
1010: END IF;
1011: WHEN fnd_api.g_exc_unexpected_error THEN
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013:
1014: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data);

Line 1014: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1010: END IF;
1011: WHEN fnd_api.g_exc_unexpected_error THEN
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013:
1014: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data);
1017:
1018: -- Debug info.

Line 1031: x_return_status := fnd_api.g_ret_sts_unexp_error;

1027: p_prefix=>l_debug_prefix,
1028: p_msg_level=>fnd_log.level_procedure);
1029: END IF;
1030: WHEN OTHERS THEN
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032:
1033: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1034: fnd_message.set_token('ERROR' ,SQLERRM);
1035: fnd_msg_pub.add;

Line 1037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1033: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1034: fnd_message.set_token('ERROR' ,SQLERRM);
1035: fnd_msg_pub.add;
1036:
1037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1038: p_count => x_msg_count,
1039: p_data => x_msg_data);
1040:
1041: -- Debug info.

Line 1056: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1052: END IF;
1053: END do_save_cac_bo;
1054:
1055: PROCEDURE save_cust_acct_contact_bo(
1056: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1057: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1058: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1059: p_created_by_module IN VARCHAR2,
1060: x_return_status OUT NOCOPY VARCHAR2,

Line 1057: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1053: END do_save_cac_bo;
1054:
1055: PROCEDURE save_cust_acct_contact_bo(
1056: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1057: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1058: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1059: p_created_by_module IN VARCHAR2,
1060: x_return_status OUT NOCOPY VARCHAR2,
1061: x_msg_count OUT NOCOPY NUMBER,

Line 1093: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1089: );
1090: END save_cust_acct_contact_bo;
1091:
1092: PROCEDURE save_cust_acct_contact_bo(
1093: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1094: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1095: p_created_by_module IN VARCHAR2,
1096: p_obj_source IN VARCHAR2 := null,
1097: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 1097: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

1093: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1094: p_cust_acct_contact_obj IN HZ_CUST_ACCT_CONTACT_BO,
1095: p_created_by_module IN VARCHAR2,
1096: p_obj_source IN VARCHAR2 := null,
1097: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1100: x_return_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,
1101: x_cust_acct_contact_id OUT NOCOPY NUMBER,

Line 1115: p_init_msg_list => fnd_api.g_true,

1111: l_cac_obj HZ_CUST_ACCT_CONTACT_BO;
1112: BEGIN
1113: l_cac_obj := p_cust_acct_contact_obj;
1114: do_save_cac_bo(
1115: p_init_msg_list => fnd_api.g_true,
1116: p_validate_bo_flag => p_validate_bo_flag,
1117: p_cust_acct_contact_obj => l_cac_obj,
1118: p_created_by_module => p_created_by_module,
1119: x_return_status => x_return_status,

Line 1134: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1130: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1131: x_return_status => x_return_status,
1132: x_msg_count => l_msg_count,
1133: x_msg_data => l_msg_data);
1134: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1135: x_return_obj := l_cac_obj;
1136: END IF;
1137: END save_cust_acct_contact_bo;
1138:

Line 1153: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

1149: -- IN:
1150: -- p_init_msg_list Initialize message stack if it is set to
1151: -- p_parent_id parent id.
1152: -- p_cust_acct_contact_id customer account contact ID.
1153: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1154: -- OUT:
1155: -- x_cust_acct_contact_objs Logical customer account contact records.
1156: -- x_return_status Return status after the call. The status can
1157: -- be fnd_api.g_ret_sts_success (success),

Line 1157: -- be fnd_api.g_ret_sts_success (success),

1153: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1154: -- OUT:
1155: -- x_cust_acct_contact_objs Logical customer account contact records.
1156: -- x_return_status Return status after the call. The status can
1157: -- be fnd_api.g_ret_sts_success (success),
1158: -- fnd_api.g_ret_sts_error (error),
1159: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1160: -- x_msg_count Number of messages in message stack.
1161: -- x_msg_data Message text if x_msg_count is 1.

Line 1158: -- fnd_api.g_ret_sts_error (error),

1154: -- OUT:
1155: -- x_cust_acct_contact_objs Logical customer account contact records.
1156: -- x_return_status Return status after the call. The status can
1157: -- be fnd_api.g_ret_sts_success (success),
1158: -- fnd_api.g_ret_sts_error (error),
1159: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1160: -- x_msg_count Number of messages in message stack.
1161: -- x_msg_data Message text if x_msg_count is 1.
1162: --

Line 1159: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1155: -- x_cust_acct_contact_objs Logical customer account contact records.
1156: -- x_return_status Return status after the call. The status can
1157: -- be fnd_api.g_ret_sts_success (success),
1158: -- fnd_api.g_ret_sts_error (error),
1159: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1160: -- x_msg_count Number of messages in message stack.
1161: -- x_msg_data Message text if x_msg_count is 1.
1162: --
1163: -- NOTES

Line 1197: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

1193: */
1194:
1195:
1196: PROCEDURE get_cust_acct_contact_bo (
1197: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
1198: p_cust_acct_contact_id IN NUMBER,
1199: p_cust_acct_contact_os IN VARCHAR2,
1200: p_cust_acct_contact_osr IN VARCHAR2,
1201: x_cust_acct_contact_obj OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO,

Line 1215: x_return_status := FND_API.G_RET_STS_SUCCESS;

1211: l_cust_acct_contact_objs HZ_CUST_ACCT_CONTACT_BO_TBL;
1212: BEGIN
1213:
1214: -- initialize API return status to success.
1215: x_return_status := FND_API.G_RET_STS_SUCCESS;
1216:
1217: -- Initialize message list if p_init_msg_list is set to TRUE
1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;

Line 1218: IF FND_API.to_Boolean(p_init_msg_list) THEN

1214: -- initialize API return status to success.
1215: x_return_status := FND_API.G_RET_STS_SUCCESS;
1216:
1217: -- Initialize message list if p_init_msg_list is set to TRUE
1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221:
1222:

Line 1246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1242: x_return_status => x_return_status,
1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data);
1245:
1246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:
1250: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos

Line 1247: RAISE fnd_api.g_exc_error;

1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data);
1245:
1246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:
1250: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos
1251: (p_init_msg_list => fnd_api.g_false,

Line 1251: (p_init_msg_list => fnd_api.g_false,

1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:
1250: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos
1251: (p_init_msg_list => fnd_api.g_false,
1252: p_parent_id => NULL,
1253: p_cust_acct_contact_id => l_cust_acct_contact_id,
1254: p_action_type => NULL,
1255: x_cust_acct_contact_objs => l_cust_acct_contact_objs,

Line 1262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1258: x_msg_data => x_msg_data);
1259:
1260: x_cust_acct_contact_obj := l_cust_acct_contact_objs(1);
1261:
1262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265:
1266:

Line 1263: RAISE FND_API.G_EXC_ERROR;

1259:
1260: x_cust_acct_contact_obj := l_cust_acct_contact_objs(1);
1261:
1262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265:
1266:
1267: -- Debug info.

Line 1285: WHEN fnd_api.g_exc_error THEN

1281:
1282:
1283: EXCEPTION
1284:
1285: WHEN fnd_api.g_exc_error THEN
1286: x_return_status := fnd_api.g_ret_sts_error;
1287:
1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1289: p_count => x_msg_count,

Line 1286: x_return_status := fnd_api.g_ret_sts_error;

1282:
1283: EXCEPTION
1284:
1285: WHEN fnd_api.g_exc_error THEN
1286: x_return_status := fnd_api.g_ret_sts_error;
1287:
1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data);

Line 1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1284:
1285: WHEN fnd_api.g_exc_error THEN
1286: x_return_status := fnd_api.g_ret_sts_error;
1287:
1288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data);
1291:
1292: -- Debug info.

Line 1304: WHEN fnd_api.g_exc_unexpected_error THEN

1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304: WHEN fnd_api.g_exc_unexpected_error THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1308: p_count => x_msg_count,

Line 1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304: WHEN fnd_api.g_exc_unexpected_error THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);

Line 1307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1303: END IF;
1304: WHEN fnd_api.g_exc_unexpected_error THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310:
1311: -- Debug info.

Line 1324: x_return_status := fnd_api.g_ret_sts_unexp_error;

1320: p_prefix=>l_debug_prefix,
1321: p_msg_level=>fnd_log.level_procedure);
1322: END IF;
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.g_ret_sts_unexp_error;
1325:
1326: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1327: fnd_message.set_token('ERROR' ,SQLERRM);
1328: fnd_msg_pub.add;

Line 1330: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1326: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1327: fnd_message.set_token('ERROR' ,SQLERRM);
1328: fnd_msg_pub.add;
1329:
1330: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data);
1333:
1334: -- Debug info.

Line 1361: p_init_msg_list => FND_API.G_TRUE,

1357: l_msg_data VARCHAR2(2000);
1358: l_msg_count NUMBER;
1359: BEGIN
1360: get_cust_acct_contact_bo (
1361: p_init_msg_list => FND_API.G_TRUE,
1362: p_cust_acct_contact_id => p_cust_acct_contact_id,
1363: p_cust_acct_contact_os => p_cust_acct_contact_os,
1364: p_cust_acct_contact_osr => p_cust_acct_contact_osr,
1365: x_cust_acct_contact_obj => x_cust_acct_contact_obj,