111:
112: /* Initially let us assign the return status to success */
113: x_return_status := FND_API.g_ret_sts_success;
114:
115: IF NOT gmd_api_grp.setup_done THEN
116: gmd_api_grp.setup_done := gmd_api_grp.setup;
117: END IF;
118: IF NOT gmd_api_grp.setup_done THEN
119: RAISE setup_failure;
112: /* Initially let us assign the return status to success */
113: x_return_status := FND_API.g_ret_sts_success;
114:
115: IF NOT gmd_api_grp.setup_done THEN
116: gmd_api_grp.setup_done := gmd_api_grp.setup;
117: END IF;
118: IF NOT gmd_api_grp.setup_done THEN
119: RAISE setup_failure;
120: END IF;
114:
115: IF NOT gmd_api_grp.setup_done THEN
116: gmd_api_grp.setup_done := gmd_api_grp.setup;
117: END IF;
118: IF NOT gmd_api_grp.setup_done THEN
119: RAISE setup_failure;
120: END IF;
121:
122: /* Make sure we are call compatible */
150:
151: /* Operation Security Validation */
152: /* Validation: Check if this users performing update has access to this
153: operation owner orgn code */
154: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'OPERATION'
155: ,Entity_id => v_oprn_id) THEN
156: RAISE ins_oprn_actv_err;
157: END IF;
158:
182: /* check activity factor has a value else default */
183: IF p_oprn_activity.activity_factor IS NULL THEN
184: p_oprn_activity.activity_factor := 1;
185: ELSIF p_oprn_activity.activity_factor < 0 THEN
186: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
187: 'FIELD', 'ACTIVITY_FACTOR');
188: RAISE ins_oprn_actv_err;
189: END IF;
190:
191: /* check offset interval has a value else default */
192: IF p_oprn_activity.offset_interval IS NULL THEN
193: p_oprn_activity.offset_interval := 0;
194: ELSIF p_oprn_activity.offset_interval < 0 THEN
195: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
196: 'FIELD','OFFSET_INTERVAL');
197: RAISE ins_oprn_actv_err;
198: END IF;
199:
311:
312: /* Initially let us assign the return status to success */
313: x_return_status := FND_API.g_ret_sts_success;
314:
315: IF NOT gmd_api_grp.setup_done THEN
316: gmd_api_grp.setup_done := gmd_api_grp.setup;
317: END IF;
318: IF NOT gmd_api_grp.setup_done THEN
319: RAISE setup_failure;
312: /* Initially let us assign the return status to success */
313: x_return_status := FND_API.g_ret_sts_success;
314:
315: IF NOT gmd_api_grp.setup_done THEN
316: gmd_api_grp.setup_done := gmd_api_grp.setup;
317: END IF;
318: IF NOT gmd_api_grp.setup_done THEN
319: RAISE setup_failure;
320: END IF;
314:
315: IF NOT gmd_api_grp.setup_done THEN
316: gmd_api_grp.setup_done := gmd_api_grp.setup;
317: END IF;
318: IF NOT gmd_api_grp.setup_done THEN
319: RAISE setup_failure;
320: END IF;
321:
322: /* Make sure we are call compatible */
371: and Operation is not logically deleted */
372: OPEN get_oprn_id(p_oprn_line_id);
373: FETCH get_oprn_id INTO v_oprn_id;
374: IF get_oprn_id%NOTFOUND THEN
375: gmd_api_grp.log_message('GMD_INVALID_OPRNLINE_ID');
376: x_return_status := FND_API.g_ret_sts_error;
377: END IF;
378: CLOSE get_oprn_id;
379:
379:
380: /* Operation Security Validation */
381: /* Validation: Check if this users performing update has access to this
382: operation owner orgn code */
383: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'OPERATION'
384: ,Entity_id => v_oprn_id) THEN
385: RAISE upd_oprn_actv_err;
386: END IF;
387:
396: FOR a IN 1 .. p_update_table.count LOOP
397: /* check activity factor has a value else default */
398: IF (UPPER(p_update_table(a).p_col_to_update) = 'ACTIVITY_FACTOR' AND
399: p_update_table(a).p_value < 0) THEN
400: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
401: 'FIELD', p_update_table(a).p_col_to_update);
402: RAISE upd_oprn_actv_err;
403: /* check offset interval has a value else default */
404: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'OFFSET_INTERVAL' AND
402: RAISE upd_oprn_actv_err;
403: /* check offset interval has a value else default */
404: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'OFFSET_INTERVAL' AND
405: p_update_table(a).p_value < 0) THEN
406: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
407: 'FIELD', p_update_table(a).p_col_to_update);
408: RAISE upd_oprn_actv_err;
409: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'SEQUENCE_DEPENDENT_IND' AND
410: p_update_table(a).p_value NOT IN (1,0)) THEN
503:
504: /* Initially let us assign the return status to success */
505: x_return_status := FND_API.g_ret_sts_success;
506:
507: IF NOT gmd_api_grp.setup_done THEN
508: gmd_api_grp.setup_done := gmd_api_grp.setup;
509: END IF;
510: IF NOT gmd_api_grp.setup_done THEN
511: RAISE setup_failure;
504: /* Initially let us assign the return status to success */
505: x_return_status := FND_API.g_ret_sts_success;
506:
507: IF NOT gmd_api_grp.setup_done THEN
508: gmd_api_grp.setup_done := gmd_api_grp.setup;
509: END IF;
510: IF NOT gmd_api_grp.setup_done THEN
511: RAISE setup_failure;
512: END IF;
506:
507: IF NOT gmd_api_grp.setup_done THEN
508: gmd_api_grp.setup_done := gmd_api_grp.setup;
509: END IF;
510: IF NOT gmd_api_grp.setup_done THEN
511: RAISE setup_failure;
512: END IF;
513:
514:
546: OPEN get_activity_count (l_oprn_id);
547: FETCH get_activity_count INTO v_count;
548: CLOSE get_activity_count;
549: IF v_count = 1 THEN
550: gmd_api_grp.log_message ('GMD_DETAILS_REQUIRED');
551: RAISE del_oprn_actv_err;
552: END IF;
553: END IF;
554: CLOSE chk_oprN_line_id;
556:
557: /* Operation Security Validation */
558: /* Validation: Check if this users performing update has access to this
559: operation owner orgn code */
560: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'OPERATION'
561: ,Entity_id => l_oprn_id) THEN
562: RAISE del_oprn_actv_err;
563: END IF;
564: