DBA Data[Home] [Help]

APPS.JTS_CONFIGURATION_PVT dependencies on FND_MSG_PUB

Line 229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227:
228: IF (NOT CHECK_CONFIG_NAME_UNIQUE(p_configuration_rec.config_name, p_configuration_rec.configuration_id)) THEN
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
230: fnd_message.set_name('JTS', 'JTS_CONFIG_NAME_EXISTS');
231: fnd_msg_pub.add;
232: END IF;
233: x_return_status := fnd_api.g_ret_sts_error;

Line 231: fnd_msg_pub.add;

227:
228: IF (NOT CHECK_CONFIG_NAME_UNIQUE(p_configuration_rec.config_name, p_configuration_rec.configuration_id)) THEN
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
230: fnd_message.set_name('JTS', 'JTS_CONFIG_NAME_EXISTS');
231: fnd_msg_pub.add;
232: END IF;
233: x_return_status := fnd_api.g_ret_sts_error;
234: END IF;
235:

Line 243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');

239:
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: END VALIDATE_ROW;
250:

Line 247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name || ': flow_id not found');
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: END VALIDATE_ROW;
250:
251: -----------------------------------------------------------

Line 280: fnd_msg_pub.initialize;

276:
277: -- Standard Start of API savepoint
278: SAVEPOINT create_configuration;
279:
280: fnd_msg_pub.initialize;
281:
282: IF NOT fnd_api.compatible_api_call ( l_api_version,
283: p_api_version,
284: l_api_name,

Line 322: fnd_msg_pub.count_and_get (

318: raise fnd_api.g_exc_unexpected_error;
319: END IF;
320: END IF;
321:
322: fnd_msg_pub.count_and_get (
323: p_encoded=> fnd_api.g_false
324: ,p_count=> x_msg_count
325: ,p_data=> x_msg_data
326: );

Line 333: FND_MSG_PUB.Count_And_Get (

329: WHEN FND_API.G_EXC_ERROR THEN
330: ROLLBACK TO create_configuration;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );

Line 341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

337: );
338: WHEN OTHERS THEN
339: ROLLBACK TO create_configuration;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
343: END IF;
344: -- Standard call to get message count and if count=1, get the message
345: FND_MSG_PUB.Count_And_Get (

Line 342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

338: WHEN OTHERS THEN
339: ROLLBACK TO create_configuration;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
343: END IF;
344: -- Standard call to get message count and if count=1, get the message
345: FND_MSG_PUB.Count_And_Get (
346: p_encoded => FND_API.G_FALSE,

Line 345: FND_MSG_PUB.Count_And_Get (

341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
343: END IF;
344: -- Standard call to get message count and if count=1, get the message
345: FND_MSG_PUB.Count_And_Get (
346: p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );

Line 379: Fnd_msg_pub.initialize;

375:
376: -- Standard Start of API savepoint
377: SAVEPOINT update_name_and_desc;
378:
379: Fnd_msg_pub.initialize;
380:
381: IF NOT fnd_api.compatible_api_call ( l_api_version,
382: p_api_version,
383: l_api_name,

Line 419: FND_MSG_PUB.Count_And_Get (

415: AND USERENV('LANG') IN (language, source_lang);
416: COMMIT;
417: END IF;
418:
419: FND_MSG_PUB.Count_And_Get (
420: p_encoded => FND_API.G_FALSE,
421: p_count => x_msg_count,
422: p_data => x_msg_data
423: );

Line 429: FND_MSG_PUB.Count_And_Get (

425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_name_and_desc;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );

Line 437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

433: );
434: WHEN OTHERS THEN
435: ROLLBACK TO update_name_and_desc;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
439: END IF;
440: -- Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (

Line 438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

434: WHEN OTHERS THEN
435: ROLLBACK TO update_name_and_desc;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
439: END IF;
440: -- Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,

Line 441: FND_MSG_PUB.Count_And_Get (

437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
439: END IF;
440: -- Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );

Line 466: fnd_msg_pub.initialize;

462:
463: -- Standard Start of API savepoint
464: SAVEPOINT delete_configuration;
465:
466: fnd_msg_pub.initialize;
467:
468: IF NOT fnd_api.compatible_api_call ( l_api_version,
469: p_api_version,
470: l_api_name,

Line 482: FND_MSG_PUB.Count_And_Get (

478: p_config_id);
479: JTS_CONFIGURATIONS_PKG.DELETE_ROW(p_config_id);
480: Commit;
481:
482: FND_MSG_PUB.Count_And_Get (
483: p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data
486: );

Line 491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

487: EXCEPTION
488: WHEN OTHERS THEN
489: ROLLBACK TO delete_configuration;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (

Line 492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

488: WHEN OTHERS THEN
489: ROLLBACK TO delete_configuration;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,

Line 495: FND_MSG_PUB.Count_And_Get (

491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );

Line 520: fnd_msg_pub.initialize;

516: BEGIN
517: x_return_status := fnd_api.G_RET_STS_SUCCESS;
518:
519: IF (FND_API.to_boolean(p_init_msg_list)) THEN
520: fnd_msg_pub.initialize;
521: END IF;
522:
523: IF NOT fnd_api.compatible_api_call ( l_api_version,
524: p_api_version,

Line 555: FND_MSG_PUB.Count_And_Get (

551: AND lf.lookup_code = fl.flow_type
552: AND u1.user_id (+) = c.created_by
553: AND u2.user_id (+) = c.last_updated_by;
554:
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count,
558: p_data => x_msg_data
559: );

Line 564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (

Line 565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

561: EXCEPTION
562: WHEN OTHERS THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,

Line 568: FND_MSG_PUB.Count_And_Get (

564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 601: fnd_msg_pub.initialize;

597: BEGIN
598:
599: x_return_status := fnd_api.G_RET_STS_SUCCESS;
600:
601: fnd_msg_pub.initialize;
602:
603: IF NOT fnd_api.compatible_api_call ( l_api_version,
604: p_api_version,
605: l_api_name,

Line 695: FND_MSG_PUB.Count_And_Get (

691: i := i + 1;
692: END LOOP;
693: CLOSE config_csr;
694:
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
699: );

Line 704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (

Line 705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,

Line 708: FND_MSG_PUB.Count_And_Get (

704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data
712: );