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

Line 28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */

24: /* Standard parameters: */
25: /* IN: */
26: /* P_api_version - standard parameter */
27: /* P_init_msg_list - standard parameter (clear error msg list or not) */
28: /* P_commit - standard parameter. Should be FND_API.G_FALSE */
29: /* This procedure does no insert/update/delete */
30: /* P_validation_level - standard parameter */
31: /* OUT: */
32: /* x_return_status - standard parameter. S=success,E=expected error, */

Line 51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

47: /**************************************************************************** */
48:
49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,

Line 52: p_commit IN VARCHAR2 := FND_API.G_FALSE,

48:
49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,
56: p_recipe_version IN NUMBER,

Line 53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,
56: p_recipe_version IN NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,

Line 90: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

86: l_api_version CONSTANT NUMBER := 1.1;
87:
88: BEGIN
89: /* no SAVEPOINT needed because there is no insert/update/delete */
90: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
91: l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: BEGIN
89: /* no SAVEPOINT needed because there is no insert/update/delete */
90: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
91: l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: IF FND_API.to_Boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;

Line 94: IF FND_API.to_Boolean(p_init_msg_list) THEN

90: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
91: l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: IF FND_API.to_Boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: END IF;
94: IF FND_API.to_Boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: IF (p_recipe_id IS NOT NULL) THEN
100: OPEN get_record_with_recipe_id(p_recipe_id);
101: FETCH get_record_with_recipe_id into x_recipe_id;

Line 105: RAISE FND_API.G_EXC_ERROR;

101: FETCH get_record_with_recipe_id into x_recipe_id;
102: IF get_record_with_recipe_id%NOTFOUND THEN
103: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: CLOSE get_record_with_recipe_id;
108: ELSE
109: OPEN get_record_without_recipe_id(p_recipe_no, p_recipe_version);

Line 114: RAISE FND_API.G_EXC_ERROR;

110: FETCH get_record_without_recipe_id into x_recipe_id;
111: IF get_record_without_recipe_id%NOTFOUND THEN
112: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
113: FND_MSG_PUB.Add;
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: CLOSE get_record_without_recipe_id;
117: END IF;
118:

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
120: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: X_return_code := SQLCODE;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
127:

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: X_return_code := SQLCODE;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_code := SQLCODE;

Line 128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

124: X_return_code := SQLCODE;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_code := SQLCODE;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_code := SQLCODE;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:
133: WHEN OTHERS THEN
134: X_return_code := SQLCODE;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:
133: WHEN OTHERS THEN
134: X_return_code := SQLCODE;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
137:
138: END recipe_exists;
139:

Line 153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

149: /**************************************************************************** */
150:
151: PROCEDURE recipe_name
152: ( p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
156: p_recipe_no IN VARCHAR2,
157: p_recipe_version IN NUMBER,

Line 154: p_commit IN VARCHAR2 := FND_API.G_FALSE,

150:
151: PROCEDURE recipe_name
152: ( p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
156: p_recipe_no IN VARCHAR2,
157: p_recipe_version IN NUMBER,
158: p_action_code IN VARCHAR2 := 'U',

Line 155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

151: PROCEDURE recipe_name
152: ( p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
156: p_recipe_no IN VARCHAR2,
157: p_recipe_version IN NUMBER,
158: p_action_code IN VARCHAR2 := 'U',
159: x_return_status OUT NOCOPY VARCHAR2,

Line 177: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

173: l_api_version CONSTANT NUMBER := 1.0;
174:
175: BEGIN
176: /* no SAVEPOINT needed because there is no insert/update/delete */
177: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
178: l_api_name, G_PKG_NAME) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: BEGIN
176: /* no SAVEPOINT needed because there is no insert/update/delete */
177: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
178: l_api_name, G_PKG_NAME) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;

Line 181: IF FND_API.to_Boolean(p_init_msg_list) THEN

177: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
178: l_api_name, G_PKG_NAME) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: END IF;
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: OPEN get_record;
187: FETCH get_record into x_recipe_id;
188:

Line 191: RAISE fnd_api.g_exc_error;

187: FETCH get_record into x_recipe_id;
188:
189: IF P_action_code = 'I' THEN
190: IF get_record%FOUND THEN
191: RAISE fnd_api.g_exc_error;
192: END IF; /* end if record not found */
193: ELSIF p_action_code = 'U' THEN
194: IF get_record%NOTFOUND THEN
195: RAISE fnd_api.g_exc_error;

Line 195: RAISE fnd_api.g_exc_error;

191: RAISE fnd_api.g_exc_error;
192: END IF; /* end if record not found */
193: ELSIF p_action_code = 'U' THEN
194: IF get_record%NOTFOUND THEN
195: RAISE fnd_api.g_exc_error;
196: END IF;
197: ELSE
198: RAISE fnd_api.g_exc_error;
199: END IF; /* end if action code is insert or update */

Line 198: RAISE fnd_api.g_exc_error;

194: IF get_record%NOTFOUND THEN
195: RAISE fnd_api.g_exc_error;
196: END IF;
197: ELSE
198: RAISE fnd_api.g_exc_error;
199: END IF; /* end if action code is insert or update */
200:
201: CLOSE get_record;
202:

Line 209: WHEN FND_API.G_EXC_ERROR THEN

205: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
206: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: X_return_code := SQLCODE;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
213:

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: X_return_code := SQLCODE;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: X_return_code := SQLCODE;

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: X_return_code := SQLCODE;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: X_return_code := SQLCODE;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
218:

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: X_return_code := SQLCODE;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
218:
219: WHEN OTHERS THEN
220: X_return_code := SQLCODE;

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
218:
219: WHEN OTHERS THEN
220: X_return_code := SQLCODE;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
223:
224: END recipe_name;
225:

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

239: /* LRJackson 14Nov2000 Created */
240: /**************************************************************************** */
241: PROCEDURE get_new_id
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,

Line 244: p_commit IN VARCHAR2 := FND_API.G_FALSE,

240: /**************************************************************************** */
241: PROCEDURE get_new_id
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,

Line 245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

241: PROCEDURE get_new_id
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: x_return_code OUT NOCOPY NUMBER,

Line 262: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

258: l_api_version CONSTANT NUMBER := 1.0;
259:
260: BEGIN
261: /* no SAVEPOINT needed because there is no insert/update/delete */
262: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
263: l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: BEGIN
261: /* no SAVEPOINT needed because there is no insert/update/delete */
262: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
263: l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: IF FND_API.to_Boolean(p_init_msg_list) THEN
267: FND_MSG_PUB.initialize;
268: END IF;

Line 266: IF FND_API.to_Boolean(p_init_msg_list) THEN

262: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
263: l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: IF FND_API.to_Boolean(p_init_msg_list) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: END IF;
266: IF FND_API.to_Boolean(p_init_msg_list) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: OPEN get_new_id;
272: FETCH get_new_id into x_recipe_id;
273: CLOSE get_new_id;

Line 280: WHEN FND_API.G_EXC_ERROR THEN

276: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
277: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: X_return_code := SQLCODE;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
284:

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: X_return_code := SQLCODE;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: X_return_code := SQLCODE;

Line 285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

281: X_return_code := SQLCODE;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN OTHERS THEN
291: X_return_code := SQLCODE;

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN OTHERS THEN
291: X_return_code := SQLCODE;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
294:
295: END get_new_id;
296:

Line 315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

311: /* LRJackson 27Dec2000 Updated parameters */
312: /**************************************************************************** */
313: PROCEDURE recipe_for_update
314: ( p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
318: p_recipe_id IN NUMBER,
319: p_last_update_date IN DATE,

Line 316: p_commit IN VARCHAR2 := FND_API.G_FALSE,

312: /**************************************************************************** */
313: PROCEDURE recipe_for_update
314: ( p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
318: p_recipe_id IN NUMBER,
319: p_last_update_date IN DATE,
320: p_form_or_asynch IN VARCHAR2 := 'A',

Line 317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

313: PROCEDURE recipe_for_update
314: ( p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
318: p_recipe_id IN NUMBER,
319: p_last_update_date IN DATE,
320: p_form_or_asynch IN VARCHAR2 := 'A',
321: x_return_status OUT NOCOPY VARCHAR2,

Line 338: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

334: l_update_date DATE;
335:
336: BEGIN
337: /* no SAVEPOINT needed because there is no insert/update/delete */
338: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
339: l_api_name, G_PKG_NAME) THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: BEGIN
337: /* no SAVEPOINT needed because there is no insert/update/delete */
338: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
339: l_api_name, G_PKG_NAME) THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: IF FND_API.to_Boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;

Line 342: IF FND_API.to_Boolean(p_init_msg_list) THEN

338: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
339: l_api_name, G_PKG_NAME) THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: IF FND_API.to_Boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: END IF;
342: IF FND_API.to_Boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: OPEN get_recipe_data;
348: FETCH get_recipe_data into l_update_date;
349: IF get_recipe_data%NOTFOUND THEN

Line 350: RAISE fnd_api.g_exc_error;

346:
347: OPEN get_recipe_data;
348: FETCH get_recipe_data into l_update_date;
349: IF get_recipe_data%NOTFOUND THEN
350: RAISE fnd_api.g_exc_error;
351: ELSE
352: IF p_last_update_date is NULL OR l_update_date <> p_last_update_date THEN
353: RAISE fnd_api.g_exc_error;
354: ELSE

Line 353: RAISE fnd_api.g_exc_error;

349: IF get_recipe_data%NOTFOUND THEN
350: RAISE fnd_api.g_exc_error;
351: ELSE
352: IF p_last_update_date is NULL OR l_update_date <> p_last_update_date THEN
353: RAISE fnd_api.g_exc_error;
354: ELSE
355: IF p_form_or_asynch = 'A' THEN
356: NULL;
357: /* need to lock record here */

Line 368: WHEN FND_API.G_EXC_ERROR THEN

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
369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;

Line 373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:
378: WHEN OTHERS THEN
379: X_return_code := SQLCODE;

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:
378: WHEN OTHERS THEN
379: X_return_code := SQLCODE;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
382:
383: END recipe_for_update;
384:

Line 402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

398: /* LRJackson 14Nov2000 Created */
399: /**************************************************************************** */
400: PROCEDURE recipe_description
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_recipe_description IN VARCHAR2,
406: x_return_status OUT NOCOPY VARCHAR2,

Line 403: p_commit IN VARCHAR2 := FND_API.G_FALSE,

399: /**************************************************************************** */
400: PROCEDURE recipe_description
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_recipe_description IN VARCHAR2,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,

Line 404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

400: PROCEDURE recipe_description
401: ( p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405: p_recipe_description IN VARCHAR2,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,

Line 418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

414: l_api_version CONSTANT NUMBER := 1.0;
415:
416: BEGIN
417: /* no SAVEPOINT needed because there is no insert/update/delete */
418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
419: l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: BEGIN
417: /* no SAVEPOINT needed because there is no insert/update/delete */
418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
419: l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: IF FND_API.to_Boolean(p_init_msg_list) THEN
423: FND_MSG_PUB.initialize;
424: END IF;

Line 422: IF FND_API.to_Boolean(p_init_msg_list) THEN

418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
419: l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: IF FND_API.to_Boolean(p_init_msg_list) THEN
423: FND_MSG_PUB.initialize;
424: END IF;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: END IF;
422: IF FND_API.to_Boolean(p_init_msg_list) THEN
423: FND_MSG_PUB.initialize;
424: END IF;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: IF p_recipe_description IS NULL THEN
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;

Line 428: RAISE FND_API.G_EXC_ERROR;

424: END IF;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: IF p_recipe_description IS NULL THEN
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430:
431: /* no standard check of p_commit because no insert/update/delete */
432: /* standard call to get msge cnt, and if cnt is 1, get mesg info */

Line 436: WHEN FND_API.G_EXC_ERROR THEN

432: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
433: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: X_return_code := SQLCODE;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
440:

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: X_return_code := SQLCODE;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
440:
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_return_code := SQLCODE;

Line 441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

437: X_return_code := SQLCODE;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
440:
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_return_code := SQLCODE;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
445:

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
440:
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_return_code := SQLCODE;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
445:
446: WHEN OTHERS THEN
447: X_return_code := SQLCODE;

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
445:
446: WHEN OTHERS THEN
447: X_return_code := SQLCODE;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
450:
451: END recipe_description;
452:

Line 471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

467: /* LRJackson 21Dec2000 Created */
468: /**************************************************************************** */
469: PROCEDURE recipe_orgn_code
470: ( p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
472: p_commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
474: g_orgn_id IN NUMBER,
475: g_user_id IN NUMBER,

Line 472: p_commit IN VARCHAR2 := FND_API.G_FALSE,

468: /**************************************************************************** */
469: PROCEDURE recipe_orgn_code
470: ( p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
472: p_commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
474: g_orgn_id IN NUMBER,
475: g_user_id IN NUMBER,
476: p_required_ind IN VARCHAR2 := 'N',

Line 473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

469: PROCEDURE recipe_orgn_code
470: ( p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
472: p_commit IN VARCHAR2 := FND_API.G_FALSE,
473: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
474: g_orgn_id IN NUMBER,
475: g_user_id IN NUMBER,
476: p_required_ind IN VARCHAR2 := 'N',
477: x_return_status OUT NOCOPY VARCHAR2,

Line 507: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

503: l_api_version CONSTANT NUMBER := 1.0;
504: v_temp NUMBER;
505: BEGIN
506: /* no SAVEPOINT needed because there is no insert/update/delete */
507: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
508: l_api_name, G_PKG_NAME) THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505: BEGIN
506: /* no SAVEPOINT needed because there is no insert/update/delete */
507: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
508: l_api_name, G_PKG_NAME) THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: IF FND_API.to_Boolean(p_init_msg_list) THEN
513: FND_MSG_PUB.initialize;

Line 512: IF FND_API.to_Boolean(p_init_msg_list) THEN

508: l_api_name, G_PKG_NAME) THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: IF FND_API.to_Boolean(p_init_msg_list) THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511:
512: IF FND_API.to_Boolean(p_init_msg_list) THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: IF (p_required_ind = 'Y' and g_orgn_id is NULL) THEN
518: RAISE fnd_api.g_exc_error;
519: ELSIF (p_required_ind = 'N' and g_orgn_id is not NULL) THEN

Line 518: RAISE fnd_api.g_exc_error;

514: END IF;
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: IF (p_required_ind = 'Y' and g_orgn_id is NULL) THEN
518: RAISE fnd_api.g_exc_error;
519: ELSIF (p_required_ind = 'N' and g_orgn_id is not NULL) THEN
520: /* if orgn code is null and orgn code is not required, then */
521: /* no further validation is necessary */
522: OPEN get_orgn_code;

Line 525: RAISE fnd_api.g_exc_error;

521: /* no further validation is necessary */
522: OPEN get_orgn_code;
523: FETCH get_orgn_code into x_plant_ind,x_lab_ind;
524: IF get_orgn_code%NOTFOUND THEN
525: RAISE fnd_api.g_exc_error;
526: END IF;
527: CLOSE get_orgn_code;
528:
529: OPEN get_user_orgn (l_resp_id);

Line 532: RAISE fnd_api.g_exc_error;

528:
529: OPEN get_user_orgn (l_resp_id);
530: FETCH get_user_orgn into v_temp;
531: IF get_user_orgn%NOTFOUND THEN
532: RAISE fnd_api.g_exc_error;
533: /* (need an appropriate error message here for user not assoc with orgn) */
534: ELSE
535: IF (x_plant_ind <> 1 AND x_lab_ind <> 1) THEN --Krishna conv
536: RAISE FND_API.g_exc_error;

Line 536: RAISE FND_API.g_exc_error;

532: RAISE fnd_api.g_exc_error;
533: /* (need an appropriate error message here for user not assoc with orgn) */
534: ELSE
535: IF (x_plant_ind <> 1 AND x_lab_ind <> 1) THEN --Krishna conv
536: RAISE FND_API.g_exc_error;
537: /* (need an appropriate error message here for not a plant or lab) */
538:
539: END IF; /* end if plant ind is plant or lab */
540: END IF; /* end if user associated with this orgn */

Line 550: WHEN FND_API.G_EXC_ERROR THEN

546: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
547: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: X_return_code := SQLCODE;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
554:

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: X_return_code := SQLCODE;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: X_return_code := SQLCODE;

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

551: X_return_code := SQLCODE;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: X_return_code := SQLCODE;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
559:

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: X_return_code := SQLCODE;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
559:
560: WHEN OTHERS THEN
561: X_return_code := SQLCODE;

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
559:
560: WHEN OTHERS THEN
561: X_return_code := SQLCODE;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
564:
565: END recipe_orgn_code;
566:

Line 583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

579: /* LRJackson 14Nov2000 Created */
580: /**************************************************************************** */
581: PROCEDURE process_loss_for_update
582: ( p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
584: p_commit IN VARCHAR2 := FND_API.G_FALSE,
585: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
586: p_recipe_id IN NUMBER,
587: p_orgn_id IN NUMBER,

Line 584: p_commit IN VARCHAR2 := FND_API.G_FALSE,

580: /**************************************************************************** */
581: PROCEDURE process_loss_for_update
582: ( p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
584: p_commit IN VARCHAR2 := FND_API.G_FALSE,
585: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
586: p_recipe_id IN NUMBER,
587: p_orgn_id IN NUMBER,
588: p_last_update_date IN DATE,

Line 585: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

581: PROCEDURE process_loss_for_update
582: ( p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
584: p_commit IN VARCHAR2 := FND_API.G_FALSE,
585: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
586: p_recipe_id IN NUMBER,
587: p_orgn_id IN NUMBER,
588: p_last_update_date IN DATE,
589: p_form_or_asynch IN VARCHAR2 := 'A',

Line 608: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

604: l_update_date DATE;
605:
606: BEGIN
607: /* no SAVEPOINT needed because there is no insert/update/delete */
608: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
609: l_api_name, G_PKG_NAME) THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: BEGIN
607: /* no SAVEPOINT needed because there is no insert/update/delete */
608: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
609: l_api_name, G_PKG_NAME) THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: IF FND_API.to_Boolean(p_init_msg_list) THEN
613: FND_MSG_PUB.initialize;
614: END IF;

Line 612: IF FND_API.to_Boolean(p_init_msg_list) THEN

608: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
609: l_api_name, G_PKG_NAME) THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: IF FND_API.to_Boolean(p_init_msg_list) THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:

Line 615: x_return_status := FND_API.G_RET_STS_SUCCESS;

611: END IF;
612: IF FND_API.to_Boolean(p_init_msg_list) THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: OPEN check_recipe_id;
618: FETCH check_recipe_id into l_update_date;
619: IF check_recipe_id%NOTFOUND THEN

Line 620: RAISE fnd_api.g_exc_error;

616:
617: OPEN check_recipe_id;
618: FETCH check_recipe_id into l_update_date;
619: IF check_recipe_id%NOTFOUND THEN
620: RAISE fnd_api.g_exc_error;
621: ELSE
622: IF p_last_update_date is NULL OR l_update_date <> p_last_update_date THEN
623: RAISE fnd_api.g_exc_error;
624: ELSE

Line 623: RAISE fnd_api.g_exc_error;

619: IF check_recipe_id%NOTFOUND THEN
620: RAISE fnd_api.g_exc_error;
621: ELSE
622: IF p_last_update_date is NULL OR l_update_date <> p_last_update_date THEN
623: RAISE fnd_api.g_exc_error;
624: ELSE
625: IF p_form_or_asynch = 'A' THEN
626: NULL;
627: /* need to lock record here */

Line 639: WHEN FND_API.G_EXC_ERROR THEN

635: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
636: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
637:
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: X_return_code := SQLCODE;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
643:

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637:
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: X_return_code := SQLCODE;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: X_return_code := SQLCODE;

Line 644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

640: X_return_code := SQLCODE;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: X_return_code := SQLCODE;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
648:

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: X_return_code := SQLCODE;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
648:
649: WHEN OTHERS THEN
650: X_return_code := SQLCODE;

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
648:
649: WHEN OTHERS THEN
650: X_return_code := SQLCODE;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
653:
654: END process_loss_for_update;
655:

Line 668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

664: /**************************************************************************** */
665:
666: PROCEDURE recipe_cust_exists
667: ( p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
671: p_recipe_id IN NUMBER,
672: p_customer_id IN NUMBER,

Line 669: p_commit IN VARCHAR2 := FND_API.G_FALSE,

665:
666: PROCEDURE recipe_cust_exists
667: ( p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
671: p_recipe_id IN NUMBER,
672: p_customer_id IN NUMBER,
673: x_return_status OUT NOCOPY VARCHAR2,

Line 670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

666: PROCEDURE recipe_cust_exists
667: ( p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
671: p_recipe_id IN NUMBER,
672: p_customer_id IN NUMBER,
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,

Line 691: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

687: l_recipe_id gmd_recipes.recipe_id%TYPE;
688:
689: BEGIN
690: /* no SAVEPOINT needed because there is no insert/update/delete */
691: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
692: l_api_name, G_PKG_NAME) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689: BEGIN
690: /* no SAVEPOINT needed because there is no insert/update/delete */
691: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
692: l_api_name, G_PKG_NAME) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: IF FND_API.to_Boolean(p_init_msg_list) THEN
696: FND_MSG_PUB.initialize;
697: END IF;

Line 695: IF FND_API.to_Boolean(p_init_msg_list) THEN

691: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
692: l_api_name, G_PKG_NAME) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: IF FND_API.to_Boolean(p_init_msg_list) THEN
696: FND_MSG_PUB.initialize;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: END IF;
695: IF FND_API.to_Boolean(p_init_msg_list) THEN
696: FND_MSG_PUB.initialize;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: OPEN get_record;
701: FETCH get_record into l_recipe_id;
702:

Line 704: RAISE fnd_api.g_exc_error;

700: OPEN get_record;
701: FETCH get_record into l_recipe_id;
702:
703: IF get_record%NOTFOUND THEN
704: RAISE fnd_api.g_exc_error;
705: END IF; /* end if record not found */
706:
707: CLOSE get_record;
708:

Line 715: WHEN FND_API.G_EXC_ERROR THEN

711: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
712: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: X_return_code := SQLCODE;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
719:

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: X_return_code := SQLCODE;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: X_return_code := SQLCODE;

Line 720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

716: X_return_code := SQLCODE;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: X_return_code := SQLCODE;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
724:

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: X_return_code := SQLCODE;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
724:
725: WHEN OTHERS THEN
726: X_return_code := SQLCODE;

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

723: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
724:
725: WHEN OTHERS THEN
726: X_return_code := SQLCODE;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
729:
730: END recipe_cust_exists;
731:

Line 805: x_return_status := FND_API.g_ret_sts_unexp_error;

801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
805: x_return_status := FND_API.g_ret_sts_unexp_error;
806: END validate_start_date;
807:
808: /*#####################################################
809: # NAME

Line 844: x_return_status := FND_API.g_ret_sts_unexp_error;

840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
844: x_return_status := FND_API.g_ret_sts_unexp_error;
845: END validate_end_date;
846:
847:
848: /*#####################################################

Line 874: x_return_status := FND_API.g_ret_sts_unexp_error;

870: END IF;
871: EXCEPTION
872: WHEN OTHERS THEN
873: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
874: x_return_status := FND_API.g_ret_sts_unexp_error;
875: END effective_dates;
876:
877: /*###################################################################
878: # NAME

Line 913: x_return_status := FND_API.g_ret_sts_unexp_error;

909: END IF; -- end if std qty is not null
910: EXCEPTION
911: WHEN OTHERS THEN
912: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
913: x_return_status := FND_API.g_ret_sts_unexp_error;
914: END std_qty;
915:
916: /*#####################################################
917: # NAME

Line 949: x_return_status := FND_API.g_ret_sts_unexp_error;

945: END IF; -- IF P_max_qty IS NOT NULL
946: EXCEPTION
947: WHEN OTHERS THEN
948: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
949: x_return_status := FND_API.g_ret_sts_unexp_error;
950: END max_qty;
951:
952:
953: /*#####################################################

Line 1007: x_return_status := FND_API.g_ret_sts_unexp_error;

1003: X_inv_max_qty := ROUND(X_inv_max_qty,5);
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1007: x_return_status := FND_API.g_ret_sts_unexp_error;
1008: END calc_inv_qtys;
1009:
1010: /*#####################################################
1011: # NAME

Line 1074: x_return_status := FND_API.g_ret_sts_unexp_error;

1070: END IF;
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1074: x_return_status := FND_API.g_ret_sts_unexp_error;
1075: END calculate_process_loss;
1076:
1077: /*#####################################################
1078: # NAME

Line 1135: x_return_status := FND_API.g_ret_sts_unexp_error;

1131: END LOOP;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1135: x_return_status := FND_API.g_ret_sts_unexp_error;
1136: END check_for_duplicate;
1137:
1138:
1139: END; /* Package Body GMD_RECIPE_VAL */