DBA Data[Home] [Help]

APPS.EGO_WF_WRAPPER_PVT dependencies on FND_API

Line 12: G_ITEM_BULKLOAD_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;

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;

Line 13: G_REV_CHANGE_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;

Line 14: G_CAT_ASSIGN_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:

Line 15: G_POST_ATTR_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;

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

Line 16: G_POST_AML_BUS_EVENT VARCHAR2(1) := FND_API.G_TRUE;

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:

Line 17: G_ITEM_PEOPLE_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:
21:

Line 235: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 274: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 338: x_return_status :=FND_API.G_RET_STS_SUCCESS;

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

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 395: IF (p_organization_id = FND_API.G_MISS_NUM and p_organization_code is not null) THEN

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;

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ;

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

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

Line 701: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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

Line 781: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 797: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN

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;

Line 798: l_true_false := FND_API.g_true;

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:

Line 808: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN

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;

Line 809: l_true_false := FND_API.g_true;

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:

Line 819: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) OR p_true_false IS NULL THEN

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;

Line 820: l_true_false := FND_API.g_true;

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:

Line 830: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN

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;

Line 831: l_true_false := FND_API.g_true;

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:

Line 841: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN

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;

Line 842: l_true_false := FND_API.g_true;

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:

Line 852: IF p_true_false NOT IN (FND_API.g_true, FND_API.g_false) THEN

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;

Line 853: l_true_false := FND_API.g_true;

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: