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

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

71: --
72: -- Other variables
73: l_proc varchar2(72) := g_package ||'create_offer';
74: Begin
75: hr_utility.set_location(' Entering:' || l_proc,10);
76: --
77: -- Issue a savepoint
78: --
79: savepoint create_offer_swi;

Line 172: hr_utility.set_location(' Leaving:' || l_proc,20);

168: -- Also disable Multiple Message Detection.
169: --
170: --
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,20);
173: --
174: exception
175: when hr_multi_message.error_message_exist then
176: --

Line 188: hr_utility.set_location(' Leaving:' || l_proc, 30);

184: --
185: p_offer_version := null;
186: p_object_version_number := null;
187: p_return_status := hr_multi_message.get_return_status_disable;
188: hr_utility.set_location(' Leaving:' || l_proc, 30);
189: when others then
190: --
191: -- When Multiple Message Detection is enabled catch
192: -- any Application specific or other unexpected

Line 199: hr_utility.set_location(' Leaving:' || l_proc,40);

195: -- error.
196: --
197: rollback to create_offer_swi;
198: if hr_multi_message.unexpected_error_add(l_proc) then
199: hr_utility.set_location(' Leaving:' || l_proc,40);
200: raise;
201: end if;
202: --
203: -- Reset IN OUT and set OUT parameters

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

204: --
205: p_offer_version := null;
206: p_object_version_number := null;
207: p_return_status := hr_multi_message.get_return_status_disable;
208: hr_utility.set_location(' Leaving:' || l_proc,50);
209: end create_offer;
210: -- ----------------------------------------------------------------------------
211: -- |-----------------------------< update_offer >-----------------------------|
212: -- ----------------------------------------------------------------------------

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

278: --
279: -- Other variables
280: l_proc varchar2(72) := g_package ||'update_offer';
281: Begin
282: hr_utility.set_location(' Entering:' || l_proc,10);
283: --
284: -- Issue a savepoint
285: --
286: savepoint update_offer_swi;

Line 378: hr_utility.set_location(' Leaving:' || l_proc,20);

374: -- messages of any type exist in the Multiple Message List.
375: -- Also disable Multiple Message Detection.
376: --
377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,20);
379: --
380: exception
381: when hr_multi_message.error_message_exist then
382: --

Line 395: hr_utility.set_location(' Leaving:' || l_proc, 30);

391: p_offer_id := l_offer_id;
392: p_object_version_number := l_object_version_number;
393: p_offer_version := null;
394: p_return_status := hr_multi_message.get_return_status_disable;
395: hr_utility.set_location(' Leaving:' || l_proc, 30);
396: when others then
397: --
398: -- When Multiple Message Detection is enabled catch
399: -- any Application specific or other unexpected

Line 406: hr_utility.set_location(' Leaving:' || l_proc,40);

402: -- error.
403: --
404: rollback to update_offer_swi;
405: if hr_multi_message.unexpected_error_add(l_proc) then
406: hr_utility.set_location(' Leaving:' || l_proc,40);
407: raise;
408: end if;
409: --
410: -- Reset IN OUT and set OUT parameters

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

412: p_offer_id := l_offer_id;
413: p_object_version_number := l_object_version_number;
414: p_offer_version := null;
415: p_return_status := hr_multi_message.get_return_status_disable;
416: hr_utility.set_location(' Leaving:' || l_proc,50);
417: end update_offer;
418: -- ----------------------------------------------------------------------------
419: -- |-----------------------------< delete_offer >-----------------------------|
420: -- ----------------------------------------------------------------------------

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

433: --
434: -- Other variables
435: l_proc varchar2(72) := g_package ||'delete_offer';
436: Begin
437: hr_utility.set_location(' Entering:' || l_proc,10);
438: --
439: -- Issue a savepoint
440: --
441: savepoint delete_offer_swi;

Line 480: hr_utility.set_location(' Leaving:' || l_proc,20);

476: -- messages of any type exist in the Multiple Message List.
477: -- Also disable Multiple Message Detection.
478: --
479: p_return_status := hr_multi_message.get_return_status_disable;
480: hr_utility.set_location(' Leaving:' || l_proc,20);
481: --
482: exception
483: when hr_multi_message.error_message_exist then
484: --

Line 494: hr_utility.set_location(' Leaving:' || l_proc, 30);

490: --
491: -- Reset IN OUT parameters and set OUT parameters
492: --
493: p_return_status := hr_multi_message.get_return_status_disable;
494: hr_utility.set_location(' Leaving:' || l_proc, 30);
495: when others then
496: --
497: -- When Multiple Message Detection is enabled catch
498: -- any Application specific or other unexpected

Line 505: hr_utility.set_location(' Leaving:' || l_proc,40);

501: -- error.
502: --
503: rollback to delete_offer_swi;
504: if hr_multi_message.unexpected_error_add(l_proc) then
505: hr_utility.set_location(' Leaving:' || l_proc,40);
506: raise;
507: end if;
508: --
509: -- Reset IN OUT and set OUT parameters

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

508: --
509: -- Reset IN OUT and set OUT parameters
510: --
511: p_return_status := hr_multi_message.get_return_status_disable;
512: hr_utility.set_location(' Leaving:' || l_proc,50);
513: end delete_offer;
514: -- ----------------------------------------------------------------------------
515: -- |------------------------------< close_offer >-----------------------------|
516: -- ----------------------------------------------------------------------------

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

534: --
535: -- Other variables
536: l_proc varchar2(72) := g_package ||'close_offer';
537: Begin
538: hr_utility.set_location(' Entering:' || l_proc,10);
539: --
540: -- Issue a savepoint
541: --
542: savepoint close_offer_swi;

Line 586: hr_utility.set_location(' Leaving:' || l_proc,20);

582: -- messages of any type exist in the Multiple Message List.
583: -- Also disable Multiple Message Detection.
584: --
585: p_return_status := hr_multi_message.get_return_status_disable;
586: hr_utility.set_location(' Leaving:' || l_proc,20);
587: --
588: exception
589: when hr_multi_message.error_message_exist then
590: --

Line 600: hr_utility.set_location(' Leaving:' || l_proc, 30);

596: --
597: -- Reset IN OUT parameters and set OUT parameters
598: --
599: p_return_status := hr_multi_message.get_return_status_disable;
600: hr_utility.set_location(' Leaving:' || l_proc, 30);
601: when others then
602: --
603: -- When Multiple Message Detection is enabled catch
604: -- any Application specific or other unexpected

Line 611: hr_utility.set_location(' Leaving:' || l_proc,40);

607: -- error.
608: --
609: rollback to close_offer_swi;
610: if hr_multi_message.unexpected_error_add(l_proc) then
611: hr_utility.set_location(' Leaving:' || l_proc,40);
612: raise;
613: end if;
614: --
615: -- Reset IN OUT and set OUT parameters

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

614: --
615: -- Reset IN OUT and set OUT parameters
616: --
617: p_return_status := hr_multi_message.get_return_status_disable;
618: hr_utility.set_location(' Leaving:' || l_proc,50);
619: end close_offer;
620: -- ----------------------------------------------------------------------------
621: -- |------------------------------< hold_offer >------------------------------|
622: -- ----------------------------------------------------------------------------

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

640: --
641: -- Other variables
642: l_proc varchar2(72) := g_package ||'hold_offer';
643: Begin
644: hr_utility.set_location(' Entering:' || l_proc,10);
645: --
646: -- Issue a savepoint
647: --
648: savepoint hold_offer_swi;

Line 692: hr_utility.set_location(' Leaving:' || l_proc,20);

688: -- messages of any type exist in the Multiple Message List.
689: -- Also disable Multiple Message Detection.
690: --
691: p_return_status := hr_multi_message.get_return_status_disable;
692: hr_utility.set_location(' Leaving:' || l_proc,20);
693: --
694: exception
695: when hr_multi_message.error_message_exist then
696: --

Line 707: hr_utility.set_location(' Leaving:' || l_proc, 30);

703: -- Reset IN OUT parameters and set OUT parameters
704: --
705: p_object_version_number := l_object_version_number;
706: p_return_status := hr_multi_message.get_return_status_disable;
707: hr_utility.set_location(' Leaving:' || l_proc, 30);
708: when others then
709: --
710: -- When Multiple Message Detection is enabled catch
711: -- any Application specific or other unexpected

Line 718: hr_utility.set_location(' Leaving:' || l_proc,40);

714: -- error.
715: --
716: rollback to hold_offer_swi;
717: if hr_multi_message.unexpected_error_add(l_proc) then
718: hr_utility.set_location(' Leaving:' || l_proc,40);
719: raise;
720: end if;
721: --
722: -- Reset IN OUT and set OUT parameters

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

722: -- Reset IN OUT and set OUT parameters
723: --
724: p_object_version_number := l_object_version_number;
725: p_return_status := hr_multi_message.get_return_status_disable;
726: hr_utility.set_location(' Leaving:' || l_proc,50);
727: end hold_offer;
728: -- ----------------------------------------------------------------------------
729: -- |-----------------------------< release_offer >----------------------------|
730: -- ----------------------------------------------------------------------------

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

748: --
749: -- Other variables
750: l_proc varchar2(72) := g_package ||'release_offer';
751: Begin
752: hr_utility.set_location(' Entering:' || l_proc,10);
753: --
754: -- Issue a savepoint
755: --
756: savepoint release_offer_swi;

Line 800: hr_utility.set_location(' Leaving:' || l_proc,20);

796: -- messages of any type exist in the Multiple Message List.
797: -- Also disable Multiple Message Detection.
798: --
799: p_return_status := hr_multi_message.get_return_status_disable;
800: hr_utility.set_location(' Leaving:' || l_proc,20);
801: --
802: exception
803: when hr_multi_message.error_message_exist then
804: --

Line 815: hr_utility.set_location(' Leaving:' || l_proc, 30);

811: -- Reset IN OUT parameters and set OUT parameters
812: --
813: p_object_version_number := l_object_version_number;
814: p_return_status := hr_multi_message.get_return_status_disable;
815: hr_utility.set_location(' Leaving:' || l_proc, 30);
816: when others then
817: --
818: -- When Multiple Message Detection is enabled catch
819: -- any Application specific or other unexpected

Line 826: hr_utility.set_location(' Leaving:' || l_proc,40);

822: -- error.
823: --
824: rollback to release_offer_swi;
825: if hr_multi_message.unexpected_error_add(l_proc) then
826: hr_utility.set_location(' Leaving:' || l_proc,40);
827: raise;
828: end if;
829: --
830: -- Reset IN OUT and set OUT parameters

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

830: -- Reset IN OUT and set OUT parameters
831: --
832: p_object_version_number := l_object_version_number;
833: p_return_status := hr_multi_message.get_return_status_disable;
834: hr_utility.set_location(' Leaving:' || l_proc,50);
835: end release_offer;
836: -- ----------------------------------------------------------------------------
837: -- |------------------------< create_offer_assignment >-----------------------|
838: -- ----------------------------------------------------------------------------

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

966: --
967: -- Other variables
968: l_proc varchar2(72) := g_package ||'create_offer_assignment';
969: Begin
970: hr_utility.set_location(' Entering:' || l_proc,10);
971: --
972: -- Issue a savepoint
973: --
974: savepoint create_offer_assignment_swi;

Line 1145: hr_utility.set_location(' Leaving:' || l_proc,20);

1141: -- messages of any type exist in the Multiple Message List.
1142: -- Also disable Multiple Message Detection.
1143: --
1144: p_return_status := hr_multi_message.get_return_status_disable;
1145: hr_utility.set_location(' Leaving:' || l_proc,20);
1146: --
1147: exception
1148: when hr_multi_message.error_message_exist then
1149: --

Line 1167: hr_utility.set_location(' Leaving:' || l_proc, 30);

1163: p_comment_id := null;
1164: p_object_version_number := null;
1165: --
1166: p_return_status := hr_multi_message.get_return_status_disable;
1167: hr_utility.set_location(' Leaving:' || l_proc, 30);
1168: when others then
1169: --
1170: -- When Multiple Message Detection is enabled catch
1171: -- any Application specific or other unexpected

Line 1178: hr_utility.set_location(' Leaving:' || l_proc,40);

1174: -- error.
1175: --
1176: rollback to create_offer_assignment_swi;
1177: if hr_multi_message.unexpected_error_add(l_proc) then
1178: hr_utility.set_location(' Leaving:' || l_proc,40);
1179: raise;
1180: end if;
1181: --
1182: -- Reset IN OUT and set OUT parameters

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

1189: p_comment_id := null;
1190: p_object_version_number := null;
1191: --
1192: p_return_status := hr_multi_message.get_return_status_disable;
1193: hr_utility.set_location(' Leaving:' || l_proc,50);
1194: end create_offer_assignment;
1195: -- ----------------------------------------------------------------------------
1196: -- |------------------------< update_offer_assignment >-----------------------|
1197: -- ----------------------------------------------------------------------------

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

1332: --
1333: -- Other variables
1334: l_proc varchar2(72) := g_package ||'update_offer_assignment';
1335: Begin
1336: hr_utility.set_location(' Entering:' || l_proc,10);
1337: --
1338: -- Issue a savepoint
1339: --
1340: savepoint update_offer_assignment_swi;

Line 1531: hr_utility.set_location(' Leaving:' || l_proc,20);

1527: -- messages of any type exist in the Multiple Message List.
1528: -- Also disable Multiple Message Detection.
1529: --
1530: p_return_status := hr_multi_message.get_return_status_disable;
1531: hr_utility.set_location(' Leaving:' || l_proc,20);
1532: --
1533: exception
1534: when hr_multi_message.error_message_exist then
1535: --

Line 1555: hr_utility.set_location(' Leaving:' || l_proc, 30);

1551: p_validation_start_date := null;
1552: p_validation_end_date := null;
1553: p_offer_id := l_offer_id;
1554: p_return_status := hr_multi_message.get_return_status_disable;
1555: hr_utility.set_location(' Leaving:' || l_proc, 30);
1556: when others then
1557: --
1558: -- When Multiple Message Detection is enabled catch
1559: -- any Application specific or other unexpected

Line 1566: hr_utility.set_location(' Leaving:' || l_proc,40);

1562: -- error.
1563: --
1564: rollback to update_offer_assignment_swi;
1565: if hr_multi_message.unexpected_error_add(l_proc) then
1566: hr_utility.set_location(' Leaving:' || l_proc,40);
1567: raise;
1568: end if;
1569: --
1570: -- Reset IN OUT and set OUT parameters

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

1579: p_validation_start_date := null;
1580: p_validation_end_date := null;
1581: p_offer_id := l_offer_id;
1582: p_return_status := hr_multi_message.get_return_status_disable;
1583: hr_utility.set_location(' Leaving:' || l_proc,50);
1584: end update_offer_assignment;
1585: -- ----------------------------------------------------------------------------
1586: -- |------------------------< delete_offer_assignment >-----------------------|
1587: -- ----------------------------------------------------------------------------

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

1599: --
1600: -- Other variables
1601: l_proc varchar2(72) := g_package ||'delete_offer_assignment';
1602: Begin
1603: hr_utility.set_location(' Entering:' || l_proc,10);
1604: --
1605: -- Issue a savepoint
1606: --
1607: savepoint delete_offer_assignment_swi;

Line 1645: hr_utility.set_location(' Leaving:' || l_proc,20);

1641: -- messages of any type exist in the Multiple Message List.
1642: -- Also disable Multiple Message Detection.
1643: --
1644: p_return_status := hr_multi_message.get_return_status_disable;
1645: hr_utility.set_location(' Leaving:' || l_proc,20);
1646: --
1647: exception
1648: when hr_multi_message.error_message_exist then
1649: --

Line 1659: hr_utility.set_location(' Leaving:' || l_proc, 30);

1655: --
1656: -- Reset IN OUT parameters and set OUT parameters
1657: --
1658: p_return_status := hr_multi_message.get_return_status_disable;
1659: hr_utility.set_location(' Leaving:' || l_proc, 30);
1660: when others then
1661: --
1662: -- When Multiple Message Detection is enabled catch
1663: -- any Application specific or other unexpected

Line 1670: hr_utility.set_location(' Leaving:' || l_proc,40);

1666: -- error.
1667: --
1668: rollback to delete_offer_assignment_swi;
1669: if hr_multi_message.unexpected_error_add(l_proc) then
1670: hr_utility.set_location(' Leaving:' || l_proc,40);
1671: raise;
1672: end if;
1673: --
1674: -- Reset IN OUT and set OUT parameters

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

1673: --
1674: -- Reset IN OUT and set OUT parameters
1675: --
1676: p_return_status := hr_multi_message.get_return_status_disable;
1677: hr_utility.set_location(' Leaving:' || l_proc,50);
1678: end delete_offer_assignment;
1679: -- ----------------------------------------------------------------------------
1680: -- |--------------------------< upload_offer_letter >-------------------------|
1681: -- ----------------------------------------------------------------------------

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

1694: --
1695: -- Other variables
1696: l_proc varchar2(72) := g_package ||'upload_offer_letter';
1697: Begin
1698: hr_utility.set_location(' Entering:' || l_proc,10);
1699: --
1700: -- Issue a savepoint
1701: --
1702: savepoint upload_offer_letter_swi;

Line 1741: hr_utility.set_location(' Leaving:' || l_proc,20);

1737: -- messages of any type exist in the Multiple Message List.
1738: -- Also disable Multiple Message Detection.
1739: --
1740: p_return_status := hr_multi_message.get_return_status_disable;
1741: hr_utility.set_location(' Leaving:' || l_proc,20);
1742: --
1743: exception
1744: when hr_multi_message.error_message_exist then
1745: --

Line 1755: hr_utility.set_location(' Leaving:' || l_proc, 30);

1751: --
1752: -- Reset IN OUT parameters and set OUT parameters
1753: --
1754: p_return_status := hr_multi_message.get_return_status_disable;
1755: hr_utility.set_location(' Leaving:' || l_proc, 30);
1756: when others then
1757: --
1758: -- When Multiple Message Detection is enabled catch
1759: -- any Application specific or other unexpected

Line 1766: hr_utility.set_location(' Leaving:' || l_proc,40);

1762: -- error.
1763: --
1764: rollback to upload_offer_letter_swi;
1765: if hr_multi_message.unexpected_error_add(l_proc) then
1766: hr_utility.set_location(' Leaving:' || l_proc,40);
1767: raise;
1768: end if;
1769: --
1770: -- Reset IN OUT and set OUT parameters

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

1769: --
1770: -- Reset IN OUT and set OUT parameters
1771: --
1772: p_return_status := hr_multi_message.get_return_status_disable;
1773: hr_utility.set_location(' Leaving:' || l_proc,50);
1774: end upload_offer_letter;
1775: -- ----------------------------------------------------------------------------
1776: -- |--------------------< is_run_benmgle_for_irec_reqd >----------------------|
1777: -- ----------------------------------------------------------------------------

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

1938: l_offer_assignment_record per_all_assignments_f%rowtype;
1939: l_pay_proposal_record per_pay_proposals%rowtype;
1940: --
1941: Begin
1942: hr_utility.set_location(' Entering:' || l_proc,10);
1943: --
1944: -- Issue a savepoint
1945: --
1946: savepoint IS_RUN_BENMGLE_FOR_IREC_REQD;

Line 2141: hr_utility.set_location(' Leaving:' || l_proc,20);

2137: -- messages of any type exist in the Multiple Message List.
2138: -- Also disable Multiple Message Detection.
2139: --
2140: p_return_status := hr_multi_message.get_return_status_disable;
2141: hr_utility.set_location(' Leaving:' || l_proc,20);
2142: --
2143: exception
2144: when hr_multi_message.error_message_exist then
2145: --

Line 2155: hr_utility.set_location(' Leaving:' || l_proc, 30);

2151: --
2152: p_return_status := hr_multi_message.get_return_status_disable;
2153: p_is_run_reqd := 'N';
2154: --
2155: hr_utility.set_location(' Leaving:' || l_proc, 30);
2156: when others then
2157: --
2158: -- When Multiple Message Detection is enabled catch
2159: -- any Application specific or other unexpected

Line 2167: hr_utility.set_location(' Leaving:' || l_proc,40);

2163: --
2164: rollback to IS_RUN_BENMGLE_FOR_IREC_REQD;
2165: --
2166: if hr_multi_message.unexpected_error_add(l_proc) then
2167: hr_utility.set_location(' Leaving:' || l_proc,40);
2168: raise;
2169: end if;
2170: --
2171: p_return_status := hr_multi_message.get_return_status_disable;

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

2170: --
2171: p_return_status := hr_multi_message.get_return_status_disable;
2172: p_is_run_reqd := 'N';
2173: --
2174: hr_utility.set_location(' Leaving:' || l_proc,50);
2175: --
2176: end is_run_benmgle_for_irec_reqd;
2177: -- ----------------------------------------------------------------------------
2178: -- |-------------------------< run_benmgle_for_irec >-------------------------|

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

2296: l_proc varchar2(72) := g_package ||'run_benmgle_for_irec';
2297: l_offer_assignment_record per_all_assignments_f%rowtype;
2298: --
2299: Begin
2300: hr_utility.set_location(' Entering:' || l_proc,10);
2301: --
2302: -- Issue a savepoint
2303: --
2304: savepoint run_benmgle_for_irec;

Line 2440: hr_utility.set_location(' Leaving:' || l_proc,20);

2436: -- messages of any type exist in the Multiple Message List.
2437: -- Also disable Multiple Message Detection.
2438: --
2439: p_return_status := hr_multi_message.get_return_status_disable;
2440: hr_utility.set_location(' Leaving:' || l_proc,20);
2441: --
2442: exception
2443: when hr_multi_message.error_message_exist then
2444: --

Line 2452: hr_utility.set_location(' Leaving:' || l_proc, 30);

2448: --
2449: rollback to run_benmgle_for_irec;
2450: --
2451: p_return_status := hr_multi_message.get_return_status_disable;
2452: hr_utility.set_location(' Leaving:' || l_proc, 30);
2453: when others then
2454: --
2455: -- When Multiple Message Detection is enabled catch
2456: -- any Application specific or other unexpected

Line 2463: hr_utility.set_location(' Leaving:' || l_proc,40);

2459: -- error.
2460: --
2461: rollback to run_benmgle_for_irec;
2462: if hr_multi_message.unexpected_error_add(l_proc) then
2463: hr_utility.set_location(' Leaving:' || l_proc,40);
2464: raise;
2465: end if;
2466: --
2467: p_return_status := hr_multi_message.get_return_status_disable;

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

2464: raise;
2465: end if;
2466: --
2467: p_return_status := hr_multi_message.get_return_status_disable;
2468: hr_utility.set_location(' Leaving:' || l_proc,50);
2469: --
2470: end run_benmgle_for_irec;
2471: --
2472: --Save For Later Code Changes

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

2503: --
2504:
2505: BEGIN
2506: --
2507: hr_utility.set_location(' Entering:' || l_proc,10);
2508: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2509: --
2510: l_parser := xmlparser.newParser;
2511: xmlparser.ParseCLOB(l_parser,p_document);

Line 2508: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

2504:
2505: BEGIN
2506: --
2507: hr_utility.set_location(' Entering:' || l_proc,10);
2508: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2509: --
2510: l_parser := xmlparser.newParser;
2511: xmlparser.ParseCLOB(l_parser,p_document);
2512: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 2514: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

2510: l_parser := xmlparser.newParser;
2511: xmlparser.ParseCLOB(l_parser,p_document);
2512: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2513: --
2514: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2515:
2516: l_commitElement := xmldom.makeElement(l_CommitNode);
2517: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2518: --

Line 2616: hr_utility.set_location('Exiting:' || l_proc,40);

2612: );
2613: --
2614: end if;
2615: p_return_status := l_return_status;
2616: hr_utility.set_location('Exiting:' || l_proc,40);
2617:
2618: end process_offers_api;
2619:
2620: -- ----------------------------------------------------------------------------

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

2654: l_effective_date date := trunc(sysdate);
2655:
2656: BEGIN
2657:
2658: hr_utility.set_location(' Entering:' || l_proc,10);
2659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2660:
2661: l_parser := xmlparser.newParser;
2662: xmlparser.ParseCLOB(l_parser,p_document);

Line 2659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

2655:
2656: BEGIN
2657:
2658: hr_utility.set_location(' Entering:' || l_proc,10);
2659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2660:
2661: l_parser := xmlparser.newParser;
2662: xmlparser.ParseCLOB(l_parser,p_document);
2663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 2665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

2661: l_parser := xmlparser.newParser;
2662: xmlparser.ParseCLOB(l_parser,p_document);
2663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2664:
2665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2666:
2667: l_commitElement := xmldom.makeElement(l_CommitNode);
2668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2669:

Line 2827: hr_utility.set_location('Exiting:' || l_proc,40);

2823: );
2824: --
2825: end if;
2826: p_return_status := l_return_status;
2827: hr_utility.set_location('Exiting:' || l_proc,40);
2828:
2829: end process_asg_api;
2830: -- ----------------------------------------------------------------------------
2831: -- |-----------------------------< finalize_transaction >---------------------|

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

2902: );
2903: --
2904: begin
2905: --
2906: hr_utility.set_location(' Entering:' || l_proc,10);
2907: hr_utility.set_location(l_proc || ' Event:' || p_event,13);
2908: --
2909: open csr_offer_details;
2910: fetch csr_offer_details into

Line 2907: hr_utility.set_location(l_proc || ' Event:' || p_event,13);

2903: --
2904: begin
2905: --
2906: hr_utility.set_location(' Entering:' || l_proc,10);
2907: hr_utility.set_location(l_proc || ' Event:' || p_event,13);
2908: --
2909: open csr_offer_details;
2910: fetch csr_offer_details into
2911: l_offer_id, l_offer_version, l_prev_offer_status,

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

2912: l_applicant_assignment_id, l_expiry_date,l_object_version_number;
2913: if csr_offer_details%found then
2914: close csr_offer_details;
2915: --
2916: hr_utility.set_location(l_proc,15);
2917: --
2918: -- Approved or updated offer event handling
2919: --
2920: if p_event = 'APPROVED' OR p_event = 'SUBMIT' OR p_event = 'RESUBMIT' then

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

2917: --
2918: -- Approved or updated offer event handling
2919: --
2920: if p_event = 'APPROVED' OR p_event = 'SUBMIT' OR p_event = 'RESUBMIT' then
2921: hr_utility.set_location(l_proc, 20);
2922: -- if the transaction is approval of PENDING_EXTENDED, the status
2923: -- here will be EXTENDED as the update_offer would have converted
2924: -- the status already.
2925: if l_prev_offer_status = 'EXTENDED' then

Line 2939: hr_utility.set_location(l_proc, 24);

2935: --
2936: if l_offer_status_before_hold = 'EXTENDED' then
2937: l_offer_status := NULL;
2938: elsif l_offer_status_before_hold = 'PENDING' then
2939: hr_utility.set_location(l_proc, 24);
2940: l_offer_status := 'APPROVED';
2941: end if;
2942: --
2943: else

Line 2948: hr_utility.set_location(l_proc, 25);

2944: --
2945: -- This cursor is used to get the offer status and offer close reason
2946: -- If the close reason is Manager Withdraw or Applicant withdrew their
2947: -- application offer should not be updated
2948: hr_utility.set_location(l_proc, 25);
2949: open csr_offer_history_details(l_offer_id);
2950: fetch csr_offer_history_details into l_status,l_close_reason;
2951: if csr_offer_history_details%found then
2952: hr_utility.set_location(l_proc, 26);

Line 2952: hr_utility.set_location(l_proc, 26);

2948: hr_utility.set_location(l_proc, 25);
2949: open csr_offer_history_details(l_offer_id);
2950: fetch csr_offer_history_details into l_status,l_close_reason;
2951: if csr_offer_history_details%found then
2952: hr_utility.set_location(l_proc, 26);
2953: if l_status='CLOSED' and l_close_reason in ('MGR_WITHDRAW','WITHDRAWAL','MANUAL_CLOSURE','MGR_TERMINATE_APPL','AGENCY_TERMINATE_APPL') then
2954: hr_utility.set_location(l_proc, 27);
2955: l_offer_status := NULL;
2956: else

Line 2954: hr_utility.set_location(l_proc, 27);

2950: fetch csr_offer_history_details into l_status,l_close_reason;
2951: if csr_offer_history_details%found then
2952: hr_utility.set_location(l_proc, 26);
2953: if l_status='CLOSED' and l_close_reason in ('MGR_WITHDRAW','WITHDRAWAL','MANUAL_CLOSURE','MGR_TERMINATE_APPL','AGENCY_TERMINATE_APPL') then
2954: hr_utility.set_location(l_proc, 27);
2955: l_offer_status := NULL;
2956: else
2957: hr_utility.set_location(l_proc, 28);
2958: l_offer_status := 'APPROVED';

Line 2957: hr_utility.set_location(l_proc, 28);

2953: if l_status='CLOSED' and l_close_reason in ('MGR_WITHDRAW','WITHDRAWAL','MANUAL_CLOSURE','MGR_TERMINATE_APPL','AGENCY_TERMINATE_APPL') then
2954: hr_utility.set_location(l_proc, 27);
2955: l_offer_status := NULL;
2956: else
2957: hr_utility.set_location(l_proc, 28);
2958: l_offer_status := 'APPROVED';
2959: end if;
2960: else
2961: hr_utility.set_location(l_proc, 29);

Line 2961: hr_utility.set_location(l_proc, 29);

2957: hr_utility.set_location(l_proc, 28);
2958: l_offer_status := 'APPROVED';
2959: end if;
2960: else
2961: hr_utility.set_location(l_proc, 29);
2962: l_offer_status := 'APPROVED';
2963: end if;
2964: close csr_offer_history_details;
2965: end if;

Line 2970: hr_utility.set_location(l_proc, 30);

2966: --
2967: -- RFC offer event handling
2968: --
2969: elsif p_event = 'RFC' then
2970: hr_utility.set_location(l_proc, 30);
2971: open csr_offer_history_details(l_offer_id);
2972: fetch csr_offer_history_details into l_status,l_close_reason;
2973: if csr_offer_history_details%found then
2974: hr_utility.set_location(l_proc, 31);

Line 2974: hr_utility.set_location(l_proc, 31);

2970: hr_utility.set_location(l_proc, 30);
2971: open csr_offer_history_details(l_offer_id);
2972: fetch csr_offer_history_details into l_status,l_close_reason;
2973: if csr_offer_history_details%found then
2974: hr_utility.set_location(l_proc, 31);
2975: if l_status='CLOSED' and (l_close_reason = 'MGR_WITHDRAW' OR l_close_reason = 'WITHDRAWAL') then
2976: hr_utility.set_location(l_proc, 32);
2977: l_offer_status := NULL;
2978: else

Line 2976: hr_utility.set_location(l_proc, 32);

2972: fetch csr_offer_history_details into l_status,l_close_reason;
2973: if csr_offer_history_details%found then
2974: hr_utility.set_location(l_proc, 31);
2975: if l_status='CLOSED' and (l_close_reason = 'MGR_WITHDRAW' OR l_close_reason = 'WITHDRAWAL') then
2976: hr_utility.set_location(l_proc, 32);
2977: l_offer_status := NULL;
2978: else
2979: hr_utility.set_location(l_proc, 33);
2980: l_offer_status := 'CORRECTION';

Line 2979: hr_utility.set_location(l_proc, 33);

2975: if l_status='CLOSED' and (l_close_reason = 'MGR_WITHDRAW' OR l_close_reason = 'WITHDRAWAL') then
2976: hr_utility.set_location(l_proc, 32);
2977: l_offer_status := NULL;
2978: else
2979: hr_utility.set_location(l_proc, 33);
2980: l_offer_status := 'CORRECTION';
2981: end if;
2982: close csr_offer_history_details;
2983: else

Line 2984: hr_utility.set_location(l_proc, 34);

2980: l_offer_status := 'CORRECTION';
2981: end if;
2982: close csr_offer_history_details;
2983: else
2984: hr_utility.set_location(l_proc, 34);
2985: l_offer_status := 'CORRECTION';
2986: close csr_offer_history_details;
2987: end if;
2988: --

Line 2999: hr_utility.set_location(l_proc, 40);

2995: else
2996: handleAttachmentsWhenRejected(p_applicant_assignment_id=>l_applicant_assignment_id);
2997: l_offer_status := 'CLOSED';
2998: if p_event = 'REJECTED' then
2999: hr_utility.set_location(l_proc, 40);
3000: l_change_reason := 'APPROVER_REJECTED';
3001: else
3002: -- DELETE, CANCEL
3003: hr_utility.set_location(l_proc, 50);

Line 3003: hr_utility.set_location(l_proc, 50);

2999: hr_utility.set_location(l_proc, 40);
3000: l_change_reason := 'APPROVER_REJECTED';
3001: else
3002: -- DELETE, CANCEL
3003: hr_utility.set_location(l_proc, 50);
3004: l_change_reason := 'MANUAL_CLOSURE';
3005: end if;
3006: end if;
3007: end if;

Line 3010: hr_utility.set_location(l_proc || ' Offer Status:' || l_offer_status, 60);

3006: end if;
3007: end if;
3008: --
3009: if l_offer_status is not null then
3010: hr_utility.set_location(l_proc || ' Offer Status:' || l_offer_status, 60);
3011: update_offer
3012: (p_effective_date => l_effective_date
3013: ,p_offer_status => l_offer_status
3014: ,p_change_reason => l_change_reason

Line 3026: hr_utility.set_location('Exiting:' || l_proc,70);

3022: close csr_offer_details;
3023: end if;
3024: --
3025: p_return_status := l_return_status;
3026: hr_utility.set_location('Exiting:' || l_proc,70);
3027: --
3028: end finalize_transaction;
3029:
3030: -- ----------------------------------------------------------------------------

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

3075: PRAGMA AUTONOMOUS_TRANSACTION;
3076: --
3077: begin
3078: --
3079: hr_utility.set_location(' Entering:' || l_proc,10);
3080: --
3081: if p_applicant_assignment_id is null
3082: then
3083: --

Line 3138: hr_utility.set_location('Exiting:' || l_proc,20);

3134: exception
3135: when OTHERS then
3136: rollback;
3137: --
3138: hr_utility.set_location('Exiting:' || l_proc,20);
3139: --
3140: end void_ben_records;
3141:
3142: --

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

3147: procedure handleAttachmentsWhenCommit(p_applicant_assignment_id in number) is
3148: PRAGMA AUTONOMOUS_TRANSACTION;
3149: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
3150: begin
3151: hr_utility.set_location(' Entering:' || l_proc,10);
3152: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3153: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3154:
3155: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER',

Line 3173: hr_utility.set_location(' Exiting:' || l_proc,20);

3169:
3170: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3171: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3172: commit;
3173: hr_utility.set_location(' Exiting:' || l_proc,20);
3174: end;
3175: --
3176: -- ----------------------------------------------------------------------------
3177: -- |-----------------------------< handleAttachmentsWhenRejected >------------|

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

3180: procedure handleAttachmentsWhenRejected(p_applicant_assignment_id in number) is
3181: PRAGMA AUTONOMOUS_TRANSACTION;
3182: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
3183: begin
3184: hr_utility.set_location(' Entering:' || l_proc,10);
3185: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3186: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3187: commit;
3188: hr_utility.set_location(' Exiting:' || l_proc,20);

Line 3188: hr_utility.set_location(' Exiting:' || l_proc,20);

3184: hr_utility.set_location(' Entering:' || l_proc,10);
3185: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3186: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3187: commit;
3188: hr_utility.set_location(' Exiting:' || l_proc,20);
3189: end;
3190:
3191: -- ---------------------------------------------------------------------------
3192: -- |-----------------------------< handleAttachmentsWhenEditing >-------------|

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

3195: procedure handleAttachmentsWhenEdit(p_applicant_assignment_id in number) is
3196: PRAGMA AUTONOMOUS_TRANSACTION;
3197: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
3198: begin
3199: hr_utility.set_location(' Entering:' || l_proc,10);
3200:
3201: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3202: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3203:

Line 3219: hr_utility.set_location(' Exiting:' || l_proc,20);

3215: X_created_by => fnd_global.user_id,
3216: X_last_update_login=> fnd_global.login_id
3217: );
3218: commit;
3219: hr_utility.set_location(' Exiting:' || l_proc,20);
3220: end;
3221: --
3222: --
3223: -- ----------------------------------------------------------------------------