APPS.BEN_CWB_POST_PROCESS dependencies on FND_MESSAGE

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

2495: IF(l_effective_date IS NULL AND p_use_rate_start_date = 'Y') THEN
2496: g_actn :=
2497: 'The salary is not posted as no rate start date is defined.';
2498: WRITE (g_actn);
2499: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2500: l_message := fnd_message.get_encoded;
2501: fnd_message.set_encoded(l_message);
2502: --
2503: fnd_message.parse_encoded(encoded_message => l_message,

Line 2500: l_message := fnd_message.get_encoded;

2496: g_actn :=
2497: 'The salary is not posted as no rate start date is defined.';
2498: WRITE (g_actn);
2499: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2500: l_message := fnd_message.get_encoded;
2501: fnd_message.set_encoded(l_message);
2502: --
2503: fnd_message.parse_encoded(encoded_message => l_message,
2504: app_short_name => l_app_name,

Line 2501: fnd_message.set_encoded(l_message);

2497: 'The salary is not posted as no rate start date is defined.';
2498: WRITE (g_actn);
2499: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2500: l_message := fnd_message.get_encoded;
2501: fnd_message.set_encoded(l_message);
2502: --
2503: fnd_message.parse_encoded(encoded_message => l_message,
2504: app_short_name => l_app_name,
2505: message_name => l_message_name);

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

2499: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
2500: l_message := fnd_message.get_encoded;
2501: fnd_message.set_encoded(l_message);
2502: --
2503: fnd_message.parse_encoded(encoded_message => l_message,
2504: app_short_name => l_app_name,
2505: message_name => l_message_name);
2506: IF g_person_errored = FALSE THEN
2507: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2503: fnd_message.parse_encoded(encoded_message => l_message,
2504: app_short_name => l_app_name,
2505: message_name => l_message_name);
2506: IF g_person_errored = FALSE THEN
2507: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2508: END IF;
2509: l_error := TRUE;
2510: g_person_errored := TRUE;
2511: END IF;

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

2550: ELSE
2551: g_actn :=
2552: 'The salary is not posted as no pay basis is defined.';
2553: WRITE (g_actn);
2554: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2555: l_message := fnd_message.get_encoded;
2556: fnd_message.set_encoded(l_message);
2557: --
2558: fnd_message.parse_encoded(encoded_message => l_message,

Line 2555: l_message := fnd_message.get_encoded;

2551: g_actn :=
2552: 'The salary is not posted as no pay basis is defined.';
2553: WRITE (g_actn);
2554: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2555: l_message := fnd_message.get_encoded;
2556: fnd_message.set_encoded(l_message);
2557: --
2558: fnd_message.parse_encoded(encoded_message => l_message,
2559: app_short_name => l_app_name,

Line 2556: fnd_message.set_encoded(l_message);

2552: 'The salary is not posted as no pay basis is defined.';
2553: WRITE (g_actn);
2554: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2555: l_message := fnd_message.get_encoded;
2556: fnd_message.set_encoded(l_message);
2557: --
2558: fnd_message.parse_encoded(encoded_message => l_message,
2559: app_short_name => l_app_name,
2560: message_name => l_message_name);

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

2554: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
2555: l_message := fnd_message.get_encoded;
2556: fnd_message.set_encoded(l_message);
2557: --
2558: fnd_message.parse_encoded(encoded_message => l_message,
2559: app_short_name => l_app_name,
2560: message_name => l_message_name);
2561: IF g_person_errored = FALSE THEN
2562: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2558: fnd_message.parse_encoded(encoded_message => l_message,
2559: app_short_name => l_app_name,
2560: message_name => l_message_name);
2561: IF g_person_errored = FALSE THEN
2562: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2563: END IF;
2564: l_error := TRUE;
2565: g_person_errored := TRUE;
2566: END IF;

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

2590: || 'or apply the new salary manually. ';
2591: WRITE (g_actn);
2592: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2593: write_m('Salary in CWB '||per_bg_rec.base_salary);
2594: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2595: l_message := fnd_message.get_encoded;
2596: fnd_message.set_encoded(l_message);
2597: --
2598: fnd_message.parse_encoded(encoded_message => l_message,

Line 2595: l_message := fnd_message.get_encoded;

2591: WRITE (g_actn);
2592: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2593: write_m('Salary in CWB '||per_bg_rec.base_salary);
2594: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2595: l_message := fnd_message.get_encoded;
2596: fnd_message.set_encoded(l_message);
2597: --
2598: fnd_message.parse_encoded(encoded_message => l_message,
2599: app_short_name => l_app_name,

Line 2596: fnd_message.set_encoded(l_message);

2592: write_m('Salary in HR '||asg_rec.proposed_salary_n);
2593: write_m('Salary in CWB '||per_bg_rec.base_salary);
2594: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2595: l_message := fnd_message.get_encoded;
2596: fnd_message.set_encoded(l_message);
2597: --
2598: fnd_message.parse_encoded(encoded_message => l_message,
2599: app_short_name => l_app_name,
2600: message_name => l_message_name);

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

2594: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
2595: l_message := fnd_message.get_encoded;
2596: fnd_message.set_encoded(l_message);
2597: --
2598: fnd_message.parse_encoded(encoded_message => l_message,
2599: app_short_name => l_app_name,
2600: message_name => l_message_name);
2601: IF g_person_errored = FALSE THEN
2602: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2598: fnd_message.parse_encoded(encoded_message => l_message,
2599: app_short_name => l_app_name,
2600: message_name => l_message_name);
2601: IF g_person_errored = FALSE THEN
2602: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2603: END IF;
2604: l_error := TRUE;
2605: g_person_errored := TRUE;
2606: --fnd_message.raise_error;

Line 2606: --fnd_message.raise_error;

2602: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2603: END IF;
2604: l_error := TRUE;
2605: g_person_errored := TRUE;
2606: --fnd_message.raise_error;
2607: END IF;
2608:
2609: OPEN c_sal_comp_rates_tot (p_group_per_in_ler_id,
2610: p_group_pl_id,

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

2640: CLOSE c_future_pay_proposal;
2641:
2642: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2643: p_warning := TRUE;
2644: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2645: l_message := fnd_message.get_encoded;
2646: fnd_message.set_encoded(l_message);
2647: --
2648: fnd_message.parse_encoded(encoded_message => l_message,

Line 2645: l_message := fnd_message.get_encoded;

2641:
2642: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2643: p_warning := TRUE;
2644: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2645: l_message := fnd_message.get_encoded;
2646: fnd_message.set_encoded(l_message);
2647: --
2648: fnd_message.parse_encoded(encoded_message => l_message,
2649: app_short_name => l_app_name,

Line 2646: fnd_message.set_encoded(l_message);

2642: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
2643: p_warning := TRUE;
2644: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2645: l_message := fnd_message.get_encoded;
2646: fnd_message.set_encoded(l_message);
2647: --
2648: fnd_message.parse_encoded(encoded_message => l_message,
2649: app_short_name => l_app_name,
2650: message_name => l_message_name);

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

2644: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
2645: l_message := fnd_message.get_encoded;
2646: fnd_message.set_encoded(l_message);
2647: --
2648: fnd_message.parse_encoded(encoded_message => l_message,
2649: app_short_name => l_app_name,
2650: message_name => l_message_name);
2651: IF g_person_errored = FALSE THEN
2652: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2648: fnd_message.parse_encoded(encoded_message => l_message,
2649: app_short_name => l_app_name,
2650: message_name => l_message_name);
2651: IF g_person_errored = FALSE THEN
2652: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2653: END IF;
2654: g_person_errored := TRUE;
2655: --l_warning_text := l_warning_text||'Future dated salary proposal exists';
2656: END IF;

Line 2662: l_message := fnd_message.get_encoded;

2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: WRITE('Error in insert_salary_proposal : '||SQLERRM);
2661: l_error := TRUE;
2662: l_message := fnd_message.get_encoded;
2663: fnd_message.set_encoded(l_message);
2664: --
2665: fnd_message.parse_encoded(encoded_message => l_message,
2666: app_short_name => l_app_name,

Line 2663: fnd_message.set_encoded(l_message);

2659: WHEN OTHERS THEN
2660: WRITE('Error in insert_salary_proposal : '||SQLERRM);
2661: l_error := TRUE;
2662: l_message := fnd_message.get_encoded;
2663: fnd_message.set_encoded(l_message);
2664: --
2665: fnd_message.parse_encoded(encoded_message => l_message,
2666: app_short_name => l_app_name,
2667: message_name => l_message_name);

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

2661: l_error := TRUE;
2662: l_message := fnd_message.get_encoded;
2663: fnd_message.set_encoded(l_message);
2664: --
2665: fnd_message.parse_encoded(encoded_message => l_message,
2666: app_short_name => l_app_name,
2667: message_name => l_message_name);
2668: IF g_person_errored = FALSE THEN
2669: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2665: fnd_message.parse_encoded(encoded_message => l_message,
2666: app_short_name => l_app_name,
2667: message_name => l_message_name);
2668: IF g_person_errored = FALSE THEN
2669: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2670: END IF;
2671: g_person_errored := TRUE;
2672: END;
2673: write_m ('Time after inserting the salary proposal '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));

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

2766: WRITE('Currency in CWB does not match Input Currency of the Element Type');
2767: write_m('Currency for Element '||l_element_input_currency);
2768: write_m('Currency in CWB '||sal_rate_rec.currency);
2769:
2770: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2771: l_message := fnd_message.get_encoded;
2772: fnd_message.set_encoded(l_message);
2773: --
2774: fnd_message.parse_encoded(encoded_message => l_message,

Line 2771: l_message := fnd_message.get_encoded;

2767: write_m('Currency for Element '||l_element_input_currency);
2768: write_m('Currency in CWB '||sal_rate_rec.currency);
2769:
2770: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2771: l_message := fnd_message.get_encoded;
2772: fnd_message.set_encoded(l_message);
2773: --
2774: fnd_message.parse_encoded(encoded_message => l_message,
2775: app_short_name => l_app_name,

Line 2772: fnd_message.set_encoded(l_message);

2768: write_m('Currency in CWB '||sal_rate_rec.currency);
2769:
2770: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2771: l_message := fnd_message.get_encoded;
2772: fnd_message.set_encoded(l_message);
2773: --
2774: fnd_message.parse_encoded(encoded_message => l_message,
2775: app_short_name => l_app_name,
2776: message_name => l_message_name);

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

2770: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
2771: l_message := fnd_message.get_encoded;
2772: fnd_message.set_encoded(l_message);
2773: --
2774: fnd_message.parse_encoded(encoded_message => l_message,
2775: app_short_name => l_app_name,
2776: message_name => l_message_name);
2777: IF g_person_errored = FALSE THEN
2778: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2774: fnd_message.parse_encoded(encoded_message => l_message,
2775: app_short_name => l_app_name,
2776: message_name => l_message_name);
2777: IF g_person_errored = FALSE THEN
2778: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2779: END IF;
2780: l_error := TRUE;
2781: g_person_errored := TRUE;
2782: --fnd_message.raise_error;

Line 2782: --fnd_message.raise_error;

2778: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2779: END IF;
2780: l_error := TRUE;
2781: g_person_errored := TRUE;
2782: --fnd_message.raise_error;
2783:
2784: END IF;
2785: hr_maintain_proposal_api.insert_proposal_component
2786: (p_component_id => l_component_id

Line 2798: l_message := fnd_message.get_encoded;

2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: WRITE('Error in insert_proposal_component : '||SQLERRM);
2797: l_error := TRUE;
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: WHEN OTHERS THEN
2796: WRITE('Error in insert_proposal_component : '||SQLERRM);
2797: l_error := TRUE;
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: l_error := TRUE;
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: g_person_errored := TRUE;
2808: END;
2809:

Line 2910: l_message := fnd_message.get_encoded;

2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: WRITE('Error in update_salary_proposal : '||SQLERRM);
2909: l_error := TRUE;
2910: l_message := fnd_message.get_encoded;
2911: fnd_message.set_encoded(l_message);
2912: --
2913: fnd_message.parse_encoded(encoded_message => l_message,
2914: app_short_name => l_app_name,

Line 2911: fnd_message.set_encoded(l_message);

2907: WHEN OTHERS THEN
2908: WRITE('Error in update_salary_proposal : '||SQLERRM);
2909: l_error := TRUE;
2910: l_message := fnd_message.get_encoded;
2911: fnd_message.set_encoded(l_message);
2912: --
2913: fnd_message.parse_encoded(encoded_message => l_message,
2914: app_short_name => l_app_name,
2915: message_name => l_message_name);

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

2909: l_error := TRUE;
2910: l_message := fnd_message.get_encoded;
2911: fnd_message.set_encoded(l_message);
2912: --
2913: fnd_message.parse_encoded(encoded_message => l_message,
2914: app_short_name => l_app_name,
2915: message_name => l_message_name);
2916: IF g_person_errored = FALSE THEN
2917: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

2913: fnd_message.parse_encoded(encoded_message => l_message,
2914: app_short_name => l_app_name,
2915: message_name => l_message_name);
2916: IF g_person_errored = FALSE THEN
2917: l_warning_text := substr(l_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
2918: END IF;
2919: g_person_errored := TRUE;
2920: END;
2921: END IF;

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

3022: ELSE
3023: g_actn :=
3024: 'The salary is not posted as no pay basis is defined.';
3025: WRITE (g_actn);
3026: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3027: l_message := fnd_message.get_encoded;
3028: fnd_message.set_encoded(l_message);
3029: --
3030: fnd_message.parse_encoded(encoded_message => l_message,

Line 3027: l_message := fnd_message.get_encoded;

3023: g_actn :=
3024: 'The salary is not posted as no pay basis is defined.';
3025: WRITE (g_actn);
3026: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3027: l_message := fnd_message.get_encoded;
3028: fnd_message.set_encoded(l_message);
3029: --
3030: fnd_message.parse_encoded(encoded_message => l_message,
3031: app_short_name => l_app_name,

Line 3028: fnd_message.set_encoded(l_message);

3024: 'The salary is not posted as no pay basis is defined.';
3025: WRITE (g_actn);
3026: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3027: l_message := fnd_message.get_encoded;
3028: fnd_message.set_encoded(l_message);
3029: --
3030: fnd_message.parse_encoded(encoded_message => l_message,
3031: app_short_name => l_app_name,
3032: message_name => l_message_name);

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

3026: fnd_message.set_name ('BEN', 'BEN_94674_CWB_NO_PAY_BASIS');
3027: l_message := fnd_message.get_encoded;
3028: fnd_message.set_encoded(l_message);
3029: --
3030: fnd_message.parse_encoded(encoded_message => l_message,
3031: app_short_name => l_app_name,
3032: message_name => l_message_name);
3033: IF g_person_errored = FALSE THEN
3034: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3030: fnd_message.parse_encoded(encoded_message => l_message,
3031: app_short_name => l_app_name,
3032: message_name => l_message_name);
3033: IF g_person_errored = FALSE THEN
3034: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3035: END IF;
3036: l_error := TRUE;
3037: g_person_errored := TRUE;
3038: END IF;

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

3053: || 'or apply the new salary manually. ';
3054: WRITE (g_actn);
3055: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3056: write_m('Salary in CWB '||l_person_info.base_salary);
3057: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3058: l_message := fnd_message.get_encoded;
3059: fnd_message.set_encoded(l_message);
3060: --
3061: fnd_message.parse_encoded(encoded_message => l_message,

Line 3058: l_message := fnd_message.get_encoded;

3054: WRITE (g_actn);
3055: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3056: write_m('Salary in CWB '||l_person_info.base_salary);
3057: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3058: l_message := fnd_message.get_encoded;
3059: fnd_message.set_encoded(l_message);
3060: --
3061: fnd_message.parse_encoded(encoded_message => l_message,
3062: app_short_name => l_app_name,

Line 3059: fnd_message.set_encoded(l_message);

3055: write_m('Salary in HR '||asg_rec.proposed_salary_n);
3056: write_m('Salary in CWB '||l_person_info.base_salary);
3057: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3058: l_message := fnd_message.get_encoded;
3059: fnd_message.set_encoded(l_message);
3060: --
3061: fnd_message.parse_encoded(encoded_message => l_message,
3062: app_short_name => l_app_name,
3063: message_name => l_message_name);

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

3057: fnd_message.set_name ('BEN', 'BEN_91141_CWB_RECENT_SAL_CHG');
3058: l_message := fnd_message.get_encoded;
3059: fnd_message.set_encoded(l_message);
3060: --
3061: fnd_message.parse_encoded(encoded_message => l_message,
3062: app_short_name => l_app_name,
3063: message_name => l_message_name);
3064: IF g_person_errored = FALSE THEN
3065: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3061: fnd_message.parse_encoded(encoded_message => l_message,
3062: app_short_name => l_app_name,
3063: message_name => l_message_name);
3064: IF g_person_errored = FALSE THEN
3065: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3066: END IF;
3067: l_error := TRUE;
3068: g_person_errored := TRUE;
3069: --fnd_message.raise_error;

Line 3069: --fnd_message.raise_error;

3065: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3066: END IF;
3067: l_error := TRUE;
3068: g_person_errored := TRUE;
3069: --fnd_message.raise_error;
3070: END IF;
3071: IF(NOT l_error) THEN
3072: l_prev_sal := asg_rec.proposed_salary_n;
3073: g_actn := 'Inserting salary proposal for non_comp_salary';

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

3091: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3092:
3093: write_m('Currency for Element '||l_element_input_currency);
3094: write_m('Currency in CWB '||p_currency);
3095: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3096: l_message := fnd_message.get_encoded;
3097: fnd_message.set_encoded(l_message);
3098: --
3099: fnd_message.parse_encoded(encoded_message => l_message,

Line 3096: l_message := fnd_message.get_encoded;

3092:
3093: write_m('Currency for Element '||l_element_input_currency);
3094: write_m('Currency in CWB '||p_currency);
3095: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3096: l_message := fnd_message.get_encoded;
3097: fnd_message.set_encoded(l_message);
3098: --
3099: fnd_message.parse_encoded(encoded_message => l_message,
3100: app_short_name => l_app_name,

Line 3097: fnd_message.set_encoded(l_message);

3093: write_m('Currency for Element '||l_element_input_currency);
3094: write_m('Currency in CWB '||p_currency);
3095: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3096: l_message := fnd_message.get_encoded;
3097: fnd_message.set_encoded(l_message);
3098: --
3099: fnd_message.parse_encoded(encoded_message => l_message,
3100: app_short_name => l_app_name,
3101: message_name => l_message_name);

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

3095: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3096: l_message := fnd_message.get_encoded;
3097: fnd_message.set_encoded(l_message);
3098: --
3099: fnd_message.parse_encoded(encoded_message => l_message,
3100: app_short_name => l_app_name,
3101: message_name => l_message_name);
3102: IF g_person_errored = FALSE THEN
3103: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3099: fnd_message.parse_encoded(encoded_message => l_message,
3100: app_short_name => l_app_name,
3101: message_name => l_message_name);
3102: IF g_person_errored = FALSE THEN
3103: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3104: END IF;
3105: l_error := TRUE;
3106: g_person_errored := TRUE;
3107: END IF;

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

3132: CLOSE c_future_pay_proposal;
3133:
3134: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3135: p_warning := TRUE;
3136: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3137: l_message := fnd_message.get_encoded;
3138: fnd_message.set_encoded(l_message);
3139: --
3140: fnd_message.parse_encoded(encoded_message => l_message,

Line 3137: l_message := fnd_message.get_encoded;

3133:
3134: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3135: p_warning := TRUE;
3136: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3137: l_message := fnd_message.get_encoded;
3138: fnd_message.set_encoded(l_message);
3139: --
3140: fnd_message.parse_encoded(encoded_message => l_message,
3141: app_short_name => l_app_name,

Line 3138: fnd_message.set_encoded(l_message);

3134: IF(future_pay_proposal_rec.proposed_salary_n is not null) THEN
3135: p_warning := TRUE;
3136: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3137: l_message := fnd_message.get_encoded;
3138: fnd_message.set_encoded(l_message);
3139: --
3140: fnd_message.parse_encoded(encoded_message => l_message,
3141: app_short_name => l_app_name,
3142: message_name => l_message_name);

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

3136: fnd_message.set_name ('BEN', 'BEN_94685_FUTURE_SAL_PROP_WARN');
3137: l_message := fnd_message.get_encoded;
3138: fnd_message.set_encoded(l_message);
3139: --
3140: fnd_message.parse_encoded(encoded_message => l_message,
3141: app_short_name => l_app_name,
3142: message_name => l_message_name);
3143: IF g_person_errored = FALSE THEN
3144: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3140: fnd_message.parse_encoded(encoded_message => l_message,
3141: app_short_name => l_app_name,
3142: message_name => l_message_name);
3143: IF g_person_errored = FALSE THEN
3144: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3145: END IF;
3146: g_person_errored := TRUE;
3147: --p_warning_text := p_warning_text||'Future dated salary proposal exists';
3148: END IF;

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

3152: WHEN OTHERS THEN
3153: p_prev_sal := l_prev_sal;
3154: p_pay_proposal_id := l_pay_proposal_id;
3155: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3156: l_error := TRUE; l_message := fnd_message.get_encoded;
3157: fnd_message.set_encoded(l_message);
3158: --
3159: fnd_message.parse_encoded(encoded_message => l_message,
3160: app_short_name => l_app_name,

Line 3157: fnd_message.set_encoded(l_message);

3153: p_prev_sal := l_prev_sal;
3154: p_pay_proposal_id := l_pay_proposal_id;
3155: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3156: l_error := TRUE; l_message := fnd_message.get_encoded;
3157: fnd_message.set_encoded(l_message);
3158: --
3159: fnd_message.parse_encoded(encoded_message => l_message,
3160: app_short_name => l_app_name,
3161: message_name => l_message_name);

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

3155: WRITE('Exception at insert_salary_proposal : '||SQLERRM);
3156: l_error := TRUE; l_message := fnd_message.get_encoded;
3157: fnd_message.set_encoded(l_message);
3158: --
3159: fnd_message.parse_encoded(encoded_message => l_message,
3160: app_short_name => l_app_name,
3161: message_name => l_message_name);
3162: IF g_person_errored = FALSE THEN
3163: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3159: fnd_message.parse_encoded(encoded_message => l_message,
3160: app_short_name => l_app_name,
3161: message_name => l_message_name);
3162: IF g_person_errored = FALSE THEN
3163: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3164: END IF;
3165: g_person_errored := TRUE;
3166: --p_warning_text := p_warning_text||SQLERRM;
3167: END;

Line 3275: l_message := fnd_message.get_encoded;

3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: WRITE('Exception at create_enrollment_element : '||SQLERRM);
3274: l_error := TRUE;
3275: l_message := fnd_message.get_encoded;
3276: fnd_message.set_encoded(l_message);
3277: --
3278: fnd_message.parse_encoded(encoded_message => l_message,
3279: app_short_name => l_app_name,

Line 3276: fnd_message.set_encoded(l_message);

3272: WHEN OTHERS THEN
3273: WRITE('Exception at create_enrollment_element : '||SQLERRM);
3274: l_error := TRUE;
3275: l_message := fnd_message.get_encoded;
3276: fnd_message.set_encoded(l_message);
3277: --
3278: fnd_message.parse_encoded(encoded_message => l_message,
3279: app_short_name => l_app_name,
3280: message_name => l_message_name);

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

3274: l_error := TRUE;
3275: l_message := fnd_message.get_encoded;
3276: fnd_message.set_encoded(l_message);
3277: --
3278: fnd_message.parse_encoded(encoded_message => l_message,
3279: app_short_name => l_app_name,
3280: message_name => l_message_name);
3281: IF g_person_errored = FALSE THEN
3282: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3278: fnd_message.parse_encoded(encoded_message => l_message,
3279: app_short_name => l_app_name,
3280: message_name => l_message_name);
3281: IF g_person_errored = FALSE THEN
3282: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3283: END IF;
3284: g_person_errored := TRUE;
3285: END;
3286: g_actn := 'updating the element entry id into person rates ...';

Line 3309: l_message := fnd_message.get_encoded;

3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: WRITE('Exception at update_person_rate : '||SQLERRM);
3308: l_error := TRUE;
3309: l_message := fnd_message.get_encoded;
3310: fnd_message.set_encoded(l_message);
3311: --
3312: fnd_message.parse_encoded(encoded_message => l_message,
3313: app_short_name => l_app_name,

Line 3310: fnd_message.set_encoded(l_message);

3306: WHEN OTHERS THEN
3307: WRITE('Exception at update_person_rate : '||SQLERRM);
3308: l_error := TRUE;
3309: l_message := fnd_message.get_encoded;
3310: fnd_message.set_encoded(l_message);
3311: --
3312: fnd_message.parse_encoded(encoded_message => l_message,
3313: app_short_name => l_app_name,
3314: message_name => l_message_name);

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

3308: l_error := TRUE;
3309: l_message := fnd_message.get_encoded;
3310: fnd_message.set_encoded(l_message);
3311: --
3312: fnd_message.parse_encoded(encoded_message => l_message,
3313: app_short_name => l_app_name,
3314: message_name => l_message_name);
3315: IF g_person_errored = FALSE THEN
3316: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;

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

3312: fnd_message.parse_encoded(encoded_message => l_message,
3313: app_short_name => l_app_name,
3314: message_name => l_message_name);
3315: IF g_person_errored = FALSE THEN
3316: p_warning_text := p_warning_text||fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get;
3317: END IF;
3318: g_person_errored := TRUE;
3319: END;
3320:

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

3494: p_group_oipl_id => rt_rec.group_oipl_id,
3495: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_date);
3496: if(l_override_start_date is null) then
3497: l_error := TRUE;
3498: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3499: l_message := fnd_message.get_encoded;
3500: fnd_message.set_encoded(l_message);
3501: fnd_message.parse_encoded(encoded_message => l_message,
3502: app_short_name => l_app_name,

Line 3499: l_message := fnd_message.get_encoded;

3495: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_date);
3496: if(l_override_start_date is null) then
3497: l_error := TRUE;
3498: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3499: l_message := fnd_message.get_encoded;
3500: fnd_message.set_encoded(l_message);
3501: fnd_message.parse_encoded(encoded_message => l_message,
3502: app_short_name => l_app_name,
3503: message_name => l_message_name);

Line 3500: fnd_message.set_encoded(l_message);

3496: if(l_override_start_date is null) then
3497: l_error := TRUE;
3498: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3499: l_message := fnd_message.get_encoded;
3500: fnd_message.set_encoded(l_message);
3501: fnd_message.parse_encoded(encoded_message => l_message,
3502: app_short_name => l_app_name,
3503: message_name => l_message_name);
3504: IF g_person_errored = FALSE THEN

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

3497: l_error := TRUE;
3498: fnd_message.set_name ('BEN', 'BEN_94906_CWB_NO_RATE_STRT_DT');
3499: l_message := fnd_message.get_encoded;
3500: fnd_message.set_encoded(l_message);
3501: fnd_message.parse_encoded(encoded_message => l_message,
3502: app_short_name => l_app_name,
3503: message_name => l_message_name);
3504: IF g_person_errored = FALSE THEN
3505: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

3501: fnd_message.parse_encoded(encoded_message => l_message,
3502: app_short_name => l_app_name,
3503: message_name => l_message_name);
3504: IF g_person_errored = FALSE THEN
3505: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
3506: END IF;
3507: g_person_errored := TRUE;
3508: l_effective_date := null;
3509: else

Line 3589: fnd_message.CLEAR();

3585: EXCEPTION
3586: WHEN others THEN
3587: WRITE('No Element Rule Found ');
3588: --WRITE(SQLERRM);
3589: fnd_message.CLEAR();
3590: END;
3591: if(l_element_type_id is null and l_input_value_id is null) then
3592: get_plan_abr_info(
3593: p_lf_evt_ocrd_date => p_lf_evt_ocrd_date

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

3700:
3701: IF(rt_rec.units is null) THEN
3702: IF(l_input_currency<>rt_rec.currency) THEN
3703: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3704: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3705: l_error := TRUE;
3706:
3707: l_message := fnd_message.get_encoded;
3708: fnd_message.set_encoded(l_message);

Line 3707: l_message := fnd_message.get_encoded;

3703: WRITE('Currency in CWB does not match Input Currency of the Element Type');
3704: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3705: l_error := TRUE;
3706:
3707: l_message := fnd_message.get_encoded;
3708: fnd_message.set_encoded(l_message);
3709: --
3710: fnd_message.parse_encoded(encoded_message => l_message,
3711: app_short_name => l_app_name,

Line 3708: fnd_message.set_encoded(l_message);

3704: fnd_message.set_name ('BEN', 'BEN_94673_EL_CURR_MISMATCH');
3705: l_error := TRUE;
3706:
3707: l_message := fnd_message.get_encoded;
3708: fnd_message.set_encoded(l_message);
3709: --
3710: fnd_message.parse_encoded(encoded_message => l_message,
3711: app_short_name => l_app_name,
3712: message_name => l_message_name);

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

3706:
3707: l_message := fnd_message.get_encoded;
3708: fnd_message.set_encoded(l_message);
3709: --
3710: fnd_message.parse_encoded(encoded_message => l_message,
3711: app_short_name => l_app_name,
3712: message_name => l_message_name);
3713: IF g_person_errored = FALSE THEN
3714: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);

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

3710: fnd_message.parse_encoded(encoded_message => l_message,
3711: app_short_name => l_app_name,
3712: message_name => l_message_name);
3713: IF g_person_errored = FALSE THEN
3714: l_warning := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
3715: END IF;
3716: g_person_errored := TRUE;
3717:
3718: END IF;

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

4063: IF (((l_asg_txn.assignment_id is not null) and (l_asg_updt_eff_date >= l_actual_termination_date)) OR
4064: ((l_perf_txn.assignment_id is not null) and (l_perf_revw_strt_dt >= l_actual_termination_date)) ) THEN
4065: WRITE ('The person was terminated on ' || l_actual_termination_date
4066: || ' promotion or performance was not applied' );
4067: fnd_message.set_name ('BEN', 'BEN_93365_PERSON_TERMINATED');
4068: l_error := TRUE;
4069: --fnd_message.raise_error;
4070: END IF;
4071: END IF;

Line 4069: --fnd_message.raise_error;

4065: WRITE ('The person was terminated on ' || l_actual_termination_date
4066: || ' promotion or performance was not applied' );
4067: fnd_message.set_name ('BEN', 'BEN_93365_PERSON_TERMINATED');
4068: l_error := TRUE;
4069: --fnd_message.raise_error;
4070: END IF;
4071: END IF;
4072: END IF;
4073:

Line 4109: fnd_message.raise_error;

4105: l_perf_person_rec.rating_type := l_perf_txn.attribute2;
4106: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);
4107:
4108: if(l_error) then
4109: fnd_message.raise_error;
4110: end if;
4111:
4112: ben_cwb_asg_update.process_rating (p_person_id => p_person_id
4113: , p_txn_rec => l_perf_txn

Line 4137: l_message := fnd_message.get_encoded;

4133: EXCEPTION
4134: WHEN OTHERS THEN
4135: WRITE('Error at Performance rating '||SQLERRM);
4136: l_perf_person_rec.status := 'E';
4137: l_message := fnd_message.get_encoded;
4138: fnd_message.set_encoded(l_message);
4139: --
4140: fnd_message.parse_encoded(encoded_message => l_message,
4141: app_short_name => l_app_name,

Line 4138: fnd_message.set_encoded(l_message);

4134: WHEN OTHERS THEN
4135: WRITE('Error at Performance rating '||SQLERRM);
4136: l_perf_person_rec.status := 'E';
4137: l_message := fnd_message.get_encoded;
4138: fnd_message.set_encoded(l_message);
4139: --
4140: fnd_message.parse_encoded(encoded_message => l_message,
4141: app_short_name => l_app_name,
4142: message_name => l_message_name);

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

4136: l_perf_person_rec.status := 'E';
4137: l_message := fnd_message.get_encoded;
4138: fnd_message.set_encoded(l_message);
4139: --
4140: fnd_message.parse_encoded(encoded_message => l_message,
4141: app_short_name => l_app_name,
4142: message_name => l_message_name);
4143: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4144: g_person_errored := TRUE;

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

4139: --
4140: fnd_message.parse_encoded(encoded_message => l_message,
4141: app_short_name => l_app_name,
4142: message_name => l_message_name);
4143: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4144: g_person_errored := TRUE;
4145: WRITE(l_perf_person_rec.error_or_warning_text);
4146: ROLLBACK TO process_rating;
4147: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN

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

4144: g_person_errored := TRUE;
4145: WRITE(l_perf_person_rec.error_or_warning_text);
4146: ROLLBACK TO process_rating;
4147: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN
4148: --l_perf_person_rec.error_or_warning_text := fnd_message.get;
4149: write_m ('Time after processing rating '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4150: WRITE('Failed Performance rating is '||l_perf_person_rec.performance_rating);
4151: l_rating_status := 'CWB_PERF_SUS';
4152: ELSE

Line 4280: fnd_message.raise_error;

4276: l_promo_person_rec.asgn_change_reason := l_asg_txn.attribute3;
4277: l_promo_person_rec.effective_date := l_asg_updt_eff_date;
4278:
4279: if(l_error) then
4280: fnd_message.raise_error;
4281: end if;
4282:
4283: ben_cwb_asg_update.process_promotions (p_person_id => p_person_id
4284: , p_asg_txn_rec => l_asg_txn

Line 4304: l_message := fnd_message.get_encoded;

4300: EXCEPTION
4301: WHEN OTHERS THEN
4302: WRITE('Error at processing promotions'||SQLERRM);
4303: l_promo_person_rec.status := 'E';
4304: l_message := fnd_message.get_encoded;
4305: fnd_message.set_encoded(l_message);
4306: --
4307: fnd_message.parse_encoded(encoded_message => l_message,
4308: app_short_name => l_app_name,

Line 4305: fnd_message.set_encoded(l_message);

4301: WHEN OTHERS THEN
4302: WRITE('Error at processing promotions'||SQLERRM);
4303: l_promo_person_rec.status := 'E';
4304: l_message := fnd_message.get_encoded;
4305: fnd_message.set_encoded(l_message);
4306: --
4307: fnd_message.parse_encoded(encoded_message => l_message,
4308: app_short_name => l_app_name,
4309: message_name => l_message_name);

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

4303: l_promo_person_rec.status := 'E';
4304: l_message := fnd_message.get_encoded;
4305: fnd_message.set_encoded(l_message);
4306: --
4307: fnd_message.parse_encoded(encoded_message => l_message,
4308: app_short_name => l_app_name,
4309: message_name => l_message_name);
4310: l_promo_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4311: WRITE(l_promo_person_rec.error_or_warning_text);

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

4306: --
4307: fnd_message.parse_encoded(encoded_message => l_message,
4308: app_short_name => l_app_name,
4309: message_name => l_message_name);
4310: l_promo_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4311: WRITE(l_promo_person_rec.error_or_warning_text);
4312: ROLLBACK TO process_promotions;
4313: l_promo_error := TRUE;
4314: l_error := TRUE;

Line 4395: l_message := fnd_message.get_encoded;

4391: EXCEPTION
4392: WHEN OTHERS THEN
4393: WRITE('Error at Ranking '||SQLERRM);
4394: l_perf_person_rec.status := 'E';
4395: l_message := fnd_message.get_encoded;
4396: fnd_message.set_encoded(l_message);
4397: --
4398: fnd_message.parse_encoded(encoded_message => l_message,
4399: app_short_name => l_app_name,

Line 4396: fnd_message.set_encoded(l_message);

4392: WHEN OTHERS THEN
4393: WRITE('Error at Ranking '||SQLERRM);
4394: l_perf_person_rec.status := 'E';
4395: l_message := fnd_message.get_encoded;
4396: fnd_message.set_encoded(l_message);
4397: --
4398: fnd_message.parse_encoded(encoded_message => l_message,
4399: app_short_name => l_app_name,
4400: message_name => l_message_name);

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

4394: l_perf_person_rec.status := 'E';
4395: l_message := fnd_message.get_encoded;
4396: fnd_message.set_encoded(l_message);
4397: --
4398: fnd_message.parse_encoded(encoded_message => l_message,
4399: app_short_name => l_app_name,
4400: message_name => l_message_name);
4401: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4402: WRITE(l_perf_person_rec.error_or_warning_text);

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

4397: --
4398: fnd_message.parse_encoded(encoded_message => l_message,
4399: app_short_name => l_app_name,
4400: message_name => l_message_name);
4401: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4402: WRITE(l_perf_person_rec.error_or_warning_text);
4403: ROLLBACK TO process_ranking;
4404: l_perf_error := TRUE;
4405: l_error := TRUE;

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

4737: IF g_cwb_rpt_person.group_oipl_id <> -1 THEN
4738: g_cwb_rpt_person.opt_name := g_cache_group_options (g_cwb_rpt_person.group_oipl_id);
4739: END IF;
4740:
4741: g_cwb_rpt_person.error_or_warning_text := substr(benutils.get_message_name || ' '||fnd_message.get,1,2000);
4742:
4743: IF l_comp_error THEN
4744: g_cwb_rpt_person.error_or_warning_text := substr(g_cwb_rpt_person.error_or_warning_text ||
4745: ' '||'Person ' || p_person_id || ' failed for compensation',1,2000);

Line 4769: WRITE (fnd_message.get);

4765: -- g_cache_cwb_rpt_person (g_cache_cwb_rpt_person.COUNT + 1) := g_cwb_rpt_person;
4766:
4767: END IF;
4768: WRITE (benutils.get_message_name);
4769: WRITE (fnd_message.get);
4770: WRITE (SQLERRM||' in process_person');
4771: RAISE ben_batch_utils.g_record_error;
4772: END;
4773:

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

4955: IF (g_persons_errored > g_max_errors_allowed)
4956: THEN
4957: g_actn := '<> ';
4958: WRITE (g_actn);
4959: fnd_message.set_name ('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
4960: -- removed RAISE ben_batch_utils.g_record_error;
4961: raise g_max_error;
4962: END IF;
4963:

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

4969: ELSE
4970: --
4971: g_actn := 'Erroring out since no person is found in range...';
4972: --
4973: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
4974: fnd_message.set_token ('PROCEDURE', g_proc);
4975: fnd_message.raise_error;
4976: END IF;
4977:

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

4970: --
4971: g_actn := 'Erroring out since no person is found in range...';
4972: --
4973: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
4974: fnd_message.set_token ('PROCEDURE', g_proc);
4975: fnd_message.raise_error;
4976: END IF;
4977:
4978: COMMIT;

Line 4975: fnd_message.raise_error;

4971: g_actn := 'Erroring out since no person is found in range...';
4972: --
4973: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
4974: fnd_message.set_token ('PROCEDURE', g_proc);
4975: fnd_message.raise_error;
4976: END IF;
4977:
4978: COMMIT;
4979: END LOOP;

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

4991: WRITE(SQLERRM);
4992: print_cache;
4993: table_corrections(p_benefit_action_id);
4994: COMMIT;
4995: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4996: fnd_message.set_token ('PROCEDURE', g_proc);
4997: fnd_message.set_token ('STEP', g_actn);
4998: fnd_message.raise_error;
4999: END;

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

4992: print_cache;
4993: table_corrections(p_benefit_action_id);
4994: COMMIT;
4995: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4996: fnd_message.set_token ('PROCEDURE', g_proc);
4997: fnd_message.set_token ('STEP', g_actn);
4998: fnd_message.raise_error;
4999: END;
5000:

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

4993: table_corrections(p_benefit_action_id);
4994: COMMIT;
4995: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4996: fnd_message.set_token ('PROCEDURE', g_proc);
4997: fnd_message.set_token ('STEP', g_actn);
4998: fnd_message.raise_error;
4999: END;
5000:
5001: PROCEDURE process (

Line 4998: fnd_message.raise_error;

4994: COMMIT;
4995: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4996: fnd_message.set_token ('PROCEDURE', g_proc);
4997: fnd_message.set_token ('STEP', g_actn);
4998: fnd_message.raise_error;
4999: END;
5000:
5001: PROCEDURE process (
5002: errbuf OUT NOCOPY VARCHAR2

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

5420: END LOOP;
5421: ELSIF l_num_ranges = 0
5422: THEN
5423: WRITE ('<< No Person got selected with above selection criteria >>');
5424: fnd_message.set_name ('BEN', 'BEN_91769_NOONE_TO_PROCESS');
5425: fnd_message.set_token ('PROC', g_proc);
5426: RAISE l_silent_error;
5427: END IF;
5428:

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

5421: ELSIF l_num_ranges = 0
5422: THEN
5423: WRITE ('<< No Person got selected with above selection criteria >>');
5424: fnd_message.set_name ('BEN', 'BEN_91769_NOONE_TO_PROCESS');
5425: fnd_message.set_token ('PROC', g_proc);
5426: RAISE l_silent_error;
5427: END IF;
5428:
5429: write_m ('Time after launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));

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

5487: Close c_slaves;
5488: End loop;
5489: EXCEPTION
5490: WHEN l_slave_errored THEN
5491: --fnd_message.set_name ('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5492: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5493: g_actn:= 'slave processes';
5494: raise g_slave_error;
5495: END;

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

5488: End loop;
5489: EXCEPTION
5490: WHEN l_slave_errored THEN
5491: --fnd_message.set_name ('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5492: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5493: g_actn:= 'slave processes';
5494: raise g_slave_error;
5495: END;
5496:

Line 5501: WRITE (fnd_message.get);

5497: EXCEPTION
5498: --
5499: WHEN l_silent_error
5500: THEN
5501: WRITE (fnd_message.get);
5502: IF (l_num_ranges > 0) THEN
5503: WRITE('END_PROCESS');
5504: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5505: end_process (p_benefit_action_id => l_benefit_action_id

Line 5512: WRITE (fnd_message.get);

5508: );
5509: END IF;
5510: --
5511: WHEN g_slave_error THEN
5512: WRITE (fnd_message.get);
5513: WRITE (SQLERRM);
5514: WRITE ('Big Error Occurred');
5515: IF (l_num_ranges > 0) THEN
5516: WRITE('END_PROCESS');

Line 5523: fnd_message.clear();

5519: , p_person_selected => l_num_persons
5520: , p_business_group_id => p_bg_id
5521: );
5522: END IF;
5523: fnd_message.clear();
5524: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5525: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);

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

5520: , p_business_group_id => p_bg_id
5521: );
5522: END IF;
5523: fnd_message.clear();
5524: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5525: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5528: --

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

5521: );
5522: END IF;
5523: fnd_message.clear();
5524: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5525: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5528: --
5529: WHEN g_max_error THEN

Line 5526: --fnd_message.raise_error;

5522: END IF;
5523: fnd_message.clear();
5524: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5525: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5528: --
5529: WHEN g_max_error THEN
5530: WRITE (fnd_message.get);

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

5523: fnd_message.clear();
5524: fnd_message.set_name('BEN', 'BEN_94890_CWB_PROC_SLAVE_ERROR');
5525: --fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5528: --
5529: WHEN g_max_error THEN
5530: WRITE (fnd_message.get);
5531: WRITE (SQLERRM);

Line 5530: WRITE (fnd_message.get);

5526: --fnd_message.raise_error;
5527: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5528: --
5529: WHEN g_max_error THEN
5530: WRITE (fnd_message.get);
5531: WRITE (SQLERRM);
5532: WRITE ('Big Error Occurred');
5533: IF (l_num_ranges > 0) THEN
5534: WRITE('END_PROCESS');

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

5538: , p_business_group_id => p_bg_id
5539: );
5540: END IF;
5541:
5542: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5543: --fnd_message.raise_error;
5544: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5545: --
5546: WHEN OTHERS THEN

Line 5543: --fnd_message.raise_error;

5539: );
5540: END IF;
5541:
5542: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5543: --fnd_message.raise_error;
5544: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5545: --
5546: WHEN OTHERS THEN
5547: WRITE (fnd_message.get);

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

5540: END IF;
5541:
5542: fnd_message.set_name('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5543: --fnd_message.raise_error;
5544: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5545: --
5546: WHEN OTHERS THEN
5547: WRITE (fnd_message.get);
5548: WRITE (SQLERRM);

Line 5547: WRITE (fnd_message.get);

5543: --fnd_message.raise_error;
5544: RAISE_APPLICATION_ERROR(-20001,fnd_global.Newline||fnd_message.get||fnd_global.Newline);
5545: --
5546: WHEN OTHERS THEN
5547: WRITE (fnd_message.get);
5548: WRITE (SQLERRM);
5549: WRITE ('Big Error Occurred');
5550: IF (l_num_ranges > 0) THEN
5551: WRITE('END_PROCESS');

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

5555: , p_business_group_id => p_bg_id
5556: );
5557: END IF;
5558:
5559: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5560: fnd_message.set_token ('PROCEDURE', g_proc);
5561: fnd_message.set_token ('STEP', g_actn);
5562: fnd_message.raise_error;
5563: END;

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

5556: );
5557: END IF;
5558:
5559: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5560: fnd_message.set_token ('PROCEDURE', g_proc);
5561: fnd_message.set_token ('STEP', g_actn);
5562: fnd_message.raise_error;
5563: END;
5564: END;

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

5557: END IF;
5558:
5559: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5560: fnd_message.set_token ('PROCEDURE', g_proc);
5561: fnd_message.set_token ('STEP', g_actn);
5562: fnd_message.raise_error;
5563: END;
5564: END;

Line 5562: fnd_message.raise_error;

5558:
5559: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5560: fnd_message.set_token ('PROCEDURE', g_proc);
5561: fnd_message.set_token ('STEP', g_actn);
5562: fnd_message.raise_error;
5563: END;
5564: END;