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: --Bug14059649
382: --We should remove the code where they are suppressing the error being raise
383: --by OM code. TCA team should always pass on the error message back to the user

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

403: END IF;
404: CLOSE c_check_first_site;
405:
406: -- Debug info.
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;

Line 410: p_msg_level=>fnd_log.level_procedure);

406: -- Debug info.
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;
412:
413: -- Call table-handler.
414: HZ_CUST_ACCT_SITES_PKG.Insert_Row (

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

477:
478:
479:
480: -- Debug info.
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
483: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);

Line 485: p_msg_level=>fnd_log.level_procedure);

481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
483: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;
487:
488:
489: --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 540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

536: END IF;
537: END IF;
538:
539: -- Debug info.
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;

Line 543: p_msg_level=>fnd_log.level_procedure);

539: -- Debug info.
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545:
546: END do_create_cust_acct_site;
547:

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

613: --In exceptional case bad data (multiple) records might created by system
614: --To handle such scenario making all existing Primary records to non-primary
615: WHEN TOO_MANY_ROWS THEN
616: -- Debug info.
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'do_unset_prim_cust_site_use - TOO_MANY_ROWS Exception',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;

Line 620: p_msg_level=>fnd_log.level_procedure);

616: -- Debug info.
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'do_unset_prim_cust_site_use - TOO_MANY_ROWS Exception',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Mulitiple rows found for Cust Acct Id '||l_cust_acct_id||' and Site Use Code '||p_site_use_code,

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

619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Mulitiple rows found for Cust Acct Id '||l_cust_acct_id||' and Site Use Code '||p_site_use_code,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;

Line 626: p_msg_level=>fnd_log.level_procedure);

622:
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Mulitiple rows found for Cust Acct Id '||l_cust_acct_id||' and Site Use Code '||p_site_use_code,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;
628:
629:
630:

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

631: OPEN c_site(l_cust_acct_id);
632: LOOP
633: FETCH c_site INTO r_site;
634:
635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Site Use Id '||r_site.site_use_id,
637: p_prefix=>l_debug_prefix,
638: p_msg_level=>fnd_log.level_procedure);
639: END IF;

Line 638: p_msg_level=>fnd_log.level_procedure);

634:
635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Site Use Id '||r_site.site_use_id,
637: p_prefix=>l_debug_prefix,
638: p_msg_level=>fnd_log.level_procedure);
639: END IF;
640:
641:
642: UPDATE hz_cust_site_uses_all -- Bug 3456489

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

645: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
646: WHERE site_use_id =r_site.site_use_id;
647:
648: denormalize_site_use_flag(r_site.cust_acct_site_id,p_site_use_code,'Y');
649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
650: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Denormalization done for Acct Site Id '||r_site.cust_acct_site_id||' and Site use Code '||p_site_use_code,
651: p_prefix=>l_debug_prefix,
652: p_msg_level=>fnd_log.level_procedure);
653: END IF;

Line 652: p_msg_level=>fnd_log.level_procedure);

648: denormalize_site_use_flag(r_site.cust_acct_site_id,p_site_use_code,'Y');
649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
650: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Denormalization done for Acct Site Id '||r_site.cust_acct_site_id||' and Site use Code '||p_site_use_code,
651: p_prefix=>l_debug_prefix,
652: p_msg_level=>fnd_log.level_procedure);
653: END IF;
654: EXIT WHEN c_site%NOTFOUND;
655: END LOOP;
656: CLOSE c_site;

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

733:
734: BEGIN
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;

Line 740: p_msg_level=>fnd_log.level_procedure);

736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;
742:
743: -- Lock record.
744:

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

857:
858: END IF; -- End of account site status check
859: END IF;
860: -- Debug info.
861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
863: p_prefix=>l_debug_prefix,
864: p_msg_level=>fnd_log.level_procedure);
865: END IF;

Line 864: p_msg_level=>fnd_log.level_procedure);

860: -- Debug info.
861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
863: p_prefix=>l_debug_prefix,
864: p_msg_level=>fnd_log.level_procedure);
865: END IF;
866:
867: --Bug10332578
868: --X_STATUS is set back to Acct Site Status to handle bad data issues.

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

960: END IF;
961: END IF;
962:
963: -- Debug info.
964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
966: p_prefix=>l_debug_prefix,
967: p_msg_level=>fnd_log.level_procedure);
968: END IF;

Line 967: p_msg_level=>fnd_log.level_procedure);

963: -- Debug info.
964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
966: p_prefix=>l_debug_prefix,
967: p_msg_level=>fnd_log.level_procedure);
968: END IF;
969:
970: -- Debug info.
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 974: p_msg_level=>fnd_log.level_procedure);

970: -- Debug info.
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
973: p_prefix=>l_debug_prefix,
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;
976:
977: END do_update_cust_acct_site;
978:

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

1060: l_cust_acct_prof_id HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_PROFILE_ID%TYPE ;
1061: BEGIN
1062:
1063: -- Debug info.
1064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (+)',
1066: p_prefix=>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_procedure);
1068: END IF;

Line 1067: p_msg_level=>fnd_log.level_procedure);

1063: -- Debug info.
1064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (+)',
1066: p_prefix=>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_procedure);
1068: END IF;
1069:
1070: /* 3456489 Added for Shared Service Uptake */
1071: IF (p_cust_site_use_rec.org_id is NULL or

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

1118: p_column_value => p_cust_site_use_rec.site_use_code,
1119: x_return_status => x_return_status );
1120:
1121: -- Debug info.
1122: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1124: 'x_return_status = ' || x_return_status,
1125: p_prefix =>l_debug_prefix,
1126: p_msg_level=>fnd_log.level_statement);

Line 1126: p_msg_level=>fnd_log.level_statement);

1122: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1124: 'x_return_status = ' || x_return_status,
1125: p_prefix =>l_debug_prefix,
1126: p_msg_level=>fnd_log.level_statement);
1127: END IF;
1128:
1129: -- site_use_code is not in a valid site_use_code in party level.
1130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1166: END;
1167: END IF;
1168:
1169: -- Debug info.
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;

Line 1173: p_msg_level=>fnd_log.level_procedure);

1169: -- Debug info.
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;
1175:
1176: -- Bug 2643624.
1177: -- The first active site usage for a combination of particular site and org

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

1349: X_ORG_ID => p_cust_site_use_rec.org_id -- Bug 3456489
1350: );
1351:
1352: -- Debug info.
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1355: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);

Line 1357: p_msg_level=>fnd_log.level_procedure);

1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1355: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;
1359:
1360: /*Bug 8970479 :
1361: Updating tables hz_customer_profiles and hz_cust_profile_amts if bill-to business

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

1377: SET site_use_id = p_cust_site_use_rec.site_use_id
1378: WHERE cust_account_profile_id = l_cust_account_profile_id ;
1379:
1380: -- Debug info.
1381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'Updated hz_customer_profiles and hz_cust_profiles/amts with site_use_id of DUNNING or STATEMENTS' ,
1383: p_prefix =>l_debug_prefix,
1384: p_msg_level=>fnd_log.level_statement);
1385: END IF;

Line 1384: p_msg_level=>fnd_log.level_statement);

1380: -- Debug info.
1381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'Updated hz_customer_profiles and hz_cust_profiles/amts with site_use_id of DUNNING or STATEMENTS' ,
1383: p_prefix =>l_debug_prefix,
1384: p_msg_level=>fnd_log.level_statement);
1385: END IF;
1386: -- Debug info.
1387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,

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

1383: p_prefix =>l_debug_prefix,
1384: p_msg_level=>fnd_log.level_statement);
1385: END IF;
1386: -- Debug info.
1387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,
1389: p_prefix =>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_statement);
1391: END IF;

Line 1390: p_msg_level=>fnd_log.level_statement);

1386: -- Debug info.
1387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,
1389: p_prefix =>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_statement);
1391: END IF;
1392:
1393: END IF;
1394: CLOSE c_check_site_use_id ;

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

1479:
1480: x_site_use_id := p_cust_site_use_rec.site_use_id;
1481:
1482: -- Debug info.
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;

Line 1486: p_msg_level=>fnd_log.level_procedure);

1482: -- Debug info.
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;
1488:
1489:
1490: END do_create_cust_site_use;

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

1562:
1563: BEGIN
1564:
1565: -- Debug info.
1566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1567: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1568: p_prefix=>l_debug_prefix,
1569: p_msg_level=>fnd_log.level_procedure);
1570: END IF;

Line 1569: p_msg_level=>fnd_log.level_procedure);

1565: -- Debug info.
1566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1567: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1568: p_prefix=>l_debug_prefix,
1569: p_msg_level=>fnd_log.level_procedure);
1570: END IF;
1571:
1572:
1573: /* Bug 3456489 Modified for Shared Services Uptake. */

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

1629: p_column_value => p_cust_site_use_rec.site_use_code,
1630: x_return_status => x_return_status );
1631:
1632: -- Debug info.
1633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1634: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1635: 'x_return_status = ' || x_return_status,
1636: p_prefix =>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_statement);

Line 1637: p_msg_level=>fnd_log.level_statement);

1633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1634: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1635: 'x_return_status = ' || x_return_status,
1636: p_prefix =>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_statement);
1638: END IF;
1639:
1640: -- site_use_code is not in a valid site_use_code in party level.
1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1680: END IF;
1681: END IF;
1682:
1683: -- Debug info.
1684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1686: p_prefix=>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_procedure);
1688: END IF;

Line 1687: p_msg_level=>fnd_log.level_procedure);

1683: -- Debug info.
1684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1686: p_prefix=>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_procedure);
1688: END IF;
1689: --Bug Fix:5036975
1690:
1691: if (p_cust_site_use_rec.orig_system is not null

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

1698: -- but we should not update existing osr, set it to null
1699: end if;
1700:
1701: -- Debug info.
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;

Line 1705: p_msg_level=>fnd_log.level_procedure);

1701: -- Debug info.
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;
1707:
1708:
1709: -- Bug 2643624.

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

1949: X_APPLICATION_ID => p_cust_site_use_rec.application_id
1950: );
1951:
1952: -- Debug info.
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;

Line 1956: p_msg_level=>fnd_log.level_procedure);

1952: -- Debug info.
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:
1959: -- If this is a active bill_to or ship_to or market,
1960: -- set the appropriate denormalized flag in hz_cust_acct_sites.

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

2018: END IF;
2019: END IF;
2020:
2021: -- Debug info.
2022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2023: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
2024: p_prefix=>l_debug_prefix,
2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;

Line 2025: p_msg_level=>fnd_log.level_procedure);

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

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

2061:
2062: BEGIN
2063:
2064: -- Debug info.
2065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2066: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
2067: p_prefix=>l_debug_prefix,
2068: p_msg_level=>fnd_log.level_procedure);
2069: END IF;

Line 2068: p_msg_level=>fnd_log.level_procedure);

2064: -- Debug info.
2065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2066: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
2067: p_prefix=>l_debug_prefix,
2068: p_msg_level=>fnd_log.level_procedure);
2069: END IF;
2070:
2071:
2072: IF p_site_use_code = 'BILL_TO' THEN

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

2089: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2090: END IF;
2091:
2092: -- Debug info.
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
2095: p_prefix=>l_debug_prefix,
2096: p_msg_level=>fnd_log.level_procedure);
2097: END IF;

Line 2096: p_msg_level=>fnd_log.level_procedure);

2092: -- Debug info.
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
2095: p_prefix=>l_debug_prefix,
2096: p_msg_level=>fnd_log.level_procedure);
2097: END IF;
2098:
2099: END denormalize_site_use_flag;
2100:

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

2154: -- Check if API is called in debug mode. If yes, enable debug.
2155: --enable_debug;
2156:
2157: -- Debug info.
2158: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2159: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2160: p_prefix=>l_debug_prefix,
2161: p_msg_level=>fnd_log.level_procedure);
2162: END IF;

Line 2161: p_msg_level=>fnd_log.level_procedure);

2157: -- Debug info.
2158: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2159: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2160: p_prefix=>l_debug_prefix,
2161: p_msg_level=>fnd_log.level_procedure);
2162: END IF;
2163:
2164: -- Initialize message list if p_init_msg_list is set to TRUE.
2165: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2209: p_count => x_msg_count,
2210: p_data => x_msg_data );
2211:
2212: -- Debug info.
2213: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2215: p_msg_data=>x_msg_data,
2216: p_msg_type=>'WARNING',
2217: p_msg_level=>fnd_log.level_exception);

Line 2217: p_msg_level=>fnd_log.level_exception);

2213: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2215: p_msg_data=>x_msg_data,
2216: p_msg_type=>'WARNING',
2217: p_msg_level=>fnd_log.level_exception);
2218: END IF;
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2221: p_prefix=>l_debug_prefix,

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

2215: p_msg_data=>x_msg_data,
2216: p_msg_type=>'WARNING',
2217: p_msg_level=>fnd_log.level_exception);
2218: END IF;
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;

Line 2222: p_msg_level=>fnd_log.level_procedure);

2218: END IF;
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;
2224:
2225: -- Check if API is called in debug mode. If yes, disable debug.
2226: --disable_debug;

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

2235: p_count => x_msg_count,
2236: p_data => x_msg_data );
2237:
2238: -- Debug info.
2239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2241: p_msg_data=>x_msg_data,
2242: p_msg_type=>'ERROR',
2243: p_msg_level=>fnd_log.level_error);

Line 2243: p_msg_level=>fnd_log.level_error);

2239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2241: p_msg_data=>x_msg_data,
2242: p_msg_type=>'ERROR',
2243: p_msg_level=>fnd_log.level_error);
2244: END IF;
2245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2246: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2247: p_prefix=>l_debug_prefix,

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

2241: p_msg_data=>x_msg_data,
2242: p_msg_type=>'ERROR',
2243: p_msg_level=>fnd_log.level_error);
2244: END IF;
2245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2246: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2247: p_prefix=>l_debug_prefix,
2248: p_msg_level=>fnd_log.level_procedure);
2249: END IF;

Line 2248: p_msg_level=>fnd_log.level_procedure);

2244: END IF;
2245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2246: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2247: p_prefix=>l_debug_prefix,
2248: p_msg_level=>fnd_log.level_procedure);
2249: END IF;
2250:
2251: -- Check if API is called in debug mode. If yes, disable debug.
2252: --disable_debug;

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

2260: p_count => x_msg_count,
2261: p_data => x_msg_data );
2262:
2263: -- Debug info.
2264: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2265: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2266: p_msg_data=>x_msg_data,
2267: p_msg_type=>'UNEXPECTED ERROR',
2268: p_msg_level=>fnd_log.level_error);

Line 2268: p_msg_level=>fnd_log.level_error);

2264: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2265: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2266: p_msg_data=>x_msg_data,
2267: p_msg_type=>'UNEXPECTED ERROR',
2268: p_msg_level=>fnd_log.level_error);
2269: END IF;
2270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2271: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2272: p_prefix=>l_debug_prefix,

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

2266: p_msg_data=>x_msg_data,
2267: p_msg_type=>'UNEXPECTED ERROR',
2268: p_msg_level=>fnd_log.level_error);
2269: END IF;
2270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2271: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2272: p_prefix=>l_debug_prefix,
2273: p_msg_level=>fnd_log.level_procedure);
2274: END IF;

Line 2273: p_msg_level=>fnd_log.level_procedure);

2269: END IF;
2270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2271: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2272: p_prefix=>l_debug_prefix,
2273: p_msg_level=>fnd_log.level_procedure);
2274: END IF;
2275:
2276: -- Check if API is called in debug mode. If yes, disable debug.
2277: --disable_debug;

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

2289: p_count => x_msg_count,
2290: p_data => x_msg_data );
2291:
2292: -- Debug info.
2293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'SQL ERROR',
2297: p_msg_level=>fnd_log.level_error);

Line 2297: p_msg_level=>fnd_log.level_error);

2293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'SQL ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2301: p_prefix=>l_debug_prefix,

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

2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'SQL ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;

Line 2302: p_msg_level=>fnd_log.level_procedure);

2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;
2304:
2305: -- Check if API is called in debug mode. If yes, disable debug.
2306: --disable_debug;

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

2360: -- Check if API is called in debug mode. If yes, enable debug.
2361: --enable_debug;
2362:
2363: -- Debug info.
2364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2366: p_prefix=>l_debug_prefix,
2367: p_msg_level=>fnd_log.level_procedure);
2368: END IF;

Line 2367: p_msg_level=>fnd_log.level_procedure);

2363: -- Debug info.
2364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2366: p_prefix=>l_debug_prefix,
2367: p_msg_level=>fnd_log.level_procedure);
2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2448: p_count => x_msg_count,
2449: p_data => x_msg_data );
2450:
2451: -- Debug info.
2452: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2454: p_msg_data=>x_msg_data,
2455: p_msg_type=>'WARNING',
2456: p_msg_level=>fnd_log.level_exception);

Line 2456: p_msg_level=>fnd_log.level_exception);

2452: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2454: p_msg_data=>x_msg_data,
2455: p_msg_type=>'WARNING',
2456: p_msg_level=>fnd_log.level_exception);
2457: END IF;
2458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2459: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2460: p_prefix=>l_debug_prefix,

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

2454: p_msg_data=>x_msg_data,
2455: p_msg_type=>'WARNING',
2456: p_msg_level=>fnd_log.level_exception);
2457: END IF;
2458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2459: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2460: p_prefix=>l_debug_prefix,
2461: p_msg_level=>fnd_log.level_procedure);
2462: END IF;

Line 2461: p_msg_level=>fnd_log.level_procedure);

2457: END IF;
2458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2459: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2460: p_prefix=>l_debug_prefix,
2461: p_msg_level=>fnd_log.level_procedure);
2462: END IF;
2463:
2464: -- Check if API is called in debug mode. If yes, disable debug.
2465: --disable_debug;

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

2474: p_count => x_msg_count,
2475: p_data => x_msg_data );
2476:
2477: -- Debug info.
2478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2480: p_msg_data=>x_msg_data,
2481: p_msg_type=>'ERROR',
2482: p_msg_level=>fnd_log.level_error);

Line 2482: p_msg_level=>fnd_log.level_error);

2478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2480: p_msg_data=>x_msg_data,
2481: p_msg_type=>'ERROR',
2482: p_msg_level=>fnd_log.level_error);
2483: END IF;
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2486: p_prefix=>l_debug_prefix,

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

2480: p_msg_data=>x_msg_data,
2481: p_msg_type=>'ERROR',
2482: p_msg_level=>fnd_log.level_error);
2483: END IF;
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2486: p_prefix=>l_debug_prefix,
2487: p_msg_level=>fnd_log.level_procedure);
2488: END IF;

Line 2487: p_msg_level=>fnd_log.level_procedure);

2483: END IF;
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2486: p_prefix=>l_debug_prefix,
2487: p_msg_level=>fnd_log.level_procedure);
2488: END IF;
2489:
2490: -- Check if API is called in debug mode. If yes, disable debug.
2491: --disable_debug;

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

2499: p_count => x_msg_count,
2500: p_data => x_msg_data );
2501:
2502: -- Debug info.
2503: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2504: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2505: p_msg_data=>x_msg_data,
2506: p_msg_type=>'UNEXPECTED ERROR',
2507: p_msg_level=>fnd_log.level_error);

Line 2507: p_msg_level=>fnd_log.level_error);

2503: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2504: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2505: p_msg_data=>x_msg_data,
2506: p_msg_type=>'UNEXPECTED ERROR',
2507: p_msg_level=>fnd_log.level_error);
2508: END IF;
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2511: p_prefix=>l_debug_prefix,

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

2505: p_msg_data=>x_msg_data,
2506: p_msg_type=>'UNEXPECTED ERROR',
2507: p_msg_level=>fnd_log.level_error);
2508: END IF;
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2511: p_prefix=>l_debug_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;

Line 2512: p_msg_level=>fnd_log.level_procedure);

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

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

2528: p_count => x_msg_count,
2529: p_data => x_msg_data );
2530:
2531: -- Debug info.
2532: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2534: p_msg_data=>x_msg_data,
2535: p_msg_type=>'SQL ERROR',
2536: p_msg_level=>fnd_log.level_error);

Line 2536: p_msg_level=>fnd_log.level_error);

2532: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2534: p_msg_data=>x_msg_data,
2535: p_msg_type=>'SQL ERROR',
2536: p_msg_level=>fnd_log.level_error);
2537: END IF;
2538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2539: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2540: p_prefix=>l_debug_prefix,

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

2534: p_msg_data=>x_msg_data,
2535: p_msg_type=>'SQL ERROR',
2536: p_msg_level=>fnd_log.level_error);
2537: END IF;
2538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2539: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2540: p_prefix=>l_debug_prefix,
2541: p_msg_level=>fnd_log.level_procedure);
2542: END IF;

Line 2541: p_msg_level=>fnd_log.level_procedure);

2537: END IF;
2538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2539: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2540: p_prefix=>l_debug_prefix,
2541: p_msg_level=>fnd_log.level_procedure);
2542: END IF;
2543:
2544: -- Check if API is called in debug mode. If yes, disable debug.
2545: --disable_debug;

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

2592: -- Check if API is called in debug mode. If yes, enable debug.
2593: --enable_debug;
2594:
2595: -- Debug info.
2596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2598: p_prefix=>l_debug_prefix,
2599: p_msg_level=>fnd_log.level_procedure);
2600: END IF;

Line 2599: p_msg_level=>fnd_log.level_procedure);

2595: -- Debug info.
2596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2598: p_prefix=>l_debug_prefix,
2599: p_msg_level=>fnd_log.level_procedure);
2600: END IF;
2601:
2602: -- Initialize message list if p_init_msg_list is set to TRUE.
2603: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2618:
2619: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2620:
2621: -- Debug info.
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
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: -- Debug info.
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:
2628: -- Call table-handler.
2629: HZ_CUST_ACCT_SITES_PKG.Select_Row (

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

2689: X_ORG_ID => x_cust_acct_site_rec.org_id -- Bug 3456489
2690: );
2691:
2692: -- Debug info.
2693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2695: p_prefix=>l_debug_prefix,
2696: p_msg_level=>fnd_log.level_procedure);
2697: END IF;

Line 2696: p_msg_level=>fnd_log.level_procedure);

2692: -- Debug info.
2693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2695: p_prefix=>l_debug_prefix,
2696: p_msg_level=>fnd_log.level_procedure);
2697: END IF;
2698:
2699: -- Standard call to get message count and if count is 1, get message info.
2700: FND_MSG_PUB.Count_And_Get(

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

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

Line 2710: p_msg_level=>fnd_log.level_exception);

2706: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2708: p_msg_data=>x_msg_data,
2709: p_msg_type=>'WARNING',
2710: p_msg_level=>fnd_log.level_exception);
2711: END IF;
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2714: p_prefix=>l_debug_prefix,

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

2708: p_msg_data=>x_msg_data,
2709: p_msg_type=>'WARNING',
2710: p_msg_level=>fnd_log.level_exception);
2711: END IF;
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2714: p_prefix=>l_debug_prefix,
2715: p_msg_level=>fnd_log.level_procedure);
2716: END IF;

Line 2715: p_msg_level=>fnd_log.level_procedure);

2711: END IF;
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2714: p_prefix=>l_debug_prefix,
2715: p_msg_level=>fnd_log.level_procedure);
2716: END IF;
2717:
2718: -- Check if API is called in debug mode. If yes, disable debug.
2719: --disable_debug;

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

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

Line 2735: p_msg_level=>fnd_log.level_error);

2731: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2732: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2733: p_msg_data=>x_msg_data,
2734: p_msg_type=>'ERROR',
2735: p_msg_level=>fnd_log.level_error);
2736: END IF;
2737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2738: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2739: p_prefix=>l_debug_prefix,

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

2733: p_msg_data=>x_msg_data,
2734: p_msg_type=>'ERROR',
2735: p_msg_level=>fnd_log.level_error);
2736: END IF;
2737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2738: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2739: p_prefix=>l_debug_prefix,
2740: p_msg_level=>fnd_log.level_procedure);
2741: END IF;

Line 2740: p_msg_level=>fnd_log.level_procedure);

2736: END IF;
2737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2738: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2739: p_prefix=>l_debug_prefix,
2740: p_msg_level=>fnd_log.level_procedure);
2741: END IF;
2742:
2743: -- Check if API is called in debug mode. If yes, disable debug.
2744: --disable_debug;

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

2751: p_count => x_msg_count,
2752: p_data => x_msg_data );
2753:
2754: -- Debug info.
2755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2757: p_msg_data=>x_msg_data,
2758: p_msg_type=>'UNEXPECTED ERROR',
2759: p_msg_level=>fnd_log.level_error);

Line 2759: p_msg_level=>fnd_log.level_error);

2755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2757: p_msg_data=>x_msg_data,
2758: p_msg_type=>'UNEXPECTED ERROR',
2759: p_msg_level=>fnd_log.level_error);
2760: END IF;
2761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2762: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2763: p_prefix=>l_debug_prefix,

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

2757: p_msg_data=>x_msg_data,
2758: p_msg_type=>'UNEXPECTED ERROR',
2759: p_msg_level=>fnd_log.level_error);
2760: END IF;
2761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2762: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2763: p_prefix=>l_debug_prefix,
2764: p_msg_level=>fnd_log.level_procedure);
2765: END IF;

Line 2764: p_msg_level=>fnd_log.level_procedure);

2760: END IF;
2761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2762: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2763: p_prefix=>l_debug_prefix,
2764: p_msg_level=>fnd_log.level_procedure);
2765: END IF;
2766:
2767: -- Check if API is called in debug mode. If yes, disable debug.
2768: --disable_debug;

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

2779: p_count => x_msg_count,
2780: p_data => x_msg_data );
2781:
2782: -- Debug info.
2783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'SQL ERROR',
2787: p_msg_level=>fnd_log.level_error);

Line 2787: p_msg_level=>fnd_log.level_error);

2783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'SQL ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2791: p_prefix=>l_debug_prefix,

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

2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'SQL ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;

Line 2792: p_msg_level=>fnd_log.level_procedure);

2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;
2794:
2795: -- Check if API is called in debug mode. If yes, disable debug.
2796: --disable_debug;

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

2861: -- Check if API is called in debug mode. If yes, enable debug.
2862: --enable_debug;
2863:
2864: -- Debug info.
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;

Line 2868: p_msg_level=>fnd_log.level_procedure);

2864: -- Debug info.
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;
2870:
2871: -- Initialize message list if p_init_msg_list is set to TRUE.
2872: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2908: p_count => x_msg_count,
2909: p_data => x_msg_data );
2910:
2911: -- Debug info.
2912: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2914: p_msg_data=>x_msg_data,
2915: p_msg_type=>'WARNING',
2916: p_msg_level=>fnd_log.level_exception);

Line 2916: p_msg_level=>fnd_log.level_exception);

2912: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2914: p_msg_data=>x_msg_data,
2915: p_msg_type=>'WARNING',
2916: p_msg_level=>fnd_log.level_exception);
2917: END IF;
2918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2919: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2920: p_prefix=>l_debug_prefix,

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

2914: p_msg_data=>x_msg_data,
2915: p_msg_type=>'WARNING',
2916: p_msg_level=>fnd_log.level_exception);
2917: END IF;
2918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2919: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2920: p_prefix=>l_debug_prefix,
2921: p_msg_level=>fnd_log.level_procedure);
2922: END IF;

Line 2921: p_msg_level=>fnd_log.level_procedure);

2917: END IF;
2918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2919: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2920: p_prefix=>l_debug_prefix,
2921: p_msg_level=>fnd_log.level_procedure);
2922: END IF;
2923: -- Check if API is called in debug mode. If yes, disable debug.
2924: --disable_debug;
2925:

Line 2937: IF fnd_log.level_error>=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_error>=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=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);

Line 2941: p_msg_level=>fnd_log.level_error);

2937: IF fnd_log.level_error>=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=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
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=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
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=>'create_cust_site_use (-)',
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 2962: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 2966: p_msg_level=>fnd_log.level_error);

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

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

2964: p_msg_data=>x_msg_data,
2965: p_msg_type=>'UNEXPECTED ERROR',
2966: p_msg_level=>fnd_log.level_error);
2967: END IF;
2968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2969: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2970: p_prefix=>l_debug_prefix,
2971: p_msg_level=>fnd_log.level_procedure);
2972: END IF;

Line 2971: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2995: p_msg_level=>fnd_log.level_error);

2991: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2993: p_msg_data=>x_msg_data,
2994: p_msg_type=>'SQL ERROR',
2995: p_msg_level=>fnd_log.level_error);
2996: END IF;
2997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2998: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2999: p_prefix=>l_debug_prefix,

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

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

Line 3000: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 3066: p_msg_level=>fnd_log.level_procedure);

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

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

3132: p_count => x_msg_count,
3133: p_data => x_msg_data );
3134:
3135: -- Debug info.
3136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3138: p_msg_data=>x_msg_data,
3139: p_msg_type=>'WARNING',
3140: p_msg_level=>fnd_log.level_exception);

Line 3140: p_msg_level=>fnd_log.level_exception);

3136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3138: p_msg_data=>x_msg_data,
3139: p_msg_type=>'WARNING',
3140: p_msg_level=>fnd_log.level_exception);
3141: END IF;
3142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3143: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3144: p_prefix=>l_debug_prefix,

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

3138: p_msg_data=>x_msg_data,
3139: p_msg_type=>'WARNING',
3140: p_msg_level=>fnd_log.level_exception);
3141: END IF;
3142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3143: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3144: p_prefix=>l_debug_prefix,
3145: p_msg_level=>fnd_log.level_procedure);
3146: END IF;

Line 3145: p_msg_level=>fnd_log.level_procedure);

3141: END IF;
3142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3143: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3144: p_prefix=>l_debug_prefix,
3145: p_msg_level=>fnd_log.level_procedure);
3146: END IF;
3147:
3148: -- Check if API is called in debug mode. If yes, disable debug.
3149: --disable_debug;

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

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

Line 3166: p_msg_level=>fnd_log.level_error);

3162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3164: p_msg_data=>x_msg_data,
3165: p_msg_type=>'ERROR',
3166: p_msg_level=>fnd_log.level_error);
3167: END IF;
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3170: p_prefix=>l_debug_prefix,

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

3164: p_msg_data=>x_msg_data,
3165: p_msg_type=>'ERROR',
3166: p_msg_level=>fnd_log.level_error);
3167: END IF;
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3170: p_prefix=>l_debug_prefix,
3171: p_msg_level=>fnd_log.level_procedure);
3172: END IF;

Line 3171: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 3191: p_msg_level=>fnd_log.level_error);

3187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3195: p_prefix=>l_debug_prefix,

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

3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;

Line 3196: p_msg_level=>fnd_log.level_procedure);

3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3198:
3199: -- Check if API is called in debug mode. If yes, disable debug.
3200: --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=>'SQL 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=>'SQL ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221: END IF;
3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3223: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3224: p_prefix=>l_debug_prefix,

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

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

Line 3225: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 3288: p_msg_level=>fnd_log.level_procedure);

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

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

3307:
3308: x_cust_site_use_rec.site_use_id := p_site_use_id;
3309:
3310: -- Debug info.
3311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3313: p_prefix=>l_debug_prefix,
3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;

Line 3314: p_msg_level=>fnd_log.level_procedure);

3310: -- Debug info.
3311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3313: p_prefix=>l_debug_prefix,
3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:
3317: -- Call table-handler.
3318: HZ_CUST_SITE_USES_PKG.Select_Row (

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

3419: X_ORG_ID => x_cust_site_use_rec.org_id -- Bug 3456489
3420: );
3421:
3422: -- Debug info.
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;

Line 3426: p_msg_level=>fnd_log.level_procedure);

3422: -- Debug info.
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428:
3429: BEGIN
3430: -- Fetch customer profile id.

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

3457: p_count => x_msg_count,
3458: p_data => x_msg_data );
3459:
3460: -- Debug info.
3461: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3462: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);

Line 3465: p_msg_level=>fnd_log.level_exception);

3461: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3462: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;
3467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3468: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3469: p_prefix=>l_debug_prefix,

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

3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;
3467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3468: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3469: p_prefix=>l_debug_prefix,
3470: p_msg_level=>fnd_log.level_procedure);
3471: END IF;

Line 3470: p_msg_level=>fnd_log.level_procedure);

3466: END IF;
3467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3468: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3469: p_prefix=>l_debug_prefix,
3470: p_msg_level=>fnd_log.level_procedure);
3471: END IF;
3472:
3473: -- Check if API is called in debug mode. If yes, disable debug.
3474: --disable_debug;

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

3482: p_count => x_msg_count,
3483: p_data => x_msg_data );
3484:
3485: -- Debug info.
3486: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);

Line 3490: p_msg_level=>fnd_log.level_error);

3486: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3494: p_prefix=>l_debug_prefix,

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

3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;

Line 3495: p_msg_level=>fnd_log.level_procedure);

3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497:
3498: -- Check if API is called in debug mode. If yes, disable debug.
3499: --disable_debug;

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

3506: p_count => x_msg_count,
3507: p_data => x_msg_data );
3508:
3509: -- Debug info.
3510: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3511: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3512: p_msg_data=>x_msg_data,
3513: p_msg_type=>'UNEXPECTED ERROR',
3514: p_msg_level=>fnd_log.level_error);

Line 3514: p_msg_level=>fnd_log.level_error);

3510: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3511: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3512: p_msg_data=>x_msg_data,
3513: p_msg_type=>'UNEXPECTED ERROR',
3514: p_msg_level=>fnd_log.level_error);
3515: END IF;
3516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3517: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3518: p_prefix=>l_debug_prefix,

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

3512: p_msg_data=>x_msg_data,
3513: p_msg_type=>'UNEXPECTED ERROR',
3514: p_msg_level=>fnd_log.level_error);
3515: END IF;
3516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3517: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3518: p_prefix=>l_debug_prefix,
3519: p_msg_level=>fnd_log.level_procedure);
3520: END IF;

Line 3519: p_msg_level=>fnd_log.level_procedure);

3515: END IF;
3516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3517: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3518: p_prefix=>l_debug_prefix,
3519: p_msg_level=>fnd_log.level_procedure);
3520: END IF;
3521:
3522: -- Check if API is called in debug mode. If yes, disable debug.
3523: --disable_debug;

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

3534: p_count => x_msg_count,
3535: p_data => x_msg_data );
3536:
3537: -- Debug info.
3538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3540: p_msg_data=>x_msg_data,
3541: p_msg_type=>'SQL ERROR',
3542: p_msg_level=>fnd_log.level_error);

Line 3542: p_msg_level=>fnd_log.level_error);

3538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3540: p_msg_data=>x_msg_data,
3541: p_msg_type=>'SQL ERROR',
3542: p_msg_level=>fnd_log.level_error);
3543: END IF;
3544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3545: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3546: p_prefix=>l_debug_prefix,

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

3540: p_msg_data=>x_msg_data,
3541: p_msg_type=>'SQL ERROR',
3542: p_msg_level=>fnd_log.level_error);
3543: END IF;
3544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3545: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3546: p_prefix=>l_debug_prefix,
3547: p_msg_level=>fnd_log.level_procedure);
3548: END IF;

Line 3547: p_msg_level=>fnd_log.level_procedure);

3543: END IF;
3544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3545: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3546: p_prefix=>l_debug_prefix,
3547: p_msg_level=>fnd_log.level_procedure);
3548: END IF;
3549:
3550: -- Check if API is called in debug mode. If yes, disable debug.
3551: --disable_debug;