DBA Data[Home] [Help]

APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_INFINITE_SCHEDULER_PVT

Line 1: package body wsm_infinite_scheduler_pvt as

1: package body wsm_infinite_scheduler_pvt as
2: /* $Header: WSMVIFSB.pls 120.3.12010000.4 2008/09/19 09:31:37 tbhande ship $ */
3:
4: --private types
5: type num_tbl_t is table of number;

Line 208: p_procName => 'wsm_infinite_scheduler_pvt.schedule',

204: l_params(7).paramName := 'p_resSeqNum';
205: l_params(7).paramValue := p_resSeqNum;
206:
207: wip_logger.entryPoint(
208: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
209: p_params => l_params,
210: x_returnStatus => x_returnStatus);
211: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
212: raise fnd_api.g_exc_unexpected_error;

Line 474: p_procName => 'wsm_infinite_scheduler_pvt.schedule',

470:
471: l_stmt_num := 70;
472: if (l_logLevel <= wip_constants.trace_logging) then
473: wip_logger.exitPoint(
474: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
475: p_procReturnStatus => x_returnStatus,
476: p_msg => 'success',
477: x_returnStatus => l_retStatus);
478: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 507: p_procName => 'wsm_infinite_scheduler_pvt.schedule',

503: p_msg => x_errorMsg,
504: p_delete_stack => fnd_api.g_false);
505: if (l_logLevel <= wip_constants.trace_logging) then
506: wip_logger.exitPoint(
507: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
508: p_procReturnStatus => x_returnStatus,
509: p_msg => 'error: ' || x_errorMsg,
510: x_returnStatus => l_retStatus);
511: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 523: p_pkg_name => 'wsm_infinite_scheduler_pvt',

519: when others then
520: rollback to SP_WSMIFS_0;
521: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
522: fnd_msg_pub.add_exc_msg(
523: p_pkg_name => 'wsm_infinite_scheduler_pvt',
524: p_procedure_name => 'schedule',
525: p_error_text => SQLERRM);
526: wip_utilities.get_message_stack(
527: p_msg => x_errorMsg,

Line 531: p_procName => 'wsm_infinite_scheduler_pvt.schedule',

527: p_msg => x_errorMsg,
528: p_delete_stack => fnd_api.g_false);
529: if (l_logLevel <= wip_constants.trace_logging) then
530: wip_logger.exitPoint(
531: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
532: p_procReturnStatus => x_returnStatus,
533: p_msg => 'unexp error: ' || x_errorMsg,
534: x_returnStatus => l_retStatus);
535: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 849: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

845: l_params(9).paramName := 'p_endRecoSeqNum';
846: l_params(9).paramValue := p_endRecoSeqNum;
847:
848: wip_logger.entryPoint(
849: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
850: p_params => l_params,
851: x_returnStatus => l_retStatus);
852: end if;
853: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1205: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

1201: end if;
1202: end if;
1203:
1204: if (l_logLevel <= wip_constants.trace_logging) then
1205: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1206: p_procReturnStatus => x_returnStatus,
1207: p_msg => 'success',
1208: x_returnStatus => l_retStatus);
1209: end if;

Line 1215: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

1211: EXCEPTION
1212: -- BA: BUG3195950
1213: when e_skip_sche then
1214: if (l_logLevel <= wip_constants.trace_logging) then
1215: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1216: p_procReturnStatus => x_returnStatus,
1217: p_msg => 'success',
1218: x_returnStatus => l_retStatus);
1219: end if;

Line 1225: p_pkg_name => 'wsm_infinite_scheduler_pvt',

1221: -- EA: BUG3195950
1222: when others then
1223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1224: fnd_msg_pub.add_exc_msg(
1225: p_pkg_name => 'wsm_infinite_scheduler_pvt',
1226: p_procedure_name => 'wsmJobReader',
1227: p_error_text => SQLERRM || ' (reader #' || l_stat_num || ')' );
1228: if (l_logLevel <= wip_constants.trace_logging) then
1229: wip_logger.exitPoint(

Line 1230: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',

1226: p_procedure_name => 'wsmJobReader',
1227: p_error_text => SQLERRM || ' (reader #' || l_stat_num || ')' );
1228: if (l_logLevel <= wip_constants.trace_logging) then
1229: wip_logger.exitPoint(
1230: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1231: p_procReturnStatus => x_returnStatus,
1232: p_msg => 'unexp error: ' || SQLERRM || ' (reader #' || l_stat_num || ')',
1233: x_returnStatus => l_retStatus);
1234: end if;

Line 1323: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',

1319: l_params(9).paramValue := p_resSeqNum;
1320:
1321:
1322: wip_logger.entryPoint(
1323: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
1324: p_params => l_params,
1325: x_returnStatus => l_retStatus);
1326: end if;
1327: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2213: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',

2209: end if;
2210:
2211: if (l_logLevel <= wip_constants.trace_logging) then
2212: wip_logger.exitPoint(
2213: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2214: p_procReturnStatus => x_returnStatus,
2215: p_msg => 'success',
2216: x_returnStatus => l_retStatus);
2217: end if;

Line 2224: p_pkg_name => 'wsm_infinite_scheduler_pvt',

2220:
2221: when others then
2222: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2223: fnd_msg_pub.add_exc_msg(
2224: p_pkg_name => 'wsm_infinite_scheduler_pvt',
2225: p_procedure_name => 'wsmJobWriter',
2226: p_error_text => SQLERRM || ' (writer #' || l_stat_num || ')' );
2227: if (l_logLevel <= wip_constants.trace_logging) then
2228: wip_logger.exitPoint(

Line 2229: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',

2225: p_procedure_name => 'wsmJobWriter',
2226: p_error_text => SQLERRM || ' (writer #' || l_stat_num || ')' );
2227: if (l_logLevel <= wip_constants.trace_logging) then
2228: wip_logger.exitPoint(
2229: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2230: p_procReturnStatus => x_returnStatus,
2231: p_msg => 'unexp error: ' || SQLERRM || ' (writer #' || l_stat_num || ')',
2232: x_returnStatus => l_retStatus);
2233: end if;

Line 2237: end wsm_infinite_scheduler_pvt;

2233: end if;
2234: end wsmJobWriter;
2235:
2236:
2237: end wsm_infinite_scheduler_pvt;