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.INV_COPY_ORGANIZATION_REPORT dependencies on FND_API

Line 119: -- FND_API.G_RET_STS_SUCCESS

115: -- p_api_version REQUIRED. As per standards.
116: -- p_init_msg_list REQUIRED. As per standards.
117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR
122: -- x_msg_count REQUIRED. As per standards.
123: -- x_msg_data REQUIRED. As per standards.

Line 120: -- FND_API.G_RET_STS_ERROR

116: -- p_init_msg_list REQUIRED. As per standards.
117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR
122: -- x_msg_count REQUIRED. As per standards.
123: -- x_msg_data REQUIRED. As per standards.
124: -- p_group_code REQUIRED. Group code created for Copy Org request.

Line 121: -- FND_API.G_RET_STS_UNEXP_ERROR

117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR
122: -- x_msg_count REQUIRED. As per standards.
123: -- x_msg_data REQUIRED. As per standards.
124: -- p_group_code REQUIRED. Group code created for Copy Org request.
125: -- p_model_org_code REQUIRED. Model organization to copy from.

Line 139: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

135: --
136: --=============================================================================
137: PROCEDURE Generate_Report_Data
138: ( p_api_version IN NUMBER
139: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: , p_commit IN VARCHAR2 := FND_API.G_FALSE
141: , x_return_status OUT NOCOPY VARCHAR2
142: , x_msg_count OUT NOCOPY NUMBER
143: , x_msg_data OUT NOCOPY VARCHAR2

Line 140: , p_commit IN VARCHAR2 := FND_API.G_FALSE

136: --=============================================================================
137: PROCEDURE Generate_Report_Data
138: ( p_api_version IN NUMBER
139: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: , p_commit IN VARCHAR2 := FND_API.G_FALSE
141: , x_return_status OUT NOCOPY VARCHAR2
142: , x_msg_count OUT NOCOPY NUMBER
143: , x_msg_data OUT NOCOPY VARCHAR2
144: , p_group_code IN VARCHAR2

Line 223: IF NOT FND_API.Compatible_API_Call( l_api_version

219: g_location_status := p_location_status;
220: -----------------------------------------------------------------------------
221: -- Check for call compatibility.
222: -----------------------------------------------------------------------------
223: IF NOT FND_API.Compatible_API_Call( l_api_version
224: , p_api_version
225: , l_api_name
226: , G_PKG_NAME
227: )

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225: , l_api_name
226: , G_PKG_NAME
227: )
228: THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231: -----------------------------------------------------------------------------
232: -- Initialize API message list if necessary.
233: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 235: IF FND_API.to_Boolean( p_init_msg_list )

231: -----------------------------------------------------------------------------
232: -- Initialize API message list if necessary.
233: -- Initialize message list if p_init_msg_list is set to TRUE.
234: -----------------------------------------------------------------------------
235: IF FND_API.to_Boolean( p_init_msg_list )
236: THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: Validate_Orgs();
294: -------------------------------------------------------------------------
295: -- Standard check of p_commit.
296: -------------------------------------------------------------------------
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: IF FND_API.To_Boolean( p_commit ) THEN
299: COMMIT WORK;
300: END IF;
301: ---------------------------------------------------------------------------

Line 298: IF FND_API.To_Boolean( p_commit ) THEN

294: -------------------------------------------------------------------------
295: -- Standard check of p_commit.
296: -------------------------------------------------------------------------
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: IF FND_API.To_Boolean( p_commit ) THEN
299: COMMIT WORK;
300: END IF;
301: ---------------------------------------------------------------------------
302: -- set return status to appropriate value based in org

Line 307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

303: -- validation status.
304: ---------------------------------------------------------------------------
305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
308: ROLLBACK TO Generate_Report_Data_PVT;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
311:

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
308: ROLLBACK TO Generate_Report_Data_PVT;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
311:
312: WHEN OTHERS THEN
313: ROLLBACK TO Generate_Report_Data_PVT;

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

310: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
311:
312: WHEN OTHERS THEN
313: ROLLBACK TO Generate_Report_Data_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
316:
317: END Generate_Report_Data;
318:

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547: AND hou1.organization_id = hou.business_group_id
548: AND hou.organization_id = g_organization_id;
549: EXCEPTION
550: WHEN OTHERS THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END;
553: END IF;
554: -- END OF IF bug 4111958
555:

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

575: FROM hr_locations locs
576: WHERE locs.location_id = l_location_id;
577: EXCEPTION
578: WHEN OTHERS THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END;
581:
582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');
583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: );
614: END IF;
615:
616: EXCEPTION
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );