APPS.AHL_WARRANTY_UTILS_PVT dependencies on AHL_WARRANTY_UTILS_PVT

Line 1: PACKAGE BODY AHL_WARRANTY_UTILS_PVT AS

1: PACKAGE BODY AHL_WARRANTY_UTILS_PVT AS
2: /* $Header: AHLVSWUB.pls 120.7.12020000.2 2012/12/07 14:55:41 sareepar ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WARRANTY_UTILS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WARRANTY_UTILS_PVT';

1: PACKAGE BODY AHL_WARRANTY_UTILS_PVT AS
2: /* $Header: AHLVSWUB.pls 120.7.12020000.2 2012/12/07 14:55:41 sareepar ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WARRANTY_UTILS_PVT';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7:
8: ------------------------------------
9: -- Common constants and variables --

Line 1156: -- p_trunover_notes_tbl IN OUT AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type Required

1152: -- x_msg_count OUT NUMBER Required
1153: -- x_msg_data OUT VARCHAR2 Required
1154: --
1155: -- Insert Turnover Notes Parameters:
1156: -- p_trunover_notes_tbl IN OUT AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type Required
1157: --
1158: -- Version :
1159: -- 06-Oct-2010 SUKHWSIN Initial Creation
1160: -------------------------------------------------------------------

Line 1172: p_trunover_notes_tbl IN OUT NOCOPY AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type

1168: p_module_type IN VARCHAR2 := Null,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_msg_count OUT NOCOPY NUMBER,
1171: x_msg_data OUT NOCOPY VARCHAR2,
1172: p_trunover_notes_tbl IN OUT NOCOPY AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type
1173: )
1174: IS
1175: l_api_version CONSTANT NUMBER := 1.0;
1176: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Turnover_Notes';

Line 1182: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.begin',

1178: BEGIN
1179:
1180: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string (fnd_log.level_procedure,
1182: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.begin',
1183: 'At the start of PLSQL procedure'
1184: );
1185: END IF;
1186:

Line 1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',

1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1201: fnd_log.string(
1202: fnd_log.level_statement,
1203: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1204: 'p_init_message_list : ' || p_init_msg_list
1205: );
1206:
1207: fnd_log.string(

Line 1209: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',

1205: );
1206:
1207: fnd_log.string(
1208: fnd_log.level_statement,
1209: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1210: 'p_commit : ' || p_commit
1211: );
1212:
1213: END IF;

Line 1228: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',

1224: FND_MSG_PUB.ADD;
1225: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(
1227: fnd_log.level_error,
1228: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1229: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1230: );
1231: END IF;
1232: END IF;

Line 1242: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',

1238:
1239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1240: fnd_log.string(
1241: fnd_log.level_error,
1242: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes',
1243: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
1244: );
1245: END IF;
1246: END IF;

Line 1298: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.end',

1294:
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1296: fnd_log.string(
1297: fnd_log.level_procedure,
1298: 'ahl.plsql.AHL_WARRANTY_UTILS_PVT.Insert_Turnover_Notes.end',
1299: 'At the end of PLSQL procedure'
1300: );
1301:
1302: END IF;

Line 1362: END AHL_WARRANTY_UTILS_PVT;

1358: -- return the value
1359: RETURN l_ret_val;
1360: END Is_Warranty_Edit_Allowed;
1361:
1362: END AHL_WARRANTY_UTILS_PVT;