DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on FND_API

Line 629: ' , p_init_msg_list => FND_API.g_TRUE '||

625: ' BEGIN '||
626: ' ENI_ITEMS_STAR_PKG.Update_Categories '||
627: ' ( '||
628: ' p_api_version => 1.0 '||
629: ' , p_init_msg_list => FND_API.g_TRUE '||
630: ' , p_category_id => :X_CATEGORY_ID '||
631: ' , p_structure_id => :X_STRUCTURE_ID '||
632: ' , x_return_status => :l_return_status '||
633: ' , x_msg_count => :l_msg_count '||

Line 639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

635: ' ); '||
636: ' END;'
637: USING IN X_CATEGORY_ID, IN X_STRUCTURE_ID, OUT l_return_Status, OUT l_msg_count, OUT l_msg_data;
638:
639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);

Line 642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

638:
639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);
644: APP_EXCEPTION.Raise_Exception;
645: END IF;
646:

Line 972: l_return_status := FND_API.G_RET_STS_SUCCESS;

968: AND CONCATENATED_SEGMENTS = cp_concatenated_segs;*/
969:
970: begin
971:
972: l_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: -- **********************************
975: -- Get the correct structure based on the parameter passed in
976: -- upload_to_functional_area. If the later is passed as an argument,

Line 1143: P_INIT_MSG_LIST => FND_API.G_FALSE,

1139:
1140: -- Create a Category record
1141: INV_ITEM_CATEGORY_PUB.Create_Category (
1142: P_API_VERSION => 1.0,
1143: P_INIT_MSG_LIST => FND_API.G_FALSE,
1144: P_COMMIT => FND_API.G_FALSE,
1145: X_RETURN_STATUS => l_return_status ,
1146: X_ERRORCODE => l_errorcode,
1147: X_MSG_COUNT => l_msg_count ,

Line 1144: P_COMMIT => FND_API.G_FALSE,

1140: -- Create a Category record
1141: INV_ITEM_CATEGORY_PUB.Create_Category (
1142: P_API_VERSION => 1.0,
1143: P_INIT_MSG_LIST => FND_API.G_FALSE,
1144: P_COMMIT => FND_API.G_FALSE,
1145: X_RETURN_STATUS => l_return_status ,
1146: X_ERRORCODE => l_errorcode,
1147: X_MSG_COUNT => l_msg_count ,
1148: X_MSG_DATA => l_msg_data ,

Line 1181: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

1177: THEN
1178: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1179: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1180: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');
1181: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183:
1184:
1185: l_category_rec.CATEGORY_ID := l_category_id ;

Line 1189: P_INIT_MSG_LIST => FND_API.G_FALSE,

1185: l_category_rec.CATEGORY_ID := l_category_id ;
1186:
1187: INV_ITEM_CATEGORY_PUB.Update_Category (
1188: P_API_VERSION => 1.0,
1189: P_INIT_MSG_LIST => FND_API.G_FALSE,
1190: P_COMMIT => FND_API.G_FALSE,
1191: X_RETURN_STATUS => l_return_status,
1192: X_ERRORCODE => l_errorcode,
1193: X_MSG_COUNT => l_msg_count,

Line 1190: P_COMMIT => FND_API.G_FALSE,

1186:
1187: INV_ITEM_CATEGORY_PUB.Update_Category (
1188: P_API_VERSION => 1.0,
1189: P_INIT_MSG_LIST => FND_API.G_FALSE,
1190: P_COMMIT => FND_API.G_FALSE,
1191: X_RETURN_STATUS => l_return_status,
1192: X_ERRORCODE => l_errorcode,
1193: X_MSG_COUNT => l_msg_count,
1194: X_MSG_DATA => l_msg_data,

Line 1198: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1194: X_MSG_DATA => l_msg_data,
1195: P_CATEGORY_REC => l_category_rec );
1196:
1197: END IF;
1198: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1199: THEN
1200: FND_MSG_PUB.COUNT_AND_GET (
1201: p_encoded => 'F'
1202: , p_count => l_msg_count