[Home] [Help]
1067: begin
1068: hr_utility.set_location(' Entering:' || l_proc,10);
1069: hr_utility.set_location(' Calling:hr_transaction_api.rollback_transaction' || l_proc,15);
1070: delete_transaction_children(p_transaction_id, p_validate);
1071: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1072: hr_transaction_api.rollback_transaction(
1073: p_transaction_id => p_transaction_id,
1074: p_validate => (p_validate=hr_api.g_true_num));
1075: hr_utility.set_location(' Exiting :' || l_proc,20);
1190:
1191:
1192: if(p_notification_id is not null) then
1193: -- check if notification is open and user has access to the notification
1194: if not hr_sflutil_ss.OpenNotificationsExist(p_notification_id) then
1195: -- raise exception ... need to change
1196: if(hr_multi_message.is_message_list_enabled) then
1197: --HRSSA_TRANSACTION_COMPLETE
1198: --This notification is not available as it has already been completed
1316:
1317:
1318: if(p_notification_id is not null) then
1319: -- check if notification is open and user has access to the notification
1320: if not hr_sflutil_ss.OpenNotificationsExist(p_notification_id) then
1321: -- raise exception ... need to change
1322: if(hr_multi_message.is_message_list_enabled) then
1323: --HRSSA_TRANSACTION_COMPLETE
1324: --This notification is not available as it has already been completed
1418: -- check if the notification id if not throw exception
1419: if(ln_notification_id is not null) then
1420:
1421: -- hsundar: Delete any open SFL Notification for this txn
1422: hr_sflutil_ss.closesflnotifications(p_transaction_id,p_item_type,p_item_key);
1423:
1424: -- complete ntf with HR_V5_ALL_RESPONSES.del code
1425: /* wf_engine.CompleteActivity(
1426: p_item_Type
1443: end if;
1444: else -- other statuses
1445:
1446: -- hsundar: Delete any open SFL Notification for this txn
1447: hr_sflutil_ss.closesflnotifications(p_transaction_id,p_item_type,p_item_key);
1448:
1449: hr_transaction_ss.rollback_transaction(p_item_type,
1450: p_item_key,
1451: null,
1464: p_transaction_id => p_transaction_id,
1465: p_status => 'D');
1466:
1467: -- close all sfl notifications
1468: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1469: -- do the module specific logic
1470: end if;
1471:
1472:
1506: -- check if we have the notification id
1507: if(ln_notification_id is not null) then
1508:
1509: -- hsundar: Delete any open SFL Notification for this txn
1510: hr_sflutil_ss.closesflnotifications(p_transaction_id,p_item_type,p_item_key);
1511:
1512: -- complete ntf with HR_V5_ALL_RESPONSES.Reject code
1513: /* wf_engine.CompleteActivity(
1514: p_item_Type
1618:
1619: if(lr_hr_api_transaction_rec.item_type is not null) then
1620: -- WF case.
1621: -- hsundar: Delete any open SFL Notification for this txn
1622: hr_sflutil_ss.closesflnotifications(p_transaction_id
1623: ,lr_hr_api_transaction_rec.item_type
1624: ,lr_hr_api_transaction_rec.item_key);
1625:
1626: hr_transaction_ss.rollback_transaction(lr_hr_api_transaction_rec.item_type,
1641: p_transaction_id => p_transaction_id,
1642: p_status => 'D');
1643:
1644: -- close all sfl notifications
1645: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1646: -- do the module specific logic
1647:
1648: end if; -- End of 2nd if(lr_hr_api_transaction_rec.item_type is not null)
1649:
2079: when others then
2080: null;
2081: end;
2082:
2083: c_updateStatus:= hr_sflutil_ss.getSFLStatusForUpdate(
2084: nvl(p_currentTxnStatus,lv_currentTxnStatus),
2085: p_proposedTxnStatus);
2086: else
2087: -- we do not handle other status, return error status
2098: into lr_hr_api_transaction_rec
2099: from hr_api_transactions
2100: where transaction_id=p_transaction_id;
2101: -- send sfl notification to login user
2102: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2103: p_transaction_ref_table,
2104: fnd_global.user_name,
2105: 'HR_RELAUNCH_SS',
2106: null,