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 723: FND_MSG_PUB.ADD;

719: , p_encoded => 'F'
720: );
721: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
722: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
723: FND_MSG_PUB.ADD;
724: END LOOP;
725: RAISE FND_API.g_exc_error;
726: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
727: FOR i in 1 .. l_oe_msg_count LOOP

Line 733: FND_MSG_PUB.ADD;

729: , p_encoded => 'F'
730: );
731: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
732: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
733: FND_MSG_PUB.ADD;
734: END LOOP;
735: RAISE FND_API.g_exc_unexpected_error;
736: END IF;
737:

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

761:
762: IF p_claim_line_tbl(i).rate IS NOT NULL AND
763: l_rma_unit_price <> p_claim_line_tbl(i).rate THEN
764: IF l_modifer_line_id IS NULL THEN
765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
766: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_MODIFIER_ERR');
767: FND_MSG_PUB.add;
768: END IF;
769: RAISE FND_API.g_exc_error;

Line 767: FND_MSG_PUB.add;

763: l_rma_unit_price <> p_claim_line_tbl(i).rate THEN
764: IF l_modifer_line_id IS NULL THEN
765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
766: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_MODIFIER_ERR');
767: FND_MSG_PUB.add;
768: END IF;
769: RAISE FND_API.g_exc_error;
770: ELSE
771: l_rma_price_diff := l_rma_unit_price - p_claim_line_tbl(i).rate;

Line 865: FND_MSG_PUB.ADD;

861: , p_encoded => 'F'
862: );
863: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
864: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
865: FND_MSG_PUB.ADD;
866: END LOOP;
867: RAISE FND_API.g_exc_error;
868: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
869: FOR i in 1 .. l_oe_msg_count LOOP

Line 875: FND_MSG_PUB.ADD;

871: , p_encoded => 'F'
872: );
873: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
874: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
875: FND_MSG_PUB.ADD;
876: END LOOP;
877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
879: FND_MSG_PUB.add;

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

873: FND_MESSAGE.SET_NAME('AMS', 'AMS_API_DEBUG_MESSAGE');
874: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
875: FND_MSG_PUB.ADD;
876: END LOOP;
877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
879: FND_MSG_PUB.add;
880: END IF;
881: RAISE FND_API.g_exc_unexpected_error;

Line 879: FND_MSG_PUB.add;

875: FND_MSG_PUB.ADD;
876: END LOOP;
877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_SETL_OM_CRE_ORD_U_ERR');
879: FND_MSG_PUB.add;
880: END IF;
881: RAISE FND_API.g_exc_unexpected_error;
882: END IF;
883: END IF;

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

919: x_return_status := FND_API.g_ret_sts_unexp_error ;
920:
921: WHEN OTHERS THEN
922: x_return_status := FND_API.g_ret_sts_unexp_error ;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
924: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
925: END IF;
926:
927: END Complete_RMA_Order;

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

920:
921: WHEN OTHERS THEN
922: x_return_status := FND_API.g_ret_sts_unexp_error ;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
924: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
925: END IF;
926:
927: END Complete_RMA_Order;
928:

Line 1066: FND_MSG_PUB.ADD;

1062: , p_encoded => 'F'
1063: );
1064: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1065: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1066: FND_MSG_PUB.ADD;
1067: END LOOP;
1068:
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');

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

1065: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1066: FND_MSG_PUB.ADD;
1067: END LOOP;
1068:
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: RAISE FND_API.g_exc_error;

Line 1071: FND_MSG_PUB.add;

1067: END LOOP;
1068:
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: RAISE FND_API.g_exc_error;
1074:
1075: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

Line 1082: FND_MSG_PUB.ADD;

1078: , p_encoded => 'F'
1079: );
1080: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1081: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1082: FND_MSG_PUB.ADD;
1083: END LOOP;
1084:
1085: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1086: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');

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

1081: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1082: FND_MSG_PUB.ADD;
1083: END LOOP;
1084:
1085: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1086: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1087: FND_MSG_PUB.add;
1088: END IF;
1089: RAISE FND_API.g_exc_error;

Line 1087: FND_MSG_PUB.add;

1083: END LOOP;
1084:
1085: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1086: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_E_ERR');
1087: FND_MSG_PUB.add;
1088: END IF;
1089: RAISE FND_API.g_exc_error;
1090: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1091: FOR i in 1 .. l_oe_msg_count LOOP

Line 1097: FND_MSG_PUB.ADD;

1093: , p_encoded => 'F'
1094: );
1095: FND_MESSAGE.SET_NAME('OZF', 'OZF_API_DEBUG_MESSAGE');
1096: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1097: FND_MSG_PUB.ADD;
1098: END LOOP;
1099:
1100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1101: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');

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

1096: FND_MESSAGE.SET_TOKEN('TEXT', l_oe_msg_data);
1097: FND_MSG_PUB.ADD;
1098: END LOOP;
1099:
1100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1101: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');
1102: FND_MSG_PUB.add;
1103: END IF;
1104: RAISE FND_API.g_exc_unexpected_error;

Line 1102: FND_MSG_PUB.add;

1098: END LOOP;
1099:
1100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1101: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OM_BOK_ORD_U_ERR');
1102: FND_MSG_PUB.add;
1103: END IF;
1104: RAISE FND_API.g_exc_unexpected_error;
1105: END IF;
1106:

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

1115: x_return_status := FND_API.g_ret_sts_unexp_error ;
1116:
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.g_ret_sts_unexp_error ;
1119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1121: END IF;
1122:
1123: END Book_RMA_Order;

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

1116:
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.g_ret_sts_unexp_error ;
1119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1121: END IF;
1122:
1123: END Book_RMA_Order;
1124:

Line 1165: FND_MSG_PUB.initialize;

1161: OZF_Utility_PVT.debug_message(l_full_name||': start');
1162: END IF;
1163:
1164: IF FND_API.to_boolean(p_init_msg_list) THEN
1165: FND_MSG_PUB.initialize;
1166: END IF;
1167:
1168:
1169: IF NOT FND_API.compatible_api_call(

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

1252: SET payment_status = 'PENDING'
1253: WHERE claim_id = p_claim_id;
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
1258: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
1259: FND_MSG_PUB.ADD;
1260: END IF;

Line 1259: FND_MSG_PUB.ADD;

1255: WHEN OTHERS THEN
1256: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
1258: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);
1259: FND_MSG_PUB.ADD;
1260: END IF;
1261: END;
1262:
1263: ------------------------ finish ------------------------

Line 1264: FND_MSG_PUB.count_and_get(

1260: END IF;
1261: END;
1262:
1263: ------------------------ finish ------------------------
1264: FND_MSG_PUB.count_and_get(
1265: p_encoded => FND_API.g_false,
1266: p_count => x_msg_count,
1267: p_data => x_msg_data
1268: );

Line 1277: FND_MSG_PUB.count_and_get (

1273: EXCEPTION
1274: WHEN FND_API.g_exc_error THEN
1275: ROLLBACK TO Create_OM_Payment;
1276: x_return_status := FND_API.g_ret_sts_error;
1277: FND_MSG_PUB.count_and_get (
1278: p_encoded => FND_API.g_false
1279: ,p_count => x_msg_count
1280: ,p_data => x_msg_data
1281: );

Line 1286: FND_MSG_PUB.count_and_get (

1282:
1283: WHEN FND_API.g_exc_unexpected_error THEN
1284: ROLLBACK TO Create_OM_Payment;
1285: x_return_status := FND_API.g_ret_sts_unexp_error ;
1286: FND_MSG_PUB.count_and_get (
1287: p_encoded => FND_API.g_false
1288: ,p_count => x_msg_count
1289: ,p_data => x_msg_data
1290: );

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

1291:
1292: WHEN OTHERS THEN
1293: ROLLBACK TO Create_OM_Payment;
1294: x_return_status := FND_API.g_ret_sts_unexp_error ;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1297: END IF;
1298: FND_MSG_PUB.count_and_get(
1299: p_encoded => FND_API.g_false

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

1292: WHEN OTHERS THEN
1293: ROLLBACK TO Create_OM_Payment;
1294: x_return_status := FND_API.g_ret_sts_unexp_error ;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1297: END IF;
1298: FND_MSG_PUB.count_and_get(
1299: p_encoded => FND_API.g_false
1300: ,p_count => x_msg_count

Line 1298: FND_MSG_PUB.count_and_get(

1294: x_return_status := FND_API.g_ret_sts_unexp_error ;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1296: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1297: END IF;
1298: FND_MSG_PUB.count_and_get(
1299: p_encoded => FND_API.g_false
1300: ,p_count => x_msg_count
1301: ,p_data => x_msg_data
1302: );