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.IBE_ORD_ONECLICK_PVT dependencies on FND_API

Line 5: l_true VARCHAR2(1) := FND_API.G_TRUE;

1: PACKAGE BODY ibe_ord_oneclick_pvt AS
2: /* $Header: IBEVO1CB.pls 120.10 2006/06/20 19:59:39 apilpre ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_ord_oneclick_pvt';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
6:
7: /* Local function to Get Credit Card Type Given The Number
8: hekkiral - 21-DEC-2000 */
9:

Line 29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

25: ------------------------------------------------------------------------------
26: */
27: procedure Get_Settings(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 30: p_commit IN VARCHAR2 := FND_API.g_false,

26: */
27: procedure Get_Settings(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,

Line 31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

27: procedure Get_Settings(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
30: p_commit IN VARCHAR2 := FND_API.g_false,
31: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35:

Line 90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

86: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
87: END IF;
88: SAVEPOINT Get_Settings_Pvt;
89: -- Standard call to check for call compatibility.
90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME )
94: THEN

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME )
94: THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API rturn status to success

Line 104: x_return_status := FND_API.g_ret_sts_success;

100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API rturn status to success
104: x_return_status := FND_API.g_ret_sts_success;
105:
106: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
107: ibe_util.debug('------- INPUT: -----------------');
108: ibe_util.debug('p_party_id :'||p_party_id);

Line 122: if x_return_status <> FND_API.g_ret_sts_success then

118: ,x_return_status => x_return_status
119: ,x_msg_count => x_msg_count
120: ,x_msg_data => x_msg_data);
121:
122: if x_return_status <> FND_API.g_ret_sts_success then
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);
125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then

Line 126: if x_return_status = FND_API.G_RET_STS_ERROR then

122: if x_return_status <> FND_API.g_ret_sts_success then
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);
125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then
127: RAISE FND_API.G_EXC_ERROR;
128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;

Line 127: RAISE FND_API.G_EXC_ERROR;

123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);
125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then
127: RAISE FND_API.G_EXC_ERROR;
128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;
131: end if;

Line 128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);
125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then
127: RAISE FND_API.G_EXC_ERROR;
128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;
131: end if;
132:

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then
127: RAISE FND_API.G_EXC_ERROR;
128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: end if;
131: end if;
132:
133: /*Changes for credit card consolidation. If Cvv2 is mandatory then xpress checkout should be disabled.

Line 135: IF (l_cvv2_setup = FND_API.G_TRUE) THEN

131: end if;
132:
133: /*Changes for credit card consolidation. If Cvv2 is mandatory then xpress checkout should be disabled.
134: User can't enter cvv2 number during express checkout if cvv2 is mandatory.*/
135: IF (l_cvv2_setup = FND_API.G_TRUE) THEN
136: x_ENABLED_FLAG := 'N';
137: ELSE
138:
139: OPEN c_settings(p_party_id, p_acct_id);

Line 151: x_ONECLICK_ID := FND_API.g_miss_num;

147: x_BILL_PTYSITE_ID,
148: x_SHIP_PTYSITE_ID,
149: x_LAST_UPDATE_DATE;
150: if c_settings%NOTFOUND then
151: x_ONECLICK_ID := FND_API.g_miss_num;
152: end if;
153: CLOSE c_settings;
154:
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 191: p_init_msg_list => FND_API.G_FALSE,

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,
194: p_usage_codes => l_usage_codes,
195: x_return_codes => l_return_codes,

Line 205: if x_return_status <> FND_API.g_ret_sts_success 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
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');

Line 213: if x_return_status = FND_API.G_RET_STS_ERROR then

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;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;

Line 214: RAISE FND_API.G_EXC_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;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: end if;

Line 215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: end if;
219:

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
214: RAISE FND_API.G_EXC_ERROR;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: end if;
219:
220: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then

Line 220: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then

216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: end if;
219:
220: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then
221: x_BILL_PTYSITE_ID := null;
222: l_save_flag := 'Y';
223: END IF;
224: end if;

Line 237: p_init_msg_list => FND_API.G_FALSE,

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,
240: p_usage_codes => l_usage_codes,
241: x_return_codes => l_return_codes,

Line 251: if x_return_status <> FND_API.g_ret_sts_success 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
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');

Line 259: if x_return_status = FND_API.G_RET_STS_ERROR then

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;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: end if;

Line 260: RAISE FND_API.G_EXC_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;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: end if;
264: end if;

Line 261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: end if;
264: end if;
265:

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
260: RAISE FND_API.G_EXC_ERROR;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: end if;
264: end if;
265:
266: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then

Line 266: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then

262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: end if;
264: end if;
265:
266: if (l_return_codes(1) <> FND_API.G_RET_STS_SUCCESS) then
267: x_SHIP_PTYSITE_ID := null;
268: l_save_flag := 'Y';
269: END IF;
270: end if;

Line 305: IF FND_API.To_Boolean( p_commit ) THEN

301: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
302: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
303: END IF;
304:
305: IF FND_API.To_Boolean( p_commit ) THEN
306: COMMIT WORK;
307: END IF;
308: FND_MSG_PUB.Count_And_Get
309: ( p_encoded => FND_API.G_FALSE,

Line 309: ( p_encoded => FND_API.G_FALSE,

305: IF FND_API.To_Boolean( p_commit ) THEN
306: COMMIT WORK;
307: END IF;
308: FND_MSG_PUB.Count_And_Get
309: ( p_encoded => FND_API.G_FALSE,
310: p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313: --ibe_util.disable_debug;

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: );
313: --ibe_util.disable_debug;
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
318: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
319: END IF;
320: ROLLBACK TO Get_Settings_Pvt;

Line 321: x_return_status := FND_API.G_RET_STS_ERROR ;

317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
318: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
319: END IF;
320: ROLLBACK TO Get_Settings_Pvt;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get
323: ( p_encoded => FND_API.G_FALSE,
324: p_count => x_msg_count,
325: p_data => x_msg_data

Line 323: ( p_encoded => FND_API.G_FALSE,

319: END IF;
320: ROLLBACK TO Get_Settings_Pvt;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get
323: ( p_encoded => FND_API.G_FALSE,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: --ibe_util.disable_debug;

Line 328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: --ibe_util.disable_debug;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
330: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
331: END IF;
332: ROLLBACK TO Get_Settings_Pvt;

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
330: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
331: END IF;
332: ROLLBACK TO Get_Settings_Pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: ( p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data

Line 335: ( p_encoded => FND_API.G_FALSE,

331: END IF;
332: ROLLBACK TO Get_Settings_Pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: ( p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339: --ibe_util.disable_debug;

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
343: END IF;
344: ROLLBACK TO Get_Settings_Pvt;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,

Line 354: ( p_encoded => FND_API.G_FALSE,

350: l_api_name
351: );
352: END IF;
353: FND_MSG_PUB.Count_And_Get
354: ( p_encoded => FND_API.G_FALSE,
355: p_count => x_msg_count,
356: p_data => x_msg_data
357: );
358: --ibe_util.disable_debug;

Line 372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

368: ------------------------------------------------------------------------------
369: */
370: procedure Save_Settings(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
373: p_commit IN VARCHAR2 := FND_API.g_false,
374: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,

Line 373: p_commit IN VARCHAR2 := FND_API.g_false,

369: */
370: procedure Save_Settings(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
373: p_commit IN VARCHAR2 := FND_API.g_false,
374: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,

Line 374: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

370: procedure Save_Settings(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
373: p_commit IN VARCHAR2 := FND_API.g_false,
374: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
378:

Line 382: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

378:
379: p_party_id IN NUMBER := NULL,
380: p_acct_id IN NUMBER := NULL,
381:
382: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
383: p_ENABLED_FLAG IN VARCHAR2 := 'N',
384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

380: p_acct_id IN NUMBER := NULL,
381:
382: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
383: p_ENABLED_FLAG IN VARCHAR2 := 'N',
384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,
387: p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM
388: ) is

Line 385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,

381:
382: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
383: p_ENABLED_FLAG IN VARCHAR2 := 'N',
384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,
387: p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM
388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Save_Settings';

Line 386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,

382: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
383: p_ENABLED_FLAG IN VARCHAR2 := 'N',
384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,
387: p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM
388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Save_Settings';
390: l_api_version CONSTANT NUMBER := 1.0;

Line 387: p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM

383: p_ENABLED_FLAG IN VARCHAR2 := 'N',
384: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_PAYMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
386: p_BILL_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM,
387: p_SHIP_PTYSITE_ID IN NUMBER := FND_API.G_MISS_NUM
388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Save_Settings';
390: l_api_version CONSTANT NUMBER := 1.0;
391:

Line 392: l_oneclick_id NUMBER := FND_API.g_miss_num;

388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Save_Settings';
390: l_api_version CONSTANT NUMBER := 1.0;
391:
392: l_oneclick_id NUMBER := FND_API.g_miss_num;
393:
394: CURSOR c_oneclick_row(c_party_id NUMBER, c_acct_id NUMBER) IS
395: SELECT ord_oneclick_id
396: from IBE_ORD_ONECLICK

Line 406: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

402: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
403: END IF;
404: SAVEPOINT Save_Settings_Pvt;
405: -- Standard call to check for call compatibility.
406: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
407: p_api_version ,
408: l_api_name ,
409: G_PKG_NAME )
410: THEN

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: p_api_version ,
408: l_api_name ,
409: G_PKG_NAME )
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list ) THEN
415: FND_MSG_PUB.initialize;

Line 414: IF FND_API.to_Boolean( p_init_msg_list ) THEN

410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list ) THEN
415: FND_MSG_PUB.initialize;
416: END IF;
417:
418: -- Initialize API rturn status to success

Line 419: x_return_status := FND_API.g_ret_sts_success;

415: FND_MSG_PUB.initialize;
416: END IF;
417:
418: -- Initialize API rturn status to success
419: x_return_status := FND_API.g_ret_sts_success;
420: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
421: ibe_util.debug('-------------Input Parameters ----------');
422: ibe_util.debug('party_id :'||p_party_id);
423: ibe_util.debug('account_id :'||p_acct_id);

Line 496: RAISE FND_API.G_EXC_ERROR;

492:
493: IF (SQL%NOTFOUND) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_SAVE_ERROR');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: end if;
499: close c_oneclick_row;
500:

Line 504: IF FND_API.To_Boolean( p_commit ) THEN

500:
501: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
502: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
503: END IF;
504: IF FND_API.To_Boolean( p_commit ) THEN
505: COMMIT WORK;
506: END IF;
507:
508: FND_MSG_PUB.Count_And_Get

Line 509: ( p_encoded => FND_API.G_FALSE,

505: COMMIT WORK;
506: END IF;
507:
508: FND_MSG_PUB.Count_And_Get
509: ( p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513: --ibe_util.disable_debug;

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: p_data => x_msg_data
512: );
513: --ibe_util.disable_debug;
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
517: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
518: END IF;
519: ROLLBACK TO Save_Settings_Pvt;

Line 520: x_return_status := FND_API.G_RET_STS_ERROR ;

516: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
517: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
518: END IF;
519: ROLLBACK TO Save_Settings_Pvt;
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data

Line 522: ( p_encoded => FND_API.G_FALSE,

518: END IF;
519: ROLLBACK TO Save_Settings_Pvt;
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526: --ibe_util.disable_debug;

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526: --ibe_util.disable_debug;
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
529: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
530: END IF;
531: ROLLBACK TO Save_Settings_Pvt;

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
529: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
530: END IF;
531: ROLLBACK TO Save_Settings_Pvt;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: FND_MSG_PUB.Count_And_Get
534: ( p_encoded => FND_API.G_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data

Line 534: ( p_encoded => FND_API.G_FALSE,

530: END IF;
531: ROLLBACK TO Save_Settings_Pvt;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: FND_MSG_PUB.Count_And_Get
534: ( p_encoded => FND_API.G_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data
537: );
538: --ibe_util.disable_debug;

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
541: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
542: END IF;
543: ROLLBACK TO Save_Settings_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg
548: ( G_PKG_NAME,

Line 553: ( p_encoded => FND_API.G_FALSE,

549: l_api_name
550: );
551: END IF;
552: FND_MSG_PUB.Count_And_Get
553: ( p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data
556: );
557: --ibe_util.disable_debug;

Line 574: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

570: */
571:
572: procedure Express_Buy_Order(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
575: p_commit IN VARCHAR2 := FND_API.g_false,
576: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,

Line 575: p_commit IN VARCHAR2 := FND_API.g_false,

571:
572: procedure Express_Buy_Order(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
575: p_commit IN VARCHAR2 := FND_API.g_false,
576: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2,

Line 576: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

572: procedure Express_Buy_Order(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
575: p_commit IN VARCHAR2 := FND_API.g_false,
576: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2,
580:

Line 584: p_retrieval_num IN NUMBER := FND_API.g_miss_num, -- optional, only if recipient is expressing a cart

580:
581: -- identification
582: p_party_id IN NUMBER,
583: p_acct_id IN NUMBER,
584: p_retrieval_num IN NUMBER := FND_API.g_miss_num, -- optional, only if recipient is expressing a cart
585:
586: -- common pricing parameters
587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,

Line 587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,

583: p_acct_id IN NUMBER,
584: p_retrieval_num IN NUMBER := FND_API.g_miss_num, -- optional, only if recipient is expressing a cart
585:
586: -- common pricing parameters
587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,
589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,

Line 588: p_price_list_id IN NUMBER := FND_API.g_miss_num,

584: p_retrieval_num IN NUMBER := FND_API.g_miss_num, -- optional, only if recipient is expressing a cart
585:
586: -- common pricing parameters
587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,
589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
592:

Line 589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,

585:
586: -- common pricing parameters
587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,
589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
592:
593: -- flag to drive behavior

Line 590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,

586: -- common pricing parameters
587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,
589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
592:
593: -- flag to drive behavior
594: -- (values: 'ITEMS', 'CART', 'LISTS', 'LIST_LINES')

Line 591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,

587: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
588: p_price_list_id IN NUMBER := FND_API.g_miss_num,
589: p_price_req_type IN VARCHAR2 := FND_API.g_miss_char,
590: p_incart_event IN VARCHAR2 := FND_API.g_miss_char,
591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
592:
593: -- flag to drive behavior
594: -- (values: 'ITEMS', 'CART', 'LISTS', 'LIST_LINES')
595: p_flag IN VARCHAR2 := FND_API.g_miss_char,

Line 595: p_flag IN VARCHAR2 := FND_API.g_miss_char,

591: p_incart_line_event IN VARCHAR2 := FND_API.g_miss_char,
592:
593: -- flag to drive behavior
594: -- (values: 'ITEMS', 'CART', 'LISTS', 'LIST_LINES')
595: p_flag IN VARCHAR2 := FND_API.g_miss_char,
596:
597: -- for express checkout of a shopping cart
598: p_cart_id IN NUMBER := FND_API.g_miss_num,
599: p_minisite_id IN NUMBER := FND_API.g_miss_num, -- for stop sharing notification

Line 598: p_cart_id IN NUMBER := FND_API.g_miss_num,

594: -- (values: 'ITEMS', 'CART', 'LISTS', 'LIST_LINES')
595: p_flag IN VARCHAR2 := FND_API.g_miss_char,
596:
597: -- for express checkout of a shopping cart
598: p_cart_id IN NUMBER := FND_API.g_miss_num,
599: p_minisite_id IN NUMBER := FND_API.g_miss_num, -- for stop sharing notification
600:
601: -- for express checkout of a list of shopping lists
602: p_list_ids IN JTF_NUMBER_TABLE,

Line 599: p_minisite_id IN NUMBER := FND_API.g_miss_num, -- for stop sharing notification

595: p_flag IN VARCHAR2 := FND_API.g_miss_char,
596:
597: -- for express checkout of a shopping cart
598: p_cart_id IN NUMBER := FND_API.g_miss_num,
599: p_minisite_id IN NUMBER := FND_API.g_miss_num, -- for stop sharing notification
600:
601: -- for express checkout of a list of shopping lists
602: p_list_ids IN JTF_NUMBER_TABLE,
603: p_list_ovns IN JTF_NUMBER_TABLE,

Line 619: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

615: -- return the quote header id
616: x_new_cart_id OUT NOCOPY NUMBER,
617:
618: -- TimeStamp check
619: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
620: x_last_update_date OUT NOCOPY DATE
621:
622: ) is
623: l_api_name CONSTANT VARCHAR2(30) := 'Express_Buy_Order';

Line 627: l_curr_cart_id NUMBER := FND_API.g_miss_num;

623: l_api_name CONSTANT VARCHAR2(30) := 'Express_Buy_Order';
624: l_api_version CONSTANT NUMBER := 1.0;
625:
626: -- local variables for finding an active express cart
627: l_curr_cart_id NUMBER := FND_API.g_miss_num;
628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;
629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;

Line 628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;

624: l_api_version CONSTANT NUMBER := 1.0;
625:
626: -- local variables for finding an active express cart
627: l_curr_cart_id NUMBER := FND_API.g_miss_num;
628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;
629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;

Line 629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;

625:
626: -- local variables for finding an active express cart
627: l_curr_cart_id NUMBER := FND_API.g_miss_num;
628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;
629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;

Line 631: l_retrieval_num NUMBER := FND_API.g_miss_num;

627: l_curr_cart_id NUMBER := FND_API.g_miss_num;
628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;
629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;
634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;

Line 632: l_sharee_party_id NUMBER := FND_API.g_miss_num;

628: l_curr_cart_date DATE := FND_API.G_MISS_DATE;
629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;
634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;

Line 633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;

629: l_curr_cart_currcode VARCHAR2(15) := FND_API.G_MISS_CHAR;
630:
631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;
634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';

Line 635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;

631: l_retrieval_num NUMBER := FND_API.g_miss_num;
632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;
634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;

Line 636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;

632: l_sharee_party_id NUMBER := FND_API.g_miss_num;
633: l_sharee_acct_id NUMBER := FND_API.g_miss_num;
634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;

Line 638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;

634:
635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
642: l_settings_date DATE := FND_API.G_MISS_DATE;

Line 639: l_payment_id NUMBER := FND_API.G_MISS_NUM;

635: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
642: l_settings_date DATE := FND_API.G_MISS_DATE;
643:

Line 640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;

636: l_ord_oneclick_id NUMBER := FND_API.G_MISS_NUM;
637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
642: l_settings_date DATE := FND_API.G_MISS_DATE;
643:
644: -- local variables and cursors for updating a quote

Line 641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;

637: l_enabled_flag VARCHAR2(1) := 'N';
638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
642: l_settings_date DATE := FND_API.G_MISS_DATE;
643:
644: -- local variables and cursors for updating a quote
645: l_save_trigger VARCHAR2(1) := 'Y';

Line 642: l_settings_date DATE := FND_API.G_MISS_DATE;

638: l_freight_code VARCHAR2(25) := FND_API.G_MISS_CHAR;
639: l_payment_id NUMBER := FND_API.G_MISS_NUM;
640: l_bill_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
641: l_ship_to_pty_site_id NUMBER := FND_API.G_MISS_NUM;
642: l_settings_date DATE := FND_API.G_MISS_DATE;
643:
644: -- local variables and cursors for updating a quote
645: l_save_trigger VARCHAR2(1) := 'Y';
646: l_credit_card_num NUMBER;

Line 666: l_optional_party_id NUMBER := FND_API.g_miss_num;

662: lx_quote_header_id NUMBER;
663: lx_last_update_date DATE;
664:
665: l_party_type VARCHAR2(30);
666: l_optional_party_id NUMBER := FND_API.g_miss_num;
667: l_count_tax NUMBER := 0;
668: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
669: l_count NUMBER := 0;
670:

Line 668: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;

664:
665: l_party_type VARCHAR2(30);
666: l_optional_party_id NUMBER := FND_API.g_miss_num;
667: l_count_tax NUMBER := 0;
668: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
669: l_count NUMBER := 0;
670:
671: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
672: SELECT quote_header_id, creation_date, currency_code

Line 695: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

691: ibe_util.debug('PROCESSING FLAG : ' || p_flag);
692: END IF;
693: SAVEPOINT Express_Buy_Order_Pvt;
694: -- Standard call to check for call compatibility.
695: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
696: p_api_version ,
697: l_api_name ,
698: G_PKG_NAME )
699: THEN

Line 700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

696: p_api_version ,
697: l_api_name ,
698: G_PKG_NAME )
699: THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list ) THEN
704: FND_MSG_PUB.initialize;

Line 703: IF FND_API.to_Boolean( p_init_msg_list ) THEN

699: THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list ) THEN
704: FND_MSG_PUB.initialize;
705: END IF;
706:
707: -- Initialize API rturn status to success

Line 708: x_return_status := FND_API.g_ret_sts_success;

704: FND_MSG_PUB.initialize;
705: END IF;
706:
707: -- Initialize API rturn status to success
708: x_return_status := FND_API.g_ret_sts_success;
709:
710:
711: l_qte_header_rec.quote_header_id := p_cart_id;
712: l_qte_header_rec.party_id := p_party_id;

Line 721: if ((p_retrieval_num is not null) and (p_retrieval_num <> FND_API.g_miss_num)) then

717:
718: IF(p_flag = 'CART') THEN
719: l_save_trigger := 'Y';
720:
721: if ((p_retrieval_num is not null) and (p_retrieval_num <> FND_API.g_miss_num)) then
722:
723: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
724: ibe_util.debug('Express_Buy_Order: Validate_user_update START');
725: ibe_util.debug('Express_Buy_Order: p_party_id: '||p_party_id);

Line 736: ,p_validate_user => FND_API.G_TRUE

732: ,p_quote_header_id => p_cart_id
733: ,p_party_id => p_party_id
734: ,p_cust_account_id => p_acct_id
735: ,p_quote_retrieval_number => p_retrieval_num
736: ,p_validate_user => FND_API.G_TRUE
737: ,p_privilege_type_code => 'A'
738: ,p_last_update_date => p_last_update_date
739: ,x_return_status => x_return_status
740: ,x_msg_count => x_msg_count

Line 743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

739: ,x_return_status => x_return_status
740: ,x_msg_count => x_msg_count
741: ,x_msg_data => x_msg_data );
742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 744: RAISE FND_API.G_EXC_ERROR;

740: ,x_msg_count => x_msg_count
741: ,x_msg_data => x_msg_data );
742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;

Line 746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

742:
743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750: end if;

Line 747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750: end if;
751:

Line 817: IF (l_curr_cart_id <> FND_API.g_miss_num) then

813: END IF;
814: end if;
815: end if; --end if adding itmes
816:
817: IF (l_curr_cart_id <> FND_API.g_miss_num) then
818: l_qte_header_rec.quote_header_id := l_curr_cart_id;
819: /*OPEN c_quote_date(l_qte_header_rec.quote_header_id);
820: FETCH c_quote_date INTO l_qte_header_rec.last_update_date;
821: CLOSE c_quote_date;*/

Line 829: l_attach_contract :=FND_API.G_TRUE;

825: IF(p_flag = 'CART') THEN
826: --Contract needs to be attached to the xpressed checkout cart.
827: --There is no consolidation for carts, hence a contract has to be
828: --attached every time a cart is xpressed checked out
829: l_attach_contract :=FND_API.G_TRUE;
830: END IF;
831:
832: ELSE
833: -- clear these just in case the previous code used these recs

Line 834: l_qte_header_rec.quote_header_id := FND_API.G_MISS_NUM;

830: END IF;
831:
832: ELSE
833: -- clear these just in case the previous code used these recs
834: l_qte_header_rec.quote_header_id := FND_API.G_MISS_NUM;
835: l_qte_header_rec.quote_name := '';
836: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;
837: l_control_rec.last_update_date := FND_API.G_MISS_DATE;
838: l_attach_contract := FND_API.G_TRUE;

Line 836: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;

832: ELSE
833: -- clear these just in case the previous code used these recs
834: l_qte_header_rec.quote_header_id := FND_API.G_MISS_NUM;
835: l_qte_header_rec.quote_name := '';
836: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;
837: l_control_rec.last_update_date := FND_API.G_MISS_DATE;
838: l_attach_contract := FND_API.G_TRUE;
839: END IF;
840:

Line 837: l_control_rec.last_update_date := FND_API.G_MISS_DATE;

833: -- clear these just in case the previous code used these recs
834: l_qte_header_rec.quote_header_id := FND_API.G_MISS_NUM;
835: l_qte_header_rec.quote_name := '';
836: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;
837: l_control_rec.last_update_date := FND_API.G_MISS_DATE;
838: l_attach_contract := FND_API.G_TRUE;
839: END IF;
840:
841: -- regardless we will need to reprice - whether a new express quote or adding items or adding from lists

Line 838: l_attach_contract := FND_API.G_TRUE;

834: l_qte_header_rec.quote_header_id := FND_API.G_MISS_NUM;
835: l_qte_header_rec.quote_name := '';
836: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;
837: l_control_rec.last_update_date := FND_API.G_MISS_DATE;
838: l_attach_contract := FND_API.G_TRUE;
839: END IF;
840:
841: -- regardless we will need to reprice - whether a new express quote or adding items or adding from lists
842: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 870: IF (p_retrieval_num <> FND_API.g_miss_num) then

866: ibe_util.debug(' l_qte_header_rec.quote_name : ' || l_qte_header_rec.quote_name);
867: ibe_util.debug(' l_qte_header_rec.last_update_date : ' || to_char(l_qte_header_rec.last_update_date,'DD-MON-YYYY:HH24:MI:SS'));
868: END IF;
869:
870: IF (p_retrieval_num <> FND_API.g_miss_num) then
871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
872: ibe_util.debug('passing sharee party and acct id');
873: END IF;
874: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;

Line 874: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;

870: IF (p_retrieval_num <> FND_API.g_miss_num) then
871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
872: ibe_util.debug('passing sharee party and acct id');
873: END IF;
874: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;
875: l_qte_header_rec.cust_account_id := FND_API.G_MISS_NUM;
876: l_sharee_party_id := p_party_id;
877: l_sharee_acct_id := p_acct_id;
878: END IF;

Line 875: l_qte_header_rec.cust_account_id := FND_API.G_MISS_NUM;

871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
872: ibe_util.debug('passing sharee party and acct id');
873: END IF;
874: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;
875: l_qte_header_rec.cust_account_id := FND_API.G_MISS_NUM;
876: l_sharee_party_id := p_party_id;
877: l_sharee_acct_id := p_acct_id;
878: END IF;
879:

Line 882: p_init_msg_list => FND_API.G_FALSE,

878: END IF;
879:
880: IBE_Quote_Save_pvt.SAVE(
881: p_api_version_number => p_api_version,
882: p_init_msg_list => FND_API.G_FALSE,
883: p_commit => FND_API.g_false,
884: p_auto_update_active_quote => FND_API.g_false,
885: -- p_combineSameItem => 'Y', -- let api default from profile
886: p_sharee_Number => p_retrieval_num,

Line 883: p_commit => FND_API.g_false,

879:
880: IBE_Quote_Save_pvt.SAVE(
881: p_api_version_number => p_api_version,
882: p_init_msg_list => FND_API.G_FALSE,
883: p_commit => FND_API.g_false,
884: p_auto_update_active_quote => FND_API.g_false,
885: -- p_combineSameItem => 'Y', -- let api default from profile
886: p_sharee_Number => p_retrieval_num,
887: p_sharee_party_id => l_sharee_party_id,

Line 884: p_auto_update_active_quote => FND_API.g_false,

880: IBE_Quote_Save_pvt.SAVE(
881: p_api_version_number => p_api_version,
882: p_init_msg_list => FND_API.G_FALSE,
883: p_commit => FND_API.g_false,
884: p_auto_update_active_quote => FND_API.g_false,
885: -- p_combineSameItem => 'Y', -- let api default from profile
886: p_sharee_Number => p_retrieval_num,
887: p_sharee_party_id => l_sharee_party_id,
888: p_sharee_cust_account_id => l_sharee_acct_id,

Line 906: IF x_return_status <> FND_API.g_ret_sts_success THEN

902:
903: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
904: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') || ' quote_header_id: ' || to_char(lx_quote_header_id));
905: END IF;
906: IF x_return_status <> FND_API.g_ret_sts_success THEN
907: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );

Line 913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;

Line 914: RAISE FND_API.G_EXC_ERROR;

910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: ELSE

Line 915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: ELSE
919: IF(l_attach_contract = FND_API.G_TRUE) THEN

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: ELSE
919: IF(l_attach_contract = FND_API.G_TRUE) THEN
920: IF (OKC_TERMS_UTIL_GRP.Get_Terms_Template('QUOTE', p_cart_id) IS NULL) THEN -- Checking whether a contract has already been attached (Bug 5260372)

Line 919: IF(l_attach_contract = FND_API.G_TRUE) THEN

915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: ELSE
919: IF(l_attach_contract = FND_API.G_TRUE) THEN
920: IF (OKC_TERMS_UTIL_GRP.Get_Terms_Template('QUOTE', p_cart_id) IS NULL) THEN -- Checking whether a contract has already been attached (Bug 5260372)
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : No contract currently attached !');
923: END IF;

Line 950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

946:
947: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
948: IBE_UTIL.debug('After copy_terms api, return status = '||x_return_status);
949: END IF;
950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 951: RAISE FND_API.G_EXC_ERROR;

947: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
948: IBE_UTIL.debug('After copy_terms api, return status = '||x_return_status);
949: END IF;
950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;

Line 953: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

949: END IF;
950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956: END IF; --If contract template id is not null
957: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')

Line 954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956: END IF; --If contract template id is not null
957: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')
958: ELSE

Line 974: p_init_msg_list => fnd_api.g_false ,

970: p_quote_header_id => p_cart_id ,
971: p_delete_context => 'IBE_SC_CART_ORDERED',
972: P_minisite_id => p_minisite_id ,
973: p_api_version => p_api_version ,
974: p_init_msg_list => fnd_api.g_false ,
975: p_commit => fnd_api.g_false ,
976: x_return_status => x_return_status ,
977: x_msg_count => x_msg_count ,
978: x_msg_data => x_msg_data );

Line 975: p_commit => fnd_api.g_false ,

971: p_delete_context => 'IBE_SC_CART_ORDERED',
972: P_minisite_id => p_minisite_id ,
973: p_api_version => p_api_version ,
974: p_init_msg_list => fnd_api.g_false ,
975: p_commit => fnd_api.g_false ,
976: x_return_status => x_return_status ,
977: x_msg_count => x_msg_count ,
978: x_msg_data => x_msg_data );
979:

Line 981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

977: x_msg_count => x_msg_count ,
978: x_msg_data => x_msg_data );
979:
980:
981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:
985: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 982: RAISE FND_API.G_EXC_ERROR;

978: x_msg_data => x_msg_data );
979:
980:
981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:
985: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 985: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:
985: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
989: ibe_util.debug('Express_buy_order: Done Calling stop_sharing');

Line 986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:
985: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
989: ibe_util.debug('Express_buy_order: Done Calling stop_sharing');
990: END IF;

Line 1015: ,P_Init_Msg_List => FND_API.G_FALSE

1011: END LOOP;
1012:
1013: IBE_Shop_List_PVT.Save_Quote_From_Lists(
1014: P_Api_Version => 1.0
1015: ,P_Init_Msg_List => FND_API.G_FALSE
1016: ,P_Commit => FND_API.G_FALSE
1017: ,p_mode => 'MERGE'
1018: --,p_combine_same_item => null -- let default from profile
1019: ,p_sl_header_ids => p_list_ids

Line 1016: ,P_Commit => FND_API.G_FALSE

1012:
1013: IBE_Shop_List_PVT.Save_Quote_From_Lists(
1014: P_Api_Version => 1.0
1015: ,P_Init_Msg_List => FND_API.G_FALSE
1016: ,P_Commit => FND_API.G_FALSE
1017: ,p_mode => 'MERGE'
1018: --,p_combine_same_item => null -- let default from profile
1019: ,p_sl_header_ids => p_list_ids
1020: ,p_sl_header_ovns => p_list_ovns

Line 1036: IF x_return_status <> FND_API.g_ret_sts_success THEN

1032: ibe_util.debug('Back from IBE_Shop_List_PVT.Save_Quote_From_Lists ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1033: ibe_util.debug('X_cartId ' || lx_quote_header_id);
1034: END IF;
1035:
1036: IF x_return_status <> FND_API.g_ret_sts_success THEN
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );

Line 1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END IF;

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END IF;
1048: END IF;

Line 1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END IF;
1048: END IF;
1049:

Line 1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END IF;
1048: END IF;
1049:
1050: END IF;

Line 1065: ,P_Init_Msg_List => FND_API.G_FALSE

1061: END IF;
1062: end loop;
1063: IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1064: P_Api_Version => 1.0
1065: ,P_Init_Msg_List => FND_API.G_FALSE
1066: ,P_Commit => FND_API.G_FALSE
1067: ,p_mode => 'MERGE'
1068: -- ,p_combine_same_item => null -- let default from profile
1069: ,p_sl_line_ids => p_list_line_ids

Line 1066: ,P_Commit => FND_API.G_FALSE

1062: end loop;
1063: IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1064: P_Api_Version => 1.0
1065: ,P_Init_Msg_List => FND_API.G_FALSE
1066: ,P_Commit => FND_API.G_FALSE
1067: ,p_mode => 'MERGE'
1068: -- ,p_combine_same_item => null -- let default from profile
1069: ,p_sl_line_ids => p_list_line_ids
1070: ,p_sl_line_ovns => p_list_line_ovns

Line 1086: if x_return_status <> FND_API.g_ret_sts_success then

1082: ibe_util.debug('Back from IBE_Shop_List_PVT.Save_Quote_From_List_Items ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1083: ibe_util.debug('X_cartId ' || lx_quote_header_id);
1084: END IF;
1085:
1086: if x_return_status <> FND_API.g_ret_sts_success then
1087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

Line 1094: if x_return_status = FND_API.G_RET_STS_ERROR then

1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: end if;

Line 1095: RAISE FND_API.G_EXC_ERROR;

1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: end if;
1099: end if;

Line 1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: end if;
1099: end if;
1100: end if;

Line 1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: end if;
1099: end if;
1100: end if;
1101:

Line 1108: IF FND_API.To_Boolean( p_commit ) THEN

1104: END IF;
1105: -- let the caller know which quote we finally updated
1106: x_new_cart_id := l_curr_cart_id;
1107:
1108: IF FND_API.To_Boolean( p_commit ) THEN
1109: COMMIT WORK;
1110: END IF;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_encoded => FND_API.G_FALSE,

Line 1112: ( p_encoded => FND_API.G_FALSE,

1108: IF FND_API.To_Boolean( p_commit ) THEN
1109: COMMIT WORK;
1110: END IF;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count ,
1114: p_data => x_msg_data );
1115:
1116: --ibe_util.disable_debug;

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: p_data => x_msg_data );
1115:
1116: --ibe_util.disable_debug;
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1120: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1121: END IF;
1122: ROLLBACK TO Express_Buy_Order_Pvt;

Line 1123: x_return_status := FND_API.G_RET_STS_ERROR;

1119: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1120: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1121: END IF;
1122: ROLLBACK TO Express_Buy_Order_Pvt;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,

Line 1126: ( p_encoded => FND_API.G_FALSE,

1122: ROLLBACK TO Express_Buy_Order_Pvt;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );
1130: --ibe_util.disable_debug;

Line 1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );
1130: --ibe_util.disable_debug;
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1133: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1134: END IF;
1135: ROLLBACK TO Express_Buy_Order_Pvt;

Line 1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1132: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1133: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1134: END IF;
1135: ROLLBACK TO Express_Buy_Order_Pvt;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data

Line 1138: ( p_encoded => FND_API.G_FALSE,

1134: END IF;
1135: ROLLBACK TO Express_Buy_Order_Pvt;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );
1142: --ibe_util.disable_debug;

Line 1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1144: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1145: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1146: END IF;
1147: ROLLBACK TO Express_Buy_Order_Pvt;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1150: THEN
1151: FND_MSG_PUB.Add_Exc_Msg
1152: ( G_PKG_NAME,

Line 1157: ( p_encoded => FND_API.G_FALSE,

1153: l_api_name
1154: );
1155: END IF;
1156: FND_MSG_PUB.Count_And_Get
1157: ( p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );
1161: --ibe_util.disable_debug;

Line 1247: l_curr_cart_id NUMBER := FND_API.g_miss_num;

1243: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1244: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1245: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1246:
1247: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1248: l_curr_cart_date DATE;
1249: l_curr_cart_currcode VARCHAR2(10);
1250: l_object_version_number NUMBER;
1251: l_ord_oneclick_id NUMBER;

Line 1262: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;

1258: l_save_trigger VARCHAR2(3);
1259: l_party_type VARCHAR2(300);
1260: l_optional_party_id NUMBER;
1261: l_count_tax NUMBER := 0;
1262: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
1263: l_count NUMBER := 0;
1264: l_retrieval_num NUMBER := FND_API.g_miss_num;
1265: l_credit_card_num NUMBER;
1266: l_credit_card_name VARCHAR2(80);

Line 1264: l_retrieval_num NUMBER := FND_API.g_miss_num;

1260: l_optional_party_id NUMBER;
1261: l_count_tax NUMBER := 0;
1262: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
1263: l_count NUMBER := 0;
1264: l_retrieval_num NUMBER := FND_API.g_miss_num;
1265: l_credit_card_num NUMBER;
1266: l_credit_card_name VARCHAR2(80);
1267: l_credit_card_exp DATE;
1268: l_credit_card_holder_name VARCHAR2(50);

Line 1321: l_curr_cart_id := FND_API.g_miss_num;

1317: OPEN c_quote(x_qte_header_rec.party_id,
1318: x_qte_header_rec.cust_account_id);
1319: FETCH c_quote INTO l_curr_cart_id, l_curr_cart_date, l_curr_cart_currcode;
1320: if c_quote%NOTFOUND then
1321: l_curr_cart_id := FND_API.g_miss_num;
1322: else
1323: null;
1324: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1325: ibe_util.debug('get_express_items_settings got l_curr_cart_id ' || to_char(l_curr_cart_id));

Line 1336: if (l_curr_cart_id <> FND_API.g_miss_num) then

1332:
1333: l_control_rec.AUTO_VERSION_FLAG := 'N';
1334:
1335: -- see if we can consolidate
1336: if (l_curr_cart_id <> FND_API.g_miss_num) then
1337:
1338: -- if no then move out the old cart id and set curr_cart_id to null to trigger creating a new one
1339: if ((l_curr_cart_date < l_settings_date) or (l_curr_cart_currcode <> x_qte_header_rec.currency_code)) then
1340: -- this means that the settings (which now include currency) have changed since we first

Line 1358: p_init_msg_list => FND_API.G_FALSE,

1354: ibe_util.debug(' l_qte_header_rec.last_update_date : ' || to_char(l_qte_header_rec.last_update_date,'DD-MON-YYYY:HH24:MI:SS'));
1355: END IF;
1356: IBE_Quote_Save_pvt.SAVE(
1357: p_api_version_number => 1.0,
1358: p_init_msg_list => FND_API.G_FALSE,
1359: p_commit => FND_API.g_false,
1360: p_auto_update_active_quote => FND_API.g_false,
1361: --p_combineSameItem => 'Y', -- let api default from profile
1362: p_control_rec => l_control_rec,

Line 1359: p_commit => FND_API.g_false,

1355: END IF;
1356: IBE_Quote_Save_pvt.SAVE(
1357: p_api_version_number => 1.0,
1358: p_init_msg_list => FND_API.G_FALSE,
1359: p_commit => FND_API.g_false,
1360: p_auto_update_active_quote => FND_API.g_false,
1361: --p_combineSameItem => 'Y', -- let api default from profile
1362: p_control_rec => l_control_rec,
1363: p_qte_header_rec => l_push_qte_header_rec,

Line 1360: p_auto_update_active_quote => FND_API.g_false,

1356: IBE_Quote_Save_pvt.SAVE(
1357: p_api_version_number => 1.0,
1358: p_init_msg_list => FND_API.G_FALSE,
1359: p_commit => FND_API.g_false,
1360: p_auto_update_active_quote => FND_API.g_false,
1361: --p_combineSameItem => 'Y', -- let api default from profile
1362: p_control_rec => l_control_rec,
1363: p_qte_header_rec => l_push_qte_header_rec,
1364: p_save_type => UPDATE_EXPRESSORDER,

Line 1374: if lx_return_status <> FND_API.g_ret_sts_success then

1370: --ibe_util.enable_debug;
1371: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1372: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE for pushing out' );
1373: END IF;
1374: if lx_return_status <> FND_API.g_ret_sts_success then
1375: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

Line 1382: if lx_return_status = FND_API.G_RET_STS_ERROR then

1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: end if;

Line 1383: RAISE FND_API.G_EXC_ERROR;

1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: end if;
1387: end if;

Line 1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: end if;
1387: end if;
1388: -- set these to g_miss so rest of api can know we have to start with a new quote

Line 1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: end if;
1387: end if;
1388: -- set these to g_miss so rest of api can know we have to start with a new quote
1389: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;

Line 1389: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;

1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: end if;
1387: end if;
1388: -- set these to g_miss so rest of api can know we have to start with a new quote
1389: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;
1390: l_curr_cart_id := FND_API.g_miss_num;
1391: l_curr_cart_date := FND_API.g_miss_date;
1392: else
1393: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart

Line 1390: l_curr_cart_id := FND_API.g_miss_num;

1386: end if;
1387: end if;
1388: -- set these to g_miss so rest of api can know we have to start with a new quote
1389: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;
1390: l_curr_cart_id := FND_API.g_miss_num;
1391: l_curr_cart_date := FND_API.g_miss_date;
1392: else
1393: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart
1394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1391: l_curr_cart_date := FND_API.g_miss_date;

1387: end if;
1388: -- set these to g_miss so rest of api can know we have to start with a new quote
1389: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;
1390: l_curr_cart_id := FND_API.g_miss_num;
1391: l_curr_cart_date := FND_API.g_miss_date;
1392: else
1393: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart
1394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1395: ibe_util.debug('ibe_ord_oneclick_pvt.Get_express_items_settings-Consolidating to: '||l_curr_cart_id);

Line 1405: if ((p_flag = 'CART') or ((p_flag <> 'CART') and (l_curr_cart_id = FND_API.g_miss_num))) then

1401: /*At this point, l_curr_cart_id is either set to be the one we should use
1402: or g_miss_num to trigger creation of a new quote*/
1403:
1404: -- see if we need to apply the Express Checkout Settings (billing, shipping, payment info)
1405: if ((p_flag = 'CART') or ((p_flag <> 'CART') and (l_curr_cart_id = FND_API.g_miss_num))) then
1406:
1407: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1408: ibe_util.debug('Express_Buy_Order got l_settings_date ' || to_char(l_settings_date,'DD-MON-YYYY:HH:MI:SS'));
1409: END IF;

Line 1555: END IF; --IF ((p_flag = 'CART') or ((p_flag <> 'CART') and (l_curr_cart_id = FND_API.g_miss_num)))

1551: ibe_util.debug('l_shipment_rec.ship_to_party_site_id ' || l_shipment_rec.ship_to_party_site_id);
1552: ibe_util.debug('l_shipment_rec.ship_to_party_id ' || l_shipment_rec.ship_to_party_id);
1553: END IF;
1554:
1555: END IF; --IF ((p_flag = 'CART') or ((p_flag <> 'CART') and (l_curr_cart_id = FND_API.g_miss_num)))
1556:
1557: x_qte_header_rec := l_qte_header_rec;
1558:
1559: END;

Line 1612: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1608: ------------------------------------------------------------------------------
1609: */
1610: Procedure Update_Settings(
1611: p_api_version IN NUMBER,
1612: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1613: p_commit IN VARCHAR2 := FND_API.g_false,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,

Line 1613: p_commit IN VARCHAR2 := FND_API.g_false,

1609: */
1610: Procedure Update_Settings(
1611: p_api_version IN NUMBER,
1612: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1613: p_commit IN VARCHAR2 := FND_API.g_false,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,
1617: p_party_id IN NUMBER := NULL,

Line 1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;

1620: IS
1621:
1622: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1623: l_api_version CONSTANT NUMBER := 1.0;
1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;

Line 1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;

1621:
1622: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1623: l_api_version CONSTANT NUMBER := 1.0;
1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1629: l_enabled_flag VARCHAR2(1) := 'N';

Line 1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;

1622: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1623: l_api_version CONSTANT NUMBER := 1.0;
1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1629: l_enabled_flag VARCHAR2(1) := 'N';
1630: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;

1623: l_api_version CONSTANT NUMBER := 1.0;
1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1629: l_enabled_flag VARCHAR2(1) := 'N';
1630: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1631:

Line 1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;

1624: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1625: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1629: l_enabled_flag VARCHAR2(1) := 'N';
1630: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1631:
1632: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,

Line 1630: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;

1626: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1627: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1628: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1629: l_enabled_flag VARCHAR2(1) := 'N';
1630: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1631:
1632: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,
1633: c_acct_id IN NUMBER)
1634: IS

Line 1664: l_oneclick_id := FND_API.g_miss_num;

1660: l_bill_ptysite_id,
1661: l_ship_ptysite_id;
1662:
1663: IF c_get_oneclick_settings%NOTFOUND THEN
1664: l_oneclick_id := FND_API.g_miss_num;
1665: END IF;
1666: CLOSE c_get_oneclick_settings;
1667:
1668: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1680: IF p_assignment_id is not NULL and l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' and l_payment_id = p_assignment_id THEN

1676: ibe_util.debug('l_ship_ptysite_id :'||l_ship_ptysite_id);
1677: ibe_util.debug('Checking p_assignment_id not null :'||p_assignment_id);
1678: END IF;
1679:
1680: IF p_assignment_id is not NULL and l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' and l_payment_id = p_assignment_id THEN
1681: l_enabled_flag := 'N';
1682: l_payment_id := '';
1683:
1684: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1691: p_init_msg_list => FND_API.G_FALSE,

1687: END IF;
1688:
1689: ibe_ord_oneclick_pvt.save_settings(
1690: p_api_version => l_api_version,
1691: p_init_msg_list => FND_API.G_FALSE,
1692: p_commit => p_commit,
1693: x_return_status => x_return_status,
1694: x_msg_count => x_msg_count,
1695: x_msg_data => x_msg_data,

Line 1711: IF x_return_status <> FND_API.g_ret_sts_success THEN

1707: ibe_util.debug('Update_Settings : After Calling ibe_ord_oneclick_pvt.save_settings');
1708: ibe_util.debug('Update_Settings : x_return_status - '||x_return_status);
1709: END IF;
1710:
1711: IF x_return_status <> FND_API.g_ret_sts_success THEN
1712: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1711: IF x_return_status <> FND_API.g_ret_sts_success THEN
1712: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720: END IF;

Line 1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720: END IF;
1721:

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720: END IF;
1721:
1722: IF FND_API.To_Boolean( p_commit ) THEN

Line 1722: IF FND_API.To_Boolean( p_commit ) THEN

1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720: END IF;
1721:
1722: IF FND_API.To_Boolean( p_commit ) THEN
1723: COMMIT WORK;
1724: END IF;
1725:
1726: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1739: ( p_encoded => FND_API.G_FALSE,

1735:
1736: END IF;
1737:
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );
1743:

Line 1745: WHEN FND_API.G_EXC_ERROR THEN

1741: p_data => x_msg_data
1742: );
1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1747: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1748: END IF;
1749: ROLLBACK TO Update_Settings;

Line 1750: x_return_status := FND_API.G_RET_STS_ERROR ;

1746: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1747: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1748: END IF;
1749: ROLLBACK TO Update_Settings;
1750: x_return_status := FND_API.G_RET_STS_ERROR ;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_encoded => FND_API.G_FALSE,
1753: p_count => x_msg_count,
1754: p_data => x_msg_data

Line 1752: ( p_encoded => FND_API.G_FALSE,

1748: END IF;
1749: ROLLBACK TO Update_Settings;
1750: x_return_status := FND_API.G_RET_STS_ERROR ;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_encoded => FND_API.G_FALSE,
1753: p_count => x_msg_count,
1754: p_data => x_msg_data
1755: );
1756:

Line 1757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1753: p_count => x_msg_count,
1754: p_data => x_msg_data
1755: );
1756:
1757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1759: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1760: END IF;
1761: ROLLBACK TO Update_Settings;

Line 1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1759: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1760: END IF;
1761: ROLLBACK TO Update_Settings;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763: FND_MSG_PUB.Count_And_Get
1764: ( p_encoded => FND_API.G_FALSE,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data

Line 1764: ( p_encoded => FND_API.G_FALSE,

1760: END IF;
1761: ROLLBACK TO Update_Settings;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763: FND_MSG_PUB.Count_And_Get
1764: ( p_encoded => FND_API.G_FALSE,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data
1767: );
1768:

Line 1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1770: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1771: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1772: END IF;
1773: ROLLBACK TO Update_Settings;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1775: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1776: FND_MSG_PUB.Add_Exc_Msg
1777: ( G_PKG_NAME,
1778: l_api_name

Line 1782: ( p_encoded => FND_API.G_FALSE,

1778: l_api_name
1779: );
1780: END IF;
1781: FND_MSG_PUB.Count_And_Get
1782: ( p_encoded => FND_API.G_FALSE,
1783: p_count => x_msg_count,
1784: p_data => x_msg_data
1785: );
1786: