DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on FND_FILE

Line 1085: FND_FILE.put_line(FND_FILE.log,l_msg_data);

1081: if l_msg_count > 0 then
1082: FOR counter IN REVERSE 1..l_msg_count
1083: LOOP
1084: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1085: FND_FILE.put_line(FND_FILE.log,l_msg_data);
1086: end loop;
1087: end if;
1088: l_charges_interface_status := 'FAILED';
1089:

Line 1203: fnd_file.put_line(fnd_file.log,l_msg_data);

1199: if l_msg_count > 0 then --1
1200: FOR counter IN REVERSE 1..l_msg_count
1201: LOOP
1202: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1203: fnd_file.put_line(fnd_file.log,l_msg_data);
1204: log('main','error1:'||l_msg_data);
1205: end loop;
1206: end if; --1
1207: l_ib_interface_status := 'FAILED';

Line 1356: fnd_file.put_line(fnd_file.log,l_msg_data);

1352: LOOP
1353: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1354: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
1355: l_msg_data := substr(l_msg_data, l_position);
1356: fnd_file.put_line(fnd_file.log,l_msg_data);
1357: log('main','error'||l_msg_data);
1358: end loop;
1359: end if;
1360: l_inv_interface_status := 'FAILED';

Line 1487: fnd_file.put_line(fnd_file.log,l_msg_data);

1483: FOR counter IN REVERSE 1..l_msg_count LOOP
1484: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1485: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
1486: l_msg_data := substr(l_msg_data, l_position);
1487: fnd_file.put_line(fnd_file.log,l_msg_data);
1488: log('main','l_msg_data:'||l_msg_data);
1489: end loop;
1490: end if;
1491: l_inv_interface_status := 'FAILED';

Line 1591: fnd_file.put_line(fnd_file.log,l_msg_data);

1587:
1588: if l_msg_count > 0 then
1589: FOR counter IN REVERSE 1..l_msg_count LOOP
1590: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1591: fnd_file.put_line(fnd_file.log,l_msg_data);
1592: log('main','error2:'||l_msg_data);
1593: end loop;
1594: end if;
1595: else

Line 1659: FND_FILE.put_line(FND_FILE.log,'l_processed_flag: '||l_processed_flag);

1655: close c_item_reservations;
1656: log('main', 'End of relieving extra and partial reservations.');
1657: end if;
1658:
1659: FND_FILE.put_line(FND_FILE.log,'l_processed_flag: '||l_processed_flag);
1660: fnd_file.put_line(fnd_file.log,'l_debrief_error_status: '||l_debrief_error_status);
1661: log('main','l_processed_flag:'||l_processed_flag||' l_debrief_error_status:'||l_debrief_error_status);
1662: if nvl(l_processed_flag,'UNPROCESSED') <> 'UNPROCESSED' then
1663: if l_processed_flag = 'COMPLETED W/ERRORS' then

Line 1660: fnd_file.put_line(fnd_file.log,'l_debrief_error_status: '||l_debrief_error_status);

1656: log('main', 'End of relieving extra and partial reservations.');
1657: end if;
1658:
1659: FND_FILE.put_line(FND_FILE.log,'l_processed_flag: '||l_processed_flag);
1660: fnd_file.put_line(fnd_file.log,'l_debrief_error_status: '||l_debrief_error_status);
1661: log('main','l_processed_flag:'||l_processed_flag||' l_debrief_error_status:'||l_debrief_error_status);
1662: if nvl(l_processed_flag,'UNPROCESSED') <> 'UNPROCESSED' then
1663: if l_processed_flag = 'COMPLETED W/ERRORS' then
1664: open c_debrief_error;

Line 1669: FND_FILE.put_line(FND_FILE.log,'l_debrief_error_status: '||l_debrief_error_status);

1665: fetch c_debrief_error into l_debrief_error_status,
1666: l_assignment_status_id,
1667: l_object_version_number;
1668: close c_debrief_error;
1669: FND_FILE.put_line(FND_FILE.log,'l_debrief_error_status: '||l_debrief_error_status);
1670: FND_FILE.put_line(FND_FILE.log,'l_assignment_status_id: '||l_assignment_status_id);
1671: fnd_file.put_line(fnd_file.log,'l_object_version_number: '||l_object_version_number);
1672: log('main','l_debrief_error_status:'||l_debrief_error_status||' l_assignment_status_id:'||l_assignment_status_id||'l_object_version_number:'||l_object_version_number);
1673: end if;

Line 1670: FND_FILE.put_line(FND_FILE.log,'l_assignment_status_id: '||l_assignment_status_id);

1666: l_assignment_status_id,
1667: l_object_version_number;
1668: close c_debrief_error;
1669: FND_FILE.put_line(FND_FILE.log,'l_debrief_error_status: '||l_debrief_error_status);
1670: FND_FILE.put_line(FND_FILE.log,'l_assignment_status_id: '||l_assignment_status_id);
1671: fnd_file.put_line(fnd_file.log,'l_object_version_number: '||l_object_version_number);
1672: log('main','l_debrief_error_status:'||l_debrief_error_status||' l_assignment_status_id:'||l_assignment_status_id||'l_object_version_number:'||l_object_version_number);
1673: end if;
1674:

Line 1671: fnd_file.put_line(fnd_file.log,'l_object_version_number: '||l_object_version_number);

1667: l_object_version_number;
1668: close c_debrief_error;
1669: FND_FILE.put_line(FND_FILE.log,'l_debrief_error_status: '||l_debrief_error_status);
1670: FND_FILE.put_line(FND_FILE.log,'l_assignment_status_id: '||l_assignment_status_id);
1671: fnd_file.put_line(fnd_file.log,'l_object_version_number: '||l_object_version_number);
1672: log('main','l_debrief_error_status:'||l_debrief_error_status||' l_assignment_status_id:'||l_assignment_status_id||'l_object_version_number:'||l_object_version_number);
1673: end if;
1674:
1675: if nvl(l_debrief_error_status,-1) <> -1 then

Line 1676: fnd_file.put_line(fnd_file.log,'Calling update_assignment_status: ');

1672: log('main','l_debrief_error_status:'||l_debrief_error_status||' l_assignment_status_id:'||l_assignment_status_id||'l_object_version_number:'||l_object_version_number);
1673: end if;
1674:
1675: if nvl(l_debrief_error_status,-1) <> -1 then
1676: fnd_file.put_line(fnd_file.log,'Calling update_assignment_status: ');
1677: log('main','calling update_assignment_status');
1678: csf_task_assignments_pub.update_assignment_status
1679: ( p_api_version => 1.0
1680: , p_init_msg_list => null

Line 1693: fnd_file.put_line(fnd_file.log,'l_return_status: '||l_return_status);

1689: , x_msg_data => l_msg_data
1690: , x_task_object_version_number => l_task_object_version_number
1691: , x_task_status_id => l_task_status_id
1692: ) ;
1693: fnd_file.put_line(fnd_file.log,'l_return_status: '||l_return_status);
1694: log('main','l_return_status:'||l_return_status);
1695: if l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then
1696: retcode := 1;
1697:

Line 1701: fnd_file.put_line(fnd_file.log,l_msg_data);

1697:
1698: if l_msg_count > 0 then
1699: FOR counter IN REVERSE 1..l_msg_count LOOP
1700: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1701: fnd_file.put_line(fnd_file.log,l_msg_data);
1702: log('main','error3:'||l_msg_data);
1703: end loop;
1704: end if;
1705: else

Line 1724: fnd_file.put_line(fnd_file.log, l_msg_data);

1720: FND_MESSAGE.Set_Token('DEBRIEF_NUMBER',l_debrief_number);
1721: FND_MSG_PUB.ADD;
1722: l_msg_data := FND_MSG_PUB.Get(p_msg_index => fnd_msg_pub.G_LAST,
1723: p_encoded => FND_API.G_FALSE);
1724: fnd_file.put_line(fnd_file.log, l_msg_data);
1725: l_conc_result := fnd_concurrent.set_completion_status('WARNING','Warning');
1726: exit;
1727: end if;
1728: end loop;

Line 1743: fnd_file.put_line(fnd_file.log,l_msg_data);

1739: when e_no_header_id then
1740: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER_ID');
1741: fnd_msg_pub.add;
1742: fnd_msg_pub.get(1,FND_API.G_FALSE,l_msg_data,l1);
1743: fnd_file.put_line(fnd_file.log,l_msg_data);
1744: log('main','error4:'||l_msg_data);
1745: retcode := 2;
1746: errbuf := l_msg_data;
1747:

Line 1752: fnd_file.put_line(fnd_file.log,l_message);

1748: when others then
1749: retcode := 2;
1750: errbuf := sqlerrm;
1751: l_message := errbuf;
1752: fnd_file.put_line(fnd_file.log,l_message);
1753: log('main','error5:'||l_msg_data);
1754: end;
1755:
1756: ---------------------------------------------------------------------------