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

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

193: --
194: -- DESCRIPTION
195: -- Create customer account business object.
196: PROCEDURE do_create_cust_acct_bo(
197: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
198: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
199: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
200: p_created_by_module IN VARCHAR2,
201: p_obj_source IN VARCHAR2 := null,

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

194: -- DESCRIPTION
195: -- Create customer account business object.
196: PROCEDURE do_create_cust_acct_bo(
197: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
198: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
199: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
200: p_created_by_module IN VARCHAR2,
201: p_obj_source IN VARCHAR2 := null,
202: x_return_status OUT NOCOPY VARCHAR2,

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: -- Standard start of API savepoint
234: SAVEPOINT do_create_cust_acct_bo_pub;
235:
236: -- initialize API return status to success.
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240: IF FND_API.to_Boolean(p_init_msg_list) THEN
241: FND_MSG_PUB.initialize;

Line 240: IF FND_API.to_Boolean(p_init_msg_list) THEN

236: -- initialize API return status to success.
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240: IF FND_API.to_Boolean(p_init_msg_list) THEN
241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- initialize Global variable

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

256: p_msg_level=>fnd_log.level_procedure);
257: END IF;
258:
259: -- Base on p_validate_bo_flag, check the completeness of business objects
260: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
261: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
262: p_bus_object_code => 'CUST_ACCT',
263: x_bus_object => l_bus_object
264: );

Line 270: RAISE fnd_api.g_exc_error;

266: p_ca_objs => HZ_CUST_ACCT_BO_TBL(p_cust_acct_obj),
267: p_bus_object => l_bus_object
268: );
269: IF NOT(l_valid_obj) THEN
270: RAISE fnd_api.g_exc_error;
271: END IF;
272: END IF;
273:
274: -- check pass in parent_id and parent_os+osr

Line 284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

280: x_return_status => x_return_status,
281: x_msg_count => x_msg_count,
282: x_msg_data => x_msg_data);
283:
284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287:
288: x_cust_acct_id := p_cust_acct_obj.cust_acct_id;

Line 285: RAISE FND_API.G_EXC_ERROR;

281: x_msg_count => x_msg_count,
282: x_msg_data => x_msg_data);
283:
284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287:
288: x_cust_acct_id := p_cust_acct_obj.cust_acct_id;
289: x_cust_acct_os := p_cust_acct_obj.orig_system;

Line 303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

299: x_return_status => x_return_status,
300: x_msg_count => x_msg_count,
301: x_msg_data => x_msg_data);
302:
303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306:
307: assign_cust_acct_rec(

Line 304: RAISE FND_API.G_EXC_ERROR;

300: x_msg_count => x_msg_count,
301: x_msg_data => x_msg_data);
302:
303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306:
307: assign_cust_acct_rec(
308: p_cust_acct_obj => p_cust_acct_obj,

Line 319: RAISE FND_API.G_EXC_ERROR;

315: IF(p_cust_acct_obj.cust_profile_obj IS NULL) THEN
316: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
317: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
318: fnd_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
321:
322: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
323: p_cust_profile_obj => p_cust_acct_obj.cust_profile_obj,

Line 331: -- therefore set p_create_profile_amt to FND_API.G_FALSE

327: );
328:
329: -- set party_id to party record
330: -- profile amount will be created after creating cust account
331: -- therefore set p_create_profile_amt to FND_API.G_FALSE
332: IF(px_parent_obj_type = 'ORG') THEN
333: l_organization_rec.party_rec.party_id := px_parent_id;
334: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
335: p_cust_account_rec => l_cust_acct_rec,

Line 338: p_create_profile_amt => FND_API.G_FALSE,

334: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
335: p_cust_account_rec => l_cust_acct_rec,
336: p_organization_rec => l_organization_rec,
337: p_customer_profile_rec => l_profile_rec,
338: p_create_profile_amt => FND_API.G_FALSE,
339: x_cust_account_id => x_cust_acct_id,
340: x_account_number => l_account_number,
341: x_party_id => l_party_id,
342: x_party_number => l_party_number,

Line 354: p_create_profile_amt => FND_API.G_FALSE,

350: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
351: p_cust_account_rec => l_cust_acct_rec,
352: p_person_rec => l_person_rec,
353: p_customer_profile_rec => l_profile_rec,
354: p_create_profile_amt => FND_API.G_FALSE,
355: x_cust_account_id => x_cust_acct_id,
356: x_account_number => l_account_number,
357: x_party_id => l_party_id,
358: x_party_number => l_party_number,

Line 366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

362: x_msg_data => x_msg_data
363: );
364: END IF;
365:
366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370: OPEN get_cust_acct_profile_id(x_cust_acct_id);

Line 367: RAISE FND_API.G_EXC_ERROR;

363: );
364: END IF;
365:
366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370: OPEN get_cust_acct_profile_id(x_cust_acct_id);
371: FETCH get_cust_acct_profile_id INTO l_cust_acct_profile_id;

Line 392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

388: x_msg_count => x_msg_count,
389: x_msg_data => x_msg_data
390: );
391:
392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: END IF;
396:

Line 393: RAISE FND_API.G_EXC_ERROR;

389: x_msg_data => x_msg_data
390: );
391:
392: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: END IF;
396:
397: -------------------------------------

Line 410: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

406: x_msg_count => x_msg_count,
407: x_msg_data => x_msg_data
408: );
409:
410: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413: END IF;
414:

Line 411: RAISE FND_API.G_EXC_ERROR;

407: x_msg_data => x_msg_data
408: );
409:
410: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413: END IF;
414:
415: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

433: p_parent_osr => x_cust_acct_osr,
434: p_parent_obj_type => 'CUST_ACCT'
435: );
436:
437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:

Line 438: RAISE FND_API.G_EXC_ERROR;

434: p_parent_obj_type => 'CUST_ACCT'
435: );
436:
437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:
442: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 463: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

459: p_parent_acct_os => x_cust_acct_os,
460: p_parent_acct_osr => x_cust_acct_osr
461: );
462:
463: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:

Line 464: RAISE FND_API.G_EXC_ERROR;

460: p_parent_acct_osr => x_cust_acct_osr
461: );
462:
463: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:
468: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data
483: );
484:
485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: END IF;
489:

Line 486: RAISE FND_API.G_EXC_ERROR;

482: x_msg_data => x_msg_data
483: );
484:
485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: END IF;
489:
490: ------------------------

Line 503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

499: x_msg_count => x_msg_count,
500: x_msg_data => x_msg_data
501: );
502:
503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506: END IF;
507:

Line 504: RAISE FND_API.G_EXC_ERROR;

500: x_msg_data => x_msg_data
501: );
502:
503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506: END IF;
507:
508: -- reset Global variable

Line 526: WHEN fnd_api.g_exc_error THEN

522: p_msg_level=>fnd_log.level_procedure);
523: END IF;
524:
525: EXCEPTION
526: WHEN fnd_api.g_exc_error THEN
527: ROLLBACK TO do_create_cust_acct_bo_pub;
528:
529: -- reset Global variable
530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 537: x_return_status := fnd_api.g_ret_sts_error;

533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
534: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
535: FND_MSG_PUB.ADD;
536:
537: x_return_status := fnd_api.g_ret_sts_error;
538:
539: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
540: p_count => x_msg_count,
541: p_data => x_msg_data);

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

535: FND_MSG_PUB.ADD;
536:
537: x_return_status := fnd_api.g_ret_sts_error;
538:
539: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
540: p_count => x_msg_count,
541: p_data => x_msg_data);
542:
543: -- Debug info.

Line 556: WHEN fnd_api.g_exc_unexpected_error THEN

552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;
555:
556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO do_create_cust_acct_bo_pub;
558:
559: -- reset Global variable
560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 567: x_return_status := fnd_api.g_ret_sts_unexp_error;

563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
564: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
565: FND_MSG_PUB.ADD;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568:
569: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data);

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

565: FND_MSG_PUB.ADD;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568:
569: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data);
572:
573: -- Debug info.

Line 597: x_return_status := fnd_api.g_ret_sts_unexp_error;

593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
594: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
595: FND_MSG_PUB.ADD;
596:
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598:
599: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
600: fnd_message.set_token('ERROR' ,SQLERRM);
601: fnd_msg_pub.add;

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

599: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
600: fnd_message.set_token('ERROR' ,SQLERRM);
601: fnd_msg_pub.add;
602:
603: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data);
606:
607: -- Debug info.

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

618: END IF;
619: END do_create_cust_acct_bo;
620:
621: PROCEDURE create_cust_acct_bo(
622: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
623: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
624: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
625: p_created_by_module IN VARCHAR2,
626: x_return_status OUT NOCOPY VARCHAR2,

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

619: END do_create_cust_acct_bo;
620:
621: PROCEDURE create_cust_acct_bo(
622: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
623: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
624: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
625: p_created_by_module IN VARCHAR2,
626: x_return_status OUT NOCOPY VARCHAR2,
627: x_msg_count OUT NOCOPY NUMBER,

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

656: );
657: END create_cust_acct_bo;
658:
659: PROCEDURE create_cust_acct_bo(
660: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
661: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
662: p_created_by_module IN VARCHAR2,
663: p_obj_source IN VARCHAR2 := null,
664: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

660: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
661: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
662: p_created_by_module IN VARCHAR2,
663: p_obj_source IN VARCHAR2 := null,
664: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
667: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
668: x_cust_acct_id OUT NOCOPY NUMBER,

Line 682: p_init_msg_list => fnd_api.g_true,

678: l_ca_obj HZ_CUST_ACCT_BO;
679: BEGIN
680: l_ca_obj := p_cust_acct_obj;
681: do_create_cust_acct_bo(
682: p_init_msg_list => fnd_api.g_true,
683: p_validate_bo_flag => p_validate_bo_flag,
684: p_cust_acct_obj => l_ca_obj,
685: p_created_by_module => p_created_by_module,
686: p_obj_source => p_obj_source,

Line 702: IF FND_API.to_Boolean(p_return_obj_flag) THEN

698: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
699: x_return_status => x_return_status,
700: x_msg_count => l_msg_count,
701: x_msg_data => l_msg_data);
702: IF FND_API.to_Boolean(p_return_obj_flag) THEN
703: x_return_obj := l_ca_obj;
704: END IF;
705: END create_cust_acct_bo;
706:

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

704: END IF;
705: END create_cust_acct_bo;
706:
707: PROCEDURE update_cust_acct_bo(
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
709: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
710: p_created_by_module IN VARCHAR2,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,

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

736: PROCEDURE update_cust_acct_bo(
737: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
738: p_created_by_module IN VARCHAR2,
739: p_obj_source IN VARCHAR2 := null,
740: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
743: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
744: x_cust_acct_id OUT NOCOPY NUMBER,

Line 754: p_init_msg_list => fnd_api.g_true,

750: l_ca_obj HZ_CUST_ACCT_BO;
751: BEGIN
752: l_ca_obj := p_cust_acct_obj;
753: do_update_cust_acct_bo(
754: p_init_msg_list => fnd_api.g_true,
755: p_cust_acct_obj => l_ca_obj,
756: p_created_by_module => p_created_by_module,
757: p_obj_source => p_obj_source,
758: x_return_status => x_return_status,

Line 770: IF FND_API.to_Boolean(p_return_obj_flag) THEN

766: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
767: x_return_status => x_return_status,
768: x_msg_count => l_msg_count,
769: x_msg_data => l_msg_data);
770: IF FND_API.to_Boolean(p_return_obj_flag) THEN
771: x_return_obj := l_ca_obj;
772: END IF;
773: END update_cust_acct_bo;
774:

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

776: --
777: -- DESCRIPTION
778: -- Update customer account business object.
779: PROCEDURE do_update_cust_acct_bo(
780: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
781: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
782: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
783: p_created_by_module IN VARCHAR2,
784: p_obj_source IN VARCHAR2 := null,

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

777: -- DESCRIPTION
778: -- Update customer account business object.
779: PROCEDURE do_update_cust_acct_bo(
780: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
781: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
782: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
783: p_created_by_module IN VARCHAR2,
784: p_obj_source IN VARCHAR2 := null,
785: x_return_status OUT NOCOPY VARCHAR2,

Line 811: x_return_status := FND_API.G_RET_STS_SUCCESS;

807: -- Standard start of API savepoint
808: SAVEPOINT do_update_cust_acct_bo_pub;
809:
810: -- initialize API return status to success.
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean(p_init_msg_list) THEN
815: FND_MSG_PUB.initialize;

Line 814: IF FND_API.to_Boolean(p_init_msg_list) THEN

810: -- initialize API return status to success.
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean(p_init_msg_list) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- initialize Global variable

Line 851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

847: x_return_status => x_return_status,
848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data);
850:
851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: -- get object version number of customer acct

Line 852: RAISE FND_API.G_EXC_ERROR;

848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data);
850:
851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: -- get object version number of customer acct
856: OPEN get_ovn(x_cust_acct_id);

Line 877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data
875: );
876:
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: -- assign cust_acct_id

Line 878: RAISE FND_API.G_EXC_ERROR;

874: x_msg_data => x_msg_data
875: );
876:
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: -- assign cust_acct_id
882: p_cust_acct_obj.cust_acct_id := x_cust_acct_id;

Line 897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data
895: );
896:
897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: -- assign cust_acct_profile_id

Line 898: RAISE FND_API.G_EXC_ERROR;

894: x_msg_data => x_msg_data
895: );
896:
897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: -- assign cust_acct_profile_id
902: p_cust_acct_obj.cust_profile_obj.cust_acct_profile_id := l_cust_acct_profile_id;

Line 918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: x_msg_count => x_msg_count,
915: x_msg_data => x_msg_data
916: );
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: END IF;

Line 919: RAISE FND_API.G_EXC_ERROR;

915: x_msg_data => x_msg_data
916: );
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: END IF;
923:

Line 944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

940: p_parent_osr => x_cust_acct_osr,
941: p_parent_obj_type => 'CUST_ACCT'
942: );
943:
944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947: END IF;
948:

Line 945: RAISE FND_API.G_EXC_ERROR;

941: p_parent_obj_type => 'CUST_ACCT'
942: );
943:
944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947: END IF;
948:
949: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

960: x_msg_count => x_msg_count,
961: x_msg_data => x_msg_data
962: );
963:
964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967: END IF;
968:

Line 965: RAISE FND_API.G_EXC_ERROR;

961: x_msg_data => x_msg_data
962: );
963:
964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967: END IF;
968:
969: -------------------------------------

Line 988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

984: p_parent_acct_os => x_cust_acct_os,
985: p_parent_acct_osr => x_cust_acct_osr
986: );
987:
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991: END IF;
992:

Line 989: RAISE FND_API.G_EXC_ERROR;

985: p_parent_acct_osr => x_cust_acct_osr
986: );
987:
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991: END IF;
992:
993: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1010: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data
1008: );
1009:
1010: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: END IF;
1014:

Line 1011: RAISE FND_API.G_EXC_ERROR;

1007: x_msg_data => x_msg_data
1008: );
1009:
1010: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: END IF;
1014:
1015: ------------------------

Line 1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1024: x_msg_count => x_msg_count,
1025: x_msg_data => x_msg_data
1026: );
1027:
1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: END IF;
1032:

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: x_msg_data => x_msg_data
1026: );
1027:
1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: END IF;
1032:
1033: -- reset Global variable

Line 1050: WHEN fnd_api.g_exc_error THEN

1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1049: EXCEPTION
1050: WHEN fnd_api.g_exc_error THEN
1051: ROLLBACK TO do_update_cust_acct_bo_pub;
1052:
1053: -- reset Global variable
1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1061: x_return_status := fnd_api.g_ret_sts_error;

1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1058: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1059: FND_MSG_PUB.ADD;
1060:
1061: x_return_status := fnd_api.g_ret_sts_error;
1062:
1063: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1064: p_count => x_msg_count,
1065: p_data => x_msg_data);

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

1059: FND_MSG_PUB.ADD;
1060:
1061: x_return_status := fnd_api.g_ret_sts_error;
1062:
1063: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1064: p_count => x_msg_count,
1065: p_data => x_msg_data);
1066:
1067: -- Debug info.

Line 1080: WHEN fnd_api.g_exc_unexpected_error THEN

1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;
1079:
1080: WHEN fnd_api.g_exc_unexpected_error THEN
1081: ROLLBACK TO do_update_cust_acct_bo_pub;
1082:
1083: -- reset Global variable
1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1091: x_return_status := fnd_api.g_ret_sts_unexp_error;

1087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1088: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1089: FND_MSG_PUB.ADD;
1090:
1091: x_return_status := fnd_api.g_ret_sts_unexp_error;
1092:
1093: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1094: p_count => x_msg_count,
1095: p_data => x_msg_data);

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

1089: FND_MSG_PUB.ADD;
1090:
1091: x_return_status := fnd_api.g_ret_sts_unexp_error;
1092:
1093: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1094: p_count => x_msg_count,
1095: p_data => x_msg_data);
1096:
1097: -- Debug info.

Line 1121: x_return_status := fnd_api.g_ret_sts_unexp_error;

1117: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1118: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1119: FND_MSG_PUB.ADD;
1120:
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1124: fnd_message.set_token('ERROR' ,SQLERRM);
1125: fnd_msg_pub.add;

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

1123: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1124: fnd_message.set_token('ERROR' ,SQLERRM);
1125: fnd_msg_pub.add;
1126:
1127: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1128: p_count => x_msg_count,
1129: p_data => x_msg_data);
1130:
1131: -- Debug info.

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

1146: --
1147: -- DESCRIPTION
1148: -- Create or update customer account business object.
1149: PROCEDURE do_save_cust_acct_bo(
1150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1151: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1152: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
1153: p_created_by_module IN VARCHAR2,
1154: p_obj_source IN VARCHAR2 := null,

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

1147: -- DESCRIPTION
1148: -- Create or update customer account business object.
1149: PROCEDURE do_save_cust_acct_bo(
1150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1151: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1152: p_cust_acct_obj IN OUT NOCOPY HZ_CUST_ACCT_BO,
1153: p_created_by_module IN VARCHAR2,
1154: p_obj_source IN VARCHAR2 := null,
1155: x_return_status OUT NOCOPY VARCHAR2,

Line 1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

1169: l_create_update_flag VARCHAR2(1);
1170: l_debug_prefix VARCHAR2(30) := '';
1171: BEGIN
1172: -- initialize API return status to success.
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: -- Initialize message list if p_init_msg_list is set to TRUE.
1176: IF FND_API.to_Boolean(p_init_msg_list) THEN
1177: FND_MSG_PUB.initialize;

Line 1176: IF FND_API.to_Boolean(p_init_msg_list) THEN

1172: -- initialize API return status to success.
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: -- Initialize message list if p_init_msg_list is set to TRUE.
1176: IF FND_API.to_Boolean(p_init_msg_list) THEN
1177: FND_MSG_PUB.initialize;
1178: END IF;
1179:
1180: -- Debug info.

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: IF(l_create_update_flag = 'E') THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1204: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209: IF(l_create_update_flag = 'C') THEN
1210: do_create_cust_acct_bo(

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: x_cust_acct_osr => x_cust_acct_osr,
1237: p_parent_os => px_parent_os
1238: );
1239: ELSE
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: -- Debug info.
1244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1257: WHEN fnd_api.g_exc_error THEN

1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: x_return_status := fnd_api.g_ret_sts_error;
1259:
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
1261: FND_MSG_PUB.ADD;

Line 1258: x_return_status := fnd_api.g_ret_sts_error;

1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: x_return_status := fnd_api.g_ret_sts_error;
1259:
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
1261: FND_MSG_PUB.ADD;
1262: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1258: x_return_status := fnd_api.g_ret_sts_error;
1259:
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
1261: FND_MSG_PUB.ADD;
1262: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1263: p_count => x_msg_count,
1264: p_data => x_msg_data);
1265:
1266: -- Debug info.

Line 1278: WHEN fnd_api.g_exc_unexpected_error THEN

1274: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1275: p_prefix=>l_debug_prefix,
1276: p_msg_level=>fnd_log.level_procedure);
1277: END IF;
1278: WHEN fnd_api.g_exc_unexpected_error THEN
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280:
1281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1282: p_count => x_msg_count,

Line 1279: x_return_status := fnd_api.g_ret_sts_unexp_error;

1275: p_prefix=>l_debug_prefix,
1276: p_msg_level=>fnd_log.level_procedure);
1277: END IF;
1278: WHEN fnd_api.g_exc_unexpected_error THEN
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280:
1281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data);

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

1277: END IF;
1278: WHEN fnd_api.g_exc_unexpected_error THEN
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280:
1281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data);
1284:
1285: -- Debug info.

Line 1298: x_return_status := fnd_api.g_ret_sts_unexp_error;

1294: p_prefix=>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_procedure);
1296: END IF;
1297: WHEN OTHERS THEN
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1301: fnd_message.set_token('ERROR' ,SQLERRM);
1302: fnd_msg_pub.add;

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

1300: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1301: fnd_message.set_token('ERROR' ,SQLERRM);
1302: fnd_msg_pub.add;
1303:
1304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1305: p_count => x_msg_count,
1306: p_data => x_msg_data);
1307:
1308: -- Debug info.

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

1319: END IF;
1320: END do_save_cust_acct_bo;
1321:
1322: PROCEDURE save_cust_acct_bo(
1323: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1324: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1325: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1326: p_created_by_module IN VARCHAR2,
1327: x_return_status OUT NOCOPY VARCHAR2,

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

1320: END do_save_cust_acct_bo;
1321:
1322: PROCEDURE save_cust_acct_bo(
1323: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1324: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1325: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1326: p_created_by_module IN VARCHAR2,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,

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

1356: );
1357: END save_cust_acct_bo;
1358:
1359: PROCEDURE save_cust_acct_bo(
1360: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1361: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1362: p_created_by_module IN VARCHAR2,
1363: p_obj_source IN VARCHAR2 := null,
1364: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

1360: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1361: p_cust_acct_obj IN HZ_CUST_ACCT_BO,
1362: p_created_by_module IN VARCHAR2,
1363: p_obj_source IN VARCHAR2 := null,
1364: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1365: x_return_status OUT NOCOPY VARCHAR2,
1366: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1367: x_return_obj OUT NOCOPY HZ_CUST_ACCT_BO,
1368: x_cust_acct_id OUT NOCOPY NUMBER,

Line 1382: p_init_msg_list => fnd_api.g_true,

1378: l_ca_obj HZ_CUST_ACCT_BO;
1379: BEGIN
1380: l_ca_obj := p_cust_acct_obj;
1381: do_save_cust_acct_bo(
1382: p_init_msg_list => fnd_api.g_true,
1383: p_validate_bo_flag => p_validate_bo_flag,
1384: p_cust_acct_obj => l_ca_obj,
1385: p_created_by_module => p_created_by_module,
1386: x_return_status => x_return_status,

Line 1401: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1397: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1398: x_return_status => x_return_status,
1399: x_msg_count => l_msg_count,
1400: x_msg_data => l_msg_data);
1401: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1402: x_return_obj := l_ca_obj;
1403: END IF;
1404: END save_cust_acct_bo;
1405:

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

1416: -- IN:
1417: -- p_init_msg_list Initialize message stack if it is set to
1418: -- p_cust_acct_id customer account ID.
1419: -- p_parent_id Parent Id.
1420: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1421: -- OUT:
1422: -- x_cust_acct_obj Logical customer account record.
1423: -- x_return_status Return status after the call. The status can
1424: -- be fnd_api.g_ret_sts_success (success),

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

1420: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1421: -- OUT:
1422: -- x_cust_acct_obj Logical customer account record.
1423: -- x_return_status Return status after the call. The status can
1424: -- be fnd_api.g_ret_sts_success (success),
1425: -- fnd_api.g_ret_sts_error (error),
1426: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1427: -- x_msg_count Number of messages in message stack.
1428: -- x_msg_data Message text if x_msg_count is 1.

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

1421: -- OUT:
1422: -- x_cust_acct_obj Logical customer account record.
1423: -- x_return_status Return status after the call. The status can
1424: -- be fnd_api.g_ret_sts_success (success),
1425: -- fnd_api.g_ret_sts_error (error),
1426: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1427: -- x_msg_count Number of messages in message stack.
1428: -- x_msg_data Message text if x_msg_count is 1.
1429: --

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

1422: -- x_cust_acct_obj Logical customer account record.
1423: -- x_return_status Return status after the call. The status can
1424: -- be fnd_api.g_ret_sts_success (success),
1425: -- fnd_api.g_ret_sts_error (error),
1426: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1427: -- x_msg_count Number of messages in message stack.
1428: -- x_msg_data Message text if x_msg_count is 1.
1429: --
1430: -- NOTES

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

1462: */
1463:
1464:
1465: PROCEDURE get_cust_acct_bo(
1466: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1467: p_cust_acct_id IN NUMBER,
1468: p_cust_acct_os IN VARCHAR2,
1469: p_cust_acct_osr IN VARCHAR2,
1470: x_cust_acct_obj OUT NOCOPY HZ_CUST_ACCT_BO,

Line 1484: x_return_status := FND_API.G_RET_STS_SUCCESS;

1480: l_cust_acct_objs HZ_CUST_ACCT_BO_TBL;
1481: BEGIN
1482:
1483: -- initialize API return status to success.
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: IF FND_API.to_Boolean(p_init_msg_list) THEN
1488: FND_MSG_PUB.initialize;

Line 1487: IF FND_API.to_Boolean(p_init_msg_list) THEN

1483: -- initialize API return status to success.
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: IF FND_API.to_Boolean(p_init_msg_list) THEN
1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491:

Line 1515: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1511: x_return_status => x_return_status,
1512: x_msg_count => x_msg_count,
1513: x_msg_data => x_msg_data);
1514:
1515: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1516: RAISE fnd_api.g_exc_error;
1517: END IF;
1518:
1519: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos

Line 1516: RAISE fnd_api.g_exc_error;

1512: x_msg_count => x_msg_count,
1513: x_msg_data => x_msg_data);
1514:
1515: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1516: RAISE fnd_api.g_exc_error;
1517: END IF;
1518:
1519: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos
1520: (p_init_msg_list => fnd_api.g_false,

Line 1520: (p_init_msg_list => fnd_api.g_false,

1516: RAISE fnd_api.g_exc_error;
1517: END IF;
1518:
1519: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos
1520: (p_init_msg_list => fnd_api.g_false,
1521: p_parent_id => NULL,
1522: p_cust_acct_id => l_cust_acct_id,
1523: p_action_type => NULL,
1524: x_cust_acct_objs => l_cust_acct_objs,

Line 1531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1527: x_msg_data => x_msg_data);
1528:
1529: x_cust_acct_obj := l_cust_acct_objs(1);
1530:
1531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;
1534:
1535:

Line 1532: RAISE FND_API.G_EXC_ERROR;

1528:
1529: x_cust_acct_obj := l_cust_acct_objs(1);
1530:
1531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;
1534:
1535:
1536: -- Debug info.

Line 1554: WHEN fnd_api.g_exc_error THEN

1550:
1551:
1552: EXCEPTION
1553:
1554: WHEN fnd_api.g_exc_error THEN
1555: x_return_status := fnd_api.g_ret_sts_error;
1556:
1557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1558: p_count => x_msg_count,

Line 1555: x_return_status := fnd_api.g_ret_sts_error;

1551:
1552: EXCEPTION
1553:
1554: WHEN fnd_api.g_exc_error THEN
1555: x_return_status := fnd_api.g_ret_sts_error;
1556:
1557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data);

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

1553:
1554: WHEN fnd_api.g_exc_error THEN
1555: x_return_status := fnd_api.g_ret_sts_error;
1556:
1557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data);
1560:
1561: -- Debug info.

Line 1573: WHEN fnd_api.g_exc_unexpected_error THEN

1569: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1570: p_prefix=>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_procedure);
1572: END IF;
1573: WHEN fnd_api.g_exc_unexpected_error THEN
1574: x_return_status := fnd_api.g_ret_sts_unexp_error;
1575:
1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1577: p_count => x_msg_count,

Line 1574: x_return_status := fnd_api.g_ret_sts_unexp_error;

1570: p_prefix=>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_procedure);
1572: END IF;
1573: WHEN fnd_api.g_exc_unexpected_error THEN
1574: x_return_status := fnd_api.g_ret_sts_unexp_error;
1575:
1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data);

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

1572: END IF;
1573: WHEN fnd_api.g_exc_unexpected_error THEN
1574: x_return_status := fnd_api.g_ret_sts_unexp_error;
1575:
1576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data);
1579:
1580: -- Debug info.

Line 1593: x_return_status := fnd_api.g_ret_sts_unexp_error;

1589: p_prefix=>l_debug_prefix,
1590: p_msg_level=>fnd_log.level_procedure);
1591: END IF;
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594:
1595: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1596: fnd_message.set_token('ERROR' ,SQLERRM);
1597: fnd_msg_pub.add;

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

1595: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1596: fnd_message.set_token('ERROR' ,SQLERRM);
1597: fnd_msg_pub.add;
1598:
1599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602:
1603: -- Debug info.

Line 1630: p_init_msg_list => fnd_api.g_true,

1626: l_msg_data VARCHAR2(2000);
1627: l_msg_count NUMBER;
1628: BEGIN
1629: get_cust_acct_bo(
1630: p_init_msg_list => fnd_api.g_true,
1631: p_cust_acct_id => p_cust_acct_id,
1632: p_cust_acct_os => p_cust_acct_os,
1633: p_cust_acct_osr => p_cust_acct_osr,
1634: x_cust_acct_obj => x_cust_acct_obj,

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

1835: --
1836: -- DESCRIPTION
1837: -- Create customer account business object.
1838: PROCEDURE do_create_cust_acct_v2_bo(
1839: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1840: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1841: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
1842: p_created_by_module IN VARCHAR2,
1843: p_obj_source IN VARCHAR2 := null,

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

1836: -- DESCRIPTION
1837: -- Create customer account business object.
1838: PROCEDURE do_create_cust_acct_v2_bo(
1839: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1840: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1841: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
1842: p_created_by_module IN VARCHAR2,
1843: p_obj_source IN VARCHAR2 := null,
1844: x_return_status OUT NOCOPY VARCHAR2,

Line 1879: x_return_status := FND_API.G_RET_STS_SUCCESS;

1875: -- Standard start of API savepoint
1876: SAVEPOINT do_create_cust_acct_v2_bo_pub;
1877:
1878: -- initialize API return status to success.
1879: x_return_status := FND_API.G_RET_STS_SUCCESS;
1880:
1881: -- Initialize message list if p_init_msg_list is set to TRUE.
1882: IF FND_API.to_Boolean(p_init_msg_list) THEN
1883: FND_MSG_PUB.initialize;

Line 1882: IF FND_API.to_Boolean(p_init_msg_list) THEN

1878: -- initialize API return status to success.
1879: x_return_status := FND_API.G_RET_STS_SUCCESS;
1880:
1881: -- Initialize message list if p_init_msg_list is set to TRUE.
1882: IF FND_API.to_Boolean(p_init_msg_list) THEN
1883: FND_MSG_PUB.initialize;
1884: END IF;
1885:
1886: -- initialize Global variable

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

1898: p_msg_level=>fnd_log.level_procedure);
1899: END IF;
1900:
1901: -- Base on p_validate_bo_flag, check the completeness of business objects
1902: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1903: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
1904: p_bus_object_code => 'CUST_ACCT',
1905: x_bus_object => l_bus_object
1906: );

Line 1912: RAISE fnd_api.g_exc_error;

1908: p_ca_v2_objs => HZ_CUST_ACCT_V2_BO_TBL(p_cust_acct_v2_obj),
1909: p_bus_object => l_bus_object
1910: );
1911: IF NOT(l_valid_obj) THEN
1912: RAISE fnd_api.g_exc_error;
1913: END IF;
1914: END IF;
1915:
1916: -- check pass in parent_id and parent_os+osr

Line 1926: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1922: x_return_status => x_return_status,
1923: x_msg_count => x_msg_count,
1924: x_msg_data => x_msg_data);
1925:
1926: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:
1930: x_cust_acct_id := p_cust_acct_v2_obj.cust_acct_id;

Line 1927: RAISE FND_API.G_EXC_ERROR;

1923: x_msg_count => x_msg_count,
1924: x_msg_data => x_msg_data);
1925:
1926: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:
1930: x_cust_acct_id := p_cust_acct_v2_obj.cust_acct_id;
1931: x_cust_acct_os := p_cust_acct_v2_obj.orig_system;

Line 1945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1941: x_return_status => x_return_status,
1942: x_msg_count => x_msg_count,
1943: x_msg_data => x_msg_data);
1944:
1945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: assign_cust_acct_v2_rec(

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: x_msg_count => x_msg_count,
1943: x_msg_data => x_msg_data);
1944:
1945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: assign_cust_acct_v2_rec(
1950: p_cust_acct_v2_obj => p_cust_acct_v2_obj,

Line 1961: RAISE FND_API.G_EXC_ERROR;

1957: IF(p_cust_acct_v2_obj.cust_profile_obj IS NULL) THEN
1958: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
1959: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963:
1964: HZ_CUST_ACCT_BO_PVT.assign_cust_profile_rec(
1965: p_cust_profile_obj => p_cust_acct_v2_obj.cust_profile_obj,

Line 1973: -- therefore set p_create_profile_amt to FND_API.G_FALSE

1969: );
1970:
1971: -- set party_id to party record
1972: -- profile amount will be created after creating cust account
1973: -- therefore set p_create_profile_amt to FND_API.G_FALSE
1974: IF(px_parent_obj_type = 'ORG') THEN
1975: l_organization_rec.party_rec.party_id := px_parent_id;
1976: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
1977: p_cust_account_rec => l_cust_acct_rec,

Line 1980: p_create_profile_amt => FND_API.G_FALSE,

1976: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
1977: p_cust_account_rec => l_cust_acct_rec,
1978: p_organization_rec => l_organization_rec,
1979: p_customer_profile_rec => l_profile_rec,
1980: p_create_profile_amt => FND_API.G_FALSE,
1981: x_cust_account_id => x_cust_acct_id,
1982: x_account_number => l_account_number,
1983: x_party_id => l_party_id,
1984: x_party_number => l_party_number,

Line 1996: p_create_profile_amt => FND_API.G_FALSE,

1992: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
1993: p_cust_account_rec => l_cust_acct_rec,
1994: p_person_rec => l_person_rec,
1995: p_customer_profile_rec => l_profile_rec,
1996: p_create_profile_amt => FND_API.G_FALSE,
1997: x_cust_account_id => x_cust_acct_id,
1998: x_account_number => l_account_number,
1999: x_party_id => l_party_id,
2000: x_party_number => l_party_number,

Line 2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2004: x_msg_data => x_msg_data
2005: );
2006: END IF;
2007:
2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: OPEN get_cust_acct_profile_id(x_cust_acct_id);

Line 2009: RAISE FND_API.G_EXC_ERROR;

2005: );
2006: END IF;
2007:
2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: OPEN get_cust_acct_profile_id(x_cust_acct_id);
2013: FETCH get_cust_acct_profile_id INTO l_cust_acct_profile_id;

Line 2034: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2030: x_msg_count => x_msg_count,
2031: x_msg_data => x_msg_data
2032: );
2033:
2034: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2035: RAISE FND_API.G_EXC_ERROR;
2036: END IF;
2037: END IF;
2038:

Line 2035: RAISE FND_API.G_EXC_ERROR;

2031: x_msg_data => x_msg_data
2032: );
2033:
2034: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2035: RAISE FND_API.G_EXC_ERROR;
2036: END IF;
2037: END IF;
2038:
2039: -------------------------------------

Line 2052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2048: x_msg_count => x_msg_count,
2049: x_msg_data => x_msg_data
2050: );
2051:
2052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055: END IF;
2056:

Line 2053: RAISE FND_API.G_EXC_ERROR;

2049: x_msg_data => x_msg_data
2050: );
2051:
2052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055: END IF;
2056:
2057: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 2079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2075: p_parent_osr => x_cust_acct_osr,
2076: p_parent_obj_type => 'CUST_ACCT'
2077: );
2078:
2079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082: END IF;
2083:

Line 2080: RAISE FND_API.G_EXC_ERROR;

2076: p_parent_obj_type => 'CUST_ACCT'
2077: );
2078:
2079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082: END IF;
2083:
2084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2105: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2101: p_parent_acct_os => x_cust_acct_os,
2102: p_parent_acct_osr => x_cust_acct_osr
2103: );
2104:
2105: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2106: RAISE FND_API.G_EXC_ERROR;
2107: END IF;
2108: END IF;
2109:

Line 2106: RAISE FND_API.G_EXC_ERROR;

2102: p_parent_acct_osr => x_cust_acct_osr
2103: );
2104:
2105: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2106: RAISE FND_API.G_EXC_ERROR;
2107: END IF;
2108: END IF;
2109:
2110: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2123: x_msg_count => x_msg_count,
2124: x_msg_data => x_msg_data
2125: );
2126:
2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128: RAISE FND_API.G_EXC_ERROR;
2129: END IF;
2130: END IF;
2131:

Line 2128: RAISE FND_API.G_EXC_ERROR;

2124: x_msg_data => x_msg_data
2125: );
2126:
2127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128: RAISE FND_API.G_EXC_ERROR;
2129: END IF;
2130: END IF;
2131:
2132: ------------------------

Line 2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2142: x_msg_count => x_msg_count,
2143: x_msg_data => x_msg_data
2144: );
2145:
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: RAISE FND_API.G_EXC_ERROR;
2148: END IF;
2149: END IF;
2150:

Line 2147: RAISE FND_API.G_EXC_ERROR;

2143: x_msg_data => x_msg_data
2144: );
2145:
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: RAISE FND_API.G_EXC_ERROR;
2148: END IF;
2149: END IF;
2150:
2151: -- reset Global variable

Line 2169: WHEN fnd_api.g_exc_error THEN

2165: p_msg_level=>fnd_log.level_procedure);
2166: END IF;
2167:
2168: EXCEPTION
2169: WHEN fnd_api.g_exc_error THEN
2170: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2171:
2172: -- reset Global variable
2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2180: x_return_status := fnd_api.g_ret_sts_error;

2176: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2177: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2178: FND_MSG_PUB.ADD;
2179:
2180: x_return_status := fnd_api.g_ret_sts_error;
2181:
2182: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2183: p_count => x_msg_count,
2184: p_data => x_msg_data);

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

2178: FND_MSG_PUB.ADD;
2179:
2180: x_return_status := fnd_api.g_ret_sts_error;
2181:
2182: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2183: p_count => x_msg_count,
2184: p_data => x_msg_data);
2185:
2186: -- Debug info.

Line 2199: WHEN fnd_api.g_exc_unexpected_error THEN

2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);
2197: END IF;
2198:
2199: WHEN fnd_api.g_exc_unexpected_error THEN
2200: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2201:
2202: -- reset Global variable
2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2210: x_return_status := fnd_api.g_ret_sts_unexp_error;

2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2207: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2208: FND_MSG_PUB.ADD;
2209:
2210: x_return_status := fnd_api.g_ret_sts_unexp_error;
2211:
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2213: p_count => x_msg_count,
2214: p_data => x_msg_data);

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

2208: FND_MSG_PUB.ADD;
2209:
2210: x_return_status := fnd_api.g_ret_sts_unexp_error;
2211:
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2213: p_count => x_msg_count,
2214: p_data => x_msg_data);
2215:
2216: -- Debug info.

Line 2240: x_return_status := fnd_api.g_ret_sts_unexp_error;

2236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2237: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2238: FND_MSG_PUB.ADD;
2239:
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241:
2242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2243: fnd_message.set_token('ERROR' ,SQLERRM);
2244: fnd_msg_pub.add;

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

2242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2243: fnd_message.set_token('ERROR' ,SQLERRM);
2244: fnd_msg_pub.add;
2245:
2246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2247: p_count => x_msg_count,
2248: p_data => x_msg_data);
2249:
2250: -- Debug info.

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

2261: END IF;
2262: END do_create_cust_acct_v2_bo;
2263:
2264: PROCEDURE create_cust_acct_v2_bo(
2265: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2266: p_cust_acct_v2_obj IN HZ_CUST_ACCT_V2_BO,
2267: p_created_by_module IN VARCHAR2,
2268: p_obj_source IN VARCHAR2 := null,
2269: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

2265: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2266: p_cust_acct_v2_obj IN HZ_CUST_ACCT_V2_BO,
2267: p_created_by_module IN VARCHAR2,
2268: p_obj_source IN VARCHAR2 := null,
2269: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2270: x_return_status OUT NOCOPY VARCHAR2,
2271: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2272: x_return_obj OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2273: x_cust_acct_id OUT NOCOPY NUMBER,

Line 2287: p_init_msg_list => fnd_api.g_true,

2283: l_ca_obj HZ_CUST_ACCT_V2_BO;
2284: BEGIN
2285: l_ca_obj := p_cust_acct_v2_obj;
2286: do_create_cust_acct_v2_bo(
2287: p_init_msg_list => fnd_api.g_true,
2288: p_validate_bo_flag => p_validate_bo_flag,
2289: p_cust_acct_v2_obj => l_ca_obj,
2290: p_created_by_module => p_created_by_module,
2291: p_obj_source => p_obj_source,

Line 2307: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2303: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2304: x_return_status => x_return_status,
2305: x_msg_count => l_msg_count,
2306: x_msg_data => l_msg_data);
2307: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2308: x_return_obj := l_ca_obj;
2309: END IF;
2310: END create_cust_acct_v2_bo;
2311:

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

2312: PROCEDURE update_cust_acct_v2_bo(
2313: p_cust_acct_v2_obj IN HZ_CUST_ACCT_V2_BO,
2314: p_created_by_module IN VARCHAR2,
2315: p_obj_source IN VARCHAR2 := null,
2316: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2317: x_return_status OUT NOCOPY VARCHAR2,
2318: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2319: x_return_obj OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2320: x_cust_acct_id OUT NOCOPY NUMBER,

Line 2330: p_init_msg_list => fnd_api.g_true,

2326: l_ca_obj HZ_CUST_ACCT_V2_BO;
2327: BEGIN
2328: l_ca_obj := p_cust_acct_v2_obj;
2329: do_update_cust_acct_v2_bo(
2330: p_init_msg_list => fnd_api.g_true,
2331: p_cust_acct_v2_obj => l_ca_obj,
2332: p_created_by_module => p_created_by_module,
2333: p_obj_source => p_obj_source,
2334: x_return_status => x_return_status,

Line 2346: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2342: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2343: x_return_status => x_return_status,
2344: x_msg_count => l_msg_count,
2345: x_msg_data => l_msg_data);
2346: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2347: x_return_obj := l_ca_obj;
2348: END IF;
2349: END update_cust_acct_v2_bo;
2350:

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

2352: --
2353: -- DESCRIPTION
2354: -- Update customer account business object.
2355: PROCEDURE do_update_cust_acct_v2_bo(
2356: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2357: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2358: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2359: p_created_by_module IN VARCHAR2,
2360: p_obj_source IN VARCHAR2 := null,

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

2353: -- DESCRIPTION
2354: -- Update customer account business object.
2355: PROCEDURE do_update_cust_acct_v2_bo(
2356: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2357: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2358: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2359: p_created_by_module IN VARCHAR2,
2360: p_obj_source IN VARCHAR2 := null,
2361: x_return_status OUT NOCOPY VARCHAR2,

Line 2387: x_return_status := FND_API.G_RET_STS_SUCCESS;

2383: -- Standard start of API savepoint
2384: SAVEPOINT do_update_cust_acct_v2_bo_pub;
2385:
2386: -- initialize API return status to success.
2387: x_return_status := FND_API.G_RET_STS_SUCCESS;
2388:
2389: -- Initialize message list if p_init_msg_list is set to TRUE.
2390: IF FND_API.to_Boolean(p_init_msg_list) THEN
2391: FND_MSG_PUB.initialize;

Line 2390: IF FND_API.to_Boolean(p_init_msg_list) THEN

2386: -- initialize API return status to success.
2387: x_return_status := FND_API.G_RET_STS_SUCCESS;
2388:
2389: -- Initialize message list if p_init_msg_list is set to TRUE.
2390: IF FND_API.to_Boolean(p_init_msg_list) THEN
2391: FND_MSG_PUB.initialize;
2392: END IF;
2393:
2394: -- initialize Global variable

Line 2427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2423: x_return_status => x_return_status,
2424: x_msg_count => x_msg_count,
2425: x_msg_data => x_msg_data);
2426:
2427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2428: RAISE FND_API.G_EXC_ERROR;
2429: END IF;
2430:
2431: -- get object version number of customer acct

Line 2428: RAISE FND_API.G_EXC_ERROR;

2424: x_msg_count => x_msg_count,
2425: x_msg_data => x_msg_data);
2426:
2427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2428: RAISE FND_API.G_EXC_ERROR;
2429: END IF;
2430:
2431: -- get object version number of customer acct
2432: OPEN get_ovn(x_cust_acct_id);

Line 2453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2449: x_msg_count => x_msg_count,
2450: x_msg_data => x_msg_data
2451: );
2452:
2453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: END IF;
2456:
2457: -- assign cust_acct_id

Line 2454: RAISE FND_API.G_EXC_ERROR;

2450: x_msg_data => x_msg_data
2451: );
2452:
2453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: END IF;
2456:
2457: -- assign cust_acct_id
2458: p_cust_acct_v2_obj.cust_acct_id := x_cust_acct_id;

Line 2473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2469: x_msg_count => x_msg_count,
2470: x_msg_data => x_msg_data
2471: );
2472:
2473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: RAISE FND_API.G_EXC_ERROR;
2475: END IF;
2476:
2477: -- assign cust_acct_profile_id

Line 2474: RAISE FND_API.G_EXC_ERROR;

2470: x_msg_data => x_msg_data
2471: );
2472:
2473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: RAISE FND_API.G_EXC_ERROR;
2475: END IF;
2476:
2477: -- assign cust_acct_profile_id
2478: p_cust_acct_v2_obj.cust_profile_obj.cust_acct_profile_id := l_cust_acct_profile_id;

Line 2494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2490: x_msg_count => x_msg_count,
2491: x_msg_data => x_msg_data
2492: );
2493:
2494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497: END IF;
2498: END IF;

Line 2495: RAISE FND_API.G_EXC_ERROR;

2491: x_msg_data => x_msg_data
2492: );
2493:
2494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497: END IF;
2498: END IF;
2499:

Line 2520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2516: p_parent_osr => x_cust_acct_osr,
2517: p_parent_obj_type => 'CUST_ACCT'
2518: );
2519:
2520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523: END IF;
2524:

Line 2521: RAISE FND_API.G_EXC_ERROR;

2517: p_parent_obj_type => 'CUST_ACCT'
2518: );
2519:
2520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523: END IF;
2524:
2525: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2536: x_msg_count => x_msg_count,
2537: x_msg_data => x_msg_data
2538: );
2539:
2540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541: RAISE FND_API.G_EXC_ERROR;
2542: END IF;
2543: END IF;
2544:

Line 2541: RAISE FND_API.G_EXC_ERROR;

2537: x_msg_data => x_msg_data
2538: );
2539:
2540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541: RAISE FND_API.G_EXC_ERROR;
2542: END IF;
2543: END IF;
2544:
2545: -------------------------------------

Line 2564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2560: p_parent_acct_os => x_cust_acct_os,
2561: p_parent_acct_osr => x_cust_acct_osr
2562: );
2563:
2564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2565: RAISE FND_API.G_EXC_ERROR;
2566: END IF;
2567: END IF;
2568:

Line 2565: RAISE FND_API.G_EXC_ERROR;

2561: p_parent_acct_osr => x_cust_acct_osr
2562: );
2563:
2564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2565: RAISE FND_API.G_EXC_ERROR;
2566: END IF;
2567: END IF;
2568:
2569: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2582: x_msg_count => x_msg_count,
2583: x_msg_data => x_msg_data
2584: );
2585:
2586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589: END IF;
2590:

Line 2587: RAISE FND_API.G_EXC_ERROR;

2583: x_msg_data => x_msg_data
2584: );
2585:
2586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589: END IF;
2590:
2591: ------------------------

Line 2605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2601: x_msg_count => x_msg_count,
2602: x_msg_data => x_msg_data
2603: );
2604:
2605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;
2608: END IF;
2609:

Line 2606: RAISE FND_API.G_EXC_ERROR;

2602: x_msg_data => x_msg_data
2603: );
2604:
2605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2606: RAISE FND_API.G_EXC_ERROR;
2607: END IF;
2608: END IF;
2609:
2610: -- reset Global variable

Line 2627: WHEN fnd_api.g_exc_error THEN

2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;
2626: EXCEPTION
2627: WHEN fnd_api.g_exc_error THEN
2628: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2629:
2630: -- reset Global variable
2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2638: x_return_status := fnd_api.g_ret_sts_error;

2634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2635: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2636: FND_MSG_PUB.ADD;
2637:
2638: x_return_status := fnd_api.g_ret_sts_error;
2639:
2640: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2641: p_count => x_msg_count,
2642: p_data => x_msg_data);

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

2636: FND_MSG_PUB.ADD;
2637:
2638: x_return_status := fnd_api.g_ret_sts_error;
2639:
2640: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2641: p_count => x_msg_count,
2642: p_data => x_msg_data);
2643:
2644: -- Debug info.

Line 2657: WHEN fnd_api.g_exc_unexpected_error THEN

2653: p_prefix=>l_debug_prefix,
2654: p_msg_level=>fnd_log.level_procedure);
2655: END IF;
2656:
2657: WHEN fnd_api.g_exc_unexpected_error THEN
2658: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2659:
2660: -- reset Global variable
2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2668: x_return_status := fnd_api.g_ret_sts_unexp_error;

2664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2665: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2666: FND_MSG_PUB.ADD;
2667:
2668: x_return_status := fnd_api.g_ret_sts_unexp_error;
2669:
2670: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2671: p_count => x_msg_count,
2672: p_data => x_msg_data);

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

2666: FND_MSG_PUB.ADD;
2667:
2668: x_return_status := fnd_api.g_ret_sts_unexp_error;
2669:
2670: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2671: p_count => x_msg_count,
2672: p_data => x_msg_data);
2673:
2674: -- Debug info.

Line 2698: x_return_status := fnd_api.g_ret_sts_unexp_error;

2694: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2695: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2696: FND_MSG_PUB.ADD;
2697:
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2699:
2700: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2701: fnd_message.set_token('ERROR' ,SQLERRM);
2702: fnd_msg_pub.add;

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

2700: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2701: fnd_message.set_token('ERROR' ,SQLERRM);
2702: fnd_msg_pub.add;
2703:
2704: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2705: p_count => x_msg_count,
2706: p_data => x_msg_data);
2707:
2708: -- Debug info.

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

2723: --
2724: -- DESCRIPTION
2725: -- Create or update customer account business object.
2726: PROCEDURE do_save_cust_acct_v2_bo(
2727: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2728: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2729: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2730: p_created_by_module IN VARCHAR2,
2731: p_obj_source IN VARCHAR2 := null,

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

2724: -- DESCRIPTION
2725: -- Create or update customer account business object.
2726: PROCEDURE do_save_cust_acct_v2_bo(
2727: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2728: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2729: p_cust_acct_v2_obj IN OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2730: p_created_by_module IN VARCHAR2,
2731: p_obj_source IN VARCHAR2 := null,
2732: x_return_status OUT NOCOPY VARCHAR2,

Line 2750: x_return_status := FND_API.G_RET_STS_SUCCESS;

2746: l_create_update_flag VARCHAR2(1);
2747: l_debug_prefix VARCHAR2(30) := '';
2748: BEGIN
2749: -- initialize API return status to success.
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean(p_init_msg_list) THEN
2754: FND_MSG_PUB.initialize;

Line 2753: IF FND_API.to_Boolean(p_init_msg_list) THEN

2749: -- initialize API return status to success.
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean(p_init_msg_list) THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756:
2757: -- Debug info.

Line 2783: RAISE FND_API.G_EXC_ERROR;

2779: IF(l_create_update_flag = 'E') THEN
2780: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2781: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2782: FND_MSG_PUB.ADD;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785:
2786: IF(l_create_update_flag = 'C') THEN
2787: do_create_cust_acct_v2_bo(

Line 2817: RAISE FND_API.G_EXC_ERROR;

2813: x_cust_acct_osr => x_cust_acct_osr,
2814: p_parent_os => px_parent_os
2815: );
2816: ELSE
2817: RAISE FND_API.G_EXC_ERROR;
2818: END IF;
2819:
2820: -- Debug info.
2821: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2834: WHEN fnd_api.g_exc_error THEN

2830: p_msg_level=>fnd_log.level_procedure);
2831: END IF;
2832:
2833: EXCEPTION
2834: WHEN fnd_api.g_exc_error THEN
2835: x_return_status := fnd_api.g_ret_sts_error;
2836:
2837: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
2838: FND_MSG_PUB.ADD;

Line 2835: x_return_status := fnd_api.g_ret_sts_error;

2831: END IF;
2832:
2833: EXCEPTION
2834: WHEN fnd_api.g_exc_error THEN
2835: x_return_status := fnd_api.g_ret_sts_error;
2836:
2837: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
2838: FND_MSG_PUB.ADD;
2839: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2835: x_return_status := fnd_api.g_ret_sts_error;
2836:
2837: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
2838: FND_MSG_PUB.ADD;
2839: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2840: p_count => x_msg_count,
2841: p_data => x_msg_data);
2842:
2843: -- Debug info.

Line 2855: WHEN fnd_api.g_exc_unexpected_error THEN

2851: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2852: p_prefix=>l_debug_prefix,
2853: p_msg_level=>fnd_log.level_procedure);
2854: END IF;
2855: WHEN fnd_api.g_exc_unexpected_error THEN
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857:
2858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2859: p_count => x_msg_count,

Line 2856: x_return_status := fnd_api.g_ret_sts_unexp_error;

2852: p_prefix=>l_debug_prefix,
2853: p_msg_level=>fnd_log.level_procedure);
2854: END IF;
2855: WHEN fnd_api.g_exc_unexpected_error THEN
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857:
2858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2859: p_count => x_msg_count,
2860: p_data => x_msg_data);

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

2854: END IF;
2855: WHEN fnd_api.g_exc_unexpected_error THEN
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857:
2858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2859: p_count => x_msg_count,
2860: p_data => x_msg_data);
2861:
2862: -- Debug info.

Line 2875: x_return_status := fnd_api.g_ret_sts_unexp_error;

2871: p_prefix=>l_debug_prefix,
2872: p_msg_level=>fnd_log.level_procedure);
2873: END IF;
2874: WHEN OTHERS THEN
2875: x_return_status := fnd_api.g_ret_sts_unexp_error;
2876:
2877: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2878: fnd_message.set_token('ERROR' ,SQLERRM);
2879: fnd_msg_pub.add;

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

2877: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2878: fnd_message.set_token('ERROR' ,SQLERRM);
2879: fnd_msg_pub.add;
2880:
2881: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2882: p_count => x_msg_count,
2883: p_data => x_msg_data);
2884:
2885: -- Debug info.

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

2896: END IF;
2897: END do_save_cust_acct_v2_bo;
2898:
2899: PROCEDURE save_cust_acct_v2_bo(
2900: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2901: p_cust_acct_v2_obj IN HZ_CUST_ACCT_V2_BO,
2902: p_created_by_module IN VARCHAR2,
2903: p_obj_source IN VARCHAR2 := null,
2904: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

2900: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2901: p_cust_acct_v2_obj IN HZ_CUST_ACCT_V2_BO,
2902: p_created_by_module IN VARCHAR2,
2903: p_obj_source IN VARCHAR2 := null,
2904: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2905: x_return_status OUT NOCOPY VARCHAR2,
2906: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2907: x_return_obj OUT NOCOPY HZ_CUST_ACCT_V2_BO,
2908: x_cust_acct_id OUT NOCOPY NUMBER,

Line 2922: p_init_msg_list => fnd_api.g_true,

2918: l_ca_obj HZ_CUST_ACCT_V2_BO;
2919: BEGIN
2920: l_ca_obj := p_cust_acct_v2_obj;
2921: do_save_cust_acct_v2_bo(
2922: p_init_msg_list => fnd_api.g_true,
2923: p_validate_bo_flag => p_validate_bo_flag,
2924: p_cust_acct_v2_obj => l_ca_obj,
2925: p_created_by_module => p_created_by_module,
2926: x_return_status => x_return_status,

Line 2941: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2937: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2938: x_return_status => x_return_status,
2939: x_msg_count => l_msg_count,
2940: x_msg_data => l_msg_data);
2941: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2942: x_return_obj := l_ca_obj;
2943: END IF;
2944: END save_cust_acct_v2_bo;
2945:

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

2956: -- IN:
2957: -- p_init_msg_list Initialize message stack if it is set to
2958: -- p_cust_acct_id customer account ID.
2959: -- p_parent_id Parent Id.
2960: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2961: -- OUT:
2962: -- x_cust_acct_v2_obj Logical customer account record.
2963: -- x_return_status Return status after the call. The status can
2964: -- be fnd_api.g_ret_sts_success (success),

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

2960: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2961: -- OUT:
2962: -- x_cust_acct_v2_obj Logical customer account record.
2963: -- x_return_status Return status after the call. The status can
2964: -- be fnd_api.g_ret_sts_success (success),
2965: -- fnd_api.g_ret_sts_error (error),
2966: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2967: -- x_msg_count Number of messages in message stack.
2968: -- x_msg_data Message text if x_msg_count is 1.

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

2961: -- OUT:
2962: -- x_cust_acct_v2_obj Logical customer account record.
2963: -- x_return_status Return status after the call. The status can
2964: -- be fnd_api.g_ret_sts_success (success),
2965: -- fnd_api.g_ret_sts_error (error),
2966: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2967: -- x_msg_count Number of messages in message stack.
2968: -- x_msg_data Message text if x_msg_count is 1.
2969: --

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

2962: -- x_cust_acct_v2_obj Logical customer account record.
2963: -- x_return_status Return status after the call. The status can
2964: -- be fnd_api.g_ret_sts_success (success),
2965: -- fnd_api.g_ret_sts_error (error),
2966: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2967: -- x_msg_count Number of messages in message stack.
2968: -- x_msg_data Message text if x_msg_count is 1.
2969: --
2970: -- NOTES

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

3002: */
3003:
3004:
3005: PROCEDURE get_cust_acct_v2_bo(
3006: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3007: p_cust_acct_id IN NUMBER,
3008: p_cust_acct_os IN VARCHAR2,
3009: p_cust_acct_osr IN VARCHAR2,
3010: x_cust_acct_v2_obj OUT NOCOPY HZ_CUST_ACCT_V2_BO,

Line 3024: x_return_status := FND_API.G_RET_STS_SUCCESS;

3020: l_cust_acct_v2_objs HZ_CUST_ACCT_V2_BO_TBL;
3021: BEGIN
3022:
3023: -- initialize API return status to success.
3024: x_return_status := FND_API.G_RET_STS_SUCCESS;
3025:
3026: -- Initialize message list if p_init_msg_list is set to TRUE
3027: IF FND_API.to_Boolean(p_init_msg_list) THEN
3028: FND_MSG_PUB.initialize;

Line 3027: IF FND_API.to_Boolean(p_init_msg_list) THEN

3023: -- initialize API return status to success.
3024: x_return_status := FND_API.G_RET_STS_SUCCESS;
3025:
3026: -- Initialize message list if p_init_msg_list is set to TRUE
3027: IF FND_API.to_Boolean(p_init_msg_list) THEN
3028: FND_MSG_PUB.initialize;
3029: END IF;
3030:
3031:

Line 3055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3051: x_return_status => x_return_status,
3052: x_msg_count => x_msg_count,
3053: x_msg_data => x_msg_data);
3054:
3055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3056: RAISE fnd_api.g_exc_error;
3057: END IF;
3058:
3059: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos

Line 3056: RAISE fnd_api.g_exc_error;

3052: x_msg_count => x_msg_count,
3053: x_msg_data => x_msg_data);
3054:
3055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3056: RAISE fnd_api.g_exc_error;
3057: END IF;
3058:
3059: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos
3060: (p_init_msg_list => fnd_api.g_false,

Line 3060: (p_init_msg_list => fnd_api.g_false,

3056: RAISE fnd_api.g_exc_error;
3057: END IF;
3058:
3059: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos
3060: (p_init_msg_list => fnd_api.g_false,
3061: p_parent_id => NULL,
3062: p_cust_acct_id => l_cust_acct_id,
3063: p_action_type => NULL,
3064: x_cust_acct_v2_objs => l_cust_acct_v2_objs,

Line 3071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3067: x_msg_data => x_msg_data);
3068:
3069: x_cust_acct_v2_obj := l_cust_acct_v2_objs(1);
3070:
3071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;
3074:
3075:

Line 3072: RAISE FND_API.G_EXC_ERROR;

3068:
3069: x_cust_acct_v2_obj := l_cust_acct_v2_objs(1);
3070:
3071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;
3074:
3075:
3076: -- Debug info.

Line 3094: WHEN fnd_api.g_exc_error THEN

3090:
3091:
3092: EXCEPTION
3093:
3094: WHEN fnd_api.g_exc_error THEN
3095: x_return_status := fnd_api.g_ret_sts_error;
3096:
3097: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3098: p_count => x_msg_count,

Line 3095: x_return_status := fnd_api.g_ret_sts_error;

3091:
3092: EXCEPTION
3093:
3094: WHEN fnd_api.g_exc_error THEN
3095: x_return_status := fnd_api.g_ret_sts_error;
3096:
3097: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3098: p_count => x_msg_count,
3099: p_data => x_msg_data);

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

3093:
3094: WHEN fnd_api.g_exc_error THEN
3095: x_return_status := fnd_api.g_ret_sts_error;
3096:
3097: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3098: p_count => x_msg_count,
3099: p_data => x_msg_data);
3100:
3101: -- Debug info.

Line 3113: WHEN fnd_api.g_exc_unexpected_error THEN

3109: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3110: p_prefix=>l_debug_prefix,
3111: p_msg_level=>fnd_log.level_procedure);
3112: END IF;
3113: WHEN fnd_api.g_exc_unexpected_error THEN
3114: x_return_status := fnd_api.g_ret_sts_unexp_error;
3115:
3116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3117: p_count => x_msg_count,

Line 3114: x_return_status := fnd_api.g_ret_sts_unexp_error;

3110: p_prefix=>l_debug_prefix,
3111: p_msg_level=>fnd_log.level_procedure);
3112: END IF;
3113: WHEN fnd_api.g_exc_unexpected_error THEN
3114: x_return_status := fnd_api.g_ret_sts_unexp_error;
3115:
3116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3117: p_count => x_msg_count,
3118: p_data => x_msg_data);

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

3112: END IF;
3113: WHEN fnd_api.g_exc_unexpected_error THEN
3114: x_return_status := fnd_api.g_ret_sts_unexp_error;
3115:
3116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3117: p_count => x_msg_count,
3118: p_data => x_msg_data);
3119:
3120: -- Debug info.

Line 3133: x_return_status := fnd_api.g_ret_sts_unexp_error;

3129: p_prefix=>l_debug_prefix,
3130: p_msg_level=>fnd_log.level_procedure);
3131: END IF;
3132: WHEN OTHERS THEN
3133: x_return_status := fnd_api.g_ret_sts_unexp_error;
3134:
3135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3136: fnd_message.set_token('ERROR' ,SQLERRM);
3137: fnd_msg_pub.add;

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

3135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3136: fnd_message.set_token('ERROR' ,SQLERRM);
3137: fnd_msg_pub.add;
3138:
3139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3140: p_count => x_msg_count,
3141: p_data => x_msg_data);
3142:
3143: -- Debug info.

Line 3170: p_init_msg_list => fnd_api.g_true,

3166: l_msg_data VARCHAR2(2000);
3167: l_msg_count NUMBER;
3168: BEGIN
3169: get_cust_acct_v2_bo(
3170: p_init_msg_list => fnd_api.g_true,
3171: p_cust_acct_id => p_cust_acct_id,
3172: p_cust_acct_os => p_cust_acct_os,
3173: p_cust_acct_osr => p_cust_acct_osr,
3174: x_cust_acct_v2_obj => x_cust_acct_v2_obj,