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 262: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',

258: END LOOP;
259: */
260: --Bug#8616119
261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);
265: END IF;
266: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP

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

383: -- ACNG add call to location profile: END
384:
385: -- Debug info.
386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.insert_row (-) ' ||
388: 'x_location_id = ' || p_location_rec.location_id,
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: -- ACNG add call to location profile: BEGIN

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

388: 'x_location_id = ' || p_location_rec.location_id,
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: -- ACNG add call to location profile: BEGIN
392: hz_utility_v2pub.debug(p_message=>'hz_location_profiles_pkg.insert_row (-) ' ||
393: 'l_location_profile_id = ' || l_location_profile_id,
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: -- ACNG add call to location profile: END

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

393: 'l_location_profile_id = ' || l_location_profile_id,
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: -- ACNG add call to location profile: END
397: hz_utility_v2pub.debug(p_message=>'do_create_location (-)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400:
401: END IF;

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

473:
474: BEGIN
475: -- Debug info.
476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug(p_message=>'do_update_location (+)',
478: p_prefix=>l_debug_prefix,
479: p_msg_level=>fnd_log.level_procedure);
480: END IF;
481:

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

627: );
628:
629: -- Debug info.
630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'Key generated : '||l_key,
632: p_prefix =>l_debug_prefix,
633: p_msg_level=>fnd_log.level_statement);
634: END IF;
635:

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

638: p_location_rec.geometry := l_geometry;
639:
640: -- Debug info.
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Update_Row (+) ',
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646:

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

644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646:
647: -- Bug 4693719 : pass NULL if the secure data is not updated
648: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
649: l_acs := nvl(p_location_rec.actual_content_source, 'USER_ENTERED');
650: ELSE
651: l_acs := NULL;
652: END IF;

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

816: -- ACNG add call to location profile: END
817:
818: -- Debug info.
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row (-) ',
821: p_prefix=>l_debug_prefix,
822: p_msg_level=>fnd_log.level_procedure);
823: END IF;
824:

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

869: EXIT WHEN c1%NOTFOUND;
870:
871: -- Debug info.
872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
873: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
874: l_party_id,
875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);
877: END IF;

Line 930: last_update_date = hz_utility_v2pub.last_update_date,

926: county = DECODE(p_location_rec.county,
927: NULL, db_county,
928: fnd_api.g_miss_char, NULL,
929: p_location_rec.county),
930: last_update_date = hz_utility_v2pub.last_update_date,
931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,

Line 931: last_updated_by = hz_utility_v2pub.last_updated_by,

927: NULL, db_county,
928: fnd_api.g_miss_char, NULL,
929: p_location_rec.county),
930: last_update_date = hz_utility_v2pub.last_update_date,
931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,

Line 932: last_update_login = hz_utility_v2pub.last_update_login,

928: fnd_api.g_miss_char, NULL,
929: p_location_rec.county),
930: last_update_date = hz_utility_v2pub.last_update_date,
931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,
936: program_update_date = hz_utility_v2pub.program_update_date

Line 933: request_id = hz_utility_v2pub.request_id,

929: p_location_rec.county),
930: last_update_date = hz_utility_v2pub.last_update_date,
931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,
936: program_update_date = hz_utility_v2pub.program_update_date
937: WHERE party_id = l_party_id;

Line 934: program_id = hz_utility_v2pub.program_id,

930: last_update_date = hz_utility_v2pub.last_update_date,
931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,
936: program_update_date = hz_utility_v2pub.program_update_date
937: WHERE party_id = l_party_id;
938:

Line 935: program_application_id = hz_utility_v2pub.program_application_id,

931: last_updated_by = hz_utility_v2pub.last_updated_by,
932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,
936: program_update_date = hz_utility_v2pub.program_update_date
937: WHERE party_id = l_party_id;
938:
939: END IF; -- Only if address is not a Remit to.

Line 936: program_update_date = hz_utility_v2pub.program_update_date

932: last_update_login = hz_utility_v2pub.last_update_login,
933: request_id = hz_utility_v2pub.request_id,
934: program_id = hz_utility_v2pub.program_id,
935: program_application_id = hz_utility_v2pub.program_application_id,
936: program_update_date = hz_utility_v2pub.program_update_date
937: WHERE party_id = l_party_id;
938:
939: END IF; -- Only if address is not a Remit to.
940: END LOOP;

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

973:
974:
975: -- Debug info.
976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'do_update_location (-)',
978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;
981:

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

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

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

1204: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
1205: -- Bug 2197181: Added below condition for Mix-n-Match
1206: g_loc_is_datasource_selected = 'Y'*/
1207: THEN
1208: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1209: HZ_BUSINESS_EVENT_V2PVT.create_location_event (
1210: l_location_rec);
1211: END IF;
1212:

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

1209: HZ_BUSINESS_EVENT_V2PVT.create_location_event (
1210: l_location_rec);
1211: END IF;
1212:
1213: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1214: -- populate function for integration service
1215: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1216: p_operation => 'I',
1217: p_location_id => x_location_id );

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

1224: p_count => x_msg_count,
1225: p_data => x_msg_data);
1226: -- Debug info.
1227: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1229: p_msg_data=>x_msg_data,
1230: p_msg_type=>'WARNING',
1231: p_msg_level=>fnd_log.level_exception);
1232: END IF;

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

1230: p_msg_type=>'WARNING',
1231: p_msg_level=>fnd_log.level_exception);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238:

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

1249: p_data => x_msg_data);
1250:
1251: -- Debug info.
1252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1254: p_msg_data=>x_msg_data,
1255: p_msg_type=>'ERROR',
1256: p_msg_level=>fnd_log.level_error);
1257: END IF;

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

1255: p_msg_type=>'ERROR',
1256: p_msg_level=>fnd_log.level_error);
1257: END IF;
1258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1260: p_prefix=>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_procedure);
1262: END IF;
1263:

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

1273: p_data => x_msg_data);
1274:
1275: -- Debug info.
1276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1278: p_msg_data=>x_msg_data,
1279: p_msg_type=>'UNEXPECTED ERROR',
1280: p_msg_level=>fnd_log.level_error);
1281: END IF;

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

1279: p_msg_type=>'UNEXPECTED ERROR',
1280: p_msg_level=>fnd_log.level_error);
1281: END IF;
1282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1284: p_prefix=>l_debug_prefix,
1285: p_msg_level=>fnd_log.level_procedure);
1286: END IF;
1287:

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

1302: p_data => x_msg_data);
1303:
1304: -- Debug info.
1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'SQL ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;

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

1308: p_msg_type=>'SQL ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'create_location (-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316:

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

1473: --enable_debug;
1474:
1475: -- Debug info.
1476: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1477: hz_utility_v2pub.debug(p_message=>'update_location (+)',
1478: p_prefix=>l_debug_prefix,
1479: p_msg_level=>fnd_log.level_procedure);
1480: END IF;
1481:

Line 1652: hz_utility_v2pub.debug(p_message=>'In Location Upate TimeZone Id : '|| l_location_rec.timezone_id,

1648: x_return_status => l_return_status ,
1649: x_msg_count =>l_msg_count ,
1650: x_msg_data => l_msg_data);
1651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'In Location Upate TimeZone Id : '|| l_location_rec.timezone_id,
1653: p_prefix =>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_statement);
1655: END IF;
1656: if l_return_status <> fnd_api.g_ret_sts_success

Line 1664: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',

1660: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1661: END LOOP;
1662: */--Bug#8616119
1663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',
1665: p_prefix =>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_statement);
1667: END IF;
1668: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP

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

1699: x_addr_warn_msg,
1700: x_return_status);
1701:
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
1704: p_msg_level=>fnd_log.level_procedure);
1705: END IF;
1706:
1707: AP_TCA_SUPPLIER_SYNC_PKG.SYNC_Supplier_Sites(x_return_status => x_return_status,

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

1716: RAISE fnd_api.g_exc_unexpected_error;
1717: END IF;
1718:
1719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1720: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
1721: p_msg_level=>fnd_log.level_procedure);
1722: END IF;
1723:
1724: -- Call to indicate location update to DQM

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

1737: -- Bug 2197181: Added below condition for Mix-n-Match
1738: g_loc_is_datasource_selected = 'Y'*/
1739: THEN
1740: l_old_location_rec.orig_system := p_location_rec.orig_system;
1741: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1742: HZ_BUSINESS_EVENT_V2PVT.update_location_event (
1743: l_location_rec,
1744: l_old_location_rec);
1745: END IF;

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

1743: l_location_rec,
1744: l_old_location_rec);
1745: END IF;
1746:
1747: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1748: -- populate function for integration service
1749: HZ_POPULATE_BOT_PKG.pop_hz_locations(
1750: p_operation => 'U',
1751: p_location_id => l_location_rec.location_id );

Line 1755: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1751: p_location_id => l_location_rec.location_id );
1752: END IF;
1753: END IF;
1754:
1755: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1756:
1757: -- standard call to get message count and if count is 1, get message info.
1758: FND_MSG_PUB.Count_And_Get(
1759: p_encoded => FND_API.G_FALSE,

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

1761: p_data => x_msg_data);
1762:
1763: -- Debug info.
1764: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1766: p_msg_data=>x_msg_data,
1767: p_msg_type=>'WARNING',
1768: p_msg_level=>fnd_log.level_exception);
1769: END IF;

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

1767: p_msg_type=>'WARNING',
1768: p_msg_level=>fnd_log.level_exception);
1769: END IF;
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;
1775:

Line 1783: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1779:
1780: EXCEPTION
1781: WHEN FND_API.G_EXC_ERROR THEN
1782: ROLLBACK TO update_location;
1783: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,

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

1788: p_data => x_msg_data);
1789:
1790: -- Debug info.
1791: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1793: p_msg_data=>x_msg_data,
1794: p_msg_type=>'ERROR',
1795: p_msg_level=>fnd_log.level_error);
1796: END IF;

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

1794: p_msg_type=>'ERROR',
1795: p_msg_level=>fnd_log.level_error);
1796: END IF;
1797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1799: p_prefix=>l_debug_prefix,
1800: p_msg_level=>fnd_log.level_procedure);
1801: END IF;
1802:

Line 1808: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1804: --disable_debug;
1805:
1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: ROLLBACK TO update_location;
1808: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FND_MSG_PUB.Count_And_Get(
1811: p_encoded => FND_API.G_FALSE,
1812: p_count => x_msg_count,

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

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

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

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

Line 1833: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

1829: --disable_debug;
1830:
1831: WHEN OTHERS THEN
1832: ROLLBACK TO update_location;
1833: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835:
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

1843: p_data => x_msg_data);
1844:
1845: -- Debug info.
1846: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1848: p_msg_data=>x_msg_data,
1849: p_msg_type=>'SQL ERROR',
1850: p_msg_level=>fnd_log.level_error);
1851: END IF;

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

1849: p_msg_type=>'SQL ERROR',
1850: p_msg_level=>fnd_log.level_error);
1851: END IF;
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'update_location (-)',
1854: p_prefix=>l_debug_prefix,
1855: p_msg_level=>fnd_log.level_procedure);
1856: END IF;
1857:

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

1981: --enable_debug;
1982:
1983: -- Debug info.
1984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug(p_message=>'get_location_rec (+)',
1986: p_prefix=>l_debug_prefix,
1987: p_msg_level=>fnd_log.level_procedure);
1988: END IF;
1989:

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

2007: x_location_rec.location_id := p_location_id;
2008:
2009: -- Debug info.
2010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2011: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.Select_Row (+)',
2012: p_prefix=>l_debug_prefix,
2013: p_msg_level=>fnd_log.level_procedure);
2014: END IF;
2015:

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

2083: );
2084:
2085: -- Debug info.
2086: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2087: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.select_row (-)',
2088: p_prefix=>l_debug_prefix,
2089: p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091:

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

2097: );
2098:
2099: -- Debug info.
2100: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'WARNING',
2104: p_msg_level=>fnd_log.level_exception);
2105: END IF;

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

2103: p_msg_type=>'WARNING',
2104: p_msg_level=>fnd_log.level_exception);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;
2111:

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

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

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

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

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

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

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

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

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

2175: );
2176:
2177: -- Debug info.
2178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2180: p_msg_data=>x_msg_data,
2181: p_msg_type=>'SQL ERROR',
2182: p_msg_level=>fnd_log.level_error);
2183: END IF;

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

2181: p_msg_type=>'SQL ERROR',
2182: p_msg_level=>fnd_log.level_error);
2183: END IF;
2184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2185: hz_utility_v2pub.debug(p_message=>'get_location_rec (-)',
2186: p_prefix=>l_debug_prefix,
2187: p_msg_level=>fnd_log.level_procedure);
2188: END IF;
2189: