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.JG_ZZ_AR_AUTO_INVOICE dependencies on JL_ZZ_AR_LIBRARY_1_PKG

Line 260: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);

256:
257: IF trx_number.count > 0 AND l_auto_trx_num_flag = 'Y' THEN
258: FOR i IN customer_trx_id.FIRST .. customer_trx_id.LAST LOOP
259: l_debug_loc := 'Getting Next Sequence number';
260: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
261: IF l_err_code = 0 THEN
262: l_trx_number := l_document_letter || '-' || l_branch_number || '-'
263: || lpad(l_seq_number,8,'0');
264: trx_number(i) := l_trx_number;

Line 367: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);

363: If trx_number.count > 0 AND l_auto_trx_num_flag = 'Y' AND NVL(l_copy_doc_number_flag,'N') = 'N' THEN
364:
365: FOR i IN customer_trx_id.FIRST .. customer_trx_id.LAST LOOP
366: l_debug_loc := 'Getting Next Sequence number';
367: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
368: IF l_err_code = 0 THEN
369: trx_number(i) := l_seq_number;
370: END IF;
371: END LOOP;

Line 640: l_debug_loc := 'Calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';

636: l_debug_loc := 'BATCH_SOURCE_TYPE'||l_BATCH_SOURCE_TYPE;
637:
638: If l_batch_source_type = 'INV' THEN-- Manual Source
639: -- Get the Imported batch Source Id
640: l_debug_loc := 'Calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';
641: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );
642: l_debug_loc := 'New Batch ID'||l_batch_source_id;
643: l_debug_loc := 'Error Code'|| l_err_code1;
644: If l_err_code1 = 0 Then -- If no errors proceed

Line 641: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );

637:
638: If l_batch_source_type = 'INV' THEN-- Manual Source
639: -- Get the Imported batch Source Id
640: l_debug_loc := 'Calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';
641: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );
642: l_debug_loc := 'New Batch ID'||l_batch_source_id;
643: l_debug_loc := 'Error Code'|| l_err_code1;
644: If l_err_code1 = 0 Then -- If no errors proceed
645: If l_batch_source_id Is Not Null Then

Line 665: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);

661: Close C_BR_Batch_Details;
662: End If;
663: If l_auto_trx_num_flag = 'Y' AND NVL(l_copy_doc_number_flag,'N') = 'N' Then -- Automatic Numbering
664: l_debug_loc := 'Getting Next Sequence number';
665: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
666: If l_err_code = 0 Then
667: Update ra_customer_trx_all
668: Set trx_number = l_seq_number
669: Where customer_trx_id = p_trx_id;

Line 694: l_debug_loc := 'Manual Batch Source, calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';

690:
691: If l_batch_source_type = 'INV' THEN-- Manual Source
692:
693: -- Get the Imported batch Source Id
694: l_debug_loc := 'Manual Batch Source, calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';
695: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );
696: l_debug_loc := 'New Batch ID'||l_batch_source_id;
697: l_debug_loc := 'Error Code'|| l_err_code1;
698:

Line 695: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );

691: If l_batch_source_type = 'INV' THEN-- Manual Source
692:
693: -- Get the Imported batch Source Id
694: l_debug_loc := 'Manual Batch Source, calling JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id';
695: JL_ZZ_AR_LIBRARY_1_PKG.get_batch_id ( f_batch_source_id, l_batch_source_id, 1, l_err_code1 );
696: l_debug_loc := 'New Batch ID'||l_batch_source_id;
697: l_debug_loc := 'Error Code'|| l_err_code1;
698:
699: If l_err_code1 = 0 Then -- If no errors proceed

Line 743: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);

739: End If;
740: If l_auto_trx_num_flag = 'Y' Then -- Automatic Numbering
741:
742: l_debug_loc := 'Getting Next Sequence number';
743: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
744: If l_err_code = 0 THEN
745: l_debug_loc := 'Generating the new AR Transaction Number';
746: l_trx_number := l_document_letter || '-' || l_branch_number || '-' || lpad(l_seq_number,8,'0');
747: Update ra_customer_trx_all