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_BUDGET_ANALYSIS_PKG dependencies on PQH_PROCESS_BATCH_LOG

Line 214: pqh_process_batch_log.start_log

210: hr_utility.set_location('l_batch_id : '||l_batch_id ||' - ' || l_proc_name, 15);
211: --
212: -- Create the start record into the Process Log
213: --
214: pqh_process_batch_log.start_log
215: (
216: p_batch_id =>l_batch_id,
217: p_module_cd =>'POSITION_BUDGET_ANALYSIS',
218: p_log_context =>p_batch_name,

Line 273: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||

269: l_message_type := 'ERROR';
270: else
271: l_message_type := 'WARNING';
272: end if;
273: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||
274: l_message_type_cd||l_proc_name, 105);
275: hr_utility.set_location('before pqh.set_context_level organization_id: '||
276: l_organization.organization_id, 105);
277: hr_utility.set_location('before pqh.set_context_level l_table_route_id: '||

Line 286: pqh_process_batch_log.set_context_level

282: hr_general.decode_organization(l_organization.organization_id), 105);
283: --
284: -- Set the Process Log Context level for the Organization
285: --
286: pqh_process_batch_log.set_context_level
287: (
288: p_txn_id =>l_organization.organization_id,
289: p_txn_table_route_id =>l_table_route_id,
290: p_level =>l_organization.level1 + 1,

Line 391: pqh_process_batch_log.set_context_level

387: --
388: --
389: -- Set the Process Log Context Level for the Position
390: --
391: pqh_process_batch_log.set_context_level
392: (
393: p_txn_id =>l_position.position_id,
394: p_txn_table_route_id =>l_table_route_id,
395: p_level =>l_organization.level1+2,

Line 402: pqh_process_batch_log.insert_log

398:
399: --
400: -- Insert the Log for the position
401: --
402: pqh_process_batch_log.insert_log
403: (
404: p_message_type_cd =>l_message_type,
405: p_message_text =>l_message,
406: p_information3 =>l_budgeted_sal,

Line 479: pqh_process_batch_log.end_log;

475: end loop;
476: --
477: -- End the Process Log
478: --
479: pqh_process_batch_log.end_log;
480: hr_utility.set_location('End Process'
481: ||' '||l_proc_name, 180);
482: commit;
483: exception

Line 771: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||

767: l_message_type := 'ERROR';
768: else
769: l_message_type := 'WARNING';
770: end if;
771: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||
772: l_message_type_cd||l_proc_name, 105);
773: hr_utility.set_location('before pqh.set_context_level organization_id: '||
774: p_organization_id, 105);
775: hr_utility.set_location('before pqh.set_context_level l_table_route_id: '||

Line 784: pqh_process_batch_log.set_context_level

780: hr_general.decode_organization(p_organization_id), 105);
781: --
782: -- Set the Process Log Context level for the Organization
783: --
784: pqh_process_batch_log.set_context_level
785: (
786: p_txn_id =>p_organization_id,
787: p_txn_table_route_id =>l_table_route_id,
788: p_level =>p_level1 + 1,

Line 907: pqh_process_batch_log.set_context_level

903: fnd_file.put_line(FND_FILE.LOG,l_position.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||l_commitment_val||' '||l_under_budget_val||' ');
904: --
905: -- Set the Process Log Context Level for the Position
906: --
907: pqh_process_batch_log.set_context_level
908: (
909: p_txn_id =>l_position.position_id,
910: p_txn_table_route_id =>l_table_route_id,
911: p_level =>p_level1+2,

Line 918: pqh_process_batch_log.insert_log

914:
915: --
916: -- Insert the Log for the position
917: --
918: pqh_process_batch_log.insert_log
919: (
920: p_message_type_cd =>l_message_type,
921: p_message_text =>l_message,
922: p_information3 =>round(l_budgeted_val,2),

Line 1077: pqh_process_batch_log.set_context_level

1073: fnd_file.put_line(FND_FILE.LOG,l_position.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||0||' '||l_under_budget_val||' ');
1074: --
1075: -- Set the Process Log Context Level for the Position
1076: --
1077: pqh_process_batch_log.set_context_level
1078: (
1079: p_txn_id =>l_position.position_id,
1080: p_txn_table_route_id =>l_table_route_id,
1081: p_level =>p_level1+2,

Line 1088: pqh_process_batch_log.insert_log

1084:
1085: --
1086: -- Insert the Log for the position
1087: --
1088: pqh_process_batch_log.insert_log
1089: (
1090: p_message_type_cd =>l_message_type,
1091: p_message_text =>l_message,
1092: p_information3 =>round(l_budgeted_val,2),

Line 1247: pqh_process_batch_log.set_context_level

1243: fnd_file.put_line(FND_FILE.LOG,l_position.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||0||' '||l_under_budget_val||' '||l_budgeted_fte_date);
1244: --
1245: -- Set the Process Log Context Level for the Position
1246: --
1247: pqh_process_batch_log.set_context_level
1248: (
1249: p_txn_id =>l_position.position_id,
1250: p_txn_table_route_id =>l_table_route_id,
1251: p_level =>p_level1+2,

Line 1258: pqh_process_batch_log.insert_log

1254:
1255: --
1256: -- Insert the Log for the position
1257: --
1258: pqh_process_batch_log.insert_log
1259: (
1260: p_message_type_cd =>l_message_type,
1261: p_message_text =>l_message,
1262: p_information3 =>round(l_budgeted_val,2),

Line 1497: pqh_process_batch_log.start_log

1493: hr_utility.set_location('l_batch_id : '||l_batch_id ||' - ' || l_proc_name, 15);
1494: --
1495: -- Create the start record into the Process Log
1496: --
1497: pqh_process_batch_log.start_log
1498: (
1499: p_batch_id =>l_batch_id,
1500: p_module_cd =>'POSITION_BUDGET_ANALYSIS',
1501: p_log_context =>p_batch_name,

Line 1568: pqh_process_batch_log.end_log;

1564: end if;
1565: --
1566: -- End the Process Log
1567: --
1568: pqh_process_batch_log.end_log;
1569: hr_utility.set_location('End Process'
1570: ||' '||l_proc_name, 180);
1571: commit;
1572: exception

Line 1722: pqh_process_batch_log.start_log

1718: hr_utility.set_location('l_end_date: '||to_char(l_end_date), 157);
1719: --
1720: -- Create the start record into the Process Log
1721: --
1722: pqh_process_batch_log.start_log
1723: (
1724: p_batch_id =>l_batch_id,
1725: p_module_cd =>'POSITION_BUDGET_ANALYSIS',
1726: p_log_context =>p_batch_name,

Line 1770: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||

1766: l_message_type := 'ERROR';
1767: else
1768: l_message_type := 'WARNING';
1769: end if;
1770: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||
1771: l_message_type_cd||l_proc_name, 105);
1772: hr_utility.set_location('before pqh.set_context_level l_table_route_id: '||
1773: l_table_route_id, 105);
1774: --

Line 1777: /*pqh_process_batch_log.set_context_level

1773: l_table_route_id, 105);
1774: --
1775: -- Set the Process Log Context level....What should it be?
1776: --
1777: /*pqh_process_batch_log.set_context_level
1778: (
1779: p_txn_id =>l_organization.organization_id,
1780: p_txn_table_route_id =>l_table_route_id,
1781: p_level =>l_organization.level1 + 1,

Line 1895: pqh_process_batch_log.set_context_level

1891: fnd_file.put_line(FND_FILE.LOG,l_job.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||l_commitment_val||' '||l_under_budget_val||' ');
1892: --
1893: -- Set the Process Log Context Level for the job
1894: --
1895: pqh_process_batch_log.set_context_level
1896: (
1897: p_txn_id =>l_job.job_id,
1898: p_txn_table_route_id =>l_table_route_id, -- later
1899: p_level =>1,

Line 1906: pqh_process_batch_log.insert_log

1902:
1903: --
1904: -- Insert the Log for the job
1905: --
1906: pqh_process_batch_log.insert_log
1907: (
1908: p_message_type_cd =>l_message_type,
1909: p_message_text =>l_message,
1910: p_information3 =>round(l_budgeted_val,2),

Line 2014: pqh_process_batch_log.set_context_level

2010: --
2011: --
2012: -- Set the Process Log Context Level for the Job
2013: --
2014: pqh_process_batch_log.set_context_level
2015: (
2016: p_txn_id =>l_job.job_id,
2017: p_txn_table_route_id =>l_table_route_id,
2018: p_level =>1,

Line 2025: pqh_process_batch_log.insert_log

2021:
2022: --
2023: -- Insert the Log for the Job
2024: --
2025: pqh_process_batch_log.insert_log
2026: (
2027: p_message_type_cd =>l_message_type,
2028: p_message_text =>l_message,
2029: p_information3 =>round(l_budgeted_val,2),

Line 2135: pqh_process_batch_log.set_context_level

2131:
2132: --
2133: -- Set the Process Log Context Level for the job
2134: --
2135: pqh_process_batch_log.set_context_level
2136: (
2137: p_txn_id =>l_job.job_id,
2138: p_txn_table_route_id =>l_table_route_id,
2139: p_level =>1,

Line 2146: pqh_process_batch_log.insert_log

2142:
2143: --
2144: -- Insert the Log for the job
2145: --
2146: pqh_process_batch_log.insert_log
2147: (
2148: p_message_type_cd =>l_message_type,
2149: p_message_text =>l_message,
2150: p_information3 =>round(l_budgeted_val,2),

Line 2178: pqh_process_batch_log.end_log;

2174: --
2175: --
2176: -- End the Process Log
2177: --
2178: pqh_process_batch_log.end_log;
2179: hr_utility.set_location('End Process'
2180: ||' '||l_proc_name, 180);
2181: commit;
2182: exception

Line 2327: pqh_process_batch_log.start_log

2323: hr_utility.set_location('l_batch_id : '||l_batch_id ||' - ' || l_proc_name, 15);
2324: --
2325: -- Create the start record into the Process Log
2326: --
2327: pqh_process_batch_log.start_log
2328: (
2329: p_batch_id =>l_batch_id,
2330: p_module_cd =>'POSITION_BUDGET_ANALYSIS',
2331: p_log_context =>p_batch_name,

Line 2375: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||

2371: l_message_type := 'ERROR';
2372: else
2373: l_message_type := 'WARNING';
2374: end if;
2375: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||
2376: l_message_type_cd||l_proc_name, 105);
2377: hr_utility.set_location('before pqh.set_context_level l_table_route_id: '||
2378: l_table_route_id, 105);
2379: --

Line 2382: /*pqh_process_batch_log.set_context_level

2378: l_table_route_id, 105);
2379: --
2380: -- Set the Process Log Context level....What should it be?
2381: --
2382: /*pqh_process_batch_log.set_context_level
2383: (
2384: p_txn_id =>l_organization.organization_id,
2385: p_txn_table_route_id =>l_table_route_id,
2386: p_level =>l_organization.level1 + 1,

Line 2497: pqh_process_batch_log.set_context_level

2493: fnd_file.put_line(FND_FILE.LOG,l_grade.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||l_commitment_val||' '||l_under_budget_val||' ');
2494: --
2495: -- Set the Process Log Context Level for the grade
2496: --
2497: pqh_process_batch_log.set_context_level
2498: (
2499: p_txn_id =>l_grade.grade_id,
2500: p_txn_table_route_id =>l_table_route_id, -- later
2501: p_level =>1,

Line 2508: pqh_process_batch_log.insert_log

2504:
2505: --
2506: -- Insert the Log for the grade
2507: --
2508: pqh_process_batch_log.insert_log
2509: (
2510: p_message_type_cd =>l_message_type,
2511: p_message_text =>l_message,
2512: p_information3 =>round(l_budgeted_val,2),

Line 2616: pqh_process_batch_log.set_context_level

2612: fnd_file.put_line(FND_FILE.LOG,l_grade.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||0||' '||l_under_budget_val||' ');
2613: --
2614: -- Set the Process Log Context Level for the Grade
2615: --
2616: pqh_process_batch_log.set_context_level
2617: (
2618: p_txn_id =>l_grade.grade_id,
2619: p_txn_table_route_id =>l_table_route_id,
2620: p_level =>1,

Line 2627: pqh_process_batch_log.insert_log

2623:
2624: --
2625: -- Insert the Log for the Grade
2626: --
2627: pqh_process_batch_log.insert_log
2628: (
2629: p_message_type_cd =>l_message_type,
2630: p_message_text =>l_message,
2631: p_information3 =>round(l_budgeted_val,2),

Line 2735: pqh_process_batch_log.set_context_level

2731: fnd_file.put_line(FND_FILE.LOG,l_grade.name||' '||l_budgeted_val||' '||l_reallocation_val||' '||l_actual_val||' '||0||' '||l_under_budget_val||' '||l_budgeted_fte_date);
2732: --
2733: -- Set the Process Log Context Level for the grade
2734: --
2735: pqh_process_batch_log.set_context_level
2736: (
2737: p_txn_id =>l_grade.grade_id,
2738: p_txn_table_route_id =>l_table_route_id,
2739: p_level =>1,

Line 2746: pqh_process_batch_log.insert_log

2742:
2743: --
2744: -- Insert the Log for the grade
2745: --
2746: pqh_process_batch_log.insert_log
2747: (
2748: p_message_type_cd =>l_message_type,
2749: p_message_text =>l_message,
2750: p_information3 =>round(l_budgeted_val,2),

Line 2778: pqh_process_batch_log.end_log;

2774: --
2775: --
2776: -- End the Process Log
2777: --
2778: pqh_process_batch_log.end_log;
2779: hr_utility.set_location('End Process'
2780: ||' '||l_proc_name, 180);
2781: commit;
2782: exception

Line 2882: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||

2878: l_message_type := 'ERROR';
2879: else
2880: l_message_type := 'WARNING';
2881: end if;
2882: hr_utility.set_location('before pqh_process_batch_log.set_context_level : '||
2883: l_message_type_cd||l_proc_name, 105);
2884: hr_utility.set_location('before pqh.set_context_level organization_id: '||
2885: p_organization_id, 105);
2886: hr_utility.set_location('before pqh.set_context_level l_table_route_id: '||

Line 2895: pqh_process_batch_log.set_context_level

2891: hr_general.decode_organization(p_organization_id), 105);
2892: --
2893: -- Set the Process Log Context level for the Organization
2894: --
2895: pqh_process_batch_log.set_context_level
2896: (
2897: p_txn_id =>p_organization_id,
2898: p_txn_table_route_id =>l_table_route_id,
2899: p_level =>p_level1 + 1,

Line 2990: pqh_process_batch_log.set_context_level

2986: --
2987: -- Set the Process Log Context Level for the Organization
2988: --
2989: /*
2990: pqh_process_batch_log.set_context_level
2991: (
2992: p_txn_id =>l_organization.organization_id,
2993: p_txn_table_route_id =>l_table_route_id,
2994: p_level =>l_organization.level1+2,

Line 3001: pqh_process_batch_log.insert_log

2997: */
2998: --
2999: -- Insert the Log for the organization
3000: --
3001: pqh_process_batch_log.insert_log
3002: (
3003: p_message_type_cd =>l_message_type,
3004: p_message_text =>l_message,
3005: p_information3 =>round(l_budgeted_val,2),

Line 3094: pqh_process_batch_log.set_context_level

3090: --
3091: -- Set the Process Log Context Level for the organization
3092: --
3093: /*
3094: pqh_process_batch_log.set_context_level
3095: (
3096: p_txn_id =>l_organization.organization_id,
3097: p_txn_table_route_id =>l_table_route_id,
3098: p_level =>l_organization.level1+2,

Line 3105: pqh_process_batch_log.insert_log

3101: */
3102: --
3103: -- Insert the Log for the organization
3104: --
3105: pqh_process_batch_log.insert_log
3106: (
3107: p_message_type_cd =>l_message_type,
3108: p_message_text =>l_message,
3109: p_information3 =>round(l_budgeted_val,2),

Line 3197: pqh_process_batch_log.set_context_level

3193: --
3194: -- Set the Process Log Context Level for the organization
3195: --
3196: /*
3197: pqh_process_batch_log.set_context_level
3198: (
3199: p_txn_id =>l_organization.organization_id,
3200: p_txn_table_route_id =>l_table_route_id,
3201: p_level =>l_organization.level1+2,

Line 3208: pqh_process_batch_log.insert_log

3204: */
3205: --
3206: -- Insert the Log for the organization
3207: --
3208: pqh_process_batch_log.insert_log
3209: (
3210: p_message_type_cd =>l_message_type,
3211: p_message_text =>l_message,
3212: p_information3 =>round(l_budgeted_val,2),

Line 3418: pqh_process_batch_log.start_log

3414: hr_utility.set_location('l_batch_id : '||l_batch_id ||' - ' || l_proc_name, 15);
3415: --
3416: -- Create the start record into the Process Log
3417: --
3418: pqh_process_batch_log.start_log
3419: (
3420: p_batch_id =>l_batch_id,
3421: p_module_cd =>'POSITION_BUDGET_ANALYSIS',
3422: p_log_context =>p_batch_name,

Line 3492: pqh_process_batch_log.end_log;

3488: end if;
3489: --
3490: -- End the Process Log
3491: --
3492: pqh_process_batch_log.end_log;
3493: hr_utility.set_location('End Process'
3494: ||' '||l_proc_name, 180);
3495: commit;
3496: exception