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 497: FND_MSG_PUB.add;

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

Line 509: FND_MSG_PUB.add;

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

Line 515: FND_MSG_PUB.add;

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

Line 529: FND_MSG_PUB.add;

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

Line 543: FND_MSG_PUB.add;

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

Line 552: FND_MSG_PUB.add;

548: IF ( p_route_operation_rec.object_version_number IS NULL OR
549: p_route_operation_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
550: FND_MESSAGE.set_name( 'AHL','AHL_RM_RTO_OBJ_VERSION_NULL' );
551: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
552: FND_MSG_PUB.add;
553: -- x_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555:
556: END validate_attributes;

Line 601: FND_MSG_PUB.add;

597: FND_MESSAGE.set_token( 'FIELD', p_route_operation_rec.concatenated_segments );
598: END IF;
599:
600: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
601: FND_MSG_PUB.add;
602: --x_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;
604:
605: CLOSE get_active_operation;

Line 623: FND_MSG_PUB.add;

619: FND_MESSAGE.set_name( 'AHL', l_msg_data );
620: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );
621: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );
622: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );
623: FND_MSG_PUB.add;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:
627: END IF;

Line 670: FND_MSG_PUB.add;

666: l_operation <> l_prev_operation AND
667: l_step = l_prev_step ) THEN
668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
669: FND_MESSAGE.set_token( 'FIELD', to_char(l_step) );
670: FND_MSG_PUB.add;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: END IF;
673:
674: l_prev_step := l_step;

Line 734: FND_MSG_PUB.initialize;

730: END IF;
731:
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_boolean( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: IF G_DEBUG = 'Y' THEN
738: AHL_DEBUG_PUB.enable_debug;

Line 862: x_msg_count := FND_MSG_PUB.count_msg;

858: END IF;
859: */
860: END LOOP;
861: -- Check Error Message stack.
862: x_msg_count := FND_MSG_PUB.count_msg;
863: IF x_msg_count > 0
864: THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;

Line 929: l_msg_count := FND_MSG_PUB.count_msg;

925: END IF;
926: CLOSE get_route_status;
927:
928: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
929: l_msg_count := FND_MSG_PUB.count_msg;
930: IF l_msg_count > 0 THEN
931: x_msg_count := l_msg_count;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;

Line 1019: FND_MSG_PUB.add;

1015: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1016: );
1017: END IF;
1018: END IF;
1019: FND_MSG_PUB.add;
1020:
1021: END;
1022:
1023: ELSIF ( p_x_route_operation_tbl(i).dml_operation = 'U' ) THEN

Line 1058: FND_MSG_PUB.add;

1054: -- If the record does not exist, then, abort API.
1055: IF ( SQL%ROWCOUNT = 0 ) THEN
1056: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1057: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );
1058: FND_MSG_PUB.add;
1059: -- x_return_status := FND_API.G_RET_STS_ERROR;
1060: END IF;
1061:
1062: -- Set OUT values

Line 1070: FND_MSG_PUB.add;

1066: WHEN OTHERS THEN
1067: IF ( SQLCODE = -1 ) THEN
1068: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1069: FND_MESSAGE.set_token( 'FIELD', to_char(p_x_route_operation_tbl(i).step) );
1070: FND_MSG_PUB.add;
1071: -- x_return_status := FND_API.G_RET_STS_ERROR;
1072: END IF;
1073: END;
1074:

Line 1085: FND_MSG_PUB.add;

1081: -- If the record does not exist, then, abort API.
1082: IF ( SQL%ROWCOUNT = 0 ) THEN
1083: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1084: FND_MESSAGE.set_token( 'RECORD', to_char(i) );
1085: FND_MSG_PUB.add;
1086: --x_return_status := FND_API.G_RET_STS_ERROR;
1087: END IF;
1088: END IF;
1089: END LOOP;

Line 1096: l_msg_count := FND_MSG_PUB.count_msg;

1092: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1093: END IF;
1094:
1095: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1096: l_msg_count := FND_MSG_PUB.count_msg;
1097: IF l_msg_count > 0 THEN
1098: x_msg_count := l_msg_count;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;

Line 1128: FND_MSG_PUB.count_and_get

1124: COMMIT WORK;
1125: END IF;
1126:
1127: -- Count and Get messages (optional)
1128: FND_MSG_PUB.count_and_get
1129: (
1130: p_encoded => FND_API.G_FALSE,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data

Line 1145: FND_MSG_PUB.count_and_get

1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: ROLLBACK TO process_route_operation_pvt;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MSG_PUB.count_and_get
1146: (
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data

Line 1160: FND_MSG_PUB.count_and_get

1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO process_route_operation_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.count_and_get
1161: (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data

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

1171:
1172: WHEN OTHERS THEN
1173: ROLLBACK TO process_route_operation_pvt;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1175: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1176: THEN
1177: FND_MSG_PUB.add_exc_msg
1178: (
1179: p_pkg_name => G_PKG_NAME,

Line 1177: FND_MSG_PUB.add_exc_msg

1173: ROLLBACK TO process_route_operation_pvt;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1175: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1176: THEN
1177: FND_MSG_PUB.add_exc_msg
1178: (
1179: p_pkg_name => G_PKG_NAME,
1180: p_procedure_name => G_API_NAME,
1181: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1184: FND_MSG_PUB.count_and_get

1180: p_procedure_name => G_API_NAME,
1181: p_error_text => SUBSTRB(SQLERRM,1,240)
1182: );
1183: END IF;
1184: FND_MSG_PUB.count_and_get
1185: (
1186: p_encoded => FND_API.G_FALSE,
1187: p_count => x_msg_count,
1188: p_data => x_msg_data