DBA Data[Home] [Help]

APPS.RLM_WF_SV dependencies on WF_ENGINE

Line 78: wf_engine.AbortProcess(itemtype => v_ItemType,

74: IF (l_debug <> -1) THEN
75: rlm_core_sv.dlog(C_DEBUG,'Aborting old processes');
76: END IF;
77: --
78: wf_engine.AbortProcess(itemtype => v_ItemType,
79: itemkey => v_ItemKey);
80: --
81: IF (l_debug <> -1) THEN
82: rlm_core_sv.dlog(C_DEBUG,'After abort bad process');

Line 107: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);

103: IF (l_debug <> -1) THEN
104: rlm_core_sv.dlog(C_DEBUG,'After Purge for Item key ',p_Header_Id);
105: END IF;
106: --
107: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);
108:
109: -- Set various Header Attributes
110:
111: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,v_ScheduleNum);

Line 111: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,v_ScheduleNum);

107: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);
108:
109: -- Set various Header Attributes
110:
111: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,v_ScheduleNum);
112: --
113: wf_engine.SetItemAttrNumber( v_ItemType,
114: v_ItemKey,
115: 'USER_ID',

Line 113: wf_engine.SetItemAttrNumber( v_ItemType,

109: -- Set various Header Attributes
110:
111: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,v_ScheduleNum);
112: --
113: wf_engine.SetItemAttrNumber( v_ItemType,
114: v_ItemKey,
115: 'USER_ID',
116: FND_GLOBAL.USER_ID);
117:

Line 118: wf_engine.SetItemAttrNumber( v_ItemType,

114: v_ItemKey,
115: 'USER_ID',
116: FND_GLOBAL.USER_ID);
117:
118: wf_engine.SetItemAttrNumber( v_ItemType,
119: v_ItemKey,
120: 'APPLICATION_ID',
121: FND_GLOBAL.RESP_APPL_ID);
122:

Line 123: wf_engine.SetItemAttrNumber( v_ItemType,

119: v_ItemKey,
120: 'APPLICATION_ID',
121: FND_GLOBAL.RESP_APPL_ID);
122:
123: wf_engine.SetItemAttrNumber( v_ItemType,
124: v_ItemKey,
125: 'REQUEST_ID',
126: FND_GLOBAL.CONC_REQUEST_ID);
127:

Line 128: wf_engine.SetItemAttrNumber( v_ItemType,

124: v_ItemKey,
125: 'REQUEST_ID',
126: FND_GLOBAL.CONC_REQUEST_ID);
127:
128: wf_engine.SetItemAttrNumber( v_ItemType,
129: v_ItemKey,
130: 'RESPONSIBILITY_ID',
131: FND_GLOBAL.RESP_ID);
132:

Line 133: wf_engine.SetItemAttrNumber( v_ItemType,

129: v_ItemKey,
130: 'RESPONSIBILITY_ID',
131: FND_GLOBAL.RESP_ID);
132:
133: wf_engine.SetItemAttrNumber( v_ItemType,
134: v_ItemKey,
135: 'ORG_ID',
136: v_org_id);
137:

Line 138: wf_engine.SetItemAttrNumber( v_ItemType,

134: v_ItemKey,
135: 'ORG_ID',
136: v_org_id);
137:
138: wf_engine.SetItemAttrNumber( v_ItemType,
139: v_ItemKey,
140: 'HEADER_ID',
141: p_Header_Id);
142:

Line 143: wf_engine.SetItemAttrText( v_ItemType,

139: v_ItemKey,
140: 'HEADER_ID',
141: p_Header_Id);
142:
143: wf_engine.SetItemAttrText( v_ItemType,
144: v_ItemKey,
145: 'SCHEDULE_NUMBER',
146: v_ScheduleNum);
147:

Line 148: wf_engine.SetItemAttrText( v_ItemType,

144: v_ItemKey,
145: 'SCHEDULE_NUMBER',
146: v_ScheduleNum);
147:
148: wf_engine.SetItemAttrText( v_ItemType,
149: v_ItemKey,
150: 'CUSTOMER_NAME',
151: v_Customer);
152:

Line 156: wf_engine.SetItemAttrText( v_ItemType,

152:
153: -- Bug#: 3053299 - Setting the tokens for From User, To User and
154: -- Schedule Generation Date
155: --
156: wf_engine.SetItemAttrText( v_ItemType,
157: v_ItemKey,
158: 'FROM_USER',
159: Notification_FromUser(FND_GLOBAL.RESP_ID,
160: FND_GLOBAL.RESP_APPL_ID));

Line 162: wf_engine.SetItemAttrText( v_ItemType,

158: 'FROM_USER',
159: Notification_FromUser(FND_GLOBAL.RESP_ID,
160: FND_GLOBAL.RESP_APPL_ID));
161:
162: wf_engine.SetItemAttrText( v_ItemType,
163: v_ItemKey,
164: 'TO_USER',
165: Notification_ToUser(FND_GLOBAL.USER_ID));
166:

Line 167: wf_engine.SetItemAttrText( v_ItemType,

163: v_ItemKey,
164: 'TO_USER',
165: Notification_ToUser(FND_GLOBAL.USER_ID));
166:
167: wf_engine.SetItemAttrText( v_ItemType,
168: v_ItemKey,
169: 'SCHED_GEN_DATE',
170: v_ScheduleGenDate);
171:

Line 179: wf_engine.StartProcess(v_ItemType, v_ItemKey);

175: END IF;
176: --
177: SELECT hsecs INTO v_start_time from v$timer;
178:
179: wf_engine.StartProcess(v_ItemType, v_ItemKey);
180: --
181: IF (l_debug <> -1) THEN
182: rlm_core_sv.dlog(C_DEBUG,'After Start Process ');
183: END IF;

Line 185: v_retcode := wf_engine.GetItemAttrNumber(v_ItemType,v_ItemKey,'ERRORS_EXIST');

181: IF (l_debug <> -1) THEN
182: rlm_core_sv.dlog(C_DEBUG,'After Start Process ');
183: END IF;
184: --
185: v_retcode := wf_engine.GetItemAttrNumber(v_ItemType,v_ItemKey,'ERRORS_EXIST');
186: --
187: IF (l_debug <> -1) THEN
188: rlm_core_sv.dlog(C_DEBUG,' Errors Status: ', v_retcode);
189: END IF;

Line 203: wf_engine.AbortProcess(itemtype => v_ItemType,

199: IF (l_debug <> -1) THEN
200: rlm_core_sv.dlog(C_DEBUG,'Aborting old processes');
201: END IF;
202: --
203: wf_engine.AbortProcess(itemtype => v_ItemType,
204: itemkey => v_ItemKeyNew);
205: --
206: IF (l_debug <> -1) THEN
207: rlm_core_sv.dlog(C_DEBUG,'after abort bad process');

Line 232: wf_engine.CreateProcess(v_ItemType, v_ItemKeyNew, 'RLMEND');

228: IF (l_debug <> -1) THEN
229: rlm_core_sv.dlog(C_DEBUG,'Creating End Process ');
230: END IF;
231: --
232: wf_engine.CreateProcess(v_ItemType, v_ItemKeyNew, 'RLMEND');
233: --
234: wf_engine.SetItemParent(v_ItemType,v_ItemKeyNew,v_ItemType,
235: to_char(p_Header_Id), to_char(p_Header_Id));
236: --

Line 234: wf_engine.SetItemParent(v_ItemType,v_ItemKeyNew,v_ItemType,

230: END IF;
231: --
232: wf_engine.CreateProcess(v_ItemType, v_ItemKeyNew, 'RLMEND');
233: --
234: wf_engine.SetItemParent(v_ItemType,v_ItemKeyNew,v_ItemType,
235: to_char(p_Header_Id), to_char(p_Header_Id));
236: --
237: wf_engine.SetItemUserKey(v_ItemType, v_ItemKeyNew,v_ScheduleNum);
238: --

Line 237: wf_engine.SetItemUserKey(v_ItemType, v_ItemKeyNew,v_ScheduleNum);

233: --
234: wf_engine.SetItemParent(v_ItemType,v_ItemKeyNew,v_ItemType,
235: to_char(p_Header_Id), to_char(p_Header_Id));
236: --
237: wf_engine.SetItemUserKey(v_ItemType, v_ItemKeyNew,v_ScheduleNum);
238: --
239: IF (l_debug <> -1) THEN
240: rlm_core_sv.dlog(C_DEBUG,'Setting attributes End Process ');
241: END IF;

Line 243: wf_engine.SetItemAttrNumber( v_ItemType,

239: IF (l_debug <> -1) THEN
240: rlm_core_sv.dlog(C_DEBUG,'Setting attributes End Process ');
241: END IF;
242: --
243: wf_engine.SetItemAttrNumber( v_ItemType,
244: v_ItemKeyNew,
245: 'USER_ID',
246: FND_GLOBAL.USER_ID);
247:

Line 248: wf_engine.SetItemAttrNumber( v_ItemType,

244: v_ItemKeyNew,
245: 'USER_ID',
246: FND_GLOBAL.USER_ID);
247:
248: wf_engine.SetItemAttrNumber( v_ItemType,
249: v_ItemKeyNew,
250: 'APPLICATION_ID',
251: FND_GLOBAL.RESP_APPL_ID);
252:

Line 253: wf_engine.SetItemAttrNumber( v_ItemType,

249: v_ItemKeyNew,
250: 'APPLICATION_ID',
251: FND_GLOBAL.RESP_APPL_ID);
252:
253: wf_engine.SetItemAttrNumber( v_ItemType,
254: v_ItemKeyNew,
255: 'REQUEST_ID',
256: FND_GLOBAL.CONC_REQUEST_ID);
257:

Line 258: wf_engine.SetItemAttrNumber( v_ItemType,

254: v_ItemKeyNew,
255: 'REQUEST_ID',
256: FND_GLOBAL.CONC_REQUEST_ID);
257:
258: wf_engine.SetItemAttrNumber( v_ItemType,
259: v_ItemKeyNew,
260: 'RESPONSIBILITY_ID',
261: FND_GLOBAL.RESP_ID);
262:

Line 263: wf_engine.SetItemAttrNumber( v_ItemType,

259: v_ItemKeyNew,
260: 'RESPONSIBILITY_ID',
261: FND_GLOBAL.RESP_ID);
262:
263: wf_engine.SetItemAttrNumber( v_ItemType,
264: v_ItemKeyNew,
265: 'ORG_ID',
266: v_org_id);
267:

Line 268: wf_engine.SetItemAttrNumber( v_ItemType,

264: v_ItemKeyNew,
265: 'ORG_ID',
266: v_org_id);
267:
268: wf_engine.SetItemAttrNumber( v_ItemType,
269: v_ItemKeyNew,
270: 'HEADER_ID',
271: p_Header_Id);
272:

Line 273: wf_engine.SetItemAttrText( v_ItemType,

269: v_ItemKeyNew,
270: 'HEADER_ID',
271: p_Header_Id);
272:
273: wf_engine.SetItemAttrText( v_ItemType,
274: v_ItemKeyNew,
275: 'SCHEDULE_NUMBER',
276: v_ScheduleNum);
277:

Line 278: wf_engine.SetItemAttrText( v_ItemType,

274: v_ItemKeyNew,
275: 'SCHEDULE_NUMBER',
276: v_ScheduleNum);
277:
278: wf_engine.SetItemAttrText( v_ItemType,
279: v_ItemKeyNew,
280: 'CUSTOMER_NAME',
281: v_Customer);
282:

Line 287: wf_engine.SetItemAttrText( v_ItemType,

283: -- Bug#: 3053299 - Setting the tokens for From User, To User
284: -- and Schedule Generation Date
285:
286:
287: wf_engine.SetItemAttrText( v_ItemType,
288: v_ItemKeyNew,
289: 'FROM_USER',
290: Notification_FromUser(FND_GLOBAL.RESP_ID,
291: FND_GLOBAL.RESP_APPL_ID));

Line 294: wf_engine.SetItemAttrText( v_ItemType,

290: Notification_FromUser(FND_GLOBAL.RESP_ID,
291: FND_GLOBAL.RESP_APPL_ID));
292:
293:
294: wf_engine.SetItemAttrText( v_ItemType,
295: v_ItemKeyNew,
296: 'TO_USER',
297: Notification_ToUser(FND_GLOBAL.USER_ID));
298:

Line 299: wf_engine.SetItemAttrText( v_ItemType,

295: v_ItemKeyNew,
296: 'TO_USER',
297: Notification_ToUser(FND_GLOBAL.USER_ID));
298:
299: wf_engine.SetItemAttrText( v_ItemType,
300: v_ItemKeyNew,
301: 'SCHED_GEN_DATE',
302: v_ScheduleGenDate);
303:

Line 309: wf_engine.StartProcess(v_ItemType, v_ItemKeyNew);

305: IF (l_debug <> -1) THEN
306: rlm_core_sv.dlog(C_DEBUG,'Start EndProcess ');
307: END IF;
308: --
309: wf_engine.StartProcess(v_ItemType, v_ItemKeyNew);
310:
311: -- Set various Header Attributes
312: /*
313: -- Decided to return Sucess even if errors/warnings generated since process itself

Line 372: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

368: END IF;
369:
370: IF (FUNCMODE = 'RUN') THEN
371: -- Executable Statements
372: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
373: --
374: IF (l_debug <> -1) THEN
375: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
376: rlm_core_sv.dlog(C_DEBUG,' Before Validate');

Line 582: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

578: END IF;
579: --
580: IF (FUNCMODE = 'RUN') THEN
581: -- Executable Statements
582: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
583: --
584: IF (l_debug <> -1) THEN
585: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
586: END IF;

Line 745: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

741: END IF;
742:
743: IF (FUNCMODE = 'RUN') THEN
744: -- Executable Statements
745: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
746: --
747: IF (l_debug <> -1) THEN
748: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
749: rlm_core_sv.dlog(C_DEBUG,' ManageForecast');

Line 910: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

906: END IF;
907: --
908: IF (FUNCMODE = 'RUN') THEN
909: -- Executable Statements
910: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
911: --
912: IF (l_debug <> -1) THEN
913: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
914: END IF;

Line 1094: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

1090: END IF;
1091: --
1092: IF (FUNCMODE = 'RUN') THEN
1093: -- Executable Statements
1094: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1095: --
1096: IF (l_debug <> -1) THEN
1097: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1098: END IF;

Line 1220: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID'); --

1216: END IF;
1217: --
1218: IF (FUNCMODE = 'RUN') THEN
1219: -- Executable Statements
1220: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID'); --
1221: IF (l_debug <> -1) THEN
1222: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1223: END IF;
1224: --

Line 1225: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');

1221: IF (l_debug <> -1) THEN
1222: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1223: END IF;
1224: --
1225: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');
1226: --
1227: IF (l_debug <> -1) THEN
1228: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
1229: END IF;

Line 1231: v_schedule_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');

1227: IF (l_debug <> -1) THEN
1228: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
1229: END IF;
1230: --
1231: v_schedule_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');
1232: --
1233: IF (l_debug <> -1) THEN
1234: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
1235: END IF;

Line 1294: wf_engine.SetItemAttrNumber( itemtype,

1290: CLOSE c_process_status_schedule;
1291: --
1292: -- Bug# 3291401 - End
1293: --
1294: wf_engine.SetItemAttrNumber( itemtype,
1295: itemkey,
1296: 'ERRORS_EXIST',
1297: g_PROC_SUCCESS); ---No Errors
1298: --

Line 1301: wf_engine.SetItemAttrNumber( itemtype,

1297: g_PROC_SUCCESS); ---No Errors
1298: --
1299: ELSE
1300: --
1301: wf_engine.SetItemAttrNumber( itemtype,
1302: itemkey,
1303: 'ERRORS_EXIST',
1304: g_PROC_ERROR); ---Errors Exist
1305: --

Line 1428: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

1424: END IF;
1425: --
1426: IF (FUNCMODE = 'RUN') THEN
1427: -- Executable Statements
1428: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1429: --
1430: IF (l_debug <> -1) THEN
1431: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1432: END IF;

Line 1434: v_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

1430: IF (l_debug <> -1) THEN
1431: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1432: END IF;
1433: --
1434: v_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
1435: --
1436: IF (l_debug <> -1) THEN
1437: rlm_core_sv.dlog(C_DEBUG,' Org Id :', v_org_id);
1438: END IF;

Line 1440: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');

1436: IF (l_debug <> -1) THEN
1437: rlm_core_sv.dlog(C_DEBUG,' Org Id :', v_org_id);
1438: END IF;
1439: --
1440: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');
1441: --
1442: IF (l_debug <> -1) THEN
1443: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
1444: END IF;

Line 1446: v_sched_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');

1442: IF (l_debug <> -1) THEN
1443: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
1444: END IF;
1445: --
1446: v_sched_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');
1447: --
1448: IF (l_debug <> -1) THEN
1449: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_sched_num);
1450: END IF;

Line 1665: wf_engine.SetItemAttrNumber( v_ItemType,

1661: END IF;
1662: --
1663: -- Set various Header Attributes
1664:
1665: wf_engine.SetItemAttrNumber( v_ItemType,
1666: v_ItemKey,
1667: 'USER_ID',
1668: FND_GLOBAL.USER_ID);
1669:

Line 1670: wf_engine.SetItemAttrNumber( v_ItemType,

1666: v_ItemKey,
1667: 'USER_ID',
1668: FND_GLOBAL.USER_ID);
1669:
1670: wf_engine.SetItemAttrNumber( v_ItemType,
1671: v_ItemKey,
1672: 'APPLICATION_ID',
1673: FND_GLOBAL.RESP_APPL_ID);
1674:

Line 1675: wf_engine.SetItemAttrNumber( v_ItemType,

1671: v_ItemKey,
1672: 'APPLICATION_ID',
1673: FND_GLOBAL.RESP_APPL_ID);
1674:
1675: wf_engine.SetItemAttrNumber( v_ItemType,
1676: v_ItemKey,
1677: 'REQUEST_ID',
1678: FND_GLOBAL.CONC_REQUEST_ID);
1679:

Line 1680: wf_engine.SetItemAttrNumber( v_ItemType,

1676: v_ItemKey,
1677: 'REQUEST_ID',
1678: FND_GLOBAL.CONC_REQUEST_ID);
1679:
1680: wf_engine.SetItemAttrNumber( v_ItemType,
1681: v_ItemKey,
1682: 'RESPONSIBILITY_ID',
1683: FND_GLOBAL.RESP_ID);
1684:

Line 1685: wf_engine.SetItemAttrNumber( v_ItemType,

1681: v_ItemKey,
1682: 'RESPONSIBILITY_ID',
1683: FND_GLOBAL.RESP_ID);
1684:
1685: wf_engine.SetItemAttrNumber( v_ItemType,
1686: v_ItemKey,
1687: 'ORG_ID',
1688: v_org_id);
1689:

Line 1690: wf_engine.SetItemAttrNumber( v_ItemType,

1686: v_ItemKey,
1687: 'ORG_ID',
1688: v_org_id);
1689:
1690: wf_engine.SetItemAttrNumber( v_ItemType,
1691: v_ItemKey,
1692: 'HEADER_ID',
1693: p_Header_Id);
1694:

Line 1695: wf_engine.SetItemAttrText( v_ItemType,

1691: v_ItemKey,
1692: 'HEADER_ID',
1693: p_Header_Id);
1694:
1695: wf_engine.SetItemAttrText( v_ItemType,
1696: v_ItemKey,
1697: 'SCHEDULE_NUMBER',
1698: v_ScheduleNum);
1699:

Line 1700: wf_engine.SetItemAttrText( v_ItemType,

1696: v_ItemKey,
1697: 'SCHEDULE_NUMBER',
1698: v_ScheduleNum);
1699:
1700: wf_engine.SetItemAttrText( v_ItemType,
1701: v_ItemKey,
1702: 'CUSTOMER_NAME',
1703: v_Customer);
1704: wf_engine.SetItemAttrNumber( v_ItemType,

Line 1704: wf_engine.SetItemAttrNumber( v_ItemType,

1700: wf_engine.SetItemAttrText( v_ItemType,
1701: v_ItemKey,
1702: 'CUSTOMER_NAME',
1703: v_Customer);
1704: wf_engine.SetItemAttrNumber( v_ItemType,
1705: v_ItemKey,
1706: 'ERRORS_EXIST',
1707: v_dummy);
1708:

Line 1713: wf_engine.SetItemAttrText( v_ItemType,

1709: -- Bug#: 3053299 - Setting the tokens for From User,
1710: -- To User and Schedule Generation Date
1711:
1712:
1713: wf_engine.SetItemAttrText( v_ItemType,
1714: v_ItemKey,
1715: 'FROM_USER',
1716: Notification_FromUser(FND_GLOBAL.RESP_ID,
1717: FND_GLOBAL.RESP_APPL_ID));

Line 1720: wf_engine.SetItemAttrText( v_ItemType,

1716: Notification_FromUser(FND_GLOBAL.RESP_ID,
1717: FND_GLOBAL.RESP_APPL_ID));
1718:
1719:
1720: wf_engine.SetItemAttrText( v_ItemType,
1721: v_ItemKey,
1722: 'TO_USER',
1723: Notification_ToUser(FND_GLOBAL.USER_ID));
1724:

Line 1725: wf_engine.SetItemAttrText( v_ItemType,

1721: v_ItemKey,
1722: 'TO_USER',
1723: Notification_ToUser(FND_GLOBAL.USER_ID));
1724:
1725: wf_engine.SetItemAttrText( v_ItemType,
1726: v_ItemKey,
1727: 'SCHED_GEN_DATE',
1728: v_ScheduleGenDate);
1729:

Line 1735: wf_engine.StartProcess(v_ItemType, v_ItemKey);

1731: IF (l_debug <> -1) THEN
1732: rlm_core_sv.dlog(C_DEBUG,'Before Start Process DSP Loop');
1733: END IF;
1734: --
1735: wf_engine.StartProcess(v_ItemType, v_ItemKey);
1736: --
1737: IF (l_debug <> -1) THEN
1738: rlm_core_sv.dlog(C_DEBUG,'After Start Process DSP Loop ');
1739: END IF;

Line 1741: v_retcode := wf_engine.GetItemAttrNumber(v_ItemType,v_ItemKey,'ERRORS_EXIST');

1737: IF (l_debug <> -1) THEN
1738: rlm_core_sv.dlog(C_DEBUG,'After Start Process DSP Loop ');
1739: END IF;
1740: --
1741: v_retcode := wf_engine.GetItemAttrNumber(v_ItemType,v_ItemKey,'ERRORS_EXIST');
1742: --
1743: IF (l_debug <> -1) THEN
1744: rlm_core_sv.dlog(C_DEBUG,' Errors Status: ', v_retcode);
1745: END IF;

Line 1815: wf_engine.AbortProcess(itemtype => v_ItemType,

1811: IF (l_debug <> -1) THEN
1812: rlm_core_sv.dlog(C_DEBUG,'Aborting old processes');
1813: END IF;
1814: --
1815: wf_engine.AbortProcess(itemtype => v_ItemType,
1816: itemkey => v_ItemKey);
1817: --
1818: IF (l_debug <> -1) THEN
1819: rlm_core_sv.dlog(C_DEBUG,'after abort bad process');

Line 1844: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);

1840: IF (l_debug <> -1) THEN
1841: rlm_core_sv.dlog(C_DEBUG,'After Purge for Item key ',v_ItemKey);
1842: END IF;
1843: --
1844: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);
1845: wf_engine.SetItemParent(v_ItemType,v_ItemKey,v_ItemType,to_char(p_Header_Id),
1846: to_char(p_Header_Id));
1847: --
1848: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,

Line 1845: wf_engine.SetItemParent(v_ItemType,v_ItemKey,v_ItemType,to_char(p_Header_Id),

1841: rlm_core_sv.dlog(C_DEBUG,'After Purge for Item key ',v_ItemKey);
1842: END IF;
1843: --
1844: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);
1845: wf_engine.SetItemParent(v_ItemType,v_ItemKey,v_ItemType,to_char(p_Header_Id),
1846: to_char(p_Header_Id));
1847: --
1848: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,
1849: g_Sch_rec.schedule_reference_num);

Line 1848: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,

1844: wf_engine.CreateProcess(v_ItemType, v_ItemKey, v_ProcessName);
1845: wf_engine.SetItemParent(v_ItemType,v_ItemKey,v_ItemType,to_char(p_Header_Id),
1846: to_char(p_Header_Id));
1847: --
1848: wf_engine.SetItemUserKey(v_ItemType, v_ItemKey,
1849: g_Sch_rec.schedule_reference_num);
1850:
1851: --
1852: retcode := g_PROC_SUCCESS;

Line 1904: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

1900: --
1901: IF (FUNCMODE = 'RUN') THEN
1902: -- Executable Statements
1903: --
1904: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1905: --
1906: IF (l_debug <> -1) THEN
1907: rlm_core_sv.dlog(C_DEBUG,'WF Header_id :',v_header_id);
1908: rlm_core_sv.dlog(C_DEBUG,' Header_id :', g_Sch_rec.header_id);

Line 2049: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

2045: END IF;
2046: --
2047: IF (FUNCMODE = 'RUN') THEN
2048: -- Executable Statements
2049: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
2050: --
2051: IF (l_debug <> -1) THEN
2052: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2053: END IF;

Line 2457: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

2453: --
2454: IF (FUNCMODE = 'RUN') THEN
2455: -- Executable Statements
2456: --
2457: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
2458: --
2459: IF (l_debug <> -1) THEN
2460: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2461: rlm_core_sv.dlog(C_DEBUG,'Before Archive_Demand');

Line 2593: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

2589: e_wftestschedule EXCEPTION;
2590:
2591: BEGIN
2592: --
2593: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
2594:
2595: IF RLM_DP_SV.edi_test_indicator = 'T' then
2596: --
2597: rlm_core_sv.dlog(C_DEBUG,'Test schedule found');

Line 2695: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

2691: END IF;
2692: --
2693: IF (FUNCMODE = 'RUN') THEN
2694: -- Executable Statements
2695: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
2696: --
2697: IF (l_debug <> -1) THEN
2698: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2699: END IF;

Line 2968: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

2964: END IF;
2965: --
2966: IF (FUNCMODE = 'RUN') THEN
2967: -- Executable Statements
2968: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
2969: --
2970: IF (l_debug <> -1) THEN
2971: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2972: END IF;

Line 3224: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

3220: END IF;
3221: --
3222: IF (FUNCMODE = 'RUN') THEN
3223: -- Executable Statements
3224: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
3225: --
3226: IF (l_debug <> -1) THEN
3227: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
3228: END IF;

Line 3230: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');

3226: IF (l_debug <> -1) THEN
3227: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
3228: END IF;
3229: --
3230: v_request_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'REQUEST_ID');
3231: --
3232: IF (l_debug <> -1) THEN
3233: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
3234: END IF;

Line 3236: v_schedule_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');

3232: IF (l_debug <> -1) THEN
3233: rlm_core_sv.dlog(C_DEBUG,' Request Id :', v_request_id);
3234: END IF;
3235: --
3236: v_schedule_num := wf_engine.GetItemAttrText(itemtype,itemkey,'SCHEDULE_NUMBER');
3237: --
3238: IF (l_debug <> -1) THEN
3239: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
3240: END IF;

Line 3247: wf_engine.SetItemAttrNumber( itemtype,

3243: rlm_message_sv.initialize_messages;
3244:
3245: -- Check for Errors
3246:
3247: wf_engine.SetItemAttrNumber( itemtype,
3248: itemkey,
3249: 'ERRORS_EXIST',
3250: g_PROC_ERROR); ---Errors Exist
3251:

Line 3520: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

3516: END IF;
3517: --
3518: IF (FUNCMODE = 'RUN') THEN
3519: -- Executable Statements
3520: v_header_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
3521: --
3522: IF (l_debug <> -1) THEN
3523: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
3524: END IF;