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_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PVT AS
2: /* $Header: AHLVSPNB.pls 120.7.12020000.3 2013/03/07 10:00:55 debadey ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -----------------------------------------------------------
8: -- PACKAGE
9: -- AHL_LTP_SIMUL_PLAN_PVT

Line 173: AHL_DEBUG_PUB.debug( 'inside complete name 1:'||l_simulation_rec.simulation_plan_name);

169: RAISE Fnd_Api.G_EXC_ERROR;
170: END IF;
171:
172: IF G_DEBUG='Y' THEN
173: AHL_DEBUG_PUB.debug( 'inside complete name 1:'||l_simulation_rec.simulation_plan_name);
174: END IF;
175:
176: -- SIMULATION_PLAN_NAME
177: IF p_simulation_rec.simulation_plan_name <> FND_API.g_miss_char THEN

Line 574: AHL_DEBUG_PUB.enable_debug;

570: -- Standard Start of API savepoint
571: SAVEPOINT create_simulation_plan;
572: -- Check if API is called in debug mode. If yes, enable debug.
573: IF G_DEBUG='Y' THEN
574: AHL_DEBUG_PUB.enable_debug;
575: END IF;
576: -- Debug info.
577: IF G_DEBUG='Y' THEN
578: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Create Simulation plan','+SIMPL+');

Line 578: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Create Simulation plan','+SIMPL+');

574: AHL_DEBUG_PUB.enable_debug;
575: END IF;
576: -- Debug info.
577: IF G_DEBUG='Y' THEN
578: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Create Simulation plan','+SIMPL+');
579: END IF;
580: -- Standard call to check for call compatibility.
581: IF FND_API.to_boolean(p_init_msg_list)
582: THEN

Line 795: Ahl_Debug_Pub.debug( 'End of private api Create Simulation plan','+SMPLN+');

791: COMMIT;
792: END IF;
793: -- Debug info
794: IF G_DEBUG='Y' THEN
795: Ahl_Debug_Pub.debug( 'End of private api Create Simulation plan','+SMPLN+');
796: END IF;
797: -- Check if API is called in debug mode. If yes, disable debug.
798: IF G_DEBUG='Y' THEN
799: Ahl_Debug_Pub.disable_debug;

Line 799: Ahl_Debug_Pub.disable_debug;

795: Ahl_Debug_Pub.debug( 'End of private api Create Simulation plan','+SMPLN+');
796: END IF;
797: -- Check if API is called in debug mode. If yes, disable debug.
798: IF G_DEBUG='Y' THEN
799: Ahl_Debug_Pub.disable_debug;
800: END IF;
801: EXCEPTION
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO create_simulation_plan;

Line 810: AHL_DEBUG_PUB.log_app_messages (

806: p_count => x_msg_count,
807: p_data => x_msg_data);
808: IF G_DEBUG='Y' THEN
809:
810: AHL_DEBUG_PUB.log_app_messages (
811: x_msg_count, x_msg_data, 'ERROR' );
812: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
813: -- Check if API is called in debug mode. If yes, disable debug.
814: AHL_DEBUG_PUB.disable_debug;

Line 812: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');

808: IF G_DEBUG='Y' THEN
809:
810: AHL_DEBUG_PUB.log_app_messages (
811: x_msg_count, x_msg_data, 'ERROR' );
812: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
813: -- Check if API is called in debug mode. If yes, disable debug.
814: AHL_DEBUG_PUB.disable_debug;
815: END IF;
816: WHEN FND_API.G_EXC_ERROR THEN

Line 814: AHL_DEBUG_PUB.disable_debug;

810: AHL_DEBUG_PUB.log_app_messages (
811: x_msg_count, x_msg_data, 'ERROR' );
812: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
813: -- Check if API is called in debug mode. If yes, disable debug.
814: AHL_DEBUG_PUB.disable_debug;
815: END IF;
816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO create_simulation_plan;
818: X_return_status := FND_API.G_RET_STS_ERROR;

Line 824: AHL_DEBUG_PUB.log_app_messages (

820: p_count => x_msg_count,
821: p_data => X_msg_data);
822: IF G_DEBUG='Y' THEN
823: -- Debug info.
824: AHL_DEBUG_PUB.log_app_messages (
825: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
826: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
827: -- Check if API is called in debug mode. If yes, disable debug.
828: AHL_DEBUG_PUB.disable_debug;

Line 826: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');

822: IF G_DEBUG='Y' THEN
823: -- Debug info.
824: AHL_DEBUG_PUB.log_app_messages (
825: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
826: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
827: -- Check if API is called in debug mode. If yes, disable debug.
828: AHL_DEBUG_PUB.disable_debug;
829: END IF;
830: WHEN OTHERS THEN

Line 828: AHL_DEBUG_PUB.disable_debug;

824: AHL_DEBUG_PUB.log_app_messages (
825: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
826: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
827: -- Check if API is called in debug mode. If yes, disable debug.
828: AHL_DEBUG_PUB.disable_debug;
829: END IF;
830: WHEN OTHERS THEN
831: ROLLBACK TO create_simulation_plan;
832: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 845: AHL_DEBUG_PUB.log_app_messages (

841: p_data => X_msg_data);
842: IF G_DEBUG='Y' THEN
843:
844: -- Debug info.
845: AHL_DEBUG_PUB.log_app_messages (
846: x_msg_count, x_msg_data, 'SQL ERROR' );
847: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Create Simulation plan','+SMPLN+');
848: -- Check if API is called in debug mode. If yes, disable debug.
849: AHL_DEBUG_PUB.disable_debug;

Line 847: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Create Simulation plan','+SMPLN+');

843:
844: -- Debug info.
845: AHL_DEBUG_PUB.log_app_messages (
846: x_msg_count, x_msg_data, 'SQL ERROR' );
847: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Create Simulation plan','+SMPLN+');
848: -- Check if API is called in debug mode. If yes, disable debug.
849: AHL_DEBUG_PUB.disable_debug;
850: END IF;
851: END Create_Simulation_plan;

Line 849: AHL_DEBUG_PUB.disable_debug;

845: AHL_DEBUG_PUB.log_app_messages (
846: x_msg_count, x_msg_data, 'SQL ERROR' );
847: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Create Simulation plan','+SMPLN+');
848: -- Check if API is called in debug mode. If yes, disable debug.
849: AHL_DEBUG_PUB.disable_debug;
850: END IF;
851: END Create_Simulation_plan;
852:
853:

Line 907: AHL_DEBUG_PUB.enable_debug;

903: -- Standard Start of API savepoint
904: SAVEPOINT update_simulation_plan;
905: -- Check if API is called in debug mode. If yes, enable debug.
906: IF G_DEBUG='Y' THEN
907: AHL_DEBUG_PUB.enable_debug;
908: END IF;
909: -- Debug info.
910: IF G_DEBUG='Y' THEN
911: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPNL+');

Line 911: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPNL+');

907: AHL_DEBUG_PUB.enable_debug;
908: END IF;
909: -- Debug info.
910: IF G_DEBUG='Y' THEN
911: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPNL+');
912: END IF;
913: -- Standard call to check for call compatibility.
914: IF FND_API.to_boolean(p_init_msg_list)
915: THEN

Line 1040: Ahl_Debug_Pub.debug( 'End of private api Update Simulation plan','+SMPLN+');

1036: COMMIT;
1037: END IF;
1038: -- Debug info
1039: IF G_DEBUG='Y' THEN
1040: Ahl_Debug_Pub.debug( 'End of private api Update Simulation plan','+SMPLN+');
1041: -- Check if API is called in debug mode. If yes, disable debug.
1042: Ahl_Debug_Pub.disable_debug;
1043: END IF;
1044: EXCEPTION

Line 1042: Ahl_Debug_Pub.disable_debug;

1038: -- Debug info
1039: IF G_DEBUG='Y' THEN
1040: Ahl_Debug_Pub.debug( 'End of private api Update Simulation plan','+SMPLN+');
1041: -- Check if API is called in debug mode. If yes, disable debug.
1042: Ahl_Debug_Pub.disable_debug;
1043: END IF;
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO update_simulation_plan;

Line 1053: AHL_DEBUG_PUB.log_app_messages (

1049: p_count => x_msg_count,
1050: p_data => x_msg_data);
1051: IF G_DEBUG='Y' THEN
1052:
1053: AHL_DEBUG_PUB.log_app_messages (
1054: x_msg_count, x_msg_data, 'ERROR' );
1055: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1056: -- Check if API is called in debug mode. If yes, disable debug.
1057: AHL_DEBUG_PUB.disable_debug;

Line 1055: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1051: IF G_DEBUG='Y' THEN
1052:
1053: AHL_DEBUG_PUB.log_app_messages (
1054: x_msg_count, x_msg_data, 'ERROR' );
1055: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1056: -- Check if API is called in debug mode. If yes, disable debug.
1057: AHL_DEBUG_PUB.disable_debug;
1058: END IF;
1059: WHEN FND_API.G_EXC_ERROR THEN

Line 1057: AHL_DEBUG_PUB.disable_debug;

1053: AHL_DEBUG_PUB.log_app_messages (
1054: x_msg_count, x_msg_data, 'ERROR' );
1055: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1056: -- Check if API is called in debug mode. If yes, disable debug.
1057: AHL_DEBUG_PUB.disable_debug;
1058: END IF;
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO update_simulation_plan;
1061: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1068: AHL_DEBUG_PUB.log_app_messages (

1064: p_data => X_msg_data);
1065: IF G_DEBUG='Y' THEN
1066:
1067: -- Debug info.
1068: AHL_DEBUG_PUB.log_app_messages (
1069: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1070: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1071: -- Check if API is called in debug mode. If yes, disable debug.
1072: AHL_DEBUG_PUB.disable_debug;

Line 1070: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1066:
1067: -- Debug info.
1068: AHL_DEBUG_PUB.log_app_messages (
1069: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1070: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1071: -- Check if API is called in debug mode. If yes, disable debug.
1072: AHL_DEBUG_PUB.disable_debug;
1073: END IF;
1074: WHEN OTHERS THEN

Line 1072: AHL_DEBUG_PUB.disable_debug;

1068: AHL_DEBUG_PUB.log_app_messages (
1069: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1070: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1071: -- Check if API is called in debug mode. If yes, disable debug.
1072: AHL_DEBUG_PUB.disable_debug;
1073: END IF;
1074: WHEN OTHERS THEN
1075: ROLLBACK TO update_simulation_plan;
1076: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1089: AHL_DEBUG_PUB.log_app_messages (

1085: p_data => X_msg_data);
1086: IF G_DEBUG='Y' THEN
1087:
1088: -- Debug info.
1089: AHL_DEBUG_PUB.log_app_messages (
1090: x_msg_count, x_msg_data, 'SQL ERROR' );
1091: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1092: -- Check if API is called in debug mode. If yes, disable debug.
1093: AHL_DEBUG_PUB.disable_debug;

Line 1091: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1087:
1088: -- Debug info.
1089: AHL_DEBUG_PUB.log_app_messages (
1090: x_msg_count, x_msg_data, 'SQL ERROR' );
1091: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1092: -- Check if API is called in debug mode. If yes, disable debug.
1093: AHL_DEBUG_PUB.disable_debug;
1094: END IF;
1095: END Update_Simulation_plan;

Line 1093: AHL_DEBUG_PUB.disable_debug;

1089: AHL_DEBUG_PUB.log_app_messages (
1090: x_msg_count, x_msg_data, 'SQL ERROR' );
1091: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1092: -- Check if API is called in debug mode. If yes, disable debug.
1093: AHL_DEBUG_PUB.disable_debug;
1094: END IF;
1095: END Update_Simulation_plan;
1096:
1097:

Line 1175: AHL_DEBUG_PUB.enable_debug;

1171: -- Standard Start of API savepoint
1172: SAVEPOINT delete_simulation_plan;
1173: -- Check if API is called in debug mode. If yes, enable debug.
1174: IF G_DEBUG='Y' THEN
1175: AHL_DEBUG_PUB.enable_debug;
1176: END IF;
1177: -- Debug info.
1178: IF G_DEBUG='Y' THEN
1179: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

Line 1179: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1175: AHL_DEBUG_PUB.enable_debug;
1176: END IF;
1177: -- Debug info.
1178: IF G_DEBUG='Y' THEN
1179: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1180: END IF;
1181: -- Standard call to check for call compatibility.
1182: IF FND_API.to_boolean(p_init_msg_list)
1183: THEN

Line 1278: Ahl_Debug_Pub.debug( 'End of private api Delete Simulation plan','+SMPLN+');

1274: COMMIT;
1275: END IF;
1276: -- Debug info
1277: IF G_DEBUG='Y' THEN
1278: Ahl_Debug_Pub.debug( 'End of private api Delete Simulation plan','+SMPLN+');
1279: END IF;
1280: -- Check if API is called in debug mode. If yes, disable debug.
1281: IF G_DEBUG='Y' THEN
1282: Ahl_Debug_Pub.disable_debug;

Line 1282: Ahl_Debug_Pub.disable_debug;

1278: Ahl_Debug_Pub.debug( 'End of private api Delete Simulation plan','+SMPLN+');
1279: END IF;
1280: -- Check if API is called in debug mode. If yes, disable debug.
1281: IF G_DEBUG='Y' THEN
1282: Ahl_Debug_Pub.disable_debug;
1283: END IF;
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1286: ROLLBACK TO delete_simulation_plan;

Line 1293: AHL_DEBUG_PUB.log_app_messages (

1289: p_count => x_msg_count,
1290: p_data => x_msg_data);
1291: IF G_DEBUG='Y' THEN
1292:
1293: AHL_DEBUG_PUB.log_app_messages (
1294: x_msg_count, x_msg_data, 'ERROR' );
1295: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1296: -- Check if API is called in debug mode. If yes, disable debug.
1297: AHL_DEBUG_PUB.disable_debug;

Line 1295: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1291: IF G_DEBUG='Y' THEN
1292:
1293: AHL_DEBUG_PUB.log_app_messages (
1294: x_msg_count, x_msg_data, 'ERROR' );
1295: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1296: -- Check if API is called in debug mode. If yes, disable debug.
1297: AHL_DEBUG_PUB.disable_debug;
1298: END IF;
1299: WHEN FND_API.G_EXC_ERROR THEN

Line 1297: AHL_DEBUG_PUB.disable_debug;

1293: AHL_DEBUG_PUB.log_app_messages (
1294: x_msg_count, x_msg_data, 'ERROR' );
1295: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1296: -- Check if API is called in debug mode. If yes, disable debug.
1297: AHL_DEBUG_PUB.disable_debug;
1298: END IF;
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: ROLLBACK TO delete_simulation_plan;
1301: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1307: AHL_DEBUG_PUB.log_app_messages (

1303: p_count => x_msg_count,
1304: p_data => X_msg_data);
1305: IF G_DEBUG='Y' THEN
1306: -- Debug info.
1307: AHL_DEBUG_PUB.log_app_messages (
1308: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1309: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1310: -- Check if API is called in debug mode. If yes, disable debug.
1311: AHL_DEBUG_PUB.disable_debug;

Line 1309: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1305: IF G_DEBUG='Y' THEN
1306: -- Debug info.
1307: AHL_DEBUG_PUB.log_app_messages (
1308: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1309: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1310: -- Check if API is called in debug mode. If yes, disable debug.
1311: AHL_DEBUG_PUB.disable_debug;
1312: END IF;
1313: WHEN OTHERS THEN

Line 1311: AHL_DEBUG_PUB.disable_debug;

1307: AHL_DEBUG_PUB.log_app_messages (
1308: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1309: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1310: -- Check if API is called in debug mode. If yes, disable debug.
1311: AHL_DEBUG_PUB.disable_debug;
1312: END IF;
1313: WHEN OTHERS THEN
1314: ROLLBACK TO delete_simulation_plan;
1315: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1328: AHL_DEBUG_PUB.log_app_messages (

1324: p_data => X_msg_data);
1325: IF G_DEBUG='Y' THEN
1326:
1327: -- Debug info.
1328: AHL_DEBUG_PUB.log_app_messages (
1329: x_msg_count, x_msg_data, 'SQL ERROR' );
1330: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1331: -- Check if API is called in debug mode. If yes, disable debug.
1332: AHL_DEBUG_PUB.disable_debug;

Line 1330: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1326:
1327: -- Debug info.
1328: AHL_DEBUG_PUB.log_app_messages (
1329: x_msg_count, x_msg_data, 'SQL ERROR' );
1330: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1331: -- Check if API is called in debug mode. If yes, disable debug.
1332: AHL_DEBUG_PUB.disable_debug;
1333: END IF;
1334: END Delete_Simulation_plan;

Line 1332: AHL_DEBUG_PUB.disable_debug;

1328: AHL_DEBUG_PUB.log_app_messages (
1329: x_msg_count, x_msg_data, 'SQL ERROR' );
1330: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1331: -- Check if API is called in debug mode. If yes, disable debug.
1332: AHL_DEBUG_PUB.disable_debug;
1333: END IF;
1334: END Delete_Simulation_plan;
1335:
1336:

Line 1728: AHL_DEBUG_PUB.enable_debug;

1724: -- Standard Start of API savepoint
1725: SAVEPOINT copy_visits_to_plan;
1726: -- Check if API is called in debug mode. If yes, enable debug.
1727: IF G_DEBUG='Y' THEN
1728: AHL_DEBUG_PUB.enable_debug;
1729: -- Debug info.
1730: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');
1731: END IF;
1732: -- Standard call to check for call compatibility.

Line 1730: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');

1726: -- Check if API is called in debug mode. If yes, enable debug.
1727: IF G_DEBUG='Y' THEN
1728: AHL_DEBUG_PUB.enable_debug;
1729: -- Debug info.
1730: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');
1731: END IF;
1732: -- Standard call to check for call compatibility.
1733: IF FND_API.to_boolean(p_init_msg_list)
1734: THEN

Line 1747: AHL_DEBUG_PUB.debug( 'visit_id'||p_visit_id);

1743: THEN
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END IF;
1746: IF G_DEBUG='Y' THEN
1747: AHL_DEBUG_PUB.debug( 'visit_id'||p_visit_id);
1748: AHL_DEBUG_PUB.debug( 'visit_number'||p_visit_number);
1749: END IF;
1750: ---------------------start API Body------------------------------------
1751: --

Line 1748: AHL_DEBUG_PUB.debug( 'visit_number'||p_visit_number);

1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END IF;
1746: IF G_DEBUG='Y' THEN
1747: AHL_DEBUG_PUB.debug( 'visit_id'||p_visit_id);
1748: AHL_DEBUG_PUB.debug( 'visit_number'||p_visit_number);
1749: END IF;
1750: ---------------------start API Body------------------------------------
1751: --
1752: IF (p_visit_number IS NOT NULL AND

Line 1768: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);

1764: CLOSE get_visit_id_cur;
1765: END IF;
1766: IF G_DEBUG='Y' THEN
1767: --
1768: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);
1769: AHL_DEBUG_PUB.debug( 'visit_number'||l_primary_visit_id);
1770: END IF;
1771: --
1772: IF (p_visit_id IS NOT NULL AND

Line 1769: AHL_DEBUG_PUB.debug( 'visit_number'||l_primary_visit_id);

1765: END IF;
1766: IF G_DEBUG='Y' THEN
1767: --
1768: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);
1769: AHL_DEBUG_PUB.debug( 'visit_number'||l_primary_visit_id);
1770: END IF;
1771: --
1772: IF (p_visit_id IS NOT NULL AND
1773: p_visit_id <> FND_API.G_MISS_NUM) THEN

Line 1849: AHL_DEBUG_PUB.debug( 'plan_id'||p_plan_id);

1845: Fnd_Msg_Pub.ADD;
1846: RAISE Fnd_Api.G_EXC_ERROR;
1847: END IF;
1848: IF G_DEBUG='Y' THEN
1849: AHL_DEBUG_PUB.debug( 'plan_id'||p_plan_id);
1850: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);
1851: AHL_DEBUG_PUB.debug( 'asso visit id'||l_primary_visit_id);
1852: END IF;
1853:

Line 1850: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);

1846: RAISE Fnd_Api.G_EXC_ERROR;
1847: END IF;
1848: IF G_DEBUG='Y' THEN
1849: AHL_DEBUG_PUB.debug( 'plan_id'||p_plan_id);
1850: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);
1851: AHL_DEBUG_PUB.debug( 'asso visit id'||l_primary_visit_id);
1852: END IF;
1853:
1854: --Change by mpothuku End

Line 1851: AHL_DEBUG_PUB.debug( 'asso visit id'||l_primary_visit_id);

1847: END IF;
1848: IF G_DEBUG='Y' THEN
1849: AHL_DEBUG_PUB.debug( 'plan_id'||p_plan_id);
1850: AHL_DEBUG_PUB.debug( 'visit_id'||l_pvisit_id);
1851: AHL_DEBUG_PUB.debug( 'asso visit id'||l_primary_visit_id);
1852: END IF;
1853:
1854: --Change by mpothuku End
1855:

Line 1857: AHL_DEBUG_PUB.debug( 'visit_type_code'||l_visit_detail_rec.visit_type_code);

1853:
1854: --Change by mpothuku End
1855:
1856: IF G_DEBUG='Y' THEN
1857: AHL_DEBUG_PUB.debug( 'visit_type_code'||l_visit_detail_rec.visit_type_code);
1858: AHL_DEBUG_PUB.debug( 'inventory_id'||l_visit_detail_rec.inventory_item_id);
1859: END IF;
1860: --Get visit id
1861: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id

Line 1858: AHL_DEBUG_PUB.debug( 'inventory_id'||l_visit_detail_rec.inventory_item_id);

1854: --Change by mpothuku End
1855:
1856: IF G_DEBUG='Y' THEN
1857: AHL_DEBUG_PUB.debug( 'visit_type_code'||l_visit_detail_rec.visit_type_code);
1858: AHL_DEBUG_PUB.debug( 'inventory_id'||l_visit_detail_rec.inventory_item_id);
1859: END IF;
1860: --Get visit id
1861: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id
1862: FROM dual;

Line 1944: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);

1940: LOOP
1941: FETCH Get_stages_cur INTO l_stage_rec;
1942: EXIT WHEN Get_stages_cur%NOTFOUND;
1943: IF G_DEBUG='Y' THEN
1944: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);
1945: END IF;
1946: -- Get visit task id
1947: /* Have to Confirm with the Stages API */
1948: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id

Line 1952: AHL_DEBUG_PUB.debug( 'visit call insert stage:'||l_stage_id);

1948: SELECT Ahl_vwp_stages_B_S.NEXTVAL into l_stage_id
1949: FROM dual;
1950: --
1951: IF G_DEBUG='Y' THEN
1952: AHL_DEBUG_PUB.debug( 'visit call insert stage:'||l_stage_id);
1953: END IF;
1954: /* Copy the details in the Simulation Visit */
1955: -- Invoke the table handler to create a record
1956: Ahl_VWP_Stages_Pkg.Insert_Row (

Line 1993: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_visit_id);

1989: X_EARLIEST_START_DATE => NULL -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
1990: );
1991:
1992: IF G_DEBUG='Y' THEN
1993: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_visit_id);
1994: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' ||l_stage_rec.Stage_Num);
1995: END IF;
1996: END LOOP;
1997: CLOSE Get_stages_cur;

Line 1994: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' ||l_stage_rec.Stage_Num);

1990: );
1991:
1992: IF G_DEBUG='Y' THEN
1993: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_visit_id);
1994: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' ||l_stage_rec.Stage_Num);
1995: END IF;
1996: END LOOP;
1997: CLOSE Get_stages_cur;
1998: --mpothuku End

Line 2007: AHL_DEBUG_PUB.debug( 'visit id before tasks:'||l_pvisit_id);

2003: FETCH check_primary_visit into l_primary_visit_check;
2004: CLOSE check_primary_visit;
2005:
2006: IF G_DEBUG='Y' THEN
2007: AHL_DEBUG_PUB.debug( 'visit id before tasks:'||l_pvisit_id);
2008: END IF;
2009: --Copy the corresponding tasks
2010: OPEN get_visit_task_cur(l_pvisit_id);
2011: LOOP

Line 2013: AHL_DEBUG_PUB.debug( 'inside loop task num:'||l_visit_task_rec.visit_task_number);

2009: --Copy the corresponding tasks
2010: OPEN get_visit_task_cur(l_pvisit_id);
2011: LOOP
2012: IF G_DEBUG='Y' THEN
2013: AHL_DEBUG_PUB.debug( 'inside loop task num:'||l_visit_task_rec.visit_task_number);
2014: END IF;
2015: FETCH get_visit_task_cur INTO l_visit_task_rec;
2016: EXIT WHEN get_visit_task_cur%NOTFOUND;
2017: -- Get visit task id

Line 2022: AHL_DEBUG_PUB.debug( 'visit call insert task:'||l_visit_task_id);

2018: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
2019: l_visit_task_id FROM dual;
2020: --
2021: IF G_DEBUG='Y' THEN
2022: AHL_DEBUG_PUB.debug( 'visit call insert task:'||l_visit_task_id);
2023: END IF;
2024:
2025: /* Added by mpothuku on 01/20/05 to Check if the UE is associated with any of the visits in the plan */
2026: IF(l_visit_task_rec.task_type_code = 'PLANNED' and l_visit_task_rec.unit_effectivity_id IS NOT NULL) THEN

Line 2388: Ahl_Debug_Pub.debug( 'End of private api Copy visits to plan','+SMPLN+');

2384: COMMIT;
2385: END IF;
2386: -- Debug info
2387: IF G_DEBUG='Y' THEN
2388: Ahl_Debug_Pub.debug( 'End of private api Copy visits to plan','+SMPLN+');
2389: -- Check if API is called in debug mode. If yes, disable debug.
2390: Ahl_Debug_Pub.disable_debug;
2391: END IF;
2392:

Line 2390: Ahl_Debug_Pub.disable_debug;

2386: -- Debug info
2387: IF G_DEBUG='Y' THEN
2388: Ahl_Debug_Pub.debug( 'End of private api Copy visits to plan','+SMPLN+');
2389: -- Check if API is called in debug mode. If yes, disable debug.
2390: Ahl_Debug_Pub.disable_debug;
2391: END IF;
2392:
2393: EXCEPTION
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2402: AHL_DEBUG_PUB.log_app_messages (

2398: p_count => x_msg_count,
2399: p_data => x_msg_data);
2400: IF G_DEBUG='Y' THEN
2401:
2402: AHL_DEBUG_PUB.log_app_messages (
2403: x_msg_count, x_msg_data, 'ERROR' );
2404: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2405: -- Check if API is called in debug mode. If yes, disable debug.
2406: AHL_DEBUG_PUB.disable_debug;

Line 2404: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2400: IF G_DEBUG='Y' THEN
2401:
2402: AHL_DEBUG_PUB.log_app_messages (
2403: x_msg_count, x_msg_data, 'ERROR' );
2404: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2405: -- Check if API is called in debug mode. If yes, disable debug.
2406: AHL_DEBUG_PUB.disable_debug;
2407: END IF;
2408:

Line 2406: AHL_DEBUG_PUB.disable_debug;

2402: AHL_DEBUG_PUB.log_app_messages (
2403: x_msg_count, x_msg_data, 'ERROR' );
2404: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2405: -- Check if API is called in debug mode. If yes, disable debug.
2406: AHL_DEBUG_PUB.disable_debug;
2407: END IF;
2408:
2409: WHEN FND_API.G_EXC_ERROR THEN
2410: ROLLBACK TO copy_visits_to_plan;

Line 2418: AHL_DEBUG_PUB.log_app_messages (

2414: p_data => X_msg_data);
2415: IF G_DEBUG='Y' THEN
2416:
2417: -- Debug info.
2418: AHL_DEBUG_PUB.log_app_messages (
2419: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2420: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2421: -- Check if API is called in debug mode. If yes, disable debug.
2422: AHL_DEBUG_PUB.disable_debug;

Line 2420: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2416:
2417: -- Debug info.
2418: AHL_DEBUG_PUB.log_app_messages (
2419: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2420: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2421: -- Check if API is called in debug mode. If yes, disable debug.
2422: AHL_DEBUG_PUB.disable_debug;
2423: END IF;
2424:

Line 2422: AHL_DEBUG_PUB.disable_debug;

2418: AHL_DEBUG_PUB.log_app_messages (
2419: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2420: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2421: -- Check if API is called in debug mode. If yes, disable debug.
2422: AHL_DEBUG_PUB.disable_debug;
2423: END IF;
2424:
2425: WHEN OTHERS THEN
2426: ROLLBACK TO copy_visits_to_plan;

Line 2440: AHL_DEBUG_PUB.log_app_messages (

2436: p_data => X_msg_data);
2437: IF G_DEBUG='Y' THEN
2438:
2439: -- Debug info.
2440: AHL_DEBUG_PUB.log_app_messages (
2441: x_msg_count, x_msg_data, 'SQL ERROR' );
2442: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2443: -- Check if API is called in debug mode. If yes, disable debug.
2444: AHL_DEBUG_PUB.disable_debug;

Line 2442: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2438:
2439: -- Debug info.
2440: AHL_DEBUG_PUB.log_app_messages (
2441: x_msg_count, x_msg_data, 'SQL ERROR' );
2442: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2443: -- Check if API is called in debug mode. If yes, disable debug.
2444: AHL_DEBUG_PUB.disable_debug;
2445: END IF;
2446:

Line 2444: AHL_DEBUG_PUB.disable_debug;

2440: AHL_DEBUG_PUB.log_app_messages (
2441: x_msg_count, x_msg_data, 'SQL ERROR' );
2442: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2443: -- Check if API is called in debug mode. If yes, disable debug.
2444: AHL_DEBUG_PUB.disable_debug;
2445: END IF;
2446:
2447: END Copy_Visits_To_Plan;
2448:

Line 2530: AHL_DEBUG_PUB.enable_debug;

2526: -- Standard Start of API savepoint
2527: SAVEPOINT remove_visits_fr_plan;
2528: -- Check if API is called in debug mode. If yes, enable debug.
2529: IF G_DEBUG='Y' THEN
2530: AHL_DEBUG_PUB.enable_debug;
2531: END IF;
2532: -- Debug info.
2533: IF G_DEBUG='Y' THEN
2534: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');

Line 2534: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');

2530: AHL_DEBUG_PUB.enable_debug;
2531: END IF;
2532: -- Debug info.
2533: IF G_DEBUG='Y' THEN
2534: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');
2535: END IF;
2536: -- Standard call to check for call compatibility.
2537: IF FND_API.to_boolean(p_init_msg_list)
2538: THEN

Line 2728: Ahl_Debug_Pub.debug( 'End of private api Remove visits from plan','+SMPLN+');

2724: COMMIT;
2725: END IF;
2726: IF G_DEBUG='Y' THEN
2727: -- Debug info
2728: Ahl_Debug_Pub.debug( 'End of private api Remove visits from plan','+SMPLN+');
2729: -- Check if API is called in debug mode. If yes, disable debug.
2730: Ahl_Debug_Pub.disable_debug;
2731: END IF;
2732:

Line 2730: Ahl_Debug_Pub.disable_debug;

2726: IF G_DEBUG='Y' THEN
2727: -- Debug info
2728: Ahl_Debug_Pub.debug( 'End of private api Remove visits from plan','+SMPLN+');
2729: -- Check if API is called in debug mode. If yes, disable debug.
2730: Ahl_Debug_Pub.disable_debug;
2731: END IF;
2732:
2733: EXCEPTION
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2742: AHL_DEBUG_PUB.log_app_messages (

2738: p_count => x_msg_count,
2739: p_data => x_msg_data);
2740: IF G_DEBUG='Y' THEN
2741:
2742: AHL_DEBUG_PUB.log_app_messages (
2743: x_msg_count, x_msg_data, 'ERROR' );
2744: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2745: -- Check if API is called in debug mode. If yes, disable debug.
2746: AHL_DEBUG_PUB.disable_debug;

Line 2744: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2740: IF G_DEBUG='Y' THEN
2741:
2742: AHL_DEBUG_PUB.log_app_messages (
2743: x_msg_count, x_msg_data, 'ERROR' );
2744: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2745: -- Check if API is called in debug mode. If yes, disable debug.
2746: AHL_DEBUG_PUB.disable_debug;
2747: END IF;
2748:

Line 2746: AHL_DEBUG_PUB.disable_debug;

2742: AHL_DEBUG_PUB.log_app_messages (
2743: x_msg_count, x_msg_data, 'ERROR' );
2744: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2745: -- Check if API is called in debug mode. If yes, disable debug.
2746: AHL_DEBUG_PUB.disable_debug;
2747: END IF;
2748:
2749: WHEN FND_API.G_EXC_ERROR THEN
2750: ROLLBACK TO remove_visits_fr_plan;

Line 2758: AHL_DEBUG_PUB.log_app_messages (

2754: p_data => X_msg_data);
2755: IF G_DEBUG='Y' THEN
2756:
2757: -- Debug info.
2758: AHL_DEBUG_PUB.log_app_messages (
2759: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2760: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2761: -- Check if API is called in debug mode. If yes, disable debug.
2762: AHL_DEBUG_PUB.disable_debug;

Line 2760: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2756:
2757: -- Debug info.
2758: AHL_DEBUG_PUB.log_app_messages (
2759: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2760: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2761: -- Check if API is called in debug mode. If yes, disable debug.
2762: AHL_DEBUG_PUB.disable_debug;
2763: END IF;
2764:

Line 2762: AHL_DEBUG_PUB.disable_debug;

2758: AHL_DEBUG_PUB.log_app_messages (
2759: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2760: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2761: -- Check if API is called in debug mode. If yes, disable debug.
2762: AHL_DEBUG_PUB.disable_debug;
2763: END IF;
2764:
2765: WHEN OTHERS THEN
2766: ROLLBACK TO remove_visits_fr_plan;

Line 2780: AHL_DEBUG_PUB.log_app_messages (

2776: p_data => X_msg_data);
2777: IF G_DEBUG='Y' THEN
2778:
2779: -- Debug info.
2780: AHL_DEBUG_PUB.log_app_messages (
2781: x_msg_count, x_msg_data, 'SQL ERROR' );
2782: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2783: -- Check if API is called in debug mode. If yes, disable debug.
2784: AHL_DEBUG_PUB.disable_debug;

Line 2782: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2778:
2779: -- Debug info.
2780: AHL_DEBUG_PUB.log_app_messages (
2781: x_msg_count, x_msg_data, 'SQL ERROR' );
2782: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2783: -- Check if API is called in debug mode. If yes, disable debug.
2784: AHL_DEBUG_PUB.disable_debug;
2785: END IF;
2786:

Line 2784: AHL_DEBUG_PUB.disable_debug;

2780: AHL_DEBUG_PUB.log_app_messages (
2781: x_msg_count, x_msg_data, 'SQL ERROR' );
2782: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2783: -- Check if API is called in debug mode. If yes, disable debug.
2784: AHL_DEBUG_PUB.disable_debug;
2785: END IF;
2786:
2787: END Remove_Visits_FR_Plan;
2788:

Line 2838: AHL_DEBUG_PUB.enable_debug;

2834: -- Standard Start of API savepoint
2835: SAVEPOINT toggle_simulation_delete;
2836: -- Check if API is called in debug mode. If yes, enable debug.
2837: IF G_DEBUG='Y' THEN
2838: AHL_DEBUG_PUB.enable_debug;
2839: -- Debug info.
2840: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');
2841: END IF;
2842: -- Standard call to check for call compatibility.

Line 2840: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');

2836: -- Check if API is called in debug mode. If yes, enable debug.
2837: IF G_DEBUG='Y' THEN
2838: AHL_DEBUG_PUB.enable_debug;
2839: -- Debug info.
2840: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');
2841: END IF;
2842: -- Standard call to check for call compatibility.
2843: IF FND_API.to_boolean(p_init_msg_list)
2844: THEN

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

2903: COMMIT;
2904: END IF;
2905: IF G_DEBUG='Y' THEN
2906: -- Debug info
2907: Ahl_Debug_Pub.debug( 'End of private api Toggle Simulation Delete','+SMPLN+');
2908: -- Check if API is called in debug mode. If yes, disable debug.
2909: Ahl_Debug_Pub.disable_debug;
2910: END IF;
2911:

Line 2909: Ahl_Debug_Pub.disable_debug;

2905: IF G_DEBUG='Y' THEN
2906: -- Debug info
2907: Ahl_Debug_Pub.debug( 'End of private api Toggle Simulation Delete','+SMPLN+');
2908: -- Check if API is called in debug mode. If yes, disable debug.
2909: Ahl_Debug_Pub.disable_debug;
2910: END IF;
2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2921: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2917: p_count => x_msg_count,
2918: p_data => x_msg_data);
2919: IF G_DEBUG='Y' THEN
2920:
2921: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2922: AHL_DEBUG_PUB.log_app_messages (
2923: x_msg_count, x_msg_data, 'ERROR' );
2924: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2925: END IF;

Line 2922: AHL_DEBUG_PUB.log_app_messages (

2918: p_data => x_msg_data);
2919: IF G_DEBUG='Y' THEN
2920:
2921: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2922: AHL_DEBUG_PUB.log_app_messages (
2923: x_msg_count, x_msg_data, 'ERROR' );
2924: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2925: END IF;
2926: -- Check if API is called in debug mode. If yes, disable debug.

Line 2924: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2920:
2921: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2922: AHL_DEBUG_PUB.log_app_messages (
2923: x_msg_count, x_msg_data, 'ERROR' );
2924: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2925: END IF;
2926: -- Check if API is called in debug mode. If yes, disable debug.
2927: AHL_DEBUG_PUB.disable_debug;
2928: END IF;

Line 2927: AHL_DEBUG_PUB.disable_debug;

2923: x_msg_count, x_msg_data, 'ERROR' );
2924: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2925: END IF;
2926: -- Check if API is called in debug mode. If yes, disable debug.
2927: AHL_DEBUG_PUB.disable_debug;
2928: END IF;
2929:
2930: WHEN FND_API.G_EXC_ERROR THEN
2931: ROLLBACK TO toggle_simulation_delete;

Line 2939: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2935: p_data => X_msg_data);
2936: IF G_DEBUG='Y' THEN
2937:
2938: -- Debug info.
2939: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2940: AHL_DEBUG_PUB.log_app_messages (
2941: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2943: END IF;

Line 2940: AHL_DEBUG_PUB.log_app_messages (

2936: IF G_DEBUG='Y' THEN
2937:
2938: -- Debug info.
2939: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2940: AHL_DEBUG_PUB.log_app_messages (
2941: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2943: END IF;
2944: -- Check if API is called in debug mode. If yes, disable debug.

Line 2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2938: -- Debug info.
2939: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2940: AHL_DEBUG_PUB.log_app_messages (
2941: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2943: END IF;
2944: -- Check if API is called in debug mode. If yes, disable debug.
2945: AHL_DEBUG_PUB.disable_debug;
2946: END IF;

Line 2945: AHL_DEBUG_PUB.disable_debug;

2941: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2943: END IF;
2944: -- Check if API is called in debug mode. If yes, disable debug.
2945: AHL_DEBUG_PUB.disable_debug;
2946: END IF;
2947:
2948: WHEN OTHERS THEN
2949: ROLLBACK TO toggle_simulation_delete;

Line 2963: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2959: p_data => X_msg_data);
2960: IF G_DEBUG='Y' THEN
2961:
2962: -- Debug info.
2963: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2964: AHL_DEBUG_PUB.log_app_messages (
2965: x_msg_count, x_msg_data, 'SQL ERROR' );
2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2967: END IF;

Line 2964: AHL_DEBUG_PUB.log_app_messages (

2960: IF G_DEBUG='Y' THEN
2961:
2962: -- Debug info.
2963: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2964: AHL_DEBUG_PUB.log_app_messages (
2965: x_msg_count, x_msg_data, 'SQL ERROR' );
2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2967: END IF;
2968: -- Check if API is called in debug mode. If yes, disable debug.

Line 2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2962: -- Debug info.
2963: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2964: AHL_DEBUG_PUB.log_app_messages (
2965: x_msg_count, x_msg_data, 'SQL ERROR' );
2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2967: END IF;
2968: -- Check if API is called in debug mode. If yes, disable debug.
2969: AHL_DEBUG_PUB.disable_debug;
2970: END IF;

Line 2969: AHL_DEBUG_PUB.disable_debug;

2965: x_msg_count, x_msg_data, 'SQL ERROR' );
2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2967: END IF;
2968: -- Check if API is called in debug mode. If yes, disable debug.
2969: AHL_DEBUG_PUB.disable_debug;
2970: END IF;
2971:
2972: END Toggle_Simulation_Delete;
2973:

Line 3036: AHL_DEBUG_PUB.enable_debug;

3032: -- Standard Start of API savepoint
3033: SAVEPOINT set_plan_as_primary;
3034: -- Check if API is called in debug mode. If yes, enable debug.
3035: IF G_DEBUG='Y' THEN
3036: AHL_DEBUG_PUB.enable_debug;
3037: END IF;
3038: -- Debug info.
3039: IF G_DEBUG='Y' THEN
3040: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');

Line 3040: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');

3036: AHL_DEBUG_PUB.enable_debug;
3037: END IF;
3038: -- Debug info.
3039: IF G_DEBUG='Y' THEN
3040: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');
3041: END IF;
3042: -- Standard call to check for call compatibility.
3043: IF FND_API.to_boolean(p_init_msg_list)
3044: THEN

Line 3133: Ahl_Debug_Pub.debug( 'End of private api Set Plan as Primary','+SMPLN+');

3129: COMMIT;
3130: END IF;
3131: -- Debug info
3132: IF G_DEBUG='Y' THEN
3133: Ahl_Debug_Pub.debug( 'End of private api Set Plan as Primary','+SMPLN+');
3134: -- Check if API is called in debug mode. If yes, disable debug.
3135: Ahl_Debug_Pub.disable_debug;
3136: END IF;
3137:

Line 3135: Ahl_Debug_Pub.disable_debug;

3131: -- Debug info
3132: IF G_DEBUG='Y' THEN
3133: Ahl_Debug_Pub.debug( 'End of private api Set Plan as Primary','+SMPLN+');
3134: -- Check if API is called in debug mode. If yes, disable debug.
3135: Ahl_Debug_Pub.disable_debug;
3136: END IF;
3137:
3138: EXCEPTION
3139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3147: AHL_DEBUG_PUB.log_app_messages (

3143: p_count => x_msg_count,
3144: p_data => x_msg_data);
3145: IF G_DEBUG='Y' THEN
3146:
3147: AHL_DEBUG_PUB.log_app_messages (
3148: x_msg_count, x_msg_data, 'ERROR' );
3149: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');
3150: -- Check if API is called in debug mode. If yes, disable debug.
3151: AHL_DEBUG_PUB.disable_debug;

Line 3149: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');

3145: IF G_DEBUG='Y' THEN
3146:
3147: AHL_DEBUG_PUB.log_app_messages (
3148: x_msg_count, x_msg_data, 'ERROR' );
3149: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');
3150: -- Check if API is called in debug mode. If yes, disable debug.
3151: AHL_DEBUG_PUB.disable_debug;
3152: END IF;
3153:

Line 3151: AHL_DEBUG_PUB.disable_debug;

3147: AHL_DEBUG_PUB.log_app_messages (
3148: x_msg_count, x_msg_data, 'ERROR' );
3149: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');
3150: -- Check if API is called in debug mode. If yes, disable debug.
3151: AHL_DEBUG_PUB.disable_debug;
3152: END IF;
3153:
3154: WHEN FND_API.G_EXC_ERROR THEN
3155: ROLLBACK TO set_plan_as_primary;

Line 3163: AHL_DEBUG_PUB.log_app_messages (

3159: p_data => X_msg_data);
3160: IF G_DEBUG='Y' THEN
3161:
3162: -- Debug info.
3163: AHL_DEBUG_PUB.log_app_messages (
3164: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3165: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');
3166: -- Check if API is called in debug mode. If yes, disable debug.
3167: AHL_DEBUG_PUB.disable_debug;

Line 3165: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');

3161:
3162: -- Debug info.
3163: AHL_DEBUG_PUB.log_app_messages (
3164: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3165: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');
3166: -- Check if API is called in debug mode. If yes, disable debug.
3167: AHL_DEBUG_PUB.disable_debug;
3168: END IF;
3169: WHEN OTHERS THEN

Line 3167: AHL_DEBUG_PUB.disable_debug;

3163: AHL_DEBUG_PUB.log_app_messages (
3164: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3165: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');
3166: -- Check if API is called in debug mode. If yes, disable debug.
3167: AHL_DEBUG_PUB.disable_debug;
3168: END IF;
3169: WHEN OTHERS THEN
3170: ROLLBACK TO set_plan_as_primary;
3171: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3184: AHL_DEBUG_PUB.log_app_messages (

3180: p_data => X_msg_data);
3181:
3182: -- Debug info.
3183: IF G_DEBUG='Y' THEN
3184: AHL_DEBUG_PUB.log_app_messages (
3185: x_msg_count, x_msg_data, 'SQL ERROR' );
3186: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');
3187: END IF;
3188: -- Check if API is called in debug mode. If yes, disable debug.

Line 3186: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');

3182: -- Debug info.
3183: IF G_DEBUG='Y' THEN
3184: AHL_DEBUG_PUB.log_app_messages (
3185: x_msg_count, x_msg_data, 'SQL ERROR' );
3186: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');
3187: END IF;
3188: -- Check if API is called in debug mode. If yes, disable debug.
3189: AHL_DEBUG_PUB.disable_debug;
3190: END Set_Plan_As_Primary;

Line 3189: AHL_DEBUG_PUB.disable_debug;

3185: x_msg_count, x_msg_data, 'SQL ERROR' );
3186: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');
3187: END IF;
3188: -- Check if API is called in debug mode. If yes, disable debug.
3189: AHL_DEBUG_PUB.disable_debug;
3190: END Set_Plan_As_Primary;
3191:
3192: --------------------------------------------------------------------
3193: -- PROCEDURE

Line 3639: AHL_DEBUG_PUB.enable_debug;

3635: -- Standard Start of API savepoint
3636: SAVEPOINT set_visit_as_primary;
3637: -- Check if API is called in debug mode. If yes, enable debug.
3638: IF G_DEBUG='Y' THEN
3639: AHL_DEBUG_PUB.enable_debug;
3640: END IF;
3641: -- Debug info.
3642: IF G_DEBUG='Y' THEN
3643: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');

Line 3643: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');

3639: AHL_DEBUG_PUB.enable_debug;
3640: END IF;
3641: -- Debug info.
3642: IF G_DEBUG='Y' THEN
3643: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');
3644: END IF;
3645: -- Standard call to check for call compatibility.
3646: IF FND_API.to_boolean(p_init_msg_list)
3647: THEN

Line 3715: AHL_DEBUG_PUB.debug( 'before update id :'||l_primary_visit_id);

3711: and a.simulation_plan_id = b.simulation_plan_id
3712: and b.primary_plan_flag = 'Y';
3713: IF G_DEBUG='Y' THEN
3714:
3715: AHL_DEBUG_PUB.debug( 'before update id :'||l_primary_visit_id);
3716: AHL_DEBUG_PUB.debug( 'before update number:'||l_primary_visit_number);
3717: END IF;
3718:
3719: --Check for simulation delete flag

Line 3716: AHL_DEBUG_PUB.debug( 'before update number:'||l_primary_visit_number);

3712: and b.primary_plan_flag = 'Y';
3713: IF G_DEBUG='Y' THEN
3714:
3715: AHL_DEBUG_PUB.debug( 'before update id :'||l_primary_visit_id);
3716: AHL_DEBUG_PUB.debug( 'before update number:'||l_primary_visit_number);
3717: END IF;
3718:
3719: --Check for simulation delete flag
3720: IF l_simul_visit_rec.simulation_delete_flag = 'Y' THEN --Remove the Primary Visit

Line 3772: AHL_DEBUG_PUB.debug( 'after else update id :'||l_primary_visit_id);

3768:
3769: ELSE --Modify the visit and its related atributes
3770:
3771: IF G_DEBUG='Y' THEN
3772: AHL_DEBUG_PUB.debug( 'after else update id :'||l_primary_visit_id);
3773: AHL_DEBUG_PUB.debug( 'after else update number:'||l_primary_visit_number);
3774: --AHL_DEBUG_PUB.debug( 'after else update date:'||l_simul_visit_rec.START_DATE_TIME);
3775: END IF;
3776: --Replace primary visit attributes with simulation visit attributes

Line 3773: AHL_DEBUG_PUB.debug( 'after else update number:'||l_primary_visit_number);

3769: ELSE --Modify the visit and its related atributes
3770:
3771: IF G_DEBUG='Y' THEN
3772: AHL_DEBUG_PUB.debug( 'after else update id :'||l_primary_visit_id);
3773: AHL_DEBUG_PUB.debug( 'after else update number:'||l_primary_visit_number);
3774: --AHL_DEBUG_PUB.debug( 'after else update date:'||l_simul_visit_rec.START_DATE_TIME);
3775: END IF;
3776: --Replace primary visit attributes with simulation visit attributes
3777: OPEN c_Visit(l_primary_visit_id);

Line 3774: --AHL_DEBUG_PUB.debug( 'after else update date:'||l_simul_visit_rec.START_DATE_TIME);

3770:
3771: IF G_DEBUG='Y' THEN
3772: AHL_DEBUG_PUB.debug( 'after else update id :'||l_primary_visit_id);
3773: AHL_DEBUG_PUB.debug( 'after else update number:'||l_primary_visit_number);
3774: --AHL_DEBUG_PUB.debug( 'after else update date:'||l_simul_visit_rec.START_DATE_TIME);
3775: END IF;
3776: --Replace primary visit attributes with simulation visit attributes
3777: OPEN c_Visit(l_primary_visit_id);
3778: FETCH c_Visit INTO c_visit_rec;

Line 3969: AHL_DEBUG_PUB.debug( 'after fetch'||l_simul_visit_task_rec.primary_visit_task_id);

3965: LOOP
3966: FETCH simul_visit_task_cur INTO l_simul_visit_task_rec;
3967:
3968: IF G_DEBUG='Y' THEN
3969: AHL_DEBUG_PUB.debug( 'after fetch'||l_simul_visit_task_rec.primary_visit_task_id);
3970: END IF;
3971:
3972: EXIT WHEN simul_visit_task_cur%NOTFOUND;
3973: --

Line 3983: AHL_DEBUG_PUB.debug( 'Primary visit task:'||l_primary_visit_task_id);

3979: FETCH check_visit_task_cur INTO l_primary_visit_task_id;
3980: CLOSE check_visit_task_cur;
3981:
3982: IF G_DEBUG='Y' THEN
3983: AHL_DEBUG_PUB.debug( 'Primary visit task:'||l_primary_visit_task_id);
3984: END IF;
3985: END IF;
3986:
3987: /* Added by mpothuku on 01/20/05 to Check if the UE is associated with any of the visits in the plan */

Line 4139: AHL_DEBUG_PUB.debug( 'visit call insert new task created in simulation:'||l_simul_visit_task_rec.visit_task_number);

4135: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
4136: l_visit_task_id FROM dual;
4137:
4138: IF G_DEBUG='Y' THEN
4139: AHL_DEBUG_PUB.debug( 'visit call insert new task created in simulation:'||l_simul_visit_task_rec.visit_task_number);
4140: END IF;
4141:
4142: l_visit_task_number := Get_Visit_Task_Number(l_primary_visit_id,l_simul_visit_task_rec.visit_task_number);
4143: Ahl_Visit_Tasks_Pkg.INSERT_ROW

Line 4215: AHL_DEBUG_PUB.debug( 'After insertion of simulation visit task:'||l_simul_visit_task_rec.visit_task_id);

4211:
4212: END IF;
4213: /* mpothuku End */
4214: IF G_DEBUG='Y' THEN
4215: AHL_DEBUG_PUB.debug( 'After insertion of simulation visit task:'||l_simul_visit_task_rec.visit_task_id);
4216: END IF;
4217: END LOOP;
4218: CLOSE simul_visit_task_cur;
4219:

Line 4226: AHL_DEBUG_PUB.debug( 'after fetch'||l_simul_visit_task_rec.primary_visit_task_id);

4222: LOOP
4223: FETCH simul_visit_task_cur INTO l_simul_visit_task_rec;
4224:
4225: IF G_DEBUG='Y' THEN
4226: AHL_DEBUG_PUB.debug( 'after fetch'||l_simul_visit_task_rec.primary_visit_task_id);
4227: END IF;
4228:
4229: EXIT WHEN simul_visit_task_cur%NOTFOUND;
4230: --Check if the task has an originating_task_id /cost_parent_id

Line 4442: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);

4438: LOOP
4439: FETCH Get_stages_cur INTO l_stage_rec;
4440: EXIT WHEN Get_stages_cur%NOTFOUND;
4441: IF G_DEBUG='Y' THEN
4442: AHL_DEBUG_PUB.debug( 'inside loop stage num:'||l_stage_rec.stage_num);
4443: END IF;
4444:
4445: -- Get Stage id of the primary Visit that has to be updated
4446: OPEN c_new_stage(l_stage_rec.stage_id,l_primary_visit_id);

Line 4451: AHL_DEBUG_PUB.debug( 'visit call update stage:'||l_stage_rec.stage_id);

4447: FETCH c_new_stage INTO l_new_stage_id,l_new_stage_name;
4448: CLOSE c_new_stage;
4449:
4450: IF G_DEBUG='Y' THEN
4451: AHL_DEBUG_PUB.debug( 'visit call update stage:'||l_stage_rec.stage_id);
4452: END IF;
4453: /* Copy the details in the Simulation Visit */
4454: -- Invoke the table handler to update a record
4455: Ahl_VWP_Stages_Pkg.Update_Row (

Line 4488: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_primary_visit_id);

4484: X_PREV_STAGE_NUM => NULL,-- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4485: X_EARLIEST_START_DATE => NULL -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4486: );
4487: IF G_DEBUG='Y' THEN
4488: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_primary_visit_id);
4489: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stage_rec.Stage_Num);
4490: END IF;
4491: END LOOP;
4492: CLOSE Get_stages_cur;

Line 4489: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stage_rec.Stage_Num);

4485: X_EARLIEST_START_DATE => NULL -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
4486: );
4487: IF G_DEBUG='Y' THEN
4488: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || l_primary_visit_id);
4489: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stage_rec.Stage_Num);
4490: END IF;
4491: END LOOP;
4492: CLOSE Get_stages_cur;
4493:

Line 4495: AHL_DEBUG_PUB.debug( 'before delete simulation visit:'||p_visit_id);

4491: END LOOP;
4492: CLOSE Get_stages_cur;
4493:
4494: IF G_DEBUG='Y' THEN
4495: AHL_DEBUG_PUB.debug( 'before delete simulation visit:'||p_visit_id);
4496: END IF;
4497:
4498: --To adjust the task times for the inserted/updated tasks
4499: AHL_VWP_TIMES_PVT.Calculate_Task_Times

Line 4640: Ahl_Debug_Pub.debug( 'End of private api Set visit Primary','+SMPLN+');

4636: COMMIT;
4637: END IF;
4638: -- Debug info
4639: IF G_DEBUG='Y' THEN
4640: Ahl_Debug_Pub.debug( 'End of private api Set visit Primary','+SMPLN+');
4641: -- Check if API is called in debug mode. If yes, disable debug.
4642: Ahl_Debug_Pub.disable_debug;
4643: END IF;
4644: --

Line 4642: Ahl_Debug_Pub.disable_debug;

4638: -- Debug info
4639: IF G_DEBUG='Y' THEN
4640: Ahl_Debug_Pub.debug( 'End of private api Set visit Primary','+SMPLN+');
4641: -- Check if API is called in debug mode. If yes, disable debug.
4642: Ahl_Debug_Pub.disable_debug;
4643: END IF;
4644: --
4645: EXCEPTION
4646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4654: AHL_DEBUG_PUB.log_app_messages (

4650: p_count => x_msg_count,
4651: p_data => x_msg_data);
4652:
4653: IF G_DEBUG='Y' THEN
4654: AHL_DEBUG_PUB.log_app_messages (
4655: x_msg_count, x_msg_data, 'ERROR' );
4656: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4657: END IF;
4658: -- Check if API is called in debug mode. If yes, disable debug.

Line 4656: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');

4652:
4653: IF G_DEBUG='Y' THEN
4654: AHL_DEBUG_PUB.log_app_messages (
4655: x_msg_count, x_msg_data, 'ERROR' );
4656: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4657: END IF;
4658: -- Check if API is called in debug mode. If yes, disable debug.
4659: AHL_DEBUG_PUB.disable_debug;
4660:

Line 4659: AHL_DEBUG_PUB.disable_debug;

4655: x_msg_count, x_msg_data, 'ERROR' );
4656: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4657: END IF;
4658: -- Check if API is called in debug mode. If yes, disable debug.
4659: AHL_DEBUG_PUB.disable_debug;
4660:
4661: WHEN FND_API.G_EXC_ERROR THEN
4662: ROLLBACK TO set_visit_as_primary;
4663: X_return_status := FND_API.G_RET_STS_ERROR;

Line 4669: AHL_DEBUG_PUB.log_app_messages (

4665: p_count => x_msg_count,
4666: p_data => X_msg_data);
4667: -- Debug info.
4668: IF G_DEBUG='Y' THEN
4669: AHL_DEBUG_PUB.log_app_messages (
4670: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4671: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');
4672: END IF;
4673: -- Check if API is called in debug mode. If yes, disable debug.

Line 4671: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');

4667: -- Debug info.
4668: IF G_DEBUG='Y' THEN
4669: AHL_DEBUG_PUB.log_app_messages (
4670: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4671: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');
4672: END IF;
4673: -- Check if API is called in debug mode. If yes, disable debug.
4674: AHL_DEBUG_PUB.disable_debug;
4675:

Line 4674: AHL_DEBUG_PUB.disable_debug;

4670: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4671: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');
4672: END IF;
4673: -- Check if API is called in debug mode. If yes, disable debug.
4674: AHL_DEBUG_PUB.disable_debug;
4675:
4676: WHEN OTHERS THEN
4677: ROLLBACK TO set_visit_as_primary;
4678: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4691: AHL_DEBUG_PUB.log_app_messages (

4687: p_data => X_msg_data);
4688:
4689: -- Debug info.
4690: IF G_DEBUG='Y' THEN
4691: AHL_DEBUG_PUB.log_app_messages (
4692: x_msg_count, x_msg_data, 'SQL ERROR' );
4693: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4694: END IF;
4695: -- Check if API is called in debug mode. If yes, disable debug.

Line 4693: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');

4689: -- Debug info.
4690: IF G_DEBUG='Y' THEN
4691: AHL_DEBUG_PUB.log_app_messages (
4692: x_msg_count, x_msg_data, 'SQL ERROR' );
4693: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4694: END IF;
4695: -- Check if API is called in debug mode. If yes, disable debug.
4696: AHL_DEBUG_PUB.disable_debug;
4697: END Set_Visit_As_Primary;

Line 4696: AHL_DEBUG_PUB.disable_debug;

4692: x_msg_count, x_msg_data, 'SQL ERROR' );
4693: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4694: END IF;
4695: -- Check if API is called in debug mode. If yes, disable debug.
4696: AHL_DEBUG_PUB.disable_debug;
4697: END Set_Visit_As_Primary;
4698: --
4699: --------------------------------------------------------------------
4700: -- PROCEDURE

Line 4760: AHL_DEBUG_PUB.enable_debug;

4756: -- Standard Start of API savepoint
4757: SAVEPOINT Delete_Simul_Visits;
4758: -- Check if API is called in debug mode. If yes, enable debug.
4759: IF G_DEBUG='Y' THEN
4760: AHL_DEBUG_PUB.enable_debug;
4761: END IF;
4762: -- Debug info.
4763: IF G_DEBUG='Y' THEN
4764: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');

Line 4764: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');

4760: AHL_DEBUG_PUB.enable_debug;
4761: END IF;
4762: -- Debug info.
4763: IF G_DEBUG='Y' THEN
4764: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');
4765: END IF;
4766: -- Standard call to check for call compatibility.
4767: IF FND_API.to_boolean(p_init_msg_list)
4768: THEN

Line 4832: Ahl_Debug_Pub.debug( 'End of private api Delete_Simul_Visits','+SMPLN+');

4828: COMMIT;
4829: END IF;
4830: -- Debug info
4831: IF G_DEBUG='Y' THEN
4832: Ahl_Debug_Pub.debug( 'End of private api Delete_Simul_Visits','+SMPLN+');
4833: -- Check if API is called in debug mode. If yes, disable debug.
4834: Ahl_Debug_Pub.disable_debug;
4835: END IF;
4836: --

Line 4834: Ahl_Debug_Pub.disable_debug;

4830: -- Debug info
4831: IF G_DEBUG='Y' THEN
4832: Ahl_Debug_Pub.debug( 'End of private api Delete_Simul_Visits','+SMPLN+');
4833: -- Check if API is called in debug mode. If yes, disable debug.
4834: Ahl_Debug_Pub.disable_debug;
4835: END IF;
4836: --
4837: EXCEPTION
4838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4846: AHL_DEBUG_PUB.log_app_messages (

4842: p_count => x_msg_count,
4843: p_data => x_msg_data);
4844:
4845: IF G_DEBUG='Y' THEN
4846: AHL_DEBUG_PUB.log_app_messages (
4847: x_msg_count, x_msg_data, 'ERROR' );
4848: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4849: END IF;
4850: -- Check if API is called in debug mode. If yes, disable debug.

Line 4848: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');

4844:
4845: IF G_DEBUG='Y' THEN
4846: AHL_DEBUG_PUB.log_app_messages (
4847: x_msg_count, x_msg_data, 'ERROR' );
4848: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4849: END IF;
4850: -- Check if API is called in debug mode. If yes, disable debug.
4851: AHL_DEBUG_PUB.disable_debug;
4852:

Line 4851: AHL_DEBUG_PUB.disable_debug;

4847: x_msg_count, x_msg_data, 'ERROR' );
4848: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4849: END IF;
4850: -- Check if API is called in debug mode. If yes, disable debug.
4851: AHL_DEBUG_PUB.disable_debug;
4852:
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: ROLLBACK TO Delete_Simul_Visits;
4855: X_return_status := FND_API.G_RET_STS_ERROR;

Line 4861: AHL_DEBUG_PUB.log_app_messages (

4857: p_count => x_msg_count,
4858: p_data => X_msg_data);
4859: -- Debug info.
4860: IF G_DEBUG='Y' THEN
4861: AHL_DEBUG_PUB.log_app_messages (
4862: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4863: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');
4864: END IF;
4865: -- Check if API is called in debug mode. If yes, disable debug.

Line 4863: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');

4859: -- Debug info.
4860: IF G_DEBUG='Y' THEN
4861: AHL_DEBUG_PUB.log_app_messages (
4862: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4863: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');
4864: END IF;
4865: -- Check if API is called in debug mode. If yes, disable debug.
4866: AHL_DEBUG_PUB.disable_debug;
4867:

Line 4866: AHL_DEBUG_PUB.disable_debug;

4862: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4863: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');
4864: END IF;
4865: -- Check if API is called in debug mode. If yes, disable debug.
4866: AHL_DEBUG_PUB.disable_debug;
4867:
4868: WHEN OTHERS THEN
4869: ROLLBACK TO Delete_Simul_Visits;
4870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4882: AHL_DEBUG_PUB.log_app_messages (

4878: p_count => x_msg_count,
4879: p_data => X_msg_data);
4880: -- Debug info.
4881: IF G_DEBUG='Y' THEN
4882: AHL_DEBUG_PUB.log_app_messages (
4883: x_msg_count, x_msg_data, 'SQL ERROR' );
4884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4885: END IF;
4886: -- Check if API is called in debug mode. If yes, disable debug.

Line 4884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');

4880: -- Debug info.
4881: IF G_DEBUG='Y' THEN
4882: AHL_DEBUG_PUB.log_app_messages (
4883: x_msg_count, x_msg_data, 'SQL ERROR' );
4884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4885: END IF;
4886: -- Check if API is called in debug mode. If yes, disable debug.
4887: AHL_DEBUG_PUB.disable_debug;
4888:

Line 4887: AHL_DEBUG_PUB.disable_debug;

4883: x_msg_count, x_msg_data, 'SQL ERROR' );
4884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4885: END IF;
4886: -- Check if API is called in debug mode. If yes, disable debug.
4887: AHL_DEBUG_PUB.disable_debug;
4888:
4889: END Delete_Simul_Visits;
4890:
4891: