[Home] [Help]
353: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_EFFECTIVE_DATE_EVENT';
354:
355: L_EVENT_NAME VARCHAR2(60) := 'oracle.apps.dpp.notifyeffective';
356: L_ITEM_KEY VARCHAR2(30);
357: L_PARAMETER_LIST WF_PARAMETER_LIST_T;
358: L_USER_NAME VARCHAR2(255);
359: L_EVENT_TEST VARCHAR2(10);
360:
361: BEGIN
395: FND_FILE.NEW_LINE(FND_FILE.LOG);
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:
399: L_PARAMETER_LIST := WF_PARAMETER_LIST_T();
400: WF_EVENT.ADDPARAMETERTOLIST( P_NAME => 'PROGRAM_ID', P_VALUE => P_PROGRAM_ID, P_PARAMETERLIST => L_PARAMETER_LIST );
401: WF_EVENT.RAISE ( P_EVENT_NAME => L_EVENT_NAME,
402: P_EVENT_KEY => L_ITEM_KEY,
403: P_PARAMETERS => L_PARAMETER_LIST,
521: ITEMKEY => ITEMKEY,
522: ANAME => 'EFFECTIVE_DATE',
523: AVALUE => TRUNC(SYSDATE));
524:
525: -- L_PARAMETER_LIST := WF_PARAMETER_LIST_T();
526: --
527: -- WF_EVENT.ADDPARAMETERTOLIST ( P_NAME => 'CREATED_USER_ID',
528: -- P_VALUE => L_USER_NAME,
529: -- P_PARAMETERLIST => L_PARAMETER_LIST);
1787: IS
1788: l_api_name CONSTANT VARCHAR2(30) := 'Raise_Business_Event';
1789: l_event_name VARCHAR2(60):= 'oracle.apps.dpp.executions';
1790: l_new_item_key VARCHAR2(30);
1791: l_parameter_list WF_PARAMETER_LIST_T;
1792: l_target_system VARCHAR2(4) := 'EBIZ';
1793: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1794: l_exe_status VARCHAR2(15) := 'SUBMITTED';
1795: l_event_test VARCHAR2(10);
1851: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1852: END IF;
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END;
1855: --Define in WF Attributes l_parameter_list := WF_PARAMETER_LIST_T();
1856: WF_EVENT.AddParameterToList( p_name => 'TARGETSYSTEM'
1857: , p_value => l_target_system
1858: , p_parameterlist => l_parameter_list
1859: );