DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PO_MOAC_UTILS_PVT

Line 5339: po_moac_utils_pvt.INITIALIZE;

5335: 'l_org_id = ' || l_org_id);
5336: end if;
5337:
5338: if l_org_id is null then
5339: po_moac_utils_pvt.INITIALIZE;
5340: l_org_id := mo_global.get_current_org_id;
5341: end if;
5342: else
5343: l_org_id := p_org_id;

Line 5879: po_moac_utils_pvt.set_org_context(p_src_org_id);

5875: 'l_current_org_id = ' || l_current_org_id);
5876: end if;
5877:
5878: -- get cust_site record in src ou
5879: po_moac_utils_pvt.set_org_context(p_src_org_id);
5880: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
5881: p_init_msg_list => FND_API.G_TRUE,
5882: p_cust_acct_site_id => p_cust_site_id,
5883: x_cust_acct_site_rec => v_cust_acct_site_rec,

Line 5887: po_moac_utils_pvt.set_org_context(l_current_org_id);

5883: x_cust_acct_site_rec => v_cust_acct_site_rec,
5884: x_return_status => x_return_status,
5885: x_msg_count => x_msg_count,
5886: x_msg_data => x_msg_data);
5887: po_moac_utils_pvt.set_org_context(l_current_org_id);
5888:
5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5890: l_msg := x_msg_data;
5891: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 5914: po_moac_utils_pvt.set_org_context(p_dest_org_id);

5910: v_cust_acct_site_rec.created_by_module := 'CSPSHIPAD';
5911: v_cust_acct_site_rec.org_id := p_dest_org_id;
5912:
5913: -- now create same site in source ou
5914: po_moac_utils_pvt.set_org_context(p_dest_org_id);
5915: hz_cust_account_site_v2pub.create_cust_acct_site (
5916: p_init_msg_list => FND_API.G_TRUE,
5917: p_cust_acct_site_rec => v_cust_acct_site_rec,
5918: x_cust_acct_site_id => x_cust_acct_site_id,

Line 5922: po_moac_utils_pvt.set_org_context(l_current_org_id);

5918: x_cust_acct_site_id => x_cust_acct_site_id,
5919: x_return_status => x_return_status,
5920: x_msg_count => x_msg_count,
5921: x_msg_data => x_msg_data);
5922: po_moac_utils_pvt.set_org_context(l_current_org_id);
5923:
5924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5925: l_msg := x_msg_data;
5926: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 5948: po_moac_utils_pvt.set_org_context(p_src_org_id);

5944: LOOP
5945: FETCH get_cust_acct_site_uses into l_cust_acct_site_use_id;
5946: EXIT WHEN get_cust_acct_site_uses%NOTFOUND;
5947:
5948: po_moac_utils_pvt.set_org_context(p_src_org_id);
5949: hz_cust_account_site_v2pub.get_cust_site_use_rec (
5950: p_init_msg_list => FND_API.G_TRUE,
5951: p_site_use_id => l_cust_acct_site_use_id,
5952: x_cust_site_use_rec => v_cust_site_use_rec,

Line 5957: po_moac_utils_pvt.set_org_context(l_current_org_id);

5953: x_customer_profile_rec => v_customer_profile_rec,
5954: x_return_status => x_return_status,
5955: x_msg_count => x_msg_count,
5956: x_msg_data => x_msg_data);
5957: po_moac_utils_pvt.set_org_context(l_current_org_id);
5958:
5959: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5960: l_msg := x_msg_data;
5961: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6006: po_moac_utils_pvt.set_org_context(p_src_org_id);

6002:
6003: if l_existing_bill_to is null then
6004:
6005: -- do lots of stuff here
6006: po_moac_utils_pvt.set_org_context(p_src_org_id);
6007: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
6008: p_init_msg_list => FND_API.G_TRUE,
6009: p_cust_acct_site_id => v_bill_site_id,
6010: x_cust_acct_site_rec => v_bill_acct_site_rec,

Line 6014: po_moac_utils_pvt.set_org_context(l_current_org_id);

6010: x_cust_acct_site_rec => v_bill_acct_site_rec,
6011: x_return_status => x_return_status,
6012: x_msg_count => x_msg_count,
6013: x_msg_data => x_msg_data);
6014: po_moac_utils_pvt.set_org_context(l_current_org_id);
6015:
6016: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6017: l_msg := x_msg_data;
6018: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6041: po_moac_utils_pvt.set_org_context(p_dest_org_id);

6037: v_bill_acct_site_rec.created_by_module := 'CSPSHIPAD';
6038: v_bill_acct_site_rec.org_id := p_dest_org_id;
6039:
6040: -- now create same site in source ou
6041: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6042: hz_cust_account_site_v2pub.create_cust_acct_site (
6043: p_init_msg_list => FND_API.G_TRUE,
6044: p_cust_acct_site_rec => v_bill_acct_site_rec,
6045: x_cust_acct_site_id => x_bill_acct_site_id,

Line 6049: po_moac_utils_pvt.set_org_context(l_current_org_id);

6045: x_cust_acct_site_id => x_bill_acct_site_id,
6046: x_return_status => x_return_status,
6047: x_msg_count => x_msg_count,
6048: x_msg_data => x_msg_data);
6049: po_moac_utils_pvt.set_org_context(l_current_org_id);
6050:
6051: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6052: l_msg := x_msg_data;
6053: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6071: po_moac_utils_pvt.set_org_context(p_src_org_id);

6067: end if;
6068:
6069: l_bill_acct_site_use_id := v_ship_bill_site;
6070:
6071: po_moac_utils_pvt.set_org_context(p_src_org_id);
6072: hz_cust_account_site_v2pub.get_cust_site_use_rec (
6073: p_init_msg_list => FND_API.G_TRUE,
6074: p_site_use_id => l_bill_acct_site_use_id,
6075: x_cust_site_use_rec => v_bill_site_use_rec,

Line 6080: po_moac_utils_pvt.set_org_context(l_current_org_id);

6076: x_customer_profile_rec => v_bill_cust_profile_rec,
6077: x_return_status => x_return_status,
6078: x_msg_count => x_msg_count,
6079: x_msg_data => x_msg_data);
6080: po_moac_utils_pvt.set_org_context(l_current_org_id);
6081:
6082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6083: l_msg := x_msg_data;
6084: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6106: po_moac_utils_pvt.set_org_context(p_dest_org_id);

6102: v_bill_site_use_rec.created_by_module := 'CSPSHIPAD';
6103: v_bill_site_use_rec.org_id := p_dest_org_id;
6104: v_bill_site_use_rec.cust_acct_site_id := x_bill_acct_site_id;
6105:
6106: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6107: hz_cust_account_site_v2pub.create_cust_site_use (
6108: p_init_msg_list => FND_API.G_TRUE,
6109: p_cust_site_use_rec => v_bill_site_use_rec,
6110: p_customer_profile_rec => v_bill_cust_profile_rec,

Line 6117: po_moac_utils_pvt.set_org_context(l_current_org_id);

6113: x_site_use_id => x_site_use_id,
6114: x_return_status => x_return_status,
6115: x_msg_count => x_msg_count,
6116: x_msg_data => x_msg_data);
6117: po_moac_utils_pvt.set_org_context(l_current_org_id);
6118:
6119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6120: l_msg := x_msg_data;
6121: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6128: po_moac_utils_pvt.set_org_context(l_current_org_id);

6124: fnd_msg_pub.count_and_get
6125: ( p_count => x_msg_count
6126: , p_data => x_msg_data);
6127: x_return_status := FND_API.G_RET_STS_ERROR;
6128: po_moac_utils_pvt.set_org_context(l_current_org_id);
6129: RAISE FND_API.G_EXC_ERROR;
6130: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6131:
6132: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 6156: po_moac_utils_pvt.set_org_context(p_dest_org_id);

6152: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
6153: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
6154: end if;
6155:
6156: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6157: hz_cust_account_site_v2pub.create_cust_site_use (
6158: p_init_msg_list => FND_API.G_TRUE,
6159: p_cust_site_use_rec => v_cust_site_use_rec,
6160: p_customer_profile_rec => v_customer_profile_rec,

Line 6167: po_moac_utils_pvt.set_org_context(l_current_org_id);

6163: x_site_use_id => x_site_use_id,
6164: x_return_status => x_return_status,
6165: x_msg_count => x_msg_count,
6166: x_msg_data => x_msg_data);
6167: po_moac_utils_pvt.set_org_context(l_current_org_id);
6168:
6169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6170: l_msg := x_msg_data;
6171: FND_MESSAGE.SET_NAME('CSP', 'CSP_COPY_SITE_ERRORS');

Line 6178: po_moac_utils_pvt.set_org_context(l_current_org_id);

6174: fnd_msg_pub.count_and_get
6175: ( p_count => x_msg_count
6176: , p_data => x_msg_data);
6177: x_return_status := FND_API.G_RET_STS_ERROR;
6178: po_moac_utils_pvt.set_org_context(l_current_org_id);
6179: RAISE FND_API.G_EXC_ERROR;
6180: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6181:
6182: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 6203: po_moac_utils_pvt.set_org_context(p_dest_org_id);

6199: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);
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,

Line 6213: po_moac_utils_pvt.set_org_context(l_current_org_id);

6209: p_site_use_id => temp_ship_to_use_id,
6210: x_return_status => x_return_status,
6211: x_msg_count => x_msg_count,
6212: x_msg_data => x_msg_data);
6213: po_moac_utils_pvt.set_org_context(l_current_org_id);
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,