DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on FND_MESSAGE

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

3385: end mass_awards_error_handling;
3386:
3387: --Pradeep added this procedure for bug 3934195
3388: /* Logic is first set the message name and tokens as usual and then use
3389: the fnd_message.get to get the message that we have assigned.
3390: This is to remove the hard coding and using only the messages.
3391: */
3392:
3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,

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

3410:
3411:
3412: p_error_flg := FALSE;
3413: --Check for Maximum Amount.
3414: fnd_message.set_name ('GHR', 'GHR_38904_AWARD_AMT_TOO_BIG5');
3415:
3416: IF p_noa_code = '844' THEN
3417: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3418: fnd_message.set_token ('ALLOWED', '5%');

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

3414: fnd_message.set_name ('GHR', 'GHR_38904_AWARD_AMT_TOO_BIG5');
3415:
3416: IF p_noa_code = '844' THEN
3417: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3418: fnd_message.set_token ('ALLOWED', '5%');
3419: ELSIF p_noa_code IN ('840', '841', '879') THEN
3420: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3421: fnd_message.set_token ('ALLOWED', '25%');
3422: ELSIF p_noa_code IN ('878') THEN

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

3417: l_max_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3418: fnd_message.set_token ('ALLOWED', '5%');
3419: ELSIF p_noa_code IN ('840', '841', '879') THEN
3420: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3421: fnd_message.set_token ('ALLOWED', '25%');
3422: ELSIF p_noa_code IN ('878') THEN
3423: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3424: fnd_message.set_token ('ALLOWED', '35%');
3425: --bug 5482191

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

3420: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3421: fnd_message.set_token ('ALLOWED', '25%');
3422: ELSIF p_noa_code IN ('878') THEN
3423: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3424: fnd_message.set_token ('ALLOWED', '35%');
3425: --bug 5482191
3426: ELSIF (p_noa_code IN ('849') and l_psi = '00' ) THEN
3427: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3428: fnd_message.set_token ('ALLOWED', '35%');

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

3424: fnd_message.set_token ('ALLOWED', '35%');
3425: --bug 5482191
3426: ELSIF (p_noa_code IN ('849') and l_psi = '00' ) THEN
3427: l_max_allowed_amount := 35 * p_from_basic_pay_pa / 100;
3428: fnd_message.set_token ('ALLOWED', '35%');
3429:
3430: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3431: l_max_allowed_amount := 25000;
3432: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');

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

3428: fnd_message.set_token ('ALLOWED', '35%');
3429:
3430: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3431: l_max_allowed_amount := 25000;
3432: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');
3433: fnd_message.set_token ('ALLOWED', '$25000');
3434: END IF;
3435:
3436: /*

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

3429:
3430: ELSIF p_noa_code IN ('825', '842', '843', '848') THEN
3431: l_max_allowed_amount := 25000;
3432: fnd_message.set_name ('GHR', 'GHR_38905_AWARD_AMT_TOO_BIG6');
3433: fnd_message.set_token ('ALLOWED', '$25000');
3434: END IF;
3435:
3436: /*
3437: Existing Handling of 816 and 815 is not changed make sure

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

3445: l_max_allowed_amount := 50 * p_from_basic_pay_pa / 100;
3446: END IF;
3447:
3448: IF p_award_amount > l_max_allowed_amount THEN
3449: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3450: p_comments := p_comments||fnd_message.get;
3451: p_error_flg := TRUE;
3452: fnd_message.clear;
3453: END IF;

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

3446: END IF;
3447:
3448: IF p_award_amount > l_max_allowed_amount THEN
3449: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3450: p_comments := p_comments||fnd_message.get;
3451: p_error_flg := TRUE;
3452: fnd_message.clear;
3453: END IF;
3454: ELSIF ( ghr_pay_calc.leo_position (

Line 3452: fnd_message.clear;

3448: IF p_award_amount > l_max_allowed_amount THEN
3449: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3450: p_comments := p_comments||fnd_message.get;
3451: p_error_flg := TRUE;
3452: fnd_message.clear;
3453: END IF;
3454: ELSIF ( ghr_pay_calc.leo_position (
3455: p_prd => l_temp,
3456: p_position_id=> p_to_position_id,

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

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

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

3465: l_max_allowed_amount := 15000;
3466: END IF;
3467: IF p_award_amount > l_max_allowed_amount THEN
3468: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');
3469: p_comments := p_comments||fnd_message.get;
3470: p_error_flg := TRUE;
3471: fnd_message.clear;
3472: END IF;
3473: ELSIF ( NOT ghr_pay_calc.leo_position (

Line 3471: fnd_message.clear;

3467: IF p_award_amount > l_max_allowed_amount THEN
3468: fnd_message.set_name ('GHR', 'GHR_38896_AWARD_AMT_TOO_BIG2');
3469: p_comments := p_comments||fnd_message.get;
3470: p_error_flg := TRUE;
3471: fnd_message.clear;
3472: END IF;
3473: ELSIF ( NOT ghr_pay_calc.leo_position (
3474: p_prd => l_temp,
3475: p_position_id=> p_to_position_id,

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

3480: ) THEN
3481: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3482:
3483: IF p_award_amount > l_max_allowed_amount THEN
3484: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3485: p_comments := p_comments||fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.clear;
3488: END IF;

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

3481: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3482:
3483: IF p_award_amount > l_max_allowed_amount THEN
3484: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3485: p_comments := p_comments||fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.clear;
3488: END IF;
3489: END IF;

Line 3487: fnd_message.clear;

3483: IF p_award_amount > l_max_allowed_amount THEN
3484: fnd_message.set_name ('GHR', 'GHR_AWARD_AMT_TOO_BIG');
3485: p_comments := p_comments||fnd_message.get;
3486: p_error_flg := TRUE;
3487: fnd_message.clear;
3488: END IF;
3489: END IF;
3490: ELSIF p_noa_code = '815' THEN
3491: IF p_from_pay_plan = 'EE' THEN

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

3495: l_max_allowed_amount := 50 * p_from_basic_pay_pa / 100;
3496: END IF;
3497:
3498: IF p_award_amount > l_max_allowed_amount THEN
3499: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3500: p_comments := p_comments||fnd_message.get;
3501: p_error_flg := TRUE;
3502: fnd_message.clear;
3503: END IF;

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

3496: END IF;
3497:
3498: IF p_award_amount > l_max_allowed_amount THEN
3499: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3500: p_comments := p_comments||fnd_message.get;
3501: p_error_flg := TRUE;
3502: fnd_message.clear;
3503: END IF;
3504: ELSE

Line 3502: fnd_message.clear;

3498: IF p_award_amount > l_max_allowed_amount THEN
3499: fnd_message.set_name ('GHR', 'GHR_38898_AWARD_AMT_TOO_BIG3');
3500: p_comments := p_comments||fnd_message.get;
3501: p_error_flg := TRUE;
3502: fnd_message.clear;
3503: END IF;
3504: ELSE
3505: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3506: fnd_message.set_token ('ALLOWED', '25%');

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

3502: fnd_message.clear;
3503: END IF;
3504: ELSE
3505: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3506: fnd_message.set_token ('ALLOWED', '25%');
3507: p_comments := p_comments||fnd_message.get;
3508: p_error_flg := TRUE;
3509: fnd_message.clear;
3510: END IF;

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

3503: END IF;
3504: ELSE
3505: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3506: fnd_message.set_token ('ALLOWED', '25%');
3507: p_comments := p_comments||fnd_message.get;
3508: p_error_flg := TRUE;
3509: fnd_message.clear;
3510: END IF;
3511: END IF;

Line 3509: fnd_message.clear;

3505: l_max_allowed_amount := 25 * p_from_basic_pay_pa / 100;
3506: fnd_message.set_token ('ALLOWED', '25%');
3507: p_comments := p_comments||fnd_message.get;
3508: p_error_flg := TRUE;
3509: fnd_message.clear;
3510: END IF;
3511: END IF;
3512:
3513: -- Raise an Error if Award Amount is Greater than the Maximum Allowed Amount.

Line 3517: p_comments := fnd_message.get;

3513: -- Raise an Error if Award Amount is Greater than the Maximum Allowed Amount.
3514: --IF p_award_amount > round(l_max_allowed_amount) THEN
3515:
3516: IF p_award_amount > floor(l_max_allowed_amount) THEN
3517: p_comments := fnd_message.get;
3518: p_error_flg := TRUE;
3519: fnd_message.CLEAR;
3520: ELSE
3521: fnd_message.CLEAR;

Line 3519: fnd_message.CLEAR;

3515:
3516: IF p_award_amount > floor(l_max_allowed_amount) THEN
3517: p_comments := fnd_message.get;
3518: p_error_flg := TRUE;
3519: fnd_message.CLEAR;
3520: ELSE
3521: fnd_message.CLEAR;
3522: END IF;
3523:

Line 3521: fnd_message.CLEAR;

3517: p_comments := fnd_message.get;
3518: p_error_flg := TRUE;
3519: fnd_message.CLEAR;
3520: ELSE
3521: fnd_message.CLEAR;
3522: END IF;
3523:
3524: --Check for Minimum Amount.
3525: fnd_message.set_name ('GHR', 'GHR_38903_AWARD_AMT_TOO_LESS');

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

3521: fnd_message.CLEAR;
3522: END IF;
3523:
3524: --Check for Minimum Amount.
3525: fnd_message.set_name ('GHR', 'GHR_38903_AWARD_AMT_TOO_LESS');
3526:
3527: --Getting the Minimum Allowed Amount.
3528: IF p_noa_code = '879' THEN
3529: l_min_allowed_amount := 5 * p_from_basic_pay_pa / 100;

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

3526:
3527: --Getting the Minimum Allowed Amount.
3528: IF p_noa_code = '879' THEN
3529: l_min_allowed_amount := 5 * p_from_basic_pay_pa / 100;
3530: fnd_message.set_token ('ALLOWED', '5%');
3531: END IF;
3532:
3533: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3534: IF p_award_amount < trunc(l_min_allowed_amount) THEN

Line 3535: p_comments := fnd_message.get;

3531: END IF;
3532:
3533: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3534: IF p_award_amount < trunc(l_min_allowed_amount) THEN
3535: p_comments := fnd_message.get;
3536: p_error_flg := TRUE;
3537: fnd_message.clear;
3538: ELSE
3539: fnd_message.clear;

Line 3537: fnd_message.clear;

3533: -- Raise an Error if Award Amount is Less than the Minimum Allowed Amount.
3534: IF p_award_amount < trunc(l_min_allowed_amount) THEN
3535: p_comments := fnd_message.get;
3536: p_error_flg := TRUE;
3537: fnd_message.clear;
3538: ELSE
3539: fnd_message.clear;
3540: END IF;
3541:

Line 3539: fnd_message.clear;

3535: p_comments := fnd_message.get;
3536: p_error_flg := TRUE;
3537: fnd_message.clear;
3538: ELSE
3539: fnd_message.clear;
3540: END IF;
3541:
3542: END check_award_amount;
3543: