eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MSITE_RESP_MGR_PVT dependencies on FND_API

Line 40: -- x_is_any_duplicate_status will be FND_API.G_RET_STS_SUCCESS, if there is

36: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMRMB.pls';
37:
38: --
39: -- Associate (p_responsibility_ids, p_application_ids) with p_msite_id.
40: -- x_is_any_duplicate_status will be FND_API.G_RET_STS_SUCCESS, if there is
41: -- no duplicate and will be FND_API.G_RET_STS_ERROR when there is at least 1
42: -- duplicate association attempted
43: --
44: PROCEDURE Associate_Resps_To_MSite

Line 41: -- no duplicate and will be FND_API.G_RET_STS_ERROR when there is at least 1

37:
38: --
39: -- Associate (p_responsibility_ids, p_application_ids) with p_msite_id.
40: -- x_is_any_duplicate_status will be FND_API.G_RET_STS_SUCCESS, if there is
41: -- no duplicate and will be FND_API.G_RET_STS_ERROR when there is at least 1
42: -- duplicate association attempted
43: --
44: PROCEDURE Associate_Resps_To_MSite
45: (

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

43: --
44: PROCEDURE Associate_Resps_To_MSite
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_msite_id IN NUMBER,
51: p_responsibility_ids IN JTF_NUMBER_TABLE,

Line 48: p_commit IN VARCHAR2 := FND_API.G_FALSE,

44: PROCEDURE Associate_Resps_To_MSite
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_msite_id IN NUMBER,
51: p_responsibility_ids IN JTF_NUMBER_TABLE,
52: p_application_ids IN JTF_NUMBER_TABLE,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_msite_id IN NUMBER,
51: p_responsibility_ids IN JTF_NUMBER_TABLE,
52: p_application_ids IN JTF_NUMBER_TABLE,
53: p_start_date_actives IN JTF_DATE_TABLE,

Line 83: IF NOT FND_API.Compatible_API_Call(l_api_version,

79: -- Standard Start of API savepoint
80: SAVEPOINT Associate_Resps_To_Msite_Pvt;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version,
84: p_api_version,
85: l_api_name,
86: G_PKG_NAME)
87: THEN

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: p_api_version,
85: l_api_name,
86: G_PKG_NAME)
87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 92: IF FND_API.to_Boolean(p_init_msg_list) THEN

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean(p_init_msg_list) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: -- Check if the association already exists. Populate the
100: -- x_duplicate_association_status with the appropriate information
101: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();

Line 103: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;

99: -- Check if the association already exists. Populate the
100: -- x_duplicate_association_status with the appropriate information
101: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();
102: x_msite_resp_ids := JTF_NUMBER_TABLE();
103: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;
104:
105: FOR i IN 1..p_responsibility_ids.COUNT LOOP
106:
107: x_duplicate_association_status.EXTEND();

Line 115: x_duplicate_association_status(i) := FND_API.G_RET_STS_ERROR;

111: FETCH c1 INTO l_tmp_id;
112: IF(c1%FOUND) THEN
113: CLOSE c1;
114: -- duplicate exists
115: x_duplicate_association_status(i) := FND_API.G_RET_STS_ERROR;
116: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;
117: x_msite_resp_ids(i) := l_tmp_id;
118: ELSE
119: CLOSE c1;

Line 116: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;

112: IF(c1%FOUND) THEN
113: CLOSE c1;
114: -- duplicate exists
115: x_duplicate_association_status(i) := FND_API.G_RET_STS_ERROR;
116: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;
117: x_msite_resp_ids(i) := l_tmp_id;
118: ELSE
119: CLOSE c1;
120: -- no duplicate exists, create new entry

Line 121: x_duplicate_association_status(i) := FND_API.G_RET_STS_SUCCESS;

117: x_msite_resp_ids(i) := l_tmp_id;
118: ELSE
119: CLOSE c1;
120: -- no duplicate exists, create new entry
121: x_duplicate_association_status(i) := FND_API.G_RET_STS_SUCCESS;
122:
123: Ibe_Msite_Resp_Pvt.Create_Msite_Resp
124: (
125: p_api_version => p_api_version,

Line 126: p_init_msg_list => FND_API.G_FALSE,

122:
123: Ibe_Msite_Resp_Pvt.Create_Msite_Resp
124: (
125: p_api_version => p_api_version,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_validation_level => p_validation_level,
129: p_msite_resp_id => FND_API.G_MISS_NUM,
130: p_msite_id => p_msite_id,

Line 127: p_commit => FND_API.G_FALSE,

123: Ibe_Msite_Resp_Pvt.Create_Msite_Resp
124: (
125: p_api_version => p_api_version,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_validation_level => p_validation_level,
129: p_msite_resp_id => FND_API.G_MISS_NUM,
130: p_msite_id => p_msite_id,
131: p_responsibility_id => p_responsibility_ids(i),

Line 129: p_msite_resp_id => FND_API.G_MISS_NUM,

125: p_api_version => p_api_version,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_validation_level => p_validation_level,
129: p_msite_resp_id => FND_API.G_MISS_NUM,
130: p_msite_id => p_msite_id,
131: p_responsibility_id => p_responsibility_ids(i),
132: p_application_id => p_application_ids(i),
133: p_start_date_active => p_start_date_actives(i),

Line 143: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data
141: );
142:
143: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
144: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142:
143: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
144: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
148: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
149: FND_MSG_PUB.Add;
150: RAISE FND_API.G_EXC_ERROR;

Line 147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

143: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
144: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
148: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
149: FND_MSG_PUB.Add;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
148: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
149: FND_MSG_PUB.Add;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: END IF;
154:

Line 161: IF (FND_API.To_Boolean(p_commit)) THEN

157: --
158: -- End of main API body.
159:
160: -- Standard check of p_commit.
161: IF (FND_API.To_Boolean(p_commit)) THEN
162: COMMIT WORK;
163: END IF;
164:
165: -- Standard call to get message count and if count is 1, get message info.

Line 172: WHEN FND_API.G_EXC_ERROR THEN

168: p_encoded => 'F');
169:
170: EXCEPTION
171:
172: WHEN FND_API.G_EXC_ERROR THEN
173: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
176: p_data => x_msg_data,

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

170: EXCEPTION
171:
172: WHEN FND_API.G_EXC_ERROR THEN
173: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => 'F');
178:

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => 'F');
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
183: p_data => x_msg_data,

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: p_encoded => 'F');
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
183: p_data => x_msg_data,
184: p_encoded => 'F');
185:

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
190: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
191: FND_MESSAGE.Set_Token('REASON', SQLERRM);
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

208: --
209: PROCEDURE Update_Delete_Msite_Resps
210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 213: p_commit IN VARCHAR2 := FND_API.G_FALSE,

209: PROCEDURE Update_Delete_Msite_Resps
210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,
217: p_start_date_actives IN JTF_DATE_TABLE,

Line 214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_msite_resp_ids IN JTF_NUMBER_TABLE,
216: p_object_version_numbers IN JTF_NUMBER_TABLE,
217: p_start_date_actives IN JTF_DATE_TABLE,
218: p_end_date_actives IN JTF_DATE_TABLE,

Line 236: IF NOT FND_API.Compatible_API_Call(l_api_version,

232: -- Standard Start of API savepoint
233: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
234:
235: -- Standard call to check for call compatibility.
236: IF NOT FND_API.Compatible_API_Call(l_api_version,
237: p_api_version,
238: l_api_name,
239: G_PKG_NAME)
240: THEN

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: p_api_version,
238: l_api_name,
239: G_PKG_NAME)
240: THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 245: IF FND_API.to_Boolean(p_init_msg_list) THEN

241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean(p_init_msg_list) THEN
246: FND_MSG_PUB.initialize;
247: END IF;
248:
249: -- Initialize API return status to success

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: FND_MSG_PUB.initialize;
247: END IF;
248:
249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: -- API body
253: -- CALL FLOW :
254: -- 1.

Line 263: p_init_msg_list => FND_API.G_FALSE,

259:
260: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp
261: (
262: p_api_version => p_api_version,
263: p_init_msg_list => FND_API.G_FALSE,
264: p_commit => FND_API.G_FALSE,
265: p_validation_level => p_validation_level,
266: p_msite_resp_id => p_msite_resp_ids(i),
267: p_msite_id => FND_API.G_MISS_NUM,

Line 264: p_commit => FND_API.G_FALSE,

260: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp
261: (
262: p_api_version => p_api_version,
263: p_init_msg_list => FND_API.G_FALSE,
264: p_commit => FND_API.G_FALSE,
265: p_validation_level => p_validation_level,
266: p_msite_resp_id => p_msite_resp_ids(i),
267: p_msite_id => FND_API.G_MISS_NUM,
268: p_responsibility_id => FND_API.G_MISS_NUM,

Line 267: p_msite_id => FND_API.G_MISS_NUM,

263: p_init_msg_list => FND_API.G_FALSE,
264: p_commit => FND_API.G_FALSE,
265: p_validation_level => p_validation_level,
266: p_msite_resp_id => p_msite_resp_ids(i),
267: p_msite_id => FND_API.G_MISS_NUM,
268: p_responsibility_id => FND_API.G_MISS_NUM,
269: p_application_id => FND_API.G_MISS_NUM,
270: x_return_status => x_return_status,
271: x_msg_count => x_msg_count,

Line 268: p_responsibility_id => FND_API.G_MISS_NUM,

264: p_commit => FND_API.G_FALSE,
265: p_validation_level => p_validation_level,
266: p_msite_resp_id => p_msite_resp_ids(i),
267: p_msite_id => FND_API.G_MISS_NUM,
268: p_responsibility_id => FND_API.G_MISS_NUM,
269: p_application_id => FND_API.G_MISS_NUM,
270: x_return_status => x_return_status,
271: x_msg_count => x_msg_count,
272: x_msg_data => x_msg_data

Line 269: p_application_id => FND_API.G_MISS_NUM,

265: p_validation_level => p_validation_level,
266: p_msite_resp_id => p_msite_resp_ids(i),
267: p_msite_id => FND_API.G_MISS_NUM,
268: p_responsibility_id => FND_API.G_MISS_NUM,
269: p_application_id => FND_API.G_MISS_NUM,
270: x_return_status => x_return_status,
271: x_msg_count => x_msg_count,
272: x_msg_data => x_msg_data
273: );

Line 275: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

271: x_msg_count => x_msg_count,
272: x_msg_data => x_msg_data
273: );
274:
275: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
276: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 278: RAISE FND_API.G_EXC_ERROR;

274:
275: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
276: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
281: FND_MSG_PUB.Add;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

275: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
276: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
281: FND_MSG_PUB.Add;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
281: FND_MSG_PUB.Add;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: ELSE
286:

Line 290: p_init_msg_list => FND_API.G_FALSE,

286:
287: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
288: (
289: p_api_version => p_api_version,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_commit => FND_API.G_FALSE,
292: p_validation_level => p_validation_level,
293: p_msite_resp_id => p_msite_resp_ids(i),
294: p_object_version_number => p_object_version_numbers(i),

Line 291: p_commit => FND_API.G_FALSE,

287: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
288: (
289: p_api_version => p_api_version,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_commit => FND_API.G_FALSE,
292: p_validation_level => p_validation_level,
293: p_msite_resp_id => p_msite_resp_ids(i),
294: p_object_version_number => p_object_version_numbers(i),
295: p_msite_id => FND_API.G_MISS_NUM,

Line 295: p_msite_id => FND_API.G_MISS_NUM,

291: p_commit => FND_API.G_FALSE,
292: p_validation_level => p_validation_level,
293: p_msite_resp_id => p_msite_resp_ids(i),
294: p_object_version_number => p_object_version_numbers(i),
295: p_msite_id => FND_API.G_MISS_NUM,
296: p_responsibility_id => FND_API.G_MISS_NUM,
297: p_application_id => FND_API.G_MISS_NUM,
298: p_start_date_active => p_start_date_actives(i),
299: p_end_date_active => p_end_date_actives(i),

Line 296: p_responsibility_id => FND_API.G_MISS_NUM,

292: p_validation_level => p_validation_level,
293: p_msite_resp_id => p_msite_resp_ids(i),
294: p_object_version_number => p_object_version_numbers(i),
295: p_msite_id => FND_API.G_MISS_NUM,
296: p_responsibility_id => FND_API.G_MISS_NUM,
297: p_application_id => FND_API.G_MISS_NUM,
298: p_start_date_active => p_start_date_actives(i),
299: p_end_date_active => p_end_date_actives(i),
300: p_sort_order => p_sort_orders(i),

Line 297: p_application_id => FND_API.G_MISS_NUM,

293: p_msite_resp_id => p_msite_resp_ids(i),
294: p_object_version_number => p_object_version_numbers(i),
295: p_msite_id => FND_API.G_MISS_NUM,
296: p_responsibility_id => FND_API.G_MISS_NUM,
297: p_application_id => FND_API.G_MISS_NUM,
298: p_start_date_active => p_start_date_actives(i),
299: p_end_date_active => p_end_date_actives(i),
300: p_sort_order => p_sort_orders(i),
301: p_display_name => p_display_names(i),

Line 302: p_group_code => FND_API.G_MISS_CHAR,

298: p_start_date_active => p_start_date_actives(i),
299: p_end_date_active => p_end_date_actives(i),
300: p_sort_order => p_sort_orders(i),
301: p_display_name => p_display_names(i),
302: p_group_code => FND_API.G_MISS_CHAR,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data
306: );

Line 308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data
306: );
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 311: RAISE FND_API.G_EXC_ERROR;

307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
314: FND_MSG_PUB.Add;
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
314: FND_MSG_PUB.Add;
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
314: FND_MSG_PUB.Add;
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: END IF;
319:

Line 326: IF (FND_API.To_Boolean(p_commit)) THEN

322: --
323: -- End of main API body.
324:
325: -- Standard check of p_commit.
326: IF (FND_API.To_Boolean(p_commit)) THEN
327: COMMIT WORK;
328: END IF;
329:
330: -- Standard call to get message count and if count is 1, get message info.

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: p_encoded => 'F');
334:
335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
341: p_data => x_msg_data,

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
341: p_data => x_msg_data,
342: p_encoded => 'F');
343:

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
341: p_data => x_msg_data,
342: p_encoded => 'F');
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
348: p_data => x_msg_data,

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: p_encoded => 'F');
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
348: p_data => x_msg_data,
349: p_encoded => 'F');
350:

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: p_encoded => 'F');
350:
351: WHEN OTHERS THEN
352: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
356: THEN
357: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

368: --
369: PROCEDURE Update_Delete_Msite_Resps
370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,

Line 373: p_commit IN VARCHAR2 := FND_API.G_FALSE,

369: PROCEDURE Update_Delete_Msite_Resps
370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,

Line 374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_msite_resp_ids IN JTF_NUMBER_TABLE,
376: p_msite_ids IN JTF_NUMBER_TABLE,
377: p_responsibility_ids IN JTF_NUMBER_TABLE,
378: p_application_ids IN JTF_NUMBER_TABLE,

Line 410: IF NOT FND_API.Compatible_API_Call(l_api_version,

406: -- Standard Start of API savepoint
407: SAVEPOINT Update_Delete_Msite_Resps_Pvt;
408:
409: -- Standard call to check for call compatibility.
410: IF NOT FND_API.Compatible_API_Call(l_api_version,
411: p_api_version,
412: l_api_name,
413: G_PKG_NAME)
414: THEN

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: p_api_version,
412: l_api_name,
413: G_PKG_NAME)
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 419: IF FND_API.to_Boolean(p_init_msg_list) THEN

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean(p_init_msg_list) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426: -- API body
427: -- CALL FLOW :
428: -- 1.

Line 438: p_init_msg_list => FND_API.G_FALSE,

434:
435: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp
436: (
437: p_api_version => p_api_version,
438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: p_validation_level => p_validation_level,
441: p_msite_resp_id => p_msite_resp_ids(i),
442: p_msite_id => FND_API.G_MISS_NUM,

Line 439: p_commit => FND_API.G_FALSE,

435: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp
436: (
437: p_api_version => p_api_version,
438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: p_validation_level => p_validation_level,
441: p_msite_resp_id => p_msite_resp_ids(i),
442: p_msite_id => FND_API.G_MISS_NUM,
443: p_responsibility_id => FND_API.G_MISS_NUM,

Line 442: p_msite_id => FND_API.G_MISS_NUM,

438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: p_validation_level => p_validation_level,
441: p_msite_resp_id => p_msite_resp_ids(i),
442: p_msite_id => FND_API.G_MISS_NUM,
443: p_responsibility_id => FND_API.G_MISS_NUM,
444: p_application_id => FND_API.G_MISS_NUM,
445: x_return_status => x_return_status,
446: x_msg_count => x_msg_count,

Line 443: p_responsibility_id => FND_API.G_MISS_NUM,

439: p_commit => FND_API.G_FALSE,
440: p_validation_level => p_validation_level,
441: p_msite_resp_id => p_msite_resp_ids(i),
442: p_msite_id => FND_API.G_MISS_NUM,
443: p_responsibility_id => FND_API.G_MISS_NUM,
444: p_application_id => FND_API.G_MISS_NUM,
445: x_return_status => x_return_status,
446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data

Line 444: p_application_id => FND_API.G_MISS_NUM,

440: p_validation_level => p_validation_level,
441: p_msite_resp_id => p_msite_resp_ids(i),
442: p_msite_id => FND_API.G_MISS_NUM,
443: p_responsibility_id => FND_API.G_MISS_NUM,
444: p_application_id => FND_API.G_MISS_NUM,
445: x_return_status => x_return_status,
446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data
448: );

Line 450: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data
448: );
449:
450: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
451: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 453: RAISE FND_API.G_EXC_ERROR;

449:
450: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
451: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
455: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
456: FND_MSG_PUB.Add;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

450: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
451: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
455: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
456: FND_MSG_PUB.Add;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
455: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
456: FND_MSG_PUB.Add;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: ELSIF (p_delete_flags(i) = 'IG') THEN
461:

Line 471: p_init_msg_list => FND_API.G_FALSE,

467:
468: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
469: (
470: p_api_version => p_api_version,
471: p_init_msg_list => FND_API.G_FALSE,
472: p_commit => FND_API.G_FALSE,
473: p_validation_level => p_validation_level,
474: p_msite_resp_id => p_msite_resp_ids(i),
475: p_object_version_number => p_object_version_numbers(i),

Line 472: p_commit => FND_API.G_FALSE,

468: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
469: (
470: p_api_version => p_api_version,
471: p_init_msg_list => FND_API.G_FALSE,
472: p_commit => FND_API.G_FALSE,
473: p_validation_level => p_validation_level,
474: p_msite_resp_id => p_msite_resp_ids(i),
475: p_object_version_number => p_object_version_numbers(i),
476: p_msite_id => FND_API.G_MISS_NUM,

Line 476: p_msite_id => FND_API.G_MISS_NUM,

472: p_commit => FND_API.G_FALSE,
473: p_validation_level => p_validation_level,
474: p_msite_resp_id => p_msite_resp_ids(i),
475: p_object_version_number => p_object_version_numbers(i),
476: p_msite_id => FND_API.G_MISS_NUM,
477: p_responsibility_id => FND_API.G_MISS_NUM,
478: p_application_id => FND_API.G_MISS_NUM,
479: p_start_date_active => p_start_date_actives(i),
480: p_end_date_active => p_end_date_actives(i),

Line 477: p_responsibility_id => FND_API.G_MISS_NUM,

473: p_validation_level => p_validation_level,
474: p_msite_resp_id => p_msite_resp_ids(i),
475: p_object_version_number => p_object_version_numbers(i),
476: p_msite_id => FND_API.G_MISS_NUM,
477: p_responsibility_id => FND_API.G_MISS_NUM,
478: p_application_id => FND_API.G_MISS_NUM,
479: p_start_date_active => p_start_date_actives(i),
480: p_end_date_active => p_end_date_actives(i),
481: p_sort_order => p_sort_orders(i),

Line 478: p_application_id => FND_API.G_MISS_NUM,

474: p_msite_resp_id => p_msite_resp_ids(i),
475: p_object_version_number => p_object_version_numbers(i),
476: p_msite_id => FND_API.G_MISS_NUM,
477: p_responsibility_id => FND_API.G_MISS_NUM,
478: p_application_id => FND_API.G_MISS_NUM,
479: p_start_date_active => p_start_date_actives(i),
480: p_end_date_active => p_end_date_actives(i),
481: p_sort_order => p_sort_orders(i),
482: p_display_name => p_display_names(i),

Line 489: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data
487: );
488:
489: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
490: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 492: RAISE FND_API.G_EXC_ERROR;

488:
489: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
490: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

489: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
490: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: ELSE
500:

Line 504: p_init_msg_list => FND_API.G_FALSE,

500:
501: Ibe_Msite_Resp_Pvt.Create_Msite_Resp
502: (
503: p_api_version => p_api_version,
504: p_init_msg_list => FND_API.G_FALSE,
505: p_commit => FND_API.G_FALSE,
506: p_validation_level => p_validation_level,
507: p_msite_resp_id => p_msite_resp_ids(i),
508: p_msite_id => p_msite_ids(i),

Line 505: p_commit => FND_API.G_FALSE,

501: Ibe_Msite_Resp_Pvt.Create_Msite_Resp
502: (
503: p_api_version => p_api_version,
504: p_init_msg_list => FND_API.G_FALSE,
505: p_commit => FND_API.G_FALSE,
506: p_validation_level => p_validation_level,
507: p_msite_resp_id => p_msite_resp_ids(i),
508: p_msite_id => p_msite_ids(i),
509: p_responsibility_id => p_responsibility_ids(i),

Line 522: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

518: x_msg_count => x_msg_count,
519: x_msg_data => x_msg_data
520: );
521:
522: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521:
522: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
528: FND_MSG_PUB.Add;
529: RAISE FND_API.G_EXC_ERROR;

Line 526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

522: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
528: FND_MSG_PUB.Add;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;

Line 529: RAISE FND_API.G_EXC_ERROR;

525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
528: FND_MSG_PUB.Add;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
532: END IF;
533:

Line 539: p_init_msg_list => FND_API.G_FALSE,

535:
536: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp_Group
537: (
538: p_api_version => p_api_version,
539: p_init_msg_list => FND_API.G_FALSE,
540: p_commit => FND_API.G_FALSE,
541: p_validation_level => p_validation_level,
542: p_msite_resp_id => p_msite_resp_ids(i),
543: p_msite_id => FND_API.G_MISS_NUM,

Line 540: p_commit => FND_API.G_FALSE,

536: Ibe_Msite_Resp_Pvt.Delete_Msite_Resp_Group
537: (
538: p_api_version => p_api_version,
539: p_init_msg_list => FND_API.G_FALSE,
540: p_commit => FND_API.G_FALSE,
541: p_validation_level => p_validation_level,
542: p_msite_resp_id => p_msite_resp_ids(i),
543: p_msite_id => FND_API.G_MISS_NUM,
544: p_responsibility_id => FND_API.G_MISS_NUM,

Line 543: p_msite_id => FND_API.G_MISS_NUM,

539: p_init_msg_list => FND_API.G_FALSE,
540: p_commit => FND_API.G_FALSE,
541: p_validation_level => p_validation_level,
542: p_msite_resp_id => p_msite_resp_ids(i),
543: p_msite_id => FND_API.G_MISS_NUM,
544: p_responsibility_id => FND_API.G_MISS_NUM,
545: p_application_id => FND_API.G_MISS_NUM,
546: p_group_code => p_group_codes(i),
547: x_return_status => x_return_status,

Line 544: p_responsibility_id => FND_API.G_MISS_NUM,

540: p_commit => FND_API.G_FALSE,
541: p_validation_level => p_validation_level,
542: p_msite_resp_id => p_msite_resp_ids(i),
543: p_msite_id => FND_API.G_MISS_NUM,
544: p_responsibility_id => FND_API.G_MISS_NUM,
545: p_application_id => FND_API.G_MISS_NUM,
546: p_group_code => p_group_codes(i),
547: x_return_status => x_return_status,
548: x_msg_count => x_msg_count,

Line 545: p_application_id => FND_API.G_MISS_NUM,

541: p_validation_level => p_validation_level,
542: p_msite_resp_id => p_msite_resp_ids(i),
543: p_msite_id => FND_API.G_MISS_NUM,
544: p_responsibility_id => FND_API.G_MISS_NUM,
545: p_application_id => FND_API.G_MISS_NUM,
546: p_group_code => p_group_codes(i),
547: x_return_status => x_return_status,
548: x_msg_count => x_msg_count,
549: x_msg_data => x_msg_data

Line 552: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

548: x_msg_count => x_msg_count,
549: x_msg_data => x_msg_data
550: );
551:
552: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
553: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 555: RAISE FND_API.G_EXC_ERROR;

551:
552: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
553: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
557: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

552: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
553: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
557: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
557: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
562: ELSIF (p_delete_flags(i) = 'N') THEN
563: NULL;

Line 571: IF (FND_API.To_Boolean(p_commit)) THEN

567: --
568: -- End of main API body.
569:
570: -- Standard check of p_commit.
571: IF (FND_API.To_Boolean(p_commit)) THEN
572: COMMIT WORK;
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.

Line 582: WHEN FND_API.G_EXC_ERROR THEN

578: p_encoded => 'F');
579:
580: EXCEPTION
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data,

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

580: EXCEPTION
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => 'F');
588:

Line 589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => 'F');
588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
593: p_data => x_msg_data,

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

587: p_encoded => 'F');
588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
593: p_data => x_msg_data,
594: p_encoded => 'F');
595:

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

594: p_encoded => 'F');
595:
596: WHEN OTHERS THEN
597: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599:
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 615: -- -1, NULL, or FND_API.G_MISS_NUM, then load for all applications

611:
612: --
613: -- Return data (association + minisite data + responsibility data) belonging to
614: -- the p_msite_id and to a particular p_application_id. If p_application_id is
615: -- -1, NULL, or FND_API.G_MISS_NUM, then load for all applications
616: --
617: PROCEDURE Load_MsiteResps_For_Msite
618: (
619: p_api_version IN NUMBER,

Line 620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

616: --
617: PROCEDURE Load_MsiteResps_For_Msite
618: (
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: p_msite_id IN NUMBER,
624: p_application_id IN NUMBER,

Line 621: p_commit IN VARCHAR2 := FND_API.G_FALSE,

617: PROCEDURE Load_MsiteResps_For_Msite
618: (
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: p_msite_id IN NUMBER,
624: p_application_id IN NUMBER,
625: x_msite_csr OUT NOCOPY MSITE_CSR,

Line 622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

618: (
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: p_msite_id IN NUMBER,
624: p_application_id IN NUMBER,
625: x_msite_csr OUT NOCOPY MSITE_CSR,
626: x_msite_resp_csr OUT NOCOPY MSITE_RESP_CSR,

Line 638: IF FND_API.to_Boolean(p_init_msg_list) THEN

634: l_api_version CONSTANT NUMBER := 1.0;
635: BEGIN
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean(p_init_msg_list) THEN
639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- Initialize API return status to success

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- Initialize API return status to success
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: -- Get the mini-site data
646: OPEN x_msite_csr FOR SELECT msite_name, msite_description
647: FROM ibe_msites_vl

Line 653: p_application_id = fnd_api.g_miss_num)

649:
650: -- Get the msite-resp data and resp data
651: IF (p_application_id = -1 OR
652: p_application_id IS NULL OR
653: p_application_id = fnd_api.g_miss_num)
654: THEN
655:
656: OPEN x_msite_resp_csr FOR SELECT MR.msite_resp_id,
657: MR.object_version_number, R.responsibility_id, R.application_id,

Line 685: WHEN FND_API.G_EXC_ERROR THEN

681: END IF;
682:
683: EXCEPTION
684:
685: WHEN FND_API.G_EXC_ERROR THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
688: p_data => x_msg_data,
689: p_encoded => 'F');

Line 686: x_return_status := FND_API.G_RET_STS_ERROR;

682:
683: EXCEPTION
684:
685: WHEN FND_API.G_EXC_ERROR THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
688: p_data => x_msg_data,
689: p_encoded => 'F');
690:

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
688: p_data => x_msg_data,
689: p_encoded => 'F');
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
694: p_data => x_msg_data,
695: p_encoded => 'F');

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

688: p_data => x_msg_data,
689: p_encoded => 'F');
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
694: p_data => x_msg_data,
695: p_encoded => 'F');
696:

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: p_data => x_msg_data,
695: p_encoded => 'F');
696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

714: --
715: PROCEDURE Update_Msite_Resps
716: (
717: p_api_version IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 719: p_commit IN VARCHAR2 := FND_API.G_FALSE,

715: PROCEDURE Update_Msite_Resps
716: (
717: p_api_version IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,
723: p_sort_orders IN JTF_NUMBER_TABLE,

Line 720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

716: (
717: p_api_version IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: p_msite_resp_ids IN JTF_NUMBER_TABLE,
722: p_object_version_numbers IN JTF_NUMBER_TABLE,
723: p_sort_orders IN JTF_NUMBER_TABLE,
724: x_return_status OUT NOCOPY VARCHAR2,

Line 739: IF NOT FND_API.Compatible_API_Call(l_api_version,

735: -- Standard Start of API savepoint
736: SAVEPOINT Update_Msite_Resps_Pvt;
737:
738: -- Standard call to check for call compatibility.
739: IF NOT FND_API.Compatible_API_Call(l_api_version,
740: p_api_version,
741: l_api_name,
742: G_PKG_NAME)
743: THEN

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: p_api_version,
741: l_api_name,
742: G_PKG_NAME)
743: THEN
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 748: IF FND_API.to_Boolean(p_init_msg_list) THEN

744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean(p_init_msg_list) THEN
749: FND_MSG_PUB.initialize;
750: END IF;
751:
752: -- Initialize API return status to success

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749: FND_MSG_PUB.initialize;
750: END IF;
751:
752: -- Initialize API return status to success
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754:
755: -- API body
756: -- CALL FLOW :
757: -- 1.

Line 765: p_init_msg_list => FND_API.G_FALSE,

761:
762: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
763: (
764: p_api_version => p_api_version,
765: p_init_msg_list => FND_API.G_FALSE,
766: p_commit => FND_API.G_FALSE,
767: p_validation_level => p_validation_level,
768: p_msite_resp_id => p_msite_resp_ids(i),
769: p_object_version_number => p_object_version_numbers(i),

Line 766: p_commit => FND_API.G_FALSE,

762: Ibe_Msite_Resp_Pvt.Update_Msite_Resp
763: (
764: p_api_version => p_api_version,
765: p_init_msg_list => FND_API.G_FALSE,
766: p_commit => FND_API.G_FALSE,
767: p_validation_level => p_validation_level,
768: p_msite_resp_id => p_msite_resp_ids(i),
769: p_object_version_number => p_object_version_numbers(i),
770: p_msite_id => FND_API.G_MISS_NUM,

Line 770: p_msite_id => FND_API.G_MISS_NUM,

766: p_commit => FND_API.G_FALSE,
767: p_validation_level => p_validation_level,
768: p_msite_resp_id => p_msite_resp_ids(i),
769: p_object_version_number => p_object_version_numbers(i),
770: p_msite_id => FND_API.G_MISS_NUM,
771: p_responsibility_id => FND_API.G_MISS_NUM,
772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,

Line 771: p_responsibility_id => FND_API.G_MISS_NUM,

767: p_validation_level => p_validation_level,
768: p_msite_resp_id => p_msite_resp_ids(i),
769: p_object_version_number => p_object_version_numbers(i),
770: p_msite_id => FND_API.G_MISS_NUM,
771: p_responsibility_id => FND_API.G_MISS_NUM,
772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),

Line 772: p_application_id => FND_API.G_MISS_NUM,

768: p_msite_resp_id => p_msite_resp_ids(i),
769: p_object_version_number => p_object_version_numbers(i),
770: p_msite_id => FND_API.G_MISS_NUM,
771: p_responsibility_id => FND_API.G_MISS_NUM,
772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),
776: p_display_name => FND_API.G_MISS_CHAR,

Line 773: p_start_date_active => FND_API.G_MISS_DATE,

769: p_object_version_number => p_object_version_numbers(i),
770: p_msite_id => FND_API.G_MISS_NUM,
771: p_responsibility_id => FND_API.G_MISS_NUM,
772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),
776: p_display_name => FND_API.G_MISS_CHAR,
777: p_group_code => FND_API.G_MISS_CHAR,

Line 774: p_end_date_active => FND_API.G_MISS_DATE,

770: p_msite_id => FND_API.G_MISS_NUM,
771: p_responsibility_id => FND_API.G_MISS_NUM,
772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),
776: p_display_name => FND_API.G_MISS_CHAR,
777: p_group_code => FND_API.G_MISS_CHAR,
778: x_return_status => x_return_status,

Line 776: p_display_name => FND_API.G_MISS_CHAR,

772: p_application_id => FND_API.G_MISS_NUM,
773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),
776: p_display_name => FND_API.G_MISS_CHAR,
777: p_group_code => FND_API.G_MISS_CHAR,
778: x_return_status => x_return_status,
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data

Line 777: p_group_code => FND_API.G_MISS_CHAR,

773: p_start_date_active => FND_API.G_MISS_DATE,
774: p_end_date_active => FND_API.G_MISS_DATE,
775: p_sort_order => p_sort_orders(i),
776: p_display_name => FND_API.G_MISS_CHAR,
777: p_group_code => FND_API.G_MISS_CHAR,
778: x_return_status => x_return_status,
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data
781: );

Line 784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

780: x_msg_data => x_msg_data
781: );
782:
783:
784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
785: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 787: RAISE FND_API.G_EXC_ERROR;

783:
784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
785: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
789: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
785: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
789: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;

Line 791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
789: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;
793:
794:
795: END LOOP; -- end for i

Line 801: IF (FND_API.To_Boolean(p_commit)) THEN

797: --
798: -- End of main API body.
799:
800: -- Standard check of p_commit.
801: IF (FND_API.To_Boolean(p_commit)) THEN
802: COMMIT WORK;
803: END IF;
804:
805: -- Standard call to get message count and if count is 1, get message info.

Line 812: WHEN FND_API.G_EXC_ERROR THEN

808: p_encoded => 'F');
809:
810: EXCEPTION
811:
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: EXCEPTION
811:
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:

Line 819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
823: p_data => x_msg_data,

Line 821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

817: p_encoded => 'F');
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => 'F');
825:

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: p_encoded => 'F');
825:
826: WHEN OTHERS THEN
827: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829:
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);