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

Line 68: FND_MSG_PUB.initialize;

64:
65: -- Initialize API return status to success
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: FND_MSG_PUB.initialize;
69:
70: -- Check the profile option debug_level for debug message reporting
71: l_debug_level:=to_number(fnd_profile.value('CSI_DEBUG_LEVEL'));
72:

Line 103: FND_MSG_PUB.ADD;

99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
100: ELSE
101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');
102: END IF;
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: l_error_count:=l_error_count+1;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;

Line 139: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

135: );
136:
137: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
138:
139: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
140: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
141: IF FND_API.To_Boolean(p_commit) THEN
142: UPDATE csi_ii_geoloc_interface
143: SET process_flag = 'E',

Line 168: FND_MSG_PUB.ADD;

164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
168: FND_MSG_PUB.ADD;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: l_error_count:=l_error_count+1;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;

Line 185: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

181:
182: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
183:
184: l_error_count:=l_error_count+1;
185: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
186: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
187: IF FND_API.To_Boolean(p_commit) THEN
188: UPDATE csi_ii_geoloc_interface
189: SET process_flag = 'E',

Line 218: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

214: );
215:
216: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
217:
218: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
219: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
220: IF FND_API.To_Boolean(p_commit) THEN
221: UPDATE csi_ii_geoloc_interface
222: SET process_flag = 'E',

Line 253: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

249:
250: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
251:
252: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
253: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
254: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
255:
256: IF FND_API.To_Boolean(p_commit) THEN
257: UPDATE csi_ii_geoloc_interface

Line 292: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

288:
289: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
290:
291: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
292: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
293: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
294: IF FND_API.To_Boolean(p_commit) THEN
295: UPDATE csi_ii_geoloc_interface
296: SET process_flag = 'E',

Line 326: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

322:
323: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
324:
325: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
326: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
327: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
328: IF FND_API.To_Boolean(p_commit) THEN
329: UPDATE csi_ii_geoloc_interface
330: SET process_flag = 'E',

Line 364: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

360:
361: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
362:
363: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
364: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
365: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
366: IF FND_API.To_Boolean(p_commit) THEN
367: UPDATE csi_ii_geoloc_interface
368: SET process_flag = 'E',

Line 407: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

403: , x_return_status => l_return_status
404: );
405:
406: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
407: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
408: csi_t_gen_utility_pvt.add(l_msg_data);
409: IF FND_API.To_Boolean(p_commit) THEN
410: UPDATE csi_ii_geoloc_interface
411: SET process_flag = 'E',

Line 464: FND_MSG_PUB.Count_And_Get

460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
462: csi_t_gen_utility_pvt.add( 'Error Count:'||l_error_count);
463: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data
468: );

Line 474: FND_MSG_PUB.Count_And_Get

470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
473: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
474: FND_MSG_PUB.Count_And_Get
475: ( p_encoded => FND_API.G_FALSE,
476: p_count => x_msg_count,
477: p_data => x_msg_data
478: );

Line 484: IF FND_MSG_PUB.Check_Msg_Level

480: WHEN OTHERS THEN
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
483: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
484: IF FND_MSG_PUB.Check_Msg_Level
485: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg
488: (G_PKG_NAME,

Line 485: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
483: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
484: IF FND_MSG_PUB.Check_Msg_Level
485: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg
488: (G_PKG_NAME,
489: l_api_name

Line 487: FND_MSG_PUB.Add_Exc_Msg

483: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
484: IF FND_MSG_PUB.Check_Msg_Level
485: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg
488: (G_PKG_NAME,
489: l_api_name
490: );
491: END IF;

Line 492: FND_MSG_PUB.Count_And_Get

488: (G_PKG_NAME,
489: l_api_name
490: );
491: END IF;
492: FND_MSG_PUB.Count_And_Get
493: ( p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );