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_LOCATION_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 78: * HZ_UTILITY_V2PUB.enable_debug

74: * DESCRIPTION
75: * Turn on debug mode.
76: *
77: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
78: * HZ_UTILITY_V2PUB.enable_debug
79: *
80: * MODIFICATION HISTORY
81: *
82: * 07-23-2001 Jianying Huang o Created.

Line 94: hz_utility_v2pub.enable_debug;

90: IF g_debug_count = 1 THEN
91: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
92: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
93: THEN
94: hz_utility_v2pub.enable_debug;
95: g_debug := TRUE;
96: END IF;
97: END IF;
98: END enable_debug;

Line 109: * HZ_UTILITY_V2PUB.disable_debug

105: * DESCRIPTION
106: * Turn off debug mode.
107: *
108: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
109: * HZ_UTILITY_V2PUB.disable_debug
110: *
111: * MODIFICATION HISTORY
112: *
113: * 07-23-2001 Jianying Huang o Created.

Line 122: hz_utility_v2pub.disable_debug;

118: BEGIN
119: IF g_debug THEN
120: g_debug_count := g_debug_count - 1;
121: IF g_debug_count = 0 THEN
122: hz_utility_v2pub.disable_debug;
123: g_debug := FALSE;
124: END IF;
125: END IF;
126: END disable_debug;

Line 158: hz_utility_v2pub.debug(p_message=>'do_create_location (+)',

154: WHERE hl.location_id = p_location_rec.location_id;
155: BEGIN
156: -- Debug info.
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'do_create_location (+)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;
162:

Line 208: hz_utility_v2pub.debug(p_message=>'Key Generated : '||l_key,

204: );
205:
206: -- Debug info.
207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'Key Generated : '||l_key,
209: p_prefix =>l_debug_prefix,
210: p_msg_level=>fnd_log.level_statement);
211: END IF;
212:

Line 217: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (+)',

213: p_location_rec.address_key := l_key;
214:
215: -- Debug info.
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (+)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;
221:

Line 229: hz_utility_v2pub.debug(p_message=>'p_location_rec.actual_content_source = '||

225: END IF;
226:
227: -- Debug info.
228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
229: hz_utility_v2pub.debug(p_message=>'p_location_rec.actual_content_source = '||
230: p_location_rec.actual_content_source,
231: p_prefix =>l_debug_prefix,
232: p_msg_level=>fnd_log.level_statement);
233: END IF;

Line 374: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||

370: -- ACNG add call to location profile: END
371:
372: -- Debug info.
373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
374: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||
375: 'x_location_id = ' || p_location_rec.location_id,
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: -- ACNG add call to location profile: BEGIN

Line 379: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||

375: 'x_location_id = ' || p_location_rec.location_id,
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: -- ACNG add call to location profile: BEGIN
379: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
380: 'l_location_profile_id = ' || l_location_profile_id,
381: p_prefix=>l_debug_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: -- ACNG add call to location profile: END

Line 384: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',

380: 'l_location_profile_id = ' || l_location_profile_id,
381: p_prefix=>l_debug_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: -- ACNG add call to location profile: END
384: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);
387:
388: END IF;

Line 464: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',

460:
461: BEGIN
462: -- Debug info.
463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
464: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
465: p_prefix=>l_debug_prefix,
466: p_msg_level=>fnd_log.level_procedure);
467: END IF;
468:

Line 618: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,

614: );
615:
616: -- Debug info.
617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
619: p_prefix =>l_debug_prefix,
620: p_msg_level=>fnd_log.level_statement);
621: END IF;
622:

Line 629: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',

625: p_location_rec.geometry := l_geometry;
626:
627: -- Debug info.
628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
629: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',
630: p_prefix=>l_debug_prefix,
631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633:

Line 635: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633:
634: -- Bug 4693719 : pass NULL if the secure data is not updated
635: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
636: l_acs := nvl(p_location_rec.actual_content_source, 'USER_ENTERED');
637: ELSE
638: l_acs := NULL;
639: END IF;

Line 807: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',

803: -- ACNG add call to location profile: END
804:
805: -- Debug info.
806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
807: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',
808: p_prefix=>l_debug_prefix,
809: p_msg_level=>fnd_log.level_procedure);
810: END IF;
811:

Line 860: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||

856: EXIT WHEN c1%NOTFOUND;
857:
858: -- Debug info.
859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
861: l_party_id,
862: p_prefix =>l_debug_prefix,
863: p_msg_level=>fnd_log.level_statement);
864: END IF;

Line 917: last_update_date = hz_utility_v2pub.last_update_date,

913: county = DECODE(p_location_rec.county,
914: NULL, db_county,
915: fnd_api.g_miss_char, NULL,
916: p_location_rec.county),
917: last_update_date = hz_utility_v2pub.last_update_date,
918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,

Line 918: last_updated_by = hz_utility_v2pub.last_updated_by,

914: NULL, db_county,
915: fnd_api.g_miss_char, NULL,
916: p_location_rec.county),
917: last_update_date = hz_utility_v2pub.last_update_date,
918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,

Line 919: last_update_login = hz_utility_v2pub.last_update_login,

915: fnd_api.g_miss_char, NULL,
916: p_location_rec.county),
917: last_update_date = hz_utility_v2pub.last_update_date,
918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,
923: program_update_date = hz_utility_v2pub.program_update_date

Line 920: request_id = hz_utility_v2pub.request_id,

916: p_location_rec.county),
917: last_update_date = hz_utility_v2pub.last_update_date,
918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,
923: program_update_date = hz_utility_v2pub.program_update_date
924: WHERE party_id = l_party_id;

Line 921: program_id = hz_utility_v2pub.program_id,

917: last_update_date = hz_utility_v2pub.last_update_date,
918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,
923: program_update_date = hz_utility_v2pub.program_update_date
924: WHERE party_id = l_party_id;
925:

Line 922: program_application_id = hz_utility_v2pub.program_application_id,

918: last_updated_by = hz_utility_v2pub.last_updated_by,
919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,
923: program_update_date = hz_utility_v2pub.program_update_date
924: WHERE party_id = l_party_id;
925:
926: END IF; -- Only if address is not a Remit to.

Line 923: program_update_date = hz_utility_v2pub.program_update_date

919: last_update_login = hz_utility_v2pub.last_update_login,
920: request_id = hz_utility_v2pub.request_id,
921: program_id = hz_utility_v2pub.program_id,
922: program_application_id = hz_utility_v2pub.program_application_id,
923: program_update_date = hz_utility_v2pub.program_update_date
924: WHERE party_id = l_party_id;
925:
926: END IF; -- Only if address is not a Remit to.
927: END LOOP;

Line 964: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',

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

Line 1064: hz_utility_v2pub.debug(p_message=>'create_location (+)',

1060: --enable_debug;
1061:
1062: -- Debug info.
1063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1064: hz_utility_v2pub.debug(p_message=>'create_location (+)',
1065: p_prefix=>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_procedure);
1067: END IF;
1068:

Line 1195: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1191: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
1192: -- Bug 2197181: Added below condition for Mix-n-Match
1193: g_loc_is_datasource_selected = 'Y'*/
1194: THEN
1195: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1196: HZ_BUSINESS_EVENT_V2PVT.create_location_event (
1197: l_location_rec);
1198: END IF;
1199:

Line 1200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1196: HZ_BUSINESS_EVENT_V2PVT.create_location_event (
1197: l_location_rec);
1198: END IF;
1199:
1200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1201: -- populate function for integration service
1202: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1203: p_operation => 'I',
1204: p_location_id => x_location_id );

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

1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213: -- Debug info.
1214: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1215: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1216: p_msg_data=>x_msg_data,
1217: p_msg_type=>'WARNING',
1218: p_msg_level=>fnd_log.level_exception);
1219: END IF;

Line 1221: hz_utility_v2pub.debug(p_message=>'create_location (-)',

1217: p_msg_type=>'WARNING',
1218: p_msg_level=>fnd_log.level_exception);
1219: END IF;
1220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1221: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1222: p_prefix=>l_debug_prefix,
1223: p_msg_level=>fnd_log.level_procedure);
1224: END IF;
1225:

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

1236: p_data => x_msg_data);
1237:
1238: -- Debug info.
1239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;

Line 1246: hz_utility_v2pub.debug(p_message=>'create_location (-)',

1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:

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

1260: p_data => x_msg_data);
1261:
1262: -- Debug info.
1263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1265: p_msg_data=>x_msg_data,
1266: p_msg_type=>'UNEXPECTED ERROR',
1267: p_msg_level=>fnd_log.level_error);
1268: END IF;

Line 1270: hz_utility_v2pub.debug(p_message=>'create_location (-)',

1266: p_msg_type=>'UNEXPECTED ERROR',
1267: p_msg_level=>fnd_log.level_error);
1268: END IF;
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1271: p_prefix=>l_debug_prefix,
1272: p_msg_level=>fnd_log.level_procedure);
1273: END IF;
1274:

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

1289: p_data => x_msg_data);
1290:
1291: -- Debug info.
1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1294: p_msg_data=>x_msg_data,
1295: p_msg_type=>'SQL ERROR',
1296: p_msg_level=>fnd_log.level_error);
1297: END IF;

Line 1299: hz_utility_v2pub.debug(p_message=>'create_location (-)',

1295: p_msg_type=>'SQL ERROR',
1296: p_msg_level=>fnd_log.level_error);
1297: END IF;
1298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1299: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1300: p_prefix=>l_debug_prefix,
1301: p_msg_level=>fnd_log.level_procedure);
1302: END IF;
1303:

Line 1464: hz_utility_v2pub.debug(p_message=>'update_location (+)',

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

Line 1671: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',

1667: x_addr_warn_msg,
1668: x_return_status);
1669:
1670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1671: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1672: p_msg_level=>fnd_log.level_procedure);
1673: END IF;
1674:
1675: AP_TCA_SUPPLIER_SYNC_PKG.SYNC_Supplier_Sites(x_return_status => x_return_status,

Line 1688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',

1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686:
1687: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1689: p_msg_level=>fnd_log.level_procedure);
1690: END IF;
1691:
1692: -- Call to indicate location update to DQM

Line 1709: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1705: -- Bug 2197181: Added below condition for Mix-n-Match
1706: g_loc_is_datasource_selected = 'Y'*/
1707: THEN
1708: l_old_location_rec.orig_system := p_location_rec.orig_system;
1709: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1710: HZ_BUSINESS_EVENT_V2PVT.update_location_event (
1711: l_location_rec,
1712: l_old_location_rec);
1713: END IF;

Line 1715: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1711: l_location_rec,
1712: l_old_location_rec);
1713: END IF;
1714:
1715: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1716: -- populate function for integration service
1717: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1718: p_operation => 'U',
1719: p_location_id => l_location_rec.location_id );

Line 1723: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1719: p_location_id => l_location_rec.location_id );
1720: END IF;
1721: END IF;
1722:
1723: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1724:
1725: -- standard call to get message count and if count is 1, get message info.
1726: FND_MSG_PUB.Count_And_Get(
1727: p_encoded => FND_API.G_FALSE,

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

1729: p_data => x_msg_data);
1730:
1731: -- Debug info.
1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;

Line 1739: hz_utility_v2pub.debug(p_message=>'update_location (-)',

1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;
1743:

Line 1751: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1747:
1748: EXCEPTION
1749: WHEN FND_API.G_EXC_ERROR THEN
1750: ROLLBACK TO update_location;
1751: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1752: x_return_status := FND_API.G_RET_STS_ERROR;
1753: FND_MSG_PUB.Count_And_Get(
1754: p_encoded => FND_API.G_FALSE,
1755: p_count => x_msg_count,

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

1756: p_data => x_msg_data);
1757:
1758: -- Debug info.
1759: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1761: p_msg_data=>x_msg_data,
1762: p_msg_type=>'ERROR',
1763: p_msg_level=>fnd_log.level_error);
1764: END IF;

Line 1766: hz_utility_v2pub.debug(p_message=>'update_location (-)',

1762: p_msg_type=>'ERROR',
1763: p_msg_level=>fnd_log.level_error);
1764: END IF;
1765: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1766: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1767: p_prefix=>l_debug_prefix,
1768: p_msg_level=>fnd_log.level_procedure);
1769: END IF;
1770:

Line 1776: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1772: --disable_debug;
1773:
1774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1775: ROLLBACK TO update_location;
1776: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(
1779: p_encoded => FND_API.G_FALSE,
1780: p_count => x_msg_count,

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

1781: p_data => x_msg_data);
1782:
1783: -- Debug info.
1784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1786: p_msg_data=>x_msg_data,
1787: p_msg_type=>'UNEXPECTED ERROR',
1788: p_msg_level=>fnd_log.level_error);
1789: END IF;

Line 1791: hz_utility_v2pub.debug(p_message=>'update_location (-)',

1787: p_msg_type=>'UNEXPECTED ERROR',
1788: p_msg_level=>fnd_log.level_error);
1789: END IF;
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;
1795:

Line 1801: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1797: --disable_debug;
1798:
1799: WHEN OTHERS THEN
1800: ROLLBACK TO update_location;
1801: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803:
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

1811: p_data => x_msg_data);
1812:
1813: -- Debug info.
1814: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1816: p_msg_data=>x_msg_data,
1817: p_msg_type=>'SQL ERROR',
1818: p_msg_level=>fnd_log.level_error);
1819: END IF;

Line 1821: hz_utility_v2pub.debug(p_message=>'update_location (-)',

1817: p_msg_type=>'SQL ERROR',
1818: p_msg_level=>fnd_log.level_error);
1819: END IF;
1820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1822: p_prefix=>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;
1825:

Line 1953: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',

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

Line 1979: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',

1975: x_location_rec.location_id := p_location_id;
1976:
1977: -- Debug info.
1978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1979: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',
1980: p_prefix=>l_debug_prefix,
1981: p_msg_level=>fnd_log.level_procedure);
1982: END IF;
1983:

Line 2055: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',

2051: );
2052:
2053: -- Debug info.
2054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2055: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',
2056: p_prefix=>l_debug_prefix,
2057: p_msg_level=>fnd_log.level_procedure);
2058: END IF;
2059:

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

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

Line 2075: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',

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

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

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

Line 2099: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',

2095: p_msg_type=>'ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2103:

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

2114: );
2115:
2116: -- Debug info.
2117: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2119: p_msg_data=>x_msg_data,
2120: p_msg_type=>'UNEXPECTED ERROR',
2121: p_msg_level=>fnd_log.level_error);
2122: END IF;

Line 2124: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',

2120: p_msg_type=>'UNEXPECTED ERROR',
2121: p_msg_level=>fnd_log.level_error);
2122: END IF;
2123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2124: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2125: p_prefix=>l_debug_prefix,
2126: p_msg_level=>fnd_log.level_procedure);
2127: END IF;
2128:

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

2143: );
2144:
2145: -- Debug info.
2146: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2147: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2148: p_msg_data=>x_msg_data,
2149: p_msg_type=>'SQL ERROR',
2150: p_msg_level=>fnd_log.level_error);
2151: END IF;

Line 2153: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',

2149: p_msg_type=>'SQL ERROR',
2150: p_msg_level=>fnd_log.level_error);
2151: END IF;
2152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2153: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2154: p_prefix=>l_debug_prefix,
2155: p_msg_level=>fnd_log.level_procedure);
2156: END IF;
2157: