[Home] [Help]
164: l_offer_assignment csr_assignment_record%ROWTYPE;
165: --
166: Begin
167:
168: hr_utility.set_location('Entering:'||l_proc,10);
169: --
170: -- Issue a savepoint
171: --
172: savepoint CREATE_OFFER_ASSIGNMENT_COPY;
183: --
184: end if;
185: close csr_assignment_record;
186: --
187: hr_utility.set_location(l_proc,20);
188: --
189: hr_utility.set_location(l_proc,30);
190: --
191: --
185: close csr_assignment_record;
186: --
187: hr_utility.set_location(l_proc,20);
188: --
189: hr_utility.set_location(l_proc,30);
190: --
191: --
192: -- Truncate the time portion from all IN date parameters
193: --
200: --
201: l_assignment_type := 'O';
202: l_primary_flag := 'N';
203: --
204: hr_utility.set_location(l_proc,40);
205: --
206: -- Create Offer Assignment record
207: --
208: per_asg_ins.ins
317: ,p_grade_ladder_pgm_id => l_offer_assignment.grade_ladder_pgm_id
318: ,p_supervisor_assignment_id => l_offer_assignment.supervisor_assignment_id
319: );
320: --
321: hr_utility.set_location(l_proc, 50);
322: --
323: --
324: -- When in validation only mode raise the Validate_Enabled exception
325: --
328: end if;
329: --
330: p_offer_assignment_id := l_offer_assignment_id;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 60);
333: --
334: exception
335: when hr_api.validate_enabled then
336: --
340: -- we must rollback to the savepoint
341: --
342: rollback to CREATE_OFFER_ASSIGNMENT_COPY;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 70);
345: when others then
346: --
347: p_offer_assignment_id := null;
348: --
349: -- A validation or unexpected error has occured
350: --
351: rollback to CREATE_OFFER_ASSIGNMENT_COPY;
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 80);
354: raise;
355: end create_offer_assignment_copy;
356: --
357: -- ----------------------------------------------------------------------------
428: where tgt_apl_asg_id=p_applicant_assignment_id;
429: --
430: Begin
431: --
432: hr_utility.set_location('Entering:'||l_proc,10);
433: --
434: -- Since this procedure is called only when the status is changed
435: -- we do not need to see if the assignment_status_type_id is already
436: -- set to the required value.
443: if csr_assignment_ovn%notfound
444: then
445: close csr_assignment_ovn;
446: --
447: hr_utility.set_location(l_proc,70);
448: --
449: --
450: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
451: fnd_message.raise_error;
475: if csr_prev_assg_status_type%notfound
476: then
477: close csr_prev_assg_status_type;
478: --
479: hr_utility.set_location(l_proc,40);
480: --
481: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
482: fnd_message.raise_error;
483: --
493: --
494: elsif p_offer_status = 'EXTENDED'
495: then
496: --
497: hr_utility.set_location(l_proc,20);
498: --
499: -- Update the applicant assignment record and set the assignment
500: -- status type to 'Offer' ( assignment_status_type_id = 5 )
501: --
501: --
502: open csr_get_offer_user_status(l_business_group_id);
503: fetch csr_get_offer_user_status into l_assignment_status_type_id;
504: if csr_get_offer_user_status%notfound then
505: hr_utility.set_location(l_proc,21);
506: l_assignment_status_type_id := 5;
507: end if;
508: close csr_get_offer_user_status;
509: --
509: --
510: elsif p_offer_status = 'CLOSED'
511: then
512: --
513: hr_utility.set_location(l_proc,25);
514: --
515: if p_change_reason = 'EXPIRED'
516: or p_change_reason = 'APL_DECLINED'
517: then
519: -- If the offer has either expired or the applicant has declined the offer,
520: -- the applicant assignment status should be set to the assignment status
521: -- prior to offer.
522: --
523: hr_utility.set_location(l_proc,30);
524: --
525: -- In this scenario, we need to pick up the applicant assignment status
526: -- of the assignment record prior to the latest assignment record, becasue
527: -- the latest assignment record would have applicant assignment status = 'OFFER'
532: if csr_prev_assg_status_type%notfound
533: then
534: close csr_prev_assg_status_type;
535: --
536: hr_utility.set_location(l_proc,40);
537: --
538: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
539: fnd_message.raise_error;
540: --
554: --
555: elsif p_change_reason = 'APL_ACCEPTED'
556: then
557: --
558: hr_utility.set_location(l_proc,50);
559: --
560: -- if the offer has been accepted by the applicant, the applicant assignment
561: -- status should be set to 'Accepted' ( assignment_status_type_id = 6 )
562: --
562: --
563: open csr_get_accepted_user_status(l_business_group_id);
564: fetch csr_get_accepted_user_status into l_assignment_status_type_id;
565: if csr_get_accepted_user_status%notfound then
566: hr_utility.set_location(l_proc,51);
567: l_assignment_status_type_id := 6;
568: end if;
569: close csr_get_accepted_user_status;
570: --
576: --
577: if l_assignment_status_type_id <> -1
578: then
579: --
580: hr_utility.set_location(l_proc,60);
581: --
582: -- Decide the date track mode.
583: --
584: if l_effective_start_date = p_effective_date
583: --
584: if l_effective_start_date = p_effective_date
585: then
586: --
587: hr_utility.set_location(l_proc,80);
588: --
589: -- Since the current record has started today, we need to
590: -- correct the existing record.
591: --
591: --
592: l_datetrack_mode := hr_api.g_correction;
593: else
594: --
595: hr_utility.set_location(l_proc,90);
596: --
597: -- End the existing record and create a new record.
598: --
599: l_datetrack_mode := hr_api.g_update;
633: close csr_linked_base_asg;
634: --
635: end if;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 100);
638: --
639: exception
640: when others then
641: hr_utility.set_location(' Leaving:'||l_proc, 110);
637: hr_utility.set_location(' Leaving:'||l_proc, 100);
638: --
639: exception
640: when others then
641: hr_utility.set_location(' Leaving:'||l_proc, 110);
642: raise;
643: --
644: end update_appl_assg_status;
645: --
685: from per_all_assignments_f
686: where assignment_id = l_offer_assignment_id;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: open csr_offer_details;
692: fetch csr_offer_details into l_offer_assignment_id
693: ,l_object_version_number
701: --
702: end if;
703: close csr_offer_details;
704: --
705: hr_utility.set_location(l_proc,20);
706: --
707: -- Call upd with new offer_status value, new
708: -- latest_offer value.
709: --
722: if p_offer_status <> hr_api.g_varchar2
723: and p_offer_status <> l_updated_offer_status
724: then
725: --
726: hr_utility.set_location(l_proc, 50);
727: --
728: irc_offer_status_history_api.create_offer_status_history
729: ( p_validate => p_validate
730: ,p_effective_date => p_effective_date
744: if p_offer_status = 'CLOSED'
745: and p_offer_status <> l_updated_offer_status
746: then
747: --
748: hr_utility.set_location(l_proc, 60);
749: --
750: open csr_assignment_ovn;
751: fetch csr_assignment_ovn into l_asg_object_version_number;
752: if csr_assignment_ovn%notfound
751: fetch csr_assignment_ovn into l_asg_object_version_number;
752: if csr_assignment_ovn%notfound
753: then
754: --
755: hr_utility.set_location(l_proc, 65);
756: --
757: close csr_assignment_ovn;
758: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
759: fnd_message.raise_error;
777: );
778: --
779: end if;
780: --
781: hr_utility.set_location(' Leaving:'||l_proc, 70);
782: --
783: exception
784: when others then
785: hr_utility.set_location(' Leaving:'||l_proc, 80);
781: hr_utility.set_location(' Leaving:'||l_proc, 70);
782: --
783: exception
784: when others then
785: hr_utility.set_location(' Leaving:'||l_proc, 80);
786: raise;
787: end update_latest_offer_flag;
788: --
789: -- ----------------------------------------------------------------------------
956:
957: l_offer_assignment csr_assignment_record%ROWTYPE;
958: --
959: Begin
960: hr_utility.set_location('Entering:'||l_proc,10);
961: --
962: -- Issue a savepoint
963: --
964: savepoint COPY_OFFER_ASG_TO_APPL_ASG;
989: --
990: end if;
991: close csr_assignment_record;
992: --
993: hr_utility.set_location(l_proc,20);
994: --
995: --
996: -- Truncate the time portion from all IN date parameters
997: --
1015: --
1016: if ( l_effective_start_date = trunc(sysdate) )
1017: then
1018: --
1019: hr_utility.set_location(l_proc,30);
1020: --
1021: -- Since the applicant assignment record is being modified multiple
1022: -- times on the same day, the datetrack mode should be correction.
1023: --
1024: l_datetrack_mode := hr_api.g_correction;
1025: --
1026: end if;
1027: --
1028: hr_utility.set_location(l_proc,40);
1029: --
1030: -- Copy the Offer Assignment details into Applicant Assignment record
1031: --
1032: per_asg_upd.upd
1149: ,p_datetrack_mode => l_datetrack_mode
1150: ,p_validate => p_validate
1151: );
1152: --
1153: hr_utility.set_location(l_proc, 50);
1154: --
1155: --
1156: -- When in validation only mode raise the Validate_Enabled exception
1157: --
1158: if p_validate then
1159: raise hr_api.validate_enabled;
1160: end if;
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 60);
1163: --
1164: exception
1165: when hr_api.validate_enabled then
1166: --
1168: -- we must rollback to the savepoint
1169: --
1170: rollback to COPY_OFFER_ASG_TO_APPL_ASG;
1171: --
1172: hr_utility.set_location(' Leaving:'||l_proc, 70);
1173: when others then
1174: --
1175: -- A validation or unexpected error has occured
1176: --
1175: -- A validation or unexpected error has occured
1176: --
1177: rollback to COPY_OFFER_ASG_TO_APPL_ASG;
1178: --
1179: hr_utility.set_location(' Leaving:'||l_proc, 80);
1180: raise;
1181: end copy_offer_asg_to_appl_asg;
1182: --
1183: -- ----------------------------------------------------------------------------
1277:
1278: l_pay_proposal_record csr_pay_proposal_record%ROWTYPE;
1279: --
1280: Begin
1281: hr_utility.set_location('Entering:'||l_proc,10);
1282: --
1283: -- Issue a savepoint
1284: --
1285: savepoint COPY_OFFER_PAY_TO_APPL_PAY;
1304: --
1305: if csr_appl_pay_proposal%notfound
1306: then
1307: --
1308: hr_utility.set_location(l_proc,30);
1309: --
1310: -- Pay Proposal does not exist for this applicant.
1311: -- Hence create a new pay proposal record.
1312: --
1321: --
1322: if csr_pay_proposal_record%found
1323: then
1324: --
1325: hr_utility.set_location(l_proc,40);
1326: --
1327: -- We need to copy the pay proposal details to the record corresponding
1328: -- to applicant assignment only if the pay proposal record exists for
1329: -- offer assignment.
1379: close csr_pay_proposal_record;
1380: --
1381: else
1382: --
1383: hr_utility.set_location(l_proc,45);
1384: --
1385: --
1386: close csr_pay_proposal_record;
1387: --
1388: open csr_pay_proposal_record(l_applicant_assignment_id);
1389: fetch csr_pay_proposal_record into l_pay_proposal_record;
1390: if csr_pay_proposal_record%found then
1391: --
1392: hr_utility.set_location(l_proc,46);
1393: --
1394: hr_maintain_proposal_api.delete_salary_proposal
1395: (p_validate => p_validate
1396: ,p_pay_proposal_id => l_pay_proposal_record.pay_proposal_id
1404: close csr_pay_proposal_record;
1405: --
1406: end if;
1407: --
1408: hr_utility.set_location(l_proc, 50);
1409: --
1410: -- When in validation only mode raise the Validate_Enabled exception
1411: --
1412: if p_validate then
1412: if p_validate then
1413: raise hr_api.validate_enabled;
1414: end if;
1415: --
1416: hr_utility.set_location(' Leaving:'||l_proc, 60);
1417: --
1418: exception
1419: when hr_api.validate_enabled then
1420: --
1422: -- we must rollback to the savepoint
1423: --
1424: rollback to COPY_OFFER_PAY_TO_APPL_PAY;
1425: --
1426: hr_utility.set_location(' Leaving:'||l_proc, 70);
1427: when others then
1428: --
1429: -- A validation or unexpected error has occured
1430: --
1429: -- A validation or unexpected error has occured
1430: --
1431: rollback to COPY_OFFER_PAY_TO_APPL_PAY;
1432: --
1433: hr_utility.set_location(' Leaving:'||l_proc, 80);
1434: raise;
1435: end copy_offer_pay_to_appl_pay;
1436: --
1437: -- ----------------------------------------------------------------------------
1580: --
1581: begin
1582: --
1583: --
1584: hr_utility.set_location(' Entering:'||l_proc,10);
1585: --
1586: savepoint CLOSE_NOTIFICATIONS;
1587: --
1588: -- Close if any SFL notifications exists
1589: open csr_get_sfl_txn_details;
1590: fetch csr_get_sfl_txn_details into l_transaction_id,l_item_type,l_item_key;
1591: if csr_get_sfl_txn_details%found then
1592: --
1593: hr_utility.set_location(' SFL Transaction Found '||l_proc,20);
1594: hr_transaction_api.rollback_transaction(
1595: p_transaction_id => l_transaction_id);
1596: --
1597: hr_utility.set_location(' Rolled back SFL Transaction '||l_proc,30);
1593: hr_utility.set_location(' SFL Transaction Found '||l_proc,20);
1594: hr_transaction_api.rollback_transaction(
1595: p_transaction_id => l_transaction_id);
1596: --
1597: hr_utility.set_location(' Rolled back SFL Transaction '||l_proc,30);
1598: --
1599: if l_item_key is not null then
1600: wf_engine.abortprocess(itemtype => l_item_type
1601: ,itemkey => l_item_key
1604: ,verify_lock=> true
1605: ,cascade=> true);
1606: end if;
1607: --
1608: hr_utility.set_location(' Cancelled SFL notification '||l_proc,40);
1609: --
1610: end if;
1611: close csr_get_sfl_txn_details;
1612: --
1614: open csr_get_txn_details;
1615: fetch csr_get_txn_details into l_transaction_id,l_item_type,l_item_key;
1616: if csr_get_txn_details%found then
1617: --
1618: hr_utility.set_location(' API Transaction Found '||l_proc,50);
1619: hr_transaction_api.rollback_transaction(
1620: p_transaction_id => l_transaction_id);
1621: --
1622: hr_utility.set_location(' Rolled back API Transaction '||l_proc,60);
1618: hr_utility.set_location(' API Transaction Found '||l_proc,50);
1619: hr_transaction_api.rollback_transaction(
1620: p_transaction_id => l_transaction_id);
1621: --
1622: hr_utility.set_location(' Rolled back API Transaction '||l_proc,60);
1623: --
1624: if l_item_key is not null then
1625: wf_engine.abortprocess(itemtype => l_item_type
1626: ,itemkey => l_item_key
1629: ,verify_lock=> true
1630: ,cascade=> true);
1631: end if;
1632: --
1633: hr_utility.set_location(' Cancelled Open notification '||l_proc,70);
1634: --
1635: end if;
1636: close csr_get_txn_details;
1637: --
1639: --
1640: exception
1641: when others then
1642: rollback to CLOSE_NOTIFICATIONS;
1643: hr_utility.set_location(' Leaving: '||l_proc, 80);
1644: raise;
1645: end close_notifications;
1646: --
1647: -- ----------------------------------------------------------------------------
1745: )
1746: );
1747: --
1748: begin
1749: hr_utility.set_location('Entering:'|| l_proc, 10);
1750: --
1751: -- Issue a savepoint
1752: --
1753: savepoint CREATE_OFFER;
1761: l_status_change_date := p_status_change_date;
1762: --
1763: g_src_apl_asg_id := p_src_apl_asg_id;
1764: --
1765: hr_utility.set_location(l_proc,20);
1766: --
1767: -- If a prev offer exists for this applicant assignment, we need
1768: -- to close it and set this offer as the Latest.
1769: --
1776: fetch csr_latest_offer into l_updated_offer_id
1777: ,l_updated_offer_status
1778: ,l_updated_appl_assignment_id;
1779: --
1780: hr_utility.set_location(l_proc,40);
1781: --
1782: if (csr_latest_offer%found)
1783: then
1784: --
1783: then
1784: --
1785: close csr_latest_offer;
1786: --
1787: hr_utility.set_location(l_proc,45);
1788: --
1789: -- Set the offer_status of the record to be
1790: -- updated to 'Closed', the latest_offer
1791: -- to 'N' and change_reason to 'Offer Updated'
1824: -- This offer should now be the latest offer
1825: --
1826: l_latest_offer := 'Y';
1827: --
1828: hr_utility.set_location(l_proc,48);
1829: --
1830: -- Call Before Process User Hook
1831: --
1832: begin
1946: , p_offer_id => l_offer_id
1947: , p_offer_version => l_offer_version
1948: , p_object_version_number => l_object_version_number
1949: );
1950: hr_utility.set_location(l_proc,50);
1951: --
1952: -- Create offer history record for the newly created
1953: -- Offer record.
1954: --
1963: , p_note_text => null
1964: , p_object_version_number => l_osh_object_version_number
1965: , p_status_change_date => l_status_change_date
1966: );
1967: hr_utility.set_location(l_proc,60);
1968: --
1969: -- Call After Process User Hook
1970: --
1971: begin
2041: p_offer_id := l_offer_id;
2042: p_object_version_number := l_object_version_number;
2043: p_offer_version := l_offer_version;
2044: --
2045: hr_utility.set_location(' Leaving:'||l_proc, 70);
2046: exception
2047: when hr_api.validate_enabled then
2048: --
2049: -- As the Validate_Enabled exception has been raised
2058: p_offer_id := null;
2059: p_offer_version := null;
2060: p_object_version_number := null;
2061: --
2062: hr_utility.set_location(' Leaving:'||l_proc, 80);
2063: when others then
2064: --
2065: -- Reset IN OUT parameters and set all
2066: -- OUT parameters, including warnings, to null
2072: -- A validation or unexpected error has occured
2073: --
2074: rollback to CREATE_OFFER;
2075: --
2076: hr_utility.set_location(' Leaving:'||l_proc, 90);
2077: raise;
2078: end create_offer;
2079: --
2080: -- ----------------------------------------------------------------------------
2278: l_temp_offer_record csr_offer_record%ROWTYPE;
2279: --
2280: --
2281: begin
2282: hr_utility.set_location('Entering:'|| l_proc, 10);
2283: --
2284: -- Issue a savepoint
2285: --
2286: savepoint UPDATE_OFFER;
2376: --
2377: --
2378: -- l_create_new_version := true;
2379: --
2380: hr_utility.set_location(l_proc,50);
2381: --
2382: -- 'CLOSED' offer can be updated under only 1 circumstance:
2383: -- 1) The offer duration has been Extended
2384: --
2481: end if; -- offer_status = 'EXTENDED'
2482: --
2483: end if; -- prev_offer_status = 'CLOSED'
2484: --
2485: hr_utility.set_location(l_proc,60);
2486: --
2487: -- If l_create_new_version is true, a new offer version should be
2488: -- created and the current offer version should be closed.
2489: --
2489: --
2490: if l_create_new_version = true
2491: then
2492: --
2493: hr_utility.set_location(l_proc,70);
2494: --
2495: -- Fetch the previous offer version's record.
2496: --
2497: open csr_offer_record;
2499: --
2500: if csr_offer_record%notfound
2501: then
2502: --
2503: hr_utility.set_location(l_proc, 75);
2504: --
2505: close csr_offer_record;
2506: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2507: fnd_message.raise_error;
2697: end if;
2698: --
2699: -- Create a new offer assignment copied from prev offer assignment.
2700: --
2701: hr_utility.set_location(l_proc,77);
2702: --
2703: create_offer_assignment_copy
2704: ( p_validate => p_validate
2705: , p_effective_date => l_effective_date
2763: ,p_offer_version => l_offer_version
2764: ,p_object_version_number => l_object_version_number
2765: );
2766: --
2767: hr_utility.set_location(' Leaving:'||l_proc, 78);
2768: --
2769: else -- l_create_new_version = false
2770: --
2771: -- Proceed with normal Update.
2908: -- Check if the change_reason is 'WITHDRAWAL'. If yes, close
2909: -- the offer irrespective of the current offer status.
2910: -- Else, check for the current offer_status.
2911: --
2912: hr_utility.set_location(l_proc,100);
2913: --
2914: if (( p_change_reason = 'EXPIRED'
2915: OR p_change_reason = 'APL_DECLINED'
2916: OR p_change_reason = 'APL_ACCEPTED'
2920: AND l_prev_offer_status <> 'PENDING_EXTENDED')
2921: )
2922: then
2923: --
2924: hr_utility.set_location(l_proc,105);
2925: --
2926: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2927: fnd_message.raise_error;
2928: --
2931: if ( p_change_reason <> 'WITHDRAWAL'
2932: OR p_change_reason is null -- Null check
2933: ) then
2934: --
2935: hr_utility.set_location(l_proc,110);
2936: --
2937: -- Check to see if the offer status is Closed. If yes,
2938: -- throw an error saying that the offer cannot be closed.
2939: --
2939: --
2940: if ( l_prev_offer_status = 'CLOSED'
2941: ) then
2942: --
2943: hr_utility.set_location(l_proc,120);
2944: --
2945: -- Close offer can be called on a closed offer with change
2946: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2947: --
2980: if l_prev_offer_status = 'PENDING_EXTENDED'
2981: and l_offer_status = 'EXTENDED'
2982: then
2983: --
2984: hr_utility.set_location(l_proc,122);
2985: --
2986: -- pass in old status PENDING_EXTENDED to this method
2987: irc_iof_bus.chk_multiple_fields_updated
2988: ( p_mutiple_fields_updated => l_mutiple_fields_updated
3036: --
3037: if ( l_mutiple_fields_updated = false )
3038: then
3039: --
3040: hr_utility.set_location(l_proc,125);
3041: --
3042: l_offer_status := 'EXTENDED';
3043: --
3044: else
3049: end if;
3050: --
3051: end if;
3052:
3053: hr_utility.set_location(l_proc,130);
3054: --
3055: irc_iof_upd.upd
3056: ( p_effective_date => l_effective_date
3057: , p_offer_id => l_offer_id
3163: (l_expiry_date = hr_api.g_date)
3164: )
3165: then
3166: --
3167: hr_utility.set_location(l_proc,140);
3168: --
3169: irc_offer_status_history_api.create_offer_status_history
3170: ( p_validate => p_validate
3171: , p_effective_date => l_effective_date
3181: --
3182: -- Also, if the offer status has changed, call update_appl_assg_status
3183: -- to set the appropriate Assignment Status for the application.
3184: --
3185: hr_utility.set_location(l_proc,141);
3186: --
3187: irc_offers_api.update_appl_assg_status
3188: ( p_validate => p_validate
3189: , p_effective_date => l_effective_date
3197: -- assignment again
3198: if l_offer_status = 'CLOSED' and l_prev_offer_status<>'CLOSED'
3199: then
3200: --
3201: hr_utility.set_location(l_proc,142);
3202: --
3203: if trunc(l_effective_end_date) = hr_api.g_eot then
3204: --
3205: hr_utility.set_location('Delete the offer assignment ',143);
3201: hr_utility.set_location(l_proc,142);
3202: --
3203: if trunc(l_effective_end_date) = hr_api.g_eot then
3204: --
3205: hr_utility.set_location('Delete the offer assignment ',143);
3206: per_asg_del.del
3207: (
3208: p_assignment_id => l_prev_offer_assignment_id
3209: ,p_effective_start_date => l_effective_start_date
3216: ,p_datetrack_mode => hr_api.g_delete
3217: ,p_validate => p_validate
3218: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3219: );
3220: hr_utility.set_location('After deleting the offer assignment ',144);
3221: --
3222: else
3223: --
3224: hr_utility.set_location(l_proc,145);
3220: hr_utility.set_location('After deleting the offer assignment ',144);
3221: --
3222: else
3223: --
3224: hr_utility.set_location(l_proc,145);
3225: hr_utility.set_location('Offer assignment is not active ',146);
3226: --
3227: end if;
3228: end if;
3221: --
3222: else
3223: --
3224: hr_utility.set_location(l_proc,145);
3225: hr_utility.set_location('Offer assignment is not active ',146);
3226: --
3227: end if;
3228: end if;
3229: --
3362: p_offer_id := l_offer_id;
3363: p_object_version_number := l_object_version_number;
3364: p_offer_version := l_offer_version;
3365: --
3366: hr_utility.set_location(' Leaving:'||l_proc, 145);
3367: --
3368: exception
3369: when hr_api.validate_enabled then
3370: --
3380: -- we must rollback to the savepoint
3381: --
3382: rollback to UPDATE_OFFER;
3383: --
3384: hr_utility.set_location(' Leaving:'||l_proc, 150);
3385: when others then
3386: --
3387: -- Reset IN OUT parameters and set all
3388: -- OUT parameters, including warnings, to null
3394: -- A validation or unexpected error has occured
3395: --
3396: rollback to UPDATE_OFFER;
3397: --
3398: hr_utility.set_location(' Leaving:'||l_proc, 160);
3399: raise;
3400: end update_offer;
3401: --
3402: -- ----------------------------------------------------------------------------
3451: from per_all_assignments_f
3452: where assignment_id = l_offer_assignment_id;
3453: --
3454: begin
3455: hr_utility.set_location('Entering:'|| l_proc, 10);
3456: --
3457: -- Issue a savepoint
3458: --
3459: savepoint DELETE_OFFER;
3567: --
3568: open csr_latest_offer;
3569: fetch csr_latest_offer into l_offer_id, l_offer_status;
3570: --
3571: hr_utility.set_location(l_proc,20);
3572: --
3573: if (csr_latest_offer%found)
3574: then
3575: close csr_latest_offer;
3623: --
3624: -- Set all output arguments
3625: --
3626: --
3627: hr_utility.set_location(' Leaving:'||l_proc, 50);
3628: exception
3629: when hr_api.validate_enabled then
3630: --
3631: -- As the Validate_Enabled exception has been raised
3636: -- Only set output warning arguments
3637: -- (Any key or derived arguments must be set to null
3638: -- when validation only mode is being used.)
3639: --
3640: hr_utility.set_location(' Leaving:'||l_proc, 60);
3641: when others then
3642: --
3643: -- A validation or unexpected error has occured
3644: --
3642: --
3643: -- A validation or unexpected error has occured
3644: --
3645: rollback to DELETE_OFFER;
3646: hr_utility.set_location(' Leaving:'||l_proc, 70);
3647: raise;
3648: end delete_offer;
3649: --
3650: --
3685: and usr.user_id = fnd_global.user_id;
3686: --
3687: begin
3688: --
3689: hr_utility.set_location(' Entering: '|| l_proc, 10);
3690: --
3691: OPEN csr_applicant_userid
3692: (p_assignment_id => p_applicant_assignment_id
3693: ,p_effective_date => p_effective_date
3698: l_manager_terminates:='Y';
3699: END IF;
3700: CLOSE csr_applicant_userid;
3701: --
3702: hr_utility.set_location('l_user_id: '||l_user_id,20);
3703: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
3704: --
3705: if l_user_id=fnd_global.user_id then
3706: l_manager_terminates:='N';
3699: END IF;
3700: CLOSE csr_applicant_userid;
3701: --
3702: hr_utility.set_location('l_user_id: '||l_user_id,20);
3703: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
3704: --
3705: if l_user_id=fnd_global.user_id then
3706: l_manager_terminates:='N';
3707: else
3717: else
3718: l_change_reason := 'WITHDRAWAL';
3719: end if;
3720: --
3721: hr_utility.set_location(' l_change_reason: '||l_change_reason,40);
3722: hr_utility.set_location(' Leaving: '|| l_proc, 50);
3723: --
3724: RETURN l_change_reason;
3725: end get_offer_close_reason;
3718: l_change_reason := 'WITHDRAWAL';
3719: end if;
3720: --
3721: hr_utility.set_location(' l_change_reason: '||l_change_reason,40);
3722: hr_utility.set_location(' Leaving: '|| l_proc, 50);
3723: --
3724: RETURN l_change_reason;
3725: end get_offer_close_reason;
3726: --
3780: where offer_id = l_offer_id;
3781: --
3782: Begin
3783: --
3784: hr_utility.set_location('Entering:'||l_proc,10);
3785: --
3786: -- issue a savepoint
3787: --
3788: savepoint CLOSE_OFFER;
3796: --
3797: if (p_offer_id is not null)
3798: then
3799: --
3800: hr_utility.set_location(l_proc,20);
3801: --
3802: open csr_offer_assignment_2;
3803: fetch csr_offer_assignment_2 into l_offer_assignment_id
3804: ,l_prev_offer_status;
3823: -- offer_id for that record is.
3824: --
3825: l_offer_assignment_exists := false;
3826: --
3827: hr_utility.set_location(l_proc,30);
3828: --
3829: open csr_offer_assignment_1;
3830: fetch csr_offer_assignment_1 into l_offer_assignment_id
3831: ,l_offer_id
3838: --
3839: if csr_offer_assignment_1%found
3840: then
3841: --
3842: hr_utility.set_location(l_proc,40);
3843: --
3844: close csr_offer_assignment_1;
3845: --
3846: -- Set the variable l_offer_assignment_exists to true;
3850: else
3851: close csr_offer_assignment_1;
3852: end if;
3853: --
3854: hr_utility.set_location(l_proc,50);
3855: --
3856: end if;
3857: --
3858: hr_utility.set_location(l_proc,60);
3854: hr_utility.set_location(l_proc,50);
3855: --
3856: end if;
3857: --
3858: hr_utility.set_location(l_proc,60);
3859: --
3860: -- Check if the offer assginment exists. Only if it exists call the
3861: -- update_offer the close the offer and end date the offer assignment.
3862: --
3862: --
3863: if l_offer_assignment_exists = true
3864: then
3865: --
3866: hr_utility.set_location(l_proc,65);
3867: --
3868: -- Fetch Offer OVN
3869: --
3870: open csr_iof_object_version_number;
3912: end if;
3913: --
3914: end if;
3915: --
3916: hr_utility.set_location(l_proc,70);
3917: --
3918: end if;
3919: --
3920: -- check if there are any SAVED offers for this applicant assignment ID.
3948: --
3949: end if;
3950:
3951: --
3952: hr_utility.set_location(l_proc,90);
3953: --
3954: -- When in validation only mode raise the Validate_Enabled exception
3955: --
3956: if p_validate then
3956: if p_validate then
3957: raise hr_api.validate_enabled;
3958: end if;
3959: --
3960: hr_utility.set_location(' Leaving:'||l_proc, 100);
3961: exception
3962: when hr_api.validate_enabled then
3963: --
3964: -- As the Validate_Enabled exception has been raised
3965: -- we must rollback to the savepoint
3966: --
3967: rollback to CLOSE_OFFER;
3968: --
3969: hr_utility.set_location(' Leaving:'||l_proc, 110);
3970: when others then
3971: --
3972: -- A validation or unexpected error has occured
3973: --
3972: -- A validation or unexpected error has occured
3973: --
3974: rollback to CLOSE_OFFER;
3975: --
3976: hr_utility.set_location(' Leaving:'||l_proc, 120);
3977: raise;
3978: end close_offer;
3979: --
3980: --
3997: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3998: l_offer_version irc_offers.offer_version%TYPE;
3999: --
4000: Begin
4001: hr_utility.set_location('Entering:'||l_proc,10);
4002: --
4003: -- Call update_offer with offer_status = 'HOLD'
4004: --
4005: update_offer
4016: );
4017: --
4018: exception
4019: when others then
4020: hr_utility.set_location(' Leaving:'||l_proc, 30);
4021: raise;
4022: end hold_offer;
4023: --
4024: -- ----------------------------------------------------------------------------
4079: where offer_id = p_offer_id;
4080: --
4081: Begin
4082: --
4083: hr_utility.set_location('Entering:'||l_proc,10);
4084: --
4085: -- Check if the offer is currently in HOLD
4086: --
4087: open csr_prev_offer_status;
4204: end if;
4205: --
4206: exception
4207: when others then
4208: hr_utility.set_location(' Leaving:'||l_proc, 30);
4209: raise;
4210: end release_offer;
4211: --
4212: -- ----------------------------------------------------------------------------
4361: l_projected_assignment_end date;
4362: l_effective_date date;
4363: Begin
4364:
4365: hr_utility.set_location('Entering:'||l_proc,10);
4366: --
4367: -- Issue a savepoint
4368: --
4369: savepoint CREATE_OFFER_ASSIGNMENT;
4367: -- Issue a savepoint
4368: --
4369: savepoint CREATE_OFFER_ASSIGNMENT;
4370: --
4371: hr_utility.set_location(l_proc,20);
4372: --
4373: --
4374: -- Truncate the time portion from all IN date parameters
4375: --
4384: --
4385: l_assignment_type := 'O';
4386: l_primary_flag := 'N';
4387: --
4388: hr_utility.set_location(l_proc,40);
4389: --
4390: -- Create Offer Assignment record
4391: --
4392: per_asg_ins.ins
4508: ,p_po_line_id => p_po_line_id
4509: ,p_projected_assignment_end => p_projected_assignment_end
4510: );
4511: --
4512: hr_utility.set_location(l_proc, 50);
4513: --
4514: --
4515: -- When in validation only mode raise the Validate_Enabled exception
4516: --
4529: p_object_version_number := l_object_version_number;
4530: p_other_manager_warning := l_other_manager_warning;
4531: p_hourly_salaried_warning := l_hourly_salaried_warning;
4532: --
4533: hr_utility.set_location(' Leaving:'||l_proc, 60);
4534: --
4535: exception
4536: when hr_api.validate_enabled then
4537: --
4547: -- we must rollback to the savepoint
4548: --
4549: rollback to CREATE_OFFER_ASSIGNMENT;
4550: --
4551: hr_utility.set_location(' Leaving:'||l_proc, 70);
4552: when others then
4553: --
4554: p_assignment_id := null;
4555: p_effective_start_date := null;
4562: -- A validation or unexpected error has occured
4563: --
4564: rollback to CREATE_OFFER_ASSIGNMENT;
4565: --
4566: hr_utility.set_location(' Leaving:'||l_proc, 80);
4567: raise;
4568: end create_offer_assignment;
4569: --
4570: -- ----------------------------------------------------------------------------
4795:
4796: l_offer_record csr_offer_record%ROWTYPE;
4797: --
4798: Begin
4799: hr_utility.set_location('Entering:'|| l_proc, 10);
4800: --
4801: -- Issue a savepoint
4802: --
4803: savepoint UPDATE_OFFER_ASSIGNMENT;
4813: --
4814: if csr_prev_offer_details%notfound
4815: then
4816: --
4817: hr_utility.set_location(l_proc, 20);
4818: --
4819: close csr_prev_offer_details;
4820: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4821: fnd_message.raise_error;
4854: if l_prev_offer_status = 'HOLD'
4855: OR p_offer_status = 'HOLD'
4856: then
4857: --
4858: hr_utility.set_location(l_proc, 25);
4859: --
4860: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4861: fnd_message.raise_error;
4862: --
4863: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4864: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')
4865: then
4866: --
4867: hr_utility.set_location(l_proc, 30);
4868: --
4869: -- The code to check new offer version creation has been disabled
4870: -- since this will now be taken care of in the Java Layer itself.
4871: -- New Offer version creation code is no longer supported.
4880: --
4881: if l_create_new_version = true
4882: then
4883: --
4884: hr_utility.set_location(l_proc, 40);
4885: --
4886: -- close the current offer and offer assignment.
4887: --
4888: close_offer
4900: --
4901: if csr_offer_record%notfound
4902: then
4903: --
4904: hr_utility.set_location(l_proc, 50);
4905: --
4906: close csr_offer_record;
4907: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4908: fnd_message.raise_error;
4975: l_datetrack_mode := hr_api.g_correction;
4976: --
4977: end if; -- l_create_new_version
4978: --
4979: hr_utility.set_location(l_proc, 60);
4980: --
4981: -- update the offer assignment record.
4982: --
4983: per_asg_upd.upd
5132: p_validation_end_date := l_validation_end_date;
5133: p_offer_id := l_offer_id;
5134: p_asg_object_version_number := l_asg_object_version_number;
5135:
5136: hr_utility.set_location(' Leaving:'||l_proc, 145);
5137: --
5138: exception
5139: when hr_api.validate_enabled then
5140: --
5161: p_validation_end_date := l_validation_end_date;
5162: p_offer_id := l_offer_id;
5163: p_asg_object_version_number := l_asg_object_version_number;
5164: --
5165: hr_utility.set_location(' Leaving:'||l_proc, 150);
5166: when others then
5167: --
5168: -- Reset IN OUT parameters and set all
5169: -- OUT parameters, including warnings, to null
5186: -- A validation or unexpected error has occured
5187: --
5188: rollback to UPDATE_OFFER_ASSIGNMENT;
5189: --
5190: hr_utility.set_location(' Leaving:'||l_proc, 160);
5191: raise;
5192: end update_offer_assignment;
5193: --
5194: --
5212: from irc_offers
5213: where offer_assignment_id = p_offer_assignment_id;
5214: --
5215: Begin
5216: hr_utility.set_location('Entering:'|| l_proc, 10);
5217: --
5218: -- Issue a savepoint
5219: --
5220: savepoint DELETE_OFFER_ASSIGNMENT;
5224: --
5225: if csr_offer_id%notfound
5226: then
5227: --
5228: hr_utility.set_location(l_proc, 20);
5229: --
5230: close csr_offer_id;
5231: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
5232: fnd_message.raise_error;
5237: -- If the offer is valid, call the delete procedure of offer
5238: -- so that both the offer record and the offer assignment
5239: -- record are deleted.
5240: --
5241: hr_utility.set_location(l_proc, 30);
5242: --
5243: delete_offer
5244: ( p_validate => p_validate
5245: ,p_object_version_number => l_offer_object_version_number
5253: if p_validate then
5254: raise hr_api.validate_enabled;
5255: end if;
5256: --
5257: hr_utility.set_location(' Leaving:'||l_proc, 40);
5258: --
5259: exception
5260: when hr_api.validate_enabled then
5261: --
5267: -- Only set output warning arguments
5268: -- (Any key or derived arguments must be set to null
5269: -- when validation only mode is being used.)
5270: --
5271: hr_utility.set_location(' Leaving:'||l_proc, 60);
5272: when others then
5273: --
5274: -- A validation or unexpected error has occured
5275: --
5273: --
5274: -- A validation or unexpected error has occured
5275: --
5276: rollback to DELETE_OFFER_ASSIGNMENT;
5277: hr_utility.set_location(' Leaving:'||l_proc, 70);
5278: raise;
5279: end delete_offer_assignment;
5280: --
5281: --
5292: --
5293: l_proc varchar2(72) := g_package||'upload_offer_letter';
5294: --
5295: Begin
5296: hr_utility.set_location('Entering:'|| l_proc, 10);
5297: --
5298: -- Issue a savepoint
5299: --
5300: savepoint UPLOAD_OFFER_LETTER;
5300: savepoint UPLOAD_OFFER_LETTER;
5301: --
5302: -- Call blob_dml to pass on the blob to be uploaded
5303: --
5304: hr_utility.set_location(l_proc, 30);
5305: --
5306: irc_iof_shd.blob_dml
5307: ( p_offer_letter => p_offer_letter
5308: ,p_offer_id => p_offer_id
5314: if p_validate then
5315: raise hr_api.validate_enabled;
5316: end if;
5317: --
5318: hr_utility.set_location(' Leaving:'||l_proc, 40);
5319: exception
5320: when hr_api.validate_enabled then
5321: --
5322: -- As the Validate_Enabled exception has been raised
5323: -- we must rollback to the savepoint
5324: --
5325: rollback to UPLOAD_OFFER_LETTER;
5326: --
5327: hr_utility.set_location(' Leaving:'||l_proc, 50);
5328: when others then
5329: --
5330: -- A validation or unexpected error has occured
5331: --
5329: --
5330: -- A validation or unexpected error has occured
5331: --
5332: rollback to UPLOAD_OFFER_LETTER;
5333: hr_utility.set_location(' Leaving:'||l_proc, 60);
5334: raise;
5335: end upload_offer_letter;
5336: --
5337: end IRC_OFFERS_API;