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.CSI_INV_TRXS_PKG dependencies on FND_MESSAGE

Line 738: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

734: debug('Serialized Item with In Inventory, Out of Service, Installed, In Process or In Service exists however the ownership_override_at_txn flag is set to N');
735: debug('The current owner party is not the Internal Party so we will NOT bring this back into inventory');
736: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
737:
738: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
739: fnd_message.set_token('STATUS',l_status);
740: l_error_message := fnd_message.get;
741: l_return_status := l_fnd_error;
742: RAISE fnd_api.g_exc_error;

Line 739: fnd_message.set_token('STATUS',l_status);

735: debug('The current owner party is not the Internal Party so we will NOT bring this back into inventory');
736: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
737:
738: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
739: fnd_message.set_token('STATUS',l_status);
740: l_error_message := fnd_message.get;
741: l_return_status := l_fnd_error;
742: RAISE fnd_api.g_exc_error;
743: ELSE

Line 740: l_error_message := fnd_message.get;

736: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
737:
738: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
739: fnd_message.set_token('STATUS',l_status);
740: l_error_message := fnd_message.get;
741: l_return_status := l_fnd_error;
742: RAISE fnd_api.g_exc_error;
743: ELSE
744: l_party_tbl.delete;

Line 804: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

800: ELSE
801: l_status := 'In Inventory, Out of Service, Out of Enterprise, In Relationship, Installed, In Service or In Process';
802: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
803: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
804: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
805: fnd_message.set_token('STATUS',l_status);
806: l_error_message := fnd_message.get;
807: l_return_status := l_fnd_error;
808: RAISE fnd_api.g_exc_error;

Line 805: fnd_message.set_token('STATUS',l_status);

801: l_status := 'In Inventory, Out of Service, Out of Enterprise, In Relationship, Installed, In Service or In Process';
802: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
803: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
804: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
805: fnd_message.set_token('STATUS',l_status);
806: l_error_message := fnd_message.get;
807: l_return_status := l_fnd_error;
808: RAISE fnd_api.g_exc_error;
809: END IF;

Line 806: l_error_message := fnd_message.get;

802: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
803: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
804: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
805: fnd_message.set_token('STATUS',l_status);
806: l_error_message := fnd_message.get;
807: l_return_status := l_fnd_error;
808: RAISE fnd_api.g_exc_error;
809: END IF;
810: ELSE

Line 814: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

810: ELSE
811: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
812: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
813: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
814: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
815: fnd_message.set_token('STATUS',l_status);
816: l_error_message := fnd_message.get;
817: l_return_status := l_fnd_error;
818: RAISE fnd_api.g_exc_error;

Line 815: fnd_message.set_token('STATUS',l_status);

811: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
812: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
813: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
814: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
815: fnd_message.set_token('STATUS',l_status);
816: l_error_message := fnd_message.get;
817: l_return_status := l_fnd_error;
818: RAISE fnd_api.g_exc_error;
819: END IF;

Line 816: l_error_message := fnd_message.get;

812: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
813: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
814: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
815: fnd_message.set_token('STATUS',l_status);
816: l_error_message := fnd_message.get;
817: l_return_status := l_fnd_error;
818: RAISE fnd_api.g_exc_error;
819: END IF;
820: ELSE -- No API Records so create a new serialized record

Line 1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

1075:
1076: ELSIF l_src_instance_header_tbl.count > 1 THEN
1077: -- Multiple Instances were found so throw error
1078: debug('Multiple Instances were Found in Install Base Base-20');
1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

1076: ELSIF l_src_instance_header_tbl.count > 1 THEN
1077: -- Multiple Instances were found so throw error
1078: debug('Multiple Instances were Found in Install Base Base-20');
1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1084: l_error_message := fnd_message.get;

Line 1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

1077: -- Multiple Instances were found so throw error
1078: debug('Multiple Instances were Found in Install Base Base-20');
1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1084: l_error_message := fnd_message.get;
1085: RAISE fnd_api.g_exc_error;

Line 1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

1078: debug('Multiple Instances were Found in Install Base Base-20');
1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1084: l_error_message := fnd_message.get;
1085: RAISE fnd_api.g_exc_error;
1086:

Line 1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

1079: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1084: l_error_message := fnd_message.get;
1085: RAISE fnd_api.g_exc_error;
1086:
1087: END IF; -- End of Source Record If

Line 1084: l_error_message := fnd_message.get;

1080: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1081: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1082: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1083: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1084: l_error_message := fnd_message.get;
1085: RAISE fnd_api.g_exc_error;
1086:
1087: END IF; -- End of Source Record If
1088: END IF; -- End of Serialized Item If

Line 1125: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

1121: WHEN others THEN
1122: l_sql_error := SQLERRM;
1123: debug('You have encountered a "others" exception');
1124: debug('SQL Error: '||l_sql_error);
1125: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1126: fnd_message.set_token('API_NAME',l_api_name);
1127: fnd_message.set_token('SQL_ERROR',SQLERRM);
1128: x_return_status := l_fnd_unexpected;
1129:

Line 1126: fnd_message.set_token('API_NAME',l_api_name);

1122: l_sql_error := SQLERRM;
1123: debug('You have encountered a "others" exception');
1124: debug('SQL Error: '||l_sql_error);
1125: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1126: fnd_message.set_token('API_NAME',l_api_name);
1127: fnd_message.set_token('SQL_ERROR',SQLERRM);
1128: x_return_status := l_fnd_unexpected;
1129:
1130: IF l_mtl_item_tbl.count > 0 THEN

Line 1127: fnd_message.set_token('SQL_ERROR',SQLERRM);

1123: debug('You have encountered a "others" exception');
1124: debug('SQL Error: '||l_sql_error);
1125: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1126: fnd_message.set_token('API_NAME',l_api_name);
1127: fnd_message.set_token('SQL_ERROR',SQLERRM);
1128: x_return_status := l_fnd_unexpected;
1129:
1130: IF l_mtl_item_tbl.count > 0 THEN
1131: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 1143: x_trx_error_rec.error_text := fnd_message.get;

1139: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
1140: x_trx_error_rec.transaction_error_date := l_sysdate ;
1141: END IF;
1142:
1143: x_trx_error_rec.error_text := fnd_message.get;
1144: x_trx_error_rec.transaction_id := NULL;
1145: x_trx_error_rec.source_type := 'CSIMSRCV';
1146: x_trx_error_rec.source_id := p_transaction_id;
1147: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 1817: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

1813: l_status := 'In Inventory, Out of Service, Installed, In Process or In Service ';
1814: debug('Serialized Item with In Inventory, Out of Service, Installed, In Process or In Service exists however the ownership_override_at_txn flag is set to N');
1815: debug('The current owner party is not the Internal Party so we will NOT bring this back into inventory');
1816: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1817: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1818: fnd_message.set_token('STATUS',l_status);
1819: l_error_message := fnd_message.get;
1820: l_return_status := l_fnd_error;
1821: RAISE fnd_api.g_exc_error;

Line 1818: fnd_message.set_token('STATUS',l_status);

1814: debug('Serialized Item with In Inventory, Out of Service, Installed, In Process or In Service exists however the ownership_override_at_txn flag is set to N');
1815: debug('The current owner party is not the Internal Party so we will NOT bring this back into inventory');
1816: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1817: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1818: fnd_message.set_token('STATUS',l_status);
1819: l_error_message := fnd_message.get;
1820: l_return_status := l_fnd_error;
1821: RAISE fnd_api.g_exc_error;
1822: ELSE

Line 1819: l_error_message := fnd_message.get;

1815: debug('The current owner party is not the Internal Party so we will NOT bring this back into inventory');
1816: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1817: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1818: fnd_message.set_token('STATUS',l_status);
1819: l_error_message := fnd_message.get;
1820: l_return_status := l_fnd_error;
1821: RAISE fnd_api.g_exc_error;
1822: ELSE
1823: l_party_tbl.delete;

Line 1882: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

1878: ELSE
1879: l_status := 'In Inventory, Out of Service, Out of Enterprise, In Relationship, Installed, In Service or In Process';
1880: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
1881: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1882: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1883: fnd_message.set_token('STATUS',l_status);
1884: l_error_message := fnd_message.get;
1885: l_return_status := l_fnd_error;
1886: RAISE fnd_api.g_exc_error;

Line 1883: fnd_message.set_token('STATUS',l_status);

1879: l_status := 'In Inventory, Out of Service, Out of Enterprise, In Relationship, Installed, In Service or In Process';
1880: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
1881: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1882: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1883: fnd_message.set_token('STATUS',l_status);
1884: l_error_message := fnd_message.get;
1885: l_return_status := l_fnd_error;
1886: RAISE fnd_api.g_exc_error;
1887: END IF;

Line 1884: l_error_message := fnd_message.get;

1880: debug('Serialized Item with Out of Enterprise or In Relationship exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');
1881: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1882: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1883: fnd_message.set_token('STATUS',l_status);
1884: l_error_message := fnd_message.get;
1885: l_return_status := l_fnd_error;
1886: RAISE fnd_api.g_exc_error;
1887: END IF;
1888: ELSE

Line 1892: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

1888: ELSE
1889: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
1890: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
1891: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1892: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1893: fnd_message.set_token('STATUS',l_status);
1894: l_error_message := fnd_message.get;
1895: l_return_status := l_fnd_error;
1896: RAISE fnd_api.g_exc_error;

Line 1893: fnd_message.set_token('STATUS',l_status);

1889: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
1890: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
1891: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1892: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1893: fnd_message.set_token('STATUS',l_status);
1894: l_error_message := fnd_message.get;
1895: l_return_status := l_fnd_error;
1896: RAISE fnd_api.g_exc_error;
1897: END IF; -- Usage IF

Line 1894: l_error_message := fnd_message.get;

1890: debug('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
1891: debug('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1892: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1893: fnd_message.set_token('STATUS',l_status);
1894: l_error_message := fnd_message.get;
1895: l_return_status := l_fnd_error;
1896: RAISE fnd_api.g_exc_error;
1897: END IF; -- Usage IF
1898:

Line 2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

2085: ELSIF l_src_instance_header_tbl.count > 1 THEN -- Records Found
2086: -- Multiple Instances were found so throw error
2087: debug('Multiple Instances were Found in Install Base
2088: Base-21');
2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

2086: -- Multiple Instances were found so throw error
2087: debug('Multiple Instances were Found in Install Base
2088: Base-21');
2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2094: l_error_message := fnd_message.get;

Line 2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

2087: debug('Multiple Instances were Found in Install Base
2088: Base-21');
2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2094: l_error_message := fnd_message.get;
2095: RAISE fnd_api.g_exc_error;

Line 2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

2088: Base-21');
2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2094: l_error_message := fnd_message.get;
2095: RAISE fnd_api.g_exc_error;
2096: END IF; -- End of Source Record If

Line 2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

2089: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2094: l_error_message := fnd_message.get;
2095: RAISE fnd_api.g_exc_error;
2096: END IF; -- End of Source Record If
2097: END IF; -- End of Serial Number if

Line 2094: l_error_message := fnd_message.get;

2090: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2091: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2092: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2093: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2094: l_error_message := fnd_message.get;
2095: RAISE fnd_api.g_exc_error;
2096: END IF; -- End of Source Record If
2097: END IF; -- End of Serial Number if
2098: END LOOP; -- End of For Loop

Line 2134: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

2130: WHEN others THEN
2131: l_sql_error := SQLERRM;
2132: debug('You have encountered a "others" exception');
2133: debug('SQL Error: '||l_sql_error);
2134: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2135: fnd_message.set_token('API_NAME',l_api_name);
2136: fnd_message.set_token('SQL_ERROR',SQLERRM);
2137: x_return_status := l_fnd_unexpected;
2138:

Line 2135: fnd_message.set_token('API_NAME',l_api_name);

2131: l_sql_error := SQLERRM;
2132: debug('You have encountered a "others" exception');
2133: debug('SQL Error: '||l_sql_error);
2134: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2135: fnd_message.set_token('API_NAME',l_api_name);
2136: fnd_message.set_token('SQL_ERROR',SQLERRM);
2137: x_return_status := l_fnd_unexpected;
2138:
2139: IF l_mtl_item_tbl.count > 0 THEN

Line 2136: fnd_message.set_token('SQL_ERROR',SQLERRM);

2132: debug('You have encountered a "others" exception');
2133: debug('SQL Error: '||l_sql_error);
2134: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2135: fnd_message.set_token('API_NAME',l_api_name);
2136: fnd_message.set_token('SQL_ERROR',SQLERRM);
2137: x_return_status := l_fnd_unexpected;
2138:
2139: IF l_mtl_item_tbl.count > 0 THEN
2140: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 2152: x_trx_error_rec.error_text := fnd_message.get;

2148: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
2149: x_trx_error_rec.transaction_error_date := l_sysdate ;
2150: END IF;
2151:
2152: x_trx_error_rec.error_text := fnd_message.get;
2153: x_trx_error_rec.transaction_id := NULL;
2154: x_trx_error_rec.source_type := 'CSIPOINV';
2155: x_trx_error_rec.source_id := p_transaction_id;
2156: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 2653: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');

2649: END IF;
2650:
2651: ELSE -- No Records were found and Neg Qtys Not Allowed
2652: debug('No Records were found in Install Base and Neg Qtys not allowed to error');
2653: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2654: l_error_message := fnd_message.get;
2655: RAISE fnd_api.g_exc_error;
2656:
2657: END IF; -- Neg Qty IF

Line 2654: l_error_message := fnd_message.get;

2650:
2651: ELSE -- No Records were found and Neg Qtys Not Allowed
2652: debug('No Records were found in Install Base and Neg Qtys not allowed to error');
2653: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2654: l_error_message := fnd_message.get;
2655: RAISE fnd_api.g_exc_error;
2656:
2657: END IF; -- Neg Qty IF
2658:

Line 2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

2796:
2797: ELSIF l_src_instance_header_tbl.count > 1 THEN
2798: -- Multiple Instances were found so throw error
2799: debug('Multiple Instances were Found in Install Base-30');
2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

2797: ELSIF l_src_instance_header_tbl.count > 1 THEN
2798: -- Multiple Instances were found so throw error
2799: debug('Multiple Instances were Found in Install Base-30');
2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2805: l_error_message := fnd_message.get;

Line 2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

2798: -- Multiple Instances were found so throw error
2799: debug('Multiple Instances were Found in Install Base-30');
2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2805: l_error_message := fnd_message.get;
2806: RAISE fnd_api.g_exc_error;

Line 2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

2799: debug('Multiple Instances were Found in Install Base-30');
2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2805: l_error_message := fnd_message.get;
2806: RAISE fnd_api.g_exc_error;
2807:

Line 2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

2800: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2805: l_error_message := fnd_message.get;
2806: RAISE fnd_api.g_exc_error;
2807:
2808: ELSIF l_src_instance_header_tbl.count = 0 THEN

Line 2805: l_error_message := fnd_message.get;

2801: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2802: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2803: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2804: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2805: l_error_message := fnd_message.get;
2806: RAISE fnd_api.g_exc_error;
2807:
2808: ELSIF l_src_instance_header_tbl.count = 0 THEN
2809: debug('No Records were found in Install Base');

Line 2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

2806: RAISE fnd_api.g_exc_error;
2807:
2808: ELSIF l_src_instance_header_tbl.count = 0 THEN
2809: debug('No Records were found in Install Base');
2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2814: l_error_message := fnd_message.get;

Line 2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

2807:
2808: ELSIF l_src_instance_header_tbl.count = 0 THEN
2809: debug('No Records were found in Install Base');
2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2814: l_error_message := fnd_message.get;
2815: RAISE fnd_api.g_exc_error;

Line 2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

2808: ELSIF l_src_instance_header_tbl.count = 0 THEN
2809: debug('No Records were found in Install Base');
2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2814: l_error_message := fnd_message.get;
2815: RAISE fnd_api.g_exc_error;
2816: END IF; -- End of Source Record IF

Line 2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

2809: debug('No Records were found in Install Base');
2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2814: l_error_message := fnd_message.get;
2815: RAISE fnd_api.g_exc_error;
2816: END IF; -- End of Source Record IF
2817:

Line 2814: l_error_message := fnd_message.get;

2810: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2811: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2812: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2813: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2814: l_error_message := fnd_message.get;
2815: RAISE fnd_api.g_exc_error;
2816: END IF; -- End of Source Record IF
2817:
2818: ELSIF l_mtl_item_tbl(j).transaction_type_id in (36,1005) AND l_serial_tagged = 2 THEN

Line 2890: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');

2886: END IF;
2887:
2888: ELSE -- No Records were found and Neg Qtys Not Allowed
2889: debug('No Records were found in Install Base and Neg Qtys not allowed to error');
2890: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2891: l_error_message := fnd_message.get;
2892: RAISE fnd_api.g_exc_error;
2893:
2894: END IF; -- Neg Qty IF

Line 2891: l_error_message := fnd_message.get;

2887:
2888: ELSE -- No Records were found and Neg Qtys Not Allowed
2889: debug('No Records were found in Install Base and Neg Qtys not allowed to error');
2890: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2891: l_error_message := fnd_message.get;
2892: RAISE fnd_api.g_exc_error;
2893:
2894: END IF; -- Neg Qty IF
2895:

Line 3165: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3161: WHEN others THEN
3162: l_sql_error := SQLERRM;
3163: debug('You have encountered a "others" exception');
3164: debug('SQL Error: '||l_sql_error);
3165: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3166: fnd_message.set_token('API_NAME',l_api_name);
3167: fnd_message.set_token('SQL_ERROR',SQLERRM);
3168: x_return_status := l_fnd_unexpected;
3169:

Line 3166: fnd_message.set_token('API_NAME',l_api_name);

3162: l_sql_error := SQLERRM;
3163: debug('You have encountered a "others" exception');
3164: debug('SQL Error: '||l_sql_error);
3165: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3166: fnd_message.set_token('API_NAME',l_api_name);
3167: fnd_message.set_token('SQL_ERROR',SQLERRM);
3168: x_return_status := l_fnd_unexpected;
3169:
3170: IF l_mtl_item_tbl.count > 0 THEN

Line 3167: fnd_message.set_token('SQL_ERROR',SQLERRM);

3163: debug('You have encountered a "others" exception');
3164: debug('SQL Error: '||l_sql_error);
3165: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3166: fnd_message.set_token('API_NAME',l_api_name);
3167: fnd_message.set_token('SQL_ERROR',SQLERRM);
3168: x_return_status := l_fnd_unexpected;
3169:
3170: IF l_mtl_item_tbl.count > 0 THEN
3171: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 3183: x_trx_error_rec.error_text := fnd_message.get;

3179: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
3180: x_trx_error_rec.transaction_error_date := l_sysdate ;
3181: END IF;
3182:
3183: x_trx_error_rec.error_text := fnd_message.get;
3184: x_trx_error_rec.transaction_id := NULL;
3185: x_trx_error_rec.source_type := 'CSIMSISU';
3186: x_trx_error_rec.source_id := p_transaction_id;
3187: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 3266: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3262: WHEN others THEN
3263: l_sql_error := SQLERRM;
3264: debug('You have encountered a "others" exception');
3265: debug('SQL Error: '||l_sql_error);
3266: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3267: fnd_message.set_token('API_NAME',l_api_name);
3268: fnd_message.set_token('SQL_ERROR',SQLERRM);
3269: x_return_status := l_fnd_unexpected;
3270: l_trx_error_rec.error_text := fnd_message.get;

Line 3267: fnd_message.set_token('API_NAME',l_api_name);

3263: l_sql_error := SQLERRM;
3264: debug('You have encountered a "others" exception');
3265: debug('SQL Error: '||l_sql_error);
3266: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3267: fnd_message.set_token('API_NAME',l_api_name);
3268: fnd_message.set_token('SQL_ERROR',SQLERRM);
3269: x_return_status := l_fnd_unexpected;
3270: l_trx_error_rec.error_text := fnd_message.get;
3271: l_trx_error_rec.transaction_id := NULL;

Line 3268: fnd_message.set_token('SQL_ERROR',SQLERRM);

3264: debug('You have encountered a "others" exception');
3265: debug('SQL Error: '||l_sql_error);
3266: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3267: fnd_message.set_token('API_NAME',l_api_name);
3268: fnd_message.set_token('SQL_ERROR',SQLERRM);
3269: x_return_status := l_fnd_unexpected;
3270: l_trx_error_rec.error_text := fnd_message.get;
3271: l_trx_error_rec.transaction_id := NULL;
3272: l_trx_error_rec.source_type := 'CSICYCNT';

Line 3270: l_trx_error_rec.error_text := fnd_message.get;

3266: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3267: fnd_message.set_token('API_NAME',l_api_name);
3268: fnd_message.set_token('SQL_ERROR',SQLERRM);
3269: x_return_status := l_fnd_unexpected;
3270: l_trx_error_rec.error_text := fnd_message.get;
3271: l_trx_error_rec.transaction_id := NULL;
3272: l_trx_error_rec.source_type := 'CSICYCNT';
3273: l_trx_error_rec.source_id := p_transaction_id;
3274: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 3353: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3349: WHEN others THEN
3350: l_sql_error := SQLERRM;
3351: debug('You have encountered a "others" exception');
3352: debug('SQL Error: '||l_sql_error);
3353: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3354: fnd_message.set_token('API_NAME',l_api_name);
3355: fnd_message.set_token('SQL_ERROR',SQLERRM);
3356: x_return_status := l_fnd_unexpected;
3357: l_trx_error_rec.error_text := fnd_message.get;

Line 3354: fnd_message.set_token('API_NAME',l_api_name);

3350: l_sql_error := SQLERRM;
3351: debug('You have encountered a "others" exception');
3352: debug('SQL Error: '||l_sql_error);
3353: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3354: fnd_message.set_token('API_NAME',l_api_name);
3355: fnd_message.set_token('SQL_ERROR',SQLERRM);
3356: x_return_status := l_fnd_unexpected;
3357: l_trx_error_rec.error_text := fnd_message.get;
3358: l_trx_error_rec.transaction_id := NULL;

Line 3355: fnd_message.set_token('SQL_ERROR',SQLERRM);

3351: debug('You have encountered a "others" exception');
3352: debug('SQL Error: '||l_sql_error);
3353: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3354: fnd_message.set_token('API_NAME',l_api_name);
3355: fnd_message.set_token('SQL_ERROR',SQLERRM);
3356: x_return_status := l_fnd_unexpected;
3357: l_trx_error_rec.error_text := fnd_message.get;
3358: l_trx_error_rec.transaction_id := NULL;
3359: l_trx_error_rec.source_type := 'CSIPHYIN';

Line 3357: l_trx_error_rec.error_text := fnd_message.get;

3353: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3354: fnd_message.set_token('API_NAME',l_api_name);
3355: fnd_message.set_token('SQL_ERROR',SQLERRM);
3356: x_return_status := l_fnd_unexpected;
3357: l_trx_error_rec.error_text := fnd_message.get;
3358: l_trx_error_rec.transaction_id := NULL;
3359: l_trx_error_rec.source_type := 'CSIPHYIN';
3360: l_trx_error_rec.source_id := p_transaction_id;
3361: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 3571: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');

3567: END IF;
3568:
3569: EXCEPTION
3570: WHEN NO_DATA_FOUND THEN
3571: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3572: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3573: x_error_message := fnd_message.get;
3574: x_return_status := l_fnd_error;
3575:

Line 3572: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);

3568:
3569: EXCEPTION
3570: WHEN NO_DATA_FOUND THEN
3571: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3572: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3573: x_error_message := fnd_message.get;
3574: x_return_status := l_fnd_error;
3575:
3576: WHEN others THEN

Line 3573: x_error_message := fnd_message.get;

3569: EXCEPTION
3570: WHEN NO_DATA_FOUND THEN
3571: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3572: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3573: x_error_message := fnd_message.get;
3574: x_return_status := l_fnd_error;
3575:
3576: WHEN others THEN
3577: l_sql_error := SQLERRM;

Line 3580: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3576: WHEN others THEN
3577: l_sql_error := SQLERRM;
3578: debug('You have encountered a "others" exception');
3579: debug('SQL Error: '||l_sql_error);
3580: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3581: fnd_message.set_token('API_NAME',l_api_name);
3582: fnd_message.set_token('SQL_ERROR',SQLERRM);
3583: x_error_message := fnd_message.get;
3584: x_return_status := l_fnd_unexpected;

Line 3581: fnd_message.set_token('API_NAME',l_api_name);

3577: l_sql_error := SQLERRM;
3578: debug('You have encountered a "others" exception');
3579: debug('SQL Error: '||l_sql_error);
3580: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3581: fnd_message.set_token('API_NAME',l_api_name);
3582: fnd_message.set_token('SQL_ERROR',SQLERRM);
3583: x_error_message := fnd_message.get;
3584: x_return_status := l_fnd_unexpected;
3585: END get_rtv_transaction_recs;

Line 3582: fnd_message.set_token('SQL_ERROR',SQLERRM);

3578: debug('You have encountered a "others" exception');
3579: debug('SQL Error: '||l_sql_error);
3580: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3581: fnd_message.set_token('API_NAME',l_api_name);
3582: fnd_message.set_token('SQL_ERROR',SQLERRM);
3583: x_error_message := fnd_message.get;
3584: x_return_status := l_fnd_unexpected;
3585: END get_rtv_transaction_recs;
3586:

Line 3583: x_error_message := fnd_message.get;

3579: debug('SQL Error: '||l_sql_error);
3580: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3581: fnd_message.set_token('API_NAME',l_api_name);
3582: fnd_message.set_token('SQL_ERROR',SQLERRM);
3583: x_error_message := fnd_message.get;
3584: x_return_status := l_fnd_unexpected;
3585: END get_rtv_transaction_recs;
3586:
3587: PROCEDURE get_transaction_recs(p_transaction_id IN NUMBER,

Line 3794: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');

3790: END IF;
3791:
3792: EXCEPTION
3793: WHEN NO_DATA_FOUND THEN
3794: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3795: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3796: x_error_message := fnd_message.get;
3797: x_return_status := l_fnd_error;
3798:

Line 3795: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);

3791:
3792: EXCEPTION
3793: WHEN NO_DATA_FOUND THEN
3794: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3795: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3796: x_error_message := fnd_message.get;
3797: x_return_status := l_fnd_error;
3798:
3799: WHEN others THEN

Line 3796: x_error_message := fnd_message.get;

3792: EXCEPTION
3793: WHEN NO_DATA_FOUND THEN
3794: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
3795: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
3796: x_error_message := fnd_message.get;
3797: x_return_status := l_fnd_error;
3798:
3799: WHEN others THEN
3800: l_sql_error := SQLERRM;

Line 3803: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3799: WHEN others THEN
3800: l_sql_error := SQLERRM;
3801: debug('You have encountered a "others" exception');
3802: debug('SQL Error: '||l_sql_error);
3803: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3804: fnd_message.set_token('API_NAME',l_api_name);
3805: fnd_message.set_token('SQL_ERROR',SQLERRM);
3806: x_error_message := fnd_message.get;
3807: x_return_status := l_fnd_unexpected;

Line 3804: fnd_message.set_token('API_NAME',l_api_name);

3800: l_sql_error := SQLERRM;
3801: debug('You have encountered a "others" exception');
3802: debug('SQL Error: '||l_sql_error);
3803: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3804: fnd_message.set_token('API_NAME',l_api_name);
3805: fnd_message.set_token('SQL_ERROR',SQLERRM);
3806: x_error_message := fnd_message.get;
3807: x_return_status := l_fnd_unexpected;
3808: END get_transaction_recs;

Line 3805: fnd_message.set_token('SQL_ERROR',SQLERRM);

3801: debug('You have encountered a "others" exception');
3802: debug('SQL Error: '||l_sql_error);
3803: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3804: fnd_message.set_token('API_NAME',l_api_name);
3805: fnd_message.set_token('SQL_ERROR',SQLERRM);
3806: x_error_message := fnd_message.get;
3807: x_return_status := l_fnd_unexpected;
3808: END get_transaction_recs;
3809:

Line 3806: x_error_message := fnd_message.get;

3802: debug('SQL Error: '||l_sql_error);
3803: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3804: fnd_message.set_token('API_NAME',l_api_name);
3805: fnd_message.set_token('SQL_ERROR',SQLERRM);
3806: x_error_message := fnd_message.get;
3807: x_return_status := l_fnd_unexpected;
3808: END get_transaction_recs;
3809:
3810: PROCEDURE decode_message (p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,

Line 3830: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');

3826: END IF;
3827:
3828: EXCEPTION
3829: WHEN fnd_api.g_exc_error THEN
3830: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
3831: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
3832: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
3833: x_error_message := fnd_message.get;
3834: x_return_status := l_fnd_unexpected;

Line 3831: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);

3827:
3828: EXCEPTION
3829: WHEN fnd_api.g_exc_error THEN
3830: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
3831: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
3832: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
3833: x_error_message := fnd_message.get;
3834: x_return_status := l_fnd_unexpected;
3835:

Line 3832: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);

3828: EXCEPTION
3829: WHEN fnd_api.g_exc_error THEN
3830: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
3831: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
3832: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
3833: x_error_message := fnd_message.get;
3834: x_return_status := l_fnd_unexpected;
3835:
3836: WHEN others THEN

Line 3833: x_error_message := fnd_message.get;

3829: WHEN fnd_api.g_exc_error THEN
3830: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');
3831: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
3832: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
3833: x_error_message := fnd_message.get;
3834: x_return_status := l_fnd_unexpected;
3835:
3836: WHEN others THEN
3837: l_sql_error := SQLERRM;

Line 3840: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3836: WHEN others THEN
3837: l_sql_error := SQLERRM;
3838: debug('You have encountered a "others" exception');
3839: debug('SQL Error: '||l_sql_error);
3840: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3841: fnd_message.set_token('API_NAME',l_api_name);
3842: fnd_message.set_token('SQL_ERROR',SQLERRM);
3843: x_error_message := fnd_message.get;
3844: x_return_status := l_fnd_unexpected;

Line 3841: fnd_message.set_token('API_NAME',l_api_name);

3837: l_sql_error := SQLERRM;
3838: debug('You have encountered a "others" exception');
3839: debug('SQL Error: '||l_sql_error);
3840: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3841: fnd_message.set_token('API_NAME',l_api_name);
3842: fnd_message.set_token('SQL_ERROR',SQLERRM);
3843: x_error_message := fnd_message.get;
3844: x_return_status := l_fnd_unexpected;
3845: END decode_message;

Line 3842: fnd_message.set_token('SQL_ERROR',SQLERRM);

3838: debug('You have encountered a "others" exception');
3839: debug('SQL Error: '||l_sql_error);
3840: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3841: fnd_message.set_token('API_NAME',l_api_name);
3842: fnd_message.set_token('SQL_ERROR',SQLERRM);
3843: x_error_message := fnd_message.get;
3844: x_return_status := l_fnd_unexpected;
3845: END decode_message;
3846:

Line 3843: x_error_message := fnd_message.get;

3839: debug('SQL Error: '||l_sql_error);
3840: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3841: fnd_message.set_token('API_NAME',l_api_name);
3842: fnd_message.set_token('SQL_ERROR',SQLERRM);
3843: x_error_message := fnd_message.get;
3844: x_return_status := l_fnd_unexpected;
3845: END decode_message;
3846:
3847: PROCEDURE get_asset_creation_code(

Line 3891: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3887: END IF;
3888: CLOSE Asset_CC_Cur;
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3892: fnd_message.set_token('API_NAME', l_api_name);
3893: fnd_message.set_token('SQL_ERROR', sqlerrm);
3894: l_err_text := fnd_message.get;
3895: raise;

Line 3892: fnd_message.set_token('API_NAME', l_api_name);

3888: CLOSE Asset_CC_Cur;
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3892: fnd_message.set_token('API_NAME', l_api_name);
3893: fnd_message.set_token('SQL_ERROR', sqlerrm);
3894: l_err_text := fnd_message.get;
3895: raise;
3896: END get_asset_creation_code;

Line 3893: fnd_message.set_token('SQL_ERROR', sqlerrm);

3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3892: fnd_message.set_token('API_NAME', l_api_name);
3893: fnd_message.set_token('SQL_ERROR', sqlerrm);
3894: l_err_text := fnd_message.get;
3895: raise;
3896: END get_asset_creation_code;
3897:

Line 3894: l_err_text := fnd_message.get;

3890: WHEN OTHERS THEN
3891: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3892: fnd_message.set_token('API_NAME', l_api_name);
3893: fnd_message.set_token('SQL_ERROR', sqlerrm);
3894: l_err_text := fnd_message.get;
3895: raise;
3896: END get_asset_creation_code;
3897:
3898: PROCEDURE Check_item_Trackable(

Line 3931: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3927: p_nl_trackable_flag := 'FALSE';
3928: END IF;
3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3932: fnd_message.set_token('API_NAME', l_api_name);
3933: fnd_message.set_token('SQL_ERROR', sqlerrm);
3934: l_err_text := fnd_message.get;
3935: END check_item_trackable;

Line 3932: fnd_message.set_token('API_NAME', l_api_name);

3928: END IF;
3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3932: fnd_message.set_token('API_NAME', l_api_name);
3933: fnd_message.set_token('SQL_ERROR', sqlerrm);
3934: l_err_text := fnd_message.get;
3935: END check_item_trackable;
3936:

Line 3933: fnd_message.set_token('SQL_ERROR', sqlerrm);

3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3932: fnd_message.set_token('API_NAME', l_api_name);
3933: fnd_message.set_token('SQL_ERROR', sqlerrm);
3934: l_err_text := fnd_message.get;
3935: END check_item_trackable;
3936:
3937: PROCEDURE check_depreciable(

Line 3934: l_err_text := fnd_message.get;

3930: WHEN OTHERS THEN
3931: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3932: fnd_message.set_token('API_NAME', l_api_name);
3933: fnd_message.set_token('SQL_ERROR', sqlerrm);
3934: l_err_text := fnd_message.get;
3935: END check_item_trackable;
3936:
3937: PROCEDURE check_depreciable(
3938: p_inventory_item_id IN NUMBER,

Line 3963: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3959: p_depreciable := 'Y';
3960: END IF;
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3964: fnd_message.set_token('API_NAME', l_api_name);
3965: fnd_message.set_token('SQL_ERROR', sqlerrm);
3966: l_err_text := fnd_message.get;
3967: raise;

Line 3964: fnd_message.set_token('API_NAME', l_api_name);

3960: END IF;
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3964: fnd_message.set_token('API_NAME', l_api_name);
3965: fnd_message.set_token('SQL_ERROR', sqlerrm);
3966: l_err_text := fnd_message.get;
3967: raise;
3968: END check_depreciable;

Line 3965: fnd_message.set_token('SQL_ERROR', sqlerrm);

3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3964: fnd_message.set_token('API_NAME', l_api_name);
3965: fnd_message.set_token('SQL_ERROR', sqlerrm);
3966: l_err_text := fnd_message.get;
3967: raise;
3968: END check_depreciable;
3969:

Line 3966: l_err_text := fnd_message.get;

3962: WHEN OTHERS THEN
3963: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3964: fnd_message.set_token('API_NAME', l_api_name);
3965: fnd_message.set_token('SQL_ERROR', sqlerrm);
3966: l_err_text := fnd_message.get;
3967: raise;
3968: END check_depreciable;
3969:
3970: FUNCTION is_csi_installed RETURN VARCHAR2

Line 4060: fnd_message.set_name('CSI','CSI_MSTR_ORG_NOTFOUND');

4056: END IF;
4057:
4058: EXCEPTION
4059: WHEN e_procedure_error THEN
4060: fnd_message.set_name('CSI','CSI_MSTR_ORG_NOTFOUND');
4061: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
4062: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
4063: x_error_message := fnd_message.get;
4064: x_return_status := l_fnd_error;

Line 4061: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);

4057:
4058: EXCEPTION
4059: WHEN e_procedure_error THEN
4060: fnd_message.set_name('CSI','CSI_MSTR_ORG_NOTFOUND');
4061: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
4062: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
4063: x_error_message := fnd_message.get;
4064: x_return_status := l_fnd_error;
4065:

Line 4062: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);

4058: EXCEPTION
4059: WHEN e_procedure_error THEN
4060: fnd_message.set_name('CSI','CSI_MSTR_ORG_NOTFOUND');
4061: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
4062: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
4063: x_error_message := fnd_message.get;
4064: x_return_status := l_fnd_error;
4065:
4066: WHEN others THEN

Line 4063: x_error_message := fnd_message.get;

4059: WHEN e_procedure_error THEN
4060: fnd_message.set_name('CSI','CSI_MSTR_ORG_NOTFOUND');
4061: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
4062: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
4063: x_error_message := fnd_message.get;
4064: x_return_status := l_fnd_error;
4065:
4066: WHEN others THEN
4067: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 4067: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

4063: x_error_message := fnd_message.get;
4064: x_return_status := l_fnd_error;
4065:
4066: WHEN others THEN
4067: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4068: fnd_message.set_token('SQL_ERROR',SQLERRM);
4069: x_error_message := fnd_message.get;
4070: x_return_status := l_fnd_unexpected;
4071: END get_master_organization;

Line 4068: fnd_message.set_token('SQL_ERROR',SQLERRM);

4064: x_return_status := l_fnd_error;
4065:
4066: WHEN others THEN
4067: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4068: fnd_message.set_token('SQL_ERROR',SQLERRM);
4069: x_error_message := fnd_message.get;
4070: x_return_status := l_fnd_unexpected;
4071: END get_master_organization;
4072:

Line 4069: x_error_message := fnd_message.get;

4065:
4066: WHEN others THEN
4067: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4068: fnd_message.set_token('SQL_ERROR',SQLERRM);
4069: x_error_message := fnd_message.get;
4070: x_return_status := l_fnd_unexpected;
4071: END get_master_organization;
4072:
4073: PROCEDURE build_error_string (