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.AHL_LTP_SIMUL_PLAN_PUB dependencies on AHL_DEBUG_PUB

Line 6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

2: /* $Header: AHLPSPNB.pls 115.7 2003/09/09 06:05:47 rroy noship $ */
3: --
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PUB';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: --
8: -----------------------------------------------------------
9: -- PACKAGE
10: -- AHL_LTP_SIMUL_PLAN_PUB

Line 63: AHL_DEBUG_PUB.enable_debug;

59: -- Standard Start of API savepoint
60: SAVEPOINT process_simulation_plan;
61: -- Check if API is called in debug mode. If yes, enable debug.
62: IF G_DEBUG='Y' THEN
63: AHL_DEBUG_PUB.enable_debug;
64: END IF;
65: -- Debug info.
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');

Line 67: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');

63: AHL_DEBUG_PUB.enable_debug;
64: END IF;
65: -- Debug info.
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
68: END IF;
69: -- Standard call to check for call compatibility.
70: IF FND_API.to_boolean(p_init_msg_list)
71: THEN

Line 174: Ahl_Debug_Pub.debug( 'End of public api Process Simulation plan','+SMPLN+');

170: COMMIT;
171: END IF;
172: -- Debug info
173: IF G_DEBUG='Y' THEN
174: Ahl_Debug_Pub.debug( 'End of public api Process Simulation plan','+SMPLN+');
175: END IF;
176: -- Check if API is called in debug mode. If yes, disable debug.
177: IF G_DEBUG='Y' THEN
178: Ahl_Debug_Pub.disable_debug;

Line 178: Ahl_Debug_Pub.disable_debug;

174: Ahl_Debug_Pub.debug( 'End of public api Process Simulation plan','+SMPLN+');
175: END IF;
176: -- Check if API is called in debug mode. If yes, disable debug.
177: IF G_DEBUG='Y' THEN
178: Ahl_Debug_Pub.disable_debug;
179: END IF;
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 190: AHL_DEBUG_PUB.log_app_messages (

186: p_count => x_msg_count,
187: p_data => x_msg_data);
188:
189: IF G_DEBUG='Y' THEN
190: AHL_DEBUG_PUB.log_app_messages (
191: x_msg_count, x_msg_data, 'ERROR' );
192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
193: END IF;
194: -- Check if API is called in debug mode. If yes, disable debug.

Line 192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');

188:
189: IF G_DEBUG='Y' THEN
190: AHL_DEBUG_PUB.log_app_messages (
191: x_msg_count, x_msg_data, 'ERROR' );
192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
193: END IF;
194: -- Check if API is called in debug mode. If yes, disable debug.
195: AHL_DEBUG_PUB.disable_debug;
196:

Line 195: AHL_DEBUG_PUB.disable_debug;

191: x_msg_count, x_msg_data, 'ERROR' );
192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
193: END IF;
194: -- Check if API is called in debug mode. If yes, disable debug.
195: AHL_DEBUG_PUB.disable_debug;
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO process_simulation_plan;
199: X_return_status := FND_API.G_RET_STS_ERROR;

Line 205: AHL_DEBUG_PUB.log_app_messages (

201: p_count => x_msg_count,
202: p_data => X_msg_data);
203: -- Debug info.
204: IF G_DEBUG='Y' THEN
205: AHL_DEBUG_PUB.log_app_messages (
206: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
208: END IF;
209: -- Check if API is called in debug mode. If yes, disable debug.

Line 207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');

203: -- Debug info.
204: IF G_DEBUG='Y' THEN
205: AHL_DEBUG_PUB.log_app_messages (
206: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
208: END IF;
209: -- Check if API is called in debug mode. If yes, disable debug.
210: AHL_DEBUG_PUB.disable_debug;
211:

Line 210: AHL_DEBUG_PUB.disable_debug;

206: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
208: END IF;
209: -- Check if API is called in debug mode. If yes, disable debug.
210: AHL_DEBUG_PUB.disable_debug;
211:
212: WHEN OTHERS THEN
213: ROLLBACK TO process_simulation_plan;
214: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 227: AHL_DEBUG_PUB.log_app_messages (

223: p_data => X_msg_data);
224:
225: -- Debug info.
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.log_app_messages (
228: x_msg_count, x_msg_data, 'SQL ERROR' );
229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
230: END IF;
231: -- Check if API is called in debug mode. If yes, disable debug.

Line 229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');

225: -- Debug info.
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.log_app_messages (
228: x_msg_count, x_msg_data, 'SQL ERROR' );
229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
230: END IF;
231: -- Check if API is called in debug mode. If yes, disable debug.
232: AHL_DEBUG_PUB.disable_debug;
233:

Line 232: AHL_DEBUG_PUB.disable_debug;

228: x_msg_count, x_msg_data, 'SQL ERROR' );
229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
230: END IF;
231: -- Check if API is called in debug mode. If yes, disable debug.
232: AHL_DEBUG_PUB.disable_debug;
233:
234: END Process_Simulation_Plan;
235:
236:

Line 277: AHL_DEBUG_PUB.enable_debug;

273: -- Standard Start of API savepoint
274: SAVEPOINT process_simulation_visit;
275: -- Check if API is called in debug mode. If yes, enable debug.
276: IF G_DEBUG='Y' THEN
277: AHL_DEBUG_PUB.enable_debug;
278: END IF;
279: -- Debug info.
280: IF G_DEBUG='Y' THEN
281: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Visits to Plan','+SMPLN+');

Line 281: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Visits to Plan','+SMPLN+');

277: AHL_DEBUG_PUB.enable_debug;
278: END IF;
279: -- Debug info.
280: IF G_DEBUG='Y' THEN
281: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Visits to Plan','+SMPLN+');
282: END IF;
283: -- Standard call to check for call compatibility.
284: IF FND_API.to_boolean(p_init_msg_list)
285: THEN

Line 305: AHL_DEBUG_PUB.debug( 'visit_id'||p_simulation_visit_tbl(i).visit_id);

301: LOOP
302: IF p_simulation_visit_tbl(i).operation_flag = 'X' THEN
303:
304: IF G_DEBUG='Y' THEN
305: AHL_DEBUG_PUB.debug( 'visit_id'||p_simulation_visit_tbl(i).visit_id);
306: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
307: END IF;
308:
309: AHL_LTP_SIMUL_PLAN_PVT.Copy_Visits_To_Plan (

Line 306: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);

302: IF p_simulation_visit_tbl(i).operation_flag = 'X' THEN
303:
304: IF G_DEBUG='Y' THEN
305: AHL_DEBUG_PUB.debug( 'visit_id'||p_simulation_visit_tbl(i).visit_id);
306: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
307: END IF;
308:
309: AHL_LTP_SIMUL_PLAN_PVT.Copy_Visits_To_Plan (
310: p_api_version => p_api_version,

Line 327: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);

323: x_msg_data => l_msg_data);
324: --Assign returned value
325: p_simulation_visit_tbl(i).visit_id := l_visit_id;
326: IF G_DEBUG='Y' THEN
327: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
328: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
329: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
330: END IF;
331: --Standard check to count messages

Line 328: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);

324: --Assign returned value
325: p_simulation_visit_tbl(i).visit_id := l_visit_id;
326: IF G_DEBUG='Y' THEN
327: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
328: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
329: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
330: END IF;
331: --Standard check to count messages
332: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 329: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);

325: p_simulation_visit_tbl(i).visit_id := l_visit_id;
326: IF G_DEBUG='Y' THEN
327: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
328: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
329: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
330: END IF;
331: --Standard check to count messages
332: l_msg_count := Fnd_Msg_Pub.count_msg;
333:

Line 357: AHL_DEBUG_PUB.debug( 'Pvisit_id'||p_simulation_visit_tbl(i).primary_visit_id);

353: x_msg_data => l_msg_data);
354: --
355: */
356: IF G_DEBUG='Y' THEN
357: AHL_DEBUG_PUB.debug( 'Pvisit_id'||p_simulation_visit_tbl(i).primary_visit_id);
358: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
359: END IF;
360:
361:

Line 358: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);

354: --
355: */
356: IF G_DEBUG='Y' THEN
357: AHL_DEBUG_PUB.debug( 'Pvisit_id'||p_simulation_visit_tbl(i).primary_visit_id);
358: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
359: END IF;
360:
361:
362: ELSIF p_simulation_visit_tbl(i).operation_flag = 'C' THEN

Line 381: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);

377: x_msg_data => l_msg_data);
378: END IF;
379:
380: IF G_DEBUG='Y' THEN
381: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
382: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
383: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
384: END IF;
385: --Standard check to count messages

Line 382: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);

378: END IF;
379:
380: IF G_DEBUG='Y' THEN
381: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
382: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
383: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
384: END IF;
385: --Standard check to count messages
386: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 383: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);

379:
380: IF G_DEBUG='Y' THEN
381: AHL_DEBUG_PUB.debug( 'pvisit_id'||p_simulation_visit_tbl(i).visit_id);
382: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
383: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
384: END IF;
385: --Standard check to count messages
386: l_msg_count := Fnd_Msg_Pub.count_msg;
387:

Line 435: Ahl_Debug_Pub.debug( 'End of public api Process Simulation Visit','+SMPLN+');

431: COMMIT;
432: END IF;
433: -- Debug info
434: IF G_DEBUG='Y' THEN
435: Ahl_Debug_Pub.debug( 'End of public api Process Simulation Visit','+SMPLN+');
436: END IF;
437: -- Check if API is called in debug mode. If yes, disable debug.
438: IF G_DEBUG='Y' THEN
439: Ahl_Debug_Pub.disable_debug;

Line 439: Ahl_Debug_Pub.disable_debug;

435: Ahl_Debug_Pub.debug( 'End of public api Process Simulation Visit','+SMPLN+');
436: END IF;
437: -- Check if API is called in debug mode. If yes, disable debug.
438: IF G_DEBUG='Y' THEN
439: Ahl_Debug_Pub.disable_debug;
440: END IF;
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 451: AHL_DEBUG_PUB.log_app_messages (

447: p_count => x_msg_count,
448: p_data => x_msg_data);
449:
450: IF G_DEBUG='Y' THEN
451: AHL_DEBUG_PUB.log_app_messages (
452: x_msg_count, x_msg_data, 'ERROR' );
453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
454: END IF;
455: -- Check if API is called in debug mode. If yes, disable debug.

Line 453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');

449:
450: IF G_DEBUG='Y' THEN
451: AHL_DEBUG_PUB.log_app_messages (
452: x_msg_count, x_msg_data, 'ERROR' );
453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
454: END IF;
455: -- Check if API is called in debug mode. If yes, disable debug.
456: AHL_DEBUG_PUB.disable_debug;
457:

Line 456: AHL_DEBUG_PUB.disable_debug;

452: x_msg_count, x_msg_data, 'ERROR' );
453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
454: END IF;
455: -- Check if API is called in debug mode. If yes, disable debug.
456: AHL_DEBUG_PUB.disable_debug;
457:
458: WHEN FND_API.G_EXC_ERROR THEN
459: ROLLBACK TO process_simulation_visit;
460: X_return_status := FND_API.G_RET_STS_ERROR;

Line 466: AHL_DEBUG_PUB.log_app_messages (

462: p_count => x_msg_count,
463: p_data => X_msg_data);
464: -- Debug info.
465: IF G_DEBUG='Y' THEN
466: AHL_DEBUG_PUB.log_app_messages (
467: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
469: END IF;
470: -- Check if API is called in debug mode. If yes, disable debug.

Line 468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');

464: -- Debug info.
465: IF G_DEBUG='Y' THEN
466: AHL_DEBUG_PUB.log_app_messages (
467: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
469: END IF;
470: -- Check if API is called in debug mode. If yes, disable debug.
471: AHL_DEBUG_PUB.disable_debug;
472:

Line 471: AHL_DEBUG_PUB.disable_debug;

467: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
469: END IF;
470: -- Check if API is called in debug mode. If yes, disable debug.
471: AHL_DEBUG_PUB.disable_debug;
472:
473: WHEN OTHERS THEN
474: ROLLBACK TO process_simulation_visit;
475: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: AHL_DEBUG_PUB.log_app_messages (

484: p_data => X_msg_data);
485:
486: -- Debug info.
487: IF G_DEBUG='Y' THEN
488: AHL_DEBUG_PUB.log_app_messages (
489: x_msg_count, x_msg_data, 'SQL ERROR' );
490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');
491: END IF;
492: -- Check if API is called in debug mode. If yes, disable debug.

Line 490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');

486: -- Debug info.
487: IF G_DEBUG='Y' THEN
488: AHL_DEBUG_PUB.log_app_messages (
489: x_msg_count, x_msg_data, 'SQL ERROR' );
490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');
491: END IF;
492: -- Check if API is called in debug mode. If yes, disable debug.
493: AHL_DEBUG_PUB.disable_debug;
494:

Line 493: AHL_DEBUG_PUB.disable_debug;

489: x_msg_count, x_msg_data, 'SQL ERROR' );
490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');
491: END IF;
492: -- Check if API is called in debug mode. If yes, disable debug.
493: AHL_DEBUG_PUB.disable_debug;
494:
495: END Process_Simulation_Visit;
496:
497:

Line 538: AHL_DEBUG_PUB.enable_debug;

534: -- Standard Start of API savepoint
535: SAVEPOINT toggle_simulation_delete;
536: -- Check if API is called in debug mode. If yes, enable debug.
537: IF G_DEBUG='Y' THEN
538: AHL_DEBUG_PUB.enable_debug;
539: END IF;
540: -- Debug info.
541: IF G_DEBUG='Y' THEN
542: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

Line 542: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

538: AHL_DEBUG_PUB.enable_debug;
539: END IF;
540: -- Debug info.
541: IF G_DEBUG='Y' THEN
542: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
543: END IF;
544: -- Standard call to check for call compatibility.
545: IF FND_API.to_boolean(p_init_msg_list)
546: THEN

Line 589: Ahl_Debug_Pub.debug( 'End of public api Toggle Simulation Delete','+SMPLN+');

585: COMMIT;
586: END IF;
587: -- Debug info
588: IF G_DEBUG='Y' THEN
589: Ahl_Debug_Pub.debug( 'End of public api Toggle Simulation Delete','+SMPLN+');
590: -- Check if API is called in debug mode. If yes, disable debug.
591: Ahl_Debug_Pub.disable_debug;
592: END IF;
593:

Line 591: Ahl_Debug_Pub.disable_debug;

587: -- Debug info
588: IF G_DEBUG='Y' THEN
589: Ahl_Debug_Pub.debug( 'End of public api Toggle Simulation Delete','+SMPLN+');
590: -- Check if API is called in debug mode. If yes, disable debug.
591: Ahl_Debug_Pub.disable_debug;
592: END IF;
593:
594: EXCEPTION
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 603: AHL_DEBUG_PUB.log_app_messages (

599: p_count => x_msg_count,
600: p_data => x_msg_data);
601:
602: IF G_DEBUG='Y' THEN
603: AHL_DEBUG_PUB.log_app_messages (
604: x_msg_count, x_msg_data, 'ERROR' );
605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
606: END IF;
607: -- Check if API is called in debug mode. If yes, disable debug.

Line 605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

601:
602: IF G_DEBUG='Y' THEN
603: AHL_DEBUG_PUB.log_app_messages (
604: x_msg_count, x_msg_data, 'ERROR' );
605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
606: END IF;
607: -- Check if API is called in debug mode. If yes, disable debug.
608: AHL_DEBUG_PUB.disable_debug;
609:

Line 608: AHL_DEBUG_PUB.disable_debug;

604: x_msg_count, x_msg_data, 'ERROR' );
605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
606: END IF;
607: -- Check if API is called in debug mode. If yes, disable debug.
608: AHL_DEBUG_PUB.disable_debug;
609:
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO toggle_simulation_delete;
612: X_return_status := FND_API.G_RET_STS_ERROR;

Line 618: AHL_DEBUG_PUB.log_app_messages (

614: p_count => x_msg_count,
615: p_data => X_msg_data);
616: -- Debug info.
617: IF G_DEBUG='Y' THEN
618: AHL_DEBUG_PUB.log_app_messages (
619: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
621: END IF;
622: -- Check if API is called in debug mode. If yes, disable debug.

Line 620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

616: -- Debug info.
617: IF G_DEBUG='Y' THEN
618: AHL_DEBUG_PUB.log_app_messages (
619: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
621: END IF;
622: -- Check if API is called in debug mode. If yes, disable debug.
623: AHL_DEBUG_PUB.disable_debug;
624:

Line 623: AHL_DEBUG_PUB.disable_debug;

619: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
621: END IF;
622: -- Check if API is called in debug mode. If yes, disable debug.
623: AHL_DEBUG_PUB.disable_debug;
624:
625: WHEN OTHERS THEN
626: ROLLBACK TO toggle_simulation_delete;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 640: AHL_DEBUG_PUB.log_app_messages (

636: p_data => X_msg_data);
637:
638: -- Debug info.
639: IF G_DEBUG='Y' THEN
640: AHL_DEBUG_PUB.log_app_messages (
641: x_msg_count, x_msg_data, 'SQL ERROR' );
642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
643: END IF;
644: -- Check if API is called in debug mode. If yes, disable debug.

Line 642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

638: -- Debug info.
639: IF G_DEBUG='Y' THEN
640: AHL_DEBUG_PUB.log_app_messages (
641: x_msg_count, x_msg_data, 'SQL ERROR' );
642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
643: END IF;
644: -- Check if API is called in debug mode. If yes, disable debug.
645: AHL_DEBUG_PUB.disable_debug;
646:

Line 645: AHL_DEBUG_PUB.disable_debug;

641: x_msg_count, x_msg_data, 'SQL ERROR' );
642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
643: END IF;
644: -- Check if API is called in debug mode. If yes, disable debug.
645: AHL_DEBUG_PUB.disable_debug;
646:
647: END Toggle_Simulation_Delete;
648:
649:

Line 690: AHL_DEBUG_PUB.enable_debug;

686: -- Standard Start of API savepoint
687: SAVEPOINT set_plan_as_primary;
688: -- Check if API is called in debug mode. If yes, enable debug.
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.enable_debug;
691: END IF;
692: -- Debug info.
693: IF G_DEBUG='Y' THEN
694: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Plan as Primary','+SMPLN+');

Line 694: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Plan as Primary','+SMPLN+');

690: AHL_DEBUG_PUB.enable_debug;
691: END IF;
692: -- Debug info.
693: IF G_DEBUG='Y' THEN
694: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Plan as Primary','+SMPLN+');
695: END IF;
696: -- Standard call to check for call compatibility.
697: IF FND_API.to_boolean(p_init_msg_list)
698: THEN

Line 741: Ahl_Debug_Pub.debug( 'End of public api Set Plan as primary','+SMPLN+');

737: COMMIT;
738: END IF;
739: -- Debug info
740: IF G_DEBUG='Y' THEN
741: Ahl_Debug_Pub.debug( 'End of public api Set Plan as primary','+SMPLN+');
742: -- Check if API is called in debug mode. If yes, disable debug.
743: Ahl_Debug_Pub.disable_debug;
744: END IF;
745:

Line 743: Ahl_Debug_Pub.disable_debug;

739: -- Debug info
740: IF G_DEBUG='Y' THEN
741: Ahl_Debug_Pub.debug( 'End of public api Set Plan as primary','+SMPLN+');
742: -- Check if API is called in debug mode. If yes, disable debug.
743: Ahl_Debug_Pub.disable_debug;
744: END IF;
745:
746: EXCEPTION
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 755: AHL_DEBUG_PUB.log_app_messages (

751: p_count => x_msg_count,
752: p_data => x_msg_data);
753:
754: IF G_DEBUG='Y' THEN
755: AHL_DEBUG_PUB.log_app_messages (
756: x_msg_count, x_msg_data, 'ERROR' );
757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
758: END IF;
759: -- Check if API is called in debug mode. If yes, disable debug.

Line 757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');

753:
754: IF G_DEBUG='Y' THEN
755: AHL_DEBUG_PUB.log_app_messages (
756: x_msg_count, x_msg_data, 'ERROR' );
757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
758: END IF;
759: -- Check if API is called in debug mode. If yes, disable debug.
760: AHL_DEBUG_PUB.disable_debug;
761:

Line 760: AHL_DEBUG_PUB.disable_debug;

756: x_msg_count, x_msg_data, 'ERROR' );
757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
758: END IF;
759: -- Check if API is called in debug mode. If yes, disable debug.
760: AHL_DEBUG_PUB.disable_debug;
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO set_plan_as_primary;
764: X_return_status := FND_API.G_RET_STS_ERROR;

Line 770: AHL_DEBUG_PUB.log_app_messages (

766: p_count => x_msg_count,
767: p_data => X_msg_data);
768: -- Debug info.
769: IF G_DEBUG='Y' THEN
770: AHL_DEBUG_PUB.log_app_messages (
771: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');
773: END IF;
774: -- Check if API is called in debug mode. If yes, disable debug.

Line 772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');

768: -- Debug info.
769: IF G_DEBUG='Y' THEN
770: AHL_DEBUG_PUB.log_app_messages (
771: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');
773: END IF;
774: -- Check if API is called in debug mode. If yes, disable debug.
775: AHL_DEBUG_PUB.disable_debug;
776:

Line 775: AHL_DEBUG_PUB.disable_debug;

771: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');
773: END IF;
774: -- Check if API is called in debug mode. If yes, disable debug.
775: AHL_DEBUG_PUB.disable_debug;
776:
777: WHEN OTHERS THEN
778: ROLLBACK TO set_plan_as_primary;
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 792: AHL_DEBUG_PUB.log_app_messages (

788: p_data => X_msg_data);
789:
790: -- Debug info.
791: IF G_DEBUG='Y' THEN
792: AHL_DEBUG_PUB.log_app_messages (
793: x_msg_count, x_msg_data, 'SQL ERROR' );
794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
795: END IF;
796: -- Check if API is called in debug mode. If yes, disable debug.

Line 794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');

790: -- Debug info.
791: IF G_DEBUG='Y' THEN
792: AHL_DEBUG_PUB.log_app_messages (
793: x_msg_count, x_msg_data, 'SQL ERROR' );
794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
795: END IF;
796: -- Check if API is called in debug mode. If yes, disable debug.
797: AHL_DEBUG_PUB.disable_debug;
798:

Line 797: AHL_DEBUG_PUB.disable_debug;

793: x_msg_count, x_msg_data, 'SQL ERROR' );
794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
795: END IF;
796: -- Check if API is called in debug mode. If yes, disable debug.
797: AHL_DEBUG_PUB.disable_debug;
798:
799: END Set_Plan_As_Primary;
800:
801:

Line 843: AHL_DEBUG_PUB.enable_debug;

839: -- Standard Start of API savepoint
840: SAVEPOINT set_visit_as_primary;
841: -- Check if API is called in debug mode. If yes, enable debug.
842: IF G_DEBUG='Y' THEN
843: AHL_DEBUG_PUB.enable_debug;
844: END IF;
845: -- Debug info.
846: IF G_DEBUG='Y' THEN
847: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Visit as Primary','+SMPLN+');

Line 847: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Visit as Primary','+SMPLN+');

843: AHL_DEBUG_PUB.enable_debug;
844: END IF;
845: -- Debug info.
846: IF G_DEBUG='Y' THEN
847: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Visit as Primary','+SMPLN+');
848: END IF;
849: -- Standard call to check for call compatibility.
850: IF FND_API.to_boolean(p_init_msg_list)
851: THEN

Line 895: Ahl_Debug_Pub.debug( 'End of public api Set Visit as primary','+SMPLN+');

891: COMMIT;
892: END IF;
893: -- Debug info
894: IF G_DEBUG='Y' THEN
895: Ahl_Debug_Pub.debug( 'End of public api Set Visit as primary','+SMPLN+');
896: -- Check if API is called in debug mode. If yes, disable debug.
897: Ahl_Debug_Pub.disable_debug;
898: END IF;
899:

Line 897: Ahl_Debug_Pub.disable_debug;

893: -- Debug info
894: IF G_DEBUG='Y' THEN
895: Ahl_Debug_Pub.debug( 'End of public api Set Visit as primary','+SMPLN+');
896: -- Check if API is called in debug mode. If yes, disable debug.
897: Ahl_Debug_Pub.disable_debug;
898: END IF;
899:
900: EXCEPTION
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 909: AHL_DEBUG_PUB.log_app_messages (

905: p_count => x_msg_count,
906: p_data => x_msg_data);
907:
908: IF G_DEBUG='Y' THEN
909: AHL_DEBUG_PUB.log_app_messages (
910: x_msg_count, x_msg_data, 'ERROR' );
911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
912: END IF;
913: -- Check if API is called in debug mode. If yes, disable debug.

Line 911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');

907:
908: IF G_DEBUG='Y' THEN
909: AHL_DEBUG_PUB.log_app_messages (
910: x_msg_count, x_msg_data, 'ERROR' );
911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
912: END IF;
913: -- Check if API is called in debug mode. If yes, disable debug.
914: AHL_DEBUG_PUB.disable_debug;
915:

Line 914: AHL_DEBUG_PUB.disable_debug;

910: x_msg_count, x_msg_data, 'ERROR' );
911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
912: END IF;
913: -- Check if API is called in debug mode. If yes, disable debug.
914: AHL_DEBUG_PUB.disable_debug;
915:
916: WHEN FND_API.G_EXC_ERROR THEN
917: ROLLBACK TO set_visit_as_primary;
918: X_return_status := FND_API.G_RET_STS_ERROR;

Line 924: AHL_DEBUG_PUB.log_app_messages (

920: p_count => x_msg_count,
921: p_data => X_msg_data);
922: -- Debug info.
923: IF G_DEBUG='Y' THEN
924: AHL_DEBUG_PUB.log_app_messages (
925: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');
927: END IF;
928: -- Check if API is called in debug mode. If yes, disable debug.

Line 926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');

922: -- Debug info.
923: IF G_DEBUG='Y' THEN
924: AHL_DEBUG_PUB.log_app_messages (
925: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');
927: END IF;
928: -- Check if API is called in debug mode. If yes, disable debug.
929: AHL_DEBUG_PUB.disable_debug;
930:

Line 929: AHL_DEBUG_PUB.disable_debug;

925: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');
927: END IF;
928: -- Check if API is called in debug mode. If yes, disable debug.
929: AHL_DEBUG_PUB.disable_debug;
930:
931: WHEN OTHERS THEN
932: ROLLBACK TO set_visit_as_primary;
933: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 946: AHL_DEBUG_PUB.log_app_messages (

942: p_data => X_msg_data);
943:
944: -- Debug info.
945: IF G_DEBUG='Y' THEN
946: AHL_DEBUG_PUB.log_app_messages (
947: x_msg_count, x_msg_data, 'SQL ERROR' );
948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
949: END IF;
950: -- Check if API is called in debug mode. If yes, disable debug.

Line 948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');

944: -- Debug info.
945: IF G_DEBUG='Y' THEN
946: AHL_DEBUG_PUB.log_app_messages (
947: x_msg_count, x_msg_data, 'SQL ERROR' );
948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
949: END IF;
950: -- Check if API is called in debug mode. If yes, disable debug.
951: AHL_DEBUG_PUB.disable_debug;
952: END Set_Visit_As_Primary;

Line 951: AHL_DEBUG_PUB.disable_debug;

947: x_msg_count, x_msg_data, 'SQL ERROR' );
948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
949: END IF;
950: -- Check if API is called in debug mode. If yes, disable debug.
951: AHL_DEBUG_PUB.disable_debug;
952: END Set_Visit_As_Primary;
953: --
954: END AHL_LTP_SIMUL_PLAN_PUB;