DBA Data[Home] [Help]

APPS.BSC_SEC_UTILITY dependencies on FND_MSG_PUB

Line 177: FND_MSG_PUB.initialize;

173:
174: -- Initialize API message list if necessary.
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean( p_init_msg_list ) THEN
177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: if (P_ROWID is not null) then
181: update bsc_user_tab_access

Line 241: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

237: -- Make a standard call to get message count
238: -- and if count is 1, get message info.
239: -- The client will directly display the x_msg_data (which is already
240: -- translated) if the x_msg_count = 1;
241: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
242: -- Server-side procedure to access the messages, and consolidate them
243: -- and display them all at once or display one message after another.
244:
245: FND_MSG_PUB.Count_And_Get

Line 245: FND_MSG_PUB.Count_And_Get

241: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
242: -- Server-side procedure to access the messages, and consolidate them
243: -- and display them all at once or display one message after another.
244:
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count,
247: p_data => x_msg_data
248: );
249:

Line 255: IF FND_MSG_PUB.Check_Msg_Level

251: when no_data_found then
252: return;
253: when others then
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level
256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg
259: ( G_PKG_NAME,

Line 256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

252: return;
253: when others then
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level
256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg
259: ( G_PKG_NAME,
260: l_api_name

Line 258: FND_MSG_PUB.Add_Exc_Msg

254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level
256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg
259: ( G_PKG_NAME,
260: l_api_name
261: );
262: END IF;

Line 263: FND_MSG_PUB.Count_And_Get

259: ( G_PKG_NAME,
260: l_api_name
261: );
262: END IF;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 299: FND_MSG_PUB.initialize;

295:
296: -- Initialize API message list if necessary.
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: if (P_ROWID is not null) then
303: update bsc_user_list_access

Line 331: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

327: -- Make a standard call to get message count
328: -- and if count is 1, get message info.
329: -- The client will directly display the x_msg_data (which is already
330: -- translated) if the x_msg_count = 1;
331: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
332: -- Server-side procedure to access the messages, and consolidate them
333: -- and display them all at once or display one message after another.
334:
335: FND_MSG_PUB.Count_And_Get

Line 335: FND_MSG_PUB.Count_And_Get

331: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
332: -- Server-side procedure to access the messages, and consolidate them
333: -- and display them all at once or display one message after another.
334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339:

Line 345: IF FND_MSG_PUB.Check_Msg_Level

341: when no_data_found then
342: return;
343: when others then
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level
346: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,

Line 346: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

342: return;
343: when others then
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level
346: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,
350: l_api_name

Line 348: FND_MSG_PUB.Add_Exc_Msg

344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level
346: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,
350: l_api_name
351: );
352: END IF;

Line 353: FND_MSG_PUB.Count_And_Get

349: ( G_PKG_NAME,
350: l_api_name
351: );
352: END IF;
353: FND_MSG_PUB.Count_And_Get
354: ( p_count => x_msg_count,
355: p_data => x_msg_data
356: );
357: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 392: FND_MSG_PUB.initialize;

388:
389: -- Initialize API message list if necessary.
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394:
395: insert into bsc_user_list_access
396: (

Line 427: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

423: -- Make a standard call to get message count
424: -- and if count is 1, get message info.
425: -- The client will directly display the x_msg_data (which is already
426: -- translated) if the x_msg_count = 1;
427: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
428: -- Server-side procedure to access the messages, and consolidate them
429: -- and display them all at once or display one message after another.
430:
431: FND_MSG_PUB.Count_And_Get

Line 431: FND_MSG_PUB.Count_And_Get

427: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
428: -- Server-side procedure to access the messages, and consolidate them
429: -- and display them all at once or display one message after another.
430:
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435:

Line 441: IF FND_MSG_PUB.Check_Msg_Level

437: when no_data_found then
438: return;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF FND_MSG_PUB.Check_Msg_Level
442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg
445: ( G_PKG_NAME,

Line 442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

438: return;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF FND_MSG_PUB.Check_Msg_Level
442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg
445: ( G_PKG_NAME,
446: l_api_name

Line 444: FND_MSG_PUB.Add_Exc_Msg

440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF FND_MSG_PUB.Check_Msg_Level
442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg
445: ( G_PKG_NAME,
446: l_api_name
447: );
448: END IF;

Line 449: FND_MSG_PUB.Count_And_Get

445: ( G_PKG_NAME,
446: l_api_name
447: );
448: END IF;
449: FND_MSG_PUB.Count_And_Get
450: ( p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 571: FND_MSG_PUB.initialize;

567: l_dummy:=null;
568: -- Initialize API message list if necessary.
569: -- Initialize message list if p_init_msg_list is set to TRUE.
570: IF FND_API.to_Boolean( p_init_msg_list ) THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: open row_exists;
575: fetch row_exists into l_dummy;

Line 661: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

657: -- Make a standard call to get message count
658: -- and if count is 1, get message info.
659: -- The client will directly display the x_msg_data (which is already
660: -- translated) if the x_msg_count = 1;
661: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
662: -- Server-side procedure to access the messages, and consolidate them
663: -- and display them all at once or display one message after another.
664:
665: FND_MSG_PUB.Count_And_Get

Line 665: FND_MSG_PUB.Count_And_Get

661: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
662: -- Server-side procedure to access the messages, and consolidate them
663: -- and display them all at once or display one message after another.
664:
665: FND_MSG_PUB.Count_And_Get
666: ( p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669:

Line 675: IF FND_MSG_PUB.Check_Msg_Level

671: when no_data_found then
672: return;
673: when others then
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,

Line 676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

672: return;
673: when others then
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,
680: l_api_name

Line 678: FND_MSG_PUB.Add_Exc_Msg

674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME,
680: l_api_name
681: );
682: END IF;

Line 683: FND_MSG_PUB.Count_And_Get

679: ( G_PKG_NAME,
680: l_api_name
681: );
682: END IF;
683: FND_MSG_PUB.Count_And_Get
684: ( p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 735: FND_MSG_PUB.initialize;

731: l_dummy:=null;
732: -- Initialize API message list if necessary.
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
735: FND_MSG_PUB.initialize;
736: END IF;
737:
738: open row_exists;
739: fetch row_exists into l_dummy;

Line 789: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

785: -- Make a standard call to get message count
786: -- and if count is 1, get message info.
787: -- The client will directly display the x_msg_data (which is already
788: -- translated) if the x_msg_count = 1;
789: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
790: -- Server-side procedure to access the messages, and consolidate them
791: -- and display them all at once or display one message after another.
792:
793: FND_MSG_PUB.Count_And_Get

Line 793: FND_MSG_PUB.Count_And_Get

789: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
790: -- Server-side procedure to access the messages, and consolidate them
791: -- and display them all at once or display one message after another.
792:
793: FND_MSG_PUB.Count_And_Get
794: ( p_count => x_msg_count,
795: p_data => x_msg_data
796: );
797:

Line 803: IF FND_MSG_PUB.Check_Msg_Level

799: when no_data_found then
800: return;
801: when others then
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level
804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: FND_MSG_PUB.Add_Exc_Msg
807: ( G_PKG_NAME,

Line 804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

800: return;
801: when others then
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level
804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: FND_MSG_PUB.Add_Exc_Msg
807: ( G_PKG_NAME,
808: l_api_name

Line 806: FND_MSG_PUB.Add_Exc_Msg

802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level
804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: FND_MSG_PUB.Add_Exc_Msg
807: ( G_PKG_NAME,
808: l_api_name
809: );
810: END IF;

Line 811: FND_MSG_PUB.Count_And_Get

807: ( G_PKG_NAME,
808: l_api_name
809: );
810: END IF;
811: FND_MSG_PUB.Count_And_Get
812: ( p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 848: FND_MSG_PUB.initialize;

844:
845: -- Initialize API message list if necessary.
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list ) THEN
848: FND_MSG_PUB.initialize;
849: END IF;
850:
851: if (P_ROWID is not null) then
852: update bsc_user_kpi_access

Line 880: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

876: -- Make a standard call to get message count
877: -- and if count is 1, get message info.
878: -- The client will directly display the x_msg_data (which is already
879: -- translated) if the x_msg_count = 1;
880: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
881: -- Server-side procedure to access the messages, and consolidate them
882: -- and display them all at once or display one message after another.
883:
884: FND_MSG_PUB.Count_And_Get

Line 884: FND_MSG_PUB.Count_And_Get

880: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
881: -- Server-side procedure to access the messages, and consolidate them
882: -- and display them all at once or display one message after another.
883:
884: FND_MSG_PUB.Count_And_Get
885: ( p_count => x_msg_count,
886: p_data => x_msg_data
887: );
888:

Line 894: IF FND_MSG_PUB.Check_Msg_Level

890: when no_data_found then
891: return;
892: when others then
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level
895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PKG_NAME,

Line 895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

891: return;
892: when others then
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level
895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PKG_NAME,
899: l_api_name

Line 897: FND_MSG_PUB.Add_Exc_Msg

893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level
895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PKG_NAME,
899: l_api_name
900: );
901: END IF;

Line 902: FND_MSG_PUB.Count_And_Get

898: ( G_PKG_NAME,
899: l_api_name
900: );
901: END IF;
902: FND_MSG_PUB.Count_And_Get
903: ( p_count => x_msg_count,
904: p_data => x_msg_data
905: );
906: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 926: FND_MSG_PUB.initialize;

922: begin
923: -- Initialize API message list if necessary.
924: -- Initialize message list if p_init_msg_list is set to TRUE.
925: IF FND_API.to_Boolean( p_init_msg_list ) THEN
926: FND_MSG_PUB.initialize;
927: END IF;
928:
929: delete from bsc_user_kpi_access
930: where responsibility_id=p_resp_id

Line 941: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get

937: -- Make a standard call to get message count
938: -- and if count is 1, get message info.
939: -- The client will directly display the x_msg_data (which is already
940: -- translated) if the x_msg_count = 1;
941: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
942: -- Server-side procedure to access the messages, and consolidate them
943: -- and display them all at once or display one message after another.
944:
945: FND_MSG_PUB.Count_And_Get

Line 945: FND_MSG_PUB.Count_And_Get

941: -- Else, i.e. if x_msg_count > 1, client will call the FND_MSG_PUB.Get
942: -- Server-side procedure to access the messages, and consolidate them
943: -- and display them all at once or display one message after another.
944:
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data
948: );
949:

Line 955: IF FND_MSG_PUB.Check_Msg_Level

951: when no_data_found then
952: return;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level
956: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
957: THEN
958: FND_MSG_PUB.Add_Exc_Msg
959: ( G_PKG_NAME,

Line 956: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

952: return;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level
956: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
957: THEN
958: FND_MSG_PUB.Add_Exc_Msg
959: ( G_PKG_NAME,
960: l_api_name

Line 958: FND_MSG_PUB.Add_Exc_Msg

954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level
956: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
957: THEN
958: FND_MSG_PUB.Add_Exc_Msg
959: ( G_PKG_NAME,
960: l_api_name
961: );
962: END IF;

Line 963: FND_MSG_PUB.Count_And_Get

959: ( G_PKG_NAME,
960: l_api_name
961: );
962: END IF;
963: FND_MSG_PUB.Count_And_Get
964: ( p_count => x_msg_count,
965: p_data => x_msg_data
966: );
967: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;