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.CTO_AUTO_PROCURE_PK dependencies on MRP_SOURCING_API_PK

Line 179: | Calling MRP_SOURCING_API_PK.mrp_sourcing to get sourcing

175: | Created new local procedure Get_opm_charge_account
176: | calling SLA OPM api to get charge and accrual account id
177: | Dependency: aru#4610085(pack spec and stubbed out pkg body)
178: | GMF_transaction_accounts_PUB.get_accounts
179: | Calling MRP_SOURCING_API_PK.mrp_sourcing to get sourcing
180: | vendor and vendor site id. This API has been there from 11.5.10
181: | Talked to Usha, we dont require a dependent aru for this.
182: |
183: |

Line 5087: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);

5083: --inorder to be consistent will pass it as done by PO.
5084:
5085: l_stmt_num := 30;
5086: IF PG_DEBUG <> 0 THEN
5087: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);
5088: END IF;
5089: --call mrp_sourcing to get vendor and vendor_site_id
5090: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(
5091: arg_mode =>p_source_type_code,

Line 5090: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(

5086: IF PG_DEBUG <> 0 THEN
5087: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);
5088: END IF;
5089: --call mrp_sourcing to get vendor and vendor_site_id
5090: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(
5091: arg_mode =>p_source_type_code,
5092: arg_item_id =>p_item_id,
5093: arg_commodity_id =>l_category_id,
5094: arg_dest_organization_id =>p_destination_org_id,

Line 5106: oe_debug_pub.add('Get_opm_charge_account: ' || 'success from MRP_SOURCING_API_PK.mrp_sourcing',3);

5102: arg_error_message =>l_error_message);
5103:
5104: IF l_return_code THEN
5105: IF PG_DEBUG <> 0 THEN
5106: oe_debug_pub.add('Get_opm_charge_account: ' || 'success from MRP_SOURCING_API_PK.mrp_sourcing',3);
5107: oe_debug_pub.add('Get_opm_charge_account: ' || 'Vendor ID : '||to_char(l_vendor_id),3);
5108: oe_debug_pub.add('Get_opm_charge_account: ' || 'Vendor site ID : '||to_char(l_vendor_site_id),3);
5109: END IF;
5110:

Line 5114: oe_debug_pub.add('Get_opm_charge_account:'||'Failed in MRP_SOURCING_API_PK.mrp_sourcing' ,1);

5110:
5111:
5112: ELSE
5113: IF PG_DEBUG <> 0 THEN
5114: oe_debug_pub.add('Get_opm_charge_account:'||'Failed in MRP_SOURCING_API_PK.mrp_sourcing' ,1);
5115: oe_debug_pub.add('Get_opm_charge_account:'||l_error_message,1);
5116: --talked to usha arora. This error is not important enough to
5117: --stop process
5118: oe_debug_pub.add('Get_opm_charge_account:'||'Ignoring above error and proceeding further',1);