DBA Data[Home] [Help]

APPS.QP_VALIDATE_CURR_DETAILS dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Curr_Details AS

1: PACKAGE BODY QP_Validate_Curr_Details AS
2: /* $Header: QPXLCDTB.pls 120.3 2006/01/03 04:18:30 srashmi noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Curr_Details';

2: /* $Header: QPXLCDTB.pls 120.3 2006/01/03 04:18:30 srashmi noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Curr_Details';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 869: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor,

865:
866: oe_debug_pub.add('ENTITY - before rounding_factor');
867: IF p_CURR_DETAILS_rec.rounding_factor IS NOT NULL AND
868: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
869: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor,
870: p_CURR_DETAILS_rec.to_currency_code) THEN
871: oe_debug_pub.add('ENTITY rounding_factor error occured');
872: l_return_status := FND_API.G_RET_STS_ERROR;
873: END IF;

Line 879: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor,

875:
876: oe_debug_pub.add('ENTITY - before selling rounding_factor');
877: IF p_CURR_DETAILS_rec.selling_rounding_factor IS NOT NULL AND
878: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
879: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor,
880: p_CURR_DETAILS_rec.to_currency_code) THEN
881: oe_debug_pub.add('ENTITY selling_rounding_factor error occured');
882: l_return_status := FND_API.G_RET_STS_ERROR;
883: END IF;

Line 1043: IF NOT QP_Validate.Conversion_Date(p_CURR_DETAILS_rec.conversion_date) THEN

1039: ( p_CURR_DETAILS_rec.conversion_date <>
1040: p_old_CURR_DETAILS_rec.conversion_date OR
1041: p_old_CURR_DETAILS_rec.conversion_date IS NULL )
1042: THEN
1043: IF NOT QP_Validate.Conversion_Date(p_CURR_DETAILS_rec.conversion_date) THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF;
1047:

Line 1053: IF NOT QP_Validate.Conversion_Date_Type(p_CURR_DETAILS_rec.conversion_date_type) THEN

1049: ( p_CURR_DETAILS_rec.conversion_date_type <>
1050: p_old_CURR_DETAILS_rec.conversion_date_type OR
1051: p_old_CURR_DETAILS_rec.conversion_date_type IS NULL )
1052: THEN
1053: IF NOT QP_Validate.Conversion_Date_Type(p_CURR_DETAILS_rec.conversion_date_type) THEN
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: END IF;
1056: END IF;
1057:

Line 1064: IF NOT QP_Validate.Conversion_Method(p_CURR_DETAILS_rec.conversion_method) THEN

1060: ( p_CURR_DETAILS_rec.conversion_method <>
1061: p_old_CURR_DETAILS_rec.conversion_method OR
1062: p_old_CURR_DETAILS_rec.conversion_method IS NULL )
1063: THEN
1064: IF NOT QP_Validate.Conversion_Method(p_CURR_DETAILS_rec.conversion_method) THEN
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: END IF;
1067: END IF;
1068: */

Line 1075: IF NOT QP_Validate.Conversion_Type(p_CURR_DETAILS_rec.conversion_type) THEN

1071: ( p_CURR_DETAILS_rec.conversion_type <>
1072: p_old_CURR_DETAILS_rec.conversion_type OR
1073: p_old_CURR_DETAILS_rec.conversion_type IS NULL )
1074: THEN
1075: IF NOT QP_Validate.Conversion_Type(p_CURR_DETAILS_rec.conversion_type) THEN
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: END IF;
1078: END IF;
1079:

Line 1085: IF NOT QP_Validate.Created_By(p_CURR_DETAILS_rec.created_by) THEN

1081: ( p_CURR_DETAILS_rec.created_by <>
1082: p_old_CURR_DETAILS_rec.created_by OR
1083: p_old_CURR_DETAILS_rec.created_by IS NULL )
1084: THEN
1085: IF NOT QP_Validate.Created_By(p_CURR_DETAILS_rec.created_by) THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: END IF;
1088: END IF;
1089:

Line 1095: IF NOT QP_Validate.Creation_Date(p_CURR_DETAILS_rec.creation_date) THEN

1091: ( p_CURR_DETAILS_rec.creation_date <>
1092: p_old_CURR_DETAILS_rec.creation_date OR
1093: p_old_CURR_DETAILS_rec.creation_date IS NULL )
1094: THEN
1095: IF NOT QP_Validate.Creation_Date(p_CURR_DETAILS_rec.creation_date) THEN
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098: END IF;
1099:

Line 1105: IF NOT QP_Validate.Currency_Detail(p_CURR_DETAILS_rec.currency_detail_id) THEN

1101: ( p_CURR_DETAILS_rec.currency_detail_id <>
1102: p_old_CURR_DETAILS_rec.currency_detail_id OR
1103: p_old_CURR_DETAILS_rec.currency_detail_id IS NULL )
1104: THEN
1105: IF NOT QP_Validate.Currency_Detail(p_CURR_DETAILS_rec.currency_detail_id) THEN
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: END IF;
1108: END IF;
1109:

Line 1115: IF NOT QP_Validate.Currency_Header(p_CURR_DETAILS_rec.currency_header_id) THEN

1111: ( p_CURR_DETAILS_rec.currency_header_id <>
1112: p_old_CURR_DETAILS_rec.currency_header_id OR
1113: p_old_CURR_DETAILS_rec.currency_header_id IS NULL )
1114: THEN
1115: IF NOT QP_Validate.Currency_Header(p_CURR_DETAILS_rec.currency_header_id) THEN
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117: END IF;
1118: END IF;
1119:

Line 1125: IF NOT QP_Validate.End_Date_Active(p_CURR_DETAILS_rec.end_date_active) THEN

1121: ( p_CURR_DETAILS_rec.end_date_active <>
1122: p_old_CURR_DETAILS_rec.end_date_active OR
1123: p_old_CURR_DETAILS_rec.end_date_active IS NULL )
1124: THEN
1125: IF NOT QP_Validate.End_Date_Active(p_CURR_DETAILS_rec.end_date_active) THEN
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: END IF;
1129:

Line 1135: IF NOT QP_Validate.Fixed_Value(p_CURR_DETAILS_rec.fixed_value) THEN

1131: ( p_CURR_DETAILS_rec.fixed_value <>
1132: p_old_CURR_DETAILS_rec.fixed_value OR
1133: p_old_CURR_DETAILS_rec.fixed_value IS NULL )
1134: THEN
1135: IF NOT QP_Validate.Fixed_Value(p_CURR_DETAILS_rec.fixed_value) THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: END IF;
1138: END IF;
1139:

Line 1145: IF NOT QP_Validate.Last_Updated_By(p_CURR_DETAILS_rec.last_updated_by) THEN

1141: ( p_CURR_DETAILS_rec.last_updated_by <>
1142: p_old_CURR_DETAILS_rec.last_updated_by OR
1143: p_old_CURR_DETAILS_rec.last_updated_by IS NULL )
1144: THEN
1145: IF NOT QP_Validate.Last_Updated_By(p_CURR_DETAILS_rec.last_updated_by) THEN
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: END IF;
1148: END IF;
1149:

Line 1155: IF NOT QP_Validate.Last_Update_Date(p_CURR_DETAILS_rec.last_update_date) THEN

1151: ( p_CURR_DETAILS_rec.last_update_date <>
1152: p_old_CURR_DETAILS_rec.last_update_date OR
1153: p_old_CURR_DETAILS_rec.last_update_date IS NULL )
1154: THEN
1155: IF NOT QP_Validate.Last_Update_Date(p_CURR_DETAILS_rec.last_update_date) THEN
1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: END IF;
1158: END IF;
1159:

Line 1165: IF NOT QP_Validate.Last_Update_Login(p_CURR_DETAILS_rec.last_update_login) THEN

1161: ( p_CURR_DETAILS_rec.last_update_login <>
1162: p_old_CURR_DETAILS_rec.last_update_login OR
1163: p_old_CURR_DETAILS_rec.last_update_login IS NULL )
1164: THEN
1165: IF NOT QP_Validate.Last_Update_Login(p_CURR_DETAILS_rec.last_update_login) THEN
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168: END IF;
1169:

Line 1175: IF NOT QP_Validate.Markup_Formula(p_CURR_DETAILS_rec.markup_formula_id) THEN

1171: ( p_CURR_DETAILS_rec.markup_formula_id <>
1172: p_old_CURR_DETAILS_rec.markup_formula_id OR
1173: p_old_CURR_DETAILS_rec.markup_formula_id IS NULL )
1174: THEN
1175: IF NOT QP_Validate.Markup_Formula(p_CURR_DETAILS_rec.markup_formula_id) THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: END IF;
1178: END IF;
1179:

Line 1185: IF NOT QP_Validate.Markup_Operator(p_CURR_DETAILS_rec.markup_operator) THEN

1181: ( p_CURR_DETAILS_rec.markup_operator <>
1182: p_old_CURR_DETAILS_rec.markup_operator OR
1183: p_old_CURR_DETAILS_rec.markup_operator IS NULL )
1184: THEN
1185: IF NOT QP_Validate.Markup_Operator(p_CURR_DETAILS_rec.markup_operator) THEN
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: END IF;
1188: END IF;
1189:

Line 1195: IF NOT QP_Validate.Markup_Value(p_CURR_DETAILS_rec.markup_value) THEN

1191: ( p_CURR_DETAILS_rec.markup_value <>
1192: p_old_CURR_DETAILS_rec.markup_value OR
1193: p_old_CURR_DETAILS_rec.markup_value IS NULL )
1194: THEN
1195: IF NOT QP_Validate.Markup_Value(p_CURR_DETAILS_rec.markup_value) THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: END IF;
1198: END IF;
1199:

Line 1205: IF NOT QP_Validate.Price_Formula(p_CURR_DETAILS_rec.price_formula_id) THEN

1201: ( p_CURR_DETAILS_rec.price_formula_id <>
1202: p_old_CURR_DETAILS_rec.price_formula_id OR
1203: p_old_CURR_DETAILS_rec.price_formula_id IS NULL )
1204: THEN
1205: IF NOT QP_Validate.Price_Formula(p_CURR_DETAILS_rec.price_formula_id) THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: END IF;
1208: END IF;
1209:

Line 1215: IF NOT QP_Validate.Program_Application(p_CURR_DETAILS_rec.program_application_id) THEN

1211: ( p_CURR_DETAILS_rec.program_application_id <>
1212: p_old_CURR_DETAILS_rec.program_application_id OR
1213: p_old_CURR_DETAILS_rec.program_application_id IS NULL )
1214: THEN
1215: IF NOT QP_Validate.Program_Application(p_CURR_DETAILS_rec.program_application_id) THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: END IF;
1218: END IF;
1219:

Line 1225: IF NOT QP_Validate.Program(p_CURR_DETAILS_rec.program_id) THEN

1221: ( p_CURR_DETAILS_rec.program_id <>
1222: p_old_CURR_DETAILS_rec.program_id OR
1223: p_old_CURR_DETAILS_rec.program_id IS NULL )
1224: THEN
1225: IF NOT QP_Validate.Program(p_CURR_DETAILS_rec.program_id) THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: END IF;
1228: END IF;
1229:

Line 1235: IF NOT QP_Validate.Program_Update_Date(p_CURR_DETAILS_rec.program_update_date) THEN

1231: ( p_CURR_DETAILS_rec.program_update_date <>
1232: p_old_CURR_DETAILS_rec.program_update_date OR
1233: p_old_CURR_DETAILS_rec.program_update_date IS NULL )
1234: THEN
1235: IF NOT QP_Validate.Program_Update_Date(p_CURR_DETAILS_rec.program_update_date) THEN
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: END IF;
1238: END IF;
1239:

Line 1245: IF NOT QP_Validate.Request(p_CURR_DETAILS_rec.request_id) THEN

1241: ( p_CURR_DETAILS_rec.request_id <>
1242: p_old_CURR_DETAILS_rec.request_id OR
1243: p_old_CURR_DETAILS_rec.request_id IS NULL )
1244: THEN
1245: IF NOT QP_Validate.Request(p_CURR_DETAILS_rec.request_id) THEN
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: END IF;
1248: END IF;
1249:

Line 1255: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor) THEN

1251: ( p_CURR_DETAILS_rec.rounding_factor <>
1252: p_old_CURR_DETAILS_rec.rounding_factor OR
1253: p_old_CURR_DETAILS_rec.rounding_factor IS NULL )
1254: THEN
1255: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor) THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258: END IF;
1259:

Line 1265: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor) THEN

1261: ( p_CURR_DETAILS_rec.selling_rounding_factor <>
1262: p_old_CURR_DETAILS_rec.selling_rounding_factor OR
1263: p_old_CURR_DETAILS_rec.selling_rounding_factor IS NULL )
1264: THEN
1265: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor) THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: END IF;
1268: END IF;
1269:

Line 1275: IF NOT QP_Validate.Start_Date_Active(p_CURR_DETAILS_rec.start_date_active) THEN

1271: ( p_CURR_DETAILS_rec.start_date_active <>
1272: p_old_CURR_DETAILS_rec.start_date_active OR
1273: p_old_CURR_DETAILS_rec.start_date_active IS NULL )
1274: THEN
1275: IF NOT QP_Validate.Start_Date_Active(p_CURR_DETAILS_rec.start_date_active) THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: END IF;
1278: END IF;
1279:

Line 1285: IF NOT QP_Validate.To_Currency(p_CURR_DETAILS_rec.to_currency_code) THEN

1281: ( p_CURR_DETAILS_rec.to_currency_code <>
1282: p_old_CURR_DETAILS_rec.to_currency_code OR
1283: p_old_CURR_DETAILS_rec.to_currency_code IS NULL )
1284: THEN
1285: IF NOT QP_Validate.To_Currency(p_CURR_DETAILS_rec.to_currency_code) THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: END IF;
1288: END IF;
1289:

Line 1295: IF NOT QP_Validate.Curr_Attribute_Type(p_CURR_DETAILS_rec.curr_attribute_type) THEN

1291: ( p_CURR_DETAILS_rec.curr_attribute_type <>
1292: p_old_CURR_DETAILS_rec.curr_attribute_type OR
1293: p_old_CURR_DETAILS_rec.curr_attribute_type IS NULL )
1294: THEN
1295: IF NOT QP_Validate.Curr_Attribute_Type(p_CURR_DETAILS_rec.curr_attribute_type) THEN
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: END IF;
1298: END IF;
1299:

Line 1305: IF NOT QP_Validate.Curr_Attribute_Context(p_CURR_DETAILS_rec.curr_attribute_context) THEN

1301: ( p_CURR_DETAILS_rec.curr_attribute_context <>
1302: p_old_CURR_DETAILS_rec.curr_attribute_context OR
1303: p_old_CURR_DETAILS_rec.curr_attribute_context IS NULL )
1304: THEN
1305: IF NOT QP_Validate.Curr_Attribute_Context(p_CURR_DETAILS_rec.curr_attribute_context) THEN
1306: x_return_status := FND_API.G_RET_STS_ERROR;
1307: END IF;
1308: END IF;
1309:

Line 1315: IF NOT QP_Validate.Curr_Attribute(p_CURR_DETAILS_rec.curr_attribute) THEN

1311: ( p_CURR_DETAILS_rec.curr_attribute <>
1312: p_old_CURR_DETAILS_rec.curr_attribute OR
1313: p_old_CURR_DETAILS_rec.curr_attribute IS NULL )
1314: THEN
1315: IF NOT QP_Validate.Curr_Attribute(p_CURR_DETAILS_rec.curr_attribute) THEN
1316: x_return_status := FND_API.G_RET_STS_ERROR;
1317: END IF;
1318: END IF;
1319:

Line 1325: IF NOT QP_Validate.Curr_Attribute_Value(p_CURR_DETAILS_rec.curr_attribute_value) THEN

1321: ( p_CURR_DETAILS_rec.curr_attribute_value <>
1322: p_old_CURR_DETAILS_rec.curr_attribute_value OR
1323: p_old_CURR_DETAILS_rec.curr_attribute_value IS NULL )
1324: THEN
1325: IF NOT QP_Validate.Curr_Attribute_Value(p_CURR_DETAILS_rec.curr_attribute_value) THEN
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: END IF;
1328: END IF;
1329:

Line 1335: IF NOT QP_Validate.Precedence(p_CURR_DETAILS_rec.precedence) THEN

1331: ( p_CURR_DETAILS_rec.precedence <>
1332: p_old_CURR_DETAILS_rec.precedence OR
1333: p_old_CURR_DETAILS_rec.precedence IS NULL )
1334: THEN
1335: IF NOT QP_Validate.Precedence(p_CURR_DETAILS_rec.precedence) THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: END IF;
1338: END IF;
1339:

Line 1477: IF NOT QP_Validate.Desc_Flex( 'CURR_DETAILS' ) THEN

1473: */
1474:
1475: -- Validate descriptive flexfield.
1476:
1477: IF NOT QP_Validate.Desc_Flex( 'CURR_DETAILS' ) THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: END IF;
1480:
1481: END IF;

Line 1551: END QP_Validate_Curr_Details;

1547: END IF;
1548:
1549: END Entity_Delete;
1550:
1551: END QP_Validate_Curr_Details;