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

Line 16: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: PROCEDURE IMPORT_RECOMENDED_QUANTITIES(p_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_item_id IN NUMBER,
20: p_item_segment1 IN VARCHAR2,

Line 17: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: PROCEDURE IMPORT_RECOMENDED_QUANTITIES(p_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_item_id IN NUMBER,
20: p_item_segment1 IN VARCHAR2,
21: p_item_segment2 IN VARCHAR2,

Line 18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

14:
15: PROCEDURE IMPORT_RECOMENDED_QUANTITIES(p_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_item_id IN NUMBER,
20: p_item_segment1 IN VARCHAR2,
21: p_item_segment2 IN VARCHAR2,
22: p_item_segment3 IN VARCHAR2,

Line 90: IF NOT FND_API.Compatible_API_Call

86: l_number_of_segments number;
87: conc_segments varchar2(1000);
88: BEGIN
89: SAVEPOINT IMPORT_RECOMENDED_QUANTITIS;
90: IF NOT FND_API.Compatible_API_Call
91: ( l_api_version_number
92: , p_api_version_number
93: , L_API_NAME
94: , G_PKG_NAME

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: , L_API_NAME
94: , G_PKG_NAME
95: )
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message stack if required
101: IF FND_API.to_Boolean(p_init_msg_list)

Line 101: IF FND_API.to_Boolean(p_init_msg_list)

97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message stack if required
101: IF FND_API.to_Boolean(p_init_msg_list)
102: THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107: IF p_organization_id IS NOT NULL THEN
108: l_organization_id := p_organization_id ;
109: ELSE IF p_organization_name IS NOT NULL THEN
110: OPEN csp_inv_org_name(p_organization_name);

Line 221: IF FND_API.to_Boolean( p_commit )

217: 'Y','M',G_USER_ID, SYSDATE, G_USER_ID, SYSDATE, G_LOGIN_ID,1,p_subinventory_code);
218:
219: END IF;
220: END IF;
221: IF FND_API.to_Boolean( p_commit )
222: THEN
223: COMMIT WORK;
224: END IF;
225: EXCEPTION

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: THEN
223: COMMIT WORK;
224: END IF;
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: WHEN OTHERS THEN
230: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: END IF;
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: WHEN OTHERS THEN
230: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: END IMPORT_RECOMENDED_QUANTITIES;

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: WHEN OTHERS THEN
230: ROLLBACK TO IMPORT_RECOMENDED_QUANTITIS;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: END IMPORT_RECOMENDED_QUANTITIES;
233:
234: PROCEDURE PURGE_OLD_RECOMMENDATIONS(P_Api_Version_Number IN NUMBER,
235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: END IMPORT_RECOMENDED_QUANTITIES;
233:
234: PROCEDURE PURGE_OLD_RECOMMENDATIONS(P_Api_Version_Number IN NUMBER,
235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
236: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_Msg_Count OUT NOCOPY NUMBER,

Line 236: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

232: END IMPORT_RECOMENDED_QUANTITIES;
233:
234: PROCEDURE PURGE_OLD_RECOMMENDATIONS(P_Api_Version_Number IN NUMBER,
235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
236: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_Msg_Count OUT NOCOPY NUMBER,
240: x_Msg_Data OUT NOCOPY VARCHAR2) IS

Line 237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

233:
234: PROCEDURE PURGE_OLD_RECOMMENDATIONS(P_Api_Version_Number IN NUMBER,
235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
236: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_Msg_Count OUT NOCOPY NUMBER,
240: x_Msg_Data OUT NOCOPY VARCHAR2) IS
241: l_api_version_number NUMBER := 1.0;

Line 245: IF NOT FND_API.Compatible_API_Call

241: l_api_version_number NUMBER := 1.0;
242: L_API_NAME CONSTANT VARCHAR2(30) := 'PURGE_OLD_RECOMMENDATIONS';
243: BEGIN
244: SAVEPOINT PURGE_OLD_RECOMMENDATIONS;
245: IF NOT FND_API.Compatible_API_Call
246: ( l_api_version_number
247: , p_api_version_number
248: , L_API_NAME
249: , G_PKG_NAME

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: , L_API_NAME
249: , G_PKG_NAME
250: )
251: THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254: -- Initialize message stack if required
255: IF FND_API.to_Boolean(p_init_msg_list)
256: THEN

Line 255: IF FND_API.to_Boolean(p_init_msg_list)

251: THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254: -- Initialize message stack if required
255: IF FND_API.to_Boolean(p_init_msg_list)
256: THEN
257: FND_MSG_PUB.initialize;
258: END IF;
259: CSP_AUTO_ASLMSL_PVT.Purge_Planning_Data (

Line 261: P_Init_Msg_List => FND_API.G_FALSE,

257: FND_MSG_PUB.initialize;
258: END IF;
259: CSP_AUTO_ASLMSL_PVT.Purge_Planning_Data (
260: P_Api_Version_Number => l_api_version_number,
261: P_Init_Msg_List => FND_API.G_FALSE,
262: P_Commit => FND_API.G_FALSE,
263: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
264: X_Return_Status => x_return_status,
265: X_Msg_Count => x_msg_count,

Line 262: P_Commit => FND_API.G_FALSE,

258: END IF;
259: CSP_AUTO_ASLMSL_PVT.Purge_Planning_Data (
260: P_Api_Version_Number => l_api_version_number,
261: P_Init_Msg_List => FND_API.G_FALSE,
262: P_Commit => FND_API.G_FALSE,
263: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
264: X_Return_Status => x_return_status,
265: X_Msg_Count => x_msg_count,
266: X_Msg_Data => x_msg_data);

Line 263: P_validation_level => FND_API.G_VALID_LEVEL_FULL,

259: CSP_AUTO_ASLMSL_PVT.Purge_Planning_Data (
260: P_Api_Version_Number => l_api_version_number,
261: P_Init_Msg_List => FND_API.G_FALSE,
262: P_Commit => FND_API.G_FALSE,
263: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
264: X_Return_Status => x_return_status,
265: X_Msg_Count => x_msg_count,
266: X_Msg_Data => x_msg_data);
267:

Line 268: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

264: X_Return_Status => x_return_status,
265: X_Msg_Count => x_msg_count,
266: X_Msg_Data => x_msg_data);
267:
268: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
269: IF FND_API.to_Boolean( p_commit )
270: THEN
271: COMMIT WORK;
272: END IF;

Line 269: IF FND_API.to_Boolean( p_commit )

265: X_Msg_Count => x_msg_count,
266: X_Msg_Data => x_msg_data);
267:
268: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
269: IF FND_API.to_Boolean( p_commit )
270: THEN
271: COMMIT WORK;
272: END IF;
273: ELSE

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: THEN
271: COMMIT WORK;
272: END IF;
273: ELSE
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN OTHERS THEN
282: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN OTHERS THEN
282: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: END PURGE_OLD_RECOMMENDATIONS;

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

279: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN OTHERS THEN
282: ROLLBACK TO PURGE_OLD_RECOMMENDATIONS;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: END PURGE_OLD_RECOMMENDATIONS;
285: END CSP_ASL_PUB;