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_PRD_PARTS_CHANGE_PVT dependencies on FND_LOG

Line 3131: -- FND Logging Constants

3127: x_msg_data OUT NOCOPY VARCHAR2,
3128: x_msg_count OUT NOCOPY NUMBER,
3129: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)
3130: IS
3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3128: x_msg_count OUT NOCOPY NUMBER,
3129: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)
3130: IS
3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3136:

Line 3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;

3129: x_ahl_mtltxn_rec OUT NOCOPY AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type)
3130: IS
3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3136:
3137: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator';

Line 3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;

3130: IS
3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3136:
3137: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator';
3138:

Line 3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;

3131: -- FND Logging Constants
3132: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3133: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
3134: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
3135: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3136:
3137: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator';
3138:
3139: CURSOR ahl_disp_csr (p_disposition_id IN NUMBER,

Line 3176: fnd_log.string(l_debug_proc,l_debug_module,

3172: BEGIN
3173:
3174: -- log debug message.
3175: IF (l_debug_proc >= l_debug_level) THEN
3176: fnd_log.string(l_debug_proc,l_debug_module,
3177: 'At Start of procedure AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator');
3178: END IF;
3179:
3180: -- Standard start of API savepoint

Line 3193: fnd_log.string(l_debug_stmt,l_debug_module,

3189: x_return_status := FND_API.G_RET_STS_SUCCESS;
3190:
3191: -- log debug message.
3192: IF (l_debug_stmt >= l_debug_level) THEN
3193: fnd_log.string(l_debug_stmt,l_debug_module,
3194: 'Input disposition_id:' || p_disposition_id);
3195: fnd_log.string(l_debug_stmt,l_debug_module,
3196: 'Input Parts_Change_id:' || p_part_change_id);
3197: END IF;

Line 3195: fnd_log.string(l_debug_stmt,l_debug_module,

3191: -- log debug message.
3192: IF (l_debug_stmt >= l_debug_level) THEN
3193: fnd_log.string(l_debug_stmt,l_debug_module,
3194: 'Input disposition_id:' || p_disposition_id);
3195: fnd_log.string(l_debug_stmt,l_debug_module,
3196: 'Input Parts_Change_id:' || p_part_change_id);
3197: END IF;
3198:
3199: -- get count of existing messages.

Line 3283: fnd_log.string

3279: x_msg_data => x_msg_data );
3280:
3281: IF (l_debug_stmt >= l_debug_level)
3282: THEN
3283: fnd_log.string
3284: (
3285: l_debug_stmt,
3286: l_debug_module,
3287: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Return status:' || x_return_status

Line 3289: fnd_log.string

3285: l_debug_stmt,
3286: l_debug_module,
3287: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Return status:' || x_return_status
3288: );
3289: fnd_log.string
3290: (
3291: l_debug_stmt,
3292: l_debug_module,
3293: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Error count:' || x_msg_count

Line 3313: fnd_log.string(l_debug_proc,l_debug_module,

3309: END LOOP;
3310:
3311: -- log debug message.
3312: IF (l_debug_proc >= l_debug_level) THEN
3313: fnd_log.string(l_debug_proc,l_debug_module,
3314: '');
3315: END IF;
3316:
3317: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 3340: fnd_log.string

3336: p_x_disp_mtl_txn_tbl => l_disp_Mtl_Txn_Tbl);
3337:
3338: IF (l_debug_stmt >= l_debug_level)
3339: THEN
3340: fnd_log.string
3341: (
3342: l_debug_stmt,
3343: l_debug_module,
3344: 'After call to AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn. Return status:' || x_return_status

Line 3346: fnd_log.string

3342: l_debug_stmt,
3343: l_debug_module,
3344: 'After call to AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn. Return status:' || x_return_status
3345: );
3346: fnd_log.string
3347: (
3348: l_debug_stmt,
3349: l_debug_module,
3350: 'After call to AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn. Error count:' || x_msg_count

Line 3362: fnd_log.string(l_debug_proc,l_debug_module,

3358: END IF;
3359:
3360: -- log debug message.
3361: IF (l_debug_proc >= l_debug_level) THEN
3362: fnd_log.string(l_debug_proc,l_debug_module,
3363: 'At End of procedure AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator');
3364: END IF;
3365:
3366: EXCEPTION

Line 3437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3433: BEGIN
3434: -- Standard start of API savepoint
3435: SAVEPOINT MOVE_INSTANCE_LOCATION;
3436:
3437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3438: fnd_log.string
3439: (
3440: fnd_log.level_procedure,
3441: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 3438: fnd_log.string

3434: -- Standard start of API savepoint
3435: SAVEPOINT MOVE_INSTANCE_LOCATION;
3436:
3437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3438: fnd_log.string
3439: (
3440: fnd_log.level_procedure,
3441: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3442: 'At the start of PLSQL procedure'

Line 3440: fnd_log.level_procedure,

3436:
3437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3438: fnd_log.string
3439: (
3440: fnd_log.level_procedure,
3441: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3442: 'At the start of PLSQL procedure'
3443: );
3444: END IF;

Line 3468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3464: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3465: RAISE FND_API.G_EXC_ERROR;
3466: END IF;
3467:
3468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_statement,
3472: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3469: fnd_log.string

3465: RAISE FND_API.G_EXC_ERROR;
3466: END IF;
3467:
3468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_statement,
3472: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3473: 'Created CSI Transaction'

Line 3471: fnd_log.level_statement,

3467:
3468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_statement,
3472: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3473: 'Created CSI Transaction'
3474: );
3475: END IF;

Line 3483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3479: FETCH ahl_wip_location_csr INTO l_location_id ;
3480: CLOSE ahl_wip_location_csr;*/
3481:
3482: FOR i IN p_move_item_instance_tbl.FIRST..p_move_item_instance_tbl.LAST LOOP
3483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3484: fnd_log.string
3485: (
3486: fnd_log.level_statement,
3487: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3484: fnd_log.string

3480: CLOSE ahl_wip_location_csr;*/
3481:
3482: FOR i IN p_move_item_instance_tbl.FIRST..p_move_item_instance_tbl.LAST LOOP
3483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3484: fnd_log.string
3485: (
3486: fnd_log.level_statement,
3487: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3488: 'p_move_item_instance_tbl(i).instance_id : ' || p_move_item_instance_tbl(i).instance_id

Line 3486: fnd_log.level_statement,

3482: FOR i IN p_move_item_instance_tbl.FIRST..p_move_item_instance_tbl.LAST LOOP
3483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3484: fnd_log.string
3485: (
3486: fnd_log.level_statement,
3487: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3488: 'p_move_item_instance_tbl(i).instance_id : ' || p_move_item_instance_tbl(i).instance_id
3489: );
3490: END IF;

Line 3491: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3487: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3488: 'p_move_item_instance_tbl(i).instance_id : ' || p_move_item_instance_tbl(i).instance_id
3489: );
3490: END IF;
3491: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3492: fnd_log.string
3493: (
3494: fnd_log.level_statement,
3495: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3492: fnd_log.string

3488: 'p_move_item_instance_tbl(i).instance_id : ' || p_move_item_instance_tbl(i).instance_id
3489: );
3490: END IF;
3491: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3492: fnd_log.string
3493: (
3494: fnd_log.level_statement,
3495: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3496: 'p_move_item_instance_tbl(i).quantity : ' || p_move_item_instance_tbl(i).quantity

Line 3494: fnd_log.level_statement,

3490: END IF;
3491: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3492: fnd_log.string
3493: (
3494: fnd_log.level_statement,
3495: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3496: 'p_move_item_instance_tbl(i).quantity : ' || p_move_item_instance_tbl(i).quantity
3497: );
3498: END IF;

Line 3507: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3503: x_serialized => l_serialized,
3504: x_Return_Status => X_Return_Status
3505: );
3506: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3507: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3508: fnd_log.string
3509: (
3510: fnd_log.level_error,
3511: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3508: fnd_log.string

3504: x_Return_Status => X_Return_Status
3505: );
3506: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3507: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3508: fnd_log.string
3509: (
3510: fnd_log.level_error,
3511: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3512: 'get_dest_instance_rec returned error'

Line 3510: fnd_log.level_error,

3506: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3507: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3508: fnd_log.string
3509: (
3510: fnd_log.level_error,
3511: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3512: 'get_dest_instance_rec returned error'
3513: );
3514: END IF;

Line 3529: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3525: p_x_csi_transaction_rec => l_csi_transaction_rec,
3526: x_Return_Status => X_Return_Status
3527: );
3528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3529: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3530: fnd_log.string
3531: (
3532: fnd_log.level_error,
3533: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3530: fnd_log.string

3526: x_Return_Status => X_Return_Status
3527: );
3528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3529: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3530: fnd_log.string
3531: (
3532: fnd_log.level_error,
3533: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3534: 'serialized move: update_csi_item_instance returned error'

Line 3532: fnd_log.level_error,

3528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3529: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3530: fnd_log.string
3531: (
3532: fnd_log.level_error,
3533: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3534: 'serialized move: update_csi_item_instance returned error'
3535: );
3536: END IF;

Line 3550: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3546: p_x_csi_transaction_rec => l_csi_transaction_rec,
3547: x_Return_Status => X_Return_Status
3548: );
3549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3550: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_error,
3554: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3551: fnd_log.string

3547: x_Return_Status => X_Return_Status
3548: );
3549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3550: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_error,
3554: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3555: 'non serialized move: move_nonser_instance returned error'

Line 3553: fnd_log.level_error,

3549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3550: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_error,
3554: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3555: 'non serialized move: move_nonser_instance returned error'
3556: );
3557: END IF;

Line 3576: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3572: ( p_count => x_msg_count,
3573: p_data => x_msg_data,
3574: p_encoded => fnd_api.g_false);
3575:
3576: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3577: fnd_log.string
3578: (
3579: fnd_log.level_procedure,
3580: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',

Line 3577: fnd_log.string

3573: p_data => x_msg_data,
3574: p_encoded => fnd_api.g_false);
3575:
3576: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3577: fnd_log.string
3578: (
3579: fnd_log.level_procedure,
3580: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
3581: 'At the end of PLSQL procedure'

Line 3579: fnd_log.level_procedure,

3575:
3576: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3577: fnd_log.string
3578: (
3579: fnd_log.level_procedure,
3580: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
3581: 'At the end of PLSQL procedure'
3582: );
3583: END IF;

Line 3687: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3683: AND A.visit_id = B.visit_id;
3684:
3685:
3686: BEGIN
3687: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3688: fnd_log.string
3689: (
3690: fnd_log.level_procedure,
3691: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 3688: fnd_log.string

3684:
3685:
3686: BEGIN
3687: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3688: fnd_log.string
3689: (
3690: fnd_log.level_procedure,
3691: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3692: 'At the start of PLSQL procedure'

Line 3690: fnd_log.level_procedure,

3686: BEGIN
3687: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3688: fnd_log.string
3689: (
3690: fnd_log.level_procedure,
3691: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3692: 'At the start of PLSQL procedure'
3693: );
3694: END IF;

Line 3701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3697: IF(p_module_type IN ('JSP','OAF') AND p_move_item_instance_rec.from_workorder_number IS NOT NULL) THEN
3698: OPEN wip_entity_wonum_csr(p_move_item_instance_rec.from_workorder_number);
3699: FETCH wip_entity_wonum_csr INTO l_from_wip_entity_id,l_status_code;
3700: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3702: fnd_log.string
3703: (
3704: fnd_log.level_error,
3705: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3702: fnd_log.string

3698: OPEN wip_entity_wonum_csr(p_move_item_instance_rec.from_workorder_number);
3699: FETCH wip_entity_wonum_csr INTO l_from_wip_entity_id,l_status_code;
3700: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3702: fnd_log.string
3703: (
3704: fnd_log.level_error,
3705: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3706: 'wip_entity_not_found for from_workorder_number'

Line 3704: fnd_log.level_error,

3700: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3702: fnd_log.string
3703: (
3704: fnd_log.level_error,
3705: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3706: 'wip_entity_not_found for from_workorder_number'
3707: );
3708: END IF;

Line 3718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3714: ELSIF p_move_item_instance_rec.from_workorder_id IS NOT NULL THEN
3715: OPEN wip_entity_woid_csr(p_move_item_instance_rec.from_workorder_id);
3716: FETCH wip_entity_woid_csr INTO l_from_wip_entity_id,l_status_code;
3717: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3719: fnd_log.string
3720: (
3721: fnd_log.level_error,
3722: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3719: fnd_log.string

3715: OPEN wip_entity_woid_csr(p_move_item_instance_rec.from_workorder_id);
3716: FETCH wip_entity_woid_csr INTO l_from_wip_entity_id,l_status_code;
3717: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3719: fnd_log.string
3720: (
3721: fnd_log.level_error,
3722: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3723: 'wip_entity_not_found for from_workorder_id'

Line 3721: fnd_log.level_error,

3717: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','5','7','12','17','22')) THEN
3718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3719: fnd_log.string
3720: (
3721: fnd_log.level_error,
3722: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3723: 'wip_entity_not_found for from_workorder_id'
3724: );
3725: END IF;

Line 3738: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3734: IF(p_module_type IN ('JSP','OAF') AND p_move_item_instance_rec.to_workorder_number IS NOT NULL) THEN
3735: OPEN wip_entity_wonum_csr(p_move_item_instance_rec.to_workorder_number);
3736: FETCH wip_entity_wonum_csr INTO l_to_wip_entity_id, l_status_code;
3737: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3738: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3739: fnd_log.string
3740: (
3741: fnd_log.level_error,
3742: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3739: fnd_log.string

3735: OPEN wip_entity_wonum_csr(p_move_item_instance_rec.to_workorder_number);
3736: FETCH wip_entity_wonum_csr INTO l_to_wip_entity_id, l_status_code;
3737: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3738: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3739: fnd_log.string
3740: (
3741: fnd_log.level_error,
3742: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3743: 'wip_entity_not_found for to_workorder_number'

Line 3741: fnd_log.level_error,

3737: IF (wip_entity_wonum_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3738: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3739: fnd_log.string
3740: (
3741: fnd_log.level_error,
3742: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3743: 'wip_entity_not_found for to_workorder_number'
3744: );
3745: END IF;

Line 3755: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3751: ELSE
3752: OPEN wip_entity_woid_csr(p_move_item_instance_rec.to_workorder_id);
3753: FETCH wip_entity_woid_csr INTO l_to_wip_entity_id, l_status_code;
3754: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3755: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3756: fnd_log.string
3757: (
3758: fnd_log.level_error,
3759: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3756: fnd_log.string

3752: OPEN wip_entity_woid_csr(p_move_item_instance_rec.to_workorder_id);
3753: FETCH wip_entity_woid_csr INTO l_to_wip_entity_id, l_status_code;
3754: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3755: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3756: fnd_log.string
3757: (
3758: fnd_log.level_error,
3759: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3760: 'wip_entity_not_found for to_workorder_id'

Line 3758: fnd_log.level_error,

3754: IF (wip_entity_woid_csr%NOTFOUND OR l_status_code IN ('1','4','5','6','7','12','17','21','22')) THEN
3755: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3756: fnd_log.string
3757: (
3758: fnd_log.level_error,
3759: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3760: 'wip_entity_not_found for to_workorder_id'
3761: );
3762: END IF;

Line 3796: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3792: l_current_quantity,
3793: l_curr_wip_entity_id;
3794:
3795: IF (csi_item_instance_num_csr%NOTFOUND) THEN
3796: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3797: fnd_log.string
3798: (
3799: fnd_log.level_error,
3800: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3797: fnd_log.string

3793: l_curr_wip_entity_id;
3794:
3795: IF (csi_item_instance_num_csr%NOTFOUND) THEN
3796: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3797: fnd_log.string
3798: (
3799: fnd_log.level_error,
3800: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3801: 'removed instance_num not found ' || p_move_item_instance_rec.instance_number

Line 3799: fnd_log.level_error,

3795: IF (csi_item_instance_num_csr%NOTFOUND) THEN
3796: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3797: fnd_log.string
3798: (
3799: fnd_log.level_error,
3800: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3801: 'removed instance_num not found ' || p_move_item_instance_rec.instance_number
3802: );
3803: END IF;

Line 3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3807: FND_MSG_PUB.ADD;
3808: END IF;
3809: CLOSE csi_item_instance_num_csr;
3810: ELSE
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 3812: fnd_log.string

3808: END IF;
3809: CLOSE csi_item_instance_num_csr;
3810: ELSE
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3816: 'p_move_item_instance_rec.instance_id : ' || p_move_item_instance_rec.instance_id

Line 3814: fnd_log.level_statement,

3810: ELSE
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3816: 'p_move_item_instance_rec.instance_id : ' || p_move_item_instance_rec.instance_id
3817: );
3818: END IF;

Line 3827: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3823: l_serial_number,
3824: l_current_quantity,
3825: l_curr_wip_entity_id;
3826: IF (csi_item_instance_id_csr%NOTFOUND) THEN
3827: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3828: fnd_log.string
3829: (
3830: fnd_log.level_error,
3831: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3828: fnd_log.string

3824: l_current_quantity,
3825: l_curr_wip_entity_id;
3826: IF (csi_item_instance_id_csr%NOTFOUND) THEN
3827: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3828: fnd_log.string
3829: (
3830: fnd_log.level_error,
3831: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3832: 'removed instance_id not found ' || p_move_item_instance_rec.instance_id

Line 3830: fnd_log.level_error,

3826: IF (csi_item_instance_id_csr%NOTFOUND) THEN
3827: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3828: fnd_log.string
3829: (
3830: fnd_log.level_error,
3831: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3832: 'removed instance_id not found ' || p_move_item_instance_rec.instance_id
3833: );
3834: END IF;

Line 3844: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3840: CLOSE csi_item_instance_id_csr;
3841: END IF;
3842:
3843:
3844: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3845: fnd_log.string
3846: (
3847: fnd_log.level_statement,
3848: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3845: fnd_log.string

3841: END IF;
3842:
3843:
3844: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3845: fnd_log.string
3846: (
3847: fnd_log.level_statement,
3848: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3849: 'checking whether item is serialized'

Line 3847: fnd_log.level_statement,

3843:
3844: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3845: fnd_log.string
3846: (
3847: fnd_log.level_statement,
3848: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3849: 'checking whether item is serialized'
3850: );
3851: END IF;

Line 3865: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3861: CLOSE check_inst_nonserial;
3862:
3863: IF FND_API.To_Boolean(x_serialized) THEN
3864: IF(NVL(p_move_item_instance_rec.quantity,1) <> 1)THEN
3865: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3866: fnd_log.string
3867: (
3868: fnd_log.level_error,
3869: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3866: fnd_log.string

3862:
3863: IF FND_API.To_Boolean(x_serialized) THEN
3864: IF(NVL(p_move_item_instance_rec.quantity,1) <> 1)THEN
3865: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3866: fnd_log.string
3867: (
3868: fnd_log.level_error,
3869: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3870: 'invalid qty for serialized item ' || p_move_item_instance_rec.quantity

Line 3868: fnd_log.level_error,

3864: IF(NVL(p_move_item_instance_rec.quantity,1) <> 1)THEN
3865: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3866: fnd_log.string
3867: (
3868: fnd_log.level_error,
3869: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3870: 'invalid qty for serialized item ' || p_move_item_instance_rec.quantity
3871: );
3872: END IF;

Line 3880: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3876: END IF;
3877: ELSE
3878: IF ((NVL(p_move_item_instance_rec.quantity,1) < 0) OR
3879: (NVL(p_move_item_instance_rec.quantity,1) > l_current_quantity))THEN
3880: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3881: fnd_log.string
3882: (
3883: fnd_log.level_error,
3884: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3881: fnd_log.string

3877: ELSE
3878: IF ((NVL(p_move_item_instance_rec.quantity,1) < 0) OR
3879: (NVL(p_move_item_instance_rec.quantity,1) > l_current_quantity))THEN
3880: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3881: fnd_log.string
3882: (
3883: fnd_log.level_error,
3884: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3885: 'invalid qty for non serialized item ' || p_move_item_instance_rec.quantity

Line 3883: fnd_log.level_error,

3879: (NVL(p_move_item_instance_rec.quantity,1) > l_current_quantity))THEN
3880: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3881: fnd_log.string
3882: (
3883: fnd_log.level_error,
3884: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3885: 'invalid qty for non serialized item ' || p_move_item_instance_rec.quantity
3886: );
3887: END IF;

Line 3896: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3892: END IF;
3893: END IF;
3894:
3895: IF(l_curr_wip_entity_id <> l_from_wip_entity_id) THEN
3896: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3897: fnd_log.string
3898: (
3899: fnd_log.level_error,
3900: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3897: fnd_log.string

3893: END IF;
3894:
3895: IF(l_curr_wip_entity_id <> l_from_wip_entity_id) THEN
3896: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3897: fnd_log.string
3898: (
3899: fnd_log.level_error,
3900: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3901: 'item not in from wip_entity_id location ' || l_from_wip_entity_id

Line 3899: fnd_log.level_error,

3895: IF(l_curr_wip_entity_id <> l_from_wip_entity_id) THEN
3896: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3897: fnd_log.string
3898: (
3899: fnd_log.level_error,
3900: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3901: 'item not in from wip_entity_id location ' || l_from_wip_entity_id
3902: );
3903: END IF;

Line 3919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3915: l_instance_rec.quantity := NVL(p_move_item_instance_rec.quantity,1);
3916: x_instance_rec := l_instance_rec;
3917:
3918:
3919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3920: fnd_log.string
3921: (
3922: fnd_log.level_statement,
3923: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 3920: fnd_log.string

3916: x_instance_rec := l_instance_rec;
3917:
3918:
3919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3920: fnd_log.string
3921: (
3922: fnd_log.level_statement,
3923: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3924: 'x_instance_rec.instance_id ' || x_instance_rec.instance_id

Line 3922: fnd_log.level_statement,

3918:
3919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3920: fnd_log.string
3921: (
3922: fnd_log.level_statement,
3923: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3924: 'x_instance_rec.instance_id ' || x_instance_rec.instance_id
3925: );
3926: fnd_log.string

Line 3926: fnd_log.string

3922: fnd_log.level_statement,
3923: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3924: 'x_instance_rec.instance_id ' || x_instance_rec.instance_id
3925: );
3926: fnd_log.string
3927: (
3928: fnd_log.level_statement,
3929: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3930: 'x_instance_rec.wip_job_id ' || x_instance_rec.wip_job_id

Line 3928: fnd_log.level_statement,

3924: 'x_instance_rec.instance_id ' || x_instance_rec.instance_id
3925: );
3926: fnd_log.string
3927: (
3928: fnd_log.level_statement,
3929: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3930: 'x_instance_rec.wip_job_id ' || x_instance_rec.wip_job_id
3931: );
3932: fnd_log.string

Line 3932: fnd_log.string

3928: fnd_log.level_statement,
3929: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3930: 'x_instance_rec.wip_job_id ' || x_instance_rec.wip_job_id
3931: );
3932: fnd_log.string
3933: (
3934: fnd_log.level_statement,
3935: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3936: 'x_instance_rec.quantity ' || x_instance_rec.quantity

Line 3934: fnd_log.level_statement,

3930: 'x_instance_rec.wip_job_id ' || x_instance_rec.wip_job_id
3931: );
3932: fnd_log.string
3933: (
3934: fnd_log.level_statement,
3935: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3936: 'x_instance_rec.quantity ' || x_instance_rec.quantity
3937: );
3938: END IF;

Line 3940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3936: 'x_instance_rec.quantity ' || x_instance_rec.quantity
3937: );
3938: END IF;
3939:
3940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3941: fnd_log.string
3942: (
3943: fnd_log.level_procedure,
3944: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',

Line 3941: fnd_log.string

3937: );
3938: END IF;
3939:
3940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3941: fnd_log.string
3942: (
3943: fnd_log.level_procedure,
3944: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
3945: 'At the end of PLSQL procedure'

Line 3943: fnd_log.level_procedure,

3939:
3940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3941: fnd_log.string
3942: (
3943: fnd_log.level_procedure,
3944: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
3945: 'At the end of PLSQL procedure'
3946: );
3947: END IF;

Line 4001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3997: l_junk VARCHAR2(1);*/
3998:
3999:
4000: BEGIN
4001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4002: fnd_log.string
4003: (
4004: fnd_log.level_procedure,
4005: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 4002: fnd_log.string

3998:
3999:
4000: BEGIN
4001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4002: fnd_log.string
4003: (
4004: fnd_log.level_procedure,
4005: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4006: 'At the start of PLSQL procedure'

Line 4004: fnd_log.level_procedure,

4000: BEGIN
4001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4002: fnd_log.string
4003: (
4004: fnd_log.level_procedure,
4005: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4006: 'At the start of PLSQL procedure'
4007: );
4008: END IF;

Line 4012: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4008: END IF;
4009:
4010: -- populate l_instance_rec
4011: l_instance_rec := p_instance_rec;
4012: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: fnd_log.string
4014: (
4015: fnd_log.level_statement,
4016: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 4013: fnd_log.string

4009:
4010: -- populate l_instance_rec
4011: l_instance_rec := p_instance_rec;
4012: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: fnd_log.string
4014: (
4015: fnd_log.level_statement,
4016: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4017: 'l_instance_rec.instance_id : ' || l_instance_rec.instance_id

Line 4015: fnd_log.level_statement,

4011: l_instance_rec := p_instance_rec;
4012: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: fnd_log.string
4014: (
4015: fnd_log.level_statement,
4016: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4017: 'l_instance_rec.instance_id : ' || l_instance_rec.instance_id
4018: );
4019: fnd_log.string

Line 4019: fnd_log.string

4015: fnd_log.level_statement,
4016: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4017: 'l_instance_rec.instance_id : ' || l_instance_rec.instance_id
4018: );
4019: fnd_log.string
4020: (
4021: fnd_log.level_statement,
4022: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4023: 'l_instance_rec.quantity : ' || l_instance_rec.quantity

Line 4021: fnd_log.level_statement,

4017: 'l_instance_rec.instance_id : ' || l_instance_rec.instance_id
4018: );
4019: fnd_log.string
4020: (
4021: fnd_log.level_statement,
4022: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4023: 'l_instance_rec.quantity : ' || l_instance_rec.quantity
4024: );
4025: fnd_log.string

Line 4025: fnd_log.string

4021: fnd_log.level_statement,
4022: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4023: 'l_instance_rec.quantity : ' || l_instance_rec.quantity
4024: );
4025: fnd_log.string
4026: (
4027: fnd_log.level_statement,
4028: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4029: 'l_instance_rec.active_end_date : ' || to_char(l_instance_rec.active_end_date)

Line 4027: fnd_log.level_statement,

4023: 'l_instance_rec.quantity : ' || l_instance_rec.quantity
4024: );
4025: fnd_log.string
4026: (
4027: fnd_log.level_statement,
4028: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4029: 'l_instance_rec.active_end_date : ' || to_char(l_instance_rec.active_end_date)
4030: );
4031: END IF;

Line 4071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4067: ,x_instance_id_lst => l_instance_id_lst
4068: ,x_return_status => x_return_status
4069: ,x_msg_count => l_msg_count
4070: ,x_msg_data => l_msg_data );
4071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4072: fnd_log.string
4073: (
4074: fnd_log.level_procedure,
4075: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',

Line 4072: fnd_log.string

4068: ,x_return_status => x_return_status
4069: ,x_msg_count => l_msg_count
4070: ,x_msg_data => l_msg_data );
4071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4072: fnd_log.string
4073: (
4074: fnd_log.level_procedure,
4075: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
4076: 'At the end of PLSQL procedure'

Line 4074: fnd_log.level_procedure,

4070: ,x_msg_data => l_msg_data );
4071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4072: fnd_log.string
4073: (
4074: fnd_log.level_procedure,
4075: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
4076: 'At the end of PLSQL procedure'
4077: );
4078: END IF;

Line 4197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4193: l_open_wip_job_dest BOOLEAN;
4194:
4195:
4196: BEGIN
4197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_procedure,
4201: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 4198: fnd_log.string

4194:
4195:
4196: BEGIN
4197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_procedure,
4201: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4202: 'At the start of PLSQL procedure'

Line 4200: fnd_log.level_procedure,

4196: BEGIN
4197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_procedure,
4201: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4202: 'At the start of PLSQL procedure'
4203: );
4204: END IF;

Line 4251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4247: -- add to dest instance quantity
4248: l_instance_rec.instance_id := l_dest_instance_rec.instance_id;
4249: l_instance_rec.quantity := l_dest_instance_rec.quantity + p_move_quantity;
4250: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4252: fnd_log.string
4253: (
4254: fnd_log.level_statement,
4255: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4252: fnd_log.string

4248: l_instance_rec.instance_id := l_dest_instance_rec.instance_id;
4249: l_instance_rec.quantity := l_dest_instance_rec.quantity + p_move_quantity;
4250: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4252: fnd_log.string
4253: (
4254: fnd_log.level_statement,
4255: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4256: 'Item Found in destination'

Line 4254: fnd_log.level_statement,

4250: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4252: fnd_log.string
4253: (
4254: fnd_log.level_statement,
4255: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4256: 'Item Found in destination'
4257: );
4258: fnd_log.string

Line 4258: fnd_log.string

4254: fnd_log.level_statement,
4255: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4256: 'Item Found in destination'
4257: );
4258: fnd_log.string
4259: (
4260: fnd_log.level_statement,
4261: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4262: 'l_dest_instance_rec.instance_id ' || l_dest_instance_rec.instance_id

Line 4260: fnd_log.level_statement,

4256: 'Item Found in destination'
4257: );
4258: fnd_log.string
4259: (
4260: fnd_log.level_statement,
4261: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4262: 'l_dest_instance_rec.instance_id ' || l_dest_instance_rec.instance_id
4263: );
4264: END IF;

Line 4272: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4268: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4269: x_Return_Status => X_Return_Status
4270: );
4271: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4272: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4273: fnd_log.string
4274: (
4275: fnd_log.level_error,
4276: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4273: fnd_log.string

4269: x_Return_Status => X_Return_Status
4270: );
4271: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4272: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4273: fnd_log.string
4274: (
4275: fnd_log.level_error,
4276: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4277: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '

Line 4275: fnd_log.level_error,

4271: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4272: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4273: fnd_log.string
4274: (
4275: fnd_log.level_error,
4276: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4277: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '
4278: );
4279: END IF;

Line 4293: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4289: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4290: x_Return_Status => X_Return_Status
4291: );
4292: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4293: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4294: fnd_log.string
4295: (
4296: fnd_log.level_error,
4297: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4294: fnd_log.string

4290: x_Return_Status => X_Return_Status
4291: );
4292: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4293: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4294: fnd_log.string
4295: (
4296: fnd_log.level_error,
4297: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4298: 'Item in destination: source Non Serialized update_csi_item_instance returned error '

Line 4296: fnd_log.level_error,

4292: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4293: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4294: fnd_log.string
4295: (
4296: fnd_log.level_error,
4297: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4298: 'Item in destination: source Non Serialized update_csi_item_instance returned error '
4299: );
4300: END IF;

Line 4317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4313: ELSE
4314: l_instance_rec.quantity := l_dest_instance_rec.quantity + p_move_quantity;
4315: END IF;
4316: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4318: fnd_log.string
4319: (
4320: fnd_log.level_statement,
4321: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4318: fnd_log.string

4314: l_instance_rec.quantity := l_dest_instance_rec.quantity + p_move_quantity;
4315: END IF;
4316: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4318: fnd_log.string
4319: (
4320: fnd_log.level_statement,
4321: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4322: 'Item Found in destination'

Line 4320: fnd_log.level_statement,

4316: l_instance_rec.object_version_number := l_dest_instance_rec.object_version_number;
4317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4318: fnd_log.string
4319: (
4320: fnd_log.level_statement,
4321: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4322: 'Item Found in destination'
4323: );
4324: fnd_log.string

Line 4324: fnd_log.string

4320: fnd_log.level_statement,
4321: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4322: 'Item Found in destination'
4323: );
4324: fnd_log.string
4325: (
4326: fnd_log.level_statement,
4327: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4328: 'l_dest_instance_rec.instance_id ' || l_dest_instance_rec.instance_id

Line 4326: fnd_log.level_statement,

4322: 'Item Found in destination'
4323: );
4324: fnd_log.string
4325: (
4326: fnd_log.level_statement,
4327: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4328: 'l_dest_instance_rec.instance_id ' || l_dest_instance_rec.instance_id
4329: );
4330: END IF;

Line 4338: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4334: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4335: x_Return_Status => X_Return_Status
4336: );
4337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4338: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4339: fnd_log.string
4340: (
4341: fnd_log.level_error,
4342: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4339: fnd_log.string

4335: x_Return_Status => X_Return_Status
4336: );
4337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4338: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4339: fnd_log.string
4340: (
4341: fnd_log.level_error,
4342: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4343: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '

Line 4341: fnd_log.level_error,

4337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4338: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4339: fnd_log.string
4340: (
4341: fnd_log.level_error,
4342: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4343: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '
4344: );
4345: END IF;

Line 4366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4362: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4363: x_Return_Status => X_Return_Status
4364: );
4365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4367: fnd_log.string
4368: (
4369: fnd_log.level_error,
4370: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4367: fnd_log.string

4363: x_Return_Status => X_Return_Status
4364: );
4365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4367: fnd_log.string
4368: (
4369: fnd_log.level_error,
4370: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4371: 'Item in destination: source Non Serialized update_csi_item_instance returned error '

Line 4369: fnd_log.level_error,

4365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4367: fnd_log.string
4368: (
4369: fnd_log.level_error,
4370: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4371: 'Item in destination: source Non Serialized update_csi_item_instance returned error '
4372: );
4373: END IF;

Line 4377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4373: END IF;
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: ELSE -- no item in destination
4377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4378: fnd_log.string
4379: (
4380: fnd_log.level_statement,
4381: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4378: fnd_log.string

4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: ELSE -- no item in destination
4377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4378: fnd_log.string
4379: (
4380: fnd_log.level_statement,
4381: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4382: 'Active Item Not Found in destination'

Line 4380: fnd_log.level_statement,

4376: ELSE -- no item in destination
4377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4378: fnd_log.string
4379: (
4380: fnd_log.level_statement,
4381: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4382: 'Active Item Not Found in destination'
4383: );
4384: fnd_log.string

Line 4384: fnd_log.string

4380: fnd_log.level_statement,
4381: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4382: 'Active Item Not Found in destination'
4383: );
4384: fnd_log.string
4385: (
4386: fnd_log.level_statement,
4387: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4388: 'l_source_inst_rec.instance_id ' || l_source_inst_rec.instance_id

Line 4386: fnd_log.level_statement,

4382: 'Active Item Not Found in destination'
4383: );
4384: fnd_log.string
4385: (
4386: fnd_log.level_statement,
4387: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4388: 'l_source_inst_rec.instance_id ' || l_source_inst_rec.instance_id
4389: );
4390: fnd_log.string

Line 4390: fnd_log.string

4386: fnd_log.level_statement,
4387: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4388: 'l_source_inst_rec.instance_id ' || l_source_inst_rec.instance_id
4389: );
4390: fnd_log.string
4391: (
4392: fnd_log.level_statement,
4393: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4394: 'l_source_inst_rec.quantity ' || l_source_inst_rec.quantity

Line 4392: fnd_log.level_statement,

4388: 'l_source_inst_rec.instance_id ' || l_source_inst_rec.instance_id
4389: );
4390: fnd_log.string
4391: (
4392: fnd_log.level_statement,
4393: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4394: 'l_source_inst_rec.quantity ' || l_source_inst_rec.quantity
4395: );
4396: fnd_log.string

Line 4396: fnd_log.string

4392: fnd_log.level_statement,
4393: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4394: 'l_source_inst_rec.quantity ' || l_source_inst_rec.quantity
4395: );
4396: fnd_log.string
4397: (
4398: fnd_log.level_statement,
4399: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4400: 'p_dest_wip_job_id ' || p_dest_wip_job_id

Line 4398: fnd_log.level_statement,

4394: 'l_source_inst_rec.quantity ' || l_source_inst_rec.quantity
4395: );
4396: fnd_log.string
4397: (
4398: fnd_log.level_statement,
4399: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4400: 'p_dest_wip_job_id ' || p_dest_wip_job_id
4401: );
4402: fnd_log.string

Line 4402: fnd_log.string

4398: fnd_log.level_statement,
4399: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4400: 'p_dest_wip_job_id ' || p_dest_wip_job_id
4401: );
4402: fnd_log.string
4403: (
4404: fnd_log.level_statement,
4405: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4406: 'p_move_quantity ' || p_move_quantity

Line 4404: fnd_log.level_statement,

4400: 'p_dest_wip_job_id ' || p_dest_wip_job_id
4401: );
4402: fnd_log.string
4403: (
4404: fnd_log.level_statement,
4405: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4406: 'p_move_quantity ' || p_move_quantity
4407: );
4408: END IF;

Line 4414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4410: OPEN dest_inactive_instance_csr(p_source_instance_id,p_dest_wip_job_id);
4411: FETCH dest_inactive_instance_csr INTO l_junk;
4412: IF(dest_inactive_instance_csr%NOTFOUND)THEN
4413: l_inactive_item_found := FALSE;
4414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4415: fnd_log.string
4416: (
4417: fnd_log.level_statement,
4418: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4415: fnd_log.string

4411: FETCH dest_inactive_instance_csr INTO l_junk;
4412: IF(dest_inactive_instance_csr%NOTFOUND)THEN
4413: l_inactive_item_found := FALSE;
4414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4415: fnd_log.string
4416: (
4417: fnd_log.level_statement,
4418: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4419: 'No inactive item either in destination '

Line 4417: fnd_log.level_statement,

4413: l_inactive_item_found := FALSE;
4414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4415: fnd_log.string
4416: (
4417: fnd_log.level_statement,
4418: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4419: 'No inactive item either in destination '
4420: );
4421: END IF;

Line 4435: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4431: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4432: x_Return_Status => X_Return_Status
4433: );
4434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4435: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4436: fnd_log.string
4437: (
4438: fnd_log.level_error,
4439: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4436: fnd_log.string

4432: x_Return_Status => X_Return_Status
4433: );
4434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4435: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4436: fnd_log.string
4437: (
4438: fnd_log.level_error,
4439: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4440: 'Item NOT in destination: Full Move update_csi_item_instance returned error '

Line 4438: fnd_log.level_error,

4434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4435: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4436: fnd_log.string
4437: (
4438: fnd_log.level_error,
4439: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4440: 'Item NOT in destination: Full Move update_csi_item_instance returned error '
4441: );
4442: END IF;

Line 4456: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4452: x_dest_instance_id => l_dest_instance_id,
4453: x_return_status => X_Return_Status
4454: );
4455: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4456: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4457: fnd_log.string
4458: (
4459: fnd_log.level_error,
4460: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4457: fnd_log.string

4453: x_return_status => X_Return_Status
4454: );
4455: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4456: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4457: fnd_log.string
4458: (
4459: fnd_log.level_error,
4460: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4461: 'Item NOT in destination: Partial Move create_similar_instance returned error '

Line 4459: fnd_log.level_error,

4455: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4456: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4457: fnd_log.string
4458: (
4459: fnd_log.level_error,
4460: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4461: 'Item NOT in destination: Partial Move create_similar_instance returned error '
4462: );
4463: END IF;

Line 4476: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4472: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4473: x_Return_Status => X_Return_Status
4474: );
4475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4476: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4477: fnd_log.string
4478: (
4479: fnd_log.level_error,
4480: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4477: fnd_log.string

4473: x_Return_Status => X_Return_Status
4474: );
4475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4476: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4477: fnd_log.string
4478: (
4479: fnd_log.level_error,
4480: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4481: 'Item NOT in destination: Partial Move/Update Source qty update_csi_item_instance returned error '

Line 4479: fnd_log.level_error,

4475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4476: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4477: fnd_log.string
4478: (
4479: fnd_log.level_error,
4480: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4481: 'Item NOT in destination: Partial Move/Update Source qty update_csi_item_instance returned error '
4482: );
4483: END IF;

Line 4489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4485: END IF;
4486: END IF;
4487: END IF;
4488:
4489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_procedure,
4493: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',

Line 4490: fnd_log.string

4486: END IF;
4487: END IF;
4488:
4489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_procedure,
4493: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
4494: 'At the end of PLSQL procedure'

Line 4492: fnd_log.level_procedure,

4488:
4489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_procedure,
4493: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.end',
4494: 'At the end of PLSQL procedure'
4495: );
4496: END IF;

Line 4575: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4571:
4572: l_copy_instance BOOLEAN;
4573:
4574: BEGIN
4575: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4576: fnd_log.string
4577: (
4578: fnd_log.level_procedure,
4579: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 4576: fnd_log.string

4572: l_copy_instance BOOLEAN;
4573:
4574: BEGIN
4575: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4576: fnd_log.string
4577: (
4578: fnd_log.level_procedure,
4579: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4580: 'At the start of PLSQL procedure'

Line 4578: fnd_log.level_procedure,

4574: BEGIN
4575: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4576: fnd_log.string
4577: (
4578: fnd_log.level_procedure,
4579: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4580: 'At the start of PLSQL procedure'
4581: );
4582: END IF;

Line 4588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4584: l_copy_instance := TRUE;
4585: OPEN dest_instance_csr(p_dest_wip_job_id,p_source_instance_id );
4586: FETCH dest_instance_csr INTO l_dest_instance_rec.instance_id;
4587: IF(dest_instance_csr%FOUND)THEN
4588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4589: fnd_log.string
4590: (
4591: fnd_log.level_statement,
4592: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4589: fnd_log.string

4585: OPEN dest_instance_csr(p_dest_wip_job_id,p_source_instance_id );
4586: FETCH dest_instance_csr INTO l_dest_instance_rec.instance_id;
4587: IF(dest_instance_csr%FOUND)THEN
4588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4589: fnd_log.string
4590: (
4591: fnd_log.level_statement,
4592: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4593: 'Expired instance found'

Line 4591: fnd_log.level_statement,

4587: IF(dest_instance_csr%FOUND)THEN
4588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4589: fnd_log.string
4590: (
4591: fnd_log.level_statement,
4592: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4593: 'Expired instance found'
4594: );
4595: END IF;

Line 4601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4597: END IF;
4598: CLOSE dest_instance_csr;
4599:
4600: IF(l_copy_instance)THEN
4601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_statement,
4605: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4602: fnd_log.string

4598: CLOSE dest_instance_csr;
4599:
4600: IF(l_copy_instance)THEN
4601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_statement,
4605: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4606: 'Searching for a dummy one'

Line 4604: fnd_log.level_statement,

4600: IF(l_copy_instance)THEN
4601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_statement,
4605: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4606: 'Searching for a dummy one'
4607: );
4608: END IF;

Line 4612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4608: END IF;
4609: OPEN dest_instance_csr1(p_dest_wip_job_id,p_source_instance_id );
4610: FETCH dest_instance_csr1 INTO l_dest_instance_rec.instance_id;
4611: IF(dest_instance_csr1%FOUND)THEN
4612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4613: fnd_log.string
4614: (
4615: fnd_log.level_statement,
4616: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4613: fnd_log.string

4609: OPEN dest_instance_csr1(p_dest_wip_job_id,p_source_instance_id );
4610: FETCH dest_instance_csr1 INTO l_dest_instance_rec.instance_id;
4611: IF(dest_instance_csr1%FOUND)THEN
4612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4613: fnd_log.string
4614: (
4615: fnd_log.level_statement,
4616: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4617: 'Dummy instance found '

Line 4615: fnd_log.level_statement,

4611: IF(dest_instance_csr1%FOUND)THEN
4612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4613: fnd_log.string
4614: (
4615: fnd_log.level_statement,
4616: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4617: 'Dummy instance found '
4618: );
4619: END IF;

Line 4635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4631: l_source_instance_rec.LOCATION_ID,
4632: l_source_instance_rec.INSTANCE_STATUS_ID;
4633: CLOSE get_instance_attrib_csr;
4634:
4635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4636: fnd_log.string
4637: (
4638: fnd_log.level_statement,
4639: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4636: fnd_log.string

4632: l_source_instance_rec.INSTANCE_STATUS_ID;
4633: CLOSE get_instance_attrib_csr;
4634:
4635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4636: fnd_log.string
4637: (
4638: fnd_log.level_statement,
4639: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4640: 'l_source_instance_rec.instance_id ' || l_source_instance_rec.instance_id

Line 4638: fnd_log.level_statement,

4634:
4635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4636: fnd_log.string
4637: (
4638: fnd_log.level_statement,
4639: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4640: 'l_source_instance_rec.instance_id ' || l_source_instance_rec.instance_id
4641: );
4642: fnd_log.string

Line 4642: fnd_log.string

4638: fnd_log.level_statement,
4639: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4640: 'l_source_instance_rec.instance_id ' || l_source_instance_rec.instance_id
4641: );
4642: fnd_log.string
4643: (
4644: fnd_log.level_statement,
4645: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4646: 'l_source_instance_rec.object_version_number ' || l_source_instance_rec.object_version_number

Line 4644: fnd_log.level_statement,

4640: 'l_source_instance_rec.instance_id ' || l_source_instance_rec.instance_id
4641: );
4642: fnd_log.string
4643: (
4644: fnd_log.level_statement,
4645: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4646: 'l_source_instance_rec.object_version_number ' || l_source_instance_rec.object_version_number
4647: );
4648: fnd_log.string

Line 4648: fnd_log.string

4644: fnd_log.level_statement,
4645: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4646: 'l_source_instance_rec.object_version_number ' || l_source_instance_rec.object_version_number
4647: );
4648: fnd_log.string
4649: (
4650: fnd_log.level_statement,
4651: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4652: 'p_dest_quantity ' || p_dest_quantity

Line 4650: fnd_log.level_statement,

4646: 'l_source_instance_rec.object_version_number ' || l_source_instance_rec.object_version_number
4647: );
4648: fnd_log.string
4649: (
4650: fnd_log.level_statement,
4651: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4652: 'p_dest_quantity ' || p_dest_quantity
4653: );
4654: fnd_log.string

Line 4654: fnd_log.string

4650: fnd_log.level_statement,
4651: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4652: 'p_dest_quantity ' || p_dest_quantity
4653: );
4654: fnd_log.string
4655: (
4656: fnd_log.level_statement,
4657: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4658: 'p_dest_wip_job_id ' || p_dest_wip_job_id

Line 4656: fnd_log.level_statement,

4652: 'p_dest_quantity ' || p_dest_quantity
4653: );
4654: fnd_log.string
4655: (
4656: fnd_log.level_statement,
4657: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4658: 'p_dest_wip_job_id ' || p_dest_wip_job_id
4659: );
4660: END IF;

Line 4685: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4681: ,x_msg_data => l_msg_data
4682: );
4683:
4684: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4685: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4686: fnd_log.string
4687: (
4688: fnd_log.level_error,
4689: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4686: fnd_log.string

4682: );
4683:
4684: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4685: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4686: fnd_log.string
4687: (
4688: fnd_log.level_error,
4689: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4690: 'CSI_ITEM_INSTANCE_PUB.copy_item_instance returned error '

Line 4688: fnd_log.level_error,

4684: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4685: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4686: fnd_log.string
4687: (
4688: fnd_log.level_error,
4689: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4690: 'CSI_ITEM_INSTANCE_PUB.copy_item_instance returned error '
4691: );
4692: END IF;

Line 4696: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4692: END IF;
4693: RAISE FND_API.G_EXC_ERROR;
4694: END IF;
4695:
4696: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4697: fnd_log.string
4698: (
4699: fnd_log.level_statement,
4700: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4697: fnd_log.string

4693: RAISE FND_API.G_EXC_ERROR;
4694: END IF;
4695:
4696: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4697: fnd_log.string
4698: (
4699: fnd_log.level_statement,
4700: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4701: 'Instance copied successfully'

Line 4699: fnd_log.level_statement,

4695:
4696: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4697: fnd_log.string
4698: (
4699: fnd_log.level_statement,
4700: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4701: 'Instance copied successfully'
4702: );
4703: fnd_log.string

Line 4703: fnd_log.string

4699: fnd_log.level_statement,
4700: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4701: 'Instance copied successfully'
4702: );
4703: fnd_log.string
4704: (
4705: fnd_log.level_statement,
4706: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4707: 'l_new_instance_tbl(1).instance_id : ' ||l_new_instance_tbl(1).instance_id

Line 4705: fnd_log.level_statement,

4701: 'Instance copied successfully'
4702: );
4703: fnd_log.string
4704: (
4705: fnd_log.level_statement,
4706: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4707: 'l_new_instance_tbl(1).instance_id : ' ||l_new_instance_tbl(1).instance_id
4708: );
4709:

Line 4743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

4739: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4740: x_Return_Status => X_Return_Status
4741: );
4742: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4744: fnd_log.string
4745: (
4746: fnd_log.level_error,
4747: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,

Line 4744: fnd_log.string

4740: x_Return_Status => X_Return_Status
4741: );
4742: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4744: fnd_log.string
4745: (
4746: fnd_log.level_error,
4747: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4748: 'Updating copied instance loc: update_csi_item_instance returned error '

Line 4746: fnd_log.level_error,

4742: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4744: fnd_log.string
4745: (
4746: fnd_log.level_error,
4747: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4748: 'Updating copied instance loc: update_csi_item_instance returned error '
4749: );
4750: END IF;

Line 4756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4752: END IF;
4753: x_dest_instance_id := l_dest_instance_rec.instance_id;
4754:
4755:
4756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4757: fnd_log.string
4758: (
4759: fnd_log.level_procedure,
4760: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',

Line 4757: fnd_log.string

4753: x_dest_instance_id := l_dest_instance_rec.instance_id;
4754:
4755:
4756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4757: fnd_log.string
4758: (
4759: fnd_log.level_procedure,
4760: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4761: 'At the end of PLSQL procedure'

Line 4759: fnd_log.level_procedure,

4755:
4756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4757: fnd_log.string
4758: (
4759: fnd_log.level_procedure,
4760: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
4761: 'At the end of PLSQL procedure'
4762: );
4763: END IF;

Line 4816: -- FND Logging Constants

4812: x_msg_data OUT NOCOPY VARCHAR2,
4813: x_msg_count OUT NOCOPY NUMBER)
4814: IS
4815:
4816: -- FND Logging Constants
4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4813: x_msg_count OUT NOCOPY NUMBER)
4814: IS
4815:
4816: -- FND Logging Constants
4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';

Line 4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;

4814: IS
4815:
4816: -- FND Logging Constants
4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:

Line 4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;

4815:
4816: -- FND Logging Constants
4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4816: -- FND Logging Constants
4817: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4818: l_debug_proc NUMBER := FND_LOG.LEVEL_PROCEDURE;
4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4846: fnd_log.string(l_debug_proc,l_debug_module,

4842: BEGIN
4843:
4844: -- log debug message.
4845: IF (l_debug_proc >= l_debug_level) THEN
4846: fnd_log.string(l_debug_proc,l_debug_module,
4847: 'At Start of procedure AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition');
4848: END IF;
4849:
4850: -- Standard start of API savepoint

Line 4863: fnd_log.string(l_debug_stmt,l_debug_module,

4859: x_return_status := FND_API.G_RET_STS_SUCCESS;
4860:
4861: -- log debug message.
4862: IF (l_debug_stmt >= l_debug_level) THEN
4863: fnd_log.string(l_debug_stmt,l_debug_module,
4864: 'Input instance_id:' || p_instance_id);
4865: fnd_log.string(l_debug_stmt,l_debug_module,
4866: 'Input object_version_number:' || p_object_version_number);
4867: fnd_log.string(l_debug_stmt,l_debug_module,

Line 4865: fnd_log.string(l_debug_stmt,l_debug_module,

4861: -- log debug message.
4862: IF (l_debug_stmt >= l_debug_level) THEN
4863: fnd_log.string(l_debug_stmt,l_debug_module,
4864: 'Input instance_id:' || p_instance_id);
4865: fnd_log.string(l_debug_stmt,l_debug_module,
4866: 'Input object_version_number:' || p_object_version_number);
4867: fnd_log.string(l_debug_stmt,l_debug_module,
4868: 'Input instance_condition_id:' || p_instance_condition_id);
4869: fnd_log.string(l_debug_stmt,l_debug_module,

Line 4867: fnd_log.string(l_debug_stmt,l_debug_module,

4863: fnd_log.string(l_debug_stmt,l_debug_module,
4864: 'Input instance_id:' || p_instance_id);
4865: fnd_log.string(l_debug_stmt,l_debug_module,
4866: 'Input object_version_number:' || p_object_version_number);
4867: fnd_log.string(l_debug_stmt,l_debug_module,
4868: 'Input instance_condition_id:' || p_instance_condition_id);
4869: fnd_log.string(l_debug_stmt,l_debug_module,
4870: 'Input p_validation_level:' || p_validation_level);
4871: END IF;

Line 4869: fnd_log.string(l_debug_stmt,l_debug_module,

4865: fnd_log.string(l_debug_stmt,l_debug_module,
4866: 'Input object_version_number:' || p_object_version_number);
4867: fnd_log.string(l_debug_stmt,l_debug_module,
4868: 'Input instance_condition_id:' || p_instance_condition_id);
4869: fnd_log.string(l_debug_stmt,l_debug_module,
4870: 'Input p_validation_level:' || p_validation_level);
4871: END IF;
4872:
4873: IF (p_validation_Level = FND_API.G_VALID_LEVEL_FULL) THEN

Line 4915: fnd_log.string(l_debug_stmt,l_debug_module,

4911: -- validate if serialized.
4912: IF (l_serial_number IS NULL) THEN
4913: -- log debug message.
4914: IF (l_debug_stmt >= l_debug_level) THEN
4915: fnd_log.string(l_debug_stmt,l_debug_module,
4916: 'Instance is not serialized; no update performed.');
4917: END IF;
4918: RETURN; -- condition not updated for non-serial instances.
4919: END IF;

Line 5018: fnd_log.string(l_debug_proc,l_debug_module,

5014: END IF; -- condition not changed.
5015:
5016: -- log debug message.
5017: IF (l_debug_proc >= l_debug_level) THEN
5018: fnd_log.string(l_debug_proc,l_debug_module,
5019: 'At End of procedure AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition');
5020: END IF;
5021:
5022: END update_part_condition;

Line 5048: L_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5044: L_MSG_COUNT NUMBER;
5045: L_MSG_DATA VARCHAR2(4000);
5046:
5047: L_DEBUG_MODULE VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.CANCEL_WO_RESERVATION';
5048: L_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5049: L_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
5050:
5051: BEGIN
5052: IF (l_debug_proc >= l_debug_level) THEN

Line 5049: L_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;

5045: L_MSG_DATA VARCHAR2(4000);
5046:
5047: L_DEBUG_MODULE VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.CANCEL_WO_RESERVATION';
5048: L_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5049: L_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
5050:
5051: BEGIN
5052: IF (l_debug_proc >= l_debug_level) THEN
5053: FND_LOG.STRING(L_DEBUG_PROC,L_DEBUG_MODULE,

Line 5053: FND_LOG.STRING(L_DEBUG_PROC,L_DEBUG_MODULE,

5049: L_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
5050:
5051: BEGIN
5052: IF (l_debug_proc >= l_debug_level) THEN
5053: FND_LOG.STRING(L_DEBUG_PROC,L_DEBUG_MODULE,
5054: 'At Start of procedure AHL_PRD_PARTS_CHANGE_PVT.CANCEL_WO_RESERVATION');
5055: END IF;
5056: FOR GET_SRC_RES_ID_REC IN GET_SRC_RES_ID_CSR(P_ITEM_INSTANCE_ID)
5057: LOOP