DBA Data[Home] [Help]

APPS.HZ_GNR_PUB dependencies on HZ_GNR_PKG

Line 55: HZ_GNR_PKG.delete_gnr(

51:
52: IF upper(p_location_table_name) = 'HR_LOCATIONS_ALL' THEN
53:
54: IF p_call_type = 'U' THEN
55: HZ_GNR_PKG.delete_gnr(
56: p_locId => p_location_id,
57: p_locTbl => upper(p_location_table_name),
58: x_status => l_return_status
59: );

Line 61: HZ_GNR_PKG.validateHrLoc(

57: p_locTbl => upper(p_location_table_name),
58: x_status => l_return_status
59: );
60: END IF;
61: HZ_GNR_PKG.validateHrLoc(
62: P_LOCATION_ID => p_location_id,
63: X_STATUS => l_return_status);
64:
65: ELSIF upper(p_location_table_name) = 'HZ_LOCATIONS' THEN

Line 68: HZ_GNR_PKG.delete_gnr(

64:
65: ELSIF upper(p_location_table_name) = 'HZ_LOCATIONS' THEN
66:
67: IF p_call_type = 'U' THEN
68: HZ_GNR_PKG.delete_gnr(
69: p_locId => p_location_id,
70: p_locTbl => upper(p_location_table_name),
71: x_status => l_return_status
72: );

Line 76: HZ_GNR_PKG.validateLoc(

72: );
73: END IF;
74:
75: FOR l_c_loc_hz in c_loc_hz(p_location_id) LOOP
76: HZ_GNR_PKG.validateLoc(
77: P_LOCATION_ID => l_c_loc_hz.LOCATION_ID,
78: P_USAGE_CODE => 'ALL',
79: P_ADDRESS_STYLE => l_c_loc_hz.ADDRESS_STYLE,
80: P_COUNTRY => l_c_loc_hz.COUNTRY,

Line 293: HZ_GNR_PKG.validateLoc(

289:
290: -- read the count of messages already stacked before doing validation
291: l_msg_count_before := NVL(fnd_msg_pub.Count_Msg,0);
292:
293: HZ_GNR_PKG.validateLoc(
294: P_LOCATION_ID => P_LOCATION_ID,
295: P_USAGE_CODE => P_USAGE_CODE,
296: P_ADDRESS_STYLE => P_ADDRESS_STYLE,
297: P_COUNTRY => P_COUNTRY,

Line 328: (p_message => 'After HZ_GNR_PKG.validateLoc. l_msg_count_before:'||

324:
325: -- FND Logging for debug purpose
326: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
327: hz_utility_v2pub.debug
328: (p_message => 'After HZ_GNR_PKG.validateLoc. l_msg_count_before:'||
329: l_msg_count_before||':l_msg_count_after:'||l_msg_count_after||
330: ':x_return_status:'||x_return_status||':x_addr_val_status:'||
331: x_addr_val_status,
332: p_prefix => l_debug_prefix,