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

Line 149: -- the hr_utility.trace msg for

145: -- 12-MAR-2003 pganguly 115.26 2842174 In the archive_data proc, added
146: -- l_value := 0 before archiving
147: -- Box 17 Balances.
148: -- 05-MAR-2003 pganguly 115.24 Removed the to_char call from
149: -- the hr_utility.trace msg for
150: -- Box 17A l_value.
151: -- 03-MAR-2003 pganguly 115.23 2685760 Added the functionality to
152: -- archive Box 17A/C balances.
153: -- 31-DEC-2002 pganguly 115.22 2732112 Changed the cursor

Line 180: -- 05-JAN-2000 pganguly 115.9 Commented hr_utility.trace_on

176: -- get_ei_amount_totals function
177: -- added 1 to previuos ROE date
178: -- so that it becomes the start
179: -- date of the next ROE.
180: -- 05-JAN-2000 pganguly 115.9 Commented hr_utility.trace_on
181: -- 27-DEC-2000 pganguly 115.8 Added a check while archiving
182: -- EI Earnings. If BOX15B is
183: -- returned then we archive 0
184: -- in all the places for Box

Line 248: -- hr_utility.trace_on(null,'ROE');

244: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;
245: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
246:
247: begin
248: -- hr_utility.trace_on(null,'ROE');
249:
250: open cur_payroll_actions;
251: fetch cur_payroll_actions into
252: l_legislative_parameters;

Line 255: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);

251: fetch cur_payroll_actions into
252: l_legislative_parameters;
253: close cur_payroll_actions;
254:
255: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);
256: l_person_id :=
257: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
258: l_assignment_set_id :=
259: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);

Line 263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));

259: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);
260: l_assignment_amend :=
261: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
262:
263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));
264: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
265: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));
266:
267: if l_assignment_set_id is not null then

Line 264: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));

260: l_assignment_amend :=
261: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
262:
263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));
264: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
265: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));
266:
267: if l_assignment_set_id is not null then
268:

Line 265: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));

261: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
262:
263: hr_utility.trace('PERSON_ID= ' || to_char(l_person_id));
264: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
265: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' || to_char(l_assignment_amend));
266:
267: if l_assignment_set_id is not null then
268:
269: str := 'select

Line 283: hr_utility.trace('Assignment set id is not null');

279: hasa.assignment_id = paf.assignment_id and
280: ppa.payroll_action_id = :pactid
281: ORDER BY paf.person_id';
282:
283: hr_utility.trace('Assignment set id is not null');
284:
285: else
286:
287: -- For one person only. The person_id will be stored

Line 437: hr_utility.trace('l_hour = ' || to_char(l_hour));

433: c_ws_tab_name,
434: l_user_column_name,
435: v_curr_day));
436:
437: hr_utility.trace('l_hour = ' || to_char(l_hour));
438:
439: if l_hour <> 0 then
440: exit;
441: else

Line 451: hr_utility.trace('l working date = ' || to_char(l_working_date));

447: end if;
448:
449: end loop;
450:
451: hr_utility.trace('l working date = ' || to_char(l_working_date));
452: return l_working_date;
453:
454: end;
455:

Line 487: hr_utility.trace('Function get_defined_balance_id starts here !');

483: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
484:
485: begin
486:
487: hr_utility.trace('Function get_defined_balance_id starts here !');
488:
489: open cur_get_def_bal_id;
490: fetch cur_get_def_bal_id
491: into l_def_balance_id;

Line 494: hr_utility.trace('get_defined_balance_id: Defined balance not found!');

490: fetch cur_get_def_bal_id
491: into l_def_balance_id;
492: if cur_get_def_bal_id%NOTFOUND then
493: close cur_get_def_bal_id;
494: hr_utility.trace('get_defined_balance_id: Defined balance not found!');
495: return -1;
496: else
497: close cur_get_def_bal_id;
498: hr_utility.trace('get_defined_balance_id: Defined balance found = ' ||

Line 498: hr_utility.trace('get_defined_balance_id: Defined balance found = ' ||

494: hr_utility.trace('get_defined_balance_id: Defined balance not found!');
495: return -1;
496: else
497: close cur_get_def_bal_id;
498: hr_utility.trace('get_defined_balance_id: Defined balance found = ' ||
499: to_char(l_def_balance_id));
500: return l_def_balance_id;
501: end if;
502:

Line 534: hr_utility.trace('Function balance_feed_exists');

530: dummy varchar2(1);
531:
532: begin
533:
534: hr_utility.trace('Function balance_feed_exists');
535: hr_utility.trace('balance_feed_exists p_balance_name = ' || p_balance_name);
536:
537: OPEN cur_bal_feed_exists;
538: FETCH cur_bal_feed_exists

Line 535: hr_utility.trace('balance_feed_exists p_balance_name = ' || p_balance_name);

531:
532: begin
533:
534: hr_utility.trace('Function balance_feed_exists');
535: hr_utility.trace('balance_feed_exists p_balance_name = ' || p_balance_name);
536:
537: OPEN cur_bal_feed_exists;
538: FETCH cur_bal_feed_exists
539: INTO dummy;

Line 542: hr_utility.trace('balance_feed_exists for = ' || p_balance_name);

538: FETCH cur_bal_feed_exists
539: INTO dummy;
540: if cur_bal_feed_exists%FOUND then
541: close cur_bal_feed_exists;
542: hr_utility.trace('balance_feed_exists for = ' || p_balance_name);
543: return TRUE;
544: else
545: close cur_bal_feed_exists;
546: hr_utility.trace('Balance Feed doesn''t exist for = ' || p_balance_name);

Line 546: hr_utility.trace('Balance Feed doesn''t exist for = ' || p_balance_name);

542: hr_utility.trace('balance_feed_exists for = ' || p_balance_name);
543: return TRUE;
544: else
545: close cur_bal_feed_exists;
546: hr_utility.trace('Balance Feed doesn''t exist for = ' || p_balance_name);
547: return FALSE;
548: end if;
549:
550: end;

Line 603: hr_utility.trace('before terminate'||to_char(p_effective_date));

599: l_roe_comment varchar2(150);
600: l_effective_date date;
601:
602: begin
603: hr_utility.trace('before terminate'||to_char(p_effective_date));
604: open cur_terminate;
605:
606: fetch cur_terminate
607: into l_termination_date,

Line 618: hr_utility.trace('Cur terminate not found');

614: cur_terminate%notfound then
615:
616: close cur_terminate;
617:
618: hr_utility.trace('Cur terminate not found');
619:
620: l_effective_date := get_working_date(p_business_group_id,
621: p_asg_id,
622: p_effective_date,

Line 636: hr_utility.trace('Cur absence not found');

632:
633: if cur_absence%notfound
634: or l_absence_date is null then
635:
636: hr_utility.trace('Cur absence not found');
637: close cur_absence;
638: p_recall_date := l_recall_date;
639: p_roe_reason := l_roe_reason;
640: p_roe_comment := l_roe_comment;

Line 647: hr_utility.trace('Cur absence found');

643: return p_effective_date;
644:
645: else
646:
647: hr_utility.trace('Cur absence found');
648: close cur_absence;
649: p_recall_date := l_recall_date;
650: p_roe_reason := l_roe_reason;
651: p_roe_comment := l_roe_comment;

Line 654: hr_utility.trace('l_absence_date: '||to_char(l_absence_date));

650: p_roe_reason := l_roe_reason;
651: p_roe_comment := l_roe_comment;
652: p_term_or_abs_flag := 'Y';
653: p_term_or_abs := 'A';
654: hr_utility.trace('l_absence_date: '||to_char(l_absence_date));
655:
656: return l_absence_date;
657:
658: end if;

Line 667: hr_utility.trace('.....in terminate...else..');

663: p_roe_reason := l_roe_reason;
664: p_roe_comment := l_roe_comment;
665: p_term_or_abs_flag := 'Y';
666: p_term_or_abs := 'T';
667: hr_utility.trace('.....in terminate...else..');
668: close cur_terminate;
669: return l_termination_date;
670:
671: end if;

Line 812: hr_utility.trace('Archive initialization');

808: FETCH cur_bg_id
809: INTO l_bg_id;
810: CLOSE cur_bg_id;
811:
812: hr_utility.trace('Archive initialization');
813: pay_ca_roe_ei_pkg.populate_element_table(l_bg_id);
814: populate_box17c_bal_table;
815:
816: END;

Line 1138: hr_utility.set_location('check_retry_amend' , 5);

1134: open cur_ppf;
1135: fetch cur_ppf into l_full_name;
1136: close cur_ppf;
1137:
1138: hr_utility.set_location('check_retry_amend' , 5);
1139: open cur_retry;
1140: fetch cur_retry into l_context1;
1141:
1142: if (cur_retry%FOUND) then

Line 1144: hr_utility.set_location('check_retry_amend' , 7);

1140: fetch cur_retry into l_context1;
1141:
1142: if (cur_retry%FOUND) then
1143:
1144: hr_utility.set_location('check_retry_amend' , 7);
1145: hr_utility.trace('l_context1 = '|| to_char(l_context1));
1146: close cur_retry;
1147: open cur_amend;
1148: fetch cur_amend into dummy;

Line 1145: hr_utility.trace('l_context1 = '|| to_char(l_context1));

1141:
1142: if (cur_retry%FOUND) then
1143:
1144: hr_utility.set_location('check_retry_amend' , 7);
1145: hr_utility.trace('l_context1 = '|| to_char(l_context1));
1146: close cur_retry;
1147: open cur_amend;
1148: fetch cur_amend into dummy;
1149: if cur_amend%FOUND then

Line 1156: hr_utility.set_location('pay_ca_archive.cur_amend', 10);

1152: -- So it is an amend issue.
1153:
1154: close cur_amend;
1155:
1156: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1157:
1158: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1159: hr_utility.set_message_token('PERSON',l_full_name);
1160: --hr_utility.raise_error;

Line 1158: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');

1154: close cur_amend;
1155:
1156: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1157:
1158: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1159: hr_utility.set_message_token('PERSON',l_full_name);
1160: --hr_utility.raise_error;
1161: RETURN FALSE;
1162: else

Line 1159: hr_utility.set_message_token('PERSON',l_full_name);

1155:
1156: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1157:
1158: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1159: hr_utility.set_message_token('PERSON',l_full_name);
1160: --hr_utility.raise_error;
1161: RETURN FALSE;
1162: else
1163: close cur_amend;

Line 1160: --hr_utility.raise_error;

1156: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1157:
1158: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1159: hr_utility.set_message_token('PERSON',l_full_name);
1160: --hr_utility.raise_error;
1161: RETURN FALSE;
1162: else
1163: close cur_amend;
1164:

Line 1168: hr_utility.set_location('pay_ca_archive.cur_amend', 20);

1164:
1165: -- Record not found, so it is a
1166: -- Retry Issue
1167:
1168: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1169: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1170: hr_utility.set_message_token('PERSON',l_full_name);
1171: --hr_utility.raise_error;
1172: RETURN FALSE;

Line 1169: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');

1165: -- Record not found, so it is a
1166: -- Retry Issue
1167:
1168: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1169: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1170: hr_utility.set_message_token('PERSON',l_full_name);
1171: --hr_utility.raise_error;
1172: RETURN FALSE;
1173:

Line 1170: hr_utility.set_message_token('PERSON',l_full_name);

1166: -- Retry Issue
1167:
1168: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1169: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1170: hr_utility.set_message_token('PERSON',l_full_name);
1171: --hr_utility.raise_error;
1172: RETURN FALSE;
1173:
1174: end if;

Line 1171: --hr_utility.raise_error;

1167:
1168: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1169: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1170: hr_utility.set_message_token('PERSON',l_full_name);
1171: --hr_utility.raise_error;
1172: RETURN FALSE;
1173:
1174: end if;
1175:

Line 1179: hr_utility.set_location('pay_ca_archive.cur_retry', 10);

1175:
1176: else
1177:
1178: close cur_retry;
1179: hr_utility.set_location('pay_ca_archive.cur_retry', 10);
1180: RETURN TRUE;
1181:
1182: end if;
1183:

Line 1190: hr_utility.set_location('Package pay_ca_archive...action creation',1);

1186: end; -- End check_retry_amend
1187:
1188: begin
1189:
1190: hr_utility.set_location('Package pay_ca_archive...action creation',1);
1191:
1192: open cur_payroll_actions;
1193: fetch cur_payroll_actions
1194: into

Line 1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);

1204: l_assignment_amend :=
1205: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1206: l_end_date := l_effective_date;
1207:
1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));
1210: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
1211: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||
1212: to_char(l_assignment_amend));

Line 1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));

1205: pycadar_pkg.get_parameter('ASSIGNMENT_ID',l_legislative_parameters);
1206: l_end_date := l_effective_date;
1207:
1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));
1210: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
1211: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||
1212: to_char(l_assignment_amend));
1213:

Line 1210: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));

1206: l_end_date := l_effective_date;
1207:
1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));
1210: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
1211: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||
1212: to_char(l_assignment_amend));
1213:
1214: if l_assignment_set_id is null then

Line 1211: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||

1207:
1208: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1209: hr_utility.trace('Person ID = '|| to_char(l_person_id));
1210: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
1211: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||
1212: to_char(l_assignment_amend));
1213:
1214: if l_assignment_set_id is null then
1215:

Line 1225: hr_utility.trace('l_date_start = ' ||to_char(l_date_start)); */

1221: last_period_of_service (l_effective_date,
1222: l_person_id,
1223: l_business_group_id);
1224:
1225: hr_utility.trace('l_date_start = ' ||to_char(l_date_start)); */
1226:
1227: -- If assignment_set_id is null then the
1228: -- archiver is running for one person, the id of
1229: -- the person is stored in legislative_parameters.

Line 1245: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));

1241: l_roe_reason,
1242: l_roe_comment,
1243: l_term_or_abs_flag,
1244: l_term_or_abs);
1245: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1246:
1247: l_roe_date := l_effective_date;
1248:
1249: l_prev_roe_date := get_balance_start_date(l_person_id,

Line 1259: hr_utility.trace('Locking action id not found');

1255: open cur_asg_action_id;
1256: fetch cur_asg_action_id into l_lockingactid;
1257: if cur_asg_action_id%NOTFOUND then
1258: close cur_asg_action_id;
1259: hr_utility.trace('Locking action id not found');
1260: else
1261: close cur_asg_action_id;
1262: hr_utility.trace('Locking action id found');
1263: end if;

Line 1262: hr_utility.trace('Locking action id found');

1258: close cur_asg_action_id;
1259: hr_utility.trace('Locking action id not found');
1260: else
1261: close cur_asg_action_id;
1262: hr_utility.trace('Locking action id found');
1263: end if;
1264:
1265: l_user_entity_amend(1) := get_user_entity('ROE_ASSIGNMENT_ID');
1266: l_value_amend(1) := archive_value(l_assignment_amend,'ROE_ASSIGNMENT_ID');

Line 1280: hr_utility.trace('l_value_amend(1)'||l_value_amend(1));

1276:
1277: l_user_entity_amend(5) := get_user_entity('ROE_DATE');
1278: l_value_amend(5) := archive_value(l_assignment_amend,'ROE_DATE');
1279:
1280: hr_utility.trace('l_value_amend(1)'||l_value_amend(1));
1281: hr_utility.trace('l_value_amend(2)'||l_value_amend(2));
1282: hr_utility.trace('l_value_amend(3)'||l_value_amend(3));
1283:
1284: hr_nonrun_asact.insact(l_lockingactid,

Line 1281: hr_utility.trace('l_value_amend(2)'||l_value_amend(2));

1277: l_user_entity_amend(5) := get_user_entity('ROE_DATE');
1278: l_value_amend(5) := archive_value(l_assignment_amend,'ROE_DATE');
1279:
1280: hr_utility.trace('l_value_amend(1)'||l_value_amend(1));
1281: hr_utility.trace('l_value_amend(2)'||l_value_amend(2));
1282: hr_utility.trace('l_value_amend(3)'||l_value_amend(3));
1283:
1284: hr_nonrun_asact.insact(l_lockingactid,
1285: l_value_amend(1),

Line 1282: hr_utility.trace('l_value_amend(3)'||l_value_amend(3));

1278: l_value_amend(5) := archive_value(l_assignment_amend,'ROE_DATE');
1279:
1280: hr_utility.trace('l_value_amend(1)'||l_value_amend(1));
1281: hr_utility.trace('l_value_amend(2)'||l_value_amend(2));
1282: hr_utility.trace('l_value_amend(3)'||l_value_amend(3));
1283:
1284: hr_nonrun_asact.insact(l_lockingactid,
1285: l_value_amend(1),
1286: pactid,

Line 1331: hr_utility.trace('l_person_id = '|| l_person_id);

1327: ELSE
1328: l_start_date := l_effective_date - 400;
1329: END IF;
1330:
1331: hr_utility.trace('l_person_id = '|| l_person_id);
1332: hr_utility.trace('l_start_date = '|| l_start_date);
1333: hr_utility.trace('l_effective_date = '|| l_effective_date);
1334:
1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop

Line 1332: hr_utility.trace('l_start_date = '|| l_start_date);

1328: l_start_date := l_effective_date - 400;
1329: END IF;
1330:
1331: hr_utility.trace('l_person_id = '|| l_person_id);
1332: hr_utility.trace('l_start_date = '|| l_start_date);
1333: hr_utility.trace('l_effective_date = '|| l_effective_date);
1334:
1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1336:

Line 1333: hr_utility.trace('l_effective_date = '|| l_effective_date);

1329: END IF;
1330:
1331: hr_utility.trace('l_person_id = '|| l_person_id);
1332: hr_utility.trace('l_start_date = '|| l_start_date);
1333: hr_utility.trace('l_effective_date = '|| l_effective_date);
1334:
1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1336:
1337: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));

Line 1337: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));

1333: hr_utility.trace('l_effective_date = '|| l_effective_date);
1334:
1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1336:
1337: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1338: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1339: hr_utility.set_location('Get the locking action id', 1);
1340:
1341: open cur_prd_end_date(i.payroll_id,

Line 1338: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));

1334:
1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1336:
1337: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1338: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1339: hr_utility.set_location('Get the locking action id', 1);
1340:
1341: open cur_prd_end_date(i.payroll_id,
1342: l_roe_date);

Line 1339: hr_utility.set_location('Get the locking action id', 1);

1335: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1336:
1337: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1338: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1339: hr_utility.set_location('Get the locking action id', 1);
1340:
1341: open cur_prd_end_date(i.payroll_id,
1342: l_roe_date);
1343: fetch cur_prd_end_date

Line 1347: hr_utility.trace('l_effective_date1 = '|| to_char(l_effective_date1));

1343: fetch cur_prd_end_date
1344: into l_effective_date1;
1345: close cur_prd_end_date;
1346:
1347: hr_utility.trace('l_effective_date1 = '|| to_char(l_effective_date1));
1348:
1349: l_first_t4_gre := 'Y';
1350:
1351: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop

Line 1353: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));

1349: l_first_t4_gre := 'Y';
1350:
1351: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop
1352:
1353: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));
1354: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);
1355:
1356: if (k.gre_type = 'T4' and l_first_t4_gre = 'Y') then
1357: multiple_gre := TRUE;

Line 1354: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);

1350:
1351: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop
1352:
1353: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));
1354: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);
1355:
1356: if (k.gre_type = 'T4' and l_first_t4_gre = 'Y') then
1357: multiple_gre := TRUE;
1358: l_first_t4_gre := 'N';

Line 1367: hr_utility.trace('Locking action id not found');

1363: open cur_asg_action_id;
1364: fetch cur_asg_action_id into l_lockingactid;
1365: if cur_asg_action_id%NOTFOUND then
1366: close cur_asg_action_id;
1367: hr_utility.trace('Locking action id not found');
1368: else
1369: close cur_asg_action_id;
1370: hr_utility.trace('Locking action id found');
1371: end if;

Line 1370: hr_utility.trace('Locking action id found');

1366: close cur_asg_action_id;
1367: hr_utility.trace('Locking action id not found');
1368: else
1369: close cur_asg_action_id;
1370: hr_utility.trace('Locking action id found');
1371: end if;
1372:
1373: hr_nonrun_asact.insact(l_lockingactid,i.assignment_id,
1374: pactid,chunk,k.gre_id);

Line 1395: hr_utility.trace('Date: '||to_char(l_roe_date));

1391: --
1392: -- If it is locked by Mag process then we error out saying
1393: -- user need to amend the assignment.
1394:
1395: hr_utility.trace('Date: '||to_char(l_roe_date));
1396:
1397: if check_retry_amend(l_person_id,
1398: i.assignment_id,
1399: i.payroll_id,

Line 1411: hr_utility.trace('GRE ID = '|| to_char(k.gre_id));

1407: -- in the assignment_action creation level
1408:
1409: total_no_fields := 5;
1410:
1411: hr_utility.trace('GRE ID = '|| to_char(k.gre_id));
1412:
1413: for j in 1..total_no_fields loop
1414:
1415: if j = 1 then

Line 1467: hr_utility.trace('l_date_start = ' ||to_char(l_date_start)); */

1463: last_period_of_service (l_end_date,
1464: l_person_id,
1465: l_business_group_id);
1466:
1467: hr_utility.trace('l_date_start = ' ||to_char(l_date_start)); */
1468:
1469: l_effective_date := get_date(l_person_id,
1470: l_assignment_id,
1471: l_business_group_id,

Line 1478: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));

1474: l_roe_reason,
1475: l_roe_comment,
1476: l_term_or_abs_flag,
1477: l_term_or_abs);
1478: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1479: hr_utility.trace('l_end_date: '||to_char(l_end_date));
1480:
1481: l_roe_date := l_effective_date;
1482:

Line 1479: hr_utility.trace('l_end_date: '||to_char(l_end_date));

1475: l_roe_comment,
1476: l_term_or_abs_flag,
1477: l_term_or_abs);
1478: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1479: hr_utility.trace('l_end_date: '||to_char(l_end_date));
1480:
1481: l_roe_date := l_effective_date;
1482:
1483: l_prev_roe_date := get_balance_start_date(l_person_id,

Line 1510: hr_utility.trace('l_person_id = '|| l_person_id);

1506: ELSE
1507: l_start_date := l_effective_date - 400;
1508: END IF;
1509:
1510: hr_utility.trace('l_person_id = '|| l_person_id);
1511: hr_utility.trace('l_start_date = '|| l_start_date);
1512: hr_utility.trace('l_effective_date = '|| l_effective_date);
1513:
1514: if l_term_or_abs in ('A','T') then

Line 1511: hr_utility.trace('l_start_date = '|| l_start_date);

1507: l_start_date := l_effective_date - 400;
1508: END IF;
1509:
1510: hr_utility.trace('l_person_id = '|| l_person_id);
1511: hr_utility.trace('l_start_date = '|| l_start_date);
1512: hr_utility.trace('l_effective_date = '|| l_effective_date);
1513:
1514: if l_term_or_abs in ('A','T') then
1515: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop

Line 1512: hr_utility.trace('l_effective_date = '|| l_effective_date);

1508: END IF;
1509:
1510: hr_utility.trace('l_person_id = '|| l_person_id);
1511: hr_utility.trace('l_start_date = '|| l_start_date);
1512: hr_utility.trace('l_effective_date = '|| l_effective_date);
1513:
1514: if l_term_or_abs in ('A','T') then
1515: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1516:

Line 1517: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));

1513:
1514: if l_term_or_abs in ('A','T') then
1515: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1516:
1517: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1518: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1519: hr_utility.set_location('Get the locking action id', 1);
1520:
1521: open cur_prd_end_date(i.payroll_id,

Line 1518: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));

1514: if l_term_or_abs in ('A','T') then
1515: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1516:
1517: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1518: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1519: hr_utility.set_location('Get the locking action id', 1);
1520:
1521: open cur_prd_end_date(i.payroll_id,
1522: l_roe_date);

Line 1519: hr_utility.set_location('Get the locking action id', 1);

1515: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1516:
1517: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));
1518: hr_utility.trace('I.payroll ID = '|| to_char(i.payroll_id));
1519: hr_utility.set_location('Get the locking action id', 1);
1520:
1521: open cur_prd_end_date(i.payroll_id,
1522: l_roe_date);
1523: fetch cur_prd_end_date

Line 1527: hr_utility.trace('l_effective_date1 = '|| to_char(l_effective_date1));

1523: fetch cur_prd_end_date
1524: into l_effective_date1;
1525: close cur_prd_end_date;
1526:
1527: hr_utility.trace('l_effective_date1 = '|| to_char(l_effective_date1));
1528:
1529: l_first_t4_gre := 'Y';
1530:
1531: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop

Line 1533: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));

1529: l_first_t4_gre := 'Y';
1530:
1531: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop
1532:
1533: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));
1534: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);
1535:
1536: if (k.gre_type = 'T4' and l_first_t4_gre = 'Y') then
1537: multiple_gre := TRUE;

Line 1534: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);

1530:
1531: for k in cur_gre(i.assignment_id,i.payroll_id,l_effective_date1) loop
1532:
1533: hr_utility.trace('k.GRE ID = '|| to_char(k.gre_id));
1534: hr_utility.trace('k.GRE TYPE = '|| k.gre_type);
1535:
1536: if (k.gre_type = 'T4' and l_first_t4_gre = 'Y') then
1537: multiple_gre := TRUE;
1538: l_first_t4_gre := 'N';

Line 1547: hr_utility.trace('Locking action id not found');

1543: open cur_asg_action_id;
1544: fetch cur_asg_action_id into l_lockingactid;
1545: if cur_asg_action_id%NOTFOUND then
1546: close cur_asg_action_id;
1547: hr_utility.trace('Locking action id not found');
1548: else
1549: close cur_asg_action_id;
1550: hr_utility.trace('Locking action id found');
1551: end if;

Line 1550: hr_utility.trace('Locking action id found');

1546: close cur_asg_action_id;
1547: hr_utility.trace('Locking action id not found');
1548: else
1549: close cur_asg_action_id;
1550: hr_utility.trace('Locking action id found');
1551: end if;
1552:
1553:
1554: hr_nonrun_asact.insact(l_lockingactid,i.assignment_id,

Line 1576: hr_utility.trace('Date: '||to_char(l_roe_date));

1572: --
1573: -- If it is locked by Mag process then we error out saying
1574: -- user need to amend the assignment.
1575:
1576: hr_utility.trace('Date: '||to_char(l_roe_date));
1577:
1578: if check_retry_amend(l_person_id,
1579: i.assignment_id,
1580: i.payroll_id,

Line 1592: hr_utility.trace('GRE ID = '|| to_char(k.gre_id));

1588: -- in the assignment_action creation level
1589:
1590: total_no_fields := 5;
1591:
1592: hr_utility.trace('GRE ID = '|| to_char(k.gre_id));
1593:
1594: for j in 1..total_no_fields loop
1595:
1596: if j = 1 then

Line 1634: hr_utility.trace('Action Creation: assignment set is passed');

1630: end if;
1631:
1632: end loop; -- cur_asg_set_person_id
1633:
1634: hr_utility.trace('Action Creation: assignment set is passed');
1635:
1636: end if; -- End if (Assignment set)
1637: end;
1638:

Line 1639: hr_utility.trace_off;

1635:
1636: end if; -- End if (Assignment set)
1637: end;
1638:
1639: hr_utility.trace_off;
1640:
1641: end action_creation;
1642:
1643:

Line 1680: hr_utility.trace('func_expected_date_of_return');

1676: l_temp_date date;
1677:
1678: begin
1679:
1680: hr_utility.trace('func_expected_date_of_return');
1681:
1682: l_edor_uid := get_user_entity('ROE_EXPECTED_DATE_OF_RECALL');
1683: l_payroll_uid := get_user_entity('ROE_PAYROLL_ID');
1684:

Line 1690: hr_utility.trace('func_expected_date_of_return l_value = ' || l_value);

1686: fetch cur_edor
1687: into l_value;
1688: close cur_edor;
1689:
1690: hr_utility.trace('func_expected_date_of_return l_value = ' || l_value);
1691: l_temp_date := fnd_date.canonical_to_date(l_value);
1692:
1693: return l_temp_date;
1694:

Line 2173: hr_utility.trace('Archive data');

2169: l_serial_number pay_assignment_actions.serial_number%TYPE;
2170:
2171: begin
2172:
2173: hr_utility.trace('Archive data');
2174:
2175: open cur_archive_info;
2176: fetch cur_archive_info
2177: into l_assignment_id,

Line 2268: hr_utility.trace('cur_rec.first_name = '|| cur_rec.first_name);

2264: total_no_fields := 5;
2265:
2266: for cur_rec in cur_employee_info loop
2267:
2268: hr_utility.trace('cur_rec.first_name = '|| cur_rec.first_name);
2269: hr_utility.trace('cur_rec.middle_name = '|| cur_rec.middle_names);
2270: hr_utility.trace('cur_rec.last_name = '|| cur_rec.last_name);
2271:
2272: for cur_field in 1..total_no_fields loop

Line 2269: hr_utility.trace('cur_rec.middle_name = '|| cur_rec.middle_names);

2265:
2266: for cur_rec in cur_employee_info loop
2267:
2268: hr_utility.trace('cur_rec.first_name = '|| cur_rec.first_name);
2269: hr_utility.trace('cur_rec.middle_name = '|| cur_rec.middle_names);
2270: hr_utility.trace('cur_rec.last_name = '|| cur_rec.last_name);
2271:
2272: for cur_field in 1..total_no_fields loop
2273:

Line 2270: hr_utility.trace('cur_rec.last_name = '|| cur_rec.last_name);

2266: for cur_rec in cur_employee_info loop
2267:
2268: hr_utility.trace('cur_rec.first_name = '|| cur_rec.first_name);
2269: hr_utility.trace('cur_rec.middle_name = '|| cur_rec.middle_names);
2270: hr_utility.trace('cur_rec.last_name = '|| cur_rec.last_name);
2271:
2272: for cur_field in 1..total_no_fields loop
2273:
2274: if cur_field = 1 then

Line 2301: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2297: l_user_entity_id := get_user_entity('ROE_EMPLOYEE_CORRESPONDENCE_LANGUAGE');
2298:
2299: end if;
2300:
2301: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2302: hr_utility.trace('l value = '|| l_value);
2303:
2304: ff_archive_api.create_archive_item(
2305: p_archive_item_id => l_archive_item_id,

Line 2302: hr_utility.trace('l value = '|| l_value);

2298:
2299: end if;
2300:
2301: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2302: hr_utility.trace('l value = '|| l_value);
2303:
2304: ff_archive_api.create_archive_item(
2305: p_archive_item_id => l_archive_item_id,
2306: p_user_entity_id => l_user_entity_id,

Line 2370: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2366: l_user_entity_id := get_user_entity('ROE_TAX_UNIT_PHONE_NUMBER');
2367:
2368: end if;
2369:
2370: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2371: hr_utility.trace('l value = '|| l_value);
2372:
2373: ff_archive_api.create_archive_item(
2374: p_archive_item_id => l_archive_item_id,

Line 2371: hr_utility.trace('l value = '|| l_value);

2367:
2368: end if;
2369:
2370: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2371: hr_utility.trace('l value = '|| l_value);
2372:
2373: ff_archive_api.create_archive_item(
2374: p_archive_item_id => l_archive_item_id,
2375: p_user_entity_id => l_user_entity_id,

Line 2439: hr_utility.trace('per user entity id = '|| to_char(l_user_entity_id));

2435: l_user_entity_id := get_user_entity('ROE_PER_CITY');
2436:
2437: end if;
2438:
2439: hr_utility.trace('per user entity id = '|| to_char(l_user_entity_id));
2440: hr_utility.trace('per l value = '|| l_value);
2441:
2442: ff_archive_api.create_archive_item(
2443: p_archive_item_id => l_archive_item_id,

Line 2440: hr_utility.trace('per l value = '|| l_value);

2436:
2437: end if;
2438:
2439: hr_utility.trace('per user entity id = '|| to_char(l_user_entity_id));
2440: hr_utility.trace('per l value = '|| l_value);
2441:
2442: ff_archive_api.create_archive_item(
2443: p_archive_item_id => l_archive_item_id,
2444: p_user_entity_id => l_user_entity_id,

Line 2482: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2478: for cur_rec in 1..total_no_fields loop
2479:
2480: l_user_entity_id := get_user_entity(tab_user_entity_name(cur_rec));
2481:
2482: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2483: hr_utility.trace('l value = '|| l_value);
2484:
2485: ff_archive_api.create_archive_item(
2486: p_archive_item_id => l_archive_item_id,

Line 2483: hr_utility.trace('l value = '|| l_value);

2479:
2480: l_user_entity_id := get_user_entity(tab_user_entity_name(cur_rec));
2481:
2482: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2483: hr_utility.trace('l value = '|| l_value);
2484:
2485: ff_archive_api.create_archive_item(
2486: p_archive_item_id => l_archive_item_id,
2487: p_user_entity_id => l_user_entity_id,

Line 2509: hr_utility.trace('ROE_ASG_NUBER id = '|| to_char(l_user_entity_id));

2505: close cur_asg_number;
2506:
2507: l_user_entity_id := get_user_entity('ROE_ASG_NUMBER');
2508:
2509: hr_utility.trace('ROE_ASG_NUBER id = '|| to_char(l_user_entity_id));
2510: hr_utility.trace('ROE_ASG_NUBER value = '|| l_value);
2511:
2512: ff_archive_api.create_archive_item(
2513: p_archive_item_id => l_archive_item_id,

Line 2510: hr_utility.trace('ROE_ASG_NUBER value = '|| l_value);

2506:
2507: l_user_entity_id := get_user_entity('ROE_ASG_NUMBER');
2508:
2509: hr_utility.trace('ROE_ASG_NUBER id = '|| to_char(l_user_entity_id));
2510: hr_utility.trace('ROE_ASG_NUBER value = '|| l_value);
2511:
2512: ff_archive_api.create_archive_item(
2513: p_archive_item_id => l_archive_item_id,
2514: p_user_entity_id => l_user_entity_id,

Line 2528: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2524:
2525: l_value := cur_rec.business_number;
2526: l_user_entity_id := get_user_entity('ROE_CANADA_EMPLOYER_IDENTIFICATION_ORG_BUSINESS_NUMBER');
2527:
2528: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2529: hr_utility.trace('l value = '|| l_value);
2530:
2531: ff_archive_api.create_archive_item(
2532: p_archive_item_id => l_archive_item_id,

Line 2529: hr_utility.trace('l value = '|| l_value);

2525: l_value := cur_rec.business_number;
2526: l_user_entity_id := get_user_entity('ROE_CANADA_EMPLOYER_IDENTIFICATION_ORG_BUSINESS_NUMBER');
2527:
2528: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2529: hr_utility.trace('l value = '|| l_value);
2530:
2531: ff_archive_api.create_archive_item(
2532: p_archive_item_id => l_archive_item_id,
2533: p_user_entity_id => l_user_entity_id,

Line 2607: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2603: l_user_entity_id := get_user_entity('ROE_CONTACT_PER_LAST_NAME');
2604:
2605: end if;
2606:
2607: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2608: hr_utility.trace('l value = '|| l_value);
2609:
2610: ff_archive_api.create_archive_item(
2611: p_archive_item_id => l_archive_item_id,

Line 2608: hr_utility.trace('l value = '|| l_value);

2604:
2605: end if;
2606:
2607: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2608: hr_utility.trace('l value = '|| l_value);
2609:
2610: ff_archive_api.create_archive_item(
2611: p_archive_item_id => l_archive_item_id,
2612: p_user_entity_id => l_user_entity_id,

Line 2628: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2624:
2625: l_value := cur_rec.name;
2626: l_user_entity_id := get_user_entity('ROE_ASG_JOB');
2627:
2628: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2629: hr_utility.trace('l value = '|| l_value);
2630:
2631: ff_archive_api.create_archive_item(
2632: p_archive_item_id => l_archive_item_id,

Line 2629: hr_utility.trace('l value = '|| l_value);

2625: l_value := cur_rec.name;
2626: l_user_entity_id := get_user_entity('ROE_ASG_JOB');
2627:
2628: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2629: hr_utility.trace('l value = '|| l_value);
2630:
2631: ff_archive_api.create_archive_item(
2632: p_archive_item_id => l_archive_item_id,
2633: p_user_entity_id => l_user_entity_id,

Line 2659: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '

2655: close cur_final_pay_period_date;
2656:
2657: l_user_entity_id := get_user_entity('ROE_FINAL_PAY_PERIOD_ENDING_DATE');
2658:
2659: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2660: || to_char(l_user_entity_id));
2661: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2662: hr_utility.trace('l_final_pay_period_start_date = ' ||
2663: to_char(l_final_pay_period_start_date));

Line 2661: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);

2657: l_user_entity_id := get_user_entity('ROE_FINAL_PAY_PERIOD_ENDING_DATE');
2658:
2659: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2660: || to_char(l_user_entity_id));
2661: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2662: hr_utility.trace('l_final_pay_period_start_date = ' ||
2663: to_char(l_final_pay_period_start_date));
2664:
2665: ff_archive_api.create_archive_item(

Line 2662: hr_utility.trace('l_final_pay_period_start_date = ' ||

2658:
2659: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2660: || to_char(l_user_entity_id));
2661: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2662: hr_utility.trace('l_final_pay_period_start_date = ' ||
2663: to_char(l_final_pay_period_start_date));
2664:
2665: ff_archive_api.create_archive_item(
2666: p_archive_item_id => l_archive_item_id,

Line 2697: hr_utility.trace('l_prev_roe_date is not null ' ||

2693: -- the hire date will be the start date.
2694:
2695: if l_prev_roe_date is not null then
2696:
2697: hr_utility.trace('l_prev_roe_date is not null ' ||
2698: to_char(l_prev_roe_date,'dd-mon-yy'));
2699:
2700: -- if the prev ROE was used for LOA then the expected date
2701: -- of recall archived on the prev run would be the first day

Line 2767: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));

2763: end if;
2764:
2765: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2766:
2767: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2768: hr_utility.trace('First day worked = '|| l_value);
2769:
2770: ff_archive_api.create_archive_item(
2771: p_archive_item_id => l_archive_item_id,

Line 2768: hr_utility.trace('First day worked = '|| l_value);

2764:
2765: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2766:
2767: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2768: hr_utility.trace('First day worked = '|| l_value);
2769:
2770: ff_archive_api.create_archive_item(
2771: p_archive_item_id => l_archive_item_id,
2772: p_user_entity_id => l_user_entity_id,

Line 2782: hr_utility.trace('first day worked in hire date');

2778: p_some_warning => l_some_warning);
2779:
2780: else
2781:
2782: hr_utility.trace('first day worked in hire date');
2783:
2784: for cur_rec in cur_employee_hire_date loop
2785:
2786: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');

Line 2789: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));

2785:
2786: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');
2787: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2788:
2789: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2790: hr_utility.trace('First day worked = '|| l_value);
2791:
2792: ff_archive_api.create_archive_item(
2793: p_archive_item_id => l_archive_item_id,

Line 2790: hr_utility.trace('First day worked = '|| l_value);

2786: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');
2787: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2788:
2789: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2790: hr_utility.trace('First day worked = '|| l_value);
2791:
2792: ff_archive_api.create_archive_item(
2793: p_archive_item_id => l_archive_item_id,
2794: p_user_entity_id => l_user_entity_id,

Line 2817: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '|| to_char(l_user_entity_id));

2813:
2814: l_value := to_char(l_effective_date,'YYYY/MM/DD HH24:MI:SS');
2815: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2816:
2817: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '|| to_char(l_user_entity_id));
2818: hr_utility.trace('ROE_PAY_EARNED_END_DATE value = '|| l_value);
2819:
2820: ff_archive_api.create_archive_item(
2821: p_archive_item_id => l_archive_item_id,

Line 2818: hr_utility.trace('ROE_PAY_EARNED_END_DATE value = '|| l_value);

2814: l_value := to_char(l_effective_date,'YYYY/MM/DD HH24:MI:SS');
2815: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2816:
2817: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '|| to_char(l_user_entity_id));
2818: hr_utility.trace('ROE_PAY_EARNED_END_DATE value = '|| l_value);
2819:
2820: ff_archive_api.create_archive_item(
2821: p_archive_item_id => l_archive_item_id,
2822: p_user_entity_id => l_user_entity_id,

Line 2839: hr_utility.trace('recall date is less than final period ending date');

2835: -- is the day b4 LOA start date.
2836:
2837: if l_recall_date <= l_final_pay_period_end_date then
2838:
2839: hr_utility.trace('recall date is less than final period ending date');
2840: l_value := to_char(l_final_pay_period_end_date,'YYYY/MM/DD HH24:MI:SS');
2841:
2842: else
2843:

Line 2844: hr_utility.trace('recall date is greater than final period ending date');

2840: l_value := to_char(l_final_pay_period_end_date,'YYYY/MM/DD HH24:MI:SS');
2841:
2842: else
2843:
2844: hr_utility.trace('recall date is greater than final period ending date');
2845: l_last_day_paid1 := get_working_date(l_business_group_id,
2846: l_assignment_id,
2847: l_last_day_paid,
2848: 'P');

Line 2856: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '||

2852: end if;
2853:
2854: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2855:
2856: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '||
2857: to_char(l_user_entity_id));
2858: hr_utility.trace('ROE_PAY_EARNED_END_DATE = '|| l_value);
2859:
2860: ff_archive_api.create_archive_item(

Line 2858: hr_utility.trace('ROE_PAY_EARNED_END_DATE = '|| l_value);

2854: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2855:
2856: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '||
2857: to_char(l_user_entity_id));
2858: hr_utility.trace('ROE_PAY_EARNED_END_DATE = '|| l_value);
2859:
2860: ff_archive_api.create_archive_item(
2861: p_archive_item_id => l_archive_item_id,
2862: p_user_entity_id => l_user_entity_id,

Line 2912: hr_utility.trace('l_recall_date ' ||

2908: l_recall_date1 := l_recall_date;
2909:
2910: end if;
2911:
2912: hr_utility.trace('l_recall_date ' ||
2913: to_char(l_recall_date1,'dd-mon-yy'));
2914: l_value := to_char(l_recall_date1,'YYYY/MM/DD HH24:MI:SS');
2915: l_user_entity_id := get_user_entity('ROE_EXPECTED_DATE_OF_RECALL');
2916:

Line 2946: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

2942: l_user_entity_id := get_user_entity('ROE_UNKNOWN_NOT_RETURNING');
2943:
2944: end if;
2945:
2946: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2947: hr_utility.trace('l value = '|| l_value);
2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));

Line 2947: hr_utility.trace('l value = '|| l_value);

2943:
2944: end if;
2945:
2946: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2947: hr_utility.trace('l value = '|| l_value);
2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));

Line 2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));

2945:
2946: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2947: hr_utility.trace('l value = '|| l_value);
2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);

Line 2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));

2946: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2947: hr_utility.trace('l value = '|| l_value);
2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);
2954: hr_utility.trace('l comment = '|| l_roe_comment);

Line 2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));

2947: hr_utility.trace('l value = '|| l_value);
2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);
2954: hr_utility.trace('l comment = '|| l_roe_comment);
2955:

Line 2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));

2948:
2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);
2954: hr_utility.trace('l comment = '|| l_roe_comment);
2955:
2956:

Line 2953: hr_utility.trace('l reason = '|| l_roe_reason);

2949: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);
2954: hr_utility.trace('l comment = '|| l_roe_comment);
2955:
2956:
2957: ff_archive_api.create_archive_item(

Line 2954: hr_utility.trace('l comment = '|| l_roe_comment);

2950: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2951: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2952: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2953: hr_utility.trace('l reason = '|| l_roe_reason);
2954: hr_utility.trace('l comment = '|| l_roe_comment);
2955:
2956:
2957: ff_archive_api.create_archive_item(
2958: p_archive_item_id => l_archive_item_id,

Line 2977: hr_utility.trace('l_tax_group_id = ' || l_tax_group_id);

2973: fetch cur_tax_group
2974: into l_tax_group_id;
2975: close cur_tax_group;
2976:
2977: hr_utility.trace('l_tax_group_id = ' || l_tax_group_id);
2978: hr_utility.trace('l_t4a_gre = ' || l_t4a_gre);
2979:
2980: l_value := '0';
2981:

Line 2978: hr_utility.trace('l_t4a_gre = ' || l_t4a_gre);

2974: into l_tax_group_id;
2975: close cur_tax_group;
2976:
2977: hr_utility.trace('l_tax_group_id = ' || l_tax_group_id);
2978: hr_utility.trace('l_t4a_gre = ' || l_t4a_gre);
2979:
2980: l_value := '0';
2981:
2982: l_user_entity_id := get_user_entity('ROE_BOX_17A');

Line 2986: hr_utility.trace('Archive Data: Balance Feed Exists for ROE Vacation Pay');

2982: l_user_entity_id := get_user_entity('ROE_BOX_17A');
2983:
2984: if balance_feed_exists('ROE Vacation Pay',l_business_group_id) then
2985:
2986: hr_utility.trace('Archive Data: Balance Feed Exists for ROE Vacation Pay');
2987:
2988: l_defined_balance_id := get_defined_balance_id(
2989: 'ROE Vacation Pay',
2990: 'Assignment within Government Reporting Entity Period to Date',

Line 2993: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));

2989: 'ROE Vacation Pay',
2990: 'Assignment within Government Reporting Entity Period to Date',
2991: l_business_group_id);
2992:
2993: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2994: for gres in cur_17_gres(l_tax_group_id) loop
2995:
2996: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2997: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));

Line 2996: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));

2992:
2993: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2994: for gres in cur_17_gres(l_tax_group_id) loop
2995:
2996: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2997: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2998: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2999:
3000: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);

Line 2997: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));

2993: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2994: for gres in cur_17_gres(l_tax_group_id) loop
2995:
2996: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2997: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2998: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2999:
3000: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
3001:

Line 2998: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));

2994: for gres in cur_17_gres(l_tax_group_id) loop
2995:
2996: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2997: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2998: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2999:
3000: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
3001:
3002: open cur_latest_aaid(l_final_pay_period_start_date,

Line 3013: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));

3009: else
3010: close cur_latest_aaid;
3011: end if;
3012:
3013: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
3014:
3015: if l_latest_aaid is not null then
3016: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3017: l_latest_aaid),0);

Line 3020: hr_utility.trace('Vacation Paid l_value = ' || l_value);

3016: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3017: l_latest_aaid),0);
3018: end if;
3019:
3020: hr_utility.trace('Vacation Paid l_value = ' || l_value);
3021: hr_utility.trace('l_final_pay_period_end_date = ' ||
3022: to_char(l_final_pay_period_end_date));
3023:
3024: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);

Line 3021: hr_utility.trace('l_final_pay_period_end_date = ' ||

3017: l_latest_aaid),0);
3018: end if;
3019:
3020: hr_utility.trace('Vacation Paid l_value = ' || l_value);
3021: hr_utility.trace('l_final_pay_period_end_date = ' ||
3022: to_char(l_final_pay_period_end_date));
3023:
3024: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);
3025: fetch cur_final_pay_period_date

Line 3047: hr_utility.trace('Box 17A l_latest_aaid_after_term = ' ||

3043: else
3044: close cur_latest_aaid;
3045: end if;
3046:
3047: hr_utility.trace('Box 17A l_latest_aaid_after_term = ' ||
3048: to_char(l_latest_aaid_after_term));
3049:
3050: if l_latest_aaid_after_term is not null then
3051: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,

Line 3055: hr_utility.trace('ROE_BOX_17A = ' || l_value);

3051: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3052: l_latest_aaid_after_term),0);
3053: end if;
3054:
3055: hr_utility.trace('ROE_BOX_17A = ' || l_value);
3056:
3057: end loop; -- cur_17_gres
3058:
3059: end if; -- End if balance_feed_exists

Line 3082: hr_utility.trace('l_final_pay_period_start_date = ' ||

3078: -- l_latest_aaid will have the latest assignment_action_id
3079: -- if box 17A is populated otherwise it will have 0 as this
3080: -- is initialized with 0.
3081:
3082: hr_utility.trace('l_final_pay_period_start_date = ' ||
3083: to_char(l_final_pay_period_start_date));
3084:
3085:
3086: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));

Line 3086: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));

3082: hr_utility.trace('l_final_pay_period_start_date = ' ||
3083: to_char(l_final_pay_period_start_date));
3084:
3085:
3086: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));
3087:
3088: for tot_no_bal in 1..12 loop
3089:
3090: l_value := '0';

Line 3100: hr_utility.trace('Box 17C l_defined_balance_id = ' ||

3096: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3097: 'Assignment within Government Reporting Entity Period to Date',
3098: l_business_group_id);
3099:
3100: hr_utility.trace('Box 17C l_defined_balance_id = ' ||
3101: to_char(l_defined_balance_id));
3102:
3103: for gres in cur_17_gres(l_tax_group_id) loop
3104:

Line 3118: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));

3114: else
3115: close cur_latest_aaid;
3116: end if;
3117:
3118: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
3119:
3120: if l_latest_aaid is not null then
3121: l_value := l_value +
3122: NVL(pay_balance_pkg.get_value(l_defined_balance_id,

Line 3126: hr_utility.trace(

3122: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3123: l_latest_aaid),0);
3124: end if;
3125:
3126: hr_utility.trace(
3127: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3128: || l_value);
3129:
3130: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||

Line 3130: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||

3126: hr_utility.trace(
3127: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3128: || l_value);
3129:
3130: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||
3131: to_char(l_final_pay_period_end_date));
3132:
3133: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);
3134: fetch cur_final_pay_period_date

Line 3145: hr_utility.trace('Box 17C l_period_end_date_after_term = ' ||

3141: end if;
3142:
3143: close cur_final_pay_period_date;
3144:
3145: hr_utility.trace('Box 17C l_period_end_date_after_term = ' ||
3146: to_char(l_period_end_date_after_term));
3147:
3148: open cur_latest_aaid(l_period_start_date_after_term,
3149: l_period_end_date_after_term,

Line 3159: hr_utility.trace('Box 17C l_latest_aaid_after_term = ' ||

3155: else
3156: close cur_latest_aaid;
3157: end if;
3158:
3159: hr_utility.trace('Box 17C l_latest_aaid_after_term = ' ||
3160: to_char(l_latest_aaid_after_term));
3161:
3162: if l_latest_aaid_after_term is not null then
3163: l_value := l_value +

Line 3168: hr_utility.trace('Box 17C l_value = ' || l_value);

3164: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3165: l_latest_aaid_after_term),0);
3166: end if;
3167:
3168: hr_utility.trace('Box 17C l_value = ' || l_value);
3169:
3170: end loop; -- cur_17_gres
3171:
3172: -- We will archive only the first three highest Balances

Line 3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);

3198:
3199: end loop; -- End loop Balances
3200:
3201:
3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);

Line 3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));

3199: end loop; -- End loop Balances
3200:
3201:
3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));

Line 3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);

3200:
3201:
3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3208:

Line 3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));

3201:
3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3208:
3209: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';

Line 3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);

3202: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3208:
3209: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';
3210: tab_user_entity_name(2) := 'ROE_BOX_17C_AMOUNT1';

Line 3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));

3203: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3204: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3205: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3206: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3207: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3208:
3209: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';
3210: tab_user_entity_name(2) := 'ROE_BOX_17C_AMOUNT1';
3211: tab_user_entity_name(3) := 'ROE_BOX_17C_DESC2';

Line 3274: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

3270:
3271: l_value := l_total_insurable;
3272: l_user_entity_id := get_user_entity('ROE_TOTAL_INSURABLE_HOURS');
3273:
3274: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3275: hr_utility.trace('l value = '|| l_value);
3276:
3277: ff_archive_api.create_archive_item(
3278: p_archive_item_id => l_archive_item_id,

Line 3275: hr_utility.trace('l value = '|| l_value);

3271: l_value := l_total_insurable;
3272: l_user_entity_id := get_user_entity('ROE_TOTAL_INSURABLE_HOURS');
3273:
3274: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3275: hr_utility.trace('l value = '|| l_value);
3276:
3277: ff_archive_api.create_archive_item(
3278: p_archive_item_id => l_archive_item_id,
3279: p_user_entity_id => l_user_entity_id,

Line 3290: hr_utility.trace('End of archiving EI Hours');

3286:
3287:
3288: -- EI Hours - End
3289:
3290: hr_utility.trace('End of archiving EI Hours');
3291:
3292: -- EI Earnings - Begin
3293:
3294: l_total_type := 'EI Earnings';

Line 3311: hr_utility.trace('ret = ' || ret);

3307: p_period_type => l_period_type,
3308: p_term_or_abs_flag => l_term_or_abs_flag
3309: );
3310:
3311: hr_utility.trace('ret = ' || ret);
3312:
3313: tab_user_entity_name(1) := 'ROE_INSURABLE_EARNING_1';
3314: tab_user_entity_name(2) := 'ROE_INSURABLE_EARNING_2';
3315: tab_user_entity_name(3) := 'ROE_INSURABLE_EARNING_3';

Line 3386: hr_utility.trace('15B');

3382: else
3383:
3384: /* Commented by ssmukher for Bug 4510534
3385: if ret = 'BOX15B' then
3386: hr_utility.trace('15B');
3387: l_value := '0';
3388: else
3389: hr_utility.trace('BOX15C');
3390: l_value := tab_period_total(cur_field);

Line 3389: hr_utility.trace('BOX15C');

3385: if ret = 'BOX15B' then
3386: hr_utility.trace('15B');
3387: l_value := '0';
3388: else
3389: hr_utility.trace('BOX15C');
3390: l_value := tab_period_total(cur_field);
3391: end if;
3392: */
3393: l_value := tab_period_total(cur_field);

Line 3398: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));

3394: l_user_entity_id := get_user_entity(tab_user_entity_name(cur_field));
3395:
3396: end if;
3397:
3398: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3399: hr_utility.trace('l value = '|| l_value);
3400:
3401: ff_archive_api.create_archive_item(
3402: p_archive_item_id => l_archive_item_id,

Line 3399: hr_utility.trace('l value = '|| l_value);

3395:
3396: end if;
3397:
3398: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3399: hr_utility.trace('l value = '|| l_value);
3400:
3401: ff_archive_api.create_archive_item(
3402: p_archive_item_id => l_archive_item_id,
3403: p_user_entity_id => l_user_entity_id,

Line 3413: hr_utility.trace('End of archiving EI Earnings');

3409: p_some_warning => l_some_warning);
3410:
3411: end loop;
3412:
3413: hr_utility.trace('End of archiving EI Earnings');
3414:
3415: -- As all the archiving is done now we lock
3416: -- the mag assignment_action_id of the l_assignment_amend
3417: -- with the new assignment-action_id

Line 3457: hr_utility.raise_error;

3453: END IF;
3454:
3455: ELSE
3456:
3457: hr_utility.raise_error;
3458:
3459: END IF; -- check_retry_amend has failed or not.
3460:
3461: end;

Line 3525: hr_utility.trace('l_assignment_set_id = ' || to_char(l_assignment_set_id));

3521:
3522: l_assignment_set_id := asg_set_exists(p_assignment_set_name,
3523: p_business_group_id);
3524:
3525: hr_utility.trace('l_assignment_set_id = ' || to_char(l_assignment_set_id));
3526:
3527: IF l_assignment_set_id <> -1 THEN
3528:
3529: OPEN c_already_in_set;

Line 3536: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||

3532: IF c_already_in_set%NOTFOUND THEN
3533:
3534: CLOSE c_already_in_set;
3535:
3536: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||
3537: ' does not exist in the assignment set');
3538:
3539: hr_assignment_set_amds_pkg.insert_row(
3540: p_rowid => l_rowid

Line 3545: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||

3541: ,p_assignment_id => p_assignment_id
3542: ,p_assignment_set_id => l_assignment_set_id
3543: ,p_include_or_exclude => 'I');
3544: ELSE
3545: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||
3546: ' already exists in the assignment set');
3547: CLOSE c_already_in_set;
3548:
3549: END IF;

Line 3611: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');

3607: l_dummy VARCHAR2(1);
3608: --
3609: begin
3610: --
3611: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');
3612:
3613: OPEN cur_asg_set_id;
3614: FETCH cur_asg_set_id
3615: INTO l_assignment_set_id;

Line 3619: hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');

3615: INTO l_assignment_set_id;
3616:
3617: IF cur_asg_set_id%FOUND then
3618:
3619: hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');
3620: hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '
3621: || to_char(l_assignment_set_id));
3622:
3623: CLOSE cur_asg_set_id;

Line 3620: hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '

3616:
3617: IF cur_asg_set_id%FOUND then
3618:
3619: hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');
3620: hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '
3621: || to_char(l_assignment_set_id));
3622:
3623: CLOSE cur_asg_set_id;
3624: OPEN c_already_in_set;

Line 3630: hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');

3626: INTO l_dummy;
3627:
3628: IF c_already_in_set%FOUND THEN
3629:
3630: hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');
3631: CLOSE c_already_in_set;
3632:
3633: DELETE FROM
3634: hr_assignment_set_amendments

Line 3649: hr_utility.trace('In delete_asg_set_records cur_last_row = ' ||

3645: INTO l_dummy;
3646:
3647: IF cur_last_row%ROWCOUNT = 0 then
3648:
3649: hr_utility.trace('In delete_asg_set_records cur_last_row = ' ||
3650: to_char(cur_last_row%ROWCOUNT));
3651:
3652: CLOSE cur_last_row;
3653: