80: /* Initially let us assign the return status to success */
81: x_return_status := FND_API.g_ret_sts_success;
82:
83: /* set row who columns */
84: IF NOT gmd_api_grp.setup_done THEN
85: gmd_api_grp.setup_done := gmd_api_grp.setup;
86: IF NOT gmd_api_grp.setup_done THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
81: x_return_status := FND_API.g_ret_sts_success;
82:
83: /* set row who columns */
84: IF NOT gmd_api_grp.setup_done THEN
85: gmd_api_grp.setup_done := gmd_api_grp.setup;
86: IF NOT gmd_api_grp.setup_done THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: END IF;
82:
83: /* set row who columns */
84: IF NOT gmd_api_grp.setup_done THEN
85: gmd_api_grp.setup_done := gmd_api_grp.setup;
86: IF NOT gmd_api_grp.setup_done THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: END IF;
90:
206: p_oprn_rsrc_tbl(i).ATTRIBUTE28 ,
207: p_oprn_rsrc_tbl(i).ATTRIBUTE29 ,
208: p_oprn_rsrc_tbl(i).ATTRIBUTE30 ,
209: sysdate,
210: gmd_api_grp.user_id,
211: sysdate,
212: gmd_api_grp.user_id,
213: gmd_api_grp.user_id);
214: END LOOP;
208: p_oprn_rsrc_tbl(i).ATTRIBUTE30 ,
209: sysdate,
210: gmd_api_grp.user_id,
211: sysdate,
212: gmd_api_grp.user_id,
213: gmd_api_grp.user_id);
214: END LOOP;
215: IF (l_debug = 'Y') THEN
216: gmd_debug.put_line('End insert oprn rsrc loop - insert_operation_rsrc private');
209: sysdate,
210: gmd_api_grp.user_id,
211: sysdate,
212: gmd_api_grp.user_id,
213: gmd_api_grp.user_id);
214: END LOOP;
215: IF (l_debug = 'Y') THEN
216: gmd_debug.put_line('End insert oprn rsrc loop - insert_operation_rsrc private');
217: END IF;
372: IF x_return_status = 'S' THEN
373:
374: /* Set row who columns */
375: FND_PROFILE.put('USER_ID', 2060);
376: IF NOT gmd_api_grp.setup_done THEN
377: gmd_api_grp.setup_done := gmd_api_grp.setup;
378: END IF;
379: IF NOT gmd_api_grp.setup_done THEN
380: RAISE setup_failure;
373:
374: /* Set row who columns */
375: FND_PROFILE.put('USER_ID', 2060);
376: IF NOT gmd_api_grp.setup_done THEN
377: gmd_api_grp.setup_done := gmd_api_grp.setup;
378: END IF;
379: IF NOT gmd_api_grp.setup_done THEN
380: RAISE setup_failure;
381: END IF;
375: FND_PROFILE.put('USER_ID', 2060);
376: IF NOT gmd_api_grp.setup_done THEN
377: gmd_api_grp.setup_done := gmd_api_grp.setup;
378: END IF;
379: IF NOT gmd_api_grp.setup_done THEN
380: RAISE setup_failure;
381: END IF;
382:
383: IF (l_debug = 'Y') THEN
428: ATTRIBUTE22 = v_oprn_rsrc_update_rec.attribute22,
429: ATTRIBUTE23 = v_oprn_rsrc_update_rec.attribute23,
430: ATTRIBUTE24 = v_oprn_rsrc_update_rec.attribute24,
431: LAST_UPDATE_DATE = sysdate,
432: LAST_UPDATED_BY = gmd_api_grp.user_id,
433: LAST_UPDATE_LOGIN = gmd_api_grp.user_id
434: where oprn_line_id = p_oprn_line_id
435: and resources = p_resources;
436:
429: ATTRIBUTE23 = v_oprn_rsrc_update_rec.attribute23,
430: ATTRIBUTE24 = v_oprn_rsrc_update_rec.attribute24,
431: LAST_UPDATE_DATE = sysdate,
432: LAST_UPDATED_BY = gmd_api_grp.user_id,
433: LAST_UPDATE_LOGIN = gmd_api_grp.user_id
434: where oprn_line_id = p_oprn_line_id
435: and resources = p_resources;
436:
437: END IF;
480: x_return_status := FND_API.g_ret_sts_success;
481:
482: /* Set row who columns */
483: FND_PROFILE.put('USER_ID', 2060);
484: IF NOT gmd_api_grp.setup_done THEN
485: gmd_api_grp.setup_done := gmd_api_grp.setup;
486: END IF;
487: IF NOT gmd_api_grp.setup_done THEN
488: RAISE setup_failure;
481:
482: /* Set row who columns */
483: FND_PROFILE.put('USER_ID', 2060);
484: IF NOT gmd_api_grp.setup_done THEN
485: gmd_api_grp.setup_done := gmd_api_grp.setup;
486: END IF;
487: IF NOT gmd_api_grp.setup_done THEN
488: RAISE setup_failure;
489: END IF;
483: FND_PROFILE.put('USER_ID', 2060);
484: IF NOT gmd_api_grp.setup_done THEN
485: gmd_api_grp.setup_done := gmd_api_grp.setup;
486: END IF;
487: IF NOT gmd_api_grp.setup_done THEN
488: RAISE setup_failure;
489: END IF;
490:
491: IF (l_debug = 'Y') THEN