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.EAM_ACTIVITY_PUB dependencies on FND_MSG_PUB

Line 21: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

17:
18: IF p_bom_copy_option NOT IN (1, 2) THEN
19: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_BOM_COPY_OPT');
20: -- FND_MESSAGE.SET_ENCODED('BOM Copy Option should be 1 (NONE) or 2 (ALL).');
21: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;
24:
25: IF p_routing_copy_option NOT IN (1, 2) THEN

Line 28: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

24:
25: IF p_routing_copy_option NOT IN (1, 2) THEN
26: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_RTG_COPY_OPT');
27: -- FND_MESSAGE.SET_ENCODED('Routing Copy Option should be 1 (NONE) or 2 (ALL).');
28: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
29: RAISE FND_API.G_EXC_ERROR;
30: END IF;
31:
32: IF p_bom_copy_option NOT IN (1, 2) THEN

Line 35: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

31:
32: IF p_bom_copy_option NOT IN (1, 2) THEN
33: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_ASC_COPY_OPT');
34: -- FND_MESSAGE.SET_ENCODED('Association Copy Option should be 1 (NONE) or 2 (ALL).');
35: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: END;

Line 59: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

55: IF p_material_copy_option <> 1 THEN
56: -- Error: Material Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).
57: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_MAT_COPY_OPT_NOT_NONE');
58: -- FND_MESSAGE.SET_ENCODED('Material Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).');
59: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62: IF p_resource_copy_option <> 1 THEN
63: -- Error: Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).

Line 66: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

62: IF p_resource_copy_option <> 1 THEN
63: -- Error: Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).
64: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_NOT_NONE');
65: -- FND_MESSAGE.SET_ENCODED('Resource Copy Option has to be 1 (NONE) when Operation Copy Option is 1 (NONE).');
66: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69: ELSIF p_operation_copy_option = 2 THEN
70: -- p_operation_copy_option = 2 (ALL)

Line 78: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

74: -- Error: Material Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
75: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_MAT_COPY_OPT_INVALID');
76: -- FND_MESSAGE.SET_ENCODED('Material Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).');
77: RAISE FND_API.G_EXC_ERROR;
78: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
79: END IF;
80: IF p_resource_copy_option NOT IN (1, 2, 3) THEN
81: -- Error: Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
82: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_INVALID');

Line 84: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

80: IF p_resource_copy_option NOT IN (1, 2, 3) THEN
81: -- Error: Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).
82: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_INVALID');
83: -- FND_MESSAGE.SET_ENCODED('Resource Copy Option should be either 1 (NONE), 2 (ISSUED), or 3 (ALL).');
84: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: ELSE
88: -- Error: Operation Copy Option should be either 1 (NONE), or 2 (ALL).

Line 91: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

87: ELSE
88: -- Error: Operation Copy Option should be either 1 (NONE), or 2 (ALL).
89: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_OP_COPY_OPT_INVALID');
90: -- FND_MESSAGE.SET_ENCODED('Operation Copy Option should be either 1 (NONE), or 2 (ALL).');
91: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94:
95: -- Validation of p_association_copy_option is independent of the others.

Line 111: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

107: IF p_association_copy_option NOT IN (1, 2) THEN
108: -- Error: When Source Work Order is not linked to an Activity, Association Copy Option should be either 1 (NONE), or 2 (CURRENT).
109: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ASSO_COPY_OPT_NO_ACT');
110: -- FND_MESSAGE.SET_ENCODED('When Source Work Order is not linked to an Activity, Association Copy Option should be either 1 (NONE), or 2 (CURRENT).');
111: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: ELSE
115: -- l_activity_id_from_wo IS NOT NULL

Line 121: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

117: IF p_association_copy_option NOT IN (1, 2, 3) THEN
118: -- Error: Association Copy Option should be either 1 (NONE), 2 (CURRENT), or 3 (ALL).
119: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ASSO_COPY_OPT_INVALID');
120: -- FND_MESSAGE.SET_ENCODED('Association Copy Option should be either 1 (NONE), 2 (CURRENT), or 3 (ALL).');
121: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: /*
125: END IF;

Line 750: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

746: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
747: THEN
748: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
749: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
750: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: IF l_item_rec.bom_enabled_flag IS NULL OR

Line 818: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

814: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
815: THEN
816: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
817: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
818: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: /*Bug#3269789 - end*/
822:

Line 974: FND_MSG_PUB.initialize;

970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END IF;
972: -- Initialize message list if p_init_msg_list is set to TRUE.
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;
975: END IF;
976: -- Initialize API return status to success
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: -- API body

Line 1061: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1057:
1058: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1059: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1060: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1061: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064:
1065: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1068: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1064:
1065: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1067: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1068: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072: -- Set the Activity Attributes in the Item Record, don't have to do it manually

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

1087: WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
1088: AND organization_id = l_x_master_item_rec.organization_id;
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1092: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1093: FND_MSG_PUB.ADD;
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;

Line 1093: FND_MSG_PUB.ADD;

1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1092: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1093: FND_MSG_PUB.ADD;
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END;
1097:

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

1110: WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
1111: AND organization_id = l_x_curr_item_rec.organization_id;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1115: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1116: FND_MSG_PUB.ADD;
1117: END IF;
1118: RAISE FND_API.G_EXC_ERROR;

Line 1116: FND_MSG_PUB.ADD;

1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1115: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1116: FND_MSG_PUB.ADD;
1117: END IF;
1118: RAISE FND_API.G_EXC_ERROR;
1119: END;
1120: */

Line 1163: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1159: -- Handle errors
1160: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1161: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1162: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1163: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167:

Line 1197: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1193: -- Handle errors
1194: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1195: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1196: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1197: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:
1201:

Line 1232: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1228: -- Handle error
1229: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1230: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1231: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1232: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: END IF;

Line 1246: FND_MSG_PUB.Count_And_Get

1242: IF FND_API.To_Boolean( p_commit ) THEN
1243: COMMIT WORK;
1244: END IF;
1245: -- Standard call to get message count and if count is 1, get message info.
1246: FND_MSG_PUB.Count_And_Get
1247: ( p_count => x_msg_count ,
1248: p_data => x_msg_data
1249: );
1250:

Line 1261: FND_MSG_PUB.Count_And_Get

1257: WHEN FND_API.G_EXC_ERROR THEN
1258: ROLLBACK TO Create_Activity_PUB;
1259: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: ( p_count => x_msg_count ,
1263: p_data => x_msg_data
1264: );
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1269: FND_MSG_PUB.Count_And_Get

1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: ROLLBACK TO Create_Activity_PUB;
1267: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1269: FND_MSG_PUB.Count_And_Get
1270: ( p_count => x_msg_count ,
1271: p_data => x_msg_data
1272: );
1273: WHEN OTHERS THEN

Line 1276: IF FND_MSG_PUB.Check_Msg_Level

1272: );
1273: WHEN OTHERS THEN
1274: ROLLBACK TO Create_Activity_PUB;
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1276: IF FND_MSG_PUB.Check_Msg_Level
1277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: FND_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME ,

Line 1277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1273: WHEN OTHERS THEN
1274: ROLLBACK TO Create_Activity_PUB;
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1276: IF FND_MSG_PUB.Check_Msg_Level
1277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: FND_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME ,
1281: l_api_name

Line 1279: FND_MSG_PUB.Add_Exc_Msg

1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1276: IF FND_MSG_PUB.Check_Msg_Level
1277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: FND_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME ,
1281: l_api_name
1282: );
1283: -- log error message also

Line 1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));

1280: ( G_PKG_NAME ,
1281: l_api_name
1282: );
1283: -- log error message also
1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1285: END IF;
1286: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count ,

Line 1287: FND_MSG_PUB.Count_And_Get

1283: -- log error message also
1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1285: END IF;
1286: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count ,
1289: p_data => x_msg_data
1290: );
1291: END Create_Activity;

Line 1416: FND_MSG_PUB.initialize;

1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: END IF;
1414: -- Initialize message list if p_init_msg_list is set to TRUE.
1415: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1416: FND_MSG_PUB.initialize;
1417: END IF;
1418: -- Initialize API return status to success
1419: x_return_status := FND_API.G_RET_STS_SUCCESS;
1420: -- API body

Line 1490: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1486:
1487: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1488: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1489: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1490: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1497: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1493:
1494: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1495: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1496: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1497: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1498: RAISE FND_API.G_EXC_ERROR;
1499: END IF;
1500:
1501: -- Set the Activity Attributes in the Item Record, don't have to do it manually

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

1516: WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
1517: AND organization_id = l_x_master_item_rec.organization_id;
1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1521: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1522: FND_MSG_PUB.ADD;
1523: END IF;
1524: RAISE FND_API.G_EXC_ERROR;

Line 1522: FND_MSG_PUB.ADD;

1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1521: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1522: FND_MSG_PUB.ADD;
1523: END IF;
1524: RAISE FND_API.G_EXC_ERROR;
1525: END;
1526:

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

1539: WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
1540: AND organization_id = l_x_curr_item_rec.organization_id;
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1544: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1545: FND_MSG_PUB.ADD;
1546: END IF;
1547: RAISE FND_API.G_EXC_ERROR;

Line 1545: FND_MSG_PUB.ADD;

1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1544: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1545: FND_MSG_PUB.ADD;
1546: END IF;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END;
1549: */

Line 1618: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1614: -- Handle errors
1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1617: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1618: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:
1622: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(

Line 1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1643:
1644: -- write copy_routing error message to fnd message stack and log file
1645: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1646: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1647: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1648:
1649: END IF; -- l_source_rtg_sequence_id IS NULL
1650:

Line 1710: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1706: -- Handle errors
1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1708: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1709: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1710: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(

Line 1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1739: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1740:
1741: -- write copy_bill error message to fnd message stack and log file
1742: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1743: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1744: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1745:
1746:
1747: END IF; -- l_source_bom_sequence_id IS NULL

Line 1795: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

1791: -- Handle error
1792: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1793: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1794: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1795: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798:
1799: END IF;

Line 1812: FND_MSG_PUB.Count_And_Get

1808: IF FND_API.To_Boolean( p_commit ) THEN
1809: COMMIT WORK;
1810: END IF;
1811: -- Standard call to get message count and if count is 1, get message info.
1812: FND_MSG_PUB.Count_And_Get
1813: ( p_count => x_msg_count ,
1814: p_data => x_msg_data
1815: );
1816:

Line 1826: FND_MSG_PUB.Count_And_Get

1822: WHEN FND_API.G_EXC_ERROR THEN
1823: ROLLBACK TO Copy_Activity_PUB;
1824: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MSG_PUB.Count_And_Get
1827: ( p_count => x_msg_count ,
1828: p_data => x_msg_data
1829: );
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1834: FND_MSG_PUB.Count_And_Get

1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: ROLLBACK TO Copy_Activity_PUB;
1832: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count ,
1836: p_data => x_msg_data
1837: );
1838:

Line 1842: IF FND_MSG_PUB.Check_Msg_Level

1838:
1839: WHEN OTHERS THEN
1840: ROLLBACK TO Copy_Activity_PUB;
1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1842: IF FND_MSG_PUB.Check_Msg_Level
1843: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1844: THEN
1845: FND_MSG_PUB.Add_Exc_Msg
1846: ( G_PKG_NAME ,

Line 1843: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1839: WHEN OTHERS THEN
1840: ROLLBACK TO Copy_Activity_PUB;
1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1842: IF FND_MSG_PUB.Check_Msg_Level
1843: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1844: THEN
1845: FND_MSG_PUB.Add_Exc_Msg
1846: ( G_PKG_NAME ,
1847: l_api_name

Line 1845: FND_MSG_PUB.Add_Exc_Msg

1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1842: IF FND_MSG_PUB.Check_Msg_Level
1843: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1844: THEN
1845: FND_MSG_PUB.Add_Exc_Msg
1846: ( G_PKG_NAME ,
1847: l_api_name
1848: );
1849: -- log error message also

Line 1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));

1846: ( G_PKG_NAME ,
1847: l_api_name
1848: );
1849: -- log error message also
1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1851: END IF;
1852: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,

Line 1853: FND_MSG_PUB.Count_And_Get

1849: -- log error message also
1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1851: END IF;
1852: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,
1855: p_data => x_msg_data
1856: );
1857: END Copy_Activity;

Line 2161: FND_MSG_PUB.initialize;

2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: END IF;
2159: -- Initialize message list if p_init_msg_list is set to TRUE.
2160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2161: FND_MSG_PUB.initialize;
2162: END IF;
2163: -- Initialize API return status to success
2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165: -- API body

Line 2279: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

2275: x_master_item_error_tbl := l_x_master_item_error_tbl;
2276:
2277: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2278: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
2279: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282:
2283: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2285: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

2281: END IF;
2282:
2283: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2284: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
2285: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: -- =============================================================

Line 2297: FND_MSG_PUB.Count_And_Get

2293: IF FND_API.To_Boolean( p_commit ) THEN
2294: COMMIT WORK;
2295: END IF;
2296: -- Standard call to get message count and if count is 1, get message info.
2297: FND_MSG_PUB.Count_And_Get
2298: ( p_count => x_msg_count ,
2299: p_data => x_msg_data
2300: );
2301:

Line 2313: FND_MSG_PUB.Count_And_Get

2309: ROLLBACK TO Create_Act_With_Templ_PUB;
2310: EAM_ActivityUtilities_PVT.Write_Debug(
2311: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2312: x_return_status := FND_API.G_RET_STS_ERROR ;
2313: FND_MSG_PUB.Count_And_Get
2314: ( p_count => x_msg_count ,
2315: p_data => x_msg_data
2316: );
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2322: FND_MSG_PUB.Count_And_Get

2318: ROLLBACK TO Create_Act_With_Templ_PUB;
2319: EAM_ActivityUtilities_PVT.Write_Debug(
2320: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2322: FND_MSG_PUB.Count_And_Get
2323: ( p_count => x_msg_count ,
2324: p_data => x_msg_data
2325: );
2326: WHEN OTHERS THEN

Line 2331: IF FND_MSG_PUB.Check_Msg_Level

2327: ROLLBACK TO Create_Act_With_Templ_PUB;
2328: EAM_ActivityUtilities_PVT.Write_Debug(
2329: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2331: IF FND_MSG_PUB.Check_Msg_Level
2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2333: THEN
2334: FND_MSG_PUB.Add_Exc_Msg
2335: ( G_PKG_NAME ,

Line 2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2328: EAM_ActivityUtilities_PVT.Write_Debug(
2329: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2331: IF FND_MSG_PUB.Check_Msg_Level
2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2333: THEN
2334: FND_MSG_PUB.Add_Exc_Msg
2335: ( G_PKG_NAME ,
2336: l_api_name

Line 2334: FND_MSG_PUB.Add_Exc_Msg

2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2331: IF FND_MSG_PUB.Check_Msg_Level
2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2333: THEN
2334: FND_MSG_PUB.Add_Exc_Msg
2335: ( G_PKG_NAME ,
2336: l_api_name
2337: );
2338: END IF;

Line 2339: FND_MSG_PUB.Count_And_Get

2335: ( G_PKG_NAME ,
2336: l_api_name
2337: );
2338: END IF;
2339: FND_MSG_PUB.Count_And_Get
2340: ( p_count => x_msg_count ,
2341: p_data => x_msg_data
2342: );
2343: END Create_Activity_With_Template;

Line 2964: fnd_msg_pub.initialize;

2960: END IF;
2961: /*
2962: -- Initialize message list if p_init_msg_list is set to TRUE.
2963: IF fnd_api.to_boolean(p_init_msg_list) THEN
2964: fnd_msg_pub.initialize;
2965: END IF;
2966: */
2967: -- Get master org id
2968: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);

Line 3022: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

3018: -- Check that expense_account is not null
3019: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3020: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3021: --FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
3022: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3023:
3024: RAISE FND_API.G_EXC_ERROR;
3025:
3026: END IF;

Line 3114: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

3110:
3111: IF nvl(l_x_master_item_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3112: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
3113: l_msg_string:=FND_MESSAGE.GET;
3114: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3115: RAISE FND_API.G_EXC_ERROR;
3116:
3117: END IF;
3118:

Line 3123: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

3119:
3120: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3121: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
3122: l_msg_string:=FND_MESSAGE.GET;
3123: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3124: -- commented for BUG# 5484686
3125: RAISE FND_API.G_EXC_ERROR;
3126: END IF;
3127:

Line 3130: --fnd_msg_pub.count_and_get(p_count => x_msg_count

3126: END IF;
3127:
3128:
3129: -- Standard call to get message count and if count is 1, get message info.
3130: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3131: -- ,p_data => x_msg_data);
3132: -- commented for BUG# 5484686
3133:
3134: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');

Line 3141: -- fnd_msg_pub.count_and_get(p_count => x_msg_count

3137: WHEN fnd_api.g_exc_error THEN
3138: ROLLBACK TO EAM_Activity_PUB;
3139: x_return_status := fnd_api.g_ret_sts_error;
3140:
3141: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3142: -- ,p_data => x_msg_data);
3143: -- commented for BUG# 5484686
3144: WHEN fnd_api.g_exc_unexpected_error THEN
3145: ROLLBACK TO EAM_Activity_PUB;

Line 3148: --fnd_msg_pub.count_and_get(p_count => x_msg_count

3144: WHEN fnd_api.g_exc_unexpected_error THEN
3145: ROLLBACK TO EAM_Activity_PUB;
3146: x_return_status := fnd_api.g_ret_sts_unexp_error;
3147:
3148: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3149: -- ,p_data => x_msg_data);
3150: -- commented for BUG# 5484686
3151: WHEN OTHERS THEN
3152: ROLLBACK TO EAM_Activity_PUB;

Line 3154: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3150: -- commented for BUG# 5484686
3151: WHEN OTHERS THEN
3152: ROLLBACK TO EAM_Activity_PUB;
3153: x_return_status := fnd_api.g_ret_sts_unexp_error;
3154: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3156: END IF;*/
3157: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3158: -- ,p_data => x_msg_data);

Line 3155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3151: WHEN OTHERS THEN
3152: ROLLBACK TO EAM_Activity_PUB;
3153: x_return_status := fnd_api.g_ret_sts_unexp_error;
3154: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3156: END IF;*/
3157: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3158: -- ,p_data => x_msg_data);
3159: -- commented for BUG# 5484686

Line 3157: -- fnd_msg_pub.count_and_get(p_count => x_msg_count

3153: x_return_status := fnd_api.g_ret_sts_unexp_error;
3154: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3156: END IF;*/
3157: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3158: -- ,p_data => x_msg_data);
3159: -- commented for BUG# 5484686
3160:
3161: x_msg_data:=l_msg_string||l_error_string;