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_WW_ADJUSTMENTS dependencies on HR_UTILITY

Line 30: hr_utility.set_location('Entering Get_Basis_calc_Rule ',2300);

26:
27: l_basis_calc_rule csr_basis_calc_rule%ROWTYPE;
28:
29: BEGIN
30: hr_utility.set_location('Entering Get_Basis_calc_Rule ',2300);
31:
32: OPEN csr_basis_calc_rule(p_source_text,p_source_text2,p_date_earned);
33: FETCH csr_basis_calc_rule into l_basis_calc_rule;
34: CLOSE csr_basis_calc_rule;

Line 68: hr_utility.set_location('Entering Get_Basis_calc_Rule ',2370);

64: l_gross_net csr_gross_net%ROWTYPE;
65:
66: BEGIN
67:
68: hr_utility.set_location('Entering Get_Basis_calc_Rule ',2370);
69:
70: OPEN csr_gross_net(p_source_text,p_source_text2,p_date_earned);
71: FETCH csr_gross_net into l_gross_net;
72: CLOSE csr_gross_net;

Line 115: --hr_utility.trace_on(NULL,'ADJUSTMENT');

111: BEGIN
112:
113: /*Version 115.1 change start*/
114:
115: --hr_utility.trace_on(NULL,'ADJUSTMENT');
116:
117: IF last_asg_action_id IS NULL THEN
118: last_asg_action_id := -1;
119: END IF;

Line 126: hr_utility.set_location('Inside Get_Adjustment_details : NEntering',1800);

122: last_asg_action_id := p_assignment_action_id;
123: END IF;
124: /* Version 115.1 change end */
125:
126: hr_utility.set_location('Inside Get_Adjustment_details : NEntering',1800);
127:
128: -- Populate PL/SQL table
129: populate_pl_sql_table(p_assignment_action_id, p_date_earned, p_source_text, p_source_text2) ;
130:

Line 132: hr_utility.set_location('Inside Get_Adjustment_details : after populate_pl_sql_table',1805);

128: -- Populate PL/SQL table
129: populate_pl_sql_table(p_assignment_action_id, p_date_earned, p_source_text, p_source_text2) ;
130:
131:
132: hr_utility.set_location('Inside Get_Adjustment_details : after populate_pl_sql_table',1805);
133:
134: BEGIN
135: hr_utility.set_location('Inside Get_Adjustment_details : p_source_text = '||p_source_text||' p_source_text2'||p_source_text2,1806);
136:

Line 135: hr_utility.set_location('Inside Get_Adjustment_details : p_source_text = '||p_source_text||' p_source_text2'||p_source_text2,1806);

131:
132: hr_utility.set_location('Inside Get_Adjustment_details : after populate_pl_sql_table',1805);
133:
134: BEGIN
135: hr_utility.set_location('Inside Get_Adjustment_details : p_source_text = '||p_source_text||' p_source_text2'||p_source_text2,1806);
136:
137: OPEN csr_get_cont_perc(c_si_type => p_source_text,c_si_provider => p_source_text2,c_date_earned=> p_date_earned);
138: FETCH csr_get_cont_perc INTO l_cont_perc;
139:

Line 141: hr_utility.set_location('Inside Get_Adjustment_details : Data found for cursor csr_get_cont_perc',1806);

137: OPEN csr_get_cont_perc(c_si_type => p_source_text,c_si_provider => p_source_text2,c_date_earned=> p_date_earned);
138: FETCH csr_get_cont_perc INTO l_cont_perc;
139:
140: IF csr_get_cont_perc%FOUND THEN
141: hr_utility.set_location('Inside Get_Adjustment_details : Data found for cursor csr_get_cont_perc',1806);
142:
143: IF p_age > pay_nl_general.get_global_value(p_date_earned, 'NL_SI_SENIOR_PERCENTAGE_AGE') THEN
144: p_ee_cont_perc := l_cont_perc.sr_ee_perc;
145: p_er_cont_perc := l_cont_perc.sr_er_perc;

Line 157: hr_utility.set_location('Inside Get_Adjustment_details : No data for cursor csr_get_cont_perc',1810);

153: ELSE
154: p_ee_cont_perc := 0;
155: p_er_cont_perc := 0;
156: p_si_type_name := ' ';
157: hr_utility.set_location('Inside Get_Adjustment_details : No data for cursor csr_get_cont_perc',1810);
158:
159: END IF;
160:
161: CLOSE csr_get_cont_perc;

Line 165: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag,1810);

161: CLOSE csr_get_cont_perc;
162:
163: -- Check out the next SIP for the current SI
164: FOR i in t1.FIRST..t1.LAST LOOP
165: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag,1810);
166: IF t1(i).processed_flag = 'N' AND t1(i).si_provider_id <> p_source_text2 AND t1(i).si_type = p_source_text AND t1(i).asg_act_id = p_assignment_action_id THEN
167: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SELECTED SIP'||t1(i).si_provider_id||'SIT '||p_source_text,1816);
168: t1(i).processed_flag := 'Y';
169: RETURN t1(i).si_provider_id;

Line 167: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SELECTED SIP'||t1(i).si_provider_id||'SIT '||p_source_text,1816);

163: -- Check out the next SIP for the current SI
164: FOR i in t1.FIRST..t1.LAST LOOP
165: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag,1810);
166: IF t1(i).processed_flag = 'N' AND t1(i).si_provider_id <> p_source_text2 AND t1(i).si_type = p_source_text AND t1(i).asg_act_id = p_assignment_action_id THEN
167: hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SELECTED SIP'||t1(i).si_provider_id||'SIT '||p_source_text,1816);
168: t1(i).processed_flag := 'Y';
169: RETURN t1(i).si_provider_id;
170: END IF;
171: END LOOP;

Line 176: hr_utility.set_location('Deleted row'||' : SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag, 1878);

172:
173: -- Delete entries for the SI type after all SIPs are processed
174: FOR i in t1.FIRST..t1.LAST LOOP
175: IF t1(i).processed_flag = 'Y' AND t1(i).si_type = p_source_text AND t1(i).asg_act_id = p_assignment_action_id THEN
176: hr_utility.set_location('Deleted row'||' : SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag, 1878);
177: t1.delete(i);
178: END IF;
179: END LOOP;
180:

Line 186: hr_utility.set_location('Exception :' ||SQLERRM(SQLCODE),1899);

182: RETURN '-1';
183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: hr_utility.set_location('Exception :' ||SQLERRM(SQLCODE),1899);
187: RAISE;
188: END;
189: END ;
190:

Line 223: hr_utility.set_location('Inside pop_pl/sql si_type'||p_si_type||' sip'||p_si_provider,2350);

219: k NUMBER;
220:
221: BEGIN
222:
223: hr_utility.set_location('Inside pop_pl/sql si_type'||p_si_type||' sip'||p_si_provider,2350);
224:
225: --Check whether present si_type, assignment_action_id combination has entry in PL/SQL table
226: IF t1.LAST IS NOT NULL THEN
227:

Line 251: hr_utility.set_location('Inside v_csr_get1: t1(i).sip'||t1(i).si_provider_id||' SIT'||t1(i).si_type||' FLAG '||t1(i).processed_flag ,2355);

247: t1(i).processed_flag := 'Y';
248: ELSE
249: t1(i).processed_flag := 'N';
250: END IF;
251: hr_utility.set_location('Inside v_csr_get1: t1(i).sip'||t1(i).si_provider_id||' SIT'||t1(i).si_type||' FLAG '||t1(i).processed_flag ,2355);
252: i := i+1;
253:
254: END LOOP;
255: END IF;

Line 257: hr_utility.set_location('End pop/pl/sql: SITP=' ||p_si_type||p_si_provider||'ACT_ID'||p_assignment_action_id||'T1.LAST='||NVL(T1.LAST,0),2379);

253:
254: END LOOP;
255: END IF;
256:
257: hr_utility.set_location('End pop/pl/sql: SITP=' ||p_si_type||p_si_provider||'ACT_ID'||p_assignment_action_id||'T1.LAST='||NVL(T1.LAST,0),2379);
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: hr_utility.set_location('Exception inside v_csr_get1:' ||SQLERRM(SQLCODE),2399);

Line 261: hr_utility.set_location('Exception inside v_csr_get1:' ||SQLERRM(SQLCODE),2399);

257: hr_utility.set_location('End pop/pl/sql: SITP=' ||p_si_type||p_si_provider||'ACT_ID'||p_assignment_action_id||'T1.LAST='||NVL(T1.LAST,0),2379);
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: hr_utility.set_location('Exception inside v_csr_get1:' ||SQLERRM(SQLCODE),2399);
262: RAISE;
263: END;
264: hr_utility.set_location('no Exception populate_pl_sql_table ',2398);
265: END;

Line 264: hr_utility.set_location('no Exception populate_pl_sql_table ',2398);

260: WHEN OTHERS THEN
261: hr_utility.set_location('Exception inside v_csr_get1:' ||SQLERRM(SQLCODE),2399);
262: RAISE;
263: END;
264: hr_utility.set_location('no Exception populate_pl_sql_table ',2398);
265: END;
266:
267: FUNCTION get_si_prov_count
268: (p_assignment_id IN NUMBER,