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_MSG_PUB

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 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 224: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
228: p_error_text => SUBSTR(SQLERRM,1,240));

Line 226: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

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',
228: p_error_text => SUBSTR(SQLERRM,1,240));
229: END IF;
230: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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 353: FND_MSG_PUB.initialize;

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
357:

Line 380: FND_MSG_PUB.ADD;

376: IF l_route_id IS NOT NULL
377: THEN
378: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_DUR_GT_ROU');
379: FND_MESSAGE.set_token('DURATION',l_op_duration);
380: FND_MSG_PUB.ADD;
381: END IF;
382: -- Bug # 8639648 -- end
383:
384: -- Start work Flow Process

Line 399: FND_MSG_PUB.ADD;

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;
401:
402: IF p_source_operation_id is null or p_source_operation_id=FND_API.G_MISS_NUM
403: THEN

Line 405: FND_MSG_PUB.ADD;

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
407: OPEN get_oper_Det(p_source_operation_id);
408: FETCH get_oper_Det INTO l_oper_Rec;
409: CLOSE get_oper_Det;

Line 420: FND_MSG_PUB.ADD;

416: l_upd_status := 'APPROVAL_PENDING';
417: ELSE
418: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_DRFT');
419: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);
420: FND_MSG_PUB.ADD;
421: END IF;
422:
423: AHL_RM_ROUTE_UTIL.Validate_rt_oper_start_date
424: (

Line 437: FND_MSG_PUB.ADD;

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;
438: IF G_DEBUG='Y' THEN
439: AHL_DEBUG_PUB.debug( 'AHL_rm_util.Validate_rt_oper_start_date','+OPER+');
440: END IF;
441: ELSIF TRUNC(l_oper_rec.START_DATE_ACTIVE)

Line 445: FND_MSG_PUB.ADD;

441: ELSIF TRUNC(l_oper_rec.START_DATE_ACTIVE) 442: THEN
443: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');
444: FND_MESSAGE.set_token('FIELD',TRUNC(sysdate));
445: FND_MSG_PUB.ADD;
446: END IF;
447: ELSIF p_apprvl_type = 'TERMINATE'
448: THEN
449: --bachandr Enigma Phase I changes -- start

Line 458: FND_MSG_PUB.ADD;

454: IF ( l_enig_op_id is not null)
455: THEN
456: --if the operation is from enigma do not allow termination.
457: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_ENIG_TERM');
458: FND_MSG_PUB.ADD;
459:
460: END IF;
461: --bachandr Enigma Phase I changes -- end
462:

Line 469: FND_MSG_PUB.ADD;

465: )
466: THEN
467: -- if the operation is terminated
468: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_INV_TERMT');
469: FND_MSG_PUB.ADD;
470:
471: ELSIF
472: (
473: ( l_oper_rec.END_DATE_ACTIVE IS NOT NULL OR

Line 481: FND_MSG_PUB.ADD;

477: )
478: THEN
479: -- if the operation is coplete and end dated.
480: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_INACTIVE');
481: FND_MSG_PUB.ADD;
482: ELSE
483: -- for all other cases throw all errors;
484: IF l_oper_rec.revision_status_code='COMPLETE' or
485: l_oper_rec.revision_status_code='APPROVAL_TERMINATED'

Line 497: FND_MSG_PUB.ADD;

493:
494: IF l_counter>0
495: THEN
496: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_C_TERM');
497: FND_MSG_PUB.ADD;
498: END IF;
499: ELSE
500: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_COMP');
501: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);

Line 502: FND_MSG_PUB.ADD;

498: END IF;
499: ELSE
500: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_COMP');
501: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);
502: FND_MSG_PUB.ADD;
503: END IF;
504: END IF;
505: END IF;
506:

Line 509: l_msg_count := FND_MSG_PUB.count_msg;

505: END IF;
506:
507: END IF;
508:
509: l_msg_count := FND_MSG_PUB.count_msg;
510:
511: IF l_msg_count > 0
512: THEN
513: X_msg_count := l_msg_count;

Line 529: FND_MSG_PUB.ADD;

525:
526: IF sql%rowcount=0
527: THEN
528: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
529: FND_MSG_PUB.ADD;
530: END IF;
531:
532: Update AHL_OPERATIONS_TL
533: Set APPROVER_NOTE=null

Line 539: FND_MSG_PUB.ADD;

535:
536: IF sql%rowcount=0
537: THEN
538: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
539: FND_MSG_PUB.ADD;
540: END IF;
541:
542: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(
543: P_OBJECT =>l_object,

Line 566: FND_MSG_PUB.ADD;

562:
563: IF sql%rowcount=0
564: THEN
565: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
566: FND_MSG_PUB.ADD;
567: END IF;
568: COMPLETE_OPER_REVISION
569: (
570: p_api_version =>p_api_version,

Line 592: l_msg_count := FND_MSG_PUB.count_msg;

588: END IF;
589: END IF ;
590:
591:
592: l_msg_count := FND_MSG_PUB.count_msg;
593:
594: IF l_msg_count > 0
595: THEN
596: X_msg_count := l_msg_count;

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 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 621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
625: p_error_text => SUBSTR(SQLERRM,1,240));

Line 623: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

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',
625: p_error_text => SUBSTR(SQLERRM,1,240));
626: END IF;
627: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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 694: FND_MSG_PUB.initialize;

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
698:

Line 747: FND_MSG_PUB.ADD;

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;
749:
750: IF p_source_route_id is null or p_source_route_id=FND_API.G_MISS_NUM
751: THEN

Line 753: FND_MSG_PUB.ADD;

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
755: OPEN get_route_det(p_source_route_id);
756: FETCH get_route_det INTO l_route_rec;
757: CLOSE get_route_det;

Line 774: FND_MSG_PUB.ADD;

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;
775: IF G_DEBUG='Y' THEN
776: AHL_DEBUG_PUB.debug('AHL_rm_util.Validate_rt_oper_start_date','+ROUTE+');
777: END IF;
778: ELSIF TRUNC(l_route_rec.START_DATE_ACTIVE)

Line 782: FND_MSG_PUB.ADD;

778: ELSIF TRUNC(l_route_rec.START_DATE_ACTIVE) 779: THEN
780: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');
781: FND_MESSAGE.set_token('FIELD',TRUNC(sysdate));
782: FND_MSG_PUB.ADD;
783: END IF;
784:
785: IF l_route_rec.revision_Status_code = 'DRAFT' or
786: l_route_rec.revision_Status_code='APPROVAL_REJECTED'

Line 792: FND_MSG_PUB.ADD;

788: l_upd_status := 'APPROVAL_PENDING';
789: ELSE
790: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RO_STAT_NOT_DRFT');
791: FND_MESSAGE.set_token('FIELD',l_route_rec.route_no);
792: FND_MSG_PUB.ADD;
793: END IF;
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

Line 801: FND_MSG_PUB.ADD;

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;
803: --bachandr Enigma Phase I changes -- end
804:
805: ELSIF p_apprvl_type = 'TERMINATE'

Line 818: FND_MSG_PUB.ADD;

814: IF ( l_enigma_route_id is not null)
815: THEN
816: --if the route is from enigma do not allow termination.
817: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_ENIG_TERM');
818: FND_MSG_PUB.ADD;
819: END IF;
820: --bachandr Enigma Phase I changes -- end
821:
822: IF (

Line 832: FND_MSG_PUB.ADD;

828: )
829: THEN
830: -- if the Route is TERMINATED
831: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_INV_TERMT');
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

Line 844: FND_MSG_PUB.ADD;

840: )
841: THEN
842: -- if the Route is COMPLETE and End Dated.
843: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_INACTIVE');
844: FND_MSG_PUB.ADD;
845: ELSE
846: -- for all other cases throw all errors
847:
848:

Line 865: FND_MSG_PUB.ADD;

861: trunc(nvl(b.effective_to,sysdate)) >= trunc(sysdate);
862: IF l_counter>0
863: THEN
864: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MR_C_TERM');
865: FND_MSG_PUB.ADD;
866: END IF;
867:
868: IF l_route_rec.revision_status_code ='COMPLETE' or
869: l_route_rec.revision_Status_code='APPROVAL_TERMINATED'

Line 879: FND_MSG_PUB.ADD;

875:
876: IF l_counter>0
877: THEN
878: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_C_TERM');
879: FND_MSG_PUB.ADD;
880: END IF;
881:
882: l_upd_status := 'TERMINATION_PENDING';
883: ELSE

Line 886: FND_MSG_PUB.ADD;

882: l_upd_status := 'TERMINATION_PENDING';
883: ELSE
884: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RO_STAT_NOT_COMP');
885: FND_MESSAGE.set_token('FIELD',l_route_rec.route_no);
886: FND_MSG_PUB.ADD;
887: END IF;
888: END IF;
889: END IF;
890: END IF;

Line 892: l_msg_count := FND_MSG_PUB.count_msg;

888: END IF;
889: END IF;
890: END IF;
891:
892: l_msg_count := FND_MSG_PUB.count_msg;
893:
894: IF l_msg_count > 0
895: THEN
896: X_msg_count := l_msg_count;

Line 912: FND_MSG_PUB.ADD;

908:
909: IF sql%rowcount=0
910: THEN
911: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
912: FND_MSG_PUB.ADD;
913: END IF ;
914:
915: UPDATE AHL_ROUTES_TL
916: SET APPROVER_NOTE=null

Line 922: FND_MSG_PUB.ADD;

918:
919: IF sql%rowcount=0
920: THEN
921: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
922: FND_MSG_PUB.ADD;
923: END IF ;
924:
925:
926: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

Line 951: FND_MSG_PUB.ADD;

947:
948: IF sql%rowcount=0
949: THEN
950: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
951: FND_MSG_PUB.ADD;
952:
953: END IF;
954:
955: COMPLETE_ROUTE_REVISION

Line 977: l_msg_count := FND_MSG_PUB.count_msg;

973: AHL_DEBUG_PUB.debug( 'After CompleteRouteRevision');
974: END IF;
975: END IF ;
976:
977: l_msg_count := FND_MSG_PUB.count_msg;
978:
979: IF l_msg_count > 0
980: THEN
981: X_msg_count := l_msg_count;

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 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 1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1012: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_ROUTE_PUB',

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',
1012: p_error_text => SUBSTR(SQLERRM,1,240));
1013: END IF;
1014: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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 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 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 1419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1423: p_error_text =>SUBSTR(SQLERRM,1,240));

Line 1421: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,

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',
1423: p_error_text =>SUBSTR(SQLERRM,1,240));
1424: END IF;
1425: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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 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 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 1690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1694: p_error_text =>SUBSTR(SQLERRM,1,240));

Line 1692: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,

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',
1694: p_error_text =>SUBSTR(SQLERRM,1,240));
1695: END IF;
1696: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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;