APPS.ASO_COPY_QUOTE_PVT dependencies on FND_MSG_PUB

Line 232: FND_MSG_PUB.initialize;

228: END IF;
229:
230: -- Initialize message list if p_init_msg_list is set to TRUE.
231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
232: FND_MSG_PUB.initialize;
233: END IF;
234:
235: -- Debug Message
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

232: FND_MSG_PUB.initialize;
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:

Line 238: FND_MSG_PUB.ADD;

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
242: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

247: -- ******************************************************************
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;

Line 254: FND_MSG_PUB.ADD;

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

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

263: OPEN C_Validate_Quote ( P_Copy_Quote_Header_Rec.Quote_Header_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;

Line 271: FND_MSG_PUB.ADD;

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

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

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

Line 476: FND_MSG_PUB.ADD;

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
480: ELSE

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

486: IF l_qte_num = P_Copy_Quote_Header_Rec.Quote_Number THEN
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;

Line 492: FND_MSG_PUB.ADD;

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
496: l_qte_header_rec.quote_number := P_Copy_Quote_Header_Rec.Quote_Number;

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

522: p_quote_header_id => P_Copy_Quote_Header_Rec.Quote_Header_Id,
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;

Line 528: FND_MSG_PUB.ADD;

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

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

536: OPEN C_Qte_Number_Exists ( P_Copy_Quote_Header_Rec.Quote_Number );
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;

Line 543: FND_MSG_PUB.ADD;

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;
547: ELSE

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

572: IF C_Check_Qte_Status%NOTFOUND THEN
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;

Line 578: FND_MSG_PUB.ADD;

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

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

600: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
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;

Line 607: FND_MSG_PUB.ADD;

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

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

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

Line 692: FND_MSG_PUB.ADD;

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
696: x_return_status := FND_API.G_RET_STS_ERROR;

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

765: end if; -- success
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;

Line 772: FND_MSG_PUB.ADD;

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
776: x_return_status := FND_API.G_RET_STS_ERROR;

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

821: , X_Msg_Data => x_msg_data
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;

Line 828: FND_MSG_PUB.ADD;

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
832: x_return_status := FND_API.G_RET_STS_ERROR;

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

1042: );
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:

Line 1048: FND_MSG_PUB.ADD;

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

Line 1178: FND_MSG_PUB.Count_And_Get (

1174: IF FND_API.to_Boolean ( p_commit ) THEN
1175: COMMIT WORK;
1176: END IF;
1177: -- Standard call to get message count and if count is 1, get message info.
1178: FND_MSG_PUB.Count_And_Get (
1179: p_count => x_msg_count
1180: , p_data => x_msg_data
1181: );
1182:

Line 1188: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1184: WHEN FND_API.G_EXC_ERROR THEN
1185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1186: P_API_NAME => L_API_NAME
1187: , P_PKG_NAME => G_PKG_NAME
1188: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1189: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1190: , X_MSG_COUNT => X_MSG_COUNT
1191: , X_MSG_DATA => X_MSG_DATA
1192: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1199: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1197: P_API_NAME => L_API_NAME
1198: , P_PKG_NAME => G_PKG_NAME
1199: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1200: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1201: , X_MSG_COUNT => X_MSG_COUNT
1202: , X_MSG_DATA => X_MSG_DATA
1203: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1344: FND_MSG_PUB.initialize;

1340: END IF;
1341:
1342: -- Initialize message list if p_init_msg_list is set to TRUE.
1343: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1344: FND_MSG_PUB.initialize;
1345: END IF;
1346:
1347: -- Debug Message
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

1344: FND_MSG_PUB.initialize;
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:

Line 1350: FND_MSG_PUB.ADD;

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
1354: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 1747: FND_MSG_PUB.ADD;

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
1751: x_return_status := FND_API.G_RET_STS_ERROR;

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

1810: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
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;

Line 1817: FND_MSG_PUB.ADD;

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
1821: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 1867: FND_MSG_PUB.ADD;

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
1871: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 1900: FND_MSG_PUB.ADD;

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
1904: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 1942: FND_MSG_PUB.ADD;

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
1946: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 1976: FND_MSG_PUB.ADD;

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
1980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2241: FND_MSG_PUB.Count_And_Get (

2237: COMMIT WORK;
2238: END IF;
2239:
2240: -- Standard call to get message count and if count is 1, get message info.
2241: FND_MSG_PUB.Count_And_Get (
2242: p_count => x_msg_count
2243: , p_data => x_msg_data
2244: );
2245:

Line 2252: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2248: WHEN FND_API.G_EXC_ERROR THEN
2249: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2250: P_API_NAME => L_API_NAME
2251: , P_PKG_NAME => G_PKG_NAME
2252: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2253: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2254: , X_MSG_COUNT => X_MSG_COUNT
2255: , X_MSG_DATA => X_MSG_DATA
2256: , X_RETURN_STATUS => X_RETURN_STATUS

Line 2263: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2260: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2261: P_API_NAME => L_API_NAME
2262: , P_PKG_NAME => G_PKG_NAME
2263: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2264: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2265: , X_MSG_COUNT => X_MSG_COUNT
2266: , X_MSG_DATA => X_MSG_DATA
2267: , X_RETURN_STATUS => X_RETURN_STATUS

Line 2556: FND_MSG_PUB.initialize;

2552: END IF;
2553:
2554: -- Initialize message list if p_init_msg_list is set to TRUE.
2555: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2556: FND_MSG_PUB.initialize;
2557: END IF;
2558:
2559: -- Debug Message
2560: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

2556: FND_MSG_PUB.initialize;
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:

Line 2562: FND_MSG_PUB.ADD;

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
2566: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2580: p_quote_header_id => p_qte_header_id,
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;

Line 2586: FND_MSG_PUB.ADD;

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

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

2745: End If;
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:

Line 2751: FND_MSG_PUB.ADD;

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

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

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

Line 2798: FND_MSG_PUB.ADD;

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

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

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

Line 2817: FND_MSG_PUB.Add;

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;
2821: Close C_Get_quote;

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

2821: Close C_Get_quote;
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;

Line 2828: FND_MSG_PUB.ADD;

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

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

2831: End if;
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;

Line 2838: FND_MSG_PUB.ADD;

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

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

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

Line 2882: FND_MSG_PUB.ADD;

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

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

2905: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
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;

Line 2911: FND_MSG_PUB.ADD;

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

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

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

Line 2921: FND_MSG_PUB.ADD;

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

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

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

Line 2944: FND_MSG_PUB.ADD;

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

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

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

Line 2972: FND_MSG_PUB.ADD;

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

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

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

Line 3007: FND_MSG_PUB.ADD;

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

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

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

Line 3065: FND_MSG_PUB.ADD;

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;
3069: End If;

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

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

Line 3503: FND_MSG_PUB.ADD;

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
3507: x_return_status := FND_API.G_RET_STS_ERROR;

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

3564: aso_debug_pub.add('Copy_Rows: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
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;

Line 3571: FND_MSG_PUB.ADD;

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
3575: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 3619: FND_MSG_PUB.ADD;

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:
3623: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

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

Line 3667: FND_MSG_PUB.ADD;

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
3671: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 3723: FND_MSG_PUB.ADD;

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
3727: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 3775: FND_MSG_PUB.ADD;

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
3779: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 4034: FND_MSG_PUB.ADD;

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
4038: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 4135: FND_MSG_PUB.ADD;

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
4139: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4165: FND_MSG_PUB.Count_And_Get (

4161: COMMIT WORK;
4162: END IF;
4163:
4164: -- Standard call to get message count and if count is 1, get message info.
4165: FND_MSG_PUB.Count_And_Get (
4166: p_count => x_msg_count
4167: , p_data => x_msg_data
4168: );
4169:

Line 4176: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4172: WHEN FND_API.G_EXC_ERROR THEN
4173: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4174: P_API_NAME => L_API_NAME
4175: , P_PKG_NAME => G_PKG_NAME
4176: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4177: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4178: , X_MSG_COUNT => X_MSG_COUNT
4179: , X_MSG_DATA => X_MSG_DATA
4180: , X_RETURN_STATUS => X_RETURN_STATUS

Line 4187: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4184: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4185: P_API_NAME => L_API_NAME
4186: , P_PKG_NAME => G_PKG_NAME
4187: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4188: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4189: , X_MSG_COUNT => X_MSG_COUNT
4190: , X_MSG_DATA => X_MSG_DATA
4191: , X_RETURN_STATUS => X_RETURN_STATUS

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

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

Line 4568: FND_MSG_PUB.ADD;

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

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

4598: aso_debug_pub.add('Copy_Config: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
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;

Line 4605: FND_MSG_PUB.ADD;

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
4609: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 4646: FND_MSG_PUB.ADD;

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:
4650: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

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

Line 4681: FND_MSG_PUB.ADD;

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

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

4715: , p_line_quantity => FND_API.G_MISS_NUM
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;

Line 4722: FND_MSG_PUB.ADD;

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

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

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

Line 5025: FND_MSG_PUB.ADD;

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

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

5057: aso_debug_pub.add('Service_Copy:: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
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;

Line 5064: FND_MSG_PUB.ADD;

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
5068: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 5104: FND_MSG_PUB.ADD;

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:
5108: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

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

Line 5138: FND_MSG_PUB.ADD;

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

Line 5278: FND_MSG_PUB.initialize;

5274: END IF;
5275:
5276: -- Initialize message list if p_init_msg_list is set to TRUE.
5277: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
5278: FND_MSG_PUB.initialize;
5279: END IF;
5280:
5281: -- API BODY
5282: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5381: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5377: WHEN FND_API.G_EXC_ERROR THEN
5378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5379: P_API_NAME => L_API_NAME
5380: , P_PKG_NAME => G_PKG_NAME
5381: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5382: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5383: , X_MSG_COUNT => X_MSG_COUNT
5384: , X_MSG_DATA => X_MSG_DATA
5385: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5392: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5390: P_API_NAME => L_API_NAME
5391: , P_PKG_NAME => G_PKG_NAME
5392: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5393: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5394: , X_MSG_COUNT => X_MSG_COUNT
5395: , X_MSG_DATA => X_MSG_DATA
5396: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

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

Line 5482: fnd_msg_pub.ADD;

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

Line 5704: FND_MSG_PUB.initialize;

5700: END IF;
5701:
5702: -- Initialize message list if p_init_msg_list is set to TRUE.
5703: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
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' );

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

5703: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
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:

Line 5709: FND_MSG_PUB.ADD;

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
5713: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5722: p_quote_header_id => P_Qte_Header_Rec.quote_header_id,
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;

Line 5728: FND_MSG_PUB.ADD;

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

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

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

Line 5747: FND_MSG_PUB.ADD;

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

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

5760: OPEN C_Validate_Quote_Line ( P_Qte_Header_Rec.quote_header_id, P_Original_Qte_Line_Rec.quote_line_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;

Line 5768: FND_MSG_PUB.ADD;

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

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

5823: ELSIF l_quantity > l_qte_line_rec.quantity THEN
5824:
5825: x_return_status := FND_API.G_RET_STS_ERROR;
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);

Line 5833: FND_MSG_PUB.ADD;

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

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

5843: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - Item is not a Model Item', 1 , 'N' );
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;

Line 5849: FND_MSG_PUB.ADD;

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

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

5860: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - Item is Service Item', 1 , 'N' );
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;

Line 5866: FND_MSG_PUB.ADD;

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

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

5888: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
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;

Line 5894: FND_MSG_PUB.ADD;

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

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

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

Line 5904: FND_MSG_PUB.ADD;

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

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

5921: l_qte_line_detail_tbl(1).INSTANCE_ID IS NOT NULL )
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:

Line 5927: FND_MSG_PUB.ADD;

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

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

5945: l_qte_line_rec.quote_header_id := P_Qte_Header_Rec.quote_header_id;
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;

Line 5951: FND_MSG_PUB.ADD;

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;
5955: -- Initializing the line index table

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

6214: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
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;

Line 6221: FND_MSG_PUB.ADD;

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
6225: x_return_status := FND_API.G_RET_STS_ERROR;

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

6273: aso_debug_pub.add('SPLIT_MODEL_LINE: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
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;

Line 6280: FND_MSG_PUB.ADD;

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
6284: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 6319: FND_MSG_PUB.ADD;

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:
6323: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

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

Line 6353: FND_MSG_PUB.ADD;

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
6357: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 6404: FND_MSG_PUB.ADD;

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
6408: x_return_status := FND_API.G_RET_STS_ERROR;

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

6447: );
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;

Line 6454: FND_MSG_PUB.ADD;

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
6458: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 6695: FND_MSG_PUB.ADD;

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
6699: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6717: FND_MSG_PUB.Count_And_Get (

6713: IF FND_API.to_Boolean ( p_commit ) THEN
6714: COMMIT WORK;
6715: END IF;
6716: -- Standard call to get message count and if count is 1, get message info.
6717: FND_MSG_PUB.Count_And_Get (
6718: p_count => x_msg_count
6719: , p_data => x_msg_data
6720: );
6721:

Line 6730: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

6726: WHEN FND_API.G_EXC_ERROR THEN
6727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6728: P_API_NAME => L_API_NAME
6729: , P_PKG_NAME => G_PKG_NAME
6730: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6731: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6732: , X_MSG_COUNT => X_MSG_COUNT
6733: , X_MSG_DATA => X_MSG_DATA
6734: , X_RETURN_STATUS => X_RETURN_STATUS

Line 6741: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6739: P_API_NAME => L_API_NAME
6740: , P_PKG_NAME => G_PKG_NAME
6741: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6742: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6743: , X_MSG_COUNT => X_MSG_COUNT
6744: , X_MSG_DATA => X_MSG_DATA
6745: , X_RETURN_STATUS => X_RETURN_STATUS

Line 6818: FND_MSG_PUB.initialize;

6814: END IF;
6815:
6816: -- Initialize message list if p_init_msg_list is set to TRUE.
6817: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
6818: FND_MSG_PUB.initialize;
6819: END IF;
6820:
6821: -- API BODY
6822: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6925: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

6921: WHEN FND_API.G_EXC_ERROR THEN
6922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6923: P_API_NAME => L_API_NAME
6924: , P_PKG_NAME => G_PKG_NAME
6925: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6926: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6927: , X_MSG_COUNT => X_MSG_COUNT
6928: , X_MSG_DATA => X_MSG_DATA
6929: , X_RETURN_STATUS => X_RETURN_STATUS

Line 6936: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6934: P_API_NAME => L_API_NAME
6935: , P_PKG_NAME => G_PKG_NAME
6936: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6937: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6938: , X_MSG_COUNT => X_MSG_COUNT
6939: , X_MSG_DATA => X_MSG_DATA
6940: , X_RETURN_STATUS => X_RETURN_STATUS

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

7102: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
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;

Line 7109: FND_MSG_PUB.ADD;

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;
7113: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 7193: FND_MSG_PUB.Count_And_Get

7189: p_CUST_PO_LINE_NUMBER => l_payment_rec.CUST_PO_LINE_NUMBER,
7190: p_trxn_extension_id => l_payment_rec.trxn_extension_id
7191: );
7192: -- Standard call to get message count and if count is 1, get message info.
7193: FND_MSG_PUB.Count_And_Get
7194: ( p_count => x_msg_count,
7195: p_data => x_msg_data
7196: );
7197:

Line 7207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

7203: WHEN FND_API.G_EXC_ERROR THEN
7204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7205: P_API_NAME => L_API_NAME
7206: ,P_PKG_NAME => G_PKG_NAME
7207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
7208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7209: ,X_MSG_COUNT => X_MSG_COUNT
7210: ,X_MSG_DATA => X_MSG_DATA
7211: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 7217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7214: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7215: P_API_NAME => L_API_NAME
7216: ,P_PKG_NAME => G_PKG_NAME
7217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7218: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7219: ,X_MSG_COUNT => X_MSG_COUNT
7220: ,X_MSG_DATA => X_MSG_DATA
7221: ,X_RETURN_STATUS => X_RETURN_STATUS);