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.MSC_REL_WF dependencies on MSC_UTIL

Line 94: msc_util.msc_debug(' Start of Program ');

90: WIP_DIS_MASS_RESCHEDULE,PURCHASE_REQ_MASS_LOAD,
91: EAM_DIS_MASS_RESCHEDULE);
92: BEGIN
93: retcode :=0;
94: msc_util.msc_debug('****** Start of Program ******');
95: -- launch wf for purchase order reschedule
96: OPEN po_res;
97: LOOP
98: FETCH po_res INTO v_transaction_id, v_instance_id;

Line 100: msc_util.msc_debug('start workflow to reschedule Purchase Order, transaction_id ='||v_transaction_id);

96: OPEN po_res;
97: LOOP
98: FETCH po_res INTO v_transaction_id, v_instance_id;
99: EXIT WHEN po_res%NOTFOUND;
100: msc_util.msc_debug('start workflow to reschedule Purchase Order, transaction_id ='||v_transaction_id);
101: start_reschedule_po_wf(arg_plan_id, v_transaction_id,
102: v_instance_id, PURCHASE_ORDER_RESCHEDULE);
103: END LOOP;
104: CLOSE po_res;

Line 111: msc_util.msc_debug('start workflow to reschedule Purchase Req, transaction_id='||v_transaction_id);

107: OPEN req_res;
108: LOOP
109: FETCH req_res INTO v_transaction_id, v_instance_id;
110: EXIT WHEN req_res%NOTFOUND;
111: msc_util.msc_debug('start workflow to reschedule Purchase Req, transaction_id='||v_transaction_id);
112: start_reschedule_po_wf(arg_plan_id, v_transaction_id,
113: v_instance_id, PURCHASE_REQ_RESCHEDULE);
114: END LOOP;
115: CLOSE req_res;

Line 126: msc_util.msc_debug('start workflow for batch update');

122: OPEN batch_cur; -- launch one workflow for each load type
123: LOOP
124: FETCH batch_cur INTO v_load_type;
125: EXIT WHEN batch_cur%NOTFOUND;
126: msc_util.msc_debug('start workflow for batch update');
127: start_release_batch_wf(arg_plan_id, arg_org_id, v_instance_id,
128: arg_owning_org_id, arg_owning_instance,v_dblink,
129: v_load_type, v_instance_code);
130: END LOOP;

Line 471: msc_util.msc_debug('supplier is '||l_supplier);

467: if p_load_type = PURCHASE_ORDER_RESCHEDULE then
468: OPEN supplier_c;
469: FETCH supplier_c INTO l_supplier;
470: CLOSE supplier_c;
471: msc_util.msc_debug('supplier is '||l_supplier);
472: end if;
473: -- l_buyer := 'MFG';
474: -- l_buyer := null;
475: -- l_supplier := 'MFG';

Line 477: msc_util.msc_debug('buyer is '||l_buyer);

473: -- l_buyer := 'MFG';
474: -- l_buyer := null;
475: -- l_supplier := 'MFG';
476: -- l_supplier :=null;
477: msc_util.msc_debug('buyer is '||l_buyer);
478: if (p_load_type = PURCHASE_ORDER_RESCHEDULE and
479: l_supplier is not null) or
480: (p_load_type = PURCHASE_REQ_RESCHEDULE and
481: l_buyer is not null) then

Line 523: msc_util.msc_debug('launch concurrent program in the source '||p_instance_code);

519: IN l_supplier,
520: IN p_query_id,
521: OUT p_request_id;
522: commit;
523: msc_util.msc_debug('launch concurrent program in the source '||p_instance_code);
524: msc_util.msc_debug('request_id ='||p_request_id);
525: resultout := 'COMPLETE:FOUND';
526:
527: else

Line 524: msc_util.msc_debug('request_id ='||p_request_id);

520: IN p_query_id,
521: OUT p_request_id;
522: commit;
523: msc_util.msc_debug('launch concurrent program in the source '||p_instance_code);
524: msc_util.msc_debug('request_id ='||p_request_id);
525: resultout := 'COMPLETE:FOUND';
526:
527: else
528:

Line 540: msc_util.msc_debug('notify planner no buyer/supplier found');

536: l_new_date,
537: l_qty;
538: CLOSE detail_attri;
539:
540: msc_util.msc_debug('notify planner no buyer/supplier found');
541: wf_engine.SetItemAttrText( itemtype => itemtype,
542: itemkey => itemkey,
543: aname => 'PLAN_NAME',
544: avalue => l_plan_name);

Line 668: msc_util.msc_debug('Error in delete activities:'|| to_char(sqlcode) || ':' || substr(sqlerrm,1,100));

664:
665:
666: EXCEPTION
667: when others then
668: msc_util.msc_debug('Error in delete activities:'|| to_char(sqlcode) || ':' || substr(sqlerrm,1,100));
669: return;
670: END DeleteActivities;
671:
672: Procedure reset_load_type (p_plan_id number, p_transaction_id number) IS

Line 1965: msc_util.msc_debug('insert temp table now');

1961: open apps_ver_cur;
1962: fetch apps_ver_cur into p_apps_ver;
1963: close apps_ver_cur;
1964:
1965: msc_util.msc_debug('insert temp table now');
1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);

Line 1966: msc_util.msc_debug('load type='||p_load_type);

1962: fetch apps_ver_cur into p_apps_ver;
1963: close apps_ver_cur;
1964:
1965: msc_util.msc_debug('insert temp table now');
1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);
1970: msc_util.msc_debug('owning instance id='||p_owning_instance);

Line 1967: msc_util.msc_debug('org id='||p_org_id);

1963: close apps_ver_cur;
1964:
1965: msc_util.msc_debug('insert temp table now');
1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);
1970: msc_util.msc_debug('owning instance id='||p_owning_instance);
1971:

Line 1968: msc_util.msc_debug('instance id='||p_instance_id);

1964:
1965: msc_util.msc_debug('insert temp table now');
1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);
1970: msc_util.msc_debug('owning instance id='||p_owning_instance);
1971:
1972: if p_load_type = WIP_DIS_MASS_LOAD then

Line 1969: msc_util.msc_debug('owning org id='||p_owning_org);

1965: msc_util.msc_debug('insert temp table now');
1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);
1970: msc_util.msc_debug('owning instance id='||p_owning_instance);
1971:
1972: if p_load_type = WIP_DIS_MASS_LOAD then
1973:

Line 1970: msc_util.msc_debug('owning instance id='||p_owning_instance);

1966: msc_util.msc_debug('load type='||p_load_type);
1967: msc_util.msc_debug('org id='||p_org_id);
1968: msc_util.msc_debug('instance id='||p_instance_id);
1969: msc_util.msc_debug('owning org id='||p_owning_org);
1970: msc_util.msc_debug('owning instance id='||p_owning_instance);
1971:
1972: if p_load_type = WIP_DIS_MASS_LOAD then
1973:
1974: p_count := msc_rel_plan_pub.load_wip_discrete_jobs(

Line 2055: msc_util.msc_debug('# of rows updated:'|| p_count);

2051: null,
2052: null);
2053: end if;
2054: if p_count >0 then
2055: msc_util.msc_debug('# of rows updated:'|| p_count);
2056: resultout := 'COMPLETE:FOUND';
2057: else
2058: msc_util.msc_debug('no rows are inserted');
2059: resultout := 'COMPLETE:NOT_FOUND';

Line 2058: msc_util.msc_debug('no rows are inserted');

2054: if p_count >0 then
2055: msc_util.msc_debug('# of rows updated:'|| p_count);
2056: resultout := 'COMPLETE:FOUND';
2057: else
2058: msc_util.msc_debug('no rows are inserted');
2059: resultout := 'COMPLETE:NOT_FOUND';
2060: end if;
2061: end if;
2062: if (funcmode = 'CANCEL') then

Line 2116: msc_util.msc_debug('start reschedule in instance '||p_instance_code);

2112: USING FND_GLOBAL.USER_NAME,
2113: FND_GLOBAL.RESP_NAME,
2114: FND_GLOBAL.APPLICATION_NAME;
2115:
2116: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2117: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,
2118: WIP_DIS_MASS_RESCHEDULE) then
2119:
2120: lv_sql_stmt:=

Line 2185: msc_util.msc_debug('request id is '||p_request_id

2181: WHERE sr_instance_id= p_instance;
2182:
2183: end if;
2184:
2185: msc_util.msc_debug('request id is '||p_request_id
2186: ||', in instance '||p_instance_code);
2187:
2188: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2189: itemkey => itemkey,