DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on FND_API

Line 39: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

35: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
36: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
37: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
38:
39: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
40: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
41: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
42: --mes end
43: --NSO Modification by abedajna begin

Line 40: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

36: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
37: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
38:
39: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
40: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
41: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
42: --mes end
43: --NSO Modification by abedajna begin
44: -- Changed the signature of the procedure so that l_op_seq_id is passed along with l_std_operatio_id.

Line 41: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

37: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
38:
39: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
40: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
41: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
42: --mes end
43: --NSO Modification by abedajna begin
44: -- Changed the signature of the procedure so that l_op_seq_id is passed along with l_std_operatio_id.
45: -- commenting out the procedure call and replacing by the mofied call.

Line 726: RAISE FND_API.G_EXC_ERROR;

722: , x_msg_data => l_msg_data
723: );
724:
725: IF l_return_status = g_ret_error THEN
726: RAISE FND_API.G_EXC_ERROR;
727: l_stat_num := 370;
728: IF (l_msg_count = 1) THEN
729: x_error_code := -1;
730: x_error_msg := l_msg_data;

Line 737: RAISE FND_API.G_EXC_ERROR;

733: x_error_code := -1;
734: x_error_msg := substr(x_error_msg||fnd_msg_pub.get, 1, 4000);
735: END LOOP;
736: END IF;
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF l_return_status = g_ret_unexpected THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: --end bug 5191386

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: END LOOP;
736: END IF;
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF l_return_status = g_ret_unexpected THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: --end bug 5191386
742: END IF;
743:

Line 1103: p_initMsgList => fnd_api.g_true,

1099: AND organization_id = X_Organization_Id
1100: AND operation_seq_num = X_From_Op;
1101:
1102: wsm_infinite_scheduler_pvt.schedule(
1103: p_initMsgList => fnd_api.g_true,
1104: p_endDebug => fnd_api.g_true,
1105: p_orgID => X_Organization_Id,
1106: p_wipEntityID => X_Wip_Entity_Id,
1107: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,

Line 1104: p_endDebug => fnd_api.g_true,

1100: AND operation_seq_num = X_From_Op;
1101:
1102: wsm_infinite_scheduler_pvt.schedule(
1103: p_initMsgList => fnd_api.g_true,
1104: p_endDebug => fnd_api.g_true,
1105: p_orgID => X_Organization_Id,
1106: p_wipEntityID => X_Wip_Entity_Id,
1107: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,
1108: p_startDate => l_infi_start_date,

Line 1115: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN

1111: p_scheQuantity => p_txn_quantity,
1112: x_returnStatus => x_returnStatus,
1113: x_errorMsg => x_error_msg);
1114:
1115: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1116: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);
1117: x_error_code := -1;
1118: return ;
1119: ELSE

Line 3511: RAISE FND_API.G_EXC_ERROR;

3507: , x_msg_data => l_msg_data
3508: );
3509:
3510: IF l_return_status = g_ret_error THEN
3511: RAISE FND_API.G_EXC_ERROR;
3512: l_stmt_num := 370;
3513: IF (l_msg_count = 1) THEN
3514: x_error_code := -1;
3515: x_error_msg := l_msg_data;

Line 3522: RAISE FND_API.G_EXC_ERROR;

3518: x_error_code := -1;
3519: x_error_msg := substr(x_error_msg||fnd_msg_pub.get, 1, 4000);
3520: END LOOP;
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3523: ELSIF l_return_status = g_ret_unexpected THEN
3524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3525: END IF;
3526:

Line 3524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3520: END LOOP;
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3523: ELSIF l_return_status = g_ret_unexpected THEN
3524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3525: END IF;
3526:
3527: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3528: IF (l_return_status = g_ret_success) THEN

Line 3612: p_initMsgList => fnd_api.g_true,

3608: AND operation_seq_num = p_fm_job_op_seq_num;
3609:
3610: l_stmt_num := 30;
3611: wsm_infinite_scheduler_pvt.schedule(
3612: p_initMsgList => fnd_api.g_true,
3613: p_endDebug => fnd_api.g_true,
3614: p_orgID => p_org_id,
3615: p_wipEntityID => p_wip_entity_id,
3616: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,

Line 3613: p_endDebug => fnd_api.g_true,

3609:
3610: l_stmt_num := 30;
3611: wsm_infinite_scheduler_pvt.schedule(
3612: p_initMsgList => fnd_api.g_true,
3613: p_endDebug => fnd_api.g_true,
3614: p_orgID => p_org_id,
3615: p_wipEntityID => p_wip_entity_id,
3616: p_scheduleMode => WIP_CONSTANTS.CURRENT_OP,
3617: p_startDate => l_infi_start_date,

Line 3624: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN

3620: p_scheQuantity => p_scheQuantity,
3621: x_returnStatus => x_returnStatus,
3622: x_errorMsg => x_error_msg);
3623:
3624: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
3625: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);
3626: x_error_code := -1;
3627: return ;
3628: ELSE

Line 3828: WHEN FND_API.G_EXC_ERROR THEN

3824: p_count => x_error_count ,
3825: p_data => x_error_msg
3826: );
3827: EXCEPTION
3828: WHEN FND_API.G_EXC_ERROR THEN
3829:
3830: x_return_status := G_RET_ERROR;
3831: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3832: p_count => x_error_count ,

Line 3836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3832: p_count => x_error_count ,
3833: p_data => x_error_msg
3834: );
3835:
3836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3837:
3838: x_return_status := G_RET_UNEXPECTED;
3839:
3840: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,