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

Line 164: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

160: ,x_material_detail.cost_alloc
161: ,x_material_detail.alloc_ind, x_material_detail.COST
162: ,x_material_detail.text_code
163: ,x_material_detail.phantom_id
164: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
165: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
166: ,x_material_detail.attribute1
167: ,x_material_detail.attribute2
168: ,x_material_detail.attribute3

Line 165: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp

161: ,x_material_detail.alloc_ind, x_material_detail.COST
162: ,x_material_detail.text_code
163: ,x_material_detail.phantom_id
164: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
165: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
166: ,x_material_detail.attribute1
167: ,x_material_detail.attribute2
168: ,x_material_detail.attribute3
169: ,x_material_detail.attribute4

Line 221: x_material_detail.created_by := gme_common_pvt.g_user_ident;

217: RETURNING material_detail_id
218: INTO x_material_detail.material_detail_id;
219:
220: IF SQL%ROWCOUNT = 1 THEN
221: x_material_detail.created_by := gme_common_pvt.g_user_ident;
222: x_material_detail.creation_date := gme_common_pvt.g_timestamp;
223: x_material_detail.last_updated_by := gme_common_pvt.g_user_ident;
224: x_material_detail.last_update_date := gme_common_pvt.g_timestamp;
225: RETURN TRUE;

Line 222: x_material_detail.creation_date := gme_common_pvt.g_timestamp;

218: INTO x_material_detail.material_detail_id;
219:
220: IF SQL%ROWCOUNT = 1 THEN
221: x_material_detail.created_by := gme_common_pvt.g_user_ident;
222: x_material_detail.creation_date := gme_common_pvt.g_timestamp;
223: x_material_detail.last_updated_by := gme_common_pvt.g_user_ident;
224: x_material_detail.last_update_date := gme_common_pvt.g_timestamp;
225: RETURN TRUE;
226: ELSE

Line 223: x_material_detail.last_updated_by := gme_common_pvt.g_user_ident;

219:
220: IF SQL%ROWCOUNT = 1 THEN
221: x_material_detail.created_by := gme_common_pvt.g_user_ident;
222: x_material_detail.creation_date := gme_common_pvt.g_timestamp;
223: x_material_detail.last_updated_by := gme_common_pvt.g_user_ident;
224: x_material_detail.last_update_date := gme_common_pvt.g_timestamp;
225: RETURN TRUE;
226: ELSE
227: RETURN FALSE;

Line 224: x_material_detail.last_update_date := gme_common_pvt.g_timestamp;

220: IF SQL%ROWCOUNT = 1 THEN
221: x_material_detail.created_by := gme_common_pvt.g_user_ident;
222: x_material_detail.creation_date := gme_common_pvt.g_timestamp;
223: x_material_detail.last_updated_by := gme_common_pvt.g_user_ident;
224: x_material_detail.last_update_date := gme_common_pvt.g_timestamp;
225: RETURN TRUE;
226: ELSE
227: RETURN FALSE;
228: END IF;

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

239: || SQLERRM);
240: END IF;
241:
242: x_material_detail.material_detail_id := NULL;
243: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
244: RETURN FALSE;
245: END insert_row;
246:
247: /* Api start of comments

Line 612: gme_common_pvt.log_message ('GME_NO_KEYS'

608: WHERE batch_id = l_batch_id
609: AND line_no = l_line_no
610: AND line_type = l_line_type;
611: ELSE
612: gme_common_pvt.log_message ('GME_NO_KEYS'
613: ,'TABLE_NAME'
614: ,g_table_name);
615: RETURN FALSE;
616: END IF;

Line 622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

618: IF (SQL%FOUND) THEN
619: x_material_detail := l_gme_material_details;
620: RETURN TRUE;
621: ELSE
622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
623: ,'TABLE_NAME'
624: ,g_table_name);
625: x_material_detail := l_gme_material_details;
626: RETURN FALSE;

Line 630: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

626: RETURN FALSE;
627: END IF;
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
631: ,'TABLE_NAME'
632: ,g_table_name);
633: RETURN FALSE;
634: WHEN OTHERS THEN

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

640: || ' Error is '
641: || SQLERRM);
642: END IF;
643:
644: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
645: RETURN FALSE;
646: END fetch_row;
647:
648: /* Api start of comments

Line 718: gme_common_pvt.log_message ('GME_NO_KEYS'

714: WHERE batch_id = l_batch_id
715: AND line_no = l_line_no
716: AND line_type = l_line_type;
717: ELSE
718: gme_common_pvt.log_message ('GME_NO_KEYS'
719: ,'TABLE_NAME'
720: ,g_table_name);
721: RETURN FALSE;
722: END IF;

Line 728: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

724: IF (SQL%FOUND) THEN
725: RETURN TRUE;
726: ELSE
727: IF l_dummy = 0 THEN
728: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
729: ,'TABLE_NAME'
730: ,g_table_name);
731: ELSE
732: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 732: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

728: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
729: ,'TABLE_NAME'
730: ,g_table_name);
731: ELSE
732: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
733: ,'TABLE_NAME'
734: ,g_table_name);
735: END IF;
736:

Line 744: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

740: RETURN TRUE;
741: EXCEPTION
742: WHEN NO_DATA_FOUND THEN
743: IF l_dummy = 0 THEN
744: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
745: ,'TABLE_NAME'
746: ,g_table_name);
747: ELSE
748: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 748: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

744: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
745: ,'TABLE_NAME'
746: ,g_table_name);
747: ELSE
748: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
749: ,'TABLE_NAME'
750: ,g_table_name);
751: END IF;
752:

Line 755: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

751: END IF;
752:
753: RETURN FALSE;
754: WHEN locked_by_other_user THEN
755: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
756: ,'TABLE_NAME'
757: ,g_table_name
758: ,'RECORD'
759: ,'Line No'

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

769: || ' Error is '
770: || SQLERRM);
771: END IF;
772:
773: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
774: RETURN FALSE;
775: END delete_row;
776:
777: /* Api start of comments

Line 850: ,last_updated_by = gme_common_pvt.g_user_ident

846: ,alloc_ind = p_material_detail.alloc_ind
847: ,COST = p_material_detail.COST
848: ,text_code = p_material_detail.text_code
849: ,phantom_id = p_material_detail.phantom_id
850: ,last_updated_by = gme_common_pvt.g_user_ident
851: ,last_update_date = gme_common_pvt.g_timestamp
852: ,attribute1 = p_material_detail.attribute1
853: ,attribute2 = p_material_detail.attribute2
854: ,attribute3 = p_material_detail.attribute3

Line 851: ,last_update_date = gme_common_pvt.g_timestamp

847: ,COST = p_material_detail.COST
848: ,text_code = p_material_detail.text_code
849: ,phantom_id = p_material_detail.phantom_id
850: ,last_updated_by = gme_common_pvt.g_user_ident
851: ,last_update_date = gme_common_pvt.g_timestamp
852: ,attribute1 = p_material_detail.attribute1
853: ,attribute2 = p_material_detail.attribute2
854: ,attribute3 = p_material_detail.attribute3
855: ,attribute4 = p_material_detail.attribute4

Line 936: ,last_updated_by = gme_common_pvt.g_user_ident

932: ,alloc_ind = p_material_detail.alloc_ind
933: ,COST = p_material_detail.COST
934: ,text_code = p_material_detail.text_code
935: ,phantom_id = p_material_detail.phantom_id
936: ,last_updated_by = gme_common_pvt.g_user_ident
937: ,last_update_date = gme_common_pvt.g_timestamp
938: ,attribute1 = p_material_detail.attribute1
939: ,attribute2 = p_material_detail.attribute2
940: ,attribute3 = p_material_detail.attribute3

Line 937: ,last_update_date = gme_common_pvt.g_timestamp

933: ,COST = p_material_detail.COST
934: ,text_code = p_material_detail.text_code
935: ,phantom_id = p_material_detail.phantom_id
936: ,last_updated_by = gme_common_pvt.g_user_ident
937: ,last_update_date = gme_common_pvt.g_timestamp
938: ,attribute1 = p_material_detail.attribute1
939: ,attribute2 = p_material_detail.attribute2
940: ,attribute3 = p_material_detail.attribute3
941: ,attribute4 = p_material_detail.attribute4

Line 998: gme_common_pvt.log_message ('GME_NO_KEYS'

994: AND line_no = l_line_no
995: AND line_type = l_line_type
996: AND last_update_date = p_material_detail.last_update_date;
997: ELSE
998: gme_common_pvt.log_message ('GME_NO_KEYS'
999: ,'TABLE_NAME'
1000: ,g_table_name);
1001: RETURN FALSE;
1002: END IF;

Line 1008: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1004: IF (SQL%FOUND) THEN
1005: RETURN TRUE;
1006: ELSE
1007: IF l_dummy = 0 THEN
1008: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1009: ,'TABLE_NAME'
1010: ,g_table_name);
1011: ELSE
1012: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1012: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1008: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1009: ,'TABLE_NAME'
1010: ,g_table_name);
1011: ELSE
1012: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1013: ,'TABLE_NAME'
1014: ,g_table_name);
1015: END IF;
1016:

Line 1022: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1018: END IF;
1019: EXCEPTION
1020: WHEN NO_DATA_FOUND THEN
1021: IF l_dummy = 0 THEN
1022: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1023: ,'TABLE_NAME'
1024: ,g_table_name);
1025: ELSE
1026: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1026: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1022: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1023: ,'TABLE_NAME'
1024: ,g_table_name);
1025: ELSE
1026: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1027: ,'TABLE_NAME'
1028: ,g_table_name);
1029: END IF;
1030:

Line 1033: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1029: END IF;
1030:
1031: RETURN FALSE;
1032: WHEN locked_by_other_user THEN
1033: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1034: ,'TABLE_NAME'
1035: ,g_table_name
1036: ,'RECORD'
1037: ,'Line No'

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

1047: || ' Error is '
1048: || SQLERRM);
1049: END IF;
1050:
1051: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1052: RETURN FALSE;
1053: END update_row;
1054:
1055: /*

Line 1085: ,x_material_detail IN OUT NOCOPY gme_common_pvt.material_details_tab)

1081: +==========================================================================+
1082: */
1083: FUNCTION fetch_tab (
1084: p_material_detail IN gme_material_details%ROWTYPE
1085: ,x_material_detail IN OUT NOCOPY gme_common_pvt.material_details_tab)
1086: RETURN BOOLEAN
1087: IS
1088: i NUMBER := 0;
1089: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_TAB';

Line 1182: gme_common_pvt.log_message ('GME_NO_KEYS'

1178: END IF;
1179:
1180: CLOSE c_material_dtl_2;
1181: ELSE
1182: gme_common_pvt.log_message ('GME_NO_KEYS'
1183: ,'TABLE_NAME'
1184: ,g_table_name);
1185: RETURN FALSE;
1186: END IF;

Line 1191: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1187:
1188: RETURN TRUE;
1189: EXCEPTION
1190: WHEN NO_DATA_FOUND THEN
1191: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1192: ,'TABLE_NAME'
1193: ,g_table_name);
1194: RETURN FALSE;
1195: WHEN OTHERS THEN

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

1213: IF (c_material_dtl_2%ISOPEN) THEN
1214: CLOSE c_material_dtl_2;
1215: END IF;
1216:
1217: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1218: RETURN FALSE;
1219: END fetch_tab;
1220: END gme_material_details_dbl;