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.CSTPACWF dependencies on WF_ENGINE

Line 41: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT1');

37:
38: IF (X_ALT = 1) THEN
39: -- Inventory valuation
40:
41: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT1');
42: L_WORKFLOW_FUNC_FLAG := 1;
43:
44: ELSIF (X_ALT = 2) THEN
45: -- Account

Line 47: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT2');

43:
44: ELSIF (X_ALT = 2) THEN
45: -- Account
46:
47: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT2');
48: L_WORKFLOW_FUNC_FLAG := 1;
49:
50: ELSIF (X_ALT = 3) THEN
51: -- Overhead absorption

Line 53: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT3');

49:
50: ELSIF (X_ALT = 3) THEN
51: -- Overhead absorption
52:
53: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT3');
54: L_WORKFLOW_FUNC_FLAG := 1;
55:
56: ELSIF (X_ALT = 4) THEN
57: -- Resource absorption

Line 59: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT4');

55:
56: ELSIF (X_ALT = 4) THEN
57: -- Resource absorption
58:
59: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT4');
60: L_WORKFLOW_FUNC_FLAG := 1;
61:
62: ELSIF (X_ALT = 5) THEN
63: -- Receiving inspection

Line 65: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT5');

61:
62: ELSIF (X_ALT = 5) THEN
63: -- Receiving inspection
64:
65: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT5');
66: L_WORKFLOW_FUNC_FLAG := 1;
67:
68: ELSIF (X_ALT = 6) THEN
69: -- PPV or rate variance

Line 71: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT6');

67:
68: ELSIF (X_ALT = 6) THEN
69: -- PPV or rate variance
70:
71: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT6');
72: L_WORKFLOW_FUNC_FLAG := 1;
73:
74: ELSIF (X_ALT = 7) THEN
75: -- WIP valuation

Line 77: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT7');

73:
74: ELSIF (X_ALT = 7) THEN
75: -- WIP valuation
76:
77: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT7');
78: L_WORKFLOW_FUNC_FLAG := 1;
79:
80: ELSIF (X_ALT = 8) THEN
81: -- WIP variance

Line 83: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT8');

79:
80: ELSIF (X_ALT = 8) THEN
81: -- WIP variance
82:
83: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT8');
84: L_WORKFLOW_FUNC_FLAG := 1;
85:
86: ELSIF (X_ALT = 9) THEN
87: -- Inter-org payables

Line 89: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT9');

85:
86: ELSIF (X_ALT = 9) THEN
87: -- Inter-org payables
88:
89: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT9');
90: L_WORKFLOW_FUNC_FLAG := 1;
91:
92: ELSIF (X_ALT = 10) THEN
93: -- Inter-org receivables

Line 95: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT10');

91:
92: ELSIF (X_ALT = 10) THEN
93: -- Inter-org receivables
94:
95: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT10');
96: L_WORKFLOW_FUNC_FLAG := 1;
97:
98: ELSIF (X_ALT = 11) THEN
99: -- Inter-org transfer credit

Line 101: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT11');

97:
98: ELSIF (X_ALT = 11) THEN
99: -- Inter-org transfer credit
100:
101: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT11');
102: L_WORKFLOW_FUNC_FLAG := 1;
103:
104: ELSIF (X_ALT = 12) THEN
105: -- Inter-org freight charge

Line 107: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT12');

103:
104: ELSIF (X_ALT = 12) THEN
105: -- Inter-org freight charge
106:
107: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT12');
108: L_WORKFLOW_FUNC_FLAG := 1;
109:
110: ELSIF (X_ALT = 13) THEN
111: -- Average cost variance

Line 113: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT13');

109:
110: ELSIF (X_ALT = 13) THEN
111: -- Average cost variance
112:
113: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT13');
114: L_WORKFLOW_FUNC_FLAG := 1;
115:
116: ELSIF (X_ALT = 14) THEN
117: -- Intransit inventory

Line 119: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT14');

115:
116: ELSIF (X_ALT = 14) THEN
117: -- Intransit inventory
118:
119: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT14');
120: L_WORKFLOW_FUNC_FLAG := 1;
121:
122: ELSIF (X_ALT = 15) THEN
123: -- Encumbrance reversal

Line 125: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT15');

121:
122: ELSIF (X_ALT = 15) THEN
123: -- Encumbrance reversal
124:
125: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT15');
126: L_WORKFLOW_FUNC_FLAG := 1;
127:
128: ELSIF (X_ALT = 30) THEN
129: /* Added for Transfer Pricing Project */

Line 132: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT30');

128: ELSIF (X_ALT = 30) THEN
129: /* Added for Transfer Pricing Project */
130: -- Profit in inventory
131:
132: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT30');
133: L_WORKFLOW_FUNC_FLAG := 1;
134:
135: ELSIF (X_ALT = 16) THEN
136: -- Accrual

Line 138: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT16');

134:
135: ELSIF (X_ALT = 16) THEN
136: -- Accrual
137:
138: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT16');
139: L_WORKFLOW_FUNC_FLAG := 1;
140:
141: ELSIF (X_ALT = 31) THEN
142: -- Clearing Account

Line 144: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT31');

140:
141: ELSIF (X_ALT = 31) THEN
142: -- Clearing Account
143:
144: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT31');
145: L_WORKFLOW_FUNC_FLAG := 1;
146:
147: ELSIF (X_ALT = 32) THEN
148: -- Retroactive Price Adjustment

Line 150: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT32');

146:
147: ELSIF (X_ALT = 32) THEN
148: -- Retroactive Price Adjustment
149:
150: wf_engine.CreateProcess(L_ITEMTYPE, L_ITEMKEY, 'AVGALT32');
151: L_WORKFLOW_FUNC_FLAG := 1;
152:
153: END IF;
154:

Line 157: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

153: END IF;
154:
155: IF ( L_WORKFLOW_FUNC_FLAG = 1 ) THEN /* Bug 5513993 */
156:
157: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
158: itemkey => L_ITEMKEY,
159: aname => 'TXN_ID',
160: avalue => X_TXN_ID);
161:

Line 162: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

158: itemkey => L_ITEMKEY,
159: aname => 'TXN_ID',
160: avalue => X_TXN_ID);
161:
162: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
163:
164: itemkey => L_ITEMKEY,
165:
166: aname => 'TXN_TYPE_ID',

Line 169: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

165:
166: aname => 'TXN_TYPE_ID',
167: avalue => X_TXN_TYPE_ID);
168:
169: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
170:
171: itemkey => L_ITEMKEY,
172:
173: aname => 'TXN_ACT_ID',

Line 176: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

172:
173: aname => 'TXN_ACT_ID',
174: avalue => X_TXN_ACT_ID);
175:
176: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
177:
178: itemkey => L_ITEMKEY,
179:
180: aname => 'SRC_TYPE_ID',

Line 183: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

179:
180: aname => 'SRC_TYPE_ID',
181: avalue => X_TXN_SRC_TYPE_ID);
182:
183: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
184: itemkey => L_ITEMKEY,
185: aname => 'ITEM_ID',
186: avalue => X_ITEM_ID);
187:

Line 188: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

184: itemkey => L_ITEMKEY,
185: aname => 'ITEM_ID',
186: avalue => X_ITEM_ID);
187:
188: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
189:
190: itemkey => L_ITEMKEY,
191:
192: aname => 'CG_ID',

Line 195: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

191:
192: aname => 'CG_ID',
193: avalue => X_CG_ID);
194:
195: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
196:
197: itemkey => L_ITEMKEY,
198:
199: aname => 'ORG_ID',

Line 202: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

198:
199: aname => 'ORG_ID',
200: avalue => X_ORG_ID);
201:
202: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
203:
204: itemkey => L_ITEMKEY,
205:
206: aname => 'CE_ID',

Line 209: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,

205:
206: aname => 'CE_ID',
207: avalue => X_CE_ID);
208:
209: wf_engine.SetItemAttrNumber(itemtype => L_ITEMTYPE,
210:
211: itemkey => L_ITEMKEY,
212:
213: aname => 'RES_ID',

Line 216: wf_engine.StartProcess(L_ITEMTYPE, L_ITEMKEY);

212:
213: aname => 'RES_ID',
214: avalue => X_RES_ID);
215:
216: wf_engine.StartProcess(L_ITEMTYPE, L_ITEMKEY);
217:
218: L_ACCT_NUM := wf_engine.GetItemAttrNumber(itemtype => L_ITEMTYPE,
219:
220: itemkey => L_ITEMKEY,

Line 218: L_ACCT_NUM := wf_engine.GetItemAttrNumber(itemtype => L_ITEMTYPE,

214: avalue => X_RES_ID);
215:
216: wf_engine.StartProcess(L_ITEMTYPE, L_ITEMKEY);
217:
218: L_ACCT_NUM := wf_engine.GetItemAttrNumber(itemtype => L_ITEMTYPE,
219:
220: itemkey => L_ITEMKEY,
221:
222: aname => 'ACCT');

Line 225: X_ERR_NUM := wf_engine.GetItemAttrNumber(itemtype => L_ITEMTYPE,

221:
222: aname => 'ACCT');
223:
224:
225: X_ERR_NUM := wf_engine.GetItemAttrNumber(itemtype => L_ITEMTYPE,
226:
227: itemkey => L_ITEMKEY,
228:
229: aname => 'ERR_NUM');

Line 231: X_ERR_CODE := wf_engine.GetItemAttrText(itemtype => L_ITEMTYPE,

227: itemkey => L_ITEMKEY,
228:
229: aname => 'ERR_NUM');
230:
231: X_ERR_CODE := wf_engine.GetItemAttrText(itemtype => L_ITEMTYPE,
232:
233: itemkey => L_ITEMKEY,
234:
235: aname => 'ERR_CODE');

Line 237: X_ERR_MSG := wf_engine.GetItemAttrText(itemtype => L_ITEMTYPE,

233: itemkey => L_ITEMKEY,
234:
235: aname => 'ERR_CODE');
236:
237: X_ERR_MSG := wf_engine.GetItemAttrText(itemtype => L_ITEMTYPE,
238:
239: itemkey => L_ITEMKEY,
240:
241: aname => 'ERR_MSG');

Line 273: L_CE:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CE_ID');

269: IS
270: L_CE NUMBER;
271: BEGIN
272: IF (FUNCMODE = 'RUN') THEN
273: L_CE:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CE_ID');
274: if (L_CE = 1) then
275: result := 'COMPLETE:1';
276: elsif (L_CE = 2) then
277: result := 'COMPLETE:2';

Line 300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));
304: result := 'COMPLETE:FAILURE';

Line 301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

297: EXCEPTION
298: WHEN OTHERS THEN
299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));
304: result := 'COMPLETE:FAILURE';
305: RAISE;

Line 302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

298: WHEN OTHERS THEN
299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));
304: result := 'COMPLETE:FAILURE';
305: RAISE;
306: END; /* GET_AVG_CE */

Line 303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));

299: wf_core.context('CSTPACWF','GET_AVG_CE',itemtype,itemkey,TO_CHAR(actid),funcmode);
300: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
301: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
302: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
303: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_CE' || substrb(SQLERRM,1,150));
304: result := 'COMPLETE:FAILURE';
305: RAISE;
306: END; /* GET_AVG_CE */
307:

Line 327: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

323:
324: IF (FUNCMODE = 'RUN') THEN
325: result := 'COMPLETE:-1';
326:
327: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
328:
329: RETURN;
330: END IF;
331:

Line 342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

338: END IF;
339: EXCEPTION
340: WHEN OTHERS THEN
341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));
346: result := 'COMPLETE:FAILURE';

Line 343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

339: EXCEPTION
340: WHEN OTHERS THEN
341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));
346: result := 'COMPLETE:FAILURE';
347: RAISE;

Line 344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

340: WHEN OTHERS THEN
341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));
346: result := 'COMPLETE:FAILURE';
347: RAISE;
348: END; /* GET_DEF_ACC */

Line 345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));

341: wf_core.context('CSTPACWF','GET_DEF_ACC',itemtype,itemkey,TO_CHAR(actid),funcmode);
342: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
343: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
344: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
345: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_DEF_ACC' || substrb(SQLERRM,1,150));
346: result := 'COMPLETE:FAILURE';
347: RAISE;
348: END; /* GET_DEF_ACC */
349:

Line 372: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

368: L_CG_ID number;
369: BEGIN
370: IF (FUNCMODE = 'RUN') THEN
371:
372: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
373: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
374: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
375:
376:

Line 373: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');

369: BEGIN
370: IF (FUNCMODE = 'RUN') THEN
371:
372: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
373: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
374: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
375:
376:
377: SELECT nvl(mca.material_account,-1) into L_ACCOUNT

Line 374: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');

370: IF (FUNCMODE = 'RUN') THEN
371:
372: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
373: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
374: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
375:
376:
377: SELECT nvl(mca.material_account,-1) into L_ACCOUNT
378: FROM MTL_CATEGORY_ACCOUNTS mca,

Line 390: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);

386: AND mca.cost_group_id = L_CG_ID
387: AND mic.organization_id = L_ORG_ID
388: AND mic.inventory_item_id = L_ITEM_ID;
389:
390: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);
391:
392: result := 'COMPLETE:SUCCESS';
393: RETURN;
394: END IF;

Line 397: result := wf_engine.eng_completed;

393: RETURN;
394: END IF;
395:
396: IF (funcmode = 'CANCEL') THEN
397: result := wf_engine.eng_completed;
398: RETURN;
399:
400: ELSE
401:

Line 412: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

408: EXCEPTION
409:
410: WHEN NO_DATA_FOUND THEN
411: L_ACCOUNT := -1;
412: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
413: result := 'COMPLETE:SUCCESS';
414: RETURN;
415:
416:

Line 419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

415:
416:
417: WHEN OTHERS THEN
418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));
423: result := 'COMPLETE:FAILURE';

Line 420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

416:
417: WHEN OTHERS THEN
418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));
423: result := 'COMPLETE:FAILURE';
424: RAISE;

Line 421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

417: WHEN OTHERS THEN
418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));
423: result := 'COMPLETE:FAILURE';
424: RAISE;
425: END; /* GET_AVG_MTL_PLA */

Line 422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));

418: wf_core.context('CSTPACWF','GET_AVG_MTL_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
419: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
420: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
421: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
422: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MTL_PLA' || substrb(SQLERRM,1,150));
423: result := 'COMPLETE:FAILURE';
424: RAISE;
425: END; /* GET_AVG_MTL_PLA */
426:

Line 449: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

445: L_CG_ID number;
446: BEGIN
447: IF (FUNCMODE = 'RUN') THEN
448:
449: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
450: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
451: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
452:
453:

Line 450: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');

446: BEGIN
447: IF (FUNCMODE = 'RUN') THEN
448:
449: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
450: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
451: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
452:
453:
454: SELECT nvl(mca.material_overhead_account,-1) into L_ACCOUNT

Line 451: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');

447: IF (FUNCMODE = 'RUN') THEN
448:
449: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
450: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
451: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
452:
453:
454: SELECT nvl(mca.material_overhead_account,-1) into L_ACCOUNT
455: FROM MTL_CATEGORY_ACCOUNTS mca,

Line 467: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);

463: AND mca.cost_group_id = L_CG_ID
464: AND mic.organization_id = L_ORG_ID
465: AND mic.inventory_item_id = L_ITEM_ID;
466:
467: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);
468:
469: result := 'COMPLETE:SUCCESS';
470: RETURN;
471: END IF;

Line 474: result := wf_engine.eng_completed;

470: RETURN;
471: END IF;
472:
473: IF (funcmode = 'CANCEL') THEN
474: result := wf_engine.eng_completed;
475: RETURN;
476:
477: ELSE
478:

Line 489: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

485: EXCEPTION
486:
487: WHEN NO_DATA_FOUND THEN
488: L_ACCOUNT := -1;
489: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
490: result := 'COMPLETE:SUCCESS';
491: RETURN;
492:
493:

Line 496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

492:
493:
494: WHEN OTHERS THEN
495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));
500: result := 'COMPLETE:FAILURE';

Line 497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

493:
494: WHEN OTHERS THEN
495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));
500: result := 'COMPLETE:FAILURE';
501: RAISE;

Line 498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

494: WHEN OTHERS THEN
495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));
500: result := 'COMPLETE:FAILURE';
501: RAISE;
502: END; /* GET_AVG_MO_PLA */

Line 499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));

495: wf_core.context('CSTPACWF','GET_AVG_MO_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
496: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
497: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
498: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
499: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_MO_PLA' || substrb(SQLERRM,1,150));
500: result := 'COMPLETE:FAILURE';
501: RAISE;
502: END; /* GET_AVG_MO_PLA */
503:

Line 526: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

522: L_CG_ID number;
523: BEGIN
524: IF (FUNCMODE = 'RUN') THEN
525:
526: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
527: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
528: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
529:
530:

Line 527: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');

523: BEGIN
524: IF (FUNCMODE = 'RUN') THEN
525:
526: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
527: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
528: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
529:
530:
531: SELECT nvl(mca.resource_account,-1) into L_ACCOUNT

Line 528: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');

524: IF (FUNCMODE = 'RUN') THEN
525:
526: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
527: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
528: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
529:
530:
531: SELECT nvl(mca.resource_account,-1) into L_ACCOUNT
532: FROM MTL_CATEGORY_ACCOUNTS mca,

Line 544: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);

540: AND mca.cost_group_id = L_CG_ID
541: AND mic.organization_id = L_ORG_ID
542: AND mic.inventory_item_id = L_ITEM_ID;
543:
544: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);
545:
546: result := 'COMPLETE:SUCCESS';
547: RETURN;
548: END IF;

Line 551: result := wf_engine.eng_completed;

547: RETURN;
548: END IF;
549:
550: IF (funcmode = 'CANCEL') THEN
551: result := wf_engine.eng_completed;
552: RETURN;
553:
554: ELSE
555:

Line 566: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

562: EXCEPTION
563:
564: WHEN NO_DATA_FOUND THEN
565: L_ACCOUNT := -1;
566: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
567: result := 'COMPLETE:SUCCESS';
568: RETURN;
569:
570:

Line 573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

569:
570:
571: WHEN OTHERS THEN
572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));
577: result := 'COMPLETE:FAILURE';

Line 574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

570:
571: WHEN OTHERS THEN
572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));
577: result := 'COMPLETE:FAILURE';
578: RAISE;

Line 575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

571: WHEN OTHERS THEN
572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));
577: result := 'COMPLETE:FAILURE';
578: RAISE;
579: END; /* GET_AVG_RES_PLA */

Line 576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));

572: wf_core.context('CSTPACWF','GET_AVG_RES_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
573: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
574: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
575: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
576: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_RES_PLA' || substrb(SQLERRM,1,150));
577: result := 'COMPLETE:FAILURE';
578: RAISE;
579: END; /* GET_AVG_RES_PLA */
580:

Line 603: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

599: L_CG_ID number;
600: BEGIN
601: IF (FUNCMODE = 'RUN') THEN
602:
603: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
604: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
605: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
606:
607: SELECT nvl(mca.outside_processing_account,-1) into L_ACCOUNT

Line 604: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');

600: BEGIN
601: IF (FUNCMODE = 'RUN') THEN
602:
603: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
604: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
605: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
606:
607: SELECT nvl(mca.outside_processing_account,-1) into L_ACCOUNT
608: FROM MTL_CATEGORY_ACCOUNTS mca,

Line 605: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');

601: IF (FUNCMODE = 'RUN') THEN
602:
603: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
604: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
605: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
606:
607: SELECT nvl(mca.outside_processing_account,-1) into L_ACCOUNT
608: FROM MTL_CATEGORY_ACCOUNTS mca,
609: MTL_ITEM_CATEGORIES mic,

Line 620: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);

616: AND mca.cost_group_id = L_CG_ID
617: AND mic.organization_id = L_ORG_ID
618: AND mic.inventory_item_id = L_ITEM_ID;
619:
620: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);
621:
622: result := 'COMPLETE:SUCCESS';
623: RETURN;
624: END IF;

Line 627: result := wf_engine.eng_completed;

623: RETURN;
624: END IF;
625:
626: IF (funcmode = 'CANCEL') THEN
627: result := wf_engine.eng_completed;
628: RETURN;
629:
630: ELSE
631:

Line 642: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

638: EXCEPTION
639:
640: WHEN NO_DATA_FOUND THEN
641: L_ACCOUNT := -1;
642: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
643: result := 'COMPLETE:SUCCESS';
644: RETURN;
645:
646:

Line 649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

645:
646:
647: WHEN OTHERS THEN
648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));
653: result := 'COMPLETE:FAILURE';

Line 650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

646:
647: WHEN OTHERS THEN
648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));
653: result := 'COMPLETE:FAILURE';
654: RAISE;

Line 651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

647: WHEN OTHERS THEN
648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));
653: result := 'COMPLETE:FAILURE';
654: RAISE;
655: END; /* GET_AVG_OSP_PLA */

Line 652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));

648: wf_core.context('CSTPACWF','GET_AVG_OSP_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
649: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
650: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
651: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
652: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OSP_PLA' || substrb(SQLERRM,1,150));
653: result := 'COMPLETE:FAILURE';
654: RAISE;
655: END; /* GET_AVG_OSP_PLA */
656:

Line 679: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

675: L_CG_ID number;
676: BEGIN
677: IF (FUNCMODE = 'RUN') THEN
678:
679: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
680: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
681: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
682:
683:

Line 680: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');

676: BEGIN
677: IF (FUNCMODE = 'RUN') THEN
678:
679: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
680: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
681: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
682:
683:
684: SELECT nvl(mca.overhead_account,-1) into L_ACCOUNT

Line 681: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');

677: IF (FUNCMODE = 'RUN') THEN
678:
679: L_ORG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
680: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
681: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
682:
683:
684: SELECT nvl(mca.overhead_account,-1) into L_ACCOUNT
685: FROM MTL_CATEGORY_ACCOUNTS mca,

Line 697: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);

693: AND mca.cost_group_id = L_CG_ID
694: AND mic.organization_id = L_ORG_ID
695: AND mic.inventory_item_id = L_ITEM_ID;
696:
697: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',L_ACCOUNT);
698:
699: result := 'COMPLETE:SUCCESS';
700: RETURN;
701: END IF;

Line 704: result := wf_engine.eng_completed;

700: RETURN;
701: END IF;
702:
703: IF (funcmode = 'CANCEL') THEN
704: result := wf_engine.eng_completed;
705: RETURN;
706:
707: ELSE
708:

Line 719: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);

715: EXCEPTION
716:
717: WHEN NO_DATA_FOUND THEN
718: L_ACCOUNT := -1;
719: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',-1);
720: result := 'COMPLETE:SUCCESS';
721: RETURN;
722:
723:

Line 726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);

722:
723:
724: WHEN OTHERS THEN
725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));
730: result := 'COMPLETE:FAILURE';

Line 727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);

723:
724: WHEN OTHERS THEN
725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));
730: result := 'COMPLETE:FAILURE';
731: RAISE;

Line 728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));

724: WHEN OTHERS THEN
725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));
730: result := 'COMPLETE:FAILURE';
731: RAISE;
732: END; /* GET_AVG_OVH_PLA */

Line 729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));

725: wf_core.context('CSTPACWF','GET_AVG_OVH_PLA',itemtype,itemkey,TO_CHAR(actid),funcmode);
726: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ACCT',0);
727: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ERR_NUM',-1);
728: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_CODE',TO_CHAR(SQLCODE));
729: wf_engine.SetItemAttrText(itemtype,itemkey,'ERR_MSG','Error in CSTPACWF.GET_AVG_OVH_PLA' || substrb(SQLERRM,1,150));
730: result := 'COMPLETE:FAILURE';
731: RAISE;
732: END; /* GET_AVG_OVH_PLA */
733: