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_DEBUG

Line 233: IF g_debug <= gme_debug.g_log_unexpected THEN

229:
230: RETURN TRUE;
231: EXCEPTION
232: WHEN OTHERS THEN
233: IF g_debug <= gme_debug.g_log_unexpected THEN
234: gme_debug.put_line ( 'When others exception in '
235: || g_pkg_name
236: || '.'
237: || l_api_name

Line 234: gme_debug.put_line ( 'When others exception in '

230: RETURN TRUE;
231: EXCEPTION
232: WHEN OTHERS THEN
233: IF g_debug <= gme_debug.g_log_unexpected THEN
234: gme_debug.put_line ( 'When others exception in '
235: || g_pkg_name
236: || '.'
237: || l_api_name
238: || ' Error is '

Line 635: IF g_debug <= gme_debug.g_log_unexpected THEN

631: ,'TABLE_NAME'
632: ,g_table_name);
633: RETURN FALSE;
634: WHEN OTHERS THEN
635: IF g_debug <= gme_debug.g_log_unexpected THEN
636: gme_debug.put_line ( 'When others exception in '
637: || g_pkg_name
638: || '.'
639: || l_api_name

Line 636: gme_debug.put_line ( 'When others exception in '

632: ,g_table_name);
633: RETURN FALSE;
634: WHEN OTHERS THEN
635: IF g_debug <= gme_debug.g_log_unexpected THEN
636: gme_debug.put_line ( 'When others exception in '
637: || g_pkg_name
638: || '.'
639: || l_api_name
640: || ' Error is '

Line 764: IF g_debug <= gme_debug.g_log_unexpected THEN

760: ,'KEY'
761: ,TO_CHAR (p_material_detail.line_no) );
762: RETURN FALSE;
763: WHEN OTHERS THEN
764: IF g_debug <= gme_debug.g_log_unexpected THEN
765: gme_debug.put_line ( 'When others exception in '
766: || g_pkg_name
767: || '.'
768: || l_api_name

Line 765: gme_debug.put_line ( 'When others exception in '

761: ,TO_CHAR (p_material_detail.line_no) );
762: RETURN FALSE;
763: WHEN OTHERS THEN
764: IF g_debug <= gme_debug.g_log_unexpected THEN
765: gme_debug.put_line ( 'When others exception in '
766: || g_pkg_name
767: || '.'
768: || l_api_name
769: || ' Error is '

Line 829: IF g_debug <= gme_debug.g_log_statement THEN

825: l_batch_id := p_material_detail.batch_id;
826: l_line_no := p_material_detail.line_no;
827: l_line_type := p_material_detail.line_type;
828:
829: IF g_debug <= gme_debug.g_log_statement THEN
830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
833: gme_debug.put_line ('batch detail id is '||l_batch_id);

Line 830: gme_debug.put_line ('Entering '||l_api_name);

826: l_line_no := p_material_detail.line_no;
827: l_line_type := p_material_detail.line_type;
828:
829: IF g_debug <= gme_debug.g_log_statement THEN
830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
833: gme_debug.put_line ('batch detail id is '||l_batch_id);
834: gme_debug.put_line ('line no is '||l_line_no);

Line 831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');

827: l_line_type := p_material_detail.line_type;
828:
829: IF g_debug <= gme_debug.g_log_statement THEN
830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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);

Line 832: gme_debug.put_line ('material detail id is '||l_material_detail_id);

828:
829: IF g_debug <= gme_debug.g_log_statement THEN
830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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'));

Line 833: gme_debug.put_line ('batch detail id is '||l_batch_id);

829: IF g_debug <= gme_debug.g_log_statement THEN
830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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'));

Line 834: gme_debug.put_line ('line no is '||l_line_no);

830: gme_debug.put_line ('Entering '||l_api_name);
831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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;

Line 835: gme_debug.put_line ('l_line_type is '||l_line_type);

831: gme_debug.put_line ('Lets see what is really happening in db layer upon update.');
832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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:

Line 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'));

832: gme_debug.put_line ('material detail id is '||l_material_detail_id);
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

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 1029: IF g_debug <= gme_debug.g_log_statement THEN

1025: IF (SQL%FOUND) THEN
1026: RETURN TRUE;
1027: ELSE
1028:
1029: IF g_debug <= gme_debug.g_log_statement THEN
1030: gme_debug.put_line ('Lets see why update is failing. POINT 1');
1031: IF (l_dummy IS NULL) THEN
1032: gme_debug.put_line ('l_dummy is NULL');
1033: ELSE

Line 1030: gme_debug.put_line ('Lets see why update is failing. POINT 1');

1026: RETURN TRUE;
1027: ELSE
1028:
1029: IF g_debug <= gme_debug.g_log_statement THEN
1030: gme_debug.put_line ('Lets see why update is failing. POINT 1');
1031: IF (l_dummy IS NULL) THEN
1032: gme_debug.put_line ('l_dummy is NULL');
1033: ELSE
1034: gme_debug.put_line ('l_dummy is '||l_dummy);

Line 1032: gme_debug.put_line ('l_dummy is NULL');

1028:
1029: IF g_debug <= gme_debug.g_log_statement THEN
1030: gme_debug.put_line ('Lets see why update is failing. POINT 1');
1031: IF (l_dummy IS NULL) THEN
1032: gme_debug.put_line ('l_dummy is NULL');
1033: ELSE
1034: gme_debug.put_line ('l_dummy is '||l_dummy);
1035: END IF;
1036: gme_debug.put_line ('DB LUP date is '||TO_CHAR(l_upd,'DD-MON-YYYY HH24:MI:SS'));

Line 1034: gme_debug.put_line ('l_dummy is '||l_dummy);

1030: gme_debug.put_line ('Lets see why update is failing. POINT 1');
1031: IF (l_dummy IS NULL) THEN
1032: gme_debug.put_line ('l_dummy is NULL');
1033: ELSE
1034: gme_debug.put_line ('l_dummy is '||l_dummy);
1035: END IF;
1036: gme_debug.put_line ('DB LUP date is '||TO_CHAR(l_upd,'DD-MON-YYYY HH24:MI:SS'));
1037: END IF;
1038:

Line 1036: gme_debug.put_line ('DB LUP date is '||TO_CHAR(l_upd,'DD-MON-YYYY HH24:MI:SS'));

1032: gme_debug.put_line ('l_dummy is NULL');
1033: ELSE
1034: gme_debug.put_line ('l_dummy is '||l_dummy);
1035: END IF;
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'

Line 1053: IF g_debug <= gme_debug.g_log_statement THEN

1049: RETURN FALSE;
1050: END IF;
1051: EXCEPTION
1052: WHEN NO_DATA_FOUND THEN
1053: IF g_debug <= gme_debug.g_log_statement THEN
1054: gme_debug.put_line ('Lets see why update is failing. POINT 2');
1055: IF (l_dummy IS NULL) THEN
1056: gme_debug.put_line ('l_dummy is NULL');
1057: ELSE

Line 1054: gme_debug.put_line ('Lets see why update is failing. POINT 2');

1050: END IF;
1051: EXCEPTION
1052: WHEN NO_DATA_FOUND THEN
1053: IF g_debug <= gme_debug.g_log_statement THEN
1054: gme_debug.put_line ('Lets see why update is failing. POINT 2');
1055: IF (l_dummy IS NULL) THEN
1056: gme_debug.put_line ('l_dummy is NULL');
1057: ELSE
1058: gme_debug.put_line ('l_dummy is '||l_dummy);

Line 1056: gme_debug.put_line ('l_dummy is NULL');

1052: WHEN NO_DATA_FOUND THEN
1053: IF g_debug <= gme_debug.g_log_statement THEN
1054: gme_debug.put_line ('Lets see why update is failing. POINT 2');
1055: IF (l_dummy IS NULL) THEN
1056: gme_debug.put_line ('l_dummy is NULL');
1057: ELSE
1058: gme_debug.put_line ('l_dummy is '||l_dummy);
1059: END IF;
1060: END IF;

Line 1058: gme_debug.put_line ('l_dummy is '||l_dummy);

1054: gme_debug.put_line ('Lets see why update is failing. POINT 2');
1055: IF (l_dummy IS NULL) THEN
1056: gme_debug.put_line ('l_dummy is NULL');
1057: ELSE
1058: gme_debug.put_line ('l_dummy is '||l_dummy);
1059: END IF;
1060: END IF;
1061:
1062: IF NVL(l_dummy,0) = 0 THEN

Line 1083: IF g_debug <= gme_debug.g_log_unexpected THEN

1079: ,'KEY'
1080: ,TO_CHAR (p_material_detail.line_no) );
1081: RETURN FALSE;
1082: WHEN OTHERS THEN
1083: IF g_debug <= gme_debug.g_log_unexpected THEN
1084: gme_debug.put_line ( 'When others exception in '
1085: || g_pkg_name
1086: || '.'
1087: || l_api_name

Line 1084: gme_debug.put_line ( 'When others exception in '

1080: ,TO_CHAR (p_material_detail.line_no) );
1081: RETURN FALSE;
1082: WHEN OTHERS THEN
1083: IF g_debug <= gme_debug.g_log_unexpected THEN
1084: gme_debug.put_line ( 'When others exception in '
1085: || g_pkg_name
1086: || '.'
1087: || l_api_name
1088: || ' Error is '

Line 1155: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1151: WHERE batch_id = l_batch_id
1152: AND line_no = l_line_no
1153: AND line_type = l_line_type;
1154: BEGIN
1155: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1156: gme_debug.put_line ( l_api_name
1157: || ' in fetch_tab. batch_id= '
1158: || p_material_detail.batch_id);
1159: END IF;

Line 1156: gme_debug.put_line ( l_api_name

1152: AND line_no = l_line_no
1153: AND line_type = l_line_type;
1154: BEGIN
1155: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1156: gme_debug.put_line ( l_api_name
1157: || ' in fetch_tab. batch_id= '
1158: || p_material_detail.batch_id);
1159: END IF;
1160:

Line 1237: IF g_debug <= gme_debug.g_log_unexpected THEN

1233: ,'TABLE_NAME'
1234: ,g_table_name);
1235: RETURN FALSE;
1236: WHEN OTHERS THEN
1237: IF g_debug <= gme_debug.g_log_unexpected THEN
1238: gme_debug.put_line ( 'When others exception in '
1239: || g_pkg_name
1240: || '.'
1241: || l_api_name

Line 1238: gme_debug.put_line ( 'When others exception in '

1234: ,g_table_name);
1235: RETURN FALSE;
1236: WHEN OTHERS THEN
1237: IF g_debug <= gme_debug.g_log_unexpected THEN
1238: gme_debug.put_line ( 'When others exception in '
1239: || g_pkg_name
1240: || '.'
1241: || l_api_name
1242: || ' Error is '