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 1091: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/

1087: END LOOP; /* FOR j IN 1..x_recipe_step_out.COUNT */
1088:
1089: END IF; /* If routing id is not null */
1090:
1091: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1092: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1093:
1094: EXCEPTION
1095: WHEN FND_API.G_EXC_ERROR THEN

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

1135:
1136:
1137: CURSOR get_depd IS
1138: SELECT routingstep_no,dep_routingstep_no, routing_id, dep_type, rework_code,
1139: standard_delay, minimum_delay, max_delay, transfer_qty, RoutingStep_No_uom,
1140: transfer_pct, text_code, creation_date, created_by,last_updated_by,
1141: last_update_date, last_update_login,chargeable_ind
1142: --Sriram.S APS K Enhancements 03March2004 Bug# 3410379
1143: --Added chargable_ind column to the select statement

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

1195: x_routing_depd_tbl(i).routingstep_no := get_rec.routingstep_no ;
1196: x_routing_depd_tbl(i).routing_id := get_rec.routing_id;
1197: x_routing_depd_tbl(i).dep_type := get_rec.dep_type;
1198: x_routing_depd_tbl(i).rework_code := get_rec.rework_code ;
1199: x_routing_depd_tbl(i).standard_delay := get_rec.standard_delay ;
1200: x_routing_depd_tbl(i).minimum_delay := get_rec.minimum_delay ;
1201: x_routing_depd_tbl(i).max_delay := get_rec.max_delay ;
1202: x_routing_depd_tbl(i).transfer_qty := get_rec.transfer_qty ;
1203: x_routing_depd_tbl(i).RoutingStep_No_uom := get_rec.RoutingStep_No_uom;

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

1218: END IF;
1219: END IF;
1220: END IF;
1221:
1222: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1223: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1224:
1225: EXCEPTION
1226: WHEN FND_API.G_EXC_ERROR THEN

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

1399: IF i = 0 THEN
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402:
1403: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
1404: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1405:
1406: EXCEPTION
1407: WHEN FND_API.G_EXC_ERROR THEN

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

1662: IF i = 0 THEN
1663: RAISE fnd_api.g_exc_error;
1664: END IF; -- end if recipe_id not found
1665:
1666: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
1667: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1668:
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN