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

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

17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18:
19: PROCEDURE Create_writeoffs(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
25: X_WRITEOFF_ID OUT NOCOPY NUMBER,

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

18:
19: PROCEDURE Create_writeoffs(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
25: X_WRITEOFF_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,

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

19: PROCEDURE Create_writeoffs(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
25: X_WRITEOFF_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,

Line 53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

49: -- Standard Start of API savepoint
50: SAVEPOINT CREATE_WRITEOFFS_PVT;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 63: IF FND_API.to_Boolean( p_init_msg_list )

59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --
72: -- API body
73: --

Line 85: RAISE FND_API.G_EXC_ERROR;

81: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
82: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
83: FND_MSG_PUB.ADD;
84: END IF;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: -- IF PG_DEBUG < 10 THEN
88: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
89: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After Global user Check');

Line 111: (p_writeoffs_rec.writeoff_type= FND_API.G_MISS_CHAR) THEN

107: v_writeoff_id);
108: END IF;
109:
110: IF (p_writeoffs_rec.writeoff_type IS NULL) OR
111: (p_writeoffs_rec.writeoff_type= FND_API.G_MISS_CHAR) THEN
112: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
113: fnd_message.set_token('API_NAME', l_api_name);
114: fnd_message.set_token('MISSING_PARAM', 'writeoff_type');
115: fnd_msg_pub.add;

Line 116: RAISE FND_API.G_EXC_ERROR;

112: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
113: fnd_message.set_token('API_NAME', l_api_name);
114: fnd_message.set_token('MISSING_PARAM', 'writeoff_type');
115: fnd_msg_pub.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
120: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_type Check ');

Line 124: (p_writeoffs_rec.writeoff_reason= FND_API.G_MISS_CHAR) THEN

120: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_type Check ');
121: END IF;
122:
123: IF (p_writeoffs_rec.writeoff_reason IS NULL) OR
124: (p_writeoffs_rec.writeoff_reason= FND_API.G_MISS_CHAR) THEN
125: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
126: fnd_message.set_token('API_NAME', l_api_name);
127: fnd_message.set_token('MISSING_PARAM', 'writeoff_reason');
128: fnd_msg_pub.add;

Line 129: RAISE FND_API.G_EXC_ERROR;

125: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
126: fnd_message.set_token('API_NAME', l_api_name);
127: fnd_message.set_token('MISSING_PARAM', 'writeoff_reason');
128: fnd_msg_pub.add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131:
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_reason Check ');

Line 137: (p_writeoffs_rec.party_id = FND_API.G_MISS_NUM) THEN

133: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_reason Check ');
134: END IF;
135:
136: IF (p_writeoffs_rec.party_id IS NULL) OR
137: (p_writeoffs_rec.party_id = FND_API.G_MISS_NUM) THEN
138: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
139: fnd_message.set_token('API_NAME', l_api_name);
140: fnd_message.set_token('MISSING_PARAM', 'party_id');
141: fnd_msg_pub.add;

Line 142: RAISE FND_API.G_EXC_ERROR;

138: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
139: fnd_message.set_token('API_NAME', l_api_name);
140: fnd_message.set_token('MISSING_PARAM', 'party_id');
141: fnd_msg_pub.add;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
145: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After party_id Check ');
146: END IF;

Line 222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

218: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
219: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After Calling IEX_WRITEOFFS_PKG.'||
220: 'Insert_Row and WRITEOFF_ID is => '||x_WRITEOFF_ID);
221: END IF;
222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: --

Line 223: RAISE FND_API.G_EXC_ERROR;

219: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After Calling IEX_WRITEOFFS_PKG.'||
220: 'Insert_Row and WRITEOFF_ID is => '||x_WRITEOFF_ID);
221: END IF;
222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: --
227: -- End of API body

Line 231: IF FND_API.to_Boolean( p_commit )

227: -- End of API body
228: --
229:
230: -- Standard check for p_commit
231: IF FND_API.to_Boolean( p_commit )
232: THEN
233: COMMIT WORK;
234: END IF;
235:

Line 250: WHEN FND_API.G_EXC_ERROR THEN

246: 'IEX_WRITEOFFS_PVT.create_WRITEOFFS ******** ');
247: END IF;
248:
249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
252: P_API_NAME => L_API_NAME
253: ,P_PKG_NAME => G_PKG_NAME
254: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

256: ,X_MSG_COUNT => X_MSG_COUNT
257: ,X_MSG_DATA => X_MSG_DATA
258: ,X_RETURN_STATUS => X_RETURN_STATUS);
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

282:
283:
284: PROCEDURE Update_writeoffs(
285: P_Api_Version_Number IN NUMBER,
286: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
287: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: P_writeoffs_Rec IN writeoffs_Rec_Type,
290: X_Return_Status OUT NOCOPY VARCHAR2,

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

283:
284: PROCEDURE Update_writeoffs(
285: P_Api_Version_Number IN NUMBER,
286: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
287: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: P_writeoffs_Rec IN writeoffs_Rec_Type,
290: X_Return_Status OUT NOCOPY VARCHAR2,
291: X_Msg_Count OUT NOCOPY NUMBER,

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

284: PROCEDURE Update_writeoffs(
285: P_Api_Version_Number IN NUMBER,
286: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
287: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: P_writeoffs_Rec IN writeoffs_Rec_Type,
290: X_Return_Status OUT NOCOPY VARCHAR2,
291: X_Msg_Count OUT NOCOPY NUMBER,
292: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 313: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

309: -- Standard Start of API savepoint
310: SAVEPOINT UPDATE_WRITEOFFS_PVT;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN

Line 318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 323: IF FND_API.to_Boolean( p_init_msg_list )

319: END IF;
320:
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean( p_init_msg_list )
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327:

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327:
328:
329:
330: -- Initialize API return status to SUCCESS
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: --
334: -- Api body
335: --

Line 419: IF FND_API.to_Boolean( p_commit )

415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
416: IEX_DEBUG_PUB.LogMessage ('IEX_WRITEOFFS_PVT.update_WRITEOFFS is successfull');
417: END IF;
418: -- Standard check for p_commit
419: IF FND_API.to_Boolean( p_commit )
420: THEN
421: COMMIT WORK;
422: END IF;
423:

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: END IF;
435:
436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
450: P_API_NAME => L_API_NAME
451: ,P_PKG_NAME => G_PKG_NAME
452: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

470:
471:
472: PROCEDURE Delete_writeoffs(
473: P_Api_Version_Number IN NUMBER,
474: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
475: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: P_writeoff_id IN NUMBER,
478: X_Return_Status OUT NOCOPY VARCHAR2,

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

471:
472: PROCEDURE Delete_writeoffs(
473: P_Api_Version_Number IN NUMBER,
474: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
475: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: P_writeoff_id IN NUMBER,
478: X_Return_Status OUT NOCOPY VARCHAR2,
479: X_Msg_Count OUT NOCOPY NUMBER,

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

472: PROCEDURE Delete_writeoffs(
473: P_Api_Version_Number IN NUMBER,
474: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
475: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: P_writeoff_id IN NUMBER,
478: X_Return_Status OUT NOCOPY VARCHAR2,
479: X_Msg_Count OUT NOCOPY NUMBER,
480: X_Msg_Data OUT NOCOPY VARCHAR2

Line 499: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

495: -- Standard Start of API savepoint
496: SAVEPOINT DELETE_WRITEOFFS_PVT;
497:
498: -- Standard call to check for call compatibility.
499: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
500: p_api_version_number,
501: l_api_name,
502: G_PKG_NAME)
503: THEN

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500: p_api_version_number,
501: l_api_name,
502: G_PKG_NAME)
503: THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 509: IF FND_API.to_Boolean( p_init_msg_list )

505: END IF;
506:
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.
509: IF FND_API.to_Boolean( p_init_msg_list )
510: THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:

Line 517: x_return_status := FND_API.G_RET_STS_SUCCESS;

513:
514:
515:
516: -- Initialize API return status to SUCCESS
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518:
519: --
520: -- Api body
521: --

Line 531: IF FND_API.to_Boolean( p_commit )

527: -- End of API body
528: --
529:
530: -- Standard check for p_commit
531: IF FND_API.to_Boolean( p_commit )
532: THEN
533: COMMIT WORK;
534: END IF;
535:

Line 551: WHEN FND_API.G_EXC_ERROR THEN

547: p_data => x_msg_data
548: );
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR