DBA Data[Home] [Help]

APPS.HR_DK_UTILITY dependencies on HR_UTILITY

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

226: p_is_iban_acc IN varchar2 ) RETURN NUMBER IS
227: --
228: l_ret NUMBER ;
229: begin
230: -- hr_utility.trace_on(null,'ACCVAL');
231: l_ret :=0;
232: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
233: hr_utility.set_location('p_account_number ' || p_acc_no,1);
234:

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

228: l_ret NUMBER ;
229: begin
230: -- hr_utility.trace_on(null,'ACCVAL');
231: l_ret :=0;
232: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
233: hr_utility.set_location('p_account_number ' || p_acc_no,1);
234:
235: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
236: l_ret := validate_account_number(p_acc_no);

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

229: begin
230: -- hr_utility.trace_on(null,'ACCVAL');
231: l_ret :=0;
232: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
233: hr_utility.set_location('p_account_number ' || p_acc_no,1);
234:
235: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
236: l_ret := validate_account_number(p_acc_no);
237: hr_utility.set_location('l_ret ' || l_ret,1);

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

233: hr_utility.set_location('p_account_number ' || p_acc_no,1);
234:
235: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
236: l_ret := validate_account_number(p_acc_no);
237: hr_utility.set_location('l_ret ' || l_ret,1);
238: RETURN l_ret;
239: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
240: l_ret := validate_iban_acc(p_acc_no);
241: hr_utility.set_location('l_ret ' || l_ret,3);

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

237: hr_utility.set_location('l_ret ' || l_ret,1);
238: RETURN l_ret;
239: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
240: l_ret := validate_iban_acc(p_acc_no);
241: hr_utility.set_location('l_ret ' || l_ret,3);
242: RETURN l_ret;
243: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
244: hr_utility.set_location('Both Account Nos Null',4);
245: RETURN 1;

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

240: l_ret := validate_iban_acc(p_acc_no);
241: hr_utility.set_location('l_ret ' || l_ret,3);
242: RETURN l_ret;
243: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
244: hr_utility.set_location('Both Account Nos Null',4);
245: RETURN 1;
246: ELSE
247: hr_utility.set_location('l_ret: 3 ' ,5);
248: RETURN 3;

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

243: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
244: hr_utility.set_location('Both Account Nos Null',4);
245: RETURN 1;
246: ELSE
247: hr_utility.set_location('l_ret: 3 ' ,5);
248: RETURN 3;
249: END if;
250: End validate_account_entered;
251:

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

534: --l_proc varchar2(72) := g_package||'.get_message';
535: --
536: begin
537: --
538: --hr_utility.set_location('Entered '||l_proc,5);
539: hr_utility.set_location('. Message Name: '||p_message_name,40);
540: fnd_message.set_name(p_product, p_message_name);
541: if p_token1 is not null then
542: /* Obtain token 1 name and value */

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

535: --
536: begin
537: --
538: --hr_utility.set_location('Entered '||l_proc,5);
539: hr_utility.set_location('. Message Name: '||p_message_name,40);
540: fnd_message.set_name(p_product, p_message_name);
541: if p_token1 is not null then
542: /* Obtain token 1 name and value */
543: l_colon_position := instr(p_token1,':');

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

543: l_colon_position := instr(p_token1,':');
544: l_token_name := substr(p_token1,1,l_colon_position-1);
545: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
546: fnd_message.set_token(l_token_name, l_token_value);
547: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
548: end if;
549: if p_token2 is not null then
550: /* Obtain token 2 name and value */
551: l_colon_position := instr(p_token2,':');

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

551: l_colon_position := instr(p_token2,':');
552: l_token_name := substr(p_token2,1,l_colon_position-1);
553: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
554: fnd_message.set_token(l_token_name, l_token_value);
555: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
556: end if;
557: if p_token3 is not null then
558: /* Obtain token 3 name and value */
559: l_colon_position := instr(p_token3,':');

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

559: l_colon_position := instr(p_token3,':');
560: l_token_name := substr(p_token3,1,l_colon_position-1);
561: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
562: fnd_message.set_token(l_token_name, l_token_value);
563: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
564: end if;
565: l_message := substr(fnd_message.get,1,254);
566: --hr_utility.set_location('leaving '||l_proc,100);
567: return l_message;

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

562: fnd_message.set_token(l_token_name, l_token_value);
563: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
564: end if;
565: l_message := substr(fnd_message.get,1,254);
566: --hr_utility.set_location('leaving '||l_proc,100);
567: return l_message;
568: end get_message;
569:
570: -----------------------------------------------------------