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.PAY_NL_GENERAL dependencies on HR_UTILITY

Line 71: hr_utility.set_location('Entered '||l_proc,5);

67: l_proc varchar2(72) := g_package||'.get_message';
68: --
69: begin
70: --
71: hr_utility.set_location('Entered '||l_proc,5);
72: hr_utility.set_location('. Message Name: '||p_message_name,40);
73:
74: fnd_message.set_name(p_product, p_message_name);
75:

Line 72: hr_utility.set_location('. Message Name: '||p_message_name,40);

68: --
69: begin
70: --
71: hr_utility.set_location('Entered '||l_proc,5);
72: hr_utility.set_location('. Message Name: '||p_message_name,40);
73:
74: fnd_message.set_name(p_product, p_message_name);
75:
76: if p_token1 is not null then

Line 82: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);

78: l_colon_position := instr(p_token1,':');
79: l_token_name := substr(p_token1,1,l_colon_position-1);
80: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
81: fnd_message.set_token(l_token_name, l_token_value);
82: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
83: end if;
84:
85: if p_token2 is not null then
86: /* Obtain token 2 name and value */

Line 91: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);

87: l_colon_position := instr(p_token2,':');
88: l_token_name := substr(p_token2,1,l_colon_position-1);
89: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
90: fnd_message.set_token(l_token_name, l_token_value);
91: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
92: end if;
93:
94: if p_token3 is not null then
95: /* Obtain token 3 name and value */

Line 100: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);

96: l_colon_position := instr(p_token3,':');
97: l_token_name := substr(p_token3,1,l_colon_position-1);
98: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
99: fnd_message.set_token(l_token_name, l_token_value);
100: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
101: end if;
102:
103: l_message := substrb(fnd_message.get,1,254);
104:

Line 105: hr_utility.set_location('leaving '||l_proc,100);

101: end if;
102:
103: l_message := substrb(fnd_message.get,1,254);
104:
105: hr_utility.set_location('leaving '||l_proc,100);
106:
107: return l_message;
108: end get_message;
109: --

Line 148: hr_utility.set_location('get_period_asg_dates',1);

144: v_csr_asg_act_dates csr_asg_act_dates%ROWTYPE;
145:
146: begin
147:
148: hr_utility.set_location('get_period_asg_dates',1);
149:
150: open csr_asg_dates;
151: fetch csr_asg_dates into p_asg_start_date,p_asg_end_date;
152: close csr_asg_dates;

Line 170: hr_utility.set_location('get_period_asg_dates',99);

166: CLOSE csr_asg_act_dates;
167:
168: end if;
169:
170: hr_utility.set_location('get_period_asg_dates',99);
171:
172: return 1;
173:
174: exception

Line 177: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

173:
174: exception
175:
176: when others then
177: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
178: raise;
179:
180: end get_period_asg_dates;
181:

Line 221: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

217:
218: exception
219:
220: when others then
221: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
222: raise;
223:
224: end get_run_result_value;
225:

Line 260: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

256:
257: exception
258:
259: when others then
260: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
261: raise;
262:
263: end get_run_result_value;
264:

Line 371: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);

367:
368:
369: begin
370: l_period_obtained_flag:=1;
371: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);
372:
373: OPEN c_get_creator_type(p_element_entry_id,p_date_earned);
374: FETCH c_get_creator_type INTO l_creator_type ;
375: CLOSE c_get_creator_type;

Line 406: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);

402: CLOSE get_retro_period_ee;
403: l_period_obtained_flag:=1;
404: end if;
405:
406: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
407: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
408: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
409:
410: return l_retro_date;

Line 407: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);

403: l_period_obtained_flag:=1;
404: end if;
405:
406: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
407: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
408: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
409:
410: return l_retro_date;
411:

Line 408: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);

404: end if;
405:
406: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
407: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
408: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
409:
410: return l_retro_date;
411:
412:

Line 713: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

709: CLOSE get_global_value;
710: Return l_value;
711: EXCEPTION
712: when others then
713: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
714: raise;
715: END get_global_value;
716:
717:

Line 756: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

752: CLOSE get_global_value;
753: Return l_value;
754: EXCEPTION
755: when others then
756: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
757: raise;
758: END get_global_value;
759:
760: --

Line 861: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);

857: --
858: l_created_by := c1rec.c_created_by;
859: l_last_login := c1rec.c_last_login;
860: --
861: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);
862: hrdyndbi.insert_user_entity (p_route_name,
863: p_entity_name,
864: 'route for SCL level : '|| p_attribute_type,
865: 'Y',

Line 919: hr_utility.set_location ('hrdyndbi.create_scl_flex_dict', 1);

915: BEGIN
916: --
917: -- get each legislation code
918: --
919: hr_utility.set_location ('hrdyndbi.create_scl_flex_dict', 1);
920: --
921: for c0rec in c0 loop
922: --
923: l_legislation_code := c0rec.legislation_code;

Line 1055: hr_utility.set_location('--In Formula ',20);

1051: l_inputs ff_exec.inputs_t;
1052: l_outputs ff_exec.outputs_t;
1053:
1054: BEGIN
1055: hr_utility.set_location('--In Formula ',20);
1056: --
1057: -- Initialize the formula
1058: --
1059: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

Line 1090: hr_utility.set_location('--Leaving Formula ',21);

1086: END IF;
1087: END LOOP;
1088: END LOOP;
1089: END IF;
1090: hr_utility.set_location('--Leaving Formula ',21);
1091: EXCEPTION
1092: WHEN hr_formula_error THEN
1093: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
1094: fnd_message.set_token('1', p_formula_name);

Line 1768: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

1764: Return l_retro_status;
1765:
1766: EXCEPTION
1767: when others then
1768: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
1769: raise;
1770: END get_retro_status;
1771:
1772: -----------------------------------------------------------------------------

Line 1902: --HR_UTILITY.TRACE_ON(NULL,'GR');

1898: l_entry_exist VARCHAR2(1);
1899: --
1900: BEGIN
1901: --
1902: --HR_UTILITY.TRACE_ON(NULL,'GR');
1903: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
1904: IF g_late_hire_indicator = 'N' THEN
1905: HR_UTILITY.TRACE('~~ 1 Result : DP');
1906: RETURN 'DP';

Line 1903: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);

1899: --
1900: BEGIN
1901: --
1902: --HR_UTILITY.TRACE_ON(NULL,'GR');
1903: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
1904: IF g_late_hire_indicator = 'N' THEN
1905: HR_UTILITY.TRACE('~~ 1 Result : DP');
1906: RETURN 'DP';
1907: END IF;

Line 1905: HR_UTILITY.TRACE('~~ 1 Result : DP');

1901: --
1902: --HR_UTILITY.TRACE_ON(NULL,'GR');
1903: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
1904: IF g_late_hire_indicator = 'N' THEN
1905: HR_UTILITY.TRACE('~~ 1 Result : DP');
1906: RETURN 'DP';
1907: END IF;
1908: --
1909: OPEN C1(p_pay_act_id);

Line 1920: HR_UTILITY.TRACE('~~ 2 Result : DP');

1916: CLOSE csr_get_late_starter_flag;
1917: --
1918: g_late_hire_indicator := NVL(l_late_hire_indicator,'Y');
1919: IF g_late_hire_indicator = 'N' THEN
1920: HR_UTILITY.TRACE('~~ 2 Result : DP');
1921: RETURN 'DP';
1922: END IF;
1923: END IF;
1924: --

Line 1948: HR_UTILITY.TRACE('~~ 3 Result : '||g_result);

1944: IF l_entry_exist = 'Y' THEN
1945: g_result := 'DE';
1946: g_payroll_action_id := p_pay_act_id;
1947: g_parent_id := l_parent_id;
1948: HR_UTILITY.TRACE('~~ 3 Result : '||g_result);
1949: RETURN g_result;
1950: END IF;
1951: END IF;
1952: --

Line 1969: HR_UTILITY.TRACE('~~ 4 Result : DE');

1965: g_result := 'DE';
1966: g_payroll_action_id := p_pay_act_id;
1967: g_parent_id := l_parent_id;
1968: CLOSE csr_diff_de_dp;
1969: HR_UTILITY.TRACE('~~ 4 Result : DE');
1970: RETURN 'DE';
1971: END IF;
1972: CLOSE csr_diff_de_dp;
1973: END IF;

Line 1981: HR_UTILITY.TRACE('~~ 5 Result : '||g_result);

1977: --
1978: g_payroll_action_id := p_pay_act_id;
1979: g_parent_id := l_parent_id;
1980: g_result := 'DP';
1981: HR_UTILITY.TRACE('~~ 5 Result : '||g_result);
1982: RETURN l_result;
1983: --
1984: END check_de_dp_dimension;
1985: --

Line 2087: --HR_UTILITY.TRACE_ON(NULL,'GR');

2083: l_entry_exist VARCHAR2(1);
2084: --
2085: BEGIN
2086: --
2087: --HR_UTILITY.TRACE_ON(NULL,'GR');
2088: HR_UTILITY.TRACE('~~~ Assignment_id :'||p_ass_id);
2089: IF g_late_hire_indicator = 'N' THEN
2090: HR_UTILITY.TRACE('~~~ 1 Result : DP');
2091: RETURN 'DP';

Line 2088: HR_UTILITY.TRACE('~~~ Assignment_id :'||p_ass_id);

2084: --
2085: BEGIN
2086: --
2087: --HR_UTILITY.TRACE_ON(NULL,'GR');
2088: HR_UTILITY.TRACE('~~~ Assignment_id :'||p_ass_id);
2089: IF g_late_hire_indicator = 'N' THEN
2090: HR_UTILITY.TRACE('~~~ 1 Result : DP');
2091: RETURN 'DP';
2092: END IF;

Line 2090: HR_UTILITY.TRACE('~~~ 1 Result : DP');

2086: --
2087: --HR_UTILITY.TRACE_ON(NULL,'GR');
2088: HR_UTILITY.TRACE('~~~ Assignment_id :'||p_ass_id);
2089: IF g_late_hire_indicator = 'N' THEN
2090: HR_UTILITY.TRACE('~~~ 1 Result : DP');
2091: RETURN 'DP';
2092: END IF;
2093: --
2094: OPEN C1(p_pay_act_id);

Line 2105: HR_UTILITY.TRACE('~~~ 2 Result : DP');

2101: CLOSE csr_get_late_starter_flag;
2102: --
2103: g_late_hire_indicator := NVL(l_late_hire_indicator,'Y');
2104: IF g_late_hire_indicator = 'N' THEN
2105: HR_UTILITY.TRACE('~~~ 2 Result : DP');
2106: RETURN 'DP';
2107: END IF;
2108: END IF;
2109: --

Line 2133: HR_UTILITY.TRACE('~~~ 3 Result : '||g_result);

2129: IF l_entry_exist = 'Y' THEN
2130: g_result := 'DE';
2131: g_payroll_action_id := p_pay_act_id;
2132: g_parent_id := l_parent_id;
2133: HR_UTILITY.TRACE('~~~ 3 Result : '||g_result);
2134: RETURN g_result;
2135: END IF;
2136: END IF;
2137: --

Line 2153: HR_UTILITY.TRACE('~~~ 4 Result : DE');

2149: g_result := 'DE';
2150: g_payroll_action_id := p_pay_act_id;
2151: g_parent_id := l_parent_id;
2152: CLOSE csr_diff_de_dp;
2153: HR_UTILITY.TRACE('~~~ 4 Result : DE');
2154: RETURN 'DE';
2155: END IF;
2156: CLOSE csr_diff_de_dp;
2157: END IF;

Line 2164: HR_UTILITY.TRACE('~~~ 5 Result : '||g_result);

2160: --
2161: g_payroll_action_id := p_pay_act_id;
2162: g_parent_id := l_parent_id;
2163: g_result := 'DP';
2164: HR_UTILITY.TRACE('~~~ 5 Result : '||g_result);
2165: RETURN g_result;
2166: --
2167: END check_de_dp_dimension_old;
2168:

Line 2315: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);

2311: l_entry_exist VARCHAR2(1);
2312: --
2313: BEGIN
2314: --
2315: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
2316: IF g_late_hire_indicator = 'N' THEN
2317: HR_UTILITY.TRACE('~~ 1 QResult : DP');
2318: RETURN 'DP';
2319: END IF;

Line 2317: HR_UTILITY.TRACE('~~ 1 QResult : DP');

2313: BEGIN
2314: --
2315: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
2316: IF g_late_hire_indicator = 'N' THEN
2317: HR_UTILITY.TRACE('~~ 1 QResult : DP');
2318: RETURN 'DP';
2319: END IF;
2320: --
2321: OPEN C1(p_pay_act_id);

Line 2332: HR_UTILITY.TRACE('~~ 2 QResult : DP');

2328: CLOSE csr_get_late_starter_flag;
2329: --
2330: g_late_hire_indicator := NVL(l_late_hire_indicator,'Y');
2331: IF g_late_hire_indicator = 'N' THEN
2332: HR_UTILITY.TRACE('~~ 2 QResult : DP');
2333: RETURN 'DP';
2334: END IF;
2335: END IF;
2336: --

Line 2350: HR_UTILITY.TRACE('~~ 3 QResult : '||g_qtd_result);

2346: l_qtd_result := NULL;
2347: --
2348: IF g_qtd_result IS NOT NULL AND g_period_type = p_type
2349: AND NVL(g_assignment_id,-1) = p_ass_id AND NVL(g_payroll_action_id,-1) = p_pay_act_id THEN
2350: HR_UTILITY.TRACE('~~ 3 QResult : '||g_qtd_result);
2351: return g_qtd_result;
2352: END IF;
2353: --
2354: OPEN csr_chk_element_entry(p_ass_id,l_date_earned);

Line 2363: HR_UTILITY.TRACE('~~ 4 QResult : '||g_qtd_result);

2359: g_payroll_action_id := p_pay_act_id;
2360: g_assignment_id := p_ass_id;
2361: g_period_type := p_type;
2362: g_qtd_result := 'DE';
2363: HR_UTILITY.TRACE('~~ 4 QResult : '||g_qtd_result);
2364: RETURN g_qtd_result;
2365: END IF;
2366: --
2367: /*

Line 2380: HR_UTILITY.TRACE('~~ 5 QResult : '||g_qtd_result);

2376: FETCH csr_diff_de_dp_qtd INTO l_qtd_result;
2377: IF csr_diff_de_dp_qtd%FOUND THEN
2378: g_qtd_result := l_qtd_result;
2379: CLOSE csr_diff_de_dp_qtd;
2380: HR_UTILITY.TRACE('~~ 5 QResult : '||g_qtd_result);
2381: RETURN g_qtd_result;
2382: END IF;
2383: CLOSE csr_diff_de_dp_qtd;
2384: END IF;

Line 2397: HR_UTILITY.TRACE('~~ 6 QResult : '||g_qtd_result);

2393: FETCH csr_diff_de_dp_lqtd INTO l_qtd_result;
2394: IF csr_diff_de_dp_lqtd%FOUND THEN
2395: g_qtd_result := l_qtd_result;
2396: CLOSE csr_diff_de_dp_lqtd;
2397: HR_UTILITY.TRACE('~~ 6 QResult : '||g_qtd_result);
2398: RETURN g_qtd_result;
2399: END IF;
2400: CLOSE csr_diff_de_dp_lqtd;
2401: END IF;

Line 2409: HR_UTILITY.TRACE('~~ 7 QResult : '||g_qtd_result);

2405: g_assignment_id := p_ass_id;
2406: g_period_type := p_type;
2407: g_qtd_result := NVL(l_qtd_result,'DP');
2408: --
2409: HR_UTILITY.TRACE('~~ 7 QResult : '||g_qtd_result);
2410: RETURN g_qtd_result;
2411: --
2412: END check_de_dp_dimension_qtd;
2413: --

Line 2553: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);

2549: l_entry_exist VARCHAR2(1);
2550: --
2551: BEGIN
2552: --
2553: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
2554: IF g_late_hire_indicator = 'N' THEN
2555: HR_UTILITY.TRACE('~~ 1 QResult : DP');
2556: RETURN 'DP';
2557: END IF;

Line 2555: HR_UTILITY.TRACE('~~ 1 QResult : DP');

2551: BEGIN
2552: --
2553: HR_UTILITY.TRACE('~~ Assignment_id :'||p_ass_id);
2554: IF g_late_hire_indicator = 'N' THEN
2555: HR_UTILITY.TRACE('~~ 1 QResult : DP');
2556: RETURN 'DP';
2557: END IF;
2558: --
2559: OPEN C1(p_pay_act_id);

Line 2570: HR_UTILITY.TRACE('~~ 2 QResult : DP');

2566: CLOSE csr_get_late_starter_flag;
2567: --
2568: g_late_hire_indicator := NVL(l_late_hire_indicator,'Y');
2569: IF g_late_hire_indicator = 'N' THEN
2570: HR_UTILITY.TRACE('~~ 2 QResult : DP');
2571: RETURN 'DP';
2572: END IF;
2573: END IF;
2574: --

Line 2588: HR_UTILITY.TRACE('~~ 3 QResult : '||g_qtd_result);

2584: l_qtd_result := NULL;
2585: --
2586: IF g_qtd_result IS NOT NULL AND g_period_type = p_type
2587: AND NVL(g_assignment_id,-1) = p_ass_id AND NVL(g_payroll_action_id,-1) = p_pay_act_id THEN
2588: HR_UTILITY.TRACE('~~ 3 QResult : '||g_qtd_result);
2589: return g_qtd_result;
2590: END IF;
2591: --
2592: OPEN csr_chk_element_entry(p_ass_id,l_date_earned);

Line 2601: HR_UTILITY.TRACE('~~ 4 QResult : '||g_qtd_result);

2597: g_payroll_action_id := p_pay_act_id;
2598: g_assignment_id := p_ass_id;
2599: g_period_type := p_type;
2600: g_qtd_result := 'DE';
2601: HR_UTILITY.TRACE('~~ 4 QResult : '||g_qtd_result);
2602: RETURN g_qtd_result;
2603: END IF;
2604: --
2605: IF p_type = 'QTD' THEN

Line 2617: HR_UTILITY.TRACE('~~ 5 QResult : '||g_qtd_result);

2613: FETCH csr_diff_de_dp_qtd INTO l_qtd_result;
2614: IF csr_diff_de_dp_qtd%FOUND THEN
2615: g_qtd_result := l_qtd_result;
2616: CLOSE csr_diff_de_dp_qtd;
2617: HR_UTILITY.TRACE('~~ 5 QResult : '||g_qtd_result);
2618: RETURN g_qtd_result;
2619: END IF;
2620: CLOSE csr_diff_de_dp_qtd;
2621: END IF;

Line 2634: HR_UTILITY.TRACE('~~ 6 QResult : '||g_qtd_result);

2630: FETCH csr_diff_de_dp_lqtd INTO l_qtd_result;
2631: IF csr_diff_de_dp_lqtd%FOUND THEN
2632: g_qtd_result := l_qtd_result;
2633: CLOSE csr_diff_de_dp_lqtd;
2634: HR_UTILITY.TRACE('~~ 6 QResult : '||g_qtd_result);
2635: RETURN g_qtd_result;
2636: END IF;
2637: CLOSE csr_diff_de_dp_lqtd;
2638: END IF;

Line 2646: HR_UTILITY.TRACE('~~ 7 QResult : '||g_qtd_result);

2642: g_assignment_id := p_ass_id;
2643: g_period_type := p_type;
2644: g_qtd_result := NVL(l_qtd_result,'DP');
2645: --
2646: HR_UTILITY.TRACE('~~ 7 QResult : '||g_qtd_result);
2647: RETURN g_qtd_result;
2648: --
2649: END check_de_dp_dimension_qtd;*/
2650: --

Line 2822: hr_utility.set_location('Entering NL_ADJUST_TO_CORRECTION',250);

2818:
2819:
2820: BEGIN
2821:
2822: hr_utility.set_location('Entering NL_ADJUST_TO_CORRECTION',250);
2823: --hr_utility.set_location('p_payroll_id '||p_payroll_id,250);
2824: --hr_utility.set_location('p_reprocess_date '||p_reprocess_date,250);
2825: hr_utility.set_location('p_bg_id '||p_bg_id,250 );
2826:

Line 2823: --hr_utility.set_location('p_payroll_id '||p_payroll_id,250);

2819:
2820: BEGIN
2821:
2822: hr_utility.set_location('Entering NL_ADJUST_TO_CORRECTION',250);
2823: --hr_utility.set_location('p_payroll_id '||p_payroll_id,250);
2824: --hr_utility.set_location('p_reprocess_date '||p_reprocess_date,250);
2825: hr_utility.set_location('p_bg_id '||p_bg_id,250 );
2826:
2827: /*

Line 2824: --hr_utility.set_location('p_reprocess_date '||p_reprocess_date,250);

2820: BEGIN
2821:
2822: hr_utility.set_location('Entering NL_ADJUST_TO_CORRECTION',250);
2823: --hr_utility.set_location('p_payroll_id '||p_payroll_id,250);
2824: --hr_utility.set_location('p_reprocess_date '||p_reprocess_date,250);
2825: hr_utility.set_location('p_bg_id '||p_bg_id,250 );
2826:
2827: /*
2828: FOR rec_asg IN c_valid_assignments --(p_reprocess_date, p_payroll_id, p_bg_id)

Line 2825: hr_utility.set_location('p_bg_id '||p_bg_id,250 );

2821:
2822: hr_utility.set_location('Entering NL_ADJUST_TO_CORRECTION',250);
2823: --hr_utility.set_location('p_payroll_id '||p_payroll_id,250);
2824: --hr_utility.set_location('p_reprocess_date '||p_reprocess_date,250);
2825: hr_utility.set_location('p_bg_id '||p_bg_id,250 );
2826:
2827: /*
2828: FOR rec_asg IN c_valid_assignments --(p_reprocess_date, p_payroll_id, p_bg_id)
2829: LOOP

Line 2830: hr_utility.set_location('Retro Assignment ID '||rec_asg.retro_assignment_id,300 );

2826:
2827: /*
2828: FOR rec_asg IN c_valid_assignments --(p_reprocess_date, p_payroll_id, p_bg_id)
2829: LOOP
2830: hr_utility.set_location('Retro Assignment ID '||rec_asg.retro_assignment_id,300 );
2831: hr_utility.set_location('Assignment ID '||rec_asg.assignment_id,300 );
2832: FOR rec_entry IN c_valid_entries(rec_asg.retro_assignment_id )
2833: LOOP
2834: hr_utility.set_location('Assignment ID '||rec_entry.element_entry_id,310 );

Line 2831: hr_utility.set_location('Assignment ID '||rec_asg.assignment_id,300 );

2827: /*
2828: FOR rec_asg IN c_valid_assignments --(p_reprocess_date, p_payroll_id, p_bg_id)
2829: LOOP
2830: hr_utility.set_location('Retro Assignment ID '||rec_asg.retro_assignment_id,300 );
2831: hr_utility.set_location('Assignment ID '||rec_asg.assignment_id,300 );
2832: FOR rec_entry IN c_valid_entries(rec_asg.retro_assignment_id )
2833: LOOP
2834: hr_utility.set_location('Assignment ID '||rec_entry.element_entry_id,310 );
2835: --Update retro entries to corection.

Line 2834: hr_utility.set_location('Assignment ID '||rec_entry.element_entry_id,310 );

2830: hr_utility.set_location('Retro Assignment ID '||rec_asg.retro_assignment_id,300 );
2831: hr_utility.set_location('Assignment ID '||rec_asg.assignment_id,300 );
2832: FOR rec_entry IN c_valid_entries(rec_asg.retro_assignment_id )
2833: LOOP
2834: hr_utility.set_location('Assignment ID '||rec_entry.element_entry_id,310 );
2835: --Update retro entries to corection.
2836: pay_retro_status_internal.maintain_retro_entry
2837: (p_retro_assignment_id => rec_entry.retro_assignment_id
2838: ,p_element_entry_id => rec_entry.element_entry_id

Line 2866: hr_utility.set_location('l_corr_component_id '||l_corr_component_id,260 );

2862: OPEN c_corr_adj_component('Correction');
2863: FETCH c_corr_adj_component INTO l_corr_component_id;
2864: CLOSE c_corr_adj_component;
2865:
2866: hr_utility.set_location('l_corr_component_id '||l_corr_component_id,260 );
2867:
2868: OPEN c_corr_adj_component('Adjustment');
2869: FETCH c_corr_adj_component INTO l_adj_component_id;
2870: CLOSE c_corr_adj_component;

Line 2872: hr_utility.set_location('l_adj_component_id '||l_adj_component_id,270 );

2868: OPEN c_corr_adj_component('Adjustment');
2869: FETCH c_corr_adj_component INTO l_adj_component_id;
2870: CLOSE c_corr_adj_component;
2871:
2872: hr_utility.set_location('l_adj_component_id '||l_adj_component_id,270 );
2873:
2874: OPEN c_adj_processed;
2875: FETCH c_adj_processed INTO l_adj_processed;
2876:

Line 2945: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',320);

2941: SELECT pay_patch_status_s.nextval,9453856,'NL_9453856','C',sysdate,'NL' FROM dual;
2942:
2943: END IF;
2944:
2945: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',320);
2946:
2947: EXCEPTION
2948: WHEN OTHERS then
2949: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

Line 2949: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

2945: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',320);
2946:
2947: EXCEPTION
2948: WHEN OTHERS then
2949: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
2950: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',330);
2951: --raise_application_error(-20001, 'This process does not correlate with the note id 558457.1.') ;
2952: l_message := substrb(fnd_message.get_string('PAY','HR_NL_ADJ_TO_CORR'),1,300); --9453856
2953: fnd_file.put_line(fnd_file.log,l_message);

Line 2950: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',330);

2946:
2947: EXCEPTION
2948: WHEN OTHERS then
2949: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
2950: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',330);
2951: --raise_application_error(-20001, 'This process does not correlate with the note id 558457.1.') ;
2952: l_message := substrb(fnd_message.get_string('PAY','HR_NL_ADJ_TO_CORR'),1,300); --9453856
2953: fnd_file.put_line(fnd_file.log,l_message);
2954: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_message);