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:
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:
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;
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:
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
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: -------------------------------------
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: -------------------------------------
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
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,
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;
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:
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');
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;
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;
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:
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');
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;
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;
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:
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');
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;
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;
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;
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:
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;
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:
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
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: -----------------------------------
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: ----------------------------
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
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,
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;
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
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');
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;
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;
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:
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');
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;
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;
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:
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');
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;
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;
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;
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:
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;
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:
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;
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
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;
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
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;
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;
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:
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;
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:
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;
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
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;
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
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;
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:
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:
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:
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;
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:
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
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: -------------------------------------
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: -------------------------------------
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
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,
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;
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:
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');
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;
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;
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:
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');
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;
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;
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:
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');
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;
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;
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;
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:
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;
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:
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
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: -----------------------------------
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: ----------------------------
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
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,
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;
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
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');
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;
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;
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:
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');
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;
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;
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:
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');
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;
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;
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;
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:
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;
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:
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;
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
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;
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
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;
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;
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:
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;
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:
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;
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
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;
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
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;
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: