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 207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

203: -- Standard Start of API savepoint
204: SAVEPOINT SUBMIT_QUOTE_PVT;
205:
206: -- Standard call to check for call compatibility.
207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
208: p_api_version_number,
209: l_api_name,
210: G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
208: p_api_version_number,
209: l_api_name,
210: G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE.
215: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 215: IF FND_API.to_Boolean( p_init_msg_list ) THEN

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE.
215: IF FND_API.to_Boolean( p_init_msg_list ) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218:
219: -- Debug Message

Line 238: l_return_status := FND_API.G_RET_STS_SUCCESS;

234: ASO_VALIDATE_PVT.VALIDATE_OU(P_Qte_Header_Rec);
235:
236:
237: -- Initialize API return status to success
238: l_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: --
241: -- API body
242: --

Line 252: RAISE FND_API.G_EXC_ERROR;

248: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
249: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
250: FND_MSG_PUB.ADD;
251: END IF;
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254: -- ******************************************************************
255:
256: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

267: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');
268: END IF;
269:
270: IF (C_Get_Update_Date%NOTFOUND) OR
271: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
273: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
274: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
275: FND_MSG_PUB.ADD;

Line 278: RAISE FND_API.G_EXC_ERROR;

274: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
275: FND_MSG_PUB.ADD;
276: END IF;
277: CLOSE C_Get_Update_Date;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280:
281: CLOSE C_Get_Update_Date;
282:

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

280:
281: CLOSE C_Get_Update_Date;
282:
283: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
284: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
285: (l_last_upd_date <> p_qte_header_rec.last_update_date) Then
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
287: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
288: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

Line 291: RAISE FND_API.G_EXC_ERROR;

287: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
288: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
289: FND_MSG_PUB.ADD;
290: END IF;
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293: -- vtariker - Check Whether record has been changed
294:
295: -- 2692785

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

296: ASO_CONC_REQ_INT.Lock_Exists(
297: p_quote_header_id => p_qte_header_rec.quote_header_id,
298: x_status => lx_status);
299:
300: IF (lx_status = FND_API.G_TRUE) THEN
301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
303: FND_MSG_PUB.ADD;
304: END IF;

Line 305: RAISE FND_API.G_EXC_ERROR;

301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
303: FND_MSG_PUB.ADD;
304: END IF;
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307: -- 2692785
308:
309:

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

306: END IF;
307: -- 2692785
308:
309:
310: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
311: OPEN C_Validate_Quote (p_qte_header_rec.quote_header_id);
312: FETCH C_Validate_Quote into l_val;
313: IF C_Validate_Quote%NOTFOUND THEN
314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 321: RAISE FND_API.G_EXC_ERROR;

317: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
318: FND_MSG_PUB.ADD;
319: END IF;
320: CLOSE C_Validate_Quote;
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323: CLOSE C_Validate_Quote;
324: END IF;
325:

Line 329: p_init_msg_list => fnd_api.g_false,

325:
326: -- vtariker
327: -- assign the missing customer accounts to the quote
328: ASO_CHECK_TCA_PVT.Assign_Customer_Accounts (
329: p_init_msg_list => fnd_api.g_false,
330: p_qte_header_id => p_qte_header_rec.quote_header_id,
331: p_calling_api_flag => 2,
332: x_return_status => x_return_status,
333: x_msg_count => x_msg_count,

Line 337: IF x_return_status <> fnd_api.g_ret_sts_success THEN

333: x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data
335: );
336:
337: IF x_return_status <> fnd_api.g_ret_sts_success THEN
338: RAISE fnd_api.g_exc_error;
339: END IF;
340: -- vtariker
341:

Line 338: RAISE fnd_api.g_exc_error;

334: x_msg_data => x_msg_data
335: );
336:
337: IF x_return_status <> fnd_api.g_ret_sts_success THEN
338: RAISE fnd_api.g_exc_error;
339: END IF;
340: -- vtariker
341:
342: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);

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

341:
342: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
343:
344: -- hyang new okc
345: IF p_qte_header_rec.Customer_Name_And_Title <> FND_API.G_MISS_CHAR
346: THEN
347: l_qte_header_rec.Customer_Name_And_Title := p_qte_header_rec.Customer_Name_And_Title;
348: END IF;
349:

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

346: THEN
347: l_qte_header_rec.Customer_Name_And_Title := p_qte_header_rec.Customer_Name_And_Title;
348: END IF;
349:
350: IF p_qte_header_rec.Customer_Signature_Date <> FND_API.G_MISS_DATE
351: THEN
352: l_qte_header_rec.Customer_Signature_Date := p_qte_header_rec.Customer_Signature_Date;
353: END IF;
354:

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

351: THEN
352: l_qte_header_rec.Customer_Signature_Date := p_qte_header_rec.Customer_Signature_Date;
353: END IF;
354:
355: IF p_qte_header_rec.Supplier_Name_And_Title <> FND_API.G_MISS_CHAR
356: THEN
357: l_qte_header_rec.Supplier_Name_And_Title := p_qte_header_rec.Supplier_Name_And_Title;
358: END IF;
359:

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

356: THEN
357: l_qte_header_rec.Supplier_Name_And_Title := p_qte_header_rec.Supplier_Name_And_Title;
358: END IF;
359:
360: IF p_qte_header_rec.Supplier_Signature_Date <> FND_API.G_MISS_DATE
361: THEN
362: l_qte_header_rec.Supplier_Signature_Date := p_qte_header_rec.Supplier_Signature_Date;
363: END IF;
364:

Line 375: p_init_msg_list => FND_API.G_FALSE,

371:
372: -- rahsan 2269789
373:
374: ASO_VALIDATE_PVT.Validate_Quote_Exp_date(
375: p_init_msg_list => FND_API.G_FALSE,
376: p_quote_expiration_date => l_qte_header_rec.quote_expiration_date,
377: x_return_status => x_return_status,
378: x_msg_count => x_msg_count,
379: x_msg_data => x_msg_data

Line 381: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

377: x_return_status => x_return_status,
378: x_msg_count => x_msg_count,
379: x_msg_data => x_msg_data
380: );
381: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
382: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
384: FND_MSG_PUB.ADD;
385: END IF;

Line 386: RAISE FND_API.G_EXC_ERROR;

382: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
384: FND_MSG_PUB.ADD;
385: END IF;
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388:
389: -- end rahsan 2269789
390:

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

390:
391:
392: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
393: IF l_qte_header_rec.contract_id is null then
394: l_qte_header_rec.contract_id := FND_API.G_MISS_NUM;
395: end if;
396: IF l_qte_header_rec.quote_category_code is null then
397: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
398: end if;

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

393: IF l_qte_header_rec.contract_id is null then
394: l_qte_header_rec.contract_id := FND_API.G_MISS_NUM;
395: end if;
396: IF l_qte_header_rec.quote_category_code is null then
397: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
398: end if;
399: IF l_qte_header_rec.accounting_rule_id is null then
400: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
401: end if;

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

396: IF l_qte_header_rec.quote_category_code is null then
397: l_qte_header_rec.quote_category_code := FND_API.G_MISS_CHAR;
398: end if;
399: IF l_qte_header_rec.accounting_rule_id is null then
400: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
401: end if;
402: IF l_qte_header_rec.invoicing_rule_id is null then
403: l_qte_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
404: end if;

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

399: IF l_qte_header_rec.accounting_rule_id is null then
400: l_qte_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
401: end if;
402: IF l_qte_header_rec.invoicing_rule_id is null then
403: l_qte_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
404: end if;
405: end if;
406:
407: -- hyang quote_status

Line 413: p_init_msg_list => FND_API.G_FALSE,

409: FETCH c_qte_status_id INTO l_qte_status_id;
410: CLOSE c_qte_status_id;
411:
412: ASO_VALIDATE_PVT.Validate_Status_Transition(
413: p_init_msg_list => FND_API.G_FALSE,
414: p_source_status_id => l_qte_header_rec.quote_status_id,
415: p_dest_status_id => l_qte_status_id,
416: x_return_status => x_return_status,
417: x_msg_count => x_msg_count,

Line 420: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

416: x_return_status => x_return_status,
417: x_msg_count => x_msg_count,
418: x_msg_data => x_msg_data);
419:
420: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
421: IF l_qte_header_rec.quote_status_id = l_qte_status_id then
422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
423: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
424: FND_MSG_PUB.ADD;

Line 427: RAISE FND_API.G_EXC_ERROR;

423: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
424: FND_MSG_PUB.ADD;
425: END IF;
426: END IF;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:
430: IF aso_debug_pub.g_debug_flag = 'Y' THEN
431: aso_debug_pub.add('Submit_Q: After validate_status_transition: ORDER SUBMITEED ', 1, 'N');

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

477: p_qte_line_id => NULL);
478:
479: FOR i in 1..l_hd_payment_tbl.count LOOP
480: IF (l_hd_payment_tbl(i).payment_amount is NULL OR
481: l_hd_payment_tbl(i).payment_amount = FND_API.G_MISS_NUM) AND
482: (l_hd_payment_tbl(i).payment_type_code IS NOT NULL AND
483: l_hd_payment_tbl(i).payment_type_code <> FND_API.G_MISS_CHAR) THEN
484: l_hd_payment_tbl(i).payment_amount :=
485: l_qte_header_rec.total_quote_price;

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

479: FOR i in 1..l_hd_payment_tbl.count LOOP
480: IF (l_hd_payment_tbl(i).payment_amount is NULL OR
481: l_hd_payment_tbl(i).payment_amount = FND_API.G_MISS_NUM) AND
482: (l_hd_payment_tbl(i).payment_type_code IS NOT NULL AND
483: l_hd_payment_tbl(i).payment_type_code <> FND_API.G_MISS_CHAR) THEN
484: l_hd_payment_tbl(i).payment_amount :=
485: l_qte_header_rec.total_quote_price;
486: END IF;
487: END LOOP;

Line 557: P_Init_Msg_List => FND_API.G_FALSE,

553: END IF;
554: ASO_QUOTE_PUB.validate_model_configuration
555: (
556: P_Api_Version_Number => 1.0,
557: P_Init_Msg_List => FND_API.G_FALSE,
558: P_Commit => FND_API.G_FALSE,
559: P_Quote_header_id =>p_qte_header_rec.quote_header_id,
560: P_UPDATE_QUOTE =>l_Update_Allowed_Flg,
561: P_CONFIG_EFFECTIVE_DATE => FND_API.G_MISS_DATE,

Line 558: P_Commit => FND_API.G_FALSE,

554: ASO_QUOTE_PUB.validate_model_configuration
555: (
556: P_Api_Version_Number => 1.0,
557: P_Init_Msg_List => FND_API.G_FALSE,
558: P_Commit => FND_API.G_FALSE,
559: P_Quote_header_id =>p_qte_header_rec.quote_header_id,
560: P_UPDATE_QUOTE =>l_Update_Allowed_Flg,
561: P_CONFIG_EFFECTIVE_DATE => FND_API.G_MISS_DATE,
562: P_CONFIG_model_lookup_DATE => FND_API.G_MISS_DATE,

Line 561: P_CONFIG_EFFECTIVE_DATE => FND_API.G_MISS_DATE,

557: P_Init_Msg_List => FND_API.G_FALSE,
558: P_Commit => FND_API.G_FALSE,
559: P_Quote_header_id =>p_qte_header_rec.quote_header_id,
560: P_UPDATE_QUOTE =>l_Update_Allowed_Flg,
561: P_CONFIG_EFFECTIVE_DATE => FND_API.G_MISS_DATE,
562: P_CONFIG_model_lookup_DATE => FND_API.G_MISS_DATE,
563: X_Config_tbl => lx_config_tbl,
564: X_Return_Status => x_return_status,
565: X_Msg_Count => x_msg_count,

Line 562: P_CONFIG_model_lookup_DATE => FND_API.G_MISS_DATE,

558: P_Commit => FND_API.G_FALSE,
559: P_Quote_header_id =>p_qte_header_rec.quote_header_id,
560: P_UPDATE_QUOTE =>l_Update_Allowed_Flg,
561: P_CONFIG_EFFECTIVE_DATE => FND_API.G_MISS_DATE,
562: P_CONFIG_model_lookup_DATE => FND_API.G_MISS_DATE,
563: X_Config_tbl => lx_config_tbl,
564: X_Return_Status => x_return_status,
565: X_Msg_Count => x_msg_count,
566: X_Msg_Data => x_msg_data

Line 573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then

569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');
571: END IF;
572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:
575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
577: END IF;

Line 608: RAISE FND_API.G_EXC_ERROR;

604: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_REVIEW');
605: FND_MSG_PUB.ADD;
606: END IF;
607:
608: RAISE FND_API.G_EXC_ERROR;
609: end if; -- l_Update_Allowed_Flg
610: end if; -- l_ct_invalid
611: end if; --sucess
612:

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637: OPEN C_Get_Config_Flag(l_qte_line_id);
638: FETCH C_Get_Config_Flag INTO l_complete_config, l_valid_config, l_instance_id;
639:
640: IF C_Get_Config_Flag%NOTFOUND THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
643: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
644: FND_MSG_PUB.ADD;
645: END IF;

Line 647: RAISE FND_API.G_EXC_ERROR;

643: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
644: FND_MSG_PUB.ADD;
645: END IF;
646: CLOSE C_Get_Config_Flag;
647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');

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

651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
653: END IF;
654:
655: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
656:
657: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654:
655: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
656:
657: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
660: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
661: FND_MSG_PUB.ADD;
662: END IF;

Line 664: RAISE FND_API.G_EXC_ERROR;

660: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
661: FND_MSG_PUB.ADD;
662: END IF;
663: CLOSE C_Get_Config_Flag;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: END IF; -- 2498776 vtariker
668:

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

673: -- 2469621 vtariker
674:
675: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
676: IF l_qte_line_tbl(i).line_category_code is null then
677: l_qte_line_tbl(i).line_category_code := FND_API.G_MISS_CHAR;
678: END IF;
679: IF l_qte_line_tbl(i).invoicing_rule_id is null then
680: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
681: end if;

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

676: IF l_qte_line_tbl(i).line_category_code is null then
677: l_qte_line_tbl(i).line_category_code := FND_API.G_MISS_CHAR;
678: END IF;
679: IF l_qte_line_tbl(i).invoicing_rule_id is null then
680: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
681: end if;
682: IF l_qte_line_tbl(i).accounting_rule_id is null then
683: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
684: end if;

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

679: IF l_qte_line_tbl(i).invoicing_rule_id is null then
680: l_qte_line_tbl(i).invoicing_rule_id := FND_API.G_MISS_NUM;
681: end if;
682: IF l_qte_line_tbl(i).accounting_rule_id is null then
683: l_qte_line_tbl(i).accounting_rule_id := FND_API.G_MISS_NUM;
684: end if;
685: END IF;
686:
687: l_status := ASO_SUBMIT_QUOTE_PVT.Query_Line_Dtl_Rows(

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689:
690: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
691: FOR j IN 1..l_qte_line_dtl_tbl.count LOOP
692: if l_qte_line_dtl_tbl(j).SERVICE_REF_TYPE_CODE= 'PRODUCT_CATALOG' then
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('ASO', 'ASO_SERVICE_REF_NOT_VALID');
696: FND_MSG_PUB.ADD;
697: END IF;

Line 698: RAISE FND_API.G_EXC_ERROR;

694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('ASO', 'ASO_SERVICE_REF_NOT_VALID');
696: FND_MSG_PUB.ADD;
697: END IF;
698: RAISE FND_API.G_EXC_ERROR;
699: end if;
700: end loop;
701: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
702:

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

741: FOR j IN 1..l_tmp_payment_tbl.count LOOP
742: l_tmp_payment_tbl(j).qte_line_index := i;
743: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
744: IF l_tmp_payment_tbl(j).payment_term_id is null then
745: l_tmp_payment_tbl(j).payment_term_id := FND_API.G_MISS_NUM;
746: end if;
747: end if;
748: l_ln_payment_tbl(l_index) := l_tmp_payment_tbl(j);
749: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

808: IF aso_debug_pub.g_debug_flag = 'Y' THEN
809: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');
810: END IF;
811:
812: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN
813:
814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
815: aso_debug_pub.add('Submit_Q: Before Authorize_payment p_control_rec.CVV2: '|| p_control_rec.CVV2, 1, 'N');
816: END IF;

Line 837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

833:
834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
836: END IF;
837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 838: RAISE FND_API.G_EXC_ERROR;

834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
836: END IF;
837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;

Line 840: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

836: END IF;
837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843: END IF;
844: END IF;

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843: END IF;
844: END IF;
845: END LOOP;

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

855: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');
856: END IF;
857:
858: IF l_istore_source <> 'Y' OR (l_istore_source = 'Y' AND
859: (l_qte_header_rec.resource_id IS NOT NULL AND l_qte_header_rec.resource_id <> FND_API.G_MISS_NUM)) THEN
860:
861: IF NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
862:
863: IF (l_sales_team_prof = 'FULL') THEN

Line 867: P_Init_Msg_List => FND_API.G_FALSE,

863: IF (l_sales_team_prof = 'FULL') THEN
864:
865: ASO_SALES_TEAM_PVT.Assign_Sales_Team
866: (
867: P_Init_Msg_List => FND_API.G_FALSE,
868: P_Commit => FND_API.G_FALSE,
869: p_Qte_Header_Rec => l_qte_header_rec,
870: P_Operation => 'SUBMIT',
871: x_Qte_Header_Rec => lx_qte_header_rec,

Line 868: P_Commit => FND_API.G_FALSE,

864:
865: ASO_SALES_TEAM_PVT.Assign_Sales_Team
866: (
867: P_Init_Msg_List => FND_API.G_FALSE,
868: P_Commit => FND_API.G_FALSE,
869: p_Qte_Header_Rec => l_qte_header_rec,
870: P_Operation => 'SUBMIT',
871: x_Qte_Header_Rec => lx_qte_header_rec,
872: x_return_status => x_return_status,

Line 876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

872: x_return_status => x_return_status,
873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data
875: );
876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 877: RAISE FND_API.G_EXC_ERROR;

873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data
875: );
876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;

Line 879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

875: );
876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:
883: IF (l_sales_cred_prof = 'FULL') THEN

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:
883: IF (l_sales_cred_prof = 'FULL') THEN
884:

Line 890: P_Init_Msg_List => FND_API.G_FALSE,

886:
887: ASO_QUOTE_PUB.Allocate_Sales_Credits
888: (
889: P_Api_Version_Number => 1.0,
890: P_Init_Msg_List => FND_API.G_FALSE,
891: P_Commit => FND_API.G_FALSE,
892: P_Control_Rec => l_Sales_Alloc_Control_Rec,
893: p_Qte_Header_Rec => lx_qte_header_rec,
894: x_Qte_Header_Rec => lx_out_qte_header_rec,

Line 891: P_Commit => FND_API.G_FALSE,

887: ASO_QUOTE_PUB.Allocate_Sales_Credits
888: (
889: P_Api_Version_Number => 1.0,
890: P_Init_Msg_List => FND_API.G_FALSE,
891: P_Commit => FND_API.G_FALSE,
892: P_Control_Rec => l_Sales_Alloc_Control_Rec,
893: p_Qte_Header_Rec => lx_qte_header_rec,
894: x_Qte_Header_Rec => lx_out_qte_header_rec,
895: x_return_status => x_return_status,

Line 900: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

896: x_msg_count => x_msg_count,
897: x_msg_data => x_msg_data
898: );
899: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
900: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 901: RAISE FND_API.G_EXC_ERROR;

897: x_msg_data => x_msg_data
898: );
899: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
900: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;

Line 903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

899: lx_qte_header_rec := lx_out_qte_header_rec; --nocopy changes
900: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: END IF;

Line 904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

900: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: END IF;
908:

Line 938: P_Init_Msg_List => FND_API.G_FALSE,

934: END IF;
935:
936: ASO_ORDER_INT.Create_order(
937: P_Api_Version => 1.0,
938: P_Init_Msg_List => FND_API.G_FALSE,
939: p_Control_Rec => l_order_control_rec,
940: P_Commit => FND_API.G_FALSE,
941: p_Qte_Rec => l_Qte_Header_Rec,
942: p_Header_Payment_Tbl => l_Hd_Payment_Tbl,

Line 940: P_Commit => FND_API.G_FALSE,

936: ASO_ORDER_INT.Create_order(
937: P_Api_Version => 1.0,
938: P_Init_Msg_List => FND_API.G_FALSE,
939: p_Control_Rec => l_order_control_rec,
940: P_Commit => FND_API.G_FALSE,
941: p_Qte_Rec => l_Qte_Header_Rec,
942: p_Header_Payment_Tbl => l_Hd_Payment_Tbl,
943: p_Header_Price_Adj_Tbl => l_hd_Price_Adj_Tbl,
944: p_Header_Price_Attributes_Tbl => l_hd_Price_Attr_Tbl,

Line 976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

972: X_Msg_Data => X_Msg_Data);
973: IF aso_debug_pub.g_debug_flag = 'Y' THEN
974: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');
975: END IF;
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
979: FND_MSG_PUB.ADD;
980: END IF;

Line 981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
979: FND_MSG_PUB.ADD;
980: END IF;
981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 982: RAISE FND_API.G_EXC_ERROR;

978: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
979: FND_MSG_PUB.ADD;
980: END IF;
981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;

Line 984: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

980: END IF;
981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987: END IF;
988:

Line 985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

981: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987: END IF;
988:
989: -- If book flag is set to 'Y' OM returns success even if the order

Line 992: IF x_return_status = FND_API.G_RET_STS_SUCCESS

988:
989: -- If book flag is set to 'Y' OM returns success even if the order
990: -- is not booked. We raise an error in case the order is not booked.
991: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
992: IF x_return_status = FND_API.G_RET_STS_SUCCESS
993: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');
996: END IF;

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

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

Line 1000: RAISE FND_API.G_EXC_ERROR;

996: END IF;
997: OPEN C_book_flag;
998: FETCH C_book_flag into l_book_flag;
999: IF C_book_flag%NOTFOUND THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: IF l_book_flag = 'N' or l_book_flag IS NULL THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: IF C_book_flag%NOTFOUND THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: IF l_book_flag = 'N' or l_book_flag IS NULL THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: CLOSE C_book_flag;
1006: END IF;
1007: **/

Line 1014: P_Init_Msg_List => FND_API.G_FALSE,

1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
1012: END IF;
1013: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
1014: P_Init_Msg_List => FND_API.G_FALSE,
1015: P_Commit => FND_API.G_FALSE,
1016: P_Order_Line_Tbl => lx_order_line_tbl,
1017: X_Return_Status => x_return_status,
1018: X_Msg_Count => x_msg_count,

Line 1015: P_Commit => FND_API.G_FALSE,

1011: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
1012: END IF;
1013: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
1014: P_Init_Msg_List => FND_API.G_FALSE,
1015: P_Commit => FND_API.G_FALSE,
1016: P_Order_Line_Tbl => lx_order_line_tbl,
1017: X_Return_Status => x_return_status,
1018: X_Msg_Count => x_msg_count,
1019: X_Msg_Data => x_msg_data);

Line 1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1019: X_Msg_Data => x_msg_data);
1020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1021: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
1022: END IF;
1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1024: RAISE FND_API.G_EXC_ERROR;

1020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1021: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
1022: END IF;
1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;

Line 1026: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1022: END IF;
1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: -- EDU
1030:

Line 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: -- EDU
1030:
1031: -- bug 1749828 hyang

Line 1044: P_Init_Msg_List => FND_API.G_FALSE,

1040: l_related_obj_rec.RECIPROCAL_FLAG := 'N' ;
1041:
1042: ASO_RELATED_OBJ_PVT.Create_related_obj(
1043: P_Api_Version_Number => 1.0,
1044: P_Init_Msg_List => FND_API.G_FALSE,
1045: P_Commit => FND_API.G_FALSE,
1046: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1047: P_RELATED_OBJ_Rec => l_related_obj_rec,
1048: X_RELATED_OBJECT_ID => l_related_obj_id,

Line 1045: P_Commit => FND_API.G_FALSE,

1041:
1042: ASO_RELATED_OBJ_PVT.Create_related_obj(
1043: P_Api_Version_Number => 1.0,
1044: P_Init_Msg_List => FND_API.G_FALSE,
1045: P_Commit => FND_API.G_FALSE,
1046: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1047: P_RELATED_OBJ_Rec => l_related_obj_rec,
1048: X_RELATED_OBJECT_ID => l_related_obj_id,
1049: X_RETURN_STATUS => X_RETURN_STATUS,

Line 1046: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1042: ASO_RELATED_OBJ_PVT.Create_related_obj(
1043: P_Api_Version_Number => 1.0,
1044: P_Init_Msg_List => FND_API.G_FALSE,
1045: P_Commit => FND_API.G_FALSE,
1046: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1047: P_RELATED_OBJ_Rec => l_related_obj_rec,
1048: X_RELATED_OBJECT_ID => l_related_obj_id,
1049: X_RETURN_STATUS => X_RETURN_STATUS,
1050: X_MSG_COUNT => X_MSG_COUNT ,

Line 1057: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');
1056: END IF;
1057: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1059: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
1060: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
1061: FND_MSG_PUB.ADD;

Line 1063: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1059: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
1060: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
1061: FND_MSG_PUB.ADD;
1062: END IF;
1063: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
1061: FND_MSG_PUB.ADD;
1062: END IF;
1063: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: END IF;

Line 1066: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1062: END IF;
1063: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: END IF;
1069: END IF;
1070:

Line 1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1063: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: END IF;
1069: END IF;
1070:
1071: -- end of bug 1749828 hyang code

Line 1107: P_Init_Msg_List => FND_API.G_FALSE,

1103: -- update installment details
1104: -- hyang 1935614 csi integration
1105: ASO_INSTBASE_INT.Update_Inst_Details_ORDER(
1106: P_Api_Version_Number => 1.0,
1107: P_Init_Msg_List => FND_API.G_FALSE,
1108: P_Commit => FND_API.G_FALSE,
1109: P_Quote_Line_Shipment_id=> lx_order_line_tbl(i).quote_shipment_line_id,
1110: P_Order_Line_Id => lx_order_line_tbl(i).order_line_id,
1111: X_Return_Status => x_Return_Status,

Line 1108: P_Commit => FND_API.G_FALSE,

1104: -- hyang 1935614 csi integration
1105: ASO_INSTBASE_INT.Update_Inst_Details_ORDER(
1106: P_Api_Version_Number => 1.0,
1107: P_Init_Msg_List => FND_API.G_FALSE,
1108: P_Commit => FND_API.G_FALSE,
1109: P_Quote_Line_Shipment_id=> lx_order_line_tbl(i).quote_shipment_line_id,
1110: P_Order_Line_Id => lx_order_line_tbl(i).order_line_id,
1111: X_Return_Status => x_Return_Status,
1112: X_Msg_Count => X_Msg_Count,

Line 1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1113: X_Msg_Data => X_Msg_Data );
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');
1116: END IF;
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
1120: FND_MSG_PUB.ADD;
1121: END IF;

Line 1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
1120: FND_MSG_PUB.ADD;
1121: END IF;
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
1120: FND_MSG_PUB.ADD;
1121: END IF;
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;

Line 1125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1121: END IF;
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;
1129:

Line 1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;
1129:
1130: l_shipment_rec := ASO_UTILITY_PVT.Query_shipment_Row(lx_order_line_tbl(i).quote_shipment_Line_id);

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

1131: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_shipment_rec.quote_line_id);
1132:
1133: -- transfer reservation
1134: IF l_shipment_rec.reservation_id IS NOT NULL
1135: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1136: ASO_RESERVATION_INT.Transfer_Reservation(
1137: P_Api_Version_Number => 1.0,
1138: P_Init_Msg_List => FND_API.G_FALSE,
1139: P_Commit => FND_API.G_FALSE,

Line 1138: P_Init_Msg_List => FND_API.G_FALSE,

1134: IF l_shipment_rec.reservation_id IS NOT NULL
1135: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1136: ASO_RESERVATION_INT.Transfer_Reservation(
1137: P_Api_Version_Number => 1.0,
1138: P_Init_Msg_List => FND_API.G_FALSE,
1139: P_Commit => FND_API.G_FALSE,
1140: P_header_rec => l_qte_header_rec,
1141: P_line_Rec => l_qte_line_rec,
1142: p_shipment_rec => l_shipment_rec,

Line 1139: P_Commit => FND_API.G_FALSE,

1135: AND l_shipment_rec.reservation_id <> FND_API.G_MISS_NUM THEN
1136: ASO_RESERVATION_INT.Transfer_Reservation(
1137: P_Api_Version_Number => 1.0,
1138: P_Init_Msg_List => FND_API.G_FALSE,
1139: P_Commit => FND_API.G_FALSE,
1140: P_header_rec => l_qte_header_rec,
1141: P_line_Rec => l_qte_line_rec,
1142: p_shipment_rec => l_shipment_rec,
1143: X_Return_Status => x_Return_Status,

Line 1150: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1146: X_new_RESERVATION_ID => l_reservation_id);
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');
1149: END IF;
1150: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1153: FND_MSG_PUB.ADD;
1154: END IF;

Line 1155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1153: FND_MSG_PUB.ADD;
1154: END IF;
1155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1156: RAISE FND_API.G_EXC_ERROR;

1152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1153: FND_MSG_PUB.ADD;
1154: END IF;
1155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;

Line 1158: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1154: END IF;
1155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;
1161: END IF;
1162: END IF;

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;
1161: END IF;
1162: END IF;
1163: END LOOP; -- lx_order_line_tbl

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

1169: -- lx_return_status := x_return_status -- 1966456
1170: -- copy attachment to order
1171: aso_attachment_int.copy_attachments_to_order
1172: ( p_api_version_number => p_api_version_number
1173: ,p_init_msg_list => FND_API.G_FALSE --P_Init_Msg_List --1966456
1174: ,p_commit => FND_API.G_FALSE
1175: ,p_quote_header_id => p_qte_header_rec.quote_header_id
1176: ,p_order_id => x_order_header_rec.order_header_id
1177: ,p_order_line_tbl => lx_Order_Line_Tbl

Line 1174: ,p_commit => FND_API.G_FALSE

1170: -- copy attachment to order
1171: aso_attachment_int.copy_attachments_to_order
1172: ( p_api_version_number => p_api_version_number
1173: ,p_init_msg_list => FND_API.G_FALSE --P_Init_Msg_List --1966456
1174: ,p_commit => FND_API.G_FALSE
1175: ,p_quote_header_id => p_qte_header_rec.quote_header_id
1176: ,p_order_id => x_order_header_rec.order_header_id
1177: ,p_order_line_tbl => lx_Order_Line_Tbl
1178: ,x_return_status => x_return_status

Line 1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1181: );
1182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1183: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1184: END IF;
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END if;
1188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1186: RAISE FND_API.G_EXC_ERROR;

1182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1183: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1184: END IF;
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END if;
1188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;

Line 1188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1184: END IF;
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END if;
1188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191:
1192: -- x_return_status := lx_return_status; -- 1966456

Line 1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END if;
1188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191:
1192: -- x_return_status := lx_return_status; -- 1966456
1193:

Line 1207: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1203:
1204: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1205: aso_debug_pub.add('Submit_Q: After JTF_HA_STATE_PKG.GET_CURRENT_STATE x_return_status: '||x_return_status, 1, 'N');
1206: END IF;
1207: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1208:
1209: IF X_Current_State IN (3,4) THEN
1210:
1211: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1224: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');
1223: END IF;
1224: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1225:
1226: UPDATE ASO_QUOTE_HEADERS_ALL
1227: SET Order_Id = x_order_header_rec.order_header_id,
1228: last_update_date = sysdate,

Line 1237: x_return_Status := FND_API.G_RET_STS_ERROR;

1233: END IF;
1234:
1235: END IF;
1236: ELSE
1237: x_return_Status := FND_API.G_RET_STS_ERROR;
1238: RAISE FND_API.G_EXC_ERROR;
1239:
1240: END IF;
1241: -- HA

Line 1238: RAISE FND_API.G_EXC_ERROR;

1234:
1235: END IF;
1236: ELSE
1237: x_return_Status := FND_API.G_RET_STS_ERROR;
1238: RAISE FND_API.G_EXC_ERROR;
1239:
1240: END IF;
1241: -- HA
1242:

Line 1261: IF FND_API.to_Boolean( p_commit ) THEN

1257: );
1258:
1259: -- HA
1260: -- Standard check for p_commit
1261: IF FND_API.to_Boolean( p_commit ) THEN
1262: COMMIT WORK;
1263: END IF;
1264: -- HA
1265:

Line 1268: WHEN FND_API.G_EXC_ERROR THEN

1264: -- HA
1265:
1266: EXCEPTION
1267:
1268: WHEN FND_API.G_EXC_ERROR THEN
1269:
1270: ROLLBACK TO SUBMIT_QUOTE_PVT;
1271:
1272: BEGIN

Line 1273: IF FND_API.To_Boolean( p_commit )

1269:
1270: ROLLBACK TO SUBMIT_QUOTE_PVT;
1271:
1272: BEGIN
1273: IF FND_API.To_Boolean( p_commit )
1274: THEN
1275: COMMIT WORK;
1276: END IF;
1277:

Line 1283: x_return_status := FND_API.G_RET_STS_ERROR ;

1279: WHEN NO_DATA_FOUND THEN
1280: NULL;
1281: END;
1282:
1283: x_return_status := FND_API.G_RET_STS_ERROR ;
1284:
1285: FND_MSG_PUB.Count_And_Get
1286: ( p_count => x_msg_count,
1287: p_data => x_msg_data

Line 1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1287: p_data => x_msg_data
1288: );
1289:
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292:
1293: ROLLBACK TO SUBMIT_QUOTE_PVT;
1294:
1295: BEGIN

Line 1296: IF FND_API.To_Boolean( p_commit )

1292:
1293: ROLLBACK TO SUBMIT_QUOTE_PVT;
1294:
1295: BEGIN
1296: IF FND_API.To_Boolean( p_commit )
1297: THEN
1298: COMMIT WORK;
1299: END IF;
1300:

Line 1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1302: WHEN NO_DATA_FOUND THEN
1303: NULL;
1304: END;
1305:
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307:
1308: FND_MSG_PUB.Count_And_Get
1309: ( p_count => x_msg_count,
1310: p_data => x_msg_data

Line 1326: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1322: WHEN NO_DATA_FOUND THEN
1323: NULL;
1324: End;
1325:
1326: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1327:
1328: FND_MSG_PUB.Count_And_Get
1329: ( p_count => x_msg_count,
1330: p_data => x_msg_data

Line 1343: IF FND_API.To_Boolean( p_commit )

1339:
1340: ROLLBACK TO SUBMIT_QUOTE_PVT;
1341:
1342: BEGIN
1343: IF FND_API.To_Boolean( p_commit )
1344: THEN
1345: COMMIT WORK;
1346: END IF;
1347:

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1349: WHEN NO_DATA_FOUND THEN
1350: NULL;
1351: END;
1352:
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354:
1355: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg

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

1368: END Submit_Quote;
1369:
1370:
1371: FUNCTION Query_Tax_Detail_Rows (
1372: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1373: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1374: P_Shipment_Tbl_Cnt IN NUMBER,
1375: P_Line_Index IN NUMBER,
1376: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

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

1369:
1370:
1371: FUNCTION Query_Tax_Detail_Rows (
1372: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1373: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1374: P_Shipment_Tbl_Cnt IN NUMBER,
1375: P_Line_Index IN NUMBER,
1376: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1377: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

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

1475: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1477: END IF;
1478:
1479: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1480:
1481: FOR tax_rec IN c_tax1 LOOP
1482: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1483: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1524: lx_tax_detail_tbl(l_tax_det_count).TAX_INCLUSIVE_FLAG := tax_rec.TAX_INCLUSIVE_FLAG;
1525: lx_tax_detail_tbl(l_tax_det_count).TAX_RATE_ID := tax_rec.TAX_RATE_ID;
1526: -- lx_tax_detail_tbl(lx_tax_detail_tbl.COUNT+1) := l_tax_detail_rec;
1527: END LOOP;
1528: ELSIF P_Qte_Line_Id is NOT NULL OR P_Qte_Line_Id <> FND_API.G_MISS_NUM THEN
1529: FOR tax_rec IN c_tax2 LOOP
1530: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1531:
1532: lx_tax_detail_tbl(l_tax_det_count).TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;

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

1581: END Query_Tax_Detail_Rows;
1582:
1583:
1584: FUNCTION Query_Shipment_Rows (
1585: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1586: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1587: P_Line_Index IN NUMBER,
1588: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1589: ) RETURN VARCHAR2

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

1582:
1583:
1584: FUNCTION Query_Shipment_Rows (
1585: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1586: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1587: P_Line_Index IN NUMBER,
1588: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1589: ) RETURN VARCHAR2
1590: IS

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

2144: END Query_Quote_Party_Row;
2145:
2146:
2147: FUNCTION Query_Line_Dtl_Rows (
2148: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2149: P_Line_Index IN NUMBER,
2150: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2151: ) RETURN VARCHAR2
2152: IS

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

2318: END Query_Line_Dtl_Rows;
2319:
2320:
2321: FUNCTION Query_Line_Attribs_Ext_Rows(
2322: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Line_Index IN NUMBER,
2324: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2325: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2326: IS

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

2391: END Query_Line_Attribs_Ext_Rows;
2392:
2393:
2394: FUNCTION Query_Price_Attr_Rows (
2395: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2396: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2397: P_Line_Index IN NUMBER,
2398: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2399: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

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

2392:
2393:
2394: FUNCTION Query_Price_Attr_Rows (
2395: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2396: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2397: P_Line_Index IN NUMBER,
2398: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2399: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2400: IS

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

2746: END Query_Price_Adj_Rltship_Rows;
2747:
2748:
2749: FUNCTION Query_Price_Adj_Rows (
2750: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2751: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2752: P_Line_Index IN NUMBER,
2753: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2754: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type

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

3370: END Query_Price_Adj_Rows;
3371:
3372:
3373: FUNCTION Query_Price_Adj_Hdr_Rows (
3374: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3375: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3377: IS
3378: CURSOR c_price_adj IS

Line 3375: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

3371:
3372:
3373: FUNCTION Query_Price_Adj_Hdr_Rows (
3374: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3375: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3377: IS
3378: CURSOR c_price_adj IS
3379: SELECT

Line 3585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3583: END IF;
3584:
3585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3586:
3587: wf_event_t.initialize(l_Event);
3588:
3589: l_Event.AddParameterToList(

Line 3624: x_return_Status :=FND_API.G_RET_STS_ERROR;

3620: p_parameters => l_event.getParameterList );
3621:
3622: EXCEPTION
3623: WHEN OTHERS THEN
3624: x_return_Status :=FND_API.G_RET_STS_ERROR;
3625:
3626: END Raise_Quote_Event;
3627:
3628: