eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on FND_API

Line 1228: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN

1224: )
1225: IS
1226: BEGIN
1227:
1228: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1229: x_internal := p_internal;
1230: IF p_internal IS NULL THEN
1231: x_external := NULL;
1232: ELSE

Line 1235: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1231: x_external := NULL;
1232: ELSE
1233: x_external := p_external;
1234: END IF;
1235: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1236: x_external := p_external;
1237: IF x_external IS NULL THEN
1238: x_internal := NULL;
1239: ELSE

Line 1262: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN

1258: )
1259: IS
1260: BEGIN
1261:
1262: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1263: x_internal := p_internal;
1264: IF p_internal IS NULL THEN
1265: x_external := NULL;
1266: ELSE

Line 1269: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1265: x_external := NULL;
1266: ELSE
1267: x_external := p_external;
1268: END IF;
1269: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1270: x_external := p_external;
1271: IF x_external IS NULL THEN
1272: x_internal := NULL;
1273: ELSE

Line 1306: IF p_stop_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR

1302: x_stop_rec.trip_id,
1303: x_stop_rec.trip_name);
1304:
1305: */
1306: IF p_stop_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR
1307: OR p_stop_rec.DEPARTURE_SEAL_CODE IS NULL THEN
1308: x_stop_rec.DEPARTURE_SEAL_CODE :=
1309: p_stop_rec.DEPARTURE_SEAL_CODE;
1310: END IF;

Line 1325: ELSIF p_stop_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM

1321: -- it is created.
1322: x_stop_rec.STOP_SEQUENCE_NUMBER := -99;
1323: -- but for mode = SSN, stop_sequence_number field would always have to be specified
1324: -- when creating a stop
1325: ELSIF p_stop_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM
1326: OR p_stop_rec.STOP_SEQUENCE_NUMBER IS NULL THEN
1327: x_stop_rec.STOP_SEQUENCE_NUMBER :=
1328: p_stop_rec.STOP_SEQUENCE_NUMBER;
1329: END IF;

Line 1332: IF p_stop_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE

1328: p_stop_rec.STOP_SEQUENCE_NUMBER;
1329: END IF;
1330: -- end of SSN change
1331:
1332: IF p_stop_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE
1333: OR p_stop_rec.PLANNED_ARRIVAL_DATE IS NULL THEN
1334: x_stop_rec.PLANNED_ARRIVAL_DATE :=
1335: p_stop_rec.PLANNED_ARRIVAL_DATE;
1336: END IF;

Line 1337: IF p_stop_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE

1333: OR p_stop_rec.PLANNED_ARRIVAL_DATE IS NULL THEN
1334: x_stop_rec.PLANNED_ARRIVAL_DATE :=
1335: p_stop_rec.PLANNED_ARRIVAL_DATE;
1336: END IF;
1337: IF p_stop_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE
1338: OR p_stop_rec.PLANNED_DEPARTURE_DATE IS NULL THEN
1339: x_stop_rec.PLANNED_DEPARTURE_DATE :=
1340: p_stop_rec.PLANNED_DEPARTURE_DATE;
1341: END IF;

Line 1342: IF p_stop_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM

1338: OR p_stop_rec.PLANNED_DEPARTURE_DATE IS NULL THEN
1339: x_stop_rec.PLANNED_DEPARTURE_DATE :=
1340: p_stop_rec.PLANNED_DEPARTURE_DATE;
1341: END IF;
1342: IF p_stop_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM
1343: OR p_stop_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1344: x_stop_rec.DEPARTURE_GROSS_WEIGHT :=
1345: p_stop_rec.DEPARTURE_GROSS_WEIGHT;
1346: END IF;

Line 1347: IF p_stop_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM

1343: OR p_stop_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1344: x_stop_rec.DEPARTURE_GROSS_WEIGHT :=
1345: p_stop_rec.DEPARTURE_GROSS_WEIGHT;
1346: END IF;
1347: IF p_stop_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
1348: OR p_stop_rec.DEPARTURE_NET_WEIGHT IS NULL THEN
1349: x_stop_rec.DEPARTURE_NET_WEIGHT :=
1350: p_stop_rec.DEPARTURE_NET_WEIGHT;
1351: END IF;

Line 1358: IF p_stop_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM

1354: p_stop_rec.WEIGHT_UOM_DESC,
1355: x_stop_rec.WEIGHT_UOM_CODE,
1356: x_stop_rec.WEIGHT_UOM_DESC);
1357:
1358: IF p_stop_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM
1359: OR p_stop_rec.DEPARTURE_VOLUME IS NULL THEN
1360: x_stop_rec.DEPARTURE_VOLUME :=
1361: p_stop_rec.DEPARTURE_VOLUME;
1362: END IF;

Line 1370: IF p_stop_rec.wv_frozen_flag <> FND_API.G_MISS_CHAR THEN

1366: x_stop_rec.VOLUME_UOM_CODE,
1367: x_stop_rec.VOLUME_UOM_DESC);
1368:
1369: -- bug 3666967 - need wv_frozen_flag when creating new stop through public api.
1370: IF p_stop_rec.wv_frozen_flag <> FND_API.G_MISS_CHAR THEN
1371: x_stop_rec.wv_frozen_flag :=
1372: p_stop_rec.wv_frozen_flag;
1373: END IF;
1374: -- end bug 3666967

Line 1376: IF p_stop_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM

1372: p_stop_rec.wv_frozen_flag;
1373: END IF;
1374: -- end bug 3666967
1375:
1376: IF p_stop_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM
1377: OR p_stop_rec.DEPARTURE_FILL_PERCENT IS NULL THEN
1378: x_stop_rec.DEPARTURE_FILL_PERCENT :=
1379: p_stop_rec.DEPARTURE_FILL_PERCENT;
1380: END IF;

Line 1381: IF p_stop_rec.attribute1 <> FND_API.G_MISS_CHAR

1377: OR p_stop_rec.DEPARTURE_FILL_PERCENT IS NULL THEN
1378: x_stop_rec.DEPARTURE_FILL_PERCENT :=
1379: p_stop_rec.DEPARTURE_FILL_PERCENT;
1380: END IF;
1381: IF p_stop_rec.attribute1 <> FND_API.G_MISS_CHAR
1382: OR p_stop_rec.attribute1 IS NULL THEN
1383: x_stop_rec.attribute1 :=
1384: p_stop_rec.attribute1;
1385: END IF;

Line 1386: IF p_stop_rec.attribute2 <> FND_API.G_MISS_CHAR

1382: OR p_stop_rec.attribute1 IS NULL THEN
1383: x_stop_rec.attribute1 :=
1384: p_stop_rec.attribute1;
1385: END IF;
1386: IF p_stop_rec.attribute2 <> FND_API.G_MISS_CHAR
1387: OR p_stop_rec.attribute2 IS NULL THEN
1388: x_stop_rec.attribute2 :=
1389: p_stop_rec.attribute2;
1390: END IF;

Line 1391: IF p_stop_rec.attribute3 <> FND_API.G_MISS_CHAR

1387: OR p_stop_rec.attribute2 IS NULL THEN
1388: x_stop_rec.attribute2 :=
1389: p_stop_rec.attribute2;
1390: END IF;
1391: IF p_stop_rec.attribute3 <> FND_API.G_MISS_CHAR
1392: OR p_stop_rec.attribute3 IS NULL THEN
1393: x_stop_rec.attribute3 :=
1394: p_stop_rec.attribute3;
1395: END IF;

Line 1396: IF p_stop_rec.attribute4 <> FND_API.G_MISS_CHAR

1392: OR p_stop_rec.attribute3 IS NULL THEN
1393: x_stop_rec.attribute3 :=
1394: p_stop_rec.attribute3;
1395: END IF;
1396: IF p_stop_rec.attribute4 <> FND_API.G_MISS_CHAR
1397: OR p_stop_rec.attribute4 IS NULL THEN
1398: x_stop_rec.attribute4 :=
1399: p_stop_rec.attribute4;
1400: END IF;

Line 1401: IF p_stop_rec.attribute5 <> FND_API.G_MISS_CHAR

1397: OR p_stop_rec.attribute4 IS NULL THEN
1398: x_stop_rec.attribute4 :=
1399: p_stop_rec.attribute4;
1400: END IF;
1401: IF p_stop_rec.attribute5 <> FND_API.G_MISS_CHAR
1402: OR p_stop_rec.attribute5 IS NULL THEN
1403: x_stop_rec.attribute5 :=
1404: p_stop_rec.attribute5;
1405: END IF;

Line 1406: IF p_stop_rec.attribute6 <> FND_API.G_MISS_CHAR

1402: OR p_stop_rec.attribute5 IS NULL THEN
1403: x_stop_rec.attribute5 :=
1404: p_stop_rec.attribute5;
1405: END IF;
1406: IF p_stop_rec.attribute6 <> FND_API.G_MISS_CHAR
1407: OR p_stop_rec.attribute6 IS NULL THEN
1408: x_stop_rec.attribute6 :=
1409: p_stop_rec.attribute6;
1410: END IF;

Line 1411: IF p_stop_rec.attribute7 <> FND_API.G_MISS_CHAR

1407: OR p_stop_rec.attribute6 IS NULL THEN
1408: x_stop_rec.attribute6 :=
1409: p_stop_rec.attribute6;
1410: END IF;
1411: IF p_stop_rec.attribute7 <> FND_API.G_MISS_CHAR
1412: OR p_stop_rec.attribute7 IS NULL THEN
1413: x_stop_rec.attribute7 :=
1414: p_stop_rec.attribute7;
1415: END IF;

Line 1416: IF p_stop_rec.attribute8 <> FND_API.G_MISS_CHAR

1412: OR p_stop_rec.attribute7 IS NULL THEN
1413: x_stop_rec.attribute7 :=
1414: p_stop_rec.attribute7;
1415: END IF;
1416: IF p_stop_rec.attribute8 <> FND_API.G_MISS_CHAR
1417: OR p_stop_rec.attribute8 IS NULL THEN
1418: x_stop_rec.attribute8 :=
1419: p_stop_rec.attribute8;
1420: END IF;

Line 1421: IF p_stop_rec.attribute9 <> FND_API.G_MISS_CHAR

1417: OR p_stop_rec.attribute8 IS NULL THEN
1418: x_stop_rec.attribute8 :=
1419: p_stop_rec.attribute8;
1420: END IF;
1421: IF p_stop_rec.attribute9 <> FND_API.G_MISS_CHAR
1422: OR p_stop_rec.attribute9 IS NULL THEN
1423: x_stop_rec.attribute9 :=
1424: p_stop_rec.attribute9;
1425: END IF;

Line 1426: IF p_stop_rec.attribute10 <> FND_API.G_MISS_CHAR

1422: OR p_stop_rec.attribute9 IS NULL THEN
1423: x_stop_rec.attribute9 :=
1424: p_stop_rec.attribute9;
1425: END IF;
1426: IF p_stop_rec.attribute10 <> FND_API.G_MISS_CHAR
1427: OR p_stop_rec.attribute10 IS NULL THEN
1428: x_stop_rec.attribute10 :=
1429: p_stop_rec.attribute10;
1430: END IF;

Line 1431: IF p_stop_rec.attribute11 <> FND_API.G_MISS_CHAR

1427: OR p_stop_rec.attribute10 IS NULL THEN
1428: x_stop_rec.attribute10 :=
1429: p_stop_rec.attribute10;
1430: END IF;
1431: IF p_stop_rec.attribute11 <> FND_API.G_MISS_CHAR
1432: OR p_stop_rec.attribute11 IS NULL THEN
1433: x_stop_rec.attribute11 :=
1434: p_stop_rec.attribute11;
1435: END IF;

Line 1436: IF p_stop_rec.attribute12 <> FND_API.G_MISS_CHAR

1432: OR p_stop_rec.attribute11 IS NULL THEN
1433: x_stop_rec.attribute11 :=
1434: p_stop_rec.attribute11;
1435: END IF;
1436: IF p_stop_rec.attribute12 <> FND_API.G_MISS_CHAR
1437: OR p_stop_rec.attribute12 IS NULL THEN
1438: x_stop_rec.attribute12 :=
1439: p_stop_rec.attribute12;
1440: END IF;

Line 1441: IF p_stop_rec.attribute13 <> FND_API.G_MISS_CHAR

1437: OR p_stop_rec.attribute12 IS NULL THEN
1438: x_stop_rec.attribute12 :=
1439: p_stop_rec.attribute12;
1440: END IF;
1441: IF p_stop_rec.attribute13 <> FND_API.G_MISS_CHAR
1442: OR p_stop_rec.attribute13 IS NULL THEN
1443: x_stop_rec.attribute13 :=
1444: p_stop_rec.attribute13;
1445: END IF;

Line 1446: IF p_stop_rec.attribute14 <> FND_API.G_MISS_CHAR

1442: OR p_stop_rec.attribute13 IS NULL THEN
1443: x_stop_rec.attribute13 :=
1444: p_stop_rec.attribute13;
1445: END IF;
1446: IF p_stop_rec.attribute14 <> FND_API.G_MISS_CHAR
1447: OR p_stop_rec.attribute14 IS NULL THEN
1448: x_stop_rec.attribute14 :=
1449: p_stop_rec.attribute14;
1450: END IF;

Line 1451: IF p_stop_rec.attribute15 <> FND_API.G_MISS_CHAR

1447: OR p_stop_rec.attribute14 IS NULL THEN
1448: x_stop_rec.attribute14 :=
1449: p_stop_rec.attribute14;
1450: END IF;
1451: IF p_stop_rec.attribute15 <> FND_API.G_MISS_CHAR
1452: OR p_stop_rec.attribute15 IS NULL THEN
1453: x_stop_rec.attribute15 :=
1454: p_stop_rec.attribute15;
1455: END IF;

Line 1456: IF p_stop_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

1452: OR p_stop_rec.attribute15 IS NULL THEN
1453: x_stop_rec.attribute15 :=
1454: p_stop_rec.attribute15;
1455: END IF;
1456: IF p_stop_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
1457: OR p_stop_rec.ATTRIBUTE_CATEGORY IS NULL THEN
1458: x_stop_rec.ATTRIBUTE_CATEGORY :=
1459: p_stop_rec.ATTRIBUTE_CATEGORY;
1460: END IF;

Line 1461: IF p_stop_rec.tp_attribute1 <> FND_API.G_MISS_CHAR

1457: OR p_stop_rec.ATTRIBUTE_CATEGORY IS NULL THEN
1458: x_stop_rec.ATTRIBUTE_CATEGORY :=
1459: p_stop_rec.ATTRIBUTE_CATEGORY;
1460: END IF;
1461: IF p_stop_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
1462: OR p_stop_rec.tp_attribute1 IS NULL THEN
1463: x_stop_rec.tp_attribute1 :=
1464: p_stop_rec.tp_attribute1;
1465: END IF;

Line 1466: IF p_stop_rec.tp_attribute2 <> FND_API.G_MISS_CHAR

1462: OR p_stop_rec.tp_attribute1 IS NULL THEN
1463: x_stop_rec.tp_attribute1 :=
1464: p_stop_rec.tp_attribute1;
1465: END IF;
1466: IF p_stop_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
1467: OR p_stop_rec.tp_attribute2 IS NULL THEN
1468: x_stop_rec.tp_attribute2 :=
1469: p_stop_rec.tp_attribute2;
1470: END IF;

Line 1471: IF p_stop_rec.tp_attribute3 <> FND_API.G_MISS_CHAR

1467: OR p_stop_rec.tp_attribute2 IS NULL THEN
1468: x_stop_rec.tp_attribute2 :=
1469: p_stop_rec.tp_attribute2;
1470: END IF;
1471: IF p_stop_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
1472: OR p_stop_rec.tp_attribute3 IS NULL THEN
1473: x_stop_rec.tp_attribute3 :=
1474: p_stop_rec.tp_attribute3;
1475: END IF;

Line 1476: IF p_stop_rec.tp_attribute4 <> FND_API.G_MISS_CHAR

1472: OR p_stop_rec.tp_attribute3 IS NULL THEN
1473: x_stop_rec.tp_attribute3 :=
1474: p_stop_rec.tp_attribute3;
1475: END IF;
1476: IF p_stop_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
1477: OR p_stop_rec.tp_attribute4 IS NULL THEN
1478: x_stop_rec.tp_attribute4 :=
1479: p_stop_rec.tp_attribute4;
1480: END IF;

Line 1481: IF p_stop_rec.tp_attribute5 <> FND_API.G_MISS_CHAR

1477: OR p_stop_rec.tp_attribute4 IS NULL THEN
1478: x_stop_rec.tp_attribute4 :=
1479: p_stop_rec.tp_attribute4;
1480: END IF;
1481: IF p_stop_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
1482: OR p_stop_rec.tp_attribute5 IS NULL THEN
1483: x_stop_rec.tp_attribute5 :=
1484: p_stop_rec.tp_attribute5;
1485: END IF;

Line 1486: IF p_stop_rec.tp_attribute6 <> FND_API.G_MISS_CHAR

1482: OR p_stop_rec.tp_attribute5 IS NULL THEN
1483: x_stop_rec.tp_attribute5 :=
1484: p_stop_rec.tp_attribute5;
1485: END IF;
1486: IF p_stop_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
1487: OR p_stop_rec.tp_attribute6 IS NULL THEN
1488: x_stop_rec.tp_attribute6 :=
1489: p_stop_rec.tp_attribute6;
1490: END IF;

Line 1491: IF p_stop_rec.tp_attribute7 <> FND_API.G_MISS_CHAR

1487: OR p_stop_rec.tp_attribute6 IS NULL THEN
1488: x_stop_rec.tp_attribute6 :=
1489: p_stop_rec.tp_attribute6;
1490: END IF;
1491: IF p_stop_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
1492: OR p_stop_rec.tp_attribute7 IS NULL THEN
1493: x_stop_rec.tp_attribute7 :=
1494: p_stop_rec.tp_attribute7;
1495: END IF;

Line 1496: IF p_stop_rec.tp_attribute8 <> FND_API.G_MISS_CHAR

1492: OR p_stop_rec.tp_attribute7 IS NULL THEN
1493: x_stop_rec.tp_attribute7 :=
1494: p_stop_rec.tp_attribute7;
1495: END IF;
1496: IF p_stop_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
1497: OR p_stop_rec.tp_attribute8 IS NULL THEN
1498: x_stop_rec.tp_attribute8 :=
1499: p_stop_rec.tp_attribute8;
1500: END IF;

Line 1501: IF p_stop_rec.tp_attribute9 <> FND_API.G_MISS_CHAR

1497: OR p_stop_rec.tp_attribute8 IS NULL THEN
1498: x_stop_rec.tp_attribute8 :=
1499: p_stop_rec.tp_attribute8;
1500: END IF;
1501: IF p_stop_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
1502: OR p_stop_rec.tp_attribute9 IS NULL THEN
1503: x_stop_rec.tp_attribute9 :=
1504: p_stop_rec.tp_attribute9;
1505: END IF;

Line 1506: IF p_stop_rec.tp_attribute10 <> FND_API.G_MISS_CHAR

1502: OR p_stop_rec.tp_attribute9 IS NULL THEN
1503: x_stop_rec.tp_attribute9 :=
1504: p_stop_rec.tp_attribute9;
1505: END IF;
1506: IF p_stop_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
1507: OR p_stop_rec.tp_attribute10 IS NULL THEN
1508: x_stop_rec.tp_attribute10 :=
1509: p_stop_rec.tp_attribute10;
1510: END IF;

Line 1511: IF p_stop_rec.tp_attribute11 <> FND_API.G_MISS_CHAR

1507: OR p_stop_rec.tp_attribute10 IS NULL THEN
1508: x_stop_rec.tp_attribute10 :=
1509: p_stop_rec.tp_attribute10;
1510: END IF;
1511: IF p_stop_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
1512: OR p_stop_rec.tp_attribute11 IS NULL THEN
1513: x_stop_rec.tp_attribute11 :=
1514: p_stop_rec.tp_attribute11;
1515: END IF;

Line 1516: IF p_stop_rec.tp_attribute12 <> FND_API.G_MISS_CHAR

1512: OR p_stop_rec.tp_attribute11 IS NULL THEN
1513: x_stop_rec.tp_attribute11 :=
1514: p_stop_rec.tp_attribute11;
1515: END IF;
1516: IF p_stop_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
1517: OR p_stop_rec.tp_attribute12 IS NULL THEN
1518: x_stop_rec.tp_attribute12 :=
1519: p_stop_rec.tp_attribute12;
1520: END IF;

Line 1521: IF p_stop_rec.tp_attribute13 <> FND_API.G_MISS_CHAR

1517: OR p_stop_rec.tp_attribute12 IS NULL THEN
1518: x_stop_rec.tp_attribute12 :=
1519: p_stop_rec.tp_attribute12;
1520: END IF;
1521: IF p_stop_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
1522: OR p_stop_rec.tp_attribute13 IS NULL THEN
1523: x_stop_rec.tp_attribute13 :=
1524: p_stop_rec.tp_attribute13;
1525: END IF;

Line 1526: IF p_stop_rec.tp_attribute14 <> FND_API.G_MISS_CHAR

1522: OR p_stop_rec.tp_attribute13 IS NULL THEN
1523: x_stop_rec.tp_attribute13 :=
1524: p_stop_rec.tp_attribute13;
1525: END IF;
1526: IF p_stop_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
1527: OR p_stop_rec.tp_attribute14 IS NULL THEN
1528: x_stop_rec.tp_attribute14 :=
1529: p_stop_rec.tp_attribute14;
1530: END IF;

Line 1531: IF p_stop_rec.tp_attribute15 <> FND_API.G_MISS_CHAR

1527: OR p_stop_rec.tp_attribute14 IS NULL THEN
1528: x_stop_rec.tp_attribute14 :=
1529: p_stop_rec.tp_attribute14;
1530: END IF;
1531: IF p_stop_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
1532: OR p_stop_rec.tp_attribute15 IS NULL THEN
1533: x_stop_rec.tp_attribute15 :=
1534: p_stop_rec.tp_attribute15;
1535: END IF;

Line 1536: IF p_stop_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

1532: OR p_stop_rec.tp_attribute15 IS NULL THEN
1533: x_stop_rec.tp_attribute15 :=
1534: p_stop_rec.tp_attribute15;
1535: END IF;
1536: IF p_stop_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
1537: OR p_stop_rec.TP_ATTRIBUTE_CATEGORY IS NULL THEN
1538: x_stop_rec.TP_ATTRIBUTE_CATEGORY :=
1539: p_stop_rec.TP_ATTRIBUTE_CATEGORY;
1540: END IF;

Line 1543: IF p_stop_rec.wkday_layover_stops <> FND_API.G_MISS_NUM

1539: p_stop_rec.TP_ATTRIBUTE_CATEGORY;
1540: END IF;
1541:
1542: IF p_in_rec.caller IN ('FTEMLWRB','WSH_TP_RELEASE') THEN
1543: IF p_stop_rec.wkday_layover_stops <> FND_API.G_MISS_NUM
1544: OR p_stop_rec.wkday_layover_stops IS NULL THEN
1545: x_stop_rec.wkday_layover_stops :=
1546: p_stop_rec.wkday_layover_stops;
1547: END IF;

Line 1548: IF p_stop_rec.wkend_layover_stops <> FND_API.G_MISS_NUM

1544: OR p_stop_rec.wkday_layover_stops IS NULL THEN
1545: x_stop_rec.wkday_layover_stops :=
1546: p_stop_rec.wkday_layover_stops;
1547: END IF;
1548: IF p_stop_rec.wkend_layover_stops <> FND_API.G_MISS_NUM
1549: OR p_stop_rec.wkend_layover_stops IS NULL THEN
1550: x_stop_rec.wkend_layover_stops :=
1551: p_stop_rec.wkend_layover_stops;
1552: END IF;

Line 1555: IF p_stop_rec.tp_stop_id <> FND_API.G_MISS_NUM

1551: p_stop_rec.wkend_layover_stops;
1552: END IF;
1553: END IF;
1554: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
1555: IF p_stop_rec.tp_stop_id <> FND_API.G_MISS_NUM
1556: OR p_stop_rec.tp_stop_id IS NULL THEN
1557: x_stop_rec.tp_stop_id :=
1558: p_stop_rec.tp_stop_id;
1559: END IF;

Line 1564: IF p_stop_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE

1560: END IF;
1561: --Bug 3282166
1562: --
1563: IF p_in_rec.caller like 'FTE%' THEN
1564: IF p_stop_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE
1565: OR p_stop_rec.CARRIER_EST_DEPARTURE_DATE IS NULL THEN
1566: x_stop_rec.CARRIER_EST_DEPARTURE_DATE := p_stop_rec.CARRIER_EST_DEPARTURE_DATE;
1567:
1568: END IF;

Line 1569: IF p_stop_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE

1565: OR p_stop_rec.CARRIER_EST_DEPARTURE_DATE IS NULL THEN
1566: x_stop_rec.CARRIER_EST_DEPARTURE_DATE := p_stop_rec.CARRIER_EST_DEPARTURE_DATE;
1567:
1568: END IF;
1569: IF p_stop_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE
1570: OR p_stop_rec.CARRIER_EST_ARRIVAL_DATE IS NULL THEN
1571: x_stop_rec.CARRIER_EST_ARRIVAL_DATE := p_stop_rec.CARRIER_EST_ARRIVAL_DATE;
1572:
1573: END IF;

Line 1598: x_out_rec.STOP_LOCATION_CODE := FND_API.G_MISS_CHAR ;

1594: FOR i IN 1..p_disabled_list.COUNT
1595: LOOP
1596: IF p_disabled_list(i) = 'STOP_LOCATION_CODE' THEN
1597: x_out_rec.STOP_LOCATION_ID := p_in_rec.STOP_LOCATION_ID ;
1598: x_out_rec.STOP_LOCATION_CODE := FND_API.G_MISS_CHAR ;
1599: ELSIF p_disabled_list(i) = 'STOP_SEQUENCE_NUMBER' THEN
1600: x_out_rec.STOP_SEQUENCE_NUMBER := p_in_rec.STOP_SEQUENCE_NUMBER;
1601: ELSIF p_disabled_list(i) = 'PLANNED_ARRIVAL_DATE' THEN
1602: x_out_rec.PLANNED_ARRIVAL_DATE := p_in_rec.PLANNED_ARRIVAL_DATE ;

Line 1676: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN

1672: IS
1673: BEGIN
1674:
1675: IF x_internal IS NULL THEN
1676: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1677: x_internal := p_internal ;
1678: IF p_internal IS NULL THEN
1679: x_external := NULL;
1680: ELSE

Line 1683: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1679: x_external := NULL;
1680: ELSE
1681: x_external := p_external;
1682: END IF;
1683: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1684: x_external := p_external;
1685: IF p_external IS NULL THEN
1686: x_internal := NULL;
1687: ELSE

Line 1692: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN

1688: x_internal := p_internal;
1689: END IF;
1690: END IF;
1691: END IF;
1692: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1693: x_internal := p_internal ;
1694: IF p_internal IS NULL THEN
1695: x_external := NULL;
1696: ELSE

Line 1699: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1695: x_external := NULL;
1696: ELSE
1697: x_external := p_external;
1698: END IF;
1699: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1700: x_external := p_external;
1701: IF p_external IS NULL THEN
1702: x_internal := NULL;
1703: ELSE

Line 1728: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN

1724: BEGIN
1725:
1726: IF p_mode = '+' THEN
1727: IF x_internal IS NULL THEN
1728: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1729: x_internal := p_internal ;
1730: IF p_internal IS NULL THEN
1731: x_external := NULL;
1732: ELSE

Line 1735: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1731: x_external := NULL;
1732: ELSE
1733: x_external := p_external;
1734: END IF;
1735: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1736: x_external := p_external;
1737: IF p_external IS NULL THEN
1738: x_internal := NULL;
1739: ELSE

Line 1745: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN

1741: END IF;
1742: END IF;
1743: END IF;
1744: ELSE --p_mode <> +
1745: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1746: x_internal := p_internal ;
1747: IF p_internal IS NULL THEN
1748: x_external := NULL;
1749: ELSE

Line 1752: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN

1748: x_external := NULL;
1749: ELSE
1750: x_external := p_external;
1751: END IF;
1752: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1753: x_external := p_external;
1754: IF p_external IS NULL THEN
1755: x_internal := NULL;
1756: ELSE

Line 1790: IF p_in_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM

1786: x_out_rec.STOP_LOCATION_ID,
1787: x_out_rec.stop_location_code);
1788:
1789: ELSIF p_disabled_list(i) = 'STOP_SEQUENCE_NUMBER' THEN
1790: IF p_in_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM
1791: OR p_in_rec.STOP_SEQUENCE_NUMBER IS NULL THEN
1792: x_out_rec.STOP_SEQUENCE_NUMBER := p_in_rec.STOP_SEQUENCE_NUMBER;
1793: END IF;
1794: ELSIF p_disabled_list(i) = 'PLANNED_ARRIVAL_DATE' THEN

Line 1795: IF p_in_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE

1791: OR p_in_rec.STOP_SEQUENCE_NUMBER IS NULL THEN
1792: x_out_rec.STOP_SEQUENCE_NUMBER := p_in_rec.STOP_SEQUENCE_NUMBER;
1793: END IF;
1794: ELSIF p_disabled_list(i) = 'PLANNED_ARRIVAL_DATE' THEN
1795: IF p_in_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE
1796: OR p_in_rec.PLANNED_ARRIVAL_DATE IS NULL THEN
1797: x_out_rec.PLANNED_ARRIVAL_DATE := p_in_rec.PLANNED_ARRIVAL_DATE ;
1798: END IF;
1799: ELSIF p_disabled_list(i) = 'PLANNED_DEPARTURE_DATE' THEN

Line 1800: IF p_in_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE

1796: OR p_in_rec.PLANNED_ARRIVAL_DATE IS NULL THEN
1797: x_out_rec.PLANNED_ARRIVAL_DATE := p_in_rec.PLANNED_ARRIVAL_DATE ;
1798: END IF;
1799: ELSIF p_disabled_list(i) = 'PLANNED_DEPARTURE_DATE' THEN
1800: IF p_in_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE
1801: OR p_in_rec.PLANNED_DEPARTURE_DATE IS NULL THEN
1802: x_out_rec.PLANNED_DEPARTURE_DATE := p_in_rec.PLANNED_DEPARTURE_DATE ;
1803: END IF;
1804: -- J-IB-NPARIKH-{

Line 1806: IF p_in_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM

1802: x_out_rec.PLANNED_DEPARTURE_DATE := p_in_rec.PLANNED_DEPARTURE_DATE ;
1803: END IF;
1804: -- J-IB-NPARIKH-{
1805: ELSIF p_disabled_list(i) = 'DEPARTURE_GROSS_WEIGHT' THEN
1806: IF p_in_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM
1807: OR p_in_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1808: x_out_rec.DEPARTURE_GROSS_WEIGHT := p_in_rec.DEPARTURE_GROSS_WEIGHT ;
1809: END IF;
1810: ELSIF p_disabled_list(i) = 'DEPARTURE_NET_WEIGHT' THEN

Line 1811: IF p_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM

1807: OR p_in_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1808: x_out_rec.DEPARTURE_GROSS_WEIGHT := p_in_rec.DEPARTURE_GROSS_WEIGHT ;
1809: END IF;
1810: ELSIF p_disabled_list(i) = 'DEPARTURE_NET_WEIGHT' THEN
1811: IF p_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
1812: OR p_in_rec.DEPARTURE_NET_WEIGHT IS NULL THEN
1813: x_out_rec.DEPARTURE_NET_WEIGHT := p_in_rec.DEPARTURE_NET_WEIGHT ;
1814: END IF;
1815: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN

Line 1822: IF p_in_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM

1818: NULL,
1819: x_out_rec.WEIGHT_UOM_CODE,
1820: x_out_rec.WEIGHT_UOM_DESC);
1821: ELSIF p_disabled_list(i) = 'DEPARTURE_VOLUME' THEN
1822: IF p_in_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM
1823: OR p_in_rec.DEPARTURE_VOLUME IS NULL THEN
1824: x_out_rec.DEPARTURE_VOLUME := p_in_rec.DEPARTURE_VOLUME ;
1825: END IF;
1826: ELSIF p_disabled_list(i) = 'VOLUME_UOM_CODE' THEN

Line 1835: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR

1831: x_out_rec.VOLUME_UOM_DESC);
1832: -- J-IB-NPARIKH-}
1833:
1834: ELSIF p_disabled_list(i) = 'DESC_FLEX' THEN
1835: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
1836: OR p_in_rec.attribute1 IS NULL THEN
1837: x_out_rec.attribute1 := p_in_rec.attribute1 ;
1838: END IF;
1839: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR

Line 1839: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR

1835: IF p_in_rec.attribute1 <> FND_API.G_MISS_CHAR
1836: OR p_in_rec.attribute1 IS NULL THEN
1837: x_out_rec.attribute1 := p_in_rec.attribute1 ;
1838: END IF;
1839: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
1840: OR p_in_rec.attribute2 IS NULL THEN
1841: x_out_rec.attribute2 := p_in_rec.attribute2 ;
1842: END IF;
1843: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR

Line 1843: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR

1839: IF p_in_rec.attribute2 <> FND_API.G_MISS_CHAR
1840: OR p_in_rec.attribute2 IS NULL THEN
1841: x_out_rec.attribute2 := p_in_rec.attribute2 ;
1842: END IF;
1843: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
1844: OR p_in_rec.attribute3 IS NULL THEN
1845: x_out_rec.attribute3 := p_in_rec.attribute3 ;
1846: END IF;
1847: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR

Line 1847: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR

1843: IF p_in_rec.attribute3 <> FND_API.G_MISS_CHAR
1844: OR p_in_rec.attribute3 IS NULL THEN
1845: x_out_rec.attribute3 := p_in_rec.attribute3 ;
1846: END IF;
1847: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
1848: OR p_in_rec.attribute4 IS NULL THEN
1849: x_out_rec.attribute4 := p_in_rec.attribute4 ;
1850: END IF;
1851: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR

Line 1851: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR

1847: IF p_in_rec.attribute4 <> FND_API.G_MISS_CHAR
1848: OR p_in_rec.attribute4 IS NULL THEN
1849: x_out_rec.attribute4 := p_in_rec.attribute4 ;
1850: END IF;
1851: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
1852: OR p_in_rec.attribute5 IS NULL THEN
1853: x_out_rec.attribute5 := p_in_rec.attribute5 ;
1854: END IF;
1855: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR

Line 1855: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR

1851: IF p_in_rec.attribute5 <> FND_API.G_MISS_CHAR
1852: OR p_in_rec.attribute5 IS NULL THEN
1853: x_out_rec.attribute5 := p_in_rec.attribute5 ;
1854: END IF;
1855: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
1856: OR p_in_rec.attribute6 IS NULL THEN
1857: x_out_rec.attribute6 := p_in_rec.attribute6 ;
1858: END IF;
1859: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR

Line 1859: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR

1855: IF p_in_rec.attribute6 <> FND_API.G_MISS_CHAR
1856: OR p_in_rec.attribute6 IS NULL THEN
1857: x_out_rec.attribute6 := p_in_rec.attribute6 ;
1858: END IF;
1859: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
1860: OR p_in_rec.attribute7 IS NULL THEN
1861: x_out_rec.attribute7 := p_in_rec.attribute7 ;
1862: END IF;
1863: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR

Line 1863: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR

1859: IF p_in_rec.attribute7 <> FND_API.G_MISS_CHAR
1860: OR p_in_rec.attribute7 IS NULL THEN
1861: x_out_rec.attribute7 := p_in_rec.attribute7 ;
1862: END IF;
1863: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
1864: OR p_in_rec.attribute8 IS NULL THEN
1865: x_out_rec.attribute8 := p_in_rec.attribute8 ;
1866: END IF;
1867: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR

Line 1867: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR

1863: IF p_in_rec.attribute8 <> FND_API.G_MISS_CHAR
1864: OR p_in_rec.attribute8 IS NULL THEN
1865: x_out_rec.attribute8 := p_in_rec.attribute8 ;
1866: END IF;
1867: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
1868: OR p_in_rec.attribute9 IS NULL THEN
1869: x_out_rec.attribute9 := p_in_rec.attribute9 ;
1870: END IF;
1871: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR

Line 1871: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR

1867: IF p_in_rec.attribute9 <> FND_API.G_MISS_CHAR
1868: OR p_in_rec.attribute9 IS NULL THEN
1869: x_out_rec.attribute9 := p_in_rec.attribute9 ;
1870: END IF;
1871: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
1872: OR p_in_rec.attribute10 IS NULL THEN
1873: x_out_rec.attribute10 := p_in_rec.attribute10 ;
1874: END IF;
1875: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR

Line 1875: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR

1871: IF p_in_rec.attribute10 <> FND_API.G_MISS_CHAR
1872: OR p_in_rec.attribute10 IS NULL THEN
1873: x_out_rec.attribute10 := p_in_rec.attribute10 ;
1874: END IF;
1875: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
1876: OR p_in_rec.attribute11 IS NULL THEN
1877: x_out_rec.attribute11 := p_in_rec.attribute11 ;
1878: END IF;
1879: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR

Line 1879: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR

1875: IF p_in_rec.attribute11 <> FND_API.G_MISS_CHAR
1876: OR p_in_rec.attribute11 IS NULL THEN
1877: x_out_rec.attribute11 := p_in_rec.attribute11 ;
1878: END IF;
1879: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
1880: OR p_in_rec.attribute12 IS NULL THEN
1881: x_out_rec.attribute12 := p_in_rec.attribute12 ;
1882: END IF;
1883: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR

Line 1883: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR

1879: IF p_in_rec.attribute12 <> FND_API.G_MISS_CHAR
1880: OR p_in_rec.attribute12 IS NULL THEN
1881: x_out_rec.attribute12 := p_in_rec.attribute12 ;
1882: END IF;
1883: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
1884: OR p_in_rec.attribute13 IS NULL THEN
1885: x_out_rec.attribute13 := p_in_rec.attribute13 ;
1886: END IF;
1887: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR

Line 1887: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR

1883: IF p_in_rec.attribute13 <> FND_API.G_MISS_CHAR
1884: OR p_in_rec.attribute13 IS NULL THEN
1885: x_out_rec.attribute13 := p_in_rec.attribute13 ;
1886: END IF;
1887: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
1888: OR p_in_rec.attribute14 IS NULL THEN
1889: x_out_rec.attribute14 := p_in_rec.attribute14 ;
1890: END IF;
1891: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR

Line 1891: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR

1887: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
1888: OR p_in_rec.attribute14 IS NULL THEN
1889: x_out_rec.attribute14 := p_in_rec.attribute14 ;
1890: END IF;
1891: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
1892: OR p_in_rec.attribute15 IS NULL THEN
1893: x_out_rec.attribute15 := p_in_rec.attribute15 ;
1894: END IF;
1895: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR

Line 1895: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR

1891: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
1892: OR p_in_rec.attribute15 IS NULL THEN
1893: x_out_rec.attribute15 := p_in_rec.attribute15 ;
1894: END IF;
1895: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR
1896: OR p_in_rec.attribute_category IS NULL THEN
1897: x_out_rec.attribute_category := p_in_rec.attribute_category ;
1898: END IF;
1899: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN

Line 1900: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR

1896: OR p_in_rec.attribute_category IS NULL THEN
1897: x_out_rec.attribute_category := p_in_rec.attribute_category ;
1898: END IF;
1899: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
1900: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
1901: OR p_in_rec.tp_attribute1 IS NULL THEN
1902: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
1903: END IF;
1904: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR

Line 1904: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR

1900: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
1901: OR p_in_rec.tp_attribute1 IS NULL THEN
1902: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
1903: END IF;
1904: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
1905: OR p_in_rec.tp_attribute2 IS NULL THEN
1906: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
1907: END IF;
1908: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR

Line 1908: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR

1904: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR
1905: OR p_in_rec.tp_attribute2 IS NULL THEN
1906: x_out_rec.tp_attribute2 := p_in_rec.tp_attribute2 ;
1907: END IF;
1908: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
1909: OR p_in_rec.tp_attribute3 IS NULL THEN
1910: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
1911: END IF;
1912: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR

Line 1912: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR

1908: IF p_in_rec.tp_attribute3 <> FND_API.G_MISS_CHAR
1909: OR p_in_rec.tp_attribute3 IS NULL THEN
1910: x_out_rec.tp_attribute3 := p_in_rec.tp_attribute3 ;
1911: END IF;
1912: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
1913: OR p_in_rec.tp_attribute4 IS NULL THEN
1914: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
1915: END IF;
1916: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR

Line 1916: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR

1912: IF p_in_rec.tp_attribute4 <> FND_API.G_MISS_CHAR
1913: OR p_in_rec.tp_attribute4 IS NULL THEN
1914: x_out_rec.tp_attribute4 := p_in_rec.tp_attribute4 ;
1915: END IF;
1916: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
1917: OR p_in_rec.tp_attribute5 IS NULL THEN
1918: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
1919: END IF;
1920: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR

Line 1920: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR

1916: IF p_in_rec.tp_attribute5 <> FND_API.G_MISS_CHAR
1917: OR p_in_rec.tp_attribute5 IS NULL THEN
1918: x_out_rec.tp_attribute5 := p_in_rec.tp_attribute5 ;
1919: END IF;
1920: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
1921: OR p_in_rec.tp_attribute6 IS NULL THEN
1922: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
1923: END IF;
1924: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR

Line 1924: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR

1920: IF p_in_rec.tp_attribute6 <> FND_API.G_MISS_CHAR
1921: OR p_in_rec.tp_attribute6 IS NULL THEN
1922: x_out_rec.tp_attribute6 := p_in_rec.tp_attribute6 ;
1923: END IF;
1924: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
1925: OR p_in_rec.tp_attribute7 IS NULL THEN
1926: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
1927: END IF;
1928: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR

Line 1928: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR

1924: IF p_in_rec.tp_attribute7 <> FND_API.G_MISS_CHAR
1925: OR p_in_rec.tp_attribute7 IS NULL THEN
1926: x_out_rec.tp_attribute7 := p_in_rec.tp_attribute7 ;
1927: END IF;
1928: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
1929: OR p_in_rec.tp_attribute8 IS NULL THEN
1930: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
1931: END IF;
1932: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR

Line 1932: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR

1928: IF p_in_rec.tp_attribute8 <> FND_API.G_MISS_CHAR
1929: OR p_in_rec.tp_attribute8 IS NULL THEN
1930: x_out_rec.tp_attribute8 := p_in_rec.tp_attribute8 ;
1931: END IF;
1932: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
1933: OR p_in_rec.tp_attribute9 IS NULL THEN
1934: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
1935: END IF;
1936: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR

Line 1936: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR

1932: IF p_in_rec.tp_attribute9 <> FND_API.G_MISS_CHAR
1933: OR p_in_rec.tp_attribute9 IS NULL THEN
1934: x_out_rec.tp_attribute9 := p_in_rec.tp_attribute9 ;
1935: END IF;
1936: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
1937: OR p_in_rec.tp_attribute10 IS NULL THEN
1938: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
1939: END IF;
1940: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR

Line 1940: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR

1936: IF p_in_rec.tp_attribute10 <> FND_API.G_MISS_CHAR
1937: OR p_in_rec.tp_attribute10 IS NULL THEN
1938: x_out_rec.tp_attribute10 := p_in_rec.tp_attribute10 ;
1939: END IF;
1940: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
1941: OR p_in_rec.tp_attribute11 IS NULL THEN
1942: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
1943: END IF;
1944: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR

Line 1944: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR

1940: IF p_in_rec.tp_attribute11 <> FND_API.G_MISS_CHAR
1941: OR p_in_rec.tp_attribute11 IS NULL THEN
1942: x_out_rec.tp_attribute11 := p_in_rec.tp_attribute11 ;
1943: END IF;
1944: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
1945: OR p_in_rec.tp_attribute12 IS NULL THEN
1946: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
1947: END IF;
1948: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR

Line 1948: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR

1944: IF p_in_rec.tp_attribute12 <> FND_API.G_MISS_CHAR
1945: OR p_in_rec.tp_attribute12 IS NULL THEN
1946: x_out_rec.tp_attribute12 := p_in_rec.tp_attribute12 ;
1947: END IF;
1948: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
1949: OR p_in_rec.tp_attribute13 IS NULL THEN
1950: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
1951: END IF;
1952: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR

Line 1952: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR

1948: IF p_in_rec.tp_attribute13 <> FND_API.G_MISS_CHAR
1949: OR p_in_rec.tp_attribute13 IS NULL THEN
1950: x_out_rec.tp_attribute13 := p_in_rec.tp_attribute13 ;
1951: END IF;
1952: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
1953: OR p_in_rec.tp_attribute14 IS NULL THEN
1954: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
1955: END IF;
1956: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR

Line 1956: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR

1952: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
1953: OR p_in_rec.tp_attribute14 IS NULL THEN
1954: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
1955: END IF;
1956: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
1957: OR p_in_rec.tp_attribute15 IS NULL THEN
1958: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
1959: END IF;
1960: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR

Line 1960: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR

1956: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
1957: OR p_in_rec.tp_attribute15 IS NULL THEN
1958: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
1959: END IF;
1960: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
1961: OR p_in_rec.tp_attribute_category IS NULL THEN
1962: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
1963: END IF;
1964: --ELSIF p_disabled_list(i) = 'FULL' THEN

Line 2119: x_return_status := FND_API.G_RET_STS_SUCCESS;

2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2116: --
2117: END IF;
2118: --
2119: x_return_status := FND_API.G_RET_STS_SUCCESS;
2120: --
2121: IF p_in_rec.action_code = 'CREATE' THEN
2122: --
2123: IF l_debug_on THEN

Line 2131: IF (p_stop_rec.trip_name <> FND_API.G_MISS_CHAR) THEN

2127: -- nothing else need to be disabled
2128: --
2129: eliminate_displayonly_fields (p_stop_rec,p_in_rec, x_stop_rec);
2130: --
2131: IF (p_stop_rec.trip_name <> FND_API.G_MISS_CHAR) THEN
2132: x_stop_rec.trip_name := p_stop_rec.trip_name;
2133: END IF;
2134: --
2135: IF (p_parent_entity_id <> FND_API.G_MISS_NUM) THEN

Line 2135: IF (p_parent_entity_id <> FND_API.G_MISS_NUM) THEN

2131: IF (p_stop_rec.trip_name <> FND_API.G_MISS_CHAR) THEN
2132: x_stop_rec.trip_name := p_stop_rec.trip_name;
2133: END IF;
2134: --
2135: IF (p_parent_entity_id <> FND_API.G_MISS_NUM) THEN
2136: x_stop_rec.trip_id := p_parent_entity_id;
2137: END IF;
2138: --
2139: --3509004: public api changes, commented the following code.

Line 2151: IF (l_parent_entity_id IS NULL ) OR l_parent_entity_id = FND_API.G_MISS_NUM THEN

2147: ELSIF p_in_rec.action_code = 'UPDATE' THEN
2148: --
2149: l_parent_entity_id := p_parent_entity_id;
2150: --
2151: IF (l_parent_entity_id IS NULL ) OR l_parent_entity_id = FND_API.G_MISS_NUM THEN
2152: --
2153: OPEN get_trip_id(p_stop_rec.stop_id);
2154: FETCH get_trip_id INTO l_parent_entity_id;
2155: --

Line 2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: END IF;
2159: --
2160: IF (get_trip_id%NOTFOUND OR l_parent_entity_id IS NULL) THEN
2161: CLOSE get_trip_id;
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;
2164: --
2165: CLOSE get_trip_id;
2166: --

Line 2581: RAISE FND_API.G_EXC_ERROR;

2577: --
2578: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2579: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_trip_id');
2580: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2581: RAISE FND_API.G_EXC_ERROR;
2582: --}
2583: END IF;
2584: --
2585: IF p_stop_id IS NULL

Line 2594: RAISE FND_API.G_EXC_ERROR;

2590: --
2591: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2592: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_stop_id');
2593: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2594: RAISE FND_API.G_EXC_ERROR;
2595: --}
2596: END IF;
2597: --
2598: --

Line 2714: WHEN FND_API.G_EXC_ERROR THEN

2710: --}
2711: EXCEPTION
2712: --{
2713: --
2714: WHEN FND_API.G_EXC_ERROR THEN
2715:
2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2717: --
2718: IF l_debug_on THEN

Line 2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2715:
2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2721: END IF;
2722: --
2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2721: END IF;
2722: --
2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2724:

Line 2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2721: END IF;
2722: --
2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2724:
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2726: --
2727: IF l_debug_on THEN

Line 2729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2726: --
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2730: END IF;
2731: --
2732: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2733: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3263: RAISE FND_API.G_EXC_ERROR;

3259: --CLOSE stop_info_csr;
3260: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
3261: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
3262: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3263: RAISE FND_API.G_EXC_ERROR;
3264: --}
3265: END IF;
3266: --
3267: CLOSE stop_info_csr;

Line 3406: RAISE FND_API.G_EXC_ERROR;

3402: );
3403: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3404: x_return_status := l_return_status;
3405: wsh_util_core.add_message(x_return_status);
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;
3408: FOR exp_cnt in 1..l_exceptions_tbl.COUNT LOOP
3409: IF l_exceptions_tbl(exp_cnt).exception_behavior = 'ERROR' THEN
3410: IF l_exceptions_tbl(exp_cnt).entity_name = 'STOP' THEN

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422: l_out_status);
3423:
3424: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3425: wsh_util_core.add_message(l_out_status);
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429: -- End of code BugFix #3947506
3430:

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454: l_out_status);
3455:
3456: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3457: wsh_util_core.add_message(l_out_status);
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460: -- End of code BugFix #3947506
3461: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3462: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506

Line 4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4958: x_out_Rec.close_allowed := 'NW';
4959: --
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4964: END IF;
4965: --
4966: WHEN FND_API.G_EXC_ERROR THEN

Line 4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

4959: --
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4964: END IF;
4965: --
4966: WHEN FND_API.G_EXC_ERROR THEN
4967:

Line 4966: WHEN FND_API.G_EXC_ERROR THEN

4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4964: END IF;
4965: --
4966: WHEN FND_API.G_EXC_ERROR THEN
4967:
4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4969: --
4970: IF l_debug_on THEN

Line 4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4967:
4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4969: --
4970: IF l_debug_on THEN
4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4973: END IF;
4974: --
4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4969: --
4970: IF l_debug_on THEN
4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4973: END IF;
4974: --
4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4976:

Line 4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4973: END IF;
4974: --
4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4976:
4977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4978: --
4979: IF l_debug_on THEN

Line 4981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4978: --
4979: IF l_debug_on THEN
4980: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4982: END IF;
4983: --
4984: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5194: WHEN FND_API.G_EXC_ERROR THEN

5190: END IF;
5191: --}
5192: EXCEPTION
5193: --
5194: WHEN FND_API.G_EXC_ERROR THEN
5195:
5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5197: --
5198: IF l_debug_on THEN

Line 5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5195:
5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5197: --
5198: IF l_debug_on THEN
5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5201: END IF;
5202: --
5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5197: --
5198: IF l_debug_on THEN
5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5201: END IF;
5202: --
5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5204:

Line 5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5201: END IF;
5202: --
5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5204:
5205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5206: --
5207: IF l_debug_on THEN

Line 5209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

5205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5206: --
5207: IF l_debug_on THEN
5208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5210: END IF;
5211: --
5212: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5213: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5265: x_return_status := FND_API.G_RET_STS_SUCCESS;

5261: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5262: --
5263: END IF;
5264: --
5265: x_return_status := FND_API.G_RET_STS_SUCCESS;
5266: --
5267: IF p_user_in_rec.STOP_ID <> FND_API.G_MISS_NUM
5268: AND NVL(p_user_in_rec.STOP_ID,-99) <> NVL(p_out_rec.STOP_ID,-99)
5269: THEN

Line 5267: IF p_user_in_rec.STOP_ID <> FND_API.G_MISS_NUM

5263: END IF;
5264: --
5265: x_return_status := FND_API.G_RET_STS_SUCCESS;
5266: --
5267: IF p_user_in_rec.STOP_ID <> FND_API.G_MISS_NUM
5268: AND NVL(p_user_in_rec.STOP_ID,-99) <> NVL(p_out_rec.STOP_ID,-99)
5269: THEN
5270: l_attributes := l_attributes || 'STOP_ID, ';
5271: END IF;

Line 5273: IF p_user_in_rec.TRIP_ID <> FND_API.G_MISS_NUM

5269: THEN
5270: l_attributes := l_attributes || 'STOP_ID, ';
5271: END IF;
5272:
5273: IF p_user_in_rec.TRIP_ID <> FND_API.G_MISS_NUM
5274: AND NVL(p_user_in_rec.TRIP_ID,-99) <> NVL(p_out_rec.TRIP_ID,-99)
5275: THEN
5276: l_attributes := l_attributes || 'TRIP_ID, ';
5277: END IF;

Line 5279: IF p_user_in_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM

5275: THEN
5276: l_attributes := l_attributes || 'TRIP_ID, ';
5277: END IF;
5278:
5279: IF p_user_in_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM
5280: AND NVL(p_user_in_rec.STOP_LOCATION_ID,-99) <> NVL(p_out_rec.STOP_LOCATION_ID,-99)
5281: THEN
5282: l_attributes := l_attributes || 'STOP_LOCATION_ID, ';
5283: END IF;

Line 5285: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR

5281: THEN
5282: l_attributes := l_attributes || 'STOP_LOCATION_ID, ';
5283: END IF;
5284:
5285: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR
5286: AND NVL(p_user_in_rec.STATUS_CODE,'!!!') <> NVL(p_out_rec.STATUS_CODE,'!!!')
5287: THEN
5288: l_attributes := l_attributes || 'STATUS_CODE, ';
5289: END IF;

Line 5291: IF p_user_in_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM

5287: THEN
5288: l_attributes := l_attributes || 'STATUS_CODE, ';
5289: END IF;
5290:
5291: IF p_user_in_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM
5292: AND NVL(p_user_in_rec.STOP_SEQUENCE_NUMBER,-99) <> NVL(p_out_rec.STOP_SEQUENCE_NUMBER,-99)
5293: THEN
5294: l_attributes := l_attributes || 'STOP_SEQUENCE_NUMBER, ';
5295: END IF;

Line 5297: IF p_user_in_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE

5293: THEN
5294: l_attributes := l_attributes || 'STOP_SEQUENCE_NUMBER, ';
5295: END IF;
5296:
5297: IF p_user_in_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE
5298: AND NVL(p_user_in_rec.PLANNED_ARRIVAL_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PLANNED_ARRIVAL_DATE,TO_DATE('2','j'))
5299: THEN
5300: l_attributes := l_attributes || 'PLANNED_ARRIVAL_DATE, ';
5301: END IF;

Line 5303: IF p_user_in_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE

5299: THEN
5300: l_attributes := l_attributes || 'PLANNED_ARRIVAL_DATE, ';
5301: END IF;
5302:
5303: IF p_user_in_rec.PLANNED_DEPARTURE_DATE <> FND_API.G_MISS_DATE
5304: AND NVL(p_user_in_rec.PLANNED_DEPARTURE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PLANNED_DEPARTURE_DATE,TO_DATE('2','j'))
5305: THEN
5306: l_attributes := l_attributes || 'PLANNED_DEPARTURE_DATE, ';
5307: END IF;

Line 5309: IF p_user_in_rec.ACTUAL_ARRIVAL_DATE <> FND_API.G_MISS_DATE

5305: THEN
5306: l_attributes := l_attributes || 'PLANNED_DEPARTURE_DATE, ';
5307: END IF;
5308:
5309: IF p_user_in_rec.ACTUAL_ARRIVAL_DATE <> FND_API.G_MISS_DATE
5310: AND NVL(p_user_in_rec.ACTUAL_ARRIVAL_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ACTUAL_ARRIVAL_DATE,TO_DATE('2','j'))
5311: THEN
5312: l_attributes := l_attributes || 'ACTUAL_ARRIVAL_DATE, ';
5313: END IF;

Line 5315: IF p_user_in_rec.ACTUAL_DEPARTURE_DATE <> FND_API.G_MISS_DATE

5311: THEN
5312: l_attributes := l_attributes || 'ACTUAL_ARRIVAL_DATE, ';
5313: END IF;
5314:
5315: IF p_user_in_rec.ACTUAL_DEPARTURE_DATE <> FND_API.G_MISS_DATE
5316: AND NVL(p_user_in_rec.ACTUAL_DEPARTURE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ACTUAL_DEPARTURE_DATE,TO_DATE('2','j'))
5317: THEN
5318: l_attributes := l_attributes || 'ACTUAL_DEPARTURE_DATE, ';
5319: END IF;

Line 5321: IF p_user_in_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM

5317: THEN
5318: l_attributes := l_attributes || 'ACTUAL_DEPARTURE_DATE, ';
5319: END IF;
5320:
5321: IF p_user_in_rec.DEPARTURE_GROSS_WEIGHT <> FND_API.G_MISS_NUM
5322: AND NVL(p_user_in_rec.DEPARTURE_GROSS_WEIGHT,-99) <> NVL(p_out_rec.DEPARTURE_GROSS_WEIGHT,-99)
5323: THEN
5324: l_attributes := l_attributes || 'DEPARTURE_GROSS_WEIGHT, ';
5325: END IF;

Line 5327: IF p_user_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM

5323: THEN
5324: l_attributes := l_attributes || 'DEPARTURE_GROSS_WEIGHT, ';
5325: END IF;
5326:
5327: IF p_user_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
5328: AND NVL(p_user_in_rec.DEPARTURE_NET_WEIGHT,-99) <> NVL(p_out_rec.DEPARTURE_NET_WEIGHT,-99)
5329: THEN
5330: l_attributes := l_attributes || 'DEPARTURE_NET_WEIGHT, ';
5331: END IF;

Line 5333: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR

5329: THEN
5330: l_attributes := l_attributes || 'DEPARTURE_NET_WEIGHT, ';
5331: END IF;
5332:
5333: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
5334: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
5335: THEN
5336: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
5337: END IF;

Line 5339: IF p_user_in_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM

5335: THEN
5336: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
5337: END IF;
5338:
5339: IF p_user_in_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM
5340: AND NVL(p_user_in_rec.DEPARTURE_VOLUME,-99) <> NVL(p_out_rec.DEPARTURE_VOLUME,-99)
5341: THEN
5342: l_attributes := l_attributes || 'DEPARTURE_VOLUME, ';
5343: END IF;

Line 5345: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR

5341: THEN
5342: l_attributes := l_attributes || 'DEPARTURE_VOLUME, ';
5343: END IF;
5344:
5345: IF p_user_in_rec.VOLUME_UOM_CODE <> FND_API.G_MISS_CHAR
5346: AND NVL(p_user_in_rec.VOLUME_UOM_CODE,'!!!') <> NVL(p_out_rec.VOLUME_UOM_CODE,'!!!')
5347: THEN
5348: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
5349: END IF;

Line 5351: IF p_user_in_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR

5347: THEN
5348: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
5349: END IF;
5350:
5351: IF p_user_in_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR
5352: AND NVL(p_user_in_rec.DEPARTURE_SEAL_CODE,'!!!') <> NVL(p_out_rec.DEPARTURE_SEAL_CODE,'!!!')
5353: THEN
5354: l_attributes := l_attributes || 'DEPARTURE_SEAL_CODE, ';
5355: END IF;

Line 5357: IF p_user_in_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM

5353: THEN
5354: l_attributes := l_attributes || 'DEPARTURE_SEAL_CODE, ';
5355: END IF;
5356:
5357: IF p_user_in_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM
5358: AND NVL(p_user_in_rec.DEPARTURE_FILL_PERCENT,-99) <> NVL(p_out_rec.DEPARTURE_FILL_PERCENT,-99)
5359: THEN
5360: l_attributes := l_attributes || 'DEPARTURE_FILL_PERCENT, ';
5361: END IF;

Line 5363: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

5359: THEN
5360: l_attributes := l_attributes || 'DEPARTURE_FILL_PERCENT, ';
5361: END IF;
5362:
5363: IF p_user_in_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
5364: AND NVL(p_user_in_rec.TP_ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE_CATEGORY,'!!!')
5365: THEN
5366: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
5367: END IF;

Line 5369: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR

5365: THEN
5366: l_attributes := l_attributes || 'TP_ATTRIBUTE_CATEGORY, ';
5367: END IF;
5368:
5369: IF p_user_in_rec.TP_ATTRIBUTE1 <> FND_API.G_MISS_CHAR
5370: AND NVL(p_user_in_rec.TP_ATTRIBUTE1,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE1,'!!!')
5371: THEN
5372: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
5373: END IF;

Line 5375: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR

5371: THEN
5372: l_attributes := l_attributes || 'TP_ATTRIBUTE1, ';
5373: END IF;
5374:
5375: IF p_user_in_rec.TP_ATTRIBUTE2 <> FND_API.G_MISS_CHAR
5376: AND NVL(p_user_in_rec.TP_ATTRIBUTE2,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE2,'!!!')
5377: THEN
5378: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
5379: END IF;

Line 5381: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR

5377: THEN
5378: l_attributes := l_attributes || 'TP_ATTRIBUTE2, ';
5379: END IF;
5380:
5381: IF p_user_in_rec.TP_ATTRIBUTE3 <> FND_API.G_MISS_CHAR
5382: AND NVL(p_user_in_rec.TP_ATTRIBUTE3,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE3,'!!!')
5383: THEN
5384: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
5385: END IF;

Line 5387: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR

5383: THEN
5384: l_attributes := l_attributes || 'TP_ATTRIBUTE3, ';
5385: END IF;
5386:
5387: IF p_user_in_rec.TP_ATTRIBUTE4 <> FND_API.G_MISS_CHAR
5388: AND NVL(p_user_in_rec.TP_ATTRIBUTE4,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE4,'!!!')
5389: THEN
5390: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
5391: END IF;

Line 5393: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR

5389: THEN
5390: l_attributes := l_attributes || 'TP_ATTRIBUTE4, ';
5391: END IF;
5392:
5393: IF p_user_in_rec.TP_ATTRIBUTE5 <> FND_API.G_MISS_CHAR
5394: AND NVL(p_user_in_rec.TP_ATTRIBUTE5,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE5,'!!!')
5395: THEN
5396: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
5397: END IF;

Line 5399: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR

5395: THEN
5396: l_attributes := l_attributes || 'TP_ATTRIBUTE5, ';
5397: END IF;
5398:
5399: IF p_user_in_rec.TP_ATTRIBUTE6 <> FND_API.G_MISS_CHAR
5400: AND NVL(p_user_in_rec.TP_ATTRIBUTE6,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE6,'!!!')
5401: THEN
5402: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
5403: END IF;

Line 5405: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR

5401: THEN
5402: l_attributes := l_attributes || 'TP_ATTRIBUTE6, ';
5403: END IF;
5404:
5405: IF p_user_in_rec.TP_ATTRIBUTE7 <> FND_API.G_MISS_CHAR
5406: AND NVL(p_user_in_rec.TP_ATTRIBUTE7,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE7,'!!!')
5407: THEN
5408: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
5409: END IF;

Line 5411: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR

5407: THEN
5408: l_attributes := l_attributes || 'TP_ATTRIBUTE7, ';
5409: END IF;
5410:
5411: IF p_user_in_rec.TP_ATTRIBUTE8 <> FND_API.G_MISS_CHAR
5412: AND NVL(p_user_in_rec.TP_ATTRIBUTE8,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE8,'!!!')
5413: THEN
5414: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
5415: END IF;

Line 5417: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR

5413: THEN
5414: l_attributes := l_attributes || 'TP_ATTRIBUTE8, ';
5415: END IF;
5416:
5417: IF p_user_in_rec.TP_ATTRIBUTE9 <> FND_API.G_MISS_CHAR
5418: AND NVL(p_user_in_rec.TP_ATTRIBUTE9,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE9,'!!!')
5419: THEN
5420: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
5421: END IF;

Line 5423: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR

5419: THEN
5420: l_attributes := l_attributes || 'TP_ATTRIBUTE9, ';
5421: END IF;
5422:
5423: IF p_user_in_rec.TP_ATTRIBUTE10 <> FND_API.G_MISS_CHAR
5424: AND NVL(p_user_in_rec.TP_ATTRIBUTE10,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE10,'!!!')
5425: THEN
5426: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
5427: END IF;

Line 5429: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR

5425: THEN
5426: l_attributes := l_attributes || 'TP_ATTRIBUTE10, ';
5427: END IF;
5428:
5429: IF p_user_in_rec.TP_ATTRIBUTE11 <> FND_API.G_MISS_CHAR
5430: AND NVL(p_user_in_rec.TP_ATTRIBUTE11,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE11,'!!!')
5431: THEN
5432: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
5433: END IF;

Line 5435: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR

5431: THEN
5432: l_attributes := l_attributes || 'TP_ATTRIBUTE11, ';
5433: END IF;
5434:
5435: IF p_user_in_rec.TP_ATTRIBUTE12 <> FND_API.G_MISS_CHAR
5436: AND NVL(p_user_in_rec.TP_ATTRIBUTE12,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE12,'!!!')
5437: THEN
5438: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
5439: END IF;

Line 5441: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR

5437: THEN
5438: l_attributes := l_attributes || 'TP_ATTRIBUTE12, ';
5439: END IF;
5440:
5441: IF p_user_in_rec.TP_ATTRIBUTE13 <> FND_API.G_MISS_CHAR
5442: AND NVL(p_user_in_rec.TP_ATTRIBUTE13,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE13,'!!!')
5443: THEN
5444: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
5445: END IF;

Line 5447: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR

5443: THEN
5444: l_attributes := l_attributes || 'TP_ATTRIBUTE13, ';
5445: END IF;
5446:
5447: IF p_user_in_rec.TP_ATTRIBUTE14 <> FND_API.G_MISS_CHAR
5448: AND NVL(p_user_in_rec.TP_ATTRIBUTE14,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE14,'!!!')
5449: THEN
5450: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
5451: END IF;

Line 5453: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR

5449: THEN
5450: l_attributes := l_attributes || 'TP_ATTRIBUTE14, ';
5451: END IF;
5452:
5453: IF p_user_in_rec.TP_ATTRIBUTE15 <> FND_API.G_MISS_CHAR
5454: AND NVL(p_user_in_rec.TP_ATTRIBUTE15,'!!!') <> NVL(p_out_rec.TP_ATTRIBUTE15,'!!!')
5455: THEN
5456: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
5457: END IF;

Line 5459: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

5455: THEN
5456: l_attributes := l_attributes || 'TP_ATTRIBUTE15, ';
5457: END IF;
5458:
5459: IF p_user_in_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
5460: AND NVL(p_user_in_rec.ATTRIBUTE_CATEGORY,'!!!') <> NVL(p_out_rec.ATTRIBUTE_CATEGORY,'!!!')
5461: THEN
5462: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
5463: END IF;

Line 5465: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR

5461: THEN
5462: l_attributes := l_attributes || 'ATTRIBUTE_CATEGORY, ';
5463: END IF;
5464:
5465: IF p_user_in_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
5466: AND NVL(p_user_in_rec.ATTRIBUTE1,'!!!') <> NVL(p_out_rec.ATTRIBUTE1,'!!!')
5467: THEN
5468: l_attributes := l_attributes || 'ATTRIBUTE1, ';
5469: END IF;

Line 5471: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR

5467: THEN
5468: l_attributes := l_attributes || 'ATTRIBUTE1, ';
5469: END IF;
5470:
5471: IF p_user_in_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
5472: AND NVL(p_user_in_rec.ATTRIBUTE2,'!!!') <> NVL(p_out_rec.ATTRIBUTE2,'!!!')
5473: THEN
5474: l_attributes := l_attributes || 'ATTRIBUTE2, ';
5475: END IF;

Line 5477: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR

5473: THEN
5474: l_attributes := l_attributes || 'ATTRIBUTE2, ';
5475: END IF;
5476:
5477: IF p_user_in_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
5478: AND NVL(p_user_in_rec.ATTRIBUTE3,'!!!') <> NVL(p_out_rec.ATTRIBUTE3,'!!!')
5479: THEN
5480: l_attributes := l_attributes || 'ATTRIBUTE3, ';
5481: END IF;

Line 5483: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR

5479: THEN
5480: l_attributes := l_attributes || 'ATTRIBUTE3, ';
5481: END IF;
5482:
5483: IF p_user_in_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
5484: AND NVL(p_user_in_rec.ATTRIBUTE4,'!!!') <> NVL(p_out_rec.ATTRIBUTE4,'!!!')
5485: THEN
5486: l_attributes := l_attributes || 'ATTRIBUTE4, ';
5487: END IF;

Line 5489: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR

5485: THEN
5486: l_attributes := l_attributes || 'ATTRIBUTE4, ';
5487: END IF;
5488:
5489: IF p_user_in_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
5490: AND NVL(p_user_in_rec.ATTRIBUTE5,'!!!') <> NVL(p_out_rec.ATTRIBUTE5,'!!!')
5491: THEN
5492: l_attributes := l_attributes || 'ATTRIBUTE5, ';
5493: END IF;

Line 5495: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR

5491: THEN
5492: l_attributes := l_attributes || 'ATTRIBUTE5, ';
5493: END IF;
5494:
5495: IF p_user_in_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
5496: AND NVL(p_user_in_rec.ATTRIBUTE6,'!!!') <> NVL(p_out_rec.ATTRIBUTE6,'!!!')
5497: THEN
5498: l_attributes := l_attributes || 'ATTRIBUTE6, ';
5499: END IF;

Line 5501: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR

5497: THEN
5498: l_attributes := l_attributes || 'ATTRIBUTE6, ';
5499: END IF;
5500:
5501: IF p_user_in_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
5502: AND NVL(p_user_in_rec.ATTRIBUTE7,'!!!') <> NVL(p_out_rec.ATTRIBUTE7,'!!!')
5503: THEN
5504: l_attributes := l_attributes || 'ATTRIBUTE7, ';
5505: END IF;

Line 5507: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR

5503: THEN
5504: l_attributes := l_attributes || 'ATTRIBUTE7, ';
5505: END IF;
5506:
5507: IF p_user_in_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
5508: AND NVL(p_user_in_rec.ATTRIBUTE8,'!!!') <> NVL(p_out_rec.ATTRIBUTE8,'!!!')
5509: THEN
5510: l_attributes := l_attributes || 'ATTRIBUTE8, ';
5511: END IF;

Line 5513: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR

5509: THEN
5510: l_attributes := l_attributes || 'ATTRIBUTE8, ';
5511: END IF;
5512:
5513: IF p_user_in_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
5514: AND NVL(p_user_in_rec.ATTRIBUTE9,'!!!') <> NVL(p_out_rec.ATTRIBUTE9,'!!!')
5515: THEN
5516: l_attributes := l_attributes || 'ATTRIBUTE9, ';
5517: END IF;

Line 5519: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR

5515: THEN
5516: l_attributes := l_attributes || 'ATTRIBUTE9, ';
5517: END IF;
5518:
5519: IF p_user_in_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
5520: AND NVL(p_user_in_rec.ATTRIBUTE10,'!!!') <> NVL(p_out_rec.ATTRIBUTE10,'!!!')
5521: THEN
5522: l_attributes := l_attributes || 'ATTRIBUTE10, ';
5523: END IF;

Line 5525: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR

5521: THEN
5522: l_attributes := l_attributes || 'ATTRIBUTE10, ';
5523: END IF;
5524:
5525: IF p_user_in_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
5526: AND NVL(p_user_in_rec.ATTRIBUTE11,'!!!') <> NVL(p_out_rec.ATTRIBUTE11,'!!!')
5527: THEN
5528: l_attributes := l_attributes || 'ATTRIBUTE11, ';
5529: END IF;

Line 5531: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR

5527: THEN
5528: l_attributes := l_attributes || 'ATTRIBUTE11, ';
5529: END IF;
5530:
5531: IF p_user_in_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
5532: AND NVL(p_user_in_rec.ATTRIBUTE12,'!!!') <> NVL(p_out_rec.ATTRIBUTE12,'!!!')
5533: THEN
5534: l_attributes := l_attributes || 'ATTRIBUTE12, ';
5535: END IF;

Line 5537: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR

5533: THEN
5534: l_attributes := l_attributes || 'ATTRIBUTE12, ';
5535: END IF;
5536:
5537: IF p_user_in_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
5538: AND NVL(p_user_in_rec.ATTRIBUTE13,'!!!') <> NVL(p_out_rec.ATTRIBUTE13,'!!!')
5539: THEN
5540: l_attributes := l_attributes || 'ATTRIBUTE13, ';
5541: END IF;

Line 5543: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR

5539: THEN
5540: l_attributes := l_attributes || 'ATTRIBUTE13, ';
5541: END IF;
5542:
5543: IF p_user_in_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
5544: AND NVL(p_user_in_rec.ATTRIBUTE14,'!!!') <> NVL(p_out_rec.ATTRIBUTE14,'!!!')
5545: THEN
5546: l_attributes := l_attributes || 'ATTRIBUTE14, ';
5547: END IF;

Line 5549: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR

5545: THEN
5546: l_attributes := l_attributes || 'ATTRIBUTE14, ';
5547: END IF;
5548:
5549: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
5550: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
5551: THEN
5552: l_attributes := l_attributes || 'ATTRIBUTE15, ';
5553: END IF;

Line 5558: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE

5554:
5555: /**
5556: -- Bug 3613650
5557: -- Need not compare against WHO columns
5558: IF p_user_in_rec.CREATION_DATE <> FND_API.G_MISS_DATE
5559: AND NVL(p_user_in_rec.CREATION_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CREATION_DATE,TO_DATE('2','j'))
5560: THEN
5561: l_attributes := l_attributes || 'CREATION_DATE, ';
5562: END IF;

Line 5564: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM

5560: THEN
5561: l_attributes := l_attributes || 'CREATION_DATE, ';
5562: END IF;
5563:
5564: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
5565: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
5566: THEN
5567: l_attributes := l_attributes || 'CREATED_BY, ';
5568: END IF;

Line 5570: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE

5566: THEN
5567: l_attributes := l_attributes || 'CREATED_BY, ';
5568: END IF;
5569:
5570: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
5571: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
5572: THEN
5573: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
5574: END IF;

Line 5576: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM

5572: THEN
5573: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
5574: END IF;
5575:
5576: IF p_user_in_rec.LAST_UPDATED_BY <> FND_API.G_MISS_NUM
5577: AND NVL(p_user_in_rec.LAST_UPDATED_BY,-99) <> NVL(p_out_rec.LAST_UPDATED_BY,-99)
5578: THEN
5579: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
5580: END IF;

Line 5582: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM

5578: THEN
5579: l_attributes := l_attributes || 'LAST_UPDATED_BY, ';
5580: END IF;
5581:
5582: IF p_user_in_rec.LAST_UPDATE_LOGIN <> FND_API.G_MISS_NUM
5583: AND NVL(p_user_in_rec.LAST_UPDATE_LOGIN,-99) <> NVL(p_out_rec.LAST_UPDATE_LOGIN,-99)
5584: THEN
5585: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
5586: END IF;

Line 5588: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM

5584: THEN
5585: l_attributes := l_attributes || 'LAST_UPDATE_LOGIN, ';
5586: END IF;
5587:
5588: IF p_user_in_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
5589: AND NVL(p_user_in_rec.PROGRAM_APPLICATION_ID,-99) <> NVL(p_out_rec.PROGRAM_APPLICATION_ID,-99)
5590: THEN
5591: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
5592: END IF;

Line 5594: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM

5590: THEN
5591: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
5592: END IF;
5593:
5594: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
5595: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
5596: THEN
5597: l_attributes := l_attributes || 'PROGRAM_ID, ';
5598: END IF;

Line 5600: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE

5596: THEN
5597: l_attributes := l_attributes || 'PROGRAM_ID, ';
5598: END IF;
5599:
5600: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
5601: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
5602: THEN
5603: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
5604: END IF;

Line 5606: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM

5602: THEN
5603: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
5604: END IF;
5605:
5606: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
5607: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
5608: THEN
5609: l_attributes := l_attributes || 'REQUEST_ID, ';
5610: END IF;

Line 5614: IF p_user_in_rec.WSH_LOCATION_ID <> FND_API.G_MISS_NUM

5610: END IF;
5611:
5612: bug 3613650 */
5613:
5614: IF p_user_in_rec.WSH_LOCATION_ID <> FND_API.G_MISS_NUM
5615: AND NVL(p_user_in_rec.WSH_LOCATION_ID,-99) <> NVL(p_out_rec.WSH_LOCATION_ID,-99)
5616: THEN
5617: l_attributes := l_attributes || 'WSH_LOCATION_ID, ';
5618: END IF;

Line 5620: IF p_user_in_rec.TRACKING_DRILLDOWN_FLAG <> FND_API.G_MISS_CHAR

5616: THEN
5617: l_attributes := l_attributes || 'WSH_LOCATION_ID, ';
5618: END IF;
5619:
5620: IF p_user_in_rec.TRACKING_DRILLDOWN_FLAG <> FND_API.G_MISS_CHAR
5621: AND NVL(p_user_in_rec.TRACKING_DRILLDOWN_FLAG,'!!!') <> NVL(p_out_rec.TRACKING_DRILLDOWN_FLAG,'!!!')
5622: THEN
5623: l_attributes := l_attributes || 'TRACKING_DRILLDOWN_FLAG, ';
5624: END IF;

Line 5626: IF p_user_in_rec.TRACKING_REMARKS <> FND_API.G_MISS_CHAR

5622: THEN
5623: l_attributes := l_attributes || 'TRACKING_DRILLDOWN_FLAG, ';
5624: END IF;
5625:
5626: IF p_user_in_rec.TRACKING_REMARKS <> FND_API.G_MISS_CHAR
5627: AND NVL(p_user_in_rec.TRACKING_REMARKS,'!!!') <> NVL(p_out_rec.TRACKING_REMARKS,'!!!')
5628: THEN
5629: l_attributes := l_attributes || 'TRACKING_REMARKS, ';
5630: END IF;

Line 5632: IF p_user_in_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE

5628: THEN
5629: l_attributes := l_attributes || 'TRACKING_REMARKS, ';
5630: END IF;
5631:
5632: IF p_user_in_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE
5633: AND NVL(p_user_in_rec.CARRIER_EST_DEPARTURE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CARRIER_EST_DEPARTURE_DATE,TO_DATE('2','j'))
5634: THEN
5635: l_attributes := l_attributes || 'CARRIER_EST_DEPARTURE_DATE, ';
5636: END IF;

Line 5638: IF p_user_in_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE

5634: THEN
5635: l_attributes := l_attributes || 'CARRIER_EST_DEPARTURE_DATE, ';
5636: END IF;
5637:
5638: IF p_user_in_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE
5639: AND NVL(p_user_in_rec.CARRIER_EST_ARRIVAL_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.CARRIER_EST_ARRIVAL_DATE,TO_DATE('2','j'))
5640: THEN
5641: l_attributes := l_attributes || 'CARRIER_EST_ARRIVAL_DATE, ';
5642: END IF;

Line 5644: IF p_user_in_rec.LOADING_START_DATETIME <> FND_API.G_MISS_DATE

5640: THEN
5641: l_attributes := l_attributes || 'CARRIER_EST_ARRIVAL_DATE, ';
5642: END IF;
5643:
5644: IF p_user_in_rec.LOADING_START_DATETIME <> FND_API.G_MISS_DATE
5645: AND NVL(p_user_in_rec.LOADING_START_DATETIME,TO_DATE('2','j')) <> NVL(p_out_rec.LOADING_START_DATETIME,TO_DATE('2','j'))
5646: THEN
5647: l_attributes := l_attributes || 'LOADING_START_DATETIME, ';
5648: END IF;

Line 5650: IF p_user_in_rec.LOADING_END_DATETIME <> FND_API.G_MISS_DATE

5646: THEN
5647: l_attributes := l_attributes || 'LOADING_START_DATETIME, ';
5648: END IF;
5649:
5650: IF p_user_in_rec.LOADING_END_DATETIME <> FND_API.G_MISS_DATE
5651: AND NVL(p_user_in_rec.LOADING_END_DATETIME,TO_DATE('2','j')) <> NVL(p_out_rec.LOADING_END_DATETIME,TO_DATE('2','j'))
5652: THEN
5653: l_attributes := l_attributes || 'LOADING_END_DATETIME, ';
5654: END IF;

Line 5656: IF p_user_in_rec.UNLOADING_START_DATETIME <> FND_API.G_MISS_DATE

5652: THEN
5653: l_attributes := l_attributes || 'LOADING_END_DATETIME, ';
5654: END IF;
5655:
5656: IF p_user_in_rec.UNLOADING_START_DATETIME <> FND_API.G_MISS_DATE
5657: AND NVL(p_user_in_rec.UNLOADING_START_DATETIME,TO_DATE('2','j')) <> NVL(p_out_rec.UNLOADING_START_DATETIME,TO_DATE('2','j'))
5658: THEN
5659: l_attributes := l_attributes || 'UNLOADING_START_DATETIME, ';
5660: END IF;

Line 5662: IF p_user_in_rec.UNLOADING_END_DATETIME <> FND_API.G_MISS_DATE

5658: THEN
5659: l_attributes := l_attributes || 'UNLOADING_START_DATETIME, ';
5660: END IF;
5661:
5662: IF p_user_in_rec.UNLOADING_END_DATETIME <> FND_API.G_MISS_DATE
5663: AND NVL(p_user_in_rec.UNLOADING_END_DATETIME,TO_DATE('2','j')) <> NVL(p_out_rec.UNLOADING_END_DATETIME,TO_DATE('2','j'))
5664: THEN
5665: l_attributes := l_attributes || 'UNLOADING_END_DATETIME, ';
5666: END IF;

Line 5668: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR

5664: THEN
5665: l_attributes := l_attributes || 'UNLOADING_END_DATETIME, ';
5666: END IF;
5667:
5668: IF p_user_in_rec.ROWID <> FND_API.G_MISS_CHAR
5669: AND NVL(p_user_in_rec.ROWID,'!!!') <> NVL(p_out_rec.ROWID,'!!!')
5670: THEN
5671: l_attributes := l_attributes || 'ROWID, ';
5672: END IF;

Line 5674: IF p_user_in_rec.TRIP_NAME <> FND_API.G_MISS_CHAR

5670: THEN
5671: l_attributes := l_attributes || 'ROWID, ';
5672: END IF;
5673:
5674: IF p_user_in_rec.TRIP_NAME <> FND_API.G_MISS_CHAR
5675: AND NVL(p_user_in_rec.TRIP_NAME,'!!!') <> NVL(p_out_rec.TRIP_NAME,'!!!')
5676: THEN
5677: l_attributes := l_attributes || 'TRIP_NAME, ';
5678: END IF;

Line 5680: IF p_user_in_rec.STOP_LOCATION_CODE <> FND_API.G_MISS_CHAR

5676: THEN
5677: l_attributes := l_attributes || 'TRIP_NAME, ';
5678: END IF;
5679:
5680: IF p_user_in_rec.STOP_LOCATION_CODE <> FND_API.G_MISS_CHAR
5681: AND NVL(p_user_in_rec.STOP_LOCATION_CODE,'!!!') <> NVL(p_out_rec.STOP_LOCATION_CODE,'!!!')
5682: THEN
5683: l_attributes := l_attributes || 'STOP_LOCATION_CODE, ';
5684: END IF;

Line 5686: IF p_user_in_rec.WEIGHT_UOM_DESC <> FND_API.G_MISS_CHAR

5682: THEN
5683: l_attributes := l_attributes || 'STOP_LOCATION_CODE, ';
5684: END IF;
5685:
5686: IF p_user_in_rec.WEIGHT_UOM_DESC <> FND_API.G_MISS_CHAR
5687: AND NVL(p_user_in_rec.WEIGHT_UOM_DESC,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_DESC,'!!!')
5688: THEN
5689: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
5690: END IF;

Line 5692: IF p_user_in_rec.VOLUME_UOM_DESC <> FND_API.G_MISS_CHAR

5688: THEN
5689: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
5690: END IF;
5691:
5692: IF p_user_in_rec.VOLUME_UOM_DESC <> FND_API.G_MISS_CHAR
5693: AND NVL(p_user_in_rec.VOLUME_UOM_DESC,'!!!') <> NVL(p_out_rec.VOLUME_UOM_DESC,'!!!')
5694: THEN
5695: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
5696: END IF;

Line 5698: IF p_user_in_rec.LOCK_STOP_ID <> FND_API.G_MISS_NUM

5694: THEN
5695: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
5696: END IF;
5697:
5698: IF p_user_in_rec.LOCK_STOP_ID <> FND_API.G_MISS_NUM
5699: AND NVL(p_user_in_rec.LOCK_STOP_ID,-99) <> NVL(p_out_rec.LOCK_STOP_ID,-99)
5700: THEN
5701: l_attributes := l_attributes || 'LOCK_STOP_ID, ';
5702: END IF;

Line 5704: IF p_user_in_rec.PENDING_INTERFACE_FLAG <> FND_API.G_MISS_CHAR

5700: THEN
5701: l_attributes := l_attributes || 'LOCK_STOP_ID, ';
5702: END IF;
5703:
5704: IF p_user_in_rec.PENDING_INTERFACE_FLAG <> FND_API.G_MISS_CHAR
5705: AND NVL(p_user_in_rec.PENDING_INTERFACE_FLAG,'!!!') <> NVL(p_out_rec.PENDING_INTERFACE_FLAG,'!!!')
5706: THEN
5707: l_attributes := l_attributes || 'PENDING_INTERFACE_FLAG, ';
5708: END IF;

Line 5710: IF p_user_in_rec.TRANSACTION_HEADER_ID <> FND_API.G_MISS_NUM

5706: THEN
5707: l_attributes := l_attributes || 'PENDING_INTERFACE_FLAG, ';
5708: END IF;
5709:
5710: IF p_user_in_rec.TRANSACTION_HEADER_ID <> FND_API.G_MISS_NUM
5711: AND NVL(p_user_in_rec.TRANSACTION_HEADER_ID,-99) <> NVL(p_out_rec.TRANSACTION_HEADER_ID,-99)
5712: THEN
5713: l_attributes := l_attributes || 'TRANSACTION_HEADER_ID, ';
5714: END IF;

Line 5716: IF p_user_in_rec.SHIPMENTS_TYPE_FLAG <> FND_API.G_MISS_CHAR

5712: THEN
5713: l_attributes := l_attributes || 'TRANSACTION_HEADER_ID, ';
5714: END IF;
5715:
5716: IF p_user_in_rec.SHIPMENTS_TYPE_FLAG <> FND_API.G_MISS_CHAR
5717: AND NVL(p_user_in_rec.SHIPMENTS_TYPE_FLAG,'!!!') <> NVL(p_out_rec.SHIPMENTS_TYPE_FLAG,'!!!')
5718: THEN
5719: l_attributes := l_attributes || 'SHIPMENTS_TYPE_FLAG, ';
5720: END IF;

Line 5722: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR

5718: THEN
5719: l_attributes := l_attributes || 'SHIPMENTS_TYPE_FLAG, ';
5720: END IF;
5721:
5722: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
5723: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
5724: THEN
5725: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
5726: END IF;

Line 5728: IF p_user_in_rec.WKEND_LAYOVER_STOPS <> FND_API.G_MISS_NUM

5724: THEN
5725: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
5726: END IF;
5727:
5728: IF p_user_in_rec.WKEND_LAYOVER_STOPS <> FND_API.G_MISS_NUM
5729: AND NVL(p_user_in_rec.WKEND_LAYOVER_STOPS,-99) <> NVL(p_out_rec.WKEND_LAYOVER_STOPS,-99)
5730: THEN
5731: l_attributes := l_attributes || 'WKEND_LAYOVER_STOPS, ';
5732: END IF;

Line 5734: IF p_user_in_rec.WKDAY_LAYOVER_STOPS <> FND_API.G_MISS_NUM

5730: THEN
5731: l_attributes := l_attributes || 'WKEND_LAYOVER_STOPS, ';
5732: END IF;
5733:
5734: IF p_user_in_rec.WKDAY_LAYOVER_STOPS <> FND_API.G_MISS_NUM
5735: AND NVL(p_user_in_rec.WKDAY_LAYOVER_STOPS,-99) <> NVL(p_out_rec.WKDAY_LAYOVER_STOPS,-99)
5736: THEN
5737: l_attributes := l_attributes || 'WKDAY_LAYOVER_STOPS, ';
5738: END IF;

Line 5740: IF p_user_in_rec.TP_STOP_ID <> FND_API.G_MISS_NUM

5736: THEN
5737: l_attributes := l_attributes || 'WKDAY_LAYOVER_STOPS, ';
5738: END IF;
5739:
5740: IF p_user_in_rec.TP_STOP_ID <> FND_API.G_MISS_NUM
5741: AND NVL(p_user_in_rec.TP_STOP_ID,-99) <> NVL(p_out_rec.TP_STOP_ID,-99)
5742: THEN
5743: l_attributes := l_attributes || 'TP_STOP_ID, ';
5744: END IF;