DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on FND_MESSAGE

Line 439: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
443:

Line 440: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

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;
443:
444: RAISE FND_API.G_EXC_ERROR;

Line 469: FND_MESSAGE.Set_Name('ASO', 'ASO_API_DUPLICATE_QTE_NUM');

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;
473: RAISE FND_API.G_EXC_ERROR;

Line 470: FND_MESSAGE.Set_Token('QTE_NUM', x_qte_header_rec.quote_number, FALSE);

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;
473: RAISE FND_API.G_EXC_ERROR;
474: ELSE

Line 566: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICE_LIST_CURRENCY_CODE');

562: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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;

Line 601: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

597: FETCH c_resource INTO l_resource_id;
598: IF c_resource%NOTFOUND OR l_resource_id IS NULL OR l_resource_id= FND_API.G_MISS_NUM THEN
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;

Line 602: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);

598: IF c_resource%NOTFOUND OR l_resource_id IS NULL OR l_resource_id= FND_API.G_MISS_NUM THEN
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:

Line 3741: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');

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:
3744: END IF;
3745:

Line 3820: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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;
3824:

Line 3821: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);

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;
3824:
3825: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4173: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
4177: RAISE FND_API.G_EXC_ERROR;

Line 4174: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
4177: RAISE FND_API.G_EXC_ERROR;
4178: END IF;

Line 4327: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');

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:
4331: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4394: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');

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;
4398: END IF;

Line 4415: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
4419: RAISE FND_API.G_EXC_ERROR;

Line 4416: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);

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;
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;

Line 4437: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
4441: RAISE FND_API.G_EXC_ERROR;

Line 4438: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);

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;
4441: RAISE FND_API.G_EXC_ERROR;
4442: END IF;

Line 4461: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
4465: RAISE FND_API.G_EXC_ERROR;

Line 4462: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);

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;
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;

Line 4496: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');

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;
4500: END IF;

Line 4794: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
4798: RAISE FND_API.G_EXC_ERROR;

Line 4795: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);

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;
4798: RAISE FND_API.G_EXC_ERROR;
4799: END IF;

Line 4825: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
4829: RAISE FND_API.G_EXC_ERROR;

Line 4826: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);

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;
4829: RAISE FND_API.G_EXC_ERROR;
4830: END IF;

Line 4851: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
4855: RAISE FND_API.G_EXC_ERROR;

Line 4852: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);

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;
4855: RAISE FND_API.G_EXC_ERROR;
4856: END IF;

Line 4882: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
4886: RAISE FND_API.G_EXC_ERROR;

Line 4883: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);

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;
4886: RAISE FND_API.G_EXC_ERROR;
4887: END IF;

Line 4915: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

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;
4919:

Line 4925: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

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;
4929: END IF;

Line 4944: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');

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;
4948: END IF;

Line 4957: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');

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;
4961: END IF;

Line 5488: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5489: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);

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;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493:

Line 5784: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5785: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);

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;
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789:

Line 5903: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5904: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908:

Line 6085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
6089:

Line 6086: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);

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;
6089:
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6157: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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;
6161:

Line 6158: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);

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;
6161:
6162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6358: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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;
6362:

Line 6359: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);

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;
6362:
6363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6417: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
6421:

Line 6418: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);

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;
6421:
6422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6456: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');

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:
6460: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6967: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
6971: RAISE FND_API.G_EXC_ERROR;

Line 6968: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
6971: RAISE FND_API.G_EXC_ERROR;
6972: END IF;

Line 7007: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');

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;
7011: raise FND_API.G_EXC_ERROR;

Line 7008: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);

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;
7011: raise FND_API.G_EXC_ERROR;
7012:

Line 7031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
7035: raise FND_API.G_EXC_ERROR;

Line 7032: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

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;
7035: raise FND_API.G_EXC_ERROR;
7036:

Line 7043: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

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;
7047: raise FND_API.G_EXC_ERROR;

Line 7044: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

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;
7047: raise FND_API.G_EXC_ERROR;
7048:

Line 7062: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

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;
7066: raise FND_API.G_EXC_ERROR;

Line 7063: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);

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;
7066: raise FND_API.G_EXC_ERROR;
7067:

Line 7081: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');

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;
7085:

Line 7092: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');

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;
7096:

Line 7216: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');

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:
7220: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7342: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
7346: RAISE FND_API.G_EXC_ERROR;

Line 7343: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);

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;
7346: RAISE FND_API.G_EXC_ERROR;
7347:

Line 7362: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
7366: RAISE FND_API.G_EXC_ERROR;

Line 7363: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);

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;
7366: RAISE FND_API.G_EXC_ERROR;
7367: END IF;

Line 7382: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
7386: RAISE FND_API.G_EXC_ERROR;

Line 7383: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);

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;
7386: RAISE FND_API.G_EXC_ERROR;
7387: END IF;

Line 7436: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');

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;
7440: END IF;

Line 7453: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
7457: RAISE FND_API.G_EXC_ERROR;

Line 7454: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);

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;
7457: RAISE FND_API.G_EXC_ERROR;
7458: END IF;

Line 7471: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
7475: RAISE FND_API.G_EXC_ERROR;

Line 7472: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);

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;
7475: RAISE FND_API.G_EXC_ERROR;
7476: END IF;

Line 7494: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');

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;
7498: END IF;

Line 7520: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');

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;
7524: END IF;

Line 7633: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
7637: RAISE FND_API.G_EXC_ERROR;

Line 7634: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);

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;
7637: RAISE FND_API.G_EXC_ERROR;
7638: END IF;

Line 7656: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
7660: RAISE FND_API.G_EXC_ERROR;

Line 7657: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);

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;
7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;

Line 7678: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');

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;
7682:

Line 7679: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);

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;
7682:
7683: RAISE FND_API.G_EXC_ERROR;

Line 7702: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');

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;
7706: RAISE FND_API.G_EXC_ERROR;

Line 7703: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);

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;
7706: RAISE FND_API.G_EXC_ERROR;
7707: END IF;

Line 7773: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

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;
7777:

Line 7783: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');

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;
7787: END IF;

Line 7805: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');

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;
7809: END IF;

Line 7844: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');

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;
7848: END IF;

Line 7877: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');

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;
7881:

Line 8688: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
8692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8689: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);

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;
8692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 9135: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
9139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9136: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
9139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9140:

Line 9240: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
9244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9241: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
9244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9245: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 9581: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
9585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9582: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);

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;
9585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9586: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 9631: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
9635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9632: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);

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;
9635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9636:

Line 9775: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

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;
9779:

Line 9776: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);

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;
9779:
9780: RAISE FND_API.G_EXC_ERROR;

Line 10156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
10159:
10160: END IF;

Line 10157: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
10159:
10160: END IF;
10161:

Line 10241: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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;
10245:

Line 10242: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);

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;
10245:
10246: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 10429: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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;
10433:

Line 10430: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);

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;
10433:
10434: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 10486: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
10490:

Line 10487: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);

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;
10490:
10491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10982: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');

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:
10986: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11073: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');

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;
11077: RAISE FND_API.G_EXC_ERROR;

Line 11074: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;
11077: RAISE FND_API.G_EXC_ERROR;
11078: END IF;

Line 11085: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
11089: END IF;

Line 11086: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);

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;
11089: END IF;
11090: CLOSE C_Validate_Quote;

Line 11087: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);

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;
11089: END IF;
11090: CLOSE C_Validate_Quote;
11091: RAISE FND_API.G_EXC_ERROR;

Line 11121: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
11125: RAISE FND_API.G_EXC_ERROR;

Line 11122: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

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;
11125: RAISE FND_API.G_EXC_ERROR;
11126: END IF; -- profile auto numbering

Line 11136: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');

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);
11138: */
11139: /* -- original cpy_qte
11140: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');

Line 11137: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

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);
11138: */
11139: /* -- original cpy_qte
11140: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
11141: FND_MSG_PUB.ADD;

Line 11140: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');

11136: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
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

Line 11160: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
11164:

Line 11161: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);

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;
11164:
11165: CLOSE C_Qte_Number_Exists;

Line 11198: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');

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;
11202: RAISE FND_API.G_EXC_ERROR;

Line 11248: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
11252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11249: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
11252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11253: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 11257: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_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; */
11261: /* -- original cpy_qte

Line 11258: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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; */
11261: /* -- original cpy_qte
11262: RAISE FND_API.G_EXC_ERROR;

Line 12316: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
12320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12317: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);

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;
12320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12321: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 12357: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
12361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12358: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
12361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12362: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 12369: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
12373:

Line 12370: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
12373:
12374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12607: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
12611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12608: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);

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;
12611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12612: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 12629: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');

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;
12633:

Line 12630: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);

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;
12633:
12634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12745: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');

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;
12749: END IF;