DBA Data[Home] [Help]

APPS.WIP_OP_LINK_VALIDATIONS dependencies on WIP_INTERFACE_ERRORS

Line 18: /** Bug 2728127 -- removing GROUP_ID from insert as table 'wip_interface_errors'

14: next_link_id number := 0;
15:
16: procedure insert_error(P_INTERFACE_ID NUMBER, P_ERROR VARCHAR2, P_ERROR_TYPE NUMBER) IS
17: BEGIN
18: /** Bug 2728127 -- removing GROUP_ID from insert as table 'wip_interface_errors'
19: does not have the column--this causes package to be INVALID **/
20: insert into wip_interface_errors (INTERFACE_ID, ERROR_TYPE, ERROR)
21: values (P_INTERFACE_ID, P_ERROR_TYPE, P_ERROR);
22: /** Not removing the 'commit' statement here as i don't know the impact of

Line 20: insert into wip_interface_errors (INTERFACE_ID, ERROR_TYPE, ERROR)

16: procedure insert_error(P_INTERFACE_ID NUMBER, P_ERROR VARCHAR2, P_ERROR_TYPE NUMBER) IS
17: BEGIN
18: /** Bug 2728127 -- removing GROUP_ID from insert as table 'wip_interface_errors'
19: does not have the column--this causes package to be INVALID **/
20: insert into wip_interface_errors (INTERFACE_ID, ERROR_TYPE, ERROR)
21: values (P_INTERFACE_ID, P_ERROR_TYPE, P_ERROR);
22: /** Not removing the 'commit' statement here as i don't know the impact of
23: removing right now
24: Also, not introducing 'PRAGMA AUTONOMOUS...' as it is not used anywhere

Line 393: insert into wip_interface_errors (

389: wip_interface_err_Utils.load_errors;
390:
391: fnd_message.set_name('WIP', 'WIP_OP_LINK_NOT_FOUND');
392: fnd_message.set_token('INTERFACE', 4567);
393: insert into wip_interface_errors (
394: interface_id,
395: error_type,
396: error,
397: last_update_date,