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 FND_API

Line 42: x_returnStatus := fnd_api.g_ret_sts_success;

38: ex_dml_errors EXCEPTION;
39: PRAGMA EXCEPTION_INIT(ex_dml_errors, -24381);
40:
41: BEGIN
42: x_returnStatus := fnd_api.g_ret_sts_success;
43: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');
44:
45: IF (l_logLevel <= wip_constants.trace_logging) THEN
46: l_params(1).paramName := 'p_organization_id';

Line 447: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

443: /* Handling Exceptions */
444:
445: EXCEPTION
446: WHEN others THEN
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',

Line 506: x_ReturnStatus := fnd_api.g_ret_sts_success ;

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 ;
507: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
508:
509: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
510:

Line 620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

616: x_returnStatus => l_return_status);
617: END IF;
618: EXCEPTION
619: WHEN others THEN
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(

Line 690: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

686:
687: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed because release date before close date : '|| to_char(l_failed_counter));
688:
689: IF l_failed_counter = 0 THEN
690: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
691: ELSE
692: --
693: -- Some invalid jobs found. Set expected error flag and
694: -- update wip_discrete_jobs' status_type to fail_close.

Line 696: x_returnstatus := FND_API.G_RET_STS_ERROR;

692: --
693: -- Some invalid jobs found. Set expected error flag and
694: -- update wip_discrete_jobs' status_type to fail_close.
695: --
696: x_returnstatus := FND_API.G_RET_STS_ERROR;
697:
698: FORALL i IN l_failed_ids.FIRST .. l_failed_ids.LAST
699: UPDATE wip_discrete_jobs
700: SET status_type = WIP_CONSTANTS.FAIL_CLOSE

Line 720: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

716: END IF;
717:
718: EXCEPTION
719: WHEN others THEN
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(

Line 809: x_returnStatus := fnd_api.g_ret_sts_success;

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;
810: l_failed_counter := 0 ;
811: fnd_file.put_line(FND_FILE.LOG,'Pending Txns Check');
812:
813: OPEN c_pending_txns ;

Line 818: x_returnStatus := FND_API.G_RET_STS_ERROR ;

814: LOOP
815: FETCH c_pending_txns INTO l_failed_jobs ;
816: if (c_pending_txns%FOUND) then
817: l_failed_counter := l_failed_counter + 1 ;
818: x_returnStatus := FND_API.G_RET_STS_ERROR ;
819: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
820: end if ;
821:
822: UPDATE WIP_DJ_CLOSE_TEMP

Line 865: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

861: WHEN others THEN
862: IF (c_pending_txns%ISOPEN) THEN
863: CLOSE c_pending_txns ;
864: END IF;
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',

Line 902: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

898: l_msg_data VARCHAR2(2000);
899: l_ret_exp_status boolean := true;
900:
901: BEGIN
902: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
903:
904: for l_jobRec in c_jobs loop
905: l_ret_exp_status :=
906: wip_ws_exceptions.close_exception_job

Line 915: x_returnstatus := FND_API.G_RET_STS_ERROR;

911: UPDATE WIP_DJ_CLOSE_TEMP
912: SET STATUS_TYPE = 99
913: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
914:
915: x_returnstatus := FND_API.G_RET_STS_ERROR;
916: END IF;
917: end loop;
918:
919: END CLOSE_JOB_EXCEPTIONS ;

Line 956: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

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;
957: l_failed_counter := 0;
958:
959: for l_jobRec in c_jobs loop
960: l_ret_status :=

Line 971: x_returnstatus := FND_API.G_RET_STS_ERROR;

967: SET STATUS_TYPE = 99
968: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
969: l_failed_counter := l_failed_counter + 1 ;
970: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
971: x_returnstatus := FND_API.G_RET_STS_ERROR;
972: END IF;
973: end loop;
974:
975: UPDATE WIP_DISCRETE_JOBS

Line 1007: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1003: WHEN others THEN
1004: IF (c_jobs%ISOPEN) THEN
1005: CLOSE c_jobs ;
1006: END IF;
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',

Line 1053: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then

1049: p_wip_entity_type => l_jobRec.entity_type,
1050: x_return_status => l_ret_status,
1051: x_msg_data => l_msg_data);
1052: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
1053: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
1054: UPDATE WIP_DJ_CLOSE_TEMP
1055: SET STATUS_TYPE = 99
1056: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
1057: l_failed_counter := l_failed_counter + 1 ;

Line 1059: x_returnstatus := FND_API.G_RET_STS_ERROR;

1055: SET STATUS_TYPE = 99
1056: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
1057: l_failed_counter := l_failed_counter + 1 ;
1058: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
1059: x_returnstatus := FND_API.G_RET_STS_ERROR;
1060: END IF;
1061: end loop;
1062:
1063: UPDATE WIP_DISCRETE_JOBS

Line 1166: x_returnStatus := fnd_api.g_ret_sts_success;

1162: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1163: l_failed_counter NUMBER ;
1164: BEGIN
1165: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
1166: x_returnStatus := fnd_api.g_ret_sts_success;
1167: l_failed_counter := 0 ;
1168:
1169: IF (l_logLevel <= wip_constants.trace_logging) THEN
1170: l_params(1).paramName := 'p_organization_id';

Line 1185: x_returnstatus := FND_API.G_RET_STS_ERROR ;

1181: FETCH c_pending_txns INTO l_failed_jobs ;
1182: if (c_pending_txns%FOUND) then
1183: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
1184: l_failed_counter := l_failed_counter + 1 ;
1185: x_returnstatus := FND_API.G_RET_STS_ERROR ;
1186: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1187: end if ;
1188:
1189: UPDATE WIP_DJ_CLOSE_TEMP

Line 1232: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1228: WHEN others THEN
1229: IF (c_pending_txns%ISOPEN) THEN
1230: CLOSE c_pending_txns ;
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,

Line 1314: x_returnStatus := fnd_api.g_ret_sts_success;

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;
1315: l_failed_counter := 0 ;
1316:
1317: OPEN c_open_po ;
1318: LOOP

Line 1323: x_returnStatus := fnd_api.g_ret_sts_error;

1319: FETCH c_open_po INTO l_failed_jobs ;
1320: if (c_open_po%FOUND) then
1321: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1322: l_failed_counter := l_failed_counter + 1 ;
1323: x_returnStatus := fnd_api.g_ret_sts_error;
1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1325: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1326: l_msg := fnd_message.get;
1327: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

Line 1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1352: WHEN others THEN
1353: IF (c_open_po%ISOPEN) THEN
1354: CLOSE c_open_po ;
1355: END IF;
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',

Line 1421: x_returnStatus := fnd_api.g_ret_sts_success;

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;
1422: l_failed_counter := 0 ;
1423:
1424: OPEN c_delivered_qty ;
1425: LOOP

Line 1430: x_returnStatus := fnd_api.g_ret_sts_error;

1426: FETCH c_delivered_qty INTO l_failed_jobs ;
1427: if (c_delivered_qty%FOUND) then
1428: fnd_file.put_line(FND_FILE.LOG,'Quantity delivered less than Quantity received');
1429: l_failed_counter := l_failed_counter + 1 ;
1430: x_returnStatus := fnd_api.g_ret_sts_error;
1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1432: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED'); /*Bug 9877786(FP of 9791544)*/
1433: l_msg := fnd_message.get;
1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

Line 1478: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1474: WHEN others THEN
1475: IF (c_delivered_qty%ISOPEN) THEN
1476: CLOSE c_delivered_qty ;
1477: END IF;
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',

Line 1510: x_returnStatus := fnd_api.g_ret_sts_success;

1506: l_msg VARCHAR(240);
1507: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1508:
1509: BEGIN
1510: x_returnStatus := fnd_api.g_ret_sts_success;
1511: fnd_file.put_line(FND_FILE.LOG,'lot validate');
1512: IF (l_logLevel <= wip_constants.trace_logging) THEN
1513: l_params(1).paramName := 'p_organization_id';
1514: l_params(1).paramValue := p_organization_id ;

Line 1546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1542: END IF;
1543:
1544: EXCEPTION
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,

Line 1604: x_returnStatus := fnd_api.g_ret_sts_success;

1600: and ool.line_id = mr.demand_source_line_id; -- otimizacao
1601:
1602: /* end of fix 8681037 (FP 8461467) */
1603: BEGIN
1604: x_returnStatus := fnd_api.g_ret_sts_success;
1605: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');
1606:
1607: IF (l_logLevel <= wip_constants.trace_logging) THEN
1608: l_params(1).paramName := 'p_organization_id';

Line 1626: , p_init_msg_lst => fnd_api.g_true

1622: /* Inventory Call for deleting reservations */
1623: inv_reservation_pub.delete_reservation
1624: (
1625: p_api_version_number => 1.0
1626: , p_init_msg_lst => fnd_api.g_true
1627: , x_return_status => l_status
1628: , x_msg_count => l_msg_count
1629: , x_msg_data => l_msg
1630: , p_rsv_rec => l_rsv

Line 1655: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1651: WHEN others THEN
1652: IF (c_del_reservation%ISOPEN) THEN
1653: CLOSE c_del_reservation ;
1654: END IF;
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',

Line 1757: x_ReturnStatus := fnd_api.g_ret_sts_success;

1753:
1754: BEGIN
1755: fnd_file.put_line(FND_FILE.LOG,'Running Reports.........');
1756:
1757: x_ReturnStatus := fnd_api.g_ret_sts_success;
1758: SORT_BY_JOB := 1 ;
1759: l_report_type := p_report_type ;
1760: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');
1761:

Line 1927: raise FND_API.G_EXC_ERROR ;

1923:
1924: if (retcode <> -1 ) then
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1926: errbuf := fnd_message.get;
1927: raise FND_API.G_EXC_ERROR ;
1928: end if;
1929:
1930: END IF ;
1931:

Line 1979: raise FND_API.G_EXC_ERROR ;

1975:
1976: if (retcode <> -1 ) then
1977: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1978: errbuf := fnd_message.get;
1979: raise FND_API.G_EXC_ERROR ;
1980: end if;
1981:
1982: END IF ; -- Expense Reports End
1983:

Line 1986: x_ReturnStatus := FND_API.G_RET_STS_ERROR;

1982: END IF ; -- Expense Reports End
1983:
1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: x_ReturnStatus := FND_API.G_RET_STS_ERROR;
1987: END RUN_REPORTS;
1988:
1989:
1990:

Line 2057: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;

2053: BEGIN
2054:
2055: l_at_submission_time := 1 ; ---SRS
2056: l_immediate := 2 ; -- From Close Form
2057: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
2058:
2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
2060:
2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

Line 2135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2131: x_to_completion_date => l_to_completion_date ,
2132: x_act_close_date => l_act_close_date ,
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;

Line 2140: RAISE FND_API.G_EXC_ERROR ;

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;
2142:
2143: if ( sysdate > l_act_close_date ) then
2144: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE CLOSE');

Line 2156: RAISE FND_API.G_EXC_ERROR ;

2152: l_msg := fnd_message.get;
2153: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2154: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2155: fnd_file.put_line(FND_FILE.LOG,l_msg);
2156: RAISE FND_API.G_EXC_ERROR ;
2157: end if ;
2158:
2159: /****************************************************************
2160: * *

Line 2181: RAISE FND_API.G_EXC_ERROR ;

2177: l_msg := fnd_message.get;
2178: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2179: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2180: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
2181: RAISE FND_API.G_EXC_ERROR ;
2182: END ;
2183:
2184: /**********************************************************
2185: * *

Line 2213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2209: p_act_close_date => l_act_close_date ,
2210: x_group_id => l_group_id ,
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;

Line 2218: RAISE FND_API.G_EXC_ERROR ;

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;
2220:
2221: /*Bug 6908428: Raise workflow notifications for eam workorders for status change to Pending close */
2222: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(

Line 2229: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2225: ERRBUF => l_errMsg ,
2226: RETCODE => l_return_status
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;

Line 2234: RAISE FND_API.G_EXC_ERROR ;

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;
2236: /*Bug 6908428*/
2237:
2238: UPDATE wip_discrete_jobs

Line 2261: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2257: ERRBUF => l_errMsg,
2258: RETCODE => l_return_status
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;

Line 2266: RAISE FND_API.G_EXC_ERROR ;

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;
2268:
2269: /*Bug 6908428*/
2270:

Line 2308: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2304: x_returnstatus => l_return_status,
2305: p_organization_id => p_organization_id,
2306: p_group_id => l_group_id);
2307:
2308: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2309: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
2310: l_msg := fnd_message.get;
2311: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2312: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2334: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2330: x_returnstatus => l_return_status,
2331: p_organization_id => p_organization_id,
2332: p_group_id => l_group_id);
2333:
2334: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2335: x_warning := 1 ;
2336: END IF;
2337:
2338: /**********************************************************

Line 2350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2346: x_returnstatus => l_return_status,
2347: p_organization_id => p_organization_id,
2348: p_group_id => l_group_id);
2349:
2350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2351: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
2352: l_msg := fnd_message.get;
2353: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2354: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2376: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2372: CANCEL_MOVE_ORDERS(
2373: x_returnstatus => l_return_status,
2374: p_organization_id => p_organization_id,
2375: p_group_id => l_group_id);
2376: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2377: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2378: l_msg := fnd_message.get;
2379: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2380: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2403: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2399: x_returnstatus => l_return_status,
2400: p_organization_id => p_organization_id,
2401: p_group_id => l_group_id);
2402:
2403: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2404: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2405: l_msg := fnd_message.get;
2406: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2407: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2429: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2425: x_returnstatus => l_return_status,
2426: p_organization_id => p_organization_id,
2427: p_group_id => l_group_id);
2428:
2429: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2430: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
2431: l_msg := fnd_message.get;
2432: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2433: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2458: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

2454: x_returnstatus => l_return_status,
2455: p_organization_id => p_organization_id,
2456: p_group_id => l_group_id);
2457:
2458: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2459: x_warning := 1 ;
2460: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
2461: l_msg := fnd_message.get;
2462: --

Line 2483: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2479: x_returnstatus => l_return_status,
2480: p_organization_id => p_organization_id,
2481: p_group_id => l_group_id);
2482:
2483: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2484: /*Bug 13625290*/
2485: x_warning := 1 ;
2486: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED');
2487: l_msg := fnd_message.get;

Line 2504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2500: LOT_VALIDATE(
2501: x_returnstatus => l_return_status,
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;

Line 2509: RAISE FND_API.G_EXC_ERROR ;

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;
2511:
2512: /**********************************************************
2513: * *

Line 2524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2520: x_returnstatus => l_return_status,
2521: p_organization_id => p_organization_id,
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;

Line 2582: RAISE FND_API.G_EXC_ERROR ;

2578: P_ret_code => l_ret_code ,
2579: P_err_buf => l_errMsg );
2580:
2581: IF (l_ret_code <> 0 ) THEN
2582: RAISE FND_API.G_EXC_ERROR ;
2583: END IF;
2584:
2585:
2586: /*****************************************

Line 2659: p_init_msg_list => FND_API.G_FALSE,

2655:
2656: CST_JobCloseVar_GRP.Calculate_Job_Variance
2657: (
2658: p_api_version => 1.0,
2659: p_init_msg_list => FND_API.G_FALSE,
2660: p_commit => FND_API.G_FALSE,
2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2662: x_return_status => l_return_status,
2663: x_msg_count => l_msg_count,

Line 2660: p_commit => FND_API.G_FALSE,

2656: CST_JobCloseVar_GRP.Calculate_Job_Variance
2657: (
2658: p_api_version => 1.0,
2659: p_init_msg_list => FND_API.G_FALSE,
2660: p_commit => FND_API.G_FALSE,
2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2662: x_return_status => l_return_status,
2663: x_msg_count => l_msg_count,
2664: x_msg_data => l_msg_data,

Line 2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

2657: (
2658: p_api_version => 1.0,
2659: p_init_msg_list => FND_API.G_FALSE,
2660: p_commit => FND_API.G_FALSE,
2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2662: x_return_status => l_return_status,
2663: x_msg_count => l_msg_count,
2664: x_msg_data => l_msg_data,
2665: p_user_id => fnd_global.user_id,

Line 2674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2670: p_wcti_group_id => l_costing_group_id,
2671: p_org_id => p_organization_id
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;

Line 2679: RAISE FND_API.G_EXC_ERROR ;

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;
2681:
2682:
2683: /* Closing the jobs */

Line 2693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2689: ERRBUF => l_errMsg,
2690: RETCODE => l_return_Status
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;

Line 2698: RAISE FND_API.G_EXC_ERROR ;

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;
2700:
2701: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2702: p_group_id => l_group_id,

Line 2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2705: ERRBUF => l_errMsg,
2706: RETCODE => l_return_status
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;

Line 2714: RAISE FND_API.G_EXC_ERROR ;

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;
2716:
2717: /*Bug 6908428*/
2718:

Line 2786: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN

2782: p_from_job => p_from_job ,
2783: p_to_job => p_to_job ,
2784: p_status => p_status);
2785:
2786: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2787: x_warning := 1 ;
2788: END IF;
2789:
2790:

Line 2836: x_returnStatus := FND_API.G_RET_STS_ERROR ;

2832: WHEN others THEN
2833: rollback TO wip_close;--Bug#13639508- Rollback to the savepoint so that insertion into wip_dj_close_temp is not rolled back
2834:
2835: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');
2836: x_returnStatus := FND_API.G_RET_STS_ERROR ;
2837: /* Update jobs to Failed Close status */
2838:
2839: /*Bug 6908428: Update the status of eam_work_order_details to failed close and proceed workflow notification*/
2840: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(

Line 2847: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2843: ERRBUF => l_errMsg,
2844: RETCODE => l_return_Status
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;

Line 2852: RAISE FND_API.G_EXC_ERROR ;

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;
2854:
2855: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2856: p_group_id => l_group_id,

Line 2863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2859: ERRBUF => l_errMsg,
2860: RETCODE => l_return_status
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;

Line 2868: RAISE FND_API.G_EXC_ERROR ;

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;
2870:
2871: /*Bug 6908428*/
2872:

Line 2973: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN

2969: retcode := 1 ; -- warning ;
2970: wip_utilities.get_message_stack(p_msg =>errbuf);
2971: END IF ;
2972:
2973: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2974: retcode := 2; -- error
2975: wip_utilities.get_message_stack(p_msg =>errbuf);
2976: END IF;
2977: