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 104: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

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

Line 105: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

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

Line 108: ,0, gme_common_pvt.g_wip_entity_type_batch

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

Line 109: ,gme_common_pvt.g_wip_entity_type_fpo)

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

Line 185: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

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

Line 186: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

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

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

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

Line 663: gme_common_pvt.log_message ('GME_NO_KEYS'

659: WHERE organization_id = p_batch_header.organization_id
660: AND batch_no = p_batch_header.batch_no
661: AND batch_type = p_batch_header.batch_type;
662: ELSE
663: gme_common_pvt.log_message ('GME_NO_KEYS'
664: ,'TABLE_NAME'
665: ,g_table_name);
666: RETURN FALSE;
667: END IF;

Line 677: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

673: x_batch_header := l_gme_batch_header;
674: RETURN TRUE;
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN
677: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
678: ,'TABLE_NAME'
679: ,g_table_name);
680: RETURN FALSE;
681: WHEN OTHERS THEN

Line 771: gme_common_pvt.log_message ('GME_NO_KEYS'

767: WHERE organization_id = p_batch_header.organization_id
768: AND batch_no = p_batch_header.batch_no
769: AND batch_type = p_batch_header.batch_type;
770: ELSE
771: gme_common_pvt.log_message ('GME_NO_KEYS'
772: ,'TABLE_NAME'
773: ,g_table_name);
774: RETURN FALSE;
775: END IF;

Line 781: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

777: IF (SQL%FOUND) THEN
778: RETURN TRUE;
779: ELSE
780: IF l_dummy = 0 THEN
781: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
782: ,'TABLE_NAME'
783: ,g_table_name);
784: ELSE
785: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 785: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

781: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
782: ,'TABLE_NAME'
783: ,g_table_name);
784: ELSE
785: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
786: ,'TABLE_NAME'
787: ,g_table_name);
788: RETURN FALSE;
789: END IF;

Line 799: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

795:
796: RETURN TRUE;
797: EXCEPTION
798: WHEN locked_by_other_user THEN
799: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
800: ,'TABLE_NAME'
801: ,g_table_name
802: ,'RECORD'
803: ,'Batch'

Line 880: gme_common_pvt.set_timestamp;

876: --
877: -- bug 14023053
878: -- Reiniitalizaing the timestamp before saving
879: --
880: gme_common_pvt.set_timestamp;
881:
882: IF l_batch_id IS NOT NULL THEN
883: SELECT 1
884: INTO l_dummy

Line 908: ,last_update_date = gme_common_pvt.g_timestamp

904: ,poc_ind = p_batch_header.poc_ind
905: ,actual_cost_ind = p_batch_header.actual_cost_ind
906: ,gl_posted_ind = p_batch_header.gl_posted_ind
907: ,update_inventory_ind = p_batch_header.update_inventory_ind
908: ,last_update_date = gme_common_pvt.g_timestamp
909: ,last_updated_by = gme_common_pvt.g_user_ident
910: ,last_update_login = gme_common_pvt.g_login_id
911: ,delete_mark = p_batch_header.delete_mark
912: ,text_code = p_batch_header.text_code

Line 909: ,last_updated_by = gme_common_pvt.g_user_ident

905: ,actual_cost_ind = p_batch_header.actual_cost_ind
906: ,gl_posted_ind = p_batch_header.gl_posted_ind
907: ,update_inventory_ind = p_batch_header.update_inventory_ind
908: ,last_update_date = gme_common_pvt.g_timestamp
909: ,last_updated_by = gme_common_pvt.g_user_ident
910: ,last_update_login = gme_common_pvt.g_login_id
911: ,delete_mark = p_batch_header.delete_mark
912: ,text_code = p_batch_header.text_code
913: ,parentline_id = p_batch_header.parentline_id

Line 910: ,last_update_login = gme_common_pvt.g_login_id

906: ,gl_posted_ind = p_batch_header.gl_posted_ind
907: ,update_inventory_ind = p_batch_header.update_inventory_ind
908: ,last_update_date = gme_common_pvt.g_timestamp
909: ,last_updated_by = gme_common_pvt.g_user_ident
910: ,last_update_login = gme_common_pvt.g_login_id
911: ,delete_mark = p_batch_header.delete_mark
912: ,text_code = p_batch_header.text_code
913: ,parentline_id = p_batch_header.parentline_id
914: ,fpo_id = p_batch_header.fpo_id

Line 1010: ,last_update_date = gme_common_pvt.g_timestamp

1006: ,poc_ind = p_batch_header.poc_ind
1007: ,actual_cost_ind = p_batch_header.actual_cost_ind
1008: ,gl_posted_ind = p_batch_header.gl_posted_ind
1009: ,update_inventory_ind = p_batch_header.update_inventory_ind
1010: ,last_update_date = gme_common_pvt.g_timestamp
1011: ,last_updated_by = gme_common_pvt.g_user_ident
1012: ,last_update_login = gme_common_pvt.g_login_id
1013: ,delete_mark = p_batch_header.delete_mark
1014: ,text_code = p_batch_header.text_code

Line 1011: ,last_updated_by = gme_common_pvt.g_user_ident

1007: ,actual_cost_ind = p_batch_header.actual_cost_ind
1008: ,gl_posted_ind = p_batch_header.gl_posted_ind
1009: ,update_inventory_ind = p_batch_header.update_inventory_ind
1010: ,last_update_date = gme_common_pvt.g_timestamp
1011: ,last_updated_by = gme_common_pvt.g_user_ident
1012: ,last_update_login = gme_common_pvt.g_login_id
1013: ,delete_mark = p_batch_header.delete_mark
1014: ,text_code = p_batch_header.text_code
1015: ,parentline_id = p_batch_header.parentline_id

Line 1012: ,last_update_login = gme_common_pvt.g_login_id

1008: ,gl_posted_ind = p_batch_header.gl_posted_ind
1009: ,update_inventory_ind = p_batch_header.update_inventory_ind
1010: ,last_update_date = gme_common_pvt.g_timestamp
1011: ,last_updated_by = gme_common_pvt.g_user_ident
1012: ,last_update_login = gme_common_pvt.g_login_id
1013: ,delete_mark = p_batch_header.delete_mark
1014: ,text_code = p_batch_header.text_code
1015: ,parentline_id = p_batch_header.parentline_id
1016: ,fpo_id = p_batch_header.fpo_id

Line 1077: gme_common_pvt.log_message ('GME_NO_KEYS'

1073: AND batch_no = p_batch_header.batch_no
1074: AND batch_type = p_batch_header.batch_type
1075: AND last_update_date = p_batch_header.last_update_date;
1076: ELSE
1077: gme_common_pvt.log_message ('GME_NO_KEYS'
1078: ,'TABLE_NAME'
1079: ,g_table_name);
1080: RETURN FALSE;
1081: END IF;

Line 1095: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1091: RETURN TRUE;
1092: EXCEPTION
1093: WHEN NO_DATA_FOUND THEN
1094: IF l_dummy = 0 THEN
1095: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1096: ,'TABLE_NAME'
1097: ,g_table_name);
1098: ELSE
1099: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1099: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1095: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1096: ,'TABLE_NAME'
1097: ,g_table_name);
1098: ELSE
1099: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1100: ,'TABLE_NAME'
1101: ,g_table_name);
1102: END IF;
1103:

Line 1106: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1102: END IF;
1103:
1104: RETURN FALSE;
1105: WHEN locked_by_other_user THEN
1106: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1107: ,'TABLE_NAME'
1108: ,g_table_name
1109: ,'RECORD'
1110: ,'Batch'

Line 1185: gme_common_pvt.log_message ('GME_NO_KEYS'

1181: AND batch_no = p_batch_header.batch_no
1182: AND batch_type = p_batch_header.batch_type
1183: FOR UPDATE NOWAIT;
1184: ELSE
1185: gme_common_pvt.log_message ('GME_NO_KEYS'
1186: ,'TABLE_NAME'
1187: ,g_table_name);
1188: RETURN FALSE;
1189: END IF;

Line 1198: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1194:
1195: RETURN TRUE;
1196: EXCEPTION
1197: WHEN app_exception.record_lock_exception THEN
1198: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1199: ,'TABLE_NAME'
1200: ,g_table_name
1201: ,'RECORD'
1202: ,'Batch'