[Home] [Help]
118:
119: -- check if a transaction already exists and has been submitted for approval
120: IF l_award_approval_status = 'INPROCESS' THEN
121: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'award ' || p_auction_header_id || ' is already in the approval process');
122: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
123: END IF;
124:
125: l_last_update_date := SYSDATE;
126:
230: EXCEPTION
231: WHEN lock_not_acquired THEN
232: -- a lock could not be acquired on the transaction; another user may be submitting it for approval
233: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'a lock could not be acquired on award ' || p_auction_header_id);
234: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
235: WHEN transaction_modified THEN
236: -- the transaction has been modified by another user session
237: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'award ' || p_auction_header_id || ' has been modified by another user session');
238: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
234: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
235: WHEN transaction_modified THEN
236: -- the transaction has been modified by another user session
237: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'award ' || p_auction_header_id || ' has been modified by another user session');
238: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
239: WHEN already_in_approval THEN
240: -- the transaction is in the approval process
241: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'award ' || p_auction_header_id || ' is already in the approval process');
242: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
238: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
239: WHEN already_in_approval THEN
240: -- the transaction is in the approval process
241: log_string(l_exception_log_level, l_current_log_level, l_module_name, 'award ' || p_auction_header_id || ' is already in the approval process');
242: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_CANNOT_SBMT_AWARD_APPROVAL'));
243: END validate_transaction;
244:
245: /*
246: Adds a row into the PON_AUCTION_HISTORY table.
373: WHERE
374: dt.doctype_id= auc.doctype_id
375: AND auc.auction_header_id = p_auction_header_id;
376:
377: l_msg_suffix := PON_AUCTION_PKG.get_message_suffix(l_doctype_group_name);
378:
379: --bug 9555176
380: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
381: itemkey => p_item_key,
416:
417: wf_engine.SetItemAttrText(itemtype => p_item_type,
418: itemkey => p_item_key,
419: aname => 'NOTE_TO_APPROVERS',
420: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_note_to_approvers));
421:
422: wf_engine.SetItemAttrText(itemtype => p_item_type,
423: itemkey => p_item_key,
424: aname => 'AWARD_SUMMARY_URL',
493: BEGIN
494:
495: -- set the db session language
496: PON_PROFILE_UTIL_PKG.get_wf_language(p_user_name, l_language_code);
497: PON_AUCTION_PKG.set_session_language(null, l_language_code);
498:
499: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,
500: itemkey => p_item_key,
501: aname => 'MESSAGE_SUFFIX');
515: -- as well as the subject for the reminder notification
516: wf_engine.SetItemAttrText(itemtype => p_item_type,
517: itemkey => p_item_key,
518: aname => 'APPROVAL_REQUEST_SUBJECT',
519: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_1',
520: l_msg_suffix,
521: 'DOC_NUMBER',
522: l_document_number,
523: 'DOC_TITLE',
524: l_auction_title));
525: wf_engine.SetItemAttrText(itemtype => p_item_type,
526: itemkey => p_item_key,
527: aname => 'REQUEST_REMINDER_SUBJECT',
528: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_2',
529: l_msg_suffix,
530: 'DOC_NUMBER',
531: l_document_number,
532: 'DOC_TITLE',
534: ELSIF p_notification_type = AWARD_APPROVED THEN
535: wf_engine.SetItemAttrText(itemtype => p_item_type,
536: itemkey => p_item_key,
537: aname => 'APPROVAL_SUBJECT',
538: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVED_1',
539: l_msg_suffix,
540: 'DOC_NUMBER',
541: l_document_number,
542: 'DOC_TITLE',
544: ELSIF p_notification_type = AWARD_REJECTED THEN
545: wf_engine.SetItemAttrText(itemtype => p_item_type,
546: itemkey => p_item_key,
547: aname => 'REJECTION_SUBJECT',
548: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_REJECTED_1',
549: l_msg_suffix,
550: 'DOC_NUMBER',
551: l_document_number,
552: 'DOC_TITLE',
554: ELSIF p_notification_type = ERROR THEN
555: wf_engine.SetItemAttrText(itemtype => p_item_type,
556: itemkey => p_item_key,
557: aname => 'ERROR_SUBJECT',
558: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_1',
559: l_msg_suffix,
560: 'DOC_NUMBER',
561: l_document_number,
562: 'DOC_TITLE',
564: ELSIF p_notification_type = ERROR_FOR_ADMIN THEN
565: wf_engine.SetItemAttrText(itemtype => p_item_type,
566: itemkey => p_item_key,
567: aname => 'ERROR_SUBJECT_FOR_ADMIN',
568: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_2',
569: l_msg_suffix,
570: 'DOC_NUMBER',
571: l_document_number,
572: 'DOC_TITLE',
574: END IF;
575:
576: -- convert the open bidding date, close bidding date, award by date, approval date, and rejection_date
577: -- to dates in the user's timezone
578: l_user_timezone := PON_AUCTION_PKG.get_time_zone(p_user_name);
579: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
580:
581: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
582: itemkey => p_item_key,
575:
576: -- convert the open bidding date, close bidding date, award by date, approval date, and rejection_date
577: -- to dates in the user's timezone
578: l_user_timezone := PON_AUCTION_PKG.get_time_zone(p_user_name);
579: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
580:
581: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
582: itemkey => p_item_key,
583: aname => 'OPEN_BIDDING_DATE');
643: l_rejection_date_tz := l_rejection_date;
644: END IF;
645: END IF;
646:
647: l_user_timezone_desc := PON_AUCTION_PKG.get_timezone_description(l_user_timezone, l_language_code);
648:
649: wf_engine.setItemAttrText(itemtype => p_item_type,
650: itemkey => p_item_key,
651: aname => 'USER_TIMEZONE',
713:
714: wf_engine.SetItemAttrText (itemtype => p_item_type,
715: itemkey => p_item_key,
716: aname => 'PREVIEW_DATE_NOTSPECIFIED',
717: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
718: END IF;
719:
720: END set_common_user_attributes;
721:
938: -- this message can be seen by any buyer
939: wf_engine.SetItemAttrText(itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'APPLICATION_ERROR',
942: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
943:
944: log_string(l_exception_log_level, l_current_log_level, l_module_name, SQLERRM);
945: END;
946:
952: -- this message can be seen only by admin.
953: wf_engine.SetItemAttrText(itemtype => itemtype,
954: itemkey => itemkey,
955: aname => 'OAM_ERROR',
956: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
957:
958: -- this message can be seen by any buyer.
959: wf_engine.SetItemAttrText(itemtype => itemtype,
960: itemkey => itemkey,
958: -- this message can be seen by any buyer.
959: wf_engine.SetItemAttrText(itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'APPLICATION_ERROR',
962: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
963:
964: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
965:
966: END IF;
960: itemkey => itemkey,
961: aname => 'APPLICATION_ERROR',
962: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
963:
964: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
965:
966: END IF;
967:
968:
1015: -- this message can be seen only by admin.
1016: wf_engine.SetItemAttrText(itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'OAM_ERROR',
1019: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1020:
1021: -- this message can be seen by any buyer.
1022: wf_engine.SetItemAttrText(itemtype => itemtype,
1023: itemkey => itemkey,
1021: -- this message can be seen by any buyer.
1022: wf_engine.SetItemAttrText(itemtype => itemtype,
1023: itemkey => itemkey,
1024: aname => 'APPLICATION_ERROR',
1025: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1026:
1027: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1028: RETURN;
1029: ELSE
1023: itemkey => itemkey,
1024: aname => 'APPLICATION_ERROR',
1025: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1026:
1027: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1028: RETURN;
1029: ELSE
1030: get_employee_info_for_person(l_person_id, l_next_approver_employee);
1031: END IF;
1089: END IF;
1090: wf_engine.SetItemAttrText(itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'APPLICATION_ERROR',
1093: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_NEXT_APPROVER',
1094: NULL,
1095: 'NAME',
1096: l_next_approver_name));
1097: END IF;
1348: -- record that document as been approved (by all required approvers, if any)
1349: add_action_history(l_auction_header_id,
1350: l_transaction_id,
1351: 'AWARD_APPROVE',
1352: PON_AUCTION_PKG.getMessage('PON_AWARD_IS_APPROVED'),
1353: l_approval_date,
1354: 0,
1355: NULL);
1356:
1526: -- this message can be seen only by admin.
1527: wf_engine.SetItemAttrText( itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname => 'OAM_ERROR',
1530: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1531:
1532: -- this message can be seen by any buyer.
1533: wf_engine.SetItemAttrText( itemtype => itemtype,
1534: itemkey => itemkey,
1532: -- this message can be seen by any buyer.
1533: wf_engine.SetItemAttrText( itemtype => itemtype,
1534: itemkey => itemkey,
1535: aname => 'APPLICATION_ERROR',
1536: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1537:
1538: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1539: RETURN;
1540: END IF;
1534: itemkey => itemkey,
1535: aname => 'APPLICATION_ERROR',
1536: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1537:
1538: log_string(l_exception_log_level, l_current_log_level, l_module_name, PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1539: RETURN;
1540: END IF;
1541:
1542: get_employee_info_for_person(l_person_id, l_approver_employee);
1600: -- set the Application Error workflow attribute
1601: wf_engine.SetItemAttrText(itemtype => itemtype,
1602: itemkey => itemkey,
1603: aname => 'APPLICATION_ERROR',
1604: avalue => PON_AUCTION_PKG.getMessage('PON_NO_FORWARDEE_SPECIFIED'));
1605: -- otherwise
1606: ELSE
1607: -- validate that the forwardee is an active employee and has a user account
1608: get_employee_info_for_user(l_forwardee_user_name, l_forwardee_employee);
1618: -- set the Application Error workflow attribute
1619: wf_engine.SetItemAttrText(itemtype => itemtype,
1620: itemkey => itemkey,
1621: aname => 'APPLICATION_ERROR',
1622: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', get_display_name_for_user(l_forwardee_user_name)));
1623: END IF;
1624: END IF;
1625: END IF;
1626:
1674: -- this message can be seen only by admin.
1675: wf_engine.SetItemAttrText( itemtype => itemtype,
1676: itemkey => itemkey,
1677: aname => 'OAM_ERROR',
1678: avalue => PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_forwardee.display_name ));
1679:
1680: -- this message can be seen by any buyer.
1681: wf_engine.SetItemAttrText( itemtype => itemtype,
1682: itemkey => itemkey,
1680: -- this message can be seen by any buyer.
1681: wf_engine.SetItemAttrText( itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'APPLICATION_ERROR',
1684: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1685:
1686: RETURN;
1687: END IF;
1688: END IF;
1704: -- this message can be seen only by admin.
1705: wf_engine.SetItemAttrText( itemtype => itemtype,
1706: itemkey => itemkey,
1707: aname => 'OAM_ERROR',
1708: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1709:
1710: -- this message can be seen by any buyer.
1711: wf_engine.SetItemAttrText( itemtype => itemtype,
1712: itemkey => itemkey,
1710: -- this message can be seen by any buyer.
1711: wf_engine.SetItemAttrText( itemtype => itemtype,
1712: itemkey => itemkey,
1713: aname => 'APPLICATION_ERROR',
1714: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', l_forwardee.display_name ));
1715:
1716: RETURN;
1717: END IF;
1718: ELSE
1754: -- this message can be seen by any buyer
1755: wf_engine.SetItemAttrText(itemtype => itemtype,
1756: itemkey => itemkey,
1757: aname => 'APPLICATION_ERROR',
1758: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
1759:
1760: log_string(l_exception_log_level, l_current_log_level, l_module_name, SQLERRM);
1761: END;
1762: END IF;
2060: l_approver.orig_system_id := NULL;
2061: END;
2062:
2063: IF l_approver.orig_system_id IS NULL THEN
2064: raise_application_error(-20001,PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_approver.display_name ));
2065: END IF;
2066: END IF;
2067: END IF;
2068:
2425:
2426: -- if the notification was found, then respond to it with user's decision
2427: IF l_notification_found THEN
2428: wf_notification.SetAttrText(l_notification_id, 'RESULT', p_decision);
2429: wf_notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', PON_AUCTION_PKG.replaceHtmlChars(p_note_to_buyer));
2430: wf_notification.SetAttrText(l_notification_id, 'APPROVER_FORWARDEE_USER', p_forwardee_user_name);
2431: wf_notification.respond(l_notification_id, p_decision, p_user_name);
2432: -- otherwise, raise an exception that the notification has already been responded to
2433: ELSE
2430: wf_notification.SetAttrText(l_notification_id, 'APPROVER_FORWARDEE_USER', p_forwardee_user_name);
2431: wf_notification.respond(l_notification_id, p_decision, p_user_name);
2432: -- otherwise, raise an exception that the notification has already been responded to
2433: ELSE
2434: raise_application_error(-20001, PON_AUCTION_PKG.getMessage('PON_NOTIF_ALREADY_RESPONDED'));
2435: END IF;
2436:
2437: p_error_message := NULL;
2438: