DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on FND_MESSAGE

Line 2162: fnd_message.set_name('PN','PN_EXP_NO_RATE');

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

Line 2169: fnd_message.set_name('PN','PN_EXP_INVALID_CURRENCY');

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

Line 2900: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');

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);

Line 2942: fnd_message.set_name ('PN', 'PN_INVALID_TERMINATE_DATE');

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: /*============================================================================+

Line 6141: fnd_message.set_name('PN', 'PN_CANNOT_ASSIGN_SPC_COMM');

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;

Line 6142: fnd_message.set_token('LOCATION_ID', p_location_id);

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;

Line 6197: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');

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));

Line 6200: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');

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;

Line 6201: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));

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;

Line 7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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:

Line 7050: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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:

Line 7191: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');

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');

Line 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:

Line 7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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;

Line 7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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:

Line 7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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;

Line 7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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:

Line 7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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;

Line 7567: fnd_message.set_name('PN','PN_INVALID_SPACE_ASSIGN_DATE');

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: -------------------------------------------------------------------------------

Line 8433: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');

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:

Line 8434: fnd_message.set_token('VAR_RENT_NUM', l_var_rent_num);

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