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

Line 221: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

217: ,x_batch_step_resources.attribute27
218: ,x_batch_step_resources.attribute28
219: ,x_batch_step_resources.attribute29
220: ,x_batch_step_resources.attribute30
221: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
222: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
223: ,x_batch_step_resources.text_code
224: ,x_batch_step_resources.batch_id
225: ,x_batch_step_resources.batchstep_id

Line 222: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

218: ,x_batch_step_resources.attribute28
219: ,x_batch_step_resources.attribute29
220: ,x_batch_step_resources.attribute30
221: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
222: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
223: ,x_batch_step_resources.text_code
224: ,x_batch_step_resources.batch_id
225: ,x_batch_step_resources.batchstep_id
226: --,x_batch_step_resources.CAPACITY_UOM

Line 229: ,gme_common_pvt.g_login_id

225: ,x_batch_step_resources.batchstep_id
226: --,x_batch_step_resources.CAPACITY_UOM
227: , x_batch_step_resources.actual_rsrc_qty
228: ,x_batch_step_resources.plan_rsrc_qty
229: ,gme_common_pvt.g_login_id
230: ,x_batch_step_resources.calculate_charges
231: ,x_batch_step_resources.original_rsrc_qty
232: ,x_batch_step_resources.original_rsrc_usage
233: ,x_batch_step_resources.firm_type

Line 244: x_batch_step_resources.created_by := gme_common_pvt.g_user_ident;

240: RETURNING batchstep_resource_id
241: INTO x_batch_step_resources.batchstep_resource_id;
242:
243: IF SQL%FOUND THEN
244: x_batch_step_resources.created_by := gme_common_pvt.g_user_ident;
245: x_batch_step_resources.creation_date := gme_common_pvt.g_timestamp;
246: x_batch_step_resources.last_updated_by :=
247: gme_common_pvt.g_user_ident;
248: x_batch_step_resources.last_update_date :=

Line 245: x_batch_step_resources.creation_date := gme_common_pvt.g_timestamp;

241: INTO x_batch_step_resources.batchstep_resource_id;
242:
243: IF SQL%FOUND THEN
244: x_batch_step_resources.created_by := gme_common_pvt.g_user_ident;
245: x_batch_step_resources.creation_date := gme_common_pvt.g_timestamp;
246: x_batch_step_resources.last_updated_by :=
247: gme_common_pvt.g_user_ident;
248: x_batch_step_resources.last_update_date :=
249: gme_common_pvt.g_timestamp;

Line 247: gme_common_pvt.g_user_ident;

243: IF SQL%FOUND THEN
244: x_batch_step_resources.created_by := gme_common_pvt.g_user_ident;
245: x_batch_step_resources.creation_date := gme_common_pvt.g_timestamp;
246: x_batch_step_resources.last_updated_by :=
247: gme_common_pvt.g_user_ident;
248: x_batch_step_resources.last_update_date :=
249: gme_common_pvt.g_timestamp;
250: RETURN TRUE;
251: ELSE

Line 249: gme_common_pvt.g_timestamp;

245: x_batch_step_resources.creation_date := gme_common_pvt.g_timestamp;
246: x_batch_step_resources.last_updated_by :=
247: gme_common_pvt.g_user_ident;
248: x_batch_step_resources.last_update_date :=
249: gme_common_pvt.g_timestamp;
250: RETURN TRUE;
251: ELSE
252: RETURN FALSE;
253: END IF;

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

261: || ' Error is '
262: || SQLERRM);
263: END IF;
264:
265: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
266: RETURN FALSE;
267: END insert_row;
268:
269: /* Api start of comments

Line 642: gme_common_pvt.log_message ('GME_NO_KEYS'

638: WHERE batchstep_activity_id =
639: p_batch_step_resources.batchstep_activity_id
640: AND resources = p_batch_step_resources.resources;
641: ELSE
642: gme_common_pvt.log_message ('GME_NO_KEYS'
643: ,'TABLE_NAME'
644: ,g_table_name);
645: RETURN FALSE;
646: END IF;

Line 651: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

647:
648: RETURN TRUE;
649: EXCEPTION
650: WHEN NO_DATA_FOUND THEN
651: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
652: ,'TABLE_NAME'
653: ,g_table_name);
654: RETURN FALSE;
655: WHEN OTHERS THEN

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

661: || ' Error is '
662: || SQLERRM);
663: END IF;
664:
665: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
666: RETURN FALSE;
667: END fetch_row;
668:
669: /* Api start of comments

Line 739: gme_common_pvt.log_message ('GME_NO_KEYS'

735: WHERE batchstep_activity_id =
736: p_batch_step_resources.batchstep_activity_id
737: AND resources = p_batch_step_resources.resources;
738: ELSE
739: gme_common_pvt.log_message ('GME_NO_KEYS'
740: ,'TABLE_NAME'
741: ,g_table_name);
742: RETURN FALSE;
743: END IF;

Line 749: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

745: IF SQL%FOUND THEN
746: RETURN TRUE;
747: ELSE
748: IF l_dummy = 0 THEN
749: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
750: ,'TABLE_NAME'
751: ,g_table_name);
752: ELSE
753: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 753: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

749: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
750: ,'TABLE_NAME'
751: ,g_table_name);
752: ELSE
753: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
754: ,'TABLE_NAME'
755: ,g_table_name);
756: END IF;
757:

Line 762: gme_common_pvt.log_message

758: RETURN FALSE;
759: END IF;
760: EXCEPTION
761: WHEN locked_by_other_user THEN
762: gme_common_pvt.log_message
763: ('GME_RECORD_LOCKED'
764: ,'TABLE_NAME'
765: ,g_table_name
766: ,'RECORD'

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

777: || ' Error is '
778: || SQLERRM);
779: END IF;
780:
781: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
782: RETURN FALSE;
783: END delete_row;
784:
785: /* Api start of comments

Line 904: ,last_update_date = gme_common_pvt.g_timestamp

900: ,attribute27 = p_batch_step_resources.attribute27
901: ,attribute28 = p_batch_step_resources.attribute28
902: ,attribute29 = p_batch_step_resources.attribute29
903: ,attribute30 = p_batch_step_resources.attribute30
904: ,last_update_date = gme_common_pvt.g_timestamp
905: ,last_updated_by = gme_common_pvt.g_user_ident
906: ,text_code = p_batch_step_resources.text_code
907: ,batch_id = p_batch_step_resources.batch_id
908: ,batchstep_id = p_batch_step_resources.batchstep_id

Line 905: ,last_updated_by = gme_common_pvt.g_user_ident

901: ,attribute28 = p_batch_step_resources.attribute28
902: ,attribute29 = p_batch_step_resources.attribute29
903: ,attribute30 = p_batch_step_resources.attribute30
904: ,last_update_date = gme_common_pvt.g_timestamp
905: ,last_updated_by = gme_common_pvt.g_user_ident
906: ,text_code = p_batch_step_resources.text_code
907: ,batch_id = p_batch_step_resources.batch_id
908: ,batchstep_id = p_batch_step_resources.batchstep_id
909: --,CAPACITY_UOM = p_batch_step_resources.CAPACITY_UOM

Line 912: ,last_update_login = gme_common_pvt.g_login_id

908: ,batchstep_id = p_batch_step_resources.batchstep_id
909: --,CAPACITY_UOM = p_batch_step_resources.CAPACITY_UOM
910: , actual_rsrc_qty = p_batch_step_resources.actual_rsrc_qty
911: ,plan_rsrc_qty = p_batch_step_resources.plan_rsrc_qty
912: ,last_update_login = gme_common_pvt.g_login_id
913: ,calculate_charges = p_batch_step_resources.calculate_charges
914: ,original_rsrc_qty = p_batch_step_resources.original_rsrc_qty
915: ,original_rsrc_usage =
916: p_batch_step_resources.original_rsrc_usage

Line 1004: ,last_update_date = gme_common_pvt.g_timestamp

1000: ,attribute27 = p_batch_step_resources.attribute27
1001: ,attribute28 = p_batch_step_resources.attribute28
1002: ,attribute29 = p_batch_step_resources.attribute29
1003: ,attribute30 = p_batch_step_resources.attribute30
1004: ,last_update_date = gme_common_pvt.g_timestamp
1005: ,last_updated_by = gme_common_pvt.g_user_ident
1006: ,text_code = p_batch_step_resources.text_code
1007: ,batch_id = p_batch_step_resources.batch_id
1008: ,batchstep_id = p_batch_step_resources.batchstep_id

Line 1005: ,last_updated_by = gme_common_pvt.g_user_ident

1001: ,attribute28 = p_batch_step_resources.attribute28
1002: ,attribute29 = p_batch_step_resources.attribute29
1003: ,attribute30 = p_batch_step_resources.attribute30
1004: ,last_update_date = gme_common_pvt.g_timestamp
1005: ,last_updated_by = gme_common_pvt.g_user_ident
1006: ,text_code = p_batch_step_resources.text_code
1007: ,batch_id = p_batch_step_resources.batch_id
1008: ,batchstep_id = p_batch_step_resources.batchstep_id
1009: --,CAPACITY_UOM = p_batch_step_resources.CAPACITY_UOM

Line 1012: ,last_update_login = gme_common_pvt.g_login_id

1008: ,batchstep_id = p_batch_step_resources.batchstep_id
1009: --,CAPACITY_UOM = p_batch_step_resources.CAPACITY_UOM
1010: , actual_rsrc_qty = p_batch_step_resources.actual_rsrc_qty
1011: ,plan_rsrc_qty = p_batch_step_resources.plan_rsrc_qty
1012: ,last_update_login = gme_common_pvt.g_login_id
1013: ,calculate_charges = p_batch_step_resources.calculate_charges
1014: ,original_rsrc_qty = p_batch_step_resources.original_rsrc_qty
1015: ,original_rsrc_usage =
1016: p_batch_step_resources.original_rsrc_usage

Line 1029: gme_common_pvt.log_message ('GME_NO_KEYS'

1025: p_batch_step_resources.batchstep_activity_id
1026: AND resources = p_batch_step_resources.resources
1027: AND last_update_date = p_batch_step_resources.last_update_date;
1028: ELSE
1029: gme_common_pvt.log_message ('GME_NO_KEYS'
1030: ,'TABLE_NAME'
1031: ,g_table_name);
1032: RETURN FALSE;
1033: END IF;

Line 1039: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1035: IF SQL%FOUND THEN
1036: RETURN TRUE;
1037: ELSE
1038: IF l_dummy = 0 THEN
1039: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1040: ,'TABLE_NAME'
1041: ,g_table_name);
1042: ELSE
1043: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1043: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1039: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1040: ,'TABLE_NAME'
1041: ,g_table_name);
1042: ELSE
1043: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1044: ,'TABLE_NAME'
1045: ,g_table_name);
1046: END IF;
1047:

Line 1053: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1049: END IF;
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN
1052: IF l_dummy = 0 THEN
1053: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1054: ,'TABLE_NAME'
1055: ,g_table_name);
1056: ELSE
1057: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1057: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1053: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1054: ,'TABLE_NAME'
1055: ,g_table_name);
1056: ELSE
1057: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1058: ,'TABLE_NAME'
1059: ,g_table_name);
1060: END IF;
1061:

Line 1064: gme_common_pvt.log_message

1060: END IF;
1061:
1062: RETURN FALSE;
1063: WHEN locked_by_other_user THEN
1064: gme_common_pvt.log_message
1065: ('GME_RECORD_LOCKED'
1066: ,'TABLE_NAME'
1067: ,g_table_name
1068: ,'RECORD'

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

1079: || ' Error is '
1080: || SQLERRM);
1081: END IF;
1082:
1083: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1084: RETURN FALSE;
1085: END update_row;
1086:
1087: /* Api start of comments

Line 1149: gme_common_pvt.log_message

1145:
1146: RETURN TRUE;
1147: EXCEPTION
1148: WHEN app_exception.record_lock_exception THEN
1149: gme_common_pvt.log_message
1150: ('GME_RECORD_LOCKED'
1151: ,'TABLE_NAME'
1152: ,g_table_name
1153: ,'RECORD'