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.PQH_PTX_UTL dependencies on HR_UTILITY

Line 115: hr_utility.set_location('l_index:'||nvl(l_index,-111), 1000);

111: if p_string is null then
112: p_string := p_substring;
113: else
114: l_index := instr(nvl(p_string,''), p_substring);
115: hr_utility.set_location('l_index:'||nvl(l_index,-111), 1000);
116: if l_index = 0 then
117: p_string := p_string || fnd_global.local_chr(10) || ' ' || p_substring;
118: end if;
119: end if;

Line 1047: hr_utility.set_location('Entering:'||l_proc, 5);

1043: l_proc varchar2(72) := g_package||'alter_session_push';
1044:
1045:
1046: BEGIN
1047: hr_utility.set_location('Entering:'||l_proc, 5);
1048:
1049: EXECUTE IMMEDIATE
1050: 'alter session set "_push_join_predicate"=FALSE';
1051:

Line 1052: hr_utility.set_location('Leaving:'||l_proc, 1000);

1048:
1049: EXECUTE IMMEDIATE
1050: 'alter session set "_push_join_predicate"=FALSE';
1051:
1052: hr_utility.set_location('Leaving:'||l_proc, 1000);
1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: Raise ;

Line 1193: hr_utility.set_location('Entering:'||l_proc, 5);

1189: l_items_changed varchar2(10000);
1190: l_dpf_df c_dpf_df%rowtype;
1191: --
1192: BEGIN
1193: hr_utility.set_location('Entering:'||l_proc, 5);
1194: --
1195: savepoint apply_transaction;
1196: /*
1197: Determine the transaction type i.e whether it is update transaction or

Line 1228: hr_utility.set_location('Txn Type is Create '||l_proc, 6);

1224: IF l_ptx_rec.position_id IS NULL THEN
1225: -- create transaction
1226: l_txn_type := 'C';
1227: l_dpf_type := 'C';
1228: hr_utility.set_location('Txn Type is Create '||l_proc, 6);
1229: --
1230: open c_dpf_df(p_transaction_id);
1231: fetch c_dpf_df into l_dpf_df;
1232: close c_dpf_df;

Line 1237: hr_utility.set_location('Txn Type is Update '||l_proc, 7);

1233: --
1234: ELSE
1235: -- update transaction
1236: l_txn_type := 'U';
1237: hr_utility.set_location('Txn Type is Update '||l_proc, 7);
1238: -- call_refresh before applying Update Transaction;
1239: pqh_ptx_utl.refresh_ptx(
1240: p_transaction_category_id => l_transaction_category_id,
1241: p_position_transaction_id => p_transaction_id,

Line 1296: hr_utility.set_location(' Correction Mode '||l_proc, 10);

1292:
1293: IF (l_effective_start_date = l_ptx_rec.action_date) or (nvl(l_start_date,l_ptx_rec.date_effective) <> l_ptx_rec.date_effective) THEN
1294: -- record exists so its correction
1295: l_update_mode := 'CORRECTION';
1296: hr_utility.set_location(' Correction Mode '||l_proc, 10);
1297: ELSIF (l_effective_end_date = to_date('4712/12/31','RRRR/MM/DD')) THEN
1298: -- no record exists so its update
1299: l_update_mode := 'UPDATE';
1300: hr_utility.set_location(' Update Mode '||l_proc, 11);

Line 1300: hr_utility.set_location(' Update Mode '||l_proc, 11);

1296: hr_utility.set_location(' Correction Mode '||l_proc, 10);
1297: ELSIF (l_effective_end_date = to_date('4712/12/31','RRRR/MM/DD')) THEN
1298: -- no record exists so its update
1299: l_update_mode := 'UPDATE';
1300: hr_utility.set_location(' Update Mode '||l_proc, 11);
1301: ELSE
1302: l_update_mode := 'UPDATE_CHANGE_INSERT';
1303: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);
1304: END IF; -- for updt mode

Line 1303: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);

1299: l_update_mode := 'UPDATE';
1300: hr_utility.set_location(' Update Mode '||l_proc, 11);
1301: ELSE
1302: l_update_mode := 'UPDATE_CHANGE_INSERT';
1303: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);
1304: END IF; -- for updt mode
1305:
1306: END IF; -- for txn_type as update
1307:

Line 1317: hr_utility.set_location('Calling create_dt_position '||l_proc, 15);

1313: -- TABLE : hr_all_positions_f AND per_positions ( Common API )
1314: --
1315:
1316: IF l_txn_type = 'C' THEN
1317: hr_utility.set_location('Calling create_dt_position '||l_proc, 15);
1318: --
1319: -- call create API
1320: --
1321: hr_position_api.create_position

Line 1452: hr_utility.set_location('POSITION ID is : '||l_position_id, 19);

1448: ,p_attribute30 => l_ptx_rec.attribute30
1449: ,p_attribute_category => l_ptx_rec.attribute_category
1450: ) ;
1451: --
1452: hr_utility.set_location('POSITION ID is : '||l_position_id, 19);
1453: --
1454: update_pos_tran(p_position_transaction_id => l_ptx_rec.position_transaction_id,
1455: p_position_id => l_position_id,
1456: p_job_id => l_ptx_rec.job_id,

Line 1473: hr_utility.set_location('Update Budget Positions', 20);

1469:
1470:
1471: --rpullare
1472: --
1473: hr_utility.set_location('Update Budget Positions', 20);
1474: --
1475: ELSE
1476: hr_utility.set_location('Calling update_dt_position '||l_proc, 20);
1477: --

Line 1476: hr_utility.set_location('Calling update_dt_position '||l_proc, 20);

1472: --
1473: hr_utility.set_location('Update Budget Positions', 20);
1474: --
1475: ELSE
1476: hr_utility.set_location('Calling update_dt_position '||l_proc, 20);
1477: --
1478: -- call update API
1479: --
1480:

Line 1623: hr_utility.set_location(' Correction Mode '||l_proc, 10);

1619: if l_availability_status_id <> l_ptx_rec.availability_status_id then
1620: IF (l_effective_start_date = l_ptx_rec.action_date) THEN
1621: -- record exists so its correction
1622: l_update_mode := 'CORRECTION';
1623: hr_utility.set_location(' Correction Mode '||l_proc, 10);
1624: ELSIF (l_effective_end_date = to_date('4712/12/31','RRRR/MM/DD')) THEN
1625: -- no record exists so its update
1626: l_update_mode := 'UPDATE';
1627: hr_utility.set_location(' Update Mode '||l_proc, 11);

Line 1627: hr_utility.set_location(' Update Mode '||l_proc, 11);

1623: hr_utility.set_location(' Correction Mode '||l_proc, 10);
1624: ELSIF (l_effective_end_date = to_date('4712/12/31','RRRR/MM/DD')) THEN
1625: -- no record exists so its update
1626: l_update_mode := 'UPDATE';
1627: hr_utility.set_location(' Update Mode '||l_proc, 11);
1628: ELSE
1629: l_update_mode := 'UPDATE_CHANGE_INSERT';
1630: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);
1631: END IF; -- for updt mode

Line 1630: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);

1626: l_update_mode := 'UPDATE';
1627: hr_utility.set_location(' Update Mode '||l_proc, 11);
1628: ELSE
1629: l_update_mode := 'UPDATE_CHANGE_INSERT';
1630: hr_utility.set_location(' Update Change Insert Mode '||l_proc, 11);
1631: END IF; -- for updt mode
1632:
1633: hr_position_api.update_position
1634: (p_validate => false

Line 1768: hr_utility.set_location('POSITION ID is : '||l_position_id, 21);

1764: --
1765: -- assign position_id to local variable as it will be used in the next apis
1766: --
1767: l_position_id := l_ptx_rec.position_id;
1768: hr_utility.set_location('POSITION ID is : '||l_position_id, 21);
1769: --
1770: --rpullare Bug#2349744
1771:
1772: UPDATE FND_ATTACHED_DOCUMENTS

Line 1795: hr_utility.set_location('Calling per_dpf_ins.ins '||l_proc, 20);

1791: --
1792:
1793:
1794: IF l_dpf_type = 'C' THEN
1795: hr_utility.set_location('Calling per_dpf_ins.ins '||l_proc, 20);
1796:
1797: if (hr_psf_shd.get_availability_status(l_ptx_rec.availability_status_id,
1798: l_ptx_rec.business_group_id) <> 'ELIMINATED') then
1799: --

Line 1875: hr_utility.set_location('Calling per_dpf_upd.upd '||l_proc, 25);

1871: --
1872: end if;
1873: end if;
1874: ELSE
1875: hr_utility.set_location('Calling per_dpf_upd.upd '||l_proc, 25);
1876: --
1877: -- call update API
1878: --
1879:

Line 1966: hr_utility.set_location('Insert for pei_id '|| l_pei_position_extra_info_id

1962: end if;
1963:
1964: IF l_pei_type = 'I' THEN
1965: --
1966: hr_utility.set_location('Insert for pei_id '|| l_pei_position_extra_info_id
1967: ||l_proc, 20);
1968: insert into per_position_extra_info
1969: (
1970: position_extra_info_id, position_id, information_type,

Line 2015: hr_utility.set_location('After Insert for pei_id '|| l_pei_position_extra_info_id

2011: l_pte_rec.information29, l_pte_rec.information30,
2012: 1
2013: );
2014: --
2015: hr_utility.set_location('After Insert for pei_id '|| l_pei_position_extra_info_id
2016: ||l_proc, 25);
2017: ELSIF l_pei_type = 'C' THEN
2018: hr_utility.set_location('Calling create_position_extra_info.ins '
2019: ||l_proc, 30);

Line 2018: hr_utility.set_location('Calling create_position_extra_info.ins '

2014: --
2015: hr_utility.set_location('After Insert for pei_id '|| l_pei_position_extra_info_id
2016: ||l_proc, 25);
2017: ELSIF l_pei_type = 'C' THEN
2018: hr_utility.set_location('Calling create_position_extra_info.ins '
2019: ||l_proc, 30);
2020: --
2021: -- call create API
2022: --

Line 2083: hr_utility.set_location('Calling update_position_extra_info.upd '

2079: ,p_position_extra_info_id => l_position_extra_info_id
2080: ,p_object_version_number => l_object_version_number
2081: );
2082: ELSIF l_pei_type = 'U' then
2083: hr_utility.set_location('Calling update_position_extra_info.upd '
2084: ||l_proc, 35);
2085: --
2086: -- call update API
2087: --

Line 2183: hr_utility.set_message(8302,'PQH_ENTER_SEASONAL_DATES');

2179: -- Check if seasonal_flag = 'Y' then seasonal dates are entered.
2180: --
2181: if l_ptx_rec.seasonal_flag = 'Y' then
2182: if not l_seasonal_dates_present then
2183: hr_utility.set_message(8302,'PQH_ENTER_SEASONAL_DATES');
2184: hr_utility.raise_error;
2185: end if;
2186: else
2187: if l_seasonal_dates_present then

Line 2184: hr_utility.raise_error;

2180: --
2181: if l_ptx_rec.seasonal_flag = 'Y' then
2182: if not l_seasonal_dates_present then
2183: hr_utility.set_message(8302,'PQH_ENTER_SEASONAL_DATES');
2184: hr_utility.raise_error;
2185: end if;
2186: else
2187: if l_seasonal_dates_present then
2188: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');

Line 2188: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');

2184: hr_utility.raise_error;
2185: end if;
2186: else
2187: if l_seasonal_dates_present then
2188: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');
2189: hr_utility.raise_error;
2190: end if;
2191: end if;
2192: --

Line 2189: hr_utility.raise_error;

2185: end if;
2186: else
2187: if l_seasonal_dates_present then
2188: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');
2189: hr_utility.raise_error;
2190: end if;
2191: end if;
2192: --
2193: -- Check if overlap_period is not null then overlap dates are entered.

Line 2197: hr_utility.set_message(8302,'PQH_ENTER_OVERLAP_DATES');

2193: -- Check if overlap_period is not null then overlap dates are entered.
2194: --
2195: if l_ptx_rec.overlap_period is not null then
2196: if not l_overlap_dates_present then
2197: hr_utility.set_message(8302,'PQH_ENTER_OVERLAP_DATES');
2198: hr_utility.raise_error;
2199: end if;
2200: else
2201: if l_overlap_dates_present then

Line 2198: hr_utility.raise_error;

2194: --
2195: if l_ptx_rec.overlap_period is not null then
2196: if not l_overlap_dates_present then
2197: hr_utility.set_message(8302,'PQH_ENTER_OVERLAP_DATES');
2198: hr_utility.raise_error;
2199: end if;
2200: else
2201: if l_overlap_dates_present then
2202: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');

Line 2202: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');

2198: hr_utility.raise_error;
2199: end if;
2200: else
2201: if l_overlap_dates_present then
2202: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
2203: hr_utility.raise_error;
2204: end if;
2205: end if;
2206: /*

Line 2203: hr_utility.raise_error;

2199: end if;
2200: else
2201: if l_overlap_dates_present then
2202: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
2203: hr_utility.raise_error;
2204: end if;
2205: end if;
2206: /*
2207: --

Line 2212: hr_utility.set_message(8302,'PQH_ENTER_VALID_POS_FAMILY');

2208: -- Check whether to permit extended pay
2209: --
2210: if nvl(l_ptx_rec.work_period_type_cd,'N')='Y' then
2211: if not l_permit_extended_pay then
2212: hr_utility.set_message(8302,'PQH_ENTER_VALID_POS_FAMILY');
2213: hr_utility.raise_error;
2214: end if;
2215: end if;
2216: --

Line 2213: hr_utility.raise_error;

2209: --
2210: if nvl(l_ptx_rec.work_period_type_cd,'N')='Y' then
2211: if not l_permit_extended_pay then
2212: hr_utility.set_message(8302,'PQH_ENTER_VALID_POS_FAMILY');
2213: hr_utility.raise_error;
2214: end if;
2215: end if;
2216: --
2217: */

Line 2389: hr_utility.set_location('Leaving:'||l_proc, 1000);

2385: log_warnings(p_transaction_id);
2386: --
2387: pqh_process_batch_log.end_log ;
2388: --
2389: hr_utility.set_location('Leaving:'||l_proc, 1000);
2390: return(l_return);
2391: --
2392: EXCEPTION
2393: WHEN OTHERS THEN

Line 2599: hr_utility.set_location('inside fyi notification'||l_proc,10);

2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2596: from pqh_position_transactions
2597: where position_transaction_id = p_transaction_id;
2598: BEGIN
2599: hr_utility.set_location('inside fyi notification'||l_proc,10);
2600: open c0;
2601: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2602: l_job_desc, l_transaction_status;
2603: close c0;

Line 2604: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2600: open c0;
2601: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2602: l_job_desc, l_transaction_status;
2603: close c0;
2604: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2605: --
2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');

2602: l_job_desc, l_transaction_status;
2603: close c0;
2604: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2605: --
2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);

Line 2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2603: close c0;
2604: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2605: --
2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2604: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2605: --
2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2612: l_document := hr_utility.get_message;

Line 2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2605: --
2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2612: l_document := hr_utility.get_message;
2613: return l_document;

Line 2610: hr_utility.set_message_token('JOB',l_job_desc);

2606: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_NOTICE');
2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2612: l_document := hr_utility.get_message;
2613: return l_document;
2614: exception

Line 2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2607: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2612: l_document := hr_utility.get_message;
2613: return l_document;
2614: exception
2615: when others then

Line 2612: l_document := hr_utility.get_message;

2608: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2609: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2610: hr_utility.set_message_token('JOB',l_job_desc);
2611: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2612: l_document := hr_utility.get_message;
2613: return l_document;
2614: exception
2615: when others then
2616: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_FAIL');

Line 2616: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_FAIL');

2612: l_document := hr_utility.get_message;
2613: return l_document;
2614: exception
2615: when others then
2616: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_FAIL');
2617: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2618: l_document := hr_utility.get_message;
2619: return l_document;
2620: END fyi_notification;

Line 2617: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2613: return l_document;
2614: exception
2615: when others then
2616: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_FAIL');
2617: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2618: l_document := hr_utility.get_message;
2619: return l_document;
2620: END fyi_notification;
2621:

Line 2618: l_document := hr_utility.get_message;

2614: exception
2615: when others then
2616: hr_utility.set_message(8302,'PQH_PTX_WF_FYI_FAIL');
2617: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2618: l_document := hr_utility.get_message;
2619: return l_document;
2620: END fyi_notification;
2621:
2622: --------------------------------------------------------------------------

Line 2640: hr_utility.set_location('inside back notification'||l_proc,10);

2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2637: from pqh_position_transactions
2638: where position_transaction_id = p_transaction_id;
2639: BEGIN
2640: hr_utility.set_location('inside back notification'||l_proc,10);
2641: open c0;
2642: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2643: l_job_desc, l_transaction_status;
2644: close c0;

Line 2645: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2641: open c0;
2642: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2643: l_job_desc, l_transaction_status;
2644: close c0;
2645: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2646: --
2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');

2643: l_job_desc, l_transaction_status;
2644: close c0;
2645: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2646: --
2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);

Line 2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2644: close c0;
2645: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2646: --
2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2645: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2646: --
2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2653: l_document := hr_utility.get_message;

Line 2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2646: --
2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2653: l_document := hr_utility.get_message;
2654: return l_document;

Line 2651: hr_utility.set_message_token('JOB',l_job_desc);

2647: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_NOTICE');
2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2653: l_document := hr_utility.get_message;
2654: return l_document;
2655: exception

Line 2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2648: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2653: l_document := hr_utility.get_message;
2654: return l_document;
2655: exception
2656: when others then

Line 2653: l_document := hr_utility.get_message;

2649: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2650: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2651: hr_utility.set_message_token('JOB',l_job_desc);
2652: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2653: l_document := hr_utility.get_message;
2654: return l_document;
2655: exception
2656: when others then
2657: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_FAIL');

Line 2657: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_FAIL');

2653: l_document := hr_utility.get_message;
2654: return l_document;
2655: exception
2656: when others then
2657: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_FAIL');
2658: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2659: l_document := hr_utility.get_message;
2660: return l_document;
2661: END back_notification;

Line 2658: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2654: return l_document;
2655: exception
2656: when others then
2657: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_FAIL');
2658: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2659: l_document := hr_utility.get_message;
2660: return l_document;
2661: END back_notification;
2662:

Line 2659: l_document := hr_utility.get_message;

2655: exception
2656: when others then
2657: hr_utility.set_message(8302,'PQH_PTX_WF_BACK_FAIL');
2658: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2659: l_document := hr_utility.get_message;
2660: return l_document;
2661: END back_notification;
2662:
2663: --------------------------------------------------------------------------

Line 2681: hr_utility.set_location('inside override notification'||l_proc,10);

2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2678: from pqh_position_transactions
2679: where position_transaction_id = p_transaction_id;
2680: BEGIN
2681: hr_utility.set_location('inside override notification'||l_proc,10);
2682: open c0;
2683: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2684: l_job_desc, l_transaction_status;
2685: close c0;

Line 2686: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2682: open c0;
2683: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2684: l_job_desc, l_transaction_status;
2685: close c0;
2686: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2687: --
2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');

2684: l_job_desc, l_transaction_status;
2685: close c0;
2686: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2687: --
2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);

Line 2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2685: close c0;
2686: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2687: --
2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2686: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2687: --
2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2694: l_document := hr_utility.get_message;

Line 2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2687: --
2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2694: l_document := hr_utility.get_message;
2695: return l_document;

Line 2692: hr_utility.set_message_token('JOB',l_job_desc);

2688: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_NOTICE');
2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2694: l_document := hr_utility.get_message;
2695: return l_document;
2696: exception

Line 2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2689: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2694: l_document := hr_utility.get_message;
2695: return l_document;
2696: exception
2697: when others then

Line 2694: l_document := hr_utility.get_message;

2690: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2691: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2692: hr_utility.set_message_token('JOB',l_job_desc);
2693: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2694: l_document := hr_utility.get_message;
2695: return l_document;
2696: exception
2697: when others then
2698: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_FAIL');

Line 2698: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_FAIL');

2694: l_document := hr_utility.get_message;
2695: return l_document;
2696: exception
2697: when others then
2698: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_FAIL');
2699: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2700: l_document := hr_utility.get_message;
2701: return l_document;
2702: END override_notification;

Line 2699: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2695: return l_document;
2696: exception
2697: when others then
2698: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_FAIL');
2699: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2700: l_document := hr_utility.get_message;
2701: return l_document;
2702: END override_notification;
2703:

Line 2700: l_document := hr_utility.get_message;

2696: exception
2697: when others then
2698: hr_utility.set_message(8302,'PQH_PTX_WF_OVERRIDE_FAIL');
2699: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2700: l_document := hr_utility.get_message;
2701: return l_document;
2702: END override_notification;
2703:
2704: --------------------------------------------------------------------------

Line 2722: hr_utility.set_location('inside apply notification'||l_proc,10);

2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2719: from pqh_position_transactions
2720: where position_transaction_id = p_transaction_id;
2721: BEGIN
2722: hr_utility.set_location('inside apply notification'||l_proc,10);
2723: open c0;
2724: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2725: l_job_desc, l_transaction_status;
2726: close c0;

Line 2727: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2723: open c0;
2724: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2725: l_job_desc, l_transaction_status;
2726: close c0;
2727: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2728: --
2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');

2725: l_job_desc, l_transaction_status;
2726: close c0;
2727: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2728: --
2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);

Line 2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2726: close c0;
2727: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2728: --
2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2727: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2728: --
2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2735: l_document := hr_utility.get_message;

Line 2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2728: --
2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2735: l_document := hr_utility.get_message;
2736: return l_document;

Line 2733: hr_utility.set_message_token('JOB',l_job_desc);

2729: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_NOTICE');
2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2735: l_document := hr_utility.get_message;
2736: return l_document;
2737: exception

Line 2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2730: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2735: l_document := hr_utility.get_message;
2736: return l_document;
2737: exception
2738: when others then

Line 2735: l_document := hr_utility.get_message;

2731: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2732: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2733: hr_utility.set_message_token('JOB',l_job_desc);
2734: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2735: l_document := hr_utility.get_message;
2736: return l_document;
2737: exception
2738: when others then
2739: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_FAIL');

Line 2739: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_FAIL');

2735: l_document := hr_utility.get_message;
2736: return l_document;
2737: exception
2738: when others then
2739: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_FAIL');
2740: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2741: l_document := hr_utility.get_message;
2742: return l_document;
2743: END apply_notification;

Line 2740: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2736: return l_document;
2737: exception
2738: when others then
2739: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_FAIL');
2740: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2741: l_document := hr_utility.get_message;
2742: return l_document;
2743: END apply_notification;
2744:

Line 2741: l_document := hr_utility.get_message;

2737: exception
2738: when others then
2739: hr_utility.set_message(8302,'PQH_PTX_WF_APPLY_FAIL');
2740: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2741: l_document := hr_utility.get_message;
2742: return l_document;
2743: END apply_notification;
2744:
2745: --------------------------------------------------------------------------

Line 2763: hr_utility.set_location('inside reject notification'||l_proc,10);

2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2760: from pqh_position_transactions
2761: where position_transaction_id = p_transaction_id;
2762: BEGIN
2763: hr_utility.set_location('inside reject notification'||l_proc,10);
2764: open c0;
2765: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2766: l_job_desc, l_transaction_status;
2767: close c0;

Line 2768: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2764: open c0;
2765: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2766: l_job_desc, l_transaction_status;
2767: close c0;
2768: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2769: --
2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');

2766: l_job_desc, l_transaction_status;
2767: close c0;
2768: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2769: --
2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);

Line 2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2767: close c0;
2768: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2769: --
2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2768: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2769: --
2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2776: l_document := hr_utility.get_message;

Line 2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2769: --
2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2776: l_document := hr_utility.get_message;
2777: return l_document;

Line 2774: hr_utility.set_message_token('JOB',l_job_desc);

2770: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_NOTICE');
2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2776: l_document := hr_utility.get_message;
2777: return l_document;
2778: exception

Line 2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2771: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2776: l_document := hr_utility.get_message;
2777: return l_document;
2778: exception
2779: when others then

Line 2776: l_document := hr_utility.get_message;

2772: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2773: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2774: hr_utility.set_message_token('JOB',l_job_desc);
2775: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2776: l_document := hr_utility.get_message;
2777: return l_document;
2778: exception
2779: when others then
2780: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_FAIL');

Line 2780: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_FAIL');

2776: l_document := hr_utility.get_message;
2777: return l_document;
2778: exception
2779: when others then
2780: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_FAIL');
2781: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2782: l_document := hr_utility.get_message;
2783: return l_document;
2784: END reject_notification;

Line 2781: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2777: return l_document;
2778: exception
2779: when others then
2780: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_FAIL');
2781: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2782: l_document := hr_utility.get_message;
2783: return l_document;
2784: END reject_notification;
2785:

Line 2782: l_document := hr_utility.get_message;

2778: exception
2779: when others then
2780: hr_utility.set_message(8302,'PQH_PTX_WF_REJECT_FAIL');
2781: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2782: l_document := hr_utility.get_message;
2783: return l_document;
2784: END reject_notification;
2785:
2786: --------------------------------------------------------------------------

Line 2804: hr_utility.set_location('inside warning notification'||l_proc,10);

2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2801: from pqh_position_transactions
2802: where position_transaction_id = p_transaction_id;
2803: BEGIN
2804: hr_utility.set_location('inside warning notification'||l_proc,10);
2805: open c0;
2806: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2807: l_job_desc, l_transaction_status;
2808: close c0;

Line 2809: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2805: open c0;
2806: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2807: l_job_desc, l_transaction_status;
2808: close c0;
2809: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2810: --
2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');

2807: l_job_desc, l_transaction_status;
2808: close c0;
2809: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2810: --
2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);

Line 2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2808: close c0;
2809: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2810: --
2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2809: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2810: --
2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2817: l_document := hr_utility.get_message;

Line 2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2810: --
2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2817: l_document := hr_utility.get_message;
2818: return l_document;

Line 2815: hr_utility.set_message_token('JOB',l_job_desc);

2811: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_NOTICE');
2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2817: l_document := hr_utility.get_message;
2818: return l_document;
2819: exception

Line 2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2812: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2817: l_document := hr_utility.get_message;
2818: return l_document;
2819: exception
2820: when others then

Line 2817: l_document := hr_utility.get_message;

2813: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2814: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2815: hr_utility.set_message_token('JOB',l_job_desc);
2816: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2817: l_document := hr_utility.get_message;
2818: return l_document;
2819: exception
2820: when others then
2821: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_FAIL');

Line 2821: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_FAIL');

2817: l_document := hr_utility.get_message;
2818: return l_document;
2819: exception
2820: when others then
2821: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_FAIL');
2822: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2823: l_document := hr_utility.get_message;
2824: return l_document;
2825: END warning_notification;

Line 2822: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2818: return l_document;
2819: exception
2820: when others then
2821: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_FAIL');
2822: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2823: l_document := hr_utility.get_message;
2824: return l_document;
2825: END warning_notification;
2826:

Line 2823: l_document := hr_utility.get_message;

2819: exception
2820: when others then
2821: hr_utility.set_message(8302,'PQH_PTX_WF_WARNING_FAIL');
2822: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2823: l_document := hr_utility.get_message;
2824: return l_document;
2825: END warning_notification;
2826:
2827: --------------------------------------------------------------------------

Line 2845: hr_utility.set_location('inside respond notification'||l_proc,10);

2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2842: from pqh_position_transactions
2843: where position_transaction_id = p_transaction_id;
2844: BEGIN
2845: hr_utility.set_location('inside respond notification'||l_proc,10);
2846: open c0;
2847: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2848: l_job_desc, l_transaction_status;
2849: close c0;

Line 2850: hr_utility.set_location('position name, action date fetched '||l_proc,20);

2846: open c0;
2847: fetch c0 into l_position_name, l_action_date, l_organization_desc,
2848: l_job_desc, l_transaction_status;
2849: close c0;
2850: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2851: --
2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);

Line 2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');

2848: l_job_desc, l_transaction_status;
2849: close c0;
2850: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2851: --
2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);

Line 2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);

2849: close c0;
2850: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2851: --
2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

Line 2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);

2850: hr_utility.set_location('position name, action date fetched '||l_proc,20);
2851: --
2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2858: l_document := hr_utility.get_message;

Line 2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);

2851: --
2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2858: l_document := hr_utility.get_message;
2859: return l_document;

Line 2856: hr_utility.set_message_token('JOB',l_job_desc);

2852: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_NOTICE');
2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2858: l_document := hr_utility.get_message;
2859: return l_document;
2860: exception

Line 2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);

2853: hr_utility.set_message_token('POSITION_NAME',l_position_name);
2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2858: l_document := hr_utility.get_message;
2859: return l_document;
2860: exception
2861: when others then

Line 2858: l_document := hr_utility.get_message;

2854: hr_utility.set_message_token('ACTION_DATE',l_action_date);
2855: hr_utility.set_message_token('ORGANIZATION',l_organization_desc);
2856: hr_utility.set_message_token('JOB',l_job_desc);
2857: hr_utility.set_message_token('TRANSACTION_STATUS',l_transaction_status);
2858: l_document := hr_utility.get_message;
2859: return l_document;
2860: exception
2861: when others then
2862: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_FAIL');

Line 2862: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_FAIL');

2858: l_document := hr_utility.get_message;
2859: return l_document;
2860: exception
2861: when others then
2862: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_FAIL');
2863: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2864: l_document := hr_utility.get_message;
2865: return l_document;
2866: END respond_notification;

Line 2863: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

2859: return l_document;
2860: exception
2861: when others then
2862: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_FAIL');
2863: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2864: l_document := hr_utility.get_message;
2865: return l_document;
2866: END respond_notification;
2867:

Line 2864: l_document := hr_utility.get_message;

2860: exception
2861: when others then
2862: hr_utility.set_message(8302,'PQH_PTX_WF_RESPOND_FAIL');
2863: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
2864: l_document := hr_utility.get_message;
2865: return l_document;
2866: END respond_notification;
2867:
2868: --------------------------------------------------------------------------------------------------------------

Line 2893: hr_utility.set_location('Entering:'||l_proc, 5);

2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
2890: l_review_flag pqh_position_transactions.review_flag%TYPE;
2891:
2892: BEGIN
2893: hr_utility.set_location('Entering:'||l_proc, 5);
2894:
2895: OPEN csr_ptx;
2896: FETCH csr_ptx INTO l_ptx_rec;
2897: CLOSE csr_ptx;

Line 2918: hr_utility.set_location('Entering:'||l_proc||' with status: '||p_status||

2914: l_object_version_number := l_ptx_rec.object_version_number;
2915:
2916: -- call the update API
2917: -- If condition added for bug 6112905/ Modified for bug 6524175
2918: hr_utility.set_location('Entering:'||l_proc||' with status: '||p_status||
2919: 'and review_flag: '||l_review_flag, 15);
2920:
2921: if p_status in ('REJECT','TERMINATE','SUBMITTED') then
2922: l_review_flag := 'N';

Line 2937: hr_utility.set_location('Leaving:'||l_proc, 1000);

2933: ,p_review_flag => l_review_flag -- bug 6112905
2934: );
2935:
2936:
2937: hr_utility.set_location('Leaving:'||l_proc, 1000);
2938:
2939: RETURN 'SUCCESS';
2940:
2941:

Line 2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

2941:
2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2946: hr_utility.set_message_token('ROUTINE', l_proc);
2947: hr_utility.set_message_token('REASON', SQLERRM);
2948: hr_utility.raise_error;
2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);

Line 2946: hr_utility.set_message_token('ROUTINE', l_proc);

2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2946: hr_utility.set_message_token('ROUTINE', l_proc);
2947: hr_utility.set_message_token('REASON', SQLERRM);
2948: hr_utility.raise_error;
2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
2950: RETURN 'FAILURE';

Line 2947: hr_utility.set_message_token('REASON', SQLERRM);

2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2946: hr_utility.set_message_token('ROUTINE', l_proc);
2947: hr_utility.set_message_token('REASON', SQLERRM);
2948: hr_utility.raise_error;
2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
2950: RETURN 'FAILURE';
2951: END set_status;

Line 2948: hr_utility.raise_error;

2944: WHEN OTHERS THEN
2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2946: hr_utility.set_message_token('ROUTINE', l_proc);
2947: hr_utility.set_message_token('REASON', SQLERRM);
2948: hr_utility.raise_error;
2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
2950: RETURN 'FAILURE';
2951: END set_status;
2952:

Line 2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);

2945: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2946: hr_utility.set_message_token('ROUTINE', l_proc);
2947: hr_utility.set_message_token('REASON', SQLERRM);
2948: hr_utility.raise_error;
2949: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
2950: RETURN 'FAILURE';
2951: END set_status;
2952:
2953: --------------------------------------------------------------------------------

Line 3304: hr_utility.set_location('Insert for sit_id '|| l_sit_job_requirement_id

3300: end if;
3301:
3302: IF l_sit_type = 'I' THEN
3303: --
3304: hr_utility.set_location('Insert for sit_id '|| l_sit_job_requirement_id
3305: ||l_proc, 20);
3306: insert into per_job_requirements
3307: (
3308: job_requirement_id, business_group_id, analysis_criteria_id,

Line 3337: hr_utility.set_location('After Insert for sit_id '|| l_sit_job_requirement_id

3333: l_tjr_rec.attribute19, l_tjr_rec.attribute20,
3334: 1
3335: );
3336: --
3337: hr_utility.set_location('After Insert for sit_id '|| l_sit_job_requirement_id
3338: ||l_proc, 25);
3339: ELSIF l_sit_type = 'C' THEN
3340: hr_utility.set_location('Calling create PER_JOB_REQUIREMENTS '
3341: ||l_proc, 30);

Line 3340: hr_utility.set_location('Calling create PER_JOB_REQUIREMENTS '

3336: --
3337: hr_utility.set_location('After Insert for sit_id '|| l_sit_job_requirement_id
3338: ||l_proc, 25);
3339: ELSIF l_sit_type = 'C' THEN
3340: hr_utility.set_location('Calling create PER_JOB_REQUIREMENTS '
3341: ||l_proc, 30);
3342: --
3343: -- call create API
3344: --

Line 3383: hr_utility.set_location('Calling update PER_JOB_REQUIREMENTS '

3379: 1
3380: );
3381: end;
3382: ELSIF l_sit_type = 'U' then
3383: hr_utility.set_location('Calling update PER_JOB_REQUIREMENTS '
3384: ||l_proc, 35);
3385: --
3386: -- call update API
3387: --

Line 3474: hr_utility.set_location('l_tjr_items_changed:'||nvl(l_tjr_items_changed,'NULL'), 1000);

3470: p_txn_id => r_tjr.txn_job_requirement_id,
3471: p_refresh_criteria => 'TJR',
3472: p_items_changed => l_tjr_items_changed
3473: );
3474: hr_utility.set_location('l_tjr_items_changed:'||nvl(l_tjr_items_changed,'NULL'), 1000);
3475: if l_tjr_items_changed is not null then
3476: l_tjr_classification := pqh_utility.get_tjr_classification(r_tjr.txn_job_requirement_id);
3477: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);
3478: append_if_not_present(l_tjr_changed, l_tjr_classification);

Line 3477: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);

3473: );
3474: hr_utility.set_location('l_tjr_items_changed:'||nvl(l_tjr_items_changed,'NULL'), 1000);
3475: if l_tjr_items_changed is not null then
3476: l_tjr_classification := pqh_utility.get_tjr_classification(r_tjr.txn_job_requirement_id);
3477: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);
3478: append_if_not_present(l_tjr_changed, l_tjr_classification);
3479: end if;
3480: end loop;
3481: --

Line 3487: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);

3483: loop
3484: --
3485: if r_prs_tjr.object_version_number = 1 then
3486: l_tjr_classification := pqh_utility.get_tjr_classification(r_prs_tjr.txn_job_requirement_id);
3487: hr_utility.set_location('l_tjr_classification:'||nvl(l_tjr_classification,'NULL'), 1000);
3488: append_if_not_present(l_tjr_changed, l_tjr_classification);
3489: --
3490: delete pqh_txn_job_requirements
3491: where txn_job_requirement_id = r_prs_tjr.txn_job_requirement_id;

Line 3552: hr_utility.set_location('l_pte_items_changed:'||nvl(l_pte_items_changed,'NULL'), 1000);

3548: p_txn_id => r_pte.ptx_extra_info_ID,
3549: p_refresh_criteria => 'PTE',
3550: p_items_changed => l_pte_items_changed
3551: );
3552: hr_utility.set_location('l_pte_items_changed:'||nvl(l_pte_items_changed,'NULL'), 1000);
3553: if l_pte_items_changed is not null then
3554: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pte.ptx_extra_info_ID);
3555: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);
3556: append_if_not_present(l_pei_changed, l_pte_context_desc);

Line 3555: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);

3551: );
3552: hr_utility.set_location('l_pte_items_changed:'||nvl(l_pte_items_changed,'NULL'), 1000);
3553: if l_pte_items_changed is not null then
3554: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pte.ptx_extra_info_ID);
3555: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);
3556: append_if_not_present(l_pei_changed, l_pte_context_desc);
3557: end if;
3558: end loop;
3559: --

Line 3565: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);

3561: loop
3562: --
3563: if r_pes_poe.object_version_number = 1 then
3564: l_pte_context_desc := pqh_utility.get_pte_context_desc(r_pes_poe.ptx_extra_info_ID);
3565: hr_utility.set_location('l_pte_context_desc:'||nvl(l_pte_context_desc,'NULL'), 1000);
3566: append_if_not_present(l_pei_changed, l_pte_context_desc);
3567: --
3568: delete pqh_ptx_extra_info
3569: where ptx_extra_info_id = r_pes_poe.ptx_extra_info_id;

Line 3626: hr_utility.set_location('Entering:'||l_proc, 5);

3622: and information_type = 'PER_RESERVED') a
3623: where a.start_date between p_validation_start_date and p_validation_end_date;
3624: Begin
3625: --
3626: hr_utility.set_location('Entering:'||l_proc, 5);
3627: --
3628: --
3629: for r2 in csr_valid_eff_date(p_position_id, p_validation_start_date, p_validation_end_date) loop
3630: if p_position_type ='SHARED' or p_position_type ='SINGLE' then

Line 3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');

3630: if p_position_type ='SHARED' or p_position_type ='SINGLE' then
3631: open csr_valid_fte(p_position_id, r2.start_date);
3632: fetch csr_valid_fte into l_rsv_fte;
3633: if (p_fte < l_rsv_fte) then
3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');
3635: hr_utility.set_message_token('POSITION_FTE',p_fte);
3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;

Line 3635: hr_utility.set_message_token('POSITION_FTE',p_fte);

3631: open csr_valid_fte(p_position_id, r2.start_date);
3632: fetch csr_valid_fte into l_rsv_fte;
3633: if (p_fte < l_rsv_fte) then
3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');
3635: hr_utility.set_message_token('POSITION_FTE',p_fte);
3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;
3639: else

Line 3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);

3632: fetch csr_valid_fte into l_rsv_fte;
3633: if (p_fte < l_rsv_fte) then
3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');
3635: hr_utility.set_message_token('POSITION_FTE',p_fte);
3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;
3639: else
3640: hr_utility.set_location(l_proc, 3);

Line 3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);

3633: if (p_fte < l_rsv_fte) then
3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');
3635: hr_utility.set_message_token('POSITION_FTE',p_fte);
3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;
3639: else
3640: hr_utility.set_location(l_proc, 3);
3641: end if;

Line 3638: hr_utility.raise_error;

3634: hr_utility.set_message(800,'PER_FTE_LT_RSVD_FTE');
3635: hr_utility.set_message_token('POSITION_FTE',p_fte);
3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;
3639: else
3640: hr_utility.set_location(l_proc, 3);
3641: end if;
3642: --

Line 3640: hr_utility.set_location(l_proc, 3);

3636: hr_utility.set_message_token('RESERVED_FTE',l_rsv_fte);
3637: hr_utility.set_message_token('EFFECTIVE_DATE',r2.start_date);
3638: hr_utility.raise_error;
3639: else
3640: hr_utility.set_location(l_proc, 3);
3641: end if;
3642: --
3643: close csr_valid_fte;
3644: end if;

Line 3979: hr_utility.set_location('Budget Detail Id : '||p_worksheet_details_rec.budget_detail_id, 7);

3975: --
3976: if p_worksheet_details_rec.budget_detail_id is not null then
3977: l_budget_detail_id := p_worksheet_details_rec.budget_detail_id;
3978: -- update rows where p_worksheet_details_rec.budget_detail_id IS NOT NULL
3979: hr_utility.set_location('Budget Detail Id : '||p_worksheet_details_rec.budget_detail_id, 7);
3980:
3981: -- get the object_version_number for this budget_detail_id and pass to update API
3982: OPEN l_object_version_number_cur(p_worksheet_details_rec.budget_detail_id);
3983: FETCH l_object_version_number_cur INTO l_object_version_number;

Line 3986: hr_utility.set_location('Update API OVN : '||l_object_version_number, 8);

3982: OPEN l_object_version_number_cur(p_worksheet_details_rec.budget_detail_id);
3983: FETCH l_object_version_number_cur INTO l_object_version_number;
3984: CLOSE l_object_version_number_cur;
3985:
3986: hr_utility.set_location('Update API OVN : '||l_object_version_number, 8);
3987:
3988: pqh_budget_details_api.update_budget_detail
3989: (
3990: p_validate => false

Line 4015: hr_utility.set_location('Create API in update mode : ', 9);

4011: l_budget_detail_id := p_worksheet_details_rec.budget_detail_id;
4012: else
4013: -- for others i.e new rows call the insert API
4014:
4015: hr_utility.set_location('Create API in update mode : ', 9);
4016:
4017: pqh_budget_details_api.create_budget_detail
4018: (
4019: p_validate => false

Line 4049: hr_utility.set_location('Budget Period Id : '||p_worksheet_periods_rec.budget_period_id, 7);

4045: --
4046: if p_worksheet_periods_rec.budget_period_id is not null then
4047: l_budget_period_id := p_worksheet_periods_rec.budget_period_id;
4048: -- update rows where p_worksheet_periods_rec.budget_period_id IS NOT NULL
4049: hr_utility.set_location('Budget Period Id : '||p_worksheet_periods_rec.budget_period_id, 7);
4050:
4051: -- Populate all other levels
4052: -- pqh_apply_budget.ptx_budget_periods(r_wst.worksheet_detail_id);
4053: if l_budget_period_id is not null then

Line 4090: hr_utility.set_location('Update API OVN : '||l_bpr_object_version_number, 8);

4086: OPEN l_bpr_ovn_cur(p_worksheet_periods_rec.budget_period_id);
4087: FETCH l_bpr_ovn_cur INTO l_bpr_object_version_number;
4088: CLOSE l_bpr_ovn_cur;
4089:
4090: hr_utility.set_location('Update API OVN : '||l_bpr_object_version_number, 8);
4091:
4092: pqh_budget_periods_api.update_budget_period
4093: (
4094: p_validate => false

Line 4116: hr_utility.set_location('Create API in update mode : ', 9);

4112: );
4113: else
4114: -- for others i.e new rows call the insert API
4115:
4116: hr_utility.set_location('Create API in update mode : ', 9);
4117:
4118: pqh_budget_periods_api.create_budget_period
4119: (
4120: p_validate => false