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

Line 32: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');

28: conc_status BOOLEAN;
29:
30: BEGIN
31:
32: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
33: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Starting Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
34: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
35:
36: --added for r12 to populate temporary tables

Line 33: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Starting Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

29:
30: BEGIN
31:
32: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
33: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Starting Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
34: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
35:
36: --added for r12 to populate temporary tables
37: MO_GLOBAL.INIT('CS_CHARGES') ;

Line 34: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');

30: BEGIN
31:
32: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
33: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Starting Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
34: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'***************************************************************************************************');
35:
36: --added for r12 to populate temporary tables
37: MO_GLOBAL.INIT('CS_CHARGES') ;
38:

Line 51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');

47: THEN
48: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
49: END IF;
50:
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Completed Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
54:
55: END Main_Procedure;

Line 52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Completed Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

48: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
49: END IF;
50:
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Completed Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
54:
55: END Main_Procedure;
56:

Line 53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');

49: END IF;
50:
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Completed Concurrent Program for autosubmitting Charge Lines: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'*****************************************************************************************************');
54:
55: END Main_Procedure;
56:
57: /*--

Line 285: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

281: p_data=>x_msg_data,
282: p_msg_index_out=> l_msg_index_out);
283:
284: -- Recording exceptions in the log file.
285: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
286:
287: END;
288:
289:

Line 441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

437: END IF; -- End of autosubmit mode.
438:
439: -- Open restrictions cursor and store it into a table.
440: --
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
444:
445: OPEN cs_chg_restriction_rules;

Line 442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');

438:
439: -- Open restrictions cursor and store it into a table.
440: --
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
444:
445: OPEN cs_chg_restriction_rules;
446: LOOP

Line 443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

439: -- Open restrictions cursor and store it into a table.
440: --
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
444:
445: OPEN cs_chg_restriction_rules;
446: LOOP
447: j := j+1;

Line 458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_rest1 || l_rest2 || l_rest3);

454: l_rest1 := ('Restriction:' || RestrulesTab(j).restriction_type || ' '|| 'Currency:' || RestrulesTab(j).currency_code);
455: l_rest2 := ('Amount:' || RestrulesTab(j).Value_Amount || ' '|| 'Value_Object_Id:' || RestrulesTab(j).Value_Object_Id);
456: l_rest3 := ('Start_Date:' || RestrulesTab(j).Start_Date_Active || ' '|| 'End_Date: ' || RestrulesTab(j).End_Date_Active);
457:
458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_rest1 || l_rest2 || l_rest3);
459:
460: END LOOP;
461: CLOSE cs_chg_restriction_rules;
462:

Line 463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');

459:
460: END LOOP;
461: CLOSE cs_chg_restriction_rules;
462:
463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
466:
467: --

Line 464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');

460: END LOOP;
461: CLOSE cs_chg_restriction_rules;
462:
463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
466:
467: --
468: -- Fetch all charge lines into a table

Line 465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');

461: CLOSE cs_chg_restriction_rules;
462:
463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
466:
467: --
468: -- Fetch all charge lines into a table
469: LOOP

Line 1237: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');

1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: IF l_found = 'N' THEN
1237: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');
1238: ELSE
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');

Line 1250: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

1246: p_data=>x_msg_data,
1247: p_msg_index_out=> l_msg_index_out);
1248:
1249: -- Recording exceptions in the log file.
1250: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1251: END IF;
1252:
1253: END Auto_Submit_Chg_Lines;
1254: --

Line 1326: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || p_incident_number);

1322: p_data=>lx_msg_data,
1323: p_msg_index_out=> l_msg_index_out);
1324:
1325: -- Recording the message for concurrent program output.
1326: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || p_incident_number);
1327: FND_FILE.PUT_LINE(FND_FILE.output, lx_msg_data);
1328:
1329:
1330: IF p_restriction_type = 'LINE' THEN

Line 1327: FND_FILE.PUT_LINE(FND_FILE.output, lx_msg_data);

1323: p_msg_index_out=> l_msg_index_out);
1324:
1325: -- Recording the message for concurrent program output.
1326: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || p_incident_number);
1327: FND_FILE.PUT_LINE(FND_FILE.output, lx_msg_data);
1328:
1329:
1330: IF p_restriction_type = 'LINE' THEN
1331:

Line 1409: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

1405: p_data=>x_msg_data,
1406: p_msg_index_out=> l_msg_index_out);
1407:
1408: -- Recording exceptions in the log file.
1409: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1410:
1411:
1412: END Update_Charge_Lines;
1413:

Line 1450: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || l_incident_number);

1446: END IF;
1447:
1448:
1449: -- Recording the message for concurrent program output.
1450: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || l_incident_number);
1451: --
1452: -- dbms_output.put_line('Calling submit_order');
1453:
1454: CS_Charge_Create_Order_PUB.Submit_Order(

Line 1481: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);

1477: p_data => x_msg_data,
1478: p_msg_index_out => l_msg_index_out );
1479:
1480: -- logging messages returned by the submit order API.
1481: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);
1482:
1483: END LOOP;
1484: END IF;
1485: END IF;

Line 1506: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

1502: p_data=>x_msg_data,
1503: p_msg_index_out=> l_msg_index_out);
1504:
1505: -- Recording exceptions in the log file.
1506: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1507:
1508: END Submit_Charge_Lines;
1509:
1510:

Line 1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

1554: lx_msg_count NUMBER;
1555:
1556:
1557: BEGIN
1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1561:
1562:

Line 1559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');

1555:
1556:
1557: BEGIN
1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1561:
1562:
1563: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

1556:
1557: BEGIN
1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1561:
1562:
1563: x_return_status := FND_API.G_RET_STS_SUCCESS;
1564: x_restriction_qualify_flag := 'N';

Line 1593: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);

1589: FND_MSG_PUB.get(p_encoded => 'F',
1590: p_data=>l_msg_data,
1591: p_msg_index_out=> l_msg_index_out);
1592:
1593: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1594: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1595: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1596: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1597:

Line 1594: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);

1590: p_data=>l_msg_data,
1591: p_msg_index_out=> l_msg_index_out);
1592:
1593: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1594: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1595: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1596: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1597:
1598: Update_Charge_Lines(p_incident_id,

Line 1595: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);

1591: p_msg_index_out=> l_msg_index_out);
1592:
1593: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1594: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1595: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1596: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1597:
1598: Update_Charge_Lines(p_incident_id,
1599: p_incident_number,

Line 1619: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);

1615: FND_MSG_PUB.get(p_encoded => 'F',
1616: p_data=>l_msg_data,
1617: p_msg_index_out=> l_msg_index_out);
1618:
1619: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1620: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1621: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1622: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1623:

Line 1620: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);

1616: p_data=>l_msg_data,
1617: p_msg_index_out=> l_msg_index_out);
1618:
1619: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1620: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1621: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1622: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1623:
1624:

Line 1621: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);

1617: p_msg_index_out=> l_msg_index_out);
1618:
1619: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1620: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1621: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1622: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1623:
1624:
1625: Update_Charge_Lines(p_incident_id,

Line 1658: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);

1654: p_data => x_msg_data,
1655: p_msg_index_out => l_msg_index_out );
1656:
1657: -- logging messages returned by the submit order API.
1658: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);
1659:
1660: END LOOP;
1661: END IF;
1662:

Line 1666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

1662:
1663:
1664: END IF; --for return status. we will do nothing if return_status is other than E or U.
1665:
1666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1669:
1670: EXCEPTION

Line 1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');

1663:
1664: END IF; --for return status. we will do nothing if return_status is other than E or U.
1665:
1666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN

Line 1668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');

1664: END IF; --for return status. we will do nothing if return_status is other than E or U.
1665:
1666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1684: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

1680: p_data=>x_msg_data,
1681: p_msg_index_out=> l_msg_index_out);
1682:
1683: -- Recording exceptions in the log file.
1684: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1685:
1686:
1687: END Check_Debrief_Status;
1688: