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.AMS_WEB_TRACK_PVT dependencies on FND_MSG_PUB

Line 127: FND_MSG_PUB.initialize;

123: --insert_log_mesg('Standard call to check for call compatibility');
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean( p_init_msg_list )
126: THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130:
131:

Line 252: FND_MSG_PUB.Count_And_Get

248: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
249:
250:
251: -- Standard call to get message count and if count is 1, get message info.
252: FND_MSG_PUB.Count_And_Get
253: (p_count => x_msg_count,
254: p_data => x_msg_data
255: );
256: EXCEPTION

Line 267: FND_MSG_PUB.Count_And_Get (

263: WHEN FND_API.G_EXC_ERROR THEN
264: ROLLBACK TO create_web_track_pvt;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );

Line 278: FND_MSG_PUB.Count_And_Get (

274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO create_web_track_pvt;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );

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

283:
284: WHEN OTHERS THEN
285: ROLLBACK TO create_web_track_pvt;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
290: END IF;
291: -- Standard call to get message count and if count=1, get the message

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

285: ROLLBACK TO create_web_track_pvt;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
290: END IF;
291: -- Standard call to get message count and if count=1, get the message
292: FND_MSG_PUB.Count_And_Get (
293: p_encoded => FND_API.G_FALSE,

Line 292: FND_MSG_PUB.Count_And_Get (

288: THEN
289: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
290: END IF;
291: -- Standard call to get message count and if count=1, get the message
292: FND_MSG_PUB.Count_And_Get (
293: p_encoded => FND_API.G_FALSE,
294: p_count => x_msg_count,
295: p_data => x_msg_data
296: );

Line 383: FND_MSG_PUB.initialize;

379:
380: -- Initialize message list if p_init_msg_list is set to TRUE.
381: IF FND_API.to_Boolean( p_init_msg_list )
382: THEN
383: FND_MSG_PUB.initialize;
384: END IF;
385:
386:
387:

Line 454: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

450: END IF;
451:
452:
453: -- Debug Message
454: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
455:
456: -- Invoke table handler(Ams_Web_Track_Pkg.Update_Row)
457: Ams_Web_Track_Pkg.Update_Row(
458: p_web_tracking_id => p_web_track_rec.web_tracking_id,

Line 500: FND_MSG_PUB.Count_And_Get

496: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
497:
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get
501: (p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504: EXCEPTION

Line 514: FND_MSG_PUB.Count_And_Get (

510: WHEN FND_API.G_EXC_ERROR THEN
511: ROLLBACK TO UPDATE_Web_Track_PVT;
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: -- Standard call to get message count and if count=1, get the message
514: FND_MSG_PUB.Count_And_Get (
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data
518: );

Line 524: FND_MSG_PUB.Count_And_Get (

520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO UPDATE_Web_Track_PVT;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: -- Standard call to get message count and if count=1, get the message
524: FND_MSG_PUB.Count_And_Get (
525: p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => x_msg_data
528: );

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

529:
530: WHEN OTHERS THEN
531: ROLLBACK TO UPDATE_Web_Track_PVT;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
536: END IF;
537: -- Standard call to get message count and if count=1, get the message

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

531: ROLLBACK TO UPDATE_Web_Track_PVT;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
536: END IF;
537: -- Standard call to get message count and if count=1, get the message
538: FND_MSG_PUB.Count_And_Get (
539: p_encoded => FND_API.G_FALSE,

Line 538: FND_MSG_PUB.Count_And_Get (

534: THEN
535: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
536: END IF;
537: -- Standard call to get message count and if count=1, get the message
538: FND_MSG_PUB.Count_And_Get (
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_msg_count,
541: p_data => x_msg_data
542: );

Line 614: FND_MSG_PUB.initialize;

610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616:
617:
618:

Line 653: FND_MSG_PUB.Count_And_Get

649: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
650:
651:
652: -- Standard call to get message count and if count is 1, get message info.
653: FND_MSG_PUB.Count_And_Get
654: (p_count => x_msg_count,
655: p_data => x_msg_data
656: );
657: EXCEPTION

Line 667: FND_MSG_PUB.Count_And_Get (

663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO DELETE_Web_Track_PVT;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: );

Line 677: FND_MSG_PUB.Count_And_Get (

673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK TO DELETE_Web_Track_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );

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

682:
683: WHEN OTHERS THEN
684: ROLLBACK TO DELETE_Web_Track_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message

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

684: ROLLBACK TO DELETE_Web_Track_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,

Line 691: FND_MSG_PUB.Count_And_Get (

687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

Line 761: FND_MSG_PUB.initialize;

757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )
760: THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764:
765:

Line 786: FND_MSG_PUB.count_and_get(

782: Ams_Web_Track_Pkg.Lock_Row(l_web_tracking_id,p_object_version);
783:
784:
785: -------------------- finish --------------------------
786: FND_MSG_PUB.count_and_get(
787: p_encoded => FND_API.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 801: FND_MSG_PUB.Count_And_Get (

797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_Web_Track_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
805: );

Line 811: FND_MSG_PUB.Count_And_Get (

807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO LOCK_Web_Track_PVT;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );

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

816:
817: WHEN OTHERS THEN
818: ROLLBACK TO LOCK_Web_Track_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message

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

818: ROLLBACK TO LOCK_Web_Track_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,

Line 825: FND_MSG_PUB.Count_And_Get (

821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 1238: FND_MSG_PUB.initialize;

1234: --insert_log_mesg('Standard call to check for call');
1235: -- Initialize message list if p_init_msg_list is set to TRUE.
1236: IF FND_API.to_Boolean( p_init_msg_list )
1237: THEN
1238: FND_MSG_PUB.initialize;
1239: END IF;
1240: --insert_log_mesg('Private API: Validate_Web_Track');
1241:
1242: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1302: FND_MSG_PUB.Count_And_Get

1298: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1299:
1300:
1301: -- Standard call to get message count and if count is 1, get message info.
1302: FND_MSG_PUB.Count_And_Get
1303: (p_count => x_msg_count,
1304: p_data => x_msg_data
1305: );
1306: EXCEPTION

Line 1316: FND_MSG_PUB.Count_And_Get (

1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO VALIDATE_Web_Track_;
1314: x_return_status := FND_API.G_RET_STS_ERROR;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data
1320: );

Line 1326: FND_MSG_PUB.Count_And_Get (

1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO VALIDATE_Web_Track_;
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: -- Standard call to get message count and if count=1, get the message
1326: FND_MSG_PUB.Count_And_Get (
1327: p_encoded => FND_API.G_FALSE,
1328: p_count => x_msg_count,
1329: p_data => x_msg_data
1330: );

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

1331:
1332: WHEN OTHERS THEN
1333: ROLLBACK TO VALIDATE_Web_Track_;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1336: THEN
1337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1338: END IF;
1339: -- Standard call to get message count and if count=1, get the message

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

1333: ROLLBACK TO VALIDATE_Web_Track_;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1336: THEN
1337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1338: END IF;
1339: -- Standard call to get message count and if count=1, get the message
1340: FND_MSG_PUB.Count_And_Get (
1341: p_encoded => FND_API.G_FALSE,

Line 1340: FND_MSG_PUB.Count_And_Get (

1336: THEN
1337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1338: END IF;
1339: -- Standard call to get message count and if count=1, get the message
1340: FND_MSG_PUB.Count_And_Get (
1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );

Line 1361: FND_MSG_PUB.initialize;

1357: BEGIN
1358: -- Initialize message list if p_init_msg_list is set to TRUE.
1359: IF FND_API.to_Boolean( p_init_msg_list )
1360: THEN
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363:
1364:
1365:

Line 1377: FND_MSG_PUB.Count_And_Get

1373:
1374: -- Debug Message
1375: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1376: -- Standard call to get message count and if count is 1, get message info.
1377: FND_MSG_PUB.Count_And_Get
1378: (p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );
1381: END Validate_web_track_Rec;

Line 1472: FND_MSG_PUB.initialize;

1468:
1469: -- Initialize message list if p_init_msg_list is set to TRUE.
1470: IF FND_API.to_Boolean( p_init_msg_list )
1471: THEN
1472: FND_MSG_PUB.initialize;
1473: END IF;
1474:
1475:
1476:

Line 1592: FND_MSG_PUB.Count_And_Get

1588: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1589:
1590:
1591: -- Standard call to get message count and if count is 1, get message info.
1592: FND_MSG_PUB.Count_And_Get
1593: (p_count => x_msg_count,
1594: p_data => x_msg_data
1595: );
1596: EXCEPTION

Line 1606: FND_MSG_PUB.Count_And_Get (

1602: WHEN FND_API.G_EXC_ERROR THEN
1603: ROLLBACK TO CREATE_Web_Recomms_PVT;
1604: x_return_status := FND_API.G_RET_STS_ERROR;
1605: -- Standard call to get message count and if count=1, get the message
1606: FND_MSG_PUB.Count_And_Get (
1607: p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data
1610: );

Line 1616: FND_MSG_PUB.Count_And_Get (

1612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1613: ROLLBACK TO CREATE_Web_Recomms_PVT;
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (
1617: p_encoded => FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data
1620: );

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

1621:
1622: WHEN OTHERS THEN
1623: ROLLBACK TO CREATE_Web_Recomms_PVT;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1626: THEN
1627: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1628: END IF;
1629: -- Standard call to get message count and if count=1, get the message

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

1623: ROLLBACK TO CREATE_Web_Recomms_PVT;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1626: THEN
1627: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1628: END IF;
1629: -- Standard call to get message count and if count=1, get the message
1630: FND_MSG_PUB.Count_And_Get (
1631: p_encoded => FND_API.G_FALSE,

Line 1630: FND_MSG_PUB.Count_And_Get (

1626: THEN
1627: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1628: END IF;
1629: -- Standard call to get message count and if count=1, get the message
1630: FND_MSG_PUB.Count_And_Get (
1631: p_encoded => FND_API.G_FALSE,
1632: p_count => x_msg_count,
1633: p_data => x_msg_data
1634: );

Line 1720: FND_MSG_PUB.initialize;

1716:
1717: -- Initialize message list if p_init_msg_list is set to TRUE.
1718: IF FND_API.to_Boolean( p_init_msg_list )
1719: THEN
1720: FND_MSG_PUB.initialize;
1721: END IF;
1722:
1723:
1724:

Line 1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

1786: END IF;
1787:
1788:
1789: -- Debug Message
1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
1791:
1792: -- Invoke table handler(Ams_Web_Recomms_Pkg.Update_Row)
1793: Ams_Web_Recomms_Pkg.Update_Row(
1794: p_web_recomm_id => p_web_recomms_rec.web_recomm_id,

Line 1838: FND_MSG_PUB.Count_And_Get

1834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1835:
1836:
1837: -- Standard call to get message count and if count is 1, get message info.
1838: FND_MSG_PUB.Count_And_Get
1839: (p_count => x_msg_count,
1840: p_data => x_msg_data
1841: );
1842: EXCEPTION

Line 1852: FND_MSG_PUB.Count_And_Get (

1848: WHEN FND_API.G_EXC_ERROR THEN
1849: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: -- Standard call to get message count and if count=1, get the message
1852: FND_MSG_PUB.Count_And_Get (
1853: p_encoded => FND_API.G_FALSE,
1854: p_count => x_msg_count,
1855: p_data => x_msg_data
1856: );

Line 1862: FND_MSG_PUB.Count_And_Get (

1858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1859: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: FND_MSG_PUB.Count_And_Get (
1863: p_encoded => FND_API.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data
1866: );

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

1867:
1868: WHEN OTHERS THEN
1869: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1874: END IF;
1875: -- Standard call to get message count and if count=1, get the message

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

1869: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1874: END IF;
1875: -- Standard call to get message count and if count=1, get the message
1876: FND_MSG_PUB.Count_And_Get (
1877: p_encoded => FND_API.G_FALSE,

Line 1876: FND_MSG_PUB.Count_And_Get (

1872: THEN
1873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1874: END IF;
1875: -- Standard call to get message count and if count=1, get the message
1876: FND_MSG_PUB.Count_And_Get (
1877: p_encoded => FND_API.G_FALSE,
1878: p_count => x_msg_count,
1879: p_data => x_msg_data
1880: );

Line 1952: FND_MSG_PUB.initialize;

1948:
1949: -- Initialize message list if p_init_msg_list is set to TRUE.
1950: IF FND_API.to_Boolean( p_init_msg_list )
1951: THEN
1952: FND_MSG_PUB.initialize;
1953: END IF;
1954:
1955:
1956:

Line 1991: FND_MSG_PUB.Count_And_Get

1987: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1988:
1989:
1990: -- Standard call to get message count and if count is 1, get message info.
1991: FND_MSG_PUB.Count_And_Get
1992: (p_count => x_msg_count,
1993: p_data => x_msg_data
1994: );
1995: EXCEPTION

Line 2005: FND_MSG_PUB.Count_And_Get (

2001: WHEN FND_API.G_EXC_ERROR THEN
2002: ROLLBACK TO DELETE_Web_Recomms_PVT;
2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004: -- Standard call to get message count and if count=1, get the message
2005: FND_MSG_PUB.Count_And_Get (
2006: p_encoded => FND_API.G_FALSE,
2007: p_count => x_msg_count,
2008: p_data => x_msg_data
2009: );

Line 2015: FND_MSG_PUB.Count_And_Get (

2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO DELETE_Web_Recomms_PVT;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: -- Standard call to get message count and if count=1, get the message
2015: FND_MSG_PUB.Count_And_Get (
2016: p_encoded => FND_API.G_FALSE,
2017: p_count => x_msg_count,
2018: p_data => x_msg_data
2019: );

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

2020:
2021: WHEN OTHERS THEN
2022: ROLLBACK TO DELETE_Web_Recomms_PVT;
2023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2027: END IF;
2028: -- Standard call to get message count and if count=1, get the message

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

2022: ROLLBACK TO DELETE_Web_Recomms_PVT;
2023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2027: END IF;
2028: -- Standard call to get message count and if count=1, get the message
2029: FND_MSG_PUB.Count_And_Get (
2030: p_encoded => FND_API.G_FALSE,

Line 2029: FND_MSG_PUB.Count_And_Get (

2025: THEN
2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2027: END IF;
2028: -- Standard call to get message count and if count=1, get the message
2029: FND_MSG_PUB.Count_And_Get (
2030: p_encoded => FND_API.G_FALSE,
2031: p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );

Line 2099: FND_MSG_PUB.initialize;

2095:
2096: -- Initialize message list if p_init_msg_list is set to TRUE.
2097: IF FND_API.to_Boolean( p_init_msg_list )
2098: THEN
2099: FND_MSG_PUB.initialize;
2100: END IF;
2101:
2102:
2103:

Line 2124: FND_MSG_PUB.count_and_get(

2120: Ams_Web_Recomms_Pkg.Lock_Row(l_web_recomm_id,p_object_version);
2121:
2122:
2123: -------------------- finish --------------------------
2124: FND_MSG_PUB.count_and_get(
2125: p_encoded => FND_API.g_false,
2126: p_count => x_msg_count,
2127: p_data => x_msg_data);
2128: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 2139: FND_MSG_PUB.Count_And_Get (

2135: WHEN FND_API.G_EXC_ERROR THEN
2136: ROLLBACK TO LOCK_Web_Recomms_PVT;
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138: -- Standard call to get message count and if count=1, get the message
2139: FND_MSG_PUB.Count_And_Get (
2140: p_encoded => FND_API.G_FALSE,
2141: p_count => x_msg_count,
2142: p_data => x_msg_data
2143: );

Line 2149: FND_MSG_PUB.Count_And_Get (

2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146: ROLLBACK TO LOCK_Web_Recomms_PVT;
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2148: -- Standard call to get message count and if count=1, get the message
2149: FND_MSG_PUB.Count_And_Get (
2150: p_encoded => FND_API.G_FALSE,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data
2153: );

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

2154:
2155: WHEN OTHERS THEN
2156: ROLLBACK TO LOCK_Web_Recomms_PVT;
2157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2161: END IF;
2162: -- Standard call to get message count and if count=1, get the message

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

2156: ROLLBACK TO LOCK_Web_Recomms_PVT;
2157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2161: END IF;
2162: -- Standard call to get message count and if count=1, get the message
2163: FND_MSG_PUB.Count_And_Get (
2164: p_encoded => FND_API.G_FALSE,

Line 2163: FND_MSG_PUB.Count_And_Get (

2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2161: END IF;
2162: -- Standard call to get message count and if count=1, get the message
2163: FND_MSG_PUB.Count_And_Get (
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data
2167: );

Line 2545: FND_MSG_PUB.initialize;

2541:
2542: -- Initialize message list if p_init_msg_list is set to TRUE.
2543: IF FND_API.to_Boolean( p_init_msg_list )
2544: THEN
2545: FND_MSG_PUB.initialize;
2546: END IF;
2547:
2548:
2549: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 2605: FND_MSG_PUB.Count_And_Get

2601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2602:
2603:
2604: -- Standard call to get message count and if count is 1, get message info.
2605: FND_MSG_PUB.Count_And_Get
2606: (p_count => x_msg_count,
2607: p_data => x_msg_data
2608: );
2609: EXCEPTION

Line 2619: FND_MSG_PUB.Count_And_Get (

2615: WHEN FND_API.G_EXC_ERROR THEN
2616: ROLLBACK TO VALIDATE_Web_Recomms_;
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: -- Standard call to get message count and if count=1, get the message
2619: FND_MSG_PUB.Count_And_Get (
2620: p_encoded => FND_API.G_FALSE,
2621: p_count => x_msg_count,
2622: p_data => x_msg_data
2623: );

Line 2629: FND_MSG_PUB.Count_And_Get (

2625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2626: ROLLBACK TO VALIDATE_Web_Recomms_;
2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2628: -- Standard call to get message count and if count=1, get the message
2629: FND_MSG_PUB.Count_And_Get (
2630: p_encoded => FND_API.G_FALSE,
2631: p_count => x_msg_count,
2632: p_data => x_msg_data
2633: );

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

2634:
2635: WHEN OTHERS THEN
2636: ROLLBACK TO VALIDATE_Web_Recomms_;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message

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

2636: ROLLBACK TO VALIDATE_Web_Recomms_;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,

Line 2643: FND_MSG_PUB.Count_And_Get (

2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data
2647: );

Line 2664: FND_MSG_PUB.initialize;

2660: BEGIN
2661: -- Initialize message list if p_init_msg_list is set to TRUE.
2662: IF FND_API.to_Boolean( p_init_msg_list )
2663: THEN
2664: FND_MSG_PUB.initialize;
2665: END IF;
2666:
2667:
2668:

Line 2680: FND_MSG_PUB.Count_And_Get

2676:
2677: -- Debug Message
2678: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2679: -- Standard call to get message count and if count is 1, get message info.
2680: FND_MSG_PUB.Count_And_Get
2681: (p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2684: END Validate_web_recomms_Rec;

Line 2729: FND_MSG_PUB.initialize;

2725:
2726: -- Initialize message list if p_init_msg_list is set to TRUE.
2727: IF FND_API.to_Boolean( p_init_msg_list )
2728: THEN
2729: FND_MSG_PUB.initialize;
2730: END IF;
2731:
2732: -- Initialize API return status to SUCCESS
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2743: FND_MSG_PUB.Count_And_Get

2739:
2740: -- Debug Message
2741: AMS_UTILITY_PVT.debug_message('Private API: Create_Web_Imp_Track');
2742: -- Standard call to get message count and if count is 1, get message info.
2743: FND_MSG_PUB.Count_And_Get
2744: (p_count => x_msg_count,
2745: p_data => x_msg_data
2746: );
2747:

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

2779: --insert_log_mesg('l_web_tracking_id');
2780: --insert_log_mesg('Web Tracking Id ::::'||l_web_tracking_id);
2781:
2782: IF l_web_tracking_id IS NULL THEN
2783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2784: FND_MESSAGE.set_name('AMS', 'AMS_NO_PRIMARY_KEY');
2785: FND_MSG_PUB.add;
2786: END IF;
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2785: FND_MSG_PUB.add;

2781:
2782: IF l_web_tracking_id IS NULL THEN
2783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2784: FND_MESSAGE.set_name('AMS', 'AMS_NO_PRIMARY_KEY');
2785: FND_MSG_PUB.add;
2786: END IF;
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: END IF;
2789:

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

2866: -- dbms_output.put_line('before inserting into AMS_Web_Recomms web recomm id '|| l_web_recomm_id );
2867: --insert_log_mesg('Web Recomm Id ::::'||l_web_recomm_id);
2868:
2869: IF l_web_recomm_id IS NULL THEN
2870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2871: FND_MESSAGE.set_name('AMS', 'AMS_NO_PRIMARY_KEY');
2872: FND_MSG_PUB.add;
2873: END IF;
2874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2872: FND_MSG_PUB.add;

2868:
2869: IF l_web_recomm_id IS NULL THEN
2870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2871: FND_MESSAGE.set_name('AMS', 'AMS_NO_PRIMARY_KEY');
2872: FND_MSG_PUB.add;
2873: END IF;
2874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2875: END IF;
2876: x_impr_obj_id_rec(i).impr_track_id := l_web_recomm_id;

Line 2909: FND_MSG_PUB.Count_And_Get (

2905: WHEN FND_API.G_EXC_ERROR THEN
2906: ROLLBACK TO Create_Web_Imp_Track;
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: -- Standard call to get message count and if count=1, get the message
2909: FND_MSG_PUB.Count_And_Get (
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );

Line 2920: FND_MSG_PUB.Count_And_Get (

2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917: ROLLBACK TO Create_Web_Imp_Track;
2918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2919: -- Standard call to get message count and if count=1, get the message
2920: FND_MSG_PUB.Count_And_Get (
2921: p_encoded => FND_API.G_FALSE,
2922: p_count => x_msg_count,
2923: p_data => x_msg_data
2924: );

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

2926:
2927: WHEN OTHERS THEN
2928: ROLLBACK TO Create_Web_Imp_Track;
2929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2931: THEN
2932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2933: END IF;
2934: -- Standard call to get message count and if count=1, get the message

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

2928: ROLLBACK TO Create_Web_Imp_Track;
2929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2931: THEN
2932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2933: END IF;
2934: -- Standard call to get message count and if count=1, get the message
2935: FND_MSG_PUB.Count_And_Get (
2936: p_encoded => FND_API.G_FALSE,

Line 2935: FND_MSG_PUB.Count_And_Get (

2931: THEN
2932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2933: END IF;
2934: -- Standard call to get message count and if count=1, get the message
2935: FND_MSG_PUB.Count_And_Get (
2936: p_encoded => FND_API.G_FALSE,
2937: p_count => x_msg_count,
2938: p_data => x_msg_data
2939: );