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 2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

2082:
2083: BEGIN
2084: --Get the item key
2085: l_list := NULL;
2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);

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

2084: --Get the item key
2085: l_list := NULL;
2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);

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

2085: l_list := NULL;
2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);

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

2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);

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

2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);

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

2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);

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

2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);

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

2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);
2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);

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

2091: wf_event.addparametertolist ('OWNER_TYPE_CHANGED', l_esc_rec.owner_type_changed, l_list);
2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);

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

2092: wf_event.addparametertolist ('LEVEL_CHANGED', l_esc_rec.level_changed, l_list);
2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2100:

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

2093: wf_event.addparametertolist ('STATUS_CHANGED', l_esc_rec.status_changed, l_list);
2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2100:
2101: -- Raise the create task event

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

2094: wf_event.addparametertolist ('TARGET_DATE_CHANGED', l_esc_rec.target_date_changed, l_list);
2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2100:
2101: -- Raise the create task event
2102: wf_event.raise3( p_event_name => l_event_name,

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

2095: wf_event.addparametertolist ('OLD_OWNER_ID', to_char(l_esc_rec.old_owner_id), l_list);
2096: wf_event.addparametertolist ('OLD_OWNER_TYPE_CODE', l_esc_rec.old_owner_type_code, l_list);
2097: wf_event.addparametertolist ('OLD_LEVEL', l_esc_rec.old_level, l_list);
2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2100:
2101: -- Raise the create task event
2102: wf_event.raise3( p_event_name => l_event_name,
2103: p_event_key => l_key,

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

2098: wf_event.addparametertolist ('OLD_STATUS_ID', to_char(l_esc_rec.old_status_id), l_list);
2099: wf_event.addparametertolist ('OLD_TARGET_DATE', to_char(l_esc_rec.old_target_date,'YYYY-MM-DD HH24:MI:SS'), l_list);
2100:
2101: -- Raise the create task event
2102: wf_event.raise3( p_event_name => l_event_name,
2103: p_event_key => l_key,
2104: p_parameter_list => l_list,
2105: p_send_date => sysdate
2106: );

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

2109: COMMIT WORK;
2110: END Raise_Esc_Update_Event;
2111:
2112:
2113: FUNCTION create_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2114: RETURN VARCHAR2 IS
2115: l_task_id jtf_tasks_b.task_id%TYPE;
2116: l_wf_process_id NUMBER;
2117: l_notif_not_sent VARCHAR2(1000);

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

2119: x_msg_count NUMBER;
2120: x_msg_data VARCHAR2(1000);
2121:
2122: BEGIN
2123: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2124:
2125: Start_Resc_Workflow(
2126: P_API_VERSION =>1.0,
2127: P_INIT_MSG_LIST =>'T',

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

2145: X_WF_PROCESS_ID =>l_wf_process_id);
2146:
2147: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2148: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2149: wf_event.seterrorinfo(p_event, 'WARNING');
2150: RETURN 'WARNING';
2151: END IF;
2152:
2153: RETURN 'SUCCESS';

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

2153: RETURN 'SUCCESS';
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2157: wf_event.seterrorinfo(p_event, 'WARNING');
2158: RETURN 'WARNING';
2159: END create_esc_notif_subs;
2160:
2161:

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

2159: END create_esc_notif_subs;
2160:
2161:
2162:
2163: FUNCTION update_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2164: RETURN VARCHAR2 IS
2165: l_wf_process_id NUMBER;
2166: l_notif_not_sent VARCHAR2(1000);
2167: x_return_status VARCHAR2(200);

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

2169: x_msg_data VARCHAR2(1000);
2170:
2171: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2172: BEGIN
2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);

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

2170:
2171: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2172: BEGIN
2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);

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

2171: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2172: BEGIN
2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);

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

2172: BEGIN
2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);

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

2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);

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

2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);

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

2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);

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

2176: l_esc_rec.owner_type_changed := wf_event.getvalueforparameter('OWNER_TYPE_CHANGED', p_event.parameter_list);
2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');

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

2177: l_esc_rec.level_changed := wf_event.getvalueforparameter('LEVEL_CHANGED', p_event.parameter_list);
2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');
2185:

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

2178: l_esc_rec.status_changed := wf_event.getvalueforparameter('STATUS_CHANGED', p_event.parameter_list);
2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');
2185:
2186: Start_Resc_Workflow(

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

2179: l_esc_rec.target_date_changed := wf_event.getvalueforparameter('TARGET_DATE_CHANGED', p_event.parameter_list);
2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');
2185:
2186: Start_Resc_Workflow(
2187: P_API_VERSION =>1.0,

Line 2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');

2180: l_esc_rec.old_owner_id := wf_event.getvalueforparameter('OLD_OWNER_ID', p_event.parameter_list);
2181: l_esc_rec.old_owner_type_code := wf_event.getvalueforparameter('OLD_OWNER_TYPE_CODE', p_event.parameter_list);
2182: l_esc_rec.old_level := wf_event.getvalueforparameter('OLD_LEVEL', p_event.parameter_list);
2183: l_esc_rec.old_status_id := wf_event.getvalueforparameter('OLD_STATUS_ID', p_event.parameter_list);
2184: l_esc_rec.old_target_date := to_date(wf_event.getvalueforparameter('OLD_TARGET_DATE',p_event.parameter_list),'YYYY-MM-DD HH24:MI:SS');
2185:
2186: Start_Resc_Workflow(
2187: P_API_VERSION =>1.0,
2188: P_INIT_MSG_LIST =>'T',

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

2206: X_WF_PROCESS_ID =>l_wf_process_id);
2207:
2208: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2209: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2210: wf_event.seterrorinfo(p_event, 'WARNING');
2211: RETURN 'WARNING';
2212: END IF;
2213:
2214: RETURN 'SUCCESS';

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

2214: RETURN 'SUCCESS';
2215: EXCEPTION
2216: WHEN OTHERS THEN
2217: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2218: wf_event.seterrorinfo(p_event, 'WARNING');
2219: RETURN 'WARNING';
2220: END update_esc_notif_subs;
2221:
2222: --End of code for ER 7032664