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

Line 420: x_return_status := FND_API.G_RET_STS_SUCCESS;

416:
417: SAVEPOINT InsertLot_sv;
418:
419: -- Initialize return status to success
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421:
422: l_progress := '10';
423:
424: OPEN c_rcv_txn_interface_rec;

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

428: CLOSE c_rcv_txn_interface_rec;
429: IF (l_debug = 1) THEN
430: print_debug('No record exists in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_ID', 4);
431: END IF;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435: CLOSE c_rcv_txn_interface_rec;
436:

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

529:
530: if(l_lot_control_code = 1) then
531: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
532: fnd_msg_pub.add;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: if(l_lot_control_code = 1) then
531: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
532: fnd_msg_pub.add;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN
538: fnd_message.set_name('INV','INV_INVALID_ITEM');

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN
538: fnd_message.set_name('INV','INV_INVALID_ITEM');
539: fnd_msg_pub.add;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END;
543:
544: l_progress := '40.1';

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: WHEN NO_DATA_FOUND THEN
538: fnd_message.set_name('INV','INV_INVALID_ITEM');
539: fnd_msg_pub.add;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END;
543:
544: l_progress := '40.1';
545:

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557:
558: if(l_lotcount > 0) then
559: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
560: fnd_msg_pub.add;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: end if;
564: end if;
565:

Line 562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

558: if(l_lotcount > 0) then
559: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
560: fnd_msg_pub.add;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: end if;
564: end if;
565:
566: SELECT count(1)

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: l_loginid := fnd_global.login_id;
576: else
577: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
578: fnd_msg_pub.add;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: -- Stop PRocessing HERE
582: end if;
583:

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576: else
577: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
578: fnd_msg_pub.add;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: -- Stop PRocessing HERE
582: end if;
583:
584:

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599: FROM DUAL;
600: elsif(l_shelf_life_code = 4) then
601: fnd_message.set_name('INV','INV_LOT_EXPREQD');
602: fnd_msg_pub.add;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: end if;
606: end if;
607:

Line 604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

600: elsif(l_shelf_life_code = 4) then
601: fnd_message.set_name('INV','INV_LOT_EXPREQD');
602: fnd_msg_pub.add;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: end if;
606: end if;
607:
608: --Get All The Not Null vAlues and put in a temp area

Line 633: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

629: p_organization_id => l_organization_id,
630: p_lot_serial_number => l_lot_number,
631: p_attributes => l_attributes_in);
632:
633: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
634: x_return_status := l_return_status;
635: raise FND_API.G_EXC_UNEXPECTED_ERROR;
636: end if;
637:

Line 635: raise FND_API.G_EXC_UNEXPECTED_ERROR;

631: p_attributes => l_attributes_in);
632:
633: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
634: x_return_status := l_return_status;
635: raise FND_API.G_EXC_UNEXPECTED_ERROR;
636: end if;
637:
638: if( l_attributes_default_count > 0 ) then
639: for i in 1..l_attributes_default_count LOOP

Line 665: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

661: , x_serial_status_enabled => l_serial_status_enabled
662: , x_default_serial_status_id => l_default_serial_status_id);
663:
664:
665: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
666: x_return_status := l_return_status;
667: raise FND_API.G_EXC_UNEXPECTED_ERROR;
668: end if;
669:

Line 667: raise FND_API.G_EXC_UNEXPECTED_ERROR;

663:
664:
665: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
666: x_return_status := l_return_status;
667: raise FND_API.G_EXC_UNEXPECTED_ERROR;
668: end if;
669:
670: if(NVL(l_lot_status_enabled, 'Y') = 'Y') then
671: -- For consistency, fill after converting to 'char'

Line 841: x_return_status := FND_API.G_RET_STS_ERROR ;

837: IF (l_debug = 1) THEN
838: print_debug('API for validation is failure' , 4);
839: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
840: END IF;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: x_msg_data := fnd_flex_descval.error_message;
843: raise FND_API.G_EXC_ERROR;
844: end if;
845:

Line 843: raise FND_API.G_EXC_ERROR;

839: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
840: END IF;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: x_msg_data := fnd_flex_descval.error_message;
843: raise FND_API.G_EXC_ERROR;
844: end if;
845:
846: l_progress := '100';
847: --

Line 1073: WHEN FND_API.g_exc_error THEN

1069: END IF;
1070:
1071:
1072: EXCEPTION
1073: WHEN FND_API.g_exc_error THEN
1074: ROLLBACK TO InsertLot_sv;
1075: IF (l_debug = 1) THEN
1076: print_debug('Process - expected error happened - l_progress : '||l_progress, 1);
1077: END IF;

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074: ROLLBACK TO InsertLot_sv;
1075: IF (l_debug = 1) THEN
1076: print_debug('Process - expected error happened - l_progress : '||l_progress, 1);
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );

Line 1084: WHEN FND_API.g_exc_unexpected_error THEN

1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083:
1084: WHEN FND_API.g_exc_unexpected_error THEN
1085: ROLLBACK TO InsertLot_sv;
1086: IF (l_debug = 1) THEN
1087: print_debug('Process - unexpected error happened - l_progress : '||l_progress, 1);
1088: END IF;

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1085: ROLLBACK TO InsertLot_sv;
1086: IF (l_debug = 1) THEN
1087: print_debug('Process - unexpected error happened - l_progress : '||l_progress, 1);
1088: END IF;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: FND_MSG_PUB.Count_And_Get
1091: (p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1101: IF (l_debug = 1) THEN
1102: print_debug('SQL Error : '||SQLERRM(SQLCODE)||' SQL Error code : '||SQLCODE, 1);
1103: END IF;
1104: END IF;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: END;
1107:
1108:
1109: procedure populateSerAttributesColumn IS

Line 1282: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1278:
1279: END;
1280:
1281: PROCEDURE insertSerial(
1282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1283: p_inventory_item_id IN NUMBER,
1284: p_organization_id IN NUMBER,
1285: p_serial_number IN VARCHAR2,
1286: p_initialization_date IN DATE,

Line 1454: x_return_status := FND_API.G_RET_STS_SUCCESS;

1450: IF (l_debug = 1) THEN
1451: print_debug('Inside Insert Serial ',4);
1452: END IF;
1453:
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455:
1456: -- Standard Start of API savepoint
1457: SAVEPOINT insertSerial_sv;
1458:

Line 1474: x_return_status := FND_API.G_RET_STS_ERROR;

1470:
1471: if(l_serial_control_code = 1) then
1472: fnd_message.set_name('INV','INV_NO_SERIAL_CONTROL');
1473: fnd_msg_pub.add;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: return;
1476: end if;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN

Line 1481: x_return_status := FND_API.G_RET_STS_ERROR;

1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN
1479: fnd_message.set_name('INV','INV_INVALID_ITEM');
1480: fnd_msg_pub.add;
1481: x_return_status := FND_API.G_RET_STS_ERROR;
1482: return;
1483: END;
1484:
1485: l_progress := '20';

Line 1594: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1590: IF (l_debug = 1) THEN
1591: print_debug('At Step = '|| l_progress,4);
1592: END IF;
1593:
1594: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1595: x_return_status := l_return_status;
1596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1597: end if;
1598:

Line 1596: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1592: END IF;
1593:
1594: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1595: x_return_status := l_return_status;
1596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1597: end if;
1598:
1599: if( l_attributes_default_count > 0 ) then
1600: for i in 1..l_attributes_default_count LOOP

Line 1631: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1627: , x_default_lot_status_id => l_default_lot_status_id
1628: , x_serial_status_enabled => l_serial_status_enabled
1629: , x_default_serial_status_id => l_default_serial_status_id);
1630:
1631: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1632: x_return_status := l_return_status;
1633: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1634: end if;
1635:

Line 1633: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1629: , x_default_serial_status_id => l_default_serial_status_id);
1630:
1631: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1632: x_return_status := l_return_status;
1633: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1634: end if;
1635:
1636: if (NVL(l_serial_status_enabled, 'Y') = 'Y') then
1637: l_status_id := l_default_serial_status_id;

Line 1818: x_return_status := FND_API.G_RET_STS_ERROR ;

1814: IF (l_debug = 1) THEN
1815: print_debug('API for validation is failure' , 4);
1816: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
1817: END IF;
1818: x_return_status := FND_API.G_RET_STS_ERROR ;
1819: x_msg_data := fnd_flex_descval.error_message;
1820: raise FND_API.G_EXC_ERROR;
1821: end if;
1822:

Line 1820: raise FND_API.G_EXC_ERROR;

1816: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
1817: END IF;
1818: x_return_status := FND_API.G_RET_STS_ERROR ;
1819: x_msg_data := fnd_flex_descval.error_message;
1820: raise FND_API.G_EXC_ERROR;
1821: end if;
1822:
1823: end if;
1824:

Line 2077: IF FND_API.To_Boolean( p_commit ) THEN

2073: l_progress := '130';
2074:
2075: -- End of API body.
2076: -- Standard check of p_commit.
2077: IF FND_API.To_Boolean( p_commit ) THEN
2078: COMMIT WORK;
2079: END IF;
2080:
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

2077: IF FND_API.To_Boolean( p_commit ) THEN
2078: COMMIT WORK;
2079: END IF;
2080:
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Standard call to get message count and if count is 1, get message info.
2084: FND_MSG_PUB.Count_And_Get
2085: ( p_encoded => FND_API.G_FALSE,

Line 2085: ( p_encoded => FND_API.G_FALSE,

2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Standard call to get message count and if count is 1, get message info.
2084: FND_MSG_PUB.Count_And_Get
2085: ( p_encoded => FND_API.G_FALSE,
2086: p_count => x_msg_count ,
2087: p_data => x_msg_data
2088: );
2089:

Line 2094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2090:
2091: EXCEPTION
2092: WHEN OTHERS THEN
2093: ROLLBACK TO insertSerial_sv;
2094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2095:
2096: IF SQLCODE IS NOT NULL THEN
2097: IF (l_debug = 1) THEN
2098: print_debug('SQL Error : '||SQLERRM(SQLCODE)||' SQL Error code : '||SQLCODE, 1);

Line 2103: ( p_encoded => FND_API.G_FALSE,

2099: END IF;
2100: END IF;
2101:
2102: FND_MSG_PUB.Count_And_Get
2103: ( p_encoded => FND_API.G_FALSE,
2104: p_count => x_msg_count ,
2105: p_data => x_msg_data
2106: );
2107:

Line 2113: (p_commit IN VARCHAR2 := FND_API.G_FALSE,

2109:
2110:
2111:
2112: PROCEDURE insert_range_serial
2113: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
2114: p_inventory_item_id IN NUMBER,
2115: p_organization_id IN NUMBER,
2116: p_from_serial_number IN VARCHAR2,
2117: p_to_serial_number IN VARCHAR2,

Line 2153: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2149: l_temp_prefix VARCHAR2(30);
2150: l_cur_serial_number VARCHAR2(30);
2151: l_cur_ser_number NUMBER;
2152: l_object_id NUMBER;
2153: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2154: l_msg_count NUMBER;
2155: l_msg_data VARCHAR2(2000);
2156: l_current_status NUMBER;
2157: l_group_mark_id NUMBER;

Line 2176: x_return_status := FND_API.G_RET_STS_SUCCESS;

2172: END IF;
2173:
2174: SAVEPOINT SP_insert_range_serial;
2175:
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177:
2178:
2179: -- get the number part of the from serial
2180: inv_validate.number_from_sequence(p_from_serial_number,

Line 2259: RAISE FND_API.G_EXC_ERROR;

2255: p_serial => l_cur_serial_number,
2256: x_proc_msg => l_msg_data) = 1 THEN
2257: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL_USED');
2258: FND_MSG_PUB.ADD;
2259: RAISE FND_API.G_EXC_ERROR;
2260: ELSE
2261: -- uniqueness check passed
2262: -- and it is not a pre-defined serial
2263:

Line 2300: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2296: x_return_status => l_return_status,
2297: x_msg_count => l_msg_count,
2298: x_msg_data => l_msg_data);
2299:
2300: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2301: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL');
2302: FND_MSG_PUB.ADD;
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: END IF;

Line 2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2299:
2300: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2301: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL');
2302: FND_MSG_PUB.ADD;
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: END IF;
2305: END IF;
2306: END IF;
2307: END LOOP;

Line 2309: x_return_status := FND_API.G_RET_STS_SUCCESS;

2305: END IF;
2306: END IF;
2307: END LOOP;
2308:
2309: x_return_status := FND_API.G_RET_STS_SUCCESS;
2310:
2311: -- End of API body
2312: -- Standard check of p_commit.
2313: IF FND_API.To_Boolean( p_commit ) THEN

Line 2313: IF FND_API.To_Boolean( p_commit ) THEN

2309: x_return_status := FND_API.G_RET_STS_SUCCESS;
2310:
2311: -- End of API body
2312: -- Standard check of p_commit.
2313: IF FND_API.To_Boolean( p_commit ) THEN
2314: COMMIT WORK;
2315: END IF;
2316:
2317: -- Standard call to get message count and if count is 1,

Line 2325: WHEN FND_API.G_EXC_ERROR THEN

2321: p_data => x_msg_data
2322: );
2323:
2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO SP_insert_range_serial;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: FND_MSG_PUB.Count_And_Get
2329: (p_count => x_msg_count,

Line 2327: x_return_status := FND_API.G_RET_STS_ERROR;

2323:
2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO SP_insert_range_serial;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: FND_MSG_PUB.Count_And_Get
2329: (p_count => x_msg_count,
2330: p_data => x_msg_data
2331: );

Line 2333: WHEN FND_API.g_exc_unexpected_error THEN

2329: (p_count => x_msg_count,
2330: p_data => x_msg_data
2331: );
2332:
2333: WHEN FND_API.g_exc_unexpected_error THEN
2334: ROLLBACK TO SP_insert_range_serial;
2335: x_return_status := FND_API.g_ret_sts_unexp_error;
2336: FND_MSG_PUB.Count_And_Get
2337: (p_count => x_msg_count,

Line 2335: x_return_status := FND_API.g_ret_sts_unexp_error;

2331: );
2332:
2333: WHEN FND_API.g_exc_unexpected_error THEN
2334: ROLLBACK TO SP_insert_range_serial;
2335: x_return_status := FND_API.g_ret_sts_unexp_error;
2336: FND_MSG_PUB.Count_And_Get
2337: (p_count => x_msg_count,
2338: p_data => x_msg_data
2339: );

Line 2343: x_return_status := FND_API.g_ret_sts_unexp_error;

2339: );
2340:
2341: WHEN OTHERS THEN
2342: ROLLBACK TO SP_insert_range_serial;
2343: x_return_status := FND_API.g_ret_sts_unexp_error;
2344: FND_MSG_PUB.Count_And_Get
2345: (p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );