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

565: X_DUNS_EXTENSION => p_cust_account_rec.duns_extension,
566: X_ADVANCE_PAYMENT_INDICATOR => p_cust_account_rec.advance_payment_indicator
567: );
568:
569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
570: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Insert API'
571: ||' FedEntType : '|| p_cust_account_rec.federal_entity_type
572: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
573: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION

Line 576: p_msg_level=>fnd_log.level_procedure);

572: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
573: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION
574: ||' AdvPmntInd : '|| p_cust_account_rec.advance_payment_indicator,
575: p_prefix=>l_debug_prefix,
576: p_msg_level=>fnd_log.level_procedure);
577: END IF;
578: -- Debug info.
579: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||

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

575: p_prefix=>l_debug_prefix,
576: p_msg_level=>fnd_log.level_procedure);
577: END IF;
578: -- Debug info.
579: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
581: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
582: 'x_account_number = ' || p_cust_account_rec.account_number,
583: p_prefix=>l_debug_prefix,

Line 584: p_msg_level=>fnd_log.level_procedure);

580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
581: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
582: 'x_account_number = ' || p_cust_account_rec.account_number,
583: p_prefix=>l_debug_prefix,
584: p_msg_level=>fnd_log.level_procedure);
585: END IF;
586:
587: if (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
588: then

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

691: x_party_number := l_party_number;
692: x_profile_id := l_profile_id;
693:
694: -- Debug info.
695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
697: p_prefix=>l_debug_prefix,
698: p_msg_level=>fnd_log.level_procedure);
699: END IF;

Line 698: p_msg_level=>fnd_log.level_procedure);

694: -- Debug info.
695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
697: p_prefix=>l_debug_prefix,
698: p_msg_level=>fnd_log.level_procedure);
699: END IF;
700:
701: END do_create_cust_account;
702:

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

767:
768: BEGIN
769:
770: -- Debug info.
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;

Line 774: p_msg_level=>fnd_log.level_procedure);

770: -- Debug info.
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;
776:
777:
778: -- Lock record.

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

829: -- but we should not update existing osr, set it to null
830: end if;
831:
832: -- Debug info.
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;

Line 836: p_msg_level=>fnd_log.level_procedure);

832: -- Debug info.
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
838:
839: -- Call table-handler.
840: HZ_CUST_ACCOUNTS_PKG.Update_Row (

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

947: X_ADVANCE_PAYMENT_INDICATOR => p_cust_account_rec.advance_payment_indicator
948: );
949:
950: -- Debug info.
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;

Line 954: p_msg_level=>fnd_log.level_procedure);

950: -- Debug info.
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;
956:
957: --
958: -- R12 party usage project

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

1003: END IF;
1004: END IF;
1005:
1006: -- Debug info.
1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1008: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
1009: p_prefix=>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_procedure);
1011: END IF;

Line 1010: p_msg_level=>fnd_log.level_procedure);

1006: -- Debug info.
1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1008: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
1009: p_prefix=>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_procedure);
1011: END IF;
1012:
1013: END do_update_cust_account;
1014:

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

1062: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
1063: BEGIN
1064:
1065: -- Debug info.
1066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1067: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1068: p_prefix=>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_procedure);
1070: END IF;

Line 1069: p_msg_level=>fnd_log.level_procedure);

1065: -- Debug info.
1066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1067: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1068: p_prefix=>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_procedure);
1070: END IF;
1071:
1072: -- No sequence number is used for cust_acct_relate
1073:

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

1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094:
1095: -- Debug info.
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;

Line 1099: p_msg_level=>fnd_log.level_procedure);

1095: -- Debug info.
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101:
1102: -- Call table-handler.
1103: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (

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

1132: X_CUST_ACCT_RELATE_ID => p_cust_acct_relate_rec.cust_acct_relate_id -- Bug 4529413
1133: );
1134:
1135: -- Debug info.
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;

Line 1139: p_msg_level=>fnd_log.level_procedure);

1135: -- Debug info.
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141:
1142: -- check customer_reciprocal_flag, if 'Y', need to create
1143: -- a relationship record for related customer account or update

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

1151: THEN
1152: BEGIN
1153:
1154: -- Debug info.
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: END IF;

Line 1158: p_msg_level=>fnd_log.level_statement);

1154: -- Debug info.
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: END IF;
1160:
1161: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1162: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag

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

1201: END;
1202: END IF;
1203:
1204: -- Debug info.
1205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1206: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1207: p_prefix=>l_debug_prefix,
1208: p_msg_level=>fnd_log.level_procedure);
1209: END IF;

Line 1208: p_msg_level=>fnd_log.level_procedure);

1204: -- Debug info.
1205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1206: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1207: p_prefix=>l_debug_prefix,
1208: p_msg_level=>fnd_log.level_procedure);
1209: END IF;
1210:
1211: END do_create_cust_acct_relate;
1212:

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

1267:
1268: BEGIN
1269:
1270: -- Debug info.
1271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;

Line 1274: p_msg_level=>fnd_log.level_procedure);

1270: -- Debug info.
1271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;
1276:
1277: -- Lock record.
1278:

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

1424: RAISE FND_API.G_EXC_ERROR;
1425: END IF;
1426:
1427: -- Debug info.
1428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1430: p_prefix=>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_procedure);
1432: END IF;

Line 1431: p_msg_level=>fnd_log.level_procedure);

1427: -- Debug info.
1428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1430: p_prefix=>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_procedure);
1432: END IF;
1433:
1434: -- Call table-handler.
1435: HZ_CUST_ACCT_RELATE_PKG.Update_Row (

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

1463: X_APPLICATION_ID => p_cust_acct_relate_rec.application_id
1464: );
1465:
1466: -- Debug info.
1467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1469: p_prefix=>l_debug_prefix,
1470: p_msg_level=>fnd_log.level_procedure);
1471: END IF;

Line 1470: p_msg_level=>fnd_log.level_procedure);

1466: -- Debug info.
1467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1469: p_prefix=>l_debug_prefix,
1470: p_msg_level=>fnd_log.level_procedure);
1471: END IF;
1472:
1473: -- customer_reciprocal_flag is non-updateable. We do not need to implement the
1474: -- same logic in insert mode during update.

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

1473: -- customer_reciprocal_flag is non-updateable. We do not need to implement the
1474: -- same logic in insert mode during update.
1475:
1476: -- Debug info.
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1479: p_prefix=>l_debug_prefix,
1480: p_msg_level=>fnd_log.level_procedure);
1481: END IF;

Line 1480: p_msg_level=>fnd_log.level_procedure);

1476: -- Debug info.
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1479: p_prefix=>l_debug_prefix,
1480: p_msg_level=>fnd_log.level_procedure);
1481: END IF;
1482:
1483: END do_update_cust_acct_relate;
1484:

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

1563: -- Check if API is called in debug mode. If yes, enable debug.
1564: --enable_debug;
1565:
1566: -- Debug info.
1567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1568: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1569: p_prefix=>l_debug_prefix,
1570: p_msg_level=>fnd_log.level_procedure);
1571: END IF;

Line 1570: p_msg_level=>fnd_log.level_procedure);

1566: -- Debug info.
1567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1568: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1569: p_prefix=>l_debug_prefix,
1570: p_msg_level=>fnd_log.level_procedure);
1571: END IF;
1572:
1573: -- Initialize message list if p_init_msg_list is set to TRUE.
1574: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1634: p_count => x_msg_count,
1635: p_data => x_msg_data );
1636:
1637: -- Debug info.
1638: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1640: p_msg_data=>x_msg_data,
1641: p_msg_type=>'WARNING',
1642: p_msg_level=>fnd_log.level_exception);

Line 1642: p_msg_level=>fnd_log.level_exception);

1638: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1640: p_msg_data=>x_msg_data,
1641: p_msg_type=>'WARNING',
1642: p_msg_level=>fnd_log.level_exception);
1643: END IF;
1644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1646: p_prefix=>l_debug_prefix,

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

1640: p_msg_data=>x_msg_data,
1641: p_msg_type=>'WARNING',
1642: p_msg_level=>fnd_log.level_exception);
1643: END IF;
1644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1646: p_prefix=>l_debug_prefix,
1647: p_msg_level=>fnd_log.level_procedure);
1648: END IF;

Line 1647: p_msg_level=>fnd_log.level_procedure);

1643: END IF;
1644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1646: p_prefix=>l_debug_prefix,
1647: p_msg_level=>fnd_log.level_procedure);
1648: END IF;
1649:
1650: -- Check if API is called in debug mode. If yes, disable debug.
1651: --disable_debug;

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

1660: p_count => x_msg_count,
1661: p_data => x_msg_data );
1662:
1663: -- Debug info.
1664: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1666: p_msg_data=>x_msg_data,
1667: p_msg_type=>'ERROR',
1668: p_msg_level=>fnd_log.level_error);

Line 1668: p_msg_level=>fnd_log.level_error);

1664: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1666: p_msg_data=>x_msg_data,
1667: p_msg_type=>'ERROR',
1668: p_msg_level=>fnd_log.level_error);
1669:
1670: END IF;
1671: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1672: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1667: p_msg_type=>'ERROR',
1668: p_msg_level=>fnd_log.level_error);
1669:
1670: END IF;
1671: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1672: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1673: p_prefix=>l_debug_prefix,
1674: p_msg_level=>fnd_log.level_procedure);
1675: END IF;

Line 1674: p_msg_level=>fnd_log.level_procedure);

1670: END IF;
1671: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1672: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1673: p_prefix=>l_debug_prefix,
1674: p_msg_level=>fnd_log.level_procedure);
1675: END IF;
1676:
1677: -- Check if API is called in debug mode. If yes, disable debug.
1678: --disable_debug;

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

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

Line 1694: p_msg_level=>fnd_log.level_error);

1690: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1692: p_msg_data=>x_msg_data,
1693: p_msg_type=>'UNEXPECTED ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695:
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1693: p_msg_type=>'UNEXPECTED ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695:
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
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=>'create_cust_account (-) : for person',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702:
1703: -- Check if API is called in debug mode. If yes, disable debug.
1704: --disable_debug;

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

1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: -- Debug info.
1720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1722: p_msg_data=>x_msg_data,
1723: p_msg_type=>'SQL ERROR',
1724: p_msg_level=>fnd_log.level_error);

Line 1724: p_msg_level=>fnd_log.level_error);

1720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1722: p_msg_data=>x_msg_data,
1723: p_msg_type=>'SQL ERROR',
1724: p_msg_level=>fnd_log.level_error);
1725:
1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

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

1723: p_msg_type=>'SQL ERROR',
1724: p_msg_level=>fnd_log.level_error);
1725:
1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;

Line 1730: p_msg_level=>fnd_log.level_procedure);

1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732:
1733: -- Check if API is called in debug mode. If yes, disable debug.
1734: --disable_debug;

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

1812: -- Check if API is called in debug mode. If yes, enable debug.
1813: --enable_debug;
1814:
1815: -- Debug info.
1816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1818: p_prefix=>l_debug_prefix,
1819: p_msg_level=>fnd_log.level_procedure);
1820: END IF;

Line 1819: p_msg_level=>fnd_log.level_procedure);

1815: -- Debug info.
1816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1818: p_prefix=>l_debug_prefix,
1819: p_msg_level=>fnd_log.level_procedure);
1820: END IF;
1821:
1822: -- Initialize message list if p_init_msg_list is set to TRUE.
1823: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1882: p_count => x_msg_count,
1883: p_data => x_msg_data );
1884:
1885: -- Debug info.
1886: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1888: p_msg_data=>x_msg_data,
1889: p_msg_type=>'WARNING',
1890: p_msg_level=>fnd_log.level_exception);

Line 1890: p_msg_level=>fnd_log.level_exception);

1886: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1888: p_msg_data=>x_msg_data,
1889: p_msg_type=>'WARNING',
1890: p_msg_level=>fnd_log.level_exception);
1891: END IF;
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1894: p_prefix=>l_debug_prefix,

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

1888: p_msg_data=>x_msg_data,
1889: p_msg_type=>'WARNING',
1890: p_msg_level=>fnd_log.level_exception);
1891: END IF;
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1894: p_prefix=>l_debug_prefix,
1895: p_msg_level=>fnd_log.level_procedure);
1896: END IF;

Line 1895: p_msg_level=>fnd_log.level_procedure);

1891: END IF;
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1894: p_prefix=>l_debug_prefix,
1895: p_msg_level=>fnd_log.level_procedure);
1896: END IF;
1897:
1898:
1899: -- Check if API is called in debug mode. If yes, disable debug.

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

1909: p_count => x_msg_count,
1910: p_data => x_msg_data );
1911:
1912: -- Debug info.
1913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1915: p_msg_data=>x_msg_data,
1916: p_msg_type=>'ERROR',
1917: p_msg_level=>fnd_log.level_error);

Line 1917: p_msg_level=>fnd_log.level_error);

1913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1915: p_msg_data=>x_msg_data,
1916: p_msg_type=>'ERROR',
1917: p_msg_level=>fnd_log.level_error);
1918:
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1916: p_msg_type=>'ERROR',
1917: p_msg_level=>fnd_log.level_error);
1918:
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;

Line 1923: p_msg_level=>fnd_log.level_procedure);

1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;
1925:
1926: -- Check if API is called in debug mode. If yes, disable debug.
1927: --disable_debug;

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

1935: p_count => x_msg_count,
1936: p_data => x_msg_data );
1937:
1938: -- Debug info.
1939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1941: p_msg_data=>x_msg_data,
1942: p_msg_type=>'UNEXPECTED ERROR',
1943: p_msg_level=>fnd_log.level_error);

Line 1943: p_msg_level=>fnd_log.level_error);

1939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1941: p_msg_data=>x_msg_data,
1942: p_msg_type=>'UNEXPECTED ERROR',
1943: p_msg_level=>fnd_log.level_error);
1944:
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1942: p_msg_type=>'UNEXPECTED ERROR',
1943: p_msg_level=>fnd_log.level_error);
1944:
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;

Line 1949: p_msg_level=>fnd_log.level_procedure);

1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951:
1952: -- Check if API is called in debug mode. If yes, disable debug.
1953: --disable_debug;

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

1966: p_data => x_msg_data );
1967:
1968: -- Debug info.
1969:
1970: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1971: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1972: p_msg_data=>x_msg_data,
1973: p_msg_type=>'SQL ERROR',
1974: p_msg_level=>fnd_log.level_error);

Line 1974: p_msg_level=>fnd_log.level_error);

1970: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1971: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1972: p_msg_data=>x_msg_data,
1973: p_msg_type=>'SQL ERROR',
1974: p_msg_level=>fnd_log.level_error);
1975:
1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

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

1973: p_msg_type=>'SQL ERROR',
1974: p_msg_level=>fnd_log.level_error);
1975:
1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;

Line 1980: p_msg_level=>fnd_log.level_procedure);

1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1982:
1983:
1984: -- Check if API is called in debug mode. If yes, disable debug.

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

2039: -- Check if API is called in debug mode. If yes, enable debug.
2040: --enable_debug;
2041:
2042: -- Debug info.
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;

Line 2046: p_msg_level=>fnd_log.level_procedure);

2042: -- Debug info.
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2048:
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Update API'

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

2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2048:
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Update API'
2051: ||' FedEntType : '|| p_cust_account_rec.federal_entity_type
2052: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
2053: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION

Line 2056: p_msg_level=>fnd_log.level_procedure);

2052: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
2053: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION
2054: ||' AdvPmntInd : '|| p_cust_account_rec.advance_payment_indicator,
2055: p_prefix=>l_debug_prefix,
2056: p_msg_level=>fnd_log.level_procedure);
2057: END IF;
2058:
2059: -- Initialize message list if p_init_msg_list is set to TRUE.
2060: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 2146: p_msg_level=>fnd_log.level_exception);

2142: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2143: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2144: p_msg_data=>x_msg_data,
2145: p_msg_type=>'WARNING',
2146: p_msg_level=>fnd_log.level_exception);
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,

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

2144: p_msg_data=>x_msg_data,
2145: p_msg_type=>'WARNING',
2146: p_msg_level=>fnd_log.level_exception);
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 2168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 2172: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2178: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2198: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2204: p_msg_level=>fnd_log.level_procedure);

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

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

2220: p_count => x_msg_count,
2221: p_data => x_msg_data );
2222:
2223: -- Debug info.
2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'SQL ERROR',
2228: p_msg_level=>fnd_log.level_error);

Line 2228: p_msg_level=>fnd_log.level_error);

2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'SQL ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229:
2230: END IF;
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

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

2227: p_msg_type=>'SQL ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229:
2230: END IF;
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;

Line 2234: p_msg_level=>fnd_log.level_procedure);

2230: END IF;
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;
2236:
2237: -- Check if API is called in debug mode. If yes, disable debug.
2238: --disable_debug;

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

2290: -- Check if API is called in debug mode. If yes, enable debug.
2291: --enable_debug;
2292:
2293: -- Debug info.
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;

Line 2297: p_msg_level=>fnd_log.level_procedure);

2293: -- Debug info.
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;
2299:
2300: -- Initialize message list if p_init_msg_list is set to TRUE.
2301: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2320: END IF;
2321:
2322: x_cust_account_rec.cust_account_id := p_cust_account_id;
2323:
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
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:
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:
2330: -- Call table-handler.
2331: HZ_CUST_ACCOUNTS_PKG.Select_Row (

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

2436: );
2437:
2438:
2439:
2440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2441: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2442: p_prefix=>l_debug_prefix,
2443: p_msg_level=>fnd_log.level_procedure);
2444: END IF;

Line 2443: p_msg_level=>fnd_log.level_procedure);

2439:
2440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2441: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2442: p_prefix=>l_debug_prefix,
2443: p_msg_level=>fnd_log.level_procedure);
2444: END IF;
2445:
2446: -- Fetch customer profile id.
2447: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id

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

2470: p_count => x_msg_count,
2471: p_data => x_msg_data );
2472:
2473: -- Debug info.
2474: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2475: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2476: p_msg_data=>x_msg_data,
2477: p_msg_type=>'WARNING',
2478: p_msg_level=>fnd_log.level_exception);

Line 2478: p_msg_level=>fnd_log.level_exception);

2474: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2475: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2476: p_msg_data=>x_msg_data,
2477: p_msg_type=>'WARNING',
2478: p_msg_level=>fnd_log.level_exception);
2479: END IF;
2480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2482: p_prefix=>l_debug_prefix,

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

2476: p_msg_data=>x_msg_data,
2477: p_msg_type=>'WARNING',
2478: p_msg_level=>fnd_log.level_exception);
2479: END IF;
2480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2482: p_prefix=>l_debug_prefix,
2483: p_msg_level=>fnd_log.level_procedure);
2484: END IF;

Line 2483: p_msg_level=>fnd_log.level_procedure);

2479: END IF;
2480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2482: p_prefix=>l_debug_prefix,
2483: p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485:
2486: -- Check if API is called in debug mode. If yes, disable debug.
2487: --disable_debug;

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

2495: p_count => x_msg_count,
2496: p_data => x_msg_data );
2497:
2498: -- Debug info.
2499: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2501: p_msg_data=>x_msg_data,
2502: p_msg_type=>'ERROR',
2503: p_msg_level=>fnd_log.level_error);

Line 2503: p_msg_level=>fnd_log.level_error);

2499: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2501: p_msg_data=>x_msg_data,
2502: p_msg_type=>'ERROR',
2503: p_msg_level=>fnd_log.level_error);
2504:
2505: END IF;
2506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2507: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

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

2502: p_msg_type=>'ERROR',
2503: p_msg_level=>fnd_log.level_error);
2504:
2505: END IF;
2506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2507: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2508: p_prefix=>l_debug_prefix,
2509: p_msg_level=>fnd_log.level_procedure);
2510: END IF;

Line 2509: p_msg_level=>fnd_log.level_procedure);

2505: END IF;
2506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2507: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2508: p_prefix=>l_debug_prefix,
2509: p_msg_level=>fnd_log.level_procedure);
2510: END IF;
2511:
2512: -- Check if API is called in debug mode. If yes, disable debug.
2513: --disable_debug;

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

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

Line 2528: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2534: p_msg_level=>fnd_log.level_procedure);

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

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

2550: p_count => x_msg_count,
2551: p_data => x_msg_data );
2552:
2553: -- Debug info.
2554: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'SQL ERROR',
2558: p_msg_level=>fnd_log.level_error);

Line 2558: p_msg_level=>fnd_log.level_error);

2554: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'SQL ERROR',
2558: p_msg_level=>fnd_log.level_error);
2559:
2560: END IF;
2561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2562: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

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

2557: p_msg_type=>'SQL ERROR',
2558: p_msg_level=>fnd_log.level_error);
2559:
2560: END IF;
2561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2562: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2563: p_prefix=>l_debug_prefix,
2564: p_msg_level=>fnd_log.level_procedure);
2565: END IF;

Line 2564: p_msg_level=>fnd_log.level_procedure);

2560: END IF;
2561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2562: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2563: p_prefix=>l_debug_prefix,
2564: p_msg_level=>fnd_log.level_procedure);
2565: END IF;
2566:
2567: -- Check if API is called in debug mode. If yes, disable debug.
2568: --disable_debug;

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

2668: -- Check if API is called in debug mode. If yes, enable debug.
2669: --enable_debug;
2670:
2671: -- Debug info.
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;

Line 2675: p_msg_level=>fnd_log.level_procedure);

2671: -- Debug info.
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677:
2678: -- Initialize message list if p_init_msg_list is set to TRUE.
2679: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2711: p_count => x_msg_count,
2712: p_data => x_msg_data );
2713:
2714: -- Debug info.
2715: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2717: p_msg_data=>x_msg_data,
2718: p_msg_type=>'WARNING',
2719: p_msg_level=>fnd_log.level_exception);

Line 2719: p_msg_level=>fnd_log.level_exception);

2715: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2717: p_msg_data=>x_msg_data,
2718: p_msg_type=>'WARNING',
2719: p_msg_level=>fnd_log.level_exception);
2720: END IF;
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2723: p_prefix=>l_debug_prefix,

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

2717: p_msg_data=>x_msg_data,
2718: p_msg_type=>'WARNING',
2719: p_msg_level=>fnd_log.level_exception);
2720: END IF;
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2723: p_prefix=>l_debug_prefix,
2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;

Line 2724: p_msg_level=>fnd_log.level_procedure);

2720: END IF;
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2723: p_prefix=>l_debug_prefix,
2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;
2726:
2727: -- Check if API is called in debug mode. If yes, disable debug.
2728: --disable_debug;

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

2737: p_count => x_msg_count,
2738: p_data => x_msg_data );
2739:
2740: -- Debug info.
2741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'ERROR',
2745: p_msg_level=>fnd_log.level_error);

Line 2745: p_msg_level=>fnd_log.level_error);

2741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'ERROR',
2745: p_msg_level=>fnd_log.level_error);
2746:
2747: END IF;
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',

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

2744: p_msg_type=>'ERROR',
2745: p_msg_level=>fnd_log.level_error);
2746:
2747: END IF;
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;

Line 2751: p_msg_level=>fnd_log.level_procedure);

2747: END IF;
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;
2753:
2754: -- Check if API is called in debug mode. If yes, disable debug.
2755: --disable_debug;

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

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

Line 2771: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2777: p_msg_level=>fnd_log.level_procedure);

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

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

2793: p_count => x_msg_count,
2794: p_data => x_msg_data );
2795:
2796: -- Debug info.
2797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2799: p_msg_data=>x_msg_data,
2800: p_msg_type=>'SQL ERROR',
2801: p_msg_level=>fnd_log.level_error);

Line 2801: p_msg_level=>fnd_log.level_error);

2797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2799: p_msg_data=>x_msg_data,
2800: p_msg_type=>'SQL ERROR',
2801: p_msg_level=>fnd_log.level_error);
2802:
2803: END IF;
2804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',

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

2800: p_msg_type=>'SQL ERROR',
2801: p_msg_level=>fnd_log.level_error);
2802:
2803: END IF;
2804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2806: p_prefix=>l_debug_prefix,
2807: p_msg_level=>fnd_log.level_procedure);
2808: END IF;

Line 2807: p_msg_level=>fnd_log.level_procedure);

2803: END IF;
2804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2806: p_prefix=>l_debug_prefix,
2807: p_msg_level=>fnd_log.level_procedure);
2808: END IF;
2809:
2810: -- Check if API is called in debug mode. If yes, disable debug.
2811: --disable_debug;

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

2868: -- Check if API is called in debug mode. If yes, enable debug.
2869: --enable_debug;
2870:
2871: -- Debug info.
2872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2873: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2874: p_prefix=>l_debug_prefix,
2875: p_msg_level=>fnd_log.level_procedure);
2876: END IF;

Line 2875: p_msg_level=>fnd_log.level_procedure);

2871: -- Debug info.
2872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2873: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2874: p_prefix=>l_debug_prefix,
2875: p_msg_level=>fnd_log.level_procedure);
2876: END IF;
2877:
2878: -- Initialize message list if p_init_msg_list is set to TRUE.
2879: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2933: p_count => x_msg_count,
2934: p_data => x_msg_data );
2935:
2936: -- Debug info.
2937: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'WARNING',
2941: p_msg_level=>fnd_log.level_exception);

Line 2941: p_msg_level=>fnd_log.level_exception);

2937: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'WARNING',
2941: p_msg_level=>fnd_log.level_exception);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2945: p_prefix=>l_debug_prefix,

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

2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'WARNING',
2941: p_msg_level=>fnd_log.level_exception);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;

Line 2946: p_msg_level=>fnd_log.level_procedure);

2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;
2948:
2949: -- Check if API is called in debug mode. If yes, disable debug.
2950: --disable_debug;

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

2959: p_count => x_msg_count,
2960: p_data => x_msg_data );
2961:
2962: -- Debug info.
2963: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2965: p_msg_data=>x_msg_data,
2966: p_msg_type=>'ERROR',
2967: p_msg_level=>fnd_log.level_error);

Line 2967: p_msg_level=>fnd_log.level_error);

2963: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2965: p_msg_data=>x_msg_data,
2966: p_msg_type=>'ERROR',
2967: p_msg_level=>fnd_log.level_error);
2968:
2969: END IF;
2970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2971: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

2966: p_msg_type=>'ERROR',
2967: p_msg_level=>fnd_log.level_error);
2968:
2969: END IF;
2970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2971: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2972: p_prefix=>l_debug_prefix,
2973: p_msg_level=>fnd_log.level_procedure);
2974: END IF;

Line 2973: p_msg_level=>fnd_log.level_procedure);

2969: END IF;
2970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2971: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2972: p_prefix=>l_debug_prefix,
2973: p_msg_level=>fnd_log.level_procedure);
2974: END IF;
2975:
2976: -- Check if API is called in debug mode. If yes, disable debug.
2977: --disable_debug;

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

2985: p_count => x_msg_count,
2986: p_data => x_msg_data );
2987:
2988: -- Debug info.
2989: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2990: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2991: p_msg_data=>x_msg_data,
2992: p_msg_type=>'UNEXPECTED ERROR',
2993: p_msg_level=>fnd_log.level_error);

Line 2993: p_msg_level=>fnd_log.level_error);

2989: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2990: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2991: p_msg_data=>x_msg_data,
2992: p_msg_type=>'UNEXPECTED ERROR',
2993: p_msg_level=>fnd_log.level_error);
2994:
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

2992: p_msg_type=>'UNEXPECTED ERROR',
2993: p_msg_level=>fnd_log.level_error);
2994:
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2998: p_prefix=>l_debug_prefix,
2999: p_msg_level=>fnd_log.level_procedure);
3000: END IF;

Line 2999: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 3023: p_msg_level=>fnd_log.level_error);

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

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

3022: p_msg_type=>'SQL ERROR',
3023: p_msg_level=>fnd_log.level_error);
3024:
3025: END IF;
3026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3027: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3028: p_prefix=>l_debug_prefix,
3029: p_msg_level=>fnd_log.level_procedure);
3030: END IF;

Line 3029: p_msg_level=>fnd_log.level_procedure);

3025: END IF;
3026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3027: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3028: p_prefix=>l_debug_prefix,
3029: p_msg_level=>fnd_log.level_procedure);
3030: END IF;
3031:
3032: -- Check if API is called in debug mode. If yes, disable debug.
3033: --disable_debug;

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

3096: -- Check if API is called in debug mode. If yes, enable debug.
3097: --enable_debug;
3098:
3099: -- Debug info.
3100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3101: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3102: p_prefix=>l_debug_prefix,
3103: p_msg_level=>fnd_log.level_procedure);
3104: END IF;

Line 3103: p_msg_level=>fnd_log.level_procedure);

3099: -- Debug info.
3100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3101: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3102: p_prefix=>l_debug_prefix,
3103: p_msg_level=>fnd_log.level_procedure);
3104: END IF;
3105:
3106: -- Initialize message list if p_init_msg_list is set to TRUE.
3107: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3160: p_count => x_msg_count,
3161: p_data => x_msg_data );
3162:
3163: -- Debug info.
3164: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3166: p_msg_data=>x_msg_data,
3167: p_msg_type=>'WARNING',
3168: p_msg_level=>fnd_log.level_exception);

Line 3168: p_msg_level=>fnd_log.level_exception);

3164: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3166: p_msg_data=>x_msg_data,
3167: p_msg_type=>'WARNING',
3168: p_msg_level=>fnd_log.level_exception);
3169: END IF;
3170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3171: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3172: p_prefix=>l_debug_prefix,

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

3166: p_msg_data=>x_msg_data,
3167: p_msg_type=>'WARNING',
3168: p_msg_level=>fnd_log.level_exception);
3169: END IF;
3170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3171: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3172: p_prefix=>l_debug_prefix,
3173: p_msg_level=>fnd_log.level_procedure);
3174: END IF;

Line 3173: p_msg_level=>fnd_log.level_procedure);

3169: END IF;
3170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3171: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3172: p_prefix=>l_debug_prefix,
3173: p_msg_level=>fnd_log.level_procedure);
3174: END IF;
3175:
3176: -- Check if API is called in debug mode. If yes, disable debug.
3177: --disable_debug;

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

3186: p_count => x_msg_count,
3187: p_data => x_msg_data );
3188:
3189: -- Debug info.
3190: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3192: p_msg_data=>x_msg_data,
3193: p_msg_type=>'ERROR',
3194: p_msg_level=>fnd_log.level_error);

Line 3194: p_msg_level=>fnd_log.level_error);

3190: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3192: p_msg_data=>x_msg_data,
3193: p_msg_type=>'ERROR',
3194: p_msg_level=>fnd_log.level_error);
3195:
3196: END IF;
3197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3198: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3193: p_msg_type=>'ERROR',
3194: p_msg_level=>fnd_log.level_error);
3195:
3196: END IF;
3197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3198: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3199: p_prefix=>l_debug_prefix,
3200: p_msg_level=>fnd_log.level_procedure);
3201: END IF;

Line 3200: p_msg_level=>fnd_log.level_procedure);

3196: END IF;
3197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3198: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3199: p_prefix=>l_debug_prefix,
3200: p_msg_level=>fnd_log.level_procedure);
3201: END IF;
3202:
3203: -- Check if API is called in debug mode. If yes, disable debug.
3204: --disable_debug;

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

3212: p_count => x_msg_count,
3213: p_data => x_msg_data );
3214:
3215: -- Debug info.
3216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3218: p_msg_data=>x_msg_data,
3219: p_msg_type=>'UNEXPECTED ERROR',
3220: p_msg_level=>fnd_log.level_error);

Line 3220: p_msg_level=>fnd_log.level_error);

3216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3218: p_msg_data=>x_msg_data,
3219: p_msg_type=>'UNEXPECTED ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221:
3222: END IF;
3223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3224: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3219: p_msg_type=>'UNEXPECTED ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221:
3222: END IF;
3223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3224: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3225: p_prefix=>l_debug_prefix,
3226: p_msg_level=>fnd_log.level_procedure);
3227: END IF;

Line 3226: p_msg_level=>fnd_log.level_procedure);

3222: END IF;
3223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3224: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3225: p_prefix=>l_debug_prefix,
3226: p_msg_level=>fnd_log.level_procedure);
3227: END IF;
3228:
3229: -- Check if API is called in debug mode. If yes, disable debug.
3230: --disable_debug;

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

3242: p_count => x_msg_count,
3243: p_data => x_msg_data );
3244:
3245: -- Debug info.
3246: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3247: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3248: p_msg_data=>x_msg_data,
3249: p_msg_type=>'SQL ERROR',
3250: p_msg_level=>fnd_log.level_error);

Line 3250: p_msg_level=>fnd_log.level_error);

3246: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3247: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3248: p_msg_data=>x_msg_data,
3249: p_msg_type=>'SQL ERROR',
3250: p_msg_level=>fnd_log.level_error);
3251:
3252: END IF;
3253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3254: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

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

3249: p_msg_type=>'SQL ERROR',
3250: p_msg_level=>fnd_log.level_error);
3251:
3252: END IF;
3253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3254: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3255: p_prefix=>l_debug_prefix,
3256: p_msg_level=>fnd_log.level_procedure);
3257: END IF;

Line 3256: p_msg_level=>fnd_log.level_procedure);

3252: END IF;
3253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3254: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3255: p_prefix=>l_debug_prefix,
3256: p_msg_level=>fnd_log.level_procedure);
3257: END IF;
3258:
3259: -- Check if API is called in debug mode. If yes, disable debug.
3260: --disable_debug;

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

3317: -- Check if API is called in debug mode. If yes, enable debug.
3318: --enable_debug;
3319:
3320: -- Debug info.
3321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3322: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3323: p_prefix=>l_debug_prefix,
3324: p_msg_level=>fnd_log.level_procedure);
3325: END IF;

Line 3324: p_msg_level=>fnd_log.level_procedure);

3320: -- Debug info.
3321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3322: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3323: p_prefix=>l_debug_prefix,
3324: p_msg_level=>fnd_log.level_procedure);
3325: END IF;
3326:
3327: -- Initialize message list if p_init_msg_list is set to TRUE.
3328: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3356: x_cust_acct_relate_rec.related_cust_account_id := p_related_cust_account_id;
3357: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3358:
3359: -- Debug info.
3360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3362: p_prefix=>l_debug_prefix,
3363: p_msg_level=>fnd_log.level_procedure);
3364: END IF;

Line 3363: p_msg_level=>fnd_log.level_procedure);

3359: -- Debug info.
3360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3362: p_prefix=>l_debug_prefix,
3363: p_msg_level=>fnd_log.level_procedure);
3364: END IF;
3365:
3366: -- Call table-handler.
3367: IF p_rowid IS NULL /* Bug 3449118 */

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

3433: END IF;
3434:
3435:
3436: -- Debug info.
3437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3438: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3439: p_prefix=>l_debug_prefix,
3440: p_msg_level=>fnd_log.level_procedure);
3441: END IF;

Line 3440: p_msg_level=>fnd_log.level_procedure);

3436: -- Debug info.
3437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3438: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3439: p_prefix=>l_debug_prefix,
3440: p_msg_level=>fnd_log.level_procedure);
3441: END IF;
3442:
3443: -- Standard call to get message count and if count is 1, get message info.
3444: FND_MSG_PUB.Count_And_Get(

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

3446: p_count => x_msg_count,
3447: p_data => x_msg_data );
3448:
3449: -- Debug info.
3450: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3452: p_msg_data=>x_msg_data,
3453: p_msg_type=>'WARNING',
3454: p_msg_level=>fnd_log.level_exception);

Line 3454: p_msg_level=>fnd_log.level_exception);

3450: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3452: p_msg_data=>x_msg_data,
3453: p_msg_type=>'WARNING',
3454: p_msg_level=>fnd_log.level_exception);
3455: END IF;
3456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3457: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3458: p_prefix=>l_debug_prefix,

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

3452: p_msg_data=>x_msg_data,
3453: p_msg_type=>'WARNING',
3454: p_msg_level=>fnd_log.level_exception);
3455: END IF;
3456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3457: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3458: p_prefix=>l_debug_prefix,
3459: p_msg_level=>fnd_log.level_procedure);
3460: END IF;

Line 3459: p_msg_level=>fnd_log.level_procedure);

3455: END IF;
3456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3457: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3458: p_prefix=>l_debug_prefix,
3459: p_msg_level=>fnd_log.level_procedure);
3460: END IF;
3461:
3462: -- Check if API is called in debug mode. If yes, disable debug.
3463: --disable_debug;

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

3472: p_count => x_msg_count,
3473: p_data => x_msg_data );
3474:
3475: -- Debug info.
3476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3478: p_msg_data=>x_msg_data,
3479: p_msg_type=>'ERROR',
3480: p_msg_level=>fnd_log.level_error);

Line 3480: p_msg_level=>fnd_log.level_error);

3476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3478: p_msg_data=>x_msg_data,
3479: p_msg_type=>'ERROR',
3480: p_msg_level=>fnd_log.level_error);
3481:
3482: END IF;
3483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3484: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3479: p_msg_type=>'ERROR',
3480: p_msg_level=>fnd_log.level_error);
3481:
3482: END IF;
3483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3484: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3485: p_prefix=>l_debug_prefix,
3486: p_msg_level=>fnd_log.level_procedure);
3487: END IF;

Line 3486: p_msg_level=>fnd_log.level_procedure);

3482: END IF;
3483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3484: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3485: p_prefix=>l_debug_prefix,
3486: p_msg_level=>fnd_log.level_procedure);
3487: END IF;
3488:
3489: -- Check if API is called in debug mode. If yes, disable debug.
3490: --disable_debug;

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

3497: p_count => x_msg_count,
3498: p_data => x_msg_data );
3499:
3500: -- Debug info.
3501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3503: p_msg_data=>x_msg_data,
3504: p_msg_type=>'UNEXPECTED ERROR',
3505: p_msg_level=>fnd_log.level_error);

Line 3505: p_msg_level=>fnd_log.level_error);

3501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3503: p_msg_data=>x_msg_data,
3504: p_msg_type=>'UNEXPECTED ERROR',
3505: p_msg_level=>fnd_log.level_error);
3506:
3507: END IF;
3508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3509: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3504: p_msg_type=>'UNEXPECTED ERROR',
3505: p_msg_level=>fnd_log.level_error);
3506:
3507: END IF;
3508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3509: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3510: p_prefix=>l_debug_prefix,
3511: p_msg_level=>fnd_log.level_procedure);
3512: END IF;

Line 3511: p_msg_level=>fnd_log.level_procedure);

3507: END IF;
3508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3509: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3510: p_prefix=>l_debug_prefix,
3511: p_msg_level=>fnd_log.level_procedure);
3512: END IF;
3513:
3514: -- Check if API is called in debug mode. If yes, disable debug.
3515: --disable_debug;

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

3526: p_count => x_msg_count,
3527: p_data => x_msg_data );
3528:
3529: -- Debug info.
3530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3532: p_msg_data=>x_msg_data,
3533: p_msg_type=>'SQL ERROR',
3534: p_msg_level=>fnd_log.level_error);

Line 3534: p_msg_level=>fnd_log.level_error);

3530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3532: p_msg_data=>x_msg_data,
3533: p_msg_type=>'SQL ERROR',
3534: p_msg_level=>fnd_log.level_error);
3535:
3536: END IF;
3537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3538: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

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

3533: p_msg_type=>'SQL ERROR',
3534: p_msg_level=>fnd_log.level_error);
3535:
3536: END IF;
3537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3538: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3539: p_prefix=>l_debug_prefix,
3540: p_msg_level=>fnd_log.level_procedure);
3541: END IF;

Line 3540: p_msg_level=>fnd_log.level_procedure);

3536: END IF;
3537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3538: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3539: p_prefix=>l_debug_prefix,
3540: p_msg_level=>fnd_log.level_procedure);
3541: END IF;
3542:
3543: -- Check if API is called in debug mode. If yes, disable debug.
3544: --disable_debug;