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 364: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

360:
361: BEGIN
362: g_debug := hr_utility.debug_enabled;
363: l_procedure := g_package ||'is_supported';
364: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
365: IF (g_debug)
366: THEN
367: pay_in_utils.trace('**************************************************','********************');
368: pay_in_utils.trace('p_dimension_name :',p_dimension_name);

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

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

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

364: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
365: IF (g_debug)
366: THEN
367: pay_in_utils.trace('**************************************************','********************');
368: pay_in_utils.trace('p_dimension_name :',p_dimension_name);
369: pay_in_utils.trace('**************************************************','********************');
370: END IF;
371:
372: --

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

365: IF (g_debug)
366: THEN
367: pay_in_utils.trace('**************************************************','********************');
368: pay_in_utils.trace('p_dimension_name :',p_dimension_name);
369: pay_in_utils.trace('**************************************************','********************');
370: END IF;
371:
372: --
373: -- hr_utility.trace('Entering pay_in_bal_upload.is_supported');

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

378: FETCH csr_dimension INTO l_dimension_id;
379:
380: IF (g_debug)
381: THEN
382: pay_in_utils.trace('**************************************************','********************');
383: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
384: pay_in_utils.trace('**************************************************','********************');
385: END IF;
386:

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

379:
380: IF (g_debug)
381: THEN
382: pay_in_utils.trace('**************************************************','********************');
383: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
384: pay_in_utils.trace('**************************************************','********************');
385: END IF;
386:
387: IF csr_dimension%NOTFOUND THEN

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

380: IF (g_debug)
381: THEN
382: pay_in_utils.trace('**************************************************','********************');
383: pay_in_utils.trace('l_dimension_id :',l_dimension_id);
384: pay_in_utils.trace('**************************************************','********************');
385: END IF;
386:
387: IF csr_dimension%NOTFOUND THEN
388: CLOSE csr_dimension;

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

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

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

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

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

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

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

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

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

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

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

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

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

522:
523: BEGIN
524: g_debug := hr_utility.debug_enabled;
525: l_procedure := g_package ||'include_adjustment';
526: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
527: IF (g_debug)
528: THEN
529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );

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

525: l_procedure := g_package ||'include_adjustment';
526: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
527: IF (g_debug)
528: THEN
529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
531: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
532: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
533: pay_in_utils.trace('p_upload_date :',p_upload_date );

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

526: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
527: IF (g_debug)
528: THEN
529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
531: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
532: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
533: pay_in_utils.trace('p_upload_date :',p_upload_date );
534: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );

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

527: IF (g_debug)
528: THEN
529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
531: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
532: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
533: pay_in_utils.trace('p_upload_date :',p_upload_date );
534: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
535: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);

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

528: THEN
529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
531: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
532: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
533: pay_in_utils.trace('p_upload_date :',p_upload_date );
534: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
535: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
536: pay_in_utils.trace('**************************************************','********************');

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

529: pay_in_utils.trace('**************************************************','********************');
530: pay_in_utils.trace('p_balance_type_id :',p_balance_type_id );
531: pay_in_utils.trace('p_dimension_name :',p_dimension_name );
532: pay_in_utils.trace('p_original_entry_id :',p_original_entry_id );
533: pay_in_utils.trace('p_upload_date :',p_upload_date );
534: pay_in_utils.trace('p_batch_line_id :',p_batch_line_id );
535: pay_in_utils.trace('p_test_batch_line_id :',p_test_batch_line_id);
536: pay_in_utils.trace('**************************************************','********************');
537: END IF;

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

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

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

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

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

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

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

548: --
549:
550: IF (g_debug)
551: THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('l_source_id :',l_source_id );
554: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );

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

549:
550: IF (g_debug)
551: THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('l_source_id :',l_source_id );
554: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );
557: pay_in_utils.trace('l_source_text :',l_source_text );

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

550: IF (g_debug)
551: THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('l_source_id :',l_source_id );
554: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );
557: pay_in_utils.trace('l_source_text :',l_source_text );
558: pay_in_utils.trace('l_source_text2 :',l_source_text2 );

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

551: THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('l_source_id :',l_source_id );
554: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );
557: pay_in_utils.trace('l_source_text :',l_source_text );
558: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
559: pay_in_utils.trace('**************************************************','********************');

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

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

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

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

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

554: pay_in_utils.trace('l_orig_entry_id :',l_orig_entry_id);
555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );
557: pay_in_utils.trace('l_source_text :',l_source_text );
558: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
559: pay_in_utils.trace('**************************************************','********************');
560: END IF;
561:
562: OPEN csr_get_tested_adjustments(p_test_batch_line_id);

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

555: pay_in_utils.trace('l_tax_unit_id :',l_tax_unit_id );
556: pay_in_utils.trace('l_jur_code :',l_jur_code );
557: pay_in_utils.trace('l_source_text :',l_source_text );
558: pay_in_utils.trace('l_source_text2 :',l_source_text2 );
559: pay_in_utils.trace('**************************************************','********************');
560: END IF;
561:
562: OPEN csr_get_tested_adjustments(p_test_batch_line_id);
563: FETCH csr_get_tested_adjustments

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

570: CLOSE csr_get_tested_adjustments;
571:
572: IF (g_debug)
573: THEN
574: pay_in_utils.trace('**************************************************','********************');
575: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
576: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
577: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
578: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );

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

571:
572: IF (g_debug)
573: THEN
574: pay_in_utils.trace('**************************************************','********************');
575: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
576: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
577: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
578: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
579: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );

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

572: IF (g_debug)
573: THEN
574: pay_in_utils.trace('**************************************************','********************');
575: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
576: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
577: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
578: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
579: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
580: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );

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

573: THEN
574: pay_in_utils.trace('**************************************************','********************');
575: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
576: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
577: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
578: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
579: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
580: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
581: pay_in_utils.trace('**************************************************','********************');

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

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

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

575: pay_in_utils.trace('l_adj_source_id :',l_adj_source_id );
576: pay_in_utils.trace('l_adj_orig_entry_id:',l_adj_orig_entry_id);
577: pay_in_utils.trace('l_adj_tax_unit_id :',l_adj_tax_unit_id );
578: pay_in_utils.trace('l_adj_jur_code :',l_adj_jur_code );
579: pay_in_utils.trace('l_adj_source_text :',l_adj_source_text );
580: pay_in_utils.trace('l_adj_source_text2 :',l_adj_source_text2 );
581: pay_in_utils.trace('**************************************************','********************');
582: END IF;
583: -- Does the balance adjustment effect the new balance ?

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

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

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

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

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

609: CLOSE csr_is_included;
610:
611: IF (g_debug)
612: THEN
613: pay_in_utils.trace('**************************************************','********************');
614: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);
615: pay_in_utils.trace('**************************************************','********************');
616: END IF;
617:

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

610:
611: IF (g_debug)
612: THEN
613: pay_in_utils.trace('**************************************************','********************');
614: pay_in_utils.trace('l_bal_type_id :',l_bal_type_id);
615: pay_in_utils.trace('**************************************************','********************');
616: END IF;
617:
618: --hr_utility.trace('Exiting pay_in_bal_upload.include_adjustment_test');

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

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

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

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

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

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

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

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

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

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

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

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

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

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