815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817:
818: -- Verify that owner_id has access to owner_orgn_code
819: IF NOT spec_owner_orgn_valid(fnd_global.resp_id,
820: p_spec_header.owner_organization_id) THEN
821: -- Peep...Peep...Security Alert. User does not have access to Owner Organization
822: SELECT organization_code INTO l_owner_organization_code
823: FROM mtl_parameters
2548: X_ATTRIBUTE29 => X_hdr_rec.ATTRIBUTE29,
2549: X_ATTRIBUTE30 => X_hdr_rec.ATTRIBUTE30,
2550: X_SPEC_DESC => X_hdr_rec.SPEC_DESC,
2551: X_CREATION_DATE => SYSDATE,
2552: X_CREATED_BY => FND_GLOBAL.USER_ID,
2553: X_LAST_UPDATE_DATE => SYSDATE,
2554: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2555: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
2556:
2550: X_SPEC_DESC => X_hdr_rec.SPEC_DESC,
2551: X_CREATION_DATE => SYSDATE,
2552: X_CREATED_BY => FND_GLOBAL.USER_ID,
2553: X_LAST_UPDATE_DATE => SYSDATE,
2554: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2555: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
2556:
2557: l_progress := '030';
2558:
2551: X_CREATION_DATE => SYSDATE,
2552: X_CREATED_BY => FND_GLOBAL.USER_ID,
2553: X_LAST_UPDATE_DATE => SYSDATE,
2554: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2555: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
2556:
2557: l_progress := '030';
2558:
2559: FOR i IN 1..X_dtl_tbl.count LOOP
2628: X_ATTRIBUTE29 => X_dtl_tbl(i).ATTRIBUTE29,
2629: X_ATTRIBUTE30 => X_dtl_tbl(i).ATTRIBUTE30,
2630: X_TEST_DISPLAY => X_dtl_tbl(i).TEST_DISPLAY,
2631: X_CREATION_DATE => SYSDATE,
2632: X_CREATED_BY => FND_GLOBAL.USER_ID,
2633: X_LAST_UPDATE_DATE => SYSDATE,
2634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2636: X_VIABILITY_DURATION => X_dtl_tbl(i).VIABILITY_DURATION,
2630: X_TEST_DISPLAY => X_dtl_tbl(i).TEST_DISPLAY,
2631: X_CREATION_DATE => SYSDATE,
2632: X_CREATED_BY => FND_GLOBAL.USER_ID,
2633: X_LAST_UPDATE_DATE => SYSDATE,
2634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2636: X_VIABILITY_DURATION => X_dtl_tbl(i).VIABILITY_DURATION,
2637: X_TEST_EXPIRATION_DAYS => X_dtl_tbl(i).DAYS,
2638: X_TEST_EXPIRATION_HOURS => X_dtl_tbl(i).HOURS,
2631: X_CREATION_DATE => SYSDATE,
2632: X_CREATED_BY => FND_GLOBAL.USER_ID,
2633: X_LAST_UPDATE_DATE => SYSDATE,
2634: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2635: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2636: X_VIABILITY_DURATION => X_dtl_tbl(i).VIABILITY_DURATION,
2637: X_TEST_EXPIRATION_DAYS => X_dtl_tbl(i).DAYS,
2638: X_TEST_EXPIRATION_HOURS => X_dtl_tbl(i).HOURS,
2639: X_TEST_EXPIRATION_MINUTES => X_dtl_tbl(i).MINUTES,