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

Line 165: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp

161: ,x_batch_step_items.ATTRIBUTE27
162: ,x_batch_step_items.ATTRIBUTE28
163: ,x_batch_step_items.ATTRIBUTE29
164: ,x_batch_step_items.ATTRIBUTE30
165: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
166: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
167: ,gme_common_pvt.g_user_ident);
168:
169: RETURN TRUE;

Line 166: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

162: ,x_batch_step_items.ATTRIBUTE28
163: ,x_batch_step_items.ATTRIBUTE29
164: ,x_batch_step_items.ATTRIBUTE30
165: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
166: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
167: ,gme_common_pvt.g_user_ident);
168:
169: RETURN TRUE;
170: EXCEPTION

Line 167: ,gme_common_pvt.g_user_ident);

163: ,x_batch_step_items.ATTRIBUTE29
164: ,x_batch_step_items.ATTRIBUTE30
165: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
166: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
167: ,gme_common_pvt.g_user_ident);
168:
169: RETURN TRUE;
170: EXCEPTION
171: WHEN OTHERS THEN

Line 181: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

177: || ' Error is '
178: || SQLERRM);
179: END IF;
180:
181: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
182: RETURN FALSE;
183: END insert_row;
184:
185: /* Api start of comments

Line 323: gme_common_pvt.log_message ('GME_NO_KEYS'

319: ,x_batch_step_items.created_by
320: FROM gme_batch_step_items
321: WHERE material_detail_id = p_batch_step_items.material_detail_id;
322: ELSE
323: gme_common_pvt.log_message ('GME_NO_KEYS'
324: ,'TABLE_NAME'
325: ,g_table_name);
326: RETURN FALSE;
327: END IF;

Line 332: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

328:
329: RETURN TRUE;
330: EXCEPTION
331: WHEN NO_DATA_FOUND THEN
332: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
333: ,'TABLE_NAME'
334: ,g_table_name);
335: RETURN FALSE;
336: WHEN OTHERS THEN

Line 346: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

342: || ' Error is '
343: || SQLERRM);
344: END IF;
345:
346: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
347: RETURN FALSE;
348: END fetch_row;
349:
350: /* Api start of comments

Line 404: gme_common_pvt.log_message ('GME_NO_KEYS'

400: DELETE FROM gme_batch_step_items
401: WHERE material_detail_id =
402: p_batch_step_items.material_detail_id;
403: ELSE
404: gme_common_pvt.log_message ('GME_NO_KEYS'
405: ,'TABLE_NAME'
406: ,g_table_name);
407: RETURN FALSE;
408: END IF;

Line 414: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

410: IF SQL%FOUND THEN
411: RETURN TRUE;
412: ELSE
413: IF l_dummy = 0 THEN
414: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
415: ,'TABLE_NAME'
416: ,g_table_name);
417: ELSE
418: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 418: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

414: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
415: ,'TABLE_NAME'
416: ,g_table_name);
417: ELSE
418: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
419: ,'TABLE_NAME'
420: ,g_table_name);
421: END IF;
422:

Line 428: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

424: END IF;
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: IF l_dummy = 0 THEN
428: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
429: ,'TABLE_NAME'
430: ,g_table_name);
431: ELSE
432: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 432: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

428: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
429: ,'TABLE_NAME'
430: ,g_table_name);
431: ELSE
432: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
433: ,'TABLE_NAME'
434: ,g_table_name);
435: END IF;
436:

Line 439: gme_common_pvt.log_message

435: END IF;
436:
437: RETURN FALSE;
438: WHEN locked_by_other_user THEN
439: gme_common_pvt.log_message
440: ('GME_RECORD_LOCKED'
441: ,'TABLE_NAME'
442: ,g_table_name
443: ,'RECORD'

Line 458: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

454: || ' Error is '
455: || SQLERRM);
456: END IF;
457:
458: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
459: RETURN FALSE;
460: END delete_row;
461:
462: /* Api start of comments

Line 554: ,last_update_login = gme_common_pvt.g_login_id

550: ,ATTRIBUTE27 = p_batch_step_items.ATTRIBUTE27
551: ,ATTRIBUTE28 = p_batch_step_items.ATTRIBUTE28
552: ,ATTRIBUTE29 = p_batch_step_items.ATTRIBUTE29
553: ,ATTRIBUTE30 = p_batch_step_items.ATTRIBUTE30
554: ,last_update_login = gme_common_pvt.g_login_id
555: ,last_update_date = gme_common_pvt.g_timestamp
556: ,last_updated_by = gme_common_pvt.g_user_ident
557: WHERE material_detail_id = p_batch_step_items.material_detail_id
558: AND last_update_date = p_batch_step_items.last_update_date;

Line 555: ,last_update_date = gme_common_pvt.g_timestamp

551: ,ATTRIBUTE28 = p_batch_step_items.ATTRIBUTE28
552: ,ATTRIBUTE29 = p_batch_step_items.ATTRIBUTE29
553: ,ATTRIBUTE30 = p_batch_step_items.ATTRIBUTE30
554: ,last_update_login = gme_common_pvt.g_login_id
555: ,last_update_date = gme_common_pvt.g_timestamp
556: ,last_updated_by = gme_common_pvt.g_user_ident
557: WHERE material_detail_id = p_batch_step_items.material_detail_id
558: AND last_update_date = p_batch_step_items.last_update_date;
559: ELSE

Line 556: ,last_updated_by = gme_common_pvt.g_user_ident

552: ,ATTRIBUTE29 = p_batch_step_items.ATTRIBUTE29
553: ,ATTRIBUTE30 = p_batch_step_items.ATTRIBUTE30
554: ,last_update_login = gme_common_pvt.g_login_id
555: ,last_update_date = gme_common_pvt.g_timestamp
556: ,last_updated_by = gme_common_pvt.g_user_ident
557: WHERE material_detail_id = p_batch_step_items.material_detail_id
558: AND last_update_date = p_batch_step_items.last_update_date;
559: ELSE
560: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 560: gme_common_pvt.log_message ('GME_NO_KEYS'

556: ,last_updated_by = gme_common_pvt.g_user_ident
557: WHERE material_detail_id = p_batch_step_items.material_detail_id
558: AND last_update_date = p_batch_step_items.last_update_date;
559: ELSE
560: gme_common_pvt.log_message ('GME_NO_KEYS'
561: ,'TABLE_NAME'
562: ,g_table_name);
563: RETURN FALSE;
564: END IF;

Line 570: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

566: IF SQL%FOUND THEN
567: RETURN TRUE;
568: ELSE
569: IF l_dummy = 0 THEN
570: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
571: ,'TABLE_NAME'
572: ,g_table_name);
573: ELSE
574: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 574: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

570: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
571: ,'TABLE_NAME'
572: ,g_table_name);
573: ELSE
574: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
575: ,'TABLE_NAME'
576: ,g_table_name);
577: END IF;
578:

Line 584: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

580: END IF;
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583: IF l_dummy = 0 THEN
584: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
585: ,'TABLE_NAME'
586: ,g_table_name);
587: ELSE
588: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 588: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

584: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
585: ,'TABLE_NAME'
586: ,g_table_name);
587: ELSE
588: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
589: ,'TABLE_NAME'
590: ,g_table_name);
591: END IF;
592:

Line 595: gme_common_pvt.log_message

591: END IF;
592:
593: RETURN FALSE;
594: WHEN locked_by_other_user THEN
595: gme_common_pvt.log_message
596: ('GME_RECORD_LOCKED'
597: ,'TABLE_NAME'
598: ,g_table_name
599: ,'RECORD'

Line 614: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

610: || ' Error is '
611: || SQLERRM);
612: END IF;
613:
614: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
615: RETURN FALSE;
616: END update_row;
617:
618: /* Api start of comments

Line 669: gme_common_pvt.log_message

665:
666: RETURN TRUE;
667: EXCEPTION
668: WHEN app_exception.record_lock_exception THEN
669: gme_common_pvt.log_message
670: ('GME_RECORD_LOCKED'
671: ,'TABLE_NAME'
672: ,g_table_name
673: ,'RECORD'