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.CS_WORKFLOW_PUB dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.initialize;

153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159:
160: -- Initialize return status to SUCCESS
161: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 559: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

555: IF (FND_API.To_Boolean( p_commit )) THEN
556: COMMIT WORK;
557: END IF;
558:
559: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
560: p_data => p_msg_data,
561: p_encoded => FND_API.G_FALSE );
562:
563: EXCEPTION

Line 567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

563: EXCEPTION
564: WHEN l_SR_NO_WORKFLOW THEN
565: ROLLBACK TO Launch_Workflow_PUB;
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
568: FND_MESSAGE.SET_NAME('CS', 'CS_SR_NO_WORKFLOW');
569: FND_MSG_PUB.Add;
570: END IF;
571: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 569: FND_MSG_PUB.Add;

565: ROLLBACK TO Launch_Workflow_PUB;
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
568: FND_MESSAGE.SET_NAME('CS', 'CS_SR_NO_WORKFLOW');
569: FND_MSG_PUB.Add;
570: END IF;
571: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
572: p_data => p_msg_data,
573: p_encoded => FND_API.G_FALSE );

Line 571: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
568: FND_MESSAGE.SET_NAME('CS', 'CS_SR_NO_WORKFLOW');
569: FND_MSG_PUB.Add;
570: END IF;
571: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
572: p_data => p_msg_data,
573: p_encoded => FND_API.G_FALSE );
574:
575: WHEN l_SR_CLOSED_STATUS THEN

Line 578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

574:
575: WHEN l_SR_CLOSED_STATUS THEN
576: ROLLBACK TO Launch_Workflow_PUB;
577: p_return_status := FND_API.G_RET_STS_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
579: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_WF_CLOSED_STATUS');
580: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME||'.'||l_api_name);
581: FND_MSG_PUB.Add;
582: END IF;

Line 581: FND_MSG_PUB.Add;

577: p_return_status := FND_API.G_RET_STS_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
579: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_WF_CLOSED_STATUS');
580: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME||'.'||l_api_name);
581: FND_MSG_PUB.Add;
582: END IF;
583: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
584: p_data => p_msg_data,
585: p_encoded => FND_API.G_FALSE );

Line 583: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

579: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_WF_CLOSED_STATUS');
580: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME||'.'||l_api_name);
581: FND_MSG_PUB.Add;
582: END IF;
583: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
584: p_data => p_msg_data,
585: p_encoded => FND_API.G_FALSE );
586:
587: WHEN l_ADMINISTRATOR_NOT_SET THEN

Line 590: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

586:
587: WHEN l_ADMINISTRATOR_NOT_SET THEN
588: ROLLBACK TO Launch_Workflow_PUB;
589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
591: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_WF_ADMINISTRATOR');
592: FND_MSG_PUB.Add;
593: END IF;
594: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 592: FND_MSG_PUB.Add;

588: ROLLBACK TO Launch_Workflow_PUB;
589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
591: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_WF_ADMINISTRATOR');
592: FND_MSG_PUB.Add;
593: END IF;
594: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
595: p_data => p_msg_data,
596: p_encoded => FND_API.G_FALSE );

Line 594: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

590: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
591: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_WF_ADMINISTRATOR');
592: FND_MSG_PUB.Add;
593: END IF;
594: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
595: p_data => p_msg_data,
596: p_encoded => FND_API.G_FALSE );
597:
598: WHEN l_RESET_ADMINISTRATOR THEN

Line 601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

597:
598: WHEN l_RESET_ADMINISTRATOR THEN
599: ROLLBACK TO Launch_Workflow_PUB;
600: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
602: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_RESET_WF_ADMINI');
603: FND_MSG_PUB.Add;
604: END IF;
605: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 603: FND_MSG_PUB.Add;

599: ROLLBACK TO Launch_Workflow_PUB;
600: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
602: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_RESET_WF_ADMINI');
603: FND_MSG_PUB.Add;
604: END IF;
605: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
606: p_data => p_msg_data,
607: p_encoded => FND_API.G_FALSE );

Line 605: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
602: FND_MESSAGE.SET_NAME('CS', 'CS_ALL_RESET_WF_ADMINI');
603: FND_MSG_PUB.Add;
604: END IF;
605: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
606: p_data => p_msg_data,
607: p_encoded => FND_API.G_FALSE );
608:
609: WHEN l_WORKFLOW_IN_PROGRESS THEN

Line 623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

619: END IF;
620:
621: ROLLBACK TO Launch_Workflow_PUB;
622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_IN_PROGRESS');
625: FND_MSG_PUB.Add;
626: END IF;
627: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 625: FND_MSG_PUB.Add;

621: ROLLBACK TO Launch_Workflow_PUB;
622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_IN_PROGRESS');
625: FND_MSG_PUB.Add;
626: END IF;
627: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
628: p_data => p_msg_data,
629: p_encoded => FND_API.G_FALSE );

Line 627: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_IN_PROGRESS');
625: FND_MSG_PUB.Add;
626: END IF;
627: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
628: p_data => p_msg_data,
629: p_encoded => FND_API.G_FALSE );
630:
631: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

630:
631: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
632: ROLLBACK TO Launch_Workflow_PUB;
633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
635: FND_MESSAGE.Set_Name('CS', 'CS_SR_WF_RECORD_LOCKED');
636: FND_MSG_PUB.Add;
637: END IF;
638: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 636: FND_MSG_PUB.Add;

632: ROLLBACK TO Launch_Workflow_PUB;
633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
635: FND_MESSAGE.Set_Name('CS', 'CS_SR_WF_RECORD_LOCKED');
636: FND_MSG_PUB.Add;
637: END IF;
638: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
639: p_data => p_msg_data,
640: p_encoded => FND_API.G_FALSE );

Line 638: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
635: FND_MESSAGE.Set_Name('CS', 'CS_SR_WF_RECORD_LOCKED');
636: FND_MSG_PUB.Add;
637: END IF;
638: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
639: p_data => p_msg_data,
640: p_encoded => FND_API.G_FALSE );
641:
642: WHEN FND_API.G_EXC_ERROR THEN

Line 656: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

652: END IF;
653:
654: ROLLBACK TO Launch_Workflow_PUB;
655: p_return_status := FND_API.G_RET_STS_ERROR;
656: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
657: p_data => p_msg_data,
658: p_encoded => FND_API.G_FALSE );
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 674: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

670: END IF;
671:
672: ROLLBACK TO Launch_Workflow_PUB;
673: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
675: p_data => p_msg_data,
676: p_encoded => FND_API.G_FALSE );
677:
678: WHEN OTHERS THEN

Line 692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

688: END IF;
689:
690: ROLLBACK TO Launch_Workflow_PUB;
691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
694: l_api_name );
695: END IF;
696: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

689:
690: ROLLBACK TO Launch_Workflow_PUB;
691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
694: l_api_name );
695: END IF;
696: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
697: p_data => p_msg_data,

Line 696: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
693: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
694: l_api_name );
695: END IF;
696: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
697: p_data => p_msg_data,
698: p_encoded => FND_API.G_FALSE );
699:
700: END Launch_Servereq_Workflow;

Line 751: FND_MSG_PUB.initialize;

747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750: IF FND_API.to_Boolean( p_init_msg_list ) THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:
754: -- Initialize return status to SUCCESS
755: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 834: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

830: IF FND_API.To_Boolean( p_commit ) THEN
831: COMMIT WORK;
832: END IF;
833:
834: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
835: p_data => p_msg_data,
836: p_encoded => FND_API.G_FALSE );
837:
838: EXCEPTION

Line 842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

838: EXCEPTION
839: WHEN l_NOT_ACTIVE THEN
840: ROLLBACK TO Cancel_Workflow_PUB;
841: p_return_status := FND_API.G_RET_STS_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
843: FND_MESSAGE.SET_NAME('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
844: FND_MSG_PUB.Add;
845: END IF;
846: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 844: FND_MSG_PUB.Add;

840: ROLLBACK TO Cancel_Workflow_PUB;
841: p_return_status := FND_API.G_RET_STS_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
843: FND_MESSAGE.SET_NAME('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
844: FND_MSG_PUB.Add;
845: END IF;
846: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
847: p_data => p_msg_data,
848: p_encoded => FND_API.G_FALSE );

Line 846: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
843: FND_MESSAGE.SET_NAME('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
844: FND_MSG_PUB.Add;
845: END IF;
846: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
847: p_data => p_msg_data,
848: p_encoded => FND_API.G_FALSE );
849:
850: WHEN OTHERS THEN

Line 853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

849:
850: WHEN OTHERS THEN
851: ROLLBACK TO Cancel_Workflow_PUB;
852: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
855: l_api_name );
856: END IF;
857: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

850: WHEN OTHERS THEN
851: ROLLBACK TO Cancel_Workflow_PUB;
852: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
855: l_api_name );
856: END IF;
857: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
858: p_data => p_msg_data,

Line 857: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
855: l_api_name );
856: END IF;
857: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
858: p_data => p_msg_data,
859: p_encoded => FND_API.G_FALSE );
860:
861: END Cancel_Servereq_Workflow;

Line 909: FND_MSG_PUB.initialize;

905: raise FND_API.G_EXC_UNEXPECTED_ERROR;
906: END IF;
907:
908: IF FND_API.to_Boolean( p_init_msg_list ) THEN
909: FND_MSG_PUB.initialize;
910: END IF;
911:
912: -- Initialize return value
913: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 927: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

923: p_wf_process_id := to_number(substr(p_itemkey,
924: l_dash_pos + 1,
925: length(p_itemkey) - l_dash_pos));
926:
927: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
928: p_data => p_msg_data );
929:
930: EXCEPTION
931: WHEN l_INVALID_ITEMKEY THEN

Line 933: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

929:
930: EXCEPTION
931: WHEN l_INVALID_ITEMKEY THEN
932: p_return_status := FND_API.G_RET_STS_ERROR;
933: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
934: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_INVALID_ARGUMENT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME||'.'||l_api_name);
936: FND_MESSAGE.SET_TOKEN('VALUE', p_itemkey);
937: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_ITEMKEY');

Line 938: FND_MSG_PUB.Add;

934: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_INVALID_ARGUMENT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME||'.'||l_api_name);
936: FND_MESSAGE.SET_TOKEN('VALUE', p_itemkey);
937: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_ITEMKEY');
938: FND_MSG_PUB.Add;
939: END IF;
940: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
941: p_data => p_msg_data );
942:

Line 940: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

936: FND_MESSAGE.SET_TOKEN('VALUE', p_itemkey);
937: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_ITEMKEY');
938: FND_MSG_PUB.Add;
939: END IF;
940: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
941: p_data => p_msg_data );
942:
943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;

Line 945: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

941: p_data => p_msg_data );
942:
943: WHEN FND_API.G_EXC_ERROR THEN
944: p_return_status := FND_API.G_RET_STS_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
946: p_data => p_msg_data );
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 950: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

946: p_data => p_msg_data );
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
951: p_data => p_msg_data );
952:
953: WHEN OTHERS THEN
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

951: p_data => p_msg_data );
952:
953: WHEN OTHERS THEN
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
957: l_api_name );
958: END IF;
959: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

952:
953: WHEN OTHERS THEN
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
957: l_api_name );
958: END IF;
959: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
960: p_data => p_msg_data );

Line 959: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
957: l_api_name );
958: END IF;
959: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
960: p_data => p_msg_data );
961:
962: END Decode_Servereq_Itemkey;
963:

Line 1003: FND_MSG_PUB.initialize;

999: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1000: END IF;
1001:
1002: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1003: FND_MSG_PUB.initialize;
1004: END IF;
1005:
1006: -- Initialize return value
1007: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1024: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1020: END IF;
1021:
1022: p_itemkey := p_request_number||'-'||to_char(p_wf_process_id);
1023:
1024: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1025: p_data => p_msg_data );
1026:
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN

Line 1030: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1026:
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: p_return_status := FND_API.G_RET_STS_ERROR;
1030: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1031: p_data => p_msg_data );
1032:
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1035: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1031: p_data => p_msg_data );
1032:
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1036: p_data => p_msg_data );
1037:
1038: WHEN OTHERS THEN
1039: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1036: p_data => p_msg_data );
1037:
1038: WHEN OTHERS THEN
1039: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1042: l_api_name );
1043: END IF;
1044: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1037:
1038: WHEN OTHERS THEN
1039: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1042: l_api_name );
1043: END IF;
1044: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1045: p_data => p_msg_data );

Line 1044: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1042: l_api_name );
1043: END IF;
1044: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1045: p_data => p_msg_data );
1046:
1047: END Encode_Servereq_Itemkey;
1048:

Line 1083: FND_MSG_PUB.initialize;

1079: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END IF;
1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085:
1086: -- Initialize return status to SUCCESS
1087: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1118: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1114: p_orig_system_id => l_employee_id,
1115: p_name => p_role_name,
1116: p_display_name => p_role_display_name );
1117:
1118: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1119: p_data => p_msg_data );
1120:
1121: EXCEPTION
1122: WHEN FND_API.G_EXC_ERROR THEN

Line 1124: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1120:
1121: EXCEPTION
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: p_return_status := FND_API.G_RET_STS_ERROR;
1124: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1125: p_data => p_msg_data );
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1129: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1125: p_data => p_msg_data );
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1129: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1130: p_data => p_msg_data );
1131:
1132: WHEN OTHERS THEN
1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1130: p_data => p_msg_data );
1131:
1132: WHEN OTHERS THEN
1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1136: l_api_name );
1137: END IF;
1138: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1131:
1132: WHEN OTHERS THEN
1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1136: l_api_name );
1137: END IF;
1138: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1139: p_data => p_msg_data );

Line 1138: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1136: l_api_name );
1137: END IF;
1138: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1139: p_data => p_msg_data );
1140:
1141: END Get_Employee_Role;
1142:

Line 1197: FND_MSG_PUB.initialize;

1193: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1197: FND_MSG_PUB.initialize;
1198: END IF;
1199:
1200: -- Initialize return values
1201: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1252: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1248: END IF;
1249:
1250: END IF;
1251:
1252: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1253: p_data => p_msg_data );
1254:
1255: EXCEPTION
1256: WHEN FND_API.G_EXC_ERROR THEN

Line 1258: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1254:
1255: EXCEPTION
1256: WHEN FND_API.G_EXC_ERROR THEN
1257: p_return_status := FND_API.G_RET_STS_ERROR;
1258: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1259: p_data => p_msg_data );
1260:
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1263: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1259: p_data => p_msg_data );
1260:
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1264: p_data => p_msg_data );
1265:
1266: WHEN OTHERS THEN
1267: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1264: p_data => p_msg_data );
1265:
1266: WHEN OTHERS THEN
1267: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1270: l_api_name );
1271: END IF;
1272: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 1269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1265:
1266: WHEN OTHERS THEN
1267: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1270: l_api_name );
1271: END IF;
1272: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1273: p_data => p_msg_data );

Line 1272: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1270: l_api_name );
1271: END IF;
1272: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1273: p_data => p_msg_data );
1274:
1275: END Get_Emp_Supervisor;
1276:

Line 1316: FND_MSG_PUB.initialize;

1312: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1313: END IF;
1314:
1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: -- Initialize return value
1320: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1348: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1344: OPEN l_emp_csr;
1345: FETCH l_emp_csr INTO p_fnd_user_id;
1346: CLOSE l_emp_csr;
1347:
1348: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1349: p_data => p_msg_data );
1350:
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN

Line 1354: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1350:
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: p_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1355: p_data => p_msg_data );
1356:
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1359: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1355: p_data => p_msg_data );
1356:
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1360: p_data => p_msg_data );
1361:
1362: WHEN OTHERS THEN
1363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1360: p_data => p_msg_data );
1361:
1362: WHEN OTHERS THEN
1363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1366: l_api_name );
1367: END IF;
1368: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1361:
1362: WHEN OTHERS THEN
1363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1366: l_api_name );
1367: END IF;
1368: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1369: p_data => p_msg_data );

Line 1368: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1366: l_api_name );
1367: END IF;
1368: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1369: p_data => p_msg_data );
1370:
1371: END Get_Emp_Fnd_User_ID;
1372:

Line 1455: FND_MSG_PUB.Initialize;

1451: END IF;
1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE
1454: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.Initialize;
1456: END IF;
1457:
1458: -- Initialize API return status to SUCCESS
1459: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1648: FND_MSG_PUB.Count_And_Get

1644: IF FND_API.To_Boolean( p_commit ) THEN
1645: COMMIT WORK;
1646: END IF;
1647:
1648: FND_MSG_PUB.Count_And_Get
1649: ( p_count => p_msg_count,
1650: p_data => p_msg_data,
1651: p_encoded => FND_API.G_FALSE
1652: );

Line 1658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1654: EXCEPTION
1655: WHEN l_exc_administrator_not_set THEN
1656: ROLLBACK TO Launch_Action_Workflow_PUB;
1657: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1659: FND_MESSAGE.Set_Name('CS', 'CS_ALL_WF_ADMINISTRATOR');
1660: FND_MSG_PUB.Add;
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get

Line 1660: FND_MSG_PUB.Add;

1656: ROLLBACK TO Launch_Action_Workflow_PUB;
1657: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1659: FND_MESSAGE.Set_Name('CS', 'CS_ALL_WF_ADMINISTRATOR');
1660: FND_MSG_PUB.Add;
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get
1663: ( p_count => p_msg_count,
1664: p_data => p_msg_data,

Line 1662: FND_MSG_PUB.Count_And_Get

1658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1659: FND_MESSAGE.Set_Name('CS', 'CS_ALL_WF_ADMINISTRATOR');
1660: FND_MSG_PUB.Add;
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get
1663: ( p_count => p_msg_count,
1664: p_data => p_msg_data,
1665: p_encoded => FND_API.G_FALSE
1666: );

Line 1670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1666: );
1667: WHEN l_exc_reset_administrator THEN
1668: ROLLBACK TO Launch_Action_Workflow_PUB;
1669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1671: FND_MESSAGE.Set_Name('CS', 'CS_ALL_RESET_WF_ADMINI');
1672: FND_MSG_PUB.Add;
1673: END IF;
1674: FND_MSG_PUB.Count_And_Get

Line 1672: FND_MSG_PUB.Add;

1668: ROLLBACK TO Launch_Action_Workflow_PUB;
1669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1671: FND_MESSAGE.Set_Name('CS', 'CS_ALL_RESET_WF_ADMINI');
1672: FND_MSG_PUB.Add;
1673: END IF;
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_count => p_msg_count,
1676: p_data => p_msg_data,

Line 1674: FND_MSG_PUB.Count_And_Get

1670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1671: FND_MESSAGE.Set_Name('CS', 'CS_ALL_RESET_WF_ADMINI');
1672: FND_MSG_PUB.Add;
1673: END IF;
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_count => p_msg_count,
1676: p_data => p_msg_data,
1677: p_encoded => FND_API.G_FALSE
1678: );

Line 1687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1683: CLOSE l_action_csr;
1684: END IF;
1685: ROLLBACK TO Launch_Action_Workflow_PUB;
1686: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1688: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WORKFLOW_IN_PROGRESS');
1689: FND_MSG_PUB.Add;
1690: END IF;
1691: FND_MSG_PUB.Count_And_Get

Line 1689: FND_MSG_PUB.Add;

1685: ROLLBACK TO Launch_Action_Workflow_PUB;
1686: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1688: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WORKFLOW_IN_PROGRESS');
1689: FND_MSG_PUB.Add;
1690: END IF;
1691: FND_MSG_PUB.Count_And_Get
1692: ( p_count => p_msg_count,
1693: p_data => p_msg_data,

Line 1691: FND_MSG_PUB.Count_And_Get

1687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1688: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WORKFLOW_IN_PROGRESS');
1689: FND_MSG_PUB.Add;
1690: END IF;
1691: FND_MSG_PUB.Count_And_Get
1692: ( p_count => p_msg_count,
1693: p_data => p_msg_data,
1694: p_encoded => FND_API.G_FALSE
1695: );

Line 1699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1695: );
1696: WHEN l_exc_sr_no_workflow THEN
1697: ROLLBACK TO Launch_Action_Workflow_PUB;
1698: p_return_status := FND_API.G_RET_STS_ERROR;
1699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1700: FND_MESSAGE.Set_Name('CS', 'CS_ACT_NO_WORKFLOW');
1701: FND_MSG_PUB.Add;
1702: END IF;
1703: FND_MSG_PUB.Count_And_Get

Line 1701: FND_MSG_PUB.Add;

1697: ROLLBACK TO Launch_Action_Workflow_PUB;
1698: p_return_status := FND_API.G_RET_STS_ERROR;
1699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1700: FND_MESSAGE.Set_Name('CS', 'CS_ACT_NO_WORKFLOW');
1701: FND_MSG_PUB.Add;
1702: END IF;
1703: FND_MSG_PUB.Count_And_Get
1704: ( p_count => p_msg_count,
1705: p_data => p_msg_data,

Line 1703: FND_MSG_PUB.Count_And_Get

1699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1700: FND_MESSAGE.Set_Name('CS', 'CS_ACT_NO_WORKFLOW');
1701: FND_MSG_PUB.Add;
1702: END IF;
1703: FND_MSG_PUB.Count_And_Get
1704: ( p_count => p_msg_count,
1705: p_data => p_msg_data,
1706: p_encoded => FND_API.G_FALSE
1707: );

Line 1711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1707: );
1708: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1709: ROLLBACK TO Launch_Action_Workflow_PUB;
1710: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1712: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WF_RECORD_LOCKED');
1713: FND_MSG_PUB.Add;
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get

Line 1713: FND_MSG_PUB.Add;

1709: ROLLBACK TO Launch_Action_Workflow_PUB;
1710: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1712: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WF_RECORD_LOCKED');
1713: FND_MSG_PUB.Add;
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get
1716: ( p_count => p_msg_count,
1717: p_data => p_msg_data,

Line 1715: FND_MSG_PUB.Count_And_Get

1711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1712: FND_MESSAGE.Set_Name('CS', 'CS_ACT_WF_RECORD_LOCKED');
1713: FND_MSG_PUB.Add;
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get
1716: ( p_count => p_msg_count,
1717: p_data => p_msg_data,
1718: p_encoded => FND_API.G_FALSE
1719: );

Line 1728: FND_MSG_PUB.Count_And_Get

1724: CLOSE l_action_csr;
1725: END IF;
1726: ROLLBACK TO Launch_Action_Workflow_PUB;
1727: p_return_status := FND_API.G_RET_STS_ERROR;
1728: FND_MSG_PUB.Count_And_Get
1729: ( p_count => p_msg_count,
1730: p_data => p_msg_data,
1731: p_encoded => FND_API.G_FALSE
1732: );

Line 1741: FND_MSG_PUB.Count_And_Get

1737: CLOSE l_action_csr;
1738: END IF;
1739: ROLLBACK TO Launch_Action_Workflow_PUB;
1740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get
1742: ( p_count => p_msg_count,
1743: p_data => p_msg_data,
1744: p_encoded => FND_API.G_FALSE
1745: );

Line 1754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1750: CLOSE l_action_csr;
1751: END IF;
1752: ROLLBACK TO Launch_Action_Workflow_PUB;
1753: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1755: FND_MSG_PUB.Add_Exc_Msg
1756: ( G_PKG_NAME,
1757: l_api_name
1758: );

Line 1755: FND_MSG_PUB.Add_Exc_Msg

1751: END IF;
1752: ROLLBACK TO Launch_Action_Workflow_PUB;
1753: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1755: FND_MSG_PUB.Add_Exc_Msg
1756: ( G_PKG_NAME,
1757: l_api_name
1758: );
1759: END IF;

Line 1760: FND_MSG_PUB.Count_And_Get

1756: ( G_PKG_NAME,
1757: l_api_name
1758: );
1759: END IF;
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_count => p_msg_count,
1762: p_data => p_msg_data,
1763: p_encoded => FND_API.G_FALSE
1764: );

Line 1824: FND_MSG_PUB.Initialize;

1820: END IF;
1821:
1822: -- Initialize message list if p_init_msg_list is set to TRUE
1823: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1824: FND_MSG_PUB.Initialize;
1825: END IF;
1826:
1827: -- Initialize API return status to success
1828: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1937: FND_MSG_PUB.Count_And_Get

1933: IF FND_API.To_Boolean( p_commit ) THEN
1934: COMMIT WORK;
1935: END IF;
1936:
1937: FND_MSG_PUB.Count_And_Get
1938: ( p_count => p_msg_count,
1939: p_data => p_msg_data,
1940: p_encoded => FND_API.G_FALSE
1941: );

Line 1947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1943: EXCEPTION
1944: WHEN l_exc_not_active THEN
1945: ROLLBACK TO Cancel_Action_Workflow_PUB;
1946: p_return_status := FND_API.G_RET_STS_ERROR;
1947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1948: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
1949: FND_MSG_PUB.Add;
1950: END IF;
1951: FND_MSG_PUB.Count_And_Get

Line 1949: FND_MSG_PUB.Add;

1945: ROLLBACK TO Cancel_Action_Workflow_PUB;
1946: p_return_status := FND_API.G_RET_STS_ERROR;
1947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1948: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
1949: FND_MSG_PUB.Add;
1950: END IF;
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => p_msg_count,
1953: p_data => p_msg_data,

Line 1951: FND_MSG_PUB.Count_And_Get

1947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1948: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
1949: FND_MSG_PUB.Add;
1950: END IF;
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => p_msg_count,
1953: p_data => p_msg_data,
1954: p_encoded => FND_API.G_FALSE
1955: );

Line 1959: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1955: );
1956: WHEN OTHERS THEN
1957: ROLLBACK TO Cancel_Action_Workflow_PUB;
1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1960: FND_MSG_PUB.Add_Exc_Msg
1961: ( G_PKG_NAME,
1962: l_api_name
1963: );

Line 1960: FND_MSG_PUB.Add_Exc_Msg

1956: WHEN OTHERS THEN
1957: ROLLBACK TO Cancel_Action_Workflow_PUB;
1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1960: FND_MSG_PUB.Add_Exc_Msg
1961: ( G_PKG_NAME,
1962: l_api_name
1963: );
1964: END IF;

Line 1965: FND_MSG_PUB.Count_And_Get

1961: ( G_PKG_NAME,
1962: l_api_name
1963: );
1964: END IF;
1965: FND_MSG_PUB.Count_And_Get
1966: ( p_count => p_msg_count,
1967: p_data => p_msg_data,
1968: p_encoded => FND_API.G_FALSE
1969: );

Line 2015: FND_MSG_PUB.Initialize;

2011: END IF;
2012:
2013: -- Initialize message list if p_init_msg_list is set to TRUE
2014: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2015: FND_MSG_PUB.Initialize;
2016: END IF;
2017:
2018: -- Initialize API return status to success
2019: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2031: FND_MSG_PUB.Count_And_Get

2027: p_request_id := SUBSTR(p_itemkey, 1, l_dash_pos1-1);
2028: p_action_number := SUBSTR(p_itemkey, l_dash_pos1+1, l_dash_pos2-l_dash_pos1-1);
2029: p_wf_process_id := SUBSTR(p_itemkey, l_dash_pos2+1);
2030:
2031: FND_MSG_PUB.Count_And_Get
2032: ( p_count => p_msg_count,
2033: p_data => p_msg_data
2034: );
2035:

Line 2044: FND_MSG_PUB.Count_And_Get

2040: ( p_token_an => G_PKG_NAME||'.'||l_api_name,
2041: p_token_v => p_itemkey,
2042: p_token_p => 'p_itemkey'
2043: );
2044: FND_MSG_PUB.Count_And_Get
2045: ( p_count => p_msg_count,
2046: p_data => p_msg_data
2047: );
2048: WHEN FND_API.G_EXC_ERROR THEN

Line 2050: FND_MSG_PUB.Count_And_Get

2046: p_data => p_msg_data
2047: );
2048: WHEN FND_API.G_EXC_ERROR THEN
2049: p_return_status := FND_API.G_RET_STS_ERROR;
2050: FND_MSG_PUB.Count_And_Get
2051: ( p_count => p_msg_count,
2052: p_data => p_msg_data
2053: );
2054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2056: FND_MSG_PUB.Count_And_Get

2052: p_data => p_msg_data
2053: );
2054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2055: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2056: FND_MSG_PUB.Count_And_Get
2057: ( p_count => p_msg_count,
2058: p_data => p_msg_data
2059: );
2060: WHEN OTHERS THEN

Line 2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2058: p_data => p_msg_data
2059: );
2060: WHEN OTHERS THEN
2061: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg
2064: ( G_PKG_NAME,
2065: l_api_name
2066: );

Line 2063: FND_MSG_PUB.Add_Exc_Msg

2059: );
2060: WHEN OTHERS THEN
2061: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg
2064: ( G_PKG_NAME,
2065: l_api_name
2066: );
2067: END IF;

Line 2068: FND_MSG_PUB.Count_And_Get

2064: ( G_PKG_NAME,
2065: l_api_name
2066: );
2067: END IF;
2068: FND_MSG_PUB.Count_And_Get
2069: ( p_count => p_msg_count,
2070: p_data => p_msg_data
2071: );
2072:

Line 2113: FND_MSG_PUB.initialize;

2109: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2110: END IF;
2111:
2112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2113: FND_MSG_PUB.initialize;
2114: END IF;
2115:
2116: -- Initialize return status to SUCCESS
2117: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2199: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2195: END;
2196:
2197: END IF;
2198:
2199: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2200: p_data => p_msg_data );
2201:
2202: EXCEPTION
2203: WHEN l_INVALID_EMP_NAME THEN

Line 2205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2201:
2202: EXCEPTION
2203: WHEN l_INVALID_EMP_NAME THEN
2204: p_return_status := FND_API.G_RET_STS_ERROR;
2205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2206: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_INVALID_EMP_NAME');
2207: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
2208: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2209: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);

Line 2210: FND_MSG_PUB.Add;

2206: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_INVALID_EMP_NAME');
2207: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
2208: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2209: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);
2210: FND_MSG_PUB.Add;
2211: END IF;
2212: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2213: p_data => p_msg_data );
2214:

Line 2212: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2208: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2209: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);
2210: FND_MSG_PUB.Add;
2211: END IF;
2212: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2213: p_data => p_msg_data );
2214:
2215: WHEN l_DUPLICATE_VALUE THEN
2216: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2213: p_data => p_msg_data );
2214:
2215: WHEN l_DUPLICATE_VALUE THEN
2216: p_return_status := FND_API.G_RET_STS_ERROR;
2217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2218: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_DUPLICATE_EMPLOYEE');
2219: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
2220: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2221: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);

Line 2222: FND_MSG_PUB.Add;

2218: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_DUPLICATE_EMPLOYEE');
2219: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
2220: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2221: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);
2222: FND_MSG_PUB.Add;
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2225: p_data => p_msg_data );
2226:

Line 2224: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2220: FND_MESSAGE.SET_TOKEN('FIRST_NAME', p_emp_first_name);
2221: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_emp_last_name);
2222: FND_MSG_PUB.Add;
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2225: p_data => p_msg_data );
2226:
2227: WHEN FND_API.G_EXC_ERROR THEN
2228: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2229: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2225: p_data => p_msg_data );
2226:
2227: WHEN FND_API.G_EXC_ERROR THEN
2228: p_return_status := FND_API.G_RET_STS_ERROR;
2229: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2230: p_data => p_msg_data );
2231:
2232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2234: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2230: p_data => p_msg_data );
2231:
2232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2235: p_data => p_msg_data );
2236:
2237: WHEN OTHERS THEN
2238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2235: p_data => p_msg_data );
2236:
2237: WHEN OTHERS THEN
2238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2241: l_api_name );
2242: END IF;
2243: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

Line 2240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2236:
2237: WHEN OTHERS THEN
2238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2241: l_api_name );
2242: END IF;
2243: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2244: p_data => p_msg_data );

Line 2243: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,

2239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2241: l_api_name );
2242: END IF;
2243: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2244: p_data => p_msg_data );
2245:
2246: END Get_Employee_ID;
2247: