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

Line 129: l_return_status := FND_API.G_RET_STS_SUCCESS;

125: LOOP
126:
127: l_role_name:=xrec.approver_name;
128:
129: l_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: l_notif_id := WF_NOTIFICATION.Send
132: ( role => l_role_name
133: , msg_type => l_item_type

Line 181: l_return_status := FND_API.G_RET_STS_SUCCESS;

177: LOOP
178:
179: l_role_name:=xrec.approver_name;
180:
181: l_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: l_notif_id := WF_NOTIFICATION.Send
184: ( role => l_role_name
185: , msg_type => l_item_type

Line 208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

204: end if;
205:
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO NOTIFY_TERMINATION;
210: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
212: p_count => x_msg_count,

Line 210: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO NOTIFY_TERMINATION;
210: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
212: p_count => x_msg_count,
213: p_data => x_msg_data);
214:

Line 211: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO NOTIFY_TERMINATION;
210: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
212: p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_ERROR THEN

Line 215: WHEN FND_API.G_EXC_ERROR THEN

211: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
212: p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO NOTIFY_TERMINATION;
217: X_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
219: p_count => x_msg_count,

Line 217: X_return_status := FND_API.G_RET_STS_ERROR;

213: p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO NOTIFY_TERMINATION;
217: X_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => X_msg_data);
221: WHEN OTHERS THEN

Line 218: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

214:
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO NOTIFY_TERMINATION;
217: X_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => X_msg_data);
221: WHEN OTHERS THEN
222: ROLLBACK TO NOTIFY_TERMINATION;

Line 223: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

219: p_count => x_msg_count,
220: p_data => X_msg_data);
221: WHEN OTHERS THEN
222: ROLLBACK TO NOTIFY_TERMINATION;
223: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
227: p_procedure_name => 'NOTIFY_TERMINATION',

Line 230: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

226: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
227: p_procedure_name => 'NOTIFY_TERMINATION',
228: p_error_text => SUBSTR(SQLERRM,1,240));
229: END IF;
230: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => X_msg_data);
233: END;
234:

Line 241: p_default IN VARCHAR2 := FND_API.G_FALSE,

237: p_api_version IN NUMBER:= 1.0,
238: p_init_msg_list IN VARCHAR2,
239: p_commit IN VARCHAR2,
240: p_validation_level IN NUMBER,
241: p_default IN VARCHAR2 := FND_API.G_FALSE,
242: p_module_type IN VARCHAR2,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,

Line 262: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

258: l_msg_count NUMBER;
259: l_msg_data VARCHAR2(2000);
260: l_activity_id NUMBER:=p_source_OPERATION_id;
261: l_Status VARCHAR2(1);
262: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
263: l_object_Version_number NUMBER:=nvl(p_object_Version_number,0);
264:
265: l_upd_status VARCHAR2(50);
266: l_rev_status VARCHAR2(50);

Line 352: IF FND_API.to_boolean(l_init_msg_list) THEN

348: END IF;
349:
350: -- Standard call to check for call compatibility.
351:
352: IF FND_API.to_boolean(l_init_msg_list) THEN
353: FND_MSG_PUB.initialize;
354: END IF;
355:
356: -- Initialize API return status to success

Line 358: x_return_status :=FND_API.G_RET_STS_SUCCESS;

354: END IF;
355:
356: -- Initialize API return status to success
357:
358: x_return_status :=FND_API.G_RET_STS_SUCCESS;
359:
360: -- Get approval process setup.
361: IF (G_PM_INSTALL = 'Y') THEN
362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');

Line 396: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

392: x_return_status=>l_return_status,
393: x_msg_count =>l_msg_count,
394: x_msg_data =>l_msg_data);
395: END IF ;
396: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
397: THEN
398: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
399: FND_MSG_PUB.ADD;
400: END IF;

Line 402: IF p_source_operation_id is null or p_source_operation_id=FND_API.G_MISS_NUM

398: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
399: FND_MSG_PUB.ADD;
400: END IF;
401:
402: IF p_source_operation_id is null or p_source_operation_id=FND_API.G_MISS_NUM
403: THEN
404: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJECT_ID_NULL');
405: FND_MSG_PUB.ADD;
406: ELSE

Line 433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

429: x_msg_data =>l_msg,
430: x_return_status =>l_return_Status
431: );
432:
433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
434: THEN
435: FND_MESSAGE.SET_NAME('AHL',l_msg);
436: FND_MESSAGE.set_token('FIELD',l_start_Date);
437: FND_MSG_PUB.ADD;

Line 474: l_oper_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE )

470:
471: ELSIF
472: (
473: ( l_oper_rec.END_DATE_ACTIVE IS NOT NULL OR
474: l_oper_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE )
475: AND
476: l_oper_rec.revision_status_code = 'COMPLETE'
477: )
478: THEN

Line 514: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510:
511: IF l_msg_count > 0
512: THEN
513: X_msg_count := l_msg_count;
514: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: IF l_ACTIVE='Y'

Line 515: RAISE FND_API.G_EXC_ERROR;

511: IF l_msg_count > 0
512: THEN
513: X_msg_count := l_msg_count;
514: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: IF l_ACTIVE='Y'
519: THEN

Line 572: p_commit =>FND_API.G_FALSE,

568: COMPLETE_OPER_REVISION
569: (
570: p_api_version =>p_api_version,
571: p_init_msg_list =>p_init_msg_list,
572: p_commit =>FND_API.G_FALSE,
573: p_validation_level =>p_validation_level ,
574: p_default =>p_default ,
575: p_module_type =>p_module_type,
576: x_return_status =>l_return_status,

Line 597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593:
594: IF l_msg_count > 0
595: THEN
596: X_msg_count := l_msg_count;
597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 598: RAISE FND_API.G_EXC_ERROR;

594: IF l_msg_count > 0
595: THEN
596: X_msg_count := l_msg_count;
597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601: IF FND_API.TO_BOOLEAN(p_commit) THEN
602: COMMIT;

Line 601: IF FND_API.TO_BOOLEAN(p_commit) THEN

597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601: IF FND_API.TO_BOOLEAN(p_commit) THEN
602: COMMIT;
603: END IF;
604: EXCEPTION
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

601: IF FND_API.TO_BOOLEAN(p_commit) THEN
602: COMMIT;
603: END IF;
604: EXCEPTION
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO INITIATE_OPER_APPROVAL;
607: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
609: p_count => x_msg_count,

Line 607: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

603: END IF;
604: EXCEPTION
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO INITIATE_OPER_APPROVAL;
607: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611:

Line 608: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

604: EXCEPTION
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO INITIATE_OPER_APPROVAL;
607: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611:
612: WHEN FND_API.G_EXC_ERROR THEN

Line 612: WHEN FND_API.G_EXC_ERROR THEN

608: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO INITIATE_OPER_APPROVAL;
614: X_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
616: p_count => x_msg_count,

Line 614: X_return_status := FND_API.G_RET_STS_ERROR;

610: p_data => x_msg_data);
611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO INITIATE_OPER_APPROVAL;
614: X_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
616: p_count => x_msg_count,
617: p_data => X_msg_data);
618: WHEN OTHERS THEN

Line 615: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO INITIATE_OPER_APPROVAL;
614: X_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
616: p_count => x_msg_count,
617: p_data => X_msg_data);
618: WHEN OTHERS THEN
619: ROLLBACK TO INITIATE_OPER_APPROVAL;

Line 620: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

616: p_count => x_msg_count,
617: p_data => X_msg_data);
618: WHEN OTHERS THEN
619: ROLLBACK TO INITIATE_OPER_APPROVAL;
620: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
624: p_procedure_name => 'INITIATE_OPER_APPROVAL',

Line 627: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

623: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
624: p_procedure_name => 'INITIATE_OPER_APPROVAL',
625: p_error_text => SUBSTR(SQLERRM,1,240));
626: END IF;
627: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
628: p_count => x_msg_count,
629: p_data => X_msg_data);
630: END;
631:

Line 638: p_default IN VARCHAR2 := FND_API.G_FALSE,

634: p_api_version IN NUMBER:= 1.0,
635: p_init_msg_list IN VARCHAR2,
636: p_commit IN VARCHAR2,
637: p_validation_level IN NUMBER,
638: p_default IN VARCHAR2 := FND_API.G_FALSE,
639: p_module_type IN VARCHAR2,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,

Line 668: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

664: l_msg_count NUMBER;
665: l_msg_data VARCHAR2(2000);
666: l_activity_id NUMBER:=p_source_route_id;
667: l_Status VARCHAR2(1);
668: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
669: l_object_Version_number NUMBER:=nvl(p_object_Version_number,0);
670: l_upd_status VARCHAR2(50);
671: l_rev_status VARCHAR2(50);
672: l_new_status VARCHAR2(50);

Line 693: IF FND_API.to_boolean(l_init_msg_list) THEN

689: END IF;
690:
691: -- Standard call to check for call compatibility.
692:
693: IF FND_API.to_boolean(l_init_msg_list) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696:
697: -- Initialize API return status to success

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: END IF;
696:
697: -- Initialize API return status to success
698:
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: -- Set default for CMRO and PM modes.
702: IF (G_PM_INSTALL = 'Y') THEN
703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');

Line 720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

716: x_msg_data => x_msg_data
717: );
718:
719: -- If any severe error occurs, then, abort API.
720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
721: RAISE FND_API.G_EXC_ERROR;
722: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;

Line 721: RAISE FND_API.G_EXC_ERROR;

717: );
718:
719: -- If any severe error occurs, then, abort API.
720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
721: RAISE FND_API.G_EXC_ERROR;
722: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725: -- added code : prithwi : 29.9.2003

Line 722: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

718:
719: -- If any severe error occurs, then, abort API.
720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
721: RAISE FND_API.G_EXC_ERROR;
722: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725: -- added code : prithwi : 29.9.2003
726: OPEN get_route_det(p_source_route_id);

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: -- If any severe error occurs, then, abort API.
720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
721: RAISE FND_API.G_EXC_ERROR;
722: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725: -- added code : prithwi : 29.9.2003
726: OPEN get_route_det(p_source_route_id);
727: FETCH get_route_det INTO l_route_rec;

Line 744: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

740: x_msg_count =>l_msg_count,
741: x_msg_data =>l_msg_data);
742: END IF ;
743:
744: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
745: THEN
746: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
747: FND_MSG_PUB.ADD;
748: END IF;

Line 750: IF p_source_route_id is null or p_source_route_id=FND_API.G_MISS_NUM

746: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
747: FND_MSG_PUB.ADD;
748: END IF;
749:
750: IF p_source_route_id is null or p_source_route_id=FND_API.G_MISS_NUM
751: THEN
752: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJECT_ID_NULL');
753: FND_MSG_PUB.ADD;
754: ELSE

Line 770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

766: x_msg_data =>l_msg,
767: x_return_status =>l_return_Status
768: );
769:
770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
771: THEN
772: FND_MESSAGE.SET_NAME('AHL',l_msg);
773: FND_MESSAGE.set_token('FIELD',l_start_Date);
774: FND_MSG_PUB.ADD;

Line 798: IF l_route_rec.time_span is null or l_route_rec.time_span =FND_API.G_MISS_NUM

794:
795: --bachandr Enigma Phase I changes -- start
796: -- When the workflow type is approve , check if time span is entered as it is mandatory for
797: -- approval flow. If not throw an error.
798: IF l_route_rec.time_span is null or l_route_rec.time_span =FND_API.G_MISS_NUM
799: THEN
800: FND_MESSAGE.SET_NAME('AHL','AHL_RM_TIME_SPAN_NULL');
801: FND_MSG_PUB.ADD;
802: END IF;

Line 824: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE

820: --bachandr Enigma Phase I changes -- end
821:
822: IF (
823: (l_route_rec.END_DATE_ACTIVE IS NOT NULL OR
824: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE
825: )
826: AND
827: l_route_rec.revision_status_code = 'TERMINATED'
828: )

Line 836: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE

832: FND_MSG_PUB.ADD;
833: ELSIF
834: (
835: (l_route_rec.END_DATE_ACTIVE IS NOT NULL OR
836: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE
837: )
838: AND
839: l_route_rec.revision_status_code = 'COMPLETE'
840: )

Line 897: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

893:
894: IF l_msg_count > 0
895: THEN
896: X_msg_count := l_msg_count;
897: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: IF l_ACTIVE='Y'

Line 898: RAISE FND_API.G_EXC_ERROR;

894: IF l_msg_count > 0
895: THEN
896: X_msg_count := l_msg_count;
897: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900:
901: IF l_ACTIVE='Y'
902: THEN

Line 959: p_commit =>FND_API.G_FALSE,

955: COMPLETE_ROUTE_REVISION
956: (
957: p_api_version =>p_api_version,
958: p_init_msg_list =>p_init_msg_list,
959: p_commit =>FND_API.G_FALSE,
960: p_validation_level =>p_validation_level ,
961: p_default =>p_default ,
962: p_module_type =>p_module_type,
963: x_return_status =>l_return_status,

Line 982: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

978:
979: IF l_msg_count > 0
980: THEN
981: X_msg_count := l_msg_count;
982: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986:

Line 983: RAISE FND_API.G_EXC_ERROR;

979: IF l_msg_count > 0
980: THEN
981: X_msg_count := l_msg_count;
982: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986:
987: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 987: IF FND_API.TO_BOOLEAN(p_commit) THEN

983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986:
987: IF FND_API.TO_BOOLEAN(p_commit) THEN
988: COMMIT;
989: END IF;
990:
991: EXCEPTION

Line 992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

988: COMMIT;
989: END IF;
990:
991: EXCEPTION
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
994: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
996: p_count => x_msg_count,

Line 994: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990:
991: EXCEPTION
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
994: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:

Line 995: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

991: EXCEPTION
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
994: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:
999: WHEN FND_API.G_EXC_ERROR THEN

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
1001: X_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1003: p_count => x_msg_count,

Line 1001: X_return_status := FND_API.G_RET_STS_ERROR;

997: p_data => x_msg_data);
998:
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
1001: X_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => X_msg_data);
1005: WHEN OTHERS THEN

Line 1002: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

998:
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
1001: X_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => X_msg_data);
1005: WHEN OTHERS THEN
1006: ROLLBACK TO INITIATE_ROUTE_APPROVAL;

Line 1007: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: p_count => x_msg_count,
1004: p_data => X_msg_data);
1005: WHEN OTHERS THEN
1006: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
1007: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_ROUTE_PUB',
1011: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',

Line 1014: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_ROUTE_PUB',
1011: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1012: p_error_text => SUBSTR(SQLERRM,1,240));
1013: END IF;
1014: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1015: p_count => x_msg_count,
1016: p_data => X_msg_data);
1017: END INITIATE_ROUTE_APPROVAL;
1018:

Line 1025: p_default IN VARCHAR2 := FND_API.G_FALSE,

1021: p_api_version IN NUMBER:= 1.0,
1022: p_init_msg_list IN VARCHAR2,
1023: p_commit IN VARCHAR2,
1024: p_validation_level IN NUMBER,
1025: p_default IN VARCHAR2 := FND_API.G_FALSE,
1026: p_module_type IN VARCHAR2,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: x_msg_count OUT NOCOPY NUMBER,
1029: x_msg_data OUT NOCOPY VARCHAR2,

Line 1063: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

1059: l_num_rec NUMBER;
1060: l_msg_count NUMBER;
1061: l_msg_data VARCHAR2(2000);
1062: l_return_status VARCHAR2(1);
1063: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1064: l_fr_date DATE:=SYSDATE;
1065: l_to_Date DATE:=SYSDATE;
1066: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1067: l_curr_status VARCHAR2(30);

Line 1066: l_commit VARCHAR2(10):=FND_API.G_TRUE;

1062: l_return_status VARCHAR2(1);
1063: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1064: l_fr_date DATE:=SYSDATE;
1065: l_to_Date DATE:=SYSDATE;
1066: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1067: l_curr_status VARCHAR2(30);
1068:
1069:
1070: l_object VARCHAR2(30):='RM';

Line 1121: IF p_route_id is not null or p_route_id<>fnd_api.g_miss_num

1117: END IF;
1118: l_check_flag3:='N';
1119: END IF;
1120:
1121: IF p_route_id is not null or p_route_id<>fnd_api.g_miss_num
1122: THEN
1123: IF G_DEBUG='Y'
1124: THEN
1125: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);

Line 1391: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1387:
1388: IF l_msg_count > 0
1389: THEN
1390: X_msg_count := l_msg_count;
1391: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:
1395: IF G_DEBUG='Y' THEN

Line 1392: RAISE FND_API.G_EXC_ERROR;

1388: IF l_msg_count > 0
1389: THEN
1390: X_msg_count := l_msg_count;
1391: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:
1395: IF G_DEBUG='Y' THEN
1396: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

Line 1399: IF FND_API.TO_BOOLEAN(p_commit) THEN

1395: IF G_DEBUG='Y' THEN
1396: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1397: END IF;
1398:
1399: IF FND_API.TO_BOOLEAN(p_commit) THEN
1400: COMMIT;
1401: END IF;
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1399: IF FND_API.TO_BOOLEAN(p_commit) THEN
1400: COMMIT;
1401: END IF;
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1405: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1407: p_count => x_msg_count,

Line 1405: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1401: END IF;
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1405: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data);
1409:

Line 1406: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1402: EXCEPTION
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1405: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data);
1409:
1410: WHEN FND_API.G_EXC_ERROR THEN

Line 1410: WHEN FND_API.G_EXC_ERROR THEN

1406: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data);
1409:
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: ROLLBACK TO COMPLETE_MR_REVISION;
1412: X_return_status := FND_API.G_RET_STS_ERROR;
1413: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1414: p_count => x_msg_count,

Line 1412: X_return_status := FND_API.G_RET_STS_ERROR;

1408: p_data => x_msg_data);
1409:
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: ROLLBACK TO COMPLETE_MR_REVISION;
1412: X_return_status := FND_API.G_RET_STS_ERROR;
1413: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1414: p_count => x_msg_count,
1415: p_data => X_msg_data);
1416: WHEN OTHERS THEN

Line 1413: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1409:
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: ROLLBACK TO COMPLETE_MR_REVISION;
1412: X_return_status := FND_API.G_RET_STS_ERROR;
1413: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1414: p_count => x_msg_count,
1415: p_data => X_msg_data);
1416: WHEN OTHERS THEN
1417: ROLLBACK TO COMPLETE_MR_REVISION;

Line 1418: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1414: p_count => x_msg_count,
1415: p_data => X_msg_data);
1416: WHEN OTHERS THEN
1417: ROLLBACK TO COMPLETE_MR_REVISION;
1418: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1420: THEN
1421: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1422: p_procedure_name =>'COMPLETE_ROUTE_REVISION',

Line 1425: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1421: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1422: p_procedure_name =>'COMPLETE_ROUTE_REVISION',
1423: p_error_text =>SUBSTR(SQLERRM,1,240));
1424: END IF;
1425: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1426: p_count => x_msg_count,
1427: p_data => X_msg_data);
1428:
1429: END;

Line 1437: p_default IN VARCHAR2 := FND_API.G_FALSE,

1433: p_api_version IN NUMBER:= 1.0,
1434: p_init_msg_list IN VARCHAR2,
1435: p_commit IN VARCHAR2,
1436: p_validation_level IN NUMBER,
1437: p_default IN VARCHAR2 := FND_API.G_FALSE,
1438: p_module_type IN VARCHAR2,
1439: x_return_status OUT NOCOPY VARCHAR2,
1440: x_msg_count OUT NOCOPY NUMBER,
1441: x_msg_data OUT NOCOPY VARCHAR2,

Line 1483: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

1479: l_num_rec NUMBER;
1480: l_msg_count NUMBER;
1481: l_msg_data VARCHAR2(2000);
1482: l_return_status VARCHAR2(1);
1483: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1484: l_fr_date DATE:=SYSDATE;
1485: l_to_Date DATE:=SYSDATE;
1486: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1487: l_active VARCHAR2(50);

Line 1486: l_commit VARCHAR2(10):=FND_API.G_TRUE;

1482: l_return_status VARCHAR2(1);
1483: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1484: l_fr_date DATE:=SYSDATE;
1485: l_to_Date DATE:=SYSDATE;
1486: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1487: l_active VARCHAR2(50);
1488: l_process_name VARCHAR2(50);
1489: l_item_type VARCHAR2(50);
1490:

Line 1520: IF p_operation_id is not null or p_operation_id<>fnd_api.g_miss_num

1516: AHL_DEBUG_PUB.debug( 'Complete_operation_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1517: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1518: END IF;
1519:
1520: IF p_operation_id is not null or p_operation_id<>fnd_api.g_miss_num
1521: THEN
1522: OPEN GetOperationDet(p_operation_id);
1523: FETCH GetOperationDet INTO l_oper_rec;
1524:

Line 1662: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1658:
1659: IF l_msg_count > 0
1660: THEN
1661: X_msg_count := l_msg_count;
1662: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:
1666: IF G_DEBUG='Y' THEN

Line 1663: RAISE FND_API.G_EXC_ERROR;

1659: IF l_msg_count > 0
1660: THEN
1661: X_msg_count := l_msg_count;
1662: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:
1666: IF G_DEBUG='Y' THEN
1667: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

Line 1670: IF FND_API.TO_BOOLEAN(p_commit) THEN

1666: IF G_DEBUG='Y' THEN
1667: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1668: END IF;
1669:
1670: IF FND_API.TO_BOOLEAN(p_commit) THEN
1671: COMMIT;
1672: END IF;
1673: EXCEPTION
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1670: IF FND_API.TO_BOOLEAN(p_commit) THEN
1671: COMMIT;
1672: END IF;
1673: EXCEPTION
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1675: ROLLBACK TO COMPLETE_OPER_REVISION;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1678: p_count => x_msg_count,

Line 1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1672: END IF;
1673: EXCEPTION
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1675: ROLLBACK TO COMPLETE_OPER_REVISION;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680:

Line 1677: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1673: EXCEPTION
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1675: ROLLBACK TO COMPLETE_OPER_REVISION;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680:
1681: WHEN FND_API.G_EXC_ERROR THEN

Line 1681: WHEN FND_API.G_EXC_ERROR THEN

1677: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680:
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: ROLLBACK TO COMPLETE_OPER_REVISION;
1683: X_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1685: p_count => x_msg_count,

Line 1683: X_return_status := FND_API.G_RET_STS_ERROR;

1679: p_data => x_msg_data);
1680:
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: ROLLBACK TO COMPLETE_OPER_REVISION;
1683: X_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1685: p_count => x_msg_count,
1686: p_data => X_msg_data);
1687: WHEN OTHERS THEN

Line 1684: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1680:
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: ROLLBACK TO COMPLETE_OPER_REVISION;
1683: X_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1685: p_count => x_msg_count,
1686: p_data => X_msg_data);
1687: WHEN OTHERS THEN
1688: ROLLBACK TO COMPLETE_OPER_REVISION;

Line 1689: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1685: p_count => x_msg_count,
1686: p_data => X_msg_data);
1687: WHEN OTHERS THEN
1688: ROLLBACK TO COMPLETE_OPER_REVISION;
1689: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1691: THEN
1692: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1693: p_procedure_name =>'COMPLETE_OPER_REVISION',

Line 1696: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1692: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1693: p_procedure_name =>'COMPLETE_OPER_REVISION',
1694: p_error_text =>SUBSTR(SQLERRM,1,240));
1695: END IF;
1696: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1697: p_count => x_msg_count,
1698: p_data => X_msg_data);
1699:
1700: END;