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

Line 65: FND_MSG_PUB.Initialize;

61: l_Count NUMBER;
62:
63: BEGIN
64: SAVEPOINT CreateFuncAreaSP;
65: FND_MSG_PUB.Initialize;
66:
67: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
68: l_Func_Area_Rec := p_Func_Area_Rec;
69:

Line 106: FND_MSG_PUB.Count_And_Get

102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: ROLLBACK TO CreateFuncAreaSP;
105: IF (x_msg_data IS NULL) THEN
106: FND_MSG_PUB.Count_And_Get
107: ( p_encoded => FND_API.G_FALSE
108: , p_count => x_msg_count
109: , p_data => x_msg_data
110: );

Line 116: FND_MSG_PUB.Count_And_Get

112: x_return_status := FND_API.G_RET_STS_ERROR;
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: ROLLBACK TO CreateFuncAreaSP;
115: IF (x_msg_data IS NULL) THEN
116: FND_MSG_PUB.Count_And_Get
117: ( p_encoded => FND_API.G_FALSE
118: , p_count => x_msg_count
119: , p_data => x_msg_data
120: );

Line 156: FND_MSG_PUB.Initialize;

152: l_Count NUMBER;
153: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
154: BEGIN
155: SAVEPOINT UpdateFuncAreaSP;
156: FND_MSG_PUB.Initialize;
157: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
158:
159: Validate_Functional_Area(
160: p_Func_Area_Rec => p_Func_Area_Rec

Line 193: FND_MSG_PUB.Count_And_Get

189: EXCEPTION
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO UpdateFuncAreaSP;
192: IF (x_msg_data IS NULL) THEN
193: FND_MSG_PUB.Count_And_Get
194: ( p_encoded => FND_API.G_FALSE
195: , p_count => x_msg_count
196: , p_data => x_msg_data
197: );

Line 203: FND_MSG_PUB.Count_And_Get

199: x_return_status := FND_API.G_RET_STS_ERROR;
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO UpdateFuncAreaSP;
202: IF (x_msg_data IS NULL) THEN
203: FND_MSG_PUB.Count_And_Get
204: ( p_encoded => FND_API.G_FALSE
205: , p_count => x_msg_count
206: , p_data => x_msg_data
207: );

Line 240: FND_MSG_PUB.Initialize;

236: ,x_Msg_Data OUT NOCOPY VARCHAR2
237: ) IS
238:
239: BEGIN
240: FND_MSG_PUB.Initialize;
241: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
242:
243:
244: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area(

Line 259: FND_MSG_PUB.Count_And_Get

255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: IF (x_msg_data IS NULL) THEN
259: FND_MSG_PUB.Count_And_Get
260: ( p_encoded => FND_API.G_FALSE
261: , p_count => x_msg_count
262: , p_data => x_msg_data
263: );

Line 268: FND_MSG_PUB.Count_And_Get

264: END IF;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: IF (x_msg_data IS NULL) THEN
268: FND_MSG_PUB.Count_And_Get
269: ( p_encoded => FND_API.G_FALSE
270: , p_count => x_msg_count
271: , p_data => x_msg_data
272: );

Line 306: FND_MSG_PUB.Initialize;

302: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
303:
304: BEGIN
305: SAVEPOINT TransFuncAreaSP;
306: FND_MSG_PUB.Initialize;
307: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
308:
309: -- Modularize this into a single API (Update and Retrieve)
310:

Line 343: FND_MSG_PUB.Count_And_Get

339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO TransFuncAreaSP;
342: IF (x_msg_data IS NULL) THEN
343: FND_MSG_PUB.Count_And_Get
344: ( p_encoded => FND_API.G_FALSE
345: , p_count => x_msg_count
346: , p_data => x_msg_data
347: );

Line 353: FND_MSG_PUB.Count_And_Get

349: x_return_status := FND_API.G_RET_STS_ERROR;
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO TransFuncAreaSP;
352: IF (x_msg_data IS NULL) THEN
353: FND_MSG_PUB.Count_And_Get
354: ( p_encoded => FND_API.G_FALSE
355: , p_count => x_msg_count
356: , p_data => x_msg_data
357: );

Line 393: FND_MSG_PUB.Initialize;

389: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
390:
391: BEGIN
392: SAVEPOINT LoadFuncAreaSP;
393: FND_MSG_PUB.Initialize;
394: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
395:
396: BIS_FUNCTIONAL_AREA_PUB.Retrieve_Functional_Area
397: (

Line 441: FND_MSG_PUB.Count_And_Get

437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO LoadFuncAreaSP;
440: IF (x_msg_data IS NULL) THEN
441: FND_MSG_PUB.Count_And_Get
442: ( p_encoded => FND_API.G_FALSE
443: , p_count => x_msg_count
444: , p_data => x_msg_data
445: );

Line 452: FND_MSG_PUB.Count_And_Get

448: RAISE;
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: ROLLBACK TO LoadFuncAreaSP;
451: IF (x_msg_data IS NULL) THEN
452: FND_MSG_PUB.Count_And_Get
453: ( p_encoded => FND_API.G_FALSE
454: , p_count => x_msg_count
455: , p_data => x_msg_data
456: );

Line 499: FND_MSG_PUB.Initialize;

495: --l_Default_Flag VARCHAR2(1);
496:
497: BEGIN
498: SAVEPOINT CreateFuncAreaAppDepSP;
499: FND_MSG_PUB.Initialize;
500:
501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
502:
503: Validate_Func_Area_Apps_Dep (

Line 535: FND_MSG_PUB.Count_And_Get

531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO CreateFuncAreaAppDepSP;
534: IF (x_msg_data IS NULL) THEN
535: FND_MSG_PUB.Count_And_Get
536: ( p_encoded => FND_API.G_FALSE
537: , p_count => x_msg_count
538: , p_data => x_msg_data
539: );

Line 545: FND_MSG_PUB.Count_And_Get

541: x_return_status := FND_API.G_RET_STS_ERROR;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO CreateFuncAreaAppDepSP;
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );

Line 586: FND_MSG_PUB.Initialize;

582: --l_Temp_Default_Flag VARCHAR2(1);
583:
584: BEGIN
585: SAVEPOINT UpdateFuncAreaAppDepSP;
586: FND_MSG_PUB.Initialize;
587:
588: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
589:
590: Validate_Func_Area_Apps_Dep (

Line 624: FND_MSG_PUB.Count_And_Get

620: EXCEPTION
621: WHEN FND_API.G_EXC_ERROR THEN
622: ROLLBACK TO UpdateFuncAreaAppDepSP;
623: IF (x_msg_data IS NULL) THEN
624: FND_MSG_PUB.Count_And_Get
625: ( p_encoded => FND_API.G_FALSE
626: , p_count => x_msg_count
627: , p_data => x_msg_data
628: );

Line 634: FND_MSG_PUB.Count_And_Get

630: x_return_status := FND_API.G_RET_STS_ERROR;
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: ROLLBACK TO UpdateFuncAreaAppDepSP;
633: IF (x_msg_data IS NULL) THEN
634: FND_MSG_PUB.Count_And_Get
635: ( p_encoded => FND_API.G_FALSE
636: , p_count => x_msg_count
637: , p_data => x_msg_data
638: );

Line 672: FND_MSG_PUB.Initialize;

668: l_Count NUMBER;
669: l_Func_Area_App_Dep_Rec BIS_FUNCTIONAL_AREA_PUB.Func_Area_Apps_Depend_Rec_Type;
670: BEGIN
671: SAVEPOINT LoadFuncAreaAppDepSP;
672: FND_MSG_PUB.Initialize;
673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
674:
675: l_Func_Area_App_Dep_Rec := p_Func_Area_App_Dep_Rec;
676:

Line 722: FND_MSG_PUB.Count_And_Get

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO LoadFuncAreaAppDepSP;
721: IF (x_msg_data IS NULL) THEN
722: FND_MSG_PUB.Count_And_Get
723: ( p_encoded => FND_API.G_FALSE
724: , p_count => x_msg_count
725: , p_data => x_msg_data
726: );

Line 733: FND_MSG_PUB.Count_And_Get

729: RAISE;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: ROLLBACK TO LoadFuncAreaAppDepSP;
732: IF (x_msg_data IS NULL) THEN
733: FND_MSG_PUB.Count_And_Get
734: ( p_encoded => FND_API.G_FALSE
735: , p_count => x_msg_count
736: , p_data => x_msg_data
737: );

Line 771: FND_MSG_PUB.Initialize;

767: ,x_Msg_Data OUT NOCOPY VARCHAR2
768: ) IS
769: l_Count NUMBER;
770: BEGIN
771: FND_MSG_PUB.Initialize;
772: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
773:
774: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(LTRIM(RTRIM(p_Func_Area_Rec.Short_Name))) = FND_API.G_TRUE) THEN
775: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');

Line 776: FND_MSG_PUB.ADD;

772: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
773:
774: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(LTRIM(RTRIM(p_Func_Area_Rec.Short_Name))) = FND_API.G_TRUE) THEN
775: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:
780:

Line 791: FND_MSG_PUB.ADD;

787:
788: IF (l_Count <> 0) THEN
789: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_EXISTS');
790: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN

Line 797: FND_MSG_PUB.ADD;

793: END IF;
794:
795: IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN
796: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
797: FND_MSG_PUB.ADD;
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800:
801:

Line 804: FND_MSG_PUB.ADD;

800:
801:
802: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(LTRIM(RTRIM(p_Func_Area_Rec.Name))) = FND_API.G_TRUE) THEN
803: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_NAME_NOT_ENTERED');
804: FND_MSG_PUB.ADD;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: ELSIF(p_Action_Type = C_UPDATE OR p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE) THEN

Line 813: FND_MSG_PUB.ADD;

809:
810: /*
811: IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN
812: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: */
817:

Line 825: FND_MSG_PUB.ADD;

821:
822: IF (l_Count = 0) THEN
823: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');
824: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: END IF;

Line 834: FND_MSG_PUB.Count_And_Get

830:
831: EXCEPTION
832: WHEN FND_API.G_EXC_ERROR THEN
833: IF (x_msg_data IS NULL) THEN
834: FND_MSG_PUB.Count_And_Get
835: ( p_encoded => FND_API.G_FALSE
836: , p_count => x_msg_count
837: , p_data => x_msg_data
838: );

Line 843: FND_MSG_PUB.Count_And_Get

839: END IF;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: IF (x_msg_data IS NULL) THEN
843: FND_MSG_PUB.Count_And_Get
844: ( p_encoded => FND_API.G_FALSE
845: , p_count => x_msg_count
846: , p_data => x_msg_data
847: );

Line 879: FND_MSG_PUB.Initialize;

875: ,x_Msg_Data OUT NOCOPY VARCHAR2
876: ) IS
877: l_Count NUMBER;
878: BEGIN
879: FND_MSG_PUB.Initialize;
880: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
881:
882: IF (p_Functional_Area_Id IS NULL) THEN
883: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

Line 884: FND_MSG_PUB.ADD;

880: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
881:
882: IF (p_Functional_Area_Id IS NULL) THEN
883: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:
888: IF (p_Application_Id IS NULL) THEN

Line 890: FND_MSG_PUB.ADD;

886: END IF;
887:
888: IF (p_Application_Id IS NULL) THEN
889: FND_MESSAGE.SET_NAME('BIS','BIS_APP_ID_NOT_ENTERED');
890: FND_MSG_PUB.ADD;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:
894: SELECT COUNT(1) INTO l_Count

Line 901: FND_MSG_PUB.ADD;

897:
898: IF (l_Count = 0) THEN
899: FND_MESSAGE.SET_NAME('BIS','BIS_FA_ID_NOT_EXISTS');
900: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904:
905:

Line 917: FND_MSG_PUB.ADD;

913:
914: IF (l_Count = 0) THEN
915: FND_MESSAGE.SET_NAME('BIS','BIS_APPS_ID_NOT_EXISTS');
916: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;
921:

Line 931: FND_MSG_PUB.ADD;

927: IF l_Count <> 0 THEN
928: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_EXIST');
929: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
930: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935:

Line 943: FND_MSG_PUB.ADD;

939:
940: IF l_Count > 0 THEN
941: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_ALREADY_EXIST');
942: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
943: FND_MSG_PUB.ADD;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;
946:
947:

Line 961: FND_MSG_PUB.ADD;

957: IF (l_Count = 0) THEN
958: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_NOT_EXIST');
959: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
960: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;
964:
965:

Line 972: FND_MSG_PUB.Count_And_Get

968: EXCEPTION
969:
970: WHEN FND_API.G_EXC_ERROR THEN
971: IF (x_msg_data IS NULL) THEN
972: FND_MSG_PUB.Count_And_Get
973: ( p_encoded => FND_API.G_FALSE
974: , p_count => x_msg_count
975: , p_data => x_msg_data
976: );

Line 981: FND_MSG_PUB.Count_And_Get

977: END IF;
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: IF (x_msg_data IS NULL) THEN
981: FND_MSG_PUB.Count_And_Get
982: ( p_encoded => FND_API.G_FALSE
983: , p_count => x_msg_count
984: , p_data => x_msg_data
985: );

Line 1068: FND_MSG_PUB.Initialize;

1064: FROM BIS_FUNC_AREA_APP_DEPENDENCY B
1065: WHERE B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
1066: BEGIN
1067: SAVEPOINT DeleteFuncAreaSP;
1068: FND_MSG_PUB.Initialize;
1069: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1070: l_Func_Area_Rec := p_Func_Area_Rec;
1071:
1072: Validate_Functional_Area(

Line 1117: FND_MSG_PUB.Count_And_Get

1113: EXCEPTION
1114: WHEN FND_API.G_EXC_ERROR THEN
1115: ROLLBACK TO DeleteFuncAreaSP;
1116: IF (x_msg_data IS NULL) THEN
1117: FND_MSG_PUB.Count_And_Get
1118: ( p_encoded => FND_API.G_FALSE
1119: , p_count => x_msg_count
1120: , p_data => x_msg_data
1121: );

Line 1127: FND_MSG_PUB.Count_And_Get

1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1125: ROLLBACK TO DeleteFuncAreaSP;
1126: IF (x_msg_data IS NULL) THEN
1127: FND_MSG_PUB.Count_And_Get
1128: ( p_encoded => FND_API.G_FALSE
1129: , p_count => x_msg_count
1130: , p_data => x_msg_data
1131: );

Line 1166: FND_MSG_PUB.Initialize;

1162: l_Count NUMBER;
1163:
1164: BEGIN
1165: SAVEPOINT RemoveFuncAreaDependencySP;
1166: FND_MSG_PUB.Initialize;
1167: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1168:
1169: Validate_Func_Area_Apps_Dep (
1170: p_Functional_Area_Id => p_Functional_Area_Id

Line 1203: FND_MSG_PUB.Count_And_Get

1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: ROLLBACK TO RemoveFuncAreaDependencySP;
1202: IF (x_msg_data IS NULL) THEN
1203: FND_MSG_PUB.Count_And_Get
1204: ( p_encoded => FND_API.G_FALSE
1205: , p_count => x_msg_count
1206: , p_data => x_msg_data
1207: );

Line 1213: FND_MSG_PUB.Count_And_Get

1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: ROLLBACK TO RemoveFuncAreaDependencySP;
1212: IF (x_msg_data IS NULL) THEN
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );