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

Line 103: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

99: ,wip_entity_name
100: ,entity_type
101: ,gen_object_id)
102: VALUES (l_wip_entity_id, x_batch_header.organization_id
103: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
105: ,l_prefix||x_batch_header.batch_no
106: ,DECODE (x_batch_header.batch_type
107: ,0, gme_common_pvt.g_wip_entity_type_batch

Line 104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

100: ,entity_type
101: ,gen_object_id)
102: VALUES (l_wip_entity_id, x_batch_header.organization_id
103: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
105: ,l_prefix||x_batch_header.batch_no
106: ,DECODE (x_batch_header.batch_type
107: ,0, gme_common_pvt.g_wip_entity_type_batch
108: ,gme_common_pvt.g_wip_entity_type_fpo)

Line 107: ,0, gme_common_pvt.g_wip_entity_type_batch

103: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
105: ,l_prefix||x_batch_header.batch_no
106: ,DECODE (x_batch_header.batch_type
107: ,0, gme_common_pvt.g_wip_entity_type_batch
108: ,gme_common_pvt.g_wip_entity_type_fpo)
109: ,mtl_gen_object_id_s.NEXTVAL);
110:
111: INSERT INTO gme_batch_header

Line 108: ,gme_common_pvt.g_wip_entity_type_fpo)

104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
105: ,l_prefix||x_batch_header.batch_no
106: ,DECODE (x_batch_header.batch_type
107: ,0, gme_common_pvt.g_wip_entity_type_batch
108: ,gme_common_pvt.g_wip_entity_type_fpo)
109: ,mtl_gen_object_id_s.NEXTVAL);
110:
111: INSERT INTO gme_batch_header
112: (batch_id, batch_no

Line 183: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

179: , x_batch_header.batch_close_date, x_batch_header.poc_ind
180: ,x_batch_header.actual_cost_ind
181: ,x_batch_header.gl_posted_ind
182: ,x_batch_header.update_inventory_ind
183: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
184: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
185: ,gme_common_pvt.g_login_id, 0, x_batch_header.text_code
186: ,x_batch_header.parentline_id, x_batch_header.fpo_id
187: ,x_batch_header.attribute1, x_batch_header.attribute2

Line 184: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

180: ,x_batch_header.actual_cost_ind
181: ,x_batch_header.gl_posted_ind
182: ,x_batch_header.update_inventory_ind
183: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
184: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
185: ,gme_common_pvt.g_login_id, 0, x_batch_header.text_code
186: ,x_batch_header.parentline_id, x_batch_header.fpo_id
187: ,x_batch_header.attribute1, x_batch_header.attribute2
188: ,x_batch_header.attribute3, x_batch_header.attribute4

Line 185: ,gme_common_pvt.g_login_id, 0, x_batch_header.text_code

181: ,x_batch_header.gl_posted_ind
182: ,x_batch_header.update_inventory_ind
183: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
184: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
185: ,gme_common_pvt.g_login_id, 0, x_batch_header.text_code
186: ,x_batch_header.parentline_id, x_batch_header.fpo_id
187: ,x_batch_header.attribute1, x_batch_header.attribute2
188: ,x_batch_header.attribute3, x_batch_header.attribute4
189: ,x_batch_header.attribute5, x_batch_header.attribute6

Line 656: gme_common_pvt.log_message ('GME_NO_KEYS'

652: WHERE organization_id = p_batch_header.organization_id
653: AND batch_no = p_batch_header.batch_no
654: AND batch_type = p_batch_header.batch_type;
655: ELSE
656: gme_common_pvt.log_message ('GME_NO_KEYS'
657: ,'TABLE_NAME'
658: ,g_table_name);
659: RETURN FALSE;
660: END IF;

Line 670: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

666: x_batch_header := l_gme_batch_header;
667: RETURN TRUE;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
671: ,'TABLE_NAME'
672: ,g_table_name);
673: RETURN FALSE;
674: WHEN OTHERS THEN

Line 764: gme_common_pvt.log_message ('GME_NO_KEYS'

760: WHERE organization_id = p_batch_header.organization_id
761: AND batch_no = p_batch_header.batch_no
762: AND batch_type = p_batch_header.batch_type;
763: ELSE
764: gme_common_pvt.log_message ('GME_NO_KEYS'
765: ,'TABLE_NAME'
766: ,g_table_name);
767: RETURN FALSE;
768: END IF;

Line 774: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

770: IF (SQL%FOUND) THEN
771: RETURN TRUE;
772: ELSE
773: IF l_dummy = 0 THEN
774: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
775: ,'TABLE_NAME'
776: ,g_table_name);
777: ELSE
778: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 778: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

774: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
775: ,'TABLE_NAME'
776: ,g_table_name);
777: ELSE
778: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
779: ,'TABLE_NAME'
780: ,g_table_name);
781: RETURN FALSE;
782: END IF;

Line 792: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

788:
789: RETURN TRUE;
790: EXCEPTION
791: WHEN locked_by_other_user THEN
792: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
793: ,'TABLE_NAME'
794: ,g_table_name
795: ,'RECORD'
796: ,'Batch'

Line 895: ,last_update_date = gme_common_pvt.g_timestamp

891: ,poc_ind = p_batch_header.poc_ind
892: ,actual_cost_ind = p_batch_header.actual_cost_ind
893: ,gl_posted_ind = p_batch_header.gl_posted_ind
894: ,update_inventory_ind = p_batch_header.update_inventory_ind
895: ,last_update_date = gme_common_pvt.g_timestamp
896: ,last_updated_by = gme_common_pvt.g_user_ident
897: ,last_update_login = gme_common_pvt.g_login_id
898: ,delete_mark = p_batch_header.delete_mark
899: ,text_code = p_batch_header.text_code

Line 896: ,last_updated_by = gme_common_pvt.g_user_ident

892: ,actual_cost_ind = p_batch_header.actual_cost_ind
893: ,gl_posted_ind = p_batch_header.gl_posted_ind
894: ,update_inventory_ind = p_batch_header.update_inventory_ind
895: ,last_update_date = gme_common_pvt.g_timestamp
896: ,last_updated_by = gme_common_pvt.g_user_ident
897: ,last_update_login = gme_common_pvt.g_login_id
898: ,delete_mark = p_batch_header.delete_mark
899: ,text_code = p_batch_header.text_code
900: ,parentline_id = p_batch_header.parentline_id

Line 897: ,last_update_login = gme_common_pvt.g_login_id

893: ,gl_posted_ind = p_batch_header.gl_posted_ind
894: ,update_inventory_ind = p_batch_header.update_inventory_ind
895: ,last_update_date = gme_common_pvt.g_timestamp
896: ,last_updated_by = gme_common_pvt.g_user_ident
897: ,last_update_login = gme_common_pvt.g_login_id
898: ,delete_mark = p_batch_header.delete_mark
899: ,text_code = p_batch_header.text_code
900: ,parentline_id = p_batch_header.parentline_id
901: ,fpo_id = p_batch_header.fpo_id

Line 996: ,last_update_date = gme_common_pvt.g_timestamp

992: ,poc_ind = p_batch_header.poc_ind
993: ,actual_cost_ind = p_batch_header.actual_cost_ind
994: ,gl_posted_ind = p_batch_header.gl_posted_ind
995: ,update_inventory_ind = p_batch_header.update_inventory_ind
996: ,last_update_date = gme_common_pvt.g_timestamp
997: ,last_updated_by = gme_common_pvt.g_user_ident
998: ,last_update_login = gme_common_pvt.g_login_id
999: ,delete_mark = p_batch_header.delete_mark
1000: ,text_code = p_batch_header.text_code

Line 997: ,last_updated_by = gme_common_pvt.g_user_ident

993: ,actual_cost_ind = p_batch_header.actual_cost_ind
994: ,gl_posted_ind = p_batch_header.gl_posted_ind
995: ,update_inventory_ind = p_batch_header.update_inventory_ind
996: ,last_update_date = gme_common_pvt.g_timestamp
997: ,last_updated_by = gme_common_pvt.g_user_ident
998: ,last_update_login = gme_common_pvt.g_login_id
999: ,delete_mark = p_batch_header.delete_mark
1000: ,text_code = p_batch_header.text_code
1001: ,parentline_id = p_batch_header.parentline_id

Line 998: ,last_update_login = gme_common_pvt.g_login_id

994: ,gl_posted_ind = p_batch_header.gl_posted_ind
995: ,update_inventory_ind = p_batch_header.update_inventory_ind
996: ,last_update_date = gme_common_pvt.g_timestamp
997: ,last_updated_by = gme_common_pvt.g_user_ident
998: ,last_update_login = gme_common_pvt.g_login_id
999: ,delete_mark = p_batch_header.delete_mark
1000: ,text_code = p_batch_header.text_code
1001: ,parentline_id = p_batch_header.parentline_id
1002: ,fpo_id = p_batch_header.fpo_id

Line 1062: gme_common_pvt.log_message ('GME_NO_KEYS'

1058: AND batch_no = p_batch_header.batch_no
1059: AND batch_type = p_batch_header.batch_type
1060: AND last_update_date = p_batch_header.last_update_date;
1061: ELSE
1062: gme_common_pvt.log_message ('GME_NO_KEYS'
1063: ,'TABLE_NAME'
1064: ,g_table_name);
1065: RETURN FALSE;
1066: END IF;

Line 1080: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1076: RETURN TRUE;
1077: EXCEPTION
1078: WHEN NO_DATA_FOUND THEN
1079: IF l_dummy = 0 THEN
1080: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1081: ,'TABLE_NAME'
1082: ,g_table_name);
1083: ELSE
1084: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1084: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1080: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1081: ,'TABLE_NAME'
1082: ,g_table_name);
1083: ELSE
1084: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1085: ,'TABLE_NAME'
1086: ,g_table_name);
1087: END IF;
1088:

Line 1091: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1087: END IF;
1088:
1089: RETURN FALSE;
1090: WHEN locked_by_other_user THEN
1091: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1092: ,'TABLE_NAME'
1093: ,g_table_name
1094: ,'RECORD'
1095: ,'Batch'

Line 1170: gme_common_pvt.log_message ('GME_NO_KEYS'

1166: AND batch_no = p_batch_header.batch_no
1167: AND batch_type = p_batch_header.batch_type
1168: FOR UPDATE NOWAIT;
1169: ELSE
1170: gme_common_pvt.log_message ('GME_NO_KEYS'
1171: ,'TABLE_NAME'
1172: ,g_table_name);
1173: RETURN FALSE;
1174: END IF;

Line 1183: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1179:
1180: RETURN TRUE;
1181: EXCEPTION
1182: WHEN app_exception.record_lock_exception THEN
1183: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1184: ,'TABLE_NAME'
1185: ,g_table_name
1186: ,'RECORD'
1187: ,'Batch'