APPS.QP_MODIFIER_LIST_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type

Line 33: IF p_attr_id = FND_API.G_MISS_NUM THEN

29:
30: -- If attr_id is missing compare old and new records and for
31: -- every changed attribute clear its dependent fields.
32:
33: IF p_attr_id = FND_API.G_MISS_NUM THEN
34:
35: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)
36: THEN
37: l_index := l_index + 1;

Line 1328: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1324: BEGIN
1325:
1326: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');
1327:
1328: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1329: l_MODIFIER_LIST_rec.attribute1 := p_old_MODIFIER_LIST_rec.attribute1;
1330: END IF;
1331:
1332: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1332: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1328: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1329: l_MODIFIER_LIST_rec.attribute1 := p_old_MODIFIER_LIST_rec.attribute1;
1330: END IF;
1331:
1332: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1333: l_MODIFIER_LIST_rec.attribute10 := p_old_MODIFIER_LIST_rec.attribute10;
1334: END IF;
1335:
1336: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1336: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1332: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1333: l_MODIFIER_LIST_rec.attribute10 := p_old_MODIFIER_LIST_rec.attribute10;
1334: END IF;
1335:
1336: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1337: l_MODIFIER_LIST_rec.attribute11 := p_old_MODIFIER_LIST_rec.attribute11;
1338: END IF;
1339:
1340: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1340: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1336: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1337: l_MODIFIER_LIST_rec.attribute11 := p_old_MODIFIER_LIST_rec.attribute11;
1338: END IF;
1339:
1340: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1341: l_MODIFIER_LIST_rec.attribute12 := p_old_MODIFIER_LIST_rec.attribute12;
1342: END IF;
1343:
1344: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1344: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1340: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1341: l_MODIFIER_LIST_rec.attribute12 := p_old_MODIFIER_LIST_rec.attribute12;
1342: END IF;
1343:
1344: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1345: l_MODIFIER_LIST_rec.attribute13 := p_old_MODIFIER_LIST_rec.attribute13;
1346: END IF;
1347:
1348: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1348: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1344: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1345: l_MODIFIER_LIST_rec.attribute13 := p_old_MODIFIER_LIST_rec.attribute13;
1346: END IF;
1347:
1348: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1349: l_MODIFIER_LIST_rec.attribute14 := p_old_MODIFIER_LIST_rec.attribute14;
1350: END IF;
1351:
1352: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1352: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1348: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1349: l_MODIFIER_LIST_rec.attribute14 := p_old_MODIFIER_LIST_rec.attribute14;
1350: END IF;
1351:
1352: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1353: l_MODIFIER_LIST_rec.attribute15 := p_old_MODIFIER_LIST_rec.attribute15;
1354: END IF;
1355:
1356: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1356: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1352: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1353: l_MODIFIER_LIST_rec.attribute15 := p_old_MODIFIER_LIST_rec.attribute15;
1354: END IF;
1355:
1356: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1357: l_MODIFIER_LIST_rec.attribute2 := p_old_MODIFIER_LIST_rec.attribute2;
1358: END IF;
1359:
1360: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1360: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1356: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1357: l_MODIFIER_LIST_rec.attribute2 := p_old_MODIFIER_LIST_rec.attribute2;
1358: END IF;
1359:
1360: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1361: l_MODIFIER_LIST_rec.attribute3 := p_old_MODIFIER_LIST_rec.attribute3;
1362: END IF;
1363:
1364: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1364: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1360: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1361: l_MODIFIER_LIST_rec.attribute3 := p_old_MODIFIER_LIST_rec.attribute3;
1362: END IF;
1363:
1364: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1365: l_MODIFIER_LIST_rec.attribute4 := p_old_MODIFIER_LIST_rec.attribute4;
1366: END IF;
1367:
1368: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1368: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1364: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1365: l_MODIFIER_LIST_rec.attribute4 := p_old_MODIFIER_LIST_rec.attribute4;
1366: END IF;
1367:
1368: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1369: l_MODIFIER_LIST_rec.attribute5 := p_old_MODIFIER_LIST_rec.attribute5;
1370: END IF;
1371:
1372: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1372: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1368: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1369: l_MODIFIER_LIST_rec.attribute5 := p_old_MODIFIER_LIST_rec.attribute5;
1370: END IF;
1371:
1372: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1373: l_MODIFIER_LIST_rec.attribute6 := p_old_MODIFIER_LIST_rec.attribute6;
1374: END IF;
1375:
1376: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1376: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1372: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1373: l_MODIFIER_LIST_rec.attribute6 := p_old_MODIFIER_LIST_rec.attribute6;
1374: END IF;
1375:
1376: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1377: l_MODIFIER_LIST_rec.attribute7 := p_old_MODIFIER_LIST_rec.attribute7;
1378: END IF;
1379:
1380: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1380: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1376: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1377: l_MODIFIER_LIST_rec.attribute7 := p_old_MODIFIER_LIST_rec.attribute7;
1378: END IF;
1379:
1380: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1381: l_MODIFIER_LIST_rec.attribute8 := p_old_MODIFIER_LIST_rec.attribute8;
1382: END IF;
1383:
1384: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1384: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1380: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1381: l_MODIFIER_LIST_rec.attribute8 := p_old_MODIFIER_LIST_rec.attribute8;
1382: END IF;
1383:
1384: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1385: l_MODIFIER_LIST_rec.attribute9 := p_old_MODIFIER_LIST_rec.attribute9;
1386: END IF;
1387:
1388: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1388: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1384: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1385: l_MODIFIER_LIST_rec.attribute9 := p_old_MODIFIER_LIST_rec.attribute9;
1386: END IF;
1387:
1388: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1389: l_MODIFIER_LIST_rec.automatic_flag := p_old_MODIFIER_LIST_rec.automatic_flag;
1390: END IF;
1391:
1392: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1392: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1388: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1389: l_MODIFIER_LIST_rec.automatic_flag := p_old_MODIFIER_LIST_rec.automatic_flag;
1390: END IF;
1391:
1392: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1393: l_MODIFIER_LIST_rec.comments := p_old_MODIFIER_LIST_rec.comments;
1394: END IF;
1395:
1396: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1396: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1392: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1393: l_MODIFIER_LIST_rec.comments := p_old_MODIFIER_LIST_rec.comments;
1394: END IF;
1395:
1396: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1397: l_MODIFIER_LIST_rec.context := p_old_MODIFIER_LIST_rec.context;
1398: END IF;
1399:
1400: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1400: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1396: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1397: l_MODIFIER_LIST_rec.context := p_old_MODIFIER_LIST_rec.context;
1398: END IF;
1399:
1400: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1401: l_MODIFIER_LIST_rec.created_by := p_old_MODIFIER_LIST_rec.created_by;
1402: END IF;
1403:
1404: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1404: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1400: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1401: l_MODIFIER_LIST_rec.created_by := p_old_MODIFIER_LIST_rec.created_by;
1402: END IF;
1403:
1404: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1405: l_MODIFIER_LIST_rec.creation_date := p_old_MODIFIER_LIST_rec.creation_date;
1406: END IF;
1407:
1408: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1408: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1404: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1405: l_MODIFIER_LIST_rec.creation_date := p_old_MODIFIER_LIST_rec.creation_date;
1406: END IF;
1407:
1408: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1409: l_MODIFIER_LIST_rec.currency_code := p_old_MODIFIER_LIST_rec.currency_code;
1410: END IF;
1411:
1412: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1412: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1408: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1409: l_MODIFIER_LIST_rec.currency_code := p_old_MODIFIER_LIST_rec.currency_code;
1410: END IF;
1411:
1412: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1413: l_MODIFIER_LIST_rec.discount_lines_flag := p_old_MODIFIER_LIST_rec.discount_lines_flag;
1414: END IF;
1415:
1416: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1416: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1412: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1413: l_MODIFIER_LIST_rec.discount_lines_flag := p_old_MODIFIER_LIST_rec.discount_lines_flag;
1414: END IF;
1415:
1416: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1417: l_MODIFIER_LIST_rec.end_date_active := p_old_MODIFIER_LIST_rec.end_date_active;
1418: END IF;
1419:
1420: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1420: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1416: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1417: l_MODIFIER_LIST_rec.end_date_active := p_old_MODIFIER_LIST_rec.end_date_active;
1418: END IF;
1419:
1420: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1421: l_MODIFIER_LIST_rec.freight_terms_code := p_old_MODIFIER_LIST_rec.freight_terms_code;
1422: END IF;
1423:
1424: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1424: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1420: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1421: l_MODIFIER_LIST_rec.freight_terms_code := p_old_MODIFIER_LIST_rec.freight_terms_code;
1422: END IF;
1423:
1424: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1425: l_MODIFIER_LIST_rec.gsa_indicator := p_old_MODIFIER_LIST_rec.gsa_indicator;
1426: END IF;
1427:
1428: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1428: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1424: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1425: l_MODIFIER_LIST_rec.gsa_indicator := p_old_MODIFIER_LIST_rec.gsa_indicator;
1426: END IF;
1427:
1428: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1429: l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
1430: END IF;
1431:
1432: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1432: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1428: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1429: l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
1430: END IF;
1431:
1432: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1433: l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
1434: END IF;
1435:
1436: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1436: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1432: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1433: l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
1434: END IF;
1435:
1436: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1437: l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
1438: END IF;
1439:
1440: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1440: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1436: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1437: l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
1438: END IF;
1439:
1440: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1441: l_MODIFIER_LIST_rec.list_header_id := p_old_MODIFIER_LIST_rec.list_header_id;
1442: END IF;
1443:
1444: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1444: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1440: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1441: l_MODIFIER_LIST_rec.list_header_id := p_old_MODIFIER_LIST_rec.list_header_id;
1442: END IF;
1443:
1444: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1445: l_MODIFIER_LIST_rec.list_type_code := p_old_MODIFIER_LIST_rec.list_type_code;
1446: END IF;
1447:
1448: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1448: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1444: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1445: l_MODIFIER_LIST_rec.list_type_code := p_old_MODIFIER_LIST_rec.list_type_code;
1446: END IF;
1447:
1448: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1449: l_MODIFIER_LIST_rec.program_application_id := p_old_MODIFIER_LIST_rec.program_application_id;
1450: END IF;
1451:
1452: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1452: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1448: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1449: l_MODIFIER_LIST_rec.program_application_id := p_old_MODIFIER_LIST_rec.program_application_id;
1450: END IF;
1451:
1452: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1453: l_MODIFIER_LIST_rec.program_id := p_old_MODIFIER_LIST_rec.program_id;
1454: END IF;
1455:
1456: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1456: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1452: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1453: l_MODIFIER_LIST_rec.program_id := p_old_MODIFIER_LIST_rec.program_id;
1454: END IF;
1455:
1456: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1457: l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
1458: END IF;
1459:
1460: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1460: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1456: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1457: l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
1458: END IF;
1459:
1460: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1461: l_MODIFIER_LIST_rec.prorate_flag := p_old_MODIFIER_LIST_rec.prorate_flag;
1462: END IF;
1463:
1464: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1464: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1460: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1461: l_MODIFIER_LIST_rec.prorate_flag := p_old_MODIFIER_LIST_rec.prorate_flag;
1462: END IF;
1463:
1464: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1465: l_MODIFIER_LIST_rec.request_id := p_old_MODIFIER_LIST_rec.request_id;
1466: END IF;
1467:
1468: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1468: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1464: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1465: l_MODIFIER_LIST_rec.request_id := p_old_MODIFIER_LIST_rec.request_id;
1466: END IF;
1467:
1468: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1469: l_MODIFIER_LIST_rec.rounding_factor := p_old_MODIFIER_LIST_rec.rounding_factor;
1470: END IF;
1471:
1472: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1472: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1468: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1469: l_MODIFIER_LIST_rec.rounding_factor := p_old_MODIFIER_LIST_rec.rounding_factor;
1470: END IF;
1471:
1472: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1473: l_MODIFIER_LIST_rec.ship_method_code := p_old_MODIFIER_LIST_rec.ship_method_code;
1474: END IF;
1475:
1476: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1476: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1472: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1473: l_MODIFIER_LIST_rec.ship_method_code := p_old_MODIFIER_LIST_rec.ship_method_code;
1474: END IF;
1475:
1476: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1477: l_MODIFIER_LIST_rec.start_date_active := p_old_MODIFIER_LIST_rec.start_date_active;
1478: END IF;
1479:
1480: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1480: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1476: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1477: l_MODIFIER_LIST_rec.start_date_active := p_old_MODIFIER_LIST_rec.start_date_active;
1478: END IF;
1479:
1480: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1481: l_MODIFIER_LIST_rec.terms_id := p_old_MODIFIER_LIST_rec.terms_id;
1482: END IF;
1483:
1484: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

Line 1484: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

1480: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1481: l_MODIFIER_LIST_rec.terms_id := p_old_MODIFIER_LIST_rec.terms_id;
1482: END IF;
1483:
1484: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1485: l_MODIFIER_LIST_rec.source_system_code := p_old_MODIFIER_LIST_rec.source_system_code;
1486: END IF;
1487:
1488: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 1488: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

1484: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1485: l_MODIFIER_LIST_rec.source_system_code := p_old_MODIFIER_LIST_rec.source_system_code;
1486: END IF;
1487:
1488: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1489: l_MODIFIER_LIST_rec.pte_code := p_old_MODIFIER_LIST_rec.pte_code;
1490: END IF;
1491:
1492: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

Line 1492: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

1488: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1489: l_MODIFIER_LIST_rec.pte_code := p_old_MODIFIER_LIST_rec.pte_code;
1490: END IF;
1491:
1492: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1493: l_MODIFIER_LIST_rec.active_flag := p_old_MODIFIER_LIST_rec.active_flag;
1494: END IF;
1495:
1496: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

Line 1496: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

1492: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1493: l_MODIFIER_LIST_rec.active_flag := p_old_MODIFIER_LIST_rec.active_flag;
1494: END IF;
1495:
1496: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1497: l_MODIFIER_LIST_rec.parent_list_header_id := p_old_MODIFIER_LIST_rec.parent_list_header_id;
1498: END IF;
1499:
1500: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

Line 1500: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

1496: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1497: l_MODIFIER_LIST_rec.parent_list_header_id := p_old_MODIFIER_LIST_rec.parent_list_header_id;
1498: END IF;
1499:
1500: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1501: l_MODIFIER_LIST_rec.start_date_active_first := p_old_MODIFIER_LIST_rec.start_date_active_first;
1502: END IF;
1503:
1504: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

Line 1504: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

1500: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1501: l_MODIFIER_LIST_rec.start_date_active_first := p_old_MODIFIER_LIST_rec.start_date_active_first;
1502: END IF;
1503:
1504: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1505: l_MODIFIER_LIST_rec.end_date_active_first := p_old_MODIFIER_LIST_rec.end_date_active_first;
1506: END IF;
1507:
1508: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

Line 1508: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

1504: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1505: l_MODIFIER_LIST_rec.end_date_active_first := p_old_MODIFIER_LIST_rec.end_date_active_first;
1506: END IF;
1507:
1508: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1509: l_MODIFIER_LIST_rec.active_date_first_type := p_old_MODIFIER_LIST_rec.active_date_first_type;
1510: END IF;
1511:
1512: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

Line 1512: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

1508: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1509: l_MODIFIER_LIST_rec.active_date_first_type := p_old_MODIFIER_LIST_rec.active_date_first_type;
1510: END IF;
1511:
1512: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1513: l_MODIFIER_LIST_rec.start_date_active_second := p_old_MODIFIER_LIST_rec.start_date_active_second;
1514: END IF;
1515:
1516: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

Line 1516: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

1512: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1513: l_MODIFIER_LIST_rec.start_date_active_second := p_old_MODIFIER_LIST_rec.start_date_active_second;
1514: END IF;
1515:
1516: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1517: l_MODIFIER_LIST_rec.global_flag := p_old_MODIFIER_LIST_rec.global_flag;
1518: END IF;
1519:
1520:

Line 1521: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN

1517: l_MODIFIER_LIST_rec.global_flag := p_old_MODIFIER_LIST_rec.global_flag;
1518: END IF;
1519:
1520:
1521: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1522: l_MODIFIER_LIST_rec.end_date_active_second := p_old_MODIFIER_LIST_rec.end_date_active_second;
1523: END IF;
1524:
1525: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

Line 1525: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

1521: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1522: l_MODIFIER_LIST_rec.end_date_active_second := p_old_MODIFIER_LIST_rec.end_date_active_second;
1523: END IF;
1524:
1525: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1526: l_MODIFIER_LIST_rec.active_date_second_type := p_old_MODIFIER_LIST_rec.active_date_second_type;
1527: END IF;
1528:
1529: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

Line 1529: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

1525: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1526: l_MODIFIER_LIST_rec.active_date_second_type := p_old_MODIFIER_LIST_rec.active_date_second_type;
1527: END IF;
1528:
1529: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1530: l_MODIFIER_LIST_rec.ask_for_flag := p_old_MODIFIER_LIST_rec.ask_for_flag;
1531: END IF;
1532:
1533: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1533: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1529: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1530: l_MODIFIER_LIST_rec.ask_for_flag := p_old_MODIFIER_LIST_rec.ask_for_flag;
1531: END IF;
1532:
1533: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1534: l_MODIFIER_LIST_rec.name := p_old_MODIFIER_LIST_rec.name;
1535: END IF;
1536:
1537: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

Line 1537: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN

1533: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1534: l_MODIFIER_LIST_rec.name := p_old_MODIFIER_LIST_rec.name;
1535: END IF;
1536:
1537: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1538: l_MODIFIER_LIST_rec.version_no := p_old_MODIFIER_LIST_rec.version_no;
1539: END IF;
1540:
1541: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 1541: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1537: IF l_MODIFIER_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1538: l_MODIFIER_LIST_rec.version_no := p_old_MODIFIER_LIST_rec.version_no;
1539: END IF;
1540:
1541: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1542: l_MODIFIER_LIST_rec.description := p_old_MODIFIER_LIST_rec.description;
1543: END IF;
1544:
1545: -- Blanket Agreement Pricing bug#3871577

Line 1546: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN

1542: l_MODIFIER_LIST_rec.description := p_old_MODIFIER_LIST_rec.description;
1543: END IF;
1544:
1545: -- Blanket Agreement Pricing bug#3871577
1546: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1547: l_MODIFIER_LIST_rec.list_source_code := p_old_MODIFIER_LIST_rec.list_source_code;
1548: END IF;
1549:
1550: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

Line 1550: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN

1546: IF l_MODIFIER_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1547: l_MODIFIER_LIST_rec.list_source_code := p_old_MODIFIER_LIST_rec.list_source_code;
1548: END IF;
1549:
1550: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1551: l_MODIFIER_LIST_rec.orig_system_header_ref := p_old_MODIFIER_LIST_rec.orig_system_header_ref;
1552: END IF;
1553:
1554: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

Line 1554: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN

1550: IF l_MODIFIER_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1551: l_MODIFIER_LIST_rec.orig_system_header_ref := p_old_MODIFIER_LIST_rec.orig_system_header_ref;
1552: END IF;
1553:
1554: IF l_MODIFIER_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1555: l_MODIFIER_LIST_rec.shareable_flag := p_old_MODIFIER_LIST_rec.shareable_flag;
1556: END IF;
1557:
1558: --added for MOAC

Line 1559: IF l_MODIFIER_LIST_rec.org_id = FND_API.G_MISS_NUM THEN

1555: l_MODIFIER_LIST_rec.shareable_flag := p_old_MODIFIER_LIST_rec.shareable_flag;
1556: END IF;
1557:
1558: --added for MOAC
1559: IF l_MODIFIER_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1560: l_MODIFIER_LIST_rec.org_id := p_old_MODIFIER_LIST_rec.org_id;
1561: END IF;
1562:
1563: oe_debug_pub.add('version QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

Line 1580: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1576: BEGIN
1577:
1578: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');
1579:
1580: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1581: l_MODIFIER_LIST_rec.attribute1 := NULL;
1582: END IF;
1583:
1584: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1584: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1580: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1581: l_MODIFIER_LIST_rec.attribute1 := NULL;
1582: END IF;
1583:
1584: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1585: l_MODIFIER_LIST_rec.attribute10 := NULL;
1586: END IF;
1587:
1588: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1588: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1584: IF l_MODIFIER_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1585: l_MODIFIER_LIST_rec.attribute10 := NULL;
1586: END IF;
1587:
1588: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1589: l_MODIFIER_LIST_rec.attribute11 := NULL;
1590: END IF;
1591:
1592: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1592: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1588: IF l_MODIFIER_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1589: l_MODIFIER_LIST_rec.attribute11 := NULL;
1590: END IF;
1591:
1592: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1593: l_MODIFIER_LIST_rec.attribute12 := NULL;
1594: END IF;
1595:
1596: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1596: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1592: IF l_MODIFIER_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1593: l_MODIFIER_LIST_rec.attribute12 := NULL;
1594: END IF;
1595:
1596: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1597: l_MODIFIER_LIST_rec.attribute13 := NULL;
1598: END IF;
1599:
1600: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1600: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1596: IF l_MODIFIER_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1597: l_MODIFIER_LIST_rec.attribute13 := NULL;
1598: END IF;
1599:
1600: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1601: l_MODIFIER_LIST_rec.attribute14 := NULL;
1602: END IF;
1603:
1604: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1604: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1600: IF l_MODIFIER_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1601: l_MODIFIER_LIST_rec.attribute14 := NULL;
1602: END IF;
1603:
1604: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1605: l_MODIFIER_LIST_rec.attribute15 := NULL;
1606: END IF;
1607:
1608: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1608: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1604: IF l_MODIFIER_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1605: l_MODIFIER_LIST_rec.attribute15 := NULL;
1606: END IF;
1607:
1608: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1609: l_MODIFIER_LIST_rec.attribute2 := NULL;
1610: END IF;
1611:
1612: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1612: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1608: IF l_MODIFIER_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1609: l_MODIFIER_LIST_rec.attribute2 := NULL;
1610: END IF;
1611:
1612: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1613: l_MODIFIER_LIST_rec.attribute3 := NULL;
1614: END IF;
1615:
1616: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1616: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1612: IF l_MODIFIER_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1613: l_MODIFIER_LIST_rec.attribute3 := NULL;
1614: END IF;
1615:
1616: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1617: l_MODIFIER_LIST_rec.attribute4 := NULL;
1618: END IF;
1619:
1620: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1620: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1616: IF l_MODIFIER_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1617: l_MODIFIER_LIST_rec.attribute4 := NULL;
1618: END IF;
1619:
1620: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1621: l_MODIFIER_LIST_rec.attribute5 := NULL;
1622: END IF;
1623:
1624: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1624: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1620: IF l_MODIFIER_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1621: l_MODIFIER_LIST_rec.attribute5 := NULL;
1622: END IF;
1623:
1624: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1625: l_MODIFIER_LIST_rec.attribute6 := NULL;
1626: END IF;
1627:
1628: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1628: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1624: IF l_MODIFIER_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1625: l_MODIFIER_LIST_rec.attribute6 := NULL;
1626: END IF;
1627:
1628: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1629: l_MODIFIER_LIST_rec.attribute7 := NULL;
1630: END IF;
1631:
1632: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1632: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1628: IF l_MODIFIER_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1629: l_MODIFIER_LIST_rec.attribute7 := NULL;
1630: END IF;
1631:
1632: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1633: l_MODIFIER_LIST_rec.attribute8 := NULL;
1634: END IF;
1635:
1636: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1636: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1632: IF l_MODIFIER_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1633: l_MODIFIER_LIST_rec.attribute8 := NULL;
1634: END IF;
1635:
1636: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1637: l_MODIFIER_LIST_rec.attribute9 := NULL;
1638: END IF;
1639:
1640: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

Line 1640: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

1636: IF l_MODIFIER_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1637: l_MODIFIER_LIST_rec.attribute9 := NULL;
1638: END IF;
1639:
1640: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1641: l_MODIFIER_LIST_rec.automatic_flag := NULL;
1642: END IF;
1643:
1644: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1644: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

1640: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1641: l_MODIFIER_LIST_rec.automatic_flag := NULL;
1642: END IF;
1643:
1644: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1645: l_MODIFIER_LIST_rec.comments := NULL;
1646: END IF;
1647:
1648: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 1648: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN

1644: IF l_MODIFIER_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
1645: l_MODIFIER_LIST_rec.comments := NULL;
1646: END IF;
1647:
1648: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1649: l_MODIFIER_LIST_rec.context := NULL;
1650: END IF;
1651:
1652: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1652: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

1648: IF l_MODIFIER_LIST_rec.context = FND_API.G_MISS_CHAR THEN
1649: l_MODIFIER_LIST_rec.context := NULL;
1650: END IF;
1651:
1652: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1653: l_MODIFIER_LIST_rec.created_by := NULL;
1654: END IF;
1655:
1656: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1656: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

1652: IF l_MODIFIER_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1653: l_MODIFIER_LIST_rec.created_by := NULL;
1654: END IF;
1655:
1656: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1657: l_MODIFIER_LIST_rec.creation_date := NULL;
1658: END IF;
1659:
1660: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 1660: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

1656: IF l_MODIFIER_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1657: l_MODIFIER_LIST_rec.creation_date := NULL;
1658: END IF;
1659:
1660: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1661: l_MODIFIER_LIST_rec.currency_code := NULL;
1662: END IF;
1663:
1664: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

Line 1664: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

1660: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
1661: l_MODIFIER_LIST_rec.currency_code := NULL;
1662: END IF;
1663:
1664: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1665: l_MODIFIER_LIST_rec.discount_lines_flag := NULL;
1666: END IF;
1667:
1668: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1668: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

1664: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
1665: l_MODIFIER_LIST_rec.discount_lines_flag := NULL;
1666: END IF;
1667:
1668: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1669: l_MODIFIER_LIST_rec.end_date_active := NULL;
1670: END IF;
1671:
1672: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 1672: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

1668: IF l_MODIFIER_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
1669: l_MODIFIER_LIST_rec.end_date_active := NULL;
1670: END IF;
1671:
1672: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1673: l_MODIFIER_LIST_rec.freight_terms_code := NULL;
1674: END IF;
1675:
1676: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

Line 1676: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN

1672: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1673: l_MODIFIER_LIST_rec.freight_terms_code := NULL;
1674: END IF;
1675:
1676: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1677: l_MODIFIER_LIST_rec.gsa_indicator := NULL;
1678: END IF;
1679:
1680: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1680: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1676: IF l_MODIFIER_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
1677: l_MODIFIER_LIST_rec.gsa_indicator := NULL;
1678: END IF;
1679:
1680: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1681: l_MODIFIER_LIST_rec.last_updated_by := NULL;
1682: END IF;
1683:
1684: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1684: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

1680: IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1681: l_MODIFIER_LIST_rec.last_updated_by := NULL;
1682: END IF;
1683:
1684: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1685: l_MODIFIER_LIST_rec.last_update_date := NULL;
1686: END IF;
1687:
1688: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1688: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

1684: IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1685: l_MODIFIER_LIST_rec.last_update_date := NULL;
1686: END IF;
1687:
1688: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1689: l_MODIFIER_LIST_rec.last_update_login := NULL;
1690: END IF;
1691:
1692: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1692: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

1688: IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1689: l_MODIFIER_LIST_rec.last_update_login := NULL;
1690: END IF;
1691:
1692: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1693: l_MODIFIER_LIST_rec.list_header_id := NULL;
1694: END IF;
1695:
1696: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

Line 1696: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

1692: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1693: l_MODIFIER_LIST_rec.list_header_id := NULL;
1694: END IF;
1695:
1696: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1697: l_MODIFIER_LIST_rec.list_type_code := NULL;
1698: END IF;
1699:
1700: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1700: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

1696: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1697: l_MODIFIER_LIST_rec.list_type_code := NULL;
1698: END IF;
1699:
1700: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1701: l_MODIFIER_LIST_rec.program_application_id := NULL;
1702: END IF;
1703:
1704: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1704: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

1700: IF l_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1701: l_MODIFIER_LIST_rec.program_application_id := NULL;
1702: END IF;
1703:
1704: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1705: l_MODIFIER_LIST_rec.program_id := NULL;
1706: END IF;
1707:
1708: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1708: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

1704: IF l_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1705: l_MODIFIER_LIST_rec.program_id := NULL;
1706: END IF;
1707:
1708: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1709: l_MODIFIER_LIST_rec.program_update_date := NULL;
1710: END IF;
1711:
1712: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

Line 1712: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

1708: IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1709: l_MODIFIER_LIST_rec.program_update_date := NULL;
1710: END IF;
1711:
1712: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1713: l_MODIFIER_LIST_rec.prorate_flag := NULL;
1714: END IF;
1715:
1716: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1716: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

1712: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1713: l_MODIFIER_LIST_rec.prorate_flag := NULL;
1714: END IF;
1715:
1716: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1717: l_MODIFIER_LIST_rec.request_id := NULL;
1718: END IF;
1719:
1720: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1720: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1716: IF l_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1717: l_MODIFIER_LIST_rec.request_id := NULL;
1718: END IF;
1719:
1720: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1721: l_MODIFIER_LIST_rec.rounding_factor := NULL;
1722: END IF;
1723:
1724: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

Line 1724: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

1720: IF l_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1721: l_MODIFIER_LIST_rec.rounding_factor := NULL;
1722: END IF;
1723:
1724: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1725: l_MODIFIER_LIST_rec.ship_method_code := NULL;
1726: END IF;
1727:
1728: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1728: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

1724: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1725: l_MODIFIER_LIST_rec.ship_method_code := NULL;
1726: END IF;
1727:
1728: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1729: l_MODIFIER_LIST_rec.start_date_active := NULL;
1730: END IF;
1731:
1732: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

Line 1732: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

1728: IF l_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1729: l_MODIFIER_LIST_rec.start_date_active := NULL;
1730: END IF;
1731:
1732: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1733: l_MODIFIER_LIST_rec.terms_id := NULL;
1734: END IF;
1735:
1736: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

Line 1736: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN

1732: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1733: l_MODIFIER_LIST_rec.terms_id := NULL;
1734: END IF;
1735:
1736: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1737: l_MODIFIER_LIST_rec.source_system_code := NULL;
1738: END IF;
1739:
1740: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 1740: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN

1736: IF l_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1737: l_MODIFIER_LIST_rec.source_system_code := NULL;
1738: END IF;
1739:
1740: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1741: l_MODIFIER_LIST_rec.pte_code := NULL;
1742: END IF;
1743:
1744: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

Line 1744: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN

1740: IF l_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
1741: l_MODIFIER_LIST_rec.pte_code := NULL;
1742: END IF;
1743:
1744: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1745: l_MODIFIER_LIST_rec.active_flag := NULL;
1746: END IF;
1747:
1748: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

Line 1748: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN

1744: IF l_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
1745: l_MODIFIER_LIST_rec.active_flag := NULL;
1746: END IF;
1747:
1748: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1749: l_MODIFIER_LIST_rec.parent_list_header_id := NULL;
1750: END IF;
1751:
1752: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

Line 1752: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN

1748: IF l_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM THEN
1749: l_MODIFIER_LIST_rec.parent_list_header_id := NULL;
1750: END IF;
1751:
1752: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1753: l_MODIFIER_LIST_rec.start_date_active_first := NULL;
1754: END IF;
1755:
1756: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

Line 1756: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN

1752: IF l_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE THEN
1753: l_MODIFIER_LIST_rec.start_date_active_first := NULL;
1754: END IF;
1755:
1756: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1757: l_MODIFIER_LIST_rec.end_date_active_first := NULL;
1758: END IF;
1759:
1760: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

Line 1760: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN

1756: IF l_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE THEN
1757: l_MODIFIER_LIST_rec.end_date_active_first := NULL;
1758: END IF;
1759:
1760: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1761: l_MODIFIER_LIST_rec.active_date_first_type := NULL;
1762: END IF;
1763:
1764: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

Line 1764: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN

1760: IF l_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR THEN
1761: l_MODIFIER_LIST_rec.active_date_first_type := NULL;
1762: END IF;
1763:
1764: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1765: l_MODIFIER_LIST_rec.start_date_active_second := NULL;
1766: END IF;
1767:
1768: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

Line 1768: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN

1764: IF l_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE THEN
1765: l_MODIFIER_LIST_rec.start_date_active_second := NULL;
1766: END IF;
1767:
1768: IF l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
1769: l_MODIFIER_LIST_rec.global_flag := NULL;
1770: END IF;
1771:
1772:

Line 1773: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN

1769: l_MODIFIER_LIST_rec.global_flag := NULL;
1770: END IF;
1771:
1772:
1773: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1774: l_MODIFIER_LIST_rec.end_date_active_second := NULL;
1775: END IF;
1776:
1777: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

Line 1777: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN

1773: IF l_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE THEN
1774: l_MODIFIER_LIST_rec.end_date_active_second := NULL;
1775: END IF;
1776:
1777: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1778: l_MODIFIER_LIST_rec.active_date_second_type := NULL;
1779: END IF;
1780:
1781: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

Line 1781: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN

1777: IF l_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR THEN
1778: l_MODIFIER_LIST_rec.active_date_second_type := NULL;
1779: END IF;
1780:
1781: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1782: l_MODIFIER_LIST_rec.ask_for_flag := NULL;
1783: END IF;
1784:
1785: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

Line 1785: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN

1781: IF l_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR THEN
1782: l_MODIFIER_LIST_rec.ask_for_flag := NULL;
1783: END IF;
1784:
1785: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1786: l_MODIFIER_LIST_rec.name := NULL;
1787: END IF;
1788:
1789: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

Line 1789: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN

1785: IF l_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR THEN
1786: l_MODIFIER_LIST_rec.name := NULL;
1787: END IF;
1788:
1789: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1790: l_MODIFIER_LIST_rec.description := NULL;
1791: END IF;
1792:
1793: oe_debug_pub.add('END convert_miss_to_null in QPXUMLHB');

Line 1917: RAISE FND_API.G_EXC_ERROR;

1913: WHEN DUP_VAL_ON_INDEX THEN
1914:
1915: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
1916: OE_MSG_PUB.Add;
1917: RAISE FND_API.G_EXC_ERROR;
1918:
1919: WHEN OTHERS THEN
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1925: , 'Update_Row'
1926: );
1927: END IF;
1928:
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930:
1931: End;
1932: end if;
1933:

Line 1936: WHEN FND_API.G_EXC_ERROR THEN

1932: end if;
1933:
1934: EXCEPTION
1935:
1936: WHEN FND_API.G_EXC_ERROR THEN
1937: RAISE;
1938:
1939: WHEN OTHERS THEN
1940:

Line 1949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1945: , 'Update_Row'
1946: );
1947: END IF;
1948:
1949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1950:
1951: END Update_Row;
1952:
1953: -- Procedure Insert_Row

Line 2008: RAISE FND_API.G_EXC_ERROR;

2004: WHEN DUP_VAL_ON_INDEX THEN
2005:
2006: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER');
2007: OE_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_ERROR;
2009:
2010: WHEN OTHERS THEN
2011:
2012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2016: , 'Insert_Row'
2017: );
2018: END IF;
2019:
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021:
2022: End;
2023:
2024: oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');

Line 2172: FND_API.G_MISS_NUM,

2168: IF p_MODIFIER_LIST_rec.gsa_indicator = 'Y'
2169: THEN
2170:
2171: QP_QP_Form_Modifier_List.Create_GSA_Qual(p_MODIFIER_LIST_rec.LIST_HEADER_ID ,
2172: FND_API.G_MISS_NUM,
2173: --NULL, for bug2420752
2174: 'GSA',
2175: l_return_status );
2176: END IF;

Line 2181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2177:
2178: oe_debug_pub.add('l_ret_sts'||l_return_status);
2179: /*added this code to raise exception if qualifier does not get created-spgopal*/
2180:
2181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2182: oe_debug_pub.add('l_ret_sts if'||l_return_status);
2183: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2184: OE_MSG_PUB.Add;
2185:

Line 2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2182: oe_debug_pub.add('l_ret_sts if'||l_return_status);
2183: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2184: OE_MSG_PUB.Add;
2185:
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: oe_debug_pub.add('l_ret_sts else '||l_return_status);
2189: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2190: OE_MSG_PUB.Add;

Line 2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2183: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2184: OE_MSG_PUB.Add;
2185:
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: oe_debug_pub.add('l_ret_sts else '||l_return_status);
2189: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2190: OE_MSG_PUB.Add;
2191: RAISE FND_API.G_EXC_ERROR;

Line 2191: RAISE FND_API.G_EXC_ERROR;

2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: oe_debug_pub.add('l_ret_sts else '||l_return_status);
2189: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2190: OE_MSG_PUB.Add;
2191: RAISE FND_API.G_EXC_ERROR;
2192: END IF;
2193:
2194:
2195:

Line 2200: WHEN FND_API.G_EXC_ERROR THEN

2196: oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
2197: oe_debug_pub.add('END insert_row in QPXUMLHB');
2198: EXCEPTION
2199:
2200: WHEN FND_API.G_EXC_ERROR THEN
2201:
2202:
2203: --x_return_status := FND_API.G_RET_STS_ERROR;
2204:

Line 2203: --x_return_status := FND_API.G_RET_STS_ERROR;

2199:
2200: WHEN FND_API.G_EXC_ERROR THEN
2201:
2202:
2203: --x_return_status := FND_API.G_RET_STS_ERROR;
2204:
2205: /*
2206: -- Get message count and data
2207:

Line 2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2218: , 'Insert_Row'
2219: );
2220: END IF;
2221:
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: */
2224: RAISE; -- Bug 2101393
2225:
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: */
2224: RAISE; -- Bug 2101393
2225:
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227:
2228:
2229: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2230:

Line 2229: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2225:
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227:
2228:
2229: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2230:
2231: /*
2232: -- Get message count and data
2233:

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: , 'Insert_Row'
2245: );
2246: END IF;
2247:
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249:
2250:
2251: WHEN OTHERS THEN
2252:

Line 2261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2257: , 'Insert_Row'
2258: );
2259: END IF;
2260:
2261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2262:
2263: END Insert_Row;
2264:
2265: -- Procedure Delete_Row

Line 2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2313: , 'Delete_Row'
2314: );
2315: END IF;
2316:
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318:
2319: END Delete_Row;
2320:
2321: -- Function Query_Row

Line 2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2473: , 'Query_Row'
2474: );
2475: END IF;
2476:
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478:
2479: END Query_Row;
2480:
2481: -- Procedure lock_Row

Line 2740: x_return_status := FND_API.G_RET_STS_SUCCESS;

2736: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
2737:
2738: -- Set return status
2739:
2740: x_return_status := FND_API.G_RET_STS_SUCCESS;
2741: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2742:
2743: ELSE
2744:

Line 2741: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2737:
2738: -- Set return status
2739:
2740: x_return_status := FND_API.G_RET_STS_SUCCESS;
2741: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2742:
2743: ELSE
2744:
2745: -- Row has changed by another user.

Line 2804: x_return_status := FND_API.G_RET_STS_ERROR;

2800: oe_debug_pub.add('orig_system_header_ref :'||l_MODIFIER_LIST_rec.orig_system_header_ref||':'||p_MODIFIER_LIST_rec.orig_system_header_ref||':');
2801: oe_debug_pub.add('shareable_flag :'||l_MODIFIER_LIST_rec.shareable_flag||':'||p_MODIFIER_LIST_rec.shareable_flag||':');
2802: oe_debug_pub.ADD('-------------------data compare in modifier header end------------------');
2803: --end debug messages added as per 8594682 for oe_lock_row error
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2806:
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2808: THEN

Line 2805: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2801: oe_debug_pub.add('shareable_flag :'||l_MODIFIER_LIST_rec.shareable_flag||':'||p_MODIFIER_LIST_rec.shareable_flag||':');
2802: oe_debug_pub.ADD('-------------------data compare in modifier header end------------------');
2803: --end debug messages added as per 8594682 for oe_lock_row error
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2806:
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2808: THEN
2809:

Line 2822: x_return_status := FND_API.G_RET_STS_ERROR;

2818: EXCEPTION
2819:
2820: WHEN NO_DATA_FOUND THEN
2821:
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN

Line 2823: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2819:
2820: WHEN NO_DATA_FOUND THEN
2821:
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN
2827:

Line 2834: x_return_status := FND_API.G_RET_STS_ERROR;

2830:
2831: END IF;
2832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2833:
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2836:
2837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2838: THEN

Line 2835: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

2831: END IF;
2832: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2833:
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2836:
2837: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2838: THEN
2839:

Line 2846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2842:
2843: END IF;
2844: WHEN OTHERS THEN
2845:
2846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2847: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2848:
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2850: THEN

Line 2847: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2843: END IF;
2844: WHEN OTHERS THEN
2845:
2846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2847: x_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2848:
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2850: THEN
2851: OE_MSG_PUB.Add_Exc_Msg

Line 2872: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND

2868: BEGIN
2869:
2870: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2871: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2872: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2873: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2874: p_old_MODIFIER_LIST_rec.automatic_flag)
2875: THEN
2876: l_MODIFIER_LIST_val_rec.automatic := QP_Id_To_Value.Automatic

Line 2882: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND

2878: );
2879: END IF;
2880:
2881: IF p_MODIFIER_LIST_rec.currency_code IS NOT NULL AND
2882: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2883: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2884: p_old_MODIFIER_LIST_rec.currency_code)
2885: THEN
2886: l_MODIFIER_LIST_val_rec.currency := QP_Id_To_Value.Currency

Line 2892: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND

2888: );
2889: END IF;
2890:
2891: IF p_MODIFIER_LIST_rec.discount_lines_flag IS NOT NULL AND
2892: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2893: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2894: p_old_MODIFIER_LIST_rec.discount_lines_flag)
2895: THEN
2896: l_MODIFIER_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines

Line 2902: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND

2898: );
2899: END IF;
2900:
2901: IF p_MODIFIER_LIST_rec.freight_terms_code IS NOT NULL AND
2902: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2903: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2904: p_old_MODIFIER_LIST_rec.freight_terms_code)
2905: THEN
2906: l_MODIFIER_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms

Line 2912: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND

2908: );
2909: END IF;
2910:
2911: IF p_MODIFIER_LIST_rec.list_header_id IS NOT NULL AND
2912: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2913: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2914: p_old_MODIFIER_LIST_rec.list_header_id)
2915: THEN
2916: l_MODIFIER_LIST_val_rec.list_header := QP_Id_To_Value.List_Header

Line 2922: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND

2918: );
2919: END IF;
2920:
2921: IF p_MODIFIER_LIST_rec.list_type_code IS NOT NULL AND
2922: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2923: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2924: p_old_MODIFIER_LIST_rec.list_type_code)
2925: THEN
2926: l_MODIFIER_LIST_val_rec.list_type := QP_Id_To_Value.List_Type

Line 2932: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND

2928: );
2929: END IF;
2930:
2931: IF p_MODIFIER_LIST_rec.prorate_flag IS NOT NULL AND
2932: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2933: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2934: p_old_MODIFIER_LIST_rec.prorate_flag)
2935: THEN
2936: l_MODIFIER_LIST_val_rec.prorate := QP_Id_To_Value.Prorate

Line 2942: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND

2938: );
2939: END IF;
2940:
2941: IF p_MODIFIER_LIST_rec.ship_method_code IS NOT NULL AND
2942: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2943: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2944: p_old_MODIFIER_LIST_rec.ship_method_code)
2945: THEN
2946: l_MODIFIER_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method

Line 2952: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND

2948: );
2949: END IF;
2950:
2951: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
2952: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2953: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2954: p_old_MODIFIER_LIST_rec.terms_id)
2955: THEN
2956: l_MODIFIER_LIST_val_rec.terms := QP_Id_To_Value.Terms

Line 2979: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2975:
2976: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');
2977: -- initialize return_status.
2978:
2979: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2980:
2981: -- initialize l_MODIFIER_LIST_rec.
2982:
2983: l_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;

Line 2985: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR

2981: -- initialize l_MODIFIER_LIST_rec.
2982:
2983: l_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;
2984:
2985: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2986: THEN
2987:
2988: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2989:

Line 2988: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN

2984:
2985: IF p_MODIFIER_LIST_val_rec.automatic <> FND_API.G_MISS_CHAR
2986: THEN
2987:
2988: IF p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2989:
2990: l_MODIFIER_LIST_rec.automatic_flag := p_MODIFIER_LIST_rec.automatic_flag;
2991:
2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3007: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN

3003: l_MODIFIER_LIST_rec.automatic_flag := QP_Value_To_Id.automatic
3004: ( p_automatic => p_MODIFIER_LIST_val_rec.automatic
3005: );
3006:
3007: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3008: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3009: END IF;
3010:
3011: END IF;

Line 3008: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3004: ( p_automatic => p_MODIFIER_LIST_val_rec.automatic
3005: );
3006:
3007: IF l_MODIFIER_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3008: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3009: END IF;
3010:
3011: END IF;
3012:

Line 3015: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR

3011: END IF;
3012:
3013: END IF;
3014:
3015: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
3016: THEN
3017:
3018: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
3019:

Line 3018: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN

3014:
3015: IF p_MODIFIER_LIST_val_rec.currency <> FND_API.G_MISS_CHAR
3016: THEN
3017:
3018: IF p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
3019:
3020: l_MODIFIER_LIST_rec.currency_code := p_MODIFIER_LIST_rec.currency_code;
3021:
3022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3037: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

3033: l_MODIFIER_LIST_rec.currency_code := QP_Value_To_Id.currency
3034: ( p_currency => p_MODIFIER_LIST_val_rec.currency
3035: );
3036:
3037: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
3038: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3039: END IF;
3040:
3041: END IF;

Line 3038: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3034: ( p_currency => p_MODIFIER_LIST_val_rec.currency
3035: );
3036:
3037: IF l_MODIFIER_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
3038: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3039: END IF;
3040:
3041: END IF;
3042:

Line 3045: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR

3041: END IF;
3042:
3043: END IF;
3044:
3045: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
3046: THEN
3047:
3048: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
3049:

Line 3048: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN

3044:
3045: IF p_MODIFIER_LIST_val_rec.discount_lines <> FND_API.G_MISS_CHAR
3046: THEN
3047:
3048: IF p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
3049:
3050: l_MODIFIER_LIST_rec.discount_lines_flag := p_MODIFIER_LIST_rec.discount_lines_flag;
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3067: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN

3063: l_MODIFIER_LIST_rec.discount_lines_flag := QP_Value_To_Id.discount_lines
3064: ( p_discount_lines => p_MODIFIER_LIST_val_rec.discount_lines
3065: );
3066:
3067: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
3068: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3069: END IF;
3070:
3071: END IF;

Line 3068: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3064: ( p_discount_lines => p_MODIFIER_LIST_val_rec.discount_lines
3065: );
3066:
3067: IF l_MODIFIER_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
3068: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3069: END IF;
3070:
3071: END IF;
3072:

Line 3075: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR

3071: END IF;
3072:
3073: END IF;
3074:
3075: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
3076: THEN
3077:
3078: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
3079:

Line 3078: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN

3074:
3075: IF p_MODIFIER_LIST_val_rec.freight_terms <> FND_API.G_MISS_CHAR
3076: THEN
3077:
3078: IF p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
3079:
3080: l_MODIFIER_LIST_rec.freight_terms_code := p_MODIFIER_LIST_rec.freight_terms_code;
3081:
3082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3097: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

3093: l_MODIFIER_LIST_rec.freight_terms_code := QP_Value_To_Id.freight_terms
3094: ( p_freight_terms => p_MODIFIER_LIST_val_rec.freight_terms
3095: );
3096:
3097: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
3098: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3099: END IF;
3100:
3101: END IF;

Line 3098: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3094: ( p_freight_terms => p_MODIFIER_LIST_val_rec.freight_terms
3095: );
3096:
3097: IF l_MODIFIER_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
3098: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3099: END IF;
3100:
3101: END IF;
3102:

Line 3105: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR

3101: END IF;
3102:
3103: END IF;
3104:
3105: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
3106: THEN
3107:
3108: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3109:

Line 3108: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN

3104:
3105: IF p_MODIFIER_LIST_val_rec.list_header <> FND_API.G_MISS_CHAR
3106: THEN
3107:
3108: IF p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3109:
3110: l_MODIFIER_LIST_rec.list_header_id := p_MODIFIER_LIST_rec.list_header_id;
3111:
3112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3127: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN

3123: l_MODIFIER_LIST_rec.list_header_id := QP_Value_To_Id.list_header
3124: ( p_list_header => p_MODIFIER_LIST_val_rec.list_header
3125: );
3126:
3127: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
3128: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3129: END IF;
3130:
3131: END IF;

Line 3128: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3124: ( p_list_header => p_MODIFIER_LIST_val_rec.list_header
3125: );
3126:
3127: IF l_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
3128: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3129: END IF;
3130:
3131: END IF;
3132:

Line 3135: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR

3131: END IF;
3132:
3133: END IF;
3134:
3135: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
3136: THEN
3137:
3138: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
3139:

Line 3138: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN

3134:
3135: IF p_MODIFIER_LIST_val_rec.list_type <> FND_API.G_MISS_CHAR
3136: THEN
3137:
3138: IF p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
3139:
3140: l_MODIFIER_LIST_rec.list_type_code := p_MODIFIER_LIST_rec.list_type_code;
3141:
3142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3157: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN

3153: l_MODIFIER_LIST_rec.list_type_code := QP_Value_To_Id.list_type
3154: ( p_list_type => p_MODIFIER_LIST_val_rec.list_type
3155: );
3156:
3157: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
3158: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3159: END IF;
3160:
3161: END IF;

Line 3158: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3154: ( p_list_type => p_MODIFIER_LIST_val_rec.list_type
3155: );
3156:
3157: IF l_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
3158: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3159: END IF;
3160:
3161: END IF;
3162:

Line 3165: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR

3161: END IF;
3162:
3163: END IF;
3164:
3165: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
3166: THEN
3167:
3168: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
3169:

Line 3168: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN

3164:
3165: IF p_MODIFIER_LIST_val_rec.prorate <> FND_API.G_MISS_CHAR
3166: THEN
3167:
3168: IF p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
3169:
3170: l_MODIFIER_LIST_rec.prorate_flag := p_MODIFIER_LIST_rec.prorate_flag;
3171:
3172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3187: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN

3183: l_MODIFIER_LIST_rec.prorate_flag := QP_Value_To_Id.prorate
3184: ( p_prorate => p_MODIFIER_LIST_val_rec.prorate
3185: );
3186:
3187: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
3188: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3189: END IF;
3190:
3191: END IF;

Line 3188: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3184: ( p_prorate => p_MODIFIER_LIST_val_rec.prorate
3185: );
3186:
3187: IF l_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
3188: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3189: END IF;
3190:
3191: END IF;
3192:

Line 3195: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR

3191: END IF;
3192:
3193: END IF;
3194:
3195: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
3196: THEN
3197:
3198: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
3199:

Line 3198: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN

3194:
3195: IF p_MODIFIER_LIST_val_rec.ship_method <> FND_API.G_MISS_CHAR
3196: THEN
3197:
3198: IF p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
3199:
3200: l_MODIFIER_LIST_rec.ship_method_code := p_MODIFIER_LIST_rec.ship_method_code;
3201:
3202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3217: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

3213: l_MODIFIER_LIST_rec.ship_method_code := QP_Value_To_Id.ship_method
3214: ( p_ship_method => p_MODIFIER_LIST_val_rec.ship_method
3215: );
3216:
3217: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
3218: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3219: END IF;
3220:
3221: END IF;

Line 3218: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3214: ( p_ship_method => p_MODIFIER_LIST_val_rec.ship_method
3215: );
3216:
3217: IF l_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
3218: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3219: END IF;
3220:
3221: END IF;
3222:

Line 3225: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR

3221: END IF;
3222:
3223: END IF;
3224:
3225: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
3226: THEN
3227:
3228: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
3229:

Line 3228: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN

3224:
3225: IF p_MODIFIER_LIST_val_rec.terms <> FND_API.G_MISS_CHAR
3226: THEN
3227:
3228: IF p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
3229:
3230: l_MODIFIER_LIST_rec.terms_id := p_MODIFIER_LIST_rec.terms_id;
3231:
3232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 3247: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

3243: l_MODIFIER_LIST_rec.terms_id := QP_Value_To_Id.terms
3244: ( p_terms => p_MODIFIER_LIST_val_rec.terms
3245: );
3246:
3247: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
3248: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3249: END IF;
3250:
3251: END IF;

Line 3248: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

3244: ( p_terms => p_MODIFIER_LIST_val_rec.terms
3245: );
3246:
3247: IF l_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
3248: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
3249: END IF;
3250:
3251: END IF;
3252:

Line 3300: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3296: elsif l_current_segment_level = 'BOTH' then
3297: l_final_segment_level := 'LINE_BOTH';
3298: elsif l_current_segment_level = 'ORDER' then
3299: -- Unexpected Condition
3300: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3301: end if;
3302:
3303: elsif l_final_segment_level = 'ORDER' then
3304: if l_current_segment_level = 'ORDER' then

Line 3310: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3306: elsif l_current_segment_level = 'BOTH' then
3307: l_final_segment_level := 'ORDER_BOTH';
3308: elsif l_current_segment_level = 'LINE' then
3309: -- Unexpected Condition
3310: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3311: end if;
3312:
3313: elsif l_final_segment_level = 'BOTH' then
3314: if l_current_segment_level = 'LINE' then

Line 3327: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3323: if l_current_segment_level in ('LINE', 'BOTH') then
3324: l_final_segment_level := 'LINE_BOTH';
3325: elsif l_current_segment_level = 'ORDER' then
3326: -- Unexpected Condition
3327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3328: end if;
3329:
3330: elsif l_final_segment_level = 'ORDER_BOTH' then
3331: if l_current_segment_level in ('ORDER', 'BOTH') then

Line 3335: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3331: if l_current_segment_level in ('ORDER', 'BOTH') then
3332: l_final_segment_level := 'ORDER_BOTH';
3333: elsif l_current_segment_level = 'LINE' then
3334: -- Unexpected Condition
3335: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3336: end if;
3337:
3338: end if; -- l_final_segment_level = 'LINE'
3339: end if; -- l_final_segment_level is NULL

Line 3347: WHEN FND_API.G_EXC_ERROR THEN

3343: return(l_final_segment_level);
3344:
3345: oe_debug_pub.add('End Get_Segment_Level_for_Group');
3346: EXCEPTION
3347: WHEN FND_API.G_EXC_ERROR THEN
3348: return(null);
3349:
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3346: EXCEPTION
3347: WHEN FND_API.G_EXC_ERROR THEN
3348: return(null);
3349:
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3352: OE_MSG_PUB.Add_Exc_Msg
3353: (G_PKG_NAME
3354: ,'Get_Segment_Level_for_Group');