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_CASE_CONTACTS_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_case_contact(
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_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
25: X_CAS_CONTACT_ID OUT NOCOPY NUMBER,

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

18:
19: PROCEDURE Create_case_contact(
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_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
25: X_CAS_CONTACT_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_case_contact(
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_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
25: X_CAS_CONTACT_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,

Line 68: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

64: -- Standard Start of API savepoint
65: SAVEPOINT CREATE_CASE_CONTACT_PVT;
66:
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
69: p_api_version_number,
70: l_api_name,
71: G_PKG_NAME)
72: THEN

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: p_api_version_number,
70: l_api_name,
71: G_PKG_NAME)
72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- IF PG_DEBUG < 10 THEN
76: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
77: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Compatibility Check');

Line 82: IF FND_API.to_Boolean( p_init_msg_list )

78: END IF;
79:
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: END IF;
86:
87:
88: -- Initialize API return status to SUCCESS
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: --
92: -- API body
93: --

Line 105: RAISE FND_API.G_EXC_ERROR;

101: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
102: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Global user Check');

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

108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Global user Check');
110: END IF;
111:
112: --IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
113:
114: --object version Number
115: v_object_version_number :=1;
116: --Active_flag

Line 128: IF (p_case_contact_rec.cas_id IS NULL) OR (p_case_contact_rec.cas_ID = FND_API.G_MISS_NUM) THEN

124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS CONTACT ID Check and cas_contact_id is => '||v_cas_contact_id);
126: END IF;
127: --check for cas_id
128: IF (p_case_contact_rec.cas_id IS NULL) OR (p_case_contact_rec.cas_ID = FND_API.G_MISS_NUM) THEN
129: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
130: fnd_message.set_token('API_NAME', l_api_name);
131: fnd_message.set_token('MISSING_PARAM', 'cas_id');
132: fnd_msg_pub.add;

Line 133: RAISE FND_API.G_EXC_ERROR;

129: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
130: fnd_message.set_token('API_NAME', l_api_name);
131: fnd_message.set_token('MISSING_PARAM', 'cas_id');
132: fnd_msg_pub.add;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS ID Check ');

Line 140: IF (p_case_contact_rec.contact_party_id IS NULL) OR (p_case_contact_rec.contact_party_id = FND_API.G_MISS_NUM) THEN

136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS ID Check ');
138: END IF;
139: --check for contact_party_id
140: IF (p_case_contact_rec.contact_party_id IS NULL) OR (p_case_contact_rec.contact_party_id = FND_API.G_MISS_NUM) THEN
141: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: fnd_message.set_token('API_NAME', l_api_name);
143: fnd_message.set_token('MISSING_PARAM', 'contact_party_id');
144: fnd_msg_pub.add;

Line 145: RAISE FND_API.G_EXC_ERROR;

141: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: fnd_message.set_token('API_NAME', l_api_name);
143: fnd_message.set_token('MISSING_PARAM', 'contact_party_id');
144: fnd_msg_pub.add;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: -- IF PG_DEBUG < 10 THEN
148: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
149: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS contact ID Check ');

Line 153: OR (p_case_contact_rec.address_id = FND_API.G_MISS_NUM) THEN

149: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS contact ID Check ');
150: END IF;
151: --Populate default address_id if it is not passed
152: IF (p_case_contact_rec.address_id IS NULL)
153: OR (p_case_contact_rec.address_id = FND_API.G_MISS_NUM) THEN
154: OPEN C_GET_ADDRESS(p_case_contact_rec.CONTACT_PARTY_ID);
155: FETCH C_GET_ADDRESS INTO v_address_id;
156: CLOSE C_GET_ADDRESS;
157: ELSE

Line 162: OR (p_case_contact_rec.phone_id = FND_API.G_MISS_NUM) THEN

158: v_address_id :=p_case_contact_rec.address_id;
159: END IF;
160: --Populate default phone_id if it is not passed
161: IF (p_case_contact_rec.phone_id IS NULL)
162: OR (p_case_contact_rec.phone_id = FND_API.G_MISS_NUM) THEN
163: OPEN C_GET_phone(p_case_contact_rec.CONTACT_PARTY_ID);
164: FETCH C_GET_phone INTO v_phone_id;
165: CLOSE C_GET_phone;
166: ELSE

Line 171: OR (p_case_contact_rec.primary_flag = FND_API.G_MISS_CHAR) THEN

167: v_phone_id :=p_case_contact_rec.phone_id;
168: END IF;
169: -- Primary flag // added on 01/07/02
170: IF (p_case_contact_rec.primary_flag IS NULL)
171: OR (p_case_contact_rec.primary_flag = FND_API.G_MISS_CHAR) THEN
172: v_primary_flag :='N';
173: ELSE
174: v_primary_flag :=p_case_contact_rec.primary_flag;
175: END IF;

Line 226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Calling IEX_CASE_CONTACTS_PKG.Insert_Row and cas Contact id => '
224: ||x_cas_contact_id);
225: END IF;
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:
230: --

Line 227: RAISE FND_API.G_EXC_ERROR;

223: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Calling IEX_CASE_CONTACTS_PKG.Insert_Row and cas Contact id => '
224: ||x_cas_contact_id);
225: END IF;
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:
230: --
231: -- End of API body

Line 235: IF FND_API.to_Boolean( p_commit )

231: -- End of API body
232: --
233:
234: -- Standard check for p_commit
235: IF FND_API.to_Boolean( p_commit )
236: THEN
237: COMMIT WORK;
238: END IF;
239:

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
249: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ******** ');
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

285:
286: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
287: PROCEDURE Update_case_contact(
288: P_Api_Version_Number IN NUMBER,
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292: P_case_contact_Rec IN case_contact_Rec_Type,
293: X_Return_Status OUT NOCOPY VARCHAR2,

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

286: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
287: PROCEDURE Update_case_contact(
288: P_Api_Version_Number IN NUMBER,
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292: P_case_contact_Rec IN case_contact_Rec_Type,
293: X_Return_Status OUT NOCOPY VARCHAR2,
294: X_Msg_Count OUT NOCOPY NUMBER,

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

287: PROCEDURE Update_case_contact(
288: P_Api_Version_Number IN NUMBER,
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
291: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
292: P_case_contact_Rec IN case_contact_Rec_Type,
293: X_Return_Status OUT NOCOPY VARCHAR2,
294: X_Msg_Count OUT NOCOPY NUMBER,
295: 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_case_contact_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 385: IF FND_API.to_Boolean( p_commit )

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

Line 402: WHEN FND_API.G_EXC_ERROR THEN

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

Line 412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

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

438: PROCEDURE Delete_case_contact(
439: P_Api_Version_Number IN NUMBER,
440: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
441: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: P_cas_contact_ID IN NUMBER,
444: X_Return_Status OUT NOCOPY VARCHAR2,
445: X_Msg_Count OUT NOCOPY NUMBER,
446: X_Msg_Data OUT NOCOPY VARCHAR2

Line 462: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 472: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 492: IF FND_API.to_Boolean( p_commit )

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

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
506: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');
507: END IF;
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_API_NAME => L_API_NAME
512: ,P_PKG_NAME => G_PKG_NAME
513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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