APPS.M4R_7B1_WSM_IN dependencies on WSM_STARTING_JOBS_INTERFACE

Line 2199: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE for hdr_id : '|| l_rec.hdr_id;

2195:
2196:
2197: GET_INTRAOPERATION_STEP (l_prev_wip_entity_id,l_intra_step,l_avbl_qty,l_fm_op_seq_num);
2198:
2199: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE for hdr_id : '|| l_rec.hdr_id;
2200:
2201: INSERT
2202: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,
2203: WIP_ENTITY_ID,

Line 2202: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,

2198:
2199: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE for hdr_id : '|| l_rec.hdr_id;
2200:
2201: INSERT
2202: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,
2203: WIP_ENTITY_ID,
2204: OPERATION_SEQ_NUM,
2205: INTRAOPERATION_STEP,
2206: REPRESENTATIVE_FLAG,

Line 2232: cln_debug_pub.Add('-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE for Job '|| l_rec.prev_lot_number,1);

2228: l_result_qty := l_result_qty + l_rec.prev_lot_qty;
2229:
2230: IF (g_debug_level <= 1) THEN
2231: cln_debug_pub.Add('l_result_qty : ' || l_result_qty,1);
2232: cln_debug_pub.Add('-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE for Job '|| l_rec.prev_lot_number,1);
2233: END IF;
2234: END IF;
2235: END LOOP;
2236:

Line 2276: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE for hdr_id : '|| p_hdr_rec.hdr_id;

2272: END;
2273:
2274: GET_INTRAOPERATION_STEP (l_prev_wip_entity_id ,l_intra_step,l_avbl_qty,l_fm_op_seq_num);
2275:
2276: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE for hdr_id : '|| p_hdr_rec.hdr_id;
2277:
2278: IF (g_debug_level <= 1) THEN
2279: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2280: END IF;

Line 2283: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,

2279: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2280: END IF;
2281:
2282: INSERT
2283: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,
2284: WIP_ENTITY_ID,
2285: OPERATION_SEQ_NUM,
2286: INTRAOPERATION_STEP,
2287: REPRESENTATIVE_FLAG,

Line 2307: cln_debug_pub.Add('-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE --------',2);

2303: sysdate,
2304: p_user_id);
2305:
2306: IF (g_debug_level <= 2) THEN
2307: cln_debug_pub.Add('-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE --------',2);
2308: END IF;
2309:
2310: FOR l_rec IN M4R_7B1_WSM_WIP_SPLIT_C1(p_hdr_rec.msg_id,p_hdr_rec.prev_lot_number,p_hdr_rec.from_sub_inventory) LOOP
2311:

Line 2509: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE';

2505: END IF;
2506:
2507: GET_INTRAOPERATION_STEP (l_wip_entity_id ,l_intra_step,l_avbl_qty,l_fm_op_seq_num);
2508:
2509: g_exception_tracking_msg := 'Inserting values into WSM_STARTING_JOBS_INTERFACE';
2510:
2511: IF (g_debug_level <= 1) THEN
2512: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2513: END IF;

Line 2516: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,

2512: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2513: END IF;
2514:
2515: INSERT
2516: INTO WSM_STARTING_JOBS_INTERFACE ( HEADER_ID,
2517: WIP_ENTITY_ID,
2518: OPERATION_SEQ_NUM,
2519: INTRAOPERATION_STEP,
2520: REPRESENTATIVE_FLAG,

Line 2539: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE --------';

2535: p_user_id,
2536: sysdate,
2537: p_user_id);
2538:
2539: g_exception_tracking_msg := '-------- Values successfully inserted into WSM_STARTING_JOBS_INTERFACE --------';
2540:
2541: IF (g_debug_level <= 1) THEN
2542: cln_debug_pub.Add(g_exception_tracking_msg,1);
2543: END IF;