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_COMPETITOR_PRODUCT_PVT dependencies on FND_MSG_PUB

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

22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvcprb.pls';
23:
24:
25: -- Hint: Primary key needs to be returned.
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Create_Comp_Product(

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

23:
24:
25: -- Hint: Primary key needs to be returned.
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Create_Comp_Product(
31: p_api_version_number IN NUMBER,

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

24:
25: -- Hint: Primary key needs to be returned.
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Create_Comp_Product(
31: p_api_version_number IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 78: FND_MSG_PUB.initialize;

74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Debug Message
82: IF (AMS_DEBUG_HIGH_ON) THEN

Line 201: FND_MSG_PUB.Count_And_Get

197:
198: x_competitor_product_id := l_competitor_product_id;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205: EXCEPTION

Line 215: FND_MSG_PUB.Count_And_Get (

211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
219: );

Line 225: FND_MSG_PUB.Count_And_Get (

221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );

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

230:
231: WHEN OTHERS THEN
232: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message

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

232: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,

Line 239: FND_MSG_PUB.Count_And_Get (

235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 296: FND_MSG_PUB.initialize;

292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )
295: THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Debug Message
300: IF (AMS_DEBUG_HIGH_ON) THEN

Line 431: FND_MSG_PUB.Count_And_Get

427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: (p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435: EXCEPTION

Line 445: FND_MSG_PUB.Count_And_Get (

441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
449: );

Line 455: FND_MSG_PUB.Count_And_Get (

451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );

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

460:
461: WHEN OTHERS THEN
462: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message

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

462: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,

Line 469: FND_MSG_PUB.Count_And_Get (

465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 511: FND_MSG_PUB.initialize;

507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.
509: IF FND_API.to_Boolean( p_init_msg_list )
510: THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: -- Debug Message
515: IF (AMS_DEBUG_HIGH_ON) THEN

Line 556: FND_MSG_PUB.Count_And_Get

552: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
553: END IF;
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560: EXCEPTION

Line 570: FND_MSG_PUB.Count_And_Get (

566: WHEN FND_API.G_EXC_ERROR THEN
567: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: -- Standard call to get message count and if count=1, get the message
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: );

Line 580: FND_MSG_PUB.Count_And_Get (

576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: -- Standard call to get message count and if count=1, get the message
580: FND_MSG_PUB.Count_And_Get (
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );

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

585:
586: WHEN OTHERS THEN
587: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
592: END IF;
593: -- Standard call to get message count and if count=1, get the message

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

587: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
592: END IF;
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,

Line 594: FND_MSG_PUB.Count_And_Get (

590: THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
592: END IF;
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
598: );

Line 641: FND_MSG_PUB.initialize;

637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

669: FETCH c_Ams_Comp_Product INTO l_COMPETITOR_PRODUCT_ID;
670:
671: IF (c_Ams_Comp_Product%NOTFOUND) THEN
672: CLOSE c_Ams_Comp_Product;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
675: FND_MSG_PUB.add;
676: END IF;
677: RAISE FND_API.g_exc_error;

Line 675: FND_MSG_PUB.add;

671: IF (c_Ams_Comp_Product%NOTFOUND) THEN
672: CLOSE c_Ams_Comp_Product;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
675: FND_MSG_PUB.add;
676: END IF;
677: RAISE FND_API.g_exc_error;
678: END IF;
679:

Line 683: FND_MSG_PUB.count_and_get(

679:
680: CLOSE c_Ams_Comp_Product;
681:
682: -------------------- finish --------------------------
683: FND_MSG_PUB.count_and_get(
684: p_encoded => FND_API.g_false,
685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN

Line 701: FND_MSG_PUB.Count_And_Get (

697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );

Line 711: FND_MSG_PUB.Count_And_Get (

707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );

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

716:
717: WHEN OTHERS THEN
718: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message

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

718: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,

Line 725: FND_MSG_PUB.Count_And_Get (

721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 1139: FND_MSG_PUB.initialize;

1135:
1136: -- Initialize message list if p_init_msg_list is set to TRUE.
1137: IF FND_API.to_Boolean( p_init_msg_list )
1138: THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141:
1142: -- Initialize API return status to SUCCESS
1143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1154: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1150: -- Debug Message
1151: IF(p_comp_prod_rec.start_date > p_comp_prod_rec.end_date)
1152: THEN
1153: Ams_Utility_Pvt.debug_message('The End date is greater than Start date');
1154: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1155: THEN
1156: Fnd_Message.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');
1157: Fnd_Msg_Pub.ADD;
1158: END IF;

Line 1157: Fnd_Msg_Pub.ADD;

1153: Ams_Utility_Pvt.debug_message('The End date is greater than Start date');
1154: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1155: THEN
1156: Fnd_Message.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');
1157: Fnd_Msg_Pub.ADD;
1158: END IF;
1159: RAISE FND_API.g_exc_error;
1160: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
1161:

Line 1164: FND_MSG_PUB.Count_And_Get

1160: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
1161:
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168:

Line 1213: FND_MSG_PUB.initialize;

1209:
1210: -- Initialize message list if p_init_msg_list is set to TRUE.
1211: IF FND_API.to_Boolean( p_init_msg_list )
1212: THEN
1213: FND_MSG_PUB.initialize;
1214: END IF;
1215:
1216:
1217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1259: FND_MSG_PUB.Count_And_Get

1255: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get
1260: (p_count => x_msg_count,
1261: p_data => x_msg_data
1262: );
1263: EXCEPTION

Line 1273: FND_MSG_PUB.Count_And_Get (

1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data
1277: );

Line 1283: FND_MSG_PUB.Count_And_Get (

1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: -- Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE,
1285: p_count => x_msg_count,
1286: p_data => x_msg_data
1287: );

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

1288:
1289: WHEN OTHERS THEN
1290: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message

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

1290: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,

Line 1297: FND_MSG_PUB.Count_And_Get (

1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );