DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on ARP_CLAS_PKG

Line 4505: arp_clas_pkg.insert_po_loc_associations(

4501: /* RAISE EXCP_USER_DEFINED;
4502: ELSE
4503:
4504: -- Create the linkage between the site use and the inventory location.
4505: arp_clas_pkg.insert_po_loc_associations(
4506: p_inventory_location_id => l_inv_loc_id,
4507: p_inventory_organization_id => null,
4508: p_customer_id => p_customer_id,
4509: p_address_id => p_address_id,

Line 4823: 'Before calling arp_clas_pkg.insert_po_loc_associations');

4819:
4820: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4821: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4822: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4823: 'Before calling arp_clas_pkg.insert_po_loc_associations');
4824: end if;
4825:
4826: select cust_account_id into l_cust_acct_id
4827: from hz_cust_acct_sites_all

Line 4837: arp_clas_pkg.insert_po_loc_associations(

4833: 'l_cust_acct_id = ' || l_cust_acct_id);
4834: end if;
4835:
4836: -- Create the linkage between the site use and the inventory location.
4837: arp_clas_pkg.insert_po_loc_associations(
4838: p_inventory_location_id => l_inv_loc_id,
4839: p_inventory_organization_id => null,
4840: p_customer_id => l_cust_acct_id,
4841: p_address_id => p_address_id,

Line 4852: 'After calling arp_clas_pkg.insert_po_loc_associations');

4848:
4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4851: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4852: 'After calling arp_clas_pkg.insert_po_loc_associations');
4853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4854: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
4855: 'x_return_status = ' || x_return_status);
4856: end if;

Line 5023: 'Before arp_clas_pkg.insert_po_loc_associations...');

5019:
5020: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5022: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5023: 'Before arp_clas_pkg.insert_po_loc_associations...');
5024: end if;
5025:
5026: -- Create the linkage between the site use and the inventory location.
5027: arp_clas_pkg.insert_po_loc_associations(

Line 5027: arp_clas_pkg.insert_po_loc_associations(

5023: 'Before arp_clas_pkg.insert_po_loc_associations...');
5024: end if;
5025:
5026: -- Create the linkage between the site use and the inventory location.
5027: arp_clas_pkg.insert_po_loc_associations(
5028: p_inventory_location_id => l_inv_loc_id,
5029: p_inventory_organization_id => null,
5030: p_customer_id => p_customer_id,
5031: p_address_id => p_address_id,

Line 5042: 'After arp_clas_pkg.insert_po_loc_associations...');

5038:
5039: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5040: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5041: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5042: 'After arp_clas_pkg.insert_po_loc_associations...');
5043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5044: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',
5045: 'x_return_status = ' || x_return_status);
5046: end if;

Line 6204: arp_clas_pkg.insert_po_loc_associations(

6200: end if;
6201:
6202: -- update inventory_location link for this new site_use
6203: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6204: arp_clas_pkg.insert_po_loc_associations(
6205: p_inventory_location_id => p_hr_location_id,
6206: p_inventory_organization_id => p_dest_org_id,
6207: p_customer_id => p_customer_id,
6208: p_address_id => x_cust_acct_site_id,

Line 6218: 'arp_clas_pkg.insert_po_loc_associations... x_return_status=' || x_return_status);

6214:
6215: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6217: l_module_name,
6218: 'arp_clas_pkg.insert_po_loc_associations... x_return_status=' || x_return_status);
6219: end if;
6220:
6221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6222: l_msg := x_msg_data;