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.PQH_WF dependencies on HR_UTILITY

Line 17: hr_utility.set_location(l_proc || 'Entering',10);

13: IS
14: l_hyphen_pos NUMBER;
15: l_proc VARCHAR2(61) := g_package || 'decode_itemkey';
16: BEGIN
17: hr_utility.set_location(l_proc || 'Entering',10);
18: l_hyphen_pos := INSTR(p_itemkey, '-');
19: p_transaction_category_id := TO_NUMBER(SUBSTR(p_itemkey, 1, l_hyphen_pos - 1));
20: p_transaction_id := TO_NUMBER(SUBSTR(p_itemkey, l_hyphen_pos + 1));
21: hr_utility.set_location(l_proc || 'txn_cat'||p_transaction_category_id,20);

Line 21: hr_utility.set_location(l_proc || 'txn_cat'||p_transaction_category_id,20);

17: hr_utility.set_location(l_proc || 'Entering',10);
18: l_hyphen_pos := INSTR(p_itemkey, '-');
19: p_transaction_category_id := TO_NUMBER(SUBSTR(p_itemkey, 1, l_hyphen_pos - 1));
20: p_transaction_id := TO_NUMBER(SUBSTR(p_itemkey, l_hyphen_pos + 1));
21: hr_utility.set_location(l_proc || 'txn_cat'||p_transaction_category_id,20);
22: hr_utility.set_location(l_proc || 'txn_id'||p_transaction_id,30);
23: hr_utility.set_location(l_proc || 'Exiting',100);
24: exception when others then
25: p_transaction_category_id := null;

Line 22: hr_utility.set_location(l_proc || 'txn_id'||p_transaction_id,30);

18: l_hyphen_pos := INSTR(p_itemkey, '-');
19: p_transaction_category_id := TO_NUMBER(SUBSTR(p_itemkey, 1, l_hyphen_pos - 1));
20: p_transaction_id := TO_NUMBER(SUBSTR(p_itemkey, l_hyphen_pos + 1));
21: hr_utility.set_location(l_proc || 'txn_cat'||p_transaction_category_id,20);
22: hr_utility.set_location(l_proc || 'txn_id'||p_transaction_id,30);
23: hr_utility.set_location(l_proc || 'Exiting',100);
24: exception when others then
25: p_transaction_category_id := null;
26: p_transaction_id := null;

Line 23: hr_utility.set_location(l_proc || 'Exiting',100);

19: p_transaction_category_id := TO_NUMBER(SUBSTR(p_itemkey, 1, l_hyphen_pos - 1));
20: p_transaction_id := TO_NUMBER(SUBSTR(p_itemkey, l_hyphen_pos + 1));
21: hr_utility.set_location(l_proc || 'txn_cat'||p_transaction_category_id,20);
22: hr_utility.set_location(l_proc || 'txn_id'||p_transaction_id,30);
23: hr_utility.set_location(l_proc || 'Exiting',100);
24: exception when others then
25: p_transaction_category_id := null;
26: p_transaction_id := null;
27: raise;

Line 39: hr_utility.set_location(l_proc || ' Entering',10);

35: IS
36: l_process_log_id NUMBER;
37: l_proc VARCHAR2(61) := g_package || 'create_process_log';
38: BEGIN
39: hr_utility.set_location(l_proc || ' Entering',10);
40: /*
41: INSERT INTO ghr_process_log (
42: PROCESS_LOG_ID
43: , PROGRAM_NAME

Line 65: hr_utility.set_location(l_proc || ' '|| p_log_text,90);

61: , 1
62: )
63: ;
64: */
65: hr_utility.set_location(l_proc || ' '|| p_log_text,90);
66: hr_utility.set_location(l_proc || ' Exiting',100);
67: END;
68: --
69: -- Check wether the transaction was approved by override approver or not

Line 66: hr_utility.set_location(l_proc || ' Exiting',100);

62: )
63: ;
64: */
65: hr_utility.set_location(l_proc || ' '|| p_log_text,90);
66: hr_utility.set_location(l_proc || ' Exiting',100);
67: END;
68: --
69: -- Check wether the transaction was approved by override approver or not
70: --

Line 95: hr_utility.set_location('entering '||l_proc,10);

91: l_matchfound boolean := FALSE;
92: l_approval_cd varchar2(30);
93: l_proc VARCHAR2(61) := g_package || 'check_approver ';
94: begin
95: hr_utility.set_location('entering '||l_proc,10);
96: decode_itemkey( p_itemkey => p_itemkey
97: , p_transaction_category_id => l_tran_cat_id
98: , p_transaction_id => l_transaction_id);
99: for i in c1 loop

Line 100: hr_utility.set_location('in loop for rh_id'||i.routing_history_id||l_proc,20);

96: decode_itemkey( p_itemkey => p_itemkey
97: , p_transaction_category_id => l_tran_cat_id
98: , p_transaction_id => l_transaction_id);
99: for i in c1 loop
100: hr_utility.set_location('in loop for rh_id'||i.routing_history_id||l_proc,20);
101: open c2(i.routing_history_id);
102: fetch c2 into l_approval_cd;
103: if c2%notfound then
104: hr_utility.set_location('not routed after that'||l_proc,30);

Line 104: hr_utility.set_location('not routed after that'||l_proc,30);

100: hr_utility.set_location('in loop for rh_id'||i.routing_history_id||l_proc,20);
101: open c2(i.routing_history_id);
102: fetch c2 into l_approval_cd;
103: if c2%notfound then
104: hr_utility.set_location('not routed after that'||l_proc,30);
105: l_matchfound := FALSE;
106: close c2;
107: else
108: hr_utility.set_location('routed after sending to ov '||l_proc,40);

Line 108: hr_utility.set_location('routed after sending to ov '||l_proc,40);

104: hr_utility.set_location('not routed after that'||l_proc,30);
105: l_matchfound := FALSE;
106: close c2;
107: else
108: hr_utility.set_location('routed after sending to ov '||l_proc,40);
109: if l_approval_cd ='APPROVED' then
110: hr_utility.set_location('Approved by OA'||l_proc,50);
111: l_matchfound := TRUE;
112: return l_matchfound;

Line 110: hr_utility.set_location('Approved by OA'||l_proc,50);

106: close c2;
107: else
108: hr_utility.set_location('routed after sending to ov '||l_proc,40);
109: if l_approval_cd ='APPROVED' then
110: hr_utility.set_location('Approved by OA'||l_proc,50);
111: l_matchfound := TRUE;
112: return l_matchfound;
113: end if;
114: close c2;

Line 116: hr_utility.set_location('out loop for rh_id'||i.routing_history_id||l_proc,60);

112: return l_matchfound;
113: end if;
114: close c2;
115: end if;
116: hr_utility.set_location('out loop for rh_id'||i.routing_history_id||l_proc,60);
117: end loop;
118: hr_utility.set_location('exiting'||l_proc,100);
119: return l_matchfound;
120: end check_approver;

Line 118: hr_utility.set_location('exiting'||l_proc,100);

114: close c2;
115: end if;
116: hr_utility.set_location('out loop for rh_id'||i.routing_history_id||l_proc,60);
117: end loop;
118: hr_utility.set_location('exiting'||l_proc,100);
119: return l_matchfound;
120: end check_approver;
121: --
122: -- Check if workflow process is running

Line 138: hr_utility.set_location(l_proc || 'Entering',10);

134: FROM wf_items wfi
135: WHERE wfi.item_type = p_itemtype
136: AND wfi.item_key = p_itemkey;
137: BEGIN
138: hr_utility.set_location(l_proc || 'Entering',10);
139: OPEN c_wf;
140: FETCH c_wf INTO l_temp_holder;
141: l_running := c_wf%FOUND;
142: CLOSE c_wf;

Line 144: hr_utility.set_location(l_proc || 'WF Running - TRUE', 100);

140: FETCH c_wf INTO l_temp_holder;
141: l_running := c_wf%FOUND;
142: CLOSE c_wf;
143: if l_running THEN
144: hr_utility.set_location(l_proc || 'WF Running - TRUE', 100);
145: ELSE
146: hr_utility.set_location(l_proc || 'WF Running - FALSE', 100);
147: END IF;
148: hr_utility.set_location(l_proc || 'Exiting',100);

Line 146: hr_utility.set_location(l_proc || 'WF Running - FALSE', 100);

142: CLOSE c_wf;
143: if l_running THEN
144: hr_utility.set_location(l_proc || 'WF Running - TRUE', 100);
145: ELSE
146: hr_utility.set_location(l_proc || 'WF Running - FALSE', 100);
147: END IF;
148: hr_utility.set_location(l_proc || 'Exiting',100);
149: RETURN (NOT l_running);
150: END;

Line 148: hr_utility.set_location(l_proc || 'Exiting',100);

144: hr_utility.set_location(l_proc || 'WF Running - TRUE', 100);
145: ELSE
146: hr_utility.set_location(l_proc || 'WF Running - FALSE', 100);
147: END IF;
148: hr_utility.set_location(l_proc || 'Exiting',100);
149: RETURN (NOT l_running);
150: END;
151: PROCEDURE fyi_notification( document_id in varchar2,
152: display_type in varchar2,

Line 172: hr_utility.set_location(l_proc || 'Entering',10);

168: cursor c1 is select post_txn_function,short_name
169: from pqh_transaction_categories
170: where transaction_category_id = l_tran_cat_id ;
171: begin
172: hr_utility.set_location(l_proc || 'Entering',10);
173: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
174: l_hyphen_pos := INSTR(document_id, ':');
175: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
176: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 173: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

169: from pqh_transaction_categories
170: where transaction_category_id = l_tran_cat_id ;
171: begin
172: hr_utility.set_location(l_proc || 'Entering',10);
173: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
174: l_hyphen_pos := INSTR(document_id, ':');
175: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
176: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));
177: open c1;

Line 198: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

194: document := l_document;
195: document_type := l_document_type;
196: l_sqlcode := sqlcode;
197: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
198: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
199: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
200: END;
201: -- document := document || l_fyi_notification ;
202: hr_utility.set_location(l_proc || 'Exiting',100);

Line 199: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

195: document_type := l_document_type;
196: l_sqlcode := sqlcode;
197: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
198: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
199: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
200: END;
201: -- document := document || l_fyi_notification ;
202: hr_utility.set_location(l_proc || 'Exiting',100);
203: end;

Line 202: hr_utility.set_location(l_proc || 'Exiting',100);

198: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
199: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
200: END;
201: -- document := document || l_fyi_notification ;
202: hr_utility.set_location(l_proc || 'Exiting',100);
203: end;
204:
205: PROCEDURE reject_notification( document_id in varchar2,
206: display_type in varchar2,

Line 224: hr_utility.set_location(l_proc || 'Entering',10);

220: cursor c1 is select post_txn_function,short_name
221: from pqh_transaction_categories
222: where transaction_category_id = l_tran_cat_id ;
223: begin
224: hr_utility.set_location(l_proc || 'Entering',10);
225: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
226: document_type := 'text/plain';
227: l_hyphen_pos := INSTR(document_id, ':');
228: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 225: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

221: from pqh_transaction_categories
222: where transaction_category_id = l_tran_cat_id ;
223: begin
224: hr_utility.set_location(l_proc || 'Entering',10);
225: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
226: document_type := 'text/plain';
227: l_hyphen_pos := INSTR(document_id, ':');
228: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
229: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 250: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

246: document := l_document;
247: document_type := l_document_type;
248: l_sqlcode := sqlcode;
249: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
250: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
251: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
252: END;
253: hr_utility.set_location(l_proc || 'Exiting',100);
254: end;

Line 251: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

247: document_type := l_document_type;
248: l_sqlcode := sqlcode;
249: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
250: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
251: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
252: END;
253: hr_utility.set_location(l_proc || 'Exiting',100);
254: end;
255:

Line 253: hr_utility.set_location(l_proc || 'Exiting',100);

249: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
250: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
251: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
252: END;
253: hr_utility.set_location(l_proc || 'Exiting',100);
254: end;
255:
256: PROCEDURE back_notification( document_id in varchar2,
257: display_type in varchar2,

Line 275: hr_utility.set_location(l_proc || 'Entering',10);

271: cursor c1 is select post_txn_function,short_name
272: from pqh_transaction_categories
273: where transaction_category_id = l_tran_cat_id ;
274: begin
275: hr_utility.set_location(l_proc || 'Entering',10);
276: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
277: document_type := 'text/plain';
278: l_hyphen_pos := INSTR(document_id, ':');
279: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 276: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

272: from pqh_transaction_categories
273: where transaction_category_id = l_tran_cat_id ;
274: begin
275: hr_utility.set_location(l_proc || 'Entering',10);
276: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
277: document_type := 'text/plain';
278: l_hyphen_pos := INSTR(document_id, ':');
279: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
280: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 301: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

297: document := l_document;
298: document_type := l_document_type;
299: l_sqlcode := sqlcode;
300: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
301: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
302: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
303: END;
304: hr_utility.set_location(l_proc || 'Exiting',100);
305: end;

Line 302: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

298: document_type := l_document_type;
299: l_sqlcode := sqlcode;
300: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
301: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
302: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
303: END;
304: hr_utility.set_location(l_proc || 'Exiting',100);
305: end;
306:

Line 304: hr_utility.set_location(l_proc || 'Exiting',100);

300: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
301: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
302: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
303: END;
304: hr_utility.set_location(l_proc || 'Exiting',100);
305: end;
306:
307: PROCEDURE override_notification( document_id in varchar2,
308: display_type in varchar2,

Line 326: hr_utility.set_location(l_proc || 'Entering',10);

322: cursor c1 is select post_txn_function,short_name
323: from pqh_transaction_categories
324: where transaction_category_id = l_tran_cat_id ;
325: begin
326: hr_utility.set_location(l_proc || 'Entering',10);
327: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
328: document_type := 'text/plain';
329: l_hyphen_pos := INSTR(document_id, ':');
330: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 327: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

323: from pqh_transaction_categories
324: where transaction_category_id = l_tran_cat_id ;
325: begin
326: hr_utility.set_location(l_proc || 'Entering',10);
327: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
328: document_type := 'text/plain';
329: l_hyphen_pos := INSTR(document_id, ':');
330: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
331: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 352: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

348: document := l_document;
349: document_type := l_document_type;
350: l_sqlcode := sqlcode;
351: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
352: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
353: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
354: END;
355: hr_utility.set_location(l_proc || 'Exiting',100);
356: end;

Line 353: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

349: document_type := l_document_type;
350: l_sqlcode := sqlcode;
351: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
352: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
353: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
354: END;
355: hr_utility.set_location(l_proc || 'Exiting',100);
356: end;
357:

Line 355: hr_utility.set_location(l_proc || 'Exiting',100);

351: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
352: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
353: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
354: END;
355: hr_utility.set_location(l_proc || 'Exiting',100);
356: end;
357:
358: PROCEDURE apply_notification( document_id in varchar2,
359: display_type in varchar2,

Line 377: hr_utility.set_location(l_proc || 'Entering',10);

373: cursor c1 is select post_txn_function,short_name
374: from pqh_transaction_categories
375: where transaction_category_id = l_tran_cat_id ;
376: begin
377: hr_utility.set_location(l_proc || 'Entering',10);
378: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
379: document_type := 'text/plain';
380: l_hyphen_pos := INSTR(document_id, ':');
381: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 378: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

374: from pqh_transaction_categories
375: where transaction_category_id = l_tran_cat_id ;
376: begin
377: hr_utility.set_location(l_proc || 'Entering',10);
378: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
379: document_type := 'text/plain';
380: l_hyphen_pos := INSTR(document_id, ':');
381: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
382: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 403: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

399: document := l_document;
400: document_type := l_document_type;
401: l_sqlcode := sqlcode;
402: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
403: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
404: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
405: END;
406: hr_utility.set_location(l_proc || 'Exiting',100);
407: end;

Line 404: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

400: document_type := l_document_type;
401: l_sqlcode := sqlcode;
402: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
403: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
404: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
405: END;
406: hr_utility.set_location(l_proc || 'Exiting',100);
407: end;
408:

Line 406: hr_utility.set_location(l_proc || 'Exiting',100);

402: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
403: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
404: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
405: END;
406: hr_utility.set_location(l_proc || 'Exiting',100);
407: end;
408:
409: PROCEDURE warning_notification( document_id in varchar2,
410: display_type in varchar2,

Line 428: hr_utility.set_location(l_proc || 'Entering',10);

424: cursor c1 is select post_txn_function,short_name
425: from pqh_transaction_categories
426: where transaction_category_id = l_tran_cat_id ;
427: begin
428: hr_utility.set_location(l_proc || 'Entering',10);
429: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
430: document_type := 'text/plain';
431: l_hyphen_pos := INSTR(document_id, ':');
432: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 429: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

425: from pqh_transaction_categories
426: where transaction_category_id = l_tran_cat_id ;
427: begin
428: hr_utility.set_location(l_proc || 'Entering',10);
429: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
430: document_type := 'text/plain';
431: l_hyphen_pos := INSTR(document_id, ':');
432: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
433: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 454: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

450: document := l_document;
451: document_type := l_document_type;
452: l_sqlcode := sqlcode;
453: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
454: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
455: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
456: END;
457: hr_utility.set_location(l_proc || 'Exiting',100);
458: end;

Line 455: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

451: document_type := l_document_type;
452: l_sqlcode := sqlcode;
453: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
454: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
455: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
456: END;
457: hr_utility.set_location(l_proc || 'Exiting',100);
458: end;
459:

Line 457: hr_utility.set_location(l_proc || 'Exiting',100);

453: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
454: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
455: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
456: END;
457: hr_utility.set_location(l_proc || 'Exiting',100);
458: end;
459:
460: PROCEDURE respond_notification( document_id in varchar2,
461: display_type in varchar2,

Line 479: hr_utility.set_location(l_proc || 'Entering',10);

475: cursor c1 is select post_txn_function,short_name
476: from pqh_transaction_categories
477: where transaction_category_id = l_tran_cat_id ;
478: begin
479: hr_utility.set_location(l_proc || 'Entering',10);
480: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
481: document_type := 'text/plain';
482: l_hyphen_pos := INSTR(document_id, ':');
483: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));

Line 480: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

476: from pqh_transaction_categories
477: where transaction_category_id = l_tran_cat_id ;
478: begin
479: hr_utility.set_location(l_proc || 'Entering',10);
480: hr_utility.set_location(l_proc || 'document id ' || document_id,20);
481: document_type := 'text/plain';
482: l_hyphen_pos := INSTR(document_id, ':');
483: l_transaction_id := TO_NUMBER(SUBSTR(document_id, 1, l_hyphen_pos - 1));
484: l_tran_cat_id := TO_NUMBER(SUBSTR(document_id, l_hyphen_pos + 1));

Line 505: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

501: l_document := document;
502: l_document_type := document_type;
503: l_sqlcode := sqlcode;
504: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
505: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
506: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
507: END;
508: -- document := document || l_respond_notification ;
509: -- document := 'Testing' || document_id;

Line 506: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

502: l_document_type := document_type;
503: l_sqlcode := sqlcode;
504: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
505: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
506: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
507: END;
508: -- document := document || l_respond_notification ;
509: -- document := 'Testing' || document_id;
510: hr_utility.set_location(l_proc || 'Exiting',100);

Line 510: hr_utility.set_location(l_proc || 'Exiting',100);

506: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
507: END;
508: -- document := document || l_respond_notification ;
509: -- document := 'Testing' || document_id;
510: hr_utility.set_location(l_proc || 'Exiting',100);
511: end;
512:
513: --
514: -- Create routing history row

Line 545: hr_utility.set_location(l_proc || 'Entering',10);

541: l_object_version_number pqh_routing_history.object_version_number%type;
542: l_effective_date date := trunc(sysdate);
543: j binary_integer := 0;
544: BEGIN
545: hr_utility.set_location(l_proc || 'Entering',10);
546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;

Line 546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);

542: l_effective_date date := trunc(sysdate);
543: j binary_integer := 0;
544: BEGIN
545: hr_utility.set_location(l_proc || 'Entering',10);
546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;

Line 563: hr_utility.set_location(l_proc || 'out of xfer ',14);

559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;
560: j := j + 1;
561: end if;
562: END LOOP;
563: hr_utility.set_location(l_proc || 'out of xfer ',14);
564:
565: pqh_routing_history_api.create_routing_history_bp (
566: p_validate => false
567: ,p_routing_history_id => l_routing_history_id

Line 594: hr_utility.set_location(l_proc || 'Exiting',100);

590: ,p_effective_date => l_effective_date
591: ,p_rha_tab => l_rha_tab
592: );
593: p_routing_history_id := l_routing_history_id;
594: hr_utility.set_location(l_proc || 'Exiting',100);
595: exception
596: when others then
597: p_routing_history_id := null;
598: hr_utility.set_location(sqlerrm,110 );

Line 598: hr_utility.set_location(sqlerrm,110 );

594: hr_utility.set_location(l_proc || 'Exiting',100);
595: exception
596: when others then
597: p_routing_history_id := null;
598: hr_utility.set_location(sqlerrm,110 );
599: raise;
600: END;
601: --
602: -- Update routing history row

Line 611: hr_utility.set_location(l_proc || 'Entering',10);

607: )
608: IS
609: l_proc VARCHAR2(61) := g_package || 'update_routing_history';
610: BEGIN
611: hr_utility.set_location(l_proc || 'Entering',10);
612: UPDATE pqh_routing_history
613: set
614: user_action_cd = p_user_action_cd
615: WHERE routing_history_id = p_routing_history_id;

Line 616: hr_utility.set_location(l_proc || 'Exiting',100);

612: UPDATE pqh_routing_history
613: set
614: user_action_cd = p_user_action_cd
615: WHERE routing_history_id = p_routing_history_id;
616: hr_utility.set_location(l_proc || 'Exiting',100);
617: END;
618:
619: --
620: -- Get Last routing history row

Line 682: hr_utility.set_location(l_proc || 'Entering',10);

678: AND user_action_cd <> 'TIMEOUT'
679: ORDER BY 2 DESC, 1 ASC;
680: r_rht c_rht%ROWTYPE;
681: BEGIN
682: hr_utility.set_location(l_proc || 'Entering',10);
683: OPEN c_rht;
684: FETCH c_rht INTO r_rht;
685: CLOSE c_rht;
686: p_user_name := r_rht.user_name;

Line 688: hr_utility.set_location(l_proc || ' order by : ' || r_rht.order_by, 90);

684: FETCH c_rht INTO r_rht;
685: CLOSE c_rht;
686: p_user_name := r_rht.user_name;
687: p_routing_history_id := r_rht.routing_history_id;
688: hr_utility.set_location(l_proc || ' order by : ' || r_rht.order_by, 90);
689: hr_utility.set_location(l_proc || ' Last User : ' || r_rht.user_name, 90);
690: hr_utility.set_location(l_proc || 'Exiting',100);
691: exception when others then
692: p_routing_history_id := null;

Line 689: hr_utility.set_location(l_proc || ' Last User : ' || r_rht.user_name, 90);

685: CLOSE c_rht;
686: p_user_name := r_rht.user_name;
687: p_routing_history_id := r_rht.routing_history_id;
688: hr_utility.set_location(l_proc || ' order by : ' || r_rht.order_by, 90);
689: hr_utility.set_location(l_proc || ' Last User : ' || r_rht.user_name, 90);
690: hr_utility.set_location(l_proc || 'Exiting',100);
691: exception when others then
692: p_routing_history_id := null;
693: p_user_name := null;

Line 690: hr_utility.set_location(l_proc || 'Exiting',100);

686: p_user_name := r_rht.user_name;
687: p_routing_history_id := r_rht.routing_history_id;
688: hr_utility.set_location(l_proc || ' order by : ' || r_rht.order_by, 90);
689: hr_utility.set_location(l_proc || ' Last User : ' || r_rht.user_name, 90);
690: hr_utility.set_location(l_proc || 'Exiting',100);
691: exception when others then
692: p_routing_history_id := null;
693: p_user_name := null;
694: raise;

Line 746: hr_utility.set_location(l_proc || 'Entering',10);

742: l_transaction_id NUMBER;
743: l_user VARCHAR2(100);
744: l_proc VARCHAR2(61) := g_package || 'get_last_user';
745: BEGIN
746: hr_utility.set_location(l_proc || 'Entering',10);
747: decode_itemkey(
748: p_itemkey => p_itemkey
749: , p_transaction_category_id => l_transaction_category_id
750: , p_transaction_id => l_transaction_id

Line 756: hr_utility.set_location(l_proc || ' Exiting',100);

752: l_user := get_last_user(
753: p_transaction_category_id => l_transaction_category_id
754: , p_transaction_id => l_transaction_id
755: );
756: hr_utility.set_location(l_proc || ' Exiting',100);
757: RETURN l_user;
758: END;
759: --
760: -- Get Approver's user name

Line 781: hr_utility.set_location(l_proc || ' Entering',10);

777: AND transaction_id = p_transaction_id
778: AND approval_cd = 'APPROVED'
779: ORDER BY routing_history_id DESC;
780: BEGIN
781: hr_utility.set_location(l_proc || ' Entering',10);
782: OPEN c_rht;
783: FETCH c_rht INTO l_user;
784: CLOSE c_rht;
785: hr_utility.set_location(l_proc || ' Approver : ' || l_user, 90);

Line 785: hr_utility.set_location(l_proc || ' Approver : ' || l_user, 90);

781: hr_utility.set_location(l_proc || ' Entering',10);
782: OPEN c_rht;
783: FETCH c_rht INTO l_user;
784: CLOSE c_rht;
785: hr_utility.set_location(l_proc || ' Approver : ' || l_user, 90);
786: hr_utility.set_location(l_proc || ' Exiting',100);
787: RETURN l_user;
788: END;
789:

Line 786: hr_utility.set_location(l_proc || ' Exiting',100);

782: OPEN c_rht;
783: FETCH c_rht INTO l_user;
784: CLOSE c_rht;
785: hr_utility.set_location(l_proc || ' Approver : ' || l_user, 90);
786: hr_utility.set_location(l_proc || ' Exiting',100);
787: RETURN l_user;
788: END;
789:
790: FUNCTION get_approver (

Line 800: hr_utility.set_location(l_proc || ' Entering',10);

796: l_transaction_id NUMBER;
797: l_user VARCHAR2(100);
798: l_proc VARCHAR2(61) := g_package || 'get_approver';
799: BEGIN
800: hr_utility.set_location(l_proc || ' Entering',10);
801: decode_itemkey(
802: p_itemkey => p_itemkey
803: , p_transaction_category_id => l_transaction_category_id
804: , p_transaction_id => l_transaction_id

Line 810: hr_utility.set_location(l_proc || ' Exiting',100);

806: l_user := get_approver(
807: p_transaction_category_id => l_transaction_category_id
808: , p_transaction_id => l_transaction_id
809: );
810: hr_utility.set_location(l_proc || ' Exiting',100);
811: RETURN l_user;
812: END;
813: --
814: -- Get Requestor's Routing History

Line 845: hr_utility.set_location(l_proc || ' Entering',10);

841: WHERE transaction_category_id = p_transaction_category_id
842: AND transaction_id = p_transaction_id
843: );
844: BEGIN
845: hr_utility.set_location(l_proc || ' Entering',10);
846: OPEN c_rht;
847: FETCH c_rht INTO
848: p_user_name
849: , p_forwarded_by_assignment_id

Line 855: hr_utility.set_location(l_proc || ' Exiting',100);

851: , p_forwarded_by_position_id
852: , p_forwarded_by_user_id
853: , p_forwarded_by_role_id;
854: CLOSE c_rht;
855: hr_utility.set_location(l_proc || ' Exiting',100);
856: exception when others then
857: p_user_name := null;
858: p_forwarded_by_assignment_id := null;
859: p_forwarded_by_member_id := null;

Line 883: hr_utility.set_location(l_proc || ' Entering',10);

879: l_forwarded_by_user_id NUMBER;
880: l_forwarded_by_role_id NUMBER;
881:
882: BEGIN
883: hr_utility.set_location(l_proc || ' Entering',10);
884: get_requestor_history(
885: p_transaction_category_id => p_transaction_category_id
886: , p_transaction_id => p_transaction_id
887: , p_user_name => l_user

Line 895: hr_utility.set_location(l_proc || ' Exiting',100);

891: , p_forwarded_by_user_id => l_forwarded_by_user_id
892: , p_forwarded_by_role_id => l_forwarded_by_role_id
893: );
894:
895: hr_utility.set_location(l_proc || ' Exiting',100);
896: hr_utility.set_location(l_proc || ' Requestor : ' || l_user, 90);
897: RETURN l_user;
898: END;
899:

Line 896: hr_utility.set_location(l_proc || ' Requestor : ' || l_user, 90);

892: , p_forwarded_by_role_id => l_forwarded_by_role_id
893: );
894:
895: hr_utility.set_location(l_proc || ' Exiting',100);
896: hr_utility.set_location(l_proc || ' Requestor : ' || l_user, 90);
897: RETURN l_user;
898: END;
899:
900: FUNCTION get_requestor (

Line 910: hr_utility.set_location(l_proc || ' Entering',10);

906: l_transaction_id NUMBER;
907: l_user VARCHAR2(100);
908: l_proc VARCHAR2(61) := g_package || 'get_requestor';
909: BEGIN
910: hr_utility.set_location(l_proc || ' Entering',10);
911: decode_itemkey(
912: p_itemkey => p_itemkey
913: , p_transaction_category_id => l_transaction_category_id
914: , p_transaction_id => l_transaction_id

Line 920: hr_utility.set_location(l_proc || ' Exiting',100);

916: l_user := get_requestor(
917: p_transaction_category_id => l_transaction_category_id
918: , p_transaction_id => l_transaction_id
919: );
920: hr_utility.set_location(l_proc || ' Exiting',100);
921: RETURN l_user;
922: END;
923: --
924: -- Get workflow information based on transaction category

Line 953: hr_utility.set_location(l_proc || ' Entering',10);

949: FROM pqh_transaction_categories tct
950: WHERE transaction_category_id = p_transaction_category_id;
951: r_txn_cat c_txn_cat%ROWTYPE;
952: BEGIN
953: hr_utility.set_location(l_proc || ' Entering',10);
954: IF p_transaction_category_id IS NULL then
955: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
956: hr_utility.raise_error;
957: END IF;

Line 955: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');

951: r_txn_cat c_txn_cat%ROWTYPE;
952: BEGIN
953: hr_utility.set_location(l_proc || ' Entering',10);
954: IF p_transaction_category_id IS NULL then
955: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
956: hr_utility.raise_error;
957: END IF;
958: OPEN c_txn_cat(p_transaction_category_id => p_transaction_category_id);
959: FETCH c_txn_cat INTO r_txn_cat;

Line 956: hr_utility.raise_error;

952: BEGIN
953: hr_utility.set_location(l_proc || ' Entering',10);
954: IF p_transaction_category_id IS NULL then
955: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
956: hr_utility.raise_error;
957: END IF;
958: OPEN c_txn_cat(p_transaction_category_id => p_transaction_category_id);
959: FETCH c_txn_cat INTO r_txn_cat;
960: CLOSE c_txn_cat;

Line 970: hr_utility.set_location(l_proc || 'Exiting',100);

966: p_post_txn_function := r_txn_cat.post_txn_function;
967: p_post_style_cd := r_txn_cat.post_style_cd;
968: p_future_action_cd := r_txn_cat.future_action_cd;
969: p_short_name := r_txn_cat.short_name;
970: hr_utility.set_location(l_proc || 'Exiting',100);
971: exception when others then
972: p_transaction_category_name := null;
973: p_workflow_name := null;
974: p_process_name := null;

Line 1020: hr_utility.set_location(l_proc || ' Entering',10);

1016: )
1017: IS
1018: l_proc VARCHAR2(61) := g_package || 'set_fyi_user';
1019: BEGIN
1020: hr_utility.set_location(l_proc || ' Entering',10);
1021: hr_utility.set_location(l_proc || ' p_fyi_user '|| p_fyi_user,20);
1022: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1023: itemkey => p_ItemKey,
1024: aname => 'FYI_USER',

Line 1021: hr_utility.set_location(l_proc || ' p_fyi_user '|| p_fyi_user,20);

1017: IS
1018: l_proc VARCHAR2(61) := g_package || 'set_fyi_user';
1019: BEGIN
1020: hr_utility.set_location(l_proc || ' Entering',10);
1021: hr_utility.set_location(l_proc || ' p_fyi_user '|| p_fyi_user,20);
1022: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1023: itemkey => p_ItemKey,
1024: aname => 'FYI_USER',
1025: avalue => p_fyi_user );

Line 1026: hr_utility.set_location(l_proc || ' Exiting',100);

1022: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1023: itemkey => p_ItemKey,
1024: aname => 'FYI_USER',
1025: avalue => p_fyi_user );
1026: hr_utility.set_location(l_proc || ' Exiting',100);
1027: END;
1028: PROCEDURE SET_FYI_USER (
1029: p_transaction_category_id in number
1030: , p_transaction_id in number

Line 1046: hr_utility.set_location(l_proc || ' Entering',10);

1042: l_future_action_cd VARCHAR2(30);
1043: l_post_style_cd VARCHAR2(30);
1044: l_proc VARCHAR2(61) := g_package || 'set_fyi_user';
1045: BEGIN
1046: hr_utility.set_location(l_proc || ' Entering',10);
1047: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
1048:
1049: get_workflow_info(p_transaction_category_id => p_transaction_category_id
1050: , p_transaction_category_name => l_transaction_category_name

Line 1065: hr_utility.set_location(l_proc || ' Exiting',100);

1061: p_itemtype => l_workflow_name
1062: , p_itemkey => l_itemkey
1063: , p_fyi_user => p_fyi_user
1064: );
1065: hr_utility.set_location(l_proc || ' Exiting',100);
1066: END;
1067: --
1068: -- Set next user and status
1069: --

Line 1080: hr_utility.set_location(l_proc || ' Entering',10);

1076: IS
1077: l_proc VARCHAR2(61) := g_package || 'set_next_user';
1078: l_status VARCHAR2(30) := p_status;
1079: BEGIN
1080: hr_utility.set_location(l_proc || ' Entering',10);
1081: hr_utility.set_location(l_proc || ' p_route_to_user '|| p_route_to_user,20);
1082: hr_utility.set_location(l_proc || 'p_status '|| p_status,30);
1083: IF NOT wf_process_not_running (p_itemkey => p_itemkey
1084: , p_itemtype => p_itemtype) THEN

Line 1081: hr_utility.set_location(l_proc || ' p_route_to_user '|| p_route_to_user,20);

1077: l_proc VARCHAR2(61) := g_package || 'set_next_user';
1078: l_status VARCHAR2(30) := p_status;
1079: BEGIN
1080: hr_utility.set_location(l_proc || ' Entering',10);
1081: hr_utility.set_location(l_proc || ' p_route_to_user '|| p_route_to_user,20);
1082: hr_utility.set_location(l_proc || 'p_status '|| p_status,30);
1083: IF NOT wf_process_not_running (p_itemkey => p_itemkey
1084: , p_itemtype => p_itemtype) THEN
1085: IF p_route_to_user IS NOT NULL THEN

Line 1082: hr_utility.set_location(l_proc || 'p_status '|| p_status,30);

1078: l_status VARCHAR2(30) := p_status;
1079: BEGIN
1080: hr_utility.set_location(l_proc || ' Entering',10);
1081: hr_utility.set_location(l_proc || ' p_route_to_user '|| p_route_to_user,20);
1082: hr_utility.set_location(l_proc || 'p_status '|| p_status,30);
1083: IF NOT wf_process_not_running (p_itemkey => p_itemkey
1084: , p_itemtype => p_itemtype) THEN
1085: IF p_route_to_user IS NOT NULL THEN
1086: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 1104: hr_utility.set_location(l_proc || ' Exiting',100);

1100: aname => 'NEXT_USER_STATUS',
1101: avalue => 'NOT_FOUND' );
1102: END IF;
1103: END IF;
1104: hr_utility.set_location(l_proc || ' Exiting',100);
1105: END;
1106: PROCEDURE SET_NEXT_USER (
1107: p_transaction_category_id in number
1108: , p_transaction_id in number

Line 1125: hr_utility.set_location(l_proc || ' Entering',10);

1121: l_future_action_cd VARCHAR2(30);
1122: l_post_style_cd VARCHAR2(30);
1123: l_proc VARCHAR2(61) := g_package || 'set_next_user';
1124: BEGIN
1125: hr_utility.set_location(l_proc || ' Entering',10);
1126: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
1127:
1128: get_workflow_info(p_transaction_category_id => p_transaction_category_id
1129: , p_transaction_category_name => l_transaction_category_name

Line 1145: hr_utility.set_location(l_proc || ' Exiting',100);

1141: , p_itemkey => l_itemkey
1142: , p_route_to_user => p_route_to_user
1143: , p_status => p_status
1144: );
1145: hr_utility.set_location(l_proc || ' Exiting',100);
1146: END;
1147: --
1148: -- Dummy Post Transaction Function
1149: --

Line 1209: hr_utility.set_location(l_proc || ' Entering',10);

1205: l_proc VARCHAR2(61) := g_package || 'StartProcess';
1206: l_form_name VARCHAR2(100) := p_form_name;
1207: l_timeout_days number ;
1208: Begin
1209: hr_utility.set_location(l_proc || ' Entering',10);
1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);

Line 1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);

1206: l_form_name VARCHAR2(100) := p_form_name;
1207: l_timeout_days number ;
1208: Begin
1209: hr_utility.set_location(l_proc || ' Entering',10);
1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);

Line 1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);

1207: l_timeout_days number ;
1208: Begin
1209: hr_utility.set_location(l_proc || ' Entering',10);
1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);

Line 1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);

1208: Begin
1209: hr_utility.set_location(l_proc || ' Entering',10);
1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);

Line 1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);

1209: hr_utility.set_location(l_proc || ' Entering',10);
1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);

Line 1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);

1210: hr_utility.set_location(l_proc || ' Params - p_itemkey '|| p_itemkey,15);
1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);

Line 1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);

1211: hr_utility.set_location(l_proc || ' Params - p_itemtype '|| p_itemtype,15);
1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);

Line 1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);

1212: hr_utility.set_location(l_proc || ' Params - p_process name '|| p_process_name,15);
1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);

Line 1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);

1213: hr_utility.set_location(l_proc || ' Params - p_route_to_user '|| p_route_to_user,15);
1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);
1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);

Line 1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);

1214: hr_utility.set_location(l_proc || ' Params - p_user_status '|| p_user_status,15);
1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);
1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);
1222: -- as timeout is in days as per our transaction category form, while

Line 1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);

1215: hr_utility.set_location(l_proc || ' Params - p_timeout_days '|| to_char(p_timeout_days),15);
1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);
1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);
1222: -- as timeout is in days as per our transaction category form, while
1223: -- workflow keeps the timeout in minutes making changes .

Line 1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);

1216: hr_utility.set_location(l_proc || ' Params - p_form_name '|| p_form_name,15);
1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);
1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);
1222: -- as timeout is in days as per our transaction category form, while
1223: -- workflow keeps the timeout in minutes making changes .
1224: l_timeout_days := nvl(p_timeout_days,0) * 24 * 60;

Line 1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);

1217: hr_utility.set_location(l_proc || ' Params - p_transaction_id '|| to_char(p_transaction_id) || ' '||l_proc,15);
1218: hr_utility.set_location(l_proc || ' Params - p_transaction_category_id '|| to_char(p_transaction_category_id),15);
1219: hr_utility.set_location(l_proc || ' Params - p_post_txn_function '|| p_post_txn_function,15);
1220: hr_utility.set_location(l_proc || ' Params - p_future_action_cd '|| p_future_action_cd,15);
1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);
1222: -- as timeout is in days as per our transaction category form, while
1223: -- workflow keeps the timeout in minutes making changes .
1224: l_timeout_days := nvl(p_timeout_days,0) * 24 * 60;
1225: wf_engine.createProcess( ItemType => p_itemtype,

Line 1228: hr_utility.set_location(l_proc || ' Set timeout',15);

1224: l_timeout_days := nvl(p_timeout_days,0) * 24 * 60;
1225: wf_engine.createProcess( ItemType => p_itemtype,
1226: ItemKey => p_ItemKey,
1227: process => p_process_name );
1228: hr_utility.set_location(l_proc || ' Set timeout',15);
1229: wf_engine.SetItemAttrNumber(itemtype => p_itemtype
1230: , itemkey => p_itemkey
1231: , aname => 'TIMEOUT_DAYS'
1232: , avalue => l_timeout_days);

Line 1249: hr_utility.set_location('launch url is being set',50);

1245: wf_engine.SetItemAttrText( itemtype => p_itemtype
1246: , itemkey => p_itemkey
1247: , aname => 'TRANSACTION_NAME'
1248: , avalue => p_transaction_name);
1249: hr_utility.set_location('launch url is being set',50);
1250: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1251: itemkey => p_itemkey,
1252: aname => 'LAUNCH_URL',
1253: avalue => p_launch_url);

Line 1261: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);

1257: avalue => p_transaction_category_name);
1258:
1259: l_form_name := l_form_name || ':TRANSACTION_ID=' || to_char(p_transaction_id) || ' ROUTING_HISTORY_ID='||to_char(nvl(p_routing_history_id, 0));
1260:
1261: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);
1262:
1263: wf_engine.SetItemAttrText(itemtype => p_itemtype
1264: , itemkey => p_itemkey
1265: , aname => 'RHT_FORM_NAME'

Line 1385: hr_utility.set_location(l_proc || ' p_route_to_user' || p_route_to_user,15);

1381: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1382: itemkey => p_itemkey,
1383: aname => 'PARAMETER10_VALUE',
1384: avalue => p_parameter10_value);
1385: hr_utility.set_location(l_proc || ' p_route_to_user' || p_route_to_user,15);
1386: hr_utility.set_location(l_proc || ' p_user_status ' || p_user_status,15);
1387: IF p_route_to_user IS NOT NULL THEN
1388: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1389: itemkey => p_ItemKey,

Line 1386: hr_utility.set_location(l_proc || ' p_user_status ' || p_user_status,15);

1382: itemkey => p_itemkey,
1383: aname => 'PARAMETER10_VALUE',
1384: avalue => p_parameter10_value);
1385: hr_utility.set_location(l_proc || ' p_route_to_user' || p_route_to_user,15);
1386: hr_utility.set_location(l_proc || ' p_user_status ' || p_user_status,15);
1387: IF p_route_to_user IS NOT NULL THEN
1388: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1389: itemkey => p_ItemKey,
1390: aname => 'ROUTE_TO_USER',

Line 1402: hr_utility.set_location(l_proc || ' Start Process',15);

1398: itemkey => p_ItemKey,
1399: aname => 'NEXT_USER_STATUS',
1400: avalue => 'NOT_FOUND' );
1401: END IF;
1402: hr_utility.set_location(l_proc || ' Start Process',15);
1403: wf_engine.StartProcess ( ItemType => p_itemtype,
1404: ItemKey => p_ItemKey );
1405: hr_utility.set_location(l_proc || ' Exiting ',100);
1406: End;

Line 1405: hr_utility.set_location(l_proc || ' Exiting ',100);

1401: END IF;
1402: hr_utility.set_location(l_proc || ' Start Process',15);
1403: wf_engine.StartProcess ( ItemType => p_itemtype,
1404: ItemKey => p_ItemKey );
1405: hr_utility.set_location(l_proc || ' Exiting ',100);
1406: End;
1407: PROCEDURE get_apply_error(p_itemkey IN VARCHAR2,
1408: p_workflow_name IN VARCHAR2,
1409: p_apply_error_mesg OUT NOCOPY VARCHAR2,

Line 1414: hr_utility.set_location(l_proc || ' Entering',10);

1410: p_apply_error_num OUT NOCOPY VARCHAR2)
1411: IS
1412: l_proc varchar2(61) := g_package ||'get_error' ;
1413: BEGIN
1414: hr_utility.set_location(l_proc || ' Entering',10);
1415: p_apply_error_mesg := wf_engine.GetItemAttrText(
1416: itemtype => p_workflow_name,
1417: itemkey => p_itemkey,
1418: aname => 'APPLY_ERROR_MESG');

Line 1419: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,1,26),20);

1415: p_apply_error_mesg := wf_engine.GetItemAttrText(
1416: itemtype => p_workflow_name,
1417: itemkey => p_itemkey,
1418: aname => 'APPLY_ERROR_MESG');
1419: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,1,26),20);
1420: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,27,26),21);
1421: p_apply_error_num := wf_engine.GetItemAttrText(
1422: itemtype => p_workflow_name,
1423: itemkey => p_itemkey,

Line 1420: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,27,26),21);

1416: itemtype => p_workflow_name,
1417: itemkey => p_itemkey,
1418: aname => 'APPLY_ERROR_MESG');
1419: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,1,26),20);
1420: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,27,26),21);
1421: p_apply_error_num := wf_engine.GetItemAttrText(
1422: itemtype => p_workflow_name,
1423: itemkey => p_itemkey,
1424: aname => 'APPLY_ERROR_NUM');

Line 1425: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);

1421: p_apply_error_num := wf_engine.GetItemAttrText(
1422: itemtype => p_workflow_name,
1423: itemkey => p_itemkey,
1424: aname => 'APPLY_ERROR_NUM');
1425: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);
1426: hr_utility.set_location(l_proc || ' Exiting',100);
1427: END;
1428:
1429: PROCEDURE set_apply_error(p_itemkey IN VARCHAR2,

Line 1426: hr_utility.set_location(l_proc || ' Exiting',100);

1422: itemtype => p_workflow_name,
1423: itemkey => p_itemkey,
1424: aname => 'APPLY_ERROR_NUM');
1425: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);
1426: hr_utility.set_location(l_proc || ' Exiting',100);
1427: END;
1428:
1429: PROCEDURE set_apply_error(p_itemkey IN VARCHAR2,
1430: p_workflow_name IN VARCHAR2,

Line 1435: hr_utility.set_location(l_proc || ' Entering',10);

1431: p_apply_error_mesg IN VARCHAR2,
1432: p_apply_error_num IN VARCHAR2) IS
1433: l_proc varchar2(61) := g_package ||'set_error' ;
1434: BEGIN
1435: hr_utility.set_location(l_proc || ' Entering',10);
1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);

Line 1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);

1432: p_apply_error_num IN VARCHAR2) IS
1433: l_proc varchar2(61) := g_package ||'set_error' ;
1434: BEGIN
1435: hr_utility.set_location(l_proc || ' Entering',10);
1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);

Line 1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);

1433: l_proc varchar2(61) := g_package ||'set_error' ;
1434: BEGIN
1435: hr_utility.set_location(l_proc || ' Entering',10);
1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);
1441: wf_engine.SetItemAttrText(

Line 1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);

1434: BEGIN
1435: hr_utility.set_location(l_proc || ' Entering',10);
1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);
1441: wf_engine.SetItemAttrText(
1442: itemtype => p_workflow_name,

Line 1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);

1435: hr_utility.set_location(l_proc || ' Entering',10);
1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);
1441: wf_engine.SetItemAttrText(
1442: itemtype => p_workflow_name,
1443: itemkey => p_itemkey,

Line 1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);

1436: hr_utility.set_location(l_proc || ' itemkey'||p_itemkey,20);
1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);
1441: wf_engine.SetItemAttrText(
1442: itemtype => p_workflow_name,
1443: itemkey => p_itemkey,
1444: aname => 'APPLY_ERROR_MESG',

Line 1446: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),35);

1442: itemtype => p_workflow_name,
1443: itemkey => p_itemkey,
1444: aname => 'APPLY_ERROR_MESG',
1445: avalue => p_apply_error_mesg);
1446: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),35);
1447: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),35);
1448: wf_engine.SetItemAttrText(
1449: itemtype => p_workflow_name,
1450: itemkey => p_itemkey,

Line 1447: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),35);

1443: itemkey => p_itemkey,
1444: aname => 'APPLY_ERROR_MESG',
1445: avalue => p_apply_error_mesg);
1446: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),35);
1447: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),35);
1448: wf_engine.SetItemAttrText(
1449: itemtype => p_workflow_name,
1450: itemkey => p_itemkey,
1451: aname => 'APPLY_ERROR_NUM',

Line 1453: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,38);

1449: itemtype => p_workflow_name,
1450: itemkey => p_itemkey,
1451: aname => 'APPLY_ERROR_NUM',
1452: avalue => p_apply_error_num);
1453: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,38);
1454: hr_utility.set_location(l_proc || ' Exiting',100);
1455: END;
1456:
1457: function get_notification_detail(p_itemkey in varchar2,

Line 1454: hr_utility.set_location(l_proc || ' Exiting',100);

1450: itemkey => p_itemkey,
1451: aname => 'APPLY_ERROR_NUM',
1452: avalue => p_apply_error_num);
1453: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,38);
1454: hr_utility.set_location(l_proc || ' Exiting',100);
1455: END;
1456:
1457: function get_notification_detail(p_itemkey in varchar2,
1458: p_mode in varchar2) return varchar2 is

Line 1597: hr_utility.set_location(l_proc || ' Entering',10);

1593: BEGIN
1594: --
1595: -- Print parameters for debugging
1596: --
1597: hr_utility.set_location(l_proc || ' Entering',10);
1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);

Line 1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);

1594: --
1595: -- Print parameters for debugging
1596: --
1597: hr_utility.set_location(l_proc || ' Entering',10);
1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);

Line 1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);

1595: -- Print parameters for debugging
1596: --
1597: hr_utility.set_location(l_proc || ' Entering',10);
1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);

Line 1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);

1596: --
1597: hr_utility.set_location(l_proc || ' Entering',10);
1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);

Line 1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);

1597: hr_utility.set_location(l_proc || ' Entering',10);
1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);

Line 1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);

1598: hr_utility.set_location(l_proc || ' Parameter - p_transaction_category_id = ' || to_char(p_transaction_category_id), 15);
1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);

Line 1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);

1599: hr_utility.set_location(l_proc || ' Parameter - p_transaction_id = ' || to_char(p_transaction_id), 20);
1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);

Line 1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);

1600: hr_utility.set_location(l_proc || ' Parameter - p_routing_category_id = '|| to_char(p_routing_category_id), 25);
1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);

Line 1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);

1601: hr_utility.set_location(l_proc || ' Parameter - p_user_action_cd = ' || p_user_action_cd, 30);
1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);

Line 1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);

1602: hr_utility.set_location(l_proc || ' Parameter - p_route_to_user = ' || p_route_to_user, 35);
1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);

Line 1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);

1603: hr_utility.set_location(l_proc || ' Parameter - to_role = ' || p_forwarded_to_role_id, 35);
1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);
1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);

Line 1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);

1604: hr_utility.set_location(l_proc || ' Parameter - to_user = ' || p_forwarded_to_user_id, 35);
1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);
1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);
1612: --

Line 1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);

1605: hr_utility.set_location(l_proc || ' Parameter - to_position = ' || p_forwarded_to_position_id, 35);
1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);
1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);
1612: --
1613: -- Return if Save and Continue selected

Line 1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);

1606: hr_utility.set_location(l_proc || ' Parameter - to_assignment = ' || p_forwarded_to_assignment_id, 35);
1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);
1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);
1612: --
1613: -- Return if Save and Continue selected
1614: --

Line 1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);

1607: hr_utility.set_location(l_proc || ' Parameter - p_user_status = ' || p_user_status, 40);
1608: hr_utility.set_location(l_proc || ' Parameter - p_pos_structure_version_id= ' || to_char(p_pos_structure_version_id), 45);
1609: hr_utility.set_location(l_proc || ' Parameter - p_comments = ' || substr(p_comments,1,20), 50);
1610: hr_utility.set_location(l_proc || ' Parameter - p_member_cd = ' || p_member_cd, 55);
1611: hr_utility.set_location(l_proc || ' Parameter - p_transaction_name = ' || substr(p_transaction_name,1,20), 57);
1612: --
1613: -- Return if Save and Continue selected
1614: --
1615: IF l_user_action_cd = 'SAVE' THEN

Line 1630: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');

1626: -- Check transaction category and transaction id before continueing
1627: --
1628: IF p_transaction_category_id IS NULL
1629: OR p_transaction_id IS NULL THEN
1630: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
1631: hr_utility.raise_error;
1632: END IF;
1633: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
1634: --

Line 1631: hr_utility.raise_error;

1627: --
1628: IF p_transaction_category_id IS NULL
1629: OR p_transaction_id IS NULL THEN
1630: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
1631: hr_utility.raise_error;
1632: END IF;
1633: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
1634: --
1635: -- Currently only for FYI Notifications.

Line 1639: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');

1635: -- Currently only for FYI Notifications.
1636: --
1637: IF l_user_action_cd in ('FYI_NOT','PQH_BPR')THEN
1638: if p_workflow_seq_no = 0 THEN
1639: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');
1640: hr_utility.raise_error;
1641: END IF;
1642: else
1643: if p_workflow_seq_no <> 0 THEN

Line 1640: hr_utility.raise_error;

1636: --
1637: IF l_user_action_cd in ('FYI_NOT','PQH_BPR')THEN
1638: if p_workflow_seq_no = 0 THEN
1639: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');
1640: hr_utility.raise_error;
1641: END IF;
1642: else
1643: if p_workflow_seq_no <> 0 THEN
1644: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');

Line 1644: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');

1640: hr_utility.raise_error;
1641: END IF;
1642: else
1643: if p_workflow_seq_no <> 0 THEN
1644: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');
1645: hr_utility.raise_error;
1646: END IF;
1647: END IF;
1648:

Line 1645: hr_utility.raise_error;

1641: END IF;
1642: else
1643: if p_workflow_seq_no <> 0 THEN
1644: hr_utility.set_message(8302,'PQH_FYI_NOT_THEN_SEQ_NO_ZERO');
1645: hr_utility.raise_error;
1646: END IF;
1647: END IF;
1648:
1649: if nvl(p_workflow_seq_no, 0) <> 0 then

Line 1674: hr_utility.set_Location('build the url',25);

1670:
1671: l_wf_not_running := wf_process_not_running (p_itemkey => l_itemkey
1672: , p_itemtype => l_workflow_name);
1673: if l_short_name ='PQH_BPR' then
1674: hr_utility.set_Location('build the url',25);
1675: l_url := pqh_bdgt_realloc_utility.url_builder(p_transaction_id => p_transaction_id);
1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);
1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);
1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);

Line 1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);

1672: , p_itemtype => l_workflow_name);
1673: if l_short_name ='PQH_BPR' then
1674: hr_utility.set_Location('build the url',25);
1675: l_url := pqh_bdgt_realloc_utility.url_builder(p_transaction_id => p_transaction_id);
1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);
1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);
1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);
1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);
1680: end if;

Line 1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);

1673: if l_short_name ='PQH_BPR' then
1674: hr_utility.set_Location('build the url',25);
1675: l_url := pqh_bdgt_realloc_utility.url_builder(p_transaction_id => p_transaction_id);
1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);
1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);
1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);
1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);
1680: end if;
1681: IF l_user_action_cd = 'APPLY' THEN

Line 1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);

1674: hr_utility.set_Location('build the url',25);
1675: l_url := pqh_bdgt_realloc_utility.url_builder(p_transaction_id => p_transaction_id);
1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);
1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);
1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);
1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);
1680: end if;
1681: IF l_user_action_cd = 'APPLY' THEN
1682: IF p_effective_date IS NULL THEN

Line 1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);

1675: l_url := pqh_bdgt_realloc_utility.url_builder(p_transaction_id => p_transaction_id);
1676: hr_utility.set_Location('url1 is'||substr(l_url,1,50),26);
1677: hr_utility.set_Location('url2 is'||substr(l_url,51,50),27);
1678: hr_utility.set_Location('url3 is'||substr(l_url,101,50),28);
1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);
1680: end if;
1681: IF l_user_action_cd = 'APPLY' THEN
1682: IF p_effective_date IS NULL THEN
1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');

Line 1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');

1679: hr_utility.set_Location('url4 is'||substr(l_url,151,50),29);
1680: end if;
1681: IF l_user_action_cd = 'APPLY' THEN
1682: IF p_effective_date IS NULL THEN
1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');
1684: hr_utility.raise_error;
1685: END IF;
1686: l_route_to_user := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);

Line 1684: hr_utility.raise_error;

1680: end if;
1681: IF l_user_action_cd = 'APPLY' THEN
1682: IF p_effective_date IS NULL THEN
1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');
1684: hr_utility.raise_error;
1685: END IF;
1686: l_route_to_user := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);
1688: ELSIF l_user_action_cd IN ('FORWARD') THEN

Line 1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);

1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');
1684: hr_utility.raise_error;
1685: END IF;
1686: l_route_to_user := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);
1688: ELSIF l_user_action_cd IN ('FORWARD') THEN
1689: IF p_member_cd = 'R' AND p_forwarded_to_member_id IS NULL THEN
1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');

Line 1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);

1686: l_route_to_user := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);
1688: ELSIF l_user_action_cd IN ('FORWARD') THEN
1689: IF p_member_cd = 'R' AND p_forwarded_to_member_id IS NULL THEN
1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');
1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);

Line 1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');

1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);
1688: ELSIF l_user_action_cd IN ('FORWARD') THEN
1689: IF p_member_cd = 'R' AND p_forwarded_to_member_id IS NULL THEN
1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');
1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');

Line 1692: hr_utility.raise_error;

1688: ELSIF l_user_action_cd IN ('FORWARD') THEN
1689: IF p_member_cd = 'R' AND p_forwarded_to_member_id IS NULL THEN
1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');
1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1696: hr_utility.raise_error;

Line 1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);

1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');
1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1696: hr_utility.raise_error;
1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN

Line 1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');

1691: hr_utility.set_message(8302,'PQH_NULL_MEMBER_ID');
1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1696: hr_utility.raise_error;
1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);

Line 1696: hr_utility.raise_error;

1692: hr_utility.raise_error;
1693: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1694: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1696: hr_utility.raise_error;
1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');

Line 1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);

1695: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1696: hr_utility.raise_error;
1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1701: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1702: hr_utility.raise_error;
1703: END IF;

Line 1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');

1696: hr_utility.raise_error;
1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1701: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1702: hr_utility.raise_error;
1703: END IF;
1704: IF l_route_to_user IS NULL

Line 1701: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);

1697: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1701: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1702: hr_utility.raise_error;
1703: END IF;
1704: IF l_route_to_user IS NULL
1705: OR p_user_status IS NULL THEN

Line 1702: hr_utility.raise_error;

1698: p_pos_structure_version_id IS NULL) THEN
1699: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1700: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1701: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1702: hr_utility.raise_error;
1703: END IF;
1704: IF l_route_to_user IS NULL
1705: OR p_user_status IS NULL THEN
1706: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');

Line 1706: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');

1702: hr_utility.raise_error;
1703: END IF;
1704: IF l_route_to_user IS NULL
1705: OR p_user_status IS NULL THEN
1706: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');
1707: hr_utility.raise_error;
1708: END IF;
1709: ELSIF l_user_action_cd IN ( 'BACK', 'OVERRIDE') THEN
1710: IF p_member_cd = 'R' AND p_forwarded_to_role_id IS NULL THEN

Line 1707: hr_utility.raise_error;

1703: END IF;
1704: IF l_route_to_user IS NULL
1705: OR p_user_status IS NULL THEN
1706: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');
1707: hr_utility.raise_error;
1708: END IF;
1709: ELSIF l_user_action_cd IN ( 'BACK', 'OVERRIDE') THEN
1710: IF p_member_cd = 'R' AND p_forwarded_to_role_id IS NULL THEN
1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);

Line 1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);

1707: hr_utility.raise_error;
1708: END IF;
1709: ELSIF l_user_action_cd IN ( 'BACK', 'OVERRIDE') THEN
1710: IF p_member_cd = 'R' AND p_forwarded_to_role_id IS NULL THEN
1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);
1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');
1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);

Line 1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');

1708: END IF;
1709: ELSIF l_user_action_cd IN ( 'BACK', 'OVERRIDE') THEN
1710: IF p_member_cd = 'R' AND p_forwarded_to_role_id IS NULL THEN
1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);
1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');
1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');

Line 1713: hr_utility.raise_error;

1709: ELSIF l_user_action_cd IN ( 'BACK', 'OVERRIDE') THEN
1710: IF p_member_cd = 'R' AND p_forwarded_to_role_id IS NULL THEN
1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);
1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');
1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1717: hr_utility.raise_error;

Line 1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);

1711: hr_utility.set_location(l_proc || ' PQH_NULL_ROLE_ID', 30);
1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');
1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1717: hr_utility.raise_error;
1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN

Line 1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');

1712: hr_utility.set_message(8302,'PQH_NULL_ROLE_ID');
1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1717: hr_utility.raise_error;
1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);

Line 1717: hr_utility.raise_error;

1713: hr_utility.raise_error;
1714: ELSIF p_member_cd = 'S' AND p_forwarded_to_assignment_id IS NULL THEN
1715: hr_utility.set_location(l_proc || ' PQH_NULL_ASSIGNMENT_ID', 30);
1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1717: hr_utility.raise_error;
1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');

Line 1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);

1716: hr_utility.set_message(8302, 'PQH_NULL_ASSIGNMENT_ID');
1717: hr_utility.raise_error;
1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1722: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1723: hr_utility.raise_error;
1724: END IF;

Line 1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');

1717: hr_utility.raise_error;
1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1722: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1723: hr_utility.raise_error;
1724: END IF;
1725: IF l_route_to_user IS NULL

Line 1722: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);

1718: ELSIF p_member_cd = 'P' AND (p_forwarded_to_position_id IS NULL OR
1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1722: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1723: hr_utility.raise_error;
1724: END IF;
1725: IF l_route_to_user IS NULL
1726: OR p_user_status IS NULL THEN

Line 1723: hr_utility.raise_error;

1719: p_pos_structure_version_id IS NULL) THEN
1720: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 35);
1721: hr_utility.set_message(8302, 'PQH_NULL_POS_OR_STRUCTURE_ID');
1722: hr_utility.set_location(l_proc || ' PQH_NULL_POS_OR_STRUCTURE_ID', 38);
1723: hr_utility.raise_error;
1724: END IF;
1725: IF l_route_to_user IS NULL
1726: OR p_user_status IS NULL THEN
1727: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');

Line 1727: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');

1723: hr_utility.raise_error;
1724: END IF;
1725: IF l_route_to_user IS NULL
1726: OR p_user_status IS NULL THEN
1727: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');
1728: hr_utility.raise_error;
1729: END IF;
1730: ELSIF l_user_action_cd in ('INBOX','DBERROR') THEN
1731: l_route_to_user := nvl(p_route_to_user, fnd_global.user_name );

Line 1728: hr_utility.raise_error;

1724: END IF;
1725: IF l_route_to_user IS NULL
1726: OR p_user_status IS NULL THEN
1727: hr_utility.set_message(8302,'PQH_NULL_DESTINATION');
1728: hr_utility.raise_error;
1729: END IF;
1730: ELSIF l_user_action_cd in ('INBOX','DBERROR') THEN
1731: l_route_to_user := nvl(p_route_to_user, fnd_global.user_name );
1732: hr_utility.set_location(l_proc || ' inbox or dberror'||l_route_to_user, 40);

Line 1732: hr_utility.set_location(l_proc || ' inbox or dberror'||l_route_to_user, 40);

1728: hr_utility.raise_error;
1729: END IF;
1730: ELSIF l_user_action_cd in ('INBOX','DBERROR') THEN
1731: l_route_to_user := nvl(p_route_to_user, fnd_global.user_name );
1732: hr_utility.set_location(l_proc || ' inbox or dberror'||l_route_to_user, 40);
1733: ELSIF l_user_action_cd = 'REJECT' THEN
1734: get_requestor_history(
1735: p_transaction_category_id => p_transaction_category_id
1736: , p_transaction_id => p_transaction_id

Line 1744: hr_utility.set_location(l_proc || 'requestor is '||l_requestor,401);

1740: , p_forwarded_by_position_id => l_forwarded_to_position_id
1741: , p_forwarded_by_user_id => l_forwarded_to_user_id
1742: , p_forwarded_by_role_id => l_forwarded_to_role_id
1743: );
1744: hr_utility.set_location(l_proc || 'requestor is '||l_requestor,401);
1745: l_rejector := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1746: hr_utility.set_location(l_proc || 'rejected by is '||l_rejector,402);
1747: IF l_requestor is null or l_rejector is null then
1748: hr_utility.set_location('requestor or rejector null ', 403);

Line 1746: hr_utility.set_location(l_proc || 'rejected by is '||l_rejector,402);

1742: , p_forwarded_by_role_id => l_forwarded_to_role_id
1743: );
1744: hr_utility.set_location(l_proc || 'requestor is '||l_requestor,401);
1745: l_rejector := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1746: hr_utility.set_location(l_proc || 'rejected by is '||l_rejector,402);
1747: IF l_requestor is null or l_rejector is null then
1748: hr_utility.set_location('requestor or rejector null ', 403);
1749: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
1750: l_forwarded_to_member_id := p_forwarded_to_member_id;

Line 1748: hr_utility.set_location('requestor or rejector null ', 403);

1744: hr_utility.set_location(l_proc || 'requestor is '||l_requestor,401);
1745: l_rejector := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1746: hr_utility.set_location(l_proc || 'rejected by is '||l_rejector,402);
1747: IF l_requestor is null or l_rejector is null then
1748: hr_utility.set_location('requestor or rejector null ', 403);
1749: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
1750: l_forwarded_to_member_id := p_forwarded_to_member_id;
1751: l_forwarded_to_position_id := p_forwarded_to_position_id;
1752: l_forwarded_to_user_id := p_forwarded_to_user_id;

Line 1757: hr_utility.set_location('requestor different than rejector ', 404);

1753: l_forwarded_to_role_id := p_forwarded_to_role_id;
1754: elsif l_requestor <> l_rejector then
1755: -- transaction is to be routed to initiator, but if initiator position is eliminated
1756: -- user should be asked for immediate rejection.
1757: hr_utility.set_location('requestor different than rejector ', 404);
1758: if l_forwarded_to_position_id is not null then
1759: hr_utility.set_location('is sent to pos', 405);
1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);
1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);

Line 1759: hr_utility.set_location('is sent to pos', 405);

1755: -- transaction is to be routed to initiator, but if initiator position is eliminated
1756: -- user should be asked for immediate rejection.
1757: hr_utility.set_location('requestor different than rejector ', 404);
1758: if l_forwarded_to_position_id is not null then
1759: hr_utility.set_location('is sent to pos', 405);
1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);
1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);
1762: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);

Line 1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);

1757: hr_utility.set_location('requestor different than rejector ', 404);
1758: if l_forwarded_to_position_id is not null then
1759: hr_utility.set_location('is sent to pos', 405);
1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);
1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);
1762: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);
1764: l_route_to_user := l_requestor;
1765: l_user_action_cd := 'FRWRD_RJCT';

Line 1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);

1759: hr_utility.set_location('is sent to pos', 405);
1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);
1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);
1762: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);
1764: l_route_to_user := l_requestor;
1765: l_user_action_cd := 'FRWRD_RJCT';
1766: else
1767: hr_utility.set_location(l_proc || 'initiator position eliminated', 42);

Line 1767: hr_utility.set_location(l_proc || 'initiator position eliminated', 42);

1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);
1764: l_route_to_user := l_requestor;
1765: l_user_action_cd := 'FRWRD_RJCT';
1766: else
1767: hr_utility.set_location(l_proc || 'initiator position eliminated', 42);
1768: hr_utility.set_location(l_proc || 'rejecting it right away ', 44);
1769: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
1770: l_forwarded_to_member_id := p_forwarded_to_member_id;
1771: l_forwarded_to_position_id := p_forwarded_to_position_id;

Line 1768: hr_utility.set_location(l_proc || 'rejecting it right away ', 44);

1764: l_route_to_user := l_requestor;
1765: l_user_action_cd := 'FRWRD_RJCT';
1766: else
1767: hr_utility.set_location(l_proc || 'initiator position eliminated', 42);
1768: hr_utility.set_location(l_proc || 'rejecting it right away ', 44);
1769: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
1770: l_forwarded_to_member_id := p_forwarded_to_member_id;
1771: l_forwarded_to_position_id := p_forwarded_to_position_id;
1772: l_forwarded_to_user_id := p_forwarded_to_user_id;

Line 1776: hr_utility.set_location('not being sent to pos', 404);

1772: l_forwarded_to_user_id := p_forwarded_to_user_id;
1773: l_forwarded_to_role_id := p_forwarded_to_role_id;
1774: end if;
1775: else
1776: hr_utility.set_location('not being sent to pos', 404);
1777: l_route_to_user := l_requestor;
1778: l_user_action_cd := 'FRWRD_RJCT';
1779: end if;
1780: ELSE

Line 1781: hr_utility.set_location('requestor same as rejector',405);

1777: l_route_to_user := l_requestor;
1778: l_user_action_cd := 'FRWRD_RJCT';
1779: end if;
1780: ELSE
1781: hr_utility.set_location('requestor same as rejector',405);
1782: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
1783: l_forwarded_to_member_id := p_forwarded_to_member_id;
1784: l_forwarded_to_position_id := p_forwarded_to_position_id;
1785: l_forwarded_to_user_id := p_forwarded_to_user_id;

Line 1788: hr_utility.set_location('action_cd is'||l_user_action_cd, 405);

1784: l_forwarded_to_position_id := p_forwarded_to_position_id;
1785: l_forwarded_to_user_id := p_forwarded_to_user_id;
1786: l_forwarded_to_role_id := p_forwarded_to_role_id;
1787: END IF;
1788: hr_utility.set_location('action_cd is'||l_user_action_cd, 405);
1789: ELSIF l_user_action_cd = 'DELEGATE' THEN
1790: -- check whether the notification already exists or not, if it exists in that case
1791: -- workflow is not to be started for the delegated worksheet but transaction is to be routed
1792: -- to the user recorded in the transaction

Line 1817: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);

1813: l_workflow_name
1814: , l_itemkey
1815: , l_activity
1816: , l_user_action_cd);
1817: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);
1818: end if;
1819: END IF;
1820: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,75);
1821: IF l_user_action_cd NOT IN ('INBOX','DBERROR','FYI_NOT', 'DELEGATE','PQH_BPR') THEN

Line 1820: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,75);

1816: , l_user_action_cd);
1817: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);
1818: end if;
1819: END IF;
1820: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,75);
1821: IF l_user_action_cd NOT IN ('INBOX','DBERROR','FYI_NOT', 'DELEGATE','PQH_BPR') THEN
1822: create_routing_history(
1823: p_transaction_category_id => p_transaction_category_id
1824: , p_transaction_id => p_transaction_id

Line 1854: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);

1850: l_form_name := substr(l_form_name, 1, l_pos - 1);
1851: end if;
1852: l_form_name := l_form_name || ' ROUTING_HISTORY_ID=' || to_char(nvl(l_routing_history_id, 0));
1853:
1854: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);
1855: wf_engine.SetItemAttrText(itemtype => l_workflow_name
1856: , itemkey => l_itemkey
1857: , aname => 'FORM_NAME'
1858: , avalue => l_form_name);

Line 1862: hr_utility.set_location(l_proc || ' Before Start Process called', 35);

1858: , avalue => l_form_name);
1859: END IF;
1860: END IF;
1861: IF l_wf_not_running THEN -- Create a new workflow process
1862: hr_utility.set_location(l_proc || ' Before Start Process called', 35);
1863: hr_utility.set_location(l_proc || ' in - p_route_to_user = ' || p_route_to_user, 36);
1864: hr_utility.set_location(l_proc || ' out - l_route_to_user = ' || l_route_to_user, 37);
1865: StartProcess(
1866: p_itemkey => l_itemkey

Line 1863: hr_utility.set_location(l_proc || ' in - p_route_to_user = ' || p_route_to_user, 36);

1859: END IF;
1860: END IF;
1861: IF l_wf_not_running THEN -- Create a new workflow process
1862: hr_utility.set_location(l_proc || ' Before Start Process called', 35);
1863: hr_utility.set_location(l_proc || ' in - p_route_to_user = ' || p_route_to_user, 36);
1864: hr_utility.set_location(l_proc || ' out - l_route_to_user = ' || l_route_to_user, 37);
1865: StartProcess(
1866: p_itemkey => l_itemkey
1867: , p_itemtype => l_workflow_name

Line 1864: hr_utility.set_location(l_proc || ' out - l_route_to_user = ' || l_route_to_user, 37);

1860: END IF;
1861: IF l_wf_not_running THEN -- Create a new workflow process
1862: hr_utility.set_location(l_proc || ' Before Start Process called', 35);
1863: hr_utility.set_location(l_proc || ' in - p_route_to_user = ' || p_route_to_user, 36);
1864: hr_utility.set_location(l_proc || ' out - l_route_to_user = ' || l_route_to_user, 37);
1865: StartProcess(
1866: p_itemkey => l_itemkey
1867: , p_itemtype => l_workflow_name
1868: , p_process_name => l_process_name

Line 1907: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);

1903: , p_parameter10_name => p_parameter10_name
1904: , p_parameter10_value => p_parameter10_value
1905: );
1906: END IF;
1907: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);
1908: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,50);
1909:
1910: wf_engine.SetItemAttrText( itemtype => l_workflow_name,
1911: itemkey => l_itemkey,

Line 1908: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,50);

1904: , p_parameter10_value => p_parameter10_value
1905: );
1906: END IF;
1907: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);
1908: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,50);
1909:
1910: wf_engine.SetItemAttrText( itemtype => l_workflow_name,
1911: itemkey => l_itemkey,
1912: aname => 'COMMENTS',

Line 1915: hr_utility.set_location(l_proc || ' Completing Activity '||l_activity,60);

1911: itemkey => l_itemkey,
1912: aname => 'COMMENTS',
1913: avalue => p_comments);
1914: IF NOT l_wf_not_running THEN -- Move forward with the existing workflow process
1915: hr_utility.set_location(l_proc || ' Completing Activity '||l_activity,60);
1916: wf_engine.SetItemAttrText(
1917: itemtype => l_workflow_name,
1918: itemkey => l_itemkey,
1919: aname => 'TRAN_CAT_NAME',

Line 1921: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);

1917: itemtype => l_workflow_name,
1918: itemkey => l_itemkey,
1919: aname => 'TRAN_CAT_NAME',
1920: avalue => l_transaction_category_name);
1921: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);
1922: wf_engine.SetItemAttrDate(
1923: itemtype => l_workflow_name,
1924: itemkey => l_itemkey,
1925: aname => 'EFFECTIVE_DATE',

Line 1938: hr_utility.set_location('resetting launch url ',51);

1934: itemkey => l_itemkey,
1935: aname => 'TRANSACTION_NAME',
1936: avalue => p_transaction_name);
1937: --added by kgowripe for fixing 2897321
1938: hr_utility.set_location('resetting launch url ',51);
1939: wf_engine.SetItemAttrText( itemtype => l_workflow_name,
1940: itemkey => l_itemkey,
1941: aname => 'LAUNCH_URL',
1942: avalue => l_url);

Line 1948: hr_utility.set_location(l_proc || ' After setting attributes ',65);

1944: set_apply_error(p_itemkey => l_itemkey,
1945: p_workflow_name => l_workflow_name,
1946: p_apply_error_mesg => l_apply_error_mesg,
1947: p_apply_error_num => l_apply_error_num );
1948: hr_utility.set_location(l_proc || ' After setting attributes ',65);
1949: IF l_user_action_cd IN ('FORWARD', 'BACK', 'OVERRIDE', 'INBOX','DBERROR','DELEGATE', 'FRWRD_RJCT') THEN
1950: set_next_user (
1951: p_itemtype => l_workflow_name
1952: , p_itemkey => l_itemkey

Line 1957: hr_utility.set_location(l_proc || ' After setting user ',67);

1953: , p_route_to_user => l_route_to_user
1954: , p_status => p_user_status
1955: );
1956: END IF;
1957: hr_utility.set_location(l_proc || ' After setting user ',67);
1958: l_activity := get_respond_activity(l_itemkey);
1959: hr_utility.set_location(l_proc || ' activity is '||l_activity,68);
1960: hr_utility.set_location(l_proc || ' action_cd is '||l_user_action_cd,69);
1961: begin

Line 1959: hr_utility.set_location(l_proc || ' activity is '||l_activity,68);

1955: );
1956: END IF;
1957: hr_utility.set_location(l_proc || ' After setting user ',67);
1958: l_activity := get_respond_activity(l_itemkey);
1959: hr_utility.set_location(l_proc || ' activity is '||l_activity,68);
1960: hr_utility.set_location(l_proc || ' action_cd is '||l_user_action_cd,69);
1961: begin
1962: wf_engine.CompleteActivity(
1963: l_workflow_name

Line 1960: hr_utility.set_location(l_proc || ' action_cd is '||l_user_action_cd,69);

1956: END IF;
1957: hr_utility.set_location(l_proc || ' After setting user ',67);
1958: l_activity := get_respond_activity(l_itemkey);
1959: hr_utility.set_location(l_proc || ' activity is '||l_activity,68);
1960: hr_utility.set_location(l_proc || ' action_cd is '||l_user_action_cd,69);
1961: begin
1962: wf_engine.CompleteActivity(
1963: l_workflow_name
1964: , l_itemkey

Line 1969: hr_utility.set_location(l_proc || 'Completed Activity fail'||l_activity,690);

1965: , l_activity
1966: , l_user_action_cd);
1967: exception
1968: when others then
1969: hr_utility.set_location(l_proc || 'Completed Activity fail'||l_activity,690);
1970: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,1,30),691);
1971: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,31,30),692);
1972: end;
1973: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);

Line 1970: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,1,30),691);

1966: , l_user_action_cd);
1967: exception
1968: when others then
1969: hr_utility.set_location(l_proc || 'Completed Activity fail'||l_activity,690);
1970: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,1,30),691);
1971: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,31,30),692);
1972: end;
1973: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);
1974: END IF;

Line 1971: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,31,30),692);

1967: exception
1968: when others then
1969: hr_utility.set_location(l_proc || 'Completed Activity fail'||l_activity,690);
1970: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,1,30),691);
1971: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,31,30),692);
1972: end;
1973: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);
1974: END IF;
1975: get_apply_error(p_itemkey => l_itemkey,

Line 1973: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);

1969: hr_utility.set_location(l_proc || 'Completed Activity fail'||l_activity,690);
1970: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,1,30),691);
1971: hr_utility.set_location(l_proc || ':'||substr(sqlerrm,31,30),692);
1972: end;
1973: hr_utility.set_location(l_proc || 'Completed Activity '||l_activity,70);
1974: END IF;
1975: get_apply_error(p_itemkey => l_itemkey,
1976: p_workflow_name => l_workflow_name,
1977: p_apply_error_mesg => p_apply_error_mesg,

Line 1979: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,80);

1975: get_apply_error(p_itemkey => l_itemkey,
1976: p_workflow_name => l_workflow_name,
1977: p_apply_error_mesg => p_apply_error_mesg,
1978: p_apply_error_num => p_apply_error_num );
1979: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,80);
1980: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),90);
1981:
1982: hr_utility.set_location(l_proc || ' Exiting ',100);
1983: END;

Line 1980: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),90);

1976: p_workflow_name => l_workflow_name,
1977: p_apply_error_mesg => p_apply_error_mesg,
1978: p_apply_error_num => p_apply_error_num );
1979: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,80);
1980: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),90);
1981:
1982: hr_utility.set_location(l_proc || ' Exiting ',100);
1983: END;
1984:

Line 1982: hr_utility.set_location(l_proc || ' Exiting ',100);

1978: p_apply_error_num => p_apply_error_num );
1979: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,80);
1980: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),90);
1981:
1982: hr_utility.set_location(l_proc || ' Exiting ',100);
1983: END;
1984:
1985: PROCEDURE REROUTE_FUTURE_ACTION (
1986: p_transaction_category_id in NUMBER

Line 2004: hr_utility.set_location(l_proc || ' Entering',10);

2000: l_post_txn_function VARCHAR2(61);
2001: l_future_action_cd VARCHAR2(30);
2002: l_post_style_cd VARCHAR2(30);
2003: BEGIN
2004: hr_utility.set_location(l_proc || ' Entering',10);
2005: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2006:
2007: get_workflow_info(p_transaction_category_id => p_transaction_category_id
2008: , p_transaction_category_name => l_transaction_category_name

Line 2029: hr_utility.set_location(l_proc || ' Exiting',100);

2025: l_workflow_name
2026: , l_itemkey
2027: , 'BLOCK'
2028: , 'REROUTE');
2029: hr_utility.set_location(l_proc || ' Exiting',100);
2030: END;
2031: --
2032: -- get last user's response from routing history
2033: --

Line 2047: hr_utility.set_location(l_proc || ' Entering',10);

2043: ORDER BY routing_history_id desc;
2044: r_get_status c_get_status%ROWTYPE;
2045: l_proc VARCHAR2(61) := g_package || 'get_user_response';
2046: BEGIN
2047: hr_utility.set_location(l_proc || ' Entering',10);
2048: OPEN c_get_status;
2049: FETCH c_get_status INTO r_get_status;
2050: CLOSE c_get_status;
2051: hr_utility.set_location(l_proc || ' Exiting',100);

Line 2051: hr_utility.set_location(l_proc || ' Exiting',100);

2047: hr_utility.set_location(l_proc || ' Entering',10);
2048: OPEN c_get_status;
2049: FETCH c_get_status INTO r_get_status;
2050: CLOSE c_get_status;
2051: hr_utility.set_location(l_proc || ' Exiting',100);
2052: RETURN r_get_status.user_action_cd;
2053: END;
2054: --
2055: -- Mark notification as sent

Line 2062: hr_utility.set_location(l_proc || ' Entering',10);

2058: , p_status IN VARCHAR2)
2059: IS
2060: l_proc VARCHAR2(61) := g_package || 'mark_fyi_sent';
2061: BEGIN
2062: hr_utility.set_location(l_proc || ' Entering',10);
2063: UPDATE pqh_fyi_notify
2064: SET status = p_status
2065: , notification_date = sysdate
2066: WHERE fyi_notified_id = p_fyi_notified_id;

Line 2067: hr_utility.set_location(l_proc || ' Exiting',100);

2063: UPDATE pqh_fyi_notify
2064: SET status = p_status
2065: , notification_date = sysdate
2066: WHERE fyi_notified_id = p_fyi_notified_id;
2067: hr_utility.set_location(l_proc || ' Exiting',100);
2068: END;
2069: PROCEDURE CHECK_FYI (
2070: itemtype in varchar2,
2071: itemkey in varchar2,

Line 2095: hr_utility.set_location(l_proc || ' Entering',10);

2091: l_transaction_category_id pqh_routing_history.transaction_category_id%TYPE;
2092: l_user fnd_user.user_name%TYPE;
2093: l_transaction_status VARCHAR2(30);
2094: BEGIN
2095: hr_utility.set_location(l_proc || ' Entering',10);
2096: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2097: IF (FUNCMODE = 'RUN') THEN
2098: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2099: itemkey => ItemKey,

Line 2096: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2092: l_user fnd_user.user_name%TYPE;
2093: l_transaction_status VARCHAR2(30);
2094: BEGIN
2095: hr_utility.set_location(l_proc || ' Entering',10);
2096: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2097: IF (FUNCMODE = 'RUN') THEN
2098: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2099: itemkey => ItemKey,
2100: aname => 'TRANSACTION_STATUS');

Line 2101: hr_utility.set_location(l_proc || ' user action code ' || l_user_action_cd, 25);

2097: IF (FUNCMODE = 'RUN') THEN
2098: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2099: itemkey => ItemKey,
2100: aname => 'TRANSACTION_STATUS');
2101: hr_utility.set_location(l_proc || ' user action code ' || l_user_action_cd, 25);
2102: --ns:26-Jun-2006: Bug 5357676: Set routed_by_user for correct From to appear in fyi notification.
2103: wf_engine.SetItemAttrText(itemtype => itemtype
2104: , itemkey => itemKey
2105: , aname => 'ROUTED_BY_USER'

Line 2112: hr_utility.set_location(l_proc || ' user ' || l_user, 28);

2108: IF l_user_action_cd in ('FYI_NOT','PQH_BPR') THEN
2109: l_user := wf_engine.GetItemAttrText(itemtype => itemtype,
2110: itemkey => ItemKey,
2111: aname => 'ROUTE_TO_USER');
2112: hr_utility.set_location(l_proc || ' user ' || l_user, 28);
2113: SET_FYI_USER (
2114: p_itemtype => itemtype
2115: , p_itemkey => itemkey
2116: , p_fyi_user => l_user

Line 2126: hr_utility.set_location(l_proc || 'Item Key ' || itemkey, 29);

2122: , p_transaction_category_id => l_transaction_category_id
2123: , p_transaction_id => l_transaction_id);
2124: -- l_user_action_cd := get_user_response(p_transaction_category_id => l_transaction_category_id
2125: -- , p_transaction_id => l_transaction_id);
2126: hr_utility.set_location(l_proc || 'Item Key ' || itemkey, 29);
2127: FOR r_get_fyi IN c_get_fyi(p_transaction_category_id => l_transaction_category_id
2128: , p_transaction_id => l_transaction_id)
2129: LOOP
2130: IF r_get_fyi.notified_type_cd = 'APPROVER' THEN

Line 2142: hr_utility.set_location(l_proc || 'for -'||r_get_fyi.fyi_notified_id||' l_user : ' || l_user, 90);

2138: , p_transaction_id => l_transaction_id);
2139: ELSE
2140: l_user := r_get_fyi.notified_name;
2141: END IF;
2142: hr_utility.set_location(l_proc || 'for -'||r_get_fyi.fyi_notified_id||' l_user : ' || l_user, 90);
2143: IF (r_get_fyi.notification_event_cd = 'APPROVAL' AND l_user_action_cd IN ('APPLY', 'OVERRIDE','FORWARD','BACK'))
2144: OR (r_get_fyi.notification_event_cd = 'REJECTION' AND l_user_action_cd = 'REJECT')
2145: OR (r_get_fyi.notification_event_cd = 'DBFAILURE' AND l_user_action_cd = 'DBFAILURE')
2146: OR (r_get_fyi.notification_event_cd = 'DBSUCCESS' AND l_user_action_cd = 'DBSUCCESS')

Line 2159: hr_utility.set_location(l_proc || ' Exiting',10);

2155: );
2156: mark_fyi_sent(p_fyi_notified_id => r_get_fyi.fyi_notified_id
2157: , p_status => 'SENT');
2158: result := 'COMPLETE:SUCCESS';
2159: hr_utility.set_location(l_proc || ' Exiting',10);
2160: RETURN;
2161: END IF;
2162: ELSIF (r_get_fyi.notification_event_cd = 'OVERRIDE' AND l_user_action_cd IN ('APPLY', 'OVERRIDE','FORWARD','BACK'))
2163: THEN

Line 2174: hr_utility.set_location(l_proc || ' Exiting',10);

2170: );
2171: mark_fyi_sent(p_fyi_notified_id => r_get_fyi.fyi_notified_id
2172: , p_status => 'SENT');
2173: result := 'COMPLETE:SUCCESS';
2174: hr_utility.set_location(l_proc || ' Exiting',10);
2175: RETURN;
2176: END IF;
2177: END IF;
2178: END LOOP;

Line 2180: hr_utility.set_location(l_proc || ' Exiting',10);

2176: END IF;
2177: END IF;
2178: END LOOP;
2179: result := 'COMPLETE:FAILURE';
2180: hr_utility.set_location(l_proc || ' Exiting',10);
2181: RETURN;
2182: END IF;
2183: hr_utility.set_location(l_proc || ' Exiting',10);
2184: END;

Line 2183: hr_utility.set_location(l_proc || ' Exiting',10);

2179: result := 'COMPLETE:FAILURE';
2180: hr_utility.set_location(l_proc || ' Exiting',10);
2181: RETURN;
2182: END IF;
2183: hr_utility.set_location(l_proc || ' Exiting',10);
2184: END;
2185:
2186: -- This procedure was added so that workflow definition can be used by Budget reallocation
2187:

Line 2200: hr_utility.set_location(l_proc || ' Entering',10);

2196: l_transaction_category_id number;
2197: l_transaction_id number;
2198: l_short_name pqh_transaction_categories.short_name%type;
2199: BEGIN
2200: hr_utility.set_location(l_proc || ' Entering',10);
2201: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2202: IF (FUNCMODE = 'RUN') THEN
2203: create_process_log('which_txn_cat ' || itemkey);
2204: decode_itemkey(p_itemkey => itemkey

Line 2201: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2197: l_transaction_id number;
2198: l_short_name pqh_transaction_categories.short_name%type;
2199: BEGIN
2200: hr_utility.set_location(l_proc || ' Entering',10);
2201: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2202: IF (FUNCMODE = 'RUN') THEN
2203: create_process_log('which_txn_cat ' || itemkey);
2204: decode_itemkey(p_itemkey => itemkey
2205: ,p_transaction_category_id => l_transaction_category_id

Line 2211: hr_utility.set_location(l_proc || ' short_name '||l_short_name,30);

2207: select short_name into l_short_name
2208: from pqh_transaction_categories
2209: where transaction_category_id = l_transaction_category_id;
2210: result := 'COMPLETE:' || l_short_name;
2211: hr_utility.set_location(l_proc || ' short_name '||l_short_name,30);
2212: hr_utility.set_location(l_proc || ' Exiting ',100);
2213: return;
2214: ELSE
2215: hr_utility.set_location(l_proc || ' Exiting',100);

Line 2212: hr_utility.set_location(l_proc || ' Exiting ',100);

2208: from pqh_transaction_categories
2209: where transaction_category_id = l_transaction_category_id;
2210: result := 'COMPLETE:' || l_short_name;
2211: hr_utility.set_location(l_proc || ' short_name '||l_short_name,30);
2212: hr_utility.set_location(l_proc || ' Exiting ',100);
2213: return;
2214: ELSE
2215: hr_utility.set_location(l_proc || ' Exiting',100);
2216: END IF;

Line 2215: hr_utility.set_location(l_proc || ' Exiting',100);

2211: hr_utility.set_location(l_proc || ' short_name '||l_short_name,30);
2212: hr_utility.set_location(l_proc || ' Exiting ',100);
2213: return;
2214: ELSE
2215: hr_utility.set_location(l_proc || ' Exiting',100);
2216: END IF;
2217: exception when others then
2218: result := null;
2219: raise;

Line 2234: hr_utility.set_location(l_proc || ' Entering',10);

2230: l_user varchar2(30);
2231: l_user_action_cd varchar2(30);
2232: l_proc VARCHAR2(61) := g_package || 'find_notice_type';
2233: BEGIN
2234: hr_utility.set_location(l_proc || ' Entering',10);
2235: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2236: IF (FUNCMODE = 'RUN') THEN
2237: create_process_log('Find Notice_type ' || itemkey);
2238: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2235: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2231: l_user_action_cd varchar2(30);
2232: l_proc VARCHAR2(61) := g_package || 'find_notice_type';
2233: BEGIN
2234: hr_utility.set_location(l_proc || ' Entering',10);
2235: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2236: IF (FUNCMODE = 'RUN') THEN
2237: create_process_log('Find Notice_type ' || itemkey);
2238: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2239: itemkey => ItemKey,

Line 2252: hr_utility.set_location(l_proc || 'user_action_cd'||l_user_action_cd,30);

2248: l_status := 'WARNING';
2249: elsif l_user_action_cd ='DBERROR' then
2250: l_status := 'ERROR';
2251: else
2252: hr_utility.set_location(l_proc || 'user_action_cd'||l_user_action_cd,30);
2253: l_status := 'APPROVE';
2254: end if;
2255: result := 'COMPLETE:' || l_status;
2256: hr_utility.set_location(l_proc || ' l_status '||l_status,30);

Line 2256: hr_utility.set_location(l_proc || ' l_status '||l_status,30);

2252: hr_utility.set_location(l_proc || 'user_action_cd'||l_user_action_cd,30);
2253: l_status := 'APPROVE';
2254: end if;
2255: result := 'COMPLETE:' || l_status;
2256: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2257: hr_utility.set_location(l_proc || ' Exiting ',100);
2258: return;
2259: ELSE
2260: hr_utility.set_location(l_proc || ' Exiting',100);

Line 2257: hr_utility.set_location(l_proc || ' Exiting ',100);

2253: l_status := 'APPROVE';
2254: end if;
2255: result := 'COMPLETE:' || l_status;
2256: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2257: hr_utility.set_location(l_proc || ' Exiting ',100);
2258: return;
2259: ELSE
2260: hr_utility.set_location(l_proc || ' Exiting',100);
2261: END IF;

Line 2260: hr_utility.set_location(l_proc || ' Exiting',100);

2256: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2257: hr_utility.set_location(l_proc || ' Exiting ',100);
2258: return;
2259: ELSE
2260: hr_utility.set_location(l_proc || ' Exiting',100);
2261: END IF;
2262: exception when others then
2263: result := null;
2264: raise;

Line 2281: hr_utility.set_location(l_proc || ' Entering',10);

2277: l_status varchar2(30);
2278: l_user varchar2(30);
2279: l_proc VARCHAR2(61) := g_package || 'find_next_user';
2280: BEGIN
2281: hr_utility.set_location(l_proc || ' Entering',10);
2282: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2283: IF (FUNCMODE = 'RUN') THEN
2284: create_process_log('Find Next User ' || itemkey);
2285: l_status := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2282: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2278: l_user varchar2(30);
2279: l_proc VARCHAR2(61) := g_package || 'find_next_user';
2280: BEGIN
2281: hr_utility.set_location(l_proc || ' Entering',10);
2282: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2283: IF (FUNCMODE = 'RUN') THEN
2284: create_process_log('Find Next User ' || itemkey);
2285: l_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2286: itemkey => ItemKey,

Line 2297: hr_utility.set_location(l_proc || ' l_user ' ||l_user,20);

2293: , avalue => l_user);
2294: END IF;
2295: l_status := NVL(l_status, 'ERROR');
2296: result := 'COMPLETE:' || l_status;
2297: hr_utility.set_location(l_proc || ' l_user ' ||l_user,20);
2298: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2299: hr_utility.set_location(l_proc || ' Exiting ',100);
2300: return;
2301: ELSE

Line 2298: hr_utility.set_location(l_proc || ' l_status '||l_status,30);

2294: END IF;
2295: l_status := NVL(l_status, 'ERROR');
2296: result := 'COMPLETE:' || l_status;
2297: hr_utility.set_location(l_proc || ' l_user ' ||l_user,20);
2298: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2299: hr_utility.set_location(l_proc || ' Exiting ',100);
2300: return;
2301: ELSE
2302: hr_utility.set_location(l_proc || ' Exiting',100);

Line 2299: hr_utility.set_location(l_proc || ' Exiting ',100);

2295: l_status := NVL(l_status, 'ERROR');
2296: result := 'COMPLETE:' || l_status;
2297: hr_utility.set_location(l_proc || ' l_user ' ||l_user,20);
2298: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2299: hr_utility.set_location(l_proc || ' Exiting ',100);
2300: return;
2301: ELSE
2302: hr_utility.set_location(l_proc || ' Exiting',100);
2303: END IF;

Line 2302: hr_utility.set_location(l_proc || ' Exiting',100);

2298: hr_utility.set_location(l_proc || ' l_status '||l_status,30);
2299: hr_utility.set_location(l_proc || ' Exiting ',100);
2300: return;
2301: ELSE
2302: hr_utility.set_location(l_proc || ' Exiting',100);
2303: END IF;
2304: exception when others then
2305: result := null;
2306: raise;

Line 2320: hr_utility.set_location(l_proc || ' Entering',10);

2316: l_transaction_id NUMBER;
2317: l_transaction_category_id NUMBER;
2318: l_proc VARCHAR2(61) := g_package || 'notify_requestor';
2319: BEGIN
2320: hr_utility.set_location(l_proc || ' Entering',10);
2321: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2322: IF (FUNCMODE = 'RUN') THEN
2323: l_user := get_requestor(itemkey);
2324:

Line 2321: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2317: l_transaction_category_id NUMBER;
2318: l_proc VARCHAR2(61) := g_package || 'notify_requestor';
2319: BEGIN
2320: hr_utility.set_location(l_proc || ' Entering',10);
2321: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2322: IF (FUNCMODE = 'RUN') THEN
2323: l_user := get_requestor(itemkey);
2324:
2325: set_next_user (

Line 2332: hr_utility.set_location(l_proc || ' Exiting',100);

2328: , p_route_to_user => l_user
2329: , p_status => 'FOUND'
2330: );
2331: result := 'COMPLETE:FOUND';
2332: hr_utility.set_location(l_proc || ' Exiting',100);
2333: return;
2334: ELSE
2335: hr_utility.set_location(l_proc || ' Exiting',100);
2336: END IF;

Line 2335: hr_utility.set_location(l_proc || ' Exiting',100);

2331: result := 'COMPLETE:FOUND';
2332: hr_utility.set_location(l_proc || ' Exiting',100);
2333: return;
2334: ELSE
2335: hr_utility.set_location(l_proc || ' Exiting',100);
2336: END IF;
2337: exception when others then
2338: result := null;
2339: raise;

Line 2355: hr_utility.set_location(l_proc || ' Entering',10);

2351: l_proc VARCHAR2(61) := g_package || 'approve_txn';
2352: l_future_action_cd pqh_transaction_categories.future_action_cd%TYPE;
2353: l_post_style_cd pqh_transaction_categories.post_style_cd%TYPE;
2354: BEGIN
2355: hr_utility.set_location(l_proc || ' Entering',10);
2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2357: IF (FUNCMODE = 'RUN') THEN
2358: l_future_action_cd := wf_engine.GetItemAttrText(
2359: itemtype => itemtype,

Line 2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2352: l_future_action_cd pqh_transaction_categories.future_action_cd%TYPE;
2353: l_post_style_cd pqh_transaction_categories.post_style_cd%TYPE;
2354: BEGIN
2355: hr_utility.set_location(l_proc || ' Entering',10);
2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2357: IF (FUNCMODE = 'RUN') THEN
2358: l_future_action_cd := wf_engine.GetItemAttrText(
2359: itemtype => itemtype,
2360: itemkey => ItemKey,

Line 2383: hr_utility.set_location(l_proc || ' Exiting',100);

2379: ELSE
2380: result := 'COMPLETE:CURRENT';
2381: END IF;
2382: END IF;
2383: hr_utility.set_location(l_proc || ' Exiting',100);
2384: exception when others then
2385: result := null;
2386: raise;
2387: END;

Line 2406: hr_utility.set_location(l_proc || ' Entering',10);

2402: pragma exception_init (post_txn_not_defined, -6550);
2403: l_apply_error_mesg VARCHAR2(200) := 'No Error';
2404: l_apply_error_num VARCHAR2(30) := '0' ;
2405: BEGIN
2406: hr_utility.set_location(l_proc || ' Entering',10);
2407: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2408: IF (FUNCMODE = 'RUN') THEN
2409: set_apply_error(p_itemkey => itemkey,
2410: p_workflow_name => itemtype,

Line 2407: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2403: l_apply_error_mesg VARCHAR2(200) := 'No Error';
2404: l_apply_error_num VARCHAR2(30) := '0' ;
2405: BEGIN
2406: hr_utility.set_location(l_proc || ' Entering',10);
2407: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2408: IF (FUNCMODE = 'RUN') THEN
2409: set_apply_error(p_itemkey => itemkey,
2410: p_workflow_name => itemtype,
2411: p_apply_error_mesg => l_apply_error_mesg,

Line 2413: hr_utility.set_location(l_proc || ' After error setting ', 33);

2409: set_apply_error(p_itemkey => itemkey,
2410: p_workflow_name => itemtype,
2411: p_apply_error_mesg => l_apply_error_mesg,
2412: p_apply_error_num => l_apply_error_num );
2413: hr_utility.set_location(l_proc || ' After error setting ', 33);
2414: create_process_log('POST_TXN : itemkey = ' || itemkey);
2415: l_post_txn_function := wf_engine.GetItemAttrText(
2416: itemtype => itemtype,
2417: itemkey => ItemKey,

Line 2430: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,40) , 22);

2426: l_post_txn_function := 'begin :l_status := ' || l_post_txn_function ||
2427: '.apply_transaction(p_transaction_id =>'||
2428: to_char(l_transaction_id) ||
2429: ',p_validate_only =>''NO'' ); end;';
2430: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,40) , 22);
2431: hr_utility.set_location(l_proc ||substr(l_post_txn_function,41,40) , 22);
2432: hr_utility.set_location(l_proc ||substr(l_post_txn_function,81) , 22);
2433: savepoint before_apply_txn ;
2434: DECLARE

Line 2431: hr_utility.set_location(l_proc ||substr(l_post_txn_function,41,40) , 22);

2427: '.apply_transaction(p_transaction_id =>'||
2428: to_char(l_transaction_id) ||
2429: ',p_validate_only =>''NO'' ); end;';
2430: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,40) , 22);
2431: hr_utility.set_location(l_proc ||substr(l_post_txn_function,41,40) , 22);
2432: hr_utility.set_location(l_proc ||substr(l_post_txn_function,81) , 22);
2433: savepoint before_apply_txn ;
2434: DECLARE
2435: l_sqlerrm VARCHAR2(2000);

Line 2432: hr_utility.set_location(l_proc ||substr(l_post_txn_function,81) , 22);

2428: to_char(l_transaction_id) ||
2429: ',p_validate_only =>''NO'' ); end;';
2430: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,40) , 22);
2431: hr_utility.set_location(l_proc ||substr(l_post_txn_function,41,40) , 22);
2432: hr_utility.set_location(l_proc ||substr(l_post_txn_function,81) , 22);
2433: savepoint before_apply_txn ;
2434: DECLARE
2435: l_sqlerrm VARCHAR2(2000);
2436: l_sqlcode NUMBER;

Line 2441: hr_utility.set_location(l_proc || 'post_func not defined ' , 28);

2437: BEGIN
2438: EXECUTE IMMEDIATE l_post_txn_function USING OUT l_dbupdate;
2439: EXCEPTION
2440: when post_txn_not_defined then
2441: hr_utility.set_location(l_proc || 'post_func not defined ' , 28);
2442: raise;
2443: WHEN OTHERS THEN
2444: l_sqlcode := sqlcode;
2445: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);

Line 2446: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

2442: raise;
2443: WHEN OTHERS THEN
2444: l_sqlcode := sqlcode;
2445: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2446: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2447: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 30);
2448: rollback to before_apply_txn ;
2449: set_apply_error(p_itemkey => itemkey,
2450: p_workflow_name => itemtype,

Line 2447: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 30);

2443: WHEN OTHERS THEN
2444: l_sqlcode := sqlcode;
2445: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2446: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2447: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 30);
2448: rollback to before_apply_txn ;
2449: set_apply_error(p_itemkey => itemkey,
2450: p_workflow_name => itemtype,
2451: p_apply_error_mesg => l_sqlerrm,

Line 2453: hr_utility.set_location(l_proc || ' After error setting ', 33);

2449: set_apply_error(p_itemkey => itemkey,
2450: p_workflow_name => itemtype,
2451: p_apply_error_mesg => l_sqlerrm,
2452: p_apply_error_num => l_sqlcode );
2453: hr_utility.set_location(l_proc || ' After error setting ', 33);
2454: END;
2455: IF l_dbupdate = 'SUCCESS' THEN
2456: wf_engine.SetItemAttrText(
2457: itemtype => itemtype,

Line 2478: hr_utility.set_location(l_proc || ' Exiting',100);

2474: avalue => 'DBWARNING');
2475: result := 'COMPLETE:WARNING';
2476: END IF;
2477: END IF;
2478: hr_utility.set_location(l_proc || ' Exiting',100);
2479: exception when others then
2480: result := null;
2481: raise;
2482: END;

Line 2494: hr_utility.set_location(l_proc || ' Entering',10);

2490: )
2491: IS
2492: l_proc VARCHAR2(61) := g_package || 'chk_effective_date';
2493: BEGIN
2494: hr_utility.set_location(l_proc || ' Entering',10);
2495: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2496: IF (FUNCMODE = 'RUN') THEN
2497: create_process_log('CHK_EFFECTIVE_DATE : itemkey = ' || itemkey);
2498: result := 'COMPLETE:FUTURE';

Line 2495: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2491: IS
2492: l_proc VARCHAR2(61) := g_package || 'chk_effective_date';
2493: BEGIN
2494: hr_utility.set_location(l_proc || ' Entering',10);
2495: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2496: IF (FUNCMODE = 'RUN') THEN
2497: create_process_log('CHK_EFFECTIVE_DATE : itemkey = ' || itemkey);
2498: result := 'COMPLETE:FUTURE';
2499: END IF;

Line 2500: hr_utility.set_location(l_proc || ' Exiting',100);

2496: IF (FUNCMODE = 'RUN') THEN
2497: create_process_log('CHK_EFFECTIVE_DATE : itemkey = ' || itemkey);
2498: result := 'COMPLETE:FUTURE';
2499: END IF;
2500: hr_utility.set_location(l_proc || ' Exiting',100);
2501: exception when others then
2502: result := null;
2503: raise;
2504: END;

Line 2516: hr_utility.set_location(l_proc || ' Entering',10);

2512: l_proc VARCHAR2(61) := g_package || 'process_notification';
2513: l_form_name VARCHAR2(100);
2514: l_routing_history_id NUMBER;
2515: BEGIN
2516: hr_utility.set_location(l_proc || ' Entering',10);
2517: hr_utility.set_location(l_proc || 'Parameter - Funcmode = ' || funcmode,20);
2518: create_process_log('In ' || l_proc || ' ' || funcmode);
2519: l_form_name := wf_engine.GetItemAttrText(itemtype => itemtype,
2520: itemkey => ItemKey,

Line 2517: hr_utility.set_location(l_proc || 'Parameter - Funcmode = ' || funcmode,20);

2513: l_form_name VARCHAR2(100);
2514: l_routing_history_id NUMBER;
2515: BEGIN
2516: hr_utility.set_location(l_proc || ' Entering',10);
2517: hr_utility.set_location(l_proc || 'Parameter - Funcmode = ' || funcmode,20);
2518: create_process_log('In ' || l_proc || ' ' || funcmode);
2519: l_form_name := wf_engine.GetItemAttrText(itemtype => itemtype,
2520: itemkey => ItemKey,
2521: aname => 'FORM_NAME');

Line 2537: hr_utility.set_location(l_proc || ' Exiting',100);

2533: , aname => 'TRANSACTION_STATUS'
2534: , avalue => 'TIMEOUT');
2535: result := 'COMPLETE:TIMEOUT';
2536: END IF;
2537: hr_utility.set_location(l_proc || ' Exiting',100);
2538: return;
2539: exception when others then
2540: result := null;
2541: raise;

Line 2562: hr_utility.set_location(l_proc || ' Entering',10);

2558: l_user_action_cd VARCHAR2(30);
2559: l_requestor VARCHAR2(30);
2560: l_current_user VARCHAR2(30);
2561: BEGIN
2562: hr_utility.set_location(l_proc || ' Entering',10);
2563: hr_utility.set_location(l_proc || ' FuncMode' || funcmode, 20);
2564: IF (FUNCMODE = 'RUN') THEN
2565: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2566: itemkey => ItemKey,

Line 2563: hr_utility.set_location(l_proc || ' FuncMode' || funcmode, 20);

2559: l_requestor VARCHAR2(30);
2560: l_current_user VARCHAR2(30);
2561: BEGIN
2562: hr_utility.set_location(l_proc || ' Entering',10);
2563: hr_utility.set_location(l_proc || ' FuncMode' || funcmode, 20);
2564: IF (FUNCMODE = 'RUN') THEN
2565: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2566: itemkey => ItemKey,
2567: aname => 'TRANSACTION_STATUS');

Line 2568: hr_utility.set_location(l_proc || ' User Action '|| l_user_action_cd, 20);

2564: IF (FUNCMODE = 'RUN') THEN
2565: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2566: itemkey => ItemKey,
2567: aname => 'TRANSACTION_STATUS');
2568: hr_utility.set_location(l_proc || ' User Action '|| l_user_action_cd, 20);
2569: IF l_user_action_cd in ('FYI_NOT','PQH_BPR') THEN
2570: result := 'COMPLETE:'||l_user_action_cd;
2571: hr_utility.set_location(l_proc || ' Exiting',100);
2572: RETURN;

Line 2571: hr_utility.set_location(l_proc || ' Exiting',100);

2567: aname => 'TRANSACTION_STATUS');
2568: hr_utility.set_location(l_proc || ' User Action '|| l_user_action_cd, 20);
2569: IF l_user_action_cd in ('FYI_NOT','PQH_BPR') THEN
2570: result := 'COMPLETE:'||l_user_action_cd;
2571: hr_utility.set_location(l_proc || ' Exiting',100);
2572: RETURN;
2573: END IF;
2574: decode_itemkey(p_transaction_category_id => l_transaction_category_id
2575: , p_transaction_id => l_transaction_id

Line 2602: hr_utility.set_location(l_proc || ' Exiting',100);

2598: , p_status => 'FOUND'
2599: );
2600: END IF;
2601: result := 'COMPLETE:' || l_user_action_cd;
2602: hr_utility.set_location(l_proc || ' Exiting',100);
2603: END IF;
2604: exception when others then
2605: result := null;
2606: raise;

Line 2619: hr_utility.set_location(l_proc || ' Entering',10);

2615: IS
2616: l_proc VARCHAR2(61) := g_package || 'chk_fyi_results';
2617: l_user_action_cd VARCHAR2(30);
2618: BEGIN
2619: hr_utility.set_location(l_proc || ' Entering',10);
2620: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2621: IF (FUNCMODE = 'RUN') THEN
2622: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2623: itemkey => ItemKey,

Line 2620: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

2616: l_proc VARCHAR2(61) := g_package || 'chk_fyi_results';
2617: l_user_action_cd VARCHAR2(30);
2618: BEGIN
2619: hr_utility.set_location(l_proc || ' Entering',10);
2620: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2621: IF (FUNCMODE = 'RUN') THEN
2622: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2623: itemkey => ItemKey,
2624: aname => 'TRANSACTION_STATUS');

Line 2627: hr_utility.set_location(l_proc || result, 50);

2623: itemkey => ItemKey,
2624: aname => 'TRANSACTION_STATUS');
2625: result := 'COMPLETE:'||l_user_action_cd;
2626: END IF;
2627: hr_utility.set_location(l_proc || result, 50);
2628: hr_utility.set_location(l_proc || ' Exiting',100);
2629: exception when others then
2630: result := null;
2631: raise;

Line 2628: hr_utility.set_location(l_proc || ' Exiting',100);

2624: aname => 'TRANSACTION_STATUS');
2625: result := 'COMPLETE:'||l_user_action_cd;
2626: END IF;
2627: hr_utility.set_location(l_proc || result, 50);
2628: hr_utility.set_location(l_proc || ' Exiting',100);
2629: exception when others then
2630: result := null;
2631: raise;
2632: END;

Line 2651: hr_utility.set_location(l_proc || ' Entering',10);

2647: l_proc VARCHAR2(61) := g_package || 'chk_root_node';
2648: chk_root_not_defined1 EXCEPTION;
2649: pragma exception_init (chk_root_not_defined1, -900);
2650: BEGIN
2651: hr_utility.set_location(l_proc || ' Entering',10);
2652: if (funcmode='RUN') then
2653: l_post_txn_function := wf_engine.GetItemAttrText(
2654: itemtype => itemtype,
2655: itemkey => ItemKey,

Line 2657: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,30),15);

2653: l_post_txn_function := wf_engine.GetItemAttrText(
2654: itemtype => itemtype,
2655: itemkey => ItemKey,
2656: aname => 'POST_TXN_FUNCTION');
2657: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,30),15);
2658: decode_itemkey(p_itemkey => itemkey
2659: , p_transaction_category_id => l_transaction_category_id
2660: , p_transaction_id => l_transaction_id
2661: );

Line 2666: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,30),15);

2662: l_post_txn_function := 'begin :l_status := ' || l_post_txn_function ||
2663: '.chk_root_node(p_transaction_id =>'||
2664: to_char(l_transaction_id) || '); end;';
2665:
2666: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,30),15);
2667: DECLARE
2668: l_sqlerrm VARCHAR2(2000);
2669: l_sqlcode NUMBER;
2670: l_dbupdate varchar2(2000);

Line 2682: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

2678: result := 'COMPLETE:ROOT';
2679: WHEN OTHERS THEN
2680: l_sqlcode := sqlcode;
2681: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2682: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2683: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
2684: END;
2685: end if;
2686: exception when others then

Line 2683: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);

2679: WHEN OTHERS THEN
2680: l_sqlcode := sqlcode;
2681: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2682: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2683: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 31);
2684: END;
2685: end if;
2686: exception when others then
2687: result := null;

Line 2758: hr_utility.set_message(8302,'PQH_USER_HAS_NO_ROLE');

2754: CLOSE c_get_user_role;
2755: end if;
2756: END IF;
2757: IF l_role_id IS NULL THEN
2758: hr_utility.set_message(8302,'PQH_USER_HAS_NO_ROLE');
2759: hr_utility.raise_error;
2760: END IF;
2761: ELSE
2762: l_role_id := -1;

Line 2759: hr_utility.raise_error;

2755: end if;
2756: END IF;
2757: IF l_role_id IS NULL THEN
2758: hr_utility.set_message(8302,'PQH_USER_HAS_NO_ROLE');
2759: hr_utility.raise_error;
2760: END IF;
2761: ELSE
2762: l_role_id := -1;
2763: END IF;

Line 2784: hr_utility.set_location(l_proc || ' Entering',10);

2780: l_proc varchar2(61) := g_package ||'get_apply_error' ;
2781: l_workflow_name varchar2(30);
2782: l_itemkey varchar2(30);
2783: begin
2784: hr_utility.set_location(l_proc || ' Entering',10);
2785: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2786: hr_utility.set_location(l_proc || 'workflow name is'||l_workflow_name,20);
2787: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2788: hr_utility.set_location(l_proc || 'itemkey'||l_itemkey,25);

Line 2786: hr_utility.set_location(l_proc || 'workflow name is'||l_workflow_name,20);

2782: l_itemkey varchar2(30);
2783: begin
2784: hr_utility.set_location(l_proc || ' Entering',10);
2785: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2786: hr_utility.set_location(l_proc || 'workflow name is'||l_workflow_name,20);
2787: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2788: hr_utility.set_location(l_proc || 'itemkey'||l_itemkey,25);
2789: get_apply_error(p_itemkey => l_itemkey,
2790: p_workflow_name => l_workflow_name,

Line 2788: hr_utility.set_location(l_proc || 'itemkey'||l_itemkey,25);

2784: hr_utility.set_location(l_proc || ' Entering',10);
2785: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2786: hr_utility.set_location(l_proc || 'workflow name is'||l_workflow_name,20);
2787: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2788: hr_utility.set_location(l_proc || 'itemkey'||l_itemkey,25);
2789: get_apply_error(p_itemkey => l_itemkey,
2790: p_workflow_name => l_workflow_name,
2791: p_apply_error_mesg => p_apply_error_mesg,
2792: p_apply_error_num => p_apply_error_num );

Line 2793: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);

2789: get_apply_error(p_itemkey => l_itemkey,
2790: p_workflow_name => l_workflow_name,
2791: p_apply_error_mesg => p_apply_error_mesg,
2792: p_apply_error_num => p_apply_error_num );
2793: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);
2794: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),40);
2795: hr_utility.set_location(l_proc || ' Exiting',100);
2796: end;
2797:

Line 2794: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),40);

2790: p_workflow_name => l_workflow_name,
2791: p_apply_error_mesg => p_apply_error_mesg,
2792: p_apply_error_num => p_apply_error_num );
2793: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);
2794: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),40);
2795: hr_utility.set_location(l_proc || ' Exiting',100);
2796: end;
2797:
2798: PROCEDURE set_apply_error(p_transaction_id IN NUMBER,

Line 2795: hr_utility.set_location(l_proc || ' Exiting',100);

2791: p_apply_error_mesg => p_apply_error_mesg,
2792: p_apply_error_num => p_apply_error_num );
2793: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);
2794: hr_utility.set_location(l_proc || 'apply_mesg'||substr(p_apply_error_mesg,1,20),40);
2795: hr_utility.set_location(l_proc || ' Exiting',100);
2796: end;
2797:
2798: PROCEDURE set_apply_error(p_transaction_id IN NUMBER,
2799: p_transaction_category_id IN NUMBER,

Line 2807: hr_utility.set_location(l_proc || 'Entering',10);

2803: l_proc varchar2(61) := g_package ||'set_apply_error' ;
2804: l_workflow_name varchar2(30);
2805: l_itemkey varchar2(30);
2806: BEGIN
2807: hr_utility.set_location(l_proc || 'Entering',10);
2808: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2809: hr_utility.set_location(l_proc || 'txn_id is' ||p_transaction_id,16);
2810:
2811: IF p_transaction_category_id IS NULL

Line 2808: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);

2804: l_workflow_name varchar2(30);
2805: l_itemkey varchar2(30);
2806: BEGIN
2807: hr_utility.set_location(l_proc || 'Entering',10);
2808: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2809: hr_utility.set_location(l_proc || 'txn_id is' ||p_transaction_id,16);
2810:
2811: IF p_transaction_category_id IS NULL
2812: OR p_transaction_id IS NULL THEN

Line 2809: hr_utility.set_location(l_proc || 'txn_id is' ||p_transaction_id,16);

2805: l_itemkey varchar2(30);
2806: BEGIN
2807: hr_utility.set_location(l_proc || 'Entering',10);
2808: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2809: hr_utility.set_location(l_proc || 'txn_id is' ||p_transaction_id,16);
2810:
2811: IF p_transaction_category_id IS NULL
2812: OR p_transaction_id IS NULL THEN
2813: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');

Line 2813: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');

2809: hr_utility.set_location(l_proc || 'txn_id is' ||p_transaction_id,16);
2810:
2811: IF p_transaction_category_id IS NULL
2812: OR p_transaction_id IS NULL THEN
2813: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
2814: hr_utility.raise_error;
2815: END IF;
2816:
2817: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);

Line 2814: hr_utility.raise_error;

2810:
2811: IF p_transaction_category_id IS NULL
2812: OR p_transaction_id IS NULL THEN
2813: hr_utility.set_message(8302,'PQH_NULL_TRANSACTION_ID_OR_CAT');
2814: hr_utility.raise_error;
2815: END IF;
2816:
2817: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2818: hr_utility.set_location(l_proc || 'workflow name is' ||l_workflow_name,20);

Line 2818: hr_utility.set_location(l_proc || 'workflow name is' ||l_workflow_name,20);

2814: hr_utility.raise_error;
2815: END IF;
2816:
2817: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2818: hr_utility.set_location(l_proc || 'workflow name is' ||l_workflow_name,20);
2819: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2820:
2821: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2822: hr_utility.set_location(l_proc || 'itemkey' ||l_itemkey,25);

Line 2821: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);

2817: l_workflow_name := get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2818: hr_utility.set_location(l_proc || 'workflow name is' ||l_workflow_name,20);
2819: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2820:
2821: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2822: hr_utility.set_location(l_proc || 'itemkey' ||l_itemkey,25);
2823:
2824: set_apply_error(p_itemkey => l_itemkey,
2825: p_workflow_name => l_workflow_name,

Line 2822: hr_utility.set_location(l_proc || 'itemkey' ||l_itemkey,25);

2818: hr_utility.set_location(l_proc || 'workflow name is' ||l_workflow_name,20);
2819: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(p_transaction_id) ;
2820:
2821: hr_utility.set_location(l_proc || 'txn_cat is' ||p_transaction_category_id,15);
2822: hr_utility.set_location(l_proc || 'itemkey' ||l_itemkey,25);
2823:
2824: set_apply_error(p_itemkey => l_itemkey,
2825: p_workflow_name => l_workflow_name,
2826: p_apply_error_mesg => p_apply_error_mesg,

Line 2828: hr_utility.set_location(l_proc || ' Exiting',100);

2824: set_apply_error(p_itemkey => l_itemkey,
2825: p_workflow_name => l_workflow_name,
2826: p_apply_error_mesg => p_apply_error_mesg,
2827: p_apply_error_num => p_apply_error_num );
2828: hr_utility.set_location(l_proc || ' Exiting',100);
2829: END;
2830:
2831: PROCEDURE set_status ( p_workflow_name IN VARCHAR2,
2832: p_item_id IN VARCHAR2,

Line 2849: hr_utility.set_location(l_proc || ' Entering',10);

2845: cursor c1 is select post_txn_function,short_name
2846: from pqh_transaction_categories
2847: where transaction_category_id = l_tran_cat_id ;
2848: BEGIN
2849: hr_utility.set_location(l_proc || ' Entering',10);
2850: hr_utility.set_location(l_proc || ' workflow ' || p_workflow_name, 10);
2851: hr_utility.set_location(l_proc || ' item id ' || p_item_id,10);
2852: l_hyphen_pos := INSTR(p_item_id, '-');
2853: l_tran_cat_id := TO_NUMBER(SUBSTR(p_item_id, 1, l_hyphen_pos - 1));

Line 2850: hr_utility.set_location(l_proc || ' workflow ' || p_workflow_name, 10);

2846: from pqh_transaction_categories
2847: where transaction_category_id = l_tran_cat_id ;
2848: BEGIN
2849: hr_utility.set_location(l_proc || ' Entering',10);
2850: hr_utility.set_location(l_proc || ' workflow ' || p_workflow_name, 10);
2851: hr_utility.set_location(l_proc || ' item id ' || p_item_id,10);
2852: l_hyphen_pos := INSTR(p_item_id, '-');
2853: l_tran_cat_id := TO_NUMBER(SUBSTR(p_item_id, 1, l_hyphen_pos - 1));
2854: l_transaction_id := TO_NUMBER(SUBSTR(p_item_id, l_hyphen_pos + 1));

Line 2851: hr_utility.set_location(l_proc || ' item id ' || p_item_id,10);

2847: where transaction_category_id = l_tran_cat_id ;
2848: BEGIN
2849: hr_utility.set_location(l_proc || ' Entering',10);
2850: hr_utility.set_location(l_proc || ' workflow ' || p_workflow_name, 10);
2851: hr_utility.set_location(l_proc || ' item id ' || p_item_id,10);
2852: l_hyphen_pos := INSTR(p_item_id, '-');
2853: l_tran_cat_id := TO_NUMBER(SUBSTR(p_item_id, 1, l_hyphen_pos - 1));
2854: l_transaction_id := TO_NUMBER(SUBSTR(p_item_id, l_hyphen_pos + 1));
2855: hr_utility.set_location(l_proc || 'transaction id ' || l_transaction_id,20);

Line 2855: hr_utility.set_location(l_proc || 'transaction id ' || l_transaction_id,20);

2851: hr_utility.set_location(l_proc || ' item id ' || p_item_id,10);
2852: l_hyphen_pos := INSTR(p_item_id, '-');
2853: l_tran_cat_id := TO_NUMBER(SUBSTR(p_item_id, 1, l_hyphen_pos - 1));
2854: l_transaction_id := TO_NUMBER(SUBSTR(p_item_id, l_hyphen_pos + 1));
2855: hr_utility.set_location(l_proc || 'transaction id ' || l_transaction_id,20);
2856: hr_utility.set_location(l_proc || 'tran_cat_id ' || l_tran_cat_id,20);
2857: open c1;
2858: fetch c1 into l_post_txn_function,l_tran_cat_name;
2859: close c1;

Line 2856: hr_utility.set_location(l_proc || 'tran_cat_id ' || l_tran_cat_id,20);

2852: l_hyphen_pos := INSTR(p_item_id, '-');
2853: l_tran_cat_id := TO_NUMBER(SUBSTR(p_item_id, 1, l_hyphen_pos - 1));
2854: l_transaction_id := TO_NUMBER(SUBSTR(p_item_id, l_hyphen_pos + 1));
2855: hr_utility.set_location(l_proc || 'transaction id ' || l_transaction_id,20);
2856: hr_utility.set_location(l_proc || 'tran_cat_id ' || l_tran_cat_id,20);
2857: open c1;
2858: fetch c1 into l_post_txn_function,l_tran_cat_name;
2859: close c1;
2860: hr_utility.set_location(l_proc || 'post funtion string ' || l_post_txn_function,20);

Line 2860: hr_utility.set_location(l_proc || 'post funtion string ' || l_post_txn_function,20);

2856: hr_utility.set_location(l_proc || 'tran_cat_id ' || l_tran_cat_id,20);
2857: open c1;
2858: fetch c1 into l_post_txn_function,l_tran_cat_name;
2859: close c1;
2860: hr_utility.set_location(l_proc || 'post funtion string ' || l_post_txn_function,20);
2861: l_set_status := 'begin :l_status := ' || l_post_txn_function ||
2862: '.set_status( p_transaction_category_id => ' || to_char(l_tran_cat_id) ||
2863: ',p_transaction_id =>'|| to_char(l_transaction_id) ||
2864: ',p_status =>'''||p_status ||

Line 2867: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 1, 40),20);

2863: ',p_transaction_id =>'|| to_char(l_transaction_id) ||
2864: ',p_status =>'''||p_status ||
2865: '''); end; ';
2866:
2867: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 1, 40),20);
2868: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 41, 40),20);
2869: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 81, 40),20);
2870: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 121),20);
2871: DECLARE

Line 2868: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 41, 40),20);

2864: ',p_status =>'''||p_status ||
2865: '''); end; ';
2866:
2867: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 1, 40),20);
2868: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 41, 40),20);
2869: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 81, 40),20);
2870: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 121),20);
2871: DECLARE
2872: l_sqlerrm VARCHAR2(2000);

Line 2869: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 81, 40),20);

2865: '''); end; ';
2866:
2867: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 1, 40),20);
2868: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 41, 40),20);
2869: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 81, 40),20);
2870: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 121),20);
2871: DECLARE
2872: l_sqlerrm VARCHAR2(2000);
2873: l_sqlcode NUMBER;

Line 2870: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 121),20);

2866:
2867: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 1, 40),20);
2868: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 41, 40),20);
2869: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 81, 40),20);
2870: hr_utility.set_location(l_proc || 'dyn string ' || substr(l_set_status, 121),20);
2871: DECLARE
2872: l_sqlerrm VARCHAR2(2000);
2873: l_sqlcode NUMBER;
2874: BEGIN

Line 2884: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);

2880: WHEN OTHERS THEN
2881: l_sqlcode := sqlcode;
2882: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2883: p_result := l_sqlcode;
2884: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2885: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 32);
2886: raise;
2887: END;
2888: -- document := document || l_fyi_notification ;

Line 2885: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 32);

2881: l_sqlcode := sqlcode;
2882: l_sqlerrm := substr(sqlerrm(l_sqlcode), 1, 100);
2883: p_result := l_sqlcode;
2884: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,1,30), 30);
2885: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 32);
2886: raise;
2887: END;
2888: -- document := document || l_fyi_notification ;
2889: hr_utility.set_location(l_proc || 'Exiting',100);

Line 2889: hr_utility.set_location(l_proc || 'Exiting',100);

2885: hr_utility.set_location(l_proc || ' ' || substr(l_sqlerrm,31,30), 32);
2886: raise;
2887: END;
2888: -- document := document || l_fyi_notification ;
2889: hr_utility.set_location(l_proc || 'Exiting',100);
2890: exception when others then
2891: p_result := null;
2892: raise;
2893: end;