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.JTF_EC_WORKFLOW_PKG dependencies on WF_EVENT

Line 2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

2025:
2026: BEGIN
2027: --Get the item key
2028: l_list := NULL;
2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2030: wf_event.addparametertolist ('TASK_ID', to_char(l_task_id), l_list);
2031:
2032: -- Raise the create task event
2033: wf_event.raise3(

Line 2030: wf_event.addparametertolist ('TASK_ID', to_char(l_task_id), l_list);

2026: BEGIN
2027: --Get the item key
2028: l_list := NULL;
2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2030: wf_event.addparametertolist ('TASK_ID', to_char(l_task_id), l_list);
2031:
2032: -- Raise the create task event
2033: wf_event.raise3(
2034: p_event_name => l_event_name,

Line 2033: wf_event.raise3(

2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2030: wf_event.addparametertolist ('TASK_ID', to_char(l_task_id), l_list);
2031:
2032: -- Raise the create task event
2033: wf_event.raise3(
2034: p_event_name => l_event_name,
2035: p_event_key => l_key,
2036: p_parameter_list => l_list,
2037: p_send_date => sysdate

Line 2053: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

2049:
2050: BEGIN
2051: --Get the item key
2052: l_list := NULL;
2053: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2054:
2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);

Line 2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);

2051: --Get the item key
2052: l_list := NULL;
2053: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2054:
2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);

Line 2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);

2052: l_list := NULL;
2053: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2054:
2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);

Line 2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);

2053: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2054:
2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);

Line 2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);

2054:
2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);

Line 2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);

2055: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);

Line 2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);

2056: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);

Line 2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);

2057: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);

Line 2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);

2058: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);

Line 2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);

2059: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2067:

Line 2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);

2060: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2067:
2068: -- Raise the create task event

Line 2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);

2061: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2067:
2068: -- Raise the create task event
2069: wf_event.raise3( p_event_name => l_event_name,

Line 2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);

2062: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2063: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2064: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2067:
2068: -- Raise the create task event
2069: wf_event.raise3( p_event_name => l_event_name,
2070: p_event_key => l_key,

Line 2069: wf_event.raise3( p_event_name => l_event_name,

2065: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2066: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2067:
2068: -- Raise the create task event
2069: wf_event.raise3( p_event_name => l_event_name,
2070: p_event_key => l_key,
2071: p_parameter_list => l_list,
2072: p_send_date => sysdate
2073: );

Line 2078: FUNCTION create_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

2074: l_list.DELETE;
2075: END Raise_Esc_Update_Event;
2076:
2077:
2078: FUNCTION create_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2079: RETURN VARCHAR2 IS
2080: l_task_id jtf_tasks_b.task_id%TYPE;
2081: l_wf_process_id NUMBER;
2082: l_notif_not_sent VARCHAR2(1000);

Line 2088: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

2084: x_msg_count NUMBER;
2085: x_msg_data VARCHAR2(1000);
2086:
2087: BEGIN
2088: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2089:
2090: Start_Resc_Workflow(
2091: P_API_VERSION =>1.0,
2092: P_INIT_MSG_LIST =>'T',

Line 2114: wf_event.seterrorinfo(p_event, 'WARNING');

2110: X_WF_PROCESS_ID =>l_wf_process_id);
2111:
2112: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2113: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2114: wf_event.seterrorinfo(p_event, 'WARNING');
2115: RETURN 'WARNING';
2116: END IF;
2117:
2118: RETURN 'SUCCESS';

Line 2122: wf_event.seterrorinfo(p_event, 'WARNING');

2118: RETURN 'SUCCESS';
2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2122: wf_event.seterrorinfo(p_event, 'WARNING');
2123: RETURN 'WARNING';
2124: END create_esc_notif_subs;
2125:
2126:

Line 2128: FUNCTION update_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

2124: END create_esc_notif_subs;
2125:
2126:
2127:
2128: FUNCTION update_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2129: RETURN VARCHAR2 IS
2130: l_wf_process_id NUMBER;
2131: l_notif_not_sent VARCHAR2(1000);
2132: x_return_status VARCHAR2(200);

Line 2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

2134: x_msg_data VARCHAR2(1000);
2135:
2136: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2137: BEGIN
2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);

Line 2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);

2135:
2136: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2137: BEGIN
2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);

Line 2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);

2136: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2137: BEGIN
2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);

Line 2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);

2137: BEGIN
2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);

Line 2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);

2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);

Line 2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);

2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);

Line 2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);

2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);

Line 2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);

2141: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);

Line 2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);

2142: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);
2150:

Line 2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);

2143: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);
2150:
2151: Start_Resc_Workflow(

Line 2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);

2144: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);
2150:
2151: Start_Resc_Workflow(
2152: P_API_VERSION =>1.0,

Line 2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);

2145: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2146: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2147: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2148: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2149: l_esc_rec.old_target_date := wf_event.getvalueforparameter('OLD_TARGET_DATE', p_event.parameter_list);
2150:
2151: Start_Resc_Workflow(
2152: P_API_VERSION =>1.0,
2153: P_INIT_MSG_LIST =>'T',

Line 2175: wf_event.seterrorinfo(p_event, 'WARNING');

2171: X_WF_PROCESS_ID =>l_wf_process_id);
2172:
2173: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2174: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2175: wf_event.seterrorinfo(p_event, 'WARNING');
2176: RETURN 'WARNING';
2177: END IF;
2178:
2179: RETURN 'SUCCESS';

Line 2183: wf_event.seterrorinfo(p_event, 'WARNING');

2179: RETURN 'SUCCESS';
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2183: wf_event.seterrorinfo(p_event, 'WARNING');
2184: RETURN 'WARNING';
2185: END update_esc_notif_subs;
2186:
2187: --End of code for ER 7032664