eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_VAL dependencies on STANDARD

Line 24: /* Standard parameters: */

20: /* Person Date Comments */
21: /* --------- ------ ------------------------------------------ */
22: /* LRJackson 08Nov2000 Created */
23:
24: /* Standard parameters: */
25: /* IN: */
26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */

Line 26: /* P_api_version - standard parameter */

22: /* LRJackson 08Nov2000 Created */
23:
24: /* Standard parameters: */
25: /* IN: */
26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */

Line 27: /* P_init_msg_list - standard parameter (clear error msg list or not) */

23:
24: /* Standard parameters: */
25: /* IN: */
26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */
31: /* OUT: */

Line 28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */

24: /* Standard parameters: */
25: /* IN: */
26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */
31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */

Line 30: /* P_validation_level - standard parameter */

26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */
31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */
33: /* U=unexpected error */
34: /* x_msg_count - standard parameter. Num of messages generated */

Line 32: /* x_return_status - standard parameter. S=success,E=expected error, */

28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */
31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */
33: /* U=unexpected error */
34: /* x_msg_count - standard parameter. Num of messages generated */
35: /* x_msg_data - standard parameter. If only1 msg, here it is */
36: /* x_return_code - num rows returned or SQLCODE (Database error number)*/

Line 34: /* x_msg_count - standard parameter. Num of messages generated */

30: /* P_validation_level - standard parameter */
31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */
33: /* U=unexpected error */
34: /* x_msg_count - standard parameter. Num of messages generated */
35: /* x_msg_data - standard parameter. If only1 msg, here it is */
36: /* x_return_code - num rows returned or SQLCODE (Database error number)*/
37:
38: /* **************************************************************************/

Line 35: /* x_msg_data - standard parameter. If only1 msg, here it is */

31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */
33: /* U=unexpected error */
34: /* x_msg_count - standard parameter. Num of messages generated */
35: /* x_msg_data - standard parameter. If only1 msg, here it is */
36: /* x_return_code - num rows returned or SQLCODE (Database error number)*/
37:
38: /* **************************************************************************/
39: /* NAME */

Line 44: /* PARAMETERS standard + recipe_id, recipe_no, recipe_vers */

40: /* recipe_exists */
41: /* DESCRIPTION */
42: /* This procedure will check if given id or name and version exist in GMD_RECIPES. */
43: /* If name and vers provided, id will be returned. */
44: /* PARAMETERS standard + recipe_id, recipe_no, recipe_vers */
45: /* RETURN VALUES standard + recipe_id */
46: /* 24Jul2001 L.R.Jackson Added "AND recipe_no is null" clause. */
47: /**************************************************************************** */
48:

Line 45: /* RETURN VALUES standard + recipe_id */

41: /* DESCRIPTION */
42: /* This procedure will check if given id or name and version exist in GMD_RECIPES. */
43: /* If name and vers provided, id will be returned. */
44: /* PARAMETERS standard + recipe_id, recipe_no, recipe_vers */
45: /* RETURN VALUES standard + recipe_id */
46: /* 24Jul2001 L.R.Jackson Added "AND recipe_no is null" clause. */
47: /**************************************************************************** */
48:
49: PROCEDURE recipe_exists

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

115: END IF;
116: CLOSE get_record_without_recipe_id;
117: END IF;
118:
119: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
120: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN

Line 147: /* PARAMETERS standard + recipe_no, recipe_vers, action_code=I(insert) or U(udpate) */

143: /* DESCRIPTION */
144: /* This procedure will check if given name and version exist in GMD_RECIPES. */
145: /* If action_code = I and name+vers does not exist, success returned. */
146: /* If action_code = U and Nmae+vers exists, recipe_id will be returned */
147: /* PARAMETERS standard + recipe_no, recipe_vers, action_code=I(insert) or U(udpate) */
148: /* RETURN VALUES standard + recipe_id */
149: /**************************************************************************** */
150:
151: PROCEDURE recipe_name

Line 148: /* RETURN VALUES standard + recipe_id */

144: /* This procedure will check if given name and version exist in GMD_RECIPES. */
145: /* If action_code = I and name+vers does not exist, success returned. */
146: /* If action_code = U and Nmae+vers exists, recipe_id will be returned */
147: /* PARAMETERS standard + recipe_no, recipe_vers, action_code=I(insert) or U(udpate) */
148: /* RETURN VALUES standard + recipe_id */
149: /**************************************************************************** */
150:
151: PROCEDURE recipe_name
152: ( p_api_version IN NUMBER,

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

199: END IF; /* end if action code is insert or update */
200:
201: CLOSE get_record;
202:
203: /* no standard check of p_commit because no insert/update/delete */
204:
205: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
206: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
207:

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

201: CLOSE get_record;
202:
203: /* no standard check of p_commit because no insert/update/delete */
204:
205: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
206: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN

Line 232: /* PARAMETERS (other than standard parameters) */

228: /* get_new_id */
229: /* DESCRIPTION */
230: /* This procedure will */
231: /* */
232: /* PARAMETERS (other than standard parameters) */
233: /* */
234: /* RETURN VALUES (other than standard return values) */
235: /* recipe_id */
236: /* */

Line 234: /* RETURN VALUES (other than standard return values) */

230: /* This procedure will */
231: /* */
232: /* PARAMETERS (other than standard parameters) */
233: /* */
234: /* RETURN VALUES (other than standard return values) */
235: /* recipe_id */
236: /* */
237: /* Person Date Comments */
238: /* --------- ------ ------------------------------------------ */

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

271: OPEN get_new_id;
272: FETCH get_new_id into x_recipe_id;
273: CLOSE get_new_id;
274:
275: /* no standard check of p_commit because no insert/update/delete */
276: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
277: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
278:
279: EXCEPTION

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

272: FETCH get_new_id into x_recipe_id;
273: CLOSE get_new_id;
274:
275: /* no standard check of p_commit because no insert/update/delete */
276: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
277: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN

Line 304: /* PARAMETERS (other than standard parameters) */

300: /* recipe_for_update */
301: /* DESCRIPTION */
302: /* This procedure will */
303: /* */
304: /* PARAMETERS (other than standard parameters) */
305: /* */
306: /* RETURN VALUES (other than standard return values) */
307: /*
308: /* Person Date Comments */

Line 306: /* RETURN VALUES (other than standard return values) */

302: /* This procedure will */
303: /* */
304: /* PARAMETERS (other than standard parameters) */
305: /* */
306: /* RETURN VALUES (other than standard return values) */
307: /*
308: /* Person Date Comments */
309: /* --------- ------ ------------------------------------------ */
310: /* LRJackson 14Nov2000 Created */

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

359: END IF; /* end if update dates do not match */
360: END IF; /* end if record not found */
361: CLOSE get_recipe_data;
362:
363: /* no standard check of p_commit because no insert/update/delete */
364: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
365: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
366:
367: EXCEPTION

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

360: END IF; /* end if record not found */
361: CLOSE get_recipe_data;
362:
363: /* no standard check of p_commit because no insert/update/delete */
364: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
365: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN

Line 392: /* PARAMETERS (other than standard parameters) */

388: /* recipe_description */
389: /* DESCRIPTION */
390: /* This procedure will */
391: /* */
392: /* PARAMETERS (other than standard parameters) */
393: /* */
394: /* RETURN VALUES (other than standard return values) */
395: /* */
396: /* Person Date Comments */

Line 394: /* RETURN VALUES (other than standard return values) */

390: /* This procedure will */
391: /* */
392: /* PARAMETERS (other than standard parameters) */
393: /* */
394: /* RETURN VALUES (other than standard return values) */
395: /* */
396: /* Person Date Comments */
397: /* --------- ------ ------------------------------------------ */
398: /* LRJackson 14Nov2000 Created */

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

427: IF p_recipe_description IS NULL THEN
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430:
431: /* no standard check of p_commit because no insert/update/delete */
432: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
433: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
434:
435: EXCEPTION

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

428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430:
431: /* no standard check of p_commit because no insert/update/delete */
432: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
433: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN

Line 460: /* PARAMETERS (other than standard parametrs) */

456: /* DESCRIPTION */
457: /* This procedure will validate that a given orgn_code is a plant or a lab */
458: /* and that it is associated with the given user */
459: /* */
460: /* PARAMETERS (other than standard parametrs) */
461: /* orgn_code, user_id, required_ind */
462: /* */
463: /* RETURN VALUES (other than standard return values) */
464: /* */

Line 463: /* RETURN VALUES (other than standard return values) */

459: /* */
460: /* PARAMETERS (other than standard parametrs) */
461: /* orgn_code, user_id, required_ind */
462: /* */
463: /* RETURN VALUES (other than standard return values) */
464: /* */
465: /* Person Date Comments */
466: /* --------- ------ ------------------------------------------ */
467: /* LRJackson 21Dec2000 Created */

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

541:
542: CLOSE get_user_orgn;
543: END IF; /* end if orgn code is null or not */
544:
545: /* no standard check of p_commit because no insert/update/delete */
546: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
547: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
548:
549: EXCEPTION

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

542: CLOSE get_user_orgn;
543: END IF; /* end if orgn code is null or not */
544:
545: /* no standard check of p_commit because no insert/update/delete */
546: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
547: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN

Line 573: /* PARAMETERS (other than standard parameters) */

569: /* process_loss_for_update */
570: /* DESCRIPTION */
571: /* This procedure will */
572: /* */
573: /* PARAMETERS (other than standard parameters) */
574: /* */
575: /* RETURN VALUES (other than standard return values) */
576: /* */
577: /* Person Date Comments */

Line 575: /* RETURN VALUES (other than standard return values) */

571: /* This procedure will */
572: /* */
573: /* PARAMETERS (other than standard parameters) */
574: /* */
575: /* RETURN VALUES (other than standard return values) */
576: /* */
577: /* Person Date Comments */
578: /* --------- ------ ------------------------------------------ */
579: /* LRJackson 14Nov2000 Created */

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

630: END IF; /* end if record not found */
631:
632: CLOSE check_recipe_id;
633:
634: /* no standard check of p_commit because no insert/update/delete */
635: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
636: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
637:
638: EXCEPTION

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

631:
632: CLOSE check_recipe_id;
633:
634: /* no standard check of p_commit because no insert/update/delete */
635: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
636: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
637:
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN

Line 662: /* PARAMETERS standard + recipe_id, customer_id */

658: /* recipe_cust_exists */
659: /* DESCRIPTION */
660: /* This procedure will check if given id or name and version exist in */
661: /* GMD_RECIPE_CUSTOMERSS. */
662: /* PARAMETERS standard + recipe_id, customer_id */
663: /* RETURN VALUES standard */
664: /**************************************************************************** */
665:
666: PROCEDURE recipe_cust_exists

Line 663: /* RETURN VALUES standard */

659: /* DESCRIPTION */
660: /* This procedure will check if given id or name and version exist in */
661: /* GMD_RECIPE_CUSTOMERSS. */
662: /* PARAMETERS standard + recipe_id, customer_id */
663: /* RETURN VALUES standard */
664: /**************************************************************************** */
665:
666: PROCEDURE recipe_cust_exists
667: ( p_api_version IN NUMBER,

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

705: END IF; /* end if record not found */
706:
707: CLOSE get_record;
708:
709: /* no standard check of p_commit because no insert/update/delete */
710:
711: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
712: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
713:

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

707: CLOSE get_record;
708:
709: /* no standard check of p_commit because no insert/update/delete */
710:
711: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
712: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN

Line 960: # Checks for item_uom with standard item UOM, if different

956: # SYNOPSIS
957: # proc calc_inv_qtys
958: # Parms
959: # DESCRIPTION
960: # Checks for item_uom with standard item UOM, if different
961: # Converts the quantity from the initial UOM to the
962: # final UOM.
963: #######################################################*/
964: PROCEDURE calc_inv_qtys (P_inv_item_um VARCHAR2,