DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on FND_MSG_PUB

Line 18: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

14: -- 31-jan-2002 soagrawa Modified signature to take used_by as well
15: -- so that events team could use it too
16: -- This is related to fix for bug# 2207286
17: --========================================================================
18: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22:

Line 19: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

15: -- so that events team could use it too
16: -- This is related to fix for bug# 2207286
17: --========================================================================
18: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22:
23:

Line 20: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

16: -- This is related to fix for bug# 2207286
17: --========================================================================
18: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22:
23:
24: FUNCTION Target_Group_Exist (p_schedule_id IN NUMBER --)

Line 295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

291: END LOOP;
292: CLOSE C_Content_CL;
293:
294: If l_status_code = fnd_api.g_ret_sts_error THEN
295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
296: THEN
297: FND_MESSAGE.set_name('AMS', 'AMS_COVER_LETTER_APPRV_MSG');
298: FND_MESSAGE.Set_Token('COVER_LETTER_NAME',l_content_name);
299: FND_MSG_PUB.add;

Line 299: FND_MSG_PUB.add;

295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
296: THEN
297: FND_MESSAGE.set_name('AMS', 'AMS_COVER_LETTER_APPRV_MSG');
298: FND_MESSAGE.Set_Token('COVER_LETTER_NAME',l_content_name);
299: FND_MSG_PUB.add;
300: END IF;
301:
302: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
303: p_data => x_msg_data,

Line 302: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,

298: FND_MESSAGE.Set_Token('COVER_LETTER_NAME',l_content_name);
299: FND_MSG_PUB.add;
300: END IF;
301:
302: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
303: p_data => x_msg_data,
304: p_encoded => FND_API.G_FALSE
305: );
306: END IF;

Line 334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

330: END LOOP;
331: CLOSE C_Content_CL;
332:
333: If l_status_code = fnd_api.g_ret_sts_error THEN
334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
335: THEN
336: FND_MESSAGE.set_name('AMS', 'AMS_COLLATEARL_CONTENT_APRVMSG');
337: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text_dm);
338: FND_MSG_PUB.add;

Line 338: FND_MSG_PUB.add;

334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
335: THEN
336: FND_MESSAGE.set_name('AMS', 'AMS_COLLATEARL_CONTENT_APRVMSG');
337: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text_dm);
338: FND_MSG_PUB.add;
339: END IF;
340:
341: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
342: p_data => x_msg_data,

Line 341: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,

337: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text_dm);
338: FND_MSG_PUB.add;
339: END IF;
340:
341: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
342: p_data => x_msg_data,
343: p_encoded => FND_API.G_FALSE
344: );
345: END IF;

Line 355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

351: ELSIF (l_activity_id <> 460 ) THEN --kbasavar skip the validation for telemarketing
352:
353: l_status_code := fnd_api.g_ret_sts_error;
354:
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
356: THEN
357: FND_MESSAGE.set_name('AMS', 'AMS_COLLAT_CONTENT_NOT_EXISTS');
358: FND_MSG_PUB.add;
359: END IF;

Line 358: FND_MSG_PUB.add;

354:
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
356: THEN
357: FND_MESSAGE.set_name('AMS', 'AMS_COLLAT_CONTENT_NOT_EXISTS');
358: FND_MSG_PUB.add;
359: END IF;
360:
361: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
362: p_data => x_msg_data,

Line 361: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,

357: FND_MESSAGE.set_name('AMS', 'AMS_COLLAT_CONTENT_NOT_EXISTS');
358: FND_MSG_PUB.add;
359: END IF;
360:
361: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
362: p_data => x_msg_data,
363: p_encoded => FND_API.G_FALSE);
364:
365: END IF;--IF (l_content_exists = 'Y') THEN

Line 390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

386: END LOOP;
387: CLOSE C_Content_NDM;
388:
389: If l_status_code = fnd_api.g_ret_sts_error THEN
390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
391: THEN
392: FND_MESSAGE.set_name('AMS', 'AMS_COLLATEARL_CONTENT_APRVMSG');
393: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text);
394: FND_MSG_PUB.add;

Line 394: FND_MSG_PUB.add;

390: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
391: THEN
392: FND_MESSAGE.set_name('AMS', 'AMS_COLLATEARL_CONTENT_APRVMSG');
393: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text);
394: FND_MSG_PUB.add;
395: END IF;
396:
397: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
398: p_data => x_msg_data,

Line 397: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,

393: FND_MESSAGE.Set_Token('COLLATERAL_CONTENT_NAMES', l_content_name_text);
394: FND_MSG_PUB.add;
395: END IF;
396:
397: FND_MSG_PUB.Count_AND_Get( p_count => x_msg_count,
398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE
400: );
401: END IF;

Line 702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

698: OPEN c_schedule;
699: FETCH c_schedule INTO l_camp_id, l_source_code, l_cascade_flag ;
700: IF c_schedule%NOTFOUND THEN
701: CLOSE c_schedule;
702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
703: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
704: FND_MSG_PUB.add;
705: END IF;
706: RAISE FND_API.g_exc_error;

Line 704: FND_MSG_PUB.add;

700: IF c_schedule%NOTFOUND THEN
701: CLOSE c_schedule;
702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
703: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
704: FND_MSG_PUB.add;
705: END IF;
706: RAISE FND_API.g_exc_error;
707: END IF;
708: CLOSE c_schedule;

Line 863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

859: OPEN c_schedule;
860: FETCH c_schedule INTO l_camp_id, l_source_code, l_cascade_flag;
861: IF c_schedule%NOTFOUND THEN
862: CLOSE c_schedule;
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
864: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
865: FND_MSG_PUB.add;
866: END IF;
867: RAISE FND_API.g_exc_error;

Line 865: FND_MSG_PUB.add;

861: IF c_schedule%NOTFOUND THEN
862: CLOSE c_schedule;
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
864: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
865: FND_MSG_PUB.add;
866: END IF;
867: RAISE FND_API.g_exc_error;
868: RETURN;
869: END IF;

Line 1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1285: OPEN c_schedule;
1286: FETCH c_schedule INTO l_schedule_rec;
1287: IF c_schedule%NOTFOUND THEN
1288: CLOSE c_schedule;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1290: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1291: FND_MSG_PUB.add;
1292: END IF;
1293: RAISE FND_API.g_exc_error;

Line 1291: FND_MSG_PUB.add;

1287: IF c_schedule%NOTFOUND THEN
1288: CLOSE c_schedule;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1290: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1291: FND_MSG_PUB.add;
1292: END IF;
1293: RAISE FND_API.g_exc_error;
1294: END IF;
1295: CLOSE c_schedule;

Line 1559: FND_MSG_PUB.initialize;

1555: --
1556: -- Initialize message list IF p_init_msg_list is set to TRUE.
1557: --
1558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1559: FND_MSG_PUB.initialize;
1560: END IF;
1561:
1562: --
1563: -- Standard call to check for call compatibility.

Line 1628: FND_MSG_PUB.Count_AND_Get

1624:
1625: --
1626: -- Standard call to get message count AND IF count is 1, get message info.
1627: --
1628: FND_MSG_PUB.Count_AND_Get
1629: ( p_count => x_msg_count,
1630: p_data => x_msg_data,
1631: p_encoded => FND_API.G_FALSE
1632: );

Line 1650: FND_MSG_PUB.Count_AND_Get

1646:
1647: ROLLBACK TO Update_List_Header;
1648: x_return_status := FND_API.G_RET_STS_ERROR ;
1649:
1650: FND_MSG_PUB.Count_AND_Get
1651: ( p_count => x_msg_count,
1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE
1654: );

Line 1661: FND_MSG_PUB.Count_AND_Get

1657:
1658: ROLLBACK TO Update_List_Header;
1659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1660:
1661: FND_MSG_PUB.Count_AND_Get
1662: ( p_count => x_msg_count,
1663: p_data => x_msg_data,
1664: p_encoded => FND_API.G_FALSE
1665: );

Line 1672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1668:
1669: ROLLBACK TO Update_List_Header;
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1671:
1672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1673: THEN
1674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1675: END IF;
1676:

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

1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1671:
1672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1673: THEN
1674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1675: END IF;
1676:
1677: FND_MSG_PUB.Count_AND_Get
1678: ( p_count => x_msg_count,

Line 1677: FND_MSG_PUB.Count_AND_Get

1673: THEN
1674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1675: END IF;
1676:
1677: FND_MSG_PUB.Count_AND_Get
1678: ( p_count => x_msg_count,
1679: p_data => x_msg_data,
1680: p_encoded => FND_API.G_FALSE
1681: );

Line 1755: FND_MSG_PUB.initialize;

1751: --
1752: -- Initialize message list IF p_init_msg_list is set to TRUE.
1753: --
1754: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1755: FND_MSG_PUB.initialize;
1756: END IF;
1757:
1758: --
1759: -- Standard call to check for call compatibility.

Line 1817: FND_MSG_PUB.Count_AND_Get

1813:
1814: --
1815: -- Standard call to get message count AND IF count is 1, get message info.
1816: --
1817: FND_MSG_PUB.Count_AND_Get
1818: ( p_count => x_msg_count,
1819: p_data => x_msg_data,
1820: p_encoded => FND_API.G_FALSE
1821: );

Line 1842: FND_MSG_PUB.Count_AND_Get

1838: END IF;
1839: ROLLBACK TO AMS_COMPLETE_SCHEDULE;
1840: x_return_status := FND_API.G_RET_STS_ERROR ;
1841:
1842: FND_MSG_PUB.Count_AND_Get
1843: ( p_count => x_msg_count,
1844: p_data => x_msg_data,
1845: p_encoded => FND_API.G_FALSE
1846: );

Line 1855: FND_MSG_PUB.Count_AND_Get

1851: END IF;
1852: ROLLBACK TO AMS_COMPLETE_SCHEDULE;
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854:
1855: FND_MSG_PUB.Count_AND_Get
1856: ( p_count => x_msg_count,
1857: p_data => x_msg_data,
1858: p_encoded => FND_API.G_FALSE
1859: );

Line 1868: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1864: END IF;
1865: ROLLBACK TO AMS_COMPLETE_SCHEDULE;
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1867:
1868: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1869: THEN
1870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1871: END IF;
1872:

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

1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1867:
1868: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1869: THEN
1870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1871: END IF;
1872:
1873: FND_MSG_PUB.Count_AND_Get
1874: ( p_count => x_msg_count,

Line 1873: FND_MSG_PUB.Count_AND_Get

1869: THEN
1870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1871: END IF;
1872:
1873: FND_MSG_PUB.Count_AND_Get
1874: ( p_count => x_msg_count,
1875: p_data => x_msg_data,
1876: p_encoded => FND_API.G_FALSE
1877: );

Line 1905: FND_MSG_PUB.initialize;

1901: l_msg_count NUMBER ;
1902: l_msg_data VARCHAR2(2000);
1903: l_api_version NUMBER := 1.0 ;
1904: BEGIN
1905: FND_MSG_PUB.initialize;
1906:
1907: Complete_Schedule(
1908: p_api_version => l_api_version ,
1909:

Line 3403: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,

3399: );
3400:
3401: WHILE l_cnt < p_msg_count
3402: LOOP
3403: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,
3404: p_encoded => FND_API.G_FALSE,
3405: p_data => l_msg_data,
3406: p_msg_index_out => l_msg_index ) ;
3407: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);