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.PO_CLOSEOUT_PVT dependencies on FND_FILE

Line 1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1322: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1323: BEGIN
1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);
1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1330:

Line 1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

1323: BEGIN
1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);
1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1330:
1331: SELECT check_list_required

Line 1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);

1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);
1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1330:
1331: SELECT check_list_required
1332: INTO l_checklist_req

Line 1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');

1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);
1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1330:
1331: SELECT check_list_required
1332: INTO l_checklist_req
1333: FROM po_closeout_details

Line 1361: fnd_file.put_line(FND_FILE.LOG, 'Processing started for the document: ' || l_doc_num);

1357: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_vendor_id ' || l_vendor_id);
1358: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_vendor_contact_id ' || l_vendor_contact_id);
1359: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_vendor_site_id ' || l_vendor_site_id);
1360:
1361: fnd_file.put_line(FND_FILE.LOG, 'Processing started for the document: ' || l_doc_num);
1362: SELECT Count(reference_doc_id)
1363: INTO l_closeout_doc_count
1364: FROM PO_CLOSEOUT_DETAILS
1365: WHERE reference_doc_id = l_doc_id

Line 1372: fnd_file.put_line(FND_FILE.LOG, 'Closeout process has already been initiated for this award: ' || l_doc_num);

1368: l_progress := 10;
1369: IF l_closeout_doc_count > 0 THEN
1370: retcode := '1';
1371: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Closeout process has already been initiated for this award: ' || l_doc_id);
1372: fnd_file.put_line(FND_FILE.LOG, 'Closeout process has already been initiated for this award: ' || l_doc_num);
1373:
1374: ELSE
1375: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'validation is successful for award ' || l_doc_id);
1376: fnd_file.put_line(FND_FILE.LOG, 'Initiating closeout process for this award ');

Line 1376: fnd_file.put_line(FND_FILE.LOG, 'Initiating closeout process for this award ');

1372: fnd_file.put_line(FND_FILE.LOG, 'Closeout process has already been initiated for this award: ' || l_doc_num);
1373:
1374: ELSE
1375: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'validation is successful for award ' || l_doc_id);
1376: fnd_file.put_line(FND_FILE.LOG, 'Initiating closeout process for this award ');
1377:
1378: BEGIN
1379: INSERT
1380: INTO PO_CLOSEOUT_DETAILS (

Line 1480: fnd_file.put_line(FND_FILE.LOG, 'New record has been added to the PO_CLOSEOUT_DETAILS table for this award.');

1476: WHERE reference_doc_id = p_req_id
1477: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS);
1478:
1479: l_progress := 20;
1480: fnd_file.put_line(FND_FILE.LOG, 'New record has been added to the PO_CLOSEOUT_DETAILS table for this award.');
1481:
1482:
1483: IF l_checklist_req = 'Y' THEN
1484: fnd_file.put_line(FND_FILE.LOG, 'Contract creation process has been started for the award ' || l_doc_num);

Line 1484: fnd_file.put_line(FND_FILE.LOG, 'Contract creation process has been started for the award ' || l_doc_num);

1480: fnd_file.put_line(FND_FILE.LOG, 'New record has been added to the PO_CLOSEOUT_DETAILS table for this award.');
1481:
1482:
1483: IF l_checklist_req = 'Y' THEN
1484: fnd_file.put_line(FND_FILE.LOG, 'Contract creation process has been started for the award ' || l_doc_num);
1485: SELECT name
1486: INTO l_org_name
1487: FROM hr_all_organization_units_tl
1488: WHERE organization_id = l_org_id

Line 1593: fnd_file.put_line(FND_FILE.LOG, 'Contract creation is successful. Contract id is ' || l_contract_rec.contract_id);

1589: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'contract_ver ' || l_contract_rec.contract_version_num);
1590: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'contract_type ' || l_contract_rec.contract_type_txt);
1591: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_return_status ' || l_return_status);
1592: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1593: fnd_file.put_line(FND_FILE.LOG, 'Contract creation is successful. Contract id is ' || l_contract_rec.contract_id);
1594: ELSE
1595: fnd_file.put_line(FND_FILE.LOG, 'There are warnings/Errors while creating the contract.');
1596: fnd_file.put_line(FND_FILE.LOG, 'Message:' || l_result_type);
1597: END IF;

Line 1595: fnd_file.put_line(FND_FILE.LOG, 'There are warnings/Errors while creating the contract.');

1591: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_return_status ' || l_return_status);
1592: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1593: fnd_file.put_line(FND_FILE.LOG, 'Contract creation is successful. Contract id is ' || l_contract_rec.contract_id);
1594: ELSE
1595: fnd_file.put_line(FND_FILE.LOG, 'There are warnings/Errors while creating the contract.');
1596: fnd_file.put_line(FND_FILE.LOG, 'Message:' || l_result_type);
1597: END IF;
1598: END IF; --Checklist required
1599:

Line 1596: fnd_file.put_line(FND_FILE.LOG, 'Message:' || l_result_type);

1592: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1593: fnd_file.put_line(FND_FILE.LOG, 'Contract creation is successful. Contract id is ' || l_contract_rec.contract_id);
1594: ELSE
1595: fnd_file.put_line(FND_FILE.LOG, 'There are warnings/Errors while creating the contract.');
1596: fnd_file.put_line(FND_FILE.LOG, 'Message:' || l_result_type);
1597: END IF;
1598: END IF; --Checklist required
1599:
1600: fnd_file.put_line(FND_FILE.LOG, 'Workflow process has been intiated');

Line 1600: fnd_file.put_line(FND_FILE.LOG, 'Workflow process has been intiated');

1596: fnd_file.put_line(FND_FILE.LOG, 'Message:' || l_result_type);
1597: END IF;
1598: END IF; --Checklist required
1599:
1600: fnd_file.put_line(FND_FILE.LOG, 'Workflow process has been intiated');
1601: PO_CLOSEOUT_PVT.start_closeout_wf_process(p_doc_id => l_doc_id,
1602: x_return_status => l_return_status);
1603:
1604: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1605: fnd_file.put_line(FND_FILE.LOG, 'Workflow is successfully initiated');

1601: PO_CLOSEOUT_PVT.start_closeout_wf_process(p_doc_id => l_doc_id,
1602: x_return_status => l_return_status);
1603:
1604: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1605: fnd_file.put_line(FND_FILE.LOG, 'Workflow is successfully initiated');
1606: COMMIT;
1607: ELSE
1608: fnd_file.put_line(FND_FILE.LOG, 'Error(s) occured while initiating the workflow');
1609: END IF;

Line 1608: fnd_file.put_line(FND_FILE.LOG, 'Error(s) occured while initiating the workflow');

1604: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1605: fnd_file.put_line(FND_FILE.LOG, 'Workflow is successfully initiated');
1606: COMMIT;
1607: ELSE
1608: fnd_file.put_line(FND_FILE.LOG, 'Error(s) occured while initiating the workflow');
1609: END IF;
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Exception occured while processing the award '

Line 1614: fnd_file.put_line(FND_FILE.LOG, 'Fatal error occurred while processing the award ' || l_doc_num);

1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Exception occured while processing the award '
1613: || l_doc_id || ' - ' || SQLERRM );
1614: fnd_file.put_line(FND_FILE.LOG, 'Fatal error occurred while processing the award ' || l_doc_num);
1615: END;
1616: l_progress := 90;
1617: END IF;
1618: END LOOP;

Line 1622: fnd_file.put_line(FND_FILE.LOG, 'The multimod request ' || p_req_id || ' details have been cleared from the system');

1618: END LOOP;
1619:
1620: po_multi_mod_pvt.remove_multi_mod_request(p_multi_mod_request_id => p_req_id
1621: , x_return_status => l_return_status);
1622: fnd_file.put_line(FND_FILE.LOG, 'The multimod request ' || p_req_id || ' details have been cleared from the system');
1623: PO_CLOSEOUT_PVT.delete_contract(p_doc_id => p_req_id,
1624: p_closeout_type => PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS,
1625: x_return_status => l_return_status,
1626: x_return_msg => l_msg_data);

Line 1628: fnd_file.put_line(FND_FILE.LOG, 'Deleting the contract which is created for closeout set ');

1624: p_closeout_type => PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS,
1625: x_return_status => l_return_status,
1626: x_return_msg => l_msg_data);
1627: l_progress := 95;
1628: fnd_file.put_line(FND_FILE.LOG, 'Deleting the contract which is created for closeout set ');
1629: fnd_file.put_line(FND_FILE.LOG, 'Delete contract status ' || l_return_status);
1630: fnd_file.put_line(FND_FILE.LOG, 'return message from Delete contract : ' || l_msg_data);
1631: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Delete contract status ' || l_return_status);
1632: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'return message from Delete contract : ' || l_msg_data);

Line 1629: fnd_file.put_line(FND_FILE.LOG, 'Delete contract status ' || l_return_status);

1625: x_return_status => l_return_status,
1626: x_return_msg => l_msg_data);
1627: l_progress := 95;
1628: fnd_file.put_line(FND_FILE.LOG, 'Deleting the contract which is created for closeout set ');
1629: fnd_file.put_line(FND_FILE.LOG, 'Delete contract status ' || l_return_status);
1630: fnd_file.put_line(FND_FILE.LOG, 'return message from Delete contract : ' || l_msg_data);
1631: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Delete contract status ' || l_return_status);
1632: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'return message from Delete contract : ' || l_msg_data);
1633: l_progress := 100;

Line 1630: fnd_file.put_line(FND_FILE.LOG, 'return message from Delete contract : ' || l_msg_data);

1626: x_return_msg => l_msg_data);
1627: l_progress := 95;
1628: fnd_file.put_line(FND_FILE.LOG, 'Deleting the contract which is created for closeout set ');
1629: fnd_file.put_line(FND_FILE.LOG, 'Delete contract status ' || l_return_status);
1630: fnd_file.put_line(FND_FILE.LOG, 'return message from Delete contract : ' || l_msg_data);
1631: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Delete contract status ' || l_return_status);
1632: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'return message from Delete contract : ' || l_msg_data);
1633: l_progress := 100;
1634: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

Line 1639: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');

1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: errbuf := sqlerrm;
1638: retcode := '2';
1639: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
1640: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
1641: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'mass_closeout_submit : when others exception at '
1642: || l_progress || ';' || SQLERRM );
1643: END mass_closeout_submit;

Line 1640: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

1636: WHEN OTHERS THEN
1637: errbuf := sqlerrm;
1638: retcode := '2';
1639: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
1640: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
1641: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'mass_closeout_submit : when others exception at '
1642: || l_progress || ';' || SQLERRM );
1643: END mass_closeout_submit;
1644:

Line 1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1773: END IF;
1774:
1775: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1776: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);
1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');

Line 1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

1774:
1775: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1776: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);
1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1782:

Line 1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);

1775: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1776: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);
1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1782:
1783: DELETE

Line 1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);

1776: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);
1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1782:
1783: DELETE
1784: FROM po_multi_mod_val_results

Line 1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');

1777: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1778: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1779: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: ' || p_req_id);
1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1782:
1783: DELETE
1784: FROM po_multi_mod_val_results
1785: WHERE multi_mod_request_id = p_req_id;

Line 1789: fnd_file.put_line(FND_FILE.LOG,'Existing validation records have been cleared');

1785: WHERE multi_mod_request_id = p_req_id;
1786:
1787: l_progress := 5;
1788: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Num of Records deleted from po_multi_mod_val_results:' || SQL%ROWCOUNT);
1789: fnd_file.put_line(FND_FILE.LOG,'Existing validation records have been cleared');
1790:
1791: IF p_chk_list_req = 'Y' THEN
1792: l_open_mod_fail_type := 'WARNING';
1793: ELSE

Line 1833: fnd_file.put_line(FND_FILE.LOG,'Checklist tasks validation is completed ' || l_module_status);

1829: l_fail_count := l_fail_count + 1;
1830: l_module_status := 'with errors';
1831: END LOOP;
1832: END IF;
1833: fnd_file.put_line(FND_FILE.LOG,'Checklist tasks validation is completed ' || l_module_status);
1834:
1835: IF l_fail_count = 0 THEN
1836:
1837: l_progress := 20;

Line 1915: fnd_file.put_line(FND_FILE.LOG,'Contract Deliverables validation is completed ' || l_module_status);

1911: l_progress := 35;
1912:
1913: END IF;
1914: END IF;
1915: fnd_file.put_line(FND_FILE.LOG,'Contract Deliverables validation is completed ' || l_module_status);
1916: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Contract Deliverables validation is completed ' || l_module_status);
1917:
1918:
1919: l_document_id_tbl := NEW po_tbl_number();

Line 1958: fnd_file.put_line(FND_FILE.LOG,'Open modifications validation is completed ' || l_module_status);

1954: END IF;
1955: END LOOP;
1956: END IF;
1957:
1958: fnd_file.put_line(FND_FILE.LOG,'Open modifications validation is completed ' || l_module_status);
1959: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Open modifications validation is completed ' || l_module_status);
1960: l_progress := 45;
1961:
1962: l_document_id_tbl := NEW po_tbl_number();

Line 1997: fnd_file.put_line(FND_FILE.LOG,'Fully received validation is completed ' || l_module_status);

1993: l_module_status := 'with warnings';
1994: END LOOP;
1995: END IF;
1996:
1997: fnd_file.put_line(FND_FILE.LOG,'Fully received validation is completed ' || l_module_status);
1998: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Fully received validation is completed ' || l_module_status);
1999:
2000: l_progress := 60;
2001:

Line 2037: fnd_file.put_line(FND_FILE.LOG,'Fully invoiced validation is completed ' || l_module_status);

2033: l_module_status := 'with warnings';
2034: END LOOP;
2035: END IF;
2036:
2037: fnd_file.put_line(FND_FILE.LOG,'Fully invoiced validation is completed ' || l_module_status);
2038: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Fully invoiced validation is completed ' || l_module_status);
2039: l_progress := 80;
2040:
2041: l_document_id_tbl := NEW po_tbl_number();

Line 2119: fnd_file.put_line(FND_FILE.LOG,'Fully paid validation is completed ' || l_module_status);

2115: l_warn_count := l_warn_count + 1;
2116: l_module_status := 'with warnings';
2117: END LOOP;
2118: END IF;
2119: fnd_file.put_line(FND_FILE.LOG,'Fully paid validation is completed ' || l_module_status);
2120: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Fully paid validation is completed ' || l_module_status);
2121:
2122: IF l_fail_count > 0 THEN
2123: l_validation_status := c_result_type_FAILURE;

Line 2132: fnd_file.put_line(FND_FILE.LOG,'Validation Status : ' || l_validation_status);

2128: END IF;
2129:
2130: l_progress := 95;
2131: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_validation_status ' || l_validation_status);
2132: fnd_file.put_line(FND_FILE.LOG,'Validation Status : ' || l_validation_status);
2133:
2134: UPDATE po_multi_mod_requests
2135: SET VALIDATION_STATUS = l_validation_status
2136: WHERE MULTI_MOD_REQUEST_ID = p_req_id;

Line 2146: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');

2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: errbuf := sqlerrm;
2145: retcode := '2';
2146: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
2147: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
2148: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'validate_manage_closeout : when others exception at '
2149: || l_progress || ';' || SQLERRM );
2150:

Line 2147: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

2143: WHEN OTHERS THEN
2144: errbuf := sqlerrm;
2145: retcode := '2';
2146: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
2147: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
2148: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'validate_manage_closeout : when others exception at '
2149: || l_progress || ';' || SQLERRM );
2150:
2151: END validate_mass_closeout;

Line 2214: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

2210: IF (PO_LOG.d_proc) THEN
2211: PO_LOG.proc_begin(d_module);
2212: END IF;
2213:
2214: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
2215: p_orig_system:= 'PER';
2216: OPEN clmAwardAdmins;
2217: LOOP
2218: FETCH clmAwardAdmins INTO l_admin_id;

Line 2233: fnd_file.put_line(FND_FILE.LOG,'Filtering documents for administrator ' || l_user_display_name);

2229: l_messages := ' ';
2230: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'processing started for admin ' || l_admin_id);
2231: WF_DIRECTORY.GetUserName(p_orig_system, l_admin_id, l_username, l_user_display_name);
2232: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_username ' || l_username);
2233: fnd_file.put_line(FND_FILE.LOG,'Filtering documents for administrator ' || l_user_display_name);
2234: SELECT clm_document_number, comments,doc_type,status,supplier,totAmt,currency_code
2235: BULK COLLECT INTO l_doc_num_tbl,l_comments_tbl,l_doc_type_tbl,
2236: l_doc_status_tbl,l_supplier_tbl,l_tot_amt_tbl,
2237: l_doc_curr_tbl

Line 2345: fnd_file.put_line(FND_FILE.LOG,'Notification initiated for this administrator');

2341: wf_notification.Setattrtext(nid => l_notification_id,
2342: aname => 'MESSAGE_BODY',
2343: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_eligible_doc_notfn_body/'|| l_messages ||'#' );
2344: l_progress := 30;
2345: fnd_file.put_line(FND_FILE.LOG,'Notification initiated for this administrator');
2346: --dbms_lob.close(l_document);
2347: ELSE
2348: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'There are no valid documents to closeout for this administrator');
2349: fnd_file.put_line(FND_FILE.LOG,'There are no valid documents to closeout for this administrator');

Line 2349: fnd_file.put_line(FND_FILE.LOG,'There are no valid documents to closeout for this administrator');

2345: fnd_file.put_line(FND_FILE.LOG,'Notification initiated for this administrator');
2346: --dbms_lob.close(l_document);
2347: ELSE
2348: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'There are no valid documents to closeout for this administrator');
2349: fnd_file.put_line(FND_FILE.LOG,'There are no valid documents to closeout for this administrator');
2350: END IF;
2351:
2352: END LOOP;
2353: CLOSE clmAwardAdmins;

Line 2355: fnd_file.put_line(FND_FILE.LOG,'Process Completed');

2351:
2352: END LOOP;
2353: CLOSE clmAwardAdmins;
2354: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2355: fnd_file.put_line(FND_FILE.LOG,'Process Completed');
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: errbuf := sqlerrm;
2359: retcode := '2';

Line 2360: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');

2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: errbuf := sqlerrm;
2359: retcode := '2';
2360: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
2361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
2362: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'when others exception at '
2363: || l_progress || ';' || SQLERRM );
2364: END eligible_docs_for_closeout;

Line 2361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

2357: WHEN OTHERS THEN
2358: errbuf := sqlerrm;
2359: retcode := '2';
2360: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error occurred during this process');
2361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
2362: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'when others exception at '
2363: || l_progress || ';' || SQLERRM );
2364: END eligible_docs_for_closeout;
2365: