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:
412: ,p_parameters => l_parameter_list);
413:
414:
415: l_parameter_list.DELETE;
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: EXCEPTION
418: WHEN Others THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_data := SQLERRM ;
415: l_parameter_list.DELETE;
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: EXCEPTION
418: WHEN Others THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_data := SQLERRM ;
421: END Raise_Item_Create_Update_Event;
422:
423:
585: ,p_parameters => l_parameter_list);
586: END IF;
587:
588: l_parameter_list.DELETE;
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: EXCEPTION
592: WHEN Others THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: EXCEPTION
592: WHEN Others THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: x_msg_data := SQLERRM;
595: END Raise_Item_Event;
596: --End : 4105841 : Business Event Enhancement
597:
674: ,p_parameters => l_parameter_list);
675: END IF;
676:
677: l_parameter_list.DELETE;
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: EXCEPTION
681: WHEN Others THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: EXCEPTION
681: WHEN Others THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: x_msg_data := SQLERRM;
684: END Raise_Categories_Event;
685:
686: --R12C Raise Post Process Message Event for Orchestration
754: ,p_parameters => l_parameter_list);
755:
756: l_parameter_list.DELETE;
757:
758: x_return_status := FND_API.G_RET_STS_SUCCESS;
759: x_msg_data := NULL;
760:
761: EXCEPTION
762: WHEN OTHERS THEN
759: x_msg_data := NULL;
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: x_msg_data := SQLERRM;
765:
766: END Raise_Post_Process_Msg_Event;
767:
770: IS
771: l_true_false VARCHAR2(1);
772: BEGIN
773: l_true_false := p_true_false;
774: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
775: l_true_false := FND_API.g_true;
776: END IF;
777: G_ITEM_BULKLOAD_BUS_EVENT := l_true_false;
778: END Set_Item_Bulkload_Bus_Event;
771: l_true_false VARCHAR2(1);
772: BEGIN
773: l_true_false := p_true_false;
774: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
775: l_true_false := FND_API.g_true;
776: END IF;
777: G_ITEM_BULKLOAD_BUS_EVENT := l_true_false;
778: END Set_Item_Bulkload_Bus_Event;
779:
781: IS
782: l_true_false VARCHAR2(1);
783: BEGIN
784: l_true_false := p_true_false;
785: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
786: l_true_false := FND_API.g_true;
787: END IF;
788: G_REV_CHANGE_BUS_EVENT := l_true_false;
789: END Set_Rev_Change_Bus_Event;
782: l_true_false VARCHAR2(1);
783: BEGIN
784: l_true_false := p_true_false;
785: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
786: l_true_false := FND_API.g_true;
787: END IF;
788: G_REV_CHANGE_BUS_EVENT := l_true_false;
789: END Set_Rev_Change_Bus_Event;
790:
792: IS
793: l_true_false VARCHAR2(1);
794: BEGIN
795: l_true_false := p_true_false;
796: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
797: l_true_false := FND_API.g_true;
798: END IF;
799: G_CAT_ASSIGN_BUS_EVENT := l_true_false;
800: END Set_Category_Assign_Bus_Event;
793: l_true_false VARCHAR2(1);
794: BEGIN
795: l_true_false := p_true_false;
796: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
797: l_true_false := FND_API.g_true;
798: END IF;
799: G_CAT_ASSIGN_BUS_EVENT := l_true_false;
800: END Set_Category_Assign_Bus_Event;
801:
803: IS
804: l_true_false VARCHAR2(1);
805: BEGIN
806: l_true_false := p_true_false;
807: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
808: l_true_false := FND_API.g_true;
809: END IF;
810: G_POST_ATTR_BUS_EVENT := l_true_false;
811: END Set_PostAttr_Change_Event;
804: l_true_false VARCHAR2(1);
805: BEGIN
806: l_true_false := p_true_false;
807: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
808: l_true_false := FND_API.g_true;
809: END IF;
810: G_POST_ATTR_BUS_EVENT := l_true_false;
811: END Set_PostAttr_Change_Event;
812:
814: IS
815: l_true_false VARCHAR2(1);
816: BEGIN
817: l_true_false := p_true_false;
818: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
819: l_true_false := FND_API.g_true;
820: END IF;
821: G_POST_AML_BUS_EVENT := l_true_false;
822: END Set_PostAml_Change_Event;
815: l_true_false VARCHAR2(1);
816: BEGIN
817: l_true_false := p_true_false;
818: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
819: l_true_false := FND_API.g_true;
820: END IF;
821: G_POST_AML_BUS_EVENT := l_true_false;
822: END Set_PostAml_Change_Event;
823:
825: IS
826: l_true_false VARCHAR2(1);
827: BEGIN
828: l_true_false := p_true_false;
829: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
830: l_true_false := FND_API.g_true;
831: END IF;
832: G_ITEM_PEOPLE_BUS_EVENT := l_true_false;
833: END Set_Item_People_Event;
826: l_true_false VARCHAR2(1);
827: BEGIN
828: l_true_false := p_true_false;
829: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN
830: l_true_false := FND_API.g_true;
831: END IF;
832: G_ITEM_PEOPLE_BUS_EVENT := l_true_false;
833: END Set_Item_People_Event;
834: