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

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

70: +===========================================================================
71:
72: procedure create_credit_ratings(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
75: p_commit IN VARCHAR2:= FND_API.G_FALSE,
76: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,

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

71:
72: procedure create_credit_ratings(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
75: p_commit IN VARCHAR2:= FND_API.G_FALSE,
76: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,

Line 81: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: x_credit_rating_id OUT NOCOPY NUMBER,
81: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
82: ) IS
83:
84: l_api_name CONSTANT VARCHAR2(30) := 'create credit ratings';
85: l_api_version CONSTANT NUMBER := 1.0;

Line 94: IF NOT FND_API.Compatible_API_Call(

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

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 104: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: --Initialize API return status to success.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: -- Bug 2197181: added for mix-n-match project. first load data
112: -- sources for this entity. Then assign the actual_content_source
113: -- to the real data source. The value of content_source_type is

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: x_is_datasource_selected => g_cre_is_datasource_selected,
141: x_return_status => x_return_status,
142: p_api_version => 'V1');
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: ******** this code is replaced to go via V2 API.

Line 145: RAISE FND_API.G_EXC_ERROR;

141: x_return_status => x_return_status,
142: p_api_version => 'V1');
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: ******** this code is replaced to go via V2 API.
149: -- Call to business logic.

Line 164: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

160: x_credit_rating_id);
161:
162: ********* this call will be from V2 API
163: -- Invoke business event system.
164: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
165: -- Bug 2197181: Added below condition for Mix-n-Match
166: g_cre_is_datasource_selected = 'Y'
167: THEN
168: HZ_BUSINESS_EVENT_V2PVT.create_credit_ratings_event(l_credit_ratings_rec);

Line 173: IF FND_API.to_Boolean(p_commit) THEN

169: END IF;
170: *********
171:
172: --Standard check of p_commit.
173: IF FND_API.to_Boolean(p_commit) THEN
174: Commit;
175: END IF;
176:
177: --Standard call to get message count and if count is 1, get message info.

Line 179: p_encoded => FND_API.G_FALSE,

175: END IF;
176:
177: --Standard call to get message count and if count is 1, get message info.
178: FND_MSG_PUB.Count_And_Get(
179: p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: EXCEPTION

Line 184: WHEN FND_API.G_EXC_ERROR THEN

180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO create_credit_ratings_pub;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: FND_MSG_PUB.Count_And_Get(

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO create_credit_ratings_pub;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: FND_MSG_PUB.Count_And_Get(
189: p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,

Line 189: p_encoded => FND_API.G_FALSE,

185: ROLLBACK TO create_credit_ratings_pub;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: FND_MSG_PUB.Count_And_Get(
189: p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO create_credit_ratings_pub;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: FND_MSG_PUB.Count_And_Get(

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: p_data => x_msg_data);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO create_credit_ratings_pub;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: FND_MSG_PUB.Count_And_Get(
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,

Line 198: p_encoded => FND_API.G_FALSE,

194: ROLLBACK TO create_credit_ratings_pub;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: WHEN OTHERS THEN

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: p_data => x_msg_data);
201:
202: WHEN OTHERS THEN
203: ROLLBACK TO create_credit_ratings_pub;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205:
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
208: FND_MSG_PUB.ADD;

Line 211: p_encoded => FND_API.G_FALSE,

207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
208: FND_MSG_PUB.ADD;
209:
210: FND_MSG_PUB.Count_And_Get(
211: p_encoded => FND_API.G_FALSE,
212: p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: END create_credit_ratings;

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

252: +===========================================================================
253:
254: procedure update_credit_ratings(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
257: p_commit IN VARCHAR2:= FND_API.G_FALSE,
258: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
259: p_last_update_date IN OUT NOCOPY DATE,
260: x_return_status OUT NOCOPY VARCHAR2,

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

253:
254: procedure update_credit_ratings(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
257: p_commit IN VARCHAR2:= FND_API.G_FALSE,
258: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
259: p_last_update_date IN OUT NOCOPY DATE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,

Line 263: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

259: p_last_update_date IN OUT NOCOPY DATE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ) IS
265:
266: l_api_name CONSTANT VARCHAR2(30) := 'update credit ratings';
267: l_api_version CONSTANT NUMBER := 1.0;

Line 277: IF NOT FND_API.Compatible_API_Call(

273: --Standard start of API savepoint
274: SAVEPOINT update_credit_ratings_pub;
275:
276: --Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call(
278: l_api_version,
279: p_api_version,
280: l_api_name,
281: G_PKG_NAME)

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: p_api_version,
280: l_api_name,
281: G_PKG_NAME)
282: THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: --Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 287: IF FND_API.to_Boolean(p_init_msg_list) THEN

283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: --Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean(p_init_msg_list) THEN
288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: --Initialize API return status to success.

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: --Initialize API return status to success.
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: get_current_credit_rating(
295: 1, FND_API.G_FALSE,
296: l_credit_ratings_rec.credit_rating_id,

Line 295: 1, FND_API.G_FALSE,

291: --Initialize API return status to success.
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: get_current_credit_rating(
295: 1, FND_API.G_FALSE,
296: l_credit_ratings_rec.credit_rating_id,
297: l_old_credit_ratings_rec,
298: x_return_status,
299: x_msg_count,

Line 302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

298: x_return_status,
299: x_msg_count,
300: x_msg_data);
301:
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;

Line 303: RAISE FND_API.G_EXC_ERROR;

299: x_msg_count,
300: x_msg_data);
301:
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:

Line 304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

300: x_msg_data);
301:
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:
308: -- Bug 2197181: added for mix-n-match project. first load data

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301:
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:
308: -- Bug 2197181: added for mix-n-match project. first load data
309: -- sources for this entity.

Line 348: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

344: x_return_status);
345:
346: ********* this call will be from V2 API
347: -- Invoke business event system.
348: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
349: -- Bug 2197181: Added below condition for Mix-n-Match
350: g_cre_is_datasource_selected = 'Y'
351: THEN
352: HZ_BUSINESS_EVENT_V2PVT.update_credit_ratings_event( l_credit_ratings_rec);

Line 357: IF FND_API.to_Boolean(p_commit) THEN

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

Line 363: p_encoded => FND_API.G_FALSE,

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

Line 368: WHEN FND_API.G_EXC_ERROR THEN

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

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 373: p_encoded => FND_API.G_FALSE,

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

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 382: p_encoded => FND_API.G_FALSE,

378: ROLLBACK TO update_credit_ratings_pub;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: FND_MSG_PUB.Count_And_Get(
382: p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385:
386: WHEN OTHERS THEN

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 395: p_encoded => FND_API.G_FALSE,

391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
392: FND_MSG_PUB.ADD;
393:
394: FND_MSG_PUB.Count_And_Get(
395: p_encoded => FND_API.G_FALSE,
396: p_count => x_msg_count,
397: p_data => x_msg_data);
398:
399: END update_credit_ratings;

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

435: +===========================================================================*/
436:
437: procedure create_financial_profile(
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
440: p_commit IN VARCHAR2:= FND_API.G_FALSE,
441: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,

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

436:
437: procedure create_financial_profile(
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
440: p_commit IN VARCHAR2:= FND_API.G_FALSE,
441: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,

Line 446: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: x_financial_profile_id OUT NOCOPY NUMBER,
446: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
447: ) IS
448: l_api_name CONSTANT VARCHAR2(30) := 'create financial profile';
449: l_api_version CONSTANT NUMBER := 1.0;
450: l_financial_profile_rec FINANCIAL_PROFILE_REC_TYPE := p_financial_profile_rec;

Line 456: IF NOT FND_API.Compatible_API_Call(

452: BEGIN
453: --Standard start of API savepoint
454: SAVEPOINT create_financial_profile_pub;
455: --Standard call to check for call compatibility.
456: IF NOT FND_API.Compatible_API_Call(
457: l_api_version,
458: p_api_version,
459: l_api_name,
460: G_PKG_NAME)

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: p_api_version,
459: l_api_name,
460: G_PKG_NAME)
461: THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: --Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 466: IF FND_API.to_Boolean(p_init_msg_list) THEN

462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: --Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean(p_init_msg_list) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: --Initialize API return status to success.

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: --Initialize API return status to success.
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: /*
473: --Call to User-Hook pre Processing Procedure
474: IF fnd_profile.value('HZ_EXECUTE_API_CALLOUTS') = 'Y' THEN
475: hz_party_info_crmhk.create_financial_profile_pre(

Line 481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

477: x_return_status,
478: x_msg_count,
479: x_msg_data);
480:
481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
485: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 482: RAISE FND_API.G_EXC_ERROR;

478: x_msg_count,
479: x_msg_data);
480:
481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
485: FND_MESSAGE.SET_TOKEN('PROCEDURE',
486: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_PRE');

Line 483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

479: x_msg_data);
480:
481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
485: FND_MESSAGE.SET_TOKEN('PROCEDURE',
486: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_PRE');
487: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: FND_MESSAGE.SET_TOKEN('PROCEDURE',
486: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_PRE');
487: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:
492: END IF;
493: */

Line 509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

505: x_return_status,
506: x_msg_count,
507: x_msg_data);
508:
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
513: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 510: RAISE FND_API.G_EXC_ERROR;

506: x_msg_count,
507: x_msg_data);
508:
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
513: FND_MESSAGE.SET_TOKEN('PROCEDURE',
514: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_POST');

Line 511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

507: x_msg_data);
508:
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
513: FND_MESSAGE.SET_TOKEN('PROCEDURE',
514: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_POST');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: FND_MESSAGE.SET_TOKEN('PROCEDURE',
514: 'HZ_PARTY_INFO_CRMHK.CREATE_FINANCIAL_PROFILE_POST');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: END IF;
521: */

Line 522: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

518: END IF;
519:
520: END IF;
521: */
522: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
523: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
524: hz_business_event_v2pvt.create_fin_profile_event(L_FINANCIAL_PROFILE_REC);
525: END IF;
526:

Line 536: IF FND_API.to_Boolean(p_commit) THEN

532: END IF;
533: END IF;
534:
535: --Standard check of p_commit.
536: IF FND_API.to_Boolean(p_commit) THEN
537: Commit;
538: END IF;
539:
540: --Standard call to get message count and if count is 1, get message info.

Line 542: p_encoded => FND_API.G_FALSE,

538: END IF;
539:
540: --Standard call to get message count and if count is 1, get message info.
541: FND_MSG_PUB.Count_And_Get(
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data);
545: EXCEPTION
546: WHEN FND_API.G_EXC_ERROR THEN

Line 546: WHEN FND_API.G_EXC_ERROR THEN

542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data);
545: EXCEPTION
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO create_financial_profile_pub;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MSG_PUB.Count_And_Get(
550: p_encoded => FND_API.G_FALSE,

Line 548: x_return_status := FND_API.G_RET_STS_ERROR;

544: p_data => x_msg_data);
545: EXCEPTION
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO create_financial_profile_pub;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MSG_PUB.Count_And_Get(
550: p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);

Line 550: p_encoded => FND_API.G_FALSE,

546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO create_financial_profile_pub;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MSG_PUB.Count_And_Get(
550: p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

550: p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: ROLLBACK TO create_financial_profile_pub;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get(
558: p_encoded => FND_API.G_FALSE,

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: p_data => x_msg_data);
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: ROLLBACK TO create_financial_profile_pub;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get(
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data);

Line 558: p_encoded => FND_API.G_FALSE,

554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: ROLLBACK TO create_financial_profile_pub;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get(
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data);
561:
562: WHEN OTHERS THEN

Line 564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: p_data => x_msg_data);
561:
562: WHEN OTHERS THEN
563: ROLLBACK TO create_financial_profile_pub;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565:
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;

Line 571: p_encoded => FND_API.G_FALSE,

567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569:
570: FND_MSG_PUB.Count_And_Get(
571: p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => x_msg_data);
574:
575: END create_financial_profile;

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

607: +===========================================================================*/
608:
609: procedure update_financial_profile(
610: p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
612: p_commit IN VARCHAR2:= FND_API.G_FALSE,
613: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
614: p_last_update_date IN OUT NOCOPY DATE,
615: x_return_status OUT NOCOPY VARCHAR2,

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

608:
609: procedure update_financial_profile(
610: p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
612: p_commit IN VARCHAR2:= FND_API.G_FALSE,
613: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
614: p_last_update_date IN OUT NOCOPY DATE,
615: x_return_status OUT NOCOPY VARCHAR2,
616: x_msg_count OUT NOCOPY NUMBER,

Line 618: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

614: p_last_update_date IN OUT NOCOPY DATE,
615: x_return_status OUT NOCOPY VARCHAR2,
616: x_msg_count OUT NOCOPY NUMBER,
617: x_msg_data OUT NOCOPY VARCHAR2,
618: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
619: ) IS
620: l_api_name CONSTANT VARCHAR2(30) := 'update financial profile';
621: l_api_version CONSTANT NUMBER := 1.0;
622: l_financial_profile_rec FINANCIAL_PROFILE_REC_TYPE := p_financial_profile_rec;

Line 628: IF NOT FND_API.Compatible_API_Call(

624: BEGIN
625: --Standard start of API savepoint
626: SAVEPOINT update_financial_profile_pub;
627: --Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call(
629: l_api_version,
630: p_api_version,
631: l_api_name,
632: G_PKG_NAME)

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: p_api_version,
631: l_api_name,
632: G_PKG_NAME)
633: THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
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

Line 638: IF FND_API.to_Boolean(p_init_msg_list) THEN

634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
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: /*
646: --Call to User-Hook pre Processing Procedure
647: IF fnd_profile.value('HZ_EXECUTE_API_CALLOUTS') = 'Y' THEN

Line 654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

650: x_return_status,
651: x_msg_count,
652: x_msg_data);
653:
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
658: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 655: RAISE FND_API.G_EXC_ERROR;

651: x_msg_count,
652: x_msg_data);
653:
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
658: FND_MESSAGE.SET_TOKEN('PROCEDURE',
659: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_PRE');

Line 656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

652: x_msg_data);
653:
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
658: FND_MESSAGE.SET_TOKEN('PROCEDURE',
659: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_PRE');
660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: FND_MESSAGE.SET_TOKEN('PROCEDURE',
659: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_PRE');
660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
661: FND_MSG_PUB.ADD;
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:
665: END IF;
666: */

Line 683: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

679: x_return_status,
680: x_msg_count,
681: x_msg_data);
682:
683: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
684: RAISE FND_API.G_EXC_ERROR;
685: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
687: FND_MESSAGE.SET_TOKEN('PROCEDURE',

Line 684: RAISE FND_API.G_EXC_ERROR;

680: x_msg_count,
681: x_msg_data);
682:
683: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
684: RAISE FND_API.G_EXC_ERROR;
685: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
687: FND_MESSAGE.SET_TOKEN('PROCEDURE',
688: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_POST');

Line 685: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

681: x_msg_data);
682:
683: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
684: RAISE FND_API.G_EXC_ERROR;
685: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
687: FND_MESSAGE.SET_TOKEN('PROCEDURE',
688: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_POST');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: FND_MESSAGE.SET_TOKEN('PROCEDURE',
688: 'HZ_PARTY_INFO_CRMHK.UPDATE_FINANCIAL_PROFILE_POST');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: END IF;
695: */

Line 696: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

692: END IF;
693:
694: END IF;
695: */
696: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
698: hz_business_event_v2pvt.update_fin_profile_event(l_financial_profile_rec);
699: END IF;
700:

Line 710: IF FND_API.to_Boolean(p_commit) THEN

706: END IF;
707: END IF;
708:
709: --Standard check of p_commit.
710: IF FND_API.to_Boolean(p_commit) THEN
711: Commit;
712: END IF;
713:
714: --Standard call to get message count and if count is 1, get message info.

Line 716: p_encoded => FND_API.G_FALSE,

712: END IF;
713:
714: --Standard call to get message count and if count is 1, get message info.
715: FND_MSG_PUB.Count_And_Get(
716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
718: p_data => x_msg_data);
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN

Line 720: WHEN FND_API.G_EXC_ERROR THEN

716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
718: p_data => x_msg_data);
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: ROLLBACK TO update_financial_profile_pub;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: p_data => x_msg_data);
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: ROLLBACK TO update_financial_profile_pub;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);

Line 724: p_encoded => FND_API.G_FALSE,

720: WHEN FND_API.G_EXC_ERROR THEN
721: ROLLBACK TO update_financial_profile_pub;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_financial_profile_pub;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get(
732: p_encoded => FND_API.G_FALSE,

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_financial_profile_pub;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get(
732: p_encoded => FND_API.G_FALSE,
733: p_count => x_msg_count,
734: p_data => x_msg_data);

Line 732: p_encoded => FND_API.G_FALSE,

728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_financial_profile_pub;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get(
732: p_encoded => FND_API.G_FALSE,
733: p_count => x_msg_count,
734: p_data => x_msg_data);
735:
736: WHEN OTHERS THEN

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

734: p_data => x_msg_data);
735:
736: WHEN OTHERS THEN
737: ROLLBACK TO update_financial_profile_pub;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739:
740: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;

Line 745: p_encoded => FND_API.G_FALSE,

741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743:
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data);
748:
749: END update_financial_profile;

Line 807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

803: x_return_status,
804: x_msg_count,
805: x_msg_data);
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
811: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_PRE');

Line 808: RAISE FND_API.G_EXC_ERROR;

804: x_msg_count,
805: x_msg_data);
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
811: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_PRE');
812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

805: x_msg_data);
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
811: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_PRE');
812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
813: FND_MSG_PUB.ADD;

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
811: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_PRE');
812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: END IF;
817: */
818:

Line 822: l_credit_rating_id = FND_API.G_MISS_NUM

818:
819: -- if credit_rating_id is NULL, then generate PK.
820:
821: IF l_credit_rating_id is NULL OR
822: l_credit_rating_id = FND_API.G_MISS_NUM
823: THEN
824: l_count := 1;
825: WHILE l_count > 0 LOOP
826: SELECT hz_credit_ratings_s.nextval

Line 846: RAISE FND_API.G_EXC_ERROR;

842: IF l_count > 0 THEN
843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
845: FND_MSG_PUB.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: END IF;
849:
850: x_credit_rating_id := l_credit_rating_id;

Line 857: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

853:
854: HZ_PARTY_INFO_VAL.validate_credit_ratings(
855: p_credit_ratings_rec, 'C', x_return_status);
856:
857: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: -- sync obsolete column suit_judge_ind with new column suit_ind

Line 858: RAISE FND_API.G_EXC_ERROR;

854: HZ_PARTY_INFO_VAL.validate_credit_ratings(
855: p_credit_ratings_rec, 'C', x_return_status);
856:
857: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: -- sync obsolete column suit_judge_ind with new column suit_ind
862:

Line 864: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) AND

860:
861: -- sync obsolete column suit_judge_ind with new column suit_ind
862:
863: IF (p_credit_ratings_rec.suit_judge_ind is not null AND
864: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) AND
865: ( p_credit_ratings_rec.suit_ind is null OR
866: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR)
867: THEN
868: p_credit_ratings_rec.suit_ind := p_credit_ratings_rec.suit_judge_ind;

Line 866: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR)

862:
863: IF (p_credit_ratings_rec.suit_judge_ind is not null AND
864: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) AND
865: ( p_credit_ratings_rec.suit_ind is null OR
866: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR)
867: THEN
868: p_credit_ratings_rec.suit_ind := p_credit_ratings_rec.suit_judge_ind;
869: ELSIF nvl(p_credit_ratings_rec.suit_ind, FND_API.G_MISS_CHAR) <>
870: nvl(p_credit_ratings_rec.suit_judge_ind, FND_API.G_MISS_CHAR) THEN

Line 869: ELSIF nvl(p_credit_ratings_rec.suit_ind, FND_API.G_MISS_CHAR) <>

865: ( p_credit_ratings_rec.suit_ind is null OR
866: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR)
867: THEN
868: p_credit_ratings_rec.suit_ind := p_credit_ratings_rec.suit_judge_ind;
869: ELSIF nvl(p_credit_ratings_rec.suit_ind, FND_API.G_MISS_CHAR) <>
870: nvl(p_credit_ratings_rec.suit_judge_ind, FND_API.G_MISS_CHAR) THEN
871: p_credit_ratings_rec.suit_judge_ind := p_credit_ratings_rec.suit_ind;
872: END IF;
873:

Line 870: nvl(p_credit_ratings_rec.suit_judge_ind, FND_API.G_MISS_CHAR) THEN

866: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR)
867: THEN
868: p_credit_ratings_rec.suit_ind := p_credit_ratings_rec.suit_judge_ind;
869: ELSIF nvl(p_credit_ratings_rec.suit_ind, FND_API.G_MISS_CHAR) <>
870: nvl(p_credit_ratings_rec.suit_judge_ind, FND_API.G_MISS_CHAR) THEN
871: p_credit_ratings_rec.suit_judge_ind := p_credit_ratings_rec.suit_ind;
872: END IF;
873:
874: -- Bug 1428526: Should pass updated credit rating info. to caller.

Line 1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1000: x_return_status,
1001: x_msg_count,
1002: x_msg_data);
1003:
1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: RAISE FND_API.G_EXC_ERROR;
1006: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1007: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1008: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_POST');

Line 1005: RAISE FND_API.G_EXC_ERROR;

1001: x_msg_count,
1002: x_msg_data);
1003:
1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: RAISE FND_API.G_EXC_ERROR;
1006: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1007: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1008: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_POST');
1009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1006: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1002: x_msg_data);
1003:
1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: RAISE FND_API.G_EXC_ERROR;
1006: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1007: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1008: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_POST');
1009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1010: FND_MSG_PUB.ADD;

Line 1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1007: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1008: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.CREATE_CREDIT_RATINGS_POST');
1009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1010: FND_MSG_PUB.ADD;
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013: END IF;
1014: */
1015:

Line 1062: p_credit_ratings_rec.credit_rating_id = FND_API.G_MISS_NUM

1058: BEGIN
1059:
1060: -- check required fields:
1061: IF p_credit_ratings_rec.credit_rating_id is NULL OR
1062: p_credit_ratings_rec.credit_rating_id = FND_API.G_MISS_NUM
1063: THEN
1064: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1065: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
1066: FND_MSG_PUB.ADD;

Line 1067: RAISE FND_API.G_EXC_ERROR;

1063: THEN
1064: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1065: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
1066: FND_MSG_PUB.ADD;
1067: RAISE FND_API.G_EXC_ERROR;
1068: END IF;
1069:
1070: IF p_last_update_date IS NULL OR
1071: p_last_update_date = FND_API.G_MISS_DATE

Line 1071: p_last_update_date = FND_API.G_MISS_DATE

1067: RAISE FND_API.G_EXC_ERROR;
1068: END IF;
1069:
1070: IF p_last_update_date IS NULL OR
1071: p_last_update_date = FND_API.G_MISS_DATE
1072: THEN
1073: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1074: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1075: FND_MSG_PUB.ADD;

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: THEN
1073: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1074: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1075: FND_MSG_PUB.ADD;
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079: BEGIN
1080: -- check last update date.

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: WHEN NO_DATA_FOUND THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1094: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
1095: FND_MSG_PUB.ADD;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END;
1098:
1099: --Call to User-Hook pre Processing Procedure
1100: --Bug 1363124: validation#3 of content_source_type

Line 1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1108: x_return_status,
1109: x_msg_count,
1110: x_msg_data);
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_PRE');

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109: x_msg_count,
1110: x_msg_data);
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_PRE');
1117: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1110: x_msg_data);
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_PRE');
1117: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1118: FND_MSG_PUB.ADD;

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_PRE');
1117: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1118: FND_MSG_PUB.ADD;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121: END IF;
1122: */
1123:

Line 1128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1124: -- validate credit rating record
1125: HZ_PARTY_INFO_VAL.validate_credit_ratings(
1126: p_credit_ratings_rec, 'U', x_return_status);
1127:
1128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131:
1132: -- sync obsolete column suit_judge_ind with new column suit_ind

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: HZ_PARTY_INFO_VAL.validate_credit_ratings(
1126: p_credit_ratings_rec, 'U', x_return_status);
1127:
1128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131:
1132: -- sync obsolete column suit_judge_ind with new column suit_ind
1133: IF (p_credit_ratings_rec.suit_ind is NULL AND

Line 1136: p_credit_ratings_rec.suit_ind <> FND_API.G_MISS_CHAR AND

1132: -- sync obsolete column suit_judge_ind with new column suit_ind
1133: IF (p_credit_ratings_rec.suit_ind is NULL AND
1134: p_credit_ratings_rec.suit_judge_ind is not null ) OR
1135: (p_credit_ratings_rec.suit_ind is not NULL AND
1136: p_credit_ratings_rec.suit_ind <> FND_API.G_MISS_CHAR AND
1137: (p_credit_ratings_rec.suit_judge_ind is null OR
1138: (p_credit_ratings_rec.suit_judge_ind is not null AND
1139: p_credit_ratings_rec.suit_ind <> p_credit_ratings_rec.suit_judge_ind ) ) )
1140: THEN

Line 1143: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR ) AND

1139: p_credit_ratings_rec.suit_ind <> p_credit_ratings_rec.suit_judge_ind ) ) )
1140: THEN
1141: p_credit_ratings_rec.suit_judge_ind := p_credit_ratings_rec.suit_ind;
1142: ELSIF (p_credit_ratings_rec.suit_ind is not NULL AND
1143: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR ) AND
1144: (p_credit_ratings_rec.suit_judge_ind is null OR
1145: (p_credit_ratings_rec.suit_judge_ind is not null AND
1146: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) )
1147: THEN

Line 1146: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) )

1142: ELSIF (p_credit_ratings_rec.suit_ind is not NULL AND
1143: p_credit_ratings_rec.suit_ind = FND_API.G_MISS_CHAR ) AND
1144: (p_credit_ratings_rec.suit_judge_ind is null OR
1145: (p_credit_ratings_rec.suit_judge_ind is not null AND
1146: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR) )
1147: THEN
1148: p_credit_ratings_rec.suit_ind := p_credit_ratings_rec.suit_judge_ind;
1149: END IF;
1150:

Line 1168: x_created_by => fnd_api.g_miss_num,

1164: x_party_id => p_credit_ratings_rec.party_id,
1165: x_rating => p_credit_ratings_rec.rating,
1166: x_rated_as_of_date => p_credit_ratings_rec.rated_as_of_date,
1167: x_rating_organization => p_credit_ratings_rec.rating_organization,
1168: x_created_by => fnd_api.g_miss_num,
1169: x_creation_date => fnd_api.g_miss_date,
1170: x_last_update_login => hz_utility_pub.last_update_login,
1171: x_last_update_date => p_last_update_date,
1172: x_last_updated_by => hz_utility_pub.last_updated_by,

Line 1169: x_creation_date => fnd_api.g_miss_date,

1165: x_rating => p_credit_ratings_rec.rating,
1166: x_rated_as_of_date => p_credit_ratings_rec.rated_as_of_date,
1167: x_rating_organization => p_credit_ratings_rec.rating_organization,
1168: x_created_by => fnd_api.g_miss_num,
1169: x_creation_date => fnd_api.g_miss_date,
1170: x_last_update_login => hz_utility_pub.last_update_login,
1171: x_last_update_date => p_last_update_date,
1172: x_last_updated_by => hz_utility_pub.last_updated_by,
1173: x_request_id => hz_utility_pub.request_id,

Line 1189: x_content_source_type => fnd_api.g_miss_char,

1185: x_disaster_ind => p_credit_ratings_rec.disaster_ind,
1186: x_oprg_spec_evnt_ind => p_credit_ratings_rec.oprg_spec_evnt_ind,
1187: x_other_spec_evnt_ind => p_credit_ratings_rec.other_spec_evnt_ind,
1188: -- Bug 2197181 : content_source_type is obsolete and it is non-updateable.
1189: x_content_source_type => fnd_api.g_miss_char,
1190: x_program_update_date => hz_utility_pub.program_update_date,
1191: x_status => p_credit_ratings_rec.status,
1192: x_avg_high_credit => p_credit_ratings_rec.avg_high_credit,
1193: x_credit_score => p_credit_ratings_rec.credit_score,

Line 1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1280: x_return_status,
1281: x_msg_count,
1282: x_msg_data);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1288: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_POST');

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281: x_msg_count,
1282: x_msg_data);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1288: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_POST');
1289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1282: x_msg_data);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1288: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_POST');
1289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1290: FND_MSG_PUB.ADD;

Line 1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1288: FND_MESSAGE.SET_TOKEN('PROCEDURE','HZ_PARTY_INFO_CRMHK.UPDATE_CREDIT_RATINGS_POST');
1289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1290: FND_MSG_PUB.ADD;
1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1292: END IF;
1293: END IF;
1294: */
1295:

Line 1339: l_financial_profile_id = FND_API.G_MISS_NUM THEN

1335: BEGIN
1336: -- if financial_profile_id is NULL, then generate PK.
1337:
1338: IF l_financial_profile_id is NULL OR
1339: l_financial_profile_id = FND_API.G_MISS_NUM THEN
1340:
1341: l_count := 1;
1342: WHILE l_count > 0 LOOP
1343: SELECT hz_financial_profile_s.nextval

Line 1362: RAISE FND_API.G_EXC_ERROR;

1358: if l_count > 0 then
1359: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1360: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_profile_id');
1361: FND_MSG_PUB.ADD;
1362: RAISE FND_API.G_EXC_ERROR;
1363: end if;
1364:
1365: END IF;
1366:

Line 1374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1370:
1371: HZ_PARTY_INFO_VAL.validate_financial_profile(p_financial_profile_rec,'C',
1372: x_return_status);
1373:
1374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1375: RAISE FND_API.G_EXC_ERROR;
1376: END IF;
1377:
1378: -- Bug 1428526: Should pass updated financial profile info. to caller.

Line 1375: RAISE FND_API.G_EXC_ERROR;

1371: HZ_PARTY_INFO_VAL.validate_financial_profile(p_financial_profile_rec,'C',
1372: x_return_status);
1373:
1374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1375: RAISE FND_API.G_EXC_ERROR;
1376: END IF;
1377:
1378: -- Bug 1428526: Should pass updated financial profile info. to caller.
1379: -- Make sure to use values in p_financial_profile_rec.* when calling insert table

Line 1449: p_financial_profile_rec.financial_profile_id = FND_API.G_MISS_NUM THEN

1445: l_last_update_date DATE;
1446: BEGIN
1447: -- check required fields:
1448: IF p_financial_profile_rec.financial_profile_id is NULL OR
1449: p_financial_profile_rec.financial_profile_id = FND_API.G_MISS_NUM THEN
1450:
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1452: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_profile_id');
1453: FND_MSG_PUB.ADD;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450:
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1452: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_profile_id');
1453: FND_MSG_PUB.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455:
1456: END IF;
1457:
1458: IF p_last_update_date IS NULL OR

Line 1459: p_last_update_date = FND_API.G_MISS_DATE

1455:
1456: END IF;
1457:
1458: IF p_last_update_date IS NULL OR
1459: p_last_update_date = FND_API.G_MISS_DATE
1460: THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1462: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1463: FND_MSG_PUB.ADD;

Line 1464: RAISE FND_API.G_EXC_ERROR;

1460: THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1462: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1463: FND_MSG_PUB.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;
1466:
1467: begin
1468: -- check last update date.

Line 1481: RAISE FND_API.G_EXC_ERROR;

1477: EXCEPTION WHEN NO_DATA_FOUND THEN
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1479: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_PROFILE');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: end;
1483: -- validate credit rating record
1484: HZ_PARTY_INFO_VAL.validate_financial_profile(p_financial_profile_rec,'U',
1485: x_return_status);

Line 1487: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1483: -- validate credit rating record
1484: HZ_PARTY_INFO_VAL.validate_financial_profile(p_financial_profile_rec,'U',
1485: x_return_status);
1486:
1487: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;
1490:
1491: -- pass back the last update date

Line 1488: RAISE FND_API.G_EXC_ERROR;

1484: HZ_PARTY_INFO_VAL.validate_financial_profile(p_financial_profile_rec,'U',
1485: x_return_status);
1486:
1487: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;
1490:
1491: -- pass back the last update date
1492: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

Line 1510: X_CREATED_BY => FND_API.G_MISS_NUM,

1506: X_FINANCIAL_ACCOUNT_NUMBER => p_financial_profile_rec.FINANCIAL_ACCOUNT_NUMBER,
1507: X_FINANCIAL_ACCOUNT_TYPE => p_financial_profile_rec.FINANCIAL_ACCOUNT_TYPE,
1508: X_FINANCIAL_ORG_TYPE => p_financial_profile_rec.FINANCIAL_ORG_TYPE,
1509: X_FINANCIAL_ORGANIZATION_NAME => p_financial_profile_rec.FINANCIAL_ORGANIZATION_NAME,
1510: X_CREATED_BY => FND_API.G_MISS_NUM,
1511: X_CREATION_DATE => FND_API.G_MISS_DATE,
1512: X_PARTY_ID => p_financial_profile_rec.PARTY_ID,
1513: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1514: X_LAST_UPDATE_DATE => p_last_update_date,

Line 1511: X_CREATION_DATE => FND_API.G_MISS_DATE,

1507: X_FINANCIAL_ACCOUNT_TYPE => p_financial_profile_rec.FINANCIAL_ACCOUNT_TYPE,
1508: X_FINANCIAL_ORG_TYPE => p_financial_profile_rec.FINANCIAL_ORG_TYPE,
1509: X_FINANCIAL_ORGANIZATION_NAME => p_financial_profile_rec.FINANCIAL_ORGANIZATION_NAME,
1510: X_CREATED_BY => FND_API.G_MISS_NUM,
1511: X_CREATION_DATE => FND_API.G_MISS_DATE,
1512: X_PARTY_ID => p_financial_profile_rec.PARTY_ID,
1513: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1514: X_LAST_UPDATE_DATE => p_last_update_date,
1515: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

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

1525:
1526:
1527: procedure get_current_credit_rating(
1528: p_api_version IN NUMBER,
1529: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1530: p_credit_rating_id IN NUMBER,
1531: x_credit_ratings_rec OUT NOCOPY CREDIT_RATINGS_REC_TYPE,
1532: x_return_status IN OUT NOCOPY VARCHAR2,
1533: x_msg_count OUT NOCOPY NUMBER,

Line 1542: IF NOT FND_API.Compatible_API_Call(

1538:
1539: BEGIN
1540:
1541: --Standard call to check for call compatibility.
1542: IF NOT FND_API.Compatible_API_Call(
1543: l_api_version,
1544: p_api_version,
1545: l_api_name,
1546: G_PKG_NAME)

Line 1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1544: p_api_version,
1545: l_api_name,
1546: G_PKG_NAME)
1547: THEN
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: END IF;
1550:
1551: --Initialize message list if p_init_msg_list is set to TRUE.
1552: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1552: IF FND_API.to_Boolean(p_init_msg_list) THEN

1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: END IF;
1550:
1551: --Initialize message list if p_init_msg_list is set to TRUE.
1552: IF FND_API.to_Boolean(p_init_msg_list) THEN
1553: FND_MSG_PUB.initialize;
1554: END IF;
1555:
1556: --Initialize API return status to success.

Line 1557: x_return_status := FND_API.G_RET_STS_SUCCESS;

1553: FND_MSG_PUB.initialize;
1554: END IF;
1555:
1556: --Initialize API return status to success.
1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:
1559: --Check whether primary key has been passed in.
1560: IF p_credit_rating_id IS NULL OR
1561: p_credit_rating_id = FND_API.G_MISS_NUM THEN

Line 1561: p_credit_rating_id = FND_API.G_MISS_NUM THEN

1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:
1559: --Check whether primary key has been passed in.
1560: IF p_credit_rating_id IS NULL OR
1561: p_credit_rating_id = FND_API.G_MISS_NUM THEN
1562:
1563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1564: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
1565: FND_MSG_PUB.ADD;

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562:
1563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1564: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
1565: FND_MSG_PUB.ADD;
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:
1569: BEGIN /* Just for select statement */
1570:

Line 1779: RAISE FND_API.G_EXC_ERROR;

1775: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1776: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
1777: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_rating_id));
1778: FND_MSG_PUB.ADD;
1779: RAISE FND_API.G_EXC_ERROR;
1780: END;
1781: --Standard call to get message count and if count is 1, get message info.
1782: FND_MSG_PUB.Count_And_Get(
1783: p_encoded => FND_API.G_FALSE,

Line 1783: p_encoded => FND_API.G_FALSE,

1779: RAISE FND_API.G_EXC_ERROR;
1780: END;
1781: --Standard call to get message count and if count is 1, get message info.
1782: FND_MSG_PUB.Count_And_Get(
1783: p_encoded => FND_API.G_FALSE,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: EXCEPTION

Line 1788: WHEN FND_API.G_EXC_ERROR THEN

1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: FND_MSG_PUB.Count_And_Get(
1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,

Line 1789: x_return_status := FND_API.G_RET_STS_ERROR;

1785: p_data => x_msg_data);
1786:
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: FND_MSG_PUB.Count_And_Get(
1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data);

Line 1791: p_encoded => FND_API.G_FALSE,

1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: FND_MSG_PUB.Count_And_Get(
1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,

Line 1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1792: p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);

Line 1798: p_encoded => FND_API.G_FALSE,

1794:
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: WHEN OTHERS THEN
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: WHEN OTHERS THEN
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803:
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1806: FND_MSG_PUB.ADD;

Line 1809: p_encoded => FND_API.G_FALSE,

1805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1806: FND_MSG_PUB.ADD;
1807:
1808: FND_MSG_PUB.Count_And_Get(
1809: p_encoded => FND_API.G_FALSE,
1810: p_count => x_msg_count,
1811: p_data => x_msg_data);
1812:
1813: END get_current_credit_rating;