[Home] [Help]
5078: FOR i IN c_intf_rows LOOP
5079: Debug_Conc_Log('Processing for Item, Org='||TO_CHAR(i.INVENTORY_ITEM_ID)||', '||TO_CHAR(i.ORGANIZATION_ID));
5080: -- checking the edit cross reference privilege for creating GTIN xref.
5081: --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);
5082: 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);
5083:
5084: IF NVL(l_priv, 'F') <> 'T' THEN
5085: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5086: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
7218: -- c. with no PDH item key information at all.
7219: l_party_name := Get_Current_Party_Name;
7220:
7221: -- getting security predicate
7222: EGO_DATA_SECURITY.get_security_predicate(
7223: p_api_version => 1.0
7224: ,p_function => 'EGO_VIEW_SS_ITEM_XREFS'
7225: ,p_object_name => 'EGO_ITEM'
7226: ,p_user_name => l_party_name
8019:
8020: l_party_name := Get_Current_Party_Name;
8021:
8022: -- getting security predicate
8023: EGO_DATA_SECURITY.get_security_predicate(
8024: p_api_version => 1.0
8025: ,p_function => 'EGO_EDIT_SS_ITEM_XREFS'
8026: ,p_object_name => 'EGO_ITEM'
8027: ,p_user_name => l_party_name
8888: AND MSII.ORGANIZATION_ID = l_org_id);
8889:
8890: Debug_Conc_Log('Resolve_Child_Entities - After resolving intersection rows' );
8891: -- getting security predicate
8892: EGO_DATA_SECURITY.get_security_predicate(
8893: p_api_version => 1.0
8894: ,p_function => 'EGO_VIEW_SS_ITEM_XREFS'
8895: ,p_object_name => 'EGO_ITEM'
8896: ,p_user_name => l_party_name
9809: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE-1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE+1);
9810:
9811: IF l_xref_item_id <> l_item_id THEN
9812: -- old xref and new xref are not same, so check privilege on old item
9813: 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);
9814: IF 'T' <> l_priv_exists THEN
9815: -- no privileges, logging error
9816: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9817: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9824: x_err_msg := l_msg_text;
9825: RETURN;
9826: ELSE
9827: -- privilege exists on old item. Check privilege on new item
9828: 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);
9829: IF 'T' <> l_priv_exists THEN
9830: -- no privileges, logging error
9831: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9832: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9843: END IF; -- IF 'T' <> l_priv_exists THEN
9844: END IF; -- IF 'T' <> l_priv_exists THEN
9845: ELSIF l_xref_item_id = l_item_id AND NVL(l_ssr_desc, '!') <> NVL(l_xref_desc, '!') THEN
9846: -- New and Old link are same, but description is different, so check privilege on item
9847: 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);
9848: IF 'T' <> l_priv_exists THEN
9849: -- no privileges, logging error
9850: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9851: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9863: END IF; -- IF l_xref_item_id <> l_item_id THEN
9864: EXCEPTION
9865: WHEN NO_DATA_FOUND THEN
9866: -- check privilege only for new item
9867: 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);
9868: IF 'T' <> l_priv_exists THEN
9869: -- no privileges, logging error
9870: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9871: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);