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 779: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);

775: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
776: THEN
777: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
778: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
779: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
780: RAISE FND_API.G_EXC_ERROR;
781: END IF; */
782:
783: IF l_item_rec.bom_enabled_flag IS NULL OR

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

845: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
846: THEN
847: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
848: -- FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
849: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;*/
852: /*Bug#3269789 - end*/
853:

Line 1005: FND_MSG_PUB.initialize;

1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003: -- Initialize message list if p_init_msg_list is set to TRUE.
1004: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1005: FND_MSG_PUB.initialize;
1006: END IF;
1007: -- Initialize API return status to success
1008: x_return_status := FND_API.G_RET_STS_SUCCESS;
1009: -- API body

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

1088:
1089: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1091: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1092: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1095:
1096: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1097: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1098: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1099: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:
1103: -- Set the Activity Attributes in the Item Record, don't have to do it manually

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

1118: WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
1119: AND organization_id = l_x_master_item_rec.organization_id;
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1123: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1124: FND_MSG_PUB.ADD;
1125: END IF;
1126: RAISE FND_API.G_EXC_ERROR;

Line 1124: FND_MSG_PUB.ADD;

1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1123: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1124: FND_MSG_PUB.ADD;
1125: END IF;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END;
1128:

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

1141: WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
1142: AND organization_id = l_x_curr_item_rec.organization_id;
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1146: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1147: FND_MSG_PUB.ADD;
1148: END IF;
1149: RAISE FND_API.G_EXC_ERROR;

Line 1147: FND_MSG_PUB.ADD;

1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1146: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1147: FND_MSG_PUB.ADD;
1148: END IF;
1149: RAISE FND_API.G_EXC_ERROR;
1150: END;
1151: */

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

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

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

1224: -- Handle errors
1225: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1226: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1227: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1228: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232:

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

1259: -- Handle error
1260: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1261: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1262: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1263: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266:
1267: END IF;

Line 1277: FND_MSG_PUB.Count_And_Get

1273: IF FND_API.To_Boolean( p_commit ) THEN
1274: COMMIT WORK;
1275: END IF;
1276: -- Standard call to get message count and if count is 1, get message info.
1277: FND_MSG_PUB.Count_And_Get
1278: ( p_count => x_msg_count ,
1279: p_data => x_msg_data
1280: );
1281:

Line 1292: FND_MSG_PUB.Count_And_Get

1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO Create_Activity_PUB;
1290: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1291: x_return_status := FND_API.G_RET_STS_ERROR ;
1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,
1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1300: FND_MSG_PUB.Count_And_Get

1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Create_Activity_PUB;
1298: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count ,
1302: p_data => x_msg_data
1303: );
1304: WHEN OTHERS THEN

Line 1307: IF FND_MSG_PUB.Check_Msg_Level

1303: );
1304: WHEN OTHERS THEN
1305: ROLLBACK TO Create_Activity_PUB;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: IF FND_MSG_PUB.Check_Msg_Level
1308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1309: THEN
1310: FND_MSG_PUB.Add_Exc_Msg
1311: ( G_PKG_NAME ,

Line 1308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1304: WHEN OTHERS THEN
1305: ROLLBACK TO Create_Activity_PUB;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: IF FND_MSG_PUB.Check_Msg_Level
1308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1309: THEN
1310: FND_MSG_PUB.Add_Exc_Msg
1311: ( G_PKG_NAME ,
1312: l_api_name

Line 1310: FND_MSG_PUB.Add_Exc_Msg

1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: IF FND_MSG_PUB.Check_Msg_Level
1308: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1309: THEN
1310: FND_MSG_PUB.Add_Exc_Msg
1311: ( G_PKG_NAME ,
1312: l_api_name
1313: );
1314: -- log error message also

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

1311: ( G_PKG_NAME ,
1312: l_api_name
1313: );
1314: -- log error message also
1315: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1316: END IF;
1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count ,

Line 1318: FND_MSG_PUB.Count_And_Get

1314: -- log error message also
1315: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1316: END IF;
1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count ,
1320: p_data => x_msg_data
1321: );
1322: END Create_Activity;

Line 1447: FND_MSG_PUB.initialize;

1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END IF;
1445: -- Initialize message list if p_init_msg_list is set to TRUE.
1446: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1447: FND_MSG_PUB.initialize;
1448: END IF;
1449: -- Initialize API return status to success
1450: x_return_status := FND_API.G_RET_STS_SUCCESS;
1451: -- API body

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

1517:
1518: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1519: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
1520: -- FND_MESSAGE.SET_ENCODED('Create Activity under Master Organization failed.');
1521: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1524:
1525: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1526: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
1527: -- FND_MESSAGE.SET_ENCODED('Create Activity under Current Organization failed.');
1528: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532: -- Set the Activity Attributes in the Item Record, don't have to do it manually

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

1547: WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
1548: AND organization_id = l_x_master_item_rec.organization_id;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1552: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1553: FND_MSG_PUB.ADD;
1554: END IF;
1555: RAISE FND_API.G_EXC_ERROR;

Line 1553: FND_MSG_PUB.ADD;

1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1552: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1553: FND_MSG_PUB.ADD;
1554: END IF;
1555: RAISE FND_API.G_EXC_ERROR;
1556: END;
1557:

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

1570: WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
1571: AND organization_id = l_x_curr_item_rec.organization_id;
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1575: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1576: FND_MSG_PUB.ADD;
1577: END IF;
1578: RAISE FND_API.G_EXC_ERROR;

Line 1576: FND_MSG_PUB.ADD;

1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1575: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
1576: FND_MSG_PUB.ADD;
1577: END IF;
1578: RAISE FND_API.G_EXC_ERROR;
1579: END;
1580: */

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

1645: -- Handle errors
1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');
1648: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1649: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: l_target_rtg_sequence_id := EAM_ActivityUtilities_PVT.Get_Rtg_Sequence_id(

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

1673: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_ROUTING.copy_routing **********');
1674:
1675: -- write copy_routing error message to fnd message stack and log file
1676: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_ROUTING.copy_routing >>>>>');
1677: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1678: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_ROUTING.copy_routing <<<<<');
1679:
1680: END IF; -- l_source_rtg_sequence_id IS NULL
1681:

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

1737: -- Handle errors
1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');
1740: -- FND_MESSAGE.SET_ENCODED('Call to Routing Business Object API Failed.');
1741: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: l_target_bom_sequence_id := EAM_ActivityUtilities_PVT.Get_Bom_Sequence_id(

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

1770: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_COPY_BILL.copy_bill **********');
1771:
1772: -- write copy_bill error message to fnd message stack and log file
1773: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_COPY_BILL.copy_bill >>>>>');
1774: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1775: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_COPY_BILL.copy_bill <<<<<');
1776:
1777:
1778: END IF; -- l_source_bom_sequence_id IS NULL

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

1822: -- Handle error
1823: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ASSOC_FAILED');
1825: -- FND_MESSAGE.SET_ENCODED('Create Activity Associations failed.');
1826: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
1827: RAISE FND_API.G_EXC_ERROR;
1828: END IF;
1829:
1830: END IF;

Line 1843: FND_MSG_PUB.Count_And_Get

1839: IF FND_API.To_Boolean( p_commit ) THEN
1840: COMMIT WORK;
1841: END IF;
1842: -- Standard call to get message count and if count is 1, get message info.
1843: FND_MSG_PUB.Count_And_Get
1844: ( p_count => x_msg_count ,
1845: p_data => x_msg_data
1846: );
1847:

Line 1857: FND_MSG_PUB.Count_And_Get

1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Copy_Activity_PUB;
1855: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1856: x_return_status := FND_API.G_RET_STS_ERROR ;
1857: FND_MSG_PUB.Count_And_Get
1858: ( p_count => x_msg_count ,
1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1865: FND_MSG_PUB.Count_And_Get

1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Copy_Activity_PUB;
1863: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865: FND_MSG_PUB.Count_And_Get
1866: ( p_count => x_msg_count ,
1867: p_data => x_msg_data
1868: );
1869:

Line 1873: IF FND_MSG_PUB.Check_Msg_Level

1869:
1870: WHEN OTHERS THEN
1871: ROLLBACK TO Copy_Activity_PUB;
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME ,

Line 1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1870: WHEN OTHERS THEN
1871: ROLLBACK TO Copy_Activity_PUB;
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME ,
1878: l_api_name

Line 1876: FND_MSG_PUB.Add_Exc_Msg

1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME ,
1878: l_api_name
1879: );
1880: -- log error message also

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

1877: ( G_PKG_NAME ,
1878: l_api_name
1879: );
1880: -- log error message also
1881: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1882: END IF;
1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1884: FND_MSG_PUB.Count_And_Get
1885: ( p_count => x_msg_count ,

Line 1884: FND_MSG_PUB.Count_And_Get

1880: -- log error message also
1881: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1882: END IF;
1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1884: FND_MSG_PUB.Count_And_Get
1885: ( p_count => x_msg_count ,
1886: p_data => x_msg_data
1887: );
1888: END Copy_Activity;

Line 2192: FND_MSG_PUB.initialize;

2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189: END IF;
2190: -- Initialize message list if p_init_msg_list is set to TRUE.
2191: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2192: FND_MSG_PUB.initialize;
2193: END IF;
2194: -- Initialize API return status to success
2195: x_return_status := FND_API.G_RET_STS_SUCCESS;
2196: -- API body

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

2306: x_master_item_error_tbl := l_x_master_item_error_tbl;
2307:
2308: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2309: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
2310: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2311: RAISE FND_API.G_EXC_ERROR;
2312: END IF;
2313:
2314: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2312: END IF;
2313:
2314: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2315: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
2316: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
2317: RAISE FND_API.G_EXC_ERROR;
2318: END IF;
2319:
2320: -- =============================================================

Line 2328: FND_MSG_PUB.Count_And_Get

2324: IF FND_API.To_Boolean( p_commit ) THEN
2325: COMMIT WORK;
2326: END IF;
2327: -- Standard call to get message count and if count is 1, get message info.
2328: FND_MSG_PUB.Count_And_Get
2329: ( p_count => x_msg_count ,
2330: p_data => x_msg_data
2331: );
2332:

Line 2344: FND_MSG_PUB.Count_And_Get

2340: ROLLBACK TO Create_Act_With_Templ_PUB;
2341: EAM_ActivityUtilities_PVT.Write_Debug(
2342: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2343: x_return_status := FND_API.G_RET_STS_ERROR ;
2344: FND_MSG_PUB.Count_And_Get
2345: ( p_count => x_msg_count ,
2346: p_data => x_msg_data
2347: );
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2353: FND_MSG_PUB.Count_And_Get

2349: ROLLBACK TO Create_Act_With_Templ_PUB;
2350: EAM_ActivityUtilities_PVT.Write_Debug(
2351: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2353: FND_MSG_PUB.Count_And_Get
2354: ( p_count => x_msg_count ,
2355: p_data => x_msg_data
2356: );
2357: WHEN OTHERS THEN

Line 2362: IF FND_MSG_PUB.Check_Msg_Level

2358: ROLLBACK TO Create_Act_With_Templ_PUB;
2359: EAM_ActivityUtilities_PVT.Write_Debug(
2360: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level
2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg
2366: ( G_PKG_NAME ,

Line 2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2359: EAM_ActivityUtilities_PVT.Write_Debug(
2360: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level
2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg
2366: ( G_PKG_NAME ,
2367: l_api_name

Line 2365: FND_MSG_PUB.Add_Exc_Msg

2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level
2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg
2366: ( G_PKG_NAME ,
2367: l_api_name
2368: );
2369: END IF;

Line 2370: FND_MSG_PUB.Count_And_Get

2366: ( G_PKG_NAME ,
2367: l_api_name
2368: );
2369: END IF;
2370: FND_MSG_PUB.Count_And_Get
2371: ( p_count => x_msg_count ,
2372: p_data => x_msg_data
2373: );
2374: END Create_Activity_With_Template;

Line 2995: fnd_msg_pub.initialize;

2991: END IF;
2992: /*
2993: -- Initialize message list if p_init_msg_list is set to TRUE.
2994: IF fnd_api.to_boolean(p_init_msg_list) THEN
2995: fnd_msg_pub.initialize;
2996: END IF;
2997: */
2998: -- Get master org id
2999: l_master_organization_id := EAM_ActivityUtilities_PVT.Get_Master_Org_Id(p_org_id);

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

3049: -- Check that expense_account is not null
3050: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3051: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_EXPENSE_ACCOUNT_NULL');
3052: --FND_MESSAGE.SET_ENCODED('Please define the Expense Account for the Organization.');
3053: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3054:
3055: RAISE FND_API.G_EXC_ERROR;
3056:
3057: END IF;

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

3141:
3142: IF nvl(l_x_master_item_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3143: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_MASTER_FAILED');
3144: l_msg_string:=FND_MESSAGE.GET;
3145: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3146: RAISE FND_API.G_EXC_ERROR;
3147:
3148: END IF;
3149:

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

3150:
3151: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3152: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');
3153: l_msg_string:=FND_MESSAGE.GET;
3154: --EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
3155: -- commented for BUG# 5484686
3156: RAISE FND_API.G_EXC_ERROR;
3157: END IF;
3158:

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

3157: END IF;
3158:
3159:
3160: -- Standard call to get message count and if count is 1, get message info.
3161: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3162: -- ,p_data => x_msg_data);
3163: -- commented for BUG# 5484686
3164:
3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');

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

3168: WHEN fnd_api.g_exc_error THEN
3169: ROLLBACK TO EAM_Activity_PUB;
3170: x_return_status := fnd_api.g_ret_sts_error;
3171:
3172: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3173: -- ,p_data => x_msg_data);
3174: -- commented for BUG# 5484686
3175: WHEN fnd_api.g_exc_unexpected_error THEN
3176: ROLLBACK TO EAM_Activity_PUB;

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

3175: WHEN fnd_api.g_exc_unexpected_error THEN
3176: ROLLBACK TO EAM_Activity_PUB;
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3180: -- ,p_data => x_msg_data);
3181: -- commented for BUG# 5484686
3182: WHEN OTHERS THEN
3183: ROLLBACK TO EAM_Activity_PUB;

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

3181: -- commented for BUG# 5484686
3182: WHEN OTHERS THEN
3183: ROLLBACK TO EAM_Activity_PUB;
3184: x_return_status := fnd_api.g_ret_sts_unexp_error;
3185: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3186: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3187: END IF;*/
3188: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3189: -- ,p_data => x_msg_data);

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

3182: WHEN OTHERS THEN
3183: ROLLBACK TO EAM_Activity_PUB;
3184: x_return_status := fnd_api.g_ret_sts_unexp_error;
3185: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3186: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3187: END IF;*/
3188: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3189: -- ,p_data => x_msg_data);
3190: -- commented for BUG# 5484686

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

3184: x_return_status := fnd_api.g_ret_sts_unexp_error;
3185: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3186: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3187: END IF;*/
3188: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3189: -- ,p_data => x_msg_data);
3190: -- commented for BUG# 5484686
3191:
3192: x_msg_data:=l_msg_string||l_error_string;