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.PV_CHECK_MATCH_PUB dependencies on FND_API

Line 245: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data
243: );
244:
245: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
246: RAISE FND_API.G_EXC_ERROR;
247:
248: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
249: RAISE FND_API.g_exc_unexpected_error;

Line 246: RAISE FND_API.G_EXC_ERROR;

242: x_msg_data => l_msg_data
243: );
244:
245: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
246: RAISE FND_API.G_EXC_ERROR;
247:
248: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
249: RAISE FND_API.g_exc_unexpected_error;
250: END IF;

Line 248: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

244:
245: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
246: RAISE FND_API.G_EXC_ERROR;
247:
248: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
249: RAISE FND_API.g_exc_unexpected_error;
250: END IF;
251:
252: IF (NOT x_entity_attr_value.EXISTS(p_attribute_id)) THEN

Line 249: RAISE FND_API.g_exc_unexpected_error;

245: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
246: RAISE FND_API.G_EXC_ERROR;
247:
248: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
249: RAISE FND_API.g_exc_unexpected_error;
250: END IF;
251:
252: IF (NOT x_entity_attr_value.EXISTS(p_attribute_id)) THEN
253: RETURN FALSE;

Line 277: WHEN FND_API.G_EXC_ERROR THEN

273:
274: RETURN l_matched;
275:
276: EXCEPTION
277: WHEN FND_API.G_EXC_ERROR THEN
278: RETURN FALSE;
279: --RAISE;
280:
281: WHEN FND_API.g_exc_unexpected_error THEN

Line 281: WHEN FND_API.g_exc_unexpected_error THEN

277: WHEN FND_API.G_EXC_ERROR THEN
278: RETURN FALSE;
279: --RAISE;
280:
281: WHEN FND_API.g_exc_unexpected_error THEN
282: RETURN FALSE;
283: -- RAISE;
284:
285: WHEN OTHERS THEN

Line 430: RAISE FND_API.G_EXC_ERROR;

426: p_token1_value => l_rule_attr_value_temp,
427: p_token2 => 'attribute_to_value string',
428: p_token2_value => p_rule_to_attr_value);
429:
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432: END IF;
433:
434:

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532:
533:
534: -------------------- Exception --------------------------
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: RETURN FALSE;
538: --RAISE;
539:
540: WHEN FND_API.g_exc_unexpected_error THEN

Line 540: WHEN FND_API.g_exc_unexpected_error THEN

536: WHEN FND_API.G_EXC_ERROR THEN
537: RETURN FALSE;
538: --RAISE;
539:
540: WHEN FND_API.g_exc_unexpected_error THEN
541: RETURN FALSE;
542: --RAISE;
543:
544: WHEN OTHERS THEN

Line 573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

569: --| |
570: --==============================================================================
571: PROCEDURE Get_Entity_Attr_Values (
572: p_api_version_number IN NUMBER,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
576: p_attribute_id IN NUMBER,
577: p_entity IN VARCHAR2,

Line 574: p_commit IN VARCHAR2 := FND_API.G_FALSE,

570: --==============================================================================
571: PROCEDURE Get_Entity_Attr_Values (
572: p_api_version_number IN NUMBER,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
576: p_attribute_id IN NUMBER,
577: p_entity IN VARCHAR2,
578: p_entity_id IN NUMBER,

Line 575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

571: PROCEDURE Get_Entity_Attr_Values (
572: p_api_version_number IN NUMBER,
573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
576: p_attribute_id IN NUMBER,
577: p_entity IN VARCHAR2,
578: p_entity_id IN NUMBER,
579: p_delimiter IN VARCHAR2,

Line 621: IF FND_API.to_boolean(p_init_msg_list) THEN

617: q1.attribute_id = p_attribute_id;
618:
619: BEGIN
620: -------------------- initialize -------------------------
621: IF FND_API.to_boolean(p_init_msg_list) THEN
622: FND_MSG_PUB.initialize;
623: END IF;
624:
625: IF NOT FND_API.compatible_api_call(

Line 625: IF NOT FND_API.compatible_api_call(

621: IF FND_API.to_boolean(p_init_msg_list) THEN
622: FND_MSG_PUB.initialize;
623: END IF;
624:
625: IF NOT FND_API.compatible_api_call(
626: l_api_version,
627: p_api_version_number,
628: l_api_name,
629: g_pkg_name

Line 631: RAISE FND_API.g_exc_unexpected_error;

627: p_api_version_number,
628: l_api_name,
629: g_pkg_name
630: ) THEN
631: RAISE FND_API.g_exc_unexpected_error;
632: END IF;
633:
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630: ) THEN
631: RAISE FND_API.g_exc_unexpected_error;
632: END IF;
633:
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: -------------------------- Source code --------------------
637:
638: -- --------------------------------------------------------------------------

Line 687: RAISE FND_API.G_EXC_ERROR;

683: p_token1_value => 'There is no SQL TEXT for this attribute: ' || p_attribute_id,
684: p_token2 => 'TEXT',
685: p_token2_value => 'Entity Type: ' || p_entity);
686:
687: RAISE FND_API.G_EXC_ERROR;
688: END IF;
689:
690: --BEGIN
691: -- -------------------------------------------------------------------------

Line 810: RAISE FND_API.G_EXC_ERROR;

806: END IF;
807:
808: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');
809: fnd_msg_pub.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811:
812: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
813: p_msg_name => 'PV_NULL_TOKEN',
814: p_token1 => 'Attribute Value',

Line 817: RAISE FND_API.G_EXC_ERROR;

813: p_msg_name => 'PV_NULL_TOKEN',
814: p_token1 => 'Attribute Value',
815: p_token1_value => l_attr_value);
816:
817: RAISE FND_API.G_EXC_ERROR;
818: END IF;
819: END IF;
820:
821: -- ..................................................................

Line 839: RAISE FND_API.G_EXC_ERROR;

835: END IF;
836:
837: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');
838: fnd_msg_pub.ADD;
839: RAISE FND_API.G_EXC_ERROR;
840:
841: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
842: p_msg_name => 'PV_NULL_TOKEN',
843: p_token1 => 'Attribute Value',

Line 846: RAISE FND_API.G_EXC_ERROR;

842: p_msg_name => 'PV_NULL_TOKEN',
843: p_token1 => 'Attribute Value',
844: p_token1_value => l_attr_value);
845:
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: -- ..................................................................
850: -- 4 tokens

Line 885: RAISE FND_API.G_EXC_ERROR;

881: END IF;
882:
883: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');
884: fnd_msg_pub.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886:
887: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
888: p_msg_name => 'PV_NULL_TOKEN',
889: p_token1 => 'Attribute Value',

Line 892: RAISE FND_API.G_EXC_ERROR;

888: p_msg_name => 'PV_NULL_TOKEN',
889: p_token1 => 'Attribute Value',
890: p_token1_value => l_attr_value);
891:
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894: END IF;
895: END IF;
896:

Line 1007: p_encoded => FND_API.g_false,

1003: END IF;
1004:
1005: -------------------- finish --------------------------
1006: FND_MSG_PUB.count_and_get(
1007: p_encoded => FND_API.g_false,
1008: p_count => x_msg_count,
1009: p_data => x_msg_data
1010: );
1011:

Line 1014: WHEN FND_API.G_EXC_ERROR THEN

1010: );
1011:
1012: -------------------- Exception --------------------------
1013: EXCEPTION
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1016: p_msg_name => 'PV_DEBUG_MSG',
1017: p_token1 => 'TEXT',
1018: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,

Line 1022: x_return_status := FND_API.G_RET_STS_ERROR;

1018: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,
1019: p_token2 => null,
1020: p_token2_value => null);
1021:
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1024: p_count => x_msg_count,
1025: p_data => x_msg_data);
1026:

Line 1023: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1019: p_token2 => null,
1020: p_token2_value => null);
1021:
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1024: p_count => x_msg_count,
1025: p_data => x_msg_data);
1026:
1027: RAISE;

Line 1029: WHEN FND_API.g_exc_unexpected_error THEN

1025: p_data => x_msg_data);
1026:
1027: RAISE;
1028:
1029: WHEN FND_API.g_exc_unexpected_error THEN
1030: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1031: p_msg_name => 'PV_DEBUG_MSG',
1032: p_token1 => 'TEXT',
1033: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,

Line 1037: x_return_status := FND_API.g_ret_sts_unexp_error;

1033: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,
1034: p_token2 => null,
1035: p_token2_value => null);
1036:
1037: x_return_status := FND_API.g_ret_sts_unexp_error;
1038: FND_MSG_PUB.count_and_get(
1039: p_encoded => FND_API.g_false,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data

Line 1039: p_encoded => FND_API.g_false,

1035: p_token2_value => null);
1036:
1037: x_return_status := FND_API.g_ret_sts_unexp_error;
1038: FND_MSG_PUB.count_and_get(
1039: p_encoded => FND_API.g_false,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );
1043:

Line 1060: x_return_status := FND_API.g_ret_sts_unexp_error;

1056: p_token2 => null,
1057: p_token2_value => null);
1058:
1059:
1060: x_return_status := FND_API.g_ret_sts_unexp_error;
1061: FND_MSG_PUB.count_and_get(
1062: p_encoded => FND_API.g_false,
1063: p_count => x_msg_count,
1064: p_data => x_msg_data

Line 1062: p_encoded => FND_API.g_false,

1058:
1059:
1060: x_return_status := FND_API.g_ret_sts_unexp_error;
1061: FND_MSG_PUB.count_and_get(
1062: p_encoded => FND_API.g_false,
1063: p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066:

Line 1081: x_return_status := FND_API.g_ret_sts_unexp_error;

1077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1078: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1079: END IF;
1080:
1081: x_return_status := FND_API.g_ret_sts_unexp_error;
1082: FND_MSG_PUB.count_and_get(
1083: p_encoded => FND_API.g_false,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data

Line 1083: p_encoded => FND_API.g_false,

1079: END IF;
1080:
1081: x_return_status := FND_API.g_ret_sts_unexp_error;
1082: FND_MSG_PUB.count_and_get(
1083: p_encoded => FND_API.g_false,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );
1087:

Line 1113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1109: --| |
1110: --==============================================================================
1111: PROCEDURE Retrieve_Input_Filter (
1112: p_api_version_number IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1116: p_process_rule_id IN NUMBER,
1117: p_delimiter IN VARCHAR2 := '+++',

Line 1114: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1110: --==============================================================================
1111: PROCEDURE Retrieve_Input_Filter (
1112: p_api_version_number IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1116: p_process_rule_id IN NUMBER,
1117: p_delimiter IN VARCHAR2 := '+++',
1118: x_input_filter IN OUT NOCOPY t_input_filter,

Line 1115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1111: PROCEDURE Retrieve_Input_Filter (
1112: p_api_version_number IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1116: p_process_rule_id IN NUMBER,
1117: p_delimiter IN VARCHAR2 := '+++',
1118: x_input_filter IN OUT NOCOPY t_input_filter,
1119: x_return_status OUT NOCOPY VARCHAR2,

Line 1146: IF FND_API.to_boolean(p_init_msg_list) THEN

1142: l_api_name VARCHAR2(30) := 'RETRIEVE_INPUT_FILTER';
1143:
1144: BEGIN
1145: -------------------- initialize -------------------------
1146: IF FND_API.to_boolean(p_init_msg_list) THEN
1147: FND_MSG_PUB.initialize;
1148: END IF;
1149:
1150: IF NOT FND_API.compatible_api_call(

Line 1150: IF NOT FND_API.compatible_api_call(

1146: IF FND_API.to_boolean(p_init_msg_list) THEN
1147: FND_MSG_PUB.initialize;
1148: END IF;
1149:
1150: IF NOT FND_API.compatible_api_call(
1151: l_api_version,
1152: p_api_version_number,
1153: l_api_name,
1154: g_pkg_name

Line 1156: RAISE FND_API.g_exc_unexpected_error;

1152: p_api_version_number,
1153: l_api_name,
1154: g_pkg_name
1155: ) THEN
1156: RAISE FND_API.g_exc_unexpected_error;
1157: END IF;
1158:
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;
1160:

Line 1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

1155: ) THEN
1156: RAISE FND_API.g_exc_unexpected_error;
1157: END IF;
1158:
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;
1160:
1161:
1162: -------------------------- Source code --------------------
1163:

Line 1194: WHEN FND_API.G_EXC_ERROR THEN

1190: END IF;
1191:
1192: -------------------- Exception --------------------------
1193: EXCEPTION
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR;

1191:
1192: -------------------- Exception --------------------------
1193: EXCEPTION
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:

Line 1196: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1192: -------------------- Exception --------------------------
1193: EXCEPTION
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: WHEN FND_API.g_exc_unexpected_error THEN

Line 1200: WHEN FND_API.g_exc_unexpected_error THEN

1196: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: WHEN FND_API.g_exc_unexpected_error THEN
1201: x_return_status := FND_API.g_ret_sts_unexp_error;
1202: FND_MSG_PUB.count_and_get(
1203: p_encoded => FND_API.g_false,
1204: p_count => x_msg_count,

Line 1201: x_return_status := FND_API.g_ret_sts_unexp_error;

1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: WHEN FND_API.g_exc_unexpected_error THEN
1201: x_return_status := FND_API.g_ret_sts_unexp_error;
1202: FND_MSG_PUB.count_and_get(
1203: p_encoded => FND_API.g_false,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data

Line 1203: p_encoded => FND_API.g_false,

1199:
1200: WHEN FND_API.g_exc_unexpected_error THEN
1201: x_return_status := FND_API.g_ret_sts_unexp_error;
1202: FND_MSG_PUB.count_and_get(
1203: p_encoded => FND_API.g_false,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );
1207:

Line 1213: x_return_status := FND_API.G_RET_STS_ERROR;

1209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1210: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1211: END IF;
1212:
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: FND_MSG_PUB.count_and_get(
1215: p_encoded => FND_API.g_false,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data

Line 1215: p_encoded => FND_API.g_false,

1211: END IF;
1212:
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: FND_MSG_PUB.count_and_get(
1215: p_encoded => FND_API.g_false,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: IF (p_no_exception_flag = 'Y') THEN
1314: RETURN null;
1315:
1316: ELSE
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319: END; -- End of BEGIN-END
1320:
1321: IF (l_conversion_status_flag = 1) THEN

Line 1335: RAISE FND_API.G_EXC_ERROR;

1331: IF (p_no_exception_flag = 'Y') THEN
1332: RETURN null;
1333:
1334: ELSE
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: END IF;
1338:
1339: RETURN l_converted_attr_value;

Line 1343: WHEN FND_API.G_EXC_ERROR THEN

1339: RETURN l_converted_attr_value;
1340:
1341: -------------------- Exception --------------------------
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1345: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1346: END IF;
1347:

Line 1350: WHEN FND_API.g_exc_unexpected_error THEN

1346: END IF;
1347:
1348: RAISE;
1349:
1350: WHEN FND_API.g_exc_unexpected_error THEN
1351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1352: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1353: END IF;
1354:

Line 1456: RAISE FND_API.G_EXC_ERROR;

1452: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1453: p_token2 => null,
1454: p_token2_value => null);
1455:
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458:
1459:
1460: -- ---------------------------------------------------------------------------

Line 1514: RAISE FND_API.G_EXC_ERROR;

1510: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1511: p_token2 => 'TEXT',
1512: p_token2_value => 'This attribute value does not have a currency code!');
1513:
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517:
1518: l_currency_date := TO_DATE(Retrieve_Token (

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1550: p_token2 => 'TEXT',
1551: p_token2_value => 'This attribute value does not have a currency conversion date!');
1552:
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556:
1557: -- ----------------------------------------------------------------------------

Line 1614: RAISE FND_API.G_EXC_ERROR;

1610: IF (p_no_exception_flag = 'Y') THEN
1611: RETURN null;
1612:
1613: ELSE
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;
1616: END; -- End of BEGIN-END
1617:
1618: IF (l_conversion_status_flag = 1) THEN

Line 1632: RAISE FND_API.G_EXC_ERROR;

1628: IF (p_no_exception_flag = 'Y') THEN
1629: RETURN null;
1630:
1631: ELSE
1632: RAISE FND_API.G_EXC_ERROR;
1633: END IF;
1634: END IF;
1635:
1636: RETURN l_converted_attr_value;

Line 1640: WHEN FND_API.G_EXC_ERROR THEN

1636: RETURN l_converted_attr_value;
1637:
1638: -------------------- Exception --------------------------
1639: EXCEPTION
1640: WHEN FND_API.G_EXC_ERROR THEN
1641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1642: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644:

Line 1647: WHEN FND_API.g_exc_unexpected_error THEN

1643: END IF;
1644:
1645: RAISE;
1646:
1647: WHEN FND_API.g_exc_unexpected_error THEN
1648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1649: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1650: END IF;
1651:

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: p_rule_currency_code => p_rule_currency_code
1827: );
1828:
1829: IF (l_entity_num_attr_value = g_currency_conversion_error) THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: /* ---------------------------------------------------------------
1834: l_rule_num_attr_value :=

Line 1906: RAISE FND_API.G_EXC_ERROR;

1902: p_token1_value => p_operator,
1903: p_token2 => 'Attribute Return Type',
1904: p_token2_value => p_return_type);
1905:
1906: RAISE FND_API.G_EXC_ERROR;
1907: END IF;
1908:
1909: -- ----------------------------------------------------------
1910: -- operator -> GREATER_THAN_OR_EQUALS

Line 1931: RAISE FND_API.G_EXC_ERROR;

1927: p_token1_value => p_operator,
1928: p_token2 => 'Attribute Return Type',
1929: p_token2_value => p_return_type);
1930:
1931: RAISE FND_API.G_EXC_ERROR;
1932: END IF;
1933:
1934: -- ----------------------------------------------------------
1935: -- operator -> LESS_THAN

Line 1956: RAISE FND_API.G_EXC_ERROR;

1952: p_token1_value => p_operator,
1953: p_token2 => 'Attribute Return Type',
1954: p_token2_value => p_return_type);
1955:
1956: RAISE FND_API.G_EXC_ERROR;
1957: END IF;
1958:
1959: -- ----------------------------------------------------------
1960: -- operator -> LESS_THAN_OR_EQUALS

Line 1981: RAISE FND_API.G_EXC_ERROR;

1977: p_token1_value => p_operator,
1978: p_token2 => 'Attribute Return Type',
1979: p_token2_value => p_return_type);
1980:
1981: RAISE FND_API.G_EXC_ERROR;
1982: END IF;
1983:
1984: -- ----------------------------------------------------------
1985: -- operator -> NOT_EQUALS

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: p_token1_value => p_operator,
2057: p_token2 => 'Attribute Return Type',
2058: p_token2_value => p_return_type);
2059:
2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;
2062:
2063:
2064: -- ----------------------------------------------------------

Line 2085: RAISE FND_API.G_EXC_ERROR;

2081: p_token1_value => p_operator,
2082: p_token2 => 'Attribute Return Type',
2083: p_token2_value => p_return_type);
2084:
2085: RAISE FND_API.G_EXC_ERROR;
2086: END IF;
2087:
2088:
2089: -- ----------------------------------------------------------

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: p_token1_value => p_operator,
2111: p_token2 => 'Attribute Return Type',
2112: p_token2_value => p_return_type);
2113:
2114: RAISE FND_API.G_EXC_ERROR;
2115: END IF;
2116:
2117:
2118: -- ----------------------------------------------------------

Line 2135: RAISE FND_API.G_EXC_ERROR;

2131: p_token1_value => p_operator,
2132: p_token2 => 'Attribute Return Type',
2133: p_token2_value => p_return_type);
2134:
2135: RAISE FND_API.G_EXC_ERROR;
2136: END IF;
2137:
2138:
2139: -- ----------------------------------------------------------

Line 2156: RAISE FND_API.G_EXC_ERROR;

2152: p_token1_value => p_operator,
2153: p_token2 => 'Attribute Return Type',
2154: p_token2_value => p_return_type);
2155:
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158:
2159:
2160: -- ----------------------------------------------------------

Line 2187: RAISE FND_API.G_EXC_ERROR;

2183: p_token1_value => p_operator,
2184: p_token2 => 'Attribute Return Type',
2185: p_token2_value => p_return_type);
2186:
2187: RAISE FND_API.G_EXC_ERROR;
2188: END IF;
2189:
2190: RETURN l_matched;
2191: END Check_Match_Logic;