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_MSG_PUB

Line 286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

282: RETURN FALSE;
283: -- RAISE;
284:
285: WHEN OTHERS THEN
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
288: END IF;
289:
290: --RETURN FALSE;

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

283: -- RAISE;
284:
285: WHEN OTHERS THEN
286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
288: END IF;
289:
290: --RETURN FALSE;
291: RAISE;

Line 346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

342: l_operator VARCHAR2(50);
343: l_stop_flag BOOLEAN := FALSE;
344:
345: BEGIN
346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
347: Debug('Inside Check_Match =====================================');
348: Debug('Operator is: ' || p_operator);
349: Debug('Entity Attribute Value (80 chars): ' || substr(p_entity_attr_value,1,80));
350: Debug('Rule Attribute Value (80 chars): ' || substr(p_rule_attr_value,1,80));

Line 415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

411: END IF;
412:
413: l_num_of_tokens := Get_Num_Of_Tokens(p_delimiter, l_rule_attr_value_temp);
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
416: Debug('# of Rule Tokens: ' || l_num_of_tokens);
417: END IF;
418:
419: IF (UPPER(p_operator) = 'BETWEEN') THEN

Line 423: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

419: IF (UPPER(p_operator) = 'BETWEEN') THEN
420: l_num_of_to_tokens := Get_Num_Of_Tokens(p_delimiter, p_rule_to_attr_value);
421:
422: IF (l_num_of_tokens <> l_num_of_to_tokens) THEN
423: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
424: p_msg_name => 'PV_UNMATCHED_TOKEN_NUMBER',
425: p_token1 => 'attribute_value string',
426: p_token1_value => l_rule_attr_value_temp,
427: p_token2 => 'attribute_to_value string',

Line 478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

474: l_rule_to_attr_value := NULL;
475: END IF;
476: END IF;
477:
478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
479: Debug('Rule Token #' || i || '(80 chars): ' || substr(l_rule_attr_value,1,80));
480: Debug('Operator: ' || p_operator);
481: END IF;
482:

Line 545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

541: RETURN FALSE;
542: --RAISE;
543:
544: WHEN OTHERS THEN
545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
547: END IF;
548:
549: --RETURN FALSE;

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

542: --RAISE;
543:
544: WHEN OTHERS THEN
545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
547: END IF;
548:
549: --RETURN FALSE;
550: RAISE;

Line 622: FND_MSG_PUB.initialize;

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(
626: l_api_version,

Line 680: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

676: --Debug('SQL TEXT:::' );
677: --Debug(l_sql_text);
678:
679: IF (l_sql_text IS NULL OR LENGTH(l_sql_text) = 0) THEN
680: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
681: p_msg_name => 'PV_ABSENT_SQL_TEXT',
682: p_token1 => 'TEXT',
683: p_token1_value => 'There is no SQL TEXT for this attribute: ' || p_attribute_id,
684: p_token2 => 'TEXT',

Line 804: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

800: );
801: END IF;
802:
803: IF (l_token_value IS NULL) THEN
804: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
805: Debug('Null Token Found in: ' || l_attr_value);
806: END IF;
807:
808: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');

Line 809: fnd_msg_pub.ADD;

805: Debug('Null Token Found in: ' || l_attr_value);
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',

Line 812: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
815: p_token1_value => l_attr_value);
816:

Line 833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

829: p_index => 1
830: );
831:
832: IF (l_token_value IS NULL) THEN
833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
834: Debug('Null Token Found in: ' || l_attr_value);
835: END IF;
836:
837: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');

Line 838: fnd_msg_pub.ADD;

834: Debug('Null Token Found in: ' || l_attr_value);
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',

Line 841: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
844: p_token1_value => l_attr_value);
845:

Line 879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

875: END IF;
876: END IF;
877:
878: IF (l_token_value IS NULL) THEN
879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
880: Debug('Null Token Found in: ' || l_attr_value);
881: END IF;
882:
883: fnd_message.SET_NAME('PV', 'PV_NULL_TOKEN');

Line 884: fnd_msg_pub.ADD;

880: Debug('Null Token Found in: ' || l_attr_value);
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',

Line 887: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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',
890: p_token1_value => l_attr_value);
891:

Line 997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

993:
994: -- -------------------------------------------------------------
995: -- Debug Message.
996: -- -------------------------------------------------------------
997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
998: Debug('********************* Get_Entity_Attr_Values ******************');
999: l_msg_string := 'Attr Value: ' || x_entity_attr_value(p_attribute_id).attribute_value;
1000: -- Debug(l_msg_string);
1001: Debug('Return Type: ' || x_entity_attr_value(p_attribute_id).return_type);

Line 1006: FND_MSG_PUB.count_and_get(

1002: Debug('********************************************************************');
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: );

Line 1015: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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,
1019: p_token2 => null,

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 1030: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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,
1034: p_token2 => null,

Line 1038: FND_MSG_PUB.count_and_get(

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
1042: );

Line 1047: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1043:
1044: RAISE;
1045:
1046: WHEN g_e_no_bind_variable THEN
1047: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1048: Debug('This SQL Text does not have the right numbers of bind variables: ' );
1049: Debug(l_sql_text);
1050: END IF;
1051:

Line 1052: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1048: Debug('This SQL Text does not have the right numbers of bind variables: ' );
1049: Debug(l_sql_text);
1050: END IF;
1051:
1052: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1053: p_msg_name => 'PV_DEBUG_MSG',
1054: p_token1 => 'TEXT',
1055: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,
1056: p_token2 => null,

Line 1061: FND_MSG_PUB.count_and_get(

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
1065: );

Line 1070: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1066:
1067: RAISE;
1068:
1069: WHEN OTHERS THEN
1070: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1071: p_msg_name => 'PV_DEBUG_MSG',
1072: p_token1 => 'TEXT',
1073: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,
1074: p_token2 => null,

Line 1077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1073: p_token1_value => 'Exception raised while evaluating attribute ID: ' || p_attribute_id,
1074: p_token2 => null,
1075: p_token2_value => null);
1076:
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;

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

1074: p_token2 => null,
1075: p_token2_value => null);
1076:
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(

Line 1082: FND_MSG_PUB.count_and_get(

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
1086: );

Line 1147: FND_MSG_PUB.initialize;

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(
1151: l_api_version,

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 1202: FND_MSG_PUB.count_and_get(

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
1206: );

Line 1209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1205: p_data => x_msg_data
1206: );
1207:
1208: WHEN OTHERS THEN
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;

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

1206: );
1207:
1208: WHEN OTHERS THEN
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(

Line 1214: FND_MSG_PUB.count_and_get(

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
1218: );

Line 1304: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1300: );
1301:
1302: EXCEPTION
1303: WHEN NO_DATA_FOUND THEN
1304: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1305: p_msg_name => 'PV_NO_CURRENCY_RATE_INFO',
1306: p_token1 => 'Rule Currency Code',
1307: p_token1_value => p_rule_currency_code,
1308: p_token2 => 'Entity Currency Code',

Line 1322: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1318: END IF;
1319: END; -- End of BEGIN-END
1320:
1321: IF (l_conversion_status_flag = 1) THEN
1322: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1323: p_msg_name => 'PV_NO_CURRENCY_RATE_INFO',
1324: p_token1 => 'Rule Currency Code',
1325: p_token1_value => p_rule_currency_code,
1326: p_token2 => 'Entity Currency Code',

Line 1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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:
1348: RAISE;

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

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:
1348: RAISE;
1349:

Line 1351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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:
1355: RAISE;

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

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:
1355: RAISE;
1356:

Line 1358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1354:
1355: RAISE;
1356:
1357: WHEN OTHERS THEN
1358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1359: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1360: END IF;
1361:
1362: RAISE;

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

1355: RAISE;
1356:
1357: WHEN OTHERS THEN
1358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1359: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1360: END IF;
1361:
1362: RAISE;
1363:

Line 1428: --fnd_msg_pub.g_msg_level_threshold := fnd_msg_pub.g_msg_lvl_debug_low;

1424: le_rate_not_found EXCEPTION;
1425: le_wrong_token_numbers EXCEPTION;
1426:
1427: BEGIN
1428: --fnd_msg_pub.g_msg_level_threshold := fnd_msg_pub.g_msg_lvl_debug_low;
1429:
1430: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1431: (g_display_message))
1432: THEN

Line 1430: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND

1426:
1427: BEGIN
1428: --fnd_msg_pub.g_msg_level_threshold := fnd_msg_pub.g_msg_lvl_debug_low;
1429:
1430: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1431: (g_display_message))
1432: THEN
1433: Debug('Currency Conversion..........................................');
1434: END IF;

Line 1449: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1445: /LENGTH(g_token_delimiter)
1446: + 1;
1447:
1448: IF (l_num_of_tokens <> 3) THEN
1449: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1450: p_msg_name => 'PV_CURRENCY_WRONG_FORMAT',
1451: p_token1 => 'TEXT',
1452: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1453: p_token2 => null,

Line 1475: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND

1471: '999999999999.99'
1472: );
1473:
1474:
1475: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1476: (g_display_message))
1477: THEN
1478: Debug('Entity Attribute Value: ' || l_entity_attr_value);
1479: END IF;

Line 1497: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND

1493: p_index => 2
1494: );
1495:
1496:
1497: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1498: (g_display_message))
1499: THEN
1500: Debug('Entity Currency Code: ' || l_entity_currency_code);
1501: END IF;

Line 1507: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1503: -- ----------------------------------------------------------------------------
1504: -- Check for the existence of currency code.
1505: -- ----------------------------------------------------------------------------
1506: IF (l_entity_currency_code IS NULL) THEN
1507: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1508: p_msg_name => 'PV_NULL_TOKEN',
1509: p_token1 => 'TEXT',
1510: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1511: p_token2 => 'TEXT',

Line 1528: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND

1524: 'yyyymmddhh24miss');
1525:
1526:
1527:
1528: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1529: (g_display_message))
1530: THEN
1531: Debug('Currency Date: ' || l_currency_date);
1532: END IF;

Line 1546: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1542: -- ----------------------------------------------------------------------------
1543: -- Check for the existence of currency conversion date.
1544: -- ----------------------------------------------------------------------------
1545: IF (l_currency_date IS NULL) THEN
1546: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1547: p_msg_name => 'PV_NULL_TOKEN',
1548: p_token1 => 'TEXT',
1549: p_token1_value => 'Entity Attribute Value: ' || p_entity_attr_value,
1550: p_token2 => 'TEXT',

Line 1569: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND

1565: g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
1566: END IF;
1567:
1568:
1569: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) AND
1570: (g_display_message))
1571: THEN
1572: Debug('Period Set Name: ' || g_period_set_name);
1573: Debug('Period Type: ' || g_period_type);

Line 1601: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1597:
1598:
1599: EXCEPTION
1600: WHEN NO_DATA_FOUND THEN
1601: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1602: p_msg_name => 'PV_NO_CURRENCY_RATE_INFO',
1603: p_token1 => 'Rule Currency Code',
1604: p_token1_value => p_rule_currency_code,
1605: p_token2 => 'Entity Currency Code',

Line 1619: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1615: END IF;
1616: END; -- End of BEGIN-END
1617:
1618: IF (l_conversion_status_flag = 1) THEN
1619: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1620: p_msg_name => 'PV_NO_CURRENCY_RATE_INFO',
1621: p_token1 => 'Rule Currency Code',
1622: p_token1_value => p_rule_currency_code,
1623: p_token2 => 'Entity Currency Code',

Line 1641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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:
1645: RAISE;

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

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:
1645: RAISE;
1646:

Line 1648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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:
1652: RAISE;

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

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:
1652: RAISE;
1653:

Line 1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1651:
1652: RAISE;
1653:
1654: WHEN OTHERS THEN
1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1657: END IF;
1658:
1659: RAISE;

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

1652: RAISE;
1653:
1654: WHEN OTHERS THEN
1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1657: END IF;
1658:
1659: RAISE;
1660: END Currency_Conversion;

Line 1686: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1682: )
1683: IS
1684:
1685: BEGIN
1686: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1687: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1688: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1689: FND_MSG_PUB.Add;
1690: --END IF;

Line 1689: FND_MSG_PUB.Add;

1685: BEGIN
1686: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1687: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1688: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1689: FND_MSG_PUB.Add;
1690: --END IF;
1691: END Debug;
1692: -- =================================End of Debug================================
1693:

Line 1721: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN

1717: p_token3_value IN VARCHAR2 := NULL
1718: )
1719: IS
1720: BEGIN
1721: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
1722: FND_MESSAGE.Set_Name('PV', p_msg_name);
1723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
1724:
1725: IF (p_token2 IS NOT NULL) THEN

Line 1733: FND_MSG_PUB.Add;

1729: IF (p_token3 IS NOT NULL) THEN
1730: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
1731: END IF;
1732:
1733: FND_MSG_PUB.Add;
1734: END IF;
1735: END Set_Message;
1736: -- ==============================End of Set_Message==============================
1737:

Line 1899: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1895: l_matched := TRUE;
1896: END IF;
1897:
1898: ELSE
1899: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1900: p_msg_name => 'PV_ILLEGAL_OPERATOR',
1901: p_token1 => 'Operator',
1902: p_token1_value => p_operator,
1903: p_token2 => 'Attribute Return Type',

Line 1924: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1920: l_matched := TRUE;
1921: END IF;
1922:
1923: ELSE
1924: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1925: p_msg_name => 'PV_ILLEGAL_OPERATOR',
1926: p_token1 => 'Operator',
1927: p_token1_value => p_operator,
1928: p_token2 => 'Attribute Return Type',

Line 1949: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1945: l_matched := TRUE;
1946: END IF;
1947:
1948: ELSE
1949: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1950: p_msg_name => 'PV_ILLEGAL_OPERATOR',
1951: p_token1 => 'Operator',
1952: p_token1_value => p_operator,
1953: p_token2 => 'Attribute Return Type',

Line 1974: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1970: l_matched := TRUE;
1971: END IF;
1972:
1973: ELSE
1974: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1975: p_msg_name => 'PV_ILLEGAL_OPERATOR',
1976: p_token1 => 'Operator',
1977: p_token1_value => p_operator,
1978: p_token2 => 'Attribute Return Type',

Line 2053: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2049: END IF;
2050: END IF;
2051:
2052: ELSE
2053: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2054: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2055: p_token1 => 'Operator',
2056: p_token1_value => p_operator,
2057: p_token2 => 'Attribute Return Type',

Line 2078: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2074: l_matched := TRUE;
2075: END IF;
2076:
2077: ELSE
2078: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2079: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2080: p_token1 => 'Operator',
2081: p_token1_value => p_operator,
2082: p_token2 => 'Attribute Return Type',

Line 2107: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2103: l_matched := TRUE;
2104: END IF;
2105:
2106: ELSE
2107: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2108: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2109: p_token1 => 'Operator',
2110: p_token1_value => p_operator,
2111: p_token2 => 'Attribute Return Type',

Line 2128: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2124: l_matched := TRUE;
2125: END IF;
2126:
2127: ELSE
2128: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2129: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2130: p_token1 => 'Operator',
2131: p_token1_value => p_operator,
2132: p_token2 => 'Attribute Return Type',

Line 2149: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2145: l_matched := TRUE;
2146: END IF;
2147:
2148: ELSE
2149: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2150: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2151: p_token1 => 'Operator',
2152: p_token1_value => p_operator,
2153: p_token2 => 'Attribute Return Type',

Line 2180: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2176: -- ----------------------------------------------------------
2177: -- WRONG OPERATOR!
2178: -- ----------------------------------------------------------
2179: ELSE
2180: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2181: p_msg_name => 'PV_ILLEGAL_OPERATOR',
2182: p_token1 => 'Operator',
2183: p_token1_value => p_operator,
2184: p_token2 => 'Attribute Return Type',

Line 2273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2269: RETURN SUBSTR(l_attr_value_string, l_start_position, l_token_length);
2270:
2271: EXCEPTION
2272: WHEN others THEN
2273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2274: Debug('Retrieve Token: ' || p_attr_value_string);
2275: Debug(SQLCODE || ': ' || SQLERRM);
2276: END IF;
2277:

Line 2446: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2442:
2443: -- IF (p_attribute_id = g_purchase_amount_attr_id) THEN
2444: IF (p_attribute_id = g_a_Purchase_Amount_Product) THEN
2445: IF (l_num_of_tokens <> 4) THEN
2446: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2447: p_msg_name => 'PV_WRONG_PSS_FORMAT',
2448: p_token1 => 'Attribute ID',
2449: p_token1_value => p_attribute_id,
2450: p_token2 => 'Attribute Value',

Line 2457: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2453:
2454: -- ELSIF (p_attribute_id = g_purchase_quantity_attr_id) THEN
2455: ELSIF (p_attribute_id = g_a_Purchase_Quantity_Product) THEN
2456: IF (l_num_of_tokens <> 2) THEN
2457: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2458: p_msg_name => 'PV_WRONG_PSS_QTY_FORMAT',
2459: p_token1 => 'Attribute ID',
2460: p_token1_value => p_attribute_id,
2461: p_token2 => 'Attribute Value',