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

Line 109: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

105: return job_record is
106: l_proc_name constant varchar2(150) := g_package||'get_default_job_rec';
107: l_job_rec job_record;
108: begin
109: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
110: /*
111: ==========================================================================
112: g_varchar2 constant varchar2(9) := '$Sys_Def$';
113: g_number constant number := -987123654;

Line 206: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

202: return l_job_rec;
203:
204: exception
205: when others then
206: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
207: raise;
208: end get_default_job_rec;
209:
210:

Line 235: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

231: l_job_rec job_record;
232: col_name varchar2(150);
233: l_proc_name constant varchar2(150) := g_package||'.Get_Job_Record_Values';
234: begin
235: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
236: l_job_rec := get_default_job_rec;
237: for col_rec in bne_cols (g_interface_code)
238: loop
239: hr_utility.set_location(' col_rec.interface_col_name : ' || col_rec.interface_col_name, 15);

Line 239: hr_utility.set_location(' col_rec.interface_col_name : ' || col_rec.interface_col_name, 15);

235: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
236: l_job_rec := get_default_job_rec;
237: for col_rec in bne_cols (g_interface_code)
238: loop
239: hr_utility.set_location(' col_rec.interface_col_name : ' || col_rec.interface_col_name, 15);
240: case col_rec.interface_col_name
241:
242: when 'p_business_group_id' then
243: l_job_rec.business_group_id := g_job_rec.business_group_id;

Line 452: Hr_Utility.set_location(' Leaving: '||l_proc_name, 20);

448: null;
449: end case;
450: end loop;
451:
452: Hr_Utility.set_location(' Leaving: '||l_proc_name, 20);
453: return l_job_rec;
454: end Get_Job_Record_Values;
455:
456: procedure Set_Current_Job_record_Values

Line 545: hr_utility.trace('job id set in set current is : ' || p_job_id);

541: ,p_job_definition_id in number
542: ,p_interface_code in varchar2
543: ) is
544: begin
545: hr_utility.trace('job id set in set current is : ' || p_job_id);
546: g_interface_code := nvl(p_interface_code,'PQP_RIW_JOB_INTF');
547: g_job_rec.business_group_id := p_business_group_id;
548: g_job_rec.date_from := p_date_from;
549: g_job_rec.comments := p_comments;

Line 726: hr_utility.trace('job id : ' || p_job_id);

722: l_obj_ver_num number(3);
723: l_name per_jobs.name%TYPE;
724: l_valid_grades_changed_warning boolean;
725: begin
726: hr_utility.trace('job id : ' || p_job_id);
727: select object_version_number into l_obj_ver_num from per_jobs
728: where JOB_ID=p_job_id;
729: hr_job_api.update_job
730: (p_validate => l_validate

Line 867: hr_utility.trace('entering ' || l_proc);

863: from per_job_groups pjg
864: where pjg.job_group_id = p_job_group_id;
865:
866: begin
867: hr_utility.trace('entering ' || l_proc);
868: open idsel;
869: fetch idsel into l_flex_num;
870: if idsel%notfound
871: then

Line 876: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');

872: close idsel;
873: --
874: -- the flex structure has not been found
875: --
876: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
877: hr_utility.raise_error;
878: end if;
879: close idsel;
880:

Line 877: hr_utility.raise_error;

873: --
874: -- the flex structure has not been found
875: --
876: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
877: hr_utility.raise_error;
878: end if;
879: close idsel;
880:
881: hr_kflex_utility.ins_or_sel_keyflex_comb

Line 1383: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1379: end if;
1380: Exception
1381:
1382: when e_upl_not_allowed then
1383: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then

Line 1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);

1380: Exception
1381:
1382: when e_upl_not_allowed then
1383: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 1385: hr_utility.set_location('Leaving: ' || l_proc, 90);

1381:
1382: when e_upl_not_allowed then
1383: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 1386: hr_utility.raise_error;

1382: when e_upl_not_allowed then
1383: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1390: hr_utility.set_location('Leaving: ' || l_proc, 100);

Line 1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1384: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1390: hr_utility.set_location('Leaving: ' || l_proc, 100);
1391: hr_utility.raise_error;
1392: when others then

Line 1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

1385: hr_utility.set_location('Leaving: ' || l_proc, 90);
1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1390: hr_utility.set_location('Leaving: ' || l_proc, 100);
1391: hr_utility.raise_error;
1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);

Line 1390: hr_utility.set_location('Leaving: ' || l_proc, 100);

1386: hr_utility.raise_error;
1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1390: hr_utility.set_location('Leaving: ' || l_proc, 100);
1391: hr_utility.raise_error;
1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 1391: hr_utility.raise_error;

1387: when e_crt_not_allowed then
1388: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1389: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1390: hr_utility.set_location('Leaving: ' || l_proc, 100);
1391: hr_utility.raise_error;
1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

1390: hr_utility.set_location('Leaving: ' || l_proc, 100);
1391: hr_utility.raise_error;
1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);

Line 1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

1391: hr_utility.raise_error;
1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);
1399: hr_utility.raise_error;

Line 1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1392: when others then
1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);
1399: hr_utility.raise_error;
1400:

Line 1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );

1393: --l_error_msg := Substr(SQLERRM,1,2000);
1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);
1399: hr_utility.raise_error;
1400:
1401:

Line 1398: hr_utility.set_location(' Leaving:' || l_proc,50);

1394: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);
1399: hr_utility.raise_error;
1400:
1401:
1402:

Line 1399: hr_utility.raise_error;

1395: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1396: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1397: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,50) );
1398: hr_utility.set_location(' Leaving:' || l_proc,50);
1399: hr_utility.raise_error;
1400:
1401:
1402:
1403: end INSUPD_JOB;