DBA Data[Home] [Help]

APPS.HR_JP_DATA_MIGRATION_PKG dependencies on FND_FILE

Line 769: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');

765: --
766: if g_qualify_ini_ass_id is null
767: or g_qualify_ini_ass_id = p_assignment_id then
768: --
769: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');
770: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');
771: --
772: g_qualify_ini_ass_id := p_assignment_id;
773: --

Line 770: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');

766: if g_qualify_ini_ass_id is null
767: or g_qualify_ini_ass_id = p_assignment_id then
768: --
769: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');
770: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');
771: --
772: g_qualify_ini_ass_id := p_assignment_id;
773: --
774: end if;

Line 803: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number MR SMR Exp SMR');

799: --
800: if g_migrate_ini_ass_id is null
801: or g_migrate_ini_ass_id = p_assignment_id then
802: --
803: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number MR SMR Exp SMR');
804: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------------ ------------ ---------- ----------');
805: --
806: g_migrate_ini_ass_id := p_assignment_id;
807: --

Line 804: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------------ ------------ ---------- ----------');

800: if g_migrate_ini_ass_id is null
801: or g_migrate_ini_ass_id = p_assignment_id then
802: --
803: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number MR SMR Exp SMR');
804: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------------ ------------ ---------- ----------');
805: --
806: g_migrate_ini_ass_id := p_assignment_id;
807: --
808: end if;

Line 954: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_already_upd_mesg);

950: end if;
951: --
952: else
953: --
954: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_already_upd_mesg);
955: --
956: end if;
957: --
958: end if;

Line 989: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_exist_mesg);

985: end if;
986: --
987: else
988: --
989: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_exist_mesg);
990: --
991: end if;
992: --
993: end if;

Line 1030: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_am_mesg);

1026: end if;
1027: --
1028: else
1029: --
1030: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_fut_am_mesg);
1031: --
1032: end if;
1033: --
1034: end if;

Line 1050: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_am_null_mesg);

1046: end if;
1047: --
1048: else
1049: --
1050: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_am_null_mesg);
1051: --
1052: end if;
1053: --
1054: end if;

Line 1087: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_mr_null_mesg);

1083: end if;
1084: --
1085: else
1086: --
1087: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_mr_null_mesg);
1088: --
1089: end if;
1090: --
1091: else

Line 1329: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));

1325: end if;
1326: --
1327: else
1328: --
1329: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));
1330: --
1331: end if;
1332: --
1333: else

Line 1345: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' X '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));

1341: end if;
1342: --
1343: else
1344: --
1345: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' X '||lpad(l_exp_mr_eev,10)||' '||lpad(nvl(l_smr_eev,' '),10)||' '||lpad(l_exp_smr_eev,10));
1346: --
1347: end if;
1348: --
1349: if g_detail_debug then

Line 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'));

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

Line 1398: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);

1394: end if;
1395: --
1396: else
1397: --
1398: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);
1399: --
1400: end if;
1401: --
1402: end mig_smr_assact;

Line 1731: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');

1727: --
1728: if g_qualify_ini_ass_id is null
1729: or g_qualify_ini_ass_id = p_assignment_id then
1730: --
1731: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');
1732: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1733: --
1734: g_qualify_ini_ass_id := p_assignment_id;
1735: --

Line 1732: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');

1728: if g_qualify_ini_ass_id is null
1729: or g_qualify_ini_ass_id = p_assignment_id then
1730: --
1731: fnd_file.put_line(fnd_file.log, 'Business Group Name Assignment Number Message');
1732: fnd_file.put_line(fnd_file.log, '------------------------------ ------------------------------ --------------------------------------------------------------------------------');
1733: --
1734: g_qualify_ini_ass_id := p_assignment_id;
1735: --
1736: end if;

Line 1765: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number Age Type Contact');

1761: --
1762: if g_migrate_ini_ass_id is null
1763: or g_migrate_ini_ass_id = p_assignment_id then
1764: --
1765: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number Age Type Contact');
1766: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');
1767: --
1768: g_migrate_ini_ass_id := p_assignment_id;
1769: --

Line 1766: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');

1762: if g_migrate_ini_ass_id is null
1763: or g_migrate_ini_ass_id = p_assignment_id then
1764: --
1765: fnd_file.put_line(fnd_file.output, 'Business Group Name Assignment Number Age Type Contact');
1766: fnd_file.put_line(fnd_file.output, '------------------------------ ------------------------- ---- ------ ------------------------------------------------------------');
1767: --
1768: g_migrate_ini_ass_id := p_assignment_id;
1769: --
1770: end if;

Line 2105: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_exist_mesg);

2101: end if;
2102: --
2103: else
2104: --
2105: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_exist_mesg);
2106: --
2107: end if;
2108: --
2109: end if;

Line 2144: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_oe_exist_mesg);

2140: end if;
2141: --
2142: else
2143: --
2144: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_cei_oe_exist_mesg);
2145: --
2146: end if;
2147: --
2148: end if;

Line 2188: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_already_ee_upd_mesg);

2184: end if;
2185: --
2186: else
2187: --
2188: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_already_ee_upd_mesg);
2189: --
2190: end if;
2191: --
2192: end if;

Line 2225: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_ee_exist_mesg);

2221: end if;
2222: --
2223: else
2224: --
2225: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||c_dep_fut_ee_exist_mesg);
2226: --
2227: end if;
2228: --
2229: end if;

Line 2472: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));

2468: end if;
2469: --
2470: else
2471: --
2472: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));
2473: --
2474: end if;
2475: --
2476: else

Line 2488: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));

2484: end if;
2485: --
2486: else
2487: --
2488: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei.c_age,4)||' CEI '||rpad(l_csr_cei.c_full_name,60));
2489: --
2490: end if;
2491: --
2492: end if;

Line 2539: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));

2535: end if;
2536: --
2537: else
2538: --
2539: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));
2540: --
2541: end if;
2542: --
2543: else

Line 2555: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));

2551: end if;
2552: --
2553: else
2554: --
2555: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,25)||' '||rpad(l_csr_cei_oe.c_age,4)||' CEI OE '||rpad(l_csr_cei_oe.c_full_name,60));
2556: --
2557: end if;
2558: --
2559: end if;

Line 2626: -- fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2622: -- end if;
2623: -- --
2624: -- else
2625: -- --
2626: -- fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2627: -- --
2628: -- end if;
2629: -- --
2630: -- else

Line 2642: -- fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2638: -- end if;
2639: -- --
2640: -- else
2641: -- --
2642: -- fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2643: -- --
2644: -- end if;
2645: -- --
2646: -- end if;

Line 2687: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2683: end if;
2684: --
2685: else
2686: --
2687: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2688: --
2689: end if;
2690: --
2691: else

Line 2703: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');

2699: end if;
2700: --
2701: else
2702: --
2703: fnd_file.put_line(fnd_file.output, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' EE');
2704: --
2705: end if;
2706: --
2707: end if;

Line 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'));

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

Line 2756: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);

2752: end if;
2753: --
2754: else
2755: --
2756: fnd_file.put_line(fnd_file.log, rpad(p_business_group_name,30)||' '||rpad(p_assignment_number,30)||' '||get_sqlerrm);
2757: --
2758: end if;
2759: --
2760: end mig_dep_assact;