2158: WHEN gl_currency_api.no_rate THEN
2159: IF p_called_FROM = 'PNTAUPMT' THEN
2160: NULL;
2161: ELSE
2162: fnd_message.set_name('PN','PN_EXP_NO_RATE');
2163: app_exception.raise_exception;
2164: END IF;
2165: WHEN gl_currency_api.invalid_currency THEN
2166: IF p_called_FROM = 'PNTAUPMT' THEN
2165: WHEN gl_currency_api.invalid_currency THEN
2166: IF p_called_FROM = 'PNTAUPMT' THEN
2167: NULL;
2168: ELSE
2169: fnd_message.set_name('PN','PN_EXP_INVALID_CURRENCY');
2170: app_exception.raise_exception;
2171: END IF;
2172: WHEN OTHERS THEN
2173: IF p_called_FROM = 'PNTAUPMT' THEN
2896: PNP_DEBUG_PKG.log('Invalid PARAM passed.');
2897: RETURN FALSE;
2898:
2899: WHEN INVALID_TERMINATION_DATE THEN
2900: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');
2901: RETURN FALSE;
2902:
2903: WHEN OTHERS THEN
2904: PNP_DEBUG_PKG.log('Something went wrong here!! - '||SQLCODE||': '||SQLERRM);
2938: RETURN TRUE;
2939: END IF;
2940: EXCEPTION
2941: WHEN INVALID_TERMINATION_DATE THEN
2942: fnd_message.set_name ('PN', 'PN_INVALID_TERMINATE_DATE');
2943: RETURN FALSE;
2944: END validate_lease_terminate_date;
2945:
2946: /*============================================================================+
6137: FOR rec IN get_common_flag LOOP
6138: l_common_flag := rec.common_area_flag;
6139: END LOOP;
6140: IF l_common_flag = 'Y' THEN
6141: fnd_message.set_name('PN', 'PN_CANNOT_ASSIGN_SPC_COMM');
6142: fnd_message.set_token('LOCATION_ID', p_location_id);
6143: p_available_vacant_area := FALSE;
6144: p_future := 'N';
6145: RETURN;
6138: l_common_flag := rec.common_area_flag;
6139: END LOOP;
6140: IF l_common_flag = 'Y' THEN
6141: fnd_message.set_name('PN', 'PN_CANNOT_ASSIGN_SPC_COMM');
6142: fnd_message.set_token('LOCATION_ID', p_location_id);
6143: p_available_vacant_area := FALSE;
6144: p_future := 'N';
6145: RETURN;
6146: END IF;
6193: (NVL(l_new_allocated_area_pct,0) - NVL(l_old_allocated_area_pct,0)
6194: > 100 - NVL(l_total_allocated_area_pct,0))
6195: THEN
6196: p_available_vacant_area := FALSE;
6197: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6198: ELSE
6199: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6200: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6201: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));
6196: p_available_vacant_area := FALSE;
6197: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6198: ELSE
6199: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6200: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6201: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));
6202: p_future := l_future;
6203: END IF;
6204: p_available_vacant_area := TRUE;
6197: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6198: ELSE
6199: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6200: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6201: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));
6202: p_future := l_future;
6203: END IF;
6204: p_available_vacant_area := TRUE;
6205: END IF;
7045: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7046:
7047: EXCEPTION
7048: WHEN OTHERS THEN
7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7050: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7053:
7046:
7047: EXCEPTION
7048: WHEN OTHERS THEN
7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7050: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7053:
7054:
7187: EXCEPTION
7188:
7189: WHEN USER_DEF_ERROR THEN
7190: x_return_status := FND_API.G_RET_STS_ERROR;
7191: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7192: PNP_DEBUG_PKG.log('Assignment found for dates');
7193:
7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7191: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7192: PNP_DEBUG_PKG.log('Assignment found for dates');
7193:
7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7198: PNP_DEBUG_PKG.log('OTHERS ERROR');
7199:
7192: PNP_DEBUG_PKG.log('Assignment found for dates');
7193:
7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7198: PNP_DEBUG_PKG.log('OTHERS ERROR');
7199:
7200: END validate_assignment_for_date;
7356: x_return_status := FND_API.G_RET_STS_ERROR;
7357: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7358:
7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7363: PNP_DEBUG_PKG.log('OTHERS ERROR');
7364:
7357: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7358:
7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7363: PNP_DEBUG_PKG.log('OTHERS ERROR');
7364:
7365: END validate_assignable_area;
7496: x_return_status := FND_API.G_RET_STS_ERROR;
7497: PNP_DEBUG_PKG.disable_file_debug;
7498:
7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7503: PNP_DEBUG_PKG.disable_file_debug;
7504:
7497: PNP_DEBUG_PKG.disable_file_debug;
7498:
7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7503: PNP_DEBUG_PKG.disable_file_debug;
7504:
7505: END validate_date_assignable_area;
7563: EXIT;
7564: END LOOP;
7565:
7566: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7567: fnd_message.set_name('PN','PN_INVALID_SPACE_ASSIGN_DATE');
7568: END IF;
7569: END Validate_date_for_Assignments;
7570:
7571: -------------------------------------------------------------------------------
8429: pnp_debug_pkg.log('check_var_rent_retro - (-)');
8430: EXCEPTION
8431:
8432: WHEN RETRO_VARENT_EXCEPTION THEN
8433: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');
8434: fnd_message.set_token('VAR_RENT_NUM', l_var_rent_num);
8435: p_error := TRUE;
8436: RETURN;
8437:
8430: EXCEPTION
8431:
8432: WHEN RETRO_VARENT_EXCEPTION THEN
8433: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');
8434: fnd_message.set_token('VAR_RENT_NUM', l_var_rent_num);
8435: p_error := TRUE;
8436: RETURN;
8437:
8438: WHEN others THEN