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_TRIG_PVT dependencies on FND_MSG_PUB

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

37: ---------------------------------- Triggers --------------------------------------------
38: ----------------------------------------------------------------------------------------
39: ----------------------------------------------------------------------------------------
40: ----------------------------------------------------------------------------------------
41: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Calculate_System_Time(

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

38: ----------------------------------------------------------------------------------------
39: ----------------------------------------------------------------------------------------
40: ----------------------------------------------------------------------------------------
41: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Calculate_System_Time(
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

39: ----------------------------------------------------------------------------------------
40: ----------------------------------------------------------------------------------------
41: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Calculate_System_Time(
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: x_msg_count OUT NOCOPY NUMBER ,

Line 139: FND_MSG_PUB.initialize;

135:
136: END IF;
137:
138: IF FND_API.to_boolean(p_init_msg_list) THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: --
143: -- Standard call to check for call compatibility.

Line 450: FND_MSG_PUB.Count_AND_Get

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

Line 471: FND_MSG_PUB.Count_AND_Get

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

Line 483: FND_MSG_PUB.Count_AND_Get

479:
480: ROLLBACK TO Create_Trig_PVT;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482:
483: FND_MSG_PUB.Count_AND_Get
484: ( p_count => x_msg_count,
485: p_data => x_msg_data,
486: p_encoded => FND_API.G_FALSE
487: );

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

490:
491: ROLLBACK TO Create_Trig_PVT;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493:
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498:

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

492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
493:
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498:
499: FND_MSG_PUB.Count_AND_Get
500: ( p_count => x_msg_count,

Line 499: FND_MSG_PUB.Count_AND_Get

495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498:
499: FND_MSG_PUB.Count_AND_Get
500: ( p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => FND_API.G_FALSE
503: );

Line 604: FND_MSG_PUB.initialize;

600: --
601: -- Initialize message list IF p_init_msg_list is set to TRUE.
602: --
603: IF FND_API.to_Boolean( p_init_msg_list ) THEN
604: FND_MSG_PUB.initialize;
605: END IF;
606:
607: --
608: -- Standard call to check for call compatibility.

Line 735: FND_MSG_PUB.Count_AND_Get

731:
732: --
733: -- Standard call to get message count AND IF count is 1, get message info.
734: --
735: FND_MSG_PUB.Count_AND_Get
736: ( p_count => x_msg_count,
737: p_data => x_msg_data,
738: p_encoded => FND_API.G_FALSE
739: );

Line 756: FND_MSG_PUB.Count_AND_Get

752:
753: ROLLBACK TO Delete_Trig_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:
756: FND_MSG_PUB.Count_AND_Get
757: ( p_count => x_msg_count,
758: p_data => x_msg_data,
759: p_encoded => FND_API.G_FALSE
760: );

Line 768: FND_MSG_PUB.Count_AND_Get

764:
765: ROLLBACK TO Delete_Trig_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:
768: FND_MSG_PUB.Count_AND_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data,
771: p_encoded => FND_API.G_FALSE
772: );

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

776:
777: ROLLBACK TO Delete_Trig_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
781: THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784:

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

778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
781: THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784:
785: FND_MSG_PUB.Count_AND_Get
786: ( p_count => x_msg_count,

Line 785: FND_MSG_PUB.Count_AND_Get

781: THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784:
785: FND_MSG_PUB.Count_AND_Get
786: ( p_count => x_msg_count,
787: p_data => x_msg_data,
788: p_encoded => FND_API.G_FALSE
789: );

Line 857: FND_MSG_PUB.initialize;

853: --
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: --
856: IF FND_API.to_Boolean( p_init_msg_list ) THEN
857: FND_MSG_PUB.initialize;
858: END IF;
859:
860: IF NOT FND_API.Compatible_API_Call ( l_api_version,
861: p_api_version,

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

889: IF (C_ams_triggers%NOTFOUND) THEN
890: CLOSE C_ams_triggers;
891: -- Error, check the msg level and added an error message to the
892: -- API message list
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
894: THEN -- MMSG
895: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
896: FND_MSG_PUB.Add;
897: END IF;

Line 896: FND_MSG_PUB.Add;

892: -- API message list
893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
894: THEN -- MMSG
895: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
896: FND_MSG_PUB.Add;
897: END IF;
898:
899: RAISE FND_API.G_EXC_ERROR;
900: END IF;

Line 913: FND_MSG_PUB.Count_AND_Get

909:
910: --
911: -- Standard call to get message count AND IF count is 1, get message info.
912: --
913: FND_MSG_PUB.Count_AND_Get
914: ( p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE
917: );

Line 931: FND_MSG_PUB.Count_AND_Get

927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR ;
930:
931: FND_MSG_PUB.Count_AND_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => FND_API.G_FALSE
935: );

Line 939: FND_MSG_PUB.Count_AND_Get

935: );
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
938:
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,
942: p_encoded => FND_API.G_FALSE
943: );

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

944:
945: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947:
948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
949: THEN -- MMSG
950: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
951: FND_MSG_PUB.Add;
952: END IF;

Line 951: FND_MSG_PUB.Add;

947:
948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
949: THEN -- MMSG
950: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
951: FND_MSG_PUB.Add;
952: END IF;
953:
954: FND_MSG_PUB.Count_AND_Get
955: ( p_count => x_msg_count,

Line 954: FND_MSG_PUB.Count_AND_Get

950: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
951: FND_MSG_PUB.Add;
952: END IF;
953:
954: FND_MSG_PUB.Count_AND_Get
955: ( p_count => x_msg_count,
956: p_data => x_msg_data,
957: p_encoded => FND_API.G_FALSE
958: );

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

959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
964: THEN
965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
966: END IF;
967:

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

961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
964: THEN
965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
966: END IF;
967:
968: FND_MSG_PUB.Count_AND_Get
969: ( p_count => x_msg_count,

Line 968: FND_MSG_PUB.Count_AND_Get

964: THEN
965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
966: END IF;
967:
968: FND_MSG_PUB.Count_AND_Get
969: ( p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE
972: );

Line 1042: FND_MSG_PUB.initialize;

1038: --
1039: -- Initialize message list IF p_init_msg_list is set to TRUE.
1040: --
1041: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044:
1045: --
1046: -- Standard call to check for call compatibility.

Line 1221: FND_MSG_PUB.count_and_get(

1217:
1218: --
1219: -- Get message count AND IF count is 1, get message info.
1220: --
1221: FND_MSG_PUB.count_and_get(
1222: p_encoded => FND_API.g_false,
1223: p_count => x_msg_count,
1224: p_data => x_msg_data
1225: );

Line 1238: FND_MSG_PUB.Count_AND_Get

1234:
1235: ROLLBACK TO Update_Trig_PVT;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237:
1238: FND_MSG_PUB.Count_AND_Get
1239: ( p_count => x_msg_count,
1240: p_data => x_msg_data,
1241: p_encoded => FND_API.G_FALSE
1242: );

Line 1249: FND_MSG_PUB.Count_AND_Get

1245:
1246: ROLLBACK TO Update_Trig_PVT;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:
1249: FND_MSG_PUB.Count_AND_Get
1250: ( p_count => x_msg_count,
1251: p_data => x_msg_data,
1252: p_encoded => FND_API.G_FALSE
1253: );

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

1256:
1257: ROLLBACK TO Update_Trig_PVT;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259:
1260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1263: END IF;
1264:

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

1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259:
1260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1263: END IF;
1264:
1265: FND_MSG_PUB.Count_AND_Get
1266: ( p_count => x_msg_count,

Line 1265: FND_MSG_PUB.Count_AND_Get

1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1263: END IF;
1264:
1265: FND_MSG_PUB.Count_AND_Get
1266: ( p_count => x_msg_count,
1267: p_data => x_msg_data,
1268: p_encoded => FND_API.G_FALSE
1269: );

Line 1479: FND_MSG_PUB.initialize;

1475: AMS_Utility_PVT.debug_message(l_full_name||': start');
1476: END IF;
1477:
1478: IF FND_API.to_boolean(p_init_msg_list) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481:
1482: IF NOT FND_API.compatible_api_call(
1483: l_api_version,

Line 1540: FND_MSG_PUB.count_and_get(

1536: END IF;
1537: END IF;
1538:
1539: -------------------- finish --------------------------
1540: FND_MSG_PUB.count_and_get(
1541: p_encoded => FND_API.g_false,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data
1544: );

Line 1557: FND_MSG_PUB.count_and_get(

1553:
1554: EXCEPTION
1555: WHEN FND_API.g_exc_error THEN
1556: x_return_status := FND_API.g_ret_sts_error;
1557: FND_MSG_PUB.count_and_get(
1558: p_encoded => FND_API.g_false,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data
1561: );

Line 1565: FND_MSG_PUB.count_and_get(

1561: );
1562:
1563: WHEN FND_API.g_exc_unexpected_error THEN
1564: x_return_status := FND_API.g_ret_sts_unexp_error ;
1565: FND_MSG_PUB.count_and_get(
1566: p_encoded => FND_API.g_false,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data
1569: );

Line 1573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1569: );
1570:
1571: WHEN OTHERS THEN
1572: x_return_status := FND_API.g_ret_sts_unexp_error;
1573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1574: THEN
1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1576: END IF;
1577:

Line 1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1571: WHEN OTHERS THEN
1572: x_return_status := FND_API.g_ret_sts_unexp_error;
1573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1574: THEN
1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1576: END IF;
1577:
1578: FND_MSG_PUB.count_and_get(
1579: p_encoded => FND_API.g_false,

Line 1578: FND_MSG_PUB.count_and_get(

1574: THEN
1575: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1576: END IF;
1577:
1578: FND_MSG_PUB.count_and_get(
1579: p_encoded => FND_API.g_false,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data
1582: );

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

2146: --
2147: IF l_end_date IS NOT NULL THEN
2148: IF l_start_date > l_end_date THEN
2149: -- invalid item
2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2151: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2152: FND_MSG_PUB.Add;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2152: FND_MSG_PUB.Add;

2148: IF l_start_date > l_end_date THEN
2149: -- invalid item
2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2151: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2152: FND_MSG_PUB.Add;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_ERROR;
2155: RETURN;
2156: END IF;

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

2180:
2181: IF l_tz_end_date < SYSDATE THEN
2182: -- IF l_end_date < SYSDATE THEN
2183: -- IF l_end_date > SYSDATE THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_END_DT');
2186: FND_MSG_PUB.Add;
2187: END IF;
2188: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2186: FND_MSG_PUB.Add;

2182: -- IF l_end_date < SYSDATE THEN
2183: -- IF l_end_date > SYSDATE THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_END_DT');
2186: FND_MSG_PUB.Add;
2187: END IF;
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: RETURN;
2190: END IF;

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

2201: -- x_dt => l_act_dt ) ;
2202:
2203: -- IF l_act_dt < l_end_date THEN
2204: -- -- invalid item
2205: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2206: -- THEN -- MMSG
2207: ---- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
2208: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2209: -- FND_MSG_PUB.Add;

Line 2209: -- FND_MSG_PUB.Add;

2205: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2206: -- THEN -- MMSG
2207: ---- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
2208: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
2209: -- FND_MSG_PUB.Add;
2210: -- END IF;
2211: -- x_return_status := FND_API.G_RET_STS_ERROR;
2212: -- -- If any errors happen abort API/Procedure.
2213: -- RETURN;

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

2408: OPEN c_trig;
2409: FETCH c_trig INTO l_trig_rec;
2410: IF c_trig%NOTFOUND THEN
2411: CLOSE c_trig;
2412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2414: FND_MSG_PUB.add;
2415: END IF;
2416: RAISE FND_API.g_exc_error;

Line 2414: FND_MSG_PUB.add;

2410: IF c_trig%NOTFOUND THEN
2411: CLOSE c_trig;
2412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2414: FND_MSG_PUB.add;
2415: END IF;
2416: RAISE FND_API.g_exc_error;
2417: END IF;
2418: CLOSE c_trig;