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

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

77: l_out_rec gmd_parameters_dtl_pkg.parameter_rec_type;
78: l_fixed_process_loss NUMBER; /* B6811759 */
79: l_fixed_process_loss_uom VARCHAR2(3); /*B6811759 */
80: /* Variables used for defining status */
81: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
82: l_return_code NUMBER := 0;
83: l_rowid VARCHAR2(32);
84:
85: /* Error message count and data */

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88:
89: l_val_rt_status BOOLEAN;
90: BEGIN
91: /* Initialize API return status to success */
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: -- Bug 2099699. Sukarna Reddy dt 02/19/02.
94: -- Check if proper routing is associated with recipe
95: IF (p_recipe_header_rec.routing_id IS NOT NULL) THEN
96: l_val_rt_status := gmd_recipe_val.check_routing_validity

Line 103: RAISE FND_API.G_EXC_ERROR;

99: '100'));
100: IF (NOT l_val_rt_status) THEN
101: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: END IF;
106: -- End bug 2099699
107:

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: /* passed tp create a recipe */
111: /* ====================================== */
112: If ((p_recipe_header_rec.recipe_no IS NULL )
113: OR (p_recipe_header_rec.recipe_version IS NULL)) THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
116: FND_MSG_PUB.Add;
117: END IF;
118:

Line 126: p_init_msg_list => FND_API.G_FALSE,

122: /* already exists in the database */
123: /* ================================= */
124: GMD_RECIPE_VAL.recipe_name
125: ( p_api_version => 1.0,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_recipe_no => p_recipe_header_rec.recipe_no,
129: p_recipe_version => p_recipe_header_rec.recipe_version,
130: x_return_status => l_return_status,

Line 127: p_commit => FND_API.G_FALSE,

123: /* ================================= */
124: GMD_RECIPE_VAL.recipe_name
125: ( p_api_version => 1.0,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_recipe_no => p_recipe_header_rec.recipe_no,
129: p_recipe_version => p_recipe_header_rec.recipe_version,
130: x_return_status => l_return_status,
131: x_msg_count => l_msg_count,

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133: x_return_code => l_return_code,
134: x_recipe_id => l_recipe_id);
135:
136: IF (l_recipe_id IS NOT NULL) THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('GMD', 'GMD_DUP_RECIPE');
139: FND_MSG_PUB.ADD;
140: END IF;
141:

Line 186: p_init_msg_list => FND_API.G_FALSE,

182: /* ==================================== */
183: If (p_recipe_header_rec.recipe_description IS NOT NULL) THEN
184: GMD_RECIPE_VAL.recipe_description
185: ( p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_recipe_description => p_recipe_header_rec.recipe_description,
189: x_return_status => l_return_status,
190: x_msg_count => l_msg_count,

Line 187: p_commit => FND_API.G_FALSE,

183: If (p_recipe_header_rec.recipe_description IS NOT NULL) THEN
184: GMD_RECIPE_VAL.recipe_description
185: ( p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_recipe_description => p_recipe_header_rec.recipe_description,
189: x_return_status => l_return_status,
190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data,

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

190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data,
192: x_return_code => l_return_code);
193:
194: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DESCRIPTION');
197: FND_MSG_PUB.ADD;
198: END IF;

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: x_msg_data => l_msg_data,
192: x_return_code => l_return_code);
193:
194: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DESCRIPTION');
197: FND_MSG_PUB.ADD;
198: END IF;
199: ELSE

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DESCRIPTION');
197: FND_MSG_PUB.ADD;
198: END IF;
199: ELSE
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DECRIPTION');
202: FND_MSG_PUB.ADD;
203: END IF;
204:

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213: X_out_rec => l_out_rec,
214: X_return_status => l_return_status);
215:
216: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
219: FND_MSG_PUB.ADD;
220: END IF;*/
221:

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305: X_FIXED_PROCESS_LOSS_UOM => p_recipe_header_rec.fixed_process_loss_uom
306: );
307: END IF;
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: );
307: END IF;
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: END CREATE_RECIPE_HEADER;

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

309: WHEN FND_API.G_EXC_ERROR THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: END CREATE_RECIPE_HEADER;
315:
316:
317: /* ================================================== */

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

375: l_plant_ind NUMBER;
376: l_out_rec gmd_parameters_dtl_pkg.parameter_rec_type;
377:
378: /* Variables used for defining status */
379: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
380: l_return_code NUMBER := 0;
381: l_rowid VARCHAR2(32);
382:
383: /* Error message count and data */

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: x_routing_id NUMBER;
424: l_status_type gmd_status.status_type%type;
425: BEGIN
426: /* Initialize API return status to success */
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: -- Bug 2099699. Sukarna Reddy dt 02/19/02.
430: -- Check if proper routing is associated with recipe
431: IF (p_recipe_header_rec.routing_id IS NOT NULL) THEN

Line 448: RAISE FND_API.G_EXC_ERROR;

444: p_recipe_header_rec.recipe_Status);
445: IF (NOT l_val_rt_status) THEN
446: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
447: FND_MSG_PUB.ADD;
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450: ELSIF (l_status_type IN ('700','900')) THEN
451: IF (x_routing_id IS NOT NULL AND
452: p_recipe_header_rec.routing_id IS NOT NULL AND

Line 456: RAISE FND_API.G_EXC_ERROR;

452: p_recipe_header_rec.routing_id IS NOT NULL AND
453: x_routing_id <> p_recipe_header_rec.routing_id) THEN
454: FND_MESSAGE.SET_NAME('GMD','GMD_RECIPE_INVALID_MODE');
455: FND_MSG_PUB.ADD;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458: END IF;
459: END IF;
460: -- End bug 2099699

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

470: Description => l_description ,
471: x_return_status => l_return_status
472: );
473:
474: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: END IF;
477:
478: IF (p_recipe_header_rec.Recipe_status BETWEEN '900' and '999') THEN

Line 475: x_return_status := FND_API.G_RET_STS_ERROR;

471: x_return_status => l_return_status
472: );
473:
474: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: END IF;
477:
478: IF (p_recipe_header_rec.Recipe_status BETWEEN '900' and '999') THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475: x_return_status := FND_API.G_RET_STS_ERROR;
476: END IF;
477:
478: IF (p_recipe_header_rec.Recipe_status BETWEEN '900' and '999') THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_UPDATE_NOT_ALLOWED');
481: FND_MSG_PUB.ADD;
482: END IF;
483:

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: X_out_rec => l_out_rec,
527: X_return_status => l_return_status);
528:
529: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
532: FND_MSG_PUB.ADD;
533: END IF;*/
534:

Line 665: WHEN FND_API.G_EXC_ERROR THEN

661: --End bug 5138316 KSHUKLA
662:
663: END IF; -- End if for x_return_status = 'S'
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: WHEN OTHERS THEN
668: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662:
663: END IF; -- End if for x_return_status = 'S'
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: WHEN OTHERS THEN
668: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: END UPDATE_RECIPE_HEADER;

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

665: WHEN FND_API.G_EXC_ERROR THEN
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: WHEN OTHERS THEN
668: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: END UPDATE_RECIPE_HEADER;
671:
672:
673: PROCEDURE DELETE_RECIPE_HEADER

Line 799: IF p_recipe_header_rec.recipe_id = FND_API.G_MISS_NUM THEN

795: l_rowcount := l_rowcount + 1;
796: IF (l_debug = 'Y') THEN
797: gmd_debug.put_line('-- 1. Check for Recipe id ');
798: END IF;
799: IF p_recipe_header_rec.recipe_id = FND_API.G_MISS_NUM THEN
800: fnd_message.set_name ('GMI', 'GMI_MISSING');
801: fnd_message.set_token ('MISSING', 'RECIPE_ID');
802: fnd_msg_pub.add;
803: RAISE copy_recipe_err;

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

827: x_return_code => l_return_code ,
828: x_recipe_id => l_recipe_header_rec.recipe_id
829: );
830: -- Its ok only if the above validation returns an error.
831: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
832: l_recipe_header_rec.recipe_id := p_recipe_header_rec.recipe_id;
833: ELSE -- This is an invalid Recipe Id
834: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
835: fnd_msg_pub.add;

Line 845: IF p_recipe_header_rec.recipe_no = FND_API.G_MISS_CHAR THEN

841: IF (l_debug = 'Y') THEN
842: gmd_debug.put_line('-- 2. Check for Recipe Number (recipe_no) ');
843: END IF;
844:
845: IF p_recipe_header_rec.recipe_no = FND_API.G_MISS_CHAR THEN
846: fnd_message.set_name ('GMI', 'GMI_MISSING');
847: fnd_message.set_token ('MISSING', 'RECIPE_NO');
848: fnd_msg_pub.add;
849: RAISE copy_recipe_err;

Line 867: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

863: ,x_return_code => l_return_code
864: ,x_recipe_id => l_recipe_header_rec.recipe_id
865: );
866:
867: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
868: l_recipe_header_rec.recipe_no := p_recipe_header_rec.recipe_no;
869: l_changed_flag := TRUE;
870: ELSE
871: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');

Line 885: IF p_recipe_header_rec.recipe_version = FND_API.G_MISS_NUM THEN

881: IF (l_debug = 'Y') THEN
882: gmd_debug.put_line('-- 3. Check for Recipe Version (recipe_version) ');
883: END IF;
884:
885: IF p_recipe_header_rec.recipe_version = FND_API.G_MISS_NUM THEN
886: fnd_message.set_name ('GMI', 'GMI_MISSING');
887: fnd_message.set_token ('MISSING', 'RECIPE_VERSION');
888: fnd_msg_pub.add;
889: RAISE copy_recipe_err;

Line 909: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

905: ,x_return_code => l_return_code
906: ,x_recipe_id => l_recipe_header_rec.recipe_id
907: );
908:
909: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
910: l_recipe_header_rec.recipe_version
911: := p_recipe_header_rec.recipe_version;
912: l_changed_flag := TRUE;
913: ELSE

Line 954: IF p_recipe_header_rec.recipe_description = FND_API.G_MISS_CHAR THEN

950: IF (l_debug = 'Y') THEN
951: gmd_debug.put_line('-- 3.1. Check for Recipe Description ');
952: END IF;
953:
954: IF p_recipe_header_rec.recipe_description = FND_API.G_MISS_CHAR THEN
955: fnd_message.set_name ('GMI', 'GMI_MISSING');
956: fnd_message.set_token ('MISSING', 'RECIPE_DESCRIPTION');
957: fnd_msg_pub.add;
958: RAISE copy_recipe_err;

Line 978: IF p_recipe_header_rec.user_id = FND_API.G_MISS_NUM THEN

974:
975: IF (l_debug = 'Y') THEN
976: gmd_debug.put_line('-- 4. Check for user id ');
977: END IF;
978: IF p_recipe_header_rec.user_id = FND_API.G_MISS_NUM THEN
979: fnd_message.set_name ('GMI', 'GMI_MISSING');
980: fnd_message.set_token ('MISSING', 'USER ID');
981: fnd_msg_pub.add;
982: RAISE copy_recipe_err;

Line 998: IF p_recipe_header_rec.owner_organization_id = FND_API.G_MISS_NUM THEN

994: IF (l_debug = 'Y') THEN
995: gmd_debug.put_line('-- 5. Check for owner orgn code ');
996: END IF;
997:
998: IF p_recipe_header_rec.owner_organization_id = FND_API.G_MISS_NUM THEN
999: fnd_message.set_name ('GMI', 'GMI_MISSING');
1000: fnd_message.set_token ('MISSING', 'OWNER_ORGANIZATION_ID');
1001: fnd_msg_pub.add;
1002: RAISE copy_recipe_err;

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: X_out_rec => l_out_rec,
1013: X_return_status => l_return_status);
1014:
1015: IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
1018: FND_MSG_PUB.ADD;
1019: ELSE
1020: l_recipe_header_rec.owner_organization_id

Line 1034: IF p_recipe_header_rec.creation_organization_id = FND_API.G_MISS_NUM THEN

1030:
1031: IF (l_debug = 'Y') THEN
1032: gmd_debug.put_line('-- 6. Check for creation orgn code ');
1033: END IF;
1034: IF p_recipe_header_rec.creation_organization_id = FND_API.G_MISS_NUM THEN
1035: fnd_message.set_name ('GMI', 'GMI_MISSING');
1036: fnd_message.set_token ('MISSING', 'CREATION_ORGANIZATION_ID');
1037: fnd_msg_pub.add;
1038: RAISE copy_recipe_err;

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR;

1048: X_out_rec => l_out_rec,
1049: X_return_status => l_return_status);
1050:
1051: IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
1054: FND_MSG_PUB.ADD;
1055: ELSE
1056: l_recipe_header_rec.creation_organization_id

Line 1070: IF p_recipe_header_rec.formula_id = FND_API.G_MISS_NUM THEN

1066:
1067: IF (l_debug = 'Y') THEN
1068: gmd_debug.put_line('-- 7. Check for formula id ');
1069: END IF;
1070: IF p_recipe_header_rec.formula_id = FND_API.G_MISS_NUM THEN
1071: fnd_message.set_name ('GMI', 'GMI_MISSING');
1072: fnd_message.set_token ('MISSING', 'FORMULA_ID');
1073: fnd_msg_pub.add;
1074: RAISE copy_recipe_err;

Line 1114: IF (p_recipe_header_rec.formula_no = FND_API.G_MISS_CHAR) OR

1110: but different formula_no and/or formula_vers?
1111: Then we need to the formula id that corresponds to this
1112: changed formula_no and/or formula_vers
1113: */
1114: IF (p_recipe_header_rec.formula_no = FND_API.G_MISS_CHAR) OR
1115: (p_recipe_header_rec.formula_vers = FND_API.G_MISS_NUM) THEN
1116: fnd_message.set_name ('GMI', 'GMI_MISSING');
1117: fnd_message.set_token ('MISSING', 'FORMULA_NO OR VERS');
1118: fnd_msg_pub.add;

Line 1115: (p_recipe_header_rec.formula_vers = FND_API.G_MISS_NUM) THEN

1111: Then we need to the formula id that corresponds to this
1112: changed formula_no and/or formula_vers
1113: */
1114: IF (p_recipe_header_rec.formula_no = FND_API.G_MISS_CHAR) OR
1115: (p_recipe_header_rec.formula_vers = FND_API.G_MISS_NUM) THEN
1116: fnd_message.set_name ('GMI', 'GMI_MISSING');
1117: fnd_message.set_token ('MISSING', 'FORMULA_NO OR VERS');
1118: fnd_msg_pub.add;
1119: RAISE copy_recipe_err;

Line 1160: IF p_recipe_header_rec.routing_id = FND_API.G_MISS_NUM THEN

1156: IF (l_debug = 'Y') THEN
1157: gmd_debug.put_line('-- 9. Check for routing_id ');
1158: END IF;
1159:
1160: IF p_recipe_header_rec.routing_id = FND_API.G_MISS_NUM THEN
1161: l_recipe_header_rec.routing_id := NULL;
1162: ELSE
1163: IF p_recipe_header_rec.routing_id IS NULL THEN
1164: /* Check if Routing no and version is passed */

Line 1200: IF (p_recipe_header_rec.routing_no = FND_API.G_MISS_CHAR) OR

1196: id derived from routing_no and/or routing_vers passed in.
1197: We need to do this only if the old and new routing id are
1198: different.
1199: */
1200: IF (p_recipe_header_rec.routing_no = FND_API.G_MISS_CHAR) OR
1201: (p_recipe_header_rec.routing_vers = FND_API.G_MISS_NUM) THEN
1202: -- We set the Routing id to a Null value
1203: l_recipe_header_rec.routing_id := NULL;
1204: ELSE

Line 1201: (p_recipe_header_rec.routing_vers = FND_API.G_MISS_NUM) THEN

1197: We need to do this only if the old and new routing id are
1198: different.
1199: */
1200: IF (p_recipe_header_rec.routing_no = FND_API.G_MISS_CHAR) OR
1201: (p_recipe_header_rec.routing_vers = FND_API.G_MISS_NUM) THEN
1202: -- We set the Routing id to a Null value
1203: l_recipe_header_rec.routing_id := NULL;
1204: ELSE
1205: IF (l_recipe_header_rec.routing_id

Line 1239: IF p_recipe_header_rec.recipe_status = FND_API.G_MISS_CHAR THEN

1235: END IF; -- Condition ends when routing_id were same and ....
1236: END IF;
1237:
1238: /* Recipe status should always be set to New */
1239: IF p_recipe_header_rec.recipe_status = FND_API.G_MISS_CHAR THEN
1240: fnd_message.set_name ('GMI', 'GMI_MISSING');
1241: fnd_message.set_token ('MISSING', 'RECIPE_STATUS');
1242: fnd_msg_pub.add;
1243: RAISE copy_recipe_err;

Line 1248: IF p_recipe_header_rec.planned_process_loss = FND_API.G_MISS_NUM THEN

1244: ELSE
1245: l_recipe_header_rec.recipe_status := '100';
1246: END IF;
1247:
1248: IF p_recipe_header_rec.planned_process_loss = FND_API.G_MISS_NUM THEN
1249: l_recipe_header_rec.planned_process_loss := NULL;
1250: ELSE
1251: IF p_recipe_header_rec.planned_process_loss IS NULL THEN
1252: l_recipe_header_rec.planned_process_loss

Line 1264: IF p_recipe_header_rec.fixed_process_loss = FND_API.G_MISS_NUM THEN

1260: := old_recipe_rec.planned_process_loss;
1261: END IF;
1262: END IF;
1263: /* B6811759 */
1264: IF p_recipe_header_rec.fixed_process_loss = FND_API.G_MISS_NUM THEN
1265: l_recipe_header_rec.fixed_process_loss := NULL;
1266: ELSE
1267: IF p_recipe_header_rec.fixed_process_loss IS NULL THEN
1268: l_recipe_header_rec.fixed_process_loss

Line 1279: IF p_recipe_header_rec.fixed_process_loss_uom = FND_API.G_MISS_CHAR THEN

1275: l_recipe_header_rec.fixed_process_loss
1276: := old_recipe_rec.fixed_process_loss;
1277: END IF;
1278: END IF;
1279: IF p_recipe_header_rec.fixed_process_loss_uom = FND_API.G_MISS_CHAR THEN
1280: l_recipe_header_rec.fixed_process_loss_uom := NULL;
1281: ELSE
1282: IF p_recipe_header_rec.fixed_process_loss_uom IS NULL THEN
1283: l_recipe_header_rec.fixed_process_loss_uom

Line 1332: IF p_recipe_header_rec.text_code = FND_API.G_MISS_NUM THEN

1328: := old_recipe_rec.recipe_type;
1329: END IF;
1330:
1331:
1332: IF p_recipe_header_rec.text_code = FND_API.G_MISS_NUM THEN
1333: l_recipe_header_rec.text_code := NULL;
1334: ELSE
1335: IF p_recipe_header_rec.text_code IS NULL THEN
1336: l_recipe_header_rec.text_code

Line 1350: IF p_recipe_header_rec.delete_mark = FND_API.G_MISS_NUM THEN

1346: END IF;
1347: END IF;
1348:
1349: /* Delete Mark should always be set to 0 */
1350: IF p_recipe_header_rec.delete_mark = FND_API.G_MISS_NUM THEN
1351: fnd_message.set_name ('GMI', 'GMI_MISSING');
1352: fnd_message.set_token ('MISSING', 'DELETE_MARK');
1353: fnd_msg_pub.add;
1354: RAISE copy_recipe_err;

Line 1359: IF p_recipe_header_rec.creation_date = FND_API.G_MISS_DATE THEN

1355: ELSE
1356: l_recipe_header_rec.delete_mark := 0;
1357: END IF;
1358:
1359: IF p_recipe_header_rec.creation_date = FND_API.G_MISS_DATE THEN
1360: fnd_message.set_name ('GMI', 'GMI_MISSING');
1361: fnd_message.set_token ('MISSING', 'CREATION_DATE');
1362: fnd_msg_pub.add;
1363: RAISE copy_recipe_err;

Line 1379: IF p_recipe_header_rec.created_by = FND_API.G_MISS_NUM THEN

1375: := old_recipe_rec.creation_date;
1376: END IF;
1377: END IF;
1378:
1379: IF p_recipe_header_rec.created_by = FND_API.G_MISS_NUM THEN
1380: fnd_message.set_name ('GMI', 'GMI_MISSING');
1381: fnd_message.set_token ('MISSING', 'CREATED_BY');
1382: fnd_msg_pub.add;
1383: RAISE copy_recipe_err;

Line 1399: IF p_recipe_header_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1395: := old_recipe_rec.created_by;
1396: END IF;
1397: END IF;
1398:
1399: IF p_recipe_header_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1400: fnd_message.set_name ('GMI', 'GMI_MISSING');
1401: fnd_message.set_token ('MISSING', 'LAST_UPDATED_BY');
1402: fnd_msg_pub.add;
1403: RAISE copy_recipe_err;

Line 1419: IF p_recipe_header_rec.last_update_date = FND_API.G_MISS_DATE THEN

1415: := old_recipe_rec.last_updated_by;
1416: END IF;
1417: END IF;
1418:
1419: IF p_recipe_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
1420: fnd_message.set_name ('GMI', 'GMI_MISSING');
1421: fnd_message.set_token ('MISSING', 'LAST_UPDATE_DATE');
1422: fnd_msg_pub.add;
1423: RAISE copy_recipe_err;

Line 1439: IF p_recipe_header_rec.last_update_login = FND_API.G_MISS_NUM THEN

1435: := old_recipe_rec.last_update_date;
1436: END IF;
1437: END IF;
1438:
1439: IF p_recipe_header_rec.last_update_login = FND_API.G_MISS_NUM THEN
1440: l_recipe_header_rec.last_update_login := NULL;
1441: ELSE
1442: IF p_recipe_header_rec.last_update_login IS NULL THEN
1443: l_recipe_header_rec.last_update_login

Line 1456: IF p_recipe_header_rec.owner_id = FND_API.G_MISS_NUM THEN

1452: := old_recipe_rec.last_update_login;
1453: END IF;
1454: END IF;
1455:
1456: IF p_recipe_header_rec.owner_id = FND_API.G_MISS_NUM THEN
1457: fnd_message.set_name ('GMI', 'GMI_MISSING');
1458: fnd_message.set_token ('MISSING', 'OWNER_ID');
1459: fnd_msg_pub.add;
1460: RAISE copy_recipe_err;

Line 1476: IF p_recipe_header_rec.owner_lab_type = FND_API.G_MISS_CHAR THEN

1472: := old_recipe_rec.owner_id;
1473: END IF;
1474: END IF;
1475:
1476: IF p_recipe_header_rec.owner_lab_type = FND_API.G_MISS_CHAR THEN
1477: l_recipe_header_rec.owner_lab_type := NULL;
1478: ELSE
1479: IF p_recipe_header_rec.owner_lab_type IS NULL THEN
1480: l_recipe_header_rec.owner_lab_type

Line 1493: IF p_recipe_header_rec.calculate_step_quantity = FND_API.G_MISS_NUM THEN

1489: := old_recipe_rec.owner_lab_type;
1490: END IF;
1491: END IF;
1492:
1493: IF p_recipe_header_rec.calculate_step_quantity = FND_API.G_MISS_NUM THEN
1494: l_recipe_header_rec.calculate_step_quantity := NULL;
1495: ELSE
1496: IF p_recipe_header_rec.calculate_step_quantity IS NULL THEN
1497: l_recipe_header_rec.calculate_step_quantity

Line 1511: IF p_recipe_hdr_flex_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1507: END IF;
1508: END IF;
1509:
1510: -- Flex field attributes
1511: IF p_recipe_hdr_flex_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1512: l_recipe_hdr_flex_rec.attribute1 := NULL;
1513: ELSE
1514: IF p_recipe_hdr_flex_rec.attribute1 IS NULL THEN
1515: l_recipe_hdr_flex_rec.attribute1

Line 1528: IF p_recipe_hdr_flex_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1524: := old_recipe_rec.attribute1;
1525: END IF;
1526: END IF;
1527:
1528: IF p_recipe_hdr_flex_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1529: l_recipe_hdr_flex_rec.attribute2 := NULL;
1530: ELSE
1531: IF p_recipe_hdr_flex_rec.attribute2 IS NULL THEN
1532: l_recipe_hdr_flex_rec.attribute2

Line 1545: IF p_recipe_hdr_flex_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1541: := old_recipe_rec.attribute2;
1542: END IF;
1543: END IF;
1544:
1545: IF p_recipe_hdr_flex_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1546: l_recipe_hdr_flex_rec.attribute3 := NULL;
1547: ELSE
1548: IF p_recipe_hdr_flex_rec.attribute3 IS NULL THEN
1549: l_recipe_hdr_flex_rec.attribute3

Line 1562: IF p_recipe_hdr_flex_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1558: := old_recipe_rec.attribute3;
1559: END IF;
1560: END IF;
1561:
1562: IF p_recipe_hdr_flex_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1563: l_recipe_hdr_flex_rec.attribute4 := NULL;
1564: ELSE
1565: IF p_recipe_hdr_flex_rec.attribute4 IS NULL THEN
1566: l_recipe_hdr_flex_rec.attribute4

Line 1579: IF p_recipe_hdr_flex_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1575: := old_recipe_rec.attribute4;
1576: END IF;
1577: END IF;
1578:
1579: IF p_recipe_hdr_flex_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1580: l_recipe_hdr_flex_rec.attribute5 := NULL;
1581: ELSE
1582: IF p_recipe_hdr_flex_rec.attribute5 IS NULL THEN
1583: l_recipe_hdr_flex_rec.attribute5

Line 1596: IF p_recipe_hdr_flex_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1592: := old_recipe_rec.attribute5;
1593: END IF;
1594: END IF;
1595:
1596: IF p_recipe_hdr_flex_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1597: l_recipe_hdr_flex_rec.attribute6 := NULL;
1598: ELSE
1599: IF p_recipe_hdr_flex_rec.attribute6 IS NULL THEN
1600: l_recipe_hdr_flex_rec.attribute6

Line 1613: IF p_recipe_hdr_flex_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1609: := old_recipe_rec.attribute6;
1610: END IF;
1611: END IF;
1612:
1613: IF p_recipe_hdr_flex_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1614: l_recipe_hdr_flex_rec.attribute7 := NULL;
1615: ELSE
1616: IF p_recipe_hdr_flex_rec.attribute7 IS NULL THEN
1617: l_recipe_hdr_flex_rec.attribute7

Line 1630: IF p_recipe_hdr_flex_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1626: := old_recipe_rec.attribute7;
1627: END IF;
1628: END IF;
1629:
1630: IF p_recipe_hdr_flex_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1631: l_recipe_hdr_flex_rec.attribute8 := NULL;
1632: ELSE
1633: IF p_recipe_hdr_flex_rec.attribute8 IS NULL THEN
1634: l_recipe_hdr_flex_rec.attribute8

Line 1647: IF p_recipe_hdr_flex_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1643: := old_recipe_rec.attribute8;
1644: END IF;
1645: END IF;
1646:
1647: IF p_recipe_hdr_flex_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1648: l_recipe_hdr_flex_rec.attribute9 := NULL;
1649: ELSE
1650: IF p_recipe_hdr_flex_rec.attribute9 IS NULL THEN
1651: l_recipe_hdr_flex_rec.attribute9

Line 1664: IF p_recipe_hdr_flex_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1660: := old_recipe_rec.attribute9;
1661: END IF;
1662: END IF;
1663:
1664: IF p_recipe_hdr_flex_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1665: l_recipe_hdr_flex_rec.attribute10 := NULL;
1666: ELSE
1667: IF p_recipe_hdr_flex_rec.attribute10 IS NULL THEN
1668: l_recipe_hdr_flex_rec.attribute10

Line 1681: IF p_recipe_hdr_flex_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1677: := old_recipe_rec.attribute10;
1678: END IF;
1679: END IF;
1680:
1681: IF p_recipe_hdr_flex_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1682: l_recipe_hdr_flex_rec.attribute11 := NULL;
1683: ELSE
1684: IF p_recipe_hdr_flex_rec.attribute11 IS NULL THEN
1685: l_recipe_hdr_flex_rec.attribute11

Line 1698: IF p_recipe_hdr_flex_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1694: := old_recipe_rec.attribute11;
1695: END IF;
1696: END IF;
1697:
1698: IF p_recipe_hdr_flex_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1699: l_recipe_hdr_flex_rec.attribute12 := NULL;
1700: ELSE
1701: IF p_recipe_hdr_flex_rec.attribute12 IS NULL THEN
1702: l_recipe_hdr_flex_rec.attribute12

Line 1715: IF p_recipe_hdr_flex_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1711: := old_recipe_rec.attribute2;
1712: END IF;
1713: END IF;
1714:
1715: IF p_recipe_hdr_flex_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1716: l_recipe_hdr_flex_rec.attribute13 := NULL;
1717: ELSE
1718: IF p_recipe_hdr_flex_rec.attribute13 IS NULL THEN
1719: l_recipe_hdr_flex_rec.attribute13

Line 1732: IF p_recipe_hdr_flex_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1728: := old_recipe_rec.attribute13;
1729: END IF;
1730: END IF;
1731:
1732: IF p_recipe_hdr_flex_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1733: l_recipe_hdr_flex_rec.attribute14 := NULL;
1734: ELSE
1735: IF p_recipe_hdr_flex_rec.attribute14 IS NULL THEN
1736: l_recipe_hdr_flex_rec.attribute14

Line 1749: IF p_recipe_hdr_flex_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1745: := old_recipe_rec.attribute14;
1746: END IF;
1747: END IF;
1748:
1749: IF p_recipe_hdr_flex_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1750: l_recipe_hdr_flex_rec.attribute15 := NULL;
1751: ELSE
1752: IF p_recipe_hdr_flex_rec.attribute15 IS NULL THEN
1753: l_recipe_hdr_flex_rec.attribute15

Line 1766: IF p_recipe_hdr_flex_rec.attribute16 = FND_API.G_MISS_CHAR THEN

1762: := old_recipe_rec.attribute15;
1763: END IF;
1764: END IF;
1765:
1766: IF p_recipe_hdr_flex_rec.attribute16 = FND_API.G_MISS_CHAR THEN
1767: l_recipe_hdr_flex_rec.attribute16 := NULL;
1768: ELSE
1769: IF p_recipe_hdr_flex_rec.attribute16 IS NULL THEN
1770: l_recipe_hdr_flex_rec.attribute16

Line 1783: IF p_recipe_hdr_flex_rec.attribute17 = FND_API.G_MISS_CHAR THEN

1779: := old_recipe_rec.attribute16;
1780: END IF;
1781: END IF;
1782:
1783: IF p_recipe_hdr_flex_rec.attribute17 = FND_API.G_MISS_CHAR THEN
1784: l_recipe_hdr_flex_rec.attribute17 := NULL;
1785: ELSE
1786: IF p_recipe_hdr_flex_rec.attribute17 IS NULL THEN
1787: l_recipe_hdr_flex_rec.attribute17

Line 1800: IF p_recipe_hdr_flex_rec.attribute18 = FND_API.G_MISS_CHAR THEN

1796: := old_recipe_rec.attribute17;
1797: END IF;
1798: END IF;
1799:
1800: IF p_recipe_hdr_flex_rec.attribute18 = FND_API.G_MISS_CHAR THEN
1801: l_recipe_hdr_flex_rec.attribute18 := NULL;
1802: ELSE
1803: IF p_recipe_hdr_flex_rec.attribute18 IS NULL THEN
1804: l_recipe_hdr_flex_rec.attribute18

Line 1817: IF p_recipe_hdr_flex_rec.attribute19 = FND_API.G_MISS_CHAR THEN

1813: := old_recipe_rec.attribute18;
1814: END IF;
1815: END IF;
1816:
1817: IF p_recipe_hdr_flex_rec.attribute19 = FND_API.G_MISS_CHAR THEN
1818: l_recipe_hdr_flex_rec.attribute19 := NULL;
1819: ELSE
1820: IF p_recipe_hdr_flex_rec.attribute19 IS NULL THEN
1821: l_recipe_hdr_flex_rec.attribute19

Line 1834: IF p_recipe_hdr_flex_rec.attribute20 = FND_API.G_MISS_CHAR THEN

1830: := old_recipe_rec.attribute19;
1831: END IF;
1832: END IF;
1833:
1834: IF p_recipe_hdr_flex_rec.attribute20 = FND_API.G_MISS_CHAR THEN
1835: l_recipe_hdr_flex_rec.attribute20 := NULL;
1836: ELSE
1837: IF p_recipe_hdr_flex_rec.attribute20 IS NULL THEN
1838: l_recipe_hdr_flex_rec.attribute20

Line 1851: IF p_recipe_hdr_flex_rec.attribute21 = FND_API.G_MISS_CHAR THEN

1847: := old_recipe_rec.attribute20;
1848: END IF;
1849: END IF;
1850:
1851: IF p_recipe_hdr_flex_rec.attribute21 = FND_API.G_MISS_CHAR THEN
1852: l_recipe_hdr_flex_rec.attribute21 := NULL;
1853: ELSE
1854: IF p_recipe_hdr_flex_rec.attribute21 IS NULL THEN
1855: l_recipe_hdr_flex_rec.attribute21

Line 1868: IF p_recipe_hdr_flex_rec.attribute22 = FND_API.G_MISS_CHAR THEN

1864: := old_recipe_rec.attribute21;
1865: END IF;
1866: END IF;
1867:
1868: IF p_recipe_hdr_flex_rec.attribute22 = FND_API.G_MISS_CHAR THEN
1869: l_recipe_hdr_flex_rec.attribute22 := NULL;
1870: ELSE
1871: IF p_recipe_hdr_flex_rec.attribute22 IS NULL THEN
1872: l_recipe_hdr_flex_rec.attribute22

Line 1885: IF p_recipe_hdr_flex_rec.attribute23 = FND_API.G_MISS_CHAR THEN

1881: := old_recipe_rec.attribute2;
1882: END IF;
1883: END IF;
1884:
1885: IF p_recipe_hdr_flex_rec.attribute23 = FND_API.G_MISS_CHAR THEN
1886: l_recipe_hdr_flex_rec.attribute23 := NULL;
1887: ELSE
1888: IF p_recipe_hdr_flex_rec.attribute23 IS NULL THEN
1889: l_recipe_hdr_flex_rec.attribute23

Line 1902: IF p_recipe_hdr_flex_rec.attribute24 = FND_API.G_MISS_CHAR THEN

1898: := old_recipe_rec.attribute23;
1899: END IF;
1900: END IF;
1901:
1902: IF p_recipe_hdr_flex_rec.attribute24 = FND_API.G_MISS_CHAR THEN
1903: l_recipe_hdr_flex_rec.attribute24 := NULL;
1904: ELSE
1905: IF p_recipe_hdr_flex_rec.attribute24 IS NULL THEN
1906: l_recipe_hdr_flex_rec.attribute24

Line 1919: IF p_recipe_hdr_flex_rec.attribute25 = FND_API.G_MISS_CHAR THEN

1915: := old_recipe_rec.attribute24;
1916: END IF;
1917: END IF;
1918:
1919: IF p_recipe_hdr_flex_rec.attribute25 = FND_API.G_MISS_CHAR THEN
1920: l_recipe_hdr_flex_rec.attribute25 := NULL;
1921: ELSE
1922: IF p_recipe_hdr_flex_rec.attribute25 IS NULL THEN
1923: l_recipe_hdr_flex_rec.attribute25

Line 1936: IF p_recipe_hdr_flex_rec.attribute26 = FND_API.G_MISS_CHAR THEN

1932: := old_recipe_rec.attribute25;
1933: END IF;
1934: END IF;
1935:
1936: IF p_recipe_hdr_flex_rec.attribute26 = FND_API.G_MISS_CHAR THEN
1937: l_recipe_hdr_flex_rec.attribute26 := NULL;
1938: ELSE
1939: IF p_recipe_hdr_flex_rec.attribute26 IS NULL THEN
1940: l_recipe_hdr_flex_rec.attribute26

Line 1953: IF p_recipe_hdr_flex_rec.attribute27 = FND_API.G_MISS_CHAR THEN

1949: := old_recipe_rec.attribute26;
1950: END IF;
1951: END IF;
1952:
1953: IF p_recipe_hdr_flex_rec.attribute27 = FND_API.G_MISS_CHAR THEN
1954: l_recipe_hdr_flex_rec.attribute27 := NULL;
1955: ELSE
1956: IF p_recipe_hdr_flex_rec.attribute27 IS NULL THEN
1957: l_recipe_hdr_flex_rec.attribute27

Line 1970: IF p_recipe_hdr_flex_rec.attribute28 = FND_API.G_MISS_CHAR THEN

1966: := old_recipe_rec.attribute27;
1967: END IF;
1968: END IF;
1969:
1970: IF p_recipe_hdr_flex_rec.attribute28 = FND_API.G_MISS_CHAR THEN
1971: l_recipe_hdr_flex_rec.attribute28 := NULL;
1972: ELSE
1973: IF p_recipe_hdr_flex_rec.attribute28 IS NULL THEN
1974: l_recipe_hdr_flex_rec.attribute28

Line 1987: IF p_recipe_hdr_flex_rec.attribute29 = FND_API.G_MISS_CHAR THEN

1983: := old_recipe_rec.attribute28;
1984: END IF;
1985: END IF;
1986:
1987: IF p_recipe_hdr_flex_rec.attribute29 = FND_API.G_MISS_CHAR THEN
1988: l_recipe_hdr_flex_rec.attribute29 := NULL;
1989: ELSE
1990: IF p_recipe_hdr_flex_rec.attribute29 IS NULL THEN
1991: l_recipe_hdr_flex_rec.attribute29

Line 2004: IF p_recipe_hdr_flex_rec.attribute30 = FND_API.G_MISS_CHAR THEN

2000: := old_recipe_rec.attribute29;
2001: END IF;
2002: END IF;
2003:
2004: IF p_recipe_hdr_flex_rec.attribute30 = FND_API.G_MISS_CHAR THEN
2005: l_recipe_hdr_flex_rec.attribute30 := NULL;
2006: ELSE
2007: IF p_recipe_hdr_flex_rec.attribute30 IS NULL THEN
2008: l_recipe_hdr_flex_rec.attribute30

Line 2021: IF p_recipe_hdr_flex_rec.attribute_category = FND_API.G_MISS_CHAR THEN

2017: := old_recipe_rec.attribute30;
2018: END IF;
2019: END IF;
2020:
2021: IF p_recipe_hdr_flex_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2022: l_recipe_hdr_flex_rec.attribute_category := NULL;
2023: ELSE
2024: IF p_recipe_hdr_flex_rec.attribute_category IS NULL THEN
2025: l_recipe_hdr_flex_rec.attribute_category

Line 2045: IF x_return_status <> FND_API.g_ret_sts_success THEN

2041: GMD_RECIPE_HEADER_PVT.create_recipe_header
2042: (p_recipe_header_rec => l_recipe_header_rec
2043: ,p_recipe_hdr_flex_rec => p_recipe_hdr_flex_rec
2044: ,x_return_status => x_return_status);
2045: IF x_return_status <> FND_API.g_ret_sts_success THEN
2046: RAISE copy_recipe_err;
2047: END IF; -- End condition when create API return state is ...
2048: ELSE -- when l_changed_flag is False
2049: IF (l_debug = 'Y') THEN

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR;

2064:
2065:
2066: EXCEPTION
2067: WHEN copy_recipe_err THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: WHEN OTHERS THEN
2070: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2072: END COPY_RECIPE_HEADER;

Line 2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2067: WHEN copy_recipe_err THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: WHEN OTHERS THEN
2070: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2072: END COPY_RECIPE_HEADER;
2073:
2074: /* ================================================== */
2075: /* Procedure: */

Line 2103: x_return_status := FND_API.G_RET_STS_SUCCESS;

2099: l_fm_tab_out GMDFMVAL_PUB.formula_table_out;
2100: l_return_status VARCHAR2(1);
2101: BEGIN
2102: /* Initialize return status */
2103: x_return_status := FND_API.G_RET_STS_SUCCESS;
2104:
2105: /* =================================== */
2106: /* Check if a formula_id OR */
2107: /* a formula_no and formula_vers combo */

Line 2118: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

2114: GMDFMVAL_PUB.get_element(pElement_name => 'FORMULA',
2115: pRecord_in => l_fm_rec_in,
2116: xTable_out => l_fm_tab_out,
2117: xReturn => l_return_status);
2118: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
2119: IF (p_formula_no IS NULL) AND
2120: (p_formula_id IS NULL) THEN
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');

Line 2121: x_return_status := FND_API.G_RET_STS_ERROR;

2117: xReturn => l_return_status);
2118: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
2119: IF (p_formula_no IS NULL) AND
2120: (p_formula_id IS NULL) THEN
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
2123: FND_MSG_PUB.Add;
2124: ELSIF (p_formula_vers IS NULL) AND
2125: (p_formula_id IS NULL) THEN

Line 2126: x_return_status := FND_API.G_RET_STS_ERROR;

2122: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
2123: FND_MSG_PUB.Add;
2124: ELSIF (p_formula_vers IS NULL) AND
2125: (p_formula_id IS NULL) THEN
2126: x_return_status := FND_API.G_RET_STS_ERROR;
2127: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
2128: FND_MSG_PUB.Add;
2129: ELSE
2130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2130: x_return_status := FND_API.G_RET_STS_ERROR;

2126: x_return_status := FND_API.G_RET_STS_ERROR;
2127: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
2128: FND_MSG_PUB.Add;
2129: ELSE
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF p_formula_id IS NOT NULL THEN
2132: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVFORMULA_ID');
2133: FND_MESSAGE.SET_TOKEN('FORMULA_ID', p_formula_id);
2134: ELSE

Line 2150: IF l_return_status <> FND_API.g_ret_sts_success THEN

2146: (x_formula_id IS NOT NULL) THEN
2147: GMD_API_GRP.check_item_exists (p_formula_id => x_formula_id
2148: ,p_organization_id => p_owner_organization_id
2149: ,x_return_status => l_return_status);
2150: IF l_return_status <> FND_API.g_ret_sts_success THEN
2151: x_return_status := l_return_status;
2152: END IF;
2153: END IF;
2154: END validate_formula;