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 313: IF FND_API.to_boolean(l_init_msg_list) THEN

309: END IF;
310:
311: -- Standard call to check for call compatibility.
312:
313: IF FND_API.to_boolean(l_init_msg_list) THEN
314: FND_MSG_PUB.initialize;
315: END IF;
316:
317: -- Initialize API return status to success

Line 319: x_return_status :=FND_API.G_RET_STS_SUCCESS;

315: END IF;
316:
317: -- Initialize API return status to success
318:
319: x_return_status :=FND_API.G_RET_STS_SUCCESS;
320:
321: -- Get approval process setup.
322: IF (G_PM_INSTALL = 'Y') THEN
323: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');

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

336: x_return_status=>l_return_status,
337: x_msg_count =>l_msg_count,
338: x_msg_data =>l_msg_data);
339: END IF ;
340: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
341: THEN
342: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
343: FND_MSG_PUB.ADD;
344: END IF;

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

342: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
343: FND_MSG_PUB.ADD;
344: END IF;
345:
346: IF p_source_operation_id is null or p_source_operation_id=FND_API.G_MISS_NUM
347: THEN
348: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJECT_ID_NULL');
349: FND_MSG_PUB.ADD;
350: ELSE

Line 377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

373: x_msg_data =>l_msg,
374: x_return_status =>l_return_Status
375: );
376:
377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
378: THEN
379: FND_MESSAGE.SET_NAME('AHL',l_msg);
380: FND_MESSAGE.set_token('FIELD',l_start_Date);
381: FND_MSG_PUB.ADD;

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

414:
415: ELSIF
416: (
417: ( l_oper_rec.END_DATE_ACTIVE IS NOT NULL OR
418: l_oper_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE )
419: AND
420: l_oper_rec.revision_status_code = 'COMPLETE'
421: )
422: THEN

Line 458: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

454:
455: IF l_msg_count > 0
456: THEN
457: X_msg_count := l_msg_count;
458: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:
462: IF l_ACTIVE='Y'

Line 459: RAISE FND_API.G_EXC_ERROR;

455: IF l_msg_count > 0
456: THEN
457: X_msg_count := l_msg_count;
458: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:
462: IF l_ACTIVE='Y'
463: THEN

Line 516: p_commit =>FND_API.G_FALSE,

512: COMPLETE_OPER_REVISION
513: (
514: p_api_version =>p_api_version,
515: p_init_msg_list =>p_init_msg_list,
516: p_commit =>FND_API.G_FALSE,
517: p_validation_level =>p_validation_level ,
518: p_default =>p_default ,
519: p_module_type =>p_module_type,
520: x_return_status =>l_return_status,

Line 541: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

537:
538: IF l_msg_count > 0
539: THEN
540: X_msg_count := l_msg_count;
541: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 542: RAISE FND_API.G_EXC_ERROR;

538: IF l_msg_count > 0
539: THEN
540: X_msg_count := l_msg_count;
541: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(p_commit) THEN
546: COMMIT;

Line 545: IF FND_API.TO_BOOLEAN(p_commit) THEN

541: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(p_commit) THEN
546: COMMIT;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

545: IF FND_API.TO_BOOLEAN(p_commit) THEN
546: COMMIT;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: ROLLBACK TO INITIATE_OPER_APPROVAL;
551: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
553: p_count => x_msg_count,

Line 551: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: ROLLBACK TO INITIATE_OPER_APPROVAL;
551: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data);
555:

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

548: EXCEPTION
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: ROLLBACK TO INITIATE_OPER_APPROVAL;
551: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data);
555:
556: WHEN FND_API.G_EXC_ERROR THEN

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data);
555:
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO INITIATE_OPER_APPROVAL;
558: X_return_status := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
560: p_count => x_msg_count,

Line 558: X_return_status := FND_API.G_RET_STS_ERROR;

554: p_data => x_msg_data);
555:
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO INITIATE_OPER_APPROVAL;
558: X_return_status := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => X_msg_data);
562: WHEN OTHERS THEN

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

555:
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO INITIATE_OPER_APPROVAL;
558: X_return_status := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => X_msg_data);
562: WHEN OTHERS THEN
563: ROLLBACK TO INITIATE_OPER_APPROVAL;

Line 564: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: p_count => x_msg_count,
561: p_data => X_msg_data);
562: WHEN OTHERS THEN
563: ROLLBACK TO INITIATE_OPER_APPROVAL;
564: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
568: p_procedure_name => 'INITIATE_OPER_APPROVAL',

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

567: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
568: p_procedure_name => 'INITIATE_OPER_APPROVAL',
569: p_error_text => SUBSTR(SQLERRM,1,240));
570: END IF;
571: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => X_msg_data);
574: END;
575:

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

578: p_api_version IN NUMBER:= 1.0,
579: p_init_msg_list IN VARCHAR2,
580: p_commit IN VARCHAR2,
581: p_validation_level IN NUMBER,
582: p_default IN VARCHAR2 := FND_API.G_FALSE,
583: p_module_type IN VARCHAR2,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,

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

608: l_msg_count NUMBER;
609: l_msg_data VARCHAR2(2000);
610: l_activity_id NUMBER:=p_source_route_id;
611: l_Status VARCHAR2(1);
612: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
613: l_object_Version_number NUMBER:=nvl(p_object_Version_number,0);
614: l_upd_status VARCHAR2(50);
615: l_rev_status VARCHAR2(50);
616: l_new_status VARCHAR2(50);

Line 636: IF FND_API.to_boolean(l_init_msg_list) THEN

632: END IF;
633:
634: -- Standard call to check for call compatibility.
635:
636: IF FND_API.to_boolean(l_init_msg_list) THEN
637: FND_MSG_PUB.initialize;
638: END IF;
639:
640: -- Initialize API return status to success

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: END IF;
639:
640: -- Initialize API return status to success
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: -- Set default for CMRO and PM modes.
645: IF (G_PM_INSTALL = 'Y') THEN
646: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');

Line 663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

659: x_msg_data => x_msg_data
660: );
661:
662: -- If any severe error occurs, then, abort API.
663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;

Line 664: RAISE FND_API.G_EXC_ERROR;

660: );
661:
662: -- If any severe error occurs, then, abort API.
663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668: -- added code : prithwi : 29.9.2003

Line 665: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

661:
662: -- If any severe error occurs, then, abort API.
663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668: -- added code : prithwi : 29.9.2003
669: OPEN get_route_det(p_source_route_id);

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: -- If any severe error occurs, then, abort API.
663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668: -- added code : prithwi : 29.9.2003
669: OPEN get_route_det(p_source_route_id);
670: FETCH get_route_det INTO l_route_rec;

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

683: x_msg_count =>l_msg_count,
684: x_msg_data =>l_msg_data);
685: END IF ;
686:
687: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
688: THEN
689: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
690: FND_MSG_PUB.ADD;
691: END IF;

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

689: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJ_VERSION_NULL');
690: FND_MSG_PUB.ADD;
691: END IF;
692:
693: IF p_source_route_id is null or p_source_route_id=FND_API.G_MISS_NUM
694: THEN
695: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OBJECT_ID_NULL');
696: FND_MSG_PUB.ADD;
697: ELSE

Line 713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

709: x_msg_data =>l_msg,
710: x_return_status =>l_return_Status
711: );
712:
713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
714: THEN
715: FND_MESSAGE.SET_NAME('AHL',l_msg);
716: FND_MESSAGE.set_token('FIELD',l_start_Date);
717: FND_MSG_PUB.ADD;

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

737:
738: --bachandr Enigma Phase I changes -- start
739: -- When the workflow type is approve , check if time span is entered as it is mandatory for
740: -- approval flow. If not throw an error.
741: IF l_route_rec.time_span is null or l_route_rec.time_span =FND_API.G_MISS_NUM
742: THEN
743: FND_MESSAGE.SET_NAME('AHL','AHL_RM_TIME_SPAN_NULL');
744: FND_MSG_PUB.ADD;
745: END IF;

Line 766: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE

762: --bachandr Enigma Phase I changes -- end
763:
764: IF (
765: (l_route_rec.END_DATE_ACTIVE IS NOT NULL OR
766: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE
767: )
768: AND
769: l_route_rec.revision_status_code = 'TERMINATED'
770: )

Line 778: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE

774: FND_MSG_PUB.ADD;
775: ELSIF
776: (
777: (l_route_rec.END_DATE_ACTIVE IS NOT NULL OR
778: l_route_rec.END_DATE_ACTIVE<>FND_API.G_MISS_DATE
779: )
780: AND
781: l_route_rec.revision_status_code = 'COMPLETE'
782: )

Line 839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

835:
836: IF l_msg_count > 0
837: THEN
838: X_msg_count := l_msg_count;
839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:
843: IF l_ACTIVE='Y'

Line 840: RAISE FND_API.G_EXC_ERROR;

836: IF l_msg_count > 0
837: THEN
838: X_msg_count := l_msg_count;
839: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:
843: IF l_ACTIVE='Y'
844: THEN

Line 901: p_commit =>FND_API.G_FALSE,

897: COMPLETE_ROUTE_REVISION
898: (
899: p_api_version =>p_api_version,
900: p_init_msg_list =>p_init_msg_list,
901: p_commit =>FND_API.G_FALSE,
902: p_validation_level =>p_validation_level ,
903: p_default =>p_default ,
904: p_module_type =>p_module_type,
905: x_return_status =>l_return_status,

Line 924: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

920:
921: IF l_msg_count > 0
922: THEN
923: X_msg_count := l_msg_count;
924: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928:

Line 925: RAISE FND_API.G_EXC_ERROR;

921: IF l_msg_count > 0
922: THEN
923: X_msg_count := l_msg_count;
924: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928:
929: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 929: IF FND_API.TO_BOOLEAN(p_commit) THEN

925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928:
929: IF FND_API.TO_BOOLEAN(p_commit) THEN
930: COMMIT;
931: END IF;
932:
933: EXCEPTION

Line 934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

930: COMMIT;
931: END IF;
932:
933: EXCEPTION
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
936: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
938: p_count => x_msg_count,

Line 936: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

932:
933: EXCEPTION
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
936: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
938: p_count => x_msg_count,
939: p_data => x_msg_data);
940:

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

933: EXCEPTION
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
936: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
938: p_count => x_msg_count,
939: p_data => x_msg_data);
940:
941: WHEN FND_API.G_EXC_ERROR THEN

Line 941: WHEN FND_API.G_EXC_ERROR THEN

937: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
938: p_count => x_msg_count,
939: p_data => x_msg_data);
940:
941: WHEN FND_API.G_EXC_ERROR THEN
942: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
943: X_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
945: p_count => x_msg_count,

Line 943: X_return_status := FND_API.G_RET_STS_ERROR;

939: p_data => x_msg_data);
940:
941: WHEN FND_API.G_EXC_ERROR THEN
942: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
943: X_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => X_msg_data);
947: WHEN OTHERS THEN

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

940:
941: WHEN FND_API.G_EXC_ERROR THEN
942: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
943: X_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => X_msg_data);
947: WHEN OTHERS THEN
948: ROLLBACK TO INITIATE_ROUTE_APPROVAL;

Line 949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

945: p_count => x_msg_count,
946: p_data => X_msg_data);
947: WHEN OTHERS THEN
948: ROLLBACK TO INITIATE_ROUTE_APPROVAL;
949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_ROUTE_PUB',
953: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',

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

952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_ROUTE_PUB',
953: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
954: p_error_text => SUBSTR(SQLERRM,1,240));
955: END IF;
956: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => X_msg_data);
959: END INITIATE_ROUTE_APPROVAL;
960:

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

963: p_api_version IN NUMBER:= 1.0,
964: p_init_msg_list IN VARCHAR2,
965: p_commit IN VARCHAR2,
966: p_validation_level IN NUMBER,
967: p_default IN VARCHAR2 := FND_API.G_FALSE,
968: p_module_type IN VARCHAR2,
969: x_return_status OUT NOCOPY VARCHAR2,
970: x_msg_count OUT NOCOPY NUMBER,
971: x_msg_data OUT NOCOPY VARCHAR2,

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

1001: l_num_rec NUMBER;
1002: l_msg_count NUMBER;
1003: l_msg_data VARCHAR2(2000);
1004: l_return_status VARCHAR2(1);
1005: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1006: l_fr_date DATE:=SYSDATE;
1007: l_to_Date DATE:=SYSDATE;
1008: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1009: l_curr_status VARCHAR2(30);

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

1004: l_return_status VARCHAR2(1);
1005: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1006: l_fr_date DATE:=SYSDATE;
1007: l_to_Date DATE:=SYSDATE;
1008: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1009: l_curr_status VARCHAR2(30);
1010:
1011:
1012: l_object VARCHAR2(30):='RM';

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

1059: END IF;
1060: l_check_flag3:='N';
1061: END IF;
1062:
1063: IF p_route_id is not null or p_route_id<>fnd_api.g_miss_num
1064: THEN
1065: IF G_DEBUG='Y'
1066: THEN
1067: AHL_DEBUG_PUB.debug( 'Inside CompleteRouteRevision:p_route_id'||p_route_id);

Line 1331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1327:
1328: IF l_msg_count > 0
1329: THEN
1330: X_msg_count := l_msg_count;
1331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335: IF G_DEBUG='Y' THEN

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328: IF l_msg_count > 0
1329: THEN
1330: X_msg_count := l_msg_count;
1331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335: IF G_DEBUG='Y' THEN
1336: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

Line 1339: IF FND_API.TO_BOOLEAN(p_commit) THEN

1335: IF G_DEBUG='Y' THEN
1336: AHL_DEBUG_PUB.debug( 'Before commit Complete_route_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1337: END IF;
1338:
1339: IF FND_API.TO_BOOLEAN(p_commit) THEN
1340: COMMIT;
1341: END IF;
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1339: IF FND_API.TO_BOOLEAN(p_commit) THEN
1340: COMMIT;
1341: END IF;
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1347: p_count => x_msg_count,

Line 1345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341: END IF;
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1347: p_count => x_msg_count,
1348: p_data => x_msg_data);
1349:

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

1342: EXCEPTION
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: ROLLBACK TO COMPLETE_ROUTE_REVISION;
1345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1347: p_count => x_msg_count,
1348: p_data => x_msg_data);
1349:
1350: WHEN FND_API.G_EXC_ERROR THEN

Line 1350: WHEN FND_API.G_EXC_ERROR THEN

1346: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1347: p_count => x_msg_count,
1348: p_data => x_msg_data);
1349:
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO COMPLETE_MR_REVISION;
1352: X_return_status := FND_API.G_RET_STS_ERROR;
1353: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1354: p_count => x_msg_count,

Line 1352: X_return_status := FND_API.G_RET_STS_ERROR;

1348: p_data => x_msg_data);
1349:
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO COMPLETE_MR_REVISION;
1352: X_return_status := FND_API.G_RET_STS_ERROR;
1353: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => X_msg_data);
1356: WHEN OTHERS THEN

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

1349:
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO COMPLETE_MR_REVISION;
1352: X_return_status := FND_API.G_RET_STS_ERROR;
1353: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => X_msg_data);
1356: WHEN OTHERS THEN
1357: ROLLBACK TO COMPLETE_MR_REVISION;

Line 1358: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354: p_count => x_msg_count,
1355: p_data => X_msg_data);
1356: WHEN OTHERS THEN
1357: ROLLBACK TO COMPLETE_MR_REVISION;
1358: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1360: THEN
1361: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1362: p_procedure_name =>'COMPLETE_ROUTE_REVISION',

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

1361: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1362: p_procedure_name =>'COMPLETE_ROUTE_REVISION',
1363: p_error_text =>SUBSTR(SQLERRM,1,240));
1364: END IF;
1365: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1366: p_count => x_msg_count,
1367: p_data => X_msg_data);
1368:
1369: END;

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

1373: p_api_version IN NUMBER:= 1.0,
1374: p_init_msg_list IN VARCHAR2,
1375: p_commit IN VARCHAR2,
1376: p_validation_level IN NUMBER,
1377: p_default IN VARCHAR2 := FND_API.G_FALSE,
1378: p_module_type IN VARCHAR2,
1379: x_return_status OUT NOCOPY VARCHAR2,
1380: x_msg_count OUT NOCOPY NUMBER,
1381: x_msg_data OUT NOCOPY VARCHAR2,

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

1419: l_num_rec NUMBER;
1420: l_msg_count NUMBER;
1421: l_msg_data VARCHAR2(2000);
1422: l_return_status VARCHAR2(1);
1423: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1424: l_fr_date DATE:=SYSDATE;
1425: l_to_Date DATE:=SYSDATE;
1426: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1427: l_active VARCHAR2(50);

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

1422: l_return_status VARCHAR2(1);
1423: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1424: l_fr_date DATE:=SYSDATE;
1425: l_to_Date DATE:=SYSDATE;
1426: l_commit VARCHAR2(10):=FND_API.G_TRUE;
1427: l_active VARCHAR2(50);
1428: l_process_name VARCHAR2(50);
1429: l_item_type VARCHAR2(50);
1430:

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

1456: AHL_DEBUG_PUB.debug( 'Complete_operation_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1457: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status2----->'||L_status,'+DEBUG_REVISION+');
1458: END IF;
1459:
1460: IF p_operation_id is not null or p_operation_id<>fnd_api.g_miss_num
1461: THEN
1462: OPEN GetOperationDet(p_operation_id);
1463: FETCH GetOperationDet INTO l_oper_rec;
1464:

Line 1602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1598:
1599: IF l_msg_count > 0
1600: THEN
1601: X_msg_count := l_msg_count;
1602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:
1606: IF G_DEBUG='Y' THEN

Line 1603: RAISE FND_API.G_EXC_ERROR;

1599: IF l_msg_count > 0
1600: THEN
1601: X_msg_count := l_msg_count;
1602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:
1606: IF G_DEBUG='Y' THEN
1607: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');

Line 1610: IF FND_API.TO_BOOLEAN(p_commit) THEN

1606: IF G_DEBUG='Y' THEN
1607: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1608: END IF;
1609:
1610: IF FND_API.TO_BOOLEAN(p_commit) THEN
1611: COMMIT;
1612: END IF;
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1610: IF FND_API.TO_BOOLEAN(p_commit) THEN
1611: COMMIT;
1612: END IF;
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: ROLLBACK TO COMPLETE_OPER_REVISION;
1616: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1618: p_count => x_msg_count,

Line 1616: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1612: END IF;
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: ROLLBACK TO COMPLETE_OPER_REVISION;
1616: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:

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

1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: ROLLBACK TO COMPLETE_OPER_REVISION;
1616: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: WHEN FND_API.G_EXC_ERROR THEN

Line 1621: WHEN FND_API.G_EXC_ERROR THEN

1617: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: WHEN FND_API.G_EXC_ERROR THEN
1622: ROLLBACK TO COMPLETE_OPER_REVISION;
1623: X_return_status := FND_API.G_RET_STS_ERROR;
1624: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1625: p_count => x_msg_count,

Line 1623: X_return_status := FND_API.G_RET_STS_ERROR;

1619: p_data => x_msg_data);
1620:
1621: WHEN FND_API.G_EXC_ERROR THEN
1622: ROLLBACK TO COMPLETE_OPER_REVISION;
1623: X_return_status := FND_API.G_RET_STS_ERROR;
1624: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1625: p_count => x_msg_count,
1626: p_data => X_msg_data);
1627: WHEN OTHERS THEN

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

1620:
1621: WHEN FND_API.G_EXC_ERROR THEN
1622: ROLLBACK TO COMPLETE_OPER_REVISION;
1623: X_return_status := FND_API.G_RET_STS_ERROR;
1624: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1625: p_count => x_msg_count,
1626: p_data => X_msg_data);
1627: WHEN OTHERS THEN
1628: ROLLBACK TO COMPLETE_OPER_REVISION;

Line 1629: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1625: p_count => x_msg_count,
1626: p_data => X_msg_data);
1627: WHEN OTHERS THEN
1628: ROLLBACK TO COMPLETE_OPER_REVISION;
1629: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1633: p_procedure_name =>'COMPLETE_OPER_REVISION',

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

1632: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1633: p_procedure_name =>'COMPLETE_OPER_REVISION',
1634: p_error_text =>SUBSTR(SQLERRM,1,240));
1635: END IF;
1636: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1637: p_count => x_msg_count,
1638: p_data => X_msg_data);
1639:
1640: END;