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

Line 129: ,x_resource_txns.end_date, gme_common_pvt.g_timestamp

125: ,x_resource_txns.completed_ind, x_resource_txns.event_id
126: ,x_resource_txns.posted_ind
127: ,x_resource_txns.overrided_protected_ind
128: ,x_resource_txns.reason_code, x_resource_txns.reason_id, x_resource_txns.start_date
129: ,x_resource_txns.end_date, gme_common_pvt.g_timestamp
130: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
131: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_login_id
132: ,x_resource_txns.delete_mark, x_resource_txns.text_code
133: ,x_resource_txns.instance_id

Line 130: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

126: ,x_resource_txns.posted_ind
127: ,x_resource_txns.overrided_protected_ind
128: ,x_resource_txns.reason_code, x_resource_txns.reason_id, x_resource_txns.start_date
129: ,x_resource_txns.end_date, gme_common_pvt.g_timestamp
130: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
131: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_login_id
132: ,x_resource_txns.delete_mark, x_resource_txns.text_code
133: ,x_resource_txns.instance_id
134: ,x_resource_txns.sequence_dependent_ind

Line 131: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_login_id

127: ,x_resource_txns.overrided_protected_ind
128: ,x_resource_txns.reason_code, x_resource_txns.reason_id, x_resource_txns.start_date
129: ,x_resource_txns.end_date, gme_common_pvt.g_timestamp
130: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
131: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_login_id
132: ,x_resource_txns.delete_mark, x_resource_txns.text_code
133: ,x_resource_txns.instance_id
134: ,x_resource_txns.sequence_dependent_ind
135: ,x_resource_txns.attribute1, x_resource_txns.attribute2

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

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

Line 292: gme_common_pvt.log_message ('GME_NO_KEYS'

288: , x_resource_txns.reverse_id
289: FROM gme_resource_txns
290: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
291: ELSE
292: gme_common_pvt.log_message ('GME_NO_KEYS'
293: ,'TABLE_NAME'
294: ,g_table_name);
295: RETURN FALSE;
296: END IF;

Line 301: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

297:
298: RETURN TRUE;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
302: ,'TABLE_NAME'
303: ,g_table_name);
304: RETURN FALSE;
305: WHEN OTHERS THEN

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

302: ,'TABLE_NAME'
303: ,g_table_name);
304: RETURN FALSE;
305: WHEN OTHERS THEN
306: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
307: ,SQLERRM);
308: RETURN FALSE;
309: END fetch_row;
310:

Line 357: gme_common_pvt.log_message ('GME_NO_KEYS'

353:
354: DELETE FROM gme_resource_txns
355: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
356: ELSE
357: gme_common_pvt.log_message ('GME_NO_KEYS'
358: ,'TABLE_NAME'
359: ,g_table_name);
360: RETURN FALSE;
361: END IF;

Line 367: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

363: IF SQL%FOUND THEN
364: RETURN TRUE;
365: ELSE
366: IF l_dummy = 0 THEN
367: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
368: ,'TABLE_NAME'
369: ,g_table_name);
370: ELSE
371: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 371: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

367: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
368: ,'TABLE_NAME'
369: ,g_table_name);
370: ELSE
371: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
372: ,'TABLE_NAME'
373: ,g_table_name);
374: END IF;
375:

Line 381: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

377: END IF;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: IF l_dummy = 0 THEN
381: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
382: ,'TABLE_NAME'
383: ,g_table_name);
384: ELSE
385: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 385: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

381: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
382: ,'TABLE_NAME'
383: ,g_table_name);
384: ELSE
385: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
386: ,'TABLE_NAME'
387: ,g_table_name);
388: END IF;
389:

Line 392: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

388: END IF;
389:
390: RETURN FALSE;
391: WHEN locked_by_other_user THEN
392: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
393: ,'TABLE_NAME'
394: ,g_table_name
395: ,'RECORD'
396: ,'Resource'

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

397: ,'KEY'
398: ,p_resource_txns.resources);
399: RETURN FALSE;
400: WHEN OTHERS THEN
401: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
402: ,SQLERRM);
403: RETURN FALSE;
404: END delete_row;
405:

Line 471: ,last_update_date = gme_common_pvt.g_timestamp

467: ,reason_code = p_resource_txns.reason_code
468: ,reason_id = p_resource_txns.reason_id
469: ,start_date = p_resource_txns.start_date
470: ,end_date = p_resource_txns.end_date
471: ,last_update_date = gme_common_pvt.g_timestamp
472: ,last_updated_by = gme_common_pvt.g_user_ident
473: ,last_update_login = gme_common_pvt.g_login_id
474: ,delete_mark = p_resource_txns.delete_mark
475: ,text_code = p_resource_txns.text_code

Line 472: ,last_updated_by = gme_common_pvt.g_user_ident

468: ,reason_id = p_resource_txns.reason_id
469: ,start_date = p_resource_txns.start_date
470: ,end_date = p_resource_txns.end_date
471: ,last_update_date = gme_common_pvt.g_timestamp
472: ,last_updated_by = gme_common_pvt.g_user_ident
473: ,last_update_login = gme_common_pvt.g_login_id
474: ,delete_mark = p_resource_txns.delete_mark
475: ,text_code = p_resource_txns.text_code
476: ,instance_id = p_resource_txns.instance_id

Line 473: ,last_update_login = gme_common_pvt.g_login_id

469: ,start_date = p_resource_txns.start_date
470: ,end_date = p_resource_txns.end_date
471: ,last_update_date = gme_common_pvt.g_timestamp
472: ,last_updated_by = gme_common_pvt.g_user_ident
473: ,last_update_login = gme_common_pvt.g_login_id
474: ,delete_mark = p_resource_txns.delete_mark
475: ,text_code = p_resource_txns.text_code
476: ,instance_id = p_resource_txns.instance_id
477: ,sequence_dependent_ind =

Line 519: gme_common_pvt.log_message ('GME_NO_KEYS'

515: --10-AUG-04 Rishi Varma B3818266/3759970
516: , reverse_id = p_resource_txns.reverse_id
517: WHERE poc_trans_id = p_resource_txns.poc_trans_id;
518: ELSE
519: gme_common_pvt.log_message ('GME_NO_KEYS'
520: ,'TABLE_NAME'
521: ,g_table_name);
522: RETURN FALSE;
523: END IF;

Line 529: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

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

Line 533: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

529: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
530: ,'TABLE_NAME'
531: ,g_table_name);
532: ELSE
533: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
534: ,'TABLE_NAME'
535: ,g_table_name);
536: END IF;
537:

Line 543: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

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

Line 547: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

543: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
544: ,'TABLE_NAME'
545: ,g_table_name);
546: ELSE
547: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
548: ,'TABLE_NAME'
549: ,g_table_name);
550: END IF;
551:

Line 554: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

550: END IF;
551:
552: RETURN FALSE;
553: WHEN locked_by_other_user THEN
554: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
555: ,'TABLE_NAME'
556: ,g_table_name
557: ,'RECORD'
558: ,'Resource'

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

559: ,'KEY'
560: ,p_resource_txns.resources);
561: RETURN FALSE;
562: WHEN OTHERS THEN
563: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
564: ,SQLERRM);
565: RETURN FALSE;
566: END update_row;
567:

Line 613: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

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