DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_JOBCLOSE_PRIV

Line 1: PACKAGE BODY wip_jobclose_priv AS

1: PACKAGE BODY wip_jobclose_priv AS
2: /* $Header: wipjclpb.pls 120.32.12020000.5 2012/11/27 07:34:57 sisankar ship $ */
3:
4: procedure populate_close_temp
5: (

Line 48: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.populate_close_temp',

44:
45: IF (l_logLevel <= wip_constants.trace_logging) THEN
46: l_params(1).paramName := 'p_organization_id';
47: l_params(1).paramValue := p_organization_id ;
48: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.populate_close_temp',
49: p_params => l_params,
50: x_returnStatus => l_return_Status);
51: END IF;
52:

Line 502: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.time_zone_conversion',

498: l_params(6).paramName := 'p_to_completion_date';
499: l_params(6).paramValue := p_to_completion_date ;
500: l_params(7).paramName := 'p_act_close_date';
501: l_params(7).paramValue := p_act_close_date;
502: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.time_zone_conversion',
503: p_params => l_params,
504: x_returnStatus => l_return_Status);
505: END IF;
506: x_ReturnStatus := fnd_api.g_ret_sts_success ;

Line 661: p_procName => 'wip_jobclose_priv.prior_date_release',

657: l_params(1).paramValue := p_organization_id;
658: l_params(2).paramName := 'p_group_id';
659: l_params(2).paramValue := p_group_id;
660: wip_logger.entryPoint(
661: p_procName => 'wip_jobclose_priv.prior_date_release',
662: p_params => l_params,
663: x_returnStatus => l_return_status);
664: END IF;
665:

Line 805: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_txns',

801: l_params(1).paramName := 'p_organization_id';
802: l_params(1).paramValue := p_organization_id ;
803: l_params(1).paramName := 'p_group_id';
804: l_params(1).paramValue := p_group_id ;
805: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_txns',
806: p_params => l_params,
807: x_returnStatus => l_return_Status);
808: END IF;
809: x_returnStatus := fnd_api.g_ret_sts_success;

Line 952: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_clocks',

948: l_params(1).paramName := 'p_organization_id';
949: l_params(1).paramValue := p_organization_id ;
950: l_params(1).paramName := 'p_group_id';
951: l_params(1).paramValue := p_group_id ;
952: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_clocks',
953: p_params => l_params,
954: x_returnStatus => l_return_Status);
955: END IF;
956: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

Line 1174: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.past_close_date',

1170: l_params(1).paramName := 'p_organization_id';
1171: l_params(1).paramValue := p_organization_id ;
1172: l_params(1).paramName := 'p_group_id';
1173: l_params(1).paramValue := p_group_id ;
1174: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.past_close_date',
1175: p_params => l_params,
1176: x_returnStatus => l_return_Status);
1177: END IF;
1178:

Line 1310: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_open_po',

1306: l_params(1).paramName := 'p_organization_id';
1307: l_params(1).paramValue := p_organization_id ;
1308: l_params(1).paramName := 'p_group_id';
1309: l_params(1).paramValue := p_group_id ;
1310: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_open_po',
1311: p_params => l_params,
1312: x_returnStatus => l_return_Status);
1313: END IF;
1314: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1417: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_delivery_qty',

1413: l_params(1).paramName := 'p_organization_id';
1414: l_params(1).paramValue := p_organization_id ;
1415: l_params(1).paramName := 'p_group_id';
1416: l_params(1).paramValue := p_group_id ;
1417: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_delivery_qty',
1418: p_params => l_params,
1419: x_returnStatus => l_return_Status);
1420: END IF;
1421: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1517: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.lot_validate',

1513: l_params(1).paramName := 'p_organization_id';
1514: l_params(1).paramValue := p_organization_id ;
1515: l_params(1).paramName := 'p_group_id';
1516: l_params(1).paramValue := p_group_id ;
1517: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.lot_validate',
1518: p_params => l_params,
1519: x_returnStatus => l_return_Status);
1520: END IF;
1521:

Line 1549: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',

1545: WHEN others THEN
1546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1547: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1548: IF (l_logLevel <= wip_constants.trace_logging) THEN
1549: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',
1550: p_procReturnStatus => x_returnStatus,
1551: p_msg => l_msg,
1552: x_returnStatus => l_return_Status);
1553: END IF;

Line 1612: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.delete_reservation',

1608: l_params(1).paramName := 'p_organization_id';
1609: l_params(1).paramValue := p_organization_id ;
1610: l_params(1).paramName := 'p_group_id';
1611: l_params(1).paramValue := p_group_id ;
1612: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.delete_reservation',
1613: p_params => l_params,
1614: x_returnStatus => l_return_Status);
1615: END IF;
1616: OPEN C_del_reservation ;

Line 1659: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',

1655: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1656: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1657:
1658: IF (l_logLevel <= wip_constants.trace_logging) THEN
1659: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',
1660: p_procReturnStatus => x_returnStatus,
1661: p_msg => l_msg,
1662: x_returnStatus => l_return_Status);
1663: END IF;

Line 2106: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.wip_close',

2102: l_params(18).paramValue := p_exclude_pending_txn_jobs;
2103: l_params(19).paramName := 'p_report_type';
2104: l_params(19).paramValue := p_report_type;
2105:
2106: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.wip_close',
2107: p_params => l_params,
2108: x_returnStatus => l_return_Status);
2109: END IF;
2110: SAVEPOINT wip_close; --Bug#14285578- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back

Line 2985: END wip_jobclose_priv ;

2981: errbuf := SQLERRM;
2982:
2983: END WIP_CLOSE_MGR ;
2984:
2985: END wip_jobclose_priv ;