87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89:
90: /* Intialize the setup fields */
91: IF NOT gmd_api_grp.setup_done THEN
92: gmd_api_grp.setup_done := gmd_api_grp.setup;
93: END IF;
94: IF NOT gmd_api_grp.setup_done THEN
95: RAISE setup_failure;
88: END IF;
89:
90: /* Intialize the setup fields */
91: IF NOT gmd_api_grp.setup_done THEN
92: gmd_api_grp.setup_done := gmd_api_grp.setup;
93: END IF;
94: IF NOT gmd_api_grp.setup_done THEN
95: RAISE setup_failure;
96: END IF;
90: /* Intialize the setup fields */
91: IF NOT gmd_api_grp.setup_done THEN
92: gmd_api_grp.setup_done := gmd_api_grp.setup;
93: END IF;
94: IF NOT gmd_api_grp.setup_done THEN
95: RAISE setup_failure;
96: END IF;
97:
98: FOR i IN 1 .. p_recipe_detail_tbl.count LOOP
132: END IF;
133:
134: /* Validate if this Recipe can be modified by this user */
135: /* Recipe Security fix */
136: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
137: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
138: RAISE recipe_pr_loss_ins_failure;
139: END IF;
140:
153: FND_MSG_PUB.ADD;
154: RAISE recipe_pr_loss_ins_failure;
155: ELSE
156: --Check the organization id passed is process enabled if not raise an error message
157: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_detail_rec.organization_id)) THEN
158: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
159: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_detail_rec.organization_id);
160: FND_MSG_PUB.Add;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;
163: END IF;
164:
165: /* Validate if user has access to the process loss orgn code */
166: IF NOT (GMD_API_GRP.OrgnAccessible
167: (powner_orgn_id => p_recipe_detail_rec.organization_id) ) THEN
168: RAISE recipe_pr_loss_ins_failure;
169: END IF;
170:
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: /* Intialize the setup fields */
302: IF NOT gmd_api_grp.setup_done THEN
303: gmd_api_grp.setup_done := gmd_api_grp.setup;
304: END IF;
305: IF NOT gmd_api_grp.setup_done THEN
306: RAISE setup_failure;
299: END IF;
300:
301: /* Intialize the setup fields */
302: IF NOT gmd_api_grp.setup_done THEN
303: gmd_api_grp.setup_done := gmd_api_grp.setup;
304: END IF;
305: IF NOT gmd_api_grp.setup_done THEN
306: RAISE setup_failure;
307: END IF;
301: /* Intialize the setup fields */
302: IF NOT gmd_api_grp.setup_done THEN
303: gmd_api_grp.setup_done := gmd_api_grp.setup;
304: END IF;
305: IF NOT gmd_api_grp.setup_done THEN
306: RAISE setup_failure;
307: END IF;
308:
309: IF (p_recipe_detail_tbl.Count = 0) THEN
346: END IF;
347:
348: /* Validate if this Recipe can be modified by this user */
349: /* Recipe Security fix */
350: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
351: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
352: RAISE Recipe_Cust_ins_failure;
353: END IF;
354:
597: r.recipe_id = vRecipe_id AND
598: h.scale_type = 0);
599:
600: --kkillams,bug 3408799
601: l_entity_status GMD_API_GRP.status_rec_type;
602: default_status_err EXCEPTION;
603: setup_failure EXCEPTION;
604: Recipe_VR_insert_failure EXCEPTION;
605:
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: /* Intialize the setup fields */
633: IF NOT gmd_api_grp.setup_done THEN
634: gmd_api_grp.setup_done := gmd_api_grp.setup;
635: END IF;
636: IF NOT gmd_api_grp.setup_done THEN
637: RAISE setup_failure;
630: END IF;
631:
632: /* Intialize the setup fields */
633: IF NOT gmd_api_grp.setup_done THEN
634: gmd_api_grp.setup_done := gmd_api_grp.setup;
635: END IF;
636: IF NOT gmd_api_grp.setup_done THEN
637: RAISE setup_failure;
638: END IF;
632: /* Intialize the setup fields */
633: IF NOT gmd_api_grp.setup_done THEN
634: gmd_api_grp.setup_done := gmd_api_grp.setup;
635: END IF;
636: IF NOT gmd_api_grp.setup_done THEN
637: RAISE setup_failure;
638: END IF;
639:
640: IF (p_recipe_vr_tbl.Count = 0) THEN
682: END IF;
683:
684: /* Validate if this Recipe can be modified by this user */
685: /* Recipe Security fix */
686: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
687: ,Entity_id => p_recipe_vr_rec.recipe_id) THEN
688: RAISE Recipe_VR_insert_failure;
689: END IF;
690:
691: /* Validate if the orgn code used for creation can be accessed
692: by user */
693: --Commented the code vr security will be based on recipe owner orgn code
694: /*IF (p_recipe_vr_rec.orgn_code IS NOT NULL) THEN
695: IF NOT (gmd_api_grp.isUserOrgnAccessible
696: (powner_id => gmd_api_grp.user_id
697: ,powner_orgn => p_recipe_vr_rec.orgn_code)) THEN
698: RAISE Recipe_VR_insert_failure;
699: END IF;
692: by user */
693: --Commented the code vr security will be based on recipe owner orgn code
694: /*IF (p_recipe_vr_rec.orgn_code IS NOT NULL) THEN
695: IF NOT (gmd_api_grp.isUserOrgnAccessible
696: (powner_id => gmd_api_grp.user_id
697: ,powner_orgn => p_recipe_vr_rec.orgn_code)) THEN
698: RAISE Recipe_VR_insert_failure;
699: END IF;
700: END IF;*/
814: COMMIT;
815: --kkillams,bug 3408799
816: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
817: SAVEPOINT default_status_sp;
818: gmd_api_grp.get_status_details (V_entity_type => 'VALIDITY',
819: V_orgn_id => p_recipe_vr_rec.organization_id, --w.r.t. bug 4004501 INVCONV kkillams.
820: X_entity_status => l_entity_status);
821: --Add this code after the call to gmd_recipes_mls.insert_row.
822: IF (l_entity_status.entity_status <> 100) THEN
978: FND_MSG_PUB.initialize;
979: END IF;
980:
981: /* Intialize the setup fields */
982: IF NOT gmd_api_grp.setup_done THEN
983: gmd_api_grp.setup_done := gmd_api_grp.setup;
984: END IF;
985: IF NOT gmd_api_grp.setup_done THEN
986: RAISE setup_failure;
979: END IF;
980:
981: /* Intialize the setup fields */
982: IF NOT gmd_api_grp.setup_done THEN
983: gmd_api_grp.setup_done := gmd_api_grp.setup;
984: END IF;
985: IF NOT gmd_api_grp.setup_done THEN
986: RAISE setup_failure;
987: END IF;
981: /* Intialize the setup fields */
982: IF NOT gmd_api_grp.setup_done THEN
983: gmd_api_grp.setup_done := gmd_api_grp.setup;
984: END IF;
985: IF NOT gmd_api_grp.setup_done THEN
986: RAISE setup_failure;
987: END IF;
988:
989: IF (p_recipe_mtl_tbl.Count = 0) THEN
1032: END IF;
1033:
1034: /* Validate if this Recipe can be modified by this user */
1035: /* Recipe Security fix */
1036: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1037: ,Entity_id => p_recipe_mtl_rec.recipe_id) THEN
1038: RAISE insert_rcp_mat_failure;
1039: END IF;
1040:
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: /* Intialize the setup fields */
1257: IF NOT gmd_api_grp.setup_done THEN
1258: gmd_api_grp.setup_done := gmd_api_grp.setup;
1259: END IF;
1260: IF NOT gmd_api_grp.setup_done THEN
1261: RAISE setup_failure;
1254: END IF;
1255:
1256: /* Intialize the setup fields */
1257: IF NOT gmd_api_grp.setup_done THEN
1258: gmd_api_grp.setup_done := gmd_api_grp.setup;
1259: END IF;
1260: IF NOT gmd_api_grp.setup_done THEN
1261: RAISE setup_failure;
1262: END IF;
1256: /* Intialize the setup fields */
1257: IF NOT gmd_api_grp.setup_done THEN
1258: gmd_api_grp.setup_done := gmd_api_grp.setup;
1259: END IF;
1260: IF NOT gmd_api_grp.setup_done THEN
1261: RAISE setup_failure;
1262: END IF;
1263:
1264: IF (p_recipe_detail_tbl.Count = 0) THEN
1336: END IF;
1337:
1338: /* Validate if this Recipe can be modified by this user */
1339: /* Recipe Security fix */
1340: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1341: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1342: RAISE update_pr_loss_failure;
1343: END IF;
1344:
1341: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1342: RAISE update_pr_loss_failure;
1343: END IF;
1344:
1345: IF NOT GMD_API_GRP.OrgnAccessible(powner_orgn_id => p_recipe_detail_rec.organization_id) THEN
1346: RAISE update_pr_loss_failure;
1347: END IF;
1348:
1349: /* Update into the recipe process loss table */
1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: /* Intialize the setup fields */
1485: IF NOT gmd_api_grp.setup_done THEN
1486: gmd_api_grp.setup_done := gmd_api_grp.setup;
1487: END IF;
1488: IF NOT gmd_api_grp.setup_done THEN
1489: RAISE setup_failure;
1482: END IF;
1483:
1484: /* Intialize the setup fields */
1485: IF NOT gmd_api_grp.setup_done THEN
1486: gmd_api_grp.setup_done := gmd_api_grp.setup;
1487: END IF;
1488: IF NOT gmd_api_grp.setup_done THEN
1489: RAISE setup_failure;
1490: END IF;
1484: /* Intialize the setup fields */
1485: IF NOT gmd_api_grp.setup_done THEN
1486: gmd_api_grp.setup_done := gmd_api_grp.setup;
1487: END IF;
1488: IF NOT gmd_api_grp.setup_done THEN
1489: RAISE setup_failure;
1490: END IF;
1491:
1492: IF (p_recipe_detail_tbl.Count = 0) THEN
1529: END IF;
1530:
1531: /* Validate if this Recipe can be modified by this user */
1532: /* Recipe Security fix */
1533: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1534: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1535: RAISE update_rcp_cust_failure;
1536: END IF;
1537:
1728: FND_MSG_PUB.initialize;
1729: END IF;
1730:
1731: /* Intialize the setup fields */
1732: IF NOT gmd_api_grp.setup_done THEN
1733: gmd_api_grp.setup_done := gmd_api_grp.setup;
1734: END IF;
1735: IF NOT gmd_api_grp.setup_done THEN
1736: RAISE setup_failure;
1729: END IF;
1730:
1731: /* Intialize the setup fields */
1732: IF NOT gmd_api_grp.setup_done THEN
1733: gmd_api_grp.setup_done := gmd_api_grp.setup;
1734: END IF;
1735: IF NOT gmd_api_grp.setup_done THEN
1736: RAISE setup_failure;
1737: END IF;
1731: /* Intialize the setup fields */
1732: IF NOT gmd_api_grp.setup_done THEN
1733: gmd_api_grp.setup_done := gmd_api_grp.setup;
1734: END IF;
1735: IF NOT gmd_api_grp.setup_done THEN
1736: RAISE setup_failure;
1737: END IF;
1738:
1739: /* Initialization of all status */
1801:
1802: /* Validate if this Recipe can be modified by this user */
1803: /* Recipe Security fix */
1804: --Commented the code vr security will be based on recipe owner orgn code
1805: /*IF NOT GMD_API_GRP.isUserOrgnAccessible(powner_id => gmd_api_grp.user_id
1806: ,powner_orgn => p_recipe_vr_rec.orgn_code) THEN
1807: RAISE Update_VR_Failure;
1808: END IF;*/
1809:
1806: ,powner_orgn => p_recipe_vr_rec.orgn_code) THEN
1807: RAISE Update_VR_Failure;
1808: END IF;*/
1809:
1810: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1811: ,Entity_id => p_recipe_vr_rec.recipe_id) THEN
1812: RAISE Update_VR_Failure;
1813: END IF;
1814:
1813: END IF;
1814:
1815: /* VR Security fix */
1816: --Commented the code vr security will be based on recipe owner orgn code
1817: /*IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'VALIDITY'
1818: ,Entity_id => p_recipe_vr_rec.recipe_validity_rule_id)
1819: THEN
1820: RAISE Update_VR_Failure;
1821: END IF;*/
2208: FND_MSG_PUB.initialize;
2209: END IF;
2210:
2211: /* Intialize the setup fields */
2212: IF NOT gmd_api_grp.setup_done THEN
2213: gmd_api_grp.setup_done := gmd_api_grp.setup;
2214: END IF;
2215: IF NOT gmd_api_grp.setup_done THEN
2216: RAISE setup_failure;
2209: END IF;
2210:
2211: /* Intialize the setup fields */
2212: IF NOT gmd_api_grp.setup_done THEN
2213: gmd_api_grp.setup_done := gmd_api_grp.setup;
2214: END IF;
2215: IF NOT gmd_api_grp.setup_done THEN
2216: RAISE setup_failure;
2217: END IF;
2211: /* Intialize the setup fields */
2212: IF NOT gmd_api_grp.setup_done THEN
2213: gmd_api_grp.setup_done := gmd_api_grp.setup;
2214: END IF;
2215: IF NOT gmd_api_grp.setup_done THEN
2216: RAISE setup_failure;
2217: END IF;
2218:
2219: IF (p_recipe_detail_tbl.Count = 0) THEN
2257: END IF;
2258:
2259: /* Validate if this Recipe can be modified by this user */
2260: /* Recipe Security fix */
2261: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
2262: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
2263: RAISE FND_API.G_EXC_ERROR;
2264: END IF;
2265:
2667: FND_MSG_PUB.initialize;
2668: END IF;
2669:
2670: /* Intialize the setup fields */
2671: IF NOT gmd_api_grp.setup_done THEN
2672: gmd_api_grp.setup_done := gmd_api_grp.setup;
2673: END IF;
2674: IF NOT gmd_api_grp.setup_done THEN
2675: RAISE setup_failure;
2668: END IF;
2669:
2670: /* Intialize the setup fields */
2671: IF NOT gmd_api_grp.setup_done THEN
2672: gmd_api_grp.setup_done := gmd_api_grp.setup;
2673: END IF;
2674: IF NOT gmd_api_grp.setup_done THEN
2675: RAISE setup_failure;
2676: END IF;
2670: /* Intialize the setup fields */
2671: IF NOT gmd_api_grp.setup_done THEN
2672: gmd_api_grp.setup_done := gmd_api_grp.setup;
2673: END IF;
2674: IF NOT gmd_api_grp.setup_done THEN
2675: RAISE setup_failure;
2676: END IF;
2677:
2678: IF (p_recipe_detail_tbl.Count = 0) THEN
2715: END IF;
2716:
2717: /* Validate if this Recipe can be modified by this user */
2718: /* Recipe Security fix */
2719: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
2720: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
2721: RAISE FND_API.G_EXC_ERROR;
2722: END IF;
2723:
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141:
3142: /* Intialize the setup fields */
3143: IF NOT gmd_api_grp.setup_done THEN
3144: gmd_api_grp.setup_done := gmd_api_grp.setup;
3145: END IF;
3146: IF NOT gmd_api_grp.setup_done THEN
3147: RAISE setup_failure;
3140: END IF;
3141:
3142: /* Intialize the setup fields */
3143: IF NOT gmd_api_grp.setup_done THEN
3144: gmd_api_grp.setup_done := gmd_api_grp.setup;
3145: END IF;
3146: IF NOT gmd_api_grp.setup_done THEN
3147: RAISE setup_failure;
3148: END IF;
3142: /* Intialize the setup fields */
3143: IF NOT gmd_api_grp.setup_done THEN
3144: gmd_api_grp.setup_done := gmd_api_grp.setup;
3145: END IF;
3146: IF NOT gmd_api_grp.setup_done THEN
3147: RAISE setup_failure;
3148: END IF;
3149:
3150: IF (p_recipe_detail_tbl.Count = 0) THEN
3187: END IF;
3188:
3189: /* Validate if this Recipe can be modified by this user */
3190: /* Recipe Security fix */
3191: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
3192: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: END IF;
3195: