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

Line 131: ,gme_common_pvt.g_login_id, gme_common_pvt.g_user_ident

127: ,x_batch_step_dependencies.max_delay
128: ,x_batch_step_dependencies.transfer_qty
129: ,x_batch_step_dependencies.transfer_um
130: ,x_batch_step_dependencies.text_code
131: ,gme_common_pvt.g_login_id, gme_common_pvt.g_user_ident
132: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
133: ,gme_common_pvt.g_timestamp
134: ,x_batch_step_dependencies.transfer_percent
135: ,x_batch_step_dependencies.attribute1

Line 132: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

128: ,x_batch_step_dependencies.transfer_qty
129: ,x_batch_step_dependencies.transfer_um
130: ,x_batch_step_dependencies.text_code
131: ,gme_common_pvt.g_login_id, gme_common_pvt.g_user_ident
132: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
133: ,gme_common_pvt.g_timestamp
134: ,x_batch_step_dependencies.transfer_percent
135: ,x_batch_step_dependencies.attribute1
136: ,x_batch_step_dependencies.attribute2

Line 133: ,gme_common_pvt.g_timestamp

129: ,x_batch_step_dependencies.transfer_um
130: ,x_batch_step_dependencies.text_code
131: ,gme_common_pvt.g_login_id, gme_common_pvt.g_user_ident
132: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
133: ,gme_common_pvt.g_timestamp
134: ,x_batch_step_dependencies.transfer_percent
135: ,x_batch_step_dependencies.attribute1
136: ,x_batch_step_dependencies.attribute2
137: ,x_batch_step_dependencies.attribute3

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

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

Line 318: gme_common_pvt.log_message ('GME_NO_KEYS'

314: WHERE batch_id = p_batch_step_dependencies.batch_id
315: AND batchstep_id = p_batch_step_dependencies.batchstep_id
316: AND dep_step_id = p_batch_step_dependencies.dep_step_id;
317: ELSE
318: gme_common_pvt.log_message ('GME_NO_KEYS'
319: ,'TABLE_NAME'
320: ,g_table_name);
321: RETURN FALSE;
322: END IF;

Line 327: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

323:
324: RETURN TRUE;
325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN
327: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
328: ,'TABLE_NAME'
329: ,g_table_name);
330: RETURN FALSE;
331: WHEN OTHERS THEN

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

328: ,'TABLE_NAME'
329: ,g_table_name);
330: RETURN FALSE;
331: WHEN OTHERS THEN
332: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
333: ,SQLERRM);
334: RETURN FALSE;
335: END fetch_row;
336:

Line 399: gme_common_pvt.log_message ('GME_NO_KEYS'

395: WHERE batch_id = p_batch_step_dependencies.batch_id
396: AND batchstep_id = p_batch_step_dependencies.batchstep_id
397: AND dep_step_id = p_batch_step_dependencies.dep_step_id;
398: ELSE
399: gme_common_pvt.log_message ('GME_NO_KEYS'
400: ,'TABLE_NAME'
401: ,g_table_name);
402: RETURN FALSE;
403: END IF;

Line 409: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

405: IF SQL%FOUND THEN
406: RETURN TRUE;
407: ELSE
408: IF l_dummy = 0 THEN
409: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
410: ,'TABLE_NAME'
411: ,g_table_name);
412: ELSE
413: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 413: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

409: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
410: ,'TABLE_NAME'
411: ,g_table_name);
412: ELSE
413: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
414: ,'TABLE_NAME'
415: ,g_table_name);
416: END IF;
417:

Line 423: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

419: END IF;
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: IF l_dummy = 0 THEN
423: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
424: ,'TABLE_NAME'
425: ,g_table_name);
426: ELSE
427: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 427: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

423: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
424: ,'TABLE_NAME'
425: ,g_table_name);
426: ELSE
427: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
428: ,'TABLE_NAME'
429: ,g_table_name);
430: END IF;
431:

Line 434: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

430: END IF;
431:
432: RETURN FALSE;
433: WHEN locked_by_other_user THEN
434: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
435: ,'TABLE_NAME'
436: ,g_table_name
437: ,'Record'
438: ,'Step No'

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

439: ,'KEY'
440: ,TO_CHAR (x_batchstep_no) );
441: RETURN FALSE;
442: WHEN OTHERS THEN
443: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
444: ,SQLERRM);
445: RETURN FALSE;
446: END delete_row;
447:

Line 516: ,last_update_login = gme_common_pvt.g_login_id

512: ,max_delay = p_batch_step_dependencies.max_delay
513: ,transfer_qty = p_batch_step_dependencies.transfer_qty
514: ,transfer_um = p_batch_step_dependencies.transfer_um
515: ,text_code = p_batch_step_dependencies.text_code
516: ,last_update_login = gme_common_pvt.g_login_id
517: ,last_updated_by = gme_common_pvt.g_user_ident
518: ,last_update_date = gme_common_pvt.g_timestamp
519: ,transfer_percent = p_batch_step_dependencies.transfer_percent
520: ,attribute1 = p_batch_step_dependencies.attribute1

Line 517: ,last_updated_by = gme_common_pvt.g_user_ident

513: ,transfer_qty = p_batch_step_dependencies.transfer_qty
514: ,transfer_um = p_batch_step_dependencies.transfer_um
515: ,text_code = p_batch_step_dependencies.text_code
516: ,last_update_login = gme_common_pvt.g_login_id
517: ,last_updated_by = gme_common_pvt.g_user_ident
518: ,last_update_date = gme_common_pvt.g_timestamp
519: ,transfer_percent = p_batch_step_dependencies.transfer_percent
520: ,attribute1 = p_batch_step_dependencies.attribute1
521: ,attribute2 = p_batch_step_dependencies.attribute2

Line 518: ,last_update_date = gme_common_pvt.g_timestamp

514: ,transfer_um = p_batch_step_dependencies.transfer_um
515: ,text_code = p_batch_step_dependencies.text_code
516: ,last_update_login = gme_common_pvt.g_login_id
517: ,last_updated_by = gme_common_pvt.g_user_ident
518: ,last_update_date = gme_common_pvt.g_timestamp
519: ,transfer_percent = p_batch_step_dependencies.transfer_percent
520: ,attribute1 = p_batch_step_dependencies.attribute1
521: ,attribute2 = p_batch_step_dependencies.attribute2
522: ,attribute3 = p_batch_step_dependencies.attribute3

Line 558: gme_common_pvt.log_message ('GME_NO_KEYS'

554: AND batchstep_id = p_batch_step_dependencies.batchstep_id
555: AND dep_step_id = p_batch_step_dependencies.dep_step_id
556: AND last_update_date = p_batch_step_dependencies.last_update_date;
557: ELSE
558: gme_common_pvt.log_message ('GME_NO_KEYS'
559: ,'TABLE_NAME'
560: ,g_table_name);
561: RETURN FALSE;
562: END IF;

Line 568: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

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

Line 572: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

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

Line 582: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

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

Line 586: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

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

Line 593: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

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

Line 602: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

598: ,'KEY'
599: ,TO_CHAR (x_batchstep_no) );
600: RETURN FALSE;
601: WHEN OTHERS THEN
602: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
603: ,'TABLE_NAME'
604: ,g_table_name
605: ,'RECORD'
606: ,'Step No'

Line 670: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

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