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 1232: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN

1228: )
1229: IS
1230: BEGIN
1231:
1232: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1233: x_internal := p_internal;
1234: IF p_internal IS NULL THEN
1235: x_external := NULL;
1236: ELSE

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

1235: x_external := NULL;
1236: ELSE
1237: x_external := p_external;
1238: END IF;
1239: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1240: x_external := p_external;
1241: IF x_external IS NULL THEN
1242: x_internal := NULL;
1243: ELSE

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

1262: )
1263: IS
1264: BEGIN
1265:
1266: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1267: x_internal := p_internal;
1268: IF p_internal IS NULL THEN
1269: x_external := NULL;
1270: ELSE

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

1269: x_external := NULL;
1270: ELSE
1271: x_external := p_external;
1272: END IF;
1273: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1274: x_external := p_external;
1275: IF x_external IS NULL THEN
1276: x_internal := NULL;
1277: ELSE

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

1306: x_stop_rec.trip_id,
1307: x_stop_rec.trip_name);
1308:
1309: */
1310: IF p_stop_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR
1311: OR p_stop_rec.DEPARTURE_SEAL_CODE IS NULL THEN
1312: x_stop_rec.DEPARTURE_SEAL_CODE :=
1313: p_stop_rec.DEPARTURE_SEAL_CODE;
1314: END IF;

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

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

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

1332: p_stop_rec.STOP_SEQUENCE_NUMBER;
1333: END IF;
1334: -- end of SSN change
1335:
1336: IF p_stop_rec.PLANNED_ARRIVAL_DATE <> FND_API.G_MISS_DATE
1337: OR p_stop_rec.PLANNED_ARRIVAL_DATE IS NULL THEN
1338: x_stop_rec.PLANNED_ARRIVAL_DATE :=
1339: p_stop_rec.PLANNED_ARRIVAL_DATE;
1340: END IF;

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

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

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

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

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

1347: OR p_stop_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1348: x_stop_rec.DEPARTURE_GROSS_WEIGHT :=
1349: p_stop_rec.DEPARTURE_GROSS_WEIGHT;
1350: END IF;
1351: IF p_stop_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
1352: OR p_stop_rec.DEPARTURE_NET_WEIGHT IS NULL THEN
1353: x_stop_rec.DEPARTURE_NET_WEIGHT :=
1354: p_stop_rec.DEPARTURE_NET_WEIGHT;
1355: END IF;

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

1358: p_stop_rec.WEIGHT_UOM_DESC,
1359: x_stop_rec.WEIGHT_UOM_CODE,
1360: x_stop_rec.WEIGHT_UOM_DESC);
1361:
1362: IF p_stop_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM
1363: OR p_stop_rec.DEPARTURE_VOLUME IS NULL THEN
1364: x_stop_rec.DEPARTURE_VOLUME :=
1365: p_stop_rec.DEPARTURE_VOLUME;
1366: END IF;

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

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

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

1376: p_stop_rec.wv_frozen_flag;
1377: END IF;
1378: -- end bug 3666967
1379:
1380: IF p_stop_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM
1381: OR p_stop_rec.DEPARTURE_FILL_PERCENT IS NULL THEN
1382: x_stop_rec.DEPARTURE_FILL_PERCENT :=
1383: p_stop_rec.DEPARTURE_FILL_PERCENT;
1384: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1536: OR p_stop_rec.tp_attribute15 IS NULL THEN
1537: x_stop_rec.tp_attribute15 :=
1538: p_stop_rec.tp_attribute15;
1539: END IF;
1540: IF p_stop_rec.TP_ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
1541: OR p_stop_rec.TP_ATTRIBUTE_CATEGORY IS NULL THEN
1542: x_stop_rec.TP_ATTRIBUTE_CATEGORY :=
1543: p_stop_rec.TP_ATTRIBUTE_CATEGORY;
1544: END IF;

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

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

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

1548: OR p_stop_rec.wkday_layover_stops IS NULL THEN
1549: x_stop_rec.wkday_layover_stops :=
1550: p_stop_rec.wkday_layover_stops;
1551: END IF;
1552: IF p_stop_rec.wkend_layover_stops <> FND_API.G_MISS_NUM
1553: OR p_stop_rec.wkend_layover_stops IS NULL THEN
1554: x_stop_rec.wkend_layover_stops :=
1555: p_stop_rec.wkend_layover_stops;
1556: END IF;

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

1555: p_stop_rec.wkend_layover_stops;
1556: END IF;
1557: END IF;
1558: IF p_in_rec.caller='WSH_TP_RELEASE' THEN
1559: IF p_stop_rec.tp_stop_id <> FND_API.G_MISS_NUM
1560: OR p_stop_rec.tp_stop_id IS NULL THEN
1561: x_stop_rec.tp_stop_id :=
1562: p_stop_rec.tp_stop_id;
1563: END IF;

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

1564: END IF;
1565: --Bug 3282166
1566: --
1567: IF p_in_rec.caller like 'FTE%' THEN
1568: IF p_stop_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE
1569: OR p_stop_rec.CARRIER_EST_DEPARTURE_DATE IS NULL THEN
1570: x_stop_rec.CARRIER_EST_DEPARTURE_DATE := p_stop_rec.CARRIER_EST_DEPARTURE_DATE;
1571:
1572: END IF;

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

1569: OR p_stop_rec.CARRIER_EST_DEPARTURE_DATE IS NULL THEN
1570: x_stop_rec.CARRIER_EST_DEPARTURE_DATE := p_stop_rec.CARRIER_EST_DEPARTURE_DATE;
1571:
1572: END IF;
1573: IF p_stop_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE
1574: OR p_stop_rec.CARRIER_EST_ARRIVAL_DATE IS NULL THEN
1575: x_stop_rec.CARRIER_EST_ARRIVAL_DATE := p_stop_rec.CARRIER_EST_ARRIVAL_DATE;
1576:
1577: END IF;

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

1598: FOR i IN 1..p_disabled_list.COUNT
1599: LOOP
1600: IF p_disabled_list(i) = 'STOP_LOCATION_CODE' THEN
1601: x_out_rec.STOP_LOCATION_ID := p_in_rec.STOP_LOCATION_ID ;
1602: x_out_rec.STOP_LOCATION_CODE := FND_API.G_MISS_CHAR ;
1603: ELSIF p_disabled_list(i) = 'STOP_SEQUENCE_NUMBER' THEN
1604: x_out_rec.STOP_SEQUENCE_NUMBER := p_in_rec.STOP_SEQUENCE_NUMBER;
1605: ELSIF p_disabled_list(i) = 'PLANNED_ARRIVAL_DATE' THEN
1606: x_out_rec.PLANNED_ARRIVAL_DATE := p_in_rec.PLANNED_ARRIVAL_DATE ;

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

1676: IS
1677: BEGIN
1678:
1679: IF x_internal IS NULL THEN
1680: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1681: x_internal := p_internal ;
1682: IF p_internal IS NULL THEN
1683: x_external := NULL;
1684: ELSE

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

1683: x_external := NULL;
1684: ELSE
1685: x_external := p_external;
1686: END IF;
1687: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1688: x_external := p_external;
1689: IF p_external IS NULL THEN
1690: x_internal := NULL;
1691: ELSE

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

1692: x_internal := p_internal;
1693: END IF;
1694: END IF;
1695: END IF;
1696: IF p_internal <> FND_API.G_MISS_NUM OR p_internal IS NULL THEN
1697: x_internal := p_internal ;
1698: IF p_internal IS NULL THEN
1699: x_external := NULL;
1700: ELSE

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

1699: x_external := NULL;
1700: ELSE
1701: x_external := p_external;
1702: END IF;
1703: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1704: x_external := p_external;
1705: IF p_external IS NULL THEN
1706: x_internal := NULL;
1707: ELSE

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

1728: BEGIN
1729:
1730: IF p_mode = '+' THEN
1731: IF x_internal IS NULL THEN
1732: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1733: x_internal := p_internal ;
1734: IF p_internal IS NULL THEN
1735: x_external := NULL;
1736: ELSE

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

1735: x_external := NULL;
1736: ELSE
1737: x_external := p_external;
1738: END IF;
1739: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1740: x_external := p_external;
1741: IF p_external IS NULL THEN
1742: x_internal := NULL;
1743: ELSE

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

1745: END IF;
1746: END IF;
1747: END IF;
1748: ELSE --p_mode <> +
1749: IF p_internal <> FND_API.G_MISS_CHAR OR p_internal IS NULL THEN
1750: x_internal := p_internal ;
1751: IF p_internal IS NULL THEN
1752: x_external := NULL;
1753: ELSE

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

1752: x_external := NULL;
1753: ELSE
1754: x_external := p_external;
1755: END IF;
1756: ELSIF p_external <> FND_API.G_MISS_CHAR OR p_external IS NULL THEN
1757: x_external := p_external;
1758: IF p_external IS NULL THEN
1759: x_internal := NULL;
1760: ELSE

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

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

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

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

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

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

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

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

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

1811: OR p_in_rec.DEPARTURE_GROSS_WEIGHT IS NULL THEN
1812: x_out_rec.DEPARTURE_GROSS_WEIGHT := p_in_rec.DEPARTURE_GROSS_WEIGHT ;
1813: END IF;
1814: ELSIF p_disabled_list(i) = 'DEPARTURE_NET_WEIGHT' THEN
1815: IF p_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
1816: OR p_in_rec.DEPARTURE_NET_WEIGHT IS NULL THEN
1817: x_out_rec.DEPARTURE_NET_WEIGHT := p_in_rec.DEPARTURE_NET_WEIGHT ;
1818: END IF;
1819: ELSIF p_disabled_list(i) = 'WEIGHT_UOM_CODE' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1891: IF p_in_rec.attribute14 <> FND_API.G_MISS_CHAR
1892: OR p_in_rec.attribute14 IS NULL THEN
1893: x_out_rec.attribute14 := p_in_rec.attribute14 ;
1894: END IF;
1895: IF p_in_rec.attribute15 <> FND_API.G_MISS_CHAR
1896: OR p_in_rec.attribute15 IS NULL THEN
1897: x_out_rec.attribute15 := p_in_rec.attribute15 ;
1898: END IF;
1899: IF p_in_rec.attribute_category <> FND_API.G_MISS_CHAR

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

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

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

1900: OR p_in_rec.attribute_category IS NULL THEN
1901: x_out_rec.attribute_category := p_in_rec.attribute_category ;
1902: END IF;
1903: ELSIF p_disabled_list(i) = 'TP_FLEXFIELD' THEN
1904: IF p_in_rec.tp_attribute1 <> FND_API.G_MISS_CHAR
1905: OR p_in_rec.tp_attribute1 IS NULL THEN
1906: x_out_rec.tp_attribute1 := p_in_rec.tp_attribute1 ;
1907: END IF;
1908: IF p_in_rec.tp_attribute2 <> FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1956: IF p_in_rec.tp_attribute14 <> FND_API.G_MISS_CHAR
1957: OR p_in_rec.tp_attribute14 IS NULL THEN
1958: x_out_rec.tp_attribute14 := p_in_rec.tp_attribute14 ;
1959: END IF;
1960: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
1961: OR p_in_rec.tp_attribute15 IS NULL THEN
1962: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
1963: END IF;
1964: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR

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

1960: IF p_in_rec.tp_attribute15 <> FND_API.G_MISS_CHAR
1961: OR p_in_rec.tp_attribute15 IS NULL THEN
1962: x_out_rec.tp_attribute15 := p_in_rec.tp_attribute15 ;
1963: END IF;
1964: IF p_in_rec.tp_attribute_category <> FND_API.G_MISS_CHAR
1965: OR p_in_rec.tp_attribute_category IS NULL THEN
1966: x_out_rec.tp_attribute_category := p_in_rec.tp_attribute_category ;
1967: END IF;
1968: --ELSIF p_disabled_list(i) = 'FULL' THEN

Line 2123: x_return_status := FND_API.G_RET_STS_SUCCESS;

2119: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2120: --
2121: END IF;
2122: --
2123: x_return_status := FND_API.G_RET_STS_SUCCESS;
2124: --
2125: IF p_in_rec.action_code = 'CREATE' THEN
2126: --
2127: IF l_debug_on THEN

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

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

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

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

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

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

Line 2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2162: END IF;
2163: --
2164: IF (get_trip_id%NOTFOUND OR l_parent_entity_id IS NULL) THEN
2165: CLOSE get_trip_id;
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167: END IF;
2168: --
2169: CLOSE get_trip_id;
2170: --

Line 2585: RAISE FND_API.G_EXC_ERROR;

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

Line 2598: RAISE FND_API.G_EXC_ERROR;

2594: --
2595: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2596: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_stop_id');
2597: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2598: RAISE FND_API.G_EXC_ERROR;
2599: --}
2600: END IF;
2601: --
2602: --

Line 2718: WHEN FND_API.G_EXC_ERROR THEN

2714: --}
2715: EXCEPTION
2716: --{
2717: --
2718: WHEN FND_API.G_EXC_ERROR THEN
2719:
2720: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2721: --
2722: IF l_debug_on THEN

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

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

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

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

Line 2727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 3267: RAISE FND_API.G_EXC_ERROR;

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

Line 3410: RAISE FND_API.G_EXC_ERROR;

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

Line 3430: RAISE FND_API.G_EXC_ERROR;

3426: l_out_status);
3427:
3428: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3429: wsh_util_core.add_message(l_out_status);
3430: RAISE FND_API.G_EXC_ERROR;
3431: END IF;
3432:
3433: -- End of code BugFix #3947506
3434:

Line 3462: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

Line 4970: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

Line 4979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 5198: WHEN FND_API.G_EXC_ERROR THEN

5194: END IF;
5195: --}
5196: EXCEPTION
5197: --
5198: WHEN FND_API.G_EXC_ERROR THEN
5199:
5200: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5201: --
5202: IF l_debug_on THEN

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

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

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

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

Line 5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 5269: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

5279: THEN
5280: l_attributes := l_attributes || 'TRIP_ID, ';
5281: END IF;
5282:
5283: IF p_user_in_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM
5284: AND NVL(p_user_in_rec.STOP_LOCATION_ID,-99) <> NVL(p_out_rec.STOP_LOCATION_ID,-99)
5285: THEN
5286: l_attributes := l_attributes || 'STOP_LOCATION_ID, ';
5287: END IF;

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

5285: THEN
5286: l_attributes := l_attributes || 'STOP_LOCATION_ID, ';
5287: END IF;
5288:
5289: IF p_user_in_rec.STATUS_CODE <> FND_API.G_MISS_CHAR
5290: AND NVL(p_user_in_rec.STATUS_CODE,'!!!') <> NVL(p_out_rec.STATUS_CODE,'!!!')
5291: THEN
5292: l_attributes := l_attributes || 'STATUS_CODE, ';
5293: END IF;

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

5291: THEN
5292: l_attributes := l_attributes || 'STATUS_CODE, ';
5293: END IF;
5294:
5295: IF p_user_in_rec.STOP_SEQUENCE_NUMBER <> FND_API.G_MISS_NUM
5296: AND NVL(p_user_in_rec.STOP_SEQUENCE_NUMBER,-99) <> NVL(p_out_rec.STOP_SEQUENCE_NUMBER,-99)
5297: THEN
5298: l_attributes := l_attributes || 'STOP_SEQUENCE_NUMBER, ';
5299: END IF;

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

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

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

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

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

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

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

5315: THEN
5316: l_attributes := l_attributes || 'ACTUAL_ARRIVAL_DATE, ';
5317: END IF;
5318:
5319: IF p_user_in_rec.ACTUAL_DEPARTURE_DATE <> FND_API.G_MISS_DATE
5320: AND NVL(p_user_in_rec.ACTUAL_DEPARTURE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.ACTUAL_DEPARTURE_DATE,TO_DATE('2','j'))
5321: THEN
5322: l_attributes := l_attributes || 'ACTUAL_DEPARTURE_DATE, ';
5323: END IF;

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

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

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

5327: THEN
5328: l_attributes := l_attributes || 'DEPARTURE_GROSS_WEIGHT, ';
5329: END IF;
5330:
5331: IF p_user_in_rec.DEPARTURE_NET_WEIGHT <> FND_API.G_MISS_NUM
5332: AND NVL(p_user_in_rec.DEPARTURE_NET_WEIGHT,-99) <> NVL(p_out_rec.DEPARTURE_NET_WEIGHT,-99)
5333: THEN
5334: l_attributes := l_attributes || 'DEPARTURE_NET_WEIGHT, ';
5335: END IF;

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

5333: THEN
5334: l_attributes := l_attributes || 'DEPARTURE_NET_WEIGHT, ';
5335: END IF;
5336:
5337: IF p_user_in_rec.WEIGHT_UOM_CODE <> FND_API.G_MISS_CHAR
5338: AND NVL(p_user_in_rec.WEIGHT_UOM_CODE,'!!!') <> NVL(p_out_rec.WEIGHT_UOM_CODE,'!!!')
5339: THEN
5340: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
5341: END IF;

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

5339: THEN
5340: l_attributes := l_attributes || 'WEIGHT_UOM_CODE, ';
5341: END IF;
5342:
5343: IF p_user_in_rec.DEPARTURE_VOLUME <> FND_API.G_MISS_NUM
5344: AND NVL(p_user_in_rec.DEPARTURE_VOLUME,-99) <> NVL(p_out_rec.DEPARTURE_VOLUME,-99)
5345: THEN
5346: l_attributes := l_attributes || 'DEPARTURE_VOLUME, ';
5347: END IF;

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

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

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

5351: THEN
5352: l_attributes := l_attributes || 'VOLUME_UOM_CODE, ';
5353: END IF;
5354:
5355: IF p_user_in_rec.DEPARTURE_SEAL_CODE <> FND_API.G_MISS_CHAR
5356: AND NVL(p_user_in_rec.DEPARTURE_SEAL_CODE,'!!!') <> NVL(p_out_rec.DEPARTURE_SEAL_CODE,'!!!')
5357: THEN
5358: l_attributes := l_attributes || 'DEPARTURE_SEAL_CODE, ';
5359: END IF;

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

5357: THEN
5358: l_attributes := l_attributes || 'DEPARTURE_SEAL_CODE, ';
5359: END IF;
5360:
5361: IF p_user_in_rec.DEPARTURE_FILL_PERCENT <> FND_API.G_MISS_NUM
5362: AND NVL(p_user_in_rec.DEPARTURE_FILL_PERCENT,-99) <> NVL(p_out_rec.DEPARTURE_FILL_PERCENT,-99)
5363: THEN
5364: l_attributes := l_attributes || 'DEPARTURE_FILL_PERCENT, ';
5365: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5549: THEN
5550: l_attributes := l_attributes || 'ATTRIBUTE14, ';
5551: END IF;
5552:
5553: IF p_user_in_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
5554: AND NVL(p_user_in_rec.ATTRIBUTE15,'!!!') <> NVL(p_out_rec.ATTRIBUTE15,'!!!')
5555: THEN
5556: l_attributes := l_attributes || 'ATTRIBUTE15, ';
5557: END IF;

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

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

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

5564: THEN
5565: l_attributes := l_attributes || 'CREATION_DATE, ';
5566: END IF;
5567:
5568: IF p_user_in_rec.CREATED_BY <> FND_API.G_MISS_NUM
5569: AND NVL(p_user_in_rec.CREATED_BY,-99) <> NVL(p_out_rec.CREATED_BY,-99)
5570: THEN
5571: l_attributes := l_attributes || 'CREATED_BY, ';
5572: END IF;

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

5570: THEN
5571: l_attributes := l_attributes || 'CREATED_BY, ';
5572: END IF;
5573:
5574: IF p_user_in_rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE
5575: AND NVL(p_user_in_rec.LAST_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.LAST_UPDATE_DATE,TO_DATE('2','j'))
5576: THEN
5577: l_attributes := l_attributes || 'LAST_UPDATE_DATE, ';
5578: END IF;

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

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

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

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

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

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

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

5594: THEN
5595: l_attributes := l_attributes || 'PROGRAM_APPLICATION_ID, ';
5596: END IF;
5597:
5598: IF p_user_in_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
5599: AND NVL(p_user_in_rec.PROGRAM_ID,-99) <> NVL(p_out_rec.PROGRAM_ID,-99)
5600: THEN
5601: l_attributes := l_attributes || 'PROGRAM_ID, ';
5602: END IF;

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

5600: THEN
5601: l_attributes := l_attributes || 'PROGRAM_ID, ';
5602: END IF;
5603:
5604: IF p_user_in_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
5605: AND NVL(p_user_in_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j')) <> NVL(p_out_rec.PROGRAM_UPDATE_DATE,TO_DATE('2','j'))
5606: THEN
5607: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
5608: END IF;

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

5606: THEN
5607: l_attributes := l_attributes || 'PROGRAM_UPDATE_DATE, ';
5608: END IF;
5609:
5610: IF p_user_in_rec.REQUEST_ID <> FND_API.G_MISS_NUM
5611: AND NVL(p_user_in_rec.REQUEST_ID,-99) <> NVL(p_out_rec.REQUEST_ID,-99)
5612: THEN
5613: l_attributes := l_attributes || 'REQUEST_ID, ';
5614: END IF;

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

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

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

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

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

5626: THEN
5627: l_attributes := l_attributes || 'TRACKING_DRILLDOWN_FLAG, ';
5628: END IF;
5629:
5630: IF p_user_in_rec.TRACKING_REMARKS <> FND_API.G_MISS_CHAR
5631: AND NVL(p_user_in_rec.TRACKING_REMARKS,'!!!') <> NVL(p_out_rec.TRACKING_REMARKS,'!!!')
5632: THEN
5633: l_attributes := l_attributes || 'TRACKING_REMARKS, ';
5634: END IF;

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

5632: THEN
5633: l_attributes := l_attributes || 'TRACKING_REMARKS, ';
5634: END IF;
5635:
5636: IF p_user_in_rec.CARRIER_EST_DEPARTURE_DATE <> FND_API.G_MISS_DATE
5637: 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'))
5638: THEN
5639: l_attributes := l_attributes || 'CARRIER_EST_DEPARTURE_DATE, ';
5640: END IF;

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

5638: THEN
5639: l_attributes := l_attributes || 'CARRIER_EST_DEPARTURE_DATE, ';
5640: END IF;
5641:
5642: IF p_user_in_rec.CARRIER_EST_ARRIVAL_DATE <> FND_API.G_MISS_DATE
5643: 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'))
5644: THEN
5645: l_attributes := l_attributes || 'CARRIER_EST_ARRIVAL_DATE, ';
5646: END IF;

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

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

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

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

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

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

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

5662: THEN
5663: l_attributes := l_attributes || 'UNLOADING_START_DATETIME, ';
5664: END IF;
5665:
5666: IF p_user_in_rec.UNLOADING_END_DATETIME <> FND_API.G_MISS_DATE
5667: AND NVL(p_user_in_rec.UNLOADING_END_DATETIME,TO_DATE('2','j')) <> NVL(p_out_rec.UNLOADING_END_DATETIME,TO_DATE('2','j'))
5668: THEN
5669: l_attributes := l_attributes || 'UNLOADING_END_DATETIME, ';
5670: END IF;

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

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

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

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

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

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

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

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

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

5692: THEN
5693: l_attributes := l_attributes || 'WEIGHT_UOM_DESC, ';
5694: END IF;
5695:
5696: IF p_user_in_rec.VOLUME_UOM_DESC <> FND_API.G_MISS_CHAR
5697: AND NVL(p_user_in_rec.VOLUME_UOM_DESC,'!!!') <> NVL(p_out_rec.VOLUME_UOM_DESC,'!!!')
5698: THEN
5699: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
5700: END IF;

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

5698: THEN
5699: l_attributes := l_attributes || 'VOLUME_UOM_DESC, ';
5700: END IF;
5701:
5702: IF p_user_in_rec.LOCK_STOP_ID <> FND_API.G_MISS_NUM
5703: AND NVL(p_user_in_rec.LOCK_STOP_ID,-99) <> NVL(p_out_rec.LOCK_STOP_ID,-99)
5704: THEN
5705: l_attributes := l_attributes || 'LOCK_STOP_ID, ';
5706: END IF;

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

5704: THEN
5705: l_attributes := l_attributes || 'LOCK_STOP_ID, ';
5706: END IF;
5707:
5708: IF p_user_in_rec.PENDING_INTERFACE_FLAG <> FND_API.G_MISS_CHAR
5709: AND NVL(p_user_in_rec.PENDING_INTERFACE_FLAG,'!!!') <> NVL(p_out_rec.PENDING_INTERFACE_FLAG,'!!!')
5710: THEN
5711: l_attributes := l_attributes || 'PENDING_INTERFACE_FLAG, ';
5712: END IF;

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

5710: THEN
5711: l_attributes := l_attributes || 'PENDING_INTERFACE_FLAG, ';
5712: END IF;
5713:
5714: IF p_user_in_rec.TRANSACTION_HEADER_ID <> FND_API.G_MISS_NUM
5715: AND NVL(p_user_in_rec.TRANSACTION_HEADER_ID,-99) <> NVL(p_out_rec.TRANSACTION_HEADER_ID,-99)
5716: THEN
5717: l_attributes := l_attributes || 'TRANSACTION_HEADER_ID, ';
5718: END IF;

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

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

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

5722: THEN
5723: l_attributes := l_attributes || 'SHIPMENTS_TYPE_FLAG, ';
5724: END IF;
5725:
5726: IF p_user_in_rec.WV_FROZEN_FLAG <> FND_API.G_MISS_CHAR
5727: AND NVL(p_user_in_rec.WV_FROZEN_FLAG,'!!!') <> NVL(p_out_rec.WV_FROZEN_FLAG,'!!!')
5728: THEN
5729: l_attributes := l_attributes || 'WV_FROZEN_FLAG, ';
5730: END IF;

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

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

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

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

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

5740: THEN
5741: l_attributes := l_attributes || 'WKDAY_LAYOVER_STOPS, ';
5742: END IF;
5743:
5744: IF p_user_in_rec.TP_STOP_ID <> FND_API.G_MISS_NUM
5745: AND NVL(p_user_in_rec.TP_STOP_ID,-99) <> NVL(p_out_rec.TP_STOP_ID,-99)
5746: THEN
5747: l_attributes := l_attributes || 'TP_STOP_ID, ';
5748: END IF;