APPS.ASO_COPY_QUOTE_PVT dependencies on FND_MSG_PUB

Line 176: FND_MSG_PUB.initialize;

172: END IF;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE.
175: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
176: FND_MSG_PUB.initialize;
177: END IF;
178:
179: -- Debug Message
180: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

176: FND_MSG_PUB.initialize;
177: END IF;
178:
179: -- Debug Message
180: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
181: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
182: FND_MSG_PUB.ADD;
183: END IF;
184:

Line 182: FND_MSG_PUB.ADD;

178:
179: -- Debug Message
180: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
181: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
182: FND_MSG_PUB.ADD;
183: END IF;
184:
185: -- Initialize API return status to success
186: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

191: -- ******************************************************************
192: -- Validate Environment
193: -- ******************************************************************
194: IF FND_GLOBAL.User_Id IS NULL THEN
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
196: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
197: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
198: FND_MSG_PUB.ADD;
199: END IF;

Line 198: FND_MSG_PUB.ADD;

194: IF FND_GLOBAL.User_Id IS NULL THEN
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
196: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
197: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
198: FND_MSG_PUB.ADD;
199: END IF;
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:

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

207: OPEN C_Validate_Quote ( P_Copy_Quote_Header_Rec.Quote_Header_Id );
208: FETCH C_Validate_Quote INTO l_val;
209:
210: IF C_Validate_Quote%NOTFOUND THEN
211: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
212: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
213: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
214: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );
215: FND_MSG_PUB.ADD;

Line 215: FND_MSG_PUB.ADD;

211: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
212: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
213: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
214: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Copy_Quote_Header_Rec.Quote_Header_Id ) , FALSE );
215: FND_MSG_PUB.ADD;
216: END IF;
217: CLOSE C_Validate_Quote;
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;

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

248:
249: l_qte_header_rec.quote_version := 1;
250: l_qte_header_rec.max_version_flag := 'Y';
251: ELSE
252: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
253: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
254: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
255: FND_MSG_PUB.ADD;
256: END IF;

Line 255: FND_MSG_PUB.ADD;

251: ELSE
252: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
253: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
254: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
255: FND_MSG_PUB.ADD;
256: END IF;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF; -- profile auto numbering
259: ELSE

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

265: IF l_qte_num = P_Copy_Quote_Header_Rec.Quote_Number THEN
266: IF aso_debug_pub.g_debug_flag = 'Y' THEN
267: aso_debug_pub.ADD ( 'Copy_Quote - AUTO_NUMBERING is N ' , 1 , 'N' );
268: END IF;
269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
270: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_QTE' );
271: FND_MSG_PUB.ADD;
272: END IF;
273: RAISE FND_API.G_EXC_ERROR;

Line 271: FND_MSG_PUB.ADD;

267: aso_debug_pub.ADD ( 'Copy_Quote - AUTO_NUMBERING is N ' , 1 , 'N' );
268: END IF;
269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
270: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_QTE' );
271: FND_MSG_PUB.ADD;
272: END IF;
273: RAISE FND_API.G_EXC_ERROR;
274: ELSE
275: l_qte_header_rec.quote_number := P_Copy_Quote_Header_Rec.Quote_Number;

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

301: p_quote_header_id => P_Copy_Quote_Header_Rec.Quote_Header_Id,
302: x_status => lx_status);
303:
304: IF (lx_status = FND_API.G_TRUE) THEN
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
307: FND_MSG_PUB.ADD;
308: END IF;
309: RAISE FND_API.G_EXC_ERROR;

Line 307: FND_MSG_PUB.ADD;

303:
304: IF (lx_status = FND_API.G_TRUE) THEN
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
307: FND_MSG_PUB.ADD;
308: END IF;
309: RAISE FND_API.G_EXC_ERROR;
310: END IF;
311:

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

315: OPEN C_Qte_Number_Exists ( P_Copy_Quote_Header_Rec.Quote_Number );
316: FETCH C_Qte_Number_Exists INTO l_qte_num;
317:
318: IF C_Qte_Number_Exists%NOTFOUND THEN
319: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
320: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
321: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
322: FND_MSG_PUB.ADD;
323: END IF;

Line 322: FND_MSG_PUB.ADD;

318: IF C_Qte_Number_Exists%NOTFOUND THEN
319: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
320: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
321: FND_MESSAGE.Set_Token ('COLUMN' , 'QUOTE_NUMBER', FALSE );
322: FND_MSG_PUB.ADD;
323: END IF;
324: CLOSE C_Qte_Number_Exists;
325: RAISE FND_API.G_EXC_ERROR;
326: ELSE

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

351: IF C_Check_Qte_Status%NOTFOUND THEN
352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
353: aso_debug_pub.ADD ('Copy_Quote - invalid status ' , 1, 'N' );
354: END IF;
355: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
356: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_FOR_STATUS' );
357: FND_MSG_PUB.ADD;
358: END IF;
359: CLOSE C_Check_Qte_Status;

Line 357: FND_MSG_PUB.ADD;

353: aso_debug_pub.ADD ('Copy_Quote - invalid status ' , 1, 'N' );
354: END IF;
355: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
356: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_FOR_STATUS' );
357: FND_MSG_PUB.ADD;
358: END IF;
359: CLOSE C_Check_Qte_Status;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;

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

379: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
380:
381: IF c_qte_status_id%NOTFOUND THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
384: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
385: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
386: FND_MSG_PUB.ADD;
387: END IF;

Line 386: FND_MSG_PUB.ADD;

382: x_return_status := FND_API.G_RET_STS_ERROR;
383: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
384: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
385: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
386: FND_MSG_PUB.ADD;
387: END IF;
388: CLOSE c_qte_status_id;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

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

460: END IF;
461:
462: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
465: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
466: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
467: FND_MSG_PUB.ADD;
468: END IF;

Line 467: FND_MSG_PUB.ADD;

463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
465: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
466: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
467: FND_MSG_PUB.ADD;
468: END IF;
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
471: x_return_status := FND_API.G_RET_STS_ERROR;

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

503: END IF;
504:
505: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
508: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
509: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
510: FND_MSG_PUB.ADD;
511: END IF;

Line 510: FND_MSG_PUB.ADD;

506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
508: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
509: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
510: FND_MSG_PUB.ADD;
511: END IF;
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;

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

531: , X_Msg_Data => x_msg_data
532: );
533: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
536: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
537: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
538: FND_MSG_PUB.ADD;
539: END IF;

Line 538: FND_MSG_PUB.ADD;

534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
536: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
537: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
538: FND_MSG_PUB.ADD;
539: END IF;
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;

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

742: );
743:
744:
745: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
747: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_DOC');
748: FND_MSG_PUB.ADD;
749: END IF;
750:

Line 748: FND_MSG_PUB.ADD;

744:
745: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
747: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_COPY_DOC');
748: FND_MSG_PUB.ADD;
749: END IF;
750:
751: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 829: FND_MSG_PUB.Count_And_Get (

825: IF FND_API.to_Boolean ( p_commit ) THEN
826: COMMIT WORK;
827: END IF;
828: -- Standard call to get message count and if count is 1, get message info.
829: FND_MSG_PUB.Count_And_Get (
830: p_count => x_msg_count
831: , p_data => x_msg_data
832: );
833:

Line 839: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

835: WHEN FND_API.G_EXC_ERROR THEN
836: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
837: P_API_NAME => L_API_NAME
838: , P_PKG_NAME => G_PKG_NAME
839: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
840: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
841: , X_MSG_COUNT => X_MSG_COUNT
842: , X_MSG_DATA => X_MSG_DATA
843: , X_RETURN_STATUS => X_RETURN_STATUS

Line 850: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
848: P_API_NAME => L_API_NAME
849: , P_PKG_NAME => G_PKG_NAME
850: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
851: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
852: , X_MSG_COUNT => X_MSG_COUNT
853: , X_MSG_DATA => X_MSG_DATA
854: , X_RETURN_STATUS => X_RETURN_STATUS

Line 992: FND_MSG_PUB.initialize;

988: END IF;
989:
990: -- Initialize message list if p_init_msg_list is set to TRUE.
991: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
992: FND_MSG_PUB.initialize;
993: END IF;
994:
995: -- Debug Message
996: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

992: FND_MSG_PUB.initialize;
993: END IF;
994:
995: -- Debug Message
996: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
997: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Header API: Start' );
998: FND_MSG_PUB.ADD;
999: END IF;
1000:

Line 998: FND_MSG_PUB.ADD;

994:
995: -- Debug Message
996: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
997: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Header API: Start' );
998: FND_MSG_PUB.ADD;
999: END IF;
1000:
1001: -- Initialize API return status to success
1002: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

1214: END IF;
1215:
1216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1220: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1221: FND_MSG_PUB.ADD;
1222: END IF;

Line 1221: FND_MSG_PUB.ADD;

1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1220: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1221: FND_MSG_PUB.ADD;
1222: END IF;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;

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

1254: aso_debug_pub.add('Copy_Header: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
1255: END IF;
1256: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1259: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1260: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1261: FND_MSG_PUB.ADD;
1262: END IF;

Line 1261: FND_MSG_PUB.ADD;

1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1259: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1260: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
1261: FND_MSG_PUB.ADD;
1262: END IF;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1265: x_return_status := FND_API.G_RET_STS_ERROR;

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

1302: END IF;
1303:
1304: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1307: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1308: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1309: FND_MSG_PUB.ADD;
1310: END IF;

Line 1309: FND_MSG_PUB.ADD;

1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1307: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1308: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1309: FND_MSG_PUB.ADD;
1310: END IF;
1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;

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

1335: END IF;
1336:
1337: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1339: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1340: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1341: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1342: FND_MSG_PUB.ADD;
1343: END IF;

Line 1342: FND_MSG_PUB.ADD;

1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1339: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1340: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1341: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_NOTES' , TRUE );
1342: FND_MSG_PUB.ADD;
1343: END IF;
1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1345: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1346: x_return_status := FND_API.G_RET_STS_ERROR;

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

1377: END IF;
1378:
1379: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1382: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1383: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_TASKS' , TRUE );
1384: FND_MSG_PUB.ADD;
1385: END IF;

Line 1384: FND_MSG_PUB.ADD;

1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1382: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1383: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_TASKS' , TRUE );
1384: FND_MSG_PUB.ADD;
1385: END IF;
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1388: x_return_status := FND_API.G_RET_STS_ERROR;

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

1411: END IF;
1412:
1413: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1416: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1417: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_ATTACHMENTS' , TRUE );
1418: FND_MSG_PUB.ADD;
1419: END IF;

Line 1418: FND_MSG_PUB.ADD;

1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1416: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1417: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_ATTACHMENTS' , TRUE );
1418: FND_MSG_PUB.ADD;
1419: END IF;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1546: FND_MSG_PUB.Count_And_Get (

1542: COMMIT WORK;
1543: END IF;
1544:
1545: -- Standard call to get message count and if count is 1, get message info.
1546: FND_MSG_PUB.Count_And_Get (
1547: p_count => x_msg_count
1548: , p_data => x_msg_data
1549: );
1550:

Line 1557: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1553: WHEN FND_API.G_EXC_ERROR THEN
1554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1555: P_API_NAME => L_API_NAME
1556: , P_PKG_NAME => G_PKG_NAME
1557: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1558: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1559: , X_MSG_COUNT => X_MSG_COUNT
1560: , X_MSG_DATA => X_MSG_DATA
1561: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1568: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1565: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1566: P_API_NAME => L_API_NAME
1567: , P_PKG_NAME => G_PKG_NAME
1568: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1569: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1570: , X_MSG_COUNT => X_MSG_COUNT
1571: , X_MSG_DATA => X_MSG_DATA
1572: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1819: FND_MSG_PUB.initialize;

1815: END IF;
1816:
1817: -- Initialize message list if p_init_msg_list is set to TRUE.
1818: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;
1820: END IF;
1821:
1822: -- Debug Message
1823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

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

1819: FND_MSG_PUB.initialize;
1820: END IF;
1821:
1822: -- Debug Message
1823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
1824: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Lines API: Start' );
1825: FND_MSG_PUB.ADD;
1826: END IF;
1827:

Line 1825: FND_MSG_PUB.ADD;

1821:
1822: -- Debug Message
1823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
1824: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote Lines API: Start' );
1825: FND_MSG_PUB.ADD;
1826: END IF;
1827:
1828: -- Initialize API return status to success
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1843: p_quote_header_id => p_qte_header_id,
1844: x_status => lx_status);
1845:
1846: IF (lx_status = FND_API.G_TRUE) THEN
1847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
1849: FND_MSG_PUB.ADD;
1850: END IF;
1851: RAISE FND_API.G_EXC_ERROR;

Line 1849: FND_MSG_PUB.ADD;

1845:
1846: IF (lx_status = FND_API.G_TRUE) THEN
1847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
1849: FND_MSG_PUB.ADD;
1850: END IF;
1851: RAISE FND_API.G_EXC_ERROR;
1852: END IF;
1853:

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

1872:
1873:
1874: IF C_Validate_Quote_Line%NOTFOUND THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1877: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1878: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
1879: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );
1880: FND_MSG_PUB.ADD;

Line 1880: FND_MSG_PUB.ADD;

1876: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1877: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1878: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
1879: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Line_Id ) , FALSE );
1880: FND_MSG_PUB.ADD;
1881: END IF;
1882: CLOSE C_Validate_Quote_Line;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;

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

1892:
1893: Fetch C_Get_quote into l_LAST_UPDATE_DATE;
1894: If ( C_Get_quote%NOTFOUND) Then
1895:
1896: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
1898: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
1899: FND_MSG_PUB.Add;
1900: END IF;

Line 1899: FND_MSG_PUB.Add;

1895:
1896: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1897: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
1898: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
1899: FND_MSG_PUB.Add;
1900: END IF;
1901: raise FND_API.G_EXC_ERROR;
1902: END IF;
1903: Close C_Get_quote;

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

1903: Close C_Get_quote;
1904:
1905: If (l_last_update_date is NULL or
1906: l_last_update_date = FND_API.G_MISS_Date ) Then
1907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1908: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1909: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1910: FND_MSG_PUB.ADD;
1911: END IF;

Line 1910: FND_MSG_PUB.ADD;

1906: l_last_update_date = FND_API.G_MISS_Date ) Then
1907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1908: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1909: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1910: FND_MSG_PUB.ADD;
1911: END IF;
1912: raise FND_API.G_EXC_ERROR;
1913: End if;
1914:

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

1913: End if;
1914:
1915: -- Check Whether record has been changed by someone else
1916: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
1917: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1918: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1919: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1920: FND_MSG_PUB.ADD;
1921: END IF;

Line 1920: FND_MSG_PUB.ADD;

1916: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
1917: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1918: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1919: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1920: FND_MSG_PUB.ADD;
1921: END IF;
1922: raise FND_API.G_EXC_ERROR;
1923: End if;
1924:

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

1951:
1952: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1953: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );
1954: END IF;
1955: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1956: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
1957: FND_MSG_PUB.ADD;
1958: END IF;
1959:

Line 1957: FND_MSG_PUB.ADD;

1953: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );
1954: END IF;
1955: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1956: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
1957: FND_MSG_PUB.ADD;
1958: END IF;
1959:
1960: END IF;
1961:

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

1980: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1981:
1982: IF l_return_value = 'Y' THEN
1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1985: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
1986: FND_MSG_PUB.ADD;
1987: END IF;
1988: RAISE FND_API.G_EXC_ERROR;

Line 1986: FND_MSG_PUB.ADD;

1982: IF l_return_value = 'Y' THEN
1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1985: FND_MESSAGE.Set_Name ('ASO' , 'ASO_RECONFIG_ITM_ERR' );
1986: FND_MSG_PUB.ADD;
1987: END IF;
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990:

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

1989: END IF;
1990:
1991: ELSE
1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1993: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1994: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1995: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1996: FND_MSG_PUB.ADD;
1997: END IF;

Line 1996: FND_MSG_PUB.ADD;

1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1993: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1994: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1995: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1996: FND_MSG_PUB.ADD;
1997: END IF;
1998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1999:
2000: END IF;

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

2003:
2004: IF l_qte_line_rec.item_type_code = 'CFG' then
2005: x_return_status := FND_API.G_RET_STS_ERROR;
2006:
2007: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2008: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CFG_ITM_ERR' );
2009: FND_MSG_PUB.ADD;
2010: END IF;
2011: RAISE FND_API.G_EXC_ERROR;

Line 2009: FND_MSG_PUB.ADD;

2005: x_return_status := FND_API.G_RET_STS_ERROR;
2006:
2007: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2008: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CFG_ITM_ERR' );
2009: FND_MSG_PUB.ADD;
2010: END IF;
2011: RAISE FND_API.G_EXC_ERROR;
2012:
2013: END IF;

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

2021: IF l_qte_line_rec.service_item_flag = 'Y' THEN
2022:
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024:
2025: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2026: FND_MESSAGE.Set_Name ('ASO' , 'ASO_SRV_ITM_ERR' );
2027: FND_MSG_PUB.ADD;
2028: END IF;
2029:

Line 2027: FND_MSG_PUB.ADD;

2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024:
2025: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2026: FND_MESSAGE.Set_Name ('ASO' , 'ASO_SRV_ITM_ERR' );
2027: FND_MSG_PUB.ADD;
2028: END IF;
2029:
2030: RAISE FND_API.G_EXC_ERROR;
2031:

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

2045: FOR i IN 1 .. l_qte_line_tbl.COUNT LOOP
2046:
2047: IF l_qte_line_tbl ( i ).uom_code = 'ENR' THEN
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2050: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
2051: FND_MSG_PUB.ADD;
2052: END IF;
2053: RAISE FND_API.G_EXC_ERROR;

Line 2051: FND_MSG_PUB.ADD;

2047: IF l_qte_line_tbl ( i ).uom_code = 'ENR' THEN
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2050: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
2051: FND_MSG_PUB.ADD;
2052: END IF;
2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055:

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

2307:
2308:
2309: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2312: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2313: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
2314: FND_MSG_PUB.ADD;
2315: END IF;

Line 2314: FND_MSG_PUB.ADD;

2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2312: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2313: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
2314: FND_MSG_PUB.ADD;
2315: END IF;
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2318: x_return_status := FND_API.G_RET_STS_ERROR;

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

2358: aso_debug_pub.add('Copy_Rows: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
2359: END IF;
2360: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2363: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2364: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
2365: FND_MSG_PUB.ADD;
2366: END IF;

Line 2365: FND_MSG_PUB.ADD;

2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2363: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2364: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
2365: FND_MSG_PUB.ADD;
2366: END IF;
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2369: x_return_status := FND_API.G_RET_STS_ERROR;

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

2402:
2403:
2404: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2407: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2408: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
2409: FND_MSG_PUB.ADD;
2410: END IF;

Line 2409: FND_MSG_PUB.ADD;

2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2407: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2408: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
2409: FND_MSG_PUB.ADD;
2410: END IF;
2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2412:
2413: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

2446: END IF;
2447:
2448: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2450: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2451: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2452: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
2453: FND_MSG_PUB.ADD;
2454: END IF;

Line 2453: FND_MSG_PUB.ADD;

2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2450: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2451: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2452: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
2453: FND_MSG_PUB.ADD;
2454: END IF;
2455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2456: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
2457: x_return_status := FND_API.G_RET_STS_ERROR;

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

2502:
2503:
2504: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2507: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2508: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
2509: FND_MSG_PUB.ADD;
2510: END IF;

Line 2509: FND_MSG_PUB.ADD;

2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2507: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2508: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
2509: FND_MSG_PUB.ADD;
2510: END IF;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2513: x_return_status := FND_API.G_RET_STS_ERROR;

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

2553:
2554:
2555: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2557: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2558: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2559: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
2560: FND_MSG_PUB.ADD;
2561: END IF;

Line 2560: FND_MSG_PUB.ADD;

2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2557: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2558: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2559: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
2560: FND_MSG_PUB.ADD;
2561: END IF;
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2564: x_return_status := FND_API.G_RET_STS_ERROR;

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

2813: END IF;
2814:
2815: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2818: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2819: FND_MSG_PUB.ADD;
2820: END IF;
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2819: FND_MSG_PUB.ADD;

2815: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2818: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
2819: FND_MSG_PUB.ADD;
2820: END IF;
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2822: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2823: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2857: FND_MSG_PUB.Count_And_Get (

2853: COMMIT WORK;
2854: END IF;
2855:
2856: -- Standard call to get message count and if count is 1, get message info.
2857: FND_MSG_PUB.Count_And_Get (
2858: p_count => x_msg_count
2859: , p_data => x_msg_data
2860: );
2861:

Line 2868: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2864: WHEN FND_API.G_EXC_ERROR THEN
2865: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2866: P_API_NAME => L_API_NAME
2867: , P_PKG_NAME => G_PKG_NAME
2868: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2869: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2870: , X_MSG_COUNT => X_MSG_COUNT
2871: , X_MSG_DATA => X_MSG_DATA
2872: , X_RETURN_STATUS => X_RETURN_STATUS

Line 2879: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2877: P_API_NAME => L_API_NAME
2878: , P_PKG_NAME => G_PKG_NAME
2879: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2880: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2881: , X_MSG_COUNT => X_MSG_COUNT
2882: , X_MSG_DATA => X_MSG_DATA
2883: , X_RETURN_STATUS => X_RETURN_STATUS

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

3253:
3254:
3255:
3256: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3258: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3259: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
3260: FND_MSG_PUB.ADD;
3261: END IF;

Line 3260: FND_MSG_PUB.ADD;

3256: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3258: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3259: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
3260: FND_MSG_PUB.ADD;
3261: END IF;
3262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3263: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3264: RAISE FND_API.G_EXC_ERROR;

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

3290: aso_debug_pub.add('Copy_Config: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
3291: END IF;
3292: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3295: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3296: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
3297: FND_MSG_PUB.ADD;
3298: END IF;

Line 3297: FND_MSG_PUB.ADD;

3293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3294: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3295: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3296: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
3297: FND_MSG_PUB.ADD;
3298: END IF;
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
3301: x_return_status := FND_API.G_RET_STS_ERROR;

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

3331:
3332:
3333: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3336: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3337: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3338: FND_MSG_PUB.ADD;
3339: END IF;

Line 3338: FND_MSG_PUB.ADD;

3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3336: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3337: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3338: FND_MSG_PUB.ADD;
3339: END IF;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3341:
3342: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3366: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3367: aso_debug_pub.ADD ( 'Copy_Rows -After config line copy_attch ' || x_return_status , 1 , 'Y' );
3368: END IF;
3369: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3370: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3371: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3372: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_ATTACHMENTS' , TRUE );
3373: FND_MSG_PUB.ADD;
3374: END IF;

Line 3373: FND_MSG_PUB.ADD;

3369: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3370: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3371: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3372: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_ATTACHMENTS' , TRUE );
3373: FND_MSG_PUB.ADD;
3374: END IF;
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3377: RAISE FND_API.G_EXC_ERROR;

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

3407: , p_line_quantity => FND_API.G_MISS_NUM
3408: );
3409: END IF;
3410: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_SERVICE' , TRUE );
3414: FND_MSG_PUB.ADD;
3415: END IF;

Line 3414: FND_MSG_PUB.ADD;

3410: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_SERVICE' , TRUE );
3414: FND_MSG_PUB.ADD;
3415: END IF;
3416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3417: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3418: RAISE FND_API.G_EXC_ERROR;

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

3710:
3711:
3712:
3713: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3714: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3715: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3716: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
3717: FND_MSG_PUB.ADD;
3718: END IF;

Line 3717: FND_MSG_PUB.ADD;

3713: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3714: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3715: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3716: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
3717: FND_MSG_PUB.ADD;
3718: END IF;
3719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3720: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3721: RAISE FND_API.G_EXC_ERROR;

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

3749: aso_debug_pub.add('Service_Copy:: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
3750: END IF;
3751: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3754: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3755: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
3756: FND_MSG_PUB.ADD;
3757: END IF;

Line 3756: FND_MSG_PUB.ADD;

3752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3754: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3755: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
3756: FND_MSG_PUB.ADD;
3757: END IF;
3758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3759: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
3760: x_return_status := FND_API.G_RET_STS_ERROR;

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

3789:
3790:
3791: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3794: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3795: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3796: FND_MSG_PUB.ADD;
3797: END IF;

Line 3796: FND_MSG_PUB.ADD;

3792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3794: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3795: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
3796: FND_MSG_PUB.ADD;
3797: END IF;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799:
3800: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

3823: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3824: aso_debug_pub.ADD ( 'Copy_Rows -After config line copy_attch ' || x_return_status , 1 , 'Y' );
3825: END IF;
3826: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3827: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3828: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3829: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_ATTACHMENTS' , TRUE );
3830: FND_MSG_PUB.ADD;
3831: END IF;

Line 3830: FND_MSG_PUB.ADD;

3826: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
3827: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
3828: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
3829: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_ATTACHMENTS' , TRUE );
3830: FND_MSG_PUB.ADD;
3831: END IF;
3832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3833: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3834: RAISE FND_API.G_EXC_ERROR;

Line 3970: FND_MSG_PUB.initialize;

3966: END IF;
3967:
3968: -- Initialize message list if p_init_msg_list is set to TRUE.
3969: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
3970: FND_MSG_PUB.initialize;
3971: END IF;
3972:
3973: -- API BODY
3974: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 4073: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4069: WHEN FND_API.G_EXC_ERROR THEN
4070: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4071: P_API_NAME => L_API_NAME
4072: , P_PKG_NAME => G_PKG_NAME
4073: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4074: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4075: , X_MSG_COUNT => X_MSG_COUNT
4076: , X_MSG_DATA => X_MSG_DATA
4077: , X_RETURN_STATUS => X_RETURN_STATUS

Line 4084: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4082: P_API_NAME => L_API_NAME
4083: , P_PKG_NAME => G_PKG_NAME
4084: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4085: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4086: , X_MSG_COUNT => X_MSG_COUNT
4087: , X_MSG_DATA => X_MSG_DATA
4088: , X_RETURN_STATUS => X_RETURN_STATUS

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

4168: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4169: aso_debug_pub.ADD ( 'Copy_Opp_Quote: after insert_rel_object:x_return_status: ' || x_return_status, 1 , 'N' );
4170: END IF;
4171: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4172: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4173: fnd_message.set_name ( 'ASO', 'ASO_API_ERROR_IN_CREATING_RLTSHIPS');
4174: fnd_msg_pub.ADD;
4175: END IF;
4176:

Line 4174: fnd_msg_pub.ADD;

4170: END IF;
4171: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4172: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4173: fnd_message.set_name ( 'ASO', 'ASO_API_ERROR_IN_CREATING_RLTSHIPS');
4174: fnd_msg_pub.ADD;
4175: END IF;
4176:
4177: END IF;
4178:

Line 4396: FND_MSG_PUB.initialize;

4392: END IF;
4393:
4394: -- Initialize message list if p_init_msg_list is set to TRUE.
4395: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
4396: FND_MSG_PUB.initialize;
4397: END IF;
4398: -- Debug Message
4399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
4400: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );

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

4395: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
4396: FND_MSG_PUB.initialize;
4397: END IF;
4398: -- Debug Message
4399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
4400: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
4401: FND_MSG_PUB.ADD;
4402: END IF;
4403:

Line 4401: FND_MSG_PUB.ADD;

4397: END IF;
4398: -- Debug Message
4399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
4400: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote API: Start' );
4401: FND_MSG_PUB.ADD;
4402: END IF;
4403:
4404: -- Initialize API return status to success
4405: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4414: p_quote_header_id => P_Qte_Header_Rec.quote_header_id,
4415: x_status => lx_status);
4416:
4417: IF (lx_status = FND_API.G_TRUE) THEN
4418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
4420: FND_MSG_PUB.ADD;
4421: END IF;
4422: RAISE FND_API.G_EXC_ERROR;

Line 4420: FND_MSG_PUB.ADD;

4416:
4417: IF (lx_status = FND_API.G_TRUE) THEN
4418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
4420: FND_MSG_PUB.ADD;
4421: END IF;
4422: RAISE FND_API.G_EXC_ERROR;
4423: END IF;
4424:

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

4431:
4432: IF C_Validate_Quote%NOTFOUND THEN
4433:
4434: x_return_status := FND_API.G_RET_STS_ERROR;
4435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4436: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
4437: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
4438: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );
4439: FND_MSG_PUB.ADD;

Line 4439: FND_MSG_PUB.ADD;

4435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4436: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
4437: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
4438: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Qte_Header_Rec.quote_header_id ) , FALSE );
4439: FND_MSG_PUB.ADD;
4440: END IF;
4441: CLOSE C_Validate_Quote;
4442: RAISE FND_API.G_EXC_ERROR;
4443: END IF;

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

4452: OPEN C_Validate_Quote_Line ( P_Qte_Header_Rec.quote_header_id, P_Original_Qte_Line_Rec.quote_line_id);
4453: FETCH C_Validate_Quote_Line INTO l_val;
4454: IF C_Validate_Quote_Line%NOTFOUND THEN
4455: x_return_status := FND_API.G_RET_STS_ERROR;
4456: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4457: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
4458: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
4459: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );
4460: FND_MSG_PUB.ADD;

Line 4460: FND_MSG_PUB.ADD;

4456: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4457: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
4458: FND_MESSAGE.Set_Token ('COLUMN' , 'ORIGINAL_QUOTE_ID', FALSE );
4459: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Original_Qte_Line_Rec.quote_line_id ) , FALSE );
4460: FND_MSG_PUB.ADD;
4461: END IF;
4462: CLOSE C_Validate_Quote_Line;
4463: RAISE FND_API.G_EXC_ERROR;
4464: END IF;

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

4515: ELSIF l_quantity > l_qte_line_rec.quantity THEN
4516:
4517: x_return_status := FND_API.G_RET_STS_ERROR;
4518:
4519: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4520:
4521:
4522: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
4523: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);

Line 4525: FND_MSG_PUB.ADD;

4521:
4522: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_SPLITLINE_QTY');
4523: FND_MESSAGE.Set_Token('TBLNAME', 'p_qte_line_tbl', FALSE);
4524: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);
4525: FND_MSG_PUB.ADD;
4526: END IF;
4527: RAISE FND_API.G_EXC_ERROR;
4528:
4529: END IF;

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

4535: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - Item is not a Model Item', 1 , 'N' );
4536: END IF;
4537: x_return_status := FND_API.G_RET_STS_ERROR;
4538:
4539: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4540: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4541: FND_MSG_PUB.ADD;
4542: END IF;
4543: RAISE FND_API.G_EXC_ERROR;

Line 4541: FND_MSG_PUB.ADD;

4537: x_return_status := FND_API.G_RET_STS_ERROR;
4538:
4539: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4540: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4541: FND_MSG_PUB.ADD;
4542: END IF;
4543: RAISE FND_API.G_EXC_ERROR;
4544:
4545: END IF;

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

4552: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - Item is Service Item', 1 , 'N' );
4553: END IF;
4554: x_return_status := FND_API.G_RET_STS_ERROR;
4555:
4556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4557: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4558: FND_MSG_PUB.ADD;
4559: END IF;
4560: RAISE FND_API.G_EXC_ERROR;

Line 4558: FND_MSG_PUB.ADD;

4554: x_return_status := FND_API.G_RET_STS_ERROR;
4555:
4556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4557: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4558: FND_MSG_PUB.ADD;
4559: END IF;
4560: RAISE FND_API.G_EXC_ERROR;
4561:
4562: END IF;

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

4580: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4581:
4582: IF l_return_value = 'Y' THEN
4583: x_return_status := FND_API.G_RET_STS_ERROR;
4584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4585: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CON_ITM_ERR' );
4586: FND_MSG_PUB.ADD;
4587: END IF;
4588: RAISE FND_API.G_EXC_ERROR;

Line 4586: FND_MSG_PUB.ADD;

4582: IF l_return_value = 'Y' THEN
4583: x_return_status := FND_API.G_RET_STS_ERROR;
4584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4585: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CON_ITM_ERR' );
4586: FND_MSG_PUB.ADD;
4587: END IF;
4588: RAISE FND_API.G_EXC_ERROR;
4589: END IF;
4590:

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

4589: END IF;
4590:
4591: ELSE
4592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4593: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4594: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4595: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
4596: FND_MSG_PUB.ADD;
4597: END IF;

Line 4596: FND_MSG_PUB.ADD;

4592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4593: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4594: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4595: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
4596: FND_MSG_PUB.ADD;
4597: END IF;
4598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4599:
4600: END IF;

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

4613: l_qte_line_detail_tbl(1).INSTANCE_ID IS NOT NULL )
4614: OR ( l_qte_line_detail_tbl(1).REF_TYPE_CODE = 'TOP_MODEL' ) THEN
4615: x_return_status := FND_API.G_RET_STS_ERROR;
4616:
4617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4618: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4619: FND_MSG_PUB.ADD;
4620: END IF;
4621:

Line 4619: FND_MSG_PUB.ADD;

4615: x_return_status := FND_API.G_RET_STS_ERROR;
4616:
4617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4618: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_CANNOT_SPLIT' );
4619: FND_MSG_PUB.ADD;
4620: END IF;
4621:
4622: END IF;
4623:

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

4637: l_qte_line_rec.quote_header_id := P_Qte_Header_Rec.quote_header_id;
4638:
4639: IF l_qte_line_rec.uom_code = 'ENR' THEN
4640: x_return_status := FND_API.G_RET_STS_ERROR;
4641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4642: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
4643: FND_MSG_PUB.ADD;
4644: END IF;
4645: RAISE FND_API.G_EXC_ERROR;

Line 4643: FND_MSG_PUB.ADD;

4639: IF l_qte_line_rec.uom_code = 'ENR' THEN
4640: x_return_status := FND_API.G_RET_STS_ERROR;
4641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4642: FND_MESSAGE.Set_Name ('ASO' , 'ASO_CANNOT_COPY_EDU' );
4643: FND_MSG_PUB.ADD;
4644: END IF;
4645: RAISE FND_API.G_EXC_ERROR;
4646: END IF;
4647: -- Initializing the line index table

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

4906: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
4907:
4908: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4910: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4911: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4912: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
4913: FND_MSG_PUB.ADD;
4914: END IF;

Line 4913: FND_MSG_PUB.ADD;

4909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4910: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4911: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4912: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
4913: FND_MSG_PUB.ADD;
4914: END IF;
4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4916: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
4917: x_return_status := FND_API.G_RET_STS_ERROR;

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

4965: aso_debug_pub.add('SPLIT_MODEL_LINE: After call to copy_payment_row: x_return_status: '||l_return_status, 1, 'Y');
4966: END IF;
4967: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4970: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4971: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );
4972: FND_MSG_PUB.ADD;
4973: END IF;

Line 4972: FND_MSG_PUB.ADD;

4968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
4970: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
4971: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );
4972: FND_MSG_PUB.ADD;
4973: END IF;
4974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4975: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
4976: x_return_status := FND_API.G_RET_STS_ERROR;

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

5004:
5005:
5006: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5008: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5009: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5010: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
5011: FND_MSG_PUB.ADD;
5012: END IF;

Line 5011: FND_MSG_PUB.ADD;

5007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5008: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5009: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5010: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
5011: FND_MSG_PUB.ADD;
5012: END IF;
5013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5014:
5015: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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

5038: END IF;
5039:
5040: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5043: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5044: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
5045: FND_MSG_PUB.ADD;
5046: END IF;

Line 5045: FND_MSG_PUB.ADD;

5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5043: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5044: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_ATTACHMENTS' , TRUE );
5045: FND_MSG_PUB.ADD;
5046: END IF;
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5048: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
5049: x_return_status := FND_API.G_RET_STS_ERROR;

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

5089: END IF;
5090:
5091: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5093: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5094: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5095: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
5096: FND_MSG_PUB.ADD;
5097: END IF;

Line 5096: FND_MSG_PUB.ADD;

5092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5093: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5094: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5095: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
5096: FND_MSG_PUB.ADD;
5097: END IF;
5098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5099: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
5100: x_return_status := FND_API.G_RET_STS_ERROR;

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

5139: );
5140:
5141: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5144: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5145: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
5146: FND_MSG_PUB.ADD;
5147: END IF;

Line 5146: FND_MSG_PUB.ADD;

5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5144: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5145: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
5146: FND_MSG_PUB.ADD;
5147: END IF;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5149: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
5150: x_return_status := FND_API.G_RET_STS_ERROR;

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

5381:
5382:
5383: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5386: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5387: FND_MSG_PUB.ADD;
5388: END IF;
5389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5387: FND_MSG_PUB.ADD;

5383: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
5386: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
5387: FND_MSG_PUB.ADD;
5388: END IF;
5389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5390: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
5391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5409: FND_MSG_PUB.Count_And_Get (

5405: IF FND_API.to_Boolean ( p_commit ) THEN
5406: COMMIT WORK;
5407: END IF;
5408: -- Standard call to get message count and if count is 1, get message info.
5409: FND_MSG_PUB.Count_And_Get (
5410: p_count => x_msg_count
5411: , p_data => x_msg_data
5412: );
5413:

Line 5422: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5418: WHEN FND_API.G_EXC_ERROR THEN
5419: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5420: P_API_NAME => L_API_NAME
5421: , P_PKG_NAME => G_PKG_NAME
5422: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5423: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5424: , X_MSG_COUNT => X_MSG_COUNT
5425: , X_MSG_DATA => X_MSG_DATA
5426: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5433: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5431: P_API_NAME => L_API_NAME
5432: , P_PKG_NAME => G_PKG_NAME
5433: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5434: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5435: , X_MSG_COUNT => X_MSG_COUNT
5436: , X_MSG_DATA => X_MSG_DATA
5437: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5510: FND_MSG_PUB.initialize;

5506: END IF;
5507:
5508: -- Initialize message list if p_init_msg_list is set to TRUE.
5509: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
5510: FND_MSG_PUB.initialize;
5511: END IF;
5512:
5513: -- API BODY
5514: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5617: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5613: WHEN FND_API.G_EXC_ERROR THEN
5614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5615: P_API_NAME => L_API_NAME
5616: , P_PKG_NAME => G_PKG_NAME
5617: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5618: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5619: , X_MSG_COUNT => X_MSG_COUNT
5620: , X_MSG_DATA => X_MSG_DATA
5621: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5628: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5626: P_API_NAME => L_API_NAME
5627: , P_PKG_NAME => G_PKG_NAME
5628: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5629: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5630: , X_MSG_COUNT => X_MSG_COUNT
5631: , X_MSG_DATA => X_MSG_DATA
5632: , X_RETURN_STATUS => X_RETURN_STATUS

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

5794: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
5795: END IF;
5796:
5797: if x_return_status <> fnd_api.g_ret_sts_success then
5798: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5799: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5800: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
5801: FND_MSG_PUB.ADD;
5802: END IF;

Line 5801: FND_MSG_PUB.ADD;

5797: if x_return_status <> fnd_api.g_ret_sts_success then
5798: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5799: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5800: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
5801: FND_MSG_PUB.ADD;
5802: END IF;
5803: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5805: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 5885: FND_MSG_PUB.Count_And_Get

5881: p_CUST_PO_LINE_NUMBER => l_payment_rec.CUST_PO_LINE_NUMBER,
5882: p_trxn_extension_id => l_payment_rec.trxn_extension_id
5883: );
5884: -- Standard call to get message count and if count is 1, get message info.
5885: FND_MSG_PUB.Count_And_Get
5886: ( p_count => x_msg_count,
5887: p_data => x_msg_data
5888: );
5889:

Line 5899: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5895: WHEN FND_API.G_EXC_ERROR THEN
5896: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5897: P_API_NAME => L_API_NAME
5898: ,P_PKG_NAME => G_PKG_NAME
5899: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5900: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5901: ,X_MSG_COUNT => X_MSG_COUNT
5902: ,X_MSG_DATA => X_MSG_DATA
5903: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5909: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5907: P_API_NAME => L_API_NAME
5908: ,P_PKG_NAME => G_PKG_NAME
5909: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5910: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5911: ,X_MSG_COUNT => X_MSG_COUNT
5912: ,X_MSG_DATA => X_MSG_DATA
5913: ,X_RETURN_STATUS => X_RETURN_STATUS);