[Home] [Help]
5144: FOR i IN c_intf_rows LOOP
5145: Debug_Conc_Log('Processing for Item, Org='||TO_CHAR(i.INVENTORY_ITEM_ID)||', '||TO_CHAR(i.ORGANIZATION_ID));
5146: -- checking the edit cross reference privilege for creating GTIN xref.
5147: --l_priv := EGO_ITEM_AML_PUB.Check_No_AML_Priv(1.0, i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID, 'EGO_EDIT_ITEM_XREFS', NULL, NULL);
5148: l_priv := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_ITEM_XREFS', 'EGO_ITEM', i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID, NULL, NULL, NULL, l_party_name);
5149:
5150: IF NVL(l_priv, 'F') <> 'T' THEN
5151: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
7312: -- c. with no PDH item key information at all.
7313: l_party_name := Get_Current_Party_Name;
7314:
7315: -- getting security predicate
7316: EGO_DATA_SECURITY.get_security_predicate(
7317: p_api_version => 1.0
7318: ,p_function => 'EGO_VIEW_SS_ITEM_XREFS'
7319: ,p_object_name => 'EGO_ITEM'
7320: ,p_user_name => l_party_name
8122:
8123: l_party_name := Get_Current_Party_Name;
8124:
8125: -- getting security predicate
8126: EGO_DATA_SECURITY.get_security_predicate(
8127: p_api_version => 1.0
8128: ,p_function => 'EGO_EDIT_SS_ITEM_XREFS'
8129: ,p_object_name => 'EGO_ITEM'
8130: ,p_user_name => l_party_name
8991: AND MSII.ORGANIZATION_ID = l_org_id);
8992:
8993: Debug_Conc_Log('Resolve_Child_Entities - After resolving intersection rows' );
8994: -- getting security predicate
8995: EGO_DATA_SECURITY.get_security_predicate(
8996: p_api_version => 1.0
8997: ,p_function => 'EGO_VIEW_SS_ITEM_XREFS'
8998: ,p_object_name => 'EGO_ITEM'
8999: ,p_user_name => l_party_name
9912: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE-1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE+1);
9913:
9914: IF l_xref_item_id <> l_item_id THEN
9915: -- old xref and new xref are not same, so check privilege on old item
9916: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_xref_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9917: IF 'T' <> l_priv_exists THEN
9918: -- no privileges, logging error
9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9927: x_err_msg := l_msg_text;
9928: RETURN;
9929: ELSE
9930: -- privilege exists on old item. Check privilege on new item
9931: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9932: IF 'T' <> l_priv_exists THEN
9933: -- no privileges, logging error
9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9946: END IF; -- IF 'T' <> l_priv_exists THEN
9947: END IF; -- IF 'T' <> l_priv_exists THEN
9948: ELSIF l_xref_item_id = l_item_id AND NVL(l_ssr_desc, '!') <> NVL(l_xref_desc, '!') THEN
9949: -- New and Old link are same, but description is different, so check privilege on item
9950: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9951: IF 'T' <> l_priv_exists THEN
9952: -- no privileges, logging error
9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9966: END IF; -- IF l_xref_item_id <> l_item_id THEN
9967: EXCEPTION
9968: WHEN NO_DATA_FOUND THEN
9969: -- check privilege only for new item
9970: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9971: IF 'T' <> l_priv_exists THEN
9972: -- no privileges, logging error
9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);