DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_MESSAGE

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

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:
185: -- Initialize API return status to success

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

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

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

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

Line 212: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_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;
216: END IF;

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

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;
216: END IF;
217: CLOSE C_Validate_Quote;

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

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;
216: END IF;
217: CLOSE C_Validate_Quote;
218: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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;
324: CLOSE C_Qte_Number_Exists;
325: RAISE FND_API.G_EXC_ERROR;

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

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

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

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;
388: CLOSE c_qte_status_id;

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

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;
388: CLOSE c_qte_status_id;
389: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1001: -- Initialize API return status to success

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1828: -- Initialize API return status to success

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

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

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

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

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

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;
1881: END IF;
1882: CLOSE C_Validate_Quote_Line;

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

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;
1881: END IF;
1882: CLOSE C_Validate_Quote_Line;
1883: RAISE FND_API.G_EXC_ERROR;

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

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

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

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;
1901: raise FND_API.G_EXC_ERROR;
1902: END IF;

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

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

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

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;
1912: raise FND_API.G_EXC_ERROR;
1913: End if;

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

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

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

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;
1922: raise FND_API.G_EXC_ERROR;
1923: End if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
4404: -- Initialize API return status to success

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

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

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

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

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

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;
4440: END IF;
4441: CLOSE C_Validate_Quote;

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

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

Line 4457: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_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;
4461: END IF;

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

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;
4461: END IF;
4462: CLOSE C_Validate_Quote_Line;

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

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;
4461: END IF;
4462: CLOSE C_Validate_Quote_Line;
4463: RAISE FND_API.G_EXC_ERROR;

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

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);
4524: FND_MESSAGE.Set_Token('VALUE', p_qte_line_tbl(1).quantity, FALSE);
4525: FND_MSG_PUB.ADD;
4526: END IF;

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

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

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

4520:
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
5803: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;