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

Line 68: to_date(to_char(nvl(p_old_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR');

64: and rlt.role_id = p_role_id --added vide bug#2474811
65: and rlt.role_resource_type = 'RS_GROUP_MEMBER'
66: and nvl(rlt.delete_flag, 'N') <> 'Y'
67: and rlt.start_date_active between p_old_start_date and
68: to_date(to_char(nvl(p_old_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR');
69: l_grp_valid BOOLEAN := TRUE;
70:
71:
72: cursor team_mem_cur

Line 87: to_date(to_char(nvl(p_old_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') ;

83: and rlt.role_id = p_role_id --added vide bug#2474811
84: and rlt.role_resource_type = 'RS_TEAM_MEMBER'
85: and nvl(rlt.delete_flag, 'N') <> 'Y'
86: and rlt.start_date_active between p_old_start_date and
87: to_date(to_char(nvl(p_old_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') ;
88: l_team_valid BOOLEAN := TRUE;
89:
90: /* removed the below parameter since it is not used anywhere */
91: -- l_end_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

Line 91: -- l_end_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

87: to_date(to_char(nvl(p_old_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') ;
88: l_team_valid BOOLEAN := TRUE;
89:
90: /* removed the below parameter since it is not used anywhere */
91: -- l_end_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
92: begin
93:
94: open rsc_cur(p_resource_id);
95: fetch rsc_cur INTO rsc_rec;

Line 99: OR (rsc_rec.end_date_active < to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))

95: fetch rsc_cur INTO rsc_rec;
96: close rsc_cur;
97: IF((rsc_rec.start_date_active > p_new_start_date)
98: -- changed by sudarsana 11 feb 2002
99: OR (rsc_rec.end_date_active < to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))
100: THEN
101: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
102: FND_MSG_PUB.add;
103: l_valid := FALSE;

Line 109: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

105:
106: for grp_mem_rec in grp_mem_cur
107: loop
108: if(grp_mem_rec.start_date_active not between p_new_start_date
109: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
110: then
111: l_grp_valid := FALSE;
112: end if;
113:

Line 114: if(to_date(to_char(nvl(grp_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') not between p_new_start_date

110: then
111: l_grp_valid := FALSE;
112: end if;
113:
114: if(to_date(to_char(nvl(grp_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') not between p_new_start_date
115: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
116: then
117: l_grp_valid := FALSE;
118: end if;

Line 115: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

111: l_grp_valid := FALSE;
112: end if;
113:
114: if(to_date(to_char(nvl(grp_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') not between p_new_start_date
115: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
116: then
117: l_grp_valid := FALSE;
118: end if;
119:

Line 131: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

127:
128: for team_mem_rec in team_mem_cur
129: loop
130: if(team_mem_rec.start_date_active not between p_new_start_date
131: and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
132: then
133: l_team_valid := FALSE;
134: end if;
135:

Line 136: if(to_date(to_char(nvl(team_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')

132: then
133: l_team_valid := FALSE;
134: end if;
135:
136: if(to_date(to_char(nvl(team_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')
137: not between p_new_start_date and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
138: then
139: l_team_valid := FALSE;
140: end if;

Line 137: not between p_new_start_date and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

133: l_team_valid := FALSE;
134: end if;
135:
136: if(to_date(to_char(nvl(team_mem_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')
137: not between p_new_start_date and to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
138: then
139: l_team_valid := FALSE;
140: end if;
141:

Line 496: x_return_status := fnd_api.g_ret_sts_success;

492: --dbms_output.put_line ('Debug Message begin 10');
493: --Standard Start of API SAVEPOINT
494: SAVEPOINT ROLE_RELATE_SP;
495:
496: x_return_status := fnd_api.g_ret_sts_success;
497:
498: --Standard Call to check API compatibility
499: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
500: THEN

Line 499: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

495:
496: x_return_status := fnd_api.g_ret_sts_success;
497:
498: --Standard Call to check API compatibility
499: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
500: THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497:
498: --Standard Call to check API compatibility
499: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
500: THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
505: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 505: IF FND_API.To_boolean(P_INIT_MSG_LIST)

501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
505: IF FND_API.To_boolean(P_INIT_MSG_LIST)
506: THEN
507: FND_MSG_PUB.Initialize;
508: END IF;
509:

Line 535: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

531: P_END_DATE_ACTIVE => p_end_date_active,
532: p_data => L_data,
533: p_count => L_count,
534: P_return_code => l_return_code);
535: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;

Line 538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

534: P_return_code => l_return_code);
535: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;

Line 539: RAISE FND_API.G_EXC_ERROR;

535: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: end if;

Line 540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: end if;
544: end if;

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: end if;
544: end if;
545: end if;

Line 562: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

558: P_END_DATE_ACTIVE => p_end_date_active,
559: p_data => L_data,
560: p_count => L_count,
561: P_return_code => l_return_code);
562: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;

Line 565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

561: P_return_code => l_return_code);
562: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;

Line 566: RAISE FND_API.G_EXC_ERROR;

562: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: end if;

Line 567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: end if;
571: end if;

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: end if;
571: end if;
572: end if;

Line 589: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

585: P_END_DATE_ACTIVE => p_end_date_active,
586: p_data => L_data,
587: p_count => L_count,
588: P_return_code => l_return_code);
589: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;

Line 592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

588: P_return_code => l_return_code);
589: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;

Line 593: RAISE FND_API.G_EXC_ERROR;

589: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597: end if;

Line 594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597: end if;
598: end if;

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597: end if;
598: end if;
599: end if;

Line 611: RAISE fnd_api.g_exc_error;

607: IF(l_start_date_active is NULL)
608: THEN
609: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
610: FND_MSG_PUB.add;
611: RAISE fnd_api.g_exc_error;
612: END IF;
613:
614:
615: --check start date less than end date

Line 620: RAISE fnd_api.g_exc_error;

616: IF(l_start_date_active > l_end_date_active)
617: THEN
618: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
619: FND_MSG_PUB.add;
620: RAISE fnd_api.g_exc_error;
621: END IF;
622:
623: IF(l_role_resource_type = 'RS_TEAM' or
624: l_role_resource_type = 'RS_GROUP' or

Line 635: RAISE fnd_api.g_exc_error;

631:
632: if (l_role_type_valid = false) then
633: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');
634: FND_MSG_PUB.add;
635: RAISE fnd_api.g_exc_error;
636: end if;
637: END IF;
638:
639: --dbms_output.put_line ('Debug Message 12');

Line 658: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')

654: l_date_invalid := TRUE;
655: END IF;
656:
657:
658: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')
659: between check_date_rec.start_date_active and
660: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
661: OR (l_end_date_active IS NULL AND
662: check_date_rec.end_date_active IS NULL))

Line 660: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

656:
657:
658: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')
659: between check_date_rec.start_date_active and
660: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
661: OR (l_end_date_active IS NULL AND
662: check_date_rec.end_date_active IS NULL))
663: THEN
664: l_date_invalid := TRUE;

Line 669: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') >

665: END IF;
666:
667: -- added this check as a date range outside of the existing ranges was getting entered
668: if(l_start_date_active < check_date_rec.start_date_active
669: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') >
670: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
671: THEN
672: l_date_invalid := TRUE;
673: END IF;

Line 670: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

666:
667: -- added this check as a date range outside of the existing ranges was getting entered
668: if(l_start_date_active < check_date_rec.start_date_active
669: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') >
670: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
671: THEN
672: l_date_invalid := TRUE;
673: END IF;
674:

Line 687: RAISE fnd_api.g_exc_error;

683: IF(l_date_invalid)
684: THEN
685: fnd_message.set_name ('JTF', 'JTF_RS_OVERLAP_DATE_ERR');
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
688: END IF;
689: --end of overlapping date range check
690:
691:

Line 712: RAISE fnd_api.g_exc_error;

708: THEN
709: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
710: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
711: fnd_msg_pub.add;
712: RAISE fnd_api.g_exc_error;
713: END IF;
714: CLOSE grp_mem_cur;
715:
716: END IF;

Line 740: RAISE fnd_api.g_exc_error;

736: ELSE
737: l_role_valid := FALSE;
738: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
739: FND_MSG_PUB.add;
740: RAISE fnd_api.g_exc_error;
741: END IF;
742: close res_role_cur;
743: ELSIF((l_role_resource_type = 'RS_TEAM_MEMBER') AND
744: (l_team_resource_type = 'GROUP'))

Line 764: RAISE fnd_api.g_exc_error;

760: ELSE
761: l_role_valid := FALSE;
762: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_error;
765: END IF;
766: close grp_role_cur;
767: END IF;
768: -- end of valid role for the resource if being entered as a group member and team member

Line 784: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

780: open team_cur(l_role_resource_id);
781: fetch team_cur INTO team_rec;
782: close team_cur;
783: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
784: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
785: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
786: THEN
787: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
788: FND_MSG_PUB.add;

Line 785: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

781: fetch team_cur INTO team_rec;
782: close team_cur;
783: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
784: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
785: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
786: THEN
787: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
788: FND_MSG_PUB.add;
789: RAISE fnd_api.g_exc_error;

Line 789: RAISE fnd_api.g_exc_error;

785: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
786: THEN
787: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
788: FND_MSG_PUB.add;
789: RAISE fnd_api.g_exc_error;
790: END IF;
791:
792: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
793: THEN

Line 796: RAISE fnd_api.g_exc_error;

792: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
793: THEN
794: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
795: FND_MSG_PUB.add;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799: --dbms_output.put_line ('Debug Message 17');
800:

Line 810: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

806: fetch group_cur INTO group_rec;
807: close group_cur;
808:
809: --IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
810: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
811: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
812: THEN
813: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
814: FND_MSG_PUB.add;

Line 811: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))

807: close group_cur;
808:
809: --IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
810: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
811: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
812: THEN
813: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
814: FND_MSG_PUB.add;
815: RAISE fnd_api.g_exc_error;

Line 815: RAISE fnd_api.g_exc_error;

811: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
812: THEN
813: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
814: FND_MSG_PUB.add;
815: RAISE fnd_api.g_exc_error;
816: END IF;
817:
818:
819: IF(group_rec.end_date_active is not null AND l_end_date_active is null)

Line 823: RAISE fnd_api.g_exc_error;

819: IF(group_rec.end_date_active is not null AND l_end_date_active is null)
820: THEN
821: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
822: FND_MSG_PUB.add;
823: RAISE fnd_api.g_exc_error;
824: END IF;
825:
826: --exclusive flag validation
827: open c_exclusive_group_check_cur(l_role_resource_id,

Line 836: RAISE fnd_api.g_exc_error;

832: IF(c_exclusive_group_check_cur%FOUND)
833: THEN
834: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
835: FND_MSG_PUB.add;
836: RAISE fnd_api.g_exc_error;
837: END IF;
838:
839: close c_exclusive_group_check_cur;
840:

Line 849: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))

845: fetch rsc_cur INTO rsc_rec;
846: close rsc_cur;
847: IF((rsc_rec.start_date_active > l_start_date_active)
848: -- changed by sudarsana 11 feb 2002
849: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))
850: THEN
851: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
852: FND_MSG_PUB.add;
853: RAISE fnd_api.g_exc_error;

Line 853: RAISE fnd_api.g_exc_error;

849: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))
850: THEN
851: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
852: FND_MSG_PUB.add;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855: ELSIF(l_role_resource_type = 'RS_GROUP')
856: --check against group start and end dates
857: THEN

Line 864: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

860: close group_dt_cur;
861: IF((group_dt_rec.start_date_active > l_start_date_active)
862: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
863: --OR (group_dt_rec.end_date_active < l_end_date_active))
864: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
865: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
866: THEN
867: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
868: FND_MSG_PUB.add;

Line 865: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))

861: IF((group_dt_rec.start_date_active > l_start_date_active)
862: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
863: --OR (group_dt_rec.end_date_active < l_end_date_active))
864: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
865: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
866: THEN
867: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
868: FND_MSG_PUB.add;
869: RAISE fnd_api.g_exc_error;

Line 869: RAISE fnd_api.g_exc_error;

865: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
866: THEN
867: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
868: FND_MSG_PUB.add;
869: RAISE fnd_api.g_exc_error;
870: END IF;
871: ELSIF(l_role_resource_type = 'RS_TEAM')
872: --check against team start and end dates
873: THEN

Line 880: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

876: close team_dt_cur;
877: IF((team_dt_rec.start_date_active > l_start_date_active)
878: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
879: --OR (team_dt_rec.end_date_active < l_end_date_active))
880: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
881: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
884: FND_MSG_PUB.add;

Line 881: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))

877: IF((team_dt_rec.start_date_active > l_start_date_active)
878: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
879: --OR (team_dt_rec.end_date_active < l_end_date_active))
880: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
881: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
884: FND_MSG_PUB.add;
885: RAISE fnd_api.g_exc_error;

Line 885: RAISE fnd_api.g_exc_error;

881: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
884: FND_MSG_PUB.add;
885: RAISE fnd_api.g_exc_error;
886: END IF;
887: END IF;
888:
889: --dbms_output.put_line ('Debug Message 19');

Line 913: IF(l_return_status <> fnd_api.g_ret_sts_success)

909: X_RETURN_STATUS => l_return_status,
910: X_MSG_COUNT => l_msg_count,
911: X_MSG_DATA => l_msg_data );
912:
913: IF(l_return_status <> fnd_api.g_ret_sts_success)
914: THEN
915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

911: X_MSG_DATA => l_msg_data );
912:
913: IF(l_return_status <> fnd_api.g_ret_sts_success)
914: THEN
915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;

Line 916: RAISE FND_API.G_EXC_ERROR;

912:
913: IF(l_return_status <> fnd_api.g_ret_sts_success)
914: THEN
915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;

Line 917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

913: IF(l_return_status <> fnd_api.g_ret_sts_success)
914: THEN
915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;
921:

Line 918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

914: THEN
915: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;
921:
922: --dbms_output.put_line ('Debug Message 20');

Line 1024: RAISE fnd_api.g_exc_unexpected_error;

1020: fnd_message.set_token('P_SQLCODE',SQLCODE);
1021: fnd_message.set_token('P_SQLERRM',SQLERRM);
1022: fnd_message.set_token('P_API_NAME', l_api_name);
1023: FND_MSG_PUB.add;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025:
1026:
1027: end;
1028:

Line 1051: RAISE fnd_api.g_exc_unexpected_error;

1047: fnd_message.set_token('P_SQLCODE',SQLCODE);
1048: fnd_message.set_token('P_SQLERRM',SQLERRM);
1049: fnd_message.set_token('P_API_NAME', l_api_name);
1050: FND_MSG_PUB.add;
1051: RAISE fnd_api.g_exc_unexpected_error;
1052: end;
1053:
1054: else
1055: --call to insert records in jtf_rs_rep_managers

Line 1065: IF(l_return_status <> fnd_api.g_ret_sts_success)

1061: X_RETURN_STATUS => l_return_status,
1062: X_MSG_COUNT => l_msg_count,
1063: X_MSG_DATA => l_msg_data);
1064:
1065: IF(l_return_status <> fnd_api.g_ret_sts_success)
1066: THEN
1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1063: X_MSG_DATA => l_msg_data);
1064:
1065: IF(l_return_status <> fnd_api.g_ret_sts_success)
1066: THEN
1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;

Line 1068: RAISE FND_API.G_EXC_ERROR;

1064:
1065: IF(l_return_status <> fnd_api.g_ret_sts_success)
1066: THEN
1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072: END IF;

Line 1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1065: IF(l_return_status <> fnd_api.g_ret_sts_success)
1066: THEN
1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072: END IF;
1073: END IF; -- end of count check

Line 1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1066: THEN
1067: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072: END IF;
1073: END IF; -- end of count check
1074: END IF;

Line 1090: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1086: P_END_DATE_ACTIVE => p_end_date_active,
1087: p_data => L_data,
1088: p_count => L_count,
1089: P_return_code => l_return_code);
1090: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;

Line 1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1089: P_return_code => l_return_code);
1090: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;

Line 1094: RAISE FND_API.G_EXC_ERROR;

1090: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: end if;

Line 1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: end if;
1099: end if;

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: end if;
1099: end if;
1100:

Line 1119: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1115: P_END_DATE_ACTIVE => p_end_date_active,
1116: p_data => L_data,
1117: p_count => L_count,
1118: P_return_code => l_return_code);
1119: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;

Line 1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1118: P_return_code => l_return_code);
1119: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end if;

Line 1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end if;
1128: end if;

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end if;
1128: end if;
1129: end if;

Line 1146: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1142: P_END_DATE_ACTIVE => p_end_date_active,
1143: p_data => L_data,
1144: p_count => L_count,
1145: P_return_code => l_return_code);
1146: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;

Line 1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1145: P_return_code => l_return_code);
1146: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: end if;

Line 1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: end if;
1155: end if;

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: end if;
1155: end if;
1156: end if;

Line 1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1198: p_bind_data_id => l_bind_data_id,
1199: x_return_code => x_return_status);
1200:
1201:
1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1199: x_return_code => x_return_status);
1200:
1201:
1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;

Line 1204: RAISE FND_API.G_EXC_ERROR;

1200:
1201:
1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208:

Line 1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1201:
1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208:
1209: END IF;

Line 1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1203: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1204: RAISE FND_API.G_EXC_ERROR;
1205: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208:
1209: END IF;
1210:

Line 1217: IF fnd_api.to_boolean (p_commit)

1213: END IF;
1214: END IF;
1215:
1216: --standard commit
1217: IF fnd_api.to_boolean (p_commit)
1218: THEN
1219: COMMIT WORK;
1220: END IF;
1221:

Line 1231: ,p_init_msg_list => fnd_api.g_false

1227:
1228: begin
1229: jtf_rs_wf_events_pub.create_resource_role_relate
1230: (p_api_version => 1.0
1231: ,p_init_msg_list => fnd_api.g_false
1232: ,p_commit => fnd_api.g_false
1233: ,p_role_relate_id => l_role_relate_id
1234: ,p_role_resource_type => l_role_resource_type
1235: ,p_role_resource_id => l_role_resource_id

Line 1232: ,p_commit => fnd_api.g_false

1228: begin
1229: jtf_rs_wf_events_pub.create_resource_role_relate
1230: (p_api_version => 1.0
1231: ,p_init_msg_list => fnd_api.g_false
1232: ,p_commit => fnd_api.g_false
1233: ,p_role_relate_id => l_role_relate_id
1234: ,p_role_resource_type => l_role_resource_type
1235: ,p_role_resource_id => l_role_resource_id
1236: ,p_role_id => l_role_id

Line 1250: WHEN fnd_api.g_exc_error THEN

1246:
1247: /* End of publish API call */
1248:
1249: EXCEPTION
1250: WHEN fnd_api.g_exc_error THEN
1251: ROLLBACK TO ROLE_RELATE_SP;
1252: x_return_status := fnd_api.g_ret_sts_error;
1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1254: p_data => x_msg_data);

Line 1252: x_return_status := fnd_api.g_ret_sts_error;

1248:
1249: EXCEPTION
1250: WHEN fnd_api.g_exc_error THEN
1251: ROLLBACK TO ROLE_RELATE_SP;
1252: x_return_status := fnd_api.g_ret_sts_error;
1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1254: p_data => x_msg_data);
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: ROLLBACK TO ROLE_RELATE_SP;

Line 1255: WHEN fnd_api.g_exc_unexpected_error THEN

1251: ROLLBACK TO ROLE_RELATE_SP;
1252: x_return_status := fnd_api.g_ret_sts_error;
1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1254: p_data => x_msg_data);
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: ROLLBACK TO ROLE_RELATE_SP;
1257: x_return_status := fnd_api.g_ret_sts_unexp_error;
1258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1259: p_data => x_msg_data);

Line 1257: x_return_status := fnd_api.g_ret_sts_unexp_error;

1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1254: p_data => x_msg_data);
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: ROLLBACK TO ROLE_RELATE_SP;
1257: x_return_status := fnd_api.g_ret_sts_unexp_error;
1258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1259: p_data => x_msg_data);
1260: WHEN OTHERS THEN
1261: ROLLBACK TO ROLE_RELATE_SP;

Line 1267: x_return_status := fnd_api.g_ret_sts_unexp_error;

1263: fnd_message.set_token('P_SQLCODE',SQLCODE);
1264: fnd_message.set_token('P_SQLERRM',SQLERRM);
1265: fnd_message.set_token('P_API_NAME', l_api_name);
1266: FND_MSG_PUB.add;
1267: x_return_status := fnd_api.g_ret_sts_unexp_error;
1268: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1269: p_data => x_msg_data);
1270:
1271: END create_resource_role_relate;

Line 1652: x_return_status := fnd_api.g_ret_sts_success;

1648:
1649: --Standard Start of API SAVEPOINT
1650: SAVEPOINT ROLE_RELATE_SP;
1651:
1652: x_return_status := fnd_api.g_ret_sts_success;
1653:
1654: --Standard Call to check API compatibility
1655: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1656: THEN

Line 1655: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1651:
1652: x_return_status := fnd_api.g_ret_sts_success;
1653:
1654: --Standard Call to check API compatibility
1655: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1656: THEN
1657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1658: END IF;
1659:

Line 1657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1653:
1654: --Standard Call to check API compatibility
1655: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1656: THEN
1657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1658: END IF;
1659:
1660: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1661: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1661: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1658: END IF;
1659:
1660: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1661: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1662: THEN
1663: FND_MSG_PUB.Initialize;
1664: END IF;
1665:

Line 1685: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1681: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
1682: p_data => L_data,
1683: p_count => L_count,
1684: P_return_code => l_return_code);
1685: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;

Line 1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1684: P_return_code => l_return_code);
1685: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END IF;

Line 1689: RAISE FND_API.G_EXC_ERROR;

1685: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END IF;
1693:

Line 1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END IF;
1693:
1694: end if;

Line 1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END IF;
1693:
1694: end if;
1695: end if;

Line 1712: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1708: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
1709: p_data => L_data,
1710: p_count => L_count,
1711: P_return_code => l_return_code);
1712: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;

Line 1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1711: P_return_code => l_return_code);
1712: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720:

Line 1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720:
1721: end if;

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;
1720:
1721: end if;
1722: end if;

Line 1739: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

1735: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
1736: p_data => L_data,
1737: p_count => L_count,
1738: P_return_code => l_return_code);
1739: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;

Line 1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

1738: P_return_code => l_return_code);
1739: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;

Line 1743: RAISE FND_API.G_EXC_ERROR;

1739: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747: end if;

Line 1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747: end if;
1748: end if;

Line 1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747: end if;
1748: end if;
1749: end if;

Line 1769: IF(p_start_date_active = FND_API.G_MISS_DATE)

1765: l_role_id := role_relate_rec.role_id;
1766: --Bug8434591
1767: --Typo error attribute4 , attribute6 values are overwritten by
1768: --attribute1 value, corrected the code.
1769: IF(p_start_date_active = FND_API.G_MISS_DATE)
1770: THEN
1771: l_start_date_active := role_relate_rec.start_date_active;
1772: ELSE
1773: l_start_date_active := p_start_date_active;

Line 1775: IF(p_end_date_active = FND_API.G_MISS_DATE)

1771: l_start_date_active := role_relate_rec.start_date_active;
1772: ELSE
1773: l_start_date_active := p_start_date_active;
1774: END IF;
1775: IF(p_end_date_active = FND_API.G_MISS_DATE)
1776: THEN
1777: l_end_date_active := role_relate_rec.end_date_active;
1778: ELSE
1779: l_end_date_active := p_end_date_active;

Line 1781: IF(p_attribute1 = FND_API.G_MISS_CHAR)

1777: l_end_date_active := role_relate_rec.end_date_active;
1778: ELSE
1779: l_end_date_active := p_end_date_active;
1780: END IF;
1781: IF(p_attribute1 = FND_API.G_MISS_CHAR)
1782: THEN
1783: l_attribute1 := role_relate_rec.attribute1;
1784: ELSE
1785: l_attribute1 := p_attribute1;

Line 1787: IF(p_attribute2= FND_API.G_MISS_CHAR)

1783: l_attribute1 := role_relate_rec.attribute1;
1784: ELSE
1785: l_attribute1 := p_attribute1;
1786: END IF;
1787: IF(p_attribute2= FND_API.G_MISS_CHAR)
1788: THEN
1789: l_attribute2 := role_relate_rec.attribute2;
1790: ELSE
1791: l_attribute2 := p_attribute2;

Line 1793: IF(p_attribute3 = FND_API.G_MISS_CHAR)

1789: l_attribute2 := role_relate_rec.attribute2;
1790: ELSE
1791: l_attribute2 := p_attribute2;
1792: END IF;
1793: IF(p_attribute3 = FND_API.G_MISS_CHAR)
1794: THEN
1795: l_attribute3 := role_relate_rec.attribute3;
1796: ELSE
1797: l_attribute3 := p_attribute3;

Line 1799: IF(p_attribute4 = FND_API.G_MISS_CHAR)

1795: l_attribute3 := role_relate_rec.attribute3;
1796: ELSE
1797: l_attribute3 := p_attribute3;
1798: END IF;
1799: IF(p_attribute4 = FND_API.G_MISS_CHAR)
1800: THEN
1801: l_attribute4 := role_relate_rec.attribute4;
1802: ELSE
1803: l_attribute4 := p_attribute4;

Line 1805: IF(p_attribute5 = FND_API.G_MISS_CHAR)

1801: l_attribute4 := role_relate_rec.attribute4;
1802: ELSE
1803: l_attribute4 := p_attribute4;
1804: END IF;
1805: IF(p_attribute5 = FND_API.G_MISS_CHAR)
1806: THEN
1807: l_attribute5 := role_relate_rec.attribute5;
1808: ELSE
1809: l_attribute5 := p_attribute5;

Line 1811: IF(p_attribute6 = FND_API.G_MISS_CHAR)

1807: l_attribute5 := role_relate_rec.attribute5;
1808: ELSE
1809: l_attribute5 := p_attribute5;
1810: END IF;
1811: IF(p_attribute6 = FND_API.G_MISS_CHAR)
1812: THEN
1813: l_attribute6 := role_relate_rec.attribute6;
1814: ELSE
1815: l_attribute6 := p_attribute6;

Line 1817: IF(p_attribute7 = FND_API.G_MISS_CHAR)

1813: l_attribute6 := role_relate_rec.attribute6;
1814: ELSE
1815: l_attribute6 := p_attribute6;
1816: END IF;
1817: IF(p_attribute7 = FND_API.G_MISS_CHAR)
1818: THEN
1819: l_attribute7 := role_relate_rec.attribute7;
1820: ELSE
1821: l_attribute7 := p_attribute7;

Line 1823: IF(p_attribute8 = FND_API.G_MISS_CHAR)

1819: l_attribute7 := role_relate_rec.attribute7;
1820: ELSE
1821: l_attribute7 := p_attribute7;
1822: END IF;
1823: IF(p_attribute8 = FND_API.G_MISS_CHAR)
1824: THEN
1825: l_attribute8 := role_relate_rec.attribute8;
1826: ELSE
1827: l_attribute8 := p_attribute8;

Line 1829: IF(p_attribute9 = FND_API.G_MISS_CHAR)

1825: l_attribute8 := role_relate_rec.attribute8;
1826: ELSE
1827: l_attribute8 := p_attribute8;
1828: END IF;
1829: IF(p_attribute9 = FND_API.G_MISS_CHAR)
1830: THEN
1831: l_attribute9 := role_relate_rec.attribute9;
1832: ELSE
1833: l_attribute9 := p_attribute9;

Line 1835: IF(p_attribute10 = FND_API.G_MISS_CHAR)

1831: l_attribute9 := role_relate_rec.attribute9;
1832: ELSE
1833: l_attribute9 := p_attribute9;
1834: END IF;
1835: IF(p_attribute10 = FND_API.G_MISS_CHAR)
1836: THEN
1837: l_attribute10 := role_relate_rec.attribute10;
1838: ELSE
1839: l_attribute10 := p_attribute10;

Line 1841: IF(p_attribute11 = FND_API.G_MISS_CHAR)

1837: l_attribute10 := role_relate_rec.attribute10;
1838: ELSE
1839: l_attribute10 := p_attribute10;
1840: END IF;
1841: IF(p_attribute11 = FND_API.G_MISS_CHAR)
1842: THEN
1843: l_attribute11 := role_relate_rec.attribute11;
1844: ELSE
1845: l_attribute11 := p_attribute11;

Line 1847: IF(p_attribute12 = FND_API.G_MISS_CHAR)

1843: l_attribute11 := role_relate_rec.attribute11;
1844: ELSE
1845: l_attribute11 := p_attribute11;
1846: END IF;
1847: IF(p_attribute12 = FND_API.G_MISS_CHAR)
1848: THEN
1849: l_attribute12 := role_relate_rec.attribute12;
1850: ELSE
1851: l_attribute12 := p_attribute12;

Line 1853: IF(p_attribute13 = FND_API.G_MISS_CHAR)

1849: l_attribute12 := role_relate_rec.attribute12;
1850: ELSE
1851: l_attribute12 := p_attribute12;
1852: END IF;
1853: IF(p_attribute13 = FND_API.G_MISS_CHAR)
1854: THEN
1855: l_attribute13 := role_relate_rec.attribute13;
1856: ELSE
1857: l_attribute13 := p_attribute13;

Line 1859: IF(p_attribute14 = FND_API.G_MISS_CHAR)

1855: l_attribute13 := role_relate_rec.attribute13;
1856: ELSE
1857: l_attribute13 := p_attribute13;
1858: END IF;
1859: IF(p_attribute14 = FND_API.G_MISS_CHAR)
1860: THEN
1861: l_attribute14 := role_relate_rec.attribute14;
1862: ELSE
1863: l_attribute14 := p_attribute14;

Line 1865: IF(p_attribute15 = FND_API.G_MISS_CHAR)

1861: l_attribute14 := role_relate_rec.attribute14;
1862: ELSE
1863: l_attribute14 := p_attribute14;
1864: END IF;
1865: IF(p_attribute15 = FND_API.G_MISS_CHAR)
1866: THEN
1867: l_attribute15 := role_relate_rec.attribute15;
1868: ELSE
1869: l_attribute15 := p_attribute15;

Line 1872: IF(p_attribute_category = FND_API.G_MISS_CHAR)

1868: ELSE
1869: l_attribute15 := p_attribute15;
1870: END IF;
1871:
1872: IF(p_attribute_category = FND_API.G_MISS_CHAR)
1873: THEN
1874: l_attribute_category := role_relate_rec.attribute_category;
1875: ELSE
1876: l_attribute_category := p_attribute_category;

Line 1893: RAISE fnd_api.g_exc_error;

1889: IF(l_start_date_active is NULL)
1890: THEN
1891: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1892: FND_MSG_PUB.add;
1893: RAISE fnd_api.g_exc_error;
1894: END IF;
1895:
1896:
1897:

Line 1904: RAISE fnd_api.g_exc_error;

1900: THEN
1901:
1902: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1903: FND_MSG_PUB.add;
1904: RAISE fnd_api.g_exc_error;
1905: END IF;
1906:
1907:
1908: IF(l_role_resource_type = 'RS_TEAM' or

Line 1920: RAISE fnd_api.g_exc_error;

1916:
1917: if (l_role_type_valid = false) then
1918: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');
1919: FND_MSG_PUB.add;
1920: RAISE fnd_api.g_exc_error;
1921: end if;
1922: END IF;
1923:
1924:

Line 1947: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

1943: l_date_invalid := TRUE;
1944: END IF;
1945:
1946: --IF((l_end_date_active between check_date_rec.start_date_active and check_date_rec.end_date_active)
1947: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
1948: between check_date_rec.start_date_active and
1949: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
1950: OR (l_end_date_active IS NULL AND
1951: check_date_rec.end_date_active IS NULL))

Line 1949: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

1945:
1946: --IF((l_end_date_active between check_date_rec.start_date_active and check_date_rec.end_date_active)
1947: IF((to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
1948: between check_date_rec.start_date_active and
1949: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
1950: OR (l_end_date_active IS NULL AND
1951: check_date_rec.end_date_active IS NULL))
1952: THEN
1953:

Line 1958: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') >

1954: l_date_invalid := TRUE;
1955: END IF;
1956: -- added this check as a date range outside of the existing ranges was getting entered
1957: if(l_start_date_active < check_date_rec.start_date_active
1958: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') >
1959: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
1960: THEN
1961: l_date_invalid := TRUE;
1962: END IF;

Line 1959: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

1955: END IF;
1956: -- added this check as a date range outside of the existing ranges was getting entered
1957: if(l_start_date_active < check_date_rec.start_date_active
1958: and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') >
1959: to_date(to_char(nvl(check_date_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
1960: THEN
1961: l_date_invalid := TRUE;
1962: END IF;
1963:

Line 1975: RAISE fnd_api.g_exc_error;

1971: IF(l_date_invalid)
1972: THEN
1973: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1974: FND_MSG_PUB.add;
1975: RAISE fnd_api.g_exc_error;
1976: END IF;
1977:
1978: --end of overlapping date range check
1979:

Line 2001: RAISE fnd_api.g_exc_error;

1997: THEN
1998: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
1999: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
2000: fnd_msg_pub.add;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: CLOSE grp_mem_cur;
2004:
2005: END IF;

Line 2031: RAISE fnd_api.g_exc_error;

2027:
2028: l_role_valid := FALSE;
2029: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
2030: FND_MSG_PUB.add;
2031: RAISE fnd_api.g_exc_error;
2032: END IF;
2033: close res_role_cur;
2034: ELSIF((l_role_resource_type = 'RS_TEAM_MEMBER') AND
2035: (l_team_resource_type = 'GROUP'))

Line 2054: RAISE fnd_api.g_exc_error;

2050: ELSE
2051: l_role_valid := FALSE;
2052: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
2053: FND_MSG_PUB.add;
2054: RAISE fnd_api.g_exc_error;
2055: END IF;
2056: close grp_role_cur;
2057:
2058: END IF;

Line 2069: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2065: open team_cur(l_role_resource_id);
2066: fetch team_cur INTO team_rec;
2067: close team_cur;
2068: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
2069: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2070: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2071: THEN
2072: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2073: FND_MSG_PUB.add;

Line 2070: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2066: fetch team_cur INTO team_rec;
2067: close team_cur;
2068: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
2069: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2070: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2071: THEN
2072: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2073: FND_MSG_PUB.add;
2074: RAISE fnd_api.g_exc_error;

Line 2074: RAISE fnd_api.g_exc_error;

2070: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2071: THEN
2072: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2073: FND_MSG_PUB.add;
2074: RAISE fnd_api.g_exc_error;
2075: END IF;
2076:
2077: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
2078: THEN

Line 2081: RAISE fnd_api.g_exc_error;

2077: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
2078: THEN
2079: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2080: FND_MSG_PUB.add;
2081: RAISE fnd_api.g_exc_error;
2082: END IF;
2083:
2084: ELSIF(l_role_resource_type = 'RS_GROUP_MEMBER')
2085: THEN

Line 2091: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2087: fetch group_cur INTO group_rec;
2088: close group_cur;
2089:
2090: -- IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
2091: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2092: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2093: THEN
2094:
2095: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

Line 2092: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2088: close group_cur;
2089:
2090: -- IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
2091: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2092: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2093: THEN
2094:
2095: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2096: FND_MSG_PUB.add;

Line 2097: RAISE fnd_api.g_exc_error;

2093: THEN
2094:
2095: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2096: FND_MSG_PUB.add;
2097: RAISE fnd_api.g_exc_error;
2098: END IF;
2099:
2100:
2101:

Line 2106: RAISE fnd_api.g_exc_error;

2102: IF(group_rec.end_date_active is not null AND l_end_date_active is null)
2103: THEN
2104: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2105: FND_MSG_PUB.add;
2106: RAISE fnd_api.g_exc_error;
2107: END IF;
2108:
2109: --exclusive flag validation
2110: open c_exclusive_group_check_cur(l_role_resource_id,

Line 2119: RAISE fnd_api.g_exc_error;

2115: IF(c_exclusive_group_check_cur%FOUND)
2116: THEN
2117: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
2118: FND_MSG_PUB.add;
2119: RAISE fnd_api.g_exc_error;
2120: END IF;
2121:
2122: close c_exclusive_group_check_cur;
2123: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')

Line 2132: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')))

2128: close rsc_cur;
2129:
2130: IF((rsc_rec.start_date_active > l_start_date_active)
2131: --changed by sudarsana 11 feb 2002
2132: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')))
2133: -- OR (rsc_rec.end_date_active < l_end_date_active))
2134: THEN
2135: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
2136: FND_MSG_PUB.add;

Line 2137: RAISE fnd_api.g_exc_error;

2133: -- OR (rsc_rec.end_date_active < l_end_date_active))
2134: THEN
2135: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
2136: FND_MSG_PUB.add;
2137: RAISE fnd_api.g_exc_error;
2138: END IF;
2139:
2140: ELSIF(l_role_resource_type = 'RS_GROUP')
2141: THEN

Line 2148: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

2144: close group_dt_cur;
2145: IF((group_dt_rec.start_date_active > l_start_date_active)
2146: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
2147: --OR (group_dt_rec.end_date_active < l_end_date_active))
2148: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2149: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
2152: FND_MSG_PUB.add;

Line 2149: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))

2145: IF((group_dt_rec.start_date_active > l_start_date_active)
2146: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
2147: --OR (group_dt_rec.end_date_active < l_end_date_active))
2148: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2149: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
2152: FND_MSG_PUB.add;
2153: RAISE fnd_api.g_exc_error;

Line 2153: RAISE fnd_api.g_exc_error;

2149: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
2152: FND_MSG_PUB.add;
2153: RAISE fnd_api.g_exc_error;
2154: END IF;
2155: ELSIF(l_role_resource_type = 'RS_TEAM')
2156: THEN
2157: open team_dt_cur(l_role_resource_id);

Line 2163: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

2159: close team_dt_cur;
2160: IF((team_dt_rec.start_date_active > l_start_date_active)
2161: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
2162: --OR (team_dt_rec.end_date_active < l_end_date_active))
2163: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2164: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2165: THEN
2166: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
2167: FND_MSG_PUB.add;

Line 2164: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))

2160: IF((team_dt_rec.start_date_active > l_start_date_active)
2161: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
2162: --OR (team_dt_rec.end_date_active < l_end_date_active))
2163: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2164: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2165: THEN
2166: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
2167: FND_MSG_PUB.add;
2168: RAISE fnd_api.g_exc_error;

Line 2168: RAISE fnd_api.g_exc_error;

2164: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2165: THEN
2166: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
2167: FND_MSG_PUB.add;
2168: RAISE fnd_api.g_exc_error;
2169: END IF;
2170: END IF;
2171:
2172: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not

Line 2185: x_return_status := fnd_api.g_ret_sts_error;

2181:
2182: If(res_team_cur%found)
2183: THEN
2184:
2185: x_return_status := fnd_api.g_ret_sts_error;
2186: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2187: FND_MSG_PUB.add;
2188: RAISE fnd_api.g_exc_error;
2189: END IF;

Line 2188: RAISE fnd_api.g_exc_error;

2184:
2185: x_return_status := fnd_api.g_ret_sts_error;
2186: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2187: FND_MSG_PUB.add;
2188: RAISE fnd_api.g_exc_error;
2189: END IF;
2190: close res_team_cur;
2191:
2192: open res_group_cur(l_role_resource_id,

Line 2202: RAISE fnd_api.g_exc_error;

2198: If(res_group_cur%found)
2199: THEN
2200: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2201: FND_MSG_PUB.add;
2202: RAISE fnd_api.g_exc_error;
2203: END IF;
2204: close res_group_cur;
2205:
2206:

Line 2222: RAISE fnd_api.g_exc_error;

2218: If NOT(l_valid)
2219: THEN
2220: --fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');
2221: --FND_MSG_PUB.add;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:
2225: END IF;
2226:

Line 2240: RAISE fnd_api.g_exc_error;

2236:
2237: WHEN OTHERS THEN
2238: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
2239: fnd_msg_pub.add;
2240: RAISE fnd_api.g_exc_error;
2241:
2242: END;
2243:
2244: l_object_version_number := l_object_version_number +1;

Line 2262: IF(l_return_status <> fnd_api.g_ret_sts_success)

2258: X_RETURN_STATUS => l_return_status,
2259: X_MSG_COUNT => l_msg_count,
2260: X_MSG_DATA => l_msg_data );
2261:
2262: IF(l_return_status <> fnd_api.g_ret_sts_success)
2263: THEN
2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2262: IF(l_return_status <> fnd_api.g_ret_sts_success)
2263: THEN
2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: END IF;

Line 2267: RAISE FND_API.G_EXC_ERROR;

2263: THEN
2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: END IF;
2271:

Line 2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: END IF;
2271:
2272: END IF;

Line 2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: END IF;
2271:
2272: END IF;
2273:

Line 2281: ,p_init_msg_list => fnd_api.g_false

2277: begin
2278:
2279: jtf_rs_wf_events_pub.update_resource_role_relate
2280: (p_api_version => 1.0
2281: ,p_init_msg_list => fnd_api.g_false
2282: ,p_commit => fnd_api.g_false
2283: ,p_role_relate_id => l_role_relate_id
2284: ,p_role_resource_type => l_role_resource_type
2285: ,p_role_resource_id => l_role_resource_id

Line 2282: ,p_commit => fnd_api.g_false

2278:
2279: jtf_rs_wf_events_pub.update_resource_role_relate
2280: (p_api_version => 1.0
2281: ,p_init_msg_list => fnd_api.g_false
2282: ,p_commit => fnd_api.g_false
2283: ,p_role_relate_id => l_role_relate_id
2284: ,p_role_resource_type => l_role_resource_type
2285: ,p_role_resource_id => l_role_resource_id
2286: ,p_role_id => l_role_id

Line 2387: RAISE fnd_api.g_exc_unexpected_error;

2383: fnd_message.set_token('P_SQLCODE',SQLCODE);
2384: fnd_message.set_token('P_SQLERRM',SQLERRM);
2385: fnd_message.set_token('P_API_NAME', l_api_name);
2386: FND_MSG_PUB.add;
2387: RAISE fnd_api.g_exc_unexpected_error;
2388:
2389:
2390: end;
2391:

Line 2414: RAISE fnd_api.g_exc_unexpected_error;

2410: fnd_message.set_token('P_SQLCODE',SQLCODE);
2411: fnd_message.set_token('P_SQLERRM',SQLERRM);
2412: fnd_message.set_token('P_API_NAME', l_api_name);
2413: FND_MSG_PUB.add;
2414: RAISE fnd_api.g_exc_unexpected_error;
2415: end;
2416:
2417: else
2418:

Line 2431: IF(l_return_status <> fnd_api.g_ret_sts_success)

2427: X_RETURN_STATUS => l_return_status,
2428: X_MSG_COUNT => l_msg_count,
2429: X_MSG_DATA => l_msg_data);
2430:
2431: IF(l_return_status <> fnd_api.g_ret_sts_success)
2432: THEN
2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2434: RAISE FND_API.G_EXC_ERROR;
2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2429: X_MSG_DATA => l_msg_data);
2430:
2431: IF(l_return_status <> fnd_api.g_ret_sts_success)
2432: THEN
2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2434: RAISE FND_API.G_EXC_ERROR;
2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;

Line 2434: RAISE FND_API.G_EXC_ERROR;

2430:
2431: IF(l_return_status <> fnd_api.g_ret_sts_success)
2432: THEN
2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2434: RAISE FND_API.G_EXC_ERROR;
2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438:

Line 2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2431: IF(l_return_status <> fnd_api.g_ret_sts_success)
2432: THEN
2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2434: RAISE FND_API.G_EXC_ERROR;
2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438:
2439:

Line 2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2432: THEN
2433: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2434: RAISE FND_API.G_EXC_ERROR;
2435: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438:
2439:
2440: END IF;

Line 2455: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

2451: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
2452: p_data => L_data,
2453: p_count => L_count,
2454: P_return_code => l_return_code);
2455: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;

Line 2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2454: P_return_code => l_return_code);
2455: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: END IF;

Line 2459: RAISE FND_API.G_EXC_ERROR;

2455: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: END IF;
2463:

Line 2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: END IF;
2463:
2464: end if;

Line 2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: END IF;
2463:
2464: end if;
2465: end if;

Line 2481: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

2477: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
2478: p_data => L_data,
2479: p_count => L_count,
2480: P_return_code => l_return_code);
2481: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;

Line 2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2480: P_return_code => l_return_code);
2481: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2488: END IF;

Line 2485: RAISE FND_API.G_EXC_ERROR;

2481: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2488: END IF;
2489:

Line 2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2488: END IF;
2489:
2490: end if;

Line 2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2488: END IF;
2489:
2490: end if;
2491: end if;

Line 2509: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS)

2505: P_OBJECT_VERSION_NUM => P_OBJECT_VERSION_NUM,
2506: p_data => L_data,
2507: p_count => L_count,
2508: P_return_code => l_return_code);
2509: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS)
2510: then
2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

Line 2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2509: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS)
2510: then
2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2517: END IF;

Line 2514: RAISE FND_API.G_EXC_ERROR;

2510: then
2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2517: END IF;
2518: end if;

Line 2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2517: END IF;
2518: end if;
2519: end if;

Line 2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2517: END IF;
2518: end if;
2519: end if;
2520: end if;

Line 2563: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2559: p_bind_data_id => l_bind_data_id,
2560: x_return_code => x_return_status);
2561:
2562:
2563: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2564: -- x_return_status := fnd_api.g_ret_sts_error;
2565:
2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;

Line 2564: -- x_return_status := fnd_api.g_ret_sts_error;

2560: x_return_code => x_return_status);
2561:
2562:
2563: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2564: -- x_return_status := fnd_api.g_ret_sts_error;
2565:
2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2564: -- x_return_status := fnd_api.g_ret_sts_error;
2565:
2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;

Line 2569: RAISE FND_API.G_EXC_ERROR;

2565:
2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:

Line 2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:
2574:

Line 2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:
2574:
2575: END IF;

Line 2586: IF fnd_api.to_boolean (p_commit)

2582:
2583:
2584:
2585:
2586: IF fnd_api.to_boolean (p_commit)
2587: THEN
2588: COMMIT WORK;
2589: END IF;
2590:

Line 2595: WHEN fnd_api.g_exc_error THEN

2591:
2592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2593:
2594: EXCEPTION
2595: WHEN fnd_api.g_exc_error THEN
2596: ROLLBACK TO ROLE_RELATE_SP;
2597: x_return_status := fnd_api.g_ret_sts_error;
2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2599: p_data => x_msg_data);

Line 2597: x_return_status := fnd_api.g_ret_sts_error;

2593:
2594: EXCEPTION
2595: WHEN fnd_api.g_exc_error THEN
2596: ROLLBACK TO ROLE_RELATE_SP;
2597: x_return_status := fnd_api.g_ret_sts_error;
2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: WHEN fnd_api.g_exc_unexpected_error THEN
2601: ROLLBACK TO ROLE_RELATE_SP;

Line 2600: WHEN fnd_api.g_exc_unexpected_error THEN

2596: ROLLBACK TO ROLE_RELATE_SP;
2597: x_return_status := fnd_api.g_ret_sts_error;
2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: WHEN fnd_api.g_exc_unexpected_error THEN
2601: ROLLBACK TO ROLE_RELATE_SP;
2602: x_return_status := fnd_api.g_ret_sts_unexp_error;
2603: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2604: p_data => x_msg_data);

Line 2602: x_return_status := fnd_api.g_ret_sts_unexp_error;

2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: WHEN fnd_api.g_exc_unexpected_error THEN
2601: ROLLBACK TO ROLE_RELATE_SP;
2602: x_return_status := fnd_api.g_ret_sts_unexp_error;
2603: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2604: p_data => x_msg_data);
2605: WHEN OTHERS THEN
2606: ROLLBACK TO ROLE_RELATE_SP;

Line 2612: x_return_status := fnd_api.g_ret_sts_unexp_error;

2608: fnd_message.set_token('P_SQLCODE',SQLCODE);
2609: fnd_message.set_token('P_SQLERRM',SQLERRM);
2610: fnd_message.set_token('P_API_NAME', l_api_name);
2611: FND_MSG_PUB.add;
2612: x_return_status := fnd_api.g_ret_sts_unexp_error;
2613: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2614: p_data => x_msg_data);
2615:
2616: END update_resource_role_relate;

Line 2676: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

2672: AND rlt.role_resource_id = mem.group_member_id
2673: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2674: AND rlt.role_id = l_role_id
2675: --AND nvl(end_date_active, TRUNC(sysdate) + 1) > TRUNC(sysdate)
2676: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2677: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2678: AND nvl(rlt.delete_flag, '0') <> 'Y';
2679:
2680: chk_grp_rec chk_grp_cur%rowtype;

Line 2677: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2673: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2674: AND rlt.role_id = l_role_id
2675: --AND nvl(end_date_active, TRUNC(sysdate) + 1) > TRUNC(sysdate)
2676: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2677: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2678: AND nvl(rlt.delete_flag, '0') <> 'Y';
2679:
2680: chk_grp_rec chk_grp_cur%rowtype;
2681:

Line 2696: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')

2692: AND rlt.role_resource_id = mem.team_member_id
2693: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'
2694: AND rlt.role_id = l_role_id
2695: --AND nvl(rlt.end_date_active, TRUNC(sysdate) + 1) > TRUNC(sysdate)
2696: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2697: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2698: AND nvl(rlt.delete_flag, '0') <> 'Y';
2699:
2700:

Line 2697: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))

2693: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'
2694: AND rlt.role_id = l_role_id
2695: --AND nvl(rlt.end_date_active, TRUNC(sysdate) + 1) > TRUNC(sysdate)
2696: AND (start_date_active between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2697: OR to_date(to_char(nvl(end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') between l_start_date_active and to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2698: AND nvl(rlt.delete_flag, '0') <> 'Y';
2699:
2700:
2701: chk_team_rec chk_team_cur%rowtype;

Line 2784: x_return_status := fnd_api.g_ret_sts_success;

2780:
2781: --Standard Start of API SAVEPOINT
2782: SAVEPOINT ROLE_RELATE_SP;
2783:
2784: x_return_status := fnd_api.g_ret_sts_success;
2785:
2786: --Standard Call to check API compatibility
2787: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2788: THEN

Line 2787: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

2783:
2784: x_return_status := fnd_api.g_ret_sts_success;
2785:
2786: --Standard Call to check API compatibility
2787: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2788: THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: END IF;
2791:

Line 2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2785:
2786: --Standard Call to check API compatibility
2787: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2788: THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: END IF;
2791:
2792: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2793: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 2793: IF FND_API.To_boolean(P_INIT_MSG_LIST)

2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: END IF;
2791:
2792: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2793: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2794: THEN
2795: FND_MSG_PUB.Initialize;
2796: END IF;
2797:

Line 2809: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

2805: P_OBJECT_VERSION_NUM => p_object_version_num,
2806: p_data => L_data,
2807: p_count => L_count,
2808: P_return_code => l_return_code);
2809: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;

Line 2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2808: P_return_code => l_return_code);
2809: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2816: END IF;

Line 2813: RAISE FND_API.G_EXC_ERROR;

2809: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2816: END IF;
2817:

Line 2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2816: END IF;
2817:
2818: end if;

Line 2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2816: END IF;
2817:
2818: end if;
2819: end if;

Line 2834: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

2830: P_OBJECT_VERSION_NUM => p_object_version_num,
2831: p_data => L_data,
2832: p_count => L_count,
2833: P_return_code => l_return_code);
2834: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;

Line 2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2833: P_return_code => l_return_code);
2834: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;

Line 2838: RAISE FND_API.G_EXC_ERROR;

2834: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842:

Line 2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842:
2843: end if;

Line 2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842:
2843: end if;
2844: end if;

Line 2859: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

2855: P_OBJECT_VERSION_NUM => p_object_version_num,
2856: p_data => L_data,
2857: p_count => L_count,
2858: P_return_code => l_return_code);
2859: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;

Line 2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

2858: P_return_code => l_return_code);
2859: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;
2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2866: END IF;

Line 2863: RAISE FND_API.G_EXC_ERROR;

2859: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;
2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2866: END IF;
2867:

Line 2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;
2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2866: END IF;
2867:
2868: end if;

Line 2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;
2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2866: END IF;
2867:
2868: end if;
2869: end if;

Line 2913: RAISE fnd_api.g_exc_error;

2909: IF(chk_team_cur%FOUND) THEN
2910: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2911: FND_MSG_PUB.add;
2912: CLOSE chk_team_cur;
2913: RAISE fnd_api.g_exc_error;
2914: END IF;
2915: CLOSE chk_team_cur;
2916: OPEN chk_grp_cur (chk_type_rec.role_resource_id ,
2917: chk_type_rec.role_id,

Line 2925: RAISE fnd_api.g_exc_error;

2921: IF(chk_grp_cur%FOUND) THEN
2922: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2923: FND_MSG_PUB.add;
2924: CLOSE chk_grp_cur;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;
2927: CLOSE chk_grp_cur;
2928: END IF;
2929:

Line 2950: IF(l_return_status <> fnd_api.g_ret_sts_success)

2946: X_RETURN_STATUS => l_return_status,
2947: X_MSG_COUNT => l_msg_count,
2948: X_MSG_DATA => l_msg_data );
2949:
2950: IF(l_return_status <> fnd_api.g_ret_sts_success)
2951: THEN
2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2950: IF(l_return_status <> fnd_api.g_ret_sts_success)
2951: THEN
2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2958: END IF;

Line 2955: RAISE FND_API.G_EXC_ERROR;

2951: THEN
2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2958: END IF;
2959:

Line 2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2958: END IF;
2959:
2960: END IF;

Line 2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2958: END IF;
2959:
2960: END IF;
2961:

Line 3051: RAISE fnd_api.g_exc_unexpected_error;

3047: fnd_message.set_token('P_SQLCODE',SQLCODE);
3048: fnd_message.set_token('P_SQLERRM',SQLERRM);
3049: fnd_message.set_token('P_API_NAME', l_api_name);
3050: FND_MSG_PUB.add;
3051: RAISE fnd_api.g_exc_unexpected_error;
3052:
3053:
3054: end;
3055:

Line 3078: RAISE fnd_api.g_exc_unexpected_error;

3074: fnd_message.set_token('P_SQLERRM',SQLERRM);
3075: fnd_message.set_token('P_API_NAME', l_api_name);
3076: FND_MSG_PUB.add;
3077:
3078: RAISE fnd_api.g_exc_unexpected_error;
3079: end;
3080:
3081: else
3082:

Line 3094: IF(l_return_status <> fnd_api.g_ret_sts_success)

3090: X_RETURN_STATUS => l_return_status,
3091: X_MSG_COUNT => l_msg_count,
3092: X_MSG_DATA => l_msg_data);
3093:
3094: IF(l_return_status <> fnd_api.g_ret_sts_success)
3095: THEN
3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3097: RAISE FND_API.G_EXC_ERROR;
3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3092: X_MSG_DATA => l_msg_data);
3093:
3094: IF(l_return_status <> fnd_api.g_ret_sts_success)
3095: THEN
3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3097: RAISE FND_API.G_EXC_ERROR;
3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3100: END IF;

Line 3097: RAISE FND_API.G_EXC_ERROR;

3093:
3094: IF(l_return_status <> fnd_api.g_ret_sts_success)
3095: THEN
3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3097: RAISE FND_API.G_EXC_ERROR;
3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3100: END IF;
3101:

Line 3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3094: IF(l_return_status <> fnd_api.g_ret_sts_success)
3095: THEN
3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3097: RAISE FND_API.G_EXC_ERROR;
3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3100: END IF;
3101:
3102: END IF;

Line 3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3095: THEN
3096: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3097: RAISE FND_API.G_EXC_ERROR;
3098: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3100: END IF;
3101:
3102: END IF;
3103: END IF; -- END OF COUNT CHECK

Line 3117: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

3113: P_OBJECT_VERSION_NUM => p_object_version_num,
3114: p_data => L_data,
3115: p_count => L_count,
3116: P_return_code => l_return_code);
3117: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;

Line 3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

3116: P_return_code => l_return_code);
3117: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;

Line 3121: RAISE FND_API.G_EXC_ERROR;

3117: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125: end if;

Line 3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125: end if;
3126: end if;

Line 3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125: end if;
3126: end if;
3127: end if;

Line 3142: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

3138: P_OBJECT_VERSION_NUM => p_object_version_num,
3139: p_data => L_data,
3140: p_count => L_count,
3141: P_return_code => l_return_code);
3142: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;

Line 3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

3141: P_return_code => l_return_code);
3142: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;
3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3149: END IF;

Line 3146: RAISE FND_API.G_EXC_ERROR;

3142: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;
3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3149: END IF;
3150: end if;

Line 3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;
3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3149: END IF;
3150: end if;
3151: end if;

Line 3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;
3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3149: END IF;
3150: end if;
3151: end if;
3152: end if;

Line 3168: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then

3164: P_OBJECT_VERSION_NUM => p_object_version_num,
3165: p_data => L_data,
3166: p_count => L_count,
3167: P_return_code => l_return_code);
3168: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;

Line 3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

3167: P_return_code => l_return_code);
3168: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: END IF;

Line 3172: RAISE FND_API.G_EXC_ERROR;

3168: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: END IF;
3176: end if;

Line 3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: END IF;
3176: end if;
3177: end if;

Line 3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: END IF;
3176: end if;
3177: end if;
3178: end if;

Line 3220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

3216: p_bind_data_id => l_bind_data_id,
3217: x_return_code => x_return_status);
3218:
3219:
3220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3221: --x_return_status := fnd_api.g_ret_sts_error;
3222:
3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3224: fnd_msg_pub.add;

Line 3221: --x_return_status := fnd_api.g_ret_sts_error;

3217: x_return_code => x_return_status);
3218:
3219:
3220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3221: --x_return_status := fnd_api.g_ret_sts_error;
3222:
3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3224: fnd_msg_pub.add;
3225:

Line 3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

3222:
3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3224: fnd_msg_pub.add;
3225:
3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;

Line 3227: RAISE FND_API.G_EXC_ERROR;

3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3224: fnd_msg_pub.add;
3225:
3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:

Line 3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

3224: fnd_msg_pub.add;
3225:
3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:
3232: END IF;

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3225:
3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:
3232: END IF;
3233:

Line 3242: IF fnd_api.to_boolean (p_commit)

3238:
3239:
3240: -- end of user hook call
3241:
3242: IF fnd_api.to_boolean (p_commit)
3243: THEN
3244: COMMIT WORK;
3245: END IF;
3246:

Line 3253: ,p_init_msg_list => fnd_api.g_false

3249:
3250: begin
3251: jtf_rs_wf_events_pub.delete_resource_role_relate
3252: (p_api_version => 1.0
3253: ,p_init_msg_list => fnd_api.g_false
3254: ,p_commit => fnd_api.g_false
3255: ,p_role_relate_id => l_role_relate_id
3256: ,x_return_status => l_return_status
3257: ,x_msg_count => l_msg_count

Line 3254: ,p_commit => fnd_api.g_false

3250: begin
3251: jtf_rs_wf_events_pub.delete_resource_role_relate
3252: (p_api_version => 1.0
3253: ,p_init_msg_list => fnd_api.g_false
3254: ,p_commit => fnd_api.g_false
3255: ,p_role_relate_id => l_role_relate_id
3256: ,x_return_status => l_return_status
3257: ,x_msg_count => l_msg_count
3258: ,x_msg_data => l_msg_data);

Line 3269: WHEN fnd_api.g_exc_error THEN

3265:
3266: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3267:
3268: EXCEPTION
3269: WHEN fnd_api.g_exc_error THEN
3270: ROLLBACK TO ROLE_RELATE_SP;
3271: x_return_status := fnd_api.g_ret_sts_error;
3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3273: p_data => x_msg_data);

Line 3271: x_return_status := fnd_api.g_ret_sts_error;

3267:
3268: EXCEPTION
3269: WHEN fnd_api.g_exc_error THEN
3270: ROLLBACK TO ROLE_RELATE_SP;
3271: x_return_status := fnd_api.g_ret_sts_error;
3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3273: p_data => x_msg_data);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: ROLLBACK TO ROLE_RELATE_SP;

Line 3274: WHEN fnd_api.g_exc_unexpected_error THEN

3270: ROLLBACK TO ROLE_RELATE_SP;
3271: x_return_status := fnd_api.g_ret_sts_error;
3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3273: p_data => x_msg_data);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: ROLLBACK TO ROLE_RELATE_SP;
3276: x_return_status := fnd_api.g_ret_sts_unexp_error;
3277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3278: p_data => x_msg_data);

Line 3276: x_return_status := fnd_api.g_ret_sts_unexp_error;

3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3273: p_data => x_msg_data);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: ROLLBACK TO ROLE_RELATE_SP;
3276: x_return_status := fnd_api.g_ret_sts_unexp_error;
3277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3278: p_data => x_msg_data);
3279: WHEN OTHERS THEN
3280: ROLLBACK TO ROLE_RELATE_SP;

Line 3286: x_return_status := fnd_api.g_ret_sts_unexp_error;

3282: fnd_message.set_token('P_SQLCODE',SQLCODE);
3283: fnd_message.set_token('P_SQLERRM',SQLERRM);
3284: fnd_message.set_token('P_API_NAME', l_api_name);
3285: FND_MSG_PUB.add;
3286: x_return_status := fnd_api.g_ret_sts_unexp_error;
3287: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3288: p_data => x_msg_data);
3289:
3290: END delete_resource_role_relate;