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 837: gme_debug.put_line ('timestamp is '||TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS'));

833: gme_debug.put_line ('batch detail id is '||l_batch_id);
834: gme_debug.put_line ('line no is '||l_line_no);
835: gme_debug.put_line ('l_line_type is '||l_line_type);
836: gme_debug.put_line ('last_update_date coming in is '||TO_CHAR(p_material_detail.last_update_date,'DD-MON-YYYY HH24:MI:SS'));
837: gme_debug.put_line ('timestamp is '||TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS'));
838: END IF;
839:
840: IF l_material_detail_id IS NOT NULL THEN
841: SELECT 1, last_update_date

Line 867: ,last_updated_by = gme_common_pvt.g_user_ident

863: ,alloc_ind = p_material_detail.alloc_ind
864: ,COST = p_material_detail.COST
865: ,text_code = p_material_detail.text_code
866: ,phantom_id = p_material_detail.phantom_id
867: ,last_updated_by = gme_common_pvt.g_user_ident
868: ,last_update_date = gme_common_pvt.g_timestamp
869: ,attribute1 = p_material_detail.attribute1
870: ,attribute2 = p_material_detail.attribute2
871: ,attribute3 = p_material_detail.attribute3

Line 868: ,last_update_date = gme_common_pvt.g_timestamp

864: ,COST = p_material_detail.COST
865: ,text_code = p_material_detail.text_code
866: ,phantom_id = p_material_detail.phantom_id
867: ,last_updated_by = gme_common_pvt.g_user_ident
868: ,last_update_date = gme_common_pvt.g_timestamp
869: ,attribute1 = p_material_detail.attribute1
870: ,attribute2 = p_material_detail.attribute2
871: ,attribute3 = p_material_detail.attribute3
872: ,attribute4 = p_material_detail.attribute4

Line 955: ,last_updated_by = gme_common_pvt.g_user_ident

951: ,alloc_ind = p_material_detail.alloc_ind
952: ,COST = p_material_detail.COST
953: ,text_code = p_material_detail.text_code
954: ,phantom_id = p_material_detail.phantom_id
955: ,last_updated_by = gme_common_pvt.g_user_ident
956: ,last_update_date = gme_common_pvt.g_timestamp
957: ,attribute1 = p_material_detail.attribute1
958: ,attribute2 = p_material_detail.attribute2
959: ,attribute3 = p_material_detail.attribute3

Line 956: ,last_update_date = gme_common_pvt.g_timestamp

952: ,COST = p_material_detail.COST
953: ,text_code = p_material_detail.text_code
954: ,phantom_id = p_material_detail.phantom_id
955: ,last_updated_by = gme_common_pvt.g_user_ident
956: ,last_update_date = gme_common_pvt.g_timestamp
957: ,attribute1 = p_material_detail.attribute1
958: ,attribute2 = p_material_detail.attribute2
959: ,attribute3 = p_material_detail.attribute3
960: ,attribute4 = p_material_detail.attribute4

Line 1019: gme_common_pvt.log_message ('GME_NO_KEYS'

1015: -- AND last_update_date = p_material_detail.last_update_date;
1016: -- Bug 7710435 Put decode in there to avoid timestamp failures during batch creation.
1017: AND last_update_date = DECODE(p_called_by, 'U', p_material_detail.last_update_date, last_update_date);
1018: ELSE
1019: gme_common_pvt.log_message ('GME_NO_KEYS'
1020: ,'TABLE_NAME'
1021: ,g_table_name);
1022: RETURN FALSE;
1023: END IF;

Line 1040: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1036: gme_debug.put_line ('DB LUP date is '||TO_CHAR(l_upd,'DD-MON-YYYY HH24:MI:SS'));
1037: END IF;
1038:
1039: IF NVL(l_dummy,0) = 0 THEN
1040: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1041: ,'TABLE_NAME'
1042: ,g_table_name);
1043: ELSE
1044: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1044: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

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

Line 1063: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1059: END IF;
1060: END IF;
1061:
1062: IF NVL(l_dummy,0) = 0 THEN
1063: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1064: ,'TABLE_NAME'
1065: ,g_table_name);
1066: ELSE
1067: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 1067: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

1063: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1064: ,'TABLE_NAME'
1065: ,g_table_name);
1066: ELSE
1067: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
1068: ,'TABLE_NAME'
1069: ,g_table_name);
1070: END IF;
1071:

Line 1074: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

1070: END IF;
1071:
1072: RETURN FALSE;
1073: WHEN locked_by_other_user THEN
1074: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
1075: ,'TABLE_NAME'
1076: ,g_table_name
1077: ,'RECORD'
1078: ,'Line No'

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

1088: || ' Error is '
1089: || SQLERRM);
1090: END IF;
1091:
1092: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1093: RETURN FALSE;
1094: END update_row;
1095:
1096: /*

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

1122: +==========================================================================+
1123: */
1124: FUNCTION fetch_tab (
1125: p_material_detail IN gme_material_details%ROWTYPE
1126: ,x_material_detail IN OUT NOCOPY gme_common_pvt.material_details_tab)
1127: RETURN BOOLEAN
1128: IS
1129: i NUMBER := 0;
1130: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_TAB';

Line 1223: gme_common_pvt.log_message ('GME_NO_KEYS'

1219: END IF;
1220:
1221: CLOSE c_material_dtl_2;
1222: ELSE
1223: gme_common_pvt.log_message ('GME_NO_KEYS'
1224: ,'TABLE_NAME'
1225: ,g_table_name);
1226: RETURN FALSE;
1227: END IF;

Line 1232: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

1228:
1229: RETURN TRUE;
1230: EXCEPTION
1231: WHEN NO_DATA_FOUND THEN
1232: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1233: ,'TABLE_NAME'
1234: ,g_table_name);
1235: RETURN FALSE;
1236: WHEN OTHERS THEN

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

1254: IF (c_material_dtl_2%ISOPEN) THEN
1255: CLOSE c_material_dtl_2;
1256: END IF;
1257:
1258: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1259: RETURN FALSE;
1260: END fetch_tab;
1261: END gme_material_details_dbl;