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

Line 186: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

182: ,x_batch_step_activities.attribute27
183: ,x_batch_step_activities.attribute28
184: ,x_batch_step_activities.attribute29
185: ,x_batch_step_activities.attribute30
186: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
187: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
188: ,gme_common_pvt.g_login_id
189: ,x_batch_step_activities.text_code
190: ,x_batch_step_activities.actual_activity_factor

Line 187: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

183: ,x_batch_step_activities.attribute28
184: ,x_batch_step_activities.attribute29
185: ,x_batch_step_activities.attribute30
186: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
187: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
188: ,gme_common_pvt.g_login_id
189: ,x_batch_step_activities.text_code
190: ,x_batch_step_activities.actual_activity_factor
191: ,x_batch_step_activities.material_ind

Line 188: ,gme_common_pvt.g_login_id

184: ,x_batch_step_activities.attribute29
185: ,x_batch_step_activities.attribute30
186: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
187: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
188: ,gme_common_pvt.g_login_id
189: ,x_batch_step_activities.text_code
190: ,x_batch_step_activities.actual_activity_factor
191: ,x_batch_step_activities.material_ind
192: --rishi 3372774 06-FEB-2004 start

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

212: || ' Error is '
213: || SQLERRM);
214: END IF;
215:
216: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
217: RETURN FALSE;
218: END insert_row;
219:
220: /* Api start of comments

Line 501: gme_common_pvt.log_message ('GME_NO_KEYS'

497: WHERE batch_id = p_batch_step_activities.batch_id
498: AND batchstep_id = p_batch_step_activities.batchstep_id
499: AND activity = p_batch_step_activities.activity;
500: ELSE
501: gme_common_pvt.log_message ('GME_NO_KEYS'
502: ,'TABLE_NAME'
503: ,g_table_name);
504: RETURN FALSE;
505: END IF;

Line 510: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

506:
507: RETURN TRUE;
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
511: ,'TABLE_NAME'
512: ,g_table_name);
513: RETURN FALSE;
514: WHEN OTHERS THEN

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

520: || ' Error is '
521: || SQLERRM);
522: END IF;
523:
524: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
525: RETURN FALSE;
526: END fetch_row;
527:
528: /* Api start of comments

Line 598: gme_common_pvt.log_message ('GME_NO_KEYS'

594: WHERE batch_id = p_batch_step_activities.batch_id
595: AND batchstep_id = p_batch_step_activities.batchstep_id
596: AND activity = p_batch_step_activities.activity;
597: ELSE
598: gme_common_pvt.log_message ('GME_NO_KEYS'
599: ,'TABLE_NAME'
600: ,g_table_name);
601: RETURN FALSE;
602: END IF;

Line 608: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

604: IF SQL%FOUND THEN
605: RETURN TRUE;
606: ELSE
607: IF l_dummy = 0 THEN
608: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
609: ,'TABLE_NAME'
610: ,g_table_name);
611: ELSE
612: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

Line 612: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

608: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
609: ,'TABLE_NAME'
610: ,g_table_name);
611: ELSE
612: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
613: ,'TABLE_NAME'
614: ,g_table_name);
615: END IF;
616:

Line 621: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

617: RETURN FALSE;
618: END IF;
619: EXCEPTION
620: WHEN locked_by_other_user THEN
621: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
622: ,'TABLE_NAME'
623: ,g_table_name
624: ,'RECORD'
625: ,'Activities'

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

635: || ' Error is '
636: || SQLERRM);
637: END IF;
638:
639: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
640: RETURN FALSE;
641: END delete_row;
642:
643: /* Api start of comments

Line 742: ,last_update_date = gme_common_pvt.g_timestamp

738: ,attribute27 = p_batch_step_activities.attribute27
739: ,attribute28 = p_batch_step_activities.attribute28
740: ,attribute29 = p_batch_step_activities.attribute29
741: ,attribute30 = p_batch_step_activities.attribute30
742: ,last_update_date = gme_common_pvt.g_timestamp
743: ,last_updated_by = gme_common_pvt.g_user_ident
744: ,last_update_login = gme_common_pvt.g_login_id
745: ,text_code = p_batch_step_activities.text_code
746: ,actual_activity_factor =

Line 743: ,last_updated_by = gme_common_pvt.g_user_ident

739: ,attribute28 = p_batch_step_activities.attribute28
740: ,attribute29 = p_batch_step_activities.attribute29
741: ,attribute30 = p_batch_step_activities.attribute30
742: ,last_update_date = gme_common_pvt.g_timestamp
743: ,last_updated_by = gme_common_pvt.g_user_ident
744: ,last_update_login = gme_common_pvt.g_login_id
745: ,text_code = p_batch_step_activities.text_code
746: ,actual_activity_factor =
747: p_batch_step_activities.actual_activity_factor

Line 744: ,last_update_login = gme_common_pvt.g_login_id

740: ,attribute29 = p_batch_step_activities.attribute29
741: ,attribute30 = p_batch_step_activities.attribute30
742: ,last_update_date = gme_common_pvt.g_timestamp
743: ,last_updated_by = gme_common_pvt.g_user_ident
744: ,last_update_login = gme_common_pvt.g_login_id
745: ,text_code = p_batch_step_activities.text_code
746: ,actual_activity_factor =
747: p_batch_step_activities.actual_activity_factor
748: ,material_ind = p_batch_step_activities.material_ind

Line 814: ,last_update_date = gme_common_pvt.g_timestamp

810: ,attribute27 = p_batch_step_activities.attribute27
811: ,attribute28 = p_batch_step_activities.attribute28
812: ,attribute29 = p_batch_step_activities.attribute29
813: ,attribute30 = p_batch_step_activities.attribute30
814: ,last_update_date = gme_common_pvt.g_timestamp
815: ,last_updated_by = gme_common_pvt.g_user_ident
816: ,last_update_login = gme_common_pvt.g_login_id
817: ,text_code = p_batch_step_activities.text_code
818: ,actual_activity_factor =

Line 815: ,last_updated_by = gme_common_pvt.g_user_ident

811: ,attribute28 = p_batch_step_activities.attribute28
812: ,attribute29 = p_batch_step_activities.attribute29
813: ,attribute30 = p_batch_step_activities.attribute30
814: ,last_update_date = gme_common_pvt.g_timestamp
815: ,last_updated_by = gme_common_pvt.g_user_ident
816: ,last_update_login = gme_common_pvt.g_login_id
817: ,text_code = p_batch_step_activities.text_code
818: ,actual_activity_factor =
819: p_batch_step_activities.actual_activity_factor

Line 816: ,last_update_login = gme_common_pvt.g_login_id

812: ,attribute29 = p_batch_step_activities.attribute29
813: ,attribute30 = p_batch_step_activities.attribute30
814: ,last_update_date = gme_common_pvt.g_timestamp
815: ,last_updated_by = gme_common_pvt.g_user_ident
816: ,last_update_login = gme_common_pvt.g_login_id
817: ,text_code = p_batch_step_activities.text_code
818: ,actual_activity_factor =
819: p_batch_step_activities.actual_activity_factor
820: ,material_ind = p_batch_step_activities.material_ind

Line 830: gme_common_pvt.log_message ('GME_NO_KEYS'

826: AND batchstep_id = p_batch_step_activities.batchstep_id
827: AND activity = p_batch_step_activities.activity
828: AND last_update_date = p_batch_step_activities.last_update_date;
829: ELSE
830: gme_common_pvt.log_message ('GME_NO_KEYS'
831: ,'TABLE_NAME'
832: ,g_table_name);
833: RETURN FALSE;
834: END IF;

Line 840: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

836: IF SQL%FOUND THEN
837: RETURN TRUE;
838: ELSE
839: IF l_dummy = 0 THEN
840: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
841: ,'TABLE_NAME'
842: ,g_table_name);
843: ELSE
844: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 844: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

840: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
841: ,'TABLE_NAME'
842: ,g_table_name);
843: ELSE
844: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
845: ,'TABLE_NAME'
846: ,g_table_name);
847: END IF;
848:

Line 854: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

850: END IF;
851: EXCEPTION
852: WHEN NO_DATA_FOUND THEN
853: IF l_dummy = 0 THEN
854: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
855: ,'TABLE_NAME'
856: ,g_table_name);
857: ELSE
858: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 858: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

854: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
855: ,'TABLE_NAME'
856: ,g_table_name);
857: ELSE
858: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
859: ,'TABLE_NAME'
860: ,g_table_name);
861: END IF;
862:

Line 865: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

861: END IF;
862:
863: RETURN FALSE;
864: WHEN locked_by_other_user THEN
865: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
866: ,'TABLE_NAME'
867: ,g_table_name
868: ,'RECORD'
869: ,'Activities'

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

879: || ' Error is '
880: || SQLERRM);
881: END IF;
882:
883: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
884: RETURN FALSE;
885: END update_row;
886:
887: /* Api start of comments

Line 950: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

946:
947: RETURN TRUE;
948: EXCEPTION
949: WHEN app_exception.record_lock_exception THEN
950: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
951: ,'TABLE_NAME'
952: ,g_table_name
953: ,'RECORD'
954: ,'Activities'