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

Line 57: IF NOT FND_API.Compatible_API_Call( l_api_version

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

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: /* Initialize API return status to success */
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: /* API Body */
74: /* Later on this insert should be changed to */
75: /* make insert on business view as opposed to tables directly. */

Line 221: IF FND_API.To_Boolean(p_commit) THEN

217: yield_uom = l_uom
218: WHERE formula_id = p_formula_detail_rec.formula_id;
219:
220: /* Check if p_commit is set to TRUE */
221: IF FND_API.To_Boolean(p_commit) THEN
222: Commit;
223: END IF;
224:
225: /* Get the message count and information */

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: FND_MSG_PUB.Count_And_Get (
227: p_count => x_msg_count,
228: p_data => x_msg_data );
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK to Insert_FormulaDetail_PVT;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.Count_And_Get (
234: p_count => x_msg_count,

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228: p_data => x_msg_data );
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK to Insert_FormulaDetail_PVT;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.Count_And_Get (
234: p_count => x_msg_count,
235: p_data => x_msg_data );
236:

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: FND_MSG_PUB.Count_And_Get (
234: p_count => x_msg_count,
235: p_data => x_msg_data );
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK to Insert_FormulaDetail_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get (
241: p_count => x_msg_count,

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: p_data => x_msg_data );
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK to Insert_FormulaDetail_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get (
241: p_count => x_msg_count,
242: p_data => x_msg_data );
243:

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243:
244: WHEN OTHERS THEN
245: ROLLBACK to Insert_FormulaDetail_PVT;
246: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF (l_debug = 'Y') THEN
249: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
250: ||' - '
251: ||x_return_status);

Line 308: IF NOT FND_API.Compatible_API_Call ( l_api_version

304: /* Define Savepoint */
305: SAVEPOINT Update_FormulaDetail_PVT;
306:
307: /* Standard Check for API compatibility */
308: IF NOT FND_API.Compatible_API_Call ( l_api_version
309: ,p_api_version
310: ,l_api_name
311: ,G_PKG_NAME )
312: THEN

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: ,p_api_version
310: ,l_api_name
311: ,G_PKG_NAME )
312: THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: /* Initialize message list if p_init_msg_list is set to TRUE */
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 317: IF FND_API.to_Boolean( p_init_msg_list ) THEN

313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: /* Initialize message list if p_init_msg_list is set to TRUE */
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: /* Initialize API return status to success */
321: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: /* Initialize API return status to success */
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: IF (p_formula_detail_rec.organization_id IS NULL) THEN
324: OPEN C_get_orgid (p_formula_detail_rec.formula_id);
325: FETCH C_get_orgid INTO l_org_id;

Line 520: IF FND_API.To_Boolean( p_commit ) THEN

516: WHERE formula_id = p_formula_detail_rec.formula_id;
517:
518:
519: /* Check if p_commit is set to TRUE */
520: IF FND_API.To_Boolean( p_commit ) THEN
521: Commit;
522: END IF;
523:
524: /* Get the message count and information */

Line 531: WHEN FND_API.G_EXC_ERROR THEN

527: p_data => x_msg_data );
528:
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: ROLLBACK to Update_FormulaDetail_PVT;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: FND_MSG_PUB.Count_And_Get (
535: p_count => x_msg_count,

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: ROLLBACK to Update_FormulaDetail_PVT;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: FND_MSG_PUB.Count_And_Get (
535: p_count => x_msg_count,
536: p_data => x_msg_data );
537:

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: FND_MSG_PUB.Count_And_Get (
535: p_count => x_msg_count,
536: p_data => x_msg_data );
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK to Update_FormulaDetail_PVT;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

536: p_data => x_msg_data );
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK to Update_FormulaDetail_PVT;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_And_Get (
542: p_count => x_msg_count,
543: p_data => x_msg_data );
544:

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544:
545: WHEN OTHERS THEN
546: ROLLBACK to Update_FormulaDetail_PVT;
547: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF (l_debug = 'Y') THEN
550: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
551: ||' - '
552: ||x_return_status);

Line 592: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

588: /* Define Savepoint */
589: SAVEPOINT Delete_FormulaDetail_PVT;
590:
591: /* Standard Check for API compatibility */
592: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
593: p_api_version ,
594: l_api_name ,
595: G_PKG_NAME )
596: THEN

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: p_api_version ,
594: l_api_name ,
595: G_PKG_NAME )
596: THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599:
600: /* Initialize message list if p_init_msg_list is set to TRUE */
601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599:
600: /* Initialize message list if p_init_msg_list is set to TRUE */
601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
602: FND_MSG_PUB.initialize;
603: END IF;
604: /* Initialize API return status to success */
605: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
602: FND_MSG_PUB.initialize;
603: END IF;
604: /* Initialize API return status to success */
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: /* API body */
608: /* Later on to be changed to update a business view */
609: /* and not a table. */

Line 616: RAISE FND_API.G_EXC_ERROR;

612: WHERE
613: formulaline_id = p_formula_detail_rec.formulaline_id;
614:
615: IF(SQL%ROWCOUNT = 0) THEN
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618:
619: /* End API body */
620:

Line 639: IF FND_API.To_Boolean( p_commit ) THEN

635: yield_uom = l_uom
636: where formula_id = p_formula_detail_rec.formula_id;
637:
638: /* Check if p_commit is set to TRUE */
639: IF FND_API.To_Boolean( p_commit ) THEN
640: Commit;
641: END IF;
642:
643: /* Get the message count and information */

Line 650: WHEN FND_API.G_EXC_ERROR THEN

646: p_data => x_msg_data );
647:
648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: ROLLBACK to Delete_FormulaDetail_PVT;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get (
654: p_count => x_msg_count,

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: ROLLBACK to Delete_FormulaDetail_PVT;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get (
654: p_count => x_msg_count,
655: p_data => x_msg_data );
656:

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: FND_MSG_PUB.Count_And_Get (
654: p_count => x_msg_count,
655: p_data => x_msg_data );
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: ROLLBACK to Delete_FormulaDetail_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: FND_MSG_PUB.Count_And_Get (
661: p_count => x_msg_count,

Line 659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

655: p_data => x_msg_data );
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: ROLLBACK to Delete_FormulaDetail_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: FND_MSG_PUB.Count_And_Get (
661: p_count => x_msg_count,
662: p_data => x_msg_data );
663:

Line 667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

663:
664: WHEN OTHERS THEN
665: ROLLBACK to Delete_FormulaDetail_PVT;
666: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668:
669: END Delete_FormulaDetail;
670:
671: END GMD_FORMULA_DETAIL_PVT;