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

Line 25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

21: -- 29-Jan-2013 BKUNJAN Changes after code review
22: ---------------------------------------------------------------------
23:
24: PROCEDURE Update_GL_Date ( p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
27: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
28: ,p_ledger_id IN NUMBER
29: ,x_return_status OUT NOCOPY VARCHAR2

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

22: ---------------------------------------------------------------------
23:
24: PROCEDURE Update_GL_Date ( p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
27: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
28: ,p_ledger_id IN NUMBER
29: ,x_return_status OUT NOCOPY VARCHAR2
30: )

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

23:
24: PROCEDURE Update_GL_Date ( p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
27: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
28: ,p_ledger_id IN NUMBER
29: ,x_return_status OUT NOCOPY VARCHAR2
30: )
31: IS

Line 92: IF NOT FND_API.Compatible_API_Call ( l_api_version,

88: BEGIN
89: -- Standard Start of API savepoint
90: SAVEPOINT Update_GL_Date;
91: -- Standard call to check for call compatibility.
92: IF NOT FND_API.Compatible_API_Call ( l_api_version,
93: p_api_version,
94: l_api_name,
95: G_PKG_NAME)
96: THEN

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: p_api_version,
94: l_api_name,
95: G_PKG_NAME)
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list )
101: THEN

Line 100: IF FND_API.to_Boolean( p_init_msg_list )

96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list )
101: THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104:

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to SUCCESS
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107: --
108: -- API body
109: --
110: OPEN c_get_open_period_gl_date;

Line 154: p_init_msg_list => FND_API.G_FALSE,

150: l_claim_rec.gl_date := l_event_date;
151:
152: OZF_CLAIM_PVT.Update_Claim(
153: p_api_version => l_api_version,
154: p_init_msg_list => FND_API.G_FALSE,
155: p_commit => FND_API.G_FALSE,
156: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
157: x_return_status => l_return_status,
158: x_msg_count => l_msg_count,

Line 155: p_commit => FND_API.G_FALSE,

151:
152: OZF_CLAIM_PVT.Update_Claim(
153: p_api_version => l_api_version,
154: p_init_msg_list => FND_API.G_FALSE,
155: p_commit => FND_API.G_FALSE,
156: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
157: x_return_status => l_return_status,
158: x_msg_count => l_msg_count,
159: x_msg_data => l_msg_data,

Line 156: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

152: OZF_CLAIM_PVT.Update_Claim(
153: p_api_version => l_api_version,
154: p_init_msg_list => FND_API.G_FALSE,
155: p_commit => FND_API.G_FALSE,
156: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
157: x_return_status => l_return_status,
158: x_msg_count => l_msg_count,
159: x_msg_data => l_msg_data,
160: p_claim => l_claim_rec,

Line 166: IF l_return_status = FND_API.G_RET_STS_ERROR then

162: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
163: x_object_version_number => l_obj_version_number );
164:
165: -- Check return status from the above procedure call
166: IF l_return_status = FND_API.G_RET_STS_ERROR then
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;

Line 167: RAISE FND_API.G_EXC_ERROR;

163: x_object_version_number => l_obj_version_number );
164:
165: -- Check return status from the above procedure call
166: IF l_return_status = FND_API.G_RET_STS_ERROR then
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: END IF;

Line 168: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

164:
165: -- Check return status from the above procedure call
166: IF l_return_status = FND_API.G_RET_STS_ERROR then
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: END IF;
172:

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: -- Check return status from the above procedure call
166: IF l_return_status = FND_API.G_RET_STS_ERROR then
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: END IF;
172:
173: l_event_source_info.application_id := 682;

Line 189: WHEN FND_API.G_EXC_ERROR THEN

185:
186: END LOOP;
187:
188: EXCEPTION
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO Update_GL_Date;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error from UpdateGLDate: '||SQLERRM);
193:

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187:
188: EXCEPTION
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO Update_GL_Date;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error from UpdateGLDate: '||SQLERRM);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO Update_GL_Date;

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: ROLLBACK TO Update_GL_Date;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error from UpdateGLDate: '||SQLERRM);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO Update_GL_Date;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error from UpdateGLDate:: '||SQLERRM);
198:

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error from UpdateGLDate: '||SQLERRM);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO Update_GL_Date;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error from UpdateGLDate:: '||SQLERRM);
198:
199: WHEN OTHERS THEN
200: ROLLBACK TO Update_GL_Date;

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error from UpdateGLDate:: '||SQLERRM);
198:
199: WHEN OTHERS THEN
200: ROLLBACK TO Update_GL_Date;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error from UpdateGLDate:: '||SQLERRM);
203:
204: END Update_GL_Date;
205:

Line 301: p_init_msg_list => FND_API.G_FALSE,

297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ledger_id : '||p_ledger_id );
298:
299:
300: Update_GL_Date(p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
303: p_ledger_id => p_ledger_id,
304: x_return_status => l_return_status);
305:

Line 302: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

298:
299:
300: Update_GL_Date(p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
303: p_ledger_id => p_ledger_id,
304: x_return_status => l_return_status);
305:
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return Status from Update_GL_Date : '|| l_return_status );

Line 308: IF l_return_status = FND_API.g_ret_sts_error THEN

304: x_return_status => l_return_status);
305:
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return Status from Update_GL_Date : '|| l_return_status );
307:
308: IF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;

Line 309: RAISE FND_API.G_EXC_ERROR;

305:
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return Status from Update_GL_Date : '|| l_return_status );
307:
308: IF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:

Line 310: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return Status from Update_GL_Date : '|| l_return_status );
307:
308: IF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314:

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307:
308: IF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.G_EXC_ERROR;
310: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314:
315: --Fix for Bug 12426106

Line 404: WHEN FND_API.G_EXC_ERROR THEN

400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
402:
403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: retcode:=2;
406: ROLLBACK TO CREATE_Accounting;
407: errbuf:= FND_API.G_RET_STS_ERROR;
408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error: '||SQLERRM);

Line 407: errbuf:= FND_API.G_RET_STS_ERROR;

403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: retcode:=2;
406: ROLLBACK TO CREATE_Accounting;
407: errbuf:= FND_API.G_RET_STS_ERROR;
408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error: '||SQLERRM);
409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: retcode:=2;
416: ROLLBACK TO CREATE_Accounting;
417: errbuf:= FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error: '||SQLERRM);

Line 417: errbuf:= FND_API.G_RET_STS_UNEXP_ERROR;

413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: retcode:=2;
416: ROLLBACK TO CREATE_Accounting;
417: errbuf:= FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error: '||SQLERRM);
419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 426: errbuf:= FND_API.G_RET_STS_UNEXP_ERROR;

422: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
423: WHEN OTHERS THEN
424: retcode:=2;
425: ROLLBACK TO CREATE_Accounting;
426: errbuf:= FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));