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.FEM_PARTY_PROFITABILITY_PUB dependencies on FND_API

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

11:
12:
13: procedure do_update_profitability(
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
16: p_commit IN VARCHAR2:= FND_API.G_TRUE,
17: p_profitability_rec IN PROFITABILITY_REC_TYPE,
18: p_last_update_date IN OUT NOCOPY DATE,
19: x_return_status IN OUT NOCOPY VARCHAR2,

Line 16: p_commit IN VARCHAR2:= FND_API.G_TRUE,

12:
13: procedure do_update_profitability(
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
16: p_commit IN VARCHAR2:= FND_API.G_TRUE,
17: p_profitability_rec IN PROFITABILITY_REC_TYPE,
18: p_last_update_date IN OUT NOCOPY DATE,
19: x_return_status IN OUT NOCOPY VARCHAR2,
20: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

Line 20: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

16: p_commit IN VARCHAR2:= FND_API.G_TRUE,
17: p_profitability_rec IN PROFITABILITY_REC_TYPE,
18: p_last_update_date IN OUT NOCOPY DATE,
19: x_return_status IN OUT NOCOPY VARCHAR2,
20: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
21: );
22:
23: procedure validate_profitability(
24: p_profitability_rec IN FEM_PARTY_profitability_pub.profitability_rec_type,

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

70:
71:
72: procedure create_profitability (
73: p_api_version IN NUMBER :=1.0,
74: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
75: p_commit IN VARCHAR2:= FND_API.G_TRUE,
76: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
77: p_profitability_rec IN PROFITABILITY_REC_TYPE,
78: x_return_status OUT NOCOPY VARCHAR2,

Line 75: p_commit IN VARCHAR2:= FND_API.G_TRUE,

71:
72: procedure create_profitability (
73: p_api_version IN NUMBER :=1.0,
74: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
75: p_commit IN VARCHAR2:= FND_API.G_TRUE,
76: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
77: p_profitability_rec IN PROFITABILITY_REC_TYPE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,

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

72: procedure create_profitability (
73: p_api_version IN NUMBER :=1.0,
74: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
75: p_commit IN VARCHAR2:= FND_API.G_TRUE,
76: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
77: p_profitability_rec IN PROFITABILITY_REC_TYPE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,

Line 92: IF NOT FND_API.Compatible_API_Call(

88: --Standard start of API savepoint
89: SAVEPOINT create_profitability_pub;
90:
91: --Standard call to check for call compatibility.
92: IF NOT FND_API.Compatible_API_Call(
93: l_api_version,
94: p_api_version,
95: l_api_name,
96: G_PKG_NAME)

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: p_api_version,
95: l_api_name,
96: G_PKG_NAME)
97: THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: --Initialize message list if p_init_msg_list is set to TRUE.
102: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 102: IF FND_API.to_Boolean(p_init_msg_list) THEN

98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: --Initialize message list if p_init_msg_list is set to TRUE.
102: IF FND_API.to_Boolean(p_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: --Initialize API return status to success.

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: --Initialize API return status to success.
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: --Call to User-Hook pre Processing Procedure
110:
111: /* IF (fnd_profile.value('HZ_EXECUTE_API_CALLOUTS') = 'Y') THEN

Line 118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

114: x_return_status,
115: x_msg_count,
116: x_msg_data);
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
122: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 119: RAISE FND_API.G_EXC_ERROR;

115: x_msg_count,
116: x_msg_data);
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
122: FND_MESSAGE.SET_TOKEN('PROCEDURE',
123: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_PRE');

Line 120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

116: x_msg_data);
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
122: FND_MESSAGE.SET_TOKEN('PROCEDURE',
123: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_PRE');
124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: FND_MESSAGE.SET_TOKEN('PROCEDURE',
123: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_PRE');
124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: END IF;
130: */

Line 147: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

143: x_return_status,
144: x_msg_count,
145: x_msg_data);
146:
147: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 148: RAISE FND_API.G_EXC_ERROR;

144: x_msg_count,
145: x_msg_data);
146:
147: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROCEDURE',
152: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_POST');

Line 149: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

145: x_msg_data);
146:
147: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROCEDURE',
152: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_POST');
153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: FND_MESSAGE.SET_TOKEN('PROCEDURE',
152: 'HZ_PROFITABILITY_CRMHK.CREATE_PROFITABILITY_POST');
153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
154: FND_MSG_PUB.ADD;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: END IF;
159: */

Line 162: IF FND_API.to_Boolean(p_commit) THEN

158: END IF;
159: */
160:
161: --Standard check of p_commit.
162: IF FND_API.to_Boolean(p_commit) THEN
163: commit;
164: END IF;
165:
166: --Standard call to get message count and if count is 1, get message info.

Line 168: p_encoded => FND_API.G_FALSE,

164: END IF;
165:
166: --Standard call to get message count and if count is 1, get message info.
167: FND_MSG_PUB.Count_And_Get(
168: p_encoded => FND_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: EXCEPTION

Line 173: WHEN FND_API.G_EXC_ERROR THEN

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

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 177: p_encoded => FND_API.G_FALSE,

173: WHEN FND_API.G_EXC_ERROR THEN
174: ROLLBACK TO create_location_pub;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MSG_PUB.Count_And_Get(
177: p_encoded => FND_API.G_FALSE,
178: p_count => x_msg_count,
179: p_data => x_msg_data);
180:
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: p_data => x_msg_data);
180:
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: ROLLBACK TO create_profitability_pub;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.Count_And_Get(
185: p_encoded => FND_API.G_FALSE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);

Line 185: p_encoded => FND_API.G_FALSE,

181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: ROLLBACK TO create_profitability_pub;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.Count_And_Get(
185: p_encoded => FND_API.G_FALSE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);
188:
189: WHEN OTHERS THEN

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: p_data => x_msg_data);
188:
189: WHEN OTHERS THEN
190: ROLLBACK TO create_profitability_pub;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192:
193: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
195: FND_MSG_PUB.ADD;

Line 198: p_encoded => FND_API.G_FALSE,

194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
195: FND_MSG_PUB.ADD;
196:
197: FND_MSG_PUB.Count_And_Get(
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data);
201:
202: END create_profitability;

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

235: +===========================================================================*/
236:
237: procedure update_profitability (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
240: p_commit IN VARCHAR2:=FND_API.G_TRUE,
241: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
242: p_profitability_rec IN PROFITABILITY_REC_TYPE,
243: p_last_update_date IN OUT NOCOPY DATE,

Line 240: p_commit IN VARCHAR2:=FND_API.G_TRUE,

236:
237: procedure update_profitability (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
240: p_commit IN VARCHAR2:=FND_API.G_TRUE,
241: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
242: p_profitability_rec IN PROFITABILITY_REC_TYPE,
243: p_last_update_date IN OUT NOCOPY DATE,
244: x_return_status OUT NOCOPY VARCHAR2,

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

237: procedure update_profitability (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
240: p_commit IN VARCHAR2:=FND_API.G_TRUE,
241: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
242: p_profitability_rec IN PROFITABILITY_REC_TYPE,
243: p_last_update_date IN OUT NOCOPY DATE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,

Line 257: IF NOT FND_API.Compatible_API_Call(

253: --Standard start of API savepoint
254: SAVEPOINT update_profitability_pub;
255:
256: --Standard call to check for call compatibility.
257: IF NOT FND_API.Compatible_API_Call(
258: l_api_version,
259: p_api_version,
260: l_api_name,
261: G_PKG_NAME)

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: p_api_version,
260: l_api_name,
261: G_PKG_NAME)
262: THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: --Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 267: IF FND_API.to_Boolean(p_init_msg_list) THEN

263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: --Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean(p_init_msg_list) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270:
271: --Initialize API return status to success.

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268: FND_MSG_PUB.initialize;
269: END IF;
270:
271: --Initialize API return status to success.
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: --------------------------------------------------------------
275: -- Since we aren't doing any pre processing at this time,
276: -- there is no need to get the current record or perform

Line 295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

291: x_return_status,
292: x_msg_count,
293: x_msg_data);
294:
295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
296: RAISE FND_API.G_EXC_ERROR;
297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
299: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 296: RAISE FND_API.G_EXC_ERROR;

292: x_msg_count,
293: x_msg_data);
294:
295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
296: RAISE FND_API.G_EXC_ERROR;
297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
299: FND_MESSAGE.SET_TOKEN('PROCEDURE',
300: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_PRE');

Line 297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

293: x_msg_data);
294:
295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
296: RAISE FND_API.G_EXC_ERROR;
297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
299: FND_MESSAGE.SET_TOKEN('PROCEDURE',
300: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_PRE');
301: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: FND_MESSAGE.SET_TOKEN('PROCEDURE',
300: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_PRE');
301: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: END IF;
307: */

Line 336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

332: x_return_status,
333: x_msg_count,
334: x_msg_data);
335:
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
340: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 337: RAISE FND_API.G_EXC_ERROR;

333: x_msg_count,
334: x_msg_data);
335:
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
340: FND_MESSAGE.SET_TOKEN('PROCEDURE',
341: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_POST');

Line 338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

334: x_msg_data);
335:
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
340: FND_MESSAGE.SET_TOKEN('PROCEDURE',
341: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_POST');
342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: FND_MESSAGE.SET_TOKEN('PROCEDURE',
341: 'HZ_PROFITABILITY_CRMHK.UPDATE_PROFITABILITY_POST');
342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: END IF;
348:

Line 356: IF FND_API.to_Boolean(p_commit) THEN

352: */
353:
354: --Standard check of p_commit.
355:
356: IF FND_API.to_Boolean(p_commit) THEN
357: commit;
358: END IF;
359:
360: --Standard call to get message count and if count is 1, get message info.

Line 362: p_encoded => FND_API.G_FALSE,

358: END IF;
359:
360: --Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get(
362: p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: EXCEPTION

Line 367: WHEN FND_API.G_EXC_ERROR THEN

363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO update_profitability_pub;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MSG_PUB.Count_And_Get(
371: p_encoded => FND_API.G_FALSE,

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO update_profitability_pub;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MSG_PUB.Count_And_Get(
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data);

Line 371: p_encoded => FND_API.G_FALSE,

367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO update_profitability_pub;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MSG_PUB.Count_And_Get(
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO update_profitability_pub;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_And_Get(
379: p_encoded => FND_API.G_FALSE,

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: p_data => x_msg_data);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO update_profitability_pub;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_And_Get(
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data);

Line 379: p_encoded => FND_API.G_FALSE,

375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO update_profitability_pub;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_And_Get(
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data);
382:
383: WHEN OTHERS THEN

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: p_data => x_msg_data);
382:
383: WHEN OTHERS THEN
384: ROLLBACK TO update_profitability_pub;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
388: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
389: FND_MSG_PUB.ADD;

Line 392: p_encoded => FND_API.G_FALSE,

388: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
389: FND_MSG_PUB.ADD;
390:
391: FND_MSG_PUB.Count_And_Get(
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data);
395:
396: END update_profitability;

Line 513: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

509: BEGIN
510:
511: validate_profitability(p_profitability_rec, 'C', x_return_status);
512:
513: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516:
517: --Call table-handler.

Line 514: RAISE FND_API.G_EXC_ERROR;

510:
511: validate_profitability(p_profitability_rec, 'C', x_return_status);
512:
513: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516:
517: --Call table-handler.
518:

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

625: +===========================================================================*/
626:
627: procedure do_update_profitability(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
630: p_commit IN VARCHAR2:= FND_API.G_TRUE,
631: p_profitability_rec IN PROFITABILITY_REC_TYPE,
632: p_last_update_date IN OUT NOCOPY DATE,
633: x_return_status IN OUT NOCOPY VARCHAR2,

Line 630: p_commit IN VARCHAR2:= FND_API.G_TRUE,

626:
627: procedure do_update_profitability(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
630: p_commit IN VARCHAR2:= FND_API.G_TRUE,
631: p_profitability_rec IN PROFITABILITY_REC_TYPE,
632: p_last_update_date IN OUT NOCOPY DATE,
633: x_return_status IN OUT NOCOPY VARCHAR2,
634: p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL

Line 634: p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL

630: p_commit IN VARCHAR2:= FND_API.G_TRUE,
631: p_profitability_rec IN PROFITABILITY_REC_TYPE,
632: p_last_update_date IN OUT NOCOPY DATE,
633: x_return_status IN OUT NOCOPY VARCHAR2,
634: p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
635: ) IS
636: exist_last_update_date DATE; -- last_update_date of existing
637: -- record in FEM_PARTY_PROFITABILITY for
638: -- same party_id

Line 663: p_profitability_rec.party_id = FND_API.G_MISS_NUM THEN

659:
660:
661: --Check whether primary key has been passed in.
662: IF p_profitability_rec.party_id IS NULL OR
663: p_profitability_rec.party_id = FND_API.G_MISS_NUM THEN
664:
665: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
666: FND_MESSAGE.SET_TOKEN('COLUMN', 'party id');
667: FND_MSG_PUB.ADD;

Line 668: RAISE FND_API.G_EXC_ERROR;

664:
665: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
666: FND_MESSAGE.SET_TOKEN('COLUMN', 'party id');
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: -------------------------------------------------------------
672: -- Don't need the check last_update_date logic because null

Line 678: p_last_update_date = FND_API.G_MISS_DATE THEN

674: -- record does not exist
675: --------------------------------------------------------------
676: /*--Check whether last_update_date has been passed in.
677: IF p_last_update_date IS NULL OR
678: p_last_update_date = FND_API.G_MISS_DATE THEN
679:
680: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
681: FND_MESSAGE.SET_TOKEN('COLUMN', 'profitability last update date');
682: FND_MSG_PUB.ADD;

Line 683: RAISE FND_API.G_EXC_ERROR;

679:
680: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
681: FND_MESSAGE.SET_TOKEN('COLUMN', 'profitability last update date');
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_ERROR;
684: END IF; */
685: ---------------------------------------------------------------
686:
687:

Line 724: RAISE FND_API.G_EXC_ERROR; */

720: EXCEPTION WHEN NO_DATA_FOUND THEN
721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
722: FND_MESSAGE.SET_TOKEN('TABLE', 'FEM_PARTY_PROFITABILITY');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR; */
725: -----------------------------------------------------------------------
726:
727: --Call for validations.
728: validate_profitability(p_profitability_rec, 'U', x_return_status);

Line 730: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

726:
727: --Call for validations.
728: validate_profitability(p_profitability_rec, 'U', x_return_status);
729:
730: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733:
734: --Set value for geometry and rowid

Line 731: RAISE FND_API.G_EXC_ERROR;

727: --Call for validations.
728: validate_profitability(p_profitability_rec, 'U', x_return_status);
729:
730: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733:
734: --Set value for geometry and rowid
735: SELECT rowid INTO l_rowid

Line 869: IF (create_update_flag = 'C' AND (p_profitability_rec.party_id = FND_API.G_MISS_NUM OR

865:
866: BEGIN
867:
868: --Check for mandatory, but updateable columns
869: IF (create_update_flag = 'C' AND (p_profitability_rec.party_id = FND_API.G_MISS_NUM OR
870: p_profitability_rec.party_id IS NULL)) OR (create_update_flag = 'U' AND
871: p_profitability_rec.party_id IS NULL) THEN
872: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
873: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

Line 875: x_return_status := FND_API.G_RET_STS_ERROR;

871: p_profitability_rec.party_id IS NULL) THEN
872: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
873: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
874: FND_MSG_PUB.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877:
878: END validate_profitability;
879: