APPS.EAM_ACTIVITY_PUB dependencies on FND_API

Line 22: RAISE FND_API.G_EXC_ERROR;

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
26: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_RTG_COPY_OPT');

Line 29: RAISE FND_API.G_EXC_ERROR;

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
33: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACTCOPY_ASC_COPY_OPT');

Line 36: RAISE FND_API.G_EXC_ERROR;

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

Line 60: RAISE FND_API.G_EXC_ERROR;

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).
64: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RES_COPY_OPT_NOT_NONE');

Line 67: RAISE FND_API.G_EXC_ERROR;

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)
71: -- p_material_copy_option and p_resource_copy_option can be 1 (NONE), 2 (ISSUED), or 3 (ALL)

Line 77: RAISE FND_API.G_EXC_ERROR;

73: IF p_material_copy_option NOT IN (1, 2, 3) THEN
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).

Line 85: RAISE FND_API.G_EXC_ERROR;

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).
89: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_OP_COPY_OPT_INVALID');

Line 92: RAISE FND_API.G_EXC_ERROR;

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.
96:

Line 112: RAISE FND_API.G_EXC_ERROR;

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
116: */

Line 122: RAISE FND_API.G_EXC_ERROR;

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;
126: */

Line 717: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

713: );
714: l_item_rec.organization_id := l_temp_org_id;
715: l_item_rec.organization_code := l_temp_org_code;
716:
717: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: -- ============================================================

Line 718: RAISE FND_API.G_EXC_ERROR;

714: l_item_rec.organization_id := l_temp_org_id;
715: l_item_rec.organization_code := l_temp_org_code;
716:
717: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: -- ============================================================
722: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');

Line 735: IF l_item_rec.inventory_item_flag IS NULL OR l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR

731:
732: -- Set attributes of l_item_rec
733: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
734:
735: IF l_item_rec.inventory_item_flag IS NULL OR l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR
736: THEN
737: l_item_rec.inventory_item_flag := 'Y';
738: END IF;
739:

Line 740: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM

736: THEN
737: l_item_rec.inventory_item_flag := 'Y';
738: END IF;
739:
740: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
741: THEN
742: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
743: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
744: END IF;

Line 746: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM

742: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
743: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
744: END IF;
745: -- Check that expense_account is not null
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);

Line 751: RAISE FND_API.G_EXC_ERROR;

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
755: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR

Line 755: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR

751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: IF l_item_rec.bom_enabled_flag IS NULL OR
755: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR
756: THEN
757: l_item_rec.bom_enabled_flag := 'Y';
758: END IF;
759:

Line 792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: -- Create Item under master org fail, no use tyring to create it under child org.
794: RETURN;
795: END IF;
796: ELSE

Line 800: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;

796: ELSE
797: -- Current Org is Master Org, no additional Item needs to be created.
798: EAM_ActivityUtilities_PVT.Write_Debug('Current Org is Master Org, no additional Item needs to be created.');
799: x_master_item_rec := l_x_master_item_rec; -- should be NULL
800: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;
801: x_master_item_error_tbl := l_x_master_item_error_tbl; -- should be NULL
802: END IF;
803:
804: -- 2 d) Create Activity in current org

Line 814: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM

810: /*Bug#3269789 - start*/
811: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_curr_organization_id);
812:
813: -- Check that expense_account is not null
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);

Line 819: RAISE FND_API.G_EXC_ERROR;

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:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');

Line 856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

852:
853: -- ======================================================================
854: PROCEDURE Create_Activity
855: ( p_api_version IN NUMBER ,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
858: p_validation_level IN NUMBER :=
859: FND_API.G_VALID_LEVEL_FULL ,
860: x_return_status OUT NOCOPY VARCHAR2 ,

Line 857: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

853: -- ======================================================================
854: PROCEDURE Create_Activity
855: ( p_api_version IN NUMBER ,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
858: p_validation_level IN NUMBER :=
859: FND_API.G_VALID_LEVEL_FULL ,
860: x_return_status OUT NOCOPY VARCHAR2 ,
861: x_msg_count OUT NOCOPY NUMBER ,

Line 859: FND_API.G_VALID_LEVEL_FULL ,

855: ( p_api_version IN NUMBER ,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
858: p_validation_level IN NUMBER :=
859: FND_API.G_VALID_LEVEL_FULL ,
860: x_return_status OUT NOCOPY VARCHAR2 ,
861: x_msg_count OUT NOCOPY NUMBER ,
862: x_msg_data OUT NOCOPY VARCHAR2 ,
863:

Line 965: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

961: BEGIN
962: -- Standard Start of API savepoint
963: SAVEPOINT Create_Activity_PUB;
964: -- Standard call to check for call compatibility.
965: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
966: p_api_version ,
967: l_api_name ,
968: G_PKG_NAME )
969: THEN

Line 970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

966: p_api_version ,
967: l_api_name ,
968: G_PKG_NAME )
969: THEN
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;

Line 973: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 977: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
979:
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');

Line 1016: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

1012: p_work_order_rec => p_work_order_rec,
1013: x_return_status => l_x_work_order_ret_sts,
1014: x_work_order_rec => l_x_work_order_rec
1015: );
1016: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019: -- Set return parameter
1020: x_work_order_rec := l_x_work_order_rec;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: x_return_status => l_x_work_order_ret_sts,
1014: x_work_order_rec => l_x_work_order_rec
1015: );
1016: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019: -- Set return parameter
1020: x_work_order_rec := l_x_work_order_rec;
1021:

Line 1058: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1054: x_master_item_return_status => l_x_master_item_return_status,
1055: x_master_item_error_tbl => l_x_master_item_error_tbl
1056: );
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;

Line 1062: RAISE FND_API.G_EXC_ERROR;

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
1066: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');

Line 1065: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1069: RAISE FND_API.G_EXC_ERROR;

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
1073: /*

Line 1095: RAISE FND_API.G_EXC_ERROR;

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:
1098: l_x_curr_item_rec.EAM_ACTIVITY_TYPE_CODE := p_activity_type_code;
1099: l_x_curr_item_rec.EAM_ACTIVITY_CAUSE_CODE := p_activity_cause_code;

Line 1118: RAISE FND_API.G_EXC_ERROR;

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: */
1121:
1122: -- Assign outputs

Line 1160: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1156: x_rtg_msg_count := l_x_rtg_msg_count;
1157: x_rtg_msg_list := l_x_rtg_msg_list;
1158:
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;

Line 1164: RAISE FND_API.G_EXC_ERROR;

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:
1168: -- ============================================================

Line 1194: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1190: x_bom_msg_count := l_x_bom_msg_count;
1191: x_bom_msg_list := l_x_bom_msg_list;
1192:
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;

Line 1198: RAISE FND_API.G_EXC_ERROR;

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:
1202: -- ============================================================

Line 1229: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1225: x_act_num_association_tbl := l_x_act_num_association_tbl;
1226: x_activity_association_tbl := l_x_activity_association_tbl;
1227:
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;

Line 1233: RAISE FND_API.G_EXC_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;
1237:

Line 1242: IF FND_API.To_Boolean( p_commit ) THEN

1238: -- ======================================================================
1239:
1240: -- End of API body.
1241: -- Standard check of p_commit.
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

Line 1257: WHEN FND_API.G_EXC_ERROR THEN

1253:
1254: -- ======================================================================
1255:
1256: EXCEPTION
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

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR ;

1256: EXCEPTION
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: );

Line 1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1271: p_data => x_msg_data
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

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 1297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1293: -- ================================================================================
1294:
1295: PROCEDURE Copy_Activity
1296: ( p_api_version IN NUMBER ,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1299: p_validation_level IN NUMBER :=
1300: FND_API.G_VALID_LEVEL_FULL ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1294:
1295: PROCEDURE Copy_Activity
1296: ( p_api_version IN NUMBER ,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1299: p_validation_level IN NUMBER :=
1300: FND_API.G_VALID_LEVEL_FULL ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,
1302: x_msg_count OUT NOCOPY NUMBER ,

Line 1300: FND_API.G_VALID_LEVEL_FULL ,

1296: ( p_api_version IN NUMBER ,
1297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1298: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1299: p_validation_level IN NUMBER :=
1300: FND_API.G_VALID_LEVEL_FULL ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,
1302: x_msg_count OUT NOCOPY NUMBER ,
1303: x_msg_data OUT NOCOPY VARCHAR2 ,
1304:

Line 1407: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1403: BEGIN
1404: -- Standard Start of API savepoint
1405: SAVEPOINT Copy_Activity_PUB;
1406: -- Standard call to check for call compatibility.
1407: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1408: p_api_version ,
1409: l_api_name ,
1410: G_PKG_NAME )
1411: THEN

Line 1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1408: p_api_version ,
1409: l_api_name ,
1410: G_PKG_NAME )
1411: THEN
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;

Line 1415: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1419: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1421:
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');

Line 1487: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1483: x_master_item_return_status => l_x_master_item_return_status,
1484: x_master_item_error_tbl => l_x_master_item_error_tbl
1485: );
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;

Line 1491: RAISE FND_API.G_EXC_ERROR;

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
1495: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');

Line 1494: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1498: RAISE FND_API.G_EXC_ERROR;

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
1502: /*

Line 1524: RAISE FND_API.G_EXC_ERROR;

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:
1527: l_x_curr_item_rec.EAM_ACTIVITY_TYPE_CODE := p_activity_type_code;
1528: l_x_curr_item_rec.EAM_ACTIVITY_CAUSE_CODE := p_activity_cause_code;

Line 1547: RAISE FND_API.G_EXC_ERROR;

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: */
1550:
1551: -- Assign outputs

Line 1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
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;

Line 1619: RAISE FND_API.G_EXC_ERROR;

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(
1623: p_organization_id => l_x_curr_item_rec.organization_id,

Line 1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
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;

Line 1711: RAISE FND_API.G_EXC_ERROR;

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(
1715: p_organization_id => l_x_curr_item_rec.organization_id,

Line 1792: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1788: x_act_num_association_tbl := l_x_act_num_association_tbl;
1789: x_activity_association_tbl := l_x_activity_association_tbl;
1790:
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;

Line 1796: RAISE FND_API.G_EXC_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;
1800:

Line 1808: IF FND_API.To_Boolean( p_commit ) THEN

1804:
1805:
1806: -- End of API body.
1807: -- Standard check of p_commit.
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

Line 1822: WHEN FND_API.G_EXC_ERROR THEN

1818:
1819:
1820: -- ======================================================================
1821: EXCEPTION
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

Line 1825: x_return_status := FND_API.G_RET_STS_ERROR ;

1821: EXCEPTION
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: );

Line 1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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 2069: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2065: );
2066:
2067: -- Assign outputs
2068:
2069: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2070: commit;
2071: x_successful := TRUE;
2072: ELSE
2073: x_successful := FALSE;

Line 2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

2081: -- ================================================================================
2082:
2083: PROCEDURE Create_Activity_With_Template(
2084: p_api_version IN NUMBER ,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2087: p_validation_level IN NUMBER :=
2088: FND_API.G_VALID_LEVEL_FULL ,
2089: x_return_status OUT NOCOPY VARCHAR2 ,

Line 2086: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2082:
2083: PROCEDURE Create_Activity_With_Template(
2084: p_api_version IN NUMBER ,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2087: p_validation_level IN NUMBER :=
2088: FND_API.G_VALID_LEVEL_FULL ,
2089: x_return_status OUT NOCOPY VARCHAR2 ,
2090: x_msg_count OUT NOCOPY NUMBER ,

Line 2088: FND_API.G_VALID_LEVEL_FULL ,

2084: p_api_version IN NUMBER ,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2087: p_validation_level IN NUMBER :=
2088: FND_API.G_VALID_LEVEL_FULL ,
2089: x_return_status OUT NOCOPY VARCHAR2 ,
2090: x_msg_count OUT NOCOPY NUMBER ,
2091: x_msg_data OUT NOCOPY VARCHAR2 ,
2092:

Line 2152: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2148: BEGIN
2149: -- Standard Start of API savepoint
2150: SAVEPOINT Create_Act_With_Templ_PUB;
2151: -- Standard call to check for call compatibility.
2152: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2153: p_api_version ,
2154: l_api_name ,
2155: G_PKG_NAME )
2156: THEN

Line 2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2153: p_api_version ,
2154: l_api_name ,
2155: G_PKG_NAME )
2156: THEN
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;

Line 2160: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2164: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2166:
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');

Line 2277: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2273: x_master_item_rec := l_x_master_item_rec;
2274: x_master_item_return_status := l_x_master_item_return_status;
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;

Line 2280: RAISE FND_API.G_EXC_ERROR;

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
2284: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_CR_ACT_CURRENT_FAILED');

Line 2283: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2286: RAISE FND_API.G_EXC_ERROR;

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: -- =============================================================
2290:

Line 2293: IF FND_API.To_Boolean( p_commit ) THEN

2289: -- =============================================================
2290:
2291: -- End of API body.
2292: -- Standard check of p_commit.
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

Line 2308: WHEN FND_API.G_EXC_ERROR THEN

2304:
2305: -- ======================================================================
2306:
2307: EXCEPTION
2308: WHEN FND_API.G_EXC_ERROR THEN
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 ;

Line 2312: x_return_status := FND_API.G_RET_STS_ERROR ;

2308: WHEN FND_API.G_EXC_ERROR THEN
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: );

Line 2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: );

Line 2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2326: WHEN OTHERS THEN
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

Line 2481: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

2477:
2478:
2479: PROCEDURE Create_Activity_With_Template(
2480: --p_api_version IN NUMBER ,
2481: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2482: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2483: --p_validation_level IN NUMBER :=
2484: -- FND_API.G_VALID_LEVEL_FULL ,
2485: x_return_status OUT NOCOPY VARCHAR2 ,

Line 2482: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2478:
2479: PROCEDURE Create_Activity_With_Template(
2480: --p_api_version IN NUMBER ,
2481: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2482: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2483: --p_validation_level IN NUMBER :=
2484: -- FND_API.G_VALID_LEVEL_FULL ,
2485: x_return_status OUT NOCOPY VARCHAR2 ,
2486: --x_msg_count OUT NUMBER ,

Line 2484: -- FND_API.G_VALID_LEVEL_FULL ,

2480: --p_api_version IN NUMBER ,
2481: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2482: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2483: --p_validation_level IN NUMBER :=
2484: -- FND_API.G_VALID_LEVEL_FULL ,
2485: x_return_status OUT NOCOPY VARCHAR2 ,
2486: --x_msg_count OUT NUMBER ,
2487: --x_msg_data OUT VARCHAR2 ,
2488:

Line 2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;

2528: l_asset_activity INV_Item_GRP.Item_rec_type;
2529:
2530: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2531: l_api_version CONSTANT NUMBER := 1.0;
2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2533: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2535:
2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

Line 2533: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;

2529:
2530: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2531: l_api_version CONSTANT NUMBER := 1.0;
2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2533: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2535:
2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2537: l_x_curr_item_return_status VARCHAR2(1);

Line 2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

2530: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2531: l_api_version CONSTANT NUMBER := 1.0;
2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2533: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2535:
2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2537: l_x_curr_item_return_status VARCHAR2(1);
2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2598: if (l_x_master_item_return_status = fnd_api.g_ret_sts_success AND l_x_curr_item_return_status = fnd_api.g_ret_sts_success) then

2594: x_master_item_return_status => l_x_master_item_return_status,
2595: x_master_item_error_tbl => l_x_master_item_error_tbl
2596: );
2597:
2598: if (l_x_master_item_return_status = fnd_api.g_ret_sts_success AND l_x_curr_item_return_status = fnd_api.g_ret_sts_success) then
2599: commit;
2600: end if;
2601:
2602: /*if x_curr_item_return_status = FND_API.G_RET_STS_SUCCESS AND x_master_item_return_status = FND_API.G_RET_STS_SUCCESS then

Line 2602: /*if x_curr_item_return_status = FND_API.G_RET_STS_SUCCESS AND x_master_item_return_status = FND_API.G_RET_STS_SUCCESS then

2598: if (l_x_master_item_return_status = fnd_api.g_ret_sts_success AND l_x_curr_item_return_status = fnd_api.g_ret_sts_success) then
2599: commit;
2600: end if;
2601:
2602: /*if x_curr_item_return_status = FND_API.G_RET_STS_SUCCESS AND x_master_item_return_status = FND_API.G_RET_STS_SUCCESS then
2603: commit;
2604: x_success := TRUE;
2605: else
2606: x_success := FALSE;

Line 2750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

2746: -- package body
2747: -- wrapper API used to call Copy_Activity procedure from form
2748: procedure Copy_Activity(
2749: p_api_version IN NUMBER ,
2750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2751: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2752: p_validation_level IN NUMBER :=
2753: FND_API.G_VALID_LEVEL_FULL ,
2754: x_return_status OUT NOCOPY VARCHAR2 ,

Line 2751: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2747: -- wrapper API used to call Copy_Activity procedure from form
2748: procedure Copy_Activity(
2749: p_api_version IN NUMBER ,
2750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2751: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2752: p_validation_level IN NUMBER :=
2753: FND_API.G_VALID_LEVEL_FULL ,
2754: x_return_status OUT NOCOPY VARCHAR2 ,
2755: x_msg_count OUT NOCOPY NUMBER ,

Line 2753: FND_API.G_VALID_LEVEL_FULL ,

2749: p_api_version IN NUMBER ,
2750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2751: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2752: p_validation_level IN NUMBER :=
2753: FND_API.G_VALID_LEVEL_FULL ,
2754: x_return_status OUT NOCOPY VARCHAR2 ,
2755: x_msg_count OUT NOCOPY NUMBER ,
2756: x_msg_data OUT NOCOPY VARCHAR2 ,
2757:

Line 2954: IF NOT fnd_api.compatible_api_call(

2950: BEGIN
2951: SAVEPOINT EAM_Activity_PUB;
2952: -- Standard call to check for call compatibility.
2953: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2954: IF NOT fnd_api.compatible_api_call(
2955: l_api_version
2956: ,p_api_version
2957: ,l_api_name
2958: ,g_pkg_name) THEN

Line 2959: RAISE fnd_api.g_exc_unexpected_error;

2955: l_api_version
2956: ,p_api_version
2957: ,l_api_name
2958: ,g_pkg_name) THEN
2959: RAISE fnd_api.g_exc_unexpected_error;
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

Line 2963: IF fnd_api.to_boolean(p_init_msg_list) THEN

2959: RAISE fnd_api.g_exc_unexpected_error;
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

Line 3000: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2996: x_organization_id => l_item_rec.organization_id,
2997: x_organization_code => l_item_rec.organization_code
2998: );
2999:
3000: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3001:
3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:

Line 3002: RAISE FND_API.G_EXC_ERROR;

2998: );
2999:
3000: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3001:
3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:
3005: -- ============================================================
3006: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');

Line 3010: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN

3006: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3007:
3008:
3009: IF l_item_rec.inventory_item_flag IS NULL OR
3010: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3011: l_item_rec.inventory_item_flag := 'Y';
3012: END IF;
3013: /*
3014: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN

Line 3014: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN

3010: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3011: l_item_rec.inventory_item_flag := 'Y';
3012: END IF;
3013: /*
3014: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3015: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
3016: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
3017: END IF;
3018: -- Check that expense_account is not null

Line 3019: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN

3015: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
3016: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
3017: END IF;
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:

Line 3024: RAISE FND_API.G_EXC_ERROR;

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;
3027:
3028: */ -- commented for BUG# 5484686

Line 3030: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN

3026: END IF;
3027:
3028: */ -- commented for BUG# 5484686
3029: IF l_item_rec.bom_enabled_flag IS NULL OR
3030: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3031: l_item_rec.bom_enabled_flag := 'Y';
3032: END IF;
3033:
3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

Line 3111: IF nvl(l_x_master_item_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

3107:
3108: -- Assign outputs
3109: x_return_status := l_x_return_status;
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;

Line 3115: RAISE FND_API.G_EXC_ERROR;

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

Line 3120: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3116:
3117: END IF;
3118:
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

Line 3125: RAISE FND_API.G_EXC_ERROR;

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:
3128:
3129: -- Standard call to get message count and if count is 1, get message info.

Line 3137: WHEN fnd_api.g_exc_error THEN

3133:
3134: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3135:
3136: EXCEPTION
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

Line 3139: x_return_status := fnd_api.g_ret_sts_error;

3135:
3136: EXCEPTION
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

Line 3144: WHEN fnd_api.g_exc_unexpected_error THEN

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;
3146: x_return_status := fnd_api.g_ret_sts_unexp_error;
3147:
3148: --fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 3146: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3153: x_return_status := fnd_api.g_ret_sts_unexp_error;

3149: -- ,p_data => x_msg_data);
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