45: END IF;
46:
47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
50: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_ITEM');
51: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
52: FND_MSG_PUB.Add;
53: END IF;
48: WHEN NO_DATA_FOUND THEN
49: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
50: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_ITEM');
51: FND_MESSAGE.SET_TOKEN('ITEM', p_item);
52: FND_MSG_PUB.Add;
53: END IF;
54: RETURN G_FALSE;
55:
56: WHEN OTHERS THEN
104: END IF;
105:
106: EXCEPTION
107: WHEN NO_DATA_FOUND THEN
108: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
109: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CAS_NUMBER');
110: FND_MESSAGE.SET_TOKEN('CAS_NUMBER', p_cas_number);
111: FND_MSG_PUB.Add;
112: END IF;
107: WHEN NO_DATA_FOUND THEN
108: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
109: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CAS_NUMBER');
110: FND_MESSAGE.SET_TOKEN('CAS_NUMBER', p_cas_number);
111: FND_MSG_PUB.Add;
112: END IF;
113: RETURN G_FALSE;
114:
115: WHEN OTHERS THEN
155: END IF;
156:
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
160: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CODE');
161: FND_MESSAGE.SET_TOKEN('CODE', p_document_code);
162: FND_MSG_PUB.Add;
163: END IF;
158: WHEN NO_DATA_FOUND THEN
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
160: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CODE');
161: FND_MESSAGE.SET_TOKEN('CODE', p_document_code);
162: FND_MSG_PUB.Add;
163: END IF;
164: RETURN G_FALSE;
165:
166: WHEN OTHERS THEN
203: END IF;
204:
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
208: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
209: FND_MESSAGE.SET_TOKEN('DISCLOSURE_CODE', p_disclosure_code);
210: FND_MSG_PUB.Add;
211: END IF;
206: WHEN NO_DATA_FOUND THEN
207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
208: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
209: FND_MESSAGE.SET_TOKEN('DISCLOSURE_CODE', p_disclosure_code);
210: FND_MSG_PUB.Add;
211: END IF;
212: RETURN G_FALSE;
213:
214: WHEN OTHERS THEN
255: END IF;
256:
257: EXCEPTION
258: WHEN NO_DATA_FOUND THEN
259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
261: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
262: FND_MSG_PUB.Add;
263: END IF;
258: WHEN NO_DATA_FOUND THEN
259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
261: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
262: FND_MSG_PUB.Add;
263: END IF;
264:
265: RETURN G_FALSE;
266:
303: END IF;
304:
305: EXCEPTION
306: WHEN NO_DATA_FOUND THEN
307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
308: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT');
309: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
310: FND_MSG_PUB.Add;
311: END IF;
306: WHEN NO_DATA_FOUND THEN
307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
308: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT');
309: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
310: FND_MSG_PUB.Add;
311: END IF;
312:
313: RETURN G_FALSE;
314:
352: END IF;
353:
354: EXCEPTION
355: WHEN NO_DATA_FOUND THEN
356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
357: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE');
358: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
359: FND_MSG_PUB.Add;
360: END IF;
355: WHEN NO_DATA_FOUND THEN
356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
357: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE');
358: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
359: FND_MSG_PUB.Add;
360: END IF;
361: RETURN G_FALSE;
362:
363: WHEN OTHERS THEN