[Home] [Help]
1: PACKAGE BODY GMF_BATCH_VALIDATIONS AS
2: /* $Header: GMFBCHVB.pls 120.5 2011/09/28 15:40:28 pvkanetk noship $ */
3: --****************************************************************************************************
4: --* *
5: --* Oracle Process Manufacturing *
4: --* *
5: --* Oracle Process Manufacturing *
6: --* ============================ *
7: --* *
8: --* Package Body GMF_BATCH_VALIDATIONS *
9: --* --------------------------- *
10: --* Description: This package body contains validations called from Process Execution *
11: --* *
12: --* Author: OPM Development *
17: --* *
18: --* Function check_cancel_batch Checks if a batch can be canceled. *
19: --* Returns BOOLEAN TRUE if batch can be canceled. *
20: --* FALSE if batch can not be canceled and should be closed *
21: --* Process Execution will call GMF_BATCH_VALIDATIONS.check_cancel_batch when attempting to *
22: --* cancel a batch. If this returns TRUE a batch would be canceled. If return is FALSE then *
23: --* Process execution will require the batch to be CLOSED and NOT CANCELED. All activity will be *
24: --* zeroed out when this code is called. *
25: --* Process Execution bug for related changes Bug 12418545. *
74: l_max_date DATE;
75: l_min_period_id NUMBER;
76: l_max_period_id NUMBER;
77: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
78: g_pkg_name VARCHAR2(32) := 'GMF_BATCH_VALIDATIONS';
79: l_api_name VARCHAR2(32) := 'check_cancel_batch';
80: err_num NUMBER;
81: err_msg VARCHAR2(100);
82:
112: || 'Period not found for Min date '
113: || to_char(l_min_date,'MM/DD/RRRR HH24:MI:SS'));
114:
115: GMF_LAYERS.log_message (
116: p_table_name => 'GMF_BATCH_VALIDATIONS',
117: p_procedure_name => 'check_cancel_batch',
118: p_parameters => p_batch_id,
119: p_message => 'Costing period Not found for Earliest Transaction Date '||to_char(l_min_date,'MM/DD/RRRR HH24:MI:SS'),
120: p_error_type => 'E');
134: || 'Period not found for Max date '
135: || to_char(l_max_date,'MM/DD/RRRR HH24:MI:SS'));
136:
137: GMF_LAYERS.log_message (
138: p_table_name => 'GMF_BATCH_VALIDATIONS',
139: p_procedure_name => 'check_cancel_batch',
140: p_parameters => p_batch_id,
141: p_message => 'Costing period Not found for Latest Transaction Date '||to_char(l_max_date,'MM/DD/RRRR HH24:MI:SS'),
142: p_error_type => 'E');
156:
157: IF l_min_period_id <> l_max_period_id THEN
158:
159: GMF_LAYERS.log_message (
160: p_table_name => 'GMF_BATCH_VALIDATIONS',
161: p_procedure_name => 'check_cancel_batch',
162: p_parameters => p_batch_id,
163: p_message => 'Transactions span costing periods. WIP Account may not be cleared out for this batch if it is Canceled.',
164: p_error_type => 'E');
181: || ' Error Message '||err_msg );
182: RETURN FALSE;
183:
184: END check_cancel_batch;
185: END GMF_BATCH_VALIDATIONS;