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_STEP_PVT dependencies on GME_DEBUG

Line 79: IF g_debug <= gme_debug.g_log_procedure THEN

75: l_dep_step_rec Cur_dep_steps%ROWTYPE;
76: BEGIN
77: /* Set the return status to success initially */
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: IF g_debug <= gme_debug.g_log_procedure THEN
80: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
81: || 'Entering');
82: END IF;
83:

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

76: BEGIN
77: /* Set the return status to success initially */
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: IF g_debug <= gme_debug.g_log_procedure THEN
80: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
81: || 'Entering');
82: END IF;
83:
84: l_batch_step_rec := p_batch_step_rec ;

Line 86: IF g_debug <= gme_debug.g_log_procedure THEN

82: END IF;
83:
84: l_batch_step_rec := p_batch_step_rec ;
85: l_batch_header_rec := p_batch_header_rec;
86: IF g_debug <= gme_debug.g_log_procedure THEN
87: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
88: || 'batchstep_id'||l_batch_step_rec.batchstep_id);
89: END IF;
90: /* The Batch must be in WIP to revert a Batch Step. */

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

83:
84: l_batch_step_rec := p_batch_step_rec ;
85: l_batch_header_rec := p_batch_header_rec;
86: IF g_debug <= gme_debug.g_log_procedure THEN
87: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
88: || 'batchstep_id'||l_batch_step_rec.batchstep_id);
89: END IF;
90: /* The Batch must be in WIP to revert a Batch Step. */
91: IF (l_batch_header_rec.batch_status <> 2) THEN

Line 92: IF ( g_debug <= gme_debug.g_log_procedure) THEN

88: || 'batchstep_id'||l_batch_step_rec.batchstep_id);
89: END IF;
90: /* The Batch must be in WIP to revert a Batch Step. */
91: IF (l_batch_header_rec.batch_status <> 2) THEN
92: IF ( g_debug <= gme_debug.g_log_procedure) THEN
93: gme_debug.put_line ('batch status'|| l_batch_header_rec.batch_status);
94: END IF;
95: RAISE invalid_batch_status;
96: END IF;

Line 93: gme_debug.put_line ('batch status'|| l_batch_header_rec.batch_status);

89: END IF;
90: /* The Batch must be in WIP to revert a Batch Step. */
91: IF (l_batch_header_rec.batch_status <> 2) THEN
92: IF ( g_debug <= gme_debug.g_log_procedure) THEN
93: gme_debug.put_line ('batch status'|| l_batch_header_rec.batch_status);
94: END IF;
95: RAISE invalid_batch_status;
96: END IF;
97:

Line 123: IF ( g_debug <= gme_debug.g_log_procedure ) THEN

119: /* If the batch is certified and the batch is not a phantom */
120: IF (l_batch_header_rec.batch_status = 3) AND
121: (l_batch_header_rec.parentline_id IS NULL) THEN
122: /* Call the revert batch API */
123: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
124: gme_debug.put_line ('revert batch'||GME_common_pvt.g_step_controls_batch_sts_ind);
125: END IF;
126: l_in_batch_header_rec := l_batch_header_rec;
127: gme_revert_batch_pvt.revert_batch

Line 124: gme_debug.put_line ('revert batch'||GME_common_pvt.g_step_controls_batch_sts_ind);

120: IF (l_batch_header_rec.batch_status = 3) AND
121: (l_batch_header_rec.parentline_id IS NULL) THEN
122: /* Call the revert batch API */
123: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
124: gme_debug.put_line ('revert batch'||GME_common_pvt.g_step_controls_batch_sts_ind);
125: END IF;
126: l_in_batch_header_rec := l_batch_header_rec;
127: gme_revert_batch_pvt.revert_batch
128: (p_batch_header_rec => l_in_batch_header_rec

Line 149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN

145: -- Update the batch step to the database
146: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN
147: RAISE batch_step_upd_err;
148: END IF;
149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);
151: gme_debug.put_line ('batch_id'||l_batch_step_rec.batch_id);
152: gme_debug.put_line ('batchstep_id'||l_batch_step_rec.batchstep_id);
153:

Line 150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);

146: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN
147: RAISE batch_step_upd_err;
148: END IF;
149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);
151: gme_debug.put_line ('batch_id'||l_batch_step_rec.batch_id);
152: gme_debug.put_line ('batchstep_id'||l_batch_step_rec.batchstep_id);
153:
154: END IF;

Line 151: gme_debug.put_line ('batch_id'||l_batch_step_rec.batch_id);

147: RAISE batch_step_upd_err;
148: END IF;
149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);
151: gme_debug.put_line ('batch_id'||l_batch_step_rec.batch_id);
152: gme_debug.put_line ('batchstep_id'||l_batch_step_rec.batchstep_id);
153:
154: END IF;
155: OPEN Cur_lock_step_materials(l_batch_step_rec.batchstep_id,l_batch_step_rec.batch_id);

Line 152: gme_debug.put_line ('batchstep_id'||l_batch_step_rec.batchstep_id);

148: END IF;
149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);
151: gme_debug.put_line ('batch_id'||l_batch_step_rec.batch_id);
152: gme_debug.put_line ('batchstep_id'||l_batch_step_rec.batchstep_id);
153:
154: END IF;
155: OPEN Cur_lock_step_materials(l_batch_step_rec.batchstep_id,l_batch_step_rec.batch_id);
156: FETCH Cur_lock_step_materials BULK COLLECT INTO l_material_details_tab;

Line 162: IF ( g_debug <= gme_debug.g_log_procedure) THEN

158: CLOSE Cur_lock_step_materials;
159: RAISE BATCH_LINES_LOCKED;
160: END IF;
161: CLOSE Cur_lock_step_materials;
162: IF ( g_debug <= gme_debug.g_log_procedure) THEN
163: gme_debug.put_line ('l_material_details_tab count'||l_material_details_tab.count);
164: END IF;
165: FOR i IN 1..l_material_details_tab.COUNT LOOP
166: IF ((l_material_details_tab(i).line_type = -1 AND l_material_details_tab(i).phantom_id IS NOT NULL) OR

Line 163: gme_debug.put_line ('l_material_details_tab count'||l_material_details_tab.count);

159: RAISE BATCH_LINES_LOCKED;
160: END IF;
161: CLOSE Cur_lock_step_materials;
162: IF ( g_debug <= gme_debug.g_log_procedure) THEN
163: gme_debug.put_line ('l_material_details_tab count'||l_material_details_tab.count);
164: END IF;
165: FOR i IN 1..l_material_details_tab.COUNT LOOP
166: IF ((l_material_details_tab(i).line_type = -1 AND l_material_details_tab(i).phantom_id IS NOT NULL) OR
167: (l_material_details_tab(i).line_type <> -1 AND l_material_details_tab(i).phantom_line_id IS NULL)) THEN

Line 168: IF ( g_debug <= gme_debug.g_log_procedure ) THEN

164: END IF;
165: FOR i IN 1..l_material_details_tab.COUNT LOOP
166: IF ((l_material_details_tab(i).line_type = -1 AND l_material_details_tab(i).phantom_id IS NOT NULL) OR
167: (l_material_details_tab(i).line_type <> -1 AND l_material_details_tab(i).phantom_line_id IS NULL)) THEN
168: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
169: gme_debug.put_line ('calling revert for material line '
170: ||l_material_details_tab(i).material_detail_id);
171: gme_debug.put_line ('batch update inventory '
172: ||l_batch_header_rec.update_inventory_ind);

Line 169: gme_debug.put_line ('calling revert for material line '

165: FOR i IN 1..l_material_details_tab.COUNT LOOP
166: IF ((l_material_details_tab(i).line_type = -1 AND l_material_details_tab(i).phantom_id IS NOT NULL) OR
167: (l_material_details_tab(i).line_type <> -1 AND l_material_details_tab(i).phantom_line_id IS NULL)) THEN
168: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
169: gme_debug.put_line ('calling revert for material line '
170: ||l_material_details_tab(i).material_detail_id);
171: gme_debug.put_line ('batch update inventory '
172: ||l_batch_header_rec.update_inventory_ind);
173: END IF;

Line 171: gme_debug.put_line ('batch update inventory '

167: (l_material_details_tab(i).line_type <> -1 AND l_material_details_tab(i).phantom_line_id IS NULL)) THEN
168: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
169: gme_debug.put_line ('calling revert for material line '
170: ||l_material_details_tab(i).material_detail_id);
171: gme_debug.put_line ('batch update inventory '
172: ||l_batch_header_rec.update_inventory_ind);
173: END IF;
174:
175: gme_revert_batch_pvt.revert_line

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

220: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');
221: WHEN OTHERS THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
225: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
226: END IF;
227: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
228: END revert_step;

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

221: WHEN OTHERS THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
225: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
226: END IF;
227: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
228: END revert_step;
229: