eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_POST_PROCESS dependencies on FND_MESSAGE

Line 2525: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');

2521: IF(l_effective_date IS NULL AND p_use_rate_start_date = 'Y') THEN
2522: g_actn :=
2523: 'The salary is not posted as no rate start date is defined.';
2524: WRITE (g_actn);
2525: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2526: l_message := fnd_message.get_encoded;
2527: fnd_message.set_encoded(l_message);
2528: --
2529: fnd_message.parse_encoded(encoded_message => l_message,

Line 2526: l_message := fnd_message.get_encoded;

2522: g_actn :=
2523: 'The salary is not posted as no rate start date is defined.';
2524: WRITE (g_actn);
2525: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2526: l_message := fnd_message.get_encoded;
2527: fnd_message.set_encoded(l_message);
2528: --
2529: fnd_message.parse_encoded(encoded_message => l_message,
2530: app_short_name => l_app_name,

Line 2527: fnd_message.set_encoded(l_message);

2523: 'The salary is not posted as no rate start date is defined.';
2524: WRITE (g_actn);
2525: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2526: l_message := fnd_message.get_encoded;
2527: fnd_message.set_encoded(l_message);
2528: --
2529: fnd_message.parse_encoded(encoded_message => l_message,
2530: app_short_name => l_app_name,
2531: message_name => l_message_name);

Line 2529: fnd_message.parse_encoded(encoded_message => l_message,

2525: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2526: l_message := fnd_message.get_encoded;
2527: fnd_message.set_encoded(l_message);
2528: --
2529: fnd_message.parse_encoded(encoded_message => l_message,
2530: app_short_name => l_app_name,
2531: message_name => l_message_name);
2532: IF g_person_errored = FALSE THEN
2533: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2533: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2529: fnd_message.parse_encoded(encoded_message => l_message,
2530: app_short_name => l_app_name,
2531: message_name => l_message_name);
2532: IF g_person_errored = FALSE THEN
2533: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2534: END IF;
2535: l_error := TRUE;
2536: g_person_errored := TRUE;
2537: END IF;

Line 2580: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');

2576: ELSE
2577: g_actn :=
2578: 'The salary is not posted as no pay basis is defined.';
2579: WRITE (g_actn);
2580: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2581: l_message := fnd_message.get_encoded;
2582: fnd_message.set_encoded(l_message);
2583: --
2584: fnd_message.parse_encoded(encoded_message => l_message,

Line 2581: l_message := fnd_message.get_encoded;

2577: g_actn :=
2578: 'The salary is not posted as no pay basis is defined.';
2579: WRITE (g_actn);
2580: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2581: l_message := fnd_message.get_encoded;
2582: fnd_message.set_encoded(l_message);
2583: --
2584: fnd_message.parse_encoded(encoded_message => l_message,
2585: app_short_name => l_app_name,

Line 2582: fnd_message.set_encoded(l_message);

2578: 'The salary is not posted as no pay basis is defined.';
2579: WRITE (g_actn);
2580: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2581: l_message := fnd_message.get_encoded;
2582: fnd_message.set_encoded(l_message);
2583: --
2584: fnd_message.parse_encoded(encoded_message => l_message,
2585: app_short_name => l_app_name,
2586: message_name => l_message_name);

Line 2584: fnd_message.parse_encoded(encoded_message => l_message,

2580: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2581: l_message := fnd_message.get_encoded;
2582: fnd_message.set_encoded(l_message);
2583: --
2584: fnd_message.parse_encoded(encoded_message => l_message,
2585: app_short_name => l_app_name,
2586: message_name => l_message_name);
2587: IF g_person_errored = FALSE THEN
2588: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2588: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2584: fnd_message.parse_encoded(encoded_message => l_message,
2585: app_short_name => l_app_name,
2586: message_name => l_message_name);
2587: IF g_person_errored = FALSE THEN
2588: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2589: END IF;
2590: l_error := TRUE;
2591: g_person_errored := TRUE;
2592: END IF;

Line 2620: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');

2616: || 'or apply the new salary manually. ';
2617: WRITE (g_actn);
2618: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2619: write_m('Salary in CWB '||per_bg_rec.base_salary);
2620: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2621: l_message := fnd_message.get_encoded;
2622: fnd_message.set_encoded(l_message);
2623: --
2624: fnd_message.parse_encoded(encoded_message => l_message,

Line 2621: l_message := fnd_message.get_encoded;

2617: WRITE (g_actn);
2618: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2619: write_m('Salary in CWB '||per_bg_rec.base_salary);
2620: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2621: l_message := fnd_message.get_encoded;
2622: fnd_message.set_encoded(l_message);
2623: --
2624: fnd_message.parse_encoded(encoded_message => l_message,
2625: app_short_name => l_app_name,

Line 2622: fnd_message.set_encoded(l_message);

2618: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2619: write_m('Salary in CWB '||per_bg_rec.base_salary);
2620: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2621: l_message := fnd_message.get_encoded;
2622: fnd_message.set_encoded(l_message);
2623: --
2624: fnd_message.parse_encoded(encoded_message => l_message,
2625: app_short_name => l_app_name,
2626: message_name => l_message_name);

Line 2624: fnd_message.parse_encoded(encoded_message => l_message,

2620: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2621: l_message := fnd_message.get_encoded;
2622: fnd_message.set_encoded(l_message);
2623: --
2624: fnd_message.parse_encoded(encoded_message => l_message,
2625: app_short_name => l_app_name,
2626: message_name => l_message_name);
2627: IF g_person_errored = FALSE THEN
2628: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2628: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2624: fnd_message.parse_encoded(encoded_message => l_message,
2625: app_short_name => l_app_name,
2626: message_name => l_message_name);
2627: IF g_person_errored = FALSE THEN
2628: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2629: END IF;
2630: l_error := TRUE;
2631: g_person_errored := TRUE;
2632: --fnd_message.raise_error;

Line 2632: --fnd_message.raise_error;

2628: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2629: END IF;
2630: l_error := TRUE;
2631: g_person_errored := TRUE;
2632: --fnd_message.raise_error;
2633: END IF;
2634:
2635: OPEN c_sal_comp_rates_tot (p_group_per_in_ler_id,
2636: p_group_pl_id,

Line 2671: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');

2667: CLOSE c_future_pay_proposal;
2668:
2669: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2670: p_warning := TRUE;
2671: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2672: l_message := fnd_message.get_encoded;
2673: fnd_message.set_encoded(l_message);
2674: --
2675: fnd_message.parse_encoded(encoded_message => l_message,

Line 2672: l_message := fnd_message.get_encoded;

2668:
2669: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2670: p_warning := TRUE;
2671: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2672: l_message := fnd_message.get_encoded;
2673: fnd_message.set_encoded(l_message);
2674: --
2675: fnd_message.parse_encoded(encoded_message => l_message,
2676: app_short_name => l_app_name,

Line 2673: fnd_message.set_encoded(l_message);

2669: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2670: p_warning := TRUE;
2671: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2672: l_message := fnd_message.get_encoded;
2673: fnd_message.set_encoded(l_message);
2674: --
2675: fnd_message.parse_encoded(encoded_message => l_message,
2676: app_short_name => l_app_name,
2677: message_name => l_message_name);

Line 2675: fnd_message.parse_encoded(encoded_message => l_message,

2671: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2672: l_message := fnd_message.get_encoded;
2673: fnd_message.set_encoded(l_message);
2674: --
2675: fnd_message.parse_encoded(encoded_message => l_message,
2676: app_short_name => l_app_name,
2677: message_name => l_message_name);
2678: IF g_person_errored = FALSE THEN
2679: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2679: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2675: fnd_message.parse_encoded(encoded_message => l_message,
2676: app_short_name => l_app_name,
2677: message_name => l_message_name);
2678: IF g_person_errored = FALSE THEN
2679: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2680: END IF;
2681: g_person_errored := TRUE;
2682: --l_warning_text := l_warning_text||'Future dated salary proposal exists';
2683: END IF;

Line 2689: l_message := fnd_message.get_encoded;

2685: EXCEPTION
2686: WHEN OTHERS THEN
2687: WRITE('Error in insert_salary_proposal : '||SQLERRM);
2688: l_error := TRUE;
2689: l_message := fnd_message.get_encoded;
2690: fnd_message.set_encoded(l_message);
2691: --
2692: fnd_message.parse_encoded(encoded_message => l_message,
2693: app_short_name => l_app_name,

Line 2690: fnd_message.set_encoded(l_message);

2686: WHEN OTHERS THEN
2687: WRITE('Error in insert_salary_proposal : '||SQLERRM);
2688: l_error := TRUE;
2689: l_message := fnd_message.get_encoded;
2690: fnd_message.set_encoded(l_message);
2691: --
2692: fnd_message.parse_encoded(encoded_message => l_message,
2693: app_short_name => l_app_name,
2694: message_name => l_message_name);

Line 2692: fnd_message.parse_encoded(encoded_message => l_message,

2688: l_error := TRUE;
2689: l_message := fnd_message.get_encoded;
2690: fnd_message.set_encoded(l_message);
2691: --
2692: fnd_message.parse_encoded(encoded_message => l_message,
2693: app_short_name => l_app_name,
2694: message_name => l_message_name);
2695: IF g_person_errored = FALSE THEN
2696: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2696: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2692: fnd_message.parse_encoded(encoded_message => l_message,
2693: app_short_name => l_app_name,
2694: message_name => l_message_name);
2695: IF g_person_errored = FALSE THEN
2696: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2697: END IF;
2698: g_person_errored := TRUE;
2699: END;
2700: write_m ('Time after inserting the salary proposal '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));

Line 2797: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');

2793: WRITE('Currency in CWB does not match Input Currency of the Element Type');
2794: write_m('Currency for Element '||l_element_input_currency);
2795: write_m('Currency in CWB '||sal_rate_rec.currency);
2796:
2797: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2798: l_message := fnd_message.get_encoded;
2799: fnd_message.set_encoded(l_message);
2800: --
2801: fnd_message.parse_encoded(encoded_message => l_message,

Line 2798: l_message := fnd_message.get_encoded;

2794: write_m('Currency for Element '||l_element_input_currency);
2795: write_m('Currency in CWB '||sal_rate_rec.currency);
2796:
2797: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2798: l_message := fnd_message.get_encoded;
2799: fnd_message.set_encoded(l_message);
2800: --
2801: fnd_message.parse_encoded(encoded_message => l_message,
2802: app_short_name => l_app_name,

Line 2799: fnd_message.set_encoded(l_message);

2795: write_m('Currency in CWB '||sal_rate_rec.currency);
2796:
2797: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2798: l_message := fnd_message.get_encoded;
2799: fnd_message.set_encoded(l_message);
2800: --
2801: fnd_message.parse_encoded(encoded_message => l_message,
2802: app_short_name => l_app_name,
2803: message_name => l_message_name);

Line 2801: fnd_message.parse_encoded(encoded_message => l_message,

2797: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2798: l_message := fnd_message.get_encoded;
2799: fnd_message.set_encoded(l_message);
2800: --
2801: fnd_message.parse_encoded(encoded_message => l_message,
2802: app_short_name => l_app_name,
2803: message_name => l_message_name);
2804: IF g_person_errored = FALSE THEN
2805: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2805: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2801: fnd_message.parse_encoded(encoded_message => l_message,
2802: app_short_name => l_app_name,
2803: message_name => l_message_name);
2804: IF g_person_errored = FALSE THEN
2805: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2806: END IF;
2807: l_error := TRUE;
2808: g_person_errored := TRUE;
2809: --fnd_message.raise_error;

Line 2809: --fnd_message.raise_error;

2805: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2806: END IF;
2807: l_error := TRUE;
2808: g_person_errored := TRUE;
2809: --fnd_message.raise_error;
2810:
2811: END IF;
2812: hr_maintain_proposal_api.insert_proposal_component
2813: (p_component_id => l_component_id

Line 2825: l_message := fnd_message.get_encoded;

2821: EXCEPTION
2822: WHEN OTHERS THEN
2823: WRITE('Error in insert_proposal_component : '||SQLERRM);
2824: l_error := TRUE;
2825: l_message := fnd_message.get_encoded;
2826: fnd_message.set_encoded(l_message);
2827: --
2828: fnd_message.parse_encoded(encoded_message => l_message,
2829: app_short_name => l_app_name,

Line 2826: fnd_message.set_encoded(l_message);

2822: WHEN OTHERS THEN
2823: WRITE('Error in insert_proposal_component : '||SQLERRM);
2824: l_error := TRUE;
2825: l_message := fnd_message.get_encoded;
2826: fnd_message.set_encoded(l_message);
2827: --
2828: fnd_message.parse_encoded(encoded_message => l_message,
2829: app_short_name => l_app_name,
2830: message_name => l_message_name);

Line 2828: fnd_message.parse_encoded(encoded_message => l_message,

2824: l_error := TRUE;
2825: l_message := fnd_message.get_encoded;
2826: fnd_message.set_encoded(l_message);
2827: --
2828: fnd_message.parse_encoded(encoded_message => l_message,
2829: app_short_name => l_app_name,
2830: message_name => l_message_name);
2831: IF g_person_errored = FALSE THEN
2832: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2832: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2828: fnd_message.parse_encoded(encoded_message => l_message,
2829: app_short_name => l_app_name,
2830: message_name => l_message_name);
2831: IF g_person_errored = FALSE THEN
2832: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2833: END IF;
2834: g_person_errored := TRUE;
2835: END;
2836:

Line 2937: l_message := fnd_message.get_encoded;

2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: WRITE('Error in update_salary_proposal : '||SQLERRM);
2936: l_error := TRUE;
2937: l_message := fnd_message.get_encoded;
2938: fnd_message.set_encoded(l_message);
2939: --
2940: fnd_message.parse_encoded(encoded_message => l_message,
2941: app_short_name => l_app_name,

Line 2938: fnd_message.set_encoded(l_message);

2934: WHEN OTHERS THEN
2935: WRITE('Error in update_salary_proposal : '||SQLERRM);
2936: l_error := TRUE;
2937: l_message := fnd_message.get_encoded;
2938: fnd_message.set_encoded(l_message);
2939: --
2940: fnd_message.parse_encoded(encoded_message => l_message,
2941: app_short_name => l_app_name,
2942: message_name => l_message_name);

Line 2940: fnd_message.parse_encoded(encoded_message => l_message,

2936: l_error := TRUE;
2937: l_message := fnd_message.get_encoded;
2938: fnd_message.set_encoded(l_message);
2939: --
2940: fnd_message.parse_encoded(encoded_message => l_message,
2941: app_short_name => l_app_name,
2942: message_name => l_message_name);
2943: IF g_person_errored = FALSE THEN
2944: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 2944: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

2940: fnd_message.parse_encoded(encoded_message => l_message,
2941: app_short_name => l_app_name,
2942: message_name => l_message_name);
2943: IF g_person_errored = FALSE THEN
2944: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2945: END IF;
2946: g_person_errored := TRUE;
2947: END;
2948: END IF;

Line 3053: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');

3049: ELSE
3050: g_actn :=
3051: 'The salary is not posted as no pay basis is defined.';
3052: WRITE (g_actn);
3053: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3054: l_message := fnd_message.get_encoded;
3055: fnd_message.set_encoded(l_message);
3056: --
3057: fnd_message.parse_encoded(encoded_message => l_message,

Line 3054: l_message := fnd_message.get_encoded;

3050: g_actn :=
3051: 'The salary is not posted as no pay basis is defined.';
3052: WRITE (g_actn);
3053: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3054: l_message := fnd_message.get_encoded;
3055: fnd_message.set_encoded(l_message);
3056: --
3057: fnd_message.parse_encoded(encoded_message => l_message,
3058: app_short_name => l_app_name,

Line 3055: fnd_message.set_encoded(l_message);

3051: 'The salary is not posted as no pay basis is defined.';
3052: WRITE (g_actn);
3053: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3054: l_message := fnd_message.get_encoded;
3055: fnd_message.set_encoded(l_message);
3056: --
3057: fnd_message.parse_encoded(encoded_message => l_message,
3058: app_short_name => l_app_name,
3059: message_name => l_message_name);

Line 3057: fnd_message.parse_encoded(encoded_message => l_message,

3053: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3054: l_message := fnd_message.get_encoded;
3055: fnd_message.set_encoded(l_message);
3056: --
3057: fnd_message.parse_encoded(encoded_message => l_message,
3058: app_short_name => l_app_name,
3059: message_name => l_message_name);
3060: IF g_person_errored = FALSE THEN
3061: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3061: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3057: fnd_message.parse_encoded(encoded_message => l_message,
3058: app_short_name => l_app_name,
3059: message_name => l_message_name);
3060: IF g_person_errored = FALSE THEN
3061: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3062: END IF;
3063: l_error := TRUE;
3064: g_person_errored := TRUE;
3065: END IF;

Line 3084: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');

3080: || 'or apply the new salary manually. ';
3081: WRITE (g_actn);
3082: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3083: write_m('Salary in CWB '||l_person_info.base_salary);
3084: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3085: l_message := fnd_message.get_encoded;
3086: fnd_message.set_encoded(l_message);
3087: --
3088: fnd_message.parse_encoded(encoded_message => l_message,

Line 3085: l_message := fnd_message.get_encoded;

3081: WRITE (g_actn);
3082: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3083: write_m('Salary in CWB '||l_person_info.base_salary);
3084: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3085: l_message := fnd_message.get_encoded;
3086: fnd_message.set_encoded(l_message);
3087: --
3088: fnd_message.parse_encoded(encoded_message => l_message,
3089: app_short_name => l_app_name,

Line 3086: fnd_message.set_encoded(l_message);

3082: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3083: write_m('Salary in CWB '||l_person_info.base_salary);
3084: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3085: l_message := fnd_message.get_encoded;
3086: fnd_message.set_encoded(l_message);
3087: --
3088: fnd_message.parse_encoded(encoded_message => l_message,
3089: app_short_name => l_app_name,
3090: message_name => l_message_name);

Line 3088: fnd_message.parse_encoded(encoded_message => l_message,

3084: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3085: l_message := fnd_message.get_encoded;
3086: fnd_message.set_encoded(l_message);
3087: --
3088: fnd_message.parse_encoded(encoded_message => l_message,
3089: app_short_name => l_app_name,
3090: message_name => l_message_name);
3091: IF g_person_errored = FALSE THEN
3092: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3092: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3088: fnd_message.parse_encoded(encoded_message => l_message,
3089: app_short_name => l_app_name,
3090: message_name => l_message_name);
3091: IF g_person_errored = FALSE THEN
3092: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3093: END IF;
3094: l_error := TRUE;
3095: g_person_errored := TRUE;
3096: --fnd_message.raise_error;

Line 3096: --fnd_message.raise_error;

3092: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3093: END IF;
3094: l_error := TRUE;
3095: g_person_errored := TRUE;
3096: --fnd_message.raise_error;
3097: END IF;
3098: IF(NOT l_error) THEN
3099: l_prev_sal := asg_rec.proposed_salary_n;
3100: g_actn := 'Inserting salary proposal for non_comp_salary';

Line 3122: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');

3118: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3119:
3120: write_m('Currency for Element '||l_element_input_currency);
3121: write_m('Currency in CWB '||p_currency);
3122: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3123: l_message := fnd_message.get_encoded;
3124: fnd_message.set_encoded(l_message);
3125: --
3126: fnd_message.parse_encoded(encoded_message => l_message,

Line 3123: l_message := fnd_message.get_encoded;

3119:
3120: write_m('Currency for Element '||l_element_input_currency);
3121: write_m('Currency in CWB '||p_currency);
3122: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3123: l_message := fnd_message.get_encoded;
3124: fnd_message.set_encoded(l_message);
3125: --
3126: fnd_message.parse_encoded(encoded_message => l_message,
3127: app_short_name => l_app_name,

Line 3124: fnd_message.set_encoded(l_message);

3120: write_m('Currency for Element '||l_element_input_currency);
3121: write_m('Currency in CWB '||p_currency);
3122: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3123: l_message := fnd_message.get_encoded;
3124: fnd_message.set_encoded(l_message);
3125: --
3126: fnd_message.parse_encoded(encoded_message => l_message,
3127: app_short_name => l_app_name,
3128: message_name => l_message_name);

Line 3126: fnd_message.parse_encoded(encoded_message => l_message,

3122: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3123: l_message := fnd_message.get_encoded;
3124: fnd_message.set_encoded(l_message);
3125: --
3126: fnd_message.parse_encoded(encoded_message => l_message,
3127: app_short_name => l_app_name,
3128: message_name => l_message_name);
3129: IF g_person_errored = FALSE THEN
3130: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3130: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3126: fnd_message.parse_encoded(encoded_message => l_message,
3127: app_short_name => l_app_name,
3128: message_name => l_message_name);
3129: IF g_person_errored = FALSE THEN
3130: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3131: END IF;
3132: l_error := TRUE;
3133: g_person_errored := TRUE;
3134: END IF;

Line 3163: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');

3159: CLOSE c_future_pay_proposal;
3160:
3161: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3162: p_warning := TRUE;
3163: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3164: l_message := fnd_message.get_encoded;
3165: fnd_message.set_encoded(l_message);
3166: --
3167: fnd_message.parse_encoded(encoded_message => l_message,

Line 3164: l_message := fnd_message.get_encoded;

3160:
3161: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3162: p_warning := TRUE;
3163: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3164: l_message := fnd_message.get_encoded;
3165: fnd_message.set_encoded(l_message);
3166: --
3167: fnd_message.parse_encoded(encoded_message => l_message,
3168: app_short_name => l_app_name,

Line 3165: fnd_message.set_encoded(l_message);

3161: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3162: p_warning := TRUE;
3163: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3164: l_message := fnd_message.get_encoded;
3165: fnd_message.set_encoded(l_message);
3166: --
3167: fnd_message.parse_encoded(encoded_message => l_message,
3168: app_short_name => l_app_name,
3169: message_name => l_message_name);

Line 3167: fnd_message.parse_encoded(encoded_message => l_message,

3163: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3164: l_message := fnd_message.get_encoded;
3165: fnd_message.set_encoded(l_message);
3166: --
3167: fnd_message.parse_encoded(encoded_message => l_message,
3168: app_short_name => l_app_name,
3169: message_name => l_message_name);
3170: IF g_person_errored = FALSE THEN
3171: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3171: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3167: fnd_message.parse_encoded(encoded_message => l_message,
3168: app_short_name => l_app_name,
3169: message_name => l_message_name);
3170: IF g_person_errored = FALSE THEN
3171: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3172: END IF;
3173: g_person_errored := TRUE;
3174: --p_warning_text := p_warning_text||'Future dated salary proposal exists';
3175: END IF;

Line 3183: l_error := TRUE; l_message := fnd_message.get_encoded;

3179: WHEN OTHERS THEN
3180: p_prev_sal := l_prev_sal;
3181: p_pay_proposal_id := l_pay_proposal_id;
3182: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3183: l_error := TRUE; l_message := fnd_message.get_encoded;
3184: fnd_message.set_encoded(l_message);
3185: --
3186: fnd_message.parse_encoded(encoded_message => l_message,
3187: app_short_name => l_app_name,

Line 3184: fnd_message.set_encoded(l_message);

3180: p_prev_sal := l_prev_sal;
3181: p_pay_proposal_id := l_pay_proposal_id;
3182: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3183: l_error := TRUE; l_message := fnd_message.get_encoded;
3184: fnd_message.set_encoded(l_message);
3185: --
3186: fnd_message.parse_encoded(encoded_message => l_message,
3187: app_short_name => l_app_name,
3188: message_name => l_message_name);

Line 3186: fnd_message.parse_encoded(encoded_message => l_message,

3182: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3183: l_error := TRUE; l_message := fnd_message.get_encoded;
3184: fnd_message.set_encoded(l_message);
3185: --
3186: fnd_message.parse_encoded(encoded_message => l_message,
3187: app_short_name => l_app_name,
3188: message_name => l_message_name);
3189: IF g_person_errored = FALSE THEN
3190: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3190: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3186: fnd_message.parse_encoded(encoded_message => l_message,
3187: app_short_name => l_app_name,
3188: message_name => l_message_name);
3189: IF g_person_errored = FALSE THEN
3190: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3191: END IF;
3192: g_person_errored := TRUE;
3193: --p_warning_text := p_warning_text||SQLERRM;
3194: END;

Line 3302: l_message := fnd_message.get_encoded;

3298: EXCEPTION
3299: WHEN OTHERS THEN
3300: WRITE('Exception at create_enrollment_element : '||SQLERRM);
3301: l_error := TRUE;
3302: l_message := fnd_message.get_encoded;
3303: fnd_message.set_encoded(l_message);
3304: --
3305: fnd_message.parse_encoded(encoded_message => l_message,
3306: app_short_name => l_app_name,

Line 3303: fnd_message.set_encoded(l_message);

3299: WHEN OTHERS THEN
3300: WRITE('Exception at create_enrollment_element : '||SQLERRM);
3301: l_error := TRUE;
3302: l_message := fnd_message.get_encoded;
3303: fnd_message.set_encoded(l_message);
3304: --
3305: fnd_message.parse_encoded(encoded_message => l_message,
3306: app_short_name => l_app_name,
3307: message_name => l_message_name);

Line 3305: fnd_message.parse_encoded(encoded_message => l_message,

3301: l_error := TRUE;
3302: l_message := fnd_message.get_encoded;
3303: fnd_message.set_encoded(l_message);
3304: --
3305: fnd_message.parse_encoded(encoded_message => l_message,
3306: app_short_name => l_app_name,
3307: message_name => l_message_name);
3308: IF g_person_errored = FALSE THEN
3309: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3309: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3305: fnd_message.parse_encoded(encoded_message => l_message,
3306: app_short_name => l_app_name,
3307: message_name => l_message_name);
3308: IF g_person_errored = FALSE THEN
3309: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3310: END IF;
3311: g_person_errored := TRUE;
3312: END;
3313: g_actn := 'updating the element entry id into person rates ...';

Line 3336: l_message := fnd_message.get_encoded;

3332: EXCEPTION
3333: WHEN OTHERS THEN
3334: WRITE('Exception at update_person_rate : '||SQLERRM);
3335: l_error := TRUE;
3336: l_message := fnd_message.get_encoded;
3337: fnd_message.set_encoded(l_message);
3338: --
3339: fnd_message.parse_encoded(encoded_message => l_message,
3340: app_short_name => l_app_name,

Line 3337: fnd_message.set_encoded(l_message);

3333: WHEN OTHERS THEN
3334: WRITE('Exception at update_person_rate : '||SQLERRM);
3335: l_error := TRUE;
3336: l_message := fnd_message.get_encoded;
3337: fnd_message.set_encoded(l_message);
3338: --
3339: fnd_message.parse_encoded(encoded_message => l_message,
3340: app_short_name => l_app_name,
3341: message_name => l_message_name);

Line 3339: fnd_message.parse_encoded(encoded_message => l_message,

3335: l_error := TRUE;
3336: l_message := fnd_message.get_encoded;
3337: fnd_message.set_encoded(l_message);
3338: --
3339: fnd_message.parse_encoded(encoded_message => l_message,
3340: app_short_name => l_app_name,
3341: message_name => l_message_name);
3342: IF g_person_errored = FALSE THEN
3343: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

Line 3343: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

3339: fnd_message.parse_encoded(encoded_message => l_message,
3340: app_short_name => l_app_name,
3341: message_name => l_message_name);
3342: IF g_person_errored = FALSE THEN
3343: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3344: END IF;
3345: g_person_errored := TRUE;
3346: END;
3347:

Line 3548: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');

3544: p_group_oipl_id => rt_rec.group_oipl_id,
3545: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_date);
3546: if(l_override_start_date is null) then
3547: l_error := TRUE;
3548: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3549: l_message := fnd_message.get_encoded;
3550: fnd_message.set_encoded(l_message);
3551: fnd_message.parse_encoded(encoded_message => l_message,
3552: app_short_name => l_app_name,

Line 3549: l_message := fnd_message.get_encoded;

3545: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_date);
3546: if(l_override_start_date is null) then
3547: l_error := TRUE;
3548: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3549: l_message := fnd_message.get_encoded;
3550: fnd_message.set_encoded(l_message);
3551: fnd_message.parse_encoded(encoded_message => l_message,
3552: app_short_name => l_app_name,
3553: message_name => l_message_name);

Line 3550: fnd_message.set_encoded(l_message);

3546: if(l_override_start_date is null) then
3547: l_error := TRUE;
3548: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3549: l_message := fnd_message.get_encoded;
3550: fnd_message.set_encoded(l_message);
3551: fnd_message.parse_encoded(encoded_message => l_message,
3552: app_short_name => l_app_name,
3553: message_name => l_message_name);
3554: IF g_person_errored = FALSE THEN

Line 3551: fnd_message.parse_encoded(encoded_message => l_message,

3547: l_error := TRUE;
3548: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3549: l_message := fnd_message.get_encoded;
3550: fnd_message.set_encoded(l_message);
3551: fnd_message.parse_encoded(encoded_message => l_message,
3552: app_short_name => l_app_name,
3553: message_name => l_message_name);
3554: IF g_person_errored = FALSE THEN
3555: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 3555: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

3551: fnd_message.parse_encoded(encoded_message => l_message,
3552: app_short_name => l_app_name,
3553: message_name => l_message_name);
3554: IF g_person_errored = FALSE THEN
3555: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
3556: END IF;
3557: g_person_errored := TRUE;
3558: l_effective_date := null;
3559: else

Line 3639: fnd_message.CLEAR();

3635: EXCEPTION
3636: WHEN others THEN
3637: WRITE('No Element Rule Found ');
3638: --WRITE(SQLERRM);
3639: fnd_message.CLEAR();
3640: END;
3641: if(l_element_type_id is null and l_input_value_id is null) then
3642: get_plan_abr_info(
3643: p_lf_evt_ocrd_date => p_lf_evt_ocrd_date

Line 3766: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');

3762:
3763: IF(rt_rec.units is null) THEN
3764: IF(l_input_currency<>rt_rec.currency) THEN
3765: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3766: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3767: l_error := TRUE;
3768:
3769: l_message := fnd_message.get_encoded;
3770: fnd_message.set_encoded(l_message);

Line 3769: l_message := fnd_message.get_encoded;

3765: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3766: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3767: l_error := TRUE;
3768:
3769: l_message := fnd_message.get_encoded;
3770: fnd_message.set_encoded(l_message);
3771: --
3772: fnd_message.parse_encoded(encoded_message => l_message,
3773: app_short_name => l_app_name,

Line 3770: fnd_message.set_encoded(l_message);

3766: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3767: l_error := TRUE;
3768:
3769: l_message := fnd_message.get_encoded;
3770: fnd_message.set_encoded(l_message);
3771: --
3772: fnd_message.parse_encoded(encoded_message => l_message,
3773: app_short_name => l_app_name,
3774: message_name => l_message_name);

Line 3772: fnd_message.parse_encoded(encoded_message => l_message,

3768:
3769: l_message := fnd_message.get_encoded;
3770: fnd_message.set_encoded(l_message);
3771: --
3772: fnd_message.parse_encoded(encoded_message => l_message,
3773: app_short_name => l_app_name,
3774: message_name => l_message_name);
3775: IF g_person_errored = FALSE THEN
3776: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

Line 3776: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

3772: fnd_message.parse_encoded(encoded_message => l_message,
3773: app_short_name => l_app_name,
3774: message_name => l_message_name);
3775: IF g_person_errored = FALSE THEN
3776: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
3777: END IF;
3778: g_person_errored := TRUE;
3779:
3780: END IF;

Line 4141: fnd_message.set_name ('BEN', 'BEN_93365_PERSON_TERMINATED');

4137: IF (((l_asg_txn.assignment_id is not null) and (l_asg_updt_eff_date >= l_actual_termination_date)) OR
4138: ((l_perf_txn.assignment_id is not null) and (l_perf_revw_strt_dt >= l_actual_termination_date)) ) THEN
4139: WRITE ('The person was terminated on ' || l_actual_termination_date
4140: || ' promotion or performance was not applied' );
4141: fnd_message.set_name ('BEN', 'BEN_93365_PERSON_TERMINATED');
4142: l_error := TRUE;
4143: --fnd_message.raise_error;
4144: END IF;
4145: END IF;

Line 4143: --fnd_message.raise_error;

4139: WRITE ('The person was terminated on ' || l_actual_termination_date
4140: || ' promotion or performance was not applied' );
4141: fnd_message.set_name ('BEN', 'BEN_93365_PERSON_TERMINATED');
4142: l_error := TRUE;
4143: --fnd_message.raise_error;
4144: END IF;
4145: END IF;
4146: END IF;
4147:

Line 4184: fnd_message.raise_error;

4180: l_perf_person_rec.rating_type := l_perf_txn.attribute2;
4181: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);
4182:
4183: if(l_error) then
4184: fnd_message.raise_error;
4185: end if;
4186:
4187: ben_cwb_asg_update.process_rating (p_person_id => p_person_id
4188: , p_txn_rec => l_perf_txn

Line 4212: l_message := fnd_message.get_encoded;

4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: WRITE('Error at Performance rating '||SQLERRM);
4211: l_perf_person_rec.status := 'E';
4212: l_message := fnd_message.get_encoded;
4213: fnd_message.set_encoded(l_message);
4214: --
4215: fnd_message.parse_encoded(encoded_message => l_message,
4216: app_short_name => l_app_name,

Line 4213: fnd_message.set_encoded(l_message);

4209: WHEN OTHERS THEN
4210: WRITE('Error at Performance rating '||SQLERRM);
4211: l_perf_person_rec.status := 'E';
4212: l_message := fnd_message.get_encoded;
4213: fnd_message.set_encoded(l_message);
4214: --
4215: fnd_message.parse_encoded(encoded_message => l_message,
4216: app_short_name => l_app_name,
4217: message_name => l_message_name);

Line 4215: fnd_message.parse_encoded(encoded_message => l_message,

4211: l_perf_person_rec.status := 'E';
4212: l_message := fnd_message.get_encoded;
4213: fnd_message.set_encoded(l_message);
4214: --
4215: fnd_message.parse_encoded(encoded_message => l_message,
4216: app_short_name => l_app_name,
4217: message_name => l_message_name);
4218: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4219: g_person_errored := TRUE;

Line 4218: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

4214: --
4215: fnd_message.parse_encoded(encoded_message => l_message,
4216: app_short_name => l_app_name,
4217: message_name => l_message_name);
4218: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4219: g_person_errored := TRUE;
4220: WRITE(l_perf_person_rec.error_or_warning_text);
4221: ROLLBACK TO process_rating;
4222: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN

Line 4223: --l_perf_person_rec.error_or_warning_text := fnd_message.get;

4219: g_person_errored := TRUE;
4220: WRITE(l_perf_person_rec.error_or_warning_text);
4221: ROLLBACK TO process_rating;
4222: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN
4223: --l_perf_person_rec.error_or_warning_text := fnd_message.get;
4224: write_m ('Time after processing rating '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4225: WRITE('Failed Performance rating is '||l_perf_person_rec.performance_rating);
4226: l_rating_status := 'CWB_PERF_SUS';
4227: ELSE

Line 4357: fnd_message.raise_error;

4353: l_promo_person_rec.asgn_change_reason := l_asg_txn.attribute3;
4354: l_promo_person_rec.effective_date := l_asg_updt_eff_date;
4355:
4356: if(l_error) then
4357: fnd_message.raise_error;
4358: end if;
4359:
4360: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id
4361: , p_asg_txn_rec => l_asg_txn

Line 4381: l_message := fnd_message.get_encoded;

4377: EXCEPTION
4378: WHEN OTHERS THEN
4379: WRITE('Error at processing promotions'||SQLERRM);
4380: l_promo_person_rec.status := 'E';
4381: l_message := fnd_message.get_encoded;
4382: fnd_message.set_encoded(l_message);
4383: --
4384: fnd_message.parse_encoded(encoded_message => l_message,
4385: app_short_name => l_app_name,

Line 4382: fnd_message.set_encoded(l_message);

4378: WHEN OTHERS THEN
4379: WRITE('Error at processing promotions'||SQLERRM);
4380: l_promo_person_rec.status := 'E';
4381: l_message := fnd_message.get_encoded;
4382: fnd_message.set_encoded(l_message);
4383: --
4384: fnd_message.parse_encoded(encoded_message => l_message,
4385: app_short_name => l_app_name,
4386: message_name => l_message_name);

Line 4384: fnd_message.parse_encoded(encoded_message => l_message,

4380: l_promo_person_rec.status := 'E';
4381: l_message := fnd_message.get_encoded;
4382: fnd_message.set_encoded(l_message);
4383: --
4384: fnd_message.parse_encoded(encoded_message => l_message,
4385: app_short_name => l_app_name,
4386: message_name => l_message_name);
4387: l_promo_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4388: WRITE(l_promo_person_rec.error_or_warning_text);

Line 4387: l_promo_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

4383: --
4384: fnd_message.parse_encoded(encoded_message => l_message,
4385: app_short_name => l_app_name,
4386: message_name => l_message_name);
4387: l_promo_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4388: WRITE(l_promo_person_rec.error_or_warning_text);
4389: ROLLBACK TO process_promotions;
4390: l_promo_error := TRUE;
4391: l_error := TRUE;

Line 4472: l_message := fnd_message.get_encoded;

4468: EXCEPTION
4469: WHEN OTHERS THEN
4470: WRITE('Error at Ranking '||SQLERRM);
4471: l_perf_person_rec.status := 'E';
4472: l_message := fnd_message.get_encoded;
4473: fnd_message.set_encoded(l_message);
4474: --
4475: fnd_message.parse_encoded(encoded_message => l_message,
4476: app_short_name => l_app_name,

Line 4473: fnd_message.set_encoded(l_message);

4469: WHEN OTHERS THEN
4470: WRITE('Error at Ranking '||SQLERRM);
4471: l_perf_person_rec.status := 'E';
4472: l_message := fnd_message.get_encoded;
4473: fnd_message.set_encoded(l_message);
4474: --
4475: fnd_message.parse_encoded(encoded_message => l_message,
4476: app_short_name => l_app_name,
4477: message_name => l_message_name);

Line 4475: fnd_message.parse_encoded(encoded_message => l_message,

4471: l_perf_person_rec.status := 'E';
4472: l_message := fnd_message.get_encoded;
4473: fnd_message.set_encoded(l_message);
4474: --
4475: fnd_message.parse_encoded(encoded_message => l_message,
4476: app_short_name => l_app_name,
4477: message_name => l_message_name);
4478: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4479: WRITE(l_perf_person_rec.error_or_warning_text);

Line 4478: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

4474: --
4475: fnd_message.parse_encoded(encoded_message => l_message,
4476: app_short_name => l_app_name,
4477: message_name => l_message_name);
4478: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4479: WRITE(l_perf_person_rec.error_or_warning_text);
4480: ROLLBACK TO process_ranking;
4481: l_perf_error := TRUE;
4482: l_error := TRUE;

Line 4818: g_cwb_rpt_person.error_or_warning_text := substr(benutils.get_message_name || ' '||fnd_message.get,1,2000);

4814: IF g_cwb_rpt_person.group_oipl_id <> -1 THEN
4815: g_cwb_rpt_person.opt_name := g_cache_group_options (g_cwb_rpt_person.group_oipl_id);
4816: END IF;
4817:
4818: g_cwb_rpt_person.error_or_warning_text := substr(benutils.get_message_name || ' '||fnd_message.get,1,2000);
4819:
4820: IF l_comp_error THEN
4821: g_cwb_rpt_person.error_or_warning_text := substr(g_cwb_rpt_person.error_or_warning_text ||
4822: ' '||'Person ' || p_person_id || ' failed for compensation',1,2000);

Line 4846: WRITE (fnd_message.get);

4842: -- g_cache_cwb_rpt_person (g_cache_cwb_rpt_person.COUNT + 1) := g_cwb_rpt_person;
4843:
4844: END IF;
4845: WRITE (benutils.get_message_name);
4846: WRITE (fnd_message.get);
4847: WRITE (SQLERRM||' in process_person');
4848: RAISE ben_batch_utils.g_record_error;
4849: END;
4850:

Line 5036: fnd_message.set_name ('BEN', 'BEN_93145_MAX_LIMIT_REACHED');

5032: IF (g_persons_errored > g_max_errors_allowed)
5033: THEN
5034: g_actn := '<> ';
5035: WRITE (g_actn);
5036: fnd_message.set_name ('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5037: -- removed RAISE ben_batch_utils.g_record_error;
5038: raise g_max_error;
5039: END IF;
5040:

Line 5050: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');

5046: ELSE
5047: --
5048: g_actn := 'Erroring out since no person is found in range...';
5049: --
5050: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
5051: fnd_message.set_token ('PROCEDURE', g_proc);
5052: fnd_message.raise_error;
5053: END IF;
5054:

Line 5051: fnd_message.set_token ('PROCEDURE', g_proc);

5047: --
5048: g_actn := 'Erroring out since no person is found in range...';
5049: --
5050: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
5051: fnd_message.set_token ('PROCEDURE', g_proc);
5052: fnd_message.raise_error;
5053: END IF;
5054:
5055: COMMIT;

Line 5052: fnd_message.raise_error;

5048: g_actn := 'Erroring out since no person is found in range...';
5049: --
5050: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
5051: fnd_message.set_token ('PROCEDURE', g_proc);
5052: fnd_message.raise_error;
5053: END IF;
5054:
5055: COMMIT;
5056: END LOOP;

Line 5072: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

5068: WRITE(SQLERRM);
5069: print_cache;
5070: table_corrections(p_benefit_action_id);
5071: COMMIT;
5072: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5073: fnd_message.set_token ('PROCEDURE', g_proc);
5074: fnd_message.set_token ('STEP', g_actn);
5075: fnd_message.raise_error;
5076: END;

Line 5073: fnd_message.set_token ('PROCEDURE', g_proc);

5069: print_cache;
5070: table_corrections(p_benefit_action_id);
5071: COMMIT;
5072: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5073: fnd_message.set_token ('PROCEDURE', g_proc);
5074: fnd_message.set_token ('STEP', g_actn);
5075: fnd_message.raise_error;
5076: END;
5077:

Line 5074: fnd_message.set_token ('STEP', g_actn);

5070: table_corrections(p_benefit_action_id);
5071: COMMIT;
5072: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5073: fnd_message.set_token ('PROCEDURE', g_proc);
5074: fnd_message.set_token ('STEP', g_actn);
5075: fnd_message.raise_error;
5076: END;
5077:
5078: PROCEDURE process (

Line 5075: fnd_message.raise_error;

5071: COMMIT;
5072: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5073: fnd_message.set_token ('PROCEDURE', g_proc);
5074: fnd_message.set_token ('STEP', g_actn);
5075: fnd_message.raise_error;
5076: END;
5077:
5078: PROCEDURE process (
5079: errbuf OUT NOCOPY VARCHAR2

Line 5501: fnd_message.set_name ('BEN', 'BEN_91769_NOONE_TO_PROCESS');

5497: END LOOP;
5498: ELSIF l_num_ranges = 0
5499: THEN
5500: WRITE ('<< No Person got selected with above selection criteria >>');
5501: fnd_message.set_name ('BEN', 'BEN_91769_NOONE_TO_PROCESS');
5502: fnd_message.set_token ('PROC', g_proc);
5503: RAISE l_silent_error;
5504: END IF;
5505:

Line 5502: fnd_message.set_token ('PROC', g_proc);

5498: ELSIF l_num_ranges = 0
5499: THEN
5500: WRITE ('<< No Person got selected with above selection criteria >>');
5501: fnd_message.set_name ('BEN', 'BEN_91769_NOONE_TO_PROCESS');
5502: fnd_message.set_token ('PROC', g_proc);
5503: RAISE l_silent_error;
5504: END IF;
5505:
5506: write_m ('Time after launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));

Line 5568: --fnd_message.set_name ('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');

5564: Close c_slaves;
5565: End loop;
5566: EXCEPTION
5567: WHEN l_slave_errored THEN
5568: --fnd_message.set_name ('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5569: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5570: g_actn:= 'slave processes';
5571: raise g_slave_error;
5572: END;

Line 5569: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');

5565: End loop;
5566: EXCEPTION
5567: WHEN l_slave_errored THEN
5568: --fnd_message.set_name ('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5569: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5570: g_actn:= 'slave processes';
5571: raise g_slave_error;
5572: END;
5573:

Line 5578: WRITE (fnd_message.get);

5574: EXCEPTION
5575: --
5576: WHEN l_silent_error
5577: THEN
5578: WRITE (fnd_message.get);
5579: IF (l_num_ranges > 0) THEN
5580: WRITE('END_PROCESS');
5581: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5582: end_process (p_benefit_action_id => l_benefit_action_id

Line 5589: WRITE (fnd_message.get);

5585: );
5586: END IF;
5587: --
5588: WHEN g_slave_error THEN
5589: WRITE (fnd_message.get);
5590: WRITE (SQLERRM);
5591: WRITE ('Big Error Occurred');
5592: IF (l_num_ranges > 0) THEN
5593: WRITE('END_PROCESS');

Line 5600: fnd_message.clear();

5596: , p_person_selected => l_num_persons
5597: , p_business_group_id => p_bg_id
5598: );
5599: END IF;
5600: fnd_message.clear();
5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);

Line 5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');

5597: , p_business_group_id => p_bg_id
5598: );
5599: END IF;
5600: fnd_message.clear();
5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5605: --

Line 5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');

5598: );
5599: END IF;
5600: fnd_message.clear();
5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5605: --
5606: WHEN g_max_error THEN

Line 5603: --fnd_message.raise_error;

5599: END IF;
5600: fnd_message.clear();
5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5605: --
5606: WHEN g_max_error THEN
5607: WRITE (fnd_message.get);

Line 5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);

5600: fnd_message.clear();
5601: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5602: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5605: --
5606: WHEN g_max_error THEN
5607: WRITE (fnd_message.get);
5608: WRITE (SQLERRM);

Line 5607: WRITE (fnd_message.get);

5603: --fnd_message.raise_error;
5604: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5605: --
5606: WHEN g_max_error THEN
5607: WRITE (fnd_message.get);
5608: WRITE (SQLERRM);
5609: WRITE ('Big Error Occurred');
5610: IF (l_num_ranges > 0) THEN
5611: WRITE('END_PROCESS');

Line 5619: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');

5615: , p_business_group_id => p_bg_id
5616: );
5617: END IF;
5618:
5619: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5620: --fnd_message.raise_error;
5621: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5622: --
5623: WHEN OTHERS THEN

Line 5620: --fnd_message.raise_error;

5616: );
5617: END IF;
5618:
5619: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5620: --fnd_message.raise_error;
5621: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5622: --
5623: WHEN OTHERS THEN
5624: WRITE (fnd_message.get);

Line 5621: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);

5617: END IF;
5618:
5619: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5620: --fnd_message.raise_error;
5621: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5622: --
5623: WHEN OTHERS THEN
5624: WRITE (fnd_message.get);
5625: WRITE (SQLERRM);

Line 5624: WRITE (fnd_message.get);

5620: --fnd_message.raise_error;
5621: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5622: --
5623: WHEN OTHERS THEN
5624: WRITE (fnd_message.get);
5625: WRITE (SQLERRM);
5626: WRITE ('Big Error Occurred');
5627: IF (l_num_ranges > 0) THEN
5628: WRITE('END_PROCESS');

Line 5636: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

5632: , p_business_group_id => p_bg_id
5633: );
5634: END IF;
5635:
5636: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5637: fnd_message.set_token ('PROCEDURE', g_proc);
5638: fnd_message.set_token ('STEP', g_actn);
5639: fnd_message.raise_error;
5640: END;

Line 5637: fnd_message.set_token ('PROCEDURE', g_proc);

5633: );
5634: END IF;
5635:
5636: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5637: fnd_message.set_token ('PROCEDURE', g_proc);
5638: fnd_message.set_token ('STEP', g_actn);
5639: fnd_message.raise_error;
5640: END;
5641: END;

Line 5638: fnd_message.set_token ('STEP', g_actn);

5634: END IF;
5635:
5636: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5637: fnd_message.set_token ('PROCEDURE', g_proc);
5638: fnd_message.set_token ('STEP', g_actn);
5639: fnd_message.raise_error;
5640: END;
5641: END;

Line 5639: fnd_message.raise_error;

5635:
5636: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5637: fnd_message.set_token ('PROCEDURE', g_proc);
5638: fnd_message.set_token ('STEP', g_actn);
5639: fnd_message.raise_error;
5640: END;
5641: END;