DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on FND_FILE

Line 29: FND_FILE.put_line(FND_FILE.log,x_msg_data);

25: p_data => x_msg_data_temp,
26: p_msg_index_out => l_msg_index_out);
27: x_msg_data := x_msg_data || x_msg_data_temp;
28: End Loop;
29: FND_FILE.put_line(FND_FILE.log,x_msg_data);
30: fnd_msg_pub.delete_msg;
31: g_retcode := 1;
32: End if;
33: End;

Line 295: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Processing Effectivity==='||l_ump_rec.unit_effectivity_id);

291: Fetch c_ump into l_ump_rec;
292: Exit When c_ump%NOTFOUND;
293: --- reuse the savepoint to rollback or commit transaction for each UMP
294: SAVEPOINT Generate_SR_Tasks_PVT;
295: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Processing Effectivity==='||l_ump_rec.unit_effectivity_id);
296:
297: l_product_number := l_ump_rec.instance_number;
298: l_serial_number := l_ump_rec.serial_number;
299:

Line 332: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Processing Instance Number='||l_service_request_rec.customer_product_id);

328:
329: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
330: l_service_request_rec.ship_to_party_id := l_ump_rec.shipto_party_id;
331:
332: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Processing Instance Number='||l_service_request_rec.customer_product_id);
333: /* rhungund - note
334: Adding the following 2 rec parameters to address bug 4379140
335: */
336: l_service_request_rec.bill_to_account_id := l_ump_rec.owner_party_account_id;

Line 367: --FND_FILE.put_line(FND_FILE.log,'MESSAGE: install_site_id*='||l_service_request_rec.install_site_id);

363:
364:
365: END IF;
366:
367: --FND_FILE.put_line(FND_FILE.log,'MESSAGE: install_site_id*='||l_service_request_rec.install_site_id);
368:
369:
370: -- Get bill to and ship to sites
371: l_billto_site_id := null;

Line 432: FND_FILE.put_line(FND_FILE.log,'MESSAGE: before calling cs_servicerequest_pub.Create_ServiceRequest API');

428: Update_ServiceRequest() API has no such restriction as it's create counterpart does.
429:
430: The Update_ServiceRequest() API is also newly added to address the same ER.
431: */
432: FND_FILE.put_line(FND_FILE.log,'MESSAGE: before calling cs_servicerequest_pub.Create_ServiceRequest API');
433:
434: IF (nvl(l_primary_contact,'N') = 'N') THEN
435:
436: cs_servicerequest_pub.Create_ServiceRequest

Line 492: FND_FILE.put_line(FND_FILE.log,'MESSAGE: after calling cs_servicerequest_pub.Create_ServiceRequest API x_return_status='||x_return_status);

488: x_group_owner => x_group_owner,
489: x_individual_type => x_individual_type );
490:
491: END IF;
492: FND_FILE.put_line(FND_FILE.log,'MESSAGE: after calling cs_servicerequest_pub.Create_ServiceRequest API x_return_status='||x_return_status);
493:
494: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
495: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
496: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);

Line 638: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after create task x_return_status !='||x_return_status);

634: p_planned_start_date => nvl(l_ump_rec.earliest_due_date,l_ump_rec.due_date),
635: p_planned_end_date => to_date(nvl(l_ump_rec.latest_due_date,l_ump_rec.due_date)
636: || ' 23:59:59', 'dd-mon-yy hh24:mi:ss'),
637: p_timezone_id => l_service_request_rec.time_zone_id);
638: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after create task x_return_status !='||x_return_status);
639: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
640: fnd_message.set_name('CSF','CSF_PM_TASK_CREATION_ERROR');
641: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
642: fnd_message.set_token('VALUE2',l_route_rec.route_id);

Line 677: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after commit');

673:
674: If task_created Then
675: -- If 1=1 Then
676: COMMIT WORK;
677: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after commit');
678: -- Customer confirmation process
679: -- Get customer cofirmation flag from contracts
680: oks_pm_entitlements_pub.Get_PM_Confirmation
681: (p_api_version => 1.0

Line 875: FND_FILE.put_line(FND_FILE.log,'MESSAGE: End of loop of UMPs !!! ');

871: End If;
872:
873:
874: END LOOP;
875: FND_FILE.put_line(FND_FILE.log,'MESSAGE: End of loop of UMPs !!! ');
876:
877: If not fnd_profile.save('CSFPM_LAST_RUN_DATE',trunc(sysdate),'SITE') Then
878:
879:

Line 896: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');

892: );
893: retcode := g_retcode;
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');
897: retcode := 1;
898: errbuf := X_Msg_Data;
899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME

Line 908: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');

904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');
909: retcode := 1;
910: errbuf := X_Msg_Data;
911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME

Line 920: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 3');

916: ,X_MSG_COUNT => X_MSG_COUNT
917: ,X_MSG_DATA => X_MSG_DATA
918: ,X_RETURN_STATUS => X_RETURN_STATUS);
919: WHEN OTHERS THEN
920: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 3');
921: retcode := 1;
922: errbuf := X_Msg_Data;
923: l_sqlcode := SQLCODE;
924: l_sqlerrm := SQLERRM;