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 AMS_UTILITY_PVT

Line 107: AMS_Utility_PVT.debug_message(l_full_name||': start');

103: -- Debug Message
104: --
105: IF (AMS_DEBUG_HIGH_ON) THEN
106:
107: AMS_Utility_PVT.debug_message(l_full_name||': start');
108: END IF;
109:
110: --
111: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 142: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

138: -- Validate Trigger Check
139: --
140: IF (AMS_DEBUG_HIGH_ON) THEN
141:
142: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
143: END IF;
144:
145: Validate_Thldchk ( p_api_version => 1.0
146: ,p_init_msg_list => p_init_msg_list

Line 166: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

162: -- Insert the Record in Trigger Checks table
163: --
164: IF (AMS_DEBUG_HIGH_ON) THEN
165:
166: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
167: END IF;
168:
169: --
170: -- Find the Unique Primary Key if not sent

Line 289: AMS_Utility_PVT.debug_message(l_full_name ||': end');

285: IF (AMS_DEBUG_HIGH_ON) THEN
286:
287:
288:
289: AMS_Utility_PVT.debug_message(l_full_name ||': end');
290:
291: END IF;
292:
293:

Line 379: AMS_Utility_PVT.debug_message(l_full_name||': start');

375: -- Debug Message
376: --
377: IF (AMS_DEBUG_HIGH_ON) THEN
378:
379: AMS_Utility_PVT.debug_message(l_full_name||': start');
380: END IF;
381:
382: --
383: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 412: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

408: -- Debug Message
409: --
410: IF (AMS_DEBUG_HIGH_ON) THEN
411:
412: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
413: END IF;
414:
415: --
416: -- Debug Message

Line 544: AMS_Utility_PVT.debug_message(l_full_name||': start');

540: -- Debug Message
541: --
542: IF (AMS_DEBUG_HIGH_ON) THEN
543:
544: AMS_Utility_PVT.debug_message(l_full_name||': start');
545: END IF;
546:
547: --
548: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 577: AMS_Utility_PVT.debug_message(l_full_name||': lock');

573: -- Lock the Trigger Check
574: --
575: IF (AMS_DEBUG_HIGH_ON) THEN
576:
577: AMS_Utility_PVT.debug_message(l_full_name||': lock');
578: END IF;
579:
580: -- Perform the database operation
581: OPEN c_ams_trigger_checks;

Line 615: AMS_Utility_PVT.debug_message(l_full_name ||': end');

611: -- Debug Message
612: --
613: IF (AMS_DEBUG_HIGH_ON) THEN
614:
615: AMS_Utility_PVT.debug_message(l_full_name ||': end');
616: END IF;
617:
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN

Line 637: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN

633: p_data => x_msg_data,
634: p_encoded => FND_API.G_FALSE
635: );
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

Line 718: AMS_Utility_PVT.debug_message(l_full_name||': start');

714: -- Debug Message
715: --
716: IF (AMS_DEBUG_HIGH_ON) THEN
717:
718: AMS_Utility_PVT.debug_message(l_full_name||': start');
719: END IF;
720:
721: --
722: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 753: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

749: -- Debug Message
750: --
751: IF (AMS_DEBUG_HIGH_ON) THEN
752:
753: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
754: END IF;
755:
756: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
757: Check_thldchk_Items(

Line 856: AMS_Utility_PVT.debug_message(l_full_name ||': end');

852: -- Debug Message
853: --
854: IF (AMS_DEBUG_HIGH_ON) THEN
855:
856: AMS_Utility_PVT.debug_message(l_full_name ||': end');
857: END IF;
858:
859: EXCEPTION
860: WHEN FND_API.G_EXC_ERROR THEN

Line 939: AMS_Utility_PVT.debug_message(l_full_name||': start');

935: -- Debug Message
936: --
937: IF (AMS_DEBUG_HIGH_ON) THEN
938:
939: AMS_Utility_PVT.debug_message(l_full_name||': start');
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

Line 983: AMS_Utility_PVT.debug_message(l_full_name||': check record');

979: -- Debug Message
980: --
981: IF (AMS_DEBUG_HIGH_ON) THEN
982:
983: AMS_Utility_PVT.debug_message(l_full_name||': check record');
984: END IF;
985:
986: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
987: Check_Thldchk_Record(

Line 1013: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1009: -- Debug Message
1010: --
1011: IF (AMS_DEBUG_HIGH_ON) THEN
1012:
1013: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1014: END IF;
1015:
1016: EXCEPTION
1017:

Line 1081: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_TRIG_ID');

1077: -- Trigger ID
1078: --
1079: IF p_thldchk_rec.trigger_id IS NULL
1080: THEN
1081: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_TRIG_ID');
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: RETURN;
1084: END IF;
1085:

Line 1091: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK1_TYPE');

1087: -- Chk1_type
1088: --
1089: IF p_thldchk_rec.chk1_type IS NULL
1090: THEN
1091: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK1_TYPE');
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: RETURN;
1094: END IF;
1095:

Line 1101: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_TYPE');

1097: -- Chk2_type
1098: --
1099: IF p_thldchk_rec.chk2_type IS NULL
1100: THEN
1101: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_TYPE');
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: RETURN;
1104: END IF;
1105:

Line 1111: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_OPERATOR');

1107: -- Chk1_to_chk2_operator_type
1108: --
1109: IF p_thldchk_rec.chk1_to_chk2_operator_type IS NULL
1110: THEN
1111: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_OPERATOR');
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113: -- If any errors happen abort API/Procedure.
1114: RETURN;
1115: END IF;

Line 1122: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET');

1118: -- chk1_source_code_metric_id
1119: --
1120: IF p_thldchk_rec.chk1_source_code_metric_id IS NULL
1121: THEN
1122: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET');
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: RETURN;
1125: END IF;
1126:

Line 1129: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK1_OBJ');

1125: END IF;
1126:
1127: IF p_thldchk_rec.chk1_act_object_id IS NULL
1128: THEN
1129: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK1_OBJ');
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: RETURN;
1132: END IF;
1133:

Line 1139: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET_TYPE');

1135: -- chk1_source_code_metric_type
1136: --
1137: IF p_thldchk_rec.chk1_source_code_metric_type IS NULL
1138: THEN
1139: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET_TYPE');
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: -- If any errors happen abort API/Procedure.
1142: RETURN;
1143: END IF;

Line 1182: IF AMS_Utility_PVT.check_uniqueness(

1178: -- check if this trigger_check_id is unique.
1179: IF p_validation_mode = JTF_PLSQL_API.g_create
1180: AND p_thldchk_rec.trigger_check_id IS NOT NULL
1181: THEN
1182: IF AMS_Utility_PVT.check_uniqueness(
1183: 'ams_trigger_checks',
1184: 'trigger_check_id = ' || p_thldchk_rec.trigger_check_id
1185: ) = FND_API.g_false
1186: THEN

Line 1187: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUPLICATE_CHECK');

1183: 'ams_trigger_checks',
1184: 'trigger_check_id = ' || p_thldchk_rec.trigger_check_id
1185: ) = FND_API.g_false
1186: THEN
1187: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUPLICATE_CHECK');
1188: x_return_status := FND_API.g_ret_sts_error;
1189: RETURN;
1190: END IF;
1191: END IF;

Line 1204: IF AMS_Utility_PVT.Check_Uniqueness(

1200: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1201: l_where_clause := l_where_clause || ' AND trigger_check_id <> ' || p_thldchk_rec.trigger_check_id;
1202: END IF;
1203:
1204: IF AMS_Utility_PVT.Check_Uniqueness(
1205: p_table_name => 'ams_trigger_checks',
1206: p_where_clause => l_where_clause
1207: ) = FND_API.g_false
1208: THEN

Line 1209: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUP_TRIG_ID');

1205: p_table_name => 'ams_trigger_checks',
1206: p_where_clause => l_where_clause
1207: ) = FND_API.g_false
1208: THEN
1209: AMS_Utility_PVT.Error_Message('AMS_TRIG_DUP_TRIG_ID');
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;
1212: END IF;
1213:

Line 1255: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1251: THEN
1252: l_table_name := 'AMS_TRIGGERS' ;
1253: l_pk_name := 'trigger_id' ;
1254: l_pk_value := p_thldchk_rec.trigger_id;
1255: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1256: l_additional_where_clause := NULL ;
1257:
1258: IF AMS_Utility_PVT.Check_Fk_Exists
1259: (p_table_name => l_table_name

Line 1258: IF AMS_Utility_PVT.Check_Fk_Exists

1254: l_pk_value := p_thldchk_rec.trigger_id;
1255: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1256: l_additional_where_clause := NULL ;
1257:
1258: IF AMS_Utility_PVT.Check_Fk_Exists
1259: (p_table_name => l_table_name
1260: ,p_PK_name => l_pk_name
1261: ,p_PK_value => l_pk_value
1262: ,p_pk_data_type => l_pk_data_type

Line 1265: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_TRIGGER_ID');

1261: ,p_PK_value => l_pk_value
1262: ,p_pk_data_type => l_pk_data_type
1263: ,p_additional_where_clause => l_additional_where_clause
1264: ) = FND_API.G_FALSE THEN
1265: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_TRIGGER_ID');
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: -- If any errors happen abort API/Procedure.
1268: RETURN;
1269: END IF;

Line 1312: IF AMS_Utility_PVT.Check_Lookup_Exists

1308: --
1309: -- Check Chk2_type
1310: IF p_thldchk_rec.chk2_type <> FND_API.G_MISS_CHAR
1311: THEN
1312: IF AMS_Utility_PVT.Check_Lookup_Exists
1313: ( p_lookup_table_name => 'AMS_LOOKUPS'
1314: ,p_lookup_type => 'AMS_TRIGGER_CHK_TYPE'
1315: ,p_lookup_code => p_thldchk_rec.chk2_type
1316: ) = FND_API.G_FALSE

Line 1318: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHECK_TYPE');

1314: ,p_lookup_type => 'AMS_TRIGGER_CHK_TYPE'
1315: ,p_lookup_code => p_thldchk_rec.chk2_type
1316: ) = FND_API.G_FALSE
1317: THEN
1318: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHECK_TYPE');
1319: x_return_status := FND_API.G_RET_STS_ERROR;
1320: RETURN;
1321: END IF;
1322: END IF;

Line 1329: IF AMS_Utility_PVT.Check_Lookup_Exists

1325: -- Check CHK1_SOURCE_CODE_METRIC_TYPE
1326: --
1327: IF p_thldchk_rec.chk1_source_code_metric_type <> FND_API.G_MISS_CHAR
1328: THEN
1329: IF AMS_Utility_PVT.Check_Lookup_Exists
1330: ( p_lookup_table_name => 'AMS_LOOKUPS'
1331: ,p_lookup_type => 'AMS_MONITOR_CHK_METRIC_TYPE'
1332: ,p_lookup_code => p_thldchk_rec.chk1_source_code_metric_type
1333: ) = FND_API.G_FALSE

Line 1335: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_METRIC_TYPE');

1331: ,p_lookup_type => 'AMS_MONITOR_CHK_METRIC_TYPE'
1332: ,p_lookup_code => p_thldchk_rec.chk1_source_code_metric_type
1333: ) = FND_API.G_FALSE
1334: THEN
1335: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_METRIC_TYPE');
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: RETURN;
1338: END IF;
1339: END IF;

Line 1580: AMS_Utility_PVT.debug_message('Sonali 1');

1576: IF (AMS_DEBUG_HIGH_ON) THEN
1577:
1578:
1579:
1580: AMS_Utility_PVT.debug_message('Sonali 1');
1581:
1582: END IF;
1583:
1584: l_table_name := 'ams_act_metrics_all' ;

Line 1587: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1583:
1584: l_table_name := 'ams_act_metrics_all' ;
1585: l_pk_name := 'activity_metric_id' ;
1586: l_pk_value := l_thldchk_rec.chk1_source_code_metric_id ;
1587: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1588: l_additional_where_clause := ' arc_act_metric_used_by = '||''''
1589: ||l_thldchk_rec.chk1_arc_source_code_from||''''
1590: ||' AND act_metric_used_by_id = '||l_thldchk_rec.chk1_act_object_id ;
1591:

Line 1596: AMS_Utility_PVT.debug_message('Sonali 2');

1592: IF (AMS_DEBUG_HIGH_ON) THEN
1593:
1594:
1595:
1596: AMS_Utility_PVT.debug_message('Sonali 2');
1597:
1598: END IF;
1599:
1600: /* IF AMS_Utility_PVT.Check_FK_Exists (

Line 1600: /* IF AMS_Utility_PVT.Check_FK_Exists (

1596: AMS_Utility_PVT.debug_message('Sonali 2');
1597:
1598: END IF;
1599:
1600: /* IF AMS_Utility_PVT.Check_FK_Exists (
1601: p_table_name => l_table_name
1602: ,p_pk_name => l_pk_name
1603: ,p_pk_value => l_pk_value
1604: ,p_pk_data_type => l_pk_data_type

Line 1608: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CREATED_FOR');

1604: ,p_pk_data_type => l_pk_data_type
1605: ,p_additional_where_clause => l_additional_where_clause
1606: ) = FND_API.G_FALSE
1607: THEN
1608: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CREATED_FOR');
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: RETURN;
1611: END IF;
1612: */

Line 1617: AMS_Utility_PVT.debug_message('Sonali 3');

1613: IF (AMS_DEBUG_HIGH_ON) THEN
1614:
1615:
1616:
1617: AMS_Utility_PVT.debug_message('Sonali 3');
1618:
1619: END IF;
1620:
1621: --

Line 1629: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_OBJ');

1625: IF (l_thldchk_rec.chk2_source_code_metric_id IS NULL OR
1626: l_thldchk_rec.chk2_arc_source_code_from IS NULL OR
1627: l_thldchk_rec.chk2_act_object_id IS NULL )
1628: THEN
1629: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_OBJ');
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: RETURN;
1632: ELSIF l_thldchk_rec.chk2_source_code_metric_type IS NULL
1633: THEN

Line 1634: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET_TYPE');

1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: RETURN;
1632: ELSIF l_thldchk_rec.chk2_source_code_metric_type IS NULL
1633: THEN
1634: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_MET_TYPE');
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: RETURN;
1637: END IF ;
1638:

Line 1643: AMS_Utility_PVT.debug_message('Sonali 4');

1639: IF (AMS_DEBUG_HIGH_ON) THEN
1640:
1641:
1642:
1643: AMS_Utility_PVT.debug_message('Sonali 4');
1644:
1645: END IF;
1646:
1647: --

Line 1675: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1671:
1672: l_table_name := 'ams_act_metrics_all' ;
1673: l_pk_name := 'activity_metric_id' ;
1674: l_pk_value := l_thldchk_rec.chk2_source_code_metric_id ;
1675: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1676: l_additional_where_clause := ' arc_act_metric_used_by = '||''''
1677: ||l_thldchk_rec.chk2_arc_source_code_from||''''
1678: ||' AND act_metric_used_by_id = '||l_thldchk_rec.chk2_act_object_id ;
1679:

Line 1684: AMS_Utility_PVT.debug_message('Sonali 5');

1680: IF (AMS_DEBUG_HIGH_ON) THEN
1681:
1682:
1683:
1684: AMS_Utility_PVT.debug_message('Sonali 5');
1685:
1686: END IF;
1687: IF AMS_Utility_PVT.Check_FK_Exists (
1688: p_table_name => l_table_name

Line 1687: IF AMS_Utility_PVT.Check_FK_Exists (

1683:
1684: AMS_Utility_PVT.debug_message('Sonali 5');
1685:
1686: END IF;
1687: IF AMS_Utility_PVT.Check_FK_Exists (
1688: p_table_name => l_table_name
1689: ,p_pk_name => l_pk_name
1690: ,p_pk_value => l_pk_value
1691: ,p_pk_data_type => l_pk_data_type

Line 1695: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHK2_MET');

1691: ,p_pk_data_type => l_pk_data_type
1692: ,p_additional_where_clause => l_additional_where_clause
1693: ) = FND_API.G_FALSE
1694: THEN
1695: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHK2_MET');
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: RETURN;
1698: END IF;
1699: END IF;

Line 1706: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_WB_NAME');

1702:
1703: IF l_thldchk_rec.chk2_type = 'DIWB' THEN
1704: IF l_thldchk_rec.chk2_workbook_name IS NULL
1705: THEN
1706: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_WB_NAME');
1707: x_return_status := FND_API.G_RET_STS_ERROR;
1708: RETURN;
1709: ELSE
1710: --

Line 1718: AMS_Utility_PVT.debug_message('Sonali 6');

1714: IF (AMS_DEBUG_HIGH_ON) THEN
1715:
1716:
1717:
1718: AMS_Utility_PVT.debug_message('Sonali 6');
1719:
1720: END IF;
1721:
1722: IF (p_thldchk_rec.chk2_workbook_name IS NOT NULL AND

Line 1729: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;

1725: l_table_name := 'ams_discoverer_sql' ;
1726: l_pk_name := 'workbook_name' ;
1727: -- modified by soagrawa on 23-aug-2002 for bug# 2528692
1728: l_pk_wb_value := l_thldchk_rec.chk2_workbook_name ;
1729: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1730: l_additional_where_clause := NULL ;
1731:
1732: IF (AMS_DEBUG_HIGH_ON) THEN
1733:

Line 1736: AMS_Utility_PVT.debug_message('Sonali 7');

1732: IF (AMS_DEBUG_HIGH_ON) THEN
1733:
1734:
1735:
1736: AMS_Utility_PVT.debug_message('Sonali 7');
1737:
1738: END IF;
1739:
1740: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1740: IF AMS_Utility_PVT.Check_FK_Exists (

1736: AMS_Utility_PVT.debug_message('Sonali 7');
1737:
1738: END IF;
1739:
1740: IF AMS_Utility_PVT.Check_FK_Exists (
1741: p_table_name => l_table_name
1742: ,p_pk_name => l_pk_name
1743: -- modified by soagrawa on 23-aug-2002 for bug# 2528692
1744: ,p_pk_value => l_pk_wb_value

Line 1749: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_WB_NAME');

1745: ,p_pk_data_type => l_pk_data_type
1746: ,p_additional_where_clause => l_additional_where_clause
1747: ) = FND_API.G_FALSE
1748: THEN
1749: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_WB_NAME');
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: RETURN;
1752: END IF;
1753: END IF;

Line 1765: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_RANGE');

1761: IF l_thldchk_rec.chk1_to_chk2_operator_type = 'BETWEEN' THEN
1762: IF l_thldchk_rec.chk2_low_value IS NULL OR
1763: l_thldchk_rec.chk2_high_value IS NULL
1764: THEN
1765: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_CHK2_RANGE');
1766: x_return_status := FND_API.G_RET_STS_ERROR;
1767: RETURN;
1768: ELSE
1769: IF l_thldchk_rec.chk2_low_value > l_thldchk_rec.chk2_high_value

Line 1771: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHK2_RANGE');

1767: RETURN;
1768: ELSE
1769: IF l_thldchk_rec.chk2_low_value > l_thldchk_rec.chk2_high_value
1770: THEN
1771: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CHK2_RANGE');
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: RETURN;
1774: END IF;
1775: END IF ;

Line 1778: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_VALUE');

1774: END IF;
1775: END IF ;
1776: ELSE
1777: IF l_thldchk_rec.chk2_value IS NULL THEN
1778: AMS_Utility_PVT.Error_Message('AMS_TRIG_MISSING_VALUE');
1779: x_return_status := FND_API.G_RET_STS_ERROR ;
1780: RETURN ;
1781: END IF ;
1782: END IF;

Line 1819: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;

1815: -- --
1816: -- l_table_name := 'MTL_UNITS_OF_MEASURE';
1817: -- l_pk_name := 'UOM_CODE';
1818: -- l_pk_value := l_thldchk_rec.chk2_uom_code;
1819: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1820: -- l_additional_where_clause := ' uom_class = '||''''||l_chk1_met_rec.uom_type||'''';
1821:
1822: -- IF AMS_Utility_PVT.Check_FK_Exists (
1823: -- p_table_name => l_table_name

Line 1822: -- IF AMS_Utility_PVT.Check_FK_Exists (

1818: -- l_pk_value := l_thldchk_rec.chk2_uom_code;
1819: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1820: -- l_additional_where_clause := ' uom_class = '||''''||l_chk1_met_rec.uom_type||'''';
1821:
1822: -- IF AMS_Utility_PVT.Check_FK_Exists (
1823: -- p_table_name => l_table_name
1824: -- ,p_pk_name => l_pk_name
1825: -- ,p_pk_value => l_pk_value
1826: -- ,p_pk_data_type => l_pk_data_type

Line 1871: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;

1867: -- --
1868: -- l_table_name := 'FND_CURRENCIES';
1869: -- l_pk_name := 'CURRENCY_CODE';
1870: -- l_pk_value := l_thldchk_rec.chk2_currency_code;
1871: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1872: -- l_additional_where_clause := ' enabled_flag = '||''''||'Y'||'''';
1873:
1874: -- IF AMS_Utility_PVT.Check_FK_Exists (
1875: -- p_table_name => l_table_name

Line 1874: -- IF AMS_Utility_PVT.Check_FK_Exists (

1870: -- l_pk_value := l_thldchk_rec.chk2_currency_code;
1871: -- l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1872: -- l_additional_where_clause := ' enabled_flag = '||''''||'Y'||'''';
1873:
1874: -- IF AMS_Utility_PVT.Check_FK_Exists (
1875: -- p_table_name => l_table_name
1876: -- ,p_pk_name => l_pk_name
1877: -- ,p_pk_value => l_pk_value
1878: -- ,p_pk_data_type => l_pk_data_type