DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on FND_MESSAGE

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

235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237: -- Debug Message
238: IF OZF_DEBUG_LOW_ON THEN
239: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
240: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
241: FND_MSG_PUB.Add;
242: END IF;
243: --Initialize message list if p_init_msg_list is TRUE.

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

236: END IF;
237: -- Debug Message
238: IF OZF_DEBUG_LOW_ON THEN
239: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
240: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
241: FND_MSG_PUB.Add;
242: END IF;
243: --Initialize message list if p_init_msg_list is TRUE.
244: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

460:
461: EXCEPTION
462: WHEN OTHERS THEN
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
464: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_GEN_ERROR');
465: FND_MSG_PUB.add;
466: END IF;
467: x_return_status := FND_API.g_ret_sts_unexp_error;
468: END;

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

482: COMMIT WORK;
483: END IF;
484: -- Debug Message
485: IF OZF_DEBUG_LOW_ON THEN
486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
487: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
488: FND_MSG_PUB.Add;
489: END IF;
490: --Standard call to get message count and if count=1, get the message

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

483: END IF;
484: -- Debug Message
485: IF OZF_DEBUG_LOW_ON THEN
486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
487: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
488: FND_MSG_PUB.Add;
489: END IF;
490: --Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (

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

567: ELSIF l_type = 'FULLY_ACCRUED' THEN
568: x_ae_category := 'Accrual Budgets';
569: ELSE
570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
571: FND_MESSAGE.set_name('OZF', 'OZF_GL_FUND_TYPE_ERROR');
572: FND_MSG_PUB.add;
573: END IF;
574: x_return_status := FND_API.g_ret_sts_error;
575: END IF;

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

589: END IF;
590:
591: ELSE
592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
593: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');
594: FND_MSG_PUB.add;
595: END IF;
596: x_return_status := FND_API.g_ret_sts_error;
597: END IF;

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

597: END IF;
598: EXCEPTION
599: WHEN OTHERS THEN
600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
601: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_CATG_ERROR');
602: FND_MSG_PUB.add;
603: END IF;
604: x_return_status := FND_API.g_ret_sts_unexp_error;
605: END get_ae_category;

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

661: return 17;
662: -- R12.1 Changes End
663: ELSE
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');
666: FND_MSG_PUB.add;
667: END IF;
668: x_return_status := FND_API.g_ret_sts_error;
669: return null;

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

670: END IF;
671: EXCEPTION
672: WHEN OTHERS THEN
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('OZF', 'OZF_GL_EVE_NUM_ERROR');
675: FND_MSG_PUB.add;
676: END IF;
677: x_return_status := FND_API.g_ret_sts_unexp_error;
678: END get_event_number;

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

787: */
788: -- R12 changes end
789: ELSE
790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
791: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_ACCT_EVENT');
792: FND_MSG_PUB.add;
793: END IF;
794: x_return_status := FND_API.g_ret_sts_error;
795: return null;

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

796: END IF;
797: EXCEPTION
798: WHEN OTHERS THEN
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_TYPE_ERROR');
801: FND_MSG_PUB.add;
802: END IF;
803: x_return_status := FND_API.g_ret_sts_unexp_error;
804: END get_account_type_code;

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

860: CLOSE offer_code_csr;
861:
862: IF l_offer_code IS NOT NULL THEN
863: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
864: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
865: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');

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

861:
862: IF l_offer_code IS NOT NULL THEN
863: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
864: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
865: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
869: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);

Line 866: RETURN FND_MESSAGE.GET;

862: IF l_offer_code IS NOT NULL THEN
863: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
864: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
865: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
869: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
870: RETURN FND_MESSAGE.GET;

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

864: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_EXPENSE');
865: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
869: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
870: RETURN FND_MESSAGE.GET;
871: END IF;
872: END IF;

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

865: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
869: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
870: RETURN FND_MESSAGE.GET;
871: END IF;
872: END IF;
873: ELSIF l_ae_category = 'Accrual Budgets' THEN

Line 870: RETURN FND_MESSAGE.GET;

866: RETURN FND_MESSAGE.GET;
867: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
868: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_FB_ACCRUAL');
869: FND_MESSAGE.SET_TOKEN('OFFER', l_offer_code, FALSE);
870: RETURN FND_MESSAGE.GET;
871: END IF;
872: END IF;
873: ELSIF l_ae_category = 'Accrual Budgets' THEN
874: OPEN fund_number_csr(p_gl_rec.source_id);

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

875: FETCH fund_number_csr INTO l_fund_number;
876: CLOSE fund_number_csr;
877:
878: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
879: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
880: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');

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

876: CLOSE fund_number_csr;
877:
878: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
879: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
880: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
884: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);

Line 881: RETURN FND_MESSAGE.GET;

877:
878: IF p_account_type_code = 'EXPENSE ACCOUNT' THEN
879: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
880: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
884: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
885: RETURN FND_MESSAGE.GET;

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

879: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_EXPENSE');
880: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
884: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
885: RETURN FND_MESSAGE.GET;
886: END IF;
887: ELSIF l_ae_category = 'Settlement' THEN

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

880: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
884: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
885: RETURN FND_MESSAGE.GET;
886: END IF;
887: ELSIF l_ae_category = 'Settlement' THEN
888: OPEN claim_number_csr(p_gl_rec.source_id);

Line 885: RETURN FND_MESSAGE.GET;

881: RETURN FND_MESSAGE.GET;
882: ELSIF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
883: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_AB_ACCRUAL');
884: FND_MESSAGE.SET_TOKEN('FUND', l_fund_number, FALSE);
885: RETURN FND_MESSAGE.GET;
886: END IF;
887: ELSIF l_ae_category = 'Settlement' THEN
888: OPEN claim_number_csr(p_gl_rec.source_id);
889: FETCH claim_number_csr INTO l_claim_number;

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

889: FETCH claim_number_csr INTO l_claim_number;
890: CLOSE claim_number_csr;
891:
892: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
893: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
894: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
895: RETURN FND_MESSAGE.GET;
896: ELSIF p_account_type_code = 'REC_CLEARING' OR
897: p_account_type_code = 'VEN_CLEARING'

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

890: CLOSE claim_number_csr;
891:
892: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
893: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
894: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
895: RETURN FND_MESSAGE.GET;
896: ELSIF p_account_type_code = 'REC_CLEARING' OR
897: p_account_type_code = 'VEN_CLEARING'
898: THEN

Line 895: RETURN FND_MESSAGE.GET;

891:
892: IF p_account_type_code = 'ACCRUAL_LIABILITY' THEN
893: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_ACCRUAL');
894: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
895: RETURN FND_MESSAGE.GET;
896: ELSIF p_account_type_code = 'REC_CLEARING' OR
897: p_account_type_code = 'VEN_CLEARING'
898: THEN
899: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');

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

895: RETURN FND_MESSAGE.GET;
896: ELSIF p_account_type_code = 'REC_CLEARING' OR
897: p_account_type_code = 'VEN_CLEARING'
898: THEN
899: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
900: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
901: RETURN FND_MESSAGE.GET;
902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN

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

896: ELSIF p_account_type_code = 'REC_CLEARING' OR
897: p_account_type_code = 'VEN_CLEARING'
898: THEN
899: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
900: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
901: RETURN FND_MESSAGE.GET;
902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
904: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');

Line 901: RETURN FND_MESSAGE.GET;

897: p_account_type_code = 'VEN_CLEARING'
898: THEN
899: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_CLEARING');
900: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
901: RETURN FND_MESSAGE.GET;
902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
904: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
905: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);

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

900: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
901: RETURN FND_MESSAGE.GET;
902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
904: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
905: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
906: RETURN FND_MESSAGE.GET;
907: END IF;
908: END IF;

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

901: RETURN FND_MESSAGE.GET;
902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
904: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
905: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
906: RETURN FND_MESSAGE.GET;
907: END IF;
908: END IF;
909:

Line 906: RETURN FND_MESSAGE.GET;

902: -- Added for Bug 6751352
903: ELSIF p_account_type_code = 'EXPENSE ACCOUNT' THEN
904: FND_MESSAGE.SET_NAME('OZF', 'OZF_GL_DESC_STL_EXPENSE');
905: FND_MESSAGE.SET_TOKEN('CLAIM', l_claim_number, FALSE);
906: RETURN FND_MESSAGE.GET;
907: END IF;
908: END IF;
909:
910: RETURN null;

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

911:
912: EXCEPTION
913: WHEN OTHERS THEN
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
915: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACC_DESC_ERROR');
916: FND_MSG_PUB.add;
917: END IF;
918: x_return_status := FND_API.g_ret_sts_unexp_error;
919: END get_account_description;

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

1162: x_actg_tbl(1).CODE_COMBINATION_ID := l_dr_cc_id_tbl(1).code_combination_id;
1163: x_actg_tbl(1).ACCOUNT_TYPE := 'EXPENSE ACCOUNT';
1164: ELSE
1165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1166: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_EVENT');
1167: FND_MSG_PUB.add;
1168: END IF;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;

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

1205: END IF;
1206: -- if source table is different
1207: ELSE
1208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1209: FND_MESSAGE.set_name('OZF', 'OZF_GL_INVALID_SOURCE_TABLE');
1210: FND_MSG_PUB.add;
1211: END IF;
1212: x_return_status := FND_API.g_ret_sts_error;
1213: END IF;

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

1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: WHEN OTHERS THEN
1221: OZF_UTILITY_PVT.debug_message('sqlerrm:'|| sqlerrm);
1222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1223: FND_MESSAGE.set_name('OZF', 'OZF_GL_LINE_AMOUNT_CALC_ERROR');
1224: FND_MSG_PUB.add;
1225: END IF;
1226: x_return_status := FND_API.g_ret_sts_unexp_error;
1227: END;

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

1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: WHEN OTHERS THEN
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCTNG_EVENT_ERROR');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: x_return_status := FND_API.g_ret_sts_unexp_error;
1432: END Construct_Acctng_Event_Rec;

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

1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1515: WHEN OTHERS THEN
1516: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1517: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_HEADER_ERROR');
1518: FND_MSG_PUB.add;
1519: END IF;
1520: x_return_status := FND_API.g_ret_sts_unexp_error;
1521: END Construct_Header_Rec;

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

1593: CLOSE get_fxgl_loss_ccid_csr;
1594:
1595: IF l_fxgl_gain_ccid is null THEN
1596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1597: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_FXGL_ACCOUNT_SETUP');
1598: FND_MSG_PUB.add;
1599: END IF;
1600: x_return_status := FND_API.g_ret_sts_error;
1601: return;

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

1758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760: WHEN OTHERS THEN
1761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1762: FND_MESSAGE.set_name('OZF', 'OZF_GL_AE_LINE_ERROR');
1763: FND_MSG_PUB.add;
1764: END IF;
1765: x_return_status := FND_API.g_ret_sts_unexp_error;
1766: END Construct_Line_Rec;

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

1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1797: END IF;
1798: -- Debug Message
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: --Initialize message list if p_init_msg_list is TRUE.

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

1797: END IF;
1798: -- Debug Message
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: --Initialize message list if p_init_msg_list is TRUE.
1805: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

1861: END IF;
1862:
1863: -- Debug Message
1864: IF OZF_DEBUG_LOW_ON THEN
1865: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1866: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1867: FND_MSG_PUB.Add;
1868: END IF;
1869: --Standard call to get message count and if count=1, get the message

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

1862:
1863: -- Debug Message
1864: IF OZF_DEBUG_LOW_ON THEN
1865: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1866: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1867: FND_MSG_PUB.Add;
1868: END IF;
1869: --Standard call to get message count and if count=1, get the message
1870: FND_MSG_PUB.Count_And_Get (

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

1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END IF;
1996: -- Debug Message
1997: IF OZF_DEBUG_LOW_ON THEN
1998: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1999: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2000: FND_MSG_PUB.Add;
2001: END IF;
2002: --Initialize message list if p_init_msg_list is TRUE.

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

1995: END IF;
1996: -- Debug Message
1997: IF OZF_DEBUG_LOW_ON THEN
1998: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1999: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2000: FND_MSG_PUB.Add;
2001: END IF;
2002: --Initialize message list if p_init_msg_list is TRUE.
2003: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

2156: COMMIT WORK;
2157: END IF;
2158: -- Debug Message
2159: IF OZF_DEBUG_LOW_ON THEN
2160: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2161: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2162: FND_MSG_PUB.Add;
2163: END IF;
2164: --Standard call to get message count and if count=1, get the message

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

2157: END IF;
2158: -- Debug Message
2159: IF OZF_DEBUG_LOW_ON THEN
2160: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2161: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2162: FND_MSG_PUB.Add;
2163: END IF;
2164: --Standard call to get message count and if count=1, get the message
2165: FND_MSG_PUB.Count_And_Get (

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

2349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2350: END IF;
2351: -- Debug Message
2352: IF OZF_DEBUG_LOW_ON THEN
2353: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2354: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2355: FND_MSG_PUB.Add;
2356: END IF;
2357: --Initialize message list if p_init_msg_list is TRUE.

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

2350: END IF;
2351: -- Debug Message
2352: IF OZF_DEBUG_LOW_ON THEN
2353: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2354: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2355: FND_MSG_PUB.Add;
2356: END IF;
2357: --Initialize message list if p_init_msg_list is TRUE.
2358: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

2595: COMMIT WORK;
2596: END IF;
2597: -- Debug Message
2598: IF OZF_DEBUG_LOW_ON THEN
2599: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2600: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2601: FND_MSG_PUB.Add;
2602: END IF;
2603: --Standard call to get message count and if count=1, get the message

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

2596: END IF;
2597: -- Debug Message
2598: IF OZF_DEBUG_LOW_ON THEN
2599: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2600: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2601: FND_MSG_PUB.Add;
2602: END IF;
2603: --Standard call to get message count and if count=1, get the message
2604: FND_MSG_PUB.Count_And_Get (

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

2730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2731: END IF;
2732: -- Debug Message
2733: IF OZF_DEBUG_LOW_ON THEN
2734: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2735: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2736: FND_MSG_PUB.Add;
2737: END IF;
2738: --Initialize message list if p_init_msg_list is TRUE.

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

2731: END IF;
2732: -- Debug Message
2733: IF OZF_DEBUG_LOW_ON THEN
2734: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2735: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2736: FND_MSG_PUB.Add;
2737: END IF;
2738: --Initialize message list if p_init_msg_list is TRUE.
2739: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

2760: CLOSE chk_ae_exist;
2761:
2762: IF l_acc_event_id IS NOT NULL THEN
2763: IF OZF_DEBUG_HIGH_ON THEN
2764: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2765: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2766: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2767: FND_MSG_PUB.add;
2768: END IF;

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

2761:
2762: IF l_acc_event_id IS NOT NULL THEN
2763: IF OZF_DEBUG_HIGH_ON THEN
2764: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2765: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2766: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2767: FND_MSG_PUB.add;
2768: END IF;
2769: RAISE FND_API.G_EXC_ERROR;

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

2762: IF l_acc_event_id IS NOT NULL THEN
2763: IF OZF_DEBUG_HIGH_ON THEN
2764: FND_MESSAGE.set_name('OZF', 'OZF_ACCT_GL_ENTRY_EXIST');
2765: FND_MESSAGE.set_token('SOURCE_ID', p_gl_rec.source_id);
2766: FND_MESSAGE.set_token('SOURCE_TABLE', p_gl_rec.source_table);
2767: FND_MSG_PUB.add;
2768: END IF;
2769: RAISE FND_API.G_EXC_ERROR;
2770: END IF;

Line 2792: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_SYSPARAM');

2788:
2789: IF l_post_to_gl = 'X' THEN --ninarasi fix for bug 13793109
2790: OZF_Utility_PVT.debug_message('Inside null : '||l_post_to_gl);
2791: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_SYSPARAM');
2793: FND_MSG_PUB.add;
2794: END IF;
2795: x_return_status := FND_API.g_ret_sts_error;
2796: return;

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

2931: x_ae_line_tbl => l_ae_line_tbl );
2932:
2933: IF x_return_status = FND_API.g_ret_sts_error THEN
2934: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2935: -- FND_MESSAGE.set_name('OZF', 'OZF_GL_ACCT_RULE_ERROR');
2936: -- FND_MSG_PUB.add;
2937: --END IF;
2938: RAISE FND_API.G_EXC_ERROR;
2939: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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

3022: COMMIT WORK;
3023: END IF;
3024: -- Debug Message
3025: IF OZF_DEBUG_LOW_ON THEN
3026: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3027: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3028: FND_MSG_PUB.Add;
3029: END IF;
3030: --Standard call to get message count and if count=1, get the message

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

3023: END IF;
3024: -- Debug Message
3025: IF OZF_DEBUG_LOW_ON THEN
3026: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3027: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3028: FND_MSG_PUB.Add;
3029: END IF;
3030: --Standard call to get message count and if count=1, get the message
3031: FND_MSG_PUB.Count_And_Get (

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

3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3129: END IF;
3130: -- Debug Message
3131: IF OZF_DEBUG_LOW_ON THEN
3132: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3133: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3134: FND_MSG_PUB.Add;
3135: END IF;
3136: --Initialize message list if p_init_msg_list is TRUE.

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

3129: END IF;
3130: -- Debug Message
3131: IF OZF_DEBUG_LOW_ON THEN
3132: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3133: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3134: FND_MSG_PUB.Add;
3135: END IF;
3136: --Initialize message list if p_init_msg_list is TRUE.
3137: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

3146:
3147: -- raise error if the event status code is already accounted
3148: IF l_event_status_code = 'ACCOUNTED' THEN
3149: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3150: FND_MESSAGE.set_name('OZF', 'OZF_GL_INCORR_EVENT_STATUS');
3151: FND_MSG_PUB.add;
3152: END IF;
3153: RAISE FND_API.G_EXC_ERROR;
3154: END IF;

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

3233: COMMIT WORK;
3234: END IF;
3235: -- Debug Message
3236: IF OZF_DEBUG_LOW_ON THEN
3237: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3238: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3239: FND_MSG_PUB.Add;
3240: END IF;
3241: --Standard call to get message count and if count=1, get the message

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

3234: END IF;
3235: -- Debug Message
3236: IF OZF_DEBUG_LOW_ON THEN
3237: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3238: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3239: FND_MSG_PUB.Add;
3240: END IF;
3241: --Standard call to get message count and if count=1, get the message
3242: FND_MSG_PUB.Count_And_Get (

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

3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: END IF;
3450:
3451: IF OZF_DEBUG_LOW_ON THEN
3452: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3453: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3454: FND_MSG_PUB.Add;
3455: END IF;
3456:

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

3449: END IF;
3450:
3451: IF OZF_DEBUG_LOW_ON THEN
3452: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3453: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3454: FND_MSG_PUB.Add;
3455: END IF;
3456:
3457: --Initialize message list if p_init_msg_list is TRUE.

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

3752: COMMIT WORK;
3753: END IF;
3754: -- Debug Message
3755: IF OZF_DEBUG_LOW_ON THEN
3756: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3757: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3758: FND_MSG_PUB.Add;
3759: FND_MSG_PUB.Add;
3760: END IF;

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

3753: END IF;
3754: -- Debug Message
3755: IF OZF_DEBUG_LOW_ON THEN
3756: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3757: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3758: FND_MSG_PUB.Add;
3759: FND_MSG_PUB.Add;
3760: END IF;
3761: --Standard call to get message count and if count=1, get the message

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

3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: END IF;
3857: -- Debug Message
3858: IF OZF_DEBUG_LOW_ON THEN
3859: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3860: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3861: FND_MSG_PUB.Add;
3862: END IF;
3863: --Initialize message list if p_init_msg_list is TRUE.

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

3856: END IF;
3857: -- Debug Message
3858: IF OZF_DEBUG_LOW_ON THEN
3859: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3860: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
3861: FND_MSG_PUB.Add;
3862: END IF;
3863: --Initialize message list if p_init_msg_list is TRUE.
3864: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

3912: COMMIT WORK;
3913: END IF;
3914: -- Debug Message
3915: IF OZF_DEBUG_LOW_ON THEN
3916: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3917: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3918: FND_MSG_PUB.Add;
3919: END IF;
3920: --Standard call to get message count and if count=1, get the message

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

3913: END IF;
3914: -- Debug Message
3915: IF OZF_DEBUG_LOW_ON THEN
3916: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3917: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3918: FND_MSG_PUB.Add;
3919: END IF;
3920: --Standard call to get message count and if count=1, get the message
3921: FND_MSG_PUB.Count_And_Get (

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

4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: END IF;
4023: -- Debug Message
4024: IF OZF_DEBUG_LOW_ON THEN
4025: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4026: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
4027: FND_MSG_PUB.Add;
4028: END IF;
4029: --Initialize message list if p_init_msg_list is TRUE.

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

4022: END IF;
4023: -- Debug Message
4024: IF OZF_DEBUG_LOW_ON THEN
4025: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4026: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
4027: FND_MSG_PUB.Add;
4028: END IF;
4029: --Initialize message list if p_init_msg_list is TRUE.
4030: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

4102: COMMIT WORK;
4103: END IF;
4104: -- Debug Message
4105: IF OZF_DEBUG_LOW_ON THEN
4106: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4107: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Standard call to get message count and if count=1, get the message

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

4103: END IF;
4104: -- Debug Message
4105: IF OZF_DEBUG_LOW_ON THEN
4106: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4107: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Standard call to get message count and if count=1, get the message
4111: FND_MSG_PUB.Count_And_Get (