DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on FND_MESSAGE

Line 3357: the fnd_message.get to get the message that we have assigned.

3353: end mass_awards_error_handling;
3354:
3355: --Pradeep added this procedure for bug 3934195
3356: /* Logic is first set the message name and tokens as usual and then use
3357: the fnd_message.get to get the message that we have assigned.
3358: This is to remove the hard coding and using only the messages.
3359: */
3360:
3361: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,

Line 3382: fnd_message.set_name ('GHR', 'GHR_38904_AWARD_AMT_TOO_BIG5');

3378:
3379:
3380: p_error_flg := FALSE;
3381: --Check for Maximum Amount.
3382: fnd_message.set_name ('GHR', 'GHR_38904_AWARD_AMT_TOO_BIG5');
3383:
3384: IF p_noa_code = '844' THEN
3385: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3386: fnd_message.set_token ('ALLOWED', '5%');

Line 3386: fnd_message.set_token ('ALLOWED', '5%');

3382: fnd_message.set_name ('GHR', 'GHR_38904_AWARD_AMT_TOO_BIG5');
3383:
3384: IF p_noa_code = '844' THEN
3385: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3386: fnd_message.set_token ('ALLOWED', '5%');
3387: ELSIF p_noa_code IN ('840', '841', '879') THEN
3388: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3389: fnd_message.set_token ('ALLOWED', '25%');
3390: ELSIF p_noa_code IN ('878') THEN

Line 3389: fnd_message.set_token ('ALLOWED', '25%');

3385: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3386: fnd_message.set_token ('ALLOWED', '5%');
3387: ELSIF p_noa_code IN ('840', '841', '879') THEN
3388: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3389: fnd_message.set_token ('ALLOWED', '25%');
3390: ELSIF p_noa_code IN ('878') THEN
3391: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3392: fnd_message.set_token ('ALLOWED', '35%');
3393: --bug 5482191

Line 3392: fnd_message.set_token ('ALLOWED', '35%');

3388: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3389: fnd_message.set_token ('ALLOWED', '25%');
3390: ELSIF p_noa_code IN ('878') THEN
3391: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3392: fnd_message.set_token ('ALLOWED', '35%');
3393: --bug 5482191
3394: ELSIF (p_noa_code IN ('849') and l_psi = '00' ) THEN
3395: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3396: fnd_message.set_token ('ALLOWED', '35%');

Line 3396: fnd_message.set_token ('ALLOWED', '35%');

3392: fnd_message.set_token ('ALLOWED', '35%');
3393: --bug 5482191
3394: ELSIF (p_noa_code IN ('849') and l_psi = '00' ) THEN
3395: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3396: fnd_message.set_token ('ALLOWED', '35%');
3397:
3398: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3399: l_max_allowed_amount := 25000;
3400: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');

Line 3400: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');

3396: fnd_message.set_token ('ALLOWED', '35%');
3397:
3398: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3399: l_max_allowed_amount := 25000;
3400: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');
3401: fnd_message.set_token ('ALLOWED', '$25000');
3402: END IF;
3403:
3404: /*

Line 3401: fnd_message.set_token ('ALLOWED', '$25000');

3397:
3398: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3399: l_max_allowed_amount := 25000;
3400: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');
3401: fnd_message.set_token ('ALLOWED', '$25000');
3402: END IF;
3403:
3404: /*
3405: Existing Handling of 816 and 815 is not changed make sure

Line 3417: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');

3413: l_max_allowed_amount := 50 * p_from_basic_pay_pa / 100;
3414: END IF;
3415:
3416: IF p_award_amount > l_max_allowed_amount THEN
3417: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3418: p_comments := p_comments||fnd_message.get;
3419: p_error_flg := TRUE;
3420: fnd_message.clear;
3421: END IF;

Line 3418: p_comments := p_comments||fnd_message.get;

3414: END IF;
3415:
3416: IF p_award_amount > l_max_allowed_amount THEN
3417: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3418: p_comments := p_comments||fnd_message.get;
3419: p_error_flg := TRUE;
3420: fnd_message.clear;
3421: END IF;
3422: ELSIF ( ghr_pay_calc.leo_position (

Line 3420: fnd_message.clear;

3416: IF p_award_amount > l_max_allowed_amount THEN
3417: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3418: p_comments := p_comments||fnd_message.get;
3419: p_error_flg := TRUE;
3420: fnd_message.clear;
3421: END IF;
3422: ELSIF ( ghr_pay_calc.leo_position (
3423: p_prd => l_temp,
3424: p_position_id=> p_to_position_id,

Line 3436: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');

3432: IF l_max_allowed_amount < 15000 THEN
3433: l_max_allowed_amount := 15000;
3434: END IF;
3435: IF p_award_amount > l_max_allowed_amount THEN
3436: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');
3437: p_comments := p_comments||fnd_message.get;
3438: p_error_flg := TRUE;
3439: fnd_message.clear;
3440: END IF;

Line 3437: p_comments := p_comments||fnd_message.get;

3433: l_max_allowed_amount := 15000;
3434: END IF;
3435: IF p_award_amount > l_max_allowed_amount THEN
3436: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');
3437: p_comments := p_comments||fnd_message.get;
3438: p_error_flg := TRUE;
3439: fnd_message.clear;
3440: END IF;
3441: ELSIF ( NOT ghr_pay_calc.leo_position (

Line 3439: fnd_message.clear;

3435: IF p_award_amount > l_max_allowed_amount THEN
3436: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');
3437: p_comments := p_comments||fnd_message.get;
3438: p_error_flg := TRUE;
3439: fnd_message.clear;
3440: END IF;
3441: ELSIF ( NOT ghr_pay_calc.leo_position (
3442: p_prd => l_temp,
3443: p_position_id=> p_to_position_id,

Line 3452: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');

3448: ) THEN
3449: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3450:
3451: IF p_award_amount > l_max_allowed_amount THEN
3452: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3453: p_comments := p_comments||fnd_message.get;
3454: p_error_flg := TRUE;
3455: fnd_message.clear;
3456: END IF;

Line 3453: p_comments := p_comments||fnd_message.get;

3449: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3450:
3451: IF p_award_amount > l_max_allowed_amount THEN
3452: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3453: p_comments := p_comments||fnd_message.get;
3454: p_error_flg := TRUE;
3455: fnd_message.clear;
3456: END IF;
3457: END IF;

Line 3455: fnd_message.clear;

3451: IF p_award_amount > l_max_allowed_amount THEN
3452: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3453: p_comments := p_comments||fnd_message.get;
3454: p_error_flg := TRUE;
3455: fnd_message.clear;
3456: END IF;
3457: END IF;
3458: ELSIF p_noa_code = '815' THEN
3459: IF p_from_pay_plan = 'EE' THEN

Line 3467: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');

3463: l_max_allowed_amount := 50 * p_from_basic_pay_pa / 100;
3464: END IF;
3465:
3466: IF p_award_amount > l_max_allowed_amount THEN
3467: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3468: p_comments := p_comments||fnd_message.get;
3469: p_error_flg := TRUE;
3470: fnd_message.clear;
3471: END IF;

Line 3468: p_comments := p_comments||fnd_message.get;

3464: END IF;
3465:
3466: IF p_award_amount > l_max_allowed_amount THEN
3467: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3468: p_comments := p_comments||fnd_message.get;
3469: p_error_flg := TRUE;
3470: fnd_message.clear;
3471: END IF;
3472: ELSE

Line 3470: fnd_message.clear;

3466: IF p_award_amount > l_max_allowed_amount THEN
3467: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3468: p_comments := p_comments||fnd_message.get;
3469: p_error_flg := TRUE;
3470: fnd_message.clear;
3471: END IF;
3472: ELSE
3473: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3474: fnd_message.set_token ('ALLOWED', '25%');

Line 3474: fnd_message.set_token ('ALLOWED', '25%');

3470: fnd_message.clear;
3471: END IF;
3472: ELSE
3473: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3474: fnd_message.set_token ('ALLOWED', '25%');
3475: p_comments := p_comments||fnd_message.get;
3476: p_error_flg := TRUE;
3477: fnd_message.clear;
3478: END IF;

Line 3475: p_comments := p_comments||fnd_message.get;

3471: END IF;
3472: ELSE
3473: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3474: fnd_message.set_token ('ALLOWED', '25%');
3475: p_comments := p_comments||fnd_message.get;
3476: p_error_flg := TRUE;
3477: fnd_message.clear;
3478: END IF;
3479: END IF;

Line 3477: fnd_message.clear;

3473: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3474: fnd_message.set_token ('ALLOWED', '25%');
3475: p_comments := p_comments||fnd_message.get;
3476: p_error_flg := TRUE;
3477: fnd_message.clear;
3478: END IF;
3479: END IF;
3480:
3481: -- Raise an Error if Award Amount is Greater than the Maximum Allowed Amount.

Line 3485: p_comments := fnd_message.get;

3481: -- Raise an Error if Award Amount is Greater than the Maximum Allowed Amount.
3482: --IF p_award_amount > round(l_max_allowed_amount) THEN
3483:
3484: IF p_award_amount > floor(l_max_allowed_amount) THEN
3485: p_comments := fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.CLEAR;
3488: ELSE
3489: fnd_message.CLEAR;

Line 3487: fnd_message.CLEAR;

3483:
3484: IF p_award_amount > floor(l_max_allowed_amount) THEN
3485: p_comments := fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.CLEAR;
3488: ELSE
3489: fnd_message.CLEAR;
3490: END IF;
3491:

Line 3489: fnd_message.CLEAR;

3485: p_comments := fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.CLEAR;
3488: ELSE
3489: fnd_message.CLEAR;
3490: END IF;
3491:
3492: --Check for Minimum Amount.
3493: fnd_message.set_name ('GHR', 'GHR_38903_AWARD_AMT_TOO_LESS');

Line 3493: fnd_message.set_name ('GHR', 'GHR_38903_AWARD_AMT_TOO_LESS');

3489: fnd_message.CLEAR;
3490: END IF;
3491:
3492: --Check for Minimum Amount.
3493: fnd_message.set_name ('GHR', 'GHR_38903_AWARD_AMT_TOO_LESS');
3494:
3495: --Getting the Minimum Allowed Amount.
3496: IF p_noa_code = '879' THEN
3497: l_min_allowed_amount := 5 * p_from_basic_pay_pa / 100;

Line 3498: fnd_message.set_token ('ALLOWED', '5%');

3494:
3495: --Getting the Minimum Allowed Amount.
3496: IF p_noa_code = '879' THEN
3497: l_min_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3498: fnd_message.set_token ('ALLOWED', '5%');
3499: END IF;
3500:
3501: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3502: IF p_award_amount < trunc(l_min_allowed_amount) THEN

Line 3503: p_comments := fnd_message.get;

3499: END IF;
3500:
3501: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3502: IF p_award_amount < trunc(l_min_allowed_amount) THEN
3503: p_comments := fnd_message.get;
3504: p_error_flg := TRUE;
3505: fnd_message.clear;
3506: ELSE
3507: fnd_message.clear;

Line 3505: fnd_message.clear;

3501: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3502: IF p_award_amount < trunc(l_min_allowed_amount) THEN
3503: p_comments := fnd_message.get;
3504: p_error_flg := TRUE;
3505: fnd_message.clear;
3506: ELSE
3507: fnd_message.clear;
3508: END IF;
3509:

Line 3507: fnd_message.clear;

3503: p_comments := fnd_message.get;
3504: p_error_flg := TRUE;
3505: fnd_message.clear;
3506: ELSE
3507: fnd_message.clear;
3508: END IF;
3509:
3510: END check_award_amount;
3511: