APPS.AMS_FORMULA_PVT dependencies on FND_MSG_PUB

Line 67: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

63: -- 15/Jun/2000 tdonohoe Created.
64: --
65: -- End of comments
66:
67: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
68:
69: PROCEDURE Perform_Computation(p_left_value IN NUMBER,
70: p_right_value IN NUMBER,
71: p_operator IN VARCHAR2,

Line 110: FND_MSG_PUB.add;

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:
114: -------------------------------------------

Line 122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
123: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
124: END IF;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 123: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
123: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
124: END IF;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

124: END IF;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
130: END IF;
131:
132: WHEN OTHERS THEN

Line 129: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
130: END IF;
131:
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

130: END IF;
131:
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
136: END IF;
137:
138:

Line 135: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

131:
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
136: END IF;
137:
138:
139: END Perform_Computation;

Line 305: FND_MSG_PUB.Initialize;

301: --
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: --
304: IF FND_API.To_Boolean (p_init_msg_list) THEN
305: FND_MSG_PUB.Initialize;
306: END IF;
307:
308: --
309: -- Standard check for API version compatibility.

Line 519: FND_MSG_PUB.Count_And_Get (

515:
516:
517: ROLLBACK TO Execute_Formula_Pvt;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: FND_MSG_PUB.Count_And_Get (
520: p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 529: FND_MSG_PUB.Count_And_Get (

525:
526:
527: ROLLBACK TO Execute_Formula_Pvt;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MSG_PUB.Count_And_Get (
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533: WHEN OTHERS THEN

Line 538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

534:
535:
536: ROLLBACK TO Execute_Formula_Pvt;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
539: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
540: END IF;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,

Line 539: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

535:
536: ROLLBACK TO Execute_Formula_Pvt;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
539: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
540: END IF;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,
543: p_data => x_msg_data

Line 541: FND_MSG_PUB.Count_And_Get (

537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
539: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
540: END IF;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );
545:

Line 582: FND_MSG_PUB.Initialize;

578: --
579: -- Initialize message list if p_init_msg_list is set to TRUE.
580: --
581: IF FND_API.To_Boolean (p_init_msg_list) THEN
582: FND_MSG_PUB.Initialize;
583: END IF;
584:
585: --
586: -- Initialize API return status to success.

Line 631: FND_MSG_PUB.Initialize;

627: --
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: --
630: IF FND_API.To_Boolean (p_init_msg_list) THEN
631: FND_MSG_PUB.Initialize;
632: END IF;
633:
634: --
635: -- Initialize API return status to success.

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

677:
678: IF p_formula_rec.activity_metric_id IS NULL
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;

Line 684: FND_MSG_PUB.Add;

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;
688:

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

694:
695: IF p_formula_rec.level_depth IS NULL
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;

Line 701: FND_MSG_PUB.Add;

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;
705:

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

744:
745: IF p_formula_entry_rec.formula_id IS NULL
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;

Line 751: FND_MSG_PUB.Add;

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;
755:

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

760: --ORDER_NUMBER
761: IF p_formula_entry_rec.order_number IS NULL
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;

Line 767: FND_MSG_PUB.Add;

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;
771:

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

776: -- FORMULA_ENTRY_TYPE
777: IF p_formula_entry_rec.formula_entry_type IS NULL
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;

Line 783: FND_MSG_PUB.Add;

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;
787:

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

792: -- OBJECT_VERSION_NUMBER
793: IF p_formula_entry_rec.object_version_number IS NULL
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;

Line 799: FND_MSG_PUB.Add;

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;
803:

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

855: FETCH c_formula_type INTO l_formula_count;
856: CLOSE c_formula_type;
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;

Line 862: FND_MSG_PUB.add;

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;
866: END IF;

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

908: FETCH c_formula_entry_type INTO l_formula_entry_count;
909: CLOSE c_formula_entry_type;
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;

Line 915: FND_MSG_PUB.add;

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;
919: END IF;

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

959:
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:

Line 965: FND_MSG_PUB.add;

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;
969: RETURN;

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

1014:
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:

Line 1020: FND_MSG_PUB.add;

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;
1024: RETURN;

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

1032:
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:

Line 1038: FND_MSG_PUB.add;

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

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

1090: ,p_pk_data_type => NULL
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:

Line 1096: FND_MSG_PUB.Add;

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;
1100: RETURN;

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

1148: ,p_pk_data_type => NULL
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:

Line 1154: FND_MSG_PUB.Add;

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;
1158: RETURN;

Line 1331: FND_MSG_PUB.Initialize;

1327: --
1328: -- Initialize message list if p_init_msg_list is set to TRUE.
1329: --
1330: IF FND_API.To_Boolean (p_init_msg_list) THEN
1331: FND_MSG_PUB.Initialize;
1332: END IF;
1333:
1334: --
1335: -- Standard check for API version compatibility.

Line 1412: FND_MSG_PUB.Count_And_Get (

1408: --
1409: -- Standard API to get message count, and if 1,
1410: -- set the message data OUT variable.
1411: --
1412: FND_MSG_PUB.Count_And_Get (
1413: p_count => x_msg_count,
1414: p_data => x_msg_data,
1415: p_encoded => FND_API.G_FALSE
1416: );

Line 1426: FND_MSG_PUB.Count_And_Get (

1422:
1423: EXCEPTION
1424: WHEN FND_API.G_EXC_ERROR THEN
1425: x_return_status := FND_API.G_RET_STS_ERROR;
1426: FND_MSG_PUB.Count_And_Get (
1427: p_count => x_msg_count,
1428: p_data => x_msg_data
1429: );
1430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1432: FND_MSG_PUB.Count_And_Get (

1428: p_data => x_msg_data
1429: );
1430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: FND_MSG_PUB.Count_And_Get (
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );
1436: WHEN OTHERS THEN

Line 1438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1434: p_data => x_msg_data
1435: );
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1439: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1440: END IF;
1441: FND_MSG_PUB.Count_And_Get (
1442: p_count => x_msg_count,

Line 1439: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1435: );
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1439: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1440: END IF;
1441: FND_MSG_PUB.Count_And_Get (
1442: p_count => x_msg_count,
1443: p_data => x_msg_data

Line 1441: FND_MSG_PUB.Count_And_Get (

1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1439: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1440: END IF;
1441: FND_MSG_PUB.Count_And_Get (
1442: p_count => x_msg_count,
1443: p_data => x_msg_data
1444: );
1445: END Validate_Formula;

Line 1493: FND_MSG_PUB.Initialize;

1489: --
1490: -- Initialize message list if p_init_msg_list is set to TRUE.
1491: --
1492: IF FND_API.To_Boolean (p_init_msg_list) THEN
1493: FND_MSG_PUB.Initialize;
1494: END IF;
1495:
1496: --
1497: -- Standard check for API version compatibility.

Line 1574: FND_MSG_PUB.Count_And_Get (

1570: --
1571: -- Standard API to get message count, and if 1,
1572: -- set the message data OUT variable.
1573: --
1574: FND_MSG_PUB.Count_And_Get (
1575: p_count => x_msg_count,
1576: p_data => x_msg_data,
1577: p_encoded => FND_API.G_FALSE
1578: );

Line 1588: FND_MSG_PUB.Count_And_Get (

1584:
1585: EXCEPTION
1586: WHEN FND_API.G_EXC_ERROR THEN
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: FND_MSG_PUB.Count_And_Get (
1589: p_count => x_msg_count,
1590: p_data => x_msg_data
1591: );
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1594: FND_MSG_PUB.Count_And_Get (

1590: p_data => x_msg_data
1591: );
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: FND_MSG_PUB.Count_And_Get (
1595: p_count => x_msg_count,
1596: p_data => x_msg_data
1597: );
1598: WHEN OTHERS THEN

Line 1600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1596: p_data => x_msg_data
1597: );
1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1602: END IF;
1603: FND_MSG_PUB.Count_And_Get (
1604: p_count => x_msg_count,

Line 1601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1597: );
1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1602: END IF;
1603: FND_MSG_PUB.Count_And_Get (
1604: p_count => x_msg_count,
1605: p_data => x_msg_data

Line 1603: FND_MSG_PUB.Count_And_Get (

1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1602: END IF;
1603: FND_MSG_PUB.Count_And_Get (
1604: p_count => x_msg_count,
1605: p_data => x_msg_data
1606: );
1607: END Validate_Formula_Entry;

Line 1679: FND_MSG_PUB.Initialize;

1675: --
1676: -- Initialize message list if p_init_msg_list is set to TRUE.
1677: --
1678: IF FND_API.To_Boolean (p_init_msg_list) THEN
1679: FND_MSG_PUB.Initialize;
1680: END IF;
1681:
1682: --
1683: -- Standard check for API version compatibility.

Line 1833: FND_MSG_PUB.Count_And_Get (

1829: --
1830: -- Standard API to get message count, and if 1,
1831: -- set the message data OUT variable.
1832: --
1833: FND_MSG_PUB.Count_And_Get (
1834: p_count => x_msg_count,
1835: p_data => x_msg_data,
1836: p_encoded => FND_API.G_FALSE
1837: );

Line 1856: FND_MSG_PUB.Count_And_Get (

1852:
1853:
1854: ROLLBACK TO Create_Formula_Pvt;
1855: x_return_status := FND_API.G_RET_STS_ERROR;
1856: FND_MSG_PUB.Count_And_Get (
1857: p_count => x_msg_count,
1858: p_data => x_msg_data
1859: );
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1866: FND_MSG_PUB.Count_And_Get (

1862:
1863:
1864: ROLLBACK TO Create_Formula_Pvt;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: FND_MSG_PUB.Count_And_Get (
1867: p_count => x_msg_count,
1868: p_data => x_msg_data
1869: );
1870: WHEN OTHERS THEN

Line 1875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1871:
1872:
1873: ROLLBACK TO Create_Formula_Pvt;
1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1876: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1877: END IF;
1878: FND_MSG_PUB.Count_And_Get (
1879: p_count => x_msg_count,

Line 1876: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1872:
1873: ROLLBACK TO Create_Formula_Pvt;
1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1876: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1877: END IF;
1878: FND_MSG_PUB.Count_And_Get (
1879: p_count => x_msg_count,
1880: p_data => x_msg_data

Line 1878: FND_MSG_PUB.Count_And_Get (

1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1876: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1877: END IF;
1878: FND_MSG_PUB.Count_And_Get (
1879: p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );
1882:

Line 1955: FND_MSG_PUB.Initialize;

1951: --
1952: -- Initialize message list if p_init_msg_list is set to TRUE.
1953: --
1954: IF FND_API.To_Boolean (p_init_msg_list) THEN
1955: FND_MSG_PUB.Initialize;
1956: END IF;
1957:
1958: --
1959: -- Standard check for API version compatibility.

Line 2113: FND_MSG_PUB.Count_And_Get (

2109: --
2110: -- Standard API to get message count, and if 1,
2111: -- set the message data OUT variable.
2112: --
2113: FND_MSG_PUB.Count_And_Get (
2114: p_count => x_msg_count,
2115: p_data => x_msg_data,
2116: p_encoded => FND_API.G_FALSE
2117: );

Line 2136: FND_MSG_PUB.Count_And_Get (

2132:
2133:
2134: ROLLBACK TO Create_Formula_Entry_Pvt;
2135: x_return_status := FND_API.G_RET_STS_ERROR;
2136: FND_MSG_PUB.Count_And_Get (
2137: p_count => x_msg_count,
2138: p_data => x_msg_data
2139: );
2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2146: FND_MSG_PUB.Count_And_Get (

2142:
2143:
2144: ROLLBACK TO Create_Formula_Entry_Pvt;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2146: FND_MSG_PUB.Count_And_Get (
2147: p_count => x_msg_count,
2148: p_data => x_msg_data
2149: );
2150: WHEN OTHERS THEN

Line 2155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2151:
2152:
2153: ROLLBACK TO Create_Formula_Entry_Pvt;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2157: END IF;
2158: FND_MSG_PUB.Count_And_Get (
2159: p_count => x_msg_count,

Line 2156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2152:
2153: ROLLBACK TO Create_Formula_Entry_Pvt;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2157: END IF;
2158: FND_MSG_PUB.Count_And_Get (
2159: p_count => x_msg_count,
2160: p_data => x_msg_data

Line 2158: FND_MSG_PUB.Count_And_Get (

2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2157: END IF;
2158: FND_MSG_PUB.Count_And_Get (
2159: p_count => x_msg_count,
2160: p_data => x_msg_data
2161: );
2162:

Line 2220: FND_MSG_PUB.Initialize;

2216: --
2217: -- Initialize message list if p_init_msg_list is set to TRUE.
2218: --
2219: IF FND_API.To_Boolean (p_init_msg_list) THEN
2220: FND_MSG_PUB.Initialize;
2221: END IF;
2222:
2223: --
2224: -- Standard check for API version compatibility.

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

2320: THEN
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;

Line 2326: FND_MSG_PUB.add;

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;
2330:

Line 2344: FND_MSG_PUB.Count_And_Get (

2340: --
2341: -- Standard API to get message count, and if 1,
2342: -- set the message data OUT variable.
2343: --
2344: FND_MSG_PUB.Count_And_Get (
2345: p_count => x_msg_count,
2346: p_data => x_msg_data,
2347: p_encoded => FND_API.G_FALSE
2348: );

Line 2363: FND_MSG_PUB.Count_And_Get (

2359: WHEN FND_API.G_EXC_ERROR THEN
2360:
2361: ROLLBACK TO Update_Formula_pvt;
2362: x_return_status := FND_API.G_RET_STS_ERROR;
2363: FND_MSG_PUB.Count_And_Get (
2364: p_count => x_msg_count,
2365: p_data => x_msg_data);
2366:
2367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2371: FND_MSG_PUB.Count_And_Get (

2367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2368:
2369: ROLLBACK TO Update_Formula_pvt;
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: FND_MSG_PUB.Count_And_Get (
2372: p_count => x_msg_count,
2373: p_data => x_msg_data
2374: );
2375:

Line 2380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2376: WHEN OTHERS THEN
2377:
2378: ROLLBACK TO Update_Formula_pvt;
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2381: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2382: END IF;
2383: FND_MSG_PUB.Count_And_Get (
2384: p_count => x_msg_count,

Line 2381: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2377:
2378: ROLLBACK TO Update_Formula_pvt;
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2381: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2382: END IF;
2383: FND_MSG_PUB.Count_And_Get (
2384: p_count => x_msg_count,
2385: p_data => x_msg_data

Line 2383: FND_MSG_PUB.Count_And_Get (

2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2381: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2382: END IF;
2383: FND_MSG_PUB.Count_And_Get (
2384: p_count => x_msg_count,
2385: p_data => x_msg_data
2386: );
2387: END Update_Formula;

Line 2445: FND_MSG_PUB.Initialize;

2441: --
2442: -- Initialize message list if p_init_msg_list is set to TRUE.
2443: --
2444: IF FND_API.To_Boolean (p_init_msg_list) THEN
2445: FND_MSG_PUB.Initialize;
2446: END IF;
2447:
2448: --
2449: -- Standard check for API version compatibility.

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

2548:
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;

Line 2554: FND_MSG_PUB.add;

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;
2558:

Line 2572: FND_MSG_PUB.Count_And_Get (

2568: --
2569: -- Standard API to get message count, and if 1,
2570: -- set the message data OUT variable.
2571: --
2572: FND_MSG_PUB.Count_And_Get (
2573: p_count => x_msg_count,
2574: p_data => x_msg_data,
2575: p_encoded => FND_API.G_FALSE
2576: );

Line 2590: FND_MSG_PUB.Count_And_Get (

2586: EXCEPTION
2587: WHEN FND_API.G_EXC_ERROR THEN
2588: ROLLBACK TO Update_Formula_Entry_Pvt;
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: FND_MSG_PUB.Count_And_Get (
2591: p_count => x_msg_count,
2592: p_data => x_msg_data);
2593:
2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2597: FND_MSG_PUB.Count_And_Get (

2593:
2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2595: ROLLBACK TO Update_Formula_Entry_Pvt;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597: FND_MSG_PUB.Count_And_Get (
2598: p_count => x_msg_count,
2599: p_data => x_msg_data
2600: );
2601:

Line 2605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2601:
2602: WHEN OTHERS THEN
2603: ROLLBACK TO Update_Formula_Entry_Pvt;
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2607: END IF;
2608: FND_MSG_PUB.Count_And_Get (
2609: p_count => x_msg_count,

Line 2606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2602: WHEN OTHERS THEN
2603: ROLLBACK TO Update_Formula_Entry_Pvt;
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2607: END IF;
2608: FND_MSG_PUB.Count_And_Get (
2609: p_count => x_msg_count,
2610: p_data => x_msg_data

Line 2608: FND_MSG_PUB.Count_And_Get (

2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2607: END IF;
2608: FND_MSG_PUB.Count_And_Get (
2609: p_count => x_msg_count,
2610: p_data => x_msg_data
2611: );
2612: END Update_Formula_Entry;

Line 2665: FND_MSG_PUB.Initialize;

2661: --
2662: -- Initialize message list if p_init_msg_list is set to TRUE.
2663: --
2664: IF FND_API.To_Boolean (p_init_msg_list) THEN
2665: FND_MSG_PUB.Initialize;
2666: END IF;
2667:
2668: --
2669: -- Standard check for API version compatibility.

Line 2703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2699: WHERE formula_id = p_formula_id
2700: AND object_version_number = p_object_version_number;
2701:
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;

Line 2707: FND_MSG_PUB.add;

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;
2711:

Line 2736: FND_MSG_PUB.Count_And_Get (

2732: --
2733: -- Standard API to get message count, and if 1,
2734: -- set the message data OUT variable.
2735: --
2736: FND_MSG_PUB.Count_And_Get (
2737: p_count => x_msg_count,
2738: p_data => x_msg_data,
2739: p_encoded => FND_API.G_FALSE
2740: );

Line 2746: FND_MSG_PUB.Count_And_Get (

2742: EXCEPTION
2743: WHEN FND_API.G_EXC_ERROR THEN
2744: ROLLBACK TO Delete_Formula_pvt;
2745: x_return_status := FND_API.G_RET_STS_ERROR;
2746: FND_MSG_PUB.Count_And_Get (
2747: p_count => x_msg_count,
2748: p_data => x_msg_data
2749: );
2750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2753: FND_MSG_PUB.Count_And_Get (

2749: );
2750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2751: ROLLBACK TO Delete_Formula_pvt;
2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2753: FND_MSG_PUB.Count_And_Get (
2754: p_count => x_msg_count,
2755: p_data => x_msg_data
2756: );
2757: WHEN OTHERS THEN

Line 2760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2756: );
2757: WHEN OTHERS THEN
2758: ROLLBACK TO Delete_Formula_pvt;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2761: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get (
2764: p_count => x_msg_count,

Line 2761: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2757: WHEN OTHERS THEN
2758: ROLLBACK TO Delete_Formula_pvt;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2761: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get (
2764: p_count => x_msg_count,
2765: p_data => x_msg_data

Line 2763: FND_MSG_PUB.Count_And_Get (

2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2761: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get (
2764: p_count => x_msg_count,
2765: p_data => x_msg_data
2766: );
2767: END Delete_Formula;

Line 2820: FND_MSG_PUB.Initialize;

2816: --
2817: -- Initialize message list if p_init_msg_list is set to TRUE.
2818: --
2819: IF FND_API.To_Boolean (p_init_msg_list) THEN
2820: FND_MSG_PUB.Initialize;
2821: END IF;
2822:
2823: --
2824: -- Standard check for API version compatibility.

Line 2858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2854: WHERE formula_entry_id = p_formula_entry_id
2855: AND object_version_number = p_object_version_number;
2856:
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;

Line 2862: FND_MSG_PUB.add;

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;
2866:

Line 2887: FND_MSG_PUB.Count_And_Get (

2883: --
2884: -- Standard API to get message count, and if 1,
2885: -- set the message data OUT variable.
2886: --
2887: FND_MSG_PUB.Count_And_Get (
2888: p_count => x_msg_count,
2889: p_data => x_msg_data,
2890: p_encoded => FND_API.G_FALSE
2891: );

Line 2897: FND_MSG_PUB.Count_And_Get (

2893: EXCEPTION
2894: WHEN FND_API.G_EXC_ERROR THEN
2895: ROLLBACK TO Delete_Formula_Entry_Pvt;
2896: x_return_status := FND_API.G_RET_STS_ERROR;
2897: FND_MSG_PUB.Count_And_Get (
2898: p_count => x_msg_count,
2899: p_data => x_msg_data
2900: );
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2904: FND_MSG_PUB.Count_And_Get (

2900: );
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: ROLLBACK TO Delete_Formula_Entry_Pvt;
2903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2904: FND_MSG_PUB.Count_And_Get (
2905: p_count => x_msg_count,
2906: p_data => x_msg_data
2907: );
2908: WHEN OTHERS THEN

Line 2911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2907: );
2908: WHEN OTHERS THEN
2909: ROLLBACK TO Delete_Formula_Entry_Pvt;
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2912: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2913: END IF;
2914: FND_MSG_PUB.Count_And_Get (
2915: p_count => x_msg_count,

Line 2912: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2908: WHEN OTHERS THEN
2909: ROLLBACK TO Delete_Formula_Entry_Pvt;
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2912: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2913: END IF;
2914: FND_MSG_PUB.Count_And_Get (
2915: p_count => x_msg_count,
2916: p_data => x_msg_data

Line 2914: FND_MSG_PUB.Count_And_Get (

2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2912: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2913: END IF;
2914: FND_MSG_PUB.Count_And_Get (
2915: p_count => x_msg_count,
2916: p_data => x_msg_data
2917: );
2918: END Delete_Formula_Entry;

Line 2972: FND_MSG_PUB.Initialize;

2968: --
2969: -- Initialize message list if p_init_msg_list is set to TRUE.
2970: --
2971: IF FND_API.To_Boolean (p_init_msg_list) THEN
2972: FND_MSG_PUB.Initialize;
2973: END IF;
2974:
2975: --
2976: -- Standard check for API version compatibility.

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

3001: THEN
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;

Line 3007: FND_MSG_PUB.add;

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;
3011: CLOSE c_formula_info;

Line 3018: FND_MSG_PUB.Count_And_Get (

3014: --
3015: -- Standard API to get message count, and if 1,
3016: -- set the message data OUT variable.
3017: --
3018: FND_MSG_PUB.Count_And_Get (
3019: p_count => x_msg_count,
3020: p_data => x_msg_data,
3021: p_encoded => FND_API.G_FALSE
3022: );

Line 3035: FND_MSG_PUB.Count_And_Get (

3031:
3032: EXCEPTION
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: x_return_status := FND_API.G_RET_STS_ERROR;
3035: FND_MSG_PUB.Count_And_Get (
3036: p_count => x_msg_count,
3037: p_data => x_msg_data
3038: );
3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3041: FND_MSG_PUB.Count_And_Get (

3037: p_data => x_msg_data
3038: );
3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3041: FND_MSG_PUB.Count_And_Get (
3042: p_count => x_msg_count,
3043: p_data => x_msg_data
3044: );
3045: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

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

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

Line 3050: FND_MSG_PUB.add;

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 (
3054: p_count => x_msg_count,

Line 3053: FND_MSG_PUB.Count_And_Get (

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 (
3054: p_count => x_msg_count,
3055: p_data => x_msg_data,
3056: p_encoded => FND_API.G_FALSE
3057: );

Line 3060: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3056: p_encoded => FND_API.G_FALSE
3057: );
3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3061: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3062: END IF;
3063: FND_MSG_PUB.Count_And_Get (
3064: p_count => x_msg_count,

Line 3061: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

3057: );
3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3061: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3062: END IF;
3063: FND_MSG_PUB.Count_And_Get (
3064: p_count => x_msg_count,
3065: p_data => x_msg_data,

Line 3063: FND_MSG_PUB.Count_And_Get (

3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3061: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3062: END IF;
3063: FND_MSG_PUB.Count_And_Get (
3064: p_count => x_msg_count,
3065: p_data => x_msg_data,
3066: p_encoded => FND_API.G_FALSE
3067: );

Line 3122: FND_MSG_PUB.Initialize;

3118: --
3119: -- Initialize message list if p_init_msg_list is set to TRUE.
3120: --
3121: IF FND_API.To_Boolean (p_init_msg_list) THEN
3122: FND_MSG_PUB.Initialize;
3123: END IF;
3124:
3125: --
3126: -- Standard check for API version compatibility.

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

3151: THEN
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;

Line 3157: FND_MSG_PUB.add;

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;
3161: CLOSE c_formula_entry_info;

Line 3168: FND_MSG_PUB.Count_And_Get (

3164: --
3165: -- Standard API to get message count, and if 1,
3166: -- set the message data OUT variable.
3167: --
3168: FND_MSG_PUB.Count_And_Get (
3169: p_count => x_msg_count,
3170: p_data => x_msg_data,
3171: p_encoded => FND_API.G_FALSE
3172: );

Line 3185: FND_MSG_PUB.Count_And_Get (

3181:
3182: EXCEPTION
3183: WHEN FND_API.G_EXC_ERROR THEN
3184: x_return_status := FND_API.G_RET_STS_ERROR;
3185: FND_MSG_PUB.Count_And_Get (
3186: p_count => x_msg_count,
3187: p_data => x_msg_data
3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3191: FND_MSG_PUB.Count_And_Get (

3187: p_data => x_msg_data
3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3191: FND_MSG_PUB.Count_And_Get (
3192: p_count => x_msg_count,
3193: p_data => x_msg_data
3194: );
3195: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

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

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

Line 3200: FND_MSG_PUB.add;

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 (
3204: p_count => x_msg_count,

Line 3203: FND_MSG_PUB.Count_And_Get (

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 (
3204: p_count => x_msg_count,
3205: p_data => x_msg_data,
3206: p_encoded => FND_API.G_FALSE
3207: );

Line 3210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3206: p_encoded => FND_API.G_FALSE
3207: );
3208: WHEN OTHERS THEN
3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3212: END IF;
3213: FND_MSG_PUB.Count_And_Get (
3214: p_count => x_msg_count,

Line 3211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

3207: );
3208: WHEN OTHERS THEN
3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3212: END IF;
3213: FND_MSG_PUB.Count_And_Get (
3214: p_count => x_msg_count,
3215: p_data => x_msg_data,

Line 3213: FND_MSG_PUB.Count_And_Get (

3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3212: END IF;
3213: FND_MSG_PUB.Count_And_Get (
3214: p_count => x_msg_count,
3215: p_data => x_msg_data,
3216: p_encoded => FND_API.G_FALSE
3217: );

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

3251: FETCH c_formula INTO l_formula_rec;
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;

Line 3257: FND_MSG_PUB.add;

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;
3261: CLOSE c_formula;

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

3339: FETCH c_formula_entry INTO l_formula_entry_rec;
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;

Line 3345: FND_MSG_PUB.add;

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;
3349: CLOSE c_formula_entry;