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.GMD_SAMPLES_GRP dependencies on GMD_DEBUG

Line 1377: --gmd_debug.Log_Initialize('ValidateSample');

1373: e_smpl_plan_fetch_error EXCEPTION;
1374: e_error_fetch_item EXCEPTION;
1375:
1376: BEGIN
1377: --gmd_debug.Log_Initialize('ValidateSample');
1378: IF (l_debug = 'Y') THEN
1379: gmd_debug.put_line('Entered Procedure VALIDATE SAMPLES');
1380: END IF;
1381:

Line 1379: gmd_debug.put_line('Entered Procedure VALIDATE SAMPLES');

1375:
1376: BEGIN
1377: --gmd_debug.Log_Initialize('ValidateSample');
1378: IF (l_debug = 'Y') THEN
1379: gmd_debug.put_line('Entered Procedure VALIDATE SAMPLES');
1380: END IF;
1381:
1382: -- Initialize API return status to success
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1385: gmd_debug.put_line('called_from = ' || p_called_from);

1381:
1382: -- Initialize API return status to success
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384: IF (l_debug = 'Y') THEN
1385: gmd_debug.put_line('called_from = ' || p_called_from);
1386: END IF;
1387: IF (p_called_from = 'API') THEN
1388: -- Check for NULLs and Valid Foreign Keys in the input parameter
1389: IF (l_debug = 'Y') THEN

Line 1390: gmd_debug.put_line('calling check_for_null_and_fks_in_smpl ');

1386: END IF;
1387: IF (p_called_from = 'API') THEN
1388: -- Check for NULLs and Valid Foreign Keys in the input parameter
1389: IF (l_debug = 'Y') THEN
1390: gmd_debug.put_line('calling check_for_null_and_fks_in_smpl ');
1391: END IF;
1392:
1393: check_for_null_and_fks_in_smpl
1394: (

Line 1413: gmd_debug.put_line('Starting check for duplicate sample number:');

1409:
1410: -- Perform all other business validations.
1411:
1412: IF (l_debug = 'Y') THEN
1413: gmd_debug.put_line('Starting check for duplicate sample number:');
1414: END IF;
1415:
1416: -- M. Grosser 03-May-2006 Bug 5115015 - Modified procedure validate_sample
1417: -- to not validate sample number when automatic sample number

Line 1450: gmd_debug.put_line('Starting uom conversion:');

1446: END IF; -- Not automatic sample no assignment
1447: -- M. Grosser 03-May-2006 Bug 5115015 - End of changes
1448:
1449: IF (l_debug = 'Y') THEN
1450: gmd_debug.put_line('Starting uom conversion:');
1451: END IF;
1452:
1453: -- Sample Quantity UOM must be convertible to Item's UOM
1454: IF p_sample.sample_type = 'I' THEN

Line 1483: gmd_debug.put_line('After uom conversion qty2 ='||l_trans_qty2);

1479: to_unit => l_primary_uom_code,
1480: from_name => NULL ,
1481: to_name => NULL) ;
1482: IF (l_debug = 'Y') THEN
1483: gmd_debug.put_line('After uom conversion qty2 ='||l_trans_qty2);
1484: END IF;
1485:
1486: --GMICUOM.icuomcv(pitem_id => l_item_mst.item_id,
1487: -- plot_id => 0,

Line 1502: gmd_debug.put_line('end validate sample');

1498: RAISE FND_API.G_EXC_ERROR;
1499: END;
1500:
1501: IF (l_debug = 'Y') THEN
1502: gmd_debug.put_line('end validate sample');
1503: END IF;
1504: -- All systems GO...
1505:
1506: EXCEPTION

Line 1627: --gmd_debug.Log_Initialize('UPDATE_SAMPLE_COMP_DISP');

1623:
1624: --Bug# 5440347 end
1625:
1626: BEGIN
1627: --gmd_debug.Log_Initialize('UPDATE_SAMPLE_COMP_DISP');
1628:
1629: IF (l_debug = 'Y') THEN
1630: gmd_debug.put_line('Entered Procedure UPDATE_SAMPLE_COMP_DISP');
1631: END IF;

Line 1630: gmd_debug.put_line('Entered Procedure UPDATE_SAMPLE_COMP_DISP');

1626: BEGIN
1627: --gmd_debug.Log_Initialize('UPDATE_SAMPLE_COMP_DISP');
1628:
1629: IF (l_debug = 'Y') THEN
1630: gmd_debug.put_line('Entered Procedure UPDATE_SAMPLE_COMP_DISP');
1631: END IF;
1632:
1633: -- Initialize API return status to success
1634: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1639: gmd_debug.put_line('Input Parameters:');

1635:
1636: l_position := '010' ;
1637:
1638: IF (l_debug = 'Y') THEN
1639: gmd_debug.put_line('Input Parameters:');
1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);

Line 1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);

1636: l_position := '010' ;
1637:
1638: IF (l_debug = 'Y') THEN
1639: gmd_debug.put_line('Input Parameters:');
1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);
1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);

Line 1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);

1637:
1638: IF (l_debug = 'Y') THEN
1639: gmd_debug.put_line('Input Parameters:');
1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);
1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);
1645: END IF;

Line 1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);

1638: IF (l_debug = 'Y') THEN
1639: gmd_debug.put_line('Input Parameters:');
1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);
1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);
1645: END IF;
1646:

Line 1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);

1639: gmd_debug.put_line('Input Parameters:');
1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);
1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);
1645: END IF;
1646:
1647: IF (p_update_disp_rec.sample_id IS NULL AND p_update_disp_rec.composite_spec_disp_id IS NULL) OR (p_to_disposition IS NULL) THEN

Line 1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);

1640: gmd_debug.put_line('Sample ID: ' || p_update_disp_rec.sample_id);
1641: gmd_debug.put_line('Composite Spec Disp ID: ' || p_update_disp_rec.composite_spec_disp_id);
1642: gmd_debug.put_line('Event Spec Disp ID: ' || p_update_disp_rec.event_spec_disp_id);
1643: gmd_debug.put_line('Change Disp From: ' || p_update_disp_rec.curr_disposition);
1644: gmd_debug.put_line('Change Disp To: ' || p_to_disposition);
1645: END IF;
1646:
1647: IF (p_update_disp_rec.sample_id IS NULL AND p_update_disp_rec.composite_spec_disp_id IS NULL) OR (p_to_disposition IS NULL) THEN
1648: raise REQ_FIELDS_MISSING;

Line 1733: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, BATCHSTEP_ID:'||l_step_id);

1729: -- only do so if the sample group disposition is in 4A or 5AV -- 8252179
1730:
1731: -- IF (l_sg_disposition in ('4A', '5AV')) then -- if added for -- 8252179
1732: IF (l_debug = 'Y') THEN
1733: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, BATCHSTEP_ID:'||l_step_id);
1734: END IF;
1735: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, return_status);
1736: END IF;
1737:

Line 1761: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_step_id);

1757: IF l_auto_complete_bstep = 'Y' THEN
1758: p_batch_step_rec.batchstep_id := l_step_id;
1759:
1760: IF (l_debug = 'Y') THEN
1761: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_step_id);
1762: END IF;
1763: --call the batch step completion API.
1764: GME_API_PUB.complete_step(
1765: p_api_version => 2.0

Line 1783: gmd_debug.put_line('Returned from Batch Step Completion Call');

1779: ,x_exception_material_tbl => l_exception_material_tbl);
1780: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
1781:
1782: IF (l_debug = 'Y') THEN
1783: gmd_debug.put_line('Returned from Batch Step Completion Call');
1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

Line 1784: gmd_debug.put_line('x_return_status = '||xx_return_status);

1780: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
1781:
1782: IF (l_debug = 'Y') THEN
1783: gmd_debug.put_line('Returned from Batch Step Completion Call');
1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

Line 1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));

1781:
1782: IF (l_debug = 'Y') THEN
1783: gmd_debug.put_line('Returned from Batch Step Completion Call');
1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

Line 1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));

1782: IF (l_debug = 'Y') THEN
1783: gmd_debug.put_line('Returned from Batch Step Completion Call');
1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

Line 1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

1783: gmd_debug.put_line('Returned from Batch Step Completion Call');
1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1791: END IF;

Line 1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

1784: gmd_debug.put_line('x_return_status = '||xx_return_status);
1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1791: END IF;
1792: END IF; --l_auto_complete_bstep = 'Y'

Line 1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

1785: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1791: END IF;
1792: END IF; --l_auto_complete_bstep = 'Y'
1793: --Bug# 5440347 end

Line 1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

1786: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1787: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1788: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1789: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1790: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1791: END IF;
1792: END IF; --l_auto_complete_bstep = 'Y'
1793: --Bug# 5440347 end
1794:

Line 1805: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, BATCHSTEP_ID:'||l_step_id);

1801: IF Nvl(p_update_disp_rec.sample_id, 0) <> 0 AND -- added for -- 8252179
1802: l_sg_event_id <> 0 AND
1803: (Nvl(l_active_cnt, 0) = 1 AND Nvl(l_req_cnt, 0) = 1) THEN
1804: IF (l_debug = 'Y') THEN
1805: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, BATCHSTEP_ID:'||l_step_id);
1806: END IF;
1807:
1808: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, return_status);
1809:

Line 1913: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, BATCHSTEP_ID:'||l_step_id);

1909: THEN
1910: --changing the quality status of batch step to 'In Spec'
1911: -- IF (l_sg_disposition in ('4A', '5AV')) then -- added for -- 8252179
1912: IF (l_debug = 'Y') THEN
1913: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, BATCHSTEP_ID:'||l_step_id);
1914: END IF;
1915: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, return_status); -- 8252179
1916: -- END IF;
1917: IF (return_status <> 'S') THEN

Line 1936: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_step_id);

1932: then only call the gme API to complete the batch step.*/
1933: IF l_auto_complete_bstep = 'Y' THEN
1934: p_batch_step_rec.batchstep_id := l_step_id;
1935: IF (l_debug = 'Y') THEN
1936: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_step_id);
1937: END IF;
1938: --call the batch step completion API.
1939: GME_API_PUB.complete_step(
1940: p_api_version => 2.0

Line 1957: gmd_debug.put_line('Returned from Batch Step Completion Call');

1953: ,x_batch_step_rec => x_batch_step_rec
1954: ,x_exception_material_tbl => l_exception_material_tbl);
1955: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
1956: IF (l_debug = 'Y') THEN
1957: gmd_debug.put_line('Returned from Batch Step Completion Call');
1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

Line 1958: gmd_debug.put_line('x_return_status = '||xx_return_status);

1954: ,x_exception_material_tbl => l_exception_material_tbl);
1955: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
1956: IF (l_debug = 'Y') THEN
1957: gmd_debug.put_line('Returned from Batch Step Completion Call');
1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

Line 1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));

1955: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
1956: IF (l_debug = 'Y') THEN
1957: gmd_debug.put_line('Returned from Batch Step Completion Call');
1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

Line 1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));

1956: IF (l_debug = 'Y') THEN
1957: gmd_debug.put_line('Returned from Batch Step Completion Call');
1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

Line 1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

1957: gmd_debug.put_line('Returned from Batch Step Completion Call');
1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1965: END IF;

Line 1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

1958: gmd_debug.put_line('x_return_status = '||xx_return_status);
1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1965: END IF;
1966: END IF; --l_auto_complete_bstep = 'Y'

Line 1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

1959: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1965: END IF;
1966: END IF; --l_auto_complete_bstep = 'Y'
1967: ELSIF (p_to_disposition = '6RJ') THEN

Line 1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

1960: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
1961: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
1962: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1963: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
1964: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
1965: END IF;
1966: END IF; --l_auto_complete_bstep = 'Y'
1967: ELSIF (p_to_disposition = '6RJ') THEN
1968:

Line 1975: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, BATCHSTEP_ID:'||l_step_id);

1971: -- only do so if the sample group disposition is 6RJ -- 8252179
1972:
1973: -- IF (l_sg_disposition = '6RJ' ) then -- added IF for -- 8252179
1974: IF (l_debug = 'Y') THEN
1975: gmd_debug.put_line('Before Calling gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, BATCHSTEP_ID:'||l_step_id);
1976: END IF;
1977:
1978: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, return_status);
1979: -- END IF;

Line 2002: gmd_debug.put_line('l_active_cnt=>'||l_active_cnt);

1998: IF p_update_disp_rec.composite_spec_disp_id IS NOT NULL THEN
1999: l_final_event_disp := p_to_disposition ;
2000: ELSE
2001: IF (l_debug = 'Y') THEN
2002: gmd_debug.put_line('l_active_cnt=>'||l_active_cnt);
2003: gmd_debug.put_line('l_req_cnt=>'||l_req_cnt);
2004: gmd_debug.put_line('to_disp=>'||p_to_disposition);
2005: gmd_debug.put_line('curr_event_disp=>'||l_curr_event_disp);
2006: END IF;

Line 2003: gmd_debug.put_line('l_req_cnt=>'||l_req_cnt);

1999: l_final_event_disp := p_to_disposition ;
2000: ELSE
2001: IF (l_debug = 'Y') THEN
2002: gmd_debug.put_line('l_active_cnt=>'||l_active_cnt);
2003: gmd_debug.put_line('l_req_cnt=>'||l_req_cnt);
2004: gmd_debug.put_line('to_disp=>'||p_to_disposition);
2005: gmd_debug.put_line('curr_event_disp=>'||l_curr_event_disp);
2006: END IF;
2007:

Line 2004: gmd_debug.put_line('to_disp=>'||p_to_disposition);

2000: ELSE
2001: IF (l_debug = 'Y') THEN
2002: gmd_debug.put_line('l_active_cnt=>'||l_active_cnt);
2003: gmd_debug.put_line('l_req_cnt=>'||l_req_cnt);
2004: gmd_debug.put_line('to_disp=>'||p_to_disposition);
2005: gmd_debug.put_line('curr_event_disp=>'||l_curr_event_disp);
2006: END IF;
2007:
2008: -- if there is no active sample,update the event to 'Pending'

Line 2005: gmd_debug.put_line('curr_event_disp=>'||l_curr_event_disp);

2001: IF (l_debug = 'Y') THEN
2002: gmd_debug.put_line('l_active_cnt=>'||l_active_cnt);
2003: gmd_debug.put_line('l_req_cnt=>'||l_req_cnt);
2004: gmd_debug.put_line('to_disp=>'||p_to_disposition);
2005: gmd_debug.put_line('curr_event_disp=>'||l_curr_event_disp);
2006: END IF;
2007:
2008: -- if there is no active sample,update the event to 'Pending'
2009: -- active count can't be negative in real scenario.Just to be on safe side.

Line 2021: gmd_debug.put_line('l_curr_event_disp in (4A,5AV,6RJ )so return - l_curr_event_disp : ' ||

2017: l_ch_final_disp := NULL;
2018: l_ch_final_disp := p_to_disposition;
2019: ELSE
2020: IF (l_debug = 'Y') THEN
2021: gmd_debug.put_line('l_curr_event_disp in (4A,5AV,6RJ )so return - l_curr_event_disp : ' ||
2022: l_curr_event_disp);
2023: END IF;
2024:
2025: RETURN;

Line 2030: gmd_debug.put_line('Sampling Event ID: '||l_sampling_event_id);

2026: END IF;
2027: END IF;
2028:
2029: IF (l_debug = 'Y') THEN
2030: gmd_debug.put_line('Sampling Event ID: '||l_sampling_event_id);
2031: END IF;
2032: -- SG disp formalised here
2033:
2034: -- get MAXIMUM sample disposition from all the samples for that event.

Line 2044: gmd_debug.put_line('max disp=>'||l_max_disposition);

2040: AND ssd.delete_mark = 0
2041: AND ssd.disposition NOT IN ('0RT', '7CN');
2042:
2043: IF (l_debug = 'Y') THEN
2044: gmd_debug.put_line('max disp=>'||l_max_disposition);
2045: END IF;
2046:
2047: -- there could be a scenario where one has 2 samples.S1 with disp = '4A'
2048: -- and S2 with disp = 'In progess'.Now user tries to change the disp

Line 2059: gmd_debug.put_line('FInal disp=>'||l_final_event_disp);

2055: ELSE
2056: l_final_event_disp := l_max_disposition;
2057: END IF;
2058: IF (l_debug = 'Y') THEN
2059: gmd_debug.put_line('FInal disp=>'||l_final_event_disp);
2060: END IF;
2061: ELSE
2062: -- either required count > 1 or active count > 1
2063: -- if event is already approved/rejected , don't update the event .

Line 2108: gmd_debug.put_line('Final disp last =>'||l_final_event_disp);

2104: l_final_event_disp := '1P';
2105: END IF;
2106:
2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line('Final disp last =>'||l_final_event_disp);
2109: gmd_debug.put_line('updating the disposition of the Sampling Event (SG) to =>'||l_final_event_disp);
2110: gmd_debug.put_line('for l_sampling_event_id =>'||l_sampling_event_id);
2111: END IF;
2112:

Line 2109: gmd_debug.put_line('updating the disposition of the Sampling Event (SG) to =>'||l_final_event_disp);

2105: END IF;
2106:
2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line('Final disp last =>'||l_final_event_disp);
2109: gmd_debug.put_line('updating the disposition of the Sampling Event (SG) to =>'||l_final_event_disp);
2110: gmd_debug.put_line('for l_sampling_event_id =>'||l_sampling_event_id);
2111: END IF;
2112:
2113: -- Set the disposition of the Event spec disp

Line 2110: gmd_debug.put_line('for l_sampling_event_id =>'||l_sampling_event_id);

2106:
2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line('Final disp last =>'||l_final_event_disp);
2109: gmd_debug.put_line('updating the disposition of the Sampling Event (SG) to =>'||l_final_event_disp);
2110: gmd_debug.put_line('for l_sampling_event_id =>'||l_sampling_event_id);
2111: END IF;
2112:
2113: -- Set the disposition of the Event spec disp
2114: UPDATE gmd_event_spec_disp

Line 2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');

2193: FETCH Cur_get_seq INTO l_change_disp_id;
2194: CLOSE Cur_get_seq;
2195:
2196: IF (l_debug = 'Y') THEN
2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');
2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);

Line 2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);

2194: CLOSE Cur_get_seq;
2195:
2196: IF (l_debug = 'Y') THEN
2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');
2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);

Line 2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);

2195:
2196: IF (l_debug = 'Y') THEN
2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');
2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);

Line 2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);

2196: IF (l_debug = 'Y') THEN
2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');
2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);

Line 2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);

2197: gmd_debug.put_line('In Procedure update_change_disp_table and input parameters = ');
2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);

Line 2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);

2198: gmd_debug.put_line(' change_disp_id: ' || l_change_disp_id);
2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);

Line 2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);

2199: gmd_debug.put_line(' organization ID: ' || p_update_change_disp_rec.organization_id);
2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);

Line 2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);

2200: gmd_debug.put_line(' Sample ID: ' || p_update_change_disp_rec.sample_id);
2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);

Line 2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);

2201: gmd_debug.put_line(' sampling_event_id : ' || p_update_change_disp_rec.sampling_event_id);
2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);

Line 2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);

2202: gmd_debug.put_line(' disposition_from : ' || p_update_change_disp_rec.disposition_from);
2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);

Line 2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);

2203: gmd_debug.put_line(' disposition_to : ' || p_update_change_disp_rec.disposition_to);
2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);
2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);

Line 2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);

2204: gmd_debug.put_line(' parent lot number : ' || p_update_change_disp_rec.parent_lot_number);
2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);
2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);
2212: END IF;

Line 2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);

2205: gmd_debug.put_line(' lot number: ' || p_update_change_disp_rec.lot_number);
2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);
2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);
2212: END IF;
2213:

Line 2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);

2206: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.to_lot_status_id);
2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);
2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);
2212: END IF;
2213:
2214: INSERT INTO GMD_CHANGE_DISPOSITION

Line 2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);

2207: gmd_debug.put_line(' lot status id: ' || p_update_change_disp_rec.from_lot_status_id);
2208: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.to_grade_code);
2209: gmd_debug.put_line(' grade code: ' || p_update_change_disp_rec.from_grade_code);
2210: gmd_debug.put_line(' hold date: ' || p_update_change_disp_rec.hold_date);
2211: gmd_debug.put_line(' reason id : ' || p_update_change_disp_rec.reason_id);
2212: END IF;
2213:
2214: INSERT INTO GMD_CHANGE_DISPOSITION
2215: (

Line 2575: gmd_debug.Log_Initialize('Update_lot_grade_batch');

2571: Changes made as a part of Bug#10170611 ends
2572: */
2573: -- Initialize API return status to success
2574: x_return_status := FND_API.G_RET_STS_SUCCESS;
2575: gmd_debug.Log_Initialize('Update_lot_grade_batch');
2576:
2577:
2578: IF (l_debug = 'Y') THEN
2579: gmd_debug.put_line('Entering update_lot_grade_batch p_sample_id :'||p_sample_id);

Line 2579: gmd_debug.put_line('Entering update_lot_grade_batch p_sample_id :'||p_sample_id);

2575: gmd_debug.Log_Initialize('Update_lot_grade_batch');
2576:
2577:
2578: IF (l_debug = 'Y') THEN
2579: gmd_debug.put_line('Entering update_lot_grade_batch p_sample_id :'||p_sample_id);
2580:
2581: END IF;
2582:
2583: IF (p_sample_id IS NULL AND p_composite_spec_disp_id IS NULL)

Line 2628: gmd_debug.put_line('Inside Update_lot_grade_batch - lpn from sample = :'||l_lpn_id);

2624:
2625:
2626:
2627: IF (l_debug = 'Y') THEN
2628: gmd_debug.put_line('Inside Update_lot_grade_batch - lpn from sample = :'||l_lpn_id);
2629: END IF;
2630:
2631:
2632:

Line 2900: gmd_debug.put_line('l_parent_lot_number = :'|| l_parent_lot_number );

2896: END IF ; -- IF l_default_status_id is not null then
2897: -- Bug 91432301
2898:
2899: IF (l_debug = 'Y') THEN -- pal
2900: gmd_debug.put_line('l_parent_lot_number = :'|| l_parent_lot_number );
2901: gmd_debug.put_line('l_lot_number = :'|| l_lot_number );
2902: END IF;
2903:
2904: IF l_parent_lot_number IS NOT NULL

Line 2901: gmd_debug.put_line('l_lot_number = :'|| l_lot_number );

2897: -- Bug 91432301
2898:
2899: IF (l_debug = 'Y') THEN -- pal
2900: gmd_debug.put_line('l_parent_lot_number = :'|| l_parent_lot_number );
2901: gmd_debug.put_line('l_lot_number = :'|| l_lot_number );
2902: END IF;
2903:
2904: IF l_parent_lot_number IS NOT NULL
2905: AND l_lot_number IS NULL THEN

Line 2908: gmd_debug.put_line(' l_parent_lot_number IS NOT NULL AND l_lot_number IS NULL l_parent_lot_number = ' ||l_parent_lot_number);

2904: IF l_parent_lot_number IS NOT NULL
2905: AND l_lot_number IS NULL THEN
2906:
2907: IF (l_debug = 'Y') THEN
2908: gmd_debug.put_line(' l_parent_lot_number IS NOT NULL AND l_lot_number IS NULL l_parent_lot_number = ' ||l_parent_lot_number);
2909: END IF;
2910:
2911: -- update all lots for the parent lot specified
2912: /* OPEN get_curr_lot_status_cv FOR

Line 3013: gmd_debug.put_line('INV_MATERIAL_STATUS_PUB.update_status - lpn passed from sample = :'||l_lpn_id);

3009: -- fix for 12829066 -- pal
3010:
3011:
3012: IF (l_debug = 'Y') THEN
3013: gmd_debug.put_line('INV_MATERIAL_STATUS_PUB.update_status - lpn passed from sample = :'||l_lpn_id);
3014: END IF;
3015:
3016: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3017:

Line 3019: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);

3015:
3016: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3017:
3018: IF (l_debug = 'Y') THEN
3019: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);
3020: END IF;
3021:
3022: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3023:

Line 3049: gmd_debug.put_line('about to try to call INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is wms enabled');

3045:
3046: IF l_wms_enabled_flag = 'Y' then -- 12829066 check if org is wms enabled
3047:
3048: IF (l_debug = 'Y') THEN
3049: gmd_debug.put_line('about to try to call INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is wms enabled');
3050: END IF;
3051: -- need to loop round moqd and update status for all lpns associated with that item and org
3052:
3053: OPEN cur_get_lpn;

Line 3062: gmd_debug.put_line(' at LEAST one LPN is found here - pal - org is wms enabled');

3058: -- call API with LPN in a loop
3059:
3060:
3061: IF (l_debug = 'Y') THEN
3062: gmd_debug.put_line(' at LEAST one LPN is found here - pal - org is wms enabled');
3063: END IF;
3064: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3065:
3066: IF (l_debug = 'Y') THEN

Line 3067: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);

3063: END IF;
3064: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3065:
3066: IF (l_debug = 'Y') THEN
3067: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3068: END IF;
3069:
3070: INV_MATERIAL_STATUS_PUB.update_status
3071: (p_api_version_number => 1.0,

Line 3093: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);

3089:
3090: ELSE -- 12829066 NOT wms_enabled
3091:
3092: IF (l_debug = 'Y') THEN
3093: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);
3094: END IF;
3095:
3096:
3097: -- call API with null LPN

Line 3128: gmd_debug.put_line(' l_lot_number IS NOT NULL = ' ||l_lot_number); -- pal

3124:
3125: ELSIF l_lot_number IS NOT NULL THEN -- IF l_parent_lot_number IS NOT NULL AND l_lot_number IS NULL THEN
3126:
3127: IF (l_debug = 'Y') THEN
3128: gmd_debug.put_line(' l_lot_number IS NOT NULL = ' ||l_lot_number); -- pal
3129: gmd_debug.put_line(' p_to_lot_status_id = ' ||p_to_lot_status_id); -- pal
3130: END IF;
3131:
3132:

Line 3129: gmd_debug.put_line(' p_to_lot_status_id = ' ||p_to_lot_status_id); -- pal

3125: ELSIF l_lot_number IS NOT NULL THEN -- IF l_parent_lot_number IS NOT NULL AND l_lot_number IS NULL THEN
3126:
3127: IF (l_debug = 'Y') THEN
3128: gmd_debug.put_line(' l_lot_number IS NOT NULL = ' ||l_lot_number); -- pal
3129: gmd_debug.put_line(' p_to_lot_status_id = ' ||p_to_lot_status_id); -- pal
3130: END IF;
3131:
3132:
3133:

Line 3177: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);

3173: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3174:
3175:
3176: IF (l_debug = 'Y') THEN
3177: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);
3178: END IF;
3179:
3180: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3181:

Line 3208: gmd_debug.put_line('lot number is not null ; NO LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);

3204:
3205: IF cur_get_loose_lpn%NOTFOUND then
3206:
3207: IF (l_debug = 'Y') THEN
3208: gmd_debug.put_line('lot number is not null ; NO LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);
3209: END IF;
3210:
3211:
3212: CLOSE cur_get_loose_lpn;

Line 3217: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status ; lot number is not null - LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);

3213: else
3214: CLOSE cur_get_loose_lpn;
3215:
3216: IF (l_debug = 'Y') THEN
3217: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status ; lot number is not null - LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);
3218: END IF;
3219:
3220: l_inv_status_upd_rec_type.LPN_ID := NULL;
3221:

Line 3250: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn NOT passed from sample - org is wms enabled');

3246: IF l_wms_enabled_flag = 'Y' then -- 12829066 check if org is wms enabled
3247:
3248: -- need to loop round moqd and update status for all lpns associated with that item and org
3249: IF (l_debug = 'Y') THEN
3250: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn NOT passed from sample - org is wms enabled');
3251: END IF;
3252: l_lpn_found := 0; -- pal 14620426 sep 14 fix
3253:
3254:

Line 3264: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);

3260: -- call API with LPN in a loop
3261: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3262: l_lpn_found := 1; -- pal 14620426 sep 14 fix
3263: IF (l_debug = 'Y') THEN
3264: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3265: END IF;
3266:
3267: INV_MATERIAL_STATUS_PUB.update_status
3268: (p_api_version_number => 1.0,

Line 3291: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with no LPN found lpn NOT passed from sample - org is wms enabled ; lot number :'|| l_inv_status_upd_rec_type.lot_number);

3287: -- pal 14620426 sep 14 fix
3288: IF l_lpn_found <> 1 then
3289:
3290: IF (l_debug = 'Y') THEN
3291: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with no LPN found lpn NOT passed from sample - org is wms enabled ; lot number :'|| l_inv_status_upd_rec_type.lot_number);
3292: END IF;
3293: INV_MATERIAL_STATUS_PUB.update_status
3294: (p_api_version_number => 1.0,
3295: p_init_msg_lst => fnd_api.g_false,

Line 3315: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);

3311: ELSE -- 12829066 not wms_enabled
3312:
3313:
3314: IF (l_debug = 'Y') THEN
3315: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);
3316: END IF;
3317: -- call API with null LPN
3318: INV_MATERIAL_STATUS_PUB.update_status
3319: (p_api_version_number => 1.0,

Line 3408: gmd_debug.put_line('about to UPDATE GME_BATCH_STEPS quality status with p_to_qc_status :'||p_to_qc_status);

3404: AND batchstep_no = l_step_no
3405: FOR UPDATE OF quality_status NOWAIT ;
3406:
3407: IF (l_debug = 'Y') THEN
3408: gmd_debug.put_line('about to UPDATE GME_BATCH_STEPS quality status with p_to_qc_status :'||p_to_qc_status);
3409: END IF;
3410:
3411:
3412: IF l_curr_qc_status = 3 THEN -- Results Required

Line 3448: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_bstep_id);

3444: IF l_auto_complete_bstep = 'Y' THEN
3445: p_batch_step_rec.batchstep_id := l_bstep_id;
3446:
3447: IF (l_debug = 'Y') THEN
3448: gmd_debug.put_line('Before Calling Batch Step Completion API for BATCHSTEP_ID:'||l_bstep_id);
3449: END IF;
3450:
3451: --call the batch step completion API.
3452: GME_API_PUB.complete_step(

Line 3471: gmd_debug.put_line('Returned from Batch Step Completion Call');

3467: ,x_exception_material_tbl => l_exception_material_tbl);
3468: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
3469:
3470: IF (l_debug = 'Y') THEN
3471: gmd_debug.put_line('Returned from Batch Step Completion Call');
3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

Line 3472: gmd_debug.put_line('x_return_status = '||xx_return_status);

3468: --After returning from the API we are not handling any exceptions. Any exceptions will be written in the Debug Log
3469:
3470: IF (l_debug = 'Y') THEN
3471: gmd_debug.put_line('Returned from Batch Step Completion Call');
3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

Line 3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));

3469:
3470: IF (l_debug = 'Y') THEN
3471: gmd_debug.put_line('Returned from Batch Step Completion Call');
3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

Line 3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));

3470: IF (l_debug = 'Y') THEN
3471: gmd_debug.put_line('Returned from Batch Step Completion Call');
3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

Line 3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));

3471: gmd_debug.put_line('Returned from Batch Step Completion Call');
3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
3479: END IF;

Line 3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

3472: gmd_debug.put_line('x_return_status = '||xx_return_status);
3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
3479: END IF;
3480:

Line 3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

3473: gmd_debug.put_line('x_batch_step_rec.batch_id = '||TO_CHAR(x_batch_step_rec.batch_id));
3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
3479: END IF;
3480:
3481: END IF; --l_auto_complete_bstep = 'Y'

Line 3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));

3474: gmd_debug.put_line('x_batch_step_rec.batchstep_id = '||TO_CHAR(x_batch_step_rec.batchstep_id));
3475: gmd_debug.put_line('x_batch_step_rec.batchstep_no = '||TO_CHAR(x_batch_step_rec.batchstep_no));
3476: gmd_debug.put_line('x_batch_step_rec.actual_start_date = '||TO_CHAR(x_batch_step_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
3477: gmd_debug.put_line('x_batch_step_rec.actual_cmplt_date = '||TO_CHAR(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
3478: gmd_debug.put_line('x_batch_step_rec.step_status = '||TO_CHAR(x_batch_step_rec.step_status));
3479: END IF;
3480:
3481: END IF; --l_auto_complete_bstep = 'Y'
3482: -- Bug# 5440347 end

Line 3490: gmd_debug.put_line('exiting update_lot_grade_batch p_sample_id :'||p_sample_id);

3486:
3487: END IF;
3488:
3489: IF (l_debug = 'Y') THEN
3490: gmd_debug.put_line('exiting update_lot_grade_batch p_sample_id :'||p_sample_id);
3491: END IF;
3492:
3493:
3494: EXCEPTION

Line 4366: gmd_debug.put_line('In Procedure create_inv_txn');

4362: FETCH Cur_get_seq INTO p_header_id;
4363: CLOSE Cur_get_seq;
4364:
4365: IF (l_debug = 'Y') THEN
4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);

Line 4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');

4363: CLOSE Cur_get_seq;
4364:
4365: IF (l_debug = 'Y') THEN
4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);

Line 4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);

4364:
4365: IF (l_debug = 'Y') THEN
4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);

Line 4369: gmd_debug.put_line(' header ID: ' || p_header_id);

4365: IF (l_debug = 'Y') THEN
4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);

Line 4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);

4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);

Line 4371: gmd_debug.put_line(' user name : ' || p_user_name);

4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);

Line 4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);

4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);
4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);

Line 4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);

4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);
4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);
4377: END IF;

Line 4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);

4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);
4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);
4377: END IF;
4378:

Line 4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);

4371: gmd_debug.put_line(' user name : ' || p_user_name);
4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);
4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);
4377: END IF;
4378:
4379: l_position := '040' ;

Line 4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);

4372: gmd_debug.put_line(' date : ' || p_sample.date_drawn);
4373: gmd_debug.put_line(' qty : ' || -1*p_sample.sample_qty);
4374: gmd_debug.put_line(' lot : ' || p_sample.lot_number);
4375: gmd_debug.put_line(' reason id : ' || quality_config.transaction_reason_id);
4376: gmd_debug.put_line(' lpn id : ' || p_sample.lpn_id);
4377: END IF;
4378:
4379: l_position := '040' ;
4380:

Line 4436: gmd_debug.put_line('after insert into lot table:');

4432: l_locator_id := p_sample.locator_id ;
4433: END IF;
4434:
4435: IF (l_debug = 'Y') THEN
4436: gmd_debug.put_line('after insert into lot table:');
4437: gmd_debug.put_line(' subinventory = '||l_subinventory);
4438: gmd_debug.put_line(' locator id = '||l_locator_id);
4439: gmd_debug.put_line(' sample source = '||p_sample.source);
4440: END IF;

Line 4437: gmd_debug.put_line(' subinventory = '||l_subinventory);

4433: END IF;
4434:
4435: IF (l_debug = 'Y') THEN
4436: gmd_debug.put_line('after insert into lot table:');
4437: gmd_debug.put_line(' subinventory = '||l_subinventory);
4438: gmd_debug.put_line(' locator id = '||l_locator_id);
4439: gmd_debug.put_line(' sample source = '||p_sample.source);
4440: END IF;
4441:

Line 4438: gmd_debug.put_line(' locator id = '||l_locator_id);

4434:
4435: IF (l_debug = 'Y') THEN
4436: gmd_debug.put_line('after insert into lot table:');
4437: gmd_debug.put_line(' subinventory = '||l_subinventory);
4438: gmd_debug.put_line(' locator id = '||l_locator_id);
4439: gmd_debug.put_line(' sample source = '||p_sample.source);
4440: END IF;
4441:
4442: -- Bug 4165704: uom convergence not needed after inventory convergence

Line 4439: gmd_debug.put_line(' sample source = '||p_sample.source);

4435: IF (l_debug = 'Y') THEN
4436: gmd_debug.put_line('after insert into lot table:');
4437: gmd_debug.put_line(' subinventory = '||l_subinventory);
4438: gmd_debug.put_line(' locator id = '||l_locator_id);
4439: gmd_debug.put_line(' sample source = '||p_sample.source);
4440: END IF;
4441:
4442: -- Bug 4165704: uom convergence not needed after inventory convergence
4443: -- l_item_rec.inventory_item_id := p_sample.inventory_item_id;

Line 4539: gmd_debug.put_line('after insert into transaction table:');

4535:
4536: l_position := '070' ;
4537:
4538: IF (l_debug = 'Y') THEN
4539: gmd_debug.put_line('after insert into transaction table:');
4540: END IF;
4541:
4542: --gml_sf_log('b4 call to process transactions and header id ='|| p_header_id);
4543: -- only to test error_code in mtl_transactions_interface uncomment the following commit

Line 4560: gmd_debug.put_line('after INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS status ='||processed);

4556: ,p_header_id => p_header_id); -- foreign key to MTI, can be null
4557:
4558: --gml_sf_log('after call and return value='||processed||' and status='||x_return_status);
4559: IF (l_debug = 'Y') THEN
4560: gmd_debug.put_line('after INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS status ='||processed);
4561: END IF;
4562:
4563: IF processed < 0 THEN
4564: -- x_message_count and x_msg_data is already populated

Line 4770: gmd_debug.put_line('After uom conversion qty2 ='|| p_mmti_rec.transaction_quantity);

4766: to_unit => l_primary_uom_code,
4767: from_name => NULL ,
4768: to_name => NULL) ;
4769: IF (l_debug = 'Y') THEN
4770: gmd_debug.put_line('After uom conversion qty2 ='|| p_mmti_rec.transaction_quantity);
4771: END IF;
4772:
4773: IF (p_mmti_rec.transaction_quantity< 0 ) THEN
4774: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

Line 5109: gmd_debug.put_line('In Procedure update_remaining_qty');

5105: -- Initialize API return status to success
5106: x_return_status := FND_API.G_RET_STS_SUCCESS;
5107:
5108: IF (l_debug = 'Y') THEN
5109: gmd_debug.put_line('In Procedure update_remaining_qty');
5110: gmd_debug.put_line('Input Parameters=');
5111: gmd_debug.put_line(' Result ID: ' || p_result_id);
5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);
5113: gmd_debug.put_line(' Quantity : ' || qty);

Line 5110: gmd_debug.put_line('Input Parameters=');

5106: x_return_status := FND_API.G_RET_STS_SUCCESS;
5107:
5108: IF (l_debug = 'Y') THEN
5109: gmd_debug.put_line('In Procedure update_remaining_qty');
5110: gmd_debug.put_line('Input Parameters=');
5111: gmd_debug.put_line(' Result ID: ' || p_result_id);
5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);
5113: gmd_debug.put_line(' Quantity : ' || qty);
5114: END IF;

Line 5111: gmd_debug.put_line(' Result ID: ' || p_result_id);

5107:
5108: IF (l_debug = 'Y') THEN
5109: gmd_debug.put_line('In Procedure update_remaining_qty');
5110: gmd_debug.put_line('Input Parameters=');
5111: gmd_debug.put_line(' Result ID: ' || p_result_id);
5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);
5113: gmd_debug.put_line(' Quantity : ' || qty);
5114: END IF;
5115:

Line 5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);

5108: IF (l_debug = 'Y') THEN
5109: gmd_debug.put_line('In Procedure update_remaining_qty');
5110: gmd_debug.put_line('Input Parameters=');
5111: gmd_debug.put_line(' Result ID: ' || p_result_id);
5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);
5113: gmd_debug.put_line(' Quantity : ' || qty);
5114: END IF;
5115:
5116: -- Get the results record

Line 5113: gmd_debug.put_line(' Quantity : ' || qty);

5109: gmd_debug.put_line('In Procedure update_remaining_qty');
5110: gmd_debug.put_line('Input Parameters=');
5111: gmd_debug.put_line(' Result ID: ' || p_result_id);
5112: gmd_debug.put_line(' Sample ID: ' || p_sample_id);
5113: gmd_debug.put_line(' Quantity : ' || qty);
5114: END IF;
5115:
5116: -- Get the results record
5117: l_in_results.result_id := p_result_id;

Line 5123: gmd_debug.put_line('after fetch row from result');

5119: p_results => l_in_results,
5120: x_results => l_results);
5121:
5122: IF (l_debug = 'Y') THEN
5123: gmd_debug.put_line('after fetch row from result');
5124: END IF;
5125:
5126: -- If sample_id is specified use it. If not, get sample_id from result
5127: IF (p_sample_id > 0) THEN

Line 5130: gmd_debug.put_line('1');

5126: -- If sample_id is specified use it. If not, get sample_id from result
5127: IF (p_sample_id > 0) THEN
5128:
5129: IF (l_debug = 'Y') THEN
5130: gmd_debug.put_line('1');
5131: END IF;
5132:
5133: l_in_samples.sample_id := p_sample_id;
5134: ELSE

Line 5137: gmd_debug.put_line('2');

5133: l_in_samples.sample_id := p_sample_id;
5134: ELSE
5135:
5136: IF (l_debug = 'Y') THEN
5137: gmd_debug.put_line('2');
5138: END IF;
5139:
5140: -- Get the sample id from the results record
5141: IF (l_results.reserve_sample_id IS NULL) THEN

Line 5149: gmd_debug.put_line('sample id changed to: ');

5145: END IF;
5146: END IF;
5147:
5148: IF (l_debug = 'Y') THEN
5149: gmd_debug.put_line('sample id changed to: ');
5150: gmd_debug.put_line(' Sample ID: ' || l_in_samples.sample_id);
5151: END IF;
5152:
5153: result := GMD_SAMPLES_PVT.fetch_row(

Line 5150: gmd_debug.put_line(' Sample ID: ' || l_in_samples.sample_id);

5146: END IF;
5147:
5148: IF (l_debug = 'Y') THEN
5149: gmd_debug.put_line('sample id changed to: ');
5150: gmd_debug.put_line(' Sample ID: ' || l_in_samples.sample_id);
5151: END IF;
5152:
5153: result := GMD_SAMPLES_PVT.fetch_row(
5154: p_samples => l_in_samples,

Line 5158: gmd_debug.put_line('quantities = ');

5154: p_samples => l_in_samples,
5155: x_samples => l_samples);
5156:
5157: IF (l_debug = 'Y') THEN
5158: gmd_debug.put_line('quantities = ');
5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);

Line 5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);

5155: x_samples => l_samples);
5156:
5157: IF (l_debug = 'Y') THEN
5158: gmd_debug.put_line('quantities = ');
5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);
5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);

Line 5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);

5156:
5157: IF (l_debug = 'Y') THEN
5158: gmd_debug.put_line('quantities = ');
5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);
5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);
5164: END IF;

Line 5161: gmd_debug.put_line(' other qty: ' || qty);

5157: IF (l_debug = 'Y') THEN
5158: gmd_debug.put_line('quantities = ');
5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);
5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);
5164: END IF;
5165:

Line 5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);

5158: gmd_debug.put_line('quantities = ');
5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);
5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);
5164: END IF;
5165:
5166:

Line 5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);

5159: gmd_debug.put_line(' Sample qty: ' || l_samples.sample_qty);
5160: gmd_debug.put_line(' Remaining qty: ' || l_samples.remaining_qty);
5161: gmd_debug.put_line(' other qty: ' || qty);
5162: gmd_debug.put_line('result uom: '||l_results.test_qty_uom);
5163: gmd_debug.put_line('sample uom: '||l_samples.sample_qty_uom);
5164: END IF;
5165:
5166:
5167: -- Bug 3251084: if sample_qty or test_qty are null, then no need

Line 5199: gmd_debug.put_line('after conversion : ');

5195: from_name => NULL,
5196: to_name => NULL);
5197:
5198: IF (l_debug = 'Y') THEN
5199: gmd_debug.put_line('after conversion : ');
5200: gmd_debug.put_line('converted qty : '|| converted_qty);
5201: END IF;
5202:
5203: IF (converted_qty < 0 ) THEN

Line 5200: gmd_debug.put_line('converted qty : '|| converted_qty);

5196: to_name => NULL);
5197:
5198: IF (l_debug = 'Y') THEN
5199: gmd_debug.put_line('after conversion : ');
5200: gmd_debug.put_line('converted qty : '|| converted_qty);
5201: END IF;
5202:
5203: IF (converted_qty < 0 ) THEN
5204:

Line 5219: gmd_debug.put_line('before update : ');

5215: -- Bug 3088216: update samples remaining qty
5216: ELSIF converted_qty <= l_samples.remaining_qty THEN
5217:
5218: IF (l_debug = 'Y') THEN
5219: gmd_debug.put_line('before update : ');
5220: END IF;
5221:
5222: -- added this code to prevent locking error if sample is locked by another form.
5223: OPEN C_lock_sample(l_samples.sample_id);

Line 5238: gmd_debug.put_line(' samples uom = test uom : ');

5234:
5235: ELSE -- samples uom = test uom
5236:
5237: IF (l_debug = 'Y') THEN
5238: gmd_debug.put_line(' samples uom = test uom : ');
5239: END IF;
5240:
5241: IF qty <= l_samples.remaining_qty THEN
5242: -- added this code to prevent locking error if sample is locked by another form.

Line 5265: gmd_debug.put_line('Reached in lock on samples');

5261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5263: WHEN RECORD_LOCK THEN -- added to prevent record locking of samples
5264: IF (l_debug = 'Y') THEN
5265: gmd_debug.put_line('Reached in lock on samples');
5266: END IF;
5267: IF C_lock_sample%ISOPEN THEN
5268: CLOSE C_lock_sample;
5269: END IF;