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.12.12020000.2 2012/08/14 06:35:35 amaheshw 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: p_price_mode VARCHAR2 := 'ENTIRE_QUOTE'
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 877: IF (p_retrieval_num <> FND_API.g_miss_num) then

873: ibe_util.debug(' l_qte_header_rec.quote_name : ' || l_qte_header_rec.quote_name);
874: 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'));
875: END IF;
876:
877: IF (p_retrieval_num <> FND_API.g_miss_num) then
878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
879: ibe_util.debug('passing sharee party and acct id');
880: END IF;
881: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;

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

877: IF (p_retrieval_num <> FND_API.g_miss_num) then
878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
879: ibe_util.debug('passing sharee party and acct id');
880: END IF;
881: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;
882: l_qte_header_rec.cust_account_id := FND_API.G_MISS_NUM;
883: l_sharee_party_id := p_party_id;
884: l_sharee_acct_id := p_acct_id;
885: END IF;

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

878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
879: ibe_util.debug('passing sharee party and acct id');
880: END IF;
881: l_qte_header_rec.party_id := FND_API.G_MISS_NUM;
882: l_qte_header_rec.cust_account_id := FND_API.G_MISS_NUM;
883: l_sharee_party_id := p_party_id;
884: l_sharee_acct_id := p_acct_id;
885: END IF;
886:

Line 889: p_init_msg_list => FND_API.G_FALSE,

885: END IF;
886:
887: IBE_Quote_Save_pvt.SAVE(
888: p_api_version_number => p_api_version,
889: p_init_msg_list => FND_API.G_FALSE,
890: p_commit => FND_API.g_false,
891: p_auto_update_active_quote => FND_API.g_false,
892: -- p_combineSameItem => 'Y', -- let api default from profile
893: p_sharee_Number => p_retrieval_num,

Line 890: p_commit => FND_API.g_false,

886:
887: IBE_Quote_Save_pvt.SAVE(
888: p_api_version_number => p_api_version,
889: p_init_msg_list => FND_API.G_FALSE,
890: p_commit => FND_API.g_false,
891: p_auto_update_active_quote => FND_API.g_false,
892: -- p_combineSameItem => 'Y', -- let api default from profile
893: p_sharee_Number => p_retrieval_num,
894: p_sharee_party_id => l_sharee_party_id,

Line 891: p_auto_update_active_quote => FND_API.g_false,

887: IBE_Quote_Save_pvt.SAVE(
888: p_api_version_number => p_api_version,
889: p_init_msg_list => FND_API.G_FALSE,
890: p_commit => FND_API.g_false,
891: p_auto_update_active_quote => FND_API.g_false,
892: -- p_combineSameItem => 'Y', -- let api default from profile
893: p_sharee_Number => p_retrieval_num,
894: p_sharee_party_id => l_sharee_party_id,
895: p_sharee_cust_account_id => l_sharee_acct_id,

Line 913: IF x_return_status <> FND_API.g_ret_sts_success THEN

909:
910: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
911: 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));
912: END IF;
913: IF x_return_status <> FND_API.g_ret_sts_success THEN
914: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
915: 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');
916: END IF;
917: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );

Line 920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

916: END IF;
917: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
918: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
919: FND_MSG_PUB.Add;
920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
921: RAISE FND_API.G_EXC_ERROR;
922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;

Line 921: RAISE FND_API.G_EXC_ERROR;

917: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
918: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
919: FND_MSG_PUB.Add;
920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
921: RAISE FND_API.G_EXC_ERROR;
922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925: ELSE

Line 922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

918: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
919: FND_MSG_PUB.Add;
920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
921: RAISE FND_API.G_EXC_ERROR;
922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925: ELSE
926: IF(l_attach_contract = FND_API.G_TRUE) THEN

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

919: FND_MSG_PUB.Add;
920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
921: RAISE FND_API.G_EXC_ERROR;
922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925: ELSE
926: IF(l_attach_contract = FND_API.G_TRUE) THEN
927: 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 926: IF(l_attach_contract = FND_API.G_TRUE) THEN

922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925: ELSE
926: IF(l_attach_contract = FND_API.G_TRUE) THEN
927: 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)
928: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
929: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : No contract currently attached !');
930: END IF;

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

953:
954: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
955: IBE_UTIL.debug('After copy_terms api, return status = '||x_return_status);
956: END IF;
957: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 958: RAISE FND_API.G_EXC_ERROR;

954: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
955: IBE_UTIL.debug('After copy_terms api, return status = '||x_return_status);
956: END IF;
957: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;

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

956: END IF;
957: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;
963: END IF; --If contract template id is not null
964: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')

Line 961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

957: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;
963: END IF; --If contract template id is not null
964: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')
965: ELSE

Line 981: p_init_msg_list => fnd_api.g_false ,

977: p_quote_header_id => p_cart_id ,
978: p_delete_context => 'IBE_SC_CART_ORDERED',
979: P_minisite_id => p_minisite_id ,
980: p_api_version => p_api_version ,
981: p_init_msg_list => fnd_api.g_false ,
982: p_commit => fnd_api.g_false ,
983: x_return_status => x_return_status ,
984: x_msg_count => x_msg_count ,
985: x_msg_data => x_msg_data );

Line 982: p_commit => fnd_api.g_false ,

978: p_delete_context => 'IBE_SC_CART_ORDERED',
979: P_minisite_id => p_minisite_id ,
980: p_api_version => p_api_version ,
981: p_init_msg_list => fnd_api.g_false ,
982: p_commit => fnd_api.g_false ,
983: x_return_status => x_return_status ,
984: x_msg_count => x_msg_count ,
985: x_msg_data => x_msg_data );
986:

Line 988: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

984: x_msg_count => x_msg_count ,
985: x_msg_data => x_msg_data );
986:
987:
988: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 989: RAISE FND_API.G_EXC_ERROR;

985: x_msg_data => x_msg_data );
986:
987:
988: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

988: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
996: ibe_util.debug('Express_buy_order: Done Calling stop_sharing');

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
996: ibe_util.debug('Express_buy_order: Done Calling stop_sharing');
997: END IF;

Line 1022: ,P_Init_Msg_List => FND_API.G_FALSE

1018: END LOOP;
1019:
1020: IBE_Shop_List_PVT.Save_Quote_From_Lists(
1021: P_Api_Version => 1.0
1022: ,P_Init_Msg_List => FND_API.G_FALSE
1023: ,P_Commit => FND_API.G_FALSE
1024: ,p_mode => 'MERGE'
1025: --,p_combine_same_item => null -- let default from profile
1026: ,p_sl_header_ids => p_list_ids

Line 1023: ,P_Commit => FND_API.G_FALSE

1019:
1020: IBE_Shop_List_PVT.Save_Quote_From_Lists(
1021: P_Api_Version => 1.0
1022: ,P_Init_Msg_List => FND_API.G_FALSE
1023: ,P_Commit => FND_API.G_FALSE
1024: ,p_mode => 'MERGE'
1025: --,p_combine_same_item => null -- let default from profile
1026: ,p_sl_header_ids => p_list_ids
1027: ,p_sl_header_ovns => p_list_ovns

Line 1043: IF x_return_status <> FND_API.g_ret_sts_success THEN

1039: ibe_util.debug('Back from IBE_Shop_List_PVT.Save_Quote_From_Lists ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1040: ibe_util.debug('X_cartId ' || lx_quote_header_id);
1041: END IF;
1042:
1043: IF x_return_status <> FND_API.g_ret_sts_success THEN
1044: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1045: 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');
1046: END IF;
1047: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );

Line 1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1046: END IF;
1047: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1048: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1049: FND_MSG_PUB.Add;
1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;

Line 1051: RAISE FND_API.G_EXC_ERROR;

1047: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1048: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1049: FND_MSG_PUB.Add;
1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;

Line 1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1048: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1049: FND_MSG_PUB.Add;
1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;
1056:

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049: FND_MSG_PUB.Add;
1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;
1056:
1057: END IF;

Line 1072: ,P_Init_Msg_List => FND_API.G_FALSE

1068: END IF;
1069: end loop;
1070: IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1071: P_Api_Version => 1.0
1072: ,P_Init_Msg_List => FND_API.G_FALSE
1073: ,P_Commit => FND_API.G_FALSE
1074: ,p_mode => 'MERGE'
1075: -- ,p_combine_same_item => null -- let default from profile
1076: ,p_sl_line_ids => p_list_line_ids

Line 1073: ,P_Commit => FND_API.G_FALSE

1069: end loop;
1070: IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1071: P_Api_Version => 1.0
1072: ,P_Init_Msg_List => FND_API.G_FALSE
1073: ,P_Commit => FND_API.G_FALSE
1074: ,p_mode => 'MERGE'
1075: -- ,p_combine_same_item => null -- let default from profile
1076: ,p_sl_line_ids => p_list_line_ids
1077: ,p_sl_line_ovns => p_list_line_ovns

Line 1093: if x_return_status <> FND_API.g_ret_sts_success then

1089: ibe_util.debug('Back from IBE_Shop_List_PVT.Save_Quote_From_List_Items ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1090: ibe_util.debug('X_cartId ' || lx_quote_header_id);
1091: END IF;
1092:
1093: if x_return_status <> FND_API.g_ret_sts_success then
1094: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1095: 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');
1096: END IF;
1097: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

Line 1101: if x_return_status = FND_API.G_RET_STS_ERROR then

1097: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1098: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1099: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1100: FND_MSG_PUB.Add;
1101: if x_return_status = FND_API.G_RET_STS_ERROR then
1102: RAISE FND_API.G_EXC_ERROR;
1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: end if;

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1099: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1100: FND_MSG_PUB.Add;
1101: if x_return_status = FND_API.G_RET_STS_ERROR then
1102: RAISE FND_API.G_EXC_ERROR;
1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: end if;
1106: end if;

Line 1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1099: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1100: FND_MSG_PUB.Add;
1101: if x_return_status = FND_API.G_RET_STS_ERROR then
1102: RAISE FND_API.G_EXC_ERROR;
1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: end if;
1106: end if;
1107: end if;

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100: FND_MSG_PUB.Add;
1101: if x_return_status = FND_API.G_RET_STS_ERROR then
1102: RAISE FND_API.G_EXC_ERROR;
1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: end if;
1106: end if;
1107: end if;
1108:

Line 1115: IF FND_API.To_Boolean( p_commit ) THEN

1111: END IF;
1112: -- let the caller know which quote we finally updated
1113: x_new_cart_id := l_curr_cart_id;
1114:
1115: IF FND_API.To_Boolean( p_commit ) THEN
1116: COMMIT WORK;
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: ( p_encoded => FND_API.G_FALSE,

Line 1119: ( p_encoded => FND_API.G_FALSE,

1115: IF FND_API.To_Boolean( p_commit ) THEN
1116: COMMIT WORK;
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: ( p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count ,
1121: p_data => x_msg_data );
1122:
1123: --ibe_util.disable_debug;

Line 1125: WHEN FND_API.G_EXC_ERROR THEN

1121: p_data => x_msg_data );
1122:
1123: --ibe_util.disable_debug;
1124: EXCEPTION
1125: WHEN FND_API.G_EXC_ERROR THEN
1126: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1127: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1128: END IF;
1129: ROLLBACK TO Express_Buy_Order_Pvt;

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1127: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1128: END IF;
1129: ROLLBACK TO Express_Buy_Order_Pvt;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1132: FND_MSG_PUB.Count_And_Get
1133: ( p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,

Line 1133: ( p_encoded => FND_API.G_FALSE,

1129: ROLLBACK TO Express_Buy_Order_Pvt;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1132: FND_MSG_PUB.Count_And_Get
1133: ( p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1137: --ibe_util.disable_debug;

Line 1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1134: p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1137: --ibe_util.disable_debug;
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1140: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1141: END IF;
1142: ROLLBACK TO Express_Buy_Order_Pvt;

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1139: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1140: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1141: END IF;
1142: ROLLBACK TO Express_Buy_Order_Pvt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get
1145: ( p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data

Line 1145: ( p_encoded => FND_API.G_FALSE,

1141: END IF;
1142: ROLLBACK TO Express_Buy_Order_Pvt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get
1145: ( p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149: --ibe_util.disable_debug;

Line 1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1151: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1152: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1153: END IF;
1154: ROLLBACK TO Express_Buy_Order_Pvt;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg
1159: ( G_PKG_NAME,

Line 1164: ( p_encoded => FND_API.G_FALSE,

1160: l_api_name
1161: );
1162: END IF;
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_encoded => FND_API.G_FALSE,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168: --ibe_util.disable_debug;

Line 1254: l_curr_cart_id NUMBER := FND_API.g_miss_num;

1250: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1251: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253:
1254: l_curr_cart_id NUMBER := FND_API.g_miss_num;
1255: l_curr_cart_date DATE;
1256: l_curr_cart_currcode VARCHAR2(10);
1257: l_object_version_number NUMBER;
1258: l_ord_oneclick_id NUMBER;

Line 1269: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;

1265: l_save_trigger VARCHAR2(3);
1266: l_party_type VARCHAR2(300);
1267: l_optional_party_id NUMBER;
1268: l_count_tax NUMBER := 0;
1269: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
1270: l_count NUMBER := 0;
1271: l_retrieval_num NUMBER := FND_API.g_miss_num;
1272: l_credit_card_num NUMBER;
1273: l_credit_card_name VARCHAR2(80);

Line 1271: l_retrieval_num NUMBER := FND_API.g_miss_num;

1267: l_optional_party_id NUMBER;
1268: l_count_tax NUMBER := 0;
1269: l_payment_rec_id NUMBER := FND_API.G_MISS_NUM;
1270: l_count NUMBER := 0;
1271: l_retrieval_num NUMBER := FND_API.g_miss_num;
1272: l_credit_card_num NUMBER;
1273: l_credit_card_name VARCHAR2(80);
1274: l_credit_card_exp DATE;
1275: l_credit_card_holder_name VARCHAR2(50);

Line 1328: l_curr_cart_id := FND_API.g_miss_num;

1324: OPEN c_quote(x_qte_header_rec.party_id,
1325: x_qte_header_rec.cust_account_id);
1326: FETCH c_quote INTO l_curr_cart_id, l_curr_cart_date, l_curr_cart_currcode;
1327: if c_quote%NOTFOUND then
1328: l_curr_cart_id := FND_API.g_miss_num;
1329: else
1330: null;
1331: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1332: ibe_util.debug('get_express_items_settings got l_curr_cart_id ' || to_char(l_curr_cart_id));

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

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

Line 1365: p_init_msg_list => FND_API.G_FALSE,

1361: 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'));
1362: END IF;
1363: IBE_Quote_Save_pvt.SAVE(
1364: p_api_version_number => 1.0,
1365: p_init_msg_list => FND_API.G_FALSE,
1366: p_commit => FND_API.g_false,
1367: p_auto_update_active_quote => FND_API.g_false,
1368: --p_combineSameItem => 'Y', -- let api default from profile
1369: p_control_rec => l_control_rec,

Line 1366: p_commit => FND_API.g_false,

1362: END IF;
1363: IBE_Quote_Save_pvt.SAVE(
1364: p_api_version_number => 1.0,
1365: p_init_msg_list => FND_API.G_FALSE,
1366: p_commit => FND_API.g_false,
1367: p_auto_update_active_quote => FND_API.g_false,
1368: --p_combineSameItem => 'Y', -- let api default from profile
1369: p_control_rec => l_control_rec,
1370: p_qte_header_rec => l_push_qte_header_rec,

Line 1367: p_auto_update_active_quote => FND_API.g_false,

1363: IBE_Quote_Save_pvt.SAVE(
1364: p_api_version_number => 1.0,
1365: p_init_msg_list => FND_API.G_FALSE,
1366: p_commit => FND_API.g_false,
1367: p_auto_update_active_quote => FND_API.g_false,
1368: --p_combineSameItem => 'Y', -- let api default from profile
1369: p_control_rec => l_control_rec,
1370: p_qte_header_rec => l_push_qte_header_rec,
1371: p_save_type => UPDATE_EXPRESSORDER,

Line 1381: if lx_return_status <> FND_API.g_ret_sts_success then

1377: --ibe_util.enable_debug;
1378: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1379: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE for pushing out' );
1380: END IF;
1381: if lx_return_status <> FND_API.g_ret_sts_success then
1382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1383: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1384: END IF;
1385: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

Line 1389: if lx_return_status = FND_API.G_RET_STS_ERROR then

1385: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1386: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1387: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1388: FND_MSG_PUB.Add;
1389: if lx_return_status = FND_API.G_RET_STS_ERROR then
1390: RAISE FND_API.G_EXC_ERROR;
1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: end if;

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1387: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1388: FND_MSG_PUB.Add;
1389: if lx_return_status = FND_API.G_RET_STS_ERROR then
1390: RAISE FND_API.G_EXC_ERROR;
1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: end if;
1394: end if;

Line 1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1387: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1388: FND_MSG_PUB.Add;
1389: if lx_return_status = FND_API.G_RET_STS_ERROR then
1390: RAISE FND_API.G_EXC_ERROR;
1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: end if;
1394: end if;
1395: -- set these to g_miss so rest of api can know we have to start with a new quote

Line 1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1388: FND_MSG_PUB.Add;
1389: if lx_return_status = FND_API.G_RET_STS_ERROR then
1390: RAISE FND_API.G_EXC_ERROR;
1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: end if;
1394: end if;
1395: -- set these to g_miss so rest of api can know we have to start with a new quote
1396: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;

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

1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: end if;
1394: end if;
1395: -- set these to g_miss so rest of api can know we have to start with a new quote
1396: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;
1397: l_curr_cart_id := FND_API.g_miss_num;
1398: l_curr_cart_date := FND_API.g_miss_date;
1399: else
1400: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart

Line 1397: l_curr_cart_id := FND_API.g_miss_num;

1393: end if;
1394: end if;
1395: -- set these to g_miss so rest of api can know we have to start with a new quote
1396: l_qte_header_rec.quote_header_id := FND_API.g_miss_num;
1397: l_curr_cart_id := FND_API.g_miss_num;
1398: l_curr_cart_date := FND_API.g_miss_date;
1399: else
1400: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart
1401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1398: l_curr_cart_date := FND_API.g_miss_date;

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

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

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

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

1558: ibe_util.debug('l_shipment_rec.ship_to_party_site_id ' || l_shipment_rec.ship_to_party_site_id);
1559: ibe_util.debug('l_shipment_rec.ship_to_party_id ' || l_shipment_rec.ship_to_party_id);
1560: END IF;
1561:
1562: END IF; --IF ((p_flag = 'CART') or ((p_flag <> 'CART') and (l_curr_cart_id = FND_API.g_miss_num)))
1563:
1564: x_qte_header_rec := l_qte_header_rec;
1565:
1566: END;

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

1615: ------------------------------------------------------------------------------
1616: */
1617: Procedure Update_Settings(
1618: p_api_version IN NUMBER,
1619: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1620: p_commit IN VARCHAR2 := FND_API.g_false,
1621: x_return_status OUT NOCOPY VARCHAR2,
1622: x_msg_count OUT NOCOPY NUMBER,
1623: x_msg_data OUT NOCOPY VARCHAR2,

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

1616: */
1617: Procedure Update_Settings(
1618: p_api_version IN NUMBER,
1619: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1620: p_commit IN VARCHAR2 := FND_API.g_false,
1621: x_return_status OUT NOCOPY VARCHAR2,
1622: x_msg_count OUT NOCOPY NUMBER,
1623: x_msg_data OUT NOCOPY VARCHAR2,
1624: p_party_id IN NUMBER := NULL,

Line 1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;

1627: IS
1628:
1629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1630: l_api_version CONSTANT NUMBER := 1.0;
1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;

Line 1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;

1628:
1629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1630: l_api_version CONSTANT NUMBER := 1.0;
1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1636: l_enabled_flag VARCHAR2(1) := 'N';

Line 1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;

1629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Settings';
1630: l_api_version CONSTANT NUMBER := 1.0;
1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1636: l_enabled_flag VARCHAR2(1) := 'N';
1637: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;

1630: l_api_version CONSTANT NUMBER := 1.0;
1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1636: l_enabled_flag VARCHAR2(1) := 'N';
1637: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1638:

Line 1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;

1631: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
1632: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1636: l_enabled_flag VARCHAR2(1) := 'N';
1637: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1638:
1639: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,

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

1633: l_payment_id NUMBER := FND_API.G_MISS_NUM;
1634: l_bill_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1635: l_ship_ptysite_id NUMBER := FND_API.G_MISS_NUM;
1636: l_enabled_flag VARCHAR2(1) := 'N';
1637: l_freight_code VARCHAR2(30) := FND_API.G_MISS_CHAR;
1638:
1639: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,
1640: c_acct_id IN NUMBER)
1641: IS

Line 1653: x_return_status := FND_API.g_ret_sts_success;

1649:
1650: SAVEPOINT Update_Settings;
1651:
1652: -- Initialize API rturn status to success
1653: x_return_status := FND_API.g_ret_sts_success;
1654:
1655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1656: ibe_util.debug('------- Input to ibe_ord_oneclick_pvt.Update_Settings: -----------------');
1657: ibe_util.debug('p_party_id :'||p_party_id);

Line 1674: l_oneclick_id := FND_API.g_miss_num;

1670: l_bill_ptysite_id,
1671: l_ship_ptysite_id;
1672:
1673: IF c_get_oneclick_settings%NOTFOUND THEN
1674: l_oneclick_id := FND_API.g_miss_num;
1675: END IF;
1676: CLOSE c_get_oneclick_settings;
1677:
1678: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1690: 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

1686: ibe_util.debug('l_ship_ptysite_id :'||l_ship_ptysite_id);
1687: ibe_util.debug('Checking p_assignment_id not null :'||p_assignment_id);
1688: END IF;
1689:
1690: 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
1691: l_enabled_flag := 'N';
1692: l_payment_id := '';
1693:
1694: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1701: p_init_msg_list => FND_API.G_FALSE,

1697: END IF;
1698:
1699: ibe_ord_oneclick_pvt.save_settings(
1700: p_api_version => l_api_version,
1701: p_init_msg_list => FND_API.G_FALSE,
1702: p_commit => p_commit,
1703: x_return_status => x_return_status,
1704: x_msg_count => x_msg_count,
1705: x_msg_data => x_msg_data,

Line 1721: IF x_return_status <> FND_API.g_ret_sts_success THEN

1717: ibe_util.debug('Update_Settings : After Calling ibe_ord_oneclick_pvt.save_settings');
1718: ibe_util.debug('Update_Settings : x_return_status - '||x_return_status);
1719: END IF;
1720:
1721: IF x_return_status <> FND_API.g_ret_sts_success THEN
1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1723: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1721: IF x_return_status <> FND_API.g_ret_sts_success THEN
1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1723: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1723: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END IF;

Line 1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1723: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END IF;
1731:

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END IF;
1731:
1732: IF FND_API.To_Boolean( p_commit ) THEN

Line 1732: IF FND_API.To_Boolean( p_commit ) THEN

1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END IF;
1731:
1732: IF FND_API.To_Boolean( p_commit ) THEN
1733: COMMIT WORK;
1734: END IF;
1735:
1736: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1749: ( p_encoded => FND_API.G_FALSE,

1745:
1746: END IF;
1747:
1748: FND_MSG_PUB.Count_And_Get
1749: ( p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data
1752: );
1753:

Line 1755: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1762: ( p_encoded => FND_API.G_FALSE,

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

Line 1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1763: p_count => x_msg_count,
1764: p_data => x_msg_data
1765: );
1766:
1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1769: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1770: END IF;
1771: ROLLBACK TO Update_Settings;

Line 1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1769: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1770: END IF;
1771: ROLLBACK TO Update_Settings;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: FND_MSG_PUB.Count_And_Get
1774: ( p_encoded => FND_API.G_FALSE,
1775: p_count => x_msg_count,
1776: p_data => x_msg_data

Line 1774: ( p_encoded => FND_API.G_FALSE,

1770: END IF;
1771: ROLLBACK TO Update_Settings;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: FND_MSG_PUB.Count_And_Get
1774: ( p_encoded => FND_API.G_FALSE,
1775: p_count => x_msg_count,
1776: p_data => x_msg_data
1777: );
1778:

Line 1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1780: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1781: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1782: END IF;
1783: ROLLBACK TO Update_Settings;
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1786: FND_MSG_PUB.Add_Exc_Msg
1787: ( G_PKG_NAME,
1788: l_api_name

Line 1792: ( p_encoded => FND_API.G_FALSE,

1788: l_api_name
1789: );
1790: END IF;
1791: FND_MSG_PUB.Count_And_Get
1792: ( p_encoded => FND_API.G_FALSE,
1793: p_count => x_msg_count,
1794: p_data => x_msg_data
1795: );
1796: