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_BDGT_REALLOC_LOG_PKG dependencies on HR_UTILITY

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

12: WHERE table_alias = 'BPL';
13: l_tab_route NUMBER(15);
14: l_proc varchar2(80) := g_package||'get_table_rout_for_bpl';
15: BEGIN
16: hr_utility.set_location('Entering'||l_proc,10);
17: OPEN csr_table_route;
18: FETCH csr_table_route INTO l_tab_route;
19: CLOSE csr_table_route;
20: hr_utility.set_location('Leaving with table_route'||l_tab_route||l_proc,10);

Line 20: hr_utility.set_location('Leaving with table_route'||l_tab_route||l_proc,10);

16: hr_utility.set_location('Entering'||l_proc,10);
17: OPEN csr_table_route;
18: FETCH csr_table_route INTO l_tab_route;
19: CLOSE csr_table_route;
20: hr_utility.set_location('Leaving with table_route'||l_tab_route||l_proc,10);
21: RETURN l_tab_route;
22: END get_table_route_for_bpl;
23:
24: FUNCTION get_process_log_id(p_entity_type in varchar2 -- F/T/DD/RD

Line 47: hr_utility.set_location(l_proc,10);

43: CONNECT BY PRIOR process_log_id = master_process_log_id;
44: l_proc varchar2(80) := g_package||'get_process_log_id';
45: l_mast_log_id NUMBER(15);
46: BEGIN
47: hr_utility.set_location(l_proc,10);
48: OPEN CSR_batch_master_log;
49: FETCH CSR_batch_master_log INTO l_mast_log_id;
50: CLOSE CSR_batch_master_log ;
51: IF p_entity_type = 'F' THEN

Line 52: hr_utility.set_location('Leaving with master log id as '||l_mast_log_id||l_proc,20);

48: OPEN CSR_batch_master_log;
49: FETCH CSR_batch_master_log INTO l_mast_log_id;
50: CLOSE CSR_batch_master_log ;
51: IF p_entity_type = 'F' THEN
52: hr_utility.set_location('Leaving with master log id as '||l_mast_log_id||l_proc,20);
53: RETURN l_mast_log_id;
54: END IF;
55: FOR l_rec IN Csr_get_log(l_mast_log_id)
56: LOOP

Line 58: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);

54: END IF;
55: FOR l_rec IN Csr_get_log(l_mast_log_id)
56: LOOP
57: IF p_entity_type = 'T' AND l_rec.txn_id = p_transaction_id AND l_rec.information_category = 'T' THEN
58: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
59: RETURN l_rec.process_log_id;
60: ELSIF p_entity_type = 'D'AND l_rec.txn_id = -1*p_transaction_id AND l_rec.information_category = 'D' THEN
61: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
62: RETURN l_rec.process_log_id;

Line 61: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);

57: IF p_entity_type = 'T' AND l_rec.txn_id = p_transaction_id AND l_rec.information_category = 'T' THEN
58: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
59: RETURN l_rec.process_log_id;
60: ELSIF p_entity_type = 'D'AND l_rec.txn_id = -1*p_transaction_id AND l_rec.information_category = 'D' THEN
61: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
62: RETURN l_rec.process_log_id;
63: ELSIF p_entity_type = 'R'AND l_rec.txn_id = -2*p_transaction_id AND l_rec.information_category = 'R' THEN
64: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
65: RETURN l_rec.process_log_id;

Line 64: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);

60: ELSIF p_entity_type = 'D'AND l_rec.txn_id = -1*p_transaction_id AND l_rec.information_category = 'D' THEN
61: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
62: RETURN l_rec.process_log_id;
63: ELSIF p_entity_type = 'R'AND l_rec.txn_id = -2*p_transaction_id AND l_rec.information_category = 'R' THEN
64: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
65: RETURN l_rec.process_log_id;
66: ELSIF p_entity_type IN ('DD','RD')
67: AND l_rec.information_category = p_entity_type
68: AND l_rec.txn_id = p_entity_id THEN

Line 69: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);

65: RETURN l_rec.process_log_id;
66: ELSIF p_entity_type IN ('DD','RD')
67: AND l_rec.information_category = p_entity_type
68: AND l_rec.txn_id = p_entity_id THEN
69: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
70: RETURN l_rec.process_log_id;
71: END IF;
72: END LOOP;
73: hr_utility.set_location('Leaving with master log id as -1'||l_proc,20);

Line 73: hr_utility.set_location('Leaving with master log id as -1'||l_proc,20);

69: hr_utility.set_location('Leaving with master log id as '||l_rec.process_log_id||l_proc,20);
70: RETURN l_rec.process_log_id;
71: END IF;
72: END LOOP;
73: hr_utility.set_location('Leaving with master log id as -1'||l_proc,20);
74: RETURN -1;
75: END;
76:
77: PROCEDURE start_log_for_folder(p_folder_id IN Number) IS

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

93: l_unit_id NUMBER(15);
94: l_folder_amt NUMBER(22,3);
95: l_proc varchar2(80) := g_package||'start_log_for_folder';
96: BEGIN
97: hr_utility.set_location('Entering '||l_proc,10);
98: OPEN csr_folder_dtls;
99: FETCH csr_folder_dtls INTO l_folder_name, l_budget_name,l_entity_cd, l_unit_id;
100: CLOSE csr_folder_dtls;
101: g_table_route_id := get_table_route_for_bpl;

Line 111: hr_utility.set_location('Leaving '||l_proc,20);

107: ,p_information1 => l_budget_name
108: ,p_information2 => l_entity_cd
109: ,p_information3 => l_unit_id
110: ,p_information4 => pqh_bdgt_realloc_utility.GET_FOLDER_LEVEL_TRANS_AMT(p_folder_id)); --Build a new canvas for this level
111: hr_utility.set_location('Leaving '||l_proc,20);
112: END start_log_for_folder;
113:
114: PROCEDURE start_log_for_transaction( p_folder_id IN number
115: ,p_transaction_id IN Number) is

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

124: l_ovn NUMBER(9);
125: l_proc varchar2(80) := g_package||'start_log_for_transaction';
126: PRAGMA AUTONOMOUS_TRANSACTION;
127: BEGIN
128: hr_utility.set_location('Entering '||l_proc,10);
129: OPEN csr_trnx_name;
130: FETCH csr_trnx_name INTO l_name;
131: CLOSE csr_trnx_name;
132: l_master_log_id := get_process_log_id(p_entity_type => 'F'

Line 145: hr_utility.set_location('Inserted a row for Transaction Level '||l_proc,20);

141: ,p_message_text => 'Process Started'
142: ,p_effective_date => sysdate
143: ,p_object_version_number => l_ovn
144: ,p_information_category => 'T');
145: hr_utility.set_location('Inserted a row for Transaction Level '||l_proc,20);
146: l_master_log_id := l_process_log_id; -- Transaction level Process Log ID
147: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id
148: ,p_module_cd => 'BUDGET_REALLOCATION'
149: ,p_txn_id => -1*p_transaction_id

Line 158: hr_utility.set_location('Inserted a row for Transaction-Donor Level '||l_proc,25);

154: ,p_message_text => 'Process Started'
155: ,p_effective_date => sysdate
156: ,p_object_version_number => l_ovn
157: ,p_information_category => 'D');
158: hr_utility.set_location('Inserted a row for Transaction-Donor Level '||l_proc,25);
159: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id
160: ,p_module_cd => 'BUDGET_REALLOCATION'
161: ,p_txn_id => -2*p_transaction_id
162: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','R')

Line 170: hr_utility.set_location('Inserted a row for Transaction-Receiver Level '||l_proc,25);

166: ,p_message_text => 'Process Started'
167: ,p_effective_date => sysdate
168: ,p_object_version_number => l_ovn
169: ,p_information_category => 'R');
170: hr_utility.set_location('Inserted a row for Transaction-Receiver Level '||l_proc,25);
171:
172:
173: Commit;
174: hr_utility.set_location('Inserted a row for Transaction-Receive Level. Leaving '||l_proc,25);

Line 174: hr_utility.set_location('Inserted a row for Transaction-Receive Level. Leaving '||l_proc,25);

170: hr_utility.set_location('Inserted a row for Transaction-Receiver Level '||l_proc,25);
171:
172:
173: Commit;
174: hr_utility.set_location('Inserted a row for Transaction-Receive Level. Leaving '||l_proc,25);
175: END start_log_for_transaction;
176: PROCEDURE start_log_for_entity(p_folder_id IN NUMBER
177: ,p_transaction_id IN NUMBER
178: ,p_txn_entity_type IN varchar2 --(D/R)

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

184: l_ovn NUMBER(9);
185: l_proc varchar2(80) := g_package||'start_log_for_entity';
186: PRAGMA AUTONOMOUS_TRANSACTION;
187: BEGIN
188: hr_utility.set_location('Entering '||l_proc,10);
189: -- Log context for entity is the entity name
190: IF p_bdgt_entity_type = 'POSITION' THEN
191: l_entity_name := hr_general.decode_position_latest_name(p_entity_id);
192: ELSIF p_bdgt_entity_type = 'ORGANIZATION' THEN

Line 215: hr_utility.set_location('Leaving '||l_proc,20);

211: ,p_information_category => p_txn_entity_type||'D'
212: ,p_effective_date => sysdate
213: ,p_object_version_number => l_ovn);
214: commit;
215: hr_utility.set_location('Leaving '||l_proc,20);
216: END start_log_for_entity;
217:
218: FUNCTION get_batch_status(p_start_log_id IN NUMBER) RETURN varchar2 IS
219:

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

228: l_count_warning NUMBER := 0;
229: l_status VARCHAR2(30);
230: l_proc varchar2(80) := g_package||'get_batch_status';
231: BEGIN
232: hr_utility.set_location('Entering '||l_proc,10);
233: /*
234: Compute the status of the batch. If there exists any record in the batch with
235: message_type_cd = 'ERROR' then the transaction_status = 'ERROR'
236: If there only exists records in the batch with message_type_cd = 'WARNING' then

Line 260: hr_utility.set_location('Leaving '||l_status||l_proc,10);

256: -- no errors or warnings
257: l_status := 'SUCCESS';
258: END IF;
259: END IF;
260: hr_utility.set_location('Leaving '||l_status||l_proc,10);
261: RETURN l_status;
262: END get_batch_status;
263: PROCEDURE end_realloc_log(p_txn_entity_type IN varchar2
264: ,p_folder_id IN NUMBER

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

270: PRAGMA AUTONOMOUS_TRANSACTION;
271: l_process_log_id NUMBER(15);
272: l_proc varchar2(80) := g_package||'end_realloc_log';
273: BEGIN
274: hr_utility.set_location('Entering '||l_proc,10);
275: l_process_log_id := get_process_log_id(p_entity_type => p_txn_entity_type
276: ,p_folder_id => p_folder_id
277: ,p_transaction_id => p_transaction_id
278: ,p_entity_id => p_entity_id);

Line 289: hr_utility.set_location('Leaving '||l_proc,20);

285: message_text = DECODE(message_type_cd,'ERROR',message_text,fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED')),
286: batch_status = DECODE(batch_status,'ERROR',batch_status,l_status),
287: batch_end_date = sysdate
288: WHERE process_log_id = l_process_log_id;
289: hr_utility.set_location('Leaving '||l_proc,20);
290: Commit;
291: END end_realloc_log;
292:
293: PROCEDURE update_log_message(p_folder_id IN Number

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

319: WHERE bpr.reallocation_id = p_budget_period_id;
320:
321: PRAGMA AUTONOMOUS_TRANSACTION;
322: BEGIN
323: hr_utility.set_location('Entering '||l_proc,10);
324: IF p_folder_id IS NULL THEN
325: hr_api.mandatory_arg_error(p_api_name => 'PQH_BDGT_REALLOC_LOG_PKG'
326: ,p_argument => 'p_folder_id'
327: ,p_argument_value => p_folder_id);

Line 412: hr_utility.set_location('Leaving '||l_proc,20);

408: ,p_effective_date => sysdate );
409:
410: END IF;
411: COMMIT;
412: hr_utility.set_location('Leaving '||l_proc,20);
413: END update_log_message;
414:
415: PROCEDURE start_log(p_folder_id IN Number
416: ,p_transaction_id IN Number

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

418: ,p_txn_entity_type IN varchar2 -- F/T/R/D
419: ,p_bdgt_entity_type IN varchar2 ) IS
420: l_proc varchar2(80) := g_package||'start_log';
421: BEGIN
422: hr_utility.set_location('Entering '||l_proc,10);
423: IF p_txn_entity_type = 'F' THEN
424: start_log_for_folder(p_folder_id=> p_folder_id);
425: ELSIF p_txn_entity_type = 'T' THEN
426: start_log_for_transaction( p_folder_id => p_folder_id

Line 435: hr_utility.set_location('Leaving '||l_proc,20);

431: ,p_txn_entity_type =>p_txn_entity_type
432: ,p_bdgt_entity_type => p_bdgt_entity_type
433: ,p_entity_id => p_entity_id);
434: END IF;
435: hr_utility.set_location('Leaving '||l_proc,20);
436: END start_log;
437:
438: PROCEDURE log_rule_for_entity(p_folder_id IN NUMBER
439: ,p_transaction_id IN NUMBER

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

452: l_message_type_cd VARCHAR2(30);
453: PRAGMA AUTONOMOUS_TRANSACTION;
454: l_proc varchar2(80) := g_package||'log_rule_for_entity';
455: BEGIN
456: hr_utility.set_location('Entering '||l_proc,10);
457: -- set the message level based on the rule level for the current rule violation
458: IF p_rule_level = 'E' THEN
459: l_message_type_cd := 'ERROR';
460: ELSIF p_rule_level = 'W' THEN

Line 472: hr_utility.set_location('Leaving from F '||l_proc,11);

468: update_log_message(p_folder_id => p_folder_id
469: ,p_txn_entity_type => 'F'
470: ,p_message_type_cd => p_rule_level
471: ,p_message_text => l_message_text);
472: hr_utility.set_location('Leaving from F '||l_proc,11);
473: RETURN;
474: ELSIF p_txn_entity_type = 'T' THEN
475: update_log_message(p_folder_id => p_folder_id
476: ,p_transaction_id => p_transaction_id

Line 480: hr_utility.set_location('Leaving from T '||l_proc,11);

476: ,p_transaction_id => p_transaction_id
477: ,p_txn_entity_type => 'T'
478: ,p_message_type_cd => p_rule_level
479: ,p_message_text=> l_message_text);
480: hr_utility.set_location('Leaving from T '||l_proc,11);
481: RETURN;
482: END IF;
483: IF p_txn_entity_type IN ('DP','RP') THEN
484: -- code for inserting a row under the entity for Donor Periods under a Donor Entity

Line 492: hr_utility.set_location('Leaving from DP '||l_proc,12);

488: ,p_txn_entity_type => p_txn_entity_type
489: ,p_budget_period_id => p_budget_period_id
490: ,p_message_type_cd => p_rule_level
491: ,p_message_text => l_message_text);
492: hr_utility.set_location('Leaving from DP '||l_proc,12);
493: RETURN;
494: END IF;
495:
496: l_master_log_id := get_process_log_id(p_folder_id => p_folder_id

Line 512: hr_utility.set_location('Leaving '||l_proc,20);

508: ,p_message_type_cd => NVL(l_message_type_cd,'COMPLETE')
509: ,p_information_category => p_txn_entity_type||'M'
510: ,p_object_version_number => l_ovn
511: ,p_effective_date => sysdate );
512: hr_utility.set_location('Leaving '||l_proc,20);
513:
514: commit;
515: END log_rule_for_entity;
516:

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

519: ,p_transaction_id IN NUMBER
520: ,p_entity_id IN NUMBER) IS
521: l_proc varchar2(80) := g_package||'end_log';
522: BEGIN
523: hr_utility.set_location('Entering '||l_proc,10);
524: IF p_txn_entity_type = 'F' THEN
525: PQH_PROCESS_BATCH_LOG.END_LOG;
526: ELSIF p_txn_entity_type = 'T' THEN
527: end_realloc_log(p_txn_entity_type => p_txn_entity_type

Line 542: hr_utility.set_location('Leaving '||l_proc,20);

538: ,p_folder_id => p_folder_id
539: ,p_transaction_id => p_transaction_id
540: ,p_entity_id => p_entity_id);
541: END IF;
542: hr_utility.set_location('Leaving '||l_proc,20);
543: END end_log;
544: END pqh_bdgt_realloc_log_pkg;