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 508: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';

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

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

877: );
878:
879: if (p_vendor_site_rec.Shipping_Location_id is not null) then
880:
881: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
882:
883: ap_po_locn_association_pkg.insert_row(
884: p_location_id => p_vendor_site_rec.Ship_to_Location_id,
885: p_vendor_id => p_vendor_site_rec.Vendor_Id,

Line 1477: from po_location_associations

1473:
1474: begin
1475: select location_id
1476: into l_shipping_location_id
1477: from po_location_associations
1478: where vendor_site_id = X_Vendor_Site_Id;
1479: exception
1480: when no_data_found then
1481: l_shipping_location_id := NULL;

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

1830: if (SQL%NOTFOUND) then
1831: Raise NO_DATA_FOUND;
1832: end if;
1833:
1834: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
1835: --Bug 2697177: Added the IF condition
1836: if (X_Shipping_Location_id is not null and X_Shipping_Location_id <> ap_null_num) then /*Bug 11724842*/
1837:
1838: ap_po_locn_association_pkg.update_row(p_location_id => X_Shipping_Location_id,

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

2051: if (SQL%NOTFOUND) then
2052: Raise NO_DATA_FOUND;
2053: end if;
2054:
2055: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
2056: if (p_vendor_site_rec.Shipping_Location_id is not null and p_vendor_site_rec.Shipping_Location_id <> ap_null_num) then /*Bug11724842 */
2057:
2058: ap_po_locn_association_pkg.update_row(
2059: p_location_id => p_vendor_site_rec.Shipping_Location_id,

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

2056: if (p_vendor_site_rec.Shipping_Location_id is not null and p_vendor_site_rec.Shipping_Location_id <> ap_null_num) then /*Bug11724842 */
2057:
2058: ap_po_locn_association_pkg.update_row(
2059: p_location_id => p_vendor_site_rec.Shipping_Location_id,
2060: /* 5945837: Shipping_Location_id is stored in po_location_associations*/
2061: p_vendor_id => p_vendor_site_rec.Vendor_Id,
2062: p_vendor_site_id => P_Vendor_Site_Id,
2063: p_last_update_date => p_Last_Update_Date,
2064: p_last_updated_by => p_Last_Updated_By,