DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on FND_API

Line 98: RAISE FND_API.g_exc_error;

94: 'Start exception block of GET_BATCH_CURRENCY_AMOUNT(p_UTILIZATION_ID number:-,' ||
95: p_UTILIZATION_ID || ' p_batch_currency VARCHAR2) ' ||
96: p_batch_currency || ' : x_to_amount :=' ||
97: x_to_amount || SQLERRM);
98: RAISE FND_API.g_exc_error;
99:
100: END;
101:
102: -- Start of comments

Line 157: RAISE FND_API.g_exc_error;

153: 'Start exception block of CONV_DISC_TO_OFFER_CURR_AMOUNT(p_discount_val number:-,' ||
154: p_discount_val || ' p_offer_currency VARCHAR2) ' ||
155: p_offer_currency || ' : x_to_amount :=' ||
156: x_to_amount || SQLERRM);
157: RAISE FND_API.g_exc_error;
158:
159: END;
160:
161:

Line 351: FND_API.g_true,

347: p_fund_id,
348: l_start_date,
349: l_end_date,
350: p_period,
351: FND_API.g_true,
352: p_attribute1,
353: p_attribute2,
354: p_attribute3,
355: p_attribute4,

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

426: p_fund_id IN NUMBER,
427: p_start_date IN DATE,
428: p_end_date IN DATE,
429: p_period IN VARCHAR2,
430: p_commit IN VARCHAR2 := FND_API.g_false,
431: p_attribute1 IN VARCHAR2 := NULL,
432: p_attribute2 IN VARCHAR2 := NULL,
433: p_attribute3 IN VARCHAR2 := NULL,
434: p_attribute4 IN VARCHAR2 := NULL,

Line 660: IF fnd_api.To_Boolean(p_commit) THEN

656: UPDATE ozf_supp_trd_prfls_all
657: SET last_paid_date = sysdate
658: WHERE supplier_site_id = l_supplier_site_id;
659:
660: IF fnd_api.To_Boolean(p_commit) THEN
661: COMMIT;
662: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction is commited');
663: FND_FILE.PUT_LINE(FND_FILE.LOG, ' supplier_site_id= ' || l_supplier_site_id);
664: FND_FILE.PUT_LINE(FND_FILE.LOG, ' l_currency= ' || l_currency);

Line 795: IF fnd_api.To_Boolean(p_commit) THEN

791: UPDATE ozf_supp_trd_prfls_all
792: SET last_paid_date = sysdate
793: WHERE supplier_site_id = l_supplier_site_id;
794:
795: IF fnd_api.To_Boolean(p_commit) THEN
796: COMMIT;
797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction is commited');
798: FND_FILE.PUT_LINE(FND_FILE.LOG, ' supplier_site_id= ' || l_supplier_site_id);
799: FND_FILE.PUT_LINE(FND_FILE.LOG, ' l_currency= ' || l_currency);

Line 1003: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

999:
1000: UPDATE_AMOUNTS(l_batch_id, l_batch_threshold);
1001:
1002: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create
1003: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1004: RAISE FND_API.g_exc_error;
1005: END IF;
1006:
1007: ELSE

Line 1004: RAISE FND_API.g_exc_error;

1000: UPDATE_AMOUNTS(l_batch_id, l_batch_threshold);
1001:
1002: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create
1003: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1004: RAISE FND_API.g_exc_error;
1005: END IF;
1006:
1007: ELSE
1008:

Line 1043: FND_API.g_false,

1039: END IF;
1040:
1041:
1042: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1043: FND_API.g_false,
1044: FND_API.g_true,
1045: FND_API.g_valid_level_full,
1046: l_claim_ret_status,
1047: l_claim_msg_count,

Line 1044: FND_API.g_true,

1040:
1041:
1042: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1043: FND_API.g_false,
1044: FND_API.g_true,
1045: FND_API.g_valid_level_full,
1046: l_claim_ret_status,
1047: l_claim_msg_count,
1048: l_claim_msg_data,

Line 1045: FND_API.g_valid_level_full,

1041:
1042: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
1043: FND_API.g_false,
1044: FND_API.g_true,
1045: FND_API.g_valid_level_full,
1046: l_claim_ret_status,
1047: l_claim_msg_count,
1048: l_claim_msg_data,
1049: l_batch_id,

Line 1068: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1064: 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) );
1065: END LOOP;
1066: END IF;
1067:
1068: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1069:
1070: --Code added for Bug#6971836
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
1072:

Line 1093: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1089: END IF; --BATCH_SUM > 0
1090:
1091:
1092: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
1093: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.g_exc_error;
1095: END IF;
1096:
1097: END IF; --AUTO_CLAIM TRUE

Line 1094: RAISE FND_API.g_exc_error;

1090:
1091:
1092: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
1093: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.g_exc_error;
1095: END IF;
1096:
1097: END IF; --AUTO_CLAIM TRUE
1098: p_empty_batch := l_empty_batch;

Line 2011: RAISE FND_API.g_exc_error;

2007: IF OZF_DEBUG_HIGH_ON THEN
2008: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in CREATE_BATCH_LINES : ' || SQLERRM);
2009: END IF;
2010:
2011: RAISE FND_API.g_exc_error;
2012:
2013: END Create_Batch_Lines;
2014:
2015:

Line 2061: RAISE FND_API.g_exc_error;

2057: IF OZF_DEBUG_HIGH_ON THEN
2058: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in UPDATE_AMOUNTS:' || SQLERRM);
2059: END IF;
2060:
2061: RAISE FND_API.g_exc_error;
2062:
2063: END UPDATE_AMOUNTS;
2064:
2065:

Line 2163: FND_API.g_false,

2159: --Code added for Bug#6971836
2160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Initiates claim for batch '||to_char(l_batch_id));
2161:
2162: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
2163: FND_API.g_false,
2164: FND_API.g_true,
2165: FND_API.g_valid_level_full,
2166: l_claim_ret_status,
2167: l_claim_msg_count,

Line 2164: FND_API.g_true,

2160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Initiates claim for batch '||to_char(l_batch_id));
2161:
2162: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
2163: FND_API.g_false,
2164: FND_API.g_true,
2165: FND_API.g_valid_level_full,
2166: l_claim_ret_status,
2167: l_claim_msg_count,
2168: l_claim_msg_data,

Line 2165: FND_API.g_valid_level_full,

2161:
2162: OZF_CLAIM_ACCRUAL_PVT.Initiate_SD_Payment(1,
2163: FND_API.g_false,
2164: FND_API.g_true,
2165: FND_API.g_valid_level_full,
2166: l_claim_ret_status,
2167: l_claim_msg_count,
2168: l_claim_msg_data,
2169: l_batch_id,

Line 2189: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

2185: 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) );
2186: END LOOP;
2187: END IF;
2188:
2189: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
2190:
2191: --Code added for Bug#6971836
2192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
2193:

Line 2203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2199: object_version_number = object_version_number + 1
2200: WHERE batch_id = l_batch_id;
2201:
2202: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
2203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2206:
2207:

Line 2204: RAISE FND_API.g_exc_error;

2200: WHERE batch_id = l_batch_id;
2201:
2202: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
2203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2206:
2207:
2208: