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

Line 70: FND_MSG_PUB.initialize;

66: END IF;
67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 107: FND_MSG_PUB.Count_And_Get

103: COMMIT WORK;
104: END IF;
105:
106: -- Standard call to get message count and if count is 1, get message info.
107: FND_MSG_PUB.Count_And_Get
108: (
109: p_count => x_msg_count ,
110: p_data => x_msg_data ,
111: p_encoded => FND_API.G_FALSE

Line 118: FND_MSG_PUB.Count_And_Get

114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: ROLLBACK TO Get_SF_Parameters_svp ;
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count ,
121: p_data => x_msg_data ,
122: p_encoded => FND_API.G_FALSE

Line 128: FND_MSG_PUB.Count_And_Get

124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Get_SF_Parameters_svp ;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: (
130: p_count => x_msg_count ,
131: p_data => x_msg_data ,
132: p_encoded => FND_API.G_FALSE

Line 141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: l_error_code := SQLCODE;
139: IF l_error_code = -54 THEN
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
142: THEN
143: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
144: FND_MSG_PUB.Add;
145: END IF;

Line 144: FND_MSG_PUB.Add;

140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
142: THEN
143: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
144: FND_MSG_PUB.Add;
145: END IF;
146: ELSE
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN

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

143: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
144: FND_MSG_PUB.Add;
145: END IF;
146: ELSE
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
150: END IF;
151: END IF;

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

145: END IF;
146: ELSE
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
150: END IF;
151: END IF;
152: FND_MSG_PUB.Count_And_Get
153: (

Line 152: FND_MSG_PUB.Count_And_Get

148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
150: END IF;
151: END IF;
152: FND_MSG_PUB.Count_And_Get
153: (
154: p_count => x_msg_count ,
155: p_data => x_msg_data ,
156: p_encoded => FND_API.G_FALSE

Line 228: FND_MSG_PUB.initialize;

224: END IF;
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Initialize API return status to success
232: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 241: FND_MSG_PUB.Add;

237: FROM CN_SF_REPOSITORIES ;
238:
239: IF l_count > 0 THEN
240: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
241: FND_MSG_PUB.Add;
242: RAISE fnd_api.g_exc_error ;
243: END IF;
244: */
245: -- BEGINING OF API BODY ----

Line 279: FND_MSG_PUB.Count_And_Get

275: COMMIT WORK;
276: END IF;
277:
278: -- Standard call to get message count and if count is 1, get message info.
279: FND_MSG_PUB.Count_And_Get
280: (
281: p_count => x_msg_count ,
282: p_data => x_msg_data ,
283: p_encoded => FND_API.G_FALSE

Line 290: FND_MSG_PUB.Count_And_Get

286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO Update_SF_Parameters_svp ;
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE

Line 301: FND_MSG_PUB.Count_And_Get

297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO Update_SF_Parameters_svp ;
299: --DBMS_OUTPUT.PUT_LINE('Update Error : Unexpected ');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE

Line 316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

312:
313: l_error_code := SQLCODE;
314: IF l_error_code = -54 THEN
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
319: FND_MSG_PUB.Add;
320: END IF;

Line 319: FND_MSG_PUB.Add;

315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
319: FND_MSG_PUB.Add;
320: END IF;
321: ELSE
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN

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

318: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
319: FND_MSG_PUB.Add;
320: END IF;
321: ELSE
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
325: END IF;
326: END IF;

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

320: END IF;
321: ELSE
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
325: END IF;
326: END IF;
327: FND_MSG_PUB.Count_And_Get
328: (

Line 327: FND_MSG_PUB.Count_And_Get

323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
325: END IF;
326: END IF;
327: FND_MSG_PUB.Count_And_Get
328: (
329: p_count => x_msg_count ,
330: p_data => x_msg_data ,
331: p_encoded => FND_API.G_FALSE

Line 404: FND_MSG_PUB.initialize;

400: END IF;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean( p_init_msg_list ) THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 421: FND_MSG_PUB.Add;

417: FROM CN_SF_REPOSITORIES ;
418:
419: IF l_count > 0 THEN
420: FND_MESSAGE.SET_NAME ('CN' , 'CN_SF_RECORD_EXISTS');
421: FND_MSG_PUB.Add;
422: RAISE fnd_api.g_exc_error ;
423: END IF;
424:
425:

Line 454: FND_MSG_PUB.Count_And_Get

450: COMMIT WORK;
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE

Line 465: FND_MSG_PUB.Count_And_Get

461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO Insert_SF_Parameters_svp ;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466: (
467: p_count => x_msg_count ,
468: p_data => x_msg_data ,
469: p_encoded => FND_API.G_FALSE

Line 475: FND_MSG_PUB.Count_And_Get

471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Insert_SF_Parameters_svp ;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
475: FND_MSG_PUB.Count_And_Get
476: (
477: p_count => x_msg_count ,
478: p_data => x_msg_data ,
479: p_encoded => FND_API.G_FALSE

Line 488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: l_error_code := SQLCODE;
486: IF l_error_code = -54 THEN
487: x_return_status := FND_API.G_RET_STS_ERROR ;
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
489: THEN
490: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
491: FND_MSG_PUB.Add;
492: END IF;

Line 491: FND_MSG_PUB.Add;

487: x_return_status := FND_API.G_RET_STS_ERROR ;
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
489: THEN
490: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
491: FND_MSG_PUB.Add;
492: END IF;
493: ELSE
494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN

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

490: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
491: FND_MSG_PUB.Add;
492: END IF;
493: ELSE
494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
497: END IF;
498: END IF;

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

492: END IF;
493: ELSE
494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
497: END IF;
498: END IF;
499: FND_MSG_PUB.Count_And_Get
500: (

Line 499: FND_MSG_PUB.Count_And_Get

495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
497: END IF;
498: END IF;
499: FND_MSG_PUB.Count_And_Get
500: (
501: p_count => x_msg_count ,
502: p_data => x_msg_data ,
503: p_encoded => FND_API.G_FALSE