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 557: WHEN FND_API.G_EXC_ERROR THEN

553: ,p_recipe_mtl_flex_rec.ATTRIBUTE28
554: ,p_recipe_mtl_flex_rec.ATTRIBUTE29
555: ,p_recipe_mtl_flex_rec.ATTRIBUTE30);
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 558: x_return_status := FND_API.G_RET_STS_ERROR;

554: ,p_recipe_mtl_flex_rec.ATTRIBUTE29
555: ,p_recipe_mtl_flex_rec.ATTRIBUTE30);
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: END CREATE_RECIPE_MTL;

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: END CREATE_RECIPE_MTL;
563:
564: /* ================================================== */
565: /* Procedure: */

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

589:
590: l_recipe_process_loss_id NUMBER := 0;
591:
592: /* Variables used for defining status */
593: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
594: l_return_code NUMBER := 0;
595:
596: /* Error message count and data */
597: l_msg_count NUMBER;

Line 602: x_return_status := FND_API.G_RET_STS_SUCCESS;

598: l_msg_data VARCHAR2(2000);
599: l_return_stat VARCHAR2(10);
600: BEGIN
601: /* Initialization of all status */
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603:
604: /* ==================================== */
605: /* Validate orgn code if it has been */
606: /* provided */

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: X_out_rec => l_out_rec,
612: X_return_status => l_return_stat);
613:
614: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
617: FND_MSG_PUB.ADD;
618: END IF;*/
619: END IF;

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

618: END IF;*/
619: END IF;
620:
621: /* Update into the recipe process loss table */
622: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
623: UPDATE gmd_recipe_process_loss
624: SET recipe_id = p_recipe_detail_rec.recipe_id ,
625: organization_id = p_recipe_detail_rec.organization_id,
626: text_code = p_recipe_detail_rec.text_code,

Line 641: WHEN FND_API.G_EXC_ERROR THEN

637: WHERE recipe_process_loss_id = p_recipe_detail_rec.recipe_process_loss_id;
638: END IF;
639:
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN OTHERS THEN
644: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: END IF;
639:
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN OTHERS THEN
644: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: END UPDATE_RECIPE_PROCESS_LOSS;

Line 645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

641: WHEN FND_API.G_EXC_ERROR THEN
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN OTHERS THEN
644: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: END UPDATE_RECIPE_PROCESS_LOSS;
647:
648: /* ================================================== */
649: /* Procedure: */

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

667: /* Defining all local variables */
668: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
669:
670: /* Variables used for defining status */
671: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
672: l_return_code NUMBER := 0;
673:
674: /* Error message count and data */
675: l_msg_count NUMBER;

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

676: l_msg_data VARCHAR2(2000);
677:
678: BEGIN
679: /* Initialization of all status */
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: /* Update the recipe customer table */
683: /* only who columns needs to be updated */
684: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: /* Update the recipe customer table */
683: /* only who columns needs to be updated */
684: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
685: UPDATE GMD_RECIPE_CUSTOMERS
686: SET text_code = p_recipe_detail_rec.text_code,
687: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
688: gmd_api_grp.user_id),

Line 697: WHEN FND_API.G_EXC_ERROR THEN

693: WHERE recipe_id = p_recipe_detail_rec.recipe_id AND
694: customer_id = p_recipe_detail_rec.customer_id;
695: END IF;
696: EXCEPTION
697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: WHEN OTHERS THEN
700: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: customer_id = p_recipe_detail_rec.customer_id;
695: END IF;
696: EXCEPTION
697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: WHEN OTHERS THEN
700: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: END UPDATE_RECIPE_CUSTOMERS;

Line 701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: WHEN OTHERS THEN
700: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: END UPDATE_RECIPE_CUSTOMERS;
703:
704: /* ================================================== */
705: /* Procedure: */

Line 741: x_return_status := FND_API.G_RET_STS_SUCCESS;

737: Where recipe_validity_rule_id = pVR_id;
738:
739: BEGIN
740: /* Initialization of all status */
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: OPEN get_db_vr_rec(p_recipe_vr_rec.recipe_validity_rule_id);
744: FETCH get_db_vr_rec INTO l_vr_db_rec;
745: CLOSE get_db_vr_rec;

Line 1129: ,p_encoded => FND_API.g_false

1125:
1126: /* Get the messgae list and count generated by this API */
1127: fnd_msg_pub.count_and_get (
1128: p_count => l_msg_cnt
1129: ,p_encoded => FND_API.g_false
1130: ,p_data => l_msg_list);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129: ,p_encoded => FND_API.g_false
1130: ,p_data => l_msg_list);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: WHEN OTHERS THEN
1136: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR;

1130: ,p_data => l_msg_list);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: WHEN OTHERS THEN
1136: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: END UPDATE_RECIPE_VR;

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: WHEN OTHERS THEN
1136: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: END UPDATE_RECIPE_VR;
1139:
1140: /* ===================================================*/
1141: /* Procedure: */

Line 1181: x_return_status := FND_API.G_RET_STS_SUCCESS;

1177: /* in gmd_recipe_routing_step table. [Form initially shows values from */
1178: /* fm_rout_dtl. When user "changes" values, they are saved in recipe table.] */
1179:
1180: /* Initialization of status. */
1181: x_return_status := FND_API.G_RET_STS_SUCCESS;
1182:
1183: OPEN recipe_rout_cur(p_recipe_detail_rec.recipe_id,
1184: p_recipe_detail_rec.routingstep_id);
1185: FETCH recipe_rout_cur INTO l_rc_id, l_rcst_id;

Line 1337: WHEN FND_API.G_EXC_ERROR THEN

1333: WHERE recipe_id = p_recipe_detail_rec.recipe_id
1334: AND routingstep_id = p_recipe_detail_rec.routingstep_id;
1335: END IF; /* ends dml type */
1336: EXCEPTION
1337: WHEN FND_API.G_EXC_ERROR THEN
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339: WHEN OTHERS THEN
1340: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1338: x_return_status := FND_API.G_RET_STS_ERROR;

1334: AND routingstep_id = p_recipe_detail_rec.routingstep_id;
1335: END IF; /* ends dml type */
1336: EXCEPTION
1337: WHEN FND_API.G_EXC_ERROR THEN
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339: WHEN OTHERS THEN
1340: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: END Recipe_Routing_Steps;

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1337: WHEN FND_API.G_EXC_ERROR THEN
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339: WHEN OTHERS THEN
1340: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: END Recipe_Routing_Steps;
1343:
1344: /* ================================================== */
1345: /* Procedure: */

Line 1387: x_return_status := FND_API.G_RET_STS_SUCCESS;

1383: /* Updating recipe orgn activity for forst time infact insert a new record in */
1384: /* gmd_recipe_orgn activities table */
1385:
1386: /* Initialization of all status */
1387: x_return_status := FND_API.G_RET_STS_SUCCESS;
1388:
1389: /* To decide on the operation to perform */
1390: /* If activity already exists then it is a update */
1391: OPEN recipe_activity_cur(p_recipe_detail_rec.recipe_id,

Line 1535: WHEN FND_API.G_EXC_ERROR THEN

1531: ATTRIBUTE_CATEGORY = p_flex_update_rec.attribute_category
1532: WHERE rowid = l_rowid;
1533: END IF; /* ends dml type */
1534: EXCEPTION
1535: WHEN FND_API.G_EXC_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: WHEN OTHERS THEN
1538: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1536: x_return_status := FND_API.G_RET_STS_ERROR;

1532: WHERE rowid = l_rowid;
1533: END IF; /* ends dml type */
1534: EXCEPTION
1535: WHEN FND_API.G_EXC_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: WHEN OTHERS THEN
1538: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: END RECIPE_ORGN_OPERATIONS;

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1535: WHEN FND_API.G_EXC_ERROR THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: WHEN OTHERS THEN
1538: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: END RECIPE_ORGN_OPERATIONS;
1541:
1542:
1543: /* ================================================== */

Line 1591: x_return_status := FND_API.G_RET_STS_SUCCESS;

1587: /* Updating recipe orgn resources for forst time infact insert a new record in */
1588: /* gmd_recipe_orgn_resources table */
1589:
1590: /* Initialization of all status */
1591: x_return_status := FND_API.G_RET_STS_SUCCESS;
1592:
1593: /* To decide on the operation to perform */
1594: /* If resource already exists then it is a update */
1595: OPEN recipe_resources_cur(p_recipe_detail_rec.recipe_id, p_recipe_detail_rec.routingstep_id,

Line 1774: WHEN FND_API.G_EXC_ERROR THEN

1770: WHERE rowid = l_rowid;
1771:
1772: END IF; /* ends dml type */
1773: EXCEPTION
1774: WHEN FND_API.G_EXC_ERROR THEN
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN OTHERS THEN
1777: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771:
1772: END IF; /* ends dml type */
1773: EXCEPTION
1774: WHEN FND_API.G_EXC_ERROR THEN
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN OTHERS THEN
1777: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1779: END RECIPE_ORGN_RESOURCES;

Line 1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1774: WHEN FND_API.G_EXC_ERROR THEN
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN OTHERS THEN
1777: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1779: END RECIPE_ORGN_RESOURCES;
1780:
1781: END GMD_RECIPE_DETAIL_PVT; /* Package end */