eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 179: px_cust_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

175: px_cust_site_use_rec.gl_id_factor := p_cust_site_use_obj.gl_id_factor;
176: px_cust_site_use_rec.tax_classification := p_cust_site_use_obj.tax_classification;
177: px_cust_site_use_rec.orig_system := p_cust_site_use_os;
178: px_cust_site_use_rec.orig_system_reference := p_cust_site_use_osr;
179: px_cust_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
180: px_cust_site_use_rec.org_id := p_cust_site_use_obj.org_id;
181: END assign_cust_site_use_rec;
182:
183: -- PROCEDURE create_cust_site_uses

Line 244: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(+)',

240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: -- Debug info.
243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
244: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(+)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;
248:

Line 297: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

293: );
294:
295: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;
301: RAISE FND_API.G_EXC_ERROR;

Line 386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

382: END LOOP;
383:
384: -- Debug info.
385: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
387: p_msg_data=>x_msg_data,
388: p_msg_type=>'WARNING',
389: p_msg_level=>fnd_log.level_exception);
390: END IF;

Line 392: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',

388: p_msg_type=>'WARNING',
389: p_msg_level=>fnd_log.level_exception);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
396:

Line 412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

408: p_data => x_msg_data);
409:
410: -- Debug info.
411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
413: p_msg_data=>x_msg_data,
414: p_msg_type=>'ERROR',
415: p_msg_level=>fnd_log.level_error);
416: END IF;

Line 418: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',

414: p_msg_type=>'ERROR',
415: p_msg_level=>fnd_log.level_error);
416: END IF;
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422:

Line 437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

433: p_data => x_msg_data);
434:
435: -- Debug info.
436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;

Line 443: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',

439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
444: p_prefix=>l_debug_prefix,
445: p_msg_level=>fnd_log.level_procedure);
446: END IF;
447:

Line 466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

462: p_data => x_msg_data);
463:
464: -- Debug info.
465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;

Line 472: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',

468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476: END create_cust_site_uses;

Line 566: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(+)',

562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: -- Debug info.
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(+)',
567: p_prefix=>l_debug_prefix,
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;
570:

Line 642: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

638: );
639:
640: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646: RAISE fnd_api.g_exc_error;

Line 729: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

725: );
726:
727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;
733: RAISE fnd_api.g_exc_error;

Line 814: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

810: END LOOP;
811:
812: -- Debug info.
813: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
815: p_msg_data=>x_msg_data,
816: p_msg_type=>'WARNING',
817: p_msg_level=>fnd_log.level_exception);
818: END IF;

Line 820: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',

816: p_msg_type=>'WARNING',
817: p_msg_level=>fnd_log.level_exception);
818: END IF;
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
821: p_prefix=>l_debug_prefix,
822: p_msg_level=>fnd_log.level_procedure);
823: END IF;
824: EXCEPTION

Line 839: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

835: p_data => x_msg_data);
836:
837: -- Debug info.
838: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
839: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
840: p_msg_data=>x_msg_data,
841: p_msg_type=>'ERROR',
842: p_msg_level=>fnd_log.level_error);
843: END IF;

Line 845: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',

841: p_msg_type=>'ERROR',
842: p_msg_level=>fnd_log.level_error);
843: END IF;
844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
846: p_prefix=>l_debug_prefix,
847: p_msg_level=>fnd_log.level_procedure);
848: END IF;
849:

Line 864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

860: p_data => x_msg_data);
861:
862: -- Debug info.
863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'UNEXPECTED ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;

Line 870: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',

866: p_msg_type=>'UNEXPECTED ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874:

Line 893: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

889: p_data => x_msg_data);
890:
891: -- Debug info.
892: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
894: p_msg_data=>x_msg_data,
895: p_msg_type=>'SQL ERROR',
896: p_msg_level=>fnd_log.level_error);
897: END IF;

Line 899: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',

895: p_msg_type=>'SQL ERROR',
896: p_msg_level=>fnd_log.level_error);
897: END IF;
898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
899: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
900: p_prefix=>l_debug_prefix,
901: p_msg_level=>fnd_log.level_procedure);
902: END IF;
903: END save_cust_site_uses;

Line 934: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(+)',

930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: -- Debug info.
933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
934: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(+)',
935: p_prefix=>l_debug_prefix,
936: p_msg_level=>fnd_log.level_procedure);
937: END IF;
938:

Line 943: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

939: l_parent_acct_id := p_parent_acct_id;
940: l_parent_acct_os := p_parent_acct_os;
941: l_parent_acct_osr := p_parent_acct_osr;
942:
943: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
944:
945: IF(p_create_update_flag = 'C') THEN
946: -- Create cust account sites
947: FOR i IN 1..p_cas_objs.COUNT LOOP

Line 952: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

948: HZ_CUST_ACCT_SITE_BO_PUB.do_create_cust_acct_site_bo(
949: p_init_msg_list => fnd_api.g_false,
950: p_validate_bo_flag => fnd_api.g_false,
951: p_cust_acct_site_obj => p_cas_objs(i),
952: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
953: p_obj_source => p_obj_source,
954: x_return_status => x_return_status,
955: x_msg_count => x_msg_count,
956: x_msg_data => x_msg_data,

Line 967: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,

963: );
964:
965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;
971: RAISE fnd_api.g_exc_error;

Line 974: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

970: END IF;
971: RAISE fnd_api.g_exc_error;
972: END IF;
973:
974: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
975: END LOOP;
976: ELSE
977: -- Create/update cust account site
978: FOR i IN 1..p_cas_objs.COUNT LOOP

Line 983: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

979: HZ_CUST_ACCT_SITE_BO_PUB.do_save_cust_acct_site_bo(
980: p_init_msg_list => fnd_api.g_false,
981: p_validate_bo_flag => fnd_api.g_false,
982: p_cust_acct_site_obj => p_cas_objs(i),
983: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
984: p_obj_source => p_obj_source,
985: x_return_status => x_return_status,
986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data,

Line 998: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,

994: );
995:
996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
1002: RAISE fnd_api.g_exc_error;

Line 1005: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1001: END IF;
1002: RAISE fnd_api.g_exc_error;
1003: END IF;
1004:
1005: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1006: END LOOP;
1007: END IF;
1008:
1009: -- Debug info.

Line 1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1007: END IF;
1008:
1009: -- Debug info.
1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;

Line 1017: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',

1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;
1016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1017: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1018: p_prefix=>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_procedure);
1020: END IF;
1021: EXCEPTION

Line 1031: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1027: p_data => x_msg_data);
1028:
1029: -- Debug info.
1030: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1032: p_msg_data=>x_msg_data,
1033: p_msg_type=>'ERROR',
1034: p_msg_level=>fnd_log.level_error);
1035: END IF;

Line 1037: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',

1033: p_msg_type=>'ERROR',
1034: p_msg_level=>fnd_log.level_error);
1035: END IF;
1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1038: p_prefix=>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_procedure);
1040: END IF;
1041: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1046: p_data => x_msg_data);
1047:
1048: -- Debug info.
1049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1051: p_msg_data=>x_msg_data,
1052: p_msg_type=>'UNEXPECTED ERROR',
1053: p_msg_level=>fnd_log.level_error);
1054: END IF;

Line 1056: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',

1052: p_msg_type=>'UNEXPECTED ERROR',
1053: p_msg_level=>fnd_log.level_error);
1054: END IF;
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;
1060: WHEN OTHERS THEN

Line 1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1069: p_data => x_msg_data);
1070:
1071: -- Debug info.
1072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'SQL ERROR',
1076: p_msg_level=>fnd_log.level_error);
1077: END IF;

Line 1079: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',

1075: p_msg_type=>'SQL ERROR',
1076: p_msg_level=>fnd_log.level_error);
1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083: END save_cust_acct_sites;

Line 1260: px_cust_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1256: px_cust_site_use_rec.gl_id_factor := p_cust_site_use_v2_obj.gl_id_factor;
1257: px_cust_site_use_rec.tax_classification := p_cust_site_use_v2_obj.tax_classification;
1258: px_cust_site_use_rec.orig_system := p_cust_site_use_os;
1259: px_cust_site_use_rec.orig_system_reference := p_cust_site_use_osr;
1260: px_cust_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1261: px_cust_site_use_rec.org_id := p_cust_site_use_v2_obj.org_id;
1262: END assign_cust_site_use_v2_rec;
1263:
1264: -- PROCEDURE create_cust_site_v2_uses

Line 1325: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(+)',

1321: x_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: -- Debug info.
1324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(+)',
1326: p_prefix=>l_debug_prefix,
1327: p_msg_level=>fnd_log.level_procedure);
1328: END IF;
1329:

Line 1378: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

1374: );
1375:
1376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1379: p_prefix=>l_debug_prefix,
1380: p_msg_level=>fnd_log.level_procedure);
1381: END IF;
1382: RAISE FND_API.G_EXC_ERROR;

Line 1468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1464: END LOOP;
1465:
1466: -- Debug info.
1467: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1469: p_msg_data=>x_msg_data,
1470: p_msg_type=>'WARNING',
1471: p_msg_level=>fnd_log.level_exception);
1472: END IF;

Line 1474: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',

1470: p_msg_type=>'WARNING',
1471: p_msg_level=>fnd_log.level_exception);
1472: END IF;
1473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1474: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1475: p_prefix=>l_debug_prefix,
1476: p_msg_level=>fnd_log.level_procedure);
1477: END IF;
1478:

Line 1494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1490: p_data => x_msg_data);
1491:
1492: -- Debug info.
1493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1495: p_msg_data=>x_msg_data,
1496: p_msg_type=>'ERROR',
1497: p_msg_level=>fnd_log.level_error);
1498: END IF;

Line 1500: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',

1496: p_msg_type=>'ERROR',
1497: p_msg_level=>fnd_log.level_error);
1498: END IF;
1499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1500: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1501: p_prefix=>l_debug_prefix,
1502: p_msg_level=>fnd_log.level_procedure);
1503: END IF;
1504:

Line 1519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1515: p_data => x_msg_data);
1516:
1517: -- Debug info.
1518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1520: p_msg_data=>x_msg_data,
1521: p_msg_type=>'UNEXPECTED ERROR',
1522: p_msg_level=>fnd_log.level_error);
1523: END IF;

Line 1525: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',

1521: p_msg_type=>'UNEXPECTED ERROR',
1522: p_msg_level=>fnd_log.level_error);
1523: END IF;
1524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1526: p_prefix=>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_procedure);
1528: END IF;
1529:

Line 1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1544: p_data => x_msg_data);
1545:
1546: -- Debug info.
1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'SQL ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;

Line 1554: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',

1550: p_msg_type=>'SQL ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558: END create_cust_site_v2_uses;

Line 1638: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(+)',

1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635:
1636: -- Debug info.
1637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1638: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(+)',
1639: p_prefix=>l_debug_prefix,
1640: p_msg_level=>fnd_log.level_procedure);
1641: END IF;
1642:

Line 1700: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

1696: );
1697:
1698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704: RAISE fnd_api.g_exc_error;

Line 1787: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,

1783: );
1784:
1785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1788: p_prefix=>l_debug_prefix,
1789: p_msg_level=>fnd_log.level_procedure);
1790: END IF;
1791: RAISE fnd_api.g_exc_error;

Line 1873: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1869: END LOOP;
1870:
1871: -- Debug info.
1872: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1874: p_msg_data=>x_msg_data,
1875: p_msg_type=>'WARNING',
1876: p_msg_level=>fnd_log.level_exception);
1877: END IF;

Line 1879: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',

1875: p_msg_type=>'WARNING',
1876: p_msg_level=>fnd_log.level_exception);
1877: END IF;
1878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1879: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1880: p_prefix=>l_debug_prefix,
1881: p_msg_level=>fnd_log.level_procedure);
1882: END IF;
1883: EXCEPTION

Line 1898: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1904: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',

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

Line 1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1929: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',

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

Line 1952: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1958: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',

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

Line 1993: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(+)',

1989: x_return_status := FND_API.G_RET_STS_SUCCESS;
1990:
1991: -- Debug info.
1992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(+)',
1994: p_prefix=>l_debug_prefix,
1995: p_msg_level=>fnd_log.level_procedure);
1996: END IF;
1997:

Line 2002: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1998: l_parent_acct_id := p_parent_acct_id;
1999: l_parent_acct_os := p_parent_acct_os;
2000: l_parent_acct_osr := p_parent_acct_osr;
2001:
2002: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2003:
2004: IF(p_create_update_flag = 'C') THEN
2005: -- Create cust account sites
2006: FOR i IN 1..p_cas_v2_objs.COUNT LOOP

Line 2011: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2007: HZ_CUST_ACCT_SITE_BO_PUB.do_create_cust_acct_site_v2_bo(
2008: p_init_msg_list => fnd_api.g_false,
2009: p_validate_bo_flag => fnd_api.g_false,
2010: p_cust_acct_site_v2_obj => p_cas_v2_objs(i),
2011: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2012: p_obj_source => p_obj_source,
2013: x_return_status => x_return_status,
2014: x_msg_count => x_msg_count,
2015: x_msg_data => x_msg_data,

Line 2026: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,

2022: );
2023:
2024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2026: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2027: p_prefix=>l_debug_prefix,
2028: p_msg_level=>fnd_log.level_procedure);
2029: END IF;
2030: RAISE fnd_api.g_exc_error;

Line 2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2029: END IF;
2030: RAISE fnd_api.g_exc_error;
2031: END IF;
2032:
2033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2034: END LOOP;
2035: ELSE
2036: -- Create/update cust account site
2037: FOR i IN 1..p_cas_v2_objs.COUNT LOOP

Line 2042: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2038: HZ_CUST_ACCT_SITE_BO_PUB.do_save_cust_acct_site_v2_bo(
2039: p_init_msg_list => fnd_api.g_false,
2040: p_validate_bo_flag => fnd_api.g_false,
2041: p_cust_acct_site_v2_obj => p_cas_v2_objs(i),
2042: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2043: p_obj_source => p_obj_source,
2044: x_return_status => x_return_status,
2045: x_msg_count => x_msg_count,
2046: x_msg_data => x_msg_data,

Line 2057: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,

2053: );
2054:
2055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2057: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2058: p_prefix=>l_debug_prefix,
2059: p_msg_level=>fnd_log.level_procedure);
2060: END IF;
2061: RAISE fnd_api.g_exc_error;

Line 2064: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2060: END IF;
2061: RAISE fnd_api.g_exc_error;
2062: END IF;
2063:
2064: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2065: END LOOP;
2066: END IF;
2067:
2068: -- Debug info.

Line 2070: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2066: END IF;
2067:
2068: -- Debug info.
2069: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2070: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2071: p_msg_data=>x_msg_data,
2072: p_msg_type=>'WARNING',
2073: p_msg_level=>fnd_log.level_exception);
2074: END IF;

Line 2076: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',

2072: p_msg_type=>'WARNING',
2073: p_msg_level=>fnd_log.level_exception);
2074: END IF;
2075: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2076: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2077: p_prefix=>l_debug_prefix,
2078: p_msg_level=>fnd_log.level_procedure);
2079: END IF;
2080: EXCEPTION

Line 2090: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2086: p_data => x_msg_data);
2087:
2088: -- Debug info.
2089: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2091: p_msg_data=>x_msg_data,
2092: p_msg_type=>'ERROR',
2093: p_msg_level=>fnd_log.level_error);
2094: END IF;

Line 2096: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',

2092: p_msg_type=>'ERROR',
2093: p_msg_level=>fnd_log.level_error);
2094: END IF;
2095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2096: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2097: p_prefix=>l_debug_prefix,
2098: p_msg_level=>fnd_log.level_procedure);
2099: END IF;
2100: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2109: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2105: p_data => x_msg_data);
2106:
2107: -- Debug info.
2108: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2109: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2110: p_msg_data=>x_msg_data,
2111: p_msg_type=>'UNEXPECTED ERROR',
2112: p_msg_level=>fnd_log.level_error);
2113: END IF;

Line 2115: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',

2111: p_msg_type=>'UNEXPECTED ERROR',
2112: p_msg_level=>fnd_log.level_error);
2113: END IF;
2114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2115: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2116: p_prefix=>l_debug_prefix,
2117: p_msg_level=>fnd_log.level_procedure);
2118: END IF;
2119: WHEN OTHERS THEN

Line 2132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2128: p_data => x_msg_data);
2129:
2130: -- Debug info.
2131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2133: p_msg_data=>x_msg_data,
2134: p_msg_type=>'SQL ERROR',
2135: p_msg_level=>fnd_log.level_error);
2136: END IF;

Line 2138: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',

2134: p_msg_type=>'SQL ERROR',
2135: p_msg_level=>fnd_log.level_error);
2136: END IF;
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2139: p_prefix=>l_debug_prefix,
2140: p_msg_level=>fnd_log.level_procedure);
2141: END IF;
2142: END save_cust_acct_v2_sites;