eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.M4R_7B1_WSM_IN dependencies on M4R_WSM_DWIP_HDR_STAGING

Line 6: -- Purpose : This procedure updates the status flag in the M4R_WSM_DWIP_HDR_STAGING table

2: /* $Header: M4R7B1OB.pls 120.10 2006/10/04 13:45:54 bsaratna noship $ */
3:
4:
5: -- Procedure : UPDATE_STATUS_FLAG
6: -- Purpose : This procedure updates the status flag in the M4R_WSM_DWIP_HDR_STAGING table
7:
8: PROCEDURE UPDATE_STATUS_FLAG ( p_msg_id IN NUMBER,
9: p_hdr_id IN NUMBER,
10: p_flag IN VARCHAR2,

Line 24: g_exception_tracking_msg := 'Updating M4R_WSM_DWIP_HDR_STAGING with the status' || p_flag;

20: cln_debug_pub.Add('p_err_msg : ' || p_err_msg, 2);
21: cln_debug_pub.Add('p_group_id : ' || p_group_id, 2);
22: END IF;
23:
24: g_exception_tracking_msg := 'Updating M4R_WSM_DWIP_HDR_STAGING with the status' || p_flag;
25:
26: UPDATE M4R_WSM_DWIP_HDR_STAGING
27: SET status_flag = p_flag, error_message = p_err_msg,group_id = p_group_id
28: WHERE hdr_id = p_hdr_id

Line 26: UPDATE M4R_WSM_DWIP_HDR_STAGING

22: END IF;
23:
24: g_exception_tracking_msg := 'Updating M4R_WSM_DWIP_HDR_STAGING with the status' || p_flag;
25:
26: UPDATE M4R_WSM_DWIP_HDR_STAGING
27: SET status_flag = p_flag, error_message = p_err_msg,group_id = p_group_id
28: WHERE hdr_id = p_hdr_id
29: AND msg_id = p_msg_id;
30:

Line 1066: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,

1062: -- Procedure : JOB_SCRAP_COMPLETE_UNDO
1063: -- Purpose : This procedure processes the SCRAP/COMPLETE/UNDO transactions
1064:
1065: PROCEDURE JOB_SCRAP_COMPLETE_UNDO ( p_process_type IN VARCHAR2,
1066: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,
1067: p_qty_rec IN M4R_WSM_DWIP_LOT_QTY_STAGING%ROWTYPE,
1068: p_org_id IN NUMBER,
1069: p_user_id IN NUMBER,
1070: p_item_key IN VARCHAR2,

Line 1398: FROM M4R_WSM_DWIP_HDR_STAGING

1394: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.msg_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);
1395:
1396: SELECT custom_valid_status,error_message
1397: INTO l_custom_valid_pass,l_custom_valid_err_msg
1398: FROM M4R_WSM_DWIP_HDR_STAGING
1399: WHERE msg_id = p_hdr_rec.msg_id
1400: AND hdr_id = p_hdr_rec.hdr_id;
1401:
1402: IF (g_debug_level <= 1) THEN

Line 1609: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,

1605: -- Procedure : JOB_CREATE_OR_STATUS
1606: -- Purpose : This procedure processes the CREATE/STATUS UPDATE transactions
1607:
1608: PROCEDURE JOB_CREATE_OR_STATUS(p_process_type IN VARCHAR2,
1609: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,
1610: p_qty_rec IN M4R_WSM_DWIP_LOT_QTY_STAGING%ROWTYPE,
1611: p_user_id IN NUMBER,
1612: p_org_id IN NUMBER,
1613: p_item_key IN VARCHAR2,

Line 1850: FROM M4R_WSM_DWIP_HDR_STAGING

1846: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.msg_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);
1847:
1848: SELECT custom_valid_status,error_message
1849: INTO l_custom_valid_pass,l_custom_valid_err_msg
1850: FROM M4R_WSM_DWIP_HDR_STAGING
1851: WHERE msg_id = p_hdr_rec.msg_id
1852: AND hdr_id = p_hdr_rec.hdr_id;
1853:
1854: IF (g_debug_level <= 1) THEN

Line 1966: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,

1962: -- Procedure : WIP_LOT_TXNS
1963: -- Purpose : This procedure processes the WIP Transactions
1964:
1965: PROCEDURE WIP_LOT_TXNS ( p_process_type IN VARCHAR2,
1966: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,
1967: p_qty_rec IN M4R_WSM_DWIP_LOT_QTY_STAGING%ROWTYPE,
1968: p_org_id IN NUMBER,
1969: p_user_id IN NUMBER,
1970: p_item_key IN VARCHAR2,

Line 1978: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q

1974: CURSOR M4R_7B1_WSM_WIP_MERGE_C1 (l_msg_id NUMBER,l_lot_number VARCHAR2,l_sub_inv VARCHAR2)
1975: IS
1976: SELECT h.hdr_id,h.prev_lot_number,h.from_sub_inventory,h.operation_seq_num,h.lot_code,h.prev_lot_qty,q.lot_qty,
1977: h.start_lot_alt_rout_designator,q.lot_classification_code,h.status_flag,h.lot_number
1978: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q
1979: WHERE h.msg_id = l_msg_id
1980: AND( h.transaction_type = 'MERGE' OR q.lot_classification_code ='MERGE' )
1981: AND h.lot_number = l_lot_number
1982: AND h.from_sub_inventory = l_sub_inv

Line 1994: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q

1990: SELECT h.hdr_id,h.prev_lot_qty,q.lot_qty,h.prev_operation_seq_num,h.scheduled_start_date,
1991: h.scheduled_completion_date,h.starting_lot_item_code,h.primary_item_code,
1992: h.lot_number,h.alt_routing_designator,h.to_sub_inventory,h.from_sub_inventory,
1993: h.start_lot_alt_rout_designator,h.status_flag,h.prev_lot_number
1994: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q
1995: WHERE h.msg_id = l_msg_id
1996: AND( h.transaction_type = 'SPLIT' OR q.lot_classification_code ='SPLIT' )
1997: AND h.prev_lot_number = l_lot_number
1998: AND h.from_sub_inventory = l_sub_inv

Line 2127: UPDATE M4R_WSM_DWIP_HDR_STAGING

2123:
2124: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2125: l_err_msg :=FND_MESSAGE.GET;
2126:
2127: UPDATE M4R_WSM_DWIP_HDR_STAGING
2128: SET status_flag ='E',
2129: error_message = l_err_msg
2130: WHERE msg_id = p_hdr_rec.msg_id
2131: AND transaction_type = 'MERGE'

Line 2174: UPDATE M4R_WSM_DWIP_HDR_STAGING

2170:
2171: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2172: l_interface_err1 :=FND_MESSAGE.GET;
2173:
2174: UPDATE M4R_WSM_DWIP_HDR_STAGING
2175: SET status_flag ='E',
2176: error_message = l_interface_err1
2177: WHERE msg_id = p_hdr_rec.msg_id
2178: AND transaction_type = 'MERGE'

Line 2326: UPDATE M4R_WSM_DWIP_HDR_STAGING

2322:
2323: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2324: l_err_msg :=FND_MESSAGE.GET;
2325:
2326: UPDATE M4R_WSM_DWIP_HDR_STAGING
2327: SET status_flag ='E',
2328: error_message = l_err_msg
2329: WHERE msg_id = p_hdr_rec.msg_id
2330: AND transaction_type = 'SPLIT'

Line 2362: UPDATE M4R_WSM_DWIP_HDR_STAGING

2358:
2359: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2360: l_interface_err1 :=FND_MESSAGE.GET;
2361:
2362: UPDATE M4R_WSM_DWIP_HDR_STAGING
2363: SET status_flag ='E',
2364: error_message = l_interface_err1
2365: WHERE msg_id = p_hdr_rec.msg_id
2366: AND transaction_type = 'SPLIT'

Line 2663: FROM M4R_WSM_DWIP_HDR_STAGING

2659: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.hdr_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);
2660:
2661: SELECT custom_valid_status,error_message
2662: INTO l_custom_valid_pass,l_custom_valid_err_msg
2663: FROM M4R_WSM_DWIP_HDR_STAGING
2664: WHERE msg_id = p_hdr_rec.msg_id
2665: AND hdr_id = p_hdr_rec.hdr_id;
2666:
2667: IF (g_debug_level <= 1) THEN

Line 2676: UPDATE M4R_WSM_DWIP_HDR_STAGING

2672: IF l_custom_valid_pass = 'FAIL' THEN
2673:
2674: ROLLBACK TO before_insert;
2675:
2676: UPDATE M4R_WSM_DWIP_HDR_STAGING
2677: SET status_flag ='I' , error_message = l_custom_valid_err_msg,group_id = l_group_id
2678: WHERE msg_id = p_hdr_rec.msg_id
2679: AND status_flag ='T';
2680:

Line 2698: UPDATE M4R_WSM_DWIP_HDR_STAGING

2694: p_hdr_rec.msg_id);
2695:
2696: ELSE
2697:
2698: UPDATE M4R_WSM_DWIP_HDR_STAGING
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:

Line 2720: UPDATE M4R_WSM_DWIP_HDR_STAGING

2716: END IF;
2717:
2718: IF l_retcode = 0 THEN
2719:
2720: UPDATE M4R_WSM_DWIP_HDR_STAGING
2721: SET status_flag ='S',group_id = l_group_id
2722: WHERE msg_id = p_hdr_rec.msg_id
2723: AND status_flag ='R';
2724:

Line 2762: UPDATE M4R_WSM_DWIP_HDR_STAGING

2758: IF (g_debug_level <= 1) THEN
2759: cln_debug_pub.Add('l_interface_err : ' || l_interface_err, 1);
2760: END IF;
2761:
2762: UPDATE M4R_WSM_DWIP_HDR_STAGING
2763: SET status_flag ='E', error_message = l_errbuf || l_interface_err,group_id = l_group_id
2764: WHERE msg_id = p_hdr_rec.msg_id
2765: AND status_flag = 'R';
2766:

Line 2768: cln_debug_pub.Add('M4R_WSM_DWIP_HDR_STAGING updated', 1);

2764: WHERE msg_id = p_hdr_rec.msg_id
2765: AND status_flag = 'R';
2766:
2767: IF (g_debug_level <= 1) THEN
2768: cln_debug_pub.Add('M4R_WSM_DWIP_HDR_STAGING updated', 1);
2769: END IF;
2770:
2771:
2772: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 2799: UPDATE M4R_WSM_DWIP_HDR_STAGING

2795: cln_debug_pub.Add('----- No data found -----',5);
2796: END IF;
2797: l_err_flag := 'N';
2798:
2799: UPDATE M4R_WSM_DWIP_HDR_STAGING
2800: SET status_flag ='S', group_id = l_group_id
2801: WHERE msg_id = p_hdr_rec.msg_id
2802: AND status_flag ='R';
2803:

Line 2819: UPDATE M4R_WSM_DWIP_HDR_STAGING

2815: IF (g_debug_level <= 1) THEN
2816: cln_debug_pub.Add('l_interface_err : ' || l_interface_err, 1);
2817: END IF;
2818:
2819: UPDATE M4R_WSM_DWIP_HDR_STAGING
2820: SET status_flag ='E', error_message = l_errbuf || l_interface_err,group_id = l_group_id
2821: WHERE msg_id = p_hdr_rec.msg_id
2822: AND status_flag = 'R';
2823:

Line 2852: UPDATE M4R_WSM_DWIP_HDR_STAGING

2848: END IF;
2849:
2850: l_err_flag := 'N';
2851:
2852: UPDATE M4R_WSM_DWIP_HDR_STAGING
2853: SET status_flag ='S', group_id = l_group_id
2854: WHERE msg_id = p_hdr_rec.msg_id
2855: AND status_flag ='R';*/
2856: END;

Line 3135: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,

3131: -- Procedure : INV_LOT_TXNS
3132: -- Purpose : This procedure processes the Inventory Transactions
3133:
3134: PROCEDURE INV_LOT_TXNS ( p_process_type IN VARCHAR2,
3135: p_hdr_rec IN M4R_WSM_DWIP_HDR_STAGING%ROWTYPE,
3136: p_qty_rec IN M4R_WSM_DWIP_LOT_QTY_STAGING%ROWTYPE,
3137: p_user_id IN NUMBER,
3138: p_org_id IN NUMBER,
3139: p_item_key IN VARCHAR2,

Line 3147: FROM M4R_WSM_DWIP_HDR_STAGING H

3143:
3144: CURSOR M4R_7B1_WSM_INV_MERGE_C1 (l_msg_id NUMBER,l_lot_number VARCHAR2,l_sub_inv VARCHAR2)
3145: IS
3146: SELECT *
3147: FROM M4R_WSM_DWIP_HDR_STAGING H
3148: WHERE h.msg_id = l_msg_id
3149: AND h.transaction_type = 'MERGE'
3150: AND h.lot_number = l_lot_number
3151: AND h.from_sub_inventory = l_sub_inv

Line 3162: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q

3158: IS
3159: SELECT h.hdr_id,h.transaction_date,h.operation_seq_num,h.lot_number,h.prev_lot_number,h.prev_lot_uom,h.prev_lot_qty,
3160: h.primary_item_code,h.primary_item_revision,h.starting_lot_item_code,h.alt_routing_designator,h.from_sub_inventory,
3161: h.to_sub_inventory,q.lot_uom,q.lot_qty,h.transfer_to_org,h.status_flag
3162: FROM M4R_WSM_DWIP_HDR_STAGING H ,M4R_WSM_DWIP_LOT_QTY_STAGING Q
3163: WHERE h.msg_id = l_msg_id
3164: AND h.transaction_type = 'SPLIT'
3165: AND h.prev_lot_number = l_lot_number
3166: AND h.from_sub_inventory = l_sub_inv

Line 3173: l_hdr_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;

3169: AND h.status_flag = 'V'
3170: AND q.hdr_id = h.hdr_id;
3171:
3172:
3173: l_hdr_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;
3174: l_qty_rec M4R_WSM_DWIP_LOT_QTY_STAGING%ROWTYPE;
3175: l_err_msg VARCHAR2(2000);
3176: l_err_code VARCHAR2(500);
3177: l_retcode VARCHAR2(2);

Line 3262: UPDATE M4R_WSM_DWIP_HDR_STAGING

3258:
3259: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3260: l_interface_err1 :=FND_MESSAGE.GET;
3261:
3262: UPDATE M4R_WSM_DWIP_HDR_STAGING
3263: SET status_flag ='E',
3264: error_message = l_interface_err1,
3265: group_id = l_trx_if_id
3266: WHERE msg_id = p_hdr_rec.msg_id

Line 3322: UPDATE M4R_WSM_DWIP_HDR_STAGING

3318:
3319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3320: l_interface_err :=FND_MESSAGE.GET;
3321:
3322: UPDATE M4R_WSM_DWIP_HDR_STAGING
3323: SET status_flag ='E',
3324: error_message = l_interface_err
3325: WHERE msg_id = p_hdr_rec.msg_id
3326: AND transaction_type = 'SPLIT'

Line 3364: UPDATE M4R_WSM_DWIP_HDR_STAGING

3360:
3361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3362: l_interface_err1 :=FND_MESSAGE.GET;
3363:
3364: UPDATE M4R_WSM_DWIP_HDR_STAGING
3365: SET status_flag ='E',
3366: error_message = l_interface_err1
3367: WHERE msg_id = p_hdr_rec.msg_id
3368: AND transaction_type = 'SPLIT'

Line 3428: UPDATE M4R_WSM_DWIP_HDR_STAGING

3424:
3425: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3426: l_interface_err1 :=FND_MESSAGE.GET;
3427:
3428: UPDATE M4R_WSM_DWIP_HDR_STAGING
3429: SET status_flag ='E',
3430: error_message = l_interface_err1
3431: WHERE msg_id = p_hdr_rec.msg_id
3432: AND transaction_type = 'MERGE'

Line 3484: UPDATE M4R_WSM_DWIP_HDR_STAGING

3480:
3481: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3482: l_interface_err :=FND_MESSAGE.GET;
3483:
3484: UPDATE M4R_WSM_DWIP_HDR_STAGING
3485: SET status_flag ='E',
3486: error_message = l_interface_err
3487: WHERE msg_id = p_hdr_rec.msg_id
3488: AND transaction_type = 'MERGE'

Line 3529: UPDATE M4R_WSM_DWIP_HDR_STAGING

3525:
3526: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3527: l_interface_err1 :=FND_MESSAGE.GET;
3528:
3529: UPDATE M4R_WSM_DWIP_HDR_STAGING
3530: SET status_flag ='E',
3531: error_message = l_interface_err1
3532: WHERE msg_id = p_hdr_rec.msg_id
3533: AND transaction_type = 'MERGE'

Line 3801: FROM M4R_WSM_DWIP_HDR_STAGING

3797: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.msg_id,p_hdr_rec.hdr_id,l_trx_if_id,p_process_type);
3798:
3799: SELECT custom_valid_status,error_message
3800: INTO l_custom_valid_pass,l_custom_valid_err_msg
3801: FROM M4R_WSM_DWIP_HDR_STAGING
3802: WHERE msg_id = p_hdr_rec.msg_id
3803: AND hdr_id = p_hdr_rec.hdr_id;
3804:
3805: IF (g_debug_level <= 1) THEN

Line 3879: UPDATE M4R_WSM_DWIP_HDR_STAGING

3875: END IF;
3876:
3877: l_err_msg := l_err_code||'.'||l_err_msg;
3878:
3879: UPDATE M4R_WSM_DWIP_HDR_STAGING
3880: SET status_flag = 'E',error_message = l_err_msg,group_id = l_parent_id --l_trx_hdr_id
3881: WHERE msg_id = p_hdr_rec.msg_id
3882: AND lot_number = p_hdr_rec.lot_number
3883: AND status_flag ='R';

Line 3906: UPDATE M4R_WSM_DWIP_HDR_STAGING

3902:
3903: EXCEPTION
3904: WHEN NO_DATA_FOUND THEN
3905:
3906: UPDATE M4R_WSM_DWIP_HDR_STAGING
3907: SET status_flag = 'S',error_message = NULL
3908: WHERE msg_id = p_hdr_rec.msg_id
3909: AND lot_number = p_hdr_rec.lot_number
3910: AND status_flag ='R';

Line 3927: UPDATE M4R_WSM_DWIP_HDR_STAGING

3923: IF (g_debug_level <= 1) THEN
3924: cln_debug_pub.Add('---- Updating the status_flag ------',5);
3925: END IF;
3926:
3927: UPDATE M4R_WSM_DWIP_HDR_STAGING
3928: SET status_flag = 'E',error_message = l_err_msg,group_id = l_trx_hdr_id
3929: WHERE msg_id = p_hdr_rec.msg_id
3930: AND lot_number = p_hdr_rec.lot_number
3931: AND status_flag ='R';

Line 4069: l_hdr_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;

4065:
4066:
4067: l_msg_id NUMBER;
4068: l_msg_staging_rec M4R_WSM_DWIP_MSG_STAGING%ROWTYPE;
4069: l_hdr_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;
4070: l_process_type VARCHAR2(20);
4071: l_get_notif_code VARCHAR2(20);
4072: l_hdr_id NUMBER;
4073: l_org_id NUMBER;

Line 4115: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for the valid record';

4111: IF (g_debug_level <= 1) THEN
4112: cln_debug_pub.Add('l_msg_id : ' || l_msg_id, 1);
4113: END IF;
4114:
4115: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for the valid record';
4116:
4117: BEGIN
4118:
4119: SELECT *

Line 4121: FROM M4R_WSM_DWIP_HDR_STAGING

4117: BEGIN
4118:
4119: SELECT *
4120: INTO l_hdr_rec
4121: FROM M4R_WSM_DWIP_HDR_STAGING
4122: WHERE MSG_ID = l_msg_id
4123: AND status_flag = 'V'
4124: AND ROWNUM = 1;
4125:

Line 4395: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';

4391: IF (g_debug_level <= 1) THEN
4392: cln_debug_pub.Add('l_msg_id : ' || l_msg_id, 1);
4393: END IF;
4394:
4395: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';
4396:
4397: UPDATE M4R_WSM_DWIP_HDR_STAGING
4398: SET status_flag = 'V'
4399: WHERE MSG_ID = l_msg_id;

Line 4397: UPDATE M4R_WSM_DWIP_HDR_STAGING

4393: END IF;
4394:
4395: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';
4396:
4397: UPDATE M4R_WSM_DWIP_HDR_STAGING
4398: SET status_flag = 'V'
4399: WHERE MSG_ID = l_msg_id;
4400:
4401: -- if the custom validation is done by the user, then the above update statement has to be removed

Line 4404: /*g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';

4400:
4401: -- if the custom validation is done by the user, then the above update statement has to be removed
4402: -- and the below code segment has to be uncommented
4403:
4404: /*g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';
4405:
4406: SELECT count(*)
4407: INTO l_count_valid_rows
4408: FROM M4R_WSM_DWIP_HDR_STAGING

Line 4408: FROM M4R_WSM_DWIP_HDR_STAGING

4404: /*g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for valid records';
4405:
4406: SELECT count(*)
4407: INTO l_count_valid_rows
4408: FROM M4R_WSM_DWIP_HDR_STAGING
4409: WHERE MSG_ID = l_msg_id
4410: AND status_flag = 'V';
4411:
4412: IF (g_debug_level <= 2) THEN

Line 4447: l_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;

4443: l_interface_status NUMBER;
4444: l_event_key NUMBER;
4445: l_get_notif_code VARCHAR2(20);
4446: l_waiting_rows NUMBER;
4447: l_rec M4R_WSM_DWIP_HDR_STAGING%ROWTYPE;
4448: l_update_cln_parameter_list wf_parameter_list_t;
4449:
4450:
4451: BEGIN

Line 4475: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for the waiting records';

4471: l_waiting_rows := 0 ;
4472:
4473: BEGIN
4474:
4475: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for the waiting records';
4476:
4477: SELECT *
4478: INTO l_rec
4479: FROM M4R_WSM_DWIP_HDR_STAGING

Line 4479: FROM M4R_WSM_DWIP_HDR_STAGING

4475: g_exception_tracking_msg := 'Querying M4R_WSM_DWIP_HDR_STAGING for the waiting records';
4476:
4477: SELECT *
4478: INTO l_rec
4479: FROM M4R_WSM_DWIP_HDR_STAGING
4480: WHERE msg_id = l_msg_id
4481: AND status_flag = 'R'
4482: AND rownum < 2;
4483:

Line 4529: UPDATE M4R_WSM_DWIP_HDR_STAGING

4525: IF (g_debug_level <= 1) THEN
4526: cln_debug_pub.Add('---- Updating the status_flag ------',5);
4527: END IF;
4528:
4529: UPDATE M4R_WSM_DWIP_HDR_STAGING
4530: SET status_flag = 'E',error_message = l_err_msg
4531: WHERE msg_id = l_msg_id
4532: AND hdr_id = l_rec.hdr_id;
4533:

Line 4565: UPDATE M4R_WSM_DWIP_HDR_STAGING

4561: IF (g_debug_level <= 1) THEN
4562: cln_debug_pub.Add('---- Updating the status_flag ------',1);
4563: END IF;
4564:
4565: UPDATE M4R_WSM_DWIP_HDR_STAGING
4566: SET status_flag = 'E',error_message = l_err_msg
4567: WHERE msg_id = l_msg_id
4568: AND hdr_id = l_rec.hdr_id;
4569:

Line 4580: UPDATE M4R_WSM_DWIP_HDR_STAGING

4576: l_msg_id);
4577:
4578: ELSE
4579:
4580: UPDATE M4R_WSM_DWIP_HDR_STAGING
4581: SET status_flag = 'S',error_message = NULL
4582: WHERE msg_id = l_msg_id
4583: AND hdr_id = l_rec.hdr_id;
4584: