42: -- Parameters:
43: -- IN : p_api_version IN NUMBER (required)
44: -- API Version of this procedure
45: -- p_init_msg_level IN VARCHAR2 (optional)
46: -- DEFAULT = FND_API.G_FALSE
47: -- Indicates whether the message stack needs to be cleared
48: -- p_commit IN VARCHAR2 (optional)
49: -- DEFAULT = FND_API.G_FALSE
50: -- Indicates whether the data should be committed
45: -- p_init_msg_level IN VARCHAR2 (optional)
46: -- DEFAULT = FND_API.G_FALSE
47: -- Indicates whether the message stack needs to be cleared
48: -- p_commit IN VARCHAR2 (optional)
49: -- DEFAULT = FND_API.G_FALSE
50: -- Indicates whether the data should be committed
51: -- p_group_id IN NUMBER (required)
52: -- Group to which the member is being added
53: -- Eg., A Group
56: -- Eg., PERSON
57: --
58: -- OUT : x_return_status OUT NUMBER
59: -- Result of all the operations
60: -- FND_API.G_RET_STS_SUCCESS if success
61: -- FND_API.G_RET_STS_ERROR if error
62: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
63: -- x_msg_count OUT NUMBER
64: -- number of messages in the message list
57: --
58: -- OUT : x_return_status OUT NUMBER
59: -- Result of all the operations
60: -- FND_API.G_RET_STS_SUCCESS if success
61: -- FND_API.G_RET_STS_ERROR if error
62: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
63: -- x_msg_count OUT NUMBER
64: -- number of messages in the message list
65: -- x_msg_data OUT VARCHAR2
58: -- OUT : x_return_status OUT NUMBER
59: -- Result of all the operations
60: -- FND_API.G_RET_STS_SUCCESS if success
61: -- FND_API.G_RET_STS_ERROR if error
62: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
63: -- x_msg_count OUT NUMBER
64: -- number of messages in the message list
65: -- x_msg_data OUT VARCHAR2
66: -- if number of messages is 1, then this parameter
86: mdebug(' ADD_OFO_GROUP_MEMBER: Tracing....' );
87: -- Standard Start of API savepoint
88: -- Initialize API message list if necessary.
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93:
94: EXECUTE IMMEDIATE 'BEGIN DOM_WS_INTERFACE_PUB.Add_OFO_Group_Member( :1,:2,:3,:4,:5,:6,:7,:8); END; '
101: OUT p_msg_count,
102: OUT p_msg_data;
103:
104:
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: mdebug(' ADD_OFO_GROUP_MEMBER: Tracing....' || x_return_status);
108: FND_MSG_PUB.Count_And_Get
109: ( p_count => x_msg_count,
109: ( p_count => x_msg_count,
110: p_data => x_msg_data
111: );
112: EXCEPTION
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
110: p_data => x_msg_data
111: );
112: EXCEPTION
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
118: p_data => x_msg_data
111: );
112: EXCEPTION
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
118: p_data => x_msg_data
119: );
117: ( p_count => x_msg_count,
118: p_data => x_msg_data
119: );
120: WHEN OTHERS THEN
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: IF FND_MSG_PUB.Check_Msg_Level
123: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
124: THEN
125: FND_MSG_PUB.Add_Exc_Msg