eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 167: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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