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_COSTS_PVT dependencies on FND_API

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

18: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19:
20: PROCEDURE Create_costs(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
26: X_COST_ID OUT NOCOPY NUMBER,

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

19:
20: PROCEDURE Create_costs(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
26: X_COST_ID OUT NOCOPY NUMBER,
27: X_Return_Status OUT NOCOPY VARCHAR2,

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

20: PROCEDURE Create_costs(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
26: X_COST_ID OUT NOCOPY NUMBER,
27: X_Return_Status OUT NOCOPY VARCHAR2,
28: X_Msg_Count OUT NOCOPY NUMBER,

Line 52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59: -- IF PG_DEBUG < 10 THEN
60: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
61: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After Compatibility Check');

Line 66: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: END IF;
70:
71:
72: -- Initialize API return status to SUCCESS
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: --
76: -- API body
77: --

Line 89: RAISE FND_API.G_EXC_ERROR;

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

Line 96: --IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

92: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
93: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After Global user Check');
94: END IF;
95:
96: --IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
97:
98: --object version Number
99: v_object_version_number :=1;
100: --Active_flag

Line 105: (p_costs_rec.cost_item_approved = FND_API.G_MISS_CHAR)) THEN

101: v_active_flag :='Y';
102:
103: -- set cost_item_approved to 'Y'
104: IF ((p_costs_rec.cost_item_approved IS NULL) OR
105: (p_costs_rec.cost_item_approved = FND_API.G_MISS_CHAR)) THEN
106: v_cost_item_approved :='Y';
107: ELSE
108: v_cost_item_approved :=p_costs_rec.cost_item_approved;
109: End if;

Line 121: IF ((p_costs_rec.case_id IS NULL) OR (p_costs_rec.case_ID = FND_API.G_MISS_NUM))

117: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After cost_id Check and cost_id is => '||v_cost_id);
118: END IF;
119:
120: --check for case_id and delinquency id. Either one of them should be passed.
121: IF ((p_costs_rec.case_id IS NULL) OR (p_costs_rec.case_ID = FND_API.G_MISS_NUM))
122: AND
123: ((p_costs_rec.delinquency_id IS NULL) OR (p_costs_rec.delinquency_ID = FND_API.G_MISS_NUM))
124: THEN
125: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');

Line 123: ((p_costs_rec.delinquency_id IS NULL) OR (p_costs_rec.delinquency_ID = FND_API.G_MISS_NUM))

119:
120: --check for case_id and delinquency id. Either one of them should be passed.
121: IF ((p_costs_rec.case_id IS NULL) OR (p_costs_rec.case_ID = FND_API.G_MISS_NUM))
122: AND
123: ((p_costs_rec.delinquency_id IS NULL) OR (p_costs_rec.delinquency_ID = FND_API.G_MISS_NUM))
124: 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', 'case_id/delinquency_id');

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', 'case_id/delinquency_id');
128: fnd_msg_pub.add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131: -- IF PG_DEBUG < 10 THEN
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After CASE ID and DELINQUENCY_ID Check ');

Line 137: IF (p_costs_rec.cost_type_code IS NULL) OR (p_costs_rec.cost_type_code = FND_API.G_MISS_CHAR) THEN

133: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After CASE ID and DELINQUENCY_ID Check ');
134: END IF;
135:
136: --check for cost_type_code
137: IF (p_costs_rec.cost_type_code IS NULL) OR (p_costs_rec.cost_type_code = FND_API.G_MISS_CHAR) 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', 'cost_type_code');
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', 'cost_type_code');
141: fnd_msg_pub.add;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144: -- IF PG_DEBUG < 10 THEN
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After cost_type_code Check ');

Line 150: IF (p_costs_rec.cost_item_type_code IS NULL) OR (p_costs_rec.cost_item_type_code = FND_API.G_MISS_CHAR) THEN

146: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After cost_type_code Check ');
147: END IF;
148:
149: --check for cost_item type_code
150: IF (p_costs_rec.cost_item_type_code IS NULL) OR (p_costs_rec.cost_item_type_code = FND_API.G_MISS_CHAR) THEN
151: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
152: fnd_message.set_token('API_NAME', l_api_name);
153: fnd_message.set_token('MISSING_PARAM', 'cost_item_type_code');
154: fnd_msg_pub.add;

Line 155: RAISE FND_API.G_EXC_ERROR;

151: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
152: fnd_message.set_token('API_NAME', l_api_name);
153: fnd_message.set_token('MISSING_PARAM', 'cost_item_type_code');
154: fnd_msg_pub.add;
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157: -- IF PG_DEBUG < 10 THEN
158: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
159: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After cost_item_type_code Check ');

Line 218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After Calling IEX_COSTS_PKG.Insert_Row'
215: ||' and cost id => ' ||v_cost_id);
216: END IF;
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: --

Line 219: RAISE FND_API.G_EXC_ERROR;

215: ||' and cost id => ' ||v_cost_id);
216: END IF;
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: --
223: -- End of API body

Line 227: IF FND_API.to_Boolean( p_commit )

223: -- End of API body
224: --
225:
226: -- Standard check for p_commit
227: IF FND_API.to_Boolean( p_commit )
228: THEN
229: COMMIT WORK;
230: END IF;
231:

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
241: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PVT.Create_costs ******** ');
242: END IF;
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
246: P_API_NAME => L_API_NAME
247: ,P_PKG_NAME => G_PKG_NAME
248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

250: ,X_MSG_COUNT => X_MSG_COUNT
251: ,X_MSG_DATA => X_MSG_DATA
252: ,X_RETURN_STATUS => X_RETURN_STATUS);
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
256: P_API_NAME => L_API_NAME
257: ,P_PKG_NAME => G_PKG_NAME
258: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

278:
279:
280: PROCEDURE Update_costs(
281: P_Api_Version_Number IN NUMBER,
282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
283: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: P_costs_Rec IN costs_Rec_Type,
286: X_Return_Status OUT NOCOPY VARCHAR2,

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

279:
280: PROCEDURE Update_costs(
281: P_Api_Version_Number IN NUMBER,
282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
283: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: P_costs_Rec IN costs_Rec_Type,
286: X_Return_Status OUT NOCOPY VARCHAR2,
287: X_Msg_Count OUT NOCOPY NUMBER,

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

280: PROCEDURE Update_costs(
281: P_Api_Version_Number IN NUMBER,
282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
283: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: P_costs_Rec IN costs_Rec_Type,
286: X_Return_Status OUT NOCOPY VARCHAR2,
287: X_Msg_Count OUT NOCOPY NUMBER,
288: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

302: -- Standard Start of API savepoint
303: SAVEPOINT UPDATE_COSTS_PVT;
304:
305: -- Standard call to check for call compatibility.
306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
307: p_api_version_number,
308: l_api_name,
309: G_PKG_NAME)
310: THEN

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307: p_api_version_number,
308: l_api_name,
309: G_PKG_NAME)
310: THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314:
315: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 316: IF FND_API.to_Boolean( p_init_msg_list )

312: END IF;
313:
314:
315: -- Initialize message list if p_init_msg_list is set to TRUE.
316: IF FND_API.to_Boolean( p_init_msg_list )
317: THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320:

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320:
321:
322:
323: -- Initialize API return status to SUCCESS
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: --
327: -- Api body
328: --

Line 388: IF FND_API.to_Boolean( p_commit )

384: -- End of API body.
385: --
386:
387: -- Standard check for p_commit
388: IF FND_API.to_Boolean( p_commit )
389: THEN
390: COMMIT WORK;
391: END IF;
392:

Line 405: WHEN FND_API.G_EXC_ERROR THEN

401: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
402: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_COSTS_PVT.update_costs ******** ');
403: END IF;
404: EXCEPTION
405: WHEN FND_API.G_EXC_ERROR THEN
406: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
407: P_API_NAME => L_API_NAME
408: ,P_PKG_NAME => G_PKG_NAME
409: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: ,X_MSG_COUNT => X_MSG_COUNT
412: ,X_MSG_DATA => X_MSG_DATA
413: ,X_RETURN_STATUS => X_RETURN_STATUS);
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
417: P_API_NAME => L_API_NAME
418: ,P_PKG_NAME => G_PKG_NAME
419: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

439: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
440: -- The Master delete procedure may not be needed depends on different business requirements.
441: PROCEDURE Delete_costs(
442: P_Api_Version_Number IN NUMBER,
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: P_cost_id IN NUMBER,
447: X_Return_Status OUT NOCOPY VARCHAR2,

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

440: -- The Master delete procedure may not be needed depends on different business requirements.
441: PROCEDURE Delete_costs(
442: P_Api_Version_Number IN NUMBER,
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: P_cost_id IN NUMBER,
447: X_Return_Status OUT NOCOPY VARCHAR2,
448: X_Msg_Count OUT NOCOPY NUMBER,

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

441: PROCEDURE Delete_costs(
442: P_Api_Version_Number IN NUMBER,
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: P_cost_id IN NUMBER,
447: X_Return_Status OUT NOCOPY VARCHAR2,
448: X_Msg_Count OUT NOCOPY NUMBER,
449: X_Msg_Data OUT NOCOPY VARCHAR2

Line 465: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

461: -- Standard Start of API savepoint
462: SAVEPOINT DELETE_COSTS_PVT;
463:
464: -- Standard call to check for call compatibility.
465: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
466: p_api_version_number,
467: l_api_name,
468: G_PKG_NAME)
469: THEN

Line 470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

466: p_api_version_number,
467: l_api_name,
468: G_PKG_NAME)
469: THEN
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473:
474: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 475: IF FND_API.to_Boolean( p_init_msg_list )

471: END IF;
472:
473:
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list )
476: THEN
477: FND_MSG_PUB.initialize;
478: END IF;
479:

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: FND_MSG_PUB.initialize;
478: END IF;
479:
480: -- Initialize API return status to SUCCESS
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: --
484: -- Api body
485: --

Line 495: IF FND_API.to_Boolean( p_commit )

491: -- End of API body
492: --
493:
494: -- Standard check for p_commit
495: IF FND_API.to_Boolean( p_commit )
496: THEN
497: COMMIT WORK;
498: END IF;
499:

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PVT.delete_costs ******** ');
509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
524: P_API_NAME => L_API_NAME
525: ,P_PKG_NAME => G_PKG_NAME
526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR