DBA Data[Home] [Help]

APPS.AMS_FORMULA_PVT dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_OP');

105: ELSIF(p_operator = 'PERCENT')THEN
106: l_result := ((p_left_value /100)* p_right_value);
107:
108: ELSE
109: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_OP');
110: FND_MSG_PUB.add;
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:

Line 683: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ACT_METRIC_ID');

679: THEN
680: -- missing required fields
681: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
682: THEN -- MMSG
683: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ACT_METRIC_ID');
684: FND_MSG_PUB.Add;
685: END IF;
686:
687: x_return_status := FND_API.G_RET_STS_ERROR;

Line 700: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_LEVEL_DEPTH');

696: THEN
697: -- missing required fields
698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
699: THEN -- MMSG
700: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_LEVEL_DEPTH');
701: FND_MSG_PUB.Add;
702: END IF;
703:
704: x_return_status := FND_API.G_RET_STS_ERROR;

Line 750: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_FORMULA_ID');

746: THEN
747: -- missing required fields
748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
749: THEN -- MMSG
750: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_FORMULA_ID');
751: FND_MSG_PUB.Add;
752: END IF;
753:
754: x_return_status := FND_API.G_RET_STS_ERROR;

Line 766: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ORDER_NUM');

762: THEN
763: -- missing required fields
764: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
765: THEN -- MMSG
766: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ORDER_NUM');
767: FND_MSG_PUB.Add;
768: END IF;
769:
770: x_return_status := FND_API.G_RET_STS_ERROR;

Line 782: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ENT_TYPE');

778: THEN
779: -- missing required fields
780: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
781: THEN -- MMSG
782: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_ENT_TYPE');
783: FND_MSG_PUB.Add;
784: END IF;
785:
786: x_return_status := FND_API.G_RET_STS_ERROR;

Line 798: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_OBJ_NUM');

794: THEN
795: -- missing required fields
796: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
797: THEN -- MMSG
798: FND_MESSAGE.Set_Name('AMS', 'AMS_FML_MISSING_OBJ_NUM');
799: FND_MSG_PUB.Add;
800: END IF;
801:
802: x_return_status := FND_API.G_RET_STS_ERROR;

Line 861: FND_MESSAGE.set_name('AMS', 'AMS_FML_MAX_LEVEL');

857:
858: IF (l_formula_count > 0) THEN
859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
860:
861: FND_MESSAGE.set_name('AMS', 'AMS_FML_MAX_LEVEL');
862: FND_MSG_PUB.add;
863: END IF;
864: x_return_status := FND_API.g_ret_sts_error;
865: RETURN;

Line 914: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_DUP_ORDNUM');

910:
911: IF (l_formula_entry_count > 0) THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913:
914: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_DUP_ORDNUM');
915: FND_MSG_PUB.add;
916: END IF;
917: x_return_status := FND_API.g_ret_sts_error;
918: RETURN;

Line 964: FND_MESSAGE.set_name('AMS', 'AMS_FML_INVALID_TYPE');

960: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_TYPE',
961: p_lookup_code => l_formula_rec.formula_type) = FND_API.g_false THEN
962:
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
964: FND_MESSAGE.set_name('AMS', 'AMS_FML_INVALID_TYPE');
965: FND_MSG_PUB.add;
966: END IF;
967:
968: x_return_status := FND_API.g_ret_sts_error;

Line 1019: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_TYPE');

1015: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_ENT_TYPE',
1016: p_lookup_code => l_formula_entry_rec.formula_entry_type) = FND_API.g_false THEN
1017:
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_TYPE');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;

Line 1037: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_OP');

1033: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_OPERATOR',
1034: p_lookup_code => l_formula_entry_rec.formula_entry_operator) = FND_API.g_false THEN
1035:
1036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1037: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_OP');
1038: FND_MSG_PUB.add;
1039: END IF;
1040:
1041: x_return_status := FND_API.g_ret_sts_error;

Line 1095: FND_MESSAGE.Set_Name ('AMS', 'AMS_FML_INVALID_ACT_METRIC');

1091: ,p_additional_where_clause => NULL
1092: ) = FND_API.G_FALSE
1093: THEN
1094: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1095: FND_MESSAGE.Set_Name ('AMS', 'AMS_FML_INVALID_ACT_METRIC');
1096: FND_MSG_PUB.Add;
1097: END IF;
1098:
1099: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1153: FND_MESSAGE.Set_Name ('AMS', 'AMS_FML_INVALID_FORMULA_ID');

1149: ,p_additional_where_clause => NULL
1150: ) = FND_API.G_FALSE
1151: THEN
1152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1153: FND_MESSAGE.Set_Name ('AMS', 'AMS_FML_INVALID_FORMULA_ID');
1154: FND_MSG_PUB.Add;
1155: END IF;
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2325: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

2321: --
2322: -- Add error message to API message list.
2323: --
2324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2325: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2326: FND_MSG_PUB.add;
2327: END IF;
2328: RAISE FND_API.g_exc_error;
2329: END IF;

Line 2553: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

2549: --
2550: -- Add error message to API message list.
2551: --
2552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2553: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2554: FND_MSG_PUB.add;
2555: END IF;
2556: RAISE FND_API.g_exc_error;
2557: END IF;

Line 2706: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

2702: IF (SQL%NOTFOUND) THEN
2703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2704: THEN
2705:
2706: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2707: FND_MSG_PUB.add;
2708: RAISE FND_API.g_exc_error;
2709: END IF;
2710: END IF;

Line 2861: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

2857: IF (SQL%NOTFOUND) THEN
2858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2859: THEN
2860:
2861: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2862: FND_MSG_PUB.add;
2863: RAISE FND_API.g_exc_error;
2864: END IF;
2865: END IF;

Line 3006: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

3002: CLOSE c_formula_info;
3003: -- Error, check the msg level and added an error message to the
3004: -- API message list
3005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3006: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3007: FND_MSG_PUB.add;
3008: END IF;
3009: RAISE FND_API.g_exc_error;
3010: END IF;

Line 3049: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

3045: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
3046: x_return_status := FND_API.G_RET_STS_ERROR ;
3047:
3048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3049: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3050: FND_MSG_PUB.add;
3051: END IF;
3052:
3053: FND_MSG_PUB.Count_And_Get (

Line 3156: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

3152: CLOSE c_formula_entry_info;
3153: -- Error, check the msg level and added an error message to the
3154: -- API message list
3155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3156: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3157: FND_MSG_PUB.add;
3158: END IF;
3159: RAISE FND_API.g_exc_error;
3160: END IF;

Line 3199: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

3195: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
3196: x_return_status := FND_API.G_RET_STS_ERROR ;
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3199: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3200: FND_MSG_PUB.add;
3201: END IF;
3202:
3203: FND_MSG_PUB.Count_And_Get (

Line 3256: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

3252:
3253: IF c_formula%NOTFOUND THEN
3254: CLOSE c_formula;
3255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3256: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3257: FND_MSG_PUB.add;
3258: END IF;
3259: RAISE FND_API.g_exc_error;
3260: END IF;

Line 3344: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

3340:
3341: IF c_formula_entry%NOTFOUND THEN
3342: CLOSE c_formula_entry;
3343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3344: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3345: FND_MSG_PUB.add;
3346: END IF;
3347: RAISE FND_API.g_exc_error;
3348: END IF;