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 625: IF NOT gmd_api_grp.setup_done THEN

621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: /* Intialize the setup fields */
625: IF NOT gmd_api_grp.setup_done THEN
626: gmd_api_grp.setup_done := gmd_api_grp.setup;
627: END IF;
628: IF NOT gmd_api_grp.setup_done THEN
629: RAISE setup_failure;

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

622: END IF;
623:
624: /* Intialize the setup fields */
625: IF NOT gmd_api_grp.setup_done THEN
626: gmd_api_grp.setup_done := gmd_api_grp.setup;
627: END IF;
628: IF NOT gmd_api_grp.setup_done THEN
629: RAISE setup_failure;
630: END IF;

Line 628: IF NOT gmd_api_grp.setup_done THEN

624: /* Intialize the setup fields */
625: IF NOT gmd_api_grp.setup_done THEN
626: gmd_api_grp.setup_done := gmd_api_grp.setup;
627: END IF;
628: IF NOT gmd_api_grp.setup_done THEN
629: RAISE setup_failure;
630: END IF;
631:
632: IF (p_recipe_vr_tbl.Count = 0) THEN

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

674: END IF;
675:
676: /* Validate if this Recipe can be modified by this user */
677: /* Recipe Security fix */
678: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
679: ,Entity_id => p_recipe_vr_rec.recipe_id) THEN
680: RAISE Recipe_VR_insert_failure;
681: END IF;
682:

Line 687: IF NOT (gmd_api_grp.isUserOrgnAccessible

683: /* Validate if the orgn code used for creation can be accessed
684: by user */
685: --Commented the code vr security will be based on recipe owner orgn code
686: /*IF (p_recipe_vr_rec.orgn_code IS NOT NULL) THEN
687: IF NOT (gmd_api_grp.isUserOrgnAccessible
688: (powner_id => gmd_api_grp.user_id
689: ,powner_orgn => p_recipe_vr_rec.orgn_code)) THEN
690: RAISE Recipe_VR_insert_failure;
691: END IF;

Line 688: (powner_id => gmd_api_grp.user_id

684: by user */
685: --Commented the code vr security will be based on recipe owner orgn code
686: /*IF (p_recipe_vr_rec.orgn_code IS NOT NULL) THEN
687: IF NOT (gmd_api_grp.isUserOrgnAccessible
688: (powner_id => gmd_api_grp.user_id
689: ,powner_orgn => p_recipe_vr_rec.orgn_code)) THEN
690: RAISE Recipe_VR_insert_failure;
691: END IF;
692: END IF;*/

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

792: COMMIT;
793: --kkillams,bug 3408799
794: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
795: SAVEPOINT default_status_sp;
796: gmd_api_grp.get_status_details (V_entity_type => 'VALIDITY',
797: V_orgn_id => p_recipe_vr_rec.organization_id, --w.r.t. bug 4004501 INVCONV kkillams.
798: X_entity_status => l_entity_status);
799: --Add this code after the call to gmd_recipes_mls.insert_row.
800: IF (l_entity_status.entity_status <> 100) THEN

Line 939: IF NOT gmd_api_grp.setup_done THEN

935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: /* Intialize the setup fields */
939: IF NOT gmd_api_grp.setup_done THEN
940: gmd_api_grp.setup_done := gmd_api_grp.setup;
941: END IF;
942: IF NOT gmd_api_grp.setup_done THEN
943: RAISE setup_failure;

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

936: END IF;
937:
938: /* Intialize the setup fields */
939: IF NOT gmd_api_grp.setup_done THEN
940: gmd_api_grp.setup_done := gmd_api_grp.setup;
941: END IF;
942: IF NOT gmd_api_grp.setup_done THEN
943: RAISE setup_failure;
944: END IF;

Line 942: IF NOT gmd_api_grp.setup_done THEN

938: /* Intialize the setup fields */
939: IF NOT gmd_api_grp.setup_done THEN
940: gmd_api_grp.setup_done := gmd_api_grp.setup;
941: END IF;
942: IF NOT gmd_api_grp.setup_done THEN
943: RAISE setup_failure;
944: END IF;
945:
946: IF (p_recipe_mtl_tbl.Count = 0) THEN

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

989: END IF;
990:
991: /* Validate if this Recipe can be modified by this user */
992: /* Recipe Security fix */
993: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
994: ,Entity_id => p_recipe_mtl_rec.recipe_id) THEN
995: RAISE insert_rcp_mat_failure;
996: END IF;
997:

Line 1158: IF NOT gmd_api_grp.setup_done THEN

1154: FND_MSG_PUB.initialize;
1155: END IF;
1156:
1157: /* Intialize the setup fields */
1158: IF NOT gmd_api_grp.setup_done THEN
1159: gmd_api_grp.setup_done := gmd_api_grp.setup;
1160: END IF;
1161: IF NOT gmd_api_grp.setup_done THEN
1162: RAISE setup_failure;

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

1155: END IF;
1156:
1157: /* Intialize the setup fields */
1158: IF NOT gmd_api_grp.setup_done THEN
1159: gmd_api_grp.setup_done := gmd_api_grp.setup;
1160: END IF;
1161: IF NOT gmd_api_grp.setup_done THEN
1162: RAISE setup_failure;
1163: END IF;

Line 1161: IF NOT gmd_api_grp.setup_done THEN

1157: /* Intialize the setup fields */
1158: IF NOT gmd_api_grp.setup_done THEN
1159: gmd_api_grp.setup_done := gmd_api_grp.setup;
1160: END IF;
1161: IF NOT gmd_api_grp.setup_done THEN
1162: RAISE setup_failure;
1163: END IF;
1164:
1165: IF (p_recipe_detail_tbl.Count = 0) THEN

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

1237: END IF;
1238:
1239: /* Validate if this Recipe can be modified by this user */
1240: /* Recipe Security fix */
1241: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1242: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1243: RAISE update_pr_loss_failure;
1244: END IF;
1245:

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

1242: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1243: RAISE update_pr_loss_failure;
1244: END IF;
1245:
1246: IF NOT GMD_API_GRP.OrgnAccessible(powner_orgn_id => p_recipe_detail_rec.organization_id) THEN
1247: RAISE update_pr_loss_failure;
1248: END IF;
1249:
1250: /* Update into the recipe process loss table */

Line 1386: IF NOT gmd_api_grp.setup_done THEN

1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1385: /* Intialize the setup fields */
1386: IF NOT gmd_api_grp.setup_done THEN
1387: gmd_api_grp.setup_done := gmd_api_grp.setup;
1388: END IF;
1389: IF NOT gmd_api_grp.setup_done THEN
1390: RAISE setup_failure;

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

1383: END IF;
1384:
1385: /* Intialize the setup fields */
1386: IF NOT gmd_api_grp.setup_done THEN
1387: gmd_api_grp.setup_done := gmd_api_grp.setup;
1388: END IF;
1389: IF NOT gmd_api_grp.setup_done THEN
1390: RAISE setup_failure;
1391: END IF;

Line 1389: IF NOT gmd_api_grp.setup_done THEN

1385: /* Intialize the setup fields */
1386: IF NOT gmd_api_grp.setup_done THEN
1387: gmd_api_grp.setup_done := gmd_api_grp.setup;
1388: END IF;
1389: IF NOT gmd_api_grp.setup_done THEN
1390: RAISE setup_failure;
1391: END IF;
1392:
1393: IF (p_recipe_detail_tbl.Count = 0) THEN

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

1430: END IF;
1431:
1432: /* Validate if this Recipe can be modified by this user */
1433: /* Recipe Security fix */
1434: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1435: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
1436: RAISE update_rcp_cust_failure;
1437: END IF;
1438:

Line 1625: IF NOT gmd_api_grp.setup_done THEN

1621: FND_MSG_PUB.initialize;
1622: END IF;
1623:
1624: /* Intialize the setup fields */
1625: IF NOT gmd_api_grp.setup_done THEN
1626: gmd_api_grp.setup_done := gmd_api_grp.setup;
1627: END IF;
1628: IF NOT gmd_api_grp.setup_done THEN
1629: RAISE setup_failure;

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

1622: END IF;
1623:
1624: /* Intialize the setup fields */
1625: IF NOT gmd_api_grp.setup_done THEN
1626: gmd_api_grp.setup_done := gmd_api_grp.setup;
1627: END IF;
1628: IF NOT gmd_api_grp.setup_done THEN
1629: RAISE setup_failure;
1630: END IF;

Line 1628: IF NOT gmd_api_grp.setup_done THEN

1624: /* Intialize the setup fields */
1625: IF NOT gmd_api_grp.setup_done THEN
1626: gmd_api_grp.setup_done := gmd_api_grp.setup;
1627: END IF;
1628: IF NOT gmd_api_grp.setup_done THEN
1629: RAISE setup_failure;
1630: END IF;
1631:
1632: /* Initialization of all status */

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

1680:
1681: /* Validate if this Recipe can be modified by this user */
1682: /* Recipe Security fix */
1683: --Commented the code vr security will be based on recipe owner orgn code
1684: /*IF NOT GMD_API_GRP.isUserOrgnAccessible(powner_id => gmd_api_grp.user_id
1685: ,powner_orgn => p_recipe_vr_rec.orgn_code) THEN
1686: RAISE Update_VR_Failure;
1687: END IF;*/
1688:

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

1685: ,powner_orgn => p_recipe_vr_rec.orgn_code) THEN
1686: RAISE Update_VR_Failure;
1687: END IF;*/
1688:
1689: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
1690: ,Entity_id => p_recipe_vr_rec.recipe_id) THEN
1691: RAISE Update_VR_Failure;
1692: END IF;
1693:

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

1692: END IF;
1693:
1694: /* VR Security fix */
1695: --Commented the code vr security will be based on recipe owner orgn code
1696: /*IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'VALIDITY'
1697: ,Entity_id => p_recipe_vr_rec.recipe_validity_rule_id)
1698: THEN
1699: RAISE Update_VR_Failure;
1700: END IF;*/

Line 2085: IF NOT gmd_api_grp.setup_done THEN

2081: FND_MSG_PUB.initialize;
2082: END IF;
2083:
2084: /* Intialize the setup fields */
2085: IF NOT gmd_api_grp.setup_done THEN
2086: gmd_api_grp.setup_done := gmd_api_grp.setup;
2087: END IF;
2088: IF NOT gmd_api_grp.setup_done THEN
2089: RAISE setup_failure;

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

2082: END IF;
2083:
2084: /* Intialize the setup fields */
2085: IF NOT gmd_api_grp.setup_done THEN
2086: gmd_api_grp.setup_done := gmd_api_grp.setup;
2087: END IF;
2088: IF NOT gmd_api_grp.setup_done THEN
2089: RAISE setup_failure;
2090: END IF;

Line 2088: IF NOT gmd_api_grp.setup_done THEN

2084: /* Intialize the setup fields */
2085: IF NOT gmd_api_grp.setup_done THEN
2086: gmd_api_grp.setup_done := gmd_api_grp.setup;
2087: END IF;
2088: IF NOT gmd_api_grp.setup_done THEN
2089: RAISE setup_failure;
2090: END IF;
2091:
2092: IF (p_recipe_detail_tbl.Count = 0) THEN

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

2130: END IF;
2131:
2132: /* Validate if this Recipe can be modified by this user */
2133: /* Recipe Security fix */
2134: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
2135: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138:

Line 2544: IF NOT gmd_api_grp.setup_done THEN

2540: FND_MSG_PUB.initialize;
2541: END IF;
2542:
2543: /* Intialize the setup fields */
2544: IF NOT gmd_api_grp.setup_done THEN
2545: gmd_api_grp.setup_done := gmd_api_grp.setup;
2546: END IF;
2547: IF NOT gmd_api_grp.setup_done THEN
2548: RAISE setup_failure;

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

2541: END IF;
2542:
2543: /* Intialize the setup fields */
2544: IF NOT gmd_api_grp.setup_done THEN
2545: gmd_api_grp.setup_done := gmd_api_grp.setup;
2546: END IF;
2547: IF NOT gmd_api_grp.setup_done THEN
2548: RAISE setup_failure;
2549: END IF;

Line 2547: IF NOT gmd_api_grp.setup_done THEN

2543: /* Intialize the setup fields */
2544: IF NOT gmd_api_grp.setup_done THEN
2545: gmd_api_grp.setup_done := gmd_api_grp.setup;
2546: END IF;
2547: IF NOT gmd_api_grp.setup_done THEN
2548: RAISE setup_failure;
2549: END IF;
2550:
2551: IF (p_recipe_detail_tbl.Count = 0) THEN

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

2588: END IF;
2589:
2590: /* Validate if this Recipe can be modified by this user */
2591: /* Recipe Security fix */
2592: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
2593: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:

Line 3001: IF NOT gmd_api_grp.setup_done THEN

2997: FND_MSG_PUB.initialize;
2998: END IF;
2999:
3000: /* Intialize the setup fields */
3001: IF NOT gmd_api_grp.setup_done THEN
3002: gmd_api_grp.setup_done := gmd_api_grp.setup;
3003: END IF;
3004: IF NOT gmd_api_grp.setup_done THEN
3005: RAISE setup_failure;

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

2998: END IF;
2999:
3000: /* Intialize the setup fields */
3001: IF NOT gmd_api_grp.setup_done THEN
3002: gmd_api_grp.setup_done := gmd_api_grp.setup;
3003: END IF;
3004: IF NOT gmd_api_grp.setup_done THEN
3005: RAISE setup_failure;
3006: END IF;

Line 3004: IF NOT gmd_api_grp.setup_done THEN

3000: /* Intialize the setup fields */
3001: IF NOT gmd_api_grp.setup_done THEN
3002: gmd_api_grp.setup_done := gmd_api_grp.setup;
3003: END IF;
3004: IF NOT gmd_api_grp.setup_done THEN
3005: RAISE setup_failure;
3006: END IF;
3007:
3008: IF (p_recipe_detail_tbl.Count = 0) THEN

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

3045: END IF;
3046:
3047: /* Validate if this Recipe can be modified by this user */
3048: /* Recipe Security fix */
3049: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
3050: ,Entity_id => p_recipe_detail_rec.recipe_id) THEN
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053: