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

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

Line 343: FND_MSG_PUB.ADD;

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;
345:
346: IF p_source_operation_id is null or p_source_operation_id=FND_API.G_MISS_NUM
347: THEN

Line 349: FND_MSG_PUB.ADD;

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
351: OPEN get_oper_Det(p_source_operation_id);
352: FETCH get_oper_Det INTO l_oper_Rec;
353: CLOSE get_oper_Det;

Line 364: FND_MSG_PUB.ADD;

360: l_upd_status := 'APPROVAL_PENDING';
361: ELSE
362: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_DRFT');
363: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);
364: FND_MSG_PUB.ADD;
365: END IF;
366:
367: AHL_RM_ROUTE_UTIL.Validate_rt_oper_start_date
368: (

Line 381: FND_MSG_PUB.ADD;

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;
382: IF G_DEBUG='Y' THEN
383: AHL_DEBUG_PUB.debug( 'AHL_rm_util.Validate_rt_oper_start_date','+OPER+');
384: END IF;
385: ELSIF TRUNC(l_oper_rec.START_DATE_ACTIVE)

Line 389: FND_MSG_PUB.ADD;

385: ELSIF TRUNC(l_oper_rec.START_DATE_ACTIVE) 386: THEN
387: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');
388: FND_MESSAGE.set_token('FIELD',TRUNC(sysdate));
389: FND_MSG_PUB.ADD;
390: END IF;
391: ELSIF p_apprvl_type = 'TERMINATE'
392: THEN
393: --bachandr Enigma Phase I changes -- start

Line 402: FND_MSG_PUB.ADD;

398: IF ( l_enig_op_id is not null)
399: THEN
400: --if the operation is from enigma do not allow termination.
401: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_ENIG_TERM');
402: FND_MSG_PUB.ADD;
403:
404: END IF;
405: --bachandr Enigma Phase I changes -- end
406:

Line 413: FND_MSG_PUB.ADD;

409: )
410: THEN
411: -- if the operation is terminated
412: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_INV_TERMT');
413: FND_MSG_PUB.ADD;
414:
415: ELSIF
416: (
417: ( l_oper_rec.END_DATE_ACTIVE IS NOT NULL OR

Line 425: FND_MSG_PUB.ADD;

421: )
422: THEN
423: -- if the operation is coplete and end dated.
424: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_INACTIVE');
425: FND_MSG_PUB.ADD;
426: ELSE
427: -- for all other cases throw all errors;
428: IF l_oper_rec.revision_status_code='COMPLETE' or
429: l_oper_rec.revision_status_code='APPROVAL_TERMINATED'

Line 441: FND_MSG_PUB.ADD;

437:
438: IF l_counter>0
439: THEN
440: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_C_TERM');
441: FND_MSG_PUB.ADD;
442: END IF;
443: ELSE
444: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_COMP');
445: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);

Line 446: FND_MSG_PUB.ADD;

442: END IF;
443: ELSE
444: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_NOT_COMP');
445: FND_MESSAGE.set_token('FIELD',l_oper_rec.concatenated_Segments,false);
446: FND_MSG_PUB.ADD;
447: END IF;
448: END IF;
449: END IF;
450:

Line 453: l_msg_count := FND_MSG_PUB.count_msg;

449: END IF;
450:
451: END IF;
452:
453: l_msg_count := FND_MSG_PUB.count_msg;
454:
455: IF l_msg_count > 0
456: THEN
457: X_msg_count := l_msg_count;

Line 473: FND_MSG_PUB.ADD;

469:
470: IF sql%rowcount=0
471: THEN
472: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
473: FND_MSG_PUB.ADD;
474: END IF;
475:
476: Update AHL_OPERATIONS_TL
477: Set APPROVER_NOTE=null

Line 483: FND_MSG_PUB.ADD;

479:
480: IF sql%rowcount=0
481: THEN
482: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
483: FND_MSG_PUB.ADD;
484: END IF;
485:
486: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(
487: P_OBJECT =>l_object,

Line 510: FND_MSG_PUB.ADD;

506:
507: IF sql%rowcount=0
508: THEN
509: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
510: FND_MSG_PUB.ADD;
511: END IF;
512: COMPLETE_OPER_REVISION
513: (
514: p_api_version =>p_api_version,

Line 536: l_msg_count := FND_MSG_PUB.count_msg;

532: END IF;
533: END IF ;
534:
535:
536: l_msg_count := FND_MSG_PUB.count_msg;
537:
538: IF l_msg_count > 0
539: THEN
540: X_msg_count := l_msg_count;

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

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

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

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

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

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

Line 690: FND_MSG_PUB.ADD;

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;
692:
693: IF p_source_route_id is null or p_source_route_id=FND_API.G_MISS_NUM
694: THEN

Line 696: FND_MSG_PUB.ADD;

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
698: OPEN get_route_det(p_source_route_id);
699: FETCH get_route_det INTO l_route_rec;
700: CLOSE get_route_det;

Line 717: FND_MSG_PUB.ADD;

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;
718: IF G_DEBUG='Y' THEN
719: AHL_DEBUG_PUB.debug('AHL_rm_util.Validate_rt_oper_start_date','+ROUTE+');
720: END IF;
721: ELSIF TRUNC(l_route_rec.START_DATE_ACTIVE)

Line 725: FND_MSG_PUB.ADD;

721: ELSIF TRUNC(l_route_rec.START_DATE_ACTIVE) 722: THEN
723: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INVALID_ST_DATE');
724: FND_MESSAGE.set_token('FIELD',TRUNC(sysdate));
725: FND_MSG_PUB.ADD;
726: END IF;
727:
728: IF l_route_rec.revision_Status_code = 'DRAFT' or
729: l_route_rec.revision_Status_code='APPROVAL_REJECTED'

Line 735: FND_MSG_PUB.ADD;

731: l_upd_status := 'APPROVAL_PENDING';
732: ELSE
733: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RO_STAT_NOT_DRFT');
734: FND_MESSAGE.set_token('FIELD',l_route_rec.route_no);
735: FND_MSG_PUB.ADD;
736: END IF;
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

Line 744: FND_MSG_PUB.ADD;

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;
746: --bachandr Enigma Phase I changes -- end
747:
748: ELSIF p_apprvl_type = 'TERMINATE'

Line 760: FND_MSG_PUB.ADD;

756: IF ( l_enigma_doc_id is not null)
757: THEN
758: --if the route is from enigma do not allow termination.
759: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_ENIG_TERM');
760: FND_MSG_PUB.ADD;
761: END IF;
762: --bachandr Enigma Phase I changes -- end
763:
764: IF (

Line 774: FND_MSG_PUB.ADD;

770: )
771: THEN
772: -- if the Route is TERMINATED
773: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_INV_TERMT');
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

Line 786: FND_MSG_PUB.ADD;

782: )
783: THEN
784: -- if the Route is COMPLETE and End Dated.
785: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROUTE_INACTIVE');
786: FND_MSG_PUB.ADD;
787: ELSE
788: -- for all other cases throw all errors
789:
790:

Line 807: FND_MSG_PUB.ADD;

803: trunc(nvl(b.effective_to,sysdate)) >= trunc(sysdate);
804: IF l_counter>0
805: THEN
806: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MR_C_TERM');
807: FND_MSG_PUB.ADD;
808: END IF;
809:
810: IF l_route_rec.revision_status_code ='COMPLETE' or
811: l_route_rec.revision_Status_code='APPROVAL_TERMINATED'

Line 821: FND_MSG_PUB.ADD;

817:
818: IF l_counter>0
819: THEN
820: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_C_TERM');
821: FND_MSG_PUB.ADD;
822: END IF;
823:
824: l_upd_status := 'TERMINATION_PENDING';
825: ELSE

Line 828: FND_MSG_PUB.ADD;

824: l_upd_status := 'TERMINATION_PENDING';
825: ELSE
826: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RO_STAT_NOT_COMP');
827: FND_MESSAGE.set_token('FIELD',l_route_rec.route_no);
828: FND_MSG_PUB.ADD;
829: END IF;
830: END IF;
831: END IF;
832: END IF;

Line 834: l_msg_count := FND_MSG_PUB.count_msg;

830: END IF;
831: END IF;
832: END IF;
833:
834: l_msg_count := FND_MSG_PUB.count_msg;
835:
836: IF l_msg_count > 0
837: THEN
838: X_msg_count := l_msg_count;

Line 854: FND_MSG_PUB.ADD;

850:
851: IF sql%rowcount=0
852: THEN
853: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
854: FND_MSG_PUB.ADD;
855: END IF ;
856:
857: UPDATE AHL_ROUTES_TL
858: SET APPROVER_NOTE=null

Line 864: FND_MSG_PUB.ADD;

860:
861: IF sql%rowcount=0
862: THEN
863: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
864: FND_MSG_PUB.ADD;
865: END IF ;
866:
867:
868: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

Line 893: FND_MSG_PUB.ADD;

889:
890: IF sql%rowcount=0
891: THEN
892: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
893: FND_MSG_PUB.ADD;
894:
895: END IF;
896:
897: COMPLETE_ROUTE_REVISION

Line 919: l_msg_count := FND_MSG_PUB.count_msg;

915: AHL_DEBUG_PUB.debug( 'After CompleteRouteRevision');
916: END IF;
917: END IF ;
918:
919: l_msg_count := FND_MSG_PUB.count_msg;
920:
921: IF l_msg_count > 0
922: THEN
923: X_msg_count := l_msg_count;

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

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

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

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

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

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

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

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

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

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

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

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

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;