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 1586: p_init_msg_list => FND_API.G_FALSE,

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

Line 1587: p_commit => FND_API.G_FALSE,

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

Line 1601: p_init_msg_list => FND_API.G_FALSE,

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

Line 1602: p_commit => FND_API.G_FALSE,

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

Line 1603: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 1752: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1748: x_msg_data => l_msg_data );
1749:
1750:
1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1753: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1754: else
1755: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1756: request_status := fnd_concurrent.set_completion_status('WARNING'

Line 1857: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

1853: -- Standard Start of API savepoint
1854: SAVEPOINT IEX_IND_DEL ;
1855:
1856: -- Standard call to check for call compatibility.
1857: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
1858: p_api_version,
1859: l_api_name,
1860: G_PKG_NAME)
1861: THEN

Line 1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1858: p_api_version,
1859: l_api_name,
1860: G_PKG_NAME)
1861: THEN
1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1863: END IF;
1864:
1865: -- Initialize message list if p_init_msg_list is set to TRUE.
1866: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1866: IF FND_API.to_Boolean(p_init_msg_list) THEN

1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1863: END IF;
1864:
1865: -- Initialize message list if p_init_msg_list is set to TRUE.
1866: IF FND_API.to_Boolean(p_init_msg_list) THEN
1867: FND_MSG_PUB.initialize;
1868: END IF;
1869:
1870: -- Initialize API return status to SUCCESS

Line 1871: x_return_status := FND_API.G_RET_STS_SUCCESS;

1867: FND_MSG_PUB.initialize;
1868: END IF;
1869:
1870: -- Initialize API return status to SUCCESS
1871: x_return_status := FND_API.G_RET_STS_SUCCESS;
1872:
1873: if x_del_id_tbl.COUNT > 0 then
1874: x_del_id_tbl.DELETE ;
1875: End IF ;

Line 1981: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1977: l_cust_site_use_id) ; --29/12
1978: exception
1979: when others then --29/12
1980: IEX_DEBUG_PUB.LOGMESSAGE('Error in CURRENT invoice selection/insertion activity.....');
1981: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1982: end;--29/12
1983: end loop;
1984: end if;
1985:

Line 1992: IF FND_API.to_Boolean(p_commit) THEN

1988: --End Bug 6446848 08-Dec-2008 barathsr
1989: END IF ;
1990:
1991: -- Standard check for p_commit
1992: IF FND_API.to_Boolean(p_commit) THEN
1993: COMMIT WORK;
1994: ELSE
1995: ROLLBACK TO IEX_IND_DEL ;
1996: END IF;

Line 2004: WHEN FND_API.G_EXC_ERROR THEN

2000: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2001: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2002:
2003: EXCEPTION
2004: WHEN FND_API.G_EXC_ERROR THEN
2005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2006: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2007: END IF;
2008: RAISE FND_API.G_EXC_ERROR;

Line 2008: RAISE FND_API.G_EXC_ERROR;

2004: WHEN FND_API.G_EXC_ERROR THEN
2005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2006: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2007: END IF;
2008: RAISE FND_API.G_EXC_ERROR;
2009: ROLLBACK TO IEX_IND_DEL;
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2007: END IF;
2008: RAISE FND_API.G_EXC_ERROR;
2009: ROLLBACK TO IEX_IND_DEL;
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2013: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2014: END IF;
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2013: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2014: END IF;
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: ROLLBACK TO IEX_IND_DEL;
2017:
2018: WHEN OTHERS THEN
2019: v_error_msg := SQLCODE || ' Error Msg ' || SQLERRM ;

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

2223: -- Standard start of API savepoint
2224: SAVEPOINT SHOW_IN_UWQ_PVT;
2225:
2226: -- Standard call to check for call compatibility
2227: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2224: SAVEPOINT SHOW_IN_UWQ_PVT;
2225:
2226: -- Standard call to check for call compatibility
2227: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231: -- Initialize message list if p_init_msg_list is set to TRUE
2232: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2232: IF FND_API.To_Boolean(p_init_msg_list) THEN

2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231: -- Initialize message list if p_init_msg_list is set to TRUE
2232: IF FND_API.To_Boolean(p_init_msg_list) THEN
2233: FND_MSG_PUB.initialize;
2234: END IF;
2235:
2236: -- Initialize API return status to success

Line 2237: l_return_status := FND_API.G_RET_STS_SUCCESS;

2233: FND_MSG_PUB.initialize;
2234: END IF;
2235:
2236: -- Initialize API return status to success
2237: l_return_status := FND_API.G_RET_STS_SUCCESS;
2238:
2239: -- START OF BODY OF API
2240:
2241: -- validating uwq status

Line 2255: RAISE FND_API.G_EXC_ERROR;

2251: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2252: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2253: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: end if;
2257:
2258: -- validating table of promises
2259: l_validation_item := 'P_DELINQUENCY_ID_TBL';

Line 2272: RAISE FND_API.G_EXC_ERROR;

2268: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2269: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2270: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2271: FND_MSG_PUB.Add;
2272: RAISE FND_API.G_EXC_ERROR;
2273: end if;
2274:
2275: -- validating p_days
2276: l_validation_item := 'P_NO_DAYS';

Line 2289: RAISE FND_API.G_EXC_ERROR;

2285: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2286: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
2287: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2288: FND_MSG_PUB.Add;
2289: RAISE FND_API.G_EXC_ERROR;
2290: end if;
2291:
2292: -- set number of days
2293: if P_NO_DAYS is null then

Line 2484: IF FND_API.To_Boolean( p_commit ) THEN

2480:
2481: -- END OF BODY OF API
2482:
2483: -- Standard check of p_commit.
2484: IF FND_API.To_Boolean( p_commit ) THEN
2485: COMMIT WORK;
2486: END IF;
2487:
2488: x_return_status := l_return_status;

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

2486: END IF;
2487:
2488: x_return_status := l_return_status;
2489: -- Standard call to get message count and if count is 1, get message info
2490: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2491: p_count => x_msg_count,
2492: p_data => x_msg_data);
2493:
2494: EXCEPTION

Line 2495: WHEN FND_API.G_EXC_ERROR THEN

2491: p_count => x_msg_count,
2492: p_data => x_msg_data);
2493:
2494: EXCEPTION
2495: WHEN FND_API.G_EXC_ERROR THEN
2496: ROLLBACK TO SHOW_IN_UWQ_PVT;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2497: x_return_status := FND_API.G_RET_STS_ERROR;

2493:
2494: EXCEPTION
2495: WHEN FND_API.G_EXC_ERROR THEN
2496: ROLLBACK TO SHOW_IN_UWQ_PVT;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2500: ROLLBACK TO SHOW_IN_UWQ_PVT;
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2495: WHEN FND_API.G_EXC_ERROR THEN
2496: ROLLBACK TO SHOW_IN_UWQ_PVT;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2500: ROLLBACK TO SHOW_IN_UWQ_PVT;
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2503: WHEN OTHERS THEN

Line 2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2500: ROLLBACK TO SHOW_IN_UWQ_PVT;
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2503: WHEN OTHERS THEN
2504: ROLLBACK TO SHOW_IN_UWQ_PVT;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2503: WHEN OTHERS THEN
2504: ROLLBACK TO SHOW_IN_UWQ_PVT;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2507: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2508: END IF;
2509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);