DBA Data[Home] [Help]

APPS.GMD_FORMULA_HEADER_PVT dependencies on FND_API

Line 85: IF NOT FND_API.Compatible_API_Call ( l_api_version

81: /* Define Savepoint */
82: SAVEPOINT Insert_FormulaHeader_PVT;
83:
84: /* Standard Check for API compatibility */
85: IF NOT FND_API.Compatible_API_Call ( l_api_version
86: ,p_api_version
87: ,l_api_name
88: ,G_PKG_NAME )
89: THEN

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: ,p_api_version
87: ,l_api_name
88: ,G_PKG_NAME )
89: THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: /* Initialize message list if p_init_msg_list is set to TRUE */
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 94: IF FND_API.to_Boolean( p_init_msg_list ) THEN

90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: /* Initialize message list if p_init_msg_list is set to TRUE */
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: /* Initialize API return status to success */

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: /* Initialize API return status to success */
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: /* Insert calls the mls package */
102: /* New changes to include MLS */
103: /* This package inserts into the and table. */

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201: WHEN others then
202: ROLLBACK to Insert_FormulaHeader_PVT;
203: fnd_msg_pub.add_exc_msg('GMD_FORMULA_HEADER_PVT',
204: 'Insert_Formula_Header');
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
207: IF (l_debug = 'Y') THEN
208: gmd_debug.put_line(' In Formula Header Pvt - Formula Security OTHERS Exception ' ||
209: ' - ' || x_return_status);

Line 291: IF FND_API.To_Boolean( p_commit ) THEN

287: ||formula_rowid);
288: END IF;
289:
290: /* Check if p_commit is set to TRUE */
291: IF FND_API.To_Boolean( p_commit ) THEN
292: Commit;
293: END IF;
294:
295: /* Get the message count and information */

Line 302: WHEN FND_API.G_EXC_ERROR THEN

298: p_data => x_msg_data );
299:
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK to Insert_FormulaHeader_PVT;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: FND_MSG_PUB.Count_And_Get (
306: p_count => x_msg_count,

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK to Insert_FormulaHeader_PVT;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: FND_MSG_PUB.Count_And_Get (
306: p_count => x_msg_count,
307: p_data => x_msg_data );
308:

Line 309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

305: FND_MSG_PUB.Count_And_Get (
306: p_count => x_msg_count,
307: p_data => x_msg_data );
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK to Insert_FormulaHeader_PVT;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get (
313: p_count => x_msg_count,

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: p_data => x_msg_data );
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK to Insert_FormulaHeader_PVT;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get (
313: p_count => x_msg_count,
314: p_data => x_msg_data );
315:

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315:
316: WHEN OTHERS THEN
317: ROLLBACK to Insert_FormulaHeader_PVT;
318: fnd_msg_pub.add_exc_msg ('GMD_FORMULA_HEADER_PVT', 'Insert_Formula_Header');
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: FND_MSG_PUB.Count_And_Get (
321: p_count => x_msg_count,
322: p_data => x_msg_data );
323: IF (l_debug = 'Y') THEN

Line 367: IF NOT FND_API.Compatible_API_Call( l_api_version

363: /* Define Savepoint */
364: SAVEPOINT Update_FormulaHeader_PVT;
365:
366: /* Standard Check for API compatibility */
367: IF NOT FND_API.Compatible_API_Call( l_api_version
368: ,p_api_version
369: ,l_api_name
370: ,G_PKG_NAME )
371: THEN

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: ,p_api_version
369: ,l_api_name
370: ,G_PKG_NAME )
371: THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: /* Initialize message list if p_init_msg_list is set to TRUE */
376: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 376: IF FND_API.to_Boolean( p_init_msg_list ) THEN

372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: /* Initialize message list if p_init_msg_list is set to TRUE */
376: IF FND_API.to_Boolean( p_init_msg_list ) THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379:
380: /* Initialize API return status to success */

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: FND_MSG_PUB.initialize;
378: END IF;
379:
380: /* Initialize API return status to success */
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: /* Call the Update_row procedure for mls */
384: /* To modify to call the approp variables */
385: IF (l_debug = 'Y') THEN

Line 453: IF FND_API.To_Boolean( p_commit ) THEN

449: gmd_debug.put_line(' In Formula Header Pvt - After updating fm_form_mst table ');
450: END IF;
451:
452: /* Check if p_commit is set to TRUE */
453: IF FND_API.To_Boolean( p_commit ) THEN
454: Commit;
455: END IF;
456:
457: /* Get the message count and information */

Line 463: WHEN FND_API.G_EXC_ERROR THEN

459: p_count => x_msg_count,
460: p_data => x_msg_data );
461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK to Update_FormulaHeader_PVT;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.Count_And_Get (
467: p_count => x_msg_count,

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK to Update_FormulaHeader_PVT;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.Count_And_Get (
467: p_count => x_msg_count,
468: p_data => x_msg_data );
469: IF (l_debug = 'Y') THEN

Line 474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

470: gmd_debug.put_line(' In Formula Header Pvt - In Error Exception Section '
471: ||' - '
472: ||x_return_status);
473: END IF;
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
475: ROLLBACK to Update_FormulaHeader_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: FND_MSG_PUB.Count_And_Get (
478: p_count => x_msg_count,

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: ||x_return_status);
473: END IF;
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
475: ROLLBACK to Update_FormulaHeader_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: FND_MSG_PUB.Count_And_Get (
478: p_count => x_msg_count,
479: p_data => x_msg_data );
480: IF (l_debug = 'Y') THEN

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485:
486: WHEN OTHERS THEN
487: ROLLBACK to Update_FormulaHeader_PVT;
488: fnd_msg_pub.add_exc_msg ('GMD_FORMULA_HEADER_PVT', 'Update_Formula_Header');
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get (
491: p_count => x_msg_count,
492: p_data => x_msg_data );
493: IF (l_debug = 'Y') THEN