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 27: arp_standard.debug('validate_trx_type: ' || '-- validate trx type ');

23:
24: BEGIN
25: l_return_code := 'SUCCESS';
26: IF PG_DEBUG in ('Y', 'C') THEN
27: arp_standard.debug('validate_trx_type: ' || '-- validate trx type ');
28: END IF;
29: BEGIN
30: SELECT 'Success'
31: INTO l_dummy_code

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

36: AND st.batch_source_id = src.batch_source_id
37: AND src.global_attribute3 = p_document_letter
38: AND st.enable_flag = 'Y';
39: IF PG_DEBUG in ('Y', 'C') THEN
40: arp_standard.debug('validate_trx_type: ' || '-- First validate trx type check');
41: END IF;
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF p_created_from = 'RAXTRX' THEN

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

83: AND substr(src.global_attribute2,1,4) <> l_branch_number
84: AND ty.enable_flag = 'Y';
85: --
86: IF PG_DEBUG in ('Y', 'C') THEN
87: arp_standard.debug('validate_trx_type: ' || '-- Second validate trx type check');
88: END IF;
89: IF l_count > 0 THEN
90: IF p_created_from = 'RAXTRX' THEN
91: l_return_code := 'ERROR';

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

543:
544: l_dummy_code := NULL;
545: BEGIN
546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
548: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
549: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
550: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
551: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);

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

544: l_dummy_code := NULL;
545: BEGIN
546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
548: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
549: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
550: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
551: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
552: END IF;

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

545: BEGIN
546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
548: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
549: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
550: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
551: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
552: END IF;
553: IF p_created_from = 'ARXTWMAI' THEN

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

546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
548: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
549: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
550: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
551: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
552: END IF;
553: IF p_created_from = 'ARXTWMAI' THEN
554: SELECT nvl(cas.global_attribute9,'N')

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

547: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter contributor class code ' || l_contributor_class_code);
548: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter ship to address id '|| to_char(p_ship_to_address_id));
549: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax category id '||to_char(doc_letter_rec.tax_category_id));
550: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att name '||doc_letter_rec.con_tax_attribute_name);
551: arp_standard.debug('validate_document_letter: ' || '-- validate doc letter tax att value '||doc_letter_rec.con_tax_attribute_value);
552: END IF;
553: IF p_created_from = 'ARXTWMAI' THEN
554: SELECT nvl(cas.global_attribute9,'N')
555: INTO l_cus_cls_flag

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

620: END;
621:
622: IF l_dummy_code = 'Success' AND l_match_flag = 'Y' THEN
623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_standard.debug('validate_document_letter: ' || '-- Successfully found a combination ');
625: END IF;
626: -- Assigned SUCCESS to l_return_code Bug 1323607
627: l_return_code := 'SUCCESS';
628: EXIT;

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

631: END LOOP;
632:
633: IF l_match_flag = 'N' THEN
634: IF PG_DEBUG in ('Y', 'C') THEN
635: arp_standard.debug('validate_document_letter: ' || '-- match flag is n');
636: END IF;
637: -- Added the following if condition Bug 1323607
638:
639: IF l_return_code IS NULL THEN -- Cursor contained no records

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

686: l_invoice_class VARCHAR2(20);
687:
688: BEGIN
689: IF PG_DEBUG in ('Y', 'C') THEN
690: arp_standard.debug('validate_interface_lines: ' || '-- JL_AR_DOC_NUMBERING_PKG validation begins');
691: END IF;
692:
693: l_return_code := 1;
694: IF PG_DEBUG in ('Y', 'C') THEN

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

691: END IF;
692:
693: l_return_code := 1;
694: IF PG_DEBUG in ('Y', 'C') THEN
695: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source id for the request');
696: END IF;
697: BEGIN
698: SELECT to_number(argument3)
699: INTO l_batch_source_id

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

699: INTO l_batch_source_id
700: FROM fnd_concurrent_requests
701: WHERE request_id = p_request_id;
702: IF PG_DEBUG in ('Y', 'C') THEN
703: arp_standard.debug('validate_interface_lines: ' || '-- the batch source id for the request is '||to_char(l_batch_source_id));
704: END IF;
705: END;
706:
707: IF PG_DEBUG in ('Y', 'C') THEN

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

704: END IF;
705: END;
706:
707: IF PG_DEBUG in ('Y', 'C') THEN
708: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the batch source gdf segments');
709: END IF;
710: BEGIN
711: SELECT auto_trx_numbering_flag
712: ,substr(global_attribute3,1,1)

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

719: FROM ra_batch_sources
720: WHERE batch_source_id = l_batch_source_id;
721: END;
722: IF PG_DEBUG in ('Y', 'C') THEN
723: arp_standard.debug('validate_interface_lines: ' || '-- the batch source gdf segments found');
724: END IF;
725:
726: IF l_auto_trx_numbering_flag ='N' THEN
727: IF PG_DEBUG in ('Y', 'C') THEN

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

724: END IF;
725:
726: IF l_auto_trx_numbering_flag ='N' THEN
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is N');
729: END IF;
730: l_return_code := 1;
731: RAISE error_condition;
732: END IF;

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

730: l_return_code := 1;
731: RAISE error_condition;
732: END IF;
733: IF PG_DEBUG in ('Y', 'C') THEN
734: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is Y');
735: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter begins');
736: END IF;
737:
738: IF validate_document_letter (l_batch_source_id

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

731: RAISE error_condition;
732: END IF;
733: IF PG_DEBUG in ('Y', 'C') THEN
734: arp_standard.debug('validate_interface_lines: ' || '-- auto trx numbering flag is Y');
735: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter begins');
736: END IF;
737:
738: IF validate_document_letter (l_batch_source_id
739: ,p_interface_line_id

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

741: ,p_orig_system_address_id
742: ,l_document_letter
743: ,p_so_org_id ) <> 'SUCCESS' THEN
744: IF PG_DEBUG in ('Y', 'C') THEN
745: arp_standard.debug('validate_interface_lines: ' || '-- validate document letter set up problem');
746: END IF;
747: l_return_code := 1;
748: END IF;
749:

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

747: l_return_code := 1;
748: END IF;
749:
750: IF PG_DEBUG in ('Y', 'C') THEN
751: arp_standard.debug('validate_interface_lines: ' || '-- trying to get the type for the trx type');
752: END IF;
753: BEGIN
754: SELECT type
755: INTO l_invoice_class

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

755: INTO l_invoice_class
756: FROM ra_cust_trx_types
757: WHERE cust_trx_type_id = p_trx_type;
758: IF PG_DEBUG in ('Y', 'C') THEN
759: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
760: END IF;
761: END;
762: IF PG_DEBUG in ('Y', 'C') THEN
763: arp_standard.debug('validate_interface_lines: ' || '-- validate trx type begins');

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

759: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
760: END IF;
761: END;
762: IF PG_DEBUG in ('Y', 'C') THEN
763: arp_standard.debug('validate_interface_lines: ' || '-- validate trx type begins');
764: END IF;
765:
766: IF validate_trx_type (l_batch_source_id
767: ,p_trx_type

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

769: ,l_document_letter
770: ,p_interface_line_id
771: ,'RAXTRX' ) <> 'SUCCESS' THEN
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('validate_interface_lines: ' || '-- validate trx types and sources are not set');
774: END IF;
775: l_return_code := 1;
776: END IF;
777:

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

775: l_return_code := 1;
776: END IF;
777:
778: IF PG_DEBUG in ('Y', 'C') THEN
779: arp_standard.debug('validate_interface_lines: ' || '-- validate branch number begins');
780: END IF;
781: IF validate_four_digit (l_batch_source_id
782: ,p_interface_line_id
783: ,'RAXTRX'

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

784: ,p_inventory_item_id
785: ,p_memo_line_id
786: ,p_so_org_id ) <> 'SUCCESS' THEN
787: IF PG_DEBUG in ('Y', 'C') THEN
788: arp_standard.debug('validate_interface_lines: ' || '-- branch number validation problem');
789: END IF;
790: l_return_code := 1;
791: END IF;
792:

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

790: l_return_code := 1;
791: END IF;
792:
793: IF PG_DEBUG in ('Y', 'C') THEN
794: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date begins');
795: END IF;
796: IF p_trx_date BETWEEN
797: l_last_trx_date AND (sysdate+l_advance_days) THEN
798: IF p_trx_date <> l_last_trx_date THEN

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

798: IF p_trx_date <> l_last_trx_date THEN
799: l_max_trx_date := p_trx_date;
800: END IF;
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_standard.debug('validate_interface_lines: ' || '-- validate trx date ok');
803: END IF;
804: ELSE
805: BEGIN
806: IF PG_DEBUG in ('Y', 'C') THEN

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

803: END IF;
804: ELSE
805: BEGIN
806: IF PG_DEBUG in ('Y', 'C') THEN
807: arp_standard.debug('validate_interface_lines: ' || '-- date validation problem');
808: END IF;
809: l_return_code := 1;
810: IF p_trx_date < l_last_trx_date THEN
811: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

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

825: END;
826: END IF;
827:
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
830: END IF;
831: IF l_last_trx_date <> l_max_trx_date THEN
832: UPDATE ra_batch_sources
833: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)

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

842:
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF PG_DEBUG in ('Y', 'C') THEN
846: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others1');
847: END IF;
848: IF l_auto_trx_numbering_flag ='N' THEN
849: l_return_code := 1;
850: ELSE

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

850: ELSE
851: l_return_code := 0;
852: END IF;
853: IF PG_DEBUG in ('Y', 'C') THEN
854: arp_standard.debug('validate_interface_lines: ' || '-- validate interface lines problem - in others2');
855: END IF;
856: IF l_return_code = 0 THEN
857: RETURN FALSE;
858: ELSE