eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on HR_UTILITY

Line 5: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should show

1: package body PAY_RETRO_NOTIF_PKG as
2: /* $Header: payretno.pkb 120.20.12010000.4 2008/11/17 10:16:47 ckesanap ship $ */
3: -------------------------------------------------------------------------------
4: g_package varchar2(80) := 'PAY_RETRO_NOTIF_PKG.';
5: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should show
6: g_dbg BOOLEAN := FALSE; --Extra debugging messages
7:
8: g_event_group pay_event_groups.event_group_id%type;
9: g_business_group_id per_business_groups.business_group_id%type;

Line 62: hr_utility.trace('Full param string: '||l_legparam);

58: p_adv_flag := l_adv_flag;
59: p_report_date := l_report_date;
60: --
61: if (g_traces) then
62: hr_utility.trace('Full param string: '||l_legparam);
63: hr_utility.trace('Got report date in get_pact_details '
64: ||to_char(l_report_date,'DD-MON-YYYY HH24:MI:SS'));
65: end if;
66:

Line 63: hr_utility.trace('Got report date in get_pact_details '

59: p_report_date := l_report_date;
60: --
61: if (g_traces) then
62: hr_utility.trace('Full param string: '||l_legparam);
63: hr_utility.trace('Got report date in get_pact_details '
64: ||to_char(l_report_date,'DD-MON-YYYY HH24:MI:SS'));
65: end if;
66:
67: end get_pact_details;

Line 104: hr_utility.set_message(801, 'HR_6395_SETUP_SET_EXISTS');

100: --
101: open c_set_check;
102: fetch c_set_check into l_dummy;
103: if c_set_check%FOUND then
104: hr_utility.set_message(801, 'HR_6395_SETUP_SET_EXISTS');
105: hr_utility.raise_error;
106: end if;
107: close c_set_check;
108: --

Line 105: hr_utility.raise_error;

101: open c_set_check;
102: fetch c_set_check into l_dummy;
103: if c_set_check%FOUND then
104: hr_utility.set_message(801, 'HR_6395_SETUP_SET_EXISTS');
105: hr_utility.raise_error;
106: end if;
107: close c_set_check;
108: --
109: end validate_asg_set;

Line 176: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

172: argument1 => p_payroll_action_id);
173:
174: IF l_req_id = 0 THEN
175: fnd_message.retrieve(l_errbuf);
176: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
177: raise zero_req_id;
178: ELSE
179: --
180: if p_adv_flag = 'Y' then

Line 203: -- hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');

199: -- update fnd_concurrent_requests
200: -- set PARENT_REQUEST_ID = to_number(c_req_id)
201: -- where request_id = l_req_id;
202: -- ELSE
203: -- hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
204: -- hr_utility.raise_error;
205: -- END IF;
206: --
207: END IF;

Line 204: -- hr_utility.raise_error;

200: -- set PARENT_REQUEST_ID = to_number(c_req_id)
201: -- where request_id = l_req_id;
202: -- ELSE
203: -- hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
204: -- hr_utility.raise_error;
205: -- END IF;
206: --
207: END IF;
208:

Line 211: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');

207: END IF;
208:
209: exception
210: when zero_req_id then
211: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
212: hr_utility.raise_error;
213: when others then
214: l_errbuf := SQLERRM;
215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

Line 212: hr_utility.raise_error;

208:
209: exception
210: when zero_req_id then
211: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
212: hr_utility.raise_error;
213: when others then
214: l_errbuf := SQLERRM;
215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
216: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');

Line 215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

211: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
212: hr_utility.raise_error;
213: when others then
214: l_errbuf := SQLERRM;
215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
216: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
217: hr_utility.raise_error;
218:
219: end run_report;

Line 216: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');

212: hr_utility.raise_error;
213: when others then
214: l_errbuf := SQLERRM;
215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
216: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
217: hr_utility.raise_error;
218:
219: end run_report;
220: --

Line 217: hr_utility.raise_error;

213: when others then
214: l_errbuf := SQLERRM;
215: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
216: hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');
217: hr_utility.raise_error;
218:
219: end run_report;
220: --
221: procedure create_retro_asg_set(p_asg_set_name in varchar2,

Line 792: hr_utility.set_location(l_proc,100);

788: end if;
789: end if;
790: --
791: if (g_dbg) then
792: hr_utility.set_location(l_proc,100);
793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));

Line 793: hr_utility.trace(' Processing ASG '||p_assignment_id);

789: end if;
790: --
791: if (g_dbg) then
792: hr_utility.set_location(l_proc,100);
793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));
797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));

Line 794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));

790: --
791: if (g_dbg) then
792: hr_utility.set_location(l_proc,100);
793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));
797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));
798: end if;

Line 795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));

791: if (g_dbg) then
792: hr_utility.set_location(l_proc,100);
793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));
797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));
798: end if;
799:

Line 796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));

792: hr_utility.set_location(l_proc,100);
793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));
797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));
798: end if;
799:
800: /* only do something if there were process events */

Line 797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));

793: hr_utility.trace(' Processing ASG '||p_assignment_id);
794: hr_utility.trace(' p_min_creation_date: '||to_char(p_min_creation_date,'YYYY/MM/DD HH24:MI:SS'));
795: hr_utility.trace(' p_time_processing_started: '||to_char(p_time_processing_started,'YYYY/MM/DD HH24:MI:SS'));
796: hr_utility.trace(' l_min_eff_date: '||to_char(l_min_eff_date,'YYYY/MM/DD HH24:MI:SS'));
797: hr_utility.trace(' l_min_grp_eff_date: '||to_char(l_min_grp_eff_date,'YYYY/MM/DD HH24:MI:SS'));
798: end if;
799:
800: /* only do something if there were process events */
801: --

Line 888: hr_utility.trace('>> Element has no retro_component. Not adding '||l_entry_id(i)||' to store.');

884: l_ele_type_id(l_entry_id(i)) := l_type_id(i);
885: l_ret_comp_id(l_entry_id(i)) := l_retro_component_id(i);
886: else
887: if (g_dbg) then
888: hr_utility.trace('>> Element has no retro_component. Not adding '||l_entry_id(i)||' to store.');
889: end if;
890: end if;
891: --
892: end if;

Line 976: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);

972: ,p_owner_type => 'S'
973: ,p_system_reprocess_date => l_detailed_output(cnt).effective_date );
974: --
975: if (g_dbg) then
976: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
977: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
978: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
979: end if;
980: end if;

Line 977: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);

973: ,p_system_reprocess_date => l_detailed_output(cnt).effective_date );
974: --
975: if (g_dbg) then
976: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
977: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
978: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
979: end if;
980: end if;
981: else

Line 978: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);

974: --
975: if (g_dbg) then
976: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
977: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
978: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
979: end if;
980: end if;
981: else
982: -- In debug mode

Line 983: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);

979: end if;
980: end if;
981: else
982: -- In debug mode
983: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
984: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
985: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
986: end if;
987: --

Line 984: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);

980: end if;
981: else
982: -- In debug mode
983: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
984: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
985: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
986: end if;
987: --
988: end if;

Line 985: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);

981: else
982: -- In debug mode
983: hr_utility.trace('>DP >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
984: hr_utility.trace('>DP >effective_date = '||l_detailed_output(cnt).effective_date);
985: hr_utility.trace('>DP >update type = '||l_detailed_output(cnt).update_type);
986: end if;
987: --
988: end if;
989:

Line 1087: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);

1083: ,p_owner_type => 'S'
1084: ,p_system_reprocess_date => l_reprocess_date);
1085: --
1086: if (g_dbg) then
1087: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1088: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1089: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1090: hr_utility.trace('>DE >Reprocess Date = '||l_reprocess_date);
1091: end if;

Line 1088: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);

1084: ,p_system_reprocess_date => l_reprocess_date);
1085: --
1086: if (g_dbg) then
1087: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1088: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1089: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1090: hr_utility.trace('>DE >Reprocess Date = '||l_reprocess_date);
1091: end if;
1092: end if;

Line 1089: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);

1085: --
1086: if (g_dbg) then
1087: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1088: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1089: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1090: hr_utility.trace('>DE >Reprocess Date = '||l_reprocess_date);
1091: end if;
1092: end if;
1093: --

Line 1090: hr_utility.trace('>DE >Reprocess Date = '||l_reprocess_date);

1086: if (g_dbg) then
1087: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1088: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1089: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1090: hr_utility.trace('>DE >Reprocess Date = '||l_reprocess_date);
1091: end if;
1092: end if;
1093: --
1094: else

Line 1095: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);

1091: end if;
1092: end if;
1093: --
1094: else
1095: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1096: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1097: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1098: --
1099: end if;

Line 1096: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);

1092: end if;
1093: --
1094: else
1095: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1096: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1097: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1098: --
1099: end if;
1100: --

Line 1097: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);

1093: --
1094: else
1095: hr_utility.trace('>DE >Entry Saved id = '||l_detailed_output(cnt).element_entry_id);
1096: hr_utility.trace('>DE >effective_date = '||l_detailed_output(cnt).effective_date);
1097: hr_utility.trace('>DE >update type = '||l_detailed_output(cnt).update_type);
1098: --
1099: end if;
1100: --
1101: end if;

Line 1131: hr_utility.set_location(l_proc,900);

1127: l_ret_comp_id.delete;
1128: --
1129: --
1130: if (g_traces) then
1131: hr_utility.set_location(l_proc,900);
1132: end if;
1133: end process_assignment;
1134:
1135: procedure initialise_globals(p_event_group in number,

Line 1193: hr_utility.trace('In archinit');

1189:
1190: begin
1191: --
1192:
1193: hr_utility.trace('In archinit');
1194:
1195: get_pact_details (p_payroll_action_id,
1196: l_asg_set_name,
1197: l_bus_grp,

Line 1294: hr_utility.trace('In process_action');

1290: l_asg_id pay_assignment_actions.assignment_id%type;
1291: --
1292: begin
1293: --
1294: hr_utility.trace('In process_action');
1295:
1296: select assignment_id
1297: into l_asg_id
1298: from pay_assignment_actions

Line 1324: hr_utility.set_location(l_proc,10);

1320: l_min_creation_date date; -- date stored for last execution
1321: l_global_env pay_interpreter_pkg.t_global_env_rec;
1322:
1323: BEGIN
1324: hr_utility.set_location(l_proc,10);
1325: --
1326: initialise_globals(p_event_group => p_event_group,
1327: p_business_group_id => p_business_group_id,
1328: p_payroll_action_id => null,

Line 1335: hr_utility.set_location(l_proc,15);

1331: p_adv_flag => 'Y',
1332: p_report_date => p_time_started
1333: );
1334: --
1335: hr_utility.set_location(l_proc,15);
1336: --
1337: generate_dates_and_process(p_assignment_id);
1338: --
1339: hr_utility.set_location(l_proc,20);

Line 1339: hr_utility.set_location(l_proc,20);

1335: hr_utility.set_location(l_proc,15);
1336: --
1337: generate_dates_and_process(p_assignment_id);
1338: --
1339: hr_utility.set_location(l_proc,20);
1340: --
1341: END run_asg_adv_retronot;
1342:
1343:

Line 1415: hr_utility.trace('In range_cursor');

1411: l_bus_grp number;
1412: l_adv_flag varchar2(1);
1413: --
1414: begin
1415: hr_utility.trace('In range_cursor');
1416: /* Effective date will be set to sysdate for CC*/
1417: sqlstr := 'select distinct asg.person_id
1418: from
1419: per_assignments_f asg,

Line 1450: hr_utility.trace('l_asg_set_name = '||l_asg_set_name);

1446: l_payroll_id);
1447: --
1448: end if;
1449:
1450: hr_utility.trace('l_asg_set_name = '||l_asg_set_name);
1451: commit;
1452: hr_utility.trace('Out range_cursor');
1453: --
1454: end range_cursor;

Line 1452: hr_utility.trace('Out range_cursor');

1448: end if;
1449:
1450: hr_utility.trace('l_asg_set_name = '||l_asg_set_name);
1451: commit;
1452: hr_utility.trace('Out range_cursor');
1453: --
1454: end range_cursor;
1455: --
1456: -------------------------- action_creation ---------------------------------

Line 1530: hr_utility.trace('In action_creation');

1526: FETCH c_get_report_type INTO l_report_type;
1527: CLOSE c_get_report_type;
1528:
1529: IF(g_traces) THEN
1530: hr_utility.trace('In action_creation');
1531: hr_utility.trace('l_report_type : '|| l_report_type);
1532: END if;
1533:
1534: l_range_person := pay_ac_utility.range_person_on(

Line 1531: hr_utility.trace('l_report_type : '|| l_report_type);

1527: CLOSE c_get_report_type;
1528:
1529: IF(g_traces) THEN
1530: hr_utility.trace('In action_creation');
1531: hr_utility.trace('l_report_type : '|| l_report_type);
1532: END if;
1533:
1534: l_range_person := pay_ac_utility.range_person_on(
1535: p_report_type => l_report_type

Line 1543: hr_utility.trace('l_range_person is true');

1539:
1540: if l_range_person THEN -- 7508169. Use the new cursor c_actions_range_on cursor to fetch the assignment_ids
1541:
1542: IF(g_traces) then
1543: hr_utility.trace('l_range_person is true');
1544: END if;
1545:
1546: for asgrec in c_actions_range_on(pactid, chunk) loop
1547: --

Line 1560: hr_utility.trace('l_range_person is false');

1556:
1557: ELSE -- Retain Old Logic- No Range Person
1558:
1559: IF(g_traces) then
1560: hr_utility.trace('l_range_person is false');
1561: END if;
1562:
1563: for asgrec in c_actions(pactid, stperson, endperson) loop
1564: --

Line 1615: hr_utility.set_location(l_proc,10);

1611:
1612: l_proc varchar2(160) := g_package||'deinitialise';
1613:
1614: begin
1615: hr_utility.set_location(l_proc,10);
1616: --
1617: get_pact_details (pactid,
1618: l_asg_set_name,
1619: l_bus_grp,

Line 1674: hr_utility.set_location(l_proc,900);

1670: -- where report_id = pactid;
1671: --
1672: end if;
1673: --
1674: hr_utility.set_location(l_proc,900);
1675: --
1676: end deinitialise;
1677: --
1678: -------------------------------------------------------------------------------