DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on FND_MESSAGE

Line 289: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');

285: x_return_status := FND_API.g_ret_sts_success;
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
289: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
290: FND_MSG_PUB.add;
291: END IF;
292: x_return_status := FND_API.g_ret_sts_unexp_error;
293: END Query_Claim;

Line 530: FND_MESSAGE.set_name('OZF', 'OZF_AR_DISTRIBUTE_ERROR');

526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('OZF', 'OZF_AR_DISTRIBUTE_ERROR');
531: FND_MSG_PUB.add;
532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN
534: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

530: FND_MESSAGE.set_name('OZF', 'OZF_AR_DISTRIBUTE_ERROR');
531: FND_MSG_PUB.add;
532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN
534: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
535: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
536: FND_MSG_PUB.Add;
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 535: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

531: FND_MSG_PUB.add;
532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN
534: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
535: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
536: FND_MSG_PUB.Add;
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;
539: END Insert_Int_Distributions ;

Line 734: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');

730: x_return_status := FND_API.g_ret_sts_success;
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
734: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
735: FND_MSG_PUB.add;
736: END IF;
737: IF OZF_DEBUG_LOW_ON THEN
738: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

734: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
735: FND_MSG_PUB.add;
736: END IF;
737: IF OZF_DEBUG_LOW_ON THEN
738: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
739: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
740: FND_MSG_PUB.Add;
741: END IF;
742: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 739: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

735: FND_MSG_PUB.add;
736: END IF;
737: IF OZF_DEBUG_LOW_ON THEN
738: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
739: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
740: FND_MSG_PUB.Add;
741: END IF;
742: x_return_status := FND_API.g_ret_sts_unexp_error;
743: END Insert_Interface_Line ;

Line 859: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');

855: x_return_status := FND_API.g_ret_sts_success;
856: EXCEPTION
857: WHEN OTHERS THEN
858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
859: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
860: FND_MSG_PUB.add;
861: END IF;
862: IF OZF_DEBUG_LOW_ON THEN
863: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

859: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
860: FND_MSG_PUB.add;
861: END IF;
862: IF OZF_DEBUG_LOW_ON THEN
863: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
864: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
865: FND_MSG_PUB.Add;
866: END IF;
867: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 864: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

860: FND_MSG_PUB.add;
861: END IF;
862: IF OZF_DEBUG_LOW_ON THEN
863: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
864: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
865: FND_MSG_PUB.Add;
866: END IF;
867: x_return_status := FND_API.g_ret_sts_unexp_error;
868: END Insert_Interface_Tax;

Line 968: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');

964: x_return_status := FND_API.g_ret_sts_success;
965: EXCEPTION
966: WHEN OTHERS THEN
967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
968: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
969: FND_MSG_PUB.add;
970: END IF;
971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
972: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

968: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
969: FND_MSG_PUB.add;
970: END IF;
971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
972: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
973: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
974: FND_MSG_PUB.Add;
975: END IF;
976: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 973: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

969: FND_MSG_PUB.add;
970: END IF;
971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
972: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
973: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
974: FND_MSG_PUB.Add;
975: END IF;
976: x_return_status := FND_API.g_ret_sts_unexp_error;
977: END Insert_Interface_Sales_Credits;

Line 1194: FND_MESSAGE.set_name('OZF','OZF_BATCH_SRC_REQ_FOR_INTF');

1190: CLOSE sys_param_csr;
1191:
1192: IF (l_batch_source_id IS NULL) THEN
1193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1194: FND_MESSAGE.set_name('OZF','OZF_BATCH_SRC_REQ_FOR_INTF');
1195: FND_MSG_PUB.add;
1196: END IF;
1197: x_return_status := FND_API.g_ret_sts_error;
1198: ELSE

Line 1350: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');

1346: IF ( p_claim_rec.payment_method IS NULL OR
1347: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )
1348: THEN
1349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1350: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');
1351: FND_MSG_PUB.add;
1352: END IF;
1353: ELSIF p_claim_rec.payment_method IS NOT NULL THEN
1354: -- Now get Trx_type from the claim type

Line 1406: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_TERM');

1402: END IF;
1403:
1404: IF p_x_interface_line_rec.TERM_ID IS NULL THEN
1405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1406: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_TERM');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_return_status := FND_API.g_ret_sts_error;
1410: END IF;

Line 1422: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');

1418: p_x_interface_line_rec.AMOUNT := p_line_claim_curr_amt;
1419:
1420: ELSE
1421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1422: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');
1423: FND_MSG_PUB.add;
1424: END IF;
1425: x_return_status := FND_API.g_ret_sts_error;
1426: END IF;

Line 1438: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');

1434: IF ( p_claim_rec.payment_method IN ('CHARGEBACK','DEBIT_MEMO') )
1435: THEN
1436: IF l_billback_trx_type_id IS NULL THEN
1437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1438: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');
1439: FND_MSG_PUB.add;
1440: END IF;
1441: x_return_status := FND_API.g_ret_sts_error;
1442: ELSE

Line 1448: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');

1444: END IF;
1445: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN
1446: IF l_cm_trx_type_id IS NULL THEN
1447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1448: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');
1449: FND_MSG_PUB.add;
1450: END IF;
1451: x_return_status := FND_API.g_ret_sts_error;
1452: ELSE

Line 1588: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');

1584: CLOSE csr_claim_line_product ;
1585: END IF;
1586:
1587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1588: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1589: FND_MSG_PUB.add;
1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN
1592: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

1588: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1589: FND_MSG_PUB.add;
1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN
1592: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1593: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1594: FND_MSG_PUB.Add;
1595: END IF;
1596: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1593: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1589: FND_MSG_PUB.add;
1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN
1592: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1593: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1594: FND_MSG_PUB.Add;
1595: END IF;
1596: x_return_status := FND_API.g_ret_sts_unexp_error;
1597: END Populate_Interface_Line_Rec;

Line 1689: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');

1685:
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1689: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN
1693: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

1689: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN
1693: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1694: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1695: FND_MSG_PUB.Add;
1696: END IF;
1697: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1694: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1690: FND_MSG_PUB.add;
1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN
1693: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1694: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1695: FND_MSG_PUB.Add;
1696: END IF;
1697: x_return_status := FND_API.g_ret_sts_unexp_error;
1698: END Populate_Interface_Tax_Rec;

Line 1793: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');

1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN
1797: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

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

1793: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN
1797: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1798: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1799: FND_MSG_PUB.Add;
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1798: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1794: FND_MSG_PUB.add;
1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN
1797: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1798: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1799: FND_MSG_PUB.Add;
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;
1802: END Populate_Distributions_Rec;

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

2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
2061: -- Debug Message
2062: IF OZF_DEBUG_LOW_ON THEN
2063: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2064: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2065: FND_MSG_PUB.Add;
2066: END IF;
2067: --Initialize message list if p_init_msg_list is TRUE.

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

2060: END IF;
2061: -- Debug Message
2062: IF OZF_DEBUG_LOW_ON THEN
2063: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2064: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2065: FND_MSG_PUB.Add;
2066: END IF;
2067: --Initialize message list if p_init_msg_list is TRUE.
2068: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

2165: COMMIT WORK;
2166: END IF;
2167: -- Debug Message
2168: IF OZF_DEBUG_LOW_ON THEN
2169: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2170: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2171: FND_MSG_PUB.Add;
2172: END IF;
2173: --Standard call to get message count and if count=1, get the message

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

2166: END IF;
2167: -- Debug Message
2168: IF OZF_DEBUG_LOW_ON THEN
2169: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2170: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2171: FND_MSG_PUB.Add;
2172: END IF;
2173: --Standard call to get message count and if count=1, get the message
2174: FND_MSG_PUB.Count_And_Get (