DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on HR_UTILITY

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

247: p_is_iban_acc IN varchar2 ) RETURN NUMBER IS
248: --
249: l_ret NUMBER ;
250: begin
251: -- hr_utility.trace_on(null,'ACCVAL');
252: l_ret :=0;
253: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
254: hr_utility.set_location('p_account_number ' || p_acc_no,1);
255:

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

249: l_ret NUMBER ;
250: begin
251: -- hr_utility.trace_on(null,'ACCVAL');
252: l_ret :=0;
253: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
254: hr_utility.set_location('p_account_number ' || p_acc_no,1);
255:
256: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
257: l_ret := validate_account_number(p_acc_no);

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

250: begin
251: -- hr_utility.trace_on(null,'ACCVAL');
252: l_ret :=0;
253: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
254: hr_utility.set_location('p_account_number ' || p_acc_no,1);
255:
256: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
257: l_ret := validate_account_number(p_acc_no);
258: hr_utility.set_location('l_ret ' || l_ret,1);

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

254: hr_utility.set_location('p_account_number ' || p_acc_no,1);
255:
256: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
257: l_ret := validate_account_number(p_acc_no);
258: hr_utility.set_location('l_ret ' || l_ret,1);
259: RETURN l_ret;
260: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
261: l_ret := validate_iban_acc(p_acc_no);
262: hr_utility.set_location('l_ret ' || l_ret,3);

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

258: hr_utility.set_location('l_ret ' || l_ret,1);
259: RETURN l_ret;
260: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
261: l_ret := validate_iban_acc(p_acc_no);
262: hr_utility.set_location('l_ret ' || l_ret,3);
263: RETURN l_ret;
264: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
265: hr_utility.set_location('Both Account Nos Null',4);
266: RETURN 1;

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

261: l_ret := validate_iban_acc(p_acc_no);
262: hr_utility.set_location('l_ret ' || l_ret,3);
263: RETURN l_ret;
264: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
265: hr_utility.set_location('Both Account Nos Null',4);
266: RETURN 1;
267: ELSE
268: hr_utility.set_location('l_ret: 3 ' ,5);
269: RETURN 3;

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

264: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
265: hr_utility.set_location('Both Account Nos Null',4);
266: RETURN 1;
267: ELSE
268: hr_utility.set_location('l_ret: 3 ' ,5);
269: RETURN 3;
270: END if;
271: End validate_account_entered;
272:

Line 600: hr_utility.set_location('Entered '||l_proc,5);

596: l_proc varchar2(72) := g_package||'.get_message';
597: --
598: begin
599: --
600: hr_utility.set_location('Entered '||l_proc,5);
601: hr_utility.set_location('. Message Name: '||p_message_name,40);
602: fnd_message.set_name(p_product, p_message_name);
603: if p_token1 is not null then
604: /* Obtain token 1 name and value */

Line 601: hr_utility.set_location('. Message Name: '||p_message_name,40);

597: --
598: begin
599: --
600: hr_utility.set_location('Entered '||l_proc,5);
601: hr_utility.set_location('. Message Name: '||p_message_name,40);
602: fnd_message.set_name(p_product, p_message_name);
603: if p_token1 is not null then
604: /* Obtain token 1 name and value */
605: l_colon_position := instr(p_token1,':');

Line 609: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);

605: l_colon_position := instr(p_token1,':');
606: l_token_name := substr(p_token1,1,l_colon_position-1);
607: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
608: fnd_message.set_token(l_token_name, l_token_value);
609: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
610: end if;
611: if p_token2 is not null then
612: /* Obtain token 2 name and value */
613: l_colon_position := instr(p_token2,':');

Line 617: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);

613: l_colon_position := instr(p_token2,':');
614: l_token_name := substr(p_token2,1,l_colon_position-1);
615: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
616: fnd_message.set_token(l_token_name, l_token_value);
617: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
618: end if;
619: if p_token3 is not null then
620: /* Obtain token 3 name and value */
621: l_colon_position := instr(p_token3,':');

Line 625: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);

621: l_colon_position := instr(p_token3,':');
622: l_token_name := substr(p_token3,1,l_colon_position-1);
623: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
624: fnd_message.set_token(l_token_name, l_token_value);
625: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
626: end if;
627: l_message := substr(fnd_message.get,1,254);
628: hr_utility.set_location('leaving '||l_proc,100);
629: return l_message;

Line 628: hr_utility.set_location('leaving '||l_proc,100);

624: fnd_message.set_token(l_token_name, l_token_value);
625: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
626: end if;
627: l_message := substr(fnd_message.get,1,254);
628: hr_utility.set_location('leaving '||l_proc,100);
629: return l_message;
630: end get_message;
631:
632: ------------------------------------------------------------------------

Line 964: hr_utility.trace('IANA Charset = '||lv_iana_charset);

960: OPEN csr_get_iana_charset;
961: FETCH csr_get_iana_charset INTO lv_iana_charset;
962: CLOSE csr_get_iana_charset;
963:
964: hr_utility.trace('IANA Charset = '||lv_iana_charset);
965: RETURN (lv_iana_charset);
966: END get_IANA_charset;
967:
968: