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

Line 31: p_header_id = FND_API.G_MISS_NUM

27: l_dummy VARCHAR2(10);
28: BEGIN
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');

Line 54: p_header_status = FND_API.G_MISS_NUM

50: l_dummy VARCHAR2(10);
51: BEGIN
52:
53: IF p_header_status IS NULL OR
54: p_header_status = FND_API.G_MISS_NUM
55: THEN
56: RETURN T;
57: END IF;
58:

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: , 'Header_Status'
90: );
91: END IF;
92:
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94:
95: END Header_Status;
96:
97:

Line 120: p_request_number = FND_API.G_MISS_CHAR

116: l_ret_val boolean;
117: BEGIN
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');

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

167: , p_old_trohdr_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type :=
168: INV_Move_Order_PUB.G_MISS_TROHDR_REC
169: )
170: IS
171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
172: BEGIN
173:
174:
175: -- Check required attributes.

Line 180: l_return_status := FND_API.G_RET_STS_ERROR;

176:
177: -- inv_debug.message('Org:'||to_char(p_trohdr_rec.organization_id)); */
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');

Line 192: l_return_status := FND_API.G_RET_STS_ERROR;

188: END IF;
189:
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');

Line 211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

207:
208:
209: -- Return Error if a required attribute is missing.
210:
211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
212:
213: RAISE FND_API.G_EXC_ERROR;
214:
215: END IF;

Line 213: RAISE FND_API.G_EXC_ERROR;

209: -- Return Error if a required attribute is missing.
210:
211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
212:
213: RAISE FND_API.G_EXC_ERROR;
214:
215: END IF;
216:
217: --

Line 226: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

222: --
223: -- Validate attribute dependencies here.
224: --
225:
226: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
227:
228: RAISE FND_API.G_EXC_ERROR;
229:
230: END IF;

Line 228: RAISE FND_API.G_EXC_ERROR;

224: --
225:
226: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
227:
228: RAISE FND_API.G_EXC_ERROR;
229:
230: END IF;
231:
232: -- Done validating entity

Line 239: WHEN FND_API.G_EXC_ERROR THEN

235:
236:
237: EXCEPTION
238:
239: WHEN FND_API.G_EXC_ERROR THEN
240:
241: x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237: EXCEPTION
238:
239: WHEN FND_API.G_EXC_ERROR THEN
240:
241: x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

239: WHEN FND_API.G_EXC_ERROR THEN
240:
241: x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: WHEN OTHERS THEN

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: WHEN OTHERS THEN
248:
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
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

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: IS
271: BEGIN
272:
273:
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: -- Validate trohdr attributes
277: -- inv_debug.message('Calling validate org 1');
278:

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: p_old_trohdr_rec.organization_id IS NULL )*/
290: THEN
291: g_org.organization_id := p_trohdr_rec.organization_id;
292: IF INV_Validate.Organization(g_org) = inv_validate.F THEN
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: END IF;
295: END IF;
296:
297:

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: p_old_trohdr_rec.transaction_type_id IS NULL )
302: THEN
303: g_transaction.transaction_type_id := p_trohdr_rec.transaction_type_id;
304: IF INV_Validate.Transaction_type(g_transaction) = inv_validate.F THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: END IF;
307: END IF;
308:
309:

Line 318: x_return_status := FND_API.G_RET_STS_ERROR;

314: p_old_trohdr_rec.created_by IS NULL )
315: THEN
316: IF INV_Validate.Created_By(p_trohdr_rec.created_by) = inv_validate.F
317: THEN
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: END IF;
320: END IF;
321:
322:

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: p_old_trohdr_rec.creation_date IS NULL )
330: THEN
331: IF INV_Validate.Creation_Date(p_trohdr_rec.creation_date) = inv_validate.F
332: THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335: END IF;
336:
337:

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: p_old_trohdr_rec.date_required OR
342: p_old_trohdr_rec.date_required IS NULL )
343: THEN
344: IF Date_Required(p_trohdr_rec.date_required) = F THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: END IF;
347: END IF;
348:
349:

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: THEN
356: IF INV_Validate.Description(p_trohdr_rec.description) =
357: inv_validate.F
358: THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361: END IF;
362:
363:

Line 371: -- x_return_status := FND_API.G_RET_STS_ERROR;

367: p_old_trohdr_rec.move_order_type OR
368: p_old_trohdr_rec.move_order_type IS NULL )
369: THEN
370: --IF NOT INV_Validate.Move_Order_Type(p_trohdr_rec.move_order_type) THEN
371: -- x_return_status := FND_API.G_RET_STS_ERROR;
372: --END IF;
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: END IF;
375:

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: THEN
370: --IF NOT INV_Validate.Move_Order_Type(p_trohdr_rec.move_order_type) THEN
371: -- x_return_status := FND_API.G_RET_STS_ERROR;
372: --END IF;
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: END IF;
375:
376:
377: -- inv_debug.message('Calling validate header id');

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: p_old_trohdr_rec.header_id OR
381: p_old_trohdr_rec.header_id IS NULL )
382: THEN
383: IF Header(p_trohdr_rec.header_id) = F THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: END IF;
386: END IF;
387:
388: -- inv_debug.message('Calling validate header status');

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: p_old_trohdr_rec.header_status OR
392: p_old_trohdr_rec.header_status IS NULL )
393: THEN
394: IF Header_Status(p_trohdr_rec.header_status) = F THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END IF;
397: END IF;
398:
399:

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: p_old_trohdr_rec.last_updated_by OR
404: p_old_trohdr_rec.last_updated_by IS NULL )
405: THEN
406: IF INV_Validate.Last_Updated_By(p_trohdr_rec.last_updated_by) = inv_validate.F THEN
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: END IF;
409: END IF;
410:
411:

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

416: p_old_trohdr_rec.last_update_date IS NULL )
417: THEN
418: IF INV_Validate.Last_Update_Date(p_trohdr_rec.last_update_date) =
419: inv_validate.F THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF;
423:
424:

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: IF
432: INV_Validate.Last_Update_Login(p_trohdr_rec.last_update_login)=
433: inv_validate.F
434: THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: END IF;
437: END IF;
438:
439:

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443: p_old_trohdr_rec.program_application_id IS NULL )
444: THEN
445: IF
446: INV_Validate.Program_Application(p_trohdr_rec.program_application_id) = inv_validate.F THEN
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: END IF;
449: END IF;
450:
451: IF p_trohdr_rec.program_id IS NOT NULL AND

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

453: p_old_trohdr_rec.program_id OR
454: p_old_trohdr_rec.program_id IS NULL )
455: THEN
456: IF INV_Validate.Program(p_trohdr_rec.program_id) = inv_validate.F THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: END IF;
459: END IF;
460:
461:

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: p_old_trohdr_rec.program_update_date IS NULL )
466: THEN
467: IF
468: INV_Validate.Program_Update_Date(p_trohdr_rec.program_update_date)= inv_validate.F THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END IF;
471: END IF;
472:
473:

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476: p_old_trohdr_rec.request_id OR
477: p_old_trohdr_rec.request_id IS NULL )
478: THEN
479: IF Request(p_trohdr_rec.request_id) = F THEN
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: END IF;
482: END IF;
483:
484:

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: p_old_trohdr_rec.request_number OR
489: p_old_trohdr_rec.request_number IS NULL )
490: THEN
491: IF Request_Number(p_trohdr_rec.request_number,g_org) = F THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:
496: IF p_trohdr_rec.status_date IS NOT NULL AND

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: p_old_trohdr_rec.status_date OR
499: p_old_trohdr_rec.status_date IS NULL )
500: THEN
501: IF Status_Date(p_trohdr_rec.status_date) = F THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: END IF;
504: END IF;
505:
506: IF p_trohdr_rec.to_account_id IS NULL

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: p_old_trohdr_rec.to_account_id OR
516: p_old_trohdr_rec.to_account_id IS NULL )
517: THEN
518: IF INV_Validate.To_Account(p_trohdr_rec.to_account_id) = inv_validate.F THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: END IF;
521: END IF;
522:
523: IF p_trohdr_rec.ship_to_location_id IS NOT NULL AND

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: p_old_trohdr_rec.ship_to_location_id IS NULL )
527: THEN
528: IF INV_Validate.hr_location(p_trohdr_rec.ship_to_location_id) = INV_Validate.F
529: THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;
532: END IF;
533:
534: IF (p_trohdr_rec.attribute1 IS NOT NULL AND

Line 605: x_return_status := FND_API.G_RET_STS_ERROR;

601:
602: -- Validate descriptive flexfield.
603:
604: IF INV_Validate.Desc_Flex( 'TROHDR' ) = inv_validate.F THEN
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: END IF;
607:
608: END IF;
609:

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: -- Done validating attributes
611:
612: EXCEPTION
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615:
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: EXCEPTION
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615:
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619:
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

614: WHEN FND_API.G_EXC_ERROR THEN
615:
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619:
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621:
622: WHEN OTHERS THEN

Line 620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619:
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621:
622: WHEN OTHERS THEN
623:
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621:
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

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

639: ( x_return_status OUT NOCOPY VARCHAR2
640: , p_trohdr_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
641: )
642: IS
643: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
644: BEGIN
645:
646: -- Validate entity delete.
647:

Line 656: WHEN FND_API.G_EXC_ERROR THEN

652: x_return_status := l_return_status;
653:
654: EXCEPTION
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657:
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: EXCEPTION
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657:
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661:
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

656: WHEN FND_API.G_EXC_ERROR THEN
657:
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661:
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663:
664: WHEN OTHERS THEN

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661:
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663:
664: WHEN OTHERS THEN
665:
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663:
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