DBA Data[Home] [Help]

APPS.BIS_FUNCTIONAL_AREA_PVT dependencies on FND_MSG_PUB

Line 40: FND_MSG_PUB.Initialize;

36: l_Count NUMBER;
37:
38: BEGIN
39: SAVEPOINT CreateFuncAreaSP_Pvt;
40: FND_MSG_PUB.Initialize;
41:
42: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
43: l_Func_Area_Rec := p_Func_Area_Rec;
44:

Line 130: FND_MSG_PUB.Count_And_Get

126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: ROLLBACK TO CreateFuncAreaSP_Pvt;
129: IF (x_msg_data IS NULL) THEN
130: FND_MSG_PUB.Count_And_Get
131: ( p_encoded => FND_API.G_FALSE
132: , p_count => x_msg_count
133: , p_data => x_msg_data
134: );

Line 140: FND_MSG_PUB.Count_And_Get

136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: ROLLBACK TO CreateFuncAreaSP_Pvt;
139: IF (x_msg_data IS NULL) THEN
140: FND_MSG_PUB.Count_And_Get
141: ( p_encoded => FND_API.G_FALSE
142: , p_count => x_msg_count
143: , p_data => x_msg_data
144: );

Line 180: FND_MSG_PUB.Initialize;

176: l_Count NUMBER;
177: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
178: BEGIN
179: SAVEPOINT UpdateFuncAreaSP_Pvt;
180: FND_MSG_PUB.Initialize;
181: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
182:
183: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
184: (

Line 255: FND_MSG_PUB.Count_And_Get

251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UpdateFuncAreaSP_Pvt;
254: IF (x_msg_data IS NULL) THEN
255: FND_MSG_PUB.Count_And_Get
256: ( p_encoded => FND_API.G_FALSE
257: , p_count => x_msg_count
258: , p_data => x_msg_data
259: );

Line 265: FND_MSG_PUB.Count_And_Get

261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UpdateFuncAreaSP_Pvt;
264: IF (x_msg_data IS NULL) THEN
265: FND_MSG_PUB.Count_And_Get
266: ( p_encoded => FND_API.G_FALSE
267: , p_count => x_msg_count
268: , p_data => x_msg_data
269: );

Line 305: FND_MSG_PUB.Initialize;

301: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
302:
303: BEGIN
304: SAVEPOINT TransFuncAreaSP_Pvt;
305: FND_MSG_PUB.Initialize;
306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
307:
308: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
309: (

Line 377: FND_MSG_PUB.Count_And_Get

373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO TransFuncAreaSP_Pvt;
376: IF (x_msg_data IS NULL) THEN
377: FND_MSG_PUB.Count_And_Get
378: ( p_encoded => FND_API.G_FALSE
379: , p_count => x_msg_count
380: , p_data => x_msg_data
381: );

Line 387: FND_MSG_PUB.Count_And_Get

383: x_return_status := FND_API.G_RET_STS_ERROR;
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO TransFuncAreaSP_Pvt;
386: IF (x_msg_data IS NULL) THEN
387: FND_MSG_PUB.Count_And_Get
388: ( p_encoded => FND_API.G_FALSE
389: , p_count => x_msg_count
390: , p_data => x_msg_data
391: );

Line 436: FND_MSG_PUB.Initialize;

432: FROM BIS_FUNCTIONAL_AREAS_VL F
433: WHERE F.SHORT_NAME = p_Func_Area_Rec.Short_Name;
434:
435: BEGIN
436: FND_MSG_PUB.Initialize;
437: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
438: l_Count := 0;
439:
440: FOR cRFA IN cRetrieveFuncArea LOOP

Line 460: FND_MSG_PUB.Count_And_Get

456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (x_msg_data IS NULL) THEN
460: FND_MSG_PUB.Count_And_Get
461: ( p_encoded => FND_API.G_FALSE
462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );

Line 469: FND_MSG_PUB.Count_And_Get

465: END IF;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: IF (x_msg_data IS NULL) THEN
469: FND_MSG_PUB.Count_And_Get
470: ( p_encoded => FND_API.G_FALSE
471: , p_count => x_msg_count
472: , p_data => x_msg_data
473: );

Line 511: FND_MSG_PUB.Initialize;

507: --l_Default_Flag VARCHAR2(1);
508:
509: BEGIN
510: SAVEPOINT CreateFuncAreaAppDepSP_Pvt;
511: FND_MSG_PUB.Initialize;
512:
513: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
514:
515: INSERT INTO BIS_FUNC_AREA_APP_DEPENDENCY

Line 535: FND_MSG_PUB.Count_And_Get

531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
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_Pvt;
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_Pvt;
586: FND_MSG_PUB.Initialize;
587:
588: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
589:
590: -- currently we do not have the default flag to update,

Line 602: FND_MSG_PUB.Count_And_Get

598: EXCEPTION
599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
601: IF (x_msg_data IS NULL) THEN
602: FND_MSG_PUB.Count_And_Get
603: ( p_encoded => FND_API.G_FALSE
604: , p_count => x_msg_count
605: , p_data => x_msg_data
606: );

Line 612: FND_MSG_PUB.Count_And_Get

608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
611: IF (x_msg_data IS NULL) THEN
612: FND_MSG_PUB.Count_And_Get
613: ( p_encoded => FND_API.G_FALSE
614: , p_count => x_msg_count
615: , p_data => x_msg_data
616: );

Line 658: FND_MSG_PUB.Initialize;

654: FROM BIS_FUNC_AREA_APP_DEPENDENCY B
655: WHERE B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
656: BEGIN
657: SAVEPOINT DeleteFuncAreaSP_Pvt;
658: FND_MSG_PUB.Initialize;
659: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
660: l_Func_Area_Rec := p_Func_Area_Rec;
661:
662: FOR cFAD IN c_FuncArea_Dep LOOP

Line 693: FND_MSG_PUB.Count_And_Get

689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO DeleteFuncAreaSP_Pvt;
692: IF (x_msg_data IS NULL) THEN
693: FND_MSG_PUB.Count_And_Get
694: ( p_encoded => FND_API.G_FALSE
695: , p_count => x_msg_count
696: , p_data => x_msg_data
697: );

Line 703: FND_MSG_PUB.Count_And_Get

699: x_return_status := FND_API.G_RET_STS_ERROR;
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO DeleteFuncAreaSP_Pvt;
702: IF (x_msg_data IS NULL) THEN
703: FND_MSG_PUB.Count_And_Get
704: ( p_encoded => FND_API.G_FALSE
705: , p_count => x_msg_count
706: , p_data => x_msg_data
707: );

Line 742: FND_MSG_PUB.Initialize;

738: l_Count NUMBER;
739:
740: BEGIN
741: SAVEPOINT RemoveFuncAreaDependencySP_Pvt;
742: FND_MSG_PUB.Initialize;
743: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
744:
745: DELETE BIS_FUNC_AREA_APP_DEPENDENCY B
746: WHERE B.FUNCTIONAL_AREA_ID = p_Functional_Area_Id

Line 758: FND_MSG_PUB.Count_And_Get

754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
757: IF (x_msg_data IS NULL) THEN
758: FND_MSG_PUB.Count_And_Get
759: ( p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data
762: );

Line 768: FND_MSG_PUB.Count_And_Get

764: x_return_status := FND_API.G_RET_STS_ERROR;
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get
769: ( p_encoded => FND_API.G_FALSE
770: , p_count => x_msg_count
771: , p_data => x_msg_data
772: );