APPS.WIP_ATO_JOBS_PRIV dependencies on WIP_ATO_JOBS_PRIV

Line 1: PACKAGE BODY WIP_ATO_JOBS_PRIV AS

1: PACKAGE BODY WIP_ATO_JOBS_PRIV AS
2: /* $Header: wipvfasb.pls 120.11.12020000.3 2013/01/10 10:56:47 abhissri ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 46: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_ATO_JOBS_PRIV';

42: | complete with warning
43: +===========================================================================*/
44:
45: --Global Vars
46: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_ATO_JOBS_PRIV';
47:
48: /*------------------------------------------------------------------+
49: | Local vars |
50: +-------------------------------------------------------------------*/

Line 163: SAVEPOINT WIP_ATO_JOBS_PRIV;

159: l_audsid NUMBER;
160:
161: BEGIN
162: -- Standard Start of API savepoint
163: SAVEPOINT WIP_ATO_JOBS_PRIV;
164:
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 222: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',

218: l_params(10).paramValue := P_BATCH_ID ;
219: l_params(11).paramName := 'P_API_VERSION ';
220: l_params(11).paramValue := P_API_VERSION ;
221:
222: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
223: p_params => l_params,
224: x_returnStatus => x_return_status);
225:
226: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 423: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',

419: end if;
420:
421: -- write to the log file
422: IF (l_logLevel <= wip_constants.trace_logging) THEN
423: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
424: p_procReturnStatus => x_return_Status,
425: p_msg => 'PROCEDURE COMPLETE.',
426: x_returnStatus => l_returnStatus);
427: END IF;

Line 433: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

429: RETCODE := x_return_status;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: GOTO END_program;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 438: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: GOTO END_program;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: GOTO END_program;
441:
442: WHEN OTHERS THEN

Line 443: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: GOTO END_program;
441:
442: WHEN OTHERS THEN
443: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
445: GOTO END_program;
446:
447: <>

Line 647: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',

643: l_params(10).paramValue := P_BATCH_ID ;
644: l_params(11).paramName := 'p_all_success_ptr';
645: l_params(11).paramValue := p_all_success_ptr ;
646:
647: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
648: p_params => l_params,
649: x_returnStatus => l_returnStatus);
650:
651: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

Line 1086: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',

1082:
1083:
1084: -- write to the log file
1085: IF (l_logLevel <= wip_constants.trace_logging) THEN
1086: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
1087: p_procReturnStatus => l_returnStatus,
1088: p_msg => 'PROCEDURE COMPLETE.',
1089: x_returnStatus => l_returnStatus);
1090: END IF;

Line 1150: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',

1146:
1147: if (l_logLevel <= wip_constants.trace_logging) then
1148: l_params(1).paramName := 'p_wei_group_id ';
1149: l_params(1).paramValue := p_wei_group_id ;
1150: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1151: p_params => l_params,
1152: x_returnStatus => x_return_status);
1153:
1154: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 1253: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',

1249: END IF;
1250:
1251: -- write to the log file
1252: IF (l_logLevel <= wip_constants.trace_logging) THEN
1253: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1254: p_procReturnStatus => l_returnStatus,
1255: p_msg => 'PROCEDURE COMPLETE.',
1256: x_returnStatus => l_returnStatus);
1257: END IF;

Line 1279: END WIP_ATO_JOBS_PRIV;

1275: +-------------------------------------------------------------------*/
1276:
1277:
1278:
1279: END WIP_ATO_JOBS_PRIV;
1280: