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_BATCH_PVT dependencies on FND_API

Line 99: RAISE FND_API.g_exc_error;

95: 'Start exception block of CONV_AMT_TO_OFFER_CURR_AMOUNT(p_amt_val number:-,' ||
96: p_amt_val || ' p_offer_currency VARCHAR2) ' ||
97: p_offer_currency || ' : x_to_amount :=' ||
98: x_to_amount || SQLERRM);
99: RAISE FND_API.g_exc_error;
100:
101: END;
102: --End:Added for Bug#10011106 fix
103:

Line 158: RAISE FND_API.g_exc_error;

154: 'Start exception block of GET_BATCH_CURRENCY_AMOUNT(p_acctd_amount :-,' ||
155: p_acctd_amount || ' p_batch_currency VARCHAR2) ' ||
156: p_batch_currency || ' : x_to_amount :=' ||
157: x_to_amount || SQLERRM);
158: RAISE FND_API.g_exc_error;
159:
160: END;
161:
162: -- Start of comments

Line 217: RAISE FND_API.g_exc_error;

213: 'Start exception block of CONV_DISC_TO_OFFER_CURR_AMOUNT(p_discount_val number:-,' ||
214: p_discount_val || ' p_offer_currency VARCHAR2) ' ||
215: p_offer_currency || ' : x_to_amount :=' ||
216: x_to_amount || SQLERRM);
217: RAISE FND_API.g_exc_error;
218:
219: END;
220:
221: -- Start of comments

Line 474: FND_API.g_true,

470: l_start_date,
471: l_end_date,
472: p_period,
473: p_owner,
474: FND_API.g_true,
475: p_attribute1,
476: p_attribute2,
477: p_attribute3,
478: p_attribute4,

Line 563: p_commit IN VARCHAR2 := FND_API.g_false,

559: p_start_date IN DATE,
560: p_end_date IN DATE,
561: p_period IN VARCHAR2,
562: p_owner IN NUMBER,
563: p_commit IN VARCHAR2 := FND_API.g_false,
564: p_attribute1 IN VARCHAR2 := NULL,
565: p_attribute2 IN VARCHAR2 := NULL,
566: p_attribute3 IN VARCHAR2 := NULL,
567: p_attribute4 IN VARCHAR2 := NULL,

Line 800: IF fnd_api.To_Boolean(p_commit) THEN

796: UPDATE ozf_supp_trd_prfls_all
797: SET last_paid_date = sysdate
798: WHERE supplier_site_id = l_supplier_site_id;
799:
800: IF fnd_api.To_Boolean(p_commit) THEN
801: COMMIT;
802: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction is commited');
803: FND_FILE.PUT_LINE(FND_FILE.LOG, ' supplier_site_id= ' || l_supplier_site_id);
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' l_currency= ' || l_currency);

Line 940: IF fnd_api.To_Boolean(p_commit) THEN

936: UPDATE ozf_supp_trd_prfls_all
937: SET last_paid_date = sysdate
938: WHERE supplier_site_id = l_supplier_site_id;
939:
940: IF fnd_api.To_Boolean(p_commit) THEN
941: COMMIT;
942: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction is commited');
943: FND_FILE.PUT_LINE(FND_FILE.LOG, ' supplier_site_id= ' || l_supplier_site_id);
944: FND_FILE.PUT_LINE(FND_FILE.LOG, ' l_currency= ' || l_currency);

Line 1219: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1215:
1216: UPDATE_AMOUNTS(l_batch_id, l_batch_threshold);
1217:
1218: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create
1219: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.g_exc_error;
1221: END IF;
1222:
1223: --Start:Fix for Bug#10047209 - Create a Claim with new custom setup for -ve amount

Line 1220: RAISE FND_API.g_exc_error;

1216: UPDATE_AMOUNTS(l_batch_id, l_batch_threshold);
1217:
1218: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create
1219: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.g_exc_error;
1221: END IF;
1222:
1223: --Start:Fix for Bug#10047209 - Create a Claim with new custom setup for -ve amount
1224: --to get claim number

Line 1301: FND_API.g_false,

1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim API Invoke Start time in create_batch ' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
1298: END IF;
1299:
1300: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1301: FND_API.g_false,
1302: FND_API.g_true,
1303: FND_API.g_valid_level_full,
1304: l_claim_ret_status,
1305: l_claim_msg_count,

Line 1302: FND_API.g_true,

1298: END IF;
1299:
1300: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1301: FND_API.g_false,
1302: FND_API.g_true,
1303: FND_API.g_valid_level_full,
1304: l_claim_ret_status,
1305: l_claim_msg_count,
1306: l_claim_msg_data,

Line 1303: FND_API.g_valid_level_full,

1299:
1300: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1301: FND_API.g_false,
1302: FND_API.g_true,
1303: FND_API.g_valid_level_full,
1304: l_claim_ret_status,
1305: l_claim_msg_count,
1306: l_claim_msg_data,
1307: l_batch_id,

Line 1330: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1326: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Msg from Claim API in Batch Create ' || SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1327: END LOOP;
1328: END IF;
1329:
1330: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1331:
1332: --Code added for Bug#6971836
1333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
1334:

Line 1362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1358: END IF; --BATCH_SUM > 0
1359:
1360:
1361: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
1362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.g_exc_error;
1364: END IF;
1365:
1366: END IF; --AUTO_CLAIM TRUE

Line 1363: RAISE FND_API.g_exc_error;

1359:
1360:
1361: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
1362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.g_exc_error;
1364: END IF;
1365:
1366: END IF; --AUTO_CLAIM TRUE
1367: p_empty_batch := l_empty_batch;

Line 2491: RAISE FND_API.g_exc_error;

2487: IF OZF_DEBUG_HIGH_ON THEN
2488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in CREATE_OM_BATCH_LINES : ' || SQLERRM);
2489: END IF;
2490:
2491: RAISE FND_API.g_exc_error;
2492:
2493: END CREATE_OM_BATCH_LINES;
2494:
2495:

Line 3334: RAISE FND_API.g_exc_error;

3330: IF OZF_DEBUG_HIGH_ON THEN
3331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in CREATE_IDSM_BATCH_LINES : ' || SQLERRM);
3332: END IF;
3333:
3334: RAISE FND_API.g_exc_error;
3335:
3336: END Create_IDSM_Batch_Lines;
3337:
3338:

Line 3386: RAISE FND_API.g_exc_error;

3382: IF OZF_DEBUG_HIGH_ON THEN
3383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in UPDATE_AMOUNTS:' || SQLERRM);
3384: END IF;
3385:
3386: RAISE FND_API.g_exc_error;
3387:
3388: END UPDATE_AMOUNTS;
3389:
3390:

Line 3492: FND_API.g_false,

3488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim API Invoke Start time in invoke_batch auto claim' || to_char(sysdate,'dd-mm-yyyy hh:mi:ss') );
3489: END IF;
3490:
3491: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3492: FND_API.g_false,
3493: FND_API.g_true,
3494: FND_API.g_valid_level_full,
3495: l_claim_ret_status,
3496: l_claim_msg_count,

Line 3493: FND_API.g_true,

3489: END IF;
3490:
3491: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3492: FND_API.g_false,
3493: FND_API.g_true,
3494: FND_API.g_valid_level_full,
3495: l_claim_ret_status,
3496: l_claim_msg_count,
3497: l_claim_msg_data,

Line 3494: FND_API.g_valid_level_full,

3490:
3491: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3492: FND_API.g_false,
3493: FND_API.g_true,
3494: FND_API.g_valid_level_full,
3495: l_claim_ret_status,
3496: l_claim_msg_count,
3497: l_claim_msg_data,
3498: l_batch_id,

Line 3521: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

3517: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Msg from Claim API while invoking batch for Auto Claim ' || SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
3518: END LOOP;
3519: END IF;
3520:
3521: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
3522:
3523: --Code added for Bug#6971836
3524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
3525:

Line 3535: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3531: object_version_number = object_version_number + 1
3532: WHERE batch_id = l_batch_id;
3533:
3534: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
3535: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3536: RAISE FND_API.g_exc_error;
3537: END IF;
3538:
3539:

Line 3536: RAISE FND_API.g_exc_error;

3532: WHERE batch_id = l_batch_id;
3533:
3534: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
3535: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3536: RAISE FND_API.g_exc_error;
3537: END IF;
3538:
3539:
3540:

Line 3842: FND_API.g_false,

3838: );
3839:
3840:
3841: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3842: FND_API.g_false,
3843: FND_API.g_true,
3844: FND_API.g_valid_level_full,
3845: l_ret_status,
3846: l_msg_count,

Line 3843: FND_API.g_true,

3839:
3840:
3841: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3842: FND_API.g_false,
3843: FND_API.g_true,
3844: FND_API.g_valid_level_full,
3845: l_ret_status,
3846: l_msg_count,
3847: l_msg_data,

Line 3844: FND_API.g_valid_level_full,

3840:
3841: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
3842: FND_API.g_false,
3843: FND_API.g_true,
3844: FND_API.g_valid_level_full,
3845: l_ret_status,
3846: l_msg_count,
3847: l_msg_data,
3848: batch_rec.BATCH_ID,

Line 3876: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If claim is successful

3872: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Msg from Claim API while invoking claim for batch ' || SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
3873: END LOOP;
3874: END IF;
3875:
3876: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If claim is successful
3877:
3878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.' || batch_rec.BATCH_ID || 'is :' || to_char(l_claim_id));
3879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim created for batch.' || batch_rec.BATCH_ID || 'is :' || to_char(l_claim_id));
3880:

Line 3883: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If adjustment is successful

3879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim created for batch.' || batch_rec.BATCH_ID || 'is :' || to_char(l_claim_id));
3880:
3881: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(batch_rec.BATCH_ID, 'F', l_ret_status, l_msg_count, l_msg_data);
3882:
3883: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If adjustment is successful
3884:
3885: UPDATE OZF_SD_BATCH_HEADERS_ALL
3886: SET status_code = 'CLOSED',
3887: claim_id = l_claim_id,