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 141: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

Line 144: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

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

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

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

Line 159: x_return_status := FND_API.g_RET_STS_SUCCESS;

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

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

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

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

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

Line 178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

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

Line 198: RAISE FND_API.g_EXC_ERROR;

194: INV_ITEM_MSG.Add_Message
195: ( p_Msg_Name => 'INV_ORGITEM_ID_NOT_FOUND'
196: , p_transaction_id => p_transaction_id
197: );
198: RAISE FND_API.g_EXC_ERROR;
199: END IF;
200:
201: /* Bug 8208540 :Added the below query, check if the catalog is a GPC catalog or not*/
202: select Decode(Count(1), 0,'N','Y')

Line 223: RAISE FND_API.g_EXC_ERROR;

219: INV_ITEM_MSG.Add_Message
220: (p_Msg_Name => 'INV_IOI_NIR_NOT_COMPLETE'
221: ,p_transaction_id => p_transaction_id);
222:
223: RAISE FND_API.g_EXC_ERROR;
224: END IF;
225: END IF;
226:
227:

Line 252: RAISE FND_API.g_EXC_ERROR;

248: INV_ITEM_MSG.Add_Message
249: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
250: , p_transaction_id => p_transaction_id
251: );
252: RAISE FND_API.g_EXC_ERROR;
253: END IF;
254: CLOSE category_sets_csr;
255:
256: IF (l_debug = 1) THEN

Line 273: RAISE FND_API.g_EXC_ERROR;

269: INV_ITEM_MSG.Add_Message
270: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
271: , p_transaction_id => p_transaction_id
272: );
273: RAISE FND_API.g_EXC_ERROR;
274: END IF;
275: CLOSE category_exists_csr;
276:
277: --dbms_output.put_line('After OPEN category_exists_csr ; x_return_status = ' || x_return_status);

Line 293: RAISE FND_API.g_EXC_ERROR;

289: INV_ITEM_MSG.Add_Message
290: ( p_Msg_Name => 'INV_INVALID_CATEGORY_STRUCTURE'
291: , p_transaction_id => p_transaction_id
292: );
293: RAISE FND_API.g_EXC_ERROR;
294: END IF;
295:
296: -- If Category set control level is master and organization being processed is not master then error
297:

Line 310: RAISE FND_API.g_EXC_ERROR;

306: INV_ITEM_MSG.Add_Message
307: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
308: , p_transaction_id => p_transaction_id
309: );
310: RAISE FND_API.g_EXC_ERROR;
311: END IF;
312:
313: -- End If Category set control level is master
314:

Line 335: RAISE FND_API.g_EXC_ERROR;

331: INV_ITEM_MSG.Add_Message
332: ( p_Msg_Name => 'INV_CATEGORY_NOT_IN_VALID_SET'
333: , p_transaction_id => p_transaction_id
334: );
335: RAISE FND_API.g_EXC_ERROR;
336: END IF;
337: CLOSE category_set_valid_cats_csr;
338: END IF;
339: --Bug: 2996160 Added function Is_Category_Leafnode,code to validate leaf node

Line 352: RAISE FND_API.g_EXC_ERROR;

348: INV_ITEM_MSG.Add_Message
349: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_LEAF_ONLY'
350: , p_transaction_id => p_transaction_id
351: );
352: RAISE FND_API.g_EXC_ERROR;
353: END IF;
354:
355: --Bug: 2996160 Ends here
356:

Line 398: RAISE FND_API.g_EXC_ERROR;

394: INV_ITEM_MSG.Add_Message
395: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_NO_MULT'
396: , p_transaction_id => p_transaction_id
397: );
398: RAISE FND_API.g_EXC_ERROR;
399: END IF;
400: --ELSIF (l_the_cat_assign_count = 0) THEN
401: -- TODO:
402: -- Check if Master Item category assignment permits the Org Item assignment.

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

488: );
489: END IF;
490:
491: -- Standard check of p_commit
492: IF (FND_API.To_Boolean (p_commit)) THEN
493:
494: IF (l_debug = 1) THEN
495: INV_ITEM_MSG.Debug(Mctx, 'before COMMIT WORK');
496: END IF;

Line 508: WHEN FND_API.g_EXC_ERROR THEN

504: );
505:
506: EXCEPTION
507:
508: WHEN FND_API.g_EXC_ERROR THEN
509: ROLLBACK TO Create_Category_Assignment_PVT;
510:
511: x_return_status := FND_API.g_RET_STS_ERROR;
512: INV_ITEM_MSG.Count_And_Get

Line 511: x_return_status := FND_API.g_RET_STS_ERROR;

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

Line 517: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

513: ( p_count => x_msg_count
514: , p_data => x_msg_data
515: );
516:
517: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO Create_Category_Assignment_PVT;
519:
520: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
521: INV_ITEM_MSG.Count_And_Get

Line 520: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

516:
517: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO Create_Category_Assignment_PVT;
519:
520: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
521: INV_ITEM_MSG.Count_And_Get
522: ( p_count => x_msg_count
523: , p_data => x_msg_data
524: );

Line 529: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

525:
526: WHEN others THEN
527: ROLLBACK TO Create_Category_Assignment_PVT;
528:
529: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
530: --INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
531: INV_ITEM_MSG.Add_Message
532: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
533: , p_token1 => 'PKG_NAME'

Line 556: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

552:
553: PROCEDURE Delete_Category_Assignment
554: (
555: p_api_version IN NUMBER
556: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
558: , p_inventory_item_id IN NUMBER
559: , p_organization_id IN NUMBER
560: , p_category_set_id IN NUMBER

Line 557: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

553: PROCEDURE Delete_Category_Assignment
554: (
555: p_api_version IN NUMBER
556: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
558: , p_inventory_item_id IN NUMBER
559: , p_organization_id IN NUMBER
560: , p_category_set_id IN NUMBER
561: , p_category_id IN NUMBER

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

640: -- Set savepoint
641: SAVEPOINT Delete_Category_Assignment_PVT;
642:
643: -- Check for call compatibility
644: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
645: l_api_name, G_PKG_NAME)
646: THEN
647: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
648: END IF;

Line 647: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

643: -- Check for call compatibility
644: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
645: l_api_name, G_PKG_NAME)
646: THEN
647: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: -- Initialize message list
651: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

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

647: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: -- Initialize message list
651: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
652: INV_ITEM_MSG.Initialize;
653: END IF;
654:
655: -- Define message context

Line 660: x_return_status := FND_API.g_RET_STS_SUCCESS;

656: Mctx.Package_Name := G_PKG_NAME;
657: Mctx.Procedure_Name := l_api_name;
658:
659: -- Initialize API return status to success
660: x_return_status := FND_API.g_RET_STS_SUCCESS;
661:
662: --INV_ITEM_MSG.Debug(Mctx, 'NO VALIDATION IMPLEMENTED');
663: --INV_ITEM_MSG.Debug(Mctx, 'before DELETE FROM mtl_item_categories');
664:

Line 675: RAISE FND_API.g_EXC_ERROR;

671: INV_ITEM_MSG.Add_Message
672: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
673: , p_transaction_id => p_transaction_id
674: );
675: RAISE FND_API.g_EXC_ERROR;
676: ELSE
677: /* Bug 4046670 To check if he item belongs to a functional area for which the category set is mandatory before deletion - Anmurali */
678: /*Raise error if the category set is a mandatory category set for the functional area to which the item belongs */
679: INVIDSCS.CHECK_CAT_SET_MANDATORY(p_category_set_id,

Line 758: RAISE FND_API.g_EXC_ERROR;

754: INV_ITEM_MSG.Add_Message
755: ( p_Msg_Name => 'INV_DEL_MAND_CAT_SET'
756: , p_transaction_id => p_transaction_id
757: );
758: RAISE FND_API.g_EXC_ERROR;
759: END IF;
760: END IF;
761: -- End of bug fix for Bug 4046670 - Anmurali
762: END IF;

Line 775: RAISE FND_API.g_EXC_ERROR;

771: INV_ITEM_MSG.Add_Message
772: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
773: , p_transaction_id => p_transaction_id
774: );
775: RAISE FND_API.g_EXC_ERROR;
776: END IF;
777: CLOSE category_exists_csr;
778:
779: SELECT MASTER_ORGANIZATION_ID

Line 790: RAISE FND_API.g_EXC_ERROR;

786: INV_ITEM_MSG.Add_Message
787: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
788: , p_transaction_id => p_transaction_id
789: );
790: RAISE FND_API.g_EXC_ERROR;
791: END IF;
792:
793: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
794: --Bug: 3561206 Added an index for performance improvement

Line 822: RAISE FND_API.g_EXC_ERROR;

818: ( p_Msg_Name => 'INV_CAT_ASSGN_NOT_FOUND'
819: , p_transaction_id => p_transaction_id
820: );
821: --add 8310065 with base bug 8351807
822: RAISE FND_API.g_EXC_ERROR;
823: END IF;
824:
825: IF (l_debug = 1) THEN
826: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');

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

826: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');
827: END IF;
828:
829: -- Standard check of p_commit
830: IF (FND_API.To_Boolean (p_commit)) THEN
831: COMMIT WORK;
832: END IF;
833:
834: INV_ITEM_MSG.Count_And_Get

Line 841: WHEN FND_API.g_EXC_ERROR THEN

837: );
838:
839: EXCEPTION
840:
841: WHEN FND_API.g_EXC_ERROR THEN
842: ROLLBACK TO Delete_Category_Assignment_PVT;
843: x_return_status := FND_API.g_RET_STS_ERROR;
844: INV_ITEM_MSG.Count_And_Get
845: ( p_count => x_msg_count

Line 843: x_return_status := FND_API.g_RET_STS_ERROR;

839: EXCEPTION
840:
841: WHEN FND_API.g_EXC_ERROR THEN
842: ROLLBACK TO Delete_Category_Assignment_PVT;
843: x_return_status := FND_API.g_RET_STS_ERROR;
844: INV_ITEM_MSG.Count_And_Get
845: ( p_count => x_msg_count
846: , p_data => x_msg_data
847: );

Line 849: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

845: ( p_count => x_msg_count
846: , p_data => x_msg_data
847: );
848:
849: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
850: ROLLBACK TO Delete_Category_Assignment_PVT;
851: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
852: INV_ITEM_MSG.Count_And_Get
853: ( p_count => x_msg_count

Line 851: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

847: );
848:
849: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
850: ROLLBACK TO Delete_Category_Assignment_PVT;
851: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
852: INV_ITEM_MSG.Count_And_Get
853: ( p_count => x_msg_count
854: , p_data => x_msg_data
855: );

Line 859: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

855: );
856:
857: WHEN others THEN
858: ROLLBACK TO Delete_Category_Assignment_PVT;
859: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
860:
861: --INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
862: INV_ITEM_MSG.Add_Message
863: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'

Line 966: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

962: -- API to create a valid Category in Category Sets for ENI Upgrade
963: ----------------------------------------------------------------------------
964: PROCEDURE Create_Valid_Category(
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
967: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
968: p_category_set_id IN NUMBER,
969: p_category_id IN NUMBER,
970: p_parent_category_id IN NUMBER,

Line 967: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

963: ----------------------------------------------------------------------------
964: PROCEDURE Create_Valid_Category(
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
967: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
968: p_category_set_id IN NUMBER,
969: p_category_id IN NUMBER,
970: p_parent_category_id IN NUMBER,
971: x_return_status OUT NOCOPY VARCHAR2,

Line 1013: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1009: -- API to update a valid Category for ENI Upgrade
1010: ----------------------------------------------------------------------------
1011: PROCEDURE Update_Valid_Category(
1012: p_api_version IN NUMBER,
1013: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1014: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1015: p_category_set_id IN NUMBER,
1016: p_category_id IN NUMBER,
1017: p_parent_category_id IN NUMBER,

Line 1014: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1010: ----------------------------------------------------------------------------
1011: PROCEDURE Update_Valid_Category(
1012: p_api_version IN NUMBER,
1013: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1014: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1015: p_category_set_id IN NUMBER,
1016: p_category_id IN NUMBER,
1017: p_parent_category_id IN NUMBER,
1018: x_return_status OUT NOCOPY VARCHAR2,

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

1123: -- Set savepoint
1124: SAVEPOINT Update_Category_Assignment_PVT;
1125:
1126: -- Check for call compatibility
1127: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1128: l_api_name, G_PKG_NAME)
1129: THEN
1130: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1131: END IF;

Line 1130: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

1126: -- Check for call compatibility
1127: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1128: l_api_name, G_PKG_NAME)
1129: THEN
1130: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Initialize message list
1134: IF (FND_API.To_Boolean (p_init_msg_list)) THEN

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

1130: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Initialize message list
1134: IF (FND_API.To_Boolean (p_init_msg_list)) THEN
1135: INV_ITEM_MSG.Initialize;
1136: END IF;
1137:
1138: -- Define message context

Line 1143: x_return_status := FND_API.g_RET_STS_SUCCESS;

1139: Mctx.Package_Name := G_PKG_NAME;
1140: Mctx.Procedure_Name := l_api_name;
1141:
1142: -- Initialize API return status to success
1143: x_return_status := FND_API.g_RET_STS_SUCCESS;
1144:
1145: --* Checking whether Category Set Id is valid or not
1146: IF (l_debug = 1) THEN
1147: INV_ITEM_MSG.Debug(Mctx, 'Checking whether Category Set Id is valid or not');

Line 1162: RAISE FND_API.g_EXC_ERROR;

1158: INV_ITEM_MSG.Add_Message
1159: ( p_Msg_Name => 'INV_CATEGORY_SET_ID_NOT_FOUND'
1160: , p_transaction_id => p_transaction_id
1161: );
1162: RAISE FND_API.g_EXC_ERROR;
1163: END IF;
1164: CLOSE category_sets_csr;
1165:
1166: --* Checking whether Category Assignment exists for old category id

Line 1180: RAISE FND_API.g_EXC_ERROR;

1176: INV_ITEM_MSG.Add_Message
1177: ( p_Msg_Name => 'INV_CAT_ASSGN_NOT_FOUND'
1178: , p_transaction_id => p_transaction_id
1179: );
1180: RAISE FND_API.g_EXC_ERROR;
1181: END IF;
1182:
1183: --* Checking whether New Category Id is valid or not
1184: IF (l_debug = 1) THEN

Line 1196: RAISE FND_API.g_EXC_ERROR;

1192: INV_ITEM_MSG.Add_Message
1193: ( p_Msg_Name => 'INV_CATEGORY_ID_NOT_FOUND'
1194: , p_transaction_id => p_transaction_id
1195: );
1196: RAISE FND_API.g_EXC_ERROR;
1197: END IF;
1198: CLOSE category_exists_csr;
1199:
1200: -- Category structure_id must be the same as structure_id defined in the Category Set.

Line 1209: RAISE FND_API.g_EXC_ERROR;

1205: INV_ITEM_MSG.Add_Message
1206: ( p_Msg_Name => 'INV_INVALID_CATEGORY_STRUCTURE'
1207: , p_transaction_id => p_transaction_id
1208: );
1209: RAISE FND_API.g_EXC_ERROR;
1210: END IF;
1211:
1212: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
1213: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.

Line 1229: RAISE FND_API.g_EXC_ERROR;

1225: INV_ITEM_MSG.Add_Message
1226: ( p_Msg_Name => 'INV_CATEGORY_NOT_IN_VALID_SET'
1227: , p_transaction_id => p_transaction_id
1228: );
1229: RAISE FND_API.g_EXC_ERROR;
1230: END IF;
1231: CLOSE category_set_valid_cats_csr;
1232: END IF;
1233:

Line 1250: RAISE FND_API.g_EXC_ERROR;

1246: INV_ITEM_MSG.Add_Message
1247: ( p_Msg_Name => 'INV_CAT_CANNOT_CREATE_DELETE'
1248: , p_transaction_id => p_transaction_id
1249: );
1250: RAISE FND_API.g_EXC_ERROR;
1251: END IF;
1252:
1253: /* Commented for Bug 4609655 - Checking not required
1254: --* checking for duplicate records

Line 1271: RAISE FND_API.g_EXC_ERROR;

1267: INV_ITEM_MSG.Add_Message
1268: ( p_Msg_Name => 'INV_CAT_ASSGN_ALREADY_EXISTS'
1269: , p_transaction_id => p_transaction_id
1270: );
1271: RAISE FND_API.g_EXC_ERROR;
1272: END IF;
1273: End of Commenting for Bug 4609655 */
1274:
1275: --* Validating if new category is leafnode or not

Line 1288: RAISE FND_API.g_EXC_ERROR;

1284: INV_ITEM_MSG.Add_Message
1285: ( p_Msg_Name => 'INV_ITEM_CAT_ASSIGN_LEAF_ONLY'
1286: , p_transaction_id => p_transaction_id
1287: );
1288: RAISE FND_API.g_EXC_ERROR;
1289: END IF;
1290:
1291:
1292: --* Updating Master Org or Master Org + Child Orgs depending on Control Level

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

1344: ,x_return_status => l_return_status
1345: ,x_msg_count => l_msg_count
1346: ,x_msg_data => l_msg_data);
1347:
1348: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1349: RAISE Processing_Error;
1350: END IF;
1351: --Bug 6008273
1352:

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

1386: ,x_return_status => l_return_status
1387: ,x_msg_count => l_msg_count
1388: ,x_msg_data => l_msg_data);
1389:
1390: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1391: RAISE Processing_Error;
1392: END IF;
1393: --Bug 6008273
1394:

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

1398: INV_ITEM_MSG.Debug(Mctx, 'after update FROM mtl_item_categories');
1399: END IF;
1400:
1401: -- Standard check of p_commit
1402: IF (FND_API.To_Boolean (p_commit)) THEN
1403: COMMIT WORK;
1404: END IF;
1405:
1406: INV_ITEM_MSG.Count_And_Get

Line 1413: WHEN FND_API.g_EXC_ERROR THEN

1409: );
1410:
1411: EXCEPTION
1412:
1413: WHEN FND_API.g_EXC_ERROR THEN
1414: ROLLBACK TO Update_Category_Assignment_PVT;
1415: x_return_status := FND_API.g_RET_STS_ERROR;
1416: INV_ITEM_MSG.Count_And_Get
1417: ( p_count => x_msg_count

Line 1415: x_return_status := FND_API.g_RET_STS_ERROR;

1411: EXCEPTION
1412:
1413: WHEN FND_API.g_EXC_ERROR THEN
1414: ROLLBACK TO Update_Category_Assignment_PVT;
1415: x_return_status := FND_API.g_RET_STS_ERROR;
1416: INV_ITEM_MSG.Count_And_Get
1417: ( p_count => x_msg_count
1418: , p_data => x_msg_data
1419: );

Line 1421: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1417: ( p_count => x_msg_count
1418: , p_data => x_msg_data
1419: );
1420:
1421: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1422: ROLLBACK TO Update_Category_Assignment_PVT;
1423: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1424: INV_ITEM_MSG.Count_And_Get
1425: ( p_count => x_msg_count

Line 1423: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1419: );
1420:
1421: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1422: ROLLBACK TO Update_Category_Assignment_PVT;
1423: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1424: INV_ITEM_MSG.Count_And_Get
1425: ( p_count => x_msg_count
1426: , p_data => x_msg_data
1427: );

Line 1439: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1435: );
1436:
1437: WHEN others THEN
1438: ROLLBACK TO Update_Category_Assignment_PVT;
1439: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1440:
1441: INV_ITEM_MSG.Add_Message
1442: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
1443: , p_token1 => 'PKG_NAME'