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_GL_INTERFACE_PVT dependencies on FND_MESSAGE

Line 390: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: -- Debug Message
389: IF OZF_DEBUG_LOW_ON THEN
390: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
391: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
392: FND_MSG_PUB.Add;
393: END IF;
394: --Initialize message list if p_init_msg_list is TRUE.

Line 391: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

387: END IF;
388: -- Debug Message
389: IF OZF_DEBUG_LOW_ON THEN
390: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
391: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
392: FND_MSG_PUB.Add;
393: END IF;
394: --Initialize message list if p_init_msg_list is TRUE.
395: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 667: FND_MESSAGE.set_name('OZF', 'OZF_GL_REVENUE_ACCT_NOT_FOUND');

663: FETCH get_order_line_csr INTO l_order_number, l_line_number;
664: CLOSE get_order_line_csr;
665:
666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
667: FND_MESSAGE.set_name('OZF', 'OZF_GL_REVENUE_ACCT_NOT_FOUND');
668: FND_MESSAGE.set_token('ORDER_NUM', l_order_number);
669: FND_MESSAGE.set_token('LINE_NUM', l_line_number);
670: FND_MSG_PUB.add;
671: END IF;

Line 668: FND_MESSAGE.set_token('ORDER_NUM', l_order_number);

664: CLOSE get_order_line_csr;
665:
666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
667: FND_MESSAGE.set_name('OZF', 'OZF_GL_REVENUE_ACCT_NOT_FOUND');
668: FND_MESSAGE.set_token('ORDER_NUM', l_order_number);
669: FND_MESSAGE.set_token('LINE_NUM', l_line_number);
670: FND_MSG_PUB.add;
671: END IF;
672: x_return_status := FND_API.g_ret_sts_error;

Line 669: FND_MESSAGE.set_token('LINE_NUM', l_line_number);

665:
666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
667: FND_MESSAGE.set_name('OZF', 'OZF_GL_REVENUE_ACCT_NOT_FOUND');
668: FND_MESSAGE.set_token('ORDER_NUM', l_order_number);
669: FND_MESSAGE.set_token('LINE_NUM', l_line_number);
670: FND_MSG_PUB.add;
671: END IF;
672: x_return_status := FND_API.g_ret_sts_error;
673: END IF;

Line 782: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_GEN_ERROR');

778:
779: EXCEPTION
780: WHEN OTHERS THEN
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
782: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_GEN_ERROR');
783: FND_MSG_PUB.add;
784: END IF;
785: x_return_status := FND_API.g_ret_sts_unexp_error;
786: END;

Line 805: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

801: COMMIT WORK;
802: END IF;
803: -- Debug Message
804: IF OZF_DEBUG_LOW_ON THEN
805: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
806: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
807: FND_MSG_PUB.Add;
808: END IF;
809: --Standard call to get message count and if count=1, get the message

Line 806: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

802: END IF;
803: -- Debug Message
804: IF OZF_DEBUG_LOW_ON THEN
805: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
806: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
807: FND_MSG_PUB.Add;
808: END IF;
809: --Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (

Line 890: FND_MESSAGE.set_name('OZF', 'OZF_GL_FUND_TYPE_ERROR');

886: ELSIF l_type = 'FULLY_ACCRUED' THEN
887: x_ae_category := 'Accrual Budgets';
888: ELSE
889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
890: FND_MESSAGE.set_name('OZF', 'OZF_GL_FUND_TYPE_ERROR');
891: FND_MSG_PUB.add;
892: END IF;
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;

Line 912: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');

908: END IF;
909: */
910: ELSE
911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
912: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');
913: FND_MSG_PUB.add;
914: END IF;
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;

Line 920: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_CATG_ERROR');

916: END IF;
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_CATG_ERROR');
921: FND_MSG_PUB.add;
922: END IF;
923: x_return_status := FND_API.g_ret_sts_unexp_error;
924: END get_ae_category;

Line 983: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');

979: return 17;
980: -- R12.1 Changes End
981: ELSE
982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
983: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');
984: FND_MSG_PUB.add;
985: END IF;
986: x_return_status := FND_API.g_ret_sts_error;
987: return null;

Line 992: FND_MESSAGE.set_name('OZF', 'OZF_GL_EVE_NUM_ERROR');

988: END IF;
989: EXCEPTION
990: WHEN OTHERS THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('OZF', 'OZF_GL_EVE_NUM_ERROR');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_unexp_error;
996: END get_event_number;

Line 1143: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');

1139: -- R12 changes end
1140:
1141: ELSE
1142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1143: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');
1144: FND_MSG_PUB.add;
1145: END IF;
1146: x_return_status := FND_API.g_ret_sts_error;
1147: return null;

Line 1152: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_TYPE_ERROR');

1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1152: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_TYPE_ERROR');
1153: FND_MSG_PUB.add;
1154: END IF;
1155: x_return_status := FND_API.g_ret_sts_unexp_error;
1156: END get_account_type_code;

Line 1215: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');

1211: CLOSE offer_code_csr;
1212:
1213: IF l_offer_code IS NOT NULL THEN
1214: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1215: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');

Line 1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);

1212:
1213: IF l_offer_code IS NOT NULL THEN
1214: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1215: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);

Line 1217: RETURN FND_MESSAGE.GET;

1213: IF l_offer_code IS NOT NULL THEN
1214: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1215: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1221: RETURN FND_MESSAGE.GET;

Line 1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');

1215: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1221: RETURN FND_MESSAGE.GET;
1222: END IF;
1223: END IF;

Line 1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);

1216: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1221: RETURN FND_MESSAGE.GET;
1222: END IF;
1223: END IF;
1224: ELSIF l_ae_category = 'Accrual Budgets' THEN

Line 1221: RETURN FND_MESSAGE.GET;

1217: RETURN FND_MESSAGE.GET;
1218: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1219: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
1220: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
1221: RETURN FND_MESSAGE.GET;
1222: END IF;
1223: END IF;
1224: ELSIF l_ae_category = 'Accrual Budgets' THEN
1225: OPEN fund_number_csr(p_gl_rec.source_id);

Line 1230: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');

1226: FETCH fund_number_csr INTO l_fund_number;
1227: CLOSE fund_number_csr;
1228:
1229: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1230: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');

Line 1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);

1227: CLOSE fund_number_csr;
1228:
1229: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1230: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);

Line 1232: RETURN FND_MESSAGE.GET;

1228:
1229: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1230: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1236: RETURN FND_MESSAGE.GET;

Line 1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');

1230: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1236: RETURN FND_MESSAGE.GET;
1237: END IF;
1238: ELSIF l_ae_category = 'Settlement' THEN

Line 1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);

1231: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1236: RETURN FND_MESSAGE.GET;
1237: END IF;
1238: ELSIF l_ae_category = 'Settlement' THEN
1239: OPEN claim_number_csr(p_gl_rec.source_id);

Line 1236: RETURN FND_MESSAGE.GET;

1232: RETURN FND_MESSAGE.GET;
1233: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1234: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
1235: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
1236: RETURN FND_MESSAGE.GET;
1237: END IF;
1238: ELSIF l_ae_category = 'Settlement' THEN
1239: OPEN claim_number_csr(p_gl_rec.source_id);
1240: FETCH claim_number_csr INTO l_claim_number;

Line 1244: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');

1240: FETCH claim_number_csr INTO l_claim_number;
1241: CLOSE claim_number_csr;
1242:
1243: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1244: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
1245: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1246: RETURN FND_MESSAGE.GET;
1247: ELSIF p_account_type_code = 'REC_CLEARING' OR
1248: p_account_type_code = 'VEN_CLEARING'

Line 1245: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);

1241: CLOSE claim_number_csr;
1242:
1243: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1244: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
1245: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1246: RETURN FND_MESSAGE.GET;
1247: ELSIF p_account_type_code = 'REC_CLEARING' OR
1248: p_account_type_code = 'VEN_CLEARING'
1249: THEN

Line 1246: RETURN FND_MESSAGE.GET;

1242:
1243: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
1244: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
1245: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1246: RETURN FND_MESSAGE.GET;
1247: ELSIF p_account_type_code = 'REC_CLEARING' OR
1248: p_account_type_code = 'VEN_CLEARING'
1249: THEN
1250: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');

Line 1250: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');

1246: RETURN FND_MESSAGE.GET;
1247: ELSIF p_account_type_code = 'REC_CLEARING' OR
1248: p_account_type_code = 'VEN_CLEARING'
1249: THEN
1250: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
1251: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1252: RETURN FND_MESSAGE.GET;
1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN

Line 1251: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);

1247: ELSIF p_account_type_code = 'REC_CLEARING' OR
1248: p_account_type_code = 'VEN_CLEARING'
1249: THEN
1250: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
1251: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1252: RETURN FND_MESSAGE.GET;
1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');

Line 1252: RETURN FND_MESSAGE.GET;

1248: p_account_type_code = 'VEN_CLEARING'
1249: THEN
1250: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
1251: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1252: RETURN FND_MESSAGE.GET;
1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
1256: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);

Line 1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');

1251: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1252: RETURN FND_MESSAGE.GET;
1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
1256: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1257: RETURN FND_MESSAGE.GET;
1258: END IF;
1259: END IF;

Line 1256: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);

1252: RETURN FND_MESSAGE.GET;
1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
1256: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1257: RETURN FND_MESSAGE.GET;
1258: END IF;
1259: END IF;
1260:

Line 1257: RETURN FND_MESSAGE.GET;

1253: -- Added for Bug 6751352
1254: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
1255: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
1256: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
1257: RETURN FND_MESSAGE.GET;
1258: END IF;
1259: END IF;
1260:
1261: RETURN null;

Line 1266: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_DESC_ERROR');

1262:
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1266: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_DESC_ERROR');
1267: FND_MSG_PUB.add;
1268: END IF;
1269: x_return_status := FND_API.g_ret_sts_unexp_error;
1270: END get_account_description;

Line 1575: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_EVENT');

1571: END LOOP;
1572: END IF;
1573: ELSE
1574: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1575: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_EVENT');
1576: FND_MSG_PUB.add;
1577: END IF;
1578: x_return_status := FND_API.g_ret_sts_error;
1579: END IF;

Line 1752: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_EVENT');

1748: x_amount_tbl(l_cl_tot+i).utilization_id := l_prod_cr_cc_id_tbl_2(1).utilization_id;
1749: END LOOP;
1750: ELSE
1751: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1752: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_EVENT');
1753: FND_MSG_PUB.add;
1754: END IF;
1755: x_return_status := FND_API.g_ret_sts_error;
1756: END IF;

Line 1760: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');

1756: END IF;
1757: -- if source table is different
1758: ELSE
1759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1760: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');
1761: FND_MSG_PUB.add;
1762: END IF;
1763: x_return_status := FND_API.g_ret_sts_error;
1764: END IF;

Line 1773: FND_MESSAGE.set_name('OZF', 'OZF_GL_LINE_AMOUNT_CALC_ERROR');

1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: WHEN OTHERS THEN
1772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1773: FND_MESSAGE.set_name('OZF', 'OZF_GL_LINE_AMOUNT_CALC_ERROR');
1774: FND_MSG_PUB.add;
1775: END IF;
1776: x_return_status := FND_API.g_ret_sts_unexp_error;
1777: END;

Line 1975: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCTNG_EVENT_ERROR');

1971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973: WHEN OTHERS THEN
1974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1975: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCTNG_EVENT_ERROR');
1976: FND_MSG_PUB.add;
1977: END IF;
1978: x_return_status := FND_API.g_ret_sts_unexp_error;
1979: END Construct_Acctng_Event_Rec;

Line 2063: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_HEADER_ERROR');

2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2061: WHEN OTHERS THEN
2062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2063: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_HEADER_ERROR');
2064: FND_MSG_PUB.add;
2065: END IF;
2066: x_return_status := FND_API.g_ret_sts_unexp_error;
2067: END Construct_Header_Rec;

Line 2141: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_FXGL_ACCOUNT_SETUP');

2137: CLOSE get_fxgl_loss_ccid_csr;
2138:
2139: IF l_fxgl_gain_ccid is null THEN
2140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2141: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_FXGL_ACCOUNT_SETUP');
2142: FND_MSG_PUB.add;
2143: END IF;
2144: x_return_status := FND_API.g_ret_sts_error;
2145: return;

Line 2304: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_LINE_ERROR');

2300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: WHEN OTHERS THEN
2303: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2304: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_LINE_ERROR');
2305: FND_MSG_PUB.add;
2306: END IF;
2307: x_return_status := FND_API.g_ret_sts_unexp_error;
2308: END Construct_Line_Rec;

Line 2341: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2338: END IF;
2339: -- Debug Message
2340: IF OZF_DEBUG_LOW_ON THEN
2341: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2342: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2343: FND_MSG_PUB.Add;
2344: END IF;
2345: --Initialize message list if p_init_msg_list is TRUE.

Line 2342: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

2338: END IF;
2339: -- Debug Message
2340: IF OZF_DEBUG_LOW_ON THEN
2341: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2342: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2343: FND_MSG_PUB.Add;
2344: END IF;
2345: --Initialize message list if p_init_msg_list is TRUE.
2346: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2392: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2388: END IF;
2389:
2390: -- Debug Message
2391: IF OZF_DEBUG_LOW_ON THEN
2392: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2393: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2394: FND_MSG_PUB.Add;
2395: END IF;
2396: --Standard call to get message count and if count=1, get the message

Line 2393: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

2389:
2390: -- Debug Message
2391: IF OZF_DEBUG_LOW_ON THEN
2392: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2393: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2394: FND_MSG_PUB.Add;
2395: END IF;
2396: --Standard call to get message count and if count=1, get the message
2397: FND_MSG_PUB.Count_And_Get (

Line 2537: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2534: END IF;
2535: -- Debug Message
2536: IF OZF_DEBUG_LOW_ON THEN
2537: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2538: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2539: FND_MSG_PUB.Add;
2540: END IF;
2541: --Initialize message list if p_init_msg_list is TRUE.

Line 2538: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

2534: END IF;
2535: -- Debug Message
2536: IF OZF_DEBUG_LOW_ON THEN
2537: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2538: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2539: FND_MSG_PUB.Add;
2540: END IF;
2541: --Initialize message list if p_init_msg_list is TRUE.
2542: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2566: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');

2562: CLOSE chk_ae_exist;
2563:
2564: IF l_acc_event_id IS NOT NULL THEN
2565: IF OZF_DEBUG_HIGH_ON THEN
2566: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2567: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2568: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2569: FND_MSG_PUB.add;
2570: END IF;

Line 2567: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);

2563:
2564: IF l_acc_event_id IS NOT NULL THEN
2565: IF OZF_DEBUG_HIGH_ON THEN
2566: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2567: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2568: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2569: FND_MSG_PUB.add;
2570: END IF;
2571: RAISE FND_API.G_EXC_ERROR;

Line 2568: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);

2564: IF l_acc_event_id IS NOT NULL THEN
2565: IF OZF_DEBUG_HIGH_ON THEN
2566: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2567: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2568: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2569: FND_MSG_PUB.add;
2570: END IF;
2571: RAISE FND_API.G_EXC_ERROR;
2572: END IF;

Line 2639: -- FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_RULE_ERROR');

2635: x_ae_line_tbl => l_ae_line_tbl );
2636:
2637: IF x_return_status = FND_API.g_ret_sts_error THEN
2638: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2639: -- FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_RULE_ERROR');
2640: -- FND_MSG_PUB.add;
2641: --END IF;
2642: RAISE FND_API.G_EXC_ERROR;
2643: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2729: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2725: COMMIT WORK;
2726: END IF;
2727: -- Debug Message
2728: IF OZF_DEBUG_LOW_ON THEN
2729: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2730: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2731: FND_MSG_PUB.Add;
2732: END IF;
2733: --Standard call to get message count and if count=1, get the message

Line 2730: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

2726: END IF;
2727: -- Debug Message
2728: IF OZF_DEBUG_LOW_ON THEN
2729: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2730: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2731: FND_MSG_PUB.Add;
2732: END IF;
2733: --Standard call to get message count and if count=1, get the message
2734: FND_MSG_PUB.Count_And_Get (

Line 2835: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2832: END IF;
2833: -- Debug Message
2834: IF OZF_DEBUG_LOW_ON THEN
2835: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2836: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2837: FND_MSG_PUB.Add;
2838: END IF;
2839: --Initialize message list if p_init_msg_list is TRUE.

Line 2836: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

2832: END IF;
2833: -- Debug Message
2834: IF OZF_DEBUG_LOW_ON THEN
2835: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2836: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2837: FND_MSG_PUB.Add;
2838: END IF;
2839: --Initialize message list if p_init_msg_list is TRUE.
2840: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2853: FND_MESSAGE.set_name('OZF', 'OZF_GL_INCORR_EVENT_STATUS');

2849:
2850: -- raise error if the event status code is already accounted
2851: IF l_event_status_code = 'ACCOUNTED' THEN
2852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2853: FND_MESSAGE.set_name('OZF', 'OZF_GL_INCORR_EVENT_STATUS');
2854: FND_MSG_PUB.add;
2855: END IF;
2856: RAISE FND_API.G_EXC_ERROR;
2857: END IF;

Line 2940: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2936: COMMIT WORK;
2937: END IF;
2938: -- Debug Message
2939: IF OZF_DEBUG_LOW_ON THEN
2940: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2941: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2942: FND_MSG_PUB.Add;
2943: END IF;
2944: --Standard call to get message count and if count=1, get the message

Line 2941: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

2937: END IF;
2938: -- Debug Message
2939: IF OZF_DEBUG_LOW_ON THEN
2940: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2941: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2942: FND_MSG_PUB.Add;
2943: END IF;
2944: --Standard call to get message count and if count=1, get the message
2945: FND_MSG_PUB.Count_And_Get (

Line 3145: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: END IF;
3143:
3144: IF OZF_DEBUG_LOW_ON THEN
3145: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3146: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3147: FND_MSG_PUB.Add;
3148: END IF;
3149:

Line 3146: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

3142: END IF;
3143:
3144: IF OZF_DEBUG_LOW_ON THEN
3145: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3146: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3147: FND_MSG_PUB.Add;
3148: END IF;
3149:
3150: --Initialize message list if p_init_msg_list is TRUE.

Line 3436: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3432: COMMIT WORK;
3433: END IF;
3434: -- Debug Message
3435: IF OZF_DEBUG_LOW_ON THEN
3436: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3437: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3438: FND_MSG_PUB.Add;
3439: FND_MSG_PUB.Add;
3440: END IF;

Line 3437: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

3433: END IF;
3434: -- Debug Message
3435: IF OZF_DEBUG_LOW_ON THEN
3436: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3437: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3438: FND_MSG_PUB.Add;
3439: FND_MSG_PUB.Add;
3440: END IF;
3441: --Standard call to get message count and if count=1, get the message

Line 3542: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3539: END IF;
3540: -- Debug Message
3541: IF OZF_DEBUG_LOW_ON THEN
3542: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3543: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3544: FND_MSG_PUB.Add;
3545: END IF;
3546: --Initialize message list if p_init_msg_list is TRUE.

Line 3543: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

3539: END IF;
3540: -- Debug Message
3541: IF OZF_DEBUG_LOW_ON THEN
3542: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3543: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3544: FND_MSG_PUB.Add;
3545: END IF;
3546: --Initialize message list if p_init_msg_list is TRUE.
3547: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 3597: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3593: COMMIT WORK;
3594: END IF;
3595: -- Debug Message
3596: IF OZF_DEBUG_LOW_ON THEN
3597: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3598: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3599: FND_MSG_PUB.Add;
3600: END IF;
3601: --Standard call to get message count and if count=1, get the message

Line 3598: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

3594: END IF;
3595: -- Debug Message
3596: IF OZF_DEBUG_LOW_ON THEN
3597: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3598: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3599: FND_MSG_PUB.Add;
3600: END IF;
3601: --Standard call to get message count and if count=1, get the message
3602: FND_MSG_PUB.Count_And_Get (

Line 3696: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3693: END IF;
3694: -- Debug Message
3695: IF OZF_DEBUG_LOW_ON THEN
3696: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3697: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3698: FND_MSG_PUB.Add;
3699: END IF;
3700: --Initialize message list if p_init_msg_list is TRUE.

Line 3697: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

3693: END IF;
3694: -- Debug Message
3695: IF OZF_DEBUG_LOW_ON THEN
3696: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3697: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3698: FND_MSG_PUB.Add;
3699: END IF;
3700: --Initialize message list if p_init_msg_list is TRUE.
3701: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 3763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

3759: COMMIT WORK;
3760: END IF;
3761: -- Debug Message
3762: IF OZF_DEBUG_LOW_ON THEN
3763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3764: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3765: FND_MSG_PUB.Add;
3766: END IF;
3767: --Standard call to get message count and if count=1, get the message

Line 3764: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

3760: END IF;
3761: -- Debug Message
3762: IF OZF_DEBUG_LOW_ON THEN
3763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3764: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3765: FND_MSG_PUB.Add;
3766: END IF;
3767: --Standard call to get message count and if count=1, get the message
3768: FND_MSG_PUB.Count_And_Get (