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.8 2006/05/04 14:22 rekannan noship $ */
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 107: SAVEPOINT WIP_ATO_JOBS_PRIV;

103: l_audsid NUMBER;
104:
105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT WIP_ATO_JOBS_PRIV;
108:
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

153: l_params(10).paramValue := P_BATCH_ID ;
154: l_params(11).paramName := 'P_API_VERSION ';
155: l_params(11).paramValue := P_API_VERSION ;
156:
157: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
158: p_params => l_params,
159: x_returnStatus => x_return_status);
160:
161: if(x_return_status <> fnd_api.g_ret_sts_success) then

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

340: end if;
341:
342: -- write to the log file
343: IF (l_logLevel <= wip_constants.trace_logging) THEN
344: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
345: p_procReturnStatus => x_return_Status,
346: p_msg => 'PROCEDURE COMPLETE.',
347: x_returnStatus => l_returnStatus);
348: END IF;

Line 354: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

350: RETCODE := x_return_status;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: GOTO END_program;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 359: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: GOTO END_program;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: GOTO END_program;
362:
363: WHEN OTHERS THEN

Line 364: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;

360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: GOTO END_program;
362:
363: WHEN OTHERS THEN
364: -- ROLLBACK TO SAVEPOINT WIP_ATO_JOBS_PRIV;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: GOTO END_program;
367:
368: <>

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

557: l_params(10).paramValue := P_BATCH_ID ;
558: l_params(11).paramName := 'p_all_success_ptr';
559: l_params(11).paramValue := p_all_success_ptr ;
560:
561: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
562: p_params => l_params,
563: x_returnStatus => l_returnStatus);
564:
565: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

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

931:
932:
933: -- write to the log file
934: IF (l_logLevel <= wip_constants.trace_logging) THEN
935: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
936: p_procReturnStatus => l_returnStatus,
937: p_msg => 'PROCEDURE COMPLETE.',
938: x_returnStatus => l_returnStatus);
939: END IF;

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

995:
996: if (l_logLevel <= wip_constants.trace_logging) then
997: l_params(1).paramName := 'p_wei_group_id ';
998: l_params(1).paramValue := p_wei_group_id ;
999: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1000: p_params => l_params,
1001: x_returnStatus => x_return_status);
1002:
1003: if(x_return_status <> fnd_api.g_ret_sts_success) then

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

1086: END IF;
1087:
1088: -- write to the log file
1089: IF (l_logLevel <= wip_constants.trace_logging) THEN
1090: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1091: p_procReturnStatus => l_returnStatus,
1092: p_msg => 'PROCEDURE COMPLETE.',
1093: x_returnStatus => l_returnStatus);
1094: END IF;

Line 1116: END WIP_ATO_JOBS_PRIV;

1112: +-------------------------------------------------------------------*/
1113:
1114:
1115:
1116: END WIP_ATO_JOBS_PRIV;
1117: