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_LAB_BATCH_LOTS_DBL dependencies on GME_COMMON_PVT

Line 113: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

109: ,x_lab_batch_lots.material_detail_id
110: ,x_lab_batch_lots.item_id, x_lab_batch_lots.lot_id
111: ,x_lab_batch_lots.qty, x_lab_batch_lots.qty2
112: ,x_lab_batch_lots.uom, x_lab_batch_lots.uom2
113: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
114: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
115: ,gme_common_pvt.g_login_id, x_lab_batch_lots.attribute1
116: ,x_lab_batch_lots.attribute2, x_lab_batch_lots.attribute3
117: ,x_lab_batch_lots.attribute4, x_lab_batch_lots.attribute5

Line 114: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

110: ,x_lab_batch_lots.item_id, x_lab_batch_lots.lot_id
111: ,x_lab_batch_lots.qty, x_lab_batch_lots.qty2
112: ,x_lab_batch_lots.uom, x_lab_batch_lots.uom2
113: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
114: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
115: ,gme_common_pvt.g_login_id, x_lab_batch_lots.attribute1
116: ,x_lab_batch_lots.attribute2, x_lab_batch_lots.attribute3
117: ,x_lab_batch_lots.attribute4, x_lab_batch_lots.attribute5
118: ,x_lab_batch_lots.attribute6, x_lab_batch_lots.attribute7

Line 115: ,gme_common_pvt.g_login_id, x_lab_batch_lots.attribute1

111: ,x_lab_batch_lots.qty, x_lab_batch_lots.qty2
112: ,x_lab_batch_lots.uom, x_lab_batch_lots.uom2
113: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
114: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
115: ,gme_common_pvt.g_login_id, x_lab_batch_lots.attribute1
116: ,x_lab_batch_lots.attribute2, x_lab_batch_lots.attribute3
117: ,x_lab_batch_lots.attribute4, x_lab_batch_lots.attribute5
118: ,x_lab_batch_lots.attribute6, x_lab_batch_lots.attribute7
119: ,x_lab_batch_lots.attribute8, x_lab_batch_lots.attribute9

Line 146: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

142:
143: RETURN TRUE;
144: EXCEPTION
145: WHEN OTHERS THEN
146: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
147: ,SQLERRM);
148: RETURN FALSE;
149: END insert_row;
150:

Line 247: gme_common_pvt.log_message ('GME_NO_KEYS'

243: AND material_detail_id = p_lab_batch_lots.material_detail_id
244: AND item_id = p_lab_batch_lots.item_id
245: AND lot_id = p_lab_batch_lots.lot_id;
246: ELSE
247: gme_common_pvt.log_message ('GME_NO_KEYS'
248: ,'TABLE_NAME'
249: ,g_table_name);
250: RETURN FALSE;
251: END IF;

Line 256: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

252:
253: RETURN TRUE;
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN
256: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
257: ,'TABLE_NAME'
258: ,g_table_name);
259: RETURN FALSE;
260: WHEN OTHERS THEN

Line 261: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

257: ,'TABLE_NAME'
258: ,g_table_name);
259: RETURN FALSE;
260: WHEN OTHERS THEN
261: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
262: ,SQLERRM);
263: RETURN FALSE;
264: END fetch_row;
265:

Line 322: gme_common_pvt.log_message ('GME_NO_KEYS'

318: AND material_detail_id = p_lab_batch_lots.material_detail_id
319: AND item_id = p_lab_batch_lots.item_id
320: AND lot_id = p_lab_batch_lots.lot_id;
321: ELSE
322: gme_common_pvt.log_message ('GME_NO_KEYS'
323: ,'TABLE_NAME'
324: ,g_table_name);
325: RETURN FALSE;
326: END IF;

Line 332: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

328: IF SQL%FOUND THEN
329: RETURN TRUE;
330: ELSE
331: IF l_dummy = 0 THEN
332: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
333: ,'TABLE_NAME'
334: ,g_table_name);
335: ELSE
336: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 336: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

332: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
333: ,'TABLE_NAME'
334: ,g_table_name);
335: ELSE
336: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
337: ,'TABLE_NAME'
338: ,g_table_name);
339: END IF;
340:

Line 346: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

342: END IF;
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: IF l_dummy = 0 THEN
346: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
347: ,'TABLE_NAME'
348: ,g_table_name);
349: ELSE
350: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 350: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

346: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
347: ,'TABLE_NAME'
348: ,g_table_name);
349: ELSE
350: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
351: ,'TABLE_NAME'
352: ,g_table_name);
353: END IF;
354:

Line 357: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

353: END IF;
354:
355: RETURN FALSE;
356: WHEN locked_by_other_user THEN
357: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
358: ,'TABLE_NAME'
359: ,g_table_name
360: ,'RECORD'
361: ,'Batch'

Line 366: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

362: ,'KEY'
363: ,TO_CHAR (p_lab_batch_lots.batch_id) );
364: RETURN FALSE;
365: WHEN OTHERS THEN
366: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
367: ,SQLERRM);
368: RETURN FALSE;
369: END delete_row;
370:

Line 425: ,last_update_date = gme_common_pvt.g_timestamp

421: SET qty = p_lab_batch_lots.qty
422: ,qty2 = p_lab_batch_lots.qty2
423: ,uom = p_lab_batch_lots.uom
424: ,uom2 = p_lab_batch_lots.uom2
425: ,last_update_date = gme_common_pvt.g_timestamp
426: ,last_updated_by = gme_common_pvt.g_user_ident
427: ,last_update_login = gme_common_pvt.g_login_id
428: ,attribute1 = p_lab_batch_lots.attribute1
429: ,attribute2 = p_lab_batch_lots.attribute2

Line 426: ,last_updated_by = gme_common_pvt.g_user_ident

422: ,qty2 = p_lab_batch_lots.qty2
423: ,uom = p_lab_batch_lots.uom
424: ,uom2 = p_lab_batch_lots.uom2
425: ,last_update_date = gme_common_pvt.g_timestamp
426: ,last_updated_by = gme_common_pvt.g_user_ident
427: ,last_update_login = gme_common_pvt.g_login_id
428: ,attribute1 = p_lab_batch_lots.attribute1
429: ,attribute2 = p_lab_batch_lots.attribute2
430: ,attribute3 = p_lab_batch_lots.attribute3

Line 427: ,last_update_login = gme_common_pvt.g_login_id

423: ,uom = p_lab_batch_lots.uom
424: ,uom2 = p_lab_batch_lots.uom2
425: ,last_update_date = gme_common_pvt.g_timestamp
426: ,last_updated_by = gme_common_pvt.g_user_ident
427: ,last_update_login = gme_common_pvt.g_login_id
428: ,attribute1 = p_lab_batch_lots.attribute1
429: ,attribute2 = p_lab_batch_lots.attribute2
430: ,attribute3 = p_lab_batch_lots.attribute3
431: ,attribute4 = p_lab_batch_lots.attribute4

Line 465: gme_common_pvt.log_message ('GME_NO_KEYS'

461: AND item_id = p_lab_batch_lots.item_id
462: AND lot_id = p_lab_batch_lots.lot_id
463: AND last_update_date = p_lab_batch_lots.last_update_date;
464: ELSE
465: gme_common_pvt.log_message ('GME_NO_KEYS'
466: ,'TABLE_NAME'
467: ,g_table_name);
468: RETURN FALSE;
469: END IF;

Line 475: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

471: IF SQL%FOUND THEN
472: RETURN TRUE;
473: ELSE
474: IF l_dummy = 0 THEN
475: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
476: ,'TABLE_NAME'
477: ,g_table_name);
478: ELSE
479: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 479: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

475: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
476: ,'TABLE_NAME'
477: ,g_table_name);
478: ELSE
479: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
480: ,'TABLE_NAME'
481: ,g_table_name);
482: END IF;
483:

Line 489: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

485: END IF;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: IF l_dummy = 0 THEN
489: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
490: ,'TABLE_NAME'
491: ,g_table_name);
492: ELSE
493: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 493: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

489: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
490: ,'TABLE_NAME'
491: ,g_table_name);
492: ELSE
493: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
494: ,'TABLE_NAME'
495: ,g_table_name);
496: END IF;
497:

Line 500: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

496: END IF;
497:
498: RETURN FALSE;
499: WHEN locked_by_other_user THEN
500: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
501: ,'TABLE_NAME'
502: ,g_table_name
503: ,'RECORD'
504: ,'Batch'

Line 509: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

505: ,'KEY'
506: ,TO_CHAR (p_lab_batch_lots.batch_id) );
507: RETURN FALSE;
508: WHEN OTHERS THEN
509: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
510: ,SQLERRM);
511: RETURN FALSE;
512: END update_row;
513:

Line 565: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

561:
562: RETURN TRUE;
563: EXCEPTION
564: WHEN app_exception.record_lock_exception THEN
565: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
566: ,'TABLE_NAME'
567: ,g_table_name
568: ,'RECORD'
569: ,'Batch'

Line 633: gme_common_pvt.log_message ('GME_NO_KEYS'

629: ELSIF (p_lab_batch_lots.batch_id IS NOT NULL) THEN
630: --l_where := 'BATCH_ID =:batch_id';
631: l_cursor := 3;
632: ELSE
633: gme_common_pvt.log_message ('GME_NO_KEYS'
634: ,'TABLE_NAME'
635: ,'GME_LAB_BATCH_LOTS');
636: RAISE fnd_api.g_exc_error;
637: END IF;