DBA Data[Home] [Help]

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on FND_MESSAGE

Line 107: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_OVERSIZED');

103: IF (p_exception_message IS NOT NULL) THEN
104: l_exception_message := p_exception_message;
105: ELSE
106: IF (p_exception_name = 'WSH_OTM_DEL_OVERSIZED') THEN
107: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_OVERSIZED');
108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
109: p_delivery_rec.entity_name);
110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
111: p_delivery_rec.gross_weight);

Line 108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',

104: l_exception_message := p_exception_message;
105: ELSE
106: IF (p_exception_name = 'WSH_OTM_DEL_OVERSIZED') THEN
107: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_OVERSIZED');
108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
109: p_delivery_rec.entity_name);
110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
111: p_delivery_rec.gross_weight);
112: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',

Line 110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',

106: IF (p_exception_name = 'WSH_OTM_DEL_OVERSIZED') THEN
107: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_OVERSIZED');
108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
109: p_delivery_rec.entity_name);
110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
111: p_delivery_rec.gross_weight);
112: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
113: p_weight_limit);
114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',

Line 112: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',

108: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
109: p_delivery_rec.entity_name);
110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
111: p_delivery_rec.gross_weight);
112: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
113: p_weight_limit);
114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
115: p_content_weight);
116: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_FAIL') THEN

Line 114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',

110: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
111: p_delivery_rec.gross_weight);
112: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
113: p_weight_limit);
114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
115: p_content_weight);
116: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_FAIL') THEN
117: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_SPLIT_FAILED');
118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',

Line 117: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_SPLIT_FAILED');

113: p_weight_limit);
114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
115: p_content_weight);
116: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_FAIL') THEN
117: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_SPLIT_FAILED');
118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
119: p_delivery_rec.entity_name);
120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
121: p_delivery_rec.gross_weight);

Line 118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',

114: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
115: p_content_weight);
116: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_FAIL') THEN
117: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_SPLIT_FAILED');
118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
119: p_delivery_rec.entity_name);
120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
121: p_delivery_rec.gross_weight);
122: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',

Line 120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',

116: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_FAIL') THEN
117: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DEL_SPLIT_FAILED');
118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
119: p_delivery_rec.entity_name);
120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
121: p_delivery_rec.gross_weight);
122: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
123: p_weight_limit);
124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',

Line 122: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',

118: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
119: p_delivery_rec.entity_name);
120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
121: p_delivery_rec.gross_weight);
122: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
123: p_weight_limit);
124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
125: p_content_weight);
126: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_CHILD') THEN

Line 124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',

120: FND_MESSAGE.SET_TOKEN('GROSS_WEIGHT',
121: p_delivery_rec.gross_weight);
122: FND_MESSAGE.SET_TOKEN('WEIGHT_LIMIT',
123: p_weight_limit);
124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
125: p_content_weight);
126: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_CHILD') THEN
127: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_CHILD');
128: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME',

Line 127: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_CHILD');

123: p_weight_limit);
124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
125: p_content_weight);
126: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_CHILD') THEN
127: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_CHILD');
128: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME',
129: p_new_delivery_name);
130: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME',
131: p_delivery_rec.entity_name);

Line 128: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME',

124: FND_MESSAGE.SET_TOKEN('DEL_DET_WEIGHT',
125: p_content_weight);
126: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_CHILD') THEN
127: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_CHILD');
128: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME',
129: p_new_delivery_name);
130: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME',
131: p_delivery_rec.entity_name);
132: ELSIF (p_exception_name = 'WSH_OTM_DEL_LOCK_FAIL') THEN

Line 130: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME',

126: ELSIF (p_exception_name = 'WSH_OTM_DEL_SPLIT_CHILD') THEN
127: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_CHILD');
128: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME',
129: p_new_delivery_name);
130: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME',
131: p_delivery_rec.entity_name);
132: ELSIF (p_exception_name = 'WSH_OTM_DEL_LOCK_FAIL') THEN
133: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');
134: ELSIF (p_exception_name IN ('WSH_OTM_DEL_SPLIT_LARGE', 'WSH_OTM_DEL_SPLIT')) THEN

Line 133: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');

129: p_new_delivery_name);
130: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME',
131: p_delivery_rec.entity_name);
132: ELSIF (p_exception_name = 'WSH_OTM_DEL_LOCK_FAIL') THEN
133: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');
134: ELSIF (p_exception_name IN ('WSH_OTM_DEL_SPLIT_LARGE', 'WSH_OTM_DEL_SPLIT')) THEN
135: --the caller API (which is in this file since this is internal api) should provide the
136: --message for these two exceptions due to complication, this is not expected
137: IF l_debug_on THEN

Line 143: l_exception_message := FND_MESSAGE.Get;

139: END IF;
140: RAISE unexp_error;
141: END IF;
142:
143: l_exception_message := FND_MESSAGE.Get;
144:
145: END IF;
146:
147: IF (l_exception_message IS NULL) THEN

Line 382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');

378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
379: l_num_warn := l_num_warn + 1;
380: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
381: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
382: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
383: wsh_util_core.add_message(l_return_status,l_module_name);
384:
385: x_return_status := l_return_status;
386: --

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

570: ELSIF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
572:
573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
576: wsh_util_core.get_org_name(p_delivery_tab(i).organization_id));
577: wsh_util_core.add_message(l_return_status,l_module_name);
578: l_num_error := l_num_error+1;

Line 575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',

571: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
572:
573: ROLLBACK TO delivery_record;
574: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
575: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
576: wsh_util_core.get_org_name(p_delivery_tab(i).organization_id));
577: wsh_util_core.add_message(l_return_status,l_module_name);
578: l_num_error := l_num_error+1;
579:

Line 1312: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_LARGE');

1308: --after the delivery is split, need to log exception on delivery to inform the user
1309: --generating exception message based on number of deliveries split.
1310: IF (l_count > 6) THEN
1311: l_exception_name := 'WSH_OTM_DEL_SPLIT_LARGE';
1312: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_LARGE');
1313: ELSE
1314: l_exception_name := 'WSH_OTM_DEL_SPLIT';
1315: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT');
1316: END IF;

Line 1315: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT');

1311: l_exception_name := 'WSH_OTM_DEL_SPLIT_LARGE';
1312: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT_LARGE');
1313: ELSE
1314: l_exception_name := 'WSH_OTM_DEL_SPLIT';
1315: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT');
1316: END IF;
1317:
1318: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME', l_curr_del_split_name(1));
1319:

Line 1318: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME', l_curr_del_split_name(1));

1314: l_exception_name := 'WSH_OTM_DEL_SPLIT';
1315: FND_MESSAGE.SET_NAME('WSH', 'WSH_OTM_DELIVERY_SPLIT');
1316: END IF;
1317:
1318: FND_MESSAGE.SET_TOKEN('PARENT_DELIVERY_NAME', l_curr_del_split_name(1));
1319:
1320: --setting child delivery name 1-5 in the message
1321: FOR z IN 2..6 LOOP
1322: IF (l_count >= z) THEN

Line 1323: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), l_curr_del_split_name(z));

1319:
1320: --setting child delivery name 1-5 in the message
1321: FOR z IN 2..6 LOOP
1322: IF (l_count >= z) THEN
1323: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), l_curr_del_split_name(z));
1324: ELSE
1325: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), NULL);
1326: END IF;
1327: END LOOP;

Line 1325: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), NULL);

1321: FOR z IN 2..6 LOOP
1322: IF (l_count >= z) THEN
1323: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), l_curr_del_split_name(z));
1324: ELSE
1325: FND_MESSAGE.SET_TOKEN('CHILD_DELIVERY_NAME' || to_char(z-1), NULL);
1326: END IF;
1327: END LOOP;
1328:
1329: IF l_debug_on THEN

Line 1337: p_exception_message => FND_MESSAGE.get,

1333: log_del_splitter_exception
1334: (p_delivery_rec => p_delivery_tab(i),
1335: p_content_weight => NULL,
1336: p_weight_limit => NULL,
1337: p_exception_message => FND_MESSAGE.get,
1338: p_exception_name => l_exception_name,
1339: x_return_status => l_return_status);
1340:
1341: IF l_debug_on THEN

Line 1466: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');

1462:
1463: WHEN NO_DATA_FOUND THEN
1464:
1465: ROLLBACK TO delivery_record;
1466: FND_MESSAGE.Set_Name('WSH','WSH_DEL_NOT_FOUND');
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1468: --
1469: IF (c_get_delivery_line_and_cont%ISOPEN) THEN
1470: CLOSE c_get_delivery_line_and_cont;