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 209: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');

205: INTO l_param_info;
206: IF c_get_param%NOTFOUND THEN
207: --{
208: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
209: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
210: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
211: FND_MSG_PUB.Add; --BUG#12599249
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);

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

206: IF c_get_param%NOTFOUND THEN
207: --{
208: --Bug 3539616 : Error message shown when Shipping Parameters are not defined
209: FND_MESSAGE.Set_Name('WSH', 'WSH_SHP_NOT_FOUND');
210: FND_MESSAGE.Set_Token('ORG_NAME', wsh_util_core.get_org_name(p_organization_id));
211: FND_MSG_PUB.Add; --BUG#12599249
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Shipping Parameters not defined for Organization '||p_organization_id);
214: END IF;

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

386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
387: END IF;
388: --
389: WHEN OTHERS THEN
390: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
391: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
392: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
393: FND_MESSAGE.Set_Token('ORA_TEXT','');
394: IF c_get_param%ISOPEN THEN

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

387: END IF;
388: --
389: WHEN OTHERS THEN
390: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
391: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
392: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
393: FND_MESSAGE.Set_Token('ORA_TEXT','');
394: IF c_get_param%ISOPEN THEN
395: CLOSE c_get_param;

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

388: --
389: WHEN OTHERS THEN
390: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
391: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
392: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
393: FND_MESSAGE.Set_Token('ORA_TEXT','');
394: IF c_get_param%ISOPEN THEN
395: CLOSE c_get_param;
396: END IF;

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

389: WHEN OTHERS THEN
390: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
391: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
392: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
393: FND_MESSAGE.Set_Token('ORA_TEXT','');
394: IF c_get_param%ISOPEN THEN
395: CLOSE c_get_param;
396: END IF;
397: x_return_status := FND_API.G_RET_STS_ERROR;

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

597: OPEN c_get_global_param;
598: FETCH c_get_global_param
599: INTO l_param_info;
600: IF c_get_global_param%NOTFOUND THEN
601: FND_MESSAGE.Set_Name('WSH','WSH_PARAM_NOT_DEFINED');
602: RAISE NO_DATA_FOUND;
603: END IF;
604:
605: -- Insert cached info into PL/SQL table

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

700: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
701: END IF;
702: --
703: WHEN OTHERS THEN
704: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
705: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
706: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
707: FND_MESSAGE.Set_Token('ORA_TEXT','');
708: IF c_get_global_param%ISOPEN THEN

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

701: END IF;
702: --
703: WHEN OTHERS THEN
704: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
705: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
706: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
707: FND_MESSAGE.Set_Token('ORA_TEXT','');
708: IF c_get_global_param%ISOPEN THEN
709: CLOSE c_get_global_param;

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

702: --
703: WHEN OTHERS THEN
704: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
705: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
706: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
707: FND_MESSAGE.Set_Token('ORA_TEXT','');
708: IF c_get_global_param%ISOPEN THEN
709: CLOSE c_get_global_param;
710: END IF;

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

703: WHEN OTHERS THEN
704: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
705: FND_MESSAGE.Set_Token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
706: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
707: FND_MESSAGE.Set_Token('ORA_TEXT','');
708: IF c_get_global_param%ISOPEN THEN
709: CLOSE c_get_global_param;
710: END IF;
711: x_return_status := FND_API.G_RET_STS_ERROR;

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

873:
874: Exception
875: When others then
876: x_return_status := wsh_util_core.g_ret_sts_error;
877: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
878: fnd_message.set_token('PACKAGE',l_module_name);
879: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
880: fnd_message.set_token('ORA_TEXT',SQLERRM);
881: If l_debug_on then

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

874: Exception
875: When others then
876: x_return_status := wsh_util_core.g_ret_sts_error;
877: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
878: fnd_message.set_token('PACKAGE',l_module_name);
879: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
880: fnd_message.set_token('ORA_TEXT',SQLERRM);
881: If l_debug_on then
882: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

875: When others then
876: x_return_status := wsh_util_core.g_ret_sts_error;
877: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
878: fnd_message.set_token('PACKAGE',l_module_name);
879: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
880: fnd_message.set_token('ORA_TEXT',SQLERRM);
881: If l_debug_on then
882: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
883: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);

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

876: x_return_status := wsh_util_core.g_ret_sts_error;
877: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
878: fnd_message.set_token('PACKAGE',l_module_name);
879: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
880: fnd_message.set_token('ORA_TEXT',SQLERRM);
881: If l_debug_on then
882: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
883: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
884: wsh_debug_sv.pop(l_module_name);

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

1141: When others then
1142: If l_debug_on then
1143: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1144: End If;
1145: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1146: fnd_message.set_token('PACKAGE',l_module_name);
1147: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1148: fnd_message.set_token('ORA_TEXT',SQLERRM);
1149: raise handle_exception;

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

1142: If l_debug_on then
1143: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1144: End If;
1145: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1146: fnd_message.set_token('PACKAGE',l_module_name);
1147: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1148: fnd_message.set_token('ORA_TEXT',SQLERRM);
1149: raise handle_exception;
1150: End;

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

1143: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1144: End If;
1145: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1146: fnd_message.set_token('PACKAGE',l_module_name);
1147: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1148: fnd_message.set_token('ORA_TEXT',SQLERRM);
1149: raise handle_exception;
1150: End;
1151: If l_debug_on then

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

1144: End If;
1145: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1146: fnd_message.set_token('PACKAGE',l_module_name);
1147: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1148: fnd_message.set_token('ORA_TEXT',SQLERRM);
1149: raise handle_exception;
1150: End;
1151: If l_debug_on then
1152: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);

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

1199: When others then
1200: If l_debug_on then
1201: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1202: End If;
1203: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1204: fnd_message.set_token('PACKAGE',l_module_name);
1205: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1206: fnd_message.set_token('ORA_TEXT',SQLERRM);
1207: Raise handle_exception;

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

1200: If l_debug_on then
1201: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1202: End If;
1203: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1204: fnd_message.set_token('PACKAGE',l_module_name);
1205: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1206: fnd_message.set_token('ORA_TEXT',SQLERRM);
1207: Raise handle_exception;
1208: End;

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

1201: wsh_debug_sv.log(l_module_name,'After delete of Freight Terms from wsh_shipping_parameter_values : ',sqlerrm);
1202: End If;
1203: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1204: fnd_message.set_token('PACKAGE',l_module_name);
1205: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1206: fnd_message.set_token('ORA_TEXT',SQLERRM);
1207: Raise handle_exception;
1208: End;
1209:

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

1202: End If;
1203: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1204: fnd_message.set_token('PACKAGE',l_module_name);
1205: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1206: fnd_message.set_token('ORA_TEXT',SQLERRM);
1207: Raise handle_exception;
1208: End;
1209:
1210: l_freight_terms_rec.organization_id := p_ship_par_val_rec.organization_id;

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

1267: When Others then
1268: If l_debug_on then
1269: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1270: End If;
1271: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1272: fnd_message.set_token('PACKAGE',l_module_name);
1273: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1274: fnd_message.set_token('ORA_TEXT',SQLERRM);
1275: raise handle_exception;

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

1268: If l_debug_on then
1269: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1270: End If;
1271: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1272: fnd_message.set_token('PACKAGE',l_module_name);
1273: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1274: fnd_message.set_token('ORA_TEXT',SQLERRM);
1275: raise handle_exception;
1276: End;

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

1269: wsh_debug_sv.log(l_module_name,'After insert of values into wsh_shipping_parameter_values table : ',sqlerrm);
1270: End If;
1271: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1272: fnd_message.set_token('PACKAGE',l_module_name);
1273: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1274: fnd_message.set_token('ORA_TEXT',SQLERRM);
1275: raise handle_exception;
1276: End;
1277: End If;

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

1270: End If;
1271: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1272: fnd_message.set_token('PACKAGE',l_module_name);
1273: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1274: fnd_message.set_token('ORA_TEXT',SQLERRM);
1275: raise handle_exception;
1276: End;
1277: End If;
1278:

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

1293: End If;
1294:
1295: When others then
1296: x_return_status := wsh_util_core.g_ret_sts_error;
1297: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1298: fnd_message.set_token('PACKAGE',l_module_name);
1299: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1300: fnd_message.set_token('ORA_TEXT',SQLERRM);
1301: If l_debug_on then

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

1294:
1295: When others then
1296: x_return_status := wsh_util_core.g_ret_sts_error;
1297: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1298: fnd_message.set_token('PACKAGE',l_module_name);
1299: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1300: fnd_message.set_token('ORA_TEXT',SQLERRM);
1301: If l_debug_on then
1302: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

1295: When others then
1296: x_return_status := wsh_util_core.g_ret_sts_error;
1297: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1298: fnd_message.set_token('PACKAGE',l_module_name);
1299: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1300: fnd_message.set_token('ORA_TEXT',SQLERRM);
1301: If l_debug_on then
1302: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1303: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);

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

1296: x_return_status := wsh_util_core.g_ret_sts_error;
1297: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1298: fnd_message.set_token('PACKAGE',l_module_name);
1299: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1300: fnd_message.set_token('ORA_TEXT',SQLERRM);
1301: If l_debug_on then
1302: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1303: wsh_debug_sv.log(l_module_name,'x_return_status = : ',x_return_status);
1304: wsh_debug_sv.pop(l_module_name);

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

1472: When others then
1473: If l_debug_on then
1474: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1475: End If;
1476: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1477: fnd_message.set_token('PACKAGE',l_module_name);
1478: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1479: fnd_message.set_token('ORA_TEXT',SQLERRM);
1480: raise handle_exception;

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

1473: If l_debug_on then
1474: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1475: End If;
1476: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1477: fnd_message.set_token('PACKAGE',l_module_name);
1478: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1479: fnd_message.set_token('ORA_TEXT',SQLERRM);
1480: raise handle_exception;
1481: End;

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

1474: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1475: End If;
1476: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1477: fnd_message.set_token('PACKAGE',l_module_name);
1478: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1479: fnd_message.set_token('ORA_TEXT',SQLERRM);
1480: raise handle_exception;
1481: End;
1482:

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

1475: End If;
1476: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1477: fnd_message.set_token('PACKAGE',l_module_name);
1478: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1479: fnd_message.set_token('ORA_TEXT',SQLERRM);
1480: raise handle_exception;
1481: End;
1482:
1483:

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

1576: When others then
1577: If l_debug_on then
1578: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1579: End If;
1580: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1581: fnd_message.set_token('PACKAGE',l_module_name);
1582: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1583: fnd_message.set_token('ORA_TEXT',SQLERRM);
1584: raise handle_exception;

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

1577: If l_debug_on then
1578: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1579: End If;
1580: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1581: fnd_message.set_token('PACKAGE',l_module_name);
1582: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1583: fnd_message.set_token('ORA_TEXT',SQLERRM);
1584: raise handle_exception;
1585: End;

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

1578: wsh_debug_sv.log(l_module_name,'After delete of Freigth Terms from wsh_shipping_parameter_value : ',sqlerrm);
1579: End If;
1580: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1581: fnd_message.set_token('PACKAGE',l_module_name);
1582: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1583: fnd_message.set_token('ORA_TEXT',SQLERRM);
1584: raise handle_exception;
1585: End;
1586: create_freight_terms(l_freight_terms_rec

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

1579: End If;
1580: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1581: fnd_message.set_token('PACKAGE',l_module_name);
1582: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1583: fnd_message.set_token('ORA_TEXT',SQLERRM);
1584: raise handle_exception;
1585: End;
1586: create_freight_terms(l_freight_terms_rec
1587: ,l_return_status);

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

1608: When others then
1609: If l_debug_on then
1610: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1611: End If;
1612: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1613: fnd_message.set_token('PACKAGE',l_module_name);
1614: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1615: fnd_message.set_token('ORA_TEXT',SQLERRM);
1616: raise handle_exception;

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

1609: If l_debug_on then
1610: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1611: End If;
1612: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1613: fnd_message.set_token('PACKAGE',l_module_name);
1614: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1615: fnd_message.set_token('ORA_TEXT',SQLERRM);
1616: raise handle_exception;
1617: End;

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

1610: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1611: End If;
1612: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1613: fnd_message.set_token('PACKAGE',l_module_name);
1614: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1615: fnd_message.set_token('ORA_TEXT',SQLERRM);
1616: raise handle_exception;
1617: End;
1618: End If;

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

1611: End If;
1612: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1613: fnd_message.set_token('PACKAGE',l_module_name);
1614: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1615: fnd_message.set_token('ORA_TEXT',SQLERRM);
1616: raise handle_exception;
1617: End;
1618: End If;
1619: Else

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

1631: When others then
1632: If l_debug_on then
1633: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1634: End If;
1635: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1636: fnd_message.set_token('PACKAGE',l_module_name);
1637: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1638: fnd_message.set_token('ORA_TEXT',SQLERRM);
1639: raise handle_exception;

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

1632: If l_debug_on then
1633: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1634: End If;
1635: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1636: fnd_message.set_token('PACKAGE',l_module_name);
1637: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1638: fnd_message.set_token('ORA_TEXT',SQLERRM);
1639: raise handle_exception;
1640: End;

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

1633: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_value table : ',sqlerrm);
1634: End If;
1635: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1636: fnd_message.set_token('PACKAGE',l_module_name);
1637: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1638: fnd_message.set_token('ORA_TEXT',SQLERRM);
1639: raise handle_exception;
1640: End;
1641: End If;

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

1634: End If;
1635: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1636: fnd_message.set_token('PACKAGE',l_module_name);
1637: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1638: fnd_message.set_token('ORA_TEXT',SQLERRM);
1639: raise handle_exception;
1640: End;
1641: End If;
1642:

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

1667: When others then
1668: If l_debug_on then
1669: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1670: End If;
1671: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1672: fnd_message.set_token('PACKAGE',l_module_name);
1673: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1674: fnd_message.set_token('ORA_TEXT',SQLERRM);
1675: Raise handle_exception;

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

1668: If l_debug_on then
1669: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1670: End If;
1671: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1672: fnd_message.set_token('PACKAGE',l_module_name);
1673: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1674: fnd_message.set_token('ORA_TEXT',SQLERRM);
1675: Raise handle_exception;
1676: End;

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

1669: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameter_value table : ',sqlerrm);
1670: End If;
1671: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1672: fnd_message.set_token('PACKAGE',l_module_name);
1673: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1674: fnd_message.set_token('ORA_TEXT',SQLERRM);
1675: Raise handle_exception;
1676: End;
1677: End If;

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

1670: End If;
1671: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1672: fnd_message.set_token('PACKAGE',l_module_name);
1673: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1674: fnd_message.set_token('ORA_TEXT',SQLERRM);
1675: Raise handle_exception;
1676: End;
1677: End If;
1678: End If;

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

1691: End If;
1692: x_return_status := wsh_util_core.g_ret_sts_error;
1693:
1694: When others then
1695: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1696: fnd_message.set_token('PACKAGE',l_module_name);
1697: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1698: fnd_message.set_token('ORA_TEXT',SQLERRM);
1699: If l_debug_on then

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

1692: x_return_status := wsh_util_core.g_ret_sts_error;
1693:
1694: When others then
1695: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1696: fnd_message.set_token('PACKAGE',l_module_name);
1697: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1698: fnd_message.set_token('ORA_TEXT',SQLERRM);
1699: If l_debug_on then
1700: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

1693:
1694: When others then
1695: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1696: fnd_message.set_token('PACKAGE',l_module_name);
1697: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1698: fnd_message.set_token('ORA_TEXT',SQLERRM);
1699: If l_debug_on then
1700: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1701: wsh_debug_sv.pop(l_module_name);

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

1694: When others then
1695: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1696: fnd_message.set_token('PACKAGE',l_module_name);
1697: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1698: fnd_message.set_token('ORA_TEXT',SQLERRM);
1699: If l_debug_on then
1700: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
1701: wsh_debug_sv.pop(l_module_name);
1702: End If;

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

1743: Close get_last_update_date_csr;
1744:
1745: If l_date is not null then
1746: If l_date <> p_last_update_date then
1747: fnd_message.set_name('FND' , 'FND_RECORD_CHANGED_ERROR');
1748: Raise handle_exception;
1749: End If;
1750:
1751: End If;

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

1755: Close l_lock_csr;
1756:
1757: If l_id is null then
1758: x_return_status := wsh_util_core.G_RET_STS_ERROR;
1759: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1760: If l_debug_on then
1761: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);
1762: wsh_debug_sv.log(l_module_name,'Record dosent exists for the ORG ID ',p_organization_id);
1763: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

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

1778: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
1779: wsh_debug_sv.pop(l_module_name);
1780: End If;
1781: When Others then
1782: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1783: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1784: If l_debug_on then
1785: wsh_debug_sv.log(l_module_name,'Unexpected Error Occured During Locking for Org Id ',p_organization_id);
1786: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );

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

1976: End If;
1977:
1978: Exception
1979: When Others Then
1980: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1981: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
1982: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1983: fnd_message.set_token('ORA_TEXT','');
1984: x_return_status := FND_API.G_RET_STS_ERROR;

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

1977:
1978: Exception
1979: When Others Then
1980: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1981: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
1982: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1983: fnd_message.set_token('ORA_TEXT','');
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: If l_debug_on Then

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

1978: Exception
1979: When Others Then
1980: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1981: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
1982: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1983: fnd_message.set_token('ORA_TEXT','');
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: If l_debug_on Then
1986: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1979: When Others Then
1980: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1981: fnd_message.set_token('PACKAGE','WSH_SHIPPING_PARAMS_PVT');
1982: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1983: fnd_message.set_token('ORA_TEXT','');
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: If l_debug_on Then
1986: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2044: If l_freight_terms_value(j) = p_freight_terms_rec.param_value_chr(i) then
2045: If l_debug_on then
2046: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2047: End If;
2048: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2049: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2050: fnd_message.set_token('ORG_NAME',l_org_name);
2051: Raise handle_exception;
2052: End If;

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

2045: If l_debug_on then
2046: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2047: End If;
2048: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2049: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2050: fnd_message.set_token('ORG_NAME',l_org_name);
2051: Raise handle_exception;
2052: End If;
2053: End Loop;

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

2046: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2047: End If;
2048: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2049: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2050: fnd_message.set_token('ORG_NAME',l_org_name);
2051: Raise handle_exception;
2052: End If;
2053: End Loop;
2054: l_freight_terms_value(nvl(l_freight_terms_value.count,0)+1) := p_freight_terms_rec.param_value_chr(i);

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

2068: wsh_debug_sv.log(l_module_name, 'One of the inserted records matches existing record in wsh_shipping_parameter_values table');
2069: wsh_debug_sv.log(l_module_name, 'Duplicate Freight Terms is ',p_freight_terms_rec.param_value_chr(i));
2070: wsh_debug_sv.log(l_module_name, 'For Organization id ',p_freight_terms_rec.organization_id);
2071: End If;
2072: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
2073: Raise handle_exception;
2074: End If;
2075:
2076: End Loop;

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

2112: When others then
2113: If l_debug_on then
2114: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2115: End If;
2116: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2117: fnd_message.set_token('PACKAGE',l_module_name);
2118: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2119: fnd_message.set_token('ORA_TEXT',SQLERRM);
2120: raise handle_exception;

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

2113: If l_debug_on then
2114: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2115: End If;
2116: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2117: fnd_message.set_token('PACKAGE',l_module_name);
2118: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2119: fnd_message.set_token('ORA_TEXT',SQLERRM);
2120: raise handle_exception;
2121: End;

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

2114: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2115: End If;
2116: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2117: fnd_message.set_token('PACKAGE',l_module_name);
2118: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2119: fnd_message.set_token('ORA_TEXT',SQLERRM);
2120: raise handle_exception;
2121: End;
2122: End If;

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

2115: End If;
2116: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2117: fnd_message.set_token('PACKAGE',l_module_name);
2118: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2119: fnd_message.set_token('ORA_TEXT',SQLERRM);
2120: raise handle_exception;
2121: End;
2122: End If;
2123: End If;

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

2136: wsh_debug_sv.pop(l_module_name);
2137: End If;
2138: When others then
2139: x_return_status := wsh_util_core.g_ret_sts_error;
2140: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2141: fnd_message.set_token('PACKAGE',l_module_name);
2142: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2143: fnd_message.set_token('ORA_TEXT',SQLERRM);
2144: If l_debug_on then

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

2137: End If;
2138: When others then
2139: x_return_status := wsh_util_core.g_ret_sts_error;
2140: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2141: fnd_message.set_token('PACKAGE',l_module_name);
2142: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2143: fnd_message.set_token('ORA_TEXT',SQLERRM);
2144: If l_debug_on then
2145: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

2138: When others then
2139: x_return_status := wsh_util_core.g_ret_sts_error;
2140: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2141: fnd_message.set_token('PACKAGE',l_module_name);
2142: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2143: fnd_message.set_token('ORA_TEXT',SQLERRM);
2144: If l_debug_on then
2145: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2146: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

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

2139: x_return_status := wsh_util_core.g_ret_sts_error;
2140: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2141: fnd_message.set_token('PACKAGE',l_module_name);
2142: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2143: fnd_message.set_token('ORA_TEXT',SQLERRM);
2144: If l_debug_on then
2145: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2146: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2147: wsh_debug_sv.pop(l_module_name);

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

2210: If l_freight_terms is not null then
2211: If l_debug_on then
2212: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2213: End If;
2214: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2215: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2216: fnd_message.set_token('ORG_NAME',l_org_name);
2217: Raise handle_exception;
2218: End If;

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

2211: If l_debug_on then
2212: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2213: End If;
2214: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2215: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2216: fnd_message.set_token('ORG_NAME',l_org_name);
2217: Raise handle_exception;
2218: End If;
2219: End Loop;

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

2212: wsh_debug_sv.log(l_module_name, 'Going to raise others exception , Duplicate records exists for freight terms ');
2213: End If;
2214: fnd_message.set_name('WSH','WSH_FREIGHT_ORG_ASSGN_EXISTS');
2215: fnd_message.set_token('FREIGHT_TERMS',p_freight_terms_rec.param_value_chr(i));
2216: fnd_message.set_token('ORG_NAME',l_org_name);
2217: Raise handle_exception;
2218: End If;
2219: End Loop;
2220:

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

2237: When others then
2238: If l_debug_on then
2239: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2240: End If;
2241: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2242: fnd_message.set_token('PACKAGE',l_module_name);
2243: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2244: fnd_message.set_token('ORA_TEXT',SQLERRM);
2245: raise handle_exception;

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

2238: If l_debug_on then
2239: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2240: End If;
2241: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2242: fnd_message.set_token('PACKAGE',l_module_name);
2243: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2244: fnd_message.set_token('ORA_TEXT',SQLERRM);
2245: raise handle_exception;
2246: End;

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

2239: wsh_debug_sv.log(l_module_name,'After insert of values in wsh_shipping_parameter_values table : ',sqlerrm);
2240: End If;
2241: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2242: fnd_message.set_token('PACKAGE',l_module_name);
2243: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2244: fnd_message.set_token('ORA_TEXT',SQLERRM);
2245: raise handle_exception;
2246: End;
2247: End If;

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

2240: End If;
2241: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2242: fnd_message.set_token('PACKAGE',l_module_name);
2243: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2244: fnd_message.set_token('ORA_TEXT',SQLERRM);
2245: raise handle_exception;
2246: End;
2247: End If;
2248:

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

2246: End;
2247: End If;
2248:
2249: If sql%notfound then
2250: fnd_message.set_name('FND' , 'FORM_RECORD_CHANGED');
2251: Raise handle_exception;
2252: End If;
2253:
2254: If l_debug_on then

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

2269: wsh_debug_sv.pop(l_module_name);
2270: End If;
2271: When others then
2272: x_return_status := wsh_util_core.g_ret_sts_error;
2273: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2274: fnd_message.set_token('PACKAGE',l_module_name);
2275: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2276: fnd_message.set_token('ORA_TEXT',SQLERRM);
2277: If l_debug_on then

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

2270: End If;
2271: When others then
2272: x_return_status := wsh_util_core.g_ret_sts_error;
2273: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2274: fnd_message.set_token('PACKAGE',l_module_name);
2275: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2276: fnd_message.set_token('ORA_TEXT',SQLERRM);
2277: If l_debug_on then
2278: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

2271: When others then
2272: x_return_status := wsh_util_core.g_ret_sts_error;
2273: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2274: fnd_message.set_token('PACKAGE',l_module_name);
2275: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2276: fnd_message.set_token('ORA_TEXT',SQLERRM);
2277: If l_debug_on then
2278: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2279: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

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

2272: x_return_status := wsh_util_core.g_ret_sts_error;
2273: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2274: fnd_message.set_token('PACKAGE',l_module_name);
2275: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2276: fnd_message.set_token('ORA_TEXT',SQLERRM);
2277: If l_debug_on then
2278: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2279: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2280: wsh_debug_sv.pop(l_module_name);

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

2324:
2325: Exception
2326: When others then
2327: x_return_status := wsh_util_core.g_ret_sts_error;
2328: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2329: fnd_message.set_token('PACKAGE',l_module_name);
2330: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2331: fnd_message.set_token('ORA_TEXT',SQLERRM);
2332: If l_debug_on then

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

2325: Exception
2326: When others then
2327: x_return_status := wsh_util_core.g_ret_sts_error;
2328: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2329: fnd_message.set_token('PACKAGE',l_module_name);
2330: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2331: fnd_message.set_token('ORA_TEXT',SQLERRM);
2332: If l_debug_on then
2333: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

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

2326: When others then
2327: x_return_status := wsh_util_core.g_ret_sts_error;
2328: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2329: fnd_message.set_token('PACKAGE',l_module_name);
2330: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2331: fnd_message.set_token('ORA_TEXT',SQLERRM);
2332: If l_debug_on then
2333: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2334: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

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

2327: x_return_status := wsh_util_core.g_ret_sts_error;
2328: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
2329: fnd_message.set_token('PACKAGE',l_module_name);
2330: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
2331: fnd_message.set_token('ORA_TEXT',SQLERRM);
2332: If l_debug_on then
2333: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
2334: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
2335: wsh_debug_sv.pop(l_module_name);