8: ------------------------------
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_WF_WRAPPER_PVT';--R12C Batch Level Business Event switches
11: --R12C Entity level Business events switch
12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_WF_WRAPPER_PVT';--R12C Batch Level Business Event switches
11: --R12C Entity level Business events switch
12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
17: G_ITEM_PEOPLE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_WF_WRAPPER_PVT';--R12C Batch Level Business Event switches
11: --R12C Entity level Business events switch
12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
17: G_ITEM_PEOPLE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
18:
11: --R12C Entity level Business events switch
12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
17: G_ITEM_PEOPLE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: ----------------------------------------------------------------------
12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
17: G_ITEM_PEOPLE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: ----------------------------------------------------------------------
20:
13: G_REV_CHANGE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
14: G_CAT_ASSIGN_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
17: G_ITEM_PEOPLE_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: ----------------------------------------------------------------------
20:
21:
231: ERROR_HANDLER.Add_Error_Message(
232: p_message_name => 'EGO_EVENT_SUBSCR'
233: ,p_application_id => 'EGO'
234: --,p_token_tbl => l_token_table ---parameters Commented for bug 6518941
235: ,p_message_type => FND_API.G_RET_STS_ERROR
236: --,p_row_identifier => p_user_row_identifier
237: --,p_entity_id => p_entity_id
238: --,p_entity_index => p_entity_index
239: --,p_entity_code => p_entity_code
270: ERROR_HANDLER.Add_Error_Message(
271: p_message_name => 'EGO_PLSQL_ERR'
272: ,p_application_id => 'EGO'
273: ,p_token_tbl => l_token_table
274: ,p_message_type => FND_API.G_RET_STS_ERROR
275: ,p_row_identifier => p_user_row_identifier
276: ,p_entity_id => p_entity_id
277: ,p_entity_index => p_entity_index
278: ,p_entity_code => p_entity_code
334: ,p_event_key => l_event_key
335: ,p_parameters => l_parameter_list);
336:
337: l_parameter_list.DELETE;
338: x_return_status :=FND_API.G_RET_STS_SUCCESS;
339:
340: EXCEPTION
341: -----------------------------------------------------------
342: -- There are no expected errors in this procedure, so... --
341: -----------------------------------------------------------
342: -- There are no expected errors in this procedure, so... --
343: -----------------------------------------------------------
344: WHEN OTHERS THEN
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: x_msg_data := p_event_name ||' '|| SQLERRM;
347: END Raise_AML_Event;
348:
349:
391: ,p_value => p_request_id
392: ,p_ParameterList => l_parameter_List);
393: ELSE
394: -- Fix for bug#8474046
395: IF (p_organization_id = FND_API.G_MISS_NUM and p_organization_code is not null) THEN
396: -- Derive the Organization_id from Organization Code
397: OPEN c_get_org_id(p_organization_code);
398: FETCH c_get_org_id INTO l_org_id;
399: CLOSE c_get_org_id;
428: ,p_parameters => l_parameter_list);
429:
430:
431: l_parameter_list.DELETE;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: EXCEPTION
434: WHEN Others THEN
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: x_msg_data := SQLERRM ;
431: l_parameter_list.DELETE;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: EXCEPTION
434: WHEN Others THEN
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: x_msg_data := SQLERRM ;
437: END Raise_Item_Create_Update_Event;
438:
439:
608: ,p_parameters => l_parameter_list);
609: END IF;
610:
611: l_parameter_list.DELETE;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: EXCEPTION
615: WHEN Others THEN
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: EXCEPTION
615: WHEN Others THEN
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: x_msg_data := SQLERRM;
618: END Raise_Item_Event;
619: --End : 4105841 : Business Event Enhancement
620:
697: ,p_parameters => l_parameter_list);
698: END IF;
699:
700: l_parameter_list.DELETE;
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702:
703: EXCEPTION
704: WHEN Others THEN
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702:
703: EXCEPTION
704: WHEN Others THEN
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_data := SQLERRM;
707: END Raise_Categories_Event;
708:
709: --R12C Raise Post Process Message Event for Orchestration
777: ,p_parameters => l_parameter_list);
778:
779: l_parameter_list.DELETE;
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782: x_msg_data := NULL;
783:
784: EXCEPTION
785: WHEN OTHERS THEN
782: x_msg_data := NULL;
783:
784: EXCEPTION
785: WHEN OTHERS THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: x_msg_data := SQLERRM;
788:
789: END Raise_Post_Process_Msg_Event;
790:
793: IS
794: l_true_false VARCHAR2(1);
795: BEGIN
796: l_true_false := p_true_false;
797: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
798: l_true_false := FND_API.g_true;
799: END IF;
800: G_ITEM_BULKLOAD_BUS_EVENT := l_true_false;
801: END Set_Item_Bulkload_Bus_Event;
794: l_true_false VARCHAR2(1);
795: BEGIN
796: l_true_false := p_true_false;
797: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
798: l_true_false := FND_API.g_true;
799: END IF;
800: G_ITEM_BULKLOAD_BUS_EVENT := l_true_false;
801: END Set_Item_Bulkload_Bus_Event;
802:
804: IS
805: l_true_false VARCHAR2(1);
806: BEGIN
807: l_true_false := p_true_false;
808: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
809: l_true_false := FND_API.g_true;
810: END IF;
811: G_REV_CHANGE_BUS_EVENT := l_true_false;
812: END Set_Rev_Change_Bus_Event;
805: l_true_false VARCHAR2(1);
806: BEGIN
807: l_true_false := p_true_false;
808: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
809: l_true_false := FND_API.g_true;
810: END IF;
811: G_REV_CHANGE_BUS_EVENT := l_true_false;
812: END Set_Rev_Change_Bus_Event;
813:
815: IS
816: l_true_false VARCHAR2(1);
817: BEGIN
818: l_true_false := p_true_false;
819: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) OR p_true_false IS NULL THEN
820: l_true_false := FND_API.g_true;
821: END IF;
822: G_CAT_ASSIGN_BUS_EVENT := l_true_false;
823: END Set_Category_Assign_Bus_Event;
816: l_true_false VARCHAR2(1);
817: BEGIN
818: l_true_false := p_true_false;
819: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) OR p_true_false IS NULL THEN
820: l_true_false := FND_API.g_true;
821: END IF;
822: G_CAT_ASSIGN_BUS_EVENT := l_true_false;
823: END Set_Category_Assign_Bus_Event;
824:
826: IS
827: l_true_false VARCHAR2(1);
828: BEGIN
829: l_true_false := p_true_false;
830: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
831: l_true_false := FND_API.g_true;
832: END IF;
833: G_POST_ATTR_BUS_EVENT := l_true_false;
834: END Set_PostAttr_Change_Event;
827: l_true_false VARCHAR2(1);
828: BEGIN
829: l_true_false := p_true_false;
830: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
831: l_true_false := FND_API.g_true;
832: END IF;
833: G_POST_ATTR_BUS_EVENT := l_true_false;
834: END Set_PostAttr_Change_Event;
835:
837: IS
838: l_true_false VARCHAR2(1);
839: BEGIN
840: l_true_false := p_true_false;
841: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
842: l_true_false := FND_API.g_true;
843: END IF;
844: G_POST_AML_BUS_EVENT := l_true_false;
845: END Set_PostAml_Change_Event;
838: l_true_false VARCHAR2(1);
839: BEGIN
840: l_true_false := p_true_false;
841: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
842: l_true_false := FND_API.g_true;
843: END IF;
844: G_POST_AML_BUS_EVENT := l_true_false;
845: END Set_PostAml_Change_Event;
846:
848: IS
849: l_true_false VARCHAR2(1);
850: BEGIN
851: l_true_false := p_true_false;
852: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
853: l_true_false := FND_API.g_true;
854: END IF;
855: G_ITEM_PEOPLE_BUS_EVENT := l_true_false;
856: END Set_Item_People_Event;
849: l_true_false VARCHAR2(1);
850: BEGIN
851: l_true_false := p_true_false;
852: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
853: l_true_false := FND_API.g_true;
854: END IF;
855: G_ITEM_PEOPLE_BUS_EVENT := l_true_false;
856: END Set_Item_People_Event;
857: