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.PER_IN_PERSON_LEG_HOOK dependencies on PAY_IN_UTILS

Line 6: p_token_name pay_in_utils.char_tab_type;

2: /* $Header: peinlhpe.pkb 120.11.12020000.2 2012/07/05 02:47:04 amnaraya ship $ */
3:
4: g_package CONSTANT VARCHAR2(100) := 'per_in_person_leg_hook.';
5: g_debug BOOLEAN;
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8:
9:
10: --------------------------------------------------------------------------

Line 7: p_token_value pay_in_utils.char_tab_type;

3:
4: g_package CONSTANT VARCHAR2(100) := 'per_in_person_leg_hook.';
5: g_debug BOOLEAN;
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8:
9:
10: --------------------------------------------------------------------------
11: -- --

Line 283: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

279: BEGIN
280:
281: l_procedure := g_package||'chk_person_type';
282: g_debug := hr_utility.debug_enabled;
283: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
284:
285: IF g_debug THEN
286: pay_in_utils.trace('p_code',p_code);
287: END IF;

Line 286: pay_in_utils.trace('p_code',p_code);

282: g_debug := hr_utility.debug_enabled;
283: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
284:
285: IF g_debug THEN
286: pay_in_utils.trace('p_code',p_code);
287: END IF;
288:
289: -- Change here in case any new PTs to be included
290:

Line 305: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

301:
302: FOR i IN 1..l_loop_count
303: LOOP
304: IF l_person_type(i) = p_code then
305: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
306: RETURN TRUE;
307: END IF;
308: END LOOP;
309: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 309: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

305: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
306: RETURN TRUE;
307: END IF;
308: END LOOP;
309: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
310: RETURN FALSE;
311:
312: END chk_person_type;
313:

Line 355: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

351: ,p_person_id IN NUMBER
352: ,p_field IN VARCHAR2
353: ,p_value IN VARCHAR2
354: ,p_message_name OUT NOCOPY VARCHAR2
355: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
356: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
357: )
358: IS
359:

Line 356: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

352: ,p_field IN VARCHAR2
353: ,p_value IN VARCHAR2
354: ,p_message_name OUT NOCOPY VARCHAR2
355: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
356: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
357: )
358: IS
359:
360: CURSOR csr_check

Line 381: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

377:
378:
379: l_procedure := g_package||'check_unique_number';
380: g_debug := hr_utility.debug_enabled;
381: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
382:
383: IF g_debug THEN
384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);

Line 384: pay_in_utils.trace('******************************','');

380: g_debug := hr_utility.debug_enabled;
381: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
382:
383: IF g_debug THEN
384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );

Line 385: pay_in_utils.trace('p_business_group_id',p_business_group_id);

381: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
382:
383: IF g_debug THEN
384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );

Line 386: pay_in_utils.trace('p_person_id ',p_person_id );

382:
383: IF g_debug THEN
384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );
390: pay_in_utils.trace('**************************************************','********************');

Line 387: pay_in_utils.trace('p_field ',p_field );

383: IF g_debug THEN
384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;

Line 388: pay_in_utils.trace('p_value ',p_value );

384: pay_in_utils.trace('**************************************************','********************');
385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:

Line 389: pay_in_utils.trace('p_message_name ',p_message_name );

385: pay_in_utils.trace('p_business_group_id',p_business_group_id);
386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:
393: p_message_name := 'SUCCESS';

Line 390: pay_in_utils.trace('******************************','');

386: pay_in_utils.trace('p_person_id ',p_person_id );
387: pay_in_utils.trace('p_field ',p_field );
388: pay_in_utils.trace('p_value ',p_value );
389: pay_in_utils.trace('p_message_name ',p_message_name );
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:
393: p_message_name := 'SUCCESS';
394:

Line 395: pay_in_utils.trace('l_qry ',l_qry);

391: END IF;
392:
393: p_message_name := 'SUCCESS';
394:
395: pay_in_utils.trace('l_qry ',l_qry);
396: OPEN csr_check;
397: FETCH csr_check INTO l_check;
398: CLOSE csr_check;
399:

Line 401: pay_in_utils.trace('******************************','');

397: FETCH csr_check INTO l_check;
398: CLOSE csr_check;
399:
400: IF g_debug THEN
401: pay_in_utils.trace('**************************************************','********************');
402: pay_in_utils.trace('l_check ',l_check);
403: pay_in_utils.trace('**************************************************','********************');
404: END IF;
405:

Line 402: pay_in_utils.trace('l_check ',l_check);

398: CLOSE csr_check;
399:
400: IF g_debug THEN
401: pay_in_utils.trace('**************************************************','********************');
402: pay_in_utils.trace('l_check ',l_check);
403: pay_in_utils.trace('**************************************************','********************');
404: END IF;
405:
406: IF l_check = 'Y' THEN

Line 403: pay_in_utils.trace('******************************','');

399:
400: IF g_debug THEN
401: pay_in_utils.trace('**************************************************','********************');
402: pay_in_utils.trace('l_check ',l_check);
403: pay_in_utils.trace('**************************************************','********************');
404: END IF;
405:
406: IF l_check = 'Y' THEN
407:

Line 420: pay_in_utils.trace('******************************','');

416: ,'PAN Reference Number','per_information14'
417: ,'NSSN','per_information15') inf_column
418: into l_inf_column from dual;
419: IF g_debug THEN
420: pay_in_utils.trace('**************************************************','********************');
421: pay_in_utils.trace('l_inf_column ',l_inf_column);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:

Line 421: pay_in_utils.trace('l_inf_column ',l_inf_column);

417: ,'NSSN','per_information15') inf_column
418: into l_inf_column from dual;
419: IF g_debug THEN
420: pay_in_utils.trace('**************************************************','********************');
421: pay_in_utils.trace('l_inf_column ',l_inf_column);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:
425: l_qry:=' SELECT count(1) from dual where exists(SELECT 1 FROM per_people_f '||

Line 422: pay_in_utils.trace('******************************','');

418: into l_inf_column from dual;
419: IF g_debug THEN
420: pay_in_utils.trace('**************************************************','********************');
421: pay_in_utils.trace('l_inf_column ',l_inf_column);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:
425: l_qry:=' SELECT count(1) from dual where exists(SELECT 1 FROM per_people_f '||
426: ' WHERE business_group_id = '||p_business_group_id||

Line 436: pay_in_utils.trace('******************************','');

432: EXECUTE IMMEDIATE l_qry
433: INTO l_count;
434:
435: IF g_debug THEN
436: pay_in_utils.trace('**************************************************','********************');
437: pay_in_utils.trace('l_qry ',l_qry);
438: pay_in_utils.trace('l_count ',l_count);
439: pay_in_utils.trace('**************************************************','********************');
440: END IF;

Line 437: pay_in_utils.trace('l_qry ',l_qry);

433: INTO l_count;
434:
435: IF g_debug THEN
436: pay_in_utils.trace('**************************************************','********************');
437: pay_in_utils.trace('l_qry ',l_qry);
438: pay_in_utils.trace('l_count ',l_count);
439: pay_in_utils.trace('**************************************************','********************');
440: END IF;
441:

Line 438: pay_in_utils.trace('l_count ',l_count);

434:
435: IF g_debug THEN
436: pay_in_utils.trace('**************************************************','********************');
437: pay_in_utils.trace('l_qry ',l_qry);
438: pay_in_utils.trace('l_count ',l_count);
439: pay_in_utils.trace('**************************************************','********************');
440: END IF;
441:
442:

Line 439: pay_in_utils.trace('******************************','');

435: IF g_debug THEN
436: pay_in_utils.trace('**************************************************','********************');
437: pay_in_utils.trace('l_qry ',l_qry);
438: pay_in_utils.trace('l_count ',l_count);
439: pay_in_utils.trace('**************************************************','********************');
440: END IF;
441:
442:
443: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 443: pay_in_utils.set_location(g_debug,l_procedure,20);

439: pay_in_utils.trace('**************************************************','********************');
440: END IF;
441:
442:
443: pay_in_utils.set_location(g_debug,l_procedure,20);
444:
445: IF l_count <> 0 THEN
446: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
447: p_token_name(1) := 'NUMBER_CATEGORY';

Line 451: pay_in_utils.trace('******************************','');

447: p_token_name(1) := 'NUMBER_CATEGORY';
448: p_token_value(1) := p_field;
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_message_name ',p_message_name);
453: pay_in_utils.trace('**************************************************','********************');
454: END IF;
455:

Line 452: pay_in_utils.trace('p_message_name ',p_message_name);

448: p_token_value(1) := p_field;
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_message_name ',p_message_name);
453: pay_in_utils.trace('**************************************************','********************');
454: END IF;
455:
456: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

Line 453: pay_in_utils.trace('******************************','');

449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_message_name ',p_message_name);
453: pay_in_utils.trace('**************************************************','********************');
454: END IF;
455:
456: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
457: RETURN;

Line 456: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

452: pay_in_utils.trace('p_message_name ',p_message_name);
453: pay_in_utils.trace('**************************************************','********************');
454: END IF;
455:
456: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
457: RETURN;
458: END IF;
459:
460: END IF ;

Line 463: pay_in_utils.trace('******************************','');

459:
460: END IF ;
461:
462: IF g_debug THEN
463: pay_in_utils.trace('**************************************************','********************');
464: pay_in_utils.trace('p_message_name ',p_message_name);
465: pay_in_utils.trace('**************************************************','********************');
466: END IF;
467:

Line 464: pay_in_utils.trace('p_message_name ',p_message_name);

460: END IF ;
461:
462: IF g_debug THEN
463: pay_in_utils.trace('**************************************************','********************');
464: pay_in_utils.trace('p_message_name ',p_message_name);
465: pay_in_utils.trace('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);

Line 465: pay_in_utils.trace('******************************','');

461:
462: IF g_debug THEN
463: pay_in_utils.trace('**************************************************','********************');
464: pay_in_utils.trace('p_message_name ',p_message_name);
465: pay_in_utils.trace('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
469:

Line 468: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);

464: pay_in_utils.trace('p_message_name ',p_message_name);
465: pay_in_utils.trace('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
469:
470: END check_unique_number;
471:
472:

Line 507: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

503: PROCEDURE check_pan_format( p_pan IN VARCHAR2
504: ,p_pan_af IN VARCHAR2
505: ,p_panref_number IN VARCHAR2
506: ,p_message_name OUT NOCOPY VARCHAR2
507: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
508: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
509: )
510: IS
511:

Line 508: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

504: ,p_pan_af IN VARCHAR2
505: ,p_panref_number IN VARCHAR2
506: ,p_message_name OUT NOCOPY VARCHAR2
507: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
508: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
509: )
510: IS
511:
512: l_num_string NUMBER ;

Line 523: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

519:
520: BEGIN
521: l_procedure := g_package||'check_pan_format';
522: g_debug := hr_utility.debug_enabled;
523: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
524:
525: IF g_debug THEN
526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );

Line 526: pay_in_utils.trace('******************************','');

522: g_debug := hr_utility.debug_enabled;
523: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
524:
525: IF g_debug THEN
526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );

Line 527: pay_in_utils.trace('p_pan ',p_pan );

523: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
524:
525: IF g_debug THEN
526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );
531: pay_in_utils.trace('**************************************************','********************');

Line 528: pay_in_utils.trace('p_pan_af ',p_pan_af );

524:
525: IF g_debug THEN
526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );
531: pay_in_utils.trace('**************************************************','********************');
532: END IF;

Line 529: pay_in_utils.trace('p_panref_number',p_panref_number);

525: IF g_debug THEN
526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );
531: pay_in_utils.trace('**************************************************','********************');
532: END IF;
533:

Line 530: pay_in_utils.trace('p_message_name ',p_message_name );

526: pay_in_utils.trace('**************************************************','********************');
527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );
531: pay_in_utils.trace('**************************************************','********************');
532: END IF;
533:
534: -- PAN format - XXXXX9999X

Line 531: pay_in_utils.trace('******************************','');

527: pay_in_utils.trace('p_pan ',p_pan );
528: pay_in_utils.trace('p_pan_af ',p_pan_af );
529: pay_in_utils.trace('p_panref_number',p_panref_number);
530: pay_in_utils.trace('p_message_name ',p_message_name );
531: pay_in_utils.trace('**************************************************','********************');
532: END IF;
533:
534: -- PAN format - XXXXX9999X
535: -- Check for the length

Line 542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

538: p_token_name(1) := 'FIELD';
539: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
540: p_token_name(2) := 'FORMAT';
541: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
543:
544: IF g_debug THEN
545: pay_in_utils.trace('**************************************************','********************');
546: pay_in_utils.trace('p_message_name ',p_message_name);

Line 545: pay_in_utils.trace('******************************','');

541: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
543:
544: IF g_debug THEN
545: pay_in_utils.trace('**************************************************','********************');
546: pay_in_utils.trace('p_message_name ',p_message_name);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:

Line 546: pay_in_utils.trace('p_message_name ',p_message_name);

542: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
543:
544: IF g_debug THEN
545: pay_in_utils.trace('**************************************************','********************');
546: pay_in_utils.trace('p_message_name ',p_message_name);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:
550: RETURN;

Line 547: pay_in_utils.trace('******************************','');

543:
544: IF g_debug THEN
545: pay_in_utils.trace('**************************************************','********************');
546: pay_in_utils.trace('p_message_name ',p_message_name);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:
550: RETURN;
551: END IF;

Line 570: pay_in_utils.trace('******************************','');

566: p_token_name(2) := 'FORMAT';
567: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
568:
569: IF g_debug THEN
570: pay_in_utils.trace('**************************************************','********************');
571: pay_in_utils.trace('p_message_name ',p_message_name);
572: pay_in_utils.trace('**************************************************','********************');
573: END IF;
574:

Line 571: pay_in_utils.trace('p_message_name ',p_message_name);

567: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
568:
569: IF g_debug THEN
570: pay_in_utils.trace('**************************************************','********************');
571: pay_in_utils.trace('p_message_name ',p_message_name);
572: pay_in_utils.trace('**************************************************','********************');
573: END IF;
574:
575: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 572: pay_in_utils.trace('******************************','');

568:
569: IF g_debug THEN
570: pay_in_utils.trace('**************************************************','********************');
571: pay_in_utils.trace('p_message_name ',p_message_name);
572: pay_in_utils.trace('**************************************************','********************');
573: END IF;
574:
575: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
576: RETURN;

Line 575: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

571: pay_in_utils.trace('p_message_name ',p_message_name);
572: pay_in_utils.trace('**************************************************','********************');
573: END IF;
574:
575: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
576: RETURN;
577: END IF ;
578: END LOOP ;
579:

Line 589: pay_in_utils.trace('******************************','');

585: p_token_name(2) := 'FORMAT';
586: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
587:
588: IF g_debug THEN
589: pay_in_utils.trace('**************************************************','********************');
590: pay_in_utils.trace('p_message_name ',p_message_name);
591: pay_in_utils.trace('**************************************************','********************');
592: END IF;
593:

Line 590: pay_in_utils.trace('p_message_name ',p_message_name);

586: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
587:
588: IF g_debug THEN
589: pay_in_utils.trace('**************************************************','********************');
590: pay_in_utils.trace('p_message_name ',p_message_name);
591: pay_in_utils.trace('**************************************************','********************');
592: END IF;
593:
594: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 591: pay_in_utils.trace('******************************','');

587:
588: IF g_debug THEN
589: pay_in_utils.trace('**************************************************','********************');
590: pay_in_utils.trace('p_message_name ',p_message_name);
591: pay_in_utils.trace('**************************************************','********************');
592: END IF;
593:
594: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
595: RETURN;

Line 594: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

590: pay_in_utils.trace('p_message_name ',p_message_name);
591: pay_in_utils.trace('**************************************************','********************');
592: END IF;
593:
594: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
595: RETURN;
596: END;
597: --
598: --

Line 609: pay_in_utils.trace('******************************','');

605: p_token_name(2) := 'FORMAT';
606: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
607:
608: IF g_debug THEN
609: pay_in_utils.trace('**************************************************','********************');
610: pay_in_utils.trace('p_message_name ',p_message_name);
611: pay_in_utils.trace('**************************************************','********************');
612: END IF;
613:

Line 610: pay_in_utils.trace('p_message_name ',p_message_name);

606: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
607:
608: IF g_debug THEN
609: pay_in_utils.trace('**************************************************','********************');
610: pay_in_utils.trace('p_message_name ',p_message_name);
611: pay_in_utils.trace('**************************************************','********************');
612: END IF;
613:
614: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 611: pay_in_utils.trace('******************************','');

607:
608: IF g_debug THEN
609: pay_in_utils.trace('**************************************************','********************');
610: pay_in_utils.trace('p_message_name ',p_message_name);
611: pay_in_utils.trace('**************************************************','********************');
612: END IF;
613:
614: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
615: RETURN;

Line 614: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

610: pay_in_utils.trace('p_message_name ',p_message_name);
611: pay_in_utils.trace('**************************************************','********************');
612: END IF;
613:
614: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
615: RETURN;
616: END IF ;
617: --
618: --

Line 630: pay_in_utils.trace('******************************','');

626: p_token_name(2) := 'FORMAT';
627: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
628:
629: IF g_debug THEN
630: pay_in_utils.trace('**************************************************','********************');
631: pay_in_utils.trace('p_message_name ',p_message_name);
632: pay_in_utils.trace('**************************************************','********************');
633: END IF;
634:

Line 631: pay_in_utils.trace('p_message_name ',p_message_name);

627: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
628:
629: IF g_debug THEN
630: pay_in_utils.trace('**************************************************','********************');
631: pay_in_utils.trace('p_message_name ',p_message_name);
632: pay_in_utils.trace('**************************************************','********************');
633: END IF;
634:
635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 632: pay_in_utils.trace('******************************','');

628:
629: IF g_debug THEN
630: pay_in_utils.trace('**************************************************','********************');
631: pay_in_utils.trace('p_message_name ',p_message_name);
632: pay_in_utils.trace('**************************************************','********************');
633: END IF;
634:
635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
636: RETURN;

Line 635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

631: pay_in_utils.trace('p_message_name ',p_message_name);
632: pay_in_utils.trace('**************************************************','********************');
633: END IF;
634:
635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
636: RETURN;
637: END IF ;
638: END LOOP ;
639:

Line 649: pay_in_utils.trace('******************************','');

645: p_token_name(2) := 'FIELD2';
646: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
647:
648: IF g_debug THEN
649: pay_in_utils.trace('**************************************************','********************');
650: pay_in_utils.trace('p_message_name ',p_message_name);
651: pay_in_utils.trace('**************************************************','********************');
652: END IF;
653:

Line 650: pay_in_utils.trace('p_message_name ',p_message_name);

646: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
647:
648: IF g_debug THEN
649: pay_in_utils.trace('**************************************************','********************');
650: pay_in_utils.trace('p_message_name ',p_message_name);
651: pay_in_utils.trace('**************************************************','********************');
652: END IF;
653:
654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 651: pay_in_utils.trace('******************************','');

647:
648: IF g_debug THEN
649: pay_in_utils.trace('**************************************************','********************');
650: pay_in_utils.trace('p_message_name ',p_message_name);
651: pay_in_utils.trace('**************************************************','********************');
652: END IF;
653:
654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
655: RETURN;

Line 654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

650: pay_in_utils.trace('p_message_name ',p_message_name);
651: pay_in_utils.trace('**************************************************','********************');
652: END IF;
653:
654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
655: RETURN;
656: END IF;
657:
658: --Checks that either the PAN field or the PAN Ref Number For field is null.

Line 667: pay_in_utils.trace('******************************','');

663: p_token_name(2) := 'FIELD2';
664: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
665:
666: IF g_debug THEN
667: pay_in_utils.trace('**************************************************','********************');
668: pay_in_utils.trace('p_message_name ',p_message_name);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:

Line 668: pay_in_utils.trace('p_message_name ',p_message_name);

664: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
665:
666: IF g_debug THEN
667: pay_in_utils.trace('**************************************************','********************');
668: pay_in_utils.trace('p_message_name ',p_message_name);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 669: pay_in_utils.trace('******************************','');

665:
666: IF g_debug THEN
667: pay_in_utils.trace('**************************************************','********************');
668: pay_in_utils.trace('p_message_name ',p_message_name);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
673: RETURN;

Line 672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

668: pay_in_utils.trace('p_message_name ',p_message_name);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
673: RETURN;
674: END IF;
675: p_message_name:='SUCCESS';
676:

Line 678: pay_in_utils.trace('******************************','');

674: END IF;
675: p_message_name:='SUCCESS';
676:
677: IF g_debug THEN
678: pay_in_utils.trace('**************************************************','********************');
679: pay_in_utils.trace('p_message_name ',p_message_name);
680: pay_in_utils.trace('**************************************************','********************');
681: END IF;
682:

Line 679: pay_in_utils.trace('p_message_name ',p_message_name);

675: p_message_name:='SUCCESS';
676:
677: IF g_debug THEN
678: pay_in_utils.trace('**************************************************','********************');
679: pay_in_utils.trace('p_message_name ',p_message_name);
680: pay_in_utils.trace('**************************************************','********************');
681: END IF;
682:
683: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 680: pay_in_utils.trace('******************************','');

676:
677: IF g_debug THEN
678: pay_in_utils.trace('**************************************************','********************');
679: pay_in_utils.trace('p_message_name ',p_message_name);
680: pay_in_utils.trace('**************************************************','********************');
681: END IF;
682:
683: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
684:

Line 683: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

679: pay_in_utils.trace('p_message_name ',p_message_name);
680: pay_in_utils.trace('**************************************************','********************');
681: END IF;
682:
683: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
684:
685:
686: END check_pan_format;
687:

Line 749: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

745: ,p_pension_number IN VARCHAR2
746: ,p_panref_number IN VARCHAR2
747: ,p_NSSN IN VARCHAR2
748: ,p_message_name OUT NOCOPY VARCHAR2
749: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
750: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
751: )
752: IS
753:

Line 750: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

746: ,p_panref_number IN VARCHAR2
747: ,p_NSSN IN VARCHAR2
748: ,p_message_name OUT NOCOPY VARCHAR2
749: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
750: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
751: )
752: IS
753:
754: CURSOR csr_pt

Line 787: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

783:
784:
785: l_procedure := g_package||'check_in_person_int';
786: g_debug := hr_utility.debug_enabled;
787: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
788:
789: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
790: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
791: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 791: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

787: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
788:
789: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
790: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
791: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
792: RETURN;
793: END IF;
794:
795: IF g_debug THEN

Line 796: pay_in_utils.trace('******************************','');

792: RETURN;
793: END IF;
794:
795: IF g_debug THEN
796: pay_in_utils.trace('**************************************************','********************');
797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );

Line 797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );

793: END IF;
794:
795: IF g_debug THEN
796: pay_in_utils.trace('**************************************************','********************');
797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );

Line 798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );

794:
795: IF g_debug THEN
796: pay_in_utils.trace('**************************************************','********************');
797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );

Line 799: pay_in_utils.trace('p_person_id ',p_person_id );

795: IF g_debug THEN
796: pay_in_utils.trace('**************************************************','********************');
797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );

Line 800: pay_in_utils.trace('p_effective_date ',p_effective_date );

796: pay_in_utils.trace('**************************************************','********************');
797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );

Line 801: pay_in_utils.trace('p_pan ',p_pan );

797: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );

Line 802: pay_in_utils.trace('p_pan_af ',p_pan_af );

798: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );

Line 803: pay_in_utils.trace('p_military_status ',p_military_status );

799: pay_in_utils.trace('p_person_id ',p_person_id );
800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );

Line 804: pay_in_utils.trace('p_resident_status ',p_resident_status );

800: pay_in_utils.trace('p_effective_date ',p_effective_date );
801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );

Line 805: pay_in_utils.trace('p_pf_number ',p_pf_number );

801: pay_in_utils.trace('p_pan ',p_pan );
802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );

Line 806: pay_in_utils.trace('p_esi_number ',p_esi_number );

802: pay_in_utils.trace('p_pan_af ',p_pan_af );
803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );

Line 807: pay_in_utils.trace('p_sa_number ',p_sa_number );

803: pay_in_utils.trace('p_military_status ',p_military_status );
804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );

Line 808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );

804: pay_in_utils.trace('p_resident_status ',p_resident_status );
805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );

Line 809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );

805: pay_in_utils.trace('p_pf_number ',p_pf_number );
806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );

Line 810: pay_in_utils.trace('p_pension_number ',p_pension_number );

806: pay_in_utils.trace('p_esi_number ',p_esi_number );
807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );
814: pay_in_utils.trace('**************************************************','********************');

Line 811: pay_in_utils.trace('p_panref_number ',p_panref_number );

807: pay_in_utils.trace('p_sa_number ',p_sa_number );
808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );
814: pay_in_utils.trace('**************************************************','********************');
815: END IF;

Line 812: pay_in_utils.trace('p_NSSN ',p_NSSN );

808: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );
814: pay_in_utils.trace('**************************************************','********************');
815: END IF;
816:

Line 813: pay_in_utils.trace('p_message_name ',p_message_name );

809: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );
814: pay_in_utils.trace('**************************************************','********************');
815: END IF;
816:
817: --

Line 814: pay_in_utils.trace('******************************','');

810: pay_in_utils.trace('p_pension_number ',p_pension_number );
811: pay_in_utils.trace('p_panref_number ',p_panref_number );
812: pay_in_utils.trace('p_NSSN ',p_NSSN );
813: pay_in_utils.trace('p_message_name ',p_message_name );
814: pay_in_utils.trace('**************************************************','********************');
815: END IF;
816:
817: --
818: -- Check for mandatory arguments

Line 835: pay_in_utils.trace('p_message_name ',p_message_name);

831: p_token_name(2) := 'FIELD';
832: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
833:
834: IF g_debug THEN
835: pay_in_utils.trace('p_message_name ',p_message_name);
836: END IF;
837:
838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
839: RETURN;

Line 838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

834: IF g_debug THEN
835: pay_in_utils.trace('p_message_name ',p_message_name);
836: END IF;
837:
838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
839: RETURN;
840: END IF ;
841: END IF ;
842: ELSE

Line 854: pay_in_utils.trace('******************************','');

850: p_token_name(2) := 'ARGUMENT';
851: p_token_value(2) := 'P_PERSON_TYPE_ID';
852:
853: IF g_debug THEN
854: pay_in_utils.trace('**************************************************','********************');
855: pay_in_utils.trace('p_message_name ',p_message_name);
856: pay_in_utils.trace('**************************************************','********************');
857: END IF;
858:

Line 855: pay_in_utils.trace('p_message_name ',p_message_name);

851: p_token_value(2) := 'P_PERSON_TYPE_ID';
852:
853: IF g_debug THEN
854: pay_in_utils.trace('**************************************************','********************');
855: pay_in_utils.trace('p_message_name ',p_message_name);
856: pay_in_utils.trace('**************************************************','********************');
857: END IF;
858:
859: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

Line 856: pay_in_utils.trace('******************************','');

852:
853: IF g_debug THEN
854: pay_in_utils.trace('**************************************************','********************');
855: pay_in_utils.trace('p_message_name ',p_message_name);
856: pay_in_utils.trace('**************************************************','********************');
857: END IF;
858:
859: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
860: RETURN ;

Line 859: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

855: pay_in_utils.trace('p_message_name ',p_message_name);
856: pay_in_utils.trace('**************************************************','********************');
857: END IF;
858:
859: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
860: RETURN ;
861: ELSE
862: OPEN csr_ptu ;
863: FETCH csr_ptu INTO l_person_type;

Line 873: pay_in_utils.trace('******************************','');

869: p_token_name(2) := 'FIELD';
870: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
871:
872: IF g_debug THEN
873: pay_in_utils.trace('**************************************************','********************');
874: pay_in_utils.trace('p_message_name ',p_message_name);
875: pay_in_utils.trace('**************************************************','********************');
876: END IF;
877:

Line 874: pay_in_utils.trace('p_message_name ',p_message_name);

870: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
871:
872: IF g_debug THEN
873: pay_in_utils.trace('**************************************************','********************');
874: pay_in_utils.trace('p_message_name ',p_message_name);
875: pay_in_utils.trace('**************************************************','********************');
876: END IF;
877:
878: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

Line 875: pay_in_utils.trace('******************************','');

871:
872: IF g_debug THEN
873: pay_in_utils.trace('**************************************************','********************');
874: pay_in_utils.trace('p_message_name ',p_message_name);
875: pay_in_utils.trace('**************************************************','********************');
876: END IF;
877:
878: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
879: RETURN ;

Line 878: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

874: pay_in_utils.trace('p_message_name ',p_message_name);
875: pay_in_utils.trace('**************************************************','********************');
876: END IF;
877:
878: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
879: RETURN ;
880: ELSE
881: CLOSE csr_ptu;
882: END IF;

Line 892: pay_in_utils.trace('******************************','');

888: IF NOT chk_person_type (l_person_type)
889:
890: THEN
891: IF g_debug THEN
892: pay_in_utils.trace('**************************************************','********************');
893: pay_in_utils.trace('p_message_name ',p_message_name);
894: pay_in_utils.trace('**************************************************','********************');
895: END IF;
896:

Line 893: pay_in_utils.trace('p_message_name ',p_message_name);

889:
890: THEN
891: IF g_debug THEN
892: pay_in_utils.trace('**************************************************','********************');
893: pay_in_utils.trace('p_message_name ',p_message_name);
894: pay_in_utils.trace('**************************************************','********************');
895: END IF;
896:
897: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);

Line 894: pay_in_utils.trace('******************************','');

890: THEN
891: IF g_debug THEN
892: pay_in_utils.trace('**************************************************','********************');
893: pay_in_utils.trace('p_message_name ',p_message_name);
894: pay_in_utils.trace('**************************************************','********************');
895: END IF;
896:
897: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
898: RETURN ;

Line 897: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);

893: pay_in_utils.trace('p_message_name ',p_message_name);
894: pay_in_utils.trace('**************************************************','********************');
895: END IF;
896:
897: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
898: RETURN ;
899: END IF;
900:
901: --

Line 914: pay_in_utils.trace('******************************','');

910: p_token_name(2) := 'ARGUMENT';
911: p_token_value(2) := 'P_RESIDENT_STATUS';
912:
913: IF g_debug THEN
914: pay_in_utils.trace('**************************************************','********************');
915: pay_in_utils.trace('p_message_name ',p_message_name);
916: pay_in_utils.trace('**************************************************','********************');
917: END IF;
918:

Line 915: pay_in_utils.trace('p_message_name ',p_message_name);

911: p_token_value(2) := 'P_RESIDENT_STATUS';
912:
913: IF g_debug THEN
914: pay_in_utils.trace('**************************************************','********************');
915: pay_in_utils.trace('p_message_name ',p_message_name);
916: pay_in_utils.trace('**************************************************','********************');
917: END IF;
918:
919: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 70);

Line 916: pay_in_utils.trace('******************************','');

912:
913: IF g_debug THEN
914: pay_in_utils.trace('**************************************************','********************');
915: pay_in_utils.trace('p_message_name ',p_message_name);
916: pay_in_utils.trace('**************************************************','********************');
917: END IF;
918:
919: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 70);
920: RETURN;

Line 919: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 70);

915: pay_in_utils.trace('p_message_name ',p_message_name);
916: pay_in_utils.trace('**************************************************','********************');
917: END IF;
918:
919: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 70);
920: RETURN;
921: END IF;
922:
923: --

Line 937: pay_in_utils.trace('******************************','');

933: p_token_name(2) := 'FIELD';
934: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
935:
936: IF g_debug THEN
937: pay_in_utils.trace('**************************************************','********************');
938: pay_in_utils.trace('p_message_name ',p_message_name);
939: pay_in_utils.trace('**************************************************','********************');
940: END IF;
941:

Line 938: pay_in_utils.trace('p_message_name ',p_message_name);

934: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
935:
936: IF g_debug THEN
937: pay_in_utils.trace('**************************************************','********************');
938: pay_in_utils.trace('p_message_name ',p_message_name);
939: pay_in_utils.trace('**************************************************','********************');
940: END IF;
941:
942: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 80);

Line 939: pay_in_utils.trace('******************************','');

935:
936: IF g_debug THEN
937: pay_in_utils.trace('**************************************************','********************');
938: pay_in_utils.trace('p_message_name ',p_message_name);
939: pay_in_utils.trace('**************************************************','********************');
940: END IF;
941:
942: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 80);
943: RETURN;

Line 942: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 80);

938: pay_in_utils.trace('p_message_name ',p_message_name);
939: pay_in_utils.trace('**************************************************','********************');
940: END IF;
941:
942: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 80);
943: RETURN;
944: END IF;
945: END IF;
946:

Line 960: pay_in_utils.trace('******************************','');

956: p_token_name(2) := 'FIELD';
957: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','EX_SERVICE');
958:
959: IF g_debug THEN
960: pay_in_utils.trace('**************************************************','********************');
961: pay_in_utils.trace('p_message_name ',p_message_name);
962: pay_in_utils.trace('**************************************************','********************');
963: END IF;
964:

Line 961: pay_in_utils.trace('p_message_name ',p_message_name);

957: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','EX_SERVICE');
958:
959: IF g_debug THEN
960: pay_in_utils.trace('**************************************************','********************');
961: pay_in_utils.trace('p_message_name ',p_message_name);
962: pay_in_utils.trace('**************************************************','********************');
963: END IF;
964:
965: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);

Line 962: pay_in_utils.trace('******************************','');

958:
959: IF g_debug THEN
960: pay_in_utils.trace('**************************************************','********************');
961: pay_in_utils.trace('p_message_name ',p_message_name);
962: pay_in_utils.trace('**************************************************','********************');
963: END IF;
964:
965: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);
966: RETURN;

Line 965: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);

961: pay_in_utils.trace('p_message_name ',p_message_name);
962: pay_in_utils.trace('**************************************************','********************');
963: END IF;
964:
965: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);
966: RETURN;
967: END IF;
968: END IF;
969:

Line 981: pay_in_utils.trace('******************************','');

977: p_token_name(2) := 'FIELD';
978: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RESIDENTIAL_STATUS');
979:
980: IF g_debug THEN
981: pay_in_utils.trace('**************************************************','********************');
982: pay_in_utils.trace('p_message_name ',p_message_name);
983: pay_in_utils.trace('**************************************************','********************');
984: END IF;
985:

Line 982: pay_in_utils.trace('p_message_name ',p_message_name);

978: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RESIDENTIAL_STATUS');
979:
980: IF g_debug THEN
981: pay_in_utils.trace('**************************************************','********************');
982: pay_in_utils.trace('p_message_name ',p_message_name);
983: pay_in_utils.trace('**************************************************','********************');
984: END IF;
985:
986: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);

Line 983: pay_in_utils.trace('******************************','');

979:
980: IF g_debug THEN
981: pay_in_utils.trace('**************************************************','********************');
982: pay_in_utils.trace('p_message_name ',p_message_name);
983: pay_in_utils.trace('**************************************************','********************');
984: END IF;
985:
986: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);
987: RETURN;

Line 986: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);

982: pay_in_utils.trace('p_message_name ',p_message_name);
983: pay_in_utils.trace('**************************************************','********************');
984: END IF;
985:
986: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);
987: RETURN;
988:
989: END IF ;
990:

Line 1005: pay_in_utils.trace('******************************','');

1001:
1002: IF p_message_name <> 'SUCCESS' then
1003:
1004: IF g_debug THEN
1005: pay_in_utils.trace('**************************************************','********************');
1006: pay_in_utils.trace('p_message_name ',p_message_name);
1007: pay_in_utils.trace('**************************************************','********************');
1008: END IF;
1009:

Line 1006: pay_in_utils.trace('p_message_name ',p_message_name);

1002: IF p_message_name <> 'SUCCESS' then
1003:
1004: IF g_debug THEN
1005: pay_in_utils.trace('**************************************************','********************');
1006: pay_in_utils.trace('p_message_name ',p_message_name);
1007: pay_in_utils.trace('**************************************************','********************');
1008: END IF;
1009:
1010: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 110);

Line 1007: pay_in_utils.trace('******************************','');

1003:
1004: IF g_debug THEN
1005: pay_in_utils.trace('**************************************************','********************');
1006: pay_in_utils.trace('p_message_name ',p_message_name);
1007: pay_in_utils.trace('**************************************************','********************');
1008: END IF;
1009:
1010: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 110);
1011: RETURN;

Line 1010: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 110);

1006: pay_in_utils.trace('p_message_name ',p_message_name);
1007: pay_in_utils.trace('**************************************************','********************');
1008: END IF;
1009:
1010: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 110);
1011: RETURN;
1012: END IF;
1013:
1014:

Line 1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);

1018: p_token_name(1) := 'FIELD';
1019: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1020: p_token_name(2) := 'FORMAT';
1021: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1023:
1024: IF g_debug THEN
1025: pay_in_utils.trace('**************************************************','********************');
1026: pay_in_utils.trace('p_message_name ',p_message_name);

Line 1025: pay_in_utils.trace('******************************','');

1021: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1023:
1024: IF g_debug THEN
1025: pay_in_utils.trace('**************************************************','********************');
1026: pay_in_utils.trace('p_message_name ',p_message_name);
1027: pay_in_utils.trace('**************************************************','********************');
1028: END IF;
1029:

Line 1026: pay_in_utils.trace('p_message_name ',p_message_name);

1022: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1023:
1024: IF g_debug THEN
1025: pay_in_utils.trace('**************************************************','********************');
1026: pay_in_utils.trace('p_message_name ',p_message_name);
1027: pay_in_utils.trace('**************************************************','********************');
1028: END IF;
1029:
1030: RETURN;

Line 1027: pay_in_utils.trace('******************************','');

1023:
1024: IF g_debug THEN
1025: pay_in_utils.trace('**************************************************','********************');
1026: pay_in_utils.trace('p_message_name ',p_message_name);
1027: pay_in_utils.trace('**************************************************','********************');
1028: END IF;
1029:
1030: RETURN;
1031: END IF;

Line 1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);

1034: p_token_name(1) := 'FIELD';
1035: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1036: p_token_name(2) := 'FORMAT';
1037: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_message_name ',p_message_name);

Line 1041: pay_in_utils.trace('******************************','');

1037: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_message_name ',p_message_name);
1043: pay_in_utils.trace('**************************************************','********************');
1044: END IF;
1045:

Line 1042: pay_in_utils.trace('p_message_name ',p_message_name);

1038: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_message_name ',p_message_name);
1043: pay_in_utils.trace('**************************************************','********************');
1044: END IF;
1045:
1046: RETURN;

Line 1043: pay_in_utils.trace('******************************','');

1039:
1040: IF g_debug THEN
1041: pay_in_utils.trace('**************************************************','********************');
1042: pay_in_utils.trace('p_message_name ',p_message_name);
1043: pay_in_utils.trace('**************************************************','********************');
1044: END IF;
1045:
1046: RETURN;
1047: END IF;

Line 1071: pay_in_utils.trace('******************************','');

1067:
1068: IF p_message_name <> 'SUCCESS' then
1069:
1070: IF g_debug THEN
1071: pay_in_utils.trace('**************************************************','********************');
1072: pay_in_utils.trace('p_message_name ',p_message_name);
1073: pay_in_utils.trace('**************************************************','********************');
1074: END IF;
1075:

Line 1072: pay_in_utils.trace('p_message_name ',p_message_name);

1068: IF p_message_name <> 'SUCCESS' then
1069:
1070: IF g_debug THEN
1071: pay_in_utils.trace('**************************************************','********************');
1072: pay_in_utils.trace('p_message_name ',p_message_name);
1073: pay_in_utils.trace('**************************************************','********************');
1074: END IF;
1075:
1076: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);

Line 1073: pay_in_utils.trace('******************************','');

1069:
1070: IF g_debug THEN
1071: pay_in_utils.trace('**************************************************','********************');
1072: pay_in_utils.trace('p_message_name ',p_message_name);
1073: pay_in_utils.trace('**************************************************','********************');
1074: END IF;
1075:
1076: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
1077: RETURN;

Line 1076: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);

1072: pay_in_utils.trace('p_message_name ',p_message_name);
1073: pay_in_utils.trace('**************************************************','********************');
1074: END IF;
1075:
1076: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
1077: RETURN;
1078: END IF;
1079:
1080: END IF;

Line 1097: pay_in_utils.trace('******************************','');

1093:
1094: IF p_message_name <> 'SUCCESS' then
1095:
1096: IF g_debug THEN
1097: pay_in_utils.trace('**************************************************','********************');
1098: pay_in_utils.trace('p_message_name ',p_message_name);
1099: pay_in_utils.trace('**************************************************','********************');
1100: END IF;
1101:

Line 1098: pay_in_utils.trace('p_message_name ',p_message_name);

1094: IF p_message_name <> 'SUCCESS' then
1095:
1096: IF g_debug THEN
1097: pay_in_utils.trace('**************************************************','********************');
1098: pay_in_utils.trace('p_message_name ',p_message_name);
1099: pay_in_utils.trace('**************************************************','********************');
1100: END IF;
1101:
1102: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);

Line 1099: pay_in_utils.trace('******************************','');

1095:
1096: IF g_debug THEN
1097: pay_in_utils.trace('**************************************************','********************');
1098: pay_in_utils.trace('p_message_name ',p_message_name);
1099: pay_in_utils.trace('**************************************************','********************');
1100: END IF;
1101:
1102: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1103: RETURN;

Line 1102: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);

1098: pay_in_utils.trace('p_message_name ',p_message_name);
1099: pay_in_utils.trace('**************************************************','********************');
1100: END IF;
1101:
1102: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1103: RETURN;
1104: END IF;
1105:
1106:

Line 1124: pay_in_utils.trace('******************************','');

1120:
1121: IF p_message_name <> 'SUCCESS' then
1122:
1123: IF g_debug THEN
1124: pay_in_utils.trace('**************************************************','********************');
1125: pay_in_utils.trace('p_message_name ',p_message_name);
1126: pay_in_utils.trace('**************************************************','********************');
1127: END IF;
1128:

Line 1125: pay_in_utils.trace('p_message_name ',p_message_name);

1121: IF p_message_name <> 'SUCCESS' then
1122:
1123: IF g_debug THEN
1124: pay_in_utils.trace('**************************************************','********************');
1125: pay_in_utils.trace('p_message_name ',p_message_name);
1126: pay_in_utils.trace('**************************************************','********************');
1127: END IF;
1128:
1129: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 140);

Line 1126: pay_in_utils.trace('******************************','');

1122:
1123: IF g_debug THEN
1124: pay_in_utils.trace('**************************************************','********************');
1125: pay_in_utils.trace('p_message_name ',p_message_name);
1126: pay_in_utils.trace('**************************************************','********************');
1127: END IF;
1128:
1129: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 140);
1130: RETURN;

Line 1129: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 140);

1125: pay_in_utils.trace('p_message_name ',p_message_name);
1126: pay_in_utils.trace('**************************************************','********************');
1127: END IF;
1128:
1129: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 140);
1130: RETURN;
1131: END IF;
1132:
1133: END IF;

Line 1151: pay_in_utils.trace('******************************','');

1147:
1148: IF p_message_name <> 'SUCCESS' then
1149:
1150: IF g_debug THEN
1151: pay_in_utils.trace('**************************************************','********************');
1152: pay_in_utils.trace('p_message_name ',p_message_name);
1153: pay_in_utils.trace('**************************************************','********************');
1154: END IF;
1155:

Line 1152: pay_in_utils.trace('p_message_name ',p_message_name);

1148: IF p_message_name <> 'SUCCESS' then
1149:
1150: IF g_debug THEN
1151: pay_in_utils.trace('**************************************************','********************');
1152: pay_in_utils.trace('p_message_name ',p_message_name);
1153: pay_in_utils.trace('**************************************************','********************');
1154: END IF;
1155:
1156: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);

Line 1153: pay_in_utils.trace('******************************','');

1149:
1150: IF g_debug THEN
1151: pay_in_utils.trace('**************************************************','********************');
1152: pay_in_utils.trace('p_message_name ',p_message_name);
1153: pay_in_utils.trace('**************************************************','********************');
1154: END IF;
1155:
1156: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
1157: RETURN;

Line 1156: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);

1152: pay_in_utils.trace('p_message_name ',p_message_name);
1153: pay_in_utils.trace('**************************************************','********************');
1154: END IF;
1155:
1156: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
1157: RETURN;
1158: END IF;
1159:
1160: END IF;

Line 1178: pay_in_utils.trace('******************************','');

1174:
1175: IF p_message_name <> 'SUCCESS' then
1176:
1177: IF g_debug THEN
1178: pay_in_utils.trace('**************************************************','********************');
1179: pay_in_utils.trace('p_message_name ',p_message_name);
1180: pay_in_utils.trace('**************************************************','********************');
1181: END IF;
1182:

Line 1179: pay_in_utils.trace('p_message_name ',p_message_name);

1175: IF p_message_name <> 'SUCCESS' then
1176:
1177: IF g_debug THEN
1178: pay_in_utils.trace('**************************************************','********************');
1179: pay_in_utils.trace('p_message_name ',p_message_name);
1180: pay_in_utils.trace('**************************************************','********************');
1181: END IF;
1182:
1183: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);

Line 1180: pay_in_utils.trace('******************************','');

1176:
1177: IF g_debug THEN
1178: pay_in_utils.trace('**************************************************','********************');
1179: pay_in_utils.trace('p_message_name ',p_message_name);
1180: pay_in_utils.trace('**************************************************','********************');
1181: END IF;
1182:
1183: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
1184: RETURN;

Line 1183: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);

1179: pay_in_utils.trace('p_message_name ',p_message_name);
1180: pay_in_utils.trace('**************************************************','********************');
1181: END IF;
1182:
1183: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
1184: RETURN;
1185: END IF;
1186:
1187: END IF;

Line 1205: pay_in_utils.trace('******************************','');

1201:
1202: IF p_message_name <> 'SUCCESS' then
1203:
1204: IF g_debug THEN
1205: pay_in_utils.trace('**************************************************','********************');
1206: pay_in_utils.trace('p_message_name ',p_message_name);
1207: pay_in_utils.trace('**************************************************','********************');
1208: END IF;
1209:

Line 1206: pay_in_utils.trace('p_message_name ',p_message_name);

1202: IF p_message_name <> 'SUCCESS' then
1203:
1204: IF g_debug THEN
1205: pay_in_utils.trace('**************************************************','********************');
1206: pay_in_utils.trace('p_message_name ',p_message_name);
1207: pay_in_utils.trace('**************************************************','********************');
1208: END IF;
1209:
1210: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);

Line 1207: pay_in_utils.trace('******************************','');

1203:
1204: IF g_debug THEN
1205: pay_in_utils.trace('**************************************************','********************');
1206: pay_in_utils.trace('p_message_name ',p_message_name);
1207: pay_in_utils.trace('**************************************************','********************');
1208: END IF;
1209:
1210: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);
1211: RETURN;

Line 1210: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);

1206: pay_in_utils.trace('p_message_name ',p_message_name);
1207: pay_in_utils.trace('**************************************************','********************');
1208: END IF;
1209:
1210: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);
1211: RETURN;
1212: END IF;
1213: END IF;
1214:

Line 1230: pay_in_utils.trace('******************************','');

1226:
1227: IF p_message_name <> 'SUCCESS' then
1228:
1229: IF g_debug THEN
1230: pay_in_utils.trace('**************************************************','********************');
1231: pay_in_utils.trace('p_message_name ',p_message_name);
1232: pay_in_utils.trace('**************************************************','********************');
1233: END IF;
1234:

Line 1231: pay_in_utils.trace('p_message_name ',p_message_name);

1227: IF p_message_name <> 'SUCCESS' then
1228:
1229: IF g_debug THEN
1230: pay_in_utils.trace('**************************************************','********************');
1231: pay_in_utils.trace('p_message_name ',p_message_name);
1232: pay_in_utils.trace('**************************************************','********************');
1233: END IF;
1234:
1235: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);

Line 1232: pay_in_utils.trace('******************************','');

1228:
1229: IF g_debug THEN
1230: pay_in_utils.trace('**************************************************','********************');
1231: pay_in_utils.trace('p_message_name ',p_message_name);
1232: pay_in_utils.trace('**************************************************','********************');
1233: END IF;
1234:
1235: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);
1236: RETURN;

Line 1235: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);

1231: pay_in_utils.trace('p_message_name ',p_message_name);
1232: pay_in_utils.trace('**************************************************','********************');
1233: END IF;
1234:
1235: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);
1236: RETURN;
1237: END IF;
1238: END IF;
1239:

Line 1255: pay_in_utils.trace('******************************','');

1251:
1252: IF p_message_name <> 'SUCCESS' then
1253:
1254: IF g_debug THEN
1255: pay_in_utils.trace('**************************************************','********************');
1256: pay_in_utils.trace('p_message_name ',p_message_name);
1257: pay_in_utils.trace('**************************************************','********************');
1258: END IF;
1259:

Line 1256: pay_in_utils.trace('p_message_name ',p_message_name);

1252: IF p_message_name <> 'SUCCESS' then
1253:
1254: IF g_debug THEN
1255: pay_in_utils.trace('**************************************************','********************');
1256: pay_in_utils.trace('p_message_name ',p_message_name);
1257: pay_in_utils.trace('**************************************************','********************');
1258: END IF;
1259:
1260: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);

Line 1257: pay_in_utils.trace('******************************','');

1253:
1254: IF g_debug THEN
1255: pay_in_utils.trace('**************************************************','********************');
1256: pay_in_utils.trace('p_message_name ',p_message_name);
1257: pay_in_utils.trace('**************************************************','********************');
1258: END IF;
1259:
1260: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);
1261: RETURN;

Line 1260: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);

1256: pay_in_utils.trace('p_message_name ',p_message_name);
1257: pay_in_utils.trace('**************************************************','********************');
1258: END IF;
1259:
1260: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);
1261: RETURN;
1262: END IF;
1263: END IF;
1264:

Line 1281: pay_in_utils.trace('******************************','');

1277:
1278: IF p_message_name <> 'SUCCESS' then
1279:
1280: IF g_debug THEN
1281: pay_in_utils.trace('**************************************************','********************');
1282: pay_in_utils.trace('p_message_name ',p_message_name);
1283: pay_in_utils.trace('**************************************************','********************');
1284: END IF;
1285:

Line 1282: pay_in_utils.trace('p_message_name ',p_message_name);

1278: IF p_message_name <> 'SUCCESS' then
1279:
1280: IF g_debug THEN
1281: pay_in_utils.trace('**************************************************','********************');
1282: pay_in_utils.trace('p_message_name ',p_message_name);
1283: pay_in_utils.trace('**************************************************','********************');
1284: END IF;
1285:
1286: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);

Line 1283: pay_in_utils.trace('******************************','');

1279:
1280: IF g_debug THEN
1281: pay_in_utils.trace('**************************************************','********************');
1282: pay_in_utils.trace('p_message_name ',p_message_name);
1283: pay_in_utils.trace('**************************************************','********************');
1284: END IF;
1285:
1286: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1287: RETURN;

Line 1286: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);

1282: pay_in_utils.trace('p_message_name ',p_message_name);
1283: pay_in_utils.trace('**************************************************','********************');
1284: END IF;
1285:
1286: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1287: RETURN;
1288: END IF;
1289: END IF;
1290:

Line 1292: pay_in_utils.trace('p_message_name ',p_message_name);

1288: END IF;
1289: END IF;
1290:
1291: IF g_debug THEN
1292: pay_in_utils.trace('p_message_name ',p_message_name);
1293: END IF;
1294:
1295: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 200);
1296:

Line 1295: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 200);

1291: IF g_debug THEN
1292: pay_in_utils.trace('p_message_name ',p_message_name);
1293: END IF;
1294:
1295: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 200);
1296:
1297:
1298: END check_in_person_int;
1299:

Line 1374: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

1370: BEGIN
1371:
1372: l_procedure := g_package||'check_in_person_insert';
1373: g_debug := hr_utility.debug_enabled;
1374: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1375:
1376: IF g_debug THEN
1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);

Line 1377: pay_in_utils.trace('******************************','');

1373: g_debug := hr_utility.debug_enabled;
1374: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1375:
1376: IF g_debug THEN
1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );

Line 1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);

1374: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1375:
1376: IF g_debug THEN
1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

Line 1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );

1375:
1376: IF g_debug THEN
1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

Line 1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );

1376: IF g_debug THEN
1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

Line 1381: pay_in_utils.trace('p_hire_date ',p_hire_date );

1377: pay_in_utils.trace('**************************************************','********************');
1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

Line 1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

1378: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

Line 1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

1379: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

Line 1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

1380: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

Line 1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

1381: pay_in_utils.trace('p_hire_date ',p_hire_date );
1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

Line 1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

1382: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

Line 1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

1383: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

Line 1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

1384: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

Line 1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

1385: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

Line 1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

1386: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1394: pay_in_utils.trace('**************************************************','********************');

Line 1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

1387: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1394: pay_in_utils.trace('**************************************************','********************');
1395: END IF;

Line 1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

1388: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1394: pay_in_utils.trace('**************************************************','********************');
1395: END IF;
1396:

Line 1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

1389: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1394: pay_in_utils.trace('**************************************************','********************');
1395: END IF;
1396:
1397: p_message_name := 'SUCCESS';

Line 1394: pay_in_utils.trace('******************************','');

1390: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1391: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1392: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1393: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1394: pay_in_utils.trace('**************************************************','********************');
1395: END IF;
1396:
1397: p_message_name := 'SUCCESS';
1398: IF p_per_information_category <> 'IN' then

Line 1399: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

1395: END IF;
1396:
1397: p_message_name := 'SUCCESS';
1398: IF p_per_information_category <> 'IN' then
1399: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1400: RETURN;
1401: END IF;
1402:
1403: check_in_person_int

Line 1425: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);

1421: ,p_token_name => p_token_name
1422: ,p_token_value => p_token_value
1423: );
1424:
1425: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1426: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1427: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1428: ELSE
1429: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

Line 1427: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);

1423: );
1424:
1425: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1426: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1427: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1428: ELSE
1429: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1430: END IF;
1431:

Line 1429: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

1425: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1426: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1427: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1428: ELSE
1429: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1430: END IF;
1431:
1432: END check_in_person_insert;
1433:

Line 1537: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

1533: BEGIN
1534:
1535: l_procedure := g_package||'check_in_person_update';
1536: g_debug := hr_utility.debug_enabled;
1537: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1538:
1539: IF g_debug THEN
1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);

Line 1540: pay_in_utils.trace('******************************','');

1536: g_debug := hr_utility.debug_enabled;
1537: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1538:
1539: IF g_debug THEN
1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );

Line 1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);

1537: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1538:
1539: IF g_debug THEN
1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

Line 1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );

1538:
1539: IF g_debug THEN
1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

Line 1543: pay_in_utils.trace('p_person_id ',p_person_id );

1539: IF g_debug THEN
1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

Line 1544: pay_in_utils.trace('p_effective_date ',p_effective_date );

1540: pay_in_utils.trace('**************************************************','********************');
1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

Line 1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

1541: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

Line 1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

1542: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

Line 1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

1543: pay_in_utils.trace('p_person_id ',p_person_id );
1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

Line 1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

1544: pay_in_utils.trace('p_effective_date ',p_effective_date );
1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

Line 1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

1545: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

Line 1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

1546: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

Line 1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

1547: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

Line 1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

1548: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

Line 1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

1549: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1557: pay_in_utils.trace('**************************************************','********************');

Line 1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

1550: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1557: pay_in_utils.trace('**************************************************','********************');
1558: END IF;

Line 1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

1551: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1557: pay_in_utils.trace('**************************************************','********************');
1558: END IF;
1559:

Line 1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

1552: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1557: pay_in_utils.trace('**************************************************','********************');
1558: END IF;
1559:
1560: p_message_name := 'SUCCESS';

Line 1557: pay_in_utils.trace('******************************','');

1553: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1554: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1555: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1556: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1557: pay_in_utils.trace('**************************************************','********************');
1558: END IF;
1559:
1560: p_message_name := 'SUCCESS';
1561:

Line 1563: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

1559:
1560: p_message_name := 'SUCCESS';
1561:
1562: IF p_per_information_category <> 'IN' then
1563: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1564: RETURN;
1565: END IF;
1566:
1567: OPEN csr_person;

Line 1654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);

1650: ,p_token_name => p_token_name
1651: ,p_token_value => p_token_value
1652: );
1653:
1654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1655: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1656: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1657: ELSE
1658: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

Line 1656: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);

1652: );
1653:
1654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1655: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1656: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1657: ELSE
1658: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1659: END IF;
1660:

Line 1658: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

1654: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1655: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1656: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1657: ELSE
1658: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1659: END IF;
1660:
1661: END check_in_person_update;
1662: