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.WSM_SERIAL_SUPPORT_PVT dependencies on FND_API

Line 33: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

29: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
30: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
31: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
32:
33: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
34: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
35: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
36:
37:

Line 34: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

30: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
31: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
32:
33: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
34: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
35: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
36:
37:
38: --______________________________________________________________________________________________

Line 35: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

31: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
32:
33: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
34: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
35: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
36:
37:
38: --______________________________________________________________________________________________
39: -- Forward declaration section....----------------------------------------------------------------

Line 225: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

221: x_error_count OUT NOCOPY NUMBER,
222: x_error_msg OUT NOCOPY VARCHAR2
223: )
224: IS
225: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
226: l_null_num NUMBER := FND_API.G_NULL_NUM;
227: l_null_date DATE := FND_API.G_NULL_DATE;
228: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
229:

Line 226: l_null_num NUMBER := FND_API.G_NULL_NUM;

222: x_error_msg OUT NOCOPY VARCHAR2
223: )
224: IS
225: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
226: l_null_num NUMBER := FND_API.G_NULL_NUM;
227: l_null_date DATE := FND_API.G_NULL_DATE;
228: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
229:
230: cursor c_lbj_serials is

Line 227: l_null_date DATE := FND_API.G_NULL_DATE;

223: )
224: IS
225: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
226: l_null_num NUMBER := FND_API.G_NULL_NUM;
227: l_null_date DATE := FND_API.G_NULL_DATE;
228: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
229:
230: cursor c_lbj_serials is
231: select

Line 228: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

224: IS
225: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
226: l_null_num NUMBER := FND_API.G_NULL_NUM;
227: l_null_date DATE := FND_API.G_NULL_DATE;
228: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
229:
230: cursor c_lbj_serials is
231: select
232: wsti.Serial_Number ,

Line 406: RAISE FND_API.G_EXC_ERROR;

402: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
403: p_run_log_level => l_log_level
404: );
405: END IF;
406: RAISE FND_API.G_EXC_ERROR;
407: end if;
408:
409: l_stmt_num := 50;
410: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 436: raise FND_API.G_EXC_ERROR;

432: l_stmt_num := 60;
433:
434: if x_return_status <> G_RET_SUCCESS then
435: IF x_return_status = G_RET_ERROR THEN
436: raise FND_API.G_EXC_ERROR;
437: ELSIF x_return_status = G_RET_UNEXPECTED THEN
438: raise FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440: end if;

Line 438: raise FND_API.G_EXC_UNEXPECTED_ERROR;

434: if x_return_status <> G_RET_SUCCESS then
435: IF x_return_status = G_RET_ERROR THEN
436: raise FND_API.G_EXC_ERROR;
437: ELSIF x_return_status = G_RET_UNEXPECTED THEN
438: raise FND_API.G_EXC_UNEXPECTED_ERROR;
439: END IF;
440: end if;
441:
442: EXCEPTION

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440: end if;
441:
442: EXCEPTION
443:
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: x_return_status := G_RET_ERROR;
447: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
448: p_count => x_error_count ,

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: p_count => x_error_count ,
449: p_data => x_error_msg
450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: x_return_status := G_RET_UNEXPECTED;
455:
456: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 551: raise FND_API.G_EXC_ERROR;

547: x_error_count => x_error_count
548: );
549: if x_return_status <> G_RET_SUCCESS then
550: IF x_return_status = G_RET_ERROR THEN
551: raise FND_API.G_EXC_ERROR;
552: ELSIF x_return_status = G_RET_UNEXPECTED THEN
553: raise FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555: end if;

Line 553: raise FND_API.G_EXC_UNEXPECTED_ERROR;

549: if x_return_status <> G_RET_SUCCESS then
550: IF x_return_status = G_RET_ERROR THEN
551: raise FND_API.G_EXC_ERROR;
552: ELSIF x_return_status = G_RET_UNEXPECTED THEN
553: raise FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555: end if;
556: END IF;
557:

Line 576: raise FND_API.G_EXC_ERROR;

572: l_stmt_num := 30;
573:
574: if x_return_status <> G_RET_SUCCESS then
575: IF x_return_status = G_RET_ERROR THEN
576: raise FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = G_RET_UNEXPECTED THEN
578: raise FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580: end if;

Line 578: raise FND_API.G_EXC_UNEXPECTED_ERROR;

574: if x_return_status <> G_RET_SUCCESS then
575: IF x_return_status = G_RET_ERROR THEN
576: raise FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = G_RET_UNEXPECTED THEN
578: raise FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580: end if;
581:
582: l_stmt_num := 40;

Line 603: RAISE FND_API.G_EXC_ERROR;

599: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
600: p_run_log_level => l_log_level
601: );
602: END IF;
603: RAISE FND_API.G_EXC_ERROR;
604: else
605: -- return success... as no rows were found as expected..
606: l_stmt_num := 60;
607: return;

Line 638: raise FND_API.G_EXC_ERROR;

634:
635: l_stmt_num := 80;
636: if x_return_status <> G_RET_SUCCESS then
637: IF x_return_status = G_RET_ERROR THEN
638: raise FND_API.G_EXC_ERROR;
639: ELSIF x_return_status = G_RET_UNEXPECTED THEN
640: raise FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642: end if;

Line 640: raise FND_API.G_EXC_UNEXPECTED_ERROR;

636: if x_return_status <> G_RET_SUCCESS then
637: IF x_return_status = G_RET_ERROR THEN
638: raise FND_API.G_EXC_ERROR;
639: ELSIF x_return_status = G_RET_UNEXPECTED THEN
640: raise FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642: end if;
643: end if;
644:

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642: end if;
643: end if;
644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO LBJ_serial_proc;
648: x_return_status := G_RET_ERROR;
649: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
650: p_count => x_error_count ,

Line 654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

650: p_count => x_error_count ,
651: p_data => x_error_msg
652: );
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: ROLLBACK TO LBJ_serial_proc;
656: x_return_status := G_RET_UNEXPECTED;
657:
658: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 750: RAISE FND_API.G_EXC_ERROR;

746: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
747: p_run_log_level => l_log_level
748: );
749: END IF;
750: RAISE FND_API.G_EXC_ERROR;
751: END;
752:
753: l_stmt_num := 40;
754: g_serial_ctl_code(p_serial_item_id || '_' || p_organization_id) := x_serial_ctrl_code;

Line 799: RAISE FND_API.G_EXC_ERROR;

795: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
796: p_run_log_level => l_log_level
797: );
798: END IF;
799: RAISE FND_API.G_EXC_ERROR;
800: END;
801:
802: EXCEPTION
803:

Line 804: WHEN FND_API.G_EXC_ERROR THEN

800: END;
801:
802: EXCEPTION
803:
804: WHEN FND_API.G_EXC_ERROR THEN
805:
806: x_return_status := G_RET_ERROR;
807: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
808: p_count => x_error_count ,

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1007: p_run_log_level => l_log_level
1008: );
1009: END IF;
1010: RAISE FND_API.G_EXC_ERROR;
1011: end if;
1012:
1013: l_stmt_num := 110;
1014: if p_wsm_serial_nums_tbl(l_index).action_flag = WSM_ADD_SERIAL_NUM then -- Add a serial number

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1032: p_run_log_level => l_log_level
1033: );
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038: l_stmt_num := 130;
1039: add_assoc_serial_number( p_calling_mode => p_calling_mode,

Line 1057: raise FND_API.G_EXC_ERROR;

1053: l_stmt_num := 140;
1054:
1055: if x_return_status <> G_RET_SUCCESS then
1056: IF x_return_status = G_RET_ERROR THEN
1057: raise FND_API.G_EXC_ERROR;
1058: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1059: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END IF;
1061: end if;

Line 1059: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1055: if x_return_status <> G_RET_SUCCESS then
1056: IF x_return_status = G_RET_ERROR THEN
1057: raise FND_API.G_EXC_ERROR;
1058: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1059: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END IF;
1061: end if;
1062:
1063: x_serial_tbl(x_serial_tbl.count+1) := p_wsm_serial_nums_tbl(l_index).serial_number;

Line 1089: raise FND_API.G_EXC_ERROR;

1085: l_stmt_num := 170;
1086:
1087: if x_return_status <> G_RET_SUCCESS then
1088: IF x_return_status = G_RET_ERROR THEN
1089: raise FND_API.G_EXC_ERROR;
1090: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093: end if;

Line 1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1087: if x_return_status <> G_RET_SUCCESS then
1088: IF x_return_status = G_RET_ERROR THEN
1089: raise FND_API.G_EXC_ERROR;
1090: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093: end if;
1094:
1095: l_stmt_num := 180;

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1121: p_run_log_level => l_log_level
1122: );
1123: END IF;
1124: RAISE FND_API.G_EXC_ERROR;
1125: end if;
1126:
1127: l_stmt_num := 210;
1128: IF l_qty < l_serial_num_count + p_wsm_serial_nums_tbl(l_index).generate_for_qty then

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1145: p_run_log_level => l_log_level
1146: );
1147: END IF;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151: l_stmt_num := 230;
1152: for l_cntr in 1..p_wsm_serial_nums_tbl(l_index).generate_for_qty loop

Line 1174: raise FND_API.G_EXC_ERROR;

1170: l_stmt_num := 250;
1171:
1172: if x_return_status <> G_RET_SUCCESS then
1173: IF x_return_status = G_RET_ERROR THEN
1174: raise FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1176: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178: end if;

Line 1176: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1172: if x_return_status <> G_RET_SUCCESS then
1173: IF x_return_status = G_RET_ERROR THEN
1174: raise FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1176: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178: end if;
1179:
1180: x_serial_tbl(x_serial_tbl.count+1) := l_serial_number;

Line 1207: raise FND_API.G_EXC_ERROR;

1203:
1204: l_stmt_num := 280;
1205: if x_return_status <> G_RET_SUCCESS then
1206: IF x_return_status = G_RET_ERROR THEN
1207: raise FND_API.G_EXC_ERROR;
1208: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END IF;
1211: end if;

Line 1209: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1205: if x_return_status <> G_RET_SUCCESS then
1206: IF x_return_status = G_RET_ERROR THEN
1207: raise FND_API.G_EXC_ERROR;
1208: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END IF;
1211: end if;
1212: else
1213: -- Invalid action code...

Line 1233: RAISE FND_API.G_EXC_ERROR;

1229: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1230: p_run_log_level => l_log_level
1231: );
1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;
1234: end if;
1235: l_stmt_num := 300;
1236: l_index := p_wsm_serial_nums_tbl.next(l_index);
1237:

Line 1243: WHEN FND_API.G_EXC_ERROR THEN

1239:
1240:
1241: EXCEPTION
1242:
1243: WHEN FND_API.G_EXC_ERROR THEN
1244:
1245: x_return_status := G_RET_ERROR;
1246: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1247: p_count => x_error_count ,

Line 1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1247: p_count => x_error_count ,
1248: p_data => x_error_msg
1249: );
1250:
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252:
1253: x_return_status := G_RET_UNEXPECTED;
1254:
1255: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 1365: RAISE FND_API.G_EXC_ERROR;

1361: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1362: p_run_log_level => l_log_level
1363: );
1364: END IF;
1365: RAISE FND_API.G_EXC_ERROR;
1366: end if;
1367:
1368: x_serial_number := l_serial_number;
1369:

Line 1393: raise FND_API.G_EXC_ERROR;

1389: );
1390:
1391: if x_return_status <> G_RET_SUCCESS then
1392: IF x_return_status = G_RET_ERROR THEN
1393: raise FND_API.G_EXC_ERROR;
1394: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1395: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397: end if;

Line 1395: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1391: if x_return_status <> G_RET_SUCCESS then
1392: IF x_return_status = G_RET_ERROR THEN
1393: raise FND_API.G_EXC_ERROR;
1394: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1395: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397: end if;
1398: end if;
1399:

Line 1441: raise FND_API.G_EXC_ERROR;

1437: );
1438:
1439: if x_return_status <> G_RET_SUCCESS then
1440: IF x_return_status = G_RET_ERROR THEN
1441: raise FND_API.G_EXC_ERROR;
1442: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1443: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END IF;
1445: end if;

Line 1443: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1439: if x_return_status <> G_RET_SUCCESS then
1440: IF x_return_status = G_RET_ERROR THEN
1441: raise FND_API.G_EXC_ERROR;
1442: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1443: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END IF;
1445: end if;
1446: l_stmt_num := 50;
1447: END IF;

Line 1466: raise FND_API.G_EXC_ERROR;

1462:
1463:
1464: if x_return_status <> G_RET_SUCCESS then
1465: IF x_return_status = G_RET_ERROR THEN
1466: raise FND_API.G_EXC_ERROR;
1467: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1468: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: end if;

Line 1468: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1464: if x_return_status <> G_RET_SUCCESS then
1465: IF x_return_status = G_RET_ERROR THEN
1466: raise FND_API.G_EXC_ERROR;
1467: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1468: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: end if;
1471:
1472: l_stmt_num := 70;

Line 1494: raise FND_API.G_EXC_ERROR;

1490: );
1491:
1492: if x_return_status <> G_RET_SUCCESS then
1493: IF x_return_status = G_RET_ERROR THEN
1494: raise FND_API.G_EXC_ERROR;
1495: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1496: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498: end if;

Line 1496: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1492: if x_return_status <> G_RET_SUCCESS then
1493: IF x_return_status = G_RET_ERROR THEN
1494: raise FND_API.G_EXC_ERROR;
1495: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1496: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498: end if;
1499:
1500: l_stmt_num := 90;

Line 1504: WHEN FND_API.G_EXC_ERROR THEN

1500: l_stmt_num := 90;
1501:
1502: EXCEPTION
1503:
1504: WHEN FND_API.G_EXC_ERROR THEN
1505:
1506: x_return_status := G_RET_ERROR;
1507: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1508: p_count => x_error_count ,

Line 1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1508: p_count => x_error_count ,
1509: p_data => x_error_msg
1510: );
1511:
1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1513:
1514: x_return_status := G_RET_UNEXPECTED;
1515:
1516: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 1628: RAISE FND_API.G_EXC_ERROR;

1624: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1625: p_run_log_level => l_log_level
1626: );
1627: END IF;
1628: RAISE FND_API.G_EXC_ERROR;
1629: end if;
1630:
1631: -- Bug fix 5219922: START.
1632: l_stmt_num := 35;

Line 1642: raise FND_API.G_EXC_ERROR;

1638: );
1639:
1640: if x_return_status <> G_RET_SUCCESS then
1641: IF x_return_status = G_RET_ERROR THEN
1642: raise FND_API.G_EXC_ERROR;
1643: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646: end if;

Line 1644: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1640: if x_return_status <> G_RET_SUCCESS then
1641: IF x_return_status = G_RET_ERROR THEN
1642: raise FND_API.G_EXC_ERROR;
1643: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646: end if;
1647: end if;
1648:

Line 1703: raise FND_API.G_EXC_ERROR;

1699:
1700: l_stmt_num := 50;
1701: if x_return_status <> G_RET_SUCCESS then
1702: IF x_return_status = G_RET_ERROR THEN
1703: raise FND_API.G_EXC_ERROR;
1704: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706: END IF;
1707: end if;

Line 1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1701: if x_return_status <> G_RET_SUCCESS then
1702: IF x_return_status = G_RET_ERROR THEN
1703: raise FND_API.G_EXC_ERROR;
1704: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706: END IF;
1707: end if;
1708: END IF;
1709:

Line 1745: raise FND_API.G_EXC_ERROR;

1741: l_stmt_num := 80;
1742:
1743: if x_return_status <> G_RET_SUCCESS then
1744: IF x_return_status = G_RET_ERROR THEN
1745: raise FND_API.G_EXC_ERROR;
1746: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1748: END IF;
1749: end if;

Line 1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1743: if x_return_status <> G_RET_SUCCESS then
1744: IF x_return_status = G_RET_ERROR THEN
1745: raise FND_API.G_EXC_ERROR;
1746: ELSIF x_return_status = G_RET_UNEXPECTED THEN
1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1748: END IF;
1749: end if;
1750:
1751: END IF;

Line 1755: WHEN FND_API.G_EXC_ERROR THEN

1751: END IF;
1752:
1753: EXCEPTION
1754:
1755: WHEN FND_API.G_EXC_ERROR THEN
1756:
1757: x_return_status := G_RET_ERROR;
1758: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1759: p_count => x_error_count ,

Line 1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1759: p_count => x_error_count ,
1760: p_data => x_error_msg
1761: );
1762:
1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764:
1765: x_return_status := G_RET_UNEXPECTED;
1766:
1767: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 1903: RAISE FND_API.G_EXC_ERROR;

1899: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1900: p_run_log_level => l_log_level
1901: );
1902: END IF;
1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905: ELSE
1906: IF g_log_level_error >= l_log_level OR
1907: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

Line 1920: RAISE FND_API.G_EXC_ERROR;

1916: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1917: p_run_log_level => l_log_level
1918: );
1919: END IF;
1920: RAISE FND_API.G_EXC_ERROR;
1921: END IF;
1922:
1923: EXCEPTION
1924: WHEN NO_DATA_FOUND THEN

Line 1968: RAISE FND_API.G_EXC_ERROR;

1964:
1965: l_stmt_num := 40;
1966:
1967: if l_quantity <> 1 or l_return_code <> 0 then
1968: RAISE FND_API.G_EXC_ERROR;
1969: end if;
1970:
1971: EXCEPTION
1972:

Line 1973: WHEN FND_API.G_EXC_ERROR THEN

1969: end if;
1970:
1971: EXCEPTION
1972:
1973: WHEN FND_API.G_EXC_ERROR THEN
1974:
1975: x_return_status := G_RET_ERROR;
1976: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1977: p_count => x_error_count ,

Line 1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1977: p_count => x_error_count ,
1978: p_data => x_error_msg
1979: );
1980:
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982:
1983: x_return_status := G_RET_UNEXPECTED;
1984:
1985: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 2033: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

2029: IS
2030: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2031: l_desc_attributes_tbl inv_serial_number_attr.char_table;
2032:
2033: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2034: l_attribute_category VARCHAR2(30);
2035:
2036: l_update_serial_attr NUMBER;
2037: l_update_desc_attr NUMBER;

Line 2095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2091: x_err_data => x_error_msg
2092: );
2093:
2094: if x_return_status <> g_ret_success then
2095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2096: end if;
2097:
2098: l_update_serial_attr := g_wms_installed;
2099: else

Line 2398: raise FND_API.G_EXC_ERROR;

2394: );
2395:
2396: if x_return_status <> G_RET_SUCCESS then
2397: IF x_return_status = G_RET_ERROR THEN
2398: raise FND_API.G_EXC_ERROR;
2399: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402: end if;

Line 2400: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2396: if x_return_status <> G_RET_SUCCESS then
2397: IF x_return_status = G_RET_ERROR THEN
2398: raise FND_API.G_EXC_ERROR;
2399: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402: end if;
2403:
2404: EXCEPTION

Line 2406: WHEN FND_API.G_EXC_ERROR THEN

2402: end if;
2403:
2404: EXCEPTION
2405:
2406: WHEN FND_API.G_EXC_ERROR THEN
2407:
2408: x_return_status := G_RET_ERROR;
2409: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2410: p_count => x_error_count ,

Line 2414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2410: p_count => x_error_count ,
2411: p_data => x_error_msg
2412: );
2413:
2414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2415:
2416: x_return_status := G_RET_UNEXPECTED;
2417:
2418: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2507: x_err_data => x_error_msg
2508: );
2509:
2510: if x_return_status <> g_ret_success then
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: end if;
2513:
2514: l_update_serial_attr := g_wms_installed;
2515: else

Line 2560: raise FND_API.G_EXC_ERROR;

2556: );
2557:
2558: if x_return_status <> g_ret_success or l_validation_status <> 'Y' then
2559: IF x_return_status = G_RET_ERROR THEN
2560: raise FND_API.G_EXC_ERROR;
2561: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2563: END IF;
2564: end if;

Line 2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2558: if x_return_status <> g_ret_success or l_validation_status <> 'Y' then
2559: IF x_return_status = G_RET_ERROR THEN
2560: raise FND_API.G_EXC_ERROR;
2561: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2563: END IF;
2564: end if;
2565: end if;
2566:

Line 2597: raise FND_API.G_EXC_ERROR;

2593:
2594: if x_return_status <> G_RET_SUCCESS then
2595: --error out..
2596: IF x_return_status = G_RET_ERROR THEN
2597: raise FND_API.G_EXC_ERROR;
2598: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END IF;
2601:

Line 2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2595: --error out..
2596: IF x_return_status = G_RET_ERROR THEN
2597: raise FND_API.G_EXC_ERROR;
2598: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END IF;
2601:
2602: end if;
2603: end if;

Line 2607: WHEN FND_API.G_EXC_ERROR THEN

2603: end if;
2604:
2605: EXCEPTION
2606:
2607: WHEN FND_API.G_EXC_ERROR THEN
2608:
2609: x_return_status := G_RET_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2611: p_count => x_error_count ,

Line 2615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2611: p_count => x_error_count ,
2612: p_data => x_error_msg
2613: );
2614:
2615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2616:
2617: x_return_status := G_RET_UNEXPECTED;
2618:
2619: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 2887: raise FND_API.G_EXC_ERROR;

2883:
2884: l_stmt_num := 40;
2885:
2886: IF x_return_status = G_RET_ERROR THEN
2887: raise FND_API.G_EXC_ERROR;
2888: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2889: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2890: END IF;
2891:

Line 2889: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2885:
2886: IF x_return_status = G_RET_ERROR THEN
2887: raise FND_API.G_EXC_ERROR;
2888: ELSIF x_return_status = G_RET_UNEXPECTED THEN
2889: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2890: END IF;
2891:
2892: exception
2893:

Line 2894: WHEN FND_API.G_EXC_ERROR THEN

2890: END IF;
2891:
2892: exception
2893:
2894: WHEN FND_API.G_EXC_ERROR THEN
2895: rollback to update_serial;
2896: x_return_status := G_RET_ERROR;
2897: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2898: p_count => x_error_count ,

Line 2902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2898: p_count => x_error_count ,
2899: p_data => x_error_msg
2900: );
2901:
2902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2903: rollback to update_serial;
2904: x_return_status := G_RET_UNEXPECTED;
2905: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2906: p_count => x_error_count ,

Line 2966: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

2962: l_serial_start_flag NUMBER;
2963: l_first_serial_txn_id NUMBER;
2964: l_serial_start_op NUMBER;
2965:
2966: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2967: l_null_num NUMBER := FND_API.G_NULL_NUM;
2968: l_null_date DATE := FND_API.G_NULL_DATE;
2969: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
2970:

Line 2967: l_null_num NUMBER := FND_API.G_NULL_NUM;

2963: l_first_serial_txn_id NUMBER;
2964: l_serial_start_op NUMBER;
2965:
2966: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2967: l_null_num NUMBER := FND_API.G_NULL_NUM;
2968: l_null_date DATE := FND_API.G_NULL_DATE;
2969: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
2970:
2971: cursor c_move_serials

Line 2968: l_null_date DATE := FND_API.G_NULL_DATE;

2964: l_serial_start_op NUMBER;
2965:
2966: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2967: l_null_num NUMBER := FND_API.G_NULL_NUM;
2968: l_null_date DATE := FND_API.G_NULL_DATE;
2969: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
2970:
2971: cursor c_move_serials
2972: is

Line 2969: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

2965:
2966: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2967: l_null_num NUMBER := FND_API.G_NULL_NUM;
2968: l_null_date DATE := FND_API.G_NULL_DATE;
2969: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
2970:
2971: cursor c_move_serials
2972: is
2973: select

Line 3221: raise FND_API.G_EXC_ERROR;

3217: );
3218:
3219: if x_return_status <> G_RET_SUCCESS then
3220: IF x_return_status = G_RET_ERROR THEN
3221: raise FND_API.G_EXC_ERROR;
3222: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3223: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225: end if;

Line 3223: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3219: if x_return_status <> G_RET_SUCCESS then
3220: IF x_return_status = G_RET_ERROR THEN
3221: raise FND_API.G_EXC_ERROR;
3222: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3223: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225: end if;
3226: l_stmt_num := 25;
3227:

Line 3261: RAISE FND_API.G_EXC_ERROR;

3257: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3258: p_run_log_level => l_log_level
3259: );
3260: END IF;
3261: RAISE FND_API.G_EXC_ERROR;
3262: end if;
3263: RETURN;
3264:
3265: ELSIF p_wsm_serial_nums_tbl.count = 0 THEN

Line 3302: raise FND_API.G_EXC_ERROR;

3298: );
3299:
3300: if x_return_status <> G_RET_SUCCESS then
3301: IF x_return_status = G_RET_ERROR THEN
3302: raise FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;
3306: end if;

Line 3304: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3300: if x_return_status <> G_RET_SUCCESS then
3301: IF x_return_status = G_RET_ERROR THEN
3302: raise FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;
3306: end if;
3307: end if; -- end invoke process_serial_info
3308:

Line 3346: RAISE FND_API.G_EXC_ERROR;

3342: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3343: p_run_log_level => l_log_level
3344: );
3345: END IF;
3346: RAISE FND_API.G_EXC_ERROR;
3347: end if;
3348:
3349: ELSE
3350: l_stmt_num := 90;

Line 3388: RAISE FND_API.G_EXC_ERROR;

3384: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3385: p_run_log_level => l_log_level
3386: );
3387: END IF;
3388: RAISE FND_API.G_EXC_ERROR;
3389: end if;
3390:
3391: l_stmt_num := 110;
3392: open c_move_serials;

Line 3445: raise FND_API.G_EXC_ERROR;

3441: );
3442:
3443: if x_return_status <> G_RET_SUCCESS then
3444: IF x_return_status = G_RET_ERROR THEN
3445: raise FND_API.G_EXC_ERROR;
3446: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3447: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449: end if;

Line 3447: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3443: if x_return_status <> G_RET_SUCCESS then
3444: IF x_return_status = G_RET_ERROR THEN
3445: raise FND_API.G_EXC_ERROR;
3446: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3447: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449: end if;
3450:
3451: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 3464: WHEN FND_API.G_EXC_ERROR THEN

3460: END IF;
3461:
3462: EXCEPTION
3463:
3464: WHEN FND_API.G_EXC_ERROR THEN
3465:
3466: x_return_status := G_RET_ERROR;
3467: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3468: p_count => x_error_count ,

Line 3472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3468: p_count => x_error_count ,
3469: p_data => x_error_msg
3470: );
3471:
3472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3473:
3474: x_return_status := G_RET_UNEXPECTED;
3475:
3476: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 3588: raise FND_API.G_EXC_ERROR;

3584: x_error_count => x_error_count
3585: );
3586: if x_return_status <> G_RET_SUCCESS then
3587: IF x_return_status = G_RET_ERROR THEN
3588: raise FND_API.G_EXC_ERROR;
3589: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3591: END IF;
3592: end if;

Line 3590: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3586: if x_return_status <> G_RET_SUCCESS then
3587: IF x_return_status = G_RET_ERROR THEN
3588: raise FND_API.G_EXC_ERROR;
3589: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3591: END IF;
3592: end if;
3593: END IF;
3594:

Line 3642: raise FND_API.G_EXC_ERROR;

3638: );
3639:
3640: if x_return_status <> G_RET_SUCCESS then
3641: IF x_return_status = G_RET_ERROR THEN
3642: raise FND_API.G_EXC_ERROR;
3643: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END IF;
3646: end if;

Line 3644: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3640: if x_return_status <> G_RET_SUCCESS then
3641: IF x_return_status = G_RET_ERROR THEN
3642: raise FND_API.G_EXC_ERROR;
3643: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END IF;
3646: end if;
3647:
3648: l_stmt_num := 30;

Line 3723: raise FND_API.G_EXC_ERROR;

3719: );
3720:
3721: if x_return_status <> G_RET_SUCCESS then
3722: IF x_return_status = G_RET_ERROR THEN
3723: raise FND_API.G_EXC_ERROR;
3724: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3725: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3726: END IF;
3727: end if;

Line 3725: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3721: if x_return_status <> G_RET_SUCCESS then
3722: IF x_return_status = G_RET_ERROR THEN
3723: raise FND_API.G_EXC_ERROR;
3724: ELSIF x_return_status = G_RET_UNEXPECTED THEN
3725: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3726: END IF;
3727: end if;
3728:
3729: -- if the old txn_id = first serial move transaction id, then clear the fields in

Line 3753: WHEN FND_API.G_EXC_ERROR THEN

3749: END IF;
3750: end if;
3751: EXCEPTION
3752:
3753: WHEN FND_API.G_EXC_ERROR THEN
3754: ROLLBACK to Move_serial_proc;
3755: x_return_status := G_RET_ERROR;
3756: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3757: p_count => x_error_count ,

Line 3761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3757: p_count => x_error_count ,
3758: p_data => x_error_msg
3759: );
3760:
3761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3762: ROLLBACK to Move_serial_proc;
3763: x_return_status := G_RET_UNEXPECTED;
3764:
3765: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 3967: RAISE FND_API.G_EXC_ERROR;

3963: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3964: p_run_log_level => l_log_level
3965: );
3966: END IF;
3967: RAISE FND_API.G_EXC_ERROR;
3968:
3969: End if;
3970:
3971:

Line 4009: RAISE FND_API.G_EXC_ERROR;

4005: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4006: p_run_log_level => l_log_level
4007: );
4008: END IF;
4009: RAISE FND_API.G_EXC_ERROR;
4010: END IF;
4011: -- return...
4012: RETURN;
4013: END IF;

Line 4032: RAISE FND_API.G_EXC_ERROR;

4028: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4029: p_run_log_level => l_log_level
4030: );
4031: END IF;
4032: RAISE FND_API.G_EXC_ERROR;
4033: END IF;
4034:
4035: -- Now get the count of the serial numbers being moved....
4036: l_move_serial_qty := 0;

Line 4063: RAISE FND_API.G_EXC_ERROR;

4059: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4060: p_run_log_level => l_log_level
4061: );
4062: END IF;
4063: RAISE FND_API.G_EXC_ERROR;
4064: end if;
4065:
4066: if p_serial_num_tbl(l_cntr).action_flag = 5 then
4067: l_move_serial_qty := l_move_serial_qty + 1;

Line 4116: RAISE FND_API.G_EXC_ERROR;

4112: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4113: p_run_log_level => l_log_level
4114: );
4115: END IF;
4116: RAISE FND_API.G_EXC_ERROR;
4117:
4118: elsif (l_move_serial_qty = p_move_qty) THEN
4119: -- -- all the move serial numbers provided...
4120: l_count := 0;

Line 4523: RAISE FND_API.G_EXC_ERROR;

4519: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4520: p_run_log_level => l_log_level
4521: );
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;
4524: end if;
4525:
4526: l_stmt_num := 260;
4527: -- loop theough p_serial_num_tbl and load the local PL/SQl table...

Line 4633: raise FND_API.G_EXC_ERROR;

4629: );
4630:
4631: if x_return_status <> G_RET_SUCCESS then
4632: IF x_return_status = G_RET_ERROR THEN
4633: raise FND_API.G_EXC_ERROR;
4634: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4635: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4636: END IF;
4637: end if;

Line 4635: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4631: if x_return_status <> G_RET_SUCCESS then
4632: IF x_return_status = G_RET_ERROR THEN
4633: raise FND_API.G_EXC_ERROR;
4634: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4635: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4636: END IF;
4637: end if;
4638:
4639: l_stmt_num := 310;

Line 4676: raise FND_API.G_EXC_ERROR;

4672: );
4673:
4674: if x_return_status <> G_RET_SUCCESS then
4675: IF x_return_status = G_RET_ERROR THEN
4676: raise FND_API.G_EXC_ERROR;
4677: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4679: END IF;
4680: end if;

Line 4678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4674: if x_return_status <> G_RET_SUCCESS then
4675: IF x_return_status = G_RET_ERROR THEN
4676: raise FND_API.G_EXC_ERROR;
4677: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4679: END IF;
4680: end if;
4681: end loop;
4682: END IF;

Line 4687: WHEN FND_API.G_EXC_ERROR THEN

4683:
4684: l_stmt_num := 330;
4685:
4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688:
4689: x_return_status := G_RET_ERROR;
4690: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
4691: p_count => x_error_count ,

Line 4695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4691: p_count => x_error_count ,
4692: p_data => x_error_msg
4693: );
4694:
4695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4696:
4697: x_return_status := G_RET_UNEXPECTED;
4698:
4699: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 4875: RAISE FND_API.G_EXC_ERROR;

4871: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4872: p_run_log_level => l_log_level
4873: );
4874: END IF;
4875: RAISE FND_API.G_EXC_ERROR;
4876: end if;
4877:
4878: l_stmt_num := 70;
4879: IF p_move_qty > 0 THEN

Line 4932: RAISE FND_API.G_EXC_ERROR;

4928: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4929: p_run_log_level => l_log_level
4930: );
4931: END IF;
4932: RAISE FND_API.G_EXC_ERROR;
4933: end if;
4934:
4935: l_stmt_num := 120;
4936: l_pos := 0;

Line 5003: WHEN FND_API.G_EXC_ERROR THEN

4999: forall l_counter in l_wip_serial_rows_tbl.first..l_wip_serial_rows_tbl.last
5000: insert into wip_serial_move_interface values l_wip_serial_rows_tbl(l_counter);
5001:
5002: EXCEPTION
5003: WHEN FND_API.G_EXC_ERROR THEN
5004:
5005: x_return_status := G_RET_ERROR;
5006: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5007: p_count => x_error_count ,

Line 5011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5007: p_count => x_error_count ,
5008: p_data => x_error_msg
5009: );
5010:
5011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5012:
5013: x_return_status := G_RET_UNEXPECTED;
5014:
5015: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 5058: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

5054:
5055: l_wip_entity_id NUMBER;
5056: l_inventory_item_id NUMBER;
5057:
5058: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
5059: l_null_num NUMBER := FND_API.G_NULL_NUM;
5060: l_null_date DATE := FND_API.G_NULL_DATE;
5061: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5062:

Line 5059: l_null_num NUMBER := FND_API.G_NULL_NUM;

5055: l_wip_entity_id NUMBER;
5056: l_inventory_item_id NUMBER;
5057:
5058: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
5059: l_null_num NUMBER := FND_API.G_NULL_NUM;
5060: l_null_date DATE := FND_API.G_NULL_DATE;
5061: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5062:
5063: cursor c_wlt_serials

Line 5060: l_null_date DATE := FND_API.G_NULL_DATE;

5056: l_inventory_item_id NUMBER;
5057:
5058: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
5059: l_null_num NUMBER := FND_API.G_NULL_NUM;
5060: l_null_date DATE := FND_API.G_NULL_DATE;
5061: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5062:
5063: cursor c_wlt_serials
5064: is

Line 5061: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

5057:
5058: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
5059: l_null_num NUMBER := FND_API.G_NULL_NUM;
5060: l_null_date DATE := FND_API.G_NULL_DATE;
5061: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5062:
5063: cursor c_wlt_serials
5064: is
5065: select

Line 5236: RAISE FND_API.G_EXC_ERROR;

5232: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5233: p_run_log_level => l_log_level
5234: );
5235: END IF;
5236: RAISE FND_API.G_EXC_ERROR;
5237: END;
5238: ELSE
5239: l_stmt_num := 30;
5240: BEGIN

Line 5280: RAISE FND_API.G_EXC_ERROR;

5276: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5277: p_run_log_level => l_log_level
5278: );
5279: END IF;
5280: RAISE FND_API.G_EXC_ERROR;
5281: END;
5282: END IF;
5283:
5284: l_stmt_num := 40;

Line 5329: RAISE FND_API.G_EXC_ERROR;

5325: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5326: p_run_log_level => l_log_level
5327: );
5328: END IF;
5329: RAISE FND_API.G_EXC_ERROR;
5330: end if;
5331:
5332: l_stmt_num := 50;
5333: open c_wlt_serials;

Line 5367: RAISE FND_API.G_EXC_ERROR;

5363: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5364: p_run_log_level => l_log_level
5365: );
5366: END IF;
5367: RAISE FND_API.G_EXC_ERROR;
5368: end if;
5369:
5370: l_stmt_num := 70;
5371: -- just fetch the data...

Line 5381: WHEN FND_API.G_EXC_ERROR THEN

5377: l_stmt_num := 80;
5378: end if;
5379: EXCEPTION
5380:
5381: WHEN FND_API.G_EXC_ERROR THEN
5382:
5383: x_return_status := G_RET_ERROR;
5384: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5385: p_count => x_error_count ,

Line 5783: raise FND_API.G_EXC_ERROR;

5779: x_error_count => x_error_count
5780: );
5781: if x_return_status <> G_RET_SUCCESS then
5782: IF x_return_status = G_RET_ERROR THEN
5783: raise FND_API.G_EXC_ERROR;
5784: ELSIF x_return_status = G_RET_UNEXPECTED THEN
5785: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5786: END IF;
5787: end if;

Line 5785: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5781: if x_return_status <> G_RET_SUCCESS then
5782: IF x_return_status = G_RET_ERROR THEN
5783: raise FND_API.G_EXC_ERROR;
5784: ELSIF x_return_status = G_RET_UNEXPECTED THEN
5785: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5786: END IF;
5787: end if;
5788: END IF;
5789:

Line 5832: raise FND_API.G_EXC_ERROR;

5828: );
5829:
5830: if x_return_status <> G_RET_SUCCESS then
5831: IF x_return_status = G_RET_ERROR THEN
5832: raise FND_API.G_EXC_ERROR;
5833: ELSIF x_return_status = G_RET_UNEXPECTED THEN
5834: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5835: END IF;
5836: end if;

Line 5834: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5830: if x_return_status <> G_RET_SUCCESS then
5831: IF x_return_status = G_RET_ERROR THEN
5832: raise FND_API.G_EXC_ERROR;
5833: ELSIF x_return_status = G_RET_UNEXPECTED THEN
5834: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5835: END IF;
5836: end if;
5837:
5838: IF l_serial_start_flag IS NOT NULL THEN

Line 5893: RAISE FND_API.G_EXC_ERROR;

5889: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5890: p_run_log_level => l_log_level
5891: );
5892: END IF;
5893: RAISE FND_API.G_EXC_ERROR;
5894: END IF;
5895: RETURN;
5896: end if;
5897:

Line 5947: RAISE FND_API.G_EXC_ERROR;

5943: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5944: p_run_log_level => l_log_level
5945: );
5946: END IF;
5947: RAISE FND_API.G_EXC_ERROR;
5948: END IF;
5949:
5950: l_stmt_num := 80;
5951: -- First thing is sort the serial numbers table based on wip_entity_name

Line 5982: RAISE FND_API.G_EXC_ERROR;

5978: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5979: p_run_log_level => l_log_level
5980: );
5981: END IF;
5982: RAISE FND_API.G_EXC_ERROR;
5983: END IF;
5984:
5985: IF (p_serial_num_tbl(l_index2).changed_wip_entity_name < p_serial_num_tbl(l_index1).changed_wip_entity_name)
5986: -- OR (p_serial_num_tbl(l_index2).changed_wip_entity_name <> l_wip_entity_name AND

Line 6052: RAISE FND_API.G_EXC_ERROR;

6048: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6049: p_run_log_level => l_log_level
6050: );
6051: END IF;
6052: RAISE FND_API.G_EXC_ERROR;
6053: end if;
6054:
6055: l_job_ser_info_tbl(p_serial_num_tbl(l_index).changed_wip_entity_name).l_index_start := l_index;
6056: l_job_ser_info_tbl(p_serial_num_tbl(l_index).changed_wip_entity_name).l_count := 1;

Line 6094: raise FND_API.G_EXC_ERROR;

6090: );
6091:
6092: if x_return_status <> G_RET_SUCCESS then
6093: IF x_return_status = G_RET_ERROR THEN
6094: raise FND_API.G_EXC_ERROR;
6095: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6096: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6097: END IF;
6098: end if;

Line 6096: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6092: if x_return_status <> G_RET_SUCCESS then
6093: IF x_return_status = G_RET_ERROR THEN
6094: raise FND_API.G_EXC_ERROR;
6095: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6096: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6097: END IF;
6098: end if;
6099:
6100: l_update_serial_attr := g_wms_installed;

Line 6145: RAISE FND_API.G_EXC_ERROR;

6141: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6142: p_run_log_level => l_log_level
6143: );
6144: END IF;
6145: RAISE FND_API.G_EXC_ERROR;
6146: end if;
6147:
6148: l_stmt_num := 133;
6149: -- first check is on the count...

Line 6183: RAISE FND_API.G_EXC_ERROR;

6179: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6180: p_run_log_level => l_log_level
6181: );
6182: END IF;
6183: RAISE FND_API.G_EXC_ERROR;
6184: END IF;
6185:
6186: -- None encountered so far...
6187: l_filling_job_name := p_resulting_jobs_tbl(l_index).wip_entity_name;

Line 6327: raise FND_API.G_EXC_ERROR;

6323: );
6324:
6325: if x_return_status <> G_RET_SUCCESS then
6326: IF x_return_status = G_RET_ERROR THEN
6327: raise FND_API.G_EXC_ERROR;
6328: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END IF;
6331: end if;

Line 6329: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6325: if x_return_status <> G_RET_SUCCESS then
6326: IF x_return_status = G_RET_ERROR THEN
6327: raise FND_API.G_EXC_ERROR;
6328: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END IF;
6331: end if;
6332:
6333: l_stmt_num := 141;

Line 6413: RAISE FND_API.G_EXC_ERROR;

6409: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6410: p_run_log_level => l_log_level
6411: );
6412: END IF;
6413: RAISE FND_API.G_EXC_ERROR;
6414: END IF;
6415:
6416: END IF;
6417:

Line 6449: RAISE FND_API.G_EXC_ERROR;

6445: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6446: p_run_log_level => l_log_level
6447: );
6448: END IF;
6449: RAISE FND_API.G_EXC_ERROR;
6450: end if;
6451:
6452: ELSE
6453: -- Indicates that the starting job is not a res. job...

Line 6472: RAISE FND_API.G_EXC_ERROR;

6468: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6469: p_run_log_level => l_log_level
6470: );
6471: END IF;
6472: RAISE FND_API.G_EXC_ERROR;
6473: end if;
6474: end if;
6475:
6476: l_stmt_num := 147;

Line 6577: raise FND_API.G_EXC_ERROR;

6573: );
6574:
6575: if x_return_status <> G_RET_SUCCESS then
6576: IF x_return_status = G_RET_ERROR THEN
6577: raise FND_API.G_EXC_ERROR;
6578: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6579: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6580: END IF;
6581: end if;

Line 6579: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6575: if x_return_status <> G_RET_SUCCESS then
6576: IF x_return_status = G_RET_ERROR THEN
6577: raise FND_API.G_EXC_ERROR;
6578: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6579: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6580: END IF;
6581: end if;
6582:
6583: end if;

Line 6609: raise FND_API.G_EXC_ERROR;

6605: );
6606:
6607: if x_return_status <> G_RET_SUCCESS then
6608: IF x_return_status = G_RET_ERROR THEN
6609: raise FND_API.G_EXC_ERROR;
6610: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6612: END IF;
6613: end if;

Line 6611: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6607: if x_return_status <> G_RET_SUCCESS then
6608: IF x_return_status = G_RET_ERROR THEN
6609: raise FND_API.G_EXC_ERROR;
6610: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6612: END IF;
6613: end if;
6614: END IF;
6615:

Line 6648: raise FND_API.G_EXC_ERROR;

6644: );
6645:
6646: if x_return_status <> G_RET_SUCCESS then
6647: IF x_return_status = G_RET_ERROR THEN
6648: raise FND_API.G_EXC_ERROR;
6649: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6650: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END IF;
6652: end if;

Line 6650: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6646: if x_return_status <> G_RET_SUCCESS then
6647: IF x_return_status = G_RET_ERROR THEN
6648: raise FND_API.G_EXC_ERROR;
6649: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6650: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END IF;
6652: end if;
6653:
6654: else

Line 6694: raise FND_API.G_EXC_ERROR;

6690: );
6691:
6692: if x_return_status <> G_RET_SUCCESS then
6693: IF x_return_status = G_RET_ERROR THEN
6694: raise FND_API.G_EXC_ERROR;
6695: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6696: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6697: END IF;
6698: end if;

Line 6696: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6692: if x_return_status <> G_RET_SUCCESS then
6693: IF x_return_status = G_RET_ERROR THEN
6694: raise FND_API.G_EXC_ERROR;
6695: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6696: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6697: END IF;
6698: end if;
6699: end if;
6700:

Line 6720: raise FND_API.G_EXC_ERROR;

6716: x_error_msg => x_error_msg
6717: );
6718: if x_return_status <> G_RET_SUCCESS then
6719: IF x_return_status = G_RET_ERROR THEN
6720: raise FND_API.G_EXC_ERROR;
6721: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6722: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6723: END IF;
6724: end if;

Line 6722: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6718: if x_return_status <> G_RET_SUCCESS then
6719: IF x_return_status = G_RET_ERROR THEN
6720: raise FND_API.G_EXC_ERROR;
6721: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6722: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6723: END IF;
6724: end if;
6725: END IF;
6726:

Line 6817: raise FND_API.G_EXC_ERROR;

6813: );
6814:
6815: if x_return_status <> G_RET_SUCCESS then
6816: IF x_return_status = G_RET_ERROR THEN
6817: raise FND_API.G_EXC_ERROR;
6818: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6820: END IF;
6821: end if;

Line 6819: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6815: if x_return_status <> G_RET_SUCCESS then
6816: IF x_return_status = G_RET_ERROR THEN
6817: raise FND_API.G_EXC_ERROR;
6818: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6820: END IF;
6821: end if;
6822: end if;
6823:

Line 6965: raise FND_API.G_EXC_ERROR;

6961: );
6962:
6963: if x_return_status <> G_RET_SUCCESS then
6964: IF x_return_status = G_RET_ERROR THEN
6965: raise FND_API.G_EXC_ERROR;
6966: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6967: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END IF;
6969: END IF;

Line 6967: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6963: if x_return_status <> G_RET_SUCCESS then
6964: IF x_return_status = G_RET_ERROR THEN
6965: raise FND_API.G_EXC_ERROR;
6966: ELSIF x_return_status = G_RET_UNEXPECTED THEN
6967: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END IF;
6969: END IF;
6970: ELSE
6971: l_stmt_num := 200;

Line 7004: raise FND_API.G_EXC_ERROR;

7000: );
7001:
7002: IF x_return_status <> G_RET_SUCCESS THEN
7003: IF x_return_status = G_RET_ERROR THEN
7004: raise FND_API.G_EXC_ERROR;
7005: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7006: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7007: END IF;
7008: END IF;

Line 7006: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7002: IF x_return_status <> G_RET_SUCCESS THEN
7003: IF x_return_status = G_RET_ERROR THEN
7004: raise FND_API.G_EXC_ERROR;
7005: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7006: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7007: END IF;
7008: END IF;
7009:
7010: -- If the parent is serial tracked then all child jobs will also be serial tracked...

Line 7046: raise FND_API.G_EXC_ERROR;

7042: );
7043:
7044: if x_return_status <> G_RET_SUCCESS then
7045: IF x_return_status = G_RET_ERROR THEN
7046: raise FND_API.G_EXC_ERROR;
7047: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7048: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END IF;
7050: end if;

Line 7048: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7044: if x_return_status <> G_RET_SUCCESS then
7045: IF x_return_status = G_RET_ERROR THEN
7046: raise FND_API.G_EXC_ERROR;
7047: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7048: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END IF;
7050: end if;
7051: end if;
7052:

Line 7125: raise FND_API.G_EXC_ERROR;

7121: );
7122:
7123: if x_return_status <> G_RET_SUCCESS then
7124: IF x_return_status = G_RET_ERROR THEN
7125: raise FND_API.G_EXC_ERROR;
7126: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7127: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7128: END IF;
7129: end if;

Line 7127: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7123: if x_return_status <> G_RET_SUCCESS then
7124: IF x_return_status = G_RET_ERROR THEN
7125: raise FND_API.G_EXC_ERROR;
7126: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7127: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7128: END IF;
7129: end if;
7130:
7131: l_stmt_num := 240;

Line 7146: raise FND_API.G_EXC_ERROR;

7142: );
7143:
7144: if x_return_status <> G_RET_SUCCESS then
7145: IF x_return_status = G_RET_ERROR THEN
7146: raise FND_API.G_EXC_ERROR;
7147: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7148: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7149: END IF;
7150: end if;

Line 7148: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7144: if x_return_status <> G_RET_SUCCESS then
7145: IF x_return_status = G_RET_ERROR THEN
7146: raise FND_API.G_EXC_ERROR;
7147: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7148: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7149: END IF;
7150: end if;
7151:
7152: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_ROUTING THEN -- Update Routing transaction

Line 7183: raise FND_API.G_EXC_ERROR;

7179: );
7180:
7181: if x_return_status <> G_RET_SUCCESS then
7182: IF x_return_status = G_RET_ERROR THEN
7183: raise FND_API.G_EXC_ERROR;
7184: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7185: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7186: END IF;
7187: end if;

Line 7185: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7181: if x_return_status <> G_RET_SUCCESS then
7182: IF x_return_status = G_RET_ERROR THEN
7183: raise FND_API.G_EXC_ERROR;
7184: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7185: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7186: END IF;
7187: end if;
7188:
7189: l_stmt_num := 260;

Line 7205: raise FND_API.G_EXC_ERROR;

7201: );
7202:
7203: if x_return_status <> G_RET_SUCCESS then
7204: IF x_return_status = G_RET_ERROR THEN
7205: raise FND_API.G_EXC_ERROR;
7206: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7207: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7208: END IF;
7209: end if;

Line 7207: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7203: if x_return_status <> G_RET_SUCCESS then
7204: IF x_return_status = G_RET_ERROR THEN
7205: raise FND_API.G_EXC_ERROR;
7206: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7207: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7208: END IF;
7209: end if;
7210:
7211: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_LOT_NAME THEN -- Update Lot Name transaction

Line 7228: raise FND_API.G_EXC_ERROR;

7224: );
7225:
7226: if x_return_status <> G_RET_SUCCESS then
7227: IF x_return_status = G_RET_ERROR THEN
7228: raise FND_API.G_EXC_ERROR;
7229: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7230: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7231: END IF;
7232: end if;

Line 7230: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7226: if x_return_status <> G_RET_SUCCESS then
7227: IF x_return_status = G_RET_ERROR THEN
7228: raise FND_API.G_EXC_ERROR;
7229: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7230: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7231: END IF;
7232: end if;
7233:
7234: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_QUANTITY THEN -- Update Quantity transaction

Line 7257: RAISE FND_API.G_EXC_ERROR;

7253: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7254: p_run_log_level => l_log_level
7255: );
7256: END IF;
7257: RAISE FND_API.G_EXC_ERROR;
7258: ELSE
7259: -- ST : Fix for bug 5143373
7260: -- Insert the existing serials...
7261: Insert_into_WST ( p_transaction_id => p_txn_id ,

Line 7275: raise FND_API.G_EXC_ERROR;

7271: );
7272:
7273: if x_return_status <> G_RET_SUCCESS then
7274: IF x_return_status = G_RET_ERROR THEN
7275: raise FND_API.G_EXC_ERROR;
7276: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7277: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7278: END IF;
7279: end if;

Line 7277: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7273: if x_return_status <> G_RET_SUCCESS then
7274: IF x_return_status = G_RET_ERROR THEN
7275: raise FND_API.G_EXC_ERROR;
7276: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7277: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7278: END IF;
7279: end if;
7280: -- ST : Fix for bug 5143373 end --
7281: return;

Line 7309: raise FND_API.G_EXC_ERROR;

7305:
7306: l_stmt_num := 320;
7307: if x_return_status <> G_RET_SUCCESS then
7308: IF x_return_status = G_RET_ERROR THEN
7309: raise FND_API.G_EXC_ERROR;
7310: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7312: END IF;
7313: end if;

Line 7311: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7307: if x_return_status <> G_RET_SUCCESS then
7308: IF x_return_status = G_RET_ERROR THEN
7309: raise FND_API.G_EXC_ERROR;
7310: ELSIF x_return_status = G_RET_UNEXPECTED THEN
7311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7312: END IF;
7313: end if;
7314: END IF;
7315:

Line 7345: RAISE FND_API.G_EXC_ERROR;

7341: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7342: p_run_log_level => l_log_level
7343: );
7344: END IF;
7345: RAISE FND_API.G_EXC_ERROR;
7346: END IF;
7347:
7348: l_stmt_num := 350;
7349:

Line 7454: WHEN FND_API.G_EXC_ERROR THEN

7450:
7451: END IF;
7452:
7453: EXCEPTION
7454: WHEN FND_API.G_EXC_ERROR THEN
7455: ROLLBACK to WLT_serial_proc;
7456: x_return_status := G_RET_ERROR;
7457: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7458: p_count => x_error_count ,

Line 7462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7458: p_count => x_error_count ,
7459: p_data => x_error_msg
7460: );
7461:
7462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7463: ROLLBACK to WLT_serial_proc;
7464: x_return_status := G_RET_UNEXPECTED;
7465:
7466: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 7559: RAISE FND_API.G_EXC_ERROR;

7555: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7556: p_run_log_level => l_log_level
7557: );
7558: END IF;
7559: RAISE FND_API.G_EXC_ERROR;
7560:
7561: END IF;
7562:
7563:

Line 7585: RAISE FND_API.G_EXC_ERROR;

7581: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7582: p_run_log_level => l_log_level
7583: );
7584: END IF;
7585: RAISE FND_API.G_EXC_ERROR;
7586:
7587: END IF;
7588:
7589: l_stmt_num := 60;

Line 7617: RAISE FND_API.G_EXC_ERROR;

7613: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7614: p_run_log_level => l_log_level
7615: );
7616: END IF;
7617: RAISE FND_API.G_EXC_ERROR;
7618:
7619: END IF;
7620:
7621: l_stmt_num := 70;

Line 7644: RAISE FND_API.G_EXC_ERROR;

7640: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7641: p_run_log_level => l_log_level
7642: );
7643: END IF;
7644: RAISE FND_API.G_EXC_ERROR;
7645:
7646: END IF;
7647: END IF;
7648:

Line 7653: WHEN FND_API.G_EXC_ERROR THEN

7649: l_stmt_num := 80;
7650:
7651: EXCEPTION
7652:
7653: WHEN FND_API.G_EXC_ERROR THEN
7654:
7655: x_return_status := G_RET_ERROR;
7656: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7657: p_count => x_error_count ,

Line 7661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7657: p_count => x_error_count ,
7658: p_data => x_error_msg
7659: );
7660:
7661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7662:
7663: x_return_status := G_RET_UNEXPECTED;
7664:
7665: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 8561: raise FND_API.G_EXC_ERROR;

8557: );
8558:
8559: if x_return_status <> G_RET_SUCCESS then
8560: IF x_return_status = G_RET_ERROR THEN
8561: raise FND_API.G_EXC_ERROR;
8562: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8563: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8564: END IF;
8565: end if;

Line 8563: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8559: if x_return_status <> G_RET_SUCCESS then
8560: IF x_return_status = G_RET_ERROR THEN
8561: raise FND_API.G_EXC_ERROR;
8562: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8563: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8564: END IF;
8565: end if;
8566:
8567: l_cntr := l_serial_info_tbl.next(l_cntr);

Line 8611: raise FND_API.G_EXC_ERROR;

8607: );
8608:
8609: if x_return_status <> G_RET_SUCCESS then
8610: IF x_return_status = G_RET_ERROR THEN
8611: raise FND_API.G_EXC_ERROR;
8612: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8613: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8614: END IF;
8615: end if;

Line 8613: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8609: if x_return_status <> G_RET_SUCCESS then
8610: IF x_return_status = G_RET_ERROR THEN
8611: raise FND_API.G_EXC_ERROR;
8612: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8613: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8614: END IF;
8615: end if;
8616:
8617: l_cntr := l_serial_info_tbl.next(l_cntr);

Line 8676: raise FND_API.G_EXC_ERROR;

8672: );
8673:
8674: if x_return_status <> G_RET_SUCCESS then
8675: IF x_return_status = G_RET_ERROR THEN
8676: raise FND_API.G_EXC_ERROR;
8677: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8679: END IF;
8680: end if;

Line 8678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8674: if x_return_status <> G_RET_SUCCESS then
8675: IF x_return_status = G_RET_ERROR THEN
8676: raise FND_API.G_EXC_ERROR;
8677: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8679: END IF;
8680: end if;
8681:
8682: l_cntr := l_serial_info_tbl.next(l_cntr);

Line 8726: raise FND_API.G_EXC_ERROR;

8722: );
8723:
8724: if x_return_status <> G_RET_SUCCESS then
8725: IF x_return_status = G_RET_ERROR THEN
8726: raise FND_API.G_EXC_ERROR;
8727: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8728: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8729: END IF;
8730: end if;

Line 8728: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8724: if x_return_status <> G_RET_SUCCESS then
8725: IF x_return_status = G_RET_ERROR THEN
8726: raise FND_API.G_EXC_ERROR;
8727: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8728: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8729: END IF;
8730: end if;
8731:
8732: l_cntr := l_serial_info_tbl.next(l_cntr);

Line 8789: raise FND_API.G_EXC_ERROR;

8785: );
8786:
8787: if x_return_status <> G_RET_SUCCESS then
8788: IF x_return_status = G_RET_ERROR THEN
8789: raise FND_API.G_EXC_ERROR;
8790: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8791: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8792: END IF;
8793: end if;

Line 8791: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8787: if x_return_status <> G_RET_SUCCESS then
8788: IF x_return_status = G_RET_ERROR THEN
8789: raise FND_API.G_EXC_ERROR;
8790: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8791: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8792: END IF;
8793: end if;
8794:
8795: IF not (l_serial_txn_tbl.exists(l_wsm_serial_attrs_tbl(l_cntr).header_id)) THEN

Line 8852: raise FND_API.G_EXC_ERROR;

8848: );
8849:
8850: if x_return_status <> G_RET_SUCCESS then
8851: IF x_return_status = G_RET_ERROR THEN
8852: raise FND_API.G_EXC_ERROR;
8853: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8855: END IF;
8856: end if;

Line 8854: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8850: if x_return_status <> G_RET_SUCCESS then
8851: IF x_return_status = G_RET_ERROR THEN
8852: raise FND_API.G_EXC_ERROR;
8853: ELSIF x_return_status = G_RET_UNEXPECTED THEN
8854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8855: END IF;
8856: end if;
8857:
8858: l_cntr := l_wsm_serial_attrs_tbl.next(l_cntr);

Line 8893: WHEN FND_API.G_EXC_ERROR THEN

8889: END IF;
8890:
8891: EXCEPTION
8892:
8893: WHEN FND_API.G_EXC_ERROR THEN
8894:
8895: x_return_status := G_RET_ERROR;
8896: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
8897: p_count => x_error_count ,

Line 8901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8897: p_count => x_error_count ,
8898: p_data => x_error_msg
8899: );
8900:
8901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8902:
8903: x_return_status := G_RET_UNEXPECTED;
8904:
8905: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 9146: raise FND_API.G_EXC_ERROR;

9142: );
9143:
9144: if x_return_status <> G_RET_SUCCESS then
9145: IF x_return_status = G_RET_ERROR THEN
9146: raise FND_API.G_EXC_ERROR;
9147: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9148: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9149: END IF;
9150: end if;

Line 9148: raise FND_API.G_EXC_UNEXPECTED_ERROR;

9144: if x_return_status <> G_RET_SUCCESS then
9145: IF x_return_status = G_RET_ERROR THEN
9146: raise FND_API.G_EXC_ERROR;
9147: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9148: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9149: END IF;
9150: end if;
9151:
9152: IF p_move_txn_type IN (1,2) THEN -- Not undo/assembly return

Line 9230: raise FND_API.G_EXC_ERROR;

9226: x_error_count => x_error_count
9227: );
9228: if x_return_status <> G_RET_SUCCESS then
9229: IF x_return_status = G_RET_ERROR THEN
9230: raise FND_API.G_EXC_ERROR;
9231: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9233: END IF;
9234: end if;

Line 9232: raise FND_API.G_EXC_UNEXPECTED_ERROR;

9228: if x_return_status <> G_RET_SUCCESS then
9229: IF x_return_status = G_RET_ERROR THEN
9230: raise FND_API.G_EXC_ERROR;
9231: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9233: END IF;
9234: end if;
9235:
9236: IF p_move_txn_type IN (2,3) THEN -- Assembly return and completion transaction...

Line 9259: raise FND_API.G_EXC_ERROR;

9255: );
9256:
9257: if x_return_status <> G_RET_SUCCESS then
9258: IF x_return_status = G_RET_ERROR THEN
9259: raise FND_API.G_EXC_ERROR;
9260: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9261: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9262: END IF;
9263: end if;

Line 9261: raise FND_API.G_EXC_UNEXPECTED_ERROR;

9257: if x_return_status <> G_RET_SUCCESS then
9258: IF x_return_status = G_RET_ERROR THEN
9259: raise FND_API.G_EXC_ERROR;
9260: ELSIF x_return_status = G_RET_UNEXPECTED THEN
9261: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9262: END IF;
9263: end if;
9264: END IF;
9265:

Line 9279: WHEN FND_API.G_EXC_ERROR THEN

9275: END IF;
9276:
9277: EXCEPTION
9278:
9279: WHEN FND_API.G_EXC_ERROR THEN
9280:
9281: x_return_status := G_RET_ERROR;
9282: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
9283: p_count => x_error_count ,

Line 9287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9283: p_count => x_error_count ,
9284: p_data => x_error_msg
9285: );
9286:
9287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9288:
9289: x_return_status := G_RET_UNEXPECTED;
9290:
9291: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,