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.10 2007/11/19 12:17:47 rsaharay noship $ */
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 354: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

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

Line 355: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

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

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

387: BEGIN
388:
389: l_procedure := g_package||'check_unique_number';
390: g_debug := hr_utility.debug_enabled;
391: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
392:
393: IF g_debug THEN
394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);

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

390: g_debug := hr_utility.debug_enabled;
391: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
392:
393: IF g_debug THEN
394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );

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

391: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
392:
393: IF g_debug THEN
394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );

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

392:
393: IF g_debug THEN
394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );
400: pay_in_utils.trace('**************************************************','********************');

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

393: IF g_debug THEN
394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );
400: pay_in_utils.trace('**************************************************','********************');
401: END IF;

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

394: pay_in_utils.trace('**************************************************','********************');
395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );
400: pay_in_utils.trace('**************************************************','********************');
401: END IF;
402:

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

395: pay_in_utils.trace('p_business_group_id',p_business_group_id);
396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );
400: pay_in_utils.trace('**************************************************','********************');
401: END IF;
402:
403: p_message_name := 'SUCCESS';

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

396: pay_in_utils.trace('p_person_id ',p_person_id );
397: pay_in_utils.trace('p_field ',p_field );
398: pay_in_utils.trace('p_value ',p_value );
399: pay_in_utils.trace('p_message_name ',p_message_name );
400: pay_in_utils.trace('**************************************************','********************');
401: END IF;
402:
403: p_message_name := 'SUCCESS';
404:

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

406: FETCH csr_check INTO l_check;
407: CLOSE csr_check;
408:
409: IF g_debug THEN
410: pay_in_utils.trace('**************************************************','********************');
411: pay_in_utils.trace('l_check ',l_check);
412: pay_in_utils.trace('**************************************************','********************');
413: END IF;
414:

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

407: CLOSE csr_check;
408:
409: IF g_debug THEN
410: pay_in_utils.trace('**************************************************','********************');
411: pay_in_utils.trace('l_check ',l_check);
412: pay_in_utils.trace('**************************************************','********************');
413: END IF;
414:
415: IF l_check = 'Y' THEN

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

408:
409: IF g_debug THEN
410: pay_in_utils.trace('**************************************************','********************');
411: pay_in_utils.trace('l_check ',l_check);
412: pay_in_utils.trace('**************************************************','********************');
413: END IF;
414:
415: IF l_check = 'Y' THEN
416:

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

417: OPEN csr_number;
418: FETCH csr_number
419: INTO l_count;
420: CLOSE csr_number;
421: pay_in_utils.set_location(g_debug,l_procedure,20);
422:
423: IF l_count <> 0 THEN
424: p_message_name := 'PER_IN_NON_UNIQUE_VALUE';
425: p_token_name(1) := 'NUMBER_CATEGORY';

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

425: p_token_name(1) := 'NUMBER_CATEGORY';
426: p_token_value(1) := p_field;
427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('p_message_name ',p_message_name);
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:

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

426: p_token_value(1) := p_field;
427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('p_message_name ',p_message_name);
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
434: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

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

427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('p_message_name ',p_message_name);
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
434: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
435: RETURN;

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

430: pay_in_utils.trace('p_message_name ',p_message_name);
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
434: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
435: RETURN;
436: END IF;
437:
438: END IF ;

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

437:
438: END IF ;
439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('p_message_name ',p_message_name);
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:

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

438: END IF ;
439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('p_message_name ',p_message_name);
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);

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

439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('p_message_name ',p_message_name);
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
447:

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

442: pay_in_utils.trace('p_message_name ',p_message_name);
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
447:
448: END check_unique_number;
449:
450:

Line 485: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

481: PROCEDURE check_pan_format( p_pan IN VARCHAR2
482: ,p_pan_af IN VARCHAR2
483: ,p_panref_number IN VARCHAR2
484: ,p_message_name OUT NOCOPY VARCHAR2
485: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
486: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
487: )
488: IS
489:

Line 486: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

482: ,p_pan_af IN VARCHAR2
483: ,p_panref_number IN VARCHAR2
484: ,p_message_name OUT NOCOPY VARCHAR2
485: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
486: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
487: )
488: IS
489:
490: l_num_string NUMBER ;

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

497:
498: BEGIN
499: l_procedure := g_package||'check_pan_format';
500: g_debug := hr_utility.debug_enabled;
501: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
502:
503: IF g_debug THEN
504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );

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

500: g_debug := hr_utility.debug_enabled;
501: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
502:
503: IF g_debug THEN
504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );

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

501: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
502:
503: IF g_debug THEN
504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );
509: pay_in_utils.trace('**************************************************','********************');

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

502:
503: IF g_debug THEN
504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );
509: pay_in_utils.trace('**************************************************','********************');
510: END IF;

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

503: IF g_debug THEN
504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );
509: pay_in_utils.trace('**************************************************','********************');
510: END IF;
511:

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

504: pay_in_utils.trace('**************************************************','********************');
505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );
509: pay_in_utils.trace('**************************************************','********************');
510: END IF;
511:
512: -- PAN format - XXXXX9999X

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

505: pay_in_utils.trace('p_pan ',p_pan );
506: pay_in_utils.trace('p_pan_af ',p_pan_af );
507: pay_in_utils.trace('p_panref_number',p_panref_number);
508: pay_in_utils.trace('p_message_name ',p_message_name );
509: pay_in_utils.trace('**************************************************','********************');
510: END IF;
511:
512: -- PAN format - XXXXX9999X
513: -- Check for the length

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

516: p_token_name(1) := 'FIELD';
517: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN');
518: p_token_name(2) := 'FORMAT';
519: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
520: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
521:
522: IF g_debug THEN
523: pay_in_utils.trace('**************************************************','********************');
524: pay_in_utils.trace('p_message_name ',p_message_name);

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

519: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
520: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
521:
522: IF g_debug THEN
523: pay_in_utils.trace('**************************************************','********************');
524: pay_in_utils.trace('p_message_name ',p_message_name);
525: pay_in_utils.trace('**************************************************','********************');
526: END IF;
527:

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

520: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
521:
522: IF g_debug THEN
523: pay_in_utils.trace('**************************************************','********************');
524: pay_in_utils.trace('p_message_name ',p_message_name);
525: pay_in_utils.trace('**************************************************','********************');
526: END IF;
527:
528: RETURN;

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

521:
522: IF g_debug THEN
523: pay_in_utils.trace('**************************************************','********************');
524: pay_in_utils.trace('p_message_name ',p_message_name);
525: pay_in_utils.trace('**************************************************','********************');
526: END IF;
527:
528: RETURN;
529: END IF;

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

544: p_token_name(2) := 'FORMAT';
545: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_FORMAT');
546:
547: IF g_debug THEN
548: pay_in_utils.trace('**************************************************','********************');
549: pay_in_utils.trace('p_message_name ',p_message_name);
550: pay_in_utils.trace('**************************************************','********************');
551: END IF;
552:

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

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

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

546:
547: IF g_debug THEN
548: pay_in_utils.trace('**************************************************','********************');
549: pay_in_utils.trace('p_message_name ',p_message_name);
550: pay_in_utils.trace('**************************************************','********************');
551: END IF;
552:
553: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
554: RETURN;

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

549: pay_in_utils.trace('p_message_name ',p_message_name);
550: pay_in_utils.trace('**************************************************','********************');
551: END IF;
552:
553: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
554: RETURN;
555: END IF ;
556: END LOOP ;
557:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

623: p_token_name(2) := 'FIELD2';
624: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
625:
626: IF g_debug THEN
627: pay_in_utils.trace('**************************************************','********************');
628: pay_in_utils.trace('p_message_name ',p_message_name);
629: pay_in_utils.trace('**************************************************','********************');
630: END IF;
631:

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

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

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

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

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

628: pay_in_utils.trace('p_message_name ',p_message_name);
629: pay_in_utils.trace('**************************************************','********************');
630: END IF;
631:
632: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
633: RETURN;
634: END IF;
635:
636: --Checks that either the PAN field or the PAN Ref Number For field is null.

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

641: p_token_name(2) := 'FIELD2';
642: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
643:
644: IF g_debug THEN
645: pay_in_utils.trace('**************************************************','********************');
646: pay_in_utils.trace('p_message_name ',p_message_name);
647: pay_in_utils.trace('**************************************************','********************');
648: END IF;
649:

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

642: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_REF');
643:
644: IF g_debug THEN
645: pay_in_utils.trace('**************************************************','********************');
646: pay_in_utils.trace('p_message_name ',p_message_name);
647: pay_in_utils.trace('**************************************************','********************');
648: END IF;
649:
650: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

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

643:
644: IF g_debug THEN
645: pay_in_utils.trace('**************************************************','********************');
646: pay_in_utils.trace('p_message_name ',p_message_name);
647: pay_in_utils.trace('**************************************************','********************');
648: END IF;
649:
650: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
651: RETURN;

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

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

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

652: END IF;
653: p_message_name:='SUCCESS';
654:
655: IF g_debug THEN
656: pay_in_utils.trace('**************************************************','********************');
657: pay_in_utils.trace('p_message_name ',p_message_name);
658: pay_in_utils.trace('**************************************************','********************');
659: END IF;
660:

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

653: p_message_name:='SUCCESS';
654:
655: IF g_debug THEN
656: pay_in_utils.trace('**************************************************','********************');
657: pay_in_utils.trace('p_message_name ',p_message_name);
658: pay_in_utils.trace('**************************************************','********************');
659: END IF;
660:
661: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

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

654:
655: IF g_debug THEN
656: pay_in_utils.trace('**************************************************','********************');
657: pay_in_utils.trace('p_message_name ',p_message_name);
658: pay_in_utils.trace('**************************************************','********************');
659: END IF;
660:
661: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
662:

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

657: pay_in_utils.trace('p_message_name ',p_message_name);
658: pay_in_utils.trace('**************************************************','********************');
659: END IF;
660:
661: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
662:
663:
664: END check_pan_format;
665:

Line 727: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

723: ,p_pension_number IN VARCHAR2
724: ,p_panref_number IN VARCHAR2
725: ,p_NSSN IN VARCHAR2
726: ,p_message_name OUT NOCOPY VARCHAR2
727: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
728: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
729: )
730: IS
731:

Line 728: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

724: ,p_panref_number IN VARCHAR2
725: ,p_NSSN IN VARCHAR2
726: ,p_message_name OUT NOCOPY VARCHAR2
727: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
728: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
729: )
730: IS
731:
732: CURSOR csr_pt

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

761:
762:
763: l_procedure := g_package||'check_in_person_int';
764: g_debug := hr_utility.debug_enabled;
765: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
766:
767: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
768: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
769: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

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

765: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
766:
767: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
768: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
769: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
770: RETURN;
771: END IF;
772:
773: IF g_debug THEN

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

770: RETURN;
771: END IF;
772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );

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

771: END IF;
772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );

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

772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );

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

773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );

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

774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );

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

775: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );

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

776: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );

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

777: pay_in_utils.trace('p_person_id ',p_person_id );
778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );

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

778: pay_in_utils.trace('p_effective_date ',p_effective_date );
779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );

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

779: pay_in_utils.trace('p_pan ',p_pan );
780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );

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

780: pay_in_utils.trace('p_pan_af ',p_pan_af );
781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );

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

781: pay_in_utils.trace('p_military_status ',p_military_status );
782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );

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

782: pay_in_utils.trace('p_resident_status ',p_resident_status );
783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );

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

783: pay_in_utils.trace('p_pf_number ',p_pf_number );
784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );

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

784: pay_in_utils.trace('p_esi_number ',p_esi_number );
785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );
792: pay_in_utils.trace('**************************************************','********************');

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

785: pay_in_utils.trace('p_sa_number ',p_sa_number );
786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );
792: pay_in_utils.trace('**************************************************','********************');
793: END IF;

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

786: pay_in_utils.trace('p_group_ins_number ',p_group_ins_number );
787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );
792: pay_in_utils.trace('**************************************************','********************');
793: END IF;
794:

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

787: pay_in_utils.trace('p_gratuity_number ',p_gratuity_number );
788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );
792: pay_in_utils.trace('**************************************************','********************');
793: END IF;
794:
795: --

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

788: pay_in_utils.trace('p_pension_number ',p_pension_number );
789: pay_in_utils.trace('p_panref_number ',p_panref_number );
790: pay_in_utils.trace('p_NSSN ',p_NSSN );
791: pay_in_utils.trace('p_message_name ',p_message_name );
792: pay_in_utils.trace('**************************************************','********************');
793: END IF;
794:
795: --
796: -- Check for mandatory arguments

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

809: p_token_name(2) := 'FIELD';
810: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
811:
812: IF g_debug THEN
813: pay_in_utils.trace('p_message_name ',p_message_name);
814: END IF;
815:
816: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
817: RETURN;

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

812: IF g_debug THEN
813: pay_in_utils.trace('p_message_name ',p_message_name);
814: END IF;
815:
816: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
817: RETURN;
818: END IF ;
819: END IF ;
820: ELSE

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

828: p_token_name(2) := 'ARGUMENT';
829: p_token_value(2) := 'P_PERSON_TYPE_ID';
830:
831: IF g_debug THEN
832: pay_in_utils.trace('**************************************************','********************');
833: pay_in_utils.trace('p_message_name ',p_message_name);
834: pay_in_utils.trace('**************************************************','********************');
835: END IF;
836:

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

829: p_token_value(2) := 'P_PERSON_TYPE_ID';
830:
831: IF g_debug THEN
832: pay_in_utils.trace('**************************************************','********************');
833: pay_in_utils.trace('p_message_name ',p_message_name);
834: pay_in_utils.trace('**************************************************','********************');
835: END IF;
836:
837: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

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

830:
831: IF g_debug THEN
832: pay_in_utils.trace('**************************************************','********************');
833: pay_in_utils.trace('p_message_name ',p_message_name);
834: pay_in_utils.trace('**************************************************','********************');
835: END IF;
836:
837: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
838: RETURN ;

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

833: pay_in_utils.trace('p_message_name ',p_message_name);
834: pay_in_utils.trace('**************************************************','********************');
835: END IF;
836:
837: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
838: RETURN ;
839: ELSE
840: OPEN csr_ptu ;
841: FETCH csr_ptu INTO l_person_type;

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

847: p_token_name(2) := 'FIELD';
848: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
849:
850: IF g_debug THEN
851: pay_in_utils.trace('**************************************************','********************');
852: pay_in_utils.trace('p_message_name ',p_message_name);
853: pay_in_utils.trace('**************************************************','********************');
854: END IF;
855:

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

848: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PERSON_TYPE');
849:
850: IF g_debug THEN
851: pay_in_utils.trace('**************************************************','********************');
852: pay_in_utils.trace('p_message_name ',p_message_name);
853: pay_in_utils.trace('**************************************************','********************');
854: END IF;
855:
856: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

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

849:
850: IF g_debug THEN
851: pay_in_utils.trace('**************************************************','********************');
852: pay_in_utils.trace('p_message_name ',p_message_name);
853: pay_in_utils.trace('**************************************************','********************');
854: END IF;
855:
856: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
857: RETURN ;

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

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

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

866: IF NOT chk_person_type (l_person_type)
867:
868: THEN
869: IF g_debug THEN
870: pay_in_utils.trace('**************************************************','********************');
871: pay_in_utils.trace('p_message_name ',p_message_name);
872: pay_in_utils.trace('**************************************************','********************');
873: END IF;
874:

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

867:
868: THEN
869: IF g_debug THEN
870: pay_in_utils.trace('**************************************************','********************');
871: pay_in_utils.trace('p_message_name ',p_message_name);
872: pay_in_utils.trace('**************************************************','********************');
873: END IF;
874:
875: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);

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

868: THEN
869: IF g_debug THEN
870: pay_in_utils.trace('**************************************************','********************');
871: pay_in_utils.trace('p_message_name ',p_message_name);
872: pay_in_utils.trace('**************************************************','********************');
873: END IF;
874:
875: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
876: RETURN ;

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

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

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

888: p_token_name(2) := 'ARGUMENT';
889: p_token_value(2) := 'P_RESIDENT_STATUS';
890:
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: p_token_value(2) := 'P_RESIDENT_STATUS';
890:
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, 70);

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

890:
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, 70);
898: RETURN;

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

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, 70);
898: RETURN;
899: END IF;
900:
901: --

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

911: p_token_name(2) := 'FIELD';
912: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
913:
914: IF g_debug THEN
915: pay_in_utils.trace('**************************************************','********************');
916: pay_in_utils.trace('p_message_name ',p_message_name);
917: pay_in_utils.trace('**************************************************','********************');
918: END IF;
919:

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

912: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PAN_AF');
913:
914: IF g_debug THEN
915: pay_in_utils.trace('**************************************************','********************');
916: pay_in_utils.trace('p_message_name ',p_message_name);
917: pay_in_utils.trace('**************************************************','********************');
918: END IF;
919:
920: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 80);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

979:
980: IF p_message_name <> 'SUCCESS' then
981:
982: IF g_debug THEN
983: pay_in_utils.trace('**************************************************','********************');
984: pay_in_utils.trace('p_message_name ',p_message_name);
985: pay_in_utils.trace('**************************************************','********************');
986: END IF;
987:

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

980: IF p_message_name <> 'SUCCESS' then
981:
982: IF g_debug THEN
983: pay_in_utils.trace('**************************************************','********************');
984: pay_in_utils.trace('p_message_name ',p_message_name);
985: pay_in_utils.trace('**************************************************','********************');
986: END IF;
987:
988: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 110);

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

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

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

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

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

996: p_token_name(1) := 'FIELD';
997: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
998: p_token_name(2) := 'FORMAT';
999: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1000: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1001:
1002: IF g_debug THEN
1003: pay_in_utils.trace('**************************************************','********************');
1004: pay_in_utils.trace('p_message_name ',p_message_name);

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

999: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1000: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1001:
1002: IF g_debug THEN
1003: pay_in_utils.trace('**************************************************','********************');
1004: pay_in_utils.trace('p_message_name ',p_message_name);
1005: pay_in_utils.trace('**************************************************','********************');
1006: END IF;
1007:

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

1000: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1001:
1002: IF g_debug THEN
1003: pay_in_utils.trace('**************************************************','********************');
1004: pay_in_utils.trace('p_message_name ',p_message_name);
1005: pay_in_utils.trace('**************************************************','********************');
1006: END IF;
1007:
1008: RETURN;

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

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

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

1012: p_token_name(1) := 'FIELD';
1013: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN');
1014: p_token_name(2) := 'FORMAT';
1015: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1016: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1017:
1018: IF g_debug THEN
1019: pay_in_utils.trace('**************************************************','********************');
1020: pay_in_utils.trace('p_message_name ',p_message_name);

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

1015: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','NSSN_FORMAT');
1016: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1017:
1018: IF g_debug THEN
1019: pay_in_utils.trace('**************************************************','********************');
1020: pay_in_utils.trace('p_message_name ',p_message_name);
1021: pay_in_utils.trace('**************************************************','********************');
1022: END IF;
1023:

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

1016: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 115);
1017:
1018: IF g_debug THEN
1019: pay_in_utils.trace('**************************************************','********************');
1020: pay_in_utils.trace('p_message_name ',p_message_name);
1021: pay_in_utils.trace('**************************************************','********************');
1022: END IF;
1023:
1024: RETURN;

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

1017:
1018: IF g_debug THEN
1019: pay_in_utils.trace('**************************************************','********************');
1020: pay_in_utils.trace('p_message_name ',p_message_name);
1021: pay_in_utils.trace('**************************************************','********************');
1022: END IF;
1023:
1024: RETURN;
1025: END IF;

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

1045:
1046: IF p_message_name <> 'SUCCESS' then
1047:
1048: IF g_debug THEN
1049: pay_in_utils.trace('**************************************************','********************');
1050: pay_in_utils.trace('p_message_name ',p_message_name);
1051: pay_in_utils.trace('**************************************************','********************');
1052: END IF;
1053:

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

1046: IF p_message_name <> 'SUCCESS' then
1047:
1048: IF g_debug THEN
1049: pay_in_utils.trace('**************************************************','********************');
1050: pay_in_utils.trace('p_message_name ',p_message_name);
1051: pay_in_utils.trace('**************************************************','********************');
1052: END IF;
1053:
1054: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);

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

1047:
1048: IF g_debug THEN
1049: pay_in_utils.trace('**************************************************','********************');
1050: pay_in_utils.trace('p_message_name ',p_message_name);
1051: pay_in_utils.trace('**************************************************','********************');
1052: END IF;
1053:
1054: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
1055: RETURN;

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

1050: pay_in_utils.trace('p_message_name ',p_message_name);
1051: pay_in_utils.trace('**************************************************','********************');
1052: END IF;
1053:
1054: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
1055: RETURN;
1056: END IF;
1057:
1058: check_unique_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1115:
1116: IF p_message_name <> 'SUCCESS' then
1117:
1118: IF g_debug THEN
1119: pay_in_utils.trace('**************************************************','********************');
1120: pay_in_utils.trace('p_message_name ',p_message_name);
1121: pay_in_utils.trace('**************************************************','********************');
1122: END IF;
1123:

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

1116: IF p_message_name <> 'SUCCESS' then
1117:
1118: IF g_debug THEN
1119: pay_in_utils.trace('**************************************************','********************');
1120: pay_in_utils.trace('p_message_name ',p_message_name);
1121: pay_in_utils.trace('**************************************************','********************');
1122: END IF;
1123:
1124: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);

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

1117:
1118: IF g_debug THEN
1119: pay_in_utils.trace('**************************************************','********************');
1120: pay_in_utils.trace('p_message_name ',p_message_name);
1121: pay_in_utils.trace('**************************************************','********************');
1122: END IF;
1123:
1124: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
1125: RETURN;

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

1120: pay_in_utils.trace('p_message_name ',p_message_name);
1121: pay_in_utils.trace('**************************************************','********************');
1122: END IF;
1123:
1124: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
1125: RETURN;
1126: END IF;
1127:
1128: check_unique_number

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

1138:
1139: IF p_message_name <> 'SUCCESS' then
1140:
1141: IF g_debug THEN
1142: pay_in_utils.trace('**************************************************','********************');
1143: pay_in_utils.trace('p_message_name ',p_message_name);
1144: pay_in_utils.trace('**************************************************','********************');
1145: END IF;
1146:

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

1139: IF p_message_name <> 'SUCCESS' then
1140:
1141: IF g_debug THEN
1142: pay_in_utils.trace('**************************************************','********************');
1143: pay_in_utils.trace('p_message_name ',p_message_name);
1144: pay_in_utils.trace('**************************************************','********************');
1145: END IF;
1146:
1147: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);

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

1140:
1141: IF g_debug THEN
1142: pay_in_utils.trace('**************************************************','********************');
1143: pay_in_utils.trace('p_message_name ',p_message_name);
1144: pay_in_utils.trace('**************************************************','********************');
1145: END IF;
1146:
1147: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
1148: RETURN;

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

1143: pay_in_utils.trace('p_message_name ',p_message_name);
1144: pay_in_utils.trace('**************************************************','********************');
1145: END IF;
1146:
1147: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
1148: RETURN;
1149: END IF;
1150:
1151: check_unique_number

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

1161:
1162: IF p_message_name <> 'SUCCESS' then
1163:
1164: IF g_debug THEN
1165: pay_in_utils.trace('**************************************************','********************');
1166: pay_in_utils.trace('p_message_name ',p_message_name);
1167: pay_in_utils.trace('**************************************************','********************');
1168: END IF;
1169:

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

1162: IF p_message_name <> 'SUCCESS' then
1163:
1164: IF g_debug THEN
1165: pay_in_utils.trace('**************************************************','********************');
1166: pay_in_utils.trace('p_message_name ',p_message_name);
1167: pay_in_utils.trace('**************************************************','********************');
1168: END IF;
1169:
1170: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);

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

1163:
1164: IF g_debug THEN
1165: pay_in_utils.trace('**************************************************','********************');
1166: pay_in_utils.trace('p_message_name ',p_message_name);
1167: pay_in_utils.trace('**************************************************','********************');
1168: END IF;
1169:
1170: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);
1171: RETURN;

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

1166: pay_in_utils.trace('p_message_name ',p_message_name);
1167: pay_in_utils.trace('**************************************************','********************');
1168: END IF;
1169:
1170: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 170);
1171: RETURN;
1172: END IF;
1173:
1174: check_unique_number

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

1184:
1185: IF p_message_name <> 'SUCCESS' then
1186:
1187: IF g_debug THEN
1188: pay_in_utils.trace('**************************************************','********************');
1189: pay_in_utils.trace('p_message_name ',p_message_name);
1190: pay_in_utils.trace('**************************************************','********************');
1191: END IF;
1192:

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

1185: IF p_message_name <> 'SUCCESS' then
1186:
1187: IF g_debug THEN
1188: pay_in_utils.trace('**************************************************','********************');
1189: pay_in_utils.trace('p_message_name ',p_message_name);
1190: pay_in_utils.trace('**************************************************','********************');
1191: END IF;
1192:
1193: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);

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

1186:
1187: IF g_debug THEN
1188: pay_in_utils.trace('**************************************************','********************');
1189: pay_in_utils.trace('p_message_name ',p_message_name);
1190: pay_in_utils.trace('**************************************************','********************');
1191: END IF;
1192:
1193: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);
1194: RETURN;

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

1189: pay_in_utils.trace('p_message_name ',p_message_name);
1190: pay_in_utils.trace('**************************************************','********************');
1191: END IF;
1192:
1193: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 180);
1194: RETURN;
1195: END IF;
1196:
1197: check_unique_number

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

1207:
1208: IF p_message_name <> 'SUCCESS' then
1209:
1210: IF g_debug THEN
1211: pay_in_utils.trace('**************************************************','********************');
1212: pay_in_utils.trace('p_message_name ',p_message_name);
1213: pay_in_utils.trace('**************************************************','********************');
1214: END IF;
1215:

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

1208: IF p_message_name <> 'SUCCESS' then
1209:
1210: IF g_debug THEN
1211: pay_in_utils.trace('**************************************************','********************');
1212: pay_in_utils.trace('p_message_name ',p_message_name);
1213: pay_in_utils.trace('**************************************************','********************');
1214: END IF;
1215:
1216: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);

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

1209:
1210: IF g_debug THEN
1211: pay_in_utils.trace('**************************************************','********************');
1212: pay_in_utils.trace('p_message_name ',p_message_name);
1213: pay_in_utils.trace('**************************************************','********************');
1214: END IF;
1215:
1216: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);
1217: RETURN;

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

1212: pay_in_utils.trace('p_message_name ',p_message_name);
1213: pay_in_utils.trace('**************************************************','********************');
1214: END IF;
1215:
1216: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 190);
1217: RETURN;
1218: END IF;
1219:
1220: --Check uniqueness for the PF National Social Security Number

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

1231:
1232: IF p_message_name <> 'SUCCESS' then
1233:
1234: IF g_debug THEN
1235: pay_in_utils.trace('**************************************************','********************');
1236: pay_in_utils.trace('p_message_name ',p_message_name);
1237: pay_in_utils.trace('**************************************************','********************');
1238: END IF;
1239:

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

1232: IF p_message_name <> 'SUCCESS' then
1233:
1234: IF g_debug THEN
1235: pay_in_utils.trace('**************************************************','********************');
1236: pay_in_utils.trace('p_message_name ',p_message_name);
1237: pay_in_utils.trace('**************************************************','********************');
1238: END IF;
1239:
1240: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);

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

1233:
1234: IF g_debug THEN
1235: pay_in_utils.trace('**************************************************','********************');
1236: pay_in_utils.trace('p_message_name ',p_message_name);
1237: pay_in_utils.trace('**************************************************','********************');
1238: END IF;
1239:
1240: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1241: RETURN;

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

1236: pay_in_utils.trace('p_message_name ',p_message_name);
1237: pay_in_utils.trace('**************************************************','********************');
1238: END IF;
1239:
1240: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
1241: RETURN;
1242: END IF;
1243:
1244: IF g_debug THEN

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

1241: RETURN;
1242: END IF;
1243:
1244: IF g_debug THEN
1245: pay_in_utils.trace('p_message_name ',p_message_name);
1246: END IF;
1247:
1248: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 200);
1249:

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

1244: IF g_debug THEN
1245: pay_in_utils.trace('p_message_name ',p_message_name);
1246: END IF;
1247:
1248: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 200);
1249:
1250:
1251: END check_in_person_int;
1252:

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

1323: BEGIN
1324:
1325: l_procedure := g_package||'check_in_person_insert';
1326: g_debug := hr_utility.debug_enabled;
1327: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1328:
1329: IF g_debug THEN
1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);

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

1326: g_debug := hr_utility.debug_enabled;
1327: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1328:
1329: IF g_debug THEN
1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );

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

1327: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1328:
1329: IF g_debug THEN
1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

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

1328:
1329: IF g_debug THEN
1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

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

1329: IF g_debug THEN
1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

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

1330: pay_in_utils.trace('**************************************************','********************');
1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

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

1331: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

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

1332: pay_in_utils.trace('p_business_group_id ',p_business_group_id );
1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

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

1333: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

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

1334: pay_in_utils.trace('p_hire_date ',p_hire_date );
1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

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

1335: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

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

1336: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

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

1337: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

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

1338: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

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

1339: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1347: pay_in_utils.trace('**************************************************','********************');

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

1340: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1347: pay_in_utils.trace('**************************************************','********************');
1348: END IF;

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

1341: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1347: pay_in_utils.trace('**************************************************','********************');
1348: END IF;
1349:

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

1342: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1347: pay_in_utils.trace('**************************************************','********************');
1348: END IF;
1349:
1350: p_message_name := 'SUCCESS';

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

1343: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1344: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1345: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1346: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1347: pay_in_utils.trace('**************************************************','********************');
1348: END IF;
1349:
1350: p_message_name := 'SUCCESS';
1351: IF p_per_information_category <> 'IN' then

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

1348: END IF;
1349:
1350: p_message_name := 'SUCCESS';
1351: IF p_per_information_category <> 'IN' then
1352: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1353: RETURN;
1354: END IF;
1355:
1356: check_in_person_int

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

1374: ,p_token_name => p_token_name
1375: ,p_token_value => p_token_value
1376: );
1377:
1378: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1379: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1380: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1381: ELSE
1382: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

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

1376: );
1377:
1378: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1379: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1380: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1381: ELSE
1382: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1383: END IF;
1384:

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

1378: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1379: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1380: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1381: ELSE
1382: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1383: END IF;
1384:
1385: END check_in_person_insert;
1386:

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

1486: BEGIN
1487:
1488: l_procedure := g_package||'check_in_person_update';
1489: g_debug := hr_utility.debug_enabled;
1490: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1491:
1492: IF g_debug THEN
1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);

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

1489: g_debug := hr_utility.debug_enabled;
1490: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1491:
1492: IF g_debug THEN
1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );

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

1490: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
1491:
1492: IF g_debug THEN
1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );

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

1491:
1492: IF g_debug THEN
1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );

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

1492: IF g_debug THEN
1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );

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

1493: pay_in_utils.trace('**************************************************','********************');
1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );

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

1494: pay_in_utils.trace('p_per_information_category',p_per_information_category);
1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );

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

1495: pay_in_utils.trace('p_person_type_id ',p_person_type_id );
1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );

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

1496: pay_in_utils.trace('p_person_id ',p_person_id );
1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );

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

1497: pay_in_utils.trace('p_effective_date ',p_effective_date );
1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );

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

1498: pay_in_utils.trace('p_per_information4 ',p_per_information4 );
1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );

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

1499: pay_in_utils.trace('p_per_information5 ',p_per_information5 );
1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );

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

1500: pay_in_utils.trace('p_per_information6 ',p_per_information6 );
1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );

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

1501: pay_in_utils.trace('p_per_information7 ',p_per_information7 );
1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );

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

1502: pay_in_utils.trace('p_per_information8 ',p_per_information8 );
1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1510: pay_in_utils.trace('**************************************************','********************');

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

1503: pay_in_utils.trace('p_per_information9 ',p_per_information9 );
1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1510: pay_in_utils.trace('**************************************************','********************');
1511: END IF;

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

1504: pay_in_utils.trace('p_per_information10 ',p_per_information10 );
1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1510: pay_in_utils.trace('**************************************************','********************');
1511: END IF;
1512:

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

1505: pay_in_utils.trace('p_per_information11 ',p_per_information11 );
1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1510: pay_in_utils.trace('**************************************************','********************');
1511: END IF;
1512:
1513: p_message_name := 'SUCCESS';

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

1506: pay_in_utils.trace('p_per_information12 ',p_per_information12 );
1507: pay_in_utils.trace('p_per_information13 ',p_per_information13 );
1508: pay_in_utils.trace('p_per_information14 ',p_per_information14 );
1509: pay_in_utils.trace('p_per_information15 ',p_per_information15 );
1510: pay_in_utils.trace('**************************************************','********************');
1511: END IF;
1512:
1513: p_message_name := 'SUCCESS';
1514:

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

1512:
1513: p_message_name := 'SUCCESS';
1514:
1515: IF p_per_information_category <> 'IN' then
1516: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1517: RETURN;
1518: END IF;
1519:
1520: OPEN csr_person;

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

1603: ,p_token_name => p_token_name
1604: ,p_token_value => p_token_value
1605: );
1606:
1607: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1608: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1609: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1610: ELSE
1611: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);

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

1605: );
1606:
1607: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1608: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1609: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1610: ELSE
1611: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1612: END IF;
1613:

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

1607: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1608: IF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
1609: pay_in_utils.raise_message(800,p_message_name, p_token_name, p_token_value);
1610: ELSE
1611: pay_in_utils.raise_message(801,p_message_name, p_token_name, p_token_value);
1612: END IF;
1613:
1614: END check_in_person_update;
1615: