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_MSG_PUB

Line 157: FND_MSG_PUB.initialize;

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:
160: -- Debug Message
161: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' start');

Line 161: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' start');

157: FND_MSG_PUB.initialize;
158: END IF;
159:
160: -- Debug Message
161: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' start');
162:
163: --
164: -- API body
165: --

Line 169: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Calling Process Inv Payments');

165: --
166:
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,

Line 179: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Process Inv Payments returns ' || l_return_status);

175: X_MSG_COUNT => l_msg_count,
176: X_MSG_DATA => l_msg_data,
177: P_PAYMENTS_TBL => p_payments_tbl);
178:
179: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Process Inv Payments returns ' || l_return_status);
180:
181: IF l_return_status <> 'S' THEN
182: NULL;
183: -- log error

Line 186: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'pay count is ' || l_num_payments);

182: NULL;
183: -- log error
184: END IF;
185:
186: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'pay count is ' || l_num_payments);
187:
188: -- get all delinquency IDs to be closed
189: IF l_num_payments >= 1 THEN
190: FOR i in 1..l_num_payments LOOP

Line 192: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'before open del cursor');

188: -- get all delinquency IDs to be closed
189: IF l_num_payments >= 1 THEN
190: FOR i in 1..l_num_payments LOOP
191:
192: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'before open del cursor');
193: select delinquency_id into l_del_id
194: from iex_delinquencies
195: where payment_schedule_id = p_payments_tbl(i);
196:

Line 204: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'callling close dunnings');

200: ELSE
201: NULL;
202: END IF;
203:
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

Line 216: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Close dunning returns ' || l_return_status);

212: ,x_return_status => l_return_status
213: ,x_msg_count => l_msg_count
214: ,x_msg_data => l_msg_data);
215:
216: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Close dunning returns ' || l_return_status);
217:
218: IF l_return_status <> 'S' THEN
219: NULL;
220: -- log error

Line 223: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'before update');

219: NULL;
220: -- log error
221: END IF;
222:
223: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'before update');
224:
225: -- now update the delinquencies table
226: nCount := l_del_tbl.count;
227:

Line 238: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after update');

234: WHERE DELINQUENCY_ID = l_del_tbl(j);
235:
236: end if;
237:
238: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after update');
239: COMMIT;
240:
241: x_return_status := l_return_status;
242:

Line 248: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' end');

244: -- End of API body
245: --
246:
247: -- Debug Message
248: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' end');
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count,

Line 251: FND_MSG_PUB.Count_And_Get

247: -- Debug Message
248: IEX_DEBUG_PUB.LogMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PVT: ' || l_api_name || ' end');
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255:

Line 261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
262: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
263: ,X_MSG_COUNT => X_MSG_COUNT
264: ,X_MSG_DATA => X_MSG_DATA
265: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 271: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
272: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
273: ,X_MSG_COUNT => X_MSG_COUNT
274: ,X_MSG_DATA => X_MSG_DATA
275: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 375: FND_MSG_PUB.Count_And_Get

371: IEX_DEBUG_PUB.logMessage( 'End Raise Delinquency Event program');
372: END IF;
373:
374: -- Standard call to get message count and if count is 1, get message info.
375: FND_MSG_PUB.Count_And_Get
376: ( p_count => x_msg_count,
377: p_data => x_msg_data
378: );
379:

Line 389: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
393:

Line 1867: FND_MSG_PUB.initialize;

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
1871: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2001: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1997:
1998: -- Debug Message
1999: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
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

Line 2233: FND_MSG_PUB.initialize;

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
2237: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2254: FND_MSG_PUB.Add;

2250: END IF;
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

Line 2271: FND_MSG_PUB.Add;

2267: END IF;
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

Line 2288: FND_MSG_PUB.Add;

2284: END IF;
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

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 2498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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;
2502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2502: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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;
2506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
2510: end;

Line 2507: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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);
2510: end;
2511:

Line 2509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
2510: end;
2511:
2512: /*------------------------------------------------------------------------
2513: CLOSE Dunnings Process