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 35: x_returnStatus := fnd_api.g_ret_sts_success;

31: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
32: l_number_temp NUMBER ;
33:
34: BEGIN
35: x_returnStatus := fnd_api.g_ret_sts_success;
36: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');
37:
38: IF (l_logLevel <= wip_constants.trace_logging) THEN
39: l_params(1).paramName := 'p_organization_id';

Line 184: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

180: /* Handling Exceptions */
181:
182: EXCEPTION
183: WHEN others THEN
184: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
185: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
186:
187: IF (l_logLevel <= wip_constants.trace_logging) THEN
188: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',

Line 241: x_ReturnStatus := fnd_api.g_ret_sts_success ;

237: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.time_zone_conversion',
238: p_params => l_params,
239: x_returnStatus => l_return_Status);
240: END IF;
241: x_ReturnStatus := fnd_api.g_ret_sts_success ;
242: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
243:
244: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
245:

Line 353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

349: x_returnStatus => l_return_status);
350: END IF;
351: EXCEPTION
352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
355:
356: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
357: wip_logger.exitPoint(

Line 423: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

419:
420: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed because release date before close date : '|| to_char(l_failed_counter));
421:
422: IF l_failed_counter = 0 THEN
423: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
424: ELSE
425: --
426: -- Some invalid jobs found. Set expected error flag and
427: -- update wip_discrete_jobs' status_type to fail_close.

Line 429: x_returnstatus := FND_API.G_RET_STS_ERROR;

425: --
426: -- Some invalid jobs found. Set expected error flag and
427: -- update wip_discrete_jobs' status_type to fail_close.
428: --
429: x_returnstatus := FND_API.G_RET_STS_ERROR;
430:
431: FORALL i IN l_failed_ids.FIRST .. l_failed_ids.LAST
432: UPDATE wip_discrete_jobs
433: SET status_type = WIP_CONSTANTS.FAIL_CLOSE

Line 453: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

449: END IF;
450:
451: EXCEPTION
452: WHEN others THEN
453: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
454: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
455:
456: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
457: wip_logger.exitPoint(

Line 542: x_returnStatus := fnd_api.g_ret_sts_success;

538: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_txns',
539: p_params => l_params,
540: x_returnStatus => l_return_Status);
541: END IF;
542: x_returnStatus := fnd_api.g_ret_sts_success;
543: l_failed_counter := 0 ;
544: fnd_file.put_line(FND_FILE.LOG,'Pending Txns Check');
545:
546: OPEN c_pending_txns ;

Line 551: x_returnStatus := FND_API.G_RET_STS_ERROR ;

547: LOOP
548: FETCH c_pending_txns INTO l_failed_jobs ;
549: if (c_pending_txns%FOUND) then
550: l_failed_counter := l_failed_counter + 1 ;
551: x_returnStatus := FND_API.G_RET_STS_ERROR ;
552: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
553: end if ;
554:
555: UPDATE WIP_DJ_CLOSE_TEMP

Line 598: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

594: WHEN others THEN
595: IF (c_pending_txns%ISOPEN) THEN
596: CLOSE c_pending_txns ;
597: END IF;
598: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
599: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
600:
601: IF (l_logLevel <= wip_constants.trace_logging) THEN
602: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',

Line 635: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

631: l_msg_data VARCHAR2(2000);
632: l_ret_exp_status boolean := true;
633:
634: BEGIN
635: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
636:
637: for l_jobRec in c_jobs loop
638: l_ret_exp_status :=
639: wip_ws_exceptions.close_exception_job

Line 648: x_returnstatus := FND_API.G_RET_STS_ERROR;

644: UPDATE WIP_DJ_CLOSE_TEMP
645: SET STATUS_TYPE = 99
646: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
647:
648: x_returnstatus := FND_API.G_RET_STS_ERROR;
649: END IF;
650: end loop;
651:
652: END CLOSE_JOB_EXCEPTIONS ;

Line 689: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

685: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_clocks',
686: p_params => l_params,
687: x_returnStatus => l_return_Status);
688: END IF;
689: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
690: l_failed_counter := 0;
691:
692: for l_jobRec in c_jobs loop
693: l_ret_status :=

Line 704: x_returnstatus := FND_API.G_RET_STS_ERROR;

700: SET STATUS_TYPE = 99
701: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
702: l_failed_counter := l_failed_counter + 1 ;
703: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
704: x_returnstatus := FND_API.G_RET_STS_ERROR;
705: END IF;
706: end loop;
707:
708: UPDATE WIP_DISCRETE_JOBS

Line 740: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

736: WHEN others THEN
737: IF (c_jobs%ISOPEN) THEN
738: CLOSE c_jobs ;
739: END IF;
740: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
741: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
742:
743: IF (l_logLevel <= wip_constants.trace_logging) THEN
744: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',

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

782: p_wip_entity_type => l_jobRec.entity_type,
783: x_return_status => l_ret_status,
784: x_msg_data => l_msg_data);
785: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
786: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
787: UPDATE WIP_DJ_CLOSE_TEMP
788: SET STATUS_TYPE = 99
789: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
790: l_failed_counter := l_failed_counter + 1 ;

Line 792: x_returnstatus := FND_API.G_RET_STS_ERROR;

788: SET STATUS_TYPE = 99
789: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
790: l_failed_counter := l_failed_counter + 1 ;
791: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
792: x_returnstatus := FND_API.G_RET_STS_ERROR;
793: END IF;
794: end loop;
795:
796: UPDATE WIP_DISCRETE_JOBS

Line 899: x_returnStatus := fnd_api.g_ret_sts_success;

895: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
896: l_failed_counter NUMBER ;
897: BEGIN
898: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
899: x_returnStatus := fnd_api.g_ret_sts_success;
900: l_failed_counter := 0 ;
901:
902: IF (l_logLevel <= wip_constants.trace_logging) THEN
903: l_params(1).paramName := 'p_organization_id';

Line 918: x_returnstatus := FND_API.G_RET_STS_ERROR ;

914: FETCH c_pending_txns INTO l_failed_jobs ;
915: if (c_pending_txns%FOUND) then
916: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
917: l_failed_counter := l_failed_counter + 1 ;
918: x_returnstatus := FND_API.G_RET_STS_ERROR ;
919: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
920: end if ;
921:
922: UPDATE WIP_DJ_CLOSE_TEMP

Line 965: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

961: WHEN others THEN
962: IF (c_pending_txns%ISOPEN) THEN
963: CLOSE c_pending_txns ;
964: END IF;
965: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
966: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
967: IF (l_logLevel <= wip_constants.trace_logging) THEN
968: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',
969: p_procReturnStatus => x_returnStatus,

Line 1046: x_returnStatus := fnd_api.g_ret_sts_success;

1042: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_open_po',
1043: p_params => l_params,
1044: x_returnStatus => l_return_Status);
1045: END IF;
1046: x_returnStatus := fnd_api.g_ret_sts_success;
1047: l_failed_counter := 0 ;
1048:
1049: OPEN c_open_po ;
1050: LOOP

Line 1055: x_returnStatus := fnd_api.g_ret_sts_error;

1051: FETCH c_open_po INTO l_failed_jobs ;
1052: if (c_open_po%FOUND) then
1053: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1054: l_failed_counter := l_failed_counter + 1 ;
1055: x_returnStatus := fnd_api.g_ret_sts_error;
1056: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1057: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1058: l_msg := fnd_message.get;
1059: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

Line 1088: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1084: WHEN others THEN
1085: IF (c_open_po%ISOPEN) THEN
1086: CLOSE c_open_po ;
1087: END IF;
1088: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1089: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1090:
1091: IF (l_logLevel <= wip_constants.trace_logging) THEN
1092: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',

Line 1120: x_returnStatus := fnd_api.g_ret_sts_success;

1116: l_msg VARCHAR(240);
1117: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1118:
1119: BEGIN
1120: x_returnStatus := fnd_api.g_ret_sts_success;
1121: fnd_file.put_line(FND_FILE.LOG,'lot validate');
1122: IF (l_logLevel <= wip_constants.trace_logging) THEN
1123: l_params(1).paramName := 'p_organization_id';
1124: l_params(1).paramValue := p_organization_id ;

Line 1156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1152: END IF;
1153:
1154: EXCEPTION
1155: WHEN others THEN
1156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1157: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1158: IF (l_logLevel <= wip_constants.trace_logging) THEN
1159: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',
1160: p_procReturnStatus => x_returnStatus,

Line 1197: x_returnStatus := fnd_api.g_ret_sts_success;

1193: AND wdct.group_id = p_group_id
1194: AND wdct.wip_entity_id = wrv.wip_entity_id;
1195:
1196: BEGIN
1197: x_returnStatus := fnd_api.g_ret_sts_success;
1198: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');
1199:
1200: IF (l_logLevel <= wip_constants.trace_logging) THEN
1201: l_params(1).paramName := 'p_organization_id';

Line 1218: , p_init_msg_lst => fnd_api.g_true

1214: /* Inventory Call for deleting reservations */
1215: inv_reservation_pub.delete_reservation
1216: (
1217: p_api_version_number => 1.0
1218: , p_init_msg_lst => fnd_api.g_true
1219: , x_return_status => l_status
1220: , x_msg_count => l_msg_count
1221: , x_msg_data => l_msg
1222: , p_rsv_rec => l_rsv

Line 1248: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1244: WHEN others THEN
1245: IF (c_del_reservation%ISOPEN) THEN
1246: CLOSE c_del_reservation ;
1247: END IF;
1248: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1249: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1250:
1251: IF (l_logLevel <= wip_constants.trace_logging) THEN
1252: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',

Line 1350: x_ReturnStatus := fnd_api.g_ret_sts_success;

1346:
1347: BEGIN
1348: fnd_file.put_line(FND_FILE.LOG,'Running Reports.........');
1349:
1350: x_ReturnStatus := fnd_api.g_ret_sts_success;
1351: SORT_BY_JOB := 1 ;
1352: l_report_type := p_report_type ;
1353: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');
1354:

Line 1520: raise FND_API.G_EXC_ERROR ;

1516:
1517: if (retcode <> -1 ) then
1518: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1519: errbuf := fnd_message.get;
1520: raise FND_API.G_EXC_ERROR ;
1521: end if;
1522:
1523: END IF ;
1524:

Line 1572: raise FND_API.G_EXC_ERROR ;

1568:
1569: if (retcode <> -1 ) then
1570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1571: errbuf := fnd_message.get;
1572: raise FND_API.G_EXC_ERROR ;
1573: end if;
1574:
1575: END IF ; -- Expense Reports End
1576:

Line 1579: x_ReturnStatus := FND_API.G_RET_STS_ERROR;

1575: END IF ; -- Expense Reports End
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: x_ReturnStatus := FND_API.G_RET_STS_ERROR;
1580: END RUN_REPORTS;
1581:
1582:
1583:

Line 1646: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;

1642: BEGIN
1643:
1644: l_at_submission_time := 1 ; ---SRS
1645: l_immediate := 2 ; -- From Close Form
1646: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
1647:
1648: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
1649:
1650: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

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

1697: x_to_completion_date => l_to_completion_date ,
1698: x_act_close_date => l_act_close_date ,
1699: x_returnstatus => l_return_status
1700: );
1701: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1702: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1703: wip_logger.log(p_msg => 'time zone conversion failed',
1704: x_returnStatus => l_return_Status);
1705: END IF;

Line 1706: RAISE FND_API.G_EXC_ERROR ;

1702: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1703: wip_logger.log(p_msg => 'time zone conversion failed',
1704: x_returnStatus => l_return_Status);
1705: END IF;
1706: RAISE FND_API.G_EXC_ERROR ;
1707: END IF;
1708:
1709: if ( sysdate > l_act_close_date ) then
1710: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE CLOSE');

Line 1722: RAISE FND_API.G_EXC_ERROR ;

1718: l_msg := fnd_message.get;
1719: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1720: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1721: fnd_file.put_line(FND_FILE.LOG,l_msg);
1722: RAISE FND_API.G_EXC_ERROR ;
1723: end if ;
1724:
1725: /****************************************************************
1726: * *

Line 1747: RAISE FND_API.G_EXC_ERROR ;

1743: l_msg := fnd_message.get;
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1745: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1746: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
1747: RAISE FND_API.G_EXC_ERROR ;
1748: END ;
1749:
1750: /**********************************************************
1751: * *

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

1774: p_act_close_date => l_act_close_date ,
1775: x_group_id => l_group_id ,
1776: x_ReturnStatus => l_return_status
1777: );
1778: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1779: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1780: wip_logger.log(p_msg => 'populate_close_temp',
1781: x_returnStatus => l_return_Status);
1782: END IF;

Line 1783: RAISE FND_API.G_EXC_ERROR ;

1779: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1780: wip_logger.log(p_msg => 'populate_close_temp',
1781: x_returnStatus => l_return_Status);
1782: END IF;
1783: RAISE FND_API.G_EXC_ERROR ;
1784: END IF;
1785:
1786: /*Bug 6908428: Raise workflow notifications for eam workorders for status change to Pending close */
1787: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(

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

1790: ERRBUF => l_errMsg ,
1791: RETCODE => l_return_status
1792: );
1793:
1794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1795: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1796: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
1797: x_returnStatus => l_return_Status);
1798: END IF;

Line 1799: RAISE FND_API.G_EXC_ERROR ;

1795: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1796: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
1797: x_returnStatus => l_return_Status);
1798: END IF;
1799: RAISE FND_API.G_EXC_ERROR ;
1800: END IF;
1801: /*Bug 6908428*/
1802:
1803: UPDATE wip_discrete_jobs

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

1822: ERRBUF => l_errMsg,
1823: RETCODE => l_return_status
1824: );
1825:
1826: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1827: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1828: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
1829: x_returnStatus => l_return_Status);
1830: END IF;

Line 1831: RAISE FND_API.G_EXC_ERROR ;

1827: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1828: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
1829: x_returnStatus => l_return_Status);
1830: END IF;
1831: RAISE FND_API.G_EXC_ERROR ;
1832: END IF;
1833:
1834: /*Bug 6908428*/
1835:

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

1857: x_returnstatus => l_return_status,
1858: p_organization_id => p_organization_id,
1859: p_group_id => l_group_id);
1860:
1861: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1862: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
1863: l_msg := fnd_message.get;
1864: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1865: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

1883: x_returnstatus => l_return_status,
1884: p_organization_id => p_organization_id,
1885: p_group_id => l_group_id);
1886:
1887: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1888: x_warning := 1 ;
1889: END IF;
1890:
1891: /**********************************************************

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

1899: x_returnstatus => l_return_status,
1900: p_organization_id => p_organization_id,
1901: p_group_id => l_group_id);
1902:
1903: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1904: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
1905: l_msg := fnd_message.get;
1906: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1907: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

1925: CANCEL_MOVE_ORDERS(
1926: x_returnstatus => l_return_status,
1927: p_organization_id => p_organization_id,
1928: p_group_id => l_group_id);
1929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1930: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1931: l_msg := fnd_message.get;
1932: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1933: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

1952: x_returnstatus => l_return_status,
1953: p_organization_id => p_organization_id,
1954: p_group_id => l_group_id);
1955:
1956: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1957: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1958: l_msg := fnd_message.get;
1959: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1960: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

1978: x_returnstatus => l_return_status,
1979: p_organization_id => p_organization_id,
1980: p_group_id => l_group_id);
1981:
1982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1983: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
1984: l_msg := fnd_message.get;
1985: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1986: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

2007: x_returnstatus => l_return_status,
2008: p_organization_id => p_organization_id,
2009: p_group_id => l_group_id);
2010:
2011: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2012: x_warning := 1 ;
2013: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
2014: l_msg := fnd_message.get;
2015: --

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

2031: LOT_VALIDATE(
2032: x_returnstatus => l_return_status,
2033: p_organization_id => p_organization_id,
2034: p_group_id => l_group_id );
2035: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2036: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2037: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2038: x_returnStatus => l_return_Status);
2039: END IF;

Line 2040: RAISE FND_API.G_EXC_ERROR ;

2036: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2037: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2038: x_returnStatus => l_return_Status);
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR ;
2041: END IF;
2042:
2043: /**********************************************************
2044: * *

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

2051: x_returnstatus => l_return_status,
2052: p_organization_id => p_organization_id,
2053: p_group_id => l_group_id );
2054:
2055: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2057: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2058: x_returnStatus => l_return_Status);
2059: END IF;

Line 2083: RAISE FND_API.G_EXC_ERROR ;

2079: P_ret_code => l_ret_code ,
2080: P_err_buf => l_errMsg );
2081:
2082: IF (l_ret_code <> 0 ) THEN
2083: RAISE FND_API.G_EXC_ERROR ;
2084: END IF;
2085:
2086:
2087: /*****************************************

Line 2158: p_init_msg_list => FND_API.G_FALSE,

2154:
2155: CST_JobCloseVar_GRP.Calculate_Job_Variance
2156: (
2157: p_api_version => 1.0,
2158: p_init_msg_list => FND_API.G_FALSE,
2159: p_commit => FND_API.G_FALSE,
2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2161: x_return_status => l_return_status,
2162: x_msg_count => l_msg_count,

Line 2159: p_commit => FND_API.G_FALSE,

2155: CST_JobCloseVar_GRP.Calculate_Job_Variance
2156: (
2157: p_api_version => 1.0,
2158: p_init_msg_list => FND_API.G_FALSE,
2159: p_commit => FND_API.G_FALSE,
2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2161: x_return_status => l_return_status,
2162: x_msg_count => l_msg_count,
2163: x_msg_data => l_msg_data,

Line 2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

2156: (
2157: p_api_version => 1.0,
2158: p_init_msg_list => FND_API.G_FALSE,
2159: p_commit => FND_API.G_FALSE,
2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2161: x_return_status => l_return_status,
2162: x_msg_count => l_msg_count,
2163: x_msg_data => l_msg_data,
2164: p_user_id => fnd_global.user_id,

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

2169: p_wcti_group_id => l_costing_group_id,
2170: p_org_id => p_organization_id
2171: );
2172: -- Bug 5370550
2173: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2174: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2175: wip_logger.log(p_msg => 'costing function error',
2176: x_returnStatus => l_return_Status);
2177: END IF;

Line 2178: RAISE FND_API.G_EXC_ERROR ;

2174: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2175: wip_logger.log(p_msg => 'costing function error',
2176: x_returnStatus => l_return_Status);
2177: END IF;
2178: RAISE FND_API.G_EXC_ERROR ;
2179: END IF;
2180:
2181:
2182: /* Closing the jobs */

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

2188: ERRBUF => l_errMsg,
2189: RETCODE => l_return_Status
2190: );
2191:
2192: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2193: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2194: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2195: x_returnStatus => l_return_Status);
2196: END IF;

Line 2197: RAISE FND_API.G_EXC_ERROR ;

2193: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2194: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2195: x_returnStatus => l_return_Status);
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR ;
2198: END IF;
2199:
2200: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2201: p_group_id => l_group_id,

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

2204: ERRBUF => l_errMsg,
2205: RETCODE => l_return_status
2206: );
2207:
2208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2209: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2210: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2211: x_returnStatus => l_return_Status);
2212: END IF;

Line 2213: RAISE FND_API.G_EXC_ERROR ;

2209: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2210: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2211: x_returnStatus => l_return_Status);
2212: END IF;
2213: RAISE FND_API.G_EXC_ERROR ;
2214: END IF;
2215:
2216: /*Bug 6908428*/
2217:

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

2271: p_from_job => p_from_job ,
2272: p_to_job => p_to_job ,
2273: p_status => p_status);
2274:
2275: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2276: x_warning := 1 ;
2277: END IF;
2278:
2279:

Line 2322: x_returnStatus := FND_API.G_RET_STS_ERROR ;

2318: EXCEPTION
2319: WHEN others THEN
2320: rollback ;
2321: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');
2322: x_returnStatus := FND_API.G_RET_STS_ERROR ;
2323: /* Update jobs to Failed Close status */
2324:
2325: /*Bug 6908428: Update the status of eam_work_order_details to failed close and proceed workflow notification*/
2326: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(

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

2329: ERRBUF => l_errMsg,
2330: RETCODE => l_return_Status
2331: );
2332:
2333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2334: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2335: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2336: x_returnStatus => l_return_Status);
2337: END IF;

Line 2338: RAISE FND_API.G_EXC_ERROR ;

2334: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2335: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2336: x_returnStatus => l_return_Status);
2337: END IF;
2338: RAISE FND_API.G_EXC_ERROR ;
2339: END IF;
2340:
2341: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2342: p_group_id => l_group_id,

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

2345: ERRBUF => l_errMsg,
2346: RETCODE => l_return_status
2347: );
2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2351: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2352: x_returnStatus => l_return_Status);
2353: END IF;

Line 2354: RAISE FND_API.G_EXC_ERROR ;

2350: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2351: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2352: x_returnStatus => l_return_Status);
2353: END IF;
2354: RAISE FND_API.G_EXC_ERROR ;
2355: END IF;
2356:
2357: /*Bug 6908428*/
2358:

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

2455: retcode := 1 ; -- warning ;
2456: wip_utilities.get_message_stack(p_msg =>errbuf);
2457: END IF ;
2458:
2459: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2460: retcode := 2; -- error
2461: wip_utilities.get_message_stack(p_msg =>errbuf);
2462: END IF;
2463: