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_FMP_MR_PUB dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.Initialize;

44: END IF;
45:
46: -- Initialize message, depending on p_init_msg_list flag
47: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
48: FND_MSG_PUB.Initialize;
49: END IF;
50:
51: -- Initialize API return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 82: x_msg_count := FND_MSG_PUB.count_msg;

78: x_msg_data => x_msg_data,
79: p_x_mr_header_rec => p_x_mr_header_rec
80: );
81:
82: x_msg_count := FND_MSG_PUB.count_msg;
83: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
84: THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;

Line 114: FND_MSG_PUB.ADD;

110: );
111: END IF;
112: ElSE
113: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML_FLAG');
114: FND_MSG_PUB.ADD;
115: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
116: THEN
117: fnd_log.string
118: (

Line 153: x_msg_count := FND_MSG_PUB.count_msg;

149: x_msg_data => x_msg_data,
150: p_x_association_tbl => p_x_mr_doc_tbl
151: );
152:
153: x_msg_count := FND_MSG_PUB.count_msg;
154: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
155: THEN
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;

Line 194: x_msg_count := FND_MSG_PUB.count_msg;

190: x_msg_data => x_msg_data,
191: p_x_mr_route_tbl => p_x_mr_route_tbl
192: );
193:
194: x_msg_count := FND_MSG_PUB.count_msg;
195: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
196: THEN
197: RAISE FND_API.G_EXC_ERROR;
198: END IF;

Line 233: x_msg_count := FND_MSG_PUB.count_msg;

229: x_msg_data => x_msg_data,
230: p_x_mr_visit_type_tbl => p_x_mr_visit_type_tbl
231: );
232:
233: x_msg_count := FND_MSG_PUB.count_msg;
234: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
235: THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;

Line 273: x_msg_count := FND_MSG_PUB.count_msg;

269: p_mr_header_id => p_x_mr_header_rec.mr_header_id,
270: p_super_user => p_x_mr_header_rec.superuser_role
271: );
272:
273: x_msg_count := FND_MSG_PUB.count_msg;
274: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
275: THEN
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;

Line 314: x_msg_count := FND_MSG_PUB.count_msg;

310: x_msg_data => x_msg_data,
311: p_x_mr_relation_tbl => p_x_mr_relation_tbl
312: );
313:
314: x_msg_count := FND_MSG_PUB.count_msg;
315: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
316: THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;

Line 356: x_msg_count := FND_MSG_PUB.count_msg;

352: x_msg_data => x_msg_data,
353: p_x_mr_relation_tbl => p_x_accomtriggers_tbl
354: );
355:
356: x_msg_count := FND_MSG_PUB.count_msg;
357: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
358: THEN
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;

Line 388: x_msg_count := FND_MSG_PUB.count_msg;

384: );
385: END IF;
386:
387: -- Check Error Message stack.
388: x_msg_count := FND_MSG_PUB.count_msg;
389: IF x_msg_count > 0
390: THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;

Line 400: FND_MSG_PUB.count_and_get

396: COMMIT WORK;
397: END IF;
398:
399: -- Standard call to get message count and if count is 1, get message info
400: FND_MSG_PUB.count_and_get
401: (
402: p_count => x_msg_count,
403: p_data => x_msg_data,
404: p_encoded => FND_API.G_FALSE

Line 411: FND_MSG_PUB.count_and_get

407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: Rollback to Create_Mr_SP;
411: FND_MSG_PUB.count_and_get
412: (
413: p_count => x_msg_count,
414: p_data => x_msg_data,
415: p_encoded => FND_API.G_FALSE

Line 421: FND_MSG_PUB.count_and_get

417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: Rollback to Create_Mr_SP;
421: FND_MSG_PUB.count_and_get
422: (
423: p_count => x_msg_count,
424: p_data => x_msg_data,
425: p_encoded => FND_API.G_FALSE

Line 431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

427:
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: Rollback to Create_Mr_SP;
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.add_exc_msg
434: (
435: p_pkg_name => G_PKG_NAME,

Line 433: FND_MSG_PUB.add_exc_msg

429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: Rollback to Create_Mr_SP;
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.add_exc_msg
434: (
435: p_pkg_name => G_PKG_NAME,
436: p_procedure_name => 'Create_Mr',
437: p_error_text => SUBSTR(SQLERRM,1,240)

Line 440: FND_MSG_PUB.count_and_get

436: p_procedure_name => 'Create_Mr',
437: p_error_text => SUBSTR(SQLERRM,1,240)
438: );
439: END IF;
440: FND_MSG_PUB.count_and_get
441: (
442: p_count => x_msg_count,
443: p_data => x_msg_data,
444: p_encoded => FND_API.G_FALSE

Line 517: FND_MSG_PUB.count_and_get

513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.count_and_get
518: (
519: p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE

Line 526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

522: );
523:
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.add_exc_msg
529: (
530: p_pkg_name => G_PKG_NAME,

Line 528: FND_MSG_PUB.add_exc_msg

524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.add_exc_msg
529: (
530: p_pkg_name => G_PKG_NAME,
531: p_procedure_name => 'Create_Mr',
532: p_error_text => SUBSTR(SQLERRM,1,240)

Line 535: FND_MSG_PUB.count_and_get

531: p_procedure_name => 'Create_Mr',
532: p_error_text => SUBSTR(SQLERRM,1,240)
533: );
534: END IF;
535: FND_MSG_PUB.count_and_get
536: (
537: p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE

Line 590: FND_MSG_PUB.Initialize;

586: END IF;
587:
588: -- Initialize message, depending on p_init_msg_list flag
589: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
590: FND_MSG_PUB.Initialize;
591: END IF;
592:
593: -- Initialize API return status to success
594: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 618: x_msg_count := FND_MSG_PUB.count_msg;

614: x_mr_header_id => l_mr_header_rec.mr_header_id,
615: x_return_status => x_return_status
616: );
617:
618: x_msg_count := FND_MSG_PUB.count_msg;
619: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
620: THEN
621: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
622: THEN

Line 650: x_msg_count := FND_MSG_PUB.count_msg;

646: x_msg_data => x_msg_data,
647: p_x_mr_header_rec => l_mr_header_rec
648: );
649:
650: x_msg_count := FND_MSG_PUB.count_msg;
651: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
652: THEN
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;

Line 668: FND_MSG_PUB.ADD;

664: END IF;
665: ElSIF (l_mr_header_rec.DML_OPERATION IS NOT NULL)
666: THEN
667: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML_FLAG');
668: FND_MSG_PUB.ADD;
669: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
670: THEN
671: fnd_log.string
672: (

Line 706: x_msg_count := FND_MSG_PUB.count_msg;

702: x_msg_data => x_msg_data,
703: p_x_association_tbl => p_x_mr_doc_tbl
704: );
705:
706: x_msg_count := FND_MSG_PUB.count_msg;
707: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
708: THEN
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;

Line 746: x_msg_count := FND_MSG_PUB.count_msg;

742: x_msg_data => x_msg_data,
743: p_x_mr_route_tbl => p_x_mr_route_tbl
744: );
745:
746: x_msg_count := FND_MSG_PUB.count_msg;
747: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
748: THEN
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;

Line 784: x_msg_count := FND_MSG_PUB.count_msg;

780: x_msg_data => x_msg_data,
781: p_x_mr_visit_type_tbl => p_x_mr_visit_type_tbl
782: );
783:
784: x_msg_count := FND_MSG_PUB.count_msg;
785: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
786: THEN
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;

Line 819: x_msg_count := FND_MSG_PUB.count_msg;

815: p_mr_header_id => l_mr_header_rec.mr_header_id,
816: p_super_user => l_mr_header_rec.superuser_role
817: );
818:
819: x_msg_count := FND_MSG_PUB.count_msg;
820: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
821: THEN
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;

Line 859: x_msg_count := FND_MSG_PUB.count_msg;

855: x_msg_data => x_msg_data,
856: p_x_mr_relation_tbl => p_x_mr_relation_tbl
857: );
858:
859: x_msg_count := FND_MSG_PUB.count_msg;
860: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
861: THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;

Line 900: x_msg_count := FND_MSG_PUB.count_msg;

896: x_msg_data => x_msg_data,
897: p_x_mr_relation_tbl => p_x_accomtriggers_tbl
898: );
899:
900: x_msg_count := FND_MSG_PUB.count_msg;
901: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
902: THEN
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;

Line 931: x_msg_count := FND_MSG_PUB.count_msg;

927: );
928: END IF;
929:
930: -- Check Error Message stack.
931: x_msg_count := FND_MSG_PUB.count_msg;
932: IF x_msg_count > 0
933: THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;

Line 943: FND_MSG_PUB.count_and_get

939: COMMIT WORK;
940: END IF;
941:
942: -- Standard call to get message count and if count is 1, get message info
943: FND_MSG_PUB.count_and_get
944: (
945: p_count => x_msg_count,
946: p_data => x_msg_data,
947: p_encoded => FND_API.G_FALSE

Line 954: FND_MSG_PUB.count_and_get

950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: Rollback to Modify_Mr_SP;
954: FND_MSG_PUB.count_and_get
955: (
956: p_count => x_msg_count,
957: p_data => x_msg_data,
958: p_encoded => FND_API.G_FALSE

Line 964: FND_MSG_PUB.count_and_get

960:
961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: Rollback to Modify_Mr_SP;
964: FND_MSG_PUB.count_and_get
965: (
966: p_count => x_msg_count,
967: p_data => x_msg_data,
968: p_encoded => FND_API.G_FALSE

Line 974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

970:
971: WHEN OTHERS THEN
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: Rollback to Modify_Mr_SP;
974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
975: THEN
976: FND_MSG_PUB.add_exc_msg
977: (
978: p_pkg_name => G_PKG_NAME,

Line 976: FND_MSG_PUB.add_exc_msg

972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: Rollback to Modify_Mr_SP;
974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
975: THEN
976: FND_MSG_PUB.add_exc_msg
977: (
978: p_pkg_name => G_PKG_NAME,
979: p_procedure_name => 'Modify_Mr',
980: p_error_text => SUBSTR(SQLERRM,1,240)

Line 983: FND_MSG_PUB.count_and_get

979: p_procedure_name => 'Modify_Mr',
980: p_error_text => SUBSTR(SQLERRM,1,240)
981: );
982: END IF;
983: FND_MSG_PUB.count_and_get
984: (
985: p_count => x_msg_count,
986: p_data => x_msg_data,
987: p_encoded => FND_API.G_FALSE

Line 1059: FND_MSG_PUB.count_and_get

1055:
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: FND_MSG_PUB.count_and_get
1060: (
1061: p_count => x_msg_count,
1062: p_data => x_msg_data,
1063: p_encoded => FND_API.G_FALSE

Line 1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1064: );
1065:
1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.add_exc_msg
1071: (
1072: p_pkg_name => G_PKG_NAME,

Line 1070: FND_MSG_PUB.add_exc_msg

1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.add_exc_msg
1071: (
1072: p_pkg_name => G_PKG_NAME,
1073: p_procedure_name => 'Modify_Mr',
1074: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1077: FND_MSG_PUB.count_and_get

1073: p_procedure_name => 'Modify_Mr',
1074: p_error_text => SUBSTR(SQLERRM,1,240)
1075: );
1076: END IF;
1077: FND_MSG_PUB.count_and_get
1078: (
1079: p_count => x_msg_count,
1080: p_data => x_msg_data,
1081: p_encoded => FND_API.G_FALSE

Line 1128: FND_MSG_PUB.Initialize;

1124: END IF;
1125:
1126: -- Initialize message, depending on p_init_msg_list flag
1127: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1128: FND_MSG_PUB.Initialize;
1129: END IF;
1130:
1131: -- Initialize API return status to success
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1156: x_msg_count := FND_MSG_PUB.count_msg;

1152: x_mr_header_id => l_mr_header_id,
1153: x_return_status => x_return_status
1154: );
1155:
1156: x_msg_count := FND_MSG_PUB.count_msg;
1157: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1158: THEN
1159: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1160: THEN

Line 1187: x_msg_count := FND_MSG_PUB.count_msg;

1183: p_mr_header_id => l_mr_header_id,
1184: p_OBJECT_VERSION_NUMBER => p_mr_object_version
1185: );
1186:
1187: x_msg_count := FND_MSG_PUB.count_msg;
1188: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1189: THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;

Line 1207: x_msg_count := FND_MSG_PUB.count_msg;

1203: );
1204: END IF;
1205:
1206: -- Check Error Message stack.
1207: x_msg_count := FND_MSG_PUB.count_msg;
1208: IF x_msg_count > 0
1209: THEN
1210: RAISE FND_API.G_EXC_ERROR;
1211: END IF;

Line 1219: FND_MSG_PUB.count_and_get

1215: COMMIT WORK;
1216: END IF;
1217:
1218: -- Standard call to get message count and if count is 1, get message info
1219: FND_MSG_PUB.count_and_get
1220: (
1221: p_count => x_msg_count,
1222: p_data => x_msg_data,
1223: p_encoded => FND_API.G_FALSE

Line 1230: FND_MSG_PUB.count_and_get

1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: Rollback to Delete_Mr_SP;
1230: FND_MSG_PUB.count_and_get
1231: (
1232: p_count => x_msg_count,
1233: p_data => x_msg_data,
1234: p_encoded => FND_API.G_FALSE

Line 1240: FND_MSG_PUB.count_and_get

1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: Rollback to Delete_Mr_SP;
1240: FND_MSG_PUB.count_and_get
1241: (
1242: p_count => x_msg_count,
1243: p_data => x_msg_data,
1244: p_encoded => FND_API.G_FALSE

Line 1250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1246:
1247: WHEN OTHERS THEN
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: Rollback to Delete_Mr_SP;
1250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: FND_MSG_PUB.add_exc_msg
1253: (
1254: p_pkg_name => G_PKG_NAME,

Line 1252: FND_MSG_PUB.add_exc_msg

1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: Rollback to Delete_Mr_SP;
1250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: FND_MSG_PUB.add_exc_msg
1253: (
1254: p_pkg_name => G_PKG_NAME,
1255: p_procedure_name => 'Delete_Mr',
1256: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1259: FND_MSG_PUB.count_and_get

1255: p_procedure_name => 'Delete_Mr',
1256: p_error_text => SUBSTR(SQLERRM,1,240)
1257: );
1258: END IF;
1259: FND_MSG_PUB.count_and_get
1260: (
1261: p_count => x_msg_count,
1262: p_data => x_msg_data,
1263: p_encoded => FND_API.G_FALSE

Line 1311: FND_MSG_PUB.Initialize;

1307: END IF;
1308:
1309: -- Initialize message, depending on p_init_msg_list flag
1310: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1311: FND_MSG_PUB.Initialize;
1312: END IF;
1313:
1314: -- Initialize API return status to success
1315: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1339: x_msg_count := FND_MSG_PUB.count_msg;

1335: x_mr_header_id => l_mr_header_id,
1336: x_return_status => x_return_status
1337: );
1338:
1339: x_msg_count := FND_MSG_PUB.count_msg;
1340: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1341: THEN
1342: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1343: THEN

Line 1372: x_msg_count := FND_MSG_PUB.count_msg;

1368: p_source_mr_header_id => l_mr_header_id,
1369: x_new_mr_header_id => x_new_mr_header_id
1370: );
1371:
1372: x_msg_count := FND_MSG_PUB.count_msg;
1373: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1374: THEN
1375: RAISE FND_API.G_EXC_ERROR;
1376: END IF;

Line 1392: x_msg_count := FND_MSG_PUB.count_msg;

1388: );
1389: END IF;
1390:
1391: -- Check Error Message stack.
1392: x_msg_count := FND_MSG_PUB.count_msg;
1393: IF x_msg_count > 0
1394: THEN
1395: RAISE FND_API.G_EXC_ERROR;
1396: END IF;

Line 1404: FND_MSG_PUB.count_and_get

1400: COMMIT WORK;
1401: END IF;
1402:
1403: -- Standard call to get message count and if count is 1, get message info
1404: FND_MSG_PUB.count_and_get
1405: (
1406: p_count => x_msg_count,
1407: p_data => x_msg_data,
1408: p_encoded => FND_API.G_FALSE

Line 1415: FND_MSG_PUB.count_and_get

1411: EXCEPTION
1412: WHEN FND_API.G_EXC_ERROR THEN
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: Rollback to Create_Mr_Revision_SP;
1415: FND_MSG_PUB.count_and_get
1416: (
1417: p_count => x_msg_count,
1418: p_data => x_msg_data,
1419: p_encoded => FND_API.G_FALSE

Line 1425: FND_MSG_PUB.count_and_get

1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: Rollback to Create_Mr_Revision_SP;
1425: FND_MSG_PUB.count_and_get
1426: (
1427: p_count => x_msg_count,
1428: p_data => x_msg_data,
1429: p_encoded => FND_API.G_FALSE

Line 1435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1431:
1432: WHEN OTHERS THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: Rollback to Create_Mr_Revision_SP;
1435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.add_exc_msg
1438: (
1439: p_pkg_name => G_PKG_NAME,

Line 1437: FND_MSG_PUB.add_exc_msg

1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: Rollback to Create_Mr_Revision_SP;
1435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.add_exc_msg
1438: (
1439: p_pkg_name => G_PKG_NAME,
1440: p_procedure_name => 'Create_Mr_Revision',
1441: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1444: FND_MSG_PUB.count_and_get

1440: p_procedure_name => 'Create_Mr_Revision',
1441: p_error_text => SUBSTR(SQLERRM,1,240)
1442: );
1443: END IF;
1444: FND_MSG_PUB.count_and_get
1445: (
1446: p_count => x_msg_count,
1447: p_data => x_msg_data,
1448: p_encoded => FND_API.G_FALSE

Line 1496: FND_MSG_PUB.Initialize;

1492: END IF;
1493:
1494: -- Initialize message, depending on p_init_msg_list flag
1495: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1496: FND_MSG_PUB.Initialize;
1497: END IF;
1498:
1499: -- Initialize API return status to success
1500: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1524: x_msg_count := FND_MSG_PUB.count_msg;

1520: x_mr_header_id => l_mr_header_id,
1521: x_return_status => x_return_status
1522: );
1523:
1524: x_msg_count := FND_MSG_PUB.count_msg;
1525: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1526: THEN
1527: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1528: THEN

Line 1556: x_msg_count := FND_MSG_PUB.count_msg;

1552: p_object_Version_number => p_mr_object_version,
1553: p_apprv_type => p_apprv_type
1554: );
1555:
1556: x_msg_count := FND_MSG_PUB.count_msg;
1557: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1558: THEN
1559: RAISE FND_API.G_EXC_ERROR;
1560: END IF;

Line 1576: x_msg_count := FND_MSG_PUB.count_msg;

1572: );
1573: END IF;
1574:
1575: -- Check Error Message stack.
1576: x_msg_count := FND_MSG_PUB.count_msg;
1577: IF x_msg_count > 0
1578: THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;

Line 1588: FND_MSG_PUB.count_and_get

1584: COMMIT WORK;
1585: END IF;
1586:
1587: -- Standard call to get message count and if count is 1, get message info
1588: FND_MSG_PUB.count_and_get
1589: (
1590: p_count => x_msg_count,
1591: p_data => x_msg_data,
1592: p_encoded => FND_API.G_FALSE

Line 1599: FND_MSG_PUB.count_and_get

1595: EXCEPTION
1596: WHEN FND_API.G_EXC_ERROR THEN
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: Rollback to Initiate_Mr_Approval_SP;
1599: FND_MSG_PUB.count_and_get
1600: (
1601: p_count => x_msg_count,
1602: p_data => x_msg_data,
1603: p_encoded => FND_API.G_FALSE

Line 1609: FND_MSG_PUB.count_and_get

1605:
1606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: Rollback to Initiate_Mr_Approval_SP;
1609: FND_MSG_PUB.count_and_get
1610: (
1611: p_count => x_msg_count,
1612: p_data => x_msg_data,
1613: p_encoded => FND_API.G_FALSE

Line 1619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1615:
1616: WHEN OTHERS THEN
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: Rollback to Initiate_Mr_Approval_SP;
1619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: FND_MSG_PUB.add_exc_msg
1622: (
1623: p_pkg_name => G_PKG_NAME,

Line 1621: FND_MSG_PUB.add_exc_msg

1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: Rollback to Initiate_Mr_Approval_SP;
1619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: FND_MSG_PUB.add_exc_msg
1622: (
1623: p_pkg_name => G_PKG_NAME,
1624: p_procedure_name => 'Initiate_Mr_Approval',
1625: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1628: FND_MSG_PUB.count_and_get

1624: p_procedure_name => 'Initiate_Mr_Approval',
1625: p_error_text => SUBSTR(SQLERRM,1,240)
1626: );
1627: END IF;
1628: FND_MSG_PUB.count_and_get
1629: (
1630: p_count => x_msg_count,
1631: p_data => x_msg_data,
1632: p_encoded => FND_API.G_FALSE

Line 1674: FND_MSG_PUB.Initialize;

1670: END IF;
1671:
1672: -- Initialize message, depending on p_init_msg_list flag
1673: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1674: FND_MSG_PUB.Initialize;
1675: END IF;
1676:
1677: -- Initialize API return status to success
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1708: x_msg_count := FND_MSG_PUB.count_msg;

1704: x_msg_data => x_msg_data,
1705: p_x_mr_route_seq_tbl => p_x_mr_route_seq_tbl
1706: );
1707:
1708: x_msg_count := FND_MSG_PUB.count_msg;
1709: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1710: THEN
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;

Line 1730: x_msg_count := FND_MSG_PUB.count_msg;

1726: );
1727: END IF;
1728:
1729: -- Check Error Message stack.
1730: x_msg_count := FND_MSG_PUB.count_msg;
1731: IF x_msg_count > 0
1732: THEN
1733: RAISE FND_API.G_EXC_ERROR;
1734: END IF;

Line 1742: FND_MSG_PUB.count_and_get

1738: COMMIT WORK;
1739: END IF;
1740:
1741: -- Standard call to get message count and if count is 1, get message info
1742: FND_MSG_PUB.count_and_get
1743: (
1744: p_count => x_msg_count,
1745: p_data => x_msg_data,
1746: p_encoded => FND_API.G_FALSE

Line 1753: FND_MSG_PUB.count_and_get

1749: EXCEPTION
1750: WHEN FND_API.G_EXC_ERROR THEN
1751: x_return_status := FND_API.G_RET_STS_ERROR;
1752: Rollback to Process_Mr_Route_Seq_SP;
1753: FND_MSG_PUB.count_and_get
1754: (
1755: p_count => x_msg_count,
1756: p_data => x_msg_data,
1757: p_encoded => FND_API.G_FALSE

Line 1763: FND_MSG_PUB.count_and_get

1759:
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: Rollback to Process_Mr_Route_Seq_SP;
1763: FND_MSG_PUB.count_and_get
1764: (
1765: p_count => x_msg_count,
1766: p_data => x_msg_data,
1767: p_encoded => FND_API.G_FALSE

Line 1773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1769:
1770: WHEN OTHERS THEN
1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1772: Rollback to Process_Mr_Route_Seq_SP;
1773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN
1775: FND_MSG_PUB.add_exc_msg
1776: (
1777: p_pkg_name => G_PKG_NAME,

Line 1775: FND_MSG_PUB.add_exc_msg

1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1772: Rollback to Process_Mr_Route_Seq_SP;
1773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN
1775: FND_MSG_PUB.add_exc_msg
1776: (
1777: p_pkg_name => G_PKG_NAME,
1778: p_procedure_name => 'Process_Mr_Route_Seq',
1779: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1782: FND_MSG_PUB.count_and_get

1778: p_procedure_name => 'Process_Mr_Route_Seq',
1779: p_error_text => SUBSTR(SQLERRM,1,240)
1780: );
1781: END IF;
1782: FND_MSG_PUB.count_and_get
1783: (
1784: p_count => x_msg_count,
1785: p_data => x_msg_data,
1786: p_encoded => FND_API.G_FALSE

Line 1840: FND_MSG_PUB.Initialize;

1836: END IF;
1837:
1838: -- Initialize message, depending on p_init_msg_list flag
1839: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1840: FND_MSG_PUB.Initialize;
1841: END IF;
1842:
1843: -- Initialize API return status to success
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1868: x_msg_count := FND_MSG_PUB.count_msg;

1864: x_mr_header_id => l_mr_header_id,
1865: x_return_status => x_return_status
1866: );
1867:
1868: x_msg_count := FND_MSG_PUB.count_msg;
1869: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1870: THEN
1871: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1872: THEN

Line 1894: x_msg_count := FND_MSG_PUB.count_msg;

1890: x_mr_effectivity_id => l_mr_effectivity_id,
1891: x_return_status => x_return_status
1892: );
1893:
1894: x_msg_count := FND_MSG_PUB.count_msg;
1895: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1896: THEN
1897: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1898: THEN

Line 1929: x_msg_count := FND_MSG_PUB.count_msg;

1925: p_mr_header_id => l_mr_header_id,
1926: p_mr_effectivity_id => l_mr_effectivity_id
1927: );
1928:
1929: x_msg_count := FND_MSG_PUB.count_msg;
1930: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1931: THEN
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;

Line 1958: x_msg_count := FND_MSG_PUB.count_msg;

1954: p_super_user => p_super_user
1955: );
1956: END IF;
1957:
1958: x_msg_count := FND_MSG_PUB.count_msg;
1959: IF x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS
1960: THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;

Line 1978: x_msg_count := FND_MSG_PUB.count_msg;

1974: );
1975: END IF;
1976:
1977: -- Check Error Message stack.
1978: x_msg_count := FND_MSG_PUB.count_msg;
1979: IF x_msg_count > 0
1980: THEN
1981: RAISE FND_API.G_EXC_ERROR;
1982: END IF;

Line 1990: FND_MSG_PUB.count_and_get

1986: COMMIT WORK;
1987: END IF;
1988:
1989: -- Standard call to get message count and if count is 1, get message info
1990: FND_MSG_PUB.count_and_get
1991: (
1992: p_count => x_msg_count,
1993: p_data => x_msg_data,
1994: p_encoded => FND_API.G_FALSE

Line 2001: FND_MSG_PUB.count_and_get

1997: EXCEPTION
1998: WHEN FND_API.G_EXC_ERROR THEN
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000: Rollback to Process_Mr_Effectivities_SP;
2001: FND_MSG_PUB.count_and_get
2002: (
2003: p_count => x_msg_count,
2004: p_data => x_msg_data,
2005: p_encoded => FND_API.G_FALSE

Line 2011: FND_MSG_PUB.count_and_get

2007:
2008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010: Rollback to Process_Mr_Effectivities_SP;
2011: FND_MSG_PUB.count_and_get
2012: (
2013: p_count => x_msg_count,
2014: p_data => x_msg_data,
2015: p_encoded => FND_API.G_FALSE

Line 2021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2017:
2018: WHEN OTHERS THEN
2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: Rollback to Process_Mr_Effectivities_SP;
2021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: FND_MSG_PUB.add_exc_msg
2024: (
2025: p_pkg_name => G_PKG_NAME,

Line 2023: FND_MSG_PUB.add_exc_msg

2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: Rollback to Process_Mr_Effectivities_SP;
2021: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: FND_MSG_PUB.add_exc_msg
2024: (
2025: p_pkg_name => G_PKG_NAME,
2026: p_procedure_name => 'Process_Mr_Effectivities',
2027: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2030: FND_MSG_PUB.count_and_get

2026: p_procedure_name => 'Process_Mr_Effectivities',
2027: p_error_text => SUBSTR(SQLERRM,1,240)
2028: );
2029: END IF;
2030: FND_MSG_PUB.count_and_get
2031: (
2032: p_count => x_msg_count,
2033: p_data => x_msg_data,
2034: p_encoded => FND_API.G_FALSE