589: SELECT global_attribute1,
590: global_attribute2
591: INTO x_enable_bank_coll,
592: x_enable_association
593: FROM ap_system_parameters;
594: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
595: l_log_msg := 'Value of x_enable_bank_coll ' || x_enable_bank_coll
596: || ' x_enable_association ' || x_enable_association;
597: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
683: association_method_e IN VARCHAR2,
684: bank_collection_id_s IN OUT NOCOPY NUMBER,
685: associate_flag_s IN OUT NOCOPY VARCHAR2 )
686: IS
687: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
688: x_enable_association ap_system_parameters.global_attribute2%TYPE;
689: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
690: -- Logging Infra:
691: l_procedure_name CONSTANT VARCHAR2(30) := 'jl_br_ap_associate_trade_note';
684: bank_collection_id_s IN OUT NOCOPY NUMBER,
685: associate_flag_s IN OUT NOCOPY VARCHAR2 )
686: IS
687: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
688: x_enable_association ap_system_parameters.global_attribute2%TYPE;
689: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
690: -- Logging Infra:
691: l_procedure_name CONSTANT VARCHAR2(30) := 'jl_br_ap_associate_trade_note';
692: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1240: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1241: END IF;
1242: SELECT global_attribute1
1243: INTO x_enable_bank_coll
1244: FROM ap_system_parameters;
1245: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1246: l_log_msg := 'Value of x_enable_bank_coll ' || x_enable_bank_coll;
1247: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1248: END IF;