eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_VENDOR_SITES_PKG dependencies on PO_LOCATION_ASSOCIATIONS

Line 507: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';

503: );
504:
505: if (X_Shipping_Location_id is not null) then
506:
507: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
508:
509: ap_po_locn_association_pkg.insert_row( p_location_id => X_Shipping_Location_id,
510: p_vendor_id => X_Vendor_Id,
511: p_vendor_site_id => X_Vendor_Site_Id,

Line 840: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';

836: );
837:
838: if (p_vendor_site_rec.Shipping_Location_id is not null) then
839:
840: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
841:
842: ap_po_locn_association_pkg.insert_row(
843: p_location_id => p_vendor_site_rec.Ship_to_Location_id,
844: p_vendor_id => p_vendor_site_rec.Vendor_Id,

Line 1436: from po_location_associations

1432:
1433: begin
1434: select location_id
1435: into l_shipping_location_id
1436: from po_location_associations
1437: where vendor_site_id = X_Vendor_Site_Id;
1438: exception
1439: when no_data_found then
1440: l_shipping_location_id := NULL;

Line 1785: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';

1781: if (SQL%NOTFOUND) then
1782: Raise NO_DATA_FOUND;
1783: end if;
1784:
1785: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
1786: --Bug 2697177: Added the IF condition
1787: if (X_Shipping_Location_id is not null) then
1788:
1789: ap_po_locn_association_pkg.update_row(p_location_id => X_Shipping_Location_id,

Line 1975: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';

1971: if (SQL%NOTFOUND) then
1972: Raise NO_DATA_FOUND;
1973: end if;
1974:
1975: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
1976: if (p_vendor_site_rec.Shipping_Location_id is not null) then
1977:
1978: ap_po_locn_association_pkg.update_row(
1979: p_location_id => p_vendor_site_rec.Shipping_Location_id,

Line 1980: /* 5945837: Shipping_Location_id is stored in po_location_associations*/

1976: if (p_vendor_site_rec.Shipping_Location_id is not null) then
1977:
1978: ap_po_locn_association_pkg.update_row(
1979: p_location_id => p_vendor_site_rec.Shipping_Location_id,
1980: /* 5945837: Shipping_Location_id is stored in po_location_associations*/
1981: p_vendor_id => p_vendor_site_rec.Vendor_Id,
1982: p_vendor_site_id => P_Vendor_Site_Id,
1983: p_last_update_date => p_Last_Update_Date,
1984: p_last_updated_by => p_Last_Updated_By,