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.WIP_SCHED_RELATION_GRP dependencies on FND_API

Line 59: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)
61: IS
62:
63: l_api_name CONSTANT VARCHAR2(30) := 'WIP_SCHED_RELATION_GRP';

Line 60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)

56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)
61: IS
62:
63: l_api_name CONSTANT VARCHAR2(30) := 'WIP_SCHED_RELATION_GRP';
64: l_api_version CONSTANT NUMBER := 1.0;

Line 116: IF NOT FND_API.Compatible_API_Call (l_api_version,

112:
113: /* Standard begin of API savepoint */
114: SAVEPOINT sp_wip_wol_grp;
115: /* Standard call to check for call compatibility. */
116: IF NOT FND_API.Compatible_API_Call (l_api_version,
117: P_API_VERSION,
118: l_api_name,
119: G_PKG_NAME)
120:

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: l_api_name,
119: G_PKG_NAME)
120:
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: /* Check p_init_msg_list */
126: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 126: IF FND_API.to_Boolean( p_init_msg_list ) THEN

122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: /* Check p_init_msg_list */
126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129: /* Initialize API return status to success */
130: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129: /* Initialize API return status to success */
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132:
133: /* Object type can be WO only */
134: IF p_parentObjectTypeID <> WIP_CONSTANTS.G_Obj_TYPE_WO

Line 395: IF FND_API.To_Boolean( p_commit ) THEN

391:
392: /* Standard check of p_commit */
393:
394: /* Commit work if p_commit flag true */
395: IF FND_API.To_Boolean( p_commit ) THEN
396: COMMIT WORK;
397: END IF;
398:
399: /* Standard call to get message count AND IF count is 1, get message info. */

Line 407: WHEN FND_API.G_EXC_ERROR THEN

403: );
404:
405: Exception
406:
407: WHEN FND_API.G_EXC_ERROR THEN
408: ROLLBACK TO sp_wip_wol_GRP;
409: x_return_status := FND_API.G_RET_STS_ERROR ;
410: FND_MSG_PUB.Count_AND_Get
411: ( p_count => x_msg_count,

Line 409: x_return_status := FND_API.G_RET_STS_ERROR ;

405: Exception
406:
407: WHEN FND_API.G_EXC_ERROR THEN
408: ROLLBACK TO sp_wip_wol_GRP;
409: x_return_status := FND_API.G_RET_STS_ERROR ;
410: FND_MSG_PUB.Count_AND_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO sp_wip_wol_grp;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_AND_Get
419: ( p_count => x_msg_count,

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO sp_wip_wol_grp;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_AND_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: /* Take Appropriate Action, AND message */
424: WHEN INVALID_OBJ_TYPE_EXCEPTION
425: THEN
426: ROLLBACK to sp_wip_wol_grp;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_OBJ_TYPE');
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_AND_Get
431: ( p_count => x_msg_count,

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434:
435: WHEN INVALID_REL_TYPE_EXCEPTION
436: THEN
437: ROLLBACK to sp_wip_wol_grp;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_REL_TYPE');
440: FND_MSG_PUB.Add;
441: FND_MSG_PUB.Count_AND_Get
442: ( p_count => x_msg_count,

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445:
446: WHEN PARENT_CHILD_SAME_EXCEPTION
447: THEN
448: ROLLBACK to sp_wip_wol_grp;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_CHILD_SAME');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_AND_Get
453: ( p_count => x_msg_count,

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456:
457: WHEN BAD_REL_STATUS_EXCEPTION
458: THEN
459: ROLLBACK to sp_wip_wol_grp;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_BAD_REL_STATUS');
462: FND_MSG_PUB.Add;
463: FND_MSG_PUB.Count_AND_Get
464: ( p_count => x_msg_count,

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

467:
468: WHEN DEP_REL_EXIST_EXCEPTION
469: THEN
470: ROLLBACK to sp_wip_wol_grp;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DEPENDENT_REL_EXIST');
473: FND_MSG_PUB.Add;
474: FND_MSG_PUB.Count_AND_Get
475: ( p_count => x_msg_count,

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478:
479: WHEN CONST_REL_EXIST_EXCEPTION
480: THEN
481: ROLLBACK to sp_wip_wol_grp;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CONSTRAINED_REL_EXIST');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_AND_Get
486: ( p_count => x_msg_count,

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489:
490: WHEN DUPLICATE_PARENT_EXCEPTION
491: THEN
492: ROLLBACK to sp_wip_wol_grp;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_EXIST');
495: FND_MSG_PUB.Add;
496: FND_MSG_PUB.Count_AND_Get
497: ( p_count => x_msg_count,

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500:
501: WHEN LOOP_FOUND_EXCEPTION
502: THEN
503: ROLLBACK to sp_wip_wol_grp;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_LOOP_FOUND');
506: FND_MSG_PUB.Add;
507: FND_MSG_PUB.Count_AND_Get
508: ( p_count => x_msg_count,

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511:
512: WHEN INSERT_FAIL_EXCEPTION
513: THEN
514: ROLLBACK to sp_wip_wol_grp;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INSERT_FAIL');
517: FND_MSG_PUB.Add;
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

521: );
522:
523: WHEN OTHERS THEN
524: ROLLBACK TO sp_wip_wol_grp;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level
527: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
528: THEN
529: FND_MSG_PUB.Add_Exc_Msg

Line 562: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
563: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)
564: IS
565:
566: l_api_name CONSTANT VARCHAR2(30) := 'WIP_SCHED_RELATION_GRP';

Line 563: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)

559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
563: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE)
564: IS
565:
566: l_api_name CONSTANT VARCHAR2(30) := 'WIP_SCHED_RELATION_GRP';
567: l_api_version CONSTANT NUMBER := 1.0;

Line 622: IF NOT FND_API.Compatible_API_Call (l_api_version,

618:
619: /* Standard begin of API savepoint */
620: SAVEPOINT sp_wip_wol_grp;
621: /* Standard call to check for call compatibility. */
622: IF NOT FND_API.Compatible_API_Call (l_api_version,
623: P_API_VERSION,
624: l_api_name,
625: G_PKG_NAME)
626:

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: l_api_name,
625: G_PKG_NAME)
626:
627: THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: /* Check p_init_msg_list */
632: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 632: IF FND_API.to_Boolean( p_init_msg_list ) THEN

628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: /* Check p_init_msg_list */
632: IF FND_API.to_Boolean( p_init_msg_list ) THEN
633: FND_MSG_PUB.initialize;
634: END IF;
635: /* Initialize API return status to success */
636: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: IF FND_API.to_Boolean( p_init_msg_list ) THEN
633: FND_MSG_PUB.initialize;
634: END IF;
635: /* Initialize API return status to success */
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638:
639: /* Check IF One Row exists for RelationshipID */
640: BEGIN

Line 729: IF FND_API.To_Boolean( p_commit ) THEN

725:
726:
727: /* Standard check of p_commit */
728: /* Commit work IF p_commit flag true */
729: IF FND_API.To_Boolean( p_commit ) THEN
730: COMMIT WORK;
731: END IF;
732:
733: /* Standard call to get message count AND IF count is 1, get message info. */

Line 741: WHEN FND_API.G_EXC_ERROR THEN

737: );
738:
739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO sp_wip_wol_GRP;
743: x_return_status := FND_API.G_RET_STS_ERROR ;
744: FND_MSG_PUB.Count_AND_Get
745: ( p_count => x_msg_count,

Line 743: x_return_status := FND_API.G_RET_STS_ERROR ;

739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO sp_wip_wol_GRP;
743: x_return_status := FND_API.G_RET_STS_ERROR ;
744: FND_MSG_PUB.Count_AND_Get
745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO sp_wip_wol_grp;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: FND_MSG_PUB.Count_AND_Get
753: ( p_count => x_msg_count,

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

747: );
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO sp_wip_wol_grp;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: FND_MSG_PUB.Count_AND_Get
753: ( p_count => x_msg_count,
754: p_data => x_msg_data
755: );

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755: );
756:
757: WHEN DEP_REL_EXIST_EXCEPTION THEN
758: ROLLBACK to sp_wip_wol_grp;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CHILD_DEP_REL_EXIST');
761: FND_MSG_PUB.Add;
762: FND_MSG_PUB.Count_AND_Get
763: ( p_count => x_msg_count,

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: );
766:
767: WHEN NO_SUCH_RELID_EXCEPTION THEN
768: ROLLBACK to sp_wip_wol_grp;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_NO_SUCH_REL_ID');
771: FND_MSG_PUB.Add;
772: FND_MSG_PUB.Count_AND_Get
773: ( p_count => x_msg_count,

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776:
777: WHEN DELETE_FAIL_EXCEPTION
778: THEN
779: ROLLBACK to sp_wip_wol_grp;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DELETE_FAIL');
782: FND_MSG_PUB.Add;
783: FND_MSG_PUB.Count_AND_Get
784: ( p_count => x_msg_count,

Line 790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

786: );
787:
788: WHEN OTHERS THEN
789: ROLLBACK TO sp_wip_wol_grp;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg