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.INL_TCAMERGE_GRP dependencies on INL_LOGGING_PVT

Line 86: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,

82: --
83: BEGIN
84: --{
85: -- Standard Beginning of Procedure/Function Logging
86: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
87: p_procedure_name => l_proc_name) ;
88:
89: -- Standard Start of API savepoint
90: SAVEPOINT Merge_Vendors_GRP;

Line 98: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95: --
96:
97: -- Logging variables
98: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
99: p_procedure_name => l_proc_name,
100: p_var_name => 'p_from_id',
101: p_var_value => p_from_id);
102: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 102: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

98: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
99: p_procedure_name => l_proc_name,
100: p_var_name => 'p_from_id',
101: p_var_value => p_from_id);
102: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
103: p_procedure_name => l_proc_name,
104: p_var_name => 'p_to_id',
105: p_var_value => p_to_id) ;
106: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 106: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

102: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
103: p_procedure_name => l_proc_name,
104: p_var_name => 'p_to_id',
105: p_var_value => p_to_id) ;
106: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
107: p_procedure_name => l_proc_name,
108: p_var_name => 'p_from_party_id',
109: p_var_value => p_from_party_id) ;
110: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 110: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

106: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
107: p_procedure_name => l_proc_name,
108: p_var_name => 'p_from_party_id',
109: p_var_value => p_from_party_id) ;
110: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
111: p_procedure_name => l_proc_name,
112: p_var_name => 'p_to_party_id',
113: p_var_value => p_to_party_id) ;
114: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 114: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

110: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
111: p_procedure_name => l_proc_name,
112: p_var_name => 'p_to_party_id',
113: p_var_value => p_to_party_id) ;
114: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
115: p_procedure_name => l_proc_name,
116: p_var_name => 'p_from_site_id',
117: p_var_value => p_from_site_id) ;
118: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 118: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

114: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
115: p_procedure_name => l_proc_name,
116: p_var_name => 'p_from_site_id',
117: p_var_value => p_from_site_id) ;
118: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
119: p_procedure_name => l_proc_name,
120: p_var_name => 'p_to_site_id',
121: p_var_value => p_to_site_id) ;
122: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 122: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

118: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
119: p_procedure_name => l_proc_name,
120: p_var_name => 'p_to_site_id',
121: p_var_value => p_to_site_id) ;
122: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
123: p_procedure_name => l_proc_name,
124: p_var_name => 'p_from_party_site_id',
125: p_var_value => p_from_party_site_id) ;
126: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 126: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

122: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
123: p_procedure_name => l_proc_name,
124: p_var_name => 'p_from_party_site_id',
125: p_var_value => p_from_party_site_id) ;
126: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
127: p_procedure_name => l_proc_name,
128: p_var_name => 'p_to_party_site_id',
129: p_var_value => p_to_party_site_id) ;
130: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 130: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

126: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
127: p_procedure_name => l_proc_name,
128: p_var_name => 'p_to_party_site_id',
129: p_var_value => p_to_party_site_id) ;
130: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
131: p_procedure_name => l_proc_name,
132: p_var_name => 'p_calling_mode',
133: p_var_value => p_calling_mode) ;
134:

Line 146: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

142: FETCH c_simulations BULK COLLECT INTO l_simulation_list;
143: CLOSE c_simulations;
144:
145: l_debug_info := 'Count of Rows fetched from Cursor C_SIMULATIONS = '||l_simulation_list.count;
146: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
147: p_procedure_name => l_proc_name,
148: p_debug_info => l_debug_info) ;
149:
150: IF l_simulation_list.COUNT > 0 THEN

Line 165: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

161: last_update_login = fnd_global.login_id
162: WHERE simulation_id = l_simulation_list(j);
163:
164: l_debug_info := 'Updated inl_simulations. Number of Rows updated is ' || sql%rowcount;
165: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
166: p_procedure_name => l_proc_name,
167: p_debug_info => l_debug_info) ;
168: END IF;
169: --}

Line 177: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

173: FETCH c_line_groups BULK COLLECT INTO l_line_group_list;
174: CLOSE c_line_groups;
175:
176: l_debug_info := 'Count of Rows fetched from Cursor C_LINE_GROUPS = '||l_line_group_list.count;
177: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
178: p_procedure_name => l_proc_name,
179: p_debug_info => l_debug_info) ;
180:
181: IF l_line_group_list.COUNT > 0 THEN

Line 196: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

192: last_update_login = fnd_global.login_id
193: WHERE ship_line_group_id = l_line_group_list(j);
194:
195: l_debug_info := 'Updated inl_ship_line_groups. Number of Rows updated is ' || sql%rowcount;
196: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
197: p_procedure_name => l_proc_name,
198: p_debug_info => l_debug_info) ;
199: END IF;
200: --}

Line 208: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

204: FETCH c_lines BULK COLLECT INTO l_line_list;
205: CLOSE c_lines;
206:
207: l_debug_info := 'Count of Rows fetched from Cursor C_LINES = ' || l_line_list.count;
208: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
209: p_procedure_name => l_proc_name,
210: p_debug_info => l_debug_info) ;
211:
212: IF l_line_list.COUNT > 0 THEN

Line 231: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

227: last_update_login = fnd_global.login_id
228: WHERE ship_line_id = l_line_list(j);
229:
230: l_debug_info := 'Updated inl_ship_lines_all. Number of Rows updated is ' || sql%rowcount;
231: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
232: p_procedure_name => l_proc_name,
233: p_debug_info => l_debug_info) ;
234: END IF;
235: --}

Line 243: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

239: FETCH c_charge_lines BULK COLLECT INTO l_charge_line_list;
240: CLOSE c_charge_lines;
241:
242: l_debug_info := 'Count of Rows fetched from Cursor C_CHARGE_LINES = ' || l_charge_line_list.count;
243: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
244: p_procedure_name => l_proc_name,
245: p_debug_info => l_debug_info) ;
246:
247: IF l_charge_line_list.COUNT > 0 THEN

Line 265: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

261: last_update_login = fnd_global.login_id
262: WHERE charge_line_id = l_charge_line_list(j);
263:
264: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
265: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
266: p_procedure_name => l_proc_name,
267: p_debug_info => l_debug_info) ;
268: END IF;
269: --}

Line 277: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

273: FETCH c_matches BULK COLLECT INTO l_match_list;
274: CLOSE c_matches;
275:
276: l_debug_info := 'Count of Rows fetched from Cursor C_MATCHES = '||l_match_list.count;
277: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
278: p_procedure_name => l_proc_name,
279: p_debug_info => l_debug_info) ;
280:
281: IF l_match_list.COUNT > 0 THEN

Line 296: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

292: last_update_login = fnd_global.login_id
293: WHERE match_id = l_match_list(j);
294:
295: l_debug_info := 'Updated inl_matches. Number of Rows updated is ' || sql%rowcount;
296: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
297: p_procedure_name => l_proc_name,
298: p_debug_info => l_debug_info) ;
299: END IF;
300: --}

Line 305: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

301: --}
302: END IF;
303: --
304: l_debug_info := 'x_return_status '||x_return_status;
305: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
306: p_procedure_name => l_proc_name,
307: p_debug_info => l_debug_info) ;
308:
309: -- Standard End of Procedure/Function Logging

Line 310: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

306: p_procedure_name => l_proc_name,
307: p_debug_info => l_debug_info) ;
308:
309: -- Standard End of Procedure/Function Logging
310: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
311: p_procedure_name => l_proc_name) ;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN

Line 316: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: -- Standard Expected Error Logging
316: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
317: p_procedure_name => l_proc_name);
318: ROLLBACK TO Merge_Vendors_GRP;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320:

Line 323: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

319: x_return_status := FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: -- Standard Unexpected Error Logging
323: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
324: p_procedure_name => l_proc_name);
325: ROLLBACK TO Merge_Vendors_GRP;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327:

Line 330: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327:
328: WHEN OTHERS THEN
329: -- Standard Unexpected Error Logging
330: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
331: p_procedure_name => l_proc_name);
332: ROLLBACK TO Merge_Vendors_GRP;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 401: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,

397: --
398: BEGIN
399: --{
400: -- Standard Beginning of Procedure/Function Logging
401: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
402: p_procedure_name => l_proc_name);
403:
404: -- Standard Start of API savepoint
405: SAVEPOINT Merge_VendorParties_GRP;

Line 412: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: --
410:
411: -- Logging variables
412: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
413: p_procedure_name => l_proc_name,
414: p_var_name => 'p_from_vendor_id',
415: p_var_value => p_from_vendor_id);
416: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 416: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

412: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
413: p_procedure_name => l_proc_name,
414: p_var_name => 'p_from_vendor_id',
415: p_var_value => p_from_vendor_id);
416: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
417: p_procedure_name => l_proc_name,
418: p_var_name => 'p_to_vendor_id',
419: p_var_value => p_to_vendor_id) ;
420: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 420: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

416: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
417: p_procedure_name => l_proc_name,
418: p_var_name => 'p_to_vendor_id',
419: p_var_value => p_to_vendor_id) ;
420: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
421: p_procedure_name => l_proc_name,
422: p_var_name => 'p_from_party_id',
423: p_var_value => p_from_party_id) ;
424: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 424: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

420: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
421: p_procedure_name => l_proc_name,
422: p_var_name => 'p_from_party_id',
423: p_var_value => p_from_party_id) ;
424: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
425: p_procedure_name => l_proc_name,
426: p_var_name => 'p_to_party_id',
427: p_var_value => p_to_party_id) ;
428: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 428: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

424: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
425: p_procedure_name => l_proc_name,
426: p_var_name => 'p_to_party_id',
427: p_var_value => p_to_party_id) ;
428: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
429: p_procedure_name => l_proc_name,
430: p_var_name => 'p_from_vendor_site_id',
431: p_var_value => p_from_vendor_site_id) ;
432: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 432: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

428: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
429: p_procedure_name => l_proc_name,
430: p_var_name => 'p_from_vendor_site_id',
431: p_var_value => p_from_vendor_site_id) ;
432: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
433: p_procedure_name => l_proc_name,
434: p_var_name => 'p_to_vendor_site_id',
435: p_var_value => p_to_vendor_site_id) ;
436: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 436: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

432: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
433: p_procedure_name => l_proc_name,
434: p_var_name => 'p_to_vendor_site_id',
435: p_var_value => p_to_vendor_site_id) ;
436: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
437: p_procedure_name => l_proc_name,
438: p_var_name => 'p_from_party_site_id',
439: p_var_value => p_from_party_site_id) ;
440: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 440: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

436: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
437: p_procedure_name => l_proc_name,
438: p_var_name => 'p_from_party_site_id',
439: p_var_value => p_from_party_site_id) ;
440: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
441: p_procedure_name => l_proc_name,
442: p_var_name => 'p_to_party_site_id',
443: p_var_value => p_to_party_site_id) ;
444: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 444: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

440: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
441: p_procedure_name => l_proc_name,
442: p_var_name => 'p_to_party_site_id',
443: p_var_value => p_to_party_site_id) ;
444: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
445: p_procedure_name => l_proc_name,
446: p_var_name => 'p_calling_mode',
447: p_var_value => p_calling_mode) ;
448:

Line 496: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

492: --
493: END IF;
494: --
495: l_debug_info := 'l_fromPartyId '||l_fromPartyId||' l_toPartyId '||l_toPartyId||' l_fromPartySiteId '||l_fromPartySiteId||' l_toPartySiteId '||l_toPartySiteId;
496: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
497: p_procedure_name => l_proc_name,
498: p_debug_info => l_debug_info) ;
499:
500: --

Line 518: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

514: x_return_status => l_return_status
515: );
516: --
517: l_debug_info := 'After calling core Merge_Vendors API l_return_status '||l_return_status;
518: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
519: p_procedure_name => l_proc_name,
520: p_debug_info => l_debug_info);
521:
522: -- If any errors happen abort API.

Line 530: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: --
529: l_debug_info := 'x_return_status '||x_return_status;
530: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
531: p_procedure_name => l_proc_name,
532: p_debug_info => l_debug_info) ;
533:
534: -- Standard call to get message count and if count is 1, get message info.

Line 540: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: -- Standard End of Procedure/Function Logging
540: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
541: p_procedure_name => l_proc_name) ;
542:
543: --}
544: EXCEPTION

Line 547: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

543: --}
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: -- Standard Expected Error Logging
547: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Merge_VendorParties_GRP;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 553: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

549: ROLLBACK TO Merge_VendorParties_GRP;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: -- Standard Unexpected Error Logging
553: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
554: p_procedure_name => l_proc_name);
555: ROLLBACK TO Merge_VendorParties_GRP;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: WHEN OTHERS THEN

Line 559: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

555: ROLLBACK TO Merge_VendorParties_GRP;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: WHEN OTHERS THEN
558: -- Standard Unexpected Error Logging
559: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
560: p_procedure_name => l_proc_name);
561: ROLLBACK TO Merge_VendorParties_GRP;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 617: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,

613:
614: BEGIN
615: --{
616: -- Standard Beginning of Procedure/Function Logging
617: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
618: p_procedure_name => l_proc_name);
619:
620: -- Standard Start of API savepoint
621: SAVEPOINT Merge_Parties_GRP;

Line 628: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: --
626:
627: -- Logging variables
628: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
629: p_procedure_name => l_proc_name,
630: p_var_name => 'p_entity_name',
631: p_var_value => p_entity_name);
632: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 632: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

628: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
629: p_procedure_name => l_proc_name,
630: p_var_name => 'p_entity_name',
631: p_var_value => p_entity_name);
632: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
633: p_procedure_name => l_proc_name,
634: p_var_name => 'p_from_id',
635: p_var_value => p_from_id);
636: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 636: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

632: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
633: p_procedure_name => l_proc_name,
634: p_var_name => 'p_from_id',
635: p_var_value => p_from_id);
636: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
637: p_procedure_name => l_proc_name,
638: p_var_name => 'p_to_id',
639: p_var_value => p_to_id);
640: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 640: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

636: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
637: p_procedure_name => l_proc_name,
638: p_var_name => 'p_to_id',
639: p_var_value => p_to_id);
640: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
641: p_procedure_name => l_proc_name,
642: p_var_name => 'p_from_fk_id',
643: p_var_value => p_from_fk_id);
644: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 644: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

640: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
641: p_procedure_name => l_proc_name,
642: p_var_name => 'p_from_fk_id',
643: p_var_value => p_from_fk_id);
644: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
645: p_procedure_name => l_proc_name,
646: p_var_name => 'p_to_fk_id',
647: p_var_value => p_to_fk_id);
648: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 648: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

644: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
645: p_procedure_name => l_proc_name,
646: p_var_name => 'p_to_fk_id',
647: p_var_value => p_to_fk_id);
648: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
649: p_procedure_name => l_proc_name,
650: p_var_name => 'p_parent_entity_name',
651: p_var_value => p_parent_entity_name);
652: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 652: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

648: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
649: p_procedure_name => l_proc_name,
650: p_var_name => 'p_parent_entity_name',
651: p_var_value => p_parent_entity_name);
652: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
653: p_procedure_name => l_proc_name,
654: p_var_name => 'p_batch_id',
655: p_var_value => p_batch_id);
656: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 656: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

652: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
653: p_procedure_name => l_proc_name,
654: p_var_name => 'p_batch_id',
655: p_var_value => p_batch_id);
656: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
657: p_procedure_name => l_proc_name,
658: p_var_name => 'p_batch_party_id',
659: p_var_value => p_batch_party_id);
660:

Line 667: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

663: FETCH c_charge_lines BULK COLLECT INTO l_charge_line_list;
664: CLOSE c_charge_lines;
665:
666: l_debug_info := 'Count of Rows fetched from Cursor C_CHARGE_LINES = ' || l_charge_line_list.count;
667: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
668: p_procedure_name => l_proc_name,
669: p_debug_info => l_debug_info) ;
670:
671: IF l_charge_line_list.COUNT > 0 THEN

Line 682: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

678: last_update_login = fnd_global.login_id
679: WHERE charge_line_id = l_charge_line_list(j);
680:
681: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
682: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
683: p_procedure_name => l_proc_name,
684: p_debug_info => l_debug_info) ;
685: END IF;
686: --}

Line 689: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

685: END IF;
686: --}
687:
688: l_debug_info := 'x_return_status '||x_return_status;
689: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
690: p_procedure_name => l_proc_name,
691: p_debug_info => l_debug_info) ;
692:
693: -- Standard End of Procedure/Function Logging

Line 694: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

690: p_procedure_name => l_proc_name,
691: p_debug_info => l_debug_info) ;
692:
693: -- Standard End of Procedure/Function Logging
694: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
695: p_procedure_name => l_proc_name) ;
696:
697: --}
698: EXCEPTION

Line 701: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

697: --}
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: -- Standard Expected Error Logging
701: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
702: p_procedure_name => l_proc_name);
703: ROLLBACK TO Merge_Parties_GRP;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 707: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

703: ROLLBACK TO Merge_Parties_GRP;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: -- Standard Unexpected Error Logging
707: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
708: p_procedure_name => l_proc_name);
709: ROLLBACK TO Merge_Parties_GRP;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: WHEN OTHERS THEN

Line 713: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

709: ROLLBACK TO Merge_Parties_GRP;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: WHEN OTHERS THEN
712: -- Standard Unexpected Error Logging
713: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
714: p_procedure_name => l_proc_name);
715: ROLLBACK TO Merge_Parties_GRP;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 770: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,

766: BEGIN
767: --{
768:
769: -- Standard Beginning of Procedure/Function Logging
770: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
771: p_procedure_name => l_proc_name);
772:
773: -- Standard Start of API savepoint
774: SAVEPOINT Merge_PartySites_GRP;

Line 780: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

776: -- Initialize API return status to success
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778:
779: -- Logging variables
780: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
781: p_procedure_name => l_proc_name,
782: p_var_name => 'p_entity_name',
783: p_var_value => p_entity_name);
784: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 784: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

780: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
781: p_procedure_name => l_proc_name,
782: p_var_name => 'p_entity_name',
783: p_var_value => p_entity_name);
784: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
785: p_procedure_name => l_proc_name,
786: p_var_name => 'p_from_id',
787: p_var_value => p_from_id);
788: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 788: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

784: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
785: p_procedure_name => l_proc_name,
786: p_var_name => 'p_from_id',
787: p_var_value => p_from_id);
788: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
789: p_procedure_name => l_proc_name,
790: p_var_name => 'p_to_id',
791: p_var_value => p_to_id);
792: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 792: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

788: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
789: p_procedure_name => l_proc_name,
790: p_var_name => 'p_to_id',
791: p_var_value => p_to_id);
792: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
793: p_procedure_name => l_proc_name,
794: p_var_name => 'p_from_fk_id',
795: p_var_value => p_from_fk_id);
796: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 796: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

792: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
793: p_procedure_name => l_proc_name,
794: p_var_name => 'p_from_fk_id',
795: p_var_value => p_from_fk_id);
796: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
797: p_procedure_name => l_proc_name,
798: p_var_name => 'p_to_fk_id',
799: p_var_value => p_to_fk_id);
800: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 800: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

796: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
797: p_procedure_name => l_proc_name,
798: p_var_name => 'p_to_fk_id',
799: p_var_value => p_to_fk_id);
800: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
801: p_procedure_name => l_proc_name,
802: p_var_name => 'p_parent_entity_name',
803: p_var_value => p_parent_entity_name);
804: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 804: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

800: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
801: p_procedure_name => l_proc_name,
802: p_var_name => 'p_parent_entity_name',
803: p_var_value => p_parent_entity_name);
804: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
805: p_procedure_name => l_proc_name,
806: p_var_name => 'p_batch_id',
807: p_var_value => p_batch_id);
808: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 808: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

804: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
805: p_procedure_name => l_proc_name,
806: p_var_name => 'p_batch_id',
807: p_var_value => p_batch_id);
808: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
809: p_procedure_name => l_proc_name,
810: p_var_name => 'p_batch_party_id',
811: p_var_value => p_batch_party_id);
812:

Line 819: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

815: FETCH c_charge_lines BULK COLLECT INTO l_charge_line_list;
816: CLOSE c_charge_lines;
817:
818: l_debug_info := 'Count of Rows fetched from Cursor C_CHARGE_LINES = ' || l_charge_line_list.count;
819: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
820: p_procedure_name => l_proc_name,
821: p_debug_info => l_debug_info) ;
822:
823: IF l_charge_line_list.COUNT > 0 THEN

Line 834: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

830: last_update_login = fnd_global.login_id
831: WHERE charge_line_id = l_charge_line_list(j);
832:
833: l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
834: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
835: p_procedure_name => l_proc_name,
836: p_debug_info => l_debug_info) ;
837: END IF;
838: --}

Line 841: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

837: END IF;
838: --}
839:
840: l_debug_info := 'x_return_status '||x_return_status;
841: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
842: p_procedure_name => l_proc_name,
843: p_debug_info => l_debug_info) ;
844:
845: -- Standard End of Procedure/Function Logging

Line 846: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

842: p_procedure_name => l_proc_name,
843: p_debug_info => l_debug_info) ;
844:
845: -- Standard End of Procedure/Function Logging
846: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
847: p_procedure_name => l_proc_name) ;
848:
849: --}
850: EXCEPTION

Line 853: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

849: --}
850: EXCEPTION
851: WHEN FND_API.G_EXC_ERROR THEN
852: -- Standard Expected Error Logging
853: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
854: p_procedure_name => l_proc_name);
855: ROLLBACK TO Merge_PartySites_GRP;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 859: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

855: ROLLBACK TO Merge_PartySites_GRP;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: -- Standard Unexpected Error Logging
859: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
860: p_procedure_name => l_proc_name);
861: ROLLBACK TO Merge_PartySites_GRP;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: WHEN OTHERS THEN

Line 865: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

861: ROLLBACK TO Merge_PartySites_GRP;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: WHEN OTHERS THEN
864: -- Standard Unexpected Error Logging
865: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
866: p_procedure_name => l_proc_name);
867: ROLLBACK TO Merge_PartySites_GRP;
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN