DBA Data[Home] [Help]

APPS.PQP_RIW_GRADE_WRAPPER dependencies on HR_UTILITY

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

111: return grade_record is
112: l_proc_name constant varchar2(150) := g_package||'.get_default_grade_rec';
113: l_grade_rec grade_record;
114: begin
115: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
116: /*
117: ==========================================================================
118: g_varchar2 constant varchar2(9) := '$Sys_Def$';
119: g_number constant number := -987123654;

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

215: return l_grade_rec;
216:
217: exception
218: when others then
219: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
220: raise;
221: end get_default_grade_rec;
222:
223: -- =============================================================================

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

243: l_grade_rec grade_record;
244: col_name varchar2(150);
245: l_proc_name constant varchar2(150) := g_package||'.Get_Grade_Record_Values';
246: begin
247: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
248: l_grade_rec := get_default_grade_rec;
249: for col_rec in bne_cols (g_interface_code)
250: loop
251:

Line 479: hr_utility.trace('returning grade record');

475: null;
476:
477: end case;
478: end loop;
479: hr_utility.trace('returning grade record');
480: return l_grade_rec;
481: end Get_grade_Record_Values;
482:
483: procedure Set_Cur_Grade_record_Values

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

719: from per_business_groups_perf pbg
720: where pbg.business_group_id = p_business_group_id;
721:
722: begin
723: hr_utility.trace('entering ' || l_proc);
724: --
725: -- check that flex structure is valid
726: --
727: open isdel;

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

731: close isdel;
732: --
733: -- the flex structure has not been found
734: --
735: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
736: hr_utility.raise_error;
737: end if;
738: close isdel;
739:

Line 736: hr_utility.raise_error;

732: --
733: -- the flex structure has not been found
734: --
735: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
736: hr_utility.raise_error;
737: end if;
738: close isdel;
739:
740: hr_kflex_utility.ins_or_sel_keyflex_comb

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

1263: end if;
1264: Exception
1265:
1266: when e_upl_not_allowed then
1267: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1268: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then

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

1264: Exception
1265:
1266: when e_upl_not_allowed then
1267: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1268: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

1265:
1266: when e_upl_not_allowed then
1267: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1268: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 1270: hr_utility.raise_error;

1266: when e_upl_not_allowed then
1267: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1268: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

1268: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then

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

1269: hr_utility.set_location('Leaving: ' || l_proc, 90);
1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

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

1270: hr_utility.raise_error;
1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 1275: hr_utility.raise_error;

1271: when e_crt_not_allowed then
1272: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1279: hr_utility.set_location(' Leaving:' || l_proc,50);

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

1273: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1279: hr_utility.set_location(' Leaving:' || l_proc,50);
1280: hr_utility.raise_error;
1281:

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

1274: hr_utility.set_location('Leaving: ' || l_proc, 100);
1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1279: hr_utility.set_location(' Leaving:' || l_proc,50);
1280: hr_utility.raise_error;
1281:
1282:

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

1275: hr_utility.raise_error;
1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1279: hr_utility.set_location(' Leaving:' || l_proc,50);
1280: hr_utility.raise_error;
1281:
1282:
1283: end INSUPD_GRADE;

Line 1280: hr_utility.raise_error;

1276: when others then
1277: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1278: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
1279: hr_utility.set_location(' Leaving:' || l_proc,50);
1280: hr_utility.raise_error;
1281:
1282:
1283: end INSUPD_GRADE;
1284: end PQP_RIW_GRADE_WRAPPER;