[Home] [Help]
436:
437: END IF;
438:
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
441: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444:
437: END IF;
438:
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
441: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444:
445: RAISE FND_API.G_EXC_ERROR;
466:
467: CLOSE C_Qte_Version;
468:
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('ASO', 'ASO_API_DUPLICATE_QTE_NUM');
471: FND_MESSAGE.Set_Token('QTE_NUM', x_qte_header_rec.quote_number, FALSE);
472: FND_MSG_PUB.ADD;
473: END IF;
474: RAISE FND_API.G_EXC_ERROR;
467: CLOSE C_Qte_Version;
468:
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('ASO', 'ASO_API_DUPLICATE_QTE_NUM');
471: FND_MESSAGE.Set_Token('QTE_NUM', x_qte_header_rec.quote_number, FALSE);
472: FND_MSG_PUB.ADD;
473: END IF;
474: RAISE FND_API.G_EXC_ERROR;
475: ELSE
563: IF aso_debug_pub.g_debug_flag = 'Y' THEN
564: aso_debug_pub.add('Populate_qte_header: Currency_code can not be passed as NULL or G_MISS_CHAR when price_list_id is NULL',1,'N');
565: END IF;
566:
567: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICE_LIST_CURRENCY_CODE');
568: FND_MSG_PUB.ADD;
569: RAISE FND_API.G_EXC_ERROR;
570:
571: END IF;
598: FETCH c_resource INTO l_resource_id;
599: IF c_resource%NOTFOUND OR l_resource_id IS NULL OR l_resource_id= FND_API.G_MISS_NUM THEN
600: CLOSE c_resource;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
603: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
604: FND_MSG_PUB.ADD;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
599: IF c_resource%NOTFOUND OR l_resource_id IS NULL OR l_resource_id= FND_API.G_MISS_NUM THEN
600: CLOSE c_resource;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
603: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
604: FND_MSG_PUB.ADD;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
3819: END IF;
3820:
3821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3822:
3823: FND_MESSAGE.Set_Name('ASO', 'ASO_NEGATIVE_QUOTE_TOTAL');
3824: FND_MSG_PUB.ADD;
3825:
3826: END IF;
3827:
3898:
3899: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3900:
3901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3902: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3903: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3904: FND_MSG_PUB.ADD;
3905: END IF;
3906:
3899: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3900:
3901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3902: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3903: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
3904: FND_MSG_PUB.ADD;
3905: END IF;
3906:
3907: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4256:
4257: IF FND_GLOBAL.User_Id IS NULL THEN
4258:
4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4261: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4262: FND_MSG_PUB.ADD;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4257: IF FND_GLOBAL.User_Id IS NULL THEN
4258:
4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4261: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4262: FND_MSG_PUB.ADD;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4410:
4411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4412:
4413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
4415: FND_MSG_PUB.ADD;
4416: END IF;
4417:
4418: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4477:
4478: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4479:
4480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4481: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXPIRATION_DATE');
4482: FND_MSG_PUB.ADD;
4483: END IF;
4484: RAISE FND_API.G_EXC_ERROR;
4485: END IF;
4498:
4499: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4500:
4501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4502: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4503: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4504: FND_MSG_PUB.ADD;
4505: END IF;
4506: RAISE FND_API.G_EXC_ERROR;
4499: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4500:
4501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4502: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4503: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
4504: FND_MSG_PUB.ADD;
4505: END IF;
4506: RAISE FND_API.G_EXC_ERROR;
4507: END IF;
4520:
4521: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4522:
4523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4524: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4525: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4526: FND_MSG_PUB.ADD;
4527: END IF;
4528: RAISE FND_API.G_EXC_ERROR;
4521: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4522:
4523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4524: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4525: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
4526: FND_MSG_PUB.ADD;
4527: END IF;
4528: RAISE FND_API.G_EXC_ERROR;
4529: END IF;
4544:
4545: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4546:
4547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4549: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4550: FND_MSG_PUB.ADD;
4551: END IF;
4552: RAISE FND_API.G_EXC_ERROR;
4545: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4546:
4547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
4549: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_STATUS_ID', FALSE);
4550: FND_MSG_PUB.ADD;
4551: END IF;
4552: RAISE FND_API.G_EXC_ERROR;
4553: END IF;
4579:
4580: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4581:
4582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4583: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
4584: FND_MSG_PUB.ADD;
4585: END IF;
4586: RAISE FND_API.G_EXC_ERROR;
4587: END IF;
4877:
4878: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4879:
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4882: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4883: FND_MSG_PUB.ADD;
4884: END IF;
4885: RAISE FND_API.G_EXC_ERROR;
4878: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4879:
4880: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4882: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE_CODE', FALSE);
4883: FND_MSG_PUB.ADD;
4884: END IF;
4885: RAISE FND_API.G_EXC_ERROR;
4886: END IF;
4908:
4909: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4910:
4911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4912: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4913: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4914: FND_MSG_PUB.ADD;
4915: END IF;
4916: RAISE FND_API.G_EXC_ERROR;
4909: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4910:
4911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4912: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4913: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4914: FND_MSG_PUB.ADD;
4915: END IF;
4916: RAISE FND_API.G_EXC_ERROR;
4917: END IF;
4934:
4935: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4936:
4937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4939: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4940: FND_MSG_PUB.ADD;
4941: END IF;
4942: RAISE FND_API.G_EXC_ERROR;
4935: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4936:
4937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4938: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
4939: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
4940: FND_MSG_PUB.ADD;
4941: END IF;
4942: RAISE FND_API.G_EXC_ERROR;
4943: END IF;
4965:
4966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4970: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973: RAISE FND_API.G_EXC_ERROR;
4966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
4970: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973: RAISE FND_API.G_EXC_ERROR;
4974: END IF;
4998:
4999: IF l_hd_payment_tbl.count > 1 THEN
5000:
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5002: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5003: FND_MSG_PUB.ADD;
5004: END IF;
5005: RAISE FND_API.G_EXC_ERROR;
5006:
5008:
5009: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
5010:
5011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5012: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
5013: FND_MSG_PUB.ADD;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;
5016: END IF;
5027:
5028: IF l_hd_payment_tbl(i).payment_option <> 'SPLIT' THEN
5029:
5030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5031: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
5032: FND_MSG_PUB.ADD;
5033: END IF;
5034: RAISE FND_API.G_EXC_ERROR;
5035: END IF;
5040:
5041: IF l_hd_tax_detail_tbl.count > 1 THEN
5042:
5043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5044: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
5045: FND_MSG_PUB.ADD;
5046: END IF;
5047: RAISE FND_API.G_EXC_ERROR;
5048: END IF;
5571:
5572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5573:
5574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5575: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5576: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5573:
5574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5575: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5576: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER INSERT ROW', TRUE);
5577: FND_MSG_PUB.ADD;
5578: END IF;
5579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5580:
5867: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5868:
5869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5871: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5872: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5873: FND_MSG_PUB.ADD;
5874: END IF;
5875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5868:
5869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5871: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
5872: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER CREATE LINES', FALSE);
5873: FND_MSG_PUB.ADD;
5874: END IF;
5875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5876:
6005: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6006:
6007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6009: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6010: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
6011: FND_MSG_PUB.ADD;
6012: END IF;
6013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6006:
6007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6009: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6010: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
6011: FND_MSG_PUB.ADD;
6012: END IF;
6013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6014:
6219:
6220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6224: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6225: FND_MSG_PUB.ADD;
6226: END IF;
6227:
6220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6224: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER PRICING', TRUE);
6225: FND_MSG_PUB.ADD;
6226: END IF;
6227:
6228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6291: */
6292: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6293:
6294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6296: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6297: FND_MSG_PUB.ADD;
6298: END IF;
6299:
6292: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6293:
6294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6296: FND_MESSAGE.Set_Token('API', 'Calculate_tax_with_GTT', FALSE);
6297: FND_MSG_PUB.ADD;
6298: END IF;
6299:
6300: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6492:
6493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6494:
6495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6497: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6498: FND_MSG_PUB.ADD;
6499: END IF;
6500:
6493: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6494:
6495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
6497: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
6498: FND_MSG_PUB.ADD;
6499: END IF;
6500:
6501: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6551:
6552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6553:
6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6555: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6556: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6557: FND_MSG_PUB.ADD;
6558: END IF;
6559:
6552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6553:
6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6555: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
6556: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATETOTAL', TRUE);
6557: FND_MSG_PUB.ADD;
6558: END IF;
6559:
6560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6590:
6591: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6592:
6593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6594: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_TERMS');
6595: FND_MSG_PUB.ADD;
6596: END IF;
6597:
6598: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
7263: -- ******************************************************************
7264: IF FND_GLOBAL.User_Id IS NULL THEN
7265:
7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7267: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
7268: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
7269: FND_MSG_PUB.ADD;
7270: END IF;
7271: RAISE FND_API.G_EXC_ERROR;
7264: IF FND_GLOBAL.User_Id IS NULL THEN
7265:
7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7267: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
7268: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
7269: FND_MSG_PUB.ADD;
7270: END IF;
7271: RAISE FND_API.G_EXC_ERROR;
7272: END IF;
7300:
7301: If ( C_Get_quote%NOTFOUND) Then
7302:
7303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7304: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7305: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7306: FND_MSG_PUB.Add;
7307: END IF;
7308: raise FND_API.G_EXC_ERROR;
7301: If ( C_Get_quote%NOTFOUND) Then
7302:
7303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7304: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
7305: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
7306: FND_MSG_PUB.Add;
7307: END IF;
7308: raise FND_API.G_EXC_ERROR;
7309:
7324:
7325: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
7326:
7327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7329: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7330: FND_MSG_PUB.ADD;
7331: END IF;
7332: raise FND_API.G_EXC_ERROR;
7325: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
7326:
7327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
7329: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
7330: FND_MSG_PUB.ADD;
7331: END IF;
7332: raise FND_API.G_EXC_ERROR;
7333:
7336: -- Check Whether record has been changed by someone else
7337: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
7338:
7339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7340: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7341: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7342: FND_MSG_PUB.ADD;
7343: END IF;
7344: raise FND_API.G_EXC_ERROR;
7337: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
7338:
7339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7340: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7341: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7342: FND_MSG_PUB.ADD;
7343: END IF;
7344: raise FND_API.G_EXC_ERROR;
7345:
7356:
7357: If (l_object_version_number <> p_qte_header_rec.object_version_number) then
7358:
7359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7360: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7361: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7362: FND_MSG_PUB.ADD;
7363: END IF;
7364: raise FND_API.G_EXC_ERROR;
7357: If (l_object_version_number <> p_qte_header_rec.object_version_number) then
7358:
7359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7360: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
7361: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
7362: FND_MSG_PUB.ADD;
7363: END IF;
7364: raise FND_API.G_EXC_ERROR;
7365:
7374:
7375: if (x_status = FND_API.G_TRUE) then
7376:
7377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7378: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
7379: FND_MSG_PUB.ADD;
7380: end if;
7381: raise FND_API.G_EXC_ERROR;
7382:
7385:
7386: IF l_order_id is NOT NULL and l_order_id <> FND_API.G_MISS_NUM THEN
7387:
7388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7389: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPDATE_QUOTE_SUBMITTED');
7390: FND_MSG_PUB.ADD;
7391: END IF;
7392: raise FND_API.G_EXC_ERROR;
7393:
7741:
7742: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7743:
7744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7745: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
7746: FND_MSG_PUB.ADD;
7747: END IF;
7748:
7749: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
7925:
7926: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7927:
7928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7929: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7930: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7931: FND_MSG_PUB.ADD;
7932: END IF;
7933: RAISE FND_API.G_EXC_ERROR;
7926: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7927:
7928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7929: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7930: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
7931: FND_MSG_PUB.ADD;
7932: END IF;
7933: RAISE FND_API.G_EXC_ERROR;
7934:
7945:
7946: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7947:
7948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7949: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7950: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7951: FND_MSG_PUB.ADD;
7952: END IF;
7953: RAISE FND_API.G_EXC_ERROR;
7946: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7947:
7948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7949: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7950: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
7951: FND_MSG_PUB.ADD;
7952: END IF;
7953: RAISE FND_API.G_EXC_ERROR;
7954: END IF;
7965:
7966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7967:
7968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7969: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7971: FND_MSG_PUB.ADD;
7972: END IF;
7973: RAISE FND_API.G_EXC_ERROR;
7966: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
7967:
7968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7969: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
7970: FND_MESSAGE.Set_Token('COLUMN', 'INVOICE_TO_PARTY_ID', FALSE);
7971: FND_MSG_PUB.ADD;
7972: END IF;
7973: RAISE FND_API.G_EXC_ERROR;
7974: END IF;
8217:
8218: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8219:
8220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8221: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UPD_EXPIRATION_DATE');
8222: FND_MSG_PUB.ADD;
8223: END IF;
8224: RAISE FND_API.G_EXC_ERROR;
8225: END IF;
8235:
8236: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8237:
8238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8239: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8240: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
8241: FND_MSG_PUB.ADD;
8242: END IF;
8243: RAISE FND_API.G_EXC_ERROR;
8236: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8237:
8238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8239: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8240: FND_MESSAGE.Set_Token('COLUMN', 'PRICE_LIST_ID', FALSE);
8241: FND_MSG_PUB.ADD;
8242: END IF;
8243: RAISE FND_API.G_EXC_ERROR;
8244: END IF;
8253:
8254: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8255:
8256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8257: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8258: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
8259: FND_MSG_PUB.ADD;
8260: END IF;
8261: RAISE FND_API.G_EXC_ERROR;
8254: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8255:
8256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8257: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
8258: FND_MESSAGE.Set_Token('COLUMN', 'Price List Expires Before Quote', FALSE);
8259: FND_MSG_PUB.ADD;
8260: END IF;
8261: RAISE FND_API.G_EXC_ERROR;
8262: END IF;
8276:
8277: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8278:
8279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8280: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
8281: FND_MSG_PUB.ADD;
8282: END IF;
8283: RAISE FND_API.G_EXC_ERROR;
8284: END IF;
8302:
8303: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8304:
8305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_SALES_REP_ID');
8307: FND_MSG_PUB.ADD;
8308: END IF;
8309: RAISE FND_API.G_EXC_ERROR;
8310: END IF;
8415:
8416: IF l_qte_header_rec.currency_code IS NULL THEN
8417:
8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8419: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8420: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
8421: FND_MSG_PUB.ADD;
8422: END IF;
8423: RAISE FND_API.G_EXC_ERROR;
8416: IF l_qte_header_rec.currency_code IS NULL THEN
8417:
8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8419: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8420: FND_MESSAGE.Set_Token('COLUMN', 'CURRENCY_CODE', FALSE);
8421: FND_MSG_PUB.ADD;
8422: END IF;
8423: RAISE FND_API.G_EXC_ERROR;
8424: END IF;
8438:
8439: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8440:
8441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8442: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8443: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8444: FND_MSG_PUB.ADD;
8445: END IF;
8446: RAISE FND_API.G_EXC_ERROR;
8439: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8440:
8441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8442: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8443: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8444: FND_MSG_PUB.ADD;
8445: END IF;
8446: RAISE FND_API.G_EXC_ERROR;
8447: END IF;
8460:
8461: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8462:
8463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8464: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8465: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8466: FND_MSG_PUB.ADD;
8467: END IF;
8468:
8461: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8462:
8463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8464: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_COLUMN');
8465: FND_MESSAGE.Set_Token('COLUMN', 'TAX_EXEMPT_REASON', FALSE);
8466: FND_MSG_PUB.ADD;
8467: END IF;
8468:
8469: RAISE FND_API.G_EXC_ERROR;
8484:
8485: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8486:
8487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8488: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
8489: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
8490: FND_MSG_PUB.ADD;
8491: END IF;
8492: RAISE FND_API.G_EXC_ERROR;
8485: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8486:
8487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8488: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INFORMATION');
8489: FND_MESSAGE.Set_Token('INFO', 'PARTY OBJECT ID', FALSE);
8490: FND_MSG_PUB.ADD;
8491: END IF;
8492: RAISE FND_API.G_EXC_ERROR;
8493: END IF;
8555:
8556: IF l_hd_payment_tbl.count > 1 THEN
8557:
8558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8559: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
8560: FND_MSG_PUB.ADD;
8561: END IF;
8562: RAISE FND_API.G_EXC_ERROR;
8563:
8565:
8566: IF l_hd_payment_tbl(1).payment_option = 'SPLIT' THEN
8567:
8568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8569: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8570: FND_MSG_PUB.ADD;
8571: END IF;
8572: RAISE FND_API.G_EXC_ERROR;
8573: END IF;
8587:
8588: IF l_payment_db_tbl(l_index) <> 'SPLIT' THEN
8589:
8590: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8591: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
8592: FND_MSG_PUB.ADD;
8593: END IF;
8594: RAISE FND_API.G_EXC_ERROR;
8595: END IF;
8626:
8627: IF l_shipment_db_tbl.count > 1 THEN
8628:
8629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_SHIPMENTS');
8631: FND_MSG_PUB.ADD;
8632: END IF;
8633: RAISE FND_API.G_EXC_ERROR;
8634: END IF;
8659:
8660: IF l_tax_db_tbl.count > 1 THEN
8661:
8662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8663: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_TAX_RECORDS');
8664: FND_MSG_PUB.ADD;
8665: END IF;
8666: RAISE FND_API.G_EXC_ERROR;
8667:
9475:
9476: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9479: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9480: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
9481: FND_MSG_PUB.ADD;
9482: END IF;
9483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9476: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9479: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
9480: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE ROW', TRUE);
9481: FND_MSG_PUB.ADD;
9482: END IF;
9483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9484: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9516: Fetch c_service_ref_type_code Into l_service_ref_type_code;
9517: Close c_service_ref_type_code;
9518:
9519: If l_service_ref_type_code = 'CUSTOMER_PRODUCT' Then
9520: FND_MESSAGE.Set_Name('ASO', 'ASO_IB_END_CUST_CHG_NA');
9521: FND_MSG_PUB.ADD;
9522: RAISE FND_API.G_EXC_ERROR;
9523: End If;
9524: End If;
9565: END IF;
9566: ELSE
9567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
9569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
9570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
9571: FND_MSG_PUB.ADD;
9572: END IF;
9573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9566: ELSE
9567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
9569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
9570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
9571: FND_MSG_PUB.ADD;
9572: END IF;
9573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9574: END IF;
10077:
10078: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10082: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10083: FND_MSG_PUB.ADD;
10084: END IF;
10085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10078: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10081: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10082: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10083: FND_MSG_PUB.ADD;
10084: END IF;
10085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10086:
10207: END LOOP;
10208: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10211: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10212: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10213: FND_MSG_PUB.ADD;
10214: END IF;
10215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10208: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10211: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10212: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
10213: FND_MSG_PUB.ADD;
10214: END IF;
10215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10216: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10548: END LOOP;
10549: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10552: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10553: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
10554: FND_MSG_PUB.ADD;
10555: END IF;
10556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10549: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10552: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10553: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDATE QLN', TRUE);
10554: FND_MSG_PUB.ADD;
10555: END IF;
10556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10557: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10656:
10657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10658:
10659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10660: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10661: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
10662: FND_MSG_PUB.ADD;
10663: END IF;
10664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10658:
10659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10660: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
10661: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER DELETE QLN', TRUE);
10662: FND_MSG_PUB.ADD;
10663: END IF;
10664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10665:
10800:
10801: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10802:
10803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10804: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
10805: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
10806: FND_MSG_PUB.ADD;
10807: END IF;
10808:
10801: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10802:
10803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10804: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
10805: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
10806: FND_MSG_PUB.ADD;
10807: END IF;
10808:
10809: RAISE FND_API.G_EXC_ERROR;
11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11226:
11227: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11228: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11229: FND_MSG_PUB.ADD;
11230:
11231: END IF;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11226:
11227: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11228: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
11229: FND_MSG_PUB.ADD;
11230:
11231: END IF;
11232:
11308: end if;
11309:
11310: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11312: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11313: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
11314: FND_MSG_PUB.ADD;
11315: END IF;
11316:
11309:
11310: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11312: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11313: FND_MESSAGE.Set_Token('API', 'CALCULATE_TAX_WITH_GTT', FALSE);
11314: FND_MSG_PUB.ADD;
11315: END IF;
11316:
11317: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11496:
11497: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11498:
11499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11500: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11501: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
11502: FND_MSG_PUB.ADD;
11503: END IF;
11504:
11497: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
11498:
11499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11500: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
11501: FND_MESSAGE.Set_Token('API', 'AR_PayNow_Amounts', FALSE);
11502: FND_MSG_PUB.ADD;
11503: END IF;
11504:
11505: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11553: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11554:
11555:
11556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11558: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
11559: FND_MSG_PUB.ADD;
11560: END IF;
11561:
11554:
11555:
11556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11557: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
11558: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER AFTER UPDT TOTAL', TRUE);
11559: FND_MSG_PUB.ADD;
11560: END IF;
11561:
11562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12049: END IF;
12050:
12051: -- Debug Message
12052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
12053: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
12054: FND_MSG_PUB.Add;
12055: END IF;
12056:
12057: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12140: -- Validate Environment
12141: -- ******************************************************************
12142: IF FND_GLOBAL.User_Id IS NULL THEN
12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12144: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
12145: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12146: FND_MSG_PUB.ADD;
12147: END IF;
12148: RAISE FND_API.G_EXC_ERROR;
12141: -- ******************************************************************
12142: IF FND_GLOBAL.User_Id IS NULL THEN
12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12144: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
12145: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12146: FND_MSG_PUB.ADD;
12147: END IF;
12148: RAISE FND_API.G_EXC_ERROR;
12149: END IF;
12152: OPEN C_Validate_Quote (p_qte_header_id);
12153: FETCH C_Validate_Quote into l_val;
12154: IF C_Validate_Quote%NOTFOUND THEN
12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12157: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
12158: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
12159: FND_MSG_PUB.ADD;
12160: END IF;
12153: FETCH C_Validate_Quote into l_val;
12154: IF C_Validate_Quote%NOTFOUND THEN
12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12157: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
12158: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
12159: FND_MSG_PUB.ADD;
12160: END IF;
12161: CLOSE C_Validate_Quote;
12154: IF C_Validate_Quote%NOTFOUND THEN
12155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12156: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12157: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
12158: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
12159: FND_MSG_PUB.ADD;
12160: END IF;
12161: CLOSE C_Validate_Quote;
12162: RAISE FND_API.G_EXC_ERROR;
12188: l_qte_header_rec.quote_version := 1;
12189: l_first_version := FND_API.G_TRUE;
12190: ELSE
12191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12192: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
12193: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12194: FND_MSG_PUB.ADD;
12195: END IF;
12196: RAISE FND_API.G_EXC_ERROR;
12189: l_first_version := FND_API.G_TRUE;
12190: ELSE
12191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12192: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
12193: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12194: FND_MSG_PUB.ADD;
12195: END IF;
12196: RAISE FND_API.G_EXC_ERROR;
12197: END IF; -- profile auto numbering
12203: AND l_qte_num = p_qte_number) THEN
12204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
12205: THEN
12206: */ -- original cpy_qte
12207: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
12208: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12209: */
12210: /* -- original cpy_qte
12211: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
12204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
12205: THEN
12206: */ -- original cpy_qte
12207: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
12208: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12209: */
12210: /* -- original cpy_qte
12211: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
12212: FND_MSG_PUB.ADD;
12207: /* FND_MESSAGE.Set_Name('ASO', 'CANNOT COPY TO EXISTING QUOTE');
12208: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12209: */
12210: /* -- original cpy_qte
12211: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_COPY_QTE');
12212: FND_MSG_PUB.ADD;
12213: END IF;
12214: RAISE FND_API.G_EXC_ERROR;
12215: ELSE
12227:
12228: IF C_Qte_Number_Exists%NOTFOUND THEN
12229:
12230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12232: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12233: FND_MSG_PUB.ADD;
12234: END IF;
12235:
12228: IF C_Qte_Number_Exists%NOTFOUND THEN
12229:
12230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
12232: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_NUMBER', FALSE);
12233: FND_MSG_PUB.ADD;
12234: END IF;
12235:
12236: CLOSE C_Qte_Number_Exists;
12265: OPEN c_qte_status_trans (l_qte_header_rec.quote_status_id, p_qte_status_id);
12266: FETCH c_qte_status_trans INTO l_enabled_flag;
12267: IF c_qte_status_trans%NOTFOUND OR l_enabled_flag = 'N' THEN
12268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12269: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_STATUS_TRANS');
12270: FND_MSG_PUB.ADD;
12271: END IF;
12272: CLOSE c_qte_status_trans;
12273: RAISE FND_API.G_EXC_ERROR;
12315:
12316: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12320: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12321: FND_MSG_PUB.ADD;
12322: END IF;
12323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12316: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
12317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12319: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
12320: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12321: FND_MSG_PUB.ADD;
12322: END IF;
12323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12324: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12324: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12325: x_return_status := FND_API.G_RET_STS_ERROR;
12326: */ -- original cpy_qte
12327: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
12329: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12330: FND_MSG_PUB.ADD;
12331: END IF; */
12332: /* -- original cpy_qte
12325: x_return_status := FND_API.G_RET_STS_ERROR;
12326: */ -- original cpy_qte
12327: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12328: FND_MESSAGE.Set_Name('ASO', 'ASO_API_EXP_ERROR');
12329: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
12330: FND_MSG_PUB.ADD;
12331: END IF; */
12332: /* -- original cpy_qte
12333: RAISE FND_API.G_EXC_ERROR;
13383:
13384: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13388: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13389: FND_MSG_PUB.ADD;
13390: END IF;
13391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13384: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13387: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13388: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13389: FND_MSG_PUB.ADD;
13390: END IF;
13391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
13424:
13425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13428: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13429: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13430: FND_MSG_PUB.ADD;
13431: END IF;
13432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13428: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13429: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13430: FND_MSG_PUB.ADD;
13431: END IF;
13432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13433: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
13436:
13437: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13441: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13442: FND_MSG_PUB.ADD;
13443: END IF;
13444:
13437: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13440: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13441: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13442: FND_MSG_PUB.ADD;
13443: END IF;
13444:
13445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13674:
13675: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13678: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13679: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13680: FND_MSG_PUB.ADD;
13681: END IF;
13682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13675: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13678: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13679: FND_MESSAGE.Set_Token('ROW', 'ASO_COPYQUOTE_ AFTER_ATTACHMENTS', TRUE);
13680: FND_MSG_PUB.ADD;
13681: END IF;
13682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13683: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
13696:
13697: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13699: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13700: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13701: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13702: FND_MSG_PUB.ADD;
13703: END IF;
13704:
13697: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
13698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13699: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13700: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
13701: FND_MESSAGE.Set_Token('ROW', 'ASO_QUOTE_HEADER', TRUE);
13702: FND_MSG_PUB.ADD;
13703: END IF;
13704:
13705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13813: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE IS NULL', 1, 'Y');
13814: END IF;
13815: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13816: FND_MESSAGE.set_name('ASO','ASO_ERR_ROLE_TYPE_NULL');
13817: FND_MSG_PUB.ADD;
13818: x_return_status := FND_API.G_RET_STS_ERROR;
13819: END IF;
13820: END IF;