DBA Data[Home] [Help]

APPS.QP_QUALIFIER_RULES_UTIL dependencies on OE_MSG_PUB

Line 740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

736: EXCEPTION
737:
738: WHEN OTHERS THEN
739:
740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: OE_MSG_PUB.Add_Exc_Msg
743: ( G_PKG_NAME
744: , 'Update_Row'

Line 742: OE_MSG_PUB.Add_Exc_Msg

738: WHEN OTHERS THEN
739:
740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: OE_MSG_PUB.Add_Exc_Msg
743: ( G_PKG_NAME
744: , 'Update_Row'
745: );
746: END IF;

Line 828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

824: EXCEPTION
825:
826: WHEN OTHERS THEN
827:
828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: OE_MSG_PUB.Add_Exc_Msg
831: ( G_PKG_NAME
832: , 'Insert_Row'

Line 830: OE_MSG_PUB.Add_Exc_Msg

826: WHEN OTHERS THEN
827:
828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: OE_MSG_PUB.Add_Exc_Msg
831: ( G_PKG_NAME
832: , 'Insert_Row'
833: );
834: END IF;

Line 863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

859: EXCEPTION
860:
861: WHEN OTHERS THEN
862:
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME
867: , 'Delete_Row'

Line 865: OE_MSG_PUB.Add_Exc_Msg

861: WHEN OTHERS THEN
862:
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME
867: , 'Delete_Row'
868: );
869: END IF;

Line 950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

946: EXCEPTION
947:
948: WHEN OTHERS THEN
949:
950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: OE_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'Query_Row'

Line 952: OE_MSG_PUB.Add_Exc_Msg

948: WHEN OTHERS THEN
949:
950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: OE_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'Query_Row'
955: );
956: END IF;

Line 1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1112:
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1117: THEN
1118:
1119: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_CHANGED');
1120: OE_MSG_PUB.Add;

Line 1120: OE_MSG_PUB.Add;

1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1117: THEN
1118:
1119: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_CHANGED');
1120: OE_MSG_PUB.Add;
1121:
1122: END IF;
1123:
1124: END IF;

Line 1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1129:
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1134: THEN
1135:
1136: oe_debug_pub.add('row deleted');
1137: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');

Line 1138: OE_MSG_PUB.Add;

1134: THEN
1135:
1136: oe_debug_pub.add('row deleted');
1137: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');
1138: OE_MSG_PUB.Add;
1139:
1140: END IF;
1141: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1142:

Line 1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1142:
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1145:
1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1147: THEN
1148:
1149: oe_debug_pub.add('row already locked');
1150: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_ALREADY_LOCKED');

Line 1151: OE_MSG_PUB.Add;

1147: THEN
1148:
1149: oe_debug_pub.add('row already locked');
1150: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_ALREADY_LOCKED');
1151: OE_MSG_PUB.Add;
1152:
1153: END IF;
1154: WHEN OTHERS THEN
1155:

Line 1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Lock_Row'

Line 1161: OE_MSG_PUB.Add_Exc_Msg

1157: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Lock_Row'
1164: );
1165: END IF;

Line 1219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1215: IF p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1216:
1217: l_QUALIFIER_RULES_rec.qualifier_rule_id := p_QUALIFIER_RULES_rec.qualifier_rule_id;
1218:
1219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1220: THEN
1221:
1222: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');

Line 1224: OE_MSG_PUB.Add;

1220: THEN
1221:
1222: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
1224: OE_MSG_PUB.Add;
1225:
1226: END IF;
1227:
1228: ELSE