DBA Data[Home] [Help]

APPS.GMD_RECIPE_DETAIL dependencies on GMD_API_GRP

Line 91: IF NOT gmd_api_grp.setup_done THEN

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;

Line 92: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 94: IF NOT gmd_api_grp.setup_done THEN

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

Line 136: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 157: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_detail_rec.organization_id)) THEN

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;

Line 166: IF NOT (GMD_API_GRP.OrgnAccessible

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:

Line 302: IF NOT gmd_api_grp.setup_done THEN

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;

Line 303: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 305: IF NOT gmd_api_grp.setup_done THEN

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

Line 350: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 601: l_entity_status GMD_API_GRP.status_rec_type;

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:

Line 633: IF NOT gmd_api_grp.setup_done THEN

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;

Line 634: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 636: IF NOT gmd_api_grp.setup_done THEN

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

Line 686: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 695: IF NOT (gmd_api_grp.isUserOrgnAccessible

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;

Line 696: (powner_id => gmd_api_grp.user_id

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;*/

Line 818: gmd_api_grp.get_status_details (V_entity_type => 'VALIDITY',

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

Line 982: IF NOT gmd_api_grp.setup_done 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;

Line 983: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 985: IF NOT gmd_api_grp.setup_done THEN

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

Line 1036: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 1257: IF NOT gmd_api_grp.setup_done THEN

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;

Line 1258: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 1260: IF NOT gmd_api_grp.setup_done THEN

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

Line 1340: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 1345: IF NOT GMD_API_GRP.OrgnAccessible(powner_orgn_id => p_recipe_detail_rec.organization_id) THEN

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 */

Line 1485: IF NOT gmd_api_grp.setup_done THEN

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;

Line 1486: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 1488: IF NOT gmd_api_grp.setup_done THEN

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

Line 1533: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 1732: IF NOT gmd_api_grp.setup_done THEN

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;

Line 1733: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 1735: IF NOT gmd_api_grp.setup_done THEN

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 */

Line 1805: /*IF NOT GMD_API_GRP.isUserOrgnAccessible(powner_id => gmd_api_grp.user_id

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:

Line 1810: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 1817: /*IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'VALIDITY'

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;*/

Line 2212: IF NOT gmd_api_grp.setup_done THEN

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;

Line 2213: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 2215: IF NOT gmd_api_grp.setup_done THEN

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

Line 2261: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 2671: IF NOT gmd_api_grp.setup_done THEN

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;

Line 2672: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 2674: IF NOT gmd_api_grp.setup_done THEN

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

Line 2719: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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:

Line 3143: IF NOT gmd_api_grp.setup_done THEN

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;

Line 3144: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 3146: IF NOT gmd_api_grp.setup_done THEN

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

Line 3191: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'

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: