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_LOG

Line 253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

249: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
250: END IF;
251:
252: -- Debug info.
253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
255: p_prefix=>l_debug_prefix,
256: p_msg_level=>fnd_log.level_procedure);
257: END IF;

Line 256: p_msg_level=>fnd_log.level_procedure);

252: -- Debug info.
253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
255: p_prefix=>l_debug_prefix,
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

Line 513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
511:
512: -- Debug info.
513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
515: p_msg_data=>x_msg_data,
516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);

Line 517: p_msg_level=>fnd_log.level_exception);

513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
515: p_msg_data=>x_msg_data,
516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);
518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
521: p_prefix=>l_debug_prefix,

Line 519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

515: p_msg_data=>x_msg_data,
516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);
518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
521: p_prefix=>l_debug_prefix,
522: p_msg_level=>fnd_log.level_procedure);
523: END IF;

Line 522: p_msg_level=>fnd_log.level_procedure);

518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
521: p_prefix=>l_debug_prefix,
522: p_msg_level=>fnd_log.level_procedure);
523: END IF;
524:
525: EXCEPTION
526: WHEN fnd_api.g_exc_error THEN

Line 544: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

540: p_count => x_msg_count,
541: p_data => x_msg_data);
542:
543: -- Debug info.
544: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
546: p_msg_data=>x_msg_data,
547: p_msg_type=>'ERROR',
548: p_msg_level=>fnd_log.level_error);

Line 548: p_msg_level=>fnd_log.level_error);

544: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
546: p_msg_data=>x_msg_data,
547: p_msg_type=>'ERROR',
548: p_msg_level=>fnd_log.level_error);
549: END IF;
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
552: p_prefix=>l_debug_prefix,

Line 550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

546: p_msg_data=>x_msg_data,
547: p_msg_type=>'ERROR',
548: p_msg_level=>fnd_log.level_error);
549: END IF;
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;

Line 553: p_msg_level=>fnd_log.level_procedure);

549: END IF;
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
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;

Line 574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

570: p_count => x_msg_count,
571: p_data => x_msg_data);
572:
573: -- Debug info.
574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'UNEXPECTED ERROR',
578: p_msg_level=>fnd_log.level_error);

Line 578: p_msg_level=>fnd_log.level_error);

574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'UNEXPECTED ERROR',
578: p_msg_level=>fnd_log.level_error);
579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
582: p_prefix=>l_debug_prefix,

Line 580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

576: p_msg_data=>x_msg_data,
577: p_msg_type=>'UNEXPECTED ERROR',
578: p_msg_level=>fnd_log.level_error);
579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;

Line 583: p_msg_level=>fnd_log.level_procedure);

579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585:
586: WHEN OTHERS THEN
587: ROLLBACK TO do_create_cust_acct_bo_pub;

Line 608: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

604: p_count => x_msg_count,
605: p_data => x_msg_data);
606:
607: -- Debug info.
608: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
609: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
610: p_msg_data=>x_msg_data,
611: p_msg_type=>'SQL ERROR',
612: p_msg_level=>fnd_log.level_error);

Line 612: p_msg_level=>fnd_log.level_error);

608: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
609: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
610: p_msg_data=>x_msg_data,
611: p_msg_type=>'SQL ERROR',
612: p_msg_level=>fnd_log.level_error);
613: END IF;
614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
616: p_prefix=>l_debug_prefix,

Line 614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

610: p_msg_data=>x_msg_data,
611: p_msg_type=>'SQL ERROR',
612: p_msg_level=>fnd_log.level_error);
613: END IF;
614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
616: p_prefix=>l_debug_prefix,
617: p_msg_level=>fnd_log.level_procedure);
618: END IF;

Line 617: p_msg_level=>fnd_log.level_procedure);

613: END IF;
614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
616: p_prefix=>l_debug_prefix,
617: p_msg_level=>fnd_log.level_procedure);
618: END IF;
619: END do_create_cust_acct_bo;
620:
621: PROCEDURE create_cust_acct_bo(

Line 827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
824: END IF;
825:
826: -- Debug info.
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
829: p_prefix=>l_debug_prefix,
830: p_msg_level=>fnd_log.level_procedure);
831: END IF;

Line 830: p_msg_level=>fnd_log.level_procedure);

826: -- Debug info.
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
829: p_prefix=>l_debug_prefix,
830: p_msg_level=>fnd_log.level_procedure);
831: END IF;
832:
833: -------------------------------
834: -- For Update cust accts

Line 1038: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1034: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1035: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1036:
1037: -- Debug info.
1038: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1039: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1040: p_msg_data=>x_msg_data,
1041: p_msg_type=>'WARNING',
1042: p_msg_level=>fnd_log.level_exception);

Line 1042: p_msg_level=>fnd_log.level_exception);

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

Line 1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1040: p_msg_data=>x_msg_data,
1041: p_msg_type=>'WARNING',
1042: p_msg_level=>fnd_log.level_exception);
1043: END IF;
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;

Line 1047: p_msg_level=>fnd_log.level_procedure);

1043: END IF;
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
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;

Line 1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1064: p_count => x_msg_count,
1065: p_data => x_msg_data);
1066:
1067: -- Debug info.
1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);

Line 1072: p_msg_level=>fnd_log.level_error);

1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1076: p_prefix=>l_debug_prefix,

Line 1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;

Line 1077: p_msg_level=>fnd_log.level_procedure);

1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
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;

Line 1098: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1094: p_count => x_msg_count,
1095: p_data => x_msg_data);
1096:
1097: -- Debug info.
1098: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1099: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1100: p_msg_data=>x_msg_data,
1101: p_msg_type=>'UNEXPECTED ERROR',
1102: p_msg_level=>fnd_log.level_error);

Line 1102: p_msg_level=>fnd_log.level_error);

1098: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1099: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1100: p_msg_data=>x_msg_data,
1101: p_msg_type=>'UNEXPECTED ERROR',
1102: p_msg_level=>fnd_log.level_error);
1103: END IF;
1104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1106: p_prefix=>l_debug_prefix,

Line 1104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1100: p_msg_data=>x_msg_data,
1101: p_msg_type=>'UNEXPECTED ERROR',
1102: p_msg_level=>fnd_log.level_error);
1103: END IF;
1104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1106: p_prefix=>l_debug_prefix,
1107: p_msg_level=>fnd_log.level_procedure);
1108: END IF;

Line 1107: p_msg_level=>fnd_log.level_procedure);

1103: END IF;
1104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1106: p_prefix=>l_debug_prefix,
1107: p_msg_level=>fnd_log.level_procedure);
1108: END IF;
1109:
1110: WHEN OTHERS THEN
1111: ROLLBACK TO do_update_cust_acct_bo_pub;

Line 1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1128: p_count => x_msg_count,
1129: p_data => x_msg_data);
1130:
1131: -- Debug info.
1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'SQL ERROR',
1136: p_msg_level=>fnd_log.level_error);

Line 1136: p_msg_level=>fnd_log.level_error);

1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'SQL ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1140: p_prefix=>l_debug_prefix,

Line 1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'SQL ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;

Line 1141: p_msg_level=>fnd_log.level_procedure);

1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: END do_update_cust_acct_bo;
1144:
1145: -- PROCEDURE do_save_cust_acct_bo

Line 1181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1177: FND_MSG_PUB.initialize;
1178: END IF;
1179:
1180: -- Debug info.
1181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1182: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1183: p_prefix=>l_debug_prefix,
1184: p_msg_level=>fnd_log.level_procedure);
1185: END IF;

Line 1184: p_msg_level=>fnd_log.level_procedure);

1180: -- Debug info.
1181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1182: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1183: p_prefix=>l_debug_prefix,
1184: p_msg_level=>fnd_log.level_procedure);
1185: END IF;
1186:
1187: x_cust_acct_id := p_cust_acct_obj.cust_acct_id;
1188: x_cust_acct_os := p_cust_acct_obj.orig_system;

Line 1244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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
1245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1246: p_msg_data=>x_msg_data,
1247: p_msg_type=>'WARNING',
1248: p_msg_level=>fnd_log.level_exception);

Line 1248: p_msg_level=>fnd_log.level_exception);

1244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1246: p_msg_data=>x_msg_data,
1247: p_msg_type=>'WARNING',
1248: p_msg_level=>fnd_log.level_exception);
1249: END IF;
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1252: p_prefix=>l_debug_prefix,

Line 1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1246: p_msg_data=>x_msg_data,
1247: p_msg_type=>'WARNING',
1248: p_msg_level=>fnd_log.level_exception);
1249: END IF;
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1252: p_prefix=>l_debug_prefix,
1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;

Line 1253: p_msg_level=>fnd_log.level_procedure);

1249: END IF;
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1252: p_prefix=>l_debug_prefix,
1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN

Line 1267: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1263: p_count => x_msg_count,
1264: p_data => x_msg_data);
1265:
1266: -- Debug info.
1267: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1269: p_msg_data=>x_msg_data,
1270: p_msg_type=>'ERROR',
1271: p_msg_level=>fnd_log.level_error);

Line 1271: p_msg_level=>fnd_log.level_error);

1267: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1269: p_msg_data=>x_msg_data,
1270: p_msg_type=>'ERROR',
1271: p_msg_level=>fnd_log.level_error);
1272: END IF;
1273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1274: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1275: p_prefix=>l_debug_prefix,

Line 1273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1269: p_msg_data=>x_msg_data,
1270: p_msg_type=>'ERROR',
1271: p_msg_level=>fnd_log.level_error);
1272: END IF;
1273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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;

Line 1276: p_msg_level=>fnd_log.level_procedure);

1272: END IF;
1273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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:

Line 1286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1282: p_count => x_msg_count,
1283: p_data => x_msg_data);
1284:
1285: -- Debug info.
1286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1287: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1288: p_msg_data=>x_msg_data,
1289: p_msg_type=>'UNEXPECTED ERROR',
1290: p_msg_level=>fnd_log.level_error);

Line 1290: p_msg_level=>fnd_log.level_error);

1286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1287: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1288: p_msg_data=>x_msg_data,
1289: p_msg_type=>'UNEXPECTED ERROR',
1290: p_msg_level=>fnd_log.level_error);
1291: END IF;
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1294: p_prefix=>l_debug_prefix,

Line 1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1288: p_msg_data=>x_msg_data,
1289: p_msg_type=>'UNEXPECTED ERROR',
1290: p_msg_level=>fnd_log.level_error);
1291: END IF;
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1294: p_prefix=>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_procedure);
1296: END IF;

Line 1295: p_msg_level=>fnd_log.level_procedure);

1291: END IF;
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
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:

Line 1309: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1305: p_count => x_msg_count,
1306: p_data => x_msg_data);
1307:
1308: -- Debug info.
1309: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'SQL ERROR',
1313: p_msg_level=>fnd_log.level_error);

Line 1313: p_msg_level=>fnd_log.level_error);

1309: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'SQL ERROR',
1313: p_msg_level=>fnd_log.level_error);
1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1317: p_prefix=>l_debug_prefix,

Line 1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'SQL ERROR',
1313: p_msg_level=>fnd_log.level_error);
1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;

Line 1318: p_msg_level=>fnd_log.level_procedure);

1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;
1320: END do_save_cust_acct_bo;
1321:
1322: PROCEDURE save_cust_acct_bo(

Line 1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1489: END IF;
1490:
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;

Line 1496: p_msg_level=>fnd_log.level_procedure);

1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:
1499: -- check if pass in contact_point_id and/or os+osr
1500: -- extraction validation logic is same as update

Line 1537: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1533: END IF;
1534:
1535:
1536: -- Debug info.
1537: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1538: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1539: p_msg_data=>x_msg_data,
1540: p_msg_type=>'WARNING',
1541: p_msg_level=>fnd_log.level_exception);

Line 1541: p_msg_level=>fnd_log.level_exception);

1537: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1538: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1539: p_msg_data=>x_msg_data,
1540: p_msg_type=>'WARNING',
1541: p_msg_level=>fnd_log.level_exception);
1542: END IF;
1543:
1544: -- Debug info.
1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1541: p_msg_level=>fnd_log.level_exception);
1542: END IF;
1543:
1544: -- Debug info.
1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1546: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1547: p_prefix=>l_debug_prefix,
1548: p_msg_level=>fnd_log.level_procedure);
1549: END IF;

Line 1548: p_msg_level=>fnd_log.level_procedure);

1544: -- Debug info.
1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1546: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1547: p_prefix=>l_debug_prefix,
1548: p_msg_level=>fnd_log.level_procedure);
1549: END IF;
1550:
1551:
1552: EXCEPTION

Line 1562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1558: p_count => x_msg_count,
1559: p_data => x_msg_data);
1560:
1561: -- Debug info.
1562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1564: p_msg_data=>x_msg_data,
1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);

Line 1566: p_msg_level=>fnd_log.level_error);

1562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1564: p_msg_data=>x_msg_data,
1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);
1567: END IF;
1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1569: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1570: p_prefix=>l_debug_prefix,

Line 1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1564: p_msg_data=>x_msg_data,
1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);
1567: END IF;
1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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;

Line 1571: p_msg_level=>fnd_log.level_procedure);

1567: END IF;
1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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:

Line 1581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1577: p_count => x_msg_count,
1578: p_data => x_msg_data);
1579:
1580: -- Debug info.
1581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1583: p_msg_data=>x_msg_data,
1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);

Line 1585: p_msg_level=>fnd_log.level_error);

1581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1583: p_msg_data=>x_msg_data,
1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);
1586: END IF;
1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1589: p_prefix=>l_debug_prefix,

Line 1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1583: p_msg_data=>x_msg_data,
1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);
1586: END IF;
1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1589: p_prefix=>l_debug_prefix,
1590: p_msg_level=>fnd_log.level_procedure);
1591: END IF;

Line 1590: p_msg_level=>fnd_log.level_procedure);

1586: END IF;
1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
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:

Line 1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602:
1603: -- Debug info.
1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'SQL ERROR',
1608: p_msg_level=>fnd_log.level_error);

Line 1608: p_msg_level=>fnd_log.level_error);

1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'SQL ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1612: p_prefix=>l_debug_prefix,

Line 1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'SQL ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;

Line 1613: p_msg_level=>fnd_log.level_procedure);

1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615:
1616: end;
1617:

Line 1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1891: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1892: END IF;
1893:
1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',
1897: p_prefix=>l_debug_prefix,
1898: p_msg_level=>fnd_log.level_procedure);
1899: END IF;

Line 1898: p_msg_level=>fnd_log.level_procedure);

1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',
1897: p_prefix=>l_debug_prefix,
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

Line 2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: -- Debug info.
2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2157: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2158: p_msg_data=>x_msg_data,
2159: p_msg_type=>'WARNING',
2160: p_msg_level=>fnd_log.level_exception);

Line 2160: p_msg_level=>fnd_log.level_exception);

2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2157: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2158: p_msg_data=>x_msg_data,
2159: p_msg_type=>'WARNING',
2160: p_msg_level=>fnd_log.level_exception);
2161: END IF;
2162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2164: p_prefix=>l_debug_prefix,

Line 2162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2158: p_msg_data=>x_msg_data,
2159: p_msg_type=>'WARNING',
2160: p_msg_level=>fnd_log.level_exception);
2161: END IF;
2162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2164: p_prefix=>l_debug_prefix,
2165: p_msg_level=>fnd_log.level_procedure);
2166: END IF;

Line 2165: p_msg_level=>fnd_log.level_procedure);

2161: END IF;
2162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2164: p_prefix=>l_debug_prefix,
2165: p_msg_level=>fnd_log.level_procedure);
2166: END IF;
2167:
2168: EXCEPTION
2169: WHEN fnd_api.g_exc_error THEN

Line 2187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2183: p_count => x_msg_count,
2184: p_data => x_msg_data);
2185:
2186: -- Debug info.
2187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2189: p_msg_data=>x_msg_data,
2190: p_msg_type=>'ERROR',
2191: p_msg_level=>fnd_log.level_error);

Line 2191: p_msg_level=>fnd_log.level_error);

2187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2189: p_msg_data=>x_msg_data,
2190: p_msg_type=>'ERROR',
2191: p_msg_level=>fnd_log.level_error);
2192: END IF;
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2195: p_prefix=>l_debug_prefix,

Line 2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2189: p_msg_data=>x_msg_data,
2190: p_msg_type=>'ERROR',
2191: p_msg_level=>fnd_log.level_error);
2192: END IF;
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);
2197: END IF;

Line 2196: p_msg_level=>fnd_log.level_procedure);

2192: END IF;
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
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;

Line 2217: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2213: p_count => x_msg_count,
2214: p_data => x_msg_data);
2215:
2216: -- Debug info.
2217: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2218: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2219: p_msg_data=>x_msg_data,
2220: p_msg_type=>'UNEXPECTED ERROR',
2221: p_msg_level=>fnd_log.level_error);

Line 2221: p_msg_level=>fnd_log.level_error);

2217: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2218: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2219: p_msg_data=>x_msg_data,
2220: p_msg_type=>'UNEXPECTED ERROR',
2221: p_msg_level=>fnd_log.level_error);
2222: END IF;
2223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2224: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2225: p_prefix=>l_debug_prefix,

Line 2223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2219: p_msg_data=>x_msg_data,
2220: p_msg_type=>'UNEXPECTED ERROR',
2221: p_msg_level=>fnd_log.level_error);
2222: END IF;
2223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2224: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2225: p_prefix=>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_procedure);
2227: END IF;

Line 2226: p_msg_level=>fnd_log.level_procedure);

2222: END IF;
2223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2224: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2225: p_prefix=>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_procedure);
2227: END IF;
2228:
2229: WHEN OTHERS THEN
2230: ROLLBACK TO do_create_cust_acct_v2_bo_pub;

Line 2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2247: p_count => x_msg_count,
2248: p_data => x_msg_data);
2249:
2250: -- Debug info.
2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'SQL ERROR',
2255: p_msg_level=>fnd_log.level_error);

Line 2255: p_msg_level=>fnd_log.level_error);

2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'SQL ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2259: p_prefix=>l_debug_prefix,

Line 2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'SQL ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;

Line 2260: p_msg_level=>fnd_log.level_procedure);

2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;
2262: END do_create_cust_acct_v2_bo;
2263:
2264: PROCEDURE create_cust_acct_v2_bo(

Line 2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2399: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2400: END IF;
2401:
2402: -- Debug info.
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;

Line 2406: p_msg_level=>fnd_log.level_procedure);

2402: -- Debug info.
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;
2408:
2409: -------------------------------
2410: -- For Update cust accts

Line 2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2611: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2612: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2613:
2614: -- Debug info.
2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2617: p_msg_data=>x_msg_data,
2618: p_msg_type=>'WARNING',
2619: p_msg_level=>fnd_log.level_exception);

Line 2619: p_msg_level=>fnd_log.level_exception);

2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2617: p_msg_data=>x_msg_data,
2618: p_msg_type=>'WARNING',
2619: p_msg_level=>fnd_log.level_exception);
2620: END IF;
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2623: p_prefix=>l_debug_prefix,

Line 2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2617: p_msg_data=>x_msg_data,
2618: p_msg_type=>'WARNING',
2619: p_msg_level=>fnd_log.level_exception);
2620: END IF;
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;

Line 2624: p_msg_level=>fnd_log.level_procedure);

2620: END IF;
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
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;

Line 2645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2641: p_count => x_msg_count,
2642: p_data => x_msg_data);
2643:
2644: -- Debug info.
2645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2647: p_msg_data=>x_msg_data,
2648: p_msg_type=>'ERROR',
2649: p_msg_level=>fnd_log.level_error);

Line 2649: p_msg_level=>fnd_log.level_error);

2645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2647: p_msg_data=>x_msg_data,
2648: p_msg_type=>'ERROR',
2649: p_msg_level=>fnd_log.level_error);
2650: END IF;
2651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2652: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2653: p_prefix=>l_debug_prefix,

Line 2651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2647: p_msg_data=>x_msg_data,
2648: p_msg_type=>'ERROR',
2649: p_msg_level=>fnd_log.level_error);
2650: END IF;
2651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2652: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2653: p_prefix=>l_debug_prefix,
2654: p_msg_level=>fnd_log.level_procedure);
2655: END IF;

Line 2654: p_msg_level=>fnd_log.level_procedure);

2650: END IF;
2651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2652: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
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;

Line 2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2671: p_count => x_msg_count,
2672: p_data => x_msg_data);
2673:
2674: -- Debug info.
2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'UNEXPECTED ERROR',
2679: p_msg_level=>fnd_log.level_error);

Line 2679: p_msg_level=>fnd_log.level_error);

2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'UNEXPECTED ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2683: p_prefix=>l_debug_prefix,

Line 2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'UNEXPECTED ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;

Line 2684: p_msg_level=>fnd_log.level_procedure);

2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;
2686:
2687: WHEN OTHERS THEN
2688: ROLLBACK TO do_update_cust_acct_v2_bo_pub;

Line 2709: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 2713: p_msg_level=>fnd_log.level_error);

2709: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2711: p_msg_data=>x_msg_data,
2712: p_msg_type=>'SQL ERROR',
2713: p_msg_level=>fnd_log.level_error);
2714: END IF;
2715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2717: p_prefix=>l_debug_prefix,

Line 2715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 2718: p_msg_level=>fnd_log.level_procedure);

2714: END IF;
2715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2717: p_prefix=>l_debug_prefix,
2718: p_msg_level=>fnd_log.level_procedure);
2719: END IF;
2720: END do_update_cust_acct_v2_bo;
2721:
2722: -- PROCEDURE do_save_cust_acct_v2_bo

Line 2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2754: FND_MSG_PUB.initialize;
2755: END IF;
2756:
2757: -- Debug info.
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;

Line 2761: p_msg_level=>fnd_log.level_procedure);

2757: -- Debug info.
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763:
2764: x_cust_acct_id := p_cust_acct_v2_obj.cust_acct_id;
2765: x_cust_acct_os := p_cust_acct_v2_obj.orig_system;

Line 2821: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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
2822: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2823: p_msg_data=>x_msg_data,
2824: p_msg_type=>'WARNING',
2825: p_msg_level=>fnd_log.level_exception);

Line 2825: p_msg_level=>fnd_log.level_exception);

2821: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2822: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2823: p_msg_data=>x_msg_data,
2824: p_msg_type=>'WARNING',
2825: p_msg_level=>fnd_log.level_exception);
2826: END IF;
2827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2828: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2829: p_prefix=>l_debug_prefix,

Line 2827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2823: p_msg_data=>x_msg_data,
2824: p_msg_type=>'WARNING',
2825: p_msg_level=>fnd_log.level_exception);
2826: END IF;
2827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2828: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2829: p_prefix=>l_debug_prefix,
2830: p_msg_level=>fnd_log.level_procedure);
2831: END IF;

Line 2830: p_msg_level=>fnd_log.level_procedure);

2826: END IF;
2827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2828: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2829: p_prefix=>l_debug_prefix,
2830: p_msg_level=>fnd_log.level_procedure);
2831: END IF;
2832:
2833: EXCEPTION
2834: WHEN fnd_api.g_exc_error THEN

Line 2844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2840: p_count => x_msg_count,
2841: p_data => x_msg_data);
2842:
2843: -- Debug info.
2844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2846: p_msg_data=>x_msg_data,
2847: p_msg_type=>'ERROR',
2848: p_msg_level=>fnd_log.level_error);

Line 2848: p_msg_level=>fnd_log.level_error);

2844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2846: p_msg_data=>x_msg_data,
2847: p_msg_type=>'ERROR',
2848: p_msg_level=>fnd_log.level_error);
2849: END IF;
2850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2851: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2852: p_prefix=>l_debug_prefix,

Line 2850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2846: p_msg_data=>x_msg_data,
2847: p_msg_type=>'ERROR',
2848: p_msg_level=>fnd_log.level_error);
2849: END IF;
2850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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;

Line 2853: p_msg_level=>fnd_log.level_procedure);

2849: END IF;
2850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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:

Line 2863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2859: p_count => x_msg_count,
2860: p_data => x_msg_data);
2861:
2862: -- Debug info.
2863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2865: p_msg_data=>x_msg_data,
2866: p_msg_type=>'UNEXPECTED ERROR',
2867: p_msg_level=>fnd_log.level_error);

Line 2867: p_msg_level=>fnd_log.level_error);

2863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2865: p_msg_data=>x_msg_data,
2866: p_msg_type=>'UNEXPECTED ERROR',
2867: p_msg_level=>fnd_log.level_error);
2868: END IF;
2869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2870: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2871: p_prefix=>l_debug_prefix,

Line 2869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2865: p_msg_data=>x_msg_data,
2866: p_msg_type=>'UNEXPECTED ERROR',
2867: p_msg_level=>fnd_log.level_error);
2868: END IF;
2869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2870: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2871: p_prefix=>l_debug_prefix,
2872: p_msg_level=>fnd_log.level_procedure);
2873: END IF;

Line 2872: p_msg_level=>fnd_log.level_procedure);

2868: END IF;
2869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2870: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
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:

Line 2886: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2882: p_count => x_msg_count,
2883: p_data => x_msg_data);
2884:
2885: -- Debug info.
2886: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2888: p_msg_data=>x_msg_data,
2889: p_msg_type=>'SQL ERROR',
2890: p_msg_level=>fnd_log.level_error);

Line 2890: p_msg_level=>fnd_log.level_error);

2886: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2888: p_msg_data=>x_msg_data,
2889: p_msg_type=>'SQL ERROR',
2890: p_msg_level=>fnd_log.level_error);
2891: END IF;
2892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2893: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2894: p_prefix=>l_debug_prefix,

Line 2892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2888: p_msg_data=>x_msg_data,
2889: p_msg_type=>'SQL ERROR',
2890: p_msg_level=>fnd_log.level_error);
2891: END IF;
2892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2893: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2894: p_prefix=>l_debug_prefix,
2895: p_msg_level=>fnd_log.level_procedure);
2896: END IF;

Line 2895: p_msg_level=>fnd_log.level_procedure);

2891: END IF;
2892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2893: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2894: p_prefix=>l_debug_prefix,
2895: p_msg_level=>fnd_log.level_procedure);
2896: END IF;
2897: END do_save_cust_acct_v2_bo;
2898:
2899: PROCEDURE save_cust_acct_v2_bo(

Line 3033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3029: END IF;
3030:
3031:
3032: -- Debug info.
3033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3034: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3035: p_prefix=>l_debug_prefix,
3036: p_msg_level=>fnd_log.level_procedure);
3037: END IF;

Line 3036: p_msg_level=>fnd_log.level_procedure);

3032: -- Debug info.
3033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3034: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3035: p_prefix=>l_debug_prefix,
3036: p_msg_level=>fnd_log.level_procedure);
3037: END IF;
3038:
3039: -- check if pass in contact_point_id and/or os+osr
3040: -- extraction validation logic is same as update

Line 3077: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3073: END IF;
3074:
3075:
3076: -- Debug info.
3077: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'WARNING',
3081: p_msg_level=>fnd_log.level_exception);

Line 3081: p_msg_level=>fnd_log.level_exception);

3077: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'WARNING',
3081: p_msg_level=>fnd_log.level_exception);
3082: END IF;
3083:
3084: -- Debug info.
3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3081: p_msg_level=>fnd_log.level_exception);
3082: END IF;
3083:
3084: -- Debug info.
3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3086: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3087: p_prefix=>l_debug_prefix,
3088: p_msg_level=>fnd_log.level_procedure);
3089: END IF;

Line 3088: p_msg_level=>fnd_log.level_procedure);

3084: -- Debug info.
3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3086: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3087: p_prefix=>l_debug_prefix,
3088: p_msg_level=>fnd_log.level_procedure);
3089: END IF;
3090:
3091:
3092: EXCEPTION

Line 3102: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3098: p_count => x_msg_count,
3099: p_data => x_msg_data);
3100:
3101: -- Debug info.
3102: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3104: p_msg_data=>x_msg_data,
3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);

Line 3106: p_msg_level=>fnd_log.level_error);

3102: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3104: p_msg_data=>x_msg_data,
3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);
3107: END IF;
3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3109: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3110: p_prefix=>l_debug_prefix,

Line 3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3104: p_msg_data=>x_msg_data,
3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);
3107: END IF;
3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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;

Line 3111: p_msg_level=>fnd_log.level_procedure);

3107: END IF;
3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level 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:

Line 3121: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3117: p_count => x_msg_count,
3118: p_data => x_msg_data);
3119:
3120: -- Debug info.
3121: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3123: p_msg_data=>x_msg_data,
3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);

Line 3125: p_msg_level=>fnd_log.level_error);

3121: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3123: p_msg_data=>x_msg_data,
3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);
3126: END IF;
3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3129: p_prefix=>l_debug_prefix,

Line 3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3123: p_msg_data=>x_msg_data,
3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);
3126: END IF;
3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3129: p_prefix=>l_debug_prefix,
3130: p_msg_level=>fnd_log.level_procedure);
3131: END IF;

Line 3130: p_msg_level=>fnd_log.level_procedure);

3126: END IF;
3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
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:

Line 3144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3140: p_count => x_msg_count,
3141: p_data => x_msg_data);
3142:
3143: -- Debug info.
3144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3145: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3146: p_msg_data=>x_msg_data,
3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);

Line 3148: p_msg_level=>fnd_log.level_error);

3144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3145: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3146: p_msg_data=>x_msg_data,
3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3152: p_prefix=>l_debug_prefix,

Line 3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3146: p_msg_data=>x_msg_data,
3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;

Line 3153: p_msg_level=>fnd_log.level_procedure);

3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;
3155:
3156: end;
3157: