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 STANDARD

Line 644: -- Standard IN Parameters :

640: -- update_wip_job api
641: -- Pre-reqs :
642: -- Parameters :
643: --
644: -- Standard IN Parameters :
645: -- p_api_version IN NUMBER Required
646: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 651: -- Standard OUT Parameters :

647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
649: -- p_interface_flag IN VARCHAR2,
650: --
651: -- Standard OUT Parameters :
652: -- x_return_status OUT VARCHAR2 Required
653: -- x_msg_count OUT NUMBER Required
654: -- x_msg_data OUT VARCHAR2 Required
655: --

Line 803: -- Standard Start of API savepoint

799: dff_default_values dff_default_values_type;
800:
801: BEGIN
802: --------------------Initialize ----------------------------------
803: -- Standard Start of API savepoint
804: SAVEPOINT create_material_reqst;
805: -- Check if API is called in debug mode. If yes, enable debug.
806: IF G_DEBUG='Y' THEN
807: AHL_DEBUG_PUB.enable_debug;

Line 815: -- Standard call to check for call compatibility.

811: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
814: END IF;
815: -- Standard call to check for call compatibility.
816: IF FND_API.to_boolean(l_init_msg_list)
817: THEN
818: FND_MSG_PUB.initialize;
819: END IF;

Line 1199: -- Standard call to get message count and if count is get message info.

1195: -- OGMA issue # 105 - end
1196:
1197: -- dbms_output.put_line( 'after uom conversion UOM:'||p_x_req_material_tbl(i).uom_code);
1198:
1199: -- Standard call to get message count and if count is get message info.
1200: l_msg_count := FND_MSG_PUB.count_msg;
1201: IF l_msg_count > 0 THEN
1202: X_msg_count := l_msg_count;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1928: --Standard check to count messages

1924: END IF;
1925: -- dbms_output.put_line( 'end of API:');
1926:
1927: ------------------------End of Body---------------------------------------
1928: --Standard check to count messages
1929: l_msg_count := Fnd_Msg_Pub.count_msg;
1930:
1931: IF l_msg_count > 0 THEN
1932: X_msg_count := l_msg_count;

Line 1937: --Standard check for commit

1933: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1934: RAISE Fnd_Api.G_EXC_ERROR;
1935: END IF;
1936:
1937: --Standard check for commit
1938: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1939: COMMIT;
1940: END IF;
1941: -- Debug info

Line 2007: -- Standard IN Parameters :

2003: -- it calls Eam Api
2004: -- Pre-reqs :
2005: -- Parameters :
2006: --
2007: -- Standard IN Parameters :
2008: -- p_api_version IN NUMBER Required
2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2015: -- Standard OUT Parameters :

2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2013: -- p_module_type IN VARCHAR2 Default NULL.
2014: --
2015: -- Standard OUT Parameters :
2016: -- x_return_status OUT VARCHAR2 Required
2017: -- x_msg_count OUT NUMBER Required
2018: -- x_msg_data OUT VARCHAR2 Required
2019: --

Line 2170: -- Standard Start of API savepoint

2166: j NUMBER;
2167: --
2168: BEGIN
2169: --------------------Initialize ----------------------------------
2170: -- Standard Start of API savepoint
2171: SAVEPOINT update_material_reqst;
2172: -- Check if API is called in debug mode. If yes, enable debug.
2173: IF G_DEBUG='Y' THEN
2174: AHL_DEBUG_PUB.enable_debug;

Line 2178: -- Standard call to check for call compatibility.

2174: AHL_DEBUG_PUB.enable_debug;
2175: -- Debug info.
2176: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
2177: END IF;
2178: -- Standard call to check for call compatibility.
2179: IF FND_API.to_boolean(p_init_msg_list)
2180: THEN
2181: FND_MSG_PUB.initialize;
2182: END IF;

Line 2351: --Standard check to count messages

2347: p_x_req_material_tbl(i).requested_date := l_req_material_rec.requested_date;
2348:
2349: END IF; --Module type
2350:
2351: --Standard check to count messages
2352: l_msg_count := Fnd_Msg_Pub.count_msg;
2353:
2354: IF l_msg_count > 0 THEN
2355: X_msg_count := l_msg_count;

Line 2791: --Standard check to count messages

2787: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');
2788: END IF;
2789: --
2790: ------------------------End of Body---------------------------------------
2791: --Standard check to count messages
2792: l_msg_count := Fnd_Msg_Pub.count_msg;
2793:
2794: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
2795: --Ignore messages in stack if return status is S after calls to EAM APIs.

Line 2804: --Standard check for commit

2800: RAISE Fnd_Api.G_EXC_ERROR;
2801: END IF;
2802: */
2803:
2804: --Standard check for commit
2805: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2806: COMMIT;
2807: END IF;
2808: -- Debug info

Line 2872: -- Standard IN Parameters :

2868: -- Calls Eam APi to remove material request
2869: -- Pre-reqs :
2870: -- Parameters :
2871: --
2872: -- Standard IN Parameters :
2873: -- p_api_version IN NUMBER Required
2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2880: -- Standard OUT Parameters :

2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2878: -- p_module_type IN VARCHAR2 Default NULL.
2879: --
2880: -- Standard OUT Parameters :
2881: -- x_return_status OUT VARCHAR2 Required
2882: -- x_msg_count OUT NUMBER Required
2883: -- x_msg_data OUT VARCHAR2 Required
2884: --

Line 3005: -- Standard local variable

3001: AND MRV.EXTERNAL_SOURCE_CODE = 'AHL'
3002: AND MRV.DEMAND_SOURCE_HEADER_ID = c_wip_entity_id
3003: AND MRV.DEMAND_SOURCE_LINE_ID = c_oper_seq_num;
3004:
3005: -- Standard local variable
3006: l_api_name CONSTANT VARCHAR2(30) := 'REMOVE_MATERIAL_REQUEST';
3007: l_api_version CONSTANT NUMBER := 1.0;
3008: l_return_status VARCHAR2(1);
3009: l_msg_data VARCHAR2(200);

Line 3033: -- Standard Start of API savepoint

3029: l_wo_status VARCHAR2(30);
3030: -- Bug # 6680137 - end
3031: BEGIN
3032: --------------------Initialize ----------------------------------
3033: -- Standard Start of API savepoint
3034: SAVEPOINT remove_material_request;
3035: -- Check if API is called in debug mode. If yes, enable debug.
3036: IF G_DEBUG='Y' THEN
3037: Ahl_Debug_Pub.enable_debug;

Line 3042: -- Standard call to check for call compatibility.

3038: -- Debug info.
3039: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3040: --
3041: END IF;
3042: -- Standard call to check for call compatibility.
3043: IF Fnd_Api.to_boolean(p_init_msg_list)
3044: THEN
3045: Fnd_Msg_Pub.initialize;
3046: END IF;

Line 3140: --Standard check to count messages

3136: END IF;
3137: --
3138: END IF;
3139:
3140: --Standard check to count messages
3141: l_msg_count := Fnd_Msg_Pub.count_msg;
3142:
3143: IF l_msg_count > 0 THEN
3144: X_msg_count := l_msg_count;

Line 3279: --Standard check to count messages

3275: RAISE Fnd_Api.G_EXC_ERROR;
3276: --
3277: END IF; --Status
3278: ---------------------------End of Body---------------------------------------
3279: --Standard check to count messages
3280: l_msg_count := Fnd_Msg_Pub.count_msg;
3281:
3282: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
3283: --Ignore messages in stack if return status is S after calls to EAM APIs.

Line 3291: --Standard check for commit

3287: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3288: RAISE Fnd_Api.G_EXC_ERROR;
3289: END IF;
3290: */
3291: --Standard check for commit
3292: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3293: COMMIT;
3294: END IF;
3295: -- Debug info

Line 3365: -- Standard IN Parameters :

3361: -- Routine jobs based on operation flag
3362: -- Pre-reqs :
3363: -- Parameters :
3364: --
3365: -- Standard IN Parameters :
3366: -- p_api_version IN NUMBER Required
3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3373: -- Standard OUT Parameters :

3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3371: -- p_module_type IN VARCHAR2 Default NULL.
3372: --
3373: -- Standard OUT Parameters :
3374: -- x_return_status OUT VARCHAR2 Required
3375: -- x_msg_count OUT NUMBER Required
3376: -- x_msg_data OUT VARCHAR2 Required
3377: --

Line 3416: -- Standard Start of API savepoint

3412: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;
3413:
3414: BEGIN
3415: --------------------Initialize ----------------------------------
3416: -- Standard Start of API savepoint
3417: SAVEPOINT process_material_request;
3418: -- Check if API is called in debug mode. If yes, enable debug.
3419: IF G_DEBUG='Y' THEN
3420: AHL_DEBUG_PUB.enable_debug;

Line 3425: -- Standard call to check for call compatibility.

3421: -- Debug info.
3422: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. process material request','+PPMRP+');
3423: --
3424: END IF;
3425: -- Standard call to check for call compatibility.
3426: IF FND_API.to_boolean(p_init_msg_list)
3427: THEN
3428: FND_MSG_PUB.initialize;
3429: END IF;

Line 3532: --Standard check to count messages

3528: END IF;
3529:
3530: END IF;
3531: ------------------------End of Body---------------------------------------
3532: --Standard check to count messages
3533: l_msg_count := Fnd_Msg_Pub.count_msg;
3534:
3535: IF l_msg_count > 0 THEN
3536: X_msg_count := l_msg_count;

Line 3541: --Standard check for commit

3537: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: RAISE Fnd_Api.G_EXC_ERROR;
3539: END IF;
3540:
3541: --Standard check for commit
3542: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3543: COMMIT;
3544: END IF;
3545: -- Debug info

Line 3715: -- p_standard_rate_flag_code IN NUMBER Default NULL,

3711: -- p_cost_basis_code IN NUMBER Default NULL,
3712: -- p_total_required IN NUMBER Default NULL,
3713: -- p_assigned_units IN NUMBER Default NULL,
3714: -- p_autocharge_type_code IN NUMBER Default NULL,
3715: -- p_standard_rate_flag_code IN NUMBER Default NULL,
3716: -- p_applied_resource_units IN NUMBER Default NULL,
3717: -- p_applied_resource_value IN NUMBER Default NULL,
3718: -- p_inventory_item_id IN NUMBER Default NULL,
3719: -- p_scheduled_quantity IN NUMBER Default NULL,

Line 3774: p_standard_rate_flag_code IN NUMBER := NULL,

3770: p_cost_basis_code IN NUMBER := NULL,
3771: p_total_required IN NUMBER := NULL,
3772: p_assigned_units IN NUMBER := NULL,
3773: p_autocharge_type_code IN NUMBER := NULL,
3774: p_standard_rate_flag_code IN NUMBER := NULL,
3775: p_applied_resource_units IN NUMBER := NULL,
3776: p_applied_resource_value IN NUMBER := NULL,
3777: p_inventory_item_id IN NUMBER := NULL,
3778: p_scheduled_quantity IN NUMBER := NULL,

Line 3830: standard_rate_flag_code ,

3826: cost_basis_code ,
3827: total_required ,
3828: assigned_units ,
3829: autocharge_type_code ,
3830: standard_rate_flag_code ,
3831: applied_resource_units ,
3832: applied_resource_value ,
3833: inventory_item_id ,
3834: scheduled_quantity ,

Line 3885: p_standard_rate_flag_code ,

3881: p_cost_basis_code ,
3882: p_total_required ,
3883: p_assigned_units ,
3884: p_autocharge_type_code ,
3885: p_standard_rate_flag_code ,
3886: p_applied_resource_units ,
3887: p_applied_resource_value ,
3888: p_inventory_item_id ,
3889: p_scheduled_quantity ,

Line 4034: -- Standard IN Parameters :

4030: --
4031: -- Pre-reqs :
4032: -- Parameters :
4033: --
4034: -- Standard IN Parameters :
4035: -- p_api_version IN NUMBER Required
4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 4040: -- Standard OUT Parameters :

4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4039: -- Based on this flag, the API will set the default attributes.
4040: -- Standard OUT Parameters :
4041: -- x_return_status OUT VARCHAR2 Required
4042: -- x_msg_count OUT NUMBER Required
4043: -- x_msg_data OUT VARCHAR2 Required
4044: --

Line 4132: -- Standard Start of API savepoint

4128: 'At the start of PLSQL procedure'
4129: );
4130: END IF;
4131: --------------------Initialize ----------------------------------
4132: -- Standard Start of API savepoint
4133: SAVEPOINT Process_Wo_Op_Materials;
4134: -- Standard call to check for call compatibility.
4135: IF FND_API.to_boolean(p_init_msg_list)
4136: THEN

Line 4134: -- Standard call to check for call compatibility.

4130: END IF;
4131: --------------------Initialize ----------------------------------
4132: -- Standard Start of API savepoint
4133: SAVEPOINT Process_Wo_Op_Materials;
4134: -- Standard call to check for call compatibility.
4135: IF FND_API.to_boolean(p_init_msg_list)
4136: THEN
4137: FND_MSG_PUB.initialize;
4138: END IF;

Line 4434: --Standard check to count messages

4430: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);
4431: END IF;
4432:
4433: ------------------------End of Body---------------------------------------
4434: --Standard check to count messages
4435: l_msg_count := Fnd_Msg_Pub.count_msg;
4436:
4437: IF l_msg_count > 0 THEN
4438: X_msg_count := l_msg_count;

Line 4443: --Standard check for commit

4439: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4440: RAISE Fnd_Api.G_EXC_ERROR;
4441: END IF;
4442:
4443: --Standard check for commit
4444: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4445: COMMIT;
4446: END IF;
4447: -- Debug info

Line 4496: -- Standard IN Parameters :

4492: --
4493: -- Pre-reqs :
4494: -- Parameters :
4495: --
4496: -- Standard IN Parameters :
4497: -- p_api_version IN NUMBER Required
4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 4502: -- Standard OUT Parameters :

4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4501: -- Based on this flag, the API will set the default attributes.
4502: -- Standard OUT Parameters :
4503: -- x_return_status OUT VARCHAR2 Required
4504: -- x_msg_count OUT NUMBER Required
4505: -- x_msg_data OUT VARCHAR2 Required
4506: --

Line 4626: -- Standard Start of API savepoint

4622: 'At the start of PLSQL procedure'
4623: );
4624: END IF;
4625:
4626: -- Standard Start of API savepoint
4627: SAVEPOINT Material_Notification;
4628: -- Initialize message list if p_init_msg_list is set to TRUE.
4629: IF FND_API.to_boolean(p_init_msg_list)
4630: THEN

Line 4635: -- Standard call to check for call compatibility.

4631: FND_MSG_PUB.initialize;
4632: END IF;
4633: -- Initialize API return status to success
4634: x_return_status := FND_API.G_RET_STS_SUCCESS;
4635: -- Standard call to check for call compatibility.
4636: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
4637: l_api_version,
4638: l_api_name,G_PKG_NAME)
4639: THEN