DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on FND_MESSAGE

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

2313: WHEN gl_currency_api.no_rate THEN
2314: IF p_called_FROM = 'PNTAUPMT' THEN
2315: NULL;
2316: ELSE
2317: fnd_message.set_name('PN','PN_EXP_NO_RATE');
2318: app_exception.raise_exception;
2319: END IF;
2320: WHEN gl_currency_api.invalid_currency THEN
2321: IF p_called_FROM = 'PNTAUPMT' THEN

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

2320: WHEN gl_currency_api.invalid_currency THEN
2321: IF p_called_FROM = 'PNTAUPMT' THEN
2322: NULL;
2323: ELSE
2324: fnd_message.set_name('PN','PN_EXP_INVALID_CURRENCY');
2325: app_exception.raise_exception;
2326: END IF;
2327: WHEN OTHERS THEN
2328: IF p_called_FROM = 'PNTAUPMT' THEN

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

3051: PNP_DEBUG_PKG.log('Invalid PARAM passed.');
3052: RETURN FALSE;
3053:
3054: WHEN INVALID_TERMINATION_DATE THEN
3055: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');
3056: RETURN FALSE;
3057:
3058: WHEN OTHERS THEN
3059: PNP_DEBUG_PKG.log('Something went wrong here!! - '||SQLCODE||': '||SQLERRM);

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

3093: RETURN TRUE;
3094: END IF;
3095: EXCEPTION
3096: WHEN INVALID_TERMINATION_DATE THEN
3097: fnd_message.set_name ('PN', 'PN_INVALID_TERMINATE_DATE');
3098: RETURN FALSE;
3099: END validate_lease_terminate_date;
3100:
3101: /*============================================================================+

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

6298: FOR rec IN get_common_flag LOOP
6299: l_common_flag := rec.common_area_flag;
6300: END LOOP;
6301: IF l_common_flag = 'Y' THEN
6302: fnd_message.set_name('PN', 'PN_CANNOT_ASSIGN_SPC_COMM');
6303: fnd_message.set_token('LOCATION_ID', p_location_id);
6304: p_available_vacant_area := FALSE;
6305: p_future := 'N';
6306: RETURN;

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

6299: l_common_flag := rec.common_area_flag;
6300: END LOOP;
6301: IF l_common_flag = 'Y' THEN
6302: fnd_message.set_name('PN', 'PN_CANNOT_ASSIGN_SPC_COMM');
6303: fnd_message.set_token('LOCATION_ID', p_location_id);
6304: p_available_vacant_area := FALSE;
6305: p_future := 'N';
6306: RETURN;
6307: END IF;

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

6354: (NVL(l_new_allocated_area_pct,0) - NVL(l_old_allocated_area_pct,0)
6355: > 100 - NVL(l_total_allocated_area_pct,0))
6356: THEN
6357: p_available_vacant_area := FALSE;
6358: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6359: ELSE
6360: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6361: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6362: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));

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

6357: p_available_vacant_area := FALSE;
6358: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6359: ELSE
6360: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6361: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6362: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));
6363: p_future := l_future;
6364: END IF;
6365: p_available_vacant_area := TRUE;

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

6358: fnd_message.set_name ('PN','PN_AREA_UNAVAILABLE');
6359: ELSE
6360: IF ( (NVL(l_future, 'N') = 'Y') AND (p_display_message = 'Y') ) THEN
6361: fnd_message.set_name ('PN','PN_FUTURE_ASGN_DT_MSG');
6362: fnd_message.set_token ('L_FUTURE_ASGN_DT', to_char(p_end_dt));
6363: p_future := l_future;
6364: END IF;
6365: p_available_vacant_area := TRUE;
6366: END IF;

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

7206: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7207:
7208: EXCEPTION
7209: WHEN OTHERS THEN
7210: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7211: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7213: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7214:

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

7207:
7208: EXCEPTION
7209: WHEN OTHERS THEN
7210: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7211: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7213: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7214:
7215:

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

7348: EXCEPTION
7349:
7350: WHEN USER_DEF_ERROR THEN
7351: x_return_status := FND_API.G_RET_STS_ERROR;
7352: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7353: PNP_DEBUG_PKG.log('Assignment found for dates');
7354:
7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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

7352: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7353: PNP_DEBUG_PKG.log('Assignment found for dates');
7354:
7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7357: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7359: PNP_DEBUG_PKG.log('OTHERS ERROR');
7360:

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

7353: PNP_DEBUG_PKG.log('Assignment found for dates');
7354:
7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7357: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7359: PNP_DEBUG_PKG.log('OTHERS ERROR');
7360:
7361: END validate_assignment_for_date;

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

7517: x_return_status := FND_API.G_RET_STS_ERROR;
7518: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7519:
7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7522: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7524: PNP_DEBUG_PKG.log('OTHERS ERROR');
7525:

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

7518: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7519:
7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7522: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7524: PNP_DEBUG_PKG.log('OTHERS ERROR');
7525:
7526: END validate_assignable_area;

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

7657: x_return_status := FND_API.G_RET_STS_ERROR;
7658: PNP_DEBUG_PKG.disable_file_debug;
7659:
7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7662: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7664: PNP_DEBUG_PKG.disable_file_debug;
7665:

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

7658: PNP_DEBUG_PKG.disable_file_debug;
7659:
7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7662: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7664: PNP_DEBUG_PKG.disable_file_debug;
7665:
7666: END validate_date_assignable_area;

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

7730: EXIT;
7731: END LOOP;
7732:
7733: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7734: fnd_message.set_name('PN','PN_INVALID_SPACE_ASSIGN_DATE');
7735: END IF;
7736: END Validate_date_for_Assignments;
7737:
7738: -------------------------------------------------------------------------------

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

8597: pnp_debug_pkg.log('check_var_rent_retro - (-)');
8598: EXCEPTION
8599:
8600: WHEN RETRO_VARENT_EXCEPTION THEN
8601: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');
8602: fnd_message.set_token('VAR_RENT_NUM', l_var_rent_num);
8603: p_error := TRUE;
8604: RETURN;
8605:

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

8598: EXCEPTION
8599:
8600: WHEN RETRO_VARENT_EXCEPTION THEN
8601: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');
8602: fnd_message.set_token('VAR_RENT_NUM', l_var_rent_num);
8603: p_error := TRUE;
8604: RETURN;
8605:
8606: WHEN others THEN