DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.add;

137: IS
138: BEGIN
139: IF p_price_list_line_rec.list_header_id IS NULL OR p_price_list_line_rec.list_header_id = FND_API.G_MISS_NUM THEN
140: FND_MESSAGE.set_name('OZF', 'OZF_NO_PRIC_LIST');
141: FND_MSG_PUB.add;
142: RAISE FND_API.g_exc_error;
143: END IF;
144: END validate_price_list;
145:

Line 237: FND_MSG_PUB.initialize;

233:
234: SAVEPOINT process_price_list;
235:
236: IF FND_API.to_boolean(p_init_msg_list) THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:
240: IF NOT FND_API.compatible_api_call
241: (

Line 259: FND_MSG_PUB.ADD;

255: /* IF p_price_list_rec.operation <> QP_GLOBALS.G_OPR_CREATE THEN
256: IF AMS_ACCESS_PVT.check_update_access(p_price_list_rec.list_header_id, 'PRIC',l_resource_id,'USER') NOT IN ('F','R') THEN
257: FND_MESSAGE.SET_NAME('OZF','OZF_EVO_NO_UPDATE_ACCESS');
258: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
259: FND_MSG_PUB.ADD;
260: x_error_source := 'H';
261: RAISE FND_API.g_exc_error;
262: END IF;
263: END IF; */

Line 271: FND_MSG_PUB.ADD;

267: CLOSE cur_get_status_code;
268:
269: IF l_existing_status_code IN ('CANCELLED') THEN
270: FND_MESSAGE.SET_NAME('OZF','OZF_PRIC_NO_CHANGES_ALLOWED');
271: FND_MSG_PUB.ADD;
272: x_error_source := 'H';
273: RAISE FND_API.g_exc_error;
274: END IF;
275:

Line 297: FND_MSG_PUB.add;

293:
294: IF l_price_list_rec.global_flag = 'Y' THEN
295: IF p_price_list_rec.org_id IS NOT NULL AND p_price_list_rec.org_id <> fnd_api.g_miss_num THEN
296: FND_MESSAGE.set_name('OZF', 'OZF_CLEAR_OU');
297: FND_MSG_PUB.add;
298: RAISE FND_API.g_exc_error;
299: ELSE
300: l_price_list_rec.org_id := NULL; -- global offer does need org id
301: END IF;

Line 335: FND_MSG_PUB.add;

331: AND l_price_list_rec.end_date_active <> FND_API.G_MISS_DATE
332: THEN
333: IF l_price_list_rec.start_date_active > l_price_list_rec.end_date_active THEN
334: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_START_AFTER_END');
335: FND_MSG_PUB.add;
336: RAISE FND_API.g_exc_error;
337: END IF;
338: END IF;
339: -- ended 2452540

Line 392: FND_MSG_PUB.add;

388: AND p_price_list_line_tbl(i).end_date_active <> FND_API.G_MISS_DATE
389: THEN
390: IF p_price_list_line_tbl(i).start_date_active > p_price_list_line_tbl(i).end_date_active THEN
391: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_START_AFTER_END');
392: FND_MSG_PUB.add;
393: RAISE FND_API.g_exc_error;
394: END IF;
395: END IF;
396: -- end bug 2452540

Line 602: FND_MSG_PUB.ADD;

598: l_msg_data := oe_msg_pub.get( p_msg_index => i,
599: p_encoded => 'F' );
600: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
601: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
602: FND_MSG_PUB.ADD;
603: END LOOP;
604: RAISE FND_API.g_exc_error;
605:
606: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 613: FND_MSG_PUB.ADD;

609: p_encoded => 'F' );
610:
611: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
612: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
613: FND_MSG_PUB.ADD;
614: END LOOP;
615: RAISE FND_API.g_exc_unexpected_error;
616: END IF;
617:

Line 827: FND_MSG_PUB.Add;

823: IF l_return_status <> FND_API.g_ret_sts_success THEN
824: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
825: FND_MESSAGE.SET_NAME('OZF', 'OZF_NOTE_ERROR');
826: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.g_exc_unexpected_error;
829: ELSE
830: FND_MESSAGE.Set_Name('OZF', 'OZF_NOTE_ERROR');
831: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);

Line 832: FND_MSG_PUB.Add;

828: RAISE FND_API.g_exc_unexpected_error;
829: ELSE
830: FND_MESSAGE.Set_Name('OZF', 'OZF_NOTE_ERROR');
831: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.g_exc_error;
834: END IF;
835: END IF;
836: ELSE

Line 861: FND_MSG_PUB.Add;

857: IF l_return_status <> FND_API.g_ret_sts_success THEN
858: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
859: FND_MESSAGE.SET_NAME('OZF', 'OZF_NOTE_ERROR');
860: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
861: FND_MSG_PUB.Add;
862: RAISE FND_API.g_exc_unexpected_error;
863: ELSE
864: FND_MESSAGE.Set_Name('OZF', 'OZF_NOTE_ERROR');
865: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);

Line 866: FND_MSG_PUB.Add;

862: RAISE FND_API.g_exc_unexpected_error;
863: ELSE
864: FND_MESSAGE.Set_Name('OZF', 'OZF_NOTE_ERROR');
865: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
866: FND_MSG_PUB.Add;
867: RAISE FND_API.g_exc_error;
868: END IF;
869: END IF;
870: END IF;

Line 881: FND_MSG_PUB.Count_AND_Get

877: IF p_commit = FND_API.g_true then
878: COMMIT WORK;
879: END IF;
880:
881: FND_MSG_PUB.Count_AND_Get
882: ( p_count => x_msg_count,
883: p_data => x_msg_data,
884: p_encoded => FND_API.G_FALSE );
885:

Line 890: FND_MSG_PUB.Count_AND_Get

886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: x_return_status := FND_API.g_ret_sts_error ;
889: ROLLBACK TO process_price_list;
890: FND_MSG_PUB.Count_AND_Get
891: ( p_count => x_msg_count,
892: p_data => x_msg_data,
893: p_encoded => FND_API.G_FALSE
894: );

Line 898: FND_MSG_PUB.Count_AND_Get

894: );
895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
896: x_return_status := FND_API.g_ret_sts_unexp_error ;
897: ROLLBACK TO process_price_list;
898: FND_MSG_PUB.Count_AND_Get
899: ( p_count => x_msg_count,
900: p_data => x_msg_data,
901: p_encoded => FND_API.G_FALSE
902: );

Line 907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

903: WHEN OTHERS THEN
904: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
905: x_error_source := 'H';
906: ROLLBACK TO process_price_list;
907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get

Line 909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

905: x_error_source := 'H';
906: ROLLBACK TO process_price_list;
907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,

Line 911: FND_MSG_PUB.Count_AND_Get

907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE
915: );

Line 973: FND_MSG_PUB.initialize;

969: BEGIN
970: SAVEPOINT move_segments;
971:
972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: IF NOT FND_API.compatible_api_call
977: (

Line 1045: FND_MSG_PUB.ADD;

1041: p_encoded => 'F' );
1042:
1043: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
1044: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
1045: FND_MSG_PUB.ADD;
1046: END LOOP;
1047: RAISE FND_API.g_exc_error;
1048:
1049: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1056: FND_MSG_PUB.ADD;

1052: p_encoded => 'F' );
1053:
1054: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
1055: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
1056: FND_MSG_PUB.ADD;
1057: END LOOP;
1058: RAISE FND_API.g_exc_unexpected_error;
1059: END IF;
1060:

Line 1063: FND_MSG_PUB.Count_AND_Get

1059: END IF;
1060:
1061: END IF;
1062:
1063: FND_MSG_PUB.Count_AND_Get
1064: ( p_count => x_msg_count,
1065: p_data => x_msg_data,
1066: p_encoded => FND_API.G_FALSE );
1067:

Line 1072: FND_MSG_PUB.Count_AND_Get

1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: x_return_status := FND_API.g_ret_sts_error ;
1071: ROLLBACK TO move_segments;
1072: FND_MSG_PUB.Count_AND_Get
1073: ( p_count => x_msg_count,
1074: p_data => x_msg_data,
1075: p_encoded => FND_API.G_FALSE
1076: );

Line 1080: FND_MSG_PUB.Count_AND_Get

1076: );
1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1078: x_return_status := FND_API.g_ret_sts_unexp_error ;
1079: ROLLBACK TO move_segments;
1080: FND_MSG_PUB.Count_AND_Get
1081: ( p_count => x_msg_count,
1082: p_data => x_msg_data,
1083: p_encoded => FND_API.G_FALSE
1084: );

Line 1088: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1084: );
1085: WHEN OTHERS THEN
1086: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1087: ROLLBACK TO move_segments;
1088: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1089: THEN
1090: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1091: END IF;
1092: FND_MSG_PUB.Count_AND_Get

Line 1090: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1086: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1087: ROLLBACK TO move_segments;
1088: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1089: THEN
1090: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1091: END IF;
1092: FND_MSG_PUB.Count_AND_Get
1093: ( p_count => x_msg_count,
1094: p_data => x_msg_data,

Line 1092: FND_MSG_PUB.Count_AND_Get

1088: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1089: THEN
1090: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1091: END IF;
1092: FND_MSG_PUB.Count_AND_Get
1093: ( p_count => x_msg_count,
1094: p_data => x_msg_data,
1095: p_encoded => FND_API.G_FALSE
1096: );

Line 1252: FND_MSG_PUB.initialize;

1248:
1249: SAVEPOINT add_inventory_item;
1250:
1251: IF FND_API.to_boolean(p_init_msg_list) THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: IF NOT FND_API.compatible_api_call(l_api_version,
1256: p_api_version,

Line 1724: FND_MSG_PUB.ADD;

1720: x_msg_data := oe_msg_pub.get( p_msg_index => i,
1721: p_encoded => 'F' );
1722: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
1723: FND_MESSAGE.SET_TOKEN('ERROR_MSG',x_msg_data);
1724: FND_MSG_PUB.ADD;
1725: END LOOP;
1726: RAISE FND_API.g_exc_error;
1727:
1728: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1735: FND_MSG_PUB.ADD;

1731: p_encoded => 'F' );
1732:
1733: FND_MESSAGE.SET_NAME('OZF','OZF_QP_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ERROR_MSG',x_msg_data);
1735: FND_MSG_PUB.ADD;
1736: END LOOP;
1737: RAISE FND_API.g_exc_unexpected_error;
1738: END IF;
1739: END LOOP;

Line 1745: FND_MSG_PUB.Count_AND_Get

1741: EXCEPTION
1742: WHEN FND_API.G_EXC_ERROR THEN
1743: x_return_status := FND_API.g_ret_sts_error ;
1744: -- ROLLBACK TO add_inventory_item;
1745: FND_MSG_PUB.Count_AND_Get
1746: ( p_count => x_msg_count,
1747: p_data => x_msg_data,
1748: p_encoded => FND_API.G_FALSE
1749: );

Line 1753: FND_MSG_PUB.Count_AND_Get

1749: );
1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1751: x_return_status := FND_API.g_ret_sts_unexp_error ;
1752: -- ROLLBACK TO add_inventory_item;
1753: FND_MSG_PUB.Count_AND_Get
1754: ( p_count => x_msg_count,
1755: p_data => x_msg_data,
1756: p_encoded => FND_API.G_FALSE
1757: );

Line 1761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1757: );
1758: WHEN OTHERS THEN
1759: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1760: -- ROLLBACK TO add_inventory_item;
1761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1762: THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1764: END IF;
1765: FND_MSG_PUB.Count_AND_Get

Line 1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1759: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1760: -- ROLLBACK TO add_inventory_item;
1761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1762: THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1764: END IF;
1765: FND_MSG_PUB.Count_AND_Get
1766: ( p_count => x_msg_count,
1767: p_data => x_msg_data,

Line 1765: FND_MSG_PUB.Count_AND_Get

1761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1762: THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1764: END IF;
1765: FND_MSG_PUB.Count_AND_Get
1766: ( p_count => x_msg_count,
1767: p_data => x_msg_data,
1768: p_encoded => FND_API.G_FALSE
1769: );