DBA Data[Home] [Help]

APPS.GMD_RECIPE_HEADER dependencies on GMD_API_GRP

Line 62: l_entity_status GMD_API_GRP.status_rec_type;

58: p_recipe_header_rec recipe_hdr;
59: p_recipe_hdr_flex_rec FLEX;
60:
61: --kkillams,bug 3408799
62: l_entity_status GMD_API_GRP.status_rec_type;
63: default_status_err EXCEPTION;
64: create_recipe_err EXCEPTION;
65: setup_failure EXCEPTION;
66: BEGIN

Line 93: IF NOT gmd_api_grp.setup_done THEN

89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: /* Intialize the setup fields */
93: IF NOT gmd_api_grp.setup_done THEN
94: gmd_api_grp.setup_done := gmd_api_grp.setup;
95: END IF;
96: IF NOT gmd_api_grp.setup_done THEN
97: RAISE setup_failure;

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

90: END IF;
91:
92: /* Intialize the setup fields */
93: IF NOT gmd_api_grp.setup_done THEN
94: gmd_api_grp.setup_done := gmd_api_grp.setup;
95: END IF;
96: IF NOT gmd_api_grp.setup_done THEN
97: RAISE setup_failure;
98: END IF;

Line 96: IF NOT gmd_api_grp.setup_done THEN

92: /* Intialize the setup fields */
93: IF NOT gmd_api_grp.setup_done THEN
94: gmd_api_grp.setup_done := gmd_api_grp.setup;
95: END IF;
96: IF NOT gmd_api_grp.setup_done THEN
97: RAISE setup_failure;
98: END IF;
99:
100: FOR i IN 1 .. p_recipe_header_tbl.count LOOP

Line 122: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_header_rec.owner_organization_id)) THEN

118: FND_MSG_PUB.Add;
119: RAISE FND_API.G_EXC_ERROR;
120: ELSE
121: --Check the owner organization id passed is process enabled if not raise an error message
122: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_header_rec.owner_organization_id)) THEN
123: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
124: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_header_rec.owner_organization_id);
125: FND_MSG_PUB.Add;
126: RAISE FND_API.G_EXC_ERROR;

Line 137: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_header_rec.creation_organization_id)) THEN

133: FND_MSG_PUB.Add;
134: RAISE FND_API.G_EXC_ERROR;
135: ELSE
136: --Check the creation organization id passed is process enabled if not raise an error message
137: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_header_rec.creation_organization_id)) THEN
138: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
139: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_header_rec.creation_organization_id);
140: FND_MSG_PUB.Add;
141: RAISE FND_API.G_EXC_ERROR;

Line 147: p_recipe_header_rec.owner_id := gmd_api_grp.user_id;

143: END IF;
144:
145: /* Assigning the owner_id, if it is not passed */
146: /* Bug 4603060 */
147: p_recipe_header_rec.owner_id := gmd_api_grp.user_id;
148:
149: /* Assign contiguous Ind as 0, if it not passed */
150: IF (p_recipe_header_rec.contiguous_ind IS NULL) THEN
151: p_recipe_header_rec.contiguous_ind := 0;

Line 161: IF NOT (GMD_API_GRP.OrgnAccessible(powner_orgn_id => p_recipe_header_rec.owner_organization_id)) THEN

157: END IF;
158:
159: /* Validation for owner_orgn_code access by owner */
160: /* Recipe Security fix */
161: IF NOT (GMD_API_GRP.OrgnAccessible(powner_orgn_id => p_recipe_header_rec.owner_organization_id)) THEN
162: RAISE create_recipe_err;
163: END IF;
164:
165: /* Validate the recipe_type field passed in */

Line 173: p_recipe_header_rec.recipe_type := GMD_API_GRP.get_recipe_type(p_organization_id => p_recipe_header_rec.owner_organization_id);

169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172: ELSE
173: p_recipe_header_rec.recipe_type := GMD_API_GRP.get_recipe_type(p_organization_id => p_recipe_header_rec.owner_organization_id);
174: END IF;
175:
176: /* Bug 4716923, 4716666 - Thomas Daniel */
177: /* Added the following code to validate the formula and the items in the formula */

Line 214: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',

210: --kkillams,bug 3408799
211: /* Assign each row from the PL/SQL table to a row. */
212: p_recipe_header_rec := p_recipe_header_tbl(i);
213: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
214: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
215: V_orgn_id => p_recipe_header_rec.owner_organization_id, --w.r.t. bug 4004501 INVCONV kkillams
216: X_entity_status => l_entity_status);
217: --Add this code after the call to gmd_recipes_mls.insert_row.
218: IF (l_entity_status.entity_status <> 100) THEN

Line 349: IF NOT gmd_api_grp.setup_done THEN

345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: /* Intialize the setup fields */
349: IF NOT gmd_api_grp.setup_done THEN
350: gmd_api_grp.setup_done := gmd_api_grp.setup;
351: END IF;
352: IF NOT gmd_api_grp.setup_done THEN
353: RAISE setup_failure;

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

346: END IF;
347:
348: /* Intialize the setup fields */
349: IF NOT gmd_api_grp.setup_done THEN
350: gmd_api_grp.setup_done := gmd_api_grp.setup;
351: END IF;
352: IF NOT gmd_api_grp.setup_done THEN
353: RAISE setup_failure;
354: END IF;

Line 352: IF NOT gmd_api_grp.setup_done THEN

348: /* Intialize the setup fields */
349: IF NOT gmd_api_grp.setup_done THEN
350: gmd_api_grp.setup_done := gmd_api_grp.setup;
351: END IF;
352: IF NOT gmd_api_grp.setup_done THEN
353: RAISE setup_failure;
354: END IF;
355:
356: /* Initialize API return status to success */

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

398: END IF;
399:
400: /* Validate if this Recipe can be modified by this user */
401: /* Recipe Security fix */
402: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'RECIPE'
403: ,Entity_id => l_recipe_id) THEN
404: RAISE update_recipe_err;
405: END IF;
406:

Line 436: IF NOT GMD_API_GRP.OrgnAccessible

432: := l_recipe_header_rec.owner_organization_id;
433: ELSE
434: -- Validate if the new orgn code to be updated with has
435: -- user access
436: IF NOT GMD_API_GRP.OrgnAccessible
437: (powner_orgn_id => p_recipe_header_rec.owner_organization_id) THEN
438: RAISE update_recipe_err;
439: END IF;
440: END IF;

Line 464: GMD_API_GRP.check_item_exists (p_formula_id => p_recipe_header_rec.formula_id

460: := l_recipe_header_rec.formula_id;
461: /* If organization ID is being updated then we need to verify if the new organization */
462: /* has access to the fomula elements */
463: IF p_recipe_header_rec.owner_organization_id <> l_recipe_header_rec.owner_organization_id THEN
464: GMD_API_GRP.check_item_exists (p_formula_id => p_recipe_header_rec.formula_id
465: ,p_organization_id => p_recipe_header_rec.owner_organization_id
466: ,x_return_status => x_return_status);
467: IF x_return_status <> FND_API.g_ret_sts_success THEN
468: RAISE update_recipe_err;

Line 490: := gmd_api_grp.user_id;

486: END IF;
487:
488: /* Bug 4603060 */
489: p_recipe_header_rec.created_by
490: := gmd_api_grp.user_id;
491:
492: IF (p_recipe_header_rec.last_update_date IS NULL) THEN
493: p_recipe_header_rec.last_update_date
494: := sysdate;

Line 499: := gmd_api_grp.user_id;

495: END IF;
496:
497: /* Bug 4603060 */
498: p_recipe_header_rec.last_updated_by
499: := gmd_api_grp.user_id;
500:
501: IF (p_recipe_header_rec.last_update_login IS NULL) THEN
502: p_recipe_header_rec.last_update_login
503: := NVL(l_recipe_header_rec.last_update_login,

Line 504: gmd_api_grp.login_id);

500:
501: IF (p_recipe_header_rec.last_update_login IS NULL) THEN
502: p_recipe_header_rec.last_update_login
503: := NVL(l_recipe_header_rec.last_update_login,
504: gmd_api_grp.login_id);
505: END IF;
506:
507: /* Bug 4603060 */
508: p_recipe_header_rec.owner_id

Line 509: := gmd_api_grp.user_id;

505: END IF;
506:
507: /* Bug 4603060 */
508: p_recipe_header_rec.owner_id
509: := gmd_api_grp.user_id;
510:
511: /* Thomas Daniel - Bug 2652200 */
512: /* Reversed the handling of FND_API.G_MISS_CHAR, now if the user */
513: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */

Line 555: p_recipe_header_rec.recipe_type := GMD_API_GRP.get_recipe_type(p_organization_id => p_recipe_header_rec.owner_organization_id);

551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554: ELSE
555: p_recipe_header_rec.recipe_type := GMD_API_GRP.get_recipe_type(p_organization_id => p_recipe_header_rec.owner_organization_id);
556: END IF;
557:
558: IF (p_recipe_header_rec.calculate_step_quantity = FND_API.G_MISS_NUM) THEN
559: p_recipe_header_rec.calculate_step_quantity := NULL;