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
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:
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,
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,
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);
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);
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
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:
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,
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,
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,
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:
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
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;
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:
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:
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,
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,
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,
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:
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:
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: