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_DETAIL_PVT dependencies on FND_API

Line 37: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

33:
34: l_recipe_process_loss_id NUMBER := 0;
35:
36: /* Variables used for defining status */
37: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
38: l_return_code NUMBER := 0;
39:
40: /* Error message count and data */
41: l_msg_count NUMBER;

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: l_return_stat VARCHAR2(10);
44:
45: BEGIN
46: /* Initialization of all status */
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: /* ==================================== */
50: /* Validate orgn code if it has been */
51: /* provided */

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: X_out_rec => l_out_rec,
57: X_return_status => l_return_stat);
58:
59: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
62: FND_MSG_PUB.ADD;
63: END IF;*/
64: END IF;

Line 78: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

74: ELSE
75: l_recipe_process_loss_id := p_recipe_detail_rec.recipe_process_loss_id;
76: END IF;
77:
78: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
79: INSERT INTO GMD_RECIPE_PROCESS_LOSS(
80: recipe_process_loss_id
81: ,recipe_id
82: ,organization_id

Line 114: WHEN FND_API.G_EXC_ERROR THEN

110: );
111:
112: END IF;
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: WHEN OTHERS THEN
117: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 115: x_return_status := FND_API.G_RET_STS_ERROR;

111:
112: END IF;
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: WHEN OTHERS THEN
117: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: END CREATE_RECIPE_PROCESS_LOSS;

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: WHEN FND_API.G_EXC_ERROR THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: WHEN OTHERS THEN
117: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: END CREATE_RECIPE_PROCESS_LOSS;
120:
121: /* ================================================== */
122: /* Procedure: */

Line 145: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

141: /* Defining all local variables */
142: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_CUSTOMERS';
143:
144: /* Variables used for defining status */
145: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
146: l_return_code NUMBER := 0;
147:
148: /* Error message count and data */
149: l_msg_count NUMBER;

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: l_msg_data VARCHAR2(2000);
151:
152: BEGIN
153: /* Initialization of all status */
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: /* ====================================== */
157: /* Check if this customer exists in our */
158: /* Recipe Customer table */

Line 169: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

165: X_MSG_COUNT => l_msg_count ,
166: X_MSG_DATA => l_msg_data ,
167: X_RETURN_CODE => l_return_code);
168:
169: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
172: FND_MSG_PUB.ADD;
173: END IF;

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: X_MSG_DATA => l_msg_data ,
167: X_RETURN_CODE => l_return_code);
168:
169: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
172: FND_MSG_PUB.ADD;
173: END IF;
174:

Line 175: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

171: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
172: FND_MSG_PUB.ADD;
173: END IF;
174:
175: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
176: INSERT INTO GMD_RECIPE_CUSTOMERS(
177: recipe_id ,
178: customer_id ,
179: site_id ,

Line 205: WHEN FND_API.G_EXC_ERROR THEN

201: );
202: END IF;
203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: WHEN OTHERS THEN
208: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202: END IF;
203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: WHEN OTHERS THEN
208: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: END CREATE_RECIPE_CUSTOMERS;

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205: WHEN FND_API.G_EXC_ERROR THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: WHEN OTHERS THEN
208: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: END CREATE_RECIPE_CUSTOMERS;
211:
212: /* ================================================== */
213: /* Procedure: */

Line 239: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

235: l_recipe_vr_id NUMBER := 0;
236: l_item_id NUMBER := 0;
237:
238: /* Variables used for defining status */
239: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
240: l_return_code NUMBER := 0;
241: l_plant_ind NUMBER;
242: l_lab_ind NUMBER;
243:

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254:
255: Setup_Failure EXCEPTION;
256: BEGIN
257: /* Initialization of all status */
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: /* Intialize the setup fields */
261: IF NOT gmd_api_grp.setup_done THEN
262: gmd_api_grp.setup_done := gmd_api_grp.setup;

Line 276: p_init_msg_list => FND_API.G_FALSE,

272: /* Set the required indicator */
273: /* ============================================== */
274: GMD_RECIPE_VAL.recipe_orgn_code(
275: p_api_version => 1.0,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: g_orgn_id => p_recipe_vr_rec.organization_id,
279: g_user_id => NVL(p_recipe_vr_rec.created_by,
280: gmd_api_grp.user_id),

Line 277: p_commit => FND_API.G_FALSE,

273: /* ============================================== */
274: GMD_RECIPE_VAL.recipe_orgn_code(
275: p_api_version => 1.0,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: g_orgn_id => p_recipe_vr_rec.organization_id,
279: g_user_id => NVL(p_recipe_vr_rec.created_by,
280: gmd_api_grp.user_id),
281: p_required_ind => 'N',

Line 289: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

285: x_return_code => l_return_code,
286: x_plant_ind => l_plant_ind,
287: x_lab_ind => l_lab_ind);
288:
289: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
292: FND_MSG_PUB.ADD;
293: END IF;

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: x_plant_ind => l_plant_ind,
287: x_lab_ind => l_lab_ind);
288:
289: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
292: FND_MSG_PUB.ADD;
293: END IF;
294:

Line 305: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

301: l_item_id := p_recipe_vr_rec.inventory_item_id;
302: END IF;
303:
304: /* Insert into the recipe validity rules table */
305: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
306: /* ======================================== */
307: /* Generate the Validity Rule Id */
308: /* Sequence number */
309: /* ======================================== */

Line 439: WHEN FND_API.G_EXC_ERROR OR setup_failure THEN

435: );
436:
437: END IF;
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR OR setup_failure THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: WHEN OTHERS THEN
442: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436:
437: END IF;
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR OR setup_failure THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: WHEN OTHERS THEN
442: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: END CREATE_RECIPE_VR;

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: WHEN FND_API.G_EXC_ERROR OR setup_failure THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: WHEN OTHERS THEN
442: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: END CREATE_RECIPE_VR;
445:
446: /* ================================================== */
447: /* Procedure: */

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_MTL';
469:
470: BEGIN
471: /* Initialization of all status */
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: /* Insert into the recipe materials table */
475: INSERT INTO GMD_RECIPE_STEP_MATERIALS(
476: recipe_id

Line 567: WHEN FND_API.G_EXC_ERROR THEN

563: ,p_recipe_mtl_flex_rec.ATTRIBUTE28
564: ,p_recipe_mtl_flex_rec.ATTRIBUTE29
565: ,p_recipe_mtl_flex_rec.ATTRIBUTE30);
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: WHEN OTHERS THEN
570: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: ,p_recipe_mtl_flex_rec.ATTRIBUTE29
565: ,p_recipe_mtl_flex_rec.ATTRIBUTE30);
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: WHEN OTHERS THEN
570: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: END CREATE_RECIPE_MTL;

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

567: WHEN FND_API.G_EXC_ERROR THEN
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: WHEN OTHERS THEN
570: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: END CREATE_RECIPE_MTL;
573:
574: /* ================================================== */
575: /* Procedure: */

Line 603: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

599:
600: l_recipe_process_loss_id NUMBER := 0;
601:
602: /* Variables used for defining status */
603: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
604: l_return_code NUMBER := 0;
605:
606: /* Error message count and data */
607: l_msg_count NUMBER;

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: l_msg_data VARCHAR2(2000);
609: l_return_stat VARCHAR2(10);
610: BEGIN
611: /* Initialization of all status */
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: /* ==================================== */
615: /* Validate orgn code if it has been */
616: /* provided */

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: X_out_rec => l_out_rec,
622: X_return_status => l_return_stat);
623:
624: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
627: FND_MSG_PUB.ADD;
628: END IF;*/
629: END IF;

Line 632: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

628: END IF;*/
629: END IF;
630:
631: /* Update into the recipe process loss table */
632: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
633: UPDATE gmd_recipe_process_loss
634: SET recipe_id = p_recipe_detail_rec.recipe_id ,
635: organization_id = p_recipe_detail_rec.organization_id,
636: text_code = p_recipe_detail_rec.text_code,

Line 651: WHEN FND_API.G_EXC_ERROR THEN

647: WHERE recipe_process_loss_id = p_recipe_detail_rec.recipe_process_loss_id;
648: END IF;
649:
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: WHEN OTHERS THEN
654: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648: END IF;
649:
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: WHEN OTHERS THEN
654: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: END UPDATE_RECIPE_PROCESS_LOSS;

Line 655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: WHEN OTHERS THEN
654: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: END UPDATE_RECIPE_PROCESS_LOSS;
657:
658: /* ================================================== */
659: /* Procedure: */

Line 681: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

677: /* Defining all local variables */
678: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
679:
680: /* Variables used for defining status */
681: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
682: l_return_code NUMBER := 0;
683:
684: /* Error message count and data */
685: l_msg_count NUMBER;

Line 690: x_return_status := FND_API.G_RET_STS_SUCCESS;

686: l_msg_data VARCHAR2(2000);
687:
688: BEGIN
689: /* Initialization of all status */
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: /* Update the recipe customer table */
693: /* only who columns needs to be updated */
694: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 694: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: /* Update the recipe customer table */
693: /* only who columns needs to be updated */
694: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
695: UPDATE GMD_RECIPE_CUSTOMERS
696: SET text_code = p_recipe_detail_rec.text_code,
697: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
698: gmd_api_grp.user_id),

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703: WHERE recipe_id = p_recipe_detail_rec.recipe_id AND
704: customer_id = p_recipe_detail_rec.customer_id;
705: END IF;
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: WHEN OTHERS THEN
710: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 708: x_return_status := FND_API.G_RET_STS_ERROR;

704: customer_id = p_recipe_detail_rec.customer_id;
705: END IF;
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: WHEN OTHERS THEN
710: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: END UPDATE_RECIPE_CUSTOMERS;

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: WHEN FND_API.G_EXC_ERROR THEN
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: WHEN OTHERS THEN
710: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: END UPDATE_RECIPE_CUSTOMERS;
713:
714: /* ================================================== */
715: /* Procedure: */

Line 751: x_return_status := FND_API.G_RET_STS_SUCCESS;

747: Where recipe_validity_rule_id = pVR_id;
748:
749: BEGIN
750: /* Initialization of all status */
751: x_return_status := FND_API.G_RET_STS_SUCCESS;
752:
753: OPEN get_db_vr_rec(p_recipe_vr_rec.recipe_validity_rule_id);
754: FETCH get_db_vr_rec INTO l_vr_db_rec;
755: CLOSE get_db_vr_rec;

Line 1139: ,p_encoded => FND_API.g_false

1135:
1136: /* Get the messgae list and count generated by this API */
1137: fnd_msg_pub.count_and_get (
1138: p_count => l_msg_cnt
1139: ,p_encoded => FND_API.g_false
1140: ,p_data => l_msg_list);
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139: ,p_encoded => FND_API.g_false
1140: ,p_data => l_msg_list);
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: WHEN OTHERS THEN
1146: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: ,p_data => l_msg_list);
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: WHEN OTHERS THEN
1146: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: END UPDATE_RECIPE_VR;

Line 1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: WHEN OTHERS THEN
1146: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: END UPDATE_RECIPE_VR;
1149:
1150: /* ===================================================*/
1151: /* Procedure: */

Line 1191: x_return_status := FND_API.G_RET_STS_SUCCESS;

1187: /* in gmd_recipe_routing_step table. [Form initially shows values from */
1188: /* fm_rout_dtl. When user "changes" values, they are saved in recipe table.] */
1189:
1190: /* Initialization of status. */
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192:
1193: OPEN recipe_rout_cur(p_recipe_detail_rec.recipe_id,
1194: p_recipe_detail_rec.routingstep_id);
1195: FETCH recipe_rout_cur INTO l_rc_id, l_rcst_id;

Line 1347: WHEN FND_API.G_EXC_ERROR THEN

1343: WHERE recipe_id = p_recipe_detail_rec.recipe_id
1344: AND routingstep_id = p_recipe_detail_rec.routingstep_id;
1345: END IF; /* ends dml type */
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WHEN OTHERS THEN
1350: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1348: x_return_status := FND_API.G_RET_STS_ERROR;

1344: AND routingstep_id = p_recipe_detail_rec.routingstep_id;
1345: END IF; /* ends dml type */
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WHEN OTHERS THEN
1350: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: END Recipe_Routing_Steps;

Line 1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WHEN OTHERS THEN
1350: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: END Recipe_Routing_Steps;
1353:
1354: /* ================================================== */
1355: /* Procedure: */

Line 1397: x_return_status := FND_API.G_RET_STS_SUCCESS;

1393: /* Updating recipe orgn activity for forst time infact insert a new record in */
1394: /* gmd_recipe_orgn activities table */
1395:
1396: /* Initialization of all status */
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: /* To decide on the operation to perform */
1400: /* If activity already exists then it is a update */
1401: OPEN recipe_activity_cur(p_recipe_detail_rec.recipe_id,

Line 1545: WHEN FND_API.G_EXC_ERROR THEN

1541: ATTRIBUTE_CATEGORY = p_flex_update_rec.attribute_category
1542: WHERE rowid = l_rowid;
1543: END IF; /* ends dml type */
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: WHEN OTHERS THEN
1548: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: WHERE rowid = l_rowid;
1543: END IF; /* ends dml type */
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: WHEN OTHERS THEN
1548: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: END RECIPE_ORGN_OPERATIONS;

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: WHEN OTHERS THEN
1548: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: END RECIPE_ORGN_OPERATIONS;
1551:
1552:
1553: /* ================================================== */

Line 1601: x_return_status := FND_API.G_RET_STS_SUCCESS;

1597: /* Updating recipe orgn resources for forst time infact insert a new record in */
1598: /* gmd_recipe_orgn_resources table */
1599:
1600: /* Initialization of all status */
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: /* To decide on the operation to perform */
1604: /* If resource already exists then it is a update */
1605: OPEN recipe_resources_cur(p_recipe_detail_rec.recipe_id, p_recipe_detail_rec.routingstep_id,

Line 1784: WHEN FND_API.G_EXC_ERROR THEN

1780: WHERE rowid = l_rowid;
1781:
1782: END IF; /* ends dml type */
1783: EXCEPTION
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := FND_API.G_RET_STS_ERROR;
1786: WHEN OTHERS THEN
1787: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1785: x_return_status := FND_API.G_RET_STS_ERROR;

1781:
1782: END IF; /* ends dml type */
1783: EXCEPTION
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := FND_API.G_RET_STS_ERROR;
1786: WHEN OTHERS THEN
1787: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: END RECIPE_ORGN_RESOURCES;

Line 1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := FND_API.G_RET_STS_ERROR;
1786: WHEN OTHERS THEN
1787: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: END RECIPE_ORGN_RESOURCES;
1790:
1791: END GMD_RECIPE_DETAIL_PVT; /* Package end */