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

Line 15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoisplb.pls';
12:
13: PROCEDURE Split_Quote_line (
14: P_Api_Version_Number IN NUMBER,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

12:
13: PROCEDURE Split_Quote_line (
14: P_Api_Version_Number IN NUMBER,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,

Line 42: x_return_status := fnd_api.g_ret_sts_success;

38:
39: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
40:
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:
44: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
45: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Split_Quote_line Begin', 1, 'Y');
46: END IF;

Line 69: p_init_msg_list => fnd_api.g_false,

65: END IF;
66:
67: split_quote_line(
68: p_api_version_number => p_api_version_number,
69: p_init_msg_list => fnd_api.g_false,
70: p_commit => p_commit,
71: p_control_rec => l_control_rec,
72: p_qte_header_rec => l_qte_header_rec,
73: p_original_qte_line_rec => l_qte_line_rec,

Line 98: p_init_msg_list IN varchar2 := fnd_api.g_false,

94:
95:
96: PROCEDURE split_quote_line(
97: p_api_version_number IN number,
98: p_init_msg_list IN varchar2 := fnd_api.g_false,
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type

Line 99: p_commit IN varchar2 := fnd_api.g_false,

95:
96: PROCEDURE split_quote_line(
97: p_api_version_number IN number,
98: p_init_msg_list IN varchar2 := fnd_api.g_false,
99: p_commit IN varchar2 := fnd_api.g_false,
100: p_control_rec IN aso_quote_pub.control_rec_type
101: := aso_quote_pub.g_miss_control_rec,
102: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
103: := aso_quote_pub.g_miss_qte_header_rec,

Line 119: l_serviceable_item VARCHAR2(1) := FND_API.G_FALSE;

115: l_api_name CONSTANT VARCHAR2(30) := 'Split_Quote_line';
116: l_api_version_number NUMBER := 1.0;
117: l_file VARCHAR2(300);
118: l_config_header_id NUMBER;
119: l_serviceable_item VARCHAR2(1) := FND_API.G_FALSE;
120: l_call_do_split_line VARCHAR2(1) := FND_API.G_FALSE;
121: l_quote_header_id NUMBER;
122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;
123: l_x_status VARCHAR2(1);

Line 120: l_call_do_split_line VARCHAR2(1) := FND_API.G_FALSE;

116: l_api_version_number NUMBER := 1.0;
117: l_file VARCHAR2(300);
118: l_config_header_id NUMBER;
119: l_serviceable_item VARCHAR2(1) := FND_API.G_FALSE;
120: l_call_do_split_line VARCHAR2(1) := FND_API.G_FALSE;
121: l_quote_header_id NUMBER;
122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;
123: l_x_status VARCHAR2(1);
124:

Line 122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;

118: l_config_header_id NUMBER;
119: l_serviceable_item VARCHAR2(1) := FND_API.G_FALSE;
120: l_call_do_split_line VARCHAR2(1) := FND_API.G_FALSE;
121: l_quote_header_id NUMBER;
122: l_call_lock_exist VARCHAR2(1) := FND_API.G_FALSE;
123: l_x_status VARCHAR2(1);
124:
125: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
126: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;

Line 130: l_split_model_line VARCHAR2(1) := FND_API.G_FALSE;

126: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
127:
128: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
129:
130: l_split_model_line VARCHAR2(1) := FND_API.G_FALSE;
131:
132: Cursor c_config_exist is
133: select config_header_id
134: from aso_quote_line_details

Line 170: x_return_status := FND_API.G_RET_STS_SUCCESS;

166:
167: END IF;
168:
169: --Initialize API return status to SUCCESS
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:
172: --Standard call to check for call compatibility.
173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
174: p_api_version_number,

Line 173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

169: --Initialize API return status to SUCCESS
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:
172: --Standard call to check for call compatibility.
173: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
174: p_api_version_number,
175: l_api_name,
176: G_PKG_NAME) THEN
177:

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: p_api_version_number,
175: l_api_name,
176: G_PKG_NAME) THEN
177:
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179:
180: END IF;
181:
182: --Initialize message list if p_init_msg_list is set to TRUE.

Line 183: IF FND_API.to_Boolean( p_init_msg_list ) THEN

179:
180: END IF;
181:
182: --Initialize message list if p_init_msg_list is set to TRUE.
183: IF FND_API.to_Boolean( p_init_msg_list ) THEN
184:
185: FND_MSG_PUB.initialize;
186:
187: END IF;

Line 197: p_qte_header_rec.quote_header_id <> fnd_api.g_miss_num THEN

193:
194: END IF;
195:
196: IF p_qte_header_rec.quote_header_id is not null OR
197: p_qte_header_rec.quote_header_id <> fnd_api.g_miss_num THEN
198:
199: l_call_lock_exist := fnd_api.g_true;
200: l_quote_header_id := p_qte_header_rec.quote_header_id;
201:

Line 199: l_call_lock_exist := fnd_api.g_true;

195:
196: IF p_qte_header_rec.quote_header_id is not null OR
197: p_qte_header_rec.quote_header_id <> fnd_api.g_miss_num THEN
198:
199: l_call_lock_exist := fnd_api.g_true;
200: l_quote_header_id := p_qte_header_rec.quote_header_id;
201:
202: ELSIF p_original_qte_line_rec.quote_line_id is not null OR
203: p_original_qte_line_rec.quote_line_id <> fnd_api.g_miss_num THEN

Line 203: p_original_qte_line_rec.quote_line_id <> fnd_api.g_miss_num THEN

199: l_call_lock_exist := fnd_api.g_true;
200: l_quote_header_id := p_qte_header_rec.quote_header_id;
201:
202: ELSIF p_original_qte_line_rec.quote_line_id is not null OR
203: p_original_qte_line_rec.quote_line_id <> fnd_api.g_miss_num THEN
204:
205: open c_quote_header_id;
206: fetch c_quote_header_id into l_quote_header_id;
207:

Line 209: l_call_lock_exist := fnd_api.g_true;

205: open c_quote_header_id;
206: fetch c_quote_header_id into l_quote_header_id;
207:
208: IF c_quote_header_id%found and l_quote_header_id is not null THEN
209: l_call_lock_exist := fnd_api.g_true;
210: END IF;
211:
212: close c_quote_header_id;
213:

Line 231: IF l_call_lock_exist = fnd_api.g_true THEN

227: IF aso_debug_pub.g_debug_flag = 'Y' THEN
228: aso_debug_pub.add('split_quote_line: l_call_lock_exist: '|| l_call_lock_exist);
229: END IF;
230:
231: IF l_call_lock_exist = fnd_api.g_true THEN
232:
233: aso_conc_req_int.lock_exists( p_quote_header_id => l_quote_header_id,
234: x_status => l_x_status );
235:

Line 240: if l_x_status = fnd_api.g_true then

236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
237: aso_debug_pub.add('split_quote_line: l_x_status: '|| l_x_status);
238: END IF;
239:
240: if l_x_status = fnd_api.g_true then
241:
242: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) then
243: fnd_message.set_name('ASO', 'ASO_CONC_REQUEST_RUNNING');
244: fnd_msg_pub.add;

Line 247: x_return_status := fnd_api.g_ret_sts_error;

243: fnd_message.set_name('ASO', 'ASO_CONC_REQUEST_RUNNING');
244: fnd_msg_pub.add;
245: end if;
246:
247: x_return_status := fnd_api.g_ret_sts_error;
248: raise fnd_api.g_exc_error;
249:
250: end if;
251:

Line 248: raise fnd_api.g_exc_error;

244: fnd_msg_pub.add;
245: end if;
246:
247: x_return_status := fnd_api.g_ret_sts_error;
248: raise fnd_api.g_exc_error;
249:
250: end if;
251:
252: END IF;

Line 255: p_original_qte_line_rec.quote_line_id = FND_API.G_MISS_NUM THEN

251:
252: END IF;
253:
254: IF p_original_qte_line_rec.quote_line_id is null OR
255: p_original_qte_line_rec.quote_line_id = FND_API.G_MISS_NUM THEN
256:
257: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
258: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id is null or G_MISS_NUM');
259: END IF;

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
258: aso_debug_pub.add('Split_Quote_line: p_original_qte_line_rec.quote_line_id is null or G_MISS_NUM');
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
264:
265: FND_MESSAGE.Set_Name ('ASO', 'ASO_API_INVALID_ID');

Line 272: RAISE FND_API.G_EXC_ERROR;

268: FND_MSG_PUB.ADD;
269:
270: END IF;
271:
272: RAISE FND_API.G_EXC_ERROR;
273:
274: ELSIF p_qte_line_tbl.count = 0 THEN
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('Split_Quote_line: p_qte_line_tbl.count: '|| p_qte_line_tbl.count);
278: END IF;
279:
280: x_return_status := FND_API.G_RET_STS_ERROR;
281:
282: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
283:
284: FND_MESSAGE.Set_Name ('ASO', 'ASO_ERR_NO_REC');

Line 290: RAISE FND_API.G_EXC_ERROR;

286: FND_MSG_PUB.ADD;
287:
288: END IF;
289:
290: RAISE FND_API.G_EXC_ERROR;
291:
292: ELSIF p_qte_line_tbl.count = 1 AND p_qte_line_tbl(1).quantity <= 0 THEN
293:
294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
295: aso_debug_pub.add('Split_Quote_line: Only one record in p_qte_line_tbl with zero line quantity');
296: END IF;
297:
298: x_return_status := FND_API.G_RET_STS_ERROR;
299:
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
301:
302: FND_MESSAGE.Set_Name ('ASO', 'ASO_ERR_SPLITLINE_QTY');

Line 309: RAISE FND_API.G_EXC_ERROR;

305: FND_MSG_PUB.ADD;
306:
307: END IF;
308:
309: RAISE FND_API.G_EXC_ERROR;
310:
311: ELSE
312:
313: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_original_qte_line_rec.quote_line_id);

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
329: aso_debug_pub.add('Quote line created from install base having line_category_code = RETURN and refer to an order, can not be spilted.');
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:
334: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
335:
336: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CANNOT_SPLIT');

Line 341: RAISE FND_API.G_EXC_ERROR;

337: FND_MSG_PUB.ADD;
338:
339: END IF;
340:
341: RAISE FND_API.G_EXC_ERROR;
342:
343: END IF;
344:
345: END IF;

Line 357: x_return_status := FND_API.G_RET_STS_ERROR;

353: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
354: aso_debug_pub.add('Split_Quote_line: Quote line item type code is CFG split of this line is not allowed', 1, 'N');
355: END IF;
356:
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:
359: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
360:
361: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CANNOT_SPLIT');

Line 366: RAISE FND_API.G_EXC_ERROR;

362: FND_MSG_PUB.ADD;
363:
364: END IF;
365:
366: RAISE FND_API.G_EXC_ERROR;
367:
368: ELSIF l_qte_line_rec.item_type_code = 'MDL' THEN
369:
370: OPEN c_config_exist;

Line 385: p_init_msg_list => fnd_api.g_false,

381: END IF;
382:
383: aso_copy_quote_pvt.split_model_line (
384: p_api_version_number => p_api_version_number,
385: p_init_msg_list => fnd_api.g_false,
386: p_commit => fnd_api.g_false,
387: p_control_rec => p_control_rec,
388: p_qte_header_rec => p_qte_header_rec,
389: p_original_qte_line_rec => l_qte_line_rec,

Line 386: p_commit => fnd_api.g_false,

382:
383: aso_copy_quote_pvt.split_model_line (
384: p_api_version_number => p_api_version_number,
385: p_init_msg_list => fnd_api.g_false,
386: p_commit => fnd_api.g_false,
387: p_control_rec => p_control_rec,
388: p_qte_header_rec => p_qte_header_rec,
389: p_original_qte_line_rec => l_qte_line_rec,
390: p_qte_line_tbl => p_qte_line_tbl,

Line 401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

397: aso_debug_pub.add('After call to the Split Model Line API in Copy Quote',1,'N');
398: aso_debug_pub.add('Split_Quote_line: x_return_status: '|| x_return_status );
399: END IF;
400:
401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402:
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: RAISE FND_API.G_EXC_ERROR;
405:

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

399: END IF;
400:
401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402:
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: RAISE FND_API.G_EXC_ERROR;
405:
406: END IF;
407:

Line 404: RAISE FND_API.G_EXC_ERROR;

400:
401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
402:
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: RAISE FND_API.G_EXC_ERROR;
405:
406: END IF;
407:
408: l_split_model_line := FND_API.G_TRUE;

Line 408: l_split_model_line := FND_API.G_TRUE;

404: RAISE FND_API.G_EXC_ERROR;
405:
406: END IF;
407:
408: l_split_model_line := FND_API.G_TRUE;
409:
410: ELSE
411:
412: CLOSE c_config_exist;

Line 418: l_call_do_split_line := FND_API.G_TRUE;

414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
415: aso_debug_pub.add('Split_Quote_line: Model item but not configured');
416: END IF;
417:
418: l_call_do_split_line := FND_API.G_TRUE;
419:
420: END IF;
421:
422: END IF;

Line 431: x_return_status := FND_API.G_RET_STS_ERROR;

427: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
428: aso_debug_pub.add('Split_Quote_line: Split of service item line is not allowed');
429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432:
433: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
434:
435: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CANNOT_SPLIT');

Line 440: RAISE FND_API.G_EXC_ERROR;

436: FND_MSG_PUB.ADD;
437:
438: END IF;
439:
440: RAISE FND_API.G_EXC_ERROR;
441:
442: ELSIF l_qte_line_rec.serviceable_product_flag = 'Y' THEN
443:
444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 448: l_serviceable_item := FND_API.G_TRUE;

444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
445: aso_debug_pub.add('Split_Quote_line: Serviceable item line');
446: END IF;
447:
448: l_serviceable_item := FND_API.G_TRUE;
449: l_call_do_split_line := FND_API.G_TRUE;
450:
451: ELSE
452:

Line 449: l_call_do_split_line := FND_API.G_TRUE;

445: aso_debug_pub.add('Split_Quote_line: Serviceable item line');
446: END IF;
447:
448: l_serviceable_item := FND_API.G_TRUE;
449: l_call_do_split_line := FND_API.G_TRUE;
450:
451: ELSE
452:
453: l_call_do_split_line := FND_API.G_TRUE;

Line 453: l_call_do_split_line := FND_API.G_TRUE;

449: l_call_do_split_line := FND_API.G_TRUE;
450:
451: ELSE
452:
453: l_call_do_split_line := FND_API.G_TRUE;
454:
455: END IF;
456:
457:

Line 458: IF l_call_do_split_line = FND_API.G_TRUE AND l_split_model_line = FND_API.G_FALSE THEN

454:
455: END IF;
456:
457:
458: IF l_call_do_split_line = FND_API.G_TRUE AND l_split_model_line = FND_API.G_FALSE THEN
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.add('Split_Quote_line: Before call to Do_Split_line');
462: END IF;

Line 470: p_commit => fnd_api.g_false,

466: p_original_qte_line_rec => l_qte_line_rec,
467: p_serviceable_item => l_serviceable_item,
468: p_qte_line_tbl => p_qte_line_tbl,
469: p_ln_shipment_tbl => p_ln_shipment_tbl,
470: p_commit => fnd_api.g_false,
471: x_qte_line_tbl => lx_qte_line_tbl,
472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data

Line 482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

478: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line');
479: aso_debug_pub.add('Split_Quote_line: After call to Do_Split_line: x_return_status: '|| x_return_status);
480: END IF;
481:
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483:
484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Split_Quote_Line: Error in Do_Split_Line');
486: END IF;

Line 488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Split_Quote_Line: Error in Do_Split_Line');
486: END IF;
487:
488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
489:
490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 490: RAISE FND_API.G_EXC_ERROR;

486: END IF;
487:
488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
489:
490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493:
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 492: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

488: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
489:
490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493:
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495:
496: END IF;

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
493:
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495:
496: END IF;
497:
498: END IF;

Line 518: IF FND_API.to_Boolean( p_commit ) THEN

514: X_Qte_Line_Tbl := lx_Qte_Line_Tbl;
515:
516: --Standard check for p_commit
517:
518: IF FND_API.to_Boolean( p_commit ) THEN
519:
520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
521: aso_debug_pub.add('Split_Quote_line: Commiting work.', 1, 'N');
522: END IF;

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530: p_data => x_msg_data );
531:
532: EXCEPTION
533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
538: END IF;

Line 537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');

533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
538: END IF;
539:
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
541: P_PKG_NAME => G_PKG_NAME,

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: X_MSG_COUNT => X_MSG_COUNT,
545: X_MSG_DATA => X_MSG_DATA,
546: X_RETURN_STATUS => X_RETURN_STATUS);
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549:
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
552: END IF;

Line 551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');

547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549:
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
552: END IF;
553:
554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
555: P_PKG_NAME => G_PKG_NAME,

Line 586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,

582: PROCEDURE Do_Split_line (
583: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
584: p_control_rec IN aso_quote_pub.control_rec_type,
585: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
586: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
587: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
588: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
589: p_commit IN VARCHAR2,
590: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 700: x_return_status := fnd_api.g_ret_sts_success;

696: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SPLIT_LINE_INT: Begin Do_Split_Line procedure', 1, 'Y');
698: END IF;
699:
700: x_return_status := fnd_api.g_ret_sts_success;
701:
702: /*
703: l_qte_header_rec := aso_utility_pvt.query_header_row(l_qte_line_rec.quote_header_id);
704:

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
739: aso_debug_pub.add('Do_Split_Line: Line quantity is <= 0 OR New quote line to be created qty > original line quantity', 1, 'N');
740: END IF;
741:
742: x_return_status := FND_API.G_RET_STS_ERROR;
743:
744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
745: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
746: FND_MSG_PUB.ADD;

Line 749: RAISE FND_API.G_EXC_ERROR;

745: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
746: FND_MSG_PUB.ADD;
747: END IF;
748:
749: RAISE FND_API.G_EXC_ERROR;
750:
751: ELSE
752:
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 760: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;

756:
757: l_to_create_quote_line_rec := l_qte_line_rec;
758: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;
759: l_to_create_quote_line_rec.operation_code := 'CREATE';
760: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;
761: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;
762: l_to_create_quote_line_tbl(i) := l_to_create_quote_line_rec;
763: l_qte_line_rec.quantity := l_qte_line_rec.quantity - p_qte_line_tbl(i).quantity;
764: l_map_qte_line_tbl(i).quote_line_id := l_qte_line_rec.quote_line_id;

Line 761: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;

757: l_to_create_quote_line_rec := l_qte_line_rec;
758: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;
759: l_to_create_quote_line_rec.operation_code := 'CREATE';
760: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;
761: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;
762: l_to_create_quote_line_tbl(i) := l_to_create_quote_line_rec;
763: l_qte_line_rec.quantity := l_qte_line_rec.quantity - p_qte_line_tbl(i).quantity;
764: l_map_qte_line_tbl(i).quote_line_id := l_qte_line_rec.quote_line_id;
765:

Line 770: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;

766: --Populate Shipment records
767:
768: l_to_create_shipment_rec := l_ln_Shipment_Tbl(1);
769: l_to_create_shipment_rec.operation_code := 'CREATE';
770: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;
771: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;
772: l_to_create_shipment_rec.qte_line_index := i;
773: l_to_create_shipment_rec.quantity := l_to_create_quote_line_rec.quantity;
774:

Line 771: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;

767:
768: l_to_create_shipment_rec := l_ln_Shipment_Tbl(1);
769: l_to_create_shipment_rec.operation_code := 'CREATE';
770: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;
771: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;
772: l_to_create_shipment_rec.qte_line_index := i;
773: l_to_create_shipment_rec.quantity := l_to_create_quote_line_rec.quantity;
774:
775:

Line 796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN

792: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
793: aso_debug_pub.add('Do_Split_Line: Inside shipment loop, shipment record exist for given line ');
794: END IF;
795:
796: IF P_ln_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM THEN
797:
798: l_to_create_shipment_rec.ship_to_cust_account_id := P_ln_Shipment_Tbl(j).ship_to_cust_account_id;
799: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
800: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_cust_account_id :'||l_to_create_shipment_rec.ship_to_cust_account_id);

Line 806: IF P_ln_Shipment_Tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN

802:
803: END IF;
804:
805:
806: IF P_ln_Shipment_Tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
807:
808: l_to_create_shipment_rec.ship_to_party_site_id := P_ln_Shipment_Tbl(j).ship_to_party_site_id;
809: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
810: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_to_party_site_id :'||l_to_create_shipment_rec.ship_to_party_site_id);

Line 816: IF P_ln_Shipment_Tbl(j).ship_to_party_id <> FND_API.G_MISS_NUM THEN

812:
813: END IF;
814:
815:
816: IF P_ln_Shipment_Tbl(j).ship_to_party_id <> FND_API.G_MISS_NUM THEN
817:
818: l_to_create_shipment_rec.ship_to_party_id := P_ln_Shipment_Tbl(j).ship_to_party_id;
819:
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 827: IF P_ln_Shipment_Tbl(j).ship_method_code <> FND_API.G_MISS_CHAR THEN

823:
824: END IF;
825:
826:
827: IF P_ln_Shipment_Tbl(j).ship_method_code <> FND_API.G_MISS_CHAR THEN
828:
829: l_to_create_shipment_rec.ship_method_code := P_ln_Shipment_Tbl(j).ship_method_code;
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.ship_method_code :'||l_to_create_shipment_rec.ship_method_code);

Line 837: IF P_ln_Shipment_Tbl(j).shipping_instructions <> FND_API.G_MISS_CHAR THEN

833:
834: END IF;
835:
836:
837: IF P_ln_Shipment_Tbl(j).shipping_instructions <> FND_API.G_MISS_CHAR THEN
838:
839: l_to_create_shipment_rec.shipping_instructions := P_ln_Shipment_Tbl(j).shipping_instructions;
840: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
841: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.shipping_instructions :'||l_to_create_shipment_rec.shipping_instructions);

Line 847: IF P_ln_Shipment_Tbl(j).packing_instructions <> FND_API.G_MISS_CHAR THEN

843:
844: END IF;
845:
846:
847: IF P_ln_Shipment_Tbl(j).packing_instructions <> FND_API.G_MISS_CHAR THEN
848:
849: l_to_create_shipment_rec.packing_instructions := P_ln_Shipment_Tbl(j).packing_instructions;
850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
851: aso_debug_pub.add('Do_Split_Line: l_to_create_shipment_rec.packing_instructions :'||l_to_create_shipment_rec.packing_instructions);

Line 877: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;

873: END IF;
874:
875: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(k);
876: l_qte_line_dtl_rec.operation_code := 'CREATE';
877: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
878: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
879: l_qte_line_dtl_rec.qte_line_index := i;
880: l_qte_line_dtl_rec.service_ref_qte_line_index := FND_API.G_MISS_NUM;
881: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;

Line 878: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;

874:
875: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(k);
876: l_qte_line_dtl_rec.operation_code := 'CREATE';
877: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
878: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
879: l_qte_line_dtl_rec.qte_line_index := i;
880: l_qte_line_dtl_rec.service_ref_qte_line_index := FND_API.G_MISS_NUM;
881: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;
882:

Line 880: l_qte_line_dtl_rec.service_ref_qte_line_index := FND_API.G_MISS_NUM;

876: l_qte_line_dtl_rec.operation_code := 'CREATE';
877: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
878: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
879: l_qte_line_dtl_rec.qte_line_index := i;
880: l_qte_line_dtl_rec.service_ref_qte_line_index := FND_API.G_MISS_NUM;
881: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;
882:
883: l_to_create_qte_line_dtl_tbl(nvl(l_to_create_qte_line_dtl_tbl.count,0)+1) := l_qte_line_dtl_rec;
884: END LOOP;

Line 881: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;

877: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
878: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
879: l_qte_line_dtl_rec.qte_line_index := i;
880: l_qte_line_dtl_rec.service_ref_qte_line_index := FND_API.G_MISS_NUM;
881: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;
882:
883: l_to_create_qte_line_dtl_tbl(nvl(l_to_create_qte_line_dtl_tbl.count,0)+1) := l_qte_line_dtl_rec;
884: END LOOP;
885:

Line 899: l_payment_rec.payment_id := FND_API.G_MISS_NUM;

895: END IF;
896:
897: l_payment_rec := l_payment_tbl(k);
898: l_payment_rec.operation_code := 'CREATE';
899: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
902: l_payment_rec.qte_line_index := i;
903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;

Line 900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;

896:
897: l_payment_rec := l_payment_tbl(k);
898: l_payment_rec.operation_code := 'CREATE';
899: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
902: l_payment_rec.qte_line_index := i;
903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
904: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;

Line 901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;

897: l_payment_rec := l_payment_tbl(k);
898: l_payment_rec.operation_code := 'CREATE';
899: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
902: l_payment_rec.qte_line_index := i;
903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
904: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
905:

Line 903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;

899: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
902: l_payment_rec.qte_line_index := i;
903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
904: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
905:
906: l_to_create_payment_tbl(nvl(l_to_create_payment_tbl.count,0)+1) := l_payment_rec;
907:

Line 904: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;

900: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
901: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
902: l_payment_rec.qte_line_index := i;
903: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
904: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
905:
906: l_to_create_payment_tbl(nvl(l_to_create_payment_tbl.count,0)+1) := l_payment_rec;
907:
908: END LOOP; */

Line 924: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;

920: END IF;
921:
922: l_sales_credit_rec := l_sales_credit_tbl(k);
923: l_sales_credit_rec.operation_code := 'CREATE';
924: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;
925: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;
926: l_sales_credit_rec.qte_line_index := i;
927:
928: l_to_create_sales_credit_tbl(nvl(l_to_create_sales_credit_tbl.count,0)+1) := l_sales_credit_rec;

Line 925: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;

921:
922: l_sales_credit_rec := l_sales_credit_tbl(k);
923: l_sales_credit_rec.operation_code := 'CREATE';
924: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;
925: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;
926: l_sales_credit_rec.qte_line_index := i;
927:
928: l_to_create_sales_credit_tbl(nvl(l_to_create_sales_credit_tbl.count,0)+1) := l_sales_credit_rec;
929: END LOOP;

Line 945: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;

941: END IF;
942:
943: l_price_attr_rec := l_price_attr_tbl(k);
944: l_price_attr_rec.operation_code := 'CREATE';
945: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;
946: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;
947: l_price_attr_rec.qte_line_index := i;
948:
949: l_to_create_price_attr_tbl(nvl(l_to_create_price_attr_tbl.count,0)+1) := l_price_attr_rec;

Line 946: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;

942:
943: l_price_attr_rec := l_price_attr_tbl(k);
944: l_price_attr_rec.operation_code := 'CREATE';
945: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;
946: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;
947: l_price_attr_rec.qte_line_index := i;
948:
949: l_to_create_price_attr_tbl(nvl(l_to_create_price_attr_tbl.count,0)+1) := l_price_attr_rec;
950:

Line 976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;

972: aso_debug_pub.add('Do_Split_Line: l_search_index(' || l_price_adj_rec.price_adjustment_id || ')' || l_search_index(l_price_adj_rec.price_adjustment_id));
973: END IF;
974:
975: l_price_adj_rec.operation_code := 'CREATE';
976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
980: l_price_adj_rec.qte_line_index := i;

Line 977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;

973: END IF;
974:
975: l_price_adj_rec.operation_code := 'CREATE';
976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
980: l_price_adj_rec.qte_line_index := i;
981: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;

Line 978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;

974:
975: l_price_adj_rec.operation_code := 'CREATE';
976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
980: l_price_adj_rec.qte_line_index := i;
981: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
982:

Line 979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;

975: l_price_adj_rec.operation_code := 'CREATE';
976: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
980: l_price_adj_rec.qte_line_index := i;
981: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
982:
983: l_to_create_price_adj_tbl(nvl(l_to_create_price_adj_tbl.count,0)+1) := l_price_adj_rec;

Line 981: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;

977: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
978: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
979: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
980: l_price_adj_rec.qte_line_index := i;
981: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
982:
983: l_to_create_price_adj_tbl(nvl(l_to_create_price_adj_tbl.count,0)+1) := l_price_adj_rec;
984:
985:

Line 1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;

1005: aso_debug_pub.add('l_price_adj_rltship_rec.rltd_price_adj_index :'||l_price_adj_rltship_rec.rltd_price_adj_index, 1, 'N');
1006: END IF;
1007:
1008: l_price_adj_rltship_rec.operation_code := 'CREATE';
1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;

Line 1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;

1006: END IF;
1007:
1008: l_price_adj_rltship_rec.operation_code := 'CREATE';
1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;

Line 1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;

1007:
1008: l_price_adj_rltship_rec.operation_code := 'CREATE';
1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1015: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;

Line 1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;

1009: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1015: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1016:
1017: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;

Line 1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;

1010: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1015: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1016:
1017: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;
1018:

Line 1015: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;

1011: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1012: l_price_adj_rltship_rec.qte_line_index := i;
1013: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1014: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1015: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1016:
1017: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;
1018:
1019: END IF;

Line 1039: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;

1035: l_price_adj_attr_rec.price_adj_index := l_search_index(l_price_adj_attr_rec.price_adjustment_id);
1036: END IF;
1037:
1038: l_price_adj_attr_rec.operation_code := 'CREATE';
1039: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1040: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1041: l_price_adj_attr_rec.qte_line_index := i;
1042: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1043:

Line 1040: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;

1036: END IF;
1037:
1038: l_price_adj_attr_rec.operation_code := 'CREATE';
1039: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1040: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1041: l_price_adj_attr_rec.qte_line_index := i;
1042: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1043:
1044: l_create_price_adj_attr_tbl(nvl(l_create_price_adj_attr_tbl.count,0)+1) := l_price_adj_attr_rec;

Line 1042: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;

1038: l_price_adj_attr_rec.operation_code := 'CREATE';
1039: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1040: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1041: l_price_adj_attr_rec.qte_line_index := i;
1042: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1043:
1044: l_create_price_adj_attr_tbl(nvl(l_create_price_adj_attr_tbl.count,0)+1) := l_price_adj_attr_rec;
1045:
1046: END LOOP;

Line 1067: IF p_serviceable_item = FND_API.G_TRUE THEN

1063: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1064: aso_debug_pub.add('Do_Split_Line: p_serviceable_item: '||p_serviceable_item, 1, 'N');
1065: END IF;
1066:
1067: IF p_serviceable_item = FND_API.G_TRUE THEN
1068:
1069: FOR row IN get_service_lines(l_qte_line_rec.quote_line_id) LOOP
1070:
1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1094: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;

1090:
1091: l_to_create_quote_line_rec := l_srv_qte_line_rec;
1092: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;
1093: l_to_create_quote_line_rec.operation_code := 'CREATE';
1094: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;
1095: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;
1096:
1097: IF l_srv_line_index <> l_line_count THEN
1098:

Line 1095: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;

1091: l_to_create_quote_line_rec := l_srv_qte_line_rec;
1092: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;
1093: l_to_create_quote_line_rec.operation_code := 'CREATE';
1094: l_to_create_quote_line_rec.quote_line_id := FND_API.G_MISS_NUM;
1095: l_to_create_quote_line_rec.line_number := FND_API.G_MISS_NUM;
1096:
1097: IF l_srv_line_index <> l_line_count THEN
1098:
1099: l_to_create_quote_line_tbl(l_to_create_quote_line_tbl.LAST + 1) := l_to_create_quote_line_rec;

Line 1111: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;

1107: --Populate Service Shipment records
1108:
1109: l_to_create_shipment_rec := l_srv_ln_Shipment_Tbl(1);
1110: l_to_create_shipment_rec.operation_code := 'CREATE';
1111: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;
1112: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;
1113: l_to_create_shipment_rec.qte_line_index := l_srv_line_index;
1114: l_to_create_shipment_rec.quantity := p_qte_line_tbl(i).quantity;
1115:

Line 1112: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;

1108:
1109: l_to_create_shipment_rec := l_srv_ln_Shipment_Tbl(1);
1110: l_to_create_shipment_rec.operation_code := 'CREATE';
1111: l_to_create_shipment_rec.shipment_id := FND_API.G_MISS_NUM;
1112: l_to_create_shipment_rec.quote_line_id := FND_API.G_MISS_NUM;
1113: l_to_create_shipment_rec.qte_line_index := l_srv_line_index;
1114: l_to_create_shipment_rec.quantity := p_qte_line_tbl(i).quantity;
1115:
1116: l_to_create_shipment_tbl(nvl(l_to_create_shipment_tbl.count,0)+1) := l_to_create_shipment_rec;

Line 1130: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;

1126: END IF;
1127:
1128: l_qte_line_dtl_rec := l_srv_qte_line_dtl_tbl(k);
1129: l_qte_line_dtl_rec.operation_code := 'CREATE';
1130: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
1131: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
1132: l_qte_line_dtl_rec.qte_line_index := l_srv_line_index;
1133: l_qte_line_dtl_rec.service_ref_qte_line_index := i;
1134: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;

Line 1131: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;

1127:
1128: l_qte_line_dtl_rec := l_srv_qte_line_dtl_tbl(k);
1129: l_qte_line_dtl_rec.operation_code := 'CREATE';
1130: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
1131: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
1132: l_qte_line_dtl_rec.qte_line_index := l_srv_line_index;
1133: l_qte_line_dtl_rec.service_ref_qte_line_index := i;
1134: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;
1135:

Line 1134: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;

1130: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
1131: l_qte_line_dtl_rec.quote_line_id := FND_API.G_MISS_NUM;
1132: l_qte_line_dtl_rec.qte_line_index := l_srv_line_index;
1133: l_qte_line_dtl_rec.service_ref_qte_line_index := i;
1134: l_qte_line_dtl_rec.service_ref_line_id := FND_API.G_MISS_NUM;
1135:
1136: l_to_create_qte_line_dtl_tbl(nvl(l_to_create_qte_line_dtl_tbl.count,0)+1) := l_qte_line_dtl_rec;
1137: END LOOP;
1138:

Line 1151: l_payment_rec.payment_id := FND_API.G_MISS_NUM;

1147: END IF;
1148:
1149: l_payment_rec := l_srv_payment_tbl(k);
1150: l_payment_rec.operation_code := 'CREATE';
1151: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1154: l_payment_rec.qte_line_index := l_srv_line_index;
1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;

Line 1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;

1148:
1149: l_payment_rec := l_srv_payment_tbl(k);
1150: l_payment_rec.operation_code := 'CREATE';
1151: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1154: l_payment_rec.qte_line_index := l_srv_line_index;
1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1156: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;

Line 1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;

1149: l_payment_rec := l_srv_payment_tbl(k);
1150: l_payment_rec.operation_code := 'CREATE';
1151: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1154: l_payment_rec.qte_line_index := l_srv_line_index;
1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1156: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1157:

Line 1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;

1151: l_payment_rec.payment_id := FND_API.G_MISS_NUM;
1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1154: l_payment_rec.qte_line_index := l_srv_line_index;
1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1156: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1157:
1158: l_to_create_payment_tbl(nvl(l_to_create_payment_tbl.count,0)+1) := l_payment_rec;
1159:

Line 1156: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;

1152: l_payment_rec.quote_line_id := FND_API.G_MISS_NUM;
1153: l_payment_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1154: l_payment_rec.qte_line_index := l_srv_line_index;
1155: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1156: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1157:
1158: l_to_create_payment_tbl(nvl(l_to_create_payment_tbl.count,0)+1) := l_payment_rec;
1159:
1160: END LOOP; */

Line 1175: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;

1171: END IF;
1172:
1173: l_sales_credit_rec := l_srv_sales_credit_tbl(k);
1174: l_sales_credit_rec.operation_code := 'CREATE';
1175: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;
1176: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;
1177: l_sales_credit_rec.qte_line_index := l_srv_line_index;
1178:
1179: l_to_create_sales_credit_tbl(nvl(l_to_create_sales_credit_tbl.count,0)+1) := l_sales_credit_rec;

Line 1176: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;

1172:
1173: l_sales_credit_rec := l_srv_sales_credit_tbl(k);
1174: l_sales_credit_rec.operation_code := 'CREATE';
1175: l_sales_credit_rec.sales_credit_id := FND_API.G_MISS_NUM;
1176: l_sales_credit_rec.quote_line_id := FND_API.G_MISS_NUM;
1177: l_sales_credit_rec.qte_line_index := l_srv_line_index;
1178:
1179: l_to_create_sales_credit_tbl(nvl(l_to_create_sales_credit_tbl.count,0)+1) := l_sales_credit_rec;
1180: END LOOP;

Line 1195: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;

1191: END IF;
1192:
1193: l_price_attr_rec := l_srv_price_attr_tbl(k);
1194: l_price_attr_rec.operation_code := 'CREATE';
1195: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;
1196: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;
1197: l_price_attr_rec.qte_line_index := l_srv_line_index;
1198:
1199: l_to_create_price_attr_tbl(nvl(l_to_create_price_attr_tbl.count,0)+1) := l_price_attr_rec;

Line 1196: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;

1192:
1193: l_price_attr_rec := l_srv_price_attr_tbl(k);
1194: l_price_attr_rec.operation_code := 'CREATE';
1195: l_price_attr_rec.price_attribute_id := FND_API.G_MISS_NUM;
1196: l_price_attr_rec.quote_line_id := FND_API.G_MISS_NUM;
1197: l_price_attr_rec.qte_line_index := l_srv_line_index;
1198:
1199: l_to_create_price_attr_tbl(nvl(l_to_create_price_attr_tbl.count,0)+1) := l_price_attr_rec;
1200: END LOOP;

Line 1217: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;

1213:
1214: l_search_index(l_price_adj_rec.price_adjustment_id) := k;
1215:
1216: l_price_adj_rec.operation_code := 'CREATE';
1217: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1221: l_price_adj_rec.qte_line_index := l_srv_line_index;

Line 1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;

1214: l_search_index(l_price_adj_rec.price_adjustment_id) := k;
1215:
1216: l_price_adj_rec.operation_code := 'CREATE';
1217: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1221: l_price_adj_rec.qte_line_index := l_srv_line_index;
1222: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;

Line 1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;

1215:
1216: l_price_adj_rec.operation_code := 'CREATE';
1217: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1221: l_price_adj_rec.qte_line_index := l_srv_line_index;
1222: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
1223:

Line 1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;

1216: l_price_adj_rec.operation_code := 'CREATE';
1217: l_price_adj_rec.price_adjustment_id := FND_API.G_MISS_NUM;
1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1221: l_price_adj_rec.qte_line_index := l_srv_line_index;
1222: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
1223:
1224: l_to_create_price_adj_tbl(nvl(l_to_create_price_adj_tbl.count,0)+1) := l_price_adj_rec;

Line 1222: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;

1218: l_price_adj_rec.creation_date := FND_API.G_MISS_DATE;
1219: l_price_adj_rec.quote_line_id := FND_API.G_MISS_NUM;
1220: l_price_adj_rec.quote_shipment_id := FND_API.G_MISS_NUM;
1221: l_price_adj_rec.qte_line_index := l_srv_line_index;
1222: l_price_adj_rec.shipment_index := FND_API.G_MISS_NUM;
1223:
1224: l_to_create_price_adj_tbl(nvl(l_to_create_price_adj_tbl.count,0)+1) := l_price_adj_rec;
1225:
1226: END LOOP;

Line 1246: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;

1242: l_price_adj_rltship_rec.rltd_price_adj_index := l_search_index(l_price_adj_rltship_rec.rltd_price_adj_id);
1243: END IF;
1244:
1245: l_price_adj_rltship_rec.operation_code := 'CREATE';
1246: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;

Line 1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;

1243: END IF;
1244:
1245: l_price_adj_rltship_rec.operation_code := 'CREATE';
1246: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;

Line 1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;

1244:
1245: l_price_adj_rltship_rec.operation_code := 'CREATE';
1246: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1252: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;

Line 1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;

1246: l_price_adj_rltship_rec.adj_relationship_id := fnd_api.g_miss_num;
1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1252: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1253:
1254: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;

Line 1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;

1247: l_price_adj_rltship_rec.creation_date := fnd_api.g_miss_date;
1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1252: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1253:
1254: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;
1255:

Line 1252: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;

1248: l_price_adj_rltship_rec.quote_line_id := fnd_api.g_miss_num;
1249: l_price_adj_rltship_rec.qte_line_index := l_srv_line_index;
1250: l_price_adj_rltship_rec.quote_shipment_id := fnd_api.g_miss_num;
1251: l_price_adj_rltship_rec.price_adjustment_id := fnd_api.g_miss_num;
1252: l_price_adj_rltship_rec.rltd_price_adj_id := fnd_api.g_miss_num;
1253:
1254: l_create_price_adj_rltn_tbl(nvl(l_create_price_adj_rltn_tbl.count,0)+1) := l_price_adj_rltship_rec;
1255:
1256: END LOOP;

Line 1272: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;

1268: l_price_adj_attr_rec.price_adj_index := l_search_index(l_price_adj_attr_rec.price_adjustment_id);
1269: END IF;
1270:
1271: l_price_adj_attr_rec.operation_code := 'CREATE';
1272: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1273: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1274: l_price_adj_attr_rec.qte_line_index := l_srv_line_index;
1275: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1276:

Line 1273: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;

1269: END IF;
1270:
1271: l_price_adj_attr_rec.operation_code := 'CREATE';
1272: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1273: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1274: l_price_adj_attr_rec.qte_line_index := l_srv_line_index;
1275: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1276:
1277: l_create_price_adj_attr_tbl(nvl(l_create_price_adj_attr_tbl.count,0)+1) := l_price_adj_attr_rec;

Line 1275: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;

1271: l_price_adj_attr_rec.operation_code := 'CREATE';
1272: l_price_adj_attr_rec.price_adj_attrib_id := fnd_api.g_miss_num;
1273: l_price_adj_attr_rec.creation_date := fnd_api.g_miss_date;
1274: l_price_adj_attr_rec.qte_line_index := l_srv_line_index;
1275: l_price_adj_attr_rec.price_adjustment_id := fnd_api.g_miss_num;
1276:
1277: l_create_price_adj_attr_tbl(nvl(l_create_price_adj_attr_tbl.count,0)+1) := l_price_adj_attr_rec;
1278:
1279: END LOOP;

Line 1311: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

1307:
1308: -- set the defaulting fwk off so that no new records are created by defaulting
1309: l_control_rec := p_control_rec;
1310:
1311: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
1312: l_control_rec.DEFAULTING_FWK_FLAG := 'N';
1313:
1314:
1315: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1321: P_Init_Msg_List => FND_API.G_FALSE,

1317: END IF;
1318:
1319: ASO_QUOTE_PUB.Update_quote(
1320: P_Api_Version_Number => 1.0,
1321: P_Init_Msg_List => FND_API.G_FALSE,
1322: P_Commit => P_Commit,
1323: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
1324: P_Control_Rec => l_control_rec,
1325: P_Qte_Header_Rec => p_qte_header_rec,

Line 1323: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

1319: ASO_QUOTE_PUB.Update_quote(
1320: P_Api_Version_Number => 1.0,
1321: P_Init_Msg_List => FND_API.G_FALSE,
1322: P_Commit => P_Commit,
1323: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
1324: P_Control_Rec => l_control_rec,
1325: P_Qte_Header_Rec => p_qte_header_rec,
1326: P_hd_Price_Attributes_Tbl => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
1327: P_hd_Payment_Tbl => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,

Line 1381: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1377: aso_debug_pub.add('Do_Split_Line: After call to Update Quote');
1378: aso_debug_pub.add('Do_Split_Line: x_Return_Status :'||x_Return_Status, 1, 'N');
1379: END IF;
1380:
1381: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1382:
1383: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1384: aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');
1385: END IF;

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

1383: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1384: aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');
1385: END IF;
1386:
1387: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1388:
1389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1390: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
1391: FND_MSG_PUB.ADD;

Line 1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1390: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
1391: FND_MSG_PUB.ADD;
1392: END IF;
1393:
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395:
1396: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1397:
1398: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1396: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1392: END IF;
1393:
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395:
1396: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1397:
1398: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1399: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
1400: FND_MSG_PUB.ADD;

Line 1403: RAISE FND_API.G_EXC_ERROR;

1399: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
1400: FND_MSG_PUB.ADD;
1401: END IF;
1402:
1403: RAISE FND_API.G_EXC_ERROR;
1404:
1405: END IF;
1406:
1407: END IF;

Line 1448: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;

1444: l_payment_rec := l_payment_tbl(1);
1445: l_payment_rec.payment_id := null;
1446: l_payment_rec.quote_header_id := l_qte_line_rec.quote_header_id;
1447: l_payment_rec.quote_line_id := lx_qte_line_tbl(i).quote_line_id;
1448: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1449: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1450:
1451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1452: aso_debug_pub.add('Do_Split_Line: Before call to copy_payment_row ', 1, 'Y');

Line 1449: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;

1445: l_payment_rec.payment_id := null;
1446: l_payment_rec.quote_header_id := l_qte_line_rec.quote_header_id;
1447: l_payment_rec.quote_line_id := lx_qte_line_tbl(i).quote_line_id;
1448: l_payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
1449: l_payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
1450:
1451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1452: aso_debug_pub.add('Do_Split_Line: Before call to copy_payment_row ', 1, 'Y');
1453: END IF;

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

1459:
1460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1461: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');
1462: END IF;
1463: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1461: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');
1462: END IF;
1463: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;

Line 1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1461: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||x_return_status, 1, 'Y');
1462: END IF;
1463: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;

Line 1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1462: END IF;
1463: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: End if;

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

1463: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: End if;
1471:

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: End if;
1471:
1472: -- End Copy payment record

Line 1477: lx_Qte_Line_Tbl(i).pricing_line_type_indicator = fnd_api.g_miss_char) THEN

1473: -- END If;
1474:
1475: IF l_qte_line_rec.quote_line_id <> lx_Qte_Line_Tbl(i).quote_line_id
1476: and (lx_Qte_Line_Tbl(i).pricing_line_type_indicator is null or
1477: lx_Qte_Line_Tbl(i).pricing_line_type_indicator = fnd_api.g_miss_char) THEN
1478:
1479: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1480: aso_debug_pub.add('Do_Split_Line: Before call to Copy_Attachments');
1481: END IF;

Line 1485: p_init_msg_list => FND_API.G_FALSE,

1481: END IF;
1482:
1483: ASO_ATTACHMENT_INT.Copy_Attachments(
1484: p_api_version => 1.0,
1485: p_init_msg_list => FND_API.G_FALSE,
1486: p_commit => FND_API.G_FALSE,
1487: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
1488: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
1489: p_old_object_id => l_map_qte_line_tbl(i).quote_line_id,

Line 1486: p_commit => FND_API.G_FALSE,

1482:
1483: ASO_ATTACHMENT_INT.Copy_Attachments(
1484: p_api_version => 1.0,
1485: p_init_msg_list => FND_API.G_FALSE,
1486: p_commit => FND_API.G_FALSE,
1487: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
1488: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
1489: p_old_object_id => l_map_qte_line_tbl(i).quote_line_id,
1490: p_new_object_id => lx_qte_line_tbl(i).quote_line_id,

Line 1501: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1497: aso_debug_pub.add('Do_Split_Line: After call to Copy_Attachments');
1498: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1499: END IF;
1500:
1501: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1502:
1503: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1504: aso_debug_pub.add('Do_Split_Line: Error in Copy_Attachments');
1505: END IF;

Line 1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1503: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1504: aso_debug_pub.add('Do_Split_Line: Error in Copy_Attachments');
1505: END IF;
1506:
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508:
1509: RAISE FND_API.G_EXC_ERROR;
1510:
1511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: END IF;
1506:
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508:
1509: RAISE FND_API.G_EXC_ERROR;
1510:
1511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1512:
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508:
1509: RAISE FND_API.G_EXC_ERROR;
1510:
1511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1512:
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514:
1515: END IF;

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1509: RAISE FND_API.G_EXC_ERROR;
1510:
1511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1512:
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514:
1515: END IF;
1516:
1517: END IF;

Line 1533: P_Init_Msg_List => FND_API.G_FALSE,

1529:
1530: ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
1531: (
1532: P_Api_Version_Number => 1.0,
1533: P_Init_Msg_List => FND_API.G_FALSE,
1534: P_Commit => P_Commit,
1535: P_OLD_QUOTE_LINE_ID => l_map_qte_line_tbl(i).quote_line_id,
1536: P_NEW_QUOTE_LINE_ID => lx_qte_line_tbl(i).quote_line_id,
1537: X_Return_Status => x_return_status,

Line 1546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1542: aso_debug_pub.add('Do_Split_Line: After call to Copy_Line_Level_Sales_Supp');
1543: aso_debug_pub.add('Do_Split_Line: x_return_status: '|| x_return_status);
1544: END IF;
1545:
1546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1547:
1548: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1549: aso_debug_pub.add('Do_Split_Line: Error in Copy_Line_Level_Sales_Supp');
1550: END IF;

Line 1552: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1548: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1549: aso_debug_pub.add('Do_Split_Line: Error in Copy_Line_Level_Sales_Supp');
1550: END IF;
1551:
1552: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1553:
1554: RAISE FND_API.G_EXC_ERROR;
1555:
1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1554: RAISE FND_API.G_EXC_ERROR;

1550: END IF;
1551:
1552: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1553:
1554: RAISE FND_API.G_EXC_ERROR;
1555:
1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1557:
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1552: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1553:
1554: RAISE FND_API.G_EXC_ERROR;
1555:
1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1557:
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559:
1560: END IF;

Line 1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1554: RAISE FND_API.G_EXC_ERROR;
1555:
1556: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1557:
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559:
1560: END IF;
1561:
1562: END IF;

Line 1578: p_update_header_flag => FND_API.G_FALSE,

1574:
1575: ASO_QUOTE_LINES_PVT.Delete_Quote_Line (
1576: P_Api_Version_Number => 1.0,
1577: p_control_rec => p_control_rec,
1578: p_update_header_flag => FND_API.G_FALSE,
1579: P_qte_Line_Rec => l_qte_line_rec,
1580: X_Return_Status => x_return_status,
1581: X_Msg_Count => x_msg_count,
1582: X_Msg_Data => x_msg_data);

Line 1584: If x_return_status = FND_API.G_RET_STS_ERROR Then

1580: X_Return_Status => x_return_status,
1581: X_Msg_Count => x_msg_count,
1582: X_Msg_Data => x_msg_data);
1583:
1584: If x_return_status = FND_API.G_RET_STS_ERROR Then
1585: Raise FND_API.G_EXC_ERROR;
1586: ElsIf x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1587: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1588: End If;

Line 1585: Raise FND_API.G_EXC_ERROR;

1581: X_Msg_Count => x_msg_count,
1582: X_Msg_Data => x_msg_data);
1583:
1584: If x_return_status = FND_API.G_RET_STS_ERROR Then
1585: Raise FND_API.G_EXC_ERROR;
1586: ElsIf x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1587: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1588: End If;
1589:

Line 1586: ElsIf x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

1582: X_Msg_Data => x_msg_data);
1583:
1584: If x_return_status = FND_API.G_RET_STS_ERROR Then
1585: Raise FND_API.G_EXC_ERROR;
1586: ElsIf x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1587: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1588: End If;
1589:
1590: End If;

Line 1587: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1583:
1584: If x_return_status = FND_API.G_RET_STS_ERROR Then
1585: Raise FND_API.G_EXC_ERROR;
1586: ElsIf x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1587: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1588: End If;
1589:
1590: End If;
1591:

Line 1609: WHEN FND_API.G_EXC_ERROR THEN

1605:
1606:
1607: EXCEPTION
1608:
1609: WHEN FND_API.G_EXC_ERROR THEN
1610:
1611: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1612: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1613: END IF;

Line 1612: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');

1608:
1609: WHEN FND_API.G_EXC_ERROR THEN
1610:
1611: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1612: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1613: END IF;
1614:
1615: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1616: P_PKG_NAME => G_PKG_NAME,

Line 1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1620: X_MSG_DATA => X_MSG_DATA,
1621: X_RETURN_STATUS => X_RETURN_STATUS
1622: );
1623:
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625:
1626: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1627: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1628: END IF;

Line 1627: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');

1623:
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625:
1626: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1627: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1628: END IF;
1629:
1630: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1631: P_PKG_NAME => G_PKG_NAME,