DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on STANDARD

Line 157: * PARAMETERS standard + customer_id, customer_no

153: * DESCRIPTION
154: * This procedure will check if given id or name exist in OP_CUST_MST.
155: * If name provided, id will be returned.
156: * Currently used by recipes and QC
157: * PARAMETERS standard + customer_id, customer_no
158: * RETURN VALUES standard + customer_id
159: *
160: * LrJackson 27Dec2000 Copied from recipe_exists
161: * Raju Added new cursors to check siteid and orgid exists for that customer.

Line 158: * RETURN VALUES standard + customer_id

154: * This procedure will check if given id or name exist in OP_CUST_MST.
155: * If name provided, id will be returned.
156: * Currently used by recipes and QC
157: * PARAMETERS standard + customer_id, customer_no
158: * RETURN VALUES standard + customer_id
159: *
160: * LrJackson 27Dec2000 Copied from recipe_exists
161: * Raju Added new cursors to check siteid and orgid exists for that customer.
162: **************************************************************************** */

Line 279: /* no standard check of p_commit because no insert/update/delete */

275: END IF;
276: CLOSE get_orgid;
277: END IF;
278:
279: /* no standard check of p_commit because no insert/update/delete */
280:
281: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
282: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
283:

Line 281: /* standard call to get msge cnt, and if cnt is 1, get mesg info */

277: END IF;
278:
279: /* no standard check of p_commit because no insert/update/delete */
280:
281: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
282: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN

Line 353: * PARAMETERS - standard +

349: * NAME
350: * action_code
351: * DESCRIPTION
352: * This procedure will check that given action code is valid. I, U, D
353: * PARAMETERS - standard +
354: * p_action_code
355: * RETURN VALUES - standard
356: * MODIFICATION HISTORY
357: * Person Date Comments

Line 355: * RETURN VALUES - standard

351: * DESCRIPTION
352: * This procedure will check that given action code is valid. I, U, D
353: * PARAMETERS - standard +
354: * p_action_code
355: * RETURN VALUES - standard
356: * MODIFICATION HISTORY
357: * Person Date Comments
358: *
359: **************************************************************************** */

Line 391: /* no standard check of p_commit because no insert/update/delete */

387: IF p_action_code is null or p_action_code not in ('I', 'U', 'D') THEN
388: RAISE fnd_api.g_exc_error;
389: END IF;
390:
391: /* no standard check of p_commit because no insert/update/delete */
392:
393: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
394: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
395:

Line 393: /* standard call to get msge cnt, and if cnt is 1, get mesg info */

389: END IF;
390:
391: /* no standard check of p_commit because no insert/update/delete */
392:
393: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
394: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
395:
396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN

Line 2033: * 01-MAR-2002 Shyam Added validation for Run_status_Updtae to check if the cost method is 'Standard'

2029: *
2030: * 12-FEB-2002 Shyam Created an NVL ststement for routing_id that is returned after
2031: * the recipe table is updated. Recipe can have null routing_ids and
2032: * returning a NULL routing_id into variable l_routing_id can cause issues.
2033: * 01-MAR-2002 Shyam Added validation for Run_status_Updtae to check if the cost method is 'Standard'
2034: * and period status is 1.
2035: * 01/16/2003 Shyam UPdate made on status that are not obsoleted or on-hold
2036: *
2037: * *********************************************************************** */

Line 2082: Standard_costing_exception EXCEPTION;

2078: CURSOR Get_FmRout_id(vRecipe_id NUMBER) IS
2079: SELECT formula_id, routing_id From gmd_recipes_b
2080: WHERE recipe_id = vRecipe_id;
2081:
2082: Standard_costing_exception EXCEPTION;
2083: Period_status_exception EXCEPTION;
2084:
2085: BEGIN
2086: SAVEPOINT update_status;

Line 2100: Raise Standard_costing_exception;

2096: OPEN Get_Cost_type;
2097: FETCH Get_Cost_type INTO l_cost_type;
2098: IF ((Get_Cost_type%NOTFOUND) OR (l_cost_type = 1)) THEN
2099: CLOSE Get_Cost_type;
2100: Raise Standard_costing_exception;
2101: END IF;
2102: CLOSE Get_Cost_Type;
2103:
2104: OPEN FROZEN_EFF_CUR;

Line 2170: WHEN Standard_costing_exception THEN

2166: /* sets the context for formula security */
2167: gmd_p_fs_context.set_additional_attr;
2168:
2169: EXCEPTION
2170: WHEN Standard_costing_exception THEN
2171: p_retcode := 3;
2172: p_errbuf := NULL;
2173: set_conc_program_Status('ERROR','Invalid cost method only standard cost methods are allowed ' );
2174: ROLLBACK to update_status;

Line 2173: set_conc_program_Status('ERROR','Invalid cost method only standard cost methods are allowed ' );

2169: EXCEPTION
2170: WHEN Standard_costing_exception THEN
2171: p_retcode := 3;
2172: p_errbuf := NULL;
2173: set_conc_program_Status('ERROR','Invalid cost method only standard cost methods are allowed ' );
2174: ROLLBACK to update_status;
2175: WHEN Period_status_exception THEN
2176: p_retcode := 3;
2177: p_errbuf := NULL;