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_SUBMIT_QUOTE_PVT dependencies on FND_API

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

24:
25: PROCEDURE Submit_Quote
26: (
27: P_Api_Version_Number IN NUMBER,
28: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,

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

25: PROCEDURE Submit_Quote
26: (
27: P_Api_Version_Number IN NUMBER,
28: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

26: (
27: P_Api_Version_Number IN NUMBER,
28: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
34: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,

Line 198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

194: -- Standard Start of API savepoint
195: SAVEPOINT SUBMIT_QUOTE_PVT;
196:
197: -- Standard call to check for call compatibility.
198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME) THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME) THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 206: IF FND_API.to_Boolean( p_init_msg_list ) THEN

202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list ) THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209:
210: -- Debug Message

Line 229: l_return_status := FND_API.G_RET_STS_SUCCESS;

225: ASO_VALIDATE_PVT.VALIDATE_OU(P_Qte_Header_Rec);
226:
227:
228: -- Initialize API return status to success
229: l_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: --
232: -- API body
233: --

Line 243: RAISE FND_API.G_EXC_ERROR;

239: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
240: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
241: FND_MSG_PUB.ADD;
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: -- ******************************************************************
246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 262: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN

258: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');
259: END IF;
260:
261: IF (C_Get_Update_Date%NOTFOUND) OR
262: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
265: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
266: FND_MSG_PUB.ADD;

Line 269: RAISE FND_API.G_EXC_ERROR;

265: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;
268: CLOSE C_Get_Update_Date;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: CLOSE C_Get_Update_Date;
273:

Line 275: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND

271:
272: CLOSE C_Get_Update_Date;
273:
274: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
275: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
276: (l_last_upd_date <> p_qte_header_rec.last_update_date) Then
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
279: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

Line 282: RAISE FND_API.G_EXC_ERROR;

278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
279: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
280: FND_MSG_PUB.ADD;
281: END IF;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: -- vtariker - Check Whether record has been changed
285:
286: -- 2692785

Line 291: IF (lx_status = FND_API.G_TRUE) THEN

287: ASO_CONC_REQ_INT.Lock_Exists(
288: p_quote_header_id => p_qte_header_rec.quote_header_id,
289: x_status => lx_status);
290:
291: IF (lx_status = FND_API.G_TRUE) THEN
292: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
294: FND_MSG_PUB.ADD;
295: END IF;

Line 296: RAISE FND_API.G_EXC_ERROR;

292: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
294: FND_MSG_PUB.ADD;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298: -- 2692785
299:
300:

Line 301: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

297: END IF;
298: -- 2692785
299:
300:
301: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
302: OPEN C_Validate_Quote (p_qte_header_rec.quote_header_id);
303: FETCH C_Validate_Quote into l_val;
304: IF C_Validate_Quote%NOTFOUND THEN
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 312: RAISE FND_API.G_EXC_ERROR;

308: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
309: FND_MSG_PUB.ADD;
310: END IF;
311: CLOSE C_Validate_Quote;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: CLOSE C_Validate_Quote;
315: END IF;
316:

Line 320: p_init_msg_list => fnd_api.g_false,

316:
317: -- vtariker
318: -- assign the missing customer accounts to the quote
319: ASO_CHECK_TCA_PVT.Assign_Customer_Accounts (
320: p_init_msg_list => fnd_api.g_false,
321: p_qte_header_id => p_qte_header_rec.quote_header_id,
322: p_calling_api_flag => 2,
323: x_return_status => x_return_status,
324: x_msg_count => x_msg_count,

Line 328: IF x_return_status <> fnd_api.g_ret_sts_success THEN

324: x_msg_count => x_msg_count,
325: x_msg_data => x_msg_data
326: );
327:
328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
329: RAISE fnd_api.g_exc_error;
330: END IF;
331: -- vtariker
332:

Line 329: RAISE fnd_api.g_exc_error;

325: x_msg_data => x_msg_data
326: );
327:
328: IF x_return_status <> fnd_api.g_ret_sts_success THEN
329: RAISE fnd_api.g_exc_error;
330: END IF;
331: -- vtariker
332:
333: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);

Line 336: IF p_qte_header_rec.Customer_Name_And_Title <> FND_API.G_MISS_CHAR

332:
333: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
334:
335: -- hyang new okc
336: IF p_qte_header_rec.Customer_Name_And_Title <> FND_API.G_MISS_CHAR
337: THEN
338: l_qte_header_rec.Customer_Name_And_Title := p_qte_header_rec.Customer_Name_And_Title;
339: END IF;
340:

Line 341: IF p_qte_header_rec.Customer_Signature_Date <> FND_API.G_MISS_DATE

337: THEN
338: l_qte_header_rec.Customer_Name_And_Title := p_qte_header_rec.Customer_Name_And_Title;
339: END IF;
340:
341: IF p_qte_header_rec.Customer_Signature_Date <> FND_API.G_MISS_DATE
342: THEN
343: l_qte_header_rec.Customer_Signature_Date := p_qte_header_rec.Customer_Signature_Date;
344: END IF;
345:

Line 346: IF p_qte_header_rec.Supplier_Name_And_Title <> FND_API.G_MISS_CHAR

342: THEN
343: l_qte_header_rec.Customer_Signature_Date := p_qte_header_rec.Customer_Signature_Date;
344: END IF;
345:
346: IF p_qte_header_rec.Supplier_Name_And_Title <> FND_API.G_MISS_CHAR
347: THEN
348: l_qte_header_rec.Supplier_Name_And_Title := p_qte_header_rec.Supplier_Name_And_Title;
349: END IF;
350:

Line 351: IF p_qte_header_rec.Supplier_Signature_Date <> FND_API.G_MISS_DATE

347: THEN
348: l_qte_header_rec.Supplier_Name_And_Title := p_qte_header_rec.Supplier_Name_And_Title;
349: END IF;
350:
351: IF p_qte_header_rec.Supplier_Signature_Date <> FND_API.G_MISS_DATE
352: THEN
353: l_qte_header_rec.Supplier_Signature_Date := p_qte_header_rec.Supplier_Signature_Date;
354: END IF;
355:

Line 366: p_init_msg_list => FND_API.G_FALSE,

362:
363: -- rahsan 2269789
364:
365: ASO_VALIDATE_PVT.Validate_Quote_Exp_date(
366: p_init_msg_list => FND_API.G_FALSE,
367: p_quote_expiration_date => l_qte_header_rec.quote_expiration_date,
368: x_return_status => x_return_status,
369: x_msg_count => x_msg_count,
370: x_msg_data => x_msg_data

Line 372: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

368: x_return_status => x_return_status,
369: x_msg_count => x_msg_count,
370: x_msg_data => x_msg_data
371: );
372: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
374: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
375: FND_MSG_PUB.ADD;
376: END IF;

Line 377: RAISE FND_API.G_EXC_ERROR;

373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
374: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
375: FND_MSG_PUB.ADD;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
380: -- end rahsan 2269789
381:

Line 385: l_qte_header_rec.contract_id := FND_API.G_MISS_NUM;

381:
382:
383: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
384: IF l_qte_header_rec.contract_id is null then
385: l_qte_header_rec.contract_id := FND_API.G_MISS_NUM;
386: end if;
387: IF l_qte_header_rec.quote_category_code is null then
388: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
389: end if;

Line 388: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;

384: IF l_qte_header_rec.contract_id is null then
385: l_qte_header_rec.contract_id := FND_API.G_MISS_NUM;
386: end if;
387: IF l_qte_header_rec.quote_category_code is null then
388: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
389: end if;
390: IF l_qte_header_rec.accounting_rule_id is null then
391: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
392: end if;

Line 391: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;

387: IF l_qte_header_rec.quote_category_code is null then
388: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
389: end if;
390: IF l_qte_header_rec.accounting_rule_id is null then
391: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
392: end if;
393: IF l_qte_header_rec.invoicing_rule_id is null then
394: l_qte_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
395: end if;

Line 394: l_qte_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;

390: IF l_qte_header_rec.accounting_rule_id is null then
391: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
392: end if;
393: IF l_qte_header_rec.invoicing_rule_id is null then
394: l_qte_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
395: end if;
396: end if;
397:
398: -- hyang quote_status

Line 404: p_init_msg_list => FND_API.G_FALSE,

400: FETCH c_qte_status_id INTO l_qte_status_id;
401: CLOSE c_qte_status_id;
402:
403: ASO_VALIDATE_PVT.Validate_Status_Transition(
404: p_init_msg_list => FND_API.G_FALSE,
405: p_source_status_id => l_qte_header_rec.quote_status_id,
406: p_dest_status_id => l_qte_status_id,
407: x_return_status => x_return_status,
408: x_msg_count => x_msg_count,

Line 411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

407: x_return_status => x_return_status,
408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data);
410:
411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
412: IF l_qte_header_rec.quote_status_id = l_qte_status_id then
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
415: FND_MSG_PUB.ADD;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
415: FND_MSG_PUB.ADD;
416: END IF;
417: END IF;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: IF aso_debug_pub.g_debug_flag = 'Y' THEN
422: aso_debug_pub.add('Submit_Q: After validate_status_transition: ORDER SUBMITEED ', 1, 'N');

Line 472: l_hd_payment_tbl(i).payment_amount = FND_API.G_MISS_NUM) AND

468: p_qte_line_id => NULL);
469:
470: FOR i in 1..l_hd_payment_tbl.count LOOP
471: IF (l_hd_payment_tbl(i).payment_amount is NULL OR
472: l_hd_payment_tbl(i).payment_amount = FND_API.G_MISS_NUM) AND
473: (l_hd_payment_tbl(i).payment_type_code IS NOT NULL AND
474: l_hd_payment_tbl(i).payment_type_code <> FND_API.G_MISS_CHAR) THEN
475: l_hd_payment_tbl(i).payment_amount :=
476: l_qte_header_rec.total_quote_price;

Line 474: l_hd_payment_tbl(i).payment_type_code <> FND_API.G_MISS_CHAR) THEN

470: FOR i in 1..l_hd_payment_tbl.count LOOP
471: IF (l_hd_payment_tbl(i).payment_amount is NULL OR
472: l_hd_payment_tbl(i).payment_amount = FND_API.G_MISS_NUM) AND
473: (l_hd_payment_tbl(i).payment_type_code IS NOT NULL AND
474: l_hd_payment_tbl(i).payment_type_code <> FND_API.G_MISS_CHAR) THEN
475: l_hd_payment_tbl(i).payment_amount :=
476: l_qte_header_rec.total_quote_price;
477: END IF;
478: END LOOP;

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: OPEN C_Get_Config_Flag(l_qte_line_id);
522: FETCH C_Get_Config_Flag INTO l_complete_config, l_valid_config, l_instance_id;
523:
524: IF C_Get_Config_Flag%NOTFOUND THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
528: FND_MSG_PUB.ADD;
529: END IF;

Line 531: RAISE FND_API.G_EXC_ERROR;

527: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
528: FND_MSG_PUB.ADD;
529: END IF;
530: CLOSE C_Get_Config_Flag;
531: RAISE FND_API.G_EXC_ERROR;
532: ELSE
533: IF aso_debug_pub.g_debug_flag = 'Y' THEN
534: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
535: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');

Line 539: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker

535: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
536: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
537: END IF;
538:
539: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
540:
541: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538:
539: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
540:
541: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
544: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
545: FND_MSG_PUB.ADD;
546: END IF;

Line 548: RAISE FND_API.G_EXC_ERROR;

544: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
545: FND_MSG_PUB.ADD;
546: END IF;
547: CLOSE C_Get_Config_Flag;
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550:
551: END IF; -- 2498776 vtariker
552:

Line 561: l_qte_line_tbl(i).line_category_code := FND_API.G_MISS_CHAR;

557: -- 2469621 vtariker
558:
559: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
560: IF l_qte_line_tbl(i).line_category_code is null then
561: l_qte_line_tbl(i).line_category_code := FND_API.G_MISS_CHAR;
562: END IF;
563: IF l_qte_line_tbl(i).invoicing_rule_id is null then
564: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
565: end if;

Line 564: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;

560: IF l_qte_line_tbl(i).line_category_code is null then
561: l_qte_line_tbl(i).line_category_code := FND_API.G_MISS_CHAR;
562: END IF;
563: IF l_qte_line_tbl(i).invoicing_rule_id is null then
564: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
565: end if;
566: IF l_qte_line_tbl(i).accounting_rule_id is null then
567: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
568: end if;

Line 567: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;

563: IF l_qte_line_tbl(i).invoicing_rule_id is null then
564: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
565: end if;
566: IF l_qte_line_tbl(i).accounting_rule_id is null then
567: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
568: end if;
569: END IF;
570:
571: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(

Line 616: l_tmp_payment_tbl(j).payment_term_id := FND_API.G_MISS_NUM;

612: FOR j IN 1..l_tmp_payment_tbl.count LOOP
613: l_tmp_payment_tbl(j).qte_line_index := i;
614: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
615: IF l_tmp_payment_tbl(j).payment_term_id is null then
616: l_tmp_payment_tbl(j).payment_term_id := FND_API.G_MISS_NUM;
617: end if;
618: end if;
619: l_ln_payment_tbl(l_index) := l_tmp_payment_tbl(j);
620: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 683: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN

679: IF aso_debug_pub.g_debug_flag = 'Y' THEN
680: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');
681: END IF;
682:
683: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN
684:
685: IF aso_debug_pub.g_debug_flag = 'Y' THEN
686: aso_debug_pub.add('Submit_Q: Before Authorize_payment p_control_rec.CVV2: '|| p_control_rec.CVV2, 1, 'N');
687: END IF;

Line 708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
707: END IF;
708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 709: RAISE FND_API.G_EXC_ERROR;

705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
707: END IF;
708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;

Line 711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

707: END IF;
708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714: END IF;
715: END IF;

Line 712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714: END IF;
715: END IF;
716: END LOOP;

Line 730: (l_qte_header_rec.resource_id IS NOT NULL AND l_qte_header_rec.resource_id <> FND_API.G_MISS_NUM)) THEN

726: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');
727: END IF;
728:
729: IF l_istore_source <> 'Y' OR (l_istore_source = 'Y' AND
730: (l_qte_header_rec.resource_id IS NOT NULL AND l_qte_header_rec.resource_id <> FND_API.G_MISS_NUM)) THEN
731:
732: IF NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
733:
734: IF (l_sales_team_prof = 'FULL') THEN

Line 738: P_Init_Msg_List => FND_API.G_FALSE,

734: IF (l_sales_team_prof = 'FULL') THEN
735:
736: ASO_SALES_TEAM_PVT.Assign_Sales_Team
737: (
738: P_Init_Msg_List => FND_API.G_FALSE,
739: P_Commit => FND_API.G_FALSE,
740: p_Qte_Header_Rec => l_qte_header_rec,
741: P_Operation => 'SUBMIT',
742: x_Qte_Header_Rec => lx_qte_header_rec,

Line 739: P_Commit => FND_API.G_FALSE,

735:
736: ASO_SALES_TEAM_PVT.Assign_Sales_Team
737: (
738: P_Init_Msg_List => FND_API.G_FALSE,
739: P_Commit => FND_API.G_FALSE,
740: p_Qte_Header_Rec => l_qte_header_rec,
741: P_Operation => 'SUBMIT',
742: x_Qte_Header_Rec => lx_qte_header_rec,
743: x_return_status => x_return_status,

Line 747: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 748: RAISE FND_API.G_EXC_ERROR;

744: x_msg_count => x_msg_count,
745: x_msg_data => x_msg_data
746: );
747: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;

Line 750: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

746: );
747: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: IF (l_sales_cred_prof = 'FULL') THEN

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END IF;
753:
754: IF (l_sales_cred_prof = 'FULL') THEN
755:

Line 761: P_Init_Msg_List => FND_API.G_FALSE,

757:
758: ASO_QUOTE_PUB.Allocate_Sales_Credits
759: (
760: P_Api_Version_Number => 1.0,
761: P_Init_Msg_List => FND_API.G_FALSE,
762: P_Commit => FND_API.G_FALSE,
763: P_Control_Rec => l_Sales_Alloc_Control_Rec,
764: p_Qte_Header_Rec => lx_qte_header_rec,
765: x_Qte_Header_Rec => lx_out_qte_header_rec,

Line 762: P_Commit => FND_API.G_FALSE,

758: ASO_QUOTE_PUB.Allocate_Sales_Credits
759: (
760: P_Api_Version_Number => 1.0,
761: P_Init_Msg_List => FND_API.G_FALSE,
762: P_Commit => FND_API.G_FALSE,
763: P_Control_Rec => l_Sales_Alloc_Control_Rec,
764: p_Qte_Header_Rec => lx_qte_header_rec,
765: x_Qte_Header_Rec => lx_out_qte_header_rec,
766: x_return_status => x_return_status,

Line 771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

767: x_msg_count => x_msg_count,
768: x_msg_data => x_msg_data
769: );
770: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 772: RAISE FND_API.G_EXC_ERROR;

768: x_msg_data => x_msg_data
769: );
770: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;

Line 774: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

770: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: END IF;

Line 775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: END IF;
779:

Line 809: P_Init_Msg_List => FND_API.G_FALSE,

805: END IF;
806:
807: ASO_ORDER_INT.Create_order(
808: P_Api_Version => 1.0,
809: P_Init_Msg_List => FND_API.G_FALSE,
810: p_Control_Rec => l_order_control_rec,
811: P_Commit => FND_API.G_FALSE,
812: p_Qte_Rec => l_Qte_Header_Rec,
813: p_Header_Payment_Tbl => l_Hd_Payment_Tbl,

Line 811: P_Commit => FND_API.G_FALSE,

807: ASO_ORDER_INT.Create_order(
808: P_Api_Version => 1.0,
809: P_Init_Msg_List => FND_API.G_FALSE,
810: p_Control_Rec => l_order_control_rec,
811: P_Commit => FND_API.G_FALSE,
812: p_Qte_Rec => l_Qte_Header_Rec,
813: p_Header_Payment_Tbl => l_Hd_Payment_Tbl,
814: p_Header_Price_Adj_Tbl => l_hd_Price_Adj_Tbl,
815: p_Header_Price_Attributes_Tbl => l_hd_Price_Attr_Tbl,

Line 847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

843: X_Msg_Data => X_Msg_Data);
844: IF aso_debug_pub.g_debug_flag = 'Y' THEN
845: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');
846: END IF;
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
849: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
850: FND_MSG_PUB.ADD;
851: END IF;

Line 852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
849: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
850: FND_MSG_PUB.ADD;
851: END IF;
852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 853: RAISE FND_API.G_EXC_ERROR;

849: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
850: FND_MSG_PUB.ADD;
851: END IF;
852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;

Line 855: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

851: END IF;
852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: END IF;
859:

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: END IF;
859:
860: -- If book flag is set to 'Y' OM returns success even if the order

Line 863: IF x_return_status = FND_API.G_RET_STS_SUCCESS

859:
860: -- If book flag is set to 'Y' OM returns success even if the order
861: -- is not booked. We raise an error in case the order is not booked.
862: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
863: IF x_return_status = FND_API.G_RET_STS_SUCCESS
864: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN
865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
866: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');
867: END IF;

Line 864: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN

860: -- If book flag is set to 'Y' OM returns success even if the order
861: -- is not booked. We raise an error in case the order is not booked.
862: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
863: IF x_return_status = FND_API.G_RET_STS_SUCCESS
864: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN
865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
866: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');
867: END IF;
868: OPEN C_book_flag;

Line 871: RAISE FND_API.G_EXC_ERROR;

867: END IF;
868: OPEN C_book_flag;
869: FETCH C_book_flag into l_book_flag;
870: IF C_book_flag%NOTFOUND THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: IF l_book_flag = 'N' or l_book_flag IS NULL THEN
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;

Line 874: RAISE FND_API.G_EXC_ERROR;

870: IF C_book_flag%NOTFOUND THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: IF l_book_flag = 'N' or l_book_flag IS NULL THEN
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: CLOSE C_book_flag;
877: END IF;
878: **/

Line 885: P_Init_Msg_List => FND_API.G_FALSE,

881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
882: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
883: END IF;
884: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
885: P_Init_Msg_List => FND_API.G_FALSE,
886: P_Commit => FND_API.G_FALSE,
887: P_Order_Line_Tbl => lx_order_line_tbl,
888: X_Return_Status => x_return_status,
889: X_Msg_Count => x_msg_count,

Line 886: P_Commit => FND_API.G_FALSE,

882: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
883: END IF;
884: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
885: P_Init_Msg_List => FND_API.G_FALSE,
886: P_Commit => FND_API.G_FALSE,
887: P_Order_Line_Tbl => lx_order_line_tbl,
888: X_Return_Status => x_return_status,
889: X_Msg_Count => x_msg_count,
890: X_Msg_Data => x_msg_data);

Line 894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

890: X_Msg_Data => x_msg_data);
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
893: END IF;
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 895: RAISE FND_API.G_EXC_ERROR;

891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
893: END IF;
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;

Line 897: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

893: END IF;
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;
900: -- EDU
901:

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;
900: -- EDU
901:
902: -- bug 1749828 hyang

Line 915: P_Init_Msg_List => FND_API.G_FALSE,

911: l_related_obj_rec.RECIPROCAL_FLAG := 'N' ;
912:
913: ASO_RELATED_OBJ_PVT.Create_related_obj(
914: P_Api_Version_Number => 1.0,
915: P_Init_Msg_List => FND_API.G_FALSE,
916: P_Commit => FND_API.G_FALSE,
917: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
918: P_RELATED_OBJ_Rec => l_related_obj_rec,
919: X_RELATED_OBJECT_ID => l_related_obj_id,

Line 916: P_Commit => FND_API.G_FALSE,

912:
913: ASO_RELATED_OBJ_PVT.Create_related_obj(
914: P_Api_Version_Number => 1.0,
915: P_Init_Msg_List => FND_API.G_FALSE,
916: P_Commit => FND_API.G_FALSE,
917: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
918: P_RELATED_OBJ_Rec => l_related_obj_rec,
919: X_RELATED_OBJECT_ID => l_related_obj_id,
920: X_RETURN_STATUS => X_RETURN_STATUS,

Line 917: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

913: ASO_RELATED_OBJ_PVT.Create_related_obj(
914: P_Api_Version_Number => 1.0,
915: P_Init_Msg_List => FND_API.G_FALSE,
916: P_Commit => FND_API.G_FALSE,
917: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
918: P_RELATED_OBJ_Rec => l_related_obj_rec,
919: X_RELATED_OBJECT_ID => l_related_obj_id,
920: X_RETURN_STATUS => X_RETURN_STATUS,
921: X_MSG_COUNT => X_MSG_COUNT ,

Line 928: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

924:
925: IF aso_debug_pub.g_debug_flag = 'Y' THEN
926: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');
927: END IF;
928: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
930: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
931: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
932: FND_MSG_PUB.ADD;

Line 934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

930: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
931: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
932: FND_MSG_PUB.ADD;
933: END IF;
934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 935: RAISE FND_API.G_EXC_ERROR;

931: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
932: FND_MSG_PUB.ADD;
933: END IF;
934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: END IF;

Line 937: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

933: END IF;
934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: END IF;
940: END IF;
941:

Line 938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: END IF;
940: END IF;
941:
942: -- end of bug 1749828 hyang code

Line 978: P_Init_Msg_List => FND_API.G_FALSE,

974: -- update installment details
975: -- hyang 1935614 csi integration
976: ASO_INSTBASE_INT.Update_Inst_Details_ORDER(
977: P_Api_Version_Number => 1.0,
978: P_Init_Msg_List => FND_API.G_FALSE,
979: P_Commit => FND_API.G_FALSE,
980: P_Quote_Line_Shipment_id=> lx_order_line_tbl(i).quote_shipment_line_id,
981: P_Order_Line_Id => lx_order_line_tbl(i).order_line_id,
982: X_Return_Status => x_Return_Status,

Line 979: P_Commit => FND_API.G_FALSE,

975: -- hyang 1935614 csi integration
976: ASO_INSTBASE_INT.Update_Inst_Details_ORDER(
977: P_Api_Version_Number => 1.0,
978: P_Init_Msg_List => FND_API.G_FALSE,
979: P_Commit => FND_API.G_FALSE,
980: P_Quote_Line_Shipment_id=> lx_order_line_tbl(i).quote_shipment_line_id,
981: P_Order_Line_Id => lx_order_line_tbl(i).order_line_id,
982: X_Return_Status => x_Return_Status,
983: X_Msg_Count => X_Msg_Count,

Line 988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

984: X_Msg_Data => X_Msg_Data );
985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');
987: END IF;
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
990: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
991: FND_MSG_PUB.ADD;
992: END IF;

Line 993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
990: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
991: FND_MSG_PUB.ADD;
992: END IF;
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 994: RAISE FND_API.G_EXC_ERROR;

990: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
991: FND_MSG_PUB.ADD;
992: END IF;
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;

Line 996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

992: END IF;
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: END IF;
1000:

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: END IF;
1000:
1001: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);

Line 1006: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN

1002: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1003:
1004: -- transfer reservation
1005: IF l_shipment_rec.reservation_id IS NOT NULL
1006: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1007: ASO_RESERVATION_INT.Transfer_Reservation(
1008: P_Api_Version_Number => 1.0,
1009: P_Init_Msg_List => FND_API.G_FALSE,
1010: P_Commit => FND_API.G_FALSE,

Line 1009: P_Init_Msg_List => FND_API.G_FALSE,

1005: IF l_shipment_rec.reservation_id IS NOT NULL
1006: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1007: ASO_RESERVATION_INT.Transfer_Reservation(
1008: P_Api_Version_Number => 1.0,
1009: P_Init_Msg_List => FND_API.G_FALSE,
1010: P_Commit => FND_API.G_FALSE,
1011: P_header_rec => l_qte_header_rec,
1012: P_line_Rec => l_qte_line_rec,
1013: p_shipment_rec => l_shipment_rec,

Line 1010: P_Commit => FND_API.G_FALSE,

1006: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1007: ASO_RESERVATION_INT.Transfer_Reservation(
1008: P_Api_Version_Number => 1.0,
1009: P_Init_Msg_List => FND_API.G_FALSE,
1010: P_Commit => FND_API.G_FALSE,
1011: P_header_rec => l_qte_header_rec,
1012: P_line_Rec => l_qte_line_rec,
1013: p_shipment_rec => l_shipment_rec,
1014: X_Return_Status => x_Return_Status,

Line 1021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1017: X_new_RESERVATION_ID => l_reservation_id);
1018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1019: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');
1020: END IF;
1021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1023: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1024: FND_MSG_PUB.ADD;
1025: END IF;

Line 1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1023: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;

Line 1029: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032: END IF;
1033: END IF;

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032: END IF;
1033: END IF;
1034: END LOOP; -- lx_order_line_tbl

Line 1044: ,p_init_msg_list => FND_API.G_FALSE --P_Init_Msg_List --1966456

1040: -- lx_return_status := x_return_status -- 1966456
1041: -- copy attachment to order
1042: aso_attachment_int.copy_attachments_to_order
1043: ( p_api_version_number => p_api_version_number
1044: ,p_init_msg_list => FND_API.G_FALSE --P_Init_Msg_List --1966456
1045: ,p_commit => FND_API.G_FALSE
1046: ,p_quote_header_id => p_qte_header_rec.quote_header_id
1047: ,p_order_id => x_order_header_rec.order_header_id
1048: ,p_order_line_tbl => lx_Order_Line_Tbl

Line 1045: ,p_commit => FND_API.G_FALSE

1041: -- copy attachment to order
1042: aso_attachment_int.copy_attachments_to_order
1043: ( p_api_version_number => p_api_version_number
1044: ,p_init_msg_list => FND_API.G_FALSE --P_Init_Msg_List --1966456
1045: ,p_commit => FND_API.G_FALSE
1046: ,p_quote_header_id => p_qte_header_rec.quote_header_id
1047: ,p_order_id => x_order_header_rec.order_header_id
1048: ,p_order_line_tbl => lx_Order_Line_Tbl
1049: ,x_return_status => x_return_status

Line 1056: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1052: );
1053: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1054: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1055: END IF;
1056: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END if;
1059: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1057: RAISE FND_API.G_EXC_ERROR;

1053: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1054: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1055: END IF;
1056: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END if;
1059: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;

Line 1059: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1055: END IF;
1056: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END if;
1059: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: -- x_return_status := lx_return_status; -- 1966456

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1057: RAISE FND_API.G_EXC_ERROR;
1058: END if;
1059: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: -- x_return_status := lx_return_status; -- 1966456
1064:

Line 1078: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1074:
1075: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1076: aso_debug_pub.add('Submit_Q: After JTF_HA_STATE_PKG.GET_CURRENT_STATE x_return_status: '||x_return_status, 1, 'N');
1077: END IF;
1078: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1079:
1080: IF X_Current_State IN (3,4) THEN
1081:
1082: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1095: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1091:
1092: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1093: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');
1094: END IF;
1095: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1096:
1097: UPDATE ASO_QUOTE_HEADERS_ALL
1098: SET Order_Id = x_order_header_rec.order_header_id,
1099: last_update_date = sysdate,

Line 1108: x_return_Status := FND_API.G_RET_STS_ERROR;

1104: END IF;
1105:
1106: END IF;
1107: ELSE
1108: x_return_Status := FND_API.G_RET_STS_ERROR;
1109: RAISE FND_API.G_EXC_ERROR;
1110:
1111: END IF;
1112: -- HA

Line 1109: RAISE FND_API.G_EXC_ERROR;

1105:
1106: END IF;
1107: ELSE
1108: x_return_Status := FND_API.G_RET_STS_ERROR;
1109: RAISE FND_API.G_EXC_ERROR;
1110:
1111: END IF;
1112: -- HA
1113:

Line 1132: IF FND_API.to_Boolean( p_commit ) THEN

1128: );
1129:
1130: -- HA
1131: -- Standard check for p_commit
1132: IF FND_API.to_Boolean( p_commit ) THEN
1133: COMMIT WORK;
1134: END IF;
1135: -- HA
1136:

Line 1139: WHEN FND_API.G_EXC_ERROR THEN

1135: -- HA
1136:
1137: EXCEPTION
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140:
1141: ROLLBACK TO SUBMIT_QUOTE_PVT;
1142:
1143: BEGIN

Line 1144: IF FND_API.To_Boolean( p_commit )

1140:
1141: ROLLBACK TO SUBMIT_QUOTE_PVT;
1142:
1143: BEGIN
1144: IF FND_API.To_Boolean( p_commit )
1145: THEN
1146: COMMIT WORK;
1147: END IF;
1148:

Line 1154: x_return_status := FND_API.G_RET_STS_ERROR ;

1150: WHEN NO_DATA_FOUND THEN
1151: NULL;
1152: END;
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR ;
1155:
1156: FND_MSG_PUB.Count_And_Get
1157: ( p_count => x_msg_count,
1158: p_data => x_msg_data

Line 1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1158: p_data => x_msg_data
1159: );
1160:
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163:
1164: ROLLBACK TO SUBMIT_QUOTE_PVT;
1165:
1166: BEGIN

Line 1167: IF FND_API.To_Boolean( p_commit )

1163:
1164: ROLLBACK TO SUBMIT_QUOTE_PVT;
1165:
1166: BEGIN
1167: IF FND_API.To_Boolean( p_commit )
1168: THEN
1169: COMMIT WORK;
1170: END IF;
1171:

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1173: WHEN NO_DATA_FOUND THEN
1174: NULL;
1175: END;
1176:
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: FND_MSG_PUB.Count_And_Get
1180: ( p_count => x_msg_count,
1181: p_data => x_msg_data

Line 1190: IF FND_API.To_Boolean( p_commit )

1186:
1187: ROLLBACK TO SUBMIT_QUOTE_PVT;
1188:
1189: BEGIN
1190: IF FND_API.To_Boolean( p_commit )
1191: THEN
1192: COMMIT WORK;
1193: END IF;
1194:

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1196: WHEN NO_DATA_FOUND THEN
1197: NULL;
1198: END;
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg

Line 1219: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1215: END Submit_Quote;
1216:
1217:
1218: FUNCTION Query_Tax_Detail_Rows (
1219: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1220: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1221: P_Shipment_Tbl_Cnt IN NUMBER,
1222: P_Line_Index IN NUMBER,
1223: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

Line 1220: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

1216:
1217:
1218: FUNCTION Query_Tax_Detail_Rows (
1219: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1220: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1221: P_Shipment_Tbl_Cnt IN NUMBER,
1222: P_Line_Index IN NUMBER,
1223: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1224: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

Line 1326: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

1322: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1323: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1324: END IF;
1325:
1326: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1327:
1328: FOR tax_rec IN c_tax1 LOOP
1329: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1330: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1375: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN

1371: lx_tax_detail_tbl(l_tax_det_count).TAX_INCLUSIVE_FLAG := tax_rec.TAX_INCLUSIVE_FLAG;
1372: lx_tax_detail_tbl(l_tax_det_count).TAX_RATE_ID := tax_rec.TAX_RATE_ID;
1373: -- lx_tax_detail_tbl(lx_tax_detail_tbl.COUNT+1) := l_tax_detail_rec;
1374: END LOOP;
1375: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1376: FOR tax_rec IN c_tax2 LOOP
1377: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1378:
1379: lx_tax_detail_tbl(l_tax_det_count).TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;

Line 1432: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

1428: END Query_Tax_Detail_Rows;
1429:
1430:
1431: FUNCTION Query_Shipment_Rows (
1432: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1433: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1434: P_Line_Index IN NUMBER,
1435: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1436: ) RETURN VARCHAR2

Line 1433: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

1429:
1430:
1431: FUNCTION Query_Shipment_Rows (
1432: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1433: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1434: P_Line_Index IN NUMBER,
1435: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1436: ) RETURN VARCHAR2
1437: IS

Line 1995: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

1991: END Query_Quote_Party_Row;
1992:
1993:
1994: FUNCTION Query_Line_Dtl_Rows (
1995: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1996: P_Line_Index IN NUMBER,
1997: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1998: ) RETURN VARCHAR2
1999: IS

Line 2169: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

2165: END Query_Line_Dtl_Rows;
2166:
2167:
2168: FUNCTION Query_Line_Attribs_Ext_Rows(
2169: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2170: P_Line_Index IN NUMBER,
2171: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2172: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2173: IS

Line 2242: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

2238: END Query_Line_Attribs_Ext_Rows;
2239:
2240:
2241: FUNCTION Query_Price_Attr_Rows (
2242: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2243: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2244: P_Line_Index IN NUMBER,
2245: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2246: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 2243: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

2239:
2240:
2241: FUNCTION Query_Price_Attr_Rows (
2242: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2243: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2244: P_Line_Index IN NUMBER,
2245: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2246: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2247: IS

Line 2597: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

2593: END Query_Price_Adj_Rltship_Rows;
2594:
2595:
2596: FUNCTION Query_Price_Adj_Rows (
2597: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2598: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2599: P_Line_Index IN NUMBER,
2600: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2601: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type

Line 3221: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

3217: END Query_Price_Adj_Rows;
3218:
3219:
3220: FUNCTION Query_Price_Adj_Hdr_Rows (
3221: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3222: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3223: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3224: IS
3225: CURSOR c_price_adj IS

Line 3222: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

3218:
3219:
3220: FUNCTION Query_Price_Adj_Hdr_Rows (
3221: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3222: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3223: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3224: IS
3225: CURSOR c_price_adj IS
3226: SELECT

Line 3432: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

3428: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3429: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3430: END IF;
3431:
3432: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3433:
3434: wf_event_t.initialize(l_Event);
3435:
3436: l_Event.AddParameterToList(

Line 3471: x_return_Status :=FND_API.G_RET_STS_ERROR;

3467: p_parameters => l_event.getParameterList );
3468:
3469: EXCEPTION
3470: WHEN OTHERS THEN
3471: x_return_Status :=FND_API.G_RET_STS_ERROR;
3472:
3473: END Raise_Quote_Event;
3474:
3475: