DBA Data[Home] [Help]

APPS.GMD_RECIPE_FETCH_PUB dependencies on STANDARD

Line 7: P_api_version - standard parameter

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FETCH_PUB';
5:
6: /* IN Parameters:
7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter

Line 8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FETCH_PUB';
5:
6: /* IN Parameters:
7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:

Line 9: P_commit - standard parameter. Should be FND_API.G_FALSE

5:
6: /* IN Parameters:
7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,

Line 11: P_validation_level - standard parameter

7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,
14: U=unexpected error
15: x_msg_count - standard parameter. Num of messages generated

Line 13: x_return_status - standard parameter. S=success,E=expected error,

9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,
14: U=unexpected error
15: x_msg_count - standard parameter. Num of messages generated
16: x_msg_data - standard parameter. If only1 msg, here it is
17: x_return_code - num rows returned or SQLCODE (Database error number)*/

Line 15: x_msg_count - standard parameter. Num of messages generated

11: P_validation_level - standard parameter
12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,
14: U=unexpected error
15: x_msg_count - standard parameter. Num of messages generated
16: x_msg_data - standard parameter. If only1 msg, here it is
17: x_return_code - num rows returned or SQLCODE (Database error number)*/
18: /*******************************************************************************
19: * Procedure get_recipe_id

Line 16: x_msg_data - standard parameter. If only1 msg, here it is

12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,
14: U=unexpected error
15: x_msg_count - standard parameter. Num of messages generated
16: x_msg_data - standard parameter. If only1 msg, here it is
17: x_return_code - num rows returned or SQLCODE (Database error number)*/
18: /*******************************************************************************
19: * Procedure get_recipe_id
20: *

Line 66: -- standard call to get msge cnt, and if cnt is 1, get mesg info

62: RAISE fnd_api.g_exc_error;
63: END IF;
64: CLOSE get_recp;
65:
66: -- standard call to get msge cnt, and if cnt is 1, get mesg info
67: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN

Line 142: -- standard call to get msge cnt, and if cnt is 1, get mesg info

138: RAISE fnd_api.g_exc_error;
139: END IF;
140: CLOSE get_rout;
141:
142: -- standard call to get msge cnt, and if cnt is 1, get mesg info
143: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN

Line 287: -- standard call to get msge cnt, and if cnt is 1, get mesg info

283: IF i= 0 THEN
284: RAISE fnd_api.g_exc_error;
285: END IF;
286:
287: -- standard call to get msge cnt, and if cnt is 1, get mesg info
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN

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

360: END IF; -- end if formula_id not found
361:
362: CLOSE get_form;
363:
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 464: /* standard call to get msge cnt, and if cnt is 1, get mesg info */

460: END IF; -- end if recipe_id not found */
461:
462: CLOSE get_proc;
463:
464: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
465: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
466:
467: EXCEPTION
468: WHEN FND_API.G_EXC_ERROR THEN

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

598: IF i = 0 THEN
599: RAISE fnd_api.g_exc_error;
600: END IF; -- end if recipe_id not found
601:
602: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
603: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
604:
605: EXCEPTION
606: WHEN FND_API.G_EXC_ERROR THEN

Line 747: -- standard call to get msge cnt, and if cnt is 1, get mesg info

743: IF i = 0 THEN
744: RAISE fnd_api.g_exc_error;
745: END IF; -- end if recipe_id not found
746:
747: -- standard call to get msge cnt, and if cnt is 1, get mesg info
748: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN

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

1042: END LOOP; /* FOR j IN 1..x_recipe_step_out.COUNT */
1043:
1044: END IF; /* If routing id is not null */
1045:
1046: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1047: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1048:
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN

Line 1094: standard_delay, minimum_delay, max_delay, transfer_qty, RoutingStep_No_uom,

1090:
1091:
1092: CURSOR get_depd IS
1093: SELECT routingstep_no,dep_routingstep_no, routing_id, dep_type, rework_code,
1094: standard_delay, minimum_delay, max_delay, transfer_qty, RoutingStep_No_uom,
1095: transfer_pct, text_code, creation_date, created_by,last_updated_by,
1096: last_update_date, last_update_login,chargeable_ind
1097: --Sriram.S APS K Enhancements 03March2004 Bug# 3410379
1098: --Added chargable_ind column to the select statement

Line 1154: x_routing_depd_tbl(i).standard_delay := get_rec.standard_delay ;

1150: x_routing_depd_tbl(i).routingstep_no := get_rec.routingstep_no ;
1151: x_routing_depd_tbl(i).routing_id := get_rec.routing_id;
1152: x_routing_depd_tbl(i).dep_type := get_rec.dep_type;
1153: x_routing_depd_tbl(i).rework_code := get_rec.rework_code ;
1154: x_routing_depd_tbl(i).standard_delay := get_rec.standard_delay ;
1155: x_routing_depd_tbl(i).minimum_delay := get_rec.minimum_delay ;
1156: x_routing_depd_tbl(i).max_delay := get_rec.max_delay ;
1157: x_routing_depd_tbl(i).transfer_qty := get_rec.transfer_qty ;
1158: x_routing_depd_tbl(i).RoutingStep_No_uom := get_rec.RoutingStep_No_uom;

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

1173: END IF;
1174: END IF;
1175: END IF;
1176:
1177: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1178: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1179:
1180: EXCEPTION
1181: WHEN FND_API.G_EXC_ERROR THEN

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

1353: IF i = 0 THEN
1354: RAISE fnd_api.g_exc_error;
1355: END IF;
1356:
1357: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
1358: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1359:
1360: EXCEPTION
1361: WHEN FND_API.G_EXC_ERROR THEN

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

1601: IF i = 0 THEN
1602: RAISE fnd_api.g_exc_error;
1603: END IF; -- end if recipe_id not found
1604:
1605: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
1606: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1607:
1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN