DBA Data[Home] [Help]

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 5510: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);

5506: --inorder to be consistent will pass it as done by PO.
5507:
5508: l_stmt_num := 30;
5509: IF PG_DEBUG <> 0 THEN
5510: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);
5511: END IF;
5512: --call mrp_sourcing to get vendor and vendor_site_id
5513: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(
5514: arg_mode =>p_source_type_code,

Line 5513: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(

5509: IF PG_DEBUG <> 0 THEN
5510: oe_debug_pub.add('Get_opm_charge_account: ' || 'Calling MRP_SOURCING_API_PK.mrp_sourcing',5);
5511: END IF;
5512: --call mrp_sourcing to get vendor and vendor_site_id
5513: l_return_code := MRP_SOURCING_API_PK.mrp_sourcing(
5514: arg_mode =>p_source_type_code,
5515: arg_item_id =>p_item_id,
5516: arg_commodity_id =>l_category_id,
5517: arg_dest_organization_id =>p_destination_org_id,

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

5525: arg_error_message =>l_error_message);
5526:
5527: IF l_return_code THEN
5528: IF PG_DEBUG <> 0 THEN
5529: oe_debug_pub.add('Get_opm_charge_account: ' || 'success from MRP_SOURCING_API_PK.mrp_sourcing',3);
5530: oe_debug_pub.add('Get_opm_charge_account: ' || 'Vendor ID : '||to_char(l_vendor_id),3);
5531: oe_debug_pub.add('Get_opm_charge_account: ' || 'Vendor site ID : '||to_char(l_vendor_site_id),3);
5532: END IF;
5533:

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

5533:
5534:
5535: ELSE
5536: IF PG_DEBUG <> 0 THEN
5537: oe_debug_pub.add('Get_opm_charge_account:'||'Failed in MRP_SOURCING_API_PK.mrp_sourcing' ,1);
5538: oe_debug_pub.add('Get_opm_charge_account:'||l_error_message,1);
5539: --talked to usha arora. This error is not important enough to
5540: --stop process
5541: oe_debug_pub.add('Get_opm_charge_account:'||'Ignoring above error and proceeding further',1);