[Home] [Help]
1305: CLOSE l_vendors_csr;
1306:
1307:
1308: if(p_secure_by_site = 'T') then
1309: open l_checkVendorSites_csr(fnd_global.user_id);
1310: loop
1311: fetch l_checkVendorSites_csr into l_error_ln;
1312: exit when l_checkVendorSites_csr%NOTFOUND;
1313: l_failSecure := 'T';
1320: close l_checkVendorSites_csr;
1321: end if;
1322:
1323: if(p_secure_by_contact = 'T') then
1324: open l_checkVendorContacts_csr(fnd_global.user_id);
1325: loop
1326: fetch l_checkVendorContacts_csr into l_error_ln;
1327: exit when l_checkVendorContacts_csr%NOTFOUND;
1328: l_failSecure := 'T';
3765: primary_quantity,
3766: uom,
3767: primary_uom,
3768: sysdate,
3769: fnd_global.user_id,
3770: fnd_global.user_id,
3771: sysdate,
3772: fnd_global.user_id,
3773: item_id,
3766: uom,
3767: primary_uom,
3768: sysdate,
3769: fnd_global.user_id,
3770: fnd_global.user_id,
3771: sysdate,
3772: fnd_global.user_id,
3773: item_id,
3774: item_revision,
3768: sysdate,
3769: fnd_global.user_id,
3770: fnd_global.user_id,
3771: sysdate,
3772: fnd_global.user_id,
3773: item_id,
3774: item_revision,
3775: expected_receipt_date,
3776: comments,
3867: 'PENDING',
3868: 'VENDOR',
3869: 'NEW',
3870: sysdate,
3871: fnd_global.user_id,
3872: fnd_global.user_id,
3873: sysdate,
3874: fnd_global.user_id,
3875: ship_to_org_id,
3868: 'VENDOR',
3869: 'NEW',
3870: sysdate,
3871: fnd_global.user_id,
3872: fnd_global.user_id,
3873: sysdate,
3874: fnd_global.user_id,
3875: ship_to_org_id,
3876: vendor_id,
3870: sysdate,
3871: fnd_global.user_id,
3872: fnd_global.user_id,
3873: sysdate,
3874: fnd_global.user_id,
3875: ship_to_org_id,
3876: vendor_id,
3877: vendor_site_id,
3878: shipment_date,
3932:
3933: cursor l_vendorId_csr is
3934: SELECT NUMBER_VALUE
3935: FROM AK_WEB_USER_SEC_ATTR_VALUES
3936: WHERE WEB_USER_ID = FND_GLOBAL.USER_ID
3937: AND ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
3938: AND ATTRIBUTE_APPLICATION_ID = 177;
3939:
3940:
3976:
3977: BEGIN
3978: x_secure_by_site := 'F';
3979: x_secure_by_contact := 'F';
3980: open l_orgSecure_csr(fnd_global.resp_id);
3981: fetch l_orgSecure_csr into l_num;
3982:
3983: l_num := null;
3984: open l_siteSecure_csr(fnd_global.resp_id);
3980: open l_orgSecure_csr(fnd_global.resp_id);
3981: fetch l_orgSecure_csr into l_num;
3982:
3983: l_num := null;
3984: open l_siteSecure_csr(fnd_global.resp_id);
3985: fetch l_siteSecure_csr into l_num;
3986: if(l_num = 1) then
3987: x_secure_by_site := 'T';
3988: end if;
3987: x_secure_by_site := 'T';
3988: end if;
3989:
3990: l_num := null;
3991: open l_contactSecure_csr(fnd_global.resp_id);
3992: fetch l_contactSecure_csr into l_num;
3993: if(l_num = 1) then
3994: x_secure_by_contact := 'T';
3995: end if;
4042: --Find out if -9999 is defined for Site for user's responsibility
4043: SELECT number_value
4044: into l_num
4045: FROM AK_RESP_SECURITY_ATTR_VALUES
4046: WHERE responsibility_id = fnd_global.resp_id
4047: AND attribute_application_id = 177
4048: AND attribute_code = 'ICX_SUPPLIER_SITE_ID'
4049: AND number_value = -9999;
4050:
4049: AND number_value = -9999;
4050:
4051: l_num := null;
4052: --IF -9999 is defined, and user is not secured by Vendor_Site_id, then it is the same as not be secured by site
4053: open l_vendorSite_csr(fnd_global.user_id);
4054: fetch l_vendorSite_csr into l_num;
4055: close l_vendorSite_csr;
4056: if(l_num is null) then
4057: x_secure_by_site := 'F';
4059:
4060: exception when others then
4061: --If -9999 is NOT defined, then user has to be secured by Site
4062: l_num := null;
4063: open l_vendorSite_csr(fnd_global.user_id);
4064: fetch l_vendorSite_csr into l_num;
4065: close l_vendorSite_csr;
4066: if(l_num is null) then
4067: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
4080: --Find out if -9999 is defined for Site for user's responsibility
4081: SELECT number_value
4082: into l_num
4083: FROM AK_RESP_SECURITY_ATTR_VALUES
4084: WHERE responsibility_id = fnd_global.resp_id
4085: AND attribute_application_id = 177
4086: AND attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
4087: AND number_value = -9999;
4088:
4087: AND number_value = -9999;
4088:
4089: l_num := null;
4090: --IF -9999 is defined, and user is not secured by Contact, then it is the same as not be secured by contact
4091: open l_vendorContact_csr(fnd_global.user_id);
4092: fetch l_vendorContact_csr into l_num;
4093: close l_vendorContact_csr;
4094: if(l_num is null) then
4095: x_secure_by_contact := 'F';
4096: end if;
4097:
4098: exception when others then
4099: --If -9999 is NOT defined, then user has to be secured by Contact
4100: open l_vendorContact_csr(fnd_global.user_id);
4101: fetch l_vendorContact_csr into l_num;
4102: close l_vendorContact_csr;
4103: if(l_num is null) then
4104: fnd_message.set_name('POS','POS_EXASN_NOT_CT_SEC');
4238: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4239:
4240: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4241: --ICX_SUPPLIER_ORG_ID
4242: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;
4243: x_user_vendor_id :=POS_VENDOR_UTIL_PKG.GET_PO_VENDOR_ID_FOR_USER(l_user_name);
4244:
4245: -- Check Securing Attributes
4246:
4421: POS_ASN_NOTIF.GENERATE_NOTIF ( p_shipment_num => l_shipment_number,
4422: p_notif_type => 'CREATE',
4423: p_vendor_id => l_vendor_id,
4424: p_vendor_site_id => l_vendor_site_id,
4425: p_user_id => fnd_global.user_id
4426: );
4427: end loop;
4428: close l_buyerNotif_csr;
4429: