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

Line 204: -- hr_utility.trace_on(null,'ACCVAL');

200: p_is_iban_acc IN varchar2 ) RETURN NUMBER IS
201: --
202: l_ret NUMBER ;
203: begin
204: -- hr_utility.trace_on(null,'ACCVAL');
205: l_ret :=0;
206: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
207: hr_utility.set_location('p_account_number ' || p_acc_no,1);
208:

Line 206: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);

202: l_ret NUMBER ;
203: begin
204: -- hr_utility.trace_on(null,'ACCVAL');
205: l_ret :=0;
206: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
207: hr_utility.set_location('p_account_number ' || p_acc_no,1);
208:
209: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
210: l_ret := validate_account_no(p_acc_no);

Line 207: hr_utility.set_location('p_account_number ' || p_acc_no,1);

203: begin
204: -- hr_utility.trace_on(null,'ACCVAL');
205: l_ret :=0;
206: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
207: hr_utility.set_location('p_account_number ' || p_acc_no,1);
208:
209: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
210: l_ret := validate_account_no(p_acc_no);
211: hr_utility.set_location('l_ret ' || l_ret,1);

Line 211: hr_utility.set_location('l_ret ' || l_ret,1);

207: hr_utility.set_location('p_account_number ' || p_acc_no,1);
208:
209: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
210: l_ret := validate_account_no(p_acc_no);
211: hr_utility.set_location('l_ret ' || l_ret,1);
212: RETURN l_ret;
213: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
214: l_ret := validate_iban_acc(p_acc_no);
215: hr_utility.set_location('l_ret ' || l_ret,3);

Line 215: hr_utility.set_location('l_ret ' || l_ret,3);

211: hr_utility.set_location('l_ret ' || l_ret,1);
212: RETURN l_ret;
213: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
214: l_ret := validate_iban_acc(p_acc_no);
215: hr_utility.set_location('l_ret ' || l_ret,3);
216: RETURN l_ret;
217: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
218: hr_utility.set_location('Both Account Nos Null',4);
219: RETURN 1;

Line 218: hr_utility.set_location('Both Account Nos Null',4);

214: l_ret := validate_iban_acc(p_acc_no);
215: hr_utility.set_location('l_ret ' || l_ret,3);
216: RETURN l_ret;
217: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
218: hr_utility.set_location('Both Account Nos Null',4);
219: RETURN 1;
220: ELSE
221: hr_utility.set_location('l_ret: 3 ' ,5);
222: RETURN 3;

Line 221: hr_utility.set_location('l_ret: 3 ' ,5);

217: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
218: hr_utility.set_location('Both Account Nos Null',4);
219: RETURN 1;
220: ELSE
221: hr_utility.set_location('l_ret: 3 ' ,5);
222: RETURN 3;
223: END if;
224: End validate_account_entered;
225:

Line 396: hr_utility.set_message(800, 'HR_HU_INVALID_SS_NO');

392: l_ss_no VARCHAR2(10);
393: BEGIN
394: l_ss_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDD-A');
395: IF l_ss_no ='0' THEN
396: hr_utility.set_message(800, 'HR_HU_INVALID_SS_NO');
397: hr_utility.raise_error;
398: END IF;
399: END validate_ss_no;
400: ---------------------------------------------------------------

Line 397: hr_utility.raise_error;

393: BEGIN
394: l_ss_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDD-A');
395: IF l_ss_no ='0' THEN
396: hr_utility.set_message(800, 'HR_HU_INVALID_SS_NO');
397: hr_utility.raise_error;
398: END IF;
399: END validate_ss_no;
400: ---------------------------------------------------------------
401: PROCEDURE validate_tax_no(p_org_info VARCHAR2) is

Line 405: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');

401: PROCEDURE validate_tax_no(p_org_info VARCHAR2) is
402: l_tax_no VARCHAR2(15);
403: BEGIN
404: IF p_org_info = '00000000-0-00' THEN
405: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
406: hr_utility.raise_error;
407: END IF;
408:
409: IF (instr(p_org_info,'-',1,1) <> 9 OR instr(p_org_info,'-',1,2) <> 11) THEN

Line 406: hr_utility.raise_error;

402: l_tax_no VARCHAR2(15);
403: BEGIN
404: IF p_org_info = '00000000-0-00' THEN
405: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
406: hr_utility.raise_error;
407: END IF;
408:
409: IF (instr(p_org_info,'-',1,1) <> 9 OR instr(p_org_info,'-',1,2) <> 11) THEN
410: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');

Line 410: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');

406: hr_utility.raise_error;
407: END IF;
408:
409: IF (instr(p_org_info,'-',1,1) <> 9 OR instr(p_org_info,'-',1,2) <> 11) THEN
410: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
411: hr_utility.raise_error;
412: END IF;
413:
414: l_tax_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDDD-D-DD');

Line 411: hr_utility.raise_error;

407: END IF;
408:
409: IF (instr(p_org_info,'-',1,1) <> 9 OR instr(p_org_info,'-',1,2) <> 11) THEN
410: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
411: hr_utility.raise_error;
412: END IF;
413:
414: l_tax_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDDD-D-DD');
415: IF l_tax_no ='0' THEN

Line 416: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');

412: END IF;
413:
414: l_tax_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDDD-D-DD');
415: IF l_tax_no ='0' THEN
416: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
417: hr_utility.raise_error;
418: END IF;
419: END validate_tax_no;
420: ---------------------------------------------------------------

Line 417: hr_utility.raise_error;

413:
414: l_tax_no := hr_ni_chk_pkg.chk_nat_id_format(p_org_info,'DDDDDDDD-D-DD');
415: IF l_tax_no ='0' THEN
416: hr_utility.set_message(800, 'HR_HU_INVALID_TAX_NO');
417: hr_utility.raise_error;
418: END IF;
419: END validate_tax_no;
420: ---------------------------------------------------------------
421: PROCEDURE validate_cs_no(p_org_info4 VARCHAR2

Line 428: hr_utility.set_message(800, 'HR_HU_INVALID_CS_NO');

424: l_cs_no VARCHAR2(8);
425: BEGIN
426: l_cs_no := substr(p_org_info4,1,8);
427: IF l_cs_no <> p_org_info5 THEN
428: hr_utility.set_message(800, 'HR_HU_INVALID_CS_NO');
429: hr_utility.raise_error;
430: END IF;
431: END validate_cs_no;
432: -----------------------------------------------------------------

Line 429: hr_utility.raise_error;

425: BEGIN
426: l_cs_no := substr(p_org_info4,1,8);
427: IF l_cs_no <> p_org_info5 THEN
428: hr_utility.set_message(800, 'HR_HU_INVALID_CS_NO');
429: hr_utility.raise_error;
430: END IF;
431: END validate_cs_no;
432: -----------------------------------------------------------------
433:

Line 459: hr_utility.set_message(800, 'HR_HU_NI_UNIQUE_WARNING');

455: AND p_identifier = pp.per_information2
456: AND pp.business_group_id = p_business_group_id);
457: --
458: IF l_status = 'Y' THEN
459: hr_utility.set_message(800, 'HR_HU_NI_UNIQUE_WARNING');
460: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('HU_FORM_LABELS','TAX_ID_NO'));
461: hr_utility.raise_error;
462: END IF;
463: --

Line 460: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('HU_FORM_LABELS','TAX_ID_NO'));

456: AND pp.business_group_id = p_business_group_id);
457: --
458: IF l_status = 'Y' THEN
459: hr_utility.set_message(800, 'HR_HU_NI_UNIQUE_WARNING');
460: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('HU_FORM_LABELS','TAX_ID_NO'));
461: hr_utility.raise_error;
462: END IF;
463: --
464: EXCEPTION

Line 461: hr_utility.raise_error;

457: --
458: IF l_status = 'Y' THEN
459: hr_utility.set_message(800, 'HR_HU_NI_UNIQUE_WARNING');
460: hr_utility.set_message_token('NI_NUMBER',hr_general.decode_lookup('HU_FORM_LABELS','TAX_ID_NO'));
461: hr_utility.raise_error;
462: END IF;
463: --
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN NULL;