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_EXCEPTIONS_GRP dependencies on FND_API

Line 29: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

25:
26: PROCEDURE Get_Exceptions (
27: -- Standard parameters
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33:

Line 103: IF NOT FND_API.compatible_api_call (

99: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
100: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
101: END IF;
102:
103: IF NOT FND_API.compatible_api_call (
104: l_api_version,
105: p_api_version,
106: l_api_name,
107: G_PKG_NAME) THEN

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: l_api_version,
105: p_api_version,
106: l_api_name,
107: G_PKG_NAME) THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Check p_init_msg_list
112: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 112: IF FND_API.to_boolean(p_init_msg_list) THEN

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Check p_init_msg_list
112: IF FND_API.to_boolean(p_init_msg_list) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 164: p_encoded => FND_API.G_FALSE

160: wsh_util_core.add_message(x_return_status);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data,
164: p_encoded => FND_API.G_FALSE
165: );
166:
167: --
168: -- Debug Statements

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

223:
224: PROCEDURE Change_Status (
225: -- Standard parameters
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,

Line 228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

224: PROCEDURE Change_Status (
225: -- Standard parameters
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

Line 229: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

225: -- Standard parameters
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233:

Line 296: IF NOT FND_API.compatible_api_call (

292: WSH_DEBUG_SV.log(l_module_name,'p_exception_id',p_exception_id);
293: WSH_DEBUG_SV.log(l_module_name,'p_new_status',p_new_status);
294: END IF;
295:
296: IF NOT FND_API.compatible_api_call (
297: l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) THEN

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Check p_init_msg_list
305: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 305: IF FND_API.to_boolean(p_init_msg_list) THEN

301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Check p_init_msg_list
305: IF FND_API.to_boolean(p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: -- initialize parameters

Line 315: IF (p_logging_entity_id = FND_API.G_MISS_NUM) OR

311: l_new_status := p_new_status;
312:
313: -- Checking p_logging_entity_id, p_logging_entity_name, and p_exception_name
314: -- if any of them is not valid then return
315: IF (p_logging_entity_id = FND_API.G_MISS_NUM) OR
316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR
317: (p_exception_name = FND_API.G_MISS_CHAR) OR
318: (p_new_status = FND_API.G_MISS_CHAR) THEN
319: x_updated_rows := 0;

Line 316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR

312:
313: -- Checking p_logging_entity_id, p_logging_entity_name, and p_exception_name
314: -- if any of them is not valid then return
315: IF (p_logging_entity_id = FND_API.G_MISS_NUM) OR
316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR
317: (p_exception_name = FND_API.G_MISS_CHAR) OR
318: (p_new_status = FND_API.G_MISS_CHAR) THEN
319: x_updated_rows := 0;
320: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 317: (p_exception_name = FND_API.G_MISS_CHAR) OR

313: -- Checking p_logging_entity_id, p_logging_entity_name, and p_exception_name
314: -- if any of them is not valid then return
315: IF (p_logging_entity_id = FND_API.G_MISS_NUM) OR
316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR
317: (p_exception_name = FND_API.G_MISS_CHAR) OR
318: (p_new_status = FND_API.G_MISS_CHAR) THEN
319: x_updated_rows := 0;
320: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
321: --

Line 318: (p_new_status = FND_API.G_MISS_CHAR) THEN

314: -- if any of them is not valid then return
315: IF (p_logging_entity_id = FND_API.G_MISS_NUM) OR
316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR
317: (p_exception_name = FND_API.G_MISS_CHAR) OR
318: (p_new_status = FND_API.G_MISS_CHAR) THEN
319: x_updated_rows := 0;
320: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
321: --
322: -- Debug Statements

Line 390: p_commit => FND_API.g_false,

386: END IF;
387: --
388: WSH_XC_UTIL.change_status (p_api_version => p_api_version,
389: p_init_msg_list => p_init_msg_list,
390: p_commit => FND_API.g_false,
391: p_validation_level => p_validation_level,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,

Line 397: p_set_default_status => FND_API.G_FALSE,

393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,
395: p_exception_id => l_exceptions_tab(i).exception_id,
396: p_old_status => l_exceptions_tab(i).status,
397: p_set_default_status => FND_API.G_FALSE,
398: x_new_status => l_new_status
399: );
400:
401: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 431: p_commit => FND_API.g_false,

427: --
428: WSH_XC_UTIL.change_status (
429: p_api_version => p_api_version,
430: p_init_msg_list => p_init_msg_list,
431: p_commit => FND_API.g_false,
432: p_validation_level => p_validation_level,
433: x_return_status => x_return_status,
434: x_msg_count => x_msg_count,
435: x_msg_data => x_msg_data,

Line 438: p_set_default_status => FND_API.G_FALSE,

434: x_msg_count => x_msg_count,
435: x_msg_data => x_msg_data,
436: p_exception_id => p_exception_id,
437: p_old_status => l_old_status,
438: p_set_default_status => FND_API.G_FALSE,
439: x_new_status => l_new_status
440: );
441:
442: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 467: AND FND_API.TO_BOOLEAN(p_commit) THEN

463:
464: x_updated_rows := l_success_count;
465:
466: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))
467: AND FND_API.TO_BOOLEAN(p_commit) THEN
468: COMMIT WORK;
469: END IF;
470:
471: FND_MSG_PUB.Count_And_Get(

Line 474: p_encoded => FND_API.G_FALSE

470:
471: FND_MSG_PUB.Count_And_Get(
472: p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476: --
477: -- Debug Statements
478: --

Line 491: p_encoded => FND_API.G_FALSE

487: wsh_util_core.add_message(x_return_status);
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE
492: );
493:
494: --
495: -- Debug Statements

Line 517: p_encoded => FND_API.G_FALSE

513: END IF;
514: FND_MSG_PUB.Count_And_Get
515: ( p_count => x_msg_count,
516: p_data => x_msg_data,
517: p_encoded => FND_API.G_FALSE
518: );
519:
520: --
521: -- Debug Statements

Line 546: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

542:
543: PROCEDURE Log_Exception (
544: -- Standard parameters
545: p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
548: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,

Line 547: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

543: PROCEDURE Log_Exception (
544: -- Standard parameters
545: p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
548: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,
551: x_return_status OUT NOCOPY VARCHAR2,

Line 548: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

544: -- Standard parameters
545: p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
548: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,
551: x_return_status OUT NOCOPY VARCHAR2,
552:

Line 600: l_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

596: l_exception_location_id NUMBER;
597: l_delivery_detail_id NUMBER;
598: l_delivery_assignment_id NUMBER;
599: l_result BOOLEAN;
600: l_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
601: l_msg_reason VARCHAR2(150);
602: l_logging_entity VARCHAR2(30);
603: l_severity VARCHAR2(30);
604:

Line 668: IF NOT FND_API.compatible_api_call(

664: wsh_debug_sv.log (l_module_name,'stop_location_id', p_exception_rec.stop_location_id);
665: wsh_debug_sv.log (l_module_name,'delivery_detail_id', p_exception_rec.delivery_detail_id);
666: END IF;
667:
668: IF NOT FND_API.compatible_api_call(
669: l_api_version,
670: p_api_version,
671: l_api_name,
672: G_PKG_NAME) THEN

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: l_api_version,
670: p_api_version,
671: l_api_name,
672: G_PKG_NAME) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: -- Check p_init_msg_list
677: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 677: IF FND_API.to_boolean(p_init_msg_list) THEN

673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: -- Check p_init_msg_list
677: IF FND_API.to_boolean(p_init_msg_list) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: IF FND_API.to_boolean(p_init_msg_list) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: -- Check for Required parameter 'exception_location'
684: IF p_exception_rec.exception_id IS NULL THEN
685: IF p_exception_rec.exception_location_code IS NULL THEN

Line 890: p_init_msg_list => FND_API.G_FALSE,

886: END IF;
887: --
888: WSH_XC_UTIL.log_exception(
889: p_api_version => p_api_version,
890: p_init_msg_list => FND_API.G_FALSE,
891: p_commit => FND_API.G_FALSE,
892: p_validation_level => p_validation_level,
893: x_return_status => l_return_status,
894: x_msg_count => x_msg_count,

Line 891: p_commit => FND_API.G_FALSE,

887: --
888: WSH_XC_UTIL.log_exception(
889: p_api_version => p_api_version,
890: p_init_msg_list => FND_API.G_FALSE,
891: p_commit => FND_API.G_FALSE,
892: p_validation_level => p_validation_level,
893: x_return_status => l_return_status,
894: x_msg_count => x_msg_count,
895: x_msg_data => x_msg_data,

Line 954: p_encoded => FND_API.G_FALSE

950:
951: FND_MSG_PUB.Count_And_Get(
952: p_count => x_msg_count,
953: p_data => x_msg_data,
954: p_encoded => FND_API.G_FALSE
955: );
956: --
957: -- Debug Statements
958: --

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968: close C_Del_Detail;
969: END IF;
970: FND_MESSAGE.SET_NAME('WSH','WSH_MULTIPLE_CONTAINERS');
971: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_exception_rec.container_name);
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: wsh_util_core.add_message(x_return_status,l_module_name);
974: FND_MSG_PUB.Count_And_Get(
975: p_count => x_msg_count,
976: p_data => x_msg_data,

Line 977: p_encoded => FND_API.G_FALSE

973: wsh_util_core.add_message(x_return_status,l_module_name);
974: FND_MSG_PUB.Count_And_Get(
975: p_count => x_msg_count,
976: p_data => x_msg_data,
977: p_encoded => FND_API.G_FALSE
978: );
979: --debug messages
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_MULTIPLE_CONTAINERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984: --
985: WHEN WSH_XC_INVALID_OPERATION THEN
986: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_OPERATION');
987: FND_MESSAGE.SET_TOKEN('REASON', l_msg_reason);
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: wsh_util_core.add_message(x_return_status);
990: FND_MSG_PUB.Count_And_Get(
991: p_count => x_msg_count,
992: p_data => x_msg_data,

Line 993: p_encoded => FND_API.G_FALSE

989: wsh_util_core.add_message(x_return_status);
990: FND_MSG_PUB.Count_And_Get(
991: p_count => x_msg_count,
992: p_data => x_msg_data,
993: p_encoded => FND_API.G_FALSE
994: );
995: --
996: -- Debug Statements
997: --

Line 1012: p_encoded => FND_API.G_FALSE

1008: wsh_util_core.add_message(x_return_status);
1009: FND_MSG_PUB.Count_And_Get(
1010: p_count => x_msg_count,
1011: p_data => x_msg_data,
1012: p_encoded => FND_API.G_FALSE
1013: );
1014: --
1015: -- Debug Statements
1016: --

Line 1031: p_encoded => FND_API.G_FALSE

1027: wsh_util_core.add_message(x_return_status);
1028: FND_MSG_PUB.Count_And_Get(
1029: p_count => x_msg_count,
1030: p_data => x_msg_data,
1031: p_encoded => FND_API.G_FALSE
1032: );
1033: --
1034: -- Debug Statements
1035: --

Line 1045: x_return_status := FND_API.G_RET_STS_ERROR;

1041:
1042: WHEN WSH_INVALID_TRIPNAME THEN
1043: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1044: FND_MESSAGE.SET_TOKEN('PARAMETER','Trip_Name');
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: wsh_util_core.add_message(x_return_status);
1047: FND_MSG_PUB.Count_And_Get(
1048: p_count => x_msg_count,
1049: p_data => x_msg_data,

Line 1050: p_encoded => FND_API.G_FALSE

1046: wsh_util_core.add_message(x_return_status);
1047: FND_MSG_PUB.Count_And_Get(
1048: p_count => x_msg_count,
1049: p_data => x_msg_data,
1050: p_encoded => FND_API.G_FALSE
1051: );
1052: --
1053: -- Debug Statements
1054: --

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060:
1061: WHEN WSH_INVALID_DELIVERY THEN
1062: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1063: FND_MESSAGE.SET_TOKEN('PARAMETER','Delivery_Name');
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: wsh_util_core.add_message(x_return_status);
1066: FND_MSG_PUB.Count_And_Get(
1067: p_count => x_msg_count,
1068: p_data => x_msg_data,

Line 1069: p_encoded => FND_API.G_FALSE

1065: wsh_util_core.add_message(x_return_status);
1066: FND_MSG_PUB.Count_And_Get(
1067: p_count => x_msg_count,
1068: p_data => x_msg_data,
1069: p_encoded => FND_API.G_FALSE
1070: );
1071: --
1072: -- Debug Statements
1073: --

Line 1082: x_return_status := FND_API.G_RET_STS_ERROR;

1078: --
1079: WHEN WSH_INVALID_CONSOL_DELIVERY THEN
1080: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_EXP');
1081: FND_MESSAGE.SET_TOKEN('PARAMETER',p_exception_rec.delivery_name);
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: wsh_util_core.add_message(x_return_status);
1084: FND_MSG_PUB.Count_And_Get(
1085: p_count => x_msg_count,
1086: p_data => x_msg_data,

Line 1087: p_encoded => FND_API.G_FALSE

1083: wsh_util_core.add_message(x_return_status);
1084: FND_MSG_PUB.Count_And_Get(
1085: p_count => x_msg_count,
1086: p_data => x_msg_data,
1087: p_encoded => FND_API.G_FALSE
1088: );
1089: --
1090: -- Debug Statements
1091: --

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR;

1096: --
1097:
1098: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN
1099: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_LOGGED_AT_LOCATION');
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: wsh_util_core.add_message(x_return_status);
1102: FND_MSG_PUB.Count_And_Get(
1103: p_count => x_msg_count,
1104: p_data => x_msg_data,

Line 1105: p_encoded => FND_API.G_FALSE

1101: wsh_util_core.add_message(x_return_status);
1102: FND_MSG_PUB.Count_And_Get(
1103: p_count => x_msg_count,
1104: p_data => x_msg_data,
1105: p_encoded => FND_API.G_FALSE
1106: );
1107: --
1108: -- Debug Statements
1109: --

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR;

1114: --
1115:
1116: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN
1117: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_EXCEPTION_LOCATION');
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: wsh_util_core.add_message(x_return_status);
1120: FND_MSG_PUB.Count_And_Get(
1121: p_count => x_msg_count,
1122: p_data => x_msg_data,

Line 1123: p_encoded => FND_API.G_FALSE

1119: wsh_util_core.add_message(x_return_status);
1120: FND_MSG_PUB.Count_And_Get(
1121: p_count => x_msg_count,
1122: p_data => x_msg_data,
1123: p_encoded => FND_API.G_FALSE
1124: );
1125: --
1126: -- Debug Statements
1127: --

Line 1139: x_return_status := FND_API.G_RET_STS_ERROR;

1135: IF C1%ISOPEN THEN
1136: CLOSE C1;
1137: END IF;
1138: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOCATION');
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: wsh_util_core.add_message(x_return_status);
1141: FND_MSG_PUB.Count_And_Get(
1142: p_count => x_msg_count,
1143: p_data => x_msg_data,

Line 1144: p_encoded => FND_API.G_FALSE

1140: wsh_util_core.add_message(x_return_status);
1141: FND_MSG_PUB.Count_And_Get(
1142: p_count => x_msg_count,
1143: p_data => x_msg_data,
1144: p_encoded => FND_API.G_FALSE
1145: );
1146: --
1147: -- Debug Statements
1148: --

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: CLOSE C2;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1160: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Delivery_Detail_Id');
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: wsh_util_core.add_message(x_return_status);
1163: FND_MSG_PUB.Count_And_Get(
1164: p_count => x_msg_count,
1165: p_data => x_msg_data,

Line 1166: p_encoded => FND_API.G_FALSE

1162: wsh_util_core.add_message(x_return_status);
1163: FND_MSG_PUB.Count_And_Get(
1164: p_count => x_msg_count,
1165: p_data => x_msg_data,
1166: p_encoded => FND_API.G_FALSE
1167: );
1168: --
1169: -- Debug Statements
1170: --

Line 1183: x_return_status := FND_API.G_RET_STS_ERROR;

1179: CLOSE C_del_detail;
1180: END IF;
1181: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1182: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Container_Name');
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: wsh_util_core.add_message(x_return_status);
1185: FND_MSG_PUB.Count_And_Get(
1186: p_count => x_msg_count,
1187: p_data => x_msg_data,

Line 1188: p_encoded => FND_API.G_FALSE

1184: wsh_util_core.add_message(x_return_status);
1185: FND_MSG_PUB.Count_And_Get(
1186: p_count => x_msg_count,
1187: p_data => x_msg_data,
1188: p_encoded => FND_API.G_FALSE
1189: );
1190: --
1191: -- Debug Statements
1192: --

Line 1200: x_return_status := FND_API.G_RET_STS_ERROR;

1196: END IF;
1197: --
1198:
1199: WHEN WSH_INVALID_INVENTORY_CONTROL THEN
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: --
1202: -- Debug Statements
1203: --
1204: IF l_debug_on THEN

Line 1212: x_return_status := FND_API.G_RET_STS_ERROR;

1208: --
1209:
1210: WHEN WSH_XC_INVALID_DATE THEN
1211: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_DATE');
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: wsh_util_core.add_message(x_return_status);
1214: FND_MSG_PUB.Count_And_Get(
1215: p_count => x_msg_count,
1216: p_data => x_msg_data,

Line 1217: p_encoded => FND_API.G_FALSE

1213: wsh_util_core.add_message(x_return_status);
1214: FND_MSG_PUB.Count_And_Get(
1215: p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE
1218: );
1219: --
1220: -- Debug Statements
1221: --

Line 1242: p_encoded => FND_API.G_FALSE

1238: END IF;
1239: FND_MSG_PUB.Count_And_Get
1240: ( p_count => x_msg_count,
1241: p_data => x_msg_data,
1242: p_encoded => FND_API.G_FALSE
1243: );
1244:
1245: --
1246: -- Debug Statements

Line 1269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1265:
1266: PROCEDURE Purge_Exception (
1267: -- Standard parameters
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1270: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1271: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1272: x_msg_count OUT NOCOPY NUMBER,
1273: x_msg_data OUT NOCOPY VARCHAR2,

Line 1270: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1266: PROCEDURE Purge_Exception (
1267: -- Standard parameters
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1270: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1271: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1272: x_msg_count OUT NOCOPY NUMBER,
1273: x_msg_data OUT NOCOPY VARCHAR2,
1274: x_return_status OUT NOCOPY VARCHAR2,

Line 1271: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1267: -- Standard parameters
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1270: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1271: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1272: x_msg_count OUT NOCOPY NUMBER,
1273: x_msg_data OUT NOCOPY VARCHAR2,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275:

Line 1376: IF NOT FND_API.compatible_api_call (

1372: wsh_debug_sv.log (l_module_name,'delivery_name', p_exception_rec.delivery_name);
1373: wsh_debug_sv.log (l_module_name,'data_older_no_of_days', p_exception_rec.data_older_no_of_days);
1374: END IF;
1375:
1376: IF NOT FND_API.compatible_api_call (
1377: l_api_version,
1378: p_api_version,
1379: l_api_name,
1380: G_PKG_NAME) THEN

Line 1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1377: l_api_version,
1378: p_api_version,
1379: l_api_name,
1380: G_PKG_NAME) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END IF;
1383:
1384: -- Check p_init_msg_list
1385: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1385: IF FND_API.to_boolean(p_init_msg_list) THEN

1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END IF;
1383:
1384: -- Check p_init_msg_list
1385: IF FND_API.to_boolean(p_init_msg_list) THEN
1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1569: p_init_msg_list => FND_API.G_FALSE,

1565: END IF;
1566: --
1567: WSH_XC_UTIL.Purge(
1568: p_api_version => p_api_version,
1569: p_init_msg_list => FND_API.G_FALSE,
1570: p_commit => FND_API.G_FALSE,
1571: p_validation_level => p_validation_level,
1572: x_return_status => l_return_status,
1573: x_msg_count => x_msg_count,

Line 1570: p_commit => FND_API.G_FALSE,

1566: --
1567: WSH_XC_UTIL.Purge(
1568: p_api_version => p_api_version,
1569: p_init_msg_list => FND_API.G_FALSE,
1570: p_commit => FND_API.G_FALSE,
1571: p_validation_level => p_validation_level,
1572: x_return_status => l_return_status,
1573: x_msg_count => x_msg_count,
1574: x_msg_data => x_msg_data,

Line 1609: p_encoded => FND_API.G_FALSE

1605:
1606: FND_MSG_PUB.Count_And_Get(
1607: p_count => x_msg_count,
1608: p_data => x_msg_data,
1609: p_encoded => FND_API.G_FALSE
1610: );
1611: --
1612: -- Debug Statements
1613: --

Line 1630: p_encoded => FND_API.G_FALSE

1626: wsh_util_core.add_message(x_return_status);
1627: FND_MSG_PUB.Count_And_Get(
1628: p_count => x_msg_count,
1629: p_data => x_msg_data,
1630: p_encoded => FND_API.G_FALSE
1631: );
1632: --
1633: -- Debug Statements
1634: --

Line 1648: p_encoded => FND_API.G_FALSE

1644: wsh_util_core.add_message(x_return_status);
1645: FND_MSG_PUB.Count_And_Get(
1646: p_count => x_msg_count,
1647: p_data => x_msg_data,
1648: p_encoded => FND_API.G_FALSE
1649: );
1650: --
1651: -- Debug Statements
1652: --

Line 1666: p_encoded => FND_API.G_FALSE

1662: wsh_util_core.add_message(x_return_status);
1663: FND_MSG_PUB.Count_And_Get(
1664: p_count => x_msg_count,
1665: p_data => x_msg_data,
1666: p_encoded => FND_API.G_FALSE
1667: );
1668: --
1669: -- Debug Statements
1670: --

Line 1684: p_encoded => FND_API.G_FALSE

1680: wsh_util_core.add_message(x_return_status);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count,
1683: p_data => x_msg_data,
1684: p_encoded => FND_API.G_FALSE
1685: );
1686: --
1687: -- Debug Statements
1688: --

Line 1703: p_encoded => FND_API.G_FALSE

1699: wsh_util_core.add_message(x_return_status);
1700: FND_MSG_PUB.Count_And_Get(
1701: p_count => x_msg_count,
1702: p_data => x_msg_data,
1703: p_encoded => FND_API.G_FALSE
1704: );
1705: --
1706: -- Debug Statements
1707: --

Line 1722: p_encoded => FND_API.G_FALSE

1718: wsh_util_core.add_message(x_return_status);
1719: FND_MSG_PUB.Count_And_Get(
1720: p_count => x_msg_count,
1721: p_data => x_msg_data,
1722: p_encoded => FND_API.G_FALSE
1723: );
1724: --
1725: -- Debug Statements
1726: --

Line 1741: p_encoded => FND_API.G_FALSE

1737: wsh_util_core.add_message(x_return_status);
1738: FND_MSG_PUB.Count_And_Get(
1739: p_count => x_msg_count,
1740: p_data => x_msg_data,
1741: p_encoded => FND_API.G_FALSE
1742: );
1743: --
1744: -- Debug Statements
1745: --

Line 1760: p_encoded => FND_API.G_FALSE

1756: wsh_util_core.add_message(x_return_status);
1757: FND_MSG_PUB.Count_And_Get(
1758: p_count => x_msg_count,
1759: p_data => x_msg_data,
1760: p_encoded => FND_API.G_FALSE
1761: );
1762: --
1763: -- Debug Statements
1764: --

Line 1778: p_encoded => FND_API.G_FALSE

1774: wsh_util_core.add_message(x_return_status);
1775: FND_MSG_PUB.Count_And_Get(
1776: p_count => x_msg_count,
1777: p_data => x_msg_data,
1778: p_encoded => FND_API.G_FALSE
1779: );
1780: --
1781: -- Debug Statements
1782: --

Line 1796: p_encoded => FND_API.G_FALSE

1792: wsh_util_core.add_message(x_return_status);
1793: FND_MSG_PUB.Count_And_Get(
1794: p_count => x_msg_count,
1795: p_data => x_msg_data,
1796: p_encoded => FND_API.G_FALSE
1797: );
1798: --
1799: -- Debug Statements
1800: --

Line 1814: p_encoded => FND_API.G_FALSE

1810: wsh_util_core.add_message(x_return_status);
1811: FND_MSG_PUB.Count_And_Get(
1812: p_count => x_msg_count,
1813: p_data => x_msg_data,
1814: p_encoded => FND_API.G_FALSE
1815: );
1816: --
1817: -- Debug Statements
1818: --

Line 1839: p_encoded => FND_API.G_FALSE

1835: END IF;
1836: FND_MSG_PUB.Count_And_Get
1837: ( p_count => x_msg_count,
1838: p_data => x_msg_data,
1839: p_encoded => FND_API.G_FALSE
1840: );
1841: --
1842: -- Debug Statements
1843: --

Line 1866: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1862:
1863: PROCEDURE Exception_Action (
1864: -- Standard parameters
1865: p_api_version IN NUMBER,
1866: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1867: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1868: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1869: x_msg_count OUT NOCOPY NUMBER,
1870: x_msg_data OUT NOCOPY VARCHAR2,

Line 1867: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1863: PROCEDURE Exception_Action (
1864: -- Standard parameters
1865: p_api_version IN NUMBER,
1866: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1867: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1868: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1869: x_msg_count OUT NOCOPY NUMBER,
1870: x_msg_data OUT NOCOPY VARCHAR2,
1871: x_return_status OUT NOCOPY VARCHAR2,

Line 1868: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1864: -- Standard parameters
1865: p_api_version IN NUMBER,
1866: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1867: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1868: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1869: x_msg_count OUT NOCOPY NUMBER,
1870: x_msg_data OUT NOCOPY VARCHAR2,
1871: x_return_status OUT NOCOPY VARCHAR2,
1872:

Line 1917: IF NOT FND_API.compatible_api_call(

1913: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1914: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
1915: END IF;
1916:
1917: IF NOT FND_API.compatible_api_call(
1918: l_api_version,
1919: p_api_version,
1920: l_api_name,
1921: G_PKG_NAME) THEN

Line 1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1918: l_api_version,
1919: p_api_version,
1920: l_api_name,
1921: G_PKG_NAME) THEN
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;
1924:
1925: -- Check p_init_msg_list
1926: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1926: IF FND_API.to_boolean(p_init_msg_list) THEN

1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;
1924:
1925: -- Check p_init_msg_list
1926: IF FND_API.to_boolean(p_init_msg_list) THEN
1927: FND_MSG_PUB.initialize;
1928: END IF;
1929:
1930: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1941: p_init_msg_list => FND_API.G_FALSE,

1937: -- Call the private API if the action requested is PURGE
1938: IF l_action = 'PURGE' THEN
1939: Purge_Exception(
1940: p_api_version => p_api_version,
1941: p_init_msg_list => FND_API.G_FALSE,
1942: p_validation_level => p_validation_level,
1943: p_commit => FND_API.G_FALSE,
1944: x_msg_count => x_msg_count,
1945: x_msg_data => x_msg_data,

Line 1943: p_commit => FND_API.G_FALSE,

1939: Purge_Exception(
1940: p_api_version => p_api_version,
1941: p_init_msg_list => FND_API.G_FALSE,
1942: p_validation_level => p_validation_level,
1943: p_commit => FND_API.G_FALSE,
1944: x_msg_count => x_msg_count,
1945: x_msg_data => x_msg_data,
1946: x_return_status => l_return_status,
1947:

Line 1959: p_init_msg_list => FND_API.G_FALSE,

1955: -- Call the private API if the action requested is LOG
1956: IF l_action = 'LOG' THEN
1957: Log_Exception(
1958: p_api_version => p_api_version,
1959: p_init_msg_list => FND_API.G_FALSE,
1960: p_validation_level => p_validation_level,
1961: p_commit => FND_API.G_FALSE,
1962: x_msg_count => x_msg_count,
1963: x_msg_data => x_msg_data,

Line 1961: p_commit => FND_API.G_FALSE,

1957: Log_Exception(
1958: p_api_version => p_api_version,
1959: p_init_msg_list => FND_API.G_FALSE,
1960: p_validation_level => p_validation_level,
1961: p_commit => FND_API.G_FALSE,
1962: x_msg_count => x_msg_count,
1963: x_msg_data => x_msg_data,
1964: x_return_status => l_return_status,
1965:

Line 2000: p_init_msg_list => FND_API.G_FALSE,

1996:
1997: -- Call the private API if the action requested is CHANGE_STATUS
1998: Change_Status(
1999: p_api_version => p_api_version,
2000: p_init_msg_list => FND_API.G_FALSE,
2001: p_validation_level => p_validation_level,
2002: p_commit => FND_API.G_FALSE,
2003: x_msg_count => x_msg_count,
2004: x_msg_data => x_msg_data,

Line 2002: p_commit => FND_API.G_FALSE,

1998: Change_Status(
1999: p_api_version => p_api_version,
2000: p_init_msg_list => FND_API.G_FALSE,
2001: p_validation_level => p_validation_level,
2002: p_commit => FND_API.G_FALSE,
2003: x_msg_count => x_msg_count,
2004: x_msg_data => x_msg_data,
2005: x_return_status => l_return_status,
2006:

Line 2028: FND_API.To_Boolean(p_commit) THEN

2024: x_return_status := l_return_status;
2025: END IF;
2026:
2027: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) AND
2028: FND_API.To_Boolean(p_commit) THEN
2029: COMMIT WORK;
2030: END IF;
2031:
2032: FND_MSG_PUB.Count_And_Get(

Line 2035: p_encoded => FND_API.G_FALSE

2031:
2032: FND_MSG_PUB.Count_And_Get(
2033: p_count => x_msg_count,
2034: p_data => x_msg_data,
2035: p_encoded => FND_API.G_FALSE
2036: );
2037: --
2038: -- Debug Statements
2039: --

Line 2054: p_encoded => FND_API.G_FALSE

2050: wsh_util_core.add_message(x_return_status);
2051: FND_MSG_PUB.Count_And_Get(
2052: p_count => x_msg_count,
2053: p_data => x_msg_data,
2054: p_encoded => FND_API.G_FALSE
2055: );
2056: --
2057: -- Debug Statements
2058: --

Line 2079: p_encoded => FND_API.G_FALSE

2075: END IF;
2076: FND_MSG_PUB.Count_And_Get
2077: ( p_count => x_msg_count,
2078: p_data => x_msg_data,
2079: p_encoded => FND_API.G_FALSE
2080: );
2081: --
2082: -- Debug Statements
2083: --