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.WIP_INFINITE_SCHEDULER_PVT dependencies on WIP_INFINITE_SCHEDULER_PVT

Line 1: package body wip_infinite_scheduler_pvt as

1: package body wip_infinite_scheduler_pvt as
2: /* $Header: wipiscdb.pls 120.9.12020000.3 2012/07/31 07:15:56 sisankar ship $ */
3:
4: --private types
5: type num_tbl_t is table of number;

Line 108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

104: l_params(9).paramValue := p_subGrpNum;
105: l_params(10).paramName := 'p_quantity';
106: l_params(10).paramValue := p_quantity;
107:
108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
109: p_params => l_params,
110: x_returnStatus => x_returnStatus);
111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
112: raise fnd_api.g_exc_unexpected_error;

Line 209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

205: raise fnd_api.g_exc_unexpected_error;
206: end if;
207:
208: if (l_logLevel <= wip_constants.trace_logging) then
209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'success',
212: x_returnStatus => l_retStatus);
213: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_delete_stack => fnd_api.g_false);
223: if (l_logLevel <= wip_constants.trace_logging) then
224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
225: p_procReturnStatus => x_returnStatus,
226: p_msg => 'error: ' || x_errorMsg,
227: x_returnStatus => l_retStatus);
228: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',

232:
233: when others then
234: rollback to wipiscdb0;
235: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
237: p_procedure_name => 'schedule',
238: p_error_text => SQLERRM);
239: wip_utilities.get_message_stack(p_msg => x_errorMsg,
240: p_delete_stack => fnd_api.g_false);

Line 242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

238: p_error_text => SQLERRM);
239: wip_utilities.get_message_stack(p_msg => x_errorMsg,
240: p_delete_stack => fnd_api.g_false);
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'unexp error: ' || x_errorMsg,
245: x_returnStatus => l_retStatus);
246: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 279: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.getMidPointInfo',

275: l_params(5).paramName := 'p_wipEntityID';
276: l_params(5).paramValue := p_wipEntityID;
277: l_params(6).paramName := 'p_orgID';
278: l_params(6).paramValue := p_orgID;
279: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.getMidPointInfo',
280: p_params => l_params,
281: x_returnStatus => l_retStatus);
282: end if;
283:

Line 429: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;
427:
428: if(l_logLevel <= wip_constants.trace_logging) then
429: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
430: p_procReturnStatus => 'N/A',
431: p_msg => 'success',
432: x_returnStatus => l_retStatus);
433: end if;

Line 556: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

552: l_params(7).paramValue := p_maxSchedSeqNum;
553: l_params(8).ParamName := 'P_quantity';
554: l_params(8).ParamValue := p_quantity;
555:
556: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
557: p_params => l_params,
558: x_returnStatus => l_retStatus);
559: end if;
560: x_returnStatus := fnd_api.g_ret_sts_success;

Line 703: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

699: open c_resInsts;
700: close c_resInsts;
701:
702: if (l_logLevel <= wip_constants.trace_logging) then
703: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
704: p_procReturnStatus => x_returnStatus,
705: p_msg => 'success',
706: x_returnStatus => l_retStatus);
707: end if;

Line 713: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

709: /*Fix bug 8914181 (FP 8894732)*/
710: when wip_constants.records_locked then
711: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
712: if (l_logLevel <= wip_constants.trace_logging) then
713: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
714: p_procReturnStatus => x_returnStatus,
715: p_msg => 'records were locked',
716: x_returnStatus => l_retStatus);
717: end if;

Line 722: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',

718: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');
719: fnd_msg_pub.add;
720: when others then
721: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
722: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
723: p_procedure_name => 'readJobSchedule',
724: p_error_text => SQLERRM);
725: if (l_logLevel <= wip_constants.trace_logging) then
726: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

Line 726: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

722: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
723: p_procedure_name => 'readJobSchedule',
724: p_error_text => SQLERRM);
725: if (l_logLevel <= wip_constants.trace_logging) then
726: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
727: p_procReturnStatus => x_returnStatus,
728: p_msg => 'unexp error: ' || SQLERRM,
729: x_returnStatus => l_retStatus);
730: end if;

Line 795: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

791: for i in 1..p_assignedUnits.count loop
792: l_params(9+i).paramName := 'p_assignedUnits(' || i || ')';
793: l_params(9+i).paramValue := p_assignedUnits(i);
794: end loop;
795: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
796: p_params => l_params,
797: x_returnStatus => l_retStatus);
798: end if;
799: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1181: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

1177: where wip_entity_id = p_wipEntityID
1178: and organization_id = p_orgID;
1179:
1180: if (l_logLevel <= wip_constants.trace_logging) then
1181: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
1182: p_procReturnStatus => x_returnStatus,
1183: p_msg => 'success',
1184: x_returnStatus => l_retStatus);
1185: end if;

Line 1190: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',

1186: exception
1187: when others then
1188: rollback to wipiscdb100;
1189: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1190: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
1191: p_procedure_name => 'writeJobSchedule',
1192: p_error_text => SQLERRM);
1193: if (l_logLevel <= wip_constants.trace_logging) then
1194: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

Line 1194: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

1190: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
1191: p_procedure_name => 'writeJobSchedule',
1192: p_error_text => SQLERRM);
1193: if (l_logLevel <= wip_constants.trace_logging) then
1194: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
1195: p_procReturnStatus => x_returnStatus,
1196: p_msg => 'unexp error: ' || SQLERRM,
1197: x_returnStatus => l_retStatus);
1198: end if;

Line 1202: end wip_infinite_scheduler_pvt;

1198: end if;
1199: end writeJobSchedule;
1200:
1201:
1202: end wip_infinite_scheduler_pvt;