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 447: IF FND_API.To_Boolean( p_commit ) THEN

443: WHERE formula_id = p_formula_detail_rec.formula_id;
444:
445:
446: /* Check if p_commit is set to TRUE */
447: IF FND_API.To_Boolean( p_commit ) THEN
448: Commit;
449: END IF;
450:
451: /* Get the message count and information */

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: p_data => x_msg_data );
455:
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: ROLLBACK to Update_FormulaDetail_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.Count_And_Get (
462: p_count => x_msg_count,

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: ROLLBACK to Update_FormulaDetail_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.Count_And_Get (
462: p_count => x_msg_count,
463: p_data => x_msg_data );
464:

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: FND_MSG_PUB.Count_And_Get (
462: p_count => x_msg_count,
463: p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK to Update_FormulaDetail_PVT;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_And_Get (
469: p_count => x_msg_count,

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK to Update_FormulaDetail_PVT;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_And_Get (
469: p_count => x_msg_count,
470: p_data => x_msg_data );
471:

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471:
472: WHEN OTHERS THEN
473: ROLLBACK to Update_FormulaDetail_PVT;
474: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF (l_debug = 'Y') THEN
477: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
478: ||' - '
479: ||x_return_status);

Line 519: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

515: /* Define Savepoint */
516: SAVEPOINT Delete_FormulaDetail_PVT;
517:
518: /* Standard Check for API compatibility */
519: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
520: p_api_version ,
521: l_api_name ,
522: G_PKG_NAME )
523: THEN

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: p_api_version ,
521: l_api_name ,
522: G_PKG_NAME )
523: THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: /* Initialize message list if p_init_msg_list is set to TRUE */
528: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 528: IF FND_API.to_Boolean( p_init_msg_list ) THEN

524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: /* Initialize message list if p_init_msg_list is set to TRUE */
528: IF FND_API.to_Boolean( p_init_msg_list ) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531: /* Initialize API return status to success */
532: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 532: x_return_status := FND_API.G_RET_STS_SUCCESS;

528: IF FND_API.to_Boolean( p_init_msg_list ) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531: /* Initialize API return status to success */
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533:
534: /* API body */
535: /* Later on to be changed to update a business view */
536: /* and not a table. */

Line 543: RAISE FND_API.G_EXC_ERROR;

539: WHERE
540: formulaline_id = p_formula_detail_rec.formulaline_id;
541:
542: IF(SQL%ROWCOUNT = 0) THEN
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545:
546: /* End API body */
547:

Line 566: IF FND_API.To_Boolean( p_commit ) THEN

562: yield_uom = l_uom
563: where formula_id = p_formula_detail_rec.formula_id;
564:
565: /* Check if p_commit is set to TRUE */
566: IF FND_API.To_Boolean( p_commit ) THEN
567: Commit;
568: END IF;
569:
570: /* Get the message count and information */

Line 577: WHEN FND_API.G_EXC_ERROR THEN

573: p_data => x_msg_data );
574:
575:
576: EXCEPTION
577: WHEN FND_API.G_EXC_ERROR THEN
578: ROLLBACK to Delete_FormulaDetail_PVT;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: FND_MSG_PUB.Count_And_Get (
581: p_count => x_msg_count,

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575:
576: EXCEPTION
577: WHEN FND_API.G_EXC_ERROR THEN
578: ROLLBACK to Delete_FormulaDetail_PVT;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: FND_MSG_PUB.Count_And_Get (
581: p_count => x_msg_count,
582: p_data => x_msg_data );
583:

Line 584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

580: FND_MSG_PUB.Count_And_Get (
581: p_count => x_msg_count,
582: p_data => x_msg_data );
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: ROLLBACK to Delete_FormulaDetail_PVT;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MSG_PUB.Count_And_Get (
588: p_count => x_msg_count,

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: p_data => x_msg_data );
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: ROLLBACK to Delete_FormulaDetail_PVT;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MSG_PUB.Count_And_Get (
588: p_count => x_msg_count,
589: p_data => x_msg_data );
590:

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

590:
591: WHEN OTHERS THEN
592: ROLLBACK to Delete_FormulaDetail_PVT;
593: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595:
596: END Delete_FormulaDetail;
597:
598: END GMD_FORMULA_DETAIL_PVT;