eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_CATEGORY_PVT dependencies on FND_API

Line 49: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

45:
46: PROCEDURE Create_Category_Assignment
47: (
48: p_api_version IN NUMBER
49: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
50: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
51: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATEGORY_PVT.g_VALIDATE_ALL
52: , p_inventory_item_id IN NUMBER
53: , p_organization_id IN NUMBER

Line 50: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

46: PROCEDURE Create_Category_Assignment
47: (
48: p_api_version IN NUMBER
49: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
50: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
51: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATEGORY_PVT.g_VALIDATE_ALL
52: , p_inventory_item_id IN NUMBER
53: , p_organization_id IN NUMBER
54: , p_category_set_id IN NUMBER

Line 140: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

136:
137: --dbms_output.put_line('Enter INV_ITEM_CATEGORY_PVT.Create_Category_Assignment');
138:
139: -- Check for call compatibility
140: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
141: l_api_name, G_PKG_NAME)
142: THEN
143: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
144: END IF;

Line 143: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

139: -- Check for call compatibility
140: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
141: l_api_name, G_PKG_NAME)
142: THEN
143: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: --dbms_output.put_line('Before Initialize message list.');
147:

Line 149: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

145:
146: --dbms_output.put_line('Before Initialize message list.');
147:
148: -- Initialize message list
149: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
150: INV_ITEM_MSG.Initialize;
151: END IF;
152:
153: -- Define message context

Line 158: x_return_status := FND_API.g_RET_STS_SUCCESS;

154: Mctx.Package_Name := G_PKG_NAME;
155: Mctx.Procedure_Name := l_api_name;
156:
157: -- Initialize API return status to success
158: x_return_status := FND_API.g_RET_STS_SUCCESS;
159:
160: -- Check for NULL parameter values
161:
162: /* IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR

Line 162: /* IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR

158: x_return_status := FND_API.g_RET_STS_SUCCESS;
159:
160: -- Check for NULL parameter values
161:
162: /* IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
163: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
164: */
165:
166: --dbms_output.put_line('Before IS NULL ; x_return_status = ' || x_return_status);

Line 163: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )

159:
160: -- Check for NULL parameter values
161:
162: /* IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
163: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
164: */
165:
166: --dbms_output.put_line('Before IS NULL ; x_return_status = ' || x_return_status);
167:

Line 177: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

173: ( p_Msg_Name => 'INV_INVALID_ARG_NULL_VALUE'
174: , p_transaction_id => p_transaction_id
175: );
176:
177: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: IF (l_debug = 1) THEN
181: INV_ITEM_MSG.Debug(Mctx, 'Validate item/org Ids');

Line 197: RAISE FND_API.g_EXC_ERROR;

193: INV_ITEM_MSG.Add_Message
194: ( p_Msg_Name => 'INV_ORGITEM_ID_NOT_FOUND'
195: , p_transaction_id => p_transaction_id
196: );
197: RAISE FND_API.g_EXC_ERROR;
198: END IF;
199:
200: --6355354:Unapproved item can have categories assigned.
201: --Bug: 4046709

Line 213: RAISE FND_API.g_EXC_ERROR;

209: INV_ITEM_MSG.Add_Message
210: (p_Msg_Name => 'INV_IOI_NIR_NOT_COMPLETE'
211: ,p_transaction_id => p_transaction_id);
212:
213: RAISE FND_API.g_EXC_ERROR;
214: END IF;
215: END IF;
216:
217:

Line 242: RAISE FND_API.g_EXC_ERROR;

238: INV_ITEM_MSG.Add_Message
239: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
240: , p_transaction_id => p_transaction_id
241: );
242: RAISE FND_API.g_EXC_ERROR;
243: END IF;
244: CLOSE category_sets_csr;
245:
246: IF (l_debug = 1) THEN

Line 263: RAISE FND_API.g_EXC_ERROR;

259: INV_ITEM_MSG.Add_Message
260: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
261: , p_transaction_id => p_transaction_id
262: );
263: RAISE FND_API.g_EXC_ERROR;
264: END IF;
265: CLOSE category_exists_csr;
266:
267: --dbms_output.put_line('After OPEN category_exists_csr ; x_return_status = ' || x_return_status);

Line 283: RAISE FND_API.g_EXC_ERROR;

279: INV_ITEM_MSG.Add_Message
280: ( p_Msg_Name => 'INV_INVALID_CATEGORY_STRUCTURE'
281: , p_transaction_id => p_transaction_id
282: );
283: RAISE FND_API.g_EXC_ERROR;
284: END IF;
285:
286: -- If Category set control level is master and organization being processed is not master then error
287:

Line 300: RAISE FND_API.g_EXC_ERROR;

296: INV_ITEM_MSG.Add_Message
297: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
298: , p_transaction_id => p_transaction_id
299: );
300: RAISE FND_API.g_EXC_ERROR;
301: END IF;
302:
303: -- End If Category set control level is master
304:

Line 325: RAISE FND_API.g_EXC_ERROR;

321: INV_ITEM_MSG.Add_Message
322: ( p_Msg_Name => 'INV_CATEGORY_NOT_IN_VALID_SET'
323: , p_transaction_id => p_transaction_id
324: );
325: RAISE FND_API.g_EXC_ERROR;
326: END IF;
327: CLOSE category_set_valid_cats_csr;
328: END IF;
329: --Bug: 2996160 Added function Is_Category_Leafnode,code to validate leaf node

Line 342: RAISE FND_API.g_EXC_ERROR;

338: INV_ITEM_MSG.Add_Message
339: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_LEAF_ONLY'
340: , p_transaction_id => p_transaction_id
341: );
342: RAISE FND_API.g_EXC_ERROR;
343: END IF;
344:
345: --Bug: 2996160 Ends here
346:

Line 388: RAISE FND_API.g_EXC_ERROR;

384: INV_ITEM_MSG.Add_Message
385: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_NO_MULT'
386: , p_transaction_id => p_transaction_id
387: );
388: RAISE FND_API.g_EXC_ERROR;
389: END IF;
390: --ELSIF (l_the_cat_assign_count = 0) THEN
391: -- TODO:
392: -- Check if Master Item category assignment permits the Org Item assignment.

Line 482: IF (FND_API.To_Boolean (p_commit)) THEN

478: );
479: END IF;
480:
481: -- Standard check of p_commit
482: IF (FND_API.To_Boolean (p_commit)) THEN
483:
484: IF (l_debug = 1) THEN
485: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
486: END IF;

Line 498: WHEN FND_API.g_EXC_ERROR THEN

494: );
495:
496: EXCEPTION
497:
498: WHEN FND_API.g_EXC_ERROR THEN
499: ROLLBACK TO Create_Category_Assignment_PVT;
500:
501: x_return_status := FND_API.g_RET_STS_ERROR;
502: INV_ITEM_MSG.Count_And_Get

Line 501: x_return_status := FND_API.g_RET_STS_ERROR;

497:
498: WHEN FND_API.g_EXC_ERROR THEN
499: ROLLBACK TO Create_Category_Assignment_PVT;
500:
501: x_return_status := FND_API.g_RET_STS_ERROR;
502: INV_ITEM_MSG.Count_And_Get
503: ( p_count => x_msg_count
504: , p_data => x_msg_data
505: );

Line 507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

503: ( p_count => x_msg_count
504: , p_data => x_msg_data
505: );
506:
507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
508: ROLLBACK TO Create_Category_Assignment_PVT;
509:
510: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
511: INV_ITEM_MSG.Count_And_Get

Line 510: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

506:
507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
508: ROLLBACK TO Create_Category_Assignment_PVT;
509:
510: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
511: INV_ITEM_MSG.Count_And_Get
512: ( p_count => x_msg_count
513: , p_data => x_msg_data
514: );

Line 519: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

515:
516: WHEN others THEN
517: ROLLBACK TO Create_Category_Assignment_PVT;
518:
519: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
520: --INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
521: INV_ITEM_MSG.Add_Message
522: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
523: , p_token1 => 'PKG_NAME'

Line 546: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

542:
543: PROCEDURE Delete_Category_Assignment
544: (
545: p_api_version IN NUMBER
546: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
547: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
548: , p_inventory_item_id IN NUMBER
549: , p_organization_id IN NUMBER
550: , p_category_set_id IN NUMBER

Line 547: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

543: PROCEDURE Delete_Category_Assignment
544: (
545: p_api_version IN NUMBER
546: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
547: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
548: , p_inventory_item_id IN NUMBER
549: , p_organization_id IN NUMBER
550: , p_category_set_id IN NUMBER
551: , p_category_id IN NUMBER

Line 634: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

630: -- Set savepoint
631: SAVEPOINT Delete_Category_Assignment_PVT;
632:
633: -- Check for call compatibility
634: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
635: l_api_name, G_PKG_NAME)
636: THEN
637: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
638: END IF;

Line 637: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

633: -- Check for call compatibility
634: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
635: l_api_name, G_PKG_NAME)
636: THEN
637: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: -- Initialize message list
641: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

Line 641: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

637: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: -- Initialize message list
641: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
642: INV_ITEM_MSG.Initialize;
643: END IF;
644:
645: -- Define message context

Line 650: x_return_status := FND_API.g_RET_STS_SUCCESS;

646: Mctx.Package_Name := G_PKG_NAME;
647: Mctx.Procedure_Name := l_api_name;
648:
649: -- Initialize API return status to success
650: x_return_status := FND_API.g_RET_STS_SUCCESS;
651:
652: --INV_ITEM_MSG.Debug(Mctx, 'NO VALIDATION IMPLEMENTED');
653: --INV_ITEM_MSG.Debug(Mctx, 'before DELETE FROM mtl_item_categories');
654:

Line 665: RAISE FND_API.g_EXC_ERROR;

661: INV_ITEM_MSG.Add_Message
662: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
663: , p_transaction_id => p_transaction_id
664: );
665: RAISE FND_API.g_EXC_ERROR;
666: ELSE
667: /* Bug 4046670 To check if he item belongs to a functional area for which the category set is mandatory before deletion - Anmurali */
668: /*Raise error if the category set is a mandatory category set for the functional area to which the item belongs */
669: INVIDSCS.CHECK_CAT_SET_MANDATORY(p_category_set_id,

Line 748: RAISE FND_API.g_EXC_ERROR;

744: INV_ITEM_MSG.Add_Message
745: ( p_Msg_Name => 'INV_DEL_MAND_CAT_SET'
746: , p_transaction_id => p_transaction_id
747: );
748: RAISE FND_API.g_EXC_ERROR;
749: END IF;
750: END IF;
751: -- End of bug fix for Bug 4046670 - Anmurali
752: END IF;

Line 765: RAISE FND_API.g_EXC_ERROR;

761: INV_ITEM_MSG.Add_Message
762: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
763: , p_transaction_id => p_transaction_id
764: );
765: RAISE FND_API.g_EXC_ERROR;
766: END IF;
767: CLOSE category_exists_csr;
768:
769: SELECT MASTER_ORGANIZATION_ID

Line 780: RAISE FND_API.g_EXC_ERROR;

776: INV_ITEM_MSG.Add_Message
777: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
778: , p_transaction_id => p_transaction_id
779: );
780: RAISE FND_API.g_EXC_ERROR;
781: END IF;
782:
783: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
784: --Bug: 3561206 Added an index for performance improvement

Line 818: IF (FND_API.To_Boolean (p_commit)) THEN

814: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');
815: END IF;
816:
817: -- Standard check of p_commit
818: IF (FND_API.To_Boolean (p_commit)) THEN
819: COMMIT WORK;
820: END IF;
821:
822: INV_ITEM_MSG.Count_And_Get

Line 829: WHEN FND_API.g_EXC_ERROR THEN

825: );
826:
827: EXCEPTION
828:
829: WHEN FND_API.g_EXC_ERROR THEN
830: ROLLBACK TO Delete_Category_Assignment_PVT;
831: x_return_status := FND_API.g_RET_STS_ERROR;
832: INV_ITEM_MSG.Count_And_Get
833: ( p_count => x_msg_count

Line 831: x_return_status := FND_API.g_RET_STS_ERROR;

827: EXCEPTION
828:
829: WHEN FND_API.g_EXC_ERROR THEN
830: ROLLBACK TO Delete_Category_Assignment_PVT;
831: x_return_status := FND_API.g_RET_STS_ERROR;
832: INV_ITEM_MSG.Count_And_Get
833: ( p_count => x_msg_count
834: , p_data => x_msg_data
835: );

Line 837: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

833: ( p_count => x_msg_count
834: , p_data => x_msg_data
835: );
836:
837: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
838: ROLLBACK TO Delete_Category_Assignment_PVT;
839: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
840: INV_ITEM_MSG.Count_And_Get
841: ( p_count => x_msg_count

Line 839: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

835: );
836:
837: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
838: ROLLBACK TO Delete_Category_Assignment_PVT;
839: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
840: INV_ITEM_MSG.Count_And_Get
841: ( p_count => x_msg_count
842: , p_data => x_msg_data
843: );

Line 847: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

843: );
844:
845: WHEN others THEN
846: ROLLBACK TO Delete_Category_Assignment_PVT;
847: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
848:
849: --INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
850: INV_ITEM_MSG.Add_Message
851: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'

Line 954: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

950: -- API to create a valid Category in Category Sets for ENI Upgrade
951: ----------------------------------------------------------------------------
952: PROCEDURE Create_Valid_Category(
953: p_api_version IN NUMBER,
954: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
955: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
956: p_category_set_id IN NUMBER,
957: p_category_id IN NUMBER,
958: p_parent_category_id IN NUMBER,

Line 955: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

951: ----------------------------------------------------------------------------
952: PROCEDURE Create_Valid_Category(
953: p_api_version IN NUMBER,
954: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
955: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
956: p_category_set_id IN NUMBER,
957: p_category_id IN NUMBER,
958: p_parent_category_id IN NUMBER,
959: x_return_status OUT NOCOPY VARCHAR2,

Line 1001: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

997: -- API to update a valid Category for ENI Upgrade
998: ----------------------------------------------------------------------------
999: PROCEDURE Update_Valid_Category(
1000: p_api_version IN NUMBER,
1001: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1002: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1003: p_category_set_id IN NUMBER,
1004: p_category_id IN NUMBER,
1005: p_parent_category_id IN NUMBER,

Line 1002: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

998: ----------------------------------------------------------------------------
999: PROCEDURE Update_Valid_Category(
1000: p_api_version IN NUMBER,
1001: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1002: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1003: p_category_set_id IN NUMBER,
1004: p_category_id IN NUMBER,
1005: p_parent_category_id IN NUMBER,
1006: x_return_status OUT NOCOPY VARCHAR2,

Line 1115: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

1111: -- Set savepoint
1112: SAVEPOINT Update_Category_Assignment_PVT;
1113:
1114: -- Check for call compatibility
1115: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1116: l_api_name, G_PKG_NAME)
1117: THEN
1118: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1119: END IF;

Line 1118: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

1114: -- Check for call compatibility
1115: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1116: l_api_name, G_PKG_NAME)
1117: THEN
1118: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120:
1121: -- Initialize message list
1122: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

Line 1122: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

1118: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120:
1121: -- Initialize message list
1122: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
1123: INV_ITEM_MSG.Initialize;
1124: END IF;
1125:
1126: -- Define message context

Line 1131: x_return_status := FND_API.g_RET_STS_SUCCESS;

1127: Mctx.Package_Name := G_PKG_NAME;
1128: Mctx.Procedure_Name := l_api_name;
1129:
1130: -- Initialize API return status to success
1131: x_return_status := FND_API.g_RET_STS_SUCCESS;
1132:
1133: --* Checking whether Category Set Id is valid or not
1134: IF (l_debug = 1) THEN
1135: INV_ITEM_MSG.Debug(Mctx, 'Checking whether Category Set Id is valid or not');

Line 1150: RAISE FND_API.g_EXC_ERROR;

1146: INV_ITEM_MSG.Add_Message
1147: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
1148: , p_transaction_id => p_transaction_id
1149: );
1150: RAISE FND_API.g_EXC_ERROR;
1151: END IF;
1152: CLOSE category_sets_csr;
1153:
1154: --* Checking whether Category Assignment exists for old category id

Line 1168: RAISE FND_API.g_EXC_ERROR;

1164: INV_ITEM_MSG.Add_Message
1165: ( p_Msg_Name => 'INV_CAT_ASSGN_NOT_FOUND'
1166: , p_transaction_id => p_transaction_id
1167: );
1168: RAISE FND_API.g_EXC_ERROR;
1169: END IF;
1170:
1171: --* Checking whether New Category Id is valid or not
1172: IF (l_debug = 1) THEN

Line 1184: RAISE FND_API.g_EXC_ERROR;

1180: INV_ITEM_MSG.Add_Message
1181: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
1182: , p_transaction_id => p_transaction_id
1183: );
1184: RAISE FND_API.g_EXC_ERROR;
1185: END IF;
1186: CLOSE category_exists_csr;
1187:
1188: -- Category structure_id must be the same as structure_id defined in the Category Set.

Line 1197: RAISE FND_API.g_EXC_ERROR;

1193: INV_ITEM_MSG.Add_Message
1194: ( p_Msg_Name => 'INV_INVALID_CATEGORY_STRUCTURE'
1195: , p_transaction_id => p_transaction_id
1196: );
1197: RAISE FND_API.g_EXC_ERROR;
1198: END IF;
1199:
1200: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
1201: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.

Line 1217: RAISE FND_API.g_EXC_ERROR;

1213: INV_ITEM_MSG.Add_Message
1214: ( p_Msg_Name => 'INV_CATEGORY_NOT_IN_VALID_SET'
1215: , p_transaction_id => p_transaction_id
1216: );
1217: RAISE FND_API.g_EXC_ERROR;
1218: END IF;
1219: CLOSE category_set_valid_cats_csr;
1220: END IF;
1221:

Line 1238: RAISE FND_API.g_EXC_ERROR;

1234: INV_ITEM_MSG.Add_Message
1235: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
1236: , p_transaction_id => p_transaction_id
1237: );
1238: RAISE FND_API.g_EXC_ERROR;
1239: END IF;
1240:
1241: /* Commented for Bug 4609655 - Checking not required
1242: --* checking for duplicate records

Line 1259: RAISE FND_API.g_EXC_ERROR;

1255: INV_ITEM_MSG.Add_Message
1256: ( p_Msg_Name => 'INV_CAT_ASSGN_ALREADY_EXISTS'
1257: , p_transaction_id => p_transaction_id
1258: );
1259: RAISE FND_API.g_EXC_ERROR;
1260: END IF;
1261: End of Commenting for Bug 4609655 */
1262:
1263: --* Validating if new category is leafnode or not

Line 1276: RAISE FND_API.g_EXC_ERROR;

1272: INV_ITEM_MSG.Add_Message
1273: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_LEAF_ONLY'
1274: , p_transaction_id => p_transaction_id
1275: );
1276: RAISE FND_API.g_EXC_ERROR;
1277: END IF;
1278:
1279:
1280: --* Updating Master Org or Master Org + Child Orgs depending on Control Level

Line 1318: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1314: ,x_return_status => l_return_status
1315: ,x_msg_count => l_msg_count
1316: ,x_msg_data => l_msg_data);
1317:
1318: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1319: RAISE Processing_Error;
1320: END IF;
1321: --Bug 6008273
1322:

Line 1352: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1348: ,x_return_status => l_return_status
1349: ,x_msg_count => l_msg_count
1350: ,x_msg_data => l_msg_data);
1351:
1352: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1353: RAISE Processing_Error;
1354: END IF;
1355: --Bug 6008273
1356:

Line 1364: IF (FND_API.To_Boolean (p_commit)) THEN

1360: INV_ITEM_MSG.Debug(Mctx, 'after update FROM mtl_item_categories');
1361: END IF;
1362:
1363: -- Standard check of p_commit
1364: IF (FND_API.To_Boolean (p_commit)) THEN
1365: COMMIT WORK;
1366: END IF;
1367:
1368: INV_ITEM_MSG.Count_And_Get

Line 1375: WHEN FND_API.g_EXC_ERROR THEN

1371: );
1372:
1373: EXCEPTION
1374:
1375: WHEN FND_API.g_EXC_ERROR THEN
1376: ROLLBACK TO Update_Category_Assignment_PVT;
1377: x_return_status := FND_API.g_RET_STS_ERROR;
1378: INV_ITEM_MSG.Count_And_Get
1379: ( p_count => x_msg_count

Line 1377: x_return_status := FND_API.g_RET_STS_ERROR;

1373: EXCEPTION
1374:
1375: WHEN FND_API.g_EXC_ERROR THEN
1376: ROLLBACK TO Update_Category_Assignment_PVT;
1377: x_return_status := FND_API.g_RET_STS_ERROR;
1378: INV_ITEM_MSG.Count_And_Get
1379: ( p_count => x_msg_count
1380: , p_data => x_msg_data
1381: );

Line 1383: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1379: ( p_count => x_msg_count
1380: , p_data => x_msg_data
1381: );
1382:
1383: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1384: ROLLBACK TO Update_Category_Assignment_PVT;
1385: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1386: INV_ITEM_MSG.Count_And_Get
1387: ( p_count => x_msg_count

Line 1385: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1381: );
1382:
1383: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1384: ROLLBACK TO Update_Category_Assignment_PVT;
1385: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1386: INV_ITEM_MSG.Count_And_Get
1387: ( p_count => x_msg_count
1388: , p_data => x_msg_data
1389: );

Line 1401: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1397: );
1398:
1399: WHEN others THEN
1400: ROLLBACK TO Update_Category_Assignment_PVT;
1401: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1402:
1403: INV_ITEM_MSG.Add_Message
1404: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
1405: , p_token1 => 'PKG_NAME'