[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: -- ----------------------------------------------------------------------------
400: and ias2.assignment_status_type_id not in (5,6));
401: --
402: Begin
403: --
404: hr_utility.set_location('Entering:'||l_proc,10);
405: --
406: -- Since this procedure is called only when the status is changed
407: -- we do not need to see if the assignment_status_type_id is already
408: -- set to the required value.
414: if csr_assignment_ovn%notfound
415: then
416: close csr_assignment_ovn;
417: --
418: hr_utility.set_location(l_proc,70);
419: --
420: --
421: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
422: fnd_message.raise_error;
446: if csr_prev_assg_status_type%notfound
447: then
448: close csr_prev_assg_status_type;
449: --
450: hr_utility.set_location(l_proc,40);
451: --
452: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
453: fnd_message.raise_error;
454: --
464: --
465: elsif p_offer_status = 'EXTENDED'
466: then
467: --
468: hr_utility.set_location(l_proc,20);
469: --
470: -- Update the applicant assignment record and set the assignment
471: -- status type to 'Offer' ( assignment_status_type_id = 5 )
472: --
474: --
475: elsif p_offer_status = 'CLOSED'
476: then
477: --
478: hr_utility.set_location(l_proc,25);
479: --
480: if p_change_reason = 'EXPIRED'
481: or p_change_reason = 'APL_DECLINED'
482: then
484: -- If the offer has either expired or the applicant has declined the offer,
485: -- the applicant assignment status should be set to the assignment status
486: -- prior to offer.
487: --
488: hr_utility.set_location(l_proc,30);
489: --
490: -- In this scenario, we need to pick up the applicant assignment status
491: -- of the assignment record prior to the latest assignment record, becasue
492: -- the latest assignment record would have applicant assignment status = 'OFFER'
497: if csr_prev_assg_status_type%notfound
498: then
499: close csr_prev_assg_status_type;
500: --
501: hr_utility.set_location(l_proc,40);
502: --
503: fnd_message.set_name('PER','IRC_412006_ASG_NOT_APPL');
504: fnd_message.raise_error;
505: --
510: --
511: elsif p_change_reason = 'APL_ACCEPTED'
512: then
513: --
514: hr_utility.set_location(l_proc,50);
515: --
516: -- if the offer has been accepted by the applicant, the applicant assignment
517: -- status should be set to 'Accepted' ( assignment_status_type_id = 6 )
518: --
526: --
527: if l_assignment_status_type_id <> -1
528: then
529: --
530: hr_utility.set_location(l_proc,60);
531: --
532: -- Decide the date track mode.
533: --
534: if l_effective_start_date = p_effective_date
533: --
534: if l_effective_start_date = p_effective_date
535: then
536: --
537: hr_utility.set_location(l_proc,80);
538: --
539: -- Since the current record has started today, we need to
540: -- correct the existing record.
541: --
541: --
542: l_datetrack_mode := hr_api.g_correction;
543: else
544: --
545: hr_utility.set_location(l_proc,90);
546: --
547: -- End the existing record and create a new record.
548: --
549: l_datetrack_mode := hr_api.g_update;
564: );
565: --
566: end if;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 100);
569: --
570: exception
571: when others then
572: hr_utility.set_location(' Leaving:'||l_proc, 110);
568: hr_utility.set_location(' Leaving:'||l_proc, 100);
569: --
570: exception
571: when others then
572: hr_utility.set_location(' Leaving:'||l_proc, 110);
573: raise;
574: --
575: end update_appl_assg_status;
576: --
616: from per_all_assignments_f
617: where assignment_id = l_offer_assignment_id;
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc,10);
621: --
622: open csr_offer_details;
623: fetch csr_offer_details into l_offer_assignment_id
624: ,l_object_version_number
632: --
633: end if;
634: close csr_offer_details;
635: --
636: hr_utility.set_location(l_proc,20);
637: --
638: -- Call upd with new offer_status value, new
639: -- latest_offer value.
640: --
653: if p_offer_status <> hr_api.g_varchar2
654: and p_offer_status <> l_updated_offer_status
655: then
656: --
657: hr_utility.set_location(l_proc, 50);
658: --
659: irc_offer_status_history_api.create_offer_status_history
660: ( p_validate => p_validate
661: ,p_effective_date => p_effective_date
675: if p_offer_status = 'CLOSED'
676: and p_offer_status <> l_updated_offer_status
677: then
678: --
679: hr_utility.set_location(l_proc, 60);
680: --
681: open csr_assignment_ovn;
682: fetch csr_assignment_ovn into l_asg_object_version_number;
683: if csr_assignment_ovn%notfound
682: fetch csr_assignment_ovn into l_asg_object_version_number;
683: if csr_assignment_ovn%notfound
684: then
685: --
686: hr_utility.set_location(l_proc, 65);
687: --
688: close csr_assignment_ovn;
689: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
690: fnd_message.raise_error;
708: );
709: --
710: end if;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 70);
713: --
714: exception
715: when others then
716: hr_utility.set_location(' Leaving:'||l_proc, 80);
712: hr_utility.set_location(' Leaving:'||l_proc, 70);
713: --
714: exception
715: when others then
716: hr_utility.set_location(' Leaving:'||l_proc, 80);
717: raise;
718: end update_latest_offer_flag;
719: --
720: -- ----------------------------------------------------------------------------
887:
888: l_offer_assignment csr_assignment_record%ROWTYPE;
889: --
890: Begin
891: hr_utility.set_location('Entering:'||l_proc,10);
892: --
893: -- Issue a savepoint
894: --
895: savepoint COPY_OFFER_ASG_TO_APPL_ASG;
920: --
921: end if;
922: close csr_assignment_record;
923: --
924: hr_utility.set_location(l_proc,20);
925: --
926: --
927: -- Truncate the time portion from all IN date parameters
928: --
946: --
947: if ( l_effective_start_date = trunc(sysdate) )
948: then
949: --
950: hr_utility.set_location(l_proc,30);
951: --
952: -- Since the applicant assignment record is being modified multiple
953: -- times on the same day, the datetrack mode should be correction.
954: --
955: l_datetrack_mode := hr_api.g_correction;
956: --
957: end if;
958: --
959: hr_utility.set_location(l_proc,40);
960: --
961: -- Copy the Offer Assignment details into Applicant Assignment record
962: --
963: per_asg_upd.upd
1080: ,p_datetrack_mode => l_datetrack_mode
1081: ,p_validate => p_validate
1082: );
1083: --
1084: hr_utility.set_location(l_proc, 50);
1085: --
1086: --
1087: -- When in validation only mode raise the Validate_Enabled exception
1088: --
1089: if p_validate then
1090: raise hr_api.validate_enabled;
1091: end if;
1092: --
1093: hr_utility.set_location(' Leaving:'||l_proc, 60);
1094: --
1095: exception
1096: when hr_api.validate_enabled then
1097: --
1099: -- we must rollback to the savepoint
1100: --
1101: rollback to COPY_OFFER_ASG_TO_APPL_ASG;
1102: --
1103: hr_utility.set_location(' Leaving:'||l_proc, 70);
1104: when others then
1105: --
1106: -- A validation or unexpected error has occured
1107: --
1106: -- A validation or unexpected error has occured
1107: --
1108: rollback to COPY_OFFER_ASG_TO_APPL_ASG;
1109: --
1110: hr_utility.set_location(' Leaving:'||l_proc, 80);
1111: raise;
1112: end copy_offer_asg_to_appl_asg;
1113: --
1114: -- ----------------------------------------------------------------------------
1207:
1208: l_pay_proposal_record csr_pay_proposal_record%ROWTYPE;
1209: --
1210: Begin
1211: hr_utility.set_location('Entering:'||l_proc,10);
1212: --
1213: -- Issue a savepoint
1214: --
1215: savepoint COPY_OFFER_PAY_TO_APPL_PAY;
1234: --
1235: if csr_appl_pay_proposal%notfound
1236: then
1237: --
1238: hr_utility.set_location(l_proc,30);
1239: --
1240: -- Pay Proposal does not exist for this applicant.
1241: -- Hence create a new pay proposal record.
1242: --
1251: --
1252: if csr_pay_proposal_record%found
1253: then
1254: --
1255: hr_utility.set_location(l_proc,40);
1256: --
1257: -- We need to copy the pay proposal details to the record corresponding
1258: -- to applicant assignment only if the pay proposal record exists for
1259: -- offer assignment.
1308: --
1309: end if;
1310: close csr_pay_proposal_record;
1311: --
1312: hr_utility.set_location(l_proc, 50);
1313: --
1314: -- When in validation only mode raise the Validate_Enabled exception
1315: --
1316: if p_validate then
1316: if p_validate then
1317: raise hr_api.validate_enabled;
1318: end if;
1319: --
1320: hr_utility.set_location(' Leaving:'||l_proc, 60);
1321: --
1322: exception
1323: when hr_api.validate_enabled then
1324: --
1326: -- we must rollback to the savepoint
1327: --
1328: rollback to COPY_OFFER_PAY_TO_APPL_PAY;
1329: --
1330: hr_utility.set_location(' Leaving:'||l_proc, 70);
1331: when others then
1332: --
1333: -- A validation or unexpected error has occured
1334: --
1333: -- A validation or unexpected error has occured
1334: --
1335: rollback to COPY_OFFER_PAY_TO_APPL_PAY;
1336: --
1337: hr_utility.set_location(' Leaving:'||l_proc, 80);
1338: raise;
1339: end copy_offer_pay_to_appl_pay;
1340: --
1341: -- ----------------------------------------------------------------------------
1473: --
1474: begin
1475: --
1476: --
1477: hr_utility.set_location(' Entering:'||l_proc,10);
1478: --
1479: savepoint CLOSE_NOTIFICATIONS;
1480: --
1481: -- Close if any SFL notifications exists
1482: open csr_get_sfl_txn_details;
1483: fetch csr_get_sfl_txn_details into l_transaction_id,l_item_type,l_item_key;
1484: if csr_get_sfl_txn_details%found then
1485: --
1486: hr_utility.set_location(' SFL Transaction Found '||l_proc,20);
1487: hr_transaction_api.rollback_transaction(
1488: p_transaction_id => l_transaction_id);
1489: --
1490: hr_utility.set_location(' Rolled back SFL Transaction '||l_proc,30);
1486: hr_utility.set_location(' SFL Transaction Found '||l_proc,20);
1487: hr_transaction_api.rollback_transaction(
1488: p_transaction_id => l_transaction_id);
1489: --
1490: hr_utility.set_location(' Rolled back SFL Transaction '||l_proc,30);
1491: --
1492: wf_engine.abortprocess(itemtype => l_item_type
1493: ,itemkey => l_item_key
1494: ,process =>null
1495: ,result => wf_engine.eng_force
1496: ,verify_lock=> true
1497: ,cascade=> true);
1498: --
1499: hr_utility.set_location(' Cancelled SFL notification '||l_proc,40);
1500: --
1501: end if;
1502: close csr_get_sfl_txn_details;
1503: --
1505: open csr_get_txn_details;
1506: fetch csr_get_txn_details into l_transaction_id,l_item_type,l_item_key;
1507: if csr_get_txn_details%found then
1508: --
1509: hr_utility.set_location(' API Transaction Found '||l_proc,50);
1510: hr_transaction_api.rollback_transaction(
1511: p_transaction_id => l_transaction_id);
1512: --
1513: hr_utility.set_location(' Rolled back API Transaction '||l_proc,60);
1509: hr_utility.set_location(' API Transaction Found '||l_proc,50);
1510: hr_transaction_api.rollback_transaction(
1511: p_transaction_id => l_transaction_id);
1512: --
1513: hr_utility.set_location(' Rolled back API Transaction '||l_proc,60);
1514: --
1515: wf_engine.abortprocess(itemtype => l_item_type
1516: ,itemkey => l_item_key
1517: ,process =>null
1518: ,result => wf_engine.eng_force
1519: ,verify_lock=> true
1520: ,cascade=> true);
1521: --
1522: hr_utility.set_location(' Cancelled Open notification '||l_proc,70);
1523: --
1524: end if;
1525: close csr_get_txn_details;
1526: --
1528: --
1529: exception
1530: when others then
1531: rollback to CLOSE_NOTIFICATIONS;
1532: hr_utility.set_location(' Leaving: '||l_proc, 80);
1533: raise;
1534: end close_notifications;
1535: --
1536: -- ----------------------------------------------------------------------------
1620: where latest_offer = 'Y'
1621: and applicant_assignment_id = p_applicant_assignment_id;
1622: --
1623: begin
1624: hr_utility.set_location('Entering:'|| l_proc, 10);
1625: --
1626: -- Issue a savepoint
1627: --
1628: savepoint CREATE_OFFER;
1634: l_proposed_start_date := trunc(p_proposed_start_date);
1635: l_offer_shipping_date := trunc(p_offer_shipping_date);
1636: l_status_change_date := p_status_change_date;
1637: --
1638: hr_utility.set_location(l_proc,20);
1639: --
1640: -- If a prev offer exists for this applicant assignment, we need
1641: -- to close it and set this offer as the Latest.
1642: --
1649: fetch csr_latest_offer into l_updated_offer_id
1650: ,l_updated_offer_status
1651: ,l_updated_appl_assignment_id;
1652: --
1653: hr_utility.set_location(l_proc,40);
1654: --
1655: if (csr_latest_offer%found)
1656: then
1657: --
1656: then
1657: --
1658: close csr_latest_offer;
1659: --
1660: hr_utility.set_location(l_proc,45);
1661: --
1662: -- Set the offer_status of the record to be
1663: -- updated to 'Closed', the latest_offer
1664: -- to 'N' and change_reason to 'Offer Updated'
1697: -- This offer should now be the latest offer
1698: --
1699: l_latest_offer := 'Y';
1700: --
1701: hr_utility.set_location(l_proc,48);
1702: --
1703: -- Call Before Process User Hook
1704: --
1705: begin
1818: , p_offer_id => l_offer_id
1819: , p_offer_version => l_offer_version
1820: , p_object_version_number => l_object_version_number
1821: );
1822: hr_utility.set_location(l_proc,50);
1823: --
1824: -- Create offer history record for the newly created
1825: -- Offer record.
1826: --
1835: , p_note_text => null
1836: , p_object_version_number => l_osh_object_version_number
1837: , p_status_change_date => l_status_change_date
1838: );
1839: hr_utility.set_location(l_proc,60);
1840: --
1841: -- Call After Process User Hook
1842: --
1843: begin
1913: p_offer_id := l_offer_id;
1914: p_object_version_number := l_object_version_number;
1915: p_offer_version := l_offer_version;
1916: --
1917: hr_utility.set_location(' Leaving:'||l_proc, 70);
1918: exception
1919: when hr_api.validate_enabled then
1920: --
1921: -- As the Validate_Enabled exception has been raised
1930: p_offer_id := null;
1931: p_offer_version := null;
1932: p_object_version_number := null;
1933: --
1934: hr_utility.set_location(' Leaving:'||l_proc, 80);
1935: when others then
1936: --
1937: -- Reset IN OUT parameters and set all
1938: -- OUT parameters, including warnings, to null
1944: -- A validation or unexpected error has occured
1945: --
1946: rollback to CREATE_OFFER;
1947: --
1948: hr_utility.set_location(' Leaving:'||l_proc, 90);
1949: raise;
1950: end create_offer;
1951: --
1952: -- ----------------------------------------------------------------------------
2138: l_temp_offer_record csr_offer_record%ROWTYPE;
2139: --
2140: --
2141: begin
2142: hr_utility.set_location('Entering:'|| l_proc, 10);
2143: --
2144: -- Issue a savepoint
2145: --
2146: savepoint UPDATE_OFFER;
2236: --
2237: --
2238: -- l_create_new_version := true;
2239: --
2240: hr_utility.set_location(l_proc,50);
2241: --
2242: -- 'CLOSED' offer can be updated under only 1 circumstance:
2243: -- 1) The offer duration has been Extended
2244: --
2341: end if; -- offer_status = 'EXTENDED'
2342: --
2343: end if; -- prev_offer_status = 'CLOSED'
2344: --
2345: hr_utility.set_location(l_proc,60);
2346: --
2347: -- If l_create_new_version is true, a new offer version should be
2348: -- created and the current offer version should be closed.
2349: --
2349: --
2350: if l_create_new_version = true
2351: then
2352: --
2353: hr_utility.set_location(l_proc,70);
2354: --
2355: -- Fetch the previous offer version's record.
2356: --
2357: open csr_offer_record;
2359: --
2360: if csr_offer_record%notfound
2361: then
2362: --
2363: hr_utility.set_location(l_proc, 75);
2364: --
2365: close csr_offer_record;
2366: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
2367: fnd_message.raise_error;
2557: end if;
2558: --
2559: -- Create a new offer assignment copied from prev offer assignment.
2560: --
2561: hr_utility.set_location(l_proc,77);
2562: --
2563: create_offer_assignment_copy
2564: ( p_validate => p_validate
2565: , p_effective_date => l_effective_date
2623: ,p_offer_version => l_offer_version
2624: ,p_object_version_number => l_object_version_number
2625: );
2626: --
2627: hr_utility.set_location(' Leaving:'||l_proc, 78);
2628: --
2629: else -- l_create_new_version = false
2630: --
2631: -- Proceed with normal Update.
2767: -- Check if the change_reason is 'WITHDRAWAL'. If yes, close
2768: -- the offer irrespective of the current offer status.
2769: -- Else, check for the current offer_status.
2770: --
2771: hr_utility.set_location(l_proc,100);
2772: --
2773: if (( p_change_reason = 'EXPIRED'
2774: OR p_change_reason = 'APL_DECLINED'
2775: OR p_change_reason = 'APL_ACCEPTED'
2779: AND l_prev_offer_status <> 'PENDING_EXTENDED')
2780: )
2781: then
2782: --
2783: hr_utility.set_location(l_proc,105);
2784: --
2785: fnd_message.set_name('PER','IRC_412300_OFFER_NOT_EXTENDED');
2786: fnd_message.raise_error;
2787: --
2790: if ( p_change_reason <> 'WITHDRAWAL'
2791: OR p_change_reason is null -- Null check
2792: ) then
2793: --
2794: hr_utility.set_location(l_proc,110);
2795: --
2796: -- Check to see if the offer status is Closed. If yes,
2797: -- throw an error saying that the offer cannot be closed.
2798: --
2798: --
2799: if ( l_prev_offer_status = 'CLOSED'
2800: ) then
2801: --
2802: hr_utility.set_location(l_proc,120);
2803: --
2804: -- Close offer can be called on a closed offer with change
2805: -- reason APL_DECLINED_ACCEPTANCE, MGR_WITHDRAW, APL_HIRED
2806: --
2839: if l_prev_offer_status = 'PENDING_EXTENDED'
2840: and l_offer_status = 'EXTENDED'
2841: then
2842: --
2843: hr_utility.set_location(l_proc,122);
2844: --
2845: -- pass in old status PENDING_EXTENDED to this method
2846: irc_iof_bus.chk_multiple_fields_updated
2847: ( p_mutiple_fields_updated => l_mutiple_fields_updated
2895: --
2896: if ( l_mutiple_fields_updated = false )
2897: then
2898: --
2899: hr_utility.set_location(l_proc,125);
2900: --
2901: l_offer_status := 'EXTENDED';
2902: --
2903: else
2908: end if;
2909: --
2910: end if;
2911:
2912: hr_utility.set_location(l_proc,130);
2913: --
2914: irc_iof_upd.upd
2915: ( p_effective_date => l_effective_date
2916: , p_offer_id => l_offer_id
3022: (l_expiry_date = hr_api.g_date)
3023: )
3024: then
3025: --
3026: hr_utility.set_location(l_proc,140);
3027: --
3028: irc_offer_status_history_api.create_offer_status_history
3029: ( p_validate => p_validate
3030: , p_effective_date => l_effective_date
3040: --
3041: -- Also, if the offer status has changed, call update_appl_assg_status
3042: -- to set the appropriate Assignment Status for the application.
3043: --
3044: hr_utility.set_location(l_proc,141);
3045: --
3046: irc_offers_api.update_appl_assg_status
3047: ( p_validate => p_validate
3048: , p_effective_date => l_effective_date
3056: -- assignment again
3057: if l_offer_status = 'CLOSED' and l_prev_offer_status<>'CLOSED'
3058: then
3059: --
3060: hr_utility.set_location(l_proc,142);
3061: --
3062: per_asg_del.del
3063: (
3064: p_assignment_id => l_prev_offer_assignment_id
3211: p_offer_id := l_offer_id;
3212: p_object_version_number := l_object_version_number;
3213: p_offer_version := l_offer_version;
3214: --
3215: hr_utility.set_location(' Leaving:'||l_proc, 145);
3216: --
3217: exception
3218: when hr_api.validate_enabled then
3219: --
3229: -- we must rollback to the savepoint
3230: --
3231: rollback to UPDATE_OFFER;
3232: --
3233: hr_utility.set_location(' Leaving:'||l_proc, 150);
3234: when others then
3235: --
3236: -- Reset IN OUT parameters and set all
3237: -- OUT parameters, including warnings, to null
3243: -- A validation or unexpected error has occured
3244: --
3245: rollback to UPDATE_OFFER;
3246: --
3247: hr_utility.set_location(' Leaving:'||l_proc, 160);
3248: raise;
3249: end update_offer;
3250: --
3251: -- ----------------------------------------------------------------------------
3300: from per_all_assignments_f
3301: where assignment_id = l_offer_assignment_id;
3302: --
3303: begin
3304: hr_utility.set_location('Entering:'|| l_proc, 10);
3305: --
3306: -- Issue a savepoint
3307: --
3308: savepoint DELETE_OFFER;
3416: --
3417: open csr_latest_offer;
3418: fetch csr_latest_offer into l_offer_id, l_offer_status;
3419: --
3420: hr_utility.set_location(l_proc,20);
3421: --
3422: if (csr_latest_offer%found)
3423: then
3424: close csr_latest_offer;
3472: --
3473: -- Set all output arguments
3474: --
3475: --
3476: hr_utility.set_location(' Leaving:'||l_proc, 50);
3477: exception
3478: when hr_api.validate_enabled then
3479: --
3480: -- As the Validate_Enabled exception has been raised
3485: -- Only set output warning arguments
3486: -- (Any key or derived arguments must be set to null
3487: -- when validation only mode is being used.)
3488: --
3489: hr_utility.set_location(' Leaving:'||l_proc, 60);
3490: when others then
3491: --
3492: -- A validation or unexpected error has occured
3493: --
3491: --
3492: -- A validation or unexpected error has occured
3493: --
3494: rollback to DELETE_OFFER;
3495: hr_utility.set_location(' Leaving:'||l_proc, 70);
3496: raise;
3497: end delete_offer;
3498: --
3499: --
3551: where offer_id = l_offer_id;
3552: --
3553: Begin
3554: --
3555: hr_utility.set_location('Entering:'||l_proc,10);
3556: --
3557: -- issue a savepoint
3558: --
3559: savepoint CLOSE_OFFER;
3567: --
3568: if (p_offer_id is not null)
3569: then
3570: --
3571: hr_utility.set_location(l_proc,20);
3572: --
3573: open csr_offer_assignment_2;
3574: fetch csr_offer_assignment_2 into l_offer_assignment_id
3575: ,l_prev_offer_status;
3594: -- offer_id for that record is.
3595: --
3596: l_offer_assignment_exists := false;
3597: --
3598: hr_utility.set_location(l_proc,30);
3599: --
3600: open csr_offer_assignment_1;
3601: fetch csr_offer_assignment_1 into l_offer_assignment_id
3602: ,l_offer_id
3609: --
3610: if csr_offer_assignment_1%found
3611: then
3612: --
3613: hr_utility.set_location(l_proc,40);
3614: --
3615: close csr_offer_assignment_1;
3616: --
3617: -- Set the variable l_offer_assignment_exists to true;
3621: else
3622: close csr_offer_assignment_1;
3623: end if;
3624: --
3625: hr_utility.set_location(l_proc,50);
3626: --
3627: end if;
3628: --
3629: hr_utility.set_location(l_proc,60);
3625: hr_utility.set_location(l_proc,50);
3626: --
3627: end if;
3628: --
3629: hr_utility.set_location(l_proc,60);
3630: --
3631: -- Check if the offer assginment exists. Only if it exists call the
3632: -- update_offer the close the offer and end date the offer assignment.
3633: --
3633: --
3634: if l_offer_assignment_exists = true
3635: then
3636: --
3637: hr_utility.set_location(l_proc,65);
3638: --
3639: -- Fetch Offer OVN
3640: --
3641: open csr_iof_object_version_number;
3677: end if;
3678: --
3679: end if;
3680: --
3681: hr_utility.set_location(l_proc,70);
3682: --
3683: end if;
3684: --
3685: -- check if there are any SAVED offers for this applicant assignment ID.
3713: --
3714: end if;
3715:
3716: --
3717: hr_utility.set_location(l_proc,90);
3718: --
3719: -- When in validation only mode raise the Validate_Enabled exception
3720: --
3721: if p_validate then
3721: if p_validate then
3722: raise hr_api.validate_enabled;
3723: end if;
3724: --
3725: hr_utility.set_location(' Leaving:'||l_proc, 100);
3726: exception
3727: when hr_api.validate_enabled then
3728: --
3729: -- As the Validate_Enabled exception has been raised
3730: -- we must rollback to the savepoint
3731: --
3732: rollback to CLOSE_OFFER;
3733: --
3734: hr_utility.set_location(' Leaving:'||l_proc, 110);
3735: when others then
3736: --
3737: -- A validation or unexpected error has occured
3738: --
3737: -- A validation or unexpected error has occured
3738: --
3739: rollback to CLOSE_OFFER;
3740: --
3741: hr_utility.set_location(' Leaving:'||l_proc, 120);
3742: raise;
3743: end close_offer;
3744: --
3745: --
3762: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3763: l_offer_version irc_offers.offer_version%TYPE;
3764: --
3765: Begin
3766: hr_utility.set_location('Entering:'||l_proc,10);
3767: --
3768: -- Call update_offer with offer_status = 'HOLD'
3769: --
3770: update_offer
3781: );
3782: --
3783: exception
3784: when others then
3785: hr_utility.set_location(' Leaving:'||l_proc, 30);
3786: raise;
3787: end hold_offer;
3788: --
3789: -- ----------------------------------------------------------------------------
3837: where offer_id = p_offer_id;
3838: --
3839: Begin
3840: --
3841: hr_utility.set_location('Entering:'||l_proc,10);
3842: --
3843: -- Check if the offer is currently in HOLD
3844: --
3845: open csr_prev_offer_status;
3961: end if;
3962: --
3963: exception
3964: when others then
3965: hr_utility.set_location(' Leaving:'||l_proc, 30);
3966: raise;
3967: end release_offer;
3968: --
3969: -- ----------------------------------------------------------------------------
4118: l_projected_assignment_end date;
4119: l_effective_date date;
4120: Begin
4121:
4122: hr_utility.set_location('Entering:'||l_proc,10);
4123: --
4124: -- Issue a savepoint
4125: --
4126: savepoint CREATE_OFFER_ASSIGNMENT;
4124: -- Issue a savepoint
4125: --
4126: savepoint CREATE_OFFER_ASSIGNMENT;
4127: --
4128: hr_utility.set_location(l_proc,20);
4129: --
4130: --
4131: -- Truncate the time portion from all IN date parameters
4132: --
4141: --
4142: l_assignment_type := 'O';
4143: l_primary_flag := 'N';
4144: --
4145: hr_utility.set_location(l_proc,40);
4146: --
4147: -- Create Offer Assignment record
4148: --
4149: per_asg_ins.ins
4265: ,p_po_line_id => p_po_line_id
4266: ,p_projected_assignment_end => p_projected_assignment_end
4267: );
4268: --
4269: hr_utility.set_location(l_proc, 50);
4270: --
4271: --
4272: -- When in validation only mode raise the Validate_Enabled exception
4273: --
4286: p_object_version_number := l_object_version_number;
4287: p_other_manager_warning := l_other_manager_warning;
4288: p_hourly_salaried_warning := l_hourly_salaried_warning;
4289: --
4290: hr_utility.set_location(' Leaving:'||l_proc, 60);
4291: --
4292: exception
4293: when hr_api.validate_enabled then
4294: --
4304: -- we must rollback to the savepoint
4305: --
4306: rollback to CREATE_OFFER_ASSIGNMENT;
4307: --
4308: hr_utility.set_location(' Leaving:'||l_proc, 70);
4309: when others then
4310: --
4311: p_assignment_id := null;
4312: p_effective_start_date := null;
4319: -- A validation or unexpected error has occured
4320: --
4321: rollback to CREATE_OFFER_ASSIGNMENT;
4322: --
4323: hr_utility.set_location(' Leaving:'||l_proc, 80);
4324: raise;
4325: end create_offer_assignment;
4326: --
4327: -- ----------------------------------------------------------------------------
4552:
4553: l_offer_record csr_offer_record%ROWTYPE;
4554: --
4555: Begin
4556: hr_utility.set_location('Entering:'|| l_proc, 10);
4557: --
4558: -- Issue a savepoint
4559: --
4560: savepoint UPDATE_OFFER_ASSIGNMENT;
4570: --
4571: if csr_prev_offer_details%notfound
4572: then
4573: --
4574: hr_utility.set_location(l_proc, 20);
4575: --
4576: close csr_prev_offer_details;
4577: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4578: fnd_message.raise_error;
4611: if l_prev_offer_status = 'HOLD'
4612: OR p_offer_status = 'HOLD'
4613: then
4614: --
4615: hr_utility.set_location(l_proc, 25);
4616: --
4617: fnd_message.set_name('PER','IRC_412306_CANT_UPD_HELD_OFFER');
4618: fnd_message.raise_error;
4619: --
4620: elsif l_prev_offer_status in ('EXTENDED','APPROVED','CLOSED')
4621: OR p_offer_status in ('EXTENDED','APPROVED','CLOSED')
4622: then
4623: --
4624: hr_utility.set_location(l_proc, 30);
4625: --
4626: -- The code to check new offer version creation has been disabled
4627: -- since this will now be taken care of in the Java Layer itself.
4628: -- New Offer version creation code is no longer supported.
4637: --
4638: if l_create_new_version = true
4639: then
4640: --
4641: hr_utility.set_location(l_proc, 40);
4642: --
4643: -- close the current offer and offer assignment.
4644: --
4645: close_offer
4657: --
4658: if csr_offer_record%notfound
4659: then
4660: --
4661: hr_utility.set_location(l_proc, 50);
4662: --
4663: close csr_offer_record;
4664: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4665: fnd_message.raise_error;
4732: l_datetrack_mode := hr_api.g_correction;
4733: --
4734: end if; -- l_create_new_version
4735: --
4736: hr_utility.set_location(l_proc, 60);
4737: --
4738: -- update the offer assignment record.
4739: --
4740: per_asg_upd.upd
4889: p_validation_end_date := l_validation_end_date;
4890: p_offer_id := l_offer_id;
4891: p_asg_object_version_number := l_asg_object_version_number;
4892:
4893: hr_utility.set_location(' Leaving:'||l_proc, 145);
4894: --
4895: exception
4896: when hr_api.validate_enabled then
4897: --
4918: p_validation_end_date := l_validation_end_date;
4919: p_offer_id := l_offer_id;
4920: p_asg_object_version_number := l_asg_object_version_number;
4921: --
4922: hr_utility.set_location(' Leaving:'||l_proc, 150);
4923: when others then
4924: --
4925: -- Reset IN OUT parameters and set all
4926: -- OUT parameters, including warnings, to null
4943: -- A validation or unexpected error has occured
4944: --
4945: rollback to UPDATE_OFFER_ASSIGNMENT;
4946: --
4947: hr_utility.set_location(' Leaving:'||l_proc, 160);
4948: raise;
4949: end update_offer_assignment;
4950: --
4951: --
4969: from irc_offers
4970: where offer_assignment_id = p_offer_assignment_id;
4971: --
4972: Begin
4973: hr_utility.set_location('Entering:'|| l_proc, 10);
4974: --
4975: -- Issue a savepoint
4976: --
4977: savepoint DELETE_OFFER_ASSIGNMENT;
4981: --
4982: if csr_offer_id%notfound
4983: then
4984: --
4985: hr_utility.set_location(l_proc, 20);
4986: --
4987: close csr_offer_id;
4988: fnd_message.set_name('PER','IRC_412322_INVALID_OFFER_ID');
4989: fnd_message.raise_error;
4994: -- If the offer is valid, call the delete procedure of offer
4995: -- so that both the offer record and the offer assignment
4996: -- record are deleted.
4997: --
4998: hr_utility.set_location(l_proc, 30);
4999: --
5000: delete_offer
5001: ( p_validate => p_validate
5002: ,p_object_version_number => l_offer_object_version_number
5010: if p_validate then
5011: raise hr_api.validate_enabled;
5012: end if;
5013: --
5014: hr_utility.set_location(' Leaving:'||l_proc, 40);
5015: --
5016: exception
5017: when hr_api.validate_enabled then
5018: --
5024: -- Only set output warning arguments
5025: -- (Any key or derived arguments must be set to null
5026: -- when validation only mode is being used.)
5027: --
5028: hr_utility.set_location(' Leaving:'||l_proc, 60);
5029: when others then
5030: --
5031: -- A validation or unexpected error has occured
5032: --
5030: --
5031: -- A validation or unexpected error has occured
5032: --
5033: rollback to DELETE_OFFER_ASSIGNMENT;
5034: hr_utility.set_location(' Leaving:'||l_proc, 70);
5035: raise;
5036: end delete_offer_assignment;
5037: --
5038: --
5049: --
5050: l_proc varchar2(72) := g_package||'upload_offer_letter';
5051: --
5052: Begin
5053: hr_utility.set_location('Entering:'|| l_proc, 10);
5054: --
5055: -- Issue a savepoint
5056: --
5057: savepoint UPLOAD_OFFER_LETTER;
5057: savepoint UPLOAD_OFFER_LETTER;
5058: --
5059: -- Call blob_dml to pass on the blob to be uploaded
5060: --
5061: hr_utility.set_location(l_proc, 30);
5062: --
5063: irc_iof_shd.blob_dml
5064: ( p_offer_letter => p_offer_letter
5065: ,p_offer_id => p_offer_id
5071: if p_validate then
5072: raise hr_api.validate_enabled;
5073: end if;
5074: --
5075: hr_utility.set_location(' Leaving:'||l_proc, 40);
5076: exception
5077: when hr_api.validate_enabled then
5078: --
5079: -- As the Validate_Enabled exception has been raised
5080: -- we must rollback to the savepoint
5081: --
5082: rollback to UPLOAD_OFFER_LETTER;
5083: --
5084: hr_utility.set_location(' Leaving:'||l_proc, 50);
5085: when others then
5086: --
5087: -- A validation or unexpected error has occured
5088: --
5086: --
5087: -- A validation or unexpected error has occured
5088: --
5089: rollback to UPLOAD_OFFER_LETTER;
5090: hr_utility.set_location(' Leaving:'||l_proc, 60);
5091: raise;
5092: end upload_offer_letter;
5093: --
5094: end IRC_OFFERS_API;