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

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

364:
365: BEGIN
366: g_debug := hr_utility.debug_enabled;
367: l_procedure := g_package ||'is_supported';
368: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
369: IF (g_debug)
370: THEN
371: pay_in_utils.trace('**************************************************','********************');
372: pay_in_utils.trace('p_dimension_name :',p_dimension_name);

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

367: l_procedure := g_package ||'is_supported';
368: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
369: IF (g_debug)
370: THEN
371: pay_in_utils.trace('**************************************************','********************');
372: pay_in_utils.trace('p_dimension_name :',p_dimension_name);
373: pay_in_utils.trace('**************************************************','********************');
374: END IF;
375:

Line 372: pay_in_utils.trace('p_dimension_name :',p_dimension_name);

368: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
369: IF (g_debug)
370: THEN
371: pay_in_utils.trace('**************************************************','********************');
372: pay_in_utils.trace('p_dimension_name :',p_dimension_name);
373: pay_in_utils.trace('**************************************************','********************');
374: END IF;
375:
376: --

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

369: IF (g_debug)
370: THEN
371: pay_in_utils.trace('**************************************************','********************');
372: pay_in_utils.trace('p_dimension_name :',p_dimension_name);
373: pay_in_utils.trace('**************************************************','********************');
374: END IF;
375:
376: --
377: -- hr_utility.trace('Entering pay_in_bal_upload.is_supported');

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

382: FETCH csr_dimension INTO l_dimension_id;
383:
384: IF (g_debug)
385: THEN
386: pay_in_utils.trace('**************************************************','********************');
387: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
388: pay_in_utils.trace('**************************************************','********************');
389: END IF;
390:

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

383:
384: IF (g_debug)
385: THEN
386: pay_in_utils.trace('**************************************************','********************');
387: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
388: pay_in_utils.trace('**************************************************','********************');
389: END IF;
390:
391: IF csr_dimension%NOTFOUND THEN

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

384: IF (g_debug)
385: THEN
386: pay_in_utils.trace('**************************************************','********************');
387: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
388: pay_in_utils.trace('**************************************************','********************');
389: END IF;
390:
391: IF csr_dimension%NOTFOUND THEN
392: CLOSE csr_dimension;

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

389: END IF;
390:
391: IF csr_dimension%NOTFOUND THEN
392: CLOSE csr_dimension;
393: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
394: RETURN (0); -- denotes FALSE
395: ELSE
396: CLOSE csr_dimension;
397: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

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

393: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
394: RETURN (0); -- denotes FALSE
395: ELSE
396: CLOSE csr_dimension;
397: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
398: RETURN (1); -- denotes TRUE
399: END IF;
400: --
401: -- hr_utility.trace('Exiting pay_in_bal_upload.is_supported');

Line 406: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

402: --
403: EXCEPTION
404: WHEN others THEN
405: CLOSE csr_dimension;
406: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
407: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
408: pay_in_utils.trace(l_message,l_procedure);
409: pay_in_utils.trace('**************************************************','********************');
410: RAISE;

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

403: EXCEPTION
404: WHEN others THEN
405: CLOSE csr_dimension;
406: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
407: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
408: pay_in_utils.trace(l_message,l_procedure);
409: pay_in_utils.trace('**************************************************','********************');
410: RAISE;
411: END is_supported;

Line 408: pay_in_utils.trace(l_message,l_procedure);

404: WHEN others THEN
405: CLOSE csr_dimension;
406: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
407: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
408: pay_in_utils.trace(l_message,l_procedure);
409: pay_in_utils.trace('**************************************************','********************');
410: RAISE;
411: END is_supported;
412:

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

405: CLOSE csr_dimension;
406: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
407: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
408: pay_in_utils.trace(l_message,l_procedure);
409: pay_in_utils.trace('**************************************************','********************');
410: RAISE;
411: END is_supported;
412:
413:

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

526:
527: BEGIN
528: g_debug := hr_utility.debug_enabled;
529: l_procedure := g_package ||'include_adjustment';
530: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
531: IF (g_debug)
532: THEN
533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );

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

529: l_procedure := g_package ||'include_adjustment';
530: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
531: IF (g_debug)
532: THEN
533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );

Line 534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );

530: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
531: IF (g_debug)
532: THEN
533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );

Line 535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );

531: IF (g_debug)
532: THEN
533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);

Line 536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );

532: THEN
533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
540: pay_in_utils.trace('**************************************************','********************');

Line 537: pay_in_utils.trace('p_upload_date :',p_upload_date );

533: pay_in_utils.trace('**************************************************','********************');
534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
540: pay_in_utils.trace('**************************************************','********************');
541: END IF;

Line 538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );

534: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
540: pay_in_utils.trace('**************************************************','********************');
541: END IF;
542:

Line 539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);

535: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
540: pay_in_utils.trace('**************************************************','********************');
541: END IF;
542:
543:

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

536: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
537: pay_in_utils.trace('p_upload_date :',p_upload_date );
538: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
539: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
540: pay_in_utils.trace('**************************************************','********************');
541: END IF;
542:
543:
544: OPEN csr_get_details(p_batch_line_id);

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

552: --
553:
554: IF (g_debug)
555: THEN
556: pay_in_utils.trace('**************************************************','********************');
557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );

Line 557: pay_in_utils.trace('l_source_id :',l_source_id );

553:
554: IF (g_debug)
555: THEN
556: pay_in_utils.trace('**************************************************','********************');
557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );

Line 558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);

554: IF (g_debug)
555: THEN
556: pay_in_utils.trace('**************************************************','********************');
557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );

Line 559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );

555: THEN
556: pay_in_utils.trace('**************************************************','********************');
557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
563: pay_in_utils.trace('**************************************************','********************');

Line 560: pay_in_utils.trace('l_jur_code :',l_jur_code );

556: pay_in_utils.trace('**************************************************','********************');
557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
563: pay_in_utils.trace('**************************************************','********************');
564: END IF;

Line 561: pay_in_utils.trace('l_source_text :',l_source_text );

557: pay_in_utils.trace('l_source_id :',l_source_id );
558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
563: pay_in_utils.trace('**************************************************','********************');
564: END IF;
565:

Line 562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );

558: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
563: pay_in_utils.trace('**************************************************','********************');
564: END IF;
565:
566: OPEN csr_get_tested_adjustments(p_test_batch_line_id);

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

559: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
560: pay_in_utils.trace('l_jur_code :',l_jur_code );
561: pay_in_utils.trace('l_source_text :',l_source_text );
562: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
563: pay_in_utils.trace('**************************************************','********************');
564: END IF;
565:
566: OPEN csr_get_tested_adjustments(p_test_batch_line_id);
567: FETCH csr_get_tested_adjustments

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

574: CLOSE csr_get_tested_adjustments;
575:
576: IF (g_debug)
577: THEN
578: pay_in_utils.trace('**************************************************','********************');
579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );

Line 579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );

575:
576: IF (g_debug)
577: THEN
578: pay_in_utils.trace('**************************************************','********************');
579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );

Line 580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);

576: IF (g_debug)
577: THEN
578: pay_in_utils.trace('**************************************************','********************');
579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );

Line 581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );

577: THEN
578: pay_in_utils.trace('**************************************************','********************');
579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
585: pay_in_utils.trace('**************************************************','********************');

Line 582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );

578: pay_in_utils.trace('**************************************************','********************');
579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;

Line 583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );

579: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587: -- Does the balance adjustment effect the new balance ?

Line 584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );

580: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587: -- Does the balance adjustment effect the new balance ?
588:

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

581: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
582: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
583: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
584: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587: -- Does the balance adjustment effect the new balance ?
588:
589: --hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));

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

613: CLOSE csr_is_included;
614:
615: IF (g_debug)
616: THEN
617: pay_in_utils.trace('**************************************************','********************');
618: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);
619: pay_in_utils.trace('**************************************************','********************');
620: END IF;
621:

Line 618: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);

614:
615: IF (g_debug)
616: THEN
617: pay_in_utils.trace('**************************************************','********************');
618: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);
619: pay_in_utils.trace('**************************************************','********************');
620: END IF;
621:
622: --hr_utility.trace('Exiting pay_in_bal_upload.include_adjustment_test');

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

615: IF (g_debug)
616: THEN
617: pay_in_utils.trace('**************************************************','********************');
618: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);
619: pay_in_utils.trace('**************************************************','********************');
620: END IF;
621:
622: --hr_utility.trace('Exiting pay_in_bal_upload.include_adjustment_test');
623:

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

623:
624: -- Adjustment does contribute to the new balance.
625:
626: IF l_bal_type_id IS NOT NULL THEN
627: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
628: RETURN (1); --TRUE
629:
630: -- Adjustment does not contribute to the new balance.
631: ELSE

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

628: RETURN (1); --TRUE
629:
630: -- Adjustment does not contribute to the new balance.
631: ELSE
632: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
633: RETURN (0); --FALSE
634:
635: END IF;
636:

Line 651: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

647: IF csr_get_tested_adjustments%ISOPEN THEN
648: CLOSE csr_get_tested_adjustments;
649: END IF;
650:
651: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
653: pay_in_utils.trace(l_message,l_procedure);
654: pay_in_utils.trace('**************************************************','********************');
655: RAISE;

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

648: CLOSE csr_get_tested_adjustments;
649: END IF;
650:
651: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
653: pay_in_utils.trace(l_message,l_procedure);
654: pay_in_utils.trace('**************************************************','********************');
655: RAISE;
656: END include_adjustment;

Line 653: pay_in_utils.trace(l_message,l_procedure);

649: END IF;
650:
651: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
653: pay_in_utils.trace(l_message,l_procedure);
654: pay_in_utils.trace('**************************************************','********************');
655: RAISE;
656: END include_adjustment;
657: --------------------------------------------------------------------------

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

650:
651: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
653: pay_in_utils.trace(l_message,l_procedure);
654: pay_in_utils.trace('**************************************************','********************');
655: RAISE;
656: END include_adjustment;
657: --------------------------------------------------------------------------
658: -- --