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

Line 66: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

62: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
63:
64: BEGIN
65:
66: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
67: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
68: END IF;
69:
70: x_pending_product_lots_rec := p_pending_product_lots_rec;

Line 67: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

63:
64: BEGIN
65:
66: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
67: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
68: END IF;
69:
70: x_pending_product_lots_rec := p_pending_product_lots_rec;
71:

Line 113: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

109: ,x_pending_product_lots_rec.LAST_UPDATE_DATE
110: ,x_pending_product_lots_rec.LAST_UPDATED_BY
111: ,x_pending_product_lots_rec.LAST_UPDATE_LOGIN);
112:
113: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
114: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
115: END IF;
116:
117: IF SQL%FOUND THEN

Line 114: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

110: ,x_pending_product_lots_rec.LAST_UPDATED_BY
111: ,x_pending_product_lots_rec.LAST_UPDATE_LOGIN);
112:
113: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
114: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
115: END IF;
116:
117: IF SQL%FOUND THEN
118: RETURN TRUE;

Line 127: IF g_debug <= gme_debug.g_log_procedure THEN

123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
127: IF g_debug <= gme_debug.g_log_procedure THEN
128: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
129: END IF;
130:
131: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;

Line 128: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

124: EXCEPTION
125: WHEN OTHERS THEN
126: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
127: IF g_debug <= gme_debug.g_log_procedure THEN
128: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
129: END IF;
130:
131: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
132:

Line 171: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

167:
168: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
169: BEGIN
170:
171: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
172: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
173: END IF;
174:
175: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;

Line 172: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

168: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
169: BEGIN
170:
171: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
172: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
173: END IF;
174:
175: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;
176: l_matl_dtl_id := p_pending_product_lots_rec.material_detail_id;

Line 199: IF g_debug <= gme_debug.g_log_procedure THEN

195: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
196: RETURN FALSE;
197: END IF;
198:
199: IF g_debug <= gme_debug.g_log_procedure THEN
200: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
201: END IF;
202:
203: RETURN TRUE;

Line 200: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

196: RETURN FALSE;
197: END IF;
198:
199: IF g_debug <= gme_debug.g_log_procedure THEN
200: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
201: END IF;
202:
203: RETURN TRUE;
204:

Line 214: IF g_debug <= gme_debug.g_log_procedure THEN

210: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
211: RETURN FALSE;
212: WHEN OTHERS THEN
213: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
214: IF g_debug <= gme_debug.g_log_procedure THEN
215: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
216: END IF;
217:
218: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;

Line 215: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

211: RETURN FALSE;
212: WHEN OTHERS THEN
213: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
214: IF g_debug <= gme_debug.g_log_procedure THEN
215: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
216: END IF;
217:
218: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
219:

Line 260: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

256: l_sequ NUMBER;
257:
258: BEGIN
259:
260: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
261: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
262: END IF;
263:
264: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;

Line 261: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

257:
258: BEGIN
259:
260: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
261: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
262: END IF;
263:
264: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;
265: l_matl_dtl_id := p_pending_product_lots_rec.material_detail_id;

Line 314: IF g_debug <= gme_debug.g_log_procedure THEN

310: RETURN FALSE;
311: END IF;
312: END IF;
313:
314: IF g_debug <= gme_debug.g_log_procedure THEN
315: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
316: END IF;
317:
318: RETURN TRUE;

Line 315: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

311: END IF;
312: END IF;
313:
314: IF g_debug <= gme_debug.g_log_procedure THEN
315: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
316: END IF;
317:
318: RETURN TRUE;
319: EXCEPTION

Line 336: IF g_debug <= gme_debug.g_log_procedure THEN

332: ,p_pending_product_lots_rec.pending_product_lot_id);
333: RETURN FALSE;
334: WHEN OTHERS THEN
335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
336: IF g_debug <= gme_debug.g_log_procedure THEN
337: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
338: END IF;
339:
340: RETURN FALSE;

Line 337: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

333: RETURN FALSE;
334: WHEN OTHERS THEN
335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
336: IF g_debug <= gme_debug.g_log_procedure THEN
337: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
338: END IF;
339:
340: RETURN FALSE;
341: END delete_row;

Line 379: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

375: l_pp_lot_rec gme_pending_product_lots%ROWTYPE;
376:
377: BEGIN
378:
379: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
380: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
381: END IF;
382:
383: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;

Line 380: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

376:
377: BEGIN
378:
379: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
380: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
381: END IF;
382:
383: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;
384: l_matl_dtl_id := p_pending_product_lots_rec.material_detail_id;

Line 441: IF g_debug <= gme_debug.g_log_procedure THEN

437: ,g_table_name);
438: RETURN FALSE;
439: END IF;
440:
441: IF g_debug <= gme_debug.g_log_procedure THEN
442: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
443: END IF;
444:
445: IF SQL%ROWCOUNT <> 0 THEN

Line 442: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

438: RETURN FALSE;
439: END IF;
440:
441: IF g_debug <= gme_debug.g_log_procedure THEN
442: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
443: END IF;
444:
445: IF SQL%ROWCOUNT <> 0 THEN
446: RETURN TRUE;

Line 475: IF g_debug <= gme_debug.g_log_procedure THEN

471: ,p_pending_product_lots_rec.pending_product_lot_id);
472: RETURN FALSE;
473: WHEN OTHERS THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: IF g_debug <= gme_debug.g_log_procedure THEN
476: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
477: END IF;
478:
479: RETURN FALSE;

Line 476: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

472: RETURN FALSE;
473: WHEN OTHERS THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: IF g_debug <= gme_debug.g_log_procedure THEN
476: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
477: END IF;
478:
479: RETURN FALSE;
480: END update_row;

Line 517: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

513: l_sequ NUMBER;
514:
515: BEGIN
516:
517: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
518: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
519: END IF;
520:
521: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;

Line 518: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

514:
515: BEGIN
516:
517: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
518: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
519: END IF;
520:
521: l_pp_lot_id := p_pending_product_lots_rec.pending_product_lot_id;
522: l_matl_dtl_id := p_pending_product_lots_rec.material_detail_id;

Line 547: IF g_debug <= gme_debug.g_log_procedure THEN

543: ,g_table_name);
544: RETURN FALSE;
545: END IF;
546:
547: IF g_debug <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
549: END IF;
550:
551: RETURN TRUE;

Line 548: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

544: RETURN FALSE;
545: END IF;
546:
547: IF g_debug <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
549: END IF;
550:
551: RETURN TRUE;
552: EXCEPTION

Line 564: IF g_debug <= gme_debug.g_log_procedure THEN

560: ,p_pending_product_lots_rec.pending_product_lot_id);
561: RETURN FALSE;
562: WHEN OTHERS THEN
563: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
564: IF g_debug <= gme_debug.g_log_procedure THEN
565: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
566: END IF;
567:
568: RETURN FALSE;

Line 565: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

561: RETURN FALSE;
562: WHEN OTHERS THEN
563: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
564: IF g_debug <= gme_debug.g_log_procedure THEN
565: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
566: END IF;
567:
568: RETURN FALSE;
569: END lock_row;