DBA Data[Home] [Help]

APPS.HR_ERRORS_API dependencies on HR_GENERAL_UTILITIES

Line 375: l_string := hr_general_utilities.Add_Separators

371: Counter number := 0;
372: --
373: begin
374: if g_errorTable.count > 0 then
375: l_string := hr_general_utilities.Add_Separators
376: ( p_instring => to_char(g_errorTable.count)
377: , p_start => TRUE
378: );
379: --

Line 390: || hr_general_utilities.Add_Separators

386: l_tmpflag := 'N';
387: end if;
388:
389: l_string := l_string
390: || hr_general_utilities.Add_Separators
391: ( p_instring => g_errorTable(Counter).ErrorField)
392: || hr_general_utilities.Add_Separators
393: ( p_instring => g_errorTable(Counter).ErrorCode)
394: || hr_general_utilities.Add_Separators

Line 392: || hr_general_utilities.Add_Separators

388:
389: l_string := l_string
390: || hr_general_utilities.Add_Separators
391: ( p_instring => g_errorTable(Counter).ErrorField)
392: || hr_general_utilities.Add_Separators
393: ( p_instring => g_errorTable(Counter).ErrorCode)
394: || hr_general_utilities.Add_Separators
395: ( p_instring => g_errorTable(Counter).ErrorMsg)
396: || hr_general_utilities.Add_Separators

Line 394: || hr_general_utilities.Add_Separators

390: || hr_general_utilities.Add_Separators
391: ( p_instring => g_errorTable(Counter).ErrorField)
392: || hr_general_utilities.Add_Separators
393: ( p_instring => g_errorTable(Counter).ErrorCode)
394: || hr_general_utilities.Add_Separators
395: ( p_instring => g_errorTable(Counter).ErrorMsg)
396: || hr_general_utilities.Add_Separators
397: ( p_instring => l_tmpflag)
398: || hr_general_utilities.Add_Separators

Line 396: || hr_general_utilities.Add_Separators

392: || hr_general_utilities.Add_Separators
393: ( p_instring => g_errorTable(Counter).ErrorCode)
394: || hr_general_utilities.Add_Separators
395: ( p_instring => g_errorTable(Counter).ErrorMsg)
396: || hr_general_utilities.Add_Separators
397: ( p_instring => l_tmpflag)
398: || hr_general_utilities.Add_Separators
399: (p_instring => to_char(g_errorTable(Counter).RowNumber))
400: || hr_general_utilities.Add_Separators

Line 398: || hr_general_utilities.Add_Separators

394: || hr_general_utilities.Add_Separators
395: ( p_instring => g_errorTable(Counter).ErrorMsg)
396: || hr_general_utilities.Add_Separators
397: ( p_instring => l_tmpflag)
398: || hr_general_utilities.Add_Separators
399: (p_instring => to_char(g_errorTable(Counter).RowNumber))
400: || hr_general_utilities.Add_Separators
401: ( p_instring => g_errorTable(Counter).EmailId)
402: || hr_general_utilities.Add_Separators

Line 400: || hr_general_utilities.Add_Separators

396: || hr_general_utilities.Add_Separators
397: ( p_instring => l_tmpflag)
398: || hr_general_utilities.Add_Separators
399: (p_instring => to_char(g_errorTable(Counter).RowNumber))
400: || hr_general_utilities.Add_Separators
401: ( p_instring => g_errorTable(Counter).EmailId)
402: || hr_general_utilities.Add_Separators
403: ( p_instring => g_errorTable(Counter).EmailMsg);
404: Counter := g_errorTable.Next(Counter);

Line 402: || hr_general_utilities.Add_Separators

398: || hr_general_utilities.Add_Separators
399: (p_instring => to_char(g_errorTable(Counter).RowNumber))
400: || hr_general_utilities.Add_Separators
401: ( p_instring => g_errorTable(Counter).EmailId)
402: || hr_general_utilities.Add_Separators
403: ( p_instring => g_errorTable(Counter).EmailMsg);
404: Counter := g_errorTable.Next(Counter);
405: end loop;
406: end if;

Line 410: l_id := hr_general_utilitieS.EPFS

406: end if;
407: --
408: if l_string is not null then
409: -- encrypt the string
410: l_id := hr_general_utilitieS.EPFS
411: ( p_string => l_string
412: , p_type => 'G'
413: );
414: else

Line 433: hr_general_utilities.reset_g_cache;

429: l_tmpstring varchar2(32000);
430: --
431: begin
432: -- bug # 1615428
433: hr_general_utilities.reset_g_cache;
434:
435: --
436: if p_encrypt is not null then
437: -- decrypt the string

Line 443: hr_general_utilities.DEXL (i => p_encrypt);

439: -- bug # 1615428
440: -- cache initialization is moved up and made us the first call in this procedure
441: --
442: --
443: hr_general_utilities.DEXL (i => p_encrypt);
444:
445: l_tmpString := hr_general_utilities.REGS (p_index => 1);
446: -- extract the record count
447: g_count := to_number

Line 445: l_tmpString := hr_general_utilities.REGS (p_index => 1);

441: --
442: --
443: hr_general_utilities.DEXL (i => p_encrypt);
444:
445: l_tmpString := hr_general_utilities.REGS (p_index => 1);
446: -- extract the record count
447: g_count := to_number
448: (hr_general_utilities.Find_Item_In_String
449: ( p_item => 1

Line 448: (hr_general_utilities.Find_Item_In_String

444:
445: l_tmpString := hr_general_utilities.REGS (p_index => 1);
446: -- extract the record count
447: g_count := to_number
448: (hr_general_utilities.Find_Item_In_String
449: ( p_item => 1
450: , p_string => l_tmpString
451: ));
452: --

Line 461: hr_general_utilities.Find_Item_In_String

457: LOOP
458: l_index := ((Counter - 1) * 7) + 1;
459:
460: g_errorTable(Counter).ErrorField :=
461: hr_general_utilities.Find_Item_In_String
462: ( p_item => l_index + 1
463: , p_string => l_tmpString
464: ) ;
465:

Line 467: hr_general_utilities.Find_Item_In_String

463: , p_string => l_tmpString
464: ) ;
465:
466: g_errorTable(Counter).ErrorCode :=
467: hr_general_utilities.Find_Item_In_String
468: ( p_item => l_index + 2
469: , p_string => l_tmpString
470: ) ;
471:

Line 473: hr_general_utilities.Find_Item_In_String

469: , p_string => l_tmpString
470: ) ;
471:
472: g_errorTable(Counter).ErrorMsg :=
473: hr_general_utilities.Find_Item_In_String
474: ( p_item => l_index + 3
475: , p_string => l_tmpString
476: ) ;
477:

Line 479: hr_general_utilities.Find_Item_In_String

475: , p_string => l_tmpString
476: ) ;
477:
478: l_tmpflag :=
479: hr_general_utilities.Find_Item_In_String
480: ( p_item => l_index + 4
481: , p_string => l_tmpString
482: );
483:

Line 492: ( hr_general_utilities.Find_Item_In_String

488: end if;
489:
490: g_errorTable(Counter).RowNumber :=
491: to_number
492: ( hr_general_utilities.Find_Item_In_String
493: ( p_item => l_index + 5
494: , p_string => l_tmpString
495: )
496: );

Line 499: hr_general_utilities.Find_Item_In_String

495: )
496: );
497:
498: g_errorTable(Counter).EmailId :=
499: hr_general_utilities.Find_Item_In_String
500: ( p_item => l_index + 6
501: , p_string => l_tmpString
502: );
503: g_errorTable(Counter).EmailMsg :=

Line 504: hr_general_utilities.Find_Item_In_String

500: ( p_item => l_index + 6
501: , p_string => l_tmpString
502: );
503: g_errorTable(Counter).EmailMsg :=
504: hr_general_utilities.Find_Item_In_String
505: ( p_item => l_index + 7
506: , p_string => l_tmpString
507: );
508: