APPS.ASO_QUOTE_HEADERS_PVT dependencies on FND_MSG_PUB

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

434: 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');
435:
436: END IF;
437:
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
440: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
441: FND_MSG_PUB.ADD;
442: END IF;

Line 441: FND_MSG_PUB.ADD;

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

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

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

Line 471: FND_MSG_PUB.ADD;

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

Line 567: FND_MSG_PUB.ADD;

563: 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');
564: END IF;
565:
566: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICE_LIST_CURRENCY_CODE');
567: FND_MSG_PUB.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569:
570: END IF;
571:

Line 603: FND_MSG_PUB.ADD;

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

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

3735: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3736: aso_debug_pub.add('Inside price check: x_return_status: '|| x_return_status );
3737: END IF;
3738:
3739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3740:
3741: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');
3742: FND_MSG_PUB.ADD;
3743:

Line 3742: FND_MSG_PUB.ADD;

3738:
3739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3740:
3741: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');
3742: FND_MSG_PUB.ADD;
3743:
3744: END IF;
3745:
3746: RAISE FND_API.G_EXC_ERROR;

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

3815: END IF;
3816:
3817: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3818:
3819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3820: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3821: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3822: FND_MSG_PUB.ADD;
3823: END IF;

Line 3822: FND_MSG_PUB.ADD;

3818:
3819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3820: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3821: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3822: FND_MSG_PUB.ADD;
3823: END IF;
3824:
3825: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4145: FND_MSG_PUB.initialize;

4141:
4142:
4143: -- Initialize message list if p_init_msg_list is set to TRUE.
4144: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4145: FND_MSG_PUB.initialize;
4146: END IF;
4147:
4148: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
4149: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

4168: -- Validate Environment
4169:
4170: IF FND_GLOBAL.User_Id IS NULL THEN
4171:
4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4173: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4174: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4175: FND_MSG_PUB.ADD;
4176: END IF;

Line 4175: FND_MSG_PUB.ADD;

4171:
4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4173: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4174: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4175: FND_MSG_PUB.ADD;
4176: END IF;
4177: RAISE FND_API.G_EXC_ERROR;
4178: END IF;
4179:

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

4322: , x_msg_data => x_msg_data);
4323:
4324: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4325:
4326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4327: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
4328: FND_MSG_PUB.ADD;
4329: END IF;
4330:

Line 4328: FND_MSG_PUB.ADD;

4324: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4325:
4326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4327: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
4328: FND_MSG_PUB.ADD;
4329: END IF;
4330:
4331: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4389: end if;
4390:
4391: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4392:
4393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4394: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');
4395: FND_MSG_PUB.ADD;
4396: END IF;
4397: RAISE FND_API.G_EXC_ERROR;

Line 4395: FND_MSG_PUB.ADD;

4391: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4392:
4393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4394: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');
4395: FND_MSG_PUB.ADD;
4396: END IF;
4397: RAISE FND_API.G_EXC_ERROR;
4398: END IF;
4399:

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

4410: end if;
4411:
4412: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4413:
4414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4415: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4416: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4417: FND_MSG_PUB.ADD;
4418: END IF;

Line 4417: FND_MSG_PUB.ADD;

4413:
4414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4415: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4416: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4417: FND_MSG_PUB.ADD;
4418: END IF;
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421:

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

4432: end if;
4433:
4434: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4435:
4436: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4437: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4438: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4439: FND_MSG_PUB.ADD;
4440: END IF;

Line 4439: FND_MSG_PUB.ADD;

4435:
4436: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4437: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4438: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4439: FND_MSG_PUB.ADD;
4440: END IF;
4441: RAISE FND_API.G_EXC_ERROR;
4442: END IF;
4443:

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

4456: end if;
4457:
4458: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4459:
4460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4461: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4462: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4463: FND_MSG_PUB.ADD;
4464: END IF;

Line 4463: FND_MSG_PUB.ADD;

4459:
4460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4461: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4462: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4463: FND_MSG_PUB.ADD;
4464: END IF;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467:

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

4491: end if;
4492:
4493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4494:
4495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4496: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
4497: FND_MSG_PUB.ADD;
4498: END IF;
4499: RAISE FND_API.G_EXC_ERROR;

Line 4497: FND_MSG_PUB.ADD;

4493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4494:
4495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4496: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
4497: FND_MSG_PUB.ADD;
4498: END IF;
4499: RAISE FND_API.G_EXC_ERROR;
4500: END IF;
4501:

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

4789: END IF;
4790:
4791: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4792:
4793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4794: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4795: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4796: FND_MSG_PUB.ADD;
4797: END IF;

Line 4796: FND_MSG_PUB.ADD;

4792:
4793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4794: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4795: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4796: FND_MSG_PUB.ADD;
4797: END IF;
4798: RAISE FND_API.G_EXC_ERROR;
4799: END IF;
4800:

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

4820: END IF;
4821:
4822: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4823:
4824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4825: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4826: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4827: FND_MSG_PUB.ADD;
4828: END IF;

Line 4827: FND_MSG_PUB.ADD;

4823:
4824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4825: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4826: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4827: FND_MSG_PUB.ADD;
4828: END IF;
4829: RAISE FND_API.G_EXC_ERROR;
4830: END IF;
4831:

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

4846: END IF;
4847:
4848: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4849:
4850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4852: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4853: FND_MSG_PUB.ADD;
4854: END IF;

Line 4853: FND_MSG_PUB.ADD;

4849:
4850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4852: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4853: FND_MSG_PUB.ADD;
4854: END IF;
4855: RAISE FND_API.G_EXC_ERROR;
4856: END IF;
4857:

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

4877: END IF;
4878:
4879: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4880:
4881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4882: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4883: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4884: FND_MSG_PUB.ADD;
4885: END IF;

Line 4884: FND_MSG_PUB.ADD;

4880:
4881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4882: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4883: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4884: FND_MSG_PUB.ADD;
4885: END IF;
4886: RAISE FND_API.G_EXC_ERROR;
4887: END IF;
4888:

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

4910: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4911:
4912: IF l_hd_payment_tbl.count > 1 THEN
4913:
4914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4915: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
4916: FND_MSG_PUB.ADD;
4917: END IF;
4918: RAISE FND_API.G_EXC_ERROR;

Line 4916: FND_MSG_PUB.ADD;

4912: IF l_hd_payment_tbl.count > 1 THEN
4913:
4914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4915: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
4916: FND_MSG_PUB.ADD;
4917: END IF;
4918: RAISE FND_API.G_EXC_ERROR;
4919:
4920: ELSIF l_hd_payment_tbl.count = 1 THEN

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

4920: ELSIF l_hd_payment_tbl.count = 1 THEN
4921:
4922: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
4923:
4924: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4925: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
4926: FND_MSG_PUB.ADD;
4927: END IF;
4928: RAISE FND_API.G_EXC_ERROR;

Line 4926: FND_MSG_PUB.ADD;

4922: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
4923:
4924: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4925: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
4926: FND_MSG_PUB.ADD;
4927: END IF;
4928: RAISE FND_API.G_EXC_ERROR;
4929: END IF;
4930:

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

4939: FOR i IN 1..l_hd_payment_tbl.count LOOP
4940:
4941: IF l_hd_payment_tbl(i).payment_option <> 'SPLIT' THEN
4942:
4943: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4944: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
4945: FND_MSG_PUB.ADD;
4946: END IF;
4947: RAISE FND_API.G_EXC_ERROR;

Line 4945: FND_MSG_PUB.ADD;

4941: IF l_hd_payment_tbl(i).payment_option <> 'SPLIT' THEN
4942:
4943: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4944: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
4945: FND_MSG_PUB.ADD;
4946: END IF;
4947: RAISE FND_API.G_EXC_ERROR;
4948: END IF;
4949:

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

4952: END IF;
4953:
4954: IF l_hd_tax_detail_tbl.count > 1 THEN
4955:
4956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4957: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
4958: FND_MSG_PUB.ADD;
4959: END IF;
4960: RAISE FND_API.G_EXC_ERROR;

Line 4958: FND_MSG_PUB.ADD;

4954: IF l_hd_tax_detail_tbl.count > 1 THEN
4955:
4956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4957: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
4958: FND_MSG_PUB.ADD;
4959: END IF;
4960: RAISE FND_API.G_EXC_ERROR;
4961: END IF;
4962:

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

5483: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5484:
5485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5486:
5487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5488: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5489: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5490: FND_MSG_PUB.ADD;
5491: END IF;

Line 5490: FND_MSG_PUB.ADD;

5486:
5487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5488: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5489: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5490: FND_MSG_PUB.ADD;
5491: END IF;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493:
5494: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

5779:
5780: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5781:
5782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5784: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5785: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5786: FND_MSG_PUB.ADD;
5787: END IF;

Line 5786: FND_MSG_PUB.ADD;

5782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5784: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5785: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5786: FND_MSG_PUB.ADD;
5787: END IF;
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789:
5790: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

5898:
5899: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5900:
5901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5903: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5904: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
5905: FND_MSG_PUB.ADD;
5906: END IF;

Line 5905: FND_MSG_PUB.ADD;

5901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5903: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5904: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
5905: FND_MSG_PUB.ADD;
5906: END IF;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908:
5909: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

6080: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6081:
6082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6083:
6084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6086: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6087: FND_MSG_PUB.ADD;
6088: END IF;

Line 6087: FND_MSG_PUB.ADD;

6083:
6084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6086: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6087: FND_MSG_PUB.ADD;
6088: END IF;
6089:
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6091:

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

6152: END IF;
6153: */
6154: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6155:
6156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6157: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6158: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6159: FND_MSG_PUB.ADD;
6160: END IF;

Line 6159: FND_MSG_PUB.ADD;

6155:
6156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6157: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6158: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6159: FND_MSG_PUB.ADD;
6160: END IF;
6161:
6162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6353: END IF;
6354:
6355: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6356:
6357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6358: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6359: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6360: FND_MSG_PUB.ADD;
6361: END IF;

Line 6360: FND_MSG_PUB.ADD;

6356:
6357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6358: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6359: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6360: FND_MSG_PUB.ADD;
6361: END IF;
6362:
6363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6412: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6413:
6414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6415:
6416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6417: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6418: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6419: FND_MSG_PUB.ADD;
6420: END IF;

Line 6419: FND_MSG_PUB.ADD;

6415:
6416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6417: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6418: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6419: FND_MSG_PUB.ADD;
6420: END IF;
6421:
6422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6423:

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

6451: X_Msg_Data => X_Msg_Data );
6452:
6453: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6454:
6455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6456: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');
6457: FND_MSG_PUB.ADD;
6458: END IF;
6459:

Line 6457: FND_MSG_PUB.ADD;

6453: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6454:
6455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6456: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');
6457: FND_MSG_PUB.ADD;
6458: END IF;
6459:
6460: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6495:
6496:
6497: -- Standard call to get message count and if count is 1, get message info.
6498:
6499: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6500: p_data => x_msg_data );
6501:
6502: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6503: aso_debug_pub.add('******************************************************', 1, 'Y');

Line 6515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

6511: WHEN FND_API.G_EXC_ERROR THEN
6512: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6513: P_API_NAME => L_API_NAME
6514: ,P_PKG_NAME => G_PKG_NAME
6515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6516: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6517: ,P_SQLCODE => SQLCODE
6518: ,P_SQLERRM => SQLERRM
6519: ,X_MSG_COUNT => X_MSG_COUNT

Line 6527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6524: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6525: P_API_NAME => L_API_NAME
6526: ,P_PKG_NAME => G_PKG_NAME
6527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6528: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6529: ,P_SQLCODE => SQLCODE
6530: ,P_SQLERRM => SQLERRM
6531: ,X_MSG_COUNT => X_MSG_COUNT

Line 6937: FND_MSG_PUB.initialize;

6933: END IF;
6934:
6935: -- Initialize message list if p_init_msg_list is set to TRUE.
6936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6937: FND_MSG_PUB.initialize;
6938: END IF;
6939:
6940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6941: aso_debug_pub.add('Update_Quote - Begin ', 1, 'Y');

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

6962: -- Validate Environment
6963: -- ******************************************************************
6964: IF FND_GLOBAL.User_Id IS NULL THEN
6965:
6966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6967: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
6968: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
6969: FND_MSG_PUB.ADD;
6970: END IF;

Line 6969: FND_MSG_PUB.ADD;

6965:
6966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6967: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
6968: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
6969: FND_MSG_PUB.ADD;
6970: END IF;
6971: RAISE FND_API.G_EXC_ERROR;
6972: END IF;
6973:

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

7002: l_order_type_id,l_order_id,l_object_version_number, l_currency_code, l_price_list_id;
7003:
7004: If ( C_Get_quote%NOTFOUND) Then
7005:
7006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7007: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7008: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7009: FND_MSG_PUB.Add;
7010: END IF;

Line 7009: FND_MSG_PUB.Add;

7005:
7006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7007: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7008: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7009: FND_MSG_PUB.Add;
7010: END IF;
7011: raise FND_API.G_EXC_ERROR;
7012:
7013: END IF;

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

7026: END IF;
7027:
7028: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
7029:
7030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7032: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7033: FND_MSG_PUB.ADD;
7034: END IF;

Line 7033: FND_MSG_PUB.ADD;

7029:
7030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7032: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7033: FND_MSG_PUB.ADD;
7034: END IF;
7035: raise FND_API.G_EXC_ERROR;
7036:
7037: End if;

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

7038:
7039: -- Check Whether record has been changed by someone else
7040: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
7041:
7042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7043: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7044: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7045: FND_MSG_PUB.ADD;
7046: END IF;

Line 7045: FND_MSG_PUB.ADD;

7041:
7042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7043: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7044: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7045: FND_MSG_PUB.ADD;
7046: END IF;
7047: raise FND_API.G_EXC_ERROR;
7048:
7049: End if;

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

7057: END IF;
7058:
7059: If (l_object_version_number <> p_qte_header_rec.object_version_number) then
7060:
7061: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7062: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7063: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7064: FND_MSG_PUB.ADD;
7065: END IF;

Line 7064: FND_MSG_PUB.ADD;

7060:
7061: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7062: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7063: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7064: FND_MSG_PUB.ADD;
7065: END IF;
7066: raise FND_API.G_EXC_ERROR;
7067:
7068: End If;

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

7076: x_status => x_status);
7077:
7078: if (x_status = FND_API.G_TRUE) then
7079:
7080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7081: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
7082: FND_MSG_PUB.ADD;
7083: end if;
7084: raise FND_API.G_EXC_ERROR;

Line 7082: FND_MSG_PUB.ADD;

7078: if (x_status = FND_API.G_TRUE) then
7079:
7080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7081: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
7082: FND_MSG_PUB.ADD;
7083: end if;
7084: raise FND_API.G_EXC_ERROR;
7085:
7086: end if;

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

7087: end if;
7088:
7089: IF l_order_id is NOT NULL and l_order_id <> FND_API.G_MISS_NUM THEN
7090:
7091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7092: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');
7093: FND_MSG_PUB.ADD;
7094: END IF;
7095: raise FND_API.G_EXC_ERROR;

Line 7093: FND_MSG_PUB.ADD;

7089: IF l_order_id is NOT NULL and l_order_id <> FND_API.G_MISS_NUM THEN
7090:
7091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7092: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');
7093: FND_MSG_PUB.ADD;
7094: END IF;
7095: raise FND_API.G_EXC_ERROR;
7096:
7097: END IF;

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

7211: , x_msg_data => x_msg_data);
7212:
7213: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7214:
7215: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7216: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
7217: FND_MSG_PUB.ADD;
7218: END IF;
7219:

Line 7217: FND_MSG_PUB.ADD;

7213: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7214:
7215: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7216: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
7217: FND_MSG_PUB.ADD;
7218: END IF;
7219:
7220: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
7221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7337: x_msg_data => x_msg_data);
7338:
7339: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7340:
7341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7342: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7343: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7344: FND_MSG_PUB.ADD;
7345: END IF;

Line 7344: FND_MSG_PUB.ADD;

7340:
7341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7342: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7343: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7344: FND_MSG_PUB.ADD;
7345: END IF;
7346: RAISE FND_API.G_EXC_ERROR;
7347:
7348: END IF;

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

7357: x_msg_data => x_msg_data);
7358:
7359: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7360:
7361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7362: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7363: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7364: FND_MSG_PUB.ADD;
7365: END IF;

Line 7364: FND_MSG_PUB.ADD;

7360:
7361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7362: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7363: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7364: FND_MSG_PUB.ADD;
7365: END IF;
7366: RAISE FND_API.G_EXC_ERROR;
7367: END IF;
7368:

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

7377: x_msg_data => x_msg_data);
7378:
7379: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7380:
7381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7382: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7383: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7384: FND_MSG_PUB.ADD;
7385: END IF;

Line 7384: FND_MSG_PUB.ADD;

7380:
7381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7382: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7383: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7384: FND_MSG_PUB.ADD;
7385: END IF;
7386: RAISE FND_API.G_EXC_ERROR;
7387: END IF;
7388:

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

7431: x_msg_data => x_msg_data);
7432:
7433: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7434:
7435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7436: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');
7437: FND_MSG_PUB.ADD;
7438: END IF;
7439: RAISE FND_API.G_EXC_ERROR;

Line 7437: FND_MSG_PUB.ADD;

7433: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7434:
7435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7436: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');
7437: FND_MSG_PUB.ADD;
7438: END IF;
7439: RAISE FND_API.G_EXC_ERROR;
7440: END IF;
7441:

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

7448: x_msg_data => x_msg_data);
7449:
7450: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7451:
7452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7453: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7454: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
7455: FND_MSG_PUB.ADD;
7456: END IF;

Line 7455: FND_MSG_PUB.ADD;

7451:
7452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7453: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7454: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
7455: FND_MSG_PUB.ADD;
7456: END IF;
7457: RAISE FND_API.G_EXC_ERROR;
7458: END IF;
7459:

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

7466: x_msg_data => x_msg_data);
7467:
7468: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7469:
7470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7471: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7472: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
7473: FND_MSG_PUB.ADD;
7474: END IF;

Line 7473: FND_MSG_PUB.ADD;

7469:
7470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7471: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7472: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
7473: FND_MSG_PUB.ADD;
7474: END IF;
7475: RAISE FND_API.G_EXC_ERROR;
7476: END IF;
7477:

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

7489: x_msg_data => x_msg_data);
7490:
7491: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7492:
7493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7494: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
7495: FND_MSG_PUB.ADD;
7496: END IF;
7497: RAISE FND_API.G_EXC_ERROR;

Line 7495: FND_MSG_PUB.ADD;

7491: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7492:
7493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7494: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
7495: FND_MSG_PUB.ADD;
7496: END IF;
7497: RAISE FND_API.G_EXC_ERROR;
7498: END IF;
7499: END IF;

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

7515: x_msg_data => x_msg_data);
7516:
7517: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7518:
7519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7520: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
7521: FND_MSG_PUB.ADD;
7522: END IF;
7523: RAISE FND_API.G_EXC_ERROR;

Line 7521: FND_MSG_PUB.ADD;

7517: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7518:
7519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7520: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
7521: FND_MSG_PUB.ADD;
7522: END IF;
7523: RAISE FND_API.G_EXC_ERROR;
7524: END IF;
7525:

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

7628: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
7629:
7630: IF l_qte_header_rec.currency_code IS NULL THEN
7631:
7632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7633: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7634: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
7635: FND_MSG_PUB.ADD;
7636: END IF;

Line 7635: FND_MSG_PUB.ADD;

7631:
7632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7633: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7634: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
7635: FND_MSG_PUB.ADD;
7636: END IF;
7637: RAISE FND_API.G_EXC_ERROR;
7638: END IF;
7639:

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

7651: x_msg_data => x_msg_data);
7652:
7653: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7654:
7655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7656: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7657: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
7658: FND_MSG_PUB.ADD;
7659: END IF;

Line 7658: FND_MSG_PUB.ADD;

7654:
7655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7656: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7657: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
7658: FND_MSG_PUB.ADD;
7659: END IF;
7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;
7662:

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

7673: x_msg_data => x_msg_data);
7674:
7675: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7676:
7677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7678: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7679: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
7680: FND_MSG_PUB.ADD;
7681: END IF;

Line 7680: FND_MSG_PUB.ADD;

7676:
7677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7678: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
7679: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
7680: FND_MSG_PUB.ADD;
7681: END IF;
7682:
7683: RAISE FND_API.G_EXC_ERROR;
7684: END IF;

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

7697: x_msg_data => x_msg_data);
7698:
7699: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7700:
7701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7702: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
7703: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
7704: FND_MSG_PUB.ADD;
7705: END IF;

Line 7704: FND_MSG_PUB.ADD;

7700:
7701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7702: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
7703: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
7704: FND_MSG_PUB.ADD;
7705: END IF;
7706: RAISE FND_API.G_EXC_ERROR;
7707: END IF;
7708:

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

7768: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
7769:
7770: IF l_hd_payment_tbl.count > 1 THEN
7771:
7772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7773: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
7774: FND_MSG_PUB.ADD;
7775: END IF;
7776: RAISE FND_API.G_EXC_ERROR;

Line 7774: FND_MSG_PUB.ADD;

7770: IF l_hd_payment_tbl.count > 1 THEN
7771:
7772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7773: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
7774: FND_MSG_PUB.ADD;
7775: END IF;
7776: RAISE FND_API.G_EXC_ERROR;
7777:
7778: ELSIF l_hd_payment_tbl.count = 1 THEN

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

7778: ELSIF l_hd_payment_tbl.count = 1 THEN
7779:
7780: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
7781:
7782: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7783: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
7784: FND_MSG_PUB.ADD;
7785: END IF;
7786: RAISE FND_API.G_EXC_ERROR;

Line 7784: FND_MSG_PUB.ADD;

7780: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
7781:
7782: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7783: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
7784: FND_MSG_PUB.ADD;
7785: END IF;
7786: RAISE FND_API.G_EXC_ERROR;
7787: END IF;
7788:

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

7800: WHILE l_index IS NOT NULL LOOP
7801:
7802: IF l_payment_db_tbl(l_index) <> 'SPLIT' THEN
7803:
7804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7805: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
7806: FND_MSG_PUB.ADD;
7807: END IF;
7808: RAISE FND_API.G_EXC_ERROR;

Line 7806: FND_MSG_PUB.ADD;

7802: IF l_payment_db_tbl(l_index) <> 'SPLIT' THEN
7803:
7804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7805: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
7806: FND_MSG_PUB.ADD;
7807: END IF;
7808: RAISE FND_API.G_EXC_ERROR;
7809: END IF;
7810: l_index := l_payment_db_tbl.next(l_index);

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

7839: END LOOP;
7840:
7841: IF l_shipment_db_tbl.count > 1 THEN
7842:
7843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7844: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
7845: FND_MSG_PUB.ADD;
7846: END IF;
7847: RAISE FND_API.G_EXC_ERROR;

Line 7845: FND_MSG_PUB.ADD;

7841: IF l_shipment_db_tbl.count > 1 THEN
7842:
7843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7844: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
7845: FND_MSG_PUB.ADD;
7846: END IF;
7847: RAISE FND_API.G_EXC_ERROR;
7848: END IF;
7849:

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

7872: END LOOP;
7873:
7874: IF l_tax_db_tbl.count > 1 THEN
7875:
7876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7877: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
7878: FND_MSG_PUB.ADD;
7879: END IF;
7880: RAISE FND_API.G_EXC_ERROR;

Line 7878: FND_MSG_PUB.ADD;

7874: IF l_tax_db_tbl.count > 1 THEN
7875:
7876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7877: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
7878: FND_MSG_PUB.ADD;
7879: END IF;
7880: RAISE FND_API.G_EXC_ERROR;
7881:
7882: END IF;

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

8683:
8684:
8685: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8688: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
8689: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
8690: FND_MSG_PUB.ADD;
8691: END IF;

Line 8690: FND_MSG_PUB.ADD;

8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8688: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
8689: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
8690: FND_MSG_PUB.ADD;
8691: END IF;
8692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8694: x_return_status := FND_API.G_RET_STS_ERROR;

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

9130: END IF;
9131:
9132: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9135: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9136: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
9137: FND_MSG_PUB.ADD;
9138: END IF;

Line 9137: FND_MSG_PUB.ADD;

9133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9135: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9136: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
9137: FND_MSG_PUB.ADD;
9138: END IF;
9139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9140:
9141: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

9235: := l_price_adj_tbl(j).price_adjustment_id;
9236: END LOOP;
9237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9240: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9241: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
9242: FND_MSG_PUB.ADD;
9243: END IF;

Line 9242: FND_MSG_PUB.ADD;

9238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9240: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9241: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
9242: FND_MSG_PUB.ADD;
9243: END IF;
9244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9245: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9246: x_return_status := FND_API.G_RET_STS_ERROR;

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

9576: := l_price_adj_tbl(j).price_adjustment_id;
9577: END LOOP;
9578: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9581: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9582: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
9583: FND_MSG_PUB.ADD;
9584: END IF;

Line 9583: FND_MSG_PUB.ADD;

9579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9581: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9582: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
9583: FND_MSG_PUB.ADD;
9584: END IF;
9585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9586: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9587: x_return_status := FND_API.G_RET_STS_ERROR;

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

9626: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9627:
9628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9629:
9630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9631: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9632: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
9633: FND_MSG_PUB.ADD;
9634: END IF;

Line 9633: FND_MSG_PUB.ADD;

9629:
9630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9631: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9632: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
9633: FND_MSG_PUB.ADD;
9634: END IF;
9635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9636:
9637: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

9770: END IF;
9771:
9772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9773:
9774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9775: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9776: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9777: FND_MSG_PUB.ADD;
9778: END IF;

Line 9777: FND_MSG_PUB.ADD;

9773:
9774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9775: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
9776: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
9777: FND_MSG_PUB.ADD;
9778: END IF;
9779:
9780: RAISE FND_API.G_EXC_ERROR;
9781:

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

10150: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10151:
10152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10153:
10154: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10155:
10156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10157: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10158: FND_MSG_PUB.ADD;

Line 10158: FND_MSG_PUB.ADD;

10154: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10155:
10156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10157: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10158: FND_MSG_PUB.ADD;
10159:
10160: END IF;
10161:
10162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

10236: END IF;
10237: end if;
10238:
10239: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
10240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10241: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
10242: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
10243: FND_MSG_PUB.ADD;
10244: END IF;

Line 10243: FND_MSG_PUB.ADD;

10239: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
10240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10241: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
10242: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
10243: FND_MSG_PUB.ADD;
10244: END IF;
10245:
10246: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

10424: 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;
10425:
10426: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
10427:
10428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10429: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
10430: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
10431: FND_MSG_PUB.ADD;
10432: END IF;

Line 10431: FND_MSG_PUB.ADD;

10427:
10428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10429: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
10430: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
10431: FND_MSG_PUB.ADD;
10432: END IF;
10433:
10434: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

10481:
10482: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10483:
10484:
10485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10486: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10487: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
10488: FND_MSG_PUB.ADD;
10489: END IF;

Line 10488: FND_MSG_PUB.ADD;

10484:
10485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10486: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10487: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
10488: FND_MSG_PUB.ADD;
10489: END IF;
10490:
10491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10492:

Line 10524: FND_MSG_PUB.Count_And_Get

10520: COMMIT WORK;
10521: END IF;
10522:
10523: -- Standard call to get message count and if count is 1, get message info.
10524: FND_MSG_PUB.Count_And_Get
10525: ( p_count => x_msg_count,
10526: p_data => x_msg_data
10527: );
10528:

Line 10534: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

10530: WHEN FND_API.G_EXC_ERROR THEN
10531: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10532: P_API_NAME => L_API_NAME
10533: ,P_PKG_NAME => G_PKG_NAME
10534: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10535: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10536: ,P_SQLCODE => SQLCODE
10537: ,P_SQLERRM => SQLERRM
10538: ,X_MSG_COUNT => X_MSG_COUNT

Line 10546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10543: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10544: P_API_NAME => L_API_NAME
10545: ,P_PKG_NAME => G_PKG_NAME
10546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10547: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10548: ,P_SQLCODE => SQLCODE
10549: ,P_SQLERRM => SQLERRM
10550: ,X_MSG_COUNT => X_MSG_COUNT

Line 10609: FND_MSG_PUB.initialize;

10605:
10606: -- Initialize message list if p_init_msg_list is set to TRUE.
10607: IF FND_API.to_Boolean( p_init_msg_list )
10608: THEN
10609: FND_MSG_PUB.initialize;
10610: END IF;
10611:
10612:
10613: -- Initialize API return status to SUCCESS

Line 10723: FND_MSG_PUB.Count_And_Get

10719: END IF;
10720:
10721:
10722: -- Standard call to get message count and if count is 1, get message info.
10723: FND_MSG_PUB.Count_And_Get
10724: ( p_count => x_msg_count,
10725: p_data => x_msg_data
10726: );
10727:

Line 10733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

10729: WHEN FND_API.G_EXC_ERROR THEN
10730: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10731: P_API_NAME => L_API_NAME
10732: ,P_PKG_NAME => G_PKG_NAME
10733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10734: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10735: ,P_SQLCODE => SQLCODE
10736: ,P_SQLERRM => SQLERRM
10737: ,X_MSG_COUNT => X_MSG_COUNT

Line 10745: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10742: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10743: P_API_NAME => L_API_NAME
10744: ,P_PKG_NAME => G_PKG_NAME
10745: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10746: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10747: ,P_SQLCODE => SQLCODE
10748: ,P_SQLERRM => SQLERRM
10749: ,X_MSG_COUNT => X_MSG_COUNT

Line 10977: FND_MSG_PUB.initialize;

10973: END IF;
10974:
10975: -- Initialize message list if p_init_msg_list is set to TRUE.
10976: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10977: FND_MSG_PUB.initialize;
10978: END IF;
10979:
10980: -- Debug Message
10981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

10977: FND_MSG_PUB.initialize;
10978: END IF;
10979:
10980: -- Debug Message
10981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
10982: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
10983: FND_MSG_PUB.Add;
10984: END IF;
10985:

Line 10983: FND_MSG_PUB.Add;

10979:
10980: -- Debug Message
10981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
10982: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
10983: FND_MSG_PUB.Add;
10984: END IF;
10985:
10986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10987: aso_debug_pub.add('p_qte_header_id: '||p_qte_header_id,1,'N');

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

11068: -- ******************************************************************
11069: -- Validate Environment
11070: -- ******************************************************************
11071: IF FND_GLOBAL.User_Id IS NULL THEN
11072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11073: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
11074: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
11075: FND_MSG_PUB.ADD;
11076: END IF;

Line 11075: FND_MSG_PUB.ADD;

11071: IF FND_GLOBAL.User_Id IS NULL THEN
11072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11073: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
11074: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
11075: FND_MSG_PUB.ADD;
11076: END IF;
11077: RAISE FND_API.G_EXC_ERROR;
11078: END IF;
11079: -- ******************************************************************

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

11080: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
11081: OPEN C_Validate_Quote (p_qte_header_id);
11082: FETCH C_Validate_Quote into l_val;
11083: IF C_Validate_Quote%NOTFOUND THEN
11084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
11086: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
11087: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
11088: FND_MSG_PUB.ADD;

Line 11088: FND_MSG_PUB.ADD;

11084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
11086: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
11087: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
11088: FND_MSG_PUB.ADD;
11089: END IF;
11090: CLOSE C_Validate_Quote;
11091: RAISE FND_API.G_EXC_ERROR;
11092: END IF;

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

11116: CLOSE C_Qte_Number;
11117: l_qte_header_rec.quote_version := 1;
11118: l_first_version := FND_API.G_TRUE;
11119: ELSE
11120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11121: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11122: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
11123: FND_MSG_PUB.ADD;
11124: END IF;

Line 11123: FND_MSG_PUB.ADD;

11119: ELSE
11120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11121: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11122: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
11123: FND_MSG_PUB.ADD;
11124: END IF;
11125: RAISE FND_API.G_EXC_ERROR;
11126: END IF; -- profile auto numbering
11127: ELSE

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

11129: FETCH C_Qte_Number_Exists into l_qte_num;
11130: CLOSE C_Qte_Number_Exists;
11131: IF (FND_PROFILE.Value('ASO_AUTO_NUMBERING') = 'N'
11132: AND l_qte_num = p_qte_number) THEN
11133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
11134: THEN
11135: */ -- original cpy_qte
11136: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
11137: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

Line 11141: FND_MSG_PUB.ADD;

11137: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
11138: */
11139: /* -- original cpy_qte
11140: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
11141: FND_MSG_PUB.ADD;
11142: END IF;
11143: RAISE FND_API.G_EXC_ERROR;
11144: ELSE
11145: l_qte_header_rec.quote_number := p_qte_number;

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

11155: FETCH C_Qte_Number_Exists into l_qte_num;
11156:
11157: IF C_Qte_Number_Exists%NOTFOUND THEN
11158:
11159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11160: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
11161: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
11162: FND_MSG_PUB.ADD;
11163: END IF;

Line 11162: FND_MSG_PUB.ADD;

11158:
11159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11160: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
11161: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
11162: FND_MSG_PUB.ADD;
11163: END IF;
11164:
11165: CLOSE C_Qte_Number_Exists;
11166: RAISE FND_API.G_EXC_ERROR;

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

11193: IF l_first_version = FND_API.G_FALSE THEN
11194: OPEN c_qte_status_trans (l_qte_header_rec.quote_status_id, p_qte_status_id);
11195: FETCH c_qte_status_trans INTO l_enabled_flag;
11196: IF c_qte_status_trans%NOTFOUND OR l_enabled_flag = 'N' THEN
11197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11198: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
11199: FND_MSG_PUB.ADD;
11200: END IF;
11201: CLOSE c_qte_status_trans;

Line 11199: FND_MSG_PUB.ADD;

11195: FETCH c_qte_status_trans INTO l_enabled_flag;
11196: IF c_qte_status_trans%NOTFOUND OR l_enabled_flag = 'N' THEN
11197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11198: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
11199: FND_MSG_PUB.ADD;
11200: END IF;
11201: CLOSE c_qte_status_trans;
11202: RAISE FND_API.G_EXC_ERROR;
11203: END IF;

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

11243:
11244:
11245: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11248: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11249: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11250: FND_MSG_PUB.ADD;
11251: END IF;

Line 11250: FND_MSG_PUB.ADD;

11246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11248: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11249: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11250: FND_MSG_PUB.ADD;
11251: END IF;
11252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11253: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
11254: x_return_status := FND_API.G_RET_STS_ERROR;

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

11252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11253: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
11254: x_return_status := FND_API.G_RET_STS_ERROR;
11255: */ -- original cpy_qte
11256: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11257: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
11258: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11259: FND_MSG_PUB.ADD;
11260: END IF; */

Line 11259: FND_MSG_PUB.ADD;

11255: */ -- original cpy_qte
11256: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11257: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
11258: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11259: FND_MSG_PUB.ADD;
11260: END IF; */
11261: /* -- original cpy_qte
11262: RAISE FND_API.G_EXC_ERROR;
11263: END IF;

Line 11278: FND_MSG_PUB.Count_And_Get

11274:
11275:
11276:
11277: -- Standard call to get message count and if count is 1, get message info.
11278: FND_MSG_PUB.Count_And_Get
11279: ( p_count => x_msg_count,
11280: p_data => x_msg_data
11281: );
11282:

Line 11288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

11284: WHEN FND_API.G_EXC_ERROR THEN
11285: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11286: P_API_NAME => L_API_NAME
11287: ,P_PKG_NAME => G_PKG_NAME
11288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11289: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11290: ,X_MSG_COUNT => X_MSG_COUNT
11291: ,X_MSG_DATA => X_MSG_DATA
11292: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 11298: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11295: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11296: P_API_NAME => L_API_NAME
11297: ,P_PKG_NAME => G_PKG_NAME
11298: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11299: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11300: ,X_MSG_COUNT => X_MSG_COUNT
11301: ,X_MSG_DATA => X_MSG_DATA
11302: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 11861: FND_MSG_PUB.initialize;

11857:
11858: -- Initialize message list if p_init_msg_list is set to TRUE.
11859: IF FND_API.to_Boolean( p_init_msg_list )
11860: THEN
11861: FND_MSG_PUB.initialize;
11862: END IF;
11863:
11864:
11865:

Line 11991: FND_MSG_PUB.Count_And_Get

11987:
11988:
11989:
11990: -- Standard call to get message count and if count is 1, get message info.
11991: FND_MSG_PUB.Count_And_Get
11992: ( p_count => x_msg_count,
11993: p_data => x_msg_data
11994: );
11995:

Line 12001: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

11997: WHEN FND_API.G_EXC_ERROR THEN
11998: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11999: P_API_NAME => L_API_NAME
12000: ,P_PKG_NAME => G_PKG_NAME
12001: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12002: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12003: ,X_MSG_COUNT => X_MSG_COUNT
12004: ,X_MSG_DATA => X_MSG_DATA
12005: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12009: P_API_NAME => L_API_NAME
12010: ,P_PKG_NAME => G_PKG_NAME
12011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12013: ,X_MSG_COUNT => X_MSG_COUNT
12014: ,X_MSG_DATA => X_MSG_DATA
12015: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

12311: END IF;
12312:
12313: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12316: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12317: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
12318: FND_MSG_PUB.ADD;
12319: END IF;

Line 12318: FND_MSG_PUB.ADD;

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

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

12352: END IF;
12353:
12354: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12357: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12358: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12359: FND_MSG_PUB.ADD;
12360: END IF;

Line 12359: FND_MSG_PUB.ADD;

12355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12357: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12358: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12359: FND_MSG_PUB.ADD;
12360: END IF;
12361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12362: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12363: x_return_status := FND_API.G_RET_STS_ERROR;

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

12364: END IF;
12365:
12366: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12369: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12370: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12371: FND_MSG_PUB.ADD;
12372: END IF;

Line 12371: FND_MSG_PUB.ADD;

12367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12369: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12370: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12371: FND_MSG_PUB.ADD;
12372: END IF;
12373:
12374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12375: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

12602: END IF;
12603:
12604: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12607: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12608: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
12609: FND_MSG_PUB.ADD;
12610: END IF;

Line 12609: FND_MSG_PUB.ADD;

12605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12607: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12608: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
12609: FND_MSG_PUB.ADD;
12610: END IF;
12611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12612: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
12613: x_return_status := FND_API.G_RET_STS_ERROR;

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

12624: -- CLOSE line_id_from_config;
12625:
12626: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12629: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12630: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12631: FND_MSG_PUB.ADD;
12632: END IF;

Line 12631: FND_MSG_PUB.ADD;

12627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12629: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12630: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12631: FND_MSG_PUB.ADD;
12632: END IF;
12633:
12634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12635: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 12701: FND_MSG_PUB.initialize;

12697:
12698: -- Initialize message list if p_init_msg_list is set to TRUE.
12699: IF FND_API.to_Boolean( p_init_msg_list )
12700: THEN
12701: FND_MSG_PUB.initialize;
12702: END IF;
12703:
12704:
12705: -- Initialize API return status to SUCCESS

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

12740: ELSE
12741: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12742: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE IS NULL', 1, 'Y');
12743: END IF;
12744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12745: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');
12746: FND_MSG_PUB.ADD;
12747: x_return_status := FND_API.G_RET_STS_ERROR;
12748: END IF;

Line 12746: FND_MSG_PUB.ADD;

12742: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE IS NULL', 1, 'Y');
12743: END IF;
12744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12745: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');
12746: FND_MSG_PUB.ADD;
12747: x_return_status := FND_API.G_RET_STS_ERROR;
12748: END IF;
12749: END IF;
12750: END IF;

Line 12761: FND_MSG_PUB.Count_And_Get

12757: END IF;
12758:
12759:
12760: -- Standard call to get message count and if count is 1, get message info.
12761: FND_MSG_PUB.Count_And_Get
12762: ( p_count => x_msg_count,
12763: p_data => x_msg_data
12764: );
12765: