29:
30: IF p_header_id IS NULL OR
31: p_header_id = FND_API.G_MISS_NUM
32: THEN
33: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
36: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_HEADER_ID'),FALSE); -- ND
37: FND_MSG_PUB.Add;
33: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
36: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_HEADER_ID'),FALSE); -- ND
37: FND_MSG_PUB.Add;
38: END IF;
39: RETURN F;
40: END IF;
41: return T;
68: EXCEPTION
69:
70: WHEN NO_DATA_FOUND THEN
71:
72: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
73: THEN
74:
75: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_HEADER_STATUS'),FALSE); -- ND
73: THEN
74:
75: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_HEADER_STATUS'),FALSE); -- ND
77: FND_MSG_PUB.Add;
78:
79: END IF;
80:
81: RETURN F;
81: RETURN F;
82:
83: WHEN OTHERS THEN
84:
85: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
86: THEN
87: FND_MSG_PUB.Add_Exc_Msg
88: ( G_PKG_NAME
89: , 'Header_Status'
83: WHEN OTHERS THEN
84:
85: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
86: THEN
87: FND_MSG_PUB.Add_Exc_Msg
88: ( G_PKG_NAME
89: , 'Header_Status'
90: );
91: END IF;
118:
119: IF p_request_number IS NULL OR
120: p_request_number = FND_API.G_MISS_CHAR
121: THEN
122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
123: THEN
124: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REQUEST_NUMBER'),FALSE); -- ND
126: FND_MSG_PUB.Add;
122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
123: THEN
124: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REQUEST_NUMBER'),FALSE); -- ND
126: FND_MSG_PUB.Add;
127: END IF;
128: RETURN F;
129:
130:
178: IF p_trohdr_rec.organization_id IS NULL
179: THEN
180: l_return_status := FND_API.G_RET_STS_ERROR;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
183: THEN
184: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_id ');
186: FND_MSG_PUB.Add;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
183: THEN
184: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_id ');
186: FND_MSG_PUB.Add;
187: END IF;
188: END IF;
189:
190: IF p_trohdr_rec.header_id IS NULL
190: IF p_trohdr_rec.header_id IS NULL
191: THEN
192: l_return_status := FND_API.G_RET_STS_ERROR;
193:
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header Id');
198: FND_MSG_PUB.Add;
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header Id');
198: FND_MSG_PUB.Add;
199: END IF;
200: END IF;
201:
202: --
247: WHEN OTHERS THEN
248:
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250:
251: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: FND_MSG_PUB.Add_Exc_Msg
254: ( G_PKG_NAME
255: , 'Entity'
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250:
251: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: FND_MSG_PUB.Add_Exc_Msg
254: ( G_PKG_NAME
255: , 'Entity'
256: );
257: END IF;
622: WHEN OTHERS THEN
623:
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625:
626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg
629: ( G_PKG_NAME
630: , 'Attributes'
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625:
626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg
629: ( G_PKG_NAME
630: , 'Attributes'
631: );
632: END IF;
664: WHEN OTHERS THEN
665:
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667:
668: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
669: THEN
670: FND_MSG_PUB.Add_Exc_Msg
671: ( G_PKG_NAME
672: , 'Entity_Delete'
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667:
668: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
669: THEN
670: FND_MSG_PUB.Add_Exc_Msg
671: ( G_PKG_NAME
672: , 'Entity_Delete'
673: );
674: END IF;