2699: SET status_flag ='R' ,group_id = l_group_id
2700: WHERE msg_id = p_hdr_rec.msg_id
2701: AND status_flag ='T';
2702:
2703: g_exception_tracking_msg := '-------- Calling WSMPLOAD.load --------';
2704:
2705: IF (g_debug_level <= 2) THEN
2706: cln_debug_pub.Add(g_exception_tracking_msg,2);
2707: cln_debug_pub.Add('l_group_id : ' || l_group_id, 2);
2706: cln_debug_pub.Add(g_exception_tracking_msg,2);
2707: cln_debug_pub.Add('l_group_id : ' || l_group_id, 2);
2708: END IF;
2709:
2710: WSMPLOAD.load(l_errbuf, l_retcode,'1', l_group_id );
2711:
2712: IF (g_debug_level <= 2) THEN
2713: cln_debug_pub.Add('-------- Out of WSMPLOAD.load --------',2);
2714: cln_debug_pub.Add('l_retcode : ' || l_retcode, 2);
2709:
2710: WSMPLOAD.load(l_errbuf, l_retcode,'1', l_group_id );
2711:
2712: IF (g_debug_level <= 2) THEN
2713: cln_debug_pub.Add('-------- Out of WSMPLOAD.load --------',2);
2714: cln_debug_pub.Add('l_retcode : ' || l_retcode, 2);
2715: cln_debug_pub.Add('l_errbuf : ' || l_errbuf, 2);
2716: END IF;
2717: