DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on IBE_ADDRESS_V2PVT

Line 18: - validates the address usage via calls to IBE_ADDRESS_V2PVT.valid_usages

14:
15: Get_Settings
16: - retrives the foreign keys from IBE_ORD_ONECLICK
17: - retrives user's main email address associated with partyid in HZ_PARTIES
18: - validates the address usage via calls to IBE_ADDRESS_V2PVT.valid_usages
19:
20: Key Input: party id and account id
21:
22: NOTE: this api can be TRANSACTIONAL in that if an address is not valid,

Line 184: ibe_util.debug('Calling IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

180: if (x_BILL_PTYSITE_ID is not null) then
181: -- call address validation apis; if either is not valid turn settings off
182: l_usage_codes(1) := 'BILL_TO_COUNTRY';
183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
184: ibe_util.debug('Calling IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
185: ibe_util.debug(' party_site_id: ' || x_BILL_PTYSITE_ID);
186: ibe_util.debug(' operating_unit_id: ' || l_org_id);
187: ibe_util.debug(' usage_code: ' || l_usage_codes(1));
188: END IF;

Line 189: IBE_ADDRESS_V2PVT.valid_usages (

185: ibe_util.debug(' party_site_id: ' || x_BILL_PTYSITE_ID);
186: ibe_util.debug(' operating_unit_id: ' || l_org_id);
187: ibe_util.debug(' usage_code: ' || l_usage_codes(1));
188: END IF;
189: IBE_ADDRESS_V2PVT.valid_usages (
190: p_api_version => l_api_version,
191: p_init_msg_list => FND_API.G_FALSE,
192: p_party_site_id => x_BILL_PTYSITE_ID,
193: p_operating_unit_id => l_org_id,

Line 201: ibe_util.debug('Back from IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data );
199: --ibe_util.enable_debug;
200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
201: ibe_util.debug('Back from IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
202: ibe_util.debug(' return_code: ' || l_return_codes(1));
203: END IF;
204:
205: if x_return_status <> FND_API.g_ret_sts_success then

Line 207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);

203: END IF;
204:
205: if x_return_status <> FND_API.g_ret_sts_success then
206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

Line 210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );

206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
214: RAISE FND_API.G_EXC_ERROR;

Line 230: ibe_util.debug('Calling IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

226: if (x_SHIP_PTYSITE_ID is not null) then
227: -- call address validation apis; if either is not valid turn settings off
228: l_usage_codes(1) := 'SHIP_TO_COUNTRY';
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
230: ibe_util.debug('Calling IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
231: ibe_util.debug(' party_site_id: ' || x_SHIP_PTYSITE_ID);
232: ibe_util.debug(' operating_unit_id: ' || l_org_id);
233: ibe_util.debug(' usage_code: ' || l_usage_codes(1));
234: END IF;

Line 235: IBE_ADDRESS_V2PVT.valid_usages (

231: ibe_util.debug(' party_site_id: ' || x_SHIP_PTYSITE_ID);
232: ibe_util.debug(' operating_unit_id: ' || l_org_id);
233: ibe_util.debug(' usage_code: ' || l_usage_codes(1));
234: END IF;
235: IBE_ADDRESS_V2PVT.valid_usages (
236: p_api_version => l_api_version,
237: p_init_msg_list => FND_API.G_FALSE,
238: p_party_site_id => x_SHIP_PTYSITE_ID,
239: p_operating_unit_id => l_org_id,

Line 247: ibe_util.debug('Back from IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data );
245: --ibe_util.enable_debug;
246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: ibe_util.debug('Back from IBE_ADDRESS_V2PVT.valid_usages ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
248: ibe_util.debug(' return_code: ' || l_return_codes(1));
249: END IF;
250:
251: if x_return_status <> FND_API.g_ret_sts_success then

Line 253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);

249: END IF;
250:
251: if x_return_status <> FND_API.g_ret_sts_success then
252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

Line 256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );

252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
260: RAISE FND_API.G_EXC_ERROR;