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.
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
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
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
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
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
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;
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
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:
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
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
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
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
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
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
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
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;
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;