[Home] [Help]
1264: CLOSE l_vendors_csr;
1265:
1266:
1267: if(p_secure_by_site = 'T') then
1268: open l_checkVendorSites_csr(fnd_global.user_id);
1269: loop
1270: fetch l_checkVendorSites_csr into l_error_ln;
1271: exit when l_checkVendorSites_csr%NOTFOUND;
1272: l_failSecure := 'T';
1279: close l_checkVendorSites_csr;
1280: end if;
1281:
1282: if(p_secure_by_contact = 'T') then
1283: open l_checkVendorContacts_csr(fnd_global.user_id);
1284: loop
1285: fetch l_checkVendorContacts_csr into l_error_ln;
1286: exit when l_checkVendorContacts_csr%NOTFOUND;
1287: l_failSecure := 'T';
3692: primary_quantity,
3693: uom,
3694: primary_uom,
3695: sysdate,
3696: fnd_global.user_id,
3697: fnd_global.user_id,
3698: sysdate,
3699: fnd_global.user_id,
3700: item_id,
3693: uom,
3694: primary_uom,
3695: sysdate,
3696: fnd_global.user_id,
3697: fnd_global.user_id,
3698: sysdate,
3699: fnd_global.user_id,
3700: item_id,
3701: item_revision,
3695: sysdate,
3696: fnd_global.user_id,
3697: fnd_global.user_id,
3698: sysdate,
3699: fnd_global.user_id,
3700: item_id,
3701: item_revision,
3702: expected_receipt_date,
3703: comments,
3793: 'PENDING',
3794: 'VENDOR',
3795: 'NEW',
3796: sysdate,
3797: fnd_global.user_id,
3798: fnd_global.user_id,
3799: sysdate,
3800: fnd_global.user_id,
3801: ship_to_org_id,
3794: 'VENDOR',
3795: 'NEW',
3796: sysdate,
3797: fnd_global.user_id,
3798: fnd_global.user_id,
3799: sysdate,
3800: fnd_global.user_id,
3801: ship_to_org_id,
3802: vendor_id,
3796: sysdate,
3797: fnd_global.user_id,
3798: fnd_global.user_id,
3799: sysdate,
3800: fnd_global.user_id,
3801: ship_to_org_id,
3802: vendor_id,
3803: vendor_site_id,
3804: shipment_date,
3858:
3859: cursor l_vendorId_csr is
3860: SELECT NUMBER_VALUE
3861: FROM AK_WEB_USER_SEC_ATTR_VALUES
3862: WHERE WEB_USER_ID = FND_GLOBAL.USER_ID
3863: AND ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
3864: AND ATTRIBUTE_APPLICATION_ID = 177;
3865:
3866:
3902:
3903: BEGIN
3904: x_secure_by_site := 'F';
3905: x_secure_by_contact := 'F';
3906: open l_orgSecure_csr(fnd_global.resp_id);
3907: fetch l_orgSecure_csr into l_num;
3908:
3909: l_num := null;
3910: open l_siteSecure_csr(fnd_global.resp_id);
3906: open l_orgSecure_csr(fnd_global.resp_id);
3907: fetch l_orgSecure_csr into l_num;
3908:
3909: l_num := null;
3910: open l_siteSecure_csr(fnd_global.resp_id);
3911: fetch l_siteSecure_csr into l_num;
3912: if(l_num = 1) then
3913: x_secure_by_site := 'T';
3914: end if;
3913: x_secure_by_site := 'T';
3914: end if;
3915:
3916: l_num := null;
3917: open l_contactSecure_csr(fnd_global.resp_id);
3918: fetch l_contactSecure_csr into l_num;
3919: if(l_num = 1) then
3920: x_secure_by_contact := 'T';
3921: end if;
3968: --Find out if -9999 is defined for Site for user's responsibility
3969: SELECT number_value
3970: into l_num
3971: FROM AK_RESP_SECURITY_ATTR_VALUES
3972: WHERE responsibility_id = fnd_global.resp_id
3973: AND attribute_application_id = 177
3974: AND attribute_code = 'ICX_SUPPLIER_SITE_ID'
3975: AND number_value = -9999;
3976:
3975: AND number_value = -9999;
3976:
3977: l_num := null;
3978: --IF -9999 is defined, and user is not secured by Vendor_Site_id, then it is the same as not be secured by site
3979: open l_vendorSite_csr(fnd_global.user_id);
3980: fetch l_vendorSite_csr into l_num;
3981: close l_vendorSite_csr;
3982: if(l_num is null) then
3983: x_secure_by_site := 'F';
3985:
3986: exception when others then
3987: --If -9999 is NOT defined, then user has to be secured by Site
3988: l_num := null;
3989: open l_vendorSite_csr(fnd_global.user_id);
3990: fetch l_vendorSite_csr into l_num;
3991: close l_vendorSite_csr;
3992: if(l_num is null) then
3993: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
4006: --Find out if -9999 is defined for Site for user's responsibility
4007: SELECT number_value
4008: into l_num
4009: FROM AK_RESP_SECURITY_ATTR_VALUES
4010: WHERE responsibility_id = fnd_global.resp_id
4011: AND attribute_application_id = 177
4012: AND attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
4013: AND number_value = -9999;
4014:
4013: AND number_value = -9999;
4014:
4015: l_num := null;
4016: --IF -9999 is defined, and user is not secured by Contact, then it is the same as not be secured by contact
4017: open l_vendorContact_csr(fnd_global.user_id);
4018: fetch l_vendorContact_csr into l_num;
4019: close l_vendorContact_csr;
4020: if(l_num is null) then
4021: x_secure_by_contact := 'F';
4022: end if;
4023:
4024: exception when others then
4025: --If -9999 is NOT defined, then user has to be secured by Contact
4026: open l_vendorContact_csr(fnd_global.user_id);
4027: fetch l_vendorContact_csr into l_num;
4028: close l_vendorContact_csr;
4029: if(l_num is null) then
4030: fnd_message.set_name('POS','POS_EXASN_NOT_CT_SEC');
4164: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4165:
4166: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4167: --ICX_SUPPLIER_ORG_ID
4168: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;
4169: x_user_vendor_id :=POS_VENDOR_UTIL_PKG.GET_PO_VENDOR_ID_FOR_USER(l_user_name);
4170:
4171: -- Check Securing Attributes
4172:
4347: POS_ASN_NOTIF.GENERATE_NOTIF ( p_shipment_num => l_shipment_number,
4348: p_notif_type => 'CREATE',
4349: p_vendor_id => l_vendor_id,
4350: p_vendor_site_id => l_vendor_site_id,
4351: p_user_id => fnd_global.user_id
4352: );
4353: end loop;
4354: close l_buyerNotif_csr;
4355: