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_WF_ALLOC_ATP dependencies on MSC_SCH_WB

Line 27: msc_sch_wb.atp_debug('debug_wf: ' || 'Debug WF started'||' p_session_id '|| p_session_id || ' p_login_user '|| p_login_user );

23:
24: BEGIN
25:
26: IF PG_DEBUG in ('Y', 'C') THEN
27: msc_sch_wb.atp_debug('debug_wf: ' || 'Debug WF started'||' p_session_id '|| p_session_id || ' p_login_user '|| p_login_user );
28: END IF;
29:
30: select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
31: into DEBUG_LOC_SRC

Line 35: msc_sch_wb.atp_debug('debug_wf: ' || DEBUG_LOC_SRC );

31: into DEBUG_LOC_SRC
32: from v$parameter where name= 'utl_file_dir';
33:
34: IF PG_DEBUG in ('Y', 'C') THEN
35: msc_sch_wb.atp_debug('debug_wf: ' || DEBUG_LOC_SRC );
36: END IF;
37:
38: IF (PG_DEBUG_SRC = 'C') THEN
39: SELECT spid

Line 52: msc_sch_wb.atp_debug('debug_wf: ' || SPID_SRC );

48: END IF;
49:
50:
51: IF PG_DEBUG in ('Y', 'C') THEN
52: msc_sch_wb.atp_debug('debug_wf: ' || SPID_SRC );
53: END IF;
54:
55: --Create work_flow process
56:

Line 63: msc_sch_wb.atp_debug('debug_wf: ' || l_itemkey );

59: from mrp_atp_details_temp
60: where rownum = 1;
61:
62: IF PG_DEBUG in ('Y', 'C') THEN
63: msc_sch_wb.atp_debug('debug_wf: ' || l_itemkey );
64: END IF;
65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: msc_sch_wb.atp_debug('debug_wf: ' || 'CreateProcess' );

Line 67: msc_sch_wb.atp_debug('debug_wf: ' || 'CreateProcess' );

63: msc_sch_wb.atp_debug('debug_wf: ' || l_itemkey );
64: END IF;
65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: msc_sch_wb.atp_debug('debug_wf: ' || 'CreateProcess' );
68: END IF;
69: wf_engine.CreateProcess(
70: itemtype => l_itemtype,
71: itemkey => l_itemkey,

Line 77: msc_sch_wb.atp_debug('debug_wf: ' || 'Setting Param' );

73:
74: --setting parameters
75:
76: IF PG_DEBUG in ('Y', 'C') THEN
77: msc_sch_wb.atp_debug('debug_wf: ' || 'Setting Param' );
78: END IF;
79:
80: wf_engine.SetItemAttrNumber(
81: itemtype => l_itemtype,

Line 87: msc_sch_wb.atp_debug('debug_wf: p_session_id ' || p_session_id );

83: aname => 'SESSION_ID',
84: avalue => p_session_id);
85:
86: IF PG_DEBUG in ('Y', 'C') THEN
87: msc_sch_wb.atp_debug('debug_wf: p_session_id ' || p_session_id );
88: END IF;
89:
90: wf_engine.SetItemAttrText(
91: itemtype => l_itemtype,

Line 97: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_SRC ' || DEBUG_LOC_SRC );

93: aname => 'DEBUG_LOC_SRC',
94: avalue => DEBUG_LOC_SRC);
95:
96: IF PG_DEBUG in ('Y', 'C') THEN
97: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_SRC ' || DEBUG_LOC_SRC );
98: END IF;
99:
100: wf_engine.SetItemAttrNumber(
101: itemtype => l_itemtype,

Line 107: msc_sch_wb.atp_debug('debug_wf: SPID_SRC ' || SPID_SRC );

103: aname => 'SPID_SRC',
104: avalue => SPID_SRC);
105:
106: IF PG_DEBUG in ('Y', 'C') THEN
107: msc_sch_wb.atp_debug('debug_wf: SPID_SRC ' || SPID_SRC );
108: END IF;
109:
110: wf_engine.SetItemAttrText(
111: itemtype => l_itemtype,

Line 117: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_SRC ' || TRACE_LOC_SRC );

113: aname => 'TRACE_LOC_SRC',
114: avalue => TRACE_LOC_SRC);
115:
116: IF PG_DEBUG in ('Y', 'C') THEN
117: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_SRC ' || TRACE_LOC_SRC );
118: END IF;
119:
120: wf_engine.SetItemAttrText(
121: itemtype => l_itemtype,

Line 127: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_DES ' || p_session_loc_des );

123: aname => 'DEBUG_LOC_DES',
124: avalue => p_session_loc_des);
125:
126: IF PG_DEBUG in ('Y', 'C') THEN
127: msc_sch_wb.atp_debug('debug_wf: DEBUG_LOC_DES ' || p_session_loc_des );
128: END IF;
129:
130: wf_engine.SetItemAttrNumber(
131: itemtype => l_itemtype,

Line 137: msc_sch_wb.atp_debug('debug_wf: SPID_DES ' || p_spid_des );

133: aname => 'SPID_DES',
134: avalue => p_spid_des);
135:
136: IF PG_DEBUG in ('Y', 'C') THEN
137: msc_sch_wb.atp_debug('debug_wf: SPID_DES ' || p_spid_des );
138: END IF;
139:
140: wf_engine.SetItemAttrText(
141: itemtype => l_itemtype,

Line 147: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_DES ' || p_trace_loc_des );

143: aname => 'TRACE_LOC_DES',
144: avalue => p_trace_loc_des);
145:
146: IF PG_DEBUG in ('Y', 'C') THEN
147: msc_sch_wb.atp_debug('debug_wf: TRACE_LOC_DES ' || p_trace_loc_des );
148: END IF;
149:
150: wf_engine.SetItemAttrText(
151: itemtype => l_itemtype,

Line 157: msc_sch_wb.atp_debug('debug_wf: LOGIN_USER ' || p_login_user );

153: aname => 'LOGIN_USER',
154: avalue => p_login_user);
155:
156: IF PG_DEBUG in ('Y', 'C') THEN
157: msc_sch_wb.atp_debug('debug_wf: LOGIN_USER ' || p_login_user );
158: END IF;
159:
160: IF PG_DEBUG in ('Y', 'C') THEN
161: msc_sch_wb.atp_debug('debug_wf: ' || 'starting process' );

Line 161: msc_sch_wb.atp_debug('debug_wf: ' || 'starting process' );

157: msc_sch_wb.atp_debug('debug_wf: LOGIN_USER ' || p_login_user );
158: END IF;
159:
160: IF PG_DEBUG in ('Y', 'C') THEN
161: msc_sch_wb.atp_debug('debug_wf: ' || 'starting process' );
162: END IF;
163:
164: wf_engine.StartProcess(
165: itemtype => l_itemtype,

Line 169: msc_sch_wb.atp_debug('debug_wf: ' || 'Debug WF done' );

165: itemtype => l_itemtype,
166: itemkey => l_itemkey);
167:
168: IF PG_DEBUG in ('Y', 'C') THEN
169: msc_sch_wb.atp_debug('debug_wf: ' || 'Debug WF done' );
170: END IF;
171:
172: END DEBUG_WF;
173: --ATP Debug Workflow

Line 226: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'WF Profile:' || l_profile);

222: -- Check if the profile has been set for workflow to be installed
223: -- and activated.
224: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');
225: IF PG_DEBUG in ('Y', 'C') THEN
226: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'WF Profile:' || l_profile);
227: END IF;
228:
229: IF NVL(l_profile, 'N') = 'N' THEN
230: IF PG_DEBUG in ('Y', 'C') THEN

Line 231: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Allocated ATP Workflow Profile = No');

227: END IF;
228:
229: IF NVL(l_profile, 'N') = 'N' THEN
230: IF PG_DEBUG in ('Y', 'C') THEN
231: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || '***Allocated ATP Workflow Profile = No***');
232: END IF;
233: RETURN;
234: END IF;
235:

Line 242: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || p_itemkey);

238: itemkey => p_itemkey,
239: process => 'ALLOCATEDATPNOTIFY');
240:
241: IF PG_DEBUG in ('Y', 'C') THEN
242: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || p_itemkey);
243: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
244: END IF;
245:
246: wf_engine.SetItemAttrNumber(

Line 243: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));

239: process => 'ALLOCATEDATPNOTIFY');
240:
241: IF PG_DEBUG in ('Y', 'C') THEN
242: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || p_itemkey);
243: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
244: END IF;
245:
246: wf_engine.SetItemAttrNumber(
247: itemtype => l_itemtype,

Line 426: msc_sch_wb.atp_debug('Within_Allocation: ' || 'Inside Shortage:' || l_allocated_qty ||

422: itemkey => itemkey,
423: aname => 'REQUESTED_QTY');
424:
425: IF PG_DEBUG in ('Y', 'C') THEN
426: msc_sch_wb.atp_debug('Within_Allocation: ' || 'Inside Shortage:' || l_allocated_qty ||
427: ' : '||l_requested_qty);
428: END IF;
429:
430: if (NVL(l_allocated_qty, 0) >= NVL(l_requested_qty, 0)) then

Line 455: msc_sch_wb.atp_debug('Qty_Stolen: ' || 'Inside Stolen:' || l_stolen_qty);

451: itemkey => itemkey,
452: aname => 'STOLEN_QTY');
453:
454: IF PG_DEBUG in ('Y', 'C') THEN
455: msc_sch_wb.atp_debug('Qty_Stolen: ' || 'Inside Stolen:' || l_stolen_qty);
456: END IF;
457:
458: if NVL(l_stolen_qty, 0) > 0 then
459: resultout := 'COMPLETE:Y';

Line 489: msc_sch_wb.atp_debug('ATP_Satisfy: ' || 'Inside ATP Satisfy:' || l_request_date_qty);

485: itemkey => itemkey,
486: aname => 'REQUESTED_QTY');
487:
488: IF PG_DEBUG in ('Y', 'C') THEN
489: msc_sch_wb.atp_debug('ATP_Satisfy: ' || 'Inside ATP Satisfy:' || l_request_date_qty);
490: END IF;
491:
492: if (NVL(l_request_date_qty, 0) >= NVL(l_requested_qty, 0)) then
493: resultout := 'COMPLETE:Y';

Line 552: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'WF Profile:' || l_profile);

548: -- Check if the profile has been set for workflow to be installed
549: -- and activated.
550: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');
551: IF PG_DEBUG in ('Y', 'C') THEN
552: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'WF Profile:' || l_profile);
553: END IF;
554:
555: IF NVL(l_profile, 'N') = 'N' THEN
556: IF PG_DEBUG in ('Y', 'C') THEN

Line 557: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Allocated ATP Workflow Profile = No');

553: END IF;
554:
555: IF NVL(l_profile, 'N') = 'N' THEN
556: IF PG_DEBUG in ('Y', 'C') THEN
557: msc_sch_wb.atp_debug('start_mscatp_wf: ' || '***Allocated ATP Workflow Profile = No***');
558: END IF;
559: RETURN;
560: END IF;
561:

Line 568: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || p_itemkey);

564: itemkey => p_itemkey,
565: process => 'ATP_OVERRIDE_NOTIFY');
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || p_itemkey);
569: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
570: END IF;
571:
572: wf_engine.SetItemAttrText(

Line 569: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));

565: process => 'ATP_OVERRIDE_NOTIFY');
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || p_itemkey);
569: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'Starting wf:' || to_char(p_inventory_item_id));
570: END IF;
571:
572: wf_engine.SetItemAttrText(
573: itemtype => l_itemtype,