[Home] [Help]
582: --Bugfix:4681253
583: /*select decode(nvl(fpov1.profile_option_value,'N'),
584: 'N', lc.displayed_field)
585: INTO l_batch_name
586: FROM fnd_profile_option_values fpov1,
587: fnd_profile_options fpo1,
588: ap_lookup_codes lc
589: WHERE fpov1.profile_option_id = fpo1.profile_option_id
590: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'
583: /*select decode(nvl(fpov1.profile_option_value,'N'),
584: 'N', lc.displayed_field)
585: INTO l_batch_name
586: FROM fnd_profile_option_values fpov1,
587: fnd_profile_options fpo1,
588: ap_lookup_codes lc
589: WHERE fpov1.profile_option_id = fpo1.profile_option_id
590: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'
591: AND fpov1.level_id = 10004
594: AND rownum = 1;*/
595: --End of commenting code for bug#6926296
596:
597: --Added the below code for bug#6926296
598: l_use_batch_controls := fnd_profile.value('AP_USE_INV_BATCH_CONTROLS');
599: if nvl(l_use_batch_controls,'N') = 'N' then
600: select lc.displayed_field
601: into l_batch_name
602: from ap_lookup_codes lc
5746: AP_IMPORT_UTILITIES_PKG.Print(
5747: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
5748: END IF;
5749: -------------------------------------------
5750: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
5751: IF (l_seq_num_profile IN ('A','P')) THEN
5752:
5753: l_doc_category_code := 'PO ADJ INV';
5754:
7025: END IF;
7026: RAISE Import_Retro_Adj_failure;
7027: END IF;
7028: --
7029: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
7030: IF ((l_orig_invoices_valid = 'N') and (l_seq_num_profile = 'A')) THEN
7031: --Insert rejections
7032: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
7033: ('AP_INVOICES_INTERFACE',