eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_THLDCHK_PVT dependencies on FND_MSG_PUB

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

56: -- 06/29/1999 ptendulk created
57: -- 10/26/1999 ptendulk Modified according to new standards
58: -- End of Comments
59:
60: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_thldchk

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

57: -- 10/26/1999 ptendulk Modified according to new standards
58: -- End of Comments
59:
60: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_thldchk
65: ( p_api_version IN NUMBER,

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

58: -- End of Comments
59:
60: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_thldchk
65: ( p_api_version 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: --
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: --
118: -- Standard call to check for call compatibility.

Line 279: FND_MSG_PUB.Count_AND_Get

275:
276: --
277: -- Standard call to get message count AND IF count is 1, get message info.
278: --
279: FND_MSG_PUB.Count_AND_Get
280: ( p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => FND_API.G_FALSE
283: );

Line 299: FND_MSG_PUB.Count_AND_Get

295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO Create_Thldchk_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298:
299: FND_MSG_PUB.Count_AND_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data,
302: p_encoded => FND_API.G_FALSE
303: );

Line 309: FND_MSG_PUB.Count_AND_Get

305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306: ROLLBACK TO Create_Thldchk_PVT;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308:
309: FND_MSG_PUB.Count_AND_Get
310: ( p_count => x_msg_count,
311: p_data => x_msg_data,
312: p_encoded => FND_API.G_FALSE
313: );

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

315: WHEN OTHERS THEN
316: ROLLBACK TO Create_Thldchk_PVT;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318:
319: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
322: END IF;
323:

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

317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318:
319: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
322: END IF;
323:
324: FND_MSG_PUB.Count_AND_Get
325: ( p_count => x_msg_count,

Line 324: FND_MSG_PUB.Count_AND_Get

320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
322: END IF;
323:
324: FND_MSG_PUB.Count_AND_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => FND_API.G_FALSE
328: );

Line 386: FND_MSG_PUB.initialize;

382: --
383: -- Initialize message list IF p_init_msg_list is set to TRUE.
384: --
385: IF FND_API.to_Boolean( p_init_msg_list ) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: --
390: -- Standard call to check for call compatibility.

Line 428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

424:
425: IF (SQL%NOTFOUND) THEN
426: -- Error, check the msg level and added an error message to the
427: -- API message list
428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
429: THEN -- MMSG
430: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
431: FND_MSG_PUB.Add;
432: END IF;

Line 431: FND_MSG_PUB.Add;

427: -- API message list
428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
429: THEN -- MMSG
430: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
431: FND_MSG_PUB.Add;
432: END IF;
433:
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;

Line 451: FND_MSG_PUB.Count_AND_Get

447:
448: --
449: -- Standard call to get message count AND IF count is 1, get message info.
450: --
451: FND_MSG_PUB.Count_AND_Get
452: ( p_count => x_msg_count,
453: p_data => x_msg_data,
454: p_encoded => FND_API.G_FALSE
455: );

Line 462: FND_MSG_PUB.Count_AND_Get

458: WHEN FND_API.G_EXC_ERROR THEN
459: ROLLBACK TO Delete_Thldchk_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461:
462: FND_MSG_PUB.Count_AND_Get
463: ( p_count => x_msg_count,
464: p_data => x_msg_data,
465: p_encoded => FND_API.G_FALSE
466: );

Line 472: FND_MSG_PUB.Count_AND_Get

468:
469: ROLLBACK TO Delete_Thldchk_PVT;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471:
472: FND_MSG_PUB.Count_AND_Get
473: ( p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => FND_API.G_FALSE
476: );

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

478:
479: ROLLBACK TO Delete_Thldchk_PVT;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481:
482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
485: END IF;
486:

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

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481:
482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
485: END IF;
486:
487: FND_MSG_PUB.Count_AND_Get
488: ( p_count => x_msg_count,

Line 487: FND_MSG_PUB.Count_AND_Get

483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
485: END IF;
486:
487: FND_MSG_PUB.Count_AND_Get
488: ( p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => FND_API.G_FALSE
491: );

Line 551: FND_MSG_PUB.initialize;

547: --
548: -- Initialize message list if p_init_msg_list is set to TRUE.
549: --
550: IF FND_API.to_boolean(p_init_msg_list) THEN
551: FND_MSG_PUB.initialize;
552: END IF;
553:
554: --
555: -- Standard call to check for call compatibility.

Line 587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

583: IF (c_ams_trigger_checks%NOTFOUND) THEN
584: CLOSE c_ams_trigger_checks;
585: -- Error, check the msg level and added an error message to the
586: -- API message list
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
588: THEN -- MMSG
589: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.Add;
591: END IF;

Line 590: FND_MSG_PUB.Add;

586: -- API message list
587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
588: THEN -- MMSG
589: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.Add;
591: END IF;
592:
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;

Line 605: FND_MSG_PUB.Count_AND_Get

601:
602: --
603: -- Standard call to get message count AND IF count is 1, get message info.
604: --
605: FND_MSG_PUB.Count_AND_Get
606: ( p_count => x_msg_count,
607: p_data => x_msg_data,
608: p_encoded => FND_API.G_FALSE
609: );

Line 622: FND_MSG_PUB.Count_AND_Get

618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR ;
621:
622: FND_MSG_PUB.Count_AND_Get
623: ( p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => FND_API.G_FALSE
626: );

Line 631: FND_MSG_PUB.Count_AND_Get

627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
630:
631: FND_MSG_PUB.Count_AND_Get
632: ( p_count => x_msg_count,
633: p_data => x_msg_data,
634: p_encoded => FND_API.G_FALSE
635: );

Line 640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

636:
637: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639:
640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
641: THEN -- MMSG
642: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.Add;
644: END IF;

Line 643: FND_MSG_PUB.Add;

639:
640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
641: THEN -- MMSG
642: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.Add;
644: END IF;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,

Line 646: FND_MSG_PUB.Count_AND_Get

642: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.Add;
644: END IF;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );

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

651:
652: WHEN OTHERS THEN
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
654:
655: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
656: THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
658: END IF;
659:

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

653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
654:
655: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
656: THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
658: END IF;
659:
660: FND_MSG_PUB.Count_AND_Get
661: ( p_count => x_msg_count,

Line 660: FND_MSG_PUB.Count_AND_Get

656: THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
658: END IF;
659:
660: FND_MSG_PUB.Count_AND_Get
661: ( p_count => x_msg_count,
662: p_data => x_msg_data,
663: p_encoded => FND_API.G_FALSE
664: );

Line 725: FND_MSG_PUB.initialize;

721: --
722: -- Initialize message list IF p_init_msg_list is set to TRUE.
723: --
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727:
728: --
729: -- Standard call to check for call compatibility.

Line 824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

820:
821: IF (SQL%NOTFOUND) THEN
822: -- Error, check the msg level and added an error message to the
823: -- API message list
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
825: THEN -- MMSG
826: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
827: FND_MSG_PUB.Add;
828: END IF;

Line 827: FND_MSG_PUB.Add;

823: -- API message list
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
825: THEN -- MMSG
826: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
827: FND_MSG_PUB.Add;
828: END IF;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:

Line 845: FND_MSG_PUB.Count_AND_Get

841:
842: --
843: -- Standard call to get message count AND IF count is 1, get message info.
844: --
845: FND_MSG_PUB.Count_AND_Get
846: ( p_count => x_msg_count,
847: p_data => x_msg_data,
848: p_encoded => FND_API.G_FALSE
849: );

Line 864: FND_MSG_PUB.Count_AND_Get

860: WHEN FND_API.G_EXC_ERROR THEN
861: ROLLBACK TO Update_Thldchk_PVT;
862: x_return_status := FND_API.G_RET_STS_ERROR ;
863:
864: FND_MSG_PUB.Count_AND_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data,
867: p_encoded => FND_API.G_FALSE
868: );

Line 874: FND_MSG_PUB.Count_AND_Get

870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO Update_Thldchk_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873:
874: FND_MSG_PUB.Count_AND_Get
875: ( p_count => x_msg_count,
876: p_data => x_msg_data,
877: p_encoded => FND_API.G_FALSE
878: );

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

880: WHEN OTHERS THEN
881: ROLLBACK TO Update_Thldchk_PVT;
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883:
884: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
885: THEN
886: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
887: END IF;
888:

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

882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883:
884: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
885: THEN
886: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
887: END IF;
888:
889: FND_MSG_PUB.Count_AND_Get
890: ( p_count => x_msg_count,

Line 889: FND_MSG_PUB.Count_AND_Get

885: THEN
886: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
887: END IF;
888:
889: FND_MSG_PUB.Count_AND_Get
890: ( p_count => x_msg_count,
891: p_data => x_msg_data,
892: p_encoded => FND_API.G_FALSE
893: );

Line 944: FND_MSG_PUB.initialize;

940: END IF;
941:
942: -- Initialize message list if p_init_msg_list is set to TRUE.
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946:
947: -- Standard call to check for call compatibility.
948: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1002: FND_MSG_PUB.Count_AND_Get

998:
999: --
1000: -- Standard call to get message count AND IF count is 1, get message info.
1001: --
1002: FND_MSG_PUB.Count_AND_Get
1003: ( p_count => x_msg_count,
1004: p_data => x_msg_data,
1005: p_encoded => FND_API.G_FALSE
1006: );

Line 1020: FND_MSG_PUB.Count_AND_Get

1016: EXCEPTION
1017:
1018: WHEN FND_API.G_EXC_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_ERROR ;
1020: FND_MSG_PUB.Count_AND_Get
1021: ( p_count => x_msg_count,
1022: p_data => x_msg_data,
1023: p_encoded => FND_API.G_FALSE
1024: );

Line 1028: FND_MSG_PUB.Count_AND_Get

1024: );
1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028: FND_MSG_PUB.Count_AND_Get
1029: ( p_count => x_msg_count,
1030: p_data => x_msg_data,
1031: p_encoded => FND_API.G_FALSE
1032: );

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

1032: );
1033:
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1036: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1037: THEN
1038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1039: END IF;
1040:

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

1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1036: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1037: THEN
1038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1039: END IF;
1040:
1041: FND_MSG_PUB.Count_AND_Get
1042: ( p_count => x_msg_count,

Line 1041: FND_MSG_PUB.Count_AND_Get

1037: THEN
1038: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1039: END IF;
1040:
1041: FND_MSG_PUB.Count_AND_Get
1042: ( p_count => x_msg_count,
1043: p_data => x_msg_data,
1044: p_encoded => FND_API.G_FALSE
1045: );

Line 1805: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1801:
1802: -- IF l_thldchk_rec.chk2_uom_code IS NOT NULL
1803: -- THEN
1804: -- IF l_chk1_met_rec.metric_uom_code IS NULL THEN
1805: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1806: -- THEN
1807: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_NULL');
1808: -- FND_MSG_PUB.Add;
1809: -- END IF;

Line 1808: -- FND_MSG_PUB.Add;

1804: -- IF l_chk1_met_rec.metric_uom_code IS NULL THEN
1805: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1806: -- THEN
1807: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_NULL');
1808: -- FND_MSG_PUB.Add;
1809: -- END IF;
1810: -- x_return_status := FND_API.G_RET_STS_ERROR;
1811: -- RETURN;
1812: -- ELSE

Line 1830: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1826: -- ,p_pk_data_type => l_pk_data_type
1827: -- ,p_additional_where_clause => l_additional_where_clause
1828: -- ) = FND_API.G_FALSE
1829: -- THEN
1830: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1831: -- THEN
1832: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM');
1833: -- FND_MSG_PUB.Add;
1834: -- END IF;

Line 1833: -- FND_MSG_PUB.Add;

1829: -- THEN
1830: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1831: -- THEN
1832: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM');
1833: -- FND_MSG_PUB.Add;
1834: -- END IF;
1835:
1836: -- x_return_status := FND_API.G_RET_STS_ERROR;
1837: -- RETURN;

Line 1842: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1838: -- END IF; -- Check_FK_Exists--
1839: -- END IF;
1840: -- ELSE
1841: -- IF l_chk1_met_rec.metric_uom_code IS NOT NULL THEN
1842: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1843: -- THEN
1844: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_NULL');
1845: -- FND_MSG_PUB.Add;
1846: -- END IF;

Line 1845: -- FND_MSG_PUB.Add;

1841: -- IF l_chk1_met_rec.metric_uom_code IS NOT NULL THEN
1842: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1843: -- THEN
1844: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_NULL');
1845: -- FND_MSG_PUB.Add;
1846: -- END IF;
1847:
1848: -- x_return_status := FND_API.G_RET_STS_ERROR;
1849: -- RETURN;

Line 1856: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1852:
1853:
1854: -- IF l_thldchk_rec.chk2_currency_code IS NOT NULL THEN
1855: -- IF l_chk1_met_rec.transaction_currency_code IS NULL THEN
1856: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1857: -- THEN
1858: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR_NULL');
1859: -- FND_MSG_PUB.Add;
1860: -- END IF;

Line 1859: -- FND_MSG_PUB.Add;

1855: -- IF l_chk1_met_rec.transaction_currency_code IS NULL THEN
1856: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1857: -- THEN
1858: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR_NULL');
1859: -- FND_MSG_PUB.Add;
1860: -- END IF;
1861:
1862: -- x_return_status := FND_API.G_RET_STS_ERROR;
1863: -- RETURN;

Line 1882: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1878: -- ,p_pk_data_type => l_pk_data_type
1879: -- ,p_additional_where_clause => l_additional_where_clause
1880: -- ) = FND_API.G_FALSE
1881: -- THEN
1882: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1883: -- THEN
1884: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR');
1885: -- FND_MSG_PUB.Add;
1886: -- END IF;

Line 1885: -- FND_MSG_PUB.Add;

1881: -- THEN
1882: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1883: -- THEN
1884: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR');
1885: -- FND_MSG_PUB.Add;
1886: -- END IF;
1887:
1888: -- x_return_status := FND_API.G_RET_STS_ERROR;
1889: -- RETURN;

Line 1894: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1890: -- END IF; -- Check_FK_Exists
1891: -- END IF;
1892: -- ELSE
1893: -- IF l_chk1_met_rec.transaction_currency_code IS NOT NULL THEN
1894: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1895: -- THEN
1896: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR_NULL');
1897: -- FND_MSG_PUB.Add;
1898: --END IF;

Line 1897: -- FND_MSG_PUB.Add;

1893: -- IF l_chk1_met_rec.transaction_currency_code IS NOT NULL THEN
1894: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1895: -- THEN
1896: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR_NULL');
1897: -- FND_MSG_PUB.Add;
1898: --END IF;
1899:
1900: --x_return_status := FND_API.G_RET_STS_ERROR;
1901: -- RETURN;

Line 1923: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1919: -- CLOSE c_met_det ;
1920:
1921: -- IF l_chk1_met_rec.transaction_currency_code <> l_chk2_met_rec.transaction_currency_code
1922: -- OR l_chk1_met_rec.metric_uom_code <> l_chk2_met_rec.metric_uom_code THEN
1923: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1924: -- THEN
1925: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_CURR');
1926: -- FND_MSG_PUB.Add;
1927: -- END IF;

Line 1926: -- FND_MSG_PUB.Add;

1922: -- OR l_chk1_met_rec.metric_uom_code <> l_chk2_met_rec.metric_uom_code THEN
1923: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1924: -- THEN
1925: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_UOM_CURR');
1926: -- FND_MSG_PUB.Add;
1927: -- END IF;
1928:
1929: -- x_return_status := FND_API.G_RET_STS_ERROR;
1930: -- RETURN;

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

2024: OPEN c_thldchk;
2025: FETCH c_thldchk INTO l_thldchk_rec;
2026: IF c_thldchk%NOTFOUND THEN
2027: CLOSE c_thldchk;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2029: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2030: FND_MSG_PUB.add;
2031: END IF;
2032: RAISE FND_API.g_exc_error;

Line 2030: FND_MSG_PUB.add;

2026: IF c_thldchk%NOTFOUND THEN
2027: CLOSE c_thldchk;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2029: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2030: FND_MSG_PUB.add;
2031: END IF;
2032: RAISE FND_API.g_exc_error;
2033: END IF;
2034: CLOSE c_thldchk;