DBA Data[Home] [Help]

APPS.GMF_BATCH_VALIDATIONS dependencies on GME_DEBUG

Line 93: IF g_debug <= gme_debug.g_log_statement THEN

89: -- Changed cursor NOTFOUND check to dates being NULL.
90:
91: IF ((l_min_date IS NULL) OR (l_max_date IS NULL)) THEN
92: CLOSE Min_max_trans_date;
93: IF g_debug <= gme_debug.g_log_statement THEN
94: gme_debug.put_line ( g_pkg_name
95: || '.'
96: || l_api_name
97: || ':'

Line 94: gme_debug.put_line ( g_pkg_name

90:
91: IF ((l_min_date IS NULL) OR (l_max_date IS NULL)) THEN
92: CLOSE Min_max_trans_date;
93: IF g_debug <= gme_debug.g_log_statement THEN
94: gme_debug.put_line ( g_pkg_name
95: || '.'
96: || l_api_name
97: || ':'
98: || 'No transactions exist for the batch');

Line 108: gme_debug.put_line ( g_pkg_name

104: OPEN Get_period_id(l_min_date);
105: FETCH Get_period_id INTO l_min_period_id;
106: IF (Get_period_id%NOTFOUND) THEN
107: CLOSE Get_period_id;
108: gme_debug.put_line ( g_pkg_name
109: || '.'
110: || l_api_name
111: || ':'
112: || 'Period not found for Min date '

Line 130: gme_debug.put_line ( g_pkg_name

126: OPEN Get_period_id(l_max_date);
127: FETCH Get_period_id INTO l_max_period_id;
128: IF (Get_period_id%NOTFOUND) THEN
129: CLOSE Get_period_id;
130: gme_debug.put_line ( g_pkg_name
131: || '.'
132: || l_api_name
133: || ':'
134: || 'Period not found for Max date '

Line 148: IF g_debug <= gme_debug.g_log_statement THEN

144: RETURN FALSE;
145: END IF;
146: CLOSE Get_period_id;
147:
148: IF g_debug <= gme_debug.g_log_statement THEN
149: gme_debug.put_line ( g_pkg_name
150: || '.'
151: || l_api_name
152: || ':'

Line 149: gme_debug.put_line ( g_pkg_name

145: END IF;
146: CLOSE Get_period_id;
147:
148: IF g_debug <= gme_debug.g_log_statement THEN
149: gme_debug.put_line ( g_pkg_name
150: || '.'
151: || l_api_name
152: || ':'
153: || 'l_min_period_id ' ||l_min_period_id

Line 176: gme_debug.put_line ( g_pkg_name

172: WHEN OTHERS
173: THEN
174: err_num := SQLCODE;
175: err_msg := SUBSTRB(SQLERRM, 1, 100);
176: gme_debug.put_line ( g_pkg_name
177: || '.'
178: || l_api_name
179: || ':'
180: || 'Exception Error '||err_num