DBA Data[Home] [Help]

APPS.PAY_ITERATE dependencies on HR_UTILITY

Line 957: hr_utility.trace('l_rt_id: '||to_char(l_rt_id));

953: -- remove check_for_children as going to do a direct delete, not an api delete.
954: -- children will be temporarily orphaned, til the row is reinserted with
955: -- original id
956: --
957: hr_utility.trace('l_rt_id: '||to_char(l_rt_id));
958: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));
959: --
960: -- first get the original run_type_id
961: --

Line 958: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));

954: -- children will be temporarily orphaned, til the row is reinserted with
955: -- original id
956: --
957: hr_utility.trace('l_rt_id: '||to_char(l_rt_id));
958: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));
959: --
960: -- first get the original run_type_id
961: --
962: pay_prt_ins.set_base_key_value(p_rt_id);

Line 1037: hr_utility.trace('AFTER ZAP CREATE');

1033: ,p_effective_end_date => l_out_eed
1034: ,p_object_version_number => l_out_ovn
1035: );
1036: --
1037: hr_utility.trace('AFTER ZAP CREATE');
1038: --
1039: -- set the uploaded cache
1040: --
1041: select run_type_id

Line 1328: hr_utility.trace('before SET_END_DATE');

1324: --
1325: if g_to_be_uploaded_eed <> hr_api.g_eot then
1326: --
1327: if l_call_set_end_date then
1328: hr_utility.trace('before SET_END_DATE');
1329: set_end_date;
1330: hr_utility.trace('after SET_END_DATE');
1331: else
1332: null;

Line 1330: hr_utility.trace('after SET_END_DATE');

1326: --
1327: if l_call_set_end_date then
1328: hr_utility.trace('before SET_END_DATE');
1329: set_end_date;
1330: hr_utility.trace('after SET_END_DATE');
1331: else
1332: null;
1333: end if;
1334: else

Line 1392: hr_utility.trace('p_rt_name: '||p_rt_name);

1388: --
1389: -- Does the same row already exist on the db?
1390: --
1391: if l_mode = 'USER' then
1392: hr_utility.trace('p_rt_name: '||p_rt_name);
1393: open u_row_exists;
1394: fetch u_row_exists into l_rt_id, l_rt_nm, l_shrtnm, l_srs_flag
1395: ,l_run_information_category, l_run_information1,
1396: l_run_information2

Line 1418: hr_utility.trace('l_rt_id: '||to_char(l_rt_id));

1414: l_run_information29
1415: ,l_run_information30, l_lc, l_bg, l_esd, l_eed,
1416: l_ovn;
1417: IF u_row_exists%NOTFOUND then
1418: hr_utility.trace('l_rt_id: '||to_char(l_rt_id));
1419: close u_row_exists;
1420: insert_row;
1421: ELSE -- this row does already exist
1422: --

Line 1493: hr_utility.trace('before zap l_rt_id: '||to_char(l_rt_id));

1489: or nvl(l_run_information30,'NULL_VALUE')
1490: <> nvl(p_run_information30,'NULL_VALUE')
1491: or l_esd <> p_effective_start_date then
1492: --
1493: hr_utility.trace('before zap l_rt_id: '||to_char(l_rt_id));
1494: zap_insert(l_rt_id);
1495: --
1496: else
1497: --

Line 2158: hr_utility.trace('l_rtu_id: '||to_char(l_rtu_id));

2154: --
2155: -- in order to update an existing row, need to purge the existing row
2156: -- then insert a new row.
2157: --
2158: hr_utility.trace('l_rtu_id: '||to_char(l_rtu_id));
2159: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));
2160: --
2161: -- use delete rather than api delete to bypass validation
2162: --

Line 2159: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));

2155: -- in order to update an existing row, need to purge the existing row
2156: -- then insert a new row.
2157: --
2158: hr_utility.trace('l_rtu_id: '||to_char(l_rtu_id));
2159: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));
2160: --
2161: -- use delete rather than api delete to bypass validation
2162: --
2163: delete from pay_run_type_usages_f

Line 2185: hr_utility.trace('AFTER ZAP CREATE');

2181: ,p_effective_end_date => l_out_eed
2182: ,p_object_version_number => l_out_ovn
2183: );
2184: --
2185: hr_utility.trace('AFTER ZAP CREATE');
2186: --
2187: -- set the uploaded cache
2188: --
2189: select run_type_usage_id

Line 2319: hr_utility.trace('l_par_rt_id: '||to_char(l_par_rt_id));

2315: --
2316: OPEN get_parent_id(l_bg);
2317: FETCH get_parent_id into l_par_rt_id;
2318: CLOSE get_parent_id;
2319: hr_utility.trace('l_par_rt_id: '||to_char(l_par_rt_id));
2320: --
2321: OPEN get_bg_id(p_child_bg);
2322: FETCH get_bg_id into l_ch_bg;
2323: CLOSE get_bg_id;

Line 2324: hr_utility.trace('l_ch_bg: '||to_char(l_ch_bg));

2320: --
2321: OPEN get_bg_id(p_child_bg);
2322: FETCH get_bg_id into l_ch_bg;
2323: CLOSE get_bg_id;
2324: hr_utility.trace('l_ch_bg: '||to_char(l_ch_bg));
2325: --
2326: OPEN get_child_rt_id(l_ch_bg);
2327: FETCH get_child_rt_id into l_ch_rt_id;
2328: CLOSE get_child_rt_id;

Line 2329: hr_utility.trace('l_ch_rt_id: '||to_char(l_ch_rt_id));

2325: --
2326: OPEN get_child_rt_id(l_ch_bg);
2327: FETCH get_child_rt_id into l_ch_rt_id;
2328: CLOSE get_child_rt_id;
2329: hr_utility.trace('l_ch_rt_id: '||to_char(l_ch_rt_id));
2330: --
2331: -- Is the new row the end of file row (rtu_eof_number = 2) ?
2332: -- Is the new row part of the same dt record as the last uploaded row?
2333: --

Line 2344: hr_utility.trace('before SET_END_DATE');

2340: --
2341: if g_rtu_to_be_uploaded_eed <> hr_api.g_eot then
2342: --
2343: if l_call_rtu_set_end_date then
2344: hr_utility.trace('before SET_END_DATE');
2345: set_end_date;
2346: hr_utility.trace('after SET_END_DATE');
2347: else
2348: null;

Line 2346: hr_utility.trace('after SET_END_DATE');

2342: --
2343: if l_call_rtu_set_end_date then
2344: hr_utility.trace('before SET_END_DATE');
2345: set_end_date;
2346: hr_utility.trace('after SET_END_DATE');
2347: else
2348: null;
2349: end if;
2350: else

Line 2428: hr_utility.trace('this row does not exist');

2424: open s_row_exists(l_par_rt_id, l_ch_rt_id);
2425: fetch s_row_exists into l_rtu_id, l_par_rt_id, l_ch_rt_id, l_seq
2426: , l_lc, l_bg, l_esd, l_eed, l_ovn;
2427: IF s_row_exists%NOTFOUND then
2428: hr_utility.trace('this row does not exist');
2429: close s_row_exists;
2430: insert_row;
2431: ELSE -- this row does already exist
2432: hr_utility.trace('this row does exist');

Line 2432: hr_utility.trace('this row does exist');

2428: hr_utility.trace('this row does not exist');
2429: close s_row_exists;
2430: insert_row;
2431: ELSE -- this row does already exist
2432: hr_utility.trace('this row does exist');
2433: --
2434: -- see if any changes have been made
2435: --
2436: if l_seq <> p_sequence

Line 2457: hr_utility.trace('this row does exist - before zap');

2453: null;
2454: end if;
2455: --
2456: end if;
2457: hr_utility.trace('this row does exist - before zap');
2458: zap_insert(l_rtu_id);
2459: else
2460: --
2461: -- check if just end date has changed

Line 2464: hr_utility.trace('this row does exist - eed changed');

2460: --
2461: -- check if just end date has changed
2462: --
2463: if l_eed <> p_effective_end_date then
2464: hr_utility.trace('this row does exist - eed changed');
2465: --
2466: --
2467: -- don't actually have to update the row, as it is the same
2468: -- as an existing row except for the end date, which will be set

Line 2486: hr_utility.trace('row exists - no changes');

2482: --
2483: -- Row already exists and no columns have changed, so set_end_date
2484: -- does not need to be called. Set a flag to indicate this.
2485: --
2486: hr_utility.trace('row exists - no changes');
2487: l_call_rtu_set_end_date := false;
2488: end if;
2489: end if;
2490: --

Line 2610: hr_utility.trace('rt id is: '||to_char(l_rt_id));

2606: --
2607: open get_run_type_id(l_bg_id);
2608: fetch get_run_type_id into l_rt_id;
2609: close get_run_type_id;
2610: hr_utility.trace('rt id is: '||to_char(l_rt_id));
2611: --
2612: pay_rtt_upd.upd_tl(p_language_code => userenv('LANG')
2613: ,p_run_type_id => l_rt_id
2614: ,p_run_type_name => p_rt_name_tl

Line 2758: hr_utility.set_location('pay_iterate.up_run_type_org_method',10);

2754: Begin --


2755: --
2756: if p_eof_number = 1 then -- if this is not the last row to be uploaded
2757: --
2758: hr_utility.set_location('pay_iterate.up_run_type_org_method',10);
2759: --
2760: -- get the business group id
2761: --
2762: select business_group_id

Line 2769: hr_utility.set_location('pay_iterate.up_run_type_org_method',20);

2765: , l_lc
2766: from per_business_groups
2767: where UPPER(name) = p_business_group;
2768: --
2769: hr_utility.set_location('pay_iterate.up_run_type_org_method',20);
2770: --
2771: -- Get the run type id
2772: --
2773: select prt.run_type_id

Line 2788: hr_utility.set_location('pay_iterate.up_run_type_org_method',30);

2784: and p_rt_lc is null
2785: and prt.business_group_id is null
2786: and prt.legislation_code is null));
2787: --
2788: hr_utility.set_location('pay_iterate.up_run_type_org_method',30);
2789: --
2790: -- get the org payment method id
2791: --
2792: select popm.org_payment_method_id

Line 2800: hr_utility.set_location('pay_iterate.up_run_type_org_method',40);

2796: and p_effective_start_date between popm.effective_start_date
2797: and popm.effective_end_date
2798: and popm.business_group_id = l_bg_id;
2799: --
2800: hr_utility.set_location('pay_iterate.up_run_type_org_method',40);
2801: --
2802: open c_row_exists;
2803: fetch c_row_exists into l_rom_id, l_ovn, l_esd, l_eed;
2804: --

Line 2834: hr_utility.set_location('pay_iterate.up_run_type_org_method',70);

2830: g_rom_rec.new_esd := l_out_esd;
2831: g_rom_rec.old_eed := p_effective_end_date;
2832: g_rom_rec.new_eed := l_out_eed;
2833: --
2834: hr_utility.set_location('pay_iterate.up_run_type_org_method',70);
2835: --
2836: else
2837: if g_rom_rec.old_eed <> hr_api.g_eot then
2838: end_date_rom;

Line 2845: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');

2841: --
2842: EXCEPTION
2843: --
2844: WHEN l_error THEN
2845: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');
2846: hr_utility.raise_error;
2847: --
2848: end up_run_type_org_method;
2849: --

Line 2846: hr_utility.raise_error;

2842: EXCEPTION
2843: --
2844: WHEN l_error THEN
2845: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');
2846: hr_utility.raise_error;
2847: --
2848: end up_run_type_org_method;
2849: --
2850: /* Name : up_element_type_usage

Line 3053: hr_utility.set_message(801, 'HR_33699_USER_ROW_EXISTS');

3049: begin
3050: --
3051: if l_mode = 'STARTUP' then
3052: --
3053: hr_utility.set_message(801, 'HR_33699_USER_ROW_EXISTS');
3054: hr_utility.raise_error;
3055: --
3056: else
3057: --

Line 3054: hr_utility.raise_error;

3050: --
3051: if l_mode = 'STARTUP' then
3052: --
3053: hr_utility.set_message(801, 'HR_33699_USER_ROW_EXISTS');
3054: hr_utility.raise_error;
3055: --
3056: else
3057: --
3058: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');

Line 3058: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');

3054: hr_utility.raise_error;
3055: --
3056: else
3057: --
3058: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');
3059: hr_utility.raise_error;
3060: --
3061: end if;
3062: --

Line 3059: hr_utility.raise_error;

3055: --
3056: else
3057: --
3058: hr_utility.set_message(801, 'HR_33700_LEG_USER_ROW_EXISTS');
3059: hr_utility.raise_error;
3060: --
3061: end if;
3062: --
3063: end exists_error;

Line 3263: hr_utility.set_location('Entering: pay_iterate.order_cumulative',5);

3259: l_rt_method pay_run_types_f.run_method%type;
3260: l_meth_order varchar2(2);
3261: --
3262: begin
3263: hr_utility.set_location('Entering: pay_iterate.order_cumulative',5);
3264: if p_business_grp_name is not null then
3265: open get_bg_id(p_business_grp_name);
3266: fetch get_bg_id into l_bg;
3267: close get_bg_id;

Line 3275: hr_utility.set_location('pay_iterate.order_cumulative',10);

3271: --
3272: open csr_child_cumulative(p_legislation_code, l_bg, p_run_type_name);
3273: fetch csr_child_cumulative into l_rt_name, l_rt_method;
3274: if csr_child_cumulative%notfound then
3275: hr_utility.set_location('pay_iterate.order_cumulative',10);
3276: close csr_child_cumulative;
3277: l_meth_order := 'C';
3278: else
3279: hr_utility.set_location('pay_iterate.order_cumulative',15);

Line 3279: hr_utility.set_location('pay_iterate.order_cumulative',15);

3275: hr_utility.set_location('pay_iterate.order_cumulative',10);
3276: close csr_child_cumulative;
3277: l_meth_order := 'C';
3278: else
3279: hr_utility.set_location('pay_iterate.order_cumulative',15);
3280: close csr_child_cumulative;
3281: l_meth_order := 'D';
3282: end if;
3283: --