DBA Data[Home] [Help]

APPS.FEM_PARTY_PROFITABILITY_PUB dependencies on FND_MSG_PUB

Line 103: FND_MSG_PUB.initialize;

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.
107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 125: FND_MSG_PUB.ADD;

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);
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: END IF;

Line 154: FND_MSG_PUB.ADD;

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);
154: FND_MSG_PUB.ADD;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: END IF;

Line 167: FND_MSG_PUB.Count_And_Get(

163: commit;
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:

Line 176: FND_MSG_PUB.Count_And_Get(

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);
180:

Line 184: FND_MSG_PUB.Count_And_Get(

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);
188:

Line 195: FND_MSG_PUB.ADD;

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;
196:
197: FND_MSG_PUB.Count_And_Get(
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,

Line 197: FND_MSG_PUB.Count_And_Get(

193: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
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:

Line 268: FND_MSG_PUB.initialize;

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.
272: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 302: FND_MSG_PUB.ADD;

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);
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: END IF;

Line 343: FND_MSG_PUB.ADD;

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);
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: END IF;

Line 361: FND_MSG_PUB.Count_And_Get(

357: commit;
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:

Line 370: FND_MSG_PUB.Count_And_Get(

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);
374:

Line 378: FND_MSG_PUB.Count_And_Get(

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);
382:

Line 389: FND_MSG_PUB.ADD;

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;
390:
391: FND_MSG_PUB.Count_And_Get(
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,

Line 391: FND_MSG_PUB.Count_And_Get(

387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
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:

Line 667: FND_MSG_PUB.ADD;

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;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: -------------------------------------------------------------

Line 682: FND_MSG_PUB.ADD;

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;
683: RAISE FND_API.G_EXC_ERROR;
684: END IF; */
685: ---------------------------------------------------------------
686:

Line 723: FND_MSG_PUB.ADD;

719:
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.

Line 874: FND_MSG_PUB.ADD;

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');
874: FND_MSG_PUB.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877:
878: END validate_profitability;