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_JOBCLOSE_PRIV dependencies on WIP_LOGGER

Line 29: l_params wip_logger.param_tbl_t;

25: x_ReturnStatus OUT NOCOPY VARCHAR2
26: )
27: IS
28:
29: l_params wip_logger.param_tbl_t;
30: l_return_Status VARCHAR2(1);
31: l_msg VARCHAR(240);
32: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
33: l_number_temp NUMBER ;

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 415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);

411: INSERT INTO WIP_DJ_CLOSE_TEMP
412: VALUES l_close_final_tbl(indx);
413: EXCEPTION
414: WHEN ex_dml_errors THEN
415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);
416: FOR i IN 1 ..SQL%BULK_EXCEPTIONS.count LOOP
417: wip_logger.log('wip_entity_id= ' ||l_close_final_tbl(SQL%BULK_EXCEPTIONS(i).error_index).wip_entity_id ||',Error='||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),l_return_status);
418: END LOOP;
419: END;

Line 417: wip_logger.log('wip_entity_id= ' ||l_close_final_tbl(SQL%BULK_EXCEPTIONS(i).error_index).wip_entity_id ||',Error='||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),l_return_status);

413: EXCEPTION
414: WHEN ex_dml_errors THEN
415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);
416: FOR i IN 1 ..SQL%BULK_EXCEPTIONS.count LOOP
417: wip_logger.log('wip_entity_id= ' ||l_close_final_tbl(SQL%BULK_EXCEPTIONS(i).error_index).wip_entity_id ||',Error='||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),l_return_status);
418: END LOOP;
419: END;
420:
421: l_close_temp_tbl1.delete;

Line 436: wip_logger.exitPoint(

432: --
433: -- Bug 5345660 exitPoint for normal exit.
434: --
435: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
436: wip_logger.exitPoint(
437: p_procName => 'wip_close_priv.populate_close_temp',
438: p_procReturnStatus => x_returnStatus,
439: p_msg => 'procedure normal exit',
440: x_returnStatus => l_return_status);

Line 451: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',

447: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
448: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
449:
450: IF (l_logLevel <= wip_constants.trace_logging) THEN
451: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',
452: p_procReturnStatus => x_returnStatus,
453: p_msg => l_msg,
454: x_returnStatus => l_return_Status);
455: END IF;

Line 480: l_params wip_logger.param_tbl_t;

476: x_to_completion_date OUT NOCOPY DATE ,
477: x_act_close_date OUT NOCOPY DATE ,
478: x_returnstatus OUT NOCOPY VARCHAR2
479: )IS
480: l_params wip_logger.param_tbl_t;
481: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
482: l_return_status VARCHAR2(1) ;
483: l_msg_count NUMBER ;
484: l_msg_data VARCHAR2(200);

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 612: wip_logger.exitPoint(

608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
612: wip_logger.exitPoint(
613: p_procName => 'wip_close_priv.time_zone_conversions',
614: p_procReturnStatus => x_returnStatus,
615: p_msg => 'procedure normal exit',
616: x_returnStatus => l_return_status);

Line 624: wip_logger.exitPoint(

620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
621: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
622:
623: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
624: wip_logger.exitPoint(
625: p_procName=>'wip_close_priv.time_zone_conversions',
626: p_procReturnStatus => x_returnStatus,
627: p_msg => l_msg,
628: x_returnStatus => l_return_Status);

Line 647: l_params wip_logger.param_tbl_t;

643:
644: --
645: -- Bug 5148397
646: --
647: l_params wip_logger.param_tbl_t;
648: l_return_status VARCHAR2(1);
649: l_msg VARCHAR(2000);
650: l_failed_counter NUMBER;
651: l_failed_ids dbms_sql.number_table;

Line 660: wip_logger.entryPoint(

656: l_params(1).paramName := 'p_organization_id';
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;

Line 711: wip_logger.exitPoint(

707: --
708: -- Bug 5345660 exitPoint for normal exit.
709: --
710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
711: wip_logger.exitPoint(
712: p_procName => 'wip_close_priv.prior_date_release',
713: p_procReturnStatus => x_returnStatus,
714: p_msg => 'procedure normal exit',
715: x_returnStatus => l_return_status);

Line 724: wip_logger.exitPoint(

720: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
721: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
722:
723: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
724: wip_logger.exitPoint(
725: p_procName=>'wip_close_priv.prior_date_release',
726: p_procReturnStatus => x_returnStatus,
727: p_msg => l_msg,
728: x_returnStatus => l_return_Status);

Line 744: l_params wip_logger.param_tbl_t;

740: p_organization_id IN NUMBER ,
741: p_group_id IN NUMBER
742: )
743: IS
744: l_params wip_logger.param_tbl_t;
745: l_return_Status VARCHAR2(1);
746: l_msg VARCHAR(240);
747: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
748:

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 853: wip_logger.exitPoint(

849: --
850: -- Bug 5345660 exitPoint for normal exit.
851: --
852: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
853: wip_logger.exitPoint(
854: p_procName => 'wip_close_priv.pending_txns',
855: p_procReturnStatus => x_returnStatus,
856: p_msg => 'procedure normal exit',
857: x_returnStatus => l_return_status);

Line 869: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',

865: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
866: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
867:
868: IF (l_logLevel <= wip_constants.trace_logging) THEN
869: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',
870: p_procReturnStatus => x_returnStatus,
871: p_msg => l_msg,
872: x_returnStatus => l_return_Status);
873: END IF;

Line 941: l_params wip_logger.param_tbl_t;

937: and wdct.organization_id = p_organization_id;
938:
939: l_ret_status VARCHAR2(30);
940: l_msg_data VARCHAR2(2000);
941: l_params wip_logger.param_tbl_t;
942: l_return_Status VARCHAR2(1);
943: l_msg VARCHAR(240);
944: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
945: l_failed_counter NUMBER ;

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 995: wip_logger.exitPoint(

991: --
992: -- Bug 5345660 exitPoint for normal exit.
993: --
994: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
995: wip_logger.exitPoint(
996: p_procName => 'wip_close_priv.pending_clocks',
997: p_procReturnStatus => x_returnStatus,
998: p_msg => 'procedure normal exit',
999: x_returnStatus => l_return_status);

Line 1011: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',

1007: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1008: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1009:
1010: IF (l_logLevel <= wip_constants.trace_logging) THEN
1011: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',
1012: p_procReturnStatus => x_returnStatus,
1013: p_msg => l_msg,
1014: x_returnStatus => l_return_Status);
1015: END IF;

Line 1135: l_params wip_logger.param_tbl_t;

1131:
1132: )
1133: IS
1134:
1135: l_params wip_logger.param_tbl_t;
1136: l_return_Status VARCHAR2(1);
1137: l_msg VARCHAR(240);
1138: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1139:

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 1220: wip_logger.exitPoint(

1216: --
1217: -- Bug 5345660 exitPoint for normal exit.
1218: --
1219: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1220: wip_logger.exitPoint(
1221: p_procName => 'wip_close_priv.past_close_date',
1222: p_procReturnStatus => x_returnStatus,
1223: p_msg => 'procedure normal exit',
1224: x_returnStatus => l_return_status);

Line 1235: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',

1231: END IF;
1232: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1233: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1234: IF (l_logLevel <= wip_constants.trace_logging) THEN
1235: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',
1236: p_procReturnStatus => x_returnStatus,
1237: p_msg => l_msg,
1238: x_returnStatus => l_return_Status);
1239: END IF;

Line 1253: l_params wip_logger.param_tbl_t;

1249: p_group_id IN NUMBER
1250: )
1251: IS
1252:
1253: l_params wip_logger.param_tbl_t;
1254: l_return_Status VARCHAR2(1);
1255: l_msg VARCHAR(240);
1256: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1257:

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 1344: wip_logger.exitPoint(

1340: --
1341: -- Bug 5345660 exitPoint for normal exit.
1342: --
1343: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1344: wip_logger.exitPoint(
1345: p_procName => 'wip_close_priv.check_open_po',
1346: p_procReturnStatus => x_returnStatus,
1347: p_msg => 'procedure normal exit',
1348: x_returnStatus => l_return_status);

Line 1360: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',

1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1358:
1359: IF (l_logLevel <= wip_constants.trace_logging) THEN
1360: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',
1361: p_procReturnStatus => x_returnStatus,
1362: p_msg => l_msg,
1363: x_returnStatus => l_return_Status);
1364: END IF;

Line 1380: l_params wip_logger.param_tbl_t;

1376: p_group_id IN NUMBER
1377: )
1378: IS
1379:
1380: l_params wip_logger.param_tbl_t;
1381: l_return_Status VARCHAR2(1);
1382: l_msg VARCHAR(240);
1383: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1384:

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 1466: wip_logger.exitPoint(

1462: CLOSE c_delivered_qty ;
1463: END IF;
1464:
1465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1466: wip_logger.exitPoint(
1467: p_procName => 'wip_close_priv.check_delivery_qty',
1468: p_procReturnStatus => x_returnStatus,
1469: p_msg => 'procedure normal exit',
1470: x_returnStatus => l_return_status);

Line 1482: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_delivery_qty',

1478: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1479: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1480:
1481: IF (l_logLevel <= wip_constants.trace_logging) THEN
1482: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_delivery_qty',
1483: p_procReturnStatus => x_returnStatus,
1484: p_msg => l_msg,
1485: x_returnStatus => l_return_Status);
1486: END IF;

Line 1505: l_params wip_logger.param_tbl_t;

1501: l_error_code number;
1502: l_err_msg varchar2(1000);
1503: l_wsm_org number ;
1504: l_return_status Varchar2(1);
1505: l_params wip_logger.param_tbl_t;
1506: l_msg VARCHAR(240);
1507: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1508:
1509: BEGIN

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 1537: wip_logger.exitPoint(

1533: --
1534: -- Bug 5345660 exitPoint for normal exit.
1535: --
1536: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1537: wip_logger.exitPoint(
1538: p_procName => 'wip_close_priv.lot_validate',
1539: p_procReturnStatus => x_returnStatus,
1540: p_msg => 'procedure normal exit',
1541: x_returnStatus => l_return_status);

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 1569: l_params wip_logger.param_tbl_t;

1565: p_group_id IN NUMBER
1566:
1567: )
1568: IS
1569: l_params wip_logger.param_tbl_t;
1570: l_return_Status VARCHAR2(1);
1571: l_msg VARCHAR(240);
1572: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1573: l_rsv inv_reservation_global.mtl_reservation_rec_type;

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 1643: wip_logger.exitPoint(

1639: --
1640: -- Bug 5345660 exitPoint for normal exit.
1641: --
1642: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1643: wip_logger.exitPoint(
1644: p_procName => 'wip_close_priv.delete_reservation',
1645: p_procReturnStatus => x_returnStatus,
1646: p_msg => 'procedure normal exit',
1647: x_returnStatus => l_return_status);

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 2045: l_params wip_logger.param_tbl_t;

2041: l_msg_count NUMBER;
2042: l_msg_data VARCHAR2(200);
2043: l_msg VARCHAR2(2000);
2044: l_req_id NUMBER;
2045: l_params wip_logger.param_tbl_t;
2046: l_errMsg VARCHAR2(240);
2047: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2048: l_acct_period_close_date DATE; -- Added for bug : 8262844(FP of 8215957)
2049: l_jobs_to_close NUMBER; --fix bug 9250439

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 2137: wip_logger.log(p_msg => 'time zone conversion failed',

2133: x_returnstatus => l_return_status
2134: );
2135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2136: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2137: wip_logger.log(p_msg => 'time zone conversion failed',
2138: x_returnStatus => l_return_Status);
2139: END IF;
2140: RAISE FND_API.G_EXC_ERROR ;
2141: END IF;

Line 2215: wip_logger.log(p_msg => 'populate_close_temp',

2211: x_ReturnStatus => l_return_status
2212: );
2213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2214: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2215: wip_logger.log(p_msg => 'populate_close_temp',
2216: x_returnStatus => l_return_Status);
2217: END IF;
2218: RAISE FND_API.G_EXC_ERROR ;
2219: END IF;

Line 2231: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,

2227: );
2228:
2229: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2231: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
2232: x_returnStatus => l_return_Status);
2233: END IF;
2234: RAISE FND_API.G_EXC_ERROR ;
2235: END IF;

Line 2263: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,

2259: );
2260:
2261: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2262: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2263: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
2264: x_returnStatus => l_return_Status);
2265: END IF;
2266: RAISE FND_API.G_EXC_ERROR ;
2267: END IF;

Line 2315: -- Bug 5345660 Added profile check before invoking wip_logger

2311: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2312: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2313: x_warning := 1 ;
2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger
2316: --
2317: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2318: wip_logger.log(p_msg => l_msg,
2319: x_returnStatus => l_return_Status);

Line 2318: wip_logger.log(p_msg => l_msg,

2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger
2316: --
2317: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2318: wip_logger.log(p_msg => l_msg,
2319: x_returnStatus => l_return_Status);
2320: END IF;
2321: END IF;
2322:

Line 2357: -- Bug 5345660 Added profile check before invoking wip_logger

2353: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2354: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2355: x_warning := 1 ;
2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger
2358: --
2359: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2360: wip_logger.log(p_msg => l_msg,
2361: x_returnStatus => l_return_Status);

Line 2360: wip_logger.log(p_msg => l_msg,

2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger
2358: --
2359: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2360: wip_logger.log(p_msg => l_msg,
2361: x_returnStatus => l_return_Status);
2362: END IF;
2363: END IF;
2364: /**********************************************************

Line 2383: -- Bug 5345660 Added profile check before invoking wip_logger

2379: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2380: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2381: x_warning := 1 ;
2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger
2384: --
2385: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2386: wip_logger.log(p_msg => l_msg,
2387: x_returnStatus => l_return_Status);

Line 2386: wip_logger.log(p_msg => l_msg,

2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger
2384: --
2385: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2386: wip_logger.log(p_msg => l_msg,
2387: x_returnStatus => l_return_Status);
2388: END IF;
2389: END IF;
2390:

Line 2410: -- Bug 5345660 Added profile check before invoking wip_logger

2406: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2407: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2408: x_warning := 1 ;
2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger
2411: --
2412: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2413: wip_logger.log(p_msg => l_msg,
2414: x_returnStatus => l_return_Status);

Line 2413: wip_logger.log(p_msg => l_msg,

2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger
2411: --
2412: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2413: wip_logger.log(p_msg => l_msg,
2414: x_returnStatus => l_return_Status);
2415: END IF;
2416: END IF;
2417:

Line 2436: -- Bug 5345660 Added profile check before invoking wip_logger

2432: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2433: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2434: x_warning := 1 ;
2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger
2437: --
2438: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2439: wip_logger.log(p_msg => l_msg,
2440: x_returnStatus => l_return_Status);

Line 2439: wip_logger.log(p_msg => l_msg,

2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger
2437: --
2438: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2439: wip_logger.log(p_msg => l_msg,
2440: x_returnStatus => l_return_Status);
2441: END IF;
2442: END IF;
2443:

Line 2463: -- Bug 5345660 Added profile check before invoking wip_logger

2459: x_warning := 1 ;
2460: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
2461: l_msg := fnd_message.get;
2462: --
2463: -- Bug 5345660 Added profile check before invoking wip_logger
2464: --
2465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2466: wip_logger.log(p_msg => l_msg,
2467: x_returnStatus => l_return_Status);

Line 2466: wip_logger.log(p_msg => l_msg,

2462: --
2463: -- Bug 5345660 Added profile check before invoking wip_logger
2464: --
2465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2466: wip_logger.log(p_msg => l_msg,
2467: x_returnStatus => l_return_Status);
2468: END IF;
2469: END IF;
2470: END IF ;

Line 2489: wip_logger.log(p_msg => 'CHECK_DELIVERY_QTY procedure failed',

2485: x_warning := 1 ;
2486: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED');
2487: l_msg := fnd_message.get;
2488: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2489: wip_logger.log(p_msg => 'CHECK_DELIVERY_QTY procedure failed',
2490: x_returnStatus => l_return_Status);
2491: END IF;
2492: END IF;
2493:

Line 2506: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',

2502: p_organization_id => p_organization_id,
2503: p_group_id => l_group_id );
2504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2505: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2506: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2507: x_returnStatus => l_return_Status);
2508: END IF;
2509: RAISE FND_API.G_EXC_ERROR ;
2510: END IF;

Line 2526: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',

2522: p_group_id => l_group_id );
2523:
2524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2525: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2526: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2527: x_returnStatus => l_return_Status);
2528: END IF;
2529: END IF;
2530:

Line 2676: wip_logger.log(p_msg => 'costing function error',

2672: );
2673: -- Bug 5370550
2674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2675: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2676: wip_logger.log(p_msg => 'costing function error',
2677: x_returnStatus => l_return_Status);
2678: END IF;
2679: RAISE FND_API.G_EXC_ERROR ;
2680: END IF;

Line 2695: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,

2691: );
2692:
2693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2695: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2696: x_returnStatus => l_return_Status);
2697: END IF;
2698: RAISE FND_API.G_EXC_ERROR ;
2699: END IF;

Line 2711: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,

2707: );
2708:
2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2711: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2712: x_returnStatus => l_return_Status);
2713: END IF;
2714: RAISE FND_API.G_EXC_ERROR ;
2715: END IF;

Line 2822: wip_logger.exitPoint(

2818: --
2819: -- Bug 5345660 exitPoint for normal exit.
2820: --
2821: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2822: wip_logger.exitPoint(
2823: p_procName => 'wip_close_priv.wip_close',
2824: p_procReturnStatus => x_returnStatus,
2825: p_msg => 'procedure normal exit',
2826: x_returnStatus => l_return_status);

Line 2849: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,

2845: );
2846:
2847: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2848: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2849: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2850: x_returnStatus => l_return_Status);
2851: END IF;
2852: RAISE FND_API.G_EXC_ERROR ;
2853: END IF;

Line 2865: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,

2861: );
2862:
2863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2864: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2865: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2866: x_returnStatus => l_return_Status);
2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR ;
2869: END IF;

Line 2896: wip_logger.exitPoint(

2892: -- Bug 5345660 exitPoint for exception exit.
2893: --
2894: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2895: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2896: wip_logger.exitPoint(
2897: p_procName => 'wip_close_priv.wip_close',
2898: p_procReturnStatus => x_returnStatus,
2899: p_msg => l_msg,
2900: x_returnStatus => l_return_status);