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_API

Line 95: p_conv_rate => FND_API.G_MISS_NUM,

91: OZF_UTILITY_PVT.Convert_Currency (
92: p_from_currency => p_plan_currency,
93: p_to_currency => p_batch_currency,
94: p_conv_type => p_exchange_rate_type,
95: p_conv_rate => FND_API.G_MISS_NUM,
96: p_conv_date => p_date,
97: p_from_amount => p_amount,
98: x_return_status => x_return_status,
99: x_to_amount => x_to_amount_batch,

Line 108: p_conv_rate => FND_API.G_MISS_NUM,

104: OZF_UTILITY_PVT.Convert_Currency (
105: p_from_currency => p_plan_currency,
106: p_to_currency => p_functional_curr,
107: p_conv_type => p_exchange_rate_type,
108: p_conv_rate => FND_API.G_MISS_NUM,
109: p_conv_date => p_date,
110: p_from_amount => p_amount,
111: x_return_status => x_return_status,
112: x_to_amount => x_to_amount_func,

Line 120: p_conv_rate => FND_API.G_MISS_NUM,

116: OZF_UTILITY_PVT.Convert_Currency (
117: p_from_currency => p_functional_curr,
118: p_to_currency => p_batch_currency,
119: p_conv_type => p_exchange_rate_type,
120: p_conv_rate => FND_API.G_MISS_NUM,
121: p_conv_date => SYSDATE,
122: p_from_amount => x_to_amount_func,
123: x_return_status => x_return_status,
124: x_to_amount => x_to_amount_batch,

Line 134: p_conv_rate => FND_API.G_MISS_NUM,

130: OZF_UTILITY_PVT.Convert_Currency (
131: p_from_currency => p_plan_currency,
132: p_to_currency => p_batch_currency,
133: p_conv_type => p_exchange_rate_type,
134: p_conv_rate => FND_API.G_MISS_NUM,
135: p_conv_date => SYSDATE,
136: p_from_amount => p_amount,
137: x_return_status => x_return_status,
138: x_to_amount => x_to_amount_batch,

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172:
173: WHERE UTILIZATION_ID=l_util_id;
174:
175: DELETE FROM OZF_SD_BATCH_LINES_ALL WHERE batch_line_id=p_batch_line_id;
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: x_meaning := NULL;
178:
179:
180: EXCEPTION

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

180: EXCEPTION
181:
182: --error code will be returned to java layer where commit or rollback can happen
183: WHEN OTHERS then
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: x_meaning := NULL;
186: RETURN;
187:
188: end;

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS ;

412:
413: BEGIN
414:
415: x_msg_data := '';
416: x_return_status := FND_API.G_RET_STS_SUCCESS ;
417: l_error_message := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR') ;
418:
419: -- Validate the SDR Request Number
420: Select count(*) into l_req_number_count from OZF_SD_REQUEST_HEADERS_ALL_B

Line 426: x_return_status := FND_API.G_RET_STS_ERROR ;

422: IF l_req_number_count = 0 THEN
423:
424: l_msg_data := l_msg_data ||','|| 'The request number '||p_request_number ||' is not valid.' ;
425: x_msg_data := 'No Ship and Debit Request exists for : '||p_request_number;
426: x_return_status := FND_API.G_RET_STS_ERROR ;
427:
428: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
429: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
430:

Line 482: x_return_status := FND_API.G_RET_STS_ERROR ;

478: AND NVL(PROCESSED_FLAG,'N') <>'Y';
479:
480: l_error_count := l_error_count +1 ;
481: x_msg_data := l_error_message;
482: x_return_status := FND_API.G_RET_STS_ERROR ;
483: l_line_status := 'E' ;
484: END IF;
485:
486: -- Validate the product code

Line 499: x_return_status := FND_API.G_RET_STS_ERROR ;

495: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
496:
497: l_error_count := l_error_count +1 ;
498: x_msg_data := l_error_message;
499: x_return_status := FND_API.G_RET_STS_ERROR ;
500: l_line_status := 'E' ;
501: END IF;
502:
503: -- Validate the discount type

Line 516: x_return_status := FND_API.G_RET_STS_ERROR ;

512: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
513:
514: l_error_count := l_error_count +1 ;
515: x_msg_data := l_error_message;
516: x_return_status := FND_API.G_RET_STS_ERROR ;
517: l_line_status := 'E' ;
518: END IF;
519:
520: -- Validate the currency if not null

Line 545: x_return_status := FND_API.G_RET_STS_ERROR ;

541: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
542:
543: l_error_count := l_error_count +1 ;
544: x_msg_data := l_error_message;
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: l_line_status := 'E' ;
547: END IF;
548: END IF ;
549:

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596:
597: ELSE
598: l_msg_data := l_msg_data ||','|| 'The ststus is not pending suppler approval' ;
599: x_msg_data := 'Currently the request is not pending for supplier approval';
600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: UPDATE OZF_SD_RES_HEADER_INTF SET ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number
603: and NVL(PROCESSED_FLAG,'N') <>'Y';
604:

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: COMMIT ;
616: EXCEPTION
617:
618: WHEN OTHERS then
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
621: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
622: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
623: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755:
756: EXCEPTION
757:
758: WHEN OTHERS then
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: RETURN;
761:
762: END SD_RAISE_EVENT;
763:

Line 780: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

776: -- NOTES
777: --
778: ----------------------------------------------------------------------
779: PROCEDURE PROCESS_BATCH_ADJUST_CLAIM( p_batch_header_id NUMBER,
780: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
781: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 781: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

777: --
778: ----------------------------------------------------------------------
779: PROCEDURE PROCESS_BATCH_ADJUST_CLAIM( p_batch_header_id NUMBER,
780: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
781: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2) IS
785:

Line 790: l_full_write_off VARCHAR2(1) := fnd_api.g_false ;

786: l_procedure_name VARCHAR2(30) := 'PROCESS_BATCH_ADJUST_CLAIM' ;
787: l_unapproved_line_count NUMBER ;
788: l_approved_line_count NUMBER;
789: l_total_line_count NUMBER;
790: l_full_write_off VARCHAR2(1) := fnd_api.g_false ;
791: l_status_code VARCHAR2(30) ;
792: l_claim_id number ;
793: l_orig_app_line_count NUMBER ;
794: l_orig_total_line_count NUMBER ;

Line 795: l_create_claim VARCHAR2(1) := fnd_api.g_false ;

791: l_status_code VARCHAR2(30) ;
792: l_claim_id number ;
793: l_orig_app_line_count NUMBER ;
794: l_orig_total_line_count NUMBER ;
795: l_create_claim VARCHAR2(1) := fnd_api.g_false ;
796:
797: l_total_app_claim_amt NUMBER ;
798: l_tot_non_rma_lines NUMBER ;
799: l_imd_claim_flag VARCHAR2(1);

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802:
803:
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;

Line 834: l_full_write_off := fnd_api.g_true;

830: AND TOTAL_APPROVED_AMT IS NOT NULL
831: AND status_code NOT IN ('APPROVED','COMPLETED');
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,

Line 847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS AND l_full_write_off = fnd_api.g_FALSE THEN

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;
850:
851: FOR I IN 1..x_msg_count LOOP

Line 959: l_full_write_off := fnd_api.g_true;

955:
956: -- Check if all lines are approved and batch header is not 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);

Line 971: l_full_write_off := fnd_api.g_FALSE ;

967:
968: -- Only for WIP batch create claim
969: IF (l_orig_app_line_count <> l_orig_total_line_count) THEN
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:

Line 972: l_create_claim := fnd_api.g_true;

968: -- Only for WIP batch create claim
969: IF (l_orig_app_line_count <> l_orig_total_line_count) THEN
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,

Line 982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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:
985: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
986:

Line 1006: IF x_return_status <> FND_API.G_RET_STS_SUCCESS AND l_full_write_off = fnd_api.g_FALSE THEN

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;
1009:
1010: FOR I IN 1..x_msg_count LOOP

Line 1021: IF (l_create_claim=fnd_api.g_true) THEN

1017:
1018: RETURN;
1019: END IF;
1020:
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 ');

Line 1051: l_full_write_off := fnd_api.g_true ;

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 ;
1052:
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Adjusting the lines of the current batch');
1054:
1055:

Line 1108: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1104: END IF ;
1105:
1106: COMMIT;
1107:
1108: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1109:
1110: EXCEPTION
1111:
1112: WHEN OTHERS then

Line 1113: x_return_status := FND_API.G_RET_STS_ERROR;

1109:
1110: EXCEPTION
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;

Line 1137: p_comp_wrt_off IN VARCHAR2 := fnd_api.g_false,

1133: -- NOTES
1134: --
1135: ----------------------------------------------------------------------
1136: PROCEDURE CREATE_ADJUSTMENT( p_batch_header_id NUMBER,
1137: p_comp_wrt_off IN VARCHAR2 := fnd_api.g_false,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2) IS
1141:

Line 1149: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1145: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1146: x_act_budget_id NUMBER;
1147: l_new_util_id NUMBER ;
1148: l_fail_count NUMBER := 0;
1149: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1150: l_init_msg_list VARCHAR2(1) := fnd_api.g_false ;
1151: l_conv_adj_amount NUMBER; -- added to fix bug 9057734
1152:
1153:

Line 1150: l_init_msg_list VARCHAR2(1) := fnd_api.g_false ;

1146: x_act_budget_id NUMBER;
1147: l_new_util_id NUMBER ;
1148: l_fail_count NUMBER := 0;
1149: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1150: l_init_msg_list VARCHAR2(1) := fnd_api.g_false ;
1151: l_conv_adj_amount NUMBER; -- added to fix bug 9057734
1152:
1153:
1154: CURSOR c_batch_details IS

Line 1194: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1190: AND lines.ADJ_UTILIZATION_ID is null;
1191:
1192: BEGIN
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:

Line 1264: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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
1265:
1266:
1267: fnd_msg_pub.count_and_get (
1268: p_encoded=> fnd_api.g_false

Line 1268: p_encoded=> fnd_api.g_false

1264: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1265:
1266:
1267: fnd_msg_pub.count_and_get (
1268: p_encoded=> fnd_api.g_false
1269: ,p_count=> x_msg_count
1270: ,p_data=> x_msg_data);
1271:
1272:

Line 1273: IF (p_comp_wrt_off = fnd_api.g_false) THEN

1269: ,p_count=> x_msg_count
1270: ,p_data=> x_msg_data);
1271:
1272:
1273: IF (p_comp_wrt_off = fnd_api.g_false) THEN
1274: RETURN;
1275: END IF;
1276:
1277:

Line 1292: IF (p_comp_wrt_off = fnd_api.g_true) THEN

1288:
1289:
1290: -- If complete write off, then change the line status to COMPLETE and update the new utlization iD
1291: -- Else update the utilization id but the line status
1292: IF (p_comp_wrt_off = fnd_api.g_true) THEN
1293:
1294: UPDATE OZF_SD_BATCH_LINES_ALL
1295: SET ADJ_UTILIZATION_ID = l_new_util_id,
1296: status_code = 'COMPLETED'

Line 1316: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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:
1320: WHEN OTHERS then

Line 1321: x_return_status := FND_API.G_RET_STS_ERROR;

1317:
1318: EXCEPTION
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:

Line 1348: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

1344: retcode OUT nocopy NUMBER,
1345: p_batch_id NUMBER) IS
1346:
1347:
1348: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
1349: l_msg_count NUMBER ;
1350: l_msg_data VARCHAR2(2000) ;
1351: l_curr_batch_status VARCHAR2(30);
1352:

Line 1393: p_validation_level=> fnd_api.g_valid_level_full,

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,
1395: x_return_status=> l_return_status ,
1396: x_msg_count=> l_msg_count ,
1397: x_msg_data=> l_msg_data ) ;

Line 1394: p_init_msg_list=> fnd_api.g_false,

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,
1395: x_return_status=> l_return_status ,
1396: x_msg_count=> l_msg_count ,
1397: x_msg_data=> l_msg_data ) ;
1398:

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1424: l_incomplete_count NUMBER ;
1425:
1426: BEGIN
1427:
1428: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1429:
1430: UPDATE OZF_SD_BATCH_LINES_ALL
1431: SET complete_flag='Y'
1432: WHERE batch_id=p_batch_header_id ;

Line 1439: x_return_status := FND_API.G_RET_STS_ERROR;

1435:
1436: EXCEPTION
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;

Line 1467: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1463: l_incomplete_count NUMBER ;
1464:
1465:
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1468:
1469: SELECT COUNT(1) INTO l_incomplete_count
1470: FROM OZF_SD_BATCH_LINES_ALL
1471: WHERE status_code IN( 'REJECTED','SUBMITTED')

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR ;

1474:
1475:
1476: IF (l_incomplete_count>0) THEN
1477:
1478: x_return_status := FND_API.G_RET_STS_ERROR ;
1479: END IF ;
1480:
1481:
1482: END CHECK_COMPLETE_FLAGS ;