[Home] [Help]
3109: LAST_UPDATED_BY,LAST_UPDATE_LOGIN) VALUES
3110: (QP_UPGRADE_ERRORS_S.NEXTVAL,USERENV('SESSIONID'),
3111: P_ID1,P_ID2,P_ID3,P_ID4,P_ID5,P_ID6,P_ID7,P_ID8,
3112: P_ERROR_TYPE, SUBSTR(P_ERROR_DESC,1,240),P_ERROR_MODULE,SYSDATE,
3113: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,FND_GLOBAL.LOGIN_ID);
3114: COMMIT;
3115:
3116: END;
3117:
5009: /*
5010: commenting this code R12 per ER 4756750 to move the profile-based
5011: approach for all calling app and come up with a pricing parameter
5012: for the item validation Org per the ER
5013: l_application_id := fnd_global.resp_appl_id;
5014:
5015: oe_debug_pub.add('l_application_id = '||l_application_id);
5016: if l_application_id in (201, 178) then -- oracle purchasing/iProcurement
5017: SELECT inventory_organization_id
5061: RETURN NUMBER IS
5062: l_context_org_id NUMBER;
5063: BEGIN
5064: l_context_org_id := MO_GLOBAL.get_current_org_id;
5065: -- IF (FND_GLOBAL.USER_ID IS NOT NULL) AND (FND_GLOBAL.RESP_ID IS NOT NULL) AND (FND_GLOBAL.RESP_APPL_ID IS NOT NULL) THEN
5066: IF l_context_org_id IS NOT NULL THEN
5067: --check if org context is set
5068: RETURN l_context_org_id; --MO_GLOBAL.get_current_org_id;
5069: ELSE
5164: RETURN FALSE;
5165: END;
5166:
5167: -- If the database is a seed DB and the user is DATAMERGE, return TRUE
5168: IF l_db_name LIKE 'SEED%' AND l_dm_user_id = fnd_global.user_id THEN
5169: RETURN TRUE;
5170: ELSE
5171: RETURN FALSE;
5172: END IF;
5176:
5177: FUNCTION Validate_Item(p_product_context IN VARCHAR2,
5178: p_product_attribute IN VARCHAR2,
5179: p_product_attr_val IN VARCHAR2) RETURN VARCHAR2 IS
5180: l_appl_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
5181: l_dummy VARCHAR2(30);
5182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5183: BEGIN
5184: