DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_MESSAGE

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

233: END IF;
234:
235: -- Debug Message
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
237: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
238: FND_MSG_PUB.ADD;
239: END IF;
240:
241: -- Initialize API return status to success

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

248: -- Validate Environment
249: -- ******************************************************************
250: IF FND_GLOBAL.User_Id IS NULL THEN
251: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
252: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
253: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
254: FND_MSG_PUB.ADD;
255: END IF;
256: RAISE FND_API.G_EXC_ERROR;

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

249: -- ******************************************************************
250: IF FND_GLOBAL.User_Id IS NULL THEN
251: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
252: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
253: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
254: FND_MSG_PUB.ADD;
255: END IF;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;

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

264: FETCH C_Validate_Quote INTO l_val;
265:
266: IF C_Validate_Quote%NOTFOUND THEN
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
268: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
269: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
270: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );
271: FND_MSG_PUB.ADD;
272: END IF;

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

265:
266: IF C_Validate_Quote%NOTFOUND THEN
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
268: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
269: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
270: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );
271: FND_MSG_PUB.ADD;
272: END IF;
273: CLOSE C_Validate_Quote;

Line 270: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );

266: IF C_Validate_Quote%NOTFOUND THEN
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
268: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
269: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
270: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );
271: FND_MSG_PUB.ADD;
272: END IF;
273: CLOSE C_Validate_Quote;
274: RAISE FND_API.G_EXC_ERROR;

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

470: l_qte_header_rec.quote_version := 1;
471: l_qte_header_rec.max_version_flag := 'Y';
472: ELSE
473: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
474: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
475: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
476: FND_MSG_PUB.ADD;
477: END IF;
478: RAISE FND_API.G_EXC_ERROR;

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

471: l_qte_header_rec.max_version_flag := 'Y';
472: ELSE
473: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
474: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
475: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
476: FND_MSG_PUB.ADD;
477: END IF;
478: RAISE FND_API.G_EXC_ERROR;
479: END IF; -- profile auto numbering

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

487: IF aso_debug_pub.g_debug_flag = 'Y' THEN
488: aso_debug_pub.ADD ( 'Copy_Quote - AUTO_NUMBERING is N ' , 1 , 'N' );
489: END IF;
490: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
491: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_QTE' );
492: FND_MSG_PUB.ADD;
493: END IF;
494: RAISE FND_API.G_EXC_ERROR;
495: ELSE

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

523: x_status => lx_status);
524:
525: IF (lx_status = FND_API.G_TRUE) THEN
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
528: FND_MSG_PUB.ADD;
529: END IF;
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;

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

537: FETCH C_Qte_Number_Exists INTO l_qte_num;
538:
539: IF C_Qte_Number_Exists%NOTFOUND THEN
540: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
541: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
542: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
543: FND_MSG_PUB.ADD;
544: END IF;
545: CLOSE C_Qte_Number_Exists;

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

538:
539: IF C_Qte_Number_Exists%NOTFOUND THEN
540: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
541: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
542: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
543: FND_MSG_PUB.ADD;
544: END IF;
545: CLOSE C_Qte_Number_Exists;
546: RAISE FND_API.G_EXC_ERROR;

Line 577: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_FOR_STATUS' );

573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
574: aso_debug_pub.ADD ('Copy_Quote - invalid status ' , 1, 'N' );
575: END IF;
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
577: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_FOR_STATUS' );
578: FND_MSG_PUB.ADD;
579: END IF;
580: CLOSE C_Check_Qte_Status;
581: RAISE FND_API.G_EXC_ERROR;

Line 605: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );

601:
602: IF c_qte_status_id%NOTFOUND THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
605: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
606: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
607: FND_MSG_PUB.ADD;
608: END IF;
609: CLOSE c_qte_status_id;

Line 606: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );

602: IF c_qte_status_id%NOTFOUND THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
605: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
606: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
607: FND_MSG_PUB.ADD;
608: END IF;
609: CLOSE c_qte_status_id;
610: RAISE FND_API.G_EXC_ERROR;

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

686:
687: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
690: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
691: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
692: FND_MSG_PUB.ADD;
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

687: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
690: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
691: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
692: FND_MSG_PUB.ADD;
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

766: */
767: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
770: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
771: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
772: FND_MSG_PUB.ADD;
773: END IF;
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

767: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
770: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
771: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
772: FND_MSG_PUB.ADD;
773: END IF;
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

822: );
823: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
826: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
827: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
828: FND_MSG_PUB.ADD;
829: END IF;
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

823: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
826: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
827: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
828: FND_MSG_PUB.ADD;
829: END IF;
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 1047: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_DOC');

1043:
1044:
1045: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1047: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_DOC');
1048: FND_MSG_PUB.ADD;
1049: END IF;
1050:
1051: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1345: END IF;
1346:
1347: -- Debug Message
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
1349: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Header API: Start' );
1350: FND_MSG_PUB.ADD;
1351: END IF;
1352:
1353: -- Initialize API return status to success

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

1741:
1742: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1745: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1746: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1747: FND_MSG_PUB.ADD;
1748: END IF;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1746: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );

1742: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1745: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1746: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1747: FND_MSG_PUB.ADD;
1748: END IF;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

1811: END IF;
1812: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1815: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1816: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1817: FND_MSG_PUB.ADD;
1818: END IF;
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1816: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );

1812: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1815: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1816: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1817: FND_MSG_PUB.ADD;
1818: END IF;
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

1861:
1862: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1865: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1866: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1867: FND_MSG_PUB.ADD;
1868: END IF;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1866: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );

1862: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1865: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1866: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1867: FND_MSG_PUB.ADD;
1868: END IF;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

1894:
1895: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1897: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1898: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1899: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1900: FND_MSG_PUB.ADD;
1901: END IF;
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1899: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );

1895: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1897: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1898: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1899: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1900: FND_MSG_PUB.ADD;
1901: END IF;
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

1936:
1937: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1940: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1941: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_TASKS' , TRUE );
1942: FND_MSG_PUB.ADD;
1943: END IF;
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1941: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_TASKS' , TRUE );

1937: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1940: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1941: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_TASKS' , TRUE );
1942: FND_MSG_PUB.ADD;
1943: END IF;
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

1970:
1971: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1974: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1975: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_ATTACHMENTS' , TRUE );
1976: FND_MSG_PUB.ADD;
1977: END IF;
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1975: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_ATTACHMENTS' , TRUE );

1971: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1974: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1975: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_ATTACHMENTS' , TRUE );
1976: FND_MSG_PUB.ADD;
1977: END IF;
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

2557: END IF;
2558:
2559: -- Debug Message
2560: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
2561: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Lines API: Start' );
2562: FND_MSG_PUB.ADD;
2563: END IF;
2564:
2565: -- Initialize API return status to success

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

2581: x_status => lx_status);
2582:
2583: IF (lx_status = FND_API.G_TRUE) THEN
2584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2585: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
2586: FND_MSG_PUB.ADD;
2587: END IF;
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;

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

2746:
2747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2748:
2749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2750: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_DEFAULTING');
2751: FND_MSG_PUB.ADD;
2752: END IF;
2753:
2754: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

2791:
2792: IF C_Validate_Quote_Line%NOTFOUND THEN
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2795: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
2796: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
2797: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );
2798: FND_MSG_PUB.ADD;
2799: END IF;

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

2792: IF C_Validate_Quote_Line%NOTFOUND THEN
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2795: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
2796: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
2797: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );
2798: FND_MSG_PUB.ADD;
2799: END IF;
2800: CLOSE C_Validate_Quote_Line;

Line 2797: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );

2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2795: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
2796: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
2797: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );
2798: FND_MSG_PUB.ADD;
2799: END IF;
2800: CLOSE C_Validate_Quote_Line;
2801: RAISE FND_API.G_EXC_ERROR;

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

2811: Fetch C_Get_quote into l_LAST_UPDATE_DATE;
2812: If ( C_Get_quote%NOTFOUND) Then
2813:
2814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2815: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
2816: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2817: FND_MSG_PUB.Add;
2818: END IF;
2819: raise FND_API.G_EXC_ERROR;

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

2812: If ( C_Get_quote%NOTFOUND) Then
2813:
2814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2815: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
2816: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2817: FND_MSG_PUB.Add;
2818: END IF;
2819: raise FND_API.G_EXC_ERROR;
2820: END IF;

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

2822:
2823: If (l_last_update_date is NULL or
2824: l_last_update_date = FND_API.G_MISS_Date ) Then
2825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2826: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2827: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2828: FND_MSG_PUB.ADD;
2829: END IF;
2830: raise FND_API.G_EXC_ERROR;

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

2823: If (l_last_update_date is NULL or
2824: l_last_update_date = FND_API.G_MISS_Date ) Then
2825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2826: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2827: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2828: FND_MSG_PUB.ADD;
2829: END IF;
2830: raise FND_API.G_EXC_ERROR;
2831: End if;

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

2832:
2833: -- Check Whether record has been changed by someone else
2834: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
2835: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2836: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
2837: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2838: FND_MSG_PUB.ADD;
2839: END IF;
2840: raise FND_API.G_EXC_ERROR;

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

2833: -- Check Whether record has been changed by someone else
2834: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
2835: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2836: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
2837: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2838: FND_MSG_PUB.ADD;
2839: END IF;
2840: raise FND_API.G_EXC_ERROR;
2841: End if;

Line 2881: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );

2877: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );
2878: END IF;
2879:
2880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2881: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
2882: FND_MSG_PUB.ADD;
2883: END IF;
2884:
2885: END IF;

Line 2910: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );

2906:
2907: IF l_return_value = 'Y' THEN
2908: x_return_status := FND_API.G_RET_STS_ERROR;
2909: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2910: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
2911: FND_MSG_PUB.ADD;
2912: END IF;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;

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

2915:
2916: ELSE
2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2918: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2919: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2920: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
2921: FND_MSG_PUB.ADD;
2922: END IF;
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2920: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

2916: ELSE
2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2918: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2919: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2920: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
2921: FND_MSG_PUB.ADD;
2922: END IF;
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2924:

Line 2943: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CFG_ITM_ERR' );

2939: End If;
2940: /* Code change for Quoting Usability Sun ER End */
2941:
2942: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2943: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CFG_ITM_ERR' );
2944: FND_MSG_PUB.ADD;
2945: END IF;
2946: RAISE FND_API.G_EXC_ERROR;
2947:

Line 2971: FND_MESSAGE.Set_Name ('ASO' , 'ASO_SRV_ITM_ERR' );

2967: End If;
2968: /* Code change for Quoting Usability Sun ER End */
2969:
2970: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2971: FND_MESSAGE.Set_Name ('ASO' , 'ASO_SRV_ITM_ERR' );
2972: FND_MSG_PUB.ADD;
2973: END IF;
2974:
2975: RAISE FND_API.G_EXC_ERROR;

Line 3006: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );

3002: End If;
3003: /* Code change for Quoting Usability Sun ER End */
3004:
3005: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3006: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
3007: FND_MSG_PUB.ADD;
3008: END IF;
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF;

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

3059: END IF;
3060: ELSE
3061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
3065: FND_MSG_PUB.ADD;
3066: END IF;
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

3060: ELSE
3061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
3065: FND_MSG_PUB.ADD;
3066: END IF;
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;

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

3497:
3498: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3501: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3502: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
3503: FND_MSG_PUB.ADD;
3504: END IF;
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3502: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );

3498: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3501: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3502: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
3503: FND_MSG_PUB.ADD;
3504: END IF;
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3506: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3565: END IF;
3566: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
3571: FND_MSG_PUB.ADD;
3572: END IF;
3573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );

3566: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3569: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3570: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
3571: FND_MSG_PUB.ADD;
3572: END IF;
3573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3574: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3613:
3614: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3617: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3618: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3619: FND_MSG_PUB.ADD;
3620: END IF;
3621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3614: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3617: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3618: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3619: FND_MSG_PUB.ADD;
3620: END IF;
3621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3622:

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

3661:
3662: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3664: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3665: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3666: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
3667: FND_MSG_PUB.ADD;
3668: END IF;
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3666: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );

3662: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3664: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3665: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3666: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
3667: FND_MSG_PUB.ADD;
3668: END IF;
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3717:
3718: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3721: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3722: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
3723: FND_MSG_PUB.ADD;
3724: END IF;
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3722: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );

3718: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3721: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3722: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
3723: FND_MSG_PUB.ADD;
3724: END IF;
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3726: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3769:
3770: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3772: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3773: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3774: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
3775: FND_MSG_PUB.ADD;
3776: END IF;
3777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3774: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

3770: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3772: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3773: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3774: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
3775: FND_MSG_PUB.ADD;
3776: END IF;
3777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3778: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4029:
4030: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4032: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4033: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4034: FND_MSG_PUB.ADD;
4035: END IF;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4130:
4131: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4133: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4134: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4135: FND_MSG_PUB.ADD;
4136: END IF;
4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4138: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4562:
4563:
4564: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4565: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4566: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4567: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
4568: FND_MSG_PUB.ADD;
4569: END IF;
4570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4567: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );

4563:
4564: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4565: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4566: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4567: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
4568: FND_MSG_PUB.ADD;
4569: END IF;
4570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4571: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4599: END IF;
4600: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4602: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4603: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4604: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
4605: FND_MSG_PUB.ADD;
4606: END IF;
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4604: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );

4600: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4602: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4603: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4604: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
4605: FND_MSG_PUB.ADD;
4606: END IF;
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4640:
4641: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4644: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4645: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
4646: FND_MSG_PUB.ADD;
4647: END IF;
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4641: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4644: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4645: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
4646: FND_MSG_PUB.ADD;
4647: END IF;
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649:

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

4675: aso_debug_pub.ADD ( 'Copy_Rows -After config line copy_attch ' || x_return_status , 1 , 'Y' );
4676: END IF;
4677: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4679: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4680: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_ATTACHMENTS' , TRUE );
4681: FND_MSG_PUB.ADD;
4682: END IF;
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4680: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_ATTACHMENTS' , TRUE );

4676: END IF;
4677: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4679: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4680: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_ATTACHMENTS' , TRUE );
4681: FND_MSG_PUB.ADD;
4682: END IF;
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

4716: );
4717: END IF;
4718: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4720: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4721: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_SERVICE' , TRUE );
4722: FND_MSG_PUB.ADD;
4723: END IF;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4721: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_SERVICE' , TRUE );

4717: END IF;
4718: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4720: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4721: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_SERVICE' , TRUE );
4722: FND_MSG_PUB.ADD;
4723: END IF;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

5019:
5020:
5021: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5022: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5023: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5024: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
5025: FND_MSG_PUB.ADD;
5026: END IF;
5027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5024: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );

5020:
5021: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5022: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5023: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5024: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
5025: FND_MSG_PUB.ADD;
5026: END IF;
5027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5028: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

5058: END IF;
5059: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5061: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5062: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5063: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
5064: FND_MSG_PUB.ADD;
5065: END IF;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5063: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );

5059: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5061: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5062: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5063: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
5064: FND_MSG_PUB.ADD;
5065: END IF;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

5098:
5099: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5102: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5103: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
5104: FND_MSG_PUB.ADD;
5105: END IF;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5099: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5102: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5103: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
5104: FND_MSG_PUB.ADD;
5105: END IF;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107:

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

5132: aso_debug_pub.ADD ( 'Copy_Rows -After config line copy_attch ' || x_return_status , 1 , 'Y' );
5133: END IF;
5134: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5136: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5137: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_ATTACHMENTS' , TRUE );
5138: FND_MSG_PUB.ADD;
5139: END IF;
5140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5137: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_ATTACHMENTS' , TRUE );

5133: END IF;
5134: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5136: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5137: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_ATTACHMENTS' , TRUE );
5138: FND_MSG_PUB.ADD;
5139: END IF;
5140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5141: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 5481: fnd_message.set_name ( 'ASO', 'ASO_API_ERROR_IN_CREATING_RLTSHIPS');

5477: aso_debug_pub.ADD ( 'Copy_Opp_Quote: after insert_rel_object:x_return_status: ' || x_return_status, 1 , 'N' );
5478: END IF;
5479: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5481: fnd_message.set_name ( 'ASO', 'ASO_API_ERROR_IN_CREATING_RLTSHIPS');
5482: fnd_msg_pub.ADD;
5483: END IF;
5484:
5485: END IF;

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

5704: FND_MSG_PUB.initialize;
5705: END IF;
5706: -- Debug Message
5707: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
5708: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
5709: FND_MSG_PUB.ADD;
5710: END IF;
5711:
5712: -- Initialize API return status to success

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

5723: x_status => lx_status);
5724:
5725: IF (lx_status = FND_API.G_TRUE) THEN
5726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5727: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
5728: FND_MSG_PUB.ADD;
5729: END IF;
5730: RAISE FND_API.G_EXC_ERROR;
5731: END IF;

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

5740: IF C_Validate_Quote%NOTFOUND THEN
5741:
5742: x_return_status := FND_API.G_RET_STS_ERROR;
5743: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5744: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5745: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5746: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );
5747: FND_MSG_PUB.ADD;
5748: END IF;

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

5741:
5742: x_return_status := FND_API.G_RET_STS_ERROR;
5743: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5744: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5745: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5746: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );
5747: FND_MSG_PUB.ADD;
5748: END IF;
5749: CLOSE C_Validate_Quote;

Line 5746: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );

5742: x_return_status := FND_API.G_RET_STS_ERROR;
5743: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5744: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5745: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5746: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );
5747: FND_MSG_PUB.ADD;
5748: END IF;
5749: CLOSE C_Validate_Quote;
5750: RAISE FND_API.G_EXC_ERROR;

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

5761: FETCH C_Validate_Quote_Line INTO l_val;
5762: IF C_Validate_Quote_Line%NOTFOUND THEN
5763: x_return_status := FND_API.G_RET_STS_ERROR;
5764: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5765: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5766: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5767: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );
5768: FND_MSG_PUB.ADD;
5769: END IF;

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

5762: IF C_Validate_Quote_Line%NOTFOUND THEN
5763: x_return_status := FND_API.G_RET_STS_ERROR;
5764: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5765: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5766: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5767: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );
5768: FND_MSG_PUB.ADD;
5769: END IF;
5770: CLOSE C_Validate_Quote_Line;

Line 5767: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );

5763: x_return_status := FND_API.G_RET_STS_ERROR;
5764: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5765: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
5766: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
5767: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );
5768: FND_MSG_PUB.ADD;
5769: END IF;
5770: CLOSE C_Validate_Quote_Line;
5771: RAISE FND_API.G_EXC_ERROR;

Line 5830: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');

5826:
5827: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5828:
5829:
5830: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
5831: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);
5832: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);
5833: FND_MSG_PUB.ADD;
5834: END IF;

Line 5831: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);

5827: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5828:
5829:
5830: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
5831: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);
5832: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);
5833: FND_MSG_PUB.ADD;
5834: END IF;
5835: RAISE FND_API.G_EXC_ERROR;

Line 5832: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);

5828:
5829:
5830: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
5831: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);
5832: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);
5833: FND_MSG_PUB.ADD;
5834: END IF;
5835: RAISE FND_API.G_EXC_ERROR;
5836:

Line 5848: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );

5844: END IF;
5845: x_return_status := FND_API.G_RET_STS_ERROR;
5846:
5847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5848: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
5849: FND_MSG_PUB.ADD;
5850: END IF;
5851: RAISE FND_API.G_EXC_ERROR;
5852:

Line 5865: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );

5861: END IF;
5862: x_return_status := FND_API.G_RET_STS_ERROR;
5863:
5864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5865: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
5866: FND_MSG_PUB.ADD;
5867: END IF;
5868: RAISE FND_API.G_EXC_ERROR;
5869:

Line 5893: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CON_ITM_ERR' );

5889:
5890: IF l_return_value = 'Y' THEN
5891: x_return_status := FND_API.G_RET_STS_ERROR;
5892: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5893: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CON_ITM_ERR' );
5894: FND_MSG_PUB.ADD;
5895: END IF;
5896: RAISE FND_API.G_EXC_ERROR;
5897: END IF;

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

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

Line 5903: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

5899: ELSE
5900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5901: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5902: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5903: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
5904: FND_MSG_PUB.ADD;
5905: END IF;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907:

Line 5926: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );

5922: OR ( l_qte_line_detail_tbl(1).REF_TYPE_CODE = 'TOP_MODEL' ) THEN
5923: x_return_status := FND_API.G_RET_STS_ERROR;
5924:
5925: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5926: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
5927: FND_MSG_PUB.ADD;
5928: END IF;
5929:
5930: END IF;

Line 5950: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );

5946:
5947: IF l_qte_line_rec.uom_code = 'ENR' THEN
5948: x_return_status := FND_API.G_RET_STS_ERROR;
5949: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5950: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
5951: FND_MSG_PUB.ADD;
5952: END IF;
5953: RAISE FND_API.G_EXC_ERROR;
5954: END IF;

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

6215:
6216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6220: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
6221: FND_MSG_PUB.ADD;
6222: END IF;
6223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6220: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );

6216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6220: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
6221: FND_MSG_PUB.ADD;
6222: END IF;
6223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

6274: END IF;
6275: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6278: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6279: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );
6280: FND_MSG_PUB.ADD;
6281: END IF;
6282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6279: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );

6275: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6278: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6279: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );
6280: FND_MSG_PUB.ADD;
6281: END IF;
6282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6283: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

6313:
6314: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6316: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6317: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6318: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
6319: FND_MSG_PUB.ADD;
6320: END IF;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6314: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6316: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6317: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6318: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
6319: FND_MSG_PUB.ADD;
6320: END IF;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6322:

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

6347:
6348: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6351: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6352: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
6353: FND_MSG_PUB.ADD;
6354: END IF;
6355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6352: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );

6348: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6351: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6352: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
6353: FND_MSG_PUB.ADD;
6354: END IF;
6355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6356: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

6398:
6399: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6402: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6403: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
6404: FND_MSG_PUB.ADD;
6405: END IF;
6406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6403: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );

6399: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6402: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6403: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
6404: FND_MSG_PUB.ADD;
6405: END IF;
6406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6407: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

6448:
6449: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6452: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6453: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
6454: FND_MSG_PUB.ADD;
6455: END IF;
6456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6453: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

6449: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6452: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6453: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
6454: FND_MSG_PUB.ADD;
6455: END IF;
6456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6457: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

6690:
6691: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
6694: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
6695: FND_MSG_PUB.ADD;
6696: END IF;
6697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6698: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

7103: END IF;
7104:
7105: if x_return_status <> fnd_api.g_ret_sts_success then
7106: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7107: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
7108: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
7109: FND_MSG_PUB.ADD;
7110: END IF;
7111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7108: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);

7104:
7105: if x_return_status <> fnd_api.g_ret_sts_success then
7106: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7107: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
7108: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
7109: FND_MSG_PUB.ADD;
7110: END IF;
7111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
7112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;