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

Line 808: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted batch is '||p_batch_header_id);

804: BEGIN
805:
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted batch is '||p_batch_header_id);
809:
810: SAVEPOINT process_batch_adjust_claim_sv;
811:
812:

Line 817: FND_FILE.PUT_LINE(FND_FILE.LOG, '- imd_claim_flag for batch is '||l_imd_claim_flag );

813: SELECT status_code,imd_claim_flag into l_status_code,l_imd_claim_flag
814: FROM OZF_SD_BATCH_HEADERS_ALL
815: WHERE BATCH_ID=p_batch_header_id ;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, '- imd_claim_flag for batch is '||l_imd_claim_flag );
818: FND_FILE.PUT_LINE(FND_FILE.LOG, '- for batch id '||p_batch_header_id||' status code is'||l_status_code);
819:
820: --If partial approved is allowed for a batch then on batch closure we just do adjustments
821: IF l_imd_claim_flag ='Y' THEN

Line 818: FND_FILE.PUT_LINE(FND_FILE.LOG, '- for batch id '||p_batch_header_id||' status code is'||l_status_code);

814: FROM OZF_SD_BATCH_HEADERS_ALL
815: WHERE BATCH_ID=p_batch_header_id ;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, '- imd_claim_flag for batch is '||l_imd_claim_flag );
818: FND_FILE.PUT_LINE(FND_FILE.LOG, '- for batch id '||p_batch_header_id||' status code is'||l_status_code);
819:
820: --If partial approved is allowed for a batch then on batch closure we just do adjustments
821: IF l_imd_claim_flag ='Y' THEN
822:

Line 836: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_full_write_off '||l_full_write_off);

832:
833:
834: l_full_write_off := fnd_api.g_true;
835:
836: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_full_write_off '||l_full_write_off);
837:
838: create_adjustment(p_batch_header_id =>p_batch_header_id,
839: p_comp_wrt_off=> l_full_write_off,
840: x_return_status=> x_return_status,

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Status of Adjustment API call '||x_return_status);

841: x_msg_count=> x_msg_count,
842: x_msg_data=> x_msg_data);
843:
844:
845: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Status of Adjustment API call '||x_return_status);
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS AND l_full_write_off = fnd_api.g_FALSE THEN
848:
849: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;

Line 853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

849: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;
850:
851: FOR I IN 1..x_msg_count LOOP
852:
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
854: ' Msg from Claim API while invoking claim for batch '
855: || SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
856:
857: END LOOP;

Line 862: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjustment completed');

858:
859: RETURN;
860: END IF;
861:
862: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjustment completed');
863:
864: ELSE
865:
866: -- Check if the sum is negative

Line 961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');

957: IF(l_approved_line_count = l_total_line_count) THEN
958:
959: l_full_write_off := fnd_api.g_true;
960:
961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');
962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);
963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);
964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);

Line 962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);

958:
959: l_full_write_off := fnd_api.g_true;
960:
961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');
962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);
963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);
964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);
966:

Line 963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);

959: l_full_write_off := fnd_api.g_true;
960:
961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');
962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);
963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);
964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);
966:
967:

Line 964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);

960:
961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');
962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);
963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);
964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);
966:
967:
968: -- Only for WIP batch create claim

Line 965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);

961: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved');
962: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_approved_line_count '||l_approved_line_count);
963: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_total_line_count '||l_total_line_count);
964: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_app_line_count '||l_orig_app_line_count);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_orig_total_line_count '||l_orig_total_line_count);
966:
967:
968: -- Only for WIP batch create claim
969: IF (l_orig_app_line_count <> l_orig_total_line_count) THEN

Line 974: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved and processing the claim');

970:
971: l_full_write_off := fnd_api.g_FALSE ;
972: l_create_claim := fnd_api.g_true;
973:
974: FND_FILE.PUT_LINE(FND_FILE.LOG, '- All the lines are approved and processing the claim');
975:
976: OZF_SD_BATCH_FEED_PVT.process_claim(p_batch_header_id,
977: x_return_status,
978: x_msg_data,l_claim_id);

Line 980: FND_FILE.PUT_LINE(FND_FILE.LOG, ' - Status of claim API call '||x_return_status);

976: OZF_SD_BATCH_FEED_PVT.process_claim(p_batch_header_id,
977: x_return_status,
978: x_msg_data,l_claim_id);
979:
980: FND_FILE.PUT_LINE(FND_FILE.LOG, ' - Status of claim API call '||x_return_status);
981:
982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;
984:

Line 985: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);

981:
982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;
984:
985: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
986:
987: RETURN ;
988: END IF ;
989:

Line 990: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -Claim created successfully ');

986:
987: RETURN ;
988: END IF ;
989:
990: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -Claim created successfully ');
991:
992: end if ;
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claiing the create Adjustment API ');

Line 994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claiing the create Adjustment API ');

990: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -Claim created successfully ');
991:
992: end if ;
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claiing the create Adjustment API ');
995: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_full_write_off '||l_full_write_off);
996:
997: create_adjustment(p_batch_header_id =>p_batch_header_id,
998: p_comp_wrt_off=> l_full_write_off,

Line 995: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_full_write_off '||l_full_write_off);

991:
992: end if ;
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claiing the create Adjustment API ');
995: FND_FILE.PUT_LINE(FND_FILE.LOG, '- l_full_write_off '||l_full_write_off);
996:
997: create_adjustment(p_batch_header_id =>p_batch_header_id,
998: p_comp_wrt_off=> l_full_write_off,
999: x_return_status=> x_return_status,

Line 1004: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Status of Adjustment API call '||x_return_status);

1000: x_msg_count=> x_msg_count,
1001: x_msg_data=> x_msg_data);
1002:
1003:
1004: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Status of Adjustment API call '||x_return_status);
1005:
1006: IF x_return_status <> FND_API.G_RET_STS_SUCCESS AND l_full_write_off = fnd_api.g_FALSE THEN
1007:
1008: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;

Line 1012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

1008: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;
1009:
1010: FOR I IN 1..x_msg_count LOOP
1011:
1012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1013: ' Msg from Claim API while invoking claim for batch '
1014: || SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1015:
1016: END LOOP;

Line 1025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -Raised life cycle business event ');

1021: IF (l_create_claim=fnd_api.g_true) THEN
1022:
1023: sd_raise_event (p_batch_header_id, 'CLAIM', x_return_status);
1024:
1025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -Raised life cycle business event ');
1026:
1027:
1028: END IF ;
1029:

Line 1031: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjustment completed');

1027:
1028: END IF ;
1029:
1030:
1031: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjustment completed');
1032:
1033:
1034:
1035: else

Line 1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Few or all lines are not ');

1034:
1035: else
1036:
1037:
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Few or all lines are not ');
1039:
1040: if (l_approved_line_count > 0) THEN
1041:
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Few lines are approved - Calling create child batch');

Line 1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Few lines are approved - Calling create child batch');

1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Few or all lines are not ');
1039:
1040: if (l_approved_line_count > 0) THEN
1041:
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Few lines are approved - Calling create child batch');
1043:
1044:
1045: OZF_SD_BATCH_FEED_PVT.PROCESS_CHILD_BATCH(p_batch_header_id,x_return_status,x_msg_data) ;
1046:

Line 1047: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Process child batch returned status '||x_return_status);

1043:
1044:
1045: OZF_SD_BATCH_FEED_PVT.PROCESS_CHILD_BATCH(p_batch_header_id,x_return_status,x_msg_data) ;
1046:
1047: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Process child batch returned status '||x_return_status);
1048: End if;
1049:
1050: -- The unapproved lines, with complete flag true, the complete write off would happen
1051: l_full_write_off := fnd_api.g_true ;

Line 1053: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjusting the lines of the current batch');

1049:
1050: -- The unapproved lines, with complete flag true, the complete write off would happen
1051: l_full_write_off := fnd_api.g_true ;
1052:
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjusting the lines of the current batch');
1054:
1055:
1056: create_adjustment(p_batch_header_id =>p_batch_header_id,
1057: p_comp_wrt_off=> l_full_write_off,

Line 1063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjusted the batch '||x_return_status);

1059: x_msg_count=> x_msg_count,
1060: x_msg_data=> x_msg_data);
1061:
1062:
1063: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjusted the batch '||x_return_status);
1064:
1065: end if ;
1066:
1067: END IF;

Line 1097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Changing status to Closed');

1093: ) rma_lines ;
1094:
1095: IF (l_unapproved_line_count = 0 ) THEN
1096:
1097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Changing status to Closed');
1098:
1099:
1100: UPDATE ozf_sd_batch_headers_all
1101: SET status_code = 'CLOSED'

Line 1115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected exception is :' || sqlerrm);

1111:
1112: WHEN OTHERS then
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected exception is :' || sqlerrm);
1116:
1117: ROLLBACK TO SAVEPOINT process_batch_adjust_claim_sv;
1118: RETURN;
1119:

Line 1197: FND_FILE.PUT_LINE(FND_FILE.LOG, p_batch_header_id||' - Submitted for adjustment');

1193:
1194: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1195:
1196:
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, p_batch_header_id||' - Submitted for adjustment');
1198:
1199:
1200: FOR adj_rec IN c_batch_details
1201: LOOP

Line 1212: FND_FILE.PUT_LINE(FND_FILE.LOG, p_batch_header_id||' - Line for adjustment is '||adj_rec.batch_line_id);

1208: IF(adj_rec.adj_amount<>0) THEN
1209:
1210:
1211:
1212: FND_FILE.PUT_LINE(FND_FILE.LOG, p_batch_header_id||' - Line for adjustment is '||adj_rec.batch_line_id);
1213:
1214:
1215: l_act_util_rec.adjustment_type := adj_rec.adj_type_name; --'DECREASE_EARNED';
1216: l_act_util_rec.adjustment_type_id := adj_rec.ADJUSTMENT_TYPE_ID;

Line 1260: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||'-'||adj_rec.batch_line_id||' Return staus for ASJ private call '||x_return_status );

1256: ,x_utilization_id => l_new_util_id
1257: );
1258:
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||'-'||adj_rec.batch_line_id||' Return staus for ASJ private call '||x_return_status );
1261:
1262:
1263:
1264: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1307: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' -Utilization created for line '||adj_rec.batch_line_id );

1303:
1304: END IF;
1305:
1306:
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' -Utilization created for line '||adj_rec.batch_line_id );
1308:
1309:
1310: END IF ;
1311: END LOOP;

Line 1315: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' -Adjustment completed '||x_return_status );

1311: END LOOP;
1312:
1313:
1314:
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' -Adjustment completed '||x_return_status );
1316: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1317:
1318: EXCEPTION
1319:

Line 1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected exception is :' || sqlerrm);

1319:
1320: WHEN OTHERS then
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected exception is :' || sqlerrm);
1324:
1325:
1326: RETURN;
1327:

Line 1367: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Processing for batch '|| p_batch_id || ' for closure.');

1363: and bh.batch_id = p_batch_id;
1364:
1365: BEGIN
1366:
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Processing for batch '|| p_batch_id || ' for closure.');
1368:
1369:
1370: OPEN c_pen_close_batches (p_batch_id);
1371: FETCH c_pen_close_batches into l_status_code, l_request_id, l_phase_code;

Line 1375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current Status of batch is '|| l_status_code);

1371: FETCH c_pen_close_batches into l_status_code, l_request_id, l_phase_code;
1372: CLOSE c_pen_close_batches;
1373:
1374:
1375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current Status of batch is '|| l_status_code);
1376:
1377: -- True when the request in BH not found in FND_Concurrent_Reqeusts / The current request is the request tagged in BH / Last request has finshed processing.
1378: IF ( l_status_code ='PENDING_CLOSE'
1379: AND ( l_request_id is null OR l_request_id = FND_GLOBAL.CONC_REQUEST_ID OR l_phase_code = 'C')) THEN

Line 1390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoking api for processing Claim / Adjustment.');

1386: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1387: object_version_number = object_version_number + 1
1388: where batch_id = p_batch_id;
1389:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoking api for processing Claim / Adjustment.');
1391:
1392: PROCESS_BATCH_ADJUST_CLAIM( p_batch_header_id => p_batch_id,
1393: p_validation_level=> fnd_api.g_valid_level_full,
1394: p_init_msg_list=> fnd_api.g_false,

Line 1399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The processing for the batch is completed '|| l_return_status);

1395: x_return_status=> l_return_status ,
1396: x_msg_count=> l_msg_count ,
1397: x_msg_data=> l_msg_data ) ;
1398:
1399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The processing for the batch is completed '|| l_return_status);
1400:
1401: ELSE
1402:
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch could not be processed by this request.');

Line 1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch could not be processed by this request.');

1399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The processing for the batch is completed '|| l_return_status);
1400:
1401: ELSE
1402:
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch could not be processed by this request.');
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Either the batch is not in Pending Close state or it is currently being processed by another request.');
1405:
1406: END IF ;
1407:

Line 1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Either the batch is not in Pending Close state or it is currently being processed by another request.');

1400:
1401: ELSE
1402:
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch could not be processed by this request.');
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Either the batch is not in Pending Close state or it is currently being processed by another request.');
1405:
1406: END IF ;
1407:
1408: END PROCESS_SD_PEN_CLOSE_BATCHES ;

Line 1441: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' Unexpected exception occured ' );

1437:
1438: WHEN OTHERS then
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: FND_FILE.PUT_LINE(FND_FILE.LOG,p_batch_header_id||' Unexpected exception occured ' );
1442:
1443: RETURN;
1444:
1445: