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

Line 181: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR

177: BEGIN
178: l_api_name := UPPER(p_api_name);
179:
180: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
181: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get(
185: p_encoded => FND_API.G_FALSE,

Line 184: FND_MSG_PUB.Count_And_Get(

180: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
181: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
182: THEN
183: x_return_status := FND_API.G_RET_STS_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: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 188: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_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: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
189: THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.Count_And_Get(
192: p_encoded => FND_API.G_FALSE,

Line 191: FND_MSG_PUB.Count_And_Get(

187: p_data => x_msg_data);
188: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
189: THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.Count_And_Get(
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: ELSIF p_exception_level = CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS

Line 199: FND_MSG_PUB.BUILD_EXC_MSG (

195: ELSIF p_exception_level = CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS
196: THEN
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: -- Insert the 'sqlerrm' into the message stack.
199: FND_MSG_PUB.BUILD_EXC_MSG (
200: p_pkg_name => p_pkg_name,
201: p_procedure_name => p_api_name );
202:
203: FND_MSG_PUB.Count_And_Get(

Line 203: FND_MSG_PUB.Count_And_Get(

199: FND_MSG_PUB.BUILD_EXC_MSG (
200: p_pkg_name => p_pkg_name,
201: p_procedure_name => p_api_name );
202:
203: FND_MSG_PUB.Count_And_Get(
204: p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data);
207: END IF;

Line 224: FND_MSG_PUB.initialize;

220: BEGIN
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF FND_API.to_Boolean( p_init_msg_list )
223: THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: -- Initialize API return status to SUCCESS
228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 233: --fnd_msg_pub.add;

229:
230:
231: IF ( p_start_date > p_end_date ) then
232: fnd_message.set_name (G_APP_SHORTNAME, 'CS_ALL_START_DATE_AFTER_END');
233: --fnd_msg_pub.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (p_end_date = G_MISS_DATE) THEN
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: END IF;

Line 248: --FND_MSG_PUB.Add;

244: FND_MESSAGE.SET_NAME (G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
245: FND_MESSAGE.SET_TOKEN('API_NAME', 'VALIDATE_DATES');
246: FND_MESSAGE.SET_TOKEN('VALUE', p_start_date); -- parameter here is start_date.
247: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_START_DATE');
248: --FND_MSG_PUB.Add;
249: end if;
250: if ( p_end_date < sysdate ) then
251: FND_MESSAGE.SET_NAME (G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
252: FND_MESSAGE.SET_TOKEN('API_NAME', 'VALIDATE_DATES');

Line 255: --FND_MSG_PUB.Add;

251: FND_MESSAGE.SET_NAME (G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
252: FND_MESSAGE.SET_TOKEN('API_NAME', 'VALIDATE_DATES');
253: FND_MESSAGE.SET_TOKEN('VALUE', p_end_date); -- parameter here is start_date.
254: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_END_DATE');
255: --FND_MSG_PUB.Add;
256: end if;
257: end if;
258: */
259:

Line 261: FND_MSG_PUB.Count_And_Get (

257: end if;
258: */
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data);
265:

Line 283: FND_MSG_PUB.initialize;

279: BEGIN
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list )
282: THEN
283: FND_MSG_PUB.initialize;
284: END IF;
285:
286: -- Initialize API return status to SUCCESS
287: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 293: --fnd_msg_pub.add;

289: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_CHAR ) then
290: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
291: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
292: fnd_message.set_token('NULL_PARAM', p_column_name);
293: --fnd_msg_pub.add;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: end if;
296:
297: -- Standard call to get message count and if count is 1, get message info.

Line 298: FND_MSG_PUB.Count_And_Get (

294: x_return_status := FND_API.G_RET_STS_ERROR;
295: end if;
296:
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:

Line 319: FND_MSG_PUB.initialize;

315: BEGIN
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list )
318: THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:
322: -- Initialize API return status to SUCCESS
323: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 329: --fnd_msg_pub.add;

325: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_NUM ) then
326: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
327: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
328: fnd_message.set_token('NULL_PARAM', p_column_name);
329: --fnd_msg_pub.add;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: end if;
332:
333: -- Standard call to get message count and if count is 1, get message info.

Line 334: FND_MSG_PUB.Count_And_Get(

330: x_return_status := FND_API.G_RET_STS_ERROR;
331: end if;
332:
333: -- Standard call to get message count and if count is 1, get message info.
334: FND_MSG_PUB.Count_And_Get(
335: p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data);
338:

Line 356: FND_MSG_PUB.initialize;

352: BEGIN
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean( p_init_msg_list )
355: THEN
356: FND_MSG_PUB.initialize;
357: END IF;
358:
359: -- Initialize API return status to SUCCESS
360: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 366: --fnd_msg_pub.add;

362: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_DATE ) then
363: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
364: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
365: fnd_message.set_token('NULL_PARAM', p_column_name);
366: --fnd_msg_pub.add;
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info.

Line 371: FND_MSG_PUB.Count_And_Get (

367: x_return_status := FND_API.G_RET_STS_ERROR;
368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get (
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:

Line 427: FND_MSG_PUB.initialize;

423: BEGIN
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )
426: THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Initialize API return status to SUCCESS
431: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

654: p_argument_value VARCHAR2
655: )
656: IS
657: BEGIN
658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
659: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
660: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
661: FND_MESSAGE.Set_Token('VALUE', p_argument_value);
662: FND_MESSAGE.Set_Token('PARAMETER', p_argument);

Line 709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

705:
706: /*
707: IF ( p_start_date IS NOT NULL ) THEN
708: IF p_start_date < sysdate THEN
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
710: FND_MESSAGE.Set_Name('CS', 'CS_ALL_START_DATE');
711: FND_MESSAGE.Set_Token('START_DATE' ,p_start_date);
712: FND_MESSAGE.Set_Token('END_DATE' ,p_end_date);
713: END IF;

Line 719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

715:
716: END IF;
717: --
718: IF( p_end_date < p_start_date ) THEN
719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
720: FND_MESSAGE.Set_Name('CS', 'CS_ALL_END_DATE');
721: FND_MESSAGE.Set_Token('START_DATE' ,p_start_date);
722: FND_MESSAGE.Set_Token('END_DATE' ,p_end_date);
723: END IF;

Line 747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

743: ( p_api_name VARCHAR2
744: )
745: IS
746: BEGIN
747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
748: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');
749: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
750: END IF;
751: END Record_IS_Locked_Msg;

Line 771: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

767: p_argument_value VARCHAR2
768: )
769: IS
770: BEGIN
771: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
772: --** check the message name
773: FND_MESSAGE.Set_Name('CS', 'CS_API_CHG_CANT_UPD_PARAM');
774: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
775: FND_MESSAGE.Set_Token('COLUMN_NAME', p_argument);

Line 797: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

793: p_argument VARCHAR2
794: )
795: IS
796: BEGIN
797: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
798: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
799: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
800: FND_MESSAGE.Set_Token('NULL_PARAM', p_argument);
801: END IF;

Line 823: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

819: p_argument_value VARCHAR2
820: )
821: IS
822: BEGIN
823: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
825: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
826: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_argument_value);
827: END IF;

Line 846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

842: --
843: Begin
844:
845: --
846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
847: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_MISSING_PARAM');
848: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
849: FND_MESSAGE.Set_Token('MISSING_PARAM', p_argument);
850: End If;