DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on WSM_RESULTING_JOBS_INTERFACE

Line 2376: g_exception_tracking_msg := 'Inserting values into WSM_RESULTING_JOBS_INTERFACE for hdr_id : '|| l_rec.hdr_id;

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;

Line 2383: INTO WSM_RESULTING_JOBS_INTERFACE

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,

Line 2444: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_RESULTING_JOBS_INTERFACE --------';

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;

Line 2580: g_exception_tracking_msg := 'Inserting values into WSM_RESULTING_JOBS_INTERFACE';

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;

Line 2587: INTO WSM_RESULTING_JOBS_INTERFACE

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,

Line 2643: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_RESULTING_JOBS_INTERFACE --------';

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;