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

Line 69: FND_MSG_PUB.initialize;

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

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

86: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
87: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
92: FND_MSG_PUB.Add;
93: END IF;
94: x_loading_status := 'CN_REQUIRED_FIELDS';

Line 92: FND_MSG_PUB.Add;

88: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
89: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
92: FND_MSG_PUB.Add;
93: END IF;
94: x_loading_status := 'CN_REQUIRED_FIELDS';
95: RAISE FND_API.G_EXC_ERROR;
96: ELSE

Line 103: FND_MSG_PUB.Count_And_Get(

99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO insert_row;
102: x_return_status := FND_API.G_RET_STS_ERROR ;
103: FND_MSG_PUB.Count_And_Get(
104: p_count => x_msg_count ,
105: p_data => x_msg_data ,
106: p_encoded => FND_API.G_FALSE);
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 111: FND_MSG_PUB.Count_And_Get(

107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108: ROLLBACK TO insert_row;
109: x_loading_status := 'UNEXPECTED_ERR';
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: FND_MSG_PUB.Count_And_Get(
112: p_count => x_msg_count ,
113: p_data => x_msg_data ,
114: p_encoded => FND_API.G_FALSE);
115: WHEN OTHERS THEN

Line 119: IF FND_MSG_PUB.Check_Msg_Level(

115: WHEN OTHERS THEN
116: ROLLBACK TO insert_row;
117: x_loading_status := 'UNEXPECTED_ERR';
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: IF FND_MSG_PUB.Check_Msg_Level(
120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
121: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
122: END IF;
123: FND_MSG_PUB.Count_And_Get(

Line 120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

116: ROLLBACK TO insert_row;
117: x_loading_status := 'UNEXPECTED_ERR';
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: IF FND_MSG_PUB.Check_Msg_Level(
120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
121: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
122: END IF;
123: FND_MSG_PUB.Count_And_Get(
124: p_count => x_msg_count ,

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

117: x_loading_status := 'UNEXPECTED_ERR';
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: IF FND_MSG_PUB.Check_Msg_Level(
120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
121: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
122: END IF;
123: FND_MSG_PUB.Count_And_Get(
124: p_count => x_msg_count ,
125: p_data => x_msg_data ,

Line 123: FND_MSG_PUB.Count_And_Get(

119: IF FND_MSG_PUB.Check_Msg_Level(
120: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
121: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
122: END IF;
123: FND_MSG_PUB.Count_And_Get(
124: p_count => x_msg_count ,
125: p_data => x_msg_data ,
126: p_encoded => FND_API.G_FALSE);
127: END;

Line 165: FND_MSG_PUB.initialize;

161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to success
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: x_loading_status := 'CN_INSERTED';

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

174: (l_reasons_all_rec.reason = fnd_api.g_miss_char) OR
175: (l_reasons_all_rec.lookup_type = fnd_api.g_miss_char) OR
176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
180: FND_MSG_PUB.Add;
181: END IF;
182: x_loading_status := 'CN_REQUIRED_FIELDS';

Line 180: FND_MSG_PUB.Add;

176: (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
177: (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
179: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
180: FND_MSG_PUB.Add;
181: END IF;
182: x_loading_status := 'CN_REQUIRED_FIELDS';
183: RAISE FND_API.G_EXC_ERROR;
184: ELSE

Line 231: FND_MSG_PUB.Count_And_Get(

227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO update_row;
230: x_return_status := FND_API.G_RET_STS_ERROR ;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 239: FND_MSG_PUB.Count_And_Get(

235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO update_row;
237: x_loading_status := 'UNEXPECTED_ERR';
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: FND_MSG_PUB.Count_And_Get(
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE);
243: WHEN OTHERS THEN

Line 247: IF FND_MSG_PUB.Check_Msg_Level(

243: WHEN OTHERS THEN
244: ROLLBACK TO update_row;
245: x_loading_status := 'UNEXPECTED_ERR';
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: IF FND_MSG_PUB.Check_Msg_Level(
248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get(

Line 248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

244: ROLLBACK TO update_row;
245: x_loading_status := 'UNEXPECTED_ERR';
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: IF FND_MSG_PUB.Check_Msg_Level(
248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get(
252: p_count => x_msg_count ,

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

245: x_loading_status := 'UNEXPECTED_ERR';
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: IF FND_MSG_PUB.Check_Msg_Level(
248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get(
252: p_count => x_msg_count ,
253: p_data => x_msg_data ,

Line 251: FND_MSG_PUB.Count_And_Get(

247: IF FND_MSG_PUB.Check_Msg_Level(
248: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
250: END IF;
251: FND_MSG_PUB.Count_And_Get(
252: p_count => x_msg_count ,
253: p_data => x_msg_data ,
254: p_encoded => FND_API.G_FALSE);
255: END;

Line 292: FND_MSG_PUB.initialize;

288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list ) THEN
292: FND_MSG_PUB.initialize;
293: END IF;
294: -- Initialize API return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: x_loading_status := 'CN_INSERTED';

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

295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: x_loading_status := 'CN_INSERTED';
297: -- API body
298: IF (p_reason_id = FND_API.G_MISS_NUM) THEN
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.SET_NAME ('CN' , 'CN_REASON_ID_ERROR');
301: FND_MSG_PUB.Add;
302: END IF;
303: x_loading_status := 'CN_REASON_ID_ERROR';

Line 301: FND_MSG_PUB.Add;

297: -- API body
298: IF (p_reason_id = FND_API.G_MISS_NUM) THEN
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.SET_NAME ('CN' , 'CN_REASON_ID_ERROR');
301: FND_MSG_PUB.Add;
302: END IF;
303: x_loading_status := 'CN_REASON_ID_ERROR';
304: RAISE FND_API.G_EXC_ERROR ;
305: END IF;

Line 351: FND_MSG_PUB.Count_And_Get(

347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO update_row;
350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get(
352: p_count => x_msg_count ,
353: p_data => x_msg_data ,
354: p_encoded => FND_API.G_FALSE);
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 359: FND_MSG_PUB.Count_And_Get(

355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_row;
357: x_loading_status := 'UNEXPECTED_ERR';
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: FND_MSG_PUB.Count_And_Get(
360: p_count => x_msg_count ,
361: p_data => x_msg_data ,
362: p_encoded => FND_API.G_FALSE);
363: WHEN OTHERS THEN

Line 367: IF FND_MSG_PUB.Check_Msg_Level(

363: WHEN OTHERS THEN
364: ROLLBACK TO update_row;
365: x_loading_status := 'UNEXPECTED_ERR';
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: IF FND_MSG_PUB.Check_Msg_Level(
368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
370: END IF;
371: FND_MSG_PUB.Count_And_Get(

Line 368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

364: ROLLBACK TO update_row;
365: x_loading_status := 'UNEXPECTED_ERR';
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: IF FND_MSG_PUB.Check_Msg_Level(
368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
370: END IF;
371: FND_MSG_PUB.Count_And_Get(
372: p_count => x_msg_count ,

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

365: x_loading_status := 'UNEXPECTED_ERR';
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: IF FND_MSG_PUB.Check_Msg_Level(
368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
370: END IF;
371: FND_MSG_PUB.Count_And_Get(
372: p_count => x_msg_count ,
373: p_data => x_msg_data ,

Line 371: FND_MSG_PUB.Count_And_Get(

367: IF FND_MSG_PUB.Check_Msg_Level(
368: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
370: END IF;
371: FND_MSG_PUB.Count_And_Get(
372: p_count => x_msg_count ,
373: p_data => x_msg_data ,
374: p_encoded => FND_API.G_FALSE);
375: END;

Line 413: FND_MSG_PUB.initialize;

409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: x_loading_status := 'CN_INSERTED';

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

416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: x_loading_status := 'CN_INSERTED';
418: -- API body
419: IF (p_payment_worksheet_id = FND_API.G_MISS_NUM) THEN
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
421: FND_MESSAGE.SET_NAME ('CN' , 'CN_WORKSHEET_ID_ERROR');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_loading_status := 'CN_WORKSHEET_ID_ERROR';

Line 422: FND_MSG_PUB.Add;

418: -- API body
419: IF (p_payment_worksheet_id = FND_API.G_MISS_NUM) THEN
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
421: FND_MESSAGE.SET_NAME ('CN' , 'CN_WORKSHEET_ID_ERROR');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_loading_status := 'CN_WORKSHEET_ID_ERROR';
425: RAISE FND_API.G_EXC_ERROR ;
426: END IF;

Line 441: FND_MSG_PUB.Count_And_Get(

437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO delete_worksheet_notes;
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MSG_PUB.Count_And_Get(
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 449: FND_MSG_PUB.Count_And_Get(

445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO delete_worksheet_notes;
447: x_loading_status := 'UNEXPECTED_ERR';
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: FND_MSG_PUB.Count_And_Get(
450: p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE);
453: WHEN OTHERS THEN

Line 457: IF FND_MSG_PUB.Check_Msg_Level(

453: WHEN OTHERS THEN
454: ROLLBACK TO delete_worksheet_notes;
455: x_loading_status := 'UNEXPECTED_ERR';
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level(
458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(

Line 458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

454: ROLLBACK TO delete_worksheet_notes;
455: x_loading_status := 'UNEXPECTED_ERR';
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level(
458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(
462: p_count => x_msg_count ,

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

455: x_loading_status := 'UNEXPECTED_ERR';
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level(
458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(
462: p_count => x_msg_count ,
463: p_data => x_msg_data ,

Line 461: FND_MSG_PUB.Count_And_Get(

457: IF FND_MSG_PUB.Check_Msg_Level(
458: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(
462: p_count => x_msg_count ,
463: p_data => x_msg_data ,
464: p_encoded => FND_API.G_FALSE);
465: END;