DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on FND_MSG_PUB

Line 57: FND_MSG_PUB.add;

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
61: p_association_type_code <> 'ROUTE' ) THEN

Line 64: FND_MSG_PUB.add;

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

Line 79: FND_MSG_PUB.add;

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;
83: ELSIF (p_association_type_code = 'ROUTE') THEN

Line 92: FND_MSG_PUB.add;

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

Line 102: FND_MSG_PUB.add;

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

Line 119: FND_MSG_PUB.add;

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;
123: END LOOP;

Line 188: FND_MSG_PUB.add;

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;
190:
191: END IF;
192:

Line 337: FND_MSG_PUB.add;

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

Line 475: l_msg_count := FND_MSG_PUB.count_msg;

471: BEGIN
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
475: l_msg_count := FND_MSG_PUB.count_msg;
476: IF l_msg_count > 0 THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

Line 489: FND_MSG_PUB.add;

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.
493: IF ( p_rt_oper_panel_rec.rt_oper_panel_id IS NULL OR

Line 497: FND_MSG_PUB.add;

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
501: l_msg_count := FND_MSG_PUB.count_msg;

Line 501: l_msg_count := FND_MSG_PUB.count_msg;

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
501: l_msg_count := FND_MSG_PUB.count_msg;
502: IF l_msg_count > 0 THEN
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:

Line 549: FND_MSG_PUB.add;

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

Line 617: FND_MSG_PUB.initialize;

613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: IF G_DEBUG = 'Y' THEN
621: AHL_DEBUG_PUB.enable_debug;

Line 781: FND_MSG_PUB.ADD;

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

Line 812: FND_MSG_PUB.ADD;

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

Line 832: l_msg_count := FND_MSG_PUB.count_msg;

828: END IF ;
829:
830:
831: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
832: l_msg_count := FND_MSG_PUB.count_msg;
833: IF l_msg_count > 0 THEN
834: x_msg_count := l_msg_count;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;

Line 910: FND_MSG_PUB.add;

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
914: (

Line 956: FND_MSG_PUB.add;

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
960: p_x_rt_oper_panel_tbl(i).object_version_number := p_x_rt_oper_panel_tbl(i).object_version_number + 1;

Line 967: FND_MSG_PUB.add;

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
971: (

Line 991: FND_MSG_PUB.add;

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

Line 1001: l_msg_count := FND_MSG_PUB.count_msg;

997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );
998: END IF;
999:
1000: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1001: l_msg_count := FND_MSG_PUB.count_msg;
1002: IF l_msg_count > 0 THEN
1003: x_msg_count := l_msg_count;
1004: RAISE FND_API.G_EXC_ERROR;
1005: END IF;

Line 1032: FND_MSG_PUB.count_and_get

1028: COMMIT WORK;
1029: END IF;
1030:
1031: -- Count and Get messages (optional)
1032: FND_MSG_PUB.count_and_get
1033: (
1034: p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data

Line 1047: FND_MSG_PUB.count_and_get

1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: ROLLBACK TO process_rt_oper_panel_PVT;
1046: x_return_status := FND_API.G_RET_STS_ERROR ;
1047: FND_MSG_PUB.count_and_get
1048: (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data

Line 1062: FND_MSG_PUB.count_and_get

1058:
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO process_rt_oper_panel_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062: FND_MSG_PUB.count_and_get
1063: (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data

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

1073:
1074: WHEN OTHERS THEN
1075: ROLLBACK TO process_rt_oper_panel_PVT;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1077: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1078: THEN
1079: FND_MSG_PUB.add_exc_msg
1080: (
1081: p_pkg_name => G_PKG_NAME,

Line 1079: FND_MSG_PUB.add_exc_msg

1075: ROLLBACK TO process_rt_oper_panel_PVT;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1077: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1078: THEN
1079: FND_MSG_PUB.add_exc_msg
1080: (
1081: p_pkg_name => G_PKG_NAME,
1082: p_procedure_name => G_API_NAME1,
1083: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1086: FND_MSG_PUB.count_and_get

1082: p_procedure_name => G_API_NAME1,
1083: p_error_text => SUBSTRB(SQLERRM,1,240)
1084: );
1085: END IF;
1086: FND_MSG_PUB.count_and_get
1087: (
1088: p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data