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

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

229:
230: BEGIN
231:
232: -- Debug info.
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (+)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;

Line 236: p_msg_level=>fnd_log.level_procedure);

232: -- Debug info.
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (+)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238:
239: --
240: --- Before creating account site, inherit status from party site(bug 3299622)

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

325: p_cust_acct_site_rec.cust_account_id, p_cust_acct_site_rec.org_id);
326: FETCH c_check_first_site INTO l_tmp;
327: IF c_check_first_site%NOTFOUND THEN
328: -- Debug info.
329: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'First site created in this org... '||
331: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id||' '||
332: 'org_id = '||p_cust_acct_site_rec.org_id,
333: p_prefix=>l_debug_prefix,

Line 334: p_msg_level=>fnd_log.level_statement);

330: hz_utility_v2pub.debug(p_message=>'First site created in this org... '||
331: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id||' '||
332: 'org_id = '||p_cust_acct_site_rec.org_id,
333: p_prefix=>l_debug_prefix,
334: p_msg_level=>fnd_log.level_statement);
335: END IF;
336:
337: OPEN c_check_profile(p_cust_acct_site_rec.cust_account_id);
338: FETCH c_check_profile INTO l_tmp;

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

339: CLOSE c_check_profile;
340:
341: IF l_tmp = 'Y' THEN
342: -- Debug info.
343: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
345: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id,
346: p_prefix=>l_debug_prefix,
347: p_msg_level=>fnd_log.level_statement);

Line 347: p_msg_level=>fnd_log.level_statement);

343: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
345: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id,
346: p_prefix=>l_debug_prefix,
347: p_msg_level=>fnd_log.level_statement);
348: END IF;
349:
350: BEGIN
351: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

361: x_msg_count => l_msg_count,
362: x_msg_data => l_msg_data);
363:
364: -- Debug info.
365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
367: 'l_return_status = '||l_return_status||' '||
368: 'l_msg_count = '||l_msg_count||' '||
369: 'l_msg_data = '||l_msg_data,

Line 371: p_msg_level=>fnd_log.level_statement);

367: 'l_return_status = '||l_return_status||' '||
368: 'l_msg_count = '||l_msg_count||' '||
369: 'l_msg_data = '||l_msg_data,
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_statement);
372: END IF;
373: EXCEPTION
374: WHEN OTHERS THEN
375: -- Debug info.

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

372: END IF;
373: EXCEPTION
374: WHEN OTHERS THEN
375: -- Debug info.
376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
377: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
378: p_prefix=>l_debug_prefix,
379: p_msg_level=>fnd_log.level_statement);
380: END IF;

Line 379: p_msg_level=>fnd_log.level_statement);

375: -- Debug info.
376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
377: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
378: p_prefix=>l_debug_prefix,
379: p_msg_level=>fnd_log.level_statement);
380: END IF;
381:
382: l_return_status := 'S';
383: END;

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

392: END IF;
393: CLOSE c_check_first_site;
394:
395: -- Debug info.
396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400: END IF;

Line 399: p_msg_level=>fnd_log.level_procedure);

395: -- Debug info.
396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400: END IF;
401:
402: -- Call table-handler.
403: HZ_CUST_ACCT_SITES_PKG.Insert_Row (

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

466:
467:
468:
469: -- Debug info.
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
472: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);

Line 474: p_msg_level=>fnd_log.level_procedure);

470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
472: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476:
477:
478: --if (p_cust_acct_site_rec.orig_system_reference is not null and l_party_rec.orig_system_reference<>fnd_api.g_miss_char )-for two tables has null osr.

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

525: END IF;
526: END IF;
527:
528: -- Debug info.
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;

Line 532: p_msg_level=>fnd_log.level_procedure);

528: -- Debug info.
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;
534:
535: END do_create_cust_acct_site;
536:

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

654:
655: BEGIN
656:
657: -- Debug info.
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;

Line 661: p_msg_level=>fnd_log.level_procedure);

657: -- Debug info.
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;
663:
664: -- Lock record.
665:

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

778:
779: END IF; -- End of account site status check
780: END IF;
781: -- Debug info.
782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
784: p_prefix=>l_debug_prefix,
785: p_msg_level=>fnd_log.level_procedure);
786: END IF;

Line 785: p_msg_level=>fnd_log.level_procedure);

781: -- Debug info.
782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
784: p_prefix=>l_debug_prefix,
785: p_msg_level=>fnd_log.level_procedure);
786: END IF;
787:
788: -- Call table-handler.
789: HZ_CUST_ACCT_SITES_PKG.Update_Row (

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

878: END IF;
879: END IF;
880:
881: -- Debug info.
882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
883: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: END IF;

Line 885: p_msg_level=>fnd_log.level_procedure);

881: -- Debug info.
882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
883: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: END IF;
887:
888: -- Debug info.
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

885: p_msg_level=>fnd_log.level_procedure);
886: END IF;
887:
888: -- Debug info.
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
891: p_prefix=>l_debug_prefix,
892: p_msg_level=>fnd_log.level_procedure);
893: END IF;

Line 892: p_msg_level=>fnd_log.level_procedure);

888: -- Debug info.
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
891: p_prefix=>l_debug_prefix,
892: p_msg_level=>fnd_log.level_procedure);
893: END IF;
894:
895: END do_update_cust_acct_site;
896:

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

968:
969: BEGIN
970:
971: -- Debug info.
972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
973: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (+)',
974: p_prefix=>l_debug_prefix,
975: p_msg_level=>fnd_log.level_procedure);
976: END IF;

Line 975: p_msg_level=>fnd_log.level_procedure);

971: -- Debug info.
972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
973: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (+)',
974: p_prefix=>l_debug_prefix,
975: p_msg_level=>fnd_log.level_procedure);
976: END IF;
977:
978: /* 3456489 Added for Shared Service Uptake */
979: IF (p_cust_site_use_rec.org_id is NULL or

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

1026: p_column_value => p_cust_site_use_rec.site_use_code,
1027: x_return_status => x_return_status );
1028:
1029: -- Debug info.
1030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1032: 'x_return_status = ' || x_return_status,
1033: p_prefix =>l_debug_prefix,
1034: p_msg_level=>fnd_log.level_statement);

Line 1034: p_msg_level=>fnd_log.level_statement);

1030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1032: 'x_return_status = ' || x_return_status,
1033: p_prefix =>l_debug_prefix,
1034: p_msg_level=>fnd_log.level_statement);
1035: END IF;
1036:
1037: -- site_use_code is not in a valid site_use_code in party level.
1038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

Line 1081: p_msg_level=>fnd_log.level_procedure);

1077: -- Debug info.
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083:
1084: -- Bug 2643624.
1085: -- The first active site usage for a combination of particular site and org

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

1257: X_ORG_ID => p_cust_site_use_rec.org_id -- Bug 3456489
1258: );
1259:
1260: -- Debug info.
1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1263: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);

Line 1265: p_msg_level=>fnd_log.level_procedure);

1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1263: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;
1267:
1268:
1269: if (p_cust_site_use_rec.orig_system_reference is not null and p_cust_site_use_rec.orig_system_reference <>fnd_api.g_miss_char ) then

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

1348:
1349: x_site_use_id := p_cust_site_use_rec.site_use_id;
1350:
1351: -- Debug info.
1352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1353: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',
1354: p_prefix=>l_debug_prefix,
1355: p_msg_level=>fnd_log.level_procedure);
1356: END IF;

Line 1355: p_msg_level=>fnd_log.level_procedure);

1351: -- Debug info.
1352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1353: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',
1354: p_prefix=>l_debug_prefix,
1355: p_msg_level=>fnd_log.level_procedure);
1356: END IF;
1357:
1358:
1359: END do_create_cust_site_use;

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

1431:
1432: BEGIN
1433:
1434: -- Debug info.
1435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1437: p_prefix=>l_debug_prefix,
1438: p_msg_level=>fnd_log.level_procedure);
1439: END IF;

Line 1438: p_msg_level=>fnd_log.level_procedure);

1434: -- Debug info.
1435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1437: p_prefix=>l_debug_prefix,
1438: p_msg_level=>fnd_log.level_procedure);
1439: END IF;
1440:
1441:
1442: /* Bug 3456489 Modified for Shared Services Uptake. */

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

1498: p_column_value => p_cust_site_use_rec.site_use_code,
1499: x_return_status => x_return_status );
1500:
1501: -- Debug info.
1502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1504: 'x_return_status = ' || x_return_status,
1505: p_prefix =>l_debug_prefix,
1506: p_msg_level=>fnd_log.level_statement);

Line 1506: p_msg_level=>fnd_log.level_statement);

1502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1504: 'x_return_status = ' || x_return_status,
1505: p_prefix =>l_debug_prefix,
1506: p_msg_level=>fnd_log.level_statement);
1507: END IF;
1508:
1509: -- site_use_code is not in a valid site_use_code in party level.
1510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1549: END IF;
1550: END IF;
1551:
1552: -- Debug info.
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;

Line 1556: p_msg_level=>fnd_log.level_procedure);

1552: -- Debug info.
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558: --Bug Fix:5036975
1559:
1560: if (p_cust_site_use_rec.orig_system is not null

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

1567: -- but we should not update existing osr, set it to null
1568: end if;
1569:
1570: -- Debug info.
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;

Line 1574: p_msg_level=>fnd_log.level_procedure);

1570: -- Debug info.
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;
1576:
1577:
1578: -- Bug 2643624.

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

1816: X_APPLICATION_ID => p_cust_site_use_rec.application_id
1817: );
1818:
1819: -- Debug info.
1820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1822: p_prefix=>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;

Line 1823: p_msg_level=>fnd_log.level_procedure);

1819: -- Debug info.
1820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1822: p_prefix=>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;
1825:
1826: -- If this is a active bill_to or ship_to or market,
1827: -- set the appropriate denormalized flag in hz_cust_acct_sites.

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

1885: END IF;
1886: END IF;
1887:
1888: -- Debug info.
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;

Line 1892: p_msg_level=>fnd_log.level_procedure);

1888: -- Debug info.
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;
1894:
1895: END do_update_cust_site_use;
1896:

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

1928:
1929: BEGIN
1930:
1931: -- Debug info.
1932: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_procedure);
1936: END IF;

Line 1935: p_msg_level=>fnd_log.level_procedure);

1931: -- Debug info.
1932: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_procedure);
1936: END IF;
1937:
1938:
1939: IF p_site_use_code = 'BILL_TO' THEN

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

1950: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1951: END IF;
1952:
1953: -- Debug info.
1954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1955: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
1956: p_prefix=>l_debug_prefix,
1957: p_msg_level=>fnd_log.level_procedure);
1958: END IF;

Line 1957: p_msg_level=>fnd_log.level_procedure);

1953: -- Debug info.
1954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1955: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
1956: p_prefix=>l_debug_prefix,
1957: p_msg_level=>fnd_log.level_procedure);
1958: END IF;
1959:
1960: END denormalize_site_use_flag;
1961:

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

2015: -- Check if API is called in debug mode. If yes, enable debug.
2016: --enable_debug;
2017:
2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;

Line 2022: p_msg_level=>fnd_log.level_procedure);

2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2070: p_count => x_msg_count,
2071: p_data => x_msg_data );
2072:
2073: -- Debug info.
2074: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2076: p_msg_data=>x_msg_data,
2077: p_msg_type=>'WARNING',
2078: p_msg_level=>fnd_log.level_exception);

Line 2078: p_msg_level=>fnd_log.level_exception);

2074: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2076: p_msg_data=>x_msg_data,
2077: p_msg_type=>'WARNING',
2078: p_msg_level=>fnd_log.level_exception);
2079: END IF;
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2082: p_prefix=>l_debug_prefix,

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

2076: p_msg_data=>x_msg_data,
2077: p_msg_type=>'WARNING',
2078: p_msg_level=>fnd_log.level_exception);
2079: END IF;
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: END IF;

Line 2083: p_msg_level=>fnd_log.level_procedure);

2079: END IF;
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: END IF;
2085:
2086: -- Check if API is called in debug mode. If yes, disable debug.
2087: --disable_debug;

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

2096: p_count => x_msg_count,
2097: p_data => x_msg_data );
2098:
2099: -- Debug info.
2100: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'ERROR',
2104: p_msg_level=>fnd_log.level_error);

Line 2104: p_msg_level=>fnd_log.level_error);

2100: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'ERROR',
2104: p_msg_level=>fnd_log.level_error);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2108: p_prefix=>l_debug_prefix,

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

2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'ERROR',
2104: p_msg_level=>fnd_log.level_error);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;

Line 2109: p_msg_level=>fnd_log.level_procedure);

2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.
2113: --disable_debug;

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

2121: p_count => x_msg_count,
2122: p_data => x_msg_data );
2123:
2124: -- Debug info.
2125: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2126: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2127: p_msg_data=>x_msg_data,
2128: p_msg_type=>'UNEXPECTED ERROR',
2129: p_msg_level=>fnd_log.level_error);

Line 2129: p_msg_level=>fnd_log.level_error);

2125: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2126: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2127: p_msg_data=>x_msg_data,
2128: p_msg_type=>'UNEXPECTED ERROR',
2129: p_msg_level=>fnd_log.level_error);
2130: END IF;
2131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2133: p_prefix=>l_debug_prefix,

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

2127: p_msg_data=>x_msg_data,
2128: p_msg_type=>'UNEXPECTED ERROR',
2129: p_msg_level=>fnd_log.level_error);
2130: END IF;
2131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2133: p_prefix=>l_debug_prefix,
2134: p_msg_level=>fnd_log.level_procedure);
2135: END IF;

Line 2134: p_msg_level=>fnd_log.level_procedure);

2130: END IF;
2131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2133: p_prefix=>l_debug_prefix,
2134: p_msg_level=>fnd_log.level_procedure);
2135: END IF;
2136:
2137: -- Check if API is called in debug mode. If yes, disable debug.
2138: --disable_debug;

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

2150: p_count => x_msg_count,
2151: p_data => x_msg_data );
2152:
2153: -- Debug info.
2154: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'SQL ERROR',
2158: p_msg_level=>fnd_log.level_error);

Line 2158: p_msg_level=>fnd_log.level_error);

2154: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'SQL ERROR',
2158: p_msg_level=>fnd_log.level_error);
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2162: p_prefix=>l_debug_prefix,

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

2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'SQL ERROR',
2158: p_msg_level=>fnd_log.level_error);
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2162: p_prefix=>l_debug_prefix,
2163: p_msg_level=>fnd_log.level_procedure);
2164: END IF;

Line 2163: p_msg_level=>fnd_log.level_procedure);

2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2162: p_prefix=>l_debug_prefix,
2163: p_msg_level=>fnd_log.level_procedure);
2164: END IF;
2165:
2166: -- Check if API is called in debug mode. If yes, disable debug.
2167: --disable_debug;

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

2221: -- Check if API is called in debug mode. If yes, enable debug.
2222: --enable_debug;
2223:
2224: -- Debug info.
2225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2226: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2227: p_prefix=>l_debug_prefix,
2228: p_msg_level=>fnd_log.level_procedure);
2229: END IF;

Line 2228: p_msg_level=>fnd_log.level_procedure);

2224: -- Debug info.
2225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2226: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2227: p_prefix=>l_debug_prefix,
2228: p_msg_level=>fnd_log.level_procedure);
2229: END IF;
2230:
2231: -- Initialize message list if p_init_msg_list is set to TRUE.
2232: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2309: p_count => x_msg_count,
2310: p_data => x_msg_data );
2311:
2312: -- Debug info.
2313: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2314: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2315: p_msg_data=>x_msg_data,
2316: p_msg_type=>'WARNING',
2317: p_msg_level=>fnd_log.level_exception);

Line 2317: p_msg_level=>fnd_log.level_exception);

2313: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2314: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2315: p_msg_data=>x_msg_data,
2316: p_msg_type=>'WARNING',
2317: p_msg_level=>fnd_log.level_exception);
2318: END IF;
2319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2320: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2321: p_prefix=>l_debug_prefix,

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

2315: p_msg_data=>x_msg_data,
2316: p_msg_type=>'WARNING',
2317: p_msg_level=>fnd_log.level_exception);
2318: END IF;
2319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2320: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2321: p_prefix=>l_debug_prefix,
2322: p_msg_level=>fnd_log.level_procedure);
2323: END IF;

Line 2322: p_msg_level=>fnd_log.level_procedure);

2318: END IF;
2319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2320: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2321: p_prefix=>l_debug_prefix,
2322: p_msg_level=>fnd_log.level_procedure);
2323: END IF;
2324:
2325: -- Check if API is called in debug mode. If yes, disable debug.
2326: --disable_debug;

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

2335: p_count => x_msg_count,
2336: p_data => x_msg_data );
2337:
2338: -- Debug info.
2339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2341: p_msg_data=>x_msg_data,
2342: p_msg_type=>'ERROR',
2343: p_msg_level=>fnd_log.level_error);

Line 2343: p_msg_level=>fnd_log.level_error);

2339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2341: p_msg_data=>x_msg_data,
2342: p_msg_type=>'ERROR',
2343: p_msg_level=>fnd_log.level_error);
2344: END IF;
2345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2346: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2347: p_prefix=>l_debug_prefix,

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

2341: p_msg_data=>x_msg_data,
2342: p_msg_type=>'ERROR',
2343: p_msg_level=>fnd_log.level_error);
2344: END IF;
2345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2346: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2347: p_prefix=>l_debug_prefix,
2348: p_msg_level=>fnd_log.level_procedure);
2349: END IF;

Line 2348: p_msg_level=>fnd_log.level_procedure);

2344: END IF;
2345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2346: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2347: p_prefix=>l_debug_prefix,
2348: p_msg_level=>fnd_log.level_procedure);
2349: END IF;
2350:
2351: -- Check if API is called in debug mode. If yes, disable debug.
2352: --disable_debug;

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

2360: p_count => x_msg_count,
2361: p_data => x_msg_data );
2362:
2363: -- Debug info.
2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'UNEXPECTED ERROR',
2368: p_msg_level=>fnd_log.level_error);

Line 2368: p_msg_level=>fnd_log.level_error);

2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'UNEXPECTED ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2372: p_prefix=>l_debug_prefix,

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

2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'UNEXPECTED ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;

Line 2373: p_msg_level=>fnd_log.level_procedure);

2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:
2376: -- Check if API is called in debug mode. If yes, disable debug.
2377: --disable_debug;

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

2389: p_count => x_msg_count,
2390: p_data => x_msg_data );
2391:
2392: -- Debug info.
2393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2395: p_msg_data=>x_msg_data,
2396: p_msg_type=>'SQL ERROR',
2397: p_msg_level=>fnd_log.level_error);

Line 2397: p_msg_level=>fnd_log.level_error);

2393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2395: p_msg_data=>x_msg_data,
2396: p_msg_type=>'SQL ERROR',
2397: p_msg_level=>fnd_log.level_error);
2398: END IF;
2399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2401: p_prefix=>l_debug_prefix,

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

2395: p_msg_data=>x_msg_data,
2396: p_msg_type=>'SQL ERROR',
2397: p_msg_level=>fnd_log.level_error);
2398: END IF;
2399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2401: p_prefix=>l_debug_prefix,
2402: p_msg_level=>fnd_log.level_procedure);
2403: END IF;

Line 2402: p_msg_level=>fnd_log.level_procedure);

2398: END IF;
2399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2401: p_prefix=>l_debug_prefix,
2402: p_msg_level=>fnd_log.level_procedure);
2403: END IF;
2404:
2405: -- Check if API is called in debug mode. If yes, disable debug.
2406: --disable_debug;

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

2453: -- Check if API is called in debug mode. If yes, enable debug.
2454: --enable_debug;
2455:
2456: -- Debug info.
2457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2458: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2459: p_prefix=>l_debug_prefix,
2460: p_msg_level=>fnd_log.level_procedure);
2461: END IF;

Line 2460: p_msg_level=>fnd_log.level_procedure);

2456: -- Debug info.
2457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2458: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2459: p_prefix=>l_debug_prefix,
2460: p_msg_level=>fnd_log.level_procedure);
2461: END IF;
2462:
2463: -- Initialize message list if p_init_msg_list is set to TRUE.
2464: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2479:
2480: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2481:
2482: -- Debug info.
2483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2484: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2485: p_prefix=>l_debug_prefix,
2486: p_msg_level=>fnd_log.level_procedure);
2487: END IF;

Line 2486: p_msg_level=>fnd_log.level_procedure);

2482: -- Debug info.
2483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2484: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2485: p_prefix=>l_debug_prefix,
2486: p_msg_level=>fnd_log.level_procedure);
2487: END IF;
2488:
2489: -- Call table-handler.
2490: HZ_CUST_ACCT_SITES_PKG.Select_Row (

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

2550: X_ORG_ID => x_cust_acct_site_rec.org_id -- Bug 3456489
2551: );
2552:
2553: -- Debug info.
2554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2556: p_prefix=>l_debug_prefix,
2557: p_msg_level=>fnd_log.level_procedure);
2558: END IF;

Line 2557: p_msg_level=>fnd_log.level_procedure);

2553: -- Debug info.
2554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2556: p_prefix=>l_debug_prefix,
2557: p_msg_level=>fnd_log.level_procedure);
2558: END IF;
2559:
2560: -- Standard call to get message count and if count is 1, get message info.
2561: FND_MSG_PUB.Count_And_Get(

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

2563: p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:
2566: -- Debug info.
2567: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'WARNING',
2571: p_msg_level=>fnd_log.level_exception);

Line 2571: p_msg_level=>fnd_log.level_exception);

2567: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'WARNING',
2571: p_msg_level=>fnd_log.level_exception);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2575: p_prefix=>l_debug_prefix,

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

2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'WARNING',
2571: p_msg_level=>fnd_log.level_exception);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;

Line 2576: p_msg_level=>fnd_log.level_procedure);

2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;
2578:
2579: -- Check if API is called in debug mode. If yes, disable debug.
2580: --disable_debug;

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

2588: p_count => x_msg_count,
2589: p_data => x_msg_data );
2590:
2591: -- Debug info.
2592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'ERROR',
2596: p_msg_level=>fnd_log.level_error);

Line 2596: p_msg_level=>fnd_log.level_error);

2592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'ERROR',
2596: p_msg_level=>fnd_log.level_error);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2600: p_prefix=>l_debug_prefix,

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

2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'ERROR',
2596: p_msg_level=>fnd_log.level_error);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;

Line 2601: p_msg_level=>fnd_log.level_procedure);

2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;
2603:
2604: -- Check if API is called in debug mode. If yes, disable debug.
2605: --disable_debug;

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

2612: p_count => x_msg_count,
2613: p_data => x_msg_data );
2614:
2615: -- Debug info.
2616: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2617: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2618: p_msg_data=>x_msg_data,
2619: p_msg_type=>'UNEXPECTED ERROR',
2620: p_msg_level=>fnd_log.level_error);

Line 2620: p_msg_level=>fnd_log.level_error);

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

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

2618: p_msg_data=>x_msg_data,
2619: p_msg_type=>'UNEXPECTED ERROR',
2620: p_msg_level=>fnd_log.level_error);
2621: END IF;
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;

Line 2625: p_msg_level=>fnd_log.level_procedure);

2621: END IF;
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:
2628: -- Check if API is called in debug mode. If yes, disable debug.
2629: --disable_debug;

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

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

Line 2648: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2653: p_msg_level=>fnd_log.level_procedure);

2649: END IF;
2650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2651: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2652: p_prefix=>l_debug_prefix,
2653: p_msg_level=>fnd_log.level_procedure);
2654: END IF;
2655:
2656: -- Check if API is called in debug mode. If yes, disable debug.
2657: --disable_debug;

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

2722: -- Check if API is called in debug mode. If yes, enable debug.
2723: --enable_debug;
2724:
2725: -- Debug info.
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;

Line 2729: p_msg_level=>fnd_log.level_procedure);

2725: -- Debug info.
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731:
2732: -- Initialize message list if p_init_msg_list is set to TRUE.
2733: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2769: p_count => x_msg_count,
2770: p_data => x_msg_data );
2771:
2772: -- Debug info.
2773: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'WARNING',
2777: p_msg_level=>fnd_log.level_exception);

Line 2777: p_msg_level=>fnd_log.level_exception);

2773: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'WARNING',
2777: p_msg_level=>fnd_log.level_exception);
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2781: p_prefix=>l_debug_prefix,

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

2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'WARNING',
2777: p_msg_level=>fnd_log.level_exception);
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2781: p_prefix=>l_debug_prefix,
2782: p_msg_level=>fnd_log.level_procedure);
2783: END IF;

Line 2782: p_msg_level=>fnd_log.level_procedure);

2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2781: p_prefix=>l_debug_prefix,
2782: p_msg_level=>fnd_log.level_procedure);
2783: END IF;
2784: -- Check if API is called in debug mode. If yes, disable debug.
2785: --disable_debug;
2786:

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

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

Line 2802: p_msg_level=>fnd_log.level_error);

2798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2800: p_msg_data=>x_msg_data,
2801: p_msg_type=>'ERROR',
2802: p_msg_level=>fnd_log.level_error);
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_site_use (-)',
2806: p_prefix=>l_debug_prefix,

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

2800: p_msg_data=>x_msg_data,
2801: p_msg_type=>'ERROR',
2802: p_msg_level=>fnd_log.level_error);
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_site_use (-)',
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_site_use (-)',
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 2823: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2819: p_count => x_msg_count,
2820: p_data => x_msg_data );
2821:
2822: -- Debug info.
2823: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2824: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2825: p_msg_data=>x_msg_data,
2826: p_msg_type=>'UNEXPECTED ERROR',
2827: p_msg_level=>fnd_log.level_error);

Line 2827: p_msg_level=>fnd_log.level_error);

2823: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2824: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2825: p_msg_data=>x_msg_data,
2826: p_msg_type=>'UNEXPECTED ERROR',
2827: p_msg_level=>fnd_log.level_error);
2828: END IF;
2829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2830: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2831: p_prefix=>l_debug_prefix,

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

2825: p_msg_data=>x_msg_data,
2826: p_msg_type=>'UNEXPECTED ERROR',
2827: p_msg_level=>fnd_log.level_error);
2828: END IF;
2829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2830: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2831: p_prefix=>l_debug_prefix,
2832: p_msg_level=>fnd_log.level_procedure);
2833: END IF;

Line 2832: p_msg_level=>fnd_log.level_procedure);

2828: END IF;
2829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2830: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2831: p_prefix=>l_debug_prefix,
2832: p_msg_level=>fnd_log.level_procedure);
2833: END IF;
2834:
2835: -- Check if API is called in debug mode. If yes, disable debug.
2836: --disable_debug;

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

2848: p_count => x_msg_count,
2849: p_data => x_msg_data );
2850:
2851: -- Debug info.
2852: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2853: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2854: p_msg_data=>x_msg_data,
2855: p_msg_type=>'SQL ERROR',
2856: p_msg_level=>fnd_log.level_error);

Line 2856: p_msg_level=>fnd_log.level_error);

2852: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2853: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2854: p_msg_data=>x_msg_data,
2855: p_msg_type=>'SQL ERROR',
2856: p_msg_level=>fnd_log.level_error);
2857: END IF;
2858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2859: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2860: p_prefix=>l_debug_prefix,

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

2854: p_msg_data=>x_msg_data,
2855: p_msg_type=>'SQL ERROR',
2856: p_msg_level=>fnd_log.level_error);
2857: END IF;
2858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2859: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2860: p_prefix=>l_debug_prefix,
2861: p_msg_level=>fnd_log.level_procedure);
2862: END IF;

Line 2861: p_msg_level=>fnd_log.level_procedure);

2857: END IF;
2858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2859: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2860: p_prefix=>l_debug_prefix,
2861: p_msg_level=>fnd_log.level_procedure);
2862: END IF;
2863:
2864: -- Check if API is called in debug mode. If yes, disable debug.
2865: --disable_debug;

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

2920: -- Check if API is called in debug mode. If yes, enable debug.
2921: --enable_debug;
2922:
2923: -- Debug info.
2924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2925: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',
2926: p_prefix=>l_debug_prefix,
2927: p_msg_level=>fnd_log.level_procedure);
2928: END IF;

Line 2927: p_msg_level=>fnd_log.level_procedure);

2923: -- Debug info.
2924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2925: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',
2926: p_prefix=>l_debug_prefix,
2927: p_msg_level=>fnd_log.level_procedure);
2928: END IF;
2929:
2930: -- Initialize message list if p_init_msg_list is set to TRUE.
2931: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2993: p_count => x_msg_count,
2994: p_data => x_msg_data );
2995:
2996: -- Debug info.
2997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2999: p_msg_data=>x_msg_data,
3000: p_msg_type=>'WARNING',
3001: p_msg_level=>fnd_log.level_exception);

Line 3001: p_msg_level=>fnd_log.level_exception);

2997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2999: p_msg_data=>x_msg_data,
3000: p_msg_type=>'WARNING',
3001: p_msg_level=>fnd_log.level_exception);
3002: END IF;
3003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3004: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3005: p_prefix=>l_debug_prefix,

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

2999: p_msg_data=>x_msg_data,
3000: p_msg_type=>'WARNING',
3001: p_msg_level=>fnd_log.level_exception);
3002: END IF;
3003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3004: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3005: p_prefix=>l_debug_prefix,
3006: p_msg_level=>fnd_log.level_procedure);
3007: END IF;

Line 3006: p_msg_level=>fnd_log.level_procedure);

3002: END IF;
3003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3004: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3005: p_prefix=>l_debug_prefix,
3006: p_msg_level=>fnd_log.level_procedure);
3007: END IF;
3008:
3009: -- Check if API is called in debug mode. If yes, disable debug.
3010: --disable_debug;

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

3019: p_count => x_msg_count,
3020: p_data => x_msg_data );
3021:
3022: -- Debug info.
3023: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3025: p_msg_data=>x_msg_data,
3026: p_msg_type=>'ERROR',
3027: p_msg_level=>fnd_log.level_error);

Line 3027: p_msg_level=>fnd_log.level_error);

3023: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3025: p_msg_data=>x_msg_data,
3026: p_msg_type=>'ERROR',
3027: p_msg_level=>fnd_log.level_error);
3028: END IF;
3029: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3030: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3031: p_prefix=>l_debug_prefix,

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

3025: p_msg_data=>x_msg_data,
3026: p_msg_type=>'ERROR',
3027: p_msg_level=>fnd_log.level_error);
3028: END IF;
3029: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3030: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3031: p_prefix=>l_debug_prefix,
3032: p_msg_level=>fnd_log.level_procedure);
3033: END IF;

Line 3032: p_msg_level=>fnd_log.level_procedure);

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

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

3044: p_count => x_msg_count,
3045: p_data => x_msg_data );
3046:
3047: -- Debug info.
3048: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'UNEXPECTED ERROR',
3052: p_msg_level=>fnd_log.level_error);

Line 3052: p_msg_level=>fnd_log.level_error);

3048: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'UNEXPECTED ERROR',
3052: p_msg_level=>fnd_log.level_error);
3053: END IF;
3054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3055: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3056: p_prefix=>l_debug_prefix,

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

3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'UNEXPECTED ERROR',
3052: p_msg_level=>fnd_log.level_error);
3053: END IF;
3054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3055: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3056: p_prefix=>l_debug_prefix,
3057: p_msg_level=>fnd_log.level_procedure);
3058: END IF;

Line 3057: p_msg_level=>fnd_log.level_procedure);

3053: END IF;
3054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3055: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3056: p_prefix=>l_debug_prefix,
3057: p_msg_level=>fnd_log.level_procedure);
3058: END IF;
3059:
3060: -- Check if API is called in debug mode. If yes, disable debug.
3061: --disable_debug;

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

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

Line 3081: p_msg_level=>fnd_log.level_error);

3077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'SQL ERROR',
3081: p_msg_level=>fnd_log.level_error);
3082: END IF;
3083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3085: p_prefix=>l_debug_prefix,

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

3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'SQL ERROR',
3081: p_msg_level=>fnd_log.level_error);
3082: END IF;
3083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3085: p_prefix=>l_debug_prefix,
3086: p_msg_level=>fnd_log.level_procedure);
3087: END IF;

Line 3086: p_msg_level=>fnd_log.level_procedure);

3082: END IF;
3083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3085: p_prefix=>l_debug_prefix,
3086: p_msg_level=>fnd_log.level_procedure);
3087: END IF;
3088:
3089: -- Check if API is called in debug mode. If yes, disable debug.
3090: --disable_debug;

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

3142: -- Check if API is called in debug mode. If yes, enable debug.
3143: --enable_debug;
3144:
3145: -- Debug info.
3146: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3147: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (+)',
3148: p_prefix=>l_debug_prefix,
3149: p_msg_level=>fnd_log.level_procedure);
3150: END IF;

Line 3149: p_msg_level=>fnd_log.level_procedure);

3145: -- Debug info.
3146: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3147: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (+)',
3148: p_prefix=>l_debug_prefix,
3149: p_msg_level=>fnd_log.level_procedure);
3150: END IF;
3151:
3152: -- Initialize message list if p_init_msg_list is set to TRUE.
3153: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3168:
3169: x_cust_site_use_rec.site_use_id := p_site_use_id;
3170:
3171: -- Debug info.
3172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3173: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3174: p_prefix=>l_debug_prefix,
3175: p_msg_level=>fnd_log.level_procedure);
3176: END IF;

Line 3175: p_msg_level=>fnd_log.level_procedure);

3171: -- Debug info.
3172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3173: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3174: p_prefix=>l_debug_prefix,
3175: p_msg_level=>fnd_log.level_procedure);
3176: END IF;
3177:
3178: -- Call table-handler.
3179: HZ_CUST_SITE_USES_PKG.Select_Row (

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

3280: X_ORG_ID => x_cust_site_use_rec.org_id -- Bug 3456489
3281: );
3282:
3283: -- Debug info.
3284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3285: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3286: p_prefix=>l_debug_prefix,
3287: p_msg_level=>fnd_log.level_procedure);
3288: END IF;

Line 3287: p_msg_level=>fnd_log.level_procedure);

3283: -- Debug info.
3284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3285: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3286: p_prefix=>l_debug_prefix,
3287: p_msg_level=>fnd_log.level_procedure);
3288: END IF;
3289:
3290: BEGIN
3291: -- Fetch customer profile id.

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

3318: p_count => x_msg_count,
3319: p_data => x_msg_data );
3320:
3321: -- Debug info.
3322: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3323: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3324: p_msg_data=>x_msg_data,
3325: p_msg_type=>'WARNING',
3326: p_msg_level=>fnd_log.level_exception);

Line 3326: p_msg_level=>fnd_log.level_exception);

3322: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3323: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3324: p_msg_data=>x_msg_data,
3325: p_msg_type=>'WARNING',
3326: p_msg_level=>fnd_log.level_exception);
3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3330: p_prefix=>l_debug_prefix,

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

3324: p_msg_data=>x_msg_data,
3325: p_msg_type=>'WARNING',
3326: p_msg_level=>fnd_log.level_exception);
3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3330: p_prefix=>l_debug_prefix,
3331: p_msg_level=>fnd_log.level_procedure);
3332: END IF;

Line 3331: p_msg_level=>fnd_log.level_procedure);

3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3330: p_prefix=>l_debug_prefix,
3331: p_msg_level=>fnd_log.level_procedure);
3332: END IF;
3333:
3334: -- Check if API is called in debug mode. If yes, disable debug.
3335: --disable_debug;

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

3343: p_count => x_msg_count,
3344: p_data => x_msg_data );
3345:
3346: -- Debug info.
3347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3349: p_msg_data=>x_msg_data,
3350: p_msg_type=>'ERROR',
3351: p_msg_level=>fnd_log.level_error);

Line 3351: p_msg_level=>fnd_log.level_error);

3347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3349: p_msg_data=>x_msg_data,
3350: p_msg_type=>'ERROR',
3351: p_msg_level=>fnd_log.level_error);
3352: END IF;
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3355: p_prefix=>l_debug_prefix,

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

3349: p_msg_data=>x_msg_data,
3350: p_msg_type=>'ERROR',
3351: p_msg_level=>fnd_log.level_error);
3352: END IF;
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;

Line 3356: p_msg_level=>fnd_log.level_procedure);

3352: END IF;
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3358:
3359: -- Check if API is called in debug mode. If yes, disable debug.
3360: --disable_debug;

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

3367: p_count => x_msg_count,
3368: p_data => x_msg_data );
3369:
3370: -- Debug info.
3371: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3373: p_msg_data=>x_msg_data,
3374: p_msg_type=>'UNEXPECTED ERROR',
3375: p_msg_level=>fnd_log.level_error);

Line 3375: p_msg_level=>fnd_log.level_error);

3371: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3373: p_msg_data=>x_msg_data,
3374: p_msg_type=>'UNEXPECTED ERROR',
3375: p_msg_level=>fnd_log.level_error);
3376: END IF;
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3379: p_prefix=>l_debug_prefix,

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

3373: p_msg_data=>x_msg_data,
3374: p_msg_type=>'UNEXPECTED ERROR',
3375: p_msg_level=>fnd_log.level_error);
3376: END IF;
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3379: p_prefix=>l_debug_prefix,
3380: p_msg_level=>fnd_log.level_procedure);
3381: END IF;

Line 3380: p_msg_level=>fnd_log.level_procedure);

3376: END IF;
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3379: p_prefix=>l_debug_prefix,
3380: p_msg_level=>fnd_log.level_procedure);
3381: END IF;
3382:
3383: -- Check if API is called in debug mode. If yes, disable debug.
3384: --disable_debug;

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

3395: p_count => x_msg_count,
3396: p_data => x_msg_data );
3397:
3398: -- Debug info.
3399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3400: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3401: p_msg_data=>x_msg_data,
3402: p_msg_type=>'SQL ERROR',
3403: p_msg_level=>fnd_log.level_error);

Line 3403: p_msg_level=>fnd_log.level_error);

3399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3400: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3401: p_msg_data=>x_msg_data,
3402: p_msg_type=>'SQL ERROR',
3403: p_msg_level=>fnd_log.level_error);
3404: END IF;
3405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3407: p_prefix=>l_debug_prefix,

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

3401: p_msg_data=>x_msg_data,
3402: p_msg_type=>'SQL ERROR',
3403: p_msg_level=>fnd_log.level_error);
3404: END IF;
3405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3407: p_prefix=>l_debug_prefix,
3408: p_msg_level=>fnd_log.level_procedure);
3409: END IF;

Line 3408: p_msg_level=>fnd_log.level_procedure);

3404: END IF;
3405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3407: p_prefix=>l_debug_prefix,
3408: p_msg_level=>fnd_log.level_procedure);
3409: END IF;
3410:
3411: -- Check if API is called in debug mode. If yes, disable debug.
3412: --disable_debug;