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_RESRC_REQUIRE_PVT dependencies on STANDARD

Line 1188: -- Standard IN Parameters :

1184: -- Type : Private
1185: -- Pre-reqs :
1186: -- Parameters :
1187: --
1188: -- Standard IN Parameters :
1189: -- p_api_version IN NUMBER Required
1190: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1191: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1192: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1196: -- Standard OUT Parameters :

1192: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1193: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1194: -- p_module_type IN VARCHAR2 Default NULL.
1195: --
1196: -- Standard OUT Parameters :
1197: -- x_return_status OUT VARCHAR2 Required
1198: -- x_msg_count OUT NUMBER Required
1199: -- x_msg_data OUT VARCHAR2 Required
1200: --

Line 1305: STANDARD_RATE_FLAG, resource_type

1301: -- Added resource_type for bug# 6512803.
1302: CURSOR c_get_std_rate_flag(p_resource_id NUMBER)
1303: IS
1304: SELECT
1305: STANDARD_RATE_FLAG, resource_type
1306: FROM
1307: BOM_RESOURCES
1308: WHERE
1309: resource_id = p_resource_id;

Line 1372: -- Standard Start of API savepoint

1368: l_resource_type bom_resources.resource_type%TYPE;
1369:
1370: BEGIN
1371: --------------------Initialize ----------------------------------
1372: -- Standard Start of API savepoint
1373: SAVEPOINT Create_Resrc_Require;
1374: -- Check if API is called in debug mode. If yes, enable debug.
1375: IF G_DEBUG='Y' THEN
1376: AHL_DEBUG_PUB.enable_debug;

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

1385: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require_PVT. Create_Resrc_Require +PPResrc_Require_Pvt+');
1386: END IF;
1387: G_MODULE_TYPE:=P_MODULE_TYPE;
1388:
1389: -- Standard call to check for call compatibility.
1390: IF FND_API.to_boolean(p_init_msg_list)
1391: THEN
1392: FND_MSG_PUB.initialize;
1393: END IF;

Line 1724: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);

1720: END IF;
1721: END IF;
1722: IF G_DEBUG='Y' THEN
1723: Ahl_Debug_Pub.debug ( l_full_name || ' SCHEDULED TYPE CODE = ' || l_Resrc_Require_Rec.SCHEDULED_TYPE_CODE);
1724: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);
1725: END IF;
1726: -- To find meaning for fnd_lookups code
1727: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
1728: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN

Line 1775: --Standard check to count messages

1771: END IF;
1772: IF G_DEBUG='Y' THEN
1773: Ahl_Debug_Pub.debug ( l_full_name || ' ******After calling Validate_Resrc_Require****');
1774: END IF;
1775: --Standard check to count messages
1776: l_msg_count := Fnd_Msg_Pub.count_msg;
1777:
1778: IF l_msg_count > 0 THEN
1779: x_msg_count := l_msg_count;

Line 2075: --Standard check to count messages

2071: Ahl_Debug_Pub.debug ('after wip load p_x_resrc_Require_tbl.COUNT'||p_x_resrc_Require_tbl.COUNT);
2072:
2073: END IF;
2074:
2075: --Standard check to count messages
2076: l_msg_count := Fnd_Msg_Pub.count_msg;
2077: IF l_msg_count > 0 THEN
2078: X_msg_count := l_msg_count;
2079: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2201: --Standard check to count messages

2197: END IF;
2198:
2199: --END IF;
2200: ------------------------End of Body---------------------------------------
2201: --Standard check to count messages
2202: l_msg_count := Fnd_Msg_Pub.count_msg;
2203: IF l_msg_count > 0 THEN
2204: X_msg_count := l_msg_count;
2205: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2209: --Standard check for commit

2205: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2206: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2207: END IF;
2208:
2209: --Standard check for commit
2210: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2211: COMMIT;
2212: END IF;
2213: IF G_DEBUG='Y' THEN

Line 2287: -- Standard IN Parameters :

2283: -- Type : Private
2284: -- Pre-reqs :
2285: -- Parameters :
2286: --
2287: -- Standard IN Parameters :
2288: -- p_api_version IN NUMBER Required
2289: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2290: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2291: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2295: -- Standard OUT Parameters :

2291: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2292: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2293: -- p_module_type IN VARCHAR2 Default NULL.
2294: --
2295: -- Standard OUT Parameters :
2296: -- x_return_status OUT VARCHAR2 Required
2297: -- x_msg_count OUT NUMBER Required
2298: -- x_msg_data OUT VARCHAR2 Required
2299: --

Line 2445: -- Standard Start of API savepoint

2441: l_department_id NUMBER;
2442:
2443: BEGIN
2444: --------------------Initialize ----------------------------------
2445: -- Standard Start of API savepoint
2446: SAVEPOINT Update_Resrc_Require;
2447:
2448: -- Check if API is called in debug mode. If yes, enable debug.
2449: IF G_DEBUG='Y' THEN

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

2454: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt. Update Resource Requirement +PPResrc_Require_Pvt+');
2455: END IF;
2456:
2457: G_MODULE_TYPE:=P_MODULE_TYPE;
2458: -- Standard call to check for call compatibility.
2459: IF FND_API.to_boolean(p_init_msg_list)
2460: THEN
2461: FND_MSG_PUB.initialize;
2462: END IF;

Line 2798: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);

2794: END IF;
2795: END IF;
2796: IF G_DEBUG='Y' THEN
2797: Ahl_Debug_Pub.debug ( l_full_name || ' SCHEDULED TYPE CODE = ' || l_Resrc_Require_Rec.SCHEDULED_TYPE_CODE);
2798: Ahl_Debug_Pub.debug ( l_full_name || ' STANDARD RATE FLAG = ' || l_Resrc_Require_Rec.STD_RATE_FLAG_CODE);
2799: END IF;
2800: -- To find meaning for fnd_lookups code
2801: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
2802: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN

Line 2823: --Standard check to count messages

2819: x_msg_count => x_msg_count,
2820: x_msg_data => x_msg_data
2821: );
2822:
2823: --Standard check to count messages
2824: l_msg_count := Fnd_Msg_Pub.count_msg;
2825:
2826: IF l_msg_count > 0 THEN
2827: x_msg_count := l_msg_count;

Line 3134: -- Standard check to count messages

3130: END IF;
3131: END IF;
3132: --
3133: ------------------------End of Body---------------------------------------
3134: -- Standard check to count messages
3135: l_msg_count := Fnd_Msg_Pub.count_msg;
3136:
3137: IF l_msg_count > 0 THEN
3138: X_msg_count := l_msg_count;

Line 3143: --Standard check for commit

3139: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3140: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3141: END IF;
3142:
3143: --Standard check for commit
3144: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3145: COMMIT;
3146: END IF;
3147:

Line 3341: -- Standard start of API savepoint

3337: AND TRUNC(NVL(end_date_active,SYSDATE));
3338:
3339: BEGIN
3340: -------------------------------- Initialize -----------------------
3341: -- Standard start of API savepoint
3342: SAVEPOINT Get_Resource_Requirement;
3343: IF G_DEBUG='Y' THEN
3344: -- Check if API is called in debug mode. If yes, enable debug.
3345: Ahl_Debug_Pub.enable_debug;

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

3349: IF G_DEBUG='Y' THEN
3350: Ahl_Debug_Pub.debug ( l_full_name || ' Start ');
3351: END IF;
3352:
3353: -- Standard call to check for call compatibility.
3354: IF Fnd_Api.to_boolean(p_init_msg_list)
3355: THEN
3356: Fnd_Msg_Pub.initialize;
3357: END IF;

Line 3412: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN

3408: ------------------------------------------ Start -----------------------------------
3409: -- Debug info.
3410:
3411: -- To find meaning for fnd_lookups code
3412: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3413: SELECT meaning
3414: INTO l_std_rate_flag
3415: FROM MFG_LOOKUPS
3416: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG

Line 3416: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG

3412: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3413: SELECT meaning
3414: INTO l_std_rate_flag
3415: FROM MFG_LOOKUPS
3416: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG
3417: AND LOOKUP_TYPE = 'BOM_NO_YES';
3418: END IF;
3419:
3420: OPEN c_lookups ('CST_BASIS', c_WIP_oper_rec.basis_type);

Line 3449: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE := c_WIP_oper_rec.Standard_Rate_Flag ;

3445: --l_Resrc_Require_Rec.APPLIED_NUM := c_WIP_oper_rec.APPLIED_RESOURCE_VALUE;
3446: l_Resrc_Require_Rec.OPEN_NUM := (l_Resrc_Require_Rec.TOTAL_REQUIRED - l_Resrc_Require_Rec.APPLIED_NUM);
3447:
3448: l_Resrc_Require_Rec.STD_RATE_FLAG_NAME := l_std_rate_flag;
3449: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE := c_WIP_oper_rec.Standard_Rate_Flag ;
3450:
3451: l_Resrc_Require_Rec.RESOURCE_SEQ_NUMBER := c_resrc_req.RESOURCE_SEQUENCE_NUM;
3452: l_Resrc_Require_Rec.OPERATION_SEQ_NUMBER := l_oper_seq_num;
3453: -- JKJAIN US space FP for ER # 6998882

Line 3504: -- Standard call to get message count and if count is 1, get message info

3500: Ahl_Debug_Pub.debug ( l_full_name || ' Operation End = ' || p_x_resrc_Require_tbl(i).OPER_END_DATE);*/
3501:
3502: END LOOP;
3503: END IF;
3504: -- Standard call to get message count and if count is 1, get message info
3505: Fnd_Msg_Pub.Count_And_Get
3506: ( p_count => x_msg_count,
3507: p_data => x_msg_data,
3508: p_encoded => Fnd_Api.g_false);

Line 3662: -- Standard Start of API savepoint

3658:
3659:
3660: BEGIN
3661: --------------------Initialize ----------------------------------
3662: -- Standard Start of API savepoint
3663: SAVEPOINT Remove_Resource_Requirement;
3664:
3665: -- Check if API is called in debug mode. If yes, enable debug.
3666: IF G_DEBUG='Y' THEN

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

3668:
3669: -- Debug info.
3670: Ahl_Debug_Pub.debug( 'Enter ahl_pp_resrc_require_pvt Remove Resource Requirement +APRRP+');
3671: END IF;
3672: -- Standard call to check for call compatibility.
3673: IF Fnd_Api.to_boolean(p_init_msg_list)
3674: THEN
3675: Fnd_Msg_Pub.initialize;
3676: END IF;

Line 3792: Ahl_Debug_Pub.debug ( ' STANDARD_RATE_FLAG = ' || l_wip_oper_res_rec.STANDARD_RATE_FLAG);

3788: --
3789: IF G_DEBUG='Y' THEN
3790: Ahl_Debug_Pub.debug ( ' AutoCharge Code = ' || l_wip_oper_res_rec.AUTOCHARGE_TYPE);
3791: Ahl_Debug_Pub.debug ( ' COST BASIS = ' || l_wip_oper_res_rec.BASIS_TYPE);
3792: Ahl_Debug_Pub.debug ( ' STANDARD_RATE_FLAG = ' || l_wip_oper_res_rec.STANDARD_RATE_FLAG);
3793: Ahl_Debug_Pub.debug ( ' l_Resrc_Require_Rec.Resource_Id = ' || l_Resrc_Require_Rec.Resource_Id);
3794: END IF;
3795: --Assign Org,Wip entity details
3796: p_x_resrc_Require_tbl(i).ORGANIZATION_ID := l_organization_id;

Line 3800: p_x_resrc_Require_tbl(i).std_rate_flag_code := l_wip_oper_res_rec.STANDARD_RATE_FLAG;

3796: p_x_resrc_Require_tbl(i).ORGANIZATION_ID := l_organization_id;
3797: p_x_resrc_Require_tbl(i).WIP_ENTITY_ID := l_wip_entity_id;
3798: p_x_resrc_Require_tbl(i).CHARGE_TYPE_CODE := l_wip_oper_res_rec.AUTOCHARGE_TYPE;
3799: p_x_resrc_Require_tbl(i).COST_BASIS_CODE := l_wip_oper_res_rec.BASIS_TYPE;
3800: p_x_resrc_Require_tbl(i).std_rate_flag_code := l_wip_oper_res_rec.STANDARD_RATE_FLAG;
3801: p_x_resrc_Require_tbl(i).scheduled_type_code := l_wip_oper_res_rec.SCHEDULED_FLAG;
3802: --Check for Eam code
3803: OPEN c_uom_code(l_Resource_Rec.Resource_Id);
3804: FETCH c_uom_code INTO l_uom_code;

Line 3913: --Standard check to count messages

3909: END IF;--Count
3910: END IF; --Return status
3911:
3912: ---------------------------End of Body---------------------------------------
3913: --Standard check to count messages
3914: l_msg_count := Fnd_Msg_Pub.count_msg;
3915:
3916: IF l_msg_count > 0 THEN
3917: X_msg_count := l_msg_count;

Line 3922: --Standard check for commit

3918: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3919: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3920: END IF;
3921:
3922: --Standard check for commit
3923: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3924: COMMIT;
3925: END IF;
3926:

Line 3995: -- Standard IN Parameters :

3991: -- Function : Process ............................based on operation flag
3992: -- Pre-reqs :
3993: -- Parameters :
3994: --
3995: -- Standard IN Parameters :
3996: -- p_api_version IN NUMBER Required
3997: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3998: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3999: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 4003: -- Standard OUT Parameters :

3999: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4000: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4001: -- p_module_type IN VARCHAR2 Default NULL.
4002: --
4003: -- Standard OUT Parameters :
4004: -- x_return_status OUT VARCHAR2 Required
4005: -- x_msg_count OUT NUMBER Required
4006: -- x_msg_data OUT VARCHAR2 Required
4007: --

Line 4054: -- Standard Start of API savepoint

4050: AWO.workorder_id = c_workorder_id;
4051:
4052: BEGIN
4053: --------------------Initialize ----------------------------------
4054: -- Standard Start of API savepoint
4055: SAVEPOINT Process_Resrc_Require;
4056: -- Check if API is called in debug mode. If yes, enable debug.
4057: IF G_DEBUG='Y' THEN
4058: AHL_DEBUG_PUB.enable_debug;

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

4058: AHL_DEBUG_PUB.enable_debug;
4059: -- Debug info.
4060: Ahl_Debug_Pub.debug( 'Enter AHL_PP_RESRC_Require.process_resrc_Require +PPResrc_Require_Pvt+');
4061: END IF;
4062: -- Standard call to check for call compatibility.
4063: IF FND_API.to_boolean(p_init_msg_list)
4064: THEN
4065: FND_MSG_PUB.initialize;
4066: END IF;

Line 4145: --Standard check to count messages

4141: x_msg_data => l_msg_data
4142: );
4143: END IF;
4144: ------------------------End of Body---------------------------------------
4145: --Standard check to count messages
4146: l_msg_count := Fnd_Msg_Pub.count_msg;
4147:
4148: -- Fix for Bug # 9201220 (FP for Bug # 9115435) -- start
4149: IF l_msg_count > 0 THEN

Line 4229: --Standard check for commit

4225: -- Fix for Bug # 9201220 (FP for Bug # 9115435) -- end
4226:
4227: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
4228:
4229: --Standard check for commit
4230: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4231: COMMIT;
4232: END IF;
4233: IF G_DEBUG='Y' THEN