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

Line 124: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

120: ,x_batch_step_transfers.line_type
121: ,x_batch_step_transfers.trans_qty
122: ,x_batch_step_transfers.trans_um
123: ,x_batch_step_transfers.trans_date
124: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
125: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
126: ,gme_common_pvt.g_user_ident
127: ,x_batch_step_transfers.delete_mark
128: ,x_batch_step_transfers.text_code

Line 125: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp

121: ,x_batch_step_transfers.trans_qty
122: ,x_batch_step_transfers.trans_um
123: ,x_batch_step_transfers.trans_date
124: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
125: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
126: ,gme_common_pvt.g_user_ident
127: ,x_batch_step_transfers.delete_mark
128: ,x_batch_step_transfers.text_code
129: ,x_batch_step_transfers.attribute1

Line 126: ,gme_common_pvt.g_user_ident

122: ,x_batch_step_transfers.trans_um
123: ,x_batch_step_transfers.trans_date
124: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
125: ,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
126: ,gme_common_pvt.g_user_ident
127: ,x_batch_step_transfers.delete_mark
128: ,x_batch_step_transfers.text_code
129: ,x_batch_step_transfers.attribute1
130: ,x_batch_step_transfers.attribute2

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

166: RETURN FALSE;
167: END IF;
168: EXCEPTION
169: WHEN OTHERS THEN
170: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
171: ,SQLERRM);
172: RETURN FALSE;
173: END insert_row;
174:

Line 307: gme_common_pvt.log_message ('GME_NO_KEYS'

303: ,x_batch_step_transfers.attribute_category
304: FROM gme_batch_step_transfers
305: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id;
306: ELSE
307: gme_common_pvt.log_message ('GME_NO_KEYS'
308: ,'TABLE_NAME'
309: ,g_table_name);
310: RETURN FALSE;
311: END IF;

Line 316: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

312:
313: RETURN TRUE;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
317: ,'TABLE_NAME'
318: ,g_table_name);
319: RETURN FALSE;
320: WHEN OTHERS THEN

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

317: ,'TABLE_NAME'
318: ,g_table_name);
319: RETURN FALSE;
320: WHEN OTHERS THEN
321: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
322: ,SQLERRM);
323: RETURN FALSE;
324: END fetch_row;
325:

Line 374: gme_common_pvt.log_message ('GME_NO_KEYS'

370: UPDATE gme_batch_step_transfers
371: SET delete_mark = 1
372: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id;
373: ELSE
374: gme_common_pvt.log_message ('GME_NO_KEYS'
375: ,'TABLE_NAME'
376: ,g_table_name);
377: RETURN FALSE;
378: END IF;

Line 384: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

380: IF SQL%FOUND THEN
381: RETURN TRUE;
382: ELSE
383: IF l_dummy = 0 THEN
384: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
385: ,'TABLE_NAME'
386: ,g_table_name);
387: ELSE
388: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 388: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

384: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
385: ,'TABLE_NAME'
386: ,g_table_name);
387: ELSE
388: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
389: ,'TABLE_NAME'
390: ,g_table_name);
391: END IF;
392:

Line 398: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

394: END IF;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: IF l_dummy = 0 THEN
398: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
399: ,'TABLE_NAME'
400: ,g_table_name);
401: ELSE
402: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 402: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

398: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
399: ,'TABLE_NAME'
400: ,g_table_name);
401: ELSE
402: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
403: ,'TABLE_NAME'
404: ,g_table_name);
405: END IF;
406:

Line 409: gme_common_pvt.log_message

405: END IF;
406:
407: RETURN FALSE;
408: WHEN locked_by_other_user THEN
409: gme_common_pvt.log_message
410: ('GME_RECORD_LOCKED'
411: ,'TABLE_NAME'
412: ,g_table_name
413: ,'RECORD'

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

415: ,'KEY'
416: ,TO_CHAR (p_batch_step_transfers.wip_trans_id) );
417: RETURN FALSE;
418: WHEN OTHERS THEN
419: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
420: ,SQLERRM);
421: RETURN FALSE;
422: END delete_row;
423:

Line 477: ,last_updated_by = gme_common_pvt.g_user_ident

473: ,line_type = p_batch_step_transfers.line_type
474: ,trans_qty = p_batch_step_transfers.trans_qty
475: ,trans_um = p_batch_step_transfers.trans_um
476: ,trans_date = p_batch_step_transfers.trans_date
477: ,last_updated_by = gme_common_pvt.g_user_ident
478: ,last_update_date = gme_common_pvt.g_timestamp
479: ,last_update_login = gme_common_pvt.g_login_id
480: ,delete_mark = p_batch_step_transfers.delete_mark
481: ,text_code = p_batch_step_transfers.text_code

Line 478: ,last_update_date = gme_common_pvt.g_timestamp

474: ,trans_qty = p_batch_step_transfers.trans_qty
475: ,trans_um = p_batch_step_transfers.trans_um
476: ,trans_date = p_batch_step_transfers.trans_date
477: ,last_updated_by = gme_common_pvt.g_user_ident
478: ,last_update_date = gme_common_pvt.g_timestamp
479: ,last_update_login = gme_common_pvt.g_login_id
480: ,delete_mark = p_batch_step_transfers.delete_mark
481: ,text_code = p_batch_step_transfers.text_code
482: ,attribute1 = p_batch_step_transfers.attribute1

Line 479: ,last_update_login = gme_common_pvt.g_login_id

475: ,trans_um = p_batch_step_transfers.trans_um
476: ,trans_date = p_batch_step_transfers.trans_date
477: ,last_updated_by = gme_common_pvt.g_user_ident
478: ,last_update_date = gme_common_pvt.g_timestamp
479: ,last_update_login = gme_common_pvt.g_login_id
480: ,delete_mark = p_batch_step_transfers.delete_mark
481: ,text_code = p_batch_step_transfers.text_code
482: ,attribute1 = p_batch_step_transfers.attribute1
483: ,attribute2 = p_batch_step_transfers.attribute2

Line 516: gme_common_pvt.log_message ('GME_NO_KEYS'

512: ,attribute_category = p_batch_step_transfers.attribute_category
513: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
514: AND last_update_date = p_batch_step_transfers.last_update_date;
515: ELSE
516: gme_common_pvt.log_message ('GME_NO_KEYS'
517: ,'TABLE_NAME'
518: ,g_table_name);
519: RETURN FALSE;
520: END IF;

Line 526: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

522: IF SQL%FOUND THEN
523: RETURN TRUE;
524: ELSE
525: IF l_dummy = 0 THEN
526: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
527: ,'TABLE_NAME'
528: ,g_table_name);
529: ELSE
530: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 530: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

526: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
527: ,'TABLE_NAME'
528: ,g_table_name);
529: ELSE
530: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
531: ,'TABLE_NAME'
532: ,g_table_name);
533: END IF;
534:

Line 540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

536: END IF;
537: EXCEPTION
538: WHEN NO_DATA_FOUND THEN
539: IF l_dummy = 0 THEN
540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
541: ,'TABLE_NAME'
542: ,g_table_name);
543: ELSE
544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
541: ,'TABLE_NAME'
542: ,g_table_name);
543: ELSE
544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
545: ,'TABLE_NAME'
546: ,g_table_name);
547: END IF;
548:

Line 551: gme_common_pvt.log_message

547: END IF;
548:
549: RETURN FALSE;
550: WHEN locked_by_other_user THEN
551: gme_common_pvt.log_message
552: ('GME_RECORD_LOCKED'
553: ,'TABLE_NAME'
554: ,g_table_name
555: ,'RECORD'

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

557: ,'KEY'
558: ,TO_CHAR (p_batch_step_transfers.wip_trans_id) );
559: RETURN FALSE;
560: WHEN OTHERS THEN
561: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
562: ,SQLERRM);
563: RETURN FALSE;
564: END update_row;
565:

Line 612: gme_common_pvt.log_message

608:
609: RETURN TRUE;
610: EXCEPTION
611: WHEN app_exception.record_lock_exception THEN
612: gme_common_pvt.log_message
613: ('GME_RECORD_LOCKED'
614: ,'TABLE_NAME'
615: ,g_table_name
616: ,'RECORD'