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
89: mdebug(' ADD_OFO_GROUP_MEMBER: Tracing....' );
90: -- Standard Start of API savepoint
91: -- Initialize API message list if necessary.
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Bug 9697013
117: OUT p_msg_data;
118: END IF;
119: -- Bug 9697013
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: mdebug(' ADD_OFO_GROUP_MEMBER: Tracing....' || x_return_status);
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
127: );
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: mdebug('. Add_OFO_Group_Member : Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: IF FND_MSG_PUB.Check_Msg_Level
139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: FND_MSG_PUB.Add_Exc_Msg