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_PROCESS_PARAMETERS_PVT dependencies on GME_DEBUG

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

76: l_resources VARCHAR2 (16);
77: l_batch_header gme_batch_header%ROWTYPE;
78: l_resource_row gme_batch_step_resources%ROWTYPE;
79: BEGIN
80: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
81: gme_debug.put_line ('Calling public Insert process parameters Row');
82: END IF;
83:
84: x_return_status := fnd_api.g_ret_sts_success;

Line 81: gme_debug.put_line ('Calling public Insert process parameters Row');

77: l_batch_header gme_batch_header%ROWTYPE;
78: l_resource_row gme_batch_step_resources%ROWTYPE;
79: BEGIN
80: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
81: gme_debug.put_line ('Calling public Insert process parameters Row');
82: END IF;
83:
84: x_return_status := fnd_api.g_ret_sts_success;
85:

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

138: ,x_proc_param_id => l_proc_param_id
139: ,x_step_status => l_step_status
140: ,x_return_status => l_return_status);
141:
142: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
143: gme_debug.put_line ( 'after validate_process_param '
144: || l_return_status);
145: END IF;
146:

Line 143: gme_debug.put_line ( 'after validate_process_param '

139: ,x_step_status => l_step_status
140: ,x_return_status => l_return_status);
141:
142: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
143: gme_debug.put_line ( 'after validate_process_param '
144: || l_return_status);
145: END IF;
146:
147: IF l_return_status <> 'S' THEN

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

154: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
155: RAISE invalid_step_status;
156: END IF;
157:
158: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
159: gme_debug.put_line ('after step status');
160: END IF;
161:
162: -- Get process parameters details from GMP tables

Line 159: gme_debug.put_line ('after step status');

155: RAISE invalid_step_status;
156: END IF;
157:
158: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
159: gme_debug.put_line ('after step status');
160: END IF;
161:
162: -- Get process parameters details from GMP tables
163: OPEN cur_process_parameter (p_parameter);

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

176: END IF;
177:
178: CLOSE cur_process_parameter;
179:
180: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
181: gme_debug.put_line ('after getting param details ');
182: END IF;
183:
184: -- Check for target value

Line 181: gme_debug.put_line ('after getting param details ');

177:
178: CLOSE cur_process_parameter;
179:
180: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
181: gme_debug.put_line ('after getting param details ');
182: END IF;
183:
184: -- Check for target value
185: IF p_process_param_rec.target_value IS NOT NULL THEN

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

264: END IF; /* l_parameter_type = 2*/
265: END IF; /* p_process_param_rec.actual_value IS NOT NULL*/
266: END IF; /* l_step_status IN (2,3)*/
267:
268: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
269: gme_debug.put_line ('after validate actual value');
270: END IF;
271:
272: --Validate flex fields

Line 269: gme_debug.put_line ('after validate actual value');

265: END IF; /* p_process_param_rec.actual_value IS NOT NULL*/
266: END IF; /* l_step_status IN (2,3)*/
267:
268: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
269: gme_debug.put_line ('after validate actual value');
270: END IF;
271:
272: --Validate flex fields
273: /* Nsinha as part of GME_Process_Parameter_APIs_TD

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

278: ,p_validate_flexfields => p_validate_flexfields
279: ,x_process_param_rec => l_process_param_rec
280: ,x_return_status => l_return_status);
281:
282: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
283: gme_debug.put_line ('validate flex return ' || l_return_status);
284: END IF;
285:
286: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 283: gme_debug.put_line ('validate flex return ' || l_return_status);

279: ,x_process_param_rec => l_process_param_rec
280: ,x_return_status => l_return_status);
281:
282: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
283: gme_debug.put_line ('validate flex return ' || l_return_status);
284: END IF;
285:
286: IF l_return_status <> fnd_api.g_ret_sts_success THEN
287: RAISE validation_failure;

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

286: IF l_return_status <> fnd_api.g_ret_sts_success THEN
287: RAISE validation_failure;
288: END IF;
289:
290: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
291: gme_debug.put_line ('after validate flex fields');
292: END IF;
293:
294: l_process_param_rec.batch_id := l_batch_id;

Line 291: gme_debug.put_line ('after validate flex fields');

287: RAISE validation_failure;
288: END IF;
289:
290: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
291: gme_debug.put_line ('after validate flex fields');
292: END IF;
293:
294: l_process_param_rec.batch_id := l_batch_id;
295: l_process_param_rec.batchstep_id := l_batchstep_id;

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

309: l_process_param_rec.target_value := p_process_param_rec.target_value;
310: l_process_param_rec.actual_value := p_process_param_rec.actual_value;
311: END IF;
312:
313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
314: gme_debug.put_line ('call insert ' || x_return_status);
315: END IF;
316:
317: /* Nsinha as part of GME_Process_Parameter_APIs_TD:

Line 314: gme_debug.put_line ('call insert ' || x_return_status);

310: l_process_param_rec.actual_value := p_process_param_rec.actual_value;
311: END IF;
312:
313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
314: gme_debug.put_line ('call insert ' || x_return_status);
315: END IF;
316:
317: /* Nsinha as part of GME_Process_Parameter_APIs_TD:
318: Replaced the call to gme_api_process_parameters.insert_process_param

Line 327: IF g_debug <= gme_debug.g_log_procedure THEN

323: ,x_process_parameters => x_process_param_rec) THEN
324: RAISE fnd_api.g_exc_error;
325: END IF;
326:
327: IF g_debug <= gme_debug.g_log_procedure THEN
328: gme_debug.put_line ( g_pkg_name
329: || '.'
330: || l_api_name
331: || ':'

Line 328: gme_debug.put_line ( g_pkg_name

324: RAISE fnd_api.g_exc_error;
325: END IF;
326:
327: IF g_debug <= gme_debug.g_log_procedure THEN
328: gme_debug.put_line ( g_pkg_name
329: || '.'
330: || l_api_name
331: || ':'
332: || 'Exiting with '

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

429: l_value NUMBER;
430: l_flex_validate BOOLEAN := FALSE;
431: l_field_updated BOOLEAN := FALSE;
432: BEGIN
433: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
434: gme_debug.put_line ('Calling public update process parameters Row');
435: END IF;
436:
437: /* Initially let us assign the return status to success */

Line 434: gme_debug.put_line ('Calling public update process parameters Row');

430: l_flex_validate BOOLEAN := FALSE;
431: l_field_updated BOOLEAN := FALSE;
432: BEGIN
433: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
434: gme_debug.put_line ('Calling public update process parameters Row');
435: END IF;
436:
437: /* Initially let us assign the return status to success */
438: x_return_status := fnd_api.g_ret_sts_success;

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

503: ,x_proc_param_id => l_proc_param_id
504: ,x_step_status => l_step_status
505: ,x_return_status => l_return_status);
506:
507: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
508: gme_debug.put_line ( 'after validate_process_param '
509: || l_return_status);
510: END IF;
511:

Line 508: gme_debug.put_line ( 'after validate_process_param '

504: ,x_step_status => l_step_status
505: ,x_return_status => l_return_status);
506:
507: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
508: gme_debug.put_line ( 'after validate_process_param '
509: || l_return_status);
510: END IF;
511:
512: IF l_return_status <> 'S' THEN

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

582: ,p_validate_flexfields => p_validate_flexfields
583: ,x_process_param_rec => l_process_param_rec
584: ,x_return_status => l_return_status);
585:
586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
587: gme_debug.put_line ('validate flex return ' || l_return_status);
588: END IF;
589:
590: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 587: gme_debug.put_line ('validate flex return ' || l_return_status);

583: ,x_process_param_rec => l_process_param_rec
584: ,x_return_status => l_return_status);
585:
586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
587: gme_debug.put_line ('validate flex return ' || l_return_status);
588: END IF;
589:
590: IF l_return_status <> fnd_api.g_ret_sts_success THEN
591: RAISE validation_failure;

Line 609: IF g_debug <= gme_debug.g_log_procedure THEN

605: END IF;
606:
607: x_process_param_rec := l_process_param_rec;
608:
609: IF g_debug <= gme_debug.g_log_procedure THEN
610: gme_debug.put_line ( g_pkg_name
611: || '.'
612: || l_api_name
613: || ':'

Line 610: gme_debug.put_line ( g_pkg_name

606:
607: x_process_param_rec := l_process_param_rec;
608:
609: IF g_debug <= gme_debug.g_log_procedure THEN
610: gme_debug.put_line ( g_pkg_name
611: || '.'
612: || l_api_name
613: || ':'
614: || 'Exiting with '

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

693: l_step_status NUMBER;
694: l_parameter_id NUMBER;
695: l_batch_status NUMBER;
696: BEGIN
697: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
698: gme_debug.put_line ('Calling public delete process parameters Row');
699: END IF;
700:
701: IF (p_parameter IS NULL AND p_process_param_rec.process_param_id IS NULL) THEN

Line 698: gme_debug.put_line ('Calling public delete process parameters Row');

694: l_parameter_id NUMBER;
695: l_batch_status NUMBER;
696: BEGIN
697: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
698: gme_debug.put_line ('Calling public delete process parameters Row');
699: END IF;
700:
701: IF (p_parameter IS NULL AND p_process_param_rec.process_param_id IS NULL) THEN
702: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

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

754: ,x_proc_param_id => l_proc_param_id
755: ,x_step_status => l_step_status
756: ,x_return_status => l_return_status);
757:
758: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
759: gme_debug.put_line ( 'after validate_process_param '
760: || l_return_status);
761: END IF;
762:

Line 759: gme_debug.put_line ( 'after validate_process_param '

755: ,x_step_status => l_step_status
756: ,x_return_status => l_return_status);
757:
758: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
759: gme_debug.put_line ( 'after validate_process_param '
760: || l_return_status);
761: END IF;
762:
763: IF l_return_status <> 'S' THEN

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

936: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
937: RAISE batch_header_fetch_error;
938: END IF;
939:
940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
941: gme_debug.put_line ('validation- after batch fetch');
942: END IF;
943:
944: x_batch_id := l_batch_header.batch_id;

Line 941: gme_debug.put_line ('validation- after batch fetch');

937: RAISE batch_header_fetch_error;
938: END IF;
939:
940: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
941: gme_debug.put_line ('validation- after batch fetch');
942: END IF;
943:
944: x_batch_id := l_batch_header.batch_id;
945: -- use batch_id to fetch batchstep_id

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

949: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_steps, l_batch_steps) ) THEN
950: RAISE batch_steps_fetch_error;
951: END IF;
952:
953: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
954: gme_debug.put_line ('validation- after step fetch');
955: END IF;
956:
957: x_step_status := l_batch_steps.step_status;

Line 954: gme_debug.put_line ('validation- after step fetch');

950: RAISE batch_steps_fetch_error;
951: END IF;
952:
953: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
954: gme_debug.put_line ('validation- after step fetch');
955: END IF;
956:
957: x_step_status := l_batch_steps.step_status;
958: x_batchstep_id := l_batch_steps.batchstep_id;

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

990: ,p_batchstep_no);
991: RAISE stepactivity_not_found;
992: END IF;
993:
994: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
995: gme_debug.put_line ('validation- after activity check');
996: END IF;
997:
998: -- If resource was not found in any activity then report error

Line 995: gme_debug.put_line ('validation- after activity check');

991: RAISE stepactivity_not_found;
992: END IF;
993:
994: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
995: gme_debug.put_line ('validation- after activity check');
996: END IF;
997:
998: -- If resource was not found in any activity then report error
999: IF l_rsrc_not_found THEN

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

1004: ,p_activity);
1005: RAISE resource_not_found;
1006: END IF;
1007:
1008: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1009: gme_debug.put_line ('validation- after duplicate resource');
1010: END IF;
1011:
1012: -- if same activity and resource combination exists then raise error

Line 1009: gme_debug.put_line ('validation- after duplicate resource');

1005: RAISE resource_not_found;
1006: END IF;
1007:
1008: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1009: gme_debug.put_line ('validation- after duplicate resource');
1010: END IF;
1011:
1012: -- if same activity and resource combination exists then raise error
1013: OPEN cur_check_act_resource (x_batchstep_id

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

1030: END IF;
1031:
1032: CLOSE cur_check_act_resource;
1033:
1034: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1035: gme_debug.put_line ('validation- after act-resource check');
1036: END IF;
1037:
1038: -- check teh parameter exists in gmp

Line 1035: gme_debug.put_line ('validation- after act-resource check');

1031:
1032: CLOSE cur_check_act_resource;
1033:
1034: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1035: gme_debug.put_line ('validation- after act-resource check');
1036: END IF;
1037:
1038: -- check teh parameter exists in gmp
1039: IF p_parameter IS NOT NULL THEN

Line 1061: gme_debug.put_line ( 'validation- after act-resource check'

1057: x_parameter_id := l_parameter_id;
1058:
1059: -- check for process parameter for update and delete only
1060: IF p_parameter IS NOT NULL THEN
1061: gme_debug.put_line ( 'validation- after act-resource check'
1062: || x_resource_id
1063: || 'p_parameter');
1064:
1065: FOR process_param IN cur_get_parameter (x_resource_id, p_parameter) LOOP

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

1079: RAISE param_not_found;
1080: END IF;
1081: END IF;
1082:
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ('validation- after process parameter');
1085: END IF;
1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1084: gme_debug.put_line ('validation- after process parameter');

1080: END IF;
1081: END IF;
1082:
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ('validation- after process parameter');
1085: END IF;
1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);

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

1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ('validation- after process parameter');
1085: END IF;
1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);

Line 1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);

1084: gme_debug.put_line ('validation- after process parameter');
1085: END IF;
1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);

Line 1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);

1085: END IF;
1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);
1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);

Line 1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);

1086:
1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);
1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);
1094: END IF;

Line 1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);

1087: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);
1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);
1094: END IF;
1095: EXCEPTION

Line 1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);

1088: gme_debug.put_line ('validation-batch_id' || x_batch_id);
1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);
1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);
1094: END IF;
1095: EXCEPTION
1096: WHEN setup_failure THEN

Line 1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);

1089: gme_debug.put_line ('validation-x_batchstep_id' || x_batchstep_id);
1090: gme_debug.put_line ('validation-x_activity_id' || x_activity_id);
1091: gme_debug.put_line ('validation-x_resource_id ' || x_resource_id);
1092: gme_debug.put_line ('validation-x_parameter_id ' || x_parameter_id);
1093: gme_debug.put_line ('validation-x_step_status ' || x_step_status);
1094: END IF;
1095: EXCEPTION
1096: WHEN setup_failure THEN
1097: x_return_status := fnd_api.g_ret_sts_error;