DBA Data[Home] [Help]

APPS.BSC_SCORECARD_PUB dependencies on FND_MSG_PUB

Line 55: FND_MSG_PUB.Initialize;

51:
52: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
53:
54: begin
55: FND_MSG_PUB.Initialize;
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: -- Assign all values in the passed "Record" parameter to the locally defined
58: -- "Record" variable.
59: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;

Line 66: FND_MSG_PUB.ADD;

62: if l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name is not null then
63: if BSC_SCORECARD_PVT.Validate_Tab(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name) > 0 then
64: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_NAME_EXISTS');
65: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
66: FND_MSG_PUB.ADD;
67: RAISE FND_API.G_EXC_ERROR;
68: end if;
69: end if;
70:

Line 134: FND_MSG_PUB.Count_And_Get

130:
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: IF (x_msg_data IS NULL) THEN
134: FND_MSG_PUB.Count_And_Get
135: ( p_encoded => FND_API.G_FALSE
136: , p_count => x_msg_count
137: , p_data => x_msg_data
138: );

Line 144: FND_MSG_PUB.Count_And_Get

140: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: IF (x_msg_data IS NULL) THEN
144: FND_MSG_PUB.Count_And_Get
145: ( p_encoded => FND_API.G_FALSE
146: , p_count => x_msg_count
147: , p_data => x_msg_data
148: );

Line 187: FND_MSG_PUB.Initialize;

183: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
184: l_Bsc_Tab_Entity_Rec_Out BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
185:
186: begin
187: FND_MSG_PUB.Initialize;
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
190:
191: BSC_SCORECARD_PUB.Create_Tab(

Line 207: FND_MSG_PUB.Count_And_Get

203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: IF (x_msg_data IS NULL) THEN
207: FND_MSG_PUB.Count_And_Get
208: ( p_encoded => FND_API.G_FALSE
209: , p_count => x_msg_count
210: , p_data => x_msg_data
211: );

Line 217: FND_MSG_PUB.Count_And_Get

213: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: IF (x_msg_data IS NULL) THEN
217: FND_MSG_PUB.Count_And_Get
218: ( p_encoded => FND_API.G_FALSE
219: , p_count => x_msg_count
220: , p_data => x_msg_data
221: );

Line 257: FND_MSG_PUB.Initialize;

253: ,x_msg_data OUT NOCOPY varchar2
254: ) is
255:
256: begin
257: FND_MSG_PUB.Initialize;
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: x_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
261:

Line 301: FND_MSG_PUB.Initialize;

297: ,x_msg_data OUT NOCOPY varchar2
298: ) is
299:
300: begin
301: FND_MSG_PUB.Initialize;
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303: BSC_SCORECARD_PVT.Retrieve_Tab( p_commit
304: ,p_Bsc_Tab_Entity_Rec
305: ,x_Bsc_Tab_Entity_Rec

Line 313: FND_MSG_PUB.Count_And_Get

309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: IF (x_msg_data IS NULL) THEN
313: FND_MSG_PUB.Count_And_Get
314: ( p_encoded => FND_API.G_FALSE
315: , p_count => x_msg_count
316: , p_data => x_msg_data
317: );

Line 323: FND_MSG_PUB.Count_And_Get

319: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: IF (x_msg_data IS NULL) THEN
323: FND_MSG_PUB.Count_And_Get
324: ( p_encoded => FND_API.G_FALSE
325: , p_count => x_msg_count
326: , p_data => x_msg_data
327: );

Line 362: FND_MSG_PUB.Initialize;

358: ,x_msg_data OUT NOCOPY varchar2
359: ) is
360:
361: begin
362: FND_MSG_PUB.Initialize;
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: BSC_SCORECARD_PVT.Update_Tab( p_commit
365: ,p_Bsc_Tab_Entity_Rec
366: ,x_return_status

Line 373: FND_MSG_PUB.Count_And_Get

369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: IF (x_msg_data IS NULL) THEN
373: FND_MSG_PUB.Count_And_Get
374: ( p_encoded => FND_API.G_FALSE
375: , p_count => x_msg_count
376: , p_data => x_msg_data
377: );

Line 383: FND_MSG_PUB.Count_And_Get

379: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: IF (x_msg_data IS NULL) THEN
383: FND_MSG_PUB.Count_And_Get
384: ( p_encoded => FND_API.G_FALSE
385: , p_count => x_msg_count
386: , p_data => x_msg_data
387: );

Line 422: FND_MSG_PUB.Initialize;

418: ,x_msg_data OUT NOCOPY varchar2
419: ) is
420:
421: begin
422: FND_MSG_PUB.Initialize;
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424: BSC_SCORECARD_PVT.Delete_Tab( p_commit
425: ,p_Bsc_Tab_Entity_Rec
426: ,x_return_status

Line 433: FND_MSG_PUB.Count_And_Get

429:
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: IF (x_msg_data IS NULL) THEN
433: FND_MSG_PUB.Count_And_Get
434: ( p_encoded => FND_API.G_FALSE
435: , p_count => x_msg_count
436: , p_data => x_msg_data
437: );

Line 443: FND_MSG_PUB.Count_And_Get

439: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: IF (x_msg_data IS NULL) THEN
443: FND_MSG_PUB.Count_And_Get
444: ( p_encoded => FND_API.G_FALSE
445: , p_count => x_msg_count
446: , p_data => x_msg_data
447: );

Line 490: FND_MSG_PUB.Initialize;

486: FROM fnd_responsibility
487: WHERE INSTR(','||p_Resposibility_Key||',',','||responsibility_key||',') > 0;
488:
489: BEGIN
490: FND_MSG_PUB.Initialize;
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
493:
494: FOR CD IN c_Resp_Ids LOOP

Line 524: FND_MSG_PUB.Count_And_Get

520:
521: EXCEPTION
522: WHEN FND_API.G_EXC_ERROR THEN
523: IF (x_msg_data IS NULL) THEN
524: FND_MSG_PUB.Count_And_Get
525: ( p_encoded => FND_API.G_FALSE
526: , p_count => x_msg_count
527: , p_data => x_msg_data
528: );

Line 534: FND_MSG_PUB.Count_And_Get

530: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: IF (x_msg_data IS NULL) THEN
534: FND_MSG_PUB.Count_And_Get
535: ( p_encoded => FND_API.G_FALSE
536: , p_count => x_msg_count
537: , p_data => x_msg_data
538: );

Line 577: FND_MSG_PUB.Initialize;

573: l_Comma_Sep_Resp_Key VARCHAR2(32000):= NULL;
574: l_Tab_Short_Name BSC_TABS_B.SHORT_NAME%TYPE := NULL;
575:
576: BEGIN
577: FND_MSG_PUB.Initialize;
578: x_return_status := FND_API.G_RET_STS_SUCCESS;
579: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
580:
581: BEGIN

Line 621: FND_MSG_PUB.Count_And_Get

617:
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: IF (x_msg_data IS NULL) THEN
621: FND_MSG_PUB.Count_And_Get
622: ( p_encoded => FND_API.G_FALSE
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );

Line 631: FND_MSG_PUB.Count_And_Get

627: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: IF (x_msg_data IS NULL) THEN
631: FND_MSG_PUB.Count_And_Get
632: ( p_encoded => FND_API.G_FALSE
633: , p_count => x_msg_count
634: , p_data => x_msg_data
635: );

Line 674: FND_MSG_PUB.Initialize;

670:
671: l_responsibility_key varchar2(30);
672:
673: begin
674: FND_MSG_PUB.Initialize;
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676: -- set local record equal to the one passed.
677: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
678:

Line 689: FND_MSG_PUB.Count_And_Get

685:
686: EXCEPTION
687: WHEN FND_API.G_EXC_ERROR THEN
688: IF (x_msg_data IS NULL) THEN
689: FND_MSG_PUB.Count_And_Get
690: ( p_encoded => FND_API.G_FALSE
691: , p_count => x_msg_count
692: , p_data => x_msg_data
693: );

Line 699: FND_MSG_PUB.Count_And_Get

695: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: IF (x_msg_data IS NULL) THEN
699: FND_MSG_PUB.Count_And_Get
700: ( p_encoded => FND_API.G_FALSE
701: , p_count => x_msg_count
702: , p_data => x_msg_data
703: );

Line 738: FND_MSG_PUB.Initialize;

734: ,x_msg_data OUT NOCOPY varchar2
735: ) is
736:
737: begin
738: FND_MSG_PUB.Initialize;
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740: BSC_SCORECARD_PVT.Update_System_Time_Stamp( p_commit
741: ,p_Bsc_Tab_Entity_Rec
742: ,x_return_status

Line 749: FND_MSG_PUB.Count_And_Get

745:
746: EXCEPTION
747: WHEN FND_API.G_EXC_ERROR THEN
748: IF (x_msg_data IS NULL) THEN
749: FND_MSG_PUB.Count_And_Get
750: ( p_encoded => FND_API.G_FALSE
751: , p_count => x_msg_count
752: , p_data => x_msg_data
753: );

Line 759: FND_MSG_PUB.Count_And_Get

755: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: IF (x_msg_data IS NULL) THEN
759: FND_MSG_PUB.Count_And_Get
760: ( p_encoded => FND_API.G_FALSE
761: , p_count => x_msg_count
762: , p_data => x_msg_data
763: );

Line 798: FND_MSG_PUB.Initialize;

794: ,x_msg_data OUT NOCOPY varchar2
795: ) is
796:
797: begin
798: FND_MSG_PUB.Initialize;
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800: BSC_SCORECARD_PVT.Update_Tab_Time_Stamp( p_commit
801: ,p_Bsc_Tab_Entity_Rec
802: ,x_return_status

Line 809: FND_MSG_PUB.Count_And_Get

805:
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: IF (x_msg_data IS NULL) THEN
809: FND_MSG_PUB.Count_And_Get
810: ( p_encoded => FND_API.G_FALSE
811: , p_count => x_msg_count
812: , p_data => x_msg_data
813: );

Line 819: FND_MSG_PUB.Count_And_Get

815: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: IF (x_msg_data IS NULL) THEN
819: FND_MSG_PUB.Count_And_Get
820: ( p_encoded => FND_API.G_FALSE
821: , p_count => x_msg_count
822: , p_data => x_msg_data
823: );