DBA Data[Home] [Help]

APPS.OE_CONTRACT_UTIL dependencies on OE_MSG_PUB

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

614: EXCEPTION
615:
616: WHEN OTHERS THEN
617:
618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
619: THEN
620: OE_MSG_PUB.Add_Exc_Msg
621: ( G_PKG_NAME
622: , 'Update_Row'

Line 620: OE_MSG_PUB.Add_Exc_Msg

616: WHEN OTHERS THEN
617:
618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
619: THEN
620: OE_MSG_PUB.Add_Exc_Msg
621: ( G_PKG_NAME
622: , 'Update_Row'
623: );
624: END IF;

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

697: EXCEPTION
698:
699: WHEN OTHERS THEN
700:
701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: OE_MSG_PUB.Add_Exc_Msg
704: ( G_PKG_NAME
705: , 'Insert_Row'

Line 703: OE_MSG_PUB.Add_Exc_Msg

699: WHEN OTHERS THEN
700:
701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: OE_MSG_PUB.Add_Exc_Msg
704: ( G_PKG_NAME
705: , 'Insert_Row'
706: );
707: END IF;

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

725: EXCEPTION
726:
727: WHEN OTHERS THEN
728:
729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: OE_MSG_PUB.Add_Exc_Msg
732: ( G_PKG_NAME
733: , 'Delete_Row'

Line 731: OE_MSG_PUB.Add_Exc_Msg

727: WHEN OTHERS THEN
728:
729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: OE_MSG_PUB.Add_Exc_Msg
732: ( G_PKG_NAME
733: , 'Delete_Row'
734: );
735: END IF;

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

806: EXCEPTION
807:
808: WHEN OTHERS THEN
809:
810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: OE_MSG_PUB.Add_Exc_Msg
813: ( G_PKG_NAME
814: , 'Query_Row'

Line 812: OE_MSG_PUB.Add_Exc_Msg

808: WHEN OTHERS THEN
809:
810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: OE_MSG_PUB.Add_Exc_Msg
813: ( G_PKG_NAME
814: , 'Query_Row'
815: );
816: END IF;

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

1029:
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1034: THEN
1035:
1036: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
1037: OE_MSG_PUB.Add;

Line 1037: OE_MSG_PUB.Add;

1033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1034: THEN
1035:
1036: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
1037: OE_MSG_PUB.Add;
1038:
1039: END IF;
1040:
1041: END IF;

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

1046:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1049:
1050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1051: THEN
1052:
1053: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1054: OE_MSG_PUB.Add;

Line 1054: OE_MSG_PUB.Add;

1050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1051: THEN
1052:
1053: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1054: OE_MSG_PUB.Add;
1055:
1056: END IF;
1057: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1058:

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

1058:
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: x_Contract_rec.return_status := FND_API.G_RET_STS_ERROR;
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1063: THEN
1064:
1065: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1066: OE_MSG_PUB.Add;

Line 1066: OE_MSG_PUB.Add;

1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1063: THEN
1064:
1065: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1066: OE_MSG_PUB.Add;
1067:
1068: END IF;
1069: WHEN OTHERS THEN
1070:

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

1070:
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: x_Contract_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073:
1074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: OE_MSG_PUB.Add_Exc_Msg
1077: ( G_PKG_NAME
1078: , 'Lock_Row'

Line 1076: OE_MSG_PUB.Add_Exc_Msg

1072: x_Contract_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073:
1074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: OE_MSG_PUB.Add_Exc_Msg
1077: ( G_PKG_NAME
1078: , 'Lock_Row'
1079: );
1080: END IF;

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

1150: IF p_Contract_rec.agreement_id <> FND_API.G_MISS_NUM THEN
1151:
1152: l_Contract_rec.agreement_id := p_Contract_rec.agreement_id;
1153:
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1155: THEN
1156:
1157: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 1159: OE_MSG_PUB.Add;

1155: THEN
1156:
1157: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
1159: OE_MSG_PUB.Add;
1160:
1161: END IF;
1162:
1163: ELSE

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

1180: IF p_Contract_rec.discount_id <> FND_API.G_MISS_NUM THEN
1181:
1182: l_Contract_rec.discount_id := p_Contract_rec.discount_id;
1183:
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1185: THEN
1186:
1187: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');

Line 1189: OE_MSG_PUB.Add;

1185: THEN
1186:
1187: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
1189: OE_MSG_PUB.Add;
1190:
1191: END IF;
1192:
1193: ELSE

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

1210: IF p_Contract_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1211:
1212: l_Contract_rec.price_list_id := p_Contract_rec.price_list_id;
1213:
1214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1215: THEN
1216:
1217: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 1219: OE_MSG_PUB.Add;

1215: THEN
1216:
1217: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1219: OE_MSG_PUB.Add;
1220:
1221: END IF;
1222:
1223: ELSE