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

Line 37: hr_utility.trace('Child request to be stored:'||P_CHILD_REQ(P));

33:
34:
35: FOR P IN P_CHILD_REQ.FIRST..P_CHILD_REQ.LAST
36: LOOP
37: hr_utility.trace('Child request to be stored:'||P_CHILD_REQ(P));
38: PAY_GB_MULTI_DML_AND_VAL.ADD_CHILD_CON_DETAILS(
39: P_CHILD_CON_ID=>P_CHILD_REQ(P),P_PARENT_CON_ID =>P_CONCURRENT_REQUEST_ID);
40: END LOOP;
41:

Line 97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);

93: REQ_COUNT NUMBER;
94:
95: BEGIN
96:
97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);
98: hr_utility.trace('P_RUN_TYPE:'||P_RUN_TYPE);
99: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
100:
101:

Line 98: hr_utility.trace('P_RUN_TYPE:'||P_RUN_TYPE);

94:
95: BEGIN
96:
97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);
98: hr_utility.trace('P_RUN_TYPE:'||P_RUN_TYPE);
99: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
100:
101:
102: REQ_COUNT:=0;

Line 99: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);

95: BEGIN
96:
97: hr_utility.trace('Inside '||PAY_GB_MULTI_PAYROLL_RUN.g_package);
98: hr_utility.trace('P_RUN_TYPE:'||P_RUN_TYPE);
99: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
100:
101:
102: REQ_COUNT:=0;
103: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 107: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);

103: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
104:
105: LOOP
106:
107: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);
108: OPEN CSR_PAYROLL_PARAMETERS(PAY_RUN.PAYROLL_ID,P_TIME_PERIOD_NAME);
109: FETCH CSR_PAYROLL_PARAMETERS INTO V_CONDOLIDATION_SET_ID, V_REGULAR_PAY_DATE,V_END_DATE;
110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);

Line 110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);

106:
107: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);
108: OPEN CSR_PAYROLL_PARAMETERS(PAY_RUN.PAYROLL_ID,P_TIME_PERIOD_NAME);
109: FETCH CSR_PAYROLL_PARAMETERS INTO V_CONDOLIDATION_SET_ID, V_REGULAR_PAY_DATE,V_END_DATE;
110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);
112: hr_utility.trace('EARNED DATE:'||V_END_DATE);
113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);
114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);

Line 111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);

107: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);
108: OPEN CSR_PAYROLL_PARAMETERS(PAY_RUN.PAYROLL_ID,P_TIME_PERIOD_NAME);
109: FETCH CSR_PAYROLL_PARAMETERS INTO V_CONDOLIDATION_SET_ID, V_REGULAR_PAY_DATE,V_END_DATE;
110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);
112: hr_utility.trace('EARNED DATE:'||V_END_DATE);
113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);
114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);
115:

Line 112: hr_utility.trace('EARNED DATE:'||V_END_DATE);

108: OPEN CSR_PAYROLL_PARAMETERS(PAY_RUN.PAYROLL_ID,P_TIME_PERIOD_NAME);
109: FETCH CSR_PAYROLL_PARAMETERS INTO V_CONDOLIDATION_SET_ID, V_REGULAR_PAY_DATE,V_END_DATE;
110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);
112: hr_utility.trace('EARNED DATE:'||V_END_DATE);
113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);
114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);
115:
116:

Line 113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);

109: FETCH CSR_PAYROLL_PARAMETERS INTO V_CONDOLIDATION_SET_ID, V_REGULAR_PAY_DATE,V_END_DATE;
110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);
112: hr_utility.trace('EARNED DATE:'||V_END_DATE);
113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);
114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);
115:
116:
117: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(

Line 114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);

110: hr_utility.trace('V_CONDOLIDATION_SET--_V_REGULAR_PAY_DATE --V_END_DATE are:'||V_CONDOLIDATION_SET_ID||'-'||V_REGULAR_PAY_DATE||'-'||V_END_DATE);
111: hr_utility.trace('Payroll_id'||PAY_RUN.payroll_id);
112: hr_utility.trace('EARNED DATE:'||V_END_DATE);
113: hr_utility.trace('V_REGULAR_PAY_DATE:'||V_REGULAR_PAY_DATE);
114: hr_utility.trace('P_ELEMENT_SET_NAME:'||P_ELEMENT_SET_NAME);
115:
116:
117: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
118: APPLICATION => 'PAY'

Line 135: hr_utility.trace('Concurrent Request Submitted for Payroll:'||PAY_RUN.payroll_id||'-'||L_REQ_ID);

131: , ARGUMENT9 => l_ARGUMENT9
132: , ARGUMENT10 => l_ARGUMENT10
133: );
134:
135: hr_utility.trace('Concurrent Request Submitted for Payroll:'||PAY_RUN.payroll_id||'-'||L_REQ_ID);
136: CLOSE CSR_PAYROLL_PARAMETERS;
137: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
138: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
139: REQ_COUNT:=REQ_COUNT+1;

Line 138: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));

134:
135: hr_utility.trace('Concurrent Request Submitted for Payroll:'||PAY_RUN.payroll_id||'-'||L_REQ_ID);
136: CLOSE CSR_PAYROLL_PARAMETERS;
137: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
138: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
139: REQ_COUNT:=REQ_COUNT+1;
140: END LOOP;
141:
142: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);

Line 147: hr_utility.trace('Master request details stored are:'||PAR_REQ_ID||'-'||PAR_REQ_PARAMS);

143: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
144: CLOSE CSR_PARENT_REQ_ID;
145:
146: PAR_REQ_PARAMS:=PAR_REQ_PARAMS ||',ROLLBACK_PARAM=' ||P_TIME_PERIOD_NAME;
147: hr_utility.trace('Master request details stored are:'||PAR_REQ_ID||'-'||PAR_REQ_PARAMS);
148:
149: /*
150: Storing into the master and child tables
151: */

Line 166: hr_utility.trace('after inserting into master and child records:');

162: ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
163: ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
164: ,P_CHILD_REQ =>T_CHILD_REQ);
165:
166: hr_utility.trace('after inserting into master and child records:');
167:
168: END RUN_PAYROLL_UK;
169:
170:

Line 226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);

222: BEGIN
223:
224:
225:
226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);
227: hr_utility.trace('P_START_DATE'||P_START_DATE);
228: hr_utility.trace('P_END_DATE'||P_END_DATE);
229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);
230:

Line 227: hr_utility.trace('P_START_DATE'||P_START_DATE);

223:
224:
225:
226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);
227: hr_utility.trace('P_START_DATE'||P_START_DATE);
228: hr_utility.trace('P_END_DATE'||P_END_DATE);
229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);
230:
231:

Line 228: hr_utility.trace('P_END_DATE'||P_END_DATE);

224:
225:
226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);
227: hr_utility.trace('P_START_DATE'||P_START_DATE);
228: hr_utility.trace('P_END_DATE'||P_END_DATE);
229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);
230:
231:
232: REQ_COUNT:=0;

Line 229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);

225:
226: hr_utility.trace('Inside:'||PAY_GB_MULTI_PAYROLL_RUN.g_package);
227: hr_utility.trace('P_START_DATE'||P_START_DATE);
228: hr_utility.trace('P_END_DATE'||P_END_DATE);
229: hr_utility.trace('P_PAYMENT_METHOD_OVERRIDE:'||P_PAYMENT_OVERRIDE_Y_N);
230:
231:
232: REQ_COUNT:=0;
233:

Line 243: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);

239:
240: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
241: LOOP
242:
243: hr_utility.trace('Payroll_Id:'||PAY_RUN.PAYROLL_ID);
244: OPEN CSR_GET_CONS_ID(PAY_RUN.PAYROLL_ID);
245: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
246:
247: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(

Line 262: hr_utility.trace('Leaving one process: request id: is'||L_REQ_ID);

258: , ARGUMENT6 => V_PAYMENT_OVERRIDE_NAME
259: , ARGUMENT7 => P_ACTION_PARAMETER_GROUP
260: );
261:
262: hr_utility.trace('Leaving one process: request id: is'||L_REQ_ID);
263: CLOSE CSR_GET_CONS_ID;
264: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
265: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
266: REQ_COUNT:=REQ_COUNT+1;

Line 265: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));

261:
262: hr_utility.trace('Leaving one process: request id: is'||L_REQ_ID);
263: CLOSE CSR_GET_CONS_ID;
264: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
265: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
266: REQ_COUNT:=REQ_COUNT+1;
267: END LOOP;
268:
269: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);

Line 273: hr_utility.trace('Master request details stored are:'||PAR_REQ_ID||'-'||PAR_REQ_PARAMS);

269: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);
270: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
271: CLOSE CSR_PARENT_REQ_ID;
272:
273: hr_utility.trace('Master request details stored are:'||PAR_REQ_ID||'-'||PAR_REQ_PARAMS);
274:
275: /*
276: Storing into the master and child tables
277: */

Line 293: hr_utility.trace('Child records also updated successfully');

289: ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
290: ,P_CHILD_REQ =>T_CHILD_REQ);
291: --ADDING MASTER DETAILS
292:
293: hr_utility.trace('Child records also updated successfully');
294:
295: END RUN_PREPAYMENTS_UK;
296:
297:

Line 339: hr_utility.trace('Inside:RUN_BACS_UK');

335: WHERE PAYROLL_ID=P_PAYROLL_ID;
336:
337: BEGIN
338:
339: hr_utility.trace('Inside:RUN_BACS_UK');
340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');

Line 340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);

336:
337: BEGIN
338:
339: hr_utility.trace('Inside:RUN_BACS_UK');
340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);

Line 341: hr_utility.trace('P_START_DATE'||P_START_DATE);

337: BEGIN
338:
339: hr_utility.trace('Inside:RUN_BACS_UK');
340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);

Line 342: hr_utility.trace('P_END_DATE'||P_END_DATE);

338:
339: hr_utility.trace('Inside:RUN_BACS_UK');
340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);

Line 343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');

339: hr_utility.trace('Inside:RUN_BACS_UK');
340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);

Line 344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);

340: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);

Line 345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);

341: hr_utility.trace('P_START_DATE'||P_START_DATE);
342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);

Line 346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);

342: hr_utility.trace('P_END_DATE'||P_END_DATE);
343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);

Line 347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);

343: hr_utility.trace('P_PAYMENT_TYPE:'||'BACS Tape');
344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);

Line 348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);

344: hr_utility.trace('P_PAYMENT_METHOD:'||P_PAYMENT_METHOD);
345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);
352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);

Line 349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);

345: hr_utility.trace('P_PROCESS_DATE:'||P_PROCESS_DATE);
346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);
352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);
353:

Line 350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);

346: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);
352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);
353:
354:

Line 351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);

347: hr_utility.trace('P_SORT_SEQUENCE:'||P_SORT_SEQUENCE);
348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);
352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);
353:
354:
355: REQ_COUNT:=0;

Line 352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);

348: hr_utility.trace('P_SUBMISSION_NUMBER:'||P_SUBMISSION_NUMBER);
349: hr_utility.trace('P_EXPIRATION_DATE:'||P_EXPIRATION_DATE);
350: hr_utility.trace('P_AUDIT_SAM_FREQ:'||P_AUDIT_SAM_FREQ);
351: hr_utility.trace('P_B_REPORT_TYPE:'||P_B_REPORT_TYPE);
352: hr_utility.trace('P_B_FORMAT_TYPE:'||P_B_FORMAT_TYPE);
353:
354:
355: REQ_COUNT:=0;
356: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 363: hr_utility.trace('V_AUDIT_SAMPLE_HID:'||V_AUDIT_SAMPLE_HID);

359: V_AUDIT_SAMPLE_HID:='TRANSFER_SELECT_COUNT='||lpad(nvl(P_AUDIT_SAM_FREQ,'0'),4,'0');
360: V_EXPIR_DATE_HID:='TRANSFER_EXPIRY_DATE='||to_char(to_date('2012/12/12', 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
361: V_SUBMISSION_NUMBER_HID:='SUBMISSION_NUMBER='||P_SUBMISSION_NUMBER;
362:
363: hr_utility.trace('V_AUDIT_SAMPLE_HID:'||V_AUDIT_SAMPLE_HID);
364: hr_utility.trace('V_EXPIR_DATE_HID:'||V_EXPIR_DATE_HID);
365: hr_utility.trace('V_SUBMISSION_NUMBER_HID:'||V_SUBMISSION_NUMBER_HID);
366:
367: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);

Line 364: hr_utility.trace('V_EXPIR_DATE_HID:'||V_EXPIR_DATE_HID);

360: V_EXPIR_DATE_HID:='TRANSFER_EXPIRY_DATE='||to_char(to_date('2012/12/12', 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');
361: V_SUBMISSION_NUMBER_HID:='SUBMISSION_NUMBER='||P_SUBMISSION_NUMBER;
362:
363: hr_utility.trace('V_AUDIT_SAMPLE_HID:'||V_AUDIT_SAMPLE_HID);
364: hr_utility.trace('V_EXPIR_DATE_HID:'||V_EXPIR_DATE_HID);
365: hr_utility.trace('V_SUBMISSION_NUMBER_HID:'||V_SUBMISSION_NUMBER_HID);
366:
367: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);
368: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;

Line 365: hr_utility.trace('V_SUBMISSION_NUMBER_HID:'||V_SUBMISSION_NUMBER_HID);

361: V_SUBMISSION_NUMBER_HID:='SUBMISSION_NUMBER='||P_SUBMISSION_NUMBER;
362:
363: hr_utility.trace('V_AUDIT_SAMPLE_HID:'||V_AUDIT_SAMPLE_HID);
364: hr_utility.trace('V_EXPIR_DATE_HID:'||V_EXPIR_DATE_HID);
365: hr_utility.trace('V_SUBMISSION_NUMBER_HID:'||V_SUBMISSION_NUMBER_HID);
366:
367: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);
368: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
369:

Line 370: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);

366:
367: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);
368: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
369:
370: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);
371:
372: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
373: APPLICATION => 'PAY'
374: , PROGRAM => 'BACS'

Line 399: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));

395: , ARGUMENT18 => P_B_FORMAT_TYPE
396: );
397: CLOSE CSR_GET_CONS_ID;
398: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
399: hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
400: REQ_COUNT:=REQ_COUNT+1;
401: END LOOP;
402:
403:

Line 484: hr_utility.trace('P_START_DATE:'||P_START_DATE);

480:
481: V_START_CHEQUE_NUMBER:=P_CHEQUE_START_NUMBER;
482:
483:
484: hr_utility.trace('P_START_DATE:'||P_START_DATE);
485: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
486: LOOP
487: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);
488: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;

Line 491: hr_utility.trace('Start cheque number for payrollL'||PAY_RUN.payroll_id||V_START_CHEQUE_NUMBER);

487: OPEN CSR_GET_CONS_ID(PAY_RUN.payroll_id);
488: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
489:
490:
491: hr_utility.trace('Start cheque number for payrollL'||PAY_RUN.payroll_id||V_START_CHEQUE_NUMBER);
492:
493:
494:
495:

Line 516: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);

512: , ARGUMENT11 => P_CHEQUE_END_NUMBER
513: , ARGUMENT12 => P_ACTION_PARAMETER_GROUP
514: );
515: CLOSE CSR_GET_CONS_ID;
516: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);
517: hr_utility.trace('request_id:'||L_REQ_ID);
518: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
520: REQ_COUNT:=REQ_COUNT+1;

Line 517: hr_utility.trace('request_id:'||L_REQ_ID);

513: , ARGUMENT12 => P_ACTION_PARAMETER_GROUP
514: );
515: CLOSE CSR_GET_CONS_ID;
516: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);
517: hr_utility.trace('request_id:'||L_REQ_ID);
518: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
520: REQ_COUNT:=REQ_COUNT+1;
521: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);

Line 519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);

515: CLOSE CSR_GET_CONS_ID;
516: hr_utility.trace('V_CONDOLIDATION_SET_ID:'||V_CONDOLIDATION_SET_ID);
517: hr_utility.trace('request_id:'||L_REQ_ID);
518: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
520: REQ_COUNT:=REQ_COUNT+1;
521: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
522: --hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
523: OPEN CSR_NEXT_CHEQUE_SEQUENCE(PAY_RUN.payroll_id);

Line 521: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);

517: hr_utility.trace('request_id:'||L_REQ_ID);
518: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
520: REQ_COUNT:=REQ_COUNT+1;
521: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
522: --hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
523: OPEN CSR_NEXT_CHEQUE_SEQUENCE(PAY_RUN.payroll_id);
524: FETCH CSR_NEXT_CHEQUE_SEQUENCE INTO T_START_CHEQUE_NUMBER;
525: CLOSE CSR_NEXT_CHEQUE_SEQUENCE;

Line 522: --hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));

518: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
519: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
520: REQ_COUNT:=REQ_COUNT+1;
521: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
522: --hr_utility.trace('Child request copied is:'||T_CHILD_REQ(REQ_COUNT));
523: OPEN CSR_NEXT_CHEQUE_SEQUENCE(PAY_RUN.payroll_id);
524: FETCH CSR_NEXT_CHEQUE_SEQUENCE INTO T_START_CHEQUE_NUMBER;
525: CLOSE CSR_NEXT_CHEQUE_SEQUENCE;
526:

Line 528: hr_utility.trace('V_START_CHEQUE_NUMBER:'||V_START_CHEQUE_NUMBER);

524: FETCH CSR_NEXT_CHEQUE_SEQUENCE INTO T_START_CHEQUE_NUMBER;
525: CLOSE CSR_NEXT_CHEQUE_SEQUENCE;
526:
527: V_START_CHEQUE_NUMBER:=V_START_CHEQUE_NUMBER+T_START_CHEQUE_NUMBER;
528: hr_utility.trace('V_START_CHEQUE_NUMBER:'||V_START_CHEQUE_NUMBER);
529:
530: END LOOP;
531: hr_utility.trace('Loop over');
532: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);

Line 531: hr_utility.trace('Loop over');

527: V_START_CHEQUE_NUMBER:=V_START_CHEQUE_NUMBER+T_START_CHEQUE_NUMBER;
528: hr_utility.trace('V_START_CHEQUE_NUMBER:'||V_START_CHEQUE_NUMBER);
529:
530: END LOOP;
531: hr_utility.trace('Loop over');
532: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);
533: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
534: CLOSE CSR_PARENT_REQ_ID;
535:

Line 601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);

597: BEGIN
598:
599:
600:
601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);

Line 602: hr_utility.trace('P_START_DATE:'||P_START_DATE);

598:
599:
600:
601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);

Line 603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);

599:
600:
601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);

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

600:
601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);

Line 605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);

601: hr_utility.trace('P_PAYROLL_GROUP_NAME:'||P_PAYROLL_GROUP_ID);
602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);

Line 606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);

602: hr_utility.trace('P_START_DATE:'||P_START_DATE);
603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);

Line 607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);

603: hr_utility.trace('P_EFFECTIVE_DATE:'||P_EFFECTIVE_DATE);
604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);

Line 608: hr_utility.trace('P_END_DATE:'||P_END_DATE);

604: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);

Line 609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);

605: hr_utility.trace('P_MAG_FILE_NAME:'||V_MAG_FILE_NAME);
606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);

Line 610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);

606: hr_utility.trace('P_REP_FILE_NAME:'||V_REP_FILE_NAME);
607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);
614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);

Line 611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);

607: hr_utility.trace('P_ACTION_PARAMETER_GROUP:'||P_ACTION_PARAMETER_GROUP);
608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);
614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);
615:

Line 612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);

608: hr_utility.trace('P_END_DATE:'||P_END_DATE);
609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);
614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);
615:
616: REQ_COUNT:=0;

Line 613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);

609: hr_utility.trace('P_ARCHIVE_START_DATE:'||P_ARCHIVE_START_DATE);
610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);
614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);
615:
616: REQ_COUNT:=0;
617: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);

610: hr_utility.trace('P_ARCHIVE_END_DATE:'||P_ARCHIVE_END_DATE);
611: hr_utility.trace('P_ARCHIVE_START_DATE_HIDDEN:'||P_ARCHIVE_START_DATE_HIDDEN);
612: hr_utility.trace('P_ARCHIVE_END_DATE_HIDDEN:'||P_ARCHIVE_END_DATE_HIDDEN);
613: hr_utility.trace('P_PAYROLL_ID_HID:'|| V_PAYROLL_ID_HID);
614: hr_utility.trace('V_CONSOLIDATION_SET_NAME:'||V_CONSOLIDATION_SET_NAME);
615:
616: REQ_COUNT:=0;
617: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
618: LOOP

Line 623: hr_utility.trace('Payroll Id is:'||PAY_RUN.PAYROLL_ID);

619: OPEN CSR_CONS_DET(PAY_RUN.PAYROLL_ID);
620: FETCH CSR_CONS_DET INTO V_CONSOLIDATION_SET_ID;
621: V_PAYROLL_ID_HID:='PAYROLL='||PAY_RUN.PAYROLL_ID;
622: V_CONSOLIDATION_SET_NAME_HID:='CONSOLIDATION='||V_CONSOLIDATION_SET_ID;
623: hr_utility.trace('Payroll Id is:'||PAY_RUN.PAYROLL_ID);
624: hr_utility.trace('Payroll Id is:'||V_PAYROLL_ID_HID);
625: hr_utility.trace('V_CONSOLIDATION_SET_NAME_HID:'||V_CONSOLIDATION_SET_NAME_HID);
626:
627: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(

Line 624: hr_utility.trace('Payroll Id is:'||V_PAYROLL_ID_HID);

620: FETCH CSR_CONS_DET INTO V_CONSOLIDATION_SET_ID;
621: V_PAYROLL_ID_HID:='PAYROLL='||PAY_RUN.PAYROLL_ID;
622: V_CONSOLIDATION_SET_NAME_HID:='CONSOLIDATION='||V_CONSOLIDATION_SET_ID;
623: hr_utility.trace('Payroll Id is:'||PAY_RUN.PAYROLL_ID);
624: hr_utility.trace('Payroll Id is:'||V_PAYROLL_ID_HID);
625: hr_utility.trace('V_CONSOLIDATION_SET_NAME_HID:'||V_CONSOLIDATION_SET_NAME_HID);
626:
627: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
628: APPLICATION => 'PAY'

Line 625: hr_utility.trace('V_CONSOLIDATION_SET_NAME_HID:'||V_CONSOLIDATION_SET_NAME_HID);

621: V_PAYROLL_ID_HID:='PAYROLL='||PAY_RUN.PAYROLL_ID;
622: V_CONSOLIDATION_SET_NAME_HID:='CONSOLIDATION='||V_CONSOLIDATION_SET_ID;
623: hr_utility.trace('Payroll Id is:'||PAY_RUN.PAYROLL_ID);
624: hr_utility.trace('Payroll Id is:'||V_PAYROLL_ID_HID);
625: hr_utility.trace('V_CONSOLIDATION_SET_NAME_HID:'||V_CONSOLIDATION_SET_NAME_HID);
626:
627: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
628: APPLICATION => 'PAY'
629: , PROGRAM => 'UKPSGEN'

Line 656: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);

652: );
653:
654:
655: CLOSE CSR_CONS_DET;
656: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);
657: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
658: REQ_COUNT:=REQ_COUNT+1;
659: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
660: END LOOP;

Line 659: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);

655: CLOSE CSR_CONS_DET;
656: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);
657: T_CHILD_REQ(REQ_COUNT):=L_REQ_ID;
658: REQ_COUNT:=REQ_COUNT+1;
659: hr_utility.trace('REQ_COUNT:'||REQ_COUNT);
660: END LOOP;
661: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);
662: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
663: CLOSE CSR_PARENT_REQ_ID;

Line 704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);

700: REQ_COUNT NUMBER;
701: BEGIN
702: REQ_COUNT:=0;
703:
704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);

Line 705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);

701: BEGIN
702: REQ_COUNT:=0;
703:
704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);

Line 706: hr_utility.trace('P_START_DATE'||P_START_DATE);

702: REQ_COUNT:=0;
703:
704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);
710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);

Line 707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);

703:
704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);
710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);
711:

Line 708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);

704: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);
710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);
711:
712: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);

705: hr_utility.trace('P_ELEMENT_SET'||P_ELEMENT_SET);
706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);
710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);
711:
712: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
713: LOOP

Line 710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);

706: hr_utility.trace('P_START_DATE'||P_START_DATE);
707: hr_utility.trace('P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
708: hr_utility.trace('P_ACTION_PARAMETER_GROUPL_GROUP_NAME'||P_ACTION_PARAMETER_GROUP);
709: hr_utility.trace('P_RETRO_PAY_DEF'||P_RETRO_PAY_DEF);
710: hr_utility.trace('P_ENTRY_CREATION_DATE'||P_ENTRY_CREATION_DATE);
711:
712: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
713: LOOP
714:

Line 783: hr_utility.trace('Start of TPL Multiple Report');

779:
780:
781: BEGIN
782:
783: hr_utility.trace('Start of TPL Multiple Report');
784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);
787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);

Line 784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);

780:
781: BEGIN
782:
783: hr_utility.trace('Start of TPL Multiple Report');
784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);
787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);
788:

Line 785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);

781: BEGIN
782:
783: hr_utility.trace('Start of TPL Multiple Report');
784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);
787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);
788:
789: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);

782:
783: hr_utility.trace('Start of TPL Multiple Report');
784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);
787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);
788:
789: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
790: LOOP

Line 787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);

783: hr_utility.trace('Start of TPL Multiple Report');
784: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
785: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
786: hr_utility.trace('P_SORT_ORDER'||P_SORT_ORDER);
787: hr_utility.trace('P_SUMMARY_ONLY'||P_SUMMARY_ONLY);
788:
789: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
790: LOOP
791:

Line 794: hr_utility.trace('payroll_id:'||PAY_RUN.PAYROLL_ID);

790: LOOP
791:
792: OPEN CSR_GET_CONS_ID(PAY_RUN.PAYROLL_ID);
793: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
794: hr_utility.trace('payroll_id:'||PAY_RUN.PAYROLL_ID);
795: hr_utility.trace('P_TIME_PERIOD_NAME:'||P_TIME_PERIOD_NAME);
796: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);
797: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
798: APPLICATION => 'PAY'

Line 795: hr_utility.trace('P_TIME_PERIOD_NAME:'||P_TIME_PERIOD_NAME);

791:
792: OPEN CSR_GET_CONS_ID(PAY_RUN.PAYROLL_ID);
793: FETCH CSR_GET_CONS_ID INTO V_CONDOLIDATION_SET_ID;
794: hr_utility.trace('payroll_id:'||PAY_RUN.PAYROLL_ID);
795: hr_utility.trace('P_TIME_PERIOD_NAME:'||P_TIME_PERIOD_NAME);
796: V_TIME_PERIOD_ID:=PAY_GB_MULTI_PAYROLL_RUN.GET_PERIOD_NAME(P_TIME_PERIOD_NAME,PAY_RUN.PAYROLL_ID);
797: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
798: APPLICATION => 'PAY'
799: , PROGRAM => 'PAYRPTPL'

Line 811: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);

807: , ARGUMENT5 => P_SORT_ORDER
808: , ARGUMENT6 => P_SUMMARY_ONLY
809:
810: );
811: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);
812: CLOSE CSR_GET_CONS_ID;
813: END LOOP;
814:
815:

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

833: L_REQ_ID NUMBER;
834: V_CONDOLIDATION_SET_NAME VARCHAR2(20);
835: BEGIN
836:
837: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
838: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
839: hr_utility.trace('P_EARLY_START_DATE'||P_EARLY_START_DATE);
840: hr_utility.trace('P_EARLY_END_DATE'||P_EARLY_END_DATE);
841:

Line 838: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);

834: V_CONDOLIDATION_SET_NAME VARCHAR2(20);
835: BEGIN
836:
837: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
838: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
839: hr_utility.trace('P_EARLY_START_DATE'||P_EARLY_START_DATE);
840: hr_utility.trace('P_EARLY_END_DATE'||P_EARLY_END_DATE);
841:
842: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)

Line 839: hr_utility.trace('P_EARLY_START_DATE'||P_EARLY_START_DATE);

835: BEGIN
836:
837: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
838: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
839: hr_utility.trace('P_EARLY_START_DATE'||P_EARLY_START_DATE);
840: hr_utility.trace('P_EARLY_END_DATE'||P_EARLY_END_DATE);
841:
842: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
843: LOOP

Line 840: hr_utility.trace('P_EARLY_END_DATE'||P_EARLY_END_DATE);

836:
837: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
838: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
839: hr_utility.trace('P_EARLY_START_DATE'||P_EARLY_START_DATE);
840: hr_utility.trace('P_EARLY_END_DATE'||P_EARLY_END_DATE);
841:
842: FOR PAY_RUN IN CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID)
843: LOOP
844:

Line 857: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);

853: , ARGUMENT3 => P_EARLY_START_DATE
854: , ARGUMENT4 => P_EARLY_END_DATE
855: , ARGUMENT5 => V_CONDOLIDATION_SET_NAME
856: );
857: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);
858:
859: END LOOP;
860:
861: END RUN_PAY_SUM_REP;

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

881: V_CONDOLIDATION_SET_NAME VARCHAR2(20);
882: V_TIME_PERIOD_ID NUMBER;
883: BEGIN
884:
885: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
886: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
887: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
888:
889:

Line 886: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);

882: V_TIME_PERIOD_ID NUMBER;
883: BEGIN
884:
885: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
886: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
887: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
888:
889:
890:

Line 887: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);

883: BEGIN
884:
885: hr_utility.trace('P_BUSINESS_GROUP_ID'||P_BUSINESS_GROUP_ID);
886: hr_utility.trace('P_PAYROLL_GROUP_NAME'||P_PAYROLL_GROUP_ID);
887: hr_utility.trace('P_TIME_PERIOD_NAME'||P_TIME_PERIOD_NAME);
888:
889:
890:
891:

Line 913: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);

909: , ARGUMENT6 => P_TOT_DED_ID
910: , ARGUMENT7 => P_DIR_PAY_ID
911: , ARGUMENT8 => P_EMP_CHAR_ID
912: );
913: hr_utility.trace('Request Id: for payroll: '|| PAY_RUN.payroll_id ||' is:' ||L_REQ_ID);
914: END LOOP;
915:
916: END RUN_GROSS_TO_NET_MULTI;
917:

Line 971: hr_utility.trace('Parent Request Id:'||P_PARENT_REQ_ID);

967: V_COUNT:=0;
968:
969: REQ_COUNT:=1;
970:
971: hr_utility.trace('Parent Request Id:'||P_PARENT_REQ_ID);
972:
973: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PARENT_REQ_ID)
974: LOOP
975: hr_utility.trace('aCTUAL REQUEST iD:'||PAY_RUN.CON_ID);

Line 975: hr_utility.trace('aCTUAL REQUEST iD:'||PAY_RUN.CON_ID);

971: hr_utility.trace('Parent Request Id:'||P_PARENT_REQ_ID);
972:
973: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PARENT_REQ_ID)
974: LOOP
975: hr_utility.trace('aCTUAL REQUEST iD:'||PAY_RUN.CON_ID);
976: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
977: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
978:
979: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);

Line 977: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);

973: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PARENT_REQ_ID)
974: LOOP
975: hr_utility.trace('aCTUAL REQUEST iD:'||PAY_RUN.CON_ID);
976: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
977: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
978:
979: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
980: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
981: CLOSE CSR_PAYACT_ID;

Line 983: hr_utility.trace('payroll action id is:'||P_PAY_ACTION_ID);

979: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
980: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
981: CLOSE CSR_PAYACT_ID;
982:
983: hr_utility.trace('payroll action id is:'||P_PAY_ACTION_ID);
984:
985: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
986: APPLICATION => 'PAY'
987: , PROGRAM => 'ROLLBACK_RUN'

Line 1002: hr_utility.trace('Child ROLLBACK request copied is:'||T_CHILD_REQ(REQ_COUNT));

998: V_AL_COUNT:=V_AL_COUNT+1;
999: END IF;
1000: T_CHILD_REQ(REQ_COUNT):=PAY_RUN.CON_ID;
1001: T_ROLLBACK_REQ(REQ_COUNT):=L_REQ_ID;
1002: hr_utility.trace('Child ROLLBACK request copied is:'||T_CHILD_REQ(REQ_COUNT));
1003: REQ_COUNT:=REQ_COUNT+1;
1004: END LOOP;
1005:
1006: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);

Line 1091: hr_utility.trace('P_PAYROLL_GROUP_ID:'||P_PAYROLL_GROUP_ID);

1087:
1088:
1089: NULL;
1090:
1091: hr_utility.trace('P_PAYROLL_GROUP_ID:'||P_PAYROLL_GROUP_ID);
1092: hr_utility.trace('P_YEAR:'||P_YEAR);
1093: hr_utility.trace('P_PROCESS_TYPE:'||P_PROCESS_TYPE);
1094: hr_utility.trace('P_PROCESS_NAME:'||P_PROCESS_NAME);
1095:

Line 1092: hr_utility.trace('P_YEAR:'||P_YEAR);

1088:
1089: NULL;
1090:
1091: hr_utility.trace('P_PAYROLL_GROUP_ID:'||P_PAYROLL_GROUP_ID);
1092: hr_utility.trace('P_YEAR:'||P_YEAR);
1093: hr_utility.trace('P_PROCESS_TYPE:'||P_PROCESS_TYPE);
1094: hr_utility.trace('P_PROCESS_NAME:'||P_PROCESS_NAME);
1095:
1096:

Line 1093: hr_utility.trace('P_PROCESS_TYPE:'||P_PROCESS_TYPE);

1089: NULL;
1090:
1091: hr_utility.trace('P_PAYROLL_GROUP_ID:'||P_PAYROLL_GROUP_ID);
1092: hr_utility.trace('P_YEAR:'||P_YEAR);
1093: hr_utility.trace('P_PROCESS_TYPE:'||P_PROCESS_TYPE);
1094: hr_utility.trace('P_PROCESS_NAME:'||P_PROCESS_NAME);
1095:
1096:
1097: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PROCESS_NAME)

Line 1094: hr_utility.trace('P_PROCESS_NAME:'||P_PROCESS_NAME);

1090:
1091: hr_utility.trace('P_PAYROLL_GROUP_ID:'||P_PAYROLL_GROUP_ID);
1092: hr_utility.trace('P_YEAR:'||P_YEAR);
1093: hr_utility.trace('P_PROCESS_TYPE:'||P_PROCESS_TYPE);
1094: hr_utility.trace('P_PROCESS_NAME:'||P_PROCESS_NAME);
1095:
1096:
1097: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PROCESS_NAME)
1098: LOOP

Line 1100: hr_utility.trace('PAY_RUN.CON_ID'||PAY_RUN.CON_ID);

1096:
1097: FOR PAY_RUN IN CSR_CHILD_REQUEST(P_PROCESS_NAME)
1098: LOOP
1099:
1100: hr_utility.trace('PAY_RUN.CON_ID'||PAY_RUN.CON_ID);
1101:
1102: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
1103: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
1104:

Line 1103: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);

1099:
1100: hr_utility.trace('PAY_RUN.CON_ID'||PAY_RUN.CON_ID);
1101:
1102: IF PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1 THEN
1103: hr_utility.trace('child requestId:'||PAY_RUN.CON_ID);
1104:
1105: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
1106: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1107: CLOSE CSR_PAYACT_ID;

Line 1109: hr_utility.trace('PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1');

1105: OPEN CSR_PAYACT_ID(PAY_RUN.CON_ID);
1106: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1107: CLOSE CSR_PAYACT_ID;
1108:
1109: hr_utility.trace('PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1');
1110: hr_utility.trace('P_PAY_ACTION_ID passed is:'||P_PAY_ACTION_ID);
1111: V_PAYROLL_RUN_HID:='PAYROLL_ACTION_ID='||P_PAY_ACTION_ID;
1112: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
1113: APPLICATION => 'PAY'

Line 1110: hr_utility.trace('P_PAY_ACTION_ID passed is:'||P_PAY_ACTION_ID);

1106: FETCH CSR_PAYACT_ID INTO P_PAY_ACTION_ID;
1107: CLOSE CSR_PAYACT_ID;
1108:
1109: hr_utility.trace('PAY_GB_MULTI_DML_AND_VAL.CHK_ALREADY_ROLLED_BACK(PAY_RUN.CON_ID)=1');
1110: hr_utility.trace('P_PAY_ACTION_ID passed is:'||P_PAY_ACTION_ID);
1111: V_PAYROLL_RUN_HID:='PAYROLL_ACTION_ID='||P_PAY_ACTION_ID;
1112: L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST(
1113: APPLICATION => 'PAY'
1114: , PROGRAM => 'ROLLBACK'

Line 1148: hr_utility.trace('bEFORE MASTER UPDATE');

1144: OPEN CSR_PARENT_REQ_ID(L_REQ_ID);
1145: FETCH CSR_PARENT_REQ_ID INTO PAR_REQ_ID, PAR_REQ_PARAMS;
1146: CLOSE CSR_PARENT_REQ_ID;
1147:
1148: hr_utility.trace('bEFORE MASTER UPDATE');
1149:
1150: PAY_GB_MULTI_DML_AND_VAL.UPDATE_MASTER_ROLLBACK_DETAILS
1151: (
1152: P_MASTER_REQUEST_ID=>P_PROCESS_NAME

Line 1161: hr_utility.trace('BEFORE CHILD UPDATE');

1157: /*
1158: UPDATING THE ROLLBACK
1159: */
1160:
1161: hr_utility.trace('BEFORE CHILD UPDATE');
1162: FOR P IN 0..V_N_COUNT
1163: LOOP
1164:
1165: PAY_GB_MULTI_DML_AND_VAL.UPDATE_CHILD_ROLLBACK_DETAILS