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.MRP_VALIDATE_ASSIGNMENT_SET dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: -- Check required attributes.
21:

Line 25: l_return_status := FND_API.G_RET_STS_ERROR;

21:
22: IF p_Assignment_Set_rec.Assignment_Set_Id IS NULL
23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:

Line 45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

41:
42:
43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;
50:
51: --

Line 67: WHEN FND_API.G_EXC_ERROR THEN

63: x_return_status := l_return_status;
64:
65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: FND_MSG_PUB.Add_Exc_Msg

Line 96: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

92: ( x_return_status OUT NOCOPY VARCHAR2
93: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
94: )
95: IS
96: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
97: BEGIN
98:
99: -- Validate entity delete.
100:

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: x_return_status := l_return_status;
106:
107: EXCEPTION
108:
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

107: EXCEPTION
108:
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: x_return_status := FND_API.G_RET_STS_ERROR;
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114:
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
122: THEN
123: FND_MSG_PUB.Add_Exc_Msg

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: )
139: IS
140: BEGIN
141:
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: -- Validate Assignment_Set attributes
145:
146: IF (p_Assignment_Set_rec.Assignment_Set_Id IS NOT NULL AND

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: IF NOT MRP_Validate.Assignment_Set
152: ( p_Assignment_Set_rec.Assignment_Set_Id
153: )
154: THEN
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: END IF;
157: END IF;
158:
159: IF p_Assignment_Set_rec.Assignment_Set_Name IS NOT NULL AND

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: p_old_Assignment_Set_rec.Assignment_Set_Name OR
162: p_old_Assignment_Set_rec.Assignment_Set_Name IS NULL )
163: THEN
164: IF NOT Val_Assignment_Set_Name(p_Assignment_Set_rec.Assignment_Set_Name) THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: END IF;
167: END IF;
168:
169: IF p_Assignment_Set_rec.Attribute1 IS NOT NULL AND

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: p_old_Assignment_Set_rec.Attribute1 OR
172: p_old_Assignment_Set_rec.Attribute1 IS NULL )
173: THEN
174: IF NOT Val_Attribute1(p_Assignment_Set_rec.Attribute1) THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: END IF;
177: END IF;
178:
179: IF p_Assignment_Set_rec.Attribute10 IS NOT NULL AND

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: p_old_Assignment_Set_rec.Attribute10 OR
182: p_old_Assignment_Set_rec.Attribute10 IS NULL )
183: THEN
184: IF NOT Val_Attribute10(p_Assignment_Set_rec.Attribute10) THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: END IF;
187: END IF;
188:
189: IF p_Assignment_Set_rec.Attribute11 IS NOT NULL AND

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: p_old_Assignment_Set_rec.Attribute11 OR
192: p_old_Assignment_Set_rec.Attribute11 IS NULL )
193: THEN
194: IF NOT Val_Attribute11(p_Assignment_Set_rec.Attribute11) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: END IF;
197: END IF;
198:
199: IF p_Assignment_Set_rec.Attribute12 IS NOT NULL AND

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: p_old_Assignment_Set_rec.Attribute12 OR
202: p_old_Assignment_Set_rec.Attribute12 IS NULL )
203: THEN
204: IF NOT Val_Attribute12(p_Assignment_Set_rec.Attribute12) THEN
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: END IF;
207: END IF;
208:
209: IF p_Assignment_Set_rec.Attribute13 IS NOT NULL AND

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: p_old_Assignment_Set_rec.Attribute13 OR
212: p_old_Assignment_Set_rec.Attribute13 IS NULL )
213: THEN
214: IF NOT Val_Attribute13(p_Assignment_Set_rec.Attribute13) THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: END IF;
217: END IF;
218:
219: IF p_Assignment_Set_rec.Attribute14 IS NOT NULL AND

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: p_old_Assignment_Set_rec.Attribute14 OR
222: p_old_Assignment_Set_rec.Attribute14 IS NULL )
223: THEN
224: IF NOT Val_Attribute14(p_Assignment_Set_rec.Attribute14) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: END IF;
227: END IF;
228:
229: IF p_Assignment_Set_rec.Attribute15 IS NOT NULL AND

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: p_old_Assignment_Set_rec.Attribute15 OR
232: p_old_Assignment_Set_rec.Attribute15 IS NULL )
233: THEN
234: IF NOT Val_Attribute15(p_Assignment_Set_rec.Attribute15) THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: END IF;
237: END IF;
238:
239: IF p_Assignment_Set_rec.Attribute2 IS NOT NULL AND

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: p_old_Assignment_Set_rec.Attribute2 OR
242: p_old_Assignment_Set_rec.Attribute2 IS NULL )
243: THEN
244: IF NOT Val_Attribute2(p_Assignment_Set_rec.Attribute2) THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247: END IF;
248:
249: IF p_Assignment_Set_rec.Attribute3 IS NOT NULL AND

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: p_old_Assignment_Set_rec.Attribute3 OR
252: p_old_Assignment_Set_rec.Attribute3 IS NULL )
253: THEN
254: IF NOT Val_Attribute3(p_Assignment_Set_rec.Attribute3) THEN
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257: END IF;
258:
259: IF p_Assignment_Set_rec.Attribute4 IS NOT NULL AND

Line 265: x_return_status := FND_API.G_RET_STS_ERROR;

261: p_old_Assignment_Set_rec.Attribute4 OR
262: p_old_Assignment_Set_rec.Attribute4 IS NULL )
263: THEN
264: IF NOT Val_Attribute4(p_Assignment_Set_rec.Attribute4) THEN
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;
267: END IF;
268:
269: IF p_Assignment_Set_rec.Attribute5 IS NOT NULL AND

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: p_old_Assignment_Set_rec.Attribute5 OR
272: p_old_Assignment_Set_rec.Attribute5 IS NULL )
273: THEN
274: IF NOT Val_Attribute5(p_Assignment_Set_rec.Attribute5) THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277: END IF;
278:
279: IF p_Assignment_Set_rec.Attribute6 IS NOT NULL AND

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: p_old_Assignment_Set_rec.Attribute6 OR
282: p_old_Assignment_Set_rec.Attribute6 IS NULL )
283: THEN
284: IF NOT Val_Attribute6(p_Assignment_Set_rec.Attribute6) THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287: END IF;
288:
289: IF p_Assignment_Set_rec.Attribute7 IS NOT NULL AND

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: p_old_Assignment_Set_rec.Attribute7 OR
292: p_old_Assignment_Set_rec.Attribute7 IS NULL )
293: THEN
294: IF NOT Val_Attribute7(p_Assignment_Set_rec.Attribute7) THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: END IF;
297: END IF;
298:
299: IF p_Assignment_Set_rec.Attribute8 IS NOT NULL AND

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: p_old_Assignment_Set_rec.Attribute8 OR
302: p_old_Assignment_Set_rec.Attribute8 IS NULL )
303: THEN
304: IF NOT Val_Attribute8(p_Assignment_Set_rec.Attribute8) THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: END IF;
307: END IF;
308:
309: IF p_Assignment_Set_rec.Attribute9 IS NOT NULL AND

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: p_old_Assignment_Set_rec.Attribute9 OR
312: p_old_Assignment_Set_rec.Attribute9 IS NULL )
313: THEN
314: IF NOT Val_Attribute9(p_Assignment_Set_rec.Attribute9) THEN
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: END IF;
317: END IF;
318:
319: IF p_Assignment_Set_rec.Attribute_Category IS NOT NULL AND

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: p_old_Assignment_Set_rec.Attribute_Category OR
322: p_old_Assignment_Set_rec.Attribute_Category IS NULL )
323: THEN
324: IF NOT Val_Attribute_Category(p_Assignment_Set_rec.Attribute_Category) THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: END IF;
327: END IF;
328:
329: IF p_Assignment_Set_rec.Created_By IS NOT NULL AND

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: p_old_Assignment_Set_rec.Created_By OR
332: p_old_Assignment_Set_rec.Created_By IS NULL )
333: THEN
334: IF NOT Val_Created_By(p_Assignment_Set_rec.Created_By) THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: END IF;
337: END IF;
338:
339: IF p_Assignment_Set_rec.Creation_Date IS NOT NULL AND

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: p_old_Assignment_Set_rec.Creation_Date OR
342: p_old_Assignment_Set_rec.Creation_Date IS NULL )
343: THEN
344: IF NOT Val_Creation_Date(p_Assignment_Set_rec.Creation_Date) THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: END IF;
347: END IF;
348:
349: IF p_Assignment_Set_rec.Description IS NOT NULL AND

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: p_old_Assignment_Set_rec.Description OR
352: p_old_Assignment_Set_rec.Description IS NULL )
353: THEN
354: IF NOT Val_Description(p_Assignment_Set_rec.Description) THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END IF;
357: END IF;
358:
359: IF p_Assignment_Set_rec.Last_Updated_By IS NOT NULL AND

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361: p_old_Assignment_Set_rec.Last_Updated_By OR
362: p_old_Assignment_Set_rec.Last_Updated_By IS NULL )
363: THEN
364: IF NOT Val_Last_Updated_By(p_Assignment_Set_rec.Last_Updated_By) THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: END IF;
367: END IF;
368:
369: IF p_Assignment_Set_rec.Last_Update_Date IS NOT NULL AND

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: p_old_Assignment_Set_rec.Last_Update_Date OR
372: p_old_Assignment_Set_rec.Last_Update_Date IS NULL )
373: THEN
374: IF NOT Val_Last_Update_Date(p_Assignment_Set_rec.Last_Update_Date) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;
378:
379: IF p_Assignment_Set_rec.Last_Update_Login IS NOT NULL AND

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: p_old_Assignment_Set_rec.Last_Update_Login OR
382: p_old_Assignment_Set_rec.Last_Update_Login IS NULL )
383: THEN
384: IF NOT Val_Last_Update_Login(p_Assignment_Set_rec.Last_Update_Login) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: END IF;
387: END IF;
388:
389: IF p_Assignment_Set_rec.Program_Application_Id IS NOT NULL AND

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: p_old_Assignment_Set_rec.Program_Application_Id OR
392: p_old_Assignment_Set_rec.Program_Application_Id IS NULL )
393: THEN
394: IF NOT Val_Program_Application_Id(p_Assignment_Set_rec.Program_Application_Id) THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END IF;
397: END IF;
398:
399: IF p_Assignment_Set_rec.Program_Id IS NOT NULL AND

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: p_old_Assignment_Set_rec.Program_Id OR
402: p_old_Assignment_Set_rec.Program_Id IS NULL )
403: THEN
404: IF NOT Val_Program_Id(p_Assignment_Set_rec.Program_Id) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: END IF;
407: END IF;
408:
409: IF p_Assignment_Set_rec.Program_Update_Date IS NOT NULL AND

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: p_old_Assignment_Set_rec.Program_Update_Date OR
412: p_old_Assignment_Set_rec.Program_Update_Date IS NULL )
413: THEN
414: IF NOT Val_Program_Update_Date(p_Assignment_Set_rec.Program_Update_Date) THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: END IF;
417: END IF;
418:
419: IF p_Assignment_Set_rec.Request_Id IS NOT NULL AND

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: p_old_Assignment_Set_rec.Request_Id OR
422: p_old_Assignment_Set_rec.Request_Id IS NULL )
423: THEN
424: IF NOT Val_Request_Id(p_Assignment_Set_rec.Request_Id) THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: END IF;
427: END IF;
428:
429: -- Done validating attributes

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: -- Done validating attributes
430:
431: EXCEPTION
432:
433: WHEN FND_API.G_EXC_ERROR THEN
434:
435: x_return_status := FND_API.G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: EXCEPTION
432:
433: WHEN FND_API.G_EXC_ERROR THEN
434:
435: x_return_status := FND_API.G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438:
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: WHEN FND_API.G_EXC_ERROR THEN
434:
435: x_return_status := FND_API.G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438:
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: WHEN OTHERS THEN

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: x_return_status := FND_API.G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438:
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: WHEN OTHERS THEN
442:
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: WHEN OTHERS THEN
442:
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444:
445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
446: THEN
447: FND_MSG_PUB.Add_Exc_Msg

Line 470: p_Assignment_Set_Name = FND_API.G_MISS_CHAR

466:
467: BEGIN
468:
469: IF p_Assignment_Set_Name IS NULL OR
470: p_Assignment_Set_Name = FND_API.G_MISS_CHAR
471: THEN
472: dbms_output.put_line ('Val_Assignment_Set_Name Error');
473: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Set_Name');

Line 509: p_Attribute1 = FND_API.G_MISS_CHAR

505: IS
506: BEGIN
507:
508: IF p_Attribute1 IS NULL OR
509: p_Attribute1 = FND_API.G_MISS_CHAR
510: THEN
511: RETURN TRUE;
512: END IF;
513:

Line 527: p_Attribute10 = FND_API.G_MISS_CHAR

523: IS
524: BEGIN
525:
526: IF p_Attribute10 IS NULL OR
527: p_Attribute10 = FND_API.G_MISS_CHAR
528: THEN
529: RETURN TRUE;
530: END IF;
531:

Line 545: p_Attribute11 = FND_API.G_MISS_CHAR

541: IS
542: BEGIN
543:
544: IF p_Attribute11 IS NULL OR
545: p_Attribute11 = FND_API.G_MISS_CHAR
546: THEN
547: RETURN TRUE;
548: END IF;
549:

Line 563: p_Attribute12 = FND_API.G_MISS_CHAR

559: IS
560: BEGIN
561:
562: IF p_Attribute12 IS NULL OR
563: p_Attribute12 = FND_API.G_MISS_CHAR
564: THEN
565: RETURN TRUE;
566: END IF;
567:

Line 581: p_Attribute13 = FND_API.G_MISS_CHAR

577: IS
578: BEGIN
579:
580: IF p_Attribute13 IS NULL OR
581: p_Attribute13 = FND_API.G_MISS_CHAR
582: THEN
583: RETURN TRUE;
584: END IF;
585:

Line 599: p_Attribute14 = FND_API.G_MISS_CHAR

595: IS
596: BEGIN
597:
598: IF p_Attribute14 IS NULL OR
599: p_Attribute14 = FND_API.G_MISS_CHAR
600: THEN
601: RETURN TRUE;
602: END IF;
603:

Line 617: p_Attribute15 = FND_API.G_MISS_CHAR

613: IS
614: BEGIN
615:
616: IF p_Attribute15 IS NULL OR
617: p_Attribute15 = FND_API.G_MISS_CHAR
618: THEN
619: RETURN TRUE;
620: END IF;
621:

Line 635: p_Attribute2 = FND_API.G_MISS_CHAR

631: IS
632: BEGIN
633:
634: IF p_Attribute2 IS NULL OR
635: p_Attribute2 = FND_API.G_MISS_CHAR
636: THEN
637: RETURN TRUE;
638: END IF;
639:

Line 653: p_Attribute3 = FND_API.G_MISS_CHAR

649: IS
650: BEGIN
651:
652: IF p_Attribute3 IS NULL OR
653: p_Attribute3 = FND_API.G_MISS_CHAR
654: THEN
655: RETURN TRUE;
656: END IF;
657:

Line 671: p_Attribute4 = FND_API.G_MISS_CHAR

667: IS
668: BEGIN
669:
670: IF p_Attribute4 IS NULL OR
671: p_Attribute4 = FND_API.G_MISS_CHAR
672: THEN
673: RETURN TRUE;
674: END IF;
675:

Line 689: p_Attribute5 = FND_API.G_MISS_CHAR

685: IS
686: BEGIN
687:
688: IF p_Attribute5 IS NULL OR
689: p_Attribute5 = FND_API.G_MISS_CHAR
690: THEN
691: RETURN TRUE;
692: END IF;
693:

Line 707: p_Attribute6 = FND_API.G_MISS_CHAR

703: IS
704: BEGIN
705:
706: IF p_Attribute6 IS NULL OR
707: p_Attribute6 = FND_API.G_MISS_CHAR
708: THEN
709: RETURN TRUE;
710: END IF;
711:

Line 725: p_Attribute7 = FND_API.G_MISS_CHAR

721: IS
722: BEGIN
723:
724: IF p_Attribute7 IS NULL OR
725: p_Attribute7 = FND_API.G_MISS_CHAR
726: THEN
727: RETURN TRUE;
728: END IF;
729:

Line 743: p_Attribute8 = FND_API.G_MISS_CHAR

739: IS
740: BEGIN
741:
742: IF p_Attribute8 IS NULL OR
743: p_Attribute8 = FND_API.G_MISS_CHAR
744: THEN
745: RETURN TRUE;
746: END IF;
747:

Line 761: p_Attribute9 = FND_API.G_MISS_CHAR

757: IS
758: BEGIN
759:
760: IF p_Attribute9 IS NULL OR
761: p_Attribute9 = FND_API.G_MISS_CHAR
762: THEN
763: RETURN TRUE;
764: END IF;
765:

Line 779: p_Attribute_Category = FND_API.G_MISS_CHAR

775: IS
776: BEGIN
777:
778: IF p_Attribute_Category IS NULL OR
779: p_Attribute_Category = FND_API.G_MISS_CHAR
780: THEN
781: RETURN TRUE;
782: END IF;
783:

Line 797: p_Created_By = FND_API.G_MISS_NUM

793: IS
794: BEGIN
795:
796: IF p_Created_By IS NULL OR
797: p_Created_By = FND_API.G_MISS_NUM
798: THEN
799: RETURN TRUE;
800: END IF;
801:

Line 815: p_Creation_Date = FND_API.G_MISS_DATE

811: IS
812: BEGIN
813:
814: IF p_Creation_Date IS NULL OR
815: p_Creation_Date = FND_API.G_MISS_DATE
816: THEN
817: RETURN TRUE;
818: END IF;
819:

Line 833: p_Description = FND_API.G_MISS_CHAR

829: IS
830: BEGIN
831:
832: IF p_Description IS NULL OR
833: p_Description = FND_API.G_MISS_CHAR
834: THEN
835: RETURN TRUE;
836: END IF;
837:

Line 851: p_Last_Updated_By = FND_API.G_MISS_NUM

847: IS
848: BEGIN
849:
850: IF p_Last_Updated_By IS NULL OR
851: p_Last_Updated_By = FND_API.G_MISS_NUM
852: THEN
853: RETURN TRUE;
854: END IF;
855:

Line 869: p_Last_Update_Date = FND_API.G_MISS_DATE

865: IS
866: BEGIN
867:
868: IF p_Last_Update_Date IS NULL OR
869: p_Last_Update_Date = FND_API.G_MISS_DATE
870: THEN
871: RETURN TRUE;
872: END IF;
873:

Line 887: p_Last_Update_Login = FND_API.G_MISS_NUM

883: IS
884: BEGIN
885:
886: IF p_Last_Update_Login IS NULL OR
887: p_Last_Update_Login = FND_API.G_MISS_NUM
888: THEN
889: RETURN TRUE;
890: END IF;
891:

Line 905: p_Program_Application_Id = FND_API.G_MISS_NUM

901: IS
902: BEGIN
903:
904: IF p_Program_Application_Id IS NULL OR
905: p_Program_Application_Id = FND_API.G_MISS_NUM
906: THEN
907: RETURN TRUE;
908: END IF;
909:

Line 923: p_Program_Id = FND_API.G_MISS_NUM

919: IS
920: BEGIN
921:
922: IF p_Program_Id IS NULL OR
923: p_Program_Id = FND_API.G_MISS_NUM
924: THEN
925: RETURN TRUE;
926: END IF;
927:

Line 941: p_Program_Update_Date = FND_API.G_MISS_DATE

937: IS
938: BEGIN
939:
940: IF p_Program_Update_Date IS NULL OR
941: p_Program_Update_Date = FND_API.G_MISS_DATE
942: THEN
943: RETURN TRUE;
944: END IF;
945:

Line 959: p_Request_Id = FND_API.G_MISS_NUM

955: IS
956: BEGIN
957:
958: IF p_Request_Id IS NULL OR
959: p_Request_Id = FND_API.G_MISS_NUM
960: THEN
961: RETURN TRUE;
962: END IF;
963: