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 145: -- the hr_utility.trace msg for

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

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

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

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

240: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;
241: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
242:
243: begin
244: -- hr_utility.trace_on(null,'ROE');
245:
246: open cur_payroll_actions;
247: fetch cur_payroll_actions into
248: l_legislative_parameters;

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

247: fetch cur_payroll_actions into
248: l_legislative_parameters;
249: close cur_payroll_actions;
250:
251: hr_utility.trace('l_legislative_parameters= ' || l_legislative_parameters);
252: l_person_id :=
253: pycadar_pkg.get_parameter('PERSON_ID',l_legislative_parameters);
254: l_assignment_set_id :=
255: pycadar_pkg.get_parameter('ASSIGNMENT_SET_ID',l_legislative_parameters);

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

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

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

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

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

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

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

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

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

429: c_ws_tab_name,
430: l_user_column_name,
431: v_curr_day));
432:
433: hr_utility.trace('l_hour = ' || to_char(l_hour));
434:
435: if l_hour <> 0 then
436: exit;
437: else

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

443: end if;
444:
445: end loop;
446:
447: hr_utility.trace('l working date = ' || to_char(l_working_date));
448: return l_working_date;
449:
450: end;
451:

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

479: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
480:
481: begin
482:
483: hr_utility.trace('Function get_defined_balance_id starts here !');
484:
485: open cur_get_def_bal_id;
486: fetch cur_get_def_bal_id
487: into l_def_balance_id;

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

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

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

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

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

526: dummy varchar2(1);
527:
528: begin
529:
530: hr_utility.trace('Function balance_feed_exists');
531: hr_utility.trace('balance_feed_exists p_balance_name = ' || p_balance_name);
532:
533: OPEN cur_bal_feed_exists;
534: FETCH cur_bal_feed_exists

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

527:
528: begin
529:
530: hr_utility.trace('Function balance_feed_exists');
531: hr_utility.trace('balance_feed_exists p_balance_name = ' || p_balance_name);
532:
533: OPEN cur_bal_feed_exists;
534: FETCH cur_bal_feed_exists
535: INTO dummy;

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

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

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

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

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

595: l_roe_comment varchar2(150);
596: l_effective_date date;
597:
598: begin
599: hr_utility.trace('before terminate'||to_char(p_effective_date));
600: open cur_terminate;
601:
602: fetch cur_terminate
603: into l_termination_date,

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

610: cur_terminate%notfound then
611:
612: close cur_terminate;
613:
614: hr_utility.trace('Cur terminate not found');
615:
616: l_effective_date := get_working_date(p_business_group_id,
617: p_asg_id,
618: p_effective_date,

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

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

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

639: return p_effective_date;
640:
641: else
642:
643: hr_utility.trace('Cur absence found');
644: close cur_absence;
645: p_recall_date := l_recall_date;
646: p_roe_reason := l_roe_reason;
647: p_roe_comment := l_roe_comment;

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

646: p_roe_reason := l_roe_reason;
647: p_roe_comment := l_roe_comment;
648: p_term_or_abs_flag := 'Y';
649: p_term_or_abs := 'A';
650: hr_utility.trace('l_absence_date: '||to_char(l_absence_date));
651:
652: return l_absence_date;
653:
654: end if;

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

659: p_roe_reason := l_roe_reason;
660: p_roe_comment := l_roe_comment;
661: p_term_or_abs_flag := 'Y';
662: p_term_or_abs := 'T';
663: hr_utility.trace('.....in terminate...else..');
664: close cur_terminate;
665: return l_termination_date;
666:
667: end if;

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

804: FETCH cur_bg_id
805: INTO l_bg_id;
806: CLOSE cur_bg_id;
807:
808: hr_utility.trace('Archive initialization');
809: pay_ca_roe_ei_pkg.populate_element_table(l_bg_id);
810: populate_box17c_bal_table;
811:
812: END;

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

1130: open cur_ppf;
1131: fetch cur_ppf into l_full_name;
1132: close cur_ppf;
1133:
1134: hr_utility.set_location('check_retry_amend' , 5);
1135: open cur_retry;
1136: fetch cur_retry into l_context1;
1137:
1138: if (cur_retry%FOUND) then

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

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

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

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

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

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

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

1150: close cur_amend;
1151:
1152: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1153:
1154: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1155: hr_utility.set_message_token('PERSON',l_full_name);
1156: --hr_utility.raise_error;
1157: RETURN FALSE;
1158: else

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

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

Line 1156: --hr_utility.raise_error;

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

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

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

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

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

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

1162: -- Retry Issue
1163:
1164: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1165: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1166: hr_utility.set_message_token('PERSON',l_full_name);
1167: --hr_utility.raise_error;
1168: RETURN FALSE;
1169:
1170: end if;

Line 1167: --hr_utility.raise_error;

1163:
1164: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1165: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1166: hr_utility.set_message_token('PERSON',l_full_name);
1167: --hr_utility.raise_error;
1168: RETURN FALSE;
1169:
1170: end if;
1171:

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

1171:
1172: else
1173:
1174: close cur_retry;
1175: hr_utility.set_location('pay_ca_archive.cur_retry', 10);
1176: RETURN TRUE;
1177:
1178: end if;
1179:

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

1182: end; -- End check_retry_amend
1183:
1184: begin
1185:
1186: hr_utility.set_location('Package pay_ca_archive...action creation',1);
1187:
1188: open cur_payroll_actions;
1189: fetch cur_payroll_actions
1190: into

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

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

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

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

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

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

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

1203:
1204: hr_utility.trace('l_legislative_parameters '|| l_legislative_parameters);
1205: hr_utility.trace('Person ID = '|| to_char(l_person_id));
1206: hr_utility.trace('ASSIGNMENT_SET_ID= ' || to_char(l_assignment_set_id));
1207: hr_utility.trace('AMEND ASSIGNMENT ACTION ID= ' ||
1208: to_char(l_assignment_amend));
1209:
1210: if l_assignment_set_id is null then
1211:

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

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

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

1237: l_roe_reason,
1238: l_roe_comment,
1239: l_term_or_abs_flag,
1240: l_term_or_abs);
1241: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1242:
1243: l_roe_date := l_effective_date;
1244:
1245: l_prev_roe_date := get_balance_start_date(l_person_id,

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

1251: open cur_asg_action_id;
1252: fetch cur_asg_action_id into l_lockingactid;
1253: if cur_asg_action_id%NOTFOUND then
1254: close cur_asg_action_id;
1255: hr_utility.trace('Locking action id not found');
1256: else
1257: close cur_asg_action_id;
1258: hr_utility.trace('Locking action id found');
1259: end if;

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

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

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

1272:
1273: l_user_entity_amend(5) := get_user_entity('ROE_DATE');
1274: l_value_amend(5) := archive_value(l_assignment_amend,'ROE_DATE');
1275:
1276: hr_utility.trace('l_value_amend(1)'||l_value_amend(1));
1277: hr_utility.trace('l_value_amend(2)'||l_value_amend(2));
1278: hr_utility.trace('l_value_amend(3)'||l_value_amend(3));
1279:
1280: hr_nonrun_asact.insact(l_lockingactid,

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

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

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

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

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

1323: ELSE
1324: l_start_date := l_effective_date - 400;
1325: END IF;
1326:
1327: hr_utility.trace('l_person_id = '|| l_person_id);
1328: hr_utility.trace('l_start_date = '|| l_start_date);
1329: hr_utility.trace('l_effective_date = '|| l_effective_date);
1330:
1331: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop

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

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

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

1325: END IF;
1326:
1327: hr_utility.trace('l_person_id = '|| l_person_id);
1328: hr_utility.trace('l_start_date = '|| l_start_date);
1329: hr_utility.trace('l_effective_date = '|| l_effective_date);
1330:
1331: for i in cur_paf(l_person_id, l_effective_date, l_start_date) loop
1332:
1333: hr_utility.trace('I.assignment ID = '|| to_char(i.assignment_id));

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

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

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

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

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

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

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

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

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

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

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

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

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

1359: open cur_asg_action_id;
1360: fetch cur_asg_action_id into l_lockingactid;
1361: if cur_asg_action_id%NOTFOUND then
1362: close cur_asg_action_id;
1363: hr_utility.trace('Locking action id not found');
1364: else
1365: close cur_asg_action_id;
1366: hr_utility.trace('Locking action id found');
1367: end if;

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

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

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

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

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

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

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

1459: last_period_of_service (l_end_date,
1460: l_person_id,
1461: l_business_group_id);
1462:
1463: hr_utility.trace('l_date_start = ' ||to_char(l_date_start)); */
1464:
1465: l_effective_date := get_date(l_person_id,
1466: l_assignment_id,
1467: l_business_group_id,

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

1470: l_roe_reason,
1471: l_roe_comment,
1472: l_term_or_abs_flag,
1473: l_term_or_abs);
1474: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1475: hr_utility.trace('l_end_date: '||to_char(l_end_date));
1476:
1477: l_roe_date := l_effective_date;
1478:

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

1471: l_roe_comment,
1472: l_term_or_abs_flag,
1473: l_term_or_abs);
1474: hr_utility.trace('l_effective_date: '||to_char(l_effective_date));
1475: hr_utility.trace('l_end_date: '||to_char(l_end_date));
1476:
1477: l_roe_date := l_effective_date;
1478:
1479: l_prev_roe_date := get_balance_start_date(l_person_id,

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

1502: ELSE
1503: l_start_date := l_effective_date - 400;
1504: END IF;
1505:
1506: hr_utility.trace('l_person_id = '|| l_person_id);
1507: hr_utility.trace('l_start_date = '|| l_start_date);
1508: hr_utility.trace('l_effective_date = '|| l_effective_date);
1509:
1510: if l_term_or_abs in ('A','T') then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1539: open cur_asg_action_id;
1540: fetch cur_asg_action_id into l_lockingactid;
1541: if cur_asg_action_id%NOTFOUND then
1542: close cur_asg_action_id;
1543: hr_utility.trace('Locking action id not found');
1544: else
1545: close cur_asg_action_id;
1546: hr_utility.trace('Locking action id found');
1547: end if;

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

1542: close cur_asg_action_id;
1543: hr_utility.trace('Locking action id not found');
1544: else
1545: close cur_asg_action_id;
1546: hr_utility.trace('Locking action id found');
1547: end if;
1548:
1549:
1550: hr_nonrun_asact.insact(l_lockingactid,i.assignment_id,

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

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

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

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

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

1626: end if;
1627:
1628: end loop; -- cur_asg_set_person_id
1629:
1630: hr_utility.trace('Action Creation: assignment set is passed');
1631:
1632: end if; -- End if (Assignment set)
1633: end;
1634:

Line 1635: hr_utility.trace_off;

1631:
1632: end if; -- End if (Assignment set)
1633: end;
1634:
1635: hr_utility.trace_off;
1636:
1637: end action_creation;
1638:
1639:

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

1672: l_temp_date date;
1673:
1674: begin
1675:
1676: hr_utility.trace('func_expected_date_of_return');
1677:
1678: l_edor_uid := get_user_entity('ROE_EXPECTED_DATE_OF_RECALL');
1679: l_payroll_uid := get_user_entity('ROE_PAYROLL_ID');
1680:

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

1682: fetch cur_edor
1683: into l_value;
1684: close cur_edor;
1685:
1686: hr_utility.trace('func_expected_date_of_return l_value = ' || l_value);
1687: l_temp_date := fnd_date.canonical_to_date(l_value);
1688:
1689: return l_temp_date;
1690:

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

2165: l_serial_number pay_assignment_actions.serial_number%TYPE;
2166:
2167: begin
2168:
2169: hr_utility.trace('Archive data');
2170:
2171: open cur_archive_info;
2172: fetch cur_archive_info
2173: into l_assignment_id,

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

2260: total_no_fields := 5;
2261:
2262: for cur_rec in cur_employee_info loop
2263:
2264: hr_utility.trace('cur_rec.first_name = '|| cur_rec.first_name);
2265: hr_utility.trace('cur_rec.middle_name = '|| cur_rec.middle_names);
2266: hr_utility.trace('cur_rec.last_name = '|| cur_rec.last_name);
2267:
2268: for cur_field in 1..total_no_fields loop

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2501: close cur_asg_number;
2502:
2503: l_user_entity_id := get_user_entity('ROE_ASG_NUMBER');
2504:
2505: hr_utility.trace('ROE_ASG_NUBER id = '|| to_char(l_user_entity_id));
2506: hr_utility.trace('ROE_ASG_NUBER value = '|| l_value);
2507:
2508: ff_archive_api.create_archive_item(
2509: p_archive_item_id => l_archive_item_id,

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

2502:
2503: l_user_entity_id := get_user_entity('ROE_ASG_NUMBER');
2504:
2505: hr_utility.trace('ROE_ASG_NUBER id = '|| to_char(l_user_entity_id));
2506: hr_utility.trace('ROE_ASG_NUBER value = '|| l_value);
2507:
2508: ff_archive_api.create_archive_item(
2509: p_archive_item_id => l_archive_item_id,
2510: p_user_entity_id => l_user_entity_id,

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

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

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

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

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

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

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

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

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

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

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

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

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

2651: close cur_final_pay_period_date;
2652:
2653: l_user_entity_id := get_user_entity('ROE_FINAL_PAY_PERIOD_ENDING_DATE');
2654:
2655: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2656: || to_char(l_user_entity_id));
2657: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2658: hr_utility.trace('l_final_pay_period_start_date = ' ||
2659: to_char(l_final_pay_period_start_date));

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

2653: l_user_entity_id := get_user_entity('ROE_FINAL_PAY_PERIOD_ENDING_DATE');
2654:
2655: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2656: || to_char(l_user_entity_id));
2657: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2658: hr_utility.trace('l_final_pay_period_start_date = ' ||
2659: to_char(l_final_pay_period_start_date));
2660:
2661: ff_archive_api.create_archive_item(

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

2654:
2655: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE entity id = '
2656: || to_char(l_user_entity_id));
2657: hr_utility.trace('ROE_FINAL_PAY_PERIOD_ENDING_DATE value = '|| l_value);
2658: hr_utility.trace('l_final_pay_period_start_date = ' ||
2659: to_char(l_final_pay_period_start_date));
2660:
2661: ff_archive_api.create_archive_item(
2662: p_archive_item_id => l_archive_item_id,

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

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

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

2742: end if;
2743:
2744: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2745:
2746: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2747: hr_utility.trace('First day worked = '|| l_value);
2748:
2749: ff_archive_api.create_archive_item(
2750: p_archive_item_id => l_archive_item_id,

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

2743:
2744: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2745:
2746: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2747: hr_utility.trace('First day worked = '|| l_value);
2748:
2749: ff_archive_api.create_archive_item(
2750: p_archive_item_id => l_archive_item_id,
2751: p_user_entity_id => l_user_entity_id,

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

2757: p_some_warning => l_some_warning);
2758:
2759: else
2760:
2761: hr_utility.trace('first day worked in hire date');
2762:
2763: for cur_rec in cur_employee_hire_date loop
2764:
2765: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');

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

2764:
2765: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');
2766: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2767:
2768: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2769: hr_utility.trace('First day worked = '|| l_value);
2770:
2771: ff_archive_api.create_archive_item(
2772: p_archive_item_id => l_archive_item_id,

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

2765: l_value := to_char(cur_rec.hire_date,'YYYY/MM/DD HH24:MI:SS');
2766: l_user_entity_id := get_user_entity('ROE_EMP_PER_HIRE_DATE');
2767:
2768: hr_utility.trace('ROE_EMP_PER_HIRE_DATE = '|| to_char(l_user_entity_id));
2769: hr_utility.trace('First day worked = '|| l_value);
2770:
2771: ff_archive_api.create_archive_item(
2772: p_archive_item_id => l_archive_item_id,
2773: p_user_entity_id => l_user_entity_id,

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

2792:
2793: l_value := to_char(l_effective_date,'YYYY/MM/DD HH24:MI:SS');
2794: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2795:
2796: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '|| to_char(l_user_entity_id));
2797: hr_utility.trace('ROE_PAY_EARNED_END_DATE value = '|| l_value);
2798:
2799: ff_archive_api.create_archive_item(
2800: p_archive_item_id => l_archive_item_id,

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

2793: l_value := to_char(l_effective_date,'YYYY/MM/DD HH24:MI:SS');
2794: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2795:
2796: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '|| to_char(l_user_entity_id));
2797: hr_utility.trace('ROE_PAY_EARNED_END_DATE value = '|| l_value);
2798:
2799: ff_archive_api.create_archive_item(
2800: p_archive_item_id => l_archive_item_id,
2801: p_user_entity_id => l_user_entity_id,

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

2814: -- is the day b4 LOA start date.
2815:
2816: if l_recall_date <= l_final_pay_period_end_date then
2817:
2818: hr_utility.trace('recall date is less than final period ending date');
2819: l_value := to_char(l_final_pay_period_end_date,'YYYY/MM/DD HH24:MI:SS');
2820:
2821: else
2822:

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

2819: l_value := to_char(l_final_pay_period_end_date,'YYYY/MM/DD HH24:MI:SS');
2820:
2821: else
2822:
2823: hr_utility.trace('recall date is greater than final period ending date');
2824: l_last_day_paid1 := get_working_date(l_business_group_id,
2825: l_assignment_id,
2826: l_last_day_paid,
2827: 'P');

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

2831: end if;
2832:
2833: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2834:
2835: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '||
2836: to_char(l_user_entity_id));
2837: hr_utility.trace('ROE_PAY_EARNED_END_DATE = '|| l_value);
2838:
2839: ff_archive_api.create_archive_item(

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

2833: l_user_entity_id := get_user_entity('ROE_PAY_EARNED_END_DATE');
2834:
2835: hr_utility.trace('ROE_PAY_EARNED_END_DATE id = '||
2836: to_char(l_user_entity_id));
2837: hr_utility.trace('ROE_PAY_EARNED_END_DATE = '|| l_value);
2838:
2839: ff_archive_api.create_archive_item(
2840: p_archive_item_id => l_archive_item_id,
2841: p_user_entity_id => l_user_entity_id,

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

2887: l_recall_date1 := l_recall_date;
2888:
2889: end if;
2890:
2891: hr_utility.trace('l_recall_date ' ||
2892: to_char(l_recall_date1,'dd-mon-yy'));
2893: l_value := to_char(l_recall_date1,'YYYY/MM/DD HH24:MI:SS');
2894: l_user_entity_id := get_user_entity('ROE_EXPECTED_DATE_OF_RECALL');
2895:

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

2921: l_user_entity_id := get_user_entity('ROE_UNKNOWN_NOT_RETURNING');
2922:
2923: end if;
2924:
2925: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2926: hr_utility.trace('l value = '|| l_value);
2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));

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

2922:
2923: end if;
2924:
2925: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2926: hr_utility.trace('l value = '|| l_value);
2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));

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

2924:
2925: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2926: hr_utility.trace('l value = '|| l_value);
2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);

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

2925: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
2926: hr_utility.trace('l value = '|| l_value);
2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);
2933: hr_utility.trace('l comment = '|| l_roe_comment);

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

2926: hr_utility.trace('l value = '|| l_value);
2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);
2933: hr_utility.trace('l comment = '|| l_roe_comment);
2934:

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

2927:
2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);
2933: hr_utility.trace('l comment = '|| l_roe_comment);
2934:
2935:

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

2928: hr_utility.trace('l person_id = '|| to_char(l_person_id));
2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);
2933: hr_utility.trace('l comment = '|| l_roe_comment);
2934:
2935:
2936: ff_archive_api.create_archive_item(

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

2929: hr_utility.trace('l bg_id = '|| to_char(l_business_group_id));
2930: hr_utility.trace('l effective date = '|| to_char(l_effective_date));
2931: hr_utility.trace('l recall date = '|| to_char(l_recall_date));
2932: hr_utility.trace('l reason = '|| l_roe_reason);
2933: hr_utility.trace('l comment = '|| l_roe_comment);
2934:
2935:
2936: ff_archive_api.create_archive_item(
2937: p_archive_item_id => l_archive_item_id,

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

2952: fetch cur_tax_group
2953: into l_tax_group_id;
2954: close cur_tax_group;
2955:
2956: hr_utility.trace('l_tax_group_id = ' || l_tax_group_id);
2957: hr_utility.trace('l_t4a_gre = ' || l_t4a_gre);
2958:
2959: l_value := '0';
2960:

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

2953: into l_tax_group_id;
2954: close cur_tax_group;
2955:
2956: hr_utility.trace('l_tax_group_id = ' || l_tax_group_id);
2957: hr_utility.trace('l_t4a_gre = ' || l_t4a_gre);
2958:
2959: l_value := '0';
2960:
2961: l_user_entity_id := get_user_entity('ROE_BOX_17A');

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

2961: l_user_entity_id := get_user_entity('ROE_BOX_17A');
2962:
2963: if balance_feed_exists('ROE Vacation Pay',l_business_group_id) then
2964:
2965: hr_utility.trace('Archive Data: Balance Feed Exists for ROE Vacation Pay');
2966:
2967: l_defined_balance_id := get_defined_balance_id(
2968: 'ROE Vacation Pay',
2969: 'Assignment within Government Reporting Entity Period to Date',

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

2968: 'ROE Vacation Pay',
2969: 'Assignment within Government Reporting Entity Period to Date',
2970: l_business_group_id);
2971:
2972: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2973: for gres in cur_17_gres(l_tax_group_id) loop
2974:
2975: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2976: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));

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

2971:
2972: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2973: for gres in cur_17_gres(l_tax_group_id) loop
2974:
2975: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2976: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2977: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2978:
2979: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);

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

2972: hr_utility.trace('l_defined_balance_id = ' || to_char(l_defined_balance_id));
2973: for gres in cur_17_gres(l_tax_group_id) loop
2974:
2975: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2976: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2977: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2978:
2979: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
2980:

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

2973: for gres in cur_17_gres(l_tax_group_id) loop
2974:
2975: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2976: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2977: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2978:
2979: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
2980:
2981: open cur_latest_aaid(l_final_pay_period_start_date,

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

2988: else
2989: close cur_latest_aaid;
2990: end if;
2991:
2992: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
2993:
2994: if l_latest_aaid is not null then
2995: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
2996: l_latest_aaid),0);

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

2995: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
2996: l_latest_aaid),0);
2997: end if;
2998:
2999: hr_utility.trace('Vacation Paid l_value = ' || l_value);
3000: hr_utility.trace('l_final_pay_period_end_date = ' ||
3001: to_char(l_final_pay_period_end_date));
3002:
3003: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);

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

2996: l_latest_aaid),0);
2997: end if;
2998:
2999: hr_utility.trace('Vacation Paid l_value = ' || l_value);
3000: hr_utility.trace('l_final_pay_period_end_date = ' ||
3001: to_char(l_final_pay_period_end_date));
3002:
3003: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);
3004: fetch cur_final_pay_period_date

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

3022: else
3023: close cur_latest_aaid;
3024: end if;
3025:
3026: hr_utility.trace('Box 17A l_latest_aaid_after_term = ' ||
3027: to_char(l_latest_aaid_after_term));
3028:
3029: if l_latest_aaid_after_term is not null then
3030: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,

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

3030: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3031: l_latest_aaid_after_term),0);
3032: end if;
3033:
3034: hr_utility.trace('ROE_BOX_17A = ' || l_value);
3035:
3036: end loop; -- cur_17_gres
3037:
3038: end if; -- End if balance_feed_exists

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

3057: -- l_latest_aaid will have the latest assignment_action_id
3058: -- if box 17A is populated otherwise it will have 0 as this
3059: -- is initialized with 0.
3060:
3061: hr_utility.trace('l_final_pay_period_start_date = ' ||
3062: to_char(l_final_pay_period_start_date));
3063:
3064:
3065: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));

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

3061: hr_utility.trace('l_final_pay_period_start_date = ' ||
3062: to_char(l_final_pay_period_start_date));
3063:
3064:
3065: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));
3066:
3067: for tot_no_bal in 1..12 loop
3068:
3069: l_value := '0';

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

3075: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3076: 'Assignment within Government Reporting Entity Period to Date',
3077: l_business_group_id);
3078:
3079: hr_utility.trace('Box 17C l_defined_balance_id = ' ||
3080: to_char(l_defined_balance_id));
3081:
3082: for gres in cur_17_gres(l_tax_group_id) loop
3083:

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

3093: else
3094: close cur_latest_aaid;
3095: end if;
3096:
3097: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
3098:
3099: if l_latest_aaid is not null then
3100: l_value := l_value +
3101: NVL(pay_balance_pkg.get_value(l_defined_balance_id,

Line 3105: hr_utility.trace(

3101: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3102: l_latest_aaid),0);
3103: end if;
3104:
3105: hr_utility.trace(
3106: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3107: || l_value);
3108:
3109: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||

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

3105: hr_utility.trace(
3106: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3107: || l_value);
3108:
3109: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||
3110: to_char(l_final_pay_period_end_date));
3111:
3112: open cur_final_pay_period_date(l_final_pay_period_end_date + 1);
3113: fetch cur_final_pay_period_date

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

3120: end if;
3121:
3122: close cur_final_pay_period_date;
3123:
3124: hr_utility.trace('Box 17C l_period_end_date_after_term = ' ||
3125: to_char(l_period_end_date_after_term));
3126:
3127: open cur_latest_aaid(l_period_start_date_after_term,
3128: l_period_end_date_after_term,

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

3134: else
3135: close cur_latest_aaid;
3136: end if;
3137:
3138: hr_utility.trace('Box 17C l_latest_aaid_after_term = ' ||
3139: to_char(l_latest_aaid_after_term));
3140:
3141: if l_latest_aaid_after_term is not null then
3142: l_value := l_value +

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

3143: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3144: l_latest_aaid_after_term),0);
3145: end if;
3146:
3147: hr_utility.trace('Box 17C l_value = ' || l_value);
3148:
3149: end loop; -- cur_17_gres
3150:
3151: -- We will archive only the first three highest Balances

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

3177:
3178: end loop; -- End loop Balances
3179:
3180:
3181: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);

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

3178: end loop; -- End loop Balances
3179:
3180:
3181: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3186: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));

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

3179:
3180:
3181: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3186: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3187:

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

3180:
3181: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3186: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3187:
3188: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';

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

3181: hr_utility.trace('l_temp_code1 = ' || l_temp_code1);
3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3186: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3187:
3188: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';
3189: tab_user_entity_name(2) := 'ROE_BOX_17C_AMOUNT1';

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

3182: hr_utility.trace('l_temp_value1 = ' || to_char(l_temp_value1));
3183: hr_utility.trace('l_temp_code2 = ' || l_temp_code2);
3184: hr_utility.trace('l_temp_value2 = ' || to_char(l_temp_value2));
3185: hr_utility.trace('l_temp_code3 = ' || l_temp_code3);
3186: hr_utility.trace('l_temp_value3 = ' || to_char(l_temp_value3));
3187:
3188: tab_user_entity_name(1) := 'ROE_BOX_17C_DESC1';
3189: tab_user_entity_name(2) := 'ROE_BOX_17C_AMOUNT1';
3190: tab_user_entity_name(3) := 'ROE_BOX_17C_DESC2';

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

3249:
3250: l_value := l_total_insurable;
3251: l_user_entity_id := get_user_entity('ROE_TOTAL_INSURABLE_HOURS');
3252:
3253: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3254: hr_utility.trace('l value = '|| l_value);
3255:
3256: ff_archive_api.create_archive_item(
3257: p_archive_item_id => l_archive_item_id,

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

3250: l_value := l_total_insurable;
3251: l_user_entity_id := get_user_entity('ROE_TOTAL_INSURABLE_HOURS');
3252:
3253: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3254: hr_utility.trace('l value = '|| l_value);
3255:
3256: ff_archive_api.create_archive_item(
3257: p_archive_item_id => l_archive_item_id,
3258: p_user_entity_id => l_user_entity_id,

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

3265:
3266:
3267: -- EI Hours - End
3268:
3269: hr_utility.trace('End of archiving EI Hours');
3270:
3271: -- EI Earnings - Begin
3272:
3273: l_total_type := 'EI Earnings';

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

3286: p_period_type => l_period_type,
3287: p_term_or_abs_flag => l_term_or_abs_flag
3288: );
3289:
3290: hr_utility.trace('ret = ' || ret);
3291:
3292: tab_user_entity_name(1) := 'ROE_INSURABLE_EARNING_1';
3293: tab_user_entity_name(2) := 'ROE_INSURABLE_EARNING_2';
3294: tab_user_entity_name(3) := 'ROE_INSURABLE_EARNING_3';

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

3361: else
3362:
3363: /* Commented by ssmukher for Bug 4510534
3364: if ret = 'BOX15B' then
3365: hr_utility.trace('15B');
3366: l_value := '0';
3367: else
3368: hr_utility.trace('BOX15C');
3369: l_value := tab_period_total(cur_field);

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

3364: if ret = 'BOX15B' then
3365: hr_utility.trace('15B');
3366: l_value := '0';
3367: else
3368: hr_utility.trace('BOX15C');
3369: l_value := tab_period_total(cur_field);
3370: end if;
3371: */
3372: l_value := tab_period_total(cur_field);

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

3373: l_user_entity_id := get_user_entity(tab_user_entity_name(cur_field));
3374:
3375: end if;
3376:
3377: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3378: hr_utility.trace('l value = '|| l_value);
3379:
3380: ff_archive_api.create_archive_item(
3381: p_archive_item_id => l_archive_item_id,

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

3374:
3375: end if;
3376:
3377: hr_utility.trace('user entity id = '|| to_char(l_user_entity_id));
3378: hr_utility.trace('l value = '|| l_value);
3379:
3380: ff_archive_api.create_archive_item(
3381: p_archive_item_id => l_archive_item_id,
3382: p_user_entity_id => l_user_entity_id,

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

3388: p_some_warning => l_some_warning);
3389:
3390: end loop;
3391:
3392: hr_utility.trace('End of archiving EI Earnings');
3393:
3394: -- As all the archiving is done now we lock
3395: -- the mag assignment_action_id of the l_assignment_amend
3396: -- with the new assignment-action_id

Line 3436: hr_utility.raise_error;

3432: END IF;
3433:
3434: ELSE
3435:
3436: hr_utility.raise_error;
3437:
3438: END IF; -- check_retry_amend has failed or not.
3439:
3440: end;

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

3500:
3501: l_assignment_set_id := asg_set_exists(p_assignment_set_name,
3502: p_business_group_id);
3503:
3504: hr_utility.trace('l_assignment_set_id = ' || to_char(l_assignment_set_id));
3505:
3506: IF l_assignment_set_id <> -1 THEN
3507:
3508: OPEN c_already_in_set;

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

3511: IF c_already_in_set%NOTFOUND THEN
3512:
3513: CLOSE c_already_in_set;
3514:
3515: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||
3516: ' does not exist in the assignment set');
3517:
3518: hr_assignment_set_amds_pkg.insert_row(
3519: p_rowid => l_rowid

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

3520: ,p_assignment_id => p_assignment_id
3521: ,p_assignment_set_id => l_assignment_set_id
3522: ,p_include_or_exclude => 'I');
3523: ELSE
3524: hr_utility.trace('Assignment id: ' || to_char(p_assignment_id) ||
3525: ' already exists in the assignment set');
3526: CLOSE c_already_in_set;
3527:
3528: END IF;

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

3586: l_dummy VARCHAR2(1);
3587: --
3588: begin
3589: --
3590: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');
3591:
3592: OPEN cur_asg_set_id;
3593: FETCH cur_asg_set_id
3594: INTO l_assignment_set_id;

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

3594: INTO l_assignment_set_id;
3595:
3596: IF cur_asg_set_id%FOUND then
3597:
3598: hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');
3599: hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '
3600: || to_char(l_assignment_set_id));
3601:
3602: CLOSE cur_asg_set_id;

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

3595:
3596: IF cur_asg_set_id%FOUND then
3597:
3598: hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');
3599: hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '
3600: || to_char(l_assignment_set_id));
3601:
3602: CLOSE cur_asg_set_id;
3603: OPEN c_already_in_set;

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

3605: INTO l_dummy;
3606:
3607: IF c_already_in_set%FOUND THEN
3608:
3609: hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');
3610: CLOSE c_already_in_set;
3611:
3612: DELETE FROM
3613: hr_assignment_set_amendments

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

3624: INTO l_dummy;
3625:
3626: IF cur_last_row%ROWCOUNT = 0 then
3627:
3628: hr_utility.trace('In delete_asg_set_records cur_last_row = ' ||
3629: to_char(cur_last_row%ROWCOUNT));
3630:
3631: CLOSE cur_last_row;
3632: