2537: --cursor to check whether a group_id has failed or successful
2538: cursor cur_check_error (l_group_id in pls_integer)
2539: is
2540: select 1
2541: from wsh_interface_errors wie
2542: where wie.interface_error_group_id = l_group_id
2543: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE;
2544:
2545: --cursor to log error message into log file after pulling from wsh_interface_errors
2541: from wsh_interface_errors wie
2542: where wie.interface_error_group_id = l_group_id
2543: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE;
2544:
2545: --cursor to log error message into log file after pulling from wsh_interface_errors
2546: cursor cur_log_error (l_group_id in pls_integer)
2547: is
2548: select error_message
2549: from wsh_interface_errors wie
2545: --cursor to log error message into log file after pulling from wsh_interface_errors
2546: cursor cur_log_error (l_group_id in pls_integer)
2547: is
2548: select error_message
2549: from wsh_interface_errors wie
2550: where wie.interface_error_group_id = l_group_id
2551: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE
2552: order by wie.interface_error_id;
2553:
3769: end loop;
3770: print_info(g_log_must_message,'');
3771:
3772: for i in 1..g_delete_record_count_loop loop
3773: delete from wsh_interface_errors
3774: where interface_action_code = g_tp_release_code
3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3772: for i in 1..g_delete_record_count_loop loop
3773: delete from wsh_interface_errors
3774: where interface_action_code = g_tp_release_code
3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3781: print_info(g_log_must_message,l_Message_Text);
3782: commit;
3783: end loop;