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 WF_ENGINE

Line 1013: g_tp_frm_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER4');

1009: cln_debug_pub.Add('p_actid : '|| p_actid, 2);
1010: cln_debug_pub.Add('p_funcmode : '|| p_funcmode, 2);
1011: END IF;
1012:
1013: g_tp_frm_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER4');
1014: IF (g_debug_level <= 1) THEN
1015: cln_debug_pub.Add('g_tp_frm_code : ' || g_tp_frm_code, 1);
1016: END IF;
1017:

Line 1018: g_intrl_cntrl_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER2');

1014: IF (g_debug_level <= 1) THEN
1015: cln_debug_pub.Add('g_tp_frm_code : ' || g_tp_frm_code, 1);
1016: END IF;
1017:
1018: g_intrl_cntrl_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER2');
1019: IF (g_debug_level <= 1) THEN
1020: cln_debug_pub.Add('g_intrl_cntrl_num : ' || g_intrl_cntrl_num, 1);
1021: END IF;
1022:

Line 1023: l_notif_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_CODE');

1019: IF (g_debug_level <= 1) THEN
1020: cln_debug_pub.Add('g_intrl_cntrl_num : ' || g_intrl_cntrl_num, 1);
1021: END IF;
1022:
1023: l_notif_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_CODE');
1024: IF (g_debug_level <= 1) THEN
1025: cln_debug_pub.Add('l_notif_code : ' || l_notif_code, 1);
1026: END IF;
1027:

Line 1028: l_notif_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_DESC');

1024: IF (g_debug_level <= 1) THEN
1025: cln_debug_pub.Add('l_notif_code : ' || l_notif_code, 1);
1026: END IF;
1027:
1028: l_notif_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_DESC');
1029: IF (g_debug_level <= 1) THEN
1030: cln_debug_pub.Add('l_notif_desc : ' || l_notif_desc, 1);
1031: END IF;
1032:

Line 1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

1381: NULL,
1382: decode(p_process_type,'JOB_UNDO',NULL,l_jump_flag));
1383:
1384:
1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');

Line 1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

1382: decode(p_process_type,'JOB_UNDO',NULL,l_jump_flag));
1383:
1384:
1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1390:

Line 1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);

1383:
1384:
1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1390:
1391:

Line 1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);

1384:
1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1390:
1391:
1392: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'T',NULL,NULL);

Line 1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');

1385: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1386: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1387: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1388: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
1389: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1390:
1391:
1392: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'T',NULL,NULL);
1393:

Line 1411: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1407: IF l_custom_valid_pass = 'FAIL' THEN
1408:
1409: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,NULL);
1410:
1411: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1412:
1413: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1414: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1415:

Line 1525: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1521: p_qty_rec.lot_qty,
1522: p_hdr_rec.hdr_id,
1523: p_hdr_rec.msg_id);
1524:
1525: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1526:
1527: ELSE
1528: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'S',NULL,l_group_id);
1529:

Line 1550: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1546: END IF;
1547:
1548: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,NULL);
1549:
1550: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1551:
1552: ADD_MSG_COLL_HIST ( l_interface_err ,
1553: p_hdr_rec.transaction_type,
1554: p_hdr_rec.lot_number,

Line 1580: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1576: END IF;
1577:
1578: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,NULL);
1579:
1580: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1581:
1582: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1583: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
1584:

Line 1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

1834: IF (g_debug_level <= 1) THEN
1835: cln_debug_pub.Add('-------- Values successfully inserted into WSM_LOT_JOB_INTERFACE --------',1);
1836: END IF;
1837:
1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);
1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');

Line 1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

1835: cln_debug_pub.Add('-------- Values successfully inserted into WSM_LOT_JOB_INTERFACE --------',1);
1836: END IF;
1837:
1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);
1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1843:

Line 1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);

1836: END IF;
1837:
1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);
1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1843:
1844: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'T',NULL,l_header_id);

Line 1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);

1837:
1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);
1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1843:
1844: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'T',NULL,l_header_id);
1845:

Line 1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');

1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
1840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
1841: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_header_id);
1842: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','CREATE_UPD');
1843:
1844: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'T',NULL,l_header_id);
1845:
1846: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.msg_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);

Line 1863: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1859: IF l_custom_valid_pass = 'FAIL' THEN
1860:
1861: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,l_group_id);
1862:
1863: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1864:
1865: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1866: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1867:

Line 1917: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1913: END IF;
1914:
1915: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,NULL);
1916:
1917: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1918:
1919: ADD_MSG_COLL_HIST ( l_interface_err ,
1920: p_hdr_rec.transaction_type,
1921: p_hdr_rec.lot_number,

Line 1955: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

1951: p_qty_rec.lot_qty,
1952: p_hdr_rec.hdr_id,
1953: p_hdr_rec.msg_id);
1954:
1955: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1956:
1957: x_resultout := 'FAILED';
1958:
1959: END JOB_CREATE_OR_STATUS;

Line 2654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

2650:
2651: END IF; -- p_process_type <> 'WIP_SPLIT'
2652:
2653:
2654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
2655: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
2656: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',l_result_qty);
2657: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
2658:

Line 2655: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

2651: END IF; -- p_process_type <> 'WIP_SPLIT'
2652:
2653:
2654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
2655: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
2656: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',l_result_qty);
2657: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
2658:
2659: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.hdr_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);

Line 2656: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',l_result_qty);

2652:
2653:
2654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
2655: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
2656: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',l_result_qty);
2657: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
2658:
2659: RAISE_CUSTOM_VALID_EVENT (p_hdr_rec.hdr_id,p_hdr_rec.hdr_id,l_group_id,p_process_type);
2660:

Line 2657: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);

2653:
2654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
2655: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
2656: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',l_result_qty);
2657: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_group_id);
2658:
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

Line 2681: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF1');

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:
2681: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF1');
2682:
2683: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
2684: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2685:

Line 2785: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

2781: cln_debug_pub.Add('ADD_MSG_COLL_HIST returns', 1);
2782: END IF;
2783:
2784:
2785: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
2786:
2787: IF (g_debug_level <= 1) THEN
2788: cln_debug_pub.Add('Item attribute NOTIF_CODE is set', 1);
2789: END IF;

Line 2840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

2836: p_qty_rec.lot_qty,
2837: p_hdr_rec.hdr_id,
2838: p_hdr_rec.msg_id);
2839:
2840: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
2841:
2842: EXCEPTION
2843: WHEN NO_DATA_FOUND THEN
2844:

Line 2879: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

2875: END IF;
2876:
2877: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_group_id);
2878:
2879: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
2880:
2881: ADD_MSG_COLL_HIST ( l_interface_err ,
2882: p_hdr_rec.transaction_type,
2883: p_hdr_rec.lot_number,

Line 2912: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

2908: p_qty_rec.lot_qty,
2909: p_hdr_rec.hdr_id,
2910: p_hdr_rec.msg_id);
2911:
2912: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
2913:
2914: x_resultout := 'FAILED';
2915:
2916: WHEN OTHERS THEN

Line 2942: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

2938: p_qty_rec.lot_qty,
2939: p_hdr_rec.hdr_id,
2940: p_hdr_rec.msg_id);
2941:
2942: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
2943:
2944: x_resultout := 'FAILED';
2945:
2946: END WIP_LOT_TXNS;

Line 3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);

3295: l_retcode,
3296: l_err_msg);
3297:
3298:
3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

Line 3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

3296: l_err_msg);
3297:
3298:
3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3304:

Line 3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);

3297:
3298:
3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3304:
3305: l_parent_id := l_trx_if_id;

Line 3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);

3298:
3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3304:
3305: l_parent_id := l_trx_if_id;
3306:

Line 3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

3299: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3300: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3301: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3302: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3303: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3304:
3305: l_parent_id := l_trx_if_id;
3306:
3307: FOR l_rec IN M4R_7B1_WSM_INV_SPLIT_C1(p_hdr_rec.msg_id,p_hdr_rec.prev_lot_number,p_hdr_rec.from_sub_inventory) LOOP

Line 3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

3459: NULL, -- WIP NAME
3460: l_retcode,
3461: l_err_msg);
3462:
3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);
3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

Line 3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);

3460: l_retcode,
3461: l_err_msg);
3462:
3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);
3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3468:

Line 3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);

3461: l_err_msg);
3462:
3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);
3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3468:
3469: FOR l_rec IN M4R_7B1_WSM_INV_MERGE_C1(p_hdr_rec.msg_id,p_hdr_rec.lot_number,p_hdr_rec.from_sub_inventory) LOOP

Line 3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);

3462:
3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);
3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3468:
3469: FOR l_rec IN M4R_7B1_WSM_INV_MERGE_C1(p_hdr_rec.msg_id,p_hdr_rec.lot_number,p_hdr_rec.from_sub_inventory) LOOP
3470:

Line 3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

3463: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3464: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.primary_item_code);
3465: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3466: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3467: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3468:
3469: FOR l_rec IN M4R_7B1_WSM_INV_MERGE_C1(p_hdr_rec.msg_id,p_hdr_rec.lot_number,p_hdr_rec.from_sub_inventory) LOOP
3470:
3471: IF l_rec.status_flag <> 'V' THEN

Line 3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);

3646: ELSE
3647: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3648: END IF;
3649:
3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

Line 3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

3647: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3648: END IF;
3649:
3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3655:

Line 3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);

3648: END IF;
3649:
3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3655:
3656:

Line 3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);

3649:
3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3655:
3656:
3657: ELSIF p_process_type = 'LOT_TRANSLATE' THEN -- INV TRANSLATE

Line 3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

3650: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.prev_lot_number);
3651: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3652: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_hdr_rec.prev_lot_qty);
3653: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3654: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3655:
3656:
3657: ELSIF p_process_type = 'LOT_TRANSLATE' THEN -- INV TRANSLATE
3658:

Line 3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

3731: ELSE
3732: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3733: END IF;
3734:
3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

Line 3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

3732: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3733: END IF;
3734:
3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3740:

Line 3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);

3733: END IF;
3734:
3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3740:
3741: ELSE -- INV TRANSFER

Line 3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);

3734:
3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3740:
3741: ELSE -- INV TRANSFER
3742:

Line 3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

3735: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3736: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3737: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3738: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_if_id);
3739: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3740:
3741: ELSE -- INV TRANSFER
3742:
3743: l_parent_id := l_trx_if_id;

Line 3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);

3784: ELSE
3785: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3786: END IF;
3787:
3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);
3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

Line 3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

3785: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_parent_id);
3786: END IF;
3787:
3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);
3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3793: END IF;

Line 3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);

3786: END IF;
3787:
3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);
3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3793: END IF;
3794:

Line 3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);

3787:
3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);
3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3793: END IF;
3794:
3795: IF l_retcode = 'S' THEN

Line 3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');

3788: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
3789: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);
3790: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_QTY',p_qty_rec.lot_qty);
3791: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRX_INTERFACE_ID',l_trx_hdr_id);
3792: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'TRANSACTION_TYPE','INV_LOT_TXN');
3793: END IF;
3794:
3795: IF l_retcode = 'S' THEN
3796:

Line 3816: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

3812: IF l_custom_valid_pass = 'FAIL' THEN
3813:
3814: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,l_parent_id);
3815:
3816: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3817:
3818: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
3819: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3820:

Line 3901: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

3897: p_qty_rec.lot_qty,
3898: p_hdr_rec.hdr_id,
3899: p_hdr_rec.msg_id);
3900:
3901: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3902:
3903: EXCEPTION
3904: WHEN NO_DATA_FOUND THEN
3905:

Line 3945: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

3941: p_qty_rec.lot_qty,
3942: p_hdr_rec.hdr_id,
3943: p_hdr_rec.msg_id);
3944:
3945: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3946:
3947: x_resultout := 'FAILED';
3948: END;
3949: END IF; --l_custom_valid_pass = 'FAIL'

Line 3953: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

3949: END IF; --l_custom_valid_pass = 'FAIL'
3950: ELSE
3951: x_resultout := 'FAILED';
3952:
3953: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3954:
3955: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3956: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3957: l_err_msg := FND_MESSAGE.GET;

Line 3985: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

3981: END IF;
3982:
3983: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,NULL);
3984:
3985: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3986:
3987: ADD_MSG_COLL_HIST ( l_interface_err ,
3988: p_hdr_rec.transaction_type,
3989: p_hdr_rec.lot_number,

Line 4018: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

4014: p_qty_rec.lot_qty,
4015: p_hdr_rec.hdr_id,
4016: p_hdr_rec.msg_id);
4017:
4018: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
4019:
4020: x_resultout := 'FAILED';
4021:
4022: WHEN OTHERS THEN

Line 4037: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');

4033: END IF;
4034:
4035: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_trx_hdr_id);
4036:
4037: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
4038:
4039: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4040: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
4041: l_err_msg := FND_MESSAGE.GET;

Line 4110: l_msg_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER2');

4106: IF p_funcmode <> 'RUN' THEN
4107: RETURN;
4108: END IF;
4109:
4110: l_msg_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PARAMETER2');
4111: IF (g_debug_level <= 1) THEN
4112: cln_debug_pub.Add('l_msg_id : ' || l_msg_id, 1);
4113: END IF;
4114:

Line 4161: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'HEADER_ID',l_hdr_rec.hdr_id);

4157: IF (g_debug_level <= 1) THEN
4158: cln_debug_pub.Add('l_user_id : ' || l_user_id, 1);
4159: END IF;
4160:
4161: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'HEADER_ID',l_hdr_rec.hdr_id);
4162:
4163: BEGIN
4164:
4165: g_exception_tracking_msg := 'Querying ORG_ORGANIZATION_DEFINITIONS for l_org_id';

Line 4184: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','INV_LOT_TXN');

4180: IF (l_hdr_rec.transaction_type = 'CONSUME') THEN
4181:
4182: l_process_type := 'MTL_CONSUME';
4183:
4184: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','INV_LOT_TXN');
4185:
4186: INV_LOT_TXNS( l_process_type,
4187: l_hdr_rec,
4188: NULL,

Line 4221: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','SCRAP_COMP_UNDO');

4217: l_process_type= 'JOB_COMPLETION' OR
4218: l_process_type= 'JOB_UNDO' OR
4219: l_process_type= 'JOB_MOVE' THEN
4220:
4221: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','SCRAP_COMP_UNDO');
4222:
4223: JOB_SCRAP_COMPLETE_UNDO ( l_process_type,
4224: l_hdr_rec,
4225: l_qty_rec,

Line 4234: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','CREATE_UPD');

4230:
4231: ELSIF l_process_type= 'JOB_CREATION' OR
4232: l_process_type= 'STATUS_UPDATE' THEN
4233:
4234: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','CREATE_UPD');
4235:
4236: JOB_CREATE_OR_STATUS(l_process_type,
4237: l_hdr_rec,
4238: l_qty_rec,

Line 4263: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','INV_LOT_TXN');

4259: (l_process_type= 'LOT_TRANSFER' ) OR --(Lot Update/Change Lot Number,Lot transfer)
4260: (l_process_type= 'INV_MERGE') OR
4261: (l_process_type= 'INV_SPLIT')) THEN
4262:
4263: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRANSACTION_TYPE','INV_LOT_TXN');
4264:
4265: INV_LOT_TXNS(l_process_type,
4266: l_hdr_rec,
4267: l_qty_rec,

Line 4293: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');

4289:
4290:
4291: UPDATE_STATUS_FLAG(l_hdr_rec.msg_id,l_hdr_rec.hdr_id,'I',l_coll_hist_msg,NULL);
4292:
4293: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');
4294:
4295: x_resultout := 'FAILED';
4296:
4297: --EXIT;

Line 4334: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');

4330: l_hdr_rec.msg_id);
4331:
4332: UPDATE_STATUS_FLAG(l_hdr_rec.msg_id,l_hdr_rec.hdr_id,'I',l_coll_hist_msg,NULL);
4333:
4334: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');
4335:
4336: x_resultout := 'FAILED';
4337:
4338: WHEN OTHERS THEN

Line 4366: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');

4362: l_hdr_rec.msg_id);
4363:
4364: UPDATE_STATUS_FLAG(l_hdr_rec.msg_id,l_hdr_rec.hdr_id,'I',l_coll_hist_msg,NULL);
4365:
4366: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');
4367:
4368: END PROCESS_STAGING;
4369:
4370:

Line 4390: l_msg_id := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'PARAMETER2');

4386: cln_debug_pub.Add('funcmode : ' || p_funcmode, 2);
4387: cln_debug_pub.Add('resultout : ' || x_resultout, 2);
4388: END IF;
4389:
4390: l_msg_id := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'PARAMETER2');
4391: IF (g_debug_level <= 1) THEN
4392: cln_debug_pub.Add('l_msg_id : ' || l_msg_id, 1);
4393: END IF;
4394:

Line 4422: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF1');

4418:
4419: EXCEPTION
4420: WHEN NO_DATA_FOUND THEN
4421:
4422: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF1');
4423:
4424: x_resultout := 'NO_VALID_ROWS';
4425:
4426: IF (g_debug_level <= 1) THEN

Line 4465: l_msg_id := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'PARAMETER2');

4461: IF p_funcmode <> 'RUN' THEN
4462: RETURN;
4463: END IF;
4464:
4465: l_msg_id := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'PARAMETER2');
4466: IF (g_debug_level <= 1) THEN
4467: cln_debug_pub.Add('l_msg_id : ' || l_msg_id, 1);
4468: END IF;
4469:

Line 4547: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');

4543: NULL,
4544: l_rec.hdr_id,
4545: l_msg_id);
4546:
4547: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');
4548:
4549: END;
4550:
4551: IF l_exception_flag <> 'Y' THEN

Line 4559: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');

4555: x_resultout := 'CONTINUE';
4556:
4557: ELSIF l_interface_status =3 THEN -- 'Error'
4558:
4559: wf_engine.SetItemAttrText('M4R7B1OI',p_itemkey,'NOTIF_CODE','7B1_NOTIF2');
4560:
4561: IF (g_debug_level <= 1) THEN
4562: cln_debug_pub.Add('---- Updating the status_flag ------',1);
4563: END IF;

Line 4594: l_get_notif_code := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE');

4590: x_resultout := 'CONTINUE';
4591:
4592: ELSE -- l_waiting_rows = 1
4593:
4594: l_get_notif_code := wf_engine.GetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE');
4595: IF (g_debug_level <= 1) THEN
4596: cln_debug_pub.Add('l_get_notif_code : ' || l_get_notif_code, 1);
4597: END IF;
4598:

Line 4601: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF3');

4597: END IF;
4598:
4599: IF l_get_notif_code IS NULL THEN -- no err in the trx processing
4600:
4601: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF3');
4602:
4603: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_SUCCESS');
4604: l_err_msg := FND_MESSAGE.GET;
4605:

Line 4606: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);

4602:
4603: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_SUCCESS');
4604: l_err_msg := FND_MESSAGE.GET;
4605:
4606: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4607:
4608: l_update_cln_parameter_list := wf_parameter_list_t();
4609:
4610: WF_EVENT.AddParameterToList('COLLABORATION_POINT','APPS',l_update_cln_parameter_list);

Line 4620: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);

4616:
4617: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_FAILED');
4618: l_err_msg := FND_MESSAGE.GET;
4619:
4620: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4621:
4622: l_update_cln_parameter_list := wf_parameter_list_t();
4623:
4624: