DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on FND_MESSAGE

Line 56: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );

52:
53: -- Check if a valid value is passed in p_association_type_code
54: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR
55: p_association_type_code IS NULL ) THEN
56: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );
57: FND_MSG_PUB.add;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: RETURN;
60: ELSIF ( p_association_type_code <> 'OPERATION' AND

Line 62: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );

58: x_return_status := FND_API.G_RET_STS_ERROR;
59: RETURN;
60: ELSIF ( p_association_type_code <> 'OPERATION' AND
61: p_association_type_code <> 'ROUTE' ) THEN
62: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
63: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );
64: FND_MSG_PUB.add;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: RETURN;

Line 63: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );

59: RETURN;
60: ELSIF ( p_association_type_code <> 'OPERATION' AND
61: p_association_type_code <> 'ROUTE' ) THEN
62: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
63: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );
64: FND_MSG_PUB.add;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: RETURN;
67: END IF;

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

74: x_return_status => l_return_status,
75: x_msg_data => l_msg_data
76: );
77: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
78: FND_MESSAGE.set_name( 'AHL', l_msg_data );
79: FND_MSG_PUB.add;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: RETURN;
82: END IF;

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

87: x_return_status => l_return_status,
88: x_msg_data => l_msg_data
89: );
90: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
91: FND_MESSAGE.set_name( 'AHL', l_msg_data );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: END IF;

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

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

Line 101: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );

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

Line 117: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );

113: p_rt_oper_panel_tbl(i).dml_operation <> 'D'
114: )
115: )
116: THEN
117: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
118: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_panel_tbl(i).dml_operation );
119: FND_MSG_PUB.add;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: RETURN;

Line 118: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_panel_tbl(i).dml_operation );

114: )
115: )
116: THEN
117: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
118: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_panel_tbl(i).dml_operation );
119: FND_MSG_PUB.add;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: RETURN;
122: END IF;

Line 174: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_TYPE' );

170: );
171:
172: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
173: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
174: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_TYPE' );
175: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
176: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PANEL_TYPES' );
177: ELSE
178: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 176: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PANEL_TYPES' );

172: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
173: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
174: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_TYPE' );
175: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
176: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PANEL_TYPES' );
177: ELSE
178: FND_MESSAGE.set_name( 'AHL', l_msg_data );
179: END IF;
180:

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

174: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_TYPE' );
175: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
176: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PANEL_TYPES' );
177: ELSE
178: FND_MESSAGE.set_name( 'AHL', l_msg_data );
179: END IF;
180:
181: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL OR
182: p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

Line 183: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_panel_rec.panel_type_id ) );

179: END IF;
180:
181: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL OR
182: p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
183: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_panel_rec.panel_type_id ) );
184: ELSE
185: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_panel_rec.panel_type );
186: END IF;
187:

Line 185: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_panel_rec.panel_type );

181: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL OR
182: p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
183: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_panel_rec.panel_type_id ) );
184: ELSE
185: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_panel_rec.panel_type );
186: END IF;
187:
188: FND_MSG_PUB.add;
189: END IF;

Line 335: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_REC' );

331: l_old_rt_oper_panel_rec.attribute14,
332: l_old_rt_oper_panel_rec.attribute15;
333:
334: IF get_old_rec%NOTFOUND THEN
335: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_REC' );
336: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_rec ) );
337: FND_MSG_PUB.add;
338: CLOSE get_old_rec;
339: RAISE FND_API.G_EXC_ERROR;

Line 336: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_rec ) );

332: l_old_rt_oper_panel_rec.attribute15;
333:
334: IF get_old_rec%NOTFOUND THEN
335: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_REC' );
336: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_rec ) );
337: FND_MSG_PUB.add;
338: CLOSE get_old_rec;
339: RAISE FND_API.G_EXC_ERROR;
340: END IF;

Line 487: FND_MESSAGE.set_name( 'AHL','AHL_RM_PANEL_VERSION_NULL' );

483:
484: -- Check if the mandatory Object Version Number column contains a null value.
485: IF ( p_rt_oper_panel_rec.object_version_number IS NULL OR
486: p_rt_oper_panel_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
487: FND_MESSAGE.set_name( 'AHL','AHL_RM_PANEL_VERSION_NULL' );
488: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
489: FND_MSG_PUB.add;
490: END IF;
491:

Line 488: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );

484: -- Check if the mandatory Object Version Number column contains a null value.
485: IF ( p_rt_oper_panel_rec.object_version_number IS NULL OR
486: p_rt_oper_panel_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
487: FND_MESSAGE.set_name( 'AHL','AHL_RM_PANEL_VERSION_NULL' );
488: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
489: FND_MSG_PUB.add;
490: END IF;
491:
492: -- Check if the mandatory rt_oper_panel ID column contains a null value.

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

491:
492: -- Check if the mandatory rt_oper_panel ID column contains a null value.
493: IF ( p_rt_oper_panel_rec.rt_oper_panel_id IS NULL OR
494: p_rt_oper_panel_rec.rt_oper_panel_id = FND_API.G_MISS_NUM ) THEN
495: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_PANEL_ID_NULL' );
496: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
497: FND_MSG_PUB.add;
498: END IF;
499:

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

492: -- Check if the mandatory rt_oper_panel ID column contains a null value.
493: IF ( p_rt_oper_panel_rec.rt_oper_panel_id IS NULL OR
494: p_rt_oper_panel_rec.rt_oper_panel_id = FND_API.G_MISS_NUM ) THEN
495: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_PANEL_ID_NULL' );
496: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
497: FND_MSG_PUB.add;
498: END IF;
499:
500: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 547: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );

543: END LOOP;
544:
545: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
546: CLOSE get_dup_rec;
547: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
548: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_panel_rec ) );
549: FND_MSG_PUB.add;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: RETURN;

Line 548: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_panel_rec ) );

544:
545: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
546: CLOSE get_dup_rec;
547: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
548: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_panel_rec ) );
549: FND_MSG_PUB.add;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: RETURN;
552: END IF;

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

776: l_return_status
777: );
778:
779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
780: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
781: FND_MSG_PUB.ADD;
782: x_return_status := l_return_status;
783: RETURN;
784: END IF;

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

807: l_return_status
808: );
809:
810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
811: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
812: FND_MSG_PUB.ADD;
813: x_return_status := l_return_status;
814: RETURN;
815: END IF;

Line 908: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );

904:
905: EXCEPTION
906: WHEN OTHERS THEN
907: IF ( SQLCODE = -1 ) THEN
908: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
909: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_panel_tbl(i) ) );
910: FND_MSG_PUB.add;
911: ELSE
912: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 909: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_panel_tbl(i) ) );

905: EXCEPTION
906: WHEN OTHERS THEN
907: IF ( SQLCODE = -1 ) THEN
908: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
909: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_x_rt_oper_panel_tbl(i) ) );
910: FND_MSG_PUB.add;
911: ELSE
912: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
913: fnd_log.string

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

950: AND object_version_number = p_x_rt_oper_panel_tbl(i).object_version_number;
951:
952: -- If the record does not exist, then, abort API.
953: IF ( SQL%ROWCOUNT = 0 ) THEN
954: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
955: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );
956: FND_MSG_PUB.add;
957: END IF;
958:

Line 955: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );

951:
952: -- If the record does not exist, then, abort API.
953: IF ( SQL%ROWCOUNT = 0 ) THEN
954: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
955: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );
956: FND_MSG_PUB.add;
957: END IF;
958:
959: -- Set OUT values

Line 965: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );

961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: IF ( SQLCODE = -1 ) THEN
965: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
966: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );
967: FND_MSG_PUB.add;
968: ELSE
969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 966: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );

962: EXCEPTION
963: WHEN OTHERS THEN
964: IF ( SQLCODE = -1 ) THEN
965: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
966: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_tbl(i) ) );
967: FND_MSG_PUB.add;
968: ELSE
969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
970: fnd_log.string

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

985: AND object_version_number = p_x_rt_oper_panel_tbl(i).object_version_number;
986:
987: -- If the record does not exist, then, abort API.
988: IF ( SQL%ROWCOUNT = 0 ) THEN
989: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
990: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
991: FND_MSG_PUB.add;
992: END IF;
993: END IF;

Line 990: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );

986:
987: -- If the record does not exist, then, abort API.
988: IF ( SQL%ROWCOUNT = 0 ) THEN
989: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
990: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
991: FND_MSG_PUB.add;
992: END IF;
993: END IF;
994: END LOOP;