DBA Data[Home] [Help]

APPS.GMD_FORMULA_HEADER_PVT dependencies on FND_API

Line 56: IF NOT FND_API.Compatible_API_Call ( l_api_version

52: /* Define Savepoint */
53: SAVEPOINT Insert_FormulaHeader_PVT;
54:
55: /* Standard Check for API compatibility */
56: IF NOT FND_API.Compatible_API_Call ( l_api_version
57: ,p_api_version
58: ,l_api_name
59: ,G_PKG_NAME )
60: THEN

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: ,p_api_version
58: ,l_api_name
59: ,G_PKG_NAME )
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: /* Initialize message list if p_init_msg_list is set to TRUE */
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 65: IF FND_API.to_Boolean( p_init_msg_list ) THEN

61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: /* Initialize message list if p_init_msg_list is set to TRUE */
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: /* Initialize API return status to success */

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: /* Initialize API return status to success */
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: /* Insert calls the mls package */
73: /* New changes to include MLS */
74: /* This package inserts into the and table. */

Line 157: IF FND_API.To_Boolean( p_commit ) THEN

153: ||formula_rowid);
154: END IF;
155:
156: /* Check if p_commit is set to TRUE */
157: IF FND_API.To_Boolean( p_commit ) THEN
158: Commit;
159: END IF;
160:
161: /* Get the message count and information */

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164: p_data => x_msg_data );
165:
166:
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK to Insert_FormulaHeader_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MSG_PUB.Count_And_Get (
172: p_count => x_msg_count,

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166:
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK to Insert_FormulaHeader_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MSG_PUB.Count_And_Get (
172: p_count => x_msg_count,
173: p_data => x_msg_data );
174:

Line 175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

171: FND_MSG_PUB.Count_And_Get (
172: p_count => x_msg_count,
173: p_data => x_msg_data );
174:
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK to Insert_FormulaHeader_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get (
179: p_count => x_msg_count,

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: p_data => x_msg_data );
174:
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK to Insert_FormulaHeader_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get (
179: p_count => x_msg_count,
180: p_data => x_msg_data );
181:

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181:
182: WHEN OTHERS THEN
183: ROLLBACK to Insert_FormulaHeader_PVT;
184: fnd_msg_pub.add_exc_msg ('GMD_FORMULA_HEADER_PVT', 'Insert_Formula_Header');
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: FND_MSG_PUB.Count_And_Get (
187: p_count => x_msg_count,
188: p_data => x_msg_data );
189: IF (l_debug = 'Y') THEN

Line 233: IF NOT FND_API.Compatible_API_Call( l_api_version

229: /* Define Savepoint */
230: SAVEPOINT Update_FormulaHeader_PVT;
231:
232: /* Standard Check for API compatibility */
233: IF NOT FND_API.Compatible_API_Call( l_api_version
234: ,p_api_version
235: ,l_api_name
236: ,G_PKG_NAME )
237: THEN

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

234: ,p_api_version
235: ,l_api_name
236: ,G_PKG_NAME )
237: THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: END IF;
240:
241: /* Initialize message list if p_init_msg_list is set to TRUE */
242: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 242: IF FND_API.to_Boolean( p_init_msg_list ) THEN

238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: END IF;
240:
241: /* Initialize message list if p_init_msg_list is set to TRUE */
242: IF FND_API.to_Boolean( p_init_msg_list ) THEN
243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: /* Initialize API return status to success */

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: /* Initialize API return status to success */
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: /* Call the Update_row procedure for mls */
250: /* To modify to call the approp variables */
251: IF (l_debug = 'Y') THEN

Line 319: IF FND_API.To_Boolean( p_commit ) THEN

315: gmd_debug.put_line(' In Formula Header Pvt - After updating fm_form_mst table ');
316: END IF;
317:
318: /* Check if p_commit is set to TRUE */
319: IF FND_API.To_Boolean( p_commit ) THEN
320: Commit;
321: END IF;
322:
323: /* Get the message count and information */

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325: p_count => x_msg_count,
326: p_data => x_msg_data );
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: ROLLBACK to Update_FormulaHeader_PVT;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get (
333: p_count => x_msg_count,

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: ROLLBACK to Update_FormulaHeader_PVT;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get (
333: p_count => x_msg_count,
334: p_data => x_msg_data );
335: IF (l_debug = 'Y') THEN

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: gmd_debug.put_line(' In Formula Header Pvt - In Error Exception Section '
337: ||' - '
338: ||x_return_status);
339: END IF;
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK to Update_FormulaHeader_PVT;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get (
344: p_count => x_msg_count,

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

338: ||x_return_status);
339: END IF;
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK to Update_FormulaHeader_PVT;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get (
344: p_count => x_msg_count,
345: p_data => x_msg_data );
346: IF (l_debug = 'Y') THEN

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351:
352: WHEN OTHERS THEN
353: ROLLBACK to Update_FormulaHeader_PVT;
354: fnd_msg_pub.add_exc_msg ('GMD_FORMULA_HEADER_PVT', 'Update_Formula_Header');
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: FND_MSG_PUB.Count_And_Get (
357: p_count => x_msg_count,
358: p_data => x_msg_data );
359: IF (l_debug = 'Y') THEN