APPS.ASO_QUOTE_HEADERS_PVT dependencies on FND_MSG_PUB

Line 439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

435: aso_debug_pub.add('Populate_Qte_Header: ASO_AUTO_NUMBERING is off and quote_number is passed as G_MISS_NUM or NULL', 1, 'N');
436:
437: END IF;
438:
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
441: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;

Line 442: FND_MSG_PUB.ADD;

438:
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
441: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444:
445: RAISE FND_API.G_EXC_ERROR;
446:

Line 469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

465: END IF;
466:
467: CLOSE C_Qte_Version;
468:
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('ASO', 'ASO_API_DUPLICATE_QTE_NUM');
471: FND_MESSAGE.Set_Token('QTE_NUM', x_qte_header_rec.quote_number, FALSE);
472: FND_MSG_PUB.ADD;
473: END IF;

Line 472: FND_MSG_PUB.ADD;

468:
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('ASO', 'ASO_API_DUPLICATE_QTE_NUM');
471: FND_MESSAGE.Set_Token('QTE_NUM', x_qte_header_rec.quote_number, FALSE);
472: FND_MSG_PUB.ADD;
473: END IF;
474: RAISE FND_API.G_EXC_ERROR;
475: ELSE
476: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 568: FND_MSG_PUB.ADD;

564: aso_debug_pub.add('Populate_qte_header: Currency_code can not be passed as NULL or G_MISS_CHAR when price_list_id is NULL',1,'N');
565: END IF;
566:
567: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICE_LIST_CURRENCY_CODE');
568: FND_MSG_PUB.ADD;
569: RAISE FND_API.G_EXC_ERROR;
570:
571: END IF;
572:

Line 604: FND_MSG_PUB.ADD;

600: CLOSE c_resource;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
603: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
604: FND_MSG_PUB.ADD;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
608: CLOSE c_resource;

Line 3821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3818: aso_debug_pub.add('Inside price check: x_return_status: '|| x_return_status );
3819: END IF;
3820:
3821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3822:
3823: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');
3824: FND_MSG_PUB.ADD;
3825:

Line 3824: FND_MSG_PUB.ADD;

3820:
3821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3822:
3823: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');
3824: FND_MSG_PUB.ADD;
3825:
3826: END IF;
3827:
3828: RAISE FND_API.G_EXC_ERROR;

Line 3901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3897: END IF;
3898:
3899: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3900:
3901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3902: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3903: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3904: FND_MSG_PUB.ADD;
3905: END IF;

Line 3904: FND_MSG_PUB.ADD;

3900:
3901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3902: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3903: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3904: FND_MSG_PUB.ADD;
3905: END IF;
3906:
3907: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4232: FND_MSG_PUB.initialize;

4228:
4229:
4230: -- Initialize message list if p_init_msg_list is set to TRUE.
4231: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4232: FND_MSG_PUB.initialize;
4233: END IF;
4234:
4235: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
4236: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4255: -- Validate Environment
4256:
4257: IF FND_GLOBAL.User_Id IS NULL THEN
4258:
4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4261: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4262: FND_MSG_PUB.ADD;
4263: END IF;

Line 4262: FND_MSG_PUB.ADD;

4258:
4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4261: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4262: FND_MSG_PUB.ADD;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266:

Line 4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4409: , x_msg_data => x_msg_data);
4410:
4411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4412:
4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
4415: FND_MSG_PUB.ADD;
4416: END IF;
4417:

Line 4415: FND_MSG_PUB.ADD;

4411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4412:
4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
4415: FND_MSG_PUB.ADD;
4416: END IF;
4417:
4418: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4476: end if;
4477:
4478: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4479:
4480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4481: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');
4482: FND_MSG_PUB.ADD;
4483: END IF;
4484: RAISE FND_API.G_EXC_ERROR;

Line 4482: FND_MSG_PUB.ADD;

4478: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4479:
4480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4481: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');
4482: FND_MSG_PUB.ADD;
4483: END IF;
4484: RAISE FND_API.G_EXC_ERROR;
4485: END IF;
4486:

Line 4501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4497: end if;
4498:
4499: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4500:
4501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4502: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4503: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4504: FND_MSG_PUB.ADD;
4505: END IF;

Line 4504: FND_MSG_PUB.ADD;

4500:
4501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4502: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4503: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4504: FND_MSG_PUB.ADD;
4505: END IF;
4506: RAISE FND_API.G_EXC_ERROR;
4507: END IF;
4508:

Line 4523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4519: end if;
4520:
4521: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4522:
4523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4524: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4525: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4526: FND_MSG_PUB.ADD;
4527: END IF;

Line 4526: FND_MSG_PUB.ADD;

4522:
4523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4524: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4525: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4526: FND_MSG_PUB.ADD;
4527: END IF;
4528: RAISE FND_API.G_EXC_ERROR;
4529: END IF;
4530:

Line 4547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4543: end if;
4544:
4545: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4546:
4547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4549: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4550: FND_MSG_PUB.ADD;
4551: END IF;

Line 4550: FND_MSG_PUB.ADD;

4546:
4547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4549: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4550: FND_MSG_PUB.ADD;
4551: END IF;
4552: RAISE FND_API.G_EXC_ERROR;
4553: END IF;
4554:

Line 4582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4578: end if;
4579:
4580: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4581:
4582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4583: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
4584: FND_MSG_PUB.ADD;
4585: END IF;
4586: RAISE FND_API.G_EXC_ERROR;

Line 4584: FND_MSG_PUB.ADD;

4580: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4581:
4582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4583: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
4584: FND_MSG_PUB.ADD;
4585: END IF;
4586: RAISE FND_API.G_EXC_ERROR;
4587: END IF;
4588:

Line 4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4876: END IF;
4877:
4878: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4879:
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4882: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4883: FND_MSG_PUB.ADD;
4884: END IF;

Line 4883: FND_MSG_PUB.ADD;

4879:
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4882: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4883: FND_MSG_PUB.ADD;
4884: END IF;
4885: RAISE FND_API.G_EXC_ERROR;
4886: END IF;
4887:

Line 4911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4907: END IF;
4908:
4909: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4910:
4911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4912: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4913: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4914: FND_MSG_PUB.ADD;
4915: END IF;

Line 4914: FND_MSG_PUB.ADD;

4910:
4911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4912: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4913: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4914: FND_MSG_PUB.ADD;
4915: END IF;
4916: RAISE FND_API.G_EXC_ERROR;
4917: END IF;
4918:

Line 4937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4933: END IF;
4934:
4935: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4936:
4937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4939: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4940: FND_MSG_PUB.ADD;
4941: END IF;

Line 4940: FND_MSG_PUB.ADD;

4936:
4937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4939: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4940: FND_MSG_PUB.ADD;
4941: END IF;
4942: RAISE FND_API.G_EXC_ERROR;
4943: END IF;
4944:

Line 4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4964: END IF;
4965:
4966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4970: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;

Line 4971: FND_MSG_PUB.ADD;

4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4970: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973: RAISE FND_API.G_EXC_ERROR;
4974: END IF;
4975:

Line 5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4997: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4998:
4999: IF l_hd_payment_tbl.count > 1 THEN
5000:
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5002: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5003: FND_MSG_PUB.ADD;
5004: END IF;
5005: RAISE FND_API.G_EXC_ERROR;

Line 5003: FND_MSG_PUB.ADD;

4999: IF l_hd_payment_tbl.count > 1 THEN
5000:
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5002: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5003: FND_MSG_PUB.ADD;
5004: END IF;
5005: RAISE FND_API.G_EXC_ERROR;
5006:
5007: ELSIF l_hd_payment_tbl.count = 1 THEN

Line 5011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5007: ELSIF l_hd_payment_tbl.count = 1 THEN
5008:
5009: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
5010:
5011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5012: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5013: FND_MSG_PUB.ADD;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;

Line 5013: FND_MSG_PUB.ADD;

5009: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
5010:
5011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5012: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5013: FND_MSG_PUB.ADD;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;
5016: END IF;
5017:

Line 5030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5026: FOR i IN 1..l_hd_payment_tbl.count LOOP
5027:
5028: IF l_hd_payment_tbl(i).payment_option <> 'SPLIT' THEN
5029:
5030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
5032: FND_MSG_PUB.ADD;
5033: END IF;
5034: RAISE FND_API.G_EXC_ERROR;

Line 5032: FND_MSG_PUB.ADD;

5028: IF l_hd_payment_tbl(i).payment_option <> 'SPLIT' THEN
5029:
5030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
5032: FND_MSG_PUB.ADD;
5033: END IF;
5034: RAISE FND_API.G_EXC_ERROR;
5035: END IF;
5036:

Line 5043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5039: END IF;
5040:
5041: IF l_hd_tax_detail_tbl.count > 1 THEN
5042:
5043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5044: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
5045: FND_MSG_PUB.ADD;
5046: END IF;
5047: RAISE FND_API.G_EXC_ERROR;

Line 5045: FND_MSG_PUB.ADD;

5041: IF l_hd_tax_detail_tbl.count > 1 THEN
5042:
5043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5044: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
5045: FND_MSG_PUB.ADD;
5046: END IF;
5047: RAISE FND_API.G_EXC_ERROR;
5048: END IF;
5049:

Line 5574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5570: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5571:
5572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5573:
5574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5575: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5576: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5577: FND_MSG_PUB.ADD;
5578: END IF;

Line 5577: FND_MSG_PUB.ADD;

5573:
5574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5575: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5576: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5580:
5581: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 5870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5866:
5867: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5868:
5869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5871: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5872: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5873: FND_MSG_PUB.ADD;
5874: END IF;

Line 5873: FND_MSG_PUB.ADD;

5869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5871: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5872: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5873: FND_MSG_PUB.ADD;
5874: END IF;
5875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5876:
5877: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 6008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6004:
6005: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6006:
6007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6009: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6010: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
6011: FND_MSG_PUB.ADD;
6012: END IF;

Line 6011: FND_MSG_PUB.ADD;

6007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6009: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6010: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
6011: FND_MSG_PUB.ADD;
6012: END IF;
6013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6014:
6015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 6222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6219:
6220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6224: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6225: FND_MSG_PUB.ADD;
6226: END IF;

Line 6225: FND_MSG_PUB.ADD;

6221:
6222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6224: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6225: FND_MSG_PUB.ADD;
6226: END IF;
6227:
6228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6229:

Line 6294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6290: END IF;
6291: */
6292: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6293:
6294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6296: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6297: FND_MSG_PUB.ADD;
6298: END IF;

Line 6297: FND_MSG_PUB.ADD;

6293:
6294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6296: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6297: FND_MSG_PUB.ADD;
6298: END IF;
6299:
6300: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6491: END IF;
6492:
6493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6494:
6495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6497: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6498: FND_MSG_PUB.ADD;
6499: END IF;

Line 6498: FND_MSG_PUB.ADD;

6494:
6495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6497: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6498: FND_MSG_PUB.ADD;
6499: END IF;
6500:
6501: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6550: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6551:
6552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6553:
6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6555: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6556: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6557: FND_MSG_PUB.ADD;
6558: END IF;

Line 6557: FND_MSG_PUB.ADD;

6553:
6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6555: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6556: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6557: FND_MSG_PUB.ADD;
6558: END IF;
6559:
6560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6561:

Line 6593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6589: X_Msg_Data => X_Msg_Data );
6590:
6591: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6592:
6593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6594: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');
6595: FND_MSG_PUB.ADD;
6596: END IF;
6597:

Line 6595: FND_MSG_PUB.ADD;

6591: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6592:
6593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6594: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');
6595: FND_MSG_PUB.ADD;
6596: END IF;
6597:
6598: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6633:
6634:
6635: -- Standard call to get message count and if count is 1, get message info.
6636:
6637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6638: p_data => x_msg_data );
6639:
6640: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6641: aso_debug_pub.add('******************************************************', 1, 'Y');

Line 6653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

6649: WHEN FND_API.G_EXC_ERROR THEN
6650: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6651: P_API_NAME => L_API_NAME
6652: ,P_PKG_NAME => G_PKG_NAME
6653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6654: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6655: ,P_SQLCODE => SQLCODE
6656: ,P_SQLERRM => SQLERRM
6657: ,X_MSG_COUNT => X_MSG_COUNT

Line 6665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6663: P_API_NAME => L_API_NAME
6664: ,P_PKG_NAME => G_PKG_NAME
6665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6667: ,P_SQLCODE => SQLCODE
6668: ,P_SQLERRM => SQLERRM
6669: ,X_MSG_COUNT => X_MSG_COUNT

Line 7237: FND_MSG_PUB.initialize;

7233: END IF;
7234:
7235: -- Initialize message list if p_init_msg_list is set to TRUE.
7236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7237: FND_MSG_PUB.initialize;
7238: END IF;
7239:
7240: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7241: aso_debug_pub.add('Update_Quote - Begin ', 1, 'Y');

Line 7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7262: -- Validate Environment
7263: -- ******************************************************************
7264: IF FND_GLOBAL.User_Id IS NULL THEN
7265:
7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7267: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
7268: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
7269: FND_MSG_PUB.ADD;
7270: END IF;

Line 7269: FND_MSG_PUB.ADD;

7265:
7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7267: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
7268: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
7269: FND_MSG_PUB.ADD;
7270: END IF;
7271: RAISE FND_API.G_EXC_ERROR;
7272: END IF;
7273:

Line 7303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7299: l_order_type_id,l_order_id,l_object_version_number, l_currency_code, l_price_list_id;
7300:
7301: If ( C_Get_quote%NOTFOUND) Then
7302:
7303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7304: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7305: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7306: FND_MSG_PUB.Add;
7307: END IF;

Line 7306: FND_MSG_PUB.Add;

7302:
7303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7304: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7305: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7306: FND_MSG_PUB.Add;
7307: END IF;
7308: raise FND_API.G_EXC_ERROR;
7309:
7310: END IF;

Line 7327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7323: END IF;
7324:
7325: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
7326:
7327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7329: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7330: FND_MSG_PUB.ADD;
7331: END IF;

Line 7330: FND_MSG_PUB.ADD;

7326:
7327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7329: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7330: FND_MSG_PUB.ADD;
7331: END IF;
7332: raise FND_API.G_EXC_ERROR;
7333:
7334: End if;

Line 7339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7335:
7336: -- Check Whether record has been changed by someone else
7337: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
7338:
7339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7340: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7341: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7342: FND_MSG_PUB.ADD;
7343: END IF;

Line 7342: FND_MSG_PUB.ADD;

7338:
7339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7340: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7341: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7342: FND_MSG_PUB.ADD;
7343: END IF;
7344: raise FND_API.G_EXC_ERROR;
7345:
7346: End if;

Line 7359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7355: END IF;
7356:
7357: If (l_object_version_number <> p_qte_header_rec.object_version_number) then
7358:
7359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7360: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7361: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7362: FND_MSG_PUB.ADD;
7363: END IF;

Line 7362: FND_MSG_PUB.ADD;

7358:
7359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7360: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7361: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7362: FND_MSG_PUB.ADD;
7363: END IF;
7364: raise FND_API.G_EXC_ERROR;
7365:
7366: End If;

Line 7377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7373: x_status => x_status);
7374:
7375: if (x_status = FND_API.G_TRUE) then
7376:
7377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7378: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
7379: FND_MSG_PUB.ADD;
7380: end if;
7381: raise FND_API.G_EXC_ERROR;

Line 7379: FND_MSG_PUB.ADD;

7375: if (x_status = FND_API.G_TRUE) then
7376:
7377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7378: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
7379: FND_MSG_PUB.ADD;
7380: end if;
7381: raise FND_API.G_EXC_ERROR;
7382:
7383: end if;

Line 7388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7384: end if;
7385:
7386: IF l_order_id is NOT NULL and l_order_id <> FND_API.G_MISS_NUM THEN
7387:
7388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7389: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');
7390: FND_MSG_PUB.ADD;
7391: END IF;
7392: raise FND_API.G_EXC_ERROR;

Line 7390: FND_MSG_PUB.ADD;

7386: IF l_order_id is NOT NULL and l_order_id <> FND_API.G_MISS_NUM THEN
7387:
7388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7389: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');
7390: FND_MSG_PUB.ADD;
7391: END IF;
7392: raise FND_API.G_EXC_ERROR;
7393:
7394: END IF;

Line 7744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7740: END IF ;
7741:
7742: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7743:
7744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7745: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
7746: FND_MSG_PUB.ADD;
7747: END IF;
7748:

Line 7746: FND_MSG_PUB.ADD;

7742: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7743:
7744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7745: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
7746: FND_MSG_PUB.ADD;
7747: END IF;
7748:
7749: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
7750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7924: x_msg_data => x_msg_data);
7925:
7926: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7927:
7928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7929: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7930: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7931: FND_MSG_PUB.ADD;
7932: END IF;

Line 7931: FND_MSG_PUB.ADD;

7927:
7928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7929: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7930: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7931: FND_MSG_PUB.ADD;
7932: END IF;
7933: RAISE FND_API.G_EXC_ERROR;
7934:
7935: END IF;

Line 7948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7944: x_msg_data => x_msg_data);
7945:
7946: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7947:
7948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7949: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7950: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7951: FND_MSG_PUB.ADD;
7952: END IF;

Line 7951: FND_MSG_PUB.ADD;

7947:
7948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7949: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7950: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7951: FND_MSG_PUB.ADD;
7952: END IF;
7953: RAISE FND_API.G_EXC_ERROR;
7954: END IF;
7955:

Line 7968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7964: x_msg_data => x_msg_data);
7965:
7966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7967:
7968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7969: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7971: FND_MSG_PUB.ADD;
7972: END IF;

Line 7971: FND_MSG_PUB.ADD;

7967:
7968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7969: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7971: FND_MSG_PUB.ADD;
7972: END IF;
7973: RAISE FND_API.G_EXC_ERROR;
7974: END IF;
7975:

Line 8220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8216: x_msg_data => x_msg_data);
8217:
8218: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8219:
8220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');
8222: FND_MSG_PUB.ADD;
8223: END IF;
8224: RAISE FND_API.G_EXC_ERROR;

Line 8222: FND_MSG_PUB.ADD;

8218: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8219:
8220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');
8222: FND_MSG_PUB.ADD;
8223: END IF;
8224: RAISE FND_API.G_EXC_ERROR;
8225: END IF;
8226:

Line 8238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8234: x_msg_data => x_msg_data);
8235:
8236: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8237:
8238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8239: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8240: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
8241: FND_MSG_PUB.ADD;
8242: END IF;

Line 8241: FND_MSG_PUB.ADD;

8237:
8238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8239: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8240: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
8241: FND_MSG_PUB.ADD;
8242: END IF;
8243: RAISE FND_API.G_EXC_ERROR;
8244: END IF;
8245:

Line 8256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8252: x_msg_data => x_msg_data);
8253:
8254: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8255:
8256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8257: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8258: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
8259: FND_MSG_PUB.ADD;
8260: END IF;

Line 8259: FND_MSG_PUB.ADD;

8255:
8256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8257: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8258: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
8259: FND_MSG_PUB.ADD;
8260: END IF;
8261: RAISE FND_API.G_EXC_ERROR;
8262: END IF;
8263:

Line 8279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8275: x_msg_data => x_msg_data);
8276:
8277: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8278:
8279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8280: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
8281: FND_MSG_PUB.ADD;
8282: END IF;
8283: RAISE FND_API.G_EXC_ERROR;

Line 8281: FND_MSG_PUB.ADD;

8277: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8278:
8279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8280: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
8281: FND_MSG_PUB.ADD;
8282: END IF;
8283: RAISE FND_API.G_EXC_ERROR;
8284: END IF;
8285: END IF;

Line 8305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8301: x_msg_data => x_msg_data);
8302:
8303: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8304:
8305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
8307: FND_MSG_PUB.ADD;
8308: END IF;
8309: RAISE FND_API.G_EXC_ERROR;

Line 8307: FND_MSG_PUB.ADD;

8303: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8304:
8305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
8307: FND_MSG_PUB.ADD;
8308: END IF;
8309: RAISE FND_API.G_EXC_ERROR;
8310: END IF;
8311:

Line 8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8414: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
8415:
8416: IF l_qte_header_rec.currency_code IS NULL THEN
8417:
8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8419: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8420: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
8421: FND_MSG_PUB.ADD;
8422: END IF;

Line 8421: FND_MSG_PUB.ADD;

8417:
8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8419: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8420: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
8421: FND_MSG_PUB.ADD;
8422: END IF;
8423: RAISE FND_API.G_EXC_ERROR;
8424: END IF;
8425:

Line 8441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8437: x_msg_data => x_msg_data);
8438:
8439: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8440:
8441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8442: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8443: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8444: FND_MSG_PUB.ADD;
8445: END IF;

Line 8444: FND_MSG_PUB.ADD;

8440:
8441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8442: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8443: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8444: FND_MSG_PUB.ADD;
8445: END IF;
8446: RAISE FND_API.G_EXC_ERROR;
8447: END IF;
8448:

Line 8463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8459: x_msg_data => x_msg_data);
8460:
8461: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8462:
8463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8464: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8465: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8466: FND_MSG_PUB.ADD;
8467: END IF;

Line 8466: FND_MSG_PUB.ADD;

8462:
8463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8464: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8465: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8466: FND_MSG_PUB.ADD;
8467: END IF;
8468:
8469: RAISE FND_API.G_EXC_ERROR;
8470: END IF;

Line 8487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8483: x_msg_data => x_msg_data);
8484:
8485: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8486:
8487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8488: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
8489: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
8490: FND_MSG_PUB.ADD;
8491: END IF;

Line 8490: FND_MSG_PUB.ADD;

8486:
8487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8488: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
8489: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
8490: FND_MSG_PUB.ADD;
8491: END IF;
8492: RAISE FND_API.G_EXC_ERROR;
8493: END IF;
8494:

Line 8558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8554: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
8555:
8556: IF l_hd_payment_tbl.count > 1 THEN
8557:
8558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8559: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
8560: FND_MSG_PUB.ADD;
8561: END IF;
8562: RAISE FND_API.G_EXC_ERROR;

Line 8560: FND_MSG_PUB.ADD;

8556: IF l_hd_payment_tbl.count > 1 THEN
8557:
8558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8559: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
8560: FND_MSG_PUB.ADD;
8561: END IF;
8562: RAISE FND_API.G_EXC_ERROR;
8563:
8564: ELSIF l_hd_payment_tbl.count = 1 THEN

Line 8568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8564: ELSIF l_hd_payment_tbl.count = 1 THEN
8565:
8566: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
8567:
8568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8569: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8570: FND_MSG_PUB.ADD;
8571: END IF;
8572: RAISE FND_API.G_EXC_ERROR;

Line 8570: FND_MSG_PUB.ADD;

8566: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
8567:
8568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8569: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8570: FND_MSG_PUB.ADD;
8571: END IF;
8572: RAISE FND_API.G_EXC_ERROR;
8573: END IF;
8574:

Line 8590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8586: WHILE l_index IS NOT NULL LOOP
8587:
8588: IF l_payment_db_tbl(l_index) <> 'SPLIT' THEN
8589:
8590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8591: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8592: FND_MSG_PUB.ADD;
8593: END IF;
8594: RAISE FND_API.G_EXC_ERROR;

Line 8592: FND_MSG_PUB.ADD;

8588: IF l_payment_db_tbl(l_index) <> 'SPLIT' THEN
8589:
8590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8591: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8592: FND_MSG_PUB.ADD;
8593: END IF;
8594: RAISE FND_API.G_EXC_ERROR;
8595: END IF;
8596: l_index := l_payment_db_tbl.next(l_index);

Line 8629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8625: END LOOP;
8626:
8627: IF l_shipment_db_tbl.count > 1 THEN
8628:
8629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
8631: FND_MSG_PUB.ADD;
8632: END IF;
8633: RAISE FND_API.G_EXC_ERROR;

Line 8631: FND_MSG_PUB.ADD;

8627: IF l_shipment_db_tbl.count > 1 THEN
8628:
8629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
8631: FND_MSG_PUB.ADD;
8632: END IF;
8633: RAISE FND_API.G_EXC_ERROR;
8634: END IF;
8635:

Line 8662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

8658: END LOOP;
8659:
8660: IF l_tax_db_tbl.count > 1 THEN
8661:
8662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8663: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
8664: FND_MSG_PUB.ADD;
8665: END IF;
8666: RAISE FND_API.G_EXC_ERROR;

Line 8664: FND_MSG_PUB.ADD;

8660: IF l_tax_db_tbl.count > 1 THEN
8661:
8662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8663: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
8664: FND_MSG_PUB.ADD;
8665: END IF;
8666: RAISE FND_API.G_EXC_ERROR;
8667:
8668: END IF;

Line 9478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

9474:
9475:
9476: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9479: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9480: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
9481: FND_MSG_PUB.ADD;
9482: END IF;

Line 9481: FND_MSG_PUB.ADD;

9477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9479: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9480: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
9481: FND_MSG_PUB.ADD;
9482: END IF;
9483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9484: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9485: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9521: FND_MSG_PUB.ADD;

9517: Close c_service_ref_type_code;
9518:
9519: If l_service_ref_type_code = 'CUSTOMER_PRODUCT' Then
9520: FND_MESSAGE.Set_Name('ASO', 'ASO_IB_END_CUST_CHG_NA');
9521: FND_MSG_PUB.ADD;
9522: RAISE FND_API.G_EXC_ERROR;
9523: End If;
9524: End If;
9525: End If;

Line 9568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

9564: END IF;
9565: END IF;
9566: ELSE
9567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
9569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
9570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
9571: FND_MSG_PUB.ADD;
9572: END IF;

Line 9571: FND_MSG_PUB.ADD;

9567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
9569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
9570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
9571: FND_MSG_PUB.ADD;
9572: END IF;
9573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9574: END IF;
9575:

Line 10080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10076: END IF;
10077:
10078: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10082: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10083: FND_MSG_PUB.ADD;
10084: END IF;

Line 10083: FND_MSG_PUB.ADD;

10079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10082: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10083: FND_MSG_PUB.ADD;
10084: END IF;
10085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10086:
10087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 10210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10206: := l_price_adj_tbl(j).price_adjustment_id;
10207: END LOOP;
10208: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10211: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10212: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10213: FND_MSG_PUB.ADD;
10214: END IF;

Line 10213: FND_MSG_PUB.ADD;

10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10211: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10212: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10213: FND_MSG_PUB.ADD;
10214: END IF;
10215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10216: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10217: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10547: := l_price_adj_tbl(j).price_adjustment_id;
10548: END LOOP;
10549: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10552: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10553: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
10554: FND_MSG_PUB.ADD;
10555: END IF;

Line 10554: FND_MSG_PUB.ADD;

10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10552: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10553: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
10554: FND_MSG_PUB.ADD;
10555: END IF;
10556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10557: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10558: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10655: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10656:
10657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10658:
10659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10660: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10661: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
10662: FND_MSG_PUB.ADD;
10663: END IF;

Line 10662: FND_MSG_PUB.ADD;

10658:
10659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10660: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10661: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
10662: FND_MSG_PUB.ADD;
10663: END IF;
10664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10665:
10666: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 10803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10799: END IF;
10800:
10801: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10802:
10803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10804: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
10805: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
10806: FND_MSG_PUB.ADD;
10807: END IF;

Line 10806: FND_MSG_PUB.ADD;

10802:
10803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10804: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
10805: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
10806: FND_MSG_PUB.ADD;
10807: END IF;
10808:
10809: RAISE FND_API.G_EXC_ERROR;
10810:

Line 11225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

11221: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11222:
11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11226:
11227: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11228: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11229: FND_MSG_PUB.ADD;

Line 11229: FND_MSG_PUB.ADD;

11225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11226:
11227: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11228: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11229: FND_MSG_PUB.ADD;
11230:
11231: END IF;
11232:
11233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

11307: END IF;
11308: end if;
11309:
11310: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11312: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11313: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
11314: FND_MSG_PUB.ADD;
11315: END IF;

Line 11314: FND_MSG_PUB.ADD;

11310: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11312: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11313: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
11314: FND_MSG_PUB.ADD;
11315: END IF;
11316:
11317: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

11495: aso_debug_pub.add('Update_Quote: After call to AR_VIEW_TERM_GRP.pay_now_amounts: x_return_status: '|| x_return_status, 1, 'Y'); END IF;
11496:
11497: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11498:
11499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11500: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11501: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
11502: FND_MSG_PUB.ADD;
11503: END IF;

Line 11502: FND_MSG_PUB.ADD;

11498:
11499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11500: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11501: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
11502: FND_MSG_PUB.ADD;
11503: END IF;
11504:
11505: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

11552:
11553: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11554:
11555:
11556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11558: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
11559: FND_MSG_PUB.ADD;
11560: END IF;

Line 11559: FND_MSG_PUB.ADD;

11555:
11556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11558: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
11559: FND_MSG_PUB.ADD;
11560: END IF;
11561:
11562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11563:

Line 11595: FND_MSG_PUB.Count_And_Get

11591: COMMIT WORK;
11592: END IF;
11593:
11594: -- Standard call to get message count and if count is 1, get message info.
11595: FND_MSG_PUB.Count_And_Get
11596: ( p_count => x_msg_count,
11597: p_data => x_msg_data
11598: );
11599:

Line 11605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

11601: WHEN FND_API.G_EXC_ERROR THEN
11602: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11603: P_API_NAME => L_API_NAME
11604: ,P_PKG_NAME => G_PKG_NAME
11605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11606: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11607: ,P_SQLCODE => SQLCODE
11608: ,P_SQLERRM => SQLERRM
11609: ,X_MSG_COUNT => X_MSG_COUNT

Line 11617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11615: P_API_NAME => L_API_NAME
11616: ,P_PKG_NAME => G_PKG_NAME
11617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11618: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11619: ,P_SQLCODE => SQLCODE
11620: ,P_SQLERRM => SQLERRM
11621: ,X_MSG_COUNT => X_MSG_COUNT

Line 11680: FND_MSG_PUB.initialize;

11676:
11677: -- Initialize message list if p_init_msg_list is set to TRUE.
11678: IF FND_API.to_Boolean( p_init_msg_list )
11679: THEN
11680: FND_MSG_PUB.initialize;
11681: END IF;
11682:
11683:
11684: -- Initialize API return status to SUCCESS

Line 11794: FND_MSG_PUB.Count_And_Get

11790: END IF;
11791:
11792:
11793: -- Standard call to get message count and if count is 1, get message info.
11794: FND_MSG_PUB.Count_And_Get
11795: ( p_count => x_msg_count,
11796: p_data => x_msg_data
11797: );
11798:

Line 11804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

11800: WHEN FND_API.G_EXC_ERROR THEN
11801: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11802: P_API_NAME => L_API_NAME
11803: ,P_PKG_NAME => G_PKG_NAME
11804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11805: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11806: ,P_SQLCODE => SQLCODE
11807: ,P_SQLERRM => SQLERRM
11808: ,X_MSG_COUNT => X_MSG_COUNT

Line 11816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11813: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11814: P_API_NAME => L_API_NAME
11815: ,P_PKG_NAME => G_PKG_NAME
11816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11817: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11818: ,P_SQLCODE => SQLCODE
11819: ,P_SQLERRM => SQLERRM
11820: ,X_MSG_COUNT => X_MSG_COUNT

Line 12048: FND_MSG_PUB.initialize;

12044: END IF;
12045:
12046: -- Initialize message list if p_init_msg_list is set to TRUE.
12047: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12048: FND_MSG_PUB.initialize;
12049: END IF;
12050:
12051: -- Debug Message
12052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 12052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

12048: FND_MSG_PUB.initialize;
12049: END IF;
12050:
12051: -- Debug Message
12052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
12053: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
12054: FND_MSG_PUB.Add;
12055: END IF;
12056:

Line 12054: FND_MSG_PUB.Add;

12050:
12051: -- Debug Message
12052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
12053: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
12054: FND_MSG_PUB.Add;
12055: END IF;
12056:
12057: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12058: aso_debug_pub.add('p_qte_header_id: '||p_qte_header_id,1,'N');

Line 12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12139: -- ******************************************************************
12140: -- Validate Environment
12141: -- ******************************************************************
12142: IF FND_GLOBAL.User_Id IS NULL THEN
12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12144: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
12145: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12146: FND_MSG_PUB.ADD;
12147: END IF;

Line 12146: FND_MSG_PUB.ADD;

12142: IF FND_GLOBAL.User_Id IS NULL THEN
12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12144: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
12145: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12146: FND_MSG_PUB.ADD;
12147: END IF;
12148: RAISE FND_API.G_EXC_ERROR;
12149: END IF;
12150: -- ******************************************************************

Line 12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12151: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
12152: OPEN C_Validate_Quote (p_qte_header_id);
12153: FETCH C_Validate_Quote into l_val;
12154: IF C_Validate_Quote%NOTFOUND THEN
12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12157: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
12158: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
12159: FND_MSG_PUB.ADD;

Line 12159: FND_MSG_PUB.ADD;

12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12157: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
12158: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
12159: FND_MSG_PUB.ADD;
12160: END IF;
12161: CLOSE C_Validate_Quote;
12162: RAISE FND_API.G_EXC_ERROR;
12163: END IF;

Line 12191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12187: CLOSE C_Qte_Number;
12188: l_qte_header_rec.quote_version := 1;
12189: l_first_version := FND_API.G_TRUE;
12190: ELSE
12191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12192: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
12193: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12194: FND_MSG_PUB.ADD;
12195: END IF;

Line 12194: FND_MSG_PUB.ADD;

12190: ELSE
12191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12192: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
12193: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12194: FND_MSG_PUB.ADD;
12195: END IF;
12196: RAISE FND_API.G_EXC_ERROR;
12197: END IF; -- profile auto numbering
12198: ELSE

Line 12204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

12200: FETCH C_Qte_Number_Exists into l_qte_num;
12201: CLOSE C_Qte_Number_Exists;
12202: IF (FND_PROFILE.Value('ASO_AUTO_NUMBERING') = 'N'
12203: AND l_qte_num = p_qte_number) THEN
12204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
12205: THEN
12206: */ -- original cpy_qte
12207: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
12208: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

Line 12212: FND_MSG_PUB.ADD;

12208: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12209: */
12210: /* -- original cpy_qte
12211: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
12212: FND_MSG_PUB.ADD;
12213: END IF;
12214: RAISE FND_API.G_EXC_ERROR;
12215: ELSE
12216: l_qte_header_rec.quote_number := p_qte_number;

Line 12230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12226: FETCH C_Qte_Number_Exists into l_qte_num;
12227:
12228: IF C_Qte_Number_Exists%NOTFOUND THEN
12229:
12230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12232: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12233: FND_MSG_PUB.ADD;
12234: END IF;

Line 12233: FND_MSG_PUB.ADD;

12229:
12230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12232: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12233: FND_MSG_PUB.ADD;
12234: END IF;
12235:
12236: CLOSE C_Qte_Number_Exists;
12237: RAISE FND_API.G_EXC_ERROR;

Line 12268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12264: IF l_first_version = FND_API.G_FALSE THEN
12265: OPEN c_qte_status_trans (l_qte_header_rec.quote_status_id, p_qte_status_id);
12266: FETCH c_qte_status_trans INTO l_enabled_flag;
12267: IF c_qte_status_trans%NOTFOUND OR l_enabled_flag = 'N' THEN
12268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12269: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
12270: FND_MSG_PUB.ADD;
12271: END IF;
12272: CLOSE c_qte_status_trans;

Line 12270: FND_MSG_PUB.ADD;

12266: FETCH c_qte_status_trans INTO l_enabled_flag;
12267: IF c_qte_status_trans%NOTFOUND OR l_enabled_flag = 'N' THEN
12268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12269: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
12270: FND_MSG_PUB.ADD;
12271: END IF;
12272: CLOSE c_qte_status_trans;
12273: RAISE FND_API.G_EXC_ERROR;
12274: END IF;

Line 12318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12314:
12315:
12316: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12320: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12321: FND_MSG_PUB.ADD;
12322: END IF;

Line 12321: FND_MSG_PUB.ADD;

12317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12320: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12321: FND_MSG_PUB.ADD;
12322: END IF;
12323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12324: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12325: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12327: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

12323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12324: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12325: x_return_status := FND_API.G_RET_STS_ERROR;
12326: */ -- original cpy_qte
12327: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
12329: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12330: FND_MSG_PUB.ADD;
12331: END IF; */

Line 12330: FND_MSG_PUB.ADD;

12326: */ -- original cpy_qte
12327: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
12329: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12330: FND_MSG_PUB.ADD;
12331: END IF; */
12332: /* -- original cpy_qte
12333: RAISE FND_API.G_EXC_ERROR;
12334: END IF;

Line 12349: FND_MSG_PUB.Count_And_Get

12345:
12346:
12347:
12348: -- Standard call to get message count and if count is 1, get message info.
12349: FND_MSG_PUB.Count_And_Get
12350: ( p_count => x_msg_count,
12351: p_data => x_msg_data
12352: );
12353:

Line 12359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

12355: WHEN FND_API.G_EXC_ERROR THEN
12356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12357: P_API_NAME => L_API_NAME
12358: ,P_PKG_NAME => G_PKG_NAME
12359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12360: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12361: ,X_MSG_COUNT => X_MSG_COUNT
12362: ,X_MSG_DATA => X_MSG_DATA
12363: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12367: P_API_NAME => L_API_NAME
12368: ,P_PKG_NAME => G_PKG_NAME
12369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12370: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12371: ,X_MSG_COUNT => X_MSG_COUNT
12372: ,X_MSG_DATA => X_MSG_DATA
12373: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12932: FND_MSG_PUB.initialize;

12928:
12929: -- Initialize message list if p_init_msg_list is set to TRUE.
12930: IF FND_API.to_Boolean( p_init_msg_list )
12931: THEN
12932: FND_MSG_PUB.initialize;
12933: END IF;
12934:
12935:
12936:

Line 13062: FND_MSG_PUB.Count_And_Get

13058:
13059:
13060:
13061: -- Standard call to get message count and if count is 1, get message info.
13062: FND_MSG_PUB.Count_And_Get
13063: ( p_count => x_msg_count,
13064: p_data => x_msg_data
13065: );
13066:

Line 13072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

13068: WHEN FND_API.G_EXC_ERROR THEN
13069: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13070: P_API_NAME => L_API_NAME
13071: ,P_PKG_NAME => G_PKG_NAME
13072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
13073: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13074: ,X_MSG_COUNT => X_MSG_COUNT
13075: ,X_MSG_DATA => X_MSG_DATA
13076: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 13082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13080: P_API_NAME => L_API_NAME
13081: ,P_PKG_NAME => G_PKG_NAME
13082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13084: ,X_MSG_COUNT => X_MSG_COUNT
13085: ,X_MSG_DATA => X_MSG_DATA
13086: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 13386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13382: END IF;
13383:
13384: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13388: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13389: FND_MSG_PUB.ADD;
13390: END IF;

Line 13389: FND_MSG_PUB.ADD;

13385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13388: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13389: FND_MSG_PUB.ADD;
13390: END IF;
13391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
13393: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13423: END IF;
13424:
13425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13428: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13429: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13430: FND_MSG_PUB.ADD;
13431: END IF;

Line 13430: FND_MSG_PUB.ADD;

13426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13428: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13429: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13430: FND_MSG_PUB.ADD;
13431: END IF;
13432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13433: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
13434: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13435: END IF;
13436:
13437: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13441: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13442: FND_MSG_PUB.ADD;
13443: END IF;

Line 13442: FND_MSG_PUB.ADD;

13438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13441: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13442: FND_MSG_PUB.ADD;
13443: END IF;
13444:
13445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13446: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 13677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13673: END IF;
13674:
13675: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13678: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13679: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13680: FND_MSG_PUB.ADD;
13681: END IF;

Line 13680: FND_MSG_PUB.ADD;

13676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13678: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13679: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13680: FND_MSG_PUB.ADD;
13681: END IF;
13682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13683: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
13684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13699: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13695: -- CLOSE line_id_from_config;
13696:
13697: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13699: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13700: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13701: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13702: FND_MSG_PUB.ADD;
13703: END IF;

Line 13702: FND_MSG_PUB.ADD;

13698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13699: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13700: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13701: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13702: FND_MSG_PUB.ADD;
13703: END IF;
13704:
13705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13706: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 13772: FND_MSG_PUB.initialize;

13768:
13769: -- Initialize message list if p_init_msg_list is set to TRUE.
13770: IF FND_API.to_Boolean( p_init_msg_list )
13771: THEN
13772: FND_MSG_PUB.initialize;
13773: END IF;
13774:
13775:
13776: -- Initialize API return status to SUCCESS

Line 13815: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

13811: ELSE
13812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13813: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE IS NULL', 1, 'Y');
13814: END IF;
13815: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13816: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');
13817: FND_MSG_PUB.ADD;
13818: x_return_status := FND_API.G_RET_STS_ERROR;
13819: END IF;

Line 13817: FND_MSG_PUB.ADD;

13813: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE IS NULL', 1, 'Y');
13814: END IF;
13815: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13816: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');
13817: FND_MSG_PUB.ADD;
13818: x_return_status := FND_API.G_RET_STS_ERROR;
13819: END IF;
13820: END IF;
13821: END IF;

Line 13832: FND_MSG_PUB.Count_And_Get

13828: END IF;
13829:
13830:
13831: -- Standard call to get message count and if count is 1, get message info.
13832: FND_MSG_PUB.Count_And_Get
13833: ( p_count => x_msg_count,
13834: p_data => x_msg_data
13835: );
13836: