APPS.CSF_REMOTE_VIEWS_PUB dependencies on FND_MSG_PUB

Line 38: FND_MSG_PUB.initialize;

34: IF FND_API.to_Boolean
35: ( p_init_msg_list
36: )
37: THEN
38: FND_MSG_PUB.initialize;
39: END IF;
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: -- All statements wich do not begin with 'select' are to be rejected.

Line 68: FND_MSG_PUB.Count_And_Get

64: ( t_cursor_name
65: );
66: x_query_correct := FND_API.G_TRUE;
67: -- Standard call to get message count and if count is 1, get message info.
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count
70: , p_data => x_msg_data
71: );
72: EXCEPTION

Line 76: FND_MSG_PUB.Count_And_Get

72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR
74: THEN
75: x_return_status := FND_API.G_RET_STS_ERROR ;
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count
78: , p_data => x_msg_data
79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 83: FND_MSG_PUB.Count_And_Get

79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
81: THEN
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84: ( p_count => x_msg_count
85: , p_data => x_msg_data
86: );
87: WHEN OTHERS

Line 90: IF FND_MSG_PUB.Check_Msg_Level

86: );
87: WHEN OTHERS
88: THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: IF FND_MSG_PUB.Check_Msg_Level
91: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
92: )
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg

Line 91: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

87: WHEN OTHERS
88: THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: IF FND_MSG_PUB.Check_Msg_Level
91: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
92: )
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME

Line 94: FND_MSG_PUB.Add_Exc_Msg

90: IF FND_MSG_PUB.Check_Msg_Level
91: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
92: )
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg
95: ( G_PKG_NAME
96: , l_api_name
97: );
98: END IF;

Line 99: FND_MSG_PUB.Count_And_Get

95: ( G_PKG_NAME
96: , l_api_name
97: );
98: END IF;
99: FND_MSG_PUB.Count_And_Get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data
102: );
103: if dbms_sql.is_open

Line 336: FND_MSG_PUB.initialize;

332: IF FND_API.to_Boolean
333: ( p_init_msg_list
334: )
335: THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338: -- Initialize API return status to success
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:

Line 387: fnd_msg_pub.add;

383: fnd_message.Set_Name
384: ( 'CSF'
385: , 'CSF_RMT_VWS_PAR_MAPPING'
386: );
387: fnd_msg_pub.add;
388: raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: else
390: c_query := dbms_sql.open_cursor;
391: -- Start a new block to be able to trap exceptions

Line 648: fnd_msg_pub.add;

644: fnd_message.set_name
645: ( 'CSF'
646: , 'CSF_RMT_VWS_PARSE_ERROR'
647: );
648: fnd_msg_pub.add;
649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
650: end;
651: dbms_sql.close_cursor
652: ( c_query

Line 721: FND_MSG_PUB.Count_And_Get

717: COMMIT WORK;
718: END IF;
719: -- Ensure out parameters are correctly set.
720: x_notification_id := t_not_id;
721: FND_MSG_PUB.Count_And_Get
722: ( p_count => x_msg_count
723: , p_data => x_msg_data
724: );
725: EXCEPTION

Line 730: FND_MSG_PUB.Count_And_Get

726: WHEN FND_API.G_EXC_ERROR
727: THEN
728: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count
732: , p_data => x_msg_data
733: );
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 738: FND_MSG_PUB.Count_And_Get

734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
735: THEN
736: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get
739: ( p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742: WHEN OTHERS

Line 746: IF FND_MSG_PUB.Check_Msg_Level

742: WHEN OTHERS
743: THEN
744: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
746: IF FND_MSG_PUB.Check_Msg_Level
747: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
748: )
749: THEN
750: FND_MSG_PUB.Add_Exc_Msg

Line 747: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

743: THEN
744: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
746: IF FND_MSG_PUB.Check_Msg_Level
747: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
748: )
749: THEN
750: FND_MSG_PUB.Add_Exc_Msg
751: ( G_PKG_NAME

Line 750: FND_MSG_PUB.Add_Exc_Msg

746: IF FND_MSG_PUB.Check_Msg_Level
747: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
748: )
749: THEN
750: FND_MSG_PUB.Add_Exc_Msg
751: ( G_PKG_NAME
752: , l_api_name
753: );
754: END IF;

Line 755: FND_MSG_PUB.Count_And_Get

751: ( G_PKG_NAME
752: , l_api_name
753: );
754: END IF;
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count
757: , p_data => x_msg_data
758: );
759: end execute_remote_view;