DBA Data[Home] [Help]

APPS.GME_PROCESS_PARAMETERS_PVT dependencies on GME_COMMON_PVT

Line 87: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

83:
84: x_return_status := fnd_api.g_ret_sts_success;
85:
86: IF p_parameter IS NULL THEN
87: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
88: ,'FIELD_NAME'
89: ,'PROCESS PARAMETER');
90: RAISE input_param_missing;
91: END IF;

Line 100: gme_common_pvt.log_message ('GME_RSRCID_NOT_FOUND'

96: p_process_param_rec.batchstep_resource_id;
97:
98: IF NOT (gme_batch_step_resources_dbl.fetch_row (l_resource_row
99: ,l_resource_row) ) THEN
100: gme_common_pvt.log_message ('GME_RSRCID_NOT_FOUND'
101: ,'BATCHSTEP_RSRC_ID'
102: ,l_resource_row.batchstep_resource_id);
103: RAISE resource_fetch_error;
104: END IF;

Line 121: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');

117:
118: IF cur_validate_batch_type%FOUND THEN
119: CLOSE cur_validate_batch_type;
120:
121: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');
122: RAISE validate_param_failed;
123: END IF;
124:
125: CLOSE cur_validate_batch_type;

Line 154: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

150: END IF; /* p_process_param_rec.batchstep_resource_id IS NOT NULL */
151:
152: -- Check Step Status
153: IF l_step_status IN (4, 5) 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

Line 172: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'

168:
169: IF cur_process_parameter%NOTFOUND THEN
170: CLOSE cur_process_parameter;
171:
172: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'
173: ,'PARAMETER'
174: ,p_parameter);
175: RAISE param_details_not_found;
176: END IF;

Line 192: gme_common_pvt.log_message

188: v_temp := p_process_param_rec.target_value;
189: EXCEPTION
190: WHEN VALUE_ERROR THEN
191: x_return_status := fnd_api.g_ret_sts_error;
192: gme_common_pvt.log_message
193: ('GME_INVALID_FIELD'
194: ,'FIELD'
195: ,'p_process_param_rec.target_value');
196: RETURN;

Line 209: gme_common_pvt.log_message

205:
206: IF cur_process_value%NOTFOUND THEN
207: CLOSE cur_process_value;
208:
209: gme_common_pvt.log_message
210: ('GME_INVALID_FIELD'
211: ,'FIELD'
212: ,'p_process_param_rec.target_value');
213: RAISE wrong_target_value;

Line 243: gme_common_pvt.log_message

239: BEGIN
240: v_temp := p_process_param_rec.actual_value;
241: EXCEPTION
242: WHEN VALUE_ERROR THEN
243: gme_common_pvt.log_message
244: ('GME_INVALID_FIELD'
245: ,'FIELD'
246: ,'p_process_param_rec.actual_value');
247: x_return_status := fnd_api.g_ret_sts_error;

Line 441: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

437: /* Initially let us assign the return status to success */
438: x_return_status := fnd_api.g_ret_sts_success;
439:
440: IF (p_parameter IS NULL AND p_process_param_rec.process_param_id IS NULL) THEN
441: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
442: ,'FIELD_NAME'
443: ,'PROCESS PARAMETERS');
444: RAISE input_param_missing;
445: END IF;

Line 459: gme_common_pvt.log_message ('GME_PARAM_ID_NOT_FOUND'

455:
456: IF cur_validate_parameter%NOTFOUND THEN
457: CLOSE cur_validate_parameter;
458:
459: gme_common_pvt.log_message ('GME_PARAM_ID_NOT_FOUND'
460: ,'PROCESS_PARAM_ID'
461: ,l_proc_param_id);
462: RAISE param_not_found;
463: END IF;

Line 486: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');

482:
483: IF cur_validate_batch_type%FOUND THEN
484: CLOSE cur_validate_batch_type;
485:
486: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');
487: RAISE validate_param_failed;
488: END IF;
489:
490: CLOSE cur_validate_batch_type;

Line 518: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

514: END IF;
515: END IF;
516:
517: IF l_step_status IN (4, 5) THEN
518: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
519: RAISE invalid_step_status;
520: END IF;
521:
522: l_process_param_rec.process_param_id := l_proc_param_id;

Line 545: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

541: CLOSE cur_process_parameter;
542:
543: IF l_step_status IN (2, 3) THEN
544: IF p_process_param_rec.actual_value = fnd_api.g_miss_char THEN
545: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
546: ,'FIELD_NAME'
547: ,'ACTUAL_VALUE');
548: RAISE input_param_missing;
549: ELSIF ( p_process_param_rec.actual_value IS NOT NULL

Line 558: gme_common_pvt.log_message

554: BEGIN
555: v_temp := p_process_param_rec.actual_value;
556: EXCEPTION
557: WHEN VALUE_ERROR THEN
558: gme_common_pvt.log_message
559: ('GME_INVALID_FIELD'
560: ,'FIELD'
561: ,'p_process_param_rec.actual_value');
562: x_return_status := fnd_api.g_ret_sts_error;

Line 595: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');

591: RAISE validation_failure;
592: END IF;
593:
594: IF NOT (l_field_updated) THEN
595: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
596: RAISE no_change;
597: END IF;
598:
599: /* Replace the call to gme_api_process_parameters.update_process_param

Line 702: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

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'
703: ,'FIELD_NAME'
704: ,'PROCESS PARAMETERS');
705: RAISE input_param_missing;
706: END IF;

Line 720: gme_common_pvt.log_message ('GME_PARAM_ID_NOT_FOUND'

716:
717: IF cur_validate_parameter%NOTFOUND THEN
718: CLOSE cur_validate_parameter;
719:
720: gme_common_pvt.log_message ('GME_PARAM_ID_NOT_FOUND'
721: ,'PROCESS_PARAM_ID'
722: ,l_proc_param_id);
723: RAISE param_not_found;
724: END IF;

Line 737: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');

733:
734: IF cur_validate_batch_type%FOUND THEN
735: CLOSE cur_validate_batch_type;
736:
737: gme_common_pvt.log_message ('GME_FPO_PARAM_NO_EDIT');
738: RAISE validate_param_failed;
739: END IF;
740:
741: CLOSE cur_validate_batch_type;

Line 774: gme_common_pvt.log_message('PM_WRONG_STATUS');

770: FETCH cur_validate_batch_status INTO l_batch_status;
771: IF cur_validate_batch_status%FOUND THEN
772: IF l_batch_status <> 1 THEN
773: CLOSE cur_validate_batch_status;
774: gme_common_pvt.log_message('PM_WRONG_STATUS');
775: RAISE invalid_batch_status;
776: END IF;
777: END IF;
778: CLOSE cur_validate_batch_status;

Line 781: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

777: END IF;
778: CLOSE cur_validate_batch_status;
779:
780: /* IF l_step_status <> 1 THEN
781: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
782: RAISE invalid_step_status;
783: END IF;*/
784: /* siva end */
785:

Line 911: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

907: /* Initially let us assign the return status to success */
908: x_return_status := fnd_api.g_ret_sts_success;
909:
910: IF p_activity IS NULL THEN
911: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
912: ,'FIELD_NAME'
913: ,'ACTIVITY');
914: RAISE input_param_missing;
915: ELSIF p_resource IS NULL THEN

Line 916: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'

912: ,'FIELD_NAME'
913: ,'ACTIVITY');
914: RAISE input_param_missing;
915: ELSIF p_resource IS NULL THEN
916: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
917: ,'FIELD_NAME'
918: ,'RESOURCE');
919: RAISE input_param_missing;
920: END IF;

Line 923: gme_common_pvt.g_setup_done :=

919: RAISE input_param_missing;
920: END IF;
921:
922: -- Check setup is done. For all profile/parameter values based on orgn_code/organization_id.
923: gme_common_pvt.g_setup_done :=
924: gme_common_pvt.setup (p_org_code => p_org_code);
925:
926: IF NOT gme_common_pvt.g_setup_done THEN
927: RAISE setup_failure;

Line 924: gme_common_pvt.setup (p_org_code => p_org_code);

920: END IF;
921:
922: -- Check setup is done. For all profile/parameter values based on orgn_code/organization_id.
923: gme_common_pvt.g_setup_done :=
924: gme_common_pvt.setup (p_org_code => p_org_code);
925:
926: IF NOT gme_common_pvt.g_setup_done THEN
927: RAISE setup_failure;
928: END IF;

Line 926: IF NOT gme_common_pvt.g_setup_done THEN

922: -- Check setup is done. For all profile/parameter values based on orgn_code/organization_id.
923: gme_common_pvt.g_setup_done :=
924: gme_common_pvt.setup (p_org_code => p_org_code);
925:
926: IF NOT gme_common_pvt.g_setup_done THEN
927: RAISE setup_failure;
928: END IF;
929:
930: l_batch_header.organization_id := gme_common_pvt.g_organization_id;

Line 930: l_batch_header.organization_id := gme_common_pvt.g_organization_id;

926: IF NOT gme_common_pvt.g_setup_done THEN
927: RAISE setup_failure;
928: END IF;
929:
930: l_batch_header.organization_id := gme_common_pvt.g_organization_id;
931: -- Validate input param one by one to see if it identifies a resource/process parameter correctly
932: l_batch_header.organization_id := gme_common_pvt.g_organization_id;
933: l_batch_header.batch_no := p_batch_no;
934: l_batch_header.batch_type := 0;

Line 932: l_batch_header.organization_id := gme_common_pvt.g_organization_id;

928: END IF;
929:
930: l_batch_header.organization_id := gme_common_pvt.g_organization_id;
931: -- Validate input param one by one to see if it identifies a resource/process parameter correctly
932: l_batch_header.organization_id := gme_common_pvt.g_organization_id;
933: l_batch_header.batch_no := p_batch_no;
934: l_batch_header.batch_type := 0;
935:
936: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN

Line 986: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'

982: END IF;
983: END LOOP;
984:
985: IF NOT l_act_found THEN
986: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'
987: ,'ACTIVITY'
988: ,p_activity
989: ,'STEP_NO'
990: ,p_batchstep_no);

Line 1000: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'

996: END IF;
997:
998: -- If resource was not found in any activity then report error
999: IF l_rsrc_not_found THEN
1000: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'
1001: ,'RESOURCE'
1002: ,p_resource
1003: ,'ACTIVITY'
1004: ,p_activity);

Line 1024: gme_common_pvt.log_message ('GME_BATCH_SAME_ACT_RSRC_FOUND'

1020:
1021: IF l_act_count > 1 THEN
1022: CLOSE cur_check_act_resource;
1023:
1024: gme_common_pvt.log_message ('GME_BATCH_SAME_ACT_RSRC_FOUND'
1025: ,'ACTIVITY'
1026: ,p_activity
1027: ,'RESOURCE'
1028: ,p_resource);

Line 1048: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'

1044:
1045: IF cur_check_parameter%NOTFOUND THEN
1046: CLOSE cur_check_parameter;
1047:
1048: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'
1049: ,'PARAMETER'
1050: ,p_parameter);
1051: RAISE param_not_found;
1052: END IF;

Line 1071: gme_common_pvt.log_message ('GME_BATCH_SAME_PARAM_FOUND'

1067: x_proc_param_id := process_param.process_param_id;
1068: END LOOP;
1069:
1070: IF l_count > 1 THEN
1071: gme_common_pvt.log_message ('GME_BATCH_SAME_PARAM_FOUND'
1072: ,'PARAMETER'
1073: ,p_parameter);
1074: RAISE dup_param_found;
1075: ELSIF l_count = 0 THEN

Line 1076: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'

1072: ,'PARAMETER'
1073: ,p_parameter);
1074: RAISE dup_param_found;
1075: ELSIF l_count = 0 THEN
1076: gme_common_pvt.log_message ('GME_PARAM_NOT_FOUND'
1077: ,'PARAMETER'
1078: ,p_parameter);
1079: RAISE param_not_found;
1080: END IF;