2372: RAISE return_code_false;
2373:
2374: END IF;
2375:
2376: g_exception_tracking_msg := 'Inserting values into WSM_RESULTING_JOBS_INTERFACE for hdr_id : '|| l_rec.hdr_id;
2377:
2378: IF (g_debug_level <= 1) THEN
2379: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2380: END IF;
2379: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2380: END IF;
2381:
2382: INSERT
2383: INTO WSM_RESULTING_JOBS_INTERFACE
2384: ( HEADER_ID,
2385: GROUP_ID,
2386: WIP_ENTITY_NAME,
2387: PRIMARY_ITEM_ID,
2440: END IF;
2441:
2442: END LOOP;
2443:
2444: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_RESULTING_JOBS_INTERFACE --------';
2445:
2446: IF (g_debug_level <= 1) THEN
2447: cln_debug_pub.Add(g_exception_tracking_msg,1);
2448: END IF;
2576: IF (g_debug_level <= 1) THEN
2577: cln_debug_pub.Add('l_bonus_acc_id : ' || l_bonus_acc_id,1);
2578: END IF;
2579:
2580: g_exception_tracking_msg := 'Inserting values into WSM_RESULTING_JOBS_INTERFACE';
2581:
2582: IF (g_debug_level <= 1) THEN
2583: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2584: END IF;
2583: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2584: END IF;
2585:
2586: INSERT
2587: INTO WSM_RESULTING_JOBS_INTERFACE
2588: ( HEADER_ID,
2589: GROUP_ID,
2590: WIP_ENTITY_NAME,
2591: PRIMARY_ITEM_ID,
2639: p_user_id,
2640: sysdate,
2641: p_user_id);
2642:
2643: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_RESULTING_JOBS_INTERFACE --------';
2644:
2645: IF (g_debug_level <= 1) THEN
2646: cln_debug_pub.Add(g_exception_tracking_msg,1);
2647: END IF;