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.JL_AR_DOC_NUMBERING_PKG dependencies on STANDARD

Line 28: arp_standard.debug('validate_trx_type: ' || '-- validate trx type ');

24:
25: BEGIN
26: l_return_code := 'SUCCESS';
27: IF PG_DEBUG in ('Y', 'C') THEN
28: arp_standard.debug('validate_trx_type: ' || '-- validate trx type ');
29: END IF;
30: -- Bug 8825457 Start
31: l_org_id := MO_GLOBAL.get_current_org_id;
32: -- Bug 8825457 End

Line 47: arp_standard.debug('validate_trx_type: ' || '-- First validate trx type check');

43: -- Bug 8825457 Start
44: AND src.org_id = l_org_id;
45: -- Bug 8825457 End
46: IF PG_DEBUG in ('Y', 'C') THEN
47: arp_standard.debug('validate_trx_type: ' || '-- First validate trx type check');
48: END IF;
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: IF p_created_from = 'RAXTRX' THEN

Line 94: arp_standard.debug('validate_trx_type: ' || '-- Second validate trx type check');

90: AND substr(src.global_attribute2,1,4) <> l_branch_number
91: AND ty.enable_flag = 'Y';
92: --
93: IF PG_DEBUG in ('Y', 'C') THEN
94: arp_standard.debug('validate_trx_type: ' || '-- Second validate trx type check');
95: END IF;
96: IF l_count > 0 THEN
97: IF p_created_from = 'RAXTRX' THEN
98: l_return_code := 'ERROR';

Line 561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);

557:
558: l_dummy_code := NULL;
559: BEGIN
560: IF PG_DEBUG in ('Y', 'C') THEN
561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);

Line 562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));

558: l_dummy_code := NULL;
559: BEGIN
560: IF PG_DEBUG in ('Y', 'C') THEN
561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
566: END IF;

Line 563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));

559: BEGIN
560: IF PG_DEBUG in ('Y', 'C') THEN
561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
566: END IF;
567: IF p_created_from = 'ARXTWMAI' THEN

Line 564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);

560: IF PG_DEBUG in ('Y', 'C') THEN
561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
566: END IF;
567: IF p_created_from = 'ARXTWMAI' THEN
568: SELECT nvl(cas.global_attribute9,'N')

Line 565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);

561: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
562: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
563: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
564: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
565: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
566: END IF;
567: IF p_created_from = 'ARXTWMAI' THEN
568: SELECT nvl(cas.global_attribute9,'N')
569: INTO l_cus_cls_flag

Line 638: arp_standard.debug('validate_document_letter: ' || '-- Successfully found a combination ');

634: END;
635:
636: IF l_dummy_code = 'Success' AND l_match_flag = 'Y' THEN
637: IF PG_DEBUG in ('Y', 'C') THEN
638: arp_standard.debug('validate_document_letter: ' || '-- Successfully found a combination ');
639: END IF;
640: -- Assigned SUCCESS to l_return_code Bug 1323607
641: l_return_code := 'SUCCESS';
642: EXIT;

Line 649: arp_standard.debug('validate_document_letter: ' || '-- match flag is n');

645: END LOOP;
646:
647: IF l_match_flag = 'N' THEN
648: IF PG_DEBUG in ('Y', 'C') THEN
649: arp_standard.debug('validate_document_letter: ' || '-- match flag is n');
650: END IF;
651: -- Added the following if condition Bug 1323607
652:
653: IF l_return_code IS NULL THEN -- Cursor contained no records

Line 704: arp_standard.debug('validate_interface_lines: ' || '-- JL_AR_DOC_NUMBERING_PKG validation begins');

700: l_invoice_class VARCHAR2(20);
701:
702: BEGIN
703: IF PG_DEBUG in ('Y', 'C') THEN
704: arp_standard.debug('validate_interface_lines: ' || '-- JL_AR_DOC_NUMBERING_PKG validation begins');
705: END IF;
706:
707: l_return_code := 1;
708: IF PG_DEBUG in ('Y', 'C') THEN

Line 709: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source id for the request');

705: END IF;
706:
707: l_return_code := 1;
708: IF PG_DEBUG in ('Y', 'C') THEN
709: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source id for the request');
710: END IF;
711: BEGIN
712: SELECT to_number(argument3)
713: INTO l_batch_source_id

Line 717: arp_standard.debug('validate_interface_lines: ' || '-- the batch source id for the request is '||to_char(l_batch_source_id));

713: INTO l_batch_source_id
714: FROM fnd_concurrent_requests
715: WHERE request_id = p_request_id;
716: IF PG_DEBUG in ('Y', 'C') THEN
717: arp_standard.debug('validate_interface_lines: ' || '-- the batch source id for the request is '||to_char(l_batch_source_id));
718: END IF;
719: END;
720:
721: IF PG_DEBUG in ('Y', 'C') THEN

Line 722: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source gdf segments');

718: END IF;
719: END;
720:
721: IF PG_DEBUG in ('Y', 'C') THEN
722: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source gdf segments');
723: END IF;
724: BEGIN
725: SELECT auto_trx_numbering_flag
726: ,substr(global_attribute3,1,1)

Line 737: arp_standard.debug('validate_interface_lines: ' || '-- the batch source gdf segments found');

733: FROM ra_batch_sources
734: WHERE batch_source_id = l_batch_source_id;
735: END;
736: IF PG_DEBUG in ('Y', 'C') THEN
737: arp_standard.debug('validate_interface_lines: ' || '-- the batch source gdf segments found');
738: END IF;
739:
740: IF l_auto_trx_numbering_flag ='N' THEN
741: IF PG_DEBUG in ('Y', 'C') THEN

Line 742: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is N');

738: END IF;
739:
740: IF l_auto_trx_numbering_flag ='N' THEN
741: IF PG_DEBUG in ('Y', 'C') THEN
742: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is N');
743: END IF;
744: l_return_code := 1;
745: RAISE error_condition;
746: END IF;

Line 748: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is Y');

744: l_return_code := 1;
745: RAISE error_condition;
746: END IF;
747: IF PG_DEBUG in ('Y', 'C') THEN
748: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is Y');
749: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter begins');
750: END IF;
751:
752: IF validate_document_letter (l_batch_source_id

Line 749: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter begins');

745: RAISE error_condition;
746: END IF;
747: IF PG_DEBUG in ('Y', 'C') THEN
748: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is Y');
749: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter begins');
750: END IF;
751:
752: IF validate_document_letter (l_batch_source_id
753: ,p_interface_line_id

Line 759: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter set up problem');

755: ,p_orig_system_address_id
756: ,l_document_letter
757: ,p_so_org_id ) <> 'SUCCESS' THEN
758: IF PG_DEBUG in ('Y', 'C') THEN
759: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter set up problem');
760: END IF;
761: l_return_code := 1;
762: END IF;
763:

Line 765: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the type for the trx type');

761: l_return_code := 1;
762: END IF;
763:
764: IF PG_DEBUG in ('Y', 'C') THEN
765: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the type for the trx type');
766: END IF;
767: BEGIN
768: SELECT type
769: INTO l_invoice_class

Line 773: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');

769: INTO l_invoice_class
770: FROM ra_cust_trx_types
771: WHERE cust_trx_type_id = p_trx_type;
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
774: END IF;
775: END;
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('validate_interface_lines: ' || '-- validate trx type begins');

Line 777: arp_standard.debug('validate_interface_lines: ' || '-- validate trx type begins');

773: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
774: END IF;
775: END;
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('validate_interface_lines: ' || '-- validate trx type begins');
778: END IF;
779:
780: IF validate_trx_type (l_batch_source_id
781: ,p_trx_type

Line 787: arp_standard.debug('validate_interface_lines: ' || '-- validate trx types and sources are not set');

783: ,l_document_letter
784: ,p_interface_line_id
785: ,'RAXTRX' ) <> 'SUCCESS' THEN
786: IF PG_DEBUG in ('Y', 'C') THEN
787: arp_standard.debug('validate_interface_lines: ' || '-- validate trx types and sources are not set');
788: END IF;
789: l_return_code := 1;
790: END IF;
791:

Line 793: arp_standard.debug('validate_interface_lines: ' || '-- validate branch number begins');

789: l_return_code := 1;
790: END IF;
791:
792: IF PG_DEBUG in ('Y', 'C') THEN
793: arp_standard.debug('validate_interface_lines: ' || '-- validate branch number begins');
794: END IF;
795: IF validate_four_digit (l_batch_source_id
796: ,p_interface_line_id
797: ,'RAXTRX'

Line 802: arp_standard.debug('validate_interface_lines: ' || '-- branch number validation problem');

798: ,p_inventory_item_id
799: ,p_memo_line_id
800: ,p_so_org_id ) <> 'SUCCESS' THEN
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_standard.debug('validate_interface_lines: ' || '-- branch number validation problem');
803: END IF;
804: l_return_code := 1;
805: END IF;
806:

Line 808: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date begins');

804: l_return_code := 1;
805: END IF;
806:
807: IF PG_DEBUG in ('Y', 'C') THEN
808: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date begins');
809: END IF;
810: IF p_trx_date BETWEEN
811: l_last_trx_date AND (sysdate+l_advance_days) THEN
812: IF p_trx_date <> l_last_trx_date THEN

Line 816: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date ok');

812: IF p_trx_date <> l_last_trx_date THEN
813: l_max_trx_date := p_trx_date;
814: END IF;
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date ok');
817: END IF;
818: ELSE
819: BEGIN
820: IF PG_DEBUG in ('Y', 'C') THEN

Line 821: arp_standard.debug('validate_interface_lines: ' || '-- date validation problem');

817: END IF;
818: ELSE
819: BEGIN
820: IF PG_DEBUG in ('Y', 'C') THEN
821: arp_standard.debug('validate_interface_lines: ' || '-- date validation problem');
822: END IF;
823: l_return_code := 1;
824: IF p_trx_date < l_last_trx_date THEN
825: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 843: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');

839: END;
840: END IF;
841:
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
844: END IF;
845: IF l_last_trx_date <> l_max_trx_date THEN
846: UPDATE ra_batch_sources
847: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)

Line 860: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others1');

856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: IF PG_DEBUG in ('Y', 'C') THEN
860: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others1');
861: END IF;
862: IF l_auto_trx_numbering_flag ='N' THEN
863: l_return_code := 1;
864: ELSE

Line 868: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others2');

864: ELSE
865: l_return_code := 0;
866: END IF;
867: IF PG_DEBUG in ('Y', 'C') THEN
868: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others2');
869: END IF;
870: IF l_return_code = 0 THEN
871: RETURN FALSE;
872: ELSE