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_PP_MATERIALS_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 1: PACKAGE BODY AHL_PP_MATERIALS_PVT AS

1: PACKAGE BODY AHL_PP_MATERIALS_PVT AS
2: /* $Header: AHLVPPMB.pls 120.25.12020000.2 2012/12/07 11:33:38 sareepar ship $*/
3: --
4: -----------------------
5: -- Declare Constants --

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

3: --
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_MATERIALS_PVT';
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9: -------------------------------------------------
10: -- Declare Locally used Record and Table Types --
11: -------------------------------------------------

Line 2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2790: p_data => x_msg_data);
2791: IF G_DEBUG='Y' THEN
2792: AHL_DEBUG_PUB.log_app_messages (
2793: x_msg_count, x_msg_data, 'ERROR' );
2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2795: -- Check if API is called in debug mode. If yes, disable debug.
2796: AHL_DEBUG_PUB.disable_debug;
2797: END IF;
2798: WHEN FND_API.G_EXC_ERROR THEN

Line 2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2804: IF G_DEBUG='Y' THEN
2805: -- Debug info.
2806: AHL_DEBUG_PUB.log_app_messages (
2807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2809: -- Check if API is called in debug mode. If yes, disable debug.
2810: AHL_DEBUG_PUB.disable_debug;
2811: END IF;
2812: WHEN OTHERS THEN

Line 2817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

2813: ROLLBACK TO create_material_reqst;
2814: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2816: THEN
2817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
2818: p_procedure_name => 'CREATE_MATERIAL_REQST',
2819: p_error_text => SUBSTR(SQLERRM,1,240));
2820: END IF;
2821: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2824: IF G_DEBUG='Y' THEN
2825: -- Debug info.
2826: AHL_DEBUG_PUB.log_app_messages (
2827: x_msg_count, x_msg_data, 'SQL ERROR' );
2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2829: -- Check if API is called in debug mode. If yes, disable debug.
2830: AHL_DEBUG_PUB.disable_debug;
2831: END IF;
2832: END Create_Material_Reqst;

Line 2856: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

2852: -- x_msg_count OUT NUMBER Required
2853: -- x_msg_data OUT VARCHAR2 Required
2854: --
2855: -- Update Material Request Parameters:
2856: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2857: -- Contains material information to perform material reservation
2858: --
2859: -- Version :
2860: -- Initial Version 1.0

Line 2869: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

2865: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2866: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
2867: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2868: p_module_type IN VARCHAR2 := NULL,
2869: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2870: x_return_status OUT NOCOPY VARCHAR2,
2871: x_msg_count OUT NOCOPY NUMBER,
2872: x_msg_data OUT NOCOPY VARCHAR2
2873: )

Line 3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3713: p_data => x_msg_data);
3714: IF G_DEBUG='Y' THEN
3715: AHL_DEBUG_PUB.log_app_messages (
3716: x_msg_count, x_msg_data, 'ERROR' );
3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3718: -- Check if API is called in debug mode. If yes, disable debug.
3719: AHL_DEBUG_PUB.disable_debug;
3720: END IF;
3721: WHEN FND_API.G_EXC_ERROR THEN

Line 3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3727: IF G_DEBUG='Y' THEN
3728: -- Debug info.
3729: AHL_DEBUG_PUB.log_app_messages (
3730: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3732: -- Check if API is called in debug mode. If yes, disable debug.
3733: AHL_DEBUG_PUB.disable_debug;
3734: END IF;
3735: WHEN OTHERS THEN

Line 3740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

3736: ROLLBACK TO update_material_reqst;
3737: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3738: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3739: THEN
3740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
3741: p_procedure_name => 'UPDATE_MATERIAL_REQST',
3742: p_error_text => SUBSTR(SQLERRM,1,240));
3743: END IF;
3744: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3747: IF G_DEBUG='Y' THEN
3748: -- Debug info.
3749: AHL_DEBUG_PUB.log_app_messages (
3750: x_msg_count, x_msg_data, 'SQL ERROR' );
3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3752: -- Check if API is called in debug mode. If yes, disable debug.
3753: AHL_DEBUG_PUB.disable_debug;
3754: END IF;
3755: END Update_Material_Reqst;

Line 3778: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

3774: -- x_msg_count OUT NUMBER Required
3775: -- x_msg_data OUT VARCHAR2 Required
3776: --
3777: -- Remove Material Request Parameters:
3778: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
3779: -- Contains material information to perform material reservation
3780: --
3781: -- Version :
3782: -- Initial Version 1.0

Line 3791: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

3787: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
3788: p_commit IN VARCHAR2 := Fnd_Api.g_false,
3789: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
3790: p_module_type IN VARCHAR2 := 'JSP',
3791: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
3792: x_return_status OUT NOCOPY VARCHAR2,
3793: x_msg_count OUT NOCOPY NUMBER,
3794: x_msg_data OUT NOCOPY VARCHAR2
3795: )

Line 3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');

3925: -- Check if API is called in debug mode. If yes, enable debug.
3926: IF G_DEBUG='Y' THEN
3927: Ahl_Debug_Pub.enable_debug;
3928: -- Debug info.
3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3930: --
3931: END IF;
3932: -- Standard call to check for call compatibility.
3933: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

4179: p_data => x_msg_data);
4180: IF G_DEBUG='Y' THEN
4181: Ahl_Debug_Pub.log_app_messages (
4182: x_msg_count, x_msg_data, 'ERROR' );
4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4184: -- Check if API is called in debug mode. If yes, disable debug.
4185: Ahl_Debug_Pub.disable_debug;
4186: END IF;
4187: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

4193: IF G_DEBUG='Y' THEN
4194: -- Debug info.
4195: Ahl_Debug_Pub.log_app_messages (
4196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4198: -- Check if API is called in debug mode. If yes, disable debug.
4199: Ahl_Debug_Pub.disable_debug;
4200: END IF;
4201: WHEN OTHERS THEN

Line 4206: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

4202: ROLLBACK TO remove_material_request;
4203: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4204: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4205: THEN
4206: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
4207: p_procedure_name => 'REMOVE_MATERIAL_REQUEST',
4208: p_error_text => SUBSTR(SQLERRM,1,240));
4209: END IF;
4210: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');

4213: IF G_DEBUG='Y' THEN
4214: -- Debug info.
4215: Ahl_Debug_Pub.log_app_messages (
4216: x_msg_count, x_msg_data, 'SQL ERROR' );
4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
4218: -- Check if API is called in debug mode. If yes, disable debug.
4219: Ahl_Debug_Pub.disable_debug;
4220: END IF;
4221: END Remove_Material_Request;

Line 4244: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

4240: -- x_msg_count OUT NUMBER Required
4241: -- x_msg_data OUT VARCHAR2 Required
4242: --
4243: -- Remove Material Request Parameters:
4244: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
4245: -- Contains material information to perform material reservation
4246: --
4247: -- Version :
4248: -- Initial Version 1.0

Line 4257: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

4253: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
4254: p_commit IN VARCHAR2 := Fnd_Api.g_false,
4255: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
4256: p_module_type IN VARCHAR2 := 'API',
4257: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
4258: x_return_status OUT NOCOPY VARCHAR2,
4259: x_msg_count OUT NOCOPY NUMBER,
4260: x_msg_data OUT NOCOPY VARCHAR2
4261: )

Line 4795: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

4791: ROLLBACK TO Change_Requirement_Item;
4792: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4794: THEN
4795: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
4796: p_procedure_name => 'Change_Requirement_Item',
4797: p_error_text => SUBSTR(SQLERRM,1,240));
4798: END IF;
4799: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4828: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

4824: -- x_msg_count OUT NUMBER Required
4825: -- x_msg_data OUT VARCHAR2 Required
4826: --
4827: -- Process Material Request Parameters:
4828: -- p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
4829: -- Contains material information to perform material reservation depending
4830: -- on operation flag
4831: --
4832: -- Version :

Line 4842: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

4838: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
4839: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
4840: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
4841: p_module_type IN VARCHAR2 := NULL,
4842: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
4843: x_return_status OUT NOCOPY VARCHAR2,
4844: x_msg_count OUT NOCOPY NUMBER,
4845: x_msg_data OUT NOCOPY VARCHAR2
4846: )

Line 4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4852: l_job_return_status VARCHAR2(1);
4853: l_msg_data VARCHAR2(2000);
4854: l_interface_flag VARCHAR2(1) := NULL;
4855: l_called_module VARCHAR2(10) := 'UI';
4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

Line 4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4853: l_msg_data VARCHAR2(2000);
4854: l_interface_flag VARCHAR2(1) := NULL;
4855: l_called_module VARCHAR2(10) := 'UI';
4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4861: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;

Line 4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4854: l_interface_flag VARCHAR2(1) := NULL;
4855: l_called_module VARCHAR2(10) := 'UI';
4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4861: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;
4862:

Line 4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4855: l_called_module VARCHAR2(10) := 'UI';
4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4861: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;
4862:
4863: --Added by debadey for Aog notification

Line 4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4856: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4857: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4858: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4859: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4860: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4861: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;
4862:
4863: --Added by debadey for Aog notification
4864: l_asm_id_tbl AHL_MM_MTL_MGT_PVT.number_table_type;

Line 5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5127: p_data => x_msg_data);
5128: IF G_DEBUG='Y' THEN
5129: AHL_DEBUG_PUB.log_app_messages (
5130: x_msg_count, x_msg_data, 'ERROR' );
5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5132: -- Check if API is called in debug mode. If yes, disable debug.
5133: AHL_DEBUG_PUB.disable_debug;
5134: END IF;
5135: WHEN FND_API.G_EXC_ERROR THEN

Line 5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5141: IF G_DEBUG='Y' THEN
5142: -- Debug info.
5143: AHL_DEBUG_PUB.log_app_messages (
5144: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5146: -- Check if API is called in debug mode. If yes, disable debug.
5147: AHL_DEBUG_PUB.disable_debug;
5148: --
5149: END IF;

Line 5155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

5151: ROLLBACK TO process_material_request;
5152: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5154: THEN
5155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
5156: p_procedure_name => 'PROCESS_MATERIAL_REQUEST',
5157: p_error_text => SUBSTR(SQLERRM,1,240));
5158: END IF;
5159: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5162: IF G_DEBUG='Y' THEN
5163: -- Debug info.
5164: AHL_DEBUG_PUB.log_app_messages (
5165: x_msg_count, x_msg_data, 'SQL ERROR' );
5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5167: -- Check if API is called in debug mode. If yes, disable debug.
5168: AHL_DEBUG_PUB.disable_debug;
5169: END IF;
5170: END Process_Material_Request;

Line 5564: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',

5560: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5561: -- fnd_log.string
5562: -- (
5563: -- fnd_log.level_statement,
5564: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',
5565: -- 'l_net_qty -> ' || l_net_qty
5566: -- );
5567: -- END IF;
5568: return l_net_qty;

Line 5687: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',

5683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5684: fnd_log.string
5685: (
5686: fnd_log.level_procedure,
5687: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',
5688: 'At the start of PLSQL procedure'
5689: );
5690: END IF;
5691: --------------------Initialize ----------------------------------

Line 6022: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',

6018: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6019: fnd_log.string
6020: (
6021: fnd_log.level_procedure,
6022: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',
6023: 'At the end of PLSQL procedure'
6024: );
6025: END IF;
6026: EXCEPTION

Line 6044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

6040: ROLLBACK TO Process_Wo_Op_Materials;
6041: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6043: THEN
6044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
6045: p_procedure_name => 'PROCESS_WO_OP_MATERIALS',
6046: p_error_text => SUBSTR(SQLERRM,1,240));
6047: END IF;
6048: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',

6174: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6175: fnd_log.string
6176: (
6177: fnd_log.level_procedure,
6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
6179: 'At the start of PLSQL procedure'
6180: );
6181: END IF;
6182: -- Standard Start of API savepoint

Line 6321: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',

6317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6318: fnd_log.string
6319: (
6320: fnd_log.level_procedure,
6321: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',
6322: 'At the end of PLSQL procedure'
6323: );
6324: END IF;
6325: EXCEPTION

Line 6499: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

6495:
6496: --Local Variable Declaration
6497: l_api_name CONSTANT VARCHAR2(30) := 'Wo_Mat_Req_Item_Change';
6498: l_api_version CONSTANT NUMBER := 1.0;
6499: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
6500: l_inventory_item_id NUMBER := NULL;
6501: l_msg_data VARCHAR2(2000);
6502: l_msg_count NUMBER;
6503: l_return_status VARCHAR2(1);

Line 6504: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

6500: l_inventory_item_id NUMBER := NULL;
6501: l_msg_data VARCHAR2(2000);
6502: l_msg_count NUMBER;
6503: l_return_status VARCHAR2(1);
6504: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
6505: l_uom_code MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
6506: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
6507: l_current_mat_dtl_rec Get_WO_Mat_Details%ROWTYPE;
6508: l_uc_header_id NUMBER;

Line 6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6674: p_data => x_msg_data);
6675: IF G_DEBUG='Y' THEN
6676: AHL_DEBUG_PUB.log_app_messages (
6677: x_msg_count, x_msg_data, 'ERROR' );
6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6679: -- Check if API is called in debug mode. If yes, disable debug.
6680: AHL_DEBUG_PUB.disable_debug;
6681: END IF;
6682: WHEN FND_API.G_EXC_ERROR THEN

Line 6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6688: IF G_DEBUG='Y' THEN
6689: -- Debug info.
6690: AHL_DEBUG_PUB.log_app_messages (
6691: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6693: -- Check if API is called in debug mode. If yes, disable debug.
6694: AHL_DEBUG_PUB.disable_debug;
6695: END IF;
6696: WHEN OTHERS THEN

Line 6701: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',

6697: ROLLBACK TO Wo_Mat_Req_Item_Change;
6698: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6700: THEN
6701: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
6702: p_procedure_name => 'Wo_Mat_Req_Item_Change',
6703: p_error_text => SUBSTR(SQLERRM,1,240));
6704: END IF;
6705: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6708: IF G_DEBUG='Y' THEN
6709: -- Debug info.
6710: AHL_DEBUG_PUB.log_app_messages (
6711: x_msg_count, x_msg_data, 'SQL ERROR' );
6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6713: -- Check if API is called in debug mode. If yes, disable debug.
6714: AHL_DEBUG_PUB.disable_debug;
6715: END IF;
6716:

Line 6719: END AHL_PP_MATERIALS_PVT;

6715: END IF;
6716:
6717: END Wo_Mat_Req_Item_Change;
6718:
6719: END AHL_PP_MATERIALS_PVT;