DBA Data[Home] [Help]

APPS.OZF_OM_PAYMENT_PVT dependencies on FND_MSG_PUB

Line 7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_OM_PAYMENT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(15) := 'ozfvompb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8:
9: /*=======================================================================*
10: | PROCEDURE
11: | Query_Claim

Line 281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

277:
278: x_return_status := FND_API.g_ret_sts_success;
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
282: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
283: FND_MSG_PUB.add;
284: END IF;
285: IF OZF_DEBUG_HIGH_ON THEN

Line 283: FND_MSG_PUB.add;

279: EXCEPTION
280: WHEN OTHERS THEN
281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
282: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
283: FND_MSG_PUB.add;
284: END IF;
285: IF OZF_DEBUG_HIGH_ON THEN
286: OZF_Utility_PVT.debug_message('Claim Id = '|| p_claim_id);
287: OZF_Utility_PVT.debug_message('SQLERRM = '|| SQLERRM);

Line 348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

344:
345: x_return_status := FND_API.g_ret_sts_success;
346: EXCEPTION
347: WHEN OTHERS THEN
348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
349: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
350: FND_MSG_PUB.add;
351: END IF;
352: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 350: FND_MSG_PUB.add;

346: EXCEPTION
347: WHEN OTHERS THEN
348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
349: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
350: FND_MSG_PUB.add;
351: END IF;
352: x_return_status := FND_API.g_ret_sts_unexp_error;
353:
354: END Query_Claim_Line;

Line 717: FND_MSG_PUB.ADD;

713: , p_encoded => 'F'
714: );
715: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
716: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
717: FND_MSG_PUB.ADD;
718: END LOOP;
719: RAISE FND_API.g_exc_error;
720: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
721: FOR i in 1 .. l_oe_msg_count LOOP

Line 727: FND_MSG_PUB.ADD;

723: , p_encoded => 'F'
724: );
725: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
726: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
727: FND_MSG_PUB.ADD;
728: END LOOP;
729: RAISE FND_API.g_exc_unexpected_error;
730: END IF;
731:

Line 759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

755:
756: IF p_claim_line_tbl(i).rate IS NOT NULL AND
757: l_rma_unit_price <> p_claim_line_tbl(i).rate THEN
758: IF l_modifer_line_id IS NULL THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
760: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_MODIFIER_ERR');
761: FND_MSG_PUB.add;
762: END IF;
763: RAISE FND_API.g_exc_error;

Line 761: FND_MSG_PUB.add;

757: l_rma_unit_price <> p_claim_line_tbl(i).rate THEN
758: IF l_modifer_line_id IS NULL THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
760: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_MODIFIER_ERR');
761: FND_MSG_PUB.add;
762: END IF;
763: RAISE FND_API.g_exc_error;
764: ELSE
765: l_rma_price_diff := l_rma_unit_price - p_claim_line_tbl(i).rate;

Line 859: FND_MSG_PUB.ADD;

855: , p_encoded => 'F'
856: );
857: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
858: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
859: FND_MSG_PUB.ADD;
860: END LOOP;
861: RAISE FND_API.g_exc_error;
862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: FOR i in 1 .. l_oe_msg_count LOOP

Line 869: FND_MSG_PUB.ADD;

865: , p_encoded => 'F'
866: );
867: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
868: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
869: FND_MSG_PUB.ADD;
870: END LOOP;
871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
872: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
873: FND_MSG_PUB.add;

Line 871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

867: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
868: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
869: FND_MSG_PUB.ADD;
870: END LOOP;
871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
872: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
873: FND_MSG_PUB.add;
874: END IF;
875: RAISE FND_API.g_exc_unexpected_error;

Line 873: FND_MSG_PUB.add;

869: FND_MSG_PUB.ADD;
870: END LOOP;
871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
872: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
873: FND_MSG_PUB.add;
874: END IF;
875: RAISE FND_API.g_exc_unexpected_error;
876: END IF;
877: END IF;

Line 917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

913: x_return_status := FND_API.g_ret_sts_unexp_error ;
914:
915: WHEN OTHERS THEN
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
919: END IF;
920:
921: END Complete_RMA_Order;

Line 918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

914:
915: WHEN OTHERS THEN
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
919: END IF;
920:
921: END Complete_RMA_Order;
922:

Line 1060: FND_MSG_PUB.ADD;

1056: , p_encoded => 'F'
1057: );
1058: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1059: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1060: FND_MSG_PUB.ADD;
1061: END LOOP;
1062:
1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1064: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');

Line 1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1059: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1060: FND_MSG_PUB.ADD;
1061: END LOOP;
1062:
1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1064: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1065: FND_MSG_PUB.add;
1066: END IF;
1067: RAISE FND_API.g_exc_error;

Line 1065: FND_MSG_PUB.add;

1061: END LOOP;
1062:
1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1064: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1065: FND_MSG_PUB.add;
1066: END IF;
1067: RAISE FND_API.g_exc_error;
1068:
1069: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

Line 1076: FND_MSG_PUB.ADD;

1072: , p_encoded => 'F'
1073: );
1074: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1075: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1076: FND_MSG_PUB.ADD;
1077: END LOOP;
1078:
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');

Line 1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1075: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1076: FND_MSG_PUB.ADD;
1077: END LOOP;
1078:
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1081: FND_MSG_PUB.add;
1082: END IF;
1083: RAISE FND_API.g_exc_error;

Line 1081: FND_MSG_PUB.add;

1077: END LOOP;
1078:
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1081: FND_MSG_PUB.add;
1082: END IF;
1083: RAISE FND_API.g_exc_error;
1084: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1085: FOR i in 1 .. l_oe_msg_count LOOP

Line 1091: FND_MSG_PUB.ADD;

1087: , p_encoded => 'F'
1088: );
1089: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1090: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1091: FND_MSG_PUB.ADD;
1092: END LOOP;
1093:
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1095: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');

Line 1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1090: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1091: FND_MSG_PUB.ADD;
1092: END LOOP;
1093:
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1095: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: RAISE FND_API.g_exc_unexpected_error;

Line 1096: FND_MSG_PUB.add;

1092: END LOOP;
1093:
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1095: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: RAISE FND_API.g_exc_unexpected_error;
1099: END IF;
1100:

Line 1113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1109: x_return_status := FND_API.g_ret_sts_unexp_error ;
1110:
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.g_ret_sts_unexp_error ;
1113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1114: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1115: END IF;
1116:
1117: END Book_RMA_Order;

Line 1114: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1110:
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.g_ret_sts_unexp_error ;
1113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1114: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1115: END IF;
1116:
1117: END Book_RMA_Order;
1118:

Line 1159: FND_MSG_PUB.initialize;

1155: OZF_Utility_PVT.debug_message(l_full_name||': start');
1156: END IF;
1157:
1158: IF FND_API.to_boolean(p_init_msg_list) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161:
1162:
1163: IF NOT FND_API.compatible_api_call(

Line 1250: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1246: SET payment_status = 'PENDING'
1247: WHERE claim_id = p_claim_id;
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1251: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
1252: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
1253: FND_MSG_PUB.ADD;
1254: END IF;

Line 1253: FND_MSG_PUB.ADD;

1249: WHEN OTHERS THEN
1250: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1251: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
1252: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
1253: FND_MSG_PUB.ADD;
1254: END IF;
1255: END;
1256:
1257: ------------------------ finish ------------------------

Line 1258: FND_MSG_PUB.count_and_get(

1254: END IF;
1255: END;
1256:
1257: ------------------------ finish ------------------------
1258: FND_MSG_PUB.count_and_get(
1259: p_encoded => FND_API.g_false,
1260: p_count => x_msg_count,
1261: p_data => x_msg_data
1262: );

Line 1271: FND_MSG_PUB.count_and_get (

1267: EXCEPTION
1268: WHEN FND_API.g_exc_error THEN
1269: ROLLBACK TO Create_OM_Payment;
1270: x_return_status := FND_API.g_ret_sts_error;
1271: FND_MSG_PUB.count_and_get (
1272: p_encoded => FND_API.g_false
1273: ,p_count => x_msg_count
1274: ,p_data => x_msg_data
1275: );

Line 1280: FND_MSG_PUB.count_and_get (

1276:
1277: WHEN FND_API.g_exc_unexpected_error THEN
1278: ROLLBACK TO Create_OM_Payment;
1279: x_return_status := FND_API.g_ret_sts_unexp_error ;
1280: FND_MSG_PUB.count_and_get (
1281: p_encoded => FND_API.g_false
1282: ,p_count => x_msg_count
1283: ,p_data => x_msg_data
1284: );

Line 1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1285:
1286: WHEN OTHERS THEN
1287: ROLLBACK TO Create_OM_Payment;
1288: x_return_status := FND_API.g_ret_sts_unexp_error ;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1290: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1291: END IF;
1292: FND_MSG_PUB.count_and_get(
1293: p_encoded => FND_API.g_false

Line 1290: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1286: WHEN OTHERS THEN
1287: ROLLBACK TO Create_OM_Payment;
1288: x_return_status := FND_API.g_ret_sts_unexp_error ;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1290: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1291: END IF;
1292: FND_MSG_PUB.count_and_get(
1293: p_encoded => FND_API.g_false
1294: ,p_count => x_msg_count

Line 1292: FND_MSG_PUB.count_and_get(

1288: x_return_status := FND_API.g_ret_sts_unexp_error ;
1289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1290: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1291: END IF;
1292: FND_MSG_PUB.count_and_get(
1293: p_encoded => FND_API.g_false
1294: ,p_count => x_msg_count
1295: ,p_data => x_msg_data
1296: );