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 283: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);

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

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

431: END IF; -- End of autosubmit mode.
432:
433: -- Open restrictions cursor and store it into a table.
434: --
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
438:
439: OPEN cs_chg_restriction_rules;

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

432:
433: -- Open restrictions cursor and store it into a table.
434: --
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
438:
439: OPEN cs_chg_restriction_rules;
440: LOOP

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

433: -- Open restrictions cursor and store it into a table.
434: --
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start of Restrictions');
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
438:
439: OPEN cs_chg_restriction_rules;
440: LOOP
441: j := j+1;

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

448: l_rest1 := ('Restriction:' || RestrulesTab(j).restriction_type || ' '|| 'Currency:' || RestrulesTab(j).currency_code);
449: l_rest2 := ('Amount:' || RestrulesTab(j).Value_Amount || ' '|| 'Value_Object_Id:' || RestrulesTab(j).Value_Object_Id);
450: l_rest3 := ('Start_Date:' || RestrulesTab(j).Start_Date_Active || ' '|| 'End_Date: ' || RestrulesTab(j).End_Date_Active);
451:
452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_rest1 || l_rest2 || l_rest3);
453:
454: END LOOP;
455: CLOSE cs_chg_restriction_rules;
456:

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

453:
454: END LOOP;
455: CLOSE cs_chg_restriction_rules;
456:
457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
460:
461: --

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

454: END LOOP;
455: CLOSE cs_chg_restriction_rules;
456:
457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
460:
461: --
462: -- Fetch all charge lines into a table

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

455: CLOSE cs_chg_restriction_rules;
456:
457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End of Restrictions');
459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '***********************************');
460:
461: --
462: -- Fetch all charge lines into a table
463: LOOP

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

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

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

1240: p_data=>x_msg_data,
1241: p_msg_index_out=> l_msg_index_out);
1242:
1243: -- Recording exceptions in the log file.
1244: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1245: END IF;
1246:
1247: END Auto_Submit_Chg_Lines;
1248: --

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

1312: p_data=>lx_msg_data,
1313: p_msg_index_out=> l_msg_index_out);
1314:
1315: -- Recording the message for concurrent program output.
1316: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || p_incident_number);
1317: FND_FILE.PUT_LINE(FND_FILE.output, lx_msg_data);
1318:
1319:
1320: IF p_restriction_type = 'LINE' THEN

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

1313: p_msg_index_out=> l_msg_index_out);
1314:
1315: -- Recording the message for concurrent program output.
1316: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || p_incident_number);
1317: FND_FILE.PUT_LINE(FND_FILE.output, lx_msg_data);
1318:
1319:
1320: IF p_restriction_type = 'LINE' THEN
1321:

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

1386: p_data=>x_msg_data,
1387: p_msg_index_out=> l_msg_index_out);
1388:
1389: -- Recording exceptions in the log file.
1390: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1391:
1392:
1393: END Update_Charge_Lines;
1394:

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

1427: END IF;
1428:
1429:
1430: -- Recording the message for concurrent program output.
1431: FND_FILE.PUT_LINE(FND_FILE.output,'Service Request Number:' || l_incident_number);
1432: --
1433: -- dbms_output.put_line('Calling submit_order');
1434:
1435: CS_Charge_Create_Order_PUB.Submit_Order(

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

1458: p_data => x_msg_data,
1459: p_msg_index_out => l_msg_index_out );
1460:
1461: -- logging messages returned by the submit order API.
1462: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);
1463:
1464: END LOOP;
1465: END IF;
1466: END IF;

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

1483: p_data=>x_msg_data,
1484: p_msg_index_out=> l_msg_index_out);
1485:
1486: -- Recording exceptions in the log file.
1487: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1488:
1489: END Submit_Charge_Lines;
1490:
1491:

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

1535: lx_msg_count NUMBER;
1536:
1537:
1538: BEGIN
1539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1542:
1543:

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

1536:
1537:
1538: BEGIN
1539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1542:
1543:
1544: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1537:
1538: BEGIN
1539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1542:
1543:
1544: x_return_status := FND_API.G_RET_STS_SUCCESS;
1545: x_restriction_qualify_flag := 'N';

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

1570: FND_MSG_PUB.get(p_encoded => 'F',
1571: p_data=>l_msg_data,
1572: p_msg_index_out=> l_msg_index_out);
1573:
1574: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1575: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1576: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1577: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1578:

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

1571: p_data=>l_msg_data,
1572: p_msg_index_out=> l_msg_index_out);
1573:
1574: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1575: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1576: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1577: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1578:
1579: Update_Charge_Lines(p_incident_id,

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

1572: p_msg_index_out=> l_msg_index_out);
1573:
1574: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1575: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1576: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1577: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1578:
1579: Update_Charge_Lines(p_incident_id,
1580: p_incident_number,

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

1596: FND_MSG_PUB.get(p_encoded => 'F',
1597: p_data=>l_msg_data,
1598: p_msg_index_out=> l_msg_index_out);
1599:
1600: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1601: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1602: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1603: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1604:

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

1597: p_data=>l_msg_data,
1598: p_msg_index_out=> l_msg_index_out);
1599:
1600: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1601: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1602: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1603: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1604:
1605:

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

1598: p_msg_index_out=> l_msg_index_out);
1599:
1600: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);
1601: FND_FILE.put_line(FND_FILE.LOG,'Estimate Detail ID:' || p_estimate_detail_id);
1602: FND_FILE.put_line(FND_FILE.LOG,l_msg_data);
1603: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
1604:
1605:
1606: Update_Charge_Lines(p_incident_id,

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

1635: p_data => x_msg_data,
1636: p_msg_index_out => l_msg_index_out );
1637:
1638: -- logging messages returned by the submit order API.
1639: fnd_file.put_line(FND_FILE.OUTPUT,x_msg_data);
1640:
1641: END LOOP;
1642: END IF;
1643:

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

1643:
1644:
1645: END IF; --for return status. we will do nothing if return_status is other than E or U.
1646:
1647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1650:
1651: EXCEPTION

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

1644:
1645: END IF; --for return status. we will do nothing if return_status is other than E or U.
1646:
1647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN

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

1645: END IF; --for return status. we will do nothing if return_status is other than E or U.
1646:
1647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exiting Debrief_Status_Check');
1649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1661: p_data=>x_msg_data,
1662: p_msg_index_out=> l_msg_index_out);
1663:
1664: -- Recording exceptions in the log file.
1665: FND_FILE.put_line(FND_FILE.LOG,x_msg_data);
1666:
1667:
1668: END Check_Debrief_Status;
1669: