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_COMMON_PVT

Line 72: x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;

68: END IF;
69:
70: x_pending_product_lots_rec := p_pending_product_lots_rec;
71:
72: x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;
73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;

Line 73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;

69:
70: x_pending_product_lots_rec := p_pending_product_lots_rec;
71:
72: x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;
73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;
77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;

Line 74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;

70: x_pending_product_lots_rec := p_pending_product_lots_rec;
71:
72: x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;
73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;
77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;
78:

Line 76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;

72: x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;
73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;
77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;
78:
79: SELECT apps.gme_pending_product_lots_s.nextval
80: INTO x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID

Line 77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;

73: x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
74: x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;
77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;
78:
79: SELECT apps.gme_pending_product_lots_s.nextval
80: INTO x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID
81: FROM sys.dual;

Line 192: gme_common_pvt.log_message ('GME_NO_KEYS'

188: FROM gme_pending_product_lots
189: WHERE material_detail_id = l_matl_dtl_id
190: AND sequence = l_sequ;
191: ELSE
192: gme_common_pvt.log_message ('GME_NO_KEYS'
193: ,'TABLE_NAME'
194: ,g_table_name);
195: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
196: RETURN FALSE;

Line 207: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

203: RETURN TRUE;
204:
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
208: ,'TABLE_NAME'
209: ,g_table_name);
210: x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID := NULL;
211: RETURN FALSE;

Line 293: gme_common_pvt.log_message ('GME_NO_KEYS'

289: FROM gme_pending_product_lots
290: WHERE material_detail_id = l_matl_dtl_id
291: AND sequence = l_sequ;
292: ELSE
293: gme_common_pvt.log_message ('GME_NO_KEYS'
294: ,'TABLE_NAME'
295: ,g_table_name);
296: RETURN FALSE;
297: END IF;

Line 303: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

299: IF (SQL%FOUND) THEN
300: RETURN TRUE;
301: ELSE
302: IF l_dummy = 0 THEN
303: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
304: ,'TABLE_NAME'
305: ,g_table_name);
306: ELSE
307: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 307: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

303: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
304: ,'TABLE_NAME'
305: ,g_table_name);
306: ELSE
307: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
308: ,'TABLE_NAME'
309: ,g_table_name);
310: RETURN FALSE;
311: END IF;

Line 321: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

317:
318: RETURN TRUE;
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
322: ,'TABLE_NAME'
323: ,g_table_name);
324: RETURN FALSE;
325: WHEN locked_by_other_user THEN

Line 326: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

322: ,'TABLE_NAME'
323: ,g_table_name);
324: RETURN FALSE;
325: WHEN locked_by_other_user THEN
326: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
327: ,'TABLE_NAME'
328: ,g_table_name
329: ,'RECORD'
330: ,'PendingProductLots'

Line 389: l_pp_lot_rec.last_update_date := gme_common_pvt.g_timestamp;

385: l_sequ := p_pending_product_lots_rec.sequence;
386:
387: l_pp_lot_rec := p_pending_product_lots_rec;
388:
389: l_pp_lot_rec.last_update_date := gme_common_pvt.g_timestamp;
390: l_pp_lot_rec.last_updated_by := gme_common_pvt.g_user_ident;
391: l_pp_lot_rec.last_update_login := gme_common_pvt.g_login_id;
392:
393: IF (l_pp_lot_id IS NOT NULL) THEN

Line 390: l_pp_lot_rec.last_updated_by := gme_common_pvt.g_user_ident;

386:
387: l_pp_lot_rec := p_pending_product_lots_rec;
388:
389: l_pp_lot_rec.last_update_date := gme_common_pvt.g_timestamp;
390: l_pp_lot_rec.last_updated_by := gme_common_pvt.g_user_ident;
391: l_pp_lot_rec.last_update_login := gme_common_pvt.g_login_id;
392:
393: IF (l_pp_lot_id IS NOT NULL) THEN
394: SELECT 1

Line 391: l_pp_lot_rec.last_update_login := gme_common_pvt.g_login_id;

387: l_pp_lot_rec := p_pending_product_lots_rec;
388:
389: l_pp_lot_rec.last_update_date := gme_common_pvt.g_timestamp;
390: l_pp_lot_rec.last_updated_by := gme_common_pvt.g_user_ident;
391: l_pp_lot_rec.last_update_login := gme_common_pvt.g_login_id;
392:
393: IF (l_pp_lot_id IS NOT NULL) THEN
394: SELECT 1
395: INTO l_dummy

Line 435: gme_common_pvt.log_message ('GME_NO_KEYS'

431: WHERE material_detail_id = l_matl_dtl_id
432: AND sequence = l_sequ
433: AND last_update_date = p_pending_product_lots_rec.last_update_date;
434: ELSE
435: gme_common_pvt.log_message ('GME_NO_KEYS'
436: ,'TABLE_NAME'
437: ,g_table_name);
438: RETURN FALSE;
439: END IF;

Line 455: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

451: RETURN TRUE;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN
454: IF l_dummy = 0 THEN
455: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
456: ,'TABLE_NAME'
457: ,g_table_name);
458: ELSE
459: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 459: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

455: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
456: ,'TABLE_NAME'
457: ,g_table_name);
458: ELSE
459: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
460: ,'TABLE_NAME'
461: ,g_table_name);
462: END IF;
463: RETURN FALSE;

Line 465: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

461: ,g_table_name);
462: END IF;
463: RETURN FALSE;
464: WHEN locked_by_other_user THEN
465: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
466: ,'TABLE_NAME'
467: ,g_table_name
468: ,'RECORD'
469: ,'PendingProductLots'

Line 541: gme_common_pvt.log_message ('GME_NO_KEYS'

537: WHERE material_detail_id = l_matl_dtl_id
538: AND sequence = l_sequ
539: FOR UPDATE NOWAIT;
540: ELSE
541: gme_common_pvt.log_message ('GME_NO_KEYS'
542: ,'TABLE_NAME'
543: ,g_table_name);
544: RETURN FALSE;
545: END IF;

Line 554: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

550:
551: RETURN TRUE;
552: EXCEPTION
553: WHEN app_exception.record_lock_exception THEN
554: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
555: ,'TABLE_NAME'
556: ,g_table_name
557: ,'RECORD'
558: ,'PendingProductLots'