DBA Data[Home] [Help]

APPS.WIP_SCHED_RELATION_GRP dependencies on FND_MSG_PUB

Line 127: FND_MSG_PUB.initialize;

123: END IF;
124:
125: /* Check p_init_msg_list */
126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129: /* Initialize API return status to success */
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:

Line 400: FND_MSG_PUB.Count_AND_Get

396: COMMIT WORK;
397: END IF;
398:
399: /* Standard call to get message count AND IF count is 1, get message info. */
400: FND_MSG_PUB.Count_AND_Get
401: ( p_count => x_msg_count,
402: p_data => x_msg_data
403: );
404:

Line 410: FND_MSG_PUB.Count_AND_Get

406:
407: WHEN FND_API.G_EXC_ERROR THEN
408: ROLLBACK TO sp_wip_wol_GRP;
409: x_return_status := FND_API.G_RET_STS_ERROR ;
410: FND_MSG_PUB.Count_AND_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414:

Line 418: FND_MSG_PUB.Count_AND_Get

414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO sp_wip_wol_grp;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_AND_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422:

Line 429: FND_MSG_PUB.Add;

425: THEN
426: ROLLBACK to sp_wip_wol_grp;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_OBJ_TYPE');
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_AND_Get
431: ( p_count => x_msg_count,
432: p_data => x_msg_data
433: );

Line 430: FND_MSG_PUB.Count_AND_Get

426: ROLLBACK to sp_wip_wol_grp;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_OBJ_TYPE');
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_AND_Get
431: ( p_count => x_msg_count,
432: p_data => x_msg_data
433: );
434:

Line 440: FND_MSG_PUB.Add;

436: THEN
437: ROLLBACK to sp_wip_wol_grp;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_REL_TYPE');
440: FND_MSG_PUB.Add;
441: FND_MSG_PUB.Count_AND_Get
442: ( p_count => x_msg_count,
443: p_data => x_msg_data
444: );

Line 441: FND_MSG_PUB.Count_AND_Get

437: ROLLBACK to sp_wip_wol_grp;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INVALID_REL_TYPE');
440: FND_MSG_PUB.Add;
441: FND_MSG_PUB.Count_AND_Get
442: ( p_count => x_msg_count,
443: p_data => x_msg_data
444: );
445:

Line 451: FND_MSG_PUB.Add;

447: THEN
448: ROLLBACK to sp_wip_wol_grp;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_CHILD_SAME');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_AND_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
455: );

Line 452: FND_MSG_PUB.Count_AND_Get

448: ROLLBACK to sp_wip_wol_grp;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_CHILD_SAME');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_AND_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456:

Line 462: FND_MSG_PUB.Add;

458: THEN
459: ROLLBACK to sp_wip_wol_grp;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_BAD_REL_STATUS');
462: FND_MSG_PUB.Add;
463: FND_MSG_PUB.Count_AND_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 463: FND_MSG_PUB.Count_AND_Get

459: ROLLBACK to sp_wip_wol_grp;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_BAD_REL_STATUS');
462: FND_MSG_PUB.Add;
463: FND_MSG_PUB.Count_AND_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467:

Line 473: FND_MSG_PUB.Add;

469: THEN
470: ROLLBACK to sp_wip_wol_grp;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DEPENDENT_REL_EXIST');
473: FND_MSG_PUB.Add;
474: FND_MSG_PUB.Count_AND_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );

Line 474: FND_MSG_PUB.Count_AND_Get

470: ROLLBACK to sp_wip_wol_grp;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DEPENDENT_REL_EXIST');
473: FND_MSG_PUB.Add;
474: FND_MSG_PUB.Count_AND_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478:

Line 484: FND_MSG_PUB.Add;

480: THEN
481: ROLLBACK to sp_wip_wol_grp;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CONSTRAINED_REL_EXIST');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_AND_Get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
488: );

Line 485: FND_MSG_PUB.Count_AND_Get

481: ROLLBACK to sp_wip_wol_grp;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CONSTRAINED_REL_EXIST');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_AND_Get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489:

Line 495: FND_MSG_PUB.Add;

491: THEN
492: ROLLBACK to sp_wip_wol_grp;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_EXIST');
495: FND_MSG_PUB.Add;
496: FND_MSG_PUB.Count_AND_Get
497: ( p_count => x_msg_count,
498: p_data => x_msg_data
499: );

Line 496: FND_MSG_PUB.Count_AND_Get

492: ROLLBACK to sp_wip_wol_grp;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_PARENT_EXIST');
495: FND_MSG_PUB.Add;
496: FND_MSG_PUB.Count_AND_Get
497: ( p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:

Line 506: FND_MSG_PUB.Add;

502: THEN
503: ROLLBACK to sp_wip_wol_grp;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_LOOP_FOUND');
506: FND_MSG_PUB.Add;
507: FND_MSG_PUB.Count_AND_Get
508: ( p_count => x_msg_count,
509: p_data => x_msg_data
510: );

Line 507: FND_MSG_PUB.Count_AND_Get

503: ROLLBACK to sp_wip_wol_grp;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_LOOP_FOUND');
506: FND_MSG_PUB.Add;
507: FND_MSG_PUB.Count_AND_Get
508: ( p_count => x_msg_count,
509: p_data => x_msg_data
510: );
511:

Line 517: FND_MSG_PUB.Add;

513: THEN
514: ROLLBACK to sp_wip_wol_grp;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INSERT_FAIL');
517: FND_MSG_PUB.Add;
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data
521: );

Line 518: FND_MSG_PUB.Count_AND_Get

514: ROLLBACK to sp_wip_wol_grp;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_INSERT_FAIL');
517: FND_MSG_PUB.Add;
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data
521: );
522:

Line 526: IF FND_MSG_PUB.Check_Msg_Level

522:
523: WHEN OTHERS THEN
524: ROLLBACK TO sp_wip_wol_grp;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level
527: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
528: THEN
529: FND_MSG_PUB.Add_Exc_Msg
530: ( G_PKG_NAME,

Line 527: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

523: WHEN OTHERS THEN
524: ROLLBACK TO sp_wip_wol_grp;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level
527: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
528: THEN
529: FND_MSG_PUB.Add_Exc_Msg
530: ( G_PKG_NAME,
531: l_api_name

Line 529: FND_MSG_PUB.Add_Exc_Msg

525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level
527: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
528: THEN
529: FND_MSG_PUB.Add_Exc_Msg
530: ( G_PKG_NAME,
531: l_api_name
532: );
533: END IF;

Line 534: FND_MSG_PUB.Count_AND_Get

530: ( G_PKG_NAME,
531: l_api_name
532: );
533: END IF;
534: FND_MSG_PUB.Count_AND_Get
535: ( p_count => x_msg_count,
536: p_data => x_msg_data
537: );
538:

Line 633: FND_MSG_PUB.initialize;

629: END IF;
630:
631: /* Check p_init_msg_list */
632: IF FND_API.to_Boolean( p_init_msg_list ) THEN
633: FND_MSG_PUB.initialize;
634: END IF;
635: /* Initialize API return status to success */
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:

Line 734: FND_MSG_PUB.Count_AND_Get

730: COMMIT WORK;
731: END IF;
732:
733: /* Standard call to get message count AND IF count is 1, get message info. */
734: FND_MSG_PUB.Count_AND_Get
735: ( p_count => x_msg_count,
736: p_data => x_msg_data
737: );
738:

Line 744: FND_MSG_PUB.Count_AND_Get

740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO sp_wip_wol_GRP;
743: x_return_status := FND_API.G_RET_STS_ERROR ;
744: FND_MSG_PUB.Count_AND_Get
745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:

Line 752: FND_MSG_PUB.Count_AND_Get

748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO sp_wip_wol_grp;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: FND_MSG_PUB.Count_AND_Get
753: ( p_count => x_msg_count,
754: p_data => x_msg_data
755: );
756:

Line 761: FND_MSG_PUB.Add;

757: WHEN DEP_REL_EXIST_EXCEPTION THEN
758: ROLLBACK to sp_wip_wol_grp;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CHILD_DEP_REL_EXIST');
761: FND_MSG_PUB.Add;
762: FND_MSG_PUB.Count_AND_Get
763: ( p_count => x_msg_count,
764: p_data => x_msg_data
765: );

Line 762: FND_MSG_PUB.Count_AND_Get

758: ROLLBACK to sp_wip_wol_grp;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_CHILD_DEP_REL_EXIST');
761: FND_MSG_PUB.Add;
762: FND_MSG_PUB.Count_AND_Get
763: ( p_count => x_msg_count,
764: p_data => x_msg_data
765: );
766:

Line 771: FND_MSG_PUB.Add;

767: WHEN NO_SUCH_RELID_EXCEPTION THEN
768: ROLLBACK to sp_wip_wol_grp;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_NO_SUCH_REL_ID');
771: FND_MSG_PUB.Add;
772: FND_MSG_PUB.Count_AND_Get
773: ( p_count => x_msg_count,
774: p_data => x_msg_data
775: );

Line 772: FND_MSG_PUB.Count_AND_Get

768: ROLLBACK to sp_wip_wol_grp;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_NO_SUCH_REL_ID');
771: FND_MSG_PUB.Add;
772: FND_MSG_PUB.Count_AND_Get
773: ( p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:

Line 782: FND_MSG_PUB.Add;

778: THEN
779: ROLLBACK to sp_wip_wol_grp;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DELETE_FAIL');
782: FND_MSG_PUB.Add;
783: FND_MSG_PUB.Count_AND_Get
784: ( p_count => x_msg_count,
785: p_data => x_msg_data
786: );

Line 783: FND_MSG_PUB.Count_AND_Get

779: ROLLBACK to sp_wip_wol_grp;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MESSAGE.SET_name('WIP', 'WIP_WOL_DELETE_FAIL');
782: FND_MSG_PUB.Add;
783: FND_MSG_PUB.Count_AND_Get
784: ( p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787:

Line 791: IF FND_MSG_PUB.Check_Msg_Level

787:
788: WHEN OTHERS THEN
789: ROLLBACK TO sp_wip_wol_grp;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME,

Line 792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

788: WHEN OTHERS THEN
789: ROLLBACK TO sp_wip_wol_grp;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME,
796: l_api_name

Line 794: FND_MSG_PUB.Add_Exc_Msg

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME,
796: l_api_name
797: );
798: END IF;

Line 799: FND_MSG_PUB.Count_AND_Get

795: ( G_PKG_NAME,
796: l_api_name
797: );
798: END IF;
799: FND_MSG_PUB.Count_AND_Get
800: ( p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803: