APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on AHL_PRD_SERN_CHANGE_PVT

Line 1: PACKAGE BODY AHL_PRD_SERN_CHANGE_PVT AS

1: PACKAGE BODY AHL_PRD_SERN_CHANGE_PVT AS
2: /* $Header: AHLVSNCB.pls 120.5 2008/04/03 13:23:49 adivenka ship $ */
3: --
4: -----------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_SERN_CHANGE_PVT';

3: --
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_SERN_CHANGE_PVT';
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9:
10: -------------------------------------------------
11: -- Declare Local Procedures --

Line 550: AHL_DEBUG_PUB.debug( 'enter ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

546: --------------
547: -- Debug info.
548: --------------
549: IF G_DEBUG='Y' THEN
550: AHL_DEBUG_PUB.debug( 'enter ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
551: END IF;
552:
553: ------------------------------------------------
554: -- Standard call to check for call compatibility.

Line 1122: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1118: p_data => x_msg_data);
1119: IF G_DEBUG='Y' THEN
1120: AHL_DEBUG_PUB.log_app_messages (
1121: x_msg_count, x_msg_data, 'ERROR' );
1122: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1123: -- Check if API is called in debug mode. If yes, disable debug.
1124: AHL_DEBUG_PUB.disable_debug;
1125: END IF;
1126:

Line 1137: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1133: IF G_DEBUG='Y' THEN
1134: -- Debug info.
1135: AHL_DEBUG_PUB.log_app_messages (
1136: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1137: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1138: -- Check if API is called in debug mode. If yes, disable debug.
1139: AHL_DEBUG_PUB.disable_debug;
1140: END IF;
1141: WHEN OTHERS THEN

Line 1146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',

1142: ROLLBACK TO Process_Serialnum_Change;
1143: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',
1147: p_procedure_name => 'PROCESS_SERIALNUM_CHANGE',
1148: p_error_text => SUBSTR(SQLERRM,1,240));
1149: END IF;
1150: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1157: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1153: IF G_DEBUG='Y' THEN
1154: -- Debug info.
1155: AHL_DEBUG_PUB.log_app_messages (
1156: x_msg_count, x_msg_data, 'SQL ERROR' );
1157: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1158: -- Check if API is called in debug mode. If yes, disable debug.
1159: AHL_DEBUG_PUB.disable_debug;
1160: END IF;
1161:

Line 1164: END AHL_PRD_SERN_CHANGE_PVT;

1160: END IF;
1161:
1162: END Process_Serialnum_Change;
1163:
1164: END AHL_PRD_SERN_CHANGE_PVT;