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

Line 11: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,

7:
8: PROCEDURE invoke_new_del_status_wf
9: (
10: p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
12: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
13: p_delinquency_id IN NUMBER,
14: p_object_id IN NUMBER,
15: p_object_type IN VARCHAR2,

Line 12: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,

8: PROCEDURE invoke_new_del_status_wf
9: (
10: p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
12: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
13: p_delinquency_id IN NUMBER,
14: p_object_id IN NUMBER,
15: p_object_type IN VARCHAR2,
16: p_user_id IN NUMBER,

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number2,

61: iex_debug_pub.logmessage('l_api_version_number..'||l_api_version_number||'p_api_version..'||p_api_version);
62: -- Standard call to check for call compatibility.
63:
64: if p_object_type = 'Bankruptcy' then
65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number2,
66: p_api_version,
67: l_api_name,
68: G_PKG_NAME)
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: p_api_version,
67: l_api_name,
68: G_PKG_NAME)
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72: else
73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
74: p_api_version,

Line 73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72: else
73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
74: p_api_version,
75: l_api_name,
76: G_PKG_NAME)
77: THEN

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: p_api_version,
75: l_api_name,
76: G_PKG_NAME)
77: THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80: end if;
81:
82:

Line 85: IF FND_API.to_Boolean( p_init_msg_list )

81:
82:
83: iex_debug_pub.logmessage('IEX-2 Start Invoking Creating New Delinquency Workflow');
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89:
90:
91:
92: -- Initialize API return status to SUCCESS
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: iex_debug_pub.logmessage('IEX- Before getting item key information....');
96:
97: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159: );
160:
161: --Start bug 6740370 gnramasa 11th Jan 08
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO invoke_new_del_status_wf;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167:

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: --Start bug 6740370 gnramasa 11th Jan 08
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO invoke_new_del_status_wf;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO invoke_new_del_status_wf;

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164: ROLLBACK TO invoke_new_del_status_wf;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO invoke_new_del_status_wf;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO invoke_new_del_status_wf;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO invoke_new_del_status_wf;

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO invoke_new_del_status_wf;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
177: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
178: END IF;
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 187: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,

183:
184: PROCEDURE invoke_upd_del_status_wf
185: (
186: p_api_version IN NUMBER := 1.0,
187: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
189: p_delinquency_id IN NUMBER,
190: p_object_id IN NUMBER,
191: p_object_type IN VARCHAR2,

Line 188: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,

184: PROCEDURE invoke_upd_del_status_wf
185: (
186: p_api_version IN NUMBER := 1.0,
187: p_init_msg_list IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2, -- fix a bug 3975142 := FND_API.G_FALSE,
189: p_delinquency_id IN NUMBER,
190: p_object_id IN NUMBER,
191: p_object_type IN VARCHAR2,
192: p_user_id IN NUMBER,

Line 237: IF NOT FND_API.Compatible_API_Call ( l_api_version_number2,

233:
234:
235: -- Standard call to check for call compatibility.
236: if p_object_type = 'Bankruptcy' then
237: IF NOT FND_API.Compatible_API_Call ( l_api_version_number2,
238: p_api_version,
239: l_api_name,
240: G_PKG_NAME)
241: THEN

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: p_api_version,
239: l_api_name,
240: G_PKG_NAME)
241: THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: else
245: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
246: p_api_version,

Line 245: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

241: THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: else
245: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
246: p_api_version,
247: l_api_name,
248: G_PKG_NAME)
249: THEN

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

246: p_api_version,
247: l_api_name,
248: G_PKG_NAME)
249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252: end if;
253:
254:

Line 256: IF FND_API.to_Boolean( p_init_msg_list )

252: end if;
253:
254:
255: -- Initialize message list if p_init_msg_list is set to TRUE.
256: IF FND_API.to_Boolean( p_init_msg_list )
257: THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260:

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260:
261:
262:
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;
267:
268: itemkey := 'NEWST'||TO_CHAR(p_delinquency_id)||itemkey;

Line 322: WHEN FND_API.G_EXC_ERROR THEN

318: );
319:
320: --Start bug 6740370 gnramasa 11th Jan 08
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO invoke_new_del_status_wf;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
326:

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: --Start bug 6740370 gnramasa 11th Jan 08
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO invoke_new_del_status_wf;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO invoke_new_del_status_wf;

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: ROLLBACK TO invoke_new_del_status_wf;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO invoke_new_del_status_wf;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO invoke_new_del_status_wf;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO invoke_new_del_status_wf;

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO invoke_new_del_status_wf;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
336: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
337: END IF;
338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);