553: if g_debug then
554: hr_utility.set_location(l_proc,0);
555: end if;
556: --
557: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
558: c_fut_exist_mesg := fnd_message.get;
559: --
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
554: hr_utility.set_location(l_proc,0);
555: end if;
556: --
557: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
558: c_fut_exist_mesg := fnd_message.get;
559: --
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
562: --
556: --
557: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
558: c_fut_exist_mesg := fnd_message.get;
559: --
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
562: --
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
557: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
558: c_fut_exist_mesg := fnd_message.get;
559: --
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
562: --
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
565: --
559: --
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
562: --
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
565: --
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
560: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
561: c_already_upd_mesg := fnd_message.get;
562: --
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
565: --
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
568: --
562: --
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
565: --
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
568: --
569: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
570: c_mr_null_mesg := fnd_message.get;
563: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_AM');
564: c_fut_am_mesg := fnd_message.get;
565: --
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
568: --
569: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
570: c_mr_null_mesg := fnd_message.get;
571: --
565: --
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
568: --
569: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
570: c_mr_null_mesg := fnd_message.get;
571: --
572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
566: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_AM_NULL');
567: c_am_null_mesg := fnd_message.get;
568: --
569: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_MR_NULL');
570: c_mr_null_mesg := fnd_message.get;
571: --
572: if g_debug then
573: hr_utility.trace('c_fut_exist_mesg : '||c_fut_exist_mesg);
574: hr_utility.trace('c_already_upd_mesg : '||c_already_upd_mesg);
618: if g_debug then
619: hr_utility.set_location(l_proc,0);
620: end if;
621: --
622: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_FUT_EXIST');
623: c_dep_fut_cei_exist_mesg := fnd_message.get;
624: --
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
619: hr_utility.set_location(l_proc,0);
620: end if;
621: --
622: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_FUT_EXIST');
623: c_dep_fut_cei_exist_mesg := fnd_message.get;
624: --
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
627: --
621: --
622: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_FUT_EXIST');
623: c_dep_fut_cei_exist_mesg := fnd_message.get;
624: --
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
627: --
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
622: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_FUT_EXIST');
623: c_dep_fut_cei_exist_mesg := fnd_message.get;
624: --
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
627: --
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
630: --
624: --
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
627: --
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
630: --
631: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
632: c_dep_fut_ee_exist_mesg := fnd_message.get;
625: fnd_message.set_name('PAY','PAY_JP_MIG_CEI_OE_FUT_EXIST');
626: c_dep_fut_cei_oe_exist_mesg := fnd_message.get;
627: --
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
630: --
631: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
632: c_dep_fut_ee_exist_mesg := fnd_message.get;
633: --
627: --
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
630: --
631: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
632: c_dep_fut_ee_exist_mesg := fnd_message.get;
633: --
634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
628: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_ALREADY_UPD');
629: c_dep_already_ee_upd_mesg := fnd_message.get;
630: --
631: fnd_message.set_name('PAY','PAY_JP_MIG_SMR_FUT_EXIST');
632: c_dep_fut_ee_exist_mesg := fnd_message.get;
633: --
634: if g_debug then
635: hr_utility.trace('c_dep_fut_cei_exist_mesg : '||c_dep_fut_cei_exist_mesg);
636: hr_utility.trace('c_dep_fut_cei_oe_exist_mesg : '||c_dep_fut_cei_oe_exist_mesg);
651: --
652: if sqlcode = -20001 then
653: --
654: declare
655: l_sqlerrm varchar2(2000) := fnd_message.get;
656: begin
657: if l_sqlerrm is not null then
658: return l_sqlerrm;
659: else
1360: when hr_api.object_locked then
1361: --
1362: if g_debug then
1363: hr_utility.set_location(l_proc,-1000);
1364: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1365: end if;
1366: --
1367: if g_sql_run = 'Y' then
1368: --
1367: if g_sql_run = 'Y' then
1368: --
1369: if g_log = 'Y' then
1370: --
1371: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1372: --
1373: end if;
1374: --
1375: else
1373: end if;
1374: --
1375: else
1376: --
1377: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
1378: --
1379: end if;
1380: --
1381: when others then
2718: when hr_api.object_locked then
2719: --
2720: if g_debug then
2721: hr_utility.set_location(l_proc,-1000);
2722: hr_utility.trace(to_char(p_assignment_id)||':'||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2723: end if;
2724: --
2725: if g_sql_run = 'Y' then
2726: --
2725: if g_sql_run = 'Y' then
2726: --
2727: if g_log = 'Y' then
2728: --
2729: hr_utility.trace(rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2730: --
2731: end if;
2732: --
2733: else
2731: end if;
2732: --
2733: else
2734: --
2735: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||fnd_message.get_string('FND','FND_LOCK_RECORD_ERROR'));
2736: --
2737: end if;
2738: --
2739: when others then