DBA Data[Home] [Help]

APPS.WSMPLOAD dependencies on FND_API

Line 36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
38: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: -- This procedure is used to add a errored job to the PL/SQL errored jobs table...

Line 37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;

33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
38: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: -- This procedure is used to add a errored job to the PL/SQL errored jobs table...
41: Procedure add_errored_jobs (p_error_job_name IN VARCHAR2 ,

Line 38: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
38: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: -- This procedure is used to add a errored job to the PL/SQL errored jobs table...
41: Procedure add_errored_jobs (p_error_job_name IN VARCHAR2 ,
42: p_error_job_id IN NUMBER ,

Line 256: RAISE FND_API.G_EXC_ERROR;

252: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
253: p_run_log_level => l_log_level
254: );
255: END IF;
256: RAISE FND_API.G_EXC_ERROR;
257:
258: ELSE
259: if( g_log_level_statement >= l_log_level ) then
260: l_msg_tokens.delete;

Line 371: RAISE FND_API.G_EXC_ERROR;

367: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
368: p_run_log_level => l_log_level
369: );
370: END IF;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373: -- x_err_code := 0; -- Fix for bug #3421662 --
374: END IF;
375:

Line 444: RAISE FND_API.G_EXC_ERROR;

440: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
441: p_run_log_level => l_log_level
442: );
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
445:
446: END IF;
447:
448: l_stmt_num := 47.7;

Line 463: p_initMsgList => FND_API.g_true,

459: End if;
460:
461: WSM_infinite_scheduler_PVT.schedule
462: (
463: p_initMsgList => FND_API.g_true,
464: p_endDebug => FND_API.g_true,
465: p_orgID => c_inf_sch_par_rep_jobs_rec.organization_id,
466: p_wipEntityID => c_inf_sch_par_rep_jobs_rec.wip_entity_id,
467: p_scheduleMode => c_inf_sch_par_rep_jobs_rec.inf_sch_mode,

Line 464: p_endDebug => FND_API.g_true,

460:
461: WSM_infinite_scheduler_PVT.schedule
462: (
463: p_initMsgList => FND_API.g_true,
464: p_endDebug => FND_API.g_true,
465: p_orgID => c_inf_sch_par_rep_jobs_rec.organization_id,
466: p_wipEntityID => c_inf_sch_par_rep_jobs_rec.wip_entity_id,
467: p_scheduleMode => c_inf_sch_par_rep_jobs_rec.inf_sch_mode,
468: p_startDate => l_job_op_start_dt,

Line 476: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

472: x_returnStatus => l_return_status,
473: x_errorMsg => l_error_msg
474: );
475:
476: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
477: -- x_error_code := -1;
478: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
479:
480: l_msg_tokens.delete;

Line 490: RAISE FND_API.G_EXC_ERROR;

486: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
487: p_run_log_level => l_log_level
488: );
489: END IF;
490: RAISE FND_API.G_EXC_ERROR;
491: ELSE
492: -- x_error_code := 0;
493: if( g_log_level_statement >= l_log_level ) then
494: l_msg_tokens.delete;

Line 510: WHEN FND_API.G_EXC_ERROR THEN

506: END LOOP; --C_INF_SCH_PAR_REP_JOBS
507: CLOSE C_INF_SCH_PAR_REP_JOBS;
508:
509: exception
510: WHEN FND_API.G_EXC_ERROR THEN
511:
512: x_return_status := G_RET_ERROR;
513: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
514: p_count => x_msg_count ,

Line 518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

514: p_count => x_msg_count ,
515: p_data => x_error_msg
516: );
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519:
520: x_return_status := G_RET_UNEXPECTED;
521:
522: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 1159: p_encoded => FND_API.G_FALSE

1155: fnd_file.put_line(fnd_file.log,l_error_msg);
1156: ELSIF (l_msg_count > 1) THEN
1157: FOR i IN 1..l_msg_count LOOP
1158: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,
1159: p_encoded => FND_API.G_FALSE
1160: );
1161: fnd_file.put_line(fnd_file.log,l_error_msg);
1162: END LOOP;
1163: END IF;

Line 1274: p_commit => FND_API.G_FALSE,

1270: );
1271: End if;
1272:
1273: WSM_WIP_LOT_TXN_PVT.invoke_txn_API ( p_api_version => 1.0,
1274: p_commit => FND_API.G_FALSE,
1275: p_init_msg_list => FND_API.G_TRUE,
1276: p_validation_level => 1,
1277: p_calling_mode => 1, --indicates that called from interface(2-Forms,1-Interface)
1278: p_txn_header_rec => l_txn_header_rec,

Line 1275: p_init_msg_list => FND_API.G_TRUE,

1271: End if;
1272:
1273: WSM_WIP_LOT_TXN_PVT.invoke_txn_API ( p_api_version => 1.0,
1274: p_commit => FND_API.G_FALSE,
1275: p_init_msg_list => FND_API.G_TRUE,
1276: p_validation_level => 1,
1277: p_calling_mode => 1, --indicates that called from interface(2-Forms,1-Interface)
1278: p_txn_header_rec => l_txn_header_rec,
1279: p_starting_jobs_tbl => l_starting_jobs_tbl,

Line 1306: p_encoded => FND_API.G_FALSE

1302: fnd_file.put_line(fnd_file.log,l_error_msg);
1303: ELSIF (l_msg_count > 1) THEN
1304: FOR i IN 1..l_msg_count LOOP
1305: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,
1306: p_encoded => FND_API.G_FALSE
1307: );
1308: fnd_file.put_line(fnd_file.log,l_error_msg);
1309: END LOOP;
1310: END IF;

Line 1317: if l_return_status = fnd_api.g_ret_sts_success then

1313: -- here...
1314: -- if it returns success then add the particularly header id .... to the success list.... else to the failure list...
1315: l_stmt_num := 68;
1316:
1317: if l_return_status = fnd_api.g_ret_sts_success then
1318:
1319: if( g_log_level_statement >= l_log_level ) then
1320: l_msg_tokens.delete;
1321: WSM_log_PVT.logMessage(p_module_name => l_module ,