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

Line 294: hr_utility.set_location('Entering: '||l_proc, 10);

290: and pdb.defined_balance_id = pbsm.defined_balance_id
291: order by pdb.balance_type_id
292: ;
293: begin
294: hr_utility.set_location('Entering: '||l_proc, 10);
295:
296: if p_purge_action_id is not null then
297: --
298: -- Check to see if this is a purge action just in case.

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

300: open csr_ppa;
301: fetch csr_ppa into l_ppa_rec;
302: close csr_ppa;
303: --
304: hr_utility.set_location(l_proc, 15);
305: pay_core_utils.assert_condition
306: ('pay_purge_pkg.init_pact:1', nvl(l_ppa_rec.action_type,'null') = 'Z');
307: end if;
308:

Line 317: hr_utility.trace(' Payroll Action ID = '||p_purge_action_id);

313: g_purge_action_rec.business_group_id := l_ppa_rec.business_group_id;
314: g_purge_action_rec.legislation_code := l_ppa_rec.legislation_code;
315: g_purge_action_rec.effective_date := l_ppa_rec.effective_date;
316:
317: hr_utility.trace(' Payroll Action ID = '||p_purge_action_id);
318: hr_utility.trace(' Business Group ID = '||l_ppa_rec.business_group_id);
319: hr_utility.trace(' Legislation Code = '||l_ppa_rec.legislation_code);
320: hr_utility.trace(' Effective Date = '||l_ppa_rec.effective_date);
321:

Line 318: hr_utility.trace(' Business Group ID = '||l_ppa_rec.business_group_id);

314: g_purge_action_rec.legislation_code := l_ppa_rec.legislation_code;
315: g_purge_action_rec.effective_date := l_ppa_rec.effective_date;
316:
317: hr_utility.trace(' Payroll Action ID = '||p_purge_action_id);
318: hr_utility.trace(' Business Group ID = '||l_ppa_rec.business_group_id);
319: hr_utility.trace(' Legislation Code = '||l_ppa_rec.legislation_code);
320: hr_utility.trace(' Effective Date = '||l_ppa_rec.effective_date);
321:
322: --

Line 319: hr_utility.trace(' Legislation Code = '||l_ppa_rec.legislation_code);

315: g_purge_action_rec.effective_date := l_ppa_rec.effective_date;
316:
317: hr_utility.trace(' Payroll Action ID = '||p_purge_action_id);
318: hr_utility.trace(' Business Group ID = '||l_ppa_rec.business_group_id);
319: hr_utility.trace(' Legislation Code = '||l_ppa_rec.legislation_code);
320: hr_utility.trace(' Effective Date = '||l_ppa_rec.effective_date);
321:
322: --
323: -- Retrieve the number of assignments to process.

Line 320: hr_utility.trace(' Effective Date = '||l_ppa_rec.effective_date);

316:
317: hr_utility.trace(' Payroll Action ID = '||p_purge_action_id);
318: hr_utility.trace(' Business Group ID = '||l_ppa_rec.business_group_id);
319: hr_utility.trace(' Legislation Code = '||l_ppa_rec.legislation_code);
320: hr_utility.trace(' Effective Date = '||l_ppa_rec.effective_date);
321:
322: --
323: -- Retrieve the number of assignments to process.
324: --

Line 331: hr_utility.trace(' Asg Count = '||g_purge_action_rec.asg_count);

327: from pay_assignment_actions
328: where payroll_action_id = p_purge_action_id
329: and action_status <> 'C';
330:
331: hr_utility.trace(' Asg Count = '||g_purge_action_rec.asg_count);
332:
333: --
334: -- Delete the balance cache.
335: --

Line 350: hr_utility.set_location('Leaving: '||l_proc, 50);

346: --
347: end loop;
348: end if;
349:
350: hr_utility.set_location('Leaving: '||l_proc, 50);
351: end init_pact;
352:
353: /*
354: * This function checks to see if the specified balance could have a

Line 1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');

1126: where pdb.defined_balance_id = c1rec.defined_balance_id
1127: and pbt.balance_type_id = pdb.balance_type_id
1128: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1129:
1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');
1131: hr_utility.set_message_token('BALANCE', l_balance_name);
1132: hr_utility.set_message_token('EXPECTED', c1rec.value);
1133: hr_utility.set_message_token('ACTUAL', l_value);
1134: hr_utility.raise_error;

Line 1131: hr_utility.set_message_token('BALANCE', l_balance_name);

1127: and pbt.balance_type_id = pdb.balance_type_id
1128: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1129:
1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');
1131: hr_utility.set_message_token('BALANCE', l_balance_name);
1132: hr_utility.set_message_token('EXPECTED', c1rec.value);
1133: hr_utility.set_message_token('ACTUAL', l_value);
1134: hr_utility.raise_error;
1135: end if;

Line 1132: hr_utility.set_message_token('EXPECTED', c1rec.value);

1128: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1129:
1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');
1131: hr_utility.set_message_token('BALANCE', l_balance_name);
1132: hr_utility.set_message_token('EXPECTED', c1rec.value);
1133: hr_utility.set_message_token('ACTUAL', l_value);
1134: hr_utility.raise_error;
1135: end if;
1136: end loop;

Line 1133: hr_utility.set_message_token('ACTUAL', l_value);

1129:
1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');
1131: hr_utility.set_message_token('BALANCE', l_balance_name);
1132: hr_utility.set_message_token('EXPECTED', c1rec.value);
1133: hr_utility.set_message_token('ACTUAL', l_value);
1134: hr_utility.raise_error;
1135: end if;
1136: end loop;
1137: end pypurvbr;

Line 1134: hr_utility.raise_error;

1130: hr_utility.set_message(801, 'PAY_289018_PUR_BAL_VAL_FAIL');
1131: hr_utility.set_message_token('BALANCE', l_balance_name);
1132: hr_utility.set_message_token('EXPECTED', c1rec.value);
1133: hr_utility.set_message_token('ACTUAL', l_value);
1134: hr_utility.raise_error;
1135: end if;
1136: end loop;
1137: end pypurvbr;
1138:

Line 1280: hr_utility.trace('l_et_name : ' || l_et_name);

1276: p_adjustment_only_flag => 'Y',
1277: p_business_group_name => p_bg_name,
1278: p_post_termination_rule => l_ptr);
1279:
1280: hr_utility.trace('l_et_name : ' || l_et_name);
1281:
1282: -- The element_information1 needs to be set to 'B'
1283: -- to allow rollup of subject balances. We have
1284: -- no 'official' way and so so use direct update.

Line 1320: hr_utility.set_location ('cre_iv_bf', 10);

1316: l_et_id pay_element_types_f.element_type_id%type;
1317:
1318: begin
1319:
1320: hr_utility.set_location ('cre_iv_bf', 10);
1321:
1322: -- Grab some details for calls.
1323: select pet.element_name,
1324: pet.element_type_id,

Line 1338: hr_utility.set_location ('cre_iv_bf', 20);

1334: and pet.element_type_id = pel.element_type_id
1335: and pet.effective_start_date = c_sot
1336: and pet.effective_end_date = c_eot;
1337:
1338: hr_utility.set_location ('cre_iv_bf', 20);
1339:
1340: l_iv_id := pay_db_pay_setup.create_input_value (
1341: p_element_name => l_et_name,
1342: p_name => p_iv_name,

Line 1349: hr_utility.set_location ('cre_iv_bf', 30);

1345: p_effective_start_date => c_sot,
1346: p_effective_end_date => c_eot,
1347: p_display_sequence => p_seq);
1348:
1349: hr_utility.set_location ('cre_iv_bf', 30);
1350:
1351: hr_input_values.create_link_input_value(
1352: p_insert_type => 'INSERT_INPUT_VALUE',
1353: p_element_link_id => p_el_id,

Line 1368: hr_utility.set_location ('cre_iv_bf', 40);

1364: p_legislation_code => NULL,
1365: p_pay_value_name => NULL,
1366: p_element_type_id => l_et_id);
1367:
1368: hr_utility.set_location ('cre_iv_bf', 40);
1369:
1370: if(p_bt_id is not null) then
1371: -- We must be creating a balance feed as well
1372:

Line 1373: hr_utility.set_location ('cre_iv_bf', 50);

1369:
1370: if(p_bt_id is not null) then
1371: -- We must be creating a balance feed as well
1372:
1373: hr_utility.set_location ('cre_iv_bf', 50);
1374:
1375: hr_balances.ins_balance_feed(
1376: p_option => 'INS_MANUAL_FEED',
1377: p_input_value_id => l_iv_id,

Line 1396: hr_utility.set_location('pay_purge_pkg.pypurcif', 10);

1392: end cre_iv_bf;
1393:
1394: begin
1395:
1396: hr_utility.set_location('pay_purge_pkg.pypurcif', 10);
1397:
1398: select pbg.name
1399: into l_bg_name
1400: from per_business_groups pbg

Line 1449: hr_utility.set_location('pay_purge_pkg.pypurcif', 20);

1445: -- and the input and output currency codes must always
1446: -- be the same (to avoid currency conversion issues
1447: -- when the balance adjustment is processed).
1448:
1449: hr_utility.set_location('pay_purge_pkg.pypurcif', 20);
1450:
1451: l := l_et_tab.first;
1452:
1453: while(l is not null) loop

Line 1475: hr_utility.set_location('pay_purge_pkg.pypurcif', 30);

1471: -- If we haven't found a type that has been created
1472: -- already, we create the element type, link and so on.
1473: if(not l_found) then
1474:
1475: hr_utility.set_location('pay_purge_pkg.pypurcif', 30);
1476:
1477: -- Record that another element type will be created.
1478: l_et_count := l_et_count + 1;
1479:

Line 1495: hr_utility.set_location('pay_purge_pkg.pypurcif', 40);

1491: l_et_tab(l_el_id).jur_lev := c1rec.jurisdiction_level;
1492:
1493: end if;
1494:
1495: hr_utility.set_location('pay_purge_pkg.pypurcif', 40);
1496:
1497: -- The display sequence is the same as the
1498: -- input value count.
1499: l_iv_count := l_et_tab(l_el_id).iv_count;

Line 1514: hr_utility.trace('** l_el_id : ' || l_el_id);

1510:
1511: if(l_et_tab(l_el_id).iv_count = c_iv_limit) then
1512: -- If the input value limit has been reached, we
1513: -- remove the element type from the list.
1514: hr_utility.trace('** l_el_id : ' || l_el_id);
1515: l_et_tab.delete(l_el_id);
1516: end if;
1517:
1518: end;