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:
228: RAISE ins_oprn_actv_err;
229: END IF;
230:
231: /* Added the below call in Bug No.8316321 */
232: GMD_API_GRP.set_activity_sequence_num (P_oprn_id => v_oprn_id,
233: P_user_id => fnd_global.user_id,
234: P_login_id => fnd_global.login_id);
235:
236:
317:
318: /* Initially let us assign the return status to success */
319: x_return_status := FND_API.g_ret_sts_success;
320:
321: IF NOT gmd_api_grp.setup_done THEN
322: gmd_api_grp.setup_done := gmd_api_grp.setup;
323: END IF;
324: IF NOT gmd_api_grp.setup_done THEN
325: RAISE setup_failure;
318: /* Initially let us assign the return status to success */
319: x_return_status := FND_API.g_ret_sts_success;
320:
321: IF NOT gmd_api_grp.setup_done THEN
322: gmd_api_grp.setup_done := gmd_api_grp.setup;
323: END IF;
324: IF NOT gmd_api_grp.setup_done THEN
325: RAISE setup_failure;
326: END IF;
320:
321: IF NOT gmd_api_grp.setup_done THEN
322: gmd_api_grp.setup_done := gmd_api_grp.setup;
323: END IF;
324: IF NOT gmd_api_grp.setup_done THEN
325: RAISE setup_failure;
326: END IF;
327:
328: /* Make sure we are call compatible */
377: and Operation is not logically deleted */
378: OPEN get_oprn_id(p_oprn_line_id);
379: FETCH get_oprn_id INTO v_oprn_id;
380: IF get_oprn_id%NOTFOUND THEN
381: gmd_api_grp.log_message('GMD_INVALID_OPRNLINE_ID');
382: x_return_status := FND_API.g_ret_sts_error;
383: END IF;
384: CLOSE get_oprn_id;
385:
385:
386: /* Operation Security Validation */
387: /* Validation: Check if this users performing update has access to this
388: operation owner orgn code */
389: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'OPERATION'
390: ,Entity_id => v_oprn_id) THEN
391: RAISE upd_oprn_actv_err;
392: END IF;
393:
402: FOR a IN 1 .. p_update_table.count LOOP
403: /* check activity factor has a value else default */
404: IF (UPPER(p_update_table(a).p_col_to_update) = 'ACTIVITY_FACTOR' 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: /* check offset interval has a value else default */
410: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'OFFSET_INTERVAL' AND
408: RAISE upd_oprn_actv_err;
409: /* check offset interval has a value else default */
410: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'OFFSET_INTERVAL' AND
411: p_update_table(a).p_value < 0) THEN
412: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
413: 'FIELD', p_update_table(a).p_col_to_update);
414: RAISE upd_oprn_actv_err;
415: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'SEQUENCE_DEPENDENT_IND' AND
416: p_update_table(a).p_value NOT IN (1,0)) THEN
430: RAISE upd_oprn_actv_err;
431: END IF;
432:
433: /* Added the below call in Bug No.8316321 */
434: GMD_API_GRP.set_activity_sequence_num (P_oprn_id => v_oprn_id,
435: P_user_id => fnd_global.user_id,
436: P_login_id => fnd_global.login_id);
437:
438: IF p_commit THEN
514:
515: /* Initially let us assign the return status to success */
516: x_return_status := FND_API.g_ret_sts_success;
517:
518: IF NOT gmd_api_grp.setup_done THEN
519: gmd_api_grp.setup_done := gmd_api_grp.setup;
520: END IF;
521: IF NOT gmd_api_grp.setup_done THEN
522: RAISE setup_failure;
515: /* Initially let us assign the return status to success */
516: x_return_status := FND_API.g_ret_sts_success;
517:
518: IF NOT gmd_api_grp.setup_done THEN
519: gmd_api_grp.setup_done := gmd_api_grp.setup;
520: END IF;
521: IF NOT gmd_api_grp.setup_done THEN
522: RAISE setup_failure;
523: END IF;
517:
518: IF NOT gmd_api_grp.setup_done THEN
519: gmd_api_grp.setup_done := gmd_api_grp.setup;
520: END IF;
521: IF NOT gmd_api_grp.setup_done THEN
522: RAISE setup_failure;
523: END IF;
524:
525:
557: OPEN get_activity_count (l_oprn_id);
558: FETCH get_activity_count INTO v_count;
559: CLOSE get_activity_count;
560: IF v_count = 1 THEN
561: gmd_api_grp.log_message ('GMD_DETAILS_REQUIRED');
562: RAISE del_oprn_actv_err;
563: END IF;
564: END IF;
565: CLOSE chk_oprN_line_id;
567:
568: /* Operation Security Validation */
569: /* Validation: Check if this users performing update has access to this
570: operation owner orgn code */
571: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'OPERATION'
572: ,Entity_id => l_oprn_id) THEN
573: RAISE del_oprn_actv_err;
574: END IF;
575: