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.

[Home] [Help]

APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on HR_UTILITY

Line 14: hr_utility.trace('V_COUNT:'||V_COUNT);

10: V_COUNT NUMBER;
11: BEGIN
12:
13: V_COUNT:=0;
14: hr_utility.trace('V_COUNT:'||V_COUNT);
15:
16:
17: SELECT NVL(MAX(payroll_group_id),0)+1
18: INTO V_COUNT FROM PAY_GB_PAYROLL_GROUPS;

Line 69: hr_utility.trace('V_STATUS:'||V_STATUS);

65: SELECT PPA.PAYROLL_ACTION_ID INTO
66: V_PAY_ACTION_ID FROM PAY_PAYROLL_ACTIONS PPA
67: WHERE PPA.REQUEST_ID=P_REQUEST_ID;
68:
69: hr_utility.trace('V_STATUS:'||V_STATUS);
70: EXCEPTION WHEN NO_DATA_FOUND THEN
71: V_STATUS:=0;
72: END;
73: hr_utility.trace('V_STATUS after excpetion'||V_STATUS);

Line 73: hr_utility.trace('V_STATUS after excpetion'||V_STATUS);

69: hr_utility.trace('V_STATUS:'||V_STATUS);
70: EXCEPTION WHEN NO_DATA_FOUND THEN
71: V_STATUS:=0;
72: END;
73: hr_utility.trace('V_STATUS after excpetion'||V_STATUS);
74: RETURN V_STATUS;
75: END CHK_ALREADY_ROLLED_BACK;
76:
77:

Line 117: hr_utility.trace('V_STATUS:'||V_STATUS);

113: V_PAYROLL_ID NUMBER;
114: BEGIN
115:
116: V_STATUS:=0;
117: hr_utility.trace('V_STATUS:'||V_STATUS);
118: SELECT PGPGM.PAYROLL_ID INTO
119: V_PAYROLL_ID
120: FROM PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM
121: WHERE PGPGM.PAYROLL_ID=P_PAYROLL_ID

Line 125: hr_utility.trace('V_STATUS:'||V_STATUS);

121: WHERE PGPGM.PAYROLL_ID=P_PAYROLL_ID
122: AND PGPGM.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID;
123:
124: V_STATUS:=1;
125: hr_utility.trace('V_STATUS:'||V_STATUS);
126: EXCEPTION WHEN NO_DATA_FOUND THEN
127: V_STATUS:=2;
128: RETURN V_STATUS;
129: END VAL_PAYROLLS_IN_GROUP;

Line 146: hr_utility.trace('V_STATUS:'||V_STATUS);

142: V_CONC_ID NUMBER;
143: BEGIN
144:
145: V_STATUS:=1;
146: hr_utility.trace('V_STATUS:'||V_STATUS);
147: SELECT CONCURRENT_REQUEST_ID
148: INTO V_CONC_ID
149: FROM PAY_GB_MP_MASTER_REQUEST_DET PGPMMRD
150: WHERE PGPMMRD.CONCURRENT_REQUEST_ID=P_CONCURRENT_REQUEST_ID

Line 209: hr_utility.trace('Payroll Group Id:'||M_PAYROLL_GROUP_ID);

205:
206:
207: M_PAYROLL_GROUP_ID:=PAY_GB_MULTI_DML_AND_VAL.GET_GROUP_MAX_ID;
208:
209: hr_utility.trace('Payroll Group Id:'||M_PAYROLL_GROUP_ID);
210:
211: IF VAL_PAYROLL_GROUPS(P_PAYROLL_GROUP_NAME,P_BUSINESS_GROUP_ID) =1 THEN
212:
213: hr_utility.trace(' VAL_PAYROLL_GROUPS returned 1');

Line 213: hr_utility.trace(' VAL_PAYROLL_GROUPS returned 1');

209: hr_utility.trace('Payroll Group Id:'||M_PAYROLL_GROUP_ID);
210:
211: IF VAL_PAYROLL_GROUPS(P_PAYROLL_GROUP_NAME,P_BUSINESS_GROUP_ID) =1 THEN
212:
213: hr_utility.trace(' VAL_PAYROLL_GROUPS returned 1');
214: INSERT INTO PAY_GB_PAYROLL_GROUPS
215: (
216: PAYROLL_GROUP_ID
217: ,PAYROLL_GROUP_NAME

Line 242: hr_utility.trace('Group Already Exists');

238:
239: ELSE
240: P_PAYROLL_GROUP_ID := 0;
241: P_RETURN_STATUS := '0'; -- Means Name already exist
242: hr_utility.trace('Group Already Exists');
243: END IF;
244:
245:
246:

Line 247: hr_utility.trace('Insert Over');

243: END IF;
244:
245:
246:
247: hr_utility.trace('Insert Over');
248:
249:
250: END CREATE_PAYROLL_GROUP;
251:

Line 267: hr_utility.trace(P_PAYROLL_ID);

263: V_PAYROLL_GROUP_NAME VARCHAR2(100);
264: BEGIN
265:
266:
267: hr_utility.trace(P_PAYROLL_ID);
268: hr_utility.trace(P_PAYROLL_GROUP_ID);
269: hr_utility.trace(P_BUSINESS_GROUP_ID);
270:
271: SELECT PAPF.PAYROLL_NAME INTO V_PAYROLL_NAME

Line 268: hr_utility.trace(P_PAYROLL_GROUP_ID);

264: BEGIN
265:
266:
267: hr_utility.trace(P_PAYROLL_ID);
268: hr_utility.trace(P_PAYROLL_GROUP_ID);
269: hr_utility.trace(P_BUSINESS_GROUP_ID);
270:
271: SELECT PAPF.PAYROLL_NAME INTO V_PAYROLL_NAME
272: FROM PAY_ALL_PAYROLLS_F PAPF

Line 269: hr_utility.trace(P_BUSINESS_GROUP_ID);

265:
266:
267: hr_utility.trace(P_PAYROLL_ID);
268: hr_utility.trace(P_PAYROLL_GROUP_ID);
269: hr_utility.trace(P_BUSINESS_GROUP_ID);
270:
271: SELECT PAPF.PAYROLL_NAME INTO V_PAYROLL_NAME
272: FROM PAY_ALL_PAYROLLS_F PAPF
273: WHERE PAPF.PAYROLL_ID=P_PAYROLL_ID

Line 282: hr_utility.trace('Payroll name is:'||V_PAYROLL_NAME);

278: FROM PAY_GB_PAYROLL_GROUPS PGPG
279: WHERE PGPG.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID
280: AND PGPG.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
281:
282: hr_utility.trace('Payroll name is:'||V_PAYROLL_NAME);
283: IF VAL_PAYROLLS_IN_GROUP(P_PAYROLL_GROUP_ID,
284: P_PAYROLL_ID, V_PAYROLL_GROUP_NAME)=2 THEN
285: hr_utility.trace('VAL_PAYROLLS_IN_GROUP returns 1');
286: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);

Line 285: hr_utility.trace('VAL_PAYROLLS_IN_GROUP returns 1');

281:
282: hr_utility.trace('Payroll name is:'||V_PAYROLL_NAME);
283: IF VAL_PAYROLLS_IN_GROUP(P_PAYROLL_GROUP_ID,
284: P_PAYROLL_ID, V_PAYROLL_GROUP_NAME)=2 THEN
285: hr_utility.trace('VAL_PAYROLLS_IN_GROUP returns 1');
286: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
287: IF VALIDATE_FREQUENCY(P_PAYROLL_ID,P_PAYROLL_GROUP_ID)=1 THEN
288: INSERT INTO PAY_GB_PAYROLL_GROUP_MAPPINGS
289: (

Line 286: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);

282: hr_utility.trace('Payroll name is:'||V_PAYROLL_NAME);
283: IF VAL_PAYROLLS_IN_GROUP(P_PAYROLL_GROUP_ID,
284: P_PAYROLL_ID, V_PAYROLL_GROUP_NAME)=2 THEN
285: hr_utility.trace('VAL_PAYROLLS_IN_GROUP returns 1');
286: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
287: IF VALIDATE_FREQUENCY(P_PAYROLL_ID,P_PAYROLL_GROUP_ID)=1 THEN
288: INSERT INTO PAY_GB_PAYROLL_GROUP_MAPPINGS
289: (
290: PAYROLL_ID

Line 309: hr_utility.trace('Insert over');

305: );
306: END IF;
307: COMMIT;
308:
309: hr_utility.trace('Insert over');
310: ELSE
311: hr_utility.set_message(801,'The payrol trying to add is not of same frequency off this group');
312: hr_utility.raise_error;
313: END IF;

Line 311: hr_utility.set_message(801,'The payrol trying to add is not of same frequency off this group');

307: COMMIT;
308:
309: hr_utility.trace('Insert over');
310: ELSE
311: hr_utility.set_message(801,'The payrol trying to add is not of same frequency off this group');
312: hr_utility.raise_error;
313: END IF;
314:
315: END ADD_PAYROLLS;

Line 312: hr_utility.raise_error;

308:
309: hr_utility.trace('Insert over');
310: ELSE
311: hr_utility.set_message(801,'The payrol trying to add is not of same frequency off this group');
312: hr_utility.raise_error;
313: END IF;
314:
315: END ADD_PAYROLLS;
316:

Line 410: hr_utility.trace('object version is for master is:'||CURR_OBJ_VERS);

406:
407: SELECT OBJECT_VERSION_NUMBER INTO CURR_OBJ_VERS
408: FROM PAY_GB_MP_MASTER_REQUEST_DET
409: WHERE CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
410: hr_utility.trace('object version is for master is:'||CURR_OBJ_VERS);
411:
412: UPDATE PAY_GB_MP_MASTER_REQUEST_DET
413: SET
414: ROLLBACK_REQUEST_ID=P_ROLLBACK_REQUEST_ID

Line 440: hr_utility.trace('object version is for CHILD is:'||CURR_OBJ_VERS);

436: SELECT OBJECT_VERSION_NUMBER INTO CURR_OBJ_VERS
437: FROM PAY_GB_MP_CHILD_REQUEST_DET
438: WHERE CHILD_CONCURRENT_REQUEST_ID=P_CHILD_REQUEST_ID
439: AND PARENT_CONCURRENT_REQUEST_ID=P_MASTER_REQUEST_ID;
440: hr_utility.trace('object version is for CHILD is:'||CURR_OBJ_VERS);
441:
442: UPDATE PAY_GB_MP_CHILD_REQUEST_DET
443: SET
444: ROLLBACK_REQUEST_ID=P_ROLLBACK_REQUEST_ID