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_PRTY_ACCSS_MGR_PVT dependencies on FND_API

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

24: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVMPMB.pls';
25:
26: --
27: -- Associate (p_party_ids) with p_msite_id.
28: -- x_is_any_duplicate_status will be FND_API.G_RET_STS_SUCCESS, if there is
29: -- no duplicate and will be FND_API.G_RET_STS_ERROR when there is at least 1
30: -- duplicate association attempted
31: --
32: PROCEDURE Associate_Parties_To_MSite

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

25:
26: --
27: -- Associate (p_party_ids) with p_msite_id.
28: -- x_is_any_duplicate_status will be FND_API.G_RET_STS_SUCCESS, if there is
29: -- no duplicate and will be FND_API.G_RET_STS_ERROR when there is at least 1
30: -- duplicate association attempted
31: --
32: PROCEDURE Associate_Parties_To_MSite
33: (

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

31: --
32: PROCEDURE Associate_Parties_To_MSite
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_msite_id IN NUMBER,
39: p_party_ids IN JTF_NUMBER_TABLE,

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

32: PROCEDURE Associate_Parties_To_MSite
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_msite_id IN NUMBER,
39: p_party_ids IN JTF_NUMBER_TABLE,
40: p_start_date_actives IN JTF_DATE_TABLE,

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

33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_msite_id IN NUMBER,
39: p_party_ids IN JTF_NUMBER_TABLE,
40: p_start_date_actives IN JTF_DATE_TABLE,
41: p_end_date_actives IN JTF_DATE_TABLE,

Line 66: IF NOT FND_API.Compatible_API_Call(l_api_version,

62: -- Standard Start of API savepoint
63: SAVEPOINT Associate_Parties_To_Msite_Pvt;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call(l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PKG_NAME)
70: THEN

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: p_api_version,
68: l_api_name,
69: G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 75: IF FND_API.to_Boolean(p_init_msg_list) THEN

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: -- Check if the association already exists. Populate the
83: -- x_duplicate_association_status with the appropriate information
84: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();

Line 86: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;

82: -- Check if the association already exists. Populate the
83: -- x_duplicate_association_status with the appropriate information
84: x_duplicate_association_status := JTF_VARCHAR2_TABLE_100();
85: x_msite_prty_accss_ids := JTF_NUMBER_TABLE();
86: x_is_any_duplicate_status := FND_API.G_RET_STS_SUCCESS;
87:
88: FOR i IN 1..p_party_ids.COUNT LOOP
89:
90: x_duplicate_association_status.EXTEND();

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

94: FETCH c1 INTO l_tmp_id;
95: IF(c1%FOUND) THEN
96: CLOSE c1;
97: -- duplicate exists
98: x_duplicate_association_status(i) := FND_API.G_RET_STS_ERROR;
99: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;
100: x_msite_prty_accss_ids(i) := l_tmp_id;
101: ELSE
102: CLOSE c1;

Line 99: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;

95: IF(c1%FOUND) THEN
96: CLOSE c1;
97: -- duplicate exists
98: x_duplicate_association_status(i) := FND_API.G_RET_STS_ERROR;
99: x_is_any_duplicate_status := FND_API.G_RET_STS_ERROR;
100: x_msite_prty_accss_ids(i) := l_tmp_id;
101: ELSE
102: CLOSE c1;
103: -- no duplicate exists, create new entry

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

100: x_msite_prty_accss_ids(i) := l_tmp_id;
101: ELSE
102: CLOSE c1;
103: -- no duplicate exists, create new entry
104: x_duplicate_association_status(i) := FND_API.G_RET_STS_SUCCESS;
105:
106: Ibe_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss
107: (
108: p_api_version => p_api_version,

Line 109: p_init_msg_list => FND_API.G_FALSE,

105:
106: Ibe_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss
107: (
108: p_api_version => p_api_version,
109: p_init_msg_list => FND_API.G_FALSE,
110: p_commit => FND_API.G_FALSE,
111: p_validation_level => p_validation_level,
112: p_msite_id => p_msite_id,
113: p_party_id => p_party_ids(i),

Line 110: p_commit => FND_API.G_FALSE,

106: Ibe_Msite_Prty_Accss_Pvt.Create_Msite_Prty_Accss
107: (
108: p_api_version => p_api_version,
109: p_init_msg_list => FND_API.G_FALSE,
110: p_commit => FND_API.G_FALSE,
111: p_validation_level => p_validation_level,
112: p_msite_id => p_msite_id,
113: p_party_id => p_party_ids(i),
114: p_start_date_active => p_start_date_actives(i),

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

118: x_msg_count => x_msg_count,
119: x_msg_data => x_msg_data
120: );
121:
122: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
123: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121:
122: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
123: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
127: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;

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

122: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
123: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
127: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;

Line 129: RAISE FND_API.G_EXC_ERROR;

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
127: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_PRTY_FL');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131:
132: END IF;
133:

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

136: --
137: -- End of main API body.
138:
139: -- Standard check of p_commit.
140: IF (FND_API.To_Boolean(p_commit)) THEN
141: COMMIT WORK;
142: END IF;
143:
144: -- Standard call to get message count and if count is 1, get message info.

Line 151: WHEN FND_API.G_EXC_ERROR THEN

147: p_encoded => 'F');
148:
149: EXCEPTION
150:
151: WHEN FND_API.G_EXC_ERROR THEN
152: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
155: p_data => x_msg_data,

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149: EXCEPTION
150:
151: WHEN FND_API.G_EXC_ERROR THEN
152: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
155: p_data => x_msg_data,
156: p_encoded => 'F');
157:

Line 158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
155: p_data => x_msg_data,
156: p_encoded => 'F');
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
162: p_data => x_msg_data,

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

156: p_encoded => 'F');
157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: ROLLBACK TO Associate_Parties_To_Msite_Pvt;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => 'F');
164:

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
169: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
170: FND_MESSAGE.Set_Token('REASON', SQLERRM);
171: FND_MSG_PUB.Add;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

187: --
188: PROCEDURE Update_Delete_Msite_Prty
189: (
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

188: PROCEDURE Update_Delete_Msite_Prty
189: (
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,

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

189: (
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_msite_prty_accss_ids IN JTF_NUMBER_TABLE,
195: p_object_version_numbers IN JTF_NUMBER_TABLE,
196: p_msite_ids IN JTF_NUMBER_TABLE,
197: p_party_ids IN JTF_NUMBER_TABLE,

Line 217: IF NOT FND_API.Compatible_API_Call(l_api_version,

213: -- Standard Start of API savepoint
214: SAVEPOINT Update_Delete_Msite_Prty_Pvt;
215:
216: -- Standard call to check for call compatibility.
217: IF NOT FND_API.Compatible_API_Call(l_api_version,
218: p_api_version,
219: l_api_name,
220: G_PKG_NAME)
221: THEN

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: p_api_version,
219: l_api_name,
220: G_PKG_NAME)
221: THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 226: IF FND_API.to_Boolean(p_init_msg_list) THEN

222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226: IF FND_API.to_Boolean(p_init_msg_list) THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: -- Initialize API return status to success

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: -- Initialize API return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: -- API body
234: -- CALL FLOW :
235: -- 1.

Line 244: p_init_msg_list => FND_API.G_FALSE,

240:
241: Ibe_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss
242: (
243: p_api_version => p_api_version,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => p_validation_level,
247: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
248: p_msite_id => FND_API.G_MISS_NUM,

Line 245: p_commit => FND_API.G_FALSE,

241: Ibe_Msite_Prty_Accss_Pvt.Delete_Msite_Prty_Accss
242: (
243: p_api_version => p_api_version,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => p_validation_level,
247: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
248: p_msite_id => FND_API.G_MISS_NUM,
249: p_party_id => FND_API.G_MISS_NUM,

Line 248: p_msite_id => FND_API.G_MISS_NUM,

244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => p_validation_level,
247: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
248: p_msite_id => FND_API.G_MISS_NUM,
249: p_party_id => FND_API.G_MISS_NUM,
250: x_return_status => x_return_status,
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data

Line 249: p_party_id => FND_API.G_MISS_NUM,

245: p_commit => FND_API.G_FALSE,
246: p_validation_level => p_validation_level,
247: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
248: p_msite_id => FND_API.G_MISS_NUM,
249: p_party_id => FND_API.G_MISS_NUM,
250: x_return_status => x_return_status,
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data
253: );

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

251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data
253: );
254:
255: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
256: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 258: RAISE FND_API.G_EXC_ERROR;

254:
255: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
256: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

255: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
256: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_PRTY_FL');
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265: ELSE
266:

Line 270: p_init_msg_list => FND_API.G_FALSE,

266:
267: Ibe_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss
268: (
269: p_api_version => p_api_version,
270: p_init_msg_list => FND_API.G_FALSE,
271: p_commit => FND_API.G_FALSE,
272: p_validation_level => p_validation_level,
273: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
274: p_object_version_number => p_object_version_numbers(i),

Line 271: p_commit => FND_API.G_FALSE,

267: Ibe_Msite_Prty_Accss_Pvt.Update_Msite_Prty_Accss
268: (
269: p_api_version => p_api_version,
270: p_init_msg_list => FND_API.G_FALSE,
271: p_commit => FND_API.G_FALSE,
272: p_validation_level => p_validation_level,
273: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
274: p_object_version_number => p_object_version_numbers(i),
275: p_msite_id => FND_API.G_MISS_NUM,

Line 275: p_msite_id => FND_API.G_MISS_NUM,

271: p_commit => FND_API.G_FALSE,
272: p_validation_level => p_validation_level,
273: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
274: p_object_version_number => p_object_version_numbers(i),
275: p_msite_id => FND_API.G_MISS_NUM,
276: p_party_id => FND_API.G_MISS_NUM,
277: p_start_date_active => p_start_date_actives(i),
278: p_end_date_active => p_end_date_actives(i),
279: x_return_status => x_return_status,

Line 276: p_party_id => FND_API.G_MISS_NUM,

272: p_validation_level => p_validation_level,
273: p_msite_prty_accss_id => p_msite_prty_accss_ids(i),
274: p_object_version_number => p_object_version_numbers(i),
275: p_msite_id => FND_API.G_MISS_NUM,
276: p_party_id => FND_API.G_MISS_NUM,
277: p_start_date_active => p_start_date_actives(i),
278: p_end_date_active => p_end_date_actives(i),
279: x_return_status => x_return_status,
280: x_msg_count => x_msg_count,

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

280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data
282: );
283:
284: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
285: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 287: RAISE FND_API.G_EXC_ERROR;

283:
284: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
285: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
289: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

284: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
285: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
286: FND_MSG_PUB.Add;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
289: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
289: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_PRTY_FL');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: END IF;
295:

Line 303: (p_party_access_code = FND_API.G_MISS_CHAR))

299: -- Update ibe_msites_b's party_access_code flag
300: --
301: -- Check for validity of party access code
302: IF ((p_party_access_code IS NULL) OR
303: (p_party_access_code = FND_API.G_MISS_CHAR))
304: THEN
305: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVLD_PRTY_ACSS_CODE');
306: FND_MSG_PUB.Add;
307: RAISE FND_API.G_EXC_ERROR;

Line 307: RAISE FND_API.G_EXC_ERROR;

303: (p_party_access_code = FND_API.G_MISS_CHAR))
304: THEN
305: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVLD_PRTY_ACSS_CODE');
306: FND_MSG_PUB.Add;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309:
310: BEGIN
311: UPDATE ibe_msites_b

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PRTY_ACCSS_CODE_FAIL');
323: FND_MESSAGE.Set_Token('PARTY_ACCESS_CODE', p_party_access_code);
324: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
325: FND_MSG_PUB.Add;
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END;
328:
329: -- End of main API body.
330:

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

328:
329: -- End of main API body.
330:
331: -- Standard check of p_commit.
332: IF (FND_API.To_Boolean(p_commit)) THEN
333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: p_encoded => 'F');
340:
341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => 'F');
349:

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => 'F');
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data,

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

348: p_encoded => 'F');
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data,
355: p_encoded => 'F');
356:

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

355: p_encoded => 'F');
356:
357: WHEN OTHERS THEN
358: ROLLBACK TO Update_Delete_Msite_Prty_Pvt;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360:
361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

375: --
376: PROCEDURE Load_MsiteParties_For_Msite
377: (
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
382: p_msite_id IN NUMBER,
383: x_party_access_code_csr OUT NOCOPY PARTY_ACCESS_CODE_CSR,

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

376: PROCEDURE Load_MsiteParties_For_Msite
377: (
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
382: p_msite_id IN NUMBER,
383: x_party_access_code_csr OUT NOCOPY PARTY_ACCESS_CODE_CSR,
384: x_msite_csr OUT NOCOPY MSITE_CSR,

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

377: (
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
382: p_msite_id IN NUMBER,
383: x_party_access_code_csr OUT NOCOPY PARTY_ACCESS_CODE_CSR,
384: x_msite_csr OUT NOCOPY MSITE_CSR,
385: x_msite_prty_accss_csr OUT NOCOPY MSITE_PRTY_ACCSS_CSR,

Line 398: IF FND_API.to_Boolean(p_init_msg_list) THEN

394: l_api_version CONSTANT NUMBER := 1.0;
395: BEGIN
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE.
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Initialize API return status to success

Line 403: x_return_status := FND_API.G_RET_STS_SUCCESS;

399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Initialize API return status to success
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
405: -- Get the party access code data
406: OPEN x_party_access_code_csr FOR SELECT lookup_code, meaning
407: FROM fnd_lookups

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: ORDER BY party_id, account_number;
435:
436: EXCEPTION
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => 'F');

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435:
436: EXCEPTION
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => 'F');
443:

Line 444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => 'F');
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
447: p_data => x_msg_data,
448: p_encoded => 'F');

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: p_data => x_msg_data,
442: p_encoded => 'F');
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
447: p_data => x_msg_data,
448: p_encoded => 'F');
449:

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

447: p_data => x_msg_data,
448: p_encoded => 'F');
449:
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);