DBA Data[Home] [Help]

APPS.GME_REVERT_BATCH_PVT dependencies on GME_DEBUG

Line 67: IF (g_debug <= gme_debug.g_log_statement) THEN

63: BEGIN
64: /* Set the return status to success initially */
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: IF (g_debug <= gme_debug.g_log_statement) THEN
68: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
69: || 'Entering');
70: END IF;
71:

Line 68: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

64: /* Set the return status to success initially */
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: IF (g_debug <= gme_debug.g_log_statement) THEN
68: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
69: || 'Entering');
70: END IF;
71:
72: l_batch_header_rec := p_batch_header_rec;

Line 88: IF (g_debug <= gme_debug.g_log_statement) THEN

84: l_batch_header_rec.batch_status := 2;
85: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
86: /* Fetch all the material lines associated with the batch */
87: FOR i IN 1..l_material_details_tab.COUNT LOOP
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
90: || 'material line count'||l_material_details_tab.COUNT );
91: END IF;
92: /* We should not revert the phantom product, so added the check below to see */

Line 89: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

85: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
86: /* Fetch all the material lines associated with the batch */
87: FOR i IN 1..l_material_details_tab.COUNT LOOP
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
90: || 'material line count'||l_material_details_tab.COUNT );
91: END IF;
92: /* We should not revert the phantom product, so added the check below to see */
93: /* if the current line being process is a phantom product, if it is not a phantom */

Line 104: IF (g_debug <= gme_debug.g_log_statement) THEN

100: AND l_material_details_tab(i).phantom_line_id IS NULL
101: AND (gme_common_pvt.is_material_auto_release
102: (l_material_details_tab(i).material_detail_id) = 0 )
103: )) THEN
104: IF (g_debug <= gme_debug.g_log_statement) THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
106: || ' calling revert line for:'||l_material_details_tab(i).material_detail_id );
107: END IF;
108: revert_line

Line 105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

101: AND (gme_common_pvt.is_material_auto_release
102: (l_material_details_tab(i).material_detail_id) = 0 )
103: )) THEN
104: IF (g_debug <= gme_debug.g_log_statement) THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
106: || ' calling revert line for:'||l_material_details_tab(i).material_detail_id );
107: END IF;
108: revert_line
109: (p_batch_header_rec => l_batch_header_rec

Line 113: IF (g_debug <= gme_debug.g_log_statement) THEN

109: (p_batch_header_rec => l_batch_header_rec
110: ,p_material_details_rec => l_material_details_tab(i)
111: ,p_batch_step_rec => NULL
112: ,x_return_status => l_return_status) ;
113: IF (g_debug <= gme_debug.g_log_statement) THEN
114: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
115: || 'return status from revert line:'||l_return_status);
116: END IF;
117: IF l_return_status <> x_return_status THEN

Line 114: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

110: ,p_material_details_rec => l_material_details_tab(i)
111: ,p_batch_step_rec => NULL
112: ,x_return_status => l_return_status) ;
113: IF (g_debug <= gme_debug.g_log_statement) THEN
114: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
115: || 'return status from revert line:'||l_return_status);
116: END IF;
117: IF l_return_status <> x_return_status THEN
118: RAISE REVERT_LINE_FAIL;

Line 168: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

164: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));
165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167:
168: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
169: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
170: END IF;
171:
172: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 169: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);

165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167:
168: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
169: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
170: END IF;
171:
172: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
173: END revert_batch;

Line 237: IF (g_debug <= gme_debug.g_log_statement) THEN

233: BEGIN
234:
235: /* Inititialize the return status to success */
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: IF (g_debug <= gme_debug.g_log_statement) THEN
238: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
239: || 'Entering');
240: END IF;
241:

Line 238: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

234:
235: /* Inititialize the return status to success */
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: IF (g_debug <= gme_debug.g_log_statement) THEN
238: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
239: || 'Entering');
240: END IF;
241:
242: IF p_material_details_rec.line_type = -1 THEN

Line 249: IF (g_debug <= gme_debug.g_log_statement) THEN

245: IF NOT (GME_BATCH_HEADER_DBL.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec)) THEN
246: RAISE BATCH_HEADER_FETCH_ERROR;
247: END IF;
248: -- revert_batch for phantom batch
249: IF (g_debug <= gme_debug.g_log_statement) THEN
250: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
251: || 'calling for phantom:'||l_ph_batch_header_rec.batch_id );
252: END IF;
253: revert_batch

Line 250: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

246: RAISE BATCH_HEADER_FETCH_ERROR;
247: END IF;
248: -- revert_batch for phantom batch
249: IF (g_debug <= gme_debug.g_log_statement) THEN
250: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
251: || 'calling for phantom:'||l_ph_batch_header_rec.batch_id );
252: END IF;
253: revert_batch
254: ( p_batch_header_rec => l_ph_batch_header_rec

Line 264: IF (g_debug <= gme_debug.g_log_statement) THEN

260: ELSE
261: l_batch_header_rec := p_batch_header_rec ;
262: l_material_details_rec := p_material_details_rec ;
263: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
264: IF (g_debug <= gme_debug.g_log_statement) THEN
265: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
266: || 'calling revert mat:'||p_material_details_rec.material_detail_id);
267: END IF;
268: /* Bug 5001915 get values for item control and added if condition before calling revert mtl */

Line 265: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

261: l_batch_header_rec := p_batch_header_rec ;
262: l_material_details_rec := p_material_details_rec ;
263: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
264: IF (g_debug <= gme_debug.g_log_statement) THEN
265: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
266: || 'calling revert mat:'||p_material_details_rec.material_detail_id);
267: END IF;
268: /* Bug 5001915 get values for item control and added if condition before calling revert mtl */
269: OPEN Cur_get_item(p_material_details_rec.organization_id, p_material_details_rec.inventory_item_id);

Line 336: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

332: x_return_status := l_return_status;
333: WHEN OTHERS THEN
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335:
336: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
337: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 337: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);

333: WHEN OTHERS THEN
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335:
336: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
337: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
341: END revert_line;