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_ACCOUNT_V2PUB dependencies on FND_LOG

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

237: BEGIN
238:
239: -- Debug info.
240:
241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
242: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (+)',
243: p_prefix=>l_debug_prefix,
244: p_msg_level=>fnd_log.level_procedure);
245: END IF;

Line 244: p_msg_level=>fnd_log.level_procedure);

240:
241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
242: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (+)',
243: p_prefix=>l_debug_prefix,
244: p_msg_level=>fnd_log.level_procedure);
245: END IF;
246:
247: if (p_cust_account_rec.orig_system is null OR p_cust_account_rec.orig_system = fnd_api.g_miss_char)
248: and (p_cust_account_rec.orig_system_reference is not null and

Line 392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

388:
389: END IF;
390:
391: -- Debug info.
392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
393: IF l_create_party THEN
394: hz_utility_v2pub.debug(p_message=>'We need to create party. ',
395: p_prefix =>l_debug_prefix,
396: p_msg_level=>fnd_log.level_statement);

Line 396: p_msg_level=>fnd_log.level_statement);

392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
393: IF l_create_party THEN
394: hz_utility_v2pub.debug(p_message=>'We need to create party. ',
395: p_prefix =>l_debug_prefix,
396: p_msg_level=>fnd_log.level_statement);
397: ELSE
398: hz_utility_v2pub.debug(p_message=>'We donot need to create party. ',
399: p_prefix =>l_debug_prefix,
400: p_msg_level=>fnd_log.level_statement);

Line 400: p_msg_level=>fnd_log.level_statement);

396: p_msg_level=>fnd_log.level_statement);
397: ELSE
398: hz_utility_v2pub.debug(p_message=>'We donot need to create party. ',
399: p_prefix =>l_debug_prefix,
400: p_msg_level=>fnd_log.level_statement);
401:
402: END IF;
403: END IF;
404:

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

449:
450:
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;

Line 456: p_msg_level=>fnd_log.level_procedure);

452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Call table-handler.
460: HZ_CUST_ACCOUNTS_PKG.Insert_Row (

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

562: X_APPLICATION_ID => p_cust_account_rec.application_id
563: );
564:
565: -- Debug info.
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
568: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
569: 'x_account_number = ' || p_cust_account_rec.account_number,
570: p_prefix=>l_debug_prefix,

Line 571: p_msg_level=>fnd_log.level_procedure);

567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
568: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
569: 'x_account_number = ' || p_cust_account_rec.account_number,
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);
572: END IF;
573:
574: if (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
575: then

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

678: x_party_number := l_party_number;
679: x_profile_id := l_profile_id;
680:
681: -- Debug info.
682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
683: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
684: p_prefix=>l_debug_prefix,
685: p_msg_level=>fnd_log.level_procedure);
686: END IF;

Line 685: p_msg_level=>fnd_log.level_procedure);

681: -- Debug info.
682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
683: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
684: p_prefix=>l_debug_prefix,
685: p_msg_level=>fnd_log.level_procedure);
686: END IF;
687:
688: END do_create_cust_account;
689:

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

754:
755: BEGIN
756:
757: -- Debug info.
758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
759: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
760: p_prefix=>l_debug_prefix,
761: p_msg_level=>fnd_log.level_procedure);
762: END IF;

Line 761: p_msg_level=>fnd_log.level_procedure);

757: -- Debug info.
758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
759: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
760: p_prefix=>l_debug_prefix,
761: p_msg_level=>fnd_log.level_procedure);
762: END IF;
763:
764:
765: -- Lock record.

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

816: -- but we should not update existing osr, set it to null
817: end if;
818:
819: -- Debug info.
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;

Line 823: p_msg_level=>fnd_log.level_procedure);

819: -- Debug info.
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825:
826: -- Call table-handler.
827: HZ_CUST_ACCOUNTS_PKG.Update_Row (

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

930: X_APPLICATION_ID => p_cust_account_rec.application_id
931: );
932:
933: -- Debug info.
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;

Line 937: p_msg_level=>fnd_log.level_procedure);

933: -- Debug info.
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;
939:
940: --
941: -- R12 party usage project

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

986: END IF;
987: END IF;
988:
989: -- Debug info.
990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
991: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
992: p_prefix=>l_debug_prefix,
993: p_msg_level=>fnd_log.level_procedure);
994: END IF;

Line 993: p_msg_level=>fnd_log.level_procedure);

989: -- Debug info.
990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
991: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
992: p_prefix=>l_debug_prefix,
993: p_msg_level=>fnd_log.level_procedure);
994: END IF;
995:
996: END do_update_cust_account;
997:

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

1045: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
1046: BEGIN
1047:
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;

Line 1052: p_msg_level=>fnd_log.level_procedure);

1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1054:
1055: -- No sequence number is used for cust_acct_relate
1056:

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

1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: -- Debug info.
1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1081: p_prefix=>l_debug_prefix,
1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;

Line 1082: p_msg_level=>fnd_log.level_procedure);

1078: -- Debug info.
1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1081: p_prefix=>l_debug_prefix,
1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;
1084:
1085: -- Call table-handler.
1086: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (

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

1115: X_CUST_ACCT_RELATE_ID => p_cust_acct_relate_rec.cust_acct_relate_id -- Bug 4529413
1116: );
1117:
1118: -- Debug info.
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;

Line 1122: p_msg_level=>fnd_log.level_procedure);

1118: -- Debug info.
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:
1125: -- check customer_reciprocal_flag, if 'Y', need to create
1126: -- a relationship record for related customer account or update

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

1134: THEN
1135: BEGIN
1136:
1137: -- Debug info.
1138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1140: p_prefix =>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_statement);
1142: END IF;

Line 1141: p_msg_level=>fnd_log.level_statement);

1137: -- Debug info.
1138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1140: p_prefix =>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_statement);
1142: END IF;
1143:
1144: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1145: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag

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

1184: END;
1185: END IF;
1186:
1187: -- Debug info.
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1190: p_prefix=>l_debug_prefix,
1191: p_msg_level=>fnd_log.level_procedure);
1192: END IF;

Line 1191: p_msg_level=>fnd_log.level_procedure);

1187: -- Debug info.
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1190: p_prefix=>l_debug_prefix,
1191: p_msg_level=>fnd_log.level_procedure);
1192: END IF;
1193:
1194: END do_create_cust_acct_relate;
1195:

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

1250:
1251: BEGIN
1252:
1253: -- Debug info.
1254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1255: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1256: p_prefix=>l_debug_prefix,
1257: p_msg_level=>fnd_log.level_procedure);
1258: END IF;

Line 1257: p_msg_level=>fnd_log.level_procedure);

1253: -- Debug info.
1254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1255: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1256: p_prefix=>l_debug_prefix,
1257: p_msg_level=>fnd_log.level_procedure);
1258: END IF;
1259:
1260: -- Lock record.
1261:

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

1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409:
1410: -- Debug info.
1411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1413: p_prefix=>l_debug_prefix,
1414: p_msg_level=>fnd_log.level_procedure);
1415: END IF;

Line 1414: p_msg_level=>fnd_log.level_procedure);

1410: -- Debug info.
1411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1413: p_prefix=>l_debug_prefix,
1414: p_msg_level=>fnd_log.level_procedure);
1415: END IF;
1416:
1417: -- Call table-handler.
1418: HZ_CUST_ACCT_RELATE_PKG.Update_Row (

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

1446: X_APPLICATION_ID => p_cust_acct_relate_rec.application_id
1447: );
1448:
1449: -- Debug info.
1450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1451: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1452: p_prefix=>l_debug_prefix,
1453: p_msg_level=>fnd_log.level_procedure);
1454: END IF;

Line 1453: p_msg_level=>fnd_log.level_procedure);

1449: -- Debug info.
1450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1451: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1452: p_prefix=>l_debug_prefix,
1453: p_msg_level=>fnd_log.level_procedure);
1454: END IF;
1455:
1456: -- customer_reciprocal_flag is non-updateable. We do not need to implement the
1457: -- same logic in insert mode during update.

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

1456: -- customer_reciprocal_flag is non-updateable. We do not need to implement the
1457: -- same logic in insert mode during update.
1458:
1459: -- Debug info.
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;

Line 1463: p_msg_level=>fnd_log.level_procedure);

1459: -- Debug info.
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;
1465:
1466: END do_update_cust_acct_relate;
1467:

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

1546: -- Check if API is called in debug mode. If yes, enable debug.
1547: --enable_debug;
1548:
1549: -- Debug info.
1550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1551: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1552: p_prefix=>l_debug_prefix,
1553: p_msg_level=>fnd_log.level_procedure);
1554: END IF;

Line 1553: p_msg_level=>fnd_log.level_procedure);

1549: -- Debug info.
1550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1551: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1552: p_prefix=>l_debug_prefix,
1553: p_msg_level=>fnd_log.level_procedure);
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1617: p_count => x_msg_count,
1618: p_data => x_msg_data );
1619:
1620: -- Debug info.
1621: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1622: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1623: p_msg_data=>x_msg_data,
1624: p_msg_type=>'WARNING',
1625: p_msg_level=>fnd_log.level_exception);

Line 1625: p_msg_level=>fnd_log.level_exception);

1621: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1622: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1623: p_msg_data=>x_msg_data,
1624: p_msg_type=>'WARNING',
1625: p_msg_level=>fnd_log.level_exception);
1626: END IF;
1627: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1628: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1629: p_prefix=>l_debug_prefix,

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

1623: p_msg_data=>x_msg_data,
1624: p_msg_type=>'WARNING',
1625: p_msg_level=>fnd_log.level_exception);
1626: END IF;
1627: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1628: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1629: p_prefix=>l_debug_prefix,
1630: p_msg_level=>fnd_log.level_procedure);
1631: END IF;

Line 1630: p_msg_level=>fnd_log.level_procedure);

1626: END IF;
1627: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1628: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1629: p_prefix=>l_debug_prefix,
1630: p_msg_level=>fnd_log.level_procedure);
1631: END IF;
1632:
1633: -- Check if API is called in debug mode. If yes, disable debug.
1634: --disable_debug;

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

1643: p_count => x_msg_count,
1644: p_data => x_msg_data );
1645:
1646: -- Debug info.
1647: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'ERROR',
1651: p_msg_level=>fnd_log.level_error);

Line 1651: p_msg_level=>fnd_log.level_error);

1647: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'ERROR',
1651: p_msg_level=>fnd_log.level_error);
1652:
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1650: p_msg_type=>'ERROR',
1651: p_msg_level=>fnd_log.level_error);
1652:
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;

Line 1657: p_msg_level=>fnd_log.level_procedure);

1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1659:
1660: -- Check if API is called in debug mode. If yes, disable debug.
1661: --disable_debug;

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

1669: p_count => x_msg_count,
1670: p_data => x_msg_data );
1671:
1672: -- Debug info.
1673: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1675: p_msg_data=>x_msg_data,
1676: p_msg_type=>'UNEXPECTED ERROR',
1677: p_msg_level=>fnd_log.level_error);

Line 1677: p_msg_level=>fnd_log.level_error);

1673: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1675: p_msg_data=>x_msg_data,
1676: p_msg_type=>'UNEXPECTED ERROR',
1677: p_msg_level=>fnd_log.level_error);
1678:
1679: END IF;
1680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1681: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1676: p_msg_type=>'UNEXPECTED ERROR',
1677: p_msg_level=>fnd_log.level_error);
1678:
1679: END IF;
1680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1681: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1682: p_prefix=>l_debug_prefix,
1683: p_msg_level=>fnd_log.level_procedure);
1684: END IF;

Line 1683: p_msg_level=>fnd_log.level_procedure);

1679: END IF;
1680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1681: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1682: p_prefix=>l_debug_prefix,
1683: p_msg_level=>fnd_log.level_procedure);
1684: END IF;
1685:
1686: -- Check if API is called in debug mode. If yes, disable debug.
1687: --disable_debug;

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

1699: p_count => x_msg_count,
1700: p_data => x_msg_data );
1701:
1702: -- Debug info.
1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'SQL ERROR',
1707: p_msg_level=>fnd_log.level_error);

Line 1707: p_msg_level=>fnd_log.level_error);

1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'SQL ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708:
1709: END IF;
1710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1706: p_msg_type=>'SQL ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708:
1709: END IF;
1710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1712: p_prefix=>l_debug_prefix,
1713: p_msg_level=>fnd_log.level_procedure);
1714: END IF;

Line 1713: p_msg_level=>fnd_log.level_procedure);

1709: END IF;
1710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1712: p_prefix=>l_debug_prefix,
1713: p_msg_level=>fnd_log.level_procedure);
1714: END IF;
1715:
1716: -- Check if API is called in debug mode. If yes, disable debug.
1717: --disable_debug;

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

1795: -- Check if API is called in debug mode. If yes, enable debug.
1796: --enable_debug;
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;

Line 1802: p_msg_level=>fnd_log.level_procedure);

1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804:
1805: -- Initialize message list if p_init_msg_list is set to TRUE.
1806: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1865: p_count => x_msg_count,
1866: p_data => x_msg_data );
1867:
1868: -- Debug info.
1869: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1871: p_msg_data=>x_msg_data,
1872: p_msg_type=>'WARNING',
1873: p_msg_level=>fnd_log.level_exception);

Line 1873: p_msg_level=>fnd_log.level_exception);

1869: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1871: p_msg_data=>x_msg_data,
1872: p_msg_type=>'WARNING',
1873: p_msg_level=>fnd_log.level_exception);
1874: END IF;
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1877: p_prefix=>l_debug_prefix,

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

1871: p_msg_data=>x_msg_data,
1872: p_msg_type=>'WARNING',
1873: p_msg_level=>fnd_log.level_exception);
1874: END IF;
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1877: p_prefix=>l_debug_prefix,
1878: p_msg_level=>fnd_log.level_procedure);
1879: END IF;

Line 1878: p_msg_level=>fnd_log.level_procedure);

1874: END IF;
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1877: p_prefix=>l_debug_prefix,
1878: p_msg_level=>fnd_log.level_procedure);
1879: END IF;
1880:
1881:
1882: -- Check if API is called in debug mode. If yes, disable debug.

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

1892: p_count => x_msg_count,
1893: p_data => x_msg_data );
1894:
1895: -- Debug info.
1896: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1898: p_msg_data=>x_msg_data,
1899: p_msg_type=>'ERROR',
1900: p_msg_level=>fnd_log.level_error);

Line 1900: p_msg_level=>fnd_log.level_error);

1896: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1898: p_msg_data=>x_msg_data,
1899: p_msg_type=>'ERROR',
1900: p_msg_level=>fnd_log.level_error);
1901:
1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1899: p_msg_type=>'ERROR',
1900: p_msg_level=>fnd_log.level_error);
1901:
1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1905: p_prefix=>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_procedure);
1907: END IF;

Line 1906: p_msg_level=>fnd_log.level_procedure);

1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1905: p_prefix=>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_procedure);
1907: END IF;
1908:
1909: -- Check if API is called in debug mode. If yes, disable debug.
1910: --disable_debug;

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

1918: p_count => x_msg_count,
1919: p_data => x_msg_data );
1920:
1921: -- Debug info.
1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);

Line 1926: p_msg_level=>fnd_log.level_error);

1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);
1927:
1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);
1927:
1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1931: p_prefix=>l_debug_prefix,
1932: p_msg_level=>fnd_log.level_procedure);
1933: END IF;

Line 1932: p_msg_level=>fnd_log.level_procedure);

1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1931: p_prefix=>l_debug_prefix,
1932: p_msg_level=>fnd_log.level_procedure);
1933: END IF;
1934:
1935: -- Check if API is called in debug mode. If yes, disable debug.
1936: --disable_debug;

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

1949: p_data => x_msg_data );
1950:
1951: -- Debug info.
1952:
1953: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1955: p_msg_data=>x_msg_data,
1956: p_msg_type=>'SQL ERROR',
1957: p_msg_level=>fnd_log.level_error);

Line 1957: p_msg_level=>fnd_log.level_error);

1953: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1955: p_msg_data=>x_msg_data,
1956: p_msg_type=>'SQL ERROR',
1957: p_msg_level=>fnd_log.level_error);
1958:
1959: END IF;
1960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1956: p_msg_type=>'SQL ERROR',
1957: p_msg_level=>fnd_log.level_error);
1958:
1959: END IF;
1960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1962: p_prefix=>l_debug_prefix,
1963: p_msg_level=>fnd_log.level_procedure);
1964: END IF;

Line 1963: p_msg_level=>fnd_log.level_procedure);

1959: END IF;
1960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1962: p_prefix=>l_debug_prefix,
1963: p_msg_level=>fnd_log.level_procedure);
1964: END IF;
1965:
1966:
1967: -- Check if API is called in debug mode. If yes, disable debug.

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

2022: -- Check if API is called in debug mode. If yes, enable debug.
2023: --enable_debug;
2024:
2025: -- Debug info.
2026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2027: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2028: p_prefix=>l_debug_prefix,
2029: p_msg_level=>fnd_log.level_procedure);
2030: END IF;

Line 2029: p_msg_level=>fnd_log.level_procedure);

2025: -- Debug info.
2026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2027: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2028: p_prefix=>l_debug_prefix,
2029: p_msg_level=>fnd_log.level_procedure);
2030: END IF;
2031:
2032: -- Initialize message list if p_init_msg_list is set to TRUE.
2033: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2111: p_count => x_msg_count,
2112: p_data => x_msg_data );
2113:
2114: -- Debug info.
2115: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2117: p_msg_data=>x_msg_data,
2118: p_msg_type=>'WARNING',
2119: p_msg_level=>fnd_log.level_exception);

Line 2119: p_msg_level=>fnd_log.level_exception);

2115: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2117: p_msg_data=>x_msg_data,
2118: p_msg_type=>'WARNING',
2119: p_msg_level=>fnd_log.level_exception);
2120: END IF;
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2123: p_prefix=>l_debug_prefix,

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

2117: p_msg_data=>x_msg_data,
2118: p_msg_type=>'WARNING',
2119: p_msg_level=>fnd_log.level_exception);
2120: END IF;
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2123: p_prefix=>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_procedure);
2125: END IF;

Line 2124: p_msg_level=>fnd_log.level_procedure);

2120: END IF;
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2123: p_prefix=>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_procedure);
2125: END IF;
2126:
2127: -- Check if API is called in debug mode. If yes, disable debug.
2128: --disable_debug;

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

2137: p_count => x_msg_count,
2138: p_data => x_msg_data );
2139:
2140: -- Debug info.
2141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'ERROR',
2145: p_msg_level=>fnd_log.level_error);

Line 2145: p_msg_level=>fnd_log.level_error);

2141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'ERROR',
2145: p_msg_level=>fnd_log.level_error);
2146:
2147: END IF;
2148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2149: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

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

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

Line 2151: p_msg_level=>fnd_log.level_procedure);

2147: END IF;
2148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2149: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2150: p_prefix=>l_debug_prefix,
2151: p_msg_level=>fnd_log.level_procedure);
2152: END IF;
2153:
2154: -- Check if API is called in debug mode. If yes, disable debug.
2155: --disable_debug;

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

2163: p_count => x_msg_count,
2164: p_data => x_msg_data );
2165:
2166: -- Debug info.
2167: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2169: p_msg_data=>x_msg_data,
2170: p_msg_type=>'UNEXPECTED ERROR',
2171: p_msg_level=>fnd_log.level_error);

Line 2171: p_msg_level=>fnd_log.level_error);

2167: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2169: p_msg_data=>x_msg_data,
2170: p_msg_type=>'UNEXPECTED ERROR',
2171: p_msg_level=>fnd_log.level_error);
2172:
2173: END IF;
2174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2175: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

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

2170: p_msg_type=>'UNEXPECTED ERROR',
2171: p_msg_level=>fnd_log.level_error);
2172:
2173: END IF;
2174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2175: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2176: p_prefix=>l_debug_prefix,
2177: p_msg_level=>fnd_log.level_procedure);
2178: END IF;

Line 2177: p_msg_level=>fnd_log.level_procedure);

2173: END IF;
2174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2175: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2176: p_prefix=>l_debug_prefix,
2177: p_msg_level=>fnd_log.level_procedure);
2178: END IF;
2179:
2180: -- Check if API is called in debug mode. If yes, disable debug.
2181: --disable_debug;

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

2193: p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: -- Debug info.
2197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2199: p_msg_data=>x_msg_data,
2200: p_msg_type=>'SQL ERROR',
2201: p_msg_level=>fnd_log.level_error);

Line 2201: p_msg_level=>fnd_log.level_error);

2197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2199: p_msg_data=>x_msg_data,
2200: p_msg_type=>'SQL ERROR',
2201: p_msg_level=>fnd_log.level_error);
2202:
2203: END IF;
2204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

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

2200: p_msg_type=>'SQL ERROR',
2201: p_msg_level=>fnd_log.level_error);
2202:
2203: END IF;
2204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2206: p_prefix=>l_debug_prefix,
2207: p_msg_level=>fnd_log.level_procedure);
2208: END IF;

Line 2207: p_msg_level=>fnd_log.level_procedure);

2203: END IF;
2204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2206: p_prefix=>l_debug_prefix,
2207: p_msg_level=>fnd_log.level_procedure);
2208: END IF;
2209:
2210: -- Check if API is called in debug mode. If yes, disable debug.
2211: --disable_debug;

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

2263: -- Check if API is called in debug mode. If yes, enable debug.
2264: --enable_debug;
2265:
2266: -- Debug info.
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;

Line 2270: p_msg_level=>fnd_log.level_procedure);

2266: -- Debug info.
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;
2272:
2273: -- Initialize message list if p_init_msg_list is set to TRUE.
2274: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2293: END IF;
2294:
2295: x_cust_account_rec.cust_account_id := p_cust_account_id;
2296:
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;

Line 2300: p_msg_level=>fnd_log.level_procedure);

2296:
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302:
2303: -- Call table-handler.
2304: HZ_CUST_ACCOUNTS_PKG.Select_Row (

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

2403: X_CREATED_BY_MODULE => x_cust_account_rec.created_by_module,
2404: X_APPLICATION_ID => x_cust_account_rec.application_id
2405: );
2406:
2407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2409: p_prefix=>l_debug_prefix,
2410: p_msg_level=>fnd_log.level_procedure);
2411: END IF;

Line 2410: p_msg_level=>fnd_log.level_procedure);

2406:
2407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2409: p_prefix=>l_debug_prefix,
2410: p_msg_level=>fnd_log.level_procedure);
2411: END IF;
2412:
2413: -- Fetch customer profile id.
2414: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id

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

2437: p_count => x_msg_count,
2438: p_data => x_msg_data );
2439:
2440: -- Debug info.
2441: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2443: p_msg_data=>x_msg_data,
2444: p_msg_type=>'WARNING',
2445: p_msg_level=>fnd_log.level_exception);

Line 2445: p_msg_level=>fnd_log.level_exception);

2441: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2443: p_msg_data=>x_msg_data,
2444: p_msg_type=>'WARNING',
2445: p_msg_level=>fnd_log.level_exception);
2446: END IF;
2447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2449: p_prefix=>l_debug_prefix,

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

2443: p_msg_data=>x_msg_data,
2444: p_msg_type=>'WARNING',
2445: p_msg_level=>fnd_log.level_exception);
2446: END IF;
2447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2449: p_prefix=>l_debug_prefix,
2450: p_msg_level=>fnd_log.level_procedure);
2451: END IF;

Line 2450: p_msg_level=>fnd_log.level_procedure);

2446: END IF;
2447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2449: p_prefix=>l_debug_prefix,
2450: p_msg_level=>fnd_log.level_procedure);
2451: END IF;
2452:
2453: -- Check if API is called in debug mode. If yes, disable debug.
2454: --disable_debug;

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

2462: p_count => x_msg_count,
2463: p_data => x_msg_data );
2464:
2465: -- Debug info.
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'ERROR',
2470: p_msg_level=>fnd_log.level_error);

Line 2470: p_msg_level=>fnd_log.level_error);

2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471:
2472: END IF;
2473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

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

2469: p_msg_type=>'ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471:
2472: END IF;
2473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2475: p_prefix=>l_debug_prefix,
2476: p_msg_level=>fnd_log.level_procedure);
2477: END IF;

Line 2476: p_msg_level=>fnd_log.level_procedure);

2472: END IF;
2473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2475: p_prefix=>l_debug_prefix,
2476: p_msg_level=>fnd_log.level_procedure);
2477: END IF;
2478:
2479: -- Check if API is called in debug mode. If yes, disable debug.
2480: --disable_debug;

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

2487: p_count => x_msg_count,
2488: p_data => x_msg_data );
2489:
2490: -- Debug info.
2491: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2493: p_msg_data=>x_msg_data,
2494: p_msg_type=>'UNEXPECTED ERROR',
2495: p_msg_level=>fnd_log.level_error);

Line 2495: p_msg_level=>fnd_log.level_error);

2491: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2493: p_msg_data=>x_msg_data,
2494: p_msg_type=>'UNEXPECTED ERROR',
2495: p_msg_level=>fnd_log.level_error);
2496:
2497: END IF;
2498: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2499: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

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

2494: p_msg_type=>'UNEXPECTED ERROR',
2495: p_msg_level=>fnd_log.level_error);
2496:
2497: END IF;
2498: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2499: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2500: p_prefix=>l_debug_prefix,
2501: p_msg_level=>fnd_log.level_procedure);
2502: END IF;

Line 2501: p_msg_level=>fnd_log.level_procedure);

2497: END IF;
2498: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2499: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2500: p_prefix=>l_debug_prefix,
2501: p_msg_level=>fnd_log.level_procedure);
2502: END IF;
2503:
2504:
2505: -- Check if API is called in debug mode. If yes, disable debug.

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

2517: p_count => x_msg_count,
2518: p_data => x_msg_data );
2519:
2520: -- Debug info.
2521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2523: p_msg_data=>x_msg_data,
2524: p_msg_type=>'SQL ERROR',
2525: p_msg_level=>fnd_log.level_error);

Line 2525: p_msg_level=>fnd_log.level_error);

2521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2523: p_msg_data=>x_msg_data,
2524: p_msg_type=>'SQL ERROR',
2525: p_msg_level=>fnd_log.level_error);
2526:
2527: END IF;
2528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2529: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

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

2524: p_msg_type=>'SQL ERROR',
2525: p_msg_level=>fnd_log.level_error);
2526:
2527: END IF;
2528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2529: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2530: p_prefix=>l_debug_prefix,
2531: p_msg_level=>fnd_log.level_procedure);
2532: END IF;

Line 2531: p_msg_level=>fnd_log.level_procedure);

2527: END IF;
2528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2529: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2530: p_prefix=>l_debug_prefix,
2531: p_msg_level=>fnd_log.level_procedure);
2532: END IF;
2533:
2534: -- Check if API is called in debug mode. If yes, disable debug.
2535: --disable_debug;

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

2635: -- Check if API is called in debug mode. If yes, enable debug.
2636: --enable_debug;
2637:
2638: -- Debug info.
2639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2640: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2641: p_prefix=>l_debug_prefix,
2642: p_msg_level=>fnd_log.level_procedure);
2643: END IF;

Line 2642: p_msg_level=>fnd_log.level_procedure);

2638: -- Debug info.
2639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2640: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2641: p_prefix=>l_debug_prefix,
2642: p_msg_level=>fnd_log.level_procedure);
2643: END IF;
2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.
2646: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2678: p_count => x_msg_count,
2679: p_data => x_msg_data );
2680:
2681: -- Debug info.
2682: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2684: p_msg_data=>x_msg_data,
2685: p_msg_type=>'WARNING',
2686: p_msg_level=>fnd_log.level_exception);

Line 2686: p_msg_level=>fnd_log.level_exception);

2682: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2684: p_msg_data=>x_msg_data,
2685: p_msg_type=>'WARNING',
2686: p_msg_level=>fnd_log.level_exception);
2687: END IF;
2688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2689: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2690: p_prefix=>l_debug_prefix,

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

2684: p_msg_data=>x_msg_data,
2685: p_msg_type=>'WARNING',
2686: p_msg_level=>fnd_log.level_exception);
2687: END IF;
2688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2689: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2690: p_prefix=>l_debug_prefix,
2691: p_msg_level=>fnd_log.level_procedure);
2692: END IF;

Line 2691: p_msg_level=>fnd_log.level_procedure);

2687: END IF;
2688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2689: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2690: p_prefix=>l_debug_prefix,
2691: p_msg_level=>fnd_log.level_procedure);
2692: END IF;
2693:
2694: -- Check if API is called in debug mode. If yes, disable debug.
2695: --disable_debug;

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

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

Line 2712: p_msg_level=>fnd_log.level_error);

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

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

2711: p_msg_type=>'ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713:
2714: END IF;
2715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
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=>'create_cust_acct_relate (-)',
2717: p_prefix=>l_debug_prefix,
2718: p_msg_level=>fnd_log.level_procedure);
2719: END IF;
2720:
2721: -- Check if API is called in debug mode. If yes, disable debug.
2722: --disable_debug;

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

2730: p_count => x_msg_count,
2731: p_data => x_msg_data );
2732:
2733: -- Debug info.
2734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2736: p_msg_data=>x_msg_data,
2737: p_msg_type=>'UNEXPECTED ERROR',
2738: p_msg_level=>fnd_log.level_error);

Line 2738: p_msg_level=>fnd_log.level_error);

2734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2736: p_msg_data=>x_msg_data,
2737: p_msg_type=>'UNEXPECTED ERROR',
2738: p_msg_level=>fnd_log.level_error);
2739:
2740: END IF;
2741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',

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

2737: p_msg_type=>'UNEXPECTED ERROR',
2738: p_msg_level=>fnd_log.level_error);
2739:
2740: END IF;
2741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2743: p_prefix=>l_debug_prefix,
2744: p_msg_level=>fnd_log.level_procedure);
2745: END IF;

Line 2744: p_msg_level=>fnd_log.level_procedure);

2740: END IF;
2741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2743: p_prefix=>l_debug_prefix,
2744: p_msg_level=>fnd_log.level_procedure);
2745: END IF;
2746:
2747: -- Check if API is called in debug mode. If yes, disable debug.
2748: --disable_debug;

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

2760: p_count => x_msg_count,
2761: p_data => x_msg_data );
2762:
2763: -- Debug info.
2764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2766: p_msg_data=>x_msg_data,
2767: p_msg_type=>'SQL ERROR',
2768: p_msg_level=>fnd_log.level_error);

Line 2768: p_msg_level=>fnd_log.level_error);

2764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2766: p_msg_data=>x_msg_data,
2767: p_msg_type=>'SQL ERROR',
2768: p_msg_level=>fnd_log.level_error);
2769:
2770: END IF;
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',

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

2767: p_msg_type=>'SQL ERROR',
2768: p_msg_level=>fnd_log.level_error);
2769:
2770: END IF;
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2773: p_prefix=>l_debug_prefix,
2774: p_msg_level=>fnd_log.level_procedure);
2775: END IF;

Line 2774: p_msg_level=>fnd_log.level_procedure);

2770: END IF;
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2773: p_prefix=>l_debug_prefix,
2774: p_msg_level=>fnd_log.level_procedure);
2775: END IF;
2776:
2777: -- Check if API is called in debug mode. If yes, disable debug.
2778: --disable_debug;

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

2835: -- Check if API is called in debug mode. If yes, enable debug.
2836: --enable_debug;
2837:
2838: -- Debug info.
2839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2840: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2841: p_prefix=>l_debug_prefix,
2842: p_msg_level=>fnd_log.level_procedure);
2843: END IF;

Line 2842: p_msg_level=>fnd_log.level_procedure);

2838: -- Debug info.
2839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2840: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2841: p_prefix=>l_debug_prefix,
2842: p_msg_level=>fnd_log.level_procedure);
2843: END IF;
2844:
2845: -- Initialize message list if p_init_msg_list is set to TRUE.
2846: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2899: p_count => x_msg_count,
2900: p_data => x_msg_data );
2901:
2902: -- Debug info.
2903: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2904: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2905: p_msg_data=>x_msg_data,
2906: p_msg_type=>'WARNING',
2907: p_msg_level=>fnd_log.level_exception);

Line 2907: p_msg_level=>fnd_log.level_exception);

2903: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2904: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2905: p_msg_data=>x_msg_data,
2906: p_msg_type=>'WARNING',
2907: p_msg_level=>fnd_log.level_exception);
2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2911: p_prefix=>l_debug_prefix,

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

2905: p_msg_data=>x_msg_data,
2906: p_msg_type=>'WARNING',
2907: p_msg_level=>fnd_log.level_exception);
2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2911: p_prefix=>l_debug_prefix,
2912: p_msg_level=>fnd_log.level_procedure);
2913: END IF;

Line 2912: p_msg_level=>fnd_log.level_procedure);

2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2911: p_prefix=>l_debug_prefix,
2912: p_msg_level=>fnd_log.level_procedure);
2913: END IF;
2914:
2915: -- Check if API is called in debug mode. If yes, disable debug.
2916: --disable_debug;

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

2925: p_count => x_msg_count,
2926: p_data => x_msg_data );
2927:
2928: -- Debug info.
2929: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2930: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2931: p_msg_data=>x_msg_data,
2932: p_msg_type=>'ERROR',
2933: p_msg_level=>fnd_log.level_error);

Line 2933: p_msg_level=>fnd_log.level_error);

2929: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2930: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2931: p_msg_data=>x_msg_data,
2932: p_msg_type=>'ERROR',
2933: p_msg_level=>fnd_log.level_error);
2934:
2935: END IF;
2936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2937: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

2932: p_msg_type=>'ERROR',
2933: p_msg_level=>fnd_log.level_error);
2934:
2935: END IF;
2936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2937: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2938: p_prefix=>l_debug_prefix,
2939: p_msg_level=>fnd_log.level_procedure);
2940: END IF;

Line 2939: p_msg_level=>fnd_log.level_procedure);

2935: END IF;
2936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2937: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2938: p_prefix=>l_debug_prefix,
2939: p_msg_level=>fnd_log.level_procedure);
2940: END IF;
2941:
2942: -- Check if API is called in debug mode. If yes, disable debug.
2943: --disable_debug;

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

2951: p_count => x_msg_count,
2952: p_data => x_msg_data );
2953:
2954: -- Debug info.
2955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2957: p_msg_data=>x_msg_data,
2958: p_msg_type=>'UNEXPECTED ERROR',
2959: p_msg_level=>fnd_log.level_error);

Line 2959: p_msg_level=>fnd_log.level_error);

2955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2957: p_msg_data=>x_msg_data,
2958: p_msg_type=>'UNEXPECTED ERROR',
2959: p_msg_level=>fnd_log.level_error);
2960:
2961: END IF;
2962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2963: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

2958: p_msg_type=>'UNEXPECTED ERROR',
2959: p_msg_level=>fnd_log.level_error);
2960:
2961: END IF;
2962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2963: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2964: p_prefix=>l_debug_prefix,
2965: p_msg_level=>fnd_log.level_procedure);
2966: END IF;

Line 2965: p_msg_level=>fnd_log.level_procedure);

2961: END IF;
2962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2963: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2964: p_prefix=>l_debug_prefix,
2965: p_msg_level=>fnd_log.level_procedure);
2966: END IF;
2967:
2968: -- Check if API is called in debug mode. If yes, disable debug.
2969: --disable_debug;

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

2981: p_count => x_msg_count,
2982: p_data => x_msg_data );
2983:
2984: -- Debug info.
2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);

Line 2989: p_msg_level=>fnd_log.level_error);

2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990:
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990:
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;

Line 2995: p_msg_level=>fnd_log.level_procedure);

2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;
2997:
2998: -- Check if API is called in debug mode. If yes, disable debug.
2999: --disable_debug;

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

3062: -- Check if API is called in debug mode. If yes, enable debug.
3063: --enable_debug;
3064:
3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;

Line 3069: p_msg_level=>fnd_log.level_procedure);

3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;
3071:
3072: -- Initialize message list if p_init_msg_list is set to TRUE.
3073: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3125: p_count => x_msg_count,
3126: p_data => x_msg_data );
3127:
3128: -- Debug info.
3129: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3131: p_msg_data=>x_msg_data,
3132: p_msg_type=>'WARNING',
3133: p_msg_level=>fnd_log.level_exception);

Line 3133: p_msg_level=>fnd_log.level_exception);

3129: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3131: p_msg_data=>x_msg_data,
3132: p_msg_type=>'WARNING',
3133: p_msg_level=>fnd_log.level_exception);
3134: END IF;
3135: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3136: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3137: p_prefix=>l_debug_prefix,

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

3131: p_msg_data=>x_msg_data,
3132: p_msg_type=>'WARNING',
3133: p_msg_level=>fnd_log.level_exception);
3134: END IF;
3135: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3136: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3137: p_prefix=>l_debug_prefix,
3138: p_msg_level=>fnd_log.level_procedure);
3139: END IF;

Line 3138: p_msg_level=>fnd_log.level_procedure);

3134: END IF;
3135: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3136: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3137: p_prefix=>l_debug_prefix,
3138: p_msg_level=>fnd_log.level_procedure);
3139: END IF;
3140:
3141: -- Check if API is called in debug mode. If yes, disable debug.
3142: --disable_debug;

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

3151: p_count => x_msg_count,
3152: p_data => x_msg_data );
3153:
3154: -- Debug info.
3155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3157: p_msg_data=>x_msg_data,
3158: p_msg_type=>'ERROR',
3159: p_msg_level=>fnd_log.level_error);

Line 3159: p_msg_level=>fnd_log.level_error);

3155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3157: p_msg_data=>x_msg_data,
3158: p_msg_type=>'ERROR',
3159: p_msg_level=>fnd_log.level_error);
3160:
3161: END IF;
3162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3158: p_msg_type=>'ERROR',
3159: p_msg_level=>fnd_log.level_error);
3160:
3161: END IF;
3162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3164: p_prefix=>l_debug_prefix,
3165: p_msg_level=>fnd_log.level_procedure);
3166: END IF;

Line 3165: p_msg_level=>fnd_log.level_procedure);

3161: END IF;
3162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3164: p_prefix=>l_debug_prefix,
3165: p_msg_level=>fnd_log.level_procedure);
3166: END IF;
3167:
3168: -- Check if API is called in debug mode. If yes, disable debug.
3169: --disable_debug;

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

3177: p_count => x_msg_count,
3178: p_data => x_msg_data );
3179:
3180: -- Debug info.
3181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3183: p_msg_data=>x_msg_data,
3184: p_msg_type=>'UNEXPECTED ERROR',
3185: p_msg_level=>fnd_log.level_error);

Line 3185: p_msg_level=>fnd_log.level_error);

3181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3183: p_msg_data=>x_msg_data,
3184: p_msg_type=>'UNEXPECTED ERROR',
3185: p_msg_level=>fnd_log.level_error);
3186:
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3184: p_msg_type=>'UNEXPECTED ERROR',
3185: p_msg_level=>fnd_log.level_error);
3186:
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;

Line 3191: p_msg_level=>fnd_log.level_procedure);

3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;
3193:
3194: -- Check if API is called in debug mode. If yes, disable debug.
3195: --disable_debug;

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

3207: p_count => x_msg_count,
3208: p_data => x_msg_data );
3209:
3210: -- Debug info.
3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);

Line 3215: p_msg_level=>fnd_log.level_error);

3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216:
3217: END IF;
3218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3219: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216:
3217: END IF;
3218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3219: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3220: p_prefix=>l_debug_prefix,
3221: p_msg_level=>fnd_log.level_procedure);
3222: END IF;

Line 3221: p_msg_level=>fnd_log.level_procedure);

3217: END IF;
3218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3219: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3220: p_prefix=>l_debug_prefix,
3221: p_msg_level=>fnd_log.level_procedure);
3222: END IF;
3223:
3224: -- Check if API is called in debug mode. If yes, disable debug.
3225: --disable_debug;

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

3282: -- Check if API is called in debug mode. If yes, enable debug.
3283: --enable_debug;
3284:
3285: -- Debug info.
3286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3287: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3288: p_prefix=>l_debug_prefix,
3289: p_msg_level=>fnd_log.level_procedure);
3290: END IF;

Line 3289: p_msg_level=>fnd_log.level_procedure);

3285: -- Debug info.
3286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3287: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3288: p_prefix=>l_debug_prefix,
3289: p_msg_level=>fnd_log.level_procedure);
3290: END IF;
3291:
3292: -- Initialize message list if p_init_msg_list is set to TRUE.
3293: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3321: x_cust_acct_relate_rec.related_cust_account_id := p_related_cust_account_id;
3322: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3323:
3324: -- Debug info.
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;

Line 3328: p_msg_level=>fnd_log.level_procedure);

3324: -- Debug info.
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;
3330:
3331: -- Call table-handler.
3332: IF p_rowid IS NULL /* Bug 3449118 */

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

3398: END IF;
3399:
3400:
3401: -- Debug info.
3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3403: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3404: p_prefix=>l_debug_prefix,
3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;

Line 3405: p_msg_level=>fnd_log.level_procedure);

3401: -- Debug info.
3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3403: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3404: p_prefix=>l_debug_prefix,
3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407:
3408: -- Standard call to get message count and if count is 1, get message info.
3409: FND_MSG_PUB.Count_And_Get(

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

3411: p_count => x_msg_count,
3412: p_data => x_msg_data );
3413:
3414: -- Debug info.
3415: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'WARNING',
3419: p_msg_level=>fnd_log.level_exception);

Line 3419: p_msg_level=>fnd_log.level_exception);

3415: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'WARNING',
3419: p_msg_level=>fnd_log.level_exception);
3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3423: p_prefix=>l_debug_prefix,

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

3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'WARNING',
3419: p_msg_level=>fnd_log.level_exception);
3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3423: p_prefix=>l_debug_prefix,
3424: p_msg_level=>fnd_log.level_procedure);
3425: END IF;

Line 3424: p_msg_level=>fnd_log.level_procedure);

3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3423: p_prefix=>l_debug_prefix,
3424: p_msg_level=>fnd_log.level_procedure);
3425: END IF;
3426:
3427: -- Check if API is called in debug mode. If yes, disable debug.
3428: --disable_debug;

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

3437: p_count => x_msg_count,
3438: p_data => x_msg_data );
3439:
3440: -- Debug info.
3441: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3443: p_msg_data=>x_msg_data,
3444: p_msg_type=>'ERROR',
3445: p_msg_level=>fnd_log.level_error);

Line 3445: p_msg_level=>fnd_log.level_error);

3441: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3443: p_msg_data=>x_msg_data,
3444: p_msg_type=>'ERROR',
3445: p_msg_level=>fnd_log.level_error);
3446:
3447: END IF;
3448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3449: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3444: p_msg_type=>'ERROR',
3445: p_msg_level=>fnd_log.level_error);
3446:
3447: END IF;
3448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3449: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3450: p_prefix=>l_debug_prefix,
3451: p_msg_level=>fnd_log.level_procedure);
3452: END IF;

Line 3451: p_msg_level=>fnd_log.level_procedure);

3447: END IF;
3448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3449: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3450: p_prefix=>l_debug_prefix,
3451: p_msg_level=>fnd_log.level_procedure);
3452: END IF;
3453:
3454: -- Check if API is called in debug mode. If yes, disable debug.
3455: --disable_debug;

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

3462: p_count => x_msg_count,
3463: p_data => x_msg_data );
3464:
3465: -- Debug info.
3466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3468: p_msg_data=>x_msg_data,
3469: p_msg_type=>'UNEXPECTED ERROR',
3470: p_msg_level=>fnd_log.level_error);

Line 3470: p_msg_level=>fnd_log.level_error);

3466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3468: p_msg_data=>x_msg_data,
3469: p_msg_type=>'UNEXPECTED ERROR',
3470: p_msg_level=>fnd_log.level_error);
3471:
3472: END IF;
3473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3474: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3469: p_msg_type=>'UNEXPECTED ERROR',
3470: p_msg_level=>fnd_log.level_error);
3471:
3472: END IF;
3473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3474: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3475: p_prefix=>l_debug_prefix,
3476: p_msg_level=>fnd_log.level_procedure);
3477: END IF;

Line 3476: p_msg_level=>fnd_log.level_procedure);

3472: END IF;
3473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3474: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3475: p_prefix=>l_debug_prefix,
3476: p_msg_level=>fnd_log.level_procedure);
3477: END IF;
3478:
3479: -- Check if API is called in debug mode. If yes, disable debug.
3480: --disable_debug;

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

3491: p_count => x_msg_count,
3492: p_data => x_msg_data );
3493:
3494: -- Debug info.
3495: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3496: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3497: p_msg_data=>x_msg_data,
3498: p_msg_type=>'SQL ERROR',
3499: p_msg_level=>fnd_log.level_error);

Line 3499: p_msg_level=>fnd_log.level_error);

3495: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3496: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3497: p_msg_data=>x_msg_data,
3498: p_msg_type=>'SQL ERROR',
3499: p_msg_level=>fnd_log.level_error);
3500:
3501: END IF;
3502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3503: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3498: p_msg_type=>'SQL ERROR',
3499: p_msg_level=>fnd_log.level_error);
3500:
3501: END IF;
3502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3503: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3504: p_prefix=>l_debug_prefix,
3505: p_msg_level=>fnd_log.level_procedure);
3506: END IF;

Line 3505: p_msg_level=>fnd_log.level_procedure);

3501: END IF;
3502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3503: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3504: p_prefix=>l_debug_prefix,
3505: p_msg_level=>fnd_log.level_procedure);
3506: END IF;
3507:
3508: -- Check if API is called in debug mode. If yes, disable debug.
3509: --disable_debug;