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

Line 75: FND_MSG_PUB.add;

71:
72: -- Check if a valid value is passed in p_route_id
73: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
74: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
75: FND_MSG_PUB.add;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: RETURN;
78: END IF;
79:

Line 90: FND_MSG_PUB.ADD;

86: );
87:
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
90: FND_MSG_PUB.ADD;
91: x_return_status := l_return_status;
92: RETURN;
93: END IF;
94:

Line 99: FND_MSG_PUB.add;

95: -- Check if at least one record is passed in p_route_operation_tbl
96: IF ( p_route_operation_tbl.count < 1 ) THEN
97: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
98: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
99: FND_MSG_PUB.add;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: RETURN;
102: END IF;
103:

Line 112: FND_MSG_PUB.add;

108: p_route_operation_tbl(i).dml_operation <> 'D' ) THEN
109: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
110: FND_MESSAGE.set_token( 'FIELD', p_route_operation_tbl(i).dml_operation );
111: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_tbl(i) ) );
112: FND_MSG_PUB.add;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: RETURN;
115: END IF;
116: END LOOP;

Line 179: FND_MSG_PUB.add;

175: FND_MESSAGE.set_token( 'FIELD', p_x_route_operation_rec.concatenated_segments );
176: END IF;
177:
178: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_rec ) );
179: FND_MSG_PUB.add;
180: END IF;
181:
182: END IF;
183:

Line 344: FND_MSG_PUB.add;

340:
341: IF get_old_rec%NOTFOUND THEN
342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RT_OPER_REC' );
343: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_rec ) );
344: FND_MSG_PUB.add;
345: CLOSE get_old_rec;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:

Line 501: FND_MSG_PUB.add;

497: p_route_operation_rec.operation_id = FND_API.G_MISS_NUM AND
498: p_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) ) THEN
499: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_NULL' );
500: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
501: FND_MSG_PUB.add;
502: --x_return_status := FND_API.G_RET_STS_ERROR;
503: END IF;
504:
505: -- Check if the Step is NULL

Line 513: FND_MSG_PUB.add;

509: ( p_route_operation_rec.dml_operation <> 'D' AND
510: p_route_operation_rec.step = FND_API.G_MISS_NUM ) ) THEN
511: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_NULL' );
512: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
513: FND_MSG_PUB.add;
514: --x_return_status := FND_API.G_RET_STS_ERROR;
515: ELSIF ( p_route_operation_rec.dml_operation <> 'D' AND
516: p_route_operation_rec.step <= 0 ) THEN
517: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_LESS_ZERO' );

Line 519: FND_MSG_PUB.add;

515: ELSIF ( p_route_operation_rec.dml_operation <> 'D' AND
516: p_route_operation_rec.step <= 0 ) THEN
517: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_LESS_ZERO' );
518: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
519: FND_MSG_PUB.add;
520: --x_return_status := FND_API.G_RET_STS_ERROR;
521: END IF;
522:
523:

Line 533: FND_MSG_PUB.add;

529: EXCEPTION
530: WHEN INVALID_NUMBER THEN
531: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_DECIMAL' );
532: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
533: FND_MSG_PUB.add;
534: -- x_return_status := FND_API.G_RET_STS_ERROR;
535: END;
536: END IF;
537:

Line 547: FND_MSG_PUB.add;

543: IF ( p_route_operation_rec.route_operation_id IS NULL OR
544: p_route_operation_rec.route_operation_id = FND_API.G_MISS_NUM ) THEN
545: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_ID_NULL' );
546: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
547: FND_MSG_PUB.add;
548: --x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;
550:
551: -- Check if the mandatory Object Version Number column contains a null value.

Line 556: FND_MSG_PUB.add;

552: IF ( p_route_operation_rec.object_version_number IS NULL OR
553: p_route_operation_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
554: FND_MESSAGE.set_name( 'AHL','AHL_RM_RTO_OBJ_VERSION_NULL' );
555: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
556: FND_MSG_PUB.add;
557: -- x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559:
560:

Line 606: FND_MSG_PUB.add;

602: FND_MESSAGE.set_token( 'FIELD', p_route_operation_rec.concatenated_segments );
603: END IF;
604:
605: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
606: FND_MSG_PUB.add;
607: --x_return_status := FND_API.G_RET_STS_ERROR;
608: END IF;
609:
610: CLOSE get_active_operation;

Line 628: FND_MSG_PUB.add;

624: FND_MESSAGE.set_name( 'AHL', l_msg_data );
625: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
626: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
627: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
628: FND_MSG_PUB.add;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631:
632: END IF;

Line 675: FND_MSG_PUB.add;

671: l_operation <> l_prev_operation AND
672: l_step = l_prev_step ) THEN
673: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
674: FND_MESSAGE.set_token( 'FIELD', to_char(l_step) );
675: FND_MSG_PUB.add;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678:
679: l_prev_step := l_step;

Line 761: FND_MSG_PUB.initialize;

757: END IF;
758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF G_DEBUG = 'Y' THEN
765: AHL_DEBUG_PUB.enable_debug;

Line 811: FND_MSG_PUB.add;

807: CLOSE get_route_source;
808: IF (UPPER(l_route_source) = 'AUTOMATIC' AND UPPER(p_module_type) <> 'BPEL') THEN
809: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_ENG_ASS_ERR' );
810: FND_MESSAGE.set_token( 'FIELD', l_route_no );
811: FND_MSG_PUB.add;
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814: END LOOP;
815: --End of changes by snarkhed

Line 906: x_msg_count := FND_MSG_PUB.count_msg;

902: END IF;
903: */
904: END LOOP;
905: -- Check Error Message stack.
906: x_msg_count := FND_MSG_PUB.count_msg;
907: IF x_msg_count > 0
908: THEN
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;

Line 973: l_msg_count := FND_MSG_PUB.count_msg;

969: END IF;
970: CLOSE get_route_status;
971:
972: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
973: l_msg_count := FND_MSG_PUB.count_msg;
974: IF l_msg_count > 0 THEN
975: x_msg_count := l_msg_count;
976: RAISE FND_API.G_EXC_ERROR;
977: END IF;

Line 1063: FND_MSG_PUB.add;

1059: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1060: );
1061: END IF;
1062: END IF;
1063: FND_MSG_PUB.add;
1064:
1065: END;
1066:
1067: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'U' ) THEN

Line 1102: FND_MSG_PUB.add;

1098: -- If the record does not exist, then, abort API.
1099: IF ( SQL%ROWCOUNT = 0 ) THEN
1100: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1101: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1102: FND_MSG_PUB.add;
1103: -- x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;
1105:
1106: --Pekambar (Praveen) Added for 12.2 - VEE -

Line 1128: FND_MSG_PUB.add;

1124: WHEN OTHERS THEN
1125: IF ( SQLCODE = -1 ) THEN
1126: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1127: FND_MESSAGE.set_token( 'FIELD', to_char(p_x_route_operation_tbl(i).step) );
1128: FND_MSG_PUB.add;
1129: -- x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;
1131: END;
1132:

Line 1143: FND_MSG_PUB.add;

1139: -- If the record does not exist, then, abort API.
1140: IF ( SQL%ROWCOUNT = 0 ) THEN
1141: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1142: FND_MESSAGE.set_token( 'RECORD', to_char(i) );
1143: FND_MSG_PUB.add;
1144: --x_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146:
1147: --Pekambar (Praveen) Added for - VEE - USAF

Line 1167: FND_MSG_PUB.add;

1163: FETCH duplicate_step INTO l_dummy;
1164: IF ( duplicate_step%FOUND ) THEN
1165: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DUP_STEP' );
1166: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1167: FND_MSG_PUB.add;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170: CLOSE duplicate_step;
1171: END IF;

Line 1180: l_msg_count := FND_MSG_PUB.count_msg;

1176: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1177: END IF;
1178:
1179: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1180: l_msg_count := FND_MSG_PUB.count_msg;
1181: IF l_msg_count > 0 THEN
1182: x_msg_count := l_msg_count;
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;

Line 1212: FND_MSG_PUB.count_and_get

1208: COMMIT WORK;
1209: END IF;
1210:
1211: -- Count and Get messages (optional)
1212: FND_MSG_PUB.count_and_get
1213: (
1214: p_encoded => FND_API.G_FALSE,
1215: p_count => x_msg_count,
1216: p_data => x_msg_data

Line 1229: FND_MSG_PUB.count_and_get

1225:
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: ROLLBACK TO process_route_operation_pvt;
1228: x_return_status := FND_API.G_RET_STS_ERROR ;
1229: FND_MSG_PUB.count_and_get
1230: (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => x_msg_count,
1233: p_data => x_msg_data

Line 1244: FND_MSG_PUB.count_and_get

1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO process_route_operation_pvt;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1244: FND_MSG_PUB.count_and_get
1245: (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data

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

1255:
1256: WHEN OTHERS THEN
1257: ROLLBACK TO process_route_operation_pvt;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1260: THEN
1261: FND_MSG_PUB.add_exc_msg
1262: (
1263: p_pkg_name => G_PKG_NAME,

Line 1261: FND_MSG_PUB.add_exc_msg

1257: ROLLBACK TO process_route_operation_pvt;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1260: THEN
1261: FND_MSG_PUB.add_exc_msg
1262: (
1263: p_pkg_name => G_PKG_NAME,
1264: p_procedure_name => G_API_NAME,
1265: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1268: FND_MSG_PUB.count_and_get

1264: p_procedure_name => G_API_NAME,
1265: p_error_text => SUBSTRB(SQLERRM,1,240)
1266: );
1267: END IF;
1268: FND_MSG_PUB.count_and_get
1269: (
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data