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_MESSAGE

Line 74: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );

70: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 89: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

85: l_return_status
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;

Line 97: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

93: END IF;
94:
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;

Line 98: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );

94:
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;

Line 109: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );

105: FOR i IN 1..p_route_operation_tbl.count LOOP
106: IF ( p_route_operation_tbl(i).dml_operation <> 'C' AND
107: p_route_operation_tbl(i).dml_operation <> 'U' AND
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;

Line 110: FND_MESSAGE.set_token( 'FIELD', p_route_operation_tbl(i).dml_operation );

106: IF ( p_route_operation_tbl(i).dml_operation <> 'C' AND
107: p_route_operation_tbl(i).dml_operation <> 'U' AND
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;

Line 111: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_tbl(i) ) );

107: p_route_operation_tbl(i).dml_operation <> 'U' AND
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;

Line 166: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RTO_INVALID_OPERATION' );

162: );
163:
164: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
165: IF ( l_msg_data = 'AHL_RM_INVALID_OPERATION' ) THEN
166: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RTO_INVALID_OPERATION' );
167: ELSE
168: FND_MESSAGE.set_name( 'AHL', l_msg_data );
169: END IF;
170:

Line 168: FND_MESSAGE.set_name( 'AHL', l_msg_data );

164: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
165: IF ( l_msg_data = 'AHL_RM_INVALID_OPERATION' ) THEN
166: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RTO_INVALID_OPERATION' );
167: ELSE
168: FND_MESSAGE.set_name( 'AHL', l_msg_data );
169: END IF;
170:
171: IF ( p_x_route_operation_rec.concatenated_segments IS NULL OR
172: p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN

Line 173: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_operation_rec.operation_id ) );

169: END IF;
170:
171: IF ( p_x_route_operation_rec.concatenated_segments IS NULL OR
172: p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
173: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_operation_rec.operation_id ) );
174: ELSE
175: FND_MESSAGE.set_token( 'FIELD', p_x_route_operation_rec.concatenated_segments );
176: END IF;
177:

Line 175: FND_MESSAGE.set_token( 'FIELD', p_x_route_operation_rec.concatenated_segments );

171: IF ( p_x_route_operation_rec.concatenated_segments IS NULL OR
172: p_x_route_operation_rec.concatenated_segments = FND_API.G_MISS_CHAR ) THEN
173: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_operation_rec.operation_id ) );
174: ELSE
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;

Line 178: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_rec ) );

174: ELSE
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;

Line 342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RT_OPER_REC' );

338: l_old_route_operation_rec.attribute14,
339: l_old_route_operation_rec.attribute15;
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;

Line 343: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_rec ) );

339: l_old_route_operation_rec.attribute15;
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;

Line 495: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_NULL' );

491: p_route_operation_rec.concatenated_segments IS NULL ) OR
492: ( p_route_operation_rec.dml_operation <> 'D' AND
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;

Line 496: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

492: ( p_route_operation_rec.dml_operation <> 'D' AND
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:

Line 507: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_NULL' );

503: IF ( ( p_route_operation_rec.dml_operation = 'C' AND
504: p_route_operation_rec.step IS NULL ) OR
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

Line 508: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

504: p_route_operation_rec.step IS NULL ) OR
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

Line 513: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_LESS_ZERO' );

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' );
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;

Line 514: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

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' );
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:

Line 527: FND_MESSAGE.set_name( 'AHL','AHL_RM_STEP_DECIMAL' );

523: INTO l_step
524: FROM DUAL;
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;

Line 528: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

524: FROM DUAL;
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;

Line 541: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_ID_NULL' );

537:
538: -- Check if the mandatory route_operation_id column contains a null value.
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;

Line 542: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

538: -- Check if the mandatory route_operation_id column contains a null value.
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:

Line 550: FND_MESSAGE.set_name( 'AHL','AHL_RM_RTO_OBJ_VERSION_NULL' );

546:
547: -- Check if the mandatory Object Version Number column contains a null value.
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;

Line 551: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

547: -- Check if the mandatory Object Version Number column contains a null value.
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:

Line 592: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_INACTIVE' );

588: FETCH get_active_operation INTO
589: l_dummy;
590:
591: IF ( get_active_operation%NOTFOUND ) THEN
592: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_INACTIVE' );
593:
594: IF ( p_route_operation_rec.concatenated_segments IS NULL ) THEN
595: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_route_operation_rec.operation_id ) );
596: ELSE

Line 595: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_route_operation_rec.operation_id ) );

591: IF ( get_active_operation%NOTFOUND ) THEN
592: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_INACTIVE' );
593:
594: IF ( p_route_operation_rec.concatenated_segments IS NULL ) THEN
595: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_route_operation_rec.operation_id ) );
596: ELSE
597: FND_MESSAGE.set_token( 'FIELD', p_route_operation_rec.concatenated_segments );
598: END IF;
599:

Line 597: FND_MESSAGE.set_token( 'FIELD', p_route_operation_rec.concatenated_segments );

593:
594: IF ( p_route_operation_rec.concatenated_segments IS NULL ) THEN
595: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_route_operation_rec.operation_id ) );
596: ELSE
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;

Line 600: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

596: ELSE
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:

Line 619: FND_MESSAGE.set_name( 'AHL', l_msg_data );

615: x_op_max_res_duration => l_op_max_res_duration
616: );
617:
618: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
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;

Line 620: FND_MESSAGE.set_token( 'FIELD1', l_op_max_res_duration );

616: );
617:
618: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
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;

Line 621: FND_MESSAGE.set_token( 'FIELD2', l_rt_time_span );

617:
618: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
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;

Line 622: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_operation_rec ) );

618: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
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:

Line 668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );

664: IF ( l_prev_operation IS NOT NULL AND
665: l_prev_step IS NOT NULL AND
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;

Line 669: FND_MESSAGE.set_token( 'FIELD', to_char(l_step) );

665: l_prev_step IS NOT NULL AND
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:

Line 1004: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );

1000: -- Set OUT values
1001: p_x_route_operation_tbl(i).route_operation_id := l_route_operation_id;
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1005: IF ( SQLCODE = -1 ) THEN
1006: FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );
1007: ELSE
1008: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );

Line 1006: FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );

1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1005: IF ( SQLCODE = -1 ) THEN
1006: FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );
1007: ELSE
1008: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );
1009: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1010: THEN

Line 1008: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );

1004: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );
1005: IF ( SQLCODE = -1 ) THEN
1006: FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );
1007: ELSE
1008: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );
1009: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1010: THEN
1011: fnd_log.string
1012: (

Line 1056: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1052: AND object_version_number = p_x_route_operation_tbl(i).object_version_number;
1053:
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;

Line 1057: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_operation_tbl(i) ) );

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

Line 1068: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STEP_DUP' );

1064:
1065: EXCEPTION
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;

Line 1069: FND_MESSAGE.set_token( 'FIELD', to_char(p_x_route_operation_tbl(i).step) );

1065: EXCEPTION
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;

Line 1083: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

1079: AND object_version_number = p_x_route_operation_tbl(i).object_version_number;
1080:
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;

Line 1084: FND_MESSAGE.set_token( 'RECORD', to_char(i) );

1080:
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;