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 PQH_PROCESS_LOG

Line 31: FROM pqh_process_log

27: ,p_folder_id IN number) -- Realloc Folder Id
28: RETURN NUMBER IS
29: CURSOR CSR_batch_master_log IS
30: SELECT process_log_id
31: FROM pqh_process_log
32: WHERE txn_id = p_folder_id
33: AND module_cd = 'BUDGET_REALLOCATION';
34:
35: Cursor Csr_get_log (p_batch_id IN number)

Line 39: FROM pqh_process_log

35: Cursor Csr_get_log (p_batch_id IN number)
36: IS SELECT process_log_id,
37: txn_id,
38: information_category
39: FROM pqh_process_log
40: START WITH txn_id = p_transaction_id
41: AND master_process_log_id = p_batch_id
42: AND module_cd = 'BUDGET_REALLOCATION'
43: CONNECT BY PRIOR process_log_id = master_process_log_id;

Line 134: pqh_process_log_api.create_process_log(p_process_log_id => l_process_log_id

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'
133: ,p_folder_id => p_folder_id);
134: pqh_process_log_api.create_process_log(p_process_log_id => l_process_log_id
135: ,p_module_cd => 'BUDGET_REALLOCATION'
136: ,p_txn_id => p_transaction_id
137: ,p_log_context => l_name
138: ,p_batch_start_date => sysdate

Line 147: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id

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
150: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','D')
151: ,p_batch_start_date => sysdate

Line 159: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id

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')
163: ,p_batch_start_date => sysdate

Line 203: pqh_process_log_api.create_process_log(p_process_log_id => l_log_id

199: l_master_log_id := get_process_log_id(p_folder_id => p_folder_id
200: ,p_transaction_id => p_transaction_id
201: ,p_entity_type => p_txn_entity_type);
202:
203: pqh_process_log_api.create_process_log(p_process_log_id => l_log_id
204: ,p_module_cd => 'BUDGET_REALLOCATION'
205: ,p_txn_id => p_entity_id
206: ,p_log_context => l_entity_name
207: ,p_batch_start_date => sysdate

Line 222: FROM pqh_process_log

218: FUNCTION get_batch_status(p_start_log_id IN NUMBER) RETURN varchar2 IS
219:
220: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
221: SELECT COUNT(*)
222: FROM pqh_process_log
223: WHERE message_type_cd = p_message_type_cd
224: START WITH process_log_id = p_start_log_id
225: CONNECT BY PRIOR process_log_id = master_process_log_id;
226:

Line 283: UPDATE pqh_process_log

279: l_status := get_batch_status(l_process_log_id);
280: /*
281: update the 'start' record for this transaction with message_type_cd = 'COMPLETE'
282: */
283: UPDATE pqh_process_log
284: SET message_type_cd = DECODE(message_type_cd,'ERROR',message_type_cd,'COMPLETE'),
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

Line 345: pqh_process_log_api.create_process_log(p_process_log_id => l_folder_log_id

341: IF p_txn_entity_type = 'F' THEN
342: l_process_log_id := get_process_log_id(p_entity_type => 'F'
343: ,p_folder_id => p_folder_id);
344: l_log_context := 'FOLDER';
345: pqh_process_log_api.create_process_log(p_process_log_id => l_folder_log_id
346: ,p_module_cd => 'BUDGET_REALLOCATION'
347: ,p_txn_id => p_folder_id
348: ,p_log_context => l_log_context
349: ,p_master_process_log_id => l_process_log_id

Line 365: UPDATE pqh_process_log

361: END IF;
362: l_process_log_id := get_process_log_id(p_entity_type => 'T'
363: ,p_transaction_id => p_transaction_id
364: ,p_folder_id => p_folder_id);
365: UPDATE pqh_process_log
366: set message_type_cd = l_message_type_cd
367: ,batch_status = l_status
368: ,message_text = p_message_text
369: WHERE process_log_id = l_process_log_id;

Line 399: pqh_process_log_api.create_process_log(p_process_log_id => l_period_log_id

395: OPEN csr_rcvr_dates;
396: FETCH csr_rcvr_dates INTO l_log_context;
397: CLOSE csr_rcvr_dates;
398: END IF;
399: pqh_process_log_api.create_process_log(p_process_log_id => l_period_log_id
400: ,p_module_cd => 'BUDGET_REALLOCATION'
401: ,p_txn_id => p_budget_period_id
402: ,p_log_context => l_log_context
403: ,p_master_process_log_id => l_process_log_id

Line 502: pqh_process_log_api.create_process_log(p_process_log_id => l_rule_log_id

498: ,p_entity_type => p_txn_entity_type||'D'
499: ,p_entity_id => p_entity_id);
500:
501: -- Create an entry in the process log for the current rule under the current entity
502: pqh_process_log_api.create_process_log(p_process_log_id => l_rule_log_id
503: ,p_module_cd => 'BUDGET_REALLOCATION'
504: ,p_txn_id => p_entity_id
505: ,p_log_context => p_rule_name
506: ,p_master_process_log_id => l_master_log_id