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_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 743: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

739: );
740: l_item_rec.organization_id := l_temp_org_id;
741: l_item_rec.organization_code := l_temp_org_code;
742:
743: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- ============================================================

Line 744: RAISE FND_API.G_EXC_ERROR;

740: l_item_rec.organization_id := l_temp_org_id;
741: l_item_rec.organization_code := l_temp_org_code;
742:
743: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- ============================================================
748: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');

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

757:
758: -- Set attributes of l_item_rec
759: l_item_rec.eam_item_type := 2; -- EAM Asset Activity
760:
761: IF l_item_rec.inventory_item_flag IS NULL OR l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR
762: THEN
763: l_item_rec.inventory_item_flag := 'Y';
764: END IF;
765:

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

762: THEN
763: l_item_rec.inventory_item_flag := 'Y';
764: END IF;
765:
766: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM
767: THEN
768: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
769: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
770: END IF;

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

771:
772: /* Bug 13418048 Avoiding expense account required check as activity is not costed or purchased
773: -- Check that expense_account is not null
774:
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);

Line 780: RAISE FND_API.G_EXC_ERROR;

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

Line 784: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR

780: RAISE FND_API.G_EXC_ERROR;
781: END IF; */
782:
783: IF l_item_rec.bom_enabled_flag IS NULL OR
784: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR
785: THEN
786: l_item_rec.bom_enabled_flag := 'Y';
787: END IF;
788:

Line 821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: -- Create Item under master org fail, no use tyring to create it under child org.
823: RETURN;
824: END IF;
825: ELSE

Line 829: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;

825: ELSE
826: -- Current Org is Master Org, no additional Item needs to be created.
827: EAM_ActivityUtilities_PVT.Write_Debug('Current Org is Master Org, no additional Item needs to be created.');
828: x_master_item_rec := l_x_master_item_rec; -- should be NULL
829: x_master_item_return_status := FND_API.G_RET_STS_SUCCESS;
830: x_master_item_error_tbl := l_x_master_item_error_tbl; -- should be NULL
831: END IF;
832:
833: -- 2 d) Create Activity in current org

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

841:
842: /* Bug 13838073 Avoiding expense account required check as activity is not costed or purchased
843:
844: -- Check that expense_account is not null
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);

Line 850: RAISE FND_API.G_EXC_ERROR;

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

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

883:
884: -- ======================================================================
885: PROCEDURE Create_Activity
886: ( p_api_version IN NUMBER ,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
889: p_validation_level IN NUMBER :=
890: FND_API.G_VALID_LEVEL_FULL ,
891: x_return_status OUT NOCOPY VARCHAR2 ,

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

884: -- ======================================================================
885: PROCEDURE Create_Activity
886: ( p_api_version IN NUMBER ,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
889: p_validation_level IN NUMBER :=
890: FND_API.G_VALID_LEVEL_FULL ,
891: x_return_status OUT NOCOPY VARCHAR2 ,
892: x_msg_count OUT NOCOPY NUMBER ,

Line 890: FND_API.G_VALID_LEVEL_FULL ,

886: ( p_api_version IN NUMBER ,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
889: p_validation_level IN NUMBER :=
890: FND_API.G_VALID_LEVEL_FULL ,
891: x_return_status OUT NOCOPY VARCHAR2 ,
892: x_msg_count OUT NOCOPY NUMBER ,
893: x_msg_data OUT NOCOPY VARCHAR2 ,
894:

Line 996: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

992: BEGIN
993: -- Standard Start of API savepoint
994: SAVEPOINT Create_Activity_PUB;
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
997: p_api_version ,
998: l_api_name ,
999: G_PKG_NAME )
1000: THEN

Line 1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

997: p_api_version ,
998: l_api_name ,
999: G_PKG_NAME )
1000: THEN
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;

Line 1004: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1008: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1010:
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');

Line 1047: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

1043: p_work_order_rec => p_work_order_rec,
1044: x_return_status => l_x_work_order_ret_sts,
1045: x_work_order_rec => l_x_work_order_rec
1046: );
1047: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050: -- Set return parameter
1051: x_work_order_rec := l_x_work_order_rec;

Line 1048: RAISE FND_API.G_EXC_ERROR;

1044: x_return_status => l_x_work_order_ret_sts,
1045: x_work_order_rec => l_x_work_order_rec
1046: );
1047: IF l_x_work_order_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050: -- Set return parameter
1051: x_work_order_rec := l_x_work_order_rec;
1052:

Line 1089: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1085: x_master_item_return_status => l_x_master_item_return_status,
1086: x_master_item_error_tbl => l_x_master_item_error_tbl
1087: );
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;

Line 1093: RAISE FND_API.G_EXC_ERROR;

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

Line 1096: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1100: RAISE FND_API.G_EXC_ERROR;

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

Line 1126: RAISE FND_API.G_EXC_ERROR;

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

Line 1149: RAISE FND_API.G_EXC_ERROR;

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: */
1152:
1153: -- Assign outputs

Line 1191: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1187: x_rtg_msg_count := l_x_rtg_msg_count;
1188: x_rtg_msg_list := l_x_rtg_msg_list;
1189:
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;

Line 1195: RAISE FND_API.G_EXC_ERROR;

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

Line 1225: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1221: x_bom_msg_count := l_x_bom_msg_count;
1222: x_bom_msg_list := l_x_bom_msg_list;
1223:
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;

Line 1229: RAISE FND_API.G_EXC_ERROR;

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

Line 1260: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1256: x_act_num_association_tbl := l_x_act_num_association_tbl;
1257: x_activity_association_tbl := l_x_activity_association_tbl;
1258:
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;

Line 1264: RAISE FND_API.G_EXC_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;
1268:

Line 1273: IF FND_API.To_Boolean( p_commit ) THEN

1269: -- ======================================================================
1270:
1271: -- End of API body.
1272: -- Standard check of p_commit.
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

Line 1288: WHEN FND_API.G_EXC_ERROR THEN

1284:
1285: -- ======================================================================
1286:
1287: EXCEPTION
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

Line 1291: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

1324: -- ================================================================================
1325:
1326: PROCEDURE Copy_Activity
1327: ( p_api_version IN NUMBER ,
1328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1329: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1330: p_validation_level IN NUMBER :=
1331: FND_API.G_VALID_LEVEL_FULL ,
1332: x_return_status OUT NOCOPY VARCHAR2 ,

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

1325:
1326: PROCEDURE Copy_Activity
1327: ( p_api_version IN NUMBER ,
1328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1329: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1330: p_validation_level IN NUMBER :=
1331: FND_API.G_VALID_LEVEL_FULL ,
1332: x_return_status OUT NOCOPY VARCHAR2 ,
1333: x_msg_count OUT NOCOPY NUMBER ,

Line 1331: FND_API.G_VALID_LEVEL_FULL ,

1327: ( p_api_version IN NUMBER ,
1328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1329: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1330: p_validation_level IN NUMBER :=
1331: FND_API.G_VALID_LEVEL_FULL ,
1332: x_return_status OUT NOCOPY VARCHAR2 ,
1333: x_msg_count OUT NOCOPY NUMBER ,
1334: x_msg_data OUT NOCOPY VARCHAR2 ,
1335:

Line 1438: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1434: BEGIN
1435: -- Standard Start of API savepoint
1436: SAVEPOINT Copy_Activity_PUB;
1437: -- Standard call to check for call compatibility.
1438: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1439: p_api_version ,
1440: l_api_name ,
1441: G_PKG_NAME )
1442: THEN

Line 1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1439: p_api_version ,
1440: l_api_name ,
1441: G_PKG_NAME )
1442: THEN
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;

Line 1446: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1450: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1452:
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');

Line 1518: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1514: x_master_item_return_status => l_x_master_item_return_status,
1515: x_master_item_error_tbl => l_x_master_item_error_tbl
1516: );
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;

Line 1522: RAISE FND_API.G_EXC_ERROR;

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

Line 1525: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1529: RAISE FND_API.G_EXC_ERROR;

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

Line 1555: RAISE FND_API.G_EXC_ERROR;

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

Line 1578: RAISE FND_API.G_EXC_ERROR;

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: */
1581:
1582: -- Assign outputs

Line 1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
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;

Line 1650: RAISE FND_API.G_EXC_ERROR;

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

Line 1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
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;

Line 1742: RAISE FND_API.G_EXC_ERROR;

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

Line 1823: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1819: x_act_num_association_tbl := l_x_act_num_association_tbl;
1820: x_activity_association_tbl := l_x_activity_association_tbl;
1821:
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;

Line 1827: RAISE FND_API.G_EXC_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;
1831:

Line 1839: IF FND_API.To_Boolean( p_commit ) THEN

1835:
1836:
1837: -- End of API body.
1838: -- Standard check of p_commit.
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

Line 1853: WHEN FND_API.G_EXC_ERROR THEN

1849:
1850:
1851: -- ======================================================================
1852: EXCEPTION
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

Line 1856: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

2096: );
2097:
2098: -- Assign outputs
2099:
2100: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2101: commit;
2102: x_successful := TRUE;
2103: ELSE
2104: x_successful := FALSE;

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

2112: -- ================================================================================
2113:
2114: PROCEDURE Create_Activity_With_Template(
2115: p_api_version IN NUMBER ,
2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2117: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2118: p_validation_level IN NUMBER :=
2119: FND_API.G_VALID_LEVEL_FULL ,
2120: x_return_status OUT NOCOPY VARCHAR2 ,

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

2113:
2114: PROCEDURE Create_Activity_With_Template(
2115: p_api_version IN NUMBER ,
2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2117: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2118: p_validation_level IN NUMBER :=
2119: FND_API.G_VALID_LEVEL_FULL ,
2120: x_return_status OUT NOCOPY VARCHAR2 ,
2121: x_msg_count OUT NOCOPY NUMBER ,

Line 2119: FND_API.G_VALID_LEVEL_FULL ,

2115: p_api_version IN NUMBER ,
2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2117: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2118: p_validation_level IN NUMBER :=
2119: FND_API.G_VALID_LEVEL_FULL ,
2120: x_return_status OUT NOCOPY VARCHAR2 ,
2121: x_msg_count OUT NOCOPY NUMBER ,
2122: x_msg_data OUT NOCOPY VARCHAR2 ,
2123:

Line 2183: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT Create_Act_With_Templ_PUB;
2182: -- Standard call to check for call compatibility.
2183: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2184: p_api_version ,
2185: l_api_name ,
2186: G_PKG_NAME )
2187: THEN

Line 2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2184: p_api_version ,
2185: l_api_name ,
2186: G_PKG_NAME )
2187: THEN
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;

Line 2191: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2195: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2197:
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');

Line 2308: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2304: x_master_item_rec := l_x_master_item_rec;
2305: x_master_item_return_status := l_x_master_item_return_status;
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;

Line 2311: RAISE FND_API.G_EXC_ERROR;

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

Line 2314: IF l_x_curr_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2317: RAISE FND_API.G_EXC_ERROR;

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

Line 2324: IF FND_API.To_Boolean( p_commit ) THEN

2320: -- =============================================================
2321:
2322: -- End of API body.
2323: -- Standard check of p_commit.
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

Line 2339: WHEN FND_API.G_EXC_ERROR THEN

2335:
2336: -- ======================================================================
2337:
2338: EXCEPTION
2339: WHEN FND_API.G_EXC_ERROR THEN
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 ;

Line 2343: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

2508:
2509:
2510: PROCEDURE Create_Activity_With_Template(
2511: --p_api_version IN NUMBER ,
2512: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2513: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2514: --p_validation_level IN NUMBER :=
2515: -- FND_API.G_VALID_LEVEL_FULL ,
2516: x_return_status OUT NOCOPY VARCHAR2 ,

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

2509:
2510: PROCEDURE Create_Activity_With_Template(
2511: --p_api_version IN NUMBER ,
2512: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2513: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2514: --p_validation_level IN NUMBER :=
2515: -- FND_API.G_VALID_LEVEL_FULL ,
2516: x_return_status OUT NOCOPY VARCHAR2 ,
2517: --x_msg_count OUT NUMBER ,

Line 2515: -- FND_API.G_VALID_LEVEL_FULL ,

2511: --p_api_version IN NUMBER ,
2512: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2513: --p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2514: --p_validation_level IN NUMBER :=
2515: -- FND_API.G_VALID_LEVEL_FULL ,
2516: x_return_status OUT NOCOPY VARCHAR2 ,
2517: --x_msg_count OUT NUMBER ,
2518: --x_msg_data OUT VARCHAR2 ,
2519:

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

2559: l_asset_activity INV_Item_GRP.Item_rec_type;
2560:
2561: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2562: l_api_version CONSTANT NUMBER := 1.0;
2563: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2564: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2566:
2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

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

2560:
2561: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2562: l_api_version CONSTANT NUMBER := 1.0;
2563: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2564: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2566:
2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2568: l_x_curr_item_return_status VARCHAR2(1);

Line 2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

2561: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2562: l_api_version CONSTANT NUMBER := 1.0;
2563: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2564: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2566:
2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2568: l_x_curr_item_return_status VARCHAR2(1);
2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2629: 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

2625: x_master_item_return_status => l_x_master_item_return_status,
2626: x_master_item_error_tbl => l_x_master_item_error_tbl
2627: );
2628:
2629: 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
2630: commit;
2631: end if;
2632:
2633: /*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 2633: /*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

2629: 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
2630: commit;
2631: end if;
2632:
2633: /*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
2634: commit;
2635: x_success := TRUE;
2636: else
2637: x_success := FALSE;

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

2777: -- package body
2778: -- wrapper API used to call Copy_Activity procedure from form
2779: procedure Copy_Activity(
2780: p_api_version IN NUMBER ,
2781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2782: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2783: p_validation_level IN NUMBER :=
2784: FND_API.G_VALID_LEVEL_FULL ,
2785: x_return_status OUT NOCOPY VARCHAR2 ,

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

2778: -- wrapper API used to call Copy_Activity procedure from form
2779: procedure Copy_Activity(
2780: p_api_version IN NUMBER ,
2781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2782: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2783: p_validation_level IN NUMBER :=
2784: FND_API.G_VALID_LEVEL_FULL ,
2785: x_return_status OUT NOCOPY VARCHAR2 ,
2786: x_msg_count OUT NOCOPY NUMBER ,

Line 2784: FND_API.G_VALID_LEVEL_FULL ,

2780: p_api_version IN NUMBER ,
2781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2782: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2783: p_validation_level IN NUMBER :=
2784: FND_API.G_VALID_LEVEL_FULL ,
2785: x_return_status OUT NOCOPY VARCHAR2 ,
2786: x_msg_count OUT NOCOPY NUMBER ,
2787: x_msg_data OUT NOCOPY VARCHAR2 ,
2788:

Line 2985: IF NOT fnd_api.compatible_api_call(

2981: BEGIN
2982: SAVEPOINT EAM_Activity_PUB;
2983: -- Standard call to check for call compatibility.
2984: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2985: IF NOT fnd_api.compatible_api_call(
2986: l_api_version
2987: ,p_api_version
2988: ,l_api_name
2989: ,g_pkg_name) THEN

Line 2990: RAISE fnd_api.g_exc_unexpected_error;

2986: l_api_version
2987: ,p_api_version
2988: ,l_api_name
2989: ,g_pkg_name) THEN
2990: RAISE fnd_api.g_exc_unexpected_error;
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

Line 2994: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 3031: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3027: x_organization_id => l_item_rec.organization_id,
3028: x_organization_code => l_item_rec.organization_code
3029: );
3030:
3031: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032:
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035:

Line 3033: RAISE FND_API.G_EXC_ERROR;

3029: );
3030:
3031: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032:
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035:
3036: -- ============================================================
3037: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');

Line 3041: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN

3037: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3038:
3039:
3040: IF l_item_rec.inventory_item_flag IS NULL OR
3041: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3042: l_item_rec.inventory_item_flag := 'Y';
3043: END IF;
3044: /*
3045: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN

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

3041: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN
3042: l_item_rec.inventory_item_flag := 'Y';
3043: END IF;
3044: /*
3045: IF l_item_rec.expense_account IS NULL OR l_item_rec.expense_account = fnd_api.g_MISS_NUM THEN
3046: -- In the Master Item form, Expense Account defaulted from Master Org. So should use Master Org.
3047: l_item_rec.expense_account := EAM_ActivityUtilities_PVT.Get_Expense_Account_Id(l_master_organization_id);
3048: END IF;
3049: -- Check that expense_account is not null

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

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

Line 3055: RAISE FND_API.G_EXC_ERROR;

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

Line 3061: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN

3057: END IF;
3058:
3059: */ -- commented for BUG# 5484686
3060: IF l_item_rec.bom_enabled_flag IS NULL OR
3061: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3062: l_item_rec.bom_enabled_flag := 'Y';
3063: END IF;
3064:
3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

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

3138:
3139: -- Assign outputs
3140: x_return_status := l_x_return_status;
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;

Line 3146: RAISE FND_API.G_EXC_ERROR;

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

Line 3151: IF l_x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3147:
3148: END IF;
3149:
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

Line 3156: RAISE FND_API.G_EXC_ERROR;

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

Line 3168: WHEN fnd_api.g_exc_error THEN

3164:
3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3166:
3167: EXCEPTION
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

Line 3170: x_return_status := fnd_api.g_ret_sts_error;

3166:
3167: EXCEPTION
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

Line 3175: WHEN fnd_api.g_exc_unexpected_error THEN

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;
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: --fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 3177: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3184: x_return_status := fnd_api.g_ret_sts_unexp_error;

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