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 371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

367: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
368: END IF;
369:
370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
373: p_prefix=>l_debug_prefix,
374: p_msg_level=>fnd_log.level_procedure);
375: END IF;

Line 374: p_msg_level=>fnd_log.level_procedure);

370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
373: p_prefix=>l_debug_prefix,
374: p_msg_level=>fnd_log.level_procedure);
375: END IF;
376:
377: -- Base on p_validate_bo_flag, check the completeness of business objects
378: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

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

637: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
638: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
639:
640: -- Debug info.
641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
643: p_msg_data=>x_msg_data,
644: p_msg_type=>'WARNING',
645: p_msg_level=>fnd_log.level_exception);

Line 645: p_msg_level=>fnd_log.level_exception);

641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
643: p_msg_data=>x_msg_data,
644: p_msg_type=>'WARNING',
645: p_msg_level=>fnd_log.level_exception);
646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
649: p_prefix=>l_debug_prefix,

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

643: p_msg_data=>x_msg_data,
644: p_msg_type=>'WARNING',
645: p_msg_level=>fnd_log.level_exception);
646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;

Line 650: p_msg_level=>fnd_log.level_procedure);

646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652:
653: EXCEPTION
654: WHEN fnd_api.g_exc_error THEN

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

668: p_count => x_msg_count,
669: p_data => x_msg_data);
670:
671: -- Debug info.
672: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
674: p_msg_data=>x_msg_data,
675: p_msg_type=>'ERROR',
676: p_msg_level=>fnd_log.level_error);

Line 676: p_msg_level=>fnd_log.level_error);

672: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
674: p_msg_data=>x_msg_data,
675: p_msg_type=>'ERROR',
676: p_msg_level=>fnd_log.level_error);
677: END IF;
678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
680: p_prefix=>l_debug_prefix,

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

674: p_msg_data=>x_msg_data,
675: p_msg_type=>'ERROR',
676: p_msg_level=>fnd_log.level_error);
677: END IF;
678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
680: p_prefix=>l_debug_prefix,
681: p_msg_level=>fnd_log.level_procedure);
682: END IF;

Line 681: p_msg_level=>fnd_log.level_procedure);

677: END IF;
678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
680: p_prefix=>l_debug_prefix,
681: p_msg_level=>fnd_log.level_procedure);
682: END IF;
683:
684: WHEN fnd_api.g_exc_unexpected_error THEN
685: ROLLBACK TO do_create_cust_acct_bo_pub;

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

698: p_count => x_msg_count,
699: p_data => x_msg_data);
700:
701: -- Debug info.
702: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
704: p_msg_data=>x_msg_data,
705: p_msg_type=>'UNEXPECTED ERROR',
706: p_msg_level=>fnd_log.level_error);

Line 706: p_msg_level=>fnd_log.level_error);

702: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
704: p_msg_data=>x_msg_data,
705: p_msg_type=>'UNEXPECTED ERROR',
706: p_msg_level=>fnd_log.level_error);
707: END IF;
708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
710: p_prefix=>l_debug_prefix,

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

704: p_msg_data=>x_msg_data,
705: p_msg_type=>'UNEXPECTED ERROR',
706: p_msg_level=>fnd_log.level_error);
707: END IF;
708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
710: p_prefix=>l_debug_prefix,
711: p_msg_level=>fnd_log.level_procedure);
712: END IF;

Line 711: p_msg_level=>fnd_log.level_procedure);

707: END IF;
708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
710: p_prefix=>l_debug_prefix,
711: p_msg_level=>fnd_log.level_procedure);
712: END IF;
713:
714: WHEN OTHERS THEN
715: ROLLBACK TO do_create_cust_acct_bo_pub;

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

732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: -- Debug info.
736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'SQL ERROR',
740: p_msg_level=>fnd_log.level_error);

Line 740: p_msg_level=>fnd_log.level_error);

736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'SQL ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
744: p_prefix=>l_debug_prefix,

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

738: p_msg_data=>x_msg_data,
739: p_msg_type=>'SQL ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;

Line 745: p_msg_level=>fnd_log.level_procedure);

741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747: END do_create_cust_acct_bo;
748:
749:

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

952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
953: END IF;
954:
955: -- Debug info.
956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
957: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
958: p_prefix=>l_debug_prefix,
959: p_msg_level=>fnd_log.level_procedure);
960: END IF;

Line 959: p_msg_level=>fnd_log.level_procedure);

955: -- Debug info.
956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
957: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
958: p_prefix=>l_debug_prefix,
959: p_msg_level=>fnd_log.level_procedure);
960: END IF;
961:
962: -------------------------------
963: -- For Update cust accts

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

1163: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1164: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1169: p_msg_data=>x_msg_data,
1170: p_msg_type=>'WARNING',
1171: p_msg_level=>fnd_log.level_exception);

Line 1171: p_msg_level=>fnd_log.level_exception);

1167: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1169: p_msg_data=>x_msg_data,
1170: p_msg_type=>'WARNING',
1171: p_msg_level=>fnd_log.level_exception);
1172: END IF;
1173: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1174: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1175: p_prefix=>l_debug_prefix,

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

1169: p_msg_data=>x_msg_data,
1170: p_msg_type=>'WARNING',
1171: p_msg_level=>fnd_log.level_exception);
1172: END IF;
1173: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1174: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1175: p_prefix=>l_debug_prefix,
1176: p_msg_level=>fnd_log.level_procedure);
1177: END IF;

Line 1176: p_msg_level=>fnd_log.level_procedure);

1172: END IF;
1173: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1174: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1175: p_prefix=>l_debug_prefix,
1176: p_msg_level=>fnd_log.level_procedure);
1177: END IF;
1178: EXCEPTION
1179: WHEN fnd_api.g_exc_error THEN
1180: ROLLBACK TO do_update_cust_acct_bo_pub;

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

1193: p_count => x_msg_count,
1194: p_data => x_msg_data);
1195:
1196: -- Debug info.
1197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);

Line 1201: p_msg_level=>fnd_log.level_error);

1197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);
1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1205: p_prefix=>l_debug_prefix,

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

1199: p_msg_data=>x_msg_data,
1200: p_msg_type=>'ERROR',
1201: p_msg_level=>fnd_log.level_error);
1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;

Line 1206: p_msg_level=>fnd_log.level_procedure);

1202: END IF;
1203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1204: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;
1208:
1209: WHEN fnd_api.g_exc_unexpected_error THEN
1210: ROLLBACK TO do_update_cust_acct_bo_pub;

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

1223: p_count => x_msg_count,
1224: p_data => x_msg_data);
1225:
1226: -- Debug info.
1227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'UNEXPECTED ERROR',
1231: p_msg_level=>fnd_log.level_error);

Line 1231: p_msg_level=>fnd_log.level_error);

1227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'UNEXPECTED ERROR',
1231: p_msg_level=>fnd_log.level_error);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1235: p_prefix=>l_debug_prefix,

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

1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'UNEXPECTED ERROR',
1231: p_msg_level=>fnd_log.level_error);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;

Line 1236: p_msg_level=>fnd_log.level_procedure);

1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238:
1239: WHEN OTHERS THEN
1240: ROLLBACK TO do_update_cust_acct_bo_pub;

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

1257: p_count => x_msg_count,
1258: p_data => x_msg_data);
1259:
1260: -- Debug info.
1261: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1263: p_msg_data=>x_msg_data,
1264: p_msg_type=>'SQL ERROR',
1265: p_msg_level=>fnd_log.level_error);

Line 1265: p_msg_level=>fnd_log.level_error);

1261: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1263: p_msg_data=>x_msg_data,
1264: p_msg_type=>'SQL ERROR',
1265: p_msg_level=>fnd_log.level_error);
1266: END IF;
1267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1269: p_prefix=>l_debug_prefix,

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

1263: p_msg_data=>x_msg_data,
1264: p_msg_type=>'SQL ERROR',
1265: p_msg_level=>fnd_log.level_error);
1266: END IF;
1267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1269: p_prefix=>l_debug_prefix,
1270: p_msg_level=>fnd_log.level_procedure);
1271: END IF;

Line 1270: p_msg_level=>fnd_log.level_procedure);

1266: END IF;
1267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1269: p_prefix=>l_debug_prefix,
1270: p_msg_level=>fnd_log.level_procedure);
1271: END IF;
1272: END do_update_cust_acct_bo;
1273:
1274: -- PROCEDURE do_save_cust_acct_bo

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

1306: FND_MSG_PUB.initialize;
1307: END IF;
1308:
1309: -- Debug info.
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;

Line 1313: p_msg_level=>fnd_log.level_procedure);

1309: -- Debug info.
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315:
1316: x_cust_acct_id := p_cust_acct_obj.cust_acct_id;
1317: x_cust_acct_os := p_cust_acct_obj.orig_system;

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

1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:
1372: -- Debug info.
1373: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1374: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'WARNING',
1377: p_msg_level=>fnd_log.level_exception);

Line 1377: p_msg_level=>fnd_log.level_exception);

1373: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1374: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'WARNING',
1377: p_msg_level=>fnd_log.level_exception);
1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1381: p_prefix=>l_debug_prefix,

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

1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'WARNING',
1377: p_msg_level=>fnd_log.level_exception);
1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1381: p_prefix=>l_debug_prefix,
1382: p_msg_level=>fnd_log.level_procedure);
1383: END IF;

Line 1382: p_msg_level=>fnd_log.level_procedure);

1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1381: p_prefix=>l_debug_prefix,
1382: p_msg_level=>fnd_log.level_procedure);
1383: END IF;
1384:
1385: EXCEPTION
1386: WHEN fnd_api.g_exc_error THEN

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

1392: p_count => x_msg_count,
1393: p_data => x_msg_data);
1394:
1395: -- Debug info.
1396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1398: p_msg_data=>x_msg_data,
1399: p_msg_type=>'ERROR',
1400: p_msg_level=>fnd_log.level_error);

Line 1400: p_msg_level=>fnd_log.level_error);

1396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1398: p_msg_data=>x_msg_data,
1399: p_msg_type=>'ERROR',
1400: p_msg_level=>fnd_log.level_error);
1401: END IF;
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1404: p_prefix=>l_debug_prefix,

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

1398: p_msg_data=>x_msg_data,
1399: p_msg_type=>'ERROR',
1400: p_msg_level=>fnd_log.level_error);
1401: END IF;
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;

Line 1405: p_msg_level=>fnd_log.level_procedure);

1401: END IF;
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407: WHEN fnd_api.g_exc_unexpected_error THEN
1408: x_return_status := fnd_api.g_ret_sts_unexp_error;
1409:

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

1411: p_count => x_msg_count,
1412: p_data => x_msg_data);
1413:
1414: -- Debug info.
1415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1417: p_msg_data=>x_msg_data,
1418: p_msg_type=>'UNEXPECTED ERROR',
1419: p_msg_level=>fnd_log.level_error);

Line 1419: p_msg_level=>fnd_log.level_error);

1415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1417: p_msg_data=>x_msg_data,
1418: p_msg_type=>'UNEXPECTED ERROR',
1419: p_msg_level=>fnd_log.level_error);
1420: END IF;
1421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1423: p_prefix=>l_debug_prefix,

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

1417: p_msg_data=>x_msg_data,
1418: p_msg_type=>'UNEXPECTED ERROR',
1419: p_msg_level=>fnd_log.level_error);
1420: END IF;
1421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1423: p_prefix=>l_debug_prefix,
1424: p_msg_level=>fnd_log.level_procedure);
1425: END IF;

Line 1424: p_msg_level=>fnd_log.level_procedure);

1420: END IF;
1421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1423: p_prefix=>l_debug_prefix,
1424: p_msg_level=>fnd_log.level_procedure);
1425: END IF;
1426: WHEN OTHERS THEN
1427: x_return_status := fnd_api.g_ret_sts_unexp_error;
1428:

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

1434: p_count => x_msg_count,
1435: p_data => x_msg_data);
1436:
1437: -- Debug info.
1438: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1440: p_msg_data=>x_msg_data,
1441: p_msg_type=>'SQL ERROR',
1442: p_msg_level=>fnd_log.level_error);

Line 1442: p_msg_level=>fnd_log.level_error);

1438: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1440: p_msg_data=>x_msg_data,
1441: p_msg_type=>'SQL ERROR',
1442: p_msg_level=>fnd_log.level_error);
1443: END IF;
1444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1445: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1446: p_prefix=>l_debug_prefix,

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

1440: p_msg_data=>x_msg_data,
1441: p_msg_type=>'SQL ERROR',
1442: p_msg_level=>fnd_log.level_error);
1443: END IF;
1444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1445: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1446: p_prefix=>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_procedure);
1448: END IF;

Line 1447: p_msg_level=>fnd_log.level_procedure);

1443: END IF;
1444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1445: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1446: p_prefix=>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_procedure);
1448: END IF;
1449: END do_save_cust_acct_bo;
1450:
1451: PROCEDURE save_cust_acct_bo(

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

1618: END IF;
1619:
1620:
1621: -- Debug info.
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1624: p_prefix=>l_debug_prefix,
1625: p_msg_level=>fnd_log.level_procedure);
1626: END IF;

Line 1625: p_msg_level=>fnd_log.level_procedure);

1621: -- Debug info.
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1624: p_prefix=>l_debug_prefix,
1625: p_msg_level=>fnd_log.level_procedure);
1626: END IF;
1627:
1628: -- check if pass in contact_point_id and/or os+osr
1629: -- extraction validation logic is same as update

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

1662: END IF;
1663:
1664:
1665: -- Debug info.
1666: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1668: p_msg_data=>x_msg_data,
1669: p_msg_type=>'WARNING',
1670: p_msg_level=>fnd_log.level_exception);

Line 1670: p_msg_level=>fnd_log.level_exception);

1666: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1668: p_msg_data=>x_msg_data,
1669: p_msg_type=>'WARNING',
1670: p_msg_level=>fnd_log.level_exception);
1671: END IF;
1672:
1673: -- Debug info.
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1670: p_msg_level=>fnd_log.level_exception);
1671: END IF;
1672:
1673: -- Debug info.
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1675: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1676: p_prefix=>l_debug_prefix,
1677: p_msg_level=>fnd_log.level_procedure);
1678: END IF;

Line 1677: p_msg_level=>fnd_log.level_procedure);

1673: -- Debug info.
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1675: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1676: p_prefix=>l_debug_prefix,
1677: p_msg_level=>fnd_log.level_procedure);
1678: END IF;
1679:
1680:
1681: EXCEPTION

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

1687: p_count => x_msg_count,
1688: p_data => x_msg_data);
1689:
1690: -- Debug info.
1691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);

Line 1695: p_msg_level=>fnd_log.level_error);

1691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1699: p_prefix=>l_debug_prefix,

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

1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;

Line 1700: p_msg_level=>fnd_log.level_procedure);

1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702: WHEN fnd_api.g_exc_unexpected_error THEN
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:

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

1706: p_count => x_msg_count,
1707: p_data => x_msg_data);
1708:
1709: -- Debug info.
1710: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1712: p_msg_data=>x_msg_data,
1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);

Line 1714: p_msg_level=>fnd_log.level_error);

1710: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1712: p_msg_data=>x_msg_data,
1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);
1715: END IF;
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1718: p_prefix=>l_debug_prefix,

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

1712: p_msg_data=>x_msg_data,
1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);
1715: END IF;
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1718: p_prefix=>l_debug_prefix,
1719: p_msg_level=>fnd_log.level_procedure);
1720: END IF;

Line 1719: p_msg_level=>fnd_log.level_procedure);

1715: END IF;
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1718: p_prefix=>l_debug_prefix,
1719: p_msg_level=>fnd_log.level_procedure);
1720: END IF;
1721: WHEN OTHERS THEN
1722: x_return_status := fnd_api.g_ret_sts_unexp_error;
1723:

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

1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732: -- Debug info.
1733: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1734: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1735: p_msg_data=>x_msg_data,
1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);

Line 1737: p_msg_level=>fnd_log.level_error);

1733: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1734: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1735: p_msg_data=>x_msg_data,
1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1741: p_prefix=>l_debug_prefix,

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

1735: p_msg_data=>x_msg_data,
1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;

Line 1742: p_msg_level=>fnd_log.level_procedure);

1738: END IF;
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744:
1745: end;
1746:

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

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

Line 2027: p_msg_level=>fnd_log.level_procedure);

2023: -- Debug info.
2024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2025: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',
2026: p_prefix=>l_debug_prefix,
2027: p_msg_level=>fnd_log.level_procedure);
2028: END IF;
2029:
2030: -- Base on p_validate_bo_flag, check the completeness of business objects
2031: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

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

2283: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2284: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2285:
2286: -- Debug info.
2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);

Line 2291: p_msg_level=>fnd_log.level_exception);

2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2295: p_prefix=>l_debug_prefix,

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

2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2295: p_prefix=>l_debug_prefix,
2296: p_msg_level=>fnd_log.level_procedure);
2297: END IF;

Line 2296: p_msg_level=>fnd_log.level_procedure);

2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2295: p_prefix=>l_debug_prefix,
2296: p_msg_level=>fnd_log.level_procedure);
2297: END IF;
2298:
2299: EXCEPTION
2300: WHEN fnd_api.g_exc_error THEN

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

2314: p_count => x_msg_count,
2315: p_data => x_msg_data);
2316:
2317: -- Debug info.
2318: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2320: p_msg_data=>x_msg_data,
2321: p_msg_type=>'ERROR',
2322: p_msg_level=>fnd_log.level_error);

Line 2322: p_msg_level=>fnd_log.level_error);

2318: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2320: p_msg_data=>x_msg_data,
2321: p_msg_type=>'ERROR',
2322: p_msg_level=>fnd_log.level_error);
2323: END IF;
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2326: p_prefix=>l_debug_prefix,

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

2320: p_msg_data=>x_msg_data,
2321: p_msg_type=>'ERROR',
2322: p_msg_level=>fnd_log.level_error);
2323: END IF;
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;

Line 2327: p_msg_level=>fnd_log.level_procedure);

2323: END IF;
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:
2330: WHEN fnd_api.g_exc_unexpected_error THEN
2331: ROLLBACK TO do_create_cust_acct_v2_bo_pub;

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

2344: p_count => x_msg_count,
2345: p_data => x_msg_data);
2346:
2347: -- Debug info.
2348: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2350: p_msg_data=>x_msg_data,
2351: p_msg_type=>'UNEXPECTED ERROR',
2352: p_msg_level=>fnd_log.level_error);

Line 2352: p_msg_level=>fnd_log.level_error);

2348: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2350: p_msg_data=>x_msg_data,
2351: p_msg_type=>'UNEXPECTED ERROR',
2352: p_msg_level=>fnd_log.level_error);
2353: END IF;
2354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2355: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2356: p_prefix=>l_debug_prefix,

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

2350: p_msg_data=>x_msg_data,
2351: p_msg_type=>'UNEXPECTED ERROR',
2352: p_msg_level=>fnd_log.level_error);
2353: END IF;
2354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2355: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2356: p_prefix=>l_debug_prefix,
2357: p_msg_level=>fnd_log.level_procedure);
2358: END IF;

Line 2357: p_msg_level=>fnd_log.level_procedure);

2353: END IF;
2354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2355: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2356: p_prefix=>l_debug_prefix,
2357: p_msg_level=>fnd_log.level_procedure);
2358: END IF;
2359:
2360: WHEN OTHERS THEN
2361: ROLLBACK TO do_create_cust_acct_v2_bo_pub;

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

2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: -- Debug info.
2382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2384: p_msg_data=>x_msg_data,
2385: p_msg_type=>'SQL ERROR',
2386: p_msg_level=>fnd_log.level_error);

Line 2386: p_msg_level=>fnd_log.level_error);

2382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2384: p_msg_data=>x_msg_data,
2385: p_msg_type=>'SQL ERROR',
2386: p_msg_level=>fnd_log.level_error);
2387: END IF;
2388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2389: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2390: p_prefix=>l_debug_prefix,

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

2384: p_msg_data=>x_msg_data,
2385: p_msg_type=>'SQL ERROR',
2386: p_msg_level=>fnd_log.level_error);
2387: END IF;
2388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2389: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2390: p_prefix=>l_debug_prefix,
2391: p_msg_level=>fnd_log.level_procedure);
2392: END IF;

Line 2391: p_msg_level=>fnd_log.level_procedure);

2387: END IF;
2388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2389: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2390: p_prefix=>l_debug_prefix,
2391: p_msg_level=>fnd_log.level_procedure);
2392: END IF;
2393: END do_create_cust_acct_v2_bo;
2394:
2395: PROCEDURE create_cust_acct_v2_bo(

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

2530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2531: END IF;
2532:
2533: -- Debug info.
2534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2535: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2536: p_prefix=>l_debug_prefix,
2537: p_msg_level=>fnd_log.level_procedure);
2538: END IF;

Line 2537: p_msg_level=>fnd_log.level_procedure);

2533: -- Debug info.
2534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2535: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2536: p_prefix=>l_debug_prefix,
2537: p_msg_level=>fnd_log.level_procedure);
2538: END IF;
2539:
2540: -------------------------------
2541: -- For Update cust accts

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

2742: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2743: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2744:
2745: -- Debug info.
2746: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2748: p_msg_data=>x_msg_data,
2749: p_msg_type=>'WARNING',
2750: p_msg_level=>fnd_log.level_exception);

Line 2750: p_msg_level=>fnd_log.level_exception);

2746: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2748: p_msg_data=>x_msg_data,
2749: p_msg_type=>'WARNING',
2750: p_msg_level=>fnd_log.level_exception);
2751: END IF;
2752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2754: p_prefix=>l_debug_prefix,

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

2748: p_msg_data=>x_msg_data,
2749: p_msg_type=>'WARNING',
2750: p_msg_level=>fnd_log.level_exception);
2751: END IF;
2752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2754: p_prefix=>l_debug_prefix,
2755: p_msg_level=>fnd_log.level_procedure);
2756: END IF;

Line 2755: p_msg_level=>fnd_log.level_procedure);

2751: END IF;
2752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2754: p_prefix=>l_debug_prefix,
2755: p_msg_level=>fnd_log.level_procedure);
2756: END IF;
2757: EXCEPTION
2758: WHEN fnd_api.g_exc_error THEN
2759: ROLLBACK TO do_update_cust_acct_v2_bo_pub;

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

2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774:
2775: -- Debug info.
2776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'ERROR',
2780: p_msg_level=>fnd_log.level_error);

Line 2780: p_msg_level=>fnd_log.level_error);

2776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2784: p_prefix=>l_debug_prefix,

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

2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;

Line 2785: p_msg_level=>fnd_log.level_procedure);

2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;
2787:
2788: WHEN fnd_api.g_exc_unexpected_error THEN
2789: ROLLBACK TO do_update_cust_acct_v2_bo_pub;

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

2802: p_count => x_msg_count,
2803: p_data => x_msg_data);
2804:
2805: -- Debug info.
2806: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2808: p_msg_data=>x_msg_data,
2809: p_msg_type=>'UNEXPECTED ERROR',
2810: p_msg_level=>fnd_log.level_error);

Line 2810: p_msg_level=>fnd_log.level_error);

2806: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2808: p_msg_data=>x_msg_data,
2809: p_msg_type=>'UNEXPECTED ERROR',
2810: p_msg_level=>fnd_log.level_error);
2811: END IF;
2812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2813: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2814: p_prefix=>l_debug_prefix,

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

2808: p_msg_data=>x_msg_data,
2809: p_msg_type=>'UNEXPECTED ERROR',
2810: p_msg_level=>fnd_log.level_error);
2811: END IF;
2812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2813: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2814: p_prefix=>l_debug_prefix,
2815: p_msg_level=>fnd_log.level_procedure);
2816: END IF;

Line 2815: p_msg_level=>fnd_log.level_procedure);

2811: END IF;
2812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2813: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2814: p_prefix=>l_debug_prefix,
2815: p_msg_level=>fnd_log.level_procedure);
2816: END IF;
2817:
2818: WHEN OTHERS THEN
2819: ROLLBACK TO do_update_cust_acct_v2_bo_pub;

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

2836: p_count => x_msg_count,
2837: p_data => x_msg_data);
2838:
2839: -- Debug info.
2840: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'SQL ERROR',
2844: p_msg_level=>fnd_log.level_error);

Line 2844: p_msg_level=>fnd_log.level_error);

2840: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'SQL ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2848: p_prefix=>l_debug_prefix,

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

2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'SQL ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2848: p_prefix=>l_debug_prefix,
2849: p_msg_level=>fnd_log.level_procedure);
2850: END IF;

Line 2849: p_msg_level=>fnd_log.level_procedure);

2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2848: p_prefix=>l_debug_prefix,
2849: p_msg_level=>fnd_log.level_procedure);
2850: END IF;
2851: END do_update_cust_acct_v2_bo;
2852:
2853: -- PROCEDURE do_save_cust_acct_v2_bo

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

2885: FND_MSG_PUB.initialize;
2886: END IF;
2887:
2888: -- Debug info.
2889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2890: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2891: p_prefix=>l_debug_prefix,
2892: p_msg_level=>fnd_log.level_procedure);
2893: END IF;

Line 2892: p_msg_level=>fnd_log.level_procedure);

2888: -- Debug info.
2889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2890: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2891: p_prefix=>l_debug_prefix,
2892: p_msg_level=>fnd_log.level_procedure);
2893: END IF;
2894:
2895: x_cust_acct_id := p_cust_acct_v2_obj.cust_acct_id;
2896: x_cust_acct_os := p_cust_acct_v2_obj.orig_system;

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

2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;
2950:
2951: -- Debug info.
2952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2954: p_msg_data=>x_msg_data,
2955: p_msg_type=>'WARNING',
2956: p_msg_level=>fnd_log.level_exception);

Line 2956: p_msg_level=>fnd_log.level_exception);

2952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2954: p_msg_data=>x_msg_data,
2955: p_msg_type=>'WARNING',
2956: p_msg_level=>fnd_log.level_exception);
2957: END IF;
2958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2960: p_prefix=>l_debug_prefix,

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

2954: p_msg_data=>x_msg_data,
2955: p_msg_type=>'WARNING',
2956: p_msg_level=>fnd_log.level_exception);
2957: END IF;
2958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2960: p_prefix=>l_debug_prefix,
2961: p_msg_level=>fnd_log.level_procedure);
2962: END IF;

Line 2961: p_msg_level=>fnd_log.level_procedure);

2957: END IF;
2958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2960: p_prefix=>l_debug_prefix,
2961: p_msg_level=>fnd_log.level_procedure);
2962: END IF;
2963:
2964: EXCEPTION
2965: WHEN fnd_api.g_exc_error THEN

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

2971: p_count => x_msg_count,
2972: p_data => x_msg_data);
2973:
2974: -- Debug info.
2975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2977: p_msg_data=>x_msg_data,
2978: p_msg_type=>'ERROR',
2979: p_msg_level=>fnd_log.level_error);

Line 2979: p_msg_level=>fnd_log.level_error);

2975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2977: p_msg_data=>x_msg_data,
2978: p_msg_type=>'ERROR',
2979: p_msg_level=>fnd_log.level_error);
2980: END IF;
2981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2983: p_prefix=>l_debug_prefix,

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

2977: p_msg_data=>x_msg_data,
2978: p_msg_type=>'ERROR',
2979: p_msg_level=>fnd_log.level_error);
2980: END IF;
2981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2983: p_prefix=>l_debug_prefix,
2984: p_msg_level=>fnd_log.level_procedure);
2985: END IF;

Line 2984: p_msg_level=>fnd_log.level_procedure);

2980: END IF;
2981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2983: p_prefix=>l_debug_prefix,
2984: p_msg_level=>fnd_log.level_procedure);
2985: END IF;
2986: WHEN fnd_api.g_exc_unexpected_error THEN
2987: x_return_status := fnd_api.g_ret_sts_unexp_error;
2988:

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

2990: p_count => x_msg_count,
2991: p_data => x_msg_data);
2992:
2993: -- Debug info.
2994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2996: p_msg_data=>x_msg_data,
2997: p_msg_type=>'UNEXPECTED ERROR',
2998: p_msg_level=>fnd_log.level_error);

Line 2998: p_msg_level=>fnd_log.level_error);

2994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2996: p_msg_data=>x_msg_data,
2997: p_msg_type=>'UNEXPECTED ERROR',
2998: p_msg_level=>fnd_log.level_error);
2999: END IF;
3000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3001: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3002: p_prefix=>l_debug_prefix,

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

2996: p_msg_data=>x_msg_data,
2997: p_msg_type=>'UNEXPECTED ERROR',
2998: p_msg_level=>fnd_log.level_error);
2999: END IF;
3000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3001: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3002: p_prefix=>l_debug_prefix,
3003: p_msg_level=>fnd_log.level_procedure);
3004: END IF;

Line 3003: p_msg_level=>fnd_log.level_procedure);

2999: END IF;
3000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3001: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3002: p_prefix=>l_debug_prefix,
3003: p_msg_level=>fnd_log.level_procedure);
3004: END IF;
3005: WHEN OTHERS THEN
3006: x_return_status := fnd_api.g_ret_sts_unexp_error;
3007:

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

3013: p_count => x_msg_count,
3014: p_data => x_msg_data);
3015:
3016: -- Debug info.
3017: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3019: p_msg_data=>x_msg_data,
3020: p_msg_type=>'SQL ERROR',
3021: p_msg_level=>fnd_log.level_error);

Line 3021: p_msg_level=>fnd_log.level_error);

3017: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3019: p_msg_data=>x_msg_data,
3020: p_msg_type=>'SQL ERROR',
3021: p_msg_level=>fnd_log.level_error);
3022: END IF;
3023: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3025: p_prefix=>l_debug_prefix,

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

3019: p_msg_data=>x_msg_data,
3020: p_msg_type=>'SQL ERROR',
3021: p_msg_level=>fnd_log.level_error);
3022: END IF;
3023: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3025: p_prefix=>l_debug_prefix,
3026: p_msg_level=>fnd_log.level_procedure);
3027: END IF;

Line 3026: p_msg_level=>fnd_log.level_procedure);

3022: END IF;
3023: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3025: p_prefix=>l_debug_prefix,
3026: p_msg_level=>fnd_log.level_procedure);
3027: END IF;
3028: END do_save_cust_acct_v2_bo;
3029:
3030: PROCEDURE save_cust_acct_v2_bo(

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

3160: END IF;
3161:
3162:
3163: -- Debug info.
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;

Line 3167: p_msg_level=>fnd_log.level_procedure);

3163: -- Debug info.
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
3169:
3170: -- check if pass in contact_point_id and/or os+osr
3171: -- extraction validation logic is same as update

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

3204: END IF;
3205:
3206:
3207: -- Debug info.
3208: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3209: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3210: p_msg_data=>x_msg_data,
3211: p_msg_type=>'WARNING',
3212: p_msg_level=>fnd_log.level_exception);

Line 3212: p_msg_level=>fnd_log.level_exception);

3208: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3209: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3210: p_msg_data=>x_msg_data,
3211: p_msg_type=>'WARNING',
3212: p_msg_level=>fnd_log.level_exception);
3213: END IF;
3214:
3215: -- Debug info.
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3212: p_msg_level=>fnd_log.level_exception);
3213: END IF;
3214:
3215: -- Debug info.
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;

Line 3219: p_msg_level=>fnd_log.level_procedure);

3215: -- Debug info.
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3221:
3222:
3223: EXCEPTION

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

3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:
3232: -- Debug info.
3233: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3235: p_msg_data=>x_msg_data,
3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);

Line 3237: p_msg_level=>fnd_log.level_error);

3233: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3235: p_msg_data=>x_msg_data,
3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);
3238: END IF;
3239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3241: p_prefix=>l_debug_prefix,

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

3235: p_msg_data=>x_msg_data,
3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);
3238: END IF;
3239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3241: p_prefix=>l_debug_prefix,
3242: p_msg_level=>fnd_log.level_procedure);
3243: END IF;

Line 3242: p_msg_level=>fnd_log.level_procedure);

3238: END IF;
3239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3241: p_prefix=>l_debug_prefix,
3242: p_msg_level=>fnd_log.level_procedure);
3243: END IF;
3244: WHEN fnd_api.g_exc_unexpected_error THEN
3245: x_return_status := fnd_api.g_ret_sts_unexp_error;
3246:

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

3248: p_count => x_msg_count,
3249: p_data => x_msg_data);
3250:
3251: -- Debug info.
3252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3254: p_msg_data=>x_msg_data,
3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);

Line 3256: p_msg_level=>fnd_log.level_error);

3252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3254: p_msg_data=>x_msg_data,
3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);
3257: END IF;
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3260: p_prefix=>l_debug_prefix,

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

3254: p_msg_data=>x_msg_data,
3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);
3257: END IF;
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;

Line 3261: p_msg_level=>fnd_log.level_procedure);

3257: END IF;
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;
3263: WHEN OTHERS THEN
3264: x_return_status := fnd_api.g_ret_sts_unexp_error;
3265:

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

3271: p_count => x_msg_count,
3272: p_data => x_msg_data);
3273:
3274: -- Debug info.
3275: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3276: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3277: p_msg_data=>x_msg_data,
3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);

Line 3279: p_msg_level=>fnd_log.level_error);

3275: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3276: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3277: p_msg_data=>x_msg_data,
3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);
3280: END IF;
3281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3283: p_prefix=>l_debug_prefix,

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

3277: p_msg_data=>x_msg_data,
3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);
3280: END IF;
3281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3283: p_prefix=>l_debug_prefix,
3284: p_msg_level=>fnd_log.level_procedure);
3285: END IF;

Line 3284: p_msg_level=>fnd_log.level_procedure);

3280: END IF;
3281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3283: p_prefix=>l_debug_prefix,
3284: p_msg_level=>fnd_log.level_procedure);
3285: END IF;
3286:
3287: end;
3288: