[Home] [Help]
3096: LAST_UPDATED_BY,LAST_UPDATE_LOGIN) VALUES
3097: (QP_UPGRADE_ERRORS_S.NEXTVAL,USERENV('SESSIONID'),
3098: P_ID1,P_ID2,P_ID3,P_ID4,P_ID5,P_ID6,P_ID7,P_ID8,
3099: P_ERROR_TYPE, SUBSTR(P_ERROR_DESC,1,240),P_ERROR_MODULE,SYSDATE,
3100: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,FND_GLOBAL.LOGIN_ID);
3101: COMMIT;
3102:
3103: END;
3104:
4986: /*
4987: commenting this code R12 per ER 4756750 to move the profile-based
4988: approach for all calling app and come up with a pricing parameter
4989: for the item validation Org per the ER
4990: l_application_id := fnd_global.resp_appl_id;
4991:
4992: oe_debug_pub.add('l_application_id = '||l_application_id);
4993: if l_application_id in (201, 178) then -- oracle purchasing/iProcurement
4994: SELECT inventory_organization_id
5038: RETURN NUMBER IS
5039: l_context_org_id NUMBER;
5040: BEGIN
5041: l_context_org_id := MO_GLOBAL.get_current_org_id;
5042: -- 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
5043: IF l_context_org_id IS NOT NULL THEN
5044: --check if org context is set
5045: RETURN l_context_org_id; --MO_GLOBAL.get_current_org_id;
5046: ELSE
5141: RETURN FALSE;
5142: END;
5143:
5144: -- If the database is a seed DB and the user is DATAMERGE, return TRUE
5145: IF l_db_name LIKE 'SEED%' AND l_dm_user_id = fnd_global.user_id THEN
5146: RETURN TRUE;
5147: ELSE
5148: RETURN FALSE;
5149: END IF;
5153:
5154: FUNCTION Validate_Item(p_product_context IN VARCHAR2,
5155: p_product_attribute IN VARCHAR2,
5156: p_product_attr_val IN VARCHAR2) RETURN VARCHAR2 IS
5157: l_appl_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
5158: l_dummy VARCHAR2(30);
5159: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5160: BEGIN
5161: