[Home] [Help]
695: -- bug3668978
696: -- We should pass the current login user to eRecord API rather than
697: -- the buyer because the notification may have been routed to
698: -- somebody else
699: l_user_name := FND_GLOBAL.user_name;
700:
701: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'SUPPLIER_USER_NAME');
1020: INTO l_role
1021: FROM FND_USER FU,
1022: HZ_PARTIES HP
1023: WHERE HP.party_id = FU.customer_id
1024: AND FU.user_id = fnd_global.user_id;
1025: EXCEPTION
1026: WHEN NO_DATA_FOUND THEN
1027: l_role := Null;
1028:
1046:
1047: -- bug3668978
1048: -- employee id should reflect the person who responds to the notification rather
1049: -- then the buyer on the document.
1050: l_employee_id := FND_GLOBAL.employee_id;
1051:
1052: l_accepting_party := 'B';
1053: l_response := l_buyer_response;
1054: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1067: ELSE
1068: -- bug3668978
1069: -- employee id should reflect the person who responds to the notification rather
1070: -- then the buyer on the document.
1071: -- l_employee_id := FND_GLOBAL.employee_id;
1072: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
1073: itemkey => itemkey,
1074: aname => 'KO_USER_NAME');
1075:
1183: WHEN NO_DATA_FOUND THEN
1184: RAISE l_binding_exception;
1185: END;
1186:
1187: l_user_id := FND_GLOBAL.USER_ID;
1188:
1189: -- Default Promised date with Need-by-Date only when the profile option is set
1190: IF( g_default_promise_date = 'Y') THEN
1191: IF(l_supplier_response = 'ACCEPTED' AND l_buyer_response = 'ACCEPTED') THEN
1206: PO_ACCEPTANCES_INS_PVT.insert_row(
1207: x_rowid => l_rowid,
1208: x_acceptance_id => l_acceptance_id,
1209: p_creation_date => sysdate,
1210: p_created_by => fnd_global.user_id,
1211: p_po_header_id => l_document_id,
1212: p_draft_id => l_draft_id,
1213: p_po_release_id => Null,
1214: p_action => l_response_code,
2965:
2966: UPDATE PO_LINE_LOCATIONS_ALL
2967: SET approved_flag = 'Y',
2968: approved_date = sysdate,
2969: last_updated_by = fnd_global.user_id,
2970: last_update_login = fnd_global.login_id,
2971: last_update_date = sysdate
2972: WHERE po_header_id = p_po_header_id
2973: AND NVL(cancel_flag,'N') = 'N'
2966: UPDATE PO_LINE_LOCATIONS_ALL
2967: SET approved_flag = 'Y',
2968: approved_date = sysdate,
2969: last_updated_by = fnd_global.user_id,
2970: last_update_login = fnd_global.login_id,
2971: last_update_date = sysdate
2972: WHERE po_header_id = p_po_header_id
2973: AND NVL(cancel_flag,'N') = 'N'
2974: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED'
2994: approved_flag = l_approved_flag,
2995: pending_signature_flag = 'N',
2996: acceptance_required_flag = 'N',
2997: acceptance_due_date = Null,
2998: last_updated_by = FND_GLOBAL.user_id,
2999: last_update_login = FND_GLOBAL.login_id,
3000: last_update_date = sysdate
3001: WHERE po_header_id = p_po_header_id;
3002:
2995: pending_signature_flag = 'N',
2996: acceptance_required_flag = 'N',
2997: acceptance_due_date = Null,
2998: last_updated_by = FND_GLOBAL.user_id,
2999: last_update_login = FND_GLOBAL.login_id,
3000: last_update_date = sysdate
3001: WHERE po_header_id = p_po_header_id;
3002:
3003: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3191: UPDATE PO_HEADERS_DRAFT_ALL
3192: SET pending_signature_flag = 'N',
3193: --acceptance_required_flag = 'N',
3194: acceptance_due_date = Null,
3195: last_updated_by = FND_GLOBAL.user_id,
3196: last_update_login = FND_GLOBAL.login_id,
3197: last_update_date = sysdate
3198: WHERE po_header_id = p_po_header_id
3199: AND draft_id = p_draft_id;
3192: SET pending_signature_flag = 'N',
3193: --acceptance_required_flag = 'N',
3194: acceptance_due_date = Null,
3195: last_updated_by = FND_GLOBAL.user_id,
3196: last_update_login = FND_GLOBAL.login_id,
3197: last_update_date = sysdate
3198: WHERE po_header_id = p_po_header_id
3199: AND draft_id = p_draft_id;
3200: else
3201: UPDATE PO_HEADERS_ALL
3202: SET pending_signature_flag = 'N',
3203: acceptance_required_flag = 'N',
3204: acceptance_due_date = Null,
3205: last_updated_by = FND_GLOBAL.user_id,
3206: last_update_login = FND_GLOBAL.login_id,
3207: last_update_date = sysdate
3208: WHERE po_header_id = p_po_header_id;
3209: end if;
3202: SET pending_signature_flag = 'N',
3203: acceptance_required_flag = 'N',
3204: acceptance_due_date = Null,
3205: last_updated_by = FND_GLOBAL.user_id,
3206: last_update_login = FND_GLOBAL.login_id,
3207: last_update_date = sysdate
3208: WHERE po_header_id = p_po_header_id;
3209: end if;
3210: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3789: WHEN NO_DATA_FOUND THEN
3790: RAISE l_binding_exception;
3791: END;
3792:
3793: l_employee_id := FND_GLOBAL.employee_id; -- bug3738420
3794:
3795: -- If either Supplier or Buyer rejected the document then the PO status
3796: -- should be set to REJECTED from PRE-APPROVED
3797: