DBA Data[Home] [Help]

APPS.AMS_IMP_DOC_PVT dependencies on FND_MSG_PUB

Line 60: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

56: --
57: -- End of Comments
58: -- ==============================================================================
59:
60: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_Imp_Doc(

Line 61: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

57: -- End of Comments
58: -- ==============================================================================
59:
60: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_Imp_Doc(
65: p_api_version_number IN NUMBER,

Line 62: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

58: -- ==============================================================================
59:
60: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_Imp_Doc(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 114: FND_MSG_PUB.initialize;

110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117:
118:

Line 234: FND_MSG_PUB.Count_And_Get

230: END IF;
231:
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: EXCEPTION

Line 248: FND_MSG_PUB.Count_And_Get (

244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Imp_Doc_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );

Line 258: FND_MSG_PUB.Count_And_Get (

254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO CREATE_Imp_Doc_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
262: );

Line 267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

263:
264: WHEN OTHERS THEN
265: ROLLBACK TO CREATE_Imp_Doc_PVT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message

Line 269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

265: ROLLBACK TO CREATE_Imp_Doc_PVT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,

Line 272: FND_MSG_PUB.Count_And_Get (

268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
276: );

Line 363: FND_MSG_PUB.initialize;

359:
360: -- Initialize message list if p_init_msg_list is set to TRUE.
361: IF FND_API.to_Boolean( p_init_msg_list )
362: THEN
363: FND_MSG_PUB.initialize;
364: END IF;
365:
366:
367:

Line 447: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

443:
444: -- Debug Message
445: IF (AMS_DEBUG_HIGH_ON) THEN
446:
447: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
448: END IF;
449:
450: -- Invoke table handler(Ams_Imp_Doc_Pkg.Update_Row)
451: Ams_Imp_Doc_Pkg.Update_Row(

Line 483: FND_MSG_PUB.Count_And_Get

479: END IF;
480:
481:
482: -- Standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get
484: (p_count => x_msg_count,
485: p_data => x_msg_data
486: );
487: EXCEPTION

Line 497: FND_MSG_PUB.Count_And_Get (

493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO UPDATE_Imp_Doc_PVT;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );

Line 507: FND_MSG_PUB.Count_And_Get (

503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO UPDATE_Imp_Doc_PVT;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );

Line 516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

512:
513: WHEN OTHERS THEN
514: ROLLBACK TO UPDATE_Imp_Doc_PVT;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message

Line 518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

514: ROLLBACK TO UPDATE_Imp_Doc_PVT;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,

Line 521: FND_MSG_PUB.Count_And_Get (

517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );

Line 597: FND_MSG_PUB.initialize;

593:
594: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF FND_API.to_Boolean( p_init_msg_list )
596: THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600:
601:

Line 645: FND_MSG_PUB.Count_And_Get

641: END IF;
642:
643:
644: -- Standard call to get message count and if count is 1, get message info.
645: FND_MSG_PUB.Count_And_Get
646: (p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: EXCEPTION

Line 659: FND_MSG_PUB.Count_And_Get (

655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO DELETE_Imp_Doc_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: -- Standard call to get message count and if count=1, get the message
659: FND_MSG_PUB.Count_And_Get (
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_msg_count,
662: p_data => x_msg_data
663: );

Line 669: FND_MSG_PUB.Count_And_Get (

665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO DELETE_Imp_Doc_PVT;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );

Line 678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

674:
675: WHEN OTHERS THEN
676: ROLLBACK TO DELETE_Imp_Doc_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
681: END IF;
682: -- Standard call to get message count and if count=1, get the message

Line 680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

676: ROLLBACK TO DELETE_Imp_Doc_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
681: END IF;
682: -- Standard call to get message count and if count=1, get the message
683: FND_MSG_PUB.Count_And_Get (
684: p_encoded => FND_API.G_FALSE,

Line 683: FND_MSG_PUB.Count_And_Get (

679: THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
681: END IF;
682: -- Standard call to get message count and if count=1, get the message
683: FND_MSG_PUB.Count_And_Get (
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_msg_count,
686: p_data => x_msg_data
687: );

Line 763: FND_MSG_PUB.initialize;

759:
760: -- Initialize message list if p_init_msg_list is set to TRUE.
761: IF FND_API.to_Boolean( p_init_msg_list )
762: THEN
763: FND_MSG_PUB.initialize;
764: END IF;
765:
766:
767:

Line 798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

794: FETCH c_imp_doc INTO l_imp_document_id;
795:
796: IF (c_imp_doc%NOTFOUND) THEN
797: CLOSE c_imp_doc;
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
799: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
800: FND_MSG_PUB.add;
801: END IF;
802: RAISE FND_API.g_exc_error;

Line 800: FND_MSG_PUB.add;

796: IF (c_imp_doc%NOTFOUND) THEN
797: CLOSE c_imp_doc;
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
799: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
800: FND_MSG_PUB.add;
801: END IF;
802: RAISE FND_API.g_exc_error;
803: END IF;
804:

Line 808: FND_MSG_PUB.count_and_get(

804:
805: CLOSE c_imp_doc;
806:
807: -------------------- finish --------------------------
808: FND_MSG_PUB.count_and_get(
809: p_encoded => FND_API.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data);
812: IF (AMS_DEBUG_HIGH_ON) THEN

Line 826: FND_MSG_PUB.Count_And_Get (

822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO LOCK_Imp_Doc_PVT;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: -- Standard call to get message count and if count=1, get the message
826: FND_MSG_PUB.Count_And_Get (
827: p_encoded => FND_API.G_FALSE,
828: p_count => x_msg_count,
829: p_data => x_msg_data
830: );

Line 836: FND_MSG_PUB.Count_And_Get (

832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: ROLLBACK TO LOCK_Imp_Doc_PVT;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: -- Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );

Line 845: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

841:
842: WHEN OTHERS THEN
843: ROLLBACK TO LOCK_Imp_Doc_PVT;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
848: END IF;
849: -- Standard call to get message count and if count=1, get the message

Line 847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

843: ROLLBACK TO LOCK_Imp_Doc_PVT;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
848: END IF;
849: -- Standard call to get message count and if count=1, get the message
850: FND_MSG_PUB.Count_And_Get (
851: p_encoded => FND_API.G_FALSE,

Line 850: FND_MSG_PUB.Count_And_Get (

846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
848: END IF;
849: -- Standard call to get message count and if count=1, get the message
850: FND_MSG_PUB.Count_And_Get (
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data
854: );

Line 1318: FND_MSG_PUB.initialize;

1314:
1315: -- Initialize message list if p_init_msg_list is set to TRUE.
1316: IF FND_API.to_Boolean( p_init_msg_list )
1317: THEN
1318: FND_MSG_PUB.initialize;
1319: END IF;
1320:
1321:
1322: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1384: FND_MSG_PUB.Count_And_Get

1380: END IF;
1381:
1382:
1383: -- Standard call to get message count and if count is 1, get message info.
1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1388: EXCEPTION

Line 1398: FND_MSG_PUB.Count_And_Get (

1394: WHEN FND_API.G_EXC_ERROR THEN
1395: ROLLBACK TO VALIDATE_Imp_Doc_;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: -- Standard call to get message count and if count=1, get the message
1398: FND_MSG_PUB.Count_And_Get (
1399: p_encoded => FND_API.G_FALSE,
1400: p_count => x_msg_count,
1401: p_data => x_msg_data
1402: );

Line 1408: FND_MSG_PUB.Count_And_Get (

1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405: ROLLBACK TO VALIDATE_Imp_Doc_;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: -- Standard call to get message count and if count=1, get the message
1408: FND_MSG_PUB.Count_And_Get (
1409: p_encoded => FND_API.G_FALSE,
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );

Line 1417: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1413:
1414: WHEN OTHERS THEN
1415: ROLLBACK TO VALIDATE_Imp_Doc_;
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1420: END IF;
1421: -- Standard call to get message count and if count=1, get the message

Line 1419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1415: ROLLBACK TO VALIDATE_Imp_Doc_;
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1420: END IF;
1421: -- Standard call to get message count and if count=1, get the message
1422: FND_MSG_PUB.Count_And_Get (
1423: p_encoded => FND_API.G_FALSE,

Line 1422: FND_MSG_PUB.Count_And_Get (

1418: THEN
1419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1420: END IF;
1421: -- Standard call to get message count and if count=1, get the message
1422: FND_MSG_PUB.Count_And_Get (
1423: p_encoded => FND_API.G_FALSE,
1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );

Line 1443: FND_MSG_PUB.initialize;

1439: BEGIN
1440: -- Initialize message list if p_init_msg_list is set to TRUE.
1441: IF FND_API.to_Boolean( p_init_msg_list )
1442: THEN
1443: FND_MSG_PUB.initialize;
1444: END IF;
1445:
1446:
1447:

Line 1462: FND_MSG_PUB.Count_And_Get

1458:
1459: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1460: END IF;
1461: -- Standard call to get message count and if count is 1, get message info.
1462: FND_MSG_PUB.Count_And_Get
1463: (p_count => x_msg_count,
1464: p_data => x_msg_data
1465: );
1466: END Validate_imp_doc_Rec;