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

Line 23: wf_engine.createProcess( ItemType => l_ItemType,

19: -- Added for testing
20: --
21: -- Creates a new runtime process for an application item (SF-52 for WGI)
22: --
23: wf_engine.createProcess( ItemType => l_ItemType,
24: ItemKey => l_ItemKey,
25: process => 'AWGI' );
26: --
27: --

Line 28: wf_engine.SetItemAttrText ( itemtype => l_ItemType,

24: ItemKey => l_ItemKey,
25: process => 'AWGI' );
26: --
27: --
28: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
29: itemkey => l_Itemkey,
30: aname => 'PA_REQUEST_ID',
31: avalue => p_pa_request_id );
32: wf_engine.SetItemAttrText ( itemtype => l_ItemType,

Line 32: wf_engine.SetItemAttrText ( itemtype => l_ItemType,

28: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
29: itemkey => l_Itemkey,
30: aname => 'PA_REQUEST_ID',
31: avalue => p_pa_request_id );
32: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
33: itemkey => l_Itemkey,
34: aname => 'EMP_FULL_NAME',
35: avalue => p_full_name );
36: --

Line 40: wf_engine.StartProcess ( ItemType => l_ItemType,

36: --
37: --
38: -- Start the WGI process for the SF52 created
39: --
40: wf_engine.StartProcess ( ItemType => l_ItemType,
41: ItemKey => l_ItemKey );
42: --
43: --
44: end StartWGIProcess;

Line 104: wf_engine.SetItemAttrText (itemtype => ItemType,

100: -- NOCOPY Changes
101: l_result := result;
102: --
103: if funcmode = 'RUN' then
104: wf_engine.SetItemAttrText (itemtype => ItemType,
105: itemkey => Itemkey,
106: aname => 'ERROR_MSG',
107: avalue => '' );
108: --

Line 128: wf_engine.SetItemAttrText ( itemtype => Itemtype,

124: for full_name_rec in c_user_full_name loop
125: l_full_name := full_name_rec.full_name;
126: end loop;
127:
128: wf_engine.SetItemAttrText ( itemtype => Itemtype,
129: itemkey => Itemkey,
130: aname => 'FWD_SUP_NAME',
131: avalue => l_user_name || ' - ' || l_full_name
132: );

Line 134: wf_engine.SetItemAttrText ( itemtype => ItemType,

130: aname => 'FWD_SUP_NAME',
131: avalue => l_user_name || ' - ' || l_full_name
132: );
133: else
134: wf_engine.SetItemAttrText ( itemtype => ItemType,
135: itemkey => Itemkey,
136: aname => 'ERROR_MSG',
137: avalue => 'Supervisor does not exist or is invalid for this Employee. ');
138: end if;

Line 147: wf_engine.SetItemAttrText ( itemtype => ItemType,

143: ,p_groupbox_name => l_groupbox_name
144: ,p_personnel_office_id => l_personnel_office_id
145: ,p_gbx_user_id => l_gbx_user_id
146: );
147: wf_engine.SetItemAttrText ( itemtype => ItemType,
148: itemkey => Itemkey,
149: aname => 'POI',
150: avalue => l_personnel_office_id);
151: else

Line 152: wf_engine.SetItemAttrText ( itemtype => ItemType,

148: itemkey => Itemkey,
149: aname => 'POI',
150: avalue => l_personnel_office_id);
151: else
152: wf_engine.SetItemAttrText ( itemtype => ItemType,
153: itemkey => Itemkey,
154: aname => 'ERROR_MSG',
155: avalue => 'Position ID does not exist for this Employee. '
156: );

Line 169: wf_engine.SetItemAttrText (

165: l_valid_grpbox := VerifyValidWFUser (
166: p_user_name => l_groupbox_name
167: );
168: if l_groupbox_name Is Not Null then
169: wf_engine.SetItemAttrText (
170: itemtype => Itemtype,
171: itemkey => Itemkey,
172: aname => 'PERSONNEL_OFFICE_GBX',
173: avalue => l_groupbox_name

Line 188: wf_engine.SetItemAttrText( itemtype => ItemType,

184: ,p_routing_group_name => l_routing_group_name
185: ,p_routing_group_desc => l_routing_group_desc
186: );
187: else
188: wf_engine.SetItemAttrText( itemtype => ItemType,
189: itemkey => Itemkey,
190: aname => 'ERROR_MSG',
191: avalue => 'Groupbox is not valid or invalid for this Employee. ' );
192: end if;

Line 200: wf_engine.SetItemAttrText ( itemtype => ItemType,

196: p_groupbox_id => l_groupbox_id,
197: p_action_taken => 'NOT_ROUTED',
198: p_gbx_user_id => l_gbx_user_id);
199: else
200: wf_engine.SetItemAttrText ( itemtype => ItemType,
201: itemkey => Itemkey,
202: aname => 'ERROR_MSG',
203: avalue => 'Routing group does not exist for this Employee. ' );
204: end if;

Line 219: wf_engine.SetItemAttrText (

215: ,p_line6 => l_line6
216: ,p_line7 => l_line7
217: ,p_routing_group => l_routing_group
218: );
219: wf_engine.SetItemAttrText (
220: itemtype => Itemtype,
221: itemkey => Itemkey,
222: aname => 'LINE1',
223: avalue => l_line1

Line 225: wf_engine.SetItemAttrText (

221: itemkey => Itemkey,
222: aname => 'LINE1',
223: avalue => l_line1
224: );
225: wf_engine.SetItemAttrText (
226: itemtype => Itemtype,
227: itemkey => Itemkey,
228: aname => 'LINE2',
229: avalue => l_line2

Line 231: wf_engine.SetItemAttrText (

227: itemkey => Itemkey,
228: aname => 'LINE2',
229: avalue => l_line2
230: );
231: wf_engine.SetItemAttrText (
232: itemtype => Itemtype,
233: itemkey => Itemkey,
234: aname => 'LINE3',
235: avalue => l_line3

Line 237: wf_engine.SetItemAttrText (

233: itemkey => Itemkey,
234: aname => 'LINE3',
235: avalue => l_line3
236: );
237: wf_engine.SetItemAttrText (
238: itemtype => Itemtype,
239: itemkey => Itemkey,
240: aname => 'LINE4',
241: avalue => l_line4

Line 243: wf_engine.SetItemAttrText (

239: itemkey => Itemkey,
240: aname => 'LINE4',
241: avalue => l_line4
242: );
243: wf_engine.SetItemAttrText (
244: itemtype => Itemtype,
245: itemkey => Itemkey,
246: aname => 'LINE5',
247: avalue => l_line5

Line 249: wf_engine.SetItemAttrText (

245: itemkey => Itemkey,
246: aname => 'LINE5',
247: avalue => l_line5
248: );
249: wf_engine.SetItemAttrText (
250: itemtype => Itemtype,
251: itemkey => Itemkey,
252: aname => 'LINE6',
253: avalue => l_line6

Line 255: wf_engine.SetItemAttrText (

251: itemkey => Itemkey,
252: aname => 'LINE6',
253: avalue => l_line6
254: );
255: wf_engine.SetItemAttrText (
256: itemtype => Itemtype,
257: itemkey => Itemkey,
258: aname => 'LINE7',
259: avalue => l_line7

Line 262: wf_engine.SetItemAttrText (

258: aname => 'LINE7',
259: avalue => l_line7
260: );
261:
262: wf_engine.SetItemAttrText (
263: itemtype => Itemtype,
264: itemkey => Itemkey,
265: aname => 'WGI_ERROR_NOTE',
266: avalue => l_wgi_error_note

Line 268: wf_engine.SetItemAttrText( itemtype => Itemtype,

264: itemkey => Itemkey,
265: aname => 'WGI_ERROR_NOTE',
266: avalue => l_wgi_error_note
267: );
268: wf_engine.SetItemAttrText( itemtype => Itemtype,
269: itemkey => Itemkey,
270: aname => 'FROM_NAME',
271: avalue => FND_GLOBAL.USER_NAME() );
272: wf_engine.SetItemAttrText (

Line 272: wf_engine.SetItemAttrText (

268: wf_engine.SetItemAttrText( itemtype => Itemtype,
269: itemkey => Itemkey,
270: aname => 'FROM_NAME',
271: avalue => FND_GLOBAL.USER_NAME() );
272: wf_engine.SetItemAttrText (
273: itemtype => Itemtype,
274: itemkey => Itemkey,
275: aname => 'OFFICE_SYMBOL',
276: avalue => l_office_symbol_name

Line 278: wf_engine.SetItemAttrText (

274: itemkey => Itemkey,
275: aname => 'OFFICE_SYMBOL',
276: avalue => l_office_symbol_name
277: );
278: wf_engine.SetItemAttrText (
279: itemtype => Itemtype,
280: itemkey => Itemkey,
281: aname => 'ROUTING_GROUP',
282: avalue => l_routing_group

Line 288: wf_engine.SetItemAttrText ( itemtype => Itemtype,

284: if ((l_valid_user ) and (l_valid_grpbox)) then
285: result := 'COMPLETE:YES';
286: return;
287: elsif ((NOT l_valid_user) and (NOT l_valid_grpbox)) then
288: wf_engine.SetItemAttrText ( itemtype => Itemtype,
289: itemkey => Itemkey,
290: aname => 'ERROR_MSG',
291: avalue => 'Supervisor and Groupbox for the employee are invalid. ');
292: result := 'COMPLETE:NO';

Line 339: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

335: -- NOCOPY Changes
336: l_result := result;
337: --
338: if funcmode = 'RUN' then
339: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
340: itemkey => Itemkey,
341: aname => 'APPROVAL_REQUIRED');
342: if l_text = 'NO' then
343: result := 'COMPLETE:NO';

Line 614: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

610: Begin
611: -- NOCOPY Changes
612: l_result := result;
613: if funcmode = 'RUN' then
614: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
615: itemkey => Itemkey,
616: aname => 'PERSONNEL_OFFICE_GBX');
617: if l_text is NULL then
618: ghr_wgi_pkg.create_ghr_errorlog(

Line 663: l_error_msg := wf_engine.GetItemAttrText (

659: l_result VARCHAR2(250);
660: Begin
661: l_result := result;
662: if funcmode = 'RUN' then
663: l_error_msg := wf_engine.GetItemAttrText (
664: itemtype => Itemtype,
665: itemkey => Itemkey,
666: aname => 'ERROR_MSG'
667: );

Line 1000: wf_engine.SetItemAttrText ( itemtype => ItemType,

996: exception
997: when others then
998: -- NOCOPY Changes
999: result := l_result;
1000: wf_engine.SetItemAttrText ( itemtype => ItemType,
1001: itemkey => Itemkey,
1002: aname => 'ERROR_MSG',
1003: avalue => 'Update to HR failed. ' || substr(sqlerrm,1,1000) );
1004: result := 'COMPLETE:NO';

Line 1911: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

1907: -- NOCOPY Changes
1908: l_result := result;
1909: --
1910: if funcmode = 'RUN' then
1911: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1912: itemkey => Itemkey,
1913: aname => 'PEROFC_APRVL_REQD');
1914: if l_text = 'YES' then
1915: result := 'COMPLETE:YES';

Line 1955: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

1951: -- NOCOPY Changes
1952: l_result := result;
1953: --
1954: if funcmode = 'RUN' then
1955: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1956: itemkey => Itemkey,
1957: aname => 'USE_PEROFC');
1958: if l_text = 'NO' then
1959: result := 'COMPLETE:NO';

Line 2032: wf_engine.SetItemAttrText (itemtype => ItemType,

2028: -- NOCOPY Changes
2029: l_result := result;
2030:
2031: if funcmode = 'RUN' then
2032: wf_engine.SetItemAttrText (itemtype => ItemType,
2033: itemkey => Itemkey,
2034: aname => 'ERROR_MSG',
2035: avalue => '' );
2036: --

Line 2052: wf_engine.SetItemAttrText ( itemtype => ItemType,

2048: ,p_groupbox_name => l_groupbox_name
2049: ,p_personnel_office_id => l_personnel_office_id
2050: ,p_gbx_user_id => l_gbx_user_id
2051: );
2052: wf_engine.SetItemAttrText ( itemtype => ItemType,
2053: itemkey => Itemkey,
2054: aname => 'POI',
2055: avalue => l_personnel_office_id);
2056: else

Line 2057: wf_engine.SetItemAttrText ( itemtype => ItemType,

2053: itemkey => Itemkey,
2054: aname => 'POI',
2055: avalue => l_personnel_office_id);
2056: else
2057: wf_engine.SetItemAttrText ( itemtype => ItemType,
2058: itemkey => Itemkey,
2059: aname => 'ERROR_MSG',
2060: avalue => 'Position ID does not exist for this Employee. '
2061: );

Line 2070: wf_engine.SetItemAttrText (

2066: l_valid_grpbox := VerifyValidWFUser (
2067: p_user_name => l_groupbox_name
2068: );
2069: if l_groupbox_name Is Not Null then
2070: wf_engine.SetItemAttrText (
2071: itemtype => Itemtype,
2072: itemkey => Itemkey,
2073: aname => 'PERSONNEL_OFFICE_GBX',
2074: avalue => l_groupbox_name

Line 2089: wf_engine.SetItemAttrText( itemtype => ItemType,

2085: ,p_routing_group_name => l_routing_group_name
2086: ,p_routing_group_desc => l_routing_group_desc
2087: );
2088: else
2089: wf_engine.SetItemAttrText( itemtype => ItemType,
2090: itemkey => Itemkey,
2091: aname => 'ERROR_MSG',
2092: avalue => 'Groupbox is not valid or invalid for this Employee. ' );
2093: end if;

Line 2101: wf_engine.SetItemAttrText ( itemtype => ItemType,

2097: p_groupbox_id => l_groupbox_id,
2098: p_action_taken => 'NOT_ROUTED',
2099: p_gbx_user_id => l_gbx_user_id);
2100: else
2101: wf_engine.SetItemAttrText ( itemtype => ItemType,
2102: itemkey => Itemkey,
2103: aname => 'ERROR_MSG',
2104: avalue => 'Routing group does not exist for this Employee. ' );
2105: end if;

Line 2121: wf_engine.SetItemAttrText (

2117: ,p_line6 => l_line6
2118: ,p_line7 => l_line7
2119: ,p_routing_group => l_routing_group
2120: );
2121: wf_engine.SetItemAttrText (
2122: itemtype => Itemtype,
2123: itemkey => Itemkey,
2124: aname => 'LINE1',
2125: avalue => l_line1

Line 2127: wf_engine.SetItemAttrText (

2123: itemkey => Itemkey,
2124: aname => 'LINE1',
2125: avalue => l_line1
2126: );
2127: wf_engine.SetItemAttrText (
2128: itemtype => Itemtype,
2129: itemkey => Itemkey,
2130: aname => 'LINE2',
2131: avalue => l_line2

Line 2133: wf_engine.SetItemAttrText (

2129: itemkey => Itemkey,
2130: aname => 'LINE2',
2131: avalue => l_line2
2132: );
2133: wf_engine.SetItemAttrText (
2134: itemtype => Itemtype,
2135: itemkey => Itemkey,
2136: aname => 'LINE3',
2137: avalue => l_line3

Line 2139: wf_engine.SetItemAttrText (

2135: itemkey => Itemkey,
2136: aname => 'LINE3',
2137: avalue => l_line3
2138: );
2139: wf_engine.SetItemAttrText (
2140: itemtype => Itemtype,
2141: itemkey => Itemkey,
2142: aname => 'LINE4',
2143: avalue => l_line4

Line 2145: wf_engine.SetItemAttrText (

2141: itemkey => Itemkey,
2142: aname => 'LINE4',
2143: avalue => l_line4
2144: );
2145: wf_engine.SetItemAttrText (
2146: itemtype => Itemtype,
2147: itemkey => Itemkey,
2148: aname => 'LINE5',
2149: avalue => l_line5

Line 2151: wf_engine.SetItemAttrText (

2147: itemkey => Itemkey,
2148: aname => 'LINE5',
2149: avalue => l_line5
2150: );
2151: wf_engine.SetItemAttrText (
2152: itemtype => Itemtype,
2153: itemkey => Itemkey,
2154: aname => 'LINE6',
2155: avalue => l_line6

Line 2157: wf_engine.SetItemAttrText (

2153: itemkey => Itemkey,
2154: aname => 'LINE6',
2155: avalue => l_line6
2156: );
2157: wf_engine.SetItemAttrText (
2158: itemtype => Itemtype,
2159: itemkey => Itemkey,
2160: aname => 'LINE7',
2161: avalue => l_line7

Line 2163: wf_engine.SetItemAttrText (

2159: itemkey => Itemkey,
2160: aname => 'LINE7',
2161: avalue => l_line7
2162: );
2163: wf_engine.SetItemAttrText (
2164: itemtype => Itemtype,
2165: itemkey => Itemkey,
2166: aname => 'WGI_ERROR_NOTE',
2167: avalue => l_wgi_error_note

Line 2169: wf_engine.SetItemAttrText( itemtype => Itemtype,

2165: itemkey => Itemkey,
2166: aname => 'WGI_ERROR_NOTE',
2167: avalue => l_wgi_error_note
2168: );
2169: wf_engine.SetItemAttrText( itemtype => Itemtype,
2170: itemkey => Itemkey,
2171: aname => 'FROM_NAME',
2172: avalue => FND_GLOBAL.USER_NAME() );
2173: wf_engine.SetItemAttrText (

Line 2173: wf_engine.SetItemAttrText (

2169: wf_engine.SetItemAttrText( itemtype => Itemtype,
2170: itemkey => Itemkey,
2171: aname => 'FROM_NAME',
2172: avalue => FND_GLOBAL.USER_NAME() );
2173: wf_engine.SetItemAttrText (
2174: itemtype => Itemtype,
2175: itemkey => Itemkey,
2176: aname => 'OFFICE_SYMBOL',
2177: avalue => l_office_symbol_name

Line 2179: wf_engine.SetItemAttrText (

2175: itemkey => Itemkey,
2176: aname => 'OFFICE_SYMBOL',
2177: avalue => l_office_symbol_name
2178: );
2179: wf_engine.SetItemAttrText (
2180: itemtype => Itemtype,
2181: itemkey => Itemkey,
2182: aname => 'ROUTING_GROUP',
2183: avalue => l_routing_group

Line 2189: wf_engine.SetItemAttrText (

2185: if l_valid_grpbox then
2186: result := 'COMPLETE:YES';
2187: return;
2188: else
2189: wf_engine.SetItemAttrText (
2190: itemtype => Itemtype,
2191: itemkey => Itemkey,
2192: aname => 'ERROR_MSG',
2193: avalue => 'Personnel Groupbox of the employee is invalid. '

Line 2498: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

2494: --
2495: -- NOCOPY Changes
2496: l_result := result;
2497: if funcmode = 'RUN' then
2498: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
2499: itemkey => Itemkey,
2500: aname => 'NTFY_PEROFC_OF_APRVL');
2501: if l_text = 'NO' then
2502: result := 'COMPLETE:NO';