DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 139: px_cust_acct_site_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

135: px_cust_acct_site_rec.translated_customer_name := p_cust_acct_site_obj.translated_customer_name;
136: IF(p_create_or_update = 'C') THEN
137: px_cust_acct_site_rec.orig_system := p_cust_acct_site_os;
138: px_cust_acct_site_rec.orig_system_reference := p_cust_acct_site_osr;
139: px_cust_acct_site_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
140: END IF;
141: px_cust_acct_site_rec.org_id := p_cust_acct_site_obj.org_id;
142: END assign_cust_acct_site_rec;
143:

Line 210: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(+)',

206: END IF;
207:
208: -- Debug info.
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(+)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214:

Line 216: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214:
215: -- initialize Global variable
216: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
217: IF(p_created_by_module IS NULL) THEN
218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
219: ELSE
220: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

214:
215: -- initialize Global variable
216: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
217: IF(p_created_by_module IS NULL) THEN
218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
219: ELSE
220: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
221: END IF;
222:

Line 220: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

216: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
217: IF(p_created_by_module IS NULL) THEN
218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
219: ELSE
220: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
221: END IF;
222:
223: -- Base on p_validate_bo_flag, check the completeness of business objects
224: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

Line 327: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

323: END IF;
324:
325: -- assign cust_acct_site_id
326: p_cust_acct_site_obj.cust_acct_site_id := x_cust_acct_site_id;
327: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
328:
329: -------------------------------------
330: -- Call cust account contact v2pub api
331: -------------------------------------

Line 354: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: END IF;
353:
354: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
355:
356: -------------------------------------
357: -- Call cust account site use v2pub api
358: -------------------------------------

Line 379: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

375: END IF;
376: END IF;
377:
378: -- reset Global variable
379: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
380: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
381:
382: -- Debug info.
383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 380: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

376: END IF;
377:
378: -- reset Global variable
379: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
380: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
381:
382: -- Debug info.
383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

380: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
381:
382: -- Debug info.
383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
385: p_msg_data=>x_msg_data,
386: p_msg_type=>'WARNING',
387: p_msg_level=>fnd_log.level_exception);
388: END IF;

Line 390: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',

386: p_msg_type=>'WARNING',
387: p_msg_level=>fnd_log.level_exception);
388: END IF;
389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
390: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
391: p_prefix=>l_debug_prefix,
392: p_msg_level=>fnd_log.level_procedure);
393: END IF;
394:

Line 400: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

396: WHEN fnd_api.g_exc_error THEN
397: ROLLBACK TO do_create_cas_bo_pub;
398:
399: -- reset Global variable
400: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
401: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
402:
403: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
404: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 401: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

397: ROLLBACK TO do_create_cas_bo_pub;
398:
399: -- reset Global variable
400: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
401: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
402:
403: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
404: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
405: FND_MSG_PUB.ADD;

Line 415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

411: p_data => x_msg_data);
412:
413: -- Debug info.
414: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
416: p_msg_data=>x_msg_data,
417: p_msg_type=>'ERROR',
418: p_msg_level=>fnd_log.level_error);
419: END IF;

Line 421: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',

417: p_msg_type=>'ERROR',
418: p_msg_level=>fnd_log.level_error);
419: END IF;
420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
421: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
422: p_prefix=>l_debug_prefix,
423: p_msg_level=>fnd_log.level_procedure);
424: END IF;
425:

Line 430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

426: WHEN fnd_api.g_exc_unexpected_error THEN
427: ROLLBACK TO do_create_cas_bo_pub;
428:
429: -- reset Global variable
430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
431: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
432:
433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
434: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 431: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

427: ROLLBACK TO do_create_cas_bo_pub;
428:
429: -- reset Global variable
430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
431: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
432:
433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
434: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
435: FND_MSG_PUB.ADD;

Line 445: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

441: p_data => x_msg_data);
442:
443: -- Debug info.
444: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
446: p_msg_data=>x_msg_data,
447: p_msg_type=>'UNEXPECTED ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;

Line 451: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',

447: p_msg_type=>'UNEXPECTED ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;
450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
452: p_prefix=>l_debug_prefix,
453: p_msg_level=>fnd_log.level_procedure);
454: END IF;
455:

Line 460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

456: WHEN OTHERS THEN
457: ROLLBACK TO do_create_cas_bo_pub;
458:
459: -- reset Global variable
460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
461: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
462:
463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
464: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 461: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

457: ROLLBACK TO do_create_cas_bo_pub;
458:
459: -- reset Global variable
460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
461: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
462:
463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
464: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
465: FND_MSG_PUB.ADD;

Line 479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

475: p_data => x_msg_data);
476:
477: -- Debug info.
478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
480: p_msg_data=>x_msg_data,
481: p_msg_type=>'SQL ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;

Line 485: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',

481: p_msg_type=>'SQL ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489: END do_create_cust_acct_site_bo;

Line 693: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',

689: END IF;
690:
691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;
697:

Line 699: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

695: p_msg_level=>fnd_log.level_procedure);
696: END IF;
697:
698: -- initialize Global variable
699: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
700: IF(p_created_by_module IS NULL) THEN
701: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
702: ELSE
703: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 701: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

697:
698: -- initialize Global variable
699: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
700: IF(p_created_by_module IS NULL) THEN
701: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
702: ELSE
703: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
704: END IF;
705:

Line 703: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

699: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
700: IF(p_created_by_module IS NULL) THEN
701: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
702: ELSE
703: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
704: END IF;
705:
706: -------------------------------
707: -- For Update cust acct site

Line 759: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

755: END IF;
756:
757: -- assign cust_acct_site_id
758: p_cust_acct_site_obj.cust_acct_site_id := x_cust_acct_site_id;
759: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
760:
761: -----------------------------------
762: -- For cust account contact
763: -----------------------------------

Line 784: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: END IF;
783:
784: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
785:
786: ----------------------------
787: -- For cust account site use
788: ----------------------------

Line 807: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

803: END IF;
804: END IF;
805:
806: -- reset Global variable
807: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
808: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
809:
810: -- Debug info.
811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 808: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

804: END IF;
805:
806: -- reset Global variable
807: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
808: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
809:
810: -- Debug info.
811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

808: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
809:
810: -- Debug info.
811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
813: p_msg_data=>x_msg_data,
814: p_msg_type=>'WARNING',
815: p_msg_level=>fnd_log.level_exception);
816: END IF;

Line 818: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',

814: p_msg_type=>'WARNING',
815: p_msg_level=>fnd_log.level_exception);
816: END IF;
817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
819: p_prefix=>l_debug_prefix,
820: p_msg_level=>fnd_log.level_procedure);
821: END IF;
822: EXCEPTION

Line 827: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

823: WHEN fnd_api.g_exc_error THEN
824: ROLLBACK TO do_update_cas_bo_pub;
825:
826: -- reset Global variable
827: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
828: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
829:
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
831: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 828: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

824: ROLLBACK TO do_update_cas_bo_pub;
825:
826: -- reset Global variable
827: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
828: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
829:
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
831: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
832: FND_MSG_PUB.ADD;

Line 842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

838: p_data => x_msg_data);
839:
840: -- Debug info.
841: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
843: p_msg_data=>x_msg_data,
844: p_msg_type=>'ERROR',
845: p_msg_level=>fnd_log.level_error);
846: END IF;

Line 848: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',

844: p_msg_type=>'ERROR',
845: p_msg_level=>fnd_log.level_error);
846: END IF;
847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
848: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
849: p_prefix=>l_debug_prefix,
850: p_msg_level=>fnd_log.level_procedure);
851: END IF;
852:

Line 857: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

853: WHEN fnd_api.g_exc_unexpected_error THEN
854: ROLLBACK TO do_update_cas_bo_pub;
855:
856: -- reset Global variable
857: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
858: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
859:
860: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
861: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 858: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

854: ROLLBACK TO do_update_cas_bo_pub;
855:
856: -- reset Global variable
857: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
858: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
859:
860: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
861: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
862: FND_MSG_PUB.ADD;

Line 872: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

868: p_data => x_msg_data);
869:
870: -- Debug info.
871: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
872: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
873: p_msg_data=>x_msg_data,
874: p_msg_type=>'UNEXPECTED ERROR',
875: p_msg_level=>fnd_log.level_error);
876: END IF;

Line 878: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',

874: p_msg_type=>'UNEXPECTED ERROR',
875: p_msg_level=>fnd_log.level_error);
876: END IF;
877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
878: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
879: p_prefix=>l_debug_prefix,
880: p_msg_level=>fnd_log.level_procedure);
881: END IF;
882:

Line 887: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

883: WHEN OTHERS THEN
884: ROLLBACK TO do_update_cas_bo_pub;
885:
886: -- reset Global variable
887: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
888: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
889:
890: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
891: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 888: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

884: ROLLBACK TO do_update_cas_bo_pub;
885:
886: -- reset Global variable
887: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
888: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
889:
890: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
891: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
892: FND_MSG_PUB.ADD;

Line 906: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

902: p_data => x_msg_data);
903:
904: -- Debug info.
905: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
907: p_msg_data=>x_msg_data,
908: p_msg_type=>'SQL ERROR',
909: p_msg_level=>fnd_log.level_error);
910: END IF;

Line 912: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',

908: p_msg_type=>'SQL ERROR',
909: p_msg_level=>fnd_log.level_error);
910: END IF;
911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
913: p_prefix=>l_debug_prefix,
914: p_msg_level=>fnd_log.level_procedure);
915: END IF;
916: END do_update_cust_acct_site_bo;

Line 963: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(+)',

959: END IF;
960:
961: -- Debug info.
962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
963: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(+)',
964: p_prefix=>l_debug_prefix,
965: p_msg_level=>fnd_log.level_procedure);
966: END IF;
967:

Line 1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1038: END IF;
1039:
1040: -- Debug info.
1041: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'WARNING',
1045: p_msg_level=>fnd_log.level_exception);
1046: END IF;

Line 1048: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',

1044: p_msg_type=>'WARNING',
1045: p_msg_level=>fnd_log.level_exception);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;
1052:

Line 1063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1059: p_data => x_msg_data);
1060:
1061: -- Debug info.
1062: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1064: p_msg_data=>x_msg_data,
1065: p_msg_type=>'ERROR',
1066: p_msg_level=>fnd_log.level_error);
1067: END IF;

Line 1069: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',

1065: p_msg_type=>'ERROR',
1066: p_msg_level=>fnd_log.level_error);
1067: END IF;
1068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1070: p_prefix=>l_debug_prefix,
1071: p_msg_level=>fnd_log.level_procedure);
1072: END IF;
1073: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1078: p_data => x_msg_data);
1079:
1080: -- Debug info.
1081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1083: p_msg_data=>x_msg_data,
1084: p_msg_type=>'UNEXPECTED ERROR',
1085: p_msg_level=>fnd_log.level_error);
1086: END IF;

Line 1088: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',

1084: p_msg_type=>'UNEXPECTED ERROR',
1085: p_msg_level=>fnd_log.level_error);
1086: END IF;
1087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1089: p_prefix=>l_debug_prefix,
1090: p_msg_level=>fnd_log.level_procedure);
1091: END IF;
1092: WHEN OTHERS THEN

Line 1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1101: p_data => x_msg_data);
1102:
1103: -- Debug info.
1104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'SQL ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;

Line 1111: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',

1107: p_msg_type=>'SQL ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1112: p_prefix=>l_debug_prefix,
1113: p_msg_level=>fnd_log.level_procedure);
1114: END IF;
1115: END do_save_cust_acct_site_bo;

Line 1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',

1286:
1287:
1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:

Line 1334: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1330:
1331:
1332: -- Debug info.
1333: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1335: p_msg_data=>x_msg_data,
1336: p_msg_type=>'WARNING',
1337: p_msg_level=>fnd_log.level_exception);
1338: END IF;

Line 1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1338: END IF;
1339:
1340: -- Debug info.
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;
1346:

Line 1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1355: p_data => x_msg_data);
1356:
1357: -- Debug info.
1358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;

Line 1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;
1369: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1374: p_data => x_msg_data);
1375:
1376: -- Debug info.
1377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1379: p_msg_data=>x_msg_data,
1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);
1382: END IF;

Line 1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);
1382: END IF;
1383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1385: p_prefix=>l_debug_prefix,
1386: p_msg_level=>fnd_log.level_procedure);
1387: END IF;
1388: WHEN OTHERS THEN

Line 1401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1397: p_data => x_msg_data);
1398:
1399: -- Debug info.
1400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1402: p_msg_data=>x_msg_data,
1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;

Line 1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411:

Line 1576: px_cust_acct_site_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1572: px_cust_acct_site_rec.translated_customer_name := p_cust_acct_site_v2_obj.translated_customer_name;
1573: IF(p_create_or_update = 'C') THEN
1574: px_cust_acct_site_rec.orig_system := p_cust_acct_site_os;
1575: px_cust_acct_site_rec.orig_system_reference := p_cust_acct_site_osr;
1576: px_cust_acct_site_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1577: END IF;
1578: px_cust_acct_site_rec.org_id := p_cust_acct_site_v2_obj.org_id;
1579: END assign_cust_acct_site_v2_rec;
1580:

Line 1647: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(+)',

1643: END IF;
1644:
1645: -- Debug info.
1646: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(+)',
1648: p_prefix=>l_debug_prefix,
1649: p_msg_level=>fnd_log.level_procedure);
1650: END IF;
1651:

Line 1653: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

1649: p_msg_level=>fnd_log.level_procedure);
1650: END IF;
1651:
1652: -- initialize Global variable
1653: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1654: IF(p_created_by_module IS NULL) THEN
1655: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1656: ELSE
1657: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 1655: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

1651:
1652: -- initialize Global variable
1653: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1654: IF(p_created_by_module IS NULL) THEN
1655: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1656: ELSE
1657: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1658: END IF;
1659:

Line 1657: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1653: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1654: IF(p_created_by_module IS NULL) THEN
1655: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1656: ELSE
1657: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1658: END IF;
1659:
1660: -- Base on p_validate_bo_flag, check the completeness of business objects
1661: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

Line 1764: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1760: END IF;
1761:
1762: -- assign cust_acct_site_id
1763: p_cust_acct_site_v2_obj.cust_acct_site_id := x_cust_acct_site_id;
1764: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1765:
1766: -------------------------------------
1767: -- Call cust account contact v2pub api
1768: -------------------------------------

Line 1791: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1787: RAISE FND_API.G_EXC_ERROR;
1788: END IF;
1789: END IF;
1790:
1791: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1792:
1793: -------------------------------------
1794: -- Call cust account site use v2pub api
1795: -------------------------------------

Line 1816: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1812: END IF;
1813: END IF;
1814:
1815: -- reset Global variable
1816: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1817: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1818:
1819: -- Debug info.
1820: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1817: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1813: END IF;
1814:
1815: -- reset Global variable
1816: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1817: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1818:
1819: -- Debug info.
1820: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 1821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1817: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1818:
1819: -- Debug info.
1820: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1822: p_msg_data=>x_msg_data,
1823: p_msg_type=>'WARNING',
1824: p_msg_level=>fnd_log.level_exception);
1825: END IF;

Line 1827: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',

1823: p_msg_type=>'WARNING',
1824: p_msg_level=>fnd_log.level_exception);
1825: END IF;
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;
1831:

Line 1837: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1833: WHEN fnd_api.g_exc_error THEN
1834: ROLLBACK TO do_create_cas_v2_bo_pub;
1835:
1836: -- reset Global variable
1837: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1838: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1839:
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1841: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 1838: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1834: ROLLBACK TO do_create_cas_v2_bo_pub;
1835:
1836: -- reset Global variable
1837: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1838: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1839:
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1841: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
1842: FND_MSG_PUB.ADD;

Line 1852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1848: p_data => x_msg_data);
1849:
1850: -- Debug info.
1851: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1853: p_msg_data=>x_msg_data,
1854: p_msg_type=>'ERROR',
1855: p_msg_level=>fnd_log.level_error);
1856: END IF;

Line 1858: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',

1854: p_msg_type=>'ERROR',
1855: p_msg_level=>fnd_log.level_error);
1856: END IF;
1857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1858: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1859: p_prefix=>l_debug_prefix,
1860: p_msg_level=>fnd_log.level_procedure);
1861: END IF;
1862:

Line 1867: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1863: WHEN fnd_api.g_exc_unexpected_error THEN
1864: ROLLBACK TO do_create_cas_v2_bo_pub;
1865:
1866: -- reset Global variable
1867: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1868: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1869:
1870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1871: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 1868: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1864: ROLLBACK TO do_create_cas_v2_bo_pub;
1865:
1866: -- reset Global variable
1867: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1868: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1869:
1870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1871: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
1872: FND_MSG_PUB.ADD;

Line 1882: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1878: p_data => x_msg_data);
1879:
1880: -- Debug info.
1881: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1882: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1883: p_msg_data=>x_msg_data,
1884: p_msg_type=>'UNEXPECTED ERROR',
1885: p_msg_level=>fnd_log.level_error);
1886: END IF;

Line 1888: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',

1884: p_msg_type=>'UNEXPECTED ERROR',
1885: p_msg_level=>fnd_log.level_error);
1886: END IF;
1887: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1889: p_prefix=>l_debug_prefix,
1890: p_msg_level=>fnd_log.level_procedure);
1891: END IF;
1892:

Line 1897: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1893: WHEN OTHERS THEN
1894: ROLLBACK TO do_create_cas_v2_bo_pub;
1895:
1896: -- reset Global variable
1897: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1898: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1899:
1900: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1901: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 1898: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1894: ROLLBACK TO do_create_cas_v2_bo_pub;
1895:
1896: -- reset Global variable
1897: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1898: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1899:
1900: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1901: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
1902: FND_MSG_PUB.ADD;

Line 1916: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1912: p_data => x_msg_data);
1913:
1914: -- Debug info.
1915: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1916: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1917: p_msg_data=>x_msg_data,
1918: p_msg_type=>'SQL ERROR',
1919: p_msg_level=>fnd_log.level_error);
1920: END IF;

Line 1922: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',

1918: p_msg_type=>'SQL ERROR',
1919: p_msg_level=>fnd_log.level_error);
1920: END IF;
1921: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1922: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1923: p_prefix=>l_debug_prefix,
1924: p_msg_level=>fnd_log.level_procedure);
1925: END IF;
1926: END do_create_cust_acct_site_v2_bo;

Line 2023: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',

2019: END IF;
2020:
2021: -- Debug info.
2022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2023: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
2024: p_prefix=>l_debug_prefix,
2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;
2027:

Line 2029: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;
2027:
2028: -- initialize Global variable
2029: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2030: IF(p_created_by_module IS NULL) THEN
2031: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2032: ELSE
2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 2031: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

2027:
2028: -- initialize Global variable
2029: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2030: IF(p_created_by_module IS NULL) THEN
2031: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2032: ELSE
2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2034: END IF;
2035:

Line 2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2029: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2030: IF(p_created_by_module IS NULL) THEN
2031: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2032: ELSE
2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2034: END IF;
2035:
2036: -------------------------------
2037: -- For Update cust acct site

Line 2089: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2085: END IF;
2086:
2087: -- assign cust_acct_site_id
2088: p_cust_acct_site_v2_obj.cust_acct_site_id := x_cust_acct_site_id;
2089: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2090:
2091: -----------------------------------
2092: -- For cust account contact
2093: -----------------------------------

Line 2114: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;
2112: END IF;
2113:
2114: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2115:
2116: ----------------------------
2117: -- For cust account site use
2118: ----------------------------

Line 2137: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2133: END IF;
2134: END IF;
2135:
2136: -- reset Global variable
2137: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2138: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2139:
2140: -- Debug info.
2141: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2138: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2134: END IF;
2135:
2136: -- reset Global variable
2137: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2138: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2139:
2140: -- Debug info.
2141: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2138: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2139:
2140: -- Debug info.
2141: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'WARNING',
2145: p_msg_level=>fnd_log.level_exception);
2146: END IF;

Line 2148: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',

2144: p_msg_type=>'WARNING',
2145: p_msg_level=>fnd_log.level_exception);
2146: END IF;
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;
2152: EXCEPTION

Line 2157: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2153: WHEN fnd_api.g_exc_error THEN
2154: ROLLBACK TO do_update_cas_v2_bo_pub;
2155:
2156: -- reset Global variable
2157: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2158: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2159:
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2161: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 2158: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2154: ROLLBACK TO do_update_cas_v2_bo_pub;
2155:
2156: -- reset Global variable
2157: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2158: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2159:
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2161: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
2162: FND_MSG_PUB.ADD;

Line 2172: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2168: p_data => x_msg_data);
2169:
2170: -- Debug info.
2171: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2172: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2173: p_msg_data=>x_msg_data,
2174: p_msg_type=>'ERROR',
2175: p_msg_level=>fnd_log.level_error);
2176: END IF;

Line 2178: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',

2174: p_msg_type=>'ERROR',
2175: p_msg_level=>fnd_log.level_error);
2176: END IF;
2177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2178: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2179: p_prefix=>l_debug_prefix,
2180: p_msg_level=>fnd_log.level_procedure);
2181: END IF;
2182:

Line 2187: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2183: WHEN fnd_api.g_exc_unexpected_error THEN
2184: ROLLBACK TO do_update_cas_v2_bo_pub;
2185:
2186: -- reset Global variable
2187: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2188: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2189:
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2191: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 2188: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2184: ROLLBACK TO do_update_cas_v2_bo_pub;
2185:
2186: -- reset Global variable
2187: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2188: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2189:
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2191: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
2192: FND_MSG_PUB.ADD;

Line 2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2198: p_data => x_msg_data);
2199:
2200: -- Debug info.
2201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'UNEXPECTED ERROR',
2205: p_msg_level=>fnd_log.level_error);
2206: END IF;

Line 2208: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',

2204: p_msg_type=>'UNEXPECTED ERROR',
2205: p_msg_level=>fnd_log.level_error);
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2212:

Line 2217: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2213: WHEN OTHERS THEN
2214: ROLLBACK TO do_update_cas_v2_bo_pub;
2215:
2216: -- reset Global variable
2217: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2219:
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2221: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');

Line 2218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2214: ROLLBACK TO do_update_cas_v2_bo_pub;
2215:
2216: -- reset Global variable
2217: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2219:
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2221: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT_SITE');
2222: FND_MSG_PUB.ADD;

Line 2236: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2232: p_data => x_msg_data);
2233:
2234: -- Debug info.
2235: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2236: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2237: p_msg_data=>x_msg_data,
2238: p_msg_type=>'SQL ERROR',
2239: p_msg_level=>fnd_log.level_error);
2240: END IF;

Line 2242: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',

2238: p_msg_type=>'SQL ERROR',
2239: p_msg_level=>fnd_log.level_error);
2240: END IF;
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2243: p_prefix=>l_debug_prefix,
2244: p_msg_level=>fnd_log.level_procedure);
2245: END IF;
2246: END do_update_cust_acct_site_v2_bo;

Line 2323: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(+)',

2319: END IF;
2320:
2321: -- Debug info.
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(+)',
2324: p_prefix=>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_procedure);
2326: END IF;
2327:

Line 2386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2382: END IF;
2383:
2384: -- Debug info.
2385: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2387: p_msg_data=>x_msg_data,
2388: p_msg_type=>'WARNING',
2389: p_msg_level=>fnd_log.level_exception);
2390: END IF;

Line 2392: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',

2388: p_msg_type=>'WARNING',
2389: p_msg_level=>fnd_log.level_exception);
2390: END IF;
2391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2392: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2393: p_prefix=>l_debug_prefix,
2394: p_msg_level=>fnd_log.level_procedure);
2395: END IF;
2396:

Line 2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2403: p_data => x_msg_data);
2404:
2405: -- Debug info.
2406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'ERROR',
2410: p_msg_level=>fnd_log.level_error);
2411: END IF;

Line 2413: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',

2409: p_msg_type=>'ERROR',
2410: p_msg_level=>fnd_log.level_error);
2411: END IF;
2412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2414: p_prefix=>l_debug_prefix,
2415: p_msg_level=>fnd_log.level_procedure);
2416: END IF;
2417: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2422: p_data => x_msg_data);
2423:
2424: -- Debug info.
2425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2427: p_msg_data=>x_msg_data,
2428: p_msg_type=>'UNEXPECTED ERROR',
2429: p_msg_level=>fnd_log.level_error);
2430: END IF;

Line 2432: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',

2428: p_msg_type=>'UNEXPECTED ERROR',
2429: p_msg_level=>fnd_log.level_error);
2430: END IF;
2431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2432: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2433: p_prefix=>l_debug_prefix,
2434: p_msg_level=>fnd_log.level_procedure);
2435: END IF;
2436: WHEN OTHERS THEN

Line 2449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2445: p_data => x_msg_data);
2446:
2447: -- Debug info.
2448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2450: p_msg_data=>x_msg_data,
2451: p_msg_type=>'SQL ERROR',
2452: p_msg_level=>fnd_log.level_error);
2453: END IF;

Line 2455: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',

2451: p_msg_type=>'SQL ERROR',
2452: p_msg_level=>fnd_log.level_error);
2453: END IF;
2454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2455: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2456: p_prefix=>l_debug_prefix,
2457: p_msg_level=>fnd_log.level_procedure);
2458: END IF;
2459: END do_save_cust_acct_site_v2_bo;

Line 2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',

2594:
2595:
2596: -- Debug info.
2597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
2599: p_prefix=>l_debug_prefix,
2600: p_msg_level=>fnd_log.level_procedure);
2601: END IF;
2602:

Line 2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2638:
2639:
2640: -- Debug info.
2641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'WARNING',
2645: p_msg_level=>fnd_log.level_exception);
2646: END IF;

Line 2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2646: END IF;
2647:
2648: -- Debug info.
2649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2651: p_prefix=>l_debug_prefix,
2652: p_msg_level=>fnd_log.level_procedure);
2653: END IF;
2654:

Line 2667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2663: p_data => x_msg_data);
2664:
2665: -- Debug info.
2666: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2668: p_msg_data=>x_msg_data,
2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);
2671: END IF;

Line 2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);
2671: END IF;
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2682: p_data => x_msg_data);
2683:
2684: -- Debug info.
2685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2687: p_msg_data=>x_msg_data,
2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);
2690: END IF;

Line 2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);
2690: END IF;
2691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2693: p_prefix=>l_debug_prefix,
2694: p_msg_level=>fnd_log.level_procedure);
2695: END IF;
2696: WHEN OTHERS THEN

Line 2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2705: p_data => x_msg_data);
2706:
2707: -- Debug info.
2708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2710: p_msg_data=>x_msg_data,
2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713: END IF;

Line 2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713: END IF;
2714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2716: p_prefix=>l_debug_prefix,
2717: p_msg_level=>fnd_log.level_procedure);
2718: END IF;
2719: