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

Line 73: RETCODE := FND_API.G_RET_STS_SUCCESS;

69: begin
70:
71: RETCODE := 0;
72: --SAVEPOINT CLEAN_DEL_BUFFERS_PVT;
73: RETCODE := FND_API.G_RET_STS_SUCCESS;
74: -- IF PG_DEBUG < 10 THEN
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
76: IEX_DEBUG_PUB.logMessage('CLEAR_DEL_BUFFERS: ' || 'IEX_DEL_PUB: cleaning del buffers');
77: END IF;

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: -- Standard Start of API savepoint
139: SAVEPOINT Close_Delinquencies_PVT;
140:
141: -- Initialize API return status to SUCCESS
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 146: IF NOT FND_API.Compatible_API_Call (l_api_version,

142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call (l_api_version,
147: p_api_version,
148: l_api_name,
149: G_PKG_NAME)
150: THEN

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: p_api_version,
148: l_api_name,
149: G_PKG_NAME)
150: THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE.
155: IF FND_API.to_Boolean(p_init_msg_list)

Line 155: IF FND_API.to_Boolean(p_init_msg_list)

151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE.
155: IF FND_API.to_Boolean(p_init_msg_list)
156: THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159:

Line 171: P_INIT_MSG_LIST => FND_API.G_FALSE,

167: l_num_payments := p_payments_tbl.count;
168:
169: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Process Inv Payments');
170: IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES(P_API_VERSION => l_api_version,
171: P_INIT_MSG_LIST => FND_API.G_FALSE,
172: P_COMMIT => FND_API.G_TRUE,
173: P_VALIDATION_LEVEL => NULL,
174: X_RETURN_STATUS => l_return_status,
175: X_MSG_COUNT => l_msg_count,

Line 172: P_COMMIT => FND_API.G_TRUE,

168:
169: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Process Inv Payments');
170: IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES(P_API_VERSION => l_api_version,
171: P_INIT_MSG_LIST => FND_API.G_FALSE,
172: P_COMMIT => FND_API.G_TRUE,
173: P_VALIDATION_LEVEL => NULL,
174: X_RETURN_STATUS => l_return_status,
175: X_MSG_COUNT => l_msg_count,
176: X_MSG_DATA => l_msg_data,

Line 208: ,p_init_msg_list => FND_API.G_FALSE

204: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'callling close dunnings');
205:
206: -- here we will call crystal's API to Close_Dunnings
207: IEX_DUNNING_PUB.Close_Dunning(p_api_version => l_api_version
208: ,p_init_msg_list => FND_API.G_FALSE
209: ,p_commit => FND_API.G_TRUE
210: ,p_delinquencies_tbl => l_del_tbl
211: ,p_security_check => 'N'
212: ,x_return_status => l_return_status

Line 209: ,p_commit => FND_API.G_TRUE

205:
206: -- here we will call crystal's API to Close_Dunnings
207: IEX_DUNNING_PUB.Close_Dunning(p_api_version => l_api_version
208: ,p_init_msg_list => FND_API.G_FALSE
209: ,p_commit => FND_API.G_TRUE
210: ,p_delinquencies_tbl => l_del_tbl
211: ,p_security_check => 'N'
212: ,x_return_status => l_return_status
213: ,x_msg_count => l_msg_count

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: p_data => x_msg_data
254: );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
259: P_API_NAME => L_API_NAME
260: ,P_PKG_NAME => G_PKG_NAME
261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: ,X_MSG_COUNT => X_MSG_COUNT
264: ,X_MSG_DATA => X_MSG_DATA
265: ,X_RETURN_STATUS => X_RETURN_STATUS);
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
269: P_API_NAME => L_API_NAME
270: ,P_PKG_NAME => G_PKG_NAME
271: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: l_return_status VARCHAR2(1);
321: BEGIN
322:
323: -- Initialize API return status to SUCCESS
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: l_request_id :=p_request_id;
327: l_del_create_count := p_del_create_count ;
328: l_del_update_count := p_del_update_count ;

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: || sqlerrm);
385: END IF;
386: x_msg_count := 1 ;
387: x_msg_data := sqlerrm ;
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: END RAISE_EVENT;

Line 1589: p_init_msg_list => FND_API.G_FALSE,

1585:
1586: -- Launch the WorkFlow
1587: IEX_WF_DEL_CUR_STATUS_NOTE_PUB.START_WORKFLOW
1588: (p_api_version => 1.0,
1589: p_init_msg_list => FND_API.G_FALSE,
1590: p_commit => FND_API.G_FALSE,
1591: p_delinquency_ids => vt_wf_del_id,
1592: x_return_status => l_return_status,
1593: x_msg_count => l_msg_count,

Line 1590: p_commit => FND_API.G_FALSE,

1586: -- Launch the WorkFlow
1587: IEX_WF_DEL_CUR_STATUS_NOTE_PUB.START_WORKFLOW
1588: (p_api_version => 1.0,
1589: p_init_msg_list => FND_API.G_FALSE,
1590: p_commit => FND_API.G_FALSE,
1591: p_delinquency_ids => vt_wf_del_id,
1592: x_return_status => l_return_status,
1593: x_msg_count => l_msg_count,
1594: x_msg_data => l_msg_data);

Line 1604: p_init_msg_list => FND_API.G_FALSE,

1600:
1601: -- Close the Promises
1602: IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES
1603: (p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_FALSE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status => l_return_status,
1608: x_msg_count => l_msg_count,

Line 1605: p_commit => FND_API.G_FALSE,

1601: -- Close the Promises
1602: IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES
1603: (p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_FALSE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status => l_return_status,
1608: x_msg_count => l_msg_count,
1609: x_msg_data => l_msg_data ,

Line 1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1602: IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES
1603: (p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_FALSE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status => l_return_status,
1608: x_msg_count => l_msg_count,
1609: x_msg_data => l_msg_data ,
1610: p_delinq_tbl => vt_wf_del_id );

Line 1824: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1820: x_msg_data => l_msg_data );
1821:
1822:
1823: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1824: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1825: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1826: else
1827: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1828: request_status := fnd_concurrent.set_completion_status('WARNING'

Line 1930: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

1926: -- Standard Start of API savepoint
1927: SAVEPOINT IEX_IND_DEL ;
1928:
1929: -- Standard call to check for call compatibility.
1930: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
1931: p_api_version,
1932: l_api_name,
1933: G_PKG_NAME)
1934: THEN

Line 1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1931: p_api_version,
1932: l_api_name,
1933: G_PKG_NAME)
1934: THEN
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;
1937:
1938: -- Initialize message list if p_init_msg_list is set to TRUE.
1939: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1939: IF FND_API.to_Boolean(p_init_msg_list) THEN

1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;
1937:
1938: -- Initialize message list if p_init_msg_list is set to TRUE.
1939: IF FND_API.to_Boolean(p_init_msg_list) THEN
1940: FND_MSG_PUB.initialize;
1941: END IF;
1942:
1943: -- Initialize API return status to SUCCESS

Line 1944: x_return_status := FND_API.G_RET_STS_SUCCESS;

1940: FND_MSG_PUB.initialize;
1941: END IF;
1942:
1943: -- Initialize API return status to SUCCESS
1944: x_return_status := FND_API.G_RET_STS_SUCCESS;
1945:
1946: if x_del_id_tbl.COUNT > 0 then
1947: x_del_id_tbl.DELETE ;
1948: End IF ;

Line 2058: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2054: l_cust_site_use_id) ; --29/12
2055: exception
2056: when others then --29/12
2057: IEX_DEBUG_PUB.LOGMESSAGE('Error in CURRENT invoice selection/insertion activity.....');
2058: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2059: end;--29/12
2060: end loop;
2061: end if;
2062:

Line 2069: IF FND_API.to_Boolean(p_commit) THEN

2065: --End Bug 6446848 08-Dec-2008 barathsr
2066: END IF ;
2067:
2068: -- Standard check for p_commit
2069: IF FND_API.to_Boolean(p_commit) THEN
2070: COMMIT WORK;
2071: ELSE
2072: ROLLBACK TO IEX_IND_DEL ;
2073: END IF;

Line 2081: WHEN FND_API.G_EXC_ERROR THEN

2077: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2078: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2083: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2084: END IF;
2085: RAISE FND_API.G_EXC_ERROR;

Line 2085: RAISE FND_API.G_EXC_ERROR;

2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2083: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2084: END IF;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ROLLBACK TO IEX_IND_DEL;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2084: END IF;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ROLLBACK TO IEX_IND_DEL;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2090: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2091: END IF;
2092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2090: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2091: END IF;
2092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2093: ROLLBACK TO IEX_IND_DEL;
2094:
2095: WHEN OTHERS THEN
2096: v_error_msg := SQLCODE || ' Error Msg ' || SQLERRM ;

Line 2304: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2300: -- Standard start of API savepoint
2301: SAVEPOINT SHOW_IN_UWQ_PVT;
2302:
2303: -- Standard call to check for call compatibility
2304: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: END IF;
2307:
2308: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2301: SAVEPOINT SHOW_IN_UWQ_PVT;
2302:
2303: -- Standard call to check for call compatibility
2304: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: END IF;
2307:
2308: -- Initialize message list if p_init_msg_list is set to TRUE
2309: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2309: IF FND_API.To_Boolean(p_init_msg_list) THEN

2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: END IF;
2307:
2308: -- Initialize message list if p_init_msg_list is set to TRUE
2309: IF FND_API.To_Boolean(p_init_msg_list) THEN
2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2313: -- Initialize API return status to success

Line 2314: l_return_status := FND_API.G_RET_STS_SUCCESS;

2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2313: -- Initialize API return status to success
2314: l_return_status := FND_API.G_RET_STS_SUCCESS;
2315:
2316: -- START OF BODY OF API
2317:
2318: -- validating uwq status

Line 2332: RAISE FND_API.G_EXC_ERROR;

2328: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2329: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2330: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2331: FND_MSG_PUB.Add;
2332: RAISE FND_API.G_EXC_ERROR;
2333: end if;
2334:
2335: -- validating table of promises
2336: l_validation_item := 'P_DELINQUENCY_ID_TBL';

Line 2349: RAISE FND_API.G_EXC_ERROR;

2345: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2346: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2347: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2348: FND_MSG_PUB.Add;
2349: RAISE FND_API.G_EXC_ERROR;
2350: end if;
2351:
2352: -- validating p_days
2353: l_validation_item := 'P_NO_DAYS';

Line 2366: RAISE FND_API.G_EXC_ERROR;

2362: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2363: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2364: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2365: FND_MSG_PUB.Add;
2366: RAISE FND_API.G_EXC_ERROR;
2367: end if;
2368:
2369: -- set number of days
2370: if P_NO_DAYS is null then

Line 2561: IF FND_API.To_Boolean( p_commit ) THEN

2557:
2558: -- END OF BODY OF API
2559:
2560: -- Standard check of p_commit.
2561: IF FND_API.To_Boolean( p_commit ) THEN
2562: COMMIT WORK;
2563: END IF;
2564:
2565: x_return_status := l_return_status;

Line 2567: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2563: END IF;
2564:
2565: x_return_status := l_return_status;
2566: -- Standard call to get message count and if count is 1, get message info
2567: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2568: p_count => x_msg_count,
2569: p_data => x_msg_data);
2570:
2571: EXCEPTION

Line 2572: WHEN FND_API.G_EXC_ERROR THEN

2568: p_count => x_msg_count,
2569: p_data => x_msg_data);
2570:
2571: EXCEPTION
2572: WHEN FND_API.G_EXC_ERROR THEN
2573: ROLLBACK TO SHOW_IN_UWQ_PVT;
2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2574: x_return_status := FND_API.G_RET_STS_ERROR;

2570:
2571: EXCEPTION
2572: WHEN FND_API.G_EXC_ERROR THEN
2573: ROLLBACK TO SHOW_IN_UWQ_PVT;
2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2577: ROLLBACK TO SHOW_IN_UWQ_PVT;
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2572: WHEN FND_API.G_EXC_ERROR THEN
2573: ROLLBACK TO SHOW_IN_UWQ_PVT;
2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2577: ROLLBACK TO SHOW_IN_UWQ_PVT;
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2580: WHEN OTHERS THEN

Line 2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2577: ROLLBACK TO SHOW_IN_UWQ_PVT;
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2580: WHEN OTHERS THEN
2581: ROLLBACK TO SHOW_IN_UWQ_PVT;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2580: WHEN OTHERS THEN
2581: ROLLBACK TO SHOW_IN_UWQ_PVT;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2585: END IF;
2586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);