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

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_MESSAGE

Line 302: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');

298:
299: IF c_get_param%NOTFOUND THEN
300: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
301:
302: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
303: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
304:
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);

Line 303: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));

299: IF c_get_param%NOTFOUND THEN
300: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
301:
302: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
303: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
304:
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);
307: END IF;

Line 445: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');

441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
442: END IF;
443: --
444: WHEN OTHERS THEN
445: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
446: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
447: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
448: FND_MESSAGE.Set_Token('ORA_TEXT','');
449: IF c_get_param%ISOPEN THEN

Line 446: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');

442: END IF;
443: --
444: WHEN OTHERS THEN
445: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
446: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
447: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
448: FND_MESSAGE.Set_Token('ORA_TEXT','');
449: IF c_get_param%ISOPEN THEN
450: CLOSE c_get_param;

Line 447: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

443: --
444: WHEN OTHERS THEN
445: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
446: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
447: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
448: FND_MESSAGE.Set_Token('ORA_TEXT','');
449: IF c_get_param%ISOPEN THEN
450: CLOSE c_get_param;
451: END IF;

Line 448: FND_MESSAGE.Set_Token('ORA_TEXT','');

444: WHEN OTHERS THEN
445: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
446: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
447: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
448: FND_MESSAGE.Set_Token('ORA_TEXT','');
449: IF c_get_param%ISOPEN THEN
450: CLOSE c_get_param;
451: END IF;
452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 656: FND_MESSAGE.Set_Name('WSH','WSH_PARAM_NOT_DEFINED');

652: OPEN c_get_global_param;
653: FETCH c_get_global_param
654: INTO l_param_info;
655: IF c_get_global_param%NOTFOUND THEN
656: FND_MESSAGE.Set_Name('WSH','WSH_PARAM_NOT_DEFINED');
657: RAISE NO_DATA_FOUND;
658: END IF;
659:
660: -- Insert cached info into PL/SQL table

Line 759: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');

755: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
756: END IF;
757: --
758: WHEN OTHERS THEN
759: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
760: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
761: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
762: FND_MESSAGE.Set_Token('ORA_TEXT','');
763: IF c_get_global_param%ISOPEN THEN

Line 760: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');

756: END IF;
757: --
758: WHEN OTHERS THEN
759: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
760: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
761: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
762: FND_MESSAGE.Set_Token('ORA_TEXT','');
763: IF c_get_global_param%ISOPEN THEN
764: CLOSE c_get_global_param;

Line 761: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

757: --
758: WHEN OTHERS THEN
759: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
760: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
761: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
762: FND_MESSAGE.Set_Token('ORA_TEXT','');
763: IF c_get_global_param%ISOPEN THEN
764: CLOSE c_get_global_param;
765: END IF;

Line 762: FND_MESSAGE.Set_Token('ORA_TEXT','');

758: WHEN OTHERS THEN
759: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
760: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
761: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
762: FND_MESSAGE.Set_Token('ORA_TEXT','');
763: IF c_get_global_param%ISOPEN THEN
764: CLOSE c_get_global_param;
765: END IF;
766: x_return_status := FND_API.G_RET_STS_ERROR;

Line 932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

928:
929: Exception
930: When others then
931: x_return_status := wsh_util_core.g_ret_sts_error;
932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
933: fnd_message.set_token('PACKAGE',l_module_name);
934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
935: fnd_message.set_token('ORA_TEXT',SQLERRM);
936: If l_debug_on then

Line 933: fnd_message.set_token('PACKAGE',l_module_name);

929: Exception
930: When others then
931: x_return_status := wsh_util_core.g_ret_sts_error;
932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
933: fnd_message.set_token('PACKAGE',l_module_name);
934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
935: fnd_message.set_token('ORA_TEXT',SQLERRM);
936: If l_debug_on then
937: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

930: When others then
931: x_return_status := wsh_util_core.g_ret_sts_error;
932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
933: fnd_message.set_token('PACKAGE',l_module_name);
934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
935: fnd_message.set_token('ORA_TEXT',SQLERRM);
936: If l_debug_on then
937: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
938: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);

Line 935: fnd_message.set_token('ORA_TEXT',SQLERRM);

931: x_return_status := wsh_util_core.g_ret_sts_error;
932: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
933: fnd_message.set_token('PACKAGE',l_module_name);
934: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
935: fnd_message.set_token('ORA_TEXT',SQLERRM);
936: If l_debug_on then
937: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
938: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
939: wsh_debug_sv.pop(l_module_name);

Line 1191: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1187: When others then
1188: If l_debug_on then
1189: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1190: End If;
1191: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1192: fnd_message.set_token('PACKAGE',l_module_name);
1193: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1194: fnd_message.set_token('ORA_TEXT',SQLERRM);
1195: raise handle_exception;

Line 1192: fnd_message.set_token('PACKAGE',l_module_name);

1188: If l_debug_on then
1189: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1190: End If;
1191: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1192: fnd_message.set_token('PACKAGE',l_module_name);
1193: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1194: fnd_message.set_token('ORA_TEXT',SQLERRM);
1195: raise handle_exception;
1196: End;

Line 1193: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1189: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1190: End If;
1191: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1192: fnd_message.set_token('PACKAGE',l_module_name);
1193: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1194: fnd_message.set_token('ORA_TEXT',SQLERRM);
1195: raise handle_exception;
1196: End;
1197: If l_debug_on then

Line 1194: fnd_message.set_token('ORA_TEXT',SQLERRM);

1190: End If;
1191: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1192: fnd_message.set_token('PACKAGE',l_module_name);
1193: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1194: fnd_message.set_token('ORA_TEXT',SQLERRM);
1195: raise handle_exception;
1196: End;
1197: If l_debug_on then
1198: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);

Line 1249: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1245: When others then
1246: If l_debug_on then
1247: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1248: End If;
1249: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1250: fnd_message.set_token('PACKAGE',l_module_name);
1251: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1252: fnd_message.set_token('ORA_TEXT',SQLERRM);
1253: Raise handle_exception;

Line 1250: fnd_message.set_token('PACKAGE',l_module_name);

1246: If l_debug_on then
1247: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1248: End If;
1249: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1250: fnd_message.set_token('PACKAGE',l_module_name);
1251: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1252: fnd_message.set_token('ORA_TEXT',SQLERRM);
1253: Raise handle_exception;
1254: End;

Line 1251: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1247: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1248: End If;
1249: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1250: fnd_message.set_token('PACKAGE',l_module_name);
1251: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1252: fnd_message.set_token('ORA_TEXT',SQLERRM);
1253: Raise handle_exception;
1254: End;
1255:

Line 1252: fnd_message.set_token('ORA_TEXT',SQLERRM);

1248: End If;
1249: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1250: fnd_message.set_token('PACKAGE',l_module_name);
1251: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1252: fnd_message.set_token('ORA_TEXT',SQLERRM);
1253: Raise handle_exception;
1254: End;
1255:
1256: l_freight_terms_rec.organization_id := p_ship_par_val_rec.organization_id;

Line 1317: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1313: When Others then
1314: If l_debug_on then
1315: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1316: End If;
1317: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1318: fnd_message.set_token('PACKAGE',l_module_name);
1319: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1320: fnd_message.set_token('ORA_TEXT',SQLERRM);
1321: raise handle_exception;

Line 1318: fnd_message.set_token('PACKAGE',l_module_name);

1314: If l_debug_on then
1315: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1316: End If;
1317: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1318: fnd_message.set_token('PACKAGE',l_module_name);
1319: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1320: fnd_message.set_token('ORA_TEXT',SQLERRM);
1321: raise handle_exception;
1322: End;

Line 1319: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1315: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1316: End If;
1317: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1318: fnd_message.set_token('PACKAGE',l_module_name);
1319: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1320: fnd_message.set_token('ORA_TEXT',SQLERRM);
1321: raise handle_exception;
1322: End;
1323: End If;

Line 1320: fnd_message.set_token('ORA_TEXT',SQLERRM);

1316: End If;
1317: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1318: fnd_message.set_token('PACKAGE',l_module_name);
1319: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1320: fnd_message.set_token('ORA_TEXT',SQLERRM);
1321: raise handle_exception;
1322: End;
1323: End If;
1324:

Line 1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1339: End If;
1340:
1341: When others then
1342: x_return_status := wsh_util_core.g_ret_sts_error;
1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1344: fnd_message.set_token('PACKAGE',l_module_name);
1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1346: fnd_message.set_token('ORA_TEXT',SQLERRM);
1347: If l_debug_on then

Line 1344: fnd_message.set_token('PACKAGE',l_module_name);

1340:
1341: When others then
1342: x_return_status := wsh_util_core.g_ret_sts_error;
1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1344: fnd_message.set_token('PACKAGE',l_module_name);
1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1346: fnd_message.set_token('ORA_TEXT',SQLERRM);
1347: If l_debug_on then
1348: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1341: When others then
1342: x_return_status := wsh_util_core.g_ret_sts_error;
1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1344: fnd_message.set_token('PACKAGE',l_module_name);
1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1346: fnd_message.set_token('ORA_TEXT',SQLERRM);
1347: If l_debug_on then
1348: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1349: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);

Line 1346: fnd_message.set_token('ORA_TEXT',SQLERRM);

1342: x_return_status := wsh_util_core.g_ret_sts_error;
1343: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1344: fnd_message.set_token('PACKAGE',l_module_name);
1345: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1346: fnd_message.set_token('ORA_TEXT',SQLERRM);
1347: If l_debug_on then
1348: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1349: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
1350: wsh_debug_sv.pop(l_module_name);

Line 1518: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1514: When others then
1515: If l_debug_on then
1516: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1517: End If;
1518: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1519: fnd_message.set_token('PACKAGE',l_module_name);
1520: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1521: fnd_message.set_token('ORA_TEXT',SQLERRM);
1522: raise handle_exception;

Line 1519: fnd_message.set_token('PACKAGE',l_module_name);

1515: If l_debug_on then
1516: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1517: End If;
1518: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1519: fnd_message.set_token('PACKAGE',l_module_name);
1520: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1521: fnd_message.set_token('ORA_TEXT',SQLERRM);
1522: raise handle_exception;
1523: End;

Line 1520: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1516: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1517: End If;
1518: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1519: fnd_message.set_token('PACKAGE',l_module_name);
1520: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1521: fnd_message.set_token('ORA_TEXT',SQLERRM);
1522: raise handle_exception;
1523: End;
1524:

Line 1521: fnd_message.set_token('ORA_TEXT',SQLERRM);

1517: End If;
1518: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1519: fnd_message.set_token('PACKAGE',l_module_name);
1520: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1521: fnd_message.set_token('ORA_TEXT',SQLERRM);
1522: raise handle_exception;
1523: End;
1524:
1525:

Line 1622: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1618: When others then
1619: If l_debug_on then
1620: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1621: End If;
1622: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1623: fnd_message.set_token('PACKAGE',l_module_name);
1624: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1625: fnd_message.set_token('ORA_TEXT',SQLERRM);
1626: raise handle_exception;

Line 1623: fnd_message.set_token('PACKAGE',l_module_name);

1619: If l_debug_on then
1620: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1621: End If;
1622: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1623: fnd_message.set_token('PACKAGE',l_module_name);
1624: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1625: fnd_message.set_token('ORA_TEXT',SQLERRM);
1626: raise handle_exception;
1627: End;

Line 1624: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1620: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1621: End If;
1622: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1623: fnd_message.set_token('PACKAGE',l_module_name);
1624: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1625: fnd_message.set_token('ORA_TEXT',SQLERRM);
1626: raise handle_exception;
1627: End;
1628: create_freight_terms(l_freight_terms_rec

Line 1625: fnd_message.set_token('ORA_TEXT',SQLERRM);

1621: End If;
1622: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1623: fnd_message.set_token('PACKAGE',l_module_name);
1624: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1625: fnd_message.set_token('ORA_TEXT',SQLERRM);
1626: raise handle_exception;
1627: End;
1628: create_freight_terms(l_freight_terms_rec
1629: ,l_return_status);

Line 1654: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1650: When others then
1651: If l_debug_on then
1652: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1653: End If;
1654: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1655: fnd_message.set_token('PACKAGE',l_module_name);
1656: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1657: fnd_message.set_token('ORA_TEXT',SQLERRM);
1658: raise handle_exception;

Line 1655: fnd_message.set_token('PACKAGE',l_module_name);

1651: If l_debug_on then
1652: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1653: End If;
1654: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1655: fnd_message.set_token('PACKAGE',l_module_name);
1656: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1657: fnd_message.set_token('ORA_TEXT',SQLERRM);
1658: raise handle_exception;
1659: End;

Line 1656: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1652: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1653: End If;
1654: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1655: fnd_message.set_token('PACKAGE',l_module_name);
1656: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1657: fnd_message.set_token('ORA_TEXT',SQLERRM);
1658: raise handle_exception;
1659: End;
1660: End If;

Line 1657: fnd_message.set_token('ORA_TEXT',SQLERRM);

1653: End If;
1654: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1655: fnd_message.set_token('PACKAGE',l_module_name);
1656: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1657: fnd_message.set_token('ORA_TEXT',SQLERRM);
1658: raise handle_exception;
1659: End;
1660: End If;
1661: Else

Line 1677: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1673: When others then
1674: If l_debug_on then
1675: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1676: End If;
1677: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1678: fnd_message.set_token('PACKAGE',l_module_name);
1679: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1680: fnd_message.set_token('ORA_TEXT',SQLERRM);
1681: raise handle_exception;

Line 1678: fnd_message.set_token('PACKAGE',l_module_name);

1674: If l_debug_on then
1675: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1676: End If;
1677: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1678: fnd_message.set_token('PACKAGE',l_module_name);
1679: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1680: fnd_message.set_token('ORA_TEXT',SQLERRM);
1681: raise handle_exception;
1682: End;

Line 1679: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1675: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1676: End If;
1677: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1678: fnd_message.set_token('PACKAGE',l_module_name);
1679: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1680: fnd_message.set_token('ORA_TEXT',SQLERRM);
1681: raise handle_exception;
1682: End;
1683: End If;

Line 1680: fnd_message.set_token('ORA_TEXT',SQLERRM);

1676: End If;
1677: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1678: fnd_message.set_token('PACKAGE',l_module_name);
1679: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1680: fnd_message.set_token('ORA_TEXT',SQLERRM);
1681: raise handle_exception;
1682: End;
1683: End If;
1684:

Line 1713: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1709: When others then
1710: If l_debug_on then
1711: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1712: End If;
1713: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1714: fnd_message.set_token('PACKAGE',l_module_name);
1715: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1716: fnd_message.set_token('ORA_TEXT',SQLERRM);
1717: Raise handle_exception;

Line 1714: fnd_message.set_token('PACKAGE',l_module_name);

1710: If l_debug_on then
1711: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1712: End If;
1713: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1714: fnd_message.set_token('PACKAGE',l_module_name);
1715: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1716: fnd_message.set_token('ORA_TEXT',SQLERRM);
1717: Raise handle_exception;
1718: End;

Line 1715: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1711: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1712: End If;
1713: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1714: fnd_message.set_token('PACKAGE',l_module_name);
1715: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1716: fnd_message.set_token('ORA_TEXT',SQLERRM);
1717: Raise handle_exception;
1718: End;
1719: End If;

Line 1716: fnd_message.set_token('ORA_TEXT',SQLERRM);

1712: End If;
1713: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1714: fnd_message.set_token('PACKAGE',l_module_name);
1715: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1716: fnd_message.set_token('ORA_TEXT',SQLERRM);
1717: Raise handle_exception;
1718: End;
1719: End If;
1720: End If;

Line 1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

1733: End If;
1734: x_return_status := wsh_util_core.g_ret_sts_error;
1735:
1736: When others then
1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1738: fnd_message.set_token('PACKAGE',l_module_name);
1739: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1740: fnd_message.set_token('ORA_TEXT',SQLERRM);
1741: If l_debug_on then

Line 1738: fnd_message.set_token('PACKAGE',l_module_name);

1734: x_return_status := wsh_util_core.g_ret_sts_error;
1735:
1736: When others then
1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1738: fnd_message.set_token('PACKAGE',l_module_name);
1739: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1740: fnd_message.set_token('ORA_TEXT',SQLERRM);
1741: If l_debug_on then
1742: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 1739: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

1735:
1736: When others then
1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1738: fnd_message.set_token('PACKAGE',l_module_name);
1739: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1740: fnd_message.set_token('ORA_TEXT',SQLERRM);
1741: If l_debug_on then
1742: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1743: wsh_debug_sv.pop(l_module_name);

Line 1740: fnd_message.set_token('ORA_TEXT',SQLERRM);

1736: When others then
1737: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1738: fnd_message.set_token('PACKAGE',l_module_name);
1739: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1740: fnd_message.set_token('ORA_TEXT',SQLERRM);
1741: If l_debug_on then
1742: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1743: wsh_debug_sv.pop(l_module_name);
1744: End If;

Line 1789: fnd_message.set_name('FND' , 'FND_RECORD_CHANGED_ERROR');

1785: Close get_last_update_date_csr;
1786:
1787: If l_date is not null then
1788: If l_date <> p_last_update_date then
1789: fnd_message.set_name('FND' , 'FND_RECORD_CHANGED_ERROR');
1790: Raise handle_exception;
1791: End If;
1792:
1793: End If;

Line 1801: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');

1797: Close l_lock_csr;
1798:
1799: If l_id is null then
1800: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1801: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1802: If l_debug_on then
1803: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);
1804: wsh_debug_sv.log(l_module_name,'Record dosent exists for the ORG ID ',p_organization_id);
1805: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

Line 1824: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');

1820: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
1821: wsh_debug_sv.pop(l_module_name);
1822: End If;
1823: When Others then
1824: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1825: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1826: If l_debug_on then
1827: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured During Locking for Org Id ',p_organization_id);
1828: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );

Line 2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2018: End If;
2019:
2020: Exception
2021: When Others Then
2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2025: fnd_message.set_token('ORA_TEXT','');
2026: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');

2019:
2020: Exception
2021: When Others Then
2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2025: fnd_message.set_token('ORA_TEXT','');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: If l_debug_on Then

Line 2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2020: Exception
2021: When Others Then
2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2025: fnd_message.set_token('ORA_TEXT','');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: If l_debug_on Then
2028: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2025: fnd_message.set_token('ORA_TEXT','');

2021: When Others Then
2022: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2023: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
2024: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2025: fnd_message.set_token('ORA_TEXT','');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: If l_debug_on Then
2028: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2090: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');

2086: If l_freight_terms_value(j) = p_freight_terms_rec.param_value_chr(i) then
2087: If l_debug_on then
2088: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2089: End If;
2090: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2091: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2092: fnd_message.set_token('ORG_NAME',l_org_name);
2093: Raise handle_exception;
2094: End If;

Line 2091: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));

2087: If l_debug_on then
2088: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2089: End If;
2090: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2091: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2092: fnd_message.set_token('ORG_NAME',l_org_name);
2093: Raise handle_exception;
2094: End If;
2095: End Loop;

Line 2092: fnd_message.set_token('ORG_NAME',l_org_name);

2088: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2089: End If;
2090: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2091: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2092: fnd_message.set_token('ORG_NAME',l_org_name);
2093: Raise handle_exception;
2094: End If;
2095: End Loop;
2096: l_freight_terms_value(nvl(l_freight_terms_value.count,0)+1) := p_freight_terms_rec.param_value_chr(i);

Line 2114: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');

2110: wsh_debug_sv.log(l_module_name, 'One of the inserted records matches existing record in wsh_shipping_parameter_values table');
2111: wsh_debug_sv.log(l_module_name, 'Duplicate Freight Terms is ',p_freight_terms_rec.param_value_chr(i));
2112: wsh_debug_sv.log(l_module_name, 'For Organization id ',p_freight_terms_rec.organization_id);
2113: End If;
2114: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
2115: Raise handle_exception;
2116: End If;
2117:
2118: End Loop;

Line 2158: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2154: When others then
2155: If l_debug_on then
2156: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2157: End If;
2158: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2159: fnd_message.set_token('PACKAGE',l_module_name);
2160: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2161: fnd_message.set_token('ORA_TEXT',SQLERRM);
2162: raise handle_exception;

Line 2159: fnd_message.set_token('PACKAGE',l_module_name);

2155: If l_debug_on then
2156: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2157: End If;
2158: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2159: fnd_message.set_token('PACKAGE',l_module_name);
2160: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2161: fnd_message.set_token('ORA_TEXT',SQLERRM);
2162: raise handle_exception;
2163: End;

Line 2160: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2156: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2157: End If;
2158: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2159: fnd_message.set_token('PACKAGE',l_module_name);
2160: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2161: fnd_message.set_token('ORA_TEXT',SQLERRM);
2162: raise handle_exception;
2163: End;
2164: End If;

Line 2161: fnd_message.set_token('ORA_TEXT',SQLERRM);

2157: End If;
2158: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2159: fnd_message.set_token('PACKAGE',l_module_name);
2160: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2161: fnd_message.set_token('ORA_TEXT',SQLERRM);
2162: raise handle_exception;
2163: End;
2164: End If;
2165: End If;

Line 2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2178: wsh_debug_sv.pop(l_module_name);
2179: End If;
2180: When others then
2181: x_return_status := wsh_util_core.g_ret_sts_error;
2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2183: fnd_message.set_token('PACKAGE',l_module_name);
2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2185: fnd_message.set_token('ORA_TEXT',SQLERRM);
2186: If l_debug_on then

Line 2183: fnd_message.set_token('PACKAGE',l_module_name);

2179: End If;
2180: When others then
2181: x_return_status := wsh_util_core.g_ret_sts_error;
2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2183: fnd_message.set_token('PACKAGE',l_module_name);
2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2185: fnd_message.set_token('ORA_TEXT',SQLERRM);
2186: If l_debug_on then
2187: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2180: When others then
2181: x_return_status := wsh_util_core.g_ret_sts_error;
2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2183: fnd_message.set_token('PACKAGE',l_module_name);
2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2185: fnd_message.set_token('ORA_TEXT',SQLERRM);
2186: If l_debug_on then
2187: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2188: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

Line 2185: fnd_message.set_token('ORA_TEXT',SQLERRM);

2181: x_return_status := wsh_util_core.g_ret_sts_error;
2182: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2183: fnd_message.set_token('PACKAGE',l_module_name);
2184: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2185: fnd_message.set_token('ORA_TEXT',SQLERRM);
2186: If l_debug_on then
2187: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2188: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2189: wsh_debug_sv.pop(l_module_name);

Line 2256: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');

2252: If l_freight_terms is not null then
2253: If l_debug_on then
2254: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2255: End If;
2256: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2257: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2258: fnd_message.set_token('ORG_NAME',l_org_name);
2259: Raise handle_exception;
2260: End If;

Line 2257: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));

2253: If l_debug_on then
2254: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2255: End If;
2256: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2257: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2258: fnd_message.set_token('ORG_NAME',l_org_name);
2259: Raise handle_exception;
2260: End If;
2261: End Loop;

Line 2258: fnd_message.set_token('ORG_NAME',l_org_name);

2254: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2255: End If;
2256: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2257: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2258: fnd_message.set_token('ORG_NAME',l_org_name);
2259: Raise handle_exception;
2260: End If;
2261: End Loop;
2262:

Line 2283: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2279: When others then
2280: If l_debug_on then
2281: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2282: End If;
2283: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2284: fnd_message.set_token('PACKAGE',l_module_name);
2285: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2286: fnd_message.set_token('ORA_TEXT',SQLERRM);
2287: raise handle_exception;

Line 2284: fnd_message.set_token('PACKAGE',l_module_name);

2280: If l_debug_on then
2281: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2282: End If;
2283: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2284: fnd_message.set_token('PACKAGE',l_module_name);
2285: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2286: fnd_message.set_token('ORA_TEXT',SQLERRM);
2287: raise handle_exception;
2288: End;

Line 2285: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2281: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2282: End If;
2283: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2284: fnd_message.set_token('PACKAGE',l_module_name);
2285: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2286: fnd_message.set_token('ORA_TEXT',SQLERRM);
2287: raise handle_exception;
2288: End;
2289: End If;

Line 2286: fnd_message.set_token('ORA_TEXT',SQLERRM);

2282: End If;
2283: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2284: fnd_message.set_token('PACKAGE',l_module_name);
2285: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2286: fnd_message.set_token('ORA_TEXT',SQLERRM);
2287: raise handle_exception;
2288: End;
2289: End If;
2290:

Line 2292: fnd_message.set_name('FND' , 'FORM_RECORD_CHANGED');

2288: End;
2289: End If;
2290:
2291: If sql%notfound then
2292: fnd_message.set_name('FND' , 'FORM_RECORD_CHANGED');
2293: Raise handle_exception;
2294: End If;
2295:
2296: If l_debug_on then

Line 2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2311: wsh_debug_sv.pop(l_module_name);
2312: End If;
2313: When others then
2314: x_return_status := wsh_util_core.g_ret_sts_error;
2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2316: fnd_message.set_token('PACKAGE',l_module_name);
2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2318: fnd_message.set_token('ORA_TEXT',SQLERRM);
2319: If l_debug_on then

Line 2316: fnd_message.set_token('PACKAGE',l_module_name);

2312: End If;
2313: When others then
2314: x_return_status := wsh_util_core.g_ret_sts_error;
2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2316: fnd_message.set_token('PACKAGE',l_module_name);
2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2318: fnd_message.set_token('ORA_TEXT',SQLERRM);
2319: If l_debug_on then
2320: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2313: When others then
2314: x_return_status := wsh_util_core.g_ret_sts_error;
2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2316: fnd_message.set_token('PACKAGE',l_module_name);
2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2318: fnd_message.set_token('ORA_TEXT',SQLERRM);
2319: If l_debug_on then
2320: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2321: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

Line 2318: fnd_message.set_token('ORA_TEXT',SQLERRM);

2314: x_return_status := wsh_util_core.g_ret_sts_error;
2315: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2316: fnd_message.set_token('PACKAGE',l_module_name);
2317: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2318: fnd_message.set_token('ORA_TEXT',SQLERRM);
2319: If l_debug_on then
2320: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2321: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2322: wsh_debug_sv.pop(l_module_name);

Line 2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');

2366:
2367: Exception
2368: When others then
2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2371: fnd_message.set_token('PACKAGE',l_module_name);
2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2373: fnd_message.set_token('ORA_TEXT',SQLERRM);
2374: If l_debug_on then

Line 2371: fnd_message.set_token('PACKAGE',l_module_name);

2367: Exception
2368: When others then
2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2371: fnd_message.set_token('PACKAGE',l_module_name);
2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2373: fnd_message.set_token('ORA_TEXT',SQLERRM);
2374: If l_debug_on then
2375: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

Line 2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));

2368: When others then
2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2371: fnd_message.set_token('PACKAGE',l_module_name);
2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2373: fnd_message.set_token('ORA_TEXT',SQLERRM);
2374: If l_debug_on then
2375: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2376: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

Line 2373: fnd_message.set_token('ORA_TEXT',SQLERRM);

2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2371: fnd_message.set_token('PACKAGE',l_module_name);
2372: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2373: fnd_message.set_token('ORA_TEXT',SQLERRM);
2374: If l_debug_on then
2375: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2376: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2377: wsh_debug_sv.pop(l_module_name);