DBA Data[Home] [Help]

APPS.AMS_IMP_DOC_CON_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_Content(

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_Content(
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_Content(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 115: FND_MSG_PUB.initialize;

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

Line 231: FND_MSG_PUB.Count_And_Get

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

Line 245: FND_MSG_PUB.Count_And_Get (

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

Line 255: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 269: FND_MSG_PUB.Count_And_Get (

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

Line 360: FND_MSG_PUB.initialize;

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

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

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

Line 477: FND_MSG_PUB.Count_And_Get

473: END IF;
474:
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get
478: (p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: EXCEPTION

Line 491: FND_MSG_PUB.Count_And_Get (

487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Imp_Doc_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );

Line 501: FND_MSG_PUB.Count_And_Get (

497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Imp_Doc_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
505: );

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

506:
507: WHEN OTHERS THEN
508: ROLLBACK TO UPDATE_Imp_Doc_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message

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

508: ROLLBACK TO UPDATE_Imp_Doc_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,

Line 515: FND_MSG_PUB.Count_And_Get (

511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );

Line 591: FND_MSG_PUB.initialize;

587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: IF FND_API.to_Boolean( p_init_msg_list )
590: THEN
591: FND_MSG_PUB.initialize;
592: END IF;
593:
594:
595:

Line 639: FND_MSG_PUB.Count_And_Get

635: END IF;
636:
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get
640: (p_count => x_msg_count,
641: p_data => x_msg_data
642: );
643: EXCEPTION

Line 653: FND_MSG_PUB.Count_And_Get (

649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Imp_Doc_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );

Line 663: FND_MSG_PUB.Count_And_Get (

659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Imp_Doc_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );

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

668:
669: WHEN OTHERS THEN
670: ROLLBACK TO DELETE_Imp_Doc_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message

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

670: ROLLBACK TO DELETE_Imp_Doc_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,

Line 677: FND_MSG_PUB.Count_And_Get (

673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );

Line 757: FND_MSG_PUB.initialize;

753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_Boolean( p_init_msg_list )
756: THEN
757: FND_MSG_PUB.initialize;
758: END IF;
759:
760:
761:

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

788: FETCH c_imp_doc INTO l_imp_document_id;
789:
790: IF (c_imp_doc%NOTFOUND) THEN
791: CLOSE c_imp_doc;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
794: FND_MSG_PUB.add;
795: END IF;
796: RAISE FND_API.g_exc_error;

Line 794: FND_MSG_PUB.add;

790: IF (c_imp_doc%NOTFOUND) THEN
791: CLOSE c_imp_doc;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
794: FND_MSG_PUB.add;
795: END IF;
796: RAISE FND_API.g_exc_error;
797: END IF;
798:

Line 802: FND_MSG_PUB.count_and_get(

798:
799: CLOSE c_imp_doc;
800:
801: -------------------- finish --------------------------
802: FND_MSG_PUB.count_and_get(
803: p_encoded => FND_API.g_false,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806: IF (AMS_DEBUG_HIGH_ON) THEN

Line 820: FND_MSG_PUB.Count_And_Get (

816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO LOCK_Imp_Doc_PVT;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );

Line 830: FND_MSG_PUB.Count_And_Get (

826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO LOCK_Imp_Doc_PVT;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: -- Standard call to get message count and if count=1, get the message
830: FND_MSG_PUB.Count_And_Get (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data
834: );

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

835:
836: WHEN OTHERS THEN
837: ROLLBACK TO LOCK_Imp_Doc_PVT;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843: -- Standard call to get message count and if count=1, get the message

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

837: ROLLBACK TO LOCK_Imp_Doc_PVT;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,

Line 844: FND_MSG_PUB.Count_And_Get (

840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );

Line 1272: FND_MSG_PUB.initialize;

1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list )
1271: THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275:
1276: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1338: FND_MSG_PUB.Count_And_Get

1334: END IF;
1335:
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get
1339: (p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342: EXCEPTION

Line 1352: FND_MSG_PUB.Count_And_Get (

1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_Imp_Doc_;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

Line 1362: FND_MSG_PUB.Count_And_Get (

1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO VALIDATE_Imp_Doc_;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (
1363: p_encoded => FND_API.G_FALSE,
1364: p_count => x_msg_count,
1365: p_data => x_msg_data
1366: );

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

1367:
1368: WHEN OTHERS THEN
1369: ROLLBACK TO VALIDATE_Imp_Doc_;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message

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

1369: ROLLBACK TO VALIDATE_Imp_Doc_;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,

Line 1376: FND_MSG_PUB.Count_And_Get (

1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );

Line 1397: FND_MSG_PUB.initialize;

1393: BEGIN
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400:
1401:

Line 1416: FND_MSG_PUB.Count_And_Get

1412:
1413: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1414: END IF;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: (p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );
1420: END Validate_imp_doc_Rec;