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 2216: msc_util.msc_debug('insert temp table now');

2212: open apps_ver_cur;
2213: fetch apps_ver_cur into p_apps_ver;
2214: close apps_ver_cur;
2215:
2216: msc_util.msc_debug('insert temp table now');
2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);

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

2213: fetch apps_ver_cur into p_apps_ver;
2214: close apps_ver_cur;
2215:
2216: msc_util.msc_debug('insert temp table now');
2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);
2221: msc_util.msc_debug('owning instance id='||p_owning_instance);

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

2214: close apps_ver_cur;
2215:
2216: msc_util.msc_debug('insert temp table now');
2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);
2221: msc_util.msc_debug('owning instance id='||p_owning_instance);
2222:

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

2215:
2216: msc_util.msc_debug('insert temp table now');
2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);
2221: msc_util.msc_debug('owning instance id='||p_owning_instance);
2222:
2223: if p_load_type = WIP_DIS_MASS_LOAD then

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

2216: msc_util.msc_debug('insert temp table now');
2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);
2221: msc_util.msc_debug('owning instance id='||p_owning_instance);
2222:
2223: if p_load_type = WIP_DIS_MASS_LOAD then
2224:

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

2217: msc_util.msc_debug('load type='||p_load_type);
2218: msc_util.msc_debug('org id='||p_org_id);
2219: msc_util.msc_debug('instance id='||p_instance_id);
2220: msc_util.msc_debug('owning org id='||p_owning_org);
2221: msc_util.msc_debug('owning instance id='||p_owning_instance);
2222:
2223: if p_load_type = WIP_DIS_MASS_LOAD then
2224:
2225: p_count := msc_rel_plan_pub.load_wip_discrete_jobs(

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

2302: null,
2303: null);
2304: end if;
2305: if p_count >0 then
2306: msc_util.msc_debug('# of rows updated:'|| p_count);
2307: resultout := 'COMPLETE:FOUND';
2308: else
2309: msc_util.msc_debug('no rows are inserted');
2310: resultout := 'COMPLETE:NOT_FOUND';

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

2305: if p_count >0 then
2306: msc_util.msc_debug('# of rows updated:'|| p_count);
2307: resultout := 'COMPLETE:FOUND';
2308: else
2309: msc_util.msc_debug('no rows are inserted');
2310: resultout := 'COMPLETE:NOT_FOUND';
2311: end if;
2312: end if;
2313: if (funcmode = 'CANCEL') then

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

2363: USING FND_GLOBAL.USER_NAME,
2364: FND_GLOBAL.RESP_NAME,
2365: FND_GLOBAL.APPLICATION_NAME;
2366:
2367: msc_util.msc_debug('start reschedule in instance '||p_instance_code);
2368: if p_load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,
2369: WIP_DIS_MASS_RESCHEDULE) then
2370:
2371: lv_sql_stmt:=

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

2432: WHERE sr_instance_id= p_instance;
2433:
2434: end if;
2435:
2436: msc_util.msc_debug('request id is '||p_request_id
2437: ||', in instance '||p_instance_code);
2438:
2439: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2440: itemkey => itemkey,